topic Re: Multiple number extraction from field in ArcGIS Pro Questions

Multiple number extraction from field

dgmoore099 — Fri, 23 Sep 2022 04:07:58 GMT

Hello,

I'm using the latest version of ArcGIS Pro. I have a dataset of individual bus stops which I am trying to map as the bus routes. The routes are identified within a string of additional information. Some strings contain multiple routes within one row. I don' t know Python. How can I extract the numbers from the "stop_desc" field in a way that I can then dissolve the resulting field numbers into a single route. In the image below, row 1 indicates that routes 1, 5 and 10 are represented at that stop. I have created a new field titled "route" for the numbers to be extracted.

Thank you

Re: Multiple number extraction from field

JohannesLindner — Fri, 23 Sep 2022 06:50:41 GMT

Does this do what you want?

Open the Python window:

Copy and paste this script, hit enter twice:

# create the output feature class route_stops = arcpy.management.CreateFeatureclass("memory", "RouteStops", "POINT") arcpy.management.AddField(route_stops, "stop_id","LONG") arcpy.management.AddField(route_stops, "route","TEXT") # start inserting into the new fc with arcpy.da.InsertCursor(route_stops, ["SHAPE@", "stop_id", "route"]) as i_cursor: # loop through the stops with arcpy.da.SearchCursor("bus_stops", ["SHAPE@", "stop_id", "stop_desc"]) as s_cursor: for shp, id, desc in s_cursor: # extract the routes from the field stop_desc: # delete spaces, get everthing after "routes:" and split that at "/" routes = desc.replace(" ", "").split("routes:")[-1].split("/") # for each route, write a point into the new fc for route in routes: i_cursor.insertRow([shp, id, route])

This will create a feature class in RAM (so export it if you want to keep it). This feature class will have two fields: The stop_id and the route. It will have a point for each route at each stop. So in your example, it will have 3 overlapping points for stop_id 12143, one for each of the routes 1, 5, and 10.

Re: Multiple number extraction from field

dgmoore099 — Fri, 23 Sep 2022 16:20:14 GMT

That did it. Thanks Johannes!