nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to geocode lines

yuzheying

I want to geocode bike routes on the map. Now I have created an excel sheet containing information about primary road, cross intersection 1 (start point) and cross intersection 2(end point). There are about 300 records need to be geocoded, and I really don't want to draw them manually...

Attempts have been made to create route layers by using Network Analyst, but I don't have that extension available on my computer. Is there any other way to geocode lines?

I really appreciate it if someone could shed some light on this question.

Find more posts tagged with

Accepted answers

All comments

Ctal_GISsquad

Yes, exactly!

JoeBorgione

Somehow, you'll need to select the all the segments of a given street between the two points, right?

al_Dhakal

Thank you Joe but I doubt if Points to Line would be the right tool here because it would join all the points in Red Zone but in reality, there would be blocks of green and blue zone streets in between two red zones. Also, it wouldn't respect the geometry of real-life streets - they are seldom in a straight line.

I have a hunch that Linear Referencing might have the right tools for the job, need to explore more.

JoeBorgione

Create a table of 'addresses' for each intersection and geocode them:

150 Campbell Ave
2538 Campbell Ave
219 Georgia St
2536 Georgia St
etc...

I've not done this but once you have your points you can apply this tool Points To Line—Data Management toolbox | Documentation to them to create your lines. Emphasis on I've never done it so there may be a learning curve in the actual execution of this approach.

al_Dhakal

Thanks, Joe.

When I think of it more, a line layer is more feasible than a polygon.

Let me explain more. I am trying to create a street sweeping map so that each household knows what color zone they belong too. The table has a beginning and ending street intersections for each zone and the cross street that goes through the zone. There are no other vertices. So for the first column, I am trying to give the street segment between 150 to 2528 Cambell Ave a red color and street segment between 259 - 2522 Madigan St a green color. I have over 6000 such rows.

So in short, how do I join these street intersections to get a line layer? Thanks!

JoeBorgione

If you have an advanced license you can use create polygons from your points. See : How To: Create polygons from points in ArcGIS Pro

That said, you need to create a set of points that mark the vertices of you polygons which I guess are hidden in the table you provide. Since I don't understand what your table represents, you'll need to explain it and we can go to the next step.

al_Dhakal

Hi,

I have a very similar problem at hand, for mapping boundaries of police beat or fire districts. As shown in the image below, I am trying to draw a polygon or at least lines for the addresses/parcels between 'From' and 'Two' and give them individual color. I can geocode them but then all I'll have are points. How do I go from geocoding points to lines or even better polygons layers? Any feedback will be greatly appreciated - Richard Fairhurst‌ and Joe Borgione‌.

Thanks,

Shital

JoeBorgione

As mentioned, you will need to acquire a street centerlines feature class and perform some sort of overlay process with the points you got back from geocoding and the centerlines.

yuzheying

I used LACounty CAMS address locator to geocode all my intersections. How to connect all the start and end points though?

JoeBorgione

I suggest you acquire a centerline feature class that you can build a geocoding locator with and geocde the intersections.

yuzheying

HI Joe,

I read your links and had a basic idea of catlog and geodata. What's the next step toward my goal?

Thanks,

Vincent

JoeBorgione

Yes, there is a big difference between routes and lines; let's not worry about routes for now.

Here is my age old 'GIS-Perspective': some folks:

Consider GIS as a cartographic tool that happens to have a database associates with it it

while others

Consider GIS as a database management tool that happens to draw pretty pictures

Either way you need to deal with the database aspect, or nothing much is going to happen.

Each of your records shown above represent an intersection of two streets. I'm sure that quite a number of these points serve dual purposes: they are both a from and two intersection. Think about a bike lane that traverses Main St:

FROM TO

Main ST & 1st Ave Main ST & 2nd Ave

Main ST & 2nd Ave Main ST & 3rd Ave

Main ST & 3rd Ave Main St & 4th Ave

etc etc

You could geocode your intersections in this fashion. With those points you could then spatially select those streets that the geocoding results lie upon, and then clean up the stragglers to represent you bike lanes. All of these steps are database manipulations.

My suggestion is spend some time gaining some basic ESRI-GIS concepts such as What is a geodatabase?—ArcGIS Help | ArcGIS for Desktop and What is geoprocessing?—Help | ArcGIS for Desktop and Mapping and visualization in ArcGIS for Desktop—Help | ArcGIS for Desktop and What is geodata?—Help | ArcGIS for Desktop

yuzheying

Is there a difference between routes and lines in ArcGIS. Cause I see both "route editor" and "Editor" in ArcGIS Toolbar.

I actually don't really care about whether it's a route or a line. I just want a layer that can visually display all my bike lanes.

yuzheying

Hi Joe,

I am new to GIS and still exploring. I am don't familiar with all the terms. But my goal is to create a polyline layer that represents bike routes. What I have in hand are a list of address and a street centerline shapefile.

Part of Excel:

Project ID	Primary Road	From	To
1	North Figueroa St.	Ave. 43	York Blvd.
2	Ave. 19	Ave. 26	Humboldt St.
3	North Figueroa St.	Ave. 22	Ave. 43
4	Pasadena Ave	Figueroa St	Ave 28

JoeBorgione

Not sure what your objective is: typically, geocoding involves turning a tabular list of addresses into a georeferenced point feature class, by matching those addresses to some sort of feature class, be it point, line or polygon, or a combination there of.

yuzheying

Hi Mody,

Thanks for your help. but I met some trouble in getting the M value. Do I have to manually measure the distance of each bike routes?

Thanks

mody_buchbinder

Hi Yuzhe

Routes are not network. Check the tools under Linear Refrencing.

You should turn your lines into route (add the M - measurement) value and then it should work.

You do not need any extensions.

Have fun

yuzheying

I also have a shapefile of all street centerlines in City of Los Angeles, it's downloaded from lacity geohub. I wonder if this file could serve as a reference when geocoding.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.