{
 "currentVersion": 10.61,
 "id": 73,
 "name": "TB_WRF_Piping",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": null,
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": true,
 "relationships": [
  {
   "id": 70,
   "name": "TB_WRF_PositionPoint",
   "relatedTableId": 102,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "ParentID",
   "composite": false
  }
 ],
 "isDataVersioned": true,
 "supportsRollbackOnFailureParameter": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": false,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsTrueCurve": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsHavingClause": true,
  "supportsCountDistinct": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsSqlExpression": true
 },
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "GlobalID",
 "displayField": "AssetID",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false
  },
  {
   "name": "AssetID",
   "type": "esriFieldTypeString",
   "alias": "Asset ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50
  },
  {
   "name": "LegacyID",
   "type": "esriFieldTypeString",
   "alias": "Legacy ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 30
  },
  {
   "name": "Address",
   "type": "esriFieldTypeString",
   "alias": "Location",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 130
  },
  {
   "name": "Location",
   "type": "esriFieldTypeString",
   "alias": "Location Details",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 256
  },
  {
   "name": "InstallDate",
   "type": "esriFieldTypeDate",
   "alias": "Install Date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8
  },
  {
   "name": "WarrantyDate",
   "type": "esriFieldTypeDate",
   "alias": "Warranty Date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8
  },
  {
   "name": "Status",
   "type": "esriFieldTypeString",
   "alias": "Lifecycle Status",
   "domain": {
    "type": "codedValue",
    "name": "gStatus",
    "description": "Lifecycle Status",
    "codedValues": [
     {
      "name": "Permitted",
      "code": "Permitted"
     },
     {
      "name": "In Service",
      "code": "In Service"
     },
     {
      "name": "Not In Service",
      "code": "Not In Service"
     },
     {
      "name": "Abandoned",
      "code": "Abandoned"
     },
     {
      "name": "Removed",
      "code": "Removed"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 20
  },
  {
   "name": "ProcessArea",
   "type": "esriFieldTypeString",
   "alias": "Process Area",
   "domain": {
    "type": "codedValue",
    "name": "gProcessArea_3",
    "description": "Process Area",
    "codedValues": [
     {
      "name": "M00",
      "code": "M00"
     },
     {
      "name": "M01",
      "code": "M01"
     },
     {
      "name": "M02",
      "code": "M02"
     },
     {
      "name": "M03",
      "code": "M03"
     },
     {
      "name": "M04",
      "code": "M04"
     },
     {
      "name": "M05",
      "code": "M05"
     },
     {
      "name": "M06",
      "code": "M06"
     },
     {
      "name": "M07",
      "code": "M07"
     },
     {
      "name": "M08",
      "code": "M08"
     },
     {
      "name": "M09",
      "code": "M09"
     },
     {
      "name": "M10",
      "code": "M10"
     },
     {
      "name": "M11",
      "code": "M11"
     },
     {
      "name": "M12",
      "code": "M12"
     },
     {
      "name": "M13",
      "code": "M13"
     },
     {
      "name": "M14",
      "code": "M14"
     },
     {
      "name": "M16",
      "code": "M16"
     },
     {
      "name": "M17",
      "code": "M17"
     },
     {
      "name": "M18",
      "code": "M18"
     },
     {
      "name": "M19",
      "code": "M19"
     },
     {
      "name": "M21",
      "code": "M21"
     },
     {
      "name": "M22",
      "code": "M22"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 3
  },
  {
   "name": "Process",
   "type": "esriFieldTypeString",
   "alias": "Process",
   "domain": {
    "type": "codedValue",
    "name": "gProcess_3",
    "description": "Process",
    "codedValues": [
     {
      "name": "M00 Preaeration Basins Odor Control",
      "code": "M00 Preaeration Basins Odor Control"
     },
     {
      "name": "M01 Equalization Basins",
      "code": "M01 Equalization Basins"
     },
     {
      "name": "M01 Fuel Unloading",
      "code": "M01 Fuel Unloading"
     },
     {
      "name": "M01 Pretreatment",
      "code": "M01 Pretreatment"
     },
     {
      "name": "M02 Primary Pump Station Primary Clarifiers 1 through 5",
      "code": "M02 Primary Pump Station Primary Clarifiers 1 through 5"
     },
     {
      "name": "M03 Blower Building Aeration Basins",
      "code": "M03 Blower Building Aeration Basins"
     },
     {
      "name": "M04 Secondary Clarifiers 1 through 9 Return Activated Sludge Pumping Stations 1 and 2",
      "code": "M04 Secondary Clarifiers 1 through 9 Return Activated Sludge Pumping Stations 1 and 2"
     },
     {
      "name": "M05 Denitrification Filters 1 through 24",
      "code": "M05 Denitrification Filters 1 through 24"
     },
     {
      "name": "M06 Administration Building Old",
      "code": "M06 Administration Building Old"
     },
     {
      "name": "M07 Generator and Electrical Distribution",
      "code": "M07 Generator and Electrical Distribution"
     },
     {
      "name": "M08 Lime Handling Lime Tower",
      "code": "M08 Lime Handling Lime Tower"
     },
     {
      "name": "M09 Control and Process Building",
      "code": "M09 Control and Process Building"
     },
     {
      "name": "M10 Plant Wastewater Pump Station",
      "code": "M10 Plant Wastewater Pump Station"
     },
     {
      "name": "M11 Grubbs Admin and Lab",
      "code": "M11 Grubbs Admin and Lab"
     },
     {
      "name": "M12 Thickeners 1 and 2 Thickened Sludge Pump Station 1",
      "code": "M12 Thickeners 1 and 2 Thickened Sludge Pump Station 1"
     },
     {
      "name": "M12 Thickeners 3 and 4 Thickened Sludge Pump Station 2",
      "code": "M12 Thickeners 3 and 4 Thickened Sludge Pump Station 2"
     },
     {
      "name": "M13 Outside of Process Areas",
      "code": "M13 Outside of Process Areas"
     },
     {
      "name": "M14 Operations Support Facility Maintenance",
      "code": "M14 Operations Support Facility Maintenance"
     },
     {
      "name": "M16 Incinerator",
      "code": "M16 Incinerator"
     },
     {
      "name": "M17 Dewatering Equipment Solids Building",
      "code": "M17 Dewatering Equipment Solids Building"
     },
     {
      "name": "M18 Sludge Holding Tanks 1 and 4",
      "code": "M18 Sludge Holding Tanks 1 and 4"
     },
     {
      "name": "M19 Ash Settling Basins Ash Cover",
      "code": "M19 Ash Settling Basins Ash Cover"
     },
     {
      "name": "M21 Methanol Building",
      "code": "M21 Methanol Building"
     },
     {
      "name": "M22 Ultraviolet Disinfection Process Water Pumps Final Flow Meter Effluent Cascade",
      "code": "M22 Ultraviolet Disinfection Process Water Pumps Final Flow Meter Effluent Cascade"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 100
  },
  {
   "name": "ProjectNum",
   "type": "esriFieldTypeString",
   "alias": "Project Number",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 30
  },
  {
   "name": "Notes",
   "type": "esriFieldTypeString",
   "alias": "Notes",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 256
  },
  {
   "name": "ParentID",
   "type": "esriFieldTypeString",
   "alias": "Parent ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 25
  },
  {
   "name": "AssetCost",
   "type": "esriFieldTypeDouble",
   "alias": "Asset Cost",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "ReplaceCost",
   "type": "esriFieldTypeDouble",
   "alias": "Replacement Cost",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "Condition",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Condition",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "ConditionDate",
   "type": "esriFieldTypeDate",
   "alias": "Condition Date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8
  },
  {
   "name": "RehabDate",
   "type": "esriFieldTypeDate",
   "alias": "Last Rehab Date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8
  },
  {
   "name": "LifeExpectancy",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Life Expectancy in Yrs",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "RemUseLife",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Remaining Useful Life in Yrs",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "COF",
   "type": "esriFieldTypeDouble",
   "alias": "Consequence of Failure",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "POF",
   "type": "esriFieldTypeDouble",
   "alias": "Probability of Failure",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "BRE",
   "type": "esriFieldTypeDouble",
   "alias": "Business Risk Exposure",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "Manufacturer",
   "type": "esriFieldTypeString",
   "alias": "Manufacturer",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50
  },
  {
   "name": "Model",
   "type": "esriFieldTypeString",
   "alias": "Model",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 25
  },
  {
   "name": "ModelYear",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Model Year",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "SerialNumber",
   "type": "esriFieldTypeString",
   "alias": "Serial Number",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 25
  },
  {
   "name": "PipingType",
   "type": "esriFieldTypeString",
   "alias": "Piping Type",
   "domain": {
    "type": "codedValue",
    "name": "gPipingType",
    "description": "Piping Type",
    "codedValues": [
     {
      "name": "General Plumbing",
      "code": "General Plumbing"
     },
     {
      "name": "Mechanical Plumbing",
      "code": "Mechanical Plumbing"
     },
     {
      "name": "Chemical",
      "code": "Chemical"
     },
     {
      "name": "Process",
      "code": "Process"
     },
     {
      "name": "Fuel",
      "code": "Fuel"
     },
     {
      "name": "Electrical",
      "code": "Electrical"
     },
     {
      "name": "Sewage",
      "code": "Sewage"
     },
     {
      "name": "Vent",
      "code": "Vent"
     },
     {
      "name": "Influent",
      "code": "Influent"
     },
     {
      "name": "Effluent",
      "code": "Effluent"
     },
     {
      "name": "Inconel",
      "code": "Inconel"
     },
     {
      "name": "Compressed Air",
      "code": "Compressed Air"
     },
     {
      "name": "Hydraulic",
      "code": "Hydraulic"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 25
  },
  {
   "name": "PipeContents",
   "type": "esriFieldTypeString",
   "alias": "Pipe Contents",
   "domain": {
    "type": "codedValue",
    "name": "gPipeContents",
    "description": "Pipe Contents",
    "codedValues": [
     {
      "name": "Chemical",
      "code": "Chemical"
     },
     {
      "name": "Potable Water",
      "code": "Potable Water"
     },
     {
      "name": "Non-Potable Water",
      "code": "Non-Potable Water"
     },
     {
      "name": "Fuel",
      "code": "Fuel"
     },
     {
      "name": "Sludge",
      "code": "Sludge"
     },
     {
      "name": "Combustible Gases",
      "code": "Combustible Gases"
     },
     {
      "name": "Refrigerant",
      "code": "Refrigerant"
     },
     {
      "name": "Ash",
      "code": "Ash"
     },
     {
      "name": "Hydraulic Fluid",
      "code": "Hydraulic Fluid"
     },
     {
      "name": "Compressed Air",
      "code": "Compressed Air"
     },
     {
      "name": "Exhaust Gas",
      "code": "Exhaust Gas"
     },
     {
      "name": "Sewage",
      "code": "Sewage"
     },
     {
      "name": "Wire/Cable",
      "code": "Wire/Cable"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 19
  },
  {
   "name": "PipeMaterial",
   "type": "esriFieldTypeString",
   "alias": "Pipe Material",
   "domain": {
    "type": "codedValue",
    "name": "gPipeMaterial",
    "description": "Pipe Material",
    "codedValues": [
     {
      "name": "SCH 30",
      "code": "SCH 30"
     },
     {
      "name": "SCH 40",
      "code": "SCH 40"
     },
     {
      "name": "SCH 80",
      "code": "SCH 80"
     },
     {
      "name": "CPVC",
      "code": "CPVC"
     },
     {
      "name": "PEX",
      "code": "PEX"
     },
     {
      "name": "Cast Iron",
      "code": "Cast Iron"
     },
     {
      "name": "Steel",
      "code": "Steel"
     },
     {
      "name": "Stainless Steel",
      "code": "Stainless Steel"
     },
     {
      "name": "Copper",
      "code": "Copper"
     },
     {
      "name": "Chromed Brass",
      "code": "Chromed Brass"
     },
     {
      "name": "Aluminum",
      "code": "Aluminum"
     },
     {
      "name": "Galvinized",
      "code": "Galvinized"
     },
     {
      "name": "Concrete",
      "code": "Concrete"
     },
     {
      "name": "Ductile Iron",
      "code": "Ductile Iron"
     },
     {
      "name": "Alloy",
      "code": "Alloy"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 35
  },
  {
   "name": "LiningMaterial",
   "type": "esriFieldTypeString",
   "alias": "Lining Material",
   "domain": {
    "type": "codedValue",
    "name": "gPipeLiningMaterial",
    "description": "Pipe Lining Material",
    "codedValues": [
     {
      "name": "Cement",
      "code": "Cement"
     },
     {
      "name": "Epoxy",
      "code": "Epoxy"
     },
     {
      "name": "Fiberglass",
      "code": "Fiberglass"
     },
     {
      "name": "Glass",
      "code": "Glass"
     },
     {
      "name": "Ceramic",
      "code": "Ceramic"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 12
  },
  {
   "name": "ExternalCoating",
   "type": "esriFieldTypeString",
   "alias": "External Coating",
   "domain": {
    "type": "codedValue",
    "name": "gPipeExteriorCoating",
    "description": "Pipe Exterior Coating",
    "codedValues": [
     {
      "name": "Painted",
      "code": "Painted"
     },
     {
      "name": "Insulated",
      "code": "Insulated"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 13
  },
  {
   "name": "PipeDiameter",
   "type": "esriFieldTypeString",
   "alias": "Pipe Diameter in IN",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 5
  },
  {
   "name": "PressureRating",
   "type": "esriFieldTypeDouble",
   "alias": "Pressure Rating in PSI",
   "domain": null,
   "editable": true,
   "nullable": true
  },
  {
   "name": "ConnectionType",
   "type": "esriFieldTypeString",
   "alias": "Connection Type",
   "domain": {
    "type": "codedValue",
    "name": "gPipeConnectType",
    "description": "Pipe Connect Type",
    "codedValues": [
     {
      "name": "Flanged",
      "code": "Flanged"
     },
     {
      "name": "Threaded",
      "code": "Threaded"
     },
     {
      "name": "Welded",
      "code": "Welded"
     },
     {
      "name": "Socket",
      "code": "Socket"
     },
     {
      "name": "Compression Fitting",
      "code": "Compression Fitting"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 20
  },
  {
   "name": "AssetName",
   "type": "esriFieldTypeString",
   "alias": "Asset Name (Equipment No.)",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50
  },
  {
   "name": "Image",
   "type": "esriFieldTypeString",
   "alias": "Image Name",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "length": 38
  },
  {
   "name": "CREATED_BY",
   "type": "esriFieldTypeString",
   "alias": "CREATED_BY",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255
  },
  {
   "name": "CREATED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "CREATED_DATE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8
  },
  {
   "name": "LAST_EDITED_BY",
   "type": "esriFieldTypeString",
   "alias": "LAST_EDITED_BY",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255
  },
  {
   "name": "LAST_EDITED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "LAST_EDITED_DATE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8
  }
 ],
 "indexes": [
  {
   "name": "R526_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_526",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G1136ParentID",
   "fields": "ParentID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_526",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "dateFieldsTimeReference": {
  "timeZone": "UTC",
  "respectsDaylightSaving": false
 },
 "types": [],
 "templates": [
  {
   "name": "TB_WRF_Piping",
   "description": "",
   "prototype": {
    "attributes": {
     "LAST_EDITED_BY": null,
     "LAST_EDITED_DATE": null,
     "AssetID": null,
     "LegacyID": null,
     "Address": null,
     "Location": null,
     "InstallDate": null,
     "WarrantyDate": null,
     "Status": "In Service",
     "ProcessArea": null,
     "Process": null,
     "ProjectNum": null,
     "Notes": null,
     "ParentID": null,
     "AssetCost": null,
     "ReplaceCost": null,
     "Condition": null,
     "ConditionDate": null,
     "RehabDate": null,
     "LifeExpectancy": null,
     "RemUseLife": null,
     "COF": null,
     "POF": null,
     "BRE": null,
     "Manufacturer": null,
     "Model": null,
     "ModelYear": null,
     "SerialNumber": null,
     "PipingType": null,
     "PipeContents": null,
     "PipeMaterial": null,
     "LiningMaterial": null,
     "ExternalCoating": null,
     "PipeDiameter": null,
     "PressureRating": null,
     "ConnectionType": null,
     "AssetName": null,
     "Image": null,
     "CREATED_DATE": null,
     "CREATED_BY": null
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 1000,
 "supportedQueryFormats": "JSON, AMF, geoJSON",
 "capabilities": "Query,Create,Update,Delete,Uploads,Editing",
 "useStandardizedQueries": true,
 "standardMaxRecordCount": 1000,
 "tileMaxRecordCount": 1000,
 "maxRecordCountFactor": 1
}