Hi list,<br><br>hum, could he use ogr vrt?<br><a href="http://www.gdal.org/ogr/drv_vrt.html">http://www.gdal.org/ogr/drv_vrt.html</a><br><br>Luigi Castro Cardeles<br>
<br><br><div class="gmail_quote">2009/4/28 Paolo Corti <span dir="ltr"><<a href="mailto:pcorti@gmail.com">pcorti@gmail.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">><br>
> Hi Roald.<br>
><br>
> Thanks for the reply.<br>
><br>
> In this project, we are required to use SHAPEFILES and Oracle, so we can't<br>
> change this environment.<br>
><br>
><br>
> Roald de Wit wrote:<br>
>><br>
>> Hi Pedro,<br>
>><br>
>> A number of years ago i had a situation like you describe below. The<br>
>> solution we chose was:<br>
>> - Create a postgresql/postgis datawarehouse<br>
>> - Import shapefiles into postgis (shp2psql or ogr2ogr)<br>
>> - Import attribute info from oracle into postgresql (we needed a<br>
>> commercial license for converting Oracle to Postgresql)<br>
>> - Either create a view or merge tables to join the geometry and<br>
>> attribute info<br>
>> - Serve the lot through MapServer WFS/WMS<br>
>><br>
>> I hope this helps.<br>
>><br>
>> Regards, Roald<br>
>><br>
<br>
</div>Pedro, the solution Roald is proposing is IMHO the closest one you<br>
have to obtain what you need with MapServer (et alii).<br>
<br>
according to this doc: <a href="http://mapserver.org/mapfile/join.html" target="_blank">http://mapserver.org/mapfile/join.html</a><br>
<br>
supported formats are:<br>
* DBF/XBase files<br>
* CSV (comma delimited text file)<br>
* PostgreSQL and PostGIS tables<br>
* MySQL tables<br>
<br>
So you have 5 options:<br>
1. shapefile + dbf (exported from Oracle tables)<br>
2. PostGIS<br>
3. MySQL<br>
4. Oracle Spatial<br>
5. Oracle + ArcSde<br>
<br>
in 2. and 3. no need to join, you could use views.<br>
in 4 you need views.<br>
with 5 there are many limits with joins, so could be the wrong way to go.<br>
<br>
Note anyway that for what you need (join to make thematic map)<br>
according to the above doc there is no way.<br>
So the only solutions to go are 3, 4<br>
I am not aware of other map web server software, neither OS or<br>
commercial, able to make mixed (from different sources) join for<br>
thematic mapping<br>
<br>
best regards<br>
<font color="#888888">Paolo<br>
</font><div><div></div><div class="h5">_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</div></div></blockquote></div><br>