Gist f2c843666c84195a872efebcc21f1f9f

100%

Gist f2c843666c84195a872efebcc21f1f9f

✓ Published0🌍 Public

Last edited Sep 25, 2021

Created on Sep 25, 2021

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.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 61afda568887fcc603e1f9ef963925ec

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.

TThomasG77

73% 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

66% 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

66% 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

65% 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

62% match

Loading thumbnail…

Gist 80f99a186a44e6fa1930f2a08618d498

This visualization displays a QGIS project containing world map layers—countries, states, provinces, and disputed borders—from the bundled `world_map.gpkg` GeoPackage, alongside JSON-derived point layers for contributors, hackfests, and user groups. Using the QGIS Python API, the script loads each vector layer via `QgsVectorLayer` with OGR drivers, adds them to the project through `QgsProject.instance().addMapLayers`, and enables a retro canvas style by setting `iface.mapCanvas().setProperty("retro", True)` before refreshing. The example demonstrates procedural map composition from built-in geodata files.

TThomasG77

62% 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

60% match

Loading thumbnail…

Multiple approaches to solve question at https://lists.osgeo.org/pipermail/gdal-dev/2022-June/055949.html

This example demonstrates three equivalent methods for converting a CSV file with latitude and longitude columns into a GeoPackage with point geometry using GDAL’s `gdal.VectorTranslate`, GeoPandas’ `read_file` and `to_file`, and Fiona’s manual schema definition and feature writing. The CSV contains a single data point (61, -150), and each approach specifies the coordinate column names via `X_POSSIBLE_NAMES` and `Y_POSSIBLE_NAMES` options. The code shows how to set the output CRS to EPSG:4326 and assign a layer name (`layername`) in the resulting GeoPackage.

TThomasG77

59% match