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

[pbg]

Hi Roald.

Thanks for the reply.

In this project, we are required to use SHAPEFILES and Oracle, so we can't
change this environment.


Roald de Wit wrote:
> 
> 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.
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/How-to-link-Oracle-attributes-to-SHAPEFILE-tp2731838p2732398.html
Sent from the Mapserver - User mailing list archive at Nabble.com.