We are involved in a statewide NENA project which will ultimately make all the 911 addressing info, minus the personal stuff, available online for maintenance (if you choose to use the online system), viewing, and analysis purposes. We have already had our data converted to the NENA standards and returned to us where it has happily sits collecting dust while we try to figure out how to get the NENA schema into the production/live database used by the 911 center.
In regards to or update I have been asked to accomplish the following and am hoping you might have some insight on:
- Update the data to the new NENA standards (time consuming but not really a problem)
- Has anyone found an efficient way to QA/QC their data per the NENA standards?
- Update the schema of the existing dispatch database
- Would it be best to give them the schema xml to import to a new live/production database?
- Or have them change the schema in the existing database?
- Or just import the NENA compliant database onto their server as a SDE/SQL database once I finish updating everything?
- Is there anything I should be looking out for? Be wary of?
- Would it be better to wait until the update/mgration to the new CAD system is done?
- Load the data into the new schema (again, not a huge issue)
Any help/advice/tips would be greatly appreciated.