<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="GENERATOR" content="MSHTML 8.00.6001.19400">
</head>
<body>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Verdana"><span class="999235021-26022013">As a follow up why can't I run:</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Verdana"><span class="999235021-26022013"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Verdana"><span class="999235021-26022013">-sql "select id, ST_SimplifyPreserveTopology(shape, 0.005) from \"v:x1571\" :</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Verdana"><span class="999235021-26022013"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Verdana"><span class="999235021-26022013">for my SQLITE SQL?</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Verdana"><span class="999235021-26022013"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Verdana"><span class="999235021-26022013">I get a message back saying:</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Verdana"><span class="999235021-26022013"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Verdana"><span class="999235021-26022013">ERROR 1: Undefined function 'ST_SimplifyPreserveTopology' used</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Verdana"><span class="999235021-26022013"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Verdana"><span class="999235021-26022013">I also tired just SimplifyPreserveTopology. Same result.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Verdana"><span class="999235021-26022013"></span></font> </div>
<span class="999235021-26022013">
<div dir="ltr" align="left"><span class="768544321-26022013"><font face="Verdana"><font size="2"><span class="999235021-26022013"><font color="#0000ff">When I put debug on and I don't use the spatialite function it says:</font></span></font></font></span></div>
<div dir="ltr" align="left"><span class="768544321-26022013"><font face="Verdana"><font color="#0000ff" size="2"><span class="999235021-26022013"></span></font></font></span> </div>
<div dir="ltr" align="left"><span class="768544321-26022013"><font face="Verdana"><font color="#0000ff" size="2"><span class="999235021-26022013">SQLITE: SpatiaLite DB found !<br>
OGR: Unloading VirtualOGR module<br>
</div>
<div></span></font></font></span><span class="768544321-26022013"><font face="Verdana"><font color="#0000ff" size="2"><span class="999235021-26022013"></span></font></font></span> </div>
<div><span class="768544321-26022013"><font face="Verdana"><font color="#0000ff" size="2"><span class="999235021-26022013">Which makes me think I have spatialite support.</span></font></font></span></div>
<div><span class="768544321-26022013"><font face="Verdana"><font color="#0000ff" size="2"><span class="999235021-26022013"></span></font></font></span> </div>
<div><span class="768544321-26022013"><font face="Verdana"><font color="#0000ff" size="2"><span class="999235021-26022013">Here my
<span class="768544321-26022013"><font face="Verdana"><font color="#0000ff" size="2"><span class="999235021-26022013">gdal-config --dep-libs</span></font></font></span>:</span></font></font></span></div>
<div><span class="768544321-26022013"><font face="Verdana"><font color="#0000ff" size="2"><span class="999235021-26022013"></span></font></font></span> </div>
<div><span class="768544321-26022013"><font face="Verdana"><font color="#0000ff" size="2"><span class="999235021-26022013">-L/usr/lib -lgeos_c -lodbc -lodbcinst -lexpat -lxerces-c -lpthread -ljasper -lnetcdf -lhdf5 -lmfhdfalt -ldfalt -lgif -ljpeg -lpng -L/usr/lib
-lpq -lz -lpthread -lm -lrt -ldl -lspatialite -L/usr/lib/x86_64-linux-gnu -lcurl -Wl,-Bsymbolic-functions -Wl,-z,relro -L/usr/lib -lNCSEcw -lNCSEcwC -lNCSCnet -lNCSUtil -L/opt/FileGDB_API/lib -lFileGDBAPI -L/usr/lib -lxml2</span></font></font></span></span></div>
<div dir="ltr" align="left"><span class="999235021-26022013"><span class="768544321-26022013"><font face="Verdana"><font color="#0000ff" size="2"><span class="999235021-26022013"></span></font></font></span>
<div><span class="768544321-26022013"><font face="Verdana"><font color="#0000ff" size="2"><span class="999235021-26022013"></span></font></font></span></span> </div>
</div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Verdana"><span class="999235021-26022013">I'm running GDAL trunk from about mid last week.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Verdana"><span class="999235021-26022013"></span></font><font color="#0000ff" size="2" face="Verdana"><span class="999235021-26022013"></span></font> </div>
<div dir="ltr" align="left">
<hr tabindex="-1">
</div>
<div dir="ltr" align="left"><font size="2" face="Tahoma"><b>From:</b> gdal-dev-bounces@lists.osgeo.org [mailto:gdal-dev-bounces@lists.osgeo.org]
<b>On Behalf Of </b>Jeremy Palmer<br>
<b>Sent:</b> Wednesday, 27 February 2013 10:49 a.m.<br>
<b>To:</b> gdal-dev@lists.osgeo.org<br>
<b>Subject:</b> [gdal-dev] ogr WFS GML parse error with WFS 1.1.0<br>
</font><br>
</div>
<blockquote style="MARGIN-RIGHT: 0px">
<div></div>
<div><font size="2" face="Verdana"><span class="768544321-26022013">When use WFS to pull a large GML object it fails:</span></font></div>
<div><font size="2" face="Verdana"><span class="768544321-26022013"></span></font> </div>
<div><font size="2" face="Verdana"><span class="768544321-26022013">ogrinfo -dialect sqlite -sql "select id, shape from \"v:x1571\" WHERE id = 3241251" WFS:'http://wfs.data.linz.govt.nz/84f646e35be34843abd9cee6085b50d6/v/x1571/wfs'<br>
</span></font></div>
<div><font size="2" face="Verdana"><span class="768544321-26022013">ERROR 1: XML parsing of GML file failed : mismatched tag at line 2, column 3621825</span></font></div>
<div><font size="2" face="Verdana"><span class="768544321-26022013"></span></font> </div>
<div><font size="2" face="Verdana"><span class="768544321-26022013">data parses fine in chrome:</span></font></div>
<div><font size="2" face="Verdana"><span class="768544321-26022013"></span></font> </div>
<div><font size="2" face="Verdana"><span class="768544321-26022013"><a href="http://wfs.data.linz.govt.nz/84f646e35be34843abd9cee6085b50d6/v/x1571/wfs?SERVICE=WFS&VERSION=1.1.0&REQUEST=GetFeature&TYPENAME=v:x1571&FILTER=%3CFilter%20xmlns%3D%22http:%2F%2Fwww.opengis.net%2Fogc%22%20xmlns:v%3D%22http:%2F%2Fdata.linz.govt.nz%2Fns%2Fv%22%20xmlns:gml%3D%22http:%2F%2Fwww.opengis.net%2Fgml%22%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Eid%3C%2FPropertyName%3E%3CLiteral%3E3241251%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3C%2FFilter%3E">http://wfs.data.linz.govt.nz/84f646e35be34843abd9cee6085b50d6/v/x1571/wfs?SERVICE=WFS&VERSION=1.1.0&REQUEST=GetFeature&TYPENAME=v:x1571&FILTER=%3CFilter%20xmlns%3D%22http:%2F%2Fwww.opengis.net%2Fogc%22%20xmlns:v%3D%22http:%2F%2Fdata.linz.govt.nz%2Fns%2Fv%22%20xmlns:gml%3D%22http:%2F%2Fwww.opengis.net%2Fgml%22%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Eid%3C%2FPropertyName%3E%3CLiteral%3E3241251%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3C%2FFilter%3E</a></span></font></div>
<div><font size="2" face="Verdana"><span class="768544321-26022013"></span></font> </div>
<div><font size="2" face="Verdana"><span class="768544321-26022013"></span></font> </div>
<div><font size="2" face="Verdana"><span class="768544321-26022013">However if I force WFS 1.0.0 it works:</span></font></div>
<div><font size="2" face="Verdana"><span class="768544321-26022013"></span></font> </div>
<div><font size="2" face="Verdana"><span class="768544321-26022013"><span class="768544321-26022013">ogrinfo -dialect sqlite -sql "select id, shape from \"v:x1571\" WHERE id = 3241251" WFS:'http://wfs.data.linz.govt.nz/84f646e35be34843abd9cee6085b50d6/v/x1571/wfs?VERSION=1.0.0'<br>
</span></span></font></div>
<div><font size="2" face="Verdana"><span class="768544321-26022013">Any ideas? Maybe axis order issue?</span></font></div>
<div><font size="2" face="Verdana"><span class="768544321-26022013"></span></font> </div>
<div><font size="2" face="Verdana"><span class="768544321-26022013">Here's my command run with debug on:</div>
</span></font>
<div><font size="2" face="Verdana"><span class="768544321-26022013"></span></font> </div>
<div><font size="2" face="Verdana"><span class="768544321-26022013"><a href="https://gist.github.com/palmerj/958f64ea6601c906235e">https://gist.github.com/palmerj/958f64ea6601c906235e</a></span></font></div>
<div><font size="2" face="Verdana"><span class="768544321-26022013"></span></font> </div>
</blockquote>
<br>
<hr>
<font face="Verdana" color="Black" size="2">This message contains information, which is confidential and may be subject to legal privilege. If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy this message. If you
have received this message in error, please notify us immediately (Phone 0800 665 463 or info@linz.govt.nz) and destroy the original message. LINZ accepts no responsibility for changes to this email, or for any attachments, after its transmission from LINZ.
Thank You.<br>
</font>
</body>
</html>