Color: [56, 168, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: left Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 8 Font Family: Arial Font Style: normal Font Weight: normal Font Decoration: none
Color: [56, 168, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: left Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 8 Font Family: Arial Font Style: normal Font Weight: normal Font Decoration: none
Color: [245, 122, 182, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: center Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 8 Font Family: Tahoma Font Style: normal Font Weight: normal Font Decoration: none
OWNER
(
type: esriFieldTypeString, alias: OWNER, length: 30
, Coded Values:
[City of Waterloo: City of Waterloo]
, [City of Kitchener: City of Kitchener]
, [Region of Waterloo: Region of Waterloo]
, ...12 more...
)
TYPE
(
type: esriFieldTypeString, alias: TYPE, length: 50
, Coded Values:
[Academic Institution: Academic Institution]
, [Accomodation: Accomodation]
, [Arts or Culture: Arts or Culture]
, ...16 more...
)
OWNER
(
type: esriFieldTypeString, alias: OWNER, length: 30
, Coded Values:
[City of Waterloo: City of Waterloo]
, [City of Kitchener: City of Kitchener]
, [Region of Waterloo: Region of Waterloo]
, ...12 more...
)
TYPE
(
type: esriFieldTypeString, alias: TYPE, length: 50
, Coded Values:
[Academic Institution: Academic Institution]
, [Accomodation: Accomodation]
, [Arts or Culture: Arts or Culture]
, ...16 more...
)
Color: [115, 115, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: center Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 8 Font Family: Arial Font Style: normal Font Weight: normal Font Decoration: none
Description: Building rooftop outlines for all historically significant structures in the City, represented by polygons. Areas for ancillary structures such as decks are not represented. The polygons are intended to be used as base data, and to represent the approximate generalised outline of the building. Polygons for this dataset were created for structures that appear on the heritage register based on the most recent aerial orthophotography (2012) and digitised at a scale of 1:250. Updates to this information will be made as required.
OWNER
(
type: esriFieldTypeString, alias: OWNER, length: 30
, Coded Values:
[City of Waterloo: City of Waterloo]
, [City of Kitchener: City of Kitchener]
, [Region of Waterloo: Region of Waterloo]
, ...12 more...
)
TYPE
(
type: esriFieldTypeString, alias: TYPE, length: 254
)
Description: The layer Environmentally Sensitive Policy Areas (ROP15_EnvSensitivePolicyArea)is a component of Map 4 (Greenlands Network) of the Regional Official Plan (ROP) as adopted by Council on June 16, 2009, and approved by the Ontario Municipal Board on June 18, 2015 . Environmentally Sensitive Policy Areas are regionally significant natural areas that comprise: (a) Provincially significant Life Science Areas of Natural and Scientific Interest, regionally significant Life Science Areas of Natural and Scientific Interest, or provincially significant Earth Science Areas of Natural and Scientific Interest; or (b) At least two of the following criteria: i) comprise ecological communities deemed unusual, of outstanding quality or particularly representative regionally, provincially or nationally; ii) contain critical habitats which are uncommon or remnants of once extensive habitats such as old growth forest, forest interior habitat, Carolinian forest, prairie-savanna, alvars, cliffs, bogs, fens, marl meadows, and cold water streams; iii) provide a large area of natural habitat of at least 20 hectares which affords habitat to species intolerant of human intrusion; or iv) provide habitat for organisms native to the region recognized as regionally, provincially or nationally significant; or (c) fulfill one of the criteria in Policy 7.C.5(b) and any two of the following: i) contain an unusual diversity of native life forms due to varied topography, microclimates, soils and/or drainage regimes; ii) perform a vital ecological function such as maintaining the hydrological balance over a widespread area by acting as a natural water storage, discharge or recharge area; iii) provide a linking system of relatively undisturbed forest or other natural habitat for the movement of wildlife over a considerable distance; iv) serve as major migratory stop-over or significant over-wintering habitat; or v) contain landforms deemed unusual or particularly representative at the regional scale.
Color: [112, 168, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: center Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 8 Font Family: Arial Font Style: normal Font Weight: normal Font Decoration: none
Color: [38, 115, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: center Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 10 Font Family: Tahoma Font Style: normal Font Weight: normal Font Decoration: none
Min. Scale: 15000.0 Max. Scale: 0.0 Label Placement: esriServerPolygonPlacementAlwaysHorizontal Label Expression: [PARK_NAME] Use Coded Values: true Symbol:
Color: [38, 115, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: center Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 8 Font Family: Tahoma Font Style: normal Font Weight: normal Font Decoration: none
OWNER
(
type: esriFieldTypeString, alias: OWNER, length: 30
, Coded Values:
[City of Waterloo: City of Waterloo]
, [City of Kitchener: City of Kitchener]
, [Region of Waterloo: Region of Waterloo]
, ...12 more...
)
OWNER
(
type: esriFieldTypeString, alias: OWNER, length: 30
, Coded Values:
[City of Waterloo: City of Waterloo]
, [City of Kitchener: City of Kitchener]
, [Region of Waterloo: Region of Waterloo]
, ...12 more...
)
Description: Locations for infrastructure related to cycling in the City of Waterloo. The data includes the locations of bike racks, bike lockers, and repair stations. The dataset represents a combination of those features that are owned and maintained by the City of Waterloo, as well as those located near schools within the City. Locations of cycling infrastructure located near/owned by schools the information has been digitised to best reflect the approximate location (collected in 2011/2012), whereas the locations owned by the City of Waterloo have primarily been captured using GPS and digitised from aerial photography in exceptional cases. Locations not owned by the school board or the City of Waterloo have also been captured as supplemental information and are intended as reference.
OWNER
(
type: esriFieldTypeString, alias: OWNER, length: 30
, Coded Values:
[City of Waterloo: City of Waterloo]
, [City of Kitchener: City of Kitchener]
, [Region of Waterloo: Region of Waterloo]
, ...12 more...
)
ASSET_TYPE
(
type: esriFieldTypeString, alias: ASSET_TYPE, length: 50
, Coded Values:
[Raised Cycle Track: Raised Cycle Track]
, [Separated Bike Lane: Separated Bike Lane]
, [Conventional Bike Lane: Conventional Bike Lane]
, ...5 more...
)
OWNER
(
type: esriFieldTypeString, alias: OWNER, length: 30
, Coded Values:
[City of Waterloo: City of Waterloo]
, [City of Kitchener: City of Kitchener]
, [Region of Waterloo: Region of Waterloo]
, ...12 more...
)
OWNER
(
type: esriFieldTypeString, alias: OWNER, length: 30
, Coded Values:
[City of Waterloo: City of Waterloo]
, [City of Kitchener: City of Kitchener]
, [Region of Waterloo: Region of Waterloo]
, ...12 more...
)
Description: Linear network representing sidewalks and City owned, leased, and special agreement trails within the City of Waterloo. The dataset has been coded with attributes indicating its type within one of three main categories; sidewalk, trail, or multi-use pathway. In addition, this data also includes the composition of trail material.
WINTER_4 = 'City Walks' OR WINTER_4 = 'Hillside Park' OR WINTER_4 = 'Park Pathways' OR WINTER_4 = 'Schools/Cost Recoverable' OR WINTER_4 = 'Waterloo Park'
OWNER
(
type: esriFieldTypeString, alias: OWNER, length: 30
, Coded Values:
[City of Waterloo: City of Waterloo]
, [City of Kitchener: City of Kitchener]
, [Region of Waterloo: Region of Waterloo]
, ...12 more...
)
OWNER
(
type: esriFieldTypeString, alias: OWNER, length: 30
, Coded Values:
[City of Waterloo: City of Waterloo]
, [City of Kitchener: City of Kitchener]
, [Region of Waterloo: Region of Waterloo]
, ...12 more...
)
OWNER
(
type: esriFieldTypeString, alias: OWNER, length: 30
, Coded Values:
[City of Waterloo: City of Waterloo]
, [City of Kitchener: City of Kitchener]
, [Region of Waterloo: Region of Waterloo]
, ...12 more...
)
Description: This dataset was created as an additional spatial output from the generation of the Census Profile documents. These polygons have the same attributes as those metrics used in the report and can be used to create maps of the reported statistics. The broad steps for creating these reports is as outlined below. The FME workbench located here (CensusDataProcessing2016.fmw)
was used to process the data and attach it to the Census custom geographies.Pre-GIS Steps1. Review .IVT tables in Beyond 20/20 browser and identify those metrics that will be required in the report.a. It should be noted that hiding non-essential fields at this stage and saving these tables as a new version for processing is recommended (clears up clutter and makes initial processing quicker). This task could be conducted by the subject matter experts prior to forwarding to GIS staff.b. The rows/columns should also be pivoted so that the geography are the rows and the census statistics are the columns.GIS Processing2. The .IVT tables are then saved in the .DBF format as FME software cannot read the IVT format.3. Tables are processed in broad categories and prefixed with a category identifier that makes identifying the individual metrics much easier after the highly descriptive and very long field names are condensed to more succinct field headings.4. The subsequent category tables are then assembled into one master tables (containing all attributes) and joined to the relevant geographic boundaries.5. This tables is output as a spatial geographic file and a non-spatial excel table (identical).Report Preparation6. The non-spatial table is then inserted into a report template constructed in excel.a. The excel report template consists of several tabs:i. Table Definitions – Contain a dictionary of the category prefixes used group table metrics and the census description from the original table.ii. Census_Processing_Output – The raw tabular output from the initial data processing. This table contains every metric for every geographic boundary. This table is the primary source for the report template; all values in the report are retrieved from this table (saved as a named range in excel DATA_TABLE).iii. Report_Template – This tab contains all the logic, formatting, and formulas used to construct the report. It is broken down in 2 halves. The left half is the ‘Publishing’ half and controls how things will look and how they are to appear on the page. The right half is the ‘Report Schema’ half, this controls what variables are being retrieved from the DATA_TABLE and inserted into the report structure. This schema portion is intended to provided clarity and indicate which metrics are being presented within the report.*variables are ‘fetched’ from the raw DATA_TABLE and inserted into the Report using the DGET formula controlled by the field named indicated in the schema view.*Building the report with these formula ensures that all profiles are consistent and present the exact same variable for each metric.*All formatting, grammar, punctuation, etc. should be done in the Publishing half of this tab.*Report sections can be rearranged by selecting, cutting, and pasting the ENTIRE row (across publishing half and schema half). This method can be used to arrange portion of the report to fit page breaks etc. (view it in the page layout mode of Excel).*The Report Selector dropdown can be used to change the geographic boundary that is presented in the report. iv. Map_Thumbnails – This tab contains pre-generated map thumbnails of each of the census geographic boundaries that are dynamically inserted into the report based on which geography is current selected.In the interest of succint field names, the attributes from the Census statistics were abbreviated and prefixed when translated in the FME workbench. The following key provides some clarity as to which metrics were derived which portions of the orginal Census attributes.//POPULATION TABLESP1: Total - Age groups of the population in private households - 25% sample dataP2: Total - Age groups of males in private households - 25% sample dataP3: Total - Age groups of females in private households - 25% sample dataP4: Total - Distribution (%) of the population in private households by broad age groups - 25% sample dataP5: Total - Distribution (%) of males in private households by broad age groups - 25% sample dataP6: Total - Distribution (%) of females in private households by broad age groups - 25% sample dataP7: Average AgeP8: Median AgeP9: Average age of malesP10: Median age of malesP11: Average age of femalesP12: Median age of females//MARITAL STATUS TABLESM1: Total - Marital status for the population aged 15 years and over in private households - 25% sample dataM2: Total - Marital status for males aged 15 years and over in private households - 25% sample dataM3: Total - Marital status for females aged 15 years and over in private households - 25% sample data//IMMIGRATION STATUS TABLESI1: Total - Immigrant status and period of immigration for the population in private households - 25% sample dataI2: Total - Immigrant status and period of immigration for males in private households - 25% sample dataI3: Total - Immigrant status and period of immigration for females in private households - 25% sample dataI4: Total - Immigrants by selected places of birth - 25% sample data//INCOME TABLESINC1: Household IncomeINC2: Individual Income//LABOUR FORCE TABLESL1: Total - Population aged 15 years and over by Labour force status - 25% sample dataL2: Total Labour Force population aged 15 years and over by Industry - NAICS 2012 - 25% sample data//MOBILITY STATUS TABLESMS1: Mobility Status 5 yrs ago - 25% sample data//STRUCTURE TABLESS1: Total Private households by tenure - 25% Sample dataS2: Total - Occupied private dwellings by structural type of dwelling - 25% sample data//EDUCATION TABLESE1: Highest level of education attained - 25% Sample data//FAMILY STRUCTURE TABLESF1: Total - Census Families in Private Households by Family SizeF2: Total - Couple Census Families in Private HouseholdsF3: Total - Private Households by SizeF4: Total Total Number of Census Families in Private Households
Color: [78, 78, 78, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: center Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 12 Font Family: Tahoma Font Style: normal Font Weight: normal Font Decoration: none
Color: [52, 52, 52, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: center Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 12 Font Family: Arial Font Style: normal Font Weight: normal Font Decoration: none