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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[email protected]> > Gesendet: 15.08.07 10:23:20 > An: "PostGIS Users Discussion" <[email protected]> > Betreff: Re: [postgis-users] shp2pgsql problem with very large ..shp-files > > Am 15.08.2007, 09:51 Uhr, schrieb Stefan Zweig <[EMAIL PROTECTED]>: > > > 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 [EMAIL PROTECTED] > web www.ib-kauppert.de > _____________________________________ > _______________________________________________ > postgis-users mailing list > [email protected] > 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 [email protected] 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. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
