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

[Bill Wordsworth]

msDrawMap(): Image handling error. Failed to draw layer named 'ora'.
msOracleSpatialLayerOpen(): OracleSpatial error. OracleSpatial is not supported

Upgrade or perish? Can I compile support into my existing setup
(4.8.3)? I've heard Hobu is great at this :).

I am afraid with all the syntax changes in 5.2.x my map files will
throw bigger errors.
Cheers, Bill

On Wed, Aug 6, 2008 at 3:20 PM, Nolte, Tim
<Tim.Nolte at ipcswirelessinc.com> wrote:
> 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
>>
>>
>