{ "currentVersion" : 12, "id" : 0, "name" : "ServiceRequests", "type" : "Feature Layer", "serviceItemId" : "4983e6bf6b4d446a9379f9e9a5b3b9d5", "displayField" : "DESCRIPTION", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : false, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "created_date", "creatorField" : "created_user", "editDateField" : "last_edited_date", "editorField" : "last_edited_user" }, "editingInfo" : { "lastEditDate" : 1638874798339, "schemaLastEditDate" : 1638874798339, "dataLastEditDate" : 1638874798339 }, "relationships" : [ { "id" : 0, "name" : "PotholeComments", "relatedTableId" : 5, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : true } ], "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" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "supportsOBACForAnonymousUsers" : true, "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" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "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" ], "supportsQueryAttachmentsWithReturnUrl" : true, "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsQueryBoxplots" : true, "supportsDefaultSR" : true, "supportsTranslations" : true, "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" ] }, "queryBoxplotsCapabilities" : { "supportsAsync" : true, "standardMaxCategoryCount" : 10000, "standardMaxSeriesCount" : 100 }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : true, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -12990389.70117001, "ymin" : 1466351.3199086597, "xmax" : 9778896.8181848638, "ymax" : 7385106.907637882, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"ISS_TYPE","field2":null,"field3":null,"fieldDelimiter":", ","defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"b25849a7bab68e1624be2e92dfa6f386","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAg5JREFUOI2tlD1oU1EUx38nCVwsmEJxcxCHokhdpCItVBe1LsUi1PeKo5V2cmrEmNSC5DUOSt2kuDiISRCLIEhRF78QarcuxsHNj0FLRSpe27zjkry8F5uSFP/weJz/ued33+HedxL8ZyWaZp7lE3zTIdCTCPuADoRVA8ugj6yTfdMy0BRyg/a7fxthbyShYGEQZJKS9wrZuMDZ6fLWwOLMRYveAqTqzANfQisOAX0oA2hi0ZS8IetkXm4OLHln0AgMQ2zWuunX9Q29y0BfNUpa5TGFa4cZvfohCnw4lWSduTCsRSWR+B3gWBS4bs4Du9qE1XTUlGb6rHPlbahlGQZAtYCwWHNt5c/HcGWXxJ6vaOV3qG4E6Ef9YSAM5GD1/RQ3e7fZp6w46SVgKTCK3n6g36r0QPRQOlvpbQt1NgLXgJ3bxglrjcAy0GskdoBC/njNtBJ/h3vpR7Dq/vU9RrS7ntfdqIJqOQI0ok+sSq9FU4imAh8GLNTvYawyaiEfxFrzZSECtBuVOeKJFLCj3W4NvLddmSiQc9OfKXpTwI02eRVUJziBHwUCuJmbFL1uYDzwxD9NKdcTxCpH6n3iI4xbN/uiZvw7HNzMBMVcGSQHdFhlMvo3BrBPRmJj1kkvhMs3n4dudpYH+QK+P4bPqWAewirCMsg8+vOedfK/GkubD9iR9FcgV31aVnPgNvUXfV+vahM7cZ4AAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15,"angle":0,"xoffset":0,"yoffset":0},"value":"DAS","label":"Damaged Sign","description":""},{"symbol":{"type":"esriPMS","url":"9e052a361bcaab2984d723427c33475f","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAutJREFUOI2tlF+IVFUcxz/n3t05yG5Bg2R3XPRBIQgqH4JChOjBemhBgnabneuUWyrqwwqVIL74tkSE6BIUqWy6zO60a2DkiwT1UET50hIRhO5Di97jil7xz7L9ZufeXw82M95pRyT6vp3zO78P3/P93XO7+J/V1bmkxpaubhWj/cBTePSSEFufX3o8ZuJThdmHBuaL7vm42x2T1FzCM1NI+iE93h0SVgv6gtQ5Qjm6RZfZz3gw/2BgGG2P0feChLKbDH5rq94C5oAKoeu3NT3fU3Q74mrw84pAW3YvSaojrNIX3Ym1tzvHAVSCc7Ijugh6lmH3SsNpCzhyPSc3amPkzKucKLRgJbcBw4BFA/G4iOgU02tvAPB54Q8J3QHqegx4LQu8ufymxXwt92dScnsxuhtlDN9cIGGT7eYHym6fTATfNZwSRu/m34o2xacKsy1gqoOSmH2t60ebJdXtJOlmqn1Lcm/7Wxl2Z2xNzzN4ZUvTqcfJxZQBoAW0HuulElxqrCVlr004JNW+pUx248G8lNxxLEPAxwAk5idBw+yVU7Qt9g3id/260jyszywp26S5wXXq5LPAdqm5ms8tr4vhZntJEl2PMa65sZg+Qre5mwEKxLyz8Dgn11wDwDAVJ+YgMJShFS+vwjCC8nrLsvcsqf6edaico5YM0silEswQRi9Tjqbyvn4QL3fP26T+jPiMouYzJoO5Zm/KkFVzWjLANP3UGv972bYwzldrFu9BC7sI3UCcmMOY+hPiM2c9DshE8GOjLSi6p52nG2Ui+CbrsNoXSxgdpTcZB30DjDadwsx90bS088qjbklP55fNnvif89mhVArHbSl6UkL3BXcXhptOV9KwW8eSnsHjo7jS4S0DyGThfcJol+1NL0g5+oScP90cFEDRbbQ+b0tN+61n9jdfTCdgw6kUL3+Jenv4KzlrwygPgIeRVP8Uz0zzWO45GVtda2/t/B1W+2JgFBiVjof+rQf8sf+b/gbfvUUQsPJE4QAAAABJRU5ErkJggg==","contentType":"image/png","width":15,"height":15,"angle":0,"xoffset":0,"yoffset":0},"value":"PTH","label":"Pothole","description":""},{"symbol":{"type":"esriPMS","url":"3fdf7743684c88e3dbf15180f6d4cc25","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAbhJREFUOI2t0zFoFEEUxvH/7gUeet02cTdXiGAjYqFiZSuaSrASMZBrRFHQQlCwsFHBQmwExSIpDCaVYClWEisxFiqHIIQUya4RnO4iH+RuLPSOXc1uNodf+d7Mjzczu2P854xVNTOz48AJL+0HQmAD+AS8TGC5NphG0TGce+ylw8Oi2WRfetMwO+ql6xnsCuHGOHyvBFOYwrmZrXot+Im0CCyuwQEPc2twbQI6W4KZ2UkvzQKN0nv4kwnorMLZEObXYWow6RBch2avJpab2GVwtQ/3gXYB7P0uxHWxQWL4ksFGCvsSWM4f+cxOsWHMFpBOAw/z4KFRvZ70PoRpyB05MHNeWijdJTVTs1MV/d0FEOlzAlfK1qfwCOlyxaDzBdBv89dsl8DsK1IOMetkzeaR2LmlEc3XhQn70pNQugecGwH7EEtvC2ALVjLopHA+gbkdYJtE0SWcowAC7IG7GTxNIUjgWQ2sB7QT594NCgUwAO/hwje4lcLzIIoeVNxpFpi1Y+lVvvjPywbggTursDfsdi+mcDuATcwOeukH8BF40YDZcan79/7ST6UFK0g3hwWpbGk9cNT8Ao2cn1Wj18m6AAAAAElFTkSuQmCC","contentType":"image/png","width":15,"height":15,"angle":0,"xoffset":0,"yoffset":0},"value":"SLO","label":"Street Light Out","description":""}]},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : true, "attachmentProperties" : [ { "name" : "id", "fieldName" : "ATTACHMENTID", "isEnabled" : true }, { "name" : "globalId", "fieldName" : "AttachmentGlobalID", "isEnabled" : true }, { "name" : "name", "fieldName" : "ATT_NAME", "isEnabled" : true }, { "name" : "size", "fieldName" : "DATA_SIZE", "isEnabled" : true }, { "name" : "contentType", "fieldName" : "CONTENT_TYPE", "isEnabled" : true }, { "name" : "keywords", "fieldName" : "Keywords", "isEnabled" : false }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : false } ], "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "ISS_TYPE", "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" : "esriFieldTypeSmallInteger", "alias" : "Status", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Status", "codedValues" : [ { "name" : "Unassigned", "code" : 0 }, { "name" : "In Progress", "code" : 1 }, { "name" : "Completed", "code" : 2 } ] }, "defaultValue" : null }, { "name" : "DESCRIPTION", "type" : "esriFieldTypeString", "alias" : "Description", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ISS_TYPE", "type" : "esriFieldTypeString", "alias" : "Issue Type", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "IssueType", "codedValues" : [ { "name" : "Pothole", "code" : "PTH" }, { "name" : "Street Light Out", "code" : "SLO" }, { "name" : "Damaged Sign", "code" : "DAS" } ] }, "defaultValue" : null }, { "name" : "VOTES", "type" : "esriFieldTypeInteger", "alias" : "Votes", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "REPORTEDBY", "type" : "esriFieldTypeString", "alias" : "Reported By", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "created_user", "type" : "esriFieldTypeString", "alias" : "created_user", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "created_date", "type" : "esriFieldTypeDate", "alias" : "created_date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_edited_user", "type" : "esriFieldTypeString", "alias" : "last_edited_user", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edited_date", "type" : "esriFieldTypeDate", "alias" : "last_edited_date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__Potholes__F4B70D857F7594D0", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_56005.Potholes_ServiceRequests_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "GlobalID_idx", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "created_dateIndex", "fields" : "created_date", "isAscending" : true, "isUnique" : false, "description" : "created_date Field index", "indexType" : "Attribute" }, { "name" : "created_userIndex", "fields" : "created_user", "isAscending" : false, "isUnique" : false, "description" : "created_user Field index", "indexType" : "Attribute" }, { "name" : "last_edited_dateIndex", "fields" : "last_edited_date", "isAscending" : true, "isUnique" : false, "description" : "last_edited_date Field index", "indexType" : "Attribute" }, { "name" : "last_edited_userIndex", "fields" : "last_edited_user", "isAscending" : false, "isUnique" : false, "description" : "last_edited_user Field index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : "PTH", "name" : "Pothole", "domains" : { "STATUS" : {"type" : "inherited"}, "ISS_TYPE" : {"type" : "inherited"} }, "templates" : [ { "name" : "Pothole", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "STATUS" : 0, "ISS_TYPE" : "PTH", "REPORTEDBY" : null, "DESCRIPTION" : null, "VOTES" : null } } } ] }, { "id" : "DAS", "name" : "Damaged Sign", "domains" : { "STATUS" : {"type" : "inherited"}, "ISS_TYPE" : {"type" : "inherited"} }, "templates" : [ { "name" : "Damaged Sign", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "STATUS" : 0, "ISS_TYPE" : "DAS", "REPORTEDBY" : null, "DESCRIPTION" : null, "VOTES" : null } } } ] }, { "id" : "SLO", "name" : "Street Light Out", "domains" : { "STATUS" : {"type" : "inherited"}, "ISS_TYPE" : {"type" : "inherited"} }, "templates" : [ { "name" : "Street Light Out", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "STATUS" : 0, "ISS_TYPE" : "SLO", "REPORTEDBY" : null, "DESCRIPTION" : null, "VOTES" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF, Parquet", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf,imageCollection", "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" : 100000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }