Data file structure » Historie » Revize 11
Revize 10 (Alex Konig, 2021-05-12 14:26) → Revize 11/12 (Alex Konig, 2021-05-12 14:34)
h1. Data file structure
Application works with input data files in .csv format. In the following paragraphs is described what can be expected in one line of file.
h2. Weather data
Sample line from data file
"03.06.2019 09:15:48";23.5;.4;0;76.1
* index 0 - date time
* index 1 - temperature in °C
* index 2 - wind in m/s
* index 3 - rain (values 0 or 1)
* index 4 - luminance in k lux
h2. Jis data
Sample line from data file
"Zavora-FEL";"01.06.2019 00:02:45";1
* index 0 - place tag
* index 1 - date time
* index 2 - recorded amount of interactions
h2. WebAuth data
Sample line from data file
"01.12.2019 00:00:00";4;2;"08:25";"09:10";"UL";"Laboratoř";"UL-109";"ul109p01-kks"
* index 0 - date (time is always 00:00:00)
* index 1 - recorded amount of logins
* index 2 - lesson
* index 3 - lesson start time
* index 4 - lesson end time
* index 5 - building tag
* index 6 - room type
* index 7 - room
* index 8 - computer
h2. Weather prediction data
Weather prediction data is a json file format. The expected format is following:
All data is contained in one object, in this object are at least two arrays labeled as following:
* "current_condition"
* "weather"
h3. Current condition
In this array is one object that contains information about current weather:
* temprerature ("FeelsLikeC": "14")
* percentage of cloud coverage ("cloudcover": "75")
* wind speed ("windspeedKmph": "9")
h3. Weather
In this array are three objects, each one contains weather prediction for one day. Each one of those objects contains the following:
* array "astronomy"
* date ("date":"2021-05-12")
* array hourly
h4. Astronomy
In this array is one object that contains the following data
* time of sunrise ("sunrise":"05:27 AM")
* time of sunset ("sunset":"08:37 PM")
h4. Hourly
In this array with 8 objects, with predictions
Furhter in the file under the header "weather" needs to awlays be a date ("date": "2021-05-01") after which follows the value "hourly", in which is stored an array with weather predictions.
Each day there are 8 objects, predictions, each contains the prediction for one specific time interval. Specifically different starting time, specifically for times 0:00, 3:00, 6:00, 9:00, 12:00, 15:00, 18:00, 21:00.
There are 3 days weather predictions written out like this: today, tommorrow and the day after tommorrow.
Each of this hourly data must contain:
* time ("time": "0000", which is translated to 00:00, 00:00 -> first two numbers taken as the hour value) hour)
* temperature temperatur ("tempC": "6")
* percentage of cloud coverage ("cloudcover": "95")
* wind speed ("WindGustKmph": "10")
* probability of rain ("chanceofrain": "88")