<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>GetFeatureInfo doesn't take any query parameters that are case
sensitive, but it's response contains field names. GeoMoose cares
about the case of those field names matching the template (in the
mapbook) and any other place they are used. Different data
sources to MapServer have different defaults for how they handle
the case of field names.<br>
</p>
<p>For example, in the mapbook (or GeoMoose remote template):<br>
</p>
<p>{{ properties.pin }} is not the same as {{ properties.PIN }} and
to work it must match the field name as it is returned by
MapServer. If it doesn't, the field will be shown as "???".</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 12/10/18 12:48 PM, TC Haddad wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAFVrPyhhiZCg9d-kvWN6VsfySNZJSQbiYZtMVD8UWWU_pjbr2Q@mail.gmail.com">
<div dir="ltr">
<div class="gmail_default"><br>
</div>
<div class="gmail_default">Thanks - I'll experiment a bit more.
Case doesn't seem to be having an impact.<br>
</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default">What's confusing is that the
GetFeatureInfo request doesn't use anything that would be
case-sensitive, and my map file is set to return all fields,
regardless of field name. <br>
</div>
<div class="gmail_default"><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr">On Mon, Dec 10, 2018 at 9:45 AM James Klassen
<<a href="mailto:klassen.js@gmail.com"
moz-do-not-send="true">klassen.js@gmail.com</a>> wrote:<br>
</div>
<blockquote class="gmail_quote">
<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" target="_blank"
moz-do-not-send="true">tchaddad@gmail.com</a> wrote:<br>
</div>
<blockquote class="gmail_quote">
<div dir="ltr">
<div class="gmail_default"><br>
</div>
<div class="gmail_default">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"><br>
</div>
<div class="gmail_default">The GetFeatureInfo response
is showing some sort of return, but it is not
intelligible. <br>
</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default">Other things I've tried: <br>
</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default">- identifying the same data
in GeoPacakge (identify fails in the same way), and <br>
</div>
<div class="gmail_default">- ESRI PGDB (identify
succeeds, which is frustrating!)</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default"><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"
rel="noreferrer" target="_blank"
moz-do-not-send="true">klassen.js@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote">
<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"
rel="noreferrer" target="_blank"
moz-do-not-send="true">tchaddad@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div class="gmail_default"><br>
</div>
<div class="gmail_default">Does anyone
have a successful GM3 example of
enabling Identify on items in a
SpatiaLite db?</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default">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"><br>
</div>
<div class="gmail_default">The layer draws
just fine, and there are no significant
error messages, just no results.</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default">Layer def and
Mapbook snippet below, SpatiaLite db was
created in QGIS 2.18.<br>
</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default">----------------
fwd ---------------- >></div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default"> 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"><br>
</div>
<div class="gmail_default">++++++++++++++++++++</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default">
<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"
rel="noreferrer" target="_blank"
moz-do-not-send="true">Geomoose-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/geomoose-users"
rel="noreferrer noreferrer" target="_blank"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/geomoose-users</a></blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</body>
</html>