{ "currentVersion": 10.61, "cimVersion": "2.2.0", "id": 1, "name": "Meter Crew Work", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102710, "latestWkid": 3437, "xyTolerance": 0.2, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463700, "falseY": -48257000, "xyUnits": 2560, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 2400, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "sde.GIS.Util_tbl_WSInspection.Material", "defaultSymbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 130, 130, 130, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "defaultLabel": "Other", "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 252, 250, 179, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "value": "BR", "label": "BR" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 85, 255, 0, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "value": "CI", "label": "CI" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 56, 168, 0, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "value": "CT", "label": "CT" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 170, 0, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "value": "IP", "label": "IP" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 197, 255, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "value": "PL", "label": "PL" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 248, 207, 252, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "value": "", "label": "Null" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 996594.1222656257, "ymin": 245639.6000000015, "xmax": 1035364.8148437515, "ymax": 287572.52734375, "spatialReference": { "wkid": 102710, "latestWkid": 3437, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 2, "falseX": -17463700, "falseY": -48257000, "xyUnits": 1.3724607682899535E8, "falseZ": 0, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "sde.GIS.ServiceValves.ServiceID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "sde.GIS.ServiceValves.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "sde.GIS.ServiceValves.ServiceID", "type": "esriFieldTypeSmallInteger", "alias": "ServiceID", "domain": null }, { "name": "sde.GIS.ServiceValves.Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sde.GIS.ServiceValves.Angle", "type": "esriFieldTypeSmallInteger", "alias": "Angle", "domain": null }, { "name": "sde.GIS.ServiceValves.ValveSize", "type": "esriFieldTypeDouble", "alias": "ValveSize", "domain": null }, { "name": "sde.GIS.ServiceValves.ValveType", "type": "esriFieldTypeString", "alias": "ValveType", "length": 10, "domain": null }, { "name": "sde.GIS.ServiceValves.Opens", "type": "esriFieldTypeString", "alias": "Opens", "length": 5, "domain": null }, { "name": "sde.GIS.ServiceValves.Turns", "type": "esriFieldTypeString", "alias": "Turns", "length": 6, "domain": null }, { "name": "sde.GIS.ServiceValves.JoinType", "type": "esriFieldTypeString", "alias": "JoinType", "length": 2, "domain": null }, { "name": "sde.GIS.ServiceValves.Tie_1", "type": "esriFieldTypeString", "alias": "Tie_1", "length": 50, "domain": null }, { "name": "sde.GIS.ServiceValves.Tie_2", "type": "esriFieldTypeString", "alias": "Tie_2", "length": 50, "domain": null }, { "name": "sde.GIS.ServiceValves.Tie_3", "type": "esriFieldTypeString", "alias": "Tie_3", "length": 50, "domain": null }, { "name": "sde.GIS.ServiceValves.SetDate", "type": "esriFieldTypeDate", "alias": "SetDate", "length": 8, "domain": null }, { "name": "sde.GIS.ServiceValves.LocationSource", "type": "esriFieldTypeSmallInteger", "alias": "LocationSource", "domain": { "type": "codedValue", "name": "WS2_LocationSource_4", "description": "Source of geographic location data", "codedValues": [ { "name": "Schematic", "code": 1 }, { "name": "GPS Point", "code": 2 }, { "name": "Tape Tie", "code": 3 }, { "name": "Best Fit", "code": 4 }, { "name": "New GPS Point Needed", "code": 5 }, { "name": "Aerial Photo 2000", "code": 6 }, { "name": "Aerial Photo 2005", "code": 7 }, { "name": "Aerial Photo 2010", "code": 8 }, { "name": "As-Built", "code": 9 }, { "name": "Construction Plan", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sde.GIS.ServiceValves.FeatureUse", "type": "esriFieldTypeString", "alias": "FeatureUse", "length": 12, "domain": null }, { "name": "sde.GIS.ServiceValves.ValveAccess", "type": "esriFieldTypeString", "alias": "ValveAccess", "length": 8, "domain": null }, { "name": "sde.GIS.ServiceValves.Depth", "type": "esriFieldTypeDouble", "alias": "Depth", "domain": null }, { "name": "sde.GIS.ServiceValves.Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 25, "domain": { "type": "codedValue", "name": "WS2_Inspector_Water_2", "description": "Inspector Name - Water", "codedValues": [ { "name": "Mike Broas", "code": "M. Broas" }, { "name": "Jack Cooper", "code": "J. Cooper" }, { "name": "Kevin Demers", "code": "K. Demers" }, { "name": "Nat Jones", "code": "N. Jones" }, { "name": "Greg Meagher", "code": "G. Meagher" }, { "name": "Dave Smith", "code": "D. Smith" }, { "name": "Scott Sykes", "code": "S. Sykes" }, { "name": "Chris Theriault", "code": "C. Theriault" }, { "name": "Dave Welch", "code": "D. Welch" }, { "name": "Ryan Towle", "code": "R. Towle" }, { "name": "Private", "code": "Private" }, { "name": "J. Locke", "code": "J. Locke" }, { "name": "G. Craggy", "code": "G. Craggy" }, { "name": "A. DeGreenia", "code": "A. DeGreenia" }, { "name": "S. Lugg", "code": "S. Lugg" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sde.GIS.ServiceValves.Prev_ID", "type": "esriFieldTypeInteger", "alias": "Prev_ID", "domain": null }, { "name": "sde.GIS.ServiceValves.Secure", "type": "esriFieldTypeString", "alias": "Secure", "length": 1, "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.ServiceID", "type": "esriFieldTypeSmallInteger", "alias": "ServiceID", "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.Exchanged", "type": "esriFieldTypeString", "alias": "Exchanged", "length": 1, "domain": { "type": "codedValue", "name": "WS2_YorN", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sde.GIS.Util_tbl_WSInspection.ExchangeDate", "type": "esriFieldTypeDate", "alias": "ExchangeDate", "length": 8, "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.NotificationSent", "type": "esriFieldTypeString", "alias": "NotificationSent", "length": 1, "domain": { "type": "codedValue", "name": "WS2_YorN", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sde.GIS.Util_tbl_WSInspection.NotificationType", "type": "esriFieldTypeString", "alias": "NotificationType", "length": 50, "domain": { "type": "codedValue", "name": "WS2_NotificationType", "description": "Type of Notification sent out", "codedValues": [ { "name": "Email", "code": "Email" }, { "name": "Phone Call", "code": "Phone" }, { "name": "Letter", "code": "Letter" }, { "name": "Fax", "code": "Fax" }, { "name": "In Person", "code": "InPerson" }, { "name": "Other", "code": "Other" }, { "name": "Door Tag", "code": "Door Tag" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sde.GIS.Util_tbl_WSInspection.Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 100, "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.NotificationDate", "type": "esriFieldTypeDate", "alias": "NotificationDate", "length": 8, "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.AccountNum", "type": "esriFieldTypeString", "alias": "AccountNum", "length": 50, "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.MeterType", "type": "esriFieldTypeString", "alias": "MeterType", "length": 50, "domain": { "type": "codedValue", "name": "WS2_MeterType", "description": "Water Meter Type", "codedValues": [ { "name": "5/8 Straight", "code": "5/8Straight" }, { "name": "5/8 x 3/4", "code": "5/8x3/4" }, { "name": "1 inch", "code": "1" }, { "name": "1.5 inch", "code": "1.5" }, { "name": "2 inch", "code": "2" }, { "name": "3 inch", "code": "3" }, { "name": "4 inch", "code": "4" }, { "name": "6 inch", "code": "6" }, { "name": "8 inch", "code": "8" }, { "name": "INACTIVE", "code": "INACTIVE" }, { "name": "SUSPENDED", "code": "SUSPENDED" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "FIRE ONLY", "code": "FIRE ONLY" }, { "name": "UNKNOWN", "code": "UNKNOWN" }, { "name": "OTHER", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sde.GIS.Util_tbl_WSInspection.SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 50, "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.SecondNotificationSent", "type": "esriFieldTypeString", "alias": "SecondNotificationSent", "length": 1, "domain": { "type": "codedValue", "name": "WS2_YorN", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sde.GIS.Util_tbl_WSInspection.SecondNotificationDate", "type": "esriFieldTypeDate", "alias": "SecondNotificationDate", "length": 8, "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.Material", "type": "esriFieldTypeString", "alias": "Material", "length": 255, "domain": { "type": "codedValue", "name": "WS2_PipeMaterial_Water", "description": "Pipe Material - Water", "codedValues": [ { "name": "CI", "code": "CI" }, { "name": "CT", "code": "CT" }, { "name": "DI", "code": "DI" }, { "name": "GI", "code": "GI" }, { "name": "IP", "code": "IP" }, { "name": "PL", "code": "PL" }, { "name": "ST", "code": "ST" }, { "name": "BR", "code": "BR" }, { "name": "UNK", "code": "UNK" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sde.GIS.Util_tbl_WSInspection.created_user", "type": "esriFieldTypeString", "alias": "sde.GIS.Util_tbl_WSInspection.created_user", "length": 255, "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.created_date", "type": "esriFieldTypeDate", "alias": "sde.GIS.Util_tbl_WSInspection.created_date", "length": 8, "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.last_edited_user", "type": "esriFieldTypeString", "alias": "sde.GIS.Util_tbl_WSInspection.last_edited_user", "length": 255, "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.last_edited_date", "type": "esriFieldTypeDate", "alias": "sde.GIS.Util_tbl_WSInspection.last_edited_date", "length": 8, "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.GUID", "type": "esriFieldTypeGUID", "alias": "GUID", "length": 38, "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.WorkType", "type": "esriFieldTypeString", "alias": "WorkTYpe", "length": 25, "domain": { "type": "codedValue", "name": "WS2_MeterWorkType", "description": "Water utility meter crew work", "codedValues": [ { "name": "Meter & Remote Exchange", "code": "Meter & Remote Exchange" }, { "name": "Meter Exchange", "code": "Meter Exchange" }, { "name": "Remote Exchange", "code": "Remote Exchange" }, { "name": "New Meter", "code": "New Meter" }, { "name": "Phone Call", "code": "Phone Call" }, { "name": "Letter", "code": "Letter" }, { "name": "Repair", "code": "Repair" }, { "name": "Other", "code": "Other" }, { "name": "In Person Notification", "code": "In Person" }, { "name": "Inspection-meter", "code": "Inspection" }, { "name": "Inspection-Lead", "code": "Inspection-Lead" }, { "name": "Door Tag Lead", "code": "Door Tag Lead" }, { "name": "Door Tag Meter", "code": "Door Tag" }, { "name": "Email", "code": "Email" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sde.GIS.Util_tbl_WSInspection.WorkDate", "type": "esriFieldTypeDate", "alias": "WorkDate", "length": 8, "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.WTPReview", "type": "esriFieldTypeString", "alias": "WTPReview", "length": 25, "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.MeterSerial", "type": "esriFieldTypeString", "alias": "MeterSerial", "length": 50, "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.RemoteSerial", "type": "esriFieldTypeString", "alias": "RemoteSerial", "length": 50, "domain": null }, { "name": "sde.GIS.Util_tbl_WSInspection.OriginalOID", "type": "esriFieldTypeInteger", "alias": "OriginalOID", "domain": null } ], "geometryField": {}, "indexes": [ { "name": "R1401_SDE_ROWID_UK", "fields": "sde.GIS.Util_tbl_WSInspection.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9172_Service", "fields": "sde.GIS.Util_tbl_WSInspection.ServiceID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Util_tbl_WSInspection", "relatedTableId": 29, "role": "esriRelRoleOrigin", "keyField": "ServiceID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true }