Latest Contributions by MitchHolley1

Have you tried printing the query to verify the syntax?  If so, what does it look like? ... View more

Thanks Dan!  I need to somehow convert the first two columns of the array into integer types before converting to a table.  If not, the output table has 'Double' type in the ID fields.  Which is not ideal.  So that's why I tried to specify a dtype.  I guess I need to head to your blog and study arrays more.  Thanks again! ... View more

You can generate a Near Table if you have an Advanced license.  ... View more

Layers can be accepted in a tool if the Data Type is set to "Feature Layer".  Secondly, if you want to limit the input layer to some specific IDs, I would suggest using a SQL Expression parameter with the Data Type set to "SQL Expression".  This can be set to 'Optional' and you can set "Obtained from" to your input feature layer.  Just remember to incorporate this in the actual Python code.  ... View more

You need to look up how those functions work... ... View more

if row[1].strip().lower() != addDict[row[0]].strip().lower() ... View more

Yes... the != operation is a strict comparison.  I would include .strip() and .lower() for comparison.  ... View more

A couple things... do not run this code in the Python executable window inside of ArcMap.  Please make this tool a Script Tool.  It will be much easier to manage and deploy. Secondly, no... the addDict[row[0]] is correct because you're asking Python to compare the value of the dictionary associated with that ID.  Please research dictionaries and script tools.  You may want to print the keys and values of the dictionary to make sure it's built properly.  ... View more

If you make your Python script able to be consumed with ArcMap (via Script Tool), then it will automatically accept a selection. What you need to do is: 1.) Build a dictionary of ID: Address pairs 2.) Search feature attribute table for presence of Addresses 3.) Update field based on result from 2 This should get you started.  fc1 = r'complete_path_to_featureClass1' fc2 = r'complete_path_to_featureClass2' #build a dictionary of OBJECTID : Address pairs, change OID@ to your uniqueID addDict = {row[0]:row[1] for row in arcpy.da.SearchCursor(fc1, ['OID@','SiteAddress'])} #search through fc2 to see if addresses match based on OBJECTID value #again, change OID@ to your uniqueID with arcpy.da.UpdateCursor(fc2, ['OID@','SiteAddress','Verifi2']) as cursor:     for row in cursor:         if row[0] in addDict:             if row[1] != addDict[row[0]]: #if the value associated with those ids do not match                 row[2] = 'No'             else:                 row[2] = 'Match'             cursor.updateRow(row) del cursor‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Do these two datasets have a unique ID that links them together?  If so, you could create a dictionary with ID: Address pairs and use that to search the attribute table.  Nested cursors get tricky...  Just to clarify, are you looking for any Addresses in FC1 that are not in FC2? ... View more

Another idea is memorialize the GlobalIDs in the Feature Class (create new field called [GBL_GUID], GUID type --> Field Calculate the [GBL_GUID] field to the values in GlobalID).  Now, if you export any data from that Feature Class in whatever database format.. the relationship will be maintained through the new [GBL_GUID] field.   ... View more

Did you try:  where = 'UPPER("EmergencyServiceZones.POLICE") = UPPER("msag_temp.Police")' ? ... View more

I think you need to remove the (  , newline='')  from the open cursor.  Try the code below and see what you get.  with open('dataTester.csv', 'w') as fp:     a= csv.writer(fp, delimiter=',')     for line in data:         a.writerows(line)‍‍‍‍ ... View more