the new data model Anomaly is located in the subject datamodel.Alert:
Anomaly: This entity contains a harmonized description of an anomaly.
No comments
Author: maestro
Extended data model Airquality observed
The data model of AirQualityobserved in the subject datamodel.Environment has been extended with these properties:
- nox: Other Nitrogen oxides detected
- coLevel: Qualitative Carbon Monoxide presence
- precipitation: Amount of water rain
- relativeHumidity: Humidity in the Air
- typeofLocation: Type of location of the sampled item
- temperature: Temperature of the item
- windDirection: Direction of the weather vane
- windSpeed: Intensity of the wind
Extended the data model WeatherForecast
the data model for WeatherForecast of the datamodel.Weather is being extended with the property:
- precipitation: Amount of water rain expected.
Extended the data model for AirQualityObserved
The data model for AirQualityObserved in the Subject dataModel.Environment has been extended with the properties:
co2: Carbon Dioxide detected.
Extended data model for GreenSpaceRecord
The data model for GreenSpaceRecord in the Subject Parks and Gardens has been extended with the property
litterCoverage: Percentage of the surface covered with litter or other waste materials
Building data model extended
Two new properties have been added to the existing building data model in the building subject,
peopleCapacity: Allowed people present at the building
peopleOccupancy: People present at the building
New option for drafting a data model
In the front page, there is a new option that allows you top to directly create a copy of the template sheet for creating new data models.
Remember that this spreadsheet is done for those unfamiliar with json schema (the official format for the smart data models) to allow them to create a new data model from their knowlege.
The use instructions are in the spreadsheet
Any doubt please let us know at info@smartdatamodels.org
Updated context.jsonld
The context.jsonld for smart data models has been updated to meet json ld requirements. Now they are implementing geojson requirements.
It affects the terms of bbox and coordinates. It could impact those elements having a geoproperty (most of the data models).
New data ACMeasurement for Energy
The Subject of dataModel.Energy, inside the domain Smart Energy has released 1 new data model:
- Pen : The Data Model intended to measure the electrical energies consumed by an electrical system which uses an Alternating Current (AC) for a three-phase (L1, L2, L3) or single-phase (L) and neutral (N). It integrates the initial version of the data Modem [THREEPHASEMEASUREMENT], extended to also perform single-phase measurements. It includes attributes for various electrical measurements such as power, frequency, current and voltage.
Create your data model with a google spreadsheet
NEW VERSION!!
This post became obsolete, go for the new master sheet
This is a resource, especially for those who have limited knowledge of JSON schema.
If you want to create a basic version of a data model (not all JSON schema is implemented), you can use a copy of this spreadsheet as template. This spreadsheet is always available at https://bit.ly/schema_sheet short name.
You need to fill the blue cells for these parameters:
- Subject: Official Subject where this data model should be allocated. (Check the official list)
- DataModel: Official data model name (Only one word i.e. WeatherForecast, no _).
- Title: use to be the name data model name with spaces. (i.e. Weather Forecast)
- Global Description: General text description of the data model. (2 lines is nice)
- Property name: Exactly this, the name of the property. Use camelCase. It would be good to check here whether this property already exists (you can copy and paste). Use those you need and leave one empty after those you filled. Properties below an empty property name are ignored.
- NGSI type: (Property, Relationship or Geoproperty)
- Data type: Type of data in the property. (array and object are not fully implemented)
- Other restrictions: If you are unfamiliar with JSON schema leave it empty.
- Description: Official description of the property.
Once you’ve got the schema, grab some examples (It is always good to review the contribution manual) and you can make a Pull Request on any of the subjects of any domain in Github. Or just use this form.
NOTE 1: The first option will be attended quicker than the second.
NOTE 2: Do not write out of the blue cells (it will be ignored). And do not add or remove cells. The converter script looks for these precise locations in blue.
NOTE 3: Your spreadsheet has to be made public. (anyone with the link), otherwise, the script will not be able to retrieve your data.
Call:
Parameters: (Mandatories)
- sheetUrl: The url of the spreadsheet (if not it takes default spreadsheet in the menu)
Output: A json schema based on the properties defined in the database. This is an alpha version so errors are not managed.
