clarke square housing project
DESCRIPTION
The mission of CSNI is to improve the Clarke Square neighborhood and benefit community residents. The Clarke Square Quality of Life Plan strategies include housing, economic development, health and wellness, and public safety.”TRANSCRIPT
![Page 1: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/1.jpg)
Clarke Square Housing ProjectUrban Planning 793
Mike Callovi, Marissa Meyer, and Maggie Thelen
![Page 2: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/2.jpg)
Project Background
![Page 3: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/3.jpg)
Clarke Square Neighborhood
source: www.clarkesquare.org
![Page 4: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/4.jpg)
Clarke Square Neighborhood InitiativeThe mission of CSNI is to improve the Clarke Square neighborhood and benefit community residents.
The Clarke Square Quality of Life Plan strategies include housing, economic development, health and wellness, and public safety.”
source: www.clarkesquare.org
![Page 5: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/5.jpg)
Project VisionCSNI will be able to:
● spatially display, interpret, and track housing quality changes over time
● identify patterns so that resources can be targeted● inform the community about the results of the analysis
![Page 6: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/6.jpg)
Project Scope1) Data Analysis and Visualization
● Importing survey data● Joining to other data sources● Analyzing patterns statistically and spatially
2) Database Documentation● Creating guides for future CSNI use
3) Field Data Collection Application Creation ● Future opportunity with ArcGIS Online software
![Page 7: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/7.jpg)
Data Collection & Analysis Methods
![Page 8: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/8.jpg)
Residential Areas in Clarke Square
![Page 9: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/9.jpg)
Fall 2015 Housing Survey During the fall of 2015, volunteers with CSNI completed an exterior housing survey.
Categories
● Roof● Exterior Characteristics● Windows and Doors● Porch● Yard● Garage
Marked whether the house needed a major, minor, or no repair
![Page 10: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/10.jpg)
Fall 2015 Housing Survey ● Other Conditions (Yes/No)
○ Appears Vacant ○ Boarded House○ Graffiti
● Overall Exterior Condition (Grade A - F)● Overall Attractiveness (Very/Somewhat Attractive or Unattractive)● Overall Homeowner Pride (Great/Moderate/No Extent)
![Page 11: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/11.jpg)
Clarke Square Survey
Data Collection
Analysis Methods
Initial Challenges
![Page 12: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/12.jpg)
Clarke Square Survey Data ● 1173 residential housing logs for the community● 41 fields (32 ratings)
![Page 13: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/13.jpg)
Re-coded & analyzed data Joined to Milwaukee parcel data via taxkey codes
![Page 14: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/14.jpg)
Aggregated Parcels into Blocks
![Page 15: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/15.jpg)
Aggregated Parcels into Blocks
![Page 16: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/16.jpg)
Aggregated Parcels into Blocks→ Created Maps
![Page 17: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/17.jpg)
Aggregated Parcels into Blocks→ Created Maps
![Page 18: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/18.jpg)
Results
![Page 19: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/19.jpg)
Category Averages
Scale
3: No repair
2: Minor repair
1: Major repair
Category Average Standard Deviation
Roof 2.594 0.485
Exterior (Paint) 2.542 0.557
Window and Door 2.488 0.589
Porch 2.591 0.481
Yard 2.682 0.423
Garage 2.659 0.503
![Page 20: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/20.jpg)
Statistical Analysis● 57 unique surveyors
○ Three initials (JR, TR, and DR) were used by multiple volunteers and discarded for analysis
● Mean 20 surveys each● Top five surveyors
○ LV: 74 ratings○ KW: 47 ratings○ JL: 43 ratings○ BB: 40 ratings
○ KC: 33 ratings
![Page 21: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/21.jpg)
Volunteer-Rated Overall Exterior Condition● Rating scale: 1 (letter grade
F, three or more major repairs needed) to 5 (letter grade A, outstanding condition)
● Mean: 3.40● Standard deviation: 1.15● Individual surveyor
averages ranged from 1.70 to 4.50
![Page 22: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/22.jpg)
Volunteer-Rated Overall Exterior ConditionTop 5 Surveyors
Surveyor Number of Ratings Surveyor Mean
Surveyor Difference from
Mean
Statistically Different? (p<0.
05)
LV 74 1.89 -1.51 Yes
KW 47 3.77 0.36 Yes
JL 43 3.98 0.57 Yes
BB 40 3.50 0.10 No
KC 33 3.27 -0.13 No
All Ratings Mean: 3.40
![Page 23: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/23.jpg)
![Page 24: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/24.jpg)
Calculated Overall Exterior Condition● Scale
○ 3: No repair○ 2: Minor repair○ 1: Major repair
● Mean: 2.58● Standard deviation: 0.39● Individual surveyor
averages ranged from 1.78 to 2.91
![Page 25: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/25.jpg)
Calculated Overall Exterior ConditionTop 5 Surveyors
Surveyor Number of Ratings Surveyor Mean
Surveyor Difference from
Mean
Statistically Different? (p<0.
05)
LV 74 2.25 -0.33 Yes
KW 47 2.82 0.24 Yes
JL 43 2.72 0.14 Yes
BB 40 2.73 0.15 Yes
KC 33 2.32 -0.27 Yes
All Ratings Mean: 2.58
![Page 26: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/26.jpg)
Volunteer vs. Calculated Overall Exterior Condition
![Page 27: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/27.jpg)
Clarke Square Survey Total Number of Maps:
● Roof Average● Exterior of the House Average● Yard Average● Porch Average● Windows and Doors● Garage
➔ Some weak clustering present
➔ Surveyor bias may influence clustering
![Page 28: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/28.jpg)
Calculated Overall Exterior Condition
Category Parcels
Minimal Repair 616
Moderate Repair 391
Major Repair 161
![Page 29: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/29.jpg)
Volunteer Rated Overall Exterior Condition
![Page 30: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/30.jpg)
Volunteer Rated Overall Exterior Condition--Blocks
![Page 31: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/31.jpg)
Volunteer Rated Overall Attractiveness
![Page 32: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/32.jpg)
Volunteer Rated Overall Attractiveness--Blocks
![Page 33: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/33.jpg)
Volunteer Rated Household Pride
![Page 34: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/34.jpg)
Volunteer Rated Household Pride--Blocks
![Page 35: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/35.jpg)
Roof Characteristics
![Page 36: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/36.jpg)
Garage
![Page 37: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/37.jpg)
Exterior Household Characteristics
![Page 38: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/38.jpg)
Porch Characteristics
![Page 39: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/39.jpg)
Characteristics of Windows and Doors
![Page 40: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/40.jpg)
Yard Characteristics
![Page 41: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/41.jpg)
Appears Vacant
![Page 42: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/42.jpg)
Boarded Up Properties
![Page 43: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/43.jpg)
Graffiti
![Page 44: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/44.jpg)
Hot Spot Analysis● Used Hot Spot Analysis (aka Getis Ord Gi)
○ “Given a set of weighted features, identifies statistically significant hot spots and cold spots using the Getis-Ord Gi* statistic”
○ Inverse Distance Squared
● Cluster Analysis on:○ Calculated Overall Average
![Page 45: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/45.jpg)
Hot Spot Map
![Page 46: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/46.jpg)
Clustering ConclusionsNot a lot of parcels that were considered spatially significant.
Doesn’t mean that there are not potential issues in the neighborhood.
Spatially one can see clustering
![Page 47: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/47.jpg)
Recommendations
![Page 48: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/48.jpg)
Clarke Square Survey ● Changes to questionnaire● Additional training for
volunteers● Check and/or calibrate results
to director
![Page 49: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/49.jpg)
Clarke Square Survey ● Obtaining GIS software with ArcGIS Online
→ Future field data entry application
● Maintaining records to track changes over time
→ Utilize tutorial guide
![Page 50: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/50.jpg)
Thank you!Questions?
![Page 51: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/51.jpg)
CompareCalculated Overall Exterior Condition
Mean: 2.5
Volunteer Rated Overall Exterior Condition
Mean: 3.40
![Page 52: Clarke Square Housing Project](https://reader031.vdocuments.us/reader031/viewer/2022020719/579090fe1a28ab7b278f0604/html5/thumbnails/52.jpg)
Initial challenges
Conversion issues
Taxkey loss
Averaging IF > 0 so that we’re not including not applicable/observable
“Be aware guys”