[Geomoose-users] GM3 identify items in SpatiaLite db?
TC Haddad
tchaddad at gmail.com
Mon Dec 10 10:48:06 PST 2018
Thanks - I'll experiment a bit more. Case doesn't seem to be having an
impact.
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.
On Mon, Dec 10, 2018 at 9:45 AM James Klassen <klassen.js at gmail.com> wrote:
> I tried changing the demo parcels layer to GeoPackage with ogr2ogr and it
> worked for me.
>
> 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.
>
> 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.
>
> On Mon, Dec 10, 2018, 11:36 TC Haddad <tchaddad at gmail.com wrote:
>
>>
>> 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...
>>
>> The GetFeatureInfo response is showing some sort of return, but it is not
>> intelligible.
>>
>> Other things I've tried:
>>
>> - identifying the same data in GeoPacakge (identify fails in the same
>> way), and
>> - ESRI PGDB (identify succeeds, which is frustrating!)
>>
>>
>>
>> On Mon, Dec 10, 2018 at 9:12 AM James Klassen <klassen.js at gmail.com>
>> wrote:
>>
>>> 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.
>>>
>>> If you look at the response to the GetFeatureInfo request is it showing
>>> data?
>>>
>>> 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.
>>>
>>> On Mon, Dec 10, 2018 at 8:49 AM TC Haddad <tchaddad at gmail.com> wrote:
>>>
>>>>
>>>> Does anyone have a successful GM3 example of enabling Identify on items
>>>> in a SpatiaLite db?
>>>>
>>>> I have a working example in GM2 that I am trying to transfer to GM3,
>>>> and everything I've tried is failing.
>>>>
>>>> The layer draws just fine, and there are no significant error messages,
>>>> just no results.
>>>>
>>>> Layer def and Mapbook snippet below, SpatiaLite db was created in QGIS
>>>> 2.18.
>>>>
>>>>
>>>>
>>>> ---------------- fwd ---------------- >>
>>>>
>>>> LAYER
>>>> NAME 'points'
>>>> CONNECTIONTYPE ogr
>>>> CONNECTION "\data\points.sqlite"
>>>> DATA "points"
>>>> STATUS ON
>>>> TYPE POINT
>>>> PROJECTION
>>>> 'init=epsg:3857'
>>>> END
>>>> METADATA
>>>> 'ows_title' 'points'
>>>> 'ows_include_items' 'all'
>>>> 'gml_include_items' 'all'
>>>> END
>>>> LABELCACHE ON
>>>> LABELITEM 'SERVICELOC'
>>>> TEMPLATE 'foo.html'
>>>> CLASS
>>>> NAME "Service Locations"
>>>> STYLE
>>>> SYMBOL "square"
>>>> SIZE 8.0
>>>> OUTLINECOLOR 0 0 0
>>>> COLOR 0 0 255
>>>> END
>>>> LABEL
>>>> TYPE TRUETYPE
>>>> FONT vera_sans
>>>> SIZE 8
>>>> ANTIALIAS TRUE
>>>> WRAP ' '
>>>> COLOR 0 0 255
>>>> OUTLINECOLOR 255 255 255
>>>> BUFFER 4
>>>> MINFEATURESIZE auto
>>>> PARTIALS FALSE
>>>> POSITION uc
>>>> END
>>>> END
>>>> TOLERANCE 30
>>>> END
>>>>
>>>> ++++++++++++++++++++
>>>>
>>>> <map-source name="points" type="mapserver">
>>>> <file>points.map</file>
>>>> <layer name="points" status="off">
>>>> <template name="identify"><![CDATA[
>>>> <div>
>>>> <div style="background-color:Gainsboro">
>>>> <b>Points</b>
>>>> </div>
>>>> <div class="item">
>>>> <label>Location Number:</label> {{
>>>> properties.LocNumber }}
>>>> </div>
>>>> <div class="item">
>>>> <label>Location Street:</label> {{
>>>> properties.LocStreet }}
>>>> </div>
>>>>
>>>> </div>
>>>> ]]></template>
>>>> </layer>
>>>> <param name="FORMAT" value="image/png;bits=8"/>
>>>> </map-source>
>>>>
>>>> _______________________________________________
>>>> Geomoose-users mailing list
>>>> Geomoose-users at lists.osgeo.org
>>>> https://lists.osgeo.org/mailman/listinfo/geomoose-users
>>>
>>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20181210/420cc539/attachment.html>
More information about the Geomoose-users
mailing list