<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2658.24">
<TITLE>RE: [UMN_MAPSERVER-USERS] getFeature: Results are not correct</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>This is most likely because OGR cannot determine a primary key on your table. It needs a primary key to operate queries (not for a map display).</FONT></P>
<P><FONT SIZE=2>A few questions:</FONT>
<BR><FONT SIZE=2>1) which version of GDAL?</FONT>
<BR><FONT SIZE=2>2) which version of Mapserver?</FONT>
<BR><FONT SIZE=2>3) you can try to use CONFIG "OGR_FID" "name_of_your_primary_key" at your MAP object if automatic detection of the primary key fails</FONT></P>
<P><FONT SIZE=2>Best regards,</FONT>
<BR><FONT SIZE=2>Bart</FONT>
</P>
<P><FONT SIZE=2>-----Oorspronkelijk bericht-----</FONT>
<BR><FONT SIZE=2>Van: UMN MapServer Users List</FONT>
<BR><FONT SIZE=2>[<A HREF="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">mailto:MAPSERVER-USERS@LISTS.UMN.EDU</A>]Namens Christian Wilmes</FONT>
<BR><FONT SIZE=2>Verzonden: dinsdag 16 mei 2006 12:29</FONT>
<BR><FONT SIZE=2>Aan: MAPSERVER-USERS@LISTS.UMN.EDU</FONT>
<BR><FONT SIZE=2>Onderwerp: [UMN_MAPSERVER-USERS] getFeature: Results are not correct</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hello,</FONT>
</P>
<P><FONT SIZE=2>first of all sorry for cross posting, but I've got no idea where I have to</FONT>
<BR><FONT SIZE=2>search the mistake so I post it to the GDAL and the Mapserver Mailinglist.</FONT>
</P>
<P><FONT SIZE=2>I'm trying to publish a WFS-Server. The Data (only Point-Data) are in a</FONT>
<BR><FONT SIZE=2>PostgreSQL-Database (no PostGIS!). So the connection to the data is over</FONT>
<BR><FONT SIZE=2>"Virtual Spatial Data". The getCapabilities and DescribeFeatureType request</FONT>
<BR><FONT SIZE=2>both work very well. Only the GML-Document getting with the getFeature</FONT>
<BR><FONT SIZE=2>request is not correct. The number of features in the GML-Document are</FONT>
<BR><FONT SIZE=2>correct too every time, but the features are not in the Bounding Box. The</FONT>
<BR><FONT SIZE=2>features in the GML-Document are always the feature which are on the top of</FONT>
<BR><FONT SIZE=2>the table they come from. Only the number of feature is correct. The MBR</FONT>
<BR><FONT SIZE=2>(Minimum Boundig Rectangle) on the top of the GML-Document amasingly the</FONT>
<BR><FONT SIZE=2>correct one. So it don't fit to the features in the document. Testing the</FONT>
<BR><FONT SIZE=2>connection with "ogrinfo" and a Boundig-Box is working correct. If I'm</FONT>
<BR><FONT SIZE=2>trying to make a WMS-Server with the same Data and the same OGR-file it</FONT>
<BR><FONT SIZE=2>works very well.</FONT>
</P>
<P><FONT SIZE=2>So here is my Mapfile:</FONT>
</P>
<P><FONT SIZE=2>MAP</FONT>
<BR> <FONT SIZE=2>NAME WFS_Server</FONT>
<BR> <FONT SIZE=2>STATUS ON</FONT>
<BR> <FONT SIZE=2>WEB</FONT>
<BR> <FONT SIZE=2>METADATA</FONT>
<BR> <FONT SIZE=2>"wfs_title" "WFS Server" </FONT>
<BR> <FONT SIZE=2>"wfs_onlineresource" "<A HREF="http://127.0.0.1/cgi-bin/mapserv.exe" TARGET="_blank">http://127.0.0.1/cgi-bin/mapserv.exe</A>?"</FONT>
<BR> <FONT SIZE=2>"wfs_srs" "EPSG:4326"</FONT>
<BR> <FONT SIZE=2>END</FONT>
<BR> <FONT SIZE=2>END</FONT>
</P>
<P> <FONT SIZE=2>PROJECTION</FONT>
<BR> <FONT SIZE=2>"init=EPSG:4326"</FONT>
<BR> <FONT SIZE=2>END</FONT>
</P>
<P>
<BR> <FONT SIZE=2>LAYER</FONT>
<BR> <FONT SIZE=2>NAME myWFS</FONT>
<BR> <FONT SIZE=2>METADATA</FONT>
<BR> <FONT SIZE=2>"wfs_title" "myWFS"</FONT>
<BR> <FONT SIZE=2>"gml_include_items" "all" </FONT>
<BR> <FONT SIZE=2>END</FONT>
<BR> <FONT SIZE=2>TYPE POINT</FONT>
<BR> <FONT SIZE=2>STATUS ON</FONT>
<BR> <FONT SIZE=2>CONNECTIONTYPE OGR</FONT>
<BR> <FONT SIZE=2>CONNECTION "test.ovf"</FONT>
<BR> <FONT SIZE=2>PROJECTION</FONT>
<BR> <FONT SIZE=2>"init=EPSG:4326"</FONT>
<BR> <FONT SIZE=2>END</FONT>
<BR> <FONT SIZE=2>DUMP TRUE</FONT>
</P>
<P> <FONT SIZE=2>END</FONT>
<BR><FONT SIZE=2>END</FONT>
</P>
<BR>
<BR>
<BR>
<BR>
<P><FONT SIZE=2>and the OGR-File test.ovf:</FONT>
</P>
<P><FONT SIZE=2><OGRVRTDataSource></FONT>
<BR><FONT SIZE=2> <OGRVRTLayer name="feature"></FONT>
<BR><FONT SIZE=2> <SrcDataSource>PG:host=192.168.5.86 user=cwilmes dbname=rosoapcw</FONT>
<BR><FONT SIZE=2>password=xxx</SrcDataSource> </FONT>
<BR><FONT SIZE=2> <SrcLayer>feature</SrcLayer> </FONT>
<BR> <FONT SIZE=2><GeometryType>wkbPoint</GeometryType> </FONT>
<BR><FONT SIZE=2> <LayerSRS>EPSG:4326</LayerSRS></FONT>
<BR> <FONT SIZE=2><GeometryField encoding="PointFromColumns" x="lat" y="lon"/> </FONT>
<BR><FONT SIZE=2> </OGRVRTLayer></FONT>
<BR><FONT SIZE=2></OGRVRTDataSource></FONT>
</P>
<BR>
<P><FONT SIZE=2>Here is a URL which I used for testing</FONT>
<BR><FONT SIZE=2>the</FONT>
<BR><FONT SIZE=2>WFS</FONT>
<BR><FONT SIZE=2>getFeature-Request:</FONT>
<BR><FONT SIZE=2><A HREF="http://localhost/cgi-bin/mapserv.exe?&REQUEST=GetFeature&VERSION=1.0.0&SERVICE=WFS&TYPENAME=myWFS&&BBox=9.98,7.98,10,8" TARGET="_blank">http://localhost/cgi-bin/mapserv.exe?&REQUEST=GetFeature&VERSION=1.0.0&SERVICE=WFS&TYPENAME=myWFS&&BBox=9.98,7.98,10,8</A></FONT>
</P>
<BR>
<P><FONT SIZE=2>....and here is the result:</FONT>
<BR><FONT SIZE=2> <?xml version="1.0" encoding="ISO-8859-1"</FONT>
<BR><FONT SIZE=2>?></FONT>
</P>
<P><FONT SIZE=2>-</FONT>
<BR><FONT SIZE=2><wfs:FeatureCollection</FONT>
<BR><FONT SIZE=2>xmlns:ms="<A HREF="http://mapserver.gis.umn.edu/mapserver" TARGET="_blank">http://mapserver.gis.umn.edu/mapserver</A>"</FONT>
<BR><FONT SIZE=2>xmlns:wfs="<A HREF="http://www.opengis.net/wfs" TARGET="_blank">http://www.opengis.net/wfs</A>"</FONT>
<BR><FONT SIZE=2>xmlns:gml="<A HREF="http://www.opengis.net/gml" TARGET="_blank">http://www.opengis.net/gml</A>"</FONT>
<BR><FONT SIZE=2>xmlns:ogc="<A HREF="http://www.opengis.net/ogc" TARGET="_blank">http://www.opengis.net/ogc</A>"</FONT>
<BR><FONT SIZE=2>xmlns:xsi="<A HREF="http://www.w3.org/2001/XMLSchema-instance" TARGET="_blank">http://www.w3.org/2001/XMLSchema-instance</A>"</FONT>
<BR><FONT SIZE=2>xsi:schemaLocation="<A HREF="http://www.opengis.net/wfs" TARGET="_blank">http://www.opengis.net/wfs</A></FONT>
<BR><FONT SIZE=2><A HREF="http://schemas.opengeospatial.net/wfs/1.0.0/WFS-basic.xsd" TARGET="_blank">http://schemas.opengeospatial.net/wfs/1.0.0/WFS-basic.xsd</A></FONT>
<BR><FONT SIZE=2><A HREF="http://mapserver.gis.umn.edu/mapserver" TARGET="_blank">http://mapserver.gis.umn.edu/mapserver</A></FONT>
<BR><FONT SIZE=2><A HREF="http://127.0.0.1/cgi-bin/mapserv.exe?SERVICE=WFS&VERSION=1.0.0&REQUEST=DescribeFeatureType&TYPENAME=myWFS&OUTPUTFORMAT=XMLSCHEMA" TARGET="_blank">http://127.0.0.1/cgi-bin/mapserv.exe?SERVICE=WFS&VERSION=1.0.0&REQUEST=DescribeFeatureType&TYPENAME=myWFS&OUTPUTFORMAT=XMLSCHEMA</A>"></FONT></P>
<P><FONT SIZE=2>- <gml:boundedBy></FONT>
<BR><FONT SIZE=2>- <gml:Box srsName="EPSG:4326"></FONT>
<BR><FONT SIZE=2> <gml:coordinates>9.980700,7.984220 9.997500,7.995010</gml:coordinates> </FONT>
<BR><FONT SIZE=2> </gml:Box></FONT>
<BR><FONT SIZE=2> </gml:boundedBy></FONT>
<BR><FONT SIZE=2>- <gml:featureMember></FONT>
<BR><FONT SIZE=2>- <ms:myWFS></FONT>
<BR><FONT SIZE=2>- <gml:boundedBy></FONT>
<BR><FONT SIZE=2>- <gml:Box srsName="EPSG:4326"></FONT>
<BR><FONT SIZE=2> <gml:coordinates>9.682230,7.653260 9.682230,7.653260</gml:coordinates> </FONT>
<BR><FONT SIZE=2> </gml:Box></FONT>
<BR><FONT SIZE=2> </gml:boundedBy></FONT>
<BR><FONT SIZE=2>- <ms:msGeometry></FONT>
<BR><FONT SIZE=2>- <gml:Point srsName="EPSG:4326"></FONT>
<BR><FONT SIZE=2> <gml:coordinates>9.682230,7.653260</gml:coordinates> </FONT>
<BR><FONT SIZE=2> </gml:Point></FONT>
<BR><FONT SIZE=2> </ms:msGeometry></FONT>
<BR><FONT SIZE=2> <ms:id>16</ms:id> </FONT>
<BR><FONT SIZE=2> </ms:myWFS></FONT>
<BR><FONT SIZE=2> </gml:featureMember></FONT>
<BR><FONT SIZE=2>- <gml:featureMember></FONT>
<BR><FONT SIZE=2>- <ms:myWFS></FONT>
<BR><FONT SIZE=2>- <gml:boundedBy></FONT>
<BR><FONT SIZE=2>- <gml:Box srsName="EPSG:4326"></FONT>
<BR><FONT SIZE=2> <gml:coordinates>9.768800,7.835870 9.768800,7.835870</gml:coordinates> </FONT>
<BR><FONT SIZE=2> </gml:Box></FONT>
<BR><FONT SIZE=2> </gml:boundedBy></FONT>
<BR><FONT SIZE=2>- <ms:msGeometry></FONT>
<BR><FONT SIZE=2>- <gml:Point srsName="EPSG:4326"></FONT>
<BR><FONT SIZE=2> <gml:coordinates>9.768800,7.835870</gml:coordinates> </FONT>
<BR><FONT SIZE=2> </gml:Point></FONT>
<BR><FONT SIZE=2> </ms:msGeometry></FONT>
<BR><FONT SIZE=2> <ms:id>17</ms:id> </FONT>
<BR><FONT SIZE=2> </ms:myWFS></FONT>
<BR><FONT SIZE=2> </gml:featureMember></FONT>
<BR><FONT SIZE=2>- <gml:featureMember></FONT>
<BR><FONT SIZE=2>- <ms:myWFS></FONT>
<BR><FONT SIZE=2>- <gml:boundedBy></FONT>
<BR><FONT SIZE=2>- <gml:Box srsName="EPSG:4326"></FONT>
<BR><FONT SIZE=2> <gml:coordinates>9.296530,7.426330 9.296530,7.426330</gml:coordinates> </FONT>
<BR><FONT SIZE=2> </gml:Box></FONT>
<BR><FONT SIZE=2> </gml:boundedBy></FONT>
<BR><FONT SIZE=2>- <ms:msGeometry></FONT>
<BR><FONT SIZE=2>- <gml:Point srsName="EPSG:4326"></FONT>
<BR><FONT SIZE=2> <gml:coordinates>9.296530,7.426330</gml:coordinates> </FONT>
<BR><FONT SIZE=2> </gml:Point></FONT>
<BR><FONT SIZE=2> </ms:msGeometry></FONT>
<BR><FONT SIZE=2> <ms:id>18</ms:id> </FONT>
<BR><FONT SIZE=2> </ms:myWFS></FONT>
<BR><FONT SIZE=2> </gml:featureMember></FONT>
<BR><FONT SIZE=2>- <gml:featureMember></FONT>
<BR><FONT SIZE=2>- <ms:myWFS></FONT>
<BR><FONT SIZE=2>- <gml:boundedBy></FONT>
<BR><FONT SIZE=2>- <gml:Box srsName="EPSG:4326"></FONT>
<BR><FONT SIZE=2> <gml:coordinates>9.111500,7.645390 9.111500,7.645390</gml:coordinates> </FONT>
<BR><FONT SIZE=2> </gml:Box></FONT>
<BR><FONT SIZE=2> </gml:boundedBy></FONT>
<BR><FONT SIZE=2>- <ms:msGeometry></FONT>
<BR><FONT SIZE=2>- <gml:Point srsName="EPSG:4326"></FONT>
<BR><FONT SIZE=2> <gml:coordinates>9.111500,7.645390</gml:coordinates> </FONT>
<BR><FONT SIZE=2> </gml:Point></FONT>
<BR><FONT SIZE=2> </ms:msGeometry></FONT>
<BR><FONT SIZE=2> <ms:id>20</ms:id> </FONT>
<BR><FONT SIZE=2> </ms:myWFS></FONT>
<BR><FONT SIZE=2> </gml:featureMember></FONT>
<BR><FONT SIZE=2> </wfs:FeatureCollection></FONT>
</P>
<BR>
<BR>
<BR>
<P><FONT SIZE=2>I will be very thankful for every idea where the mistake could!</FONT>
</P>
<P><FONT SIZE=2>Please excuse my bad english!</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>Best Regards</FONT>
<BR><FONT SIZE=2>Christian</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>"Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ...</FONT>
<BR><FONT SIZE=2>Jetzt GMX TopMail testen: <A HREF="http://www.gmx.net/de/go/topmail" TARGET="_blank">http://www.gmx.net/de/go/topmail</A></FONT>
</P>
<BR>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>"Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ...</FONT>
<BR><FONT SIZE=2>Jetzt GMX TopMail testen: <A HREF="http://www.gmx.net/de/go/topmail" TARGET="_blank">http://www.gmx.net/de/go/topmail</A></FONT>
</P>
<BR>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Mobile Internet - E-Mail und Internet immer und überall!</FONT>
<BR><FONT SIZE=2>GMX zum Mitnehmen: <A HREF="http://www.gmx.net/de/go/pocketweb" TARGET="_blank">http://www.gmx.net/de/go/pocketweb</A></FONT>
</P>
<BR>
Disclaimer
************************************************************************
Aan dit bericht kunnen geen rechten worden ontleend. Dit bericht is
uitsluitend bestemd voor de geadresseerde. Als u dit bericht per abuis
hebt ontvangen, wordt u verzocht het te vernietigen en de afzender te
informeren. Wij adviseren u om bij twijfel over de juistheid of de
volledigheid van de mail contact met afzender op te nemen.
This message shall not constitute any rights or obligations.
This message is intended solely for the addressee.
If you have received this message in error, please delete it and
notify the sender immediately. When in doubt whether this message
is correct or complete, please contact the sender.
************************************************************************
<BR>
</BODY>
</HTML>