Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Apply simplify algorithm to existing geometries and future submissions #632

Open
11 tasks
basilv opened this issue May 15, 2024 · 0 comments
Open
11 tasks
Labels
enhancement New feature or request

Comments

@basilv
Copy link
Collaborator

basilv commented May 15, 2024

To address performance/capacity limitations for BCGW Extract, we want to apply a simplify algorithm to FOM spatial objects in order to drastically reduce the volume of data (# of vertices). This algorithm will be applied as a data fix to the existing data as well as applying when new spatial data is submitted.

Additional Context

  • See spike ticket SPIKE: Address BCGW extract taking too long in the future #612
  • Use ST_SimplifyPreserveTopology in postgis with tolerance 2.5m
  • First draft of wording for FOM UI / Julius communications: "FOM applies processing to the submitted spatial objects in order to keep storage / processing requirements reasonable. Spatial objects submitted that are overly detailed have the number of vertices reduced while preserving the original shape within a tolernace of approximately 2.5 meters. (For the geospatially-savvy, this is done using the Douglas-Peucker algorithm.)"

Acceptance Criteria

  • Data migration to apply simplify algorithm to all existing spatial objects (cut blocks, retention areas, road sections).
  • Add step in processing of spatial submission to apply simplify algorithm, probably as an update statement after storing the initial data in the database.
  • Copy some complex spatial objects from prod to test environment to manually test the above two items.
  • Add wording to FOM spatial submission screen (expanded text area) about doing the simplification. (Basil to draft - see above)
  • Send communications to Julius about doing the simplification that he can pass along to submitters (Basil to draft - see above). Include some screenshots from testing (see spike ticket SPIKE: Address BCGW extract taking too long in the future #612).

Definition of Done

  • Ready to Demo in Sprint Review
  • Does what I have made have appropriate test coverage?
  • Documentation and/or scientific documentation exists and can be found
  • Peer Reviewed by 2 people on the team
  • Manual testing of all PRs in Dev and Prod
  • Merged
@basilv basilv added the enhancement New feature or request label May 15, 2024
@basilv basilv changed the title Apply simplify algorithm to existing geometrics and future submissions Apply simplify algorithm to existing geometries and future submissions May 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant