northrivergeo / tn_ng911_data_model

This is the postgresql version of the TN NG911 Standard. I'm using it with one county in TN. It's open for all to use.
GNU General Public License v2.0
0 stars 2 forks source link

City Trigger Function (Carried from Issue #23) #27

Closed KSnyderCode closed 1 year ago

KSnyderCode commented 2 years ago

I checked the TN 911 Standard. The city can't be assigned from the Census. That has to be assigned based off the local county MSAG layer. I can write a quick trigger for that, but that's likely just has to be a placeholder for now.

northrivergeo commented 1 year ago

Hah - so I talked to chad - they can't pull the city from census - so it's sorta eyeballed.