Gist 1aa1bf66d847be043a246df8bf74793e

100%

Gist 1aa1bf66d847be043a246df8bf74793e

✓ Published0🌍 Public

Last edited Aug 24, 2021

Created on Aug 24, 2021

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.

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

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

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

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

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

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

63% match

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

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

59% match