Import Shapes with Joined Data

Author: O.Conrad (c) 2024
Menu: Database | PostgreSQL | Shapes

Description

Imports shapes with joined data from a PostGIS database.

Parameters

	Name	Type	Identifier	Description	Constraints
Output	Shapes	shapes, output	`SHAPES`	-	-
Options	Connection	choice	`CONNECTION`	-	Available Choices: Default: 0
	Geometry Table	text	`GEO_TABLE`	-	-
	Key	text	`GEO_KEY`	-	-
	Join Table	text	`JOIN_TABLE`	-	-
	Key	text	`JOIN_KEY`	-	-
	Fields	text	`FIELDS`	-	-
	Where	text	`WHERE`	-	-
	Group by	text	`GROUP`	-	-
	Having	text	`HAVING`	-	-
	Order by	text	`ORDER`	-	-
	Distinct	boolean	`DISTINCT`	-	Default: 0

Command Line


Usage: saga_cmd db_pgsql 24 [-CONNECTION ] [-SHAPES ] [-GEO_TABLE ] [-GEO_KEY ] [-JOIN_TABLE ] [-JOIN_KEY ] [-FIELDS ] [-WHERE ] [-GROUP ] [-HAVING ] [-ORDER ] [-DISTINCT ]
  -CONNECTION:   Connection
	choice
	Available Choices:
	Default: 0
  -SHAPES:       Shapes
	shapes, output
  -GEO_TABLE:    Geometry Table
	text
  -GEO_KEY:      Key
	text
  -JOIN_TABLE:   Join Table
	text
  -JOIN_KEY:     Key
	text
  -FIELDS:       Fields
	text
  -WHERE:        Where
	text
  -GROUP:        Group by
	text
  -HAVING:       Having
	text
  -ORDER:        Order by
	text
  -DISTINCT:     Distinct
	boolean
	Default: 0