Gist 61afda568887fcc603e1f9ef963925ec

100%

Gist 61afda568887fcc603e1f9ef963925ec

✓ Published0🌍 Public

Last edited Jul 2, 2021

Created on Jul 2, 2021

This example demonstrates a QGIS Processing model that exports spatial data to a PostgreSQL/PostGIS database. The model chains two algorithms: `qgis:postgisexecuteandloadsql` to run SQL and load the result, followed by `qgis:importintopostgis` to write the output to a table named "out2" in the public schema. It uses the PostgreSQL connection "EPSG demo," sets UTF-8 encoding, and creates a geometry column. The model shows a reusable workflow for automating database ingestion directly from the QGIS Processing framework.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist f2c843666c84195a872efebcc21f1f9f

This PyQGIS script exports the column metadata of an active PostgreSQL layer to a CSV file. It shows the structure of every column, including data type, nullability, precision, defaults, and comments from the `information_schema.columns` view. Working within QGIS, it uses `QgsProviderRegistry` to create a PostgreSQL connection, executes the query via `executeSql`, sanitizes null `QVariant` values, and writes the results with Python’s `csv` module. The final CSV file is then added back to the map as a vector layer.

TThomasG77

73% match

Loading thumbnail…

Gist 2bd25e856943977444bac9a5fd8c6408

This example shows a QGIS workflow for automatically populating the application with WMS, WMTS, and WFS service connections from the French IGN geoservices portal. The script scrapes the portal’s documentation page to find a CSV file containing service metadata, parses it using the `csv` module, and deduplicates entries via Python dictionaries. It then defines functions to add or remove connections in QGIS’s settings using `QgsSettings`, configuring parameters like URLs, versions, and axis orientation. The code demonstrates a practical approach to batch-importing OGC web services into a desktop GIS environment.

TThomasG77

68% match

Loading thumbnail…

OGR and QGIS MySQL recipes

This example demonstrates how to convert non-spatial MySQL/MariaDB tables with x/y coordinates into viewable vector layers in QGIS. It shows three approaches: using OGR’s SQLite dialect with the `MakePoint` function, using MySQL’s native `ST_PointFromText` function, and creating a geometry column directly in the database. The code uses `ogrinfo`, `ogr2ogr`, and VRT files to bridge GDAL with MySQL, while the final workflow includes loading CSV data through the command line before exporting to the database.

TThomasG77

67% match

Loading thumbnail…

Gist ab738ee0d721842fbea501cc96296160

This example demonstrates how to load and manage LiDAR point cloud layers in QGIS using Python, showing both automatic and manual index generation for LAZ files from the French IGN LIDAR HD dataset. It uses the QgsPointCloudLayer class with the PDAL provider, QgsProject for layer management, and QgsPointCloudDataProvider to check indexing state, generate indexes, and retrieve polygon bounds, point counts, and renderer information. The script also prints coordinate reference system details and renderer type, illustrating direct provider-level access to point cloud metadata.

TThomasG77

62% match

Loading thumbnail…

Load GTFS as GPKG with GDAL 3.7

This example demonstrates converting an IDFM GTFS transit feed into a GeoPackage database using GDAL’s new GTFS driver. The Bash script first checks that GDAL 3.7 is installed, then uses `ogrinfo` with `-json` to list all available layers. For each layer, it runs `ogr2ogr` with the GeoPackage format, appending layers incrementally with the `-update` flag. The source data is loaded directly from a URL via `/vsicurl/`, and the script allows customizing input and output names through environment variables.

TThomasG77

62% match

Loading thumbnail…

Gist 56db21b335e25668ff86c2e8359bf3d1

This example visualizes tree inventory data from a CSV file, mapping each tree’s location as a point based on longitude and latitude coordinates. The data includes attributes such as species, planting date, height, and diameter. The implementation uses a VRT file to define the CSV’s geometry, with the QGIS XML configuration specifying the point layer’s symbology and coordinate system. The visualization is rendered through QGIS, leveraging the OGR provider to read the spatial data and display it as a map layer with a single symbol renderer.

TThomasG77

61% match

Loading thumbnail…

Gist 1aa1bf66d847be043a246df8bf74793e

This example demonstrates how to load multiple CSV files containing Chinese-character field names as spatial layers in QGIS. The script uses the PyQGIS API, specifically `QgsVectorLayer` with the `delimitedtext` provider, to parse longitude and latitude columns named 經度 and 緯度. It iterates through all CSV files in a directory using Python’s `glob` and `os` modules, constructs a URI with URL encoding via `urllib.parse.quote`, and adds each resulting point layer to the project with `QgsProject.instance().addMapLayer`. The sample data shows simple occurrence records with coordinates.

TThomasG77

61% match

Loading thumbnail…

Execute Spatialite within Node.js

This example demonstrates how to execute SpatiaLite spatial operations within a Node.js application using the `sqlite3` database driver in memory. The code initializes a spatial metadata table, creates a point geometry column with EPSG 4326 projection, and adds a spatial index to a `places_spatialite` table. It then inserts a sample point using `GeomFromText` and queries the table with `db.each`, logging the resulting rows. The workflow relies on `db.loadExtension` to load the native `mod_spatialite` library, with the extension path hard-coded for Linux systems.

TThomasG77

61% match