[mapserver-users] MapServer + Database + WFS

[Nolte, Tim]

James,

Thanks for the info. After a bunch of trial and error I was able to finally able to get WFS working, and our WFS client actually having the objects. One problem that I did run into was with the size of the data. I had around 1800 or so features each with around 15 attributes of data. This proved to take like 20 minutes for the entire amount of data to load. I'm not sure if you have any suggestions with that one. The only thing I found was to break up the data into smaller chunks, while not the most ideal solution it at least helped to reduce some of the load time feel.

- 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 

> -----Original Message-----
> From: Léveillé, James [mailto:James.Leveille at mtq.gouv.qc.ca] 
> Sent: Monday, August 04, 2008 2:08 PM
> To: Nolte, Tim; mapserver-users at lists.osgeo.org
> Subject: RE : [mapserver-users] MapServer + Database + WFS
> 
> 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
> 
>