Update on the TN 911 Database

Mar 18, 2023 | 911, postgis, QGIS

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.

You may also like

Watershed GIS Part 1

Watershed GIS Part 1

I typically spend June wondering about what I'm doing, have done, and need to do work wise. One thing I keep thinking about is "the old days". By old days I mean the start of my career which was doing a lot of Watershed Mapping. Back in the mid 90's we would be...

Mergin Maps Training Class

Mergin Maps Training Class

I had a boss that would always start off with "So the Short story is...." and you'd be stuck for at least 30 minutes and maybe an hour listening to a story that didn't go anywhere. So the short story on the Mergin Maps Class.......... NRGS is a Mergin Maps partner. A...

Unintended Joy

Unintended Joy

I was originally going to call this unintended consequences but - there was a small amount of joy at the end. In Tennessee you have 6 layers that are required by the NG 911 group. So you end up with a lot of information depending on the county being poured into the...