MAPSERVER with Postgis. SELECT Queries with WFS returns only the header

Maarten Plieger plieger at KNMI.NL
Mon Aug 13 03:19:17 PDT 2007


Hello all,

I am setting up UMN mapserver with postgis. At the moment i have a test 
database running with an esri world file imported to it. With WMS i can 
view this file with both DATA settings listed below. With WFS however, 
the second query does not return any data. I really would like to make 
queries on the postgis dataset, because the final dataset will be very 
large. And this data has to be available through WFS too. Am I 
misunderstanding something? Is it possible to make postgis queries on WFS?
I am running mapserver 5 beta 3.
"describefeaturetype" and "getcapabilities" returns exactly the same for 
both settings

(1)
DATA "the_geom from name"
# WMS=OK, WFS=OK

(2)
DATA "the_geom from (select gid,name,gmi_cntry,REGION,the_geom from 
name) as foo using unique the_geom using SRID=4326"
#WMS=OK, WFS=returns only header!

Part of my mapfile:
LAYER
  NAME test3
  TYPE LINE
  CONNECTIONTYPE postgis
  CONNECTION "bla bla"
  DATA "the_geom from (select gid,name,gmi_cntry,REGION,the_geom from 
name) as foo using unique the_geom using SRID=4326"
  #DATA "the_geom from name"
  METADATA
    "wfs_title"    "World_lines" ## REQUIRED
    "wfs_srs" "EPSG:4326"
    "wfs_extent" "-180 -90 180 90"
    "gml_featureid" "NAME" ## REQUIRED
    "gml_include_items" "all"  ## Optional (serves all attributes for layer)
  END
  DUMP TRUE

  PROJECTION
    "init=epsg:4326"
  END

  CLASS
    COLOR 0 0 0
  END
END


Thanks in advance,
Maarten Plieger



More information about the MapServer-users mailing list