Split mutipolygon into smaller geometries?
539040May 20 2008 — edited Jul 3 2008I am trying to use a combination of Oracle Spatial, GeoServer, and Google Maps to display some GIS data. The data came from a 3rd party in the form on a shapefile. I converted the shapefile to a SQL script using shp2sdo and loaded the result into Oracle. The system seems to work correctly, but it is very slow. One theory I have for why it is slow is that the spatial data is organized into a small number of very large multipolygons; basically one per US state. From my analysis, this causes Oracle to respond to GeoServer with very large result sets that are identical for every bounding box within the same state. This seems very inefficient to me.
To address this problem I have concocted the idea to split the large multipolygons into smaller geometries. Is this a decent idea and, if so, how do I go about it?