[postgis-users] Geocoder 2010, Pg 9, PostGIS 1.5

[Johnathan Leppert]

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, <maplabs at light42.com> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
*Johnathan*
Software Architect & Developer
Columbus, Ohio
*Follow me on Twitter: @iamleppert <http://twitter.com/#!/iamleppert>*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110529/60dcbc24/attachment.html>