{"id":43,"date":"2020-12-18T10:53:23","date_gmt":"2020-12-18T10:53:23","guid":{"rendered":"https:\/\/spatialdbgroup.polimi.it\/?page_id=43"},"modified":"2021-06-03T08:53:09","modified_gmt":"2021-06-03T08:53:09","slug":"idmltool","status":"publish","type":"page","link":"https:\/\/spatialdbgroup.polimi.it\/?page_id=43","title":{"rendered":"IDM Tool"},"content":{"rendered":"<p class=\"bodytext\"><b>CURRENT RELEASE<img loading=\"lazy\" decoding=\"async\" class=\"content-img alignnone wp-image-120 size-full\" src=\"https:\/\/spatialdbgroup.polimi.it\/wp-content\/uploads\/2020\/12\/idmtool.png\" alt=\"\" width=\"520\" height=\"620\" srcset=\"https:\/\/spatialdbgroup.polimi.it\/wp-content\/uploads\/2020\/12\/idmtool.png 520w, https:\/\/spatialdbgroup.polimi.it\/wp-content\/uploads\/2020\/12\/idmtool-252x300.png 252w, https:\/\/spatialdbgroup.polimi.it\/wp-content\/uploads\/2020\/12\/idmtool-10x12.png 10w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/b><\/p>\n<p class=\"bodytext\">The current release of the IDM Tools comprises 3 tools, as shown by the figure below:<\/p>\n<ol start=\"1\" type=\"1\">\n<li>the <i>Model Browser<\/i>, which provides a way of exploring the Conceptual Schema in a hypertext style that is different and complementary to reading UML diagrams;\u00a0 this is useful not only for non UML experts, but also for experts who need to retrieve rapidly all information related to a given class.<\/li>\n<li>the <i>SQL Mapper<\/i>, which allows to select a set of Feature Types from the Conceptual Model and generates an SQL Script for creating a PostGis Database \u2013 called INSPIRE DATABASE &#8211;\u00a0 representing the selected Feature Types<\/li>\n<li>the <i>WFS Configurator<\/i>, which produces a Configuration File enabling a Deegree WFS to access the Data contained in the INSPIRE DATABASE<\/li>\n<\/ol>\n<p class=\"align-center\">Notice that for using the IDM Tools it is not necessary to install Enterprise Architect \u2013 these tools provide therefore free access to the Inspire Data Model.<\/p>\n<p class=\"bodytext\"><b>MOTIVATIONS<\/b><\/p>\n<p class=\"bodytext\">The architecture of the IDM Tools is characterized by 2 main aspects:<\/p>\n<ul>\n<li>the support to the frontend service is provided by an SQL database system<\/li>\n<li>the structure of the database is produced by the UML models (not from the XSDs of the service)<\/li>\n<\/ul>\n<p class=\"bodytext\">This architecture is motivated by considerations regarding the <i>performance<\/i> of the services and the <i>stability<\/i> of the data models. We believe that a WFS service must be supported by a full-fledged spatial DBMS in order to obtain acceptable performance, especially in presence of one or more of the following requirements:<\/p>\n<ul>\n<li>the WFS service has to service queries (possibly many queries in parallel), not only predefined datasets<\/li>\n<li>the amount of data to access is large<\/li>\n<li>the data should be updated through a transactional WFS<\/li>\n<\/ul>\n<p class=\"bodytext\">Regarding the <i>stability<\/i> of the Data Models, we believe that the UML model will be more stable than the XSDs which have been derived from it, since<\/p>\n<ul>\n<li>the legally approved INSPIRE Data Specifications contain the UML model, not the XSDs<\/li>\n<li>the GML XSDs published by INSPIRE constitute only one possible encoding; other encodings may emerge in the future<\/li>\n<\/ul>\n<p class=\"bodytext\">A major investment which the INSPIRE Data producers will have to face in the next years will be the definition of the <i>(semantic) transformation<\/i> from their Production Data Models to the INSPIRE Data Model. Since the structure of the INSPIRE Database is derived from the UML model, using the UML Model and the INSPIRE database as the target of these transformations will safeguard these investments from changes in the encodings. In fact, in this architecture different encodings can be produced without affecting the (semantic) transformations.<\/p>\n<p class=\"bodytext\"><b><img loading=\"lazy\" decoding=\"async\" class=\"content-img alignnone wp-image-123 size-full\" src=\"https:\/\/spatialdbgroup.polimi.it\/wp-content\/uploads\/2020\/12\/scheme.png\" alt=\"\" width=\"696\" height=\"490\" srcset=\"https:\/\/spatialdbgroup.polimi.it\/wp-content\/uploads\/2020\/12\/scheme.png 696w, https:\/\/spatialdbgroup.polimi.it\/wp-content\/uploads\/2020\/12\/scheme-300x211.png 300w, https:\/\/spatialdbgroup.polimi.it\/wp-content\/uploads\/2020\/12\/scheme-16x12.png 16w\" sizes=\"auto, (max-width: 696px) 100vw, 696px\" \/><\/b> <b>PRELOADED DATA MODEL<br \/>\n<\/b><\/p>\n<p class=\"bodytext\">The IDM Tools are distributed with a preloaded INSPIRE UML Data Model; in the current release this preloaded Data Model has been derived from the official Inspire <i>2010-04-26_r937.eap<\/i> distribution. The derived model in .eap format can be downloaded from this site. The few transformations which have been applied to the INSPIRE Themes are due to the correction of some errors or to some requirements for GML encoding. The ISO package has been simplified and renamed as \u201cselected ISO TC211\u201d. A detailed description of these modifications is presented in the <i>Preloaded Data Model<\/i> panel of the tool.<\/p>\n<p class=\"bodytext\"><strong>\u00a0FUTURE DEVELOPMENTS<\/strong><\/p>\n<p class=\"bodytext\">If the approach adopted by the IDM Tools will encounter the interest of stakeholders, we plan to develop it further in several directions:<\/p>\n<ul>\n<li>Validation of the INSPIRE Data Model: the procedures which have been applied for preloading the UML model can be transformed in a distributable tool for UML Schema Validation.<\/li>\n<li>Support for the transformation of data from existing datasets to the INSPIRE Database; the integration of existing tools into this architecture will be investigated (some work in this direction, considering as source database the Italian \u201cNational Core\u201d &#8211; the Italian standard for GeoTopographic Databases &#8211; , is underway in cooperation with CISIS\u00a0 (a consortium of Italian Regions).<\/li>\n<\/ul>\n<p><strong>WFS demo\u00a0<\/strong><\/p>\n<p>As a demonstration of the functionalities of IDMT a DBS has been defined and the generated Script files have been used to create an INSPIRE DB and to install a WFS service at the following address:<\/p>\n<p><em>http: wfs<\/em><em>.<\/em><em>spatialdbgroup <\/em><em>.<\/em><em>polimi.<\/em> <em>it\/deegree-webservices-3<\/em><em>.<\/em><em>3.<\/em><em>9\/<\/em><em>services<\/em><\/p>\n<p>The DBS definition is included in the IDMT_937 download. It has the following parameters:<\/p>\n<ul>\n<li>Name: <em>DBSdemo<\/em><\/li>\n<li>CRS : <em>3003<\/em><\/li>\n<li>Dimension: 3D<\/li>\n<li>lmplementation Model: <em>SQL <\/em><em>for <\/em><em>GML<\/em><\/li>\n<li>Selected Feature Types: <em>Network, TransportNetwork<\/em><em>, <\/em><em>RoadLink<\/em><em>, <\/em><em>RoadNode<\/em><em>, <\/em><em>RoadLinkSequence, RoadWidth and VerticalPosition<\/em><\/li>\n<\/ul>\n<p>The INSPIRE Database has been loaded with production data containing about 80,000 <em>RoadLinks <\/em>and 30,000 <em>RoadNodes<\/em><em>.<\/em><\/p>\n<p>In order to use the service it is necessary to write the necessary queries and submit them with a Browser. Some example queries have been proposed as demonstrations in the following links (if a link starts but does not return a result, copy link in your browser and execute &#8211; we have tested Edge and Firefox):<\/p>\n<ul>\n<li>Selection of all Road Links (gml v.2.1.2)<\/li>\n<\/ul>\n<p><a href=\"http:\/\/wfs.spatialdbgroup.polimi.it\/deegree-webservices-3.3.9\/services?SERVICE=WFS&amp;VERSION=1.1.0&amp;REQUEST=GetFeature&amp;OUTPUTFORMAT=text%2Fxml%3B+subtype%3Dgml%2F2.1.2&amp;TRAVERSEXLINKDEPTH=0&amp;TypeName=RoadLink\" rel=\"noopener\"><span style=\"font-size: 10pt;\">http:\/\/wfs.spatialdbgroup.polimi.it\/deegree-webservices-3.3.9\/services?SERVICE=WFS&amp;VERSION=1.1.0&amp;REQUEST=GetFeature&amp;OUTPUTFORMAT=text%2Fxml%3B+subtype%3Dgml%2F2.1.2&amp;TRAVERSEXLINKDEPTH=0&amp;TypeName=RoadLink<\/span><\/a><\/p>\n<ul>\n<li>Selection of all Road Nodes (gml v.3.2.1):<\/li>\n<\/ul>\n<p><span style=\"font-size: 10pt;\"><a href=\"http:\/\/wfs.spatialdbgroup.polimi.it\/deegree-webservices-3.3.9\/services?SERVICE=WFS&amp;VERSION=1.1.0&amp;REQUEST=GetFeature&amp;OUTPUTFORMAT=text%2Fxml%3B+subtype%3Dgml%2F3.2.1&amp;TRAVERSEXLINKDEPTH=0&amp;TypeName=RoadNode\">http:\/\/wfs.spatialdbgroup.polimi.it\/deegree-webservices-3.3.9\/services?SERVICE=WFS&amp;VERSION=1.1.0&amp;REQUEST=GetFeature&amp;OUTPUTFORMAT=text%2Fxml%3B+subtype%3Dgml%2F3.2.1&amp;TRAVERSEXLINKDEPTH=0&amp;TypeName=RoadNode<\/a><\/span><\/p>\n<ul>\n<li>Selection of the Road Nodes in a BBOX (gml 2.1.2)<\/li>\n<\/ul>\n<p><span style=\"font-size: 10pt;\"><a href=\"http:\/\/wfs.spatialdbgroup.polimi.it\/deegree-webservices-3.3.9\/services?SERVICE=WFS&amp;VERSION=1.1.0&amp;REQUEST=GetFeature&amp;OUTPUTFORMAT=text%2Fxml%3B+subtype%3Dgml%2F2.1.2&amp;TRAVERSEXLINKDEPTH=0&amp;BBOX=1686000,5026000,1705000,5035000&amp;TypeName=RoadNode\">http:\/\/wfs.spatialdbgroup.polimi.it\/deegree-webservices-3.3.9\/services?SERVICE=WFS&amp;VERSION=1.1.0&amp;REQUEST=GetFeature&amp;OUTPUTFORMAT=text%2Fxml%3B+subtype%3Dgml%2F2.1.2&amp;TRAVERSEXLINKDEPTH=0&amp;BBOX=1686000,5026000,1705000,5035000&amp;TypeName=RoadNode<\/a><\/span><\/p>\n<p>Unfortunately, as far as we know current GIS clients are not able to deal with the complex INSPIRE GML encoding. However we have verified for example QGIS is able to read and display the RoadLinks and RoadNodes obtained from the above queries, although it loses all information of the associations between features.<\/p>\n<p><em>\u00a0<\/em><\/p>\n<p><strong>DOWNLOAD<\/strong><\/p>\n<a  data-e-Disable-Page-Transition=\"true\" class=\"download-link\" title=\"\" href=\"https:\/\/spatialdbgroup.polimi.it?download=249&amp;tmstv=1776244927\" rel=\"nofollow\" id=\"download-link-249\" data-redirect=\"false\" >\n\tIDMT_937_release1.0beta_2014-06-25.zip\t(34 downloads\t)\n<\/a>\n\n<a  data-e-Disable-Page-Transition=\"true\" class=\"download-link\" title=\"\" href=\"https:\/\/spatialdbgroup.polimi.it?download=253&amp;tmstv=1776244927\" rel=\"nofollow\" id=\"download-link-253\" data-redirect=\"false\" >\n\t2010-04-26_r937revision1.zip\t(14 downloads\t)\n<\/a>\n\n","protected":false},"excerpt":{"rendered":"<p>CURRENT RELEASE The current release of the IDM Tools comprises 3 tools, as shown by the figure below: the Model Browser, which provides a way of exploring the Conceptual Schema in a hypertext style that is different and complementary to reading UML diagrams;\u00a0 this is useful not only for non UML experts, but also for [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page.php","meta":{"_acf_changed":false,"footnotes":""},"class_list":["post-43","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/spatialdbgroup.polimi.it\/index.php?rest_route=\/wp\/v2\/pages\/43","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/spatialdbgroup.polimi.it\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/spatialdbgroup.polimi.it\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/spatialdbgroup.polimi.it\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/spatialdbgroup.polimi.it\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=43"}],"version-history":[{"count":39,"href":"https:\/\/spatialdbgroup.polimi.it\/index.php?rest_route=\/wp\/v2\/pages\/43\/revisions"}],"predecessor-version":[{"id":350,"href":"https:\/\/spatialdbgroup.polimi.it\/index.php?rest_route=\/wp\/v2\/pages\/43\/revisions\/350"}],"wp:attachment":[{"href":"https:\/\/spatialdbgroup.polimi.it\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=43"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}