Oracle Spatial - Creating geometry
From: Norbert Pürringer <thalion77_at_graffiti.net>
Date: Thu, 19 Aug 2010 01:27:34 -0700 (PDT)
Message-ID: <342981ef-7235-4045-9fd3-1387ab0bef27_at_i31g2000yqm.googlegroups.com>
Hello,
Date: Thu, 19 Aug 2010 01:27:34 -0700 (PDT)
Message-ID: <342981ef-7235-4045-9fd3-1387ab0bef27_at_i31g2000yqm.googlegroups.com>
Hello,
maybe I'm lucky to find here any Oracle Spatial experts.
I would like to know if it is possible to create SDO_GEOMETRY objects by reading the coordinates out of simple number attributes for latitude and longitude using a simple sql script.
e.g. Point object:
The GEOM field is of type SDO_GEOMETRY and should be initialized by reading the coordinates out of the NUMBER field LAT and LON:
ID LAT LON GEOM
1 47 12 null
GEOM should be initialized with the object value:
SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(47, 11, NULL), NULL, NULL)
Regards,
Norbert
Received on Thu Aug 19 2010 - 03:27:34 CDT