What are the exact errors and in what part of create_geocode.sql is it failing?
Thanks, Johnathan On Sun, May 29, 2011 at 2:28 AM, <[email protected]> wrote: > > > I tried hooking up the Geocoder for TIGER 2010 as found in postgis_trunk > but it is failing.. First try was using PostGIS 2.0 trunk, after problems > next was > with PostGIS 1.5.. both with Postgresql 9.0 under linux > > It seems if I add the schema tiger_data to search_path > then run create_geocode.sql again manually, it gets a little > further.. but still, I end up with a database that looks like this: > > List of relations > Schema | Name | Type | Owner | Size | > Description > > --------+-----------------------+----------+-------+------------+------------- > public | geography_columns | view | dbb | 0 bytes | > public | geometry_columns | table | dbb | 0 bytes | > public | spatial_ref_sys | table | dbb | 0 bytes | > tiger | addr | table | dbb | 0 bytes | > tiger | addr_gid_seq | sequence | dbb | 8192 bytes | > tiger | county | table | dbb | 0 bytes | > tiger | county_gid_seq | sequence | dbb | 8192 bytes | > tiger | county_lookup | table | dbb | 0 bytes | > tiger | countysub_lookup | table | dbb | 0 bytes | > tiger | cousub | table | dbb | 0 bytes | > tiger | cousub_gid_seq | sequence | dbb | 8192 bytes | > tiger | direction_lookup | table | dbb | 8192 bytes | > tiger | edges | table | dbb | 0 bytes | > tiger | edges_gid_seq | sequence | dbb | 8192 bytes | > tiger | faces | table | dbb | 0 bytes | > tiger | faces_gid_seq | sequence | dbb | 8192 bytes | > tiger | featnames | table | dbb | 0 bytes | > tiger | featnames_gid_seq | sequence | dbb | 8192 bytes | > tiger | loader_lookuptables | table | dbb | 16 kB | > tiger | loader_platform | table | dbb | 8192 bytes | > tiger | loader_variables | table | dbb | 8192 bytes | > tiger | place | table | dbb | 0 bytes | > tiger | place_gid_seq | sequence | dbb | 8192 bytes | > tiger | place_lookup | table | dbb | 0 bytes | > tiger | secondary_unit_lookup | table | dbb | 8192 bytes | > tiger | state | table | dbb | 0 bytes | > tiger | state_gid_seq | sequence | dbb | 8192 bytes | > tiger | state_lookup | table | dbb | 8192 bytes | > tiger | county_lookup | table | dbb | 0 bytes | > tiger | countysub_lookup | table | dbb | 0 bytes | > tiger | cousub | table | dbb | 0 bytes | > tiger | cousub_gid_seq | sequence | dbb | 8192 bytes | > tiger | direction_lookup | table | dbb | 8192 bytes | > tiger | edges | table | dbb | 0 bytes | > tiger | edges_gid_seq | sequence | dbb | 8192 bytes | > tiger | faces | table | dbb | 0 bytes | > tiger | faces_gid_seq | sequence | dbb | 8192 bytes | > tiger | featnames | table | dbb | 0 bytes | > tiger | featnames_gid_seq | sequence | dbb | 8192 bytes | > tiger | loader_lookuptables | table | dbb | 16 kB | > tiger | loader_platform | table | dbb | 8192 bytes | > tiger | loader_variables | table | dbb | 8192 bytes | > tiger | place | table | dbb | 0 bytes | > tiger | place_gid_seq | sequence | dbb | 8192 bytes | > tiger | place_lookup | table | dbb | 0 bytes | > tiger | secondary_unit_lookup | table | dbb | 8192 bytes | > tiger | state | table | dbb | 0 bytes | > tiger | state_gid_seq | sequence | dbb | 8192 bytes | > tiger | state_lookup | table | dbb | 8192 bytes | > tiger | street_type_lookup | table | dbb | 24 kB | > tiger | zcta500 | table | dbb | 0 bytes | > tiger | zcta500_gid_seq | sequence | dbb | 8192 bytes | > tiger | zip_lookup | table | dbb | 0 bytes | > tiger | zip_lookup_all | table | dbb | 0 bytes | > tiger | zip_lookup_base | table | dbb | 0 bytes | > tiger | zip_state | table | dbb | 0 bytes | > tiger | zip_state_loc | table | dbb | 0 bytes | > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- *Johnathan* Software Architect & Developer Columbus, Ohio *Follow me on Twitter: @iamleppert <http://twitter.com/#!/iamleppert>*
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
