[MAPSERVER-USERS] How to map attribute data (non-geom) fromOracle(not Spatial)?

[Nolte, Tim]

Bill,

You got it.

- 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: mapserver-users-bounces at lists.osgeo.org 
> [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of 
> Bill Wordsworth
> Sent: Wednesday, August 06, 2008 2:47 PM
> To: mapserver-users at lists.osgeo.org
> Subject: Re: [MAPSERVER-USERS] How to map attribute data 
> (non-geom) fromOracle(not Spatial)?
> 
> http://www.oracle.com/technology/products/spatial/spatial_loca
> tor_features.html
> 
> Shapefile Converter > SQL*Loader > MapServer Query? Is that 
> all it takes?
> 
> On Tue, Aug 5, 2008 at 4:01 PM, Bill Wordsworth
> <bill.wordsworth at gmail.com> wrote:
> > Tim,
> > I didn't know you could do "geom from..." without Oracle Spatial, so
> > this is great!
> >
> > This is my current compilation:
> > MapServer version 4.8.3 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG 
> OUTPUT=WBMP
> > OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE
> > SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
> > SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=THREADS 
> SUPPORTS=GEOS
> > INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
> > DEBUG=MSDEBUG
> >
> > I don't see any Oracle support. Could you shed some light on how to
> > enable that? And how do you insert geom into Oracle Locator without
> > Oracle Spatial- what tools?
> >
> > So as I understand, Oracle Spatial allows geoprocessing type queries
> > (buffer, nearest, shortest) while Oracle Locator doesn't allow any
> > thing that but does display geom (point, line, polygon, (raster)).
> > Correct?? I just want to take a shapefile, insert it and 
> then display
> > its filtered set.
> > Cheers, Bill
> >
> > On Tue, Aug 5, 2008 at 10:38 AM, Nolte, Tim
> > <Tim.Nolte at ipcswirelessinc.com> wrote:
> >> Bill,
> >>
> >> Here is a layer definition I am using for Oracle 
> Spatial(Locator) data.
> >>
> >>  LAYER
> >>    GROUP "Cell Sites"
> >>    NAME "On-Air"
> >>    TYPE POINT
> >>    STATUS ON
> >>    CONNECTIONTYPE oraclespatial
> >>    CONNECTION "username/password at sid"
> >>    PROCESSING "CLOSE_CONNECTION=DEFER"
> >>    DATA "geom FROM (SELECT 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
> >>      "static_legend" "1"
> >>    END
> >>    DUMP true
> >>    CLASS
> >>      NAME "On-Air Large Scale"
> >>      MINSCALE 0
> >>      MAXSCALE 1200000
> >>      STYLE
> >>        SYMBOL "circle"
> >>        COLOR 22 129 17
> >>        OUTLINECOLOR 255 255 255
> >>        SIZE 12
> >>      END
> >>      LABEL
> >>        TYPE TRUETYPE
> >>        FONT "sans"
> >>        SIZE 7
> >>        POSITION CR
> >>        OFFSET 0 2
> >>        ANGLE AUTO
> >>        BUFFER 3
> >>        MINDISTANCE 30
> >>        MINFEATURESIZE 10
> >>        COLOR 0 0 0
> >>        OUTLINECOLOR 245 245 231
> >>        SHADOWSIZE 3 3
> >>        BACKGROUNDSHADOWSIZE 1 -1
> >>      END
> >>    END
> >>    CLASS
> >>      NAME "On-Air Small Scale"
> >>      MINSCALE 1200000
> >>      MAXSCALE 6000000
> >>      STYLE
> >>        SYMBOL "circle"
> >>        COLOR 22 129 17
> >>        OUTLINECOLOR 255 255 255
> >>        SIZE 8
> >>      END
> >>    END
> >>  END
> >>
> >> The key here is that you need to have MapServer compiled 
> with Oracle
> >> Spatial support. And you can see from my data line that that I do
> >> standard Oracle SQL statements for building my spatial 
> results. I'm not
> >> using any shapefiles in this instance. The spatial data is actually
> >> stored right in the database table. There are tools to 
> import shapefiles
> >> into Oracle. If your data is points you can build insert 
> statements to
> >> populated your geometry columns. You're probably going to 
> want to do
> >> some reading up on Oracle spatial.
> >>
> >> - 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: Bill Wordsworth [mailto:bill.wordsworth at gmail.com]
> >>> Sent: Tuesday, August 05, 2008 10:25 AM
> >>> To: Nolte, Tim; mapserver-users at lists.osgeo.org
> >>> Subject: Re: [MAPSERVER-USERS] How to map attribute data
> >>> (non-geom) from Oracle(not Spatial)?
> >>>
> >>> This is exciting news! I am using Oracle 10g and get 
> Oracle Locator
> >>> free but how do I map data from Oracle Locator? Are you doing a
> >>> JOIN+FILTER? Can you share a LAYER snippet from your MAP file?
> >>> Cheers, Bill
> >>
> >
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
>