Hi all,
Do you think it would be interesting to have a more generic spatial
databases vector format support in OJ ?
Playing with DataStore classes to support Oracle Spatial, I saw that it
could be implemented with few efforts:
Most of spatial databases tend to adhere to OGC Simple Features
Specifications for SQL.
They are accessible through a JDBC Driver providing information about
database metadata (tables, columns, indexes, primary keys, etc.).
AFAIU, supporting a spatial database involves these steps:
• Retrieving list of spatial tables (through OGC catalog or equivalent
metadata query: could also be done with JDBC DatabaseMetadata by looking at
columns types: maybe an option in the DataStore Layer: "list only
registered tables" or "list all geometric tables")
• Retrieving name, srid, maybe geo type of the tables' geo columns
• Retrieving tables extents with a metadata query or a custom query if MD
unavailable
• Loading geometric objects and converting them to OJ model.
I was thinking about base classes
(org.openjump.core.ui.plugin.datastore.spatialdatabases) implementing core
functionalities (DatabaseMetadata stuff and queries) and subclasses
providing custom information (JDBC properties, default schema, custom
queries, etc.) for each supported database.
DB Query plugin showed us that Oracle, Spatialite and MySQL spatial objects
can be efficiently loaded into OJ.
I was thinking adding support for Oracle Spatial (POC code available in the
SpatialDatabasesPlugin), MySQL/MariaDB, SQL Server, Spatialite.
Nicolas
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
_______________________________________________
Jump-pilot-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
