Pull all EPA Facility latitudes and longitudes from the FACT API

epa-facility-locations-fact-api.py

import os
import urllib3
import pandas as pd
from urllib3 import request
import certifi
import json

url = f"https://api.epa.gov/FACT/1.0/facilities?api_key={os.environ['API_KEY_EPA_FACT']}"

http = urllib3.PoolManager(
       cert_reqs='CERT_REQUIRED',
       ca_certs=certifi.where()
)
r = http.request("GET", url)
assert r.status == 200
data = json.loads(r.data.decode('utf-8'))
df = pd.json_normalize(data, record_path="data")[[
    "orisCode",
    "name",
    "geographicLocation.isValid",
    "geographicLocation.latitude",
    "geographicLocation.longitude",
]]
df = df.rename(columns={
    "orisCode": "plant_id_eia",
    "name": "plant_name_eia",
    "geographicLocation.isValid": "valid_location",
    "geographicLocation.latitude": "latitude",
    "geographicLocation.longitude": "longitude",
})
df.info()