WFS requests ignore PostGIS columns beside the Geometry and ID column

[Pål Kristensen]

Hi!

Have you tried adding the following to the METADATA section?

"ows_include_items" "All"

Regards,
Pål Kristensen



sg1 wrote:
> 
> 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-beside-the-Geometry-and-ID-column-tp14766031p14796182.html
Sent from the Mapserver - User mailing list archive at Nabble.com.