University of Miami (2022). 2022 FL EPA Interpolated Annual Estimates PM 2.5 FRM/FEM Mass (88101) [gis dataset]. University of Miami. https://aqs.epa.gov/aqsweb/airdata/download_files.html. last updated: 0001-01-01 (update frequency: As Needed). This dataset is derived as an interpolated raster created from 2022 FL EPA Annual Estimates PM 2.5 FRM/FEM Mass (88101) which is derived from 2022 US EPA Daily Summary PM 2.5 FRM/FEM Mass (88101) Key words: EPA, particulate matter, PM 2.5, FL, annual, interpolated Open Geospatial Consortium Standards: | WMS (coming soon) | WFS (coming soon) Analytical Functions: gdsc_zonal_statistics(table=fl_2022_annual_interpolated_epa_pm25,lat=25.718,lng=-80.279,radius=500) ETL documentation

ETL for fl_2022_annual_interpolated_epa_pm25

######### # GDSC ETL is performed in two steps: shell script to ETL data into postgres # and then additional transformations with SQL in postGIS (if needed). #### ######### # Step 1 - bash script (pseudo code) #### # create directory structure and move into it mkdir -p /data/fl_2022_annual_interpolated_epa_pm25/{download,etl} && cd /data/fl_2022_annual_interpolated_epa_pm25 # set update flag based on last update and update frequency do_update=0 if date() < last_update + update_frequency else do_update = 1 # load us_2022_annual_epa_pm25 as dependency (see us_2022_annual_epa_pm25 for details). # interpolate dependency points to raster with gdal_grid: ogr2ogr -f geojson /vsistdout/ PG:" tables='us_2022_annual_epa_pm25'" | gdal_grid -l us_2022_annual_epa_pm25 -zfield arithmetic_mean -a invdist:power=2.0:smoothing=0.0:radius1=0.0:radius2=0.0:angle=0.0:max_points=0:min_points=0:nodata=0.0 -a_srs EPSG:4269 -tr 0.004167 0.004167 -txe -87.8015626 -79.8076394 -tye 24.2296414 31.1676346 -ot Float32 -of GTiff geojson:/vsistdin/ download/fl_2022_annual_interpolated_epa_pm25.tif ######### # Step 2 - SQL script (pseudo code): ####