Print Thread
GIS for Oracle
#49003 05/12/14 10:29 AM
Joined: Feb 2014
Posts: 4
Beirut Lebanon
M
Member
OP Offline
Member
M
Joined: Feb 2014
Posts: 4
Beirut Lebanon

in my relational data base i have the following table,

Tableau: Clim data

Region_id --- temperature
SD --- 20
SD --- 25
SD --- 30
SD --- 33
SD --- 35
.....
Bi --- 15
Bi --- 19
Bi --- 20
......


this table shows the values of temperature for the two provinces(SUD sd, Beirut bi).


on the other side, these two provinces (SUD sd, Beirut bi) has a geographical reference defined in the spatial database that constitutes the
map of Lebanon at provinces level with the same identification (sd,bi) respectively.


the spatial database that constitutes the map of Lebanon at Province level which, by its turn, is digitalized through ArcGis software and saved as LebMap.shape.


my main objective is :


i need to know if there are PLSQL packages, procedures, functions or any Oracle tools through which i achieve two tasks:

1) link the two relational and spatial databases by the identification(sd, bi)

2) select available data in the CLIM table to diffuse or disseminate them on Lebanon map at provincial level (SUD , BEIRUT) represented by
LebMap.shape, and classify them by colors; for example:
20-30 blue color on the map
31-40 Red color on the map.

Etc ...


I thank and appreciate whoever gives me any suggestion.


software that i am using :
Oracle Enterprise Manager Version 9.2.0.1.0, Forms [32 Bit] Version 9.0.2.9.0 ,
oracle JInitiator: 1.3.1.9, WebUtil 1.0.2(Beta), windowXp Service pack3 , Internet Explorer 8.


Re: GIS for Oracle
Marmarino #49022 05/15/14 10:17 PM
Joined: Aug 2003
Posts: 101
Chesapeake Bay
Member
Offline
Member
Joined: Aug 2003
Posts: 101
Chesapeake Bay
and how is your question related to the PLSQL Developer IDE?


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.028s Queries: 15 (0.006s) Memory: 2.4975 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-03-29 13:48:27 UTC
Valid HTML 5 and Valid CSS