{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "Lift Station Maintenance Records", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "ssLiftStations", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "LiftStationID", "composite": false, "catalogID": "{FFFD2EA9-6E64-41A6-A30F-FDB95CEFD308}" }, { "id": 1, "name": "ssLiftStations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "LiftStationID", "composite": false, "catalogID": "{FFFD2EA9-6E64-41A6-A30F-FDB95CEFD308}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "LiftStationID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "LiftStationID", "type": "esriFieldTypeString", "alias": "LiftStationID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "LiftStationID" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "LSPumpStatus", "description": "Status of Pump within LS", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Retired", "code": "Retired" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "WetWellDepth" }, { "name": "SlotNumber", "type": "esriFieldTypeString", "alias": "SlotNumber", "domain": { "type": "codedValue", "name": "LSSlotCount", "description": "Slot Count", "codedValues": [ { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SlotNumber" }, { "name": "PumpManuf", "type": "esriFieldTypeString", "alias": "PumpManuf", "domain": { "type": "codedValue", "name": "PumpManuf", "description": "Pump Manufacturer List", "codedValues": [ { "name": "Allis Charmer", "code": "Allis Charmer" }, { "name": "Barnes", "code": "Barnes" }, { "name": "Crane Demming", "code": "Crane Demming" }, { "name": "Crown", "code": "Crown" }, { "name": "EMU", "code": "EMU" }, { "name": "Emerson", "code": "Emerson" }, { "name": "Fairbanks Morse", "code": "Fairbanks Morse" }, { "name": "FLYGT", "code": "FLYGT" }, { "name": "Gorman Rupp", "code": "Gorman Rupp" }, { "name": "HOMA", "code": "HOMA" }, { "name": "Smith & Loveless", "code": "Smith & Loveless" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "PumpManuf" }, { "name": "PumpModel", "type": "esriFieldTypeString", "alias": "PumpModel", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "PumpModel" }, { "name": "PumpSerial", "type": "esriFieldTypeString", "alias": "PumpSerial", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PumpSerial" }, { "name": "PumpSize", "type": "esriFieldTypeString", "alias": "PumpSize", "domain": { "type": "codedValue", "name": "PumpSize", "description": "Pump Size List", "codedValues": [ { "name": "2\"", "code": "2\"" }, { "name": "4\"", "code": "4\"" }, { "name": "6\"", "code": "6\"" }, { "name": "8\"", "code": "8\"" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "PumpSize" }, { "name": "ImpellerSize", "type": "esriFieldTypeString", "alias": "ImpellerSize", "domain": { "type": "codedValue", "name": "ImpellerSize", "description": "Impeller Size List", "codedValues": [ { "name": "4 7/8", "code": "4 7/8" }, { "name": "6 3/4", "code": "6 3/4" }, { "name": "7 CCW", "code": "7 CCW" }, { "name": "7.25", "code": "7.25" }, { "name": "8L", "code": "8L" }, { "name": "8 1/2", "code": "8 1/2" }, { "name": "8.75", "code": "8.75" }, { "name": "9", "code": "9" }, { "name": "9 3/8", "code": "9 3/8" }, { "name": "9 7/8", "code": "9 7/8" }, { "name": "10 3/8", "code": "10 3/8" }, { "name": "10.74", "code": "10.74" }, { "name": "14", "code": "14" }, { "name": "14.55", "code": "14.55" }, { "name": "147", "code": "147" }, { "name": "189", "code": "189" }, { "name": "194", "code": "194" }, { "name": "208", "code": "208" }, { "name": "209", "code": "209" }, { "name": "223", "code": "223" }, { "name": "238MM", "code": "238MM" }, { "name": "246", "code": "246" }, { "name": "282", "code": "282" }, { "name": "290MM", "code": "290MM" }, { "name": "433MM", "code": "433MM" }, { "name": "442", "code": "442" }, { "name": "454", "code": "454" }, { "name": "462", "code": "462" }, { "name": "483", "code": "483" }, { "name": "484", "code": "484" }, { "name": "249", "code": "249" }, { "name": "300", "code": "300" }, { "name": "452", "code": "452" }, { "name": "T-172", "code": "T-172" }, { "name": "241", "code": "241" }, { "name": "245", "code": "245" }, { "name": "68", "code": "68" }, { "name": "230", "code": "230" }, { "name": "258", "code": "258" }, { "name": "330", "code": "330" }, { "name": "487", "code": "487" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "ImpellerSize" }, { "name": "CheckValveSize", "type": "esriFieldTypeString", "alias": "CheckValve", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "CheckValveSize" }, { "name": "DischargeValveSize", "type": "esriFieldTypeString", "alias": "DischargeValveSize", "domain": { "type": "codedValue", "name": "DischargePipeSize", "description": "Discharge Pipe Size", "codedValues": [ { "name": "2\"", "code": "2\"" }, { "name": "4\"", "code": "4\"" }, { "name": "6\"", "code": "6\"" }, { "name": "8\"", "code": "8\"" }, { "name": "16\"", "code": "16\"" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "DischargeValveSize" }, { "name": "Misc", "type": "esriFieldTypeString", "alias": "Misc", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Misc" }, { "name": "MotorManuf", "type": "esriFieldTypeString", "alias": "MotorManuf", "domain": { "type": "codedValue", "name": "MotorManuf", "description": "Motor Manufacturer", "codedValues": [ { "name": "BALDOR", "code": "BALDOR" }, { "name": "EMU", "code": "EMU" }, { "name": "FLYGT", "code": "FLYGT" }, { "name": "MARATHON", "code": "MARATHON" }, { "name": "MEYERS", "code": "MEYERS" }, { "name": "SMITH & LOVELESS", "code": "SMITH & LOVELESS" }, { "name": "US", "code": "US" }, { "name": "XYLEM", "code": "XYLEM" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "MotorManuf" }, { "name": "MotorModel", "type": "esriFieldTypeString", "alias": "MotorModel", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "MotorModel" }, { "name": "MotorSerial", "type": "esriFieldTypeString", "alias": "MotorSerial", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MotorSerial" }, { "name": "MotorHP", "type": "esriFieldTypeString", "alias": "MotorHP", "domain": { "type": "codedValue", "name": "MotorHP", "description": "Motor Horsepower", "codedValues": [ { "name": "1/2 Hp", "code": "1/2 Hp" }, { "name": "1/3 Hp", "code": "1/3 Hp" }, { "name": "2 Hp", "code": "2 Hp" }, { "name": "2.3 Hp", "code": "2.3 Hp" }, { "name": "3 Hp", "code": "3 Hp" }, { "name": "3.6 Hp", "code": "3.6 Hp" }, { "name": "5 Hp", "code": "5 Hp" }, { "name": "5.4 Hp", "code": "5.4 Hp" }, { "name": "6.2 Hp", "code": "6.2 Hp" }, { "name": "7.5 Hp", "code": "7.5 Hp" }, { "name": "10 Hp", "code": "10 Hp" }, { "name": "15 Hp", "code": "15 Hp" }, { "name": "15.4 Hp", "code": "15.4 Hp" }, { "name": "20 Hp", "code": "20 Hp" }, { "name": "23 Hp", "code": "23 Hp" }, { "name": "23.5 Hp", "code": "23.5 Hp" }, { "name": "25 Hp", "code": "25 Hp" }, { "name": "30 Hp", "code": "30 Hp" }, { "name": "32 Hp", "code": "32 Hp" }, { "name": "50 Hp", "code": "50 Hp" }, { "name": "57 Hp", "code": "57 Hp" }, { "name": "200 Hp", "code": "200 Hp" }, { "name": "31.5 Hp", "code": "31.5 Hp" }, { "name": "47 Hp", "code": "47 Hp" }, { "name": "56 Hp", "code": "56 Hp" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "MotorHP" }, { "name": "MotorRPM", "type": "esriFieldTypeString", "alias": "MotorRPM", "domain": { "type": "codedValue", "name": "PumpRPM", "description": "Pump RPM", "codedValues": [ { "name": "1155", "code": "1155" }, { "name": "1160", "code": "1160" }, { "name": "1170", "code": "1170" }, { "name": "1200", "code": "1200" }, { "name": "1740", "code": "1740" }, { "name": "1745", "code": "1745" }, { "name": "1750", "code": "1750" }, { "name": "1800", "code": "1800" }, { "name": "3600", "code": "3600" }, { "name": "1700", "code": "1700" }, { "name": "1720", "code": "1720" }, { "name": "1680", "code": "1680" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MotorRPM" }, { "name": "MotorAMPS", "type": "esriFieldTypeString", "alias": "MotorAMPS", "domain": { "type": "codedValue", "name": "MotorAmps", "description": "Motor Amps", "codedValues": [ { "name": "3.2", "code": "3.2" }, { "name": "3.6", "code": "3.6" }, { "name": "7.8", "code": "7.8" }, { "name": "9", "code": "9" }, { "name": "15", "code": "15" }, { "name": "21", "code": "21" }, { "name": "26", "code": "26" }, { "name": "28", "code": "28" }, { "name": "37", "code": "37" }, { "name": "39", "code": "39" }, { "name": "40", "code": "40" }, { "name": "42", "code": "42" }, { "name": "44", "code": "44" }, { "name": "58", "code": "58" }, { "name": "67", "code": "67" }, { "name": "75", "code": "75" }, { "name": "226", "code": "226" }, { "name": "20", "code": "20" }, { "name": "84", "code": "84" }, { "name": "28.5", "code": "28.5" }, { "name": "23", "code": "23" }, { "name": "50", "code": "50" }, { "name": "34", "code": "34" }, { "name": "18", "code": "18" }, { "name": "22", "code": "22" }, { "name": "60", "code": "60" }, { "name": "71", "code": "71" }, { "name": "74", "code": "74" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MotorAMPS" }, { "name": "MotorVoltage", "type": "esriFieldTypeString", "alias": "MotorVoltage", "domain": { "type": "codedValue", "name": "StationVoltage", "description": "Station Voltage", "codedValues": [ { "name": "230v", "code": "230v" }, { "name": "460v", "code": "460v" }, { "name": "480v", "code": "480v" }, { "name": "VFD", "code": "VFD" }, { "name": "240v", "code": "240v" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MotorVoltage" }, { "name": "MotorServiceSize", "type": "esriFieldTypeString", "alias": "MotorServiceSize", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MotorServiceSize" }, { "name": "MotorFrame", "type": "esriFieldTypeString", "alias": "MotorFrame", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MotorFrame" }, { "name": "MotorHZ", "type": "esriFieldTypeString", "alias": "MotorHZ", "domain": { "type": "codedValue", "name": "MotorHz", "description": "Motor Hz", "codedValues": [ { "name": "60", "code": "60" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "MotorHZ" }, { "name": "MotorPhase", "type": "esriFieldTypeString", "alias": "MotorPhase", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MotorPhase" }, { "name": "MotorBreaker", "type": "esriFieldTypeString", "alias": "MotorBreaker", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MotorBreaker" }, { "name": "PumpCondition", "type": "esriFieldTypeString", "alias": "PumpCondition", "domain": { "type": "codedValue", "name": "PumpCondition", "description": "Condition of Pump", "codedValues": [ { "name": "New", "code": "New" }, { "name": "Used", "code": "Used" }, { "name": "Refurbished", "code": "Refurbished" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "PumpCondition" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "RepairDate", "type": "esriFieldTypeDate", "alias": "Repair Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RepairDate" }, { "name": "RetireDate", "type": "esriFieldTypeDate", "alias": "Retire Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RetireDate" } ], "indexes": [ { "name": "R101_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "UUID_101", "isAscending": true, "isUnique": false, "description": "", "fields": "GlobalID" }, { "name": "G2195LiftStation", "isAscending": true, "isUnique": false, "description": "", "fields": "LiftStationID" }, { "name": "UUID_OID_101", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID,OBJECTID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Lift Station Maintenance Records", "description": "", "prototype": { "attributes": { "RepairDate": null, "InstallDate": null, "LiftStationID": null, "Status": null, "SlotNumber": null, "PumpManuf": null, "PumpModel": null, "PumpSerial": null, "PumpSize": null, "ImpellerSize": null, "CheckValveSize": null, "DischargeValveSize": null, "Misc": null, "MotorManuf": null, "MotorModel": null, "MotorSerial": null, "MotorHP": null, "MotorRPM": null, "MotorAMPS": null, "MotorVoltage": null, "MotorServiceSize": null, "MotorFrame": null, "MotorHZ": null, "MotorPhase": null, "MotorBreaker": null, "PumpCondition": null, "RetireDate": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "3aecdfdbaec44f6890bcc53f407e7232" }