Tuflow

GPKG Time Series Format Specification: Difference between revisions

Browse history interactively
← Older editNewer edit →
Content deleted Content added
VisualWikitext
No edit summary
No edit summary
Line 2:
 
=== TUFLOW Time Series Version ===
An additional table called <Code>TUFLOW_timeseries_version</code> should be present in the GPKG. withThis table contains the version number of the TUFLOW GPKG time series format and should be set to <code>1.0.0</code>. The table should have the following columns:<br>
{| class="wikitable" style="width:40%"
! style="background-color:#005581; font-weight:bold; color:white;" width=20%| Column Name
Line 8:
! 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 ===
An additional table called <code>Timeseries_info</code> should be present in the GPKG. The purpose of this table is to list the available result types and relevant information for each type. The table should have the following columns:<br>
...
{| class="wikitable" style="width:50%"
! style="background-color:#005581; font-weight:bold; color:white;" width=15%| Column Name
! style="background-color:#005581; font-weight:bold; color:white;" width=15%| Type
! style="background-color:#005581; font-weight:bold; color:white;" width=70%| Description
|-
|row||INTEGER||Primary key
|-
|Table_name||TEXT||Reference to the GIS table that the result sits within
|-
|Count||INTEGER||Number of unique elements
|-
|Reference_time||TEXT||Reference time in the form of: <code>[UNITS] since YYYY-MM-DD hh:mm:ss</code>
|-
|dt||FLOAT||Output timestep (units defined in <code>Reference_time</code>)
|-
|Column_name||TEXT||Name of the column in the GIS table containing the result
|-
|Series_name||TEXT||Name of the result type
|-
|Series_units||TEXT||Result type units
|-
|}
 
===GIS Layers===
Line 19 ⟶ 41:
<br>
The column names of the GPKG layers should follow the convention below:<br>
{| class="wikitable" style="width:4050%"
! 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
Line 36 ⟶ 58:
|TimeId||INTEGER||Unique id for each timestep
|-
|Time_hoursTime_relative||FLOAT||Output relative time (reference time and units in hours<code>Timeseries_info</code>)
|-
|Datetime||DATETIME||Output time in datetime
Retrieved from "https://wiki.tuflow.com/GPKG_Time_Series_Format_Specification"