{ "currentVersion": 10.61, "id": 73, "name": "Pump Unit", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 3, "name": "Aerator", "relatedTableId": 33, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ASSETID", "composite": false }, { "id": 163, "name": "Control Panel", "relatedTableId": 49, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ASSETID", "composite": false }, { "id": 179, "name": "Gearbox", "relatedTableId": 53, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ASSETID", "composite": false }, { "id": 231, "name": "Instrumentation", "relatedTableId": 60, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ASSETID", "composite": false }, { "id": 248, "name": "Motor", "relatedTableId": 65, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ASSETID", "composite": false }, { "id": 254, "name": "Motor Control Center", "relatedTableId": 66, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ASSETID", "composite": false }, { "id": 274, "name": "Pump", "relatedTableId": 72, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ASSETID", "composite": false }, { "id": 275, "name": "Valve", "relatedTableId": 85, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ASSETID", "composite": false }, { "id": 171, "name": "Engine", "relatedTableId": 51, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleOrigin", "keyField": "ASSETID", "composite": false }, { "id": 41, "name": "Area", "relatedTableId": 36, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 106, "name": "Building", "relatedTableId": 42, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 128, "name": "Chemical Feed Equipment", "relatedTableId": 45, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 202, "name": "sde_SanDigeo.DBO.wwfGrounds", "relatedTableId": 56, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 259, "name": "Packaged Unit", "relatedTableId": 68, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 265, "name": "Process Structure", "relatedTableId": 71, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 276, "name": "Site Structure", "relatedTableId": 79, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 277, "name": "Tank", "relatedTableId": 82, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PARENTID", "composite": false }, { "id": 278, "name": "Vault", "relatedTableId": 86, "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": "LEGACYID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "TAGNUMBER", "type": "esriFieldTypeString", "alias": "Tag Number", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "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", "domain": null, "editable": true, "nullable": true, "length": 100 }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "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": "SYSTEM", "type": "esriFieldTypeString", "alias": "System Designator", "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": "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 } ], "indexes": [ { "name": "R284_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1635ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1635PARENTID", "fields": "PARENTID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Pump Unit", "description": "", "prototype": { "attributes": { "EDITOR": null, "EDITDATE": null, "ASSETID": null, "ASSETNAME": null, "LEGACYID": null, "TAGNUMBER": null, "STATUS": null, "PARENTID": null, "ADDRESS": null, "LOCATION": null, "SITE": null, "SYSTEM": null, "NOTES": null, "CREATOR": null, "CREATEDATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, AMF, geoJSON", "capabilities": "Create,Query,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 1000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }