Skip to content

Update station and campaign geometries after CSV upload #74

@mosoriob

Description

@mosoriob

Description

When a CSV file is uploaded, we need to update the geometries for both stations and campaigns in the database. The database already has two functions to handle this: update_campaign_geometry and update_station_geometry.

Implementation Details

  1. Current State:

    • CSV upload process exists but doesn't trigger geometry updates
    • Database functions update_campaign_geometry and update_station_geometry are available
  2. Required Changes:

    • Add a post-processing step after CSV upload validation
    • Call the appropriate database functions to update geometries
    • Consider transaction handling to ensure data consistency
  3. Technical Considerations:

    • Should both functions be called in sequence or in parallel?
    • Is there a dependency between campaign and station geometries?
    • Are there performance concerns with large CSV uploads?

Acceptance Criteria

  • After a CSV is successfully uploaded, both station and campaign geometries are updated
  • The process handles errors gracefully
  • Updates are logged for monitoring purposes
  • Performance remains acceptable with larger datasets

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions