{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Service Requests", "type": "Feature Layer", "description": "A request for service or incident reported by the general public or other interested party", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkt": "PROJCS[\"NAD_1983_HARN_StatePlane_Illinois_East_FIPS_1201\",GEOGCS[\"GCS_North_American_1983_HARN\",DATUM[\"D_North_American_1983_HARN\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",984250.0],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",-88.33333333333333],PARAMETER[\"Scale_Factor\",0.999975],PARAMETER[\"Latitude_Of_Origin\",36.66666666666666],UNIT[\"Foot_US\",0.3048006096012192]]", "xyTolerance": 0.00328083333333333, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.00609601219, "falseZ": 0, "zUnits": 400000, "falseM": 0, "mUnits": 100000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "status", "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "fe8935d442e12e0ae0af7ee2396c13da", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAD5klEQVRIieXVX2hTdxTA8e/v5ja3SZqmI1mymj9o6EstUoWCmw+O6Zii2IeKmwyG0paxdtT1RWdffPClMFCKVcQX6x8QWdmQPqiMKVOGbChYp9U9tGmbNv1zm7imzZImzb13D62lrWna4fBl5/Hew/lwzu/H78i8pZD/n5ABQpXl94XX+zmStAFdtwoY1hOJn0Us9qMbEm8EGSBUr/er8USiVY/HHQwOLk/5Qshyh+rxdGYika99EPvX0BjYJtat+0WLRKqE1Ypt/34Kt23D5PUiFAUtFiPz+DGp27el2b6+z0w2W7UqSZ+4p6d/XTPUA2bh8fyRHRkJFm7fjqO5GamkZEmO5HBQEAxiq6khefMmU+3tFk3X76l2+4e5sJyQKxDo1MLhoHXfPhzNzSAERjpN6s4dZnt6MNJpTH4/lh07kP1+rHv3IgcCvDx6VNJ0/adh8C8f42vQuM1WqQ0NVRds3IjjyBEQgszTp0yePIkWW3oEiatXKTp4EHtdHeZNmyhuaiJ+6pTF7PWeIxI5mBcSLlcbg4MUNzSAycRsKMTLY8cw0unXW9d1EteuAWCvr8e6Zw/JGzfIDg4eUKF+8W1cAhlgGlPVD+RAAHNFBQBT7e25kcWdXb+OZdcuZL8fy+7dTJ07JxlOZw2x2JWc0Bj4jVRKMW/eDIAWjZJ58iQv8qqz1N272A8dwrxlCwBSUdHHK0ICPAZgcrnmoOHh1ZH50IaGADA5nQAY4Fv8fwmUhRkJFkYlFGXN0KvchTFLUnJFCBgGyM53IgeDCEVZ9YwACubPVItE5j7oemhFyAexMZcrmn70yGVkswhFwVpdzd+dnXkRk9OJZedOAGYePJhzRkau5esIqbj4+2w02pjs6sJWU4O9tpbMs2fMvniRExGKQsmJEwhFQZ+cJHnrFpLDEffE47/nhQiFvhU2W13i0iVF2boV2evFefo00xcvkuzqWjJGc2UlxU1NFASDYBjE29owkkmk0tLjIh438kJuSIy73V9qAwOX/2pp4Z3WVmSvl+KGBuy1tWRDobknyOdbuJ1oGvEzZ5i5fx+5tPThu6OjF5bXzfnWefr7r6hlZeXZvr7jsYYGig4fxlpdjVAUCsrLl+RmenqYOn+e2efPMbndffro6EcCjOU1V1wT7t7eFnX9+j+1iYkLU2fPKtMdHShVVcg+39yaiEbJdHeTDYdBCEyBQFc0HD5QAZlc9fIuPvfAwGUVfhBlZd9p8finM/fuORf/FxZLRt6w4TdU9Rt3ONydr9aqq9wNCXp7G4HGYXACPhkKDRh/L5UaEv392mo11gQtjvkds+K6/s+gN4m3Bv0DZEOGMIN1/K4AAAAASUVORK5CYII=", "contentType": "image/png", "width": 19, "height": 19, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Unassigned", "label": "Unassigned" }, { "symbol": { "type": "esriPMS", "url": "3e9b5323e83ce8b416b277e961dfe8ad", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAD2ElEQVRIieWV3U9bdRjHP7/Tc1pOu7ZASwsKq0DUEGdcFpJpvHBuhoRodmEcGs1e4tQYWOKl8y8w8cqLcbEYpuDLBVMv1ARdjE6jUeeSzRecGgEZVdrTF2hLX8+bF4BS1hZ0yW58Ls/v+3s++T6/5zyPzA0K+f8Jsm2Edka+W8gtjyPoBtstkKKWnv9YlPLvhkZYuS6QbSO08ZZn42cqL1p63o+e2Cw5LGTHq9q4/2wllx7pPEHqX4NiE3gS463nzVK6XziceG7aS1PL7TjUVoSkYFZyVDJzFLXLkp6PP+pwuQ5qY9JA6Hjxi22Dpidxirz/e6Oc7mkK9uHvfQhJdldpJMWN4gnj6dhLIX6J7NyUahrGZ9qYel8tWE1QsBg8a5aTPe72fvy9DwJgWzrFxI/ouQVsS8fRFEBtuxNZDeBu34PsDpKefl0yLetc9BRdm8t4DSg+ptxlFlMHFW8n/p5BACrZqyz/+jZmOVelXVn4nB2d9+KNHMDp24mvZ5DMb++rTm/rKKQfawgSSvPL6Al83QMgJPR8nPT0G9iWXsO7zUp0tUreyAHc4T0UFi9gFJKHtFGe2tiNVSB7Ekcsk7lHVoM4vV0AZGen6kA2OIt+iRrajawGUEO7yc59JNlNnochP1ETFEvRZYuKy+m/BWC1s7LzDSHrzoqJH/Du3IfT3w2ApHgeqAsSEmHbBofTuwoq1v0trgmztKpdv2tjdW48rwIZNiUJsC1jDaxsG7Su/afMolAXhEEUGYw1J7InjJCULd8IQFl7U7OYXv80WxfUeYJUbMybLC/PBG3bREgy7vZ+8n9+1RDicHlR23YBUFr6BQCrvPxWfUeA5FQnjXxuuBC7iKdjL97Ifiq5q+i5P2pChKTQfNsjCEnBMgoU4peQFE8m/GT+G55uACKrPS+cruMr8+ddruZbkdVWAruOkZv/hELsYlUZnb4Ivp5BFE8YgMzMB9hmBcnlOSlE3m7oKDTCSvw1/zNmSRtfuvImLX1PIKut+LoH8Eb2Y+TjqyNIDfzdYdgWmdkpSskryK7mb9sOL53mSHXemrMufEyb0CY6+ozC4snUd6+wI7IPd3s/QpJRvDdXaSu5BbJz59BzURwu/4zlWL5fCOzNOeuuidCRxRe08bafTT13Ojv7oSs3/ymu5l5kNYCQ5LU18TtGMQkIHGrwvaSaPHTHEJVa+RouvtDRxLg2yjvC1/6SqReGSqmfAhvPheysyGrb15QLz4WOJi83yrXlKl8djLFhYDh6igAynbKgybaIt/sqC2IoYW6VY1ugjbG2Y7Y/l/4r6HrihoH+ApWLixM2Kp40AAAAAElFTkSuQmCC", "contentType": "image/png", "width": 19, "height": 19, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Assigned", "label": "Assigned" }, { "symbol": { "type": "esriPMS", "url": "35233f08025e48c37d8ed4f69e969e8c", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAEWklEQVRIieXWa1CUZRTA8f/LsrxACKILSMBSUIAgII3I4IBIOIIgonjJmi5KaoOKgWKNTWPkNJnjJQXFwRrwUqZgIgZ4SUVgwgANuV8SlVve1hQkYIVl+wDMuAiL5oxfOp/Pc35zzvM87/Pq8oJC9/8JpaYukFQZ6Cy5df/2/A5lh2WPSiUa6BncHTPKpFhuYrE1akbyX88F5eTE6Z6+X7pnV1Xe4lv3bw/OdQR89HT1Ypam+Ja52LkuivFLrH5mKCkv2nJPRfqVK/Wl5oaiIfN95+HrMgUrmRX6UhFF2z3+uFpCdvEp8iry3cpulFfEZS6KjJt1eO9TQ0mXPjXJzE+vq22uM5rmNpW14dGMNhqtkWPykgn2lnbM8wknqyibHekJOkfzjyV9mfWW8EXIkaSnggrL8gtrm+uM5niHsiY8GkEQ6OpWcq7kHOU3Kul6pERubsN0jzeRm9kQ6hWCrbmcmKR1ZBWdTvw2d0Xe4DE+AW06+e7b+8/96Ohi60z03NUIgkDp9XLiDm5E0XZPI/fA2YO8M20Ry2Z+iNurrsTMjWJz2jadymvlhwF3rVBVU93XvWo1q0IjkehIqL95jdi9n9DVrXyic1VvLwfPHwJgefBSQiYH8/Nvx/m9ptAt4UzEy4+fRg0oPjtK3F+wz9bWXM6EV1wA2Hk8YUjk8Th04TBBnoHIzWwI9gwiPmM3ja23Y4E1Q0Jt6nteDzsfCgEe/gDcbVVQUl+qFRno7GzJeSJmfMAbr3kA8PfDVs/HczSgLlX36wAyYxkALYrmEZGBaLzTRN/asQB0Puo0GxaSCpJ2AGX/qPSk4lND+np9uQNj1pVINOatARkbjykDaO7vxN7SDn2pOOIeAbj272mLogUAQ9Hw5rBQjF9i9fTNcmVx7SWxR9WDKBUJmzKbI7lpWhGZ8VgCPAIAyK8sAGCcqcXRYSEAJxuHi2cun52WfvEEC3zCWRYUQfn1Cqoah/6M6UtF4t7bgL5U5EH7A7KLTjLO1KLHubM3RSs03srh/aKa4oaU0/sEbycvrGVWxEdu57tTyWQUnNAYo4e9Ox/PicLe0g61Ws22YzvoUHYQNClw38LwNJVWaKVfYtOGjIXbj+SnrV33/Xq2LN2EtcyKVaGRLAuKoP7mNR51K7GSWWNm0nc6Vb0qdqTHc6Esj4n27ncCTd0jvyEdrRDAxrDU2LWpIU6ZRdkhy3dGsiRwMXO9ZyNKRZzl4zVyK25UsuuXPVQ2VOFo7dAeMMF/ov/UuJ7BNYd9JrYtzJr1ecb8rWcu/7om/vguIflUCp6Ok7CWWSNKRRRtCkquXqHhTiM6goCPy5RaLzdfr48mbW4dqp7Wh++rsKOxu3NX7KxuqTtQ01TnnVOaq3GxRhmMUns5Tm5wtnH4bP3MH35KpmDYWiM+5Sv9EpsAf4CtOcud/mlvc+9Wq4z0JdI/jYWxhauDE5RQNFKZZ/s5ifXfWwPUPMua/wQ9T7ww6F+g16FDhfcW+AAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 19, "height": 19, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Closed", "label": "Closed" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 242, 252, 204, 255 ], "toColor": [ 242, 252, 204, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 188, 179, 252, 255 ], "toColor": [ 188, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 182, 188, 255 ], "toColor": [ 252, 182, 188, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 230, 252, 255 ], "toColor": [ 179, 230, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 215, 251, 255 ], "toColor": [ 252, 215, 251, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 252, 224, 255 ], "toColor": [ 179, 252, 224, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 217, 197, 255 ], "toColor": [ 252, 217, 197, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 195, 252, 179, 255 ], "toColor": [ 195, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 242, 182, 252, 255 ], "toColor": [ 242, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 212, 217, 252, 255 ], "toColor": [ 212, 217, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 182, 218, 255 ], "toColor": [ 252, 182, 218, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 212, 252, 250, 255 ], "toColor": [ 212, 252, 250, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 210, 219, 255 ], "toColor": [ 252, 210, 219, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.4842597721444273E7, "ymin": -7472552.968101165, "xmax": -4823845.222955815, "ymax": 3.024097195838615E7, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 1.4892314192838538E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "attachmentid", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "att_name", "isEnabled": true }, { "name": "contentType", "fieldName": "content_type", "isEnabled": true }, { "name": "size", "fieldName": "data_size", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "attachmentid", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "att_name", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "content_type", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "data_size", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "requestid", "type": "esriFieldTypeString", "alias": "Service Request ID", "length": 25, "domain": null }, { "name": "requesttype", "type": "esriFieldTypeString", "alias": "Problem", "length": 100, "domain": { "type": "codedValue", "name": "ServiceRequestType", "description": "The type of service request submitted by general public", "codedValues": [ { "name": "Blight", "code": "Blight" }, { "name": "Bridge Impassible", "code": "Bridge Impassible" }, { "name": "Business Closed", "code": "Business Closed" }, { "name": "Civil Unrest or Riot", "code": "Civil Unrest or Riot" }, { "name": "Damaged Structure", "code": "Damaged Structure" }, { "name": "Debris on Road", "code": "Debris on Road" }, { "name": "Downed Power Line", "code": "Downed Power Line" }, { "name": "Excessive Noise", "code": "Excessive Noise" }, { "name": "Fire Hydrant Leak", "code": "Fire Hydrant Leak" }, { "name": "Gas Leak", "code": "Gas Leak" }, { "name": "Gas Station Closed", "code": "Gas Station Closed" }, { "name": "Graffiti", "code": "Graffiti" }, { "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": "Looting", "code": "Looting" }, { "name": "Pothole", "code": "Pothole" }, { "name": "Power Outage", "code": "Power Outage" }, { "name": "Public Facility Damage", "code": "Public Facility Damage" }, { "name": "School Closed", "code": "School Closed" }, { "name": "Sewer Odor", "code": "Sewer Odor" }, { "name": "Sewer Overflow", "code": "Sewer Overflow" }, { "name": "Sidewalk Damage", "code": "Sidewalk Damage" }, { "name": "Smoke over Road", "code": "Smoke over Road" }, { "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": "Tall Grass/Weeds", "code": "Tall Grass/Weeds" }, { "name": "Telephone Cellular Outage", "code": "Telephone Cellular Outage" }, { "name": "Telephone Landline Outage", "code": "Telephone Landline Outage" }, { "name": "Trash Pick Up", "code": "Trash Pick Up" }, { "name": "Unsafe Tree", "code": "Unsafe Tree" }, { "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": "Wild Fire", "code": "Wild Fire" }, { "name": "Other", "code": "Other" }, { "name": "Standard Facity Requests", "code": "Standard Facity Requests" }, { "name": "Temperature Too Hot", "code": "Temperature Too Hot" }, { "name": "Temperature Too Cold", "code": "Temperature Too Cold" }, { "name": "Lock Maintenance", "code": "Lock Maintenance" }, { "name": "Door Maintenance", "code": "Door Maintenance" }, { "name": "Desk Light Burnt Out", "code": "Desk Light Burnt Out" }, { "name": "Ceiling Light Burnt Out", "code": "Ceiling Light Burnt Out" }, { "name": "Keyboard Tray Added", "code": "Keyboard Tray Added" }, { "name": "Keyboard Tray Removed", "code": "Keyboard Tray Removed" }, { "name": "Blinds Broken", "code": "Blinds Broken" }, { "name": "Cabinet Removed", "code": "Cabinet Removed" }, { "name": "Cabinet Added", "code": "Cabinet Added" }, { "name": "Clean Carpet", "code": "Clean Carpet" }, { "name": "Insect Problem", "code": "Insect Problem" }, { "name": "Whiteboard Replacement", "code": "Whiteboard Replacement" }, { "name": "Snow Complaint", "code": "Snow Complaint" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "name", "type": "esriFieldTypeString", "alias": "Name", "length": 150, "domain": null }, { "name": "phone", "type": "esriFieldTypeString", "alias": "Phone Number", "length": 12, "domain": null }, { "name": "email", "type": "esriFieldTypeString", "alias": "Email Address", "length": 100, "domain": null }, { "name": "requestdate", "type": "esriFieldTypeDate", "alias": "Date Submitted", "length": 8, "domain": null }, { "name": "status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": { "type": "codedValue", "name": "ServiceRequestStatus", "description": "The status of the resolution of a service request", "codedValues": [ { "name": "Unassigned", "code": "Unassigned" }, { "name": "Assigned", "code": "Assigned" }, { "name": "Closed", "code": "Closed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "building", "type": "esriFieldTypeString", "alias": "Building Name", "length": 25, "domain": null }, { "name": "floor", "type": "esriFieldTypeString", "alias": "Floor Number", "length": 5, "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "i136requestid", "fields": "requestid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "a32_ix1", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "ss6.gdb.ServiceRequestComment", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "requestid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "ServiceRequestComment", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "requestid", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "requestid", "type": "esriFieldTypeString", "alias": "Service Request ID", "length": 25, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "submitdt", "type": "esriFieldTypeDate", "alias": "Date Submitted", "length": 8, "domain": null }, { "name": "rank", "type": "esriFieldTypeInteger", "alias": "Importance", "domain": { "type": "range", "name": "ServiceRequestRanking", "description": "A factor assigned to unassigned service requests indicating importance", "range": [ 1, 5 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "i112requestid", "fields": "requestid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r52_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_52", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "ss6.gdb.ServiceRequest", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "requestid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }