GPKG Time Series Format Specification: Difference between revisions

Content deleted Content added
No edit summary
No edit summary
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
|-
|5||M06_5m_003_swmm_ts_L||18||hours since 2020-01-01 00:00:00||01.0833330||Velocity||Velocity||m/s
|-
|}
Line 90:
|-
|Velocity||FLOAT||Result velocity
|-
|}
<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 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
|-
|}