From: Yuci Gou [mailto:[email protected]]
Sent: 18 April 2011 18:02
To: Steve Way
Cc: [email protected]
Subject: Re: [Geoserver-users] Question about GeoServer (or GeoTools) support
for Oracle Spatial
Hi Steve,
Thank you for your quick reply. And how about Oracle Spatial specialist
functions, such as routing, geocoding and analysis mining? Wonder if they can
be leveraged by GeoServer?
I think Andrea already replied to this, but you would have to write WPS
processes to leverage these functions.
And by the way, just curious, the new Oracle GeoRaster plugin you developed
mosaicks raster tiles on the fly, while the current plugin makes use of the
mosaicked already. Could you please explain a little bit why the performance is
better while seemingly doing more work (I mean mosaicking on the fly)? Thank
you!
Yeah, the current one uses the Oracle Function ExportTo to export the image out
of the DB - there is a limit on file size (think it is 64mb) using this method.
There is also an issue with the current one which I am yet to raise using a
JIRA but basically the temporary space that it allocates to creating the BLOB
is not released so evenetually, the temp tablespace will continue to grow until
the tablespace limit is reached.
With the raster plugin we have developed (extends imagemosiac-jdbc plugin), you
have two options, use native SQL with the ExportTo function, or use the Oracle
Spatial API which uses libs from your Oracle DB installation. The latter
performs much better.
What I am hoping, is that once released, the community will develop this into
something a bit more mature. Probably replacing the ExportTo function with the
GetRasterSubset function which does not have a filesize limit, but would
require you to create the color model and build the image from the BLOB that is
retrieved.
The plugin we have created basically creates a thread for each raster ID in the
request (it gets a list based on the query window), then goes off and gets the
image on each thread, then returns it back to the imagemosaic-jdbc module to
render.
Cheers,
Steve
Best regards,
Yuci
On 18 April 2011 16:11, Steve Way
<[email protected]<mailto:[email protected]>>
wrote:
Hi Yuci,
Oracle Spatial (Vector) is supported by Geotools.
There is also a plugin available for Oracle GeoRaster which is available using
the imagemosaic-jdbc plugin - but this only works on raster which has been
mosaicked within Oracle. I have developed an Oracle GeoRaster plugin which is
faster and has better performance than the current one, which works with raster
tiles mosaicking on the fly without having to pre-process in Oracle. I will
be releasing to the community in the coming weeks.
Cheers,
Steve
From: Yuci Gou [mailto:[email protected]<mailto:[email protected]>]
Sent: 18 April 2011 16:05
To:
[email protected]<mailto:[email protected]>
Subject: [Geoserver-users] Question about GeoServer (or GeoTools) support for
Oracle Spatial
Hi,
Wonder if I could ask a question about GeoTools, which GeoServer uses to access
the data source.
I noticed on this web page at
http://docs.geotools.org/latest/userguide/faq.html#okay-what-data-formats-does-geotools-support,
that Oracle is supported by GeoTools, while Oracle Spatial is not. Wondering
what is the difference?
GeoTools has plug-in called "Oracle GeoRaster Plugin", while GeoRaster is part
of Oracle Spatial. Does this mean that GeoTools already supports Oracle Spatial?
Thank you for your clarification in advance!
Kind regards,
Yuci
________________________________
DISCLAIMER:
This email may contain confidential information and is intended only for the
use of the specific individual(s) to which it is addressed. If you are not the
intended recipient of this email, you are hereby notified that any unauthorized
use, dissemination or copying of this email or the information contained in it
or attached to it is strictly prohibited. If you received this message in
error, please immediately notify the sender at Infotech or
[email protected]<mailto:[email protected]>
and delete the original message.
------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve
application availability and disaster protection. Learn more about boosting
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
