Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I'm new to Oracle Spatial. In MySQL or PostGIS, it's easy to get minx miny maxx maxy of a geometry, any and/or all of them. But how to do that in Oracle Spatial?

Do I need to chain up several functions and properties to get any of them? Well this doesn't make sense to me.

Thanks in advance.

share|improve this question

1 Answer 1

up vote 4 down vote accepted

There are various functions you can use to get the minimum bounding rectangle in Oracle Spatial:

  • SDO_GEOM.SDO_MBR
  • SDO_MIN_MBR_ORDINATE
  • SDO_MAX_MBR_ORDINATE

There are lots of examples here:

http://www.spatialdbadvisor.com/oracle_spatial_tips_tricks/55/oracle-locator-vs-enterprise-licensing-the-sdogeom-package

in section 2, which hopefully will help. It depends a bit what you're trying to get as to which one you would use. I generally end up using SDO_GEOM.SDO_MBR most of the time but you do usually end up with a few functions chained together as you say.

share|improve this answer
    
Thanks! However, it's a bit frustrated to hear that chaining up is the only solution. –  Jackey Cheung Oct 17 '12 at 9:58

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.