IPTD-309
Automate Process to Transfer DSWM Data in Developing GIS Layers for EJ MAP
Description
The project involves solid waste data from NJEMS as well as other potential sources that host this data. As data is sorted, migration of solid waste data to NJEMS may be necessary. The project leads will work in coordination with IT staff to sort through the data. The process will result in accurate datasets that are automated and will not need further program coordination. The project deadline is 6/15/23 so that the work can be leveraged for the next round of EJMAP updates. The EJ solid waste GIS layer used in EJMAP is an existing layer. The process for generating this layer will be new, however. Other Division dataset and GIS layers may be generated, or older datasets may be updated depending on program desire. These datasets can be leveraged DEP-wide as seen fit as a program may find it useful. No PII will be in the datasets.
As of this note it is confirmed that an automated GIS layer exists for the solid waste facilities.
Report developed in Mike’s shop is just about done as of 8/15/23 EJ check -in.
Mike Matsko hosted a meeting 2/28.
Here is a summary of the discussion:
An auto-generated GIS layer to support EJ reviews is needed. A current layer exists but was manually created. The creation of the GIS layer currently happens annually. By having an auto generation process in place, this data can be more up to date for better decision making.
Currently the GIS layer is built from a combination of sources that include NJEMS and spreadsheets. The GIS layer consists of 249 Solid Waste facilities along with attributes for these facilities.
In order to be able to auto generate this layer, all data will need to be maintained in NJEMS
Next Steps:
Solid Waste team will begin entering the data that is managed in the spreadsheets into NJEMS
Seema, Sanjay, Mike G, and Kevin with identify and column changes that are needed for the GIS layer.
Once the columns are agreed upon, Seema will export the existing data and share with Mike M.
Mike M will begin work on a report to replicate the data and format of the GIS export. Assistance will be provided by Mike G and Kevin
Please let me know if I missed anything.
-Mike