{ "currentVersion" : 12, "id" : 8, "name" : "'CES 3#0 (2018 Update)$'", "type" : "Table", "serviceItemId" : "cd87bf2d747a491d8aac6fd607698a40", "cacheMaxAge" : 30, "displayField" : "Census_Tract", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1618612059934, "schemaLastEditDate" : 1618612059934, "dataLastEditDate" : 1618612059934 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : true, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "ObjectID", "uniqueIdField" : { "name" : "ObjectID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "Census_Tract", "type" : "esriFieldTypeDouble", "alias" : "Census Tract", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_Population", "type" : "esriFieldTypeDouble", "alias" : "Total Population", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "California_County", "type" : "esriFieldTypeString", "alias" : "California County", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIP", "type" : "esriFieldTypeDouble", "alias" : "ZIP", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Nearby_City___to_help_approxima", "type" : "esriFieldTypeString", "alias" : "Nearby City _(to help approximate location only)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Longitude", "type" : "esriFieldTypeDouble", "alias" : "Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Latitude", "type" : "esriFieldTypeDouble", "alias" : "Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CES_3_0_Score", "type" : "esriFieldTypeDouble", "alias" : "CES 3#0 Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CES_3_0_Percentile", "type" : "esriFieldTypeDouble", "alias" : "CES 3#0 Percentile", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CES_3_0__Percentile_Range", "type" : "esriFieldTypeString", "alias" : "CES 3#0 _Percentile Range", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SB_535_Disadvantaged_Community", "type" : "esriFieldTypeString", "alias" : "SB 535 Disadvantaged Community", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ozone", "type" : "esriFieldTypeDouble", "alias" : "Ozone", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ozone_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Ozone Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PM2_5", "type" : "esriFieldTypeDouble", "alias" : "PM2#5", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PM2_5_Pctl", "type" : "esriFieldTypeDouble", "alias" : "PM2#5 Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Diesel_PM", "type" : "esriFieldTypeDouble", "alias" : "Diesel PM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Diesel_PM_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Diesel PM Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Drinking_Water", "type" : "esriFieldTypeDouble", "alias" : "Drinking Water", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Drinking_Water_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Drinking Water Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pesticides", "type" : "esriFieldTypeDouble", "alias" : "Pesticides", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pesticides_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Pesticides Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tox__Release", "type" : "esriFieldTypeDouble", "alias" : "Tox# Release", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tox__Release_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Tox# Release Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Traffic", "type" : "esriFieldTypeDouble", "alias" : "Traffic", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Traffic_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Traffic Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Cleanup_Sites", "type" : "esriFieldTypeDouble", "alias" : "Cleanup Sites", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Cleanup_Sites_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Cleanup Sites Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Groundwater_Threats", "type" : "esriFieldTypeDouble", "alias" : "Groundwater Threats", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Groundwater_Threats_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Groundwater Threats Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Haz__Waste", "type" : "esriFieldTypeDouble", "alias" : "Haz# Waste", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Haz__Waste_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Haz# Waste Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Imp__Water_Bodies", "type" : "esriFieldTypeDouble", "alias" : "Imp# Water Bodies", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Imp__Water_Bodies_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Imp# Water Bodies Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Solid_Waste", "type" : "esriFieldTypeDouble", "alias" : "Solid Waste", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Solid_Waste_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Solid Waste Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pollution_Burden", "type" : "esriFieldTypeDouble", "alias" : "Pollution Burden", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pollution_Burden_Score", "type" : "esriFieldTypeDouble", "alias" : "Pollution Burden Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pollution_Burden_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Pollution Burden Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Asthma", "type" : "esriFieldTypeDouble", "alias" : "Asthma", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Asthma_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Asthma Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Low_Birth_Weight", "type" : "esriFieldTypeDouble", "alias" : "Low Birth Weight", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Low_Birth_Weight_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Low Birth Weight Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Cardiovascular_Disease", "type" : "esriFieldTypeDouble", "alias" : "Cardiovascular Disease", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Cardiovascular_Disease_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Cardiovascular Disease Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Education", "type" : "esriFieldTypeDouble", "alias" : "Education", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Education_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Education Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Linguistic_Isolation", "type" : "esriFieldTypeDouble", "alias" : "Linguistic Isolation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Linguistic_Isolation_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Linguistic Isolation Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Poverty", "type" : "esriFieldTypeDouble", "alias" : "Poverty", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Poverty_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Poverty Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Unemployment", "type" : "esriFieldTypeDouble", "alias" : "Unemployment", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Unemployment_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Unemployment Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Housing_Burden", "type" : "esriFieldTypeDouble", "alias" : "Housing Burden", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Housing_Burden_Pctl", "type" : "esriFieldTypeDouble", "alias" : "Housing Burden Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pop__Char_", "type" : "esriFieldTypeDouble", "alias" : "Pop# Char#", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pop__Char__Score", "type" : "esriFieldTypeDouble", "alias" : "Pop# Char# Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pop__Char__Pctl", "type" : "esriFieldTypeDouble", "alias" : "Pop# Char# Pctl", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ObjectID", "type" : "esriFieldTypeOID", "alias" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__UNDERSTA__9A6192B145800112", "fields" : "ObjectID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "'CES 3#0 (2018 Update)$'", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Pop__Char__Pctl" : null, "Census_Tract" : null, "Total_Population" : null, "California_County" : null, "ZIP" : null, "Nearby_City___to_help_approxima" : null, "Longitude" : null, "Latitude" : null, "CES_3_0_Score" : null, "CES_3_0_Percentile" : null, "CES_3_0__Percentile_Range" : null, "SB_535_Disadvantaged_Community" : null, "Ozone" : null, "Ozone_Pctl" : null, "PM2_5" : null, "PM2_5_Pctl" : null, "Diesel_PM" : null, "Diesel_PM_Pctl" : null, "Drinking_Water" : null, "Drinking_Water_Pctl" : null, "Pesticides" : null, "Pesticides_Pctl" : null, "Tox__Release" : null, "Tox__Release_Pctl" : null, "Traffic" : null, "Traffic_Pctl" : null, "Cleanup_Sites" : null, "Cleanup_Sites_Pctl" : null, "Groundwater_Threats" : null, "Groundwater_Threats_Pctl" : null, "Haz__Waste" : null, "Haz__Waste_Pctl" : null, "Imp__Water_Bodies" : null, "Imp__Water_Bodies_Pctl" : null, "Solid_Waste" : null, "Solid_Waste_Pctl" : null, "Pollution_Burden" : null, "Pollution_Burden_Score" : null, "Pollution_Burden_Pctl" : null, "Asthma" : null, "Asthma_Pctl" : null, "Low_Birth_Weight" : null, "Low_Birth_Weight_Pctl" : null, "Cardiovascular_Disease" : null, "Cardiovascular_Disease_Pctl" : null, "Education" : null, "Education_Pctl" : null, "Linguistic_Isolation" : null, "Linguistic_Isolation_Pctl" : null, "Poverty" : null, "Poverty_Pctl" : null, "Unemployment" : null, "Unemployment_Pctl" : null, "Housing_Burden" : null, "Housing_Burden_Pctl" : null, "Pop__Char_" : null, "Pop__Char__Score" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }