[OSM-talk] Fetching and displaying OSM data via Oracle's MapViewer using Oracle's PL/SQL API

[Iván Sánchez Ortega]

El Sábado, 23 de Agosto de 2008, infowire at btinternet.com escribió:
> I am currently working in Oracle Spatial and would like to know whether it
> is possible to use Oracle's PL/SQL API to fetch and display OSM data in a
> Web Browser, via Oracle's MapViewer? The PL/SQL API simply calls the
> relevant java API but by being in PL/SQL it allows one to call the programs
> more easily within PL/SQL code.

I doubt it can be done easily - the OSM API is just some custom XML over HTTP, 
and AFAIK, Oracle's PL/SQL cannot fetch arbitrary bits of XML over HTTP - 
please correct me if I'm wrong.

> I'm trying to figure out how to do this so that I do not have to keep 
> manually reimporting OSM data just to keep the data as fresh as the 
> planet.osm dumps.  

You should have a look at the available scripts for syncing a PostgreSQL DB 
with daily (or hourly) planet diffs - once you have set up a cronjob, there 
is absolutely no need to manually do anything.


Cheers,
-- 
----------------------------------
Iván Sánchez Ortega <ivan at sanchezortega.es>

Un ordenador no es un televisor ni un microondas, es una herramienta compleja.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20080826/40aae0ec/attachment.pgp>