[TinyOWS-users] Does TinyOWS do reprojection?

[Brent Fraser]

Oliver,

   Geomoose's Feature Editor is JavaScript built on top of OpenLayers' 
WFS-T support.  Here's the line from the TinyOWS log

[Wed Feb 15 08:39:17 2012] [QUERY] <wfs:Transaction 
xmlns:wfs="http://www.opengis.net/wfs" service="WFS" version="1.1.0" 
xsi:schemaLocation="http://www.opengis.net/wfs 
http://schemas.opengis.net/wfs/1.1.0/wfs.xsd 
http://thinkcentre1/cgi-bin/tinyows.exe 
http://thinkcentre1/cgi-bin/tinyows.exe?service=WFS&amp;version=1.1.0&amp;request=DescribeFeatureType&amp;TypeName=censuscities" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><wfs:Update 
typeName="feature:censuscities" 
xmlns:feature="http://thinkcentre1/cgi-bin/tinyows.exe"><wfs:Property><wfs:Name>the_geom</wfs:Name><wfs:Value><gml:MultiSurface 
xmlns:gml="http://www.opengis.net/gml" 
srsName="EPSG:3857"><gml:surfaceMember><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList>-10356035 
5547218 -10356358.189312972 5548684.080055897 -10354924 5548340 
-10354228 5548341 -10353753 5548338 -10353752 5548272 -10353744 5547729 
-10353740 5547434 -10353737 5547256 -10353738 5547232 -10353738 5547220 
-10353785 5546732 -10353784 5546689 -10353783 5546674 -10353763 5546063 
-10353766 5546000 -10353799 5545999 -10353909 5545996 -10354159 5546030 
-10354246 5546041 -10354315 5546049 -10354339 5546049 -10354887 5546037 
-10354900 5546039 -10354971 5546046 -10355981 5546070 -10356034 5546069 
-10356034 5546119 -10356035 5546523 -10356035 5546587 -10356036 5546723 
-10356035 5546769 -10356035 5546789 -10356031 5546972 -10356032 5547043 
-10356035 
5547218</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember></gml:MultiSurface></wfs:Value></wfs:Property><wfs:Property><wfs:Name>statefp10</wfs:Name><wfs:Value>27</wfs:Value></wfs:Property><wfs:Property><wfs:Name>placefp10</wfs:Name><wfs:Value>53098</wfs:Value></wfs:Property><wfs:Property><wfs:Name>placens10</wfs:Name><wfs:Value>02396316</wfs:Value></wfs:Property><wfs:Property><wfs:Name>geoid10</wfs:Name><wfs:Value>2753098</wfs:Value></wfs:Property><wfs:Property><wfs:Name>name10</wfs:Name><wfs:Value>Randolph</wfs:Value></wfs:Property><wfs:Property><wfs:Name>namelsad10</wfs:Name><wfs:Value>Randolph 
city</wfs:Value></wfs:Property><wfs:Property><wfs:Name>lsad10</wfs:Name><wfs:Value>25</wfs:Value></wfs:Property><wfs:Property><wfs:Name>classfp10</wfs:Name><wfs:Value>C5</wfs:Value></wfs:Property><wfs:Property><wfs:Name>pcicbsa10</wfs:Name><wfs:Value>N</wfs:Value></wfs:Property><wfs:Property><wfs:Name>pcinecta10</wfs:Name><wfs:Value>N</wfs:Value></wfs:Property><wfs:Property><wfs:Name>mtfcc10</wfs:Name><wfs:Value>G4110</wfs:Value></wfs:Property><wfs:Property><wfs:Name>funcstat10</wfs:Name><wfs:Value>A</wfs:Value></wfs:Property><wfs:Property><wfs:Name>aland10</wfs:Name><wfs:Value>2477617</wfs:Value></wfs:Property><wfs:Property><wfs:Name>awater10</wfs:Name><wfs:Value>182190</wfs:Value></wfs:Property><wfs:Property><wfs:Name>intptlat10</wfs:Name><wfs:Value>+44.5251562</wfs:Value></wfs:Property><wfs:Property><wfs:Name>intptlon10</wfs:Name><wfs:Value>-093.0193333</wfs:Value></wfs:Property><ogc:Filter 
xmlns:ogc="http://www.opengis.net/ogc"><ogc:FeatureId 
fid="censuscities.806"/></ogc:Filter></wfs:Update></wfs:Transaction>

     The coordinates in the GML polygon are indeed EPSG:3857.  That is 
my display/edit projection in OpenLayers so nothing unexpected there.  
My expectation is that TinyOWS would create an UPDATE query containing 
the PostGIS ST_Transform() function to transform the geometry from 
EPSG:3857 to EPSG:4269 (my storage SRS).  But it doesn't, and it doesn't 
even specify any SRS for the geometry, so the UPDATE fails with:

[Wed Feb 15 08:39:17 2012] [ERROR] ERROR:  new row for relation 
"censuscities" violates check constraint "enforce_srid_the_geom"

But I could be wrong; I'm new to WFS-T and TinyOWS, and my knowledge of 
PostGIS is shallow...

Best Regards,
Brent Fraser


On 2/15/2012 3:05 AM, Olivier Courtin wrote:
> On Tue, Feb 14, 2012 at 1:10 AM, Brent Fraser <bfraser at geoanalytic.com 
> <mailto:bfraser at geoanalytic.com>> wrote:
>
> Brent,
>
>     I'm alpha testing the new Feature Editor within GeoMoose v2.6.  It
>     is a JavaScript application using OpenLayers 2.11, MS4W 3, and
>     PostGIS 1.5 at the backend.
>
>
> Humm i don't know anything about Feature Editor,
> and anyway, hat is the exact WFS request query sended to TinyOWS ?
> (you could use TinyOWS log to grab it)
>
> --
> Olivier
>
>
> _______________________________________________
> TinyOWS-users mailing list
> TinyOWS-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/tinyows-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/tinyows-users/attachments/20120215/a7309418/attachment.htm