{ "layers": [ { "currentVersion": 10.91, "id": 0, "name": "Water Service Connection", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102722, "latestWkid": 3734 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "FieldVerified", "field2": null, "field3": null, "defaultSymbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 117, 153, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "defaultLabel": "", "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "f21c05dcadae5e2a32218c6dc243f501", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAYlJREFUOI2t1D1oU1EUAOCP0vgiMVKLKK1EndTRxTpoXPyJoqKgVKtIi4u4WPcioovg3DplsHSoP4M/CC10cOnkoIKDCGIXRQolSmwLt7HoIG369BHzxDPew/nuPfdeTqv/FK0NcgUlJ6LdUUFONkyHb0a98dkzzDUDrdbvhm777LIzZEK0nLlu2pg+993zyHAjKO+2EVccEVn1xxZrbXTGYUU7dNjmjoFk6KYhVx2X0dKgZTptNaDXgill5RgUnYpKoTeU/orUsU2O6lM2irllKBwIF2y2oSlkKfbr0u20B4brrRVsT4VAXkbR3jiUtS41BG3aWHnZP3z/J2jxV10dqpohZXs1oi/RpyCseLWZaDLMhj3WpIDeqoaXYSh2onApXNPprGO2NIUEvPLciKkYhJpZl73wUJdcQ6SGp95759zSUvxn9xjz2HnjyorWJ3IfMem1RYfcMp8MwUlPTJgwblBeUU6HFlk1VV99aF9ov1vpqQz+XpY8Rg6ax8WkVEUlsaTRPEoVPwGL6WgH37pBJAAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 13, "height": 13, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "NO", "label": "NO", "description": "" }, { "symbol": { "type": "esriPMS", "url": "1e84d5ba10755b492cdb46bea4869020", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAclJREFUOI2t1F9IU2EYx/Evbsdz4jjREcYW27SLJnXhDDKoZkHZDA2D/JNFKN2IN9W9RNRN0LV2tQvFCysvSlEUBobkVeAfiIjoOEGKJcgp1vzzerbZ1XSz09zE5/J9eD/v+3t5eawcUlmz9FzYA02y+5wLi6qIzZU/fB76BJExYC0X6Ajeh0+paq2l7KxPWCR5p3PpyQrfJjqZff0K/e1ANsjG+ReDVD+4jlUu/OcIqfgYp9rqcfsrmXacRHvZYw75nvVx5tENLFJBlshQ5Cznck8HbC2hBYMZkOy5FRDVHYF9kVSpzuN4GzrRgkPA2g4kKq7eo9hdlhOSKs+VGuytzehvBnajqS5vXgiAZJM47b/Ih3TIqpTmDQEoJSWQ/tjJ7fiBoEQivgeKrgL5xUsYyMavHyIdkjdWZ4QRu4BUlDukf4mKyFxfxo3EVNdjVOdtTjR6ckLiAn7Ov0cbXMqAAINkrJvIx2EcNep+kQiPakx9vZNayvzZ4+0TNL27S3gyiMt/FMnEi32H5ZkF9MQ1eL5uDgGM3ByhJRRicbIXxeanUHVAgULSiLL5O2yPb/XrofbevdvMx8hw3Tpw36yl/ydttnmUV/0Fta6HKI1YH1cAAAAASUVORK5CYII=", "contentType": "image/png", "width": 13, "height": 13, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "YES", "label": "YES", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1523885.067741707, "ymin": 524687.2976408452, "xmax": 1717866.907090366, "ymax": 712687.5255919397, "spatialReference": { "wkid": 102722, "latestWkid": 3734 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ACCOUNTID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ACCOUNTID", "type": "esriFieldTypeString", "alias": "Account Number", "length": 30, "domain": null }, { "name": "SERVICETYPE", "type": "esriFieldTypeString", "alias": "Service Type", "length": 50, "domain": { "type": "codedValue", "name": "Type_of_Service", "description": "Does the resident have water/sewer/both", "codedValues": [ { "name": "Water", "code": "1" }, { "name": "Sewer", "code": "2" }, { "name": "Water and Sewer", "code": "3" }, { "name": "Storm Only", "code": "4" }, { "name": "Sprinkler", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "LOCATIONID", "type": "esriFieldTypeString", "alias": "Location Identifier", "length": 20, "domain": null }, { "name": "CRITICAL", "type": "esriFieldTypeSmallInteger", "alias": "CriticalCustomer", "domain": null }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": null }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "Owner of the Asset", "codedValues": [ { "name": "NWWSD", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "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": "NWWSD", "code": 1 }, { "name": "Perrysburg", "code": 2 }, { "name": "Private", "code": 3 }, { "name": "Other", "code": 4 } ], "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": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "ConnectionType", "type": "esriFieldTypeString", "alias": "ConnectionType", "length": 50, "domain": { "type": "codedValue", "name": "wConnectionType", "description": "Type of Connection Either Curb Stop or Meter Pit", "codedValues": [ { "name": "Meter Pit", "code": "MP" }, { "name": "Curb Stop", "code": "CS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Svc_Address", "type": "esriFieldTypeString", "alias": "Svc_Address", "length": 75, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 75, "domain": { "type": "codedValue", "name": "STATUS", "description": "Whether service is on/off or pending", "codedValues": [ { "name": "Service On", "code": "1" }, { "name": "Service Off", "code": "2" }, { "name": "Pending", "code": "3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 200, "domain": null }, { "name": "GPS_Located", "type": "esriFieldTypeString", "alias": "GPS_Located", "length": 50, "domain": { "type": "codedValue", "name": "Located", "description": "Has the features location been GPS or field verified", "codedValues": [ { "name": "Located and GPS", "code": "GPS" }, { "name": "Not Located needs GPS", "code": "NGPS" }, { "name": "Not GPS But Field Verified", "code": "FV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Copper", "type": "esriFieldTypeString", "alias": "Copper", "length": 125, "domain": null }, { "name": "GPSDate", "type": "esriFieldTypeDate", "alias": "GPS Date", "length": 8, "domain": null }, { "name": "Link", "type": "esriFieldTypeString", "alias": "Link", "length": 125, "domain": null }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "length": 50, "domain": null }, { "name": "StealthChangedOut", "type": "esriFieldTypeString", "alias": "Stealth Changed Out", "length": 25, "domain": { "type": "codedValue", "name": "YESNO", "description": "YesOrNo", "codedValues": [ { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" }, { "name": "INACTIVE", "code": "INACTIVE" }, { "name": "LARGE METER MANUAL READ", "code": "LRGMTR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DateChangeOut", "type": "esriFieldTypeDate", "alias": "Date ofChange Out", "length": 8, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 175, "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": "leadsvcline", "type": "esriFieldTypeString", "alias": "Lead Service Line", "length": 50, "domain": { "type": "codedValue", "name": "YESNO", "description": "YesOrNo", "codedValues": [ { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" }, { "name": "INACTIVE", "code": "INACTIVE" }, { "name": "LARGE METER MANUAL READ", "code": "LRGMTR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PitType", "type": "esriFieldTypeString", "alias": "Pit Type", "length": 50, "domain": { "type": "codedValue", "name": "wsMeterPitType", "description": "is meter pit single or tandem", "codedValues": [ { "name": "Single", "code": "S" }, { "name": "Tandem", "code": "T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FieldVerifiedBy", "type": "esriFieldTypeString", "alias": "Field Verified By", "length": 50, "domain": { "type": "codedValue", "name": "WTR_FieldVerifiedBy", "description": "Who did the field verification", "codedValues": [ { "name": "Chris Blake", "code": "cb" }, { "name": "Chad Feehan", "code": "cf" }, { "name": "Tom McGrain", "code": "tm" }, { "name": "Jay Carter", "code": "jc" }, { "name": "Ryan Firsdon", "code": "rf" }, { "name": "Jeff Heimrich", "code": "jh" }, { "name": "Justin Bowers", "code": "jb" }, { "name": "Grant Adams", "code": "ga" }, { "name": "Don Straub", "code": "ds" }, { "name": "Matt Zachary", "code": "mz" }, { "name": "Zack King", "code": "zk" }, { "name": "Austin Joseph", "code": "aj" }, { "name": "Josh Bundy", "code": "jbun" }, { "name": "Brandon Daniels", "code": "bd" }, { "name": "Zack Weiss", "code": "zw" }, { "name": "Cade Limes", "code": "cl" }, { "name": "Caleb Delaney", "code": "cd" }, { "name": "Tyler Stone", "code": "ts" }, { "name": "Tyler St. Clair", "code": "tst" }, { "name": "Austin Murphy", "code": "am" }, { "name": "Trevor Berfield", "code": "tb" }, { "name": "Jonathan Wagler", "code": "jw" }, { "name": "Tim Dennis", "code": "td" }, { "name": "Andre Ramsey", "code": "ar" }, { "name": "Ronee", "code": "rp" }, { "name": "Darrel Cross", "code": "dc" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FieldVerifiedNotes", "type": "esriFieldTypeString", "alias": "Field Notes", "length": 75, "domain": { "type": "codedValue", "name": "WTR_FieldVerifiedNotes", "description": "Observations observed in field about asset", "codedValues": [ { "name": "Needs Attention-Ops", "code": "Needs Attention-Ops" }, { "name": "Needs Attention-GIS", "code": "Needs Attention-GIS" }, { "name": "Verified", "code": "Verified" }, { "name": "Not Verified", "code": "Not Verified" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FieldVerifiedDate", "type": "esriFieldTypeDate", "alias": "Date Field Verified", "length": 8, "domain": null }, { "name": "AdditionalNotes", "type": "esriFieldTypeString", "alias": "Additional Notes", "length": 200, "domain": null }, { "name": "PrjNum", "type": "esriFieldTypeString", "alias": "Project Number", "length": 25, "domain": null }, { "name": "PWSID", "type": "esriFieldTypeString", "alias": "PWS ID", "length": 25, "domain": null }, { "name": "TypeofAttention", "type": "esriFieldTypeString", "alias": "Type of Attention", "length": 125, "domain": { "type": "codedValue", "name": "Type_of_Attention", "description": "follow up work needed", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Can't Locate", "code": "Can't Locate" }, { "name": "Needs Repaired", "code": "Needs Repaired" }, { "name": "Other-See Additional Notes Field", "code": "Other" }, { "name": "Needs Cleaned Out", "code": "Needs Cleaned Out" }, { "name": "Needs GPS", "code": "Needs GPS" }, { "name": "Needs Raised", "code": "Needs Raised" }, { "name": "Leak", "code": "Leak" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LocationNo", "type": "esriFieldTypeString", "alias": "LocationNo", "length": 50, "domain": null }, { "name": "MeterTechCrew", "type": "esriFieldTypeString", "alias": "Meter Tech Crew", "length": 50, "domain": { "type": "codedValue", "name": "WTR_MtrTechCrew", "description": "Meter Tech crew", "codedValues": [ { "name": "Don Straub", "code": "ds" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "dateofmetertechvisit", "type": "esriFieldTypeDate", "alias": "Date of Meter Tech Visit", "length": 8, "domain": null }, { "name": "MeterTechNotes", "type": "esriFieldTypeString", "alias": "Meter Tech Notes", "length": 200, "domain": null }, { "name": "ServiceConnectionInspectedforLe", "type": "esriFieldTypeString", "alias": "Service Connection Inspected for Leaks", "length": 50, "domain": { "type": "codedValue", "name": "WTR_LeakFound", "description": "Was a leak detected or sound heard", "codedValues": [ { "name": "Leak Found", "code": "lf" }, { "name": "No Leak Found", "code": "nlf" }, { "name": "Possible Leak-Follow Up Needed", "code": "pl" }, { "name": "Not Inspected", "code": "ni" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DateofLeakInspection", "type": "esriFieldTypeDate", "alias": "Date of Leak Inspection", "length": 8, "domain": null }, { "name": "LeakInspector", "type": "esriFieldTypeString", "alias": "Leak Inspector", "length": 50, "domain": { "type": "codedValue", "name": "WTR_Leak_Inspector", "description": "Who did the leak detection", "codedValues": [ { "name": "Chris Blake", "code": "cb" }, { "name": "Chad Feehan", "code": "cf" }, { "name": "Tom McGrain", "code": "tm" }, { "name": "Justin Bowers", "code": "jb" }, { "name": "Matt Zachary", "code": "mz" }, { "name": "Tim Dennis", "code": "td" }, { "name": "Andre Ramsey", "code": "ar" }, { "name": "Ronee Peterson-Loftis", "code": "rp" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LeakInspectorNotes", "type": "esriFieldTypeString", "alias": "Leak Inspector Notes", "length": 225, "domain": null }, { "name": "DateFixed", "type": "esriFieldTypeDate", "alias": "Date Fixed", "length": 8, "domain": null }, { "name": "FieldVerified", "type": "esriFieldTypeString", "alias": "Field Verified", "length": 25, "domain": { "type": "codedValue", "name": "WTR_FieldVerified", "description": "was valves or service connections field verified", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "FOLLOW UP", "code": "FOLLOW UP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WhoseAttentionNeeded", "type": "esriFieldTypeString", "alias": "Whose Attention Needed", "length": 50, "domain": { "type": "codedValue", "name": "SrvcConnectionAttention", "description": "Whose attention is needed for issue with service connection", "codedValues": [ { "name": "OPs", "code": "OPs" }, { "name": "GIS", "code": "GIS" }, { "name": "Meter Tech", "code": "Meter Tech" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SrvcConnectionLoc", "type": "esriFieldTypeString", "alias": "Service Connection Location", "length": 50, "domain": { "type": "codedValue", "name": "WTR_SrcConnectionLoc", "description": "Location of Service Conncetion", "codedValues": [ { "name": "Sidewalk", "code": "Sidewalk" }, { "name": "Driveway", "code": "Driveway" }, { "name": "Curb", "code": "Curb" }, { "name": "UnKnown", "code": "UnKnown" }, { "name": "Under Tree", "code": "Under Tree" }, { "name": "Under Shrubbery", "code": "Under Shrubbery" }, { "name": "Front Yard", "code": "Front Yard" }, { "name": "Back Yard", "code": "Back Yard" }, { "name": "Side of House", "code": "Side of House" }, { "name": "Inside House", "code": "Inside House" }, { "name": "E. Side of Sidewalk", "code": "E. Side of Sidewalk\n\nTopic: Gray Matter SCADA report follow up\nTime: Jun 22, 2021 02:30 PM Eastern Time (US and Canada)\n\nJoin Zoom Meeting\nhttps://us02web.zoom.us/j/85850181655?pwd=NDJuYXhoMHZ5WlE4VVVhUzgwRHpLdz09\n\nMeeting ID: 858 5018 1655\nPasscode: 447275\nOne tap mobile\n+16465588656,,85850181655#,,,,*447275# US (New York)\n+13017158592,,85850181655#,,,,*447275# US (Washington DC)\n\nDial by your location\n +1 646 558 8656 US (New York)\n +1 301 715 8592 US (Washington DC)\n +1 312 626 6799 US (Chicago)\n +1 669 900 9128 US (San Jose)\n +1 253 215 8782 US (Tacoma)\n +1 346 248 7799 US (Houston)\nMeeting ID: 858 5018 1655\nPasscode: 447275\nFind your local number: https://us02web.zoom.us/u/kd8MWf7Ryg\n\nE. Side of Sidewalk" }, { "name": "W. Side of Sidewalk", "code": "W. Side of Sidewalk" }, { "name": "S. Side of Sidewalk", "code": "S. Side of Sidewalk" }, { "name": "N. Side of Sidewalk", "code": "N. Side of Sidewalk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R436_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_436", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_436", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S307_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.91, "id": 1, "name": "Water_Main", "type": "Feature Layer", "description": "Water pipes connecting between manholes, pump stations and other features", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102722, "latestWkid": 3734 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "Ownership", "field2": null, "field3": null, "defaultSymbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 232, 190, 255, 255 ], "width": 2 }, "defaultLabel": "", "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 38, 115, 255 ], "width": 3 }, "value": "NWWSD", "label": "NWWSD", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1496226.3407399356, "ymin": 1.7881393432617188E-7, "xmax": 1814108.0552759916, "ymax": 714991.4527620673, "spatialReference": { "wkid": 102722, "latestWkid": 3734 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Prj_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Main_Size", "type": "esriFieldTypeDouble", "alias": "Main_Size", "domain": { "type": "codedValue", "name": "WTR_Main_Size", "description": "Water Main Size", "codedValues": [ { "name": "1", "code": 1 }, { "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": "16", "code": 16 }, { "name": "20", "code": 20 }, { "name": "24", "code": 24 }, { "name": "30", "code": 30 }, { "name": "36", "code": 36 }, { "name": "42", "code": 42 }, { "name": "48", "code": 48 }, { "name": "54", "code": 54 }, { "name": "60", "code": 60 }, { "name": "1 1/2", "code": 1.5 }, { "name": "62", "code": 62 }, { "name": "64", "code": 64 }, { "name": "66", "code": 66 }, { "name": "68", "code": 68 }, { "name": "70", "code": 70 }, { "name": "72", "code": 72 }, { "name": "74", "code": 74 }, { "name": "76", "code": 76 }, { "name": "78", "code": 78 }, { "name": "3/4", "code": 0.25 }, { "name": "18", "code": 18 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 5, "domain": { "type": "codedValue", "name": "WTR_Main_Matl", "description": "Water Main Material", "codedValues": [ { "name": "AC", "code": "AC" }, { "name": "C900", "code": "C900" }, { "name": "CIP", "code": "CIP" }, { "name": "CU", "code": "CU" }, { "name": "DIP", "code": "DIP" }, { "name": "HDPE", "code": "HDPE" }, { "name": "PSCP", "code": "PSCP" }, { "name": "PVC", "code": "PVC" }, { "name": "STEEL", "code": "STEEL" }, { "name": "TRANSITE", "code": "TRANS" }, { "name": "C909", "code": "C909" }, { "name": "C906", "code": "C906" }, { "name": "SDR 9", "code": "SDR9" }, { "name": "SDR21", "code": "SDR21" }, { "name": "RCPP", "code": "RCPP" }, { "name": "C900/DR14", "code": "DR14" }, { "name": "C900/DR18", "code": "DR18" }, { "name": "UnKnown", "code": "Unkwn" }, { "name": "PCCP", "code": "PCCP" }, { "name": "Concrete Cylinder Pipe", "code": "CCP" }, { "name": "Unknown", "code": "Unknown" }, { "name": "GALV", "code": "GALV" }, { "name": "Copper", "code": "COPP" }, { "name": "Lead", "code": "LD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Joint_Type", "type": "esriFieldTypeString", "alias": "Joint_Type", "length": 10, "domain": { "type": "codedValue", "name": "WTR_Joint_Type", "description": "Water Main Joint Type", "codedValues": [ { "name": "MECHANICAL", "code": "MECHANICAL" }, { "name": "PUSH-ON", "code": "PUSH-ON" }, { "name": "FUSED", "code": "FUSED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Poly_Wrap", "type": "esriFieldTypeString", "alias": "Poly_Wrap", "length": 3, "domain": { "type": "codedValue", "name": "WTR_Poly_Wrap", "description": "Water Main Poly Wrap", "codedValues": [ { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Lining", "type": "esriFieldTypeString", "alias": "Lining", "length": 6, "domain": { "type": "codedValue", "name": "WTR_Lining", "description": "Water Main Lining", "codedValues": [ { "name": "CEMENT", "code": "CEMENT" }, { "name": "PVC", "code": "PVC" }, { "name": "RESIN", "code": "RESIN" }, { "name": "SLIP", "code": "SLIP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Encasement", "type": "esriFieldTypeString", "alias": "Encasement", "length": 3, "domain": { "type": "codedValue", "name": "WTR_Encasement", "description": "Water Main Encasement", "codedValues": [ { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Length", "type": "esriFieldTypeDouble", "alias": "Length", "domain": null }, { "name": "As_Built", "type": "esriFieldTypeString", "alias": "As_Built", "length": 3, "domain": { "type": "codedValue", "name": "AS_BUILT", "description": "INDICATOR OF AS_BUILT DRAWING", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Yr_Install", "type": "esriFieldTypeSmallInteger", "alias": "Yr_Install", "domain": null }, { "name": "Project_Num", "type": "esriFieldTypeString", "alias": "Project_Num", "length": 16, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 100, "domain": null }, { "name": "Supplier", "type": "esriFieldTypeString", "alias": "Supplier", "length": 5, "domain": { "type": "codedValue", "name": "WTR_Supplier", "description": "Water Supplier/Status", "codedValues": [ { "name": "Bowling Green", "code": "BG" }, { "name": "Fostoria", "code": "FOS" }, { "name": "Perrysburg", "code": "PB" }, { "name": "Oregon", "code": "OR" }, { "name": "Toledo", "code": "TOL" }, { "name": "Private", "code": "PRIV" }, { "name": "Special status", "code": "SPC" }, { "name": "McComb", "code": "MCMB" }, { "name": "Napoleon", "code": "NAP" }, { "name": "North Baltimore", "code": "NB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Ownership", "type": "esriFieldTypeString", "alias": "Ownership", "length": 10, "domain": null }, { "name": "Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GBALINK", "type": "esriFieldTypeInteger", "alias": "GBALINK", "domain": null }, { "name": "WM_ID", "type": "esriFieldTypeString", "alias": "WM_ID", "length": 15, "domain": null }, { "name": "INGBAMS", "type": "esriFieldTypeSmallInteger", "alias": "INGBAMS", "domain": null }, { "name": "Line_Type", "type": "esriFieldTypeString", "alias": "Line Type", "length": 50, "domain": { "type": "codedValue", "name": "WTR_Main_Type", "description": "Water Main Type Hyd Lead or Main", "codedValues": [ { "name": "Hydrant Lead", "code": "Hyd Lead" }, { "name": "Water Main", "code": "Main" }, { "name": "Service line to customer", "code": "Service" }, { "name": "Private fire line", "code": "Priv FL" }, { "name": "UnKnown", "code": "UnKnown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "Previous_Owner", "type": "esriFieldTypeString", "alias": "Previous_Owner", "length": 25, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "SourcePDF", "type": "esriFieldTypeString", "alias": "SourcePDF", "length": 100, "domain": null }, { "name": "HyperlinkPDF", "type": "esriFieldTypeString", "alias": "HyperlinkPDF", "length": 200, "domain": null }, { "name": "HLINK2", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 125, "domain": null }, { "name": "PrjLinks", "type": "esriFieldTypeString", "alias": "PrjLinks", "length": 200, "domain": null }, { "name": "MapCreate", "type": "esriFieldTypeString", "alias": "MapCreate", "length": 225, "domain": null }, { "name": "MapCreate2", "type": "esriFieldTypeString", "alias": "MapCreate2", "length": 225, "domain": null }, { "name": "wLineStatus", "type": "esriFieldTypeString", "alias": "wLineStatus", "length": 50, "domain": { "type": "codedValue", "name": "wMainStatus", "description": "Water Main is Live or under construction or abandoned", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Under Construction", "code": "under construction" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Proposed", "code": "Proposed" }, { "name": "UnKnown", "code": "UnKnown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Prj_Status", "type": "esriFieldTypeString", "alias": "Project Status", "length": 100, "domain": null }, { "name": "Prj_Name", "type": "esriFieldTypeString", "alias": "Project Name", "length": 50, "domain": null }, { "name": "AssetType", "type": "esriFieldTypeString", "alias": "AssetType", "length": 75, "domain": null }, { "name": "TotalMiles", "type": "esriFieldTypeSingle", "alias": "TotalMiles", "domain": null }, { "name": "ServiceLineType", "type": "esriFieldTypeString", "alias": "Service Line Type", "length": 50, "domain": { "type": "codedValue", "name": "WTR_SERVICE_TYPE", "description": "Material Type of Service Line", "codedValues": [ { "name": "Copper", "code": "Copper" }, { "name": "Lead", "code": "Lead" }, { "name": "PVC", "code": "PVC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ServiceAddress", "type": "esriFieldTypeString", "alias": "Service Address", "length": 125, "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": "Condition", "type": "esriFieldTypeString", "alias": "Asset Condition Rating", "length": 200, "domain": { "type": "codedValue", "name": "PipeCondition", "description": "Condition of pipe based off numerous factors ", "codedValues": [ { "name": "Excellent-Asset New or Nearly New, No Known Suspected Condition", "code": "0" }, { "name": "Good-Asset has Few Known Suspected Issues", "code": "2" }, { "name": "Fair-Asset has Known or Suspected Issues that will Impact Assets ability to perform in Next Several Years", "code": "4" }, { "name": "Poor-Asset has Known or Suspected Issues that will Impact Assets ability to perform in Near Future (1-2 Years)", "code": "5" }, { "name": "Very Good-No Known Suspected Condition, but Asset No longer New", "code": "1" }, { "name": "Average-Asset has Known or Suspected Issues", "code": "3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EstimatedLifeReached", "type": "esriFieldTypeString", "alias": "Estimated Life", "length": 75, "domain": { "type": "codedValue", "name": "NoYes", "description": "NoYes leak possible", "codedValues": [ { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" }, { "name": "YES-FOLLOW UP NEEDED", "code": "YES-FOLLOW UP NEEDED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NumRepairs", "type": "esriFieldTypeSmallInteger", "alias": "Number of Main Repairs", "domain": null }, { "name": "LFPrj", "type": "esriFieldTypeSmallInteger", "alias": "Lineal Feet of Project", "domain": null }, { "name": "PWSID", "type": "esriFieldTypeString", "alias": "PWS ID", "length": 50, "domain": null }, { "name": "Conseqoffailure", "type": "esriFieldTypeString", "alias": "Consequence of Failure", "length": 200, "domain": { "type": "codedValue", "name": "Conseq_of_failure", "description": "Consequences of pipe failure", "codedValues": [ { "name": "Very Minor Effect on Service or Financial Impact", "code": "1" }, { "name": "Minor Service Interuption with Minor Financial Impact", "code": "2" }, { "name": "Severe Service Impact with Major Financial Impact", "code": "4" }, { "name": "Catastrophic Failure with Extreme Financial Loss", "code": "5" }, { "name": "Service Interruption with Moderate Financial Impact", "code": "3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ConnectionsPerPrj", "type": "esriFieldTypeSmallInteger", "alias": "Number of Services per Project", "domain": null }, { "name": "Occurences", "type": "esriFieldTypeString", "alias": "Occurences", "length": 200, "domain": { "type": "codedValue", "name": "Occurences", "description": "the amount of times an interruption of service happened due to a malfunction of pipe", "codedValues": [ { "name": "Monthly or Greater Frequency (Regularly)", "code": "5" }, { "name": "4 Times per Year (Quarterly)", "code": "4" }, { "name": "About Once per Year (Annually)", "code": "3" }, { "name": "Every 2-5 Years (Rarely)", "code": "2" }, { "name": "No Occurences Unless Exceptional Event", "code": "1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 225, "domain": null }, { "name": "NumNonlineRepairs", "type": "esriFieldTypeSmallInteger", "alias": "Number of Non-Line Repairs", "domain": null }, { "name": "DateofRepair", "type": "esriFieldTypeDate", "alias": "Date of Repair", "length": 8, "domain": null }, { "name": "EstimatedLife", "type": "esriFieldTypeString", "alias": "Estimated Life", "length": 75, "domain": null }, { "name": "MainInspectedforLeaks", "type": "esriFieldTypeString", "alias": "Main Inspected for Leaks", "length": 255, "domain": { "type": "codedValue", "name": "WTR_LeakFound", "description": "Was a leak detected or sound heard", "codedValues": [ { "name": "Leak Found", "code": "lf" }, { "name": "No Leak Found", "code": "nlf" }, { "name": "Possible Leak-Follow Up Needed", "code": "pl" }, { "name": "Not Inspected", "code": "ni" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LeakInspector", "type": "esriFieldTypeString", "alias": "Leak Inspector", "length": 25, "domain": { "type": "codedValue", "name": "WTR_Leak_Inspector", "description": "Who did the leak detection", "codedValues": [ { "name": "Chris Blake", "code": "cb" }, { "name": "Chad Feehan", "code": "cf" }, { "name": "Tom McGrain", "code": "tm" }, { "name": "Justin Bowers", "code": "jb" }, { "name": "Matt Zachary", "code": "mz" }, { "name": "Tim Dennis", "code": "td" }, { "name": "Andre Ramsey", "code": "ar" }, { "name": "Ronee Peterson-Loftis", "code": "rp" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DateInspected", "type": "esriFieldTypeDate", "alias": "Date Inspected", "length": 8, "domain": null }, { "name": "LeakInspectorNotes", "type": "esriFieldTypeString", "alias": "Leak Inspector Notes", "length": 225, "domain": null }, { "name": "FieldPiclink", "type": "esriFieldTypeString", "alias": "Field Picture Link", "length": 75, "domain": null }, { "name": "fieldpicweblink", "type": "esriFieldTypeString", "alias": "fieldpicweblink", "length": 150, "domain": null }, { "name": "TFL", "type": "esriFieldTypeDouble", "alias": "Total Lineal Feet", "domain": null }, { "name": "SHAPE.len", "type": "esriFieldTypeDouble", "alias": "SHAPE.len", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R297_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_297", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_297", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a218_ix1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "SHAPE.len", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true } ], "tables": [] }