{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Communities of Concern", "type": "Feature Layer", "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 \u201cPlace\u201d 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 \u201cPlace\u201dUsing 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 \u2013 \u201cCommunities_of_Concern\u201dUnion \u201cCommunities_of_Concern\u201d shapefile with Tier2 TAZ file and tabulate % of each tract that falls in \u201cCommunities_of_Concern\u201dCalculate total square meters in Tier2 TAZ shapefileUnion shapefile with \u201cCommunities_of_Concern\u201dTabulate 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 \u201cCommunities_of_Concern\u201d. Create new DBF with results and load into ArcMapJoin new DBF with Tier2 TAZ shapefile and calculate % of TAZ that falls in \u201cCommunities_of_Concern\u201d only for the records that join. All other TAZs remain 0%, if they do not intersect. ", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 26911, "latestWkid": 26911, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 190, 190, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 300055.06400000025, "ymin": 3614778.0198999997, "xmax": 719319.1183000002, "ymax": 3835495.6625999995, "spatialReference": { "wkid": 26911, "latestWkid": 26911, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 4.504455473910538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Pop", "type": "esriFieldTypeDouble", "alias": "Pop", "domain": null }, { "name": "Minority", "type": "esriFieldTypeDouble", "alias": "Minority", "domain": null }, { "name": "Poverty", "type": "esriFieldTypeDouble", "alias": "Poverty", "domain": null }, { "name": "HH", "type": "esriFieldTypeDouble", "alias": "HH", "domain": null }, { "name": "Pct_Pov", "type": "esriFieldTypeDouble", "alias": "Pct_Pov", "domain": null }, { "name": "Pct_MinPop", "type": "esriFieldTypeDouble", "alias": "Pct_MinPop", "domain": null }, { "name": "ACRES", "type": "esriFieldTypeDouble", "alias": "ACRES", "domain": null }, { "name": "Shape.area", "type": "esriFieldTypeDouble", "alias": "Shape.area", "domain": null }, { "name": "Shape.len", "type": "esriFieldTypeDouble", "alias": "Shape.len", "domain": null }, { "name": "OBJECTID_1", "type": "esriFieldTypeOID", "alias": "OBJECTID_1", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "STATEFP", "type": "esriFieldTypeString", "alias": "STATEFP", "length": 2, "domain": null }, { "name": "PLACEFP", "type": "esriFieldTypeString", "alias": "PLACEFP", "length": 5, "domain": null }, { "name": "PLACENS", "type": "esriFieldTypeString", "alias": "PLACENS", "length": 8, "domain": null }, { "name": "GEOID", "type": "esriFieldTypeString", "alias": "GEOID", "length": 7, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 100, "domain": null }, { "name": "NAMELSAD", "type": "esriFieldTypeString", "alias": "NAMELSAD", "length": 100, "domain": null }, { "name": "GEOID_Data", "type": "esriFieldTypeString", "alias": "GEOID_Data", "length": 50, "domain": null }, { "name": "ComConcern", "type": "esriFieldTypeString", "alias": "ComConcern", "length": 50, "domain": null }, { "name": "YEAR", "type": "esriFieldTypeSmallInteger", "alias": "YEAR", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R2827_SDE_ROWID_UK", "fields": "OBJECTID_1", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a2398_ix1", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.area", "shapeLengthFieldName": "Shape.len", "units": "esriMeters" }, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "c35155440fce4ac08ca95364e81dba30" }