I've installed the PostGIS Tiger Geocoder according to these instructions and loaded in data for the state of New York.

Unfortunately, when I try to geocode something...

ny_tiger=# 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('350 Fifth Ave, New York, NY 10118') As g;                                                                
 rating | lon | lat | stno | street | styp | city | st | zip 
(0 rows)

So that's not great.

I noticed when loading things in I got a ton of errors like this:

Unable to open tl_2013_36123_addr.shp or tl_2013_36123_addr.SHP.
tl_2013_36123_addr.dbf: shape (.shp) or index files (.shx) can not be opened, will just import attribute data.

Is that the problem? How do I fix that?

  • What version of PostGIS?
    – Mapperz
    May 9, 2014 at 19:14
  • 1
    It's PostGIS 2.1, Postgres 9.3 May 9, 2014 at 19:16
  • 3
    The notices are expected. When I wrote the loader, I wanted a generic load pattern for all tables at the cost of having some notices. It is more of a notice than an error. addr tables never have accompanying geometry so when you use shp2pgsql and you don't use the switch to only load attribute, it tries to load spatial, gives a warning if no spatial, and then falls back on loading only attribute data.
    – LR1234567
    May 10, 2014 at 12:41

2 Answers 2


I must've done something wrong in following those instructions, as clearing and re-loading the data from scratch yielded a working system.


Looking at your Dockerfile, it seems like the the output from loader_generate_nation_script() is never run https://github.com/similitude/tiger-geocoder/blob/master/Dockerfile#L48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.