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