New answers tagged osm2pgsql
As you query to have only nodes it is that all you get. See http://wiki.openstreetmap.org/wiki/Overpass_API/Language_Guide#Nodes for more details. Your query should be http://overpass-api.de/api/interpreter?data=(node(52.06,5.04,52.08,5.06);<;>;);out;
Nominatim and Mapnik/renderd use different database schemes, so you better put them in separate databases. See Can we use existing plant database for Nominatim for more details. Unfortunately, noone has ever documented the nominatim database scheme yet.
I downloaded OSM vector data from Geofabrik website. For the time being, i downloaded OSM vector data. I filled usefull field (speed_profile) for driving isochrones. On my windows 7 32 bits, Grass 7.0 and postgres/postgis have been installed. I loaded my OSM roads network into my Grass db. And i made a test with v.isochrones plugin. up to now, i did not load ...
You could use ST_LineMerge http://postgis.net/docs/ST_LineMerge.html First you need join all your ways into one MultiLineString using ST_DUMP http://postgis.net/docs/ST_Dump.html and ST_Multy Afterwards use ST_LineMerge to get a set of Linestrings of maximum length sewed from segments.
z_order is a field in osm2pgsql datamodel that map OSM Layers in OSM tags to a number in osm2pgsql model. Links: Osm2pgsql tables OpenStreetMap Layer
The default.style file https://github.com/openstreetmap/osm2pgsql/blob/master/default.style does not pick maxspeed into its own column. Edit default.style or use the --hstore option for writing all the tags into hstore.
There seems to be something wrong with the style file option. Try: F:\randomGISstuff\ethiopia>osm2pgsql -c -G -U postgres --hstore -S F:\randomGISstuff\ethiopia\default.style -U postgres -d ethiopia ethiopia-latest.osm.pbf If the user needs to give a password, you might have to put it on the command line as well. It might help to always give the full ...
in SQL Editor create db 'gis' -- Database: gis -- DROP DATABASE gis; CREATE DATABASE gis WITH OWNER = postgres ENCODING = 'UTF8' TABLESPACE = pg_default LC_COLLATE = 'English_United States.1252' LC_CTYPE = 'English_United States.1252' CONNECTION LIMIT = -1;
Osm2PgSql will only import polygons into the planet_polygon table if they are closed. You may find the missing data in the planet_lines table Use OverPass Turbo or OSm to get the osm_id of the missing geometry and search for it in the polygons and lines table's. This will tell you if they were actually imported. If they are not in those tables, they were ...
planet_osm_node contains the point data in the same way they are stored in the OSM database. These nodes can contain attribute information, or are just part (vertices) of ways. planet_osm_point is a subset of the node table, containing only the points with attributes, but not the vertices. Furthermore, it has a geometry column to use with GIS applications. ...
The planet_osm_point table is used much more often (than node) in documentation and examples, transforms the OSM data from an EPSG 4326 production to EPSG 900913 projection, and I've never used planet_osm_node in my work of using OSM data in applications Tilemill and qgis using the osm_point This schema page on the osm wiki has some vague answers on the ...
Top 50 recent answers are included