|
Tom: Transcad can do this operation (I'm told) in one step. However, due to Maptitude's inability to handle data matrix computations, I developed a low-tech work-around operation in Maptitude. Based on my approach, what you need to do is: 1) Create separate layers for each park, 2) Add 10 data fields in the file of personal residences (e.g. Dist_ParkA, Dist_ParkB, etc) and then 3) Use the edit/tagging feature to auto-fill the Dist_ParkX fields, one at at a time. A little tedious but it works. Then if you want to find the closest park to each residence, 4) Save the dataview table as a .wk1 spreadsheet file. 5) Open the spreadsheet table in Excel (or your favorite alternate spreadsheet application) , 6) (due to the limitations on the number of columns you can have in a spreadsheet view), split the table in half (200 residences/2 = 100 rows copied to second spreadsheet with duplicate column headings), and 7) Pivot or rotate each table so that the column headings become the row headings. 8) Sort the rows in each spreadsheet in ascending order, 9) Pivot the tables back to their original orientation, 10) Paste the two spreadsheets back together and now you should have a table with the distances to all 10 parks shown in columns (from left to right) in ascending order from the closet park (eg. first Park distance column) to most distant (last Park distance column). I'll be interested to see what other users offer as a solution, because admittedly all the data manipulation of this approach is a bit of a pain. Kevin Byrnes Tom Shoals wrote: I have two point layers (10 parks; 200 personal Yahoo! Groups Links
|
begin:vcard fn:Kevin F. Byrnes, AICP n:Byrnes, AICP;Kevin F. org:Virginia Dept for the Aging adr;dom:;;1610 Forest Ave, Ste 100;Richmond;VA;23229 email;internet:[EMAIL PROTECTED] title:Demographer tel;work:804-662-7047 tel;fax:804-662-9354 x-mozilla-html:FALSE url:http://www.vda.virginia.gov/downloadable.htm version:2.1 end:vcard
