events

[derekeder]

table or calendar driven by a json feed of past events

[derekeder]

got a start on this: http://civichacknight.org/events.html

[derekeder]

here's the rest of the events to be added in:

4/19/2012 First one!
4/26/2012 Steve Vance's project overview
5/3/2012 Demo session
5/10/2012 Fusion Tables workshop with Chad W Pry
5/17/2012 First one at 1871 5/24/2012 Derek gone
5/29/2012 Derek gone, first Tuesday session 6/5/2012 Derek gone
6/12/2012
6/19/2012 Heroku talk by Anna 6/26/2012
7/3/2012 4th of July - CANCELED
7/10/2012
7/17/2012 Mi Parque ask and George from Designing Chicago 7/24/2012 CPS School Locator folks
7/31/2012 Data Potluck #2 8/7/2012 R tutorial by Juan
8/14/2012
8/21/2012
8/28/2012 Data Potluck #3 9/4/2012
9/11/2012 Places API event Smart Chicago 9/18/2012
9/25/2012 How's Business launch 10/2/2012 Data Potluck #4 10/9/2012
10/16/2012
10/23/2012 Open 311 and Service Tracker (Rob Brackett) Smart Chicago 10/30/2012 Data Potluck #5. Edifice, Councilmatic
11/6/2012 Election Day - no event 11/13/2012 State CIO Visit (Sean Vinck) + CPS Tiers update Code for America 11/20/2012 Adopt a Sidewalk (Tolva, Hauswirth, O'Neil, Klein) ? 11/27/2012 Sunlight Foundation (Amy Ngai) + County jail project (David Eades) Sunlight Foundation 12/4/2012 Code for America 12/11/2012 Greg Sutton from CMAP Data Potluck #6 12/18/2012 CAF big data exhibit brainstorm, Matt Hampel on LocalData 12/25/2012 Xmas - no event 1/1/2013 New years - no event
1/8/2013 Code for America 1/15/2013
1/22/2013
1/29/2013 In Credit Suisse room Data Potluck #7 2/5/2013 Ian Dees on OSM 2/12/2013
2/19/2013 Amy Guterman on GravityTank's Electronic Medical Record redesign project
2/26/2013 CANCELED
3/5/2013 Sunlight Foundation, Gideon Blustein IDES Code for America 3/12/2013 Tom Kompare demos GoToSchool
3/19/2013 Doug Pencoast, Robert Drinkwater - Mobto bike and physical computing. State dept shooting doc.
3/26/2013 Data Potluck #8 4/2/2013 CTA planners
4/9/2013 Nick Doiron on Majuro.js and Demond Drummer on Englewood Codes
4/16/2013 City of Chicago + Philly + others talk about including residents in civic hacking - Opengov Hack Night 1 Year Anniversary Smart Chicago 4/23/2013 PublicStuff - service request website Code for America 4/30/2013 Miranda Mulligan - design-thinking for civic hacking Purple Binder 5/7/2013 Energy + sustainability hackathon presentations with the City of Chicago Thoughtworks 5/14/2013 School cuts team presentation 5/21/2013 Open source licenses, TCamp13 takaways Code for America 5/28/2013 Gearing up for the National Day of Civic Hacking Smart Chicago 6/4/2013 Followup from the National Day of Civic Hacking DataMade 6/11/2013 Intro to Git/Github Thoughtworks 6/18/2013 Karl Fogel on Checkbook NYC, FusionTables template Code for America 6/25/2013 DSSG DSSG 7/2/2013 Divvy Data! DataMade 7/9/2013 Open Hack Session Thoughtworks 7/16/2013 Code for America 7/23/2013 DSSG 311 team Rob Paral Associates 7/30/2013 Fernando Diaz new food inspections apps DataMade

[kfogel]

Derek Eder notifications@github.com writes:

here's the rest of the events to be added in:

Do we have any more information about these events? I can easily write some Emacs scriptitudinous macrolage to turn it into JSON for data/hack_night_events.js, but there's a lot of missing data below. Or would you like me to get it all into JSON anyway, so that at least it's in the canonical place and can be filled in from there? Let me know.

-K

4/19/2012 First one!

4/26/2012 Steve Vance's project overview

5/3/2012 Demo session

5/10/2012 Fusion Tables workshop with Chad W Pry

5/17/2012 First one at 1871 5/24/2012 Derek gone

5/29/2012 Derek gone, first Tuesday session 6/5/2012 Derek gone

6/12/2012

6/19/2012 Heroku talk by Anna 6/26/2012

7/3/2012 4th of July - CANCELED

7/10/2012

7/17/2012 Mi Parque ask and George from Designing Chicago 7/24/2012 CPS School Locator folks

7/31/2012 Data Potluck #2 8/7/2012 R tutorial by Juan

8/14/2012

8/21/2012

8/28/2012 Data Potluck #3 9/4/2012

9/11/2012 Places API event Smart Chicago 9/18/2012

9/25/2012 How's Business launch 10/2/2012 Data Potluck #4 10/9/2012

10/16/2012

10/23/2012 Open 311 and Service Tracker (Rob Brackett) Smart Chicago 10/30/2012 Data Potluck #5. Edifice, Councilmatic

11/6/2012 Election Day - no event 11/13/2012 State CIO Visit (Sean Vinck) + CPS Tiers update Code for America 11/20/2012 Adopt a Sidewalk (Tolva, Hauswirth, O'Neil, Klein) ? 11/27/2012 Sunlight Foundation (Amy Ngai) + County jail project (David Eades) Sunlight Foundation 12/4/2012 Code for America 12/11/2012 Greg Sutton from CMAP Data Potluck #6 12/18/2012 CAF big data exhibit brainstorm, Matt Hampel on LocalData 12/25/2012 Xmas - no event 1/1/2013 New years - no event

1/8/2013 Code for America 1/15/2013

1/22/2013

1/29/2013 In Credit Suisse room Data Potluck #7 2/5/2013 Ian Dees on OSM 2/12/2013

2/19/2013 Amy Guterman on GravityTank's Electronic Medical Record redesign project

2/26/2013 CANCELED

3/5/2013 Sunlight Foundation, Gideon Blustein IDES Code for America 3/12/2013 Tom Kompare demos GoToSchool

3/19/2013 Doug Pencoast, Robert Drinkwater - Mobto bike and physical computing. State dept shooting doc.

3/26/2013 Data Potluck #8 4/2/2013 CTA planners

4/9/2013 Nick Doiron on Majuro.js and Demond Drummer on Englewood Codes

4/16/2013 City of Chicago + Philly + others talk about including residents in civic hacking - Opengov Hack Night 1 Year Anniversary Smart Chicago 4/23/2013 PublicStuff - service request website Code for America 4/30/2013 Miranda Mulligan - design-thinking for civic hacking Purple Binder 5/7/2013 Energy + sustainability hackathon presentations with the City of Chicago Thoughtworks 5/14/2013 School cuts team presentation 5/21/2013 Open source licenses, TCamp13 takaways Code for America 5/28/2013 Gearing up for the National Day of Civic Hacking Smart Chicago 6/4/2013 Followup from the National Day of Civic Hacking DataMade 6/11/2013 Intro to Git/Github Thoughtworks 6/18/2013 Karl Fogel on Checkbook NYC, FusionTables template Code for America 6/25/2013 DSSG DSSG 7/2/2013 Divvy Data! DataMade 7/9/2013 Open Hack Session Thoughtworks 7/16/2013 Code for America 7/23/2013 DSSG 311 team Rob Paral Associates 7/30/2013 Fernando Diaz new food inspections apps DataMade

— Reply to this email directly or view it on GitHub.

[derekeder]

The rest of the metadata can be found in the announcement emails we've sent out. Thankfully, these have all been publicly archived on the opengov chicago google group: https://groups.google.com/forum/#!searchin/opengovchicago/hack$20night%7Csort:date

A bit of a manual process, sorry! Go ahead and add what you can.

[shua123]

Is the plan for Events to just track what happened at each Hack Night or will it also include other Chicago civic/open-gov related events (opengov meetup, hackathons, etc)?

[derekeder]

@shua123 for now, just hack night events as it will be displayed on the hack night website.

The same pattern/code could be re-used to track a larger set of events, though we'd want to think about a better way to organize them. You got something in mind?

[evz]

@derekeder It occurred to me that if this was in a Google Spreadsheet (or ended up there), I wrote a thing for my other job that converts that to JSON pretty handily. Basically the guts of the Tribapps Tarbell slightly modified to work on it's own.

[derekeder]

@evz good idea. using a google doc would probably be easier than editing a JSON file.

Here's what we could use to grab a CSV of the doc:

https://docs.google.com/spreadsheet/pub?key=0AtbqcVh3dkAqdGN6dnozemV2Nk5EMWdCUFZkMmRZMGc&output=csv

[evz]

@derekeder Yeah, that'd probably be the simplest way (rather than scraping the junk out through the API)

[danxoneil]

It would be slick to have links to the full video for each of the presentations. We've got them going back for some time now. We can do that, methinks (calling @CivicWhitaker).

[derekeder]

@danxoneil absolutely.

also on the todo list: linking to every one of @CivicWhitaker's awesome blog posts

If you guys wanna start a google doc with all the attributes, we can wire it up on the front end.

[evz]

I think @CivicWhitaker is actually @GovInTrenches on Github. Just sayin...

[danxoneil]

Whoops yep @GovInTrenches. He's on it. Probably the easiest way is for him to edit the Events page directly with these items as they are published.

[GovInTrenches]

@derekeder - So if I create a google fusion table with [dates][summary][link] we should be good to go?

[evz]

As of about 2 this morning @derekeder is a daddy. Something tells me he won't be getting back to this anytime soon.

If you make a Fusion Table, I can probably wire something up. Thanks!

[GovInTrenches]

Oh wow! Congrats @derekeder!

Link to FT is here: https://www.google.com/fusiontables/embedviz?viz=GVIZ&t=TABLE&q=select+col0%2C+col3%2C+col4+from+1zCENhZ42WnJQnOb6l-ID4aUZ8le3nzgJiW3EZvM&containerId=gviz_canvas

I'll start populating these so we can something going.

[GovInTrenches]

@evz - I've populated the table with what I have so far. There's one night in there I wasn't there - but the rest should have at the very least a link to the video.

[evz]

@GovInTrenches Cool. This will give me something to do at the hack night.

[evz]

So I @GovInTrenches gave me edit rights on the Fusion table

and I went in there and started modifying the schema a bit so we could load it directly from the Fusion Table. However, as you can see, just based upon what @derekeder already did over here it's going to get kinda tricky to come up with something that renders the event listing as elegantly as that without making it super complicated (just the columns I already added into that FT are getting a bit out of control)

So, I guess the questions I have are:

1) Is there a schema that we can establish for events that isn't totally over the top with complexity?

2) Do we actually want to enforce a schema here or should we just stick with the flat JSON file that @derekeder has going in the project already?

Personally, I like just sticking with the simpler approach and just sticking the links that @GovInTrenches provided in that Fusion Table in the JSON packet that @derekeder started. Maybe also just providing a link to the video there, too.

[GovInTrenches]

Would a separate page for blogs and videos work?

Christopher Whitaker (Sent from iPhone)

On Oct 1, 2013, at 20:32, Eric van Zanten notifications@github.com wrote:

So I @GovInTrenches gave me edit rights on the Fusion table

and I went in there and started modifying the schema a bit so we could load it directly from the Fusion Table. However, as you can see, just based upon what @derekeder already did over here it's going to get kinda tricky to come up with something that renders the event listing as elegantly as that without making it super complicated (just the columns I already added into that FT are getting a bit out of control)

So, I guess the questions I have are:

1) Is there a schema that we can establish for events that isn't totally over the top with complexity?

2) Do we actually want to enforce a schema here or should we just stick with the flat JSON file that @derekeder has going in the project already?

Personally, I like just sticking with the simpler approach and just sticking the links that @GovInTrenches provided in that Fusion Table in the JSON packet that @derekeder started. Maybe also just providing a link to the video there, too.

— Reply to this email directly or view it on GitHub.

[evz]

Huh, maybe. I like the one stop shop approach that we've already got going there. It fulfills the dual purpose of an accounting of what happened and a way to link to resources that were mentioned during the presentations.

[derekeder]

So I think we may be over thinking this. I see two approaches:

JSON

Stick with the JSON file format we have. Downside is edit-ability (requires diving in to nerd-land manually editing JSON). However, this doesn't need be be updated by a bunch of people. We're talking one new event per week here. Upside is we don't have to worry about schema (just consistency) and we can handle links pretty elegantly like so

{
  "id": "101",
  "title": "Chicago Works for You",
  "date": "2013-09-24",
  "description": "<a href='https://twitter.com/cgansen'>Chris Gansen</a> will demo <a href='http://chicagoworksforyou.com/'>Chicago Works for You</a>, a citywide dashboard by <a href='http://www.smartchicagocollaborative.org/'>Smart Chicago</a> that displays ward-by-ward views of city services in Chicago. <a href='http://www.smartchicagocollaborative.org/the-launch-of-chicago-works-for-you/'>Click here</a> for more info on the app, and <a href='http://www.smartchicagocollaborative.org/building-chicago-works-for-you/'>here</a> for how it was made. The app's github repo is <a href='https://github.com/smartchicago/chicagoworksforyou/'>here</a>.",
  "sponsor": "<a href='http://thoughtworks.com'>Thoughtworks</a>",
  "links": [
    "YouTube": "http://www.youtube.com/watch?v=OHcTPHgpoxs",
    "Smart Chicago blog post": "http://www.smartchicagocollaborative.org/hack-night-live-chicago-works-for-you/"
    ... more links
  ]
}

Google spreadsheet

Use a plain 'ol Google spreadsheet. Fusion Tables is not the right choice here due to it being a pain to edit. The point here is to make this content super easy to maintain. We can get at the data by hitting a URL like https://docs.google.com/spreadsheet/pub?key=0AmPkMT5S2NcVdHFIYms5RDl6Tnc0ZmNBaVlGQWJoS1E&output=csv like @justgrimes does for Code for DC

Not as big of a fan of the spreadsheet since it locks us in to a schema. I think we can get away with a lot if we just allow plain HTML in the description field (like we are doing now).

My vote is for JSON.

[fgregg]

Why does using a spreadsheet, versus .json, lock us into a schema?

[GovInTrenches]

I'm perfectly fine with manual edits. Need to spend more time in code land anyway. Seems straight forward enough too.

Christopher Whitaker (Sent from iPhone)

On Oct 1, 2013, at 23:53, Derek Eder notifications@github.com wrote:

So I think we may be over thinking this. I see two approaches:

JSON

Stick with the JSON file format we have. Downside is edit-ability (requires diving in to nerd-land manually editing JSON). However, this doesn't need be be updated by a bunch of people. We're talking one new event per week here. Upside is we don't have to worry about schema (just consistency) and we can handle links pretty elegantly like so

{ "id": "101", "title": "Chicago Works for You", "date": "2013-09-24", "description": "Chris Gansen will demo Chicago Works for You, a citywide dashboard by Smart Chicago that displays ward-by-ward views of city services in Chicago. Click here for more info on the app, and here for how it was made. The app's github repo is here.", "sponsor": "Thoughtworks", "links": [ "YouTube": "http://www.youtube.com/watch?v=OHcTPHgpoxs", "Smart Chicago blog post": "http://www.smartchicagocollaborative.org/hack-night-live-chicago-works-for-you/" ... more links ] } Google spreadsheet

Use a plain 'ol Google spreadsheet. Fusion Tables is not the right choice here due to it being a pain to edit. The point here is to make this content super easy to maintain. We can get at the data by hitting a URL like https://docs.google.com/spreadsheet/pub?key=0AmPkMT5S2NcVdHFIYms5RDl6Tnc0ZmNBaVlGQWJoS1E&output=csv like @justgrimes does for Code for DC

Not as big of a fan of the spreadsheet since it locks us in to a schema. I think we can get away with a lot if we just allow plain HTML in the description field (like we are doing now).

My vote is for JSON.

— Reply to this email directly or view it on GitHub.

[derekeder]

@fgregg the major lock in with CSV would be with listing an arbitrary number of links.

[derekeder]

Links added from @GovInTrenches's Fusion Table: http://opengovhacknight.org/events.html

Follow this pattern: https://github.com/open-city/open-gov-hack-night/blob/master/data/hack_night_events.js

[derekeder]

phew ok all the past events are stubbed out with title, date and sponsor. @jpvelez and @GovInTrenches could you guys help stub out the description and links where you can?

Here's an example event. Note that I'm using HTML markup inside the description section.

{
    "title": "Intro to Git and Github",
    "date": "2013-06-11",
    "description": "<p>In addition to working on civic tech projects, Derek is going to be leading an intro to Git and Github tutorial for folks who want to learn.</p>",
    "sponsor": "<a href='http://thoughtworks.com'>Thoughtworks</a>",
    "links": [
      {"name": "Github 101 - YouTube", "url": "http://www.youtube.com/watch?v=ZxabbwjcuIE"},
    ]
  },

[GovInTrenches]

Add column for video, blog post. @GovInTrenches will add to markdown file and do pull request.

[derekeder]

done in #75