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

[Obe, Regina]

I suppose you could try Ogr2Ogr to see if maybe that works or gives you more clues as to what could be wrong.
Hope that helps,
Regina 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Stefan Zweig
Sent: Wednesday, August 15, 2007 6:40 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] shp2pgsql problem with very large ..shp-files

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

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.