39.3 CIRCLE_POLYGON Function
This function creates a polygon that approximates a circle at (p_lon
, p_lat
) with radius of p_radius
. See mdsys.sdo_util.circle_polygon
for details.
Syntax
APEX_SPATIAL.CIRCLE_POLYGON (
p_lon IN NUMBER,
p_lat IN NUMBER,
p_radius IN NUMBER,
p_arc_tolerance IN NUMBER DEFAULT 20,
p_srid IN t_srid DEFAULT c_wgs_84 )
RETURN mdsys.sdo_geometry;
Parameters
Table 39-2 CIRCLE_POLYGON Parameters
Parameter | Description |
---|---|
p_lon |
Longitude position of the lower left point. |
p_lat |
Latitude position of the lower left point. |
|
Radius of the circle in meters. |
|
Arc tolerance (default 20). |
p_srid |
Reference system (default c_wgs_84). |
Returns
Table 39-3 CIRCLE_POLYGON Function Returns
Return | Description |
---|---|
|
The geometry for the polygon that approximates the circle. |
Example
This example is a query that returns a polygon that approximates a circle at (0, 0) with radius 1.
select apex_spatial.circle_polygon(0, 0, 1) from dual
Parent topic: APEX_SPATIAL