Further to my efforts using Oracle MapViewer and its facilities as a WMS
server for Google Earth instead of Geoserver, you might be interested in my
progress...
I have now been able to view both my polygons (which give the rectangular
footprints of the images I am trying to display) in the SdoGeometry column,
and the images themselves on Google Earth (JPEGS stored as Blobs).
Unfortunately there are two problems
(1) I don't know how to set the background colour to transparent which isn't
a problem with Geoserver, where all you see is the polygons and not a great
wedge of white around them.
(2) The images I want to display are rotated. In Oracle MapViewer you must
define a Bounding Box in the SdoGeometry column consisting of the bottom
left and upper right coordinate of the rectangle of the image in the BLOB
column. This only works of course for the one rectangle that happens to be
parallel to the N-E axes. I have tried loading a poly defining the 4 corners
of the rectangle but it ignores this and continues to display my images
unrotated wrt to NE axes.
I hope whoever writes the facility to display images in Geoserver bears this
in mind!!
I am not off to evaluate ArcSDE to see if this can solve my problem.
Regards
Tony
cholmes wrote:
Unfortunately I don't think there's any good tutorial on how to write a
coverage store. For datastores, the vector side of the equation, there's
a
pretty good tutorial. But basically to get the blobs out of oracle you
need
to write a new reader. Hopefully it could reuse much of the same code.
ArcSDE is probably a decent place to check out the source code, as it
handles both vector and raster.
Note that OpenGeo is starting a contract to rewrite the oracle datastore,
and the result should be much cleaner and more maintainable. If you were
to
take the current code it'd be hard to figure out what's going on. So
perhaps once we get some progress on that we can try to set you up with
some
hints on how to reuse the same oracle connection classes to have it read
coverages.
One other note, if you do manage to get the oracle blobs in to a wms, you
should stick GeoWebCache (http://geowebcache.org) in front of it. This
will
cache the images produced, and give you a streaming effect, since it uses
SuperOverlays. The normal WMS connector in Google Earth is pretty clunky.
Chris
On Wed, Aug 20, 2008 at 11:34 AM, rainers <suddendorf@anonymised.com> wrote:
Hi Andrea,
I have a similar problem. Could you please give me a hint where I can
find
the code mentioned?
May be I can adopt it, so that Tony and I - hopefully others - can use
it.
I
am new to GeoServer and from the Documents it seems not to be enough to
write a new Reader. Any hints would be welcome.
Rainer
Andrea Aime-4 wrote:
>
> Tony Bloomfield ha scritto:
>> I have an Oracle Database Table "IMAGES" in which I store a GeoTIFF
(or
>> NITF)
>> in a column as a "Blob"
>>
>> The table also has a "Geometry" column which
>> stores polygons which define the footprint of the GEOTIFF.
>>
>> I can successfully connect the Geometry column to Google Earth using
>> the URL http://localhost:8080/geoserver/wms/kml_reflect?layers=IMAGES,
>> which displays all the polygons.
>>
>> I can display a single GEOTIFF stored in GEOSERVER using a similar
URL.
>>
>> However I want to be able to display all the GEOTIFF's from all the
>> selected
>> rows
>> in the table, in the same way that all the polygons are displayed.
>>
>> Can anyone help?
>
> I can confirm we have no way to read data that way. If you want to
> support that custom setup, you'll have to write your own reader.
> In GeoTools there is a module bieng developed for the Google summer
> of code that stores image mosaics in a database (both metadata
> and raster data), that might be quite close to what you need.
>
> Cheers
> Andrea
>
>
-------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the
> world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
--
View this message in context:
http://www.nabble.com/Geoserver%2C-Oracle%2C--GeoTiff's-and-Google-Earth-tp18923267p19070155.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the
world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the
world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
View this message in context: http://www.nabble.com/Geoserver%2C-Oracle%2C--GeoTiff's-and-Google-Earth-tp18923267p19163282.html
Sent from the GeoServer - User mailing list archive at Nabble.com.