{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 6, "name": "Gate Valves", "type": "Feature Layer", "parentLayer": { "id": 0, "name": "Water" }, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 16, "name": "sde.sde.workorder__task", "relatedTableId": 33, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "globalid", "composite": false, "catalogID": "{4F8784E6-0C9B-4921-9CB9-7B20C6F6F48E}" }, { "id": 17, "name": "sde.sde.workorder__task", "relatedTableId": 34, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "globalid", "composite": false, "catalogID": "{4F8784E6-0C9B-4921-9CB9-7B20C6F6F48E}" }, { "id": 18, "name": "sde.sde.workorder__task", "relatedTableId": 42, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "globalid", "composite": false, "catalogID": "{4F8784E6-0C9B-4921-9CB9-7B20C6F6F48E}" }, { "id": 19, "name": "sde.ags.tbl_media5", "relatedTableId": 59, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "globalid", "composite": false, "catalogID": "{98166402-5F10-433B-BF64-3A405C155682}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "extent": { "xmin": 501186.36230000015, "ymin": 4977265.8671, "xmax": 505177.44400000013, "ymax": 4986597.0065, "spatialReference": { "wkid": 26915, "latestWkid": 26915, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "spatialReference": { "wkid": 26915, "latestWkid": 26915, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "sourceSpatialReference": { "wkid": 26915, "latestWkid": 26915, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "67c85275ab4f213a21a7170c410b8d5f", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAB8AAAAWCAYAAAA4oUfxAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAEUklEQVRIicWVa2wUVRTH/+fO7Hv7WOhStkj30VJI19bGEsPDogliIyIaE79oQE1IjEaN8QOJpImkfEBJwI8SEwnEhMT4xaAGKhgiilJQ0oQCLd1Xn2q3Le3S3dmdmb3XzJSWrUofQcI/mZu595w5v5Nzz70j4wFKnsvY2NhoSaWUR3POJV4IiRYUkKuCJoYT0f5o5z3Bk8mk22Jx7iWBZhAWBOcgzhj/FMDb9wSXJGml5gmuSzfshCBJAOJ2AoV5iIJ3EiTyVHJ270v3DLep6qA+cv2A9fsPiqZiU13O17BVLa9j0wnI4wmQloF1pFuwbOojc5EhOR94XnjX4OAogP3T82q//xWmK0/IyqhbstiI6xpIncySnhUQeT3Sl9iDRUheqGM4HLZmMplOy0jXh2UO0bq6aYc78cs3GP7j9wMAFHCKLga8KLiSStXDVfaF6q4oHtNk5+Vzp6GmVeje8BtTfUYq+uJf3Rc4Edm00kClsma7UxArNJWbo+DAxW9xX+B5xgYtf3UcLprsfX3lY80eyWIz1/svtRnbnVEmxrqNBvlf4KFQqISEaAGzLBN6ri2WSByvqanZ7/B4nwtv2+WxuopNv7HYFeS1XDo7kbxgzKv8/n2QHZVCy0ZjfYnWxcJpVTDYJPL5tXqp/1WlaovX1XFsDMBxaFqIiBUR3TnnTJYhuGYDqHrqa2n7+JMt9SVnWuLV/uAQ53pHrL//tznhNZWhp/KMb4EQlCe5Obtqc1hKJyW91A8SeLzaHzxoX+LbWrttV7lsd80EqHvhLaiZW8XDXZc2i7ZjHwPwad5acHd5ILu84bAj0tZeFQj8bOYFcMbYDzdisTOz4JYSz/r1O/fsFkKg59wJ3FjeBHvktGmreGTT2tDGZ9c6l/hQvKIKVNBwnkAtIAS8qxvZ0qr63R1fHkISAtzlpVygSaopzW/wr3tmg+F78ei+PAMpAGbDZasdvvpNEIJjoLN9VnlcZStM211FBCbJRpK4euKzWSb3ssqZb2WLTRTezAvu9oVKTN/2d4a7SsYDlDz9wrmOicGIuX9aOgVY7zip6XHTZhwvR4nXLPM/ZWxXaigGrqnGhTTz48vdujkV9zbjP8ueHR++cHrfy4eMbhfM8rQtxMJMvWXaettPXu799buf3OUrm+uef3ONr24jJKsdPK9jNHYFmpLGWKxTdJ068okA2wEhvCw9AnvvecR72trj578+bybIwYnhwr/gPfG40drGQ9WVlbWOyMmHhcV10KVM+IjzHyOJ2PtBEv6LR1vfcS2teNFe5HlIVVKj6dGhU+B8Us9lOiLx+OfVgeDmkrOtZfLkn11ytO09IbNYNBqNzFl2FFRQcjj6kMnc1Kz8NZCwg7O4YdA0bViSnEcAOkkEOzGhSsSTOQkqJ5o0fIjwLjFWDMIkJOmqy+nMzLvnheru7jbqbTxDwPWZ9YGBAQUYuIbI1Wt3C9gTj59D3Mx1Xv0NGKvOTb6xq20AAAAASUVORK5CYII=", "contentType": "image/png", "width": 23, "height": 16, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "objectid", "globalIdField": "globalid", "displayField": "old_id", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "old_id", "type": "esriFieldTypeInteger", "alias": "old_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "old_id" }, { "name": "gate_valve_year_built", "type": "esriFieldTypeSmallInteger", "alias": "gate_valve_year_built", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "gate_valve_year_built" }, { "name": "gate_valve_benchmark", "type": "esriFieldTypeDouble", "alias": "gate_valve_benchmark", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "gate_valve_benchmark" }, { "name": "gate_valve_owner", "type": "esriFieldTypeString", "alias": "gate_valve_owner", "domain": { "type": "codedValue", "name": "gate_valves_owner", "description": "Gate Valve Ownership", "codedValues": [ { "name": "City", "code": "City" }, { "name": "Landfall", "code": "Landfall" }, { "name": "Private", "code": "Private" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Lake Elmo", "code": "Lake Elmo" }, { "name": "Woodbury", "code": "Woodbury" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "gate_valve_owner" }, { "name": "gate_valve_size", "type": "esriFieldTypeDouble", "alias": "gate_valve_size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "gate_valve_size" }, { "name": "gate_valve_status", "type": "esriFieldTypeString", "alias": "gate_valve_status", "domain": { "type": "codedValue", "name": "gate_valves_status", "description": "Gate Valve Open Status", "codedValues": [ { "name": "Open", "code": "open" }, { "name": "Closed", "code": "closed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "gate_valve_status" }, { "name": "gate_valve_keying", "type": "esriFieldTypeString", "alias": "gate_valve_keying", "domain": { "type": "codedValue", "name": "gate_valves_keying_direction", "description": "Gate Valve Keying Direction", "codedValues": [ { "name": "Clockwise", "code": "clockwise" }, { "name": "Counterclockwise", "code": "counterclockwise" }, { "name": "Unknown", "code": "unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "gate_valve_keying" }, { "name": "originaloid", "type": "esriFieldTypeInteger", "alias": "OriginalOID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "originaloid" }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "globalid", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "globalid" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "valve_type", "type": "esriFieldTypeString", "alias": "valve_type", "domain": { "type": "codedValue", "name": "gate_valve_type", "description": "Gate Butterfly Hydrant", "codedValues": [ { "name": "Gate", "code": "1" }, { "name": "Butterfly", "code": "2" }, { "name": "Hydrant", "code": "3" }, { "name": "Air Relief", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "valve_type" }, { "name": "asbuilt", "type": "esriFieldTypeString", "alias": "asbuilt", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "asbuilt" }, { "name": "source", "type": "esriFieldTypeString", "alias": "source", "domain": { "type": "codedValue", "name": "source", "description": "Source used for GIS Edits", "codedValues": [ { "name": "Asbuilt", "code": "1" }, { "name": "Field Edit", "code": "2" }, { "name": "GPS", "code": "3" }, { "name": "Digitized", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "source" }, { "name": "gis_reviewed", "type": "esriFieldTypeString", "alias": "gis_reviewed", "domain": { "type": "codedValue", "name": "yes or no", "description": "Yes or No", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "gis_reviewed" }, { "name": "gis_reviewed_date", "type": "esriFieldTypeDate", "alias": "gis_reviewed_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "gis_reviewed_date" }, { "name": "asset_status", "type": "esriFieldTypeString", "alias": "asset_status", "domain": { "type": "codedValue", "name": "asset_status", "description": "Active Abandoned Retire(Delete)", "codedValues": [ { "name": "Active", "code": "1" }, { "name": "Retired_Needs_Delete", "code": "3" }, { "name": "Abandoned", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "asset_status" }, { "name": "asset_id", "type": "esriFieldTypeString", "alias": "asset_id", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "asset_id" }, { "name": "source_date", "type": "esriFieldTypeDate", "alias": "source_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "source_date" }, { "name": "notes", "type": "esriFieldTypeString", "alias": "notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "notes" }, { "name": "hydrant_has_gate_valve", "type": "esriFieldTypeString", "alias": "hydrant_has_gate_valve", "domain": { "type": "codedValue", "name": "yes or no", "description": "Yes or No", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "hydrant_has_gate_valve" }, { "name": "hydrant_owner", "type": "esriFieldTypeString", "alias": "hydrant_owner", "domain": { "type": "codedValue", "name": "gate_valves_owner", "description": "Gate Valve Ownership", "codedValues": [ { "name": "City", "code": "City" }, { "name": "Landfall", "code": "Landfall" }, { "name": "Private", "code": "Private" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Lake Elmo", "code": "Lake Elmo" }, { "name": "Woodbury", "code": "Woodbury" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "hydrant_owner" } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "shape" }, "indexes": [ { "name": "index_85", "isAscending": true, "isUnique": true, "description": "", "fields": "globalid" }, { "name": "r73_sde_rowid_uk", "isAscending": true, "isUnique": true, "description": "", "fields": "objectid" }, { "name": "a54_ix1", "isAscending": true, "isUnique": true, "description": "", "fields": "shape" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Gate Valves", "description": "", "prototype": { "attributes": { "hydrant_has_gate_valve": null, "notes": null, "old_id": null, "gate_valve_year_built": null, "gate_valve_benchmark": null, "gate_valve_owner": null, "gate_valve_size": null, "gate_valve_status": null, "gate_valve_keying": null, "originaloid": null, "hydrant_owner": null, "source_date": null, "asset_id": null, "asset_status": null, "gis_reviewed_date": null, "valve_type": null, "asbuilt": null, "source": null, "gis_reviewed": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "5dabca1d632c4527b975c832db5519c6" }