Latest Contributions by ChrisGAEG

你是说Pyhton 3.6 +吗?我能说的经验that some of the arcpy tools in Python 3.7 (ArcGIS Pro 2.9) that some of the tools accept f-string as parameters other does not: This example does not work (using the f-string in the where_clause parameter): where_clause_with_date_filter = f"{where_clause} AND {date_filter}" points_select = arcpy.analysis.Select("{0}.{1}".format(schema_owner, TABLE_CAL_POINTS), r"memory\f{0}".format(uuid4().hex),where_clause_with_date_filter) generates the error: File "C:\Program Files\ArcGIS\Server\framework\runtime\ArcGIS\Resources\ArcPy\arcpy\analysis.py", line 138, in Select raise e File "C:\Program Files\ArcGIS\Server\framework\runtime\ArcGIS\Resources\ArcPy\arcpy\analysis.py", line 135, in Select retval = convertArcObjectToPythonObject(gp.Select_analysis(*gp_fixargs((in_features, out_feature_class, where_clause), True))) File "C:\Program Files\ArcGIS\Server\framework\runtime\ArcGIS\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 512, in return lambda *args: val(*gp_fixargs(args, True)) arcgisscripting.ExecuteError: ERROR 000358: Invalid expression f"{where_clause} AND {date_filter}" Failed to execute (Select). i have tried to use the f-string in search cursor, and update cursor and found that in the feature_class parameter,m it does not accept f-strings, but in the where_clause it does: with arcpy.da.UpdateCursor("{0}.{1}".format(schema_owner, TABLE_LINKAGES), ["REFERENCE_FEATURE_ID"], where_clause=f"PROJECT_ID = '{project_id}'") as cursor: ... View more

@JohannesLindner Thank you so much, it works perfectly you're a legend! In the hopes that it might help someone else create database sequences using arcpy here is my code for that: import arcpy def main(): fgdb = r'C:\pathtoyourdb.gdb' # Get all of the codes to build the sequences from table = r'C:\pathtoyourdb.gdb\yourFeatureClass' field = 'YourIDField' with arcpy.da.SearchCursor(table, [field]) as cursor: myValues = sorted({row[0] for row in cursor}) print (myValues) for value in myValues: arcpy.CreateDatabaseSequence_management(fgdb, value+"_1", 1, 1) for value in myValues: arcpy.CreateDatabaseSequence_management(fgdb, value+"_2", 1, 1) sequences = arcpy.da.ListDatabaseSequences(fgdb) for seq in sequences: print('Sequence name: {}'.format(seq.name)) print('Sequence start value: {}'.format(seq.startValue)) print('Sequence increment value: {}'.format(seq.incrementValue)) print('Sequence current value: {}'.format(seq.currentValue)) if __name__ == '__main__': main() Once again, can't thank you enough for your help it is very much appreciated! ... View more

Wow this is great, thank you once again Johannes! ... View more

Thanks for the help. I didn't realized that street_status wasn't numeric. ... View more

That statement is correct and should work p.s. it is not Arcade, it is SQL. ... View more

It should be identical ... View more

Wow so simple, that's great. Thanks again! ... View more

Dan, Thanks for the advice. I ended up using Pandas. ... View more

This will work! And you were right, the OID in the table is ordered sequentially and will serve as the segment id for the output of the script. Thanks a lot for your help. ... View more

That works! The syntax example will also help a lot for future rules, so thanks so much! ... View more

Please don't post code as screenshots. //www.gobook3.com/t5/community-help-documents/how-to-insert-code-in-your-post/ta-p/914552 ... View more

This is exactly what I was trying to do. I had read the documentation of the arcpy.GetParameterAsText() , but was a bit thrown off that the function didn't use [] to reference list index. This really helps clarify it for me. Thanks a lot!! ... View more