{
 "currentVersion": 10.61,
 "id": 33,
 "name": "Aerator",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "ASSETNAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "ASSETID",
   "type": "esriFieldTypeString",
   "alias": "Asset ID\n\n",
   "length": 100,
   "domain": null
  },
  {
   "name": "ASSETNAME",
   "type": "esriFieldTypeString",
   "alias": "Asset Name\n\n",
   "length": 255,
   "domain": null
  },
  {
   "name": "ASSETTYPE",
   "type": "esriFieldTypeString",
   "alias": "Asset Type\n\n",
   "length": 50,
   "domain": null
  },
  {
   "name": "ASSETOWNER",
   "type": "esriFieldTypeString",
   "alias": "Asset Owner\n",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wwfOwner",
    "description": "The Owner of the Asset\t\t\nThe Owner of the Asset\t\t\n",
    "codedValues": [
     {
      "name": "Airports",
      "code": "Airports"
     },
     {
      "name": "HHSA",
      "code": "HHSA"
     },
     {
      "name": "Parks",
      "code": "Parks"
     },
     {
      "name": "DGS",
      "code": "DGS"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Wastewater",
      "code": "Wastewater"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "LEGACYID",
   "type": "esriFieldTypeString",
   "alias": "Legacy ID\n",
   "length": 50,
   "domain": null
  },
  {
   "name": "TAGNUMBER",
   "type": "esriFieldTypeString",
   "alias": "Tag Number\n",
   "length": 50,
   "domain": null
  },
  {
   "name": "STATUS",
   "type": "esriFieldTypeString",
   "alias": "Status\n\n",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "wwfServiceStatus\n",
    "description": "Current status of the asset - is it in service, out of service, etc.\t\t\n",
    "codedValues": [
     {
      "name": "In Service",
      "code": "In Service"
     },
     {
      "name": "Out of Service",
      "code": "Out of Service"
     },
     {
      "name": "Spare",
      "code": "Spare"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PARENTID",
   "type": "esriFieldTypeString",
   "alias": "Parent ID\n",
   "length": 100,
   "domain": null
  },
  {
   "name": "STARTUPDATE",
   "type": "esriFieldTypeDate",
   "alias": "Startup Date\n",
   "length": 8,
   "domain": null
  },
  {
   "name": "WARRANTYDATE",
   "type": "esriFieldTypeDate",
   "alias": "Warranty Date\n\n",
   "length": 8,
   "domain": null
  },
  {
   "name": "CONDITIONSCORE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Condition Score\n\n",
   "domain": null
  },
  {
   "name": "CONDITIONDATE",
   "type": "esriFieldTypeDate",
   "alias": "Condition Date\n\n",
   "length": 8,
   "domain": null
  },
  {
   "name": "ADDRESS",
   "type": "esriFieldTypeString",
   "alias": "Address\n\n",
   "length": 255,
   "domain": null
  },
  {
   "name": "LOCATION",
   "type": "esriFieldTypeString",
   "alias": "Location\n\n",
   "length": 255,
   "domain": null
  },
  {
   "name": "SITE",
   "type": "esriFieldTypeString",
   "alias": "Site",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "wwfSiteDesignator\n\n",
    "description": "Site designator to indicate what overall site (such as a pump station or plant) that assets belongs to\t\t\n",
    "codedValues": [
     {
      "name": "Heise Park WWTP",
      "code": "JUWWTP0019"
     },
     {
      "name": "Pine Valley WWTP",
      "code": "PVWWTP0007"
     },
     {
      "name": "Rancho San Diego PS",
      "code": "SVWWPS0010"
     },
     {
      "name": "Ramona Airport PS",
      "code": "RMWWPS0016"
     },
     {
      "name": "Galloway Pump Station",
      "code": "ALWWPS0012"
     },
     {
      "name": "Campo Hills Water Treatment Plant",
      "code": "CHWTP0003"
     },
     {
      "name": "Campo Hills Water Tank",
      "code": "CHWT0002"
     },
     {
      "name": "Campo Hills Well #1",
      "code": "CHWS0032"
     },
     {
      "name": "Campo Hills Well #3",
      "code": "CHWS0033"
     },
     {
      "name": "Harbison Canyon Pump Station",
      "code": "ALWWPS0013"
     },
     {
      "name": "Inter-Tie Pump Station",
      "code": "CHWPS0001"
     },
     {
      "name": "Rancho Del Campo WWTP",
      "code": "RDCWWTP0005"
     },
     {
      "name": "Rancho Del Campo Tanks",
      "code": "RDCWT0004"
     },
     {
      "name": "Rancho Del Campo Wells 1 & 3",
      "code": "RDCWS0006"
     },
     {
      "name": "Rancho Del Campo Well 4",
      "code": "RDCWS0031"
     },
     {
      "name": "Jamacha Pump Station",
      "code": "SVWWPS0011"
     },
     {
      "name": "Julian High School Pump Station",
      "code": "JUWWPS0018"
     },
     {
      "name": "Julian Wastewater Treatment Plant",
      "code": "JUWWTP0017"
     },
     {
      "name": "Moreno Avenue Pump Station",
      "code": "LSWWPS0014"
     },
     {
      "name": "San Pasqual Chlorine Building",
      "code": "SPWS0028"
     },
     {
      "name": "Vista Del Lago Pump Station",
      "code": "SVWWPS0009"
     },
     {
      "name": "Woodcreek Pump Station",
      "code": "LSWWPS0015"
     },
     {
      "name": "Spring Valley OPS",
      "code": "SVOS0040"
     },
     {
      "name": "San Pasqual Pump Station",
      "code": "SPWWPS0030"
     },
     {
      "name": "County Operation Center Bldg 5500",
      "code": "KMOS0042"
     },
     {
      "name": "Live Oak Springs Booster PS",
      "code": "LOWPS0023"
     },
     {
      "name": "Campo Repeater",
      "code": "RDCRS0043"
     },
     {
      "name": "Cowles Mountain Repeater",
      "code": "LMRS0044"
     },
     {
      "name": "Cuyamaca Peak Repeater",
      "code": "JURS0045"
     },
     {
      "name": "Live Oak Springs Tanks",
      "code": "LOWT0022"
     },
     {
      "name": "Live Oak Springs Well 2",
      "code": "LOWS0020"
     },
     {
      "name": "Live Oak Springs Well 6 (Future)",
      "code": "LOWS0021"
     },
     {
      "name": "Mount San Miglel Repeater",
      "code": "SVRS0047"
     },
     {
      "name": "North Peak Repeater",
      "code": "JURS0046"
     },
     {
      "name": "Otay Crossings Pump Station (Future)",
      "code": "EOMWWPS0034"
     },
     {
      "name": "Ramona Ave Pump Station",
      "code": "SVWWPS0008"
     },
     {
      "name": "San Pasqual Tanks",
      "code": "SPWT0027"
     },
     {
      "name": "San Pasqual Well #2",
      "code": "SPWS0024"
     },
     {
      "name": "San Pasqual Well #5",
      "code": "SPWS0025"
     },
     {
      "name": "San Pasqual Well #6",
      "code": "SPWS0026"
     },
     {
      "name": "Spa Pasqual OPS",
      "code": "SPOS0041"
     },
     {
      "name": "Volcan South Repeater",
      "code": "JURS0048"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "MANUFACTURER",
   "type": "esriFieldTypeString",
   "alias": "Manufacturer\n\n",
   "length": 30,
   "domain": null
  },
  {
   "name": "MANPHONE",
   "type": "esriFieldTypeString",
   "alias": "Manufacturer Phone #\n",
   "length": 16,
   "domain": null
  },
  {
   "name": "MANWEBSITE",
   "type": "esriFieldTypeString",
   "alias": "Manufacturer Website\n\n",
   "length": 30,
   "domain": null
  },
  {
   "name": "MODEL",
   "type": "esriFieldTypeString",
   "alias": "Model\n\n",
   "length": 30,
   "domain": null
  },
  {
   "name": "SERIALNO",
   "type": "esriFieldTypeString",
   "alias": "Serial Number\n\n",
   "length": 30,
   "domain": null
  },
  {
   "name": "VENDOR",
   "type": "esriFieldTypeString",
   "alias": "Vendor\n\n",
   "length": 30,
   "domain": null
  },
  {
   "name": "SPECLINK",
   "type": "esriFieldTypeString",
   "alias": "Spec Link\n\n",
   "length": 64,
   "domain": null
  },
  {
   "name": "OMLINK",
   "type": "esriFieldTypeString",
   "alias": "O&M Link\n\n",
   "length": 64,
   "domain": null
  },
  {
   "name": "SYSTEM",
   "type": "esriFieldTypeString",
   "alias": "System Designator\n\n",
   "length": 40,
   "domain": {
    "type": "codedValue",
    "name": "wwfSystemDesignator\n\n_1",
    "description": "Designator indicating process (conveyance, preliminary, primary, secondary, tertiary, solids - all inferred from system) and system asset is supporting. Utilized as part of cost rollup calculations.\t\t\n",
    "codedValues": [
     {
      "name": "Conveyance",
      "code": "Conveyance"
     },
     {
      "name": "Screening",
      "code": "Screening"
     },
     {
      "name": "Grit Removal",
      "code": "Grit Removal"
     },
     {
      "name": "Primary Clarification/Sedimentation",
      "code": "Primary Clarification/Sedimentation"
     },
     {
      "name": "Coagulation/Flocculation",
      "code": "Coagulation/Flocculation"
     },
     {
      "name": "Aeration",
      "code": "Aeration"
     },
     {
      "name": "Secondary Clarification",
      "code": "Secondary Clarification"
     },
     {
      "name": "Disinfection",
      "code": "Disinfection"
     },
     {
      "name": "Re-use",
      "code": "Re-use"
     },
     {
      "name": "De-watering",
      "code": "De-watering"
     },
     {
      "name": "Land Application",
      "code": "Land Application"
     },
     {
      "name": "Water",
      "code": "Water"
     },
     {
      "name": "Oil and Grease Removal",
      "code": "Oil and Grease Removal"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "LOF",
   "type": "esriFieldTypeSmallInteger",
   "alias": "LoF Score\n\n",
   "domain": null
  },
  {
   "name": "COF",
   "type": "esriFieldTypeSmallInteger",
   "alias": "CoF Score\n\n",
   "domain": null
  },
  {
   "name": "RISK",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Risk Score\n",
   "domain": null
  },
  {
   "name": "CRITICALITY",
   "type": "esriFieldTypeString",
   "alias": "Criticality\n",
   "length": 16,
   "domain": {
    "type": "codedValue",
    "name": "wwfCriticality\n\n",
    "description": "Criticality - can be used to auto-populate Priority on work order through template classes. E.g. High = Urgent work order priority.\t\t\n",
    "codedValues": [
     {
      "name": "High",
      "code": "High"
     },
     {
      "name": "Medium",
      "code": "Medium"
     },
     {
      "name": "Low",
      "code": "Low"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "REPLACEVALUE",
   "type": "esriFieldTypeDouble",
   "alias": "Replacement Value\n\n",
   "domain": null
  },
  {
   "name": "VALUEDATE",
   "type": "esriFieldTypeDate",
   "alias": "Valuation Date\n\n",
   "length": 8,
   "domain": null
  },
  {
   "name": "NOTES",
   "type": "esriFieldTypeString",
   "alias": "Notes",
   "length": 255,
   "domain": null
  },
  {
   "name": "CREATOR",
   "type": "esriFieldTypeString",
   "alias": "Creator\n",
   "length": 30,
   "domain": null
  },
  {
   "name": "CREATEDATE",
   "type": "esriFieldTypeDate",
   "alias": "Created\n",
   "length": 8,
   "domain": null
  },
  {
   "name": "EDITOR",
   "type": "esriFieldTypeString",
   "alias": "Editor\n",
   "length": 30,
   "domain": null
  },
  {
   "name": "EDITDATE",
   "type": "esriFieldTypeDate",
   "alias": "Edited\n",
   "length": 8,
   "domain": null
  },
  {
   "name": "AERTYPE",
   "type": "esriFieldTypeString",
   "alias": "Type",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "wwfAerType",
    "description": "Type or classification of aerator\t\t\n",
    "codedValues": [
     {
      "name": "Surface Mechanical",
      "code": "Surface Mechanical"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "FLOAT",
   "type": "esriFieldTypeString",
   "alias": "Float",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "wwfAerFloatPlatform\n",
    "description": "Aerator floating platform\t\t\n",
    "codedValues": [
     {
      "name": "Fiberglass",
      "code": "Fiberglass"
     },
     {
      "name": "316 SS",
      "code": "316 SS"
     },
     {
      "name": "304 SS",
      "code": "304 SS"
     },
     {
      "name": "Steel Powder Coated",
      "code": "Steel Powder Coated"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SEALTYPE",
   "type": "esriFieldTypeString",
   "alias": "Seal Type",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "wwfAerSealType\n",
    "description": "Type of aerator seal\t\t\n",
    "codedValues": [
     {
      "name": "Mechanical",
      "code": "Mechanical"
     },
     {
      "name": "Packing",
      "code": "Packing"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "GREASETYPE",
   "type": "esriFieldTypeString",
   "alias": "Lubrication, Grease",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "wwfLubricationType_2",
    "description": "Type of grease or lubrication used",
    "codedValues": [
     {
      "name": "Oil",
      "code": "Oil"
     },
     {
      "name": "Grease",
      "code": "Grease"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OILTYPE",
   "type": "esriFieldTypeString",
   "alias": "Lubrication, Oil",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "wwfLubricationType_2",
    "description": "Type of grease or lubrication used",
    "codedValues": [
     {
      "name": "Oil",
      "code": "Oil"
     },
     {
      "name": "Grease",
      "code": "Grease"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "NUMIMPELLERVANES",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Number of Impeller Vanes",
   "domain": null
  },
  {
   "name": "IMPELLERMAT",
   "type": "esriFieldTypeString",
   "alias": "Impeller Material",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "wwfAerImpellerMaterial \n",
    "description": "Impeller material\n",
    "codedValues": [
     {
      "name": "304 SS\n 304 SS\n 304 SS\n 304 SS",
      "code": "304 SS\n 304 SS\n 304 SS\n 304 SS"
     },
     {
      "name": "316 SS",
      "code": "316 SS"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ROTATIONDIR",
   "type": "esriFieldTypeString",
   "alias": "Rotation",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "wwfRotation_2",
    "description": "Rotation Direction",
    "codedValues": [
     {
      "name": "Clockwise",
      "code": "Clockwise"
     },
     {
      "name": "Counter-Clockwise",
      "code": "Counter-Clockwise"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DRIVETYPE",
   "type": "esriFieldTypeString",
   "alias": "DRIVETYPE",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "wwfAerDriveType",
    "description": "Type of aerator drive\t\t\n",
    "codedValues": [
     {
      "name": "Direct",
      "code": "Direct"
     },
     {
      "name": "Belt",
      "code": "Belt"
     },
     {
      "name": "Gear",
      "code": "Gear"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "COUPLINGTYPE",
   "type": "esriFieldTypeString",
   "alias": "Coupling Type",
   "length": 30,
   "domain": null
  },
  {
   "name": "COUPLINGMODEL",
   "type": "esriFieldTypeString",
   "alias": "Coupling Model",
   "length": 30,
   "domain": null
  },
  {
   "name": "COUPLINGSIZE",
   "type": "esriFieldTypeDouble",
   "alias": "COUPLINGSIZE",
   "domain": null
  },
  {
   "name": "IMPELLERDIAM",
   "type": "esriFieldTypeDouble",
   "alias": "IMPELLERDIAM",
   "domain": null
  },
  {
   "name": "IMPELLERSLEEVEDIAM",
   "type": "esriFieldTypeDouble",
   "alias": "IMPELLERSLEEVEDIAM",
   "domain": null
  },
  {
   "name": "SUCTIONDIAM",
   "type": "esriFieldTypeDouble",
   "alias": "SUCTIONDIAM",
   "domain": null
  },
  {
   "name": "SERVICELIFE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Service Life\n\n",
   "domain": null
  },
  {
   "name": "RPM",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Rotations per Minute",
   "domain": null
  },
  {
   "name": "CABLEMOORING",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Cable Mooring",
   "domain": null
  },
  {
   "name": "FLOWRATE",
   "type": "esriFieldTypeString",
   "alias": "Flow Rate",
   "length": 50,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R242_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G1593PARENTID",
   "fields": "PARENTID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G1593ASSETID",
   "fields": "ASSETID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 3,
   "name": "PumpUnit",
   "relatedTableId": 73,
   "role": "esriRelRoleDestination",
   "keyField": "PARENTID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, AMF",
 "isDataVersioned": true,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsHavingClause": true,
  "supportsCountDistinct": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true
 },
 "dateFieldsTimeReference": null
}