POST
|
Thanks Ben, I don't think that the Network Analysis Tool (closest facility tool) will give the output that I need. I don't have a network data set ( I have point features) and I need to find the closest, the further and the mean distance of each project from its office. The problem is that the table from the near distance analysis only report two fields - the id of the project and the id of the office. When I run the near tool I end up with 7000 measurement for each office (almost 900,000 records). The office ID and the projects ID are basically duplicated 128 times. I can't find a solution for this yet.. I started exporting each office and each projects to individuals data sets. so I can run the near tool..lots of work...! JB
... View more
08-25-2017
05:48 AM
|
0
|
1
|
243
|
POST
|
Hello Chris, Thanks a lot for your help..I would give it a try.! I am on desktop 10.4 butt I forgot to ask if Pro may have this capability.? Thanks, JB
... View more
08-23-2017
06:06 AM
|
0
|
2
|
772
|
POST
|
I'm not clear what do you men by running the near table tool. If I do that, it would create 896,000 records...it basically measure the distance of the 7000 records to each office. On not clear how I will join the tables!!
... View more
08-22-2017
07:56 AM
|
0
|
1
|
772
|
POST
|
Hello Joshua, You are correct. It is a great tool and I am learning Python but it may take a while before I am capable of compiling a tool that can do all what I need. Here is how my data look like: I have two shp. layers (both points). One layer is for the office with two fields - office_Name and orgCode (total 128 records); The other layer contain the projects (7000 records) with 4 fields: Project_Name,.. Project_ID, ...Project_Type and the common field key "orgCode" that identify the office. The projects cover the entire southeast of US and the Caribbean. Some offices are very close and some very far and there is no search radius or boundary that I can use to limit the distance for targeting the features. Basically my Input feature is the Office layer and my near feature is the Projects. I am trying to write a simple script that do what I am doing manually: 1. select the office record by orgCode 2. find the common key on "projects" table and select the records 3. run the point distance tool on selected records 4. select the distance field and run the summary for min, max and mean distance 5. save the table with the stat. 6. look for next office record and repeat the process
... View more
08-22-2017
04:17 AM
|
0
|
7
|
772
|
POST
|
Hi Dan, I have two data sets (.shp) and a common key field ID ( with one - to many). There are about 400 project for each office. Both layers are on the same projection (USA_Contiguous_Equidistant_Conic) and the offices cover very large distance (more than 100 miles) lots of over-lapping. Basically I am covering the entire southeast of US and the Caribbean.
... View more
08-21-2017
01:33 PM
|
0
|
0
|
1885
|
POST
|
YES. I have a common field that identify each office and link to projects. My Phython skills are very limited JB
... View more
08-21-2017
01:29 PM
|
0
|
9
|
1885
|
POST
|
I have two data sets (.shp) and a common key field ID ( with one - to many). Yes, both files are on the same projection (USA_Contiguous_Equidistant_Conic) and YES they cover very large distance (more than 100 miles)
... View more
08-21-2017
01:24 PM
|
0
|
1
|
772
|
POST
|
My INPUT is office location (point) and my NEAR is projects locations (point). Some offices are very close on location and some offices travel very far for projects so I can not use the search radius. For every office there is a set of projects and I want to know the max, min and average distance of those projects!
... View more
08-21-2017
01:18 PM
|
0
|
2
|
1885
|
POST
|
The near tool and point distance calculate the distance to ALLL point (projects) and I need to calculate the distance to the points that belong to each office. The only way around is exporting the projects that belong to each office ant run the near tool for each set of projects...I have 120 offices and 5000 projects ...
... View more
08-21-2017
11:56 AM
|
0
|
16
|
1885
|
POST
|
Need help on how to calculate distance of multiple points. I have two layers : an input feature(office) and near feature ( projects). I want to know the distance of the projects for each office. The near tool won't work (It calculate the distance to all points) unless I run the tool for each office...any ideas? Thanks,
... View more
08-21-2017
11:11 AM
|
0
|
24
|
12794
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|