[Geoserver-devel] SHP - ORACLE

GeoServer GeoServer Developer
1

Hello,
I need to develop an application with GeoServer viewer and OperLayer with
Oracle database and 10 with Spatial Data Option (SDO).
In a first stage, I used the technique "shapefile + dbf" and everything
works correctly.
It was then asked to "migrate" a DBF data to Oracle (with SDO);

Now, my application works with 2 shapefile displaying Italy for "provinces
and regions."

The two shapefile seem to have two different systems of reference! !! :-U

The provinces (province.shp) works in declaring Geoserver SRS 4632 (min long
6.615425724536874 , max long 18.518952153435485) and with the utility Java
"SampleShapefileToJGeomFeature.java" I uploaded data "geography" in the
Oracle table (with SDO_GEOMETRY the field) correctly.

Now I am trying to convert the shapefile of the Regions (regioni.shp) but
also displaying viewer shp known that the coordinates are displayed
reference values very different from the provinces.

Indeed when I "load" it in geoserver and then in oracle I can NOT see the
map!
Also setting the SRS as above 4632 values get min long 313361.000039426 and
max long 1312124.375.

I can not go on! Help me!
Diana
--
View this message in context: http://www.nabble.com/SHP---ORACLE-tf4698086.html#a13429860
Sent from the GeoServer - Dev mailing list archive at Nabble.com.

2

diana2 ha scritto:

Hello, I need to develop an application with GeoServer viewer and OperLayer with
Oracle database and 10 with Spatial Data Option (SDO). In a first stage, I used the technique "shapefile + dbf" and everything
works correctly. It was then asked to "migrate" a DBF data to Oracle (with SDO);

Now, my application works with 2 shapefile displaying Italy for "provinces
and regions."

The two shapefile seem to have two different systems of reference! !! :-U

The provinces (province.shp) works in declaring Geoserver SRS 4632 (min long
6.615425724536874 , max long 18.518952153435485) and with the utility Java
"SampleShapefileToJGeomFeature.java" I uploaded data "geography" in the
Oracle table (with SDO_GEOMETRY the field) correctly.

Now I am trying to convert the shapefile of the Regions (regioni.shp) but
also displaying viewer shp known that the coordinates are displayed
reference values very different from the provinces.

Indeed when I "load" it in geoserver and then in oracle I can NOT see the
map!
Also setting the SRS as above 4632 values get min long 313361.000039426 and
max long 1312124.375.

I can not go on! Help me!

Diana,
you need to find some information about the original CRS of your shapefiles. If you're lucky, those shapefiles have a xxx.prj file in
the set that you can inspect to guess what the original spatial
reference system is. Otherwise you'll have to guess, but it may
not be easy. Judging by the coordinates you provide regions is in
a projected coordinate system, but there are a few used in italy,
3003, 3004, 26591, 26592, 32632, 32633.
Again, the systems used in Italy are set up so that the
coordinates of the two adjacent code cannot overlap,
so it seems that regioni file is either in 3003, in 26592 or
in 32632.

Either post the contents of the .prj files, if you have them,
or try the above codes. Also, everything seems to indicate you're
italian, there are people much more knowleadgeable than me about
italian coordinate systems on the gfoss mailing list,
(http://www.faunalia.com/cgi-bin/mailman/listinfo/gfoss)
so if nothing works you may try to subscribe and ask there.

Cheers
Andrea

3

I use shp2sdo and sqlldr to perform all my Oracle loads from shapefiles. Both utilities are free/come with Oracle and the documentation is provided on the Oracle forums.

One thing to keep in mind is when renaming or reformating columns (shapefiles are more restrictive than oracle) you can add directives to the CTL file.

DZ

On 10/27/07, Andrea Aime <aaime@anonymised.com> wrote:

diana2 ha scritto:

Hello,
I need to develop an application with GeoServer viewer and OperLayer with
Oracle database and 10 with Spatial Data Option (SDO).
In a first stage, I used the technique “shapefile + dbf” and everything
works correctly.
It was then asked to “migrate” a DBF data to Oracle (with SDO);

Now, my application works with 2 shapefile displaying Italy for “provinces
and regions.”

The two shapefile seem to have two different systems of reference! !! :-U

The provinces (province.shp) works in declaring Geoserver SRS 4632 (min long
6.615425724536874 , max long 18.518952153435485) and with the utility Java
“SampleShapefileToJGeomFeature.java” I uploaded data “geography” in the
Oracle table (with SDO_GEOMETRY the field) correctly.

Now I am trying to convert the shapefile of the Regions (regioni.shp) but
also displaying viewer shp known that the coordinates are displayed
reference values very different from the provinces.

Indeed when I “load” it in geoserver and then in oracle I can NOT see the
map!
Also setting the SRS as above 4632 values get min long 313361.000039426 and
max long 1312124.375.

I can not go on! Help me!

Diana,
you need to find some information about the original CRS of your
shapefiles. If you’re lucky, those shapefiles have a xxx.prj file in
the set that you can inspect to guess what the original spatial
reference system is. Otherwise you’ll have to guess, but it may
not be easy. Judging by the coordinates you provide regions is in
a projected coordinate system, but there are a few used in italy,
3003, 3004, 26591, 26592, 32632, 32633.
Again, the systems used in Italy are set up so that the
coordinates of the two adjacent code cannot overlap,
so it seems that regioni file is either in 3003, in 26592 or
in 32632.

Either post the contents of the .prj files, if you have them,
or try the above codes. Also, everything seems to indicate you’re
italian, there are people much more knowleadgeable than me about
italian coordinate systems on the gfoss mailing list,
(http://www.faunalia.com/cgi-bin/mailman/listinfo/gfoss )
so if nothing works you may try to subscribe and ask there.

Cheers
Andrea

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-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel