I have just uploaded a radically revised and improved VB6 code for accessing Oracle Spatial or Locator. In revising the code I came to appreciated something the Catholic priest who married my wife and I once said to me: “True scholarship requires leisure”. I have had the lesiure to revise the code and am horrifiedRead More
This tip comes from a question Atelier Cassini asked on the Directions Magazine discussion list. He writes: “I would like to create a box drawing around an image. Do I need to know the exact dimension of that image or can I draw it automatically?” While one cannot do this automatically, one can use aRead More
Folks, for a client GIS I use Manifold GIS. It is cheap, powerful, and if one normalises its functionality by cost (ie the ratio functionality/cost), it is the best value client GIS on the market. For a good understanding of its power one should read Dr Arthur Lembo Jnr’s Comparison with ArcGIS document. This documentRead More
It is common practice, when storing single point data in an sdo_geometry to always use its SDO_POINT structure and not the SDO_ORDINATES array. When indexing point data, for performance reasons, the use of the layer_gtype=point parameter is always recommended. So, if I have sdo_geometry objects constructed as follows: MDSYS.SDO_GEOMETRY(2001,NULL,MDSYS.SDO_POINT_TYPE(1,2,NULL),NULL,NULL) inside a table/column (say called “my_points”/”geometry”),Read More
Unpacking user_sdo_geom_metadata’s diminfo object. Objects in Oracle require special handling when querying. Firstly, Oracle says that, when querying something that contains an object, and you want to access one of the object’s elements (or fields), use of a table alias in a DML query is required. So, let’s say we want to discover all possibleRead More
Data quality in databases means using the power of the database’s referential integrity functionality to ensure that data is correct regardless as to what client is creating, updating or deleting data. One common requirement for spatial data in Oracle is to be able to ensure that the values of an sdo_geometry column in a tableRead More
I decided long ago that when I had my own website I would try and make it useful for all those technical people out there some of whom once I had the priviledge of managing. This particular page is dedicated to Tips and Tricks in relation to Oracle Spatial, Locator (including Oracle XE). It willRead More
Keywords testimonials Summary Testimonials, or what customers say about my work. Please note that the testimonials on this page are the personal views of the named people and may not an official view of the organisations they work for. Simon Danish Police The work Anette Rosengard Poulsen refers to below concerns the rebuilding of theirRead More
The most critical property of an image catalog that needs to be defined on its creation (using the Catalog Registry Tool) is the size of an individual tile. The scientific basis for what I am about to say was an published paper by Dr Peter R. Lamb (CSIRO Division of Information Technology) entitled: Tiling VeryRead More
A press release by Laser-Scan in the UK has announced that I am the first Certified Professional for their new Radius Studio product other than their own staff. This complements the skills I already have with their Radius Topology product. This is a great honour for me and it comes as a result of theRead More