{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "gisdb.sde.waterlevel_manual_entry", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "gisdb.sde.master_gw1", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "linkobjid", "composite": false } ], "isDataVersioned": false, "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "globalid", "displayField": "wims_id", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "wims_id", "type": "esriFieldTypeString", "alias": "Wims ID", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "wims_id" }, { "name": "dataloggerid", "type": "esriFieldTypeString", "alias": "Data Logger ID", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "dataloggerid" }, { "name": "season", "type": "esriFieldTypeString", "alias": "Season", "domain": { "type": "codedValue", "name": "season", "description": "season", "codedValues": [ { "name": "Pre-Monsoon", "code": "Pre-Monsoon" }, { "name": "Post-Monsoon", "code": "Post-Monsoon" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "season" }, { "name": "measurement_method", "type": "esriFieldTypeString", "alias": "Measurement Method", "domain": { "type": "codedValue", "name": "measurement_method", "description": "measurement_method", "codedValues": [ { "name": "Electric Tape", "code": "Electric Tape" }, { "name": "DWLR Manual Mode", "code": "DWLR Manual Mode" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "measurement_method" }, { "name": "inputdatetime", "type": "esriFieldTypeDate", "alias": "Inputdate Time", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "inputdatetime" }, { "name": "mobilenumber", "type": "esriFieldTypeString", "alias": "Mobilenumber", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "mobilenumber" }, { "name": "batteryvoltage_v", "type": "esriFieldTypeDouble", "alias": "Battery Voltage_v", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "batteryvoltage_v" }, { "name": "ground_water_level", "type": "esriFieldTypeDouble", "alias": "Ground Water Level", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ground_water_level" }, { "name": "water_temperature", "type": "esriFieldTypeDouble", "alias": "Water Temperature", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "water_temperature" }, { "name": "barometric_pressure_hpa", "type": "esriFieldTypeDouble", "alias": "Barometric Pressure hpa", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "barometric_pressure_hpa" }, { "name": "conductivity", "type": "esriFieldTypeDouble", "alias": "Conductivity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "conductivity" }, { "name": "uncompensated_water_lvl_m", "type": "esriFieldTypeDouble", "alias": "Uncompensated Water Level m", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "uncompensated_water_lvl_m" }, { "name": "instant_rain_mm", "type": "esriFieldTypeDouble", "alias": "Instant Rain mm", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "instant_rain_mm" }, { "name": "daily_rain_mm", "type": "esriFieldTypeDouble", "alias": "Daily Rain mm", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "daily_rain_mm" }, { "name": "barometerreading", "type": "esriFieldTypeDouble", "alias": "Barometer Reading", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "barometerreading" }, { "name": "uncompensatedwaterlvl", "type": "esriFieldTypeDouble", "alias": "Uncompensated Water lvl", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "uncompensatedwaterlvl" }, { "name": "ph", "type": "esriFieldTypeDouble", "alias": "pH (Hydrogen Ion Concentration)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ph" }, { "name": "ec_us_cm", "type": "esriFieldTypeDouble", "alias": "Electrical Conductivity (µS/cm)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ec_us_cm" }, { "name": "tds_mg_l", "type": "esriFieldTypeDouble", "alias": "Total Dissolved Solids (mg/L)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "tds_mg_l" }, { "name": "calcium_mg_l", "type": "esriFieldTypeDouble", "alias": "Calcium (Ca²\u207a) (mg/L)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "calcium_mg_l" }, { "name": "magnesium_mg_l", "type": "esriFieldTypeDouble", "alias": "Magnesium (Mg²\u207a) (mg/L)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "magnesium_mg_l" }, { "name": "sodium_mg_l", "type": "esriFieldTypeDouble", "alias": "Sodium (Na\u207a) (mg/L)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "sodium_mg_l" }, { "name": "potassium_mg_l", "type": "esriFieldTypeDouble", "alias": "Potassium (K\u207a) (mg/L)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "potassium_mg_l" }, { "name": "chloride_mg_l", "type": "esriFieldTypeDouble", "alias": "Chloride (Cl\u207b) (mg/L)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "chloride_mg_l" }, { "name": "bicarbonate_mg_l", "type": "esriFieldTypeDouble", "alias": "Bicarbonate (HCO\u2083\u207b) (mg/L)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "bicarbonate_mg_l" }, { "name": "sulphate_mg_l", "type": "esriFieldTypeDouble", "alias": "Sulphate (SO\u2084²\u207b) (mg/L)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "sulphate_mg_l" }, { "name": "nitrate_mg_l", "type": "esriFieldTypeDouble", "alias": "Nitrate (NO\u2083\u207b) (mg/L)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "nitrate_mg_l" }, { "name": "fluoride_mg_l", "type": "esriFieldTypeDouble", "alias": "Fluoride (F\u207b) (mg/L)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "fluoride_mg_l" }, { "name": "dwlr_water_level_m", "type": "esriFieldTypeDouble", "alias": "DWLR Water Level (m below ground level)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "dwlr_water_level_m" }, { "name": "difference_cm", "type": "esriFieldTypeDouble", "alias": "Difference Between Manual and DWLR Reading (cm)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "difference_cm" }, { "name": "discrepancy_flag", "type": "esriFieldTypeString", "alias": "Discrepancy Flag (Exceeds 10 cm Threshold)", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "discrepancy_flag" }, { "name": "calibration_required", "type": "esriFieldTypeString", "alias": "Calibration Required (Yes/No)", "domain": { "type": "codedValue", "name": "domainyes_no", "description": "domainyes_no", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "calibration_required" }, { "name": "calibration_date", "type": "esriFieldTypeDate", "alias": "Calibration Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "calibration_date" }, { "name": "calibration_remarks", "type": "esriFieldTypeString", "alias": "Calibration Remarks", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "calibration_remarks" }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "globalid", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "globalid" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "linkobjid", "type": "esriFieldTypeInteger", "alias": "linkobjid", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "linkobjid" } ], "indexes": [ { "name": "gdb_4137_linkobj", "fields": "linkobjid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r163_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_163", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "gisdb.sde.waterlevel_manual_entry", "description": "", "prototype": { "attributes": { "calibration_remarks": null, "linkobjid": null, "wims_id": null, "dataloggerid": null, "season": null, "measurement_method": null, "inputdatetime": null, "mobilenumber": null, "batteryvoltage_v": null, "ground_water_level": null, "water_temperature": null, "barometric_pressure_hpa": null, "conductivity": null, "uncompensated_water_lvl_m": null, "instant_rain_mm": null, "daily_rain_mm": null, "barometerreading": null, "uncompensatedwaterlvl": null, "ph": null, "ec_us_cm": null, "tds_mg_l": null, "calcium_mg_l": null, "magnesium_mg_l": null, "sodium_mg_l": null, "potassium_mg_l": null, "chloride_mg_l": null, "bicarbonate_mg_l": null, "sulphate_mg_l": null, "nitrate_mg_l": null, "fluoride_mg_l": null, "dwlr_water_level_m": null, "difference_cm": null, "discrepancy_flag": null, "calibration_required": null, "calibration_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Extract", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "attachmentid", "isEnabled": true }, { "name": "globalId", "fieldName": "globalid", "isEnabled": true }, { "name": "name", "fieldName": "att_name", "isEnabled": true }, { "name": "size", "fieldName": "data_size", "isEnabled": true }, { "name": "contentType", "fieldName": "content_type", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "attachmentid", "type": "esriFieldTypeOID", "alias": "attachmentid", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "globalid", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "att_name", "type": "esriFieldTypeString", "alias": "att_name", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "data_size", "type": "esriFieldTypeInteger", "alias": "data_size", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "content_type", "type": "esriFieldTypeString", "alias": "content_type", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "7df1aed91f24472481d7136bf9292312" }