Layer: Enriched Zillow Jan 2017 Zip Code Data with income (ID:0)

View In: Map Viewer

Name: Enriched Zillow Jan 2017 Zip Code Data with income

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"visualVariables":[{"type":"colorInfo","field":null,"valueExpression":"// var houseDollars = $feature.AVGHINC_CY * .28;\n\n// if (houseDollars > $feature.Zhvi) {\n// return \"Below housing ratio\";\n// } else {\n// return \"Above housing ratio\";\n// }\n\nreturn round($feature.Zhvi / $feature.AVGHINC_CY,1);","valueExpressionTitle":"Housing to income ratio","stops":[{"value":1,"color":[58,128,89,255],"label":"< 1"},{"value":1.5,"color":[133,191,155,255],"label":null},{"value":2,"color":[218,225,218,255],"label":"2"},{"value":3.5,"color":[138,143,191,255],"label":null},{"value":5,"color":[67,78,150,255],"label":"> 5"}]},{"type":"sizeInfo","target":"outline","expression":"view.scale","valueExpression":"$view.scale","stops":[{"size":1.5,"value":253030},{"size":0.75,"value":790717},{"size":0.375,"value":3162869},{"size":0,"value":6325739}]}],"authoringInfo":{"visualVariables":[{"type":"colorInfo","minSliderValue":0.8,"maxSliderValue":18.9,"theme":"above-and-below"}]},"type":"classBreaks","field":null,"valueExpression":"// var houseDollars = $feature.AVGHINC_CY * .28;\n\n// if (houseDollars > $feature.Zhvi) {\n// return \"Below housing ratio\";\n// } else {\n// return \"Above housing ratio\";\n// }\n\nreturn round($feature.Zhvi / $feature.AVGHINC_CY,1);","minValue":-9007199254740991,"classBreakInfos":[{"symbol":{"color":[170,170,170,255],"outline":{"color":[153,153,153,128],"width":0.375,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"classMaxValue":9007199254740991}]},"transparency":20}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
ZIP_CODE (type: esriFieldTypeString, alias: ZIP_CODE, SQL Type: sqlTypeNVarchar, length: 10, nullable: true, editable: true)
NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeNVarchar, length: 100, nullable: true, editable: true)
STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeNVarchar, length: 2, nullable: true, editable: true)
POPULATION (type: esriFieldTypeDouble, alias: POP2014, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
SQMI (type: esriFieldTypeDouble, alias: SQMI, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
Join_Count (type: esriFieldTypeInteger, alias: Join Count, SQL Type: sqlTypeInteger, nullable: true, editable: true)
Date (type: esriFieldTypeString, alias: Date, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
RegionID (type: esriFieldTypeInteger, alias: RegionID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
State_1 (type: esriFieldTypeString, alias: State 1, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
Metro (type: esriFieldTypeString, alias: Metro, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
SizeRank (type: esriFieldTypeInteger, alias: SizeRank, SQL Type: sqlTypeInteger, nullable: true, editable: true)
Zhvi (type: esriFieldTypeInteger, alias: Zhvi, SQL Type: sqlTypeInteger, nullable: true, editable: true)
MoM (type: esriFieldTypeDouble, alias: MoM, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
QoQ (type: esriFieldTypeDouble, alias: QoQ, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
YoY (type: esriFieldTypeDouble, alias: YoY, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
F5Year (type: esriFieldTypeDouble, alias: 5Year, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
F10Year (type: esriFieldTypeDouble, alias: 10Year, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
PeakMonth (type: esriFieldTypeString, alias: PeakMonth, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
PeakQuarter (type: esriFieldTypeString, alias: PeakQuarter, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
PeakZHVI (type: esriFieldTypeInteger, alias: PeakZHVI, SQL Type: sqlTypeInteger, nullable: true, editable: true)
PctFallFromPeak (type: esriFieldTypeDouble, alias: PctFallFromPeak, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
LastTimeAtCurrZHVI (type: esriFieldTypeString, alias: LastTimeAtCurrZHVI, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
ID (type: esriFieldTypeString, alias: ID, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
sourceCountry (type: esriFieldTypeString, alias: sourceCountry, 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: aggregationMethod, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
HasData (type: esriFieldTypeInteger, alias: HasData, SQL Type: sqlTypeInteger, nullable: true, editable: true)
AVGHINC_CY (type: esriFieldTypeDouble, alias: 2016 Average Household Income, SQL Type: sqlTypeDecimal, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/6/2017 1:56:36 AM

Schema Last Edit Date: 3/6/2017 1:56:36 AM

Data Last Edit Date: 3/6/2017 1:56:36 AM

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