[STREAMPIPES-584] Implementing possibility for reprojection Coordinates

• Type: Sub-task
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 1.0.0
• Component/s: Backend, Pipeline Elements
• Assignee: Florian Micklich
• Reporter: Florian Micklich
• Created: 18/Sep/22 10:20
• Updated: 26/Nov/22 17:57

Description

Apache SIS Reprojection implemented
Following Pipeline and csv data was used for testing:
Remember to set semantic geo.lat and geo lng in file adapter

test_example.csv

Result

accuracy compared to qgis is totally acceptable within 0.01 tolerance
validate_proj.csv

---

Goal:

Essential Task in Geo is to reproject between different Coordinate Reference Systems (CRS)
e.g for special calculations which needs meter as CRS Unit instead of degree (as it it in WGS84)

Libs and Sources:

Lib for reprojection would be
https://sis.apache.org/

fallback:
https://github.com/locationtech/proj4j

Necessary extra package is the EPSG Library Source, which needs a special license agreement (not apache license).
User Downloads the Postgres SQL Scripts here: https://epsg.org/auth/Account/Login
During registration User agrees to license, so it can be used in StreamPipes.

Following Workflow (to be discussed)

The User unzipped the Scripts and but them into a specific folder.
Then StreamPipes can start the docker-compose file and here the questions occurs.
how to implement the service and where
What happens if files are missing
Where to register the connectionSource and how to validate?

What happens if setup fails. Are geo processors active or special Exceptions during Pipeline Creation?

Draft for EPSG Database Setup:

Material

Docker-compose file for SP Service
.env
docker-compose.yml

Issue Links

• relates to: STREAMPIPES-638 Add fallback options for georeferencing via proj4j