Geocode by Grid Name

Question

I'm kind of new to GIS, so I may not have all the terminology right, but I'm hoping someone can help.

I have a table of data (concentration of chemical X) and each reading is referenced to a grid number.  I have a shapefile that gives these grids a location and I can create a map with the grids on it.

I am looking for a way to use the shapefile (or a derivative of it that contains the geography) as a address locator of sorts to match each of the data points to the grid in which it was collected.

Any help or guidance would be greatly appreciated, thanks.

JoeBorgione · Answer

I think if you use the VB Script parser, a number will go straight into a text field.  Python will want you to use the str() function:

NewTextField = str(!NumericField!)

BrandonAdcock1 · Answer

Than k you both for your help.  This did exactly what I wanted it to do.  I used Joe's solution and it worked beautifully.  Now I have these observations spatially correlatied to the grid layer!  Wahoo!

The only small caveat was that since the block ID field was a number field, so the tool would not use that field as a single line address field.  I had to create a new field that was a text type field, then use the filed calculator tool to move the block ID's into it, thereby making the block ID's text.  Small thing, but may be a sticking point for others looking for this solution.

Again, thank you both for your help.  I'm super excited to use this to create some beautiful maps. 🙂

JoeBorgione · Answer

Just so I have it straight, you have a polygons shapefile in which each of the polygons are labeled in a fashion shown above, right?  If so, you have  the essence to geocode with:

Your 'address table' is the Concentrations table, and the 'address' of each is the value shown in the Grid column.

The data you will match your addresses to is your grid polygons.  (If it's truly a shapefile, do yourself a favor and create a file geodatabase and import the shapefile into it as a feature class. You'll thank me sometime down the road)

Create a 'General- Single Field' style locator and reference the Grid-ID field as the KeyField using the polygon data as your reference data:

edit:  Or you can follow rastrauch123‌ 's excellent procedure ( that she slipped in while I was posting my suggestion....)