I have a points layer created from the intersections of where a polyline crosses the boundaries of cities. The points layer has many of the attributes I am looking for (County, number of highway route, postmile, prefix/suffix) but it does not have the names of the cities at the boundary (or the Unincorporated County area = CO).
The points layer was created in another program (using latitude and longitude) but it is ArcGIS compatible (I am using ArcGIS 10.4). Maybe I have to go back to the original program, and maybe (?) there is something in the Toolbox that cuts to the chase (adds fields and attributes) but if someone knows a quicker way that would be nice.
Dan B
spatial join comes to mind, if you are working with featureclasses in a geodatabase or shapefiles. Join the polygons to the points, save the resultant to a new file and the information should be carried over
I will try a Spatial Join tomorrow but how would attributes from both sides
of a boundary be included? I can easily figure that the attribute for
one polygon would be added but what about both of them?
The points layer is based in Lat/Long coordinates and used aggregation of
segments of a polyline to connect (spatially??) to the points layer in
order to do calculations of postmiles at the locations of X/Y.
I am guessing I'd have to do two spatial joins, which I don't mind doing
but that doesn't seem right either.
IF I have and Advanced License is there another tool other than Spatial
Join that would do the trick?
Here is a "white board" / cocktail napkin version of what I'm looking for
in terms of a Table:
(I'll provide shapefiles if needbe tomorrow).
*0 COUNTY *3 CITY A
*5 COUNTY *8 CITY
B *10 COUNTY *13 CITY C 15
ROUTE 3
End Result
ID POSTMILE City BACK CITY AHEAD
CO RTE 3 0.0 0 COUNTY COUNTY
CO RTE 3 3.0 3 COUNTY CITY A
CO RTE 3 5.0 5 CITY A
COUNTY
CO RTE 3 8.0 8 COUNTY CITY B
CO RTE 3 10.0 10 CITY B COUNTY
CO RTE 3 13.0 13 COUNTY CITY C
CO RTE 3 15.0 15 CITY C COUNTY
Here is the link to the resource for Spatial Join
Spatial Join—Help | ArcGIS Desktop
About joining the attributes of features by their location—Help | ArcGIS for Desktop
I will try a Spatial Join tomorrow but how would attributes from both sides
of a boundary be included? I can easily figure that the attribute for
one polygon would be added but what about both of them?
The points layer is based in Lat/Long coordinates and used aggregation of
segments of a polyline to connect (spatially??) to the points layer in
order to do calculations of postmiles at the locations of X/Y.
I am guessing I'd have to do two spatial joins, which I don't mind doing
but that doesn't seem right either.
IF I have and Advanced License is there another tool other than Spatial
Join that would do the trick?
Here is a "white board" / cocktail napkin version of what I'm looking for
in terms of a Table:
(I'll provide shapefiles if needbe tomorrow).
*0 COUNTY *3 CITY A
*5 COUNTY *8 CITY
B *10 COUNTY *13 CITY C 15
ROUTE 3
End Result
ID POSTMILE City BACK CITY AHEAD
CO RTE 3 0.0 0 COUNTY COUNTY
CO RTE 3 3.0 3 COUNTY CITY A
CO RTE 3 5.0 5 CITY A
COUNTY
CO RTE 3 8.0 8 COUNTY CITY B
CO RTE 3 10.0 10 CITY B COUNTY
CO RTE 3 13.0 13 COUNTY CITY C
CO RTE 3 15.0 15 CITY C COUNTY