[OSM-talk] Error loading data with osm2pgsql

[trossachs]

My first download must have got corrupted, somehow, and Windows cached it in
my Temporary Internet files folder. I deleted this and re-tried the download
and this time it was successful.
I ran the 900193.sql script and then ran the osm2pgsql with the -s option
and it's busy reading the osm file and loading up the database!

Happy days!

Thanks again for your help.

I'll try and repay the favour to any newbs having problems on Windows 


Jon Burgess-2 wrote:
> 
> On Sun, 2009-07-12 at 05:59 -0700, trossachs wrote:
>> Thanks for your help Jon.
>> Yes, I'm using Windows and as you can tell, I'm a newbie at this map
>> stuff.
>> I've managed to get Postgres installed with PostGIS extensions and I've
>> got
>> GeoServer set up as well.
>> 
>> I tried downloading the osm2pgsql from the link you gave me and it
>> appears
>> to download a 1.7Mb file but when I try to unzip it, the unzip software
>> tells me the file is empty.
> 
> The file should be 1.8MB (1850788 bytes exactly)
> 
> The file works for me, the example below was just done using Linux
> tools:
> 
> $ wget http://tileserv.openstreetmap.org/osm2pgsql.zip                 
> --2009-07-12 14:19:13--  http://tileserv.openstreetmap.org/osm2pgsql.zip                   
> Resolving localhost... 127.0.0.1                                                           
> Connecting to localhost|127.0.0.1|:3128... connected.                                      
> Proxy request sent, awaiting response... 200 OK                                            
> Length: 1850788 (1.8M) [application/zip]                                                   
> Saving to: `osm2pgsql.zip'                                                                 
> 
> 100%[=============================================================================================================================================>]
> 1,850,788   --.-K/s   in 0.07s   
> 
> 2009-07-12 14:19:13 (25.7 MB/s) - `osm2pgsql.zip' saved [1850788/1850788]
> 
> [jburgess at shark tmp]$ unzip osm2pgsql.zip 
> Archive:  osm2pgsql.zip                   
>    creating: osm2pgsql/                   
>   inflating: osm2pgsql/zlib1.dll          
>   inflating: osm2pgsql/bz2-1.dll          
>   inflating: osm2pgsql/900913.sql         
>   inflating: osm2pgsql/libiconv-2.dll     
>   inflating: osm2pgsql/default.style      
>   inflating: osm2pgsql/README.txt         
>   inflating: osm2pgsql/libxml2-2.dll
>   inflating: osm2pgsql/libpq.dll
>   inflating: osm2pgsql/osm2pgsql.exe
> [jburgess at shark tmp]$ osm2pgsql/osm2pgsql.exe
> osm2pgsql SVN version 0.55-20081113 $Rev: 10464 $
> 
> Usage:
>         osm2pgsql.exe [options] planet.osm
>         osm2pgsql.exe [options] planet.osm.{gz,bz2}
>         osm2pgsql.exe [options] file1.osm file2.osm file3.osm
> 
> This will import the data from the OSM file(s) into a PostgreSQL database
> suitable for use by the Mapnik renderer
> 
> Options:
>    -a|--append          Add the OSM file into the database without
> removing
>                         existing data.
>    -b|--bbox            Apply a bounding box filter on the imported data
>                         Must be specified as: minlon,minlat,maxlon,maxlat
>                         e.g. --bbox -0.5,51.25,0.5,51.75
>    -c|--create          Remove existing data from the database. This is
> the
>                         default if --append is not specified.
>    -d|--database        The name of the PostgreSQL database to connect
>                         to (default: gis).
>    -l|--latlong         Store data in degrees of latitude & longitude.
>    -m|--merc            Store data in proper spherical mercator (default)
>    -M|--oldmerc         Store data in the legacy OSM mercator format
>    -E|--proj num        Use projection EPSG:num
>    -u|--utf8-sanitize   Repair bad UTF8 input data (present in planet
>                         dumps prior to August 2007). Adds about 10%
> overhead.
>    -p|--prefix          Prefix for table names (default planet_osm)
>    -s|--slim            Store temporary data in the database. This greatly
>                         reduces the RAM usage but is much slower.
>    -S|--style           Location of the style file. Defaults to
> ./default.style
>    -C|--cache           Only for slim mode: Use upto this many MB for
> caching nodes
>                         Default is 800
>    -U|--username        Postgresql user name.
>    -W|--password        Force password prompt.
>    -H|--host            Database server hostname or socket location.
>    -P|--port            Database server port.
>    -h|--help            Help information.
>    -v|--verbose         Verbose output.
> 
> Add -v to display supported projections.
> Use -E to access any espg projections (usually in /usr/share/proj/epsg)
> 
> 
> 	Jon
> 
> 
> 
> _______________________________________________
> talk mailing list
> talk at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk
> 
> 
:-D
-- 
View this message in context: http://www.nabble.com/Error-loading-data-with-osm2pgsql-tp24418427p24448994.html
Sent from the OpenStreetMap - General mailing list archive at Nabble.com.