Posts – Page 3

Girl Scout Partner Potential Map Ownership Transfer

April 7, 2016May 17, 2016Stefania Ruibal

Transferring Ownership

Because we decided to use Google fusion tables transferring ownership is simple. I will add you as the main owner of the fusion table, right now the owner is Linda, which will allow you to access the map through your Gmail and will also give you full editing privileges. For the map to be reachable for other people within Girl Scouts by using a Google fusion template I will be able to create an interactive web page were the Map can be viewed but not edited. And this page can be easily reached with a simple URL you can distribute to anyone who wants to view and use the map.

Spreadsheet Update:

1)When new Girl Scout data is updated you will need to pull Girl data from iMIS using the LB Data Viz Query (girl)

2)When you data is now imputed into a new excel sheet before you begin organizing your town data you will need to convert the smaller wrong town names to the correct ones using VLOOK up. VLOOK up instructions can be found here. You will need to use this excel page to convert your town names: VLOOK up town data.

3) When new data on Girl Scout participation is available in order to convert this into a usable spreadsheet for Google fusion you first step is to create a pivot table showing the number of Girl Scouts in each town by age group. To create a pivot table you will need to highlight the entire spreadsheet then go into Data and then click pivot table.

You will then need to organize you data into these groups at shown in the picture below.

4) Once your Girl Scout population by town data is organized your next step is to create a spreadsheet with both census population data and Girl Scout participation data. You can use the same population template spreadsheet each time the only thing that will need updating is the percentage of Girl Scouts compared to residences.

Your spreadsheet should be set up in a format like this. Your Columns for each age group should be labeled as such: Town, Daisies (number of Daisies in town), Potential Daisies (population in town), and percentage (actual Daisies over potential Daisies) Once you input the new Girl Scouts data you need to find the percentage of Girl Scouts over Census data.

Google Fusion Map Update:

1) Once your spreadsheet is organize you will need to input your new spread sheet into a google fusion table. You will then need to merge it will the MAGIC town borders of Connecticut. Under file in your google fusion table you will need to click merge and it will give you an option to merge your fusion table with a table on your desk top (town borders). You can access the Magic town borders here. For more help on merging data look to the Data Viz For All Booklet.

2) You will then need to copy the color codes and percentage ranges from you old maps. You will need to create 7 maps using google fusion tables exactly like the ones I initially created using the new data. For help using Google fusion tables look to Data Viz For All Booklet. Once you tables are finalized you will be able to update the GitHub code to update the template.

GitHub Update:

1) Updating GitHub is simple once your maps are updated and finalized you will want to go into file on your google fusioon map and then to about this table. You will then see

You will then need to do a hard copy of the ID at the bottom of the list. This ID is different for every map within this google fusion table so when importing these IDs into the GitHub code it will be different for each map.

2) You will then need to go into your fusion-girl-scouts repository making sure you are editing within your gh-pages. You will need to go into your file and then into your file. This is where you will be updating your map and points within the template. Once in your maps_libs.js file you will then need to scroll down to line 26

Within this code is where you will import your new polygon IDs that you copied from your google fusion table. Each ID is labeled with each age group.

3)Once your IDs are updated you will want to check that your map updated correctly by scrolling down on your main repository page and click on the demo link. It may take a while for the maps to update but before you do a pull request to update your master branch you want to make sure the maps are inserted correctly.

4)*This step is not necessary until you have made changes to your gh-pages that are perfect and finalized. To make a pull request to your master branch to have your repository completely updated you will need to click on the new pull request page. It will then ask you to check which GitHub profile to pull from and you will want to click on GSOFCT. Once you are have clicked on your own repository you need to create a pull request to you master from your gh-pages which will look like this . You can then create your pull request.

5)Depending on how much your data has changed you may need to edit the range of percentages the map is basing its data off of for each individual age group. You can find this on your google fusion table under change feature style in fill color. You will also need to update the percentages under the color legend on the template map within GitHub. You can access this in your file and then in your file. You will then need to scroll down to line 170.

There is separate code for each age group and within this code you can edit the color codes for the legend as well as the percentages under each color. Each code is labeled under each age group.

Population Data:

1) Once new population data for CT is released you will need to update the population data as well. The best source for specific age break downs is from the Department of Public Health for Connecticut. You will have to download their data called Connecticut Town Population by Age Sex Race and Hispanic Ethnicity for the next census. The data surrounding race is not important for the data needed for your partner potential map so you will have to extract the specific data you need for this large data set.

Hartford Food System

April 1, 2016April 8, 2016Mike Walsh

Map

Our partner would like a map of food access in Hartford, including grocery stores, convenience stores, farmers markets and community gardens. They would like us to indicate all the places that are WIC certified, as well as bus routes. The map would serve two purposes: (1) to give Hartford residents an easy way to find healthy, affordable food in their neighborhood, and (2) to highlight the serious issue of food insecurity in the poorest areas of the city. Using polygons, we will demonstrate the income disparities of the different census tracts.

So far, we have mapped all of the grocery stores, convenience stores, and farmers markets as points. We still need to need to map the farmers markets and all of the places that are WIC certified. Then, we will need to add the CTTransit bus routes and the polygon data on median household income.

Assignment 8-KNOX demo

March 31, 2016April 8, 2016Doris Zhang

link to map demo: http://doris0221.github.io/fusion-point-polygon/

My partner is expected to see an interactive map with two layers. On the first layer, it shows the all the community gardens with detailed profile information. The profile includes the address, the number of plots, photos of the garden, spot availability of the garden during the year and greenhouse availability(3). The second layer shows the Hartford neighborhood border, which divides gardens into different regions and also gives audience an easier way to visualize where their closet gardens are. Adding on to this border map, there is also a search tool, like the one in Google map, for audience to search by address. Audience can simply type in their own address in the toolbox. The map will then lead the audience into the closet garden according to the location. Moreover, there is another filter tool on the side of the map. The tool filters out by the information listed in the garden profile, such as the greenhouse and garden plot availability.

Steps completed:
Make point map
Make polygon map
Merge two maps into layer map
Create filter tool
Collect photos

Steps to be done:
Make photos appear in the profile–demo:https://support.google.com/fusiontables/answer/2527132?hl=en
Collect more photos
Fix filter tool
Edit code in github

Progress from Injury Prevention Center

March 31, 2016April 3, 2016Stacy Lam

Intimate Partner Violence Arrests in Connecticut 2010

Intimate Partner Violence Arrests in Connecticut 2011

Intimate Partner Violence Arrests in Connecticut 2012

Intimate Partner Violence Arrests in Connecticut 2013

Intimate Partner Violence Arrests in Connecticut 2014

Intimate Partner Violence Arrests in the Greater Hartford Area for 2010-2014

Injury Prevention Center Vision: To have a shaded polygon map of Connecticut from 2010-2014 that contains the rate of arrests, children involved, and the average rates of arrest per year. On the map, the towns should be labeled and be able to hover over the towns for the information. In addition, there would be a table containing the same information as well as a bar/line graph.

Round Talk Vision on April 12th: Since this is the first priority, the vision is to clip the greater Hartford area to represent the interval shelter homes for victims of intimate partner violence. With this, there will be a shaded polygon map with town labels, the rate of arrests without the involvement of children for 2010-2014. Since this will be used in Garry’s Power Point, he would like the map to be a screenshot.

Steps Completed for Data Visual Vision:
Shaded polygon maps completed for all five years.

Steps to be done for Data Visual Vision:
Compile the five years of data into one polygon map, recalculate the data to factor in child involvement, use another tool to label the towns, create the table and bar/line graph.

Steps Completed for Round Talk:
Clipped the greater Hartford from mapshaper.org and exported it to Google Fusion. And is in the progress of compiling/cleaning data.

Steps to be done for Round Talk:
Compile/clean arrest data to import into Google Fusion, label the town names, color code polygon and have this ready for Garry before April 12th for revisions.

My Demo of the project

March 31, 2016March 31, 2016Shuxin Zhang

Link to the demonstration:
Map tour demo

I have already embedded my story map into my partner’s website. There are only 3 pinpoints on the map now, and we wish to have 30 pinpoints for our final project. Each pinpoint will consist of introductory paragraph, quotes, and pictures. Some pinpoint will also show artifacts and 3D models. The final project will be a live story of Mr.McCook’s around-the-world journey. We wish the story map to be easily editable, and we will also produce a text-and-picture only paper form interpretation of the tour for further use and updates.

Steps I have completed:
0. All the scanning of McCook’s journal and sorting of files.
1. Create a storymap, and add contents to it.
2. Figure out how to embed 3D models without killing the application.
3. Write several intros to the pinpoints.
4. Figure out how to export data through the story map(which was once thought as impossible).
5. Create the website and embed my map to it.
6. Update the original data document corresponding to the map.

Steps yet to be done:
1. Finish all the readings of the journal and write intro to all of them(estimated time of completion: next week)
2. Add all contents to the storymap demo version(estimated time of completion: mid-April)
3. Figure out how to edit the style of the pointers on the map, b/c now the pointers are hardly visible(this can only be done through github code editing, so that I will have to have host server for the website, which make this seemingly-simple mission extremely hard. I will try to do that after I finished the demo version).
4. Follow-up with my partner frequently to update the data I have(Some necessary pictures still need to be added)
5. Introduce my partner to the ArcGis tool, and let her know how to update in the future.
6. Present the work before final.