eng utf8 dataset dataset Kim Balassiano U.S. Environmental Protection Agency,Office of Environmental Information,Information Services Branch 202-566-0709 1200 Pennsylvania Avenue, N.W. Washington DC 20460 balassiano.kim@epa.gov pointOfContact 2018-11-20 ISO 19139 Geographic Information - Metadata - Implementation Specification 2007 USEPA Grants 2012-02-15 publication U.S. EPA Washington, DC publisher US Environmental Protection Agency originator mapDigital EPA's management information system for grants programs is the Integrated Grants Management System (IGMS), which awards, administers, and monitors grants. Grants are regularly awarded to Federal, State, or local government agencies, universities, and other institutions that support EPA's environmental programs. Specific types of agreements include assistance agreements, grants, cooperative agreements, interagency agreements, and other types of program support agreements administered by Headquarters or EPA regions. This dataset contains point locations for all grants given out by the USEPA going back to the 1960s till the end of 2012. To map all of the Agency's historical grants (pre-2013), using the best internal geocoding agorithms available, and understand the spatial pattern of USEPA grant-giving. completed United States place Grants theme User Although these data have been processed successfully on a computer system at the Environmental Protection Agency, no warranty expressed or implied is made regarding the accuracy or utility of the data on any other system or for general or scientific purposes, nor shall the act of distribution constitute any such warranty. It is also strongly recommended that careful attention be paid to the contents of the metadata file associated with these data to evaluate data set limitations, restrictions or intended use. The U.S. Environmental Protection Agency shall not be held liable for improper or incorrect use of the data described and/or contained herein. vector eng utf8 Version 6.2 (Build 9200) ; Esri ArcGIS 10.5.1.7333 Publication date -174.20005 -64.6851 17.70101 71.29507 Kim Balassiano U.S. Environmental Protection Agency,Office of Environmental Information,Information Services Branch 1200 Pennsylvania Avenue, N.W. Washington DC 20460 distributor dataset 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 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 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. 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. 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.