osm2postgresql

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

Features

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

QGIS Rendering after import with osm2postgresql

Project Activity

See All Activity >

License

GNU General Public License version 2.0 (GPLv2)

Follow osm2postgresql

osm2postgresql Web Site

Other Useful Business Software

Ship Agents Faster

Transform your applications and workflows into powerful agentic systems at global scale.

Gemini Enterprise Agent Platform lets you rapidly build, scale, govern and optimize production-ready agents grounded in your organization's data. The platform enables developers to build custom or pre-built agents for virtually any use case. New customers get $300 in free credits.

Get Started Free

Rate This Project

User Ratings

5.0 out of 5 stars

★★★★★

★★★★

★★★

★★

★

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

Filter Reviews:

All

skywaffle Posted 2011-09-07

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!

Additional Project Details

Operating Systems

BSD, Linux

Languages

English

Intended Audience

Advanced End Users, System Administrators

User Interface

Command-line

Programming Language

Unix Shell

Database Environment

PostgreSQL (pgsql)

Related Categories

Unix Shell Database Software, Unix Shell GIS Software

Registered

2011-03-06

Similar Business Software

DbVisualizer

DbVisualizer is a universal database client for anyone who works with data, from solo developers and startups to professional teams managing complex environments, including developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It offers a graphical interface...

See Software
Google Cloud SQL

Fully managed relational database service for MySQL, PostgreSQL, and SQL Server with rich extension collections, configuration flags, and developer ecosystems. New customers get $300 in free credits to spend on Cloud SQL. You won’t be charged until you upgrade. Reduce maintenance costs with...

See Software
Google Cloud Platform

Google Cloud is a cloud-based service that allows you to create anything from simple websites to complex applications for businesses of all sizes. New customers get $300 in free credits to run, test, and deploy workloads. All customers can use 25+ products for free, up to monthly usage...

See Software
Google Cloud BigQuery

BigQuery is a serverless, multicloud data warehouse that simplifies the process of working with all types of data so you can focus on getting valuable business insights quickly. At the core of Google’s data cloud, BigQuery allows you to simplify data integration, cost effectively and securely...

See Software
Hubstaff

Hubstaff is a time tracking software that helps teams log hours, monitor productivity, and automate payments — whether remote, hybrid, in-office, or field-based. Available on desktop, web, and mobile, Hubstaff enables employees to track time against specific tasks and projects from anywhere....

See Software
GoCodes

No more missing assets. GoCodes is asset tracking software for trades and industry. Track tools, equipment, and vehicles from one account. Know what you own, where it is, and who has it. Tag assets with customizable QR code labels, included in your price. Use our mobile app, rated 4.7...

See Software