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