You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
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
The text was updated successfully, but these errors were encountered:
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
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
Acceptance Criteria
Definition of Done
The text was updated successfully, but these errors were encountered: