Name: AFFH_19_Join

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:

• GEO_ID (type: esriFieldTypeString, alias: GEO_ID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Join_ID (type: esriFieldTypeString, alias: Join_ID, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• AREA_NAME (type: esriFieldTypeString, alias: AREA_NAME, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• LIFE_PERCENTILE_COUNTY (type: esriFieldTypeDouble, alias: LIFE_PERCENTILE_COUNTY, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• INSURED_PERCENTILE_COUNTY (type: esriFieldTypeDouble, alias: INSURED_PERCENTILE_COUNTY, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• MEDIAN_HH_INCOME_PERCENTILE_COU (type: esriFieldTypeDouble, alias: MEDIAN_HH_INCOME_PERCENTILE_COUNTY, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• EMPLOYMENT_PERCENTILE_COUNTY (type: esriFieldTypeDouble, alias: EMPLOYMENT_PERCENTILE_COUNTY, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• OVER_POVERTY_PERCENTILE_COUNTY (type: esriFieldTypeDouble, alias: OVER_POVERTY_PERCENTILE_COUNTY, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• NOT_RENT_BURDENED_PERCENTILE_CO (type: esriFieldTypeDouble, alias: NOT_RENT_BURDENED_PERCENTILE_COUNTY, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• NON_OVERCROWDING_PERCENTILE_COU (type: esriFieldTypeDouble, alias: NON_OVERCROWDING_PERCENTILE_COUNTY, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• HEALTH__COUNTY_AVERAGE (type: esriFieldTypeDouble, alias: HEALTH__COUNTY_AVERAGE, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• ECONOMIC_COUNTY_AVERAGE (type: esriFieldTypeDouble, alias: ECONOMIC_COUNTY_AVERAGE, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• HOUSING_COUNTY_AVERAGE (type: esriFieldTypeDouble, alias: HOUSING_COUNTY_AVERAGE, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• AvgComp1 (type: esriFieldTypeDouble, alias: AvgComp1, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• AFFH_Score_1 (type: esriFieldTypeInteger, alias: AFFH Score 1, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• TRACT_POP (type: esriFieldTypeInteger, alias: TRACT POP, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• TRACT_WHITE (type: esriFieldTypeInteger, alias: TRACT WHITE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• TRACT_WHITE_PER (type: esriFieldTypeDouble, alias: TRACT WHITE PER, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• TRACT_NONWHITE (type: esriFieldTypeInteger, alias: TRACT NONWHITE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• TRACT_NONWHITE_PER (type: esriFieldTypeDouble, alias: TRACT NONWHITE PER, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• COUNTY_POP (type: esriFieldTypeInteger, alias: COUNTY POP, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• COUNTY_WHITE (type: esriFieldTypeInteger, alias: COUNTY WHITE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• COUNTY_WHITE_PER (type: esriFieldTypeDouble, alias: COUNTY WHITE PER, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• COUNTY_NONWHITE (type: esriFieldTypeInteger, alias: COUNTY NONWHITE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• COUNTY_NONWHITE_PER (type: esriFieldTypeDouble, alias: COUNTY NONWHITE PER, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Dissimilarity_Value (type: esriFieldTypeInteger, alias: Dissimilarity Value, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• AFFH_2_Score (type: esriFieldTypeInteger, alias: AFFH 2 Score, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• AFFH_Index_Score (type: esriFieldTypeInteger, alias: AFFH Index Score, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• COUNTY_MEDIAN_HH_INCOME_19 (type: esriFieldTypeInteger, alias: COUNTY_MEDIAN_HH_INCOME_19, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• TRACT_POPULATION_19 (type: esriFieldTypeInteger, alias: TRACT_POPULATION_19, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• TRACT_POPULATION_10 (type: esriFieldTypeString, alias: TRACT_POPULATION_10, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TRACT_MEDIAN_HH_INCOME_19 (type: esriFieldTypeString, alias: TRACT_MEDIAN_HH_INCOME_19, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TRACT_MEDIAN_HH_INCOME_10 (type: esriFieldTypeString, alias: TRACT_MEDIAN_HH_INCOME_10, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TRACT_MEDIAN_RENT_19 (type: esriFieldTypeString, alias: TRACT_MEDIAN_RENT_19, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TRACT_MEDIAN_RENT_10 (type: esriFieldTypeString, alias: TRACT_MEDIAN_RENT_10, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TRACT_COLLEGE_HIGHER_PERCENT_19 (type: esriFieldTypeDouble, alias: TRACT_COLLEGE_HIGHER_PERCENT_19, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• TRACT_COLLEGE_HIGHER_PERCENT_10 (type: esriFieldTypeDouble, alias: TRACT_COLLEGE_HIGHER_PERCENT_10, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• TRACT_WHITE_PER_19 (type: esriFieldTypeDouble, alias: TRACT_WHITE_PER_19, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• TRACT_WHITE_PER_10 (type: esriFieldTypeDouble, alias: TRACT_WHITE_PER_10, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• TRACT_WHITE_PER_CHANGE (type: esriFieldTypeDouble, alias: TRACT_WHITE_PER_CHANGE, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• TRACT_MEDIAN_HH_INCOME_CHANGE (type: esriFieldTypeString, alias: TRACT_MEDIAN_HH_INCOME_CHANGE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TRACT_MEDIAN_RENT_CHANGE (type: esriFieldTypeString, alias: TRACT_MEDIAN_RENT_CHANGE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TRACT_COLLEGE_CHANGE (type: esriFieldTypeDouble, alias: TRACT_COLLEGE_CHANGE, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Gen_V (type: esriFieldTypeInteger, alias: Gen_V, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• gentrifying (type: esriFieldTypeString, alias: gentrifying, SQL Type: sqlTypeNVarchar, length: 4000, 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: 7/18/2022 7:14:21 PM

Schema Last Edit Date: 7/18/2022 7:14:21 PM

Data Last Edit Date: 7/18/2022 7:14:21 PM

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