** REQUIREMENTS **:
Install the Asistente LADM_COL plugin to be able to use a custom model (LADM_COL:ETL-model).
MATERIALS:
def run(self): # Run method of a QGIS plugin | |
ruta="/tmp/" | |
# The plugin Maps Printer is required!!! | |
mp = qgis.utils.plugins['MapsPrinter'] | |
composer = self.iface.activeComposers()[0] # We'll only use the first composer | |
extension = '.png' | |
# Get the group to start iterating layers (making only 1 layer visible at a time) | |
group = QgsProject.instance().layerTreeRoot().findGroup( 'DEPTOS' ) |
def ogrLayerName(uri): | |
""" Returns layer name suitable for Gdal/OGR commands | |
""" | |
fields = uri.split('|') | |
ogruri = fields[0] | |
fields = fields[1:] | |
layerid = 0 | |
for f in fields: | |
if f.startswith('layername='): | |
# Name encoded in uri, nothing more needed |
SELECT | |
tbls.schemaname AS schemaname, | |
tbls.tablename AS tablename, | |
a.attname AS primary_key, | |
g.f_geometry_column AS geometry_column, | |
g.srid AS srid, | |
g.type AS type, | |
(cols.column_name = 'ilicode') AS isdomain | |
FROM pg_catalog.pg_tables tbls | |
LEFT JOIN pg_index i |
import re | |
import glob | |
ilifile = '/docs/tr/ai/productos/curso_interlis_mayo_2017/ejercicio_3er_dia/modelos/LADM-OT-discusion.ili' #Catastro_COL_ES_V_2_0_20170331.ili' | |
domains = [ | |
'Catastro_COL_ES_V_2_0_20170331.COL_Genero', | |
'Catastro_COL_ES_V_2_0_20170331.COL_InteresadoDocumentoTipo', | |
'Catastro_COL_ES_V_2_0_20170331.COL_InteresadoDocumentoTipo', | |
'Catastro_COL_ES_V_2_0_20170331.COL_UsoTipo', | |
'documentoOTTipo', |
src/providers/postgres/qgspostgresconn.cpp: 214: (QgsPostgresConn) [0ms] New PostgreSQL connection for dbname='test' host=localhost user='postgres' password='postgres' | |
src/providers/postgres/qgspostgresconn.cpp: 280: (QgsPostgresConn) [60ms] setting client encoding to UNICODE | |
src/providers/postgres/qgspostgresconn.cpp: 284: (QgsPostgresConn) [0ms] encoding successfully set | |
src/providers/postgres/qgspostgresconn.cpp: 295: (QgsPostgresConn) [0ms] Connection to the database was successful | |
src/providers/postgres/qgspostgresconn.cpp: 1378: (deduceEndian) [1ms] Creating binary cursor | |
src/providers/postgres/qgspostgresconn.cpp: 1383: (deduceEndian) [1ms] Fetching a record and attempting to get check endian-ness | |
src/providers/postgres/qgspostgresconn.cpp: 1393: (deduceEndian) [0ms] Got oid of 1259 from the binary cursor | |
src/providers/postgres/qgspostgresconn.cpp: 1394: (deduceEndian) [0ms] First oid is 1259 | |
src/providers/postgres/qgspostgresconn.cpp: 852: (postgisVersion) [475ms] PostGIS version info: 2.3 USE_GEOS=1 |
while ( featureIt != features.constEnd() ) | |
{ | |
QgsAttributes srcAttr = featureIt->attributes(); | |
QgsAttributeMap dstAttr; | |
for ( int src = 0; src < srcAttr.count(); ++src ) | |
{ | |
int dst = remap.value( src, -1 ); | |
if ( dst < 0 ) | |
continue; |
germap@germap-pc /docs/dev/LADM_COL $ java -jar /docs/downloads/software/ili2gpkg-3.10.5/ili2gpkg.jar --schemaimport --dbfile /docs/borrar/gpkg/ladm_col16.gpkg --createFk --trace /docs/dev/LADM_COL/Catastro_COL_ES.ili | |
Info: dburl <jdbc:sqlite:/docs/borrar/gpkg/ladm_col16.gpkg> | |
Info: dbusr <> | |
Info: postConnect(): PRAGMA application_id=1196437808; (ch.ehi.ili2gpkg.GpkgMapping) | |
Info: postConnect(): CREATE TABLE gpkg_spatial_ref_sys ( srs_name TEXT NOT NULL, srs_id INTEGER NOT NULL PRIMARY KEY, organization TEXT NOT NULL, organization_coordsys_id INTEGER NOT NULL, definition TEXT NOT NULL, description TEXT); (ch.ehi.ili2gpkg.GpkgMapping) | |
Info: postConnect(): INSERT INTO gpkg_spatial_ref_sys ( srs_name, srs_id, organization, organization_coordsys_id, definition) VALUES ('WGS-84', 4326, 'EPSG', 4326, 'GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["E |
<!DOCTYPE model> | |
<Option type="Map"> | |
<Option name="children" type="Map"> | |
<Option name="qgis:basicstatisticsforfields_1" type="Map"> | |
<Option name="active" type="bool" value="true"/> | |
<Option name="alg_config"/> | |
<Option name="alg_id" type="QString" value="qgis:basicstatisticsforfields"/> | |
<Option name="component_description" type="QString" value="Basic statistics for fields"/> | |
<Option name="component_pos_x" type="double" value="741"/> | |
<Option name="component_pos_y" type="double" value="494"/> |
import sys | |
from qgis.core import ( | |
QgsApplication, | |
QgsProcessingFeedback, | |
QgsVectorLayer, | |
QgsProperty | |
) | |
# On Linux, you need to prepare the environment with these variables: |