RE: [MI-L] Overlap analysis - Oracle tables

Peter Horsbøll Møller Fri, 24 Mar 2006 01:51:16 -0800

Title: Overlap analysis - Oracle tables

David,

How big is the difference if you use the CartesianArea() function in MapInfo ?

Peter Horsbøll Møller
GIS Developer, MTM
Geographical Information & IT

COWI A/S
Odensevej 95
DK-5260 Odense S.
Denmark

Tel     +45 6311 4900
Direct +45 6311 4908
Mob     +45 5156 1045
Fax     +45 6311 4949
E-mail [EMAIL PROTECTED]
http://www.cowi.dk/gis

From: Llewellyn, David [mailto:[EMAIL PROTECTED]
Sent: Friday, March 24, 2006 3:29 AM
To: Peter Horsbøll Møller
Cc: MapInfo-L@lists.directionsmag.com
Subject: RE: [MI-L] Overlap analysis - Oracle tables

Peter,

In the version of Oracle Spatial we are running (9.2.0.6.0) the querytype parameter must be included.

I have tried querytype=JOIN

But the results are still the same.

See the actual query and output below:

1 SELECT A.TRI_NUM, SDO_GEOM.SDO_AREA(SDO_GEOM.SDO_INTERSECTION(A.GEOLOC, B.GEOLOC, 0.005), 0.005, 'unit=SQ_KM') "OLAP"

2 FROM NTDA_REG_QLD A, NTDA_SCH_QLD B

3 WHERE B.TRI_NUM = 'QQ99/9'

4* AND SDO_RELATE(A.GEOLOC, B.GEOLOC, 'mask = ANYINTERACT querytype=JOIN') = 'TRUE'

TRI_NUM OLAP

---------- ----------

QC99/xx .055406902

QC97/yy 21061.2942

QC02/zz .539097535

QC99/pp 1278.13187

The areas above differ from the areas output by MapInfo (using the Area function) by a factor of about 0.9974.

Best regards,

David Llewellyn.

-----Original Message-----
From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED]
Sent: Thursday, 23 March 2006 8:00 PM
To: Llewellyn, David
Subject: RE: [MI-L] Overlap analysis - Oracle tables

Hi David,

Try without the querytype=WINDOW

From: Llewellyn, David [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 23, 2006 2:06 AM
To: Peter Horsbøll Møller
Subject: RE: [MI-L] Overlap analysis - Oracle tables

Thanks for the suggestion Peter,

A useful one. The results however, are the same.

Still, would be interested to know if you come up with anything that might be useful from your course.

From my initial reading, I think the problem might have something to do with the SRID number in the USER_SDO_GEOM_METADATA view (see below).

Unfortunately, my knowledge of Oracel Spatial is still pretty scant, so actually how to update that number is so far a mystery.

Best regards,

David Llewellyn

***This Email, together with any attachments is intended for the addressee only. If you have received this Email in error please inform the sender immediately by return Email. Alternatively you can ring the National Native Title Tribunal on the toll free number 1800 640 501 and report the error. Please delete the Email and any copies from your computer and/or computer network. The Tribunal does not warrant that this email is virus free. The Tribunal has also implemented content filtering of Emails to restrict inappropriate and spam emails being received. Other emails which may contain viruses may also be blocked. In either case, and in any case the email may not reach its intended recipient. If the email is important you may wish to see confirmation of its receipt by placing that request in the text of the email. Please resend the email if you haven't received that confirmation as requested. ***

_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l

RE: [MI-L] Overlap analysis - Oracle tables

Reply via email to