Skip to content

Changes

View changes from to


On April 29, 2024 at 8:50:30 AM +0300, Gravatar Ville Heikkilä:
  • Updated description of Tampere street lights from

    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 electrical intensity (electrical 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](https://ckan.energydata.rd.tuni.fi/organization/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](https://fiware-datamodels.readthedocs.io/en/latest/Device/doc/introduction.html), [weather](https://fiware-datamodels.readthedocs.io/en/latest/Weather/doc/introduction.html) and [street lighting](https://fiware-datamodels.readthedocs.io/en/latest/StreetLighting/doc/introduction.html) 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](https://fiware-datamodels.readthedocs.io/en/latest/StreetLighting/StreetlightControlCabinet/doc/spec.html): 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](https://fiware-datamodels.readthedocs.io/en/latest/StreetLighting/StreetlightGroup/doc/spec.html): 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](https://fiware-datamodels.readthedocs.io/en/latest/Device/Device/doc/spec.html): 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](https://fiware-datamodels.readthedocs.io/en/latest/Weather/WeatherObserved/doc/spec.html): 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 transfered 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 FIWARR 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"
    to
    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](https://ckan.energydata.rd.tuni.fi/organization/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](https://fiware-datamodels.readthedocs.io/en/latest/Device/doc/introduction.html), [weather](https://fiware-datamodels.readthedocs.io/en/latest/Weather/doc/introduction.html) and [street lighting](https://fiware-datamodels.readthedocs.io/en/latest/StreetLighting/doc/introduction.html) 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](https://fiware-datamodels.readthedocs.io/en/latest/StreetLighting/StreetlightControlCabinet/doc/spec.html): 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](https://fiware-datamodels.readthedocs.io/en/latest/StreetLighting/StreetlightGroup/doc/spec.html): 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](https://fiware-datamodels.readthedocs.io/en/latest/Device/Device/doc/spec.html): 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](https://fiware-datamodels.readthedocs.io/en/latest/Weather/WeatherObserved/doc/spec.html): 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"