[Geoserver-users] Oracle 10G Data Store [Sec=Unclassified]

Hi Sam

> -----Original Message-----
> From: Rishmawi, Sami
> Oracle 10G has a built in "mini" spatial option called
> "Locator". It is provides limited GIS support.

Although I have never used Geoserver with Locator I see no reason why
you shouldn't be able to. Locator uses exactly the same geometry data
type as Spatial and uses the same indexing mechanisms. It's pretty much
Oracle Spatial without a lot of the functions that provide spatial
tuning, coordinate transformations (which you can do with geotools or
have geoserver reproject on the fly anyway), etc.

Only one way to find out for sure, so please let us know how it goes.

Regards,

Miles Jordan

Applications Developer
Data Centre
The Australian Antarctic Division
203 Channel Hwy, Kingston TAS 7053

[p] +61 (0) 3 6232 3486
[m] +61 (0) 424 879 668
[e] miles.jordan@anonymised.com
[w] http://www.aad.gov.au

> Oracle White Paper Reference:
> http://www.oracle.com/technology/products/spatial/pdf/10gr2_c
> ollateral/l
> ocator_twp_10gr2.pdf. I have not yet got into the
> implementation details.
>
> I was hoping to use GeoServer as my WFS data feed to my
> Oracle "locator" enabled data.
>
> Sam
>
> Sami Rishmawi (sami@anonymised.com)
>
> WebSked Lead Engineer
>
> FGM (www.fgm.com)
>
> voice: 619-221-1327
>
>
> -----Original Message-----
> From: Justin Deoliveira [mailto:jdeolive@anonymised.com]
> Sent: Tuesday, August 21, 2007 9:12 AM
> To: Rishmawi, Sami
> Cc: geoserver-users@lists.sourceforge.net
> Subject: Re: [Geoserver-users] Oracle 10G Data Store
>
> Hi,
>
> Without the spatial option I don't think you will be able to
> use your oracle database with GeoServer. There is some work
> going on by rob atkinson to support "geometryless" tables in
> which data is specified in x,y coordinates, etc... and not
> necessary a full blown geometry. But that work is still in a
> very experimental state from what i believe.
>
> How are you storing your spatial data? I wonder if it might
> be possible to "trick" GeoServer into thinking your database
> is a spatial one by creating the necessary metadata tables.
> Although this would be a stretch.
>
> -Justin
>
> Rishmawi, Sami wrote:
> >
> >
> > I am using an Oracle 10G Server, but do not own the Oracle Spatial
> > option. Can I Configure Feature Types? If so, what loss of
> capability
> > will I have without the Oracle Spatial Option?
> >
> >
> >
> > Sami Rishmawi ( sami@anonymised.com <mailto:sami@anonymised.com> )
> >
>
___________________________________________________________________________

    Australian Antarctic Division - Commonwealth of Australia
IMPORTANT: This transmission is intended for the addressee only. If you are not the
intended recipient, you are notified that use or dissemination of this communication is
strictly prohibited by Commonwealth law. If you have received this transmission in error,
please notify the sender immediately by e-mail or by telephoning +61 3 6232 3209 and
DELETE the message.
        Visit our web site at http://www.antarctica.gov.au/
___________________________________________________________________________

Just to confirm…

As described, locator is the built in stuff, “Spatial” by Oracle’s definition is a bunch of additional functionality which costs lots more money, I think it may even have topology stuff in it to speed up spatial queries.

With the built in locator features you can do all the things you’d wanna do with Geoserver, load and save maps, run spatial queries etc… without restriction. As far as I can tell you’d only want spatial if you were a large corporation with maps of millions of polygons which need to be spatially referenced against other maps with millions of polygons on a regular basis. If you’re just serving and writing map data locator has everything you need.

Tom

On 8/22/07, Miles Jordan <Miles.Jordan@anonymised.com> wrote:

Hi Sam

-----Original Message-----
From: Rishmawi, Sami
Oracle 10G has a built in “mini” spatial option called
“Locator”. It is provides limited GIS support.

Although I have never used Geoserver with Locator I see no reason why
you shouldn’t be able to. Locator uses exactly the same geometry data
type as Spatial and uses the same indexing mechanisms. It’s pretty much
Oracle Spatial without a lot of the functions that provide spatial
tuning, coordinate transformations (which you can do with geotools or
have geoserver reproject on the fly anyway), etc.

Only one way to find out for sure, so please let us know how it goes.

Regards,

Miles Jordan

Applications Developer
Data Centre
The Australian Antarctic Division
203 Channel Hwy, Kingston TAS 7053

[p] +61 (0) 3 6232 3486
[m] +61 (0) 424 879 668
[e] miles.jordan@anonymised.com
[w] http://www.aad.gov.au

Oracle White Paper Reference:
http://www.oracle.com/technology/products/spatial/pdf/10gr2_c
ollateral/l
ocator_twp_10gr2.pdf. I have not yet got into the
implementation details.

I was hoping to use GeoServer as my WFS data feed to my
Oracle “locator” enabled data.

Sam

Sami Rishmawi (sami@anonymised.com)

WebSked Lead Engineer

FGM ( www.fgm.com)

voice: 619-221-1327

-----Original Message-----
From: Justin Deoliveira [mailto:jdeolive@anonymised.com]
Sent: Tuesday, August 21, 2007 9:12 AM
To: Rishmawi, Sami
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Oracle 10G Data Store

Hi,

Without the spatial option I don’t think you will be able to
use your oracle database with GeoServer. There is some work
going on by rob atkinson to support “geometryless” tables in
which data is specified in x,y coordinates, etc… and not
necessary a full blown geometry. But that work is still in a
very experimental state from what i believe.

How are you storing your spatial data? I wonder if it might
be possible to “trick” GeoServer into thinking your database
is a spatial one by creating the necessary metadata tables.
Although this would be a stretch.

-Justin

Rishmawi, Sami wrote:

I am using an Oracle 10G Server, but do not own the Oracle Spatial
option. Can I Configure Feature Types? If so, what loss of
capability
will I have without the Oracle Spatial Option?

Sami Rishmawi ( sami@anonymised.com <mailto: sami@anonymised.com> )


Australian Antarctic Division - Commonwealth of Australia
IMPORTANT: This transmission is intended for the addressee only. If you are not the
intended recipient, you are notified that use or dissemination of this communication is
strictly prohibited by Commonwealth law. If you have received this transmission in error,
please notify the sender immediately by e-mail or by telephoning +61 3 6232 3209 and
DELETE the message.
Visit our web site at http://www.antarctica.gov.au/



This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/


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

Thanks for the reply. I guess I probably asked my question
pre-maturely. I was a little disappointed at first since all the
documentation relating to Oracle indicated the use of Oracle Spatial.
After reading the Oracle documentation it appears that Oracle Locator is
the base functionality of Oracle Spatial. I have made some progress
already in configuring and testing a Feature type from my data set
through the WFS interface. However, I have not yet successfully
retrieved data using a geometry filter. Hope to do so today.

Sami Rishmawi (sami@anonymised.com)

WebSked Lead Engineer

FGM (www.fgm.com)

voice: 619-221-1327

-----Original Message-----
From: Miles Jordan [mailto:Miles.Jordan@anonymised.com]
Sent: Tuesday, August 21, 2007 6:43 PM
To: Rishmawi, Sami; Justin Deoliveira
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] Oracle 10G Data Store [Sec=Unclassified]

Hi Sam

> -----Original Message-----
> From: Rishmawi, Sami
> Oracle 10G has a built in "mini" spatial option called
> "Locator". It is provides limited GIS support.

Although I have never used Geoserver with Locator I see no reason why
you shouldn't be able to. Locator uses exactly the same geometry data
type as Spatial and uses the same indexing mechanisms. It's pretty much
Oracle Spatial without a lot of the functions that provide spatial
tuning, coordinate transformations (which you can do with geotools or
have geoserver reproject on the fly anyway), etc.

Only one way to find out for sure, so please let us know how it goes.

Regards,

Miles Jordan

Applications Developer
Data Centre
The Australian Antarctic Division
203 Channel Hwy, Kingston TAS 7053

[p] +61 (0) 3 6232 3486
[m] +61 (0) 424 879 668
[e] miles.jordan@anonymised.com
[w] http://www.aad.gov.au

> Oracle White Paper Reference:
> http://www.oracle.com/technology/products/spatial/pdf/10gr2_c
> ollateral/l
> ocator_twp_10gr2.pdf. I have not yet got into the
> implementation details.
>
> I was hoping to use GeoServer as my WFS data feed to my
> Oracle "locator" enabled data.
>
> Sam
>
> Sami Rishmawi (sami@anonymised.com)
>
> WebSked Lead Engineer
>
> FGM (www.fgm.com)
>
> voice: 619-221-1327
>
>
> -----Original Message-----
> From: Justin Deoliveira [mailto:jdeolive@anonymised.com]
> Sent: Tuesday, August 21, 2007 9:12 AM
> To: Rishmawi, Sami
> Cc: geoserver-users@lists.sourceforge.net
> Subject: Re: [Geoserver-users] Oracle 10G Data Store
>
> Hi,
>
> Without the spatial option I don't think you will be able to
> use your oracle database with GeoServer. There is some work
> going on by rob atkinson to support "geometryless" tables in
> which data is specified in x,y coordinates, etc... and not
> necessary a full blown geometry. But that work is still in a
> very experimental state from what i believe.
>
> How are you storing your spatial data? I wonder if it might
> be possible to "trick" GeoServer into thinking your database
> is a spatial one by creating the necessary metadata tables.
> Although this would be a stretch.
>
> -Justin
>
> Rishmawi, Sami wrote:
> >
> >
> > I am using an Oracle 10G Server, but do not own the Oracle Spatial
> > option. Can I Configure Feature Types? If so, what loss of
> capability
> > will I have without the Oracle Spatial Option?
> >
> >
> >
> > Sami Rishmawi ( sami@anonymised.com <mailto:sami@anonymised.com> )
> >
>
________________________________________________________________________
___

    Australian Antarctic Division - Commonwealth of Australia
IMPORTANT: This transmission is intended for the addressee only. If you
are not the
intended recipient, you are notified that use or dissemination of this
communication is
strictly prohibited by Commonwealth law. If you have received this
transmission in error,
please notify the sender immediately by e-mail or by telephoning +61 3
6232 3209 and
DELETE the message.
        Visit our web site at http://www.antarctica.gov.au/
________________________________________________________________________
___

Thanks for the info.

Sami Rishmawi (sami@anonymised.com <mailto:sami@anonymised.com> )

WebSked Lead Engineer

FGM (www.fgm.com <http://www.fgm.com/&gt; )

voice: 619-221-1327

________________________________

From: Tom (JDi Solutions) [mailto:tom.dean@anonymised.com]
Sent: Wednesday, August 22, 2007 12:39 AM
To: Miles Jordan
Cc: Rishmawi, Sami; Justin Deoliveira;
geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Oracle 10G Data Store [Sec=Unclassified]

Just to confirm...

As described, locator is the built in stuff, "Spatial" by Oracle's
definition is a bunch of additional functionality which costs lots more
money, I think it may even have topology stuff in it to speed up spatial
queries.

With the built in locator features you can do all the things you'd wanna
do with Geoserver, load and save maps, run spatial queries etc.. without
restriction. As far as I can tell you'd only want spatial if you were a
large corporation with maps of millions of polygons which need to be
spatially referenced against other maps with millions of polygons on a
regular basis. If you're just serving and writing map data locator has
everything you need.

Tom

On 8/22/07, Miles Jordan <Miles.Jordan@anonymised.com> wrote:

Hi Sam

-----Original Message-----
From: Rishmawi, Sami
     Oracle 10G has a built in "mini" spatial option called
"Locator". It is provides limited GIS support.

Although I have never used Geoserver with Locator I see no reason why
you shouldn't be able to. Locator uses exactly the same geometry data
type as Spatial and uses the same indexing mechanisms. It's pretty much
Oracle Spatial without a lot of the functions that provide spatial
tuning, coordinate transformations (which you can do with geotools or
have geoserver reproject on the fly anyway), etc.

Only one way to find out for sure, so please let us know how it goes.

Regards,

Miles Jordan

Applications Developer
Data Centre
The Australian Antarctic Division
203 Channel Hwy, Kingston TAS 7053

[p] +61 (0) 3 6232 3486
[m] +61 (0) 424 879 668
[e] miles.jordan@anonymised.com
[w] http://www.aad.gov.au

Oracle White Paper Reference:
http://www.oracle.com/technology/products/spatial/pdf/10gr2_c
ollateral/l
ocator_twp_10gr2.pdf. I have not yet got into the
implementation details.

     I was hoping to use GeoServer as my WFS data feed to my
Oracle "locator" enabled data.

Sam

Sami Rishmawi (sami@anonymised.com)

WebSked Lead Engineer

FGM ( www.fgm.com <http://www.fgm.com> )

voice: 619-221-1327

-----Original Message-----
From: Justin Deoliveira [mailto:jdeolive@anonymised.com]
Sent: Tuesday, August 21, 2007 9:12 AM
To: Rishmawi, Sami
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Oracle 10G Data Store

Hi,

Without the spatial option I don't think you will be able to
use your oracle database with GeoServer. There is some work
going on by rob atkinson to support "geometryless" tables in
which data is specified in x,y coordinates, etc... and not
necessary a full blown geometry. But that work is still in a
very experimental state from what i believe.

How are you storing your spatial data? I wonder if it might
be possible to "trick" GeoServer into thinking your database
is a spatial one by creating the necessary metadata tables.
Although this would be a stretch.

-Justin

Rishmawi, Sami wrote:
>
>
> I am using an Oracle 10G Server, but do not own the Oracle Spatial
> option. Can I Configure Feature Types? If so, what loss of
capability
> will I have without the Oracle Spatial Option?
>
>
>
> Sami Rishmawi ( sami@anonymised.com <mailto: sami@anonymised.com

<mailto:sami@anonymised.com> > )

>

________________________________________________________________________
___

    Australian Antarctic Division - Commonwealth of Australia
IMPORTANT: This transmission is intended for the addressee only. If you
are not the
intended recipient, you are notified that use or dissemination of this
communication is
strictly prohibited by Commonwealth law. If you have received this
transmission in error,
please notify the sender immediately by e-mail or by telephoning +61 3
6232 3209 and
DELETE the message.
        Visit our web site at http://www.antarctica.gov.au/
________________________________________________________________________
___

------------------------------------------------------------------------
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users