[mapserver-users] MapServer + Database + WFS

[Léveillé, James]

Hi Tim,

If it's not too late (I'm coming back from vacation), here is a working
example with MapServer 5 (on Windows) and Oracle 10g.
I'm also using a custom projection.

Hope it helps.


---
MAP

  NAME                      "Prototype"
  CONFIG PROJ_LIB           "D:/mapserver5_orcl/ms4w/proj/nad"

  PROJECTION
    "init=epsg:42105"
  END
  WEB
    METADATA
      "wfs_title"                       "Prototype"
      "wfs_onlineresource"
"http://server_name/MapServer5_orcl/mapserv.exe?map=D:\project\my_wfs_mapfil
e.map"
      "wfs_srs"                         "EPSG:42105" # *** Contrary to WMS,
I think that the OGC WFS specification doesn't allow a layer (feature type)
to be advertized in more than one SRS.
      "wfs_abstract"                    "My prototype ..."
      "wfs_geometry_element_name"       "MS_GEOMETRY"
    END
  END
  STATUS                  ON

  EXTENT                  30000 75000 1710000 2120000 # Custom projection
#  SHAPEPATH               "D:/systemes/dds/donnees/"
  UNITS                   METERS

# MY LAYER

  LAYER

    NAME                          "layer name"
    PROJECTION
      "init=EPSG:42105" # Custom projection
    END
    METADATA
      "wfs_title"                 "Layer Name"
      "wfs_name"                  "Layer Name"
      "wfs_abstract"              "Layer Name"
      "wfs_srs"                   "EPSG:42105" # Custom projection

      "wfs_geometry_element_name" "MS_GEOMETRY"
      "wfs_version"               "1.0.0"
      "wfs_request_method"        "GET"
      "wfs_connectiontimeout"     "600"

      "wfs_featureid"             "ide_segmn_ferrv"
      "gml_exclude_items"         "all"
      "gml_include_items"         "ide_segmn_ferrv"
#,num_rtss,authr_respn,indct_sourc_ctq_mtq,topnm,clasf_res_camng"
    END
    STATUS                ON
    DUMP                  TRUE

    EXTENT                30000 75000 1700000 2120000 # Custom projection

    CONNECTIONTYPE        oraclespatial
    CONNECTION            "user/pw at inst"
    PROCESSING            "CLOSE_CONNECTION=DEFER"
    DATA                  "geo_segmn_ferrv FROM bgr_segmn_ferrv USING UNIQUE
ide_segmn_ferrv SRID 1557057 "
    TYPE                  LINE

  END

END











______________________________________________________
JAMES LÉVEILLÉ
Service des systèmes de Mission
Direction des technologies de l'information
Ministère des Transports du Québec
5833, boul. Pierre-Bertrand, 2ième étage
Québec (Québec) G2K 1K7
Téléphone:   (418) 380-2005 poste 227
Télécopieur: (418) 644-6653
james.leveille at mtq.gouv.qc.ca

 


-----Message d'origine-----
De : mapserver-users-bounces at lists.osgeo.org
[mailto:mapserver-users-bounces at lists.osgeo.org] De la part de Nolte, Tim
Envoyé : 30 juillet 2008 10:55
À : mapserver-users at lists.osgeo.org
Objet : [mapserver-users] MapServer + Database + WFS


Is no one out there using Oracle Spatial, or any other DB, with MapServer
and WFS? There is pretty much a huge lack of documentation for serving WFS
from MapServer. It would be nice to know if what I'm attempting is even
possible or not. Thanks if someone does actually respond.

- Tim

----
Timothy J Nolte - tnolte at ilpcs.com
Network Planning Engineer

iPCS Wireless, Inc.
4717 Broadmoor Ave, Suite G
Kentwood, MI 49512

Office: 616-656-5163
PCS:    616-706-2438
Fax:    616-554-6484
Web: www.ipcswirelessinc.com _______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users