GIS for Oracle

25 pts.
Tags:
Oracle
Oracle Database
In my relational database, 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 digitized 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 byLebMap.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'm 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.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Genderhayes
    It contains the main feature dataset with a geometric network providing comprehensive background screening, onboarding and industry specific hiring services offers a full portfolio of US and international background screening solutions including criminal history checks, drug testing, verifications and references and much more. With intensive quality assurance on all background checks, GIS clients can feel confident that they are getting the best possible background checks, freeing them to focus on other portions of their business
    7,565 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following