{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Hydrant Inspection", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "COLOR", "defaultSymbol": { "type": "esriPMS", "url": "56ed4df0cbf0c73601e4f36e027e37c2", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABOUlEQVRIic2W23GDMBBFz87QREgD1jcpI04ZpgxDGaYM4zKib1GB29h88IjMQ5acYSb7J4T2aO/dZcjYObJ/BVDHSQzNbgDgqA5SINEA7chRPoE32AEwJAcoos8kAeA4sRK8iAJ48oxxIlKmuAoek0OCTBlMN/ymNzCO6dDAtgVKMdgMQA7cgVwdF/ry/xKNGMpx8SCRGEp1WODyYvJybv7CAzE0A6QlXjIL1GJo5xurJovBascHypXnht4QykHmRWx2kRy4q6MGrk8A1VbyIGCImHYs6CV6CTDv/7UIDt0mQB0FywrK4ZnfyoV25Mke4H17mHWJOm743vSTvlpFCDDK0yDU/g3F0GrHuzf9mzKtAjx5FoMzQX6nvwLOWzKFKvhaG5wFyFCpo0UpIBIgBkug9VLe3/2v4gdQSWfcShqcvAAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 18, "height": 18, "angle": 0, "xoffset": 0, "yoffset": 0 }, "defaultLabel": "", "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "6f352d196f5f368df2b5a17e8d78cf37", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABYAAAAXCAYAAAAP6L+eAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABh0lEQVQ4jdXTyytEYRjH8e97ZjCDccllRJSipFggiY0NSS6FUi5LSVmwsbBAWLKwslB2lspGUtT4A0aampnsFOOSGndjmJljoSk65z1uM8VveZ73/Zynp+c1E6eY4wqrqtoOTMfIHBZCON93XC076fA+4zp+4Tagkpeu0FyRRFGWSXY8H3AajuLiJkLrgp/9o5cP300KTHakMtttk941hKfW7zQoQDgCcxv39NRaqCxM+B7s8D6z6w4a/ZfVvQCjTYISu5aRwgPL1/iuwobw0vYDGcmCmS7tSKRwbprC+U2YcEQO2yyCVIuiW5PC+/PZlE1ccngWksKz3TbGWlK+B/82unDboh+AE7/xjFccj+y4gww2WOmts34Obx4Yb0M0Hl8Ijy9EXUni1zqORXThzioLALueIPdPqvRyeYGZ4hwTpXbt89aFN8YzAT7diqHG5D+yFf8T7l++Jj9TIS9du0rRbLmC5KYp9NVbNbUofAo43xfWRjJ+1uqb9QYLIZxAzU8lvcRtxq/iA2njVnVMAgAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 16, "height": 17, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Blue", "label": "Blue" }, { "symbol": { "type": "esriPMS", "url": "534a7a46c521135770d9bc4517d0391e", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABYAAAAXCAYAAAAP6L+eAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABPElEQVQ4jdXUvWrCUBTA8f9FRwUnkQyCoCAOLu3gEziIxUUQ/Bili4Ozg5X4BM6Cm7uLuBjICySDg+CuRVdxlThcKBVzU2Ob0h4IB3Lu/eXkcJMwAUU4UNhxnBfg7YfMVyGE9bnjJ+VS04TVCo5HSCSgWIRkUrVaAyzvURwOUCqBbV/fD4Wg1wNdV271hvv9WxTgfIbhEKpVyOd9wqYJhuH5XCYT6HQgnfYBN5uw23nDoxHEYjAY+IDjcdjv5WurIhqFSMS1pIZtG7JZ2GzUsK5Dt+sT/ma4w+WyzNut9+7xGJZLaLWgVrsDns/va2u9llehcFP65VFUKjIbBpxO6t25HKRSkMncCc9mMn91Ktrtv3Iq/ifcaICmyf+vKhYL+enX60r4HbCuKtPpA31+WBIWQljA86OSWwQ24wsL+0q675H9BgAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 16, "height": 17, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Red", "label": "Red" }, { "symbol": { "type": "esriPMS", "url": "a6b5310e86ce1be2f73f7a24dc5b09ff", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABYAAAAXCAYAAAAP6L+eAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABWklEQVQ4jdXSP2vCUBSH4RfiZkaF0FHIILi1QyAO4ih0DbgK0i2LH6CfIASFjBIyuQkiOLgI2ZPVwUUQAv5bhIxCh0KxNTdGq9D+xnvvee7hcHI8KLlHw6/A+53MNyA47fhZ9FLTNMrlMrIss91u8X2fKIpEz59+wmcpFAp4nkelUvl2fjwecRwHy7KEtalwp9M5QwEkScI0TSaTCfP5/DpY0zR0XU/7F8Mw8DyP5XKZHe52uyiKkgq3Wi0OhwO2bWeH9/s9xWIRSZKEcBzHxHGceCeEG40Gs9mMUqkkhC3Lot/vXwf/Nomw67oAF2fcbDapVqsMh0PG4/FluF6vZ+pKVVVUVSUMw2wd3yOJ8HQ6BUDXdfL5vLB4sViwWq2y73G73Qa4uBWDweCPbMX/hHu9Huv1ms1mIyyu1WrsdjtGo5EQjoDg9MI0zdta/bS+4AB4uVVKysNm/AEO2GvTsv9AbQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 16, "height": 17, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Silver", "label": "Silver" }, { "symbol": { "type": "esriPMS", "url": "3dbf544a677b0493e6c1637b0f4d3e45", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABYAAAAXCAYAAAAP6L+eAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABNElEQVQ4jdXUvYrCQBDA8T9oKbaK2gsWFjkfIBAbkQN7O0Gu9AnMiYW1hZ2lHyDYCGLhE9iksRBBQbAIYiVoK1gsiJpsTPRy3A2EgUzmt5NlkyA+RdBv+BP4/iHzCzBuJ/6QPamqkE5DOAy7HUynsN1K4dgjbIlIBCYTUJT7++czNBqg6/JeR7het6IAgQBUqzAcwnzuEVZV0DSnZaFUglYL1msPcLcL8bgzXKnA4QC1mgd4v4doVLy2LI5HOJ3sa1JYUWC5hGRSDus6NJse4XfDFh6PRU4knJvLZchmodOBwcAFnM+7myqVEtdsZq397laMRiJrGoRC8ubFAjYbWK1cwoWCyM9ORbv9V07F/4R7PTBN8f+VRS4nPv1+Xw6bgHFbKBZfmfNqXWEDyLxM2YRve3wBbABKa6oQ57EAAAAASUVORK5CYII=", "contentType": "image/png", "width": 16, "height": 17, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Yellow", "label": "Yellow" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 226, 202, 252, 255 ], "toColor": [ 226, 202, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 252, 184, 255 ], "toColor": [ 182, 252, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 221, 194, 255 ], "toColor": [ 252, 221, 194, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 249, 252, 255 ], "toColor": [ 184, 249, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 199, 255 ], "toColor": [ 252, 179, 199, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 252, 179, 255 ], "toColor": [ 252, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 215, 252, 218, 255 ], "toColor": [ 215, 252, 218, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 250, 255 ], "toColor": [ 252, 179, 250, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 187, 217, 252, 255 ], "toColor": [ 187, 217, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 215, 226, 255 ], "toColor": [ 252, 215, 226, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 252, 212, 255 ], "toColor": [ 252, 252, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 192, 182, 255 ], "toColor": [ 252, 192, 182, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 196, 179, 252, 255 ], "toColor": [ 196, 179, 252, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2550258.403133139, "ymin": 7039395.995357648, "xmax": 2598753.5955126435, "ymax": 7156720.492663562, "spatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 8.0E-5, "mTolerance": 8.0E-5, "falseX": -123407700, "falseY": -86123500, "xyUnits": 2438.3349432932373, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "STREETNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "DATE", "type": "esriFieldTypeDate", "alias": "Today's Date", "length": 8, "domain": null }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "ROTATION", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 30, "domain": { "type": "codedValue", "name": "wHydrantManufacturer", "description": "The name of the hydrant manufacturer", "codedValues": [ { "name": "American Darling", "code": "American Darling" }, { "name": "American Standard", "code": "American Standard" }, { "name": "AVK", "code": "AVK" }, { "name": "Clow Corporation", "code": "Clow Corporation" }, { "name": "Corey", "code": "Corey" }, { "name": "Dresser", "code": "Dresser" }, { "name": "Eddy", "code": "Eddy" }, { "name": "Iowa Valve", "code": "Iowa Valve" }, { "name": "Kennedy Valve", "code": "Kennedy Valve" }, { "name": "M&H Valve", "code": "M&H Valve" }, { "name": "M&H Valve / Dresser", "code": "M&H Valve / Dresser" }, { "name": "Mueller Company", "code": "Mueller Company" }, { "name": "Other", "code": "Other" }, { "name": "Traverse City", "code": "Traverse City" }, { "name": "Unknown", "code": "Unknown" }, { "name": "US Pipe", "code": "US Pipe" }, { "name": "Waterous", "code": "Waterous" }, { "name": "Wood-Matthews", "code": "Wood-Matthews" }, { "name": "Anniston", "code": "Anniston" }, { "name": "AVF", "code": "AVF" }, { "name": "Hydrant Post", "code": "Hydrant Post" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTENANCE", "type": "esriFieldTypeString", "alias": "Maintenance Required", "length": 150, "domain": { "type": "codedValue", "name": "wHydrantMaint", "description": "Maintenance condition of a fire hydrant", "codedValues": [ { "name": "Repaint", "code": "Repaint" }, { "name": "Pressure Gage Attached", "code": "Pressure Gage Attached" }, { "name": "Trim Vegetation", "code": "Trim Vegetation" }, { "name": "Service Required", "code": "Service Required" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTSERVICE", "type": "esriFieldTypeDate", "alias": "Last Service Date", "length": 8, "domain": null }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "City of Wylie", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "NTMWD", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "City of Wylie", "code": 1 }, { "name": "NTMWD", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "PRESSURE", "type": "esriFieldTypeInteger", "alias": "Pressure", "domain": null }, { "name": "COLOR", "type": "esriFieldTypeString", "alias": "Color", "length": 50, "domain": { "type": "codedValue", "name": "wHydrantColor", "description": "Waterline color code", "codedValues": [ { "name": "Blue", "code": "Blue" }, { "name": "Red", "code": "Red" }, { "name": "Silver", "code": "Silver" }, { "name": "Yellow", "code": "Yellow" }, { "name": "White & Black", "code": "White & Black" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 50, "domain": null }, { "name": "EMPLNUM", "type": "esriFieldTypeInteger", "alias": "Employee Number", "domain": null }, { "name": "IN_SERV", "type": "esriFieldTypeString", "alias": "In Service", "length": 5, "domain": { "type": "codedValue", "name": "wHydrantYesorNo", "description": "Yes or No for Hydrant In Service", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MARKED", "type": "esriFieldTypeString", "alias": "Marked", "length": 5, "domain": { "type": "codedValue", "name": "YesNo_2", "description": "Yes or No domain", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STRNUM", "type": "esriFieldTypeInteger", "alias": "Street Number", "domain": null }, { "name": "STREETNAME", "type": "esriFieldTypeString", "alias": "Street Name", "length": 100, "domain": null }, { "name": "YEAR", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "HYDRANTID", "type": "esriFieldTypeString", "alias": "Hydrant ID", "length": 100, "domain": null }, { "name": "CALLBOX", "type": "esriFieldTypeString", "alias": "Call Box Number", "length": 100, "domain": null }, { "name": "WATERDISTRICT", "type": "esriFieldTypeString", "alias": "Water District", "length": 50, "domain": { "type": "codedValue", "name": "WaterDistrict", "description": "Used for Hydrant Inspection Water District attribute", "codedValues": [ { "name": "CITY OF WYLIE", "code": "CITY OF WYLIE" }, { "name": "CITY OF PARKER", "code": "CITY OF PARKER" }, { "name": "EAST FORK SUD", "code": "EAST FORK SUD" }, { "name": "NTMWD", "code": "NTMWD" }, { "name": "WYLIE NORTHEAST SUD", "code": "WYLIE NORTHEAST SUD" }, { "name": "GLEN KNOLL MHP", "code": "GLEN KNOLL MHP" }, { "name": "REDWOOD MHP", "code": "REDWOOD MHP" }, { "name": "SOUTHFORK MHP", "code": "SOUTHFORK MHP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Locked", "type": "esriFieldTypeString", "alias": "Locked", "length": 255, "domain": { "type": "codedValue", "name": "YesNo_2", "description": "Yes or No domain", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Crew", "type": "esriFieldTypeString", "alias": "Crew", "length": 255, "domain": { "type": "codedValue", "name": "HydrantCrews", "description": "Used for Hydrant Inspection Crew Assigner", "codedValues": [ { "name": "A1", "code": "A1" }, { "name": "A2", "code": "A2" }, { "name": "A3", "code": "A3" }, { "name": "B1", "code": "B1" }, { "name": "B2", "code": "B2" }, { "name": "B3", "code": "B3" }, { "name": "C1", "code": "C1" }, { "name": "C2", "code": "C2" }, { "name": "C3", "code": "C3" }, { "name": "A4", "code": "A4" }, { "name": "B4", "code": "B4" }, { "name": "C4", "code": "C4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Complete", "type": "esriFieldTypeString", "alias": "Complete", "length": 255, "domain": { "type": "codedValue", "name": "YesNo_2", "description": "Yes or No domain", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R519_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_519", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_519", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2066_HYDRANT", "fields": "HYDRANTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S413_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "HydrantInspectionTable", "relatedTableId": 56, "role": "esriRelRoleOrigin", "keyField": "HYDRANTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "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, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "570e2d98a0d74147a70dc4c1fa527932" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 56, "name": "HydrantInspectionTable", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "STREETNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "DATE", "type": "esriFieldTypeDate", "alias": "Today's Date", "length": 8, "domain": null }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "ROTATION", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 30, "domain": { "type": "codedValue", "name": "wHydrantManufacturer", "description": "The name of the hydrant manufacturer", "codedValues": [ { "name": "American Darling", "code": "American Darling" }, { "name": "American Standard", "code": "American Standard" }, { "name": "AVK", "code": "AVK" }, { "name": "Clow Corporation", "code": "Clow Corporation" }, { "name": "Corey", "code": "Corey" }, { "name": "Dresser", "code": "Dresser" }, { "name": "Eddy", "code": "Eddy" }, { "name": "Iowa Valve", "code": "Iowa Valve" }, { "name": "Kennedy Valve", "code": "Kennedy Valve" }, { "name": "M&H Valve", "code": "M&H Valve" }, { "name": "M&H Valve / Dresser", "code": "M&H Valve / Dresser" }, { "name": "Mueller Company", "code": "Mueller Company" }, { "name": "Other", "code": "Other" }, { "name": "Traverse City", "code": "Traverse City" }, { "name": "Unknown", "code": "Unknown" }, { "name": "US Pipe", "code": "US Pipe" }, { "name": "Waterous", "code": "Waterous" }, { "name": "Wood-Matthews", "code": "Wood-Matthews" }, { "name": "Anniston", "code": "Anniston" }, { "name": "AVF", "code": "AVF" }, { "name": "Hydrant Post", "code": "Hydrant Post" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTENANCE", "type": "esriFieldTypeString", "alias": "Maintenance Required", "length": 150, "domain": { "type": "codedValue", "name": "wHydrantMaint", "description": "Maintenance condition of a fire hydrant", "codedValues": [ { "name": "Repaint", "code": "Repaint" }, { "name": "Pressure Gage Attached", "code": "Pressure Gage Attached" }, { "name": "Trim Vegetation", "code": "Trim Vegetation" }, { "name": "Service Required", "code": "Service Required" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTSERVICE", "type": "esriFieldTypeDate", "alias": "Last Service Date", "length": 8, "domain": null }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "City of Wylie", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "NTMWD", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "City of Wylie", "code": 1 }, { "name": "NTMWD", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "PRESSURE", "type": "esriFieldTypeInteger", "alias": "Pressure", "domain": null }, { "name": "COLOR", "type": "esriFieldTypeString", "alias": "Color", "length": 50, "domain": { "type": "codedValue", "name": "wHydrantColor", "description": "Waterline color code", "codedValues": [ { "name": "Blue", "code": "Blue" }, { "name": "Red", "code": "Red" }, { "name": "Silver", "code": "Silver" }, { "name": "Yellow", "code": "Yellow" }, { "name": "White & Black", "code": "White & Black" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 50, "domain": null }, { "name": "EMPLNUM", "type": "esriFieldTypeInteger", "alias": "Employee Number", "domain": null }, { "name": "IN_SERV", "type": "esriFieldTypeString", "alias": "In Service", "length": 5, "domain": { "type": "codedValue", "name": "wHydrantYesorNo", "description": "Yes or No for Hydrant In Service", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MARKED", "type": "esriFieldTypeString", "alias": "Marked", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STRNUM", "type": "esriFieldTypeInteger", "alias": "Street Number", "domain": null }, { "name": "STREETNAME", "type": "esriFieldTypeString", "alias": "Street Name", "length": 100, "domain": null }, { "name": "YEAR", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "HYDRANTID", "type": "esriFieldTypeString", "alias": "Hydrant ID", "length": 100, "domain": null }, { "name": "CALLBOX", "type": "esriFieldTypeString", "alias": "Call Box Number", "length": 100, "domain": null }, { "name": "WATERDISTRICT", "type": "esriFieldTypeString", "alias": "Water District", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Locked", "type": "esriFieldTypeString", "alias": "Locked", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Crew", "type": "esriFieldTypeString", "alias": "Crew", "length": 255, "domain": { "type": "codedValue", "name": "HydrantCrews", "description": "Used for Hydrant Inspection Crew Assigner", "codedValues": [ { "name": "A1", "code": "A1" }, { "name": "A2", "code": "A2" }, { "name": "A3", "code": "A3" }, { "name": "B1", "code": "B1" }, { "name": "B2", "code": "B2" }, { "name": "B3", "code": "B3" }, { "name": "C1", "code": "C1" }, { "name": "C2", "code": "C2" }, { "name": "C3", "code": "C3" }, { "name": "A4", "code": "A4" }, { "name": "B4", "code": "B4" }, { "name": "C4", "code": "C4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Complete", "type": "esriFieldTypeString", "alias": "Complete", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R909_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_909", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_909", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_8252_HYDRANT", "fields": "HYDRANTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "HydrantInspection", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "HYDRANTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "570e2d98a0d74147a70dc4c1fa527932" } ] }