{"id":6411,"date":"2022-07-21T13:59:28","date_gmt":"2022-07-21T11:59:28","guid":{"rendered":"https:\/\/smartdatamodels.org\/?p=6411"},"modified":"2022-07-21T13:59:28","modified_gmt":"2022-07-21T11:59:28","slug":"export-of-the-full-database-of-attributes","status":"publish","type":"post","link":"https:\/\/smartdatamodels.org\/index.php\/export-of-the-full-database-of-attributes\/","title":{"rendered":"Export of the full database of attributes"},"content":{"rendered":"<p>At home -&gt; Search -&gt; <a href=\"https:\/\/smartdatamodels.org\/index.php\/export-of-database-of-attributes-of-the-smart-data-models\/\">json export of attributes database of smart data models\u00a0 <\/a>is the full database of attributes (more than 18000), see the <a href=\"https:\/\/smartdatamodels.org\/index.php\/statistics\/\">statistics<\/a> page as an array of JSON objects.<\/p>\n<p>Fields for each attribute<\/p>\n<p><em><strong>_id<\/strong><\/em>: identifier of the item<\/p>\n<p><em><strong>property<\/strong><\/em>: the name of the attribute<\/p>\n<p><em><strong>dataModel<\/strong><\/em>: the data model this attribute is present<\/p>\n<p><em><strong>repoName<\/strong><\/em>: the subject this data model belongs to<\/p>\n<p><em><strong>description<\/strong><\/em>: the description of the attribute<\/p>\n<p><em><strong>typeNGSI<\/strong><\/em>: Whether it is a property, Geoproperty, or relationship<\/p>\n<p><em><strong>modelTags<\/strong><\/em>: inherited from the data model tags<\/p>\n<p><em><strong>license<\/strong><\/em>: link to the license for the data model<\/p>\n<p><em><strong>schemaVersion<\/strong><\/em>: version of the data model<\/p>\n<p><em><strong>type<\/strong><\/em>: data type<\/p>\n<p><em><strong>model<\/strong><\/em>: when available the reference model for the attribute<\/p>\n<p><em><strong>units<\/strong><\/em>: when available the recommended units for the attribute<\/p>\n<p><em><strong>format<\/strong><\/em>: either date, or time, or date-time, or URI, etc the format of the attribute<\/p>\n","protected":false},"excerpt":{"rendered":"<p>At home -&gt; Search -&gt; json export of attributes database of smart data models\u00a0 is the full database of attributes (more than 18000), see the statistics page as an array of JSON objects. Fields for each attribute _id: identifier of the item property: the name of the attribute dataModel: the&#8230; <a class=\"continue-reading-link\" href=\"https:\/\/smartdatamodels.org\/index.php\/export-of-the-full-database-of-attributes\/\">More&#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","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":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[84],"tags":[],"class_list":["post-6411","post","type-post","status-publish","format-standard","hentry","category-governance"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":7846,"url":"https:\/\/smartdatamodels.org\/index.php\/draft-of-a-python-package-available\/","url_meta":{"origin":6411,"position":0},"title":"Draft of a python package available","author":"maestro","date":"12\/12\/2022","format":false,"excerpt":"Now we have a draft version of a python package to integrate the smart data models with your developments. It is a beta version so you can expect some issues when using it. We will be glad if you report it at info@smartdatamodels.org or suggest new features. Thanks to Anthony\u2026","rel":"","context":"In &quot;Cross Sector&quot;","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\/2022\/11\/python-logo-master-v3-TM-flattened.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2022\/11\/python-logo-master-v3-TM-flattened.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2022\/11\/python-logo-master-v3-TM-flattened.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":8157,"url":"https:\/\/smartdatamodels.org\/index.php\/the-data-models-available-for-python-developers-pysmartdatamodels-0-5-40-published-beta-version\/","url_meta":{"origin":6411,"position":1},"title":"The data models available for python developers. pysmartdatamodels 0.5.40 published. Beta version.","author":"maestro","date":"27\/01\/2023","format":false,"excerpt":"Now you can find in pypi.org the python package pysmartdatamodels with 13 functions for the integrators of the data models (more than 800) in external systems and applications. It is a beta version. There is a function, update_data() that whenever is run, it updates the data models to the last\u2026","rel":"","context":"In &quot;Cross Sector&quot;","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":7921,"url":"https:\/\/smartdatamodels.org\/index.php\/sql-export-available-for-postgresql\/","url_meta":{"origin":6411,"position":2},"title":"SQL export available for Postgresql","author":"maestro","date":"21\/12\/2022","format":false,"excerpt":"There is a new file 'schema.sql' in all the directories of the data models. It is a SQL script for PostgreSQL. The script creates the structure of a relational table containing the attributes defined in the data model. It also creates the data types for those attributes with an enumeration\u2026","rel":"","context":"In &quot;Cross Sector&quot;","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":32569,"url":"https:\/\/smartdatamodels.org\/index.php\/use-smartdatamodels-in-your-local-ai-agent-with-this-mcp-server\/","url_meta":{"origin":6411,"position":3},"title":"Use smartdatamodels in your local AI agent with this MCP server","author":"maestro","date":"16\/03\/2026","format":false,"excerpt":"With this MCP configuration file you will be capable to use Smart Data Models locally in your AI agent. { \"mcpServers\": { \"smartdatamodels\": { \"type\": \"http\", \"serverUrl\": \"https:\/\/opendatamodels.org\/mcp\/v1\" } } } More information here These functions are available 1. search_data_models Search the Smart Data Models (SDM) catalog by keyword, domain\u2026","rel":"","context":"In &quot;Cross Sector&quot;","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\/2022\/01\/SmartDataModels_logo.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":11440,"url":"https:\/\/smartdatamodels.org\/index.php\/new-subject-smart-data-models-and-new-data-model-attribute\/","url_meta":{"origin":6411,"position":4},"title":"New subject Smart Data Models and new data model Attribute","author":"maestro","date":"27\/11\/2024","format":false,"excerpt":"Eating your own food is for SDM a demonstration that agile standardization works We have created a new subject, SmartDataModels, where the structure of the assets of SDM will be released. We have started with the data models of Attribute according to the global data base of attributes (more than\u2026","rel":"","context":"In &quot;Cross Sector&quot;","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\/09\/Logo_SmartDataModels.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2021\/09\/Logo_SmartDataModels.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2021\/09\/Logo_SmartDataModels.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2021\/09\/Logo_SmartDataModels.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":9466,"url":"https:\/\/smartdatamodels.org\/index.php\/extension-of-the-smart-data-models\/","url_meta":{"origin":6411,"position":5},"title":"Extension of the Smart Data Models","author":"maestro","date":"04\/09\/2023","format":false,"excerpt":"Hopefully you have unnoticed about several structural changes this weekend that has happen at SDM. Database of attributes, Now there are several additional information included. -- A unique id for every attribute of a version of a data model (i.e. -- The link to the parent's attribute (whenever there is\u2026","rel":"","context":"In &quot;Cross Sector&quot;","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/6411","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=6411"}],"version-history":[{"count":1,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/6411\/revisions"}],"predecessor-version":[{"id":6413,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/6411\/revisions\/6413"}],"wp:attachment":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/media?parent=6411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/categories?post=6411"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/tags?post=6411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}