I’m preparing to rollout the “new and improved” TN 911 database to a client. I’ve been working on it as time permits and I’m at a point where “it’s done”. You can deploy it and run it and life is good.
Now the question is “can I add in some scripts to make your life easier”. Yes. I’m adding those to check overlapping road ranges or build an msag or whatever makes sense for the keepers of the address data.
A few months back I ran across this on Github: NENA Data Model.
When you look at it you have two options: An ESRI File Based Geodatabase and a Postgresql database. You can load the postgresql database easy enough. I took my clients data and shoved it into the database and opened it in QGIS and surprise it works. They even have enough tables and other info you can start building widgets for data entry.
The NENA database is more complicated than the TN database. With the TN one I have 6 layers with 2 of them being actively updated and the NENA has something like 16 (or 15 or 17) layers with tables and relations. From what I know probably 3 will be updated with some consistency. You have hydro and railroads and stuff my other clients have but isn’t part of the database so much.
I think I’m going to slowly start plugging away at adding some QGIS related things to help use the NENA Postgresql portion. Add some triggers. Add some scripts. Set up some menus.
Anyway – more news coming.
