Click a star to rate this topic

Click a star to rate this topic

Click a star to rate this topic

Click a star to rate this topic

Click a star to rate this topic

PostGIS

Read and Write Support

Data Store Type	As standard		Using FME Desktop
Data Store Type	Write	Read	Read	Write
PostGIS

Commit Support

Data Store Type

Task Supported

Commit

Copy-to

PostGIS

Input and Output Connection

Input Connection

Parameter	Description
Source Database	The name of the PostGIS-enabled PostgreSQL database. The database must exist in the RDBMS.
Coordinate Reference System	Coordinate Reference System parameters are required in a session that will write data to Oracle. This parameter can be used to specify a Coordinate Reference System (CRS) code of the input data, if it cannot be deduced automatically. This will not re-project the data, but allows its current CRS to be defined (e.g to enable multiple data stores to open where one does not have a CRS defined). See Coordinate Reference System for more information on when this is required.
Allow invalid geometries	Allows features with invalid geometries (e.g. duplicate vertices, self-intersections) to be imported. This is necessary if they need to be imported in order to be validated or corrected. If not ticked then features with invalid geometries are not imported and are logged as feature errors in the open data task.
Enable full 3D Geometries (BETA)	Select to enable full 3D geometries. Note: This parameter will only appear with an additional license enabling 3D support within 1Integrate. For more information on full 3D in 1Integrate, please see 3D Support.
Ignore Z or M	If you have data that is recorded as X,Y,Z,M, but without a meaningful Z or M value, you can opt to ignore either Z or M values. Note: If the default is left on and X,Y,Z,M is uploaded then an exception will be thrown as 1Integrate only supports X,Y,M or X,Y,Z.
Write ignored Z or M values as zero	Select to write ignored values as zero in place of null.
Import host name	The host name for the PostGIS database.
Import port number	The port name for the PostGIS database.
Import username	The username for the PostGIS database.
Import password	The password for the PostGIS database

Output Connection

Parameter	Description
Destination Database	The name of the PostGIS-enabled PostgreSQL database. The database must exist in the RDBMS.
Force geometry to be written with 4 coordinates	Select to output a fourth m coordinate for objects. Only takes effect if the geometry to be written has 3 coordinates. Note: In PostGIS, ensure that your coord_dimension integer is set to 4.
Use zero when writing ignored coordinate	Select to write ignored values as zero in place of null.
Export host name	The host name for the PostGIS database.
Export port number	The port number for the PostGIS database.
Export username	The username for the PostGIS database.
Export password	The password for the PostGIS database.

Copyright © 2021 1Spatial
US Patent Number 9542416 B2 (2017-01-10)