Marine Shellfish Lease Data Conversion into NJEMS
Description
Convert historic Marine Shellfish Lease data into NJEMS
Problem Statement
The Shellfish Lease program needs to convert data from their old system and GIS into the NJEMS module that was built for them for managing their shellfish leases
Project Justification
DOIT enabled the shellfish lease program module in NJEMS at their request due to the existing system they were using was an old Excel system built by an intern and no one knew how to maintain or upgrade it to maintain its usability.
Estimated Transactions
1- 10 new leases per month, 2,285 current leases, 322 current lessees
Target Rollout Date
30 June 2023
Target Rollout Date Reason
None
Attachments
GISToNJEMSTables_Current_11032025.xlsx
Work Plan 207 - Marine Shellfish Data Conversion JADS Design_Cover Letter - Executed.pdf
Work Plan 207 - Marine Shellfish Data Conversion JAD & Design.pdf
it-project-sheet-published_jcn_babb.doc
RE_ Recap of Today's Marine Shellfish Call.msg
Name
Created at
Size
Actions
FILE
Work Plan 207 - Marine Shellfish Data Conversion JADS Design_Cover Letter - Executed.pdf
2025-10-23 12:09
262 KiB
Linked work items
relates to
IPTD-227
NJ Shellfish Leasing Dataset and Versioned Editing
Active
Activity
Show:
Create issue
Active
Add watchers
Details
Sponsoring Leadership Area
Fish and Wildlife
Sponsoring Leadership Area's Priority
AP-5
Program Area Lead(s)
Jeff Normant
DOIT technical lead(s)
Karen Anselmo
All Involved Leadership Areas
Div. of Information TechnologyFish and Wildlife
Created: 12 February 2024, 18:25
Updated:
6 November 2025, 15:31
1-Day JAD held 10/29/2025. Rudy Bi (DOIT) built a process to grab Marine Shellfish Lease and Lessee data from GIS and put it into NJEMS tables. It is program specific, not generic. It also only goes one way – from GIS into NJEMS. The program wants data to also go from NJEMS into GIS. That’s the focus of the JAD.
DOIT (Karen Anselmo) requested volume estimates from the program on 10/3 for the # of lots and # of lessees that were added the last year or two.
Awaiting a response.
Demo provided by Karen Anselmo 10/2/24 to Marine Shellfish staff who responded positively. They were provided access to pre-production and training material. Follow-up with CGI is pending.
Better data from the program is still of interest to understand the transaction rate more accurately than the estimate of 1-10 new per month. An actual average month over the last year or several years, with any trends will make workload to new data entry clearer.
Demo being scheduled for program. Inquiry underway with CGI for their availability among existing demands.
meeting today, issues were around the amount of work and possible loss of utility (more steps, clicks, etc.) in the NJEMS interface necessary for new lessees and leases that will be manually entered after an initial data conversion of exiting 2,285 lots and 322 lessees. It is estimated this may be 1-10 new records a month. They would need to move to entry in NJEMS as opposed to the GIS interface used currently. That interface can pass updates to existing records via GIS, but cannot handle creation of new NJEMS records for new leases and lessees.
Michele Zola will schedule a meeting to walk through the process to see the true impacts for Jeff Normant and his team. There is currently no real alternative to this pathway as the existing process that uses GIS also requires manual updates to the old Access back-end. This can produce needed documents and data but is not shared nor tied into enterprise billing.
2/22/2024 Data Migration Status Summary in attached email.