Latest Contributions by JordanMiller4

How can I check each row for 2 values [counties & township]? Loop and if they match the dictionaries below, continue the If  True statement  than do something. My script right now is super slow. Processed 2 counties in 3 hours.  #Import system modules import arcpy from arcpy import env import os import time counties = ["RIC",\ "ASD", "ATB", "TUS", "HOL", "STA", "SUM", "CAR", "TRU", "WAS", "FAI", "COL", "WAY", "GEA", "LAK", "HOC", "MRW", "MAR", "MAH", "FRA", "GUE", "HAS", "POR", "CRA", "CUY", "COS"] townships = ["SANDUSKY",\ "MILTON", "WELLER", "MORGAN", "ORWELL", "LENOX", "MONTGOMERY", "MADISON", "MIFFLIN", "WAYNE", "WALNUT CREEK", "ROME", "PERRY", "PIKE", "SPRINGFIELD", "TWINSBURG", "MONROE", "SUGAR CREEK", "TUSCARAWAS", "AUGUSTA", "BROWN", "ORANGE", "ROSE", "MESOPOTAMIA", "WARREN", "FAIRFIELD", "MILL", "SANDY", "FEARING", "VIOLET", "SALEM", "BUTLER", "KNOX", "ADAMS", "MUSKINGUM", "SALT CREEK", "SUGAR CREEK", "WAYNE", "WATERFORD", "WATERTOWN", "MONTVILLE", "GREEN", "MILTON", "PAINT", "WOOSTER", "BAUGHMAN", "CHESTER", "CHIPPEWA", "MADISON", "PAINESVILLE", "PERRY", "CONCORD", "FALLS", "NORTH BLOOMFIELD", "BIG ISLAND", "GRAND PRAIRIE", "CANFIELD", "ELLSWORTH", "AUSTINTOWN", "FRANKLIN", "WESTLAND", "MADISON", "MONROE", "TULLY", "SCOTT", "NORTH", "RIPLEY", "MARION", "PLEASANT", "VALLEY", "SALT CREEK", "GREENFIELD", "AUBURN", "LIBERTY", "CHARDON", "EAST UNION", "BERLIN", "NEWBURY", "PARKMAN", "PAINT", "BLOOM", "HARDY", "DEERFIELD", "FRANKLIN", "TROY", "ATWATER", "MECHANIC", "SUFFIELD", "WINDHAM", "JACKSON", "HAMBDEN", "WASHINGTON", "WHETSTONE", "URBAN", "URBAN", "URBAN", "MANTUA", "HUNTSBURG", "MUNSON", "SOUTHINGTON", "RANDOLPH", "PRAIRIE", "MILTON", "SUGAR CREEK", "CLARK", "CRAWFORD", "THOMPSON", "POLK", "NEWTON", "URBAN", "BETHLEHEM", "FRANKLIN", "LAWRENCE", "SPRINGFIELD", "WARREN", "HOWLAND", "FARMINGTON", "URBAN", "BRACEVILLE", "BAZETTA", "JACKSON", "BRISTOL", "URBAN", "PERRY", "CANAAN", "CHAMPION", "BLOOMFIELD", "BERLIN", "BROOKFIELD", "LAWRENCE", "MIDDLEFIELD", "BURTON", "LEROY", "HAMILTON"] mxd = arcpy.mapping.MapDocument("CURRENT") df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0] lyr = arcpy.mapping.ListLayers(mxd, "ohioGrids", df)[0] for lyr in arcpy.mapping.ListLayers(mxd, "*"): if lyr.name == "ohioGrids": for a in counties: b = "%s" % (a) # #print ("%s" % (b)) for c in townships: d = "%s" % (c) # #print ("%s" % (d)) arcpy.SelectLayerByAttribute_management("ohioGrids", "CLEAR_SELECTION") cnty = '"COUNTY_CD" = \'%s\'' % b seperator = " AND " twpship = '"TOWNSHIP_N" = \'%s\'' % c lyr.definitionQuery = cnty + seperator + twpship result1 = arcpy.GetCount_management("ohioGrids") #print('{} has {} records'.format("ohioGrids", result[0])) if result1 > 0: #arcpy.RefreshActiveView() # GetExtent lyr = arcpy.mapping.ListLayers(mxd, 'ohioGrids', df)[0] ext = lyr.getExtent() df.extent = ext # SelectLayerByLocation selection = arcpy.SelectLayerByLocation_management ("Meters", "WITHIN", "ohioGrids") result = arcpy.GetCount_management(selection) count = int(result.getOutput(0)) if count > 0: print "COUNTY: " + b + " & " + "TOWNSHIP: " + d print count arcpy.SelectLayerByAttribute_management("ohioGrids", "CLEAR_SELECTION") else: arcpy.SelectLayerByAttribute_management("ohioGrids", "CLEAR_SELECTION") ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

What can I do to allow sketches to be view in survey123 when someone creates them?   ... View more

Is it possible to assign an ID to a field based on where a geopoint is placed on a map? Can be anywhere. We would like to populate an office field based on where the geopoint is placed. So if the geopoint is closest an office, call the office name in the field. Any help or examples would be appreciated! Thanks! ... View more

What's the best way to populate a department section based on a filter which works and 2 milestone date fields? I'll provide an example below if someone could help! Thanks! ... View more

Is there's a way to setup inbox to read the choices?  I know with a single selection we are able to use field=${username} but when you add more like   "person1, person2 , person3" it's unable to read.  In ArcMap I've used this WORKORDERID LIKE '%20161008%' becuase it's able to find that string but LIKE '%${username}%' doesn't seem to be a valid expression for the inbox. I'll provide an example form below. To get a single selection to show in your inbox, add your login username in the choice tab. Any help would be greatly appreciated! Any help would be greatly appreciated! ... View more

We're looking to purchase several GPS receivers and poles for better accuracy. I was wondering which ones would be the best bang for your buck and last for 3-4 years? Looking for something that can be used with Collector and there other apps. Thanks  ... View more