Name: Protected FSS Earth Station Registration (Complete Dataset)
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Protected FSS Earth Station Registration (Complete Dataset)

Daily transfer of FSS earth station antenna sites registered in the Fixed-Satellite Service Antenna Registration System (FSS ARS).
Organization: Federal Communications Commission
Last updated: 2020-11-12T13:20:18.524536
Tags: 3-5-ghz, fss-ars

Tables

Table 1

@usgov.fcc_gov_protected_fss_earth_station_registration_complete.table_1

36 kB
468 rows
20 columns

CREATE TABLE table_1 (
  "registration_number" VARCHAR,
  "location_status" VARCHAR,
  "licensee_name" VARCHAR,
  "call_sign" VARCHAR,
  "latitude_dms" VARCHAR,
  "longitude_dms" VARCHAR,
  "latitude_decimal" DOUBLE,
  "longitude_decimal" DOUBLE,
  "lower_frequency_mhz" DOUBLE  -- Lower Frequency (MHz),
  "upper_frequency_mhz" DOUBLE  -- Upper Frequency (MHz),
  "pointing_azimuth_degrees" DOUBLE  -- Pointing Azimuth (degrees),
  "pointing_elevation_angle_degrees" DOUBLE  -- Pointing Elevation Angle (degrees),
  "antenna_gain_dbi" DOUBLE  -- Antenna Gain (dBi),
  "antenna_site_elevation_meters" DOUBLE  -- Antenna Site Elevation (meters),
  "antenna_height_agl_meters" DOUBLE  -- Antenna Height AGL (meters),
  "antenna_height_amsl_meters" DOUBLE  -- Antenna Height AMSL (meters),
  "gso_satellite_longitude_decimal_degrees_e_w" DOUBLE  -- GSO Satellite Longitude Decimal Degrees (+E,-W),
  "use_for_tracking_telemetry_and_command" BOOLEAN  -- Use For Tracking, Telemetry And Command,
  "certification_date" TIMESTAMP,
  "registration_last_updated" VARCHAR
);