Data from the street light system of Tampere including electricity consumption,
ambient illuminance data and door sensor data. There are 3 different control
cabinets and 317 different street light groups which together manage about 40000
streetlights. Each control cabinet provides illuminance measurements. The data
also contains the limit values at which the streetlights are supposed to turn on
or off. These limits can be different for each control cabinet. Each street
light group provides electric current and voltage
measurements. The electrical data is given separately for each of the three
phases. The door sensor data relates to the street light groups. The data also
contains information on which control cabinet controls which street light group
(each street light group can have either 1 or 2 control cabinets). See the
CityIoT project for
general information about how the measurements are stored and can be used.
Data model
The FIWARE entity types used in this data set are from the
device,
weather
and street
lighting
data models. However, some changes had to be made to the entity attributes to
fit them to the original data. The following entity types are used.
- StreetlightControlCabinet:
Controllers of the street light groups. IlluminanceOn and IlluminanceOff
attributes were added to this type to represent the values when the street
lights should be turned on and off.
- StreetlightGroup:
Represents a group of street lights. In this data set contains the electrical
measurements which in the original data model are part of the control cabinet.
- device:
Used to represent door sensors and illuminance sensors. The illuminance sensors
are related to control cabinets and the door sensors to street light groups. As
a change from the standard device data model, The
owner attribute is used to model these relationships.
- WeatherObserved:
Is used to model the illuminance measurements from the control cabinets.
Notes about the data
- The data was originally stored in a different database system with its own
data model. From there, it was then transferred and converted to the CityIoT platform.
- In the original data, locations were given only as street addresses. For this
data set, the free service https://nominatim.openstreetmap.org/ was used to
get the corresponding latitude and longitude coordinates.
- The illuminance data contained only measurement values close to the point when
the streetlights were supposed to turn on or off. This means that there is no
measurements from midday or midnight. This was intentional by the data
provider, since the data was originally meant to test whether the streetlight
control system worked properly.
- Time resolution for illuminance measurements is about 4 minutes. For the
electrical intensity it is 2 or 3 hours, though there can be cases where
measurements for one phase are reported first then few minutes after there are
measurements for the other phases, for example. Voltage is reported only couple
times a day.
- UTC time is used with the timestamps.
Accessing the data
The data is stored in the Tampere University CityIoT platform. The used FIWARE
service is streetlight and all entities there are under the service path
/Tampere.
Examples
find out the streetlight group entity ids which has KV-0446 as a controller cabinet:
curl -X GET "https://tlt-cityiot.rd.tuni.fi/orion/v2/entities?limit=1000&type=StreetlightGroup&q=refStreetlightCabinetController~=KV-0446&attrs=id" --header "Fiware-Service: streetlight" --header "Fiware-Servicepath: /Tampere" --header "apikey: your_apikey"
Find out which streetlight groups have all phases for intensity and voltage set with all values for intensity being above 10 A:
curl -X GET "https://tlt-cityiot.rd.tuni.fi/orion/v2/entities?limit=1000&type=StreetlightGroup&q=intensity.L1>10;intensity.L2>10;intensity.L3>10;voltage.L1!=null;voltage.L2!=null;voltage.L3!=null&attrs=intensity,voltage" --header "Fiware-Service: streetlight" --header "Fiware-Servicepath: /Tampere" --header "apikey: your_apikey"
Get daily maximum illuminance values for street light control cabinet KV-0217 between 4 January 2019 and 7 January 2019:
curl -X GET "https://tlt-cityiot.rd.tuni.fi/quantumleap/v2/entities/weatherobservation_KV-0217/attrs/illuminance?fromDate=2019-01-04T00:00:00Z&toDate=2019-01-07T23:59:59Z&aggrMethod=max&aggrPeriod=day" --header "Fiware-Service: streetlight" --header "Fiware-Servicepath: /Tampere" --header "apikey: your_apikey"
