gacarrillor

    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' ) 

gacarrillor

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

gacarrillor

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

gacarrillor

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',

gacarrillor

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 

gacarrillor

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

gacarrillor

  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;

gacarrillor

Issue with models for opengis.ch

** REQUIREMENTS **:

Install the Asistente LADM_COL plugin to be able to use a custom model (LADM_COL:ETL-model).

MATERIALS:

gacarrillor

<!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"/>

gacarrillor

import sys

from qgis.core import (
     QgsApplication,
     QgsProcessingFeedback,
     QgsVectorLayer,
     QgsProperty
)

# On Linux, you need to prepare the environment with these variables: