Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (20)
- All (400)
- Biography (1)
- Blog (45)
- Business Requirements (1)
- Commentary (1)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (13)
- GPS (1)
- Image Processing (2)
- Import Export (8)
- Licensing (2)
- LiDAR (1)
- Linear Referencing (4)
- Manifold GIS (3)
- Mapping (1)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (4)
- Open Source (18)
- Oracle Spatial and Locator (193)
- Partitioning (1)
- PostGIS (34)
- Projections (1)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (35)
- Space Curves (9)
- Spatial Database Functions (108)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (92)
- Standards (3)
- Stored Procedure (15)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
Loading Shapefiles (SHP) into Oracle Spatial
When working with SHP files be aware that polygon data with holes or multi-part polygons (with/without hole) can often have holes (2003) and multi-parts (1003) with the wrong rotation. Wrong rotation is for outer shells (1003) that means Clockwise as against Clockwise and for inner shells or holes (2003) this means anti-clockwise when they should be clockwise. Many shape to Oracle loading tools will not correct this (not even MapBuilder’s shapefile loader). So, unless you know that your loader is correcting the rotation I would run MDSYS.SDO_GEOM.SDO_UNION against the loaded polygons to ensure that they are correct.
So, after loading, if multi-part polygons (sdo_gtype X007) are appearing as single-part polygons (sdo_gtype x003) with sdo_elem_info showing the disparate parts appearing as holes (2003 when they should be 1003), then do this:
update <my_table> a set a.<geom_column> = mdsys.sdo_geom.sdo_union(a.<geom_column>,a.<geom_column>,<your tolerance>); commit;
Documentation
- MySQL Spatial General Function Documentation
- Oracle LRS Object Documentation
- Oracle Spatial Exporter Package Documentation
- Oracle Spatial Object Function Documentation
- Oracle Spatial Object Function Documentation (Multi Page Version)
- PostGIS pl/pgSQL Function Documentation
- SC4O Oracle Java Topology Suite (Stored Procedures) Package Documentation
- SQL Server Spatial General TSQL Function Documentation
- SQL Server Spatial LRS TSQL Function Documentation