[mapserver-users] How to link Oracle attributes to SHAPEFILE

[Roald de Wit]

Hi Pedro,

A number of years ago i had a situation like you describe below. The
solution we chose was:
- Create a postgresql/postgis datawarehouse
- Import shapefiles into postgis (shp2psql or ogr2ogr)
- Import attribute info from oracle into postgresql (we needed a
commercial license for converting Oracle to Postgresql)
- Either create a view or merge tables to join the geometry and
attribute info
- Serve the lot through MapServer WFS/WMS

I hope this helps.

Regards, Roald

Pedro Briones García wrote:
> Hello.
>
> I’m working with *Oracle 10g* and *MapServer 5.2*. My geographic layers are SHAPEFILES and the attributes of SHAPEFILES are stored in Oracle 10g (*NOT* Oracle Spatial or Locator)
>
> I need to link (or join) SHAPEFILES with attribute (NOT spatial) tables to do 3 things:
>
> -        Draw only elements of SHAPEFILE that are related with some records in Oracle. A record (polygon, for example) in the SHAPEFILE should only draw if is related with a record in Oracle (they both have a common column).
> -        Make a thematic map wich classifications depending on the values of Oracle records.
> -        Draw only elements of SHAPEFILE that meet an Oracle condition
>
>
>
>
>
> I have found lots of examples of layers wich both, geometry and
> attribtes, in Oracle; or layers in Oracle Spatial, but none of how to
> link and use a SHAPEFILE with Oracle (not spatial).
>
>
>
>
>
> I too would like to do the same of the aforementioned, but in this
> case with *DBF files* instead of Oracle tables. I have seen an example
> in the documentation, but I don’t know distinguish SHAPEFILES and the
> DBF files in the sentence.
>
>
>
> Please, could somebody send me an example to easily understand this?
>
>
>
> Thanks in advance.
>
>
>
> Pedro Briones García
>
>
>
> TRAGSATEC
>
>
>


--
Roald de Wit
Software Engineer
roald.dewit at lisasoft.com

Commercial Support for Open Source GIS Software
http://lisasoft.com/LISAsoft/SupportedProducts/



The contents of this email are confidential and may be subject to legal or professional privilege and copyright. No representation is made that this email is free of viruses or other defects. If you have received this communication in error, you may not copy or distribute any part of it or otherwise disclose its contents to anyone. Please advise the sender of your incorrect receipt of this correspondence.