Thanks a lot to both of you. I changed the SRID to 4326 and it is working. *--------------------------------------------------------------------------- Ahmad Aburizaiza PhD student at George Mason University Geography and Geoinformation Science Department Fairfax, VA, USA Tel : +1-703-981-0354*
On Fri, Feb 24, 2012 at 7:41 AM, Paragon Corporation <l...@pcorp.us> wrote: > Ahmad, > > The question I have for you is why you have your srid as -1. > > KML spatial_ref is ALWAYS 4326 so I expect any ST_GeomFromKML to come back > as srid = 4326. You can't create a KML file that is not 4326 (WGS 84) as I > recall. If you were able to in the past, > then that's a mistake and perhaps that was corrected in 2.0. > > > > -----Original Message----- > > From: postgis-users-boun...@postgis.refractions.net > > [mailto:postgis-users-boun...@postgis.refractions.net] On > > Behalf Of Sandro Santilli > > Sent: Friday, February 24, 2012 3:13 AM > > To: PostGIS Users Discussion > > Subject: Re: [postgis-users] st_geomfromkml problem > > > > On Thu, Feb 23, 2012 at 09:17:11PM -0500, Ahmad Aburizaiza wrote: > > > > > 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></Poly > > > gon>'); > > > * > > > > > > > > > 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 > > > :) > > > > Did you upgrade from 1.x to 2.0 ? > > If you did you probably did it too early, or not using the > > correct method (hard upgrade). > > In 2.0 any negative SRID gets converted to 0 so you'll never > > meet the check for -1. The hard upgrade procedure updates > > that constraint. > > > > --strk; > > > > ,------o-. > > | __/ | Delivering high quality PostGIS 2.0 ! > > | / 2.0 | http://strk.keybit.net - http://vizzuality.com > > `-o------' > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users