Type in the TN NG911 Database

Jun 5, 2024 | 911, postgis, QGIS

THE PLAN…..there was a plan. Oh yes – the plan is to make editing and creating data in TN for the 911 addressing system to be as easy as possible. Menus and Triggers abound and now as two counties are using this with a third on the horizon – HOW do I make this easier?

Step one is adjust the menus. All Roads have a type and TN adheres to the USPS Road abbreviations. If I’m not mistaken there are 206 (from Alley to Wells) and I did them all in Alphabetical order. Which means you have like scroll for a bit to get to Road or RD.

Tennessee has a download for their state roads and I can quickly sort them out. Ever wonder what are the top 10 road abbreviations in TN?

Road and Drive are the top 2. Also Null and Single Space are 6 and 7. So moving forward there will be two tables to choose from in setting up the menus: Alphabetical and Sorted. And sorted will be based on the number of occurrences to cut down on an insane amount of scrolling.

The insane amount of scrolling type relation.

Next up – Address Numbers from your chair.

FOSS4G Belem

Subscribe to the Newsletter!


 

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...