{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "Geocoded Crimes", "type" : "Feature Layer", "serviceItemId" : "5dcbe2cf7cf940779f813465b59c0e11", "cacheMaxAge" : 30, "displayField" : "USER_REPORT_NAME", "description" : "Sheet1_GeocodeAddresses1", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1460146990990, "schemaLastEditDate" : 1460146990990, "dataLastEditDate" : 1460146990990 }, "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, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "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, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "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" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 1318927.4378562421, "ymin" : 387590.75459755957, "xmax" : 1356002.3184307516, "ymax" : 420157.59300705791, "spatialReference" : { "wkid" : 102729, "latestWkid" : 2272 } }, "drawingInfo":{"renderer":{"type":"simple","label":"","description":"","symbol":{"color":[0,113,170,255],"size":6.75,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,0,0,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"}}},"transparency":0}, "allowGeometryUpdates" : true, "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" : "Status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Score", "type" : "esriFieldTypeDouble", "alias" : "Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Match_type", "type" : "esriFieldTypeString", "alias" : "Match_type", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Match_addr", "type" : "esriFieldTypeString", "alias" : "Match_addr", "sqlType" : "sqlTypeOther", "length" : 120, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Side", "type" : "esriFieldTypeString", "alias" : "Side", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ref_ID", "type" : "esriFieldTypeDouble", "alias" : "Ref_ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "User_fld", "type" : "esriFieldTypeString", "alias" : "User_fld", "sqlType" : "sqlTypeOther", "length" : 120, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Addr_type", "type" : "esriFieldTypeString", "alias" : "Addr_type", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "IN_Single_Line_Input", "type" : "esriFieldTypeString", "alias" : "Full Address", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_REPORT_ID", "type" : "esriFieldTypeInteger", "alias" : "Report ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_REPORT_NAME", "type" : "esriFieldTypeString", "alias" : "Report Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_CCR", "type" : "esriFieldTypeString", "alias" : "CCR Number", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_SECTION", "type" : "esriFieldTypeString", "alias" : "USER_SECTION", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_DESCRIPTION", "type" : "esriFieldTypeString", "alias" : "Description", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_ARREST_DATE", "type" : "esriFieldTypeString", "alias" : "Arrest Date", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_ARREST_TIME", "type" : "esriFieldTypeString", "alias" : "Arrest Time", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_ADDRESS", "type" : "esriFieldTypeString", "alias" : "Address", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_NEIGHBORHOOD", "type" : "esriFieldTypeString", "alias" : "Neighborhood", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_ZONE", "type" : "esriFieldTypeString", "alias" : "Police Zone", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_ARRESTEE", "type" : "esriFieldTypeString", "alias" : "Arrestee", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_AGE", "type" : "esriFieldTypeInteger", "alias" : "Arrestee Age", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_GENDER", "type" : "esriFieldTypeString", "alias" : "Arrestee Gender", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_DAY_OF_WEEK", "type" : "esriFieldTypeString", "alias" : "Day of Week", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "FDO_ObjectID", "fields" : "ObjectID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "FDO_Shape", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "PK__SWMAP_GE__9A6192B184D3D5EE", "fields" : "ObjectID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_2946.SWMAP_GEOCODED_CRIMES_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" : "Geocoded Crimes", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "USER_GENDER" : "", "USER_DAY_OF_WEEK" : "", "Status" : null, "Score" : null, "Match_type" : null, "Match_addr" : null, "Side" : null, "Ref_ID" : null, "User_fld" : null, "Addr_type" : null, "IN_Single_Line_Input" : "", "USER_REPORT_ID" : null, "USER_REPORT_NAME" : "", "USER_CCR" : "", "USER_SECTION" : "", "USER_DESCRIPTION" : "", "USER_ARREST_DATE" : "", "USER_ARREST_TIME" : "", "USER_ADDRESS" : "", "USER_NEIGHBORHOOD" : "", "USER_ZONE" : "", "USER_ARRESTEE" : "", "USER_AGE" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 1, "name" : "Geocoded Crimes Heat Map", "type" : "Feature Layer", "serviceItemId" : "5dcbe2cf7cf940779f813465b59c0e11", "cacheMaxAge" : 30, "displayField" : "USER_REPORT_NAME", "description" : "Sheet1_GeocodeAddresses1", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1460065660678, "schemaLastEditDate" : 1460065660678, "dataLastEditDate" : 1460065660678 }, "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, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "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, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "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" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 1318927.4378562421, "ymin" : 387590.75459755957, "xmax" : 1356002.3184307516, "ymax" : 420157.59300705791, "spatialReference" : { "wkid" : 102729, "latestWkid" : 2272 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "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" : "Status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Score", "type" : "esriFieldTypeDouble", "alias" : "Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Match_type", "type" : "esriFieldTypeString", "alias" : "Match_type", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Match_addr", "type" : "esriFieldTypeString", "alias" : "Match_addr", "sqlType" : "sqlTypeOther", "length" : 120, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Side", "type" : "esriFieldTypeString", "alias" : "Side", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ref_ID", "type" : "esriFieldTypeDouble", "alias" : "Ref_ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "User_fld", "type" : "esriFieldTypeString", "alias" : "User_fld", "sqlType" : "sqlTypeOther", "length" : 120, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Addr_type", "type" : "esriFieldTypeString", "alias" : "Addr_type", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "IN_Single_Line_Input", "type" : "esriFieldTypeString", "alias" : "Full Address", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_REPORT_ID", "type" : "esriFieldTypeInteger", "alias" : "USER_REPORT_ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_REPORT_NAME", "type" : "esriFieldTypeString", "alias" : "USER_REPORT_NAME", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_CCR", "type" : "esriFieldTypeString", "alias" : "USER_CCR", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_SECTION", "type" : "esriFieldTypeString", "alias" : "USER_SECTION", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_DESCRIPTION", "type" : "esriFieldTypeString", "alias" : "USER_DESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_ARREST_DATE", "type" : "esriFieldTypeString", "alias" : "USER_ARREST_DATE", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_ARREST_TIME", "type" : "esriFieldTypeString", "alias" : "USER_ARREST_TIME", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_ADDRESS", "type" : "esriFieldTypeString", "alias" : "USER_ADDRESS", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_NEIGHBORHOOD", "type" : "esriFieldTypeString", "alias" : "USER_NEIGHBORHOOD", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_ZONE", "type" : "esriFieldTypeString", "alias" : "USER_ZONE", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_ARRESTEE", "type" : "esriFieldTypeString", "alias" : "USER_ARRESTEE", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_AGE", "type" : "esriFieldTypeInteger", "alias" : "USER_AGE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_GENDER", "type" : "esriFieldTypeString", "alias" : "USER_GENDER", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_DAY_OF_WEEK", "type" : "esriFieldTypeString", "alias" : "USER_DAY_OF_WEEK", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "FDO_ObjectID", "fields" : "ObjectID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "FDO_Shape", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "PK__SWMAP_GE__9A6192B184D3D5EE", "fields" : "ObjectID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_2946.SWMAP_GEOCODED_CRIMES_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" : "Geocoded Crimes Heat Map", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "USER_GENDER" : "", "USER_DAY_OF_WEEK" : "", "Status" : null, "Score" : null, "Match_type" : null, "Match_addr" : null, "Side" : null, "Ref_ID" : null, "User_fld" : null, "Addr_type" : null, "IN_Single_Line_Input" : "", "USER_REPORT_ID" : null, "USER_REPORT_NAME" : "", "USER_CCR" : "", "USER_SECTION" : "", "USER_DESCRIPTION" : "", "USER_ARREST_DATE" : "", "USER_ARREST_TIME" : "", "USER_ADDRESS" : "", "USER_NEIGHBORHOOD" : "", "USER_ZONE" : "", "USER_ARRESTEE" : "", "USER_AGE" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 2, "name" : "Street Centerlines", "type" : "Feature Layer", "serviceItemId" : "5dcbe2cf7cf940779f813465b59c0e11", "cacheMaxAge" : 30, "displayField" : "NAME", "description" : "streetcenterline_CopyFeature", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1460065660678, "schemaLastEditDate" : 1460065660678, "dataLastEditDate" : 1460065660678 }, "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, "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" : 56338.201503696284, "maxScale" : 0, "extent" : { "xmin" : 1316692.3225757629, "ymin" : 387216.99648675323, "xmax" : 1361000.7500348389, "ymax" : 420573.17321258783, "spatialReference" : { "wkid" : 102729, "latestWkid" : 2272 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[178,178,178,142],"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_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_1", "type" : "esriFieldTypeInteger", "alias" : "OBJECTID_1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID_2", "type" : "esriFieldTypeDouble", "alias" : "OBJECTID_2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OBJECTID", "type" : "esriFieldTypeDouble", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FNODE_NO", "type" : "esriFieldTypeDouble", "alias" : "FNODE_NO", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TNODE_NO", "type" : "esriFieldTypeDouble", "alias" : "TNODE_NO", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LPOLY_NO", "type" : "esriFieldTypeDouble", "alias" : "LPOLY_NO", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RPOLY_NO", "type" : "esriFieldTypeDouble", "alias" : "RPOLY_NO", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LENGTH", "type" : "esriFieldTypeDouble", "alias" : "LENGTH", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREETCL_N", "type" : "esriFieldTypeDouble", "alias" : "STREETCL_N", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREETCL_I", "type" : "esriFieldTypeDouble", "alias" : "STREETCL_I", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PREFIX", "type" : "esriFieldTypeString", "alias" : "PREFIX", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NAME", "type" : "esriFieldTypeString", "alias" : "NAME", "sqlType" : "sqlTypeOther", "length" : 35, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TYPE", "type" : "esriFieldTypeString", "alias" : "TYPE", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUFFIX", "type" : "esriFieldTypeString", "alias" : "SUFFIX", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DIR", "type" : "esriFieldTypeString", "alias" : "DIR", "sqlType" : "sqlTypeOther", "length" : 3, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STREETNAME", "type" : "esriFieldTypeString", "alias" : "STREETNAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ALTERNATEN", "type" : "esriFieldTypeString", "alias" : "ALTERNATEN", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LLEFT", "type" : "esriFieldTypeDouble", "alias" : "LLEFT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HLEFT", "type" : "esriFieldTypeDouble", "alias" : "HLEFT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LRGT", "type" : "esriFieldTypeDouble", "alias" : "LRGT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HRGT", "type" : "esriFieldTypeDouble", "alias" : "HRGT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FROMSTREET", "type" : "esriFieldTypeString", "alias" : "FROMSTREET", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOSTREET", "type" : "esriFieldTypeString", "alias" : "TOSTREET", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIPL", "type" : "esriFieldTypeString", "alias" : "ZIPL", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZIPR", "type" : "esriFieldTypeString", "alias" : "ZIPR", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MCDL", "type" : "esriFieldTypeString", "alias" : "MCDL", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MCDR", "type" : "esriFieldTypeString", "alias" : "MCDR", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OWNER", "type" : "esriFieldTypeString", "alias" : "OWNER", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BELTWAY", "type" : "esriFieldTypeString", "alias" : "BELTWAY", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MAJORRD", "type" : "esriFieldTypeString", "alias" : "MAJORRD", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NO_LANES", "type" : "esriFieldTypeDouble", "alias" : "NO_LANES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CFCC", "type" : "esriFieldTypeString", "alias" : "CFCC", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GDTLINK", "type" : "esriFieldTypeString", "alias" : "GDTLINK", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ONEWAY", "type" : "esriFieldTypeString", "alias" : "ONEWAY", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STCL_CODE", "type" : "esriFieldTypeDouble", "alias" : "STCL_CODE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UNIQUE_ID", "type" : "esriFieldTypeDouble", "alias" : "UNIQUE_ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ROUTE_NO", "type" : "esriFieldTypeString", "alias" : "ROUTE_NO", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STD_RNG", "type" : "esriFieldTypeString", "alias" : "STD_RNG", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CHECKED", "type" : "esriFieldTypeDate", "alias" : "CHECKED", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "CHANGED", "type" : "esriFieldTypeString", "alias" : "CHANGED", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STADDED", "type" : "esriFieldTypeString", "alias" : "STADDED", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CLTYPE", "type" : "esriFieldTypeString", "alias" : "CLTYPE", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HALFVAC", "type" : "esriFieldTypeString", "alias" : "HALFVAC", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CEN20LT", "type" : "esriFieldTypeString", "alias" : "CEN20LT", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CEN20RG", "type" : "esriFieldTypeString", "alias" : "CEN20RG", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZONE_LEFT", "type" : "esriFieldTypeString", "alias" : "ZONE_LEFT", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZONE_RIGHT", "type" : "esriFieldTypeString", "alias" : "ZONE_RIGHT", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HOOD_LEFT", "type" : "esriFieldTypeString", "alias" : "HOOD_LEFT", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HOOD_RIGHT", "type" : "esriFieldTypeString", "alias" : "HOOD_RIGHT", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DPW_ZON_LT", "type" : "esriFieldTypeString", "alias" : "DPW_ZON_LT", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DPW_ZON_RT", "type" : "esriFieldTypeString", "alias" : "DPW_ZON_RT", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FIRE_ZN_LT", "type" : "esriFieldTypeString", "alias" : "FIRE_ZN_LT", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FIRE_ZN_RT", "type" : "esriFieldTypeString", "alias" : "FIRE_ZN_RT", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WARD_LT", "type" : "esriFieldTypeString", "alias" : "WARD_LT", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WARD_RG", "type" : "esriFieldTypeString", "alias" : "WARD_RG", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NH_L", "type" : "esriFieldTypeString", "alias" : "NH_L", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NH_R", "type" : "esriFieldTypeString", "alias" : "NH_R", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUNCIL_LT", "type" : "esriFieldTypeString", "alias" : "COUNCIL_LT", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COUNCIL_RT", "type" : "esriFieldTypeString", "alias" : "COUNCIL_RT", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "VOTE_DT_LT", "type" : "esriFieldTypeString", "alias" : "VOTE_DT_LT", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "VOTE_DT_RT", "type" : "esriFieldTypeString", "alias" : "VOTE_DT_RT", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CLASS", "type" : "esriFieldTypeString", "alias" : "CLASS", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PAVEDDATE", "type" : "esriFieldTypeDate", "alias" : "PAVEDDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "TRUCKROUTE", "type" : "esriFieldTypeString", "alias" : "TRUCKROUTE", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SYMBOLOGY", "type" : "esriFieldTypeSmallInteger", "alias" : "SYMBOLOGY", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape_Leng", "type" : "esriFieldTypeDouble", "alias" : "Shape_Leng", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "FDO_OBJECTID_12", "fields" : "OBJECTID_12", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "FDO_Shape", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "PK__SWMAP_ST__6F32A04CC3F444E4", "fields" : "OBJECTID_12", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_2946.SWMAP_STREET_CENTERLINES_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" : "Street Centerlines", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "SYMBOLOGY" : null, "Shape_Leng" : null, "OBJECTID_1" : null, "OBJECTID_2" : null, "OBJECTID" : null, "FNODE_NO" : null, "TNODE_NO" : null, "LPOLY_NO" : null, "RPOLY_NO" : null, "LENGTH" : null, "STREETCL_N" : null, "STREETCL_I" : null, "PREFIX" : null, "NAME" : null, "TYPE" : null, "SUFFIX" : null, "DIR" : null, "STREETNAME" : null, "ALTERNATEN" : null, "LLEFT" : null, "HLEFT" : null, "LRGT" : null, "HRGT" : null, "FROMSTREET" : null, "TOSTREET" : null, "ZIPL" : null, "ZIPR" : null, "MCDL" : null, "MCDR" : null, "OWNER" : null, "BELTWAY" : null, "MAJORRD" : null, "NO_LANES" : null, "CFCC" : null, "GDTLINK" : null, "ONEWAY" : null, "STCL_CODE" : null, "UNIQUE_ID" : null, "ROUTE_NO" : null, "STD_RNG" : null, "CHECKED" : null, "CHANGED" : null, "STADDED" : null, "CLTYPE" : null, "HALFVAC" : null, "CEN20LT" : null, "CEN20RG" : null, "ZONE_LEFT" : null, "ZONE_RIGHT" : null, "HOOD_LEFT" : null, "HOOD_RIGHT" : null, "DPW_ZON_LT" : null, "DPW_ZON_RT" : null, "FIRE_ZN_LT" : null, "FIRE_ZN_RT" : null, "WARD_LT" : null, "WARD_RG" : null, "NH_L" : null, "NH_R" : null, "COUNCIL_LT" : null, "COUNCIL_RT" : null, "VOTE_DT_LT" : null, "VOTE_DT_RT" : null, "CLASS" : null, "PAVEDDATE" : null, "TRUCKROUTE" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 3, "name" : "South West Districts", "type" : "Feature Layer", "serviceItemId" : "5dcbe2cf7cf940779f813465b59c0e11", "cacheMaxAge" : 30, "displayField" : "objectid_1", "description" : "SWCouncil", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1460065660678, "schemaLastEditDate" : 1460065660678, "dataLastEditDate" : 1460065660678 }, "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, "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" : 1315076.2400721463, "ymin" : 386720.938460848, "xmax" : 1356691.0433281811, "ymax" : 421124.16357734025, "spatialReference" : { "wkid" : 102729, "latestWkid" : 2272 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[255,234,190,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":2}},"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_1", "type" : "esriFieldTypeInteger", "alias" : "objectid_1", "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" : "intptlat10", "type" : "esriFieldTypeString", "alias" : "intptlat10", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "intptlon10", "type" : "esriFieldTypeString", "alias" : "intptlon10", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "shape_leng", "type" : "esriFieldTypeDouble", "alias" : "shape_leng", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "council", "type" : "esriFieldTypeInteger", "alias" : "Council District", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "councilman", "type" : "esriFieldTypeString", "alias" : "Councilperson", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "committee", "type" : "esriFieldTypeString", "alias" : "Committee", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "phone", "type" : "esriFieldTypeString", "alias" : "Phone Number", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "FDO_OBJECTID_12", "fields" : "OBJECTID_12", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "FDO_Shape", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "PK__SWMAP_SO__6F32A04CA2409B3D", "fields" : "OBJECTID_12", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_2946.SWMAP_SOUTH_WEST_DISTRICTS_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" : "South West Districts", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "committee" : null, "phone" : null, "objectid_1" : null, "objectid" : null, "intptlat10" : null, "intptlon10" : null, "shape_leng" : null, "council" : null, "councilman" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 4, "name" : "Pittsburgh City Council Districts", "type" : "Feature Layer", "serviceItemId" : "5dcbe2cf7cf940779f813465b59c0e11", "cacheMaxAge" : 30, "displayField" : "objectid_1", "description" : "Pittsburgh_City_Council_Districts", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1460120057062, "schemaLastEditDate" : 1460120057062, "dataLastEditDate" : 1460120057062 }, "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, "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" : 1314956.1810740407, "ymin" : 381634.49916644552, "xmax" : 1380167.5242597463, "ymax" : 434042.466197319, "spatialReference" : { "wkid" : 102729, "latestWkid" : 2272 } }, "drawingInfo":{"renderer":{"type":"simple","label":"","description":"","symbol":{"color":[255,235,175,255],"outline":{"color":[110,110,110,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"}},"transparency":20}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "FID", "uniqueIdField" : { "name" : "FID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "FID", "type" : "esriFieldTypeOID", "alias" : "FID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "objectid_1", "type" : "esriFieldTypeInteger", "alias" : "objectid_1", "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" : "intptlat10", "type" : "esriFieldTypeString", "alias" : "intptlat10", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "intptlon10", "type" : "esriFieldTypeString", "alias" : "intptlon10", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "shape_leng", "type" : "esriFieldTypeDouble", "alias" : "shape_leng", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "council", "type" : "esriFieldTypeInteger", "alias" : "council", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "councilman", "type" : "esriFieldTypeString", "alias" : "councilman", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "committee", "type" : "esriFieldTypeString", "alias" : "committee", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "phone", "type" : "esriFieldTypeString", "alias" : "phone", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "FDO_FID", "fields" : "FID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "FDO_Shape", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "PK__SWMAP_PI__C1BEA5A26B9E2E9B", "fields" : "FID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_2946.SWMAP_PITTSBURGH_CITY_COUNCIL_DISTRICTS_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" : "Pittsburgh City Council Districts", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "committee" : null, "phone" : null, "objectid_1" : null, "objectid" : null, "intptlat10" : null, "intptlon10" : null, "shape_leng" : null, "council" : null, "councilman" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ], "tables" : [ { "currentVersion" : 12, "id" : 5, "name" : "Sheet1_", "type" : "Table", "serviceItemId" : "5dcbe2cf7cf940779f813465b59c0e11", "cacheMaxAge" : 30, "displayField" : "REPORT_NAME", "description" : "", "copyrightText" : "", "defaultVisibility" : false, "editingInfo" : { "lastEditDate" : 1460065660678, "schemaLastEditDate" : 1460065660678, "dataLastEditDate" : 1460065660678 }, "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" : "REPORT_ID", "type" : "esriFieldTypeInteger", "alias" : "REPORT_ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "REPORT_NAME", "type" : "esriFieldTypeString", "alias" : "REPORT_NAME", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CCR", "type" : "esriFieldTypeString", "alias" : "CCR", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SECTION", "type" : "esriFieldTypeString", "alias" : "SECTION", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DESCRIPTION", "type" : "esriFieldTypeString", "alias" : "DESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ARREST_DATE", "type" : "esriFieldTypeString", "alias" : "ARREST_DATE", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ARREST_TIME", "type" : "esriFieldTypeString", "alias" : "ARREST_TIME", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ADDRESS", "type" : "esriFieldTypeString", "alias" : "ADDRESS", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NEIGHBORHOOD", "type" : "esriFieldTypeString", "alias" : "NEIGHBORHOOD", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ZONE", "type" : "esriFieldTypeString", "alias" : "ZONE", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ARRESTEE", "type" : "esriFieldTypeString", "alias" : "ARRESTEE", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AGE", "type" : "esriFieldTypeInteger", "alias" : "AGE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GENDER", "type" : "esriFieldTypeString", "alias" : "GENDER", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DAY_OF_WEEK", "type" : "esriFieldTypeString", "alias" : "DAY_OF_WEEK", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "FDO_OBJECTID", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "PK__SWMAP_SH__F4B70D85F79C05C9", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Sheet1_", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "GENDER" : null, "DAY_OF_WEEK" : null, "REPORT_ID" : null, "REPORT_NAME" : null, "CCR" : null, "SECTION" : null, "DESCRIPTION" : null, "ARREST_DATE" : null, "ARREST_TIME" : null, "ADDRESS" : null, "NEIGHBORHOOD" : null, "ZONE" : null, "ARRESTEE" : null, "AGE" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ] }