[mapserver-users] MapServer + Database + WFS
Léveillé, James
James.Leveille at mtq.gouv.qc.ca
Mon Aug 4 11:39:29 PDT 2008
Hi Tim,
I had the same problem - even a few "timeouts" on the server side (I know,
with IIS ...).
>From my experience, WFS worked fine with a few features, but it proved to be
"more difficult" to use when there were to many of them due 1) to the size
of the GML file returned and 2) to the time it takes to read all the
information from Oracle.
I found no solution to this problem ...
______________________________________________________
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 : Nolte, Tim [mailto:Tim.Nolte at ipcswirelessinc.com]
Envoyé : 4 août 2008 14:23
À : Léveillé, James; mapserver-users at lists.osgeo.org
Objet : RE: RE : [mapserver-users] MapServer + Database + WFS
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
>
>
More information about the MapServer-users
mailing list