[Tile-serving] [osm2pgsql-dev/osm2pgsql] Where to find PostgreSQL table column's description (Discussion #2109)

[SomeoneElseOSM]

> E.g. there is a column "horse". What is it good for? Or, how can I search for rivers?

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](https://github.com/gravitystorm/openstreetmap-carto/blob/master/openstreetmap-carto.style).  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](https://www.openstreetmap.org/way/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 .

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2109#discussioncomment-7554556
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2109/comments/7554556 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20231113/2d75d3d5/attachment.htm>