{
 "currentVersion": 10.61,
 "id": 79,
 "name": "Site Structure",
 "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",
   "length": 8,
   "domain": null
  },
  {
   "name": "SITSTRYTYPE",
   "type": "esriFieldTypeString",
   "alias": "Type",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "wwfSitstrType\n",
    "description": "Type or classification of site structure\t\t\n",
    "codedValues": [
     {
      "name": "Vault",
      "code": "Vault"
     },
     {
      "name": "Cabinet",
      "code": "Cabinet"
     },
     {
      "name": "Storage Container",
      "code": "Storage Container"
     },
     {
      "name": "Shade Structure",
      "code": "Shade Structure"
     },
     {
      "name": "Concrete Wall",
      "code": "Concrete Wall"
     },
     {
      "name": "Retaining Wall",
      "code": "Retaining Wall"
     },
     {
      "name": "Platform",
      "code": "Platform"
     },
     {
      "name": "Mezzanine",
      "code": "Mezzanine"
     },
     {
      "name": "Antenna Tower",
      "code": "Antenna Tower"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SERVICELIFE",
   "type": "esriFieldTypeDouble",
   "alias": "SERVICELIFE",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R290_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G1641ASSETID",
   "fields": "ASSETID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G1641PARENTID",
   "fields": "PARENTID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 15,
   "name": "Antenna",
   "relatedTableId": 35,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 57,
   "name": "Automatic Transfer Switch",
   "relatedTableId": 37,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 61,
   "name": "Backflow Preventer",
   "relatedTableId": 38,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 70,
   "name": "Belt Filter Press",
   "relatedTableId": 39,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 82,
   "name": "Blower Unit",
   "relatedTableId": 41,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 118,
   "name": "Cabinet",
   "relatedTableId": 43,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 132,
   "name": "Chemical Feed Equipment",
   "relatedTableId": 45,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 135,
   "name": "Circuit Breaker",
   "relatedTableId": 46,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 139,
   "name": "Communication Device",
   "relatedTableId": 47,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 149,
   "name": "Compressor",
   "relatedTableId": 48,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 164,
   "name": "Control Panel",
   "relatedTableId": 49,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 176,
   "name": "Filter",
   "relatedTableId": 52,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 183,
   "name": "Generator",
   "relatedTableId": 54,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 188,
   "name": "Grinder",
   "relatedTableId": 55,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 219,
   "name": "Hopper",
   "relatedTableId": 58,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 225,
   "name": "HVAC Equipment",
   "relatedTableId": 59,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 232,
   "name": "Instrumentation",
   "relatedTableId": 60,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 239,
   "name": "Lift Equipment",
   "relatedTableId": 61,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 242,
   "name": "Lighting System",
   "relatedTableId": 62,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 255,
   "name": "MotorControlCenter",
   "relatedTableId": 66,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 257,
   "name": "Site Structure",
   "relatedTableId": 67,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 263,
   "name": "Piping",
   "relatedTableId": 69,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 276,
   "name": "Pump Unit",
   "relatedTableId": 73,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 279,
   "name": "Roof",
   "relatedTableId": 74,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 280,
   "name": "Safety Equipment",
   "relatedTableId": 75,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 281,
   "name": "Security Equipment",
   "relatedTableId": 77,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 282,
   "name": "Switchgear",
   "relatedTableId": 81,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 283,
   "name": "Tank",
   "relatedTableId": 82,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 284,
   "name": "Transformer",
   "relatedTableId": 83,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 285,
   "name": "Valve",
   "relatedTableId": 85,
   "role": "esriRelRoleOrigin",
   "keyField": "ASSETID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 207,
   "name": "sde_SanDigeo.DBO.wwfGrounds",
   "relatedTableId": 56,
   "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
}