qGIS, GEOMETRY_COLUMNS and SQL Server Spatial
This article recommends using the GEOMETRY_COLUMNS metadata table to control access to feature tables and their geometry properties for qGIS.
Tools
Useful tools such as PHPGenerator, pgAdmin, GeoRaptor etc.
GeoRaptor: Direct Display of SDO_GEOMETRY / WKT text objects
This article shows how to use GeoRaptor’s Jump to Geometry functionality to conduct “one off” mapping of SDO_GEOMETRY and EWKT/WKT text objects. PostGIS is shown as a source for EWKT showing how to integrate development across multiple databases.
GeoRaptor: Layer Properties
This page describes all the elements of the layer properties dialog used to style spatial data in a GeoRaptor map view.
GeoRaptor: Exporting GeoJSON and viewing in Tatuk GIS Viewer
This article shows how to export SDO_GEOMETRY data from Oracle to GeoJSON using GeoRaptor and SQL Developer with visualisation in the free Tatuk GIS Viewer.
GeoRaptor: Exporting GML and visualising in qGIS
GML Export and qGIS Visualisation This article shows how to export GML from SQL Developer table and resultset (query) objects using GeoRaptor. It also shows how to use the “OGR” flavour for encoding attributes (columns). And, finally, it shows how to open the GML files in qGIS and to query features to show their attributes.
GeoRaptor: Area Rendering Options
This article shows how to use GeoRaptor to render area or polygon objects using area, linear, point and text styles.
GeoRaptor: Views and On The Fly Projection
This article demonstrates demonstrated “on the fly” projection via use of multiple views to map geographic data.
GeoRaptor: Metadata Management
This post documents GeoRaptor’s Metadata Tool that can be used to created, update, delete and analyze the xxx_GEOM_METADATA associated with data held in tables and SDO_GEOMETRY columns.
GeoRaptor: Importing a Shapefile into a table
Using GeoRaptor to Load Shapefile(s) into a table
GeoRaptor: Simple Mapping
A simple demonstration of how to map SDO_GEOMETRY data from two different sources.