Name: Housing_information_by_census_tract

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 4513

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -19942590.6658
YMin: 2023652.7986
XMax: 20012847.1794
YMax: 11537127.3335
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[236,215,252,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.4}},"label":"","description":""},"transparency":0}

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:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• FIPS (type: esriFieldTypeString, alias: FIPS, SQL Type: sqlTypeNVarchar, length: 11, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeNVarchar, length: 30, nullable: true, editable: true)
• STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeNVarchar, length: 2, nullable: true, editable: true)
• POPULATION (type: esriFieldTypeInteger, alias: POP2020, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• SQMI (type: esriFieldTypeDouble, alias: SQMI, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ID (type: esriFieldTypeString, alias: Id, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• sourceCountry (type: esriFieldTypeString, alias: Country code, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ENRICH_FID (type: esriFieldTypeInteger, alias: ENRICH_FID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• aggregationMethod (type: esriFieldTypeString, alias: Aggregation method, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• populationToPolygonSizeRating (type: esriFieldTypeDouble, alias: Population to polygon size rating for the country, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• apportionmentConfidence (type: esriFieldTypeDouble, alias: Apportionment confidence for the country, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• HasData (type: esriFieldTypeInteger, alias: Has data, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• TOTHU00 (type: esriFieldTypeDouble, alias: 2000 Total Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• TOTHU10 (type: esriFieldTypeDouble, alias: 2010 Total Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• OWNER_CY (type: esriFieldTypeDouble, alias: 2020 Owner Occupied HUs, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• RENTER_CY (type: esriFieldTypeDouble, alias: 2020 Renter Occupied HUs, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• VACANT_CY (type: esriFieldTypeDouble, alias: 2020 Vacant Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• MEDVAL_CY (type: esriFieldTypeDouble, alias: 2020 Median Home Value, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• AVGVAL_CY (type: esriFieldTypeDouble, alias: 2020 Average Home Value, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• URBARHU10 (type: esriFieldTypeDouble, alias: 2010 HUs in Urbanized Areas, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• URBCLHU10 (type: esriFieldTypeDouble, alias: 2010 HUs in Urban Clusters, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• RURALHU10 (type: esriFieldTypeDouble, alias: 2010 Rural Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• OOMORT10 (type: esriFieldTypeDouble, alias: 2010 OOHUs: Mortgage, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• OONOMORT10 (type: esriFieldTypeDouble, alias: 2010 OOHUs: No Mortgage, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• URHUBASE10 (type: esriFieldTypeDouble, alias: 2010 Urban/Rural HU Base, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• URBANHU10 (type: esriFieldTypeDouble, alias: 2010 Urban Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• HAI_CY (type: esriFieldTypeDouble, alias: 2020 Housing Affordability Index, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• INCMORT_CY (type: esriFieldTypeDouble, alias: 2020 Pct of Income for Mortgage, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• TOTHU_CY (type: esriFieldTypeDouble, alias: 2020 Total Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• VALBASE_CY (type: esriFieldTypeDouble, alias: 2020 Home Value Base, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• VACANT10 (type: esriFieldTypeDouble, alias: 2010 Vacant Housing Units, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• VACRENT10 (type: esriFieldTypeDouble, alias: 2010 Vacant HUs: For Rent, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• VACRNTED10 (type: esriFieldTypeDouble, alias: 2010 Vacant HUs: Rented-Not Occ, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• VACSALE10 (type: esriFieldTypeDouble, alias: 2010 Vacant HUs: For Sale Only, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• VACSOLD10 (type: esriFieldTypeDouble, alias: 2010 Vacant HUs: Sold-Not Occ, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• VACSEAS10 (type: esriFieldTypeDouble, alias: 2010 Vacant HUs: Seasonal/Rec/Occasional, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• VACMIGR10 (type: esriFieldTypeDouble, alias: 2010 Vacant HUs: Migrant Workers, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• VACOTHER10 (type: esriFieldTypeDouble, alias: 2010 Vacant HUs: Other Vacant, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• VACBASE10 (type: esriFieldTypeDouble, alias: 2010 Vacant HUs by Type Base, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSVCHUNTS (type: esriFieldTypeDouble, alias: 2019 Total Vacant HUs (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSVCFRRNT (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: For Rent (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSVCRNTNO (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: Rented, Not Occupied (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSVCFRSLE (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: For Sale Only (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSVCSLDNO (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: Sold, Not Occupied (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSVCSNLRC (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: Seasonal/Occasional (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSVCMGWRK (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: For Migrant Wrks (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSVCOTHER (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: Other (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSTOTHH (type: esriFieldTypeDouble, alias: 2019 Total Households (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• POPOWNM10 (type: esriFieldTypeDouble, alias: 2010 Pop in OOHUs: Mortgage/Loan, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• POPOWNNM10 (type: esriFieldTypeDouble, alias: 2010 Pop in OOHUs: No Mortgage/Loan, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSTOTHU (type: esriFieldTypeDouble, alias: 2019 Total Housing Units (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ACSOWNER (type: esriFieldTypeDouble, alias: 2019 Owner Households (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• OOWHTHHR10 (type: esriFieldTypeDouble, alias: 2010 OOHUs: White HHr, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• OOBLKHHR10 (type: esriFieldTypeDouble, alias: 2010 OOHUs: Black HHr, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• OOAIHHR10 (type: esriFieldTypeDouble, alias: 2010 OOHUs: Amer Indian HHr, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• OOASNHHR10 (type: esriFieldTypeDouble, alias: 2010 OOHUs: Asian HHr, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• OOPIHHR10 (type: esriFieldTypeDouble, alias: 2010 OOHUs: Pacific Isl HHr, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• OOOTHHHR10 (type: esriFieldTypeDouble, alias: 2010 OOHUs: Other Race HHr, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• OOMLTHHR10 (type: esriFieldTypeDouble, alias: 2010 OOHUs: 2+ Races HHr, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• OOHSPHHR10 (type: esriFieldTypeDouble, alias: 2010 OOHUs: Hispanic HHr, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ROWHTHHR10 (type: esriFieldTypeDouble, alias: 2010 ROHUs: White HHr, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ROBLKHHR10 (type: esriFieldTypeDouble, alias: 2010 ROHUs: Black HHr, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ROAIHHR10 (type: esriFieldTypeDouble, alias: 2010 ROHUs: American Indian HHr, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ROASNHHR10 (type: esriFieldTypeDouble, alias: 2010 ROHUs: Asian HHr, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ROPIHHR10 (type: esriFieldTypeDouble, alias: 2010 ROHUs: Pacific Isl HHr, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ROOTHHHR10 (type: esriFieldTypeDouble, alias: 2010 ROHUs: Other Race HHr, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ROMLTHHR10 (type: esriFieldTypeDouble, alias: 2010 ROHUs: 2+ Races HHr, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• ROHSPHHR10 (type: esriFieldTypeDouble, alias: 2010 ROHUs: Hispanic HHr, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• POPOWN10 (type: esriFieldTypeDouble, alias: 2010 Pop in Owner Occ HUs, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• POPRENT10 (type: esriFieldTypeDouble, alias: 2010 Pop in Renter Occ Hus, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• OWNER10 (type: esriFieldTypeDouble, alias: 2010 Owner Occupied Hus, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• RENTER10 (type: esriFieldTypeDouble, alias: 2010 Renter Occupied Hus, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• OWNER00 (type: esriFieldTypeDouble, alias: 2000 Owner Occupied HUs, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• RENTER00 (type: esriFieldTypeDouble, alias: 2000 Renter Occupied HUs, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• PCT_Change_owner_occupied (type: esriFieldTypeDouble, alias: Percent change of owner occupied homes 2000 to 2020, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/28/2021 12:14:55 AM

Schema Last Edit Date: 9/28/2021 12:14:55 AM

Data Last Edit Date: 9/28/2021 12:14:55 AM

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