[MAPSERVER-USERS] How to map attribute data (non-geom) from Oracle(not Spatial)?
Bill Wordsworth
bill.wordsworth at gmail.com
Tue Aug 5 07:25:04 PDT 2008
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
>>
>>
>
More information about the MapServer-users
mailing list