I'm trying to run an Oracle Spatial (10g R2) datastore on Geoserver 1.3.2.
When I fire up Geoserver i get the error:
No CRS for SRID 8307 (WGS84). I did a search and this points back to
geotools, but the post was from Feb this year. Anyone have similar
issues/solutions?
Thanks
--
View this message in context: http://www.nabble.com/No-CRS-for-SRID-tf2382107.html#a6638803
Sent from the GeoServer - User mailing list archive at Nabble.com.
SRID 8307: is this something defined in your Oracle Spatial? I dont
see it in geoserver's list.
Alex
On 10/4/06, firecat <billtenbroeck@anonymised.com> wrote:
I'm trying to run an Oracle Spatial (10g R2) datastore on Geoserver 1.3.2.
When I fire up Geoserver i get the error:
No CRS for SRID 8307 (WGS84). I did a search and this points back to
geotools, but the post was from Feb this year. Anyone have similar
issues/solutions?Thanks
Yes, this an SRID that is standard to Oracle. When you say you don't see it in geoserver's list, where are you looking? In the code, or the interface?
Alexander Petkov wrote:
SRID 8307: is this something defined in your Oracle Spatial? I dont
see it in geoserver's list.Alex
On 10/4/06, firecat <billtenbroeck@anonymised.com> wrote:
I'm trying to run an Oracle Spatial (10g R2) datastore on Geoserver 1.3.2.
When I fire up Geoserver i get the error:
No CRS for SRID 8307 (WGS84). I did a search and this points back to
geotools, but the post was from Feb this year. Anyone have similar
issues/solutions?Thanks
The interface:
http://localhost:8080/geoserver/srsHelp.do
Alex
On 10/5/06, Bill Ten Broeck <billtenbroeck@anonymised.com> wrote:
Yes, this an SRID that is standard to Oracle. When you say you don't see
it in geoserver's list, where are you looking? In the code, or the
interface?Alexander Petkov wrote:
> SRID 8307: is this something defined in your Oracle Spatial? I dont
> see it in geoserver's list.
>
> Alex
>
> On 10/4/06, firecat <billtenbroeck@anonymised.com> wrote:
>>
>> I'm trying to run an Oracle Spatial (10g R2) datastore on Geoserver
>> 1.3.2.
>> When I fire up Geoserver i get the error:
>> No CRS for SRID 8307 (WGS84). I did a search and this points back to
>> geotools, but the post was from Feb this year. Anyone have similar
>> issues/solutions?
>>
>> Thanks
>
It appears from this page that these are all EPSG, so I think the mapping would be Oracle SRID 8307 = EPSG 4326. I was guessing that there was some sort of internal lookup since the provider seems to be reading the SRID out of Oracle. Just starting with Geoserver though...
Alexander Petkov wrote:
The interface:
http://localhost:8080/geoserver/srsHelp.doAlex
On 10/5/06, Bill Ten Broeck <billtenbroeck@anonymised.com> wrote:
Yes, this an SRID that is standard to Oracle. When you say you don't see
it in geoserver's list, where are you looking? In the code, or the
interface?Alexander Petkov wrote:
> SRID 8307: is this something defined in your Oracle Spatial? I dont
> see it in geoserver's list.
>
> Alex
>
> On 10/4/06, firecat <billtenbroeck@anonymised.com> wrote:
>>
>> I'm trying to run an Oracle Spatial (10g R2) datastore on Geoserver
>> 1.3.2.
>> When I fire up Geoserver i get the error:
>> No CRS for SRID 8307 (WGS84). I did a search and this points back to
>> geotools, but the post was from Feb this year. Anyone have similar
>> issues/solutions?
>>
>> Thanks
>
I was guessing that there
was some sort of internal lookup since the provider seems to be reading
the SRID out of Oracle. Just starting with Geoserver though...
I think you are correct--try configuring the data as EPSG:4326 in geoserver.
Alex
Alexander Petkov wrote:
> The interface:
> http://localhost:8080/geoserver/srsHelp.do
>
> Alex
>
> On 10/5/06, Bill Ten Broeck <billtenbroeck@anonymised.com> wrote:
>> Yes, this an SRID that is standard to Oracle. When you say you don't see
>> it in geoserver's list, where are you looking? In the code, or the
>> interface?
>>
>> Alexander Petkov wrote:
>> > SRID 8307: is this something defined in your Oracle Spatial? I dont
>> > see it in geoserver's list.
>> >
>> > Alex
>> >
>> > On 10/4/06, firecat <billtenbroeck@anonymised.com> wrote:
>> >>
>> >> I'm trying to run an Oracle Spatial (10g R2) datastore on Geoserver
>> >> 1.3.2.
>> >> When I fire up Geoserver i get the error:
>> >> No CRS for SRID 8307 (WGS84). I did a search and this points back to
>> >> geotools, but the post was from Feb this year. Anyone have similar
>> >> issues/solutions?
>> >>
>> >> Thanks
>> >
>>
>
It's actually setup that way already, so I just tried the opposite (Set the CRS to 8307) returns the same error.
Alexander Petkov wrote:
I was guessing that there
was some sort of internal lookup since the provider seems to be reading
the SRID out of Oracle. Just starting with Geoserver though...I think you are correct--try configuring the data as EPSG:4326 in geoserver.
Alex
Alexander Petkov wrote:
> The interface:
> http://localhost:8080/geoserver/srsHelp.do
>
> Alex
>
> On 10/5/06, Bill Ten Broeck <billtenbroeck@anonymised.com> wrote:
>> Yes, this an SRID that is standard to Oracle. When you say you don't see
>> it in geoserver's list, where are you looking? In the code, or the
>> interface?
>>
>> Alexander Petkov wrote:
>> > SRID 8307: is this something defined in your Oracle Spatial? I dont
>> > see it in geoserver's list.
>> >
>> > Alex
>> >
>> > On 10/4/06, firecat <billtenbroeck@anonymised.com> wrote:
>> >>
>> >> I'm trying to run an Oracle Spatial (10g R2) datastore on Geoserver
>> >> 1.3.2.
>> >> When I fire up Geoserver i get the error:
>> >> No CRS for SRID 8307 (WGS84). I did a search and this points back to
>> >> geotools, but the post was from Feb this year. Anyone have similar
>> >> issues/solutions?
>> >>
>> >> Thanks
>> >
>>
>
This looks to be an already identified problem:
http://jira.codehaus.org/browse/GEOT-826
As a hack, you can try to define 8307 in Geoserver by giving it the
WKT text for 4326, see
http://docs.codehaus.org/display/GEOSDOC/Custom+projection+definition+in+Geoserver
Any other ideas?
Alex
On 10/5/06, Bill Ten Broeck <billtenbroeck@anonymised.com> wrote:
It's actually setup that way already, so I just tried the opposite (Set
the CRS to 8307) returns the same error.Alexander Petkov wrote:
>> I was guessing that there
>> was some sort of internal lookup since the provider seems to be reading
>> the SRID out of Oracle. Just starting with Geoserver though...
>
> I think you are correct--try configuring the data as EPSG:4326 in
> geoserver.
>
> Alex
>
>> Alexander Petkov wrote:
>> > The interface:
>> > http://localhost:8080/geoserver/srsHelp.do
>> >
>> > Alex
>> >
>> > On 10/5/06, Bill Ten Broeck <billtenbroeck@anonymised.com> wrote:
>> >> Yes, this an SRID that is standard to Oracle. When you say you
>> don't see
>> >> it in geoserver's list, where are you looking? In the code, or the
>> >> interface?
>> >>
>> >> Alexander Petkov wrote:
>> >> > SRID 8307: is this something defined in your Oracle Spatial? I dont
>> >> > see it in geoserver's list.
>> >> >
>> >> > Alex
>> >> >
>> >> > On 10/4/06, firecat <billtenbroeck@anonymised.com> wrote:
>> >> >>
>> >> >> I'm trying to run an Oracle Spatial (10g R2) datastore on Geoserver
>> >> >> 1.3.2.
>> >> >> When I fire up Geoserver i get the error:
>> >> >> No CRS for SRID 8307 (WGS84). I did a search and this points
>> back to
>> >> >> geotools, but the post was from Feb this year. Anyone have similar
>> >> >> issues/solutions?
>> >> >>
>> >> >> Thanks
>> >> >
>> >>
>> >
>>
>
The suggestion to create an alias to mdsys.cs_srs worked. I can now get WMS layers out of Oracle.
WFS is another story, but we'll leave that for another day. 
Thank you Alex.
Alexander Petkov wrote:
This looks to be an already identified problem:
http://jira.codehaus.org/browse/GEOT-826
As a hack, you can try to define 8307 in Geoserver by giving it the
WKT text for 4326, see
http://docs.codehaus.org/display/GEOSDOC/Custom+projection+definition+in+GeoserverAny other ideas?
Alex
On 10/5/06, Bill Ten Broeck <billtenbroeck@anonymised.com> wrote:
The suggestion to create an alias to mdsys.cs_srs worked. I can now get
WMS layers out of Oracle.WFS is another story, but we'll leave that for another day.
Thank you Alex.
You are welcome, glad it worked.
Alex