Tuesday, June 2, 2009

Workshop Info

For the past few days we've been heading to Universidade Positivo in the afternoons to work on our workshop goings-ons. My group has been organizing the data that is relevant to us into a cohesive (single) spreadsheet, collecting bits of information from various electronic documents and printed maps and matching names with lot numbers. It has been time consuming but today we finally started crunching some of our agolmerated numbers.

Also today, I started working with a GIS shapefile of the lots in Vila Nova. I organized the individual lots into our various "Sectors" (about 40) and our "Supersectors" (6) so that we could visually represent our measures of socioeconomic status. The map pictured below is our sectors, which are organized based on street frontage and access. We had to make the Supersectors becuase we had so few surveys completed and many sectors had less than 3 surveys from them, and therefore not enough data to draw any decent conclusions.

Out of about 850 lots we had around 140 surveys, which were sorted into the sectors that they came from via a fun process of matching the address (and possibly a name) on the paper survey to a spreadsheet on a computer that had addresses paired with lot numbers. Then the lot was found on the colorful map and the sector number was put on the survey and the survey into the appropriate pile. It felt like CSI: Urban Planning.





































Our workspace at the university.

No comments:

Post a Comment