[postgis-users] shp2pgsql problem with very large .shp-files
Uwe Seher
uwe.seher at googlemail.com
Wed Aug 15 01:22:17 PDT 2007
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
_____________________________________
More information about the postgis-users
mailing list