[mapserver-users] MapServer + Database + WFS
Nolte, Tim
Tim.Nolte at ipcswirelessinc.com
Wed Jul 30 08:59:00 PDT 2008
So the specific issue I'm having is that my Oracle Spatial layers are
not coming back with any features. Here's a couple of my Mapfile
entries:
LAYER
GROUP switchboundaries
NAME davenport
TYPE POLYGON
STATUS ON
CONNECTIONTYPE oraclespatial
CONNECTION ".../... at ..."
PROCESSING "CLOSE_CONNECTION=DEFER"
DATA "geom FROM (SELECT swt.switch_id, swt.switch_descr, sgt.geom
FROM ms_switch_vw swt, switch_geom_tab sgt WHERE swt.switch_id =
sgt.switch_id AND swt.switch_id = 7) USING SRID 8307"
LABELITEM "switch_descr"
METADATA
wfs_title "Switch Boundaries: Davenport"
wfs_latlonboundingbox "-104.29 29.71 -71.55 52.63"
wfs_typename "davenport"
gml_featureid "switch_id"
gml_include_items "switch_id,switch_descr"
gml_switch_descr_alias "Switch"
END
DUMP TRUE
TRANSPARENCY 100
END
LAYER
GROUP cellsites
NAME onair
TYPE POINT
STATUS ON
CONNECTIONTYPE oraclespatial
CONNECTION ".../... at ..."
PROCESSING "CLOSE_CONNECTION=DEFER"
DATA "geom FROM (SELECT st.site_id, st.bts_nbr, sgt.geom FROM
site_tab st, site_geom_tab sgt WHERE st.site_id = sgt.site_id AND
st.site_status_id IN (4,7)) USING SRID 8307"
LABELITEM "bts_nbr"
METADATA
wfs_title "Cell Sites: On-Air"
wfs_latlonboundingbox "-104.29 29.71 -71.55 52.63"
wfs_typename "onair"
gml_geometries "geom"
gml_boundary_type "point"
gml_featureid "site_id"
gml_include_items "site_id,bts_nbr"
gml_bts_nbr_alias "BTS#"
END
DUMP TRUE
END
Any help would be greastly appreciated.
----
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: Yewondwossen Assefa [mailto:yassefa at dmsolutions.ca]
> Sent: Wednesday, July 30, 2008 11:38 AM
> To: Nolte, Tim
> Cc: mapserver-users at lists.osgeo.org
> Subject: Re: [mapserver-users] MapServer + Database + WFS
>
> Tim,
>
> I have used mainly Postgis with Mapserver and WFS. I am pretty sure
> some have used SDE as a back end. Oracle spatial is also
> known to work
> with Mapserver for a while so I see no reason why it could
> not be used
> as a WFS server too.
> Are you facing particular problems? Are you concerned about
> performance issues? As for the documentation, I am assuming
> that you are
> taking about
> http://mapserver.gis.umn.edu/docs/howto/wfs_server, It has
> been a while that It has been updated but information in it is still
> correct. Maybe specific issues/comment could help improving it.
>
> best Regards,
>
> Nolte, Tim wrote:
> > 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
> >
>
>
> --
> ----------------------------------------------------------------
> Assefa Yewondwossen
> Software Analyst
>
> Email: assefa at dmsolutions.ca
> http://www.dmsolutions.ca/
>
> Phone: (613) 565-5056 (ext 14)
> Fax: (613) 565-0925
> ----------------------------------------------------------------
>
>
>
More information about the MapServer-users
mailing list