search

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

ZCTA layer for zipcodes #20

Closed northrivergeo closed 2 years ago

northrivergeo commented 2 years ago

Every address needs a zipcode added. I've been leaving that up to the 911 BUT - in general they are using the ZCTA layer from the census. So my thought is to set up a trigger for addresses and to go ahead and set up a schema for census and set up a zipcode layer for all of TN. It shouldn't be large - maybe go ahead and convert it to SQL using shp2pgsql or the QGIS tools.

KSnyderCode commented 2 years ago

~~I can definitely knock this out tonight. ~~

Done! Using ST_Intersects. Closing issue.