I'm working with postgis and followed many tutorials out there to try to use tiger data.
this one seems to be the best:
To save time and make sure things are working, I reduced it to a smaller set of states to populate my Tiger data.
Looking in the output, I'm seeing things like this:
Unable to open tl_2016_44007_addr.shp or tl_2016_44007_addr.SHP. tl_2016_44007_addr.dbf: shape (.shp) or index files (.shx) can not be opened, will just import attribute data.
Unable to open tl_2016_36019_featnames.shp or tl_2016_36019_featnames.SHP. tl_2016_36019_featnames.dbf: shape (.shp) or index files (.shx) can not be opened, will just import attribute data.
HTTP request sent, awaiting response... 304 Not Modified File ‘www2.census.gov/geo/tiger/TIGER2016/PLACE/tl_2016_11_place.zip’ not modified on server. Omitting download.
I assume the second error means that it already downloaded the file, so it skipped it?
I ran the script again with just DC as a state, and even went with the author's example for a sanity check:
SELECT g.rating, ST_X(g.geomout) As lon, ST_Y(g.geomout) As lat, (addy).address As stno, (addy).streetname As street, (addy).streettypeabbrev As styp, (addy).location As city, (addy).stateabbrev As st, (addy).zip FROM geocode('1600 Pennsylvania Avenue Northwest, Washington, DC 20500') As g;
Success! I got back the matching data, which is good, but when I ran his second example to confirm:
SELECT g.*, ST_X(g.geomout) As lon,ST_Y(g.geomout) As lat,(addy).*, bg.tabblock_id AS FIPS FROM geocode('1600 Pennsylvania Avenue Northwest, Washington, DC 20500') As g JOIN tabblock As bg ON (g.geomout && bg.the_geom) WHERE ST_Within (g.geomout, bg.the_geom);
it returned back 0 records. I did a select * from tabblock and it returned 0 records.
What table is that, and should it normally download based on the script?
If not, how is this table populated?