Spatial Viewer for Oracle SQL Developer / News: Recent posts

Imminent is a new release of GeoRaptor for SQL Developer.

The new release has been tested on 3.0, 3.1 and 3.2.

GeoRaptor will no longer support SQL Developer 2.x versions.

regards
Simon

GeoRaptor turns up in Bostongis' comparison of Oracle Spatial SQLServer Spatial and PostGIS, see 'Free viewer and editor' section :

http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008r2_oracle11gr2_postgis15_compare

At 25-05-2010 a new version of GeoRaptor is released. Very much new features are included, read more at : https://sourceforge.net/apps/mediawiki/georaptor/index.php?title=Main_Page#New_release_.21

I fixed an issue that stopped spatial layers from being added to spatial view on Oracle 11gR1, but did also happen with 10g versions.

This release is a SNAPSHOT release that gives you early access to new features. In this first release we have
- cross schema access
- use database views as spatial layers
- support of 3D coordinates (not the new 11g 3D geometries!)
Give it a try!

- Support for SQL Developer 2.1
- SpatialView stores Settings.xml now in ide.pref.dir
- QueryByPoint now works in "line marked" mode

- SpatialView : In layer tree, border between checkbox and label is better define.
- SpatialView : add support for ArcIMS raster layer

- "Operations for SDO_GEOMETRY" : by default, option is set on true
- SpatialView : Query data now have function with "MDSYS." prefix

- SpatialView : basic screen image when you perform multiple query or "Show geometry" operation.
- SpatialView : Zoom with window [Feature request 1464359]
- UpdateMetadata : button for calculate layer MBR

- Spatial View : query function now user SRID value from selected layer
- Spatial View : support for multiline string
- Spatial View : support for Multipoint and Point cluster

- [Feature request 1480349 ] Terminology changes
- Spatial View : Query data operation to query geometry objects by mouse click position.
- [Bug 1474034 ] DB connection reconnect
- [Bug 1442554 ] Error when Connection name alias not exist
- [Bug 1437630 ] SRID not selected

- SpatiaView : in properties dialog you can select properties for single object shade (for example, it is perform when you select operaton "Draw geometry"). It is also solution for Feature Request 1461652.
- SQL Result table integration : "Draw geometry in Spatial View" now draw object in layer properties for "selected object".
- SQL Result table integration : "Zoom on geometry in Spatial View" perform zoom and "Draw geometry in Spatial View" operation.
- [Bug 1471931] SpatiaView : user can change geometry column name in properties dialog. Now Spatial View supports tabel with multi geometry columns.
- [Bug 1471931] Validate Geometry : bug fix and now works for tabel with multi geometry columns.
- [Bug 1471931] Update metadata : now works for tabel with multi geometry columns.
- [Feature request 1464363] Mouse based panning
- SQL Result table integration & Spatial view : Warning if geometry is not 2D.

I publish new homepage for GeoRaptor, created with Google Page creator - http://mygeoraptor.googlepages.com/. Some topics are still missing, but they will be available in next days.

- Bug fix : Rectangle object draw and shade

- [ 1464368 ] Control ordering of the tables in spatial view
1) User can change layer order via new menu point "Move layer in order..."
2) Layers are rendered in a buttom-up sequence
- Menu point "Zoom on geometry in Spatial View" on result table is now implemented.

- [ 1456794 ] ora-00904 error with validation tjeck...

* Spatial View : new menu point on select layer : Zoom to last read geometries MBR.
* Update metadata : delete row in metadata table with press of "Delete" key.
* Spatial View : we new layer is added via menu point on the table, Spatial View dockable window is open automatic.
* GeoRaptor Snippets : installtion is now done with help of "SnippetAddin" class.

* 4-digits notation for gtype in SDO_GEOMETRY object.
* [ 1464091 ] SDO_GEOMETRY output -> last number

* For SDO_GEOMETRY type, you now get "short" version of SDO_GEOMETRY description in SQL Worksheet result table
* Layer properties dialog is redesign and now it use GroupLayout.

* Set window center via dialog if you click on label with current window MBR.
* Integration with SQL Worksheet result set table : Copy geometry to SQL Developer log, Copy geometry to clipboard, Draw geometry in Spatial View
* Fix bug when layer shade properties are saved or loaded.

What's new:
* Shade support for circle, rectangle, polygon, polygon with hole, multipolygon

* Support for multipolygons,
* Mark geometry start, points and line direction for polygon, multi polygon, line and line string,
* In Layer properties dialog, you can set last read layer data as layer MBR.

* Bug Fix : [ 1437905 ] err redraw layer after remove filter from where
* Bug Fix : [ 1422810 ] Progress bar refresh (ValidateGeometryColumn)
* Bug Fix : [ 1422814 ] Progress bar after validation (ValidateGeometryColumn)
* Bug Fix : [ 1438301 ] Properties dialog : only numbers for sizes
* Feature request : [ 1437903 ] Copy screen image to clipboard
* Support for Matarialized Views in Spatial View, Validate Geometry and Update metadata

- Layer name is in line color.
- Layer fetch size can be set in properties dialog and it is use when data are read from DB.
- All layers and window properties are save and restore at startup.

* new Online tutorial : New version announcement
* support for Oracle Spatial Circle type
* change layer name via properties dialog
* create new layer as copy selected layer
* automatically installation of GeoRaptor Snippets group with some useful Oracle Spatial functions
* Bug fix: [ 1437626 ] Layer draw error if SRID is not null