{"id":1619,"date":"2021-02-14T03:13:04","date_gmt":"2021-02-14T02:13:04","guid":{"rendered":"https:\/\/smartdatamodels.org\/?p=1619"},"modified":"2021-02-14T03:13:04","modified_gmt":"2021-02-14T02:13:04","slug":"alpha-version-for-drafting-a-data-model","status":"publish","type":"post","link":"https:\/\/smartdatamodels.org\/index.php\/alpha-version-for-drafting-a-data-model\/","title":{"rendered":"Alpha version for drafting a data model"},"content":{"rendered":"

In case you are not an expert for creating a JSON schema (one of the elements of a data model)
\nOn this page<\/a>, you have a spreadsheet for helping with the first steps.<\/p>\n

\"\"
\n1.- Fill the spreadsheet with the names of the properties for your model<\/p>\n

2.- fill the NGSI type (Property, Relationship or Geoproperty)<\/p>\n

3.- In case of property, fill the data type (array and object types are currently not completely supported)<\/p>\n

4.- Fill in the description<\/p>\n

5.- Click the button, the page will reload<\/p>\n

6.- voila! you have your json schema below the spreadsheet, just copy and paste into your favourite editor.<\/p>\n

The python code<\/a> for it is also made public in the utils directory<\/a> in the data models repo<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

In case you are not an expert for creating a JSON schema (one of the elements of a data model) On this page, you have a spreadsheet for helping with the first steps. 1.- Fill the spreadsheet with the names of the properties for your model 2.- fill the NGSI… More…<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[105,107,109,113,115,119,117,88,143,111,125],"tags":[],"class_list":["post-1619","post","type-post","status-publish","format-standard","hentry","category-cross-sector","category-smart-cities","category-smart-energy-domain","category-smart-environment","category-smart-manufacturing","category-smart-robotics","category-smart-water","category-smart-sensoring","category-smartaeronautics","category-smart-agrifood","category-smartdestinations"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1641,"url":"https:\/\/smartdatamodels.org\/index.php\/create-your-data-model-with-a-google-spreadsheet\/","url_meta":{"origin":1619,"position":0},"title":"Create your data model with a google spreadsheet","author":"maestro","date":"15\/02\/2021","format":false,"excerpt":"NEW VERSION!! This post became obsolete, go for the new master sheet \u00a0 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\u2026","rel":"","context":"In "Cross Sector"","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/image.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/image.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/image.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":1727,"url":"https:\/\/smartdatamodels.org\/index.php\/new-option-for-drafting-a-data-model\/","url_meta":{"origin":1619,"position":1},"title":"New option for drafting a data model","author":"maestro","date":"19\/02\/2021","format":false,"excerpt":"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\u2026","rel":"","context":"In "Internal"","block_context":{"text":"Internal","link":"https:\/\/smartdatamodels.org\/index.php\/category\/internal\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2021\/02\/instructions.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3889,"url":"https:\/\/smartdatamodels.org\/index.php\/new-tool-for-simplified-creation-of-a-data-model\/","url_meta":{"origin":1619,"position":2},"title":"New tool for simplified creation of a data model","author":"maestro","date":"09\/03\/2022","format":false,"excerpt":"The creation of a data model requires two mandatory files, one example and a JSON schema containing the definitions and data types of the elements in the entity. However, the JSON schema creation could be somehow demanding. The new tool opens the door for people with only basic knowledge of\u2026","rel":"","context":"In "Cross Sector"","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2644,"url":"https:\/\/smartdatamodels.org\/index.php\/new-method-for-drafting-the-json-schema-for-a-new-data-model\/","url_meta":{"origin":1619,"position":3},"title":"New method for drafting the json schema for a new data model","author":"maestro","date":"09\/06\/2021","format":false,"excerpt":"A new tool (capable of the creation of more complex data models) is available at the menu \"Draft a data model\". It is an external tool that simplifies the json schema needs. Hope it speeds up the development of new data models and simplifies it for newcomers to this syntaxis.\u2026","rel":"","context":"In "Cross Sector"","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1969,"url":"https:\/\/smartdatamodels.org\/index.php\/include-useralias-in-common-schema-json\/","url_meta":{"origin":1619,"position":4},"title":"Include userAlias in common-schema.json","author":"maestro","date":"23\/03\/2021","format":false,"excerpt":"The file common-schema.json compiles those properties massively used across the different data models in the different domains. The property userAlias has been included to store those anonymous identifiers of a user that cannot be traced back to the user. It can be referenced in any data model just by including\u2026","rel":"","context":"In "Cross Sector"","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8429,"url":"https:\/\/smartdatamodels.org\/index.php\/mastersheet-for-submission-of-simple-data-models\/","url_meta":{"origin":1619,"position":5},"title":"MasterSheet for submission of simple data models","author":"maestro","date":"13\/03\/2023","format":false,"excerpt":"We have released a master sheet that simplifies the contribution to the smart data models. It uploads the data model to a new repository called drafted. The video help is also available Steps for using the spreadsheet 0.- Make a local copy in your google account and grant permission the\u2026","rel":"","context":"In "Cross Sector"","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2023\/03\/sheet.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/1619","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/comments?post=1619"}],"version-history":[{"count":1,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/1619\/revisions"}],"predecessor-version":[{"id":1621,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/1619\/revisions\/1621"}],"wp:attachment":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/media?parent=1619"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/categories?post=1619"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/tags?post=1619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}