A totally arbitrary set of notes themed around various topics of software development widely ranging from code examples and how-to's to development processes and maybe even some computing-inspired philosophical musings.
"It's an island, babe. If you don't bring it here, you won't find it here."
"Whoa, heavy. Pilot and philosopher!"
(From the Six Days Seven Nights movie)
Wednesday, 13 April 2016
Various tips on Oracle Spatial
When creating a spatial index on a table with SDO_GEOMETRY, one of the required parameters is LAYER_GTYPE.
How to find GTYPE of SDO_GEOMETRY objects in a table:
select sdo_geometry.get_gtype(geom), count(*) from map_data.zip_geom group by sdo_geometry.get_gtype(geom)
/
No comments:
Post a Comment