I am trying to create a python toolbox with the following function: I want to select points or lines within a polygon and save the selected feautres as a temporarily Feature. (That works)
Then I want to use SQL-Queries for example to count all Features of the Point-Feature-Class or the total length of a Line-Feature-Class. The result of the queries should be written into an existing Table. For example the result of the total length of a Line-Feature-Class, should be written into the Field: TOTAL_LENGTH.
At the end, the Table should be exported as an excel-file (Should be no problem)
I don't want to get the complete finished code. Just an Idea how to do the query and saving the result into a different existing table.
Does somebody has an idea?