go-spatial / tegola-osm

Various scripts for importing and running a mirror of OSM with tegola
https://demo.tegola.io
MIT License
73 stars 26 forks source link

ERROR: column "admin_areas_level" does not exist #16

Closed erictheise closed 6 years ago

erictheise commented 6 years ago

Imported a metro extract using the current imposm3.json. Executing postgis_index.sql against my db results in

BEGIN
    CREATE INDEX ON osm_transport_lines_gen0 (type);
CREATE INDEX
    CREATE INDEX ON osm_transport_lines_gen1 (type);
CREATE INDEX
    CREATE INDEX ON osm_transport_lines (type);
CREATE INDEX
    CREATE INDEX ON osm_admin_areas (admin_areas_level);
psql:postgis_index.sql:9: ERROR:  column "admin_areas_level" does not exist
    CREATE INDEX ON osm_landuse_areas_gen0 (type);
psql:postgis_index.sql:10: ERROR:  current transaction is aborted, commands ignored until end of transaction block
    CREATE INDEX ON osm_water_lines (type);
psql:postgis_index.sql:11: ERROR:  current transaction is aborted, commands ignored until end of transaction block
    CREATE INDEX ON osm_water_lines_gen0 (type);
psql:postgis_index.sql:12: ERROR:  current transaction is aborted, commands ignored until end of transaction block
    CREATE INDEX ON osm_water_lines_gen1 (type);
psql:postgis_index.sql:13: ERROR:  current transaction is aborted, commands ignored until end of transaction block
    CREATE INDEX ON osm_water_areas (type);
psql:postgis_index.sql:14: ERROR:  current transaction is aborted, commands ignored until end of transaction block
    CREATE INDEX ON osm_water_areas_gen0 (type);    
psql:postgis_index.sql:15: ERROR:  current transaction is aborted, commands ignored until end of transaction block
    CREATE INDEX ON osm_water_areas_gen1 (type);
psql:postgis_index.sql:16: ERROR:  current transaction is aborted, commands ignored until end of transaction block
COMMIT;
ROLLBACK

and indeed that column seems not to exist.

# \d osm_admin_areas
                                    Table "public.osm_admin_areas"
   Column    |          Type           |                          Modifiers                           
-------------+-------------------------+--------------------------------------------------------------
 id          | integer                 | not null default nextval('osm_admin_areas_id_seq'::regclass)
 osm_id      | bigint                  | 
 name        | character varying       | 
 type        | character varying       | 
 admin_level | integer                 | 
 tags        | hstore                  | 
 geometry    | geometry(Geometry,3857) | 
Indexes:
    "osm_admin_areas_pkey" PRIMARY KEY, btree (id)
    "osm_admin_areas_geom" gist (geometry)
    "osm_admin_areas_osm_id_idx" btree (osm_id)
ARolek commented 6 years ago

@erictheise quick GH hack. If you use the syntax "closes #[issue]" in your commit message it will auto close the issue when the commit hits master.