All layers listed below were projected to the Oregon State Plane Coordinate System and were clipped to the city of Portland boundary. Crime events were geocoded by using their X, Y coordinates and "Collect Events" was used to account for crime events that were located at the same location. The Block Group (BG) census boundary shape was used as an input table to join population variables including "percent age 10-19" and "percent under poverty level."
Zonal Statistics was used to summarize the number of streetlights, number of crimes and canopy cover by BG. In order to summarize the canopy raster, it was reclassified as a binary raster, zonal statistics as table was used to identify the sum of pixels with canopy calculate the percentage based on the cell count for each BG. To calculate park cover, "tabulate intersection" was used between parks and block groups and the park area was summarized by BG, then calculated as a percentage of total land area.
DATA MANAGEMENT
Portland Crime 2014
Crime points for the Portland Metro area, which are scrubbed of personal identifying information and setup for appopriate public access.
Zoning 2014
City of Portland Zoning/Comp Plan data. This is for the current adopted zoning only. When the zoning changes, a new dataset is uploaded reflecting the change. Includes 3 Shapefiles. One for Zoning area, one for Zoning Boundary lines and one for Zoning text.
Streetlights 2014
Points representing the location of street lights in the City of Portland. Attribute information includes Asset ID, owner, maintainer, location ID, power supplier, and other relevant details.
Street Centerlines
Street Centerlines in the City of Portland. Includes local streets to freeways
Parks
Park Boundary dataset derived from taxlots that compose the park site. Attributes include Parkname and Propertyid. Propertyid field is key link to other data sources in Parks.
Poverty Status
Percent of the population below the poverty level.
Vegetation (Canopy 2014)
Developed using LiDAR and imagery collected in the summer of 2014. Canopy was detected using a combination of normalized difference vegetation index (NDVI) from the imagery and feature heights from LiDAR. Geometric post-processing was used to clean up errors and noise (i.e., electrical lines above green vegetation). Developed in conjunction with the Canopy 2007 layer.
2014 TIGER/Line® Shapefiles: Block Groups
Total Population 2014 ACS 5-year estimates
% 10-19 population
Portland City Boundary
Data Layers and Tables
In order to calculate the urban street density in each BG, Line and Junction Connectivity (Esri Inc. lbeale@esri.com) was used to identify junctions with more than 2 lines and create a layer of points at their intersections. "Join Spatial Data" was used to sum the number of junctions in each BG.All variables were normalized to identify their relative importance and scaled for convenience in the analysis:-crime rate: crime events / population*100,000-park percent: park area / total area *100-light intensity: streetlights / total area, converted to acres-Junction density: Junction # / total area, converted to acres