{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "Service Requests", "type" : "Feature Layer", "serviceItemId" : "435de14059494304a1c7a08bd4f0898b", "cacheMaxAge" : 30, "displayField" : "NAME", "description" : "A request for service or incident reported by the general public or other interested party", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1414786142473, "schemaLastEditDate" : 1414786142473, "dataLastEditDate" : 1414786142473 }, "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" : 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, "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, "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" : -9821187.4105665963, "ymin" : 5111897.4792083781, "xmax" : -9805944.59905364, "ymax" : 5132731.06472314, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"STATUS","field2":null,"field3":null,"fieldDelimiter":", ","defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"3a12c8552dd83464c5c4795685f93aff","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAA+VJREFUOI211V9oU1ccwPHvuTd3N+lNTe3E2tlalZRSijWl0WJB1FCdsUotBcENNwTBB+eo7KGrdIrQ2ckeZMLyMMQ++OAoTAjKfFBSpdBObEbYVrRQxGpdDKxxMblt/t1799AZDNYqjP3gwPnH5/zlHBv/U9iWapyBcgk+kjyeTnK5OvJ5h2Wz6cBv1sTETzIMVYD+zvAjsNnd7q8sXf/SikbfM+/fx9bWhqRpGIlEuXH7djXQbtbUXIgmkz2V8XjgrXAUXMLjGTYjkSZ5506cp05hX78eSVEKfczubuYnJ0ldueI0p6e/f+bx7FUjkc7lkFkUjoIimptHzHB4Q0lvL8t8PoQsv7YiSVXRGhtx1NeTCAZJBwL+jMcTtCIRvwDrNVi0tn5rjo5u0E6eZFlb28Ls5ufRIxEy4+MYsRi2qipUr5eSjRuRFIWyri7+BtKBwIexurrPmZz8rgh+Bh+YDx58Ztu3j9IdOwDIxmI8P3cOMxIpDJ4FskNDzPl8lB8/js3lwtXRQTYcxpqdHYjBxQrQC7Dw+U4QCsnOjg6ELGPoOs/7+zEnJhY7X4xQiDiwoqcHSVFwHjzIi+5uh+l2f8zU1A+vbkWXcLux19QAoN+9+0b0VXxu926cXi+OujpeqCpSbe0nRbD5+PFqZcuWwmGl79xZEn0ZmfFxnF4vkqoib9+OlUrVFe2x9eSJIu3a9W/BwhgZeSc4PzNTyMsuF/lYzFEEi+pqw5qbWygLgdTcjBkOvxWWKyoKeVPXEWVl2SJYrq2N5+7dW2kdOoQQArvPx9w7wKrXu4DmcuRv3ULZs+fPIlhatWo0f+PG/szTp9irqtBaW5mvrMSKRt+ISh4PmscDQPrhQ8hkEE7nz0WwGY+fQlX369evYz96dOF+9veT6OtbFJcaGlje04PkcGAZBqmrVxFut5m+fPmbInhlMPj77OHDo5nBwdZkUxOlLS041q1DCQTQR0dJh0KY4TDy1q3Yt21Da2lB1jQAXoRCGDdvoh458uP7U1PxIhhAhj02v/9pqrdXY2CA0s2bF2bu9+Py+8GyQIhCf8swSA4PMzcwgNLZ+Sx58eKnL9uK4LLBwUTixAkvkvRrqrfXkT1wAG3vXtTVqxFCFFDLMEhPT5MKBslfu4bS1fWXvGLFhrWQXxQGcJ0//yDZ11edXbMmlLl0qTE7NITU0ICyaROipAQzmSQ3NoY1NYWorMR+7NgtU5bbyy9cyL7qLPrQl/b3zwIbE2fO7DDi8a+NmZnG3NhYifnokZDq6y2lqSlpa2//RdK0L5adPfvHYsaSX5Pr9OlhoLWoMhJZSG+JJeH/Ev8AYbmDTgyjryIAAAAASUVORK5CYII=","contentType":"image/png","width":16,"height":16,"angle":0,"xoffset":0,"yoffset":0},"value":"Unassigned","label":"Unassigned","description":""},{"symbol":{"type":"esriPMS","url":"c901d3654a452868ec09d5d720eedf8c","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAA8hJREFUOI211VtoHFUYB/D/mcvOzM5uNplN0p2kuZENGyiJaVMsFoX2QWpabRq8Ui/xQXySQvFBfdA3qeCToj6ECval1BaR9KGikbYQKUZEQmokq0tzscluQnY2e9+5neND2jVDNmlB/ODAmTnDb77vfIcZAf9TCLst3h2DxjGc5kRtBDQYA/IKI8EiYM0wN/kNL+HynlEUHxpeOAdBbpLeZxTvMpg+ahsQlHZwQgSuXdBcc7YNDCeorX2aHDPe0d/EFw+Ek2MIEUG/Qe3kfl6OIdD+OOSGCDj+30epM4zy+jIKf98MUNf4PPWl/rSUS440nIVZE05egkhK+iS1k33+yDDquvpBCLetIk4QoUY6oTS9gmziF1TSE0NmqGOcYXGIAGwbTMqxj6kd71P1YdR1DdzLzkIxNQ8z/RdcOwtBCkNqjMLf3AmOF1AfewwbcaCSnji2el47gzeMTzxw6jO0UHvhLcE/gGBnPwDAymeQmRsHtRerL7esBKz8FEorMWj7TkKQ/QhFH4WV+xOM5s+tXsD5PaMoVmES6DgLc5EPtB8CIRxcy0TmjyugbrJWf+GacRizV9E48Bw4XkCg7Qhydy4olGgvA8bYlq0QnyW8BrmhGQBQXInviG7FS2sLCOhRKI2tyM0DnE9/zQNTx2gV1d5qsyrp27ui98NcTyCgR8EJInhpH5jrxDx7zFxD5ER1SzaJh4IdM12d82IATjmleGDCay5zK9VrTuzwNG2n4MVQdU4dE4SXLQ/M+3TDzieaGY6CgEDW+lFafTAshXs2UdeBU56GqA6ueGDO13TLKc+eMrNpyKFGqK29KK/9AMbMHcjNqtRIFwCgkkltVi74r3lgam98AOBUcelXyH1PbZ7P2OvIxr+qiXO8jobeYXCCD4xRFJZ+AuE1WslNfuSBm1+dvp3++sgtc+Pm4fzdbgT39kDRIhD3n0FxeQ4VYwbUXgQvRSGH+6C2xMD7JABAbn4GbiUOqf6JS+EXJw0PDAA8444LSmy5sHRRBU4juLdnM/PuAwh1H9iWNWMU+YUZlFLjENXBVP7O5Oj9NQ9c/9L1bPbq8wcB4bfC0kXFyhyC2n4QUigMAuIBK5k1FJam4JSmIQYG13le6Ot8D05NGABCJ6/M5a+90GYVW66bxkS/NTsFjtchBqMgvAxqF2EX58BcA4RIkMPHfqSh709oT8La6tT80AePX04DeCT73chRt2R96JaX++18wk/dJOEEnYlKT15Q6n/mRPntumfGf69l7PprCg19ewPAYe/d5L2xe+wK/5f4B2vSh+yy6hihAAAAAElFTkSuQmCC","contentType":"image/png","width":16,"height":16,"angle":0,"xoffset":0,"yoffset":0},"value":"Assigned","label":"Assigned","description":""},{"symbol":{"type":"esriPMS","url":"5dead99b3b7fb4f75587490a73cd591d","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAABD9JREFUOI211X9M1GUcwPH319M7Tk4IA+I8fnrghYf8PgEZyY/TwCTwR5SzZuZmrh/qNDGU1towldI/WjG1mNV0qZsCgoGKmCYdiODBPE8CFJADBIzEoxPruv5o3rx5olvr89ez58fr2fP5PHueifxPMXG8warG3arOoYFtpoH+xJ7bgx7meyMiNxe3vxRePoP+3j5nPL39tmRHrOl7avh8x3euV1oNlbuO7026MdqKZIKEeIUWX085v43cmXhYf8DPaht7M/SZmBXfnN56bJW24BVBEGzjwqUthdPLz5/SlxgOTkmQzyM3Zz3PB09HLJ5kn3PPsp4rra3sq/xB2HFy2xLTUL+ptKloZnb0O787hc+1fjml/MKF5lLjIdlGbR5Z2lREItEjJ3KRSoiNDCd8ZigHjpdRXF8kB64aDPv81OrV1kfglrau6lLjIVnuvC1kzdcCYLFYqG3UozNcom/4Fv5eviSGxxIXEYFYPImVS5YAUFxfJFd4+hwGljrAZU2F8TuPfjU71T+ThWkpAJh6b7G1eCdtI3r75s23ofzaEWafSyV/1fs86+HO6y9nUdfWSFl91eLS5j3y7Ig1fXb4Zu/gjoGxLpZnfIRIJMJsHiXv6wI6zAZn9eXirRoKimHn2s2IxZNYnbGMdQfXC0MD6Z8CK+1wR29XtK80mJCgAADO1tU/Fn0Yr29OJ0kTS5hKhUiQ0D3Qn+aQiqt9v8oSlAn2Yp1sPDcu+iBqWy6RpInFRSohXp6MabDfywHuGTUKKbI5ANhsNi4P/fxUcPdgj7091c2dnqF/02uHp0kDbWbLHwKAIAiEesRgHG58Iiz3eM7eHhkdRebi5njdQuVhloaOhsk22xsIgsD8yFSMZ58MJ6hjAbh//0/qTNUsnrVs2AGerggy/Nh+VNPZbSIowBdtwhwO1Mq5fd/pUwBAiFskiTGRAFxrv87Y32MovH1qHeBAH+9PJBMkFYerK9j81ttM9XDns5UFbNqf7xRXytRsW7UZqVSK1Wrl+6pjBLmqCPT03uoAZ2tyT3xesrZtT+0XIXG6KFLmxKEKDuLbD4qo1v3CKX0NxuFGojyTeDFmLinxcchkrgCUVdeg6zvNxrTc8+kxG1odYICwYFXaPFNme35JnriA7SQnzGaqhzs5CzLIWZCBzWZDEAT7fKvVSsWZs+yq3s4i9fK76hnqBQ/GHOD0We/eLL+8Oxn4Kb8kT5xpzOFV7UIC/RUIgmBHrVYrbTe6OFhZRk13Odmhr5kTYyIiX1CuGHUKA2RGbdBVNO9RKhVBNft1e0PKrx1BKVOjUWqQSSdzx3wXXYeOHks73pIA1iVvuhgeEqCdq3rv7sOO04d+YcSaHmBGaUPhS539Ax9fN91Q17frpL2WTsHXNdQW5RdtXjptUZPfNK8Ps6Jz65wZ435N2ZrcE8CJh/sM6DmJ/jErnhL+L/EPMtmTAUgU3FAAAAAASUVORK5CYII=","contentType":"image/png","width":16,"height":16,"angle":0,"xoffset":0,"yoffset":0},"value":"Closed","label":"Closed","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" : "STATUS", "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" : "REQUESTID", "type" : "esriFieldTypeString", "alias" : "Service Request ID", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "REQUESTTYPE", "type" : "esriFieldTypeString", "alias" : "Problem", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ServiceRequestType", "codedValues" : [ { "name" : "Abandoned Motor Vehicle", "code" : "Abandoned Motor Vehicle" }, { "name" : "Animal - Abuse", "code" : "Animal - Abuse" }, { "name" : "Animal - Dangerous", "code" : "Animal - Dangerous" }, { "name" : "Animal - Dead", "code" : "Animal - Dead" }, { "name" : "Animal - Found", "code" : "Animal - Found" }, { "name" : "Animal - Loose", "code" : "Animal - Loose" }, { "name" : "Animal - Lost", "code" : "Animal - Lost" }, { "name" : "Auto Theft", "code" : "Auto Theft" }, { "name" : "Auto Vandalism", "code" : "Auto Vandalism" }, { "name" : "Blight", "code" : "Blight" }, { "name" : "Bridge Impassible", "code" : "Bridge Impassible" }, { "name" : "Burglary - Non-Emergency", "code" : "Burglary - Non-Emergency" }, { "name" : "Business Closed", "code" : "Business Closed" }, { "name" : "Campus - Blinds Broken", "code" : "Campus - Blinds Broken" }, { "name" : "Campus - Cabinet Added", "code" : "Campus - Cabinet Added" }, { "name" : "Campus - Cabinet Removed", "code" : "Campus - Cabinet Removed" }, { "name" : "Campus - Ceiling Light Burnt Out", "code" : "Campus - Ceiling Light Burnt Out" }, { "name" : "Campus - Clean Carpet", "code" : "Campus - Clean Carpet" }, { "name" : "Campus - Desk Light Burnt Out", "code" : "Campus - Desk Light Burnt Out" }, { "name" : "Campus - Door Maintenance", "code" : "Campus - Door Maintenance" }, { "name" : "Campus - Keyboard Tray Added", "code" : "Campus - Keyboard Tray Added" }, { "name" : "Campus - Keyboard Tray Removed", "code" : "Campus - Keyboard Tray Removed" }, { "name" : "Campus - Lock Maintenance", "code" : "Campus - Lock Maintenance" }, { "name" : "Campus - Standard Facity Requests", "code" : "Campus - Standard Facity Requests" }, { "name" : "Campus - Temperature Too Cold", "code" : "Campus - Temperature Too Cold" }, { "name" : "Campus - Temperature Too Hot", "code" : "Campus - Temperature Too Hot" }, { "name" : "Campus - Whiteboard Replacement", "code" : "Campus - Whiteboard Replacement" }, { "name" : "Car Alarm", "code" : "Car Alarm" }, { "name" : "Civil Unrest or Riot", "code" : "Civil Unrest or Riot" }, { "name" : "Crime - Anonymous Tip", "code" : "Crime - Anonymous Tip" }, { "name" : "Curfew Violation", "code" : "Curfew Violation" }, { "name" : "Damaged Structure", "code" : "Damaged Structure" }, { "name" : "Debris on Road", "code" : "Debris on Road" }, { "name" : "Downed Power Line", "code" : "Downed Power Line" }, { "name" : "Drag Racing", "code" : "Drag Racing" }, { "name" : "Drunk - Public Intoxication", "code" : "Drunk - Public Intoxication" }, { "name" : "Fighting - Assault", "code" : "Fighting - Assault" }, { "name" : "Fire Alarm", "code" : "Fire Alarm" }, { "name" : "Fire Hydrant Leak", "code" : "Fire Hydrant Leak" }, { "name" : "Found Property", "code" : "Found Property" }, { "name" : "Gas Leak", "code" : "Gas Leak" }, { "name" : "Gas Station Closed", "code" : "Gas Station Closed" }, { "name" : "Graffiti", "code" : "Graffiti" }, { "name" : "Harassment", "code" : "Harassment" }, { "name" : "Hit and Run - No Injuries", "code" : "Hit and Run - No Injuries" }, { "name" : "Illegal Drug - Narcotic Production", "code" : "Illegal Drug - Narcotic Production" }, { "name" : "Illegal Drug - Narcotic Sale", "code" : "Illegal Drug - Narcotic Sale" }, { "name" : "Illegal Drug - Narcotic Use", "code" : "Illegal Drug - Narcotic Use" }, { "name" : "Illegal Dumping", "code" : "Illegal Dumping" }, { "name" : "Illegal Parking", "code" : "Illegal Parking" }, { "name" : "Illegal Sign", "code" : "Illegal Sign" }, { "name" : "Illegal Storage of RV", "code" : "Illegal Storage of RV" }, { "name" : "Illegal Sump Pump Discharge", "code" : "Illegal Sump Pump Discharge" }, { "name" : "Inoperable Vehicle", "code" : "Inoperable Vehicle" }, { "name" : "Insect Problem", "code" : "Insect Problem" }, { "name" : "Intimidation - Bullying", "code" : "Intimidation - Bullying" }, { "name" : "Liquor Law Violation", "code" : "Liquor Law Violation" }, { "name" : "Loitering", "code" : "Loitering" }, { "name" : "Looting", "code" : "Looting" }, { "name" : "Loud Music - Noise", "code" : "Loud Music - Noise" }, { "name" : "Missing or Stolen Property", "code" : "Missing or Stolen Property" }, { "name" : "Pothole", "code" : "Pothole" }, { "name" : "Power Outage", "code" : "Power Outage" }, { "name" : "Property Damage - Vandalism", "code" : "Property Damage - Vandalism" }, { "name" : "Security Alarm", "code" : "Security Alarm" }, { "name" : "Sewer Odor", "code" : "Sewer Odor" }, { "name" : "Sewer Overflow", "code" : "Sewer Overflow" }, { "name" : "Shoplift", "code" : "Shoplift" }, { "name" : "Sidewalk Damage", "code" : "Sidewalk Damage" }, { "name" : "Smoke Over Road", "code" : "Smoke Over Road" }, { "name" : "Snow Complaint", "code" : "Snow Complaint" }, { "name" : "Soliciting", "code" : "Soliciting" }, { "name" : "Stolen Check or Credit Card", "code" : "Stolen Check or Credit Card" }, { "name" : "Storm Debris Pick Up", "code" : "Storm Debris Pick Up" }, { "name" : "Storm Drain Clog", "code" : "Storm Drain Clog" }, { "name" : "Street Light Damage", "code" : "Street Light Damage" }, { "name" : "Street Sign Damage", "code" : "Street Sign Damage" }, { "name" : "Suspicious Activity", "code" : "Suspicious Activity" }, { "name" : "Tall Grass - Weeds", "code" : "Tall Grass - Weeds" }, { "name" : "Telephone Cellular Outage", "code" : "Telephone Cellular Outage" }, { "name" : "Telephone Landline Outage", "code" : "Telephone Landline Outage" }, { "name" : "Theft", "code" : "Theft" }, { "name" : "Theft from Vehicle", "code" : "Theft from Vehicle" }, { "name" : "Trash Pick Up", "code" : "Trash Pick Up" }, { "name" : "Trespassing", "code" : "Trespassing" }, { "name" : "Underage Drinking", "code" : "Underage Drinking" }, { "name" : "Unsafe Tree", "code" : "Unsafe Tree" }, { "name" : "Unusual Behavior", "code" : "Unusual Behavior" }, { "name" : "Use of Tobacco", "code" : "Use of Tobacco" }, { "name" : "Vandalism - Excluding Graffiti", "code" : "Vandalism - Excluding Graffiti" }, { "name" : "Violent Threat", "code" : "Violent Threat" }, { "name" : "Water Leak", "code" : "Water Leak" }, { "name" : "Water over Road", "code" : "Water over Road" }, { "name" : "Water Pressure", "code" : "Water Pressure" }, { "name" : "Water Quality - Cloudy Water", "code" : "Water Quality - Cloudy Water" }, { "name" : "Water Quality - Odor", "code" : "Water Quality - Odor" }, { "name" : "Water Quality - Taste", "code" : "Water Quality - Taste" }, { "name" : "Weapon - Non-Emergency", "code" : "Weapon - Non-Emergency" }, { "name" : "Wild Fire", "code" : "Wild Fire" }, { "name" : "Other", "code" : "Other" } ] }, "defaultValue" : null }, { "name" : "COMMENTS", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NAME", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PHONE", "type" : "esriFieldTypeString", "alias" : "Phone Number", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EMAIL", "type" : "esriFieldTypeString", "alias" : "Email Address", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "REQUESTDATE", "type" : "esriFieldTypeDate", "alias" : "Date Submitted", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "STATUS", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ServiceRequestStatus", "codedValues" : [ { "name" : "Unassigned", "code" : "Unassigned" }, { "name" : "Assigned", "code" : "Assigned" }, { "name" : "Closed", "code" : "Closed" } ] }, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "BUILDING", "type" : "esriFieldTypeString", "alias" : "Building Name", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FLOOR", "type" : "esriFieldTypeString", "alias" : "Floor Number", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__ServiceR__F4B70D85F9250A6C", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_3211.ServiceRequestTest_Service_Requests_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : "Closed", "name" : "Closed", "domains" : { "REQUESTTYPE" : {"type" : "inherited"}, "STATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Closed", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "STATUS" : "Closed", "FLOOR" : null, "REQUESTID" : null, "REQUESTTYPE" : null, "COMMENTS" : null, "NAME" : null, "PHONE" : null, "EMAIL" : null, "REQUESTDATE" : null, "BUILDING" : null } } } ] }, { "id" : "Assigned", "name" : "Assigned", "domains" : { "REQUESTTYPE" : {"type" : "inherited"}, "STATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Assigned", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "STATUS" : "Assigned", "FLOOR" : null, "REQUESTID" : null, "REQUESTTYPE" : null, "COMMENTS" : null, "NAME" : null, "PHONE" : null, "EMAIL" : null, "REQUESTDATE" : null, "BUILDING" : null } } } ] }, { "id" : "Unassigned", "name" : "Unassigned", "domains" : { "REQUESTTYPE" : {"type" : "inherited"}, "STATUS" : {"type" : "inherited"} }, "templates" : [ { "name" : "Unassigned", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "STATUS" : "Unassigned", "FLOOR" : null, "REQUESTID" : null, "REQUESTTYPE" : null, "COMMENTS" : null, "NAME" : null, "PHONE" : null, "EMAIL" : null, "REQUESTDATE" : null, "BUILDING" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "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" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ], "tables" : [ { "currentVersion" : 12, "id" : 1, "name" : "ServiceRequestComment", "type" : "Table", "serviceItemId" : "435de14059494304a1c7a08bd4f0898b", "cacheMaxAge" : 30, "displayField" : "REQUESTID", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "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" : true, "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" : "GlobalID", "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" : "REQUESTID", "type" : "esriFieldTypeString", "alias" : "Service Request ID", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COMMENTS", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUBMITDT", "type" : "esriFieldTypeDate", "alias" : "Date Submitted", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "RANK", "type" : "esriFieldTypeInteger", "alias" : "Importance", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "range", "name" : "ServiceRequestRanking", "range" : [ 1, 5 ] }, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__ServiceR__F4B70D850A23D762", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "ServiceRequestComment", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "RANK" : null, "REQUESTID" : null, "COMMENTS" : null, "SUBMITDT" : 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" } ] }