Name: Connecticut Airports FAA
Creator: US Government
License: http://www.opendefinition.org/licenses/cc-zero

About this Dataset

Connecticut Airports FAA

Point features of airports in Connecticut, based on Federal Aviation Administration records.
Organization: State of Connecticut
Last updated: 2024-02-09T15:48:52.602850
Tags: airport, connecticut, ct, ctdeep, deep, faa, federal-aviation-administration, transportation

Tables

Table 1

@usgov.state_of_connecticut_connecticut_airports_faa_9a1f7.table_1

115.67 kB
153 rows
109 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "locationid" VARCHAR,
  "latitudedd" DOUBLE,
  "latitudes" DOUBLE,
  "longitudedd" DOUBLE,
  "longitudes" DOUBLE,
  "sitenumber" VARCHAR,
  "type" VARCHAR,
  "effectivedate" TIMESTAMP,
  "region" VARCHAR,
  "districtoffice" VARCHAR,
  "state" VARCHAR,
  "statename" VARCHAR,
  "county" VARCHAR,
  "countystate" VARCHAR,
  "city" VARCHAR,
  "facilityname" VARCHAR,
  "ownership" VARCHAR,
  "use" VARCHAR,
  "owner" VARCHAR,
  "owneraddress" VARCHAR,
  "ownercsz" VARCHAR,
  "ownerphone" VARCHAR,
  "manager" VARCHAR,
  "manageraddress" VARCHAR,
  "managercsz" VARCHAR,
  "managerphone" VARCHAR,
  "arplatitude" VARCHAR,
  "arplatitudes" VARCHAR,
  "arplongitude" VARCHAR,
  "arplongitudes" VARCHAR,
  "arpmethod" VARCHAR,
  "arpelevation" BIGINT,
  "arpelevationmethod" VARCHAR,
  "magneticvariation" VARCHAR,
  "magneticvariationyear" DOUBLE,
  "trafficpatternaltitude" DOUBLE,
  "chartname" VARCHAR,
  "distancefromcbd" DOUBLE,
  "directionfromcbd" VARCHAR,
  "landareacoveredbyairport" DOUBLE,
  "boundaryartccid" VARCHAR,
  "boundaryartcccomputerid" VARCHAR,
  "boundaryartccname" VARCHAR,
  "responsibleartccid" VARCHAR,
  "responsibleartcccomputerid" VARCHAR,
  "responsibleartccname" VARCHAR,
  "tieinfss" VARCHAR,
  "tieinfssid" VARCHAR,
  "tieinfssname" VARCHAR,
  "airporttofssphonenumber" VARCHAR,
  "tieinfsstollfreenumber" VARCHAR,
  "alternatefssid" VARCHAR,
  "alternatefssname" VARCHAR,
  "alternatefsstollfreenumber" VARCHAR,
  "notamfacilityid" VARCHAR,
  "notamservice" VARCHAR,
  "activiationdate" TIMESTAMP,
  "airportstatuscode" VARCHAR,
  "certificationtypedate" VARCHAR,
  "federalagreements" VARCHAR,
  "airspacedetermination" VARCHAR,
  "customsairportofentry" VARCHAR,
  "customslandingrights" VARCHAR,
  "militaryjointuse" VARCHAR,
  "militarylandingrights" VARCHAR,
  "nationalemergencystatus" VARCHAR,
  "nationalemergencyinterest" VARCHAR,
  "inspectionmethod" DOUBLE,
  "inspectiongroup" VARCHAR,
  "lastinspectiondate" DOUBLE,
  "lastownerinformationdate" DOUBLE,
  "fueltypes" VARCHAR,
  "airframerepair" VARCHAR,
  "powerplantrepair" VARCHAR,
  "bottledoxygentype" VARCHAR,
  "bulkoxygentype" VARCHAR,
  "lightingschedule" VARCHAR,
  "atct" VARCHAR,
  "unicomfrequencies" DOUBLE,
  "ctaffrequency" DOUBLE,
  "segmentedcircle" VARCHAR,
  "beaconcolor" VARCHAR,
  "noncommerciallandingfee" VARCHAR,
  "medicaluse" VARCHAR,
  "singleenginega" DOUBLE,
  "multienginega" DOUBLE,
  "jetenginega" DOUBLE,
  "helicoptersga" DOUBLE,
  "glidersoperational" DOUBLE,
  "militaryoperational" DOUBLE,
  "ultralights" DOUBLE,
  "operationscommercial" DOUBLE,
  "operationscommuter" VARCHAR,
  "operationsairtaxi" DOUBLE,
  "operationsgalocal" DOUBLE,
  "operationsgaitin" DOUBLE,
  "operationsmilitary" DOUBLE
);