Finalize Incremental Clearcut Detection Script

[mtbarra]

Develop and finalize the Python script that performs incremental updates on the clearcut table in the backend database, leveraging the replica DB to avoid full reloads. This will enable us to identify and insert or update new clusters of clear cuts.

Simplified tasks:

• Parse newly downloaded files and extract date + geometry

• Query the replica DB to fetch latest clearcut records (under 1 year old).

• For each new area:

• Check for proximity (< 100m) to existing areas

• If nearby:

• Merge geometries

• Update fields like centroid, area, multipolygon, etc.

• If isolated:

• Create a new entry in clearcut

• Populate DB (API or direct upsert, depending on time)

• Logs and validation for audit trail.