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

[TC Haddad]

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/0fca35f6/attachment.html>