[Geoserver-users] GeoServer with DataBase Non-spatial

GeoServer GeoServer User
1

Hi,

In a project where I am working, we are using Oracle, but without the oracle spatial.
I have the coordinates in related fields with the name lat / long.
Is to set these data in Geoserver, without the oracle spatial, its possible?

Fernando Quadro
fsquadro@anonymised.com

Notícias direto do New York Times, gols do Lance, videocassetadas e muitos outros vídeos no MSN Videos! Confira já!

2

Fernando Quadro wrote:

Hi,

In a project where I am working, we are using Oracle, but without the oracle spatial. I have the coordinates in related fields with the name lat / long.
Is to set these data in Geoserver, without the oracle spatial, its possible?

Nope, we don't have support for data with x/y columns (to be turned into point). There is some code lying around, but unmantained, that did this,
but never made its way into an official GeoServer release and was eventually abandoned.

I'm curious about one thing. In order to support geometries one
does not need a full blown Oracle Spatial, Oracle Locator is sufficient,
and it's embedded even in the minor Oracle releases such as Oracle XE.
If you have Locator I believe it would be possible to create a view
that turns the two columns into an SDO_GEOMETRY (point type)... not
sure if you can index it (functional indexes should be supported, but
I'm not certain), but if you can, GeoServer should be able to pick
up the view and use it read only.

Cheers
Andrea

3

Andrea,

Thanks for the informations!

Best Regards,

Fernando Quadro
fsquadro@anonymised.com

Date: Fri, 30 Jan 2009 16:59:23 +0100
From: aaime@anonymised.com
To: fsquadro@anonymised.com
CC: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer with DataBase Non-spatial

Fernando Quadro wrote:

Hi,

In a project where I am working, we are using Oracle, but without the
oracle spatial.
I have the coordinates in related fields with the name lat / long.
Is to set these data in Geoserver, without the oracle spatial, its possible?

Nope, we don’t have support for data with x/y columns (to be turned into
point). There is some code lying around, but unmantained, that did this,
but never made its way into an official GeoServer release and was
eventually abandoned.

I’m curious about one thing. In order to support geometries one
does not need a full blown Oracle Spatial, Oracle Locator is sufficient,
and it’s embedded even in the minor Oracle releases such as Oracle XE.
If you have Locator I believe it would be possible to create a view
that turns the two columns into an SDO_GEOMETRY (point type)… not
sure if you can index it (functional indexes should be supported, but
I’m not certain), but if you can, GeoServer should be able to pick
up the view and use it read only.

Cheers
Andrea

Notícias direto do New York Times, gols do Lance, videocassetadas e muitos outros vídeos no MSN Videos! Confira já!

4

Hej

Oracle Locator includes all spatial functionality you normally need, including the spatial overlay functions.
Oracle Spatial is only needed for special cases like raster and topology.

A functional index do work for spatial columns, but you pay a performance penalty like 20-30 % (in my tests).
It is better to create and populate (a trigger will work) a spatial column with syntax like:
ALTER TABLE

ADD SDO_GEOMETRY;
UPDATE
SET = SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(X, Y, NULL), NULL, NULL) WHERE (x is not null and y is not null);
CREATE INDEX ON
() INDEXTYPE IS MDSYS.SPATIAL_INDEX

You must also register the table in the Oracle view USER_SDO_GEOM_METADATA with relevant values for XY bounding box:
INSERT INTO USER_SDO_GEOM_METADATA
VALUES (‘

’, ‘’, SDO_DIM_ARRAY(SDO_DIM_ELEMENT(‘X’, 1000000, 3000000, 0.0001), SDO_DIM_ELEMENT(‘Y’, 5000000, 8000000, 0.0001)), NULL );

Best regards

Andreas

-----Ursprungligt meddelande-----
Från: Andrea Aime [mailto:aaime@anonymised.com]
Skickat: den 30 januari 2009 16:59
Till: Fernando Quadro
Kopia: geoserver-users@lists.sourceforge.net
Ämne: Re: [Geoserver-users] GeoServer with DataBase Non-spatial

Fernando Quadro wrote:

Hi,

In a project where I am working, we are using Oracle, but without the
oracle spatial.
I have the coordinates in related fields with the name lat / long.
Is to set these data in Geoserver, without the oracle spatial, its possible?

Nope, we don’t have support for data with x/y columns (to be turned into point). There is some code lying around, but unmantained, that did this, but never made its way into an official GeoServer release and was eventually abandoned.

I’m curious about one thing. In order to support geometries one does not need a full blown Oracle Spatial, Oracle Locator is sufficient, and it’s embedded even in the minor Oracle releases such as Oracle XE.
If you have Locator I believe it would be possible to create a view that turns the two columns into an SDO_GEOMETRY (point type)… not sure if you can index it (functional indexes should be supported, but I’m not certain), but if you can, GeoServer should be able to pick up the view and use it read only.

Cheers
Andrea

This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users