{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 7, "name": "Equipment", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "WAVEFORM", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "EVENT_ID", "type": "esriFieldTypeGUID", "alias": "Event ID", "length": 38, "domain": null }, { "name": "WAVEFORM", "type": "esriFieldTypeString", "alias": "Waveform", "length": 50, "domain": { "type": "codedValue", "name": "waveforms", "description": "Waveform", "codedValues": [ { "name": "Alternate current", "code": "Alternate current" }, { "name": "Burst", "code": "Burst" }, { "name": "Direct current", "code": "Direct current" }, { "name": "Pulsed AC", "code": "Pulsed AC" }, { "name": "Pulsed DC", "code": "Pulsed DC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DUTY_CYCLE", "type": "esriFieldTypeSmallInteger", "alias": "Duty Cycle", "domain": null }, { "name": "FREQUENCY", "type": "esriFieldTypeSmallInteger", "alias": "Frequency", "domain": null }, { "name": "NUM_ANODES", "type": "esriFieldTypeSmallInteger", "alias": "# Anodes", "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": { "type": "codedValue", "name": "equipment_models", "description": "Equipment Models", "codedValues": [ { "name": "Coffelt VVP-15", "code": "Coffelt VVP-15" }, { "name": "Coffelt VVP MK 22", "code": "Coffelt VVP MK 22" }, { "name": "Smith Root 1.5KVA", "code": "Smith Root 1.5KVA" }, { "name": "Smith Root B-12", "code": "Smith Root B-12" }, { "name": "Smith Root GPP 2.5", "code": "Smith Root GPP 2.5" }, { "name": "Smith Root GPP 5.0", "code": "Smith Root GPP 5.0" }, { "name": "Smith Root GPP 7.5", "code": "Smith Root GPP 7.5" }, { "name": "Smith Root GPP 9.0", "code": "Smith Root GPP 9.0" }, { "name": "Smith Root LR-20", "code": "Smith Root LR-20" }, { "name": "Smith Root LR-24", "code": "Smith Root LR-24" }, { "name": "Smith Root VI-A", "code": "Smith Root VI-A" }, { "name": "Smith Root VVP 15B", "code": "Smith Root VVP 15B" }, { "name": "Halltech HT2000", "code": "Halltech HT2000" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ARRAY_TYPE", "type": "esriFieldTypeString", "alias": "ARRAY_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "array_types", "description": "Array types", "codedValues": [ { "name": "Diamond anode", "code": "Diamond anode" }, { "name": "Round anode", "code": "Round anode" }, { "name": "Spherical array", "code": "Spherical array" }, { "name": "Square net anode", "code": "Square net anode" }, { "name": "Wisconsin ring array", "code": "Wisconsin ring array" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NUM_NETTERS", "type": "esriFieldTypeSmallInteger", "alias": "NUM_NETTERS", "domain": null }, { "name": "CATHODE_TYPE", "type": "esriFieldTypeString", "alias": "CATHODE_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "cathode_types", "description": "Cathode Types", "codedValues": [ { "name": "Boat", "code": "Boat" }, { "name": "Non-boat", "code": "Non-boat" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 50, "domain": { "type": "codedValue", "name": "equipment_type", "description": "Equipment Types", "codedValues": [ { "name": "Backpack", "code": "Backpack" }, { "name": "Canoe/Barge", "code": "Canoe/Barge" }, { "name": "Raft/Boat", "code": "Raft/Boat" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PEDAL_TIME", "type": "esriFieldTypeInteger", "alias": "Duration/Pedal Time in Seconds", "domain": null }, { "name": "EQUIPMENT_ID", "type": "esriFieldTypeGUID", "alias": "Equipment ID", "length": 38, "domain": null }, { "name": "VOLTAGE", "type": "esriFieldTypeSingle", "alias": "Voltage", "domain": null }, { "name": "AMPS", "type": "esriFieldTypeSingle", "alias": "Amps", "domain": null }, { "name": "CATHODE_LEN", "type": "esriFieldTypeSingle", "alias": "Cathode Length", "domain": null }, { "name": "CATHODE_DIAMETER", "type": "esriFieldTypeSingle", "alias": "Cathode Diameter", "domain": null }, { "name": "MACHINE_RES", "type": "esriFieldTypeInteger", "alias": "Machine-specific resistence", "domain": null } ], "indexes": [ { "name": "R14_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G44EQUIPMENT_ID", "fields": "EQUIPMENT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G44EVENT_ID", "fields": "EVENT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "Anodes", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "EQUIPMENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 2, "name": "SamplingEvents", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "EVENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": true, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }