I haven’t talked about this in a while – but incremental work continues.
So I had a question “Can you get the NENA 911 Standard working in QGIS?” The answer is a long “Yes”. NENA has published a repository with a postgresql portion – and in two scripts you have a empty database. A little bit more work and you have dropdown lists in QGIS. More work and you have data. Life is good. 100% doable. I will be writing more on this in a bit.
…..BUT – it did make me think. A few months back Kyle Snyder jumped in and gave me some much needed direction and took my myriad number of scripts and made them better. I was looking at the TN scripts and going “I should steal a bit of what NENA did and make this simpler”. I simplified. Now I have 6 scripts. The first two leave you with a fully functioning TN NG911 Database. Script 3 is more of a placeholder to remind you to load data. Script 4 implements triggers. Script 5 indexes everything. Script 6 will be directions on loading a DEM. So eventually 4 scripts with two files being placeholders. Does this get your data into the database? No – I’m just building an empty database.
I know it’s not perfect but it’s simpler. I’m debating a second repository with some QAQC scripts to help you keep the data clean. Maybe I stick this under the current repo but the important thing is I can explain what I’m doing.
Anyway – with all of this I’m adding some menus that can be stuffed into the database.