Spatial Geometry problem

Guest · October 9, 2009, 5:04am

Morning all.

Just noticed a funny with a select of a spatial geometry column from a
table. In 9.5GA I get the following result:

GEOMETRY
(2003, 81989, , (1, 1003, 1, , , , , , , , , , , , , , , , , , , , , , ,
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
, , ), (532414.91, 185974.57, 532432.37, 185974.57, 532432.37,
185862.87, 532450.99, 185862.87, 532450.99, 185807.02, 532488.22,
185788.4, 532488.22, 185751.17, 532525.46, 185732.55, 532544.07,
185658.09, 532581.31, 185658.09, 532693.01, 185527.77, 532730.24,
185527.77, 532767.47, 185471.92, 532804.7, 185471.92, 532823.32,
185434.69, 532897.79, 185416.07, 532897.79, 185397.46, 533158.42,
185397.46, 533195.65, 185360.22, 533232.88, 185360.22, 533232.88,
185341.61, 533270.12, 185341.61, 533270.12, 185322.99, 533307.35,
185322.99, 533325.97, 185248.52, 533344.58, 185248.52, 533344.58,
185155.44, 533381.81, 185118.21, 533381.81, 185080.98, 533400.43,
185080.98, 533400.43, 185043.74, 533419.05, 185043.74, 533419.05,
185006.51, 533437.66, 185006.51, 533437.66, 184969.28, 533456.28,
184969.28, 533456.28, 184820.34, 533437.66, 184801.73, 533381.81,
184801.73, 533381.81, 184783.11, 532972.25, 184801.73, 532990.87,
184634.18, 532972.25, 184634.18, 532916.4, 184243.23, 532897.79,
184243.23, 532897.79, 184168.77, 532879.17, 184168.77, 532879.17,
184094.3, 532860.55, 184094.3, 532860.55, 184019.84))

But from SQL*Plus, I get much more data and less consecutive commas:

GEOMETRY(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO,
SDO_ORDINATES)

SDO_GEOMETRY(2003, 81989, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1),
SDO_ORDINATE_AR
RAY(532414.91, 185974.57, 532432.37, 185974.57, 532432.37, 185862.87,
532450.99,
185862.87, 532450.99, 185807.02, 532488.22, 185788.4, 532488.22,
185751.17, 532
525.46, 185732.55, 532544.07, 185658.09, 532581.31, 185658.09,
532693.01, 185527
.77, 532730.24, 185527.77, 532767.47, 185471.92, 532804.7, 185471.92,
532823.32,
185434.69, 532897.79, 185416.07, 532897.79, 185397.46, 533158.42,
185397.46, 53
3195.65, 185360.22, 533232.88, 185360.22, 533232.88, 185341.61,
533270.12, 18534
1.61, 533270.12, 185322.99, 533307.35, 185322.99, 533325.97, 185248.52,
533344.5
8, 185248.52, 533344.58, 185155.44, 533381.81, 185118.21, 533381.81,
185080.98,
533400.43, 185080.98, 533400.43, 185043.74, 533419.05, 185043.74,
533419.05, 185
006.51, 533437.66, 185006.51, 533437.66, 184969.28, 533456.28,
184969.28, 533456
.28, 184820.34, 533437.66, 184801.73, 533381.81, 184801.73, 533381.81,
184783.11

it!>

4352.86, 188578.99, 534344.13, 188521.08, 534344.93, 188479.82,
534362.37, 18842
8.25, 534376.46, 188396.56, 534359.45, 188226.49, 533700.05, 187690.72,
532504.8
6, 186454.33, 532414.91, 185974.57))

I can let you have an export of the row in question if you need it.

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Questions? Try the on-line FAQ: http://asktoad.com/DWiki/doku.php?id=faq:questions

Trouble downloading or running the freeware update? See http://asktoad.com/DWiki/doku.php/howto_install_and_update_freetoad

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more - http://www.toadsoft.com/maillist.htmYahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

Your email settings:
Individual Email | Traditional

To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

To change settings via email:
mailto:toad-digest@yahoogroups.com
mailto:toad-fullfeatured@yahoogroups.com

To unsubscribe from this group, send an email to:
toad-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Guest · October 9, 2009, 6:26am

Good Afternoon Norm

which SRID …?

Martin Gainty

We'll have to tell the prime minister Operation Undertow is dead in the water.
She'll have our guts for garters!
--Ian Fleming

When purchasing advice for free …you always get what you paid for

To: toad@yahoogroups.com
From: toad@dunbar-it.co.uk
Date: Fri, 9 Oct 2009 11:04:52 +0100
Subject: [toad] Spatial Geometry problem

              Morning all.

Just noticed a funny with a select of a spatial geometry column from a

table. In 9.5GA I get the following result:

GEOMETRY

(2003, 81989, , (1, 1003, 1, , , , , , , , , , , , , , , , , , , , , , ,

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

, , ), (532414.91, 185974.57, 532432.37, 185974.57, 532432.37,

185862.87, 532450.99, 185862.87, 532450.99, 185807.02, 532488.22,

185788.4, 532488.22, 185751.17, 532525.46, 185732.55, 532544.07,

185658.09, 532581.31, 185658.09, 532693.01, 185527.77, 532730.24,

185527.77, 532767.47, 185471.92, 532804.7, 185471.92, 532823.32,

185434.69, 532897.79, 185416.07, 532897.79, 185397.46, 533158.42,

185397.46, 533195.65, 185360.22, 533232.88, 185360.22, 533232.88,

185341.61, 533270.12, 185341.61, 533270.12, 185322.99, 533307.35,

185322.99, 533325.97, 185248.52, 533344.58, 185248.52, 533344.58,

185155.44, 533381.81, 185118.21, 533381.81, 185080.98, 533400.43,

185080.98, 533400.43, 185043.74, 533419.05, 185043.74, 533419.05,

185006.51, 533437.66, 185006.51, 533437.66, 184969.28, 533456.28,

184969.28, 533456.28, 184820.34, 533437.66, 184801.73, 533381.81,

184801.73, 533381.81, 184783.11, 532972.25, 184801.73, 532990.87,

184634.18, 532972.25, 184634.18, 532916.4, 184243.23, 532897.79,

184243.23, 532897.79, 184168.77, 532879.17, 184168.77, 532879.17,

184094.3, 532860.55, 184094.3, 532860.55, 184019.84))

But from SQL*Plus, I get much more data and less consecutive commas:

GEOMETRY(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO,

SDO_ORDINATES)

SDO_GEOMETRY(2003, 81989, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1),

SDO_ORDINATE_AR

RAY(532414.91, 185974.57, 532432.37, 185974.57, 532432.37, 185862.87,

532450.99,

185862.87, 532450.99, 185807.02, 532488.22, 185788.4, 532488.22,

185751.17, 532

525.46, 185732.55, 532544.07, 185658.09, 532581.31, 185658.09,

532693.01, 185527

.77, 532730.24, 185527.77, 532767.47, 185471.92, 532804.7, 185471.92,

532823.32,

185434.69, 532897.79, 185416.07, 532897.79, 185397.46, 533158.42,

185397.46, 53

3195.65, 185360.22, 533232.88, 185360.22, 533232.88, 185341.61,

533270.12, 18534

1.61, 533270.12, 185322.99, 533307.35, 185322.99, 533325.97, 185248.52,

533344.5

8, 185248.52, 533344.58, 185155.44, 533381.81, 185118.21, 533381.81,

185080.98,

533400.43, 185080.98, 533400.43, 185043.74, 533419.05, 185043.74,

533419.05, 185

006.51, 533437.66, 185006.51, 533437.66, 184969.28, 533456.28,

184969.28, 533456

.28, 184820.34, 533437.66, 184801.73, 533381.81, 184801.73, 533381.81,

184783.11

<SNIP of many many lines of digits here - it’s boring reading through

it!>

4352.86, 188578.99, 534344.13, 188521.08, 534344.93, 188479.82,

534362.37, 18842

8.25, 534376.46, 188396.56, 534359.45, 188226.49, 533700.05, 187690.72,

532504.8

6, 186454.33, 532414.91, 185974.57))

I can let you have an export of the row in question if you need it.

Cheers,

Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.

We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Hotmail: Powerful Free email with security by Microsoft. Get it now.

.,._

`
Questions? Try the on-line FAQ: http://asktoad.com/DWiki/doku.php?id=faq:questions

Trouble downloading or running the freeware update? See http://asktoad.com/DWiki/doku.php/howto_install_and_update_freetoad

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more - http://www.toadsoft.com/maillist.htm`

  Your email settings: Individual Email|Traditional

  [Change settings via the Web](http://groups.yahoo.com/group/toad/join;_ylc=X3oDMTJmbm9ucGRnBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyNTUwODc2NTQ-) (Yahoo! ID required)

  Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured

       [
    Visit Your Group
  ](http://groups.yahoo.com/group/toad;_ylc=X3oDMTJkY25zbTA2BF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjU1MDg3NjU0) |
  [
    Yahoo! Groups Terms of Use
  ](http://docs.yahoo.com/info/terms/) |

   Unsubscribe

,.,_

Guest · October 9, 2009, 6:34am

Hi Martin,

which SRID ..?
You might be mistaking me for someone who knows about Spatial. I don't,
sorry!

I was asked to select a geometry column from a table for a given pk
value, in Toad, I got what appeared to be a full result, but I was told
off about using Toad because "it doesn't show all the values".

When I tried the same select in SQL*Plus, it showed a huge amount of
additional numbers and far fewer consecutive commas - hence my question.

I have no idea what an SRID is. ;-(

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Questions? Try the on-line FAQ: http://asktoad.com/DWiki/doku.php?id=faq:questions

Trouble downloading or running the freeware update? See http://asktoad.com/DWiki/doku.php/howto_install_and_update_freetoad

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more - http://www.toadsoft.com/maillist.htmYahoo! Groups Links

To visit your group on the web, go to:
Yahoo | Mail, Weather, Search, Politics, News, Finance, Sports & Videos

Your email settings:
Individual Email | Traditional

To change settings online go to:
Yahoo | Mail, Weather, Search, Politics, News, Finance, Sports & Videos
(Yahoo! ID required)

To change settings via email:
mailto:toad-digest@yahoogroups.com
mailto:toad-fullfeatured@yahoogroups.com

To unsubscribe from this group, send an email to:
toad-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
Yahoo | Mail, Weather, Search, Politics, News, Finance, Sports & Videos

Guest · October 9, 2009, 7:21am

spatial reference identifier originally coined by
European Petroleum Survey Group

to quote wikipedia
"SRIDs are typically associated with a well known text (WKT) string
definition of the coordinate system (SRTEXT, above). From the Well Known Text Wikipedia page, “A WKT string for a spatial reference system describes the datum, geoid, coordinate system, and map projection of the spatial objects”.

so when encoding or decoding data one can always perform operations with the same SRID
any operations using a different spatial reference system would need to transform their coordinates to the referencing SRID and then perform any operations such as lat/long deltas

cheers
Martin Gainty

Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.

Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.

To: toad@yahoogroups.com
From: toad@dunbar-it.co.uk
Date: Fri, 9 Oct 2009 12:34:21 +0100
Subject: RE: [toad] Spatial Geometry problem

              Hi Martin,

which SRID ..?

You might be mistaking me for someone who knows about Spatial. I don't,

sorry!

I was asked to select a geometry column from a table for a given pk

value, in Toad, I got what appeared to be a full result, but I was told

off about using Toad because "it doesn't show all the values".

When I tried the same select in SQL*Plus, it showed a huge amount of

additional numbers and far fewer consecutive commas - hence my question.

I have no idea what an SRID is. ;-(

Cheers,

Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.

We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Hotmail: Trusted email with powerful SPAM protection. Sign up now.

.,._

`
Questions? Try the on-line FAQ: http://asktoad.com/DWiki/doku.php?id=faq:questions

Trouble downloading or running the freeware update? See http://asktoad.com/DWiki/doku.php/howto_install_and_update_freetoad

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more - http://www.toadsoft.com/maillist.htm`

  Your email settings: Individual Email|Traditional

  [Change settings via the Web](http://groups.yahoo.com/group/toad/join;_ylc=X3oDMTJmaTF1cHU3BF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyNTUwOTA5NDg-) (Yahoo! ID required)

  Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured

       [
    Visit Your Group
  ](http://groups.yahoo.com/group/toad;_ylc=X3oDMTJkNzhjb2N0BF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjU1MDkwOTQ4) |
  [
    Yahoo! Groups Terms of Use
  ](http://docs.yahoo.com/info/terms/) |

   Unsubscribe

,.,_

Guest · October 9, 2009, 7:38am

the geo_srid mentioned in the snippet below (marked red) is 81989.

"The names which may be used to access projections via their Oracle SRID number, e.g. 8307 is Longitude/Latitude, 81989 is the UK National Grid." (from http://doc.xmarc.net/xmarc7/es/Fire/refman/srid_num_identifiers.htm)

So the coordinates should point to the U.K.

Jörgen Adriaanse
Gemeente Renkum

Where would we be without the internet ;->

Martin Gainty 9-10-2009 13:26 >>>

Good Afternoon Norm

which SRID ..?

Martin Gainty

We'll have to tell the prime minister Operation Undertow is dead in the water.She'll have our guts for garters!--Ian Fleming______________________________________________
When purchasing advice for free ..you always get what you paid for

To: toad@yahoogroups.com
From: toad@dunbar-it.co.uk
Date: Fri, 9 Oct 2009 11:04:52 +0100
Subject: [toad] Spatial Geometry problem

Morning all.

Just noticed a funny with a select of a spatial geometry column from a
table. In 9.5GA I get the following result:

GEOMETRY
(2003, 81989, , (1, 1003, 1, , , , , , , , , , , , , , , , , , , , , , ,
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
, , ), (532414.91, 185974.57, 532432.37, 185974.57, 532432.37,
185862.87, 532450.99, 185862.87, 532450.99, 185807.02, 532488.22,
185788.4, 532488.22, 185751.17, 532525.46, 185732.55, 532544.07,
185658.09, 532581.31, 185658.09, 532693.01, 185527.77, 532730.24,
185527.77, 532767.47, 185471.92, 532804.7, 185471.92, 532823.32,
185434.69, 532897.79, 185416.07, 532897.79, 185397.46, 533158.42,
185397.46, 533195.65, 185360.22, 533232.88, 185360.22, 533232.88,
185341.61, 533270.12, 185341.61, 533270.12, 185322.99, 533307.35,
185322.99, 533325.97, 185248.52, 533344.58, 185248.52, 533344.58,
185155.44, 533381.81, 185118.21, 533381.81, 185080.98, 533400.43,
185080.98, 533400.43, 185043.74, 533419.05, 185043.74, 533419.05,
185006.51, 533437.66, 185006.51, 533437.66, 184969.28, 533456.28,
184969.28, 533456.28, 184820.34, 533437.66, 184801.73, 533381.81,
184801.73, 533381.81, 184783.11, 532972.25, 184801.73, 532990.87,
184634.18, 532972.25, 184634.18, 532916.4, 184243.23, 532897.79,
184243.23, 532897.79, 184168.77, 532879.17, 184168.77, 532879.17,
184094.3, 532860.55, 184094.3, 532860.55, 184019.84))

But from SQL*Plus, I get much more data and less consecutive commas:

GEOMETRY(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO,
SDO_ORDINATES)

SDO_GEOMETRY(2003, 81989, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1),
SDO_ORDINATE_AR
RAY(532414.91, 185974.57, 532432.37, 185974.57, 532432.37, 185862.87,
532450.99,
185862.87, 532450.99, 185807.02, 532488.22, 185788.4, 532488.22,
185751.17, 532
525.46, 185732.55, 532544.07, 185658.09, 532581.31, 185658.09,
532693.01, 185527
.77, 532730.24, 185527.77, 532767.47, 185471.92, 532804.7, 185471.92,
532823.32,
185434.69, 532897.79, 185416.07, 532897.79, 185397.46, 533158.42,
185397.46, 53
3195.65, 185360.22, 533232.88, 185360.22, 533232.88, 185341.61,
533270.12, 18534
1.61, 533270.12, 185322.99, 533307.35, 185322.99, 533325.97, 185248.52,
533344.5
8, 185248.52, 533344.58, 185155.44, 533381.81, 185118.21, 533381.81,
185080.98,
533400.43, 185080.98, 533400.43, 185043.74, 533419.05, 185043.74,
533419.05, 185
006.51, 533437.66, 185006.51, 533437.66, 184969.28, 533456.28,
184969.28, 533456
.28, 184820.34, 533437.66, 184801.73, 533381.81, 184801.73, 533381.81,
184783.11

it!>

4352.86, 188578.99, 534344.13, 188521.08, 534344.93, 188479.82,
534362.37, 18842
8.25, 534376.46, 188396.56, 534359.45, 188226.49, 533700.05, 187690.72,
532504.8
6, 186454.33, 532414.91, 185974.57))

I can let you have an export of the row in question if you need it.

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Hotmail: Powerful Free email with security by Microsoft. Get it now.

the geo_srid mentioned in the snippet below (marked red) is 81989.

"The names which may be used to access projections via their Oracle SRID number, e.g. 8307 is Longitude/Latitude, 81989 is the UK National Grid." (from http://doc.xmarc.net/xmarc7/es/Fire/refman/srid_num_identifiers.htm)

So the coordinates should point to the U.K.

Jörgen Adriaanse

Gemeente Renkum

Where would we be without the internet ;->

Martin Gainty mgainty@hotmail.com 9-10-2009 13:26 >>>

Good Afternoon Norm

which SRID ..?

Martin Gainty

We'll have to tell the prime minister Operation Undertow is dead in the water.
She'll have our guts for garters!
--Ian Fleming

When purchasing advice for free ..you always get what you paid for

To: toad@yahoogroups.com
From: toad@dunbar-it.co.uk
Date: Fri, 9 Oct 2009 11:04:52 +0100
Subject: [toad] Spatial Geometry problem

Morning all.

Just noticed a funny with a select of a spatial geometry column from a
table. In 9.5GA I get the following result:

GEOMETRY
(2003, 81989, , (1, 1003, 1, , , , , , , , , , , , , , , , , , , , , , ,
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
, , ), (532414.91, 185974.57, 532432.37, 185974.57, 532432.37,
185862.87, 532450.99, 185862.87, 532450.99, 185807.02, 532488.22,
185788.4, 532488.22, 185751.17, 532525.46, 185732.55, 532544.07,
185658.09, 532581.31, 185658.09, 532693.01, 185527.77, 532730.24,
185527.77, 532767.47, 185471.92, 532804.7, 185471.92, 532823.32,
185434.69, 532897.79, 185416.07, 532897.79, 185397.46, 533158.42,
185397.46, 533195.65, 185360.22, 533232.88, 185360.22, 533232.88,
185341.61, 533270.12, 185341.61, 533270.12, 185322.99, 533307.35,
185322.99, 533325.97, 185248.52, 533344.58, 185248.52, 533344.58,
185155.44, 533381.81, 185118.21, 533381.81, 185080.98, 533400.43,
185080.98, 533400.43, 185043.74, 533419.05, 185043.74, 533419.05,
185006.51, 533437.66, 185006.51, 533437.66, 184969.28, 533456.28,
184969.28, 533456.28, 184820.34, 533437.66, 184801.73, 533381.81,
184801.73, 533381.81, 184783.11, 532972.25, 184801.73, 532990.87,
184634.18, 532972.25, 184634.18, 532916.4, 184243.23, 532897.79,
184243.23, 532897.79, 184168.77, 532879.17, 184168.77, 532879.17,
184094.3, 532860.55, 184094.3, 532860.55, 184019.84))

But from SQL*Plus, I get much more data and less consecutive commas:

GEOMETRY(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO,
SDO_ORDINATES)

SDO_GEOMETRY(2003, 81989, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1),
SDO_ORDINATE_AR
RAY(532414.91, 185974.57, 532432.37, 185974.57, 532432.37, 185862.87,
532450.99,
185862.87, 532450.99, 185807.02, 532488.22, 185788.4, 532488.22,
185751.17, 532
525.46, 185732.55, 532544.07, 185658.09, 532581.31, 185658.09,
532693.01, 185527
.77, 532730.24, 185527.77, 532767.47, 185471.92, 532804.7, 185471.92,
532823.32,
185434.69, 532897.79, 185416.07, 532897.79, 185397.46, 533158.42,
185397.46, 53
3195.65, 185360.22, 533232.88, 185360.22, 533232.88, 185341.61,
533270.12, 18534
1.61, 533270.12, 185322.99, 533307.35, 185322.99, 533325.97, 185248.52,
533344.5
8, 185248.52, 533344.58, 185155.44, 533381.81, 185118.21, 533381.81,
185080.98,
533400.43, 185080.98, 533400.43, 185043.74, 533419.05, 185043.74,
533419.05, 185
006.51, 533437.66, 185006.51, 533437.66, 184969.28, 533456.28,
184969.28, 533456
.28, 184820.34, 533437.66, 184801.73, 533381.81, 184801.73, 533381.81,
184783.11

4352.86, 188578.99, 534344.13, 188521.08, 534344.93, 188479.82,
534362.37, 18842
8.25, 534376.46, 188396.56, 534359.45, 188226.49, 533700.05, 187690.72,
532504.8
6, 186454.33, 532414.91, 185974.57))

I can let you have an export of the row in question if you need it.

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Hotmail: Powerful Free email with security by Microsoft. Get it now.

[att1.dat]
[att1.dat]

Attachment not added (content type not allowed): "att1.dat"
att1.dat (1.79 KB)

Guest · October 9, 2009, 8:19am

color:#1F497D’>Doesn’t look very fun, but sure, sure, send it over.

color:#1F497D’>

From:
style=‘font-size:10.0pt;font-family:“Tahoma”,“sans-serif”’>
toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Dunbar,
Norman

Sent: Friday, October 09, 2009 5:05 AM

To: toad@yahoogroups.com

Subject: [toad] Spatial Geometry problem