{"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,"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},"jetpack_post_was_ever_published":false},"categories":[84],"tags":[],"class_list":["post-6411","post","type-post","status-publish","format-standard","hentry","category-governance"],"jetpack_publicize_connections":[],"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":7921,"url":"https:\/\/smartdatamodels.org\/index.php\/sql-export-available-for-postgresql\/","url_meta":{"origin":6411,"position":1},"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":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":2},"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":42963,"url":"https:\/\/smartdatamodels.org\/index.php\/new-pysmartdatamodels-version-0-8-1-0-refreshed-data-reduced-size-20-times-with-same-functionality\/","url_meta":{"origin":6411,"position":3},"title":"New pysmartdatamodels Version 0.8.1.0: Refreshed Data (reduced size 20 times with same functionality)","author":"Agent","date":"05\/10\/2026","format":false,"excerpt":"We are happy to announce a new release of our Python package, pysmartdatamodels, version 0.8.1.0, with a refreshed attribute database, a smaller download, and a cleanup of some leftover dead code. What\u2019s New in This Version? Refreshed Data, End to End The package\u2019s bundled data \u2014 the official list of\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\/2026\/10\/pysmartdatamodels-300x67.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"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":4},"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":43057,"url":"https:\/\/smartdatamodels.org\/index.php\/new-pysmartdatamodels-version-0-8-2-0-semantic-identification-for-data-spaces\/","url_meta":{"origin":6411,"position":5},"title":"New pysmartdatamodels Version 0.8.2.0: Semantic Identification for Data Spaces","author":"Agent","date":"09\/10\/2026","format":false,"excerpt":"We are happy to announce a new release of our Python package, pysmartdatamodels, version 0.8.2.0. The headline feature is aimed squarely at data spaces: a new function that can give semantic meaning to a payload even when the party who sent it never provided one. What\u2019s New in This Version?\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\/2026\/10\/pysmartdatamodels-300x67.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_featured_media_url":"","_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}]}}