PSRC VMT Intertract Summary
City of Seattle
@usgov.city_of_seattle_psrc_vmt_intertract_summary
City of Seattle
@usgov.city_of_seattle_psrc_vmt_intertract_summary
CREATE TABLE table_1 (
"objectid1" BIGINT,
"objectid" BIGINT,
"wtr_name" VARCHAR,
"statefp10" BIGINT,
"countyfp10" BIGINT,
"tractce10" BIGINT,
"geoid10" BIGINT,
"name10" DOUBLE,
"namelsad10" VARCHAR,
"mtfcc10" VARCHAR,
"funcstat10" VARCHAR,
"aland10" BIGINT,
"awater10" BIGINT,
"intptlat10" DOUBLE,
"intptlon10" DOUBLE,
"acres_land" DOUBLE,
"acres_water" DOUBLE,
"se_anno_cad_data" VARCHAR,
"geoid10_dbl" BIGINT,
"tract10_dbl" BIGINT,
"join_objectid" BIGINT,
"tractce101" BIGINT,
"vmt_light" DOUBLE,
"vmt_med" DOUBLE,
"vmt_hvy" DOUBLE,
"vmt_total" DOUBLE,
"co2e_light" DOUBLE,
"co2e_med" DOUBLE,
"co2e_hvy" DOUBLE,
"co2e_total" DOUBLE,
"co2e_total1" DOUBLE,
"year" BIGINT,
"year_txt" BIGINT,
"shape_area" DOUBLE,
"shape_length" DOUBLE
);
Anyone who has the link will be able to view this.