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", "", "")
Question:
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?