View In:   ArcGIS Online Map Viewer

Name: Percent Change In Houselessness by Census Tract

Display Field: namelsad

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Percent difference in houseless population per sq. mile proportional to tract populations within Continuum of Care boundaries created by The Department of Housing and Urban Development (HUD).#1. Pulled PIC data per Coc from HUD for 2008-2022#2. Acquired and processed Coc spatial data layers using data_download.py and reproject_merge.py - pulled for all years, but will only need for 2010 and 2022#3. Reprojected all layers into equal area projection#4. Added area by sq. miles fields (double), calculated field for all Cocs#5. Joined PIC for 2010 and 2022 data to Coc spatial layers by Coc Number#6. For 2010 and 2022 Cocs -> Where count is not null and greater than 0, normalized count of houseless by sq. mile areas per Coc#7. Joined 2010 and 2022 Cocs where normalized count of houseless is not null and greater than 0#8. Added relative difference field (double)#9. Calculated relative difference as percent changed, 100.0 * ((2022 houseless per sq. mile - 2010 houseless per sq. mile) / 2010 houseless per sq. mile)#10. Pulled and reprojected Census tract data from P:\01_DataOriginals\USA\Boundaries\Census_AllCensusBoundaries\tlgdb_2021_a_us_substategeo.gdb#11. Added area field to Census tract data and calculated area in square miles#12. Added field to Census tract data for resulting calculation (proportion of relative difference of houseless per sq-mi 2022-2010)

Service Item Id: 22aaf2e337974faf8369d53ce09ae988

Copyright Text: The Department of Housing and Urban Development. (2023). Continuum of Care Boundaries. Continuum of Care Program. Retrieved from https://www.hudexchange.info/programs/coc/gis-tools/

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.99519149256E7
YMin: -1643352.0165
XMax: 2.00218864032E7
YMax: 1.1554348247299999E7
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Class Breaks Renderer:
Field: relative_diff_prop_pop
Min. Value: -3.0497300055869223
ClassBreakInfos:
• Class Maximum Value: 1
  Label: -3 - 1
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 245, 240, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 10
  Label: 1 - 10
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [252, 187, 161, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 20
  Label: 10 - 20
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [251, 106, 74, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 30
  Label: 20 - 30
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [203, 24, 29, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 40.35900101835006
  Label: 30 - 41
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [103, 0, 13, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
Transparency: 25
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• geoid ( modelName: geoid, nullable: true, editable: true, defaultValue: null, length: 11, alias: GEOID, type: esriFieldTypeString )
• namelsad ( modelName: namelsad, nullable: true, editable: true, defaultValue: null, length: 20, alias: NAMELSAD, type: esriFieldTypeString )
• area_by_sq_miles ( modelName: area_by_sq_miles, nullable: true, editable: true, defaultValue: null, alias: area_by_sq_miles, type: esriFieldTypeDouble )
• relative_diff_prop_area ( modelName: relative_diff_prop_area, nullable: true, editable: true, defaultValue: null, alias: relative_diff_prop_area, type: esriFieldTypeDouble )
• e_totpop_1 ( modelName: e_totpop_1, nullable: true, editable: true, defaultValue: null, alias: E_TOTPOP, type: esriFieldTypeInteger )
• relative_diff_prop_pop ( modelName: relative_diff_prop_pop, nullable: true, editable: true, defaultValue: null, alias: relative_diff_prop_pop, type: esriFieldTypeDouble )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )

Templates:

• Name: Percent Change In Houselessness by Census Tract
  Description:
  Prototype:
  namelsad: null
  relative_diff_prop_pop: null
  geoid: null
  area_by_sq_miles: null
  relative_diff_prop_area: null
  e_totpop_1: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata