[MAPSERVER-USERS] How to map attribute data (non-geom)
fromOracle(not Spatial)?
Bill Wordsworth
bill.wordsworth at gmail.com
Fri Aug 29 17:38:08 EDT 2008
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
>>
>>
>
More information about the mapserver-users
mailing list