{"swagger":"2.0","info":{"version":"7.0.1 (d6050c8)","title":"PostgREST API","description":"standard public schema"},"host":"0.0.0.0:3000","basePath":"/","schemes":["http"],"consumes":["application/json","application/vnd.pgrst.object+json","text/csv"],"produces":["application/json","application/vnd.pgrst.object+json","text/csv"],"paths":{"/":{"get":{"tags":["Introspection"],"summary":"OpenAPI description (this document)","produces":["application/openapi+json","application/json"],"responses":{"200":{"description":"OK"}}}},"/projects":{"get":{"tags":["projects"],"parameters":[{"$ref":"#/parameters/rowFilter.projects.case_id"},{"$ref":"#/parameters/rowFilter.projects.multi_poly"},{"$ref":"#/parameters/rowFilter.projects.eia_id"},{"$ref":"#/parameters/rowFilter.projects.p_state"},{"$ref":"#/parameters/rowFilter.projects.p_county"},{"$ref":"#/parameters/rowFilter.projects.ylat"},{"$ref":"#/parameters/rowFilter.projects.xlong"},{"$ref":"#/parameters/rowFilter.projects.p_area"},{"$ref":"#/parameters/rowFilter.projects.p_img_date"},{"$ref":"#/parameters/rowFilter.projects.p_dig_conf"},{"$ref":"#/parameters/rowFilter.projects.p_name"},{"$ref":"#/parameters/rowFilter.projects.p_year"},{"$ref":"#/parameters/rowFilter.projects.p_pwr_reg"},{"$ref":"#/parameters/rowFilter.projects.p_tech_pri"},{"$ref":"#/parameters/rowFilter.projects.p_tech_sec"},{"$ref":"#/parameters/rowFilter.projects.p_axis"},{"$ref":"#/parameters/rowFilter.projects.p_azimuth"},{"$ref":"#/parameters/rowFilter.projects.p_tilt"},{"$ref":"#/parameters/rowFilter.projects.p_battery"},{"$ref":"#/parameters/rowFilter.projects.p_cap_ac"},{"$ref":"#/parameters/rowFilter.projects.p_cap_dc"},{"$ref":"#/parameters/rowFilter.projects.p_type"},{"$ref":"#/parameters/rowFilter.projects.p_agrivolt"},{"$ref":"#/parameters/rowFilter.projects.p_zscore"},{"$ref":"#/parameters/select"},{"$ref":"#/parameters/order"},{"$ref":"#/parameters/range"},{"$ref":"#/parameters/rangeUnit"},{"$ref":"#/parameters/offset"},{"$ref":"#/parameters/limit"},{"$ref":"#/parameters/preferCount"}],"responses":{"206":{"description":"Partial Content"},"200":{"schema":{"items":{"$ref":"#/definitions/projects"},"type":"array"},"description":"OK"}}},"post":{"tags":["projects"],"parameters":[{"$ref":"#/parameters/body.projects"},{"$ref":"#/parameters/select"},{"$ref":"#/parameters/preferReturn"}],"responses":{"201":{"description":"Created"}}},"delete":{"tags":["projects"],"parameters":[{"$ref":"#/parameters/rowFilter.projects.case_id"},{"$ref":"#/parameters/rowFilter.projects.multi_poly"},{"$ref":"#/parameters/rowFilter.projects.eia_id"},{"$ref":"#/parameters/rowFilter.projects.p_state"},{"$ref":"#/parameters/rowFilter.projects.p_county"},{"$ref":"#/parameters/rowFilter.projects.ylat"},{"$ref":"#/parameters/rowFilter.projects.xlong"},{"$ref":"#/parameters/rowFilter.projects.p_area"},{"$ref":"#/parameters/rowFilter.projects.p_img_date"},{"$ref":"#/parameters/rowFilter.projects.p_dig_conf"},{"$ref":"#/parameters/rowFilter.projects.p_name"},{"$ref":"#/parameters/rowFilter.projects.p_year"},{"$ref":"#/parameters/rowFilter.projects.p_pwr_reg"},{"$ref":"#/parameters/rowFilter.projects.p_tech_pri"},{"$ref":"#/parameters/rowFilter.projects.p_tech_sec"},{"$ref":"#/parameters/rowFilter.projects.p_axis"},{"$ref":"#/parameters/rowFilter.projects.p_azimuth"},{"$ref":"#/parameters/rowFilter.projects.p_tilt"},{"$ref":"#/parameters/rowFilter.projects.p_battery"},{"$ref":"#/parameters/rowFilter.projects.p_cap_ac"},{"$ref":"#/parameters/rowFilter.projects.p_cap_dc"},{"$ref":"#/parameters/rowFilter.projects.p_type"},{"$ref":"#/parameters/rowFilter.projects.p_agrivolt"},{"$ref":"#/parameters/rowFilter.projects.p_zscore"},{"$ref":"#/parameters/preferReturn"}],"responses":{"204":{"description":"No Content"}}},"patch":{"tags":["projects"],"parameters":[{"$ref":"#/parameters/rowFilter.projects.case_id"},{"$ref":"#/parameters/rowFilter.projects.multi_poly"},{"$ref":"#/parameters/rowFilter.projects.eia_id"},{"$ref":"#/parameters/rowFilter.projects.p_state"},{"$ref":"#/parameters/rowFilter.projects.p_county"},{"$ref":"#/parameters/rowFilter.projects.ylat"},{"$ref":"#/parameters/rowFilter.projects.xlong"},{"$ref":"#/parameters/rowFilter.projects.p_area"},{"$ref":"#/parameters/rowFilter.projects.p_img_date"},{"$ref":"#/parameters/rowFilter.projects.p_dig_conf"},{"$ref":"#/parameters/rowFilter.projects.p_name"},{"$ref":"#/parameters/rowFilter.projects.p_year"},{"$ref":"#/parameters/rowFilter.projects.p_pwr_reg"},{"$ref":"#/parameters/rowFilter.projects.p_tech_pri"},{"$ref":"#/parameters/rowFilter.projects.p_tech_sec"},{"$ref":"#/parameters/rowFilter.projects.p_axis"},{"$ref":"#/parameters/rowFilter.projects.p_azimuth"},{"$ref":"#/parameters/rowFilter.projects.p_tilt"},{"$ref":"#/parameters/rowFilter.projects.p_battery"},{"$ref":"#/parameters/rowFilter.projects.p_cap_ac"},{"$ref":"#/parameters/rowFilter.projects.p_cap_dc"},{"$ref":"#/parameters/rowFilter.projects.p_type"},{"$ref":"#/parameters/rowFilter.projects.p_agrivolt"},{"$ref":"#/parameters/rowFilter.projects.p_zscore"},{"$ref":"#/parameters/body.projects"},{"$ref":"#/parameters/preferReturn"}],"responses":{"204":{"description":"No Content"}}}},"/sites":{"get":{"tags":["sites"],"parameters":[{"$ref":"#/parameters/rowFilter.sites.case_id"},{"$ref":"#/parameters/rowFilter.sites.fac_state"},{"$ref":"#/parameters/rowFilter.sites.fac_county"},{"$ref":"#/parameters/rowFilter.sites.ylat"},{"$ref":"#/parameters/rowFilter.sites.xlon"},{"$ref":"#/parameters/rowFilter.sites.fac_areaSqM"},{"$ref":"#/parameters/rowFilter.sites.fac_multiPoly"},{"$ref":"#/parameters/rowFilter.sites.fac_imgDate"},{"$ref":"#/parameters/rowFilter.sites.fac_imgId"},{"$ref":"#/parameters/rowFilter.sites.fac_digConf"},{"$ref":"#/parameters/rowFilter.sites.fac_eiaId"},{"$ref":"#/parameters/rowFilter.sites.fac_name"},{"$ref":"#/parameters/rowFilter.sites.fac_instYr"},{"$ref":"#/parameters/rowFilter.sites.fac_pwrReg"},{"$ref":"#/parameters/rowFilter.sites.fac_pwrTech"},{"$ref":"#/parameters/rowFilter.sites.fac_pwrTechAdd"},{"$ref":"#/parameters/rowFilter.sites.fac_trackAxis"},{"$ref":"#/parameters/rowFilter.sites.fac_azimuth"},{"$ref":"#/parameters/rowFilter.sites.fac_tilt"},{"$ref":"#/parameters/rowFilter.sites.fac_battStor"},{"$ref":"#/parameters/rowFilter.sites.fac_capAc"},{"$ref":"#/parameters/rowFilter.sites.fac_capDc"},{"$ref":"#/parameters/rowFilter.sites.fac_type"},{"$ref":"#/parameters/rowFilter.sites.fac_agrivolt"},{"$ref":"#/parameters/rowFilter.sites.lc_major"},{"$ref":"#/parameters/select"},{"$ref":"#/parameters/order"},{"$ref":"#/parameters/range"},{"$ref":"#/parameters/rangeUnit"},{"$ref":"#/parameters/offset"},{"$ref":"#/parameters/limit"},{"$ref":"#/parameters/preferCount"}],"responses":{"206":{"description":"Partial Content"},"200":{"schema":{"items":{"$ref":"#/definitions/sites"},"type":"array"},"description":"OK"}}},"post":{"tags":["sites"],"parameters":[{"$ref":"#/parameters/body.sites"},{"$ref":"#/parameters/select"},{"$ref":"#/parameters/preferReturn"}],"responses":{"201":{"description":"Created"}}},"delete":{"tags":["sites"],"parameters":[{"$ref":"#/parameters/rowFilter.sites.case_id"},{"$ref":"#/parameters/rowFilter.sites.fac_state"},{"$ref":"#/parameters/rowFilter.sites.fac_county"},{"$ref":"#/parameters/rowFilter.sites.ylat"},{"$ref":"#/parameters/rowFilter.sites.xlon"},{"$ref":"#/parameters/rowFilter.sites.fac_areaSqM"},{"$ref":"#/parameters/rowFilter.sites.fac_multiPoly"},{"$ref":"#/parameters/rowFilter.sites.fac_imgDate"},{"$ref":"#/parameters/rowFilter.sites.fac_imgId"},{"$ref":"#/parameters/rowFilter.sites.fac_digConf"},{"$ref":"#/parameters/rowFilter.sites.fac_eiaId"},{"$ref":"#/parameters/rowFilter.sites.fac_name"},{"$ref":"#/parameters/rowFilter.sites.fac_instYr"},{"$ref":"#/parameters/rowFilter.sites.fac_pwrReg"},{"$ref":"#/parameters/rowFilter.sites.fac_pwrTech"},{"$ref":"#/parameters/rowFilter.sites.fac_pwrTechAdd"},{"$ref":"#/parameters/rowFilter.sites.fac_trackAxis"},{"$ref":"#/parameters/rowFilter.sites.fac_azimuth"},{"$ref":"#/parameters/rowFilter.sites.fac_tilt"},{"$ref":"#/parameters/rowFilter.sites.fac_battStor"},{"$ref":"#/parameters/rowFilter.sites.fac_capAc"},{"$ref":"#/parameters/rowFilter.sites.fac_capDc"},{"$ref":"#/parameters/rowFilter.sites.fac_type"},{"$ref":"#/parameters/rowFilter.sites.fac_agrivolt"},{"$ref":"#/parameters/rowFilter.sites.lc_major"},{"$ref":"#/parameters/preferReturn"}],"responses":{"204":{"description":"No Content"}}},"patch":{"tags":["sites"],"parameters":[{"$ref":"#/parameters/rowFilter.sites.case_id"},{"$ref":"#/parameters/rowFilter.sites.fac_state"},{"$ref":"#/parameters/rowFilter.sites.fac_county"},{"$ref":"#/parameters/rowFilter.sites.ylat"},{"$ref":"#/parameters/rowFilter.sites.xlon"},{"$ref":"#/parameters/rowFilter.sites.fac_areaSqM"},{"$ref":"#/parameters/rowFilter.sites.fac_multiPoly"},{"$ref":"#/parameters/rowFilter.sites.fac_imgDate"},{"$ref":"#/parameters/rowFilter.sites.fac_imgId"},{"$ref":"#/parameters/rowFilter.sites.fac_digConf"},{"$ref":"#/parameters/rowFilter.sites.fac_eiaId"},{"$ref":"#/parameters/rowFilter.sites.fac_name"},{"$ref":"#/parameters/rowFilter.sites.fac_instYr"},{"$ref":"#/parameters/rowFilter.sites.fac_pwrReg"},{"$ref":"#/parameters/rowFilter.sites.fac_pwrTech"},{"$ref":"#/parameters/rowFilter.sites.fac_pwrTechAdd"},{"$ref":"#/parameters/rowFilter.sites.fac_trackAxis"},{"$ref":"#/parameters/rowFilter.sites.fac_azimuth"},{"$ref":"#/parameters/rowFilter.sites.fac_tilt"},{"$ref":"#/parameters/rowFilter.sites.fac_battStor"},{"$ref":"#/parameters/rowFilter.sites.fac_capAc"},{"$ref":"#/parameters/rowFilter.sites.fac_capDc"},{"$ref":"#/parameters/rowFilter.sites.fac_type"},{"$ref":"#/parameters/rowFilter.sites.fac_agrivolt"},{"$ref":"#/parameters/rowFilter.sites.lc_major"},{"$ref":"#/parameters/body.sites"},{"$ref":"#/parameters/preferReturn"}],"responses":{"204":{"description":"No Content"}}}},"/turbines":{"get":{"tags":["turbines"],"parameters":[{"$ref":"#/parameters/rowFilter.turbines.case_id"},{"$ref":"#/parameters/rowFilter.turbines.faa_ors"},{"$ref":"#/parameters/rowFilter.turbines.faa_asn"},{"$ref":"#/parameters/rowFilter.turbines.usgs_pr_id"},{"$ref":"#/parameters/rowFilter.turbines.t_state"},{"$ref":"#/parameters/rowFilter.turbines.t_county"},{"$ref":"#/parameters/rowFilter.turbines.t_fips"},{"$ref":"#/parameters/rowFilter.turbines.p_name"},{"$ref":"#/parameters/rowFilter.turbines.p_year"},{"$ref":"#/parameters/rowFilter.turbines.p_tnum"},{"$ref":"#/parameters/rowFilter.turbines.p_cap"},{"$ref":"#/parameters/rowFilter.turbines.t_manu"},{"$ref":"#/parameters/rowFilter.turbines.t_model"},{"$ref":"#/parameters/rowFilter.turbines.t_cap"},{"$ref":"#/parameters/rowFilter.turbines.t_hh"},{"$ref":"#/parameters/rowFilter.turbines.t_rd"},{"$ref":"#/parameters/rowFilter.turbines.t_rsa"},{"$ref":"#/parameters/rowFilter.turbines.t_ttlh"},{"$ref":"#/parameters/rowFilter.turbines.t_conf_atr"},{"$ref":"#/parameters/rowFilter.turbines.t_conf_loc"},{"$ref":"#/parameters/rowFilter.turbines.t_img_date"},{"$ref":"#/parameters/rowFilter.turbines.t_img_srce"},{"$ref":"#/parameters/rowFilter.turbines.xlong"},{"$ref":"#/parameters/rowFilter.turbines.ylat"},{"$ref":"#/parameters/rowFilter.turbines.eia_id"},{"$ref":"#/parameters/rowFilter.turbines.retrofit"},{"$ref":"#/parameters/rowFilter.turbines.retrofit_year"},{"$ref":"#/parameters/select"},{"$ref":"#/parameters/order"},{"$ref":"#/parameters/range"},{"$ref":"#/parameters/rangeUnit"},{"$ref":"#/parameters/offset"},{"$ref":"#/parameters/limit"},{"$ref":"#/parameters/preferCount"}],"responses":{"206":{"description":"Partial Content"},"200":{"schema":{"items":{"$ref":"#/definitions/turbines"},"type":"array"},"description":"OK"}}},"post":{"tags":["turbines"],"parameters":[{"$ref":"#/parameters/body.turbines"},{"$ref":"#/parameters/select"},{"$ref":"#/parameters/preferReturn"}],"responses":{"201":{"description":"Created"}}},"delete":{"tags":["turbines"],"parameters":[{"$ref":"#/parameters/rowFilter.turbines.case_id"},{"$ref":"#/parameters/rowFilter.turbines.faa_ors"},{"$ref":"#/parameters/rowFilter.turbines.faa_asn"},{"$ref":"#/parameters/rowFilter.turbines.usgs_pr_id"},{"$ref":"#/parameters/rowFilter.turbines.t_state"},{"$ref":"#/parameters/rowFilter.turbines.t_county"},{"$ref":"#/parameters/rowFilter.turbines.t_fips"},{"$ref":"#/parameters/rowFilter.turbines.p_name"},{"$ref":"#/parameters/rowFilter.turbines.p_year"},{"$ref":"#/parameters/rowFilter.turbines.p_tnum"},{"$ref":"#/parameters/rowFilter.turbines.p_cap"},{"$ref":"#/parameters/rowFilter.turbines.t_manu"},{"$ref":"#/parameters/rowFilter.turbines.t_model"},{"$ref":"#/parameters/rowFilter.turbines.t_cap"},{"$ref":"#/parameters/rowFilter.turbines.t_hh"},{"$ref":"#/parameters/rowFilter.turbines.t_rd"},{"$ref":"#/parameters/rowFilter.turbines.t_rsa"},{"$ref":"#/parameters/rowFilter.turbines.t_ttlh"},{"$ref":"#/parameters/rowFilter.turbines.t_conf_atr"},{"$ref":"#/parameters/rowFilter.turbines.t_conf_loc"},{"$ref":"#/parameters/rowFilter.turbines.t_img_date"},{"$ref":"#/parameters/rowFilter.turbines.t_img_srce"},{"$ref":"#/parameters/rowFilter.turbines.xlong"},{"$ref":"#/parameters/rowFilter.turbines.ylat"},{"$ref":"#/parameters/rowFilter.turbines.eia_id"},{"$ref":"#/parameters/rowFilter.turbines.retrofit"},{"$ref":"#/parameters/rowFilter.turbines.retrofit_year"},{"$ref":"#/parameters/preferReturn"}],"responses":{"204":{"description":"No Content"}}},"patch":{"tags":["turbines"],"parameters":[{"$ref":"#/parameters/rowFilter.turbines.case_id"},{"$ref":"#/parameters/rowFilter.turbines.faa_ors"},{"$ref":"#/parameters/rowFilter.turbines.faa_asn"},{"$ref":"#/parameters/rowFilter.turbines.usgs_pr_id"},{"$ref":"#/parameters/rowFilter.turbines.t_state"},{"$ref":"#/parameters/rowFilter.turbines.t_county"},{"$ref":"#/parameters/rowFilter.turbines.t_fips"},{"$ref":"#/parameters/rowFilter.turbines.p_name"},{"$ref":"#/parameters/rowFilter.turbines.p_year"},{"$ref":"#/parameters/rowFilter.turbines.p_tnum"},{"$ref":"#/parameters/rowFilter.turbines.p_cap"},{"$ref":"#/parameters/rowFilter.turbines.t_manu"},{"$ref":"#/parameters/rowFilter.turbines.t_model"},{"$ref":"#/parameters/rowFilter.turbines.t_cap"},{"$ref":"#/parameters/rowFilter.turbines.t_hh"},{"$ref":"#/parameters/rowFilter.turbines.t_rd"},{"$ref":"#/parameters/rowFilter.turbines.t_rsa"},{"$ref":"#/parameters/rowFilter.turbines.t_ttlh"},{"$ref":"#/parameters/rowFilter.turbines.t_conf_atr"},{"$ref":"#/parameters/rowFilter.turbines.t_conf_loc"},{"$ref":"#/parameters/rowFilter.turbines.t_img_date"},{"$ref":"#/parameters/rowFilter.turbines.t_img_srce"},{"$ref":"#/parameters/rowFilter.turbines.xlong"},{"$ref":"#/parameters/rowFilter.turbines.ylat"},{"$ref":"#/parameters/rowFilter.turbines.eia_id"},{"$ref":"#/parameters/rowFilter.turbines.retrofit"},{"$ref":"#/parameters/rowFilter.turbines.retrofit_year"},{"$ref":"#/parameters/body.turbines"},{"$ref":"#/parameters/preferReturn"}],"responses":{"204":{"description":"No Content"}}}},"/wells":{"get":{"tags":["wells"],"parameters":[{"$ref":"#/parameters/rowFilter.wells.uid"},{"$ref":"#/parameters/rowFilter.wells.wellapinum"},{"$ref":"#/parameters/rowFilter.wells.wellnad83lat"},{"$ref":"#/parameters/rowFilter.wells.wellnad83lng"},{"$ref":"#/parameters/rowFilter.wells.wellfieldname"},{"$ref":"#/parameters/rowFilter.wells.wellformationname"},{"$ref":"#/parameters/rowFilter.wells.wellstate"},{"$ref":"#/parameters/rowFilter.wells.wellcounty"},{"$ref":"#/parameters/rowFilter.wells.heconcmol"},{"$ref":"#/parameters/rowFilter.wells.sampledate"},{"$ref":"#/parameters/rowFilter.wells.sampledateconf"},{"$ref":"#/parameters/rowFilter.wells.sampledepth"},{"$ref":"#/parameters/rowFilter.wells.samplesource"},{"$ref":"#/parameters/select"},{"$ref":"#/parameters/order"},{"$ref":"#/parameters/range"},{"$ref":"#/parameters/rangeUnit"},{"$ref":"#/parameters/offset"},{"$ref":"#/parameters/limit"},{"$ref":"#/parameters/preferCount"}],"responses":{"206":{"description":"Partial Content"},"200":{"schema":{"items":{"$ref":"#/definitions/wells"},"type":"array"},"description":"OK"}}},"post":{"tags":["wells"],"parameters":[{"$ref":"#/parameters/body.wells"},{"$ref":"#/parameters/select"},{"$ref":"#/parameters/preferReturn"}],"responses":{"201":{"description":"Created"}}},"delete":{"tags":["wells"],"parameters":[{"$ref":"#/parameters/rowFilter.wells.uid"},{"$ref":"#/parameters/rowFilter.wells.wellapinum"},{"$ref":"#/parameters/rowFilter.wells.wellnad83lat"},{"$ref":"#/parameters/rowFilter.wells.wellnad83lng"},{"$ref":"#/parameters/rowFilter.wells.wellfieldname"},{"$ref":"#/parameters/rowFilter.wells.wellformationname"},{"$ref":"#/parameters/rowFilter.wells.wellstate"},{"$ref":"#/parameters/rowFilter.wells.wellcounty"},{"$ref":"#/parameters/rowFilter.wells.heconcmol"},{"$ref":"#/parameters/rowFilter.wells.sampledate"},{"$ref":"#/parameters/rowFilter.wells.sampledateconf"},{"$ref":"#/parameters/rowFilter.wells.sampledepth"},{"$ref":"#/parameters/rowFilter.wells.samplesource"},{"$ref":"#/parameters/preferReturn"}],"responses":{"204":{"description":"No Content"}}},"patch":{"tags":["wells"],"parameters":[{"$ref":"#/parameters/rowFilter.wells.uid"},{"$ref":"#/parameters/rowFilter.wells.wellapinum"},{"$ref":"#/parameters/rowFilter.wells.wellnad83lat"},{"$ref":"#/parameters/rowFilter.wells.wellnad83lng"},{"$ref":"#/parameters/rowFilter.wells.wellfieldname"},{"$ref":"#/parameters/rowFilter.wells.wellformationname"},{"$ref":"#/parameters/rowFilter.wells.wellstate"},{"$ref":"#/parameters/rowFilter.wells.wellcounty"},{"$ref":"#/parameters/rowFilter.wells.heconcmol"},{"$ref":"#/parameters/rowFilter.wells.sampledate"},{"$ref":"#/parameters/rowFilter.wells.sampledateconf"},{"$ref":"#/parameters/rowFilter.wells.sampledepth"},{"$ref":"#/parameters/rowFilter.wells.samplesource"},{"$ref":"#/parameters/body.wells"},{"$ref":"#/parameters/preferReturn"}],"responses":{"204":{"description":"No Content"}}}}},"definitions":{"projects":{"required":["case_id"],"properties":{"case_id":{"format":"integer","type":"integer","description":"Note:\nThis is a Primary Key."},"multi_poly":{"maxLength":17,"format":"character varying","type":"string"},"eia_id":{"format":"integer","type":"integer"},"p_state":{"maxLength":17,"format":"character varying","type":"string"},"p_county":{"maxLength":54,"format":"character varying","type":"string"},"ylat":{"format":"numeric","type":"number"},"xlong":{"format":"numeric","type":"number"},"p_area":{"format":"numeric","type":"number"},"p_img_date":{"format":"integer","type":"integer"},"p_dig_conf":{"format":"integer","type":"integer"},"p_name":{"maxLength":54,"format":"character varying","type":"string"},"p_year":{"format":"integer","type":"integer"},"p_pwr_reg":{"maxLength":54,"format":"character varying","type":"string"},"p_tech_pri":{"maxLength":54,"format":"character varying","type":"string"},"p_tech_sec":{"maxLength":54,"format":"character varying","type":"string"},"p_axis":{"maxLength":54,"format":"character varying","type":"string"},"p_azimuth":{"format":"integer","type":"integer"},"p_tilt":{"format":"integer","type":"integer"},"p_battery":{"maxLength":54,"format":"character varying","type":"string"},"p_cap_ac":{"format":"numeric","type":"number"},"p_cap_dc":{"format":"numeric","type":"number"},"p_type":{"maxLength":54,"format":"character varying","type":"string"},"p_agrivolt":{"maxLength":54,"format":"character varying","type":"string"},"p_zscore":{"format":"numeric","type":"number"}},"type":"object"},"sites":{"properties":{"case_id":{"format":"bigint","type":"integer"},"fac_state":{"format":"text","type":"string"},"fac_county":{"format":"text","type":"string"},"ylat":{"format":"numeric","type":"number"},"xlon":{"format":"numeric","type":"number"},"fac_areaSqM":{"format":"bigint","type":"integer"},"fac_multiPoly":{"format":"text","type":"string"},"fac_imgDate":{"format":"bigint","type":"integer"},"fac_imgId":{"format":"text","type":"string"},"fac_digConf":{"format":"bigint","type":"integer"},"fac_eiaId":{"format":"bigint","type":"integer"},"fac_name":{"format":"text","type":"string"},"fac_instYr":{"format":"bigint","type":"integer"},"fac_pwrReg":{"format":"text","type":"string"},"fac_pwrTech":{"format":"text","type":"string"},"fac_pwrTechAdd":{"format":"text","type":"string"},"fac_trackAxis":{"format":"text","type":"string"},"fac_azimuth":{"format":"bigint","type":"integer"},"fac_tilt":{"format":"bigint","type":"integer"},"fac_battStor":{"format":"text","type":"string"},"fac_capAc":{"format":"numeric","type":"number"},"fac_capDc":{"format":"numeric","type":"number"},"fac_type":{"format":"text","type":"string"},"fac_agrivolt":{"format":"text","type":"string"},"lc_major":{"format":"text","type":"string"}},"type":"object"},"turbines":{"required":["case_id"],"properties":{"case_id":{"format":"integer","type":"integer"},"faa_ors":{"maxLength":9,"format":"character varying","type":"string"},"faa_asn":{"maxLength":17,"format":"character varying","type":"string"},"usgs_pr_id":{"format":"integer","type":"integer"},"t_state":{"maxLength":2,"format":"character varying","type":"string"},"t_county":{"maxLength":54,"format":"character varying","type":"string"},"t_fips":{"maxLength":6,"format":"character varying","type":"string"},"p_name":{"maxLength":54,"format":"character varying","type":"string"},"p_year":{"format":"integer","type":"integer"},"p_tnum":{"format":"integer","type":"integer"},"p_cap":{"format":"numeric","type":"number"},"t_manu":{"maxLength":100,"format":"character varying","type":"string"},"t_model":{"maxLength":18,"format":"character varying","type":"string"},"t_cap":{"format":"integer","type":"integer"},"t_hh":{"format":"numeric","type":"number"},"t_rd":{"format":"numeric","type":"number"},"t_rsa":{"format":"numeric","type":"number"},"t_ttlh":{"format":"numeric","type":"number"},"t_conf_atr":{"format":"integer","type":"integer"},"t_conf_loc":{"format":"integer","type":"integer"},"t_img_date":{"maxLength":16,"format":"character varying","type":"string"},"t_img_srce":{"maxLength":16,"format":"character varying","type":"string"},"xlong":{"format":"numeric","type":"number"},"ylat":{"format":"numeric","type":"number"},"eia_id":{"format":"integer","type":"integer"},"retrofit":{"format":"integer","type":"integer"},"retrofit_year":{"format":"integer","type":"integer"}},"type":"object"},"wells":{"required":["uid"],"properties":{"uid":{"format":"integer","type":"integer","description":"Note:\nThis is a Primary Key."},"wellapinum":{"format":"text","type":"string"},"wellnad83lat":{"format":"numeric","type":"number"},"wellnad83lng":{"format":"numeric","type":"number"},"wellfieldname":{"format":"text","type":"string"},"wellformationname":{"format":"text","type":"string"},"wellstate":{"format":"text","type":"string"},"wellcounty":{"format":"text","type":"string"},"heconcmol":{"format":"numeric","type":"number"},"sampledate":{"format":"date","type":"string"},"sampledateconf":{"format":"integer","type":"integer"},"sampledepth":{"format":"integer","type":"integer"},"samplesource":{"format":"text","type":"string"}},"type":"object"}},"parameters":{"preferParams":{"name":"Prefer","description":"Preference","required":false,"in":"header","type":"string","enum":["params=single-object"]},"preferReturn":{"name":"Prefer","description":"Preference","required":false,"in":"header","type":"string","enum":["return=representation","return=minimal","return=none"]},"preferCount":{"name":"Prefer","description":"Preference","required":false,"in":"header","type":"string","enum":["count=none"]},"select":{"name":"select","description":"Filtering Columns","required":false,"in":"query","type":"string"},"on_conflict":{"name":"on_conflict","description":"On Conflict","required":false,"in":"query","type":"string"},"order":{"name":"order","description":"Ordering","required":false,"in":"query","type":"string"},"range":{"name":"Range","description":"Limiting and Pagination","required":false,"in":"header","type":"string"},"rangeUnit":{"name":"Range-Unit","description":"Limiting and Pagination","required":false,"default":"items","in":"header","type":"string"},"offset":{"name":"offset","description":"Limiting and Pagination","required":false,"in":"query","type":"string"},"limit":{"name":"limit","description":"Limiting and Pagination","required":false,"in":"query","type":"string"},"body.projects":{"name":"projects","description":"projects","required":false,"schema":{"$ref":"#/definitions/projects"},"in":"body"},"rowFilter.projects.case_id":{"name":"case_id","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.projects.multi_poly":{"name":"multi_poly","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.projects.eia_id":{"name":"eia_id","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.projects.p_state":{"name":"p_state","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.projects.p_county":{"name":"p_county","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.projects.ylat":{"name":"ylat","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.projects.xlong":{"name":"xlong","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.projects.p_area":{"name":"p_area","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.projects.p_img_date":{"name":"p_img_date","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.projects.p_dig_conf":{"name":"p_dig_conf","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.projects.p_name":{"name":"p_name","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.projects.p_year":{"name":"p_year","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.projects.p_pwr_reg":{"name":"p_pwr_reg","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.projects.p_tech_pri":{"name":"p_tech_pri","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.projects.p_tech_sec":{"name":"p_tech_sec","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.projects.p_axis":{"name":"p_axis","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.projects.p_azimuth":{"name":"p_azimuth","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.projects.p_tilt":{"name":"p_tilt","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.projects.p_battery":{"name":"p_battery","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.projects.p_cap_ac":{"name":"p_cap_ac","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.projects.p_cap_dc":{"name":"p_cap_dc","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.projects.p_type":{"name":"p_type","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.projects.p_agrivolt":{"name":"p_agrivolt","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.projects.p_zscore":{"name":"p_zscore","required":false,"format":"numeric","in":"query","type":"string"},"body.sites":{"name":"sites","description":"sites","required":false,"schema":{"$ref":"#/definitions/sites"},"in":"body"},"rowFilter.sites.case_id":{"name":"case_id","required":false,"format":"bigint","in":"query","type":"string"},"rowFilter.sites.fac_state":{"name":"fac_state","required":false,"format":"text","in":"query","type":"string"},"rowFilter.sites.fac_county":{"name":"fac_county","required":false,"format":"text","in":"query","type":"string"},"rowFilter.sites.ylat":{"name":"ylat","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.sites.xlon":{"name":"xlon","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.sites.fac_areaSqM":{"name":"fac_areaSqM","required":false,"format":"bigint","in":"query","type":"string"},"rowFilter.sites.fac_multiPoly":{"name":"fac_multiPoly","required":false,"format":"text","in":"query","type":"string"},"rowFilter.sites.fac_imgDate":{"name":"fac_imgDate","required":false,"format":"bigint","in":"query","type":"string"},"rowFilter.sites.fac_imgId":{"name":"fac_imgId","required":false,"format":"text","in":"query","type":"string"},"rowFilter.sites.fac_digConf":{"name":"fac_digConf","required":false,"format":"bigint","in":"query","type":"string"},"rowFilter.sites.fac_eiaId":{"name":"fac_eiaId","required":false,"format":"bigint","in":"query","type":"string"},"rowFilter.sites.fac_name":{"name":"fac_name","required":false,"format":"text","in":"query","type":"string"},"rowFilter.sites.fac_instYr":{"name":"fac_instYr","required":false,"format":"bigint","in":"query","type":"string"},"rowFilter.sites.fac_pwrReg":{"name":"fac_pwrReg","required":false,"format":"text","in":"query","type":"string"},"rowFilter.sites.fac_pwrTech":{"name":"fac_pwrTech","required":false,"format":"text","in":"query","type":"string"},"rowFilter.sites.fac_pwrTechAdd":{"name":"fac_pwrTechAdd","required":false,"format":"text","in":"query","type":"string"},"rowFilter.sites.fac_trackAxis":{"name":"fac_trackAxis","required":false,"format":"text","in":"query","type":"string"},"rowFilter.sites.fac_azimuth":{"name":"fac_azimuth","required":false,"format":"bigint","in":"query","type":"string"},"rowFilter.sites.fac_tilt":{"name":"fac_tilt","required":false,"format":"bigint","in":"query","type":"string"},"rowFilter.sites.fac_battStor":{"name":"fac_battStor","required":false,"format":"text","in":"query","type":"string"},"rowFilter.sites.fac_capAc":{"name":"fac_capAc","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.sites.fac_capDc":{"name":"fac_capDc","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.sites.fac_type":{"name":"fac_type","required":false,"format":"text","in":"query","type":"string"},"rowFilter.sites.fac_agrivolt":{"name":"fac_agrivolt","required":false,"format":"text","in":"query","type":"string"},"rowFilter.sites.lc_major":{"name":"lc_major","required":false,"format":"text","in":"query","type":"string"},"body.turbines":{"name":"turbines","description":"turbines","required":false,"schema":{"$ref":"#/definitions/turbines"},"in":"body"},"rowFilter.turbines.case_id":{"name":"case_id","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.turbines.faa_ors":{"name":"faa_ors","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.turbines.faa_asn":{"name":"faa_asn","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.turbines.usgs_pr_id":{"name":"usgs_pr_id","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.turbines.t_state":{"name":"t_state","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.turbines.t_county":{"name":"t_county","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.turbines.t_fips":{"name":"t_fips","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.turbines.p_name":{"name":"p_name","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.turbines.p_year":{"name":"p_year","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.turbines.p_tnum":{"name":"p_tnum","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.turbines.p_cap":{"name":"p_cap","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.turbines.t_manu":{"name":"t_manu","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.turbines.t_model":{"name":"t_model","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.turbines.t_cap":{"name":"t_cap","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.turbines.t_hh":{"name":"t_hh","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.turbines.t_rd":{"name":"t_rd","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.turbines.t_rsa":{"name":"t_rsa","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.turbines.t_ttlh":{"name":"t_ttlh","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.turbines.t_conf_atr":{"name":"t_conf_atr","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.turbines.t_conf_loc":{"name":"t_conf_loc","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.turbines.t_img_date":{"name":"t_img_date","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.turbines.t_img_srce":{"name":"t_img_srce","required":false,"format":"character varying","in":"query","type":"string"},"rowFilter.turbines.xlong":{"name":"xlong","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.turbines.ylat":{"name":"ylat","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.turbines.eia_id":{"name":"eia_id","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.turbines.retrofit":{"name":"retrofit","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.turbines.retrofit_year":{"name":"retrofit_year","required":false,"format":"integer","in":"query","type":"string"},"body.wells":{"name":"wells","description":"wells","required":false,"schema":{"$ref":"#/definitions/wells"},"in":"body"},"rowFilter.wells.uid":{"name":"uid","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.wells.wellapinum":{"name":"wellapinum","required":false,"format":"text","in":"query","type":"string"},"rowFilter.wells.wellnad83lat":{"name":"wellnad83lat","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.wells.wellnad83lng":{"name":"wellnad83lng","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.wells.wellfieldname":{"name":"wellfieldname","required":false,"format":"text","in":"query","type":"string"},"rowFilter.wells.wellformationname":{"name":"wellformationname","required":false,"format":"text","in":"query","type":"string"},"rowFilter.wells.wellstate":{"name":"wellstate","required":false,"format":"text","in":"query","type":"string"},"rowFilter.wells.wellcounty":{"name":"wellcounty","required":false,"format":"text","in":"query","type":"string"},"rowFilter.wells.heconcmol":{"name":"heconcmol","required":false,"format":"numeric","in":"query","type":"string"},"rowFilter.wells.sampledate":{"name":"sampledate","required":false,"format":"date","in":"query","type":"string"},"rowFilter.wells.sampledateconf":{"name":"sampledateconf","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.wells.sampledepth":{"name":"sampledepth","required":false,"format":"integer","in":"query","type":"string"},"rowFilter.wells.samplesource":{"name":"samplesource","required":false,"format":"text","in":"query","type":"string"}},"externalDocs":{"url":"https://postgrest.org/en/v7.0/api.html","description":"PostgREST Documentation"}}