{ "layers": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "Water Service Line Materials Verified", "type": "Feature Layer", "parentLayer": { "id": 0, "name": "Lead Inventory" }, "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": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsTrueCurve": true, "supportedCurveTypes": [ "esriGeometryCircularArc", "esriGeometryEllipticArc", "esriGeometryBezier3Curve" ], "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 2590285.4434062466, "ymin": 2077224.955628492, "xmax": 2644168.0810475796, "ymax": 2117440.1993448213, "spatialReference": { "wkid": 102714, "latestWkid": 2259, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -15723900, "falseY": -44067900, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "spatialReference": { "wkid": 102714, "latestWkid": 2259, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -15723900, "falseY": -44067900, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "sourceSpatialReference": { "wkid": 102714, "latestWkid": 2259, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -15723900, "falseY": -44067900, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "MaterialVerified", "uniqueValueGroups": [ { "heading": "Both Materials Verified", "classes": [ { "label": "No", "description": "No", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 2 }, "values": [ [ "No" ] ] }, { "label": "Yes", "description": "Yes", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 76, 230, 0, 255 ], "width": 2 }, "values": [ [ "Yes" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 2 }, "value": "No", "label": "No" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 76, 230, 0, 255 ], "width": 2 }, "value": "Yes", "label": "Yes" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 197, 184, 252, 255 ], "toColor": [ 197, 184, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 190, 252, 182, 255 ], "toColor": [ 190, 252, 182, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 199, 179, 255 ], "toColor": [ 252, 199, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 215, 251, 252, 255 ], "toColor": [ 215, 251, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 184, 223, 255 ], "toColor": [ 252, 184, 223, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 249, 202, 255 ], "toColor": [ 252, 249, 202, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 212, 252, 255 ], "toColor": [ 182, 212, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 202, 252, 220, 255 ], "toColor": [ 202, 252, 220, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 230, 212, 252, 255 ], "toColor": [ 230, 212, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 212, 223, 255 ], "toColor": [ 252, 212, 223, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 233, 179, 252, 255 ], "toColor": [ 233, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 232, 215, 255 ], "toColor": [ 252, 232, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 227, 252, 179, 255 ], "toColor": [ 227, 252, 179, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "INSTALLDATE", "typeIdField": "MaterialVerified", "subtypeField": "", "fields": [ { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()", "required": true }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "EAMID", "type": "esriFieldTypeString", "alias": "EAM ID", "domain": null, "editable": false, "nullable": true, "length": 25, "defaultValue": null, "modelName": "EAMID" }, { "name": "DIAMETER", "type": "esriFieldTypeString", "alias": "Diameter", "domain": { "type": "codedValue", "name": "wwPipeSize", "description": "The size of the Waste Water Pipe Size", "codedValues": [ { "name": "1 Inch", "code": "1" }, { "name": "1.25 Inch", "code": "1.25" }, { "name": "1.5 Inch", "code": "1.5" }, { "name": "1.75 Inch", "code": "1.75" }, { "name": "0.50 Inch", "code": "1/2" }, { "name": "0.25 Inch", "code": "1/4" }, { "name": "10 Inch", "code": "10" }, { "name": "12 Inch", "code": "12" }, { "name": "15 Inch", "code": "15" }, { "name": "16 Inch", "code": "16" }, { "name": "18 Inch", "code": "18" }, { "name": "2 Inch", "code": "2" }, { "name": "20 Inch", "code": "20" }, { "name": "21 Inch", "code": "21" }, { "name": "24 Inch", "code": "24" }, { "name": "27 Inch", "code": "27" }, { "name": "3 Inch", "code": "3" }, { "name": "0.75 Inch", "code": "3/4" }, { "name": "30 Inch", "code": "30" }, { "name": "36 Inch", "code": "36" }, { "name": "4 Inch", "code": "4" }, { "name": "5 Inch", "code": "5" }, { "name": "6 Inch", "code": "6" }, { "name": "7.25 Inch", "code": "7.25" }, { "name": "8 Inch", "code": "8" }, { "name": "0.75 Inch", "code": "0.75" }, { "name": "42 Inch", "code": "42" }, { "name": "48 Inch", "code": "48" }, { "name": "60 Inch", "code": "60" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 8, "defaultValue": "1", "modelName": "DIAMETER" }, { "name": "CitySidePipeMat", "type": "esriFieldTypeString", "alias": "City Side Pipe Material", "domain": { "type": "codedValue", "name": "wwPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Concrete", "code": "CON" }, { "name": "Copper", "code": "COP" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Drain Line", "code": "DL" }, { "name": "Earthen", "code": "EAR" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Fire Line", "code": "FL" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Other", "code": "OTH" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "STL" }, { "name": "Transite", "code": "TTE" }, { "name": "Unknown", "code": "UNK" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Sliplined", "code": "Sliplined" }, { "name": "Asbestos Cement Smooth", "code": "ACS" }, { "name": "Asbestos Cement Rough", "code": "ACR" }, { "name": "Non-Lead", "code": "NL" }, { "name": "Lead", "code": "L" }, { "name": "Lead Status Unknown", "code": "LSU" }, { "name": "Polybutylene", "code": "PB" }, { "name": "Possibly Lead", "code": "PL" }, { "name": "PEX", "code": "PEX" }, { "name": "Black Polyethylene", "code": "Poly" }, { "name": "Plastic", "code": "PLA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "LSU", "modelName": "CitySidePipeMat" }, { "name": "CustomSidePipeMat", "type": "esriFieldTypeString", "alias": "Customer Side Pipe Material", "domain": { "type": "codedValue", "name": "wwPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Concrete", "code": "CON" }, { "name": "Copper", "code": "COP" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Drain Line", "code": "DL" }, { "name": "Earthen", "code": "EAR" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Fire Line", "code": "FL" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Other", "code": "OTH" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "STL" }, { "name": "Transite", "code": "TTE" }, { "name": "Unknown", "code": "UNK" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Sliplined", "code": "Sliplined" }, { "name": "Asbestos Cement Smooth", "code": "ACS" }, { "name": "Asbestos Cement Rough", "code": "ACR" }, { "name": "Non-Lead", "code": "NL" }, { "name": "Lead", "code": "L" }, { "name": "Lead Status Unknown", "code": "LSU" }, { "name": "Polybutylene", "code": "PB" }, { "name": "Possibly Lead", "code": "PL" }, { "name": "PEX", "code": "PEX" }, { "name": "Black Polyethylene", "code": "Poly" }, { "name": "Plastic", "code": "PLA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "LSU", "modelName": "CustomSidePipeMat" }, { "name": "CityCnnectrs_LeadGalv", "type": "esriFieldTypeString", "alias": "City Side Connectors Lead or Galv", "domain": { "type": "codedValue", "name": "wServiceLineConnectorLeadOrGalv", "description": "", "codedValues": [ { "name": "Lead", "code": "Lead" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Galvanized", "code": "Galvanized" }, { "name": "Both Lead and Galvanized", "code": "Both Lead and Galvanized" }, { "name": "Non Lead/Galvanized", "code": "Non Lead/Galvanized" }, { "name": "Non Lead", "code": "Non Lead" }, { "name": "Copper", "code": "Copper" }, { "name": "Plastic", "code": "Plastic" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Unknown", "modelName": "CityCnnectrs_LeadGalv" }, { "name": "CustomerCnnectrs_LeadGalv", "type": "esriFieldTypeString", "alias": "Customer Side Connectors Lead or Galv", "domain": { "type": "codedValue", "name": "wServiceLineConnectorLeadOrGalv", "description": "", "codedValues": [ { "name": "Lead", "code": "Lead" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Galvanized", "code": "Galvanized" }, { "name": "Both Lead and Galvanized", "code": "Both Lead and Galvanized" }, { "name": "Non Lead/Galvanized", "code": "Non Lead/Galvanized" }, { "name": "Non Lead", "code": "Non Lead" }, { "name": "Copper", "code": "Copper" }, { "name": "Plastic", "code": "Plastic" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Unknown", "modelName": "CustomerCnnectrs_LeadGalv" }, { "name": "MaterialVerified", "type": "esriFieldTypeString", "alias": "Both Materials Verified", "domain": { "type": "codedValue", "name": "Yes No", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "No", "modelName": "MaterialVerified" }, { "name": "MaterialDateVerified", "type": "esriFieldTypeDate", "alias": "Date Materials Verified", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MaterialDateVerified" }, { "name": "MaterialVerifiedBy", "type": "esriFieldTypeString", "alias": "Material Verified By", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "MaterialVerifiedBy" }, { "name": "MaterialVerificationTechnique", "type": "esriFieldTypeString", "alias": "Material Verification Technique", "domain": { "type": "codedValue", "name": "wServiceLineVerifTechnique", "description": "Technique in which water service lines were verfied", "codedValues": [ { "name": "Field Verification", "code": "Field Verification" }, { "name": "Desk Review/Historic Documents", "code": "Desk Review/Historic Documents" }, { "name": "Other. See Material Notes", "code": "Other. See Material Notes" }, { "name": "Swordfish", "code": "Swordfish" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaterialVerificationTechnique" }, { "name": "MaterialVerificationNotes", "type": "esriFieldTypeString", "alias": "Material Verification Notes", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "MaterialVerificationNotes" }, { "name": "SwordfishComplete", "type": "esriFieldTypeString", "alias": "Swordfish Complete", "domain": { "type": "codedValue", "name": "wSwordfishComplete", "description": "", "codedValues": [ { "name": "City Side Complete", "code": "City Side Complete" }, { "name": "Customer Side Complete", "code": "Customer Side Complete" }, { "name": "Both Sides Complete", "code": "Both Sides Complete" }, { "name": "Not Complete", "code": "Not Complete" }, { "name": "Swordfish Not Needed", "code": "Swordfish Not Needed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Not Complete", "modelName": "SwordfishComplete" }, { "name": "DateSwordfishComplete", "type": "esriFieldTypeDate", "alias": "Date Swordfish Complete", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateSwordfishComplete" }, { "name": "ExcavationNeeded", "type": "esriFieldTypeString", "alias": "Excavation Needed For Verification", "domain": { "type": "codedValue", "name": "Yes No", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ExcavationNeeded" }, { "name": "LocationApproved", "type": "esriFieldTypeString", "alias": "Location Approved", "domain": { "type": "codedValue", "name": "Yes No", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 255, "defaultValue": "No", "modelName": "LocationApproved" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": false, "nullable": true, "length": 300, "defaultValue": null, "modelName": "NOTES" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Address" }, { "name": "OWNEDBY", "type": "esriFieldTypeString", "alias": "Owned By", "domain": { "type": "codedValue", "name": "wdoAssetOwner", "description": "Asset Owner of the Water Main", "codedValues": [ { "name": "City of Aztec", "code": "COA" }, { "name": "City of Bloomfield", "code": "COB" }, { "name": "City of Farmington", "code": "COF" }, { "name": "Federal", "code": "Federal" }, { "name": "Jacobs", "code": "Jacobs" }, { "name": "State of New Mexico", "code": "NM" }, { "name": "Other", "code": "Other" }, { "name": "Private", "code": "Private" }, { "name": "San Juan County", "code": "SJC" }, { "name": "Town of Kirtland", "code": "TOK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 25, "defaultValue": "COF", "modelName": "OWNEDBY" }, { "name": "LIFECYCLE", "type": "esriFieldTypeString", "alias": "Lifecycle", "domain": { "type": "codedValue", "name": "wwStatus", "description": "Indicates if the feature is in use/active", "codedValues": [ { "name": "Abandon", "code": "Abandon" }, { "name": "Active", "code": "Active" }, { "name": "Removed", "code": "Removed" }, { "name": "Non Existent", "code": "Non" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 255, "defaultValue": "Active", "modelName": "LIFECYCLE" }, { "name": "InstallYear", "type": "esriFieldTypeString", "alias": "Install Year", "domain": null, "editable": false, "nullable": true, "length": 4, "defaultValue": null, "modelName": "InstallYear" }, { "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": "INSTALLEDBY", "type": "esriFieldTypeString", "alias": "Installed By", "domain": { "type": "codedValue", "name": "wsSLInstaller", "description": "Service Line Installer", "codedValues": [ { "name": "Jacobs", "code": "Jacobs" }, { "name": "K&G", "code": "KG" }, { "name": "Other - See Notes", "code": "Other" }, { "name": "TRC", "code": "TRC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "INSTALLEDBY" }, { "name": "Exception", "type": "esriFieldTypeString", "alias": "Exception", "domain": { "type": "codedValue", "name": "Yes No", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Exception" }, { "name": "ExceptionC", "type": "esriFieldTypeString", "alias": "Exception Comments", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ExceptionC" }, { "name": "Meter_Loc_ID", "type": "esriFieldTypeString", "alias": "Meter_Loc_ID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Meter_Loc_ID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "EAMArea", "type": "esriFieldTypeDouble", "alias": "EAM Area", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "EAMArea" }, { "name": "Lucity_ID", "type": "esriFieldTypeInteger", "alias": "Lucity ID", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Lucity_ID" }, { "name": "TapClockLocation", "type": "esriFieldTypeString", "alias": "Tap Clock Location", "domain": { "type": "codedValue", "name": "wwTapClockLocation", "description": "", "codedValues": [ { "name": "1 o'clock", "code": "1" }, { "name": "2 o'clock", "code": "2" }, { "name": "3 o'clock", "code": "3" }, { "name": "4 o'clock", "code": "4" }, { "name": "5 o'clock", "code": "5" }, { "name": "6 o'clock", "code": "6" }, { "name": "7 o'clock", "code": "7" }, { "name": "8 o'clock", "code": "8" }, { "name": "9 o'clock", "code": "9" }, { "name": "10 o'clock", "code": "10" }, { "name": "11 o'clock", "code": "11" }, { "name": "12 o'clock", "code": "12" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 20, "defaultValue": null, "modelName": "TapClockLocation" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R235_pk", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "UUID_235", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID" }, { "name": "S133_idx", "isAscending": true, "isUnique": true, "description": "", "fields": "Shape" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [ { "id": "No", "name": "No", "domains": { "DIAMETER": {"type": "inherited"}, "CitySidePipeMat": {"type": "inherited"}, "CustomSidePipeMat": {"type": "inherited"}, "CityCnnectrs_LeadGalv": {"type": "inherited"}, "CustomerCnnectrs_LeadGalv": {"type": "inherited"}, "MaterialVerified": {"type": "inherited"}, "MaterialVerificationTechnique": {"type": "inherited"}, "SwordfishComplete": {"type": "inherited"}, "ExcavationNeeded": {"type": "inherited"}, "LocationApproved": {"type": "inherited"}, "OWNEDBY": {"type": "inherited"}, "LIFECYCLE": {"type": "inherited"}, "INSTALLEDBY": {"type": "inherited"}, "Exception": {"type": "inherited"}, "TapClockLocation": {"type": "inherited"} }, "templates": [ { "name": "Water Service Line", "description": "", "prototype": { "attributes": { "SwordfishComplete": "Not Complete", "DateSwordfishComplete": null, "MaterialVerificationNotes": null, "ExcavationNeeded": null, "CitySidePipeMat": "LSU", "CustomSidePipeMat": "LSU", "CityCnnectrs_LeadGalv": "Unknown", "CustomerCnnectrs_LeadGalv": "Unknown", "MaterialVerified": "No", "MaterialDateVerified": null, "MaterialVerifiedBy": null, "MaterialVerificationTechnique": null } }, "drawingTool": "esriFeatureEditToolLine" } ] }, { "id": "Yes", "name": "Yes", "domains": { "DIAMETER": {"type": "inherited"}, "CitySidePipeMat": {"type": "inherited"}, "CustomSidePipeMat": {"type": "inherited"}, "CityCnnectrs_LeadGalv": {"type": "inherited"}, "CustomerCnnectrs_LeadGalv": {"type": "inherited"}, "MaterialVerified": {"type": "inherited"}, "MaterialVerificationTechnique": {"type": "inherited"}, "SwordfishComplete": {"type": "inherited"}, "ExcavationNeeded": {"type": "inherited"}, "LocationApproved": {"type": "inherited"}, "OWNEDBY": {"type": "inherited"}, "LIFECYCLE": {"type": "inherited"}, "INSTALLEDBY": {"type": "inherited"}, "Exception": {"type": "inherited"}, "TapClockLocation": {"type": "inherited"} }, "templates": [ { "name": "Yes", "description": "", "prototype": { "attributes": { "MaterialVerificationNotes": null, "MaterialVerificationTechnique": null, "SwordfishComplete": "Not Complete", "DateSwordfishComplete": null, "ExcavationNeeded": null, "CitySidePipeMat": "LSU", "CustomSidePipeMat": "LSU", "CityCnnectrs_LeadGalv": "Unknown", "CustomerCnnectrs_LeadGalv": "Unknown", "MaterialVerified": "Yes", "MaterialDateVerified": null, "MaterialVerifiedBy": null } }, "drawingTool": "esriFeatureEditToolLine" } ] } ], "templates": [], "maxRecordCount": 18000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "55065febea214b498055aef4d968462c" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "Water Service Line Swordfished", "type": "Feature Layer", "parentLayer": { "id": 0, "name": "Lead Inventory" }, "defaultVisibility": false, "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": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsTrueCurve": true, "supportedCurveTypes": [ "esriGeometryCircularArc", "esriGeometryEllipticArc", "esriGeometryBezier3Curve" ], "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 2590285.4434062466, "ymin": 2077224.955628492, "xmax": 2644168.0810475796, "ymax": 2117440.1993448213, "spatialReference": { "wkid": 102714, "latestWkid": 2259, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -15723900, "falseY": -44067900, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "spatialReference": { "wkid": 102714, "latestWkid": 2259, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -15723900, "falseY": -44067900, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "sourceSpatialReference": { "wkid": 102714, "latestWkid": 2259, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -15723900, "falseY": -44067900, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "SwordfishComplete", "uniqueValueGroups": [ { "heading": "Swordfish Complete", "classes": [ { "label": "Swordfish Not Needed", "description": "Swordfish Not Needed", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 76, 230, 0, 255 ], "width": 2 }, "values": [ [ "Swordfish Not Needed" ] ] }, { "label": "Both Sides Complete", "description": "Both Sides Complete", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 76, 230, 0, 255 ], "width": 2 }, "values": [ [ "Both Sides Complete" ] ] }, { "label": "City Side Complete", "description": "City Side Complete", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 112, 255, 255 ], "width": 2 }, "values": [ [ "City Side Complete" ] ] }, { "label": "Customer Side Complete", "description": "Customer Side Complete", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 0, 255 ], "width": 2 }, "values": [ [ "Customer Side Complete" ] ] }, { "label": "Not Complete", "description": "Not Complete", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 85, 0, 255 ], "width": 2 }, "values": [ [ "Not Complete" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 76, 230, 0, 255 ], "width": 2 }, "value": "Swordfish Not Needed", "label": "Swordfish Not Needed" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 76, 230, 0, 255 ], "width": 2 }, "value": "Both Sides Complete", "label": "Both Sides Complete" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 112, 255, 255 ], "width": 2 }, "value": "City Side Complete", "label": "City Side Complete" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 0, 255 ], "width": 2 }, "value": "Customer Side Complete", "label": "Customer Side Complete" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 85, 0, 255 ], "width": 2 }, "value": "Not Complete", "label": "Not Complete" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 197, 184, 252, 255 ], "toColor": [ 197, 184, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 190, 252, 182, 255 ], "toColor": [ 190, 252, 182, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 199, 179, 255 ], "toColor": [ 252, 199, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 215, 251, 252, 255 ], "toColor": [ 215, 251, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 184, 223, 255 ], "toColor": [ 252, 184, 223, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 249, 202, 255 ], "toColor": [ 252, 249, 202, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 212, 252, 255 ], "toColor": [ 182, 212, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 202, 252, 220, 255 ], "toColor": [ 202, 252, 220, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 230, 212, 252, 255 ], "toColor": [ 230, 212, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 212, 223, 255 ], "toColor": [ 252, 212, 223, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 233, 179, 252, 255 ], "toColor": [ 233, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 232, 215, 255 ], "toColor": [ 252, 232, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 227, 252, 179, 255 ], "toColor": [ 227, 252, 179, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "INSTALLDATE", "typeIdField": "SwordfishComplete", "subtypeField": "", "fields": [ { "name": "EAMID", "type": "esriFieldTypeString", "alias": "EAM ID", "domain": null, "editable": false, "nullable": true, "length": 25, "defaultValue": null, "modelName": "EAMID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "DIAMETER", "type": "esriFieldTypeString", "alias": "Diameter", "domain": { "type": "codedValue", "name": "wwPipeSize", "description": "The size of the Waste Water Pipe Size", "codedValues": [ { "name": "1 Inch", "code": "1" }, { "name": "1.25 Inch", "code": "1.25" }, { "name": "1.5 Inch", "code": "1.5" }, { "name": "1.75 Inch", "code": "1.75" }, { "name": "0.50 Inch", "code": "1/2" }, { "name": "0.25 Inch", "code": "1/4" }, { "name": "10 Inch", "code": "10" }, { "name": "12 Inch", "code": "12" }, { "name": "15 Inch", "code": "15" }, { "name": "16 Inch", "code": "16" }, { "name": "18 Inch", "code": "18" }, { "name": "2 Inch", "code": "2" }, { "name": "20 Inch", "code": "20" }, { "name": "21 Inch", "code": "21" }, { "name": "24 Inch", "code": "24" }, { "name": "27 Inch", "code": "27" }, { "name": "3 Inch", "code": "3" }, { "name": "0.75 Inch", "code": "3/4" }, { "name": "30 Inch", "code": "30" }, { "name": "36 Inch", "code": "36" }, { "name": "4 Inch", "code": "4" }, { "name": "5 Inch", "code": "5" }, { "name": "6 Inch", "code": "6" }, { "name": "7.25 Inch", "code": "7.25" }, { "name": "8 Inch", "code": "8" }, { "name": "0.75 Inch", "code": "0.75" }, { "name": "42 Inch", "code": "42" }, { "name": "48 Inch", "code": "48" }, { "name": "60 Inch", "code": "60" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 8, "defaultValue": "1", "modelName": "DIAMETER" }, { "name": "CitySidePipeMat", "type": "esriFieldTypeString", "alias": "City Side Pipe Material", "domain": { "type": "codedValue", "name": "wwPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Concrete", "code": "CON" }, { "name": "Copper", "code": "COP" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Drain Line", "code": "DL" }, { "name": "Earthen", "code": "EAR" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Fire Line", "code": "FL" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Other", "code": "OTH" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "STL" }, { "name": "Transite", "code": "TTE" }, { "name": "Unknown", "code": "UNK" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Sliplined", "code": "Sliplined" }, { "name": "Asbestos Cement Smooth", "code": "ACS" }, { "name": "Asbestos Cement Rough", "code": "ACR" }, { "name": "Non-Lead", "code": "NL" }, { "name": "Lead", "code": "L" }, { "name": "Lead Status Unknown", "code": "LSU" }, { "name": "Polybutylene", "code": "PB" }, { "name": "Possibly Lead", "code": "PL" }, { "name": "PEX", "code": "PEX" }, { "name": "Black Polyethylene", "code": "Poly" }, { "name": "Plastic", "code": "PLA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "LSU", "modelName": "CitySidePipeMat" }, { "name": "CustomSidePipeMat", "type": "esriFieldTypeString", "alias": "Customer Side Pipe Material", "domain": { "type": "codedValue", "name": "wwPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Concrete", "code": "CON" }, { "name": "Copper", "code": "COP" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Drain Line", "code": "DL" }, { "name": "Earthen", "code": "EAR" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Fire Line", "code": "FL" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Other", "code": "OTH" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "STL" }, { "name": "Transite", "code": "TTE" }, { "name": "Unknown", "code": "UNK" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Sliplined", "code": "Sliplined" }, { "name": "Asbestos Cement Smooth", "code": "ACS" }, { "name": "Asbestos Cement Rough", "code": "ACR" }, { "name": "Non-Lead", "code": "NL" }, { "name": "Lead", "code": "L" }, { "name": "Lead Status Unknown", "code": "LSU" }, { "name": "Polybutylene", "code": "PB" }, { "name": "Possibly Lead", "code": "PL" }, { "name": "PEX", "code": "PEX" }, { "name": "Black Polyethylene", "code": "Poly" }, { "name": "Plastic", "code": "PLA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "LSU", "modelName": "CustomSidePipeMat" }, { "name": "CityCnnectrs_LeadGalv", "type": "esriFieldTypeString", "alias": "City Side Connectors Lead or Galv", "domain": { "type": "codedValue", "name": "wServiceLineConnectorLeadOrGalv", "description": "", "codedValues": [ { "name": "Lead", "code": "Lead" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Galvanized", "code": "Galvanized" }, { "name": "Both Lead and Galvanized", "code": "Both Lead and Galvanized" }, { "name": "Non Lead/Galvanized", "code": "Non Lead/Galvanized" }, { "name": "Non Lead", "code": "Non Lead" }, { "name": "Copper", "code": "Copper" }, { "name": "Plastic", "code": "Plastic" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Unknown", "modelName": "CityCnnectrs_LeadGalv" }, { "name": "CustomerCnnectrs_LeadGalv", "type": "esriFieldTypeString", "alias": "Customer Side Connectors Lead or Galv", "domain": { "type": "codedValue", "name": "wServiceLineConnectorLeadOrGalv", "description": "", "codedValues": [ { "name": "Lead", "code": "Lead" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Galvanized", "code": "Galvanized" }, { "name": "Both Lead and Galvanized", "code": "Both Lead and Galvanized" }, { "name": "Non Lead/Galvanized", "code": "Non Lead/Galvanized" }, { "name": "Non Lead", "code": "Non Lead" }, { "name": "Copper", "code": "Copper" }, { "name": "Plastic", "code": "Plastic" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Unknown", "modelName": "CustomerCnnectrs_LeadGalv" }, { "name": "MaterialVerified", "type": "esriFieldTypeString", "alias": "Both Materials Verified", "domain": { "type": "codedValue", "name": "Yes No", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "No", "modelName": "MaterialVerified" }, { "name": "MaterialDateVerified", "type": "esriFieldTypeDate", "alias": "Date Materials Verified", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MaterialDateVerified" }, { "name": "MaterialVerifiedBy", "type": "esriFieldTypeString", "alias": "Materials Verified By", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "MaterialVerifiedBy" }, { "name": "MaterialVerificationTechnique", "type": "esriFieldTypeString", "alias": "Material Verification Technique", "domain": { "type": "codedValue", "name": "wServiceLineVerifTechnique", "description": "Technique in which water service lines were verfied", "codedValues": [ { "name": "Field Verification", "code": "Field Verification" }, { "name": "Desk Review/Historic Documents", "code": "Desk Review/Historic Documents" }, { "name": "Other. See Material Notes", "code": "Other. See Material Notes" }, { "name": "Swordfish", "code": "Swordfish" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaterialVerificationTechnique" }, { "name": "MaterialVerificationNotes", "type": "esriFieldTypeString", "alias": "Material Verification Notes", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "MaterialVerificationNotes" }, { "name": "ExcavationNeeded", "type": "esriFieldTypeString", "alias": "Excavation Needed For Verification", "domain": { "type": "codedValue", "name": "Yes No", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ExcavationNeeded" }, { "name": "SwordfishComplete", "type": "esriFieldTypeString", "alias": "Swordfish Complete", "domain": { "type": "codedValue", "name": "wSwordfishComplete", "description": "", "codedValues": [ { "name": "City Side Complete", "code": "City Side Complete" }, { "name": "Customer Side Complete", "code": "Customer Side Complete" }, { "name": "Both Sides Complete", "code": "Both Sides Complete" }, { "name": "Not Complete", "code": "Not Complete" }, { "name": "Swordfish Not Needed", "code": "Swordfish Not Needed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Not Complete", "modelName": "SwordfishComplete" }, { "name": "DateSwordfishComplete", "type": "esriFieldTypeDate", "alias": "Date Swordfish Complete", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateSwordfishComplete" }, { "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 Edit User", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "InstallYear", "type": "esriFieldTypeString", "alias": "Install Year", "domain": null, "editable": false, "nullable": true, "length": 4, "defaultValue": null, "modelName": "InstallYear" }, { "name": "LocationApproved", "type": "esriFieldTypeString", "alias": "Location Approved", "domain": { "type": "codedValue", "name": "Yes No", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 255, "defaultValue": "No", "modelName": "LocationApproved" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Address" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [ { "id": "Swordfish Not Needed", "name": "Swordfish Not Needed", "domains": { "DIAMETER": {"type": "inherited"}, "CitySidePipeMat": {"type": "inherited"}, "CustomSidePipeMat": {"type": "inherited"}, "CityCnnectrs_LeadGalv": {"type": "inherited"}, "CustomerCnnectrs_LeadGalv": {"type": "inherited"}, "MaterialVerified": {"type": "inherited"}, "MaterialVerificationTechnique": {"type": "inherited"}, "ExcavationNeeded": {"type": "inherited"}, "SwordfishComplete": {"type": "inherited"}, "LocationApproved": {"type": "inherited"}, "OWNEDBY": {"type": "inherited"}, "LIFECYCLE": {"type": "inherited"}, "INSTALLEDBY": {"type": "inherited"}, "Exception": {"type": "inherited"}, "TapClockLocation": {"type": "inherited"} }, "templates": [ { "name": "Swordfish Not Needed", "description": "", "prototype": { "attributes": { "MaterialVerificationNotes": null, "SwordfishComplete": "Swordfish Not Needed", "ExcavationNeeded": null, "DateSwordfishComplete": null, "CitySidePipeMat": "LSU", "CustomSidePipeMat": "LSU", "CityCnnectrs_LeadGalv": "Unknown", "CustomerCnnectrs_LeadGalv": "Unknown", "MaterialVerified": "No", "MaterialDateVerified": null, "MaterialVerifiedBy": null, "MaterialVerificationTechnique": null } }, "drawingTool": "esriFeatureEditToolLine" } ] }, { "id": "Both Sides Complete", "name": "Both Sides Complete", "domains": { "DIAMETER": {"type": "inherited"}, "CitySidePipeMat": {"type": "inherited"}, "CustomSidePipeMat": {"type": "inherited"}, "CityCnnectrs_LeadGalv": {"type": "inherited"}, "CustomerCnnectrs_LeadGalv": {"type": "inherited"}, "MaterialVerified": {"type": "inherited"}, "MaterialVerificationTechnique": {"type": "inherited"}, "ExcavationNeeded": {"type": "inherited"}, "SwordfishComplete": {"type": "inherited"}, "LocationApproved": {"type": "inherited"}, "OWNEDBY": {"type": "inherited"}, "LIFECYCLE": {"type": "inherited"}, "INSTALLEDBY": {"type": "inherited"}, "Exception": {"type": "inherited"}, "TapClockLocation": {"type": "inherited"} }, "templates": [ { "name": "Both Sides Complete", "description": "", "prototype": { "attributes": { "MaterialVerificationNotes": null, "SwordfishComplete": "Both Sides Complete", "ExcavationNeeded": null, "DateSwordfishComplete": null, "CitySidePipeMat": "LSU", "CustomSidePipeMat": "LSU", "CityCnnectrs_LeadGalv": "Unknown", "CustomerCnnectrs_LeadGalv": "Unknown", "MaterialVerified": "No", "MaterialDateVerified": null, "MaterialVerifiedBy": null, "MaterialVerificationTechnique": null } }, "drawingTool": "esriFeatureEditToolLine" } ] }, { "id": "City Side Complete", "name": "City Side Complete", "domains": { "DIAMETER": {"type": "inherited"}, "CitySidePipeMat": {"type": "inherited"}, "CustomSidePipeMat": {"type": "inherited"}, "CityCnnectrs_LeadGalv": {"type": "inherited"}, "CustomerCnnectrs_LeadGalv": {"type": "inherited"}, "MaterialVerified": {"type": "inherited"}, "MaterialVerificationTechnique": {"type": "inherited"}, "ExcavationNeeded": {"type": "inherited"}, "SwordfishComplete": {"type": "inherited"}, "LocationApproved": {"type": "inherited"}, "OWNEDBY": {"type": "inherited"}, "LIFECYCLE": {"type": "inherited"}, "INSTALLEDBY": {"type": "inherited"}, "Exception": {"type": "inherited"}, "TapClockLocation": {"type": "inherited"} }, "templates": [ { "name": "City Side Complete", "description": "", "prototype": { "attributes": { "MaterialVerificationNotes": null, "SwordfishComplete": "City Side Complete", "ExcavationNeeded": null, "DateSwordfishComplete": null, "CitySidePipeMat": "LSU", "CustomSidePipeMat": "LSU", "CityCnnectrs_LeadGalv": "Unknown", "CustomerCnnectrs_LeadGalv": "Unknown", "MaterialVerified": "No", "MaterialDateVerified": null, "MaterialVerifiedBy": null, "MaterialVerificationTechnique": null } }, "drawingTool": "esriFeatureEditToolLine" } ] }, { "id": "Customer Side Complete", "name": "Customer Side Complete", "domains": { "DIAMETER": {"type": "inherited"}, "CitySidePipeMat": {"type": "inherited"}, "CustomSidePipeMat": {"type": "inherited"}, "CityCnnectrs_LeadGalv": {"type": "inherited"}, "CustomerCnnectrs_LeadGalv": {"type": "inherited"}, "MaterialVerified": {"type": "inherited"}, "MaterialVerificationTechnique": {"type": "inherited"}, "ExcavationNeeded": {"type": "inherited"}, "SwordfishComplete": {"type": "inherited"}, "LocationApproved": {"type": "inherited"}, "OWNEDBY": {"type": "inherited"}, "LIFECYCLE": {"type": "inherited"}, "INSTALLEDBY": {"type": "inherited"}, "Exception": {"type": "inherited"}, "TapClockLocation": {"type": "inherited"} }, "templates": [ { "name": "Customer Side Complete", "description": "", "prototype": { "attributes": { "MaterialVerificationNotes": null, "SwordfishComplete": "Customer Side Complete", "ExcavationNeeded": null, "DateSwordfishComplete": null, "CitySidePipeMat": "LSU", "CustomSidePipeMat": "LSU", "CityCnnectrs_LeadGalv": "Unknown", "CustomerCnnectrs_LeadGalv": "Unknown", "MaterialVerified": "No", "MaterialDateVerified": null, "MaterialVerifiedBy": null, "MaterialVerificationTechnique": null } }, "drawingTool": "esriFeatureEditToolLine" } ] }, { "id": "Not Complete", "name": "Not Complete", "domains": { "DIAMETER": {"type": "inherited"}, "CitySidePipeMat": {"type": "inherited"}, "CustomSidePipeMat": {"type": "inherited"}, "CityCnnectrs_LeadGalv": {"type": "inherited"}, "CustomerCnnectrs_LeadGalv": {"type": "inherited"}, "MaterialVerified": {"type": "inherited"}, "MaterialVerificationTechnique": {"type": "inherited"}, "ExcavationNeeded": {"type": "inherited"}, "SwordfishComplete": {"type": "inherited"}, "LocationApproved": {"type": "inherited"}, "OWNEDBY": {"type": "inherited"}, "LIFECYCLE": {"type": "inherited"}, "INSTALLEDBY": {"type": "inherited"}, "Exception": {"type": "inherited"}, "TapClockLocation": {"type": "inherited"} }, "templates": [ { "name": "Water Service Line", "description": "", "prototype": { "attributes": { "ExcavationNeeded": null, "SwordfishComplete": "Not Complete", "DateSwordfishComplete": null, "CitySidePipeMat": "LSU", "CustomSidePipeMat": "LSU", "CityCnnectrs_LeadGalv": "Unknown", "CustomerCnnectrs_LeadGalv": "Unknown", "MaterialVerified": "No", "MaterialDateVerified": null, "MaterialVerifiedBy": null, "MaterialVerificationTechnique": null, "MaterialVerificationNotes": null } }, "drawingTool": "esriFeatureEditToolLine" } ] } ], "templates": [], "maxRecordCount": 18000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "55065febea214b498055aef4d968462c" } ], "tables": [] }