{ "currentVersion": 10.61, "id": 82, "name": "Tank", "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": "TNKTYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 20, "domain": { "type": "codedValue", "name": "wwfTnkType\n", "description": "Type or classification of tank\t\t\n", "codedValues": [ { "name": "Batch", "code": "Batch" }, { "name": "Day", "code": "Day" }, { "name": "Chemical Storage", "code": "Chemical Storage" }, { "name": "Liquid Storage", "code": "Liquid Storage" }, { "name": "Bulk", "code": "Bulk" }, { "name": "Anoxic", "code": "Anoxic" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "wwfTnkMaterial\n", "description": "Primary tank construction material\t\t\n", "codedValues": [ { "name": "FRP", "code": "FRP" }, { "name": "Steel", "code": "Steel" }, { "name": "HDPE", "code": "HDPE" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LININGMATERIAL", "type": "esriFieldTypeString", "alias": "Lining Material", "length": 30, "domain": { "type": "codedValue", "name": "wwfTnkLiningMaterial\n", "description": "Lining material of tank\t\t\n", "codedValues": [ { "name": "Rubber", "code": "Rubber" }, { "name": "Viton", "code": "Viton" }, { "name": "Concrete Specialty Coating", "code": "Concrete Specialty Coating" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SERVICELIFE", "type": "esriFieldTypeDouble", "alias": "SERVICELIFE", "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeInteger", "alias": "Capacity", "domain": null } ], "indexes": [ { "name": "R293_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1644ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1644PARENTID", "fields": "PARENTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 121, "name": "Cathodic Protection Unit", "relatedTableId": 44, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 140, "name": "CommDevice", "relatedTableId": 47, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 233, "name": "Instrumentation", "relatedTableId": 60, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 246, "name": "Mixer", "relatedTableId": 63, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 277, "name": "Pump Unit", "relatedTableId": 73, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 286, "name": "Valve", "relatedTableId": 85, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 47, "name": "Area", "relatedTableId": 36, "role": "esriRelRoleDestination", "keyField": "PARENTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 112, "name": "Building", "relatedTableId": 42, "role": "esriRelRoleDestination", "keyField": "PARENTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 181, "name": "Generator", "relatedTableId": 54, "role": "esriRelRoleDestination", "keyField": "PARENTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 209, "name": "sde_SanDigeo.DBO.wwfGrounds", "relatedTableId": 56, "role": "esriRelRoleDestination", "keyField": "PARENTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 269, "name": "Process Structure", "relatedTableId": 71, "role": "esriRelRoleDestination", "keyField": "PARENTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 283, "name": "Site Structure", "relatedTableId": 79, "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 }