[Geomoose-users] GM3 identify items in SpatiaLite db?

[TC Haddad]

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>