I need to download some cities boundaries polygons and store them in a Postgis database. Is this possible? Using what tools?


Over at geofabrik you can download up-to-date shapefiles with selected osm attributes. They have even have categorized per country.

Once downloaded and sorted the data that you need; you can upload your data to your postgis using a variety of tools depending on your project: Qgis, gdal, shp2pgsql and others.

Also take heed, the data are in WSG84 (4326) so you might need to reproject them to your local Coordinate System while or before upload them to your database.

  • Thanks! Which format should I download? There are two files: colombia-latest.osm.pbfand colombia-latest.shp.zip – IAmJulianAcosta Jul 23 '16 at 2:13
  • 2
    The answer says "shapefiles", so you wantcolombia-latest.shp.zip if you are to follow this answer. – BradHards Jul 23 '16 at 2:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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