Hello everyone,
I have a question please and hope someone can help. I have a table with the
following structure:
*CREATE TABLE table1 (*
* "id" integer DEFAULT nextval('id_seq'::regclass) NOT NULL,*
* name character varying,*
* geom geometry,*
* geom_kml text,*
* CONSTRAINT enforce_dims_geom CHECK ((st_ndims(geom) = 2)),*
* CONSTRAINT enforce_geotype_geom CHECK (((geometrytype(geom) =
'POLYGON'::text) OR (geom IS NULL))),*
CONSTRAINT *enforce_srid_geom* CHECK ((st_srid(geom) = (-1))));
So the table has a geom column and a column to store the KML text besides
name and id. I want the geom field to store a polygon from the KML column.
So first I inserted id, name, and KML as text and geom as NULL. Than I ran
the below update SQL statement:
*Update table1 set geom
=
st_geomfromkml('<Polygon><outerBoundaryIs><LinearRing><coordinates>39.788212,21.424540
........
39.788212,21.424540</coordinates></LinearRing></outerBoundaryIs></Polygon>');
*
But an error appears that this conflicts with
*enforce_srid_geom*constraint. I removed it and I was able to update
the geom column but it
really does not make sense. The geom I am trying to insert does not
conflict with the constraints. I created the kml polygon in Google Earth
and the srid for that is -1. Please help :)
*---------------------------------------------------------------------------
*
*Ahmad Aburizaiza*
*PhD student at George Mason University*
*Geography and Geoinformation Science Department*
*Fairfax, VA, USA*
*Tel : +1-703-981-0354*
*
*
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
