Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Coordinate System Transformation

717958Aug 18 2009 — edited Aug 20 2009
I use oracle enterprise 10.2.0.1

I am trying to convert our ArcSDE that sit on top of oracle RDBM database, which is used to display the earth map to oracle spatial database. I have longitude, latitude and altitude data for an Area (Rectangle shape) that I would like to insert into a GEOM type column. I've been going through the spatial reference guide, which has a lots of information. My question is can I use this stmt to insert data for a rectangle shape with longitude/Latitude data?

INSERT INTO target_point VALUES(
1,
'cola_a',
MDSYS.SDO_GEOMETRY(
2003, -- 2-dimensional polygon
NULL,
NULL,
MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3), -- one rectangle (1003 = exterior)
MDSYS.SDO_ORDINATE_ARRAY(1,1, 5,7) -- only 2 points needed to
-- define rectangle (lower left and upper right) with
-- Cartesian-coordinate data
)
);

I also want to know what is the different between this and the following stmt, which store all the vertices?

INSERT INTO cola_markets_cs VALUES(
1,
'cola_a',
SDO_GEOMETRY(
2003, -- two-dimensional polygon
8307, -- SRID for 'Longitude / Latitude (WGS 84)' coordinate system
NULL,
SDO_ELEM_INFO_ARRAY(1,1003,1), -- polygon
SDO_ORDINATE_ARRAY(1,1, 5,1, 5,7, 1,7, 1,1) -- All vertices must
-- be defined for rectangle with geodetic data.
)
);


I am new to spatial database and trying to learn. Appreciate any help.

thanks
This post has been answered by Siva Ravada-Oracle on Aug 20 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2009
Added on Aug 18 2009
7 comments
1,253 views