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 <[EMAIL PROTECTED]> wrote: > Bill, > > You got it. > > - Tim > > ---- > Timothy J Nolte - [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of >> Bill Wordsworth >> Sent: Wednesday, August 06, 2008 2:47 PM >> To: mapserver-users@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 >> <[EMAIL PROTECTED]> 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 >> > <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]" >> >> 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 - [EMAIL PROTECTED] >> >> 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:[EMAIL PROTECTED] >> >>> Sent: Tuesday, August 05, 2008 10:25 AM >> >>> To: Nolte, Tim; mapserver-users@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@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapserver-users >> >> > _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users