[Geomoose-users] GM3 identify items in SpatiaLite db?
James Klassen
klassen.js at gmail.com
Mon Dec 10 09:45:21 PST 2018
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/758fcf29/attachment-0001.html>
More information about the Geomoose-users
mailing list