[mapserver-dev] Template driven output - issue with PostGIS connection

[Havard Tveite]

The OGR based GeoJSON option seems OK.  No trouble
with the "using unique" attribute there.

Håvard

On 6/6/2013 2:00 PM, Smith, Michael ERDC-RDE-CRREL-NH wrote:
> You could also try to isolate it to the template output by trying ogr
> based geojson output (http://mapserver.org/output/ogr_output.html)
>
> OUTPUTFORMAT
>    NAME "OGR_GeoJson"
>    DRIVER "GeoJson"
>    FORMATOPTION "STORAGE=stream"
>    FORMATOPTION "FORM=simple"
> END
>
>
>
> Mike
>
> On 6/6/13 7:49 AM, "Havard Tveite" <havard.tveite at umb.no> wrote:
>
>> I have not tried with other data sources, so this may not be
>> PostGIS related.
>> I have sent Thomas the information from the PostgreSQL logs
>> (the queries seemed to be the same for GML and geojson).
>>
>> Håvard
>>
>> On 6/6/2013 1:26 PM, thomas bonfort wrote:
>>> Havard,
>>> The postgis driver hasn't changed in trunk since 6.2. Can you enable
>>> debugging on your postgis layer and post the query that is being sent to
>>> the postgres backend?
>>>
>>> regards,
>>> thomas
>>>
>>>
>>> On 6 June 2013 13:17, Havard Tveite <havard.tveite at umb.no
>>> <mailto:havard.tveite at umb.no>> wrote:
>>>
>>>      I have a PostGIS connection, and want to provide GeoJSON
>>>      output.
>>>
>>>      After some stumbling (and updating of the Mapserver docs!),
>>>      I got it to work, except for the "using unique" part.
>>>
>>>      The interesting parts of my DATA string is like:
>>>           DATA "geom from (select x.id <http://x.id> as id, ...) as test
>>> using unique id using SRID=4326"
>>>
>>>      This works well for WFS with GML, but when I add
>>>      "&outputformat=geojson" (to get GeoJSON output), the returned
>>>      id is a very large number (for instance 137051404431549 - it
>>>      changes for each request), and it is the same number for all
>>>      the features.  The actual ids are between 1 and 1000.
>>>
>>>      I have the same issue when not using WFS
>>> (&mode=nquery&qformat=geojson)__.
>>>
>>>      My template for geojson output is according to the documentation
>>>      (and everything else is returned as it should).
>>>
>>>      Could this be a bug?
>>>
>>>      mapserv -v
>>>      MapServer version 6.2.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG
>>> SUPPORTS=PROJ SUPPORTS=GD SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=CAIRO
>>> SUPPORTS=OPENGL SUPPORTS=ICONV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT
>>> SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER
>>> SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS
>>> INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
>>>
>>>      I have not checked trunk.
>>>
>>>
>>>      Håvard
>>>      --
>>>      Håvard Tveite
>>>      Department of Mathematical Sciences and Technology, UMB
>>>      Drøbakveien 31, POBox 5003, N-1432 Ås, NORWAY
>>>      Phone: +47 64965483 <tel:%2B47%2064965483> Fax: +47 64965401
>>> <tel:%2B47%2064965401> http://www.umb.no/imt/
>>>      _________________________________________________
>>>      mapserver-dev mailing list
>>>      mapserver-dev at lists.osgeo.org <mailto:mapserver-dev at lists.osgeo.org>
>>>      http://lists.osgeo.org/__mailman/listinfo/mapserver-dev
>>> <http://lists.osgeo.org/mailman/listinfo/mapserver-dev>
>>>
>>>
>>
>> --
>> Håvard Tveite
>> Department of Mathematical Sciences and Technology, UMB
>> Drøbakveien 31, POBox 5003, N-1432 Ås, NORWAY
>> Phone: +47 64965483 Fax: +47 64965401 http://www.umb.no/imt/
>> _______________________________________________
>> mapserver-dev mailing list
>> mapserver-dev at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>
>
>

-- 
Håvard Tveite
Department of Mathematical Sciences and Technology, UMB
Drøbakveien 31, POBox 5003, N-1432 Ås, NORWAY
Phone: +47 64965483 Fax: +47 64965401 http://www.umb.no/imt/