census-postgres-scripts icon indicating copy to clipboard operation
census-postgres-scripts copied to clipboard
verified publisher icon censusreporter

using wrong projection on tiger import

Open sbchonez opened this issue 5 years ago • 3 comments

the data from census are actually in 4269

I think you could reproject and make valid in one step:

psql -d census -U census -v ON_ERROR_STOP=1 -q -c "ALTER TABLE tiger2019.${tablename} ALTER COLUMN geom type geometry(MultiPolygon, 4326) using ST_MakeValid(ST_Transform(geom, 4326));"

details on that here

sbchonez avatar Oct 27 '20 14:10 sbchonez

Can you point to a reference that says TIGER is in EPSG:4269?

iandees avatar Oct 27 '20 15:10 iandees

https://www2.census.gov/geo/pdfs/maps-data/data/tiger/tgrshp2019/TGRSHP2019_TechDoc_Ch2.pdf
section 2.2.3

It's also what is provided in the metadata with each file. DC tabblock data shown in QGIS:
image

sbchonez avatar Oct 27 '20 16:10 sbchonez

Hm, OK. I'll have to look at re-importing the TIGER data then. Thanks for flagging!

iandees avatar Oct 28 '20 15:10 iandees