I have a list of projects that need to be geocoded or drawn through some sort of automated process in ArcGIS 10.3 for Desktop. The are listed by primary street, a begin street intersection, and an end street intersection. The data files are in the format listed below.
Street Extent 1 Extent 2 N Spring St W Temple St W Arcadia St Aviation Boulevard 93rd Street Century Boulevard Le Conte Ave Hillgard Ave Levering Ave Pershing Drive Westchester Pkwy Imperial Highway
I am using a street centerline file that includes each street segment name, a unique ID for each segment, and the begin/end intersections for each segment. The streets observe consistent directionality. I also have available to me a separate intersection shapefile that contains the intersections, with their unique IDs, but I have been unable to figure out how to integrate them correctly into a street centerline shapefile that can be used to create an address locator or linear reference system.
These are the centerline files I am using; they are publicly available from the City of Los Angeles.
I am not trying to map addresses, but to create line segments that begin at Street/Extent 1, and then trace along the polyline specified by Street until it reaches Street/Extent 2.
The line segment would begin at W Temple St/N Spring St, and then continue along N Spring St until the intersection of W Arcadia St/N Spring St.
I have tried using a linear reference system, but the begin/end fields for the event table have to be numeric, rather than string values. Address locators will only create points for me, but could I create start/end points, and then tell ArcMap to trace along Street 1 between the start end points? I have been unable to figure out a workaround for this so far...
I have limited Python experience (and my workplace has almost none) but am open to a solution that would include it. This would have to be a process that could be integrated into a workflow, and taught to other people/updated regularly. Ideally, this would be integrated into an address locator, but I could also provide the workflow as a Modelbuilder object as well.