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

[Bill Wordsworth]

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
>