openstreetmap - Getting Geometry shape of the entire OSM database -

openstreetmap - Getting Geometry shape of the entire OSM database -

i have multiply databases on postgresql/postgis. it's database per country (might continent little ones). used osm2pgsql import info , it's working well. want create webserver lat/lon coordinates input , access proper db. in order think need create geometry-object/polygon of entire db (again, there db per county), check if lat/lon point specified in polygon , send query right db. how can create such geometry/polygon?

thanks, ohad.

partitioning database task multiple postgresql databases wrong approach. while approach might 1 other database software, not postresql. because hassle cross-database queries, may need type of query. improve partition multiple schemas within single database. however, if have 1000000 or fewer features (rows), maintain in same table indexed country field. way, info seamless when viewing on map or querying sql.

as point-in-polygon question, basic gis question, , find many others asking it. need table of polygons representing countries or administrative regions (e.g. http://www.gadm.org/) ideally gist index, , utilize st_contains or st_within determine polygon point within.

openstreetmap postgis