PostGIS

The PostGIS datastore is available for Reading and Writing data in 1Integrate.

Read and Write Support

Read	Write		FME Required
Read	Commit	Copy To	FME Required

Data Support

Data	Support	Notes
Non-Spatial		For Non-Spatial data, use the PostgreSQL/PostGIS data store.
2D
Measured
Heighted
3D		Note: Support for 3D is in BETA when using this data store. For more information about 3D data in 1Integrate, please refer to 3D Support.

Input and Output Parameters

Input Parameters

Parameter	Description
Source Database	The name of the PostGIS-enabled PostgreSQL database. The database must exist in the RDBMS.
Coordinate Reference System	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). Note: Coordinate Reference System parameters are required in a session that will write data to Oracle. 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 Parameters

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)