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.

You may also like

Photos in Mergin Maps

Photos in Mergin Maps

Not that this is new - Mergin has been doing this for a bit BUT I finally had the chance to sit down and use it. I have a client taking pics of houses to feed into the 911 dispatch system. Granted - not easy, not fun, and not his idea but he walked into this and has...

Fixing a problem

Yesterday was wild. Flash back to 6 years ago and I transferred a ESRI Process over to QGIS/PostGIS and it happened to be a 911 addressing database. As I was walking out the door, the client said "So how do we deliver the data to the state" and through a bunch of...

Model Designer Class June 25th 2024

Model Designer Class June 25th 2024

June 25th Location: Virtual Cost: $150 Time: 12pm to 4pm EST Link: https://www.eventbrite.com/e/qgis-model-designer-tickets-906763111877 The Model Designer Class makes a re-appearance after a tuneup. What is it? This 4 hour class will cover building Processing Models...