Name: vancouver_census

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• neighbourhood_name (type: esriFieldTypeString, alias: neighbourhood_name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Total___Age_groups_and_average_ (type: esriFieldTypeInteger, alias: Total - Age groups and average age of the population, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total___Distribution_____of_the (type: esriFieldTypeString, alias: Total - Distribution (%) of the population by broad age groups - 100% data, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• F0_to_14_years (type: esriFieldTypeDouble, alias: 0 to 14 years, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• F15_to_64_years (type: esriFieldTypeDouble, alias: 15 to 64 years, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• F65_years_and_over (type: esriFieldTypeDouble, alias: 65 years and over, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• F85_years_and_over (type: esriFieldTypeDouble, alias: 85 years and over, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Median_age_of_the_population (type: esriFieldTypeDouble, alias: Median age of the population, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Average_household_size (type: esriFieldTypeDouble, alias: Average household size, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Unemployment_rate (type: esriFieldTypeDouble, alias: Unemployment rate, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Employment_rate (type: esriFieldTypeDouble, alias: Employment rate, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Average_total_income_of_househo (type: esriFieldTypeInteger, alias: Average total income of households in 2015 ($), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Median_total_income_of_househol (type: esriFieldTypeInteger, alias: Median total income of households in 2015 ($), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Average_after_tax_income_of_hou (type: esriFieldTypeInteger, alias: Average after-tax income of households in 2015 ($), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Median_after_tax_income_of_hous (type: esriFieldTypeInteger, alias: Median after-tax income of households in 2015 ($), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total___Income_statistics_in_20 (type: esriFieldTypeInteger, alias: Total - Income statistics in 2015 for economic families in private households - 25% sample data, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Average_total_income_of_economi (type: esriFieldTypeInteger, alias: Average total income of economic families in 2015 ($), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Median_total_income_of_economic (type: esriFieldTypeInteger, alias: Median total income of economic families in 2015 ($), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Average_after_tax_income_of_eco (type: esriFieldTypeInteger, alias: Average after-tax income of economic families in 2015 ($), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Median_after_tax_income_of_econ (type: esriFieldTypeInteger, alias: Median after-tax income of economic families in 2015 ($), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Average_family_size_of_economic (type: esriFieldTypeDouble, alias: Average family size of economic families, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Total___Tenant_households_in_no (type: esriFieldTypeInteger, alias: Total - Tenant households in non-farm, non-reserve private dwellings - 25% sample data, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F__of_tenant_households_in_subs (type: esriFieldTypeDouble, alias: % of tenant households in subsidized housing, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• F__of_tenant_households_spendin (type: esriFieldTypeDouble, alias: % of tenant households spending 30% or more of its income on shelter costs, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Median_monthly_shelter_costs_fo (type: esriFieldTypeInteger, alias: Median monthly shelter costs for rented dwellings ($), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Average_monthly_shelter_costs_f (type: esriFieldTypeInteger, alias: Average monthly shelter costs for rented dwellings ($), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total___Highest_certificate__di (type: esriFieldTypeInteger, alias: Total - Highest certificate, diploma or degree for the population aged 15 years and over in private households - 25% sample data, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• No_certificate__diploma_or_degr (type: esriFieldTypeInteger, alias: No certificate, diploma or degree, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Secondary__high__school_diploma (type: esriFieldTypeInteger, alias: Secondary (high) school diploma or equivalency certificate, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Postsecondary_certificate__dipl (type: esriFieldTypeInteger, alias: Postsecondary certificate, diploma or degree, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Apprenticeship_or_trades_certif (type: esriFieldTypeInteger, alias: Apprenticeship or trades certificate or diploma, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Trades_certificate_or_diploma_o (type: esriFieldTypeInteger, alias: Trades certificate or diploma other than Certificate of Apprenticeship or Certificate of Qualification, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Certificate_of_Apprenticeship_o (type: esriFieldTypeInteger, alias: Certificate of Apprenticeship or Certificate of Qualification, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• College__CEGEP_or_other_non_uni (type: esriFieldTypeInteger, alias: College, CEGEP or other non-university certificate or diploma, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• University_certificate_or_diplo (type: esriFieldTypeInteger, alias: University certificate or diploma below bachelor level, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• University_certificate__diploma (type: esriFieldTypeInteger, alias: University certificate, diploma or degree at bachelor level or above, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Bachelor_s_degree (type: esriFieldTypeInteger, alias: Bachelor's degree, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• University_certificate_or_dip_1 (type: esriFieldTypeInteger, alias: University certificate or diploma above bachelor level, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Degree_in_medicine__dentistry__ (type: esriFieldTypeInteger, alias: Degree in medicine, dentistry, veterinary medicine or optometry, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Master_s_degree (type: esriFieldTypeInteger, alias: Master's degree, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Earned_doctorate (type: esriFieldTypeInteger, alias: Earned doctorate, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total___Mobility_status_1_year_ (type: esriFieldTypeInteger, alias: Total - Mobility status 1 year ago - 25% sample data, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Non_movers (type: esriFieldTypeInteger, alias: Non-movers, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Movers (type: esriFieldTypeInteger, alias: Movers, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Non_migrants (type: esriFieldTypeInteger, alias: Non-migrants, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Migrants (type: esriFieldTypeInteger, alias: Migrants, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Internal_migrants (type: esriFieldTypeInteger, alias: Internal migrants, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Intraprovincial_migrants (type: esriFieldTypeInteger, alias: Intraprovincial migrants, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Interprovincial_migrants (type: esriFieldTypeInteger, alias: Interprovincial migrants, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• External_migrants (type: esriFieldTypeInteger, alias: External migrants, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/8/2023 12:46:23 AM

Schema Last Edit Date: 6/8/2023 12:46:23 AM

Data Last Edit Date: 6/8/2023 12:46:23 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat