Runways
Federal Geographic Data Committee
@usgov.fgdc_gov_runways_4b1eb
Federal Geographic Data Committee
@usgov.fgdc_gov_runways_4b1eb
CREATE TABLE table_1 (
"oid" BIGINT,
"eff_date" TIMESTAMP,
"site_no" DOUBLE,
"site_type_code" VARCHAR,
"state_code" VARCHAR,
"arpt_id" VARCHAR,
"arpt_name" VARCHAR,
"city" VARCHAR,
"country_code" VARCHAR,
"ownership_type_code" VARCHAR,
"facility_use_code" VARCHAR,
"rwy_id" VARCHAR,
"lat1_decimal" DOUBLE,
"long1_decimal" DOUBLE,
"lat2_decimal" DOUBLE,
"long2_decimal" DOUBLE,
"rwy_len" BIGINT,
"rwy_width" BIGINT,
"surface_type_code" VARCHAR,
"cond" VARCHAR,
"treatment_code" VARCHAR,
"pcn" DOUBLE,
"pavement_type_code" VARCHAR,
"subgrade_strength_code" VARCHAR,
"tire_pres_code" VARCHAR,
"dtrm_method_code" VARCHAR,
"rwy_lgt_code" VARCHAR,
"rwy_len_source" VARCHAR,
"length_source_date" VARCHAR,
"gross_wt_sw" DOUBLE,
"gross_wt_dw" DOUBLE,
"gross_wt_dtw" DOUBLE,
"gross_wt_ddtw" DOUBLE,
"shape_area" DOUBLE,
"shape_length" DOUBLE
);
Anyone who has the link will be able to view this.