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.
