REALLY New to spatial...
So I am trying to get a handle on this.
Latest version of Oracle EE w/Spatial
I point in space that I know the long/lat, compass direction and speed from a single observation call this P1.
I have a rectangle that I have derived from two pairs of lon/lat points so it is UpperLeft(long,lat) LowerRight(long,lat).
Assume the rectangle is 10km by 1 km
- I want to determine if P1's projected direction of travel will cross the rectangle.
- I want to determine the distance that P1 is from the center of the rectangle so I can determine the ETA of P1.
If I have a table that has a column of sdo_geometry column that will describe the rectangle and I believe it should be an SDO_GTYPE of 2003.
Should I simply store the upper right and lower left pairs as long/lat? If so what sort of spatial query function(s) would I use to figure this out.
Thanks very much in advance.