Toad World® Forums

Spatial Geometry problem


#1

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/


#2

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

,.,_


#3

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:
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/


#4

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

,.,_


#5

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

<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.

[att1.dat]
[att1.dat]

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


#6

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

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

.,._

`
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=X3oDMTJmMHMzZDhvBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyNTUwOTQ0NjM-) (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=X3oDMTJkNzUybmtiBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjU1MDk0NDYz) |
  [
    Yahoo! Groups Terms of Use
  ](http://docs.yahoo.com/info/terms/) |

   Unsubscribe

,.,_


#7

color:#1F497D’>Ph! Well known….

color:#1F497D’>

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

Sent: Friday, October 09, 2009 7:22 AM

To: TOAD Yahoogroup

Subject: RE: [toad] Spatial Geometry problem

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
href=“http://en.wikipedia.org/wiki/Well-known_text#Spatial_Reference_Systems
title=“Well-known text”>Well Known Text Wikipedia page, “A WKT string for a
spatial reference system describes the
href=“http://en.wikipedia.org/wiki/Datum_(geodesy)” title=“Datum (geodesy)”>datum,
geoid,
href=“http://en.wikipedia.org/wiki/Coordinate_system” title=“Coordinate system”>coordinate
system, and
title=“Map projection”>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.
href=“http://clk.atdmt.com/GBL/go/177141665/direct/01/” target="_new">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=X3oDMTJmbGExNWV0BF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyNTUwOTQ0NTk-) (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=X3oDMTJkM3AyMTA3BF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjU1MDk0NDU5) |
  [
    Yahoo! Groups Terms of Use
  ](http://docs.yahoo.com/info/terms/) |

   Unsubscribe

,.,_


#8

color:#1F497D’>Hey Norm,

color:#1F497D’>

font-family:“Calibri”,“sans-serif”;color:#1F497D’>I don’t think any data
is missing, it’s just notated differently.

font-family:“Calibri”,“sans-serif”;color:#1F497D’>

font-family:“Calibri”,“sans-serif”;color:#1F497D’>Here’s SQL Plus:

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

SDO_ORDINATES)



SDO_GEOMETRY(2003, 81989, NULL, SDO_ELEM_INFO_ARRAY(
style=‘color:#00B050’>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,

color:#1F497D’>For the red part - In SQL Plus, you’re getting the NULL
keyword. In Toad, you’re just getting an empty space between
commas.

color:#1F497D’>For the green part – in SQL Plus, it’s just showing
the first 3 values that have data. In Toad, it’s showing the entire
array.

color:#1F497D’>

color:#1F497D’>When I export to insert statements (using 10, I didn’t try
with 9.5), I get an insert statement that works and seems to insert identical
data.

color:#1F497D’>

font-family:Courier;color:blue;background:white;mso-highlight:white’>Insert
style=‘font-size:10.0pt;font-family:“MS Shell Dlg 2”,“sans-serif”;color:black;
background:white;mso-highlight:white’>
font-family:Courier;color:blue;background:white;mso-highlight:white’>into
style=‘font-size:10.0pt;font-family:“MS Shell Dlg 2”,“sans-serif”;color:black;
background:white;mso-highlight:white’>
font-family:“Courier New”;color:blue;background:white;mso-highlight:white’>NFCDD_OWNER
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>.
color:black;background:white;mso-highlight:white’>NORM_SPATIAL
style=‘font-size:10.0pt;font-family:“MS Shell Dlg 2”,“sans-serif”;color:black;
background:white;mso-highlight:white’>

font-family:“MS Shell Dlg 2”,“sans-serif”;color:black;background:white;
mso-highlight:white’>
font-family:Courier;color:blue;background:white;mso-highlight:white’>(
style=‘font-size:10.0pt;font-family:Courier;color:black;background:white;
mso-highlight:white’>GEOMETRY
Courier;color:blue;background:white;mso-highlight:white’>)
style=‘font-size:10.0pt;font-family:“MS Shell Dlg 2”,“sans-serif”;color:black;
background:white;mso-highlight:white’>

font-family:“MS Shell Dlg 2”,“sans-serif”;color:black;background:white;
mso-highlight:white’>
Courier;color:blue;background:white;mso-highlight:white’>Values
style=‘font-size:10.0pt;font-family:“MS Shell Dlg 2”,“sans-serif”;color:black;
background:white;mso-highlight:white’>

font-family:“MS Shell Dlg 2”,“sans-serif”;color:black;background:white;
mso-highlight:white’>
font-family:Courier;color:blue;background:white;mso-highlight:white’>(
style=‘font-size:10.0pt;font-family:“MS Shell Dlg 2”,“sans-serif”;color:black;
background:white;mso-highlight:white’>

font-family:“MS Shell Dlg 2”,“sans-serif”;color:black;background:white;
mso-highlight:white’>
font-family:Courier;color:red;background:white;mso-highlight:white’>“MDSYS”
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>.
color:red;background:white;mso-highlight:white’>“SDO_GEOMETRY”
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>(
color:maroon;background:white;mso-highlight:white’>2003
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>81989
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,NULL,
“MS Shell Dlg 2”,“sans-serif”;color:black;background:white;mso-highlight:white’>

font-family:“MS Shell Dlg 2”,“sans-serif”;color:black;background:white;
mso-highlight:white’>
font-family:Courier;color:red;background:white;mso-highlight:white’>“MDSYS”
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>.
color:red;background:white;mso-highlight:white’>“SDO_ELEM_INFO_ARRAY”
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>(
color:maroon;background:white;mso-highlight:white’>1
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>1003
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>1
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,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),
style=‘font-size:10.0pt;font-family:“MS Shell Dlg 2”,“sans-serif”;color:black;
background:white;mso-highlight:white’>

font-family:“MS Shell Dlg 2”,“sans-serif”;color:black;background:white;
mso-highlight:white’>
font-family:Courier;color:red;background:white;mso-highlight:white’>“MDSYS”
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>.
color:red;background:white;mso-highlight:white’>“SDO_ORDINATE_ARRAY”
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>(
color:maroon;background:white;mso-highlight:white’>532414.91
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185974.57
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532432.37
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185974.57
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532432.37
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185862.87
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532450.99
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185862.87
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532450.99
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185807.02
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532488.22
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185788.4
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532488.22
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185751.17
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532525.46
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185732.55
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532544.07
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185658.09
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532581.31
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185658.09
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532693.01
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185527.77
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532730.24
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185527.77
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532767.47
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185471.92
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532804.7
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185471.92
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532823.32
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185434.69
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532897.79
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185416.07
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532897.79
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185397.46
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533158.42
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185397.46
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533195.65
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185360.22
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533232.88
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185360.22
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533232.88
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185341.61
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533270.12
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185341.61
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533270.12
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185322.99
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533307.35
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185322.99
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533325.97
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185248.52
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533344.58
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185248.52
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533344.58
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185155.44
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533381.81
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185118.21
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533381.81
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185080.98
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533400.43
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185080.98
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533400.43
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185043.74
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533419.05
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185043.74
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533419.05
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185006.51
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533437.66
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>185006.51
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533437.66
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>184969.28
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533456.28
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>184969.28
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533456.28
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>184820.34
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533437.66
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>184801.73
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533381.81
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>184801.73
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>533381.81
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>184783.11
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532972.25
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>184801.73
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532990.87
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>184634.18
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532972.25
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>184634.18
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532916.4
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>184243.23
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532897.79
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>184243.23
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532897.79
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>184168.77
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532879.17
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>184168.77
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-highlight:white’>532879.17
style=‘font-size:10.0pt;font-family:Courier;color:blue;background:white;
mso-highlight:white’>,
color:maroon;background:white;mso-hig


#9

how did you create the MDSYS user?

thanks john
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: john.dorlon@quest.com
Date: Fri, 9 Oct 2009 07:23:03 -0700
Subject: RE: [toad] Spatial Geometry problem

Hey Norm,

I don’t think any data
is missing, it’s just notated differently.

Here’s SQL Plus:

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,

For the red part - In SQL Plus, you’re getting the NULL
keyword. In Toad, you’re just getting an empty space between
commas.

For the green part – in SQL Plus, it’s just showing
the first 3 values that have data. In Toad, it’s showing the entire
array.

When I export to insert statements (using 10, I didn’t try
with 9.5), I get an insert statement that works and seems to insert identical
data.

Insert into NFCDD_OWNER.NORM_SPATIAL

(GEOMETRY)

Values

(

"MDSYS"."SDO_GEOMETRY"(2003,81989,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"(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,


#10

color:#1F497D’>I didn’t. Oracle did.

color:#1F497D’>

color:#1F497D’>I found the problem though. It seems one of the subtypes of SDO_GEOMETRY
is an array that can have up to 1048576 values. Toad is only showing the
first 99 of them. This is probably a limitation in Delphi’s architecture.
I’m sure we’d crash most everyone’s PC if we tried to open a dataset with over
1 million fields.

color:#1F497D’>

color:#1F497D’>So I think this will go into the limitations/known issues part
of our documentation.

color:#1F497D’>

color:#1F497D’>-John

color:#1F497D’>

color:#1F497D’>

color:#1F497D’>

color:#1F497D’>

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

Sent: Friday, October 09, 2009 9:34 AM

To: TOAD Yahoogroup

Subject: RE: [toad] Spatial Geometry problem

how did you create the MDSYS user?

thanks john

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: john.dorlon@quest.com

Date: Fri, 9 Oct 2009 07:23:03 -0700

Subject: RE: [toad] Spatial Geometry problem

Hey Norm,

color:#1F497D’>I don’t think any data is missing, it’s just notated
differently.

color:#1F497D’>

color:#1F497D’>Here’s SQL Plus:

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

SDO_ORDINATES)



SDO_GEOMETRY(2003, 81989, NULL, SDO_ELEM_INFO_ARRAY(
style=‘color:#00B050’>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,

color:#1F497D’>And here’s Toad:

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,

For the red
part - In SQL Plus, you’re getting the NULL keyword. In Toad,
you’re just getting an empty space between commas.

For the
green part – in SQL Plus, it’s just showing the first 3 values that have data.
In Toad, it’s showing the entire array.

When I
export to insert statements (using 10, I didn’t try with 9.5), I get an insert
statement that works and seems to insert identical data.

color:blue’>Insert
style=‘font-size:10.0pt;font-family:Courier;color:blue’>into
style=‘font-size:10.0pt;color:black’>
font-family:“Courier New”;color:blue’>NFCDD_OWNER
style=‘font-size:10.0pt;font-family:Courier;color:blue’>.
style=‘font-size:10.0pt;font-family:Courier;color:black’>NORM_SPATIAL

style=‘font-size:10.0pt;font-family:Courier;color:blue’>(
style=‘font-size:10.0pt;font-family:Courier;color:black’>GEOMETRY
style=‘font-size:10.0pt;font-family:Courier;color:blue’>)

style=‘font-size:10.0pt;font-family:Courier;color:blue’>Values

style=‘font-size:10.0pt;font-family:Courier;color:blue’>(

“MDSYS”
style=‘font-size:10.0pt;font-family:Courier;color:blue’>.
style=‘font-size:10.0pt;font-family:Courier;color:red’>“SDO_GEOMETRY”
style=‘font-size:10.0pt;font-family:Courier;color:blue’>(
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>2003
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>81989
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,NULL,

“MDSYS”
style=‘font-size:10.0pt;font-family:Courier;color:blue’>.
style=‘font-size:10.0pt;font-family:Courier;color:red’>“SDO_ELEM_INFO_ARRAY”
style=‘font-size:10.0pt;font-family:Courier;color:blue’>(
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>1
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>1003
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>1
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,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”
style=‘font-size:10.0pt;font-family:Courier;color:blue’>.
style=‘font-size:10.0pt;font-family:Courier;color:red’>“SDO_ORDINATE_ARRAY”
style=‘font-size:10.0pt;font-family:Courier;color:blue’>(
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532414.91
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185974.57
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532432.37
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185974.57
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532432.37
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185862.87
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532450.99
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185862.87
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532450.99
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185807.02
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532488.22
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185788.4
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532488.22
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185751.17
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532525.46
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185732.55
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532544.07
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185658.09
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532581.31
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185658.09
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532693.01
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185527.77
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532730.24
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185527.77
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532767.47
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185471.92
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532804.7
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185471.92
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532823.32
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185434.69
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532897.79
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185416.07
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532897.79
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185397.46
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533158.42
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185397.46
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533195.65
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185360.22
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533232.88
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185360.22
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533232.88
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185341.61
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533270.12
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185341.61
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533270.12
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185322.99
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533307.35
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185322.99
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533325.97
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185248.52
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533344.58
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185248.52
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533344.58
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185155.44
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533381.81
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185118.21
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533381.81
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185080.98
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533400.43
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185080.98
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533400.43
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185043.74
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533419.05
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185043.74
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533419.05
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185006.51
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533437.66
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>185006.51
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533437.66
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>184969.28
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533456.28
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>184969.28
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533456.28
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>184820.34
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533437.66
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>184801.73
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533381.81
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>184801.73
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>533381.81
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>184783.11
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532972.25
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>184801.73
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532990.87
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>184634.18
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532972.25
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>184634.18
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532916.4
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>184243.23
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532897.79
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>184243.23
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532897.79
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>184168.77
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532879.17
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>184168.77
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532879.17
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>184094.3
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532860.55
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>184094.3
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>532860.55
style=‘font-size:10.0pt;font-family:Courier;color:blue’>,
style=‘font-size:10.0pt;font-family:Courier;color:maroon’>184019.84
style=‘font-size:10.0pt;font-family:Courier;color:blue’>)));

For
comparison, it helps to view the data with Toad’s popup editor.

width=955 height=299 id=“ecxPicture_x0020_15”
src=“cid:image001.png@01CA48C5.78A1FE80”>

color:#1F497D’>

color:#1F497D’>

From:
style=‘font-size:10.0pt’> 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

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.7


#11

Hi John,

I found the problem though. It seems one of the subtypes of
SDO_GEOMETRY is an array that can have up to 1048576 values.
Toad is only showing the first 99 of them. This is
probably a limitation in Delphi’s architecture. I’m sure
we’d crash most everyone’s PC if we tried to open a dataset
with over 1 million fields.

So I think this will go into the limitations/known issues
part of our documentation.

a limitation it is then Thanks. That’ll do me.

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/


#12

color:#1F497D’>It might be nice to have a warning if there are more values to
get or that we’re truncating? Esp when doing edits?

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 10:52 AM

To: toad@yahoogroups.com

Subject: RE: [toad] Spatial Geometry problem

Hi John,

I found the problem though. It seems one of the subtypes of

SDO_GEOMETRY is an array that can have up to 1048576 values.

Toad is only showing the first 99 of them. This is

probably a limitation in Delphi’s architecture. I’m sure

we’d crash most everyone’s PC if we tried to open a dataset

with over 1 million fields.

So I think this will go into the limitations/known issues

part of our documentation.

a limitation it is then Thanks. That’ll do me.

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.htm`

  Your email settings: Individual Email|Traditional

  [Change settings via the Web](http://groups.yahoo.com/group/toad/join;_ylc=X3oDMTJmb3MwZW1lBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyNTUxMDAzMzk-) (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=X3oDMTJkOWs3anU5BF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjU1MTAwMzM5) |
  [
    Yahoo! Groups Terms of Use
  ](http://docs.yahoo.com/info/terms/) |

   Unsubscribe

,.,_


#13

Hi John, Jeff and Norm,

In fact, last I checked, selecting an
sdo_geometry column in SQL Developer for popup will bring everything
to a grinding halt.

Following on Jeff’s suggestion, I think
the one or three spatial users on this forum have occasionally chimed in
with a wish list for how this could work differently. The sdo_geometry
type has two subtypes that can potentially go into the stratosphere in
terms of their contents. The first one, sdo_elem_info, almost never
does. This is what caused all of the green commas John indentified.
I think it would be spiffy if TOAD, instead of always showing 3-6
values followed by 90+ empty ones, variably sized what it showed for the
sdo_elem_info.

Then for the sdo_ordinates, which very
often goes beyond 99 values, if I had an option to override 99 as the default
value that would be a huge time saver. I could switch that value
from time to time, up or down, depending on how big the geometries are
that I am working with.

Easy for me to say, I know nothing about
Delphi. Thanks, as always, for listening to user requests.

Matt

CREATE OR REPLACE TYPE MDSYS.SDO_GEOMETRY
AS OBJECT (

       SDO_GTYPE
  NUMBER,

       SDO_SRID
   NUMBER,

       SDO_POINT
  SDO_POINT_TYPE,

       SDO_ELEM_INFO

SDO_ELEM_INFO_ARRAY,

       SDO_ORDINATES

SDO_ORDINATE_ARRAY)

Jeff Smith jeff.smith@quest.com

Sent by: toad@yahoogroups.com
10/09/2009 10:57 AM

Please respond to

toad@yahoogroups.com

To

"toad@yahoogroups.com" toad@yahoogroups.com

cc

Subject

RE: [toad] Spatial Geometry problem

It might be nice to have a warning if there
are more values to get or that we’re truncating? Esp when doing
edits?

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com]
On Behalf Of Dunbar, Norman**
Sent:** Friday, October 09, 2009 10:52 AM**
To:** toad@yahoogroups.com**
Subject:** RE: [toad] Spatial Geometry problem

Hi John,

I found the problem though. It seems one of the subtypes of

SDO_GEOMETRY is an array that can have up to 1048576 values.

Toad is only showing the first 99 of them. This is

probably a limitation in Delphi’s architecture. I’m sure

we’d crash most everyone’s PC if we tried to open a dataset

with over 1 million fields.

So I think this will go into the limitations/known issues

part of our documentation.

a limitation it is then Thanks. That’ll do me.

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.htm`

  Your email settings: Individual Email|Traditional

  [Change settings via the Web](http://groups.yahoo.com/group/toad/join;_ylc=X3oDMTJmaDUzcnBuBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyNTUxMDEwMjA-) (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=X3oDMTJkam9ya3FyBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjU1MTAxMDIw) |
  [
    Yahoo! Groups Terms of Use
  ](http://docs.yahoo.com/info/terms/) |

   Unsubscribe

,.,_

[att1.dat]
[att1.dat]
att1.dat (1.79 KB)


#14

Hi John, Jeff and Norm,

In fact, last I checked, selecting an
sdo_geometry column in SQL Developer for popup will bring everything
to a grinding halt.

Following on Jeff’s suggestion, I think
the one or three spatial users on this forum have occasionally chimed in
with a wish list for how this could work differently. The sdo_geometry
type has two subtypes that can potentially go into the stratosphere in
terms of their contents. The first one, sdo_elem_info, almost never
does. This is what caused all of the green commas John indentified.
I think it would be spiffy if TOAD, instead of always showing 3-6
values followed by 90+ empty ones, variably sized what it showed for the
sdo_elem_info.

Then for the sdo_ordinates, which very
often goes beyond 99 values, if I had an option to override 99 as the default
value that would be a huge time saver. I could switch that value
from time to time, up or down, depending on how big the geometries are
that I am working with.

Easy for me to say, I know nothing about
Delphi. Thanks, as always, for listening to user requests.

Matt

CREATE OR REPLACE TYPE MDSYS.SDO_GEOMETRY
AS OBJECT (

       SDO_GTYPE
  NUMBER,

       SDO_SRID
   NUMBER,

       SDO_POINT
  SDO_POINT_TYPE,

       SDO_ELEM_INFO

SDO_ELEM_INFO_ARRAY,

       SDO_ORDINATES

SDO_ORDINATE_ARRAY)

Jeff Smith jeff.smith@quest.com

Sent by: toad@yahoogroups.com
10/09/2009 10:57 AM

Please respond to

toad@yahoogroups.com

To

"toad@yahoogroups.com" toad@yahoogroups.com

cc

Subject

RE: [toad] Spatial Geometry problem

It might be nice to have a warning if there
are more values to get or that we’re truncating? Esp when doing
edits?

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com]
On Behalf Of Dunbar, Norman**
Sent:** Friday, October 09, 2009 10:52 AM**
To:** toad@yahoogroups.com**
Subject:** RE: [toad] Spatial Geometry problem

Hi John,

I found the problem though. It seems one of the subtypes of

SDO_GEOMETRY is an array that can have up to 1048576 values.

Toad is only showing the first 99 of them. This is

probably a limitation in Delphi’s architecture. I’m sure

we’d crash most everyone’s PC if we tried to open a dataset

with over 1 million fields.

So I think this will go into the limitations/known issues

part of our documentation.

a limitation it is then Thanks. That’ll do me.

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.htm`

  Your email settings: Individual Email|Traditional

  [Change settings via the Web](http://groups.yahoo.com/group/toad/join;_ylc=X3oDMTJmaDUzcnBuBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyNTUxMDEwMjA-) (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=X3oDMTJkam9ya3FyBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjU1MTAxMDIw) |
  [
    Yahoo! Groups Terms of Use
  ](http://docs.yahoo.com/info/terms/) |

   Unsubscribe

,.,_

[att1.dat]
[att1.dat]
att1.dat (43 Bytes)


#15

color:#1F497D’>Maybe I can find a way to let the user control the limit, I’m
trying to find it.

color:#1F497D’>

color:#1F497D’>By the way, I’m also trying to find a way to query how many
values of the array are actually being used, but I haven’t been successful.
Anyone know how to do that?

color:#1F497D’>

color:#1F497D’>

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

Sent: Friday, October 09, 2009 10:08 AM

To: toad@yahoogroups.com

Cc: toad@yahoogroups.com

Subject: RE: [toad] Spatial Geometry problem

Hi John, Jeff
and Norm,

In fact, last I
checked, selecting an sdo_geometry column in SQL Developer for popup will
bring everything to a grinding halt.

Following on
Jeff’s suggestion, I think the one or three spatial users on this forum have
occasionally chimed in with a wish list for how this could work differently.
The sdo_geometry type has two subtypes that can potentially go into the
stratosphere in terms of their contents. The first one, sdo_elem_info,
almost never does. This is what caused all of the green commas John
indentified. I think it would be spiffy if TOAD, instead of always
showing 3-6 values followed by 90+ empty ones, variably sized what it showed
for the sdo_elem_info.

Then for the
sdo_ordinates, which very often goes beyond 99 values, if I had an option to
override 99 as the default value that would be a huge time saver. I could
switch that value from time to time, up or down, depending on how big the
geometries are that I am working with.

Easy for me to
say, I know nothing about Delphi. Thanks, as always, for listening to
user requests.

Matt

CREATE OR
REPLACE TYPE MDSYS.SDO_GEOMETRY AS OBJECT (

   SDO_GTYPE       NUMBER,


   SDO_SRID        NUMBER,


   SDO_POINT       SDO_POINT_TYPE,


   SDO_ELEM_INFO  

SDO_ELEM_INFO_ARRAY,

   SDO_ORDINATES  

SDO_ORDINATE_ARRAY)

style=‘width:100.0%’>

Jeff
Smith jeff.smith@quest.com

font-family:“Arial”,“sans-serif”’>

Sent by:
toad@yahoogroups.com

10/09/2009
10:57 AM

style='font-size:7.5pt;font-family:"Arial","sans-serif"'>Please respond to

toad@yahoogroups.com

style=‘width:100.0%’>

style='font-size:7.5pt;font-family:"Arial","sans-serif"'>To

"toad@yahoogroups.com"
toad@yahoogroups.com

style='font-size:7.5pt;font-family:"Arial","sans-serif"'>cc

style='font-size:7.5pt;font-family:"Arial","sans-serif"'>Subject

RE:
[toad] Spatial Geometry problem

It might be nice to have a warning
if there are more values to get or that we’re truncating? Esp when doing
edits?

From:
10.0pt’> toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Dunbar,
Norman**
Sent:** Friday, October 09, 2009 10:52 AM**
To:** toad@yahoogroups.com**
Subject:** RE: [toad] Spatial Geometry problem

Hi John,

I found the problem though. It seems one of the subtypes of

SDO_GEOMETRY is an array that can have up to 1048576 values.

Toad is only showing the first 99 of them. This is

probably a limitation in Delphi’s architecture. I’m sure

we’d crash most everyone’s PC if we tried to open a dataset

with over 1 million fields.

So I think this will go into the limitations/known issues

part of our documentation.

a limitation it is then Thanks. That’ll do me.

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.htm`

  Your email settings: Individual Email|Traditional

  [Change settings via the Web](http://groups.yahoo.com/group/toad/join;_ylc=X3oDMTJmYzU3amRyBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyNTUxMDE0NTU-) (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=X3oDMTJkbGMwMzlsBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjU1MTAxNDU1) |
  [
    Yahoo! Groups Terms of Use
  ](http://docs.yahoo.com/info/terms/) |

   Unsubscribe

,.,_


#16

Hi John,

Super, thanks,

The sdo_elem_info are triplets, so SDO_UTIL.GETNUMELEM
will give you 1/3 of the total array values being used.

select (SDO_UTIL.GETNUMELEM(a.sdogeometry)

    1. from TABLE a

The sdo_ordinates are in pairs, so SDO_UTIL.GETNUMVERTICES
will give you 1/2 of the values being used

select (SDO_UTIL.GETNUMVERTICES (a.sdogeometry)*2)
from TABLE a

Matt

John Dorlon john.dorlon@quest.com

Sent by: toad@yahoogroups.com
10/09/2009 11:17 AM

Please respond to

toad@yahoogroups.com

To

"toad@yahoogroups.com" toad@yahoogroups.com

cc

Subject

RE: [toad] Spatial Geometry problem

Maybe I can find a way to let the user control
the limit, I’m trying to find it.

By the way, I’m also trying to find a way
to query how many values of the array are actually being used, but I haven’t
been successful. Anyone know how to do that?

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com]
On Behalf Of matthew.c.schell@census.gov**
Sent:** Friday, October 09, 2009 10:08 AM**
To:** toad@yahoogroups.com**
Cc:** toad@yahoogroups.com**
Subject:** RE: [toad] Spatial Geometry problem

Hi John, Jeff and Norm,

In fact, last I checked, selecting an sdo_geometry column in SQL Developer
for popup will bring everything to a grinding halt.

Following on Jeff’s suggestion, I think the one or three spatial users
on this forum have occasionally chimed in with a wish list for how this
could work differently. The sdo_geometry type has two subtypes that
can potentially go into the stratosphere in terms of their contents. The
first one, sdo_elem_info, almost never does. This is what caused
all of the green commas John indentified. I think it would be spiffy
if TOAD, instead of always showing 3-6 values followed by 90+ empty ones,
variably sized what it showed for the sdo_elem_info.

Then for the sdo_ordinates, which very often goes beyond 99 values, if
I had an option to override 99 as the default value that would be a huge
time saver. I could switch that value from time to time, up or down,
depending on how big the geometries are that I am working with.

Easy for me to say, I know nothing about Delphi. Thanks, as always,
for listening to user requests.

Matt

CREATE OR REPLACE TYPE MDSYS.SDO_GEOMETRY AS
OBJECT (

       SDO_GTYPE       NUMBER,

       SDO_SRID        NUMBER,

       SDO_POINT       SDO_POINT_TYPE,

       SDO_ELEM_INFO

SDO_ELEM_INFO_ARRAY,

       SDO_ORDINATES

SDO_ORDINATE_ARRAY)

Jeff Smith jeff.smith@quest.com

Sent by: toad@yahoogroups.com
10/09/2009 10:57 AM

Please respond to

toad@yahoogroups.com

To

"toad@yahoogroups.com"
toad@yahoogroups.com

cc

Subject

RE: [toad] Spatial Geometry problem

It might be nice to have a warning if there are more values to get or that
we’re truncating? Esp when doing edits?

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com]
On Behalf Of Dunbar, Norman**
Sent:** Friday, October 09, 2009 10:52 AM**
To:** toad@yahoogroups.com**
Subject:** RE: [toad] Spatial Geometry problem

Hi John,

I found the problem though. It seems one of the subtypes of

SDO_GEOMETRY is an array that can have up to 1048576 values.

Toad is only showing the first 99 of them. This is

probably a limitation in Delphi’s architecture. I’m sure

we’d crash most everyone’s PC if we tried to open a dataset

with over 1 million fields.

So I think this will go into the limitations/known issues

part of our documentation.

a limitation it is then Thanks. That’ll do me.

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.htm`

  Your email settings: Individual Email|Traditional

  [Change settings via the Web](http://groups.yahoo.com/group/toad/join;_ylc=X3oDMTJmMjJxcHFyBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyNTUxMDI1ODk-) (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=X3oDMTJkdHE3dnNhBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjU1MTAyNTg5) |
  [
    Yahoo! Groups Terms of Use
  ](http://docs.yahoo.com/info/terms/) |

   Unsubscribe

,.,_

[att1.dat]
[att1.dat]
att1.dat (43 Bytes)


#17

Hi John,

Super, thanks,

The sdo_elem_info are triplets, so SDO_UTIL.GETNUMELEM
will give you 1/3 of the total array values being used.

select (SDO_UTIL.GETNUMELEM(a.sdogeometry)

    1. from TABLE a

The sdo_ordinates are in pairs, so SDO_UTIL.GETNUMVERTICES
will give you 1/2 of the values being used

select (SDO_UTIL.GETNUMVERTICES (a.sdogeometry)*2)
from TABLE a

Matt

John Dorlon john.dorlon@quest.com

Sent by: toad@yahoogroups.com
10/09/2009 11:17 AM

Please respond to

toad@yahoogroups.com

To

"toad@yahoogroups.com" toad@yahoogroups.com

cc

Subject

RE: [toad] Spatial Geometry problem

Maybe I can find a way to let the user control
the limit, I’m trying to find it.

By the way, I’m also trying to find a way
to query how many values of the array are actually being used, but I haven’t
been successful. Anyone know how to do that?

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com]
On Behalf Of matthew.c.schell@census.gov**
Sent:** Friday, October 09, 2009 10:08 AM**
To:** toad@yahoogroups.com**
Cc:** toad@yahoogroups.com**
Subject:** RE: [toad] Spatial Geometry problem

Hi John, Jeff and Norm,

In fact, last I checked, selecting an sdo_geometry column in SQL Developer
for popup will bring everything to a grinding halt.

Following on Jeff’s suggestion, I think the one or three spatial users
on this forum have occasionally chimed in with a wish list for how this
could work differently. The sdo_geometry type has two subtypes that
can potentially go into the stratosphere in terms of their contents. The
first one, sdo_elem_info, almost never does. This is what caused
all of the green commas John indentified. I think it would be spiffy
if TOAD, instead of always showing 3-6 values followed by 90+ empty ones,
variably sized what it showed for the sdo_elem_info.

Then for the sdo_ordinates, which very often goes beyond 99 values, if
I had an option to override 99 as the default value that would be a huge
time saver. I could switch that value from time to time, up or down,
depending on how big the geometries are that I am working with.

Easy for me to say, I know nothing about Delphi. Thanks, as always,
for listening to user requests.

Matt

CREATE OR REPLACE TYPE MDSYS.SDO_GEOMETRY AS
OBJECT (

       SDO_GTYPE       NUMBER,

       SDO_SRID        NUMBER,

       SDO_POINT       SDO_POINT_TYPE,

       SDO_ELEM_INFO

SDO_ELEM_INFO_ARRAY,

       SDO_ORDINATES

SDO_ORDINATE_ARRAY)

Jeff Smith jeff.smith@quest.com

Sent by: toad@yahoogroups.com
10/09/2009 10:57 AM

Please respond to

toad@yahoogroups.com

To

"toad@yahoogroups.com"
toad@yahoogroups.com

cc

Subject

RE: [toad] Spatial Geometry problem

It might be nice to have a warning if there are more values to get or that
we’re truncating? Esp when doing edits?

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com]
On Behalf Of Dunbar, Norman**
Sent:** Friday, October 09, 2009 10:52 AM**
To:** toad@yahoogroups.com**
Subject:** RE: [toad] Spatial Geometry problem

Hi John,

I found the problem though. It seems one of the subtypes of

SDO_GEOMETRY is an array that can have up to 1048576 values.

Toad is only showing the first 99 of them. This is

probably a limitation in Delphi’s architecture. I’m sure

we’d crash most everyone’s PC if we tried to open a dataset

with over 1 million fields.

So I think this will go into the limitations/known issues

part of our documentation.

a limitation it is then Thanks. That’ll do me.

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.htm`

  Your email settings: Individual Email|Traditional

  [Change settings via the Web](http://groups.yahoo.com/group/toad/join;_ylc=X3oDMTJmMjJxcHFyBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyNTUxMDI1ODk-) (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=X3oDMTJkdHE3dnNhBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjU1MTAyNTg5) |
  [
    Yahoo! Groups Terms of Use
  ](http://docs.yahoo.com/info/terms/) |

   Unsubscribe

,.,_

[att1.dat]
[att1.dat]
att1.dat (1.79 KB)