{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Hydrants", "type": "Feature Layer", "parentLayer": null, "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": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "extent": { "xmin": 1496230.8795559406, "ymin": 524737.1425048858, "xmax": 1720050.906900391, "ymax": 714240.6257533729, "spatialReference": { "wkid": 102722, "latestWkid": 3734, "xyTolerance": 5.120000004768372E-4, "zTolerance": 2, "mTolerance": 0.001, "falseX": -118963900, "falseY": -96373800, "xyUnits": 3.7240637144144125E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102722, "latestWkid": 3734, "xyTolerance": 5.120000004768372E-4, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -1.189638999997993E8, "falseY": -9.637379999996291E7, "xyUnits": 15624.999985448083, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "EOL", "defaultSymbol": { "type": "esriPMS", "url": "1f92c869e35a9e1148d63b00ca49b04a", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABkklEQVQ4jbXTPUhCURjG8b9hSE2C2McUJQ3SFd2sxUCCEAIpCJwaIiSHgigol8ZsS+wSfUwN0RAYhNBQkrSkfUHQZNxwFAmkIC5cr9Jg5dWLFEQPnOW8PD8OnHOM/DHGfwGen+lJJFhSFPrLZUpdXVxMTSEaDCg/AqKImE4TDARotVqre4+PjO3tsbK7y0wwyElTYG2NLa+XkN1ejwoCCALW42MOIxH84TDnOmB5GYfLxXRjWZvxcdqjUTYAhw5QVeZ9PkzaQi4HZnN1fWVkhIGJCTzxOJd1QHc3ndpyIgF+P1gskM3WEEHAYDQyDA1AuUxJC0gSVCrw8gLFYv0pZLl2G99ANsuTFpidBVUFmw16e2v7hQLvmQz3OuDoiPjcHJNOJ30AJhMsLqLL9jbnhQIXOuDtjetQiP1kkoW2Nsz6KtzechOLsQmoOgDg6orI0BDKzg6jbjceoOVz9CqKnK6uclAsktR2Gl9i6eGB9cFBzmw2HE4nHbKMkkqRl2VSQL7xVM0+050kcSdJTaa/AH6dD9+BgA6IJnzRAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 }, "defaultLabel": "All other Hydrants", "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "ea67d3ab993a396fce419e012c09c1b3", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABeUlEQVQ4jdXUv0vVURjH8Vd67x0kELwJKUnS0lSB1Q1HBx1yV9tanKLigmZYFAhiVhYubk5aYgb9B9EWQmk/QIho6GoUdekHOvUlroMF3/vle7TBoT7TOc/D5/08zzmck7HLyvzXwMaD9J/kSJ58hUqZ8jNel5jGl78G7qenj/NF2rPUxnM/iW7RNcfUVx7uCGyh7wajHRxKK5Yje4WOAs1D7PnEwnbAxjMMhmBxdXL4FQMTPBEbvwpYYPAcbTvB/ugChccUlxlOBR7jeDZh+oabv9eXUR/LZdHGieVYrArYQFOyizHMJvbbeaqAtVtFg6qkxDLkgsANfiQNQ/iFGlxKAa7zPQgssRIlzjGPiUDHEd6zEgR+ZPge3WdpCDCqNEO5xNUgcJG1Vu4sMnJqa8qgnhI95/ZLPgSBMM9ojtxbBnqpS95ShDk2lhh/xHjSn/qWZ7h+kfvXuHuAo3vZB+t8XuVFDcUHvEvzBn+bSd7gdCgf0r//wW4CZEpTed1MYV0AAAAASUVORK5CYII=", "contentType": "image/png", "width": 15, "height": 15, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Yes", "label": "Yes" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriHSVAlgorithm", "fromColor": [ 56, 168, 0, 255 ], "toColor": [ 255, 255, 0, 255 ] }, { "type": "algorithmic", "algorithm": "esriHSVAlgorithm", "fromColor": [ 255, 255, 0, 255 ], "toColor": [ 255, 0, 0, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Hydrant_ID", "typeIdField": "EOL", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Hydrant_ID", "type": "esriFieldTypeString", "alias": "Hydrant_ID", "domain": null, "editable": true, "nullable": false, "length": 20, "defaultValue": null, "modelName": "Hydrant_ID" }, { "name": "Install_Type", "type": "esriFieldTypeString", "alias": "Install_Type", "domain": { "type": "codedValue", "name": "WTR_Hyd_Install", "description": "Water Hydrant Install Type", "codedValues": [ { "name": "OVER", "code": "OVER" }, { "name": "PARALLEL", "code": "PARALLEL" }, { "name": "PERPENDICULAR", "code": "PERPENDICULAR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 13, "defaultValue": "PARALLEL", "modelName": "Install_Type" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Model" }, { "name": "Thread_Style", "type": "esriFieldTypeString", "alias": "Thread_Style", "domain": { "type": "codedValue", "name": "WTR_Hyd_Thread", "description": "Water Hydrant Thread", "codedValues": [ { "name": "NOZZLE", "code": "NOZZLE" }, { "name": "STEAMER NOZZLE", "code": "STEAMER NOZZLE" }, { "name": "VALVE OPENING", "code": "VALVE OPENING" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 17, "defaultValue": "VALVE OPENING", "modelName": "Thread_Style" }, { "name": "HYD_Drain", "type": "esriFieldTypeString", "alias": "HYD_Drain", "domain": { "type": "codedValue", "name": "WTR_Hyd_Drain", "description": "Water Hydrant Drain Type", "codedValues": [ { "name": "NON-SELF DRAINING", "code": "NON-SELF DRAINING" }, { "name": "SELF DRAINING", "code": "SELF DRAINING" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 17, "defaultValue": "SELF DRAINING", "modelName": "HYD_Drain" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": { "type": "codedValue", "name": "WTR_Manuf", "description": "Manufacturer of Hydrant", "codedValues": [ { "name": "Kennedy", "code": "Kennedy" }, { "name": "Mueller", "code": "Mueller" }, { "name": "American Darling Valve", "code": "ADV" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Anniston", "code": "Anniston" }, { "name": "Columbian Iron Works", "code": "CIW" }, { "name": "Waterous", "code": "Waterous" }, { "name": "Mathews", "code": "Mathews" }, { "name": "RD Wood", "code": "RD Wood" }, { "name": "Kennedy-K81", "code": "K81" }, { "name": "Kennedy-K10", "code": "K10" }, { "name": "Kennedy-K11", "code": "K11" }, { "name": "Kennedy-K55", "code": "K55" }, { "name": "Darling", "code": "Darling" }, { "name": "Darling-B84", "code": "B84" }, { "name": "Darling-B50", "code": "B50" }, { "name": "Darling-B62", "code": "B62" }, { "name": "Clow", "code": "Clow" }, { "name": "End of Line Flushing Hydrant", "code": "Eclipse" }, { "name": "Kennedy-5S", "code": "5S" }, { "name": "US Pipe", "code": "US Pipe" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "YR_Install", "type": "esriFieldTypeSmallInteger", "alias": "YR_Install", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YR_Install" }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Source" }, { "name": "Project_Num", "type": "esriFieldTypeString", "alias": "Project_Num", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "Project_Num" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Comments" }, { "name": "GPS_Date", "type": "esriFieldTypeDate", "alias": "GPS_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "GPS_Date" }, { "name": "DISPLAY", "type": "esriFieldTypeString", "alias": "DISPLAY", "domain": { "type": "codedValue", "name": "WTR_Hyd_Display", "description": "Hydrant Display Type", "codedValues": [ { "name": "NWWSD", "code": "NWWSD" }, { "name": "Special status", "code": "SPECIAL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "DISPLAY" }, { "name": "EstAvgAccuracy", "type": "esriFieldTypeDouble", "alias": "EstAvgAccuracy", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EstAvgAccuracy" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Enabled" }, { "name": "GBALINK", "type": "esriFieldTypeInteger", "alias": "GBALINK", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GBALINK" }, { "name": "HYD_ID", "type": "esriFieldTypeString", "alias": "HYD_ID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "HYD_ID" }, { "name": "INGBAMS", "type": "esriFieldTypeSmallInteger", "alias": "INGBAMS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INGBAMS" }, { "name": "GPS_Status", "type": "esriFieldTypeString", "alias": "GPS_Status", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": "NULL", "modelName": "GPS_Status" }, { "name": "Location_Description", "type": "esriFieldTypeString", "alias": "Location_Description", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "Location_Description" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "MapCreate", "type": "esriFieldTypeString", "alias": "MapCreate", "domain": null, "editable": true, "nullable": true, "length": 225, "defaultValue": null, "modelName": "MapCreate" }, { "name": "MapCreate2", "type": "esriFieldTypeString", "alias": "MapCreate2", "domain": null, "editable": true, "nullable": true, "length": 225, "defaultValue": null, "modelName": "MapCreate2" }, { "name": "EOL", "type": "esriFieldTypeString", "alias": "EOL", "domain": { "type": "codedValue", "name": "EOL", "description": "End of Line Hydrant", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EOL" }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 125, "defaultValue": null, "modelName": "Location" }, { "name": "MeterReadStart", "type": "esriFieldTypeInteger", "alias": "MeterReadStart", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MeterReadStart" }, { "name": "MeterReadStop", "type": "esriFieldTypeInteger", "alias": "MeterReadStop", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MeterReadStop" }, { "name": "GF", "type": "esriFieldTypeSmallInteger", "alias": "GPM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GF" }, { "name": "Num_Min", "type": "esriFieldTypeSmallInteger", "alias": "Num_Min", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Num_Min" }, { "name": "CLStart", "type": "esriFieldTypeString", "alias": "CLStart", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CLStart" }, { "name": "CLStop", "type": "esriFieldTypeString", "alias": "CLStop", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CLStop" }, { "name": "Initials", "type": "esriFieldTypeString", "alias": "Initials", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Initials" }, { "name": "Estimate", "type": "esriFieldTypeInteger", "alias": "Estimate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Estimate" }, { "name": "HydCount", "type": "esriFieldTypeSmallInteger", "alias": "Hydrant Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HydCount" }, { "name": "AssetType", "type": "esriFieldTypeString", "alias": "AssetType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": "Hydrant", "modelName": "AssetType" }, { "name": "WOHydFlushStatus", "type": "esriFieldTypeString", "alias": "Hydrant Flushing WO Status", "domain": { "type": "codedValue", "name": "WTR_Hyd_Flush_Status", "description": "Status of hydrant flushing Work Order", "codedValues": [ { "name": "New Work Order", "code": "New Work Order" }, { "name": "Complete", "code": "Complete" }, { "name": "Closed In Field", "code": "Closed In Field" }, { "name": "Needs Painted", "code": "Needs Painted" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "WOHydFlushStatus" }, { "name": "LeadWorker", "type": "esriFieldTypeString", "alias": "Lead Worker", "domain": { "type": "codedValue", "name": "HydFlushLeadWrk", "description": "Hydrant flushing Lead worker", "codedValues": [ { "name": "Caleb Delaney", "code": "Caleb Delaney" }, { "name": "Tyler St.Clair", "code": "Tyler St.Clair" }, { "name": "Tyler Stone", "code": "Tyler Stone" }, { "name": "Water Quality", "code": "Water Quality" }, { "name": "Brandon Daniels", "code": "Brandon Daniels" }, { "name": "Trevor Berfield", "code": "Trevor Berfield" }, { "name": "Austin Murphy", "code": "Austin Murphy" }, { "name": "James Jenkins", "code": "James Jenkins" }, { "name": "Jonathan Wagler", "code": "Jonathan Wagler" }, { "name": "Cade Limes", "code": "Cade Limes" }, { "name": "Aaron Smith", "code": "Aaron Smith" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LeadWorker" }, { "name": "EndDate", "type": "esriFieldTypeDate", "alias": "End Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EndDate" }, { "name": "TurnsHard", "type": "esriFieldTypeString", "alias": "Turns Hard", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "TurnsHard" }, { "name": "FixValveBox", "type": "esriFieldTypeString", "alias": "Fix Valve Box", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "FixValveBox" }, { "name": "NeedsPumped", "type": "esriFieldTypeString", "alias": "NeedsPumped", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NeedsPumped" }, { "name": "HydrantBagged", "type": "esriFieldTypeString", "alias": "Hydrant Bagged", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "HydrantBagged" }, { "name": "OtherFollowUp", "type": "esriFieldTypeString", "alias": "OtherFollowUp", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "OtherFollowUp" }, { "name": "FollowUpDetails", "type": "esriFieldTypeString", "alias": "Follow Up Details", "domain": null, "editable": true, "nullable": true, "length": 175, "defaultValue": null, "modelName": "FollowUpDetails" }, { "name": "HydrantFlushingNotes", "type": "esriFieldTypeString", "alias": "Hydrant Flushing Notes", "domain": null, "editable": true, "nullable": true, "length": 175, "defaultValue": null, "modelName": "HydrantFlushingNotes" }, { "name": "WO_ID", "type": "esriFieldTypeInteger", "alias": "WO_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WO_ID" }, { "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": "CIF", "type": "esriFieldTypeSmallInteger", "alias": "Closed in Field", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "CIF" }, { "name": "NWO", "type": "esriFieldTypeSmallInteger", "alias": "New Work Order", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "NWO" }, { "name": "Complete", "type": "esriFieldTypeSmallInteger", "alias": "Complete", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Complete" }, { "name": "NeedsPainted", "type": "esriFieldTypeString", "alias": "NeedsPainted", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NeedsPainted" }, { "name": "Flushed", "type": "esriFieldTypeString", "alias": "Flushed", "domain": { "type": "codedValue", "name": "EOLFlushed", "description": "did end of line hydrant need flushed", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "Not Needed", "code": "Not Needed" }, { "name": "Needs Visited", "code": "Needs Visited" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Flushed" }, { "name": "entrypointCLstart", "type": "esriFieldTypeString", "alias": "Entry Point CL Start", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "entrypointCLstart" }, { "name": "entrypointclstop", "type": "esriFieldTypeString", "alias": "Entry Point CL Stop", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "entrypointclstop" }, { "name": "Needed_Oil", "type": "esriFieldTypeString", "alias": "Needed Oil", "domain": { "type": "codedValue", "name": "YN", "description": "YesNo", "codedValues": [ { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Needed_Oil" }, { "name": "PaintComplete", "type": "esriFieldTypeString", "alias": "PaintComplete", "domain": { "type": "codedValue", "name": "YN", "description": "YesNo", "codedValues": [ { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "PaintComplete" }, { "name": "PaintComment", "type": "esriFieldTypeString", "alias": "PaintComment", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "PaintComment" }, { "name": "DatePainted", "type": "esriFieldTypeDate", "alias": "Date Painted", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DatePainted" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R304_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I4216Hydrant_ID", "fields": "Hydrant_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_304", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_304", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a225_ix1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [ { "id": "Yes", "name": "Yes", "domains": { "Install_Type": {"type": "inherited"}, "Thread_Style": {"type": "inherited"}, "HYD_Drain": {"type": "inherited"}, "Manufacturer": {"type": "inherited"}, "DISPLAY": {"type": "inherited"}, "Enabled": {"type": "inherited"}, "EOL": {"type": "inherited"}, "WOHydFlushStatus": {"type": "inherited"}, "LeadWorker": {"type": "inherited"}, "TurnsHard": {"type": "inherited"}, "FixValveBox": {"type": "inherited"}, "NeedsPumped": {"type": "inherited"}, "HydrantBagged": {"type": "inherited"}, "OtherFollowUp": {"type": "inherited"}, "NeedsPainted": {"type": "inherited"}, "Flushed": {"type": "inherited"}, "Needed_Oil": {"type": "inherited"}, "PaintComplete": {"type": "inherited"} }, "templates": [ { "name": "Yes", "description": "", "prototype": { "attributes": { "INGBAMS": null, "PaintComment": null, "EstAvgAccuracy": null, "Thread_Style": "VALVE OPENING", "Model": null, "MapCreate2": null, "Hydrant_ID": " ", "Install_Type": "PARALLEL", "HYD_Drain": "SELF DRAINING", "Manufacturer": null, "YR_Install": null, "Source": null, "Project_Num": null, "Comments": null, "GPS_Date": null, "DISPLAY": null, "Enabled": 1, "GBALINK": null, "HYD_ID": null, "GPS_Status": "NULL", "Location_Description": null, "DatePainted": null, "MapCreate": null, "EOL": "Yes", "Date": null, "Location": null, "MeterReadStart": null, "MeterReadStop": null, "GF": null, "Num_Min": null, "CLStart": null, "CLStop": null, "Initials": null, "Estimate": null, "HydCount": null, "AssetType": "Hydrant", "WOHydFlushStatus": null, "LeadWorker": null, "EndDate": null, "TurnsHard": null, "FixValveBox": null, "NeedsPumped": null, "HydrantBagged": null, "OtherFollowUp": null, "FollowUpDetails": null, "HydrantFlushingNotes": null, "WO_ID": null, "PaintComplete": null, "Needed_Oil": null, "entrypointclstop": null, "entrypointCLstart": null, "CIF": 1, "NWO": 1, "Complete": 1, "NeedsPainted": null, "Flushed": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] } ], "templates": [], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Update,Delete,Uploads,Editing,Sync", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "Water_Main", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 1496226.3407399356, "ymin": 1.7881393432617188E-7, "xmax": 1814108.0552759916, "ymax": 714991.4527620673, "spatialReference": { "wkid": 102722, "latestWkid": 3734, "xyTolerance": 5.120000004768372E-4, "zTolerance": 2, "mTolerance": 0.001, "falseX": -118963900, "falseY": -96373800, "xyUnits": 3.7240637144144125E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102722, "latestWkid": 3734, "xyTolerance": 5.120000004768372E-4, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -1.189638999997993E8, "falseY": -9.637379999996291E7, "xyUnits": 15624.999985448083, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "Ownership", "defaultSymbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 115, 223, 255 ], "width": 3 }, "defaultLabel": "Owned by Others", "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 112, 255, 255 ], "width": 3 }, "value": "NWWSD", "label": "NWWSD" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "algorithmic", "algorithm": "esriHSVAlgorithm", "fromColor": [ 214, 214, 255, 255 ], "toColor": [ 0, 57, 148, 255 ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Material", "typeIdField": "Ownership", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Diameter" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "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" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Material" }, { "name": "Joint_Type", "type": "esriFieldTypeString", "alias": "Joint_Type", "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" }, "editable": true, "nullable": false, "length": 10, "defaultValue": "PUSH-ON", "modelName": "Joint_Type" }, { "name": "Poly_Wrap", "type": "esriFieldTypeString", "alias": "Poly_Wrap", "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" }, "editable": true, "nullable": false, "length": 3, "defaultValue": "NO", "modelName": "Poly_Wrap" }, { "name": "Lining", "type": "esriFieldTypeString", "alias": "Lining", "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" }, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "Lining" }, { "name": "Encasement", "type": "esriFieldTypeString", "alias": "Encasement", "domain": { "type": "codedValue", "name": "WTR_Encasement", "description": "Water Main Encasement", "codedValues": [ { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": false, "length": 3, "defaultValue": "NO", "modelName": "Encasement" }, { "name": "Length", "type": "esriFieldTypeDouble", "alias": "Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "As_Built" }, { "name": "As_Built", "type": "esriFieldTypeString", "alias": "As_Built", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "NO", "modelName": "As_Built" }, { "name": "Yr_Install", "type": "esriFieldTypeSmallInteger", "alias": "Yr_Install", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Yr_Install" }, { "name": "Project_Num", "type": "esriFieldTypeString", "alias": "Project_Num", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "Project_Num" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Comments" }, { "name": "Supplier", "type": "esriFieldTypeString", "alias": "Supplier", "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" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Supplier" }, { "name": "Ownership", "type": "esriFieldTypeString", "alias": "Ownership", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Ownership" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Enabled" }, { "name": "GBALINK", "type": "esriFieldTypeInteger", "alias": "GBALINK", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GBALINK" }, { "name": "WM_ID", "type": "esriFieldTypeString", "alias": "WM_ID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "WM_ID" }, { "name": "INGBAMS", "type": "esriFieldTypeSmallInteger", "alias": "INGBAMS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INGBAMS" }, { "name": "Line_Type", "type": "esriFieldTypeString", "alias": "Line Type", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Type" }, { "name": "Previous_Owner", "type": "esriFieldTypeString", "alias": "Previous_Owner", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Previous_Owner" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "SourcePDF", "type": "esriFieldTypeString", "alias": "SourcePDF", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "SourcePDF" }, { "name": "HyperlinkPDF", "type": "esriFieldTypeString", "alias": "HyperlinkPDF", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "HyperlinkPDF" }, { "name": "HLINK2", "type": "esriFieldTypeString", "alias": "Hyperlink", "domain": null, "editable": true, "nullable": true, "length": 125, "defaultValue": null, "modelName": "HLINK2" }, { "name": "PrjLinks", "type": "esriFieldTypeString", "alias": "PrjLinks", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "PrjLinks" }, { "name": "MapCreate", "type": "esriFieldTypeString", "alias": "MapCreate", "domain": null, "editable": true, "nullable": true, "length": 225, "defaultValue": null, "modelName": "MapCreate" }, { "name": "MapCreate2", "type": "esriFieldTypeString", "alias": "MapCreate2", "domain": null, "editable": true, "nullable": true, "length": 225, "defaultValue": null, "modelName": "MapCreate2" }, { "name": "wLineStatus", "type": "esriFieldTypeString", "alias": "wLineStatus", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "wLineStatus" }, { "name": "Prj_Status", "type": "esriFieldTypeString", "alias": "Project Status", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Prj_Status" }, { "name": "Prj_Name", "type": "esriFieldTypeString", "alias": "Project Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Prj_Name" }, { "name": "AssetType", "type": "esriFieldTypeString", "alias": "AssetType", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": "Water Main", "modelName": "AssetType" }, { "name": "TotalMiles", "type": "esriFieldTypeSingle", "alias": "TotalMiles", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalMiles" }, { "name": "ServiceLineType", "type": "esriFieldTypeString", "alias": "Service Line Type", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ServiceLineType" }, { "name": "ServiceAddress", "type": "esriFieldTypeString", "alias": "Service Address", "domain": null, "editable": true, "nullable": true, "length": 125, "defaultValue": null, "modelName": "ServiceAddress" }, { "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": "Condition", "type": "esriFieldTypeString", "alias": "Asset Condition Rating", "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" }, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Condition" }, { "name": "EstimatedLifeReached", "type": "esriFieldTypeString", "alias": "Estimated Life", "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" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "NumRepairs", "type": "esriFieldTypeSmallInteger", "alias": "Number of Main Repairs", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumRepairs" }, { "name": "LFPrj", "type": "esriFieldTypeSmallInteger", "alias": "Lineal Feet of Project", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LFPrj" }, { "name": "PWSID", "type": "esriFieldTypeString", "alias": "PWS ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PWSID" }, { "name": "Conseqoffailure", "type": "esriFieldTypeString", "alias": "Consequence of Failure", "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" }, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Conseqoffailure" }, { "name": "ConnectionsPerPrj", "type": "esriFieldTypeSmallInteger", "alias": "Number of Services per Project", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ConnectionsPerPrj" }, { "name": "Occurences", "type": "esriFieldTypeString", "alias": "Occurences", "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" }, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Occurences" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 225, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "NumNonlineRepairs", "type": "esriFieldTypeSmallInteger", "alias": "Number of Non-Line Repairs", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumNonlineRepairs" }, { "name": "DateofRepair", "type": "esriFieldTypeDate", "alias": "Date of Repair", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateofRepair" }, { "name": "EstimatedLife", "type": "esriFieldTypeString", "alias": "Estimated Life", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "EstimatedLife" }, { "name": "MainInspectedforLeaks", "type": "esriFieldTypeString", "alias": "Main Inspected for Leaks", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MainInspectedforLeaks" }, { "name": "LeakInspector", "type": "esriFieldTypeString", "alias": "Leak Inspector", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "LeakInspector" }, { "name": "DateInspected", "type": "esriFieldTypeDate", "alias": "Date Inspected", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateInspected" }, { "name": "LeakInspectorNotes", "type": "esriFieldTypeString", "alias": "Leak Inspector Notes", "domain": null, "editable": true, "nullable": true, "length": 225, "defaultValue": null, "modelName": "LeakInspectorNotes" }, { "name": "FieldPiclink", "type": "esriFieldTypeString", "alias": "Field Picture Link", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "FieldPiclink" }, { "name": "fieldpicweblink", "type": "esriFieldTypeString", "alias": "fieldpicweblink", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "fieldpicweblink" }, { "name": "TFL", "type": "esriFieldTypeDouble", "alias": "Total Lineal Feet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TFL" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.len", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "SHAPE.len" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [ { "id": "NWWSD", "name": "NWWSD", "domains": { "Main_Size": {"type": "inherited"}, "Material": {"type": "inherited"}, "Joint_Type": {"type": "inherited"}, "Poly_Wrap": {"type": "inherited"}, "Lining": {"type": "inherited"}, "Encasement": {"type": "inherited"}, "As_Built": {"type": "inherited"}, "Supplier": {"type": "inherited"}, "Enabled": {"type": "inherited"}, "Line_Type": {"type": "inherited"}, "wLineStatus": {"type": "inherited"}, "ServiceLineType": {"type": "inherited"}, "Condition": {"type": "inherited"}, "EstimatedLifeReached": {"type": "inherited"}, "Conseqoffailure": {"type": "inherited"}, "Occurences": {"type": "inherited"}, "MainInspectedforLeaks": {"type": "inherited"}, "LeakInspector": {"type": "inherited"} }, "templates": [ { "name": "NWWSD, Toledo", "description": "", "prototype": { "attributes": { "Length": null, "HyperlinkPDF": "http://maps.nwwsd.org/giswebapps/LINKS/WATERpdf/", "Comments": null, "Lining": null, "SourcePDF": null, "Material": "PVC", "Supplier": "TOL", "Ownership": "NWWSD", "Main_Size": null, "Joint_Type": "PUSH-ON", "TFL": null, "Poly_Wrap": "NO", "Encasement": "NO", "As_Built": "YES", "Yr_Install": null, "Project_Num": null, "Enabled": 1, "GBALINK": null, "WM_ID": null, "INGBAMS": null, "Line_Type": null, "Previous_Owner": null, "fieldpicweblink": null, "HLINK2": "V:\\LINKS\\WATERpdf\\", "PrjLinks": null, "MapCreate": null, "MapCreate2": null, "wLineStatus": null, "Prj_Status": null, "Prj_Name": null, "AssetType": "Water Main", "TotalMiles": null, "ServiceLineType": null, "ServiceAddress": null, "FieldPiclink": null, "LeakInspectorNotes": null, "DateInspected": null, "LeakInspector": null, "Condition": null, "EstimatedLifeReached": null, "NumRepairs": null, "LFPrj": null, "PWSID": null, "Conseqoffailure": null, "ConnectionsPerPrj": null, "Occurences": null, "AssetNotes": null, "NumNonlineRepairs": null, "DateofRepair": null, "EstimatedLife": null, "MainInspectedforLeaks": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "NWWSD, BOWLING GREEN", "description": "", "prototype": { "attributes": { "Length": null, "HyperlinkPDF": "http://maps.nwwsd.org/giswebapps/LINKS/WATERpdf/", "Comments": null, "Lining": null, "SourcePDF": null, "Material": "PVC", "Supplier": "BG", "Ownership": "NWWSD", "Main_Size": null, "Joint_Type": "PUSH-ON", "TFL": null, "Poly_Wrap": "NO", "Encasement": "NO", "As_Built": "YES", "Yr_Install": null, "Project_Num": null, "Enabled": 1, "GBALINK": null, "WM_ID": null, "INGBAMS": null, "Line_Type": null, "Previous_Owner": null, "fieldpicweblink": null, "HLINK2": "V:\\LINKS\\WATERpdf\\", "PrjLinks": null, "MapCreate": null, "MapCreate2": null, "wLineStatus": null, "Prj_Status": null, "Prj_Name": null, "AssetType": "Water Main", "TotalMiles": null, "ServiceLineType": null, "ServiceAddress": null, "FieldPiclink": null, "LeakInspectorNotes": null, "DateInspected": null, "LeakInspector": null, "Condition": null, "EstimatedLifeReached": null, "NumRepairs": null, "LFPrj": null, "PWSID": null, "Conseqoffailure": null, "ConnectionsPerPrj": null, "Occurences": null, "AssetNotes": null, "NumNonlineRepairs": null, "DateofRepair": null, "EstimatedLife": null, "MainInspectedforLeaks": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "NWWSD, OREGON", "description": "", "prototype": { "attributes": { "Length": null, "HyperlinkPDF": "http://maps.nwwsd.org/giswebapps/LINKS/WATERpdf/", "Comments": null, "Lining": null, "SourcePDF": null, "Material": "PVC", "Supplier": "OR", "Ownership": "NWWSD", "Main_Size": null, "Joint_Type": "PUSH-ON", "TFL": null, "Poly_Wrap": "NO", "Encasement": "NO", "As_Built": "YES", "Yr_Install": null, "Project_Num": null, "Enabled": 1, "GBALINK": null, "WM_ID": null, "INGBAMS": null, "Line_Type": null, "Previous_Owner": null, "fieldpicweblink": null, "HLINK2": "V:\\LINKS\\WATERpdf\\", "PrjLinks": null, "MapCreate": null, "MapCreate2": null, "wLineStatus": null, "Prj_Status": null, "Prj_Name": null, "AssetType": "Water Main", "TotalMiles": null, "ServiceLineType": null, "ServiceAddress": null, "FieldPiclink": null, "LeakInspectorNotes": null, "DateInspected": null, "LeakInspector": null, "Condition": null, "EstimatedLifeReached": null, "NumRepairs": null, "LFPrj": null, "PWSID": null, "Conseqoffailure": null, "ConnectionsPerPrj": null, "Occurences": null, "AssetNotes": null, "NumNonlineRepairs": null, "DateofRepair": null, "EstimatedLife": null, "MainInspectedforLeaks": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "NWWSD, PERRYSBURG", "description": "", "prototype": { "attributes": { "Length": null, "HyperlinkPDF": "http://maps.nwwsd.org/giswebapps/LINKS/WATERpdf/", "Comments": null, "Lining": null, "SourcePDF": null, "Material": "PVC", "Supplier": "PB", "Ownership": "NWWSD", "Main_Size": null, "Joint_Type": "PUSH-ON", "TFL": null, "Poly_Wrap": "NO", "Encasement": "NO", "As_Built": "YES", "Yr_Install": null, "Project_Num": null, "Enabled": 1, "GBALINK": null, "WM_ID": null, "INGBAMS": null, "Line_Type": null, "Previous_Owner": null, "fieldpicweblink": null, "HLINK2": "V:\\LINKS\\WATERpdf\\", "PrjLinks": null, "MapCreate": null, "MapCreate2": null, "wLineStatus": null, "Prj_Status": null, "Prj_Name": null, "AssetType": "Water Main", "TotalMiles": null, "ServiceLineType": null, "ServiceAddress": null, "FieldPiclink": null, "LeakInspectorNotes": null, "DateInspected": null, "LeakInspector": null, "Condition": null, "EstimatedLifeReached": null, "NumRepairs": null, "LFPrj": null, "PWSID": null, "Conseqoffailure": null, "ConnectionsPerPrj": null, "Occurences": null, "AssetNotes": null, "NumNonlineRepairs": null, "DateofRepair": null, "EstimatedLife": null, "MainInspectedforLeaks": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "NWWSD, FOSTORIA", "description": "", "prototype": { "attributes": { "Length": null, "HyperlinkPDF": "http://maps.nwwsd.org/giswebapps/LINKS/WATERpdf/", "Comments": null, "Lining": null, "SourcePDF": null, "Material": "PVC", "Supplier": "FOS", "Ownership": "NWWSD", "Main_Size": null, "Joint_Type": "PUSH-ON", "TFL": null, "Poly_Wrap": "NO", "Encasement": "NO", "As_Built": "YES", "Yr_Install": null, "Project_Num": null, "Enabled": 1, "GBALINK": null, "WM_ID": null, "INGBAMS": null, "Line_Type": null, "Previous_Owner": null, "fieldpicweblink": null, "HLINK2": "V:\\LINKS\\WATERpdf\\", "PrjLinks": null, "MapCreate": null, "MapCreate2": null, "wLineStatus": null, "Prj_Status": null, "Prj_Name": null, "AssetType": "Water Main", "TotalMiles": null, "ServiceLineType": null, "ServiceAddress": null, "FieldPiclink": null, "LeakInspectorNotes": null, "DateInspected": null, "LeakInspector": null, "Condition": null, "EstimatedLifeReached": null, "NumRepairs": null, "LFPrj": null, "PWSID": null, "Conseqoffailure": null, "ConnectionsPerPrj": null, "Occurences": null, "AssetNotes": null, "NumNonlineRepairs": null, "DateofRepair": null, "EstimatedLife": null, "MainInspectedforLeaks": null } }, "drawingTool": "esriFeatureEditToolLine" }, { "name": "NWWSD, BLOOMDALE", "description": "", "prototype": { "attributes": { "Length": null, "HyperlinkPDF": "http://maps.nwwsd.org/giswebapps/LINKS/WATERpdf/", "Comments": null, "Lining": null, "SourcePDF": null, "Material": "PVC", "Supplier": "BLOOM", "Ownership": "NWWSD", "Main_Size": null, "Joint_Type": "PUSH-ON", "TFL": null, "Poly_Wrap": "NO", "Encasement": "NO", "As_Built": "YES", "Yr_Install": null, "Project_Num": null, "Enabled": 1, "GBALINK": null, "WM_ID": null, "INGBAMS": null, "Line_Type": null, "Previous_Owner": null, "fieldpicweblink": null, "HLINK2": "V:\\LINKS\\WATERpdf\\", "PrjLinks": null, "MapCreate": null, "MapCreate2": null, "wLineStatus": null, "Prj_Status": null, "Prj_Name": null, "AssetType": "Water Main", "TotalMiles": null, "ServiceLineType": null, "ServiceAddress": null, "FieldPiclink": null, "LeakInspectorNotes": null, "DateInspected": null, "LeakInspector": null, "Condition": null, "EstimatedLifeReached": null, "NumRepairs": null, "LFPrj": null, "PWSID": null, "Conseqoffailure": null, "ConnectionsPerPrj": null, "Occurences": null, "AssetNotes": null, "NumNonlineRepairs": null, "DateofRepair": null, "EstimatedLife": null, "MainInspectedforLeaks": null } }, "drawingTool": "esriFeatureEditToolLine" } ] } ], "templates": [], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Update,Delete,Uploads,Editing,Sync", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [] }