Clean Transportation Program
State of California
@usgov.ca_gov_clean_transportation_program
State of California
@usgov.ca_gov_clean_transportation_program
CREATE TABLE table_1 (
"objectid" BIGINT,
"num" VARCHAR,
"arfvtp_id" VARCHAR,
"agreement_number" VARCHAR,
"project_number" VARCHAR,
"recipient_contractor" VARCHAR,
"project_title" VARCHAR,
"project_amount" DOUBLE,
"project_type" VARCHAR,
"fuel_type" VARCHAR,
"supply_chain_phase" VARCHAR,
"rdd_d_phase" VARCHAR,
"status" VARCHAR,
"project_address" VARCHAR,
"project_city" VARCHAR,
"project_state" VARCHAR,
"project_zip" DOUBLE,
"full_address" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"confidence" VARCHAR,
"county" VARCHAR,
"senate_district" VARCHAR,
"senate_sort" DOUBLE,
"assembly_district" VARCHAR,
"air_district" VARCHAR,
"electric_service_area" VARCHAR,
"disadvantaged_community_oehha" VARCHAR,
"disadvantaged_community_sb535" VARCHAR,
"low_income_sb535" VARCHAR,
"ces_score" DOUBLE,
"ces_percentile" DOUBLE,
"ces_percentile_range" VARCHAR,
"assembly_sort" DOUBLE,
"project_location" VARCHAR,
"lowincome_sb1000" VARCHAR,
"fiscal_year" VARCHAR,
"dac_oehha_and_lic_sb1000" VARCHAR,
"dac_carb_lic_carb" VARCHAR,
"disadvantaged_community_ces3" VARCHAR,
"disadvantaged_community_ces4" VARCHAR,
"x" DOUBLE,
"y" DOUBLE
);
Anyone who has the link will be able to view this.