Even old dogs like me forget things and have to learn them again. You know, I am sure that I knew that SDO_GEOM.RELATE was a Spatial licensed feature and not available in Locator, but I clean forgot until a situation with a customer required me to look at an alternative. The reason is because thisRead More
I received a question from a respected colleague: Can the parameters of a spatial index be altered? I created several dozen spatial indexes with a layer_gtype of polygon, I now have a requirement to modify them to be multipolygon…. My colleague wishes to do this without dropping the existing index. The answer to this isRead More
My EXPORTER package + Java code has functions called WriteExcelSpreadsheet that can be used to create and export any SQL SELECT statement to disk as an Excel Spreadsheet using Oracle database’s DBMS_JOB or DBMS_SCHEDULER. Because Excel Spreadsheets have limited number of rows (65535) and columns (255) per sheet (the maximum size of data in aRead More
My EXPORTER package + Java code has a function called WriteDelimitedTextfile that can be used to export any SQL SELECT statement to disk using Oracle database’s DBMS_JOB or DBMS_SCHEDULER. Yes, you can export to disk via pure PL/SQL but I have added this function to my EXPORTER to create an integrated solution for exports thatRead More
This is an old article that uses older custom code e.g. Vector2Geom(). Because the principles in the code are correct, I will bring the code up to date if anyone shows any interest. When investigating geometric or topological errors for linear or polygonal geometry objects, a range of tools are needed. Oracle has basic toolsRead More
Recently, using SQL Server 2008 (not R2), I came across an issue with hinting a SELECT statement with a spatial index. This particular issue is different from the one Bob Beauchem wrote about in his article On hinting spatial indexes and query complexity (in turn he references Isaac Kunen’s Is my spatial index being used?).Read More
I have had the need, over the years, to produce statistics that helped me decide how effective a change to a property of a spatial table or index might be. For example, with SQL Server 2008’s Spatial Index, for most sites, setting the right properties to get the best performance is a trial and errorRead More
I often hear asserted in discussions about accessing data in databases that the approach taken should be “database independent”. The assertion is always made as if it were some sort of Scientific Truth (Dogma even). And it is always assumed that this is easy to achieve. Finally, it always seems to be an accepted realityRead More
Java classes loaded into the Oracle JVM are interpreted when executed up to and including Oracle 10gR2. For Oracle 11g and upwards, these loaded Java classes can be compiled to native code. I have added the optional compilation of my JTS Java wrappers and the source JTS classes to the JTS installer. The installation isRead More
I have had the need, over the years, to produce statistics that helped me decide how effective a change to a property of a spatial table or index might be. Back in the old days of the Quad Tree index, I used a procedure like the following, to work out the best properties for aRead More