100%

Execute Spatialite within Node.js

✓ Published0🌍 Public

Last edited Feb 2, 2024

Created on Feb 2, 2024

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.

AI-generated description

Execute Spatialite within Node.js

git clone https://gist.github.com/e559fb6f37ed8f8c6d97b6f8b94bf9db.git spatialite-node-sample
cd spatialite-node-sample
npm i
node index.js

ISC Licensed

Similar vizzes

Loading thumbnail…

Play with gdal.vectorTranslate in Node.js

This example demonstrates a complete geospatial data processing pipeline using the Node.js `gdal-async` library. It downloads a Natural Earth countries dataset, extracts the ZIP archive, and converts the shapefile to GeoPackage format with `gdal.vectorTranslate`, then transforms the GeoPackage into GeoJSON. The script uses the `got` library for HTTP streaming with progress reporting and `adm-zip` for extraction. This showcases how GDAL's vector translation capabilities can be invoked programmatically in a Node.js environment for format conversion between common geospatial file types.

TThomasG77

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

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…

just a bookmark of random psql queries.

This example visualizes spatial relationships between neighborhoods, city blocks, and demographic data in Portland and Laurelhurst through a series of SQL queries. The code shows how geographic joins and intersections are performed using PostGIS functions like `ST_Intersects`, combining building footprints, block polygons, and census block-group data. The queries calculate race-based percentages, such as percent white and percent black, from census fields like `h7x002` and `h7x003`, while filtering for specific places and positive population counts. The gist demonstrates iterative query building for choropleth-style analysis, revealing how raw geographic and tabular data are merged to support subsequent mapping or charting in a visualization tool.

CCaged

56% match

Loading thumbnail…

Query remote Geoparquet in browser

This example demonstrates querying a remote GeoParquet file directly from a web browser using DuckDB-Wasm. The interactive map displays French priority neighborhoods (QPVs) and identifies which one contains a specific geographic point (2.389798, 48.909514). It uses DuckDB-Wasm’s SQL engine with the spatial extension to run an `ST_contains` query, filtering results by geometric intersection. The workflow converts the matched polygons to GeoJSON via the GDAL driver and exports them as a downloadable file. The dataset was prepared from a government GeoJSON source using DuckDB and gpio utilities.

TThomasG77

55% match

Loading thumbnail…

[Working with spatial data](https://github.com/enjalot/wwsd)

This example demonstrates how to work with geospatial data using d3.js projections, visualizing trail points from a GeoJSON file on a Mercator projection. The code uses the d3.geo.path() function with a d3.geo.mercator() projection to render SVG paths, and employs d3.json() to load the data. The map displays points with a transform applied, while path elements are styled with a gray fill and white stroke that turn red on hover.

SSwampGuzzler

55% match

Loading thumbnail…

[Working with spatial data](https://github.com/enjalot/wwsd)

This example displays a world map using Leaflet with an OpenStreetMap tile layer, overlaid with country boundaries from a GeoJSON file. The visualization begins by initializing a Leaflet map centered on coordinates [30, 0] at zoom level 2. The code then loads geographic data from a static GeoJSON URL hosted on GitHub and adds it to the map via `L.geoJson()`. The integration uses Leaflet 0.7.7 alongside D3 3.5.5 for fetching the remote JSON data, demonstrating a straightforward workflow for combining interactive map tiles with custom spatial datasets.

KKristinHenry

55% match

Loading thumbnail…

Gist 28a1d2e30c530c6a170ff5f68798b235

This example curates a set of GeoJSON-based specifications and extensions, organizing them by how they add keys, use multiple files, or serialize for streaming. It lists linked resources such as geojson-t, geocodejson-spec, geojson-ld, and the OGC Features API, alongside STAC and Mapbox simplestyle. It also covers the IMDF format for indoor data and the GeoJSON Text Sequences proposal, presenting a structured reference rather than a rendered map or interactive chart, with no code libraries or visualization APIs involved.

TThomasG77

54% match