Latest Contributions by RPGIS

Hi, So I am working on a script to automate a process for populating certain fields in several feature classes, but in order to do so I need to determine what kind of geometries these feature classes are. Depending on what kind of feature classes they are, the script runs a certain way. The issue I am having with the script is I am not getting the list of geometries for the feature classes. The feature classes are in sde (not sure if that makes a difference) and I keep getting a list, but not a list of the geometries. Any help would be greatly appreciated. import arcpy arcpy.env.workspace = r'Database Connections\Storm Water.sde\STORM.GISADMIN.Storm_Network' fcs = [] descList = [] fclist = arcpy.ListFeatureClasses() for fc in fclist: fcs.append(fc) for fc in fcs: desc = arcpy.Describe(fc) descList.append(desc)‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Hi, So I have a relatively simple script that is basically a complete list of feature classes in a database and I was wondering how you would compare that list of feature classes to the list of records in a table. The other thing is, if there is a match between the list of feature classes and the table, to have the table populate with the record count of the matching feature class. I have a rough script that has both the list of the feature classes in a database and the list from the table, as well as the counts for each feature class. The other issue is that the names aren't the exact same but are similar. So I am trying to first figure out how to compare the list of feature classes to the list of records in the table. I think once I can get that then the rest should be relatively simple to do. import arcpy #set parameters inputTable = r'G:\MyThings\Test\NewTest3\StormLoad.gdb\Stormload_Table'#arcpy.GetParameterAsText(0) select_databases = r'G:\MyThings\Test\NewTest4\StormLoad.gdb'#arcpy.GetParamterAsText(1) #select_fields_toUpdate = arcpy.GetParameterAsText(2) input_value = '2'#arcpy.GetParameterAsText(3) arcpy.env.workspace = select_databases #Get list of field names field_names = [f.name for f in arcpy.ListFields(inputTable)] #Identify feature class and database field name fcdb_name_field = field_names[1] #Select the field names to populate select_field_names = field_names[2:] datasetList = arcpy.ListDatasets('*','Feature') #List feature classes def fcsInDS(): for dataset in datasetList: arcpy.env.workspace = dataset fcList = arcpy.ListFeatureClasses() return fcList fcsInDB = arcpy.ListFeatureClasses() fcs = fcsInDS() + fcsInDB for fc in fcs: fc_ReCount = arcpy.GetCount_management(fc) print '{0} has a record count of {1}'.format(fc, fc_ReCount) with arcpy.da.UpdateCursor(inputTable, field_names) as cursor: for row in cursor: if row[1] in fc: row[2] = input_value # cursor.updateRow(row)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I also noticed that when it loops through the list of combined lists, that it errors out with the feature classes in the database as either non existent or supported. I tried making a couple of adjustments to this script but it returns errors. I would greatly appreciate any assistance with this. -Robert ... View more

Good afternoon, So I am currently working on a script tool where I have to populate a set of records in a standalone table to feature counts for feature classes found in various databases. The issue that I have come across as of now if how to determine if a set of strings is similar, and if they are, run a loop to get a feature counts to then populate that record. This is nested in anther loop that loops through every field name in a standalone table. I also have fields where the name of the field corresponds with the name of the database it is derived from, and I have another loop that goes through each field name. So I am at a crossroad where I have a possible solution, but not sure if this is the right direction. Any assistance would be greatly appreciated. ... View more