how to we work with the postGIS column??

[SLDonnelly]

Describe the task
Spike to determine how it works with (1) java and (2) how it can work with the seedlot_audit table.

Ricardo to work with java classes and document how they work with Java and the ETL. For the seed_audit table need to capture changes to the seedlot postgis columns.

Acceptance Criteria

• document cases one and two add documentation for geospatial columns in the seedlot table in postgres #1036 in Github Wiki

[RMCampos]

Logs from the database, regarding the Seedlot Audit table:

2024-05-13 18:38:26.019 UTC [23624] WARNING:  [AUDIT.IF_MODIFIED_FUNC] - UDF ERROR [OTHER] - SQLSTATE: 42601, SQLERRM: INSERT has more expressions than target columns
2024-05-13 18:38:26.019 UTC [23624] CONTEXT:  PL/pgSQL function seedlot_if_modified_func() line 345 at RAISE
2024-05-13 18:42:04.000 UTC [23929] WARNING:  [AUDIT.IF_MODIFIED_FUNC] - UDF ERROR [OTHER] - SQLSTATE: 42601, SQLERRM: INSERT has more expressions than target columns
2024-05-13 18:42:04.000 UTC [23929] CONTEXT:  PL/pgSQL function seedlot_if_modified_func() line 345 at RAISE
2024-05-13 18:42:04.045 UTC [23929] WARNING:  [AUDIT.IF_MODIFIED_FUNC] - UDF ERROR [OTHER] - SQLSTATE: 42601, SQLERRM: INSERT has more expressions than target columns
2024-05-13 18:42:04.045 UTC [23929] CONTEXT:  PL/pgSQL function seedlot_if_modified_func() line 345 at RAISE
2024-05-13 18:42:04.581 UTC [23929] WARNING:  [AUDIT.IF_MODIFIED_FUNC] - UDF ERROR [OTHER] - SQLSTATE: 42601, SQLERRM: INSERT has more expressions than target columns
2024-05-13 18:42:04.581 UTC [23929] CONTEXT:  PL/pgSQL function seedlot_if_modified_func() line 345 at RAISE
2024-05-13 18:42:05.627 UTC [23929] WARNING:  [AUDIT.IF_MODIFIED_FUNC] - UDF ERROR [OTHER] - SQLSTATE: 42601, SQLERRM: INSERT has more expressions than target columns
2024-05-13 18:42:05.627 UTC [23929] CONTEXT:  PL/pgSQL function seedlot_if_modified_func() line 345 at RAISE

[RMCampos]

Based on this task. A SPAR wiki page was put together: How to work with PostGIS in Java

References:

• GeometryFactory JavaDoc
• LocationTech JTS Java library
• Hibernate Spatial Types
• Map PostGIS with Hibernate - Old, but some relevant comments

Indirectly related:

• PostGIS 3D Point - PoitZ
• PostGIS Geometries