[
https://issues.apache.org/jira/browse/STREAMPIPES-584?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17626563#comment-17626563
]
Florian Micklich commented on STREAMPIPES-584:
----------------------------------------------
{code:java}
-------- Ursprüngliche Nachricht --------<br>
Von: Florian Micklich via user
<[[email protected]](mailto:florian%20micklich%20via%20user%20%[email protected]%3e)><br>
Antwort an: Florian Micklich
<[[email protected]](mailto:florian%20micklich%20%[email protected]%3e)><br>
An: [[email protected]](mailto:[email protected])<br>
Betreff: Re: manually setup an EPSG database base information<br>
Datum: Sun, 30 Oct 2022 13:32:34 +0100<br>
Hi Martin,<br>
many many thanks for the detail description. This makes it much clearer now for
me.<br>
I have some follow up questions.<br>
What happens (for some reason) the db is not available anymore.
Is there an exception I can catch to handle something like this?
Is there a method in SIS that I can use to verify that the DataSource has been
set up correctly?<br>
Also thanks for the hint with the index [1]. I see there is also a prepare.sql
script [2].
Is this also necessary or what is its purpose?<br>
Greetings
Florian<br>
[1]
https://github.com/apache/sis/blob/master/core/sis-referencing/src/main/resources/org/apache/sis/referencing/factory/sql/EPSG_Finish.sql<br>
[2]
https://github.com/apache/sis/blob/master/core/sis-referencing/src/main/resources/org/apache/sis/referencing/factory/sql/EPSG_Prepare.sql<br>
{code}
> Implementing possibility for reprojection Coordinates
> -----------------------------------------------------
>
> Key: STREAMPIPES-584
> URL: https://issues.apache.org/jira/browse/STREAMPIPES-584
> Project: StreamPipes
> Issue Type: New Feature
> Components: Backend, Pipeline Elements
> Reporter: Florian Micklich
> Assignee: Florian Micklich
> Priority: Major
> Attachments: .env, docker-compose.yml, settings_epsg.png,
> workflow.png, workflow_v2.png
>
>
> h1. 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)
> h1. Libs and Sources:
> Lib for reprojection would be
> https://sis.apache.org/
> 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.
> h1.
> h1. 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?
> !workflow_v2.png!
> Draft for EPSG Database Setup:
> !settings_epsg.png!
> h1. Material
> Docker-compose file for SP Service
> [^.env]
> [^docker-compose.yml]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
