GPKG Time Series Format Specification: Difference between revisions

Content deleted Content added
No edit summary
No edit summary
 
(6 intermediate revisions by 2 users not shown)
Line 1:
The below sectionsections describe the TUFLOW GPKG time series format specification. The specification sitsis build ontop of the <b><u>[https://www.geopackage.org/spec120/index.html GPKG v1.2 Specification]</u></b> with two additional required tables. The additional tables and details of the GIS layers are descibeddescribed below with examples. The examples are based a the 1D/2D linked TUFLOW-SWMM example model based on TUFLOW's module 6 tutorial model 6 - <b>M06_5m_003.tcf</b>.
 
=== TUFLOW Time Series Version ===
Line 37:
|}
<br>
<b>Example <code>Timeseries_info</code></b><br>
{| class="wikitable" style="width:70%"
! style="background-color:#005581; font-weight:bold; color:white;" width=5%| Row
Line 48:
! style="background-color:#005581; font-weight:bold; color:white;" width=5%| Series_units
|-
|1||M06_5m_003_swmm_ts_P||22||hours since 2020-01-01 00:00:00||01.0833330||Depth||Depth||m
|-
|2||M06_5m_003_swmm_ts_P||22||hours since 2020-01-01 00:00:00||01.0833330||Water Level||Water Level||m
|-
|3||M06_5m_003_swmm_ts_P||22||hours since 2020-01-01 00:00:00||01.0833330||Storage Volume||Storage Volume||m3
|-
|4||M06_5m_003_swmm_ts_L||18||hours since 2020-01-01 00:00:00||01.0833330||Flow||Flow||cms
|-
|45||M06_5m_003_swmm_ts_L||18||hours since 2020-01-01 00:00:00||01.0833330||Velocity||Velocity||m/s
|-
|}
Line 92:
|-
|}
<Br>
The GIS layer should contain a feature for each applicable element and timestep i.e. the same pipe may be referenced 10 times if there are 10 output timesteps. The order should be ascending based on the output time.<Br>
<b>Example <code>M06_5m_003_swmm_ts_L</code> with three output timesteps and three culverts</b><Br>
{| class="wikitable" style="width:70%"
! style="background-color:#005581; font-weight:bold; color:white;" width=5%| fid
! style="background-color:#005581; font-weight:bold; color:white;" width=10%| geometry
! style="background-color:#005581; font-weight:bold; color:white;" width=15%| ID
! style="background-color:#005581; font-weight:bold; color:white;" width=10%| Type
! style="background-color:#005581; font-weight:bold; color:white;" width=10%| Source
! style="background-color:#005581; font-weight:bold; color:white;" width=5%| TimeId
! style="background-color:#005581; font-weight:bold; color:white;" width=10%| Time_relative
! style="background-color:#005581; font-weight:bold; color:white;" width=15%| Datetime
! style="background-color:#005581; font-weight:bold; color:white;" width=10%| Flow
! style="background-color:#005581; font-weight:bold; color:white;" width=10%| Velocity
|-
|1||LINESTRING||FC01.1_R||CONDUITS||SWMM||1||1.0||2020-01-01T01:00:00Z||52.313579||5.3814558
|-
|2||LINESTRING||FC01.2_R||CONDUITS||SWMM||1||1.0||2020-01-01T01:00:00Z||66.050522||4.5863313
|-
|3||LINESTRING||FC04.1_C||CONDUITS||SWMM||1||1.0||2020-01-01T01:00:00Z||0.5314214||2.1729025
|-
|1||LINESTRING||FC01.1_R||CONDUITS||SWMM||2||2.0||2020-01-01T02:00:00Z||19.547256||2.2898435
|-
|2||LINESTRING||FC01.2_R||CONDUITS||SWMM||2||2.0||2020-01-01T02:00:00Z||50.088657||3.4779915
|-
|3||LINESTRING||FC04.1_C||CONDUITS||SWMM||2||2.0||2020-01-01T02:00:00Z||0.6140663||2.2505249
|-
|1||LINESTRING||FC01.1_R||CONDUITS||SWMM||3||3.0||2020-01-01T03:00:00Z||3.1847720||1.4646966
|-
|2||LINESTRING||FC01.2_R||CONDUITS||SWMM||3||3.0||2020-01-01T03:00:00Z||7.6079978||0.5282743
|-
|3||LINESTRING||FC04.1_C||CONDUITS||SWMM||3||3.0||2020-01-01T03:00:00Z||0.1079226||1.4705778
|-
|}
 
<br><br>
{{Tips Navigation
|uplink=[[TUFLOW_Viewer#GPKG_Time_Series_Format| Back to TUFLOW Viewer Main Page]]
}}