I plan to run a scheduled server job on a feature class in an Oracle 18c/10.7.1 geodatabase.
The job would:
- Truncate the rows in an existing feature class
- Generate new rows from a geoprocessing tool (FeatureVerticesToPoints / midpoints)
- Insert/append the geoprocessing rows into the feature class
Note: I would like to do this without needing to temporarily store any sort of intermediate results in a temporary feature class/GDB.
I've gotten part-way there:
import arcpy conn = "Database Connections\\DEV.sde\\" input_lines = "OWNER.ROAD" existing_fc = "OWNER.SCHED_ROAD_MIDPOINT" arcpy.TruncateTable_management(conn + existing_fc) arcpy.FeatureVerticesToPoints_management(conn + input_lines, conn + existing_fc, "MID") #arcpy.Append_management(, , "TEST", "", "")
I'm not sure how to use
FeatureVerticesToPoints_management as the input in the append process.
Is there a way to append/insert geoprocessing results into an existing feature class using ArcPy?