UM Geospatial Digital Special Collections

Citation: Florida Department of Environmental Protection, Division of Water Resource Management, State Revolving Fund Program (2014). Florida State Funded Cleanup Sites [gis dataset]. Florida Department of Environmental Protection, Division of Water Resource Management, State Revolving Fund Program. https://geodata.dep.state.fl.us/datasets/FDEP::florida-state-funded-cleanup-sites/about. last updated: 2024-05-01 (update frequency: 1 day). Abstract: Florida National Priority List (Superfund) Sites. Years ago there was less understanding of how dumping or improper management of chemical wastes might adversely affect public health and the environment. The result of such practices was that hazardous substances contaminated thousands of properties across the nation. Congress passed legislation in 1980 that established the Superfund Program in order to locate, investigate and cleanup these sites. The federal Environmental Protection Agency (EPA) administers the Superfund Program in cooperation with the individual States and tribal governments. The Hazard Ranking System (HRS) is the principal mechanism that EPA uses to evaluate sites for the National Priorities List (NPL). It is a numerically based screening system that uses information from initial, limited investigations "the preliminary assessment and the site inspection" to assess the potential of sites to pose a threat to human health or the environment. Sites are listed on the NPL upon completion of Hazard Ranking System screening, public solicitation of comments about the proposed site, and after all comments have been addressed. The responsible parties may clean up the Superfund site under an agreement with EPA| or, EPA may clean up the site under a cost-share agreement using federal and state funds. Complete information on the federal Superfund Program and individual Florida Superfund sites is available on the EPA Superfund Sites Website. Key words: Florida, EPA, Environmental Protection Agency, Environment, Health, Safety, Pollution, Contamination, Clean-Up Site, Superfund, Superfund Site, Hazard, Public-Safety Open Geospatial Consortium Standards: vector tiles | WMS (coming soon) | WFS (coming soon) Analytical Functions: gdsc_get_attributes(tablename=fl_state_funded_cleanup_sites,lat=25.718,lng=-80.279,identifier=name,attrs=[eric_id,name,address,city,county,district,program,status,manager,haz_arc_id,documents],normal='') gdsc_nearest_neighbor(table=fl_state_funded_cleanup_sites,lat=25.718,lng=-80.279,id=name) ETL documentation

ETL for fl_state_funded_cleanup_sites

######### # 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_state_funded_cleanup_sites/{download,etl} && cd /data/fl_state_funded_cleanup_sites # set update flag based on last update and update frequency do_update=0 if date() < last_update + update_frequency else do_update = 1 # download if update flag is set: if do_update == 1 then wget -O download/fl_state_funded_cleanup_sites.json 'https://ca.dep.state.fl.us/arcgis/rest/services/OpenData/CLEANUP_SP/MapServer/3/query?where=1%3D1&outFields=*&outSR=4326&f=json' # replace column names Shape__Length and Shape__Area to avoid conflict when # providing as service on ArcServer. sed -i 's/Shape__Length/shape_length/gI; s/Shape__Area/shape_area/gI' download/fl_state_funded_cleanup_sites.json # load into postGIS with: ogr2ogr -lco GEOMETRY_NAME=geom -f PostgreSQL PG:"" download/fl_state_funded_cleanup_sites.json -nlt point -nln fl_state_funded_cleanup_sites ######### # Step 2 - SQL script (pseudo code): #### # remove duplicate points and make geometries valid: UPDATE fl_state_funded_cleanup_sites SET geom=ST_MakeValid(ST_RemoveRepeatedPoints(geom));" # add local geometry column and reproject existing geometries into local EPSG: SELECT AddGeometryColumn ( 'fl_state_funded_cleanup_sites', 'geom_local',2236,'point',2 ); UPDATE fl_state_funded_cleanup_sites SET geom_local=ST_Transform(geom,2236); CREATE INDEX fl_state_funded_cleanup_sites_geom_local_idx ON fl_state_funded_cleanup_sites USING GIST (geom_local); NOTIFY pgrst, 'reload schema';"