<div dir="auto">I tried changing the demo parcels layer to GeoPackage with ogr2ogr and it worked for me.<div dir="auto"><br></div><div dir="auto">I also I tried SpatiaLite, but identify returned ???? for all the fields. I suspect this is a case issue, but I didn't have time to check if changing the case in template would fix it.</div><div dir="auto"><br></div><div dir="auto">SpatiaLite might be case insensitive itself but it does present a case to MapServer and then MapServer passes that onto GeoMoose. MapServer and GeoMoose are both case sensitive.</div></div><br><div class="gmail_quote"><div dir="ltr">On Mon, Dec 10, 2018, 11:36 TC Haddad <<a href="mailto:tchaddad@gmail.com">tchaddad@gmail.com</a> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">Thanks, I think I am ok on the GM includes, but will play with the field name case. Everything I've seen says SQLite/SpatiaLite is case-insensitive...<br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">The GetFeatureInfo response is showing some sort of return, but it is not intelligible. <br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">Other things I've tried: <br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">- identifying the same data in GeoPacakge (identify fails in the same way), and <br></div><div class="gmail_default" style="font-size:large">- ESRI PGDB (identify succeeds, which is frustrating!)</div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large"><br></div></div><br><div class="gmail_quote"><div dir="ltr">On Mon, Dec 10, 2018 at 9:12 AM James Klassen <<a href="mailto:klassen.js@gmail.com" target="_blank" rel="noreferrer">klassen.js@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">One thing to check is if the case of the properties. Different formats have different conventions about lower/mixed/uppercase for the properties/field names.<div><br></div><div>If you look at the response to the GetFeatureInfo request is it showing data?</div><div><br></div><div>Another thing if you aren't using the standard GeoMoose includes, you might be missing the metadata block to enable all the WMS/WFS request types.</div></div><br><div class="gmail_quote"><div dir="ltr">On Mon, Dec 10, 2018 at 8:49 AM TC Haddad <<a href="mailto:tchaddad@gmail.com" target="_blank" rel="noreferrer">tchaddad@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">Does anyone have a successful GM3 example of enabling Identify on items in a SpatiaLite db?</div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">I have a working example in GM2 that I am trying to transfer to GM3, and everything I've tried is failing.</div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">The layer draws just fine, and there are no significant error messages, just no results.</div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">Layer def and Mapbook snippet below, SpatiaLite db was created in QGIS 2.18.<br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">---------------- fwd ---------------- >></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large"> LAYER<br> NAME 'points'<br> CONNECTIONTYPE ogr<br> CONNECTION "\data\points.sqlite"<br> DATA "points" <br> STATUS ON<br> TYPE POINT<br> PROJECTION<br> 'init=epsg:3857'<br> END <br> METADATA<br> 'ows_title' 'points'<br> 'ows_include_items' 'all'<br> 'gml_include_items' 'all'<br> END <br> LABELCACHE ON<br> LABELITEM 'SERVICELOC'<br> TEMPLATE 'foo.html'<br> CLASS<br> NAME "Service Locations" <br> STYLE<br> SYMBOL "square" <br> SIZE 8.0<br> OUTLINECOLOR 0 0 0<br> COLOR 0 0 255<br> END<br> LABEL<br> TYPE TRUETYPE<br> FONT vera_sans<br> SIZE 8<br> ANTIALIAS TRUE<br> WRAP ' '<br> COLOR 0 0 255<br> OUTLINECOLOR 255 255 255<br> BUFFER 4<br> MINFEATURESIZE auto<br> PARTIALS FALSE<br> POSITION uc<br> END<br> END<br> TOLERANCE 30<br> END<br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">++++++++++++++++++++</div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large"> <map-source name="points" type="mapserver"><br> <file>points.map</file><br> <layer name="points" status="off"><br> <template name="identify"><![CDATA[<br> <div><br> <div style="background-color:Gainsboro"><br> <b>Points</b><br> </div><br> <div class="item"><br> <label>Location Number:</label> {{ properties.LocNumber }}<br> </div><br> <div class="item"><br> <label>Location Street:</label> {{ properties.LocStreet }}<br> </div><br> <br> </div><br> ]]></template><br> </layer><br> <param name="FORMAT" value="image/png;bits=8"/><br> </map-source><br></div><br></div></div></div></div>
_______________________________________________<br>
Geomoose-users mailing list<br>
<a href="mailto:Geomoose-users@lists.osgeo.org" target="_blank" rel="noreferrer">Geomoose-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/geomoose-users" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/geomoose-users</a></blockquote></div>
</blockquote></div>
</blockquote></div>