Hello List,
I have a question in regards to serving up data via WFS from mapserver to
desktop gis clients like Arcmap.
I have wfs server (the url is http://wfs.alaskamapped.org//inventory? ).
It appears to work, but a number of things that folks normally do in
arcgis/arcmap/arcwhatever with other data sources do not work and generate
a "This operation failed because the database table does not have a
numeric index" error message. I am somewhat baffled by this, as this
error message is generated when you use the "Select Feature" tool or try
to view the WFS as a table - pretty basic stuff that users will want to
do.
I am not sure if this is a problem with my mapfile, a problem with
arcgis, or just a limit of using (or my understanding of) WFS.
Any advice would be greatly appreciated.
Thanks,
-Jay
Here is my mapfile (hopefully posting something is long is not bad form
for this list - if so let me know off line and i will not do it again)
NAME SDMI_Inventory
STATUS ON
SIZE 400 300
EXTENT -180 0 180 90
UNITS METERS
IMAGECOLOR 255 255 255
DEBUG ON
WEB
METADATA
"wfs_title" "SDMI Inventory" ## REQUIRED
"wfs_onlineresource" "http://wfs.alaskamapped.org/inventory?"; ##
Recommended
"wfs_srs" "EPSG:4326" ## Recommended
END
END
PROJECTION
"init=epsg:102006"
END
LAYER
NAME SDMI_Inventory
METADATA
"wfs_title" "SDMI Inventory" ## REQUIRED
"wfs_abstract" "This WFS service provides information about the data
in the SDMI holdings. For more information, please see
http://www.alaskamapped.org or email [EMAIL PROTECTED]"
"wfs_accessconstraints" "None."
"wfs_extent" "-180 0 180 90"
"wfs_srs" "EPSG:4326" ## Recommended
"gml_featureid" "id" ## REQUIRED
"gml_include_items" "all" ## Optional (serves all attributes for
layer)
"gml_geometries" "footprints"
"gml_footprints_type" "polygon"
"gml_objectid_type" "integer"
"gml_id_type" "integer"
END
TYPE POLYGON
STATUS ON
PROJECTION
"init=epsg:4326"
END
CONNECTIONTYPE POSTGIS
CONNECTION "host=XXXX dbname=XXXX user=XXXXX"
DATA "llgeom from (select llgeom,footprints.id as objectid, footprints.id as id, scene_gid as scene_id, scraps.downloadable as
downloadable,start_time,end_time,source_res, sources.name as contact,
licenses.web_label as license_type, 'http://browse.alaskamapped.org/footprint/download/'||footprints.id as url
FROM footprints, licenses, scraps, sources where footprints.scrap_id=scraps.id and licenses.id=scraps.license_id and
scraps.source_id = sources.id ) as foo using unique id using SRID=4326"
PROCESSING "CLOSE_CONNECTION=DEFER"
DEBUG ON
DUMP TRUE ## REQUIRED
END # Layer
END # Map File
