Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My openstreetmap data has artifacts that I can't seem to get rid of. It is showing the roads underneath the artifacts so I know that the query is working at least partially.

The data is from for the D.R./Haiti region, downloaded via the .bz2 file into a PostgreSQL database as per the instructions here:

I'm displaying it in TileMill via the query: ( SELECT * FROM planet_osm_line WHERE "highway" IN ('motorway','trunk') ORDER BY z_order asc ) AS route

enter image description here

share|improve this question
up vote 3 down vote accepted

Are you using a osm2pgsql version that is able to handle 64-bit-IDs, and the PostgreSQL and Postgis version it is build against? There are some strange errors in OSM data handling since the node IDs have cracked the 32-bit limit.

You could try the older CC-BY-SA Version from, but you have to translate that to .osm format with osmconvert before feeding the data to the Postgis database.

share|improve this answer
This worked! Thank you!!! – gpeterson Apr 20 '13 at 17:17

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.