ArcView Components |
Data Manipulation
|
|
Data Collection
Data for this project were collected from the following sources.
ArcView Components
1. Spatial Data (shape files): SIS network under S drive's Data Warehouse folder
a. Enumeration areas.shp
Query builder was used to select only Vancouver, Burnaby, and New Westminster. They were prepared to work with Census EA data.
b. Muni.shp
Three municipalities were compiled together using Summarize merge function. This was later then used to convert to raster.
c. GVRD_1996_landuse.shp
The land use for only three cities were extracted using Select by theme function (intersect).
d. Majorroads.shp
Major road network of GVRD was obtained.
e. hospitals.shp
Twelve hospitals in Vancouver, Burnaby, and New Westminster were digitized in ArcView.
a. Age (Profile of enumeration area)
CAP table of Part 1: Age and Sex and Families was downloaded and modified in Beyond 2020 in order to transpose the data. Then it was saved as .dbf to work in Microsoft Excel.
b. Income (Profile of enumeration area)
CAP table of Part 8: Sources of Income was downloaded and modified in Beyond 2020 in order to transpose the data. Then it was saved as .dbf to work in Microsoft Excel.
c. Population (Profile of enumeration area)
CAP table of Part 1: Age and Sex and Families was downloaded and modified in Beyond 2020 in order to transpose the data. Then it was saved as .dbf to work in Microsoft Excel.
There were 23 different age categories for male and female. In order to find the average age for each EA, the number of people for each age category was multiplied by the median age for that category (46 categories all together). Then, those numbers were added all together for each EA. Later, they were divided by total male and female to find the final average age for each EAs. The average ages for the study areas, Vancouver, Burnaby, and New Westminster, were joined to the theme table based on EA numbers after creating a new field, average age.
Population data, which was modified in Beyond 2020 was joined based on EA numbers in the theme table of the EA shape file. Then a new field, population density, was created. Using Calculate function in ArcView, total population for each EA was divided by area (m2) in order to find population density.
The following shapefiles were converted to ascii raster format in ArcView and then imported as rasters in Idrisi.
a. Muni.shp
b. Landuse.shp
c. Majorroads.shp
d. hospitals.shp
e. age96.shp
f. income96.shp
g. density96.shp
