{B9286C32-7897-4F8C-A688-D31FB0D4BF84} eng; USA utf8 dataset Kim Balassiano U.S. Environmental Protection Agency, Office of Environmental Information EDG Steward 202-579-3540 1200 Pennsylvania Avenue, N.W. Washington DC 20460 balassiano.kim@epa.gov https://www.epa.gov/aboutepa/oei.html pointOfContact 2023-09-05 ISO 19115 Geographic Information - Metadata ISO 19115:2003/Cor.1:2006(E) US EPA CARE Grants 2012-05-07 publication U.S. EPA Office of Environmental Information (OEI) - Office of Information Analysis and Access (OIAA) Washington DC publisher US Environmental Protection Agency originator mapDigital This is a provisional dataset that contains point locations for the subset of Community Action for a Renewed Environment (CARE) grants given out by the US EPA. CARE is a competitive grant program that offers an innovative way for a community to organize and take action to reduce toxic pollution in its local environment. There are many limitations to the data so it is advised that these metadata be read carefully before use. Although the records for these grant locations are drawn directly from the official EPA grants repository (IGMS Integrated Grants Management System), it is important to know that the IGMS was designed for purposes that did not include accurately portraying the grants place of performance on a map. Instead, the IGMS grant recipients mailing address is the primary source for grant locations. Particularly for statewide grants that are administered via State and Regional headquarters, the grant location data should not be interpreted as the grants place of performance. In 2012, a policy was established to start to collect the place of performance as a pilot for newly awarded grants that were deemed community-based in nature and for these the grant location depicted in this database will be a more reliable indicator of the actual place of performance. As for the locational accuracy of these points, there is no programmatic certification process, however, they are being entered by the Grant Project Officers who are most familiar with the details of the grants, apart from the grantees themselves. Limitations notwithstanding, this is a first-of-breed attempt to map all of the Agencys grants, using the best internal geocoding algorithms available, and is a useful tool for getting to an understanding of the distribution of USEPA grant-giving. The CARE Grants layer contains Places of Performance for single locations or areas where CARE grants are applied. This data set is used by the GeoGrants application for display of Community Action for a Renewed Environment (CARE) Grant locations. completed Kim Balassiano U.S. Environmental Protection Agency, Office of Environmental Information EDG Steward 202-579-3540 1200 Pennsylvania Avenue, N.W. Washington DC 20460 balassiano.kim@epa.gov https://www.epa.gov/aboutepa/oei.html pointOfContact THE GRANTS ARE REFRESHED DAILY. Cleanup theme EPA GIS Keyword Thesaurus Grants theme User United States place None https://edg.epa.gov/EPA_Data_License.htm otherRestrictions Use Constraints: None otherRestrictions Access Constraints: None PUBLIC http://project-open-data.github.io/schema/#accessLevel Standard Technical Controls vector eng; USA Native Dataset Environment: Microsoft Windows XP Version 5.1 (Build 2600) Service Pack 3; ESRI ArcCatalog 9.3.0.1770 -174.200050 -64.685100 17.701010 71.295070 2005-07-01 2011-09-01 true Kim Balassiano U.S. Environmental Protection Agency, Office of Environmental Information EDG Steward 202-579-3540 1200 Pennsylvania Avenue, N.W. Washington DC 20460 balassiano.kim@epa.gov https://www.epa.gov/aboutepa/oei.html distributor https://geopub.epa.gov/arcgis/rest/services/EMEF/EJgrants/MapServer/1 ESRI:ArcGIS API The endpoint of a web service to access the dataset (REST endpoint, WMS GetCapabilities URL, or a SOAP WSDL endpoint). webMapService dataset Horizontal Positional Accuracy Report Data were collected using methods that have unknown accuracy (EPA National Geospatial Data Policy [NGDP] Accuracy Tier 10). For more information, please see EPA's NGDP at http://epa.gov/geospatial/policies.html) Features represented have not been tested for completeness Features represented have not been tested for completeness Tests for integrity have not been performed. This lineage was generated by the FGDC CSDGM to 19139 transformation The OGD IGMS Data Mart source used for Geogrants is the IGMS data in the EPA Envirofacts data warehouse. These data are transformed via Informatica ETL processes to exclude all interagency agreement and fellowship grants based on the following program codes: OGD IGMS Program Code Description (IT) Internships, Training; Workshops and Fellowships for the Office of Air and Radiation (MA); Greater Research Opportunities (GRO); Fellowships for Undergraduate/Graduate Environmental Study; (TJ) Environmental Justice Training and Fellowship Assistance (FP); Science to Achieve Results (STAR); Fellowship Program (U); Fellowships (W); Interagency and Intergovernmental Agreements. Additionally, only grants with OGD IGMS status values of Awarded or Closed are loaded into Envirofacts. Envirofacts geocodes OGMS IGMS grant recipients using the FRS Geocoding service. The geocoded values are incorporated directly into the Geogrants tables without further transformation. The IGMS data in Envirofacts are refreshed daily using a truncate/insert approach as the OGD IGMS data mart does not maintain primary keys between refresh cycles. The Geogrants data is updated after the grants data in Envirofacts are refreshed. 1. Executed the following query from the ENVIROI database: select b.grant_seq,a.perf_identifier,a.grant_family,a.grant_src_identifier,a.grant_num,a.grant_program_name,a.created_date, a.award_date,replace(replace(replace(a.project_title,chr(10),' '),chr(13),' '),'"',' ') project_title,replace(replace(replace(a.project_desc,chr(10),' '),chr(13),' '),'"',' ') project_desc,a.proj_beg_date,a.proj_end_date,a.CUMULATIVE_AWARD, BRANCH_DESCRIPTION, DIVISION_DESCRIPTION, APPROVAL_OFFICE_DIVISION_NAME, AASHIP_CODE, AASHIP_DESCRIPTION, A.CONG_DIST,A.RECIPIENT_NAME, c.SSTORY, replace(wm_concat(CFDAg.cfda_code),',',';') CFDA_CODE, A.recipient_address,a.recipient_city,a.recipient_state,a.recipient_zip,a.recipient_county,b.longitude83 longitude,b.latitude83 latitude, a.point_identifier POINT_IDENTIFIER,a.poly_identifier POLY_IDENTIFIER from perf_info a, d_grants.ogd_ef_grant_dtl_rpt b, perf_success_story c, PERF_INFO_CFDA_JCT PJCT, D_GRANTS.OGD_CFDA CFDAG where b.latest_amendment_flag = 'Y' and a.grant_family = b.grant_family and a.grant_num = b.grant_num and c.perf_identifier (+) = a.perf_identifier AND PJCT.PERF_IDENTIFIER(+) = A.PERF_IDENTIFIER AND PJCT.CFDA_SEQ = CFDAG.CFDA_SEQ(+) GROUP BY b.grant_seq,a.perf_identifier,a.grant_family,a.grant_src_identifier,a.grant_num,a.grant_program_name,a.created_date, a.award_date,a.project_title,a.project_desc,a.proj_beg_date,a.proj_end_date,a.CUMULATIVE_AWARD, a.project_desc, a.BRANCH_DESCRIPTION, a.DIVISION_DESCRIPTION, a.APPROVAL_OFFICE_DIVISION_NAME, a.AASHIP_CODE, a.AASHIP_DESCRIPTION, A.CONG_DIST,A.RECIPIENT_NAME, c.SSTORY, A.recipient_address,a.recipient_city,a.recipient_state,a.recipient_zip,a.recipient_county,b.longitude83 ,b.latitude83,a.point_identifier,a.poly_identifier ORDER BY A.PERF_IDENTIFIER 2021-01-01T00:00:00 If a grant has an associated point location for place of performance, then that point location is inserted into this layer. Only Places of Performance with an active status are used. 2021-01-01T00:00:00 If a grant has an associated polygon location for place of performance, then each polygon is assigned a centroid point location and inserted into this layer. If a grant covers more than one polygon(e.g. multiple counties), a centoid point location will be created for each polygon and inserted into this layer. Only Places of Performance with an active status are used. 2021-01-01T00:00:00 If a grant is associated with neither a point or polygon place of performance, the geocoded latitude/longitude representing the grant recipients address will be inserted into this layer 2021-01-01T00:00:00 This layer will contain a location record for every place of performance that a grant covers or it will contain one record for the recipient address. 2021-01-01T00:00:00 unknown 2022-07-25 This metadata was automatically generated from the FGDC Content Standards for Digital Geospatial Metadata standard (version FGDC-STD-001-1998) using the 2024-02-09T11:11:00 version of the FGDC CSDGM to ISO 19139 transform. Kim Balassiano U.S. Environmental Protection Agency, Office of Environmental Information EDG Steward 202-579-3540 1200 Pennsylvania Avenue, N.W. Washington DC 20460 balassiano.kim@epa.gov https://www.epa.gov/aboutepa/oei.html pointOfContact