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-tp14766031p14766031.html Sent from the Mapserver - User mailing list archive at Nabble.com.
