Page 51 of 173

What’s up from Europe: London pedestrian spaces

April 12, 2014 / / 0 Comments

I found walking around in London a tad stressful, as crossing the street can only be safely done at signalized intersections, or at zebra crossings with the flashing yellow globe. Crossing the street safely is then compounded by the left-driving traffic. The “< Look Left” and “Look Right >” messages aren’t printed at all intersections and there’s a delay at signalized intersections because you can’t cross every other phase: you have to wait until the all-walk phase (when signals stop traffic in all directions).

However, London still has a lot of great pedestrian spaces and alleys (with bars and pubs) scattered around the town. It doesn’t have as much car-free space as city centers in the Netherlands and Germany. These three photos show three spaces on my many long walks around the town during my three-day trip there*.

Hay’s Galleria, seen on my Thames Path walk along the south bank. It was redeveloped in 1987 to the design and condition you see here. Like many pedestrian spaces I passed by and walked through this one is privately owned (and monitored). 

This pedestrian space off of St. John’s Road near the Clapham Junction station (with National Rail and London Overground services) was created simply by blocking car traffic from entering or exiting St. John’s Road. It has distinct pavers that match the high street – it’s not exactly a shared space as buses have priority but there is limited traffic otherwise because only delivery and construction workers can access the road. 

Old Spitalfields Market has been redeveloped – it maintains the old buildings and look on the edges with shops and restaurants but has a modern glass and steel roof with modern construction on the interior for more shops and restaurants. Even if you aren’t shopping here passersby can use it as a shortcut through the block. 

View more photos as I upload them directly from my iPhone to Flickr.

* Calling it three days is a stretch because I was tired and slept a lot, missing precious walking and exploring time. I still managed to spend over an hour walking around Queen Elizabeth Olympic Park and go shopping at Westfield Stratford City for about two hours.

Respect the corner!

April 5, 2014 / / 0 Comments

Buildings on corners should have corner entrances or minimally deviate.

Contractors work on building the new entrance.*

The residential building on the northwest corner of Milwaukee Avenue and Halsted Street was built in 2003 with a first-floor commercial space with an entrance on the Milwaukee Avenue side. Normally this wouldn’t be such a big deal – Milwaukee is a busy street and this side of the street has a fair amount of foot traffic. But the other side of the building, on Halsted Street, faces one of two entrances to the Grand Blue Line subway station and a major transfer bus stop.

7-11 is moving into the building and have built a new entrance out of the corner space with floor-to-ceiling windows. Now it’ll be much easier for transit riders to get to a convenience store. The other advantage is the added visibility: seeing the entrance from far away, from all sides, saves milliseconds in our internal GPS processing time – make a bee-line to the entrance instead of “hunting” it down after you make your way in the general direction of the building.


View Larger Map

* You can see that there’s a step here so it’s not currently accessible. Originally this wasn’t the entrance so that makes sense. I don’t know what these contractors are doing but 7-11 must make the entrance accessible.

Welcome to the Land of No

April 5, 2014 / / 8 Comments

No bike riding!

The Lincoln Park Zoo has a Nature Boardwalk at the South Pound near 2000 N Cannon Drive. Each venue has their own signs listing the rules for their respective properties.

Each sign employs a different symbol to communicate the same thing – bicycles cannot be ridden in the parks – but their designs take two approaches.

One says no and the other says yes.

  • The Zoo’s symbol uses the color red, a line slashed over a bicycle, and “Please do not:” text to prohibit the activity of riding a bike.
  • The Pond’s symbol uses the color blue and suggests walking your bike, accompanied by the text, “Please walk your bike”.

Please walk with your bicycle. 

Bicyclists – and drivers for that matter – are constantly being told no. Might there be a friendlier, more positive way to communicate rules?


View Larger Map

Even the grocery stores are bike-friendly in Portland

April 3, 2014 / / 0 Comments
Kenda tube vending machine

Swipe your bank card and get a new inner tube, next to a repair stand to help you change it.

Mike Cobb sent me this photo of a vending machine outside the Green Zebra Grocery in Portland, Oregon, that sells Kenda brand bicycle inner tubes. These vending machines are more common in Germany and the Netherlands although I only spotted one in Berlin.

Fahrrad schläuche

A tube vending machine, Fahrrad schläuche in German, outside a bike shop in Berlin.

He says they have a repair stand under shelter, air pump, tethered tools, and all-weather electricity outlets, too.

“Yeah, I’ll shop there every time I’m within a 1/2 mile,” he said. Mike is busy planning Disaster Relief Trials around the country this year and we’re working to make one happen in Chicago. But we need a title sponsor who has thousands of dollars to donate.

Seattle DRT: did it! (photo by Fred Bretsch, FEMA Region 10)

Mike in Seattle after winning DRT there. Photo by Fred Bretsch, FEMA Region 10.

Finding interesting data in the building permits dataset

March 26, 2014 / / 0 Comments

I had several great conversations with fellow #chihacknight visitors at the 1871 tech hub (222 W Merchandise Mart Plaza) about how to reveal more information about what’s being built in Chicago. I had introduced Licensed Chicago Contractors at the previous week’s hack night and tonight I showed site changes I made like how much faster it is now that I use DataTables’s server-side processing function.

Some of the discussions resulted in suggestions to try new tools and methods that would make processing the data more efficient, or more revealing. What are the ways I can aggregate the data, or connect to similar data from other sources?

One of the new features I announced I’ll be adding is statistics on building activity by neighborhood. I started testing some queries to see the results, and to find the query that outputs that information in a way that’ll pique users’ interests.

I calculated the aggregate estimated costs of all building permit activity for the past 90 days in select neighborhoods. All of the data was automatically generated using a simple MySQL query, but one that will get faster after switching to Postgres. (I eliminated any project whose estimated cost was less than $1,000 because there are many project types that are $0 to several hundred dollars.)

  • Logan Square: 77 projects, totaling $16,295,997.50 at a $211,636.33 average cost
  • West Loop: 30 projects, totaling $27,646,899.00 at a $921,563.30 average cost
  • Andersonville: 6 projects, totaling $358,770.00 at a $59,795.00 average cost
  • Bronzeville: 34 projects, totaling $17,050,662.00 at a $501,490.06 average cost
  • Hyde Park: 20 projects, totaling $13,492,265.00 at a $674,613.25 average cost
  • Humboldt Park: 35 projects, totaling $41,917,988.00 at a $1,197,656.80 average cost

How does Humboldt Park double the other neighborhoods’ average? I think it’s pretty simple: this $40 million Salvation Army residence that’s going to be built at 825 N Christiana Avenue.

The results for Bronzeville were higher than I expected because this is a distressed neighborhood that has lost of lot of population and has seen little development in the past several years. This isn’t to say the neighborhood is poor – I saw a report last fall that highlighted how the purchasing power of Bronzeville residents was quite high relative to neighboring communities.

Ronnie Harris showed me the report when I participated in the Center for Neighborhood Technology’s civic app competition and hackathon. We, along with Josh Engel, designed Build It! Bronzeville, although my participation was really pushing them to develop Josh’s game idea more and construct a paper version of it. Our team won the competition and Ronnie and Josh have kept working on it (I saw them at last week’s hack night).

Projects that pushed up Bronzeville’s average included several multi-family homes at around $1.4 million each on the blocks of 4700 and 4800 S Calumet Avenue.

Code discussion

I can’t test for the “Loop” right now in the way I have my data structured because a LIKE ‘%loop%’ query of the database will include “West Loop” records.

I need to change how the building permit data is stored – in my database – a little so that my site’s PHP codebase and MySQL queries can sift through the data faster. For example, I’m storing several key-value pairs as a JSON-encoded string in a TEXT field. One #chihacknight developer suggested I switch from MySQL to PostgreSQL because Postgres has native JSON-parsing functions.

I looked up how to use Postgres’s JSON functions and realized that, yes, I probably should do that, but that I also need to change the array structure of the data I’m encoding to JSON. In other words, with a tiny change now, I can be better prepared for the eventual migration to Postgres.