I am pretty new to OSM & PostGres/PostGis - actually never used it: I am doing some research trying to figure what would be the best possible way to leverage OSM data in our environment. osm2postgresql looks interesting in particular because it cleans up polygon data, but they are a couple of questions I am stuck with…hopefully someone on this board can help!
What we need to do (for US & Brazil):
- reverse geolocation: given latitude, longitude return address information (including the neighborhood, as a sub-area of a city)
- mapping overlays:
* given a node, return all the children (e.g. the children of country=us would be all the states)
* given a node, return the polygon that defines the boundaries of that node (a node could be a country, state, city or neighborhood)
I wasn't able to locate a db schema for a osm2postgresql DB, so it's hard to tell if it can be queried for our need … and what the queries would look like…hopefully not too many crazy joints :)
Can someone provide some pointers? Info regarding the DB schema, feasibility of getting it done (ideally accompanied by some example SQL) would be very, very appreciated!
Thanks in advance!
Hugo
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I am pretty new to OSM & PostGres/PostGis - actually never used it: I am doing some research trying to figure what would be the best possible way to leverage OSM data in our environment. osm2postgresql looks interesting in particular because it cleans up polygon data, but they are a couple of questions I am stuck with…hopefully someone on this board can help!
What we need to do (for US & Brazil):
- reverse geolocation: given latitude, longitude return address information (including the neighborhood, as a sub-area of a city)
- mapping overlays:
* given a node, return all the children (e.g. the children of country=us would be all the states)
* given a node, return the polygon that defines the boundaries of that node (a node could be a country, state, city or neighborhood)
I wasn't able to locate a db schema for a osm2postgresql DB, so it's hard to tell if it can be queried for our need … and what the queries would look like…hopefully not too many crazy joints :)
Can someone provide some pointers? Info regarding the DB schema, feasibility of getting it done (ideally accompanied by some example SQL) would be very, very appreciated!
Thanks in advance!
Hugo