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

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

Be the first to post a review of osm2postgresql!

Additional Project Details

Operating Systems

Linux, BSD

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 one of the world’s most popular database editors. Developers, analysts, and DBAs use it to elevate their SQL experience with modern tools to visualize and manage their databases, schemas, objects, and table data, and to auto-generate, write and optimize queries. And so much...

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
Amazon RDS

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching and...

See Software

Report inappropriate content