On Jan 22, 2008 9:32 AM, Andy Robinson (blackadder) < [EMAIL PROTECTED]> wrote:
> John, > > This is probably better spotted and hopefully responded to by the folks on > the dev list. Copied there. > > Cheers > > Andy > > >-----Original Message----- > >From: [EMAIL PROTECTED] [mailto:newbies- > >[EMAIL PROTECTED] On Behalf Of John Wheeler > >Sent: 22 January 2008 7:10 AM > >To: [EMAIL PROTECTED] > >Subject: [OSM-newbies] Should osm2pgsql create the planet_osm tables? > > > >Hi, > > > >My goal is to setup a renderfarm to generate my own maps. I setup a > >postgresql with postgis and succeeded in compiling osm2pgsql from the > >subversion repository. I also create a database called gis. In the readme > >of osm2pgsql I read: > > > >Connects to database and creates the following 4 tables: > > - planet_osm_point > > - planet_osm_line > > - planet_osm_roads > > - planet_osm_polygon > > > >So what I understand is that osm2pgsql creates these tables before it > >starts processing the planet file. However when I > >run osm2pgsql with the following command > > > >./osm2pgsql -c -d gis /opt/planet-latest.osm.bz2 > > > >I get: > > > >osm2pgsql SVN version 0.51-20080121 $Rev: 6139 $ > > > >Using projection SRS 3395 (WGS84 Mercator) > >Setting up table: planet_osm_point > >Setting up table: planet_osm_line > >Setting up table: planet_osm_polygon > >Setting up table: planet_osm_roads > > > >Reading in file: /opt/planet-latest.osm.bz2 > >Processing: Node(3640k) Way(0k) Relation(0k) > > > >but I see no tables being created in my gis database and when osm2pgsl is > >ready I stil see no tables. Am I forgetting something or is there a ddl > >script to create these tables? Any help is appreciated. > The tables are created and populated within a transaction, so you may not see them appear until osm2pgsql has completely finished. On my box this takes several hours for the latest planet, and spends at least an hour with no output as postgres is indexing the data. The output looks like it is working. You might want to try it with a smaller subset of data first to check everything is working. Any old .osm file will do, just download a small bbox from the server (save from JOSM), and try and import that. It should happen almost instantly and you can then check out the data in the tables. Once you get that working you can import the 3.4GB of compressed planet.osm. Dave
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
