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=12&rev2=13 '''[[http://marmotta.apache.org/kiwi/sparql.html | kiwi-sparql ]] module ''' + The KiWi triplestore basically maps the SPARQL queries to SQL. Therefore, we added GeoSPAQL aligned with that, reusing the native geo capabilities that PostGIS provides. + + Just as done with other project ( [[https://issues.apache.org/jira/browse/MARMOTTA-351 | MARMOTTA-351 ]] [1] ) for "full text search", we have followed the recommendation of our mentor and GeoSPARQL was implemented as an extension. The [[https://github.com/cuent/marmotta/tree/MARMOTTA-584/libraries/kiwi/kiwi-sparql/src/main/java/org/apache/marmotta/kiwi/sparql/function/geosparql | GeoSPARQL]] package has been created and it contains the 35 functions of the GeoSPARQL Standard, each one implementing [[https://github.com/cuent/marmotta/blob/MARMOTTA-584/libraries/kiwi/kiwi-sparql/src/main/java/org/apache/marmotta/kiwi/sparql/function/NativeFunction.java | NativeFunction]]. + + '''DATABASE UPGRADE WITH POSTGIS SUPPORT''' - 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. + 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. Note that only PostgreSQL has real support for spatial queries with postgis extension. In this section, the process performed for updating the database to Version 5 and achieve POSTGIS support is described. @@ -63, +68 @@ '''''[[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 database supporting the spatial functions and the new Geometry data type is necessary the execution of the SQL Statement "CREATE EXTENSION POSTGIS". + 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 database supporting the spatial functions and the new Geometry data type is necessary the execution of the SQL Statement "CREATE EXTENSION POSTGIS". '''''[[https://github.com/cuent/marmotta/blob/MARMOTTA-584/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/upgrade_base_004_005.sql | upgrade_base_004_005.sql ]]''''' In case that Marmotta detects an older version of the database, this script allows the upgrade to version 5 with all the changes performed in create_base_tables.sql. + + + + [1]. [[https://issues.apache.org/jira/browse/MARMOTTA-351 ]] +
