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.

Subscribe to the Newsletter!

You may also like

QGIS Fun: Chickamauga Mound

QGIS Fun: Chickamauga Mound

I've been trying to stop once a week and do something fun with QGIS. Post Heart Incident I do a lot of walking. I've been re-exploring some places I used to go in town to exercise and one is the TN River Walk. I realized the other day I needed to do some OpenStreetMap...

The Trail Map – Part 1

The Trail Map – Part 1

A few posts ago I babbled about cartography. I've never had the patience for Cartography mainly because two things usually happen...well three things: the map can't be bigger than 8x11 the map must have everything on it Make the map however you want except we will...

My So called Life as a Map Maker

My So called Life as a Map Maker

I can sum it up: It's not much of one. Way back in my younger days I was infatuated with ArcPlot (which was the plotting portion of ArcINFO). From there I moved to Arcview, ArcMap, and eventually here to QGIS. All of my work typically revolves around Data. I usually...