{ "currentVersion" : 12, "id" : 3, "name" : "System_Valve", "type" : "Feature Layer", "serviceItemId" : "43f04b04284d4004830fe8abdcdadf96", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : false, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "CREATEDDATE", "creatorField" : "CREATEDBY", "editDateField" : "LASTUPDATE", "editorField" : "LASTEDITOR" }, "editingInfo" : { "lastEditDate" : 1648574208740, "schemaLastEditDate" : 1648574208740, "dataLastEditDate" : 1648574208740 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : true, "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, "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" : 5000, "maxScale" : 0, "extent" : { "xmin" : -9504233.4902846664, "ymin" : 3848153.3001369308, "xmax" : -9502646.6343470644, "ymax" : 3849064.6510812938, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"curropen","fieldDelimiter":",","uniqueValueInfos":[{"symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"b37b1449-3a58-44a9-86f2-ac364e0414bc","imageData":"iVBORw0KGgoAAAANSUhEUgAAABwAAAAcCAYAAAByDd+UAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACgUlEQVRIie3WS2hUVwAG4G9MNNOYUZGpUCyVSoRGxFd9UUgjgijUBwpVQdyoNQii+AwqDZpFdwaRbhQMdqkLBduFTzRNKaFo2lIkqAuNxEXNVdQo3tGO4+KOdEzGmMlIUegPlwPnHu53z7n3PEr9xyn9H+yRQRgXj8c/zmQypYlEoisIgnY8edvg+JnU3WfpVSrCMASpVMpHpCv5pYV9+LFYsKya/VeoTWIHsSqMRAm6cYOSn6hpoeYLfvuVZegYCDh8Ns03mHQUNejEY3TlNBol6to32MP0yfzVmUzOCYLgUiFgyVzOPGRiM8ZkK3/A3jyN06hCE7EGEueD4ELABHl6mhesYdfPzPg9B+tPhqIeN6lIcvw0n/cHHBGw+1D2rQvNUOzBeKZioR4/Ui9wLmsuU7ZoANjLfIbNuM23x94EjmZVNUYUAcawAKujIf1AzjztBd6ickkR2Mt8ig4GJZPJqiAI2l4L/kH58LcAJrJld3f3h7n1vcCRZNLRqBSVdLaMxWL/9AlO4dEdhhUL3suWYRh29glWcu0i01YUCbajmqctXO8THMyhg0yrE334geQZjuBLWlt43ifYQNNKGg9T0SDajwpNMy7hk2g6vpJ8K016Jpu2c3gGCl0AOrAW6zlbT1vP+3nX0o00NbJkMQtO4iv962l7FltMV320rPXKa7enLSz8nlNfM28b1qAO2/O0fYiTWIdN/D0q2ilSBYGwgflHy8q2nk2lvhvLkFrMFu2BJXiAP7EfE8kc4Hgty/07DQsDYXkqte8gB+bH4w03w3DFOUa3MvgeZvF8EncbOV/OtmXcftPz+nWmqeWZMNyJnbn1J7JXIXnnj4nvH/gCdCGqQU9D3fsAAAAASUVORK5CYII=","contentType":"image/png","width":21,"height":21},"value":"0","label":"Closed"},{"symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"13a7d056-7c4c-4b25-b228-69fac4955abf","imageData":"iVBORw0KGgoAAAANSUhEUgAAABwAAAAcCAYAAAByDd+UAAAACXBIWXMAAA7EAAAOxAGVKw4bAAADCElEQVRIie3Wa0hTYRjA8f+mtemcRW2iVs5Iu5hlOEsLygq8kEk30iCkSGlERVmBmFQaFBQl0YfSqLCgDxpEJaRoFyy7SUllZqkfWuStziya1jnVtj6MSNzUzUUU9MDhged9eH+8vOe85/XmD4f3f7BfyIFwpVI53mazeavV6veCIDQBX343GBE0ixyph5XdrfiJogiAJEkoxmAJDKXWWM9RoNxTUBGi51jXcwz+WojfgixoMqhGg1wOUi+8M+LVUEW8sZ74oFnUdTwhDTAOBxyli6Wm8w1RhvMwdS586ADxM5hNv5r8tZBWAPMz4MoRZktfaJCbNIsFQXjkDugVNp+qXjMz912FsePsxdpSqCh0bC5qg+Bw2HAM2eUjqJtuCrcQiHS2UqdgoJ7drXXM2Vf9C3MlFD6wfBd0t+M3MoBLxjvoXQFHf+shb90hCA5zHeuLLtsBBfFEA6n0e5EcQN1CMjufoYhKdh/7GcHhsDgLutrZ03htCFCjJSMyE1T+wwcBZiTC3W3oAR/6fKcOoNBJWEyKZxhAgA6kDuQajWaaIAj1A4Kdjfj6qj0HFSp7NpvN2r51B1Clxma1IPMUtFrtWSaTfR8UDImk55OAhzsIvR/tWRTFt4OCWh3Nr+4TE7fcM7CjGXSxfDU+pGVQ0FvJqXsniEnZApoJw8Ms36GmFCLieGB8iHVQsKKQs/pVFN6+gN+KHJANYzdf3ofXjyFgItn9x5ydNJZJUWwrO8CZ0GiITnQPM7VB8XZIzKK6/DD1/cednqVlezm7Op8VxetZuqkEohJcW2l7K5Rkw5wlvC8/TKqzngF/TxfzSU0/QOVJA0lJBliwFpZsheTNjr2fzfC0Es7lQEImXRofIgHJLRCgNI/krGLFzoYa6WBeLCPnZcCUueCvAbmXHXrbCNfPQGA4tvR8LpXmkg5YBppzyCvGaYN0dGMxx2csUu43vRHXvKhlXEsdI3q7ISwWa+h0TGl7uaFSsKtoE21DzefSneaUgW8g5gK5feuNFfbHnfjrr4n/HvgDtp/0oZvAThwAAAAASUVORK5CYII=","contentType":"image/png","width":21,"height":21},"value":"1","label":"Opened"}]},"transparency":0}, "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" : true }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : true } ], "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" : "facilityid", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "installdate", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "locdesc", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "rotation", "type" : "esriFieldTypeDouble", "alias" : "Rotation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "diameter", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "valvetype", "type" : "esriFieldTypeString", "alias" : "Valve Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piSystemValveType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Ball", "code" : "Ball" }, { "name" : "Butterfly", "code" : "Butterfly" }, { "name" : "Cone", "code" : "Cone" }, { "name" : "Gate", "code" : "Gate" }, { "name" : "Plug", "code" : "Plug" }, { "name" : "Roundway", "code" : "Roundway" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "bypassvalve", "type" : "esriFieldTypeSmallInteger", "alias" : "Bypass Valve", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "clocktoclose", "type" : "esriFieldTypeSmallInteger", "alias" : "Clockwise To Close", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "normallyopen", "type" : "esriFieldTypeSmallInteger", "alias" : "Normally Open", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "turnstoclose", "type" : "esriFieldTypeInteger", "alias" : "Turns To Close", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "operable", "type" : "esriFieldTypeSmallInteger", "alias" : "Operable", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "hydrflag", "type" : "esriFieldTypeSmallInteger", "alias" : "Hydrant Valve", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "curropen", "type" : "esriFieldTypeSmallInteger", "alias" : "Currently Open", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "enabled", "type" : "esriFieldTypeSmallInteger", "alias" : "Enabled", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnabledDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "activeflag", "type" : "esriFieldTypeSmallInteger", "alias" : "Active Flag", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "ownedby", "type" : "esriFieldTypeSmallInteger", "alias" : "Owned By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetOwner", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "maintby", "type" : "esriFieldTypeSmallInteger", "alias" : "Managed By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetManager", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "lastupdate", "type" : "esriFieldTypeDate", "alias" : "Last Update Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "lasteditor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "workorderid", "type" : "esriFieldTypeString", "alias" : "WorkorderID", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "watertype", "type" : "esriFieldTypeString", "alias" : "WaterType", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wWaterType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Potable Water", "code" : "Potable" }, { "name" : "Raw Water", "code" : "Raw" }, { "name" : "Reclaimed Water", "code" : "Reclaimed" }, { "name" : "Salt Water", "code" : "Salt" }, { "name" : "Storm Runoff", "code" : "Storm" }, { "name" : "Treated Water", "code" : "Treated" }, { "name" : "Sewage", "code" : "Sewage" }, { "name" : "Waste Water Effluent", "code" : "Effluent" }, { "name" : "Combined Waste Water", "code" : "Combined" } ] }, "defaultValue" : null }, { "name" : "projectnumber", "type" : "esriFieldTypeString", "alias" : "ProjectNumber", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "projectname", "type" : "esriFieldTypeString", "alias" : "ProjectName", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "installedby", "type" : "esriFieldTypeString", "alias" : "InstalledBy", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "hyperlink", "type" : "esriFieldTypeString", "alias" : "Hyperlink", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "comment", "type" : "esriFieldTypeString", "alias" : "Comment", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "motorized", "type" : "esriFieldTypeSmallInteger", "alias" : "Motorized", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "percentopen", "type" : "esriFieldTypeInteger", "alias" : "PercentOpen", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "pressuresetting", "type" : "esriFieldTypeString", "alias" : "PressureSetting", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "regulationtype", "type" : "esriFieldTypeString", "alias" : "RegulationType", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainWHSystemValveRegulationType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Flow", "code" : "Flow" }, { "name" : "Pressure", "code" : "Pressure" } ] }, "defaultValue" : null }, { "name" : "connectiontype", "type" : "esriFieldTypeString", "alias" : "ConnectionType", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainConnection", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Mechanical Joint", "code" : "MJ" }, { "name" : "Restrained Joint", "code" : "RJ" }, { "name" : "Flange", "code" : "Flange" }, { "name" : "Push on", "code" : "PO" }, { "name" : "Female Iron Pipe", "code" : "FIP" }, { "name" : "Male Iron Pipe", "code" : "MIP" }, { "name" : "Compression", "code" : "Compression" }, { "name" : "Flared", "code" : "Flared" }, { "name" : "Solder", "code" : "Solder" }, { "name" : "Tapered", "code" : "Tapered" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "hasactuator", "type" : "esriFieldTypeSmallInteger", "alias" : "HasActuator", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "directionopen", "type" : "esriFieldTypeString", "alias" : "DirectionOpen", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainTurnDirection", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "clockwise", "code" : "clockwise" }, { "name" : "counterclockwise", "code" : "counterclockwise" } ] }, "defaultValue" : null }, { "name" : "manufacturer", "type" : "esriFieldTypeString", "alias" : "Manufacturer", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainManufacturer", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "American", "code" : "American" }, { "name" : "Brown Steel", "code" : "Brown" }, { "name" : "CB&I", "code" : "CB&I" }, { "name" : "Clow", "code" : "Clow" }, { "name" : "Crane", "code" : "Crane" }, { "name" : "Ford", "code" : "Ford" }, { "name" : "Foxboro", "code" : "Foxboro" }, { "name" : "Griffin", "code" : "Griffin" }, { "name" : "M&H", "code" : "M&H" }, { "name" : "McWane", "code" : "McWane" }, { "name" : "Mueller", "code" : "Mueller" }, { "name" : "Neptune", "code" : "Neptune" }, { "name" : "PDM", "code" : "PDM" }, { "name" : "Sensus", "code" : "Sensus" }, { "name" : "U.S. Pipe", "code" : "U.S. Pipe" }, { "name" : "ISCO", "code" : "ISCO" }, { "name" : "American Flow Control", "code" : "AFC" }, { "name" : "Cerro", "code" : "Cerro" }, { "name" : "Pratt", "code" : "Pratt" }, { "name" : "Dezurick", "code" : "DeZurick" }, { "name" : "Streamline", "code" : "Streamline" }, { "name" : "Howell", "code" : "Howell" }, { "name" : "Kennedy", "code" : "Kennedy" }, { "name" : "Ames", "code" : "Ames" }, { "name" : "Watts", "code" : "Watts" }, { "name" : "Febco", "code" : "Febco" }, { "name" : "Conbraco", "code" : "Conbraco" }, { "name" : "Ross", "code" : "Ross" }, { "name" : "Metron Farnier", "code" : "Metron Farnier" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "Other", "code" : "Other" }, { "name" : "American Darling", "code" : "American Darling" }, { "name" : "A.P. Smith", "code" : "A.P. Smith" } ] }, "defaultValue" : null }, { "name" : "ishorizontal", "type" : "esriFieldTypeSmallInteger", "alias" : "IsHorizontal", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "depthtooperatingnut", "type" : "esriFieldTypeDouble", "alias" : "DepthtoOperatingNut", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "northing", "type" : "esriFieldTypeDouble", "alias" : "Northing", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "easting", "type" : "esriFieldTypeDouble", "alias" : "Easting", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "origfacilityid", "type" : "esriFieldTypeString", "alias" : "OrigFacilityId", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "createdby", "type" : "esriFieldTypeString", "alias" : "CREATEDBY", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "createddate", "type" : "esriFieldTypeDate", "alias" : "CREATEDDATE", "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 }, { "name" : "paved", "type" : "esriFieldTypeSmallInteger", "alias" : "Paved Over", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "gsurface", "type" : "esriFieldTypeString", "alias" : "Ground Surface", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wSurface", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Asphalt", "code" : "Asphalt" }, { "name" : "Brick", "code" : "Brick" }, { "name" : "Concrete", "code" : "Concrete" }, { "name" : "Dirt", "code" : "Dirt" }, { "name" : "Grass", "code" : "Grass" }, { "name" : "Gravel", "code" : "Gravel" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "Water", "code" : "Water" } ] }, "defaultValue" : null }, { "name" : "fintorque", "type" : "esriFieldTypeInteger", "alias" : "Final Torque (Ft Pounds)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "stem", "type" : "esriFieldTypeString", "alias" : "Stem OK?", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "package", "type" : "esriFieldTypeString", "alias" : "Packing OK?", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "gears", "type" : "esriFieldTypeString", "alias" : "Gears OK?", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "lube", "type" : "esriFieldTypeString", "alias" : "Lube Req'd?", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "other", "type" : "esriFieldTypeString", "alias" : "Other Maint Req'd?", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "exercisedate", "type" : "esriFieldTypeDate", "alias" : "EXERCISEDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "exerciseyear", "type" : "esriFieldTypeSmallInteger", "alias" : "EXERCISEYEAR", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CreationDate", "type" : "esriFieldTypeDate", "alias" : "CreationDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "EditDate", "type" : "esriFieldTypeDate", "alias" : "EditDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Editor", "type" : "esriFieldTypeString", "alias" : "Editor", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "CREATEDDATEIndex", "fields" : "CREATEDDATE", "isAscending" : true, "isUnique" : false, "description" : "CREATEDDATE Field index", "indexType" : "Attribute" }, { "name" : "CREATEDBYIndex", "fields" : "CREATEDBY", "isAscending" : false, "isUnique" : false, "description" : "CREATEDBY Field index", "indexType" : "Attribute" }, { "name" : "LASTUPDATEIndex", "fields" : "LASTUPDATE", "isAscending" : true, "isUnique" : false, "description" : "LASTUPDATE Field index", "indexType" : "Attribute" }, { "name" : "LASTEDITORIndex", "fields" : "LASTEDITOR", "isAscending" : false, "isUnique" : false, "description" : "LASTEDITOR Field index", "indexType" : "Attribute" }, { "name" : "user_290.Sample_Utility_Data_SYSTEM_VALVE_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "PK__Sample_U__5242E63215256007", "fields" : "objectid", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "facilityid" : null, "installdate" : null, "locdesc" : null, "rotation" : null, "diameter" : null, "valvetype" : null, "bypassvalve" : null, "clocktoclose" : null, "normallyopen" : null, "turnstoclose" : null, "operable" : null, "hydrflag" : null, "curropen" : null, "enabled" : null, "activeflag" : null, "ownedby" : null, "maintby" : null, "workorderid" : null, "watertype" : null, "projectnumber" : null, "projectname" : null, "installedby" : null, "hyperlink" : null, "comment" : null, "motorized" : null, "percentopen" : null, "pressuresetting" : null, "regulationtype" : null, "connectiontype" : null, "hasactuator" : null, "directionopen" : null, "manufacturer" : null, "ishorizontal" : null, "depthtooperatingnut" : null, "northing" : null, "easting" : null, "origfacilityid" : null, "paved" : null, "gsurface" : null, "fintorque" : null, "stem" : null, "package" : null, "gears" : null, "lube" : null, "other" : null, "exercisedate" : null, "exerciseyear" : null } } } ], "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" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }