{"id":2,"date":"2013-11-28T20:37:28","date_gmt":"2013-11-28T20:37:28","guid":{"rendered":"https:\/\/blogs.ubc.ca\/torontocrime\/?page_id=2"},"modified":"2013-12-04T16:19:39","modified_gmt":"2013-12-04T23:19:39","slug":"sample-page","status":"publish","type":"page","link":"https:\/\/blogs.ubc.ca\/torontocrime\/sample-page\/","title":{"rendered":"Methodology"},"content":{"rendered":"<p>To achieve the goal of this project, we underwent specific mandates to finalize our normative spatial analysis.<\/p>\n<ol>\n<li>Gather appropriate data. Using the Chass website from the University of Toronto (<a href=\"http:\/\/www.chass.utoronto.ca\/\">http:\/\/www.chass.utoronto.ca\/<\/a>), open data catalogue for the City of Toronto, and UBC abacus website, we were able to gather the appropriate data. These include police facilities, ambulance facilities.<\/li>\n<li>We were required to organize the data into the same projection format (GCS North American 1983) to avoid scale inaccuracies.<\/li>\n<li>Acquired quantitative data in excel format from the Chass website for average income, crime data, and demographic data.<\/li>\n<li>Data organization: certain census tracts did not have the proper CTUID expression, so we were required to convert all census tracts into number formats, and create a new value field delineating proper CTUID numbers. The last step for data organization was to convert these values to text format to use in ArcGIS.<\/li>\n<li>Join excel tables to ArcGIS from our geodatabase as a single table for each of the three variables. After each table was joined individually, we then joined each table into a single layer including the overlaying census tract shapefile.<\/li>\n<li>In order to express the data onto the layer for each variable, we identified categories and class breaks in order to give us a choropleth map showing violent crime rates per census tract. We did the same for each variable.<\/li>\n<li>Next, we used our previous shapefiles for ambulance and police facilities to create buffer zones of 1km overlaid onto violent crime rates to determine problem areas.<\/li>\n<li>Finally, we conducted a series of linear regression analyses using the ordinary least squares function for a combination of two out of three variables, and a one final map comparing all three variables. Additionally, we conducted a spatial autocorrelation (Moran&#8217;s I test) to determine statistical significance.<\/li>\n<\/ol>\n<p>The map below shows our area of interest being the City of Toronto.<\/p>\n<p><a href=\"https:\/\/blogs.ubc.ca\/torontocrime\/files\/2013\/11\/Study-Area-Map.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-27\" alt=\"\" src=\"https:\/\/blogs.ubc.ca\/torontocrime\/files\/2013\/11\/Study-Area-Map.jpg\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To achieve the goal of this project, we underwent specific mandates to finalize our normative spatial analysis. Gather appropriate data. Using the Chass website from the University of Toronto (http:\/\/www.chass.utoronto.ca\/), open data catalogue for the City of Toronto, and UBC abacus website, we were able to gather the appropriate data. These include police facilities, ambulance [&hellip;]<\/p>\n","protected":false},"author":19891,"featured_media":0,"parent":0,"menu_order":2,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-2","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.ubc.ca\/torontocrime\/wp-json\/wp\/v2\/pages\/2","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ubc.ca\/torontocrime\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.ubc.ca\/torontocrime\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/torontocrime\/wp-json\/wp\/v2\/users\/19891"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/torontocrime\/wp-json\/wp\/v2\/comments?post=2"}],"version-history":[{"count":7,"href":"https:\/\/blogs.ubc.ca\/torontocrime\/wp-json\/wp\/v2\/pages\/2\/revisions"}],"predecessor-version":[{"id":58,"href":"https:\/\/blogs.ubc.ca\/torontocrime\/wp-json\/wp\/v2\/pages\/2\/revisions\/58"}],"wp:attachment":[{"href":"https:\/\/blogs.ubc.ca\/torontocrime\/wp-json\/wp\/v2\/media?parent=2"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}