.
<put algorithm description here>
Input layer [vector: any]<geben Sie hier die Parameterbeschreibung ein>
SQL [string]<geben Sie hier die Parameterbeschreibung ein>
Default: (not set)
SQL result [vector]<fügen Sie hier die Übersetzung der Ausgabe ein>
processing.runalg('gdalogr:executesql', input, sql, output)
Imports vector layers inside a PostGIS database on the basis of an available connection. The connection has to be defined properly with the ‘Add PostGIS Table(s)’ dialog before. Use the ‘Edit’ button to define the connection. Be aware that the checkboxes ‘Save Username’ and ‘Save Password’ are activated. Then you can use the algorithm. The algorithm is derived from the ogr2ogr utility .
Database (connection name) [selection]Requires the database (connection) name.
Options:
Default: 0
Input layer [vector: any]Output geometry type [selection]Defines the output geometry type. By default this is Polygon.
Options:
Default: 5
Input CRS (EPSG Code) [crs]CRS of the input vector layer.
Default: EPSG:4326
Output CRS (EPSG Code) [crs]Defines the output CRS of the database table.
Default: EPSG:4326
Schema name [string]Optional.
Defines the schema to which the database table will be assigned to. By default, ‘public’ is chosen.
Default: public
Table name, leave blank to use input name [string]Optional.
Defines a name for the table that will be imported into the database. By default the table name is the name of the input vector file.
Default: (not set)
Primary Key [string]Optional.
Defines which attribute field will be the primary key of the database table. By default this is ‘id’.
Default: id
Geometry column name [string]Optional.
Defines in which attribute field of the database there will be the geometry information. By default it will be taken from the ‘geom’ column.
Default: geom
Vector dimensions [selection]Defines if the vector file to be imported has 2-D or 3-D data.
Options:
Default: 0
Distance tolerance for simplification [string]Optional.
Defines a distance tolerance for the simplification of the vector geometries to be imported. By default no simplification there is no simplification.
Default: (not set)
Maximum distance between 2 nodes (densification) [string]Optional.
The maximum distance between two nodes. Used to create intermediate points. By default there is no maximum distance.
Default: (not set)
Select features by extent (defined in input layer CRS) [extent]You can select features from a given extent that will be in the output table.
Default: 0,1,0,1
Clip the input layer using the above (rectangle) extent [boolean]The input layer will be clipped by the extent you defined before.
Default: False
Select features using a SQL "WHERE" statement (Ex: column="value") [string]Optional.
Defines with a SQL “WHERE” statement which features should be selected for the output table.
Default: (not set)
Group "n" features per transaction (Default: 20000) [string]Optional.
You can group the input features in transactions where “n” defines the size. By default “n” limits the transaction size to 20000 features.
Default: (not set)
Overwrite existing table? [boolean]If there is a table with the same name in the database, it won’t be overwritten. By default this takes place.
Default: True
Append to existing table? [boolean]<geben Sie hier die Parameterbeschreibung ein>
Default: False
Append and add new fields to existing table? [boolean]If activated the vector data will be appended to an existing table, there won’t be created a new table. By default a new table will be created.
Default: False
Do not launder columns/table name/s? [boolean]With this option you can prevent processing from converting column names to lowercase, from removing spaces and other invalid characters.
Default: False
Do not create Spatial Index? [boolean]Prevents that a spatial index in the output table will be created.
Default: False
Continue after a failure, skipping the failed feature [boolean]<geben Sie hier die Parameterbeschreibung ein>
Default: False
Additional creation options [string]Optional.
<geben Sie hier die Parameterbeschreibung ein>
Default: (not set)
processing.runalg('gdalogr:importvectorintopostgisdatabaseavailableconnections', database, input_layer, gtype, s_srs, t_srs, schema, table, pk, geocolumn, dim, simplify, segmentize, spat, clip, where, gt, overwrite, append, addfields, launder, index, skipfailures, options)
Imports vector layers inside a PostGIS database. A new connection to the PostGIS database must be created. The algorithm is derived from the ogr2ogr utility .
Input layer [vector: any]<geben Sie hier die Parameterbeschreibung ein>
Output geometry type [selection]<geben Sie hier die Parameterbeschreibung ein>
Options:
Default: 5
Input CRS (EPSG Code) [crs]<geben Sie hier die Parameterbeschreibung ein>
Default: EPSG:4326
Output CRS (EPSG Code) [crs]<geben Sie hier die Parameterbeschreibung ein>
Default: EPSG:4326
Host [string]<geben Sie hier die Parameterbeschreibung ein>
Default: localhost
Port [string]<geben Sie hier die Parameterbeschreibung ein>
Default: 5432
Username [string]<geben Sie hier die Parameterbeschreibung ein>
Default: (not set)
Database Name [string]<geben Sie hier die Parameterbeschreibung ein>
Default: (not set)
Password [string]<geben Sie hier die Parameterbeschreibung ein>
Default: (not set)
Schema name [string]Optional.
<geben Sie hier die Parameterbeschreibung ein>
Default: public
Table name, leave blank to use input name [string]Optional.
<geben Sie hier die Parameterbeschreibung ein>
Default: (not set)
Primary Key [string]Optional.
<geben Sie hier die Parameterbeschreibung ein>
Default: id
Geometry column name [string]Optional.
<geben Sie hier die Parameterbeschreibung ein>
Default: geom
Vector dimensions [selection]<geben Sie hier die Parameterbeschreibung ein>
Options:
Default: 0
Distance tolerance for simplification [string]Optional.
<geben Sie hier die Parameterbeschreibung ein>
Default: (not set)
Maximum distance between 2 nodes (densification) [string]Optional.
<geben Sie hier die Parameterbeschreibung ein>
Default: (not set)
Select features by extent (defined in input layer CRS) [extent]<geben Sie hier die Parameterbeschreibung ein>
Default: 0,1,0,1
Clip the input layer using the above (rectangle) extent [boolean]<geben Sie hier die Parameterbeschreibung ein>
Default: False
Select features using a SQL "WHERE" statement (Ex: column="value") [string]Optional.
<geben Sie hier die Parameterbeschreibung ein>
Default: (not set)
Group "n" features per transaction (Default: 20000) [string]Optional.
<geben Sie hier die Parameterbeschreibung ein>
Default: (not set)
Overwrite existing table? [boolean]<geben Sie hier die Parameterbeschreibung ein>
Default: True
Append to existing table? [boolean]<geben Sie hier die Parameterbeschreibung ein>
Default: False
Append and add new fields to existing table? [boolean]<geben Sie hier die Parameterbeschreibung ein>
Default: False
Do not launder columns/table name/s? [boolean]<geben Sie hier die Parameterbeschreibung ein>
Default: False
Do not create Spatial Index? [boolean]<geben Sie hier die Parameterbeschreibung ein>
Default: False
Continue after a failure, skipping the failed feature [boolean]<geben Sie hier die Parameterbeschreibung ein>
Default: False
Additional creation options [string]Optional.
<geben Sie hier die Parameterbeschreibung ein>
Default: (not set)
processing.runalg('gdalogr:importvectorintopostgisdatabasenewconnection', input_layer, gtype, s_srs, t_srs, host, port, user, dbname, password, schema, table, pk, geocolumn, dim, simplify, segmentize, spat, clip, where, gt, overwrite, append, addfields, launder, index, skipfailures, options)
Creates an information file that lists information about an OGR-supported data source. The output will be shown in a ‘Result’ window and can be written into a HTML-file. The information includes the geometry type, feature count, the spatial extent, the projection information and many more.
Input layer [vector: any]Layer information [html]processing.runalg('gdalogr:information', input, output)