[mapserver-users] MapServer + Database + WFS

[Nolte, Tim]

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
> ----------------------------------------------------------------
> 
> 
>