Dear Wiki user, You have subscribed to a wiki page or wiki category on "Marmotta Wiki" for change notification.
The "MARMOTTA-584/DeveloperDocumentation" page has been changed by Francisco Sumba: https://wiki.apache.org/marmotta/MARMOTTA-584/DeveloperDocumentation?action=diff&rev1=10&rev2=11 {{attachment:kiwiValueFactory.PNG}} - In the storenode(...) function of [[https://github.com/cuent/marmotta/blob/MARMOTTA-584/libraries/kiwi/kiwi-triplestore/src/main/java/org/apache/marmotta/kiwi/persistence/KiWiConnection.java | kiwiConnection ]] class, the "node instanceof KiWiGeometryLiteral" condition was added to filter GEOMETRY Literals and insert them into the database with "store.gliteral" statement from [[https://github.com/cuent/marmotta/blob/MARMOTTA-584/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/statements.properties | "statements.properties" ]] file. The "statements.properties" was upgraded to add the new "store.gliteral" statement. Moreover, The WKT are extracted from wktLiteral. + In the storenode(...) function of [[https://github.com/cuent/marmotta/blob/MARMOTTA-584/libraries/kiwi/kiwi-triplestore/src/main/java/org/apache/marmotta/kiwi/persistence/KiWiConnection.java | kiwiConnection ]] class, the "node instanceof KiWiGeometryLiteral" condition was added to filter GEOMETRY Literals and insert them into the database with "store.gliteral" statement from [[https://github.com/cuent/marmotta/blob/MARMOTTA-584/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/statements.properties | "statements.properties" ]] file. The "statements.properties" was upgraded to add the new "store.gliteral" statement. Moreover, the WKT GEOMETRY are extracted from wktLiteral and sent as parameter to the "store.gliteral" statement. - In the following figure fragment of storenode(...) function when node is instanceof KiWiGeometryLiteral is presented. + In the following figure, a fragment of storenode(...) function is presented, it corresponds to "node instanceof KiWiGeometryLiteral" condition. - {{attachment:kiwiconnection.png}} + {{attachment:kiwiconnection.PNG}} - In the following figure fragment of RDF is presented + In the following figure a fragment of RDF is presented to show the WKTLiteral corresponding to the Province of Madrid. {{attachment:wktseparate.png}} @@ -53, +53 @@ '''[[http://marmotta.apache.org/kiwi/sparql.html | kiwi-sparql ]] module ''' - ''' CREATE EXTENSION POSTGIS ''' + '''DATABASE UPGRADE WITH POSTGIS SUPPORT''' - To achieve the execution of spatial functions GeoSPARQL in this project has decided to use the PostGIS extension of Postgres DB. In this case, it made a translation of GeoSPARQL functions to Postgis SQL functions. + To achieve the execution of spatial GeoSPARQL functions in this project, we have decided to use the PostGIS extension of Postgres DB. In this case, it makes a translation from GeoSPARQL functions to Postgis SQL functions. - In this section the process performed for updating the database to Version 5 to achieve support POSTGIS described. + In this section, the process performed for updating the database to Version 5 and achieve POSTGIS support is described. + One of the most important processes of the project was the update of the scripts to the creation, update and delete of the database, wich are allowed in the resources packages of [[ http://marmotta.apache.org/kiwi/triplestore.html | kiwi-triplestore ]] module. At next, the changes over each script are detailed. + + + '''''[[https://github.com/cuent/marmotta/blob/MARMOTTA-584/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/create_base_tables.sql || create_base_tables.sql]]''''' + + This script was modified to upgrade the database into the '''version 5''', also, the script allows the creation of a new enumtype called "geom", which allows to identify the new geometry literals. In the table "nodes" a new column called "gvalue" was added, whose data type is Geometry. For the support of the spatial functions and the new Geometry data type is necessary the execution of the SQL Statement "CREATE EXTENSION POSTGIS". + + + + +
