The purpose of GeoRaptor project is to extend Oracle SQL Developer with additional functionality for database administrators or developers working with Oracle Spatial data.
- View Oracle Spatial data
- Assists in metadata and spatial index management
- Shapefile importer
Best tool for viewing Oracle spatial data
This plugin is very helpful. Main bonus is it's ability to render circular arcs without having to densify them first (as opposed to e.g. OpenJump). There are ways for improvement, though. 0) Make it available to SQL Developer version 4 1) When creating a layer, do NOT start to retrieve data automatically. First allow a user to change the query and add conditions. Then zoom in directly to the MBR of the geometries retrieved by the adjusted SQL. 2) Make it possible to create layers for geometries that do not have a spatial index defined on them. In my applications, I have a logging table with a geometry column. It has been a deliberate decision not to create a spatial index on this table, since the geometries in this logging table may be invalid. In order to visualise them, I first need to transfer them to another logging table, which is something I would like to avoid... 3) A layer in Georaptor is now directly coupled to a single table. A typical application uses SQL with joins etc. Therefore I would appreciate the ablity to define my own SQL, preferably by cut and paste directly from my application into the SQL window for the layer in Georaptor. 4) change the default fill for polygons to a fixed color for all geometries in the layer (not a different color for each geometry), and set the default opacity to 50 % (or allow me to set my own preferences :-) 5) Changing settings with respect to the display (or hiding) of labels or changing the symbols for the vertices does not always work (sometimes it does, sometime it doesn't, especially once a layer has been copied.). Hopefully these points will show up in a future release. Richard.
very easy to use
Great tool to locate errors in raw oracle spatial data. Shows the exact location (nodes) where the problem exists, plus node order. Thanks for the great work!