Tag Archives: gis

Spatial DB Advisor

%B %e%q, %Y – %I:%M %p

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 [...]

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

fixing the geometric metadata and spatial indexes

%B %e%q, %Y – %I:%M %p

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, [...]

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