Information about locations that includes addresses, latitudes and longitudes, or other geospatial coordinates, can be visualized on a map. There are many interactive mapping platforms on federal, state, county and municipal websites that will allow you to turn on and turn off layers for environmental data (for example, locations of Superfund sites or flood risk), add layers for jurisdictional boundaries (for example, tribal reservation boundaries, census tracts), and other types of information that you wish to use in your analysis and reports. Most of these platforms will allow you to export from the GIS (typically ESRI ArcGIS) in PDF or JPG format for use in your reports. Some will allow you to export spreadsheets and map files (typically SHP or KMZ/KML). 

In this session we are going to look at ways of exporting data in a format that can be used to create your own maps, allowing you to add your own information and customize your map for analysis, reporting, public outreach, and collaboration with colleagues. You can make your own map mashup on free, user friendly platforms like Google Earth Pro and My Maps, so that you no longer need specialized training or a software license to do simple GIS analyses.

Today we will focus on exporting data from federal databases useful for planning and conducting environmental reviews and siting projects such as housing or public facilities. We will begin by using Google Earth Pro because it will allow us to work with map overlays, the timeslider for historic imagery, and to convert GIS files into a format that can be used on Google My Maps. 

Then we will use data exported from government websites to construct and share our map using Google My Maps, which allows you to collaborate with colleagues and embed your map in a website. My Maps is a cloud based mapping platform that is password protected as part of a Google Account using Google Drive. You will need to be able to access Google Drive on your computer, which may require getting permission from your IT department for use on a work computer.

This redevelopment case study focuses on a vacant building located at 1417-1419 E 62nd Place Chicago, IL. This project will convert a vacant old fire house building into 21 units of elderly housing with 14-Single (400 sq ft), 7-Double (500 sq ft) apartments with commercial spaces in the 1st and 2nd floor. The conversion of this vacant building into affordable housing will utilize extensive measures to improve the quality of life and the vitality of the neighborhood. 

There are a number of online platforms that you can use for your analysis. Some of the most useful are presented below, along with instructions on how to export data for use in Google Earth Pro and My Maps (where possible).

Below is NEPAssist embedded in this website. It is interactive so you can try it out.

EPA EnviroMapper website

The EPA EnviroMapper draws from many of the same databases used to create NEPAssist. These maps are built on a GIS platform that pulls data from sources such as EPA ACRES, and all of the EPA mapping tools will pull data from the same sources (all of the Brownfields sites will be mapped from ACRES data, for example). This means that if there is a data layer you want to use, find the platform that most easily allows you to download the data in a user friendly format. The best format for mapping your data using My Maps is a CSV file. A CSV file format is a universal spreadsheet format type that you can also open in Excel or Google Sheets. It has the advantage that when you open it as a spreadsheet you can edit and add to it using all of the tools available in Excel or Google Sheets (things like autofill and sort to help with quality control). Once you edit it you can import it into Google My Maps. You can also find mapping file formats such as SHP (used for ESRI ArcGIS and Google Earth Pro) and KML/KMZ (used for Google My Maps, Google Earth Pro and ESRI ArcGIS). The advantage of downloading a file in these formats is that you can use polygons and lines (shapes) as well as points. The disadvantage is that you can't open it as a spreadsheet and edit it without coding.

Below is a My Maps created from the exported spreadsheet below.

EPA Cleanups in My Community website

Mapping Help

The Cleanups in My Community platform will let you create a map with many useful layers. CIMC will also download data, but you must do it from the Lists or Tables page, not from the mapping tool. The best format to use for downloading data is CSV format which is a universal file type and will work in My Maps as well as Excel.

The advantage of CIMC exports is that they give you a live link to the property information which will show up in the map markers on your My Maps

Below is a My Maps created from the exported spreadsheet below.

EPA EJ Screen website

EJ Screen Help

The EJ Screen mapping tool does not allow you to export data. You can print it as a PDF, but you can't download the map files.

https://www.huduser.gov/portal/maps/CN/home.html 

According to the HUD website: This tool assists Choice Neighborhoods applicants to prepare data to submit with their grant application by allowing applicants to draw the exact location of their target neighborhood. The tool will then calculate the number of housing units, the average poverty rate, and the vacancy rate of the area drawn and send an email back to the applicant within a few hours. The email will have an attachment containing the necessary data for the Choice Neighborhoods application, along with information HUD can use to confirm the intended program area. The applicant should then submit this document with their grant application.

You can also go to the HUD Geospatial Storefront and access a variety of maps. Below is an example embedded in this website that is interactive so you can try it out.

https://hudgis-hud.opendata.arcgis.com/