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

[Bill Wordsworth]

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

On Mon, Aug 4, 2008 at 1:15 PM, Nolte, Tim
<Tim.Nolte at ipcswirelessinc.com> wrote:
> What version of Oracle are you using? If you are using 10g or higher it
> comes with Oracle Locator free. Oracle Locator is like Oracle Spatial
> Lite. We are using this for point data and polygons for our MapServer.
>
> - 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: Monday, August 04, 2008 12:28 PM
>> To: mapserver-users at lists.osgeo.org
>> Subject: [MAPSERVER-USERS] How to map attribute data
>> (non-geom) from Oracle(not Spatial)?
>>
>> What is the best way to map attribute data (non-geom) from Oracle (not
>> Spatial) using MapServer?
>>
>> Can I do this?
>> LAYER
>>       NAME "states_shapefile"
>>       DATA "path/states_shapefile"
>>       ...
>>       JOIN
>>           NAME "oracle"
>>               CONNECTIONTYPE ogr
>>           CONNECTION "..."
>>           TABLE "oracle_states_table"
>>           FROM "oracle_name"
>>           TO "shapefile_name"
>>           TYPE ONE-TO-ONE
>>       END
>>       # FILTERITEM ""
>>       FILTER "governor='Arnold'"
>> END
>> http://mapserver.gis.umn.edu/docs/reference/mapfile/join#examp
>> le-2-join-from-shp-file-to-postgresql-table
>>
>> If not, what is the best way around?
>> * Spend $$$ for Oracle Spatial
>> * Nightly convert attribute data to shapefile
>> * Nightly convert attribute data to PostGIS
>>
>> Any thoughts on the maintenance cost for each?
>> Cheers, Bill
>> _______________________________________________
>> mapserver-users mailing list
>> mapserver-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>
>>
>