Skip to content

Instantly share code, notes, and snippets.

@ThomasG77

ThomasG77/model-postgis-input-epsg.model3

Created July 2, 2021 12:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ThomasG77/61afda568887fcc603e1f9ef963925ec to your computer and use it in GitHub Desktop.
Save ThomasG77/61afda568887fcc603e1f9ef963925ec to your computer and use it in GitHub Desktop.
Download ZIP
Raw
model-postgis-input-epsg.model3
<!DOCTYPE model>
<Option type="Map">
<Option name="children" type="Map">
<Option name="qgis:importintopostgis_1" type="Map">
<Option name="active" type="bool" value="true"/>
<Option name="alg_config"/>
<Option name="alg_id" type="QString" value="qgis:importintopostgis"/>
<Option name="color" type="QString" value=""/>
<Option name="comment" type="Map">
<Option name="color" type="QString" value=""/>
<Option name="component_description" type="QString" value=""/>
<Option name="component_height" type="double" value="60"/>
<Option name="component_pos_x" type="double" value="720"/>
<Option name="component_pos_y" type="double" value="231"/>
<Option name="component_width" type="double" value="100"/>
<Option name="outputs_collapsed" type="bool" value="true"/>
<Option name="parameters_collapsed" type="bool" value="true"/>
</Option>
<Option name="component_description" type="QString" value="Export to PostgreSQL"/>
<Option name="component_height" type="double" value="30"/>
<Option name="component_pos_x" type="double" value="520"/>
<Option name="component_pos_y" type="double" value="276"/>
<Option name="component_width" type="double" value="200"/>
<Option name="dependencies"/>
<Option name="id" type="QString" value="qgis:importintopostgis_1"/>
<Option name="outputs"/>
<Option name="outputs_collapsed" type="bool" value="true"/>
<Option name="parameters_collapsed" type="bool" value="true"/>
<Option name="params" type="Map">
<Option name="CREATEINDEX" type="List">
<Option type="Map">
<Option name="source" type="int" value="2"/>
<Option name="static_value" type="bool" value="true"/>
</Option>
</Option>
<Option name="DATABASE" type="List">
<Option type="Map">
<Option name="parameter_name" type="QString" value="EPSG demo"/>
<Option name="source" type="int" value="0"/>
</Option>
</Option>
<Option name="DROP_STRING_LENGTH" type="List">
<Option type="Map">
<Option name="source" type="int" value="2"/>
<Option name="static_value" type="bool" value="false"/>
</Option>
</Option>
<Option name="ENCODING" type="List">
<Option type="Map">
<Option name="source" type="int" value="2"/>
<Option name="static_value" type="QString" value="UTF-8"/>
</Option>
</Option>
<Option name="FORCE_SINGLEPART" type="List">
<Option type="Map">
<Option name="source" type="int" value="2"/>
<Option name="static_value" type="bool" value="false"/>
</Option>
</Option>
<Option name="GEOMETRY_COLUMN" type="List">
<Option type="Map">
<Option name="source" type="int" value="2"/>
<Option name="static_value" type="QString" value="geom"/>
</Option>
</Option>
<Option name="INPUT" type="List">
<Option type="Map">
<Option name="child_id" type="QString" value="qgis:postgisexecuteandloadsql_1"/>
<Option name="output_name" type="QString" value="OUTPUT"/>
<Option name="source" type="int" value="1"/>
</Option>
</Option>
<Option name="LOWERCASE_NAMES" type="List">
<Option type="Map">
<Option name="source" type="int" value="2"/>
<Option name="static_value" type="bool" value="true"/>
</Option>
</Option>
<Option name="OVERWRITE" type="List">
<Option type="Map">
<Option name="source" type="int" value="2"/>
<Option name="static_value" type="bool" value="true"/>
</Option>
</Option>
<Option name="PRIMARY_KEY" type="List">
<Option type="Map">
<Option name="source" type="int" value="2"/>
<Option name="static_value" type="QString" value=""/>
</Option>
</Option>
<Option name="SCHEMA" type="List">
<Option type="Map">
<Option name="source" type="int" value="2"/>
<Option name="static_value" type="QString" value="public"/>
</Option>
</Option>
<Option name="TABLENAME" type="List">
<Option type="Map">
<Option name="source" type="int" value="2"/>
<Option name="static_value" type="QString" value="out2"/>
</Option>
</Option>
</Option>
</Option>
<Option name="qgis:postgisexecuteandloadsql_1" type="Map">
<Option name="active" type="bool" value="true"/>
<Option name="alg_config"/>
<Option name="alg_id" type="QString" value="qgis:postgisexecuteandloadsql"/>
<Option name="color" type="QString" value=""/>
<Option name="comment" type="Map">
<Option name="color" type="QString" value=""/>
<Option name="component_description" type="QString" value=""/>
<Option name="component_height" type="double" value="60"/>
<Option name="component_pos_x" type="double" value="320"/>
<Option name="component_pos_y" type="double" value="115"/>
<Option name="component_width" type="double" value="100"/>
<Option name="outputs_collapsed" type="bool" value="true"/>
<Option name="parameters_collapsed" type="bool" value="true"/>
</Option>
<Option name="component_description" type="QString" value="PostgreSQL execute and load SQL"/>
<Option name="component_height" type="double" value="30"/>
<Option name="component_pos_x" type="double" value="238.5"/>
<Option name="component_pos_y" type="double" value="266.5"/>
<Option name="component_width" type="double" value="200"/>
<Option name="dependencies"/>
<Option name="id" type="QString" value="qgis:postgisexecuteandloadsql_1"/>
<Option name="outputs"/>
<Option name="outputs_collapsed" type="bool" value="true"/>
<Option name="parameters_collapsed" type="bool" value="true"/>
<Option name="params" type="Map">
<Option name="DATABASE" type="List">
<Option type="Map">
<Option name="parameter_name" type="QString" value="EPSG demo"/>
<Option name="source" type="int" value="0"/>
</Option>
</Option>
<Option name="GEOMETRY_FIELD" type="List">
<Option type="Map">
<Option name="source" type="int" value="2"/>
<Option name="static_value" type="QString" value="geom"/>
</Option>
</Option>
<Option name="ID_FIELD" type="List">
<Option type="Map">
<Option name="source" type="int" value="2"/>
<Option name="static_value" type="QString" value="id"/>
</Option>
</Option>
<Option name="SQL" type="List">
<Option type="Map">
<Option name="expression" type="QString" value="'SELECT * FROM ' || @Schemapublic || '.' ||@Demotableairports"/>
<Option name="source" type="int" value="3"/>
</Option>
</Option>
</Option>
</Option>
</Option>
<Option name="designerParameterValues" type="Map">
<Option name="Demotableairports" type="QString" value="communes"/>
<Option name="EPSG demo" type="QString" value="EPSG"/>
<Option name="Schemapublic" type="QString" value="public"/>
<Option name="VERBOSE_LOG" type="bool" value="true"/>
</Option>
<Option name="groupBoxes"/>
<Option name="help"/>
<Option name="modelVariables"/>
<Option name="model_group" type="QString" value=""/>
<Option name="model_name" type="QString" value="model"/>
<Option name="parameterDefinitions" type="Map">
<Option name="Demotableairports" type="Map">
<Option name="default" type="QString" value="airports2"/>
<Option name="defaultGui" type="invalid"/>
<Option name="description" type="QString" value="Demo table airports"/>
<Option name="flags" type="int" value="0"/>
<Option name="help" type="QString" value=""/>
<Option name="mAllowNewTableNames" type="bool" value="false"/>
<Option name="mParentConnectionParameterName" type="QString" value="EPSG demo"/>
<Option name="mParentSchemaParameterName" type="QString" value="Schemapublic"/>
<Option name="metadata"/>
<Option name="name" type="QString" value="Demotableairports"/>
<Option name="parameter_type" type="QString" value="databasetable"/>
</Option>
<Option name="EPSG demo" type="Map">
<Option name="default" type="QString" value="epsg"/>
<Option name="defaultGui" type="invalid"/>
<Option name="description" type="QString" value="EPSG demo"/>
<Option name="flags" type="int" value="2"/>
<Option name="help" type="QString" value=""/>
<Option name="metadata"/>
<Option name="name" type="QString" value="EPSG demo"/>
<Option name="parameter_type" type="QString" value="providerconnection"/>
<Option name="provider" type="QString" value="postgres"/>
</Option>
<Option name="Schemapublic" type="Map">
<Option name="default" type="QString" value="public"/>
<Option name="defaultGui" type="invalid"/>
<Option name="description" type="QString" value="Schema public"/>
<Option name="flags" type="int" value="0"/>
<Option name="help" type="QString" value=""/>
<Option name="mParentConnectionParameterName" type="QString" value="EPSG demo"/>
<Option name="metadata"/>
<Option name="name" type="QString" value="Schemapublic"/>
<Option name="parameter_type" type="QString" value="databaseschema"/>
</Option>
</Option>
<Option name="parameterOrder" type="StringList">
<Option type="QString" value="EPSG demo"/>
<Option type="QString" value="Demotableairports"/>
<Option type="QString" value="Schemapublic"/>
</Option>
<Option name="parameters" type="Map">
<Option name="Demotableairports" type="Map">
<Option name="color" type="QString" value=""/>
<Option name="comment" type="Map">
<Option name="color" type="QString" value=""/>
<Option name="component_description" type="QString" value=""/>
<Option name="component_height" type="double" value="60"/>
<Option name="component_pos_x" type="double" value="540"/>
<Option name="component_pos_y" type="double" value="15"/>
<Option name="component_width" type="double" value="100"/>
<Option name="outputs_collapsed" type="bool" value="true"/>
<Option name="parameters_collapsed" type="bool" value="true"/>
</Option>
<Option name="component_description" type="QString" value="Demotableairports"/>
<Option name="component_height" type="double" value="30"/>
<Option name="component_pos_x" type="double" value="682"/>
<Option name="component_pos_y" type="double" value="109.5"/>
<Option name="component_width" type="double" value="200"/>
<Option name="name" type="QString" value="Demotableairports"/>
<Option name="outputs_collapsed" type="bool" value="true"/>
<Option name="parameters_collapsed" type="bool" value="true"/>
</Option>
<Option name="EPSG demo" type="Map">
<Option name="color" type="QString" value=""/>
<Option name="comment" type="Map">
<Option name="color" type="QString" value=""/>
<Option name="component_description" type="QString" value=""/>
<Option name="component_height" type="double" value="60"/>
<Option name="component_pos_x" type="double" value="320"/>
<Option name="component_pos_y" type="double" value="15"/>
<Option name="component_width" type="double" value="100"/>
<Option name="outputs_collapsed" type="bool" value="true"/>
<Option name="parameters_collapsed" type="bool" value="true"/>
</Option>
<Option name="component_description" type="QString" value="EPSG demo"/>
<Option name="component_height" type="double" value="30"/>
<Option name="component_pos_x" type="double" value="116.5"/>
<Option name="component_pos_y" type="double" value="43.5"/>
<Option name="component_width" type="double" value="200"/>
<Option name="name" type="QString" value="EPSG demo"/>
<Option name="outputs_collapsed" type="bool" value="true"/>
<Option name="parameters_collapsed" type="bool" value="true"/>
</Option>
<Option name="Schemapublic" type="Map">
<Option name="color" type="QString" value=""/>
<Option name="comment" type="Map">
<Option name="color" type="QString" value=""/>
<Option name="component_description" type="QString" value=""/>
<Option name="component_height" type="double" value="60"/>
<Option name="component_pos_x" type="double" value="304.5"/>
<Option name="component_pos_y" type="double" value="67.5"/>
<Option name="component_width" type="double" value="100"/>
<Option name="outputs_collapsed" type="bool" value="true"/>
<Option name="parameters_collapsed" type="bool" value="true"/>
</Option>
<Option name="component_description" type="QString" value="Schemapublic"/>
<Option name="component_height" type="double" value="30"/>
<Option name="component_pos_x" type="double" value="350"/>
<Option name="component_pos_y" type="double" value="121"/>
<Option name="component_width" type="double" value="200"/>
<Option name="name" type="QString" value="Schemapublic"/>
<Option name="outputs_collapsed" type="bool" value="true"/>
<Option name="parameters_collapsed" type="bool" value="true"/>
</Option>
</Option>
</Option>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment