26 June 2008

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 !

05 June 2008

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