osm2postgresql is a Linux script loading openstreetmap data into a postgresql database setting up if needed a server & database (postgis+hstore). Advanced processing is performed, easing rendering. http://wiki.openstreetmap.org/wiki/Osm2postgresql


  • Optional: installs a postgres server and configure it; create a database (with postgis and hstore)
  • Loads osm data into the database and process it
  • Creates and fix polygons
  • Fixes small streams, canals... on riverbanks (nicer rendering)
  • Creates 3 tables that are ready for rendering: polygons, ways, nodes_with_tags
  • In each table, populates a "class" field that you can link to your symbology
  • Helps you easily render OSM data in your GIS application or web server
  • Keeps [almost] ALL tags (in two fields: 'tags' as text and 'tagshstore' as hstore)
  • 14 March 2011: version 02 (beta) released.
  • Still a work in progress: stay tuned!

Project Samples

Project Activity

See All Activity >


Database, GIS

Follow osm2postgresql

osm2postgresql Web Site

Other Useful Business Software

Mac CRM & Project Management app for small business Mac CRM & Project Management app for small business Icon
Mac CRM & Project Management app for small business Icon

Manage your leads, clients and projects – all in one place. Daylite keeps everyone on the same page.

Stop using frustrating spreadsheets and expensive, clunky CRMs that waste more time than they save. Try Daylite, a better way to keep track of relationships and projects so your team can win more business & get more done.
Do you and everyone who will be using your CRM use Macs, iPhones & iPads?
One last question before you visit our site:

How many people in your company will need to use your CRM?

Rate This Project

Login To Rate This Project

User Ratings

ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5

User Reviews

  • I had a requirement to develop water features for Europe. This script was the only GIS tool I could find to convert the OSM polylines and multipolygons (ie. riverbanks, etc.) to polygonal features. Thanks for your work on this project!

Read more reviews >

Additional Project Details



Intended Audience

Advanced End Users, System Administrators

User Interface


Programming Language

Unix Shell

Database Environment

PostgreSQL (pgsql)