Page MenuHomePhabricator

Use hstore for tags column in all osm2pgsql tables
Closed, DeclinedPublic

Description

For some reason, tables planet_osm_rels, planet_osm_ways, planet_osm_nodes have tags defined as tags text[], instead of tags hstore. This makes it impossible to index and search by wikidata id tag.

Example goal: get entire geometry of the interstate highway by its wikidata ID.

Related Objects

StatusSubtypeAssignedTask
DeclinedYurik
DeclinedNone

Event Timeline

The slim tables are for internal osm2pgsql use and not designed to be easily queried. Also, if you're using flat nodes, the planet_osm_nodes table will be empty.

Closing as "this is by design".