Name: Enriched_Enriched_Enriched_Census_2010_vacancy___copy_2
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:
XMin: -13714791.2518
YMin: 5920295.1652
XMax: -13643861.1439
YMax: 5969055.1855
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"visualVariables":[{"type":"sizeInfo","target":"outline","expression":"view.scale","valueExpression":"$view.scale","stops":[{"size":1.5,"value":58924},{"size":0.75,"value":184137},{"size":0.375,"value":736547},{"size":0,"value":1473095}]}],"authoringInfo":{"type":"relationship","numClasses":3,"focus":"HH","field1":{"field":"ACSVCFRSLE","normalizationField":"ACSVCHUNTS","classBreakInfos":[{"minValue":0,"maxValue":0},{"minValue":0,"maxValue":0.526315},{"minValue":0.526315,"maxValue":1}]},"field2":{"field":"EDR_CY","classBreakInfos":[{"minValue":41.1,"maxValue":92.5},{"minValue":92.5,"maxValue":114},{"minValue":114,"maxValue":1250.5}]},"classificationMethod":"esriClassifyQuantile"},"type":"uniqueValue","valueExpression":"var field1 = $feature['ACSVCFRSLE'];\nvar field2 = $feature['EDR_CY'];\nvar hasNormField1 = true;\nvar hasNormField2 = false;\nvar normField1 = $feature['ACSVCHUNTS'];\nvar normField2 = null;\nif (\n IsEmpty(field1) || \n IsEmpty(field2) ||\n (hasNormField1 && (IsEmpty(normField1) || normField1 == 0)) ||\n (hasNormField2 && (IsEmpty(normField2) || normField2 == 0))\n) {\n return null; \n}\nvar value1 = IIf(hasNormField1, (field1 / normField1), field1);\nvar value2 = IIf(hasNormField2, (field2 / normField2), field2);\nvar breaks1 = [[0,0],[0,0.526315],[0.526315,1]];\nvar breaks2 = [[41.1,92.5],[92.5,114],[114,1250.5]];\nvar classCodes = [\"L\",\"M\",\"H\"];\nfunction getClassCode(value, breaks) {\n var code = null;\n for (var i in breaks) {\n var info = breaks[i];\n if (value >= info[0] && value <= info[1]) {\n code = classCodes[i];\n break;\n }\n }\n return code;\n}\nvar code1 = getClassCode(value1, breaks1);\nvar code2 = getClassCode(value2, breaks2);\nvar classValue = IIf(IsEmpty(code1) || IsEmpty(code2), null, code1 + code2);\nreturn classValue;","valueExpressionTitle":"Relationship","uniqueValueInfos":[{"value":"HH","label":"High - High","symbol":{"color":[92,71,61,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},{"value":"HM","label":"High - Medium","symbol":{"color":[66,122,142,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},{"value":"HL","label":"High - Low","symbol":{"color":[0,175,231,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},{"value":"MH","label":"Medium - High","symbol":{"color":[170,95,55,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},{"value":"MM","label":"Medium - Medium","symbol":{"color":[175,151,139,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},{"value":"ML","label":"Medium - Low","symbol":{"color":[152,207,229,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},{"value":"LH","label":"Low - High","symbol":{"color":[249,117,41,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},{"value":"LM","label":"Low - Medium","symbol":{"color":[255,178,134,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},{"value":"LL","label":"Low - Low","symbol":{"color":[255,239,226,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}}]},"transparency":0,"showLabels":false}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
- STATEFP10 (type: esriFieldTypeString, alias: STATEFP10, SQL Type: sqlTypeNVarchar, length: 2, nullable: true, editable: true)
- COUNTYFP10 (type: esriFieldTypeString, alias: COUNTYFP10, SQL Type: sqlTypeNVarchar, length: 3, nullable: true, editable: true)
- TRACTCE10 (type: esriFieldTypeString, alias: TRACTCE10, SQL Type: sqlTypeNVarchar, length: 6, nullable: true, editable: true)
- BLKGRPCE10 (type: esriFieldTypeString, alias: BLKGRPCE10, SQL Type: sqlTypeNVarchar, length: 1, nullable: true, editable: true)
- GEOID10 (type: esriFieldTypeString, alias: GEOID10, SQL Type: sqlTypeNVarchar, length: 12, nullable: true, editable: true)
- NAMELSAD10 (type: esriFieldTypeString, alias: NAMELSAD10, SQL Type: sqlTypeNVarchar, length: 13, nullable: true, editable: true)
- MTFCC10 (type: esriFieldTypeString, alias: MTFCC10, SQL Type: sqlTypeNVarchar, length: 5, nullable: true, editable: true)
- FUNCSTAT10 (type: esriFieldTypeString, alias: FUNCSTAT10, SQL Type: sqlTypeNVarchar, length: 1, nullable: true, editable: true)
- ALAND10 (type: esriFieldTypeDouble, alias: ALAND10, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- AWATER10 (type: esriFieldTypeDouble, alias: AWATER10, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- INTPTLAT10 (type: esriFieldTypeString, alias: INTPTLAT10, SQL Type: sqlTypeNVarchar, length: 11, nullable: true, editable: true)
- INTPTLON10 (type: esriFieldTypeString, alias: INTPTLON10, SQL Type: sqlTypeNVarchar, length: 12, nullable: true, editable: true)
- ACRES (type: esriFieldTypeDouble, alias: ACRES, 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)
- ACSVCHUNTS (type: esriFieldTypeDouble, alias: 2019 Total Vacant HUs (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- MOEVCHUNTS (type: esriFieldTypeDouble, alias: 2019 Total Vacant HUs MOE (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- RELVCHUNTS (type: esriFieldTypeDouble, alias: 2019 Total Vacant HUs REL (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)
- MOEVCFRRNT (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: For Rent MOE (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- RELVCFRRNT (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: For Rent REL (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)
- MOEVCRNTNO (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: Rented, Not Occupied MOE (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- RELVCRNTNO (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: Rented, Not Occupied REL (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)
- MOEVCFRSLE (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: For Sale Only MOE (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- RELVCFRSLE (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: For Sale Only REL (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)
- MOEVCSLDNO (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: Sold, Not Occupied MOE (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- RELVCSLDNO (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: Sold, Not Occupied REL (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)
- MOEVCSNLRC (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: Seasonal/Occasional MOE (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- RELVCSNLRC (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: Seasonal/Occasional REL (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)
- MOEVCMGWRK (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: For Migrant Wrks MOE (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- RELVCMGWRK (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: For Migrant Wrks REL (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)
- MOEVCOTHER (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: Other MOE (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- RELVCOTHER (type: esriFieldTypeDouble, alias: 2019 Vacant HUs: Other REL (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- ID_1 (type: esriFieldTypeString, alias: Id, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- sourceCountry_1 (type: esriFieldTypeString, alias: Country code, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- ENRICH_FID_1 (type: esriFieldTypeInteger, alias: ENRICH_FID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
- aggregationMethod_1 (type: esriFieldTypeString, alias: Aggregation method, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- populationToPolygonSizeRating_1 (type: esriFieldTypeDouble, alias: Population to polygon size rating for the country, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- apportionmentConfidence_1 (type: esriFieldTypeDouble, alias: Apportionment confidence for the country, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- HasData_1 (type: esriFieldTypeInteger, alias: Has data, SQL Type: sqlTypeInteger, nullable: true, editable: true)
- EDR_CY (type: esriFieldTypeDouble, alias: 2021 EDR, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- ID_12 (type: esriFieldTypeString, alias: Id, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- sourceCountry_12 (type: esriFieldTypeString, alias: Country code, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- ENRICH_FID_12 (type: esriFieldTypeInteger, alias: ENRICH_FID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
- aggregationMethod_12 (type: esriFieldTypeString, alias: Aggregation method, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- populationToPolygonSizeRating_2 (type: esriFieldTypeDouble, alias: populationToPolygonSizeRating_2, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- apportionmentConfidence_12 (type: esriFieldTypeDouble, alias: Apportionment confidence for the country, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- HasData_12 (type: esriFieldTypeInteger, alias: Has data, SQL Type: sqlTypeInteger, nullable: true, editable: true)
- ACSMEDVAL (type: esriFieldTypeDouble, alias: 2019 Median Home Value (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
- ACSAVGVAL (type: esriFieldTypeDouble, alias: 2019 Average Home Value (ACS 5-Yr), SQL Type: sqlTypeDecimal, nullable: true, editable: true)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/24/2021 11:41:17 PM
Schema Last Edit Date: 10/24/2021 11:41:17 PM
Data Last Edit Date: 10/24/2021 11:41:17 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat