Richard,
I just want to thank you again for taking the time to help me out.
The DECWell field stores a unique identifier, this identifier is always two letters followed by four numbers, like so:
AL1905, RS3000, CH0560
The table being created will only hold that identifier and the objectID of an orps point, so that the well data can be related to matching orps through this table.
Attached is my full code. Note that the feature layers were created because I was interested in selecting orps within a certain distance of the wells and only checking those, as opposed to the entire set of orps.
import arcpy
from arcpy import env
arcpy.env.overwriteOutput = 1
## define all user inputs for creation of arcmap toolbox
a = arcpy.GetParameterAsText(0) ## wells
b = arcpy.GetParameterAsText(1) ## orps
g = arcpy.GetParameterAsText(2) ## output table
c = arcpy.GetParameterAsText(3) ## well owner name field
d = arcpy.GetParameterAsText(4) ## orps owner name field
h = arcpy.GetParameterAsText(5) ## workspace
e = "OBJECTID" ## objectid of both well and orps data
f = "DECWell_" ## dec well identifier
env.workspace = h
##################### BEGINNING OF MATCH #########################################
## Make feature layers
arcpy.MakeFeatureLayer_management(a, "wells")
arcpy.MakeFeatureLayer_management(b, "orps")
wellsFL = "wells"
orpsFL = "orps"
## Create dictionary of well owners
well_owners = {}
wellnum = {}
## cursor to look through well data, getting DEC well number, owner name and object ID of well.
rows = arcpy.da.SearchCursor(wellsFL, [e, c, f])
for row in rows:
## split the owner's name in FIRST LAST format at a space, creating a list
owner = row[1].split(" ")
## take the last entry in the list and make that the entry for well_owners[objectID]
well_owners[row[0]] = "{}".format(owner.pop().upper())
## take the well identifier and make that the entry for wellnum[objectid]
wellnum[row[0]] = str(row[2])
del rows
## create dictionary of orps owners
orps_owners = {}
## cursor to look through orps data and return name of owner and objectID
rows = arcpy.da.SearchCursor(orpsFL, [e, d])
for row in rows:
## split owner's name in LAST FIRST format at the space, creating a list
owner = row[1].split(" ")
## take the first item in this list and make that the entry for orps_owners[objectid]
orps_owners[row[0]] = "{}".format(owner.pop(0).upper())
del rows
## create dictionary of matches
match = {}
## search through owner's names to find matching names
for o in well_owners:
for p in orps_owners:
if orps_owners
== well_owners:
if not o in match:
match = []
match.append(p)
## create an empty table to fill with matches
arcpy.CreateTable_management(h, "TABLE")
## add relevant fields to the new table
arcpy.AddField_management("TABLE", "DECWell_", "TEXT")
arcpy.AddField_management("TABLE", "match", "LONG")
## create insert cursor to insert a new row in the newly created table for each match found
rows = arcpy.da.InsertCursor("TABLE", ["DECWell_", "match"])
## for each entry in the dictionary of matches
for key in match:
## assign a variable for the unique ID of the well in the first for loop
ID = wellnum[key]
## iterate through each value in the list of matches
for s in match[key]:
## assign a tuple of the values the cursor will insert into the fields of each row
insert = (ID, s)
## insert new row
rows.insertRow(insert)
del rowsI have used an old variation of this script to produce a similar result in the past, and have observed no errors with regards to matching the correct well to the correct orps and getting the right well identifier out of the dictionary.
In the ArcGIS help for insert cursors, it says that you can select all fields in the table using a " * " in the "field_name" parameter of the cursor, and I thought that perhaps it was messing up because I was using all fields by name instead of using the " * ". So I had the script add a third field and try to use only those two, and also attempted to use the " * " with only two fields, and both still returned the same error that I mentioned above, of incorrect SQL syntax.
