<html><body><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 <bmay@mapwise.com><br><b><span style="font-weight: bold;">To:</span></b> Carlos Ruiz <boolean10001@yahoo.com>; TinyOWS users discuss list <tinyows-users@lists.maptools.org><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 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 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 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 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 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 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 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 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></body></html>