{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "Real Final", "type" : "Feature Layer", "serviceItemId" : "f43b4fc46c244c8fa2034819f4435790", "cacheMaxAge" : 30, "displayField" : "COUNTY", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1588435387578, "schemaLastEditDate" : 1588435387578, "dataLastEditDate" : 1588435387578 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 124359.57737936452, "ymin" : 14565485.303503539, "xmax" : 426620.82705342479, "ymax" : 14756414.803149331, "spatialReference" : { "wkid" : 32719, "latestWkid" : 32719 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[195,197,250,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.4}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID_12", "uniqueIdField" : { "name" : "OBJECTID_12", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID_12", "type" : "esriFieldTypeOID", "alias" : "OBJECTID_12", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID", "type" : "esriFieldTypeInteger", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FIPS_ID", "type" : "esriFieldTypeInteger", "alias" : "FIPS_ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUNTY", "type" : "esriFieldTypeString", "alias" : "COUNTY", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AREA_ACRES", "type" : "esriFieldTypeDouble", "alias" : "AREA_ACRES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID_1", "type" : "esriFieldTypeInteger", "alias" : "OBJECTID_1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "County_1", "type" : "esriFieldTypeString", "alias" : "County_1", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FIP_ID", "type" : "esriFieldTypeInteger", "alias" : "FIP_ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_Scor", "type" : "esriFieldTypeInteger", "alias" : "Total_Scor", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Final_Rank", "type" : "esriFieldTypeInteger", "alias" : "Final_Rank", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Education", "type" : "esriFieldTypeInteger", "alias" : "Education", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Drug_Rank", "type" : "esriFieldTypeInteger", "alias" : "Drug_Rank", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vul_Score", "type" : "esriFieldTypeInteger", "alias" : "Vul_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violence_R", "type" : "esriFieldTypeInteger", "alias" : "Violence_R", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Edu_Rank", "type" : "esriFieldTypeInteger", "alias" : "Edu_Rank", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violence", "type" : "esriFieldTypeInteger", "alias" : "Violence", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Homicide", "type" : "esriFieldTypeInteger", "alias" : "Homicide", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hom_Norm", "type" : "esriFieldTypeDouble", "alias" : "Hom_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hom_Score", "type" : "esriFieldTypeInteger", "alias" : "Hom_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Forc_Rape", "type" : "esriFieldTypeInteger", "alias" : "Forc_Rape", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rape_Norm", "type" : "esriFieldTypeDouble", "alias" : "Rape_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rape_Score", "type" : "esriFieldTypeInteger", "alias" : "Rape_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Assault", "type" : "esriFieldTypeInteger", "alias" : "Assault", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aslt_Norm", "type" : "esriFieldTypeDouble", "alias" : "Aslt_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aslt_Score", "type" : "esriFieldTypeInteger", "alias" : "Aslt_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Agg_Aslt", "type" : "esriFieldTypeInteger", "alias" : "Agg_Aslt", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AggSlt_Nor", "type" : "esriFieldTypeDouble", "alias" : "AggSlt_Nor", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Agg_Score", "type" : "esriFieldTypeInteger", "alias" : "Agg_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Other", "type" : "esriFieldTypeInteger", "alias" : "Other", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Other_Norm", "type" : "esriFieldTypeDouble", "alias" : "Other_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Other_Scor", "type" : "esriFieldTypeInteger", "alias" : "Other_Scor", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Income", "type" : "esriFieldTypeInteger", "alias" : "Income", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Inc_Score", "type" : "esriFieldTypeInteger", "alias" : "Inc_Score", "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" : "Pov_Score", "type" : "esriFieldTypeInteger", "alias" : "Pov_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HS_Grad", "type" : "esriFieldTypeDouble", "alias" : "HS_Grad", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HS_Score", "type" : "esriFieldTypeInteger", "alias" : "HS_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Opioid_Dea", "type" : "esriFieldTypeString", "alias" : "Opioid_Dea", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Death_Norm", "type" : "esriFieldTypeDouble", "alias" : "Death_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DeathScore", "type" : "esriFieldTypeInteger", "alias" : "DeathScore", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Opioid_D_1", "type" : "esriFieldTypeString", "alias" : "Opioid_D_1", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Death_No_1", "type" : "esriFieldTypeDouble", "alias" : "Death_No_1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DeathSco_1", "type" : "esriFieldTypeInteger", "alias" : "DeathSco_1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__REAL_MAP__6F32A04C4C5EAC74", "fields" : "OBJECTID_12", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_21841.REAL_MAP_REAL_FINAL_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Real Final", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "Death_No_1" : null, "DeathSco_1" : null, "OBJECTID" : null, "FIPS_ID" : null, "COUNTY" : null, "AREA_ACRES" : null, "OBJECTID_1" : null, "County_1" : null, "FIP_ID" : null, "Total_Scor" : null, "Final_Rank" : null, "Education" : null, "Drug_Rank" : null, "Vul_Score" : null, "Violence_R" : null, "Edu_Rank" : null, "Violence" : null, "Homicide" : null, "Hom_Norm" : null, "Hom_Score" : null, "Forc_Rape" : null, "Rape_Norm" : null, "Rape_Score" : null, "Assault" : null, "Aslt_Norm" : null, "Aslt_Score" : null, "Agg_Aslt" : null, "AggSlt_Nor" : null, "Agg_Score" : null, "Other" : null, "Other_Norm" : null, "Other_Scor" : null, "Income" : null, "Inc_Score" : null, "Poverty" : null, "Pov_Score" : null, "HS_Grad" : null, "HS_Score" : null, "Opioid_Dea" : null, "Death_Norm" : null, "DeathScore" : null, "Opioid_D_1" : 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", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 1, "name" : "Blank ", "type" : "Feature Layer", "serviceItemId" : "f43b4fc46c244c8fa2034819f4435790", "cacheMaxAge" : 30, "displayField" : "TOWN", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1588435394485, "schemaLastEditDate" : 1588435394485, "dataLastEditDate" : 1588435394485 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 124368.0272394917, "ymin" : 14565485.774662459, "xmax" : 426613.43847297726, "ymax" : 14756410.332582256, "spatialReference" : { "wkid" : 32719, "latestWkid" : 32719 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,0,0,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":0.4}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID_12", "uniqueIdField" : { "name" : "OBJECTID_12", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID_12", "type" : "esriFieldTypeOID", "alias" : "OBJECTID_12", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "TOWN_ID", "type" : "esriFieldTypeInteger", "alias" : "TOWN_ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOWN", "type" : "esriFieldTypeString", "alias" : "TOWN", "sqlType" : "sqlTypeOther", "length" : 21, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOWN2", "type" : "esriFieldTypeString", "alias" : "TOWN2", "sqlType" : "sqlTypeOther", "length" : 21, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUSUBFP10", "type" : "esriFieldTypeString", "alias" : "COUSUBFP10", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FIPS_STCO", "type" : "esriFieldTypeInteger", "alias" : "FIPS_STCO", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUNTY", "type" : "esriFieldTypeString", "alias" : "COUNTY", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POP1980", "type" : "esriFieldTypeInteger", "alias" : "POP1980", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POP1990", "type" : "esriFieldTypeInteger", "alias" : "POP1990", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POP2000", "type" : "esriFieldTypeInteger", "alias" : "POP2000", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POP2010", "type" : "esriFieldTypeInteger", "alias" : "POP2010", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POPCH80_90", "type" : "esriFieldTypeInteger", "alias" : "POPCH80_90", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POPCH90_00", "type" : "esriFieldTypeInteger", "alias" : "POPCH90_00", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POPCH00_10", "type" : "esriFieldTypeInteger", "alias" : "POPCH00_10", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HU2010", "type" : "esriFieldTypeInteger", "alias" : "HU2010", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FOURCOLOR", "type" : "esriFieldTypeInteger", "alias" : "FOURCOLOR", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TYPE", "type" : "esriFieldTypeString", "alias" : "TYPE", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AREA_ACRES", "type" : "esriFieldTypeDouble", "alias" : "AREA_ACRES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SQ_MILES", "type" : "esriFieldTypeDouble", "alias" : "SQ_MILES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID", "type" : "esriFieldTypeInteger", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "County_1", "type" : "esriFieldTypeString", "alias" : "County_1", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FIPS_STC_1", "type" : "esriFieldTypeInteger", "alias" : "FIPS_STC_1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Opioid_Dea", "type" : "esriFieldTypeString", "alias" : "Opioid_Dea", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Death_Norm", "type" : "esriFieldTypeDouble", "alias" : "Death_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DeathScore", "type" : "esriFieldTypeInteger", "alias" : "DeathScore", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID_1", "type" : "esriFieldTypeInteger", "alias" : "OBJECTID_1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "County_12", "type" : "esriFieldTypeString", "alias" : "County_12", "sqlType" : "sqlTypeOther", "length" : 254, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FIPS_STC_2", "type" : "esriFieldTypeInteger", "alias" : "FIPS_STC_2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_Scor", "type" : "esriFieldTypeInteger", "alias" : "Total_Scor", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Final_Rank", "type" : "esriFieldTypeInteger", "alias" : "Final_Rank", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__REAL_MAP__6F32A04C1B5CBD73", "fields" : "OBJECTID_12", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_21841.REAL_MAP_BLANK__Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Blank ", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "Total_Scor" : null, "Final_Rank" : null, "TOWN_ID" : null, "TOWN" : null, "TOWN2" : null, "COUSUBFP10" : null, "FIPS_STCO" : null, "COUNTY" : null, "POP1980" : null, "POP1990" : null, "POP2000" : null, "POP2010" : null, "POPCH80_90" : null, "POPCH90_00" : null, "POPCH00_10" : null, "HU2010" : null, "FOURCOLOR" : null, "TYPE" : null, "AREA_ACRES" : null, "SQ_MILES" : null, "OBJECTID" : null, "County_1" : null, "FIPS_STC_1" : null, "Opioid_Dea" : null, "Death_Norm" : null, "DeathScore" : null, "OBJECTID_1" : null, "County_12" : null, "FIPS_STC_2" : 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", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 2, "name" : "COUNTIES_POLYM", "type" : "Feature Layer", "serviceItemId" : "f43b4fc46c244c8fa2034819f4435790", "cacheMaxAge" : 30, "displayField" : "COUNTIES_POLYM.COUNTY", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1588435395587, "schemaLastEditDate" : 1588435395587, "dataLastEditDate" : 1588435395587 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 124359.57737936452, "ymin" : 14565485.303503539, "xmax" : 426620.82705342479, "ymax" : 14756414.803149331, "spatialReference" : { "wkid" : 32719, "latestWkid" : 32719 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[198,245,241,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.4}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID_1", "uniqueIdField" : { "name" : "OBJECTID_1", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID_1", "type" : "esriFieldTypeOID", "alias" : "OBJECTID_1", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID", "type" : "esriFieldTypeInteger", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FIPS_ID", "type" : "esriFieldTypeInteger", "alias" : "FIPS_ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUNTY", "type" : "esriFieldTypeString", "alias" : "COUNTY", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AREA_ACRES", "type" : "esriFieldTypeDouble", "alias" : "AREA_ACRES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "PK__REAL_MAP__E458E6E7B7AADA7B", "fields" : "OBJECTID_1", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_21841.REAL_MAP_COUNTIES_POLYM_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "COUNTIES_POLYM", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "COUNTY" : null, "AREA_ACRES" : null, "OBJECTID" : null, "FIPS_ID" : 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", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 3, "name" : "CENSUS2010TOWNS_ARC", "type" : "Feature Layer", "serviceItemId" : "f43b4fc46c244c8fa2034819f4435790", "cacheMaxAge" : 30, "displayField" : "OUTLINE", "description" : "The Municipal Boundaries from Census 2010 line feature class was created by dissolving the Census 2010 Block data on the COUSUBFP10 (county subdivision) field and converting that polygon dataset (CENSUS2010TOWNS_POLY) to a line dataset. The linework in layer was then coded to distinguish state boundaries, municipal boundaries and coastline This dataset may be used as basemap data when mapping Census 2010 geography, as other municipal boundary layers from MassGIS will not line up exactly with the Census geography.", "copyrightText" : "MassGIS, from data from the U.S. Census Bureau", "defaultVisibility" : false, "editingInfo" : { "lastEditDate" : 1588435402865, "schemaLastEditDate" : 1588435402865, "dataLastEditDate" : 1588435402865 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 124368.0272394917, "ymin" : 14565485.774662459, "xmax" : 426613.43847297115, "ymax" : 14756410.33258226, "spatialReference" : { "wkid" : 32719, "latestWkid" : 32719 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,166,135,255],"width":1},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "OUTLINE", "type" : "esriFieldTypeInteger", "alias" : "OUTLINE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__REAL_MAP__F4B70D85F68BF486", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_21841.REAL_MAP_CENSUS2010TOWNS_ARC_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "CENSUS2010TOWNS_ARC", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "OUTLINE" : 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", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 4, "name" : "CENSUS2010TOWNS_POLY", "type" : "Feature Layer", "serviceItemId" : "f43b4fc46c244c8fa2034819f4435790", "cacheMaxAge" : 30, "displayField" : "CENSUS2010TOWNS_POLY.TOWN", "description" : "The Municipal Boundaries from Census 2010 polygon feature class was created by dissolving the Census 2010 Block data on the COUSUBFP10 (county subdivision) field. Community-based attributes such as town name, ID and population were then added. This dataset may be used as basemap data when mapping Census 2010 geography, as other municipal boundary layers from MassGIS will not line up exactly with the Census geography.", "copyrightText" : "MassGIS, from data from the U.S. Census Bureau", "defaultVisibility" : false, "editingInfo" : { "lastEditDate" : 1588435408501, "schemaLastEditDate" : 1588435408501, "dataLastEditDate" : 1588435408501 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 124368.0272394917, "ymin" : 14565485.774662459, "xmax" : 426613.43847297726, "ymax" : 14756410.332582256, "spatialReference" : { "wkid" : 32719, "latestWkid" : 32719 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[201,245,240,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.4}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "TOWN_ID", "type" : "esriFieldTypeInteger", "alias" : "TOWN_ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOWN", "type" : "esriFieldTypeString", "alias" : "TOWN", "sqlType" : "sqlTypeOther", "length" : 21, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOWN2", "type" : "esriFieldTypeString", "alias" : "TOWN2", "sqlType" : "sqlTypeOther", "length" : 21, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUSUBFP10", "type" : "esriFieldTypeString", "alias" : "COUSUBFP10", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FIPS_STCO", "type" : "esriFieldTypeInteger", "alias" : "FIPS_STCO", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUNTY", "type" : "esriFieldTypeString", "alias" : "COUNTY", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POP1980", "type" : "esriFieldTypeInteger", "alias" : "POP1980", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POP1990", "type" : "esriFieldTypeInteger", "alias" : "POP1990", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POP2000", "type" : "esriFieldTypeInteger", "alias" : "POP2000", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POP2010", "type" : "esriFieldTypeInteger", "alias" : "POP2010", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POPCH80_90", "type" : "esriFieldTypeInteger", "alias" : "POPCH80_90", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POPCH90_00", "type" : "esriFieldTypeInteger", "alias" : "POPCH90_00", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POPCH00_10", "type" : "esriFieldTypeInteger", "alias" : "POPCH00_10", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HU2010", "type" : "esriFieldTypeInteger", "alias" : "HU2010", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FOURCOLOR", "type" : "esriFieldTypeInteger", "alias" : "FOURCOLOR", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TYPE", "type" : "esriFieldTypeString", "alias" : "TYPE", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AREA_ACRES", "type" : "esriFieldTypeDouble", "alias" : "AREA_ACRES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SQ_MILES", "type" : "esriFieldTypeDouble", "alias" : "SQ_MILES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "PK__REAL_MAP__F4B70D852914D5DA", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_21841.REAL_MAP_CENSUS2010TOWNS_POLY_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "CENSUS2010TOWNS_POLY", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "AREA_ACRES" : null, "SQ_MILES" : null, "TOWN_ID" : null, "TOWN" : null, "TOWN2" : null, "COUSUBFP10" : null, "FIPS_STCO" : null, "COUNTY" : null, "POP1980" : null, "POP1990" : null, "POP2000" : null, "POP2010" : null, "POPCH80_90" : null, "POPCH90_00" : null, "POPCH00_10" : null, "HU2010" : null, "FOURCOLOR" : null, "TYPE" : 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", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ], "tables" : [ { "currentVersion" : 12, "id" : 5, "name" : "FBI_clean_ExcelToTable", "type" : "Table", "serviceItemId" : "f43b4fc46c244c8fa2034819f4435790", "cacheMaxAge" : 30, "displayField" : "TOWN2", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1588435385157, "schemaLastEditDate" : 1588435385157, "dataLastEditDate" : 1588435385157 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "TOWN2", "type" : "esriFieldTypeString", "alias" : "TOWN2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violent_Crime", "type" : "esriFieldTypeInteger", "alias" : "Violent_Crime", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Murder_and___nonnegligent_mansl", "type" : "esriFieldTypeInteger", "alias" : "Murder_and_\n_nonnegligent_manslaughter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Robbery", "type" : "esriFieldTypeInteger", "alias" : "Robbery", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aggravated_assault", "type" : "esriFieldTypeInteger", "alias" : "Aggravated_assault", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Burglary", "type" : "esriFieldTypeInteger", "alias" : "Burglary", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Larceny_theft", "type" : "esriFieldTypeInteger", "alias" : "Larceny_theft", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Motor_vehicle_theft", "type" : "esriFieldTypeInteger", "alias" : "Motor_vehicle_theft", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Arson", "type" : "esriFieldTypeInteger", "alias" : "Arson", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__REAL_MAP__F4B70D858A3CFA8F", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "I9TOWN2", "fields" : "TOWN2", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "FBI_clean_ExcelToTable", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Motor_vehicle_theft" : null, "Arson" : null, "TOWN2" : null, "Violent_Crime" : null, "Murder_and___nonnegligent_mansl" : null, "Robbery" : null, "Aggravated_assault" : null, "Burglary" : null, "Larceny_theft" : 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", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 6, "name" : "Drug_Clean_ExcelToTable3", "type" : "Table", "serviceItemId" : "f43b4fc46c244c8fa2034819f4435790", "cacheMaxAge" : 30, "displayField" : "County", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1588435385157, "schemaLastEditDate" : 1588435385157, "dataLastEditDate" : 1588435385157 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "County", "type" : "esriFieldTypeString", "alias" : "County", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FIPS_STCO", "type" : "esriFieldTypeInteger", "alias" : "FIPS_STCO", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Opioid_Death", "type" : "esriFieldTypeString", "alias" : "Opioid_Death", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Death_Norm", "type" : "esriFieldTypeDouble", "alias" : "Death_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DeathScore", "type" : "esriFieldTypeInteger", "alias" : "DeathScore", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__REAL_MAP__F4B70D8581FD5E84", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "I8FIPS_STCO", "fields" : "FIPS_STCO", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Drug_Clean_ExcelToTable3", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Death_Norm" : null, "DeathScore" : null, "County" : null, "FIPS_STCO" : null, "Opioid_Death" : 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", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 7, "name" : "MassCrime_Clean_ExcelToTable2", "type" : "Table", "serviceItemId" : "f43b4fc46c244c8fa2034819f4435790", "cacheMaxAge" : 30, "displayField" : "County", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1588435385157, "schemaLastEditDate" : 1588435385157, "dataLastEditDate" : 1588435385157 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "County", "type" : "esriFieldTypeString", "alias" : "County", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FIPS_STCO", "type" : "esriFieldTypeInteger", "alias" : "FIPS_STCO", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Homicide", "type" : "esriFieldTypeInteger", "alias" : "Homicide", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hom_Norm", "type" : "esriFieldTypeDouble", "alias" : "Hom_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hom_Score", "type" : "esriFieldTypeInteger", "alias" : "Hom_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Forc_Rape", "type" : "esriFieldTypeInteger", "alias" : "Forc_Rape", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rape_Norm", "type" : "esriFieldTypeDouble", "alias" : "Rape_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rape_Score", "type" : "esriFieldTypeInteger", "alias" : "Rape_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Assault", "type" : "esriFieldTypeInteger", "alias" : "Assault", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aslt_Norm", "type" : "esriFieldTypeDouble", "alias" : "Aslt_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aslt_Score", "type" : "esriFieldTypeInteger", "alias" : "Aslt_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Agg_Aslt", "type" : "esriFieldTypeInteger", "alias" : "Agg_Aslt", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AggSlt_Norm", "type" : "esriFieldTypeDouble", "alias" : "AggSlt_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Agg_Score", "type" : "esriFieldTypeInteger", "alias" : "Agg_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Other", "type" : "esriFieldTypeInteger", "alias" : "Other", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Other_Norm", "type" : "esriFieldTypeDouble", "alias" : "Other_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Other_Score", "type" : "esriFieldTypeInteger", "alias" : "Other_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__REAL_MAP__F4B70D85A0DA0F59", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "I7FIPS_STCO", "fields" : "FIPS_STCO", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "MassCrime_Clean_ExcelToTable2", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Other_Norm" : null, "Other_Score" : null, "County" : null, "FIPS_STCO" : null, "Homicide" : null, "Hom_Norm" : null, "Hom_Score" : null, "Forc_Rape" : null, "Rape_Norm" : null, "Rape_Score" : null, "Assault" : null, "Aslt_Norm" : null, "Aslt_Score" : null, "Agg_Aslt" : null, "AggSlt_Norm" : null, "Agg_Score" : null, "Other" : 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", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 8, "name" : "Vulenerabilities_Clean_Excel5", "type" : "Table", "serviceItemId" : "f43b4fc46c244c8fa2034819f4435790", "cacheMaxAge" : 30, "displayField" : "County", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1588435385157, "schemaLastEditDate" : 1588435385157, "dataLastEditDate" : 1588435385157 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "County", "type" : "esriFieldTypeString", "alias" : "County", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FIPS_STCO", "type" : "esriFieldTypeInteger", "alias" : "FIPS_STCO", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Income", "type" : "esriFieldTypeInteger", "alias" : "Income ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Inc_Score", "type" : "esriFieldTypeInteger", "alias" : "Inc_Score", "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" : "Pov_Score", "type" : "esriFieldTypeInteger", "alias" : "Pov_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HS_Grad", "type" : "esriFieldTypeDouble", "alias" : "HS_Grad", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HS_Score", "type" : "esriFieldTypeInteger", "alias" : "HS_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__REAL_MAP__F4B70D8568754A24", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "I6FIPS_STCO", "fields" : "FIPS_STCO", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Vulenerabilities_Clean_Excel5", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "HS_Grad" : null, "HS_Score" : null, "County" : null, "FIPS_STCO" : null, "Income" : null, "Inc_Score" : null, "Poverty" : null, "Pov_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", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 9, "name" : "FinalMapcalculations_ExcelTo6", "type" : "Table", "serviceItemId" : "f43b4fc46c244c8fa2034819f4435790", "cacheMaxAge" : 30, "displayField" : "County", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1588435385157, "schemaLastEditDate" : 1588435385157, "dataLastEditDate" : 1588435385157 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "County", "type" : "esriFieldTypeString", "alias" : "County", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FIP_ID", "type" : "esriFieldTypeInteger", "alias" : "FIP_ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_Score", "type" : "esriFieldTypeInteger", "alias" : "Total_Score ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Final_Rank", "type" : "esriFieldTypeInteger", "alias" : "Final_Rank", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Education", "type" : "esriFieldTypeInteger", "alias" : "Education", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Edu_Rank", "type" : "esriFieldTypeInteger", "alias" : "Edu_Rank", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violence", "type" : "esriFieldTypeInteger", "alias" : "Violence", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violence_Rank", "type" : "esriFieldTypeInteger", "alias" : "Violence_Rank", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Drugs", "type" : "esriFieldTypeInteger", "alias" : "Drugs", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Homicide", "type" : "esriFieldTypeInteger", "alias" : "Homicide", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hom_Norm", "type" : "esriFieldTypeDouble", "alias" : "Hom_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hom_Score", "type" : "esriFieldTypeInteger", "alias" : "Hom_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Forc_Rape", "type" : "esriFieldTypeInteger", "alias" : "Forc_Rape", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rape_Norm", "type" : "esriFieldTypeDouble", "alias" : "Rape_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rape_Score", "type" : "esriFieldTypeInteger", "alias" : "Rape_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Assault", "type" : "esriFieldTypeInteger", "alias" : "Assault", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aslt_Norm", "type" : "esriFieldTypeDouble", "alias" : "Aslt_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aslt_Score", "type" : "esriFieldTypeInteger", "alias" : "Aslt_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Agg_Aslt", "type" : "esriFieldTypeInteger", "alias" : "Agg_Aslt", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AggSlt_Norm", "type" : "esriFieldTypeDouble", "alias" : "AggSlt_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Agg_Score", "type" : "esriFieldTypeInteger", "alias" : "Agg_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Other", "type" : "esriFieldTypeInteger", "alias" : "Other", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Other_Norm", "type" : "esriFieldTypeDouble", "alias" : "Other_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Other_Score", "type" : "esriFieldTypeInteger", "alias" : "Other_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Income", "type" : "esriFieldTypeInteger", "alias" : "Income ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Inc_Score", "type" : "esriFieldTypeInteger", "alias" : "Inc_Score", "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" : "Pov_Score", "type" : "esriFieldTypeInteger", "alias" : "Pov_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HS_Grad", "type" : "esriFieldTypeDouble", "alias" : "HS_Grad", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HS_Score", "type" : "esriFieldTypeInteger", "alias" : "HS_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Opioid_Death", "type" : "esriFieldTypeString", "alias" : "Opioid_Death", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Death_Norm", "type" : "esriFieldTypeDouble", "alias" : "Death_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DeathScore", "type" : "esriFieldTypeInteger", "alias" : "DeathScore", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Opioid_D_1", "type" : "esriFieldTypeString", "alias" : "Opioid_Death", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Death_No_1", "type" : "esriFieldTypeDouble", "alias" : "Death_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DeathSco_1", "type" : "esriFieldTypeInteger", "alias" : "DeathScore", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violence_Score", "type" : "esriFieldTypeString", "alias" : "Violence_Score", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vulnerability_Score", "type" : "esriFieldTypeString", "alias" : "Vulnerability_Score", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__REAL_MAP__F4B70D857571AA72", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "I5FIP_ID", "fields" : "FIP_ID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "FinalMapcalculations_ExcelTo6", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Violence_Score" : null, "Vulnerability_Score" : null, "County" : null, "FIP_ID" : null, "Total_Score" : null, "Final_Rank" : null, "Education" : null, "Edu_Rank" : null, "Violence" : null, "Violence_Rank" : null, "Drugs" : null, "Homicide" : null, "Hom_Norm" : null, "Hom_Score" : null, "Forc_Rape" : null, "Rape_Norm" : null, "Rape_Score" : null, "Assault" : null, "Aslt_Norm" : null, "Aslt_Score" : null, "Agg_Aslt" : null, "AggSlt_Norm" : null, "Agg_Score" : null, "Other" : null, "Other_Norm" : null, "Other_Score" : null, "Income" : null, "Inc_Score" : null, "Poverty" : null, "Pov_Score" : null, "HS_Grad" : null, "HS_Score" : null, "Opioid_Death" : null, "Death_Norm" : null, "DeathScore" : null, "Opioid_D_1" : null, "Death_No_1" : null, "DeathSco_1" : 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", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 10, "name" : "Real_Final_ExcelToTable1", "type" : "Table", "serviceItemId" : "f43b4fc46c244c8fa2034819f4435790", "cacheMaxAge" : 30, "displayField" : "County", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1588435385157, "schemaLastEditDate" : 1588435385157, "dataLastEditDate" : 1588435385157 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "County", "type" : "esriFieldTypeString", "alias" : "County", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FIP_ID", "type" : "esriFieldTypeInteger", "alias" : "FIP_ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_Score", "type" : "esriFieldTypeInteger", "alias" : "Total_Score ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Final_Rank", "type" : "esriFieldTypeInteger", "alias" : "Final_Rank", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Education", "type" : "esriFieldTypeInteger", "alias" : "Education", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Drug_Rank", "type" : "esriFieldTypeInteger", "alias" : "Drug_Rank", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Vul_Score", "type" : "esriFieldTypeInteger", "alias" : "Vul_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violence_Rank", "type" : "esriFieldTypeInteger", "alias" : "Violence_Rank", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Edu_Rank", "type" : "esriFieldTypeInteger", "alias" : "Edu_Rank", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Violence", "type" : "esriFieldTypeInteger", "alias" : "Violence", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Homicide", "type" : "esriFieldTypeInteger", "alias" : "Homicide", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hom_Norm", "type" : "esriFieldTypeDouble", "alias" : "Hom_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hom_Score", "type" : "esriFieldTypeInteger", "alias" : "Hom_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Forc_Rape", "type" : "esriFieldTypeInteger", "alias" : "Forc_Rape", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rape_Norm", "type" : "esriFieldTypeDouble", "alias" : "Rape_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rape_Score", "type" : "esriFieldTypeInteger", "alias" : "Rape_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Assault", "type" : "esriFieldTypeInteger", "alias" : "Assault", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aslt_Norm", "type" : "esriFieldTypeDouble", "alias" : "Aslt_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Aslt_Score", "type" : "esriFieldTypeInteger", "alias" : "Aslt_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Agg_Aslt", "type" : "esriFieldTypeInteger", "alias" : "Agg_Aslt", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AggSlt_Norm", "type" : "esriFieldTypeDouble", "alias" : "AggSlt_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Agg_Score", "type" : "esriFieldTypeInteger", "alias" : "Agg_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Other", "type" : "esriFieldTypeInteger", "alias" : "Other", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Other_Norm", "type" : "esriFieldTypeDouble", "alias" : "Other_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Other_Score", "type" : "esriFieldTypeInteger", "alias" : "Other_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Income", "type" : "esriFieldTypeInteger", "alias" : "Income ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Inc_Score", "type" : "esriFieldTypeInteger", "alias" : "Inc_Score", "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" : "Pov_Score", "type" : "esriFieldTypeInteger", "alias" : "Pov_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HS_Grad", "type" : "esriFieldTypeDouble", "alias" : "HS_Grad", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HS_Score", "type" : "esriFieldTypeInteger", "alias" : "HS_Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Opioid_Death", "type" : "esriFieldTypeString", "alias" : "Opioid_Death", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Death_Norm", "type" : "esriFieldTypeDouble", "alias" : "Death_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DeathScore", "type" : "esriFieldTypeInteger", "alias" : "DeathScore", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Opioid_D_1", "type" : "esriFieldTypeString", "alias" : "Opioid_Death", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Death_No_1", "type" : "esriFieldTypeDouble", "alias" : "Death_Norm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DeathSco_1", "type" : "esriFieldTypeInteger", "alias" : "DeathScore", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__REAL_MAP__F4B70D856E5CA994", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "I3FIP_ID", "fields" : "FIP_ID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Real_Final_ExcelToTable1", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Death_No_1" : null, "DeathSco_1" : null, "County" : null, "FIP_ID" : null, "Total_Score" : null, "Final_Rank" : null, "Education" : null, "Drug_Rank" : null, "Vul_Score" : null, "Violence_Rank" : null, "Edu_Rank" : null, "Violence" : null, "Homicide" : null, "Hom_Norm" : null, "Hom_Score" : null, "Forc_Rape" : null, "Rape_Norm" : null, "Rape_Score" : null, "Assault" : null, "Aslt_Norm" : null, "Aslt_Score" : null, "Agg_Aslt" : null, "AggSlt_Norm" : null, "Agg_Score" : null, "Other" : null, "Other_Norm" : null, "Other_Score" : null, "Income" : null, "Inc_Score" : null, "Poverty" : null, "Pov_Score" : null, "HS_Grad" : null, "HS_Score" : null, "Opioid_Death" : null, "Death_Norm" : null, "DeathScore" : null, "Opioid_D_1" : 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", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ] }