Category Archives: SQL

How to Load a Shapefile in to Oracle Spatial

Please note that you cannot just insert a Shapefile in to Oracle and expect the geometries to be stored and indexed properly! Therefore, you’ve got to use a set of “special” tools to insert the data in to Oracle Spatial. [...]

Posted in Database, SQL | Tagged , , , | Leave a comment

Microsoft SQL Server 2008 Spatial Examples

I’ve recently had the pleasure of being able to play with SQL Server 2008 that, of course, has spatial support. There are two types of geometries that are fully supported…that being the classic OGC simple geometry types and then Microsoft’s [...]

Posted in Microsoft, SQL | Tagged , | Leave a comment