Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

NASA Data Model

Navigation: Schema: NASA > Tables

asteroids: NASA Asteroids

Contents Previous Home Next More

Catalog: NASA

Schema: NASA

Primary Keys: id

Label: Asteroids

This is a read-only table function. The NASA API may not support changing the data or the Invantive SQL driver for NASA does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the NASA API.

Select NASA API URL: neo/rest/v1/neo/{asteroid_id}

Insert NASA API URL: neo/rest/v1/neo/{asteroid_id}

Update NASA API URL: neo/rest/v1/neo/{asteroid_id}

Delete NASA API URL: neo/rest/v1/neo/{asteroid_id}

Field Selection Method: NotRequired

Table Function Parameters

The following parameters can be used to control the behaviour of the table function asteroids. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be treated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example with `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name

Data Type

Required

Default Value

Documentation

asteroid_id

int64

 

 

 

Table Function Columns

The columns of the table function asteroids are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

absolute_magnitude_h

decimal

 

 

close_approach_date

datetime

 

 

close_approach_epoch_date

int64

 

 

close_approach_miss_distance_astronomical

string

 

 

close_approach_miss_distance_kilometers

string

 

 

close_approach_miss_distance_lunar

string

 

 

close_approach_miss_distance_miles

string

 

 

close_approach_orbiting_body

string

 

 

close_approach_relative_velocity_kilometers_per_hour

string

 

 

close_approach_relative_velocity_kilometers_per_second

string

 

 

close_approach_relative_velocity_miles_per_hour

string

 

 

estimated_diameter_feet_max

string

 

 

estimated_diameter_feet_min

string

 

 

estimated_diameter_kilometers_max

string

 

 

estimated_diameter_kilometers_min

string

 

 

estimated_diameter_meters_max

string

 

 

estimated_diameter_meters_min

string

 

 

estimated_diameter_miles_max

string

 

 

estimated_diameter_miles_min

string

 

 

is_potentially_hazardous_asteroid

boolean

 

 

name

string

 

 

nasa_jpl_url

string

 

 

neo_reference_id

string

 

 

orbital_data_aphelion_distance

string

 

 

orbital_data_ascending_node_longitude

string

 

 

orbital_data_eccentricity

string

 

 

orbital_data_epoch_osculation

string

 

 

orbital_data_equinox

string

 

 

orbital_data_inclination

string

 

 

orbital_data_jupiter_tisserand_invariant

string

 

 

orbital_data_mean_anomaly

string

 

 

orbital_data_mean_motion

string

 

 

orbital_data_minimum_orbit_intersection

string

 

 

orbital_data_orbit_determination_date

datetime

 

 

orbital_data_orbit_id

int32

 

 

orbital_data_orbit_uncertainty

string

 

 

orbital_data_orbital_period

string

 

 

orbital_data_perihelion_argument

string

 

 

orbital_data_perihelion_distance

string

 

 

orbital_data_perihelion_time

string

 

 

orbital_data_semi_major_axis

string

 

 

 

12-12-2020 18:58 Version 20.1.301-BETA+3023