{"id":2546,"date":"2016-11-19T09:33:15","date_gmt":"2016-11-19T17:33:15","guid":{"rendered":"http:\/\/blog.light42.com\/wordpress\/?page_id=2546"},"modified":"2022-07-12T19:55:35","modified_gmt":"2022-07-13T02:55:35","slug":"epa-facilities-misc","status":"publish","type":"page","link":"http:\/\/blog.light42.com\/wordpress\/?page_id=2546","title":{"rendered":"EPA Facilities Misc"},"content":{"rendered":"<hr \/>\n<p><strong>US EPA Facilities of Interest<\/strong><\/p>\n<p>POINT layer supplied by EPA File Geodatabase [<em>P<\/em>]:<\/p>\n<pre>\r\n...geodata_misc\/EPA_2016$ ogr2ogr -dim 2 -overwrite -lco GEOMETRY_NAME=geom  -f PostgreSQL PG:dbname=osm_ca_work FRS_INTERESTS.gdb -t_srs EPSG:4326\r\n<\/pre>\n<p>POINT layer via CSV Import:<\/p>\n<pre>\r\n  IMPORT SCRIPT: Code_Misc_repo\/import_epa_fac.sql\r\n  DATA: ..\/geodata_misc\/EPA_2016\/comb_2016\/CA_FACILITY_FILE.CSV\r\n  TABLE: facility_file_epa  \r\n  GS LAYER: osm_ca_test:facility_file_epa\r\n<\/pre>\n<div id=\"attachment_2345\" style=\"width: 310px\" class=\"wp-caption aligncenter\"><a href=\"wp-content\/uploads\/2016\/10\/Davis_EPA_Facility_example.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2345\" src=\"wp-content\/uploads\/2016\/10\/Davis_EPA_Facility_example-300x109.png\" alt=\"Davis, CA EPA-registered site POINT, Census 2016 Blockgroup ID on NAIP 2009\" width=\"300\" height=\"109\" class=\"size-medium wp-image-2345\" srcset=\"wp-content\/uploads\/2016\/10\/Davis_EPA_Facility_example-300x109.png 300w, wp-content\/uploads\/2016\/10\/Davis_EPA_Facility_example-768x280.png 768w, wp-content\/uploads\/2016\/10\/Davis_EPA_Facility_example-1024x374.png 1024w, wp-content\/uploads\/2016\/10\/Davis_EPA_Facility_example.png 1129w\" sizes=\"(max-width: 300px) 100vw, 300px\"\/><\/a><\/p>\n<p id=\"caption-attachment-2345\" class=\"wp-caption-text\">Davis, CA EPA-registered site POINT, Census 2016 Blockgroup ID on NAIP 2009<\/p>\n<\/div>\n<p><em>Sample Data URL by EPA Registry ID:<\/em><\/p>\n<pre>https:\/\/ofmpub.epa.gov\/enviro\/fii_query_detail.disp_program_facility?p_registry_id=110066130458\r\n<\/pre>\n<p>[<em>P<\/em>] US EPA Geospatial Data <a href=\"https:\/\/www.epa.gov\/enviro\/geospatial-data-download-service\" target=\"_blank\" rel=\"noopener\">-portal-<\/a> \u201cGeospatial information for all publicly available <a href=\"https:\/\/www.epa.gov\/enviro\/frs-physical-data-model\" target=\"_blank\" rel=\"noopener\">FRS<\/a> facilities that have latitude\/longitude data.\u201d <a href=\"https:\/\/ofmpub.epa.gov\/sor_internet\/registry\/facilreg\/home\/whatisfacilityidentification\/\" target=\"_blank\" rel=\"noopener\">-FRS Info-<\/a><\/p>\n<p>Areas of Interest <a href=\"..\/files-misc\/epa_fac0_ca.txt\" target=\"_blank\" rel=\"noopener\">-REPORT-<\/a><\/p>\n<p>US EPA Facilities Data 2012<a href=\"..\/files-misc\/EPA_Facility_State_File_Docs_11132012.pdf\" target=\"_blank\" rel=\"noopener\">-Report-<\/a><\/p>\n<p>US EPA Facilities Dataset Classifications 2013<a href=\"..\/files-misc\/EPA_interest_types.pdf\" target=\"_blank\" rel=\"noopener\">-link-<\/a><\/p>\n<p>US EPA Environmental Data Standards <a href=\"https:\/\/www.epa.gov\/data-standards\" target=\"_blank\" rel=\"noopener\">-portal-<\/a><\/p>\n<p>US EPA Industrial Classification Standards 2006<a href=\"..\/files-misc\/EPA_SICNAICS-v2a_10022014.pdf\" target=\"_blank\" rel=\"noopener\">-link-<\/a> <\/p>\n<p>US Census NAICS <a href=\"https:\/\/www.census.gov\/naics\" target=\"_blank\" rel=\"noopener\"> portal <\/a><\/p>\n<p>US EPA Region 9 <a href=\"https:\/\/www.epa.gov\/aboutepa\/epa-region-9-pacific-southwest\" target=\"_blank\" rel=\"noopener\">Homepage<\/a> <a href=\"https:\/\/www.epa.gov\/aboutepa\/forms\/contact-epa\" target=\"_blank\" rel=\"noopener\">-Contact-<\/a><\/p>\n<p>US EPA BRAC <a href=\"..\/files-misc\/EPA_CA_BRAC.html\" target=\"_blank\" rel=\"noopener\">-List-<\/a> CA<\/p>\n<p>US EPA Superfund Search <a href=\"https:\/\/cumulis.epa.gov\/supercpad\/cursites\/srchsites.cfm\" target=\"_blank\" rel=\"noopener\">-Link-<\/a><\/p>\n<p>US EPA Greenhouse Gas Reporting Program <a href=\"https:\/\/ghgdata.epa.gov\/ghgp\/main.do\" target=\"_blank\" rel=\"noopener\">-Link-<\/a><\/p>\n<p>US EPA Hazardous Waste Generators <a href=\"https:\/\/www.epa.gov\/hwgenerators\/biennial-hazardous-waste-report\" target=\"_blank\" rel=\"noopener\">-Link-<\/a><\/p>\n<p>US EPA Integrated Compliance Information System <a href=\"https:\/\/echo.epa.gov\/tools\/data-downloads\/icis-npdes-dmr-summary\" target=\"_blank\" rel=\"noopener\">-LINK-<\/a><\/p>\n<p>US EPA Categories of Hazardous Waste Generators <a href=\"https:\/\/www.epa.gov\/hwgenerators\/categories-hazardous-waste-generators\" target=\"_blank\" rel=\"noopener\">-Link-<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>US EPA Facilities of Interest POINT layer supplied by EPA File Geodatabase [P]: &#8230;geodata_misc\/EPA_2016$ ogr2ogr -dim 2 -overwrite -lco GEOMETRY_NAME=geom -f PostgreSQL PG:dbname=osm_ca_work FRS_INTERESTS.gdb -t_srs EPSG:4326 POINT layer via CSV Import: IMPORT SCRIPT: Code_Misc_repo\/import_epa_fac.sql DATA: ..\/geodata_misc\/EPA_2016\/comb_2016\/CA_FACILITY_FILE.CSV TABLE: facility_file_epa GS LAYER: osm_ca_test:facility_file_epa Davis, CA EPA-registered site POINT, Census 2016 Blockgroup ID on NAIP 2009 Sample Data [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1166,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/2546"}],"collection":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2546"}],"version-history":[{"count":6,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/2546\/revisions"}],"predecessor-version":[{"id":3822,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/2546\/revisions\/3822"}],"up":[{"embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/1166"}],"wp:attachment":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2546"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}