Tag Archives: gis

Spatial DB Advisor

June 18th, 2009 – 01:43 PM

PL/SQL package: lessons learned
Working with Oracle Spatial a lot, I found a great source of information in the Spatial DB Advisor, which besides a lot of interesting articles, also offers his source-code and PL/SQL packages for free. The site is not very user-friendly (trouble of seeing the threes through the wood), as finding the free [...]

By Nathan | Posted in Technology | Also tagged , , | Comments (0)

fixing the geometric metadata and spatial indexes

May 3rd, 2009 – 08:24 AM

When storing spatial data into Oracle, there are a few steps one needs to complete (as shown here too):

insert the data (obviously)
update the USER_SDO_GEOM_METADATA table. This table specifies for each column the bounding box and the SRID (coordinate system).
create a spatial index

I have created a script to this automatically for me, once [...]

By Nathan | Posted in Uncategorized | Also tagged , | Comments (0)