Menu
▾
▴
Re: [Geotools-gt2-users] [geotools-dev] Trouble reading Oracle Geometry
|
From: Jody G. <jod...@gm...> - 2009-11-17 18:26:29
|
Hi Sosna:
We actually have a users list set up on source forge ... geo...@li...
If you could kindly direct your inquiry there.
Jody
On 17/11/2009, at 4:23 PM, sosna wrote:
> Hello
>
> I am a total beginner and i am trying to read geometry stored in Oracle. I
> keep getting "POLYGON EMPTY" when trying to system.out geometry values. Here
> is the code:
>
> public static void main(String[] args) {
>
> Map params = new HashMap();
> //I fill the params
>
> DataStore oracleDatastore = null;
> try {
> oracleDatastore = DataStoreFinder.getDataStore(params);
> } catch (IOException e) {
> // TODO Auto-generated catch block
> e.printStackTrace();
> }finally{
>
> }
>
> FeatureSource fsBC = null;
> try {
> fsBC = oracleDatastore.getFeatureSource("WOJEWODZTWA");
> FeatureCollection fc = fsBC.getFeatures(Query.ALL);
>
> for( Iterator i=fc.iterator(); i.hasNext();){
> SimpleFeatureImpl feature = (SimpleFeatureImpl) i.next();
>
> System.out.println("NAZWA: " + feature.getAttribute("NAZWA"));
> System.out.println("DEFAULT GEOM: " +
> feature.getDefaultGeometry());
> }
> } catch (IOException e) {
> // TODO Auto-generated catch block
> e.printStackTrace();
> }
>
> }
>
> The result is:
> NAZWA: WOJ. ZACHODNIOPOMORSKIE
> DEFAULT GEOM: POLYGON EMPTY
> NAZWA: WOJ. ŚWIĘTOKRZYSKIE
> DEFAULT GEOM: POLYGON EMPTY
> NAZWA: WOJ. WARMIŃSKO-MAZURSKIE
> DEFAULT GEOM: POLYGON EMPTY
> NAZWA: WOJ. KUJAWSKO-POMORSKIE
> DEFAULT GEOM: POLYGON EMPTY
> NAZWA: WOJ. ŁÓDZKIE
> DEFAULT GEOM: POLYGON EMPTY
> NAZWA: WOJ. MAŁOPOLSKIE
> DEFAULT GEOM: POLYGON EMPTY
> NAZWA: WOJ. DOLNOŚLĄSKIE
> DEFAULT GEOM: POLYGON EMPTY
> NAZWA: WOJ. LUBUSKIE
> DEFAULT GEOM: POLYGON EMPTY
> NAZWA: WOJ. DOLNOŚLĄSKIE
> DEFAULT GEOM: POLYGON EMPTY
> NAZWA: WOJ. KUJAWSKO-POMORSKIE
> DEFAULT GEOM: POLYGON EMPTY
> NAZWA: WOJ. LUBELSKIE
> DEFAULT GEOM: POLYGON EMPTY
> NAZWA: WOJ. LUBUSKIE
> DEFAULT GEOM: POLYGON EMPTY
> NAZWA: WOJ. ŁÓDZKIE
> DEFAULT GEOM: POLYGON EMPTY
>
> I know that there is geometry stored. I can draw it using some tools. Below
> i put 2 random rows with geometry column from oracle.
>
> First row:
> MDSYS.SDO_GEOMETRY(2003, null, null, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1,
> null, null, null, null, null, null, null, null, null, null, null, null,
> null, null, null, null, null, null, null, null, null, null, null, null,
> null, null, null, null, null, null, null, null, null, null, null, null,
> null, null, null, null, null, null, null, null, null, null, null, null,
> null, null, null, null, null, null, null, null, null, null, null, null,
> null, null, null, null, null, null, null, null, null, null, null, null,
> null, null, null, null, null, null, null, null, null, null, null, null,
> null, null, null, null, null, null, null, null, null, null, null, null,
> null), MDSYS.SDO_ORDINATE_ARRAY(19.256710, 54.149978, 19.256631, 54.1499,
> 19.255882, 54.149334, 19.255308, 54.148660, 19.254540, 54.147725, 19.253780,
> 54.146949, 19.253029, 54.146331, 19.252279, 54.145712, 19.251791, 54.144984,
> 19.251034, 54.144260, 19.250296, 54.143720, 19.249436, 54.142735, 19.248951,
> 54.142059, 19.248386, 54.141542, 19.247724, 54.140922, 19.247251, 54.140457,
> 19.246593, 54.139889, 19.245511, 54.138118, 19.244597, 54.136132, 19.244642,
> 54.135288, 19.244232, 54.134347, 19.243275, 54.133205, 19.242217, 54.131662,
> 19.241495, 54.130547, 19.241114, 54.130035, 19.240869, 54.129572, 19.240444,
> 54.129061, 19.239825, 54.128242, 19.238631, 54.127407, 19.237805, 54.126826,
> 19.236842, 54.126169, 19.235703, 54.125541, 19.232405, 54.123885, 19.231229,
> 54.123387, 19.230593, 54.123061, 19.229055, 54.122388, 19.227478, 54.121820,
> 19.226076, 54.121196, 19.224801, 54.120492, 19.223493, 54.119824, 19.222482,
> 54.119089, 19.221603, 54.118352, 19.220872, 54.117898, 19.220319, 54.117466,
> 19.219681, 54.117089, 19.218993, 54.116608, 19.218076, 54.115975, 19.217093,
> 54.115005, 19.219121, 54.114942, 19.226506, 54.114771))
>
> Second row:
>
> MDSYS.SDO_GEOMETRY(2003, null, null, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1,
> null, null, null, null, null, null, null, null, null, null, null, null,
> null, null, null, null, null, null, null, null, null, null, null, null,
> null, null, null, null, null, null, null, null, null, null, null, null,
> null, null, null, null, null, null, null, null, null, null, null, null,
> null, null, null, null, null, null, null, null, null, null, null, null,
> null, null, null, null, null, null, null, null, null, null, null, null,
> null, null, null, null, null, null, null, null, null, null, null, null,
> null, null, null, null, null, null, null, null, null, null, null, null,
> null), MDSYS.SDO_ORDINATE_ARRAY(18.266324, 53.738770, 18.267227, 53.739179,
> 18.267847, 53.739520, 18.266732, 53.741128, 18.269549, 53.741573, 18.268740,
> 53.742725, 18.267649, 53.743952, 18.263979, 53.743896, 18.261632, 53.743978,
> 18.260241, 53.744191, 18.257936, 53.744328, 18.257812, 53.744816, 18.257454,
> 53.745379, 18.256882, 53.745692, 18.256222, 53.745949, 18.255252, 53.746036,
> 18.254348, 53.745825, 18.253729, 53.745457, 18.252335, 53.744308, 18.250636,
> 53.742908, 18.249234, 53.743284, 18.248246, 53.743642, 18.250267, 53.744342,
> 18.251111, 53.744770, 18.251322, 53.745047, 18.250315, 53.744997, 18.248009,
> 53.744454, 18.245647, 53.744072, 18.242510, 53.743592, 18.238785, 53.742988,
> 18.230746, 53.741658, 18.224521, 53.740670, 18.218847, 53.739694, 18.219382,
> 53.741993, 18.220134, 53.745876, 18.217737, 53.745330, 18.217218, 53.745536,
> 18.217147, 53.745915, 18.217241, 53.746571, 18.216496, 53.746717, 18.215352,
> 53.746663, 18.213806, 53.746436, 18.212870, 53.746006, 18.212068, 53.745633,
> 18.211518, 53.745620, 18.211160, 53.744795, 18.209726, 53.744952, 18.2095,
> 53.744212, 18.209346, 53.743773, 18.208953, 53.743464))
>
> What i am doing wrong? My task is to copy this geometry to postgis but i am
> stuck at reading it. I want to read its cooridinates then insert into
> postgis.
> --
> View this message in context: http://old.nabble.com/Trouble-reading-Oracle-Geometry-tp26394994p26394994.html
> Sent from the geotools - dev mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe from this list, please visit:
>
> http://xircles.codehaus.org/manage_email
>
>
|
