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 ?
@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
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.