🗃

SpatiaLite (SQLite + spatial)

Open Beta

.sqlite · application/x-sqlite3

SpatiaLite는 SQLite를 위한 공간 확장입니다. 공간 질의, 인덱스, OGC 표준을 완전히 지원하는 간결한 단일 파일 데이터베이스 형식입니다.

지금 SpatiaLite 내보내기 ✨ 오픈 베타 — 무료, 제한 없음

주요 기능

✓하나의 파일에 전체 데이터베이스

✓공간 SQL 쿼리

✓공간 인덱스

✓SQLite 호환

Example SpatiaLite export (central Moscow, 1x0.5 km) — Example: central Moscow, ~1×0.5 km, medium detail

SpatiaLite 형식 소개

SpatiaLite is SQLite with a spatial extension: a single file database, no server, yet real SQL with geometry, spatial functions and indexes. The file is simply copied, put into a repository or onto a flash drive and works anywhere.

The format is taken when the data has to be computed with rather than admired: select buildings within a radius, sum up street length by type, join layers with a query, filter by an attribute. All of that is done with a query straight against the file, without deploying PostGIS.

What is inside: one database file where each OSM layer is a separate table with geometry and attributes; the service tables are filled in and spatial indexes are built at write time. The coordinates are WGS84 (EPSG:4326). QGIS opens the file by drag and drop, GDAL/OGR and Python read it directly.

About the neighbouring format: GeoPackage is also SQLite and also a single file, but it is an OGC standard and other people's software understands it better. SpatiaLite wins where you write the queries yourself and need its full set of spatial functions.

SpatiaLite 파일을 여는 프로그램

다음 프로그램과 애플리케이션으로 OSM2CDR에서 내보낸 SpatiaLite (SQLite + spatial)(.sqlite) 파일을 열고 편집하고 작업할 수 있습니다:

🌎QGIS 💻SpatiaLite GUI 💻DB Browser for SQLite 💻Python (sqlite3) 💻GDAL/OGR

Format specifications

Open standard
3D coordinates supported
Lossless (no quality loss)
Stores feature attributes
Output: 1 file
SpatiaLite .sqlite (open SQLite extension). Indexed spatial queries with R-Tree. Opens in QGIS, SpatiaLite GUI.

SpatiaLite 지도 사용자

🏗

로컬 GIS 분석

Spatial SQL queries straight against the file, with no database server to deploy.

💻

모바일 애플리케이션

A compact database for Android or iOS: SQLite is already in the system, and the map travels with the app.

📊

경량 데이터베이스

One file instead of a schema in PostGIS where there is not much data and simplicity matters more.

🎨

프로토타이핑

A quick test of a hypothesis on real data before building a full pipeline.

🗺

오프라인 작업

Data at hand without a network — the database sits on disk and does not depend on a connection.

SpatiaLite 내보내기 방법

영역 선택

osm2cdr.ru의 인터랙티브 지도에서 사각형 또는 폴리곤을 그리세요

SpatiaLite 선택

사용 가능한 127가지 내보내기 형식 목록에서 SpatiaLite (SQLite + spatial)을(를) 선택하세요

내보내기

내보내기를 클릭하면 1~5분 안에 .sqlite 파일을 받습니다

다운로드

완성된 SpatiaLite 파일을 다운로드하여 QGIS에서 여세요

내보낸 뒤 여는 방법

QGIS — drag the file into the program window or add it through the Data Source Manager; the tables will appear as ordinary layers.
DB Browser for SQLite — look through the tables and run a query; for spatial functions load the mod_spatialite module.
spatialite-gui and the console spatialite — the project's own tools: queries with spatial functions work out of the box.
Python — sqlite3 with mod_spatialite loaded for queries, or geopandas.read_file with the table you need given as the layer.
GDAL — ogr2ogr converts the database into GeoPackage and back with one command if another format turns out to be needed.

SpatiaLite 형식의 인기 지도

무료