GeoPackage — Aspatial Attributes Table (no geometry column)
A GeoPackage holding an `attributes` table with no geometry at all — the standard's own answer to a lookup table you want to ship alongside your layers. Its gpkg_contents row has null bounds and a null SRS, which is what readers that assume every row is spatial trip over.
| code | year | population | households |
|---|---|---|---|
| KB | 2011 | 4386 | 1827 |
| KB | 2021 | 4820 | 2051 |
| MR | 2011 | 1073 | 447 |
| MR | 2021 | 1180 | 502 |
| HW | 2011 | 2429 | 1012 |
| HW | 2021 | 2670 | 1136 |
Specifications
- Format
- OGC GeoPackage 1.3 (SQLite)
- Application Id
- GPKG (0x47504B47)
- User Version
- 10300
- Feature Tables
- 0
- Attribute Tables
- 1
- Rows
- 10
- Data Type
- attributes
- Geometry Columns
- 0
- Bounding Box
- null (aspatial content has no extent)
- Last Change
- 2026-01-01T00:00:00.000Z (fixed for reproducibility)
Testing contract
Expected to pass- Scenario
- Open the file with a GIS client and list its contents.
- Expected result
- The census table is listed as aspatial with 10 rows and no geometry column; the null bounding box and null srs_id do not raise, and the file is not reported as empty.
What is a .gpkg file?
GeoPackage is an OGC standard that stores vector features, raster tiles, and their metadata inside a single SQLite database. Required tables such as gpkg_contents, gpkg_spatial_ref_sys, and gpkg_geometry_columns describe what the file holds, and feature geometries are stored in a standard binary header followed by Well-Known Binary. Being one self-contained file with real SQL indexing, it is the modern replacement for the multi-file shapefile.
How to use this file
Use an example .gpkg file to test GIS readers, SQLite-based spatial tooling, and shapefile-to-GeoPackage converters, checking the required metadata tables, the geometry header's SRS id and envelope flags, and attribute round-tripping.
How to use this file for testing
“GeoPackage — Aspatial Attributes Table (no geometry column)” is a deterministic Novus Examples fixture for Geospatial, Data import, Conversion testing. GeoJSON, GPX, and KML files with points, lines, polygons, and tracks — for testing map tools, route parsers, and geo importers.
Documented properties for this file: 10 rows · OGC GeoPackage 1.3 (SQLite). Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such — expect parsers to fail loudly rather than silently accept them.
Geospatial fixtures publish one invented territory across formats, with the coordinate reference system and feature counts documented in specs. Convert or reproject and diff against the twin in the same group; edge-case geometries state exactly which assumption they are built to break.
Related files
- gpxGPX — Route (rte) Rather Than a TrackA `rte` element: an ordered list of waypoints describing a planned route, with no timestamps because it has not been travelled yet. Many importers only look for `trk` and report this perfectly valid file as empty.
- gpxGPX — Standalone Waypoints OnlyFive `wpt` elements for the towns of the territory, with names, symbols and descriptions but no track or route. It is the GPX equivalent of a point layer, and the third of the three top-level GPX content types.
- osmKestrel Bay Territory — OpenStreetMap XML TwinThe towns and roads in OSM XML: tagged nodes, three highway ways sharing the junction node at Kestrel Bay, and a route relation over them. All object IDs are negative — the convention for objects that have never been uploaded — so nothing here can be mistaken for real OSM data.
- kmlKML — LineString Placemarks With tessellateThe three roads as LineString Placemarks with `tessellate` set, which tells a globe renderer to drape the line over terrain rather than drawing it as a straight chord. Converters that drop the flag produce lines that tunnel through hills.
- kmlKML — Point Placemarks With DescriptionsFive town Placemarks with plain-text descriptions and no styling — the smallest useful KML and the baseline for the rest of this subcategory. Coordinates match the master territory, so a KML-to-GeoJSON conversion can be diffed against a known answer.
- kmzKMZ — Bundled Icon Referenced by a Relative PathA KMZ whose style points at `files/markers/town.png` inside the same archive. Resolving that relative href against the archive rather than the filesystem is the whole job of a KMZ reader, and it is where extract-then-parse implementations break.
Generated by generation/geospatial.py. Free for any use, no attribution required — license.