31.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 31-2 CIRCLE_POLYGON Parameters

Parameter	Description
p_lon	Longitude position of the lower left point.
p_lat	Latitude position of the lower left point.
`p_radius`	Radius of the circle in meters.
`p_arc_tolerance`	Arc tolerance (default 20).
p_srid	Reference system (default c_wgs_84).

Returns

Table 31-3 CIRCLE_POLYGON Function Returns

Return	Description
`mdsys.sdo_geometry`	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