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

QGIS and LIDAR

So this will be my last "New Class" announcement for a bit. Back in the spring of 2024, I taught a 4 hour QGIS and LIDAR class at the TNGIC meeting (State of TN GIS meeting). I ran through it and shelved it and now I'm fixing the problem spots and smoothing down the...

NENA 911 Database in QGIS

NENA 911 Database in QGIS

I work with two counties in TN with the TN NG911 standard. Flash back 10 years ago and I hadn't really grasped how complicated address is. Do I like it? Mostly Yes. Occasionally I get questions from outside TN and I demo the two counties and how that works. A while...

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