RE: [MI-L] getting coordinates for the end points of lines

Taylor, Michael G \(SKM\) Sun, 28 May 2006 13:44:49 -0700

I always convert lines to plines in this situation. It doesn't affect the actual map object itself.

select ObjectNodeX(converttopline(obj), 1, 1), ObjectNodeY(converttopline(obj), 1, 1), ObjectNodeX(converttopline(obj), 1, Objectinfo(converttopline(obj),20)), ObjectNodeY(converttopline(obj), 1, Objectinfo(converttopline(obj),20))

Regards

Mike Taylor

GIS Senior Consultant [EMAIL PROTECTED]

Sinclair Knight Merz Ltd http:\\www.skmconsulting.com

Level 12, Mayfair House Tel: +64 4 473 4265

54 The Terrace DDI: +64 4 914 8464

PO Box 10283, Wellington Fax: +64 4 473 3369

New Zealand Mob: +64 21 110 3312

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Uffe Kousgaard
Sent: Friday, 26 May 2006 5:38 p.m.
To: Mapinfo-L
Subject: Re: [MI-L] getting coordinates for the end points of lines

Lines and polylines are handled differently (unfortunately):

Lines:

select ObjectGeography(1), ObjectGeography(2), ObjectGeography(3), ObjectGeography(4) from ...

Polylines:

select ObjectNodeX(obj, 1, 1), ObjectNodeY(obj, 1, 1), ObjectNodeX(obj, 1, Objectinfo(obj,20)), ObjectNodeY(obj, 1, Objectinfo(obj,20)) from ...

Kind regards

Uffe Kousgaard
www.routeware.dk

----- Original Message -----

From: Karl K

To: mapinfo

Sent: Friday, May 26, 2006 1:26 AM

Subject: [MI-L] getting coordinates for the end points of lines

Hi.

I have a client that requires the lat/long values for the beginning and endpoint of every polyline in a TAB. I am sure there is a way of doing this with SQL Select but don't know the correct syntax to get this info. Could someone who has done this kindly supply me with the statements to use? Thanks.

Karl

McElhanney Consulting Services Ltd.
100 - 780 Beatty Street
Vancouver, BC Canada
V6B 2M1
Tel (604) 683-8521
www.MapsByAir.com

Do you Yahoo!?
Get on board. You're invited to try the new Yahoo! Mail Beta.

_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l

Please consider the environment before printing this e-mail.

Notice - This message contains privileged and confidential information intended only for the exclusive use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action in reliance on it. If you have received this message in error please notify us immediately. Opinions, conclusions and other information in this e-mail and any attachments that do not relate to the official business of the firm are neither given nor endorsed by it. Any documentation produced using this data is uncontrolled and not subject to update. The recipient is responsible for reviewing the status of the transferred information and should advise us immediately upon receipt of any discrepancy. Any design details are applicable to the intended project only. Subject to contract, we retain copyright of all the transmitted material and it must not be reproduced wholly or in part, or supplied to any third party without our written permission. The sender makes no warranty regarding the accuracy or completeness of the data transmittal or to the presence of computer viruses or data errors

_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l

RE: [MI-L] getting coordinates for the end points of lines

Reply via email to