370 likes | 572 Views
As we start – Go to tinyurl.com/BDJ-JTools Go to desktop; find excel spreadsheet Sign in to your gmail account. J Tools. JTools . BDJ 204 basic journalism BDJ 364 reporting 1 BDJ 664 BDJ 464 reporting 2 BDJ 667 BDJ 465 senior newscast . Using Online Resources
E N D
As we start – Go to tinyurl.com/BDJ-JTools Go to desktop; find excel spreadsheet Sign in to your gmail account J Tools
JTools BDJ 204 basic journalism BDJ 364 reporting 1 BDJ 664 BDJ 464 reporting 2 BDJ 667 BDJ 465 senior newscast Using Online Resources Search Tricks and Validity of Sources Basic Maps Finding People Online Finding Stories Online Web Extras Diving Through Databases More mapping Online Resources for the Job Hunt
JTools BDJ 204 basic journalism BDJ 364 reporting 1 BDJ 664 BDJ 464 reporting 2 BDJ 667 BDJ 465 senior newscast Using Online Resources Search Tricks and Validity of Sources Basic Maps Finding People Online Finding Stories Online Web Extras Diving Through Databases More mapping Online Resources for the Job Hunt
Why learn mapping? Jtools
Research • Cremedas & Lysak, Electronic Journalism: “ …most news executives would like to use their station’s web site to provide new and additional information to users—for example, ‘‘extra’’ video footage, documents, historical perspective about a story, and so on…”
Cremedas & Lysak Research • One news director: • “we want to create new content that surrounds the TV story. Otherwise we’re only doing a partial job….”
New Media Skills Needed?Cremedas & Lysak, Electronic Journalism Beyond TV skills TV news managers surveyed: 91% said producers need them 83% said reporters need them
Mapping 1 location Multiple locations: basic Multiple locations: intermediate Jtools
1 location MAPPING JTools
Anybody can do a map with one location Copy it w/ SnipTool Save as .jpg and insert
Mapping from geocoded data • Need data with an address • Put data in excel • Use a program to geolocate on a Google map • Batchgeo simple • Google Fusion basic, but customizable
What you’ll learn today • Example from BDJ 204 website
First: check integrity of data • What is a homicide?
SIMPLE MAPPING JTools
Simple Mapping with BatchGeo 1. compile excel spreadsheet 2. cut/paste into Batch Geo website 3. make map 4. post link or embed map on website
1. Compile excel spreadsheet Syracuse Homicides questions?
2. Cut/paste spreadsheet into BatchGeo.com 3. Make the map
4. Embed the map or post the link Save Look for email with link & code NCC News Online: go to html tab. Cut/paste code where you want map to appear.
Two different maps • Example from BDJ 204 website
Another Way: Google Fusion allows customization JTools New for me, too! Be patient!
Process is similar • Import the data • Map the data • Customize the presentation
But 1st: Reformat the dataOne location column • Google Fusion maps one column • How can it map a street without a city? • Or if it maps city, all dots are same place So merge (concatenate) street, city, state in one column in Excel • See handout
But 1st: Reformat the datain narrative form Police report that the victim, __________, was killed by ________ at ________ by the assailant, __________ …
Starting with Google Fusion Sign in to Google Go to Google Docs Create a table
Import Data Find Excel file Click through NEXT until you get the table
Tell which column is location Tell it full address is what to geocode, i.e. map
Visualize the map Watch it geocode See map Zoom to get it full screen 1 km
Configure the pop-up window Click Custom Replace the code (see handout)
Set the map for sharing Upper left of screen Share it w/ others Set Visibility public unlisted private
MUCH MORE YOU CAN DO You got just a taste of it! Layer data ie. combine 2 Census categories Do heat intensity Much more!
In summary -- Simple quick maps Customizable More complex 1 location map BATCHGEO.COM GOOGLE FUSION Google, Yahoo, Bing Snip tool
More Mapping Jtools