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