{"id":6,"date":"2021-11-28T21:08:05","date_gmt":"2021-11-29T04:08:05","guid":{"rendered":"https:\/\/blogs.ubc.ca\/vancouvergreenprojects\/?page_id=6"},"modified":"2021-12-15T21:17:12","modified_gmt":"2021-12-16T04:17:12","slug":"methods","status":"publish","type":"page","link":"https:\/\/blogs.ubc.ca\/vancouvergreenprojects\/methods\/","title":{"rendered":"Methods"},"content":{"rendered":"
Data Acquisition<\/h5>\n

Listed below is a table of our current obtained datasets to conduct this project (refer to table 1). Our list of datasets are acquired from a variety of credible sources including CHASS Canadian Census Data Center, Vancouver Open Data Portal, Metro Vancouver Open Data Catalog and Statistics Canada. They are acquired based on our need to conduct and demonstrate our analyses taking into account our area of study (Vancouver), infrastructures within our area of study, explanatory variables (income, population density, level of education attainment and visible minority population) and our dependent variable (Greenest City Projects).\u00a0\u00a0\u00a0<\/span><\/p>\n

Consequently, we are aware that the census data we are obtaining is quite outdated as it is obtained from the year 2016 for all of our variables. We are taking this into consideration as a limitation and a recommendation to future studies in this field.\u00a0<\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Layer\/Datafile Name<\/b><\/td>\nDescription<\/b><\/td>\nAttributes (that will be utilized)\u00a0<\/b><\/td>\nData Source<\/b><\/td>\nFile Type, Entity<\/b><\/td>\nYear of Publication<\/b><\/td>\n<\/tr>\n
Visible Minority (CT)<\/span><\/td>\n2016 Statistics Canada Census Data of the total population of visible minorities by Census Tract<\/span><\/td>\nCOL2 – Visible Minority<\/span><\/td>\nCHASS<\/span><\/td>\n.csv, Raster<\/span><\/td>\n2016<\/span><\/td>\n<\/tr>\n
Population Density (CT)<\/span><\/td>\n2016 Statistics Canada Census Data of the total population density by Census Tract<\/span><\/td>\nCOL1 – Population Density per square kilometer<\/span><\/td>\nCHASS<\/span><\/td>\n.csv, Raster<\/span><\/td>\n2016<\/span><\/td>\n<\/tr>\n
Population (CT)<\/span><\/td>\n2016 Statistics Canada Census Data of the total population density by Census Tract<\/span><\/td>\nCOL1 – Total Population<\/span><\/td>\nCHASS<\/span><\/td>\n.csv, Raster<\/span><\/td>\n2016<\/span><\/td>\n<\/tr>\n
Education Levels (CT)<\/span><\/td>\n2016 Statistics Canada Census Data of the highest educational attainment by Census Tract<\/span><\/td>\nCOL1 – Highest Educational Attainment for population ages 25 to 64<\/span><\/td>\nCHASS<\/span><\/td>\n.csv, Raster<\/span><\/td>\n2016<\/span><\/td>\n<\/tr>\n
Levels of Income (CT)\u00a0<\/span><\/td>\n2016 Statistics Canada Census Data of the total income of households by Census Tract<\/span><\/td>\nCOL1 – \u200b\u200bTotal income statistics for the population aged 15 years and over in private households<\/span><\/td>\nCHASS<\/span><\/td>\n.csv, Raster<\/span><\/td>\n2016<\/span><\/td>\n<\/tr>\n
Greenest City Projects\u00a0<\/span><\/td>\nPoint data on the location of every \u201cGreen City\u201d project implementation between 2011 and 2020<\/span><\/td>\nEntire Dataset Used<\/span><\/td>\nVancouver Open Data Portal<\/span><\/td>\n.shp, Vector points<\/span><\/td>\n2021<\/span><\/td>\n<\/tr>\n
2016 Generalized Land Use Classification<\/span><\/td>\nPolygon file of all land use classifications within the Metro Vancouver Region<\/span><\/td>\nEntire Dataset Used<\/span><\/td>\nMetroVancouver Open Data Catalogue<\/span><\/td>\n.shp, Vector Polygons<\/span><\/td>\n2016<\/span><\/td>\n<\/tr>\n
Vancouver Area Boundary<\/span><\/td>\nPolygon shapefile of all Canada province boundaries<\/span><\/td>\nPolygons within the Metro\u00a0 Vancouver Region\u00a0<\/span><\/td>\nStatistics Canada\u00a0<\/span><\/td>\n.shp, Vector polygons<\/span><\/td>\n2011<\/span><\/td>\n<\/tr>\n
Coastal Waters<\/span><\/td>\nBoundary File of Canada\u2019s coastal waters<\/span><\/td>\nEntire Dataset Used\u00a0<\/span><\/td>\nStatistics Canada<\/span><\/td>\n.shp, Vector Polygons<\/span><\/td>\n2011<\/span><\/td>\n<\/tr>\n
Public Streets<\/span><\/td>\nVector file displaying all major roads and streets within Vancouver<\/span><\/td>\nEntire Dataset Used<\/span><\/td>\nVancouver Open Data Portal<\/span><\/td>\n.shp, Vector Line\u00a0<\/span><\/td>\n2019<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Table 1: List of Datasets used within our final project which will be mapped onto ArcGIS Pro<\/em><\/p>\n

Normalizing Population Density Data<\/b><\/h5>\n

To begin the analysis of our variables, we required an accurate population density of each Census Tract that could be adequately compared against \u201cGreenest City\u201d project locations. This was done as a countermeasure of Statistics Canada\u2019s methods of calculating population density, which is done by dividing the population of a neighborhood boundary (CT or DA) by the square footage of that area. This poses an issue with accuracy when considering the variety of land uses within an area, given that this method assumes all land use to be residential (EPA Gov, 2015). To counter this issue, we conducted dasymetric mapping to the Statistics Canada Population data that would consider only residential land coverage in population density calculations (Process shown in Chart 1). Displayed below (Map 3) is a display of residential vs. non-residential land use distributions highlighting its discrepancies, and how this can drastically skew population density data and our intended analyses. As visualized by Stanley Park (shown in inset Map 3), we can see how its low population density rate does not reflect the entire region, rather it is the vast non-residential parkland that skews the high density that exists in one corner of the CT and alters how the boundary area is considered in our calculations.<\/span><\/p>\n

\"\"Chart 1:<\/a> Flowchart depicting the steps taken in normalizing population density to accurately reflect land-use<\/em><\/p>\n

\"\"Map 2:<\/a> Map Depicting the Distribution of Residential and Non-Residential Land-use areas to be utilized in our Population Density Normalization<\/em><\/p>\n

\"\"<\/p>\n

Map 3:<\/a> Map depicting the spatial difference in Statistics Canada Population Density and our Normalized True Population Density. Map Units are displayed in Percentages.<\/em><\/p>\n

\"\"<\/p>\n

Chart 2:<\/a> Scatterplot depicting the difference between the values of\u00a0 Statistics Canada Population Density and our Normalized True Population Density<\/em><\/p>\n

Spatial Comparison of <\/b>Explanatory Variables<\/b><\/h5>\n

Prior to utilizing statistical analyses, we found it helpful to create visual comparisons of our four variables against \u201cGreenest City\u201d project areas in order to make inferences as to whether notable spatial divisions exist. Each variable was presented on our base map and given graduated colors on a 5 class value scale. Results showed that for each variable, values appear to be clustered which indicates to us the likely occurrence of spatial autocorrelation. Specifically, it appears as though the higher values of each predictor are found near areas in which Greenest City projects are the most frequent (Map 4). <\/span><\/p>\n

\"\"Map 4:<\/a> Spatial Comparison of Exploratory Variables Against Greenest City Project Locations. Map Units for Education, Income, Visible Minority are full population numbers, Map Units for Population Density is in Percentages.<\/em><\/p>\n

Spatial Autocorrelation\u00a0<\/b><\/h5>\n

Commencing our spatial analysis, we began by utilizing the Spatial Autocorrelation tool in order to determine whether our variables are influenced by systemic spatial variation, and visualize potential clusterings of values.<\/span><\/p>\n

Exploratory Regression Analysis<\/b><\/h5>\n

In order to evaluate the significance of our explanatory variables and compare for any evidence of multicollinearity, we chose to utilize an exploratory regression analysis. An exploratory regression analysis is a data mining tool that tests all combinations of explanatory variables to determine which models pass outlines necessary OLS Diagnostics, and indicate consistent predictor variables as well as whether any explanations are missing. The parameters for our analysis are as follows:\u00a0<\/span><\/p>\n

\"\"Parameter 1:<\/a> Imputed parameters in conducting an Exploratory Regression Analysis for Greenest City Projects against Explanatory Variables.<\/em><\/p>\n

Generalized Weighted Regression Analysis<\/b><\/h5>\n

Following our Exploratory Regression Analysis, we performed a Generalized Weighted Regression Analysis which would allow us to examine the ways in which the relationships between our dependent variable and predictor variables might vary over space. This analysis would additionally allow us to take a step further in drawing conclusions around whether the variable coefficients change depending on their spatial location. The parameters for our analysis are as follows:<\/span><\/p>\n

\"\"Parameter 2:<\/a> Imputed parameters in conducting a Generalized Weighted Analysis for Greenest City Projects against Explanatory Variables.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

Data Acquisition Listed below is a table of our current obtained datasets to conduct this project (refer to table 1). Our list of datasets are acquired from a variety of credible sources including CHASS Canadian Census Data Center, Vancouver Open Data Portal, Metro Vancouver Open Data Catalog and Statistics Canada. They are acquired based on … Continue reading Methods<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":69919,"featured_media":0,"parent":0,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-6","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.ubc.ca\/vancouvergreenprojects\/wp-json\/wp\/v2\/pages\/6","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ubc.ca\/vancouvergreenprojects\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.ubc.ca\/vancouvergreenprojects\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/vancouvergreenprojects\/wp-json\/wp\/v2\/users\/69919"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/vancouvergreenprojects\/wp-json\/wp\/v2\/comments?post=6"}],"version-history":[{"count":26,"href":"https:\/\/blogs.ubc.ca\/vancouvergreenprojects\/wp-json\/wp\/v2\/pages\/6\/revisions"}],"predecessor-version":[{"id":144,"href":"https:\/\/blogs.ubc.ca\/vancouvergreenprojects\/wp-json\/wp\/v2\/pages\/6\/revisions\/144"}],"wp:attachment":[{"href":"https:\/\/blogs.ubc.ca\/vancouvergreenprojects\/wp-json\/wp\/v2\/media?parent=6"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}