WFS requests ignore PostGIS columns beside the Geometry and ID column

[Kralidis,Tom [Burlington]]

What version of MapServer are you using?

As well, I see that you have set 'gml_include_items' to 'all '.  If you remove the trailing space (i.e. 'all'), does that help?

Failing this, I suggest you submit a testcase offline (minimal mapfile/sample data), which I can help you with.

..Tom


> -----Original Message-----
> From: UMN MapServer Users List 
> [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On Behalf Of sg1
> Sent: 12 January, 2008 5:30 AM
> To: MAPSERVER-USERS at LISTS.UMN.EDU
> Subject: [UMN_MAPSERVER-USERS] WFS requests ignore PostGIS 
> columns beside the Geometry and ID column
> 
> Hi everybody,
> 
> i extracted ArcGIS feature classes to shapefiles and imported 
> them into a PostGIS database.
> 
> Then i formulated a simple WMS request - everything worked fine.
> 
> Then I tried setting up a WFS request. I got some results, 
> but somehow the result ignored every column but the gid and the_geom!
> actually the getcapabilities return no errors and also the 
> getfeature returns with no errors, just the column attributes 
> are missing!
> 
> Up to now there's just one more column,that should be 
> integrated too. It is called 'wegnr' - type is 'character varying' 
> 
> The interesting thing is, that the column is also missing 
> when I use the Shapefile as data source.
> Schema, ns are default.
> Usually the column should be described by another <element /> 
> tab, but it's missing
> 
> I can't find the error.
> As I can access the data in the database I thought it's a 
> mapserver problem, but I'm not sure
> 
> The describeFeatureType request looks as followed: 
> 
> #################################################################
> <schema targetNamespace="http://mapserver.gis.umn.edu/mapserver"
> elementFormDefault="qualified" version="0.1"> <import 
> namespace="http://www.opengis.net/gml"
> schemaLocation="http://schemas.opengis.net/gml/2.1.2/feature.xsd"/>
> <element name="wanderwege" type="ms:wanderwegeType"
> substitutionGroup="gml:_Feature"/>
> −	<complexType name="wanderwegeType">
> −	<complexContent>
> −	<extension base="gml:AbstractFeatureType">
> −	<sequence>
> <element name="msGeometry" type="gml:GeometryPropertyType" 
> minOccurs="0"
> maxOccurs="1"/>
> </sequence>
> </extension>
> </complexContent>
> </complexType>
> <element name="wanderwege_shp" type="ms:wanderwege_shpType"
> substitutionGroup="gml:_Feature"/>
> −	<complexType name="wanderwege_shpType">
> −	<complexContent>
> −	<extension base="gml:AbstractFeatureType">
> −	<sequence>
> <element name="msGeometry" type="gml:GeometryPropertyType" 
> minOccurs="0"
> maxOccurs="1"/>
> </sequence>
> </extension>
> </complexContent>
> </complexType>
> </schema>
> 
> ###################################################
> That's an extract of the layer in the Mapfile:
> 
> LAYER 
> 	NAME 'wanderwege'
> 	TYPE LINE
> 	CONNECTION 'user=postgres password=Si18JaudcTdW. 
> dbname=postgis host=localhost port=5432'
> 	CONNECTIONTYPE POSTGIS
> 	DATA 'the_geom from wanderwege'
> DUMP TRUE
> 	STATUS OFF
> 	METADATA 
> 		'wms_title' 'wanderwege'
> 		'wms_srs' 'EPSG:31285'		
> 		'wms_title' 'ww'
>                	'wfs_title' 'ww'
> 		'wfs_typename' 'ww'
> 		'wfs_request_method' 'get'
> 		'wfs_service' 'wfs'
> 		'wfs_version' '1.0.0'
> 		'wfs_extent' '392570 145627 578166 218654'
> 		'wfs_featureid' 'gid'
> 		'wfs_tname' 'wegnr'
> 		'wfs_srs' 'EPSG:31285'
> 		'gml_include_items' 'all '	
> 	END
> END
> ##########################################
> 
> Thanks for every idea you guys have, I'm quite at my wits' end
> 
> sg1
> 
> --
> View this message in context: 
> http://www.nabble.com/WFS-requests-ignore-PostGIS-columns-besi
> de-the-Geometry-and-ID-column-tp14766031p14766031.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
>