<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hey Jeff,<br>
<br>
I've been successful with the Geomoose demo in using WFS-t to
delete, modify and create "census_city" features, and to save these
changes back to PostGIS (<b>Woohoo!</b>). I'll have to edit our doc
on the configuration (and file a couple of issues), but the main
points are:<br>
<br>
1. Add controls to the Census Cities layer in mapbook.xml:<br>
<tt> <layer title="Census Cities" activate="true"
src="census_cities" fade="false" unfade="false" metadata="false"
legend="false" draw-point="false" draw-line="false"
draw-polygon="true" edit-attributes="true" edit-shape="true"
remove-feature="true" remove-all-features="true"
buffer="true"></layer> </tt><br>
<br>
2. Add "auto:true" to the save strategy in GeoMoose's WFS.js (line
36):<br>
<tt> this.save_strategy = new OpenLayers.Strategy.Save(<b>{auto:true}</b>);</tt><br>
- this means that when you unselect the feature after editing
the changes will be automatically saved<br>
<br>
3. Also in WFS.js, change line 44 to be:<br>
<tt>projection:<b> this.srsName</b>, // new
OpenLayers.Projection(CONFIGURATION.projection),</tt><br>
and in the mapbook add srs="EPSG:4269" to the mapsource:<br>
<tt> <map-source name="census_cities" type="wfs"
active="true" <b> srs="EPSG:4269"</b>> </tt><br>
- this causes OpenLayers to re-project the feature's geometry
before passing it to TinyOWS (I don't think TinyOWS does
re-projection).<br>
<br>
4. Set <br>
<tt> <b>check_schema="0</b>" </tt><br>
in the TinyOWS config.xml file. There are some schema problems I
need to track down, but this works for now.<br>
<br>
5. When you create the table in PostGIS using ogr2ogr, make sure it
creates it with geometry type of POLYGON by including <tt>"<b>-nlt
POLYGON</b>"</tt>, otherwise the type is MULTIPOLYGON and
PostGIS complains when TinyOWS tries to insert a POLYGON.<br>
<br>
And thanks again for your TinyOWS demo; without that to confirm
TinyOWS does actually work, I think I would have lost my enthusiasm
...<br>
<br>
<pre class="moz-signature" cols="72">Best Regards,
Brent Fraser</pre>
<div class="moz-cite-prefix">On 3/13/2016 12:25 PM, Jeff McKenna
wrote:<br>
</div>
<blockquote cite="mid:56E5B094.7050802@gatewaygeomatics.com"
type="cite">Hi Brent,
<br>
<br>
In my debugging while setting up this demo, I made sure to examine
the full WFS request sent (the example request you gave wasn't the
full request, I think you clicked on the wrong tab in developer
tools, likely the "Preview" tab by mistake; instead, in your
network tab, click on the 'tinyows.exe' request, which you already
did, but look at the bottom of the 'Headers' tab, there you can
see the full request sent, such as:
<br>
<br>
<wfs:Transaction xmlns:wfs=<a class="moz-txt-link-rfc2396E" href="http://www.opengis.net/wfs">"http://www.opengis.net/wfs"</a>
service="WFS" version="1.1.0"
xmlns:xsi=<a class="moz-txt-link-rfc2396E" href="http://www.w3.org/2001/XMLSchema-instance">"http://www.w3.org/2001/XMLSchema-instance"</a>
xsi:schemaLocation=<a class="moz-txt-link-rfc2396E" href="http://www.opengis.net/wfshttp://schemas.opengis.net/wfs/1.1.0/wfs.xsdhttp://www.tinyows.org/http://127.0.0.1/cgi-bin/tinyows.exe?service=wfs&request=DescribeFeatureType&version=1.1.0&typename=tows:frida">"http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.1.0/wfs.xsd
http://www.tinyows.org/
http://127.0.0.1/cgi-bin/tinyows.exe?service=wfs&request=DescribeFeatureType&version=1.1.0&typename=tows:frida"</a>><wfs:Insert><feature:frida
xmlns:feature=<a class="moz-txt-link-rfc2396E" href="http://www.tinyows.org/">"http://www.tinyows.org/"</a>><feature:geom><gml:MultiSurface
xmlns:gml=<a class="moz-txt-link-rfc2396E" href="http://www.opengis.net/gml">"http://www.opengis.net/gml"</a>
srsName="EPSG:31467"><gml:surfaceMember><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList>3442019.5
5793338.125 3443987.5 5793362.125 3443147.5 5792762.125 3442475.5
5792978.125 3441323.5 5792570.125 3441155.5 5793386.125 3442019.5
5793338.125</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember></gml:MultiSurface></feature:geom></feature:frida></wfs:Insert></wfs:Transaction>
<br>
<br>
<br>
-jeff
<br>
<br>
<br>
<br>
</blockquote>
<br>
</body>
</html>