[mapserver-users] How to link Oracle attributes to SHAPEFILE
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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] How to link Oracle attributes to SHAPEFILE
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
Re: [mapserver-users] How to link Oracle attributes to SHAPEFILE
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
Re: [mapserver-users] How to link Oracle attributes to SHAPEFILE
> > 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, the solution Roald is proposing is IMHO the closest one you have to obtain what you need with MapServer (et alii). according to this doc: http://mapserver.org/mapfile/join.html supported formats are: * DBF/XBase files * CSV (comma delimited text file) * PostgreSQL and PostGIS tables * MySQL tables So you have 5 options: 1. shapefile + dbf (exported from Oracle tables) 2. PostGIS 3. MySQL 4. Oracle Spatial 5. Oracle + ArcSde in 2. and 3. no need to join, you could use views. in 4 you need views. with 5 there are many limits with joins, so could be the wrong way to go. Note anyway that for what you need (join to make thematic map) according to the above doc there is no way. So the only solutions to go are 3, 4 I am not aware of other map web server software, neither OS or commercial, able to make mixed (from different sources) join for thematic mapping best regards Paolo ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] How to link Oracle attributes to SHAPEFILE
Hi list, hum, could he use ogr vrt? http://www.gdal.org/ogr/drv_vrt.html Luigi Castro Cardeles 2009/4/28 Paolo Corti > > > > 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, the solution Roald is proposing is IMHO the closest one you > have to obtain what you need with MapServer (et alii). > > according to this doc: http://mapserver.org/mapfile/join.html > > supported formats are: >* DBF/XBase files >* CSV (comma delimited text file) >* PostgreSQL and PostGIS tables >* MySQL tables > > So you have 5 options: > 1. shapefile + dbf (exported from Oracle tables) > 2. PostGIS > 3. MySQL > 4. Oracle Spatial > 5. Oracle + ArcSde > > in 2. and 3. no need to join, you could use views. > in 4 you need views. > with 5 there are many limits with joins, so could be the wrong way to go. > > Note anyway that for what you need (join to make thematic map) > according to the above doc there is no way. > So the only solutions to go are 3, 4 > I am not aware of other map web server software, neither OS or > commercial, able to make mixed (from different sources) join for > thematic mapping > > best regards > Paolo > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users