Home » Developer & Programmer » Forms » GIS for Oracle ( Oracle Enterprise Manager Version 9.2.0.1.0)
GIS for Oracle [message #612844] Sat, 26 April 2014 01:49 Go to next message
meteo
Messages: 89
Registered: April 2010
Location: beirut
Member
i have a table called clim that contains climate data for 2 regions
also i have a geographic carte for theses 2 regions

i want to diffuse all data in clim table on a geographic carte

any one gave a suggestion i appreciate it; is there a plqsql package ,procedures , functions can do this task ???

thank you.

[JD & LF merged several topics]

[Updated on: Mon, 12 May 2014 04:45] by Moderator

Report message to a moderator

Re: Diffusion Data Table on geographic carte [message #612851 is a reply to message #612844] Sat, 26 April 2014 07:22 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I understood the first part - you have a table which contains some data.

You also have a map (a "geographic carte", as you put it). What is it? A JPG or similar image format, or something different? If it is an image, I have no idea how to draw anything on it using Oracle Forms.

Just as an idea, think of integrating Google Maps into your form. You could put markers onto it, each of them representing data for different locations stored in a table. Here's some more info: Oracle Forms 10g - Using Static Google Maps with HTTP geocoding service.

Report message to a moderator

Re: Diffusion Data Table on geographic carte [message #613117 is a reply to message #612851] Wed, 30 April 2014 04:13 Go to previous messageGo to next message
meteo
Messages: 89
Registered: April 2010
Location: beirut
Member
Hi Mr thank you for your reply.

in details
I create a new form called MAP.FMB

At form Level: i create a trigger when_new_form_ instance :
Set_Custom_Property('BL.BEAN',1, 'SETIMAGE','file:///C:\Dev9i\forms90\My_Projects\Meteo\Location_map_Lebanon.jpg' ) ;
-- this map has tow region Sud (Sd) and Beirut (Bi)

This form has a block : BL with

Bean Item (Bean)
has the following property (Item Type : BEAN, Implementation Class : oracle.forms.fd.MapComponent)
Under which I write the following trigger: when_custom_item_event:
message( Get_Custom_Property('BL.BEAN',1, 'NAME'), no_acknowledge);

Button Item (BT)
has the following property (Item Type : Push Button)
Under which I write the following trigger : When button pressed:
Set_Custom_Property('BL.BEAN',1, 'SETFONTCOLOR','255,0,100' );
Set_Custom_Property('BL.BEAN',1, 'SETPOLYGON','Sd,url1,284,128,272,138,292,181,315,196,336,194,353,178,361,166,342,133');
Set_Custom_Property('BL.BEAN',1, 'SETPOLYGON','bi ,url2,274,146,246,163,221,230,213,258,260,304,307,304,341,281,341,204,336,192,316,198');

At run time when I press on the button BT the two polygons that determine the boundary of the tow regions (Sd, Bi) are well displayed.

In addition the two regions (Sud, Beirut) were related by their specific identification (SD,Bi)on relational database table for example as follow:

Table: Clim Data

Region_id temperature pressure
SD 20 1012
SD 25 1014
SD 30 1018
SD 33 1020
SD 35 1025
.....
Bi 15 1012
Bi 19 1016
Bi 20 1023
......

How can I disseminate or diffuse these data on the two polygons (Sd, Bi)that delimit the sud and Beirut regions as mentioned above according to their specific identification.



Report message to a moderator

PLSQL Diffusion Data Table on geographic carte [message #613196 is a reply to message #612844] Wed, 30 April 2014 12:16 Go to previous messageGo to next message
meteo
Messages: 89
Registered: April 2010
Location: beirut
Member
I create a new form called MAP.FMB

At form Level: i create a trigger when_new_form_ instance :
Set_Custom_Property('BL.BEAN',1, 'SETIMAGE','file:///C:\Dev9i\forms90\My_Projects\Meteo\Location_map_Lebanon.jpg' ) ; -- this map has tow region Sud (Sd) and Beirut (Bi)


This form has a block : BL with

Bean Item (Bean)
has the following property (Item Type : BEAN, Implementation Class : oracle.forms.fd.MapComponent)
Under which I write the following trigger: when_custom_item_event: message( Get_Custom_Property('BL.BEAN',1, 'NAME'), no_acknowledge);


Button Item (BT)
has the following property (Item Type : Push Button)
Under which I write the following trigger : When button pressed:
Set_Custom_Property('BL.BEAN',1, 'SETFONTCOLOR','255,0,100' );
Set_Custom_Property('BL.BEAN',1, 'SETPOLYGON','Sd,url1,284,128,272,138,292,181,315,196,336,194,353,178,361,166,342,133');
Set_Custom_Property('BL.BEAN',1, 'SETPOLYGON','bi ,url2,274,146,246,163,221,230,213,258,260,304,307,304,341,281,341,204,336,192,316,198');



At run time when I press on the button BT the two polygons that determine the boundaries of the two regions (Sd, Bi) are well displayed.

In addition the two regions (Sud, Beirut) were related by their specific identification (SD,Bi)on relational database table for example as follows:



Table: Clim Data



Region_id --- temperature --- pressure
SD --- 20 --- 1012
SD --- 25 --- 1014
SD --- 30 --- 1018
SD --- 33 --- 1020
SD --- 35 --- 1025
.....
Bi --- 15 --- 1012
Bi --- 19 --- 1016
Bi --- 20 --- 1023
......


How can I disseminate or diffuse these data on the two polygons (Sd, Bi)that delimit the sud and Beirut regions as mentioned above according to their specific identification. ??



I thank and appreciate whoever gives me any suggestion.

Report message to a moderator

GIS for Oracle [message #613777 is a reply to message #612844] Mon, 12 May 2014 04:40 Go to previous message
meteo
Messages: 89
Registered: April 2010
Location: beirut
Member

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.

Report message to a moderator

Previous Topic: Runtime of 10 G developer
Next Topic: Item with last transactional date
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 07:55:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.