<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Dear list,<br>
a few days ago, a colleague asked me, whether it would be possible to
load database views into gvSIG. My colleague also created a colum
"geom" in order to make it possible to <br>
directly load the data into gvSIG. We gave it a try using the GeoBD
connectio manager.<br>
It was possible to connect to the database, but no tables were
displayed within the GeoBD-add-layer dialogue. When trying to connect
directly to the oracle view via project manager > table >
database,<br>
we were also not successful. The dialogue closed and no table was
visible.<br>
<br>
I am not a specialist regarding oracle spatial view definition,
therefore, I just paste here the view definition:<br>
<br>
CREATE OR REPLACE VIEW uis_gis_muc_mobilfunkanl_v_r (objekt_id,<br>
NAME,<br>
strassehausnr,<br>
plz,<br>
ort,<br>
geom,<br>
annotationo,<br>
cityo,<br>
classificationo,<br>
eastingo,<br>
epluso,<br>
eplusumtso,<br>
euroo,<br>
initialoperationo,<br>
newoperationo,<br>
northingo,<br>
officeso,<br>
otherso,<br>
o2o,<br>
o2umtso,<br>
radiostationskwo,<br>
radiostationsukwo,<br>
safetydistanceo,<br>
tmobileo,<br>
tmobileumtso,<br>
tvstationso,<br>
vodafoneo,<br>
vodafoneumtso<br>
)<br>
AS<br>
SELECT o.o_id AS objekt_id, o.o_name AS NAME,<br>
PARENT.o_label AS strassehausnr,<br>
uis_obj_attribute_value (PARENT.o_id, 'PostalCodeO') AS plz,<br>
uis_obj_attribute_value (PARENT.o_id, 'PlaceO') AS ort,<br>
MDSYS.SDO_GEOMETRY<br>
(3001,<br>
31468,<br>
MDSYS.sdo_point_type<br>
(REPLACE (uis_obj_attribute_value (o.o_id,
'EastingO'),<br>
'.',<br>
','<br>
) -- x<br>
,<br>
REPLACE (uis_obj_attribute_value (o.o_id,
'NorthingO'),<br>
'.',<br>
','<br>
) -- y<br>
,<br>
0<br>
) -- z<br>
,<br>
NULL,<br>
NULL<br>
) AS geom<br>
-- Hier die Merkmale einfügen<br>
,<br>
uis_obj_attribute_value (o.o_id, 'AnnotationO') AS
annotationo,<br>
uis_obj_attribute_value (o.o_id, 'CityO') AS cityo,<br>
uis_obj_attribute_value (o.o_id,<br>
'ClassificationO'<br>
) AS classificationo,<br>
uis_obj_attribute_value (o.o_id, 'EastingO') AS eastingo,<br>
uis_obj_attribute_value (o.o_id, 'E-PlusO') AS epluso,<br>
uis_obj_attribute_value (o.o_id, 'E-PlusUMTSO') AS
eplusumtso,<br>
uis_obj_attribute_value (o.o_id, 'EuroO') AS euroo,<br>
uis_obj_attribute_value (o.o_id,<br>
'InitialOperationO'<br>
) AS initialoperationo,<br>
uis_obj_attribute_value (o.o_id,<br>
'NewOperationO') AS newoperationo,<br>
uis_obj_attribute_value (o.o_id, 'NorthingO') AS northingo,<br>
uis_obj_attribute_value (o.o_id, 'OfficesO') AS officeso,<br>
uis_obj_attribute_value (o.o_id, 'OthersO') AS otherso,<br>
uis_obj_attribute_value (o.o_id, 'O2O') AS o2o,<br>
uis_obj_attribute_value (o.o_id, 'O2UMTSO') AS o2umtso,<br>
uis_obj_attribute_value (o.o_id,<br>
'RadioStationsKWO'<br>
) AS radiostationskwo,<br>
uis_obj_attribute_value (o.o_id,<br>
'RadioStationsUKWO'<br>
) AS radiostationsukwo,<br>
uis_obj_attribute_value (o.o_id,<br>
'SafetyDistanceO'<br>
) AS safetydistanceo,<br>
uis_obj_attribute_value (o.o_id, 'T-MobileO') AS tmobileo,<br>
uis_obj_attribute_value (o.o_id, 'T-MobileUMTSO') AS
tmobileumtso,<br>
uis_obj_attribute_value (o.o_id, 'TVStationsO') AS
tvstationso,<br>
uis_obj_attribute_value (o.o_id, 'VodafoneO') AS vodafoneo,<br>
uis_obj_attribute_value (o.o_id,<br>
'VodafoneUMTSO') AS vodafoneumtso<br>
------------------------------<br>
FROM ibkuis_bd_objects o, --
Objekte<br>
ibkuis_co_classifications c, --
Klasse<br>
ibkuis_bd_objects PARENT, --
Standort<br>
ibkuis_bd_obj_hiera hiera<br>
WHERE o.o_id = hiera.ohz_o_id<br>
AND PARENT.o_id = hiera.ohz_high_id -- den Standort
bestimmen<br>
AND o.o_c_id = c.c_id -- Verbindung zu der
Klasse<br>
AND c.c_name = 'MobilePhoneSystemPlantO' -- nur
Mobilfunkanlagen<br>
ORDER BY o.o_id<br>
/<br>
<br>
<br>
Maybe there's something wrong with the GEOM definition? The layer is a
point theme.<br>
<br>
I started gvSIG from the command line - and copied the messages left
there into a textfile. I also attach the logfile of gvSIG to this post.
<br>
I would be very happy, if you could help me with the following
questions:<br>
<br>
1) is it - generally - possible to use views of oracle spatial
databases in gvSIG (both via the table- and add-layer dialogue). Or
does gvSIG only support database tables?<br>
2) if it's possible to load views into gvSIG: are there known problems?<br>
3) if it all should work: is there anything wrong with the view
definiton above?<br>
<br>
Any comments would be great!<br>
Best,<br>
Wolfgang<br>
<br>
<br>
<br>
<div class="moz-signature">-- <br>
<table bgcolor="white" border="0" cellpadding="3" cellspacing="0"
width="350">
<tbody>
<tr>
<td colspan="2" bgcolor="#330066"><img
src="cid:part1.07040904.05030304@muenchen.de" alt="" border="0"
height="35" width="170"></td>
</tr>
<tr>
<td align="left" bgcolor="#330066" valign="bottom" width="3"> <br>
</td>
<td valign="top"><font
face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" size="2"> <b>Wolfgang
Qual<br>
<br>
</b> </font> <font
face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" size="1"><big> <b>Referat
für Gesundheit und Umwelt</b></big><br>
Umweltschutz<br>
Umweltvorsorge<br>
RGU-UW 11<br>
<br>
Bayerstraße 28a<br>
80335 München<br>
<br>
Telefon +49 - 89 - 233 - 4 77 17<br>
Telefax +49 - 89 - 233 - 4 77 05<br>
<br>
<a class="moz-txt-link-freetext"
href="http://www.muenchen.de/umweltatlas">http://www.muenchen.de/umweltatlas</a><br>
<a class="moz-txt-link-abbreviated"
href="mailto:uw11.rgu@muenchen.de">uw11.rgu@muenchen.de</a><br>
</font></td>
</tr>
<tr>
<td colspan="2" valign="top"><small><font
face="Helvetica, Arial, sans-serif"> Bitte beachten Sie die Hinweise
zur elektronischen<br>
Kommunikation mit der Landeshauptstadt München:<br>
<a class="moz-txt-link-freetext"
href="http://www.muenchen.de/ekomm">http://www.muenchen.de/ekomm</a></font></small></td>
</tr>
</tbody>
</table>
</div>
</body>
</html>