topic Re: Creating map of roadways in ArcGIS Pro Questions

Creating map of roadways

Anonymous User — Thu, 20 Jan 2022 19:05:03 GMT

I have been given an excel file with attributes including the coordinates of the beginning of roadways and the ends of those roadways. I have been asked to map out these roadways using the coordinates I have been given and I am supposed to include the other attributes. Any ideas on how I can do this would help, thanks.

Re: Creating map of roadways

DanPatterson — Thu, 20 Jan 2022 19:37:48 GMT

Excel To Table (Conversion)—ArcGIS Pro | Documentation

XY Table To Point (Data Management)—ArcGIS Pro | Documentation

Coordinate Table To 2-Point Line (Defense)—ArcGIS Pro | Documentation or

Points To Line (Data Management)—ArcGIS Pro | Documentation

Re: Creating map of roadways

AdrianWelsh — Thu, 20 Jan 2022 19:48:10 GMT

I like Dan's approach, but more of a one-stop-shop would be:

https://pro.arcgis.com/en/pro-app/2.8/tool-reference/data-management/xy-to-line.htm

Re: Creating map of roadways

DanPatterson — Thu, 20 Jan 2022 19:57:29 GMT

for sure, that would be the shortest... but I wasn't sure if the start end points were in the same row in excel or they were different entries.

Re: Creating map of roadways

Anonymous User — Thu, 20 Jan 2022 19:59:40 GMT

The start and end points are in separate columns.

Re: Creating map of roadways

DanPatterson — Thu, 20 Jan 2022 20:26:04 GMT

That is good then you can use the shortcut tool Adrian suggested. Hopefully your data are either in decimal degrees or a projected coordinate system.

In either event, you need to define the coordinate system during the process and before you use it in a map.

before you ask... you will get straight lines and they won't follow the actual road! 😉

Re: Creating map of roadways

Anonymous User — Thu, 20 Jan 2022 20:38:11 GMT

Do you know if there's a way I could sketch lines on the map then add my attributes from there? Can't think of another solution for roadway mapping.

Re: Creating map of roadways

AdrianWelsh — Thu, 20 Jan 2022 20:44:15 GMT

Can you post an example of what your table looks like?

Re: Creating map of roadways

curtvprice — Thu, 20 Jan 2022 20:57:14 GMT

If you create the lines by editing you would need to tag each one with a unique identifier that you could join to a table of attributes. Seems to me it would be easier to use another existing road dataset and do conflation (ie a spatial join on your two-point road centroids) to try to get your attributes onto existing roads. Kind of depends on your data.

Re: Creating map of roadways

Anonymous User — Thu, 20 Jan 2022 20:59:42 GMT

Re: Creating map of roadways

DanPatterson — Fri, 21 Jan 2022 00:49:26 GMT

Your beginning and end coordinates should be in 4 fields not 2

You will have to add 4 new fields, xfrom, yfrom, xto, yto decimal type.

Then you need to do field calculations

float(!Begin!.split(",")[0]) # for yfrom

float(!Begin!.split(",")[1]) # for xfrom

float(!End!.split(",")[0]) # for yto

float(!End!.split(",")[1]) # for xto

Then proceed from there. (Sort of thrown into the deep end on this I suspect... make sure you thank the person that gave you the data... suggest that they make the table gis friendly in the future 😉 )

Re: Creating map of roadways

curtvprice — Fri, 21 Jan 2022 03:24:09 GMT

There is a useful tool to work recently added to ArcGIS: convert Coordinate Notation. https://pro.arcgis.com/en/pro-app/2.8/tool-reference/data-management/convert-coordinate-notation.htm

Re: Creating map of roadways

DanPatterson — Fri, 21 Jan 2022 03:40:38 GMT

I always forget this one!

You could have used

DD_1 —Both longitude and latitude values are in a single field. Two values are separated by a space, a comma, or a slash.

but! your coordinates are in the wrong order potentially! depending where in the world you are! so you had better confirm that Longitude then Latitude is the order