cityjson

Search Shortcut cmd + k | ctrl + k

Documentation

cityjson

Downloads 650this week

GitHub stars 4

Extension repository on GitHub

Extension descriptor (YAML)

Read, write, and query CityJSON, CityJSONSeq, and FlatCityBuf 3D city model files.

Maintainer(s): HideBa

Installing and Loading

INSTALL cityjson FROM community;
LOAD cityjson;

Example

-- Read a CityJSON file
SELECT * FROM read_cityjson('buildings.city.json');

-- Read a CityJSONSeq (line-delimited) file
SELECT * FROM read_cityjsonseq('buildings.city.jsonl');

-- Read a FlatCityBuf file
SELECT * FROM read_flatcitybuf('buildings.fcb');

-- Extract geometries as WKB at a specific Level of Detail
SELECT * FROM read_cityjson('buildings.city.json', lod=>'1.2');

-- Write query results to CityJSONSeq
COPY (SELECT * FROM read_cityjson('buildings.city.json'))
  TO 'output.city.jsonl' (FORMAT cityjsonseq);

-- Inspect file metadata
SELECT * FROM cityjson_metadata('buildings.city.json');

The CityJSON extension provides table functions for reading and writing 3D city model files in CityJSON (.city.json), CityJSONSeq (.city.jsonl), and FlatCityBuf (.fcb) formats. CityJSON is a JSON-based encoding for 3D city models (buildings, terrain, vegetation, etc.) based on the CityGML data model.

Supported functions:

read_cityjson, read_cityjsonseq, read_flatcitybuf — table functions for querying city objects
cityjson_metadata, cityjsonseq_metadata, flatcitybuf_metadata — inspect file headers
COPY ... TO with formats cityjson, cityjsonseq, and flatcitybuf — write query results