DOAG SIG Spatial infos

The DOAG SIG Spatial event September 9th in Frankfurt was a great success ! Again more than 70 people attended the event. Thanks to Thomas Pahl's excellent organisation and the very interesting topics and speeches (as planned - pls see my previous thread on this).

After 7 years of DOAG SIG SPATIAL organising Thomas Pahl will hand over the event organisation to other spatial enthusiasts -
A GREAT THANK YOU to Thomas for all his voluntary work ! Great !

As promised and as a follow up of my speech pls make a note of the following information:

MAPVIEWER 11g Preview (comprising Oracle Maps) is now production and supported! - whereas you might miss it for download on the Mapviewer download page.
As MAPVIEWER now has become part of the Oracle Weblogic Server (WLS) and the version 11g is not out,
MAPVIEWER's new version is: 10.1.3.1 + Patch#4 (incl. Oracle Maps)
You may download it from Metalink.oracle.com - search for patch 7195504
Mapviewer does run on WLS - I did test it -and the certification process of Mapviewer on WLS is underway.

x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x

Of great interest was the new Oracle Middleware Strategy: So I post some links here.
See and hear the Oracle Fusion Middleware Strategy as a Podcast or the Product Strategy and Briefing (pdf) or the Webcast "BEA Welcome and Middleware Strategy Briefing" (Charles Phillips - Oracle President and Thomas Kurian - Oracle SVP Development - July 1st 2008)

x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x

Forgotten Links:
Geocoder Demo: http://elocation.oracle.com/geocoder
Oracle Maps online: http://elocation.oracle.com/elocation/ajax
Oracle Mapviewer online: http://elocation.oracle.com/mapviewer

New (in German) Spatial Community page with a wealth of information !

All visitors of the DOAG SIG Spatial will received the links to supporting papers and copies of the speeches on paper or pdf from the DOAG organisation.

I enjoyed both speaking at the DOAG event and meeting all the people !
Take care !

DOAG SIG Spatial 9.9.08 in Frankfurt

• Neues zu Oracle Spatial und Oracle Maps in 11g (Carsten Czarski, Oracle)
• Oracle Maps Mashups - wie nutzt man andere Kartenserver (Bernhard Fischer-Wasels, Oracle)
• Oracle als Integrationsplattform -- Geodata Warehouse im Konzern Stadt Herten (Berthold Bärk / Rolf Jüttner, CISS TDI)
• Oracle-Spatial-basierte Betriebsmittelauskunft für Ver- und Entsorgungsnetze (Petra Freutel / Nico Tebbe, Mettenmeier)
• Geoproxy Thüringen - Hochperformante Bereitstellung von Geodaten (Olaf Schimmich / Erik Lipski, Grit)
• Data Dictionaries: Vergleich von Oracle Spatial 11g und PostGIS (Andreas Bartels, disy)

More you can find on the http://www.doag.org/ site under SIG Spatial

Event location: InterCityHotel Frankfurt Airport, Cargo City Süd, 60549 Frankfurt/Main

Mapviewer/Oracle Maps Licensing

Due to Oracle's strategic change from the Oracle Application Server (OC4J) to the BEA Weblogic Server some questions came up re the licensing.
MapViewer is now also included in the WebLogic licenses.
It is also included in the TopLink/ADF standalone license for deployment on other supported J2EE servers (ie: other than WebLogic and Oracle Application Server).
Recap:
Following Software does include the Mapviewer/Oracle Maps:

• TopLink/ADF
• Weblogic Server Standard Edition
• Weblogic Server Enterprise Edition
• Weblogic Suite
• Internet Application Server Standard Edition One
• Internet Application Server Standard Edition
• Internet Application Server Enterprise Edition

for the pricelist suggest to check the Oracle Store or contact your Oracle Sales Rep.

online Geocoder

A forgotten Link to Oracle Spatial Geocoder is here.
And here is a JSP with a small demo page.
There one can see how the GEOCODER is queried and the result being printed out.
A good page to illustrate an SQL Query on Geo-Data !

Reverse Geocoding here (lower part) and usage of the XML Format here:

Give it a try !

Spatial Join = (German: Verschneiden)

One of the most important tasks of a GIS application is the "Spatial Join" or "das Verschneiden" (in German):



Oracle Maps may fully take advantage of the inbuilt Oracle Spatial Technology as part of the database. The functions ANYINTERACT and/or SDO_RELATE are used to calculate above e.g. which FOI (customer) is located in the Polygon (REGIERUNGSBEZIRK = County).
When you click ('mouse_click') on the polygon the Spatial Function is invoked and no timeconsuming calculations are carried out - and you have the result within a second.

"How To?" --> in my "Oracle-Maps-Tipps" BLOG

Oracle Maps Applications in the Internet - References

Forest Portal in Slowakia ...more about it here




Airport Düsseldorf - Noise reduction Monitoring (german)

Special Use Airspace & Air Traffic Control Assigned Airspace


US Geological Survey - National water quality mapping site


Oracle eLocation Services Test Drive


Valimar, Portugal:
http://geo.valimardigital.pt/maps/geoportal/Developed by a local Partner (Timestamp) for a "Digital Region".
In the map you can find some information (POI, Pedestrian paths, streets).


Department of Employment, Belgium
It uses OBI EE and MapViewer to show unemployment rates. The site is part of: www.werk.be - In werk.be click left on Cijfers en onderzoekàCijfers
Then choose:
Start interactieve toepassing VAR
Or go directly to the BI EE / Oracle Maps Entry Screen.


http://www.geonetz-greven.de/ - City Portal, Germany - .NET User Interface integrated with Oracle Maps. More screenshots in separate article.


(added 03.03.2010)

Landesamt für Umwelt, Wasser-wirtschaft und Gewerbeaufsicht Rheinland-Pfalz
Mainz, Deutschland: Messstellen Verwaltung:


added: 16.08.2011 -more details in this separate article.

Oracle compilation of links using Mapviewer/Oracle Maps:

more to come . . . - stay tuned !

SpatialDB Advisor

I today came across a very useful site/BLOG of Simon Greener, an "independent Spatial Advisor". I will add a link in my "Spatial BLOG's" - so if you like to "deepdive" into Spatial and/or GIS terminology and functions, procedures, tipps and tricks (and not only Oracle, but also MSql-Server, MySQl, PotGIS, etc.) you will find a lot of stuff on his site/BLOG "SPATIALDB-Advisor"
Good luck !

More Memory for the MapTileServer (Mapcache) !!

Especially when generating detailed tiles by the MapTileServerCache (Mapcache) in Oracle Maps the OC4J needs more Memory to be allocated !!
When you do start the Mapviewer without an explicit command to allocate Memory, only 128 MB will be assigned to the OC4J.
The side effect with too less memory: The MapTilServer will generate tiles, but these are just containing the background color and no details from the layers.

Now, when you like to generate the tiles (*) for the Mapcache (either during runtime, when the user interacts with the map or if you like to prefetch the tiles) the Mapviewer needs more Memory !
So I recommend to start the Mapviewer like:

C:\mv10131_qs\oc4j\j2ee\home>java -Xmx512M -jar oc4j.jar

and you can play around with the Xmx512M to increase like Xmx1024M when needed.
For standard operation 256 might be sufficient.
Parameters like ZoomLevel and tile-size are influencing the memory consumption (during generation!).

(*) the generated tiles are stored in the file system in a directory like:
C:\mv10131_qs\oc4j\j2ee\home\applications\mapviewer\web\tilecache\

and looks like:



Have fun !
Bernhard

Force Mapviewer to use the right JAVA directory

I recently again came across JAVA errors/exception referring to JSP's when starting the Mapviewer with Java exceptions.
The reason was, that the Mapviewer startup batchfile did not include the
SET JAVA= path.... and a JAVA runtime version cud not complie the respective JSP's.
I was able to access the Mapviewer ADMIN Page but some other pages seem to have gone (cud not be compiled properly during runtime)
To overcome this obstacle recommend to include the JAVA SET command as follows:
(my startup batchfile assigning 512 MB RAM to the OC4J(Mapviewer)


Good luck !

Oracle BI EE and Oracle Maps

I just came across this perfect Step-by-step description of the Integration of Oracle Maps in Oracle BI Suite.
Thanks to "Venkatakrishnan J" !! Great stuff !

Just to let you know !!