1

I have a shapefile feature class that represents an area with signal strength per section of area. It has signal strength from multiple radio sources but I would like to make separate file for each radio source. For example if I start with the attribute table like this.

ALL SITES_SIGNAL LEVEL
| FID |  Shape  | Site_1 level | Site_2 level | Site_3 level | 
|  0  | polygon |  -120        |   -140       |   -87        |
|  1  | polygon |  -142        |   -130       |   -77        |
|  3  | polygon |  -156        |   -111       |   -89        |
|  4  | polygon |  -60         |   -113       |   -112       |
|  5  | polygon |  -54         |   -87        |   -134       |
|  6  | polygon |  -90         |   -50        |   -117       |

I want three feature classes with attribute tables like this:

SITE_1 SIGNAL LEVEL
| FID |  Shape  | Site_1 level | 
|  0  | polygon |  -120        | 
|  1  | polygon |  -142        | 
|  3  | polygon |  -156        |   
|  4  | polygon |  -60         |  
|  5  | polygon |  -54         |  
|  6  | polygon |  -90         |   

SITE_2 SIGNAL LEVEL
| FID |  Shape  | Site_1 level | 
|  0  | polygon |  -140        | 
|  1  | polygon |  -130        | 
|  3  | polygon |  -111        |   
|  4  | polygon |  -60         |  
|  5  | polygon |  -54         |  
|  6  | polygon |  -90         |

SITE_3 SIGNAL LEVEL
| FID |  Shape  | Site_3 level | 
|  0  | polygon |  -87         | 
|  1  | polygon |  -77         | 
|  3  | polygon |  -89         |   
|  4  | polygon |  -112        |  
|  5  | polygon |  -134        |  
|  6  | polygon |  -117        |

I've looked at split by attribute, but that doesn't do what I wasn't, in this example that gives me 7 tables. I know I could make 3 copies of the table and delete two columns, but this doesn't seem efficient.

  • 1
    There is no "off the shelf" tool that would do this, you would have to script this in python which is easy enough. – Hornbydd Feb 22 at 23:43
1

To do this I would:

  1. Make two copies of your original shapefile using the Copy tool.
  2. On each of the three shapefiles drop two fields using the Delete Fields tool.
  3. Use the Geoprocessing | Results window and Copy As Python Snippet to start writing a modest Python Script tool using ArcPy
  • I thought I might have to do something like this. If there were a tool I would have liked to have know what it is. Thanks – Frank Feb 23 at 6:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.