Cacher les modifications mineures - Affichage du code
If you are interested by this work, feel free to contact me here Contact
1. Why
GeoEmbedded is part of a more important concept than I wish to develop : eSDI.
Sorry section under construction. I put below a short abstract in spanish.
eSDI (embedded Spatial Data Infrastructure) es un nuevo concepto y solución para construir y administrar una IDE. Se basa en una observación simple. A veces, especialmente en las pequeñas administraciones locales, se necesita de disponer de un dispositivo mas flexible y mas portátil. Esta solución ya existe en partido con la Geodatabase del software ArcGIS. Sin 6embargo su utilización se limita principalmente al almacenamiento de datos o entonces deben comprar extensiones especializadas como ArcSDE. Si el mundo del GIS libre dispone de base de datos espaciales robustos y potentes (PostgreSQL, MySQL) en cambio en muchas situaciones estas herramientas están demasiado completas con relación a las necesidades y a las utilizaciones que se hacen. Por eso, presentaremos un nuevo tipo de base de datos espaciales quien esta basada sobre la base de datos libre en Java H2-Database. Acoplada con el SIG gvSIG, H2-Espacial permite disponer de un primer nivel de IDE totalmente móvil : eSDI.
2.Method
Idea is to bind the JTS library with H2 database. See http://jump-project.org/project.php?PID=JTS&SID=OVER
The database spatial architecture was definied by David Blasby and Chris Holmes.
Technical architecture (Java for spatial DB)
JAVA Spatial Algorthims (JTS) | | GeoSpatialFunctions (java) | | SQLCodegenerator : auto-Generated spatial DB Bindings and SQL CREATE FUNCTION Bindings (java) | | JAVA DB
3.Spatial storage
Spatial data are stored in WKT format with SRID.
Examples :
SRID=27582;POINT(12 12)
SRID=-1;LINESTRING (62 69, 189 162, 200 235)
SRID=-1;POLYGON ((274 214, 274 295, 326 295, 326 214, 274 214))
I chose format WKT because the storage into binary induced incoherent geometries during the reading with the JTS WKB parser.
4.Database schema
Database schema is basic. A table corresponds to a geographical layer. Geometry is stored in clob data types.
In the futur work, I'd like to implement OGC simple feature SQL specifications.
Database schema will be definied by :
- a GEOMETRY_COLUMNS table which describes the available feature tables and their Geometry properties, - a SPATIAL_REF_SYS table which describes the coordinate system and transformations for Geometry.
See : Figure 1 - Schema for features tables using predefinied data types in "Implementation Specification for Geographic information - Simple feature access - Part 2: SQL option"
5.Technical choices
Database constraints
- Easy to use - Easy to move - Easy to customize - Fast - Written in Java - Good documentation - Clear roadmap - Dynamic community - Licence GPL or compatible
Databases tested
Derby : http://db.apache.org/derby/ HSQLDB : http://www.hsqldb.org/ McKoi : http://mckoi.com/database/ H2 database : http://www.h2database.com/html/frame.html
Final choice : H2 Database
In some futur days I will upload my tests results.
6.Installation
Run h2spatial.bat
Load geospatialFunctions.sql and execute it.
7.Using
Create a table and populate it with values
(:source lang=text:) CREATE TABLE mySpatialTable(gid INT primary key, the_geom CLOB);
INSERT INTO mySpatialTable VALUES(1, GeomFromText('POINT(12,1)','1')
(:sourcend:)
Where GeomFromText(arg0,arg1)
arg0 = geometry in WKT format
arg1 = EPSG code
Tests sql spatial
8.Work in progress
Improve spatial queries using wkb storage and spatial indexes.
Proposed a simple geo client to execute and display queries.
9.Licence
Don't forget this tool is under CeCILL see http://www.cecill.info/
10.Download
References
http://www.opengeospatial.org/standards/sfs http://docs.codehaus.org/display/GEOS/SpatialDBBox http://www.h2database.com/html/frame.html?main.html&main http://jump-project.org/project.php?PID=JTS&SID=OVER
The GeoEmbeddedDB named H2 Spatial is now here :http://geosysin.iict.ch/irstv-trac/wiki/H2spatial/Why
(:source lang=text)
(:source lang=text:)
(:source lang=text)
(:sourcend:)
If you are interested by this work, feel free to contact me. |
If you are interested by this work, feel free to contact me here Contact
|If you are interested by this work, feel free to contact me.|
If you are interested by this work, feel free to contact me. |
|If you are interested by this work, feel free to contact me.|
eSDI (embedded Spatial Data Infrastructure) es un nuevo concepto y solución para construir y administrar una IDE. Se basa en una observación simple. A veces, especialmente en las pequeñas administraciones locales, se necesita de disponer de un dispositivo mas flexible y mas portátil. Esta solución ya existe en partido con la Geodatabase del software ArcGIS. Sin embargo su utilización se limita principalmente al almacenamiento de datos o entonces deben comprar extensiones especializadas como ArcSDE.
eSDI (embedded Spatial Data Infrastructure) es un nuevo concepto y solución para construir y administrar una IDE. Se basa en una observación simple. A veces, especialmente en las pequeñas administraciones locales, se necesita de disponer de un dispositivo mas flexible y mas portátil. Esta solución ya existe en partido con la Geodatabase del software ArcGIS. Sin 6embargo su utilización se limita principalmente al almacenamiento de datos o entonces deben comprar extensiones especializadas como ArcSDE.
5.Installation
5.Technical choices
Database constraints
- Easy to use - Easy to move - Easy to customize - Fast - Written in Java - Good documentation - Clear roadmap - Dynamic community - Licence GPL or compatible
Databases tested
Derby : http://db.apache.org/derby/ HSQLDB : http://www.hsqldb.org/ McKoi : http://mckoi.com/database/ H2 database : http://www.h2database.com/html/frame.html
Final choice : H2 Database
In some futur days I will upload my tests results.
6.Installation
6.Using
7.Using
7.Work in progress
8.Work in progress
8.Licence
9.Licence
10.Download
References
1. Why
2.Method
1. Why
GeoEmbedded is part of a more important concept than I wish to develop : eSDI.
Sorry section under construction. I put below a short abstract in spanish.
eSDI (embedded Spatial Data Infrastructure) es un nuevo concepto y solución para construir y administrar una IDE. Se basa en una observación simple. A veces, especialmente en las pequeñas administraciones locales, se necesita de disponer de un dispositivo mas flexible y mas portátil. Esta solución ya existe en partido con la Geodatabase del software ArcGIS. Sin embargo su utilización se limita principalmente al almacenamiento de datos o entonces deben comprar extensiones especializadas como ArcSDE. Si el mundo del GIS libre dispone de base de datos espaciales robustos y potentes (PostgreSQL, MySQL) en cambio en muchas situaciones estas herramientas están demasiado completas con relación a las necesidades y a las utilizaciones que se hacen. Por eso, presentaremos un nuevo tipo de base de datos espaciales quien esta basada sobre la base de datos libre en Java H2-Database. Acoplada con el SIG gvSIG, H2-Espacial permite disponer de un primer nivel de IDE totalmente móvil : eSDI.
2.Method
3.Spatial storage
3.Spatial storage
4.Database schema
4.Database schema
5.Installation
5.Installation
6.Using
6.Using
7.Work in progress
7.Work in progress
8.Licence
8.Licence
9.Download
Projet : Base de données embarquées pour le developpement de petites SDI. L'objectif est de remplacer la geodatabase d'Esri.
Architecture : Schema à definir..
Fonctions :
Technologie :
Tests :
1. Why
2.Method
Idea is to bind the JTS library with H2 database. See http://jump-project.org/project.php?PID=JTS&SID=OVER
The database spatial architecture was definied by David Blasby and Chris Holmes.
Technical architecture (Java for spatial DB)
JAVA Spatial Algorthims (JTS) | | GeoSpatialFunctions (java) | | SQLCodegenerator : auto-Generated spatial DB Bindings and SQL CREATE FUNCTION Bindings (java) | | JAVA DB
3.Spatial storage
Spatial data are stored in WKT format with SRID.
Examples :
SRID=27582;POINT(12 12)
SRID=-1;LINESTRING (62 69, 189 162, 200 235)
SRID=-1;POLYGON ((274 214, 274 295, 326 295, 326 214, 274 214))
I chose format WKT because the storage into binary induced incoherent geometries during the reading with the JTS WKB parser.
4.Database schema
Database schema is basic. A table corresponds to a geographical layer. Geometry is stored in clob data types.
In the futur work, I'd like to implement OGC simple feature SQL specifications.
Database schema will be definied by :
- a GEOMETRY_COLUMNS table which describes the available feature tables and their Geometry properties, - a SPATIAL_REF_SYS table which describes the coordinate system and transformations for Geometry.
See : Figure 1 - Schema for features tables using predefinied data types in "Implementation Specification for Geographic information - Simple feature access - Part 2: SQL option"
5.Installation
Run h2spatial.bat
Load geospatialFunctions.sql and execute it.
6.Using
Create a table and populate it with values
CREATE TABLE mySpatialTable(gid INT primary key, the_geom CLOB);
INSERT INTO mySpatialTable VALUES(1, GeomFromText('POINT(12,1)','1')
Where GeomFromText(arg0,arg1)
arg0 = geometry in WKT format arg1 = EPSG code
Tests sql spatial
7.Work in progress
Improve spatial queries using wkb storage and spatial indexes.
Proposed a simple geo client to execute and display queries.
8.Licence
Don't forget this tool is under CeCILL see http://www.cecill.info/
Références : http://docs.codehaus.org/display/GEOS/SpatialDBBox
References:
http://www.opengeospatial.org/standards/sfs http://docs.codehaus.org/display/GEOS/SpatialDBBox http://www.h2database.com/html/frame.html?main.html&main http://jump-project.org/project.php?PID=JTS&SID=OVER
Projet : Base de données embarquées pour le developpement de petites SDI.
Architecture : Schema.
Projet : Base de données embarquées pour le developpement de petites SDI. L'objectif est de remplacer la geodatabase d'Esri.
Architecture : Schema à definir..
Fonctions :
Projet :
Architecture :
Projet : Base de données embarquées pour le developpement de petites SDI.
Architecture : Schema.
GeoEmbeddedDB
Projet :
Architecture :
Technologie :
Références : http://docs.codehaus.org/display/GEOS/SpatialDBBox