Where to find PostgreSQL table column's description #2109
Replies: 2 comments
-
The columns that are created when you load data are determined by a ".style" file that tells osm2pgsql what columns to create. An example of one of those is here. Depending on what instructions you were following to get to wherever you have got to, you might have different data columns. What goes in those columns comes essentially from OpenStreetMap, so if I do a "elect osm_id from planet_osm_polygon where horse = 'yes';" among the data returned is for osm_id 23496240. Taking a step back, and considering that osm2pgsql might be only part of what you want to use to do whatever you want t do, it might be worth asking questions at https://community.openstreetmap.org/tags/c/help-and-support/7/none/osm2pgsql . |
Beta Was this translation helpful? Give feedback.
-
https://wiki.openstreetmap.org/wiki/Key%3Ahorse
check the OSM wiki Tags
so you have to find the For the OSM data model: |
Beta Was this translation helpful? Give feedback.
-
I am new to osm and PostGIS. So, probably some dump questions.
I have just imported osm data into PostgreSQL.
Now e.g. there is a table called
planet_osm_polygonthat has many different columns.
E.g. there is a column "horse". What is it good for? Or, how can I search for rivers?
Where can I find a description of the columns and the meaning/content they store?
Is there a detailed database schema description somewhere?
Cheers,
James
Beta Was this translation helpful? Give feedback.
All reactions