Hello Jukka
Thanks for you answer. I have followed your advice by loading into Oracle my
shapefile without specifying any projection.
Then at Geoserver level, i have declared for my featuretype pointing to my
Oracle table that the default projection was 4326.
This is what i obtain using the OL client of Geoserver:
http://193.43.36.238:8484/geoserver/wms?bbox=-198.0,-98.84953231811524,198.0,95.84017868041994&styles=&Format=application/openlayers&request=GetMap&layers=fifao:EEZ_ORA&width=800&height=369&srs=EPSG:4326
A nice map representing the Exclusive Economic Zone for Fisheries.
When i ask to GeoServer to do the reproejction itself (for example, polar
stereographic projection-epsg:3031), this is what i get:
http://193.43.36.238:8484/geoserver/wms?bbox=-2700000,-2500000,3000000,2400000&styles=&Format=application/openlayers&request=GetMap&layers=fifao:EEZ_ORA&width=800&height=362&srs=EPSG:3031
A white map...
What is funny or frustating, is that by clicking in the map, i get
information coming from the Oracle attribute table. For example, by clicking
in the center of the table, I can see that i select Antartica but nothing is
effectively represented, no drawing.
I think Geoserver can not reproject and draw data extracted from an Oracle
DB and by extension can not display/draw projected data stored in Oracle.
In fact, using shapefile or PostGIS data works nicely:
Example with a fetauretype pointing to a shapefile representing the
continents:
http://193.43.36.238:8484/geoserver/wms?bbox=-2700000,-2500000,3000000,2400000&styles=&Format=application/openlayers&request=GetMap&layers=UN_CONTINENT&width=800&height=362&srs=EPSG:3031
Do i add a new bug in JIRA to have it fixed?
Reprojecting on the fly through Geoserver my data stored in Oracle is a
crucial criteria for my application.
Thanks for your help
Sylvain
Jukka Rahkonen wrote:
Hi,
Perhaps you could try what happens if you load the data into Oracle
without setting any projection in Oracle side? You can still tell
Geoserver that the data is actually EPSG:4326 and Geoserver can do
reprojection to other systems. This way, I hope, you can guarantee that
Oracle is not going to do any reprojection for you and you will have one
moving part less in your system.
In earlier days when Oracle did not support the use of EPSG projection
codes this was the normal way handle this task. Of course it would be
better to keep the data in Oracle with correct projection info, my
suggestion is just for debugging.
-Jukka Rahkonen-
-----Alkuperäinen viesti-----
Lähettäjä: geoserver-users-bounces@lists.sourceforge.net puolesta:
springrider
Lähetetty: to 19.6.2008 21:31
Vastaanottaja: geoserver-users@lists.sourceforge.net
Aihe: [Geoserver-users] Projection and Geoserver with Oracle
Good evening
I have loaded some shapefiles into my Oracle locator DB which covers the
world. When, the projections (EPSG:43216) are specified in Oracle,
Geoserver
has difficulties to display them correctly: some polygons appear and
others
not and when I use the zoom, some new polygons appear and others
disappear...
Before saying that it was a bug of Geoserver, i have tested different
shapefile to Oracle loaders, used the spatial index advisor in Oracle to
verify the geometry of my data and it seems that on the Oracle side, the
data is OK.
By browsing the forum i found this message
http://www.nabble.com/oracle-mercator-projection-to7715361.html, for which
no answer has been provided.
I am more or less in the same situation, when i tried to display projected
data from Oracle using the OL viewer in Geoserver, it fails as described
above and when i tried to reproject a layer from 4326 to 3031 for example,
i
just obtain a white map. Nothing.
The reprojection works perfectly with Shapefile and PostGIS.
It really seems that GeoServer has problem dealing with projections for
data
coming from Oracle.
Thanks a lot in advance for your feedback, this point is a very sensitive
point of my infrastructure considering that i should be able to reproject
on
the fly my GIS data.
Sylvain
PS: I am using Oracle 10.2 and i tried with GS 1.6.2, 1.6.3 with the same
results.
--
View this message in context:
http://www.nabble.com/Projection-and-Geoserver-with-Oracle-tp18015269p18015269.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
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/Projection-and-Geoserver-with-Oracle-tp18015269p18096637.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
