Hi,
I was solving a similar problem in the following steps:
1. made a column in the table with rowid (using update column) named, say,
record#.
2. if original table had a name of mytable, then made a copy of it, named
say - copyofmytable, and opened it
3. made the following query using mapbasic window:
Select mytable.record#, copyofmytable.record#, AreaOverlap(mytable.obj,
copyofmytable.obj)>0 from
mytable, copyofmytable where mytable.obj Intersects copyofmytable.obj and
mytable.record#<>copyofmytable.record# into adjacency
Browse * From adjacency
Adjacency table contains a pairwise listing of adjacent polygons, which can
be crosstabulated in any database management system.
hope this helps
Mikhail
-----Original Message-----
From: Yoshiro Nagao <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: 8 ������ 1999 �. 13:56
Subject: MI neighborhood matrix, etc
>Hello, I am a user of Mapinfo Professional.
>
>Could you teach me how to do the followings?;
>
>(Q1)I have a polygonal map table.
>
>From this, I would like to generate such a matrix
>as shows which polygones are adjacent to each other,
>and which are not. For example;
>
> WA NT SA QL NS
>Western_Australia(WA) 0 0 1 1
>Northern_Territory(NT) 0 0 0
>South_Australia(SA) 0 0
>Queensland(QL) 0
>New_Southwales(NS)
>
>Where 0 indicates adjacency, and 1 indicates non_adjacency.
>
>Can I make such a matrix(text file) by using Mapinfo command,
>or processing mapinfo data file by in-house programme?
>
>Thanks for your cooperation in advance.
>
>Yoshiro Nagao
>8-13 Egamicho, Nishinomiya
>6620855 Japan
>FAX: +81-798-22-0678
>mobile phone: 090-8874-6235
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
