Stations That Meet NEVI Requirements (March 2024)
State of California
@usgov.ca_gov_stations_that_meet_nevi_requirements_march_2024_a912d
State of California
@usgov.ca_gov_stations_that_meet_nevi_requirements_march_2024_a912d
CREATE TABLE table_1 (
"x" DOUBLE,
"y" DOUBLE,
"objectid_1" BIGINT,
"stationdesignation" VARCHAR,
"fueltypecode" VARCHAR,
"stationname" VARCHAR,
"streetaddress" VARCHAR,
"intersectiondirections" VARCHAR,
"city_1" VARCHAR,
"state" VARCHAR,
"zip_1" BIGINT,
"plus4" VARCHAR,
"stationphone" VARCHAR,
"statuscode" VARCHAR,
"expecteddate" VARCHAR,
"groupswithaccesscode" VARCHAR,
"accessdaystime" VARCHAR,
"cardsaccepted" VARCHAR,
"bdblends" VARCHAR,
"ngfilltypecode" VARCHAR,
"ngpsi" VARCHAR,
"evlevel1evsenum" VARCHAR,
"evlevel2evsenum" DOUBLE,
"evdcfastcount" BIGINT,
"evotherinfo" VARCHAR,
"evnetwork" VARCHAR,
"evnetworkweb" VARCHAR,
"geocodestatus" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"datelastconfirmed" TIMESTAMP,
"id" BIGINT,
"updatedat" TIMESTAMP,
"ownertypecode" VARCHAR,
"federalagencyid" VARCHAR,
"federalagencyname" VARCHAR,
"opendate" TIMESTAMP,
"hydrogenstatuslink" VARCHAR,
"ngvehicleclass" VARCHAR,
"lpgprimary" VARCHAR,
"e85blenderpump" VARCHAR,
"evconnectortypes" VARCHAR,
"country" VARCHAR,
"intersectiondirectionsfrench" VARCHAR,
"accessdaystimefrench" VARCHAR,
"bdblendsfrench" VARCHAR,
"groupswithaccesscodefrench" VARCHAR,
"hydrogenisretail" VARCHAR,
"accesscode" VARCHAR,
"accessdetailcode" VARCHAR,
"federalagencycode" VARCHAR,
"facilitytype" VARCHAR,
"cngdispensernum" VARCHAR,
"cngonsiterenewablesource" VARCHAR,
"cngtotalcompressioncapacity" VARCHAR,
"cngstoragecapacity" VARCHAR,
"lngonsiterenewablesource" VARCHAR,
"e85otherethanolblends" VARCHAR,
"evpricing" VARCHAR,
"evpricingfrench" VARCHAR,
"lpgnozzletypes" VARCHAR,
"hydrogenpressures" VARCHAR,
"hydrogenstandards" VARCHAR,
"cngfilltypecode" VARCHAR,
"cngpsi" VARCHAR,
"cngvehicleclass" VARCHAR,
"lngvehicleclass" VARCHAR,
"evonsiterenewablesource" VARCHAR,
"restrictedaccess" VARCHAR,
"rdblends" VARCHAR,
"rdblendsfrench" VARCHAR,
"rdblendedwithbiodiesel" VARCHAR,
"rdmaximumbiodiesellevel" VARCHAR,
"npsunitname" VARCHAR,
"cngstationsellsrenewablenatural" VARCHAR,
"lngstationsellsrenewablenatural" VARCHAR,
"maximumvehicleclass" VARCHAR,
"evworkplacecharging" BOOLEAN,
"evtotalportcountbeta" BIGINT,
"evchademoportcountbeta" BIGINT,
"evj1772portcountbeta" BIGINT,
"evccsportcountbeta" BIGINT,
"evnema1450portcountbeta" BIGINT,
"evnema515portcountbeta" BIGINT,
"evnema520portcountbeta" BIGINT,
"evteslaportcountbeta" BIGINT,
"evccs150pluskwportcountbeta" BIGINT
);
Anyone who has the link will be able to view this.