Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (22)
- All (399)
- Biography (1)
- Blog (44)
- Business Requirements (1)
- Commentary (1)
- Conversion (2)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (13)
- GPS (1)
- Image Processing (2)
- Import Export (8)
- Licensing (2)
- LiDAR (1)
- Linear Referencing (4)
- Manifold GIS (3)
- Mapping (1)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (5)
- Open Source (18)
- Oracle Spatial and Locator (194)
- Partitioning (1)
- PostGIS (36)
- Projections (1)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (37)
- Space Curves (9)
- Spatial Database Functions (109)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (92)
- Standards (3)
- Stored Procedure (17)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
Drawing a layer in GeoRaptor: Simple Gotchas!
A question from a user:
It seems as though the system calculates extents that are HUGELY larger than the actual geometry. I have found by putting a label on it that you sill see a tiny blob then using the windowed zoom I can then start showing the links and eventual remove the label. Idea’s ?
From this it appears that:
- Hist data must be geodetic/geographic, or
- The diminfo for the table/column is set to the widest possible extent ie -180..180 and -90..90 and not something smaller and closer to the extent of your data. (While the documentation says to do this, most practitioners do not – they set the diminfo to the extent of the actual data. It makes no different to Oracle but a lot of software like GR, QGIS etc that use the diminfo as the MBR of the layer.)
When one first adds a table/column to the map view, GR checks if the data is planar. If it is planar the actual extent of the data to extracted from the header record of the rtree index (stored in the mdsys index metadata). But this data is not useable for geodetic/geographic data so GR has to go to the user_sdo_geom_metadata entry to get the diminfo values.
In addition, if the data is not point data then GR automatically implements the sdo_filter pixel filtering. This can be turned off in Preferences.
Finally, to create a decent map extent for the layer, right mouse click, properties for the layer. Then tick the box marked “Recalculate MBR (next draw)”. This makes GR compute an MBR that covers only the data returned via the next draw query.
Documentation
- MySQL Spatial General Functions
- Oracle LRS Objects
- Oracle Spatial Exporter (Java + pl/SQL)
- Oracle Spatial Object Functions
- Oracle Spatial Object Functions (Multi Page)
- PostGIS pl/pgSQL Functions
- SC4O Oracle Java Topology Suite (Java + pl/SQL)
- SQL Server Spatial General TSQL Functions
- SQL Server Spatial LRS TSQL Functions