Solar Output Prediction Using Weather Data

zip Zip	city City	state State	latitude Latitude	longitude Longitude	timezone Timezone	dst Dst
210	Portsmouth	NH	43.005895	-71.013202	-5	1
211	Portsmouth	NH	43.005895	-71.013202	-5	1
212	Portsmouth	NH	43.005895	-71.013202	-5	1
213	Portsmouth	NH	43.005895	-71.013202	-5	1
214	Portsmouth	NH	43.005895	-71.013202	-5	1
215	Portsmouth	NH	43.005895	-71.013202	-5	1
501	Holtsville	NY	40.922326	-72.637078	-5	1
544	Holtsville	NY	40.922326	-72.637078	-5	1
601	Adjuntas	PR	18.180103	-66.74947	-4
602	Aguada	PR	18.363285	-67.18024	-4


CREATE TABLE erle_zipcodes (
  "zip" BIGINT,
  "city" VARCHAR,
  "state" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "timezone" BIGINT,
  "dst" BIGINT
);