Latest Contributions by JohannesBierer

‎02-03-2023

Didn't knowed this tool, if I run it with one empty field I want to delete I get something like this: Sorry it's in german ... I think the problem with this tool will be that it's some kind of chaotic data merge out of excel files in the fc. The fields to delete could contain Null values, "", "0", " " ... .

‎02-02-2023

Sorry it works sucessfully ...

‎02-02-2023

Hello, I want to delete all empty fields in a feature class (arcgis pro 3.0 - notebooks) - with no sucess. The following script doesn't work, it prints fields as count = 0 which have valid attributes. Any better ideas? fc = "Merge_1" fields = [f.name for f in arcpy.ListFields(fc) if not f.required] for field in fields: count = 0 with arcpy.da.SearchCursor(fc, field) as cursor: for row in cursor: if row[0] is None or row[0] in ["", " ", "0"]: count += 0 else: count += 1 break print(field, count)

‎02-02-2023

Thank you ...

‎02-01-2023

Hello, I want to check if a field type is text to change this field to type double so that I can use it as input field into XYTableToPoint? This if statement in line 16 doesn't work (arcgis pro 3.0 notebook) Any ideas? Error message for line 41: ERROR 000308: Ungültiger Feldtyp for f in files_list: print (f) outTable = "tab_" + os.path.splitext(os.path.basename(f.replace("-", "_")))[0] outXY = "s_" + os.path.splitext(os.path.basename(f.replace("-", "_")))[0] arcpy.conversion.ExcelToTable(f, outTable) x = "R_Wert" y = "H_Wert" fields = arcpy.ListFields(outTable) field_names = [] for field in fields: field_names.append(field.name) if field.name == x and field.type == "TEXT": print("Wrong type") arcpy.management.AddField(outTable, "R_Wert_1", "DOUBLE") arcpy.management.CalculateField(outTable, "R_Wert_1", '!R_Wert!', "PYTHON3") x = "R_Wert_1" elif field.name == y and field.type == "TEXT": print("Wrong Type") arcpy.management.AddField(outTable, "HWert_1", "DOUBLE") arcpy.management.CalculateField(outTable, "R_Wert_1", '!H_Wert!', "PYTHON3") y = "H_Wert_1" else: continue if x in field_names and y in field_names: print("Field names ok") arcpy.management.XYTableToPoint(outTable, outXY, x, y, "", arcpy.SpatialReference("DHDN 3-Degree Gauss Zone 3"))# ('ETRS 1989 UTM Zone 32N')) else: print("Field names wrong") continue

‎01-26-2023

Could it be a problem that the kml name starts with a number or the spaces in your pathnames? https://community.esri.com/t5/data-management-blog/how-to-name-things-in-arcgis/ba-p/897194

‎01-25-2023

Think it's possible: https://pro.arcgis.com/en/pro-app/latest/help/analysis/geoprocessing/basics/the-in-memory-workspace.htm

‎01-16-2023

Don't know if it helps, but I tried to print the € in a field name like this? import arcpy featureclass = r"YourPath2FC" field_names = [f.name.encode("windows-1252") for f in arcpy.ListFields(featureclass)] print (field_names) for f in field_names: print f.decode("windows-1252")

‎01-09-2023

Hello there's a key: tunnel in the OpenStreetMap data: https://wiki.openstreetmap.org/wiki/DE:Key:tunnel Don't know if you can download this data through ESRI Sources ... ?

‎01-04-2023

could this help you: https://pro.arcgis.com/en/pro-app/latest/tool-reference/cartography/calculate-polygon-main-angle.htm

‎01-04-2023

I think you will need python to do this - someone posted a solution here: https://gis.stackexchange.com/questions/34647/creating-lines-from-points-pair-coordinates-with-arcpy I tried the code of Chad Cooper there with four points with the old cursors ... it seems to work. Here is the code I used: import arcpy fieldnames = ['X1', 'Y1', 'X2', 'Y2'] # Needed input/ output files inExcel = r"YOURPATH\Points.xlsx" FGDB = r"YOURPATH\Points2Lines.gdb" outTable = "Coords" outLines = "Lines" arcpy.env.workspace = FGDB arcpy.env.overwriteOutput = True # Change to your Sheet name! arcpy.conversion.ExcelToTable(inExcel, outTable, "Test") in_rows = arcpy.SearchCursor(outTable) point = arcpy.Point() array = arcpy.Array() # Without Spatial Reference, please change! arcpy.CreateFeatureclass_management(FGDB, outLines, "POLYLINE") featureList = [] cursor = arcpy.InsertCursor(outLines) feat = cursor.newRow() for in_row in in_rows: # Set X and Y for start and end points # Change here to your field names point.X = in_row.X1 point.Y = in_row.Y1 array.add(point) point.X = in_row.X2 point.Y = in_row.Y2 array.add(point) # Create a Polyline object based on the array of points polyline = arcpy.Polyline(array) # Clear the array for future use array.removeAll() # Append to the list of Polyline objects featureList.append(polyline) # Insert the feature feat.shape = polyline cursor.insertRow(feat) del feat del cursor

‎01-04-2023

If you are not happy with the proposed solutions maybe there is a way to create a profile table with python? Don't know if you use python? Some years ago XanderBakker wrote a script for profile graphs, perhaps it's possible to use this script to export excel tables with the profile data with 1m spacing? The script is here: https://community.esri.com/t5/python-documents/using-python-and-matplotlib-to-create-profile/ta-p/914055

‎01-03-2023

Maybe you could try the snap tool? https://pro.arcgis.com/de/pro-app/latest/tool-reference/editing/snap.htm

‎01-03-2023

Sorry I did overread that you need a table, I think you could use this tool: https://pro.arcgis.com/en/pro-app/latest/tool-reference/3d-analyst/stack-profile.htm

‎01-03-2023

could this help you? https://pro.arcgis.com/en/pro-app/latest/help/analysis/3d-analyst/interactively-create-a-profile-graph-with-digitized-lines-on-a-surface.htm

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by JohannesBierer

Re: Check if a field in a feature class is totally empty to delete it?

Re: Check if a field in a feature class is totally empty to delete it?

Check if a field in a feature class is totally empty to delete it?

Re: Check for certain field name and field type doesn't work

Check for certain field name and field type doesn't work

Re: ERROR 000732 when converting kml to layer with python

Re: Intermediate data in stand-alone Python scripts

Re: arcpy: problem with coding

Re: Data of tunnels in germany

Re: Is there a way to assign compass direction to building footprints?

Re: Can I import csv file of line data?

Re: combining a line with a DEM to create an elevation profile

Re: Align poly in arcgis

Re: combining a line with a DEM to create an elevation profile

Re: combining a line with a DEM to create an elevation profile

Re: Error processing drone imagery over river

Re: How create a line that go through to point and...

Re: What's the future of Concurrent licenses?

Re: What's the future of Concurrent licenses?

Re: How transpose a point on a line