[postgis-users] import SHP into postGIS - still error - but it is closer

[luca marletta]

this my notes about.

Try to adapt the below commands

# shp2pgsql –s <epsgcode> shapename.shp myschema.newtable > dump.sql
# iconv -f "ISO-8859-15" -t "UTF-8" roads.sql (if you need it!)
# psql -d dbname -U postgres -f dump.sql

with your cooding before load into postgis, on the sql file

luca

On 2/20/07, Maciej Skorczewski <maciej.skorczewski at procad.pl> wrote:
>
> hello again!
>
> so i start new database with latin2 encoding.
> ogr2ogr start generate table
>
> CREATE TABLE osienazwy
> (
>    ogc_fid serial NOT NULL,
>    wkb_geometry geometry,
>    id double precision,
>    idulicy double precision,
>    ulica character(30),
>    "pełna" character(100),
>    id1 double precision,
>    id2 double precision,
>    kier2 character(1),
>    length numeric(31,15),
>    idodcinka double precision,
>    CONSTRAINT osienazwy_pk PRIMARY KEY (ogc_fid),
>    CONSTRAINT enforce_dims_wkb_geometry CHECK (ndims(wkb_geometry) = 2),
>    CONSTRAINT enforce_geotype_wkb_geometry CHECK
> (geometrytype(wkb_geometry) = 'LINESTRING'::text OR wkb_geometry IS NULL),
>    CONSTRAINT enforce_srid_wkb_geometry CHECK (srid(wkb_geometry) = -1)
> )
> WITHOUT OIDS;
> ALTER TABLE osienazwy OWNER TO postgres;
>
>
> but after 4599 added row (shp file have about 15.000 row of street) i
> get error massage (look on url)
> http://img87.imageshack.us/img87/7464/mapabc9.jpg
>
>
> guestion: what can i do whit this?
>
> maciek
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


-- 
luca marletta
www.beopen.it