Hi Andrea/Jody, Thanks for the replies.
I did a bit of testing, and it appears that SELECT SDO_CS.MAP_ORACLE_SRID_TO_EPSG(8311) FROM DUAL returns 4326 on Oracle 10g and null in XE. I have verified this with a few other colleagues and they are getting the same results. I am no Oracle guru, but a bit of searching on Google led me to this: http://database.itags.org/oracle/69224/ Perhaps this is why it returns null in XE. With regards to EPSG: 23038. I found them listed here: http://inovagis.terradue.com/giserver/tutorial/epsg.htm http://deegree.sourceforge.net/inf/wmsdoc/html/apa.html Please advise. Thanks. Derrick Wong Software Engineer | ASRDC (Australian Spatial Research Data Commons) Project | CSIRO Phone: +61 8 6436 8945 derrick.w...@csiro.au | www.csiro.au Address: ARRC (Australian Resources Research Centre), 26 Dick Perry Avenue, Kensington WA 6151, Australia PLEASE NOTE The information contained in this email may be confidential or privileged. Any unauthorised use or disclosure is prohibited. If you have received this email in error, please delete it immediately and notify the sender by return email. Thank you. To the extent permitted by law, CSIRO does not represent, warrant and/or guarantee that the integrity of this communication has been maintained or that the communication is free of errors, virus, interception or interference. Please consider the environment before printing this email. -----Original Message----- From: Andrea Aime [mailto:aa...@opengeo.org] Sent: Monday, 14 June 2010 5:38 PM To: Caradoc-Davies, Ben (CESRE, Kensington) Cc: Geotools-Devel list Subject: Re: [Geotools-devel] How to handle Oracle SRID problem Andrea Aime ha scritto: > However I tried the example from an online documentation I've found: > (http://youngcow.net/doc/oracle10g/appdev.102/b14255/sdo_cs_ref.htm#CHDIEJHH) > > SELECT SDO_CS.MAP_ORACLE_SRID_TO_EPSG(82361) FROM DUAL; Forgot to say that the above one worked and returned 23038... Mumble, I looked into the EPSG database and could not find such code! I guess the above function cannot really be trusted? Cheers Andrea -- Andrea Aime OpenGeo - http://opengeo.org Expert service straight from the developers. ------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Geotools-devel mailing list Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel ------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Geotools-devel mailing list Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel