Data file structure » Historie » Revize 8
Revize 7 (Alex Konig, 2021-05-12 13:46) → Revize 8/12 (Alex Konig, 2021-05-12 14:24)
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: following All data is contained its an object in one object, in this object it are at least two arrays labeled as following: * "current_condition" * "weather" h3. Current condition in array current_condition - one object - in it is ... In this in array is weather - one object that contains -- array "astronomy" - in it one object -> -- date -- array hourly - 8 objects, with predictions --- in those ... Under the hearder "current_condition" is the information about current weather: weather. It needs to contain the following information: * 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 One object with "sunrise":"05:27 AM", "sunset":"08:37 PM" h4. Hourly 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 predictions, each for 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", 00:00 -> first two taken as hour) * temperatur ("tempC": "6") * percentage of cloud coverage ("cloudcover": "95") * wind speed ("WindGustKmph": "10") * probability of rain ("chanceofrain": "88")