JSONL is a text-based format using the .jsonl file extension that is basically the same as JSON format but implemented using newline characters to separate JSON values. It is also known as JSON Lines. Manifold can import and link JSONL files. Manifold can also export tables to JSONL files. JSONL is used in GeoJSONL format.
A JSONL file contains a single table.
Reading a JSONL file parses it dynamically one line at a time, which is useful for working with very large files on machines with limited memory.
Each individual line must be no larger than 2 GB, but the file itself can be of any size.
There are three key differences between JSON format and JSONL format:
JSONL uses UTF-8 encoding. That is different from JSON, which allows encoding Unicode strings using ASCII escape sequences.
Each line is a valid JSON value.
Each line is separated with a newline, '\n', character. This means a carriage return, newline sequence, '\r\n', is also supported because surrounding white space is implicitly ignored when parsing JSON values. The last character in the file may be a line separator, and it will be treated the same as if there was no line separator present.
Manifold can export tables to JSONL. Binary fields are ignored and are not exported.
Please read the JSON topic for important information about JSON format and Manifold that, with one key difference in addition to the above, applies to JSONL format as well. The key difference between JSON and JSONL when importing files is that an entire JSON file can be no larger than 2 GB, while there is no limit on the size of a JSONL file so long as any single line within the file is no larger than 2 GB.
File - Import
File - Create - New Data Source
Example: Import GeoJSON File - Import vector footprints for all buildings in the District of Columbia, using a GeoJSON file published as open data by Microsoft.