Where to find PostgreSQL table column's description #2109
-
|
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 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? Cheers, James |
Beta Was this translation helpful? Give feedback.
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 "select 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.
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 "select 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 b…