1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

GIS for Oracle

Discussion in 'Oracle Forms and Reports' started by meteo, May 12, 2014.

  1. meteo

    meteo Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    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.