{ "currentVersion": 10.91, "id": 9, "name": "f_Pump", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "fStructureAreas", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "STRUCTUREAREA", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "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, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "FACILITYNAMES", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "PUMPTYPE", "type": "esriFieldTypeString", "alias": "Pump Type", "domain": { "type": "codedValue", "name": "PumpType", "description": "Type of Pump for facility", "codedValues": [ { "name": "Brine Feed Pump", "code": "Brine Feed Pump" }, { "name": "Centrifugal Pump", "code": "Centrifugal Pump" }, { "name": "Chemical Feed Pump", "code": "Chemical Feed Pump" }, { "name": "Chemical Transfer Pump", "code": "Chemical Transfer Pump" }, { "name": "High Service Pump", "code": "High Service Pump" }, { "name": "Hot Water Feed Pump", "code": "Hot Water Feed Pump" }, { "name": "Hot Water Recirculation Pump", "code": "Hot Water Recirculation Pump" }, { "name": "Primary Filtrate Pump", "code": "Primary Filtrate Pump" }, { "name": "Recirculation Pump", "code": "Recirculation Pump" }, { "name": "Secondary Feed Pump", "code": "Secondary Feed Pump" }, { "name": "Secondary Filtrate Pump", "code": "Secondary Filtrate Pump" }, { "name": "Submersible Pump", "code": "Submersible Pump" }, { "name": "Sump Pump", "code": "Sump Pump" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STRUCTURET" }, { "name": "PROCESSTYPE", "type": "esriFieldTypeString", "alias": "Process Type", "domain": { "type": "codedValue", "name": "ProcessType", "description": "Process Type of Facility Pump", "codedValues": [ { "name": "BD-2000", "code": "BD-2000" }, { "name": "Brine Pump", "code": "Brine Pump" }, { "name": "Chlorine", "code": "Chlorine" }, { "name": "Citric Acid", "code": "Citric Acid" }, { "name": "Flouride", "code": "Flouride" }, { "name": "HVAC", "code": "HVAC" }, { "name": "Hypochlorite", "code": "Hypochlorite" }, { "name": "Non Potable", "code": "Non Potable" }, { "name": "Phosphate ", "code": "Phosphate " }, { "name": "Phosphate", "code": "Phosphate" }, { "name": "Polyphosphate", "code": "Polyphosphate" }, { "name": "Potable Water", "code": "Potable Water" }, { "name": "Raw Sewage", "code": "Raw Sewage" }, { "name": "Raw Water", "code": "Raw Water" }, { "name": "Sludge", "code": "Sludge" }, { "name": "Sodium Hypochlorite", "code": "Sodium Hypochlorite" }, { "name": "Wash Water", "code": "Wash Water" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROCESSTYPE" }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": false, "nullable": true, "length": 25, "defaultValue": null, "modelName": "LOCATION" }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "Make", "domain": { "type": "codedValue", "name": "PumpMake", "description": "Maker of Facility Pump", "codedValues": [ { "name": "Aurora ", "code": "Aurora " }, { "name": "Hydromatic", "code": "Hydromatic" }, { "name": "Jesco", "code": "Jesco" }, { "name": "Paterson ", "code": "Paterson " }, { "name": "Wallanen & Terrian", "code": "Wallanen & Terrian" }, { "name": "Weinman", "code": "Weinman" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "MAKE" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "MODEL" }, { "name": "SERIAL", "type": "esriFieldTypeString", "alias": "SERIAL", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "SERIAL" }, { "name": "DATEINSERVE", "type": "esriFieldTypeDate", "alias": "Date in Service", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATEINSERVE" }, { "name": "SIZE", "type": "esriFieldTypeString", "alias": "Size", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SIZE" }, { "name": "GPM", "type": "esriFieldTypeSmallInteger", "alias": "Gallons Per Min", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GPM" }, { "name": "RPM", "type": "esriFieldTypeSmallInteger", "alias": "Revolutions Per Min", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RPM" }, { "name": "TDH", "type": "esriFieldTypeSmallInteger", "alias": "Total Dynamic Head", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TDH" }, { "name": "HP", "type": "esriFieldTypeSmallInteger", "alias": "Horse Power", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HP" }, { "name": "PHASE", "type": "esriFieldTypeSmallInteger", "alias": "Phase", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHASE" }, { "name": "HERTZ", "type": "esriFieldTypeSmallInteger", "alias": "Hertz", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HERTZ" }, { "name": "VOLTS", "type": "esriFieldTypeSmallInteger", "alias": "Volts", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VOLTS" }, { "name": "MOTORSERIAL", "type": "esriFieldTypeString", "alias": "Motor Serial ", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "MOTORSERIAL" }, { "name": "FACILITYNAMES", "type": "esriFieldTypeString", "alias": "Facility Names", "domain": { "type": "codedValue", "name": "FacilityName", "description": "Name of the facility", "codedValues": [ { "name": "ALGONQUIN SHORES LIFT STATION", "code": "ALGONQUIN SHORES LIFT STATION" }, { "name": "BRAEWOOD LIFT STATION", "code": "BRAEWOOD LIFT STATION" }, { "name": "BRITTANY HILLS LIFT STATION", "code": "BRITTANY HILLS LIFT STATION" }, { "name": "CARY BOOSTER", "code": "CARY BOOSTER" }, { "name": "CARY STANDPIPE", "code": "CARY STANDPIPE" }, { "name": "COPPER OAKS TOWER", "code": "COPPER OAKS TOWER" }, { "name": "COUNTRYSIDE BOOSTER", "code": "COUNTRYSIDE BOOSTER" }, { "name": "COUNTRYSIDE STANDPIPE", "code": "COUNTRYSIDE STANDPIPE" }, { "name": "GRAND RESERVE LIFT STATION", "code": "GRAND RESERVE LIFT STATION" }, { "name": "HANSON BOOSTER", "code": "HANSON BOOSTER" }, { "name": "HANSON WATER TOWER", "code": "HANSON WATER TOWER" }, { "name": "HILLSIDE BOOSTER", "code": "HILLSIDE BOOSTER" }, { "name": "HUNTINGTON BOOSTER", "code": "HUNTINGTON BOOSTER" }, { "name": "HUNTINGTON STANDPIPE", "code": "HUNTINGTON STANDPIPE" }, { "name": "JACOBS WATER TOWER", "code": "JACOBS WATER TOWER" }, { "name": "LAKEWOOD WATER TOWER", "code": "LAKEWOOD WATER TOWER" }, { "name": "LOWE DR LIFT STATION", "code": "LOWE DR LIFT STATION" }, { "name": "MEYER BOOSTER", "code": "MEYER BOOSTER" }, { "name": "NORTH HARRISON LIFT STATION", "code": "NORTH HARRISON LIFT STATION" }, { "name": "NORTH RIVER RD LIFT STATION", "code": "NORTH RIVER RD LIFT STATION" }, { "name": "POOL PUMP HOUSE", "code": "POOL PUMP HOUSE" }, { "name": "RIVER FRONT LIFT STATION", "code": "RIVER FRONT LIFT STATION" }, { "name": "SQUARE BARN LIFT STATION", "code": "SQUARE BARN LIFT STATION" }, { "name": "WASTE WATER TREATMENT PLANT", "code": "WASTE WATER TREATMENT PLANT" }, { "name": "WATER TREATMENT PLANT 1", "code": "WATER TREATMENT PLANT 1" }, { "name": "WATER TREATMENT PLANT 2", "code": "WATER TREATMENT PLANT 2" }, { "name": "WATER TREATMENT PLANT 3", "code": "WATER TREATMENT PLANT 3" }, { "name": "WELL 10", "code": "WELL 10" }, { "name": "WELL 11", "code": "WELL 11" }, { "name": "WELL 13", "code": "WELL 13" }, { "name": "WELL 15", "code": "WELL 15" }, { "name": "WELL 5", "code": "WELL 5" }, { "name": "WELL 6", "code": "WELL 6" }, { "name": "WELL 7", "code": "WELL 7" }, { "name": "WELL 8", "code": "WELL 8" }, { "name": "WELL 9", "code": "WELL 9" }, { "name": "WOODS CREEK LIFT STATION", "code": "WOODS CREEK LIFT STATION" }, { "name": "ZANGE BOOSTER", "code": "ZANGE BOOSTER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "FACILITYNAMES" }, { "name": "PUMPNAME", "type": "esriFieldTypeString", "alias": "Pump Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PUMPNAME" }, { "name": "INSTALLYEAR", "type": "esriFieldTypeString", "alias": "Install Year", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "INSTALLYEAR" }, { "name": "USEFULLIFE", "type": "esriFieldTypeSmallInteger", "alias": "Useful Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "USEFULLIFE" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status_Record", "description": "The status of record", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Engineering", "code": "Engineer" }, { "name": "Abandoned", "code": "Abandon" }, { "name": "Permanently Removed", "code": "Removed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "STATUS" }, { "name": "STRUCTUREAREA", "type": "esriFieldTypeString", "alias": "Structure Area", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STRUCTUREAREA" } ], "indexes": [ { "name": "R1075_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9743_STRUCTU", "fields": "STRUCTUREAREA", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "f_Pump", "description": "", "prototype": { "attributes": { "STATUS": null, "PUMPNAME": null, "USEFULLIFE": null, "PUMPTYPE": null, "PROCESSTYPE": null, "INSTALLYEAR": null, "MAKE": null, "MODEL": null, "SERIAL": null, "DATEINSERVE": null, "SIZE": null, "GPM": null, "RPM": null, "TDH": null, "HP": null, "PHASE": null, "HERTZ": null, "VOLTS": null, "MOTORSERIAL": null, "FACILITYNAMES": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "c26142f4de4b48ef94236c8b5799183b" }