{ "currentVersion": 10.61, "id": 66, "name": "Motor Control Center", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 250, "name": "VFD", "relatedTableId": 87, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ASSETID", "composite": false }, { "id": 6, "name": "Air System", "relatedTableId": 34, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 36, "name": "Area", "relatedTableId": 36, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 66, "name": "Belt Filter Press", "relatedTableId": 39, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 76, "name": "Blower Unit", "relatedTableId": 41, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 100, "name": "sde_SanDigeo.DBO.wwfBuilding", "relatedTableId": 42, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 127, "name": "Chemical Feed Equipment", "relatedTableId": 45, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 144, "name": "Compressor", "relatedTableId": 48, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 180, "name": "Generator", "relatedTableId": 54, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 185, "name": "Grinder", "relatedTableId": 55, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 196, "name": "sde_SanDigeo.DBO.wwfGrounds", "relatedTableId": 56, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 217, "name": "Hopper", "relatedTableId": 58, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 222, "name": "HVAC Equipment", "relatedTableId": 59, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 236, "name": "Lift Equipment", "relatedTableId": 61, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 244, "name": "Mixer", "relatedTableId": 63, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 251, "name": "Odor Control Unit", "relatedTableId": 67, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 252, "name": "Packaged Unit", "relatedTableId": 68, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 253, "name": "ProcessStructure", "relatedTableId": 71, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 254, "name": "Pump Unit", "relatedTableId": 73, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 255, "name": "SiteStructure", "relatedTableId": 79, "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": "", "displayField": "ASSETNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "Asset ID\n\n", "domain": null, "editable": true, "nullable": true, "length": 100 }, { "name": "ASSETNAME", "type": "esriFieldTypeString", "alias": "Asset Name\n\n", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "ASSETTYPE", "type": "esriFieldTypeString", "alias": "Asset Type\n\n", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "ASSETOWNER", "type": "esriFieldTypeString", "alias": "Asset Owner\n", "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" }, "editable": true, "nullable": true, "length": 50 }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "Legacy ID\n", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "TAGNUMBER", "type": "esriFieldTypeString", "alias": "Tag Number\n", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status\n\n", "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" }, "editable": true, "nullable": true, "length": 30 }, { "name": "PARENTID", "type": "esriFieldTypeString", "alias": "Parent ID\n", "domain": null, "editable": true, "nullable": true, "length": 100 }, { "name": "STARTUPDATE", "type": "esriFieldTypeDate", "alias": "Startup Date\n", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date\n\n", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "CONDITIONSCORE", "type": "esriFieldTypeSmallInteger", "alias": "Condition Score\n\n", "domain": null, "editable": true, "nullable": true }, { "name": "CONDITIONDATE", "type": "esriFieldTypeDate", "alias": "Condition Date\n\n", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address\n\n", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location\n\n", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "Site", "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" }, "editable": true, "nullable": true, "length": 30 }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer\n\n", "domain": null, "editable": true, "nullable": true, "length": 30 }, { "name": "MANPHONE", "type": "esriFieldTypeString", "alias": "Manufacturer Phone #\n", "domain": null, "editable": true, "nullable": true, "length": 16 }, { "name": "MANWEBSITE", "type": "esriFieldTypeString", "alias": "Manufacturer Website\n\n", "domain": null, "editable": true, "nullable": true, "length": 30 }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "Model\n\n", "domain": null, "editable": true, "nullable": true, "length": 30 }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "Serial Number\n\n", "domain": null, "editable": true, "nullable": true, "length": 30 }, { "name": "VENDOR", "type": "esriFieldTypeString", "alias": "Vendor\n\n", "domain": null, "editable": true, "nullable": true, "length": 30 }, { "name": "SPECLINK", "type": "esriFieldTypeString", "alias": "Spec Link\n\n", "domain": null, "editable": true, "nullable": true, "length": 64 }, { "name": "OMLINK", "type": "esriFieldTypeString", "alias": "O&M Link\n\n", "domain": null, "editable": true, "nullable": true, "length": 64 }, { "name": "SYSTEM", "type": "esriFieldTypeString", "alias": "System Designator\n\n", "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" }, "editable": true, "nullable": true, "length": 40 }, { "name": "LOF", "type": "esriFieldTypeSmallInteger", "alias": "LoF Score\n\n", "domain": null, "editable": true, "nullable": true }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "CoF Score\n\n", "domain": null, "editable": true, "nullable": true }, { "name": "RISK", "type": "esriFieldTypeSmallInteger", "alias": "Risk Score\n", "domain": null, "editable": true, "nullable": true }, { "name": "CRITICALITY", "type": "esriFieldTypeString", "alias": "Criticality\n", "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" }, "editable": true, "nullable": true, "length": 16 }, { "name": "REPLACEVALUE", "type": "esriFieldTypeDouble", "alias": "Replacement Value\n\n", "domain": null, "editable": true, "nullable": true }, { "name": "VALUEDATE", "type": "esriFieldTypeDate", "alias": "Valuation Date\n\n", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "CREATOR", "type": "esriFieldTypeString", "alias": "Creator\n", "domain": null, "editable": true, "nullable": true, "length": 30 }, { "name": "CREATEDATE", "type": "esriFieldTypeDate", "alias": "Created\n", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "Editor\n", "domain": null, "editable": true, "nullable": true, "length": 30 }, { "name": "EDITDATE", "type": "esriFieldTypeDate", "alias": "Edited\n", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "AMPS", "type": "esriFieldTypeString", "alias": "Amperage", "domain": null, "editable": true, "nullable": true, "length": 20 }, { "name": "VOLTS", "type": "esriFieldTypeString", "alias": "Voltage", "domain": null, "editable": true, "nullable": true, "length": 20 }, { "name": "CONTROLVOLTS", "type": "esriFieldTypeString", "alias": "Control Voltage", "domain": null, "editable": true, "nullable": true, "length": 20 }, { "name": "PHASE", "type": "esriFieldTypeString", "alias": "Phase", "domain": null, "editable": true, "nullable": true, "length": 30 }, { "name": "SERVICELIFE", "type": "esriFieldTypeDouble", "alias": "SERVICELIFE", "domain": null, "editable": true, "nullable": true } ], "indexes": [ { "name": "R275_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1626ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1626PARENTID", "fields": "PARENTID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Motor Control Center", "description": "", "prototype": { "attributes": { "PHASE": null, "SERVICELIFE": null, "ASSETID": null, "ASSETNAME": null, "ASSETTYPE": null, "ASSETOWNER": null, "LEGACYID": null, "TAGNUMBER": null, "STATUS": null, "PARENTID": null, "STARTUPDATE": null, "WARRANTYDATE": null, "CONDITIONSCORE": null, "CONDITIONDATE": null, "ADDRESS": null, "LOCATION": null, "SITE": null, "MANUFACTURER": null, "MANPHONE": null, "MANWEBSITE": null, "MODEL": null, "SERIALNO": null, "VENDOR": null, "SPECLINK": null, "OMLINK": null, "SYSTEM": null, "LOF": null, "COF": null, "RISK": null, "CRITICALITY": null, "REPLACEVALUE": null, "VALUEDATE": null, "NOTES": null, "CREATOR": null, "CREATEDATE": null, "EDITOR": null, "EDITDATE": null, "AMPS": null, "VOLTS": null, "CONTROLVOLTS": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, AMF, geoJSON", "capabilities": "Create,Query,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 1000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }