Query not exposed attributes from PostGIS

Question

I loaded an osm-file into PostGIS by using osm2pgsql. Now, I would like to query features with specific attributes. For example: "highway is not null" with "maxspeed is not null". PGadmin returns: "ERROR: column "maxspeed" does not exist"

From overpass-turbo I know, my area of interest provides such characteristics. So should be present.

select * from planet_osm_line
where highway is not null and maxspeed is not null

I expect a query result with a additional attribute column of "maxspeed", but PGadmin returns: "ERROR: column "maxspeed" does not exist"

check for exact column name – ScaisEdge Jun 01 '19 at 06:34 — ScaisEdge, Jun 01 '19 at 06:34

score 1 · Accepted Answer · answered Jun 03 '19 at 13:27

See a similar question at gis.stackexchange.com. Quoting the answer:

The default.style file https://github.com/openstreetmap/osm2pgsql/blob/master/default.style does not pick maxspeed into its own column. Edit default.style or use the --hstore option for writing all the tags into hstore.

Query not exposed attributes from PostGIS

1 Answers1