<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Oliver (and others),<br>
<br>
Just to narrow down the question<br>
<br>
"Does TinyOWS support re-projection in transactions to a PostGIS
database?"<br>
<br>
and a little more background:<br>
<br>
My typical use-case is to store my data in PostGIS in a geographic
SRS such as EPSG:4326, but display (and edit) in EPSG:3857 (aka
900913).<br>
<br>
We're (the Geomoose PSC) in the process of releasing GeoMoose
v2.6 with a new JavaScript Feature Editor built on OpenLayers and
using WFS-T, and I'd like to document an example using TinyOWS as
the WFS-T server.<br>
<br>
If the answer is "No, TinyOWS does not support re-projection", then
I'll just document storing and editing the data in EPSG:3857.<br>
<br>
<pre class="moz-signature" cols="72">Best Regards,
Brent Fraser</pre>
<br>
On 2/15/2012 9:08 AM, Brent Fraser wrote:
<blockquote cite="mid:4F3BD883.2010000@geoanalytic.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Oliver,<br>
<br>
Geomoose's Feature Editor is JavaScript built on top of
OpenLayers' WFS-T support. Here's the line from the TinyOWS log<br>
<br>
[Wed Feb 15 08:39:17 2012] [QUERY] <wfs:Transaction xmlns:wfs=<a
moz-do-not-send="true" class="moz-txt-link-rfc2396E"
href="http://www.opengis.net/wfs">"http://www.opengis.net/wfs"</a>
service="WFS" version="1.1.0" xsi:schemaLocation=<a
moz-do-not-send="true" class="moz-txt-link-rfc2396E"
href="http://www.opengis.net/wfshttp://schemas.opengis.net/wfs/1.1.0/wfs.xsdhttp://thinkcentre1/cgi-bin/tinyows.exehttp://thinkcentre1/cgi-bin/tinyows.exe?service=WFS&amp;version=1.1.0&amp;request=DescribeFeatureType&amp;TypeName=censuscities">"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"</a>
xmlns:xsi=<a moz-do-not-send="true" class="moz-txt-link-rfc2396E"
href="http://www.w3.org/2001/XMLSchema-instance">"http://www.w3.org/2001/XMLSchema-instance"</a>><wfs:Update
typeName="feature:censuscities" xmlns:feature=<a
moz-do-not-send="true" class="moz-txt-link-rfc2396E"
href="http://thinkcentre1/cgi-bin/tinyows.exe">"http://thinkcentre1/cgi-bin/tinyows.exe"</a>><wfs:Property><wfs:Name>the_geom</wfs:Name><wfs:Value><gml:MultiSurface
xmlns:gml=<a moz-do-not-send="true" class="moz-txt-link-rfc2396E"
href="http://www.opengis.net/gml">"http://www.opengis.net/gml"</a>
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>&
lt;/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=<a moz-do-not-send="true" class="moz-txt-link-rfc2396E"
href="http://www.opengis.net/ogc">"http://www.opengis.net/ogc"</a>><ogc:FeatureId
fid="censuscities.806"/></ogc:Filter></wfs:Update></wfs:Transaction><br>
<br>
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:<br>
<br>
[Wed Feb 15 08:39:17 2012] [ERROR] ERROR: new row for relation
"censuscities" violates check constraint "enforce_srid_the_geom"<br>
<br>
But I could be wrong; I'm new to WFS-T and TinyOWS, and my
knowledge of PostGIS is shallow...<br>
<pre class="moz-signature" cols="72">Best Regards,
Brent Fraser</pre>
<br>
On 2/15/2012 3:05 AM, Olivier Courtin wrote:
<blockquote
cite="mid:CAD+A4Nz=c-w0sDOmuPLxv4G_r7a9=52LdmqBFQTjqp8ioFo_dg@mail.gmail.com"
type="cite">On Tue, Feb 14, 2012 at 1:10 AM, Brent Fraser <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:bfraser@geoanalytic.com">bfraser@geoanalytic.com</a>></span>
wrote:<br>
<div class="gmail_quote"><br>
Brent,<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> 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.<br>
</div>
</blockquote>
<div><br>
Humm i don't know anything about Feature Editor,<br>
and anyway, hat is the exact WFS request query sended to
TinyOWS ?<br>
(you could use TinyOWS log to grab it) <br>
</div>
</div>
<br>
--<br>
Olivier<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
TinyOWS-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:TinyOWS-users@lists.maptools.org">TinyOWS-users@lists.maptools.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.maptools.org/mailman/listinfo/tinyows-users">http://lists.maptools.org/mailman/listinfo/tinyows-users</a>
</pre>
</blockquote>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
TinyOWS-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:TinyOWS-users@lists.maptools.org">TinyOWS-users@lists.maptools.org</a>
<a class="moz-txt-link-freetext" href="http://lists.maptools.org/mailman/listinfo/tinyows-users">http://lists.maptools.org/mailman/listinfo/tinyows-users</a>
</pre>
</blockquote>
</body>
</html>