IPTD-480
Ask NJEMS- natural language queries of NJEMS
Description
This project would pilot the use of Large Language Models (LLMs) to use natural language prompting to produce SQL queries that return data and execute data analysis. This will require pairing one or more LLMs tuned or trained in databases and SQL, with NJEMS database schemas and metadata in order to enable model outputs of figures, tables and possibly charts.
Problem Statement
Too much DEP data remains under-used. One obstacle to greater use has been the friction involved in learning to use a reporting tool or engaging with report experts.
Project Justification
Unlocking greater insights from existing data is likely to directly advance NJDEP goals. Constraints in personnel time and limited report building expertise remain a likely obstacle to rapid and iterative querying that leads to insight.
Estimated Transactions
None
Target Rollout Date
None
Target Rollout Date Reason
None
Activity
Show:
Shyam/Mike McCormack got access to CGI AI server to do work. Mike is putting together a list of what we need from CGI to transition remaining work to in-house development
CGI Pilot Completed. Further work on AskNJEMS will be done in-house.
Work Plan 187 signed 1/24/2025