Page 90 of 171

Clean Power Ordinance, delayed again

September 26, 2011 / / 0 Comments

Updated September 30, 2011: The ordinance never got on the Committee on Health and Environmental Protection’s agenda for September. So my fingers are crossed for the October meeting.

Clean power advocates march in Pilsen on Saturday, September 24, 2011. Photo by Ryan Williams. 

Instead of voting on the Clean Power Ordinance on September 8, 2011, the Committee on Committees, Ethics and Rules “re-referred” it to the Committee on Health and Environmental Protection. This is a companion post to Rollin’ beyond coal, on Grid Chicago.

What the Clean Power Ordinance is

It sets emissions standards for coal-powered plants in Chicago. It applies modern standards about air pollution, as they apply to coal and natural gas power plants, to any coal-powered plant in Chicago.

The Chicago Clean Power Coalition has a summary of the ordinance.

Why this is needed

Residents of Pilsen, Little Village, Bridgeport and other communities (pollution has no boundary) have suffered for decades from the release of carbon dioxide, mercury, lead, hydrochloric acid and other chemicals into the air. Read the Toxics Release Inventory for the Fisk Generating Station.

A large portion of the population is 18 and younger; this portion is growing. Pollution has a greater negative effect on young people.

The Fisk and Crawford power plants, owned by Midwest Generation, a subsidiary of Edison International, were grandfathered in to the Clean Air Act of 1970. That means the standards imposed by that legislation don’t apply.

The ordinance’s “Whereas” clause lists six studies that define the effects of certain levels of particulate matter (better known as soot) on human disease, mortality, and life expectancy. A 2002 Harvard study (PDF) that found the power plants combined caused 41 premature deaths per year.

What else

It appears that Alderman JoAnn Thompson, 16th Ward, is no longer a co-sponsor. The Chicago Clean Power Coalition lists her as a co-sponsor as of August 12, 2011, but on the ordinance document (ordinance number O2011-6489) published on the City Clerk’s website, her name is missing.

Midwest Generation, or one of its sister companies, Edison Mission Energy, is known to have lobbied the City Council, the Mayor’s Office, and the Department of Environment in 2010. “Midwest Generation officials said the ordinance is not needed because they already have started to comply with federal standards that will significantly cut pollution at their plants” (Chicago Tribune). The company also claims that a shutdown of the plant will harm electricity supply in Chicago. On that:

Chicago doesn’t actually need the electricity from the plants, though if the plants go offline before ongoing upgrades to local transmission infrastructure are completed it could cause instability on the grid including possible blackouts, according to a spokesman for the utility ComEd. (Midwest Energy News)

Alderman Solis (25th Ward) joined Alderman Joe Moore (49th Ward) during the election time this year as a lead sponsor, to help save his seat on the council in a fight with Cuahetemoc “Témoc” Morfin.

What’s next

Since the Committee on Committees, Ethics and Rules (CCER) “re-referred” it to the Committee on Health and Environmental Protection (CHEP), the members of CHEP, 18 of which are also on CCER, must discuss the ordinance. Oddly, CHEP did not place on its agenda for their Tuesday, September 27, 2011, meeting a consideration of the ordinance. After discussion, the committee can recommend that the full council vote on it. If the council passes it, Mayor Emanuel can sign or veto it.

In July, Mayor Emanuel talked about his support for the ordinance but didn’t go so far as to endorse it.

How to upload shapefiles to Google Fusion Tables

September 25, 2011 / / 0 Comments

It is now possible to upload a shapefile (and its companion files SHX, PRJ, and DBF) to Google Fusion Tables (GFT).

Before we go any further, keep in mind that the application that does this will only process 100,000 rows. Additionally, GFT only gives each user 200 MB of storage (and they don’t tell you your current status, that I can see).

  1. Login to your Google account (at Gmail, or at GFT).
  2. Prepare your data. Ensure it has fewer than 100,000 rows.
  3. ZIP up your dataX.shp, dataX.shx, dataX.prj, and dataX.dbf. Use WinZip for Windows, or for Mac, right-click the selection of files and select “Compress 4 items”.
  4. Visit the Shape to Fusion website. You will have to authorize the web application to “grant access” to your GFT tables. It needs this access so that after the web application processes your data, it can insert it into GFT.
  5. If you want a Centroid Geometry column or a Simplified Geometry column added, click “Advanced Options” and check their checkboxes – see notes below for an explanation.
  6. Choose the file to upload and click Upload.
  7. Leave the window open until it says it has processed all of the rows. It will report “Processed Y rows and inserted Y rows”. You will be given a link to the GFT the web application created.

Sample Data

If you’re looking to give this a try and see results quickly, try some sample data from the City of Chicago data portal:

Notes

I had trouble many times while using Shape to Fusion in that after I chose the file to upload and clicked Upload, I had to grant access to the web application again and start over (choose the file and click Upload a second time).

Centroid Geometry – This creates a column with the geographic coordinates of the centroid in a polygon. It lists it in the original projection system. So if your projection is in feet, the value will be in feet. This is a function that can easily be performed in free and open source QGIS, where you can also reproject files to get latitude and longitude values (in WGS84 project, EPSG 4326). The centroid value is surrounded in the field by KML syntax “<Point><coordinates>X,Y</coordinates></Point>”.

Simplified Geometry – A geometry column is automatically created by the web application (or GFT, I’m not sure). This function will create a simpler version of that geometry, with fewer lines and vertices. It also creates columns to list the vertices count for the simple and regular geometry columns.

Notable about Chicago transit: Bikes

September 23, 2011 / / 0 Comments

I forgot where I heard this, but it’s from a guy named Adam (he might be from Ireland*):

Biking in Chicago is great… because you can give up and at any time… and put your bike on a bus.

He’s right – every single one of the Chicago Transit Authority’s 2,000+ buses have bike racks to hold two bicycles.

Photo by jochemberends. Visit the Bikes and Transit group on Flickr for more photos like this.

*My notes are vague.

Introduction to DIY bike ridership research

September 20, 2011 / / 0 Comments

A lot of people ask me how many people are out there bicycling.

“Not a lot”, I tell them.

And I explain why: the primary source of data is the American Community Survey, which is a questionnaire that asks people questions about how they got to work in a specific week. (More details on how it does this below.) We don’t have data, except in rare “Household Travel Surveys”, about trips by bike to school, shopping, and social activities.

It’s comparable across the country – you can get this data for any city.

Here’s how:

  1. Visit the “legacy” American FactFinder and select American Community Survey, operated by the United States Census Bureau.
  2. Select 2005-2009 American Community Survey 5-Year Estimates (or the latest 5-year estimate). This is the most accurate data.
  3. In the right-side menu that appears, click on “Enter a table number”.
  4. In the new window, input the table number ” S0801″ (“Commuting Characteristics by Sex”) and submit the form. The new window will close and the other window will go to that table.
  5. Now it’s time to select your geography. In the left-side menu, under “Change…” click on “geography (state, county, place…)”
  6. In the window to change your geography, select “Place” as your “Geographic Type”.
  7. Then select the state.
  8. Then select your city and click “Show Result”.
Notes:
  • This data shows all modes people take to work, who live in that city. It’s highly probable that people are leaving the city to their jobs on these modes. For example, someone who lives in Rogers Park may ride their bike to work in Evanston.
  • The URL is a permanent link to this dataset. Each city has a unique URL. You should save these as bookmarks so you can easily reference the data later.
  • The question on the survey doesn’t allow multiple choices: “People who used more than one means of transportation to get to work each day were asked to report the one used for the longest distance during the work trip”.

Using Google Fusion Tables to create individual Chicago Ward maps

September 13, 2011 / / 0 Comments

I wanted to create a map of the 35th Ward boundaries using Google My Maps for a story on Grid Chicago. I planned to create this by taking the Chicago Wards boundary shapefile and exporting just the 35th Ward using QGIS into a KML file. I ran into many problems and ended up using Google Fusion Tables as the final solution.

The problems

First, QGIS creates invalid KML files. Google Earth will tell you this. I opened the KML file in a text editor and removed the offending parts (Google Earth mildly tells you what these are; you can use this validator to get more information).

Second, Google My Maps would not import the KML file. I tried a different browser and a different KML file; a friend ran into the same issue. I reported this problem to Google.

The solution

I uploaded to Google Fusion Tables a KML file containing all wards. I did this instead of uploading the single Ward because, like a database, I can filter values in the column, selecting only the row I want with “ward=35”.

After applying the filter, the map will show the boundary for just that ward. I grab the HTML code for an embeddable map and voila, the article now displays an interactive map of the 35th Ward.

Whenever I want to create a map for a different ward, I go back to this Fusion Table, make a new filter and copy the new HTML code.

A screenshot of the embedded map, showing just 1 of 50 wards, in the Grid Chicago article. 

Elsewhere

I had the same problems with QGIS exporting and uploading the KML files to My Maps the other day when I was creating maps for the abandoned railroads for Monday’s Grid Chicago article. Not thinking about Fusion Tables, I drew on the map with my mouse the lines.

Screenshot of the map of abandoned railroads.