Table To Ellipse (Data Management)

Summary

Creates a feature class containing geodetic or planar ellipses from the values in an x-coordinate field, y-coordinate field, major axis and minor axis fields, and azimuth field of a table.

Illustration

Table To Ellipse tool illustration

Usage

  • Output ellipses are constructed from field values. The field values include the following:

    • The x- and y-coordinates of a center point
    • The major and minor axis lengths
    • The azimuth angle
    The fields and their values will be included in the output.

  • When the output ellipsis are geodetic, the x- and y-coordinates and the lengths of the major and minor axes are measured on the surface of the earth, and the azimuth angle is measured from north. When the output ellipsis are planar, the x- and y-coordinates and the lengths of the major and minor axes are measured on the projected plane, and the azimuth angle is measured clockwise from grid north (vertical up on the map).

  • A geodetic ellipse is a curve on the surface of the earth. However, a geodetic ellipse feature is not stored as a parametric (true) curve in the output; it is stored as a densified polyline representing the path of the geodetic ellipse.

  • If you specify the same field for both the Major Field and Minor Field parameters, or if the values in both fields are equal, the output features represent geodetic circles.

  • When the output is a feature class in a geodatabase, the values in the Shape_Length field are always in the units of the output coordinate system specified by the Spatial Reference parameter, and they are the planar lengths of the polylines. To measure a geodesic length or distance, use the ArcGIS AllSource Measure tool and choose the Geodesic, Loxodrome, or Great Elliptic option accordingly before taking a measurement.

  • By default, the output will be a line feature class. To create a polygon feature class, specify the Geometry Type parameter value as Polygon.

Parameters

LabelExplanationData Type
Input Table

The input table. It can be a text file, CSV file, Excel file, dBASE table, or geodatabase table.

Table View
Output Feature Class

The output feature class that will contain geodetic or planar ellipses.

Feature Class
X Field

A numerical field in the input table containing the x-coordinates (or longitudes) of the center points of ellipses to be positioned in the output coordinate system specified by the Spatial Reference parameter.

Field
Y Field

A numerical field in the input table containing the y-coordinates (or latitudes) of the center points of ellipses to be positioned in the output coordinate system specified by the Spatial Reference parameter.

Field
Major Field

A numerical field in the input table containing major axis lengths of the ellipses.

Field
Minor Field

A numerical field in the input table containing minor axis lengths of the ellipses.

Field
Distance Units

Specifies the units that will be used for the Major Field and Minor Field parameters.

  • MetersThe units will be meters.
  • KilometersThe units will be kilometers.
  • MilesThe units will be miles.
  • Nautical milesThe units will be nautical miles.
  • FeetThe units will be feet.
  • U.S. survey feetThe units will be U.S. survey feet.
String
Azimuth Field
(Optional)

A numerical field in the input table containing azimuth angle values for the major axis rotations of the output ellipses. The values are measured clockwise from north.

Field
Azimuth Units
(Optional)

Specifies the units that will be used for the Azimuth Field parameter.

  • Decimal degrees The units will be decimal degrees. This is the default.
  • MilsThe units will be mils.
  • RadiansThe units will be radians.
  • GradiansThe units will be gradians.
String
ID
(Optional)

A field in the input table. This field and the values are included in the output and can be used to join the output features with the records in the input table.

Field
Spatial Reference
(Optional)

The spatial reference of the output feature class. The default is GCS_WGS_1984 or the input coordinate system if it is not Unknown.

Spatial Reference
Preserve attributes
(Optional)

Specifies whether the remaining input fields will be added to the output feature class.

  • Unchecked—The remaining input fields will not be added to the output feature class. This is the default.
  • Checked—The remaining input fields will be added to the output feature class. A new field, ORIG_FID, will also be added to the output feature class to store the input feature ID values.

Boolean
Geometry Type
(Optional)

Specifies the geometry type for the output feature class.

  • LineAn output polyline feature class will be created. This is the default.
  • PolygonAn output polygon feature class will be created.
String
Method
(Optional)

Specifies whether the ellipse will be generated based on geodesic or planar measurements.

  • GeodesicA geodesic ellipse will be generated. The ellipse will accurately represent the shape on the surface of the earth. This is the default.
  • PlanarA planar ellipse will be generated on the projected plane. It usually does not accurately represent the shape on the surface of the earth as a geodesic ellipse does. This option is not available for geographic coordinate systems.
String

arcpy.management.TableToEllipse(in_table, out_featureclass, x_field, y_field, major_field, minor_field, distance_units, {azimuth_field}, {azimuth_units}, {id_field}, {spatial_reference}, {attributes}, {geometry_type}, {method})
NameExplanationData Type
in_table

The input table. It can be a text file, CSV file, Excel file, dBASE table, or geodatabase table.

Table View
out_featureclass

The output feature class that will contain geodetic or planar ellipses.

Feature Class
x_field

A numerical field in the input table containing the x-coordinates (or longitudes) of the center points of ellipses to be positioned in the output coordinate system specified by the spatial_reference parameter.

Field
y_field

A numerical field in the input table containing the y-coordinates (or latitudes) of the center points of ellipses to be positioned in the output coordinate system specified by the spatial_reference parameter.

Field
major_field

A numerical field in the input table containing major axis lengths of the ellipses.

Field
minor_field

A numerical field in the input table containing minor axis lengths of the ellipses.

Field
distance_units

Specifies the units that will be used for the major_field and minor_field parameters.

  • METERSThe units will be meters.
  • KILOMETERSThe units will be kilometers.
  • MILESThe units will be miles.
  • NAUTICAL_MILESThe units will be nautical miles.
  • FEETThe units will be feet.
  • US_SURVEY_FEETThe units will be U.S. survey feet.
String
azimuth_field
(Optional)

A numerical field in the input table containing azimuth angle values for the major axis rotations of the output ellipses. The values are measured clockwise from north.

Field
azimuth_units
(Optional)

Specifies the units that will be used for the azimuth_field parameter.

  • DEGREES The units will be decimal degrees. This is the default.
  • MILSThe units will be mils.
  • RADSThe units will be radians.
  • GRADSThe units will be gradians.
String
id_field
(Optional)

A field in the input table. This field and the values are included in the output and can be used to join the output features with the records in the input table.

Field
spatial_reference
(Optional)

The spatial reference of the output feature class. A spatial reference can be specified as any of the following:

  • The path to a .prj file, such as C:/workspace/watershed.prj
  • The path to a feature class or feature dataset whose spatial reference you want to apply, such as C:/workspace/myproject.gdb/landuse/grassland
  • A SpatialReference object, such as arcpy.SpatialReference("C:/data/Africa/Carthage.prj")

Spatial Reference
attributes
(Optional)

Specifies whether the remaining input fields will be added to the output feature class.

  • NO_ATTRIBUTESThe remaining input fields will not be added to the output feature class. This is the default.
  • ATTRIBUTESThe remaining input fields will be added to the output feature class. A new field, ORIG_FID, will also be added to the output feature class to store the input feature ID values.
Boolean
geometry_type
(Optional)

Specifies the geometry type for the output feature class.

  • LINEAn output polyline feature class will be created. This is the default.
  • POLYGONAn output polygon feature class will be created.
String
method
(Optional)

Specifies whether the ellipse will be generated based on geodesic or planar measurements.

  • GEODESICA geodesic ellipse will be generated. The ellipse will accurately represent the shape on the surface of the earth. This is the default.
  • PLANARA planar ellipse will be generated on the projected plane. It usually does not accurately represent the shape on the surface of the earth as a geodesic ellipse does. This option is not available for geographic coordinate systems.
String

Code sample

TableToEllipse example (stand-alone script)

Create a polyline ellipse feature from a table.

# Import system modules
import arcpy

# Set local variables
input_table = r'c:\workspace\SGS\eltop.gdb\elret'
output_ellipse = r'c:\workspace\SGS\eltop.gdb\Eplyln_001'

# Run Table To Ellipse
arcpy.management.TableToEllipse(input_table, output_ellipse, 'lond', 'latd', 
                                'mjerr', 'mnerr', 'KILOMETERS', 'orient', 
                                'DEGREES', 'LinkID')

Related topics