[mapserver-users] MapServer + Database + WFS
pcreso at pcreso.com
pcreso at pcreso.com
Mon Aug 4 14:55:59 EDT 2008
Hi all,
One approach I'm looking at to manage this is setting up scale dependent zoom layers. Zoomed out, only a significant subset of features, simplified to reduce the vertex count, progressively adding features & reducing the simplify corridor as the map zooms in, to try & send a roughly constant volume of data to the client irrespective of scale.
The text version of a vertex list is pretty long, often hundreds of kb for a feature, so reducing the no of vertices & features should make a big difference.
I'm also looking at reducing the number of significant digits used to store each vertex, given each digit becomes 1 byte in XML, as the values often provide a far higher precision than is necessary (but I'm not too sure how to do this yet :-)
All this is in the pretty early stages of trialling, so any comments or advice appreciated.
Cheers,
Brent Wood
--- On Tue, 8/5/08, Léveillé, James <James.Leveille at mtq.gouv.qc.ca> wrote:
> From: Léveillé, James <James.Leveille at mtq.gouv.qc.ca>
> Subject: RE : RE : [mapserver-users] MapServer + Database + WFS
> To: "Nolte, Tim" <Tim.Nolte at ipcswirelessinc.com>, mapserver-users at lists.osgeo.org
> Date: Tuesday, August 5, 2008, 6:39 AM
> 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
> >
> >
> _______________________________________________
> 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