I get datas from a csv file that contains a latitude and longitude field. These geographical data must be reprojected with different local systems. What should I do to build a postgis table with the correct coordinates (after reprojecting the given lat and lon in the correct geodetic system) for each point that I get ? Should I split in many different tables ?
Question
How to build a geometry from different srid to set up postgis parameters correctly
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
@rgaletta PostGIS supports a different coordinate system for each record in a table, see the section Working with coordinate systems in PostGIS in the article PostgreSQL/PostGIS II: Geometry Types and Coordinate Systems.
FME only supports a single coordinate system per table. to workaround this limitation, I think you could use the SQLExecutor to insert the records with the correct SRID as per the examples in the above article. Transformers you could use:
- any Reprojector transformer to give you the correct local coordinate
- GeometryExtractor to create the OGC WKT used in the SQL
- SQLExecutor
I've attached an example workspace (2019.0): insertpostgisgeometry.fmw