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