Default Visibility:   False

Configured Visibility:   False

Minimum Scale:   0

Maximum Scale:   0

Extent:   530237.48632471, 4808907.40082861, 543045.37232471, 4819939.70522861

Display Name:   Census Planning Districts

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 (\\wat070\Production\GIS\Special_projects\WDavison\Requests\TanjaC\CensusProfiles2016\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

Feature Type:   Polygon

Type:   FeatureLayer

Display Field:   BOUNDARY_NAME

Primary Key Field:   OBJECTID

Show Map Tips:   False

Searchable:   False

Identifiable:   True

Queryable:   True

Can Copy Feature:   True

Snappable:   True

Snapping Enabled:   False

Has Attachments:   False

Feature Label:   {BOUNDARY_NAME}

Feature Description:   N/A

Feature Long Description:   N/A

Feature Zoom Factor:   N/A

Feature Zoom Scale:   N/A

Feature Border Color:   N/A

Feature Border Width:   N/A

Feature Fill Color:   N/A

Icon:   N/A

Include in Layer List:   True

Include in Legend:   True

Can Toggle Labels:   False

Draw Index:   N/A

Legend URL:   N/A

Style Name:   N/A

Data Provider:   Default

Time Zone ID:   N/A

Fields:

Layer Hyperlinks:

Show Feature Hyperlinks:   Show

Feature Hyperlinks:

Is Dynamic:   False

Dynamic Definition:

N/A

Styles:

Queries:

Relationships:





Supported Interfaces:  REST