Difference between revisions of "GPKG Time Series Format Specification"
Ellis Symons (talk | contribs) |
Ellis Symons (talk | contribs) |
||
| Line 2: | Line 2: | ||
=== TUFLOW Time Series Version === | === TUFLOW Time Series Version === | ||
| − | An additional table called <Code>TUFLOW_timeseries_version</code> | + | An additional table called <Code>TUFLOW_timeseries_version</code> should be present in the GPKG with the following columns:<br> |
| + | {| class="wikitable" style="width:40%" | ||
| + | ! style="background-color:#005581; font-weight:bold; color:white;" width=20%| Column Name | ||
| + | ! style="background-color:#005581; font-weight:bold; color:white;" width=20%| Type | ||
| + | ! style="background-color:#005581; font-weight:bold; color:white;" width=60%| Description | ||
| + | |- | ||
| + | |Version||TEXT||Major.Minor.Patch version number (e.g. 1.0.0) | ||
| + | |- | ||
| + | |} | ||
=== Time Series Info === | === Time Series Info === | ||
Revision as of 02:35, 10 November 2023
The below section lists the TUFLOW GPKG time series format specification. The specification sits ontop of the GPKG v1.2 Specification with two additional required tables. The below lists the details of the additional tables with examples. The examples are based a the 1D/2D linked TUFLOW-SWMM example model based on TUFLOW's module 6 tutorial model - M06_5m_003.tcf.
TUFLOW Time Series Version
An additional table called TUFLOW_timeseries_version should be present in the GPKG with the following columns:
| Column Name | Type | Description |
|---|---|---|
| Version | TEXT | Major.Minor.Patch version number (e.g. 1.0.0) |
Time Series Info
...
GIS Layers
The results are stored in GPKG layers, typically between 1 - 3 layers are stored in the result file depending on the output (one for point results, one for line results, one for polygon results). There is no requirement against storing results from multiple model runs in a single GPKG, this is just not typically how outputs are written.
The column names of the GPKG layers should follow the convention below:
| Column Name | Type | Description |
|---|---|---|
| fid | INTEGER | Primary key |
| geometry | GEOMETRY | GeoPackage Geometry |
| ID | TEXT | Element ID (e.g. Pipe1) |
| Type | TEXT | Element Type (e.g. CONDUIT) |
| Source | TEXT | Result Source (e.g. SWMM) |
| TimeId | INTEGER | Unique id for each timestep |
| Time_hours | FLOAT | Output time in hours |
| Datetime | DATETIME | Output time in datetime |
| ...[column for each result type for that given geometry type - examples below] | ||
| Flow | FLOAT | Result flow |
| Velocity | FLOAT | Result velocity |