<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Carlos,<br>
<br>
Thanks for your explanation and suggestion. I ended up starting
fresh with the saunders_lines table using my preferred projection
for my area (FL Albers HARN, i.e. EPSG:3087) by creating a shapefile
with some dummy features in QGIS, imported that to Postgres using
the Spit tool in QGIS (setting the projection to 3087), and now QGIS
1.7 edits the data fine via WFS. Now back to OpenLayers...<br>
<br>
Thanks,<br>
Brian<br>
<br>
On 9/20/2011 10:53 AM, Carlos Ruiz wrote:
<blockquote
cite="mid:1316530439.18555.YahooMailNeo@web38201.mail.mud.yahoo.com"
type="cite">
<div style="color:#000; background-color:#fff; font-family:arial,
helvetica, sans-serif;font-size:10pt">
<div><span>Brian,</span></div>
<div><br>
<span></span></div>
<div><span>When you use the shp2pgsql utility, it adds to the
table some constraints to ensure that all the geometry
insertion/update will be of the same SRID, type and
dimension.</span></div>
<div><br>
</div>
<div>So, the definition<br>
</div>
<div><br>
<span></span></div>
<div style="font-family: Courier
New,courier,monaco,monospace,sans-serif;">ALTER TABLE
saunders_lines ADD CONSTRAINT enforce_srid_wkb_geometry CHECK
(srid(the_geom) = 900913);</div>
<div><br>
</div>
<div>ensures that the SRID of the geometry to insert/update will
always be 900913.</div>
<div><br>
</div>
<div>You can change the SRID of the geometry if you want to
using <span style="font-family: Courier
New,courier,monaco,monospace,sans-serif;">ST_TRANSFORM</span>,
but you first must drop the <span style="font-family: Courier
New,courier,monaco,monospace,sans-serif;">enforce_srid_wkb_geometry</span>
constraint and replace the new value in the postgis
spatial_columns table for the <span style="font-family:
Courier New,courier,monaco,monospace,sans-serif;">saunders_lines</span>
row.</div>
<div><br>
</div>
<div>The 900913 projection treats the earth as a sphere (this is
wrong) and handles the coordinates as X/Y instead as Lat/Lon.
You can transform your geometry to SRID 4326 which treats the
earth as a geoid, then the coordinates are Lat/Lon and there's
no problem with its definition.</div>
<div><br>
</div>
<div>Why don't you try this ?</div>
<div><br>
</div>
<div><font style="font-weight:bold;color:rgb(0, 96,
191);font-family:verdana, helvetica, sans-serif;" size="2">IC
Carlos Ruiz</font><br>
<br>
</div>
<div style="font-family: arial, helvetica, sans-serif;
font-size: 10pt;">
<div style="font-family: times new roman, new york, times,
serif; font-size: 12pt;"><font face="Arial" size="2">
<hr size="1"><b><span style="font-weight:bold;">From:</span></b>
Brian May <a class="moz-txt-link-rfc2396E" href="mailto:bmay@mapwise.com"><bmay@mapwise.com></a><br>
<b><span style="font-weight: bold;">To:</span></b> Carlos
Ruiz <a class="moz-txt-link-rfc2396E" href="mailto:boolean10001@yahoo.com"><boolean10001@yahoo.com></a>; TinyOWS users discuss
list <a class="moz-txt-link-rfc2396E" href="mailto:tinyows-users@lists.maptools.org"><tinyows-users@lists.maptools.org></a><br>
<b><span style="font-weight: bold;">Sent:</span></b>
Monday, September 19, 2011 9:33 PM<br>
<b><span style="font-weight: bold;">Subject:</span></b>
Re: [TinyOWS-users] Problem inserting features<br>
</font><br>
<div id="yiv292209939"> More on 900913 issues:<br>
<br>
Just for kicks I decided to install QGIS 1.7 - it will
make my life better, right? I go and open up my project
that I had been testing WFS-T with, test adding a line and
saving it - new problem - ERROR: new row for relation
"saunders_lines" violates check constraint
"enforce_srid_wkb_geometry"<br>
<br>
I didn't change anything. <br>
<br>
So, after checking out projection defs in different places
I find this:<br>
<br>
QGIS 1.7 definition of 900913<br>
+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0
+x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext
+over +no_defs<br>
<br>
QGIS 1.7 definition of 3785<br>
+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0
+x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs<br>
<br>
QGIS 1.7 3875 (new Google Mercator Standard)<br>
Not there!<br>
<br>
From WFS layer metadata (coming out of postgres)<br>
+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0
+x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext
+over +no_defs<br>
<br>
From postgres spatial_ref_sys table<br>
+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0
+x_0=0.0 +y_0=0 +units=m +k=1.0 +nadgrids=@null +no_defs<br>
<br>
End of a thread on the QGIS list discussing these EPSG
codes.<br>
<a moz-do-not-send="true" rel="nofollow"
class="yiv292209939moz-txt-link-freetext"
target="_blank"
href="http://www.osgeo.org/pipermail/qgis-developer/2010-February/009183.html">http://www.osgeo.org/pipermail/qgis-developer/2010-February/009183.html</a><br>
<br>
The constraint on my table for srid:<br>
ALTER TABLE saunders_lines<br>
ADD CONSTRAINT enforce_srid_wkb_geometry CHECK
(srid(the_geom) = 900913);<br>
<br>
So maybe I'm not making things easy on myself having the
data in 900913 (or one of its variants)? <br>
<br>
Brian<br>
<br>
On 9/19/2011 5:05 PM, Carlos Ruiz wrote:
<blockquote type="cite">
<div
style="color:#000;background-color:#fff;font-family:arial,
helvetica, sans-serif;font-size:10pt;">
<div><span>Brian,</span></div>
<div><br>
</div>
Just about the 900913 projection, maybe it is not
found in the spatial_ref_sys table, also in Mapserver
could be not found in proj4, so I suggest to try with
the EPSG:3857 which is the same for spherical
mercator.<br>
<div><span></span></div>
<div><br>
<span></span></div>
<div><span>Cheers from México<br>
</span></div>
<div> </div>
<div><font style="font-weight:bold;color:rgb(0, 96,
191);font-family:verdana, helvetica, sans-serif;"
size="2">IC Carlos Ruiz</font><br>
<br>
</div>
<div style="font-family:arial, helvetica,
sans-serif;font-size:10pt;">
<div style="font-family:times new roman, new york,
times, serif;font-size:12pt;"><font face="Arial"
size="2">
<hr size="1"><b><span style="font-weight:bold;">From:</span></b>
Brian May <a moz-do-not-send="true"
rel="nofollow"
class="yiv292209939moz-txt-link-rfc2396E"
ymailto="mailto:bmay@mapwise.com"
target="_blank" href="mailto:bmay@mapwise.com"><bmay@mapwise.com></a><br>
<b><span style="font-weight:bold;">To:</span></b>
TinyOWS users discuss list <a
moz-do-not-send="true" rel="nofollow"
class="yiv292209939moz-txt-link-rfc2396E"
ymailto="mailto:tinyows-users@lists.maptools.org"
target="_blank"
href="mailto:tinyows-users@lists.maptools.org"><tinyows-users@lists.maptools.org></a><br>
<b><span style="font-weight:bold;">Sent:</span></b>
Monday, September 19, 2011 3:22 PM<br>
<b><span style="font-weight:bold;">Subject:</span></b>
[TinyOWS-users] Problem inserting features<br>
</font><br>
<div id="yiv292209939"> Getting TinyOWS to work
has been a long and winding road - still no
success - and almost ready to give up. Here's
the latest on what I have tried and the results.<br>
<br>
I ended up trying it out on linux and got
further down the road, but different problems. I
compiled it from source from SVN. I can insert
features via QGIS and OpenLayers now, but the
inserted features do not have any geometry
(confirmed via checking out the table in
postgres). And I can see existing features in
QGIS that I manually added via a direct connect
to postgres, but not in OpenLayers! I have been
running down a lot of rabbit holes trying to get
this figured out, burning a lot of time and I
could really use some help. <br>
<br>
Also, I may have found a few bugs in the
process. For example, if you have two geometry
columns in your table, and do not inform tinyows
of the additional geometry column via the config
file, it produces a 500 error when testing from
the browser. Does tinyows expect the_geom vs.
wkb_geometry? Tried both and it seems to operate
the same, except when you have them both there
at the same time.<br>
<br>
I don't remember if this is in the docs, but you
must have a record in the geometry_columns table
for tinyows to recognize the layer at all - you
can have your config all set up right, and it
just won't show the layer as being available.<br>
<br>
If you change the geometry column name in your
table and the geometry column name in the
geometry_columns table don't match - doing
./tinyows --check produces the following error:<br>
row number 0 is out of range 0..-1<br>
tinyows: src/struct/buffer.c:254:
buffer_add_str: Assertion `str' failed.<br>
Aborted<br>
<br>
Is there any reason why having your data in
900913 projection would be a problem? Wasn't my
first choice, but I figured i could eliminate
projection problems that way since the map is in
900913.<br>
<br>
Also, not sure why, but after some change I
made, the url <a moz-do-not-send="true"
rel="nofollow" target="_blank"
href="http://192.168.2.105:9091/cgi-bin/tinyows?service=WFS&request=DescribeFeatureType&version=1.1.0&">http://myurl/cgi-bin/tinyows?service=WFS&request=DescribeFeatureType&version=1.1.0&</a>
is producing a much more terse output than
before. Haven't figured out what it is yet,
although if I take out my custom layer, and just
have the france demo, the verbose output comes
back.<br>
<br>
If its easier to help debug this, I can open it
up to the outside world temporarily. <br>
<br>
Any help would be greatly appreciated.<br>
<br>
Thanks,<br>
Brian<br>
</div>
<br>
_______________________________________________<br>
TinyOWS-users mailing list<br>
<a moz-do-not-send="true" rel="nofollow"
ymailto="mailto:TinyOWS-users@lists.maptools.org"
target="_blank"
href="mailto:TinyOWS-users@lists.maptools.org">TinyOWS-users@lists.maptools.org</a><br>
<a moz-do-not-send="true" rel="nofollow"
target="_blank"
href="http://lists.maptools.org/mailman/listinfo/tinyows-users">http://lists.maptools.org/mailman/listinfo/tinyows-users</a><br>
<br>
<br>
</div>
</div>
</div>
<br>
<fieldset class="yiv292209939mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
TinyOWS-users mailing list
<a moz-do-not-send="true" rel="nofollow" class="yiv292209939moz-txt-link-abbreviated" ymailto="mailto:TinyOWS-users@lists.maptools.org" target="_blank" href="mailto:TinyOWS-users@lists.maptools.org">TinyOWS-users@lists.maptools.org</a>
<a moz-do-not-send="true" rel="nofollow" class="yiv292209939moz-txt-link-freetext" target="_blank" href="http://lists.maptools.org/mailman/listinfo/tinyows-users">http://lists.maptools.org/mailman/listinfo/tinyows-users</a>
</pre>
</blockquote>
<br>
</div>
<br>
<br>
</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>