[postgis-users] shp2pgsql problem with very large .shp-files

[Stefan Zweig]

hi uwe,

there is large file support (ext3) on the unix machine the shp2pgsql is running. and as well i have tried opening the shapefile with another application (arcgis) as you suggested. it worked alright.

i would not be happy with splitting up the shapefile into pieces. that would be lots of non-automated work, because we have some of these very large shapefiles.


any other ideas?


> -----Ursprüngliche Nachricht-----
> Von: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Gesendet: 15.08.07 10:23:20
> An: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Betreff: Re: [postgis-users] shp2pgsql problem with very large .shp-files


> 
> Am 15.08.2007, 09:51 Uhr, schrieb Stefan Zweig <stefanzweig1881 at web.de>:
> 
> > hi list,
> >
> > i have a problem with the shp2pgsql program:
> >
> > this command:
> > /usr/local/pgsql/bin/shp2pgsql -s 4326 -c -I -D -k  
> > /var/gisapp/postgreexport/_G342.shp public._g342 >  
> > /var/gisapp/postgreexport/_g342.sql
> > works alright, no problems at all
> >
> > whereas this command:
> > /usr/local/pgsql/bin/shp2pgsql -s 4326 -c -I -D -k  
> > /var/gisapp/postgreexport/_G2681.shp public._g2681 >  
> > /var/gisapp/postgreexport/_g2681.sql
> > causes shp2pgsql to answer:
> >
> > "/var/gisapp/postgreexport/_G2681.shp: shape (.shp) or index files  
> > (.shx) can not be opened."
> >
> > ls -la in /var/gisapp/postgreexport/ says the following:
> >
> > -rwxrwxrwx  1 root     root    171848556 2007-08-14 18:38 _G2681.dbf
> > -rwxrwxrwx  1 root     root                143 2007-08-14 18:38  
> > _G2681.prj
> > -rwxrwxrwx  1 root     root  4565523268 2007-08-14 18:38 _G2681.shp
> > -rwxrwxrwx  1 root     root    124980820 2007-08-14 18:38 _G2681.shx
> > -rwxrwxrwx  1 root     root                308 2007-08-15 09:35 _G342.dbf
> > -rwxrwxrwx  1 root     root                143 2007-08-15 09:35 _G342.prj
> > -rwxrwxrwx  1 root     root                716 2007-08-15 09:35 _G342.shp
> > -rwxrwxrwx  1 root     root                276 2007-08-15 09:35 _G342.shx
> >
> >
> > so the only difference between shp-file _g2681 and shp-file _g342 is  
> > that _g2681 is an extremely big one. (and actually there is another  
> > difference: _G342.shp is a point shape, _g2681.shp is a line shape)
> >
> > any ideas?
> >
> > i appreciate any help, thanks in advance,
> >
> > stefan
> 
> 
> 
> Maybe this is a Problem of the filesystem or large file support. Does the  
> shapefile work in other applications? maybe there is a border in the  
> indexnumber, so that it cann't be opened.
> Maybe you can split your shape and import the pieces ;)
> 
> bye uwe
> 
> _____________________________________
> ingenieurbüro kauppert
> 
> nebeniusstr. 34
> d-76137 karlsruhe
> 
> fon   +49 721 3548969-3
> fax   +49 721 3548969-5
> 
> email uwe.seher at ib-kauppert.de
> web   www.ib-kauppert.de
> _____________________________________
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 


_____________________________________________________________________
Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
http://smartsurfer.web.de/?mc=100071&distributionid=000000000066