[postgis-users] import SHP into postGIS - still error - but it is closer
Maciej Skorczewski
maciej.skorczewski at procad.pl
Tue Feb 20 00:14:47 PST 2007
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
More information about the postgis-users
mailing list