Name: Communities of Concern
Display Field: NAME
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description: Communities of Concern Data MethodologyBy Kimberly Clark , June 18, 2015Using data from the 2009-13 ACS 5 Year Estimates at the Census Designated Place level (CDP), calculate total percentage of minority population and total percentage of households in poverty for each CDPAlso using census tract data from the 2009-13 ACS 5 Year Estimates, tabulate percentage of minority population and total percentage of households in poverty for each City of Los Angeles Community Planning Area (CPAs)Intersect CPAs with Census Tracts and tabulate new totals for partial CPA/Census Tracts based on spatial interpolationSum total Poverty, households, minority, and population values for each CPAMerge CDPs and City of Los Angeles Community Planning Areas to create a single “Place” file for the entire SCAG region. Remove the City of Los Angeles CDP from layer. Tabulate % of households in poverty and % of minority population for each “Place”Using ranked sorting, select the places that are in the upper third in the SCAG region for both % of households in poverty (x > 0.169156) and% minority (x > 0.768549)Identify those places and export to new shapefile – “Communities_of_Concern”Union “Communities_of_Concern” shapefile with Tier2 TAZ file and tabulate % of each tract that falls in “Communities_of_Concern”Calculate total square meters in Tier2 TAZ shapefileUnion shapefile with “Communities_of_Concern”Tabulate new square meters in Tier 2 TAZ shapefileExport attribute table to DBFLoad DBF in excel and use pivot tables to tabulate total acreage by TAZ only for tracts that intersect with “Communities_of_Concern”. Create new DBF with results and load into ArcMapJoin new DBF with Tier2 TAZ shapefile and calculate % of TAZ that falls in “Communities_of_Concern” only for the records that join. All other TAZs remain 0%, if they do not intersect.
Service Item Id: c35155440fce4ac08ca95364e81dba30
Copyright Text:
Default Visibility: true
MaxRecordCount: 1000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Has Labels: false
Can Modify Layer: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports Datum Transformation: true
Extent:
XMin: 300055.06400000025
YMin: 3614778.0198999997
XMax: 719319.1183000002
YMax: 3835495.6625999995
Spatial Reference: 26911
(26911)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSFSSolid
Color: [255, 190, 190, 255]
Outline:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: null
Fields:
-
Pop
(
type: esriFieldTypeDouble, alias: Pop
)
-
Minority
(
type: esriFieldTypeDouble, alias: Minority
)
-
Poverty
(
type: esriFieldTypeDouble, alias: Poverty
)
-
HH
(
type: esriFieldTypeDouble, alias: HH
)
-
Pct_Pov
(
type: esriFieldTypeDouble, alias: Pct_Pov
)
-
Pct_MinPop
(
type: esriFieldTypeDouble, alias: Pct_MinPop
)
-
ACRES
(
type: esriFieldTypeDouble, alias: ACRES
)
-
Shape.area
(
type: esriFieldTypeDouble, alias: Shape.area
)
-
Shape.len
(
type: esriFieldTypeDouble, alias: Shape.len
)
-
OBJECTID_1
(
type: esriFieldTypeOID, alias: OBJECTID_1
)
-
OBJECTID
(
type: esriFieldTypeInteger, alias: OBJECTID
)
-
STATEFP
(
type: esriFieldTypeString, alias: STATEFP, length: 2
)
-
PLACEFP
(
type: esriFieldTypeString, alias: PLACEFP, length: 5
)
-
PLACENS
(
type: esriFieldTypeString, alias: PLACENS, length: 8
)
-
GEOID
(
type: esriFieldTypeString, alias: GEOID, length: 7
)
-
NAME
(
type: esriFieldTypeString, alias: NAME, length: 100
)
-
NAMELSAD
(
type: esriFieldTypeString, alias: NAMELSAD, length: 100
)
-
GEOID_Data
(
type: esriFieldTypeString, alias: GEOID_Data, length: 50
)
-
ComConcern
(
type: esriFieldTypeString, alias: ComConcern, length: 50
)
-
YEAR
(
type: esriFieldTypeSmallInteger, alias: YEAR
)
-
Shape
(
type: esriFieldTypeGeometry, alias: Shape
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata