[OSM-dev] Writing an OSM map application

[Andreas Volz]

Am Thu, 29 Mar 2007 13:53:45 +0200 schrieb Andreas Volz:

> Am Fri, 23 Mar 2007 19:52:29 +0000 schrieb Keith Sharp:
> 
> > On Fri, 2007-03-23 at 20:26 +0100, Andreas Volz wrote:
> > > Hello,
> > > 
> > > I like to write an application that uses the map data from OSM. I
> > > looked how other applications solved this. They import the
> > > world.osm into a SQL database an read all map information from
> > > there. So please try to answer these OSM beginner questions:
> > > 
> > > - Is there a proposed SQL database format for OSM based maps? This
> > > would be usefull to share end user generated map data between
> > > various systems.
> > 
> > I use PostGIS on top of PostgreQL.  The table format is defined by
> > the import tool, see below.
> > 
> > > - Is there an application which converts the world.osm into a SQL
> > > database?
> > 
> > If you use PostGIS then you want osm2pgsql:
> > 
> > 	http://svn.openstreetmap.org/utils/osm2pgsql/
> 
> I've still problems with osm2pgsql. I installed postgres and postgis
> on Gentoo. I started the postgres service. Then I created a database
> "osm" ,a psql user and executed this:
> 
> > psql -d osm < germany-070321.sql

Hmpf, I should read before post:

--------------------------------
Now load the PostGIS object and function
definitions into your database by loading the lwpostgis.sql definitions
file.

# psql -d [yourdatabase] -f lwpostgis.sql

The PostGIS server extensions are now loaded and ready to use.
#

For a complete set of EPSG coordinate system definition identifiers,
you can also load the spatial_ref_sys.sql definitions file and populate
the SPATIAL_REF_SYS table.

# psql -d [yourdatabase] -f spatial_ref_sys.sql
--------------------

Now it works nice.

regards
Andreas