Tip:
Highlight text to annotate it
X
Hi. This is a demo about geocoding, and I'm actually pretty new
to this, so this will be pretty basic.
And if I misrepresent something or you have any feedback for me, please let me know.
And I hope to, in the future, create more advanced videos on geocoding.
But you have to start somewhere, so this is going to be my first one.
So to start out with, I just did a Google search online
to find some map data that I can make use of.
So I did a Google search on the orangecountyflorida.net Web site.
Within there, there's an FTP, a link to an FTP site to download some data that you can use
in ArcMap, and it seems to work fine in ArcMap 9.3,
which is the one I'm using on this computer.
So I downloaded this stuff, and it's various files, and pulled them into a new map.
And I didn't even rename the layer, but that's okay.
So what we have here is just various things, and I have the address range,
which will become important later for the geocoding here.
They had a layer, and this is available publicly.
I think these zones are probably pretty outdated and the boundaries aren't correct.
But they're sharp zones, and they'll suit our purposes for now.
So this is publicly available information, is the point I'm trying to make.
And then in addition to this, I created some fake data.
So with geocoding you usually have address data within the table that you want to map.
So that's what I'm setting up here.
So in this table, I just created a crime ID, this is just an identifier.
These locations I got, actually went on the Web and did a search
and got addresses of various Walgreens stores.
So this is completely bogus data,
pretending that these addresses are actually addresses where crimes occurred.
So the location, which is a street address, I probably could rename that.
Oh, that reminds me.
These field labels, it's really important that you don't have any spaces in there
or special characters, because that will kind of crash when you try to do the geocoding.
So you'll notice that there aren't any spaces in here,
so crimes versus crime type, I don't have any space.
So crime type, crime type code, that's all just fake and made up.
The date and the time as well, they're just numbers I made up.
So this is the table, and it's called Fake Crime Data, that I want to pull in.
I'll just go ahead and close that for now.
And then this file I got, again, from the Florida...what was it?
The orangecountyflorida.net Web site.
And if we look at the attribute table, it's always a good idea to take a look
at attribute tables, especially with geocoding, because it gets kind of complicated,
at least for me it does right now.
But it's a good idea to have a look at the table and try
and get familiar with it as much as possible.
And you'll see later that the importance of what these are becomes important.
So, some of the fields we're going to have to fill in later are houses to the left
of the street, houses to the right of the street, where they begin,
where they end, that sort of thing.
So one thing you'll notice here, just
to show you now while we're here, let's see, where is this?
So here, left the O-R.
I'm not sure what that stands for, but it's this particular street, the address starts with 1100
and then it should go all the way up to 1198.
And then on the other side of the street, it's 1101, which makes sense.
There's 1100 and 1101.
And then at the end of the street on the left side it was 1198, even numbers.
And the right side is odd numbers, 1199.
So these are the field labels that we need to remember and keep in mind.
I'm not sure what these are.
So, I may be making a mistake, but they didn't seem as neat and as clean as these.
So these are the fields that I'm going to be using for the geocoding.
And just here's some address data that we'll make use of.
There's the city, zip codes, et cetera.
And a lot of these columns we will end up not using as part of this exercise.
So there's the attributes which will come into play later.
So where do we start?
If you jump over to Arc catalog, and I'm not sure if this is the right place to do it,
but I just picked the folder where...a top folder where I have all this other,
where the fake data is contained within and also these various map layers that I'm making use
of at a higher level, that's where I'm right clicking.
You probably could do it at a different folder if you wanted to, but there it is.
So you go to New.
Right click.
Go to New, and say Address Locater, because that's the first step you need,
you need a way to look up the addresses.
And then, again, I'm kind of new to this.
But you kind of look at this list and pick a style that matches what we were looking
at over here in the address range.
So depending on what the layer contains, the street data that you have, the specific style
that you pick may end up being different than the one that I pick.
Now, let's see.
I'm trying to remember.
There was one of these down here.
It's U.S. streets, one address, one address with ALT name.
I don't have ALT name.
I do have zone, which is, I think that's zip code.
One range.
Oh, here we go.
This is more like it.
So U.S. streets.
It's city, state and zip.
I think that will work, because I have city.
I don't think I have state in there.
So I'm going to pick one that doesn't have...I'll just pick U.S. streets,
because I don't think...ALT name I don't have.
State, I don't think was in there.
Zone, I guess I could pick zone.
I'll pick U.S. streets and see what happens.
Okay. And so it's a good idea to rename this.
So I'm just going to call this GIS Demo to Address Locater.
Description, it's going to be U.S. streets; and the reference data, that's where we go in
and we pick this address range that we had.
So this will be in this folder somewhere.
And it was within this folder.
And address range, and there it is.
And so I'll go ahead and say, add.
And here is where it's important to know what the attribute table looks
like for the address table that you're going to use.
So if you recall, when we were looking at houses from the left,
I believe we had where it started from zero.
So it's the left 0, I think that's a zero.
I'm not really sure, but that was where it started.
And then in the left, the one.
And then the same pattern for the right side.
I think it was right zero and right the one.
And I'm not really sure what that is.
The street name, I remember the field name was complete street.
So that kind of spelled out the street name with everything that we needed,
including the street type, et cetera.
So I can leave those blank.
And I elected not to include zip code or city.
And I guess I could have included those somehow.
But, so let's see if this works.
Okay. So we have that.
Oh, over here, the field that actually contains street,
if you recall that was actually called location in that table.
So I'm going to say add location, because that was the column heading or the field label.
It's probably good for now just to keep these defaults because I'm kind of new at this.
Connectors are good for intersections, but the data I entered was pretty clean
because they're all just Walgreens stores, and I didn't have any intersections.
I just had the actual address of the stores.
And for output, I am just going to click on all four
so I don't forget anything or lose anything.
And say, okay.
And we'll see if it works.
So it looks like it's creating an index at first.
All right.
Cool. So we have within this folder now we have GIS Demo 2 Address Locater.
Now, once that's in place, we can go back over here
and we can add the table and then geo code it.
So here is a way to add data.
And add data, I guess I want to go up to this folder and here's fake data.
And it was fake crime data.
I'll say add.
And this might look a little different in the Arc 10 or different versions,
but it will be the basic same idea.
I deleted the other sheets so there's just one sheet, but it's still wanting me
to select Sheet 1 for some reason.
I know when I tried this before, it almost looked like it didn't work
and it had the file name again but it was slightly different.
So you might see that.
But anyway, just keep clicking and saying add.
And hopefully it will work for me and hopefully it will work for you.
Okay. So you'll notice that it jumped from the display tab
to the source tab down here in the left corner.
But it looks like it did add the sheet.
And we can right click it, and say geo, well, let's open it just to see
if it actually is what we thought it was.
Yes, it's the Walgreens stores.
It's all the information in there.
And you should, just like with the other table, you should get familiar with it before you try
and geo code so you know that the labels, what the labels are.
Okay. So we have that.
So let's go ahead and get this done.
So we right click on Sheet 1 and we say, geo code addresses.
And now we have to pick an address locater.
We'll pick the one we just created.
And it's not in that folder.
It's up in this folder.
There it is.
We'll say add.
And that's the one we want to use.
Okay. So there's the sheet.
Street or intersection is actually labeled location.
I'm just going to leave the default setting here.
And the sheet file or feature class can go in this folder, geocoding.
And I might create this extra folder just to keep organized.
And I'll say geo code folder.
And there it is.
Advanced options, I'll click on it but I don't really know too much about it.
So maybe we'll have a demo about this later, but I'm just going to leave it as is.
And then geocoding options are the things that we looked at before.
I'm going to leave it as is.
And why can I not...no.
[LAUGHTER] Why is that not letting me click Okay?
Static snapshot of table inside...maybe it didn't like me creating that.
I don't know.
Oh, it didn't like me creating that table for some reason.
Well, that's a good lesson for you, for me.
Go ahead and click Okay.
And it looks like 90 percent is matched.
You should always, I was just reading about this yesterday.
If you're matching anything around 60 percent, that's really bad, and that means that you need
to clean your data or get a better address table.
There's just something not right.
But 90 percent sounds pretty good to me.
And rematch is something where you can go in and rectify ties and unmatched items
and do it manually and all these extra steps, which hopefully some day I'll learn more about.
But I'm just going to go ahead and close it for now.
And, bam! There they are, geocoding results.
There's the little icon, and I can just make it stand out a little bit more.
And you go up to eight.
Make it red.
Say, Okay.
And boom, there they are.
So those are the locations and the table data was pulled in.
So it was successfully geo coded.
That's my first time doing it this week, and so I'm excited.
So if you click on Identify, you can even double-check it this way,
you can click on any one of these and you'll see that the results and the information that was
in the table, the fake crime data table that I created, is in here.
So I'm not sure what the lines are, but anyway, there's the address.
Oh, here's the match of the address.
Walgreens was the store; I included that just to remind myself
that these are just Walgreens stores.
And, et cetera.
So I hope this was useful to you, and I'll try and create some more demos on geocoding
when I learn more about all the features.
Thanks. Bye-bye.