{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 4, "name": "wua.sde.scheme_season_cropplaning", "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": 2, "name": "wua.sde.projectschemes", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "schobjectid", "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": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "globalid", "displayField": "cropname", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "schobjectid", "type": "esriFieldTypeInteger", "alias": "Scheme Object ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "schobjectid" }, { "name": "type_of_scheme", "type": "esriFieldTypeString", "alias": "Scheme Type", "domain": { "type": "codedValue", "name": "surveytypeofscheme", "description": "surveytypeofscheme", "codedValues": [ { "name": "CD Check Dam", "code": "CD Check Dam" }, { "name": "DW", "code": "DW" }, { "name": "Farm Pond", "code": "Farm Pond" }, { "name": "Field Channel", "code": "Field Channel" }, { "name": "HAPPA", "code": "HAPPA" }, { "name": "JHORA", "code": "JHORA" }, { "name": "LI", "code": "LI" }, { "name": "LI - Midi (E) RLI", "code": "LI - Midi (E) RLI" }, { "name": "LI - Midi RLI", "code": "LI - Midi RLI" }, { "name": "LI - Mini (E) RLI", "code": "LI - Mini (E) RLI" }, { "name": "LI - MRLI", "code": "LI - MRLI" }, { "name": "LI - RLI", "code": "LI - RLI" }, { "name": "LI (E)", "code": "LI (E)" }, { "name": "MI TANK MIT", "code": "MI TANK MIT" }, { "name": "MICRIRR - Drip & Poly House", "code": "MICRIRR - Drip & Poly House" }, { "name": "MICRIRR - Drip-Sprinkler & Poly House", "code": "MICRIRR - Drip-Sprinkler & Poly House" }, { "name": "MICRIRR - Polyhouse ", "code": "MICRIRR - Polyhouse " }, { "name": "MICRIRR - Polyhouse with Sprinkler", "code": "MICRIRR - Polyhouse with Sprinkler" }, { "name": "PDW ", "code": "PDW " }, { "name": "PDW (Drip)", "code": "PDW (Drip)" }, { "name": "PDW (S)", "code": "PDW (S)" }, { "name": "PDW (Sprinklar)", "code": "PDW (Sprinklar)" }, { "name": "RLI Major ", "code": "RLI Major " }, { "name": "RLI Mini Solar", "code": "RLI Mini Solar" }, { "name": "SFMIS", "code": "SFMIS" }, { "name": "Sprinkler (E)", "code": "Sprinkler (E)" }, { "name": "Sprinkler Diesel", "code": "Sprinkler Diesel" }, { "name": "SPSIS", "code": "SPSIS" }, { "name": "TW", "code": "TW" }, { "name": "TW - LDTW", "code": "TW - LDTW" }, { "name": "TW - LDTW (E)", "code": "TW - LDTW (E)" }, { "name": "TW - LDTW (S)", "code": "TW - LDTW (S)" }, { "name": "TW - MDTW", "code": "TW - MDTW" }, { "name": "TW - MDTW (E)", "code": "TW - MDTW (E)" }, { "name": "TW - STW", "code": "TW - STW" }, { "name": "TW - STW (E)", "code": "TW - STW (E)" }, { "name": "TW (E)", "code": "TW (E)" }, { "name": "TW (S)", "code": "TW (S)" }, { "name": "TW DTW Deep Tube Well", "code": "TW DTW Deep Tube Well" }, { "name": "TW HDTW Heavy Duty Tube Well", "code": "TW HDTW Heavy Duty Tube Well" }, { "name": "TW MDTW Medium Duty Tube Well", "code": "TW MDTW Medium Duty Tube Well" }, { "name": "TW SOSTW State Owned Shallow Tube Well", "code": "TW SOSTW State Owned Shallow Tube Well" }, { "name": "WDS ", "code": "WDS " }, { "name": "WDS (CANAL)", "code": "WDS (CANAL)" }, { "name": "WDS (POND)", "code": "WDS (POND)" }, { "name": "WDS (WHT)", "code": "WDS (WHT)" }, { "name": "WHR", "code": "WHR" }, { "name": "WHT", "code": "WHT" }, { "name": "WHT (RWHT)", "code": "WHT (RWHT)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "type_of_scheme" }, { "name": "season", "type": "esriFieldTypeString", "alias": "Season", "domain": { "type": "codedValue", "name": "croppingseasons", "description": "croppingseasons", "codedValues": [ { "name": "Kharif", "code": "Kharif" }, { "name": "Rabi", "code": "Rabi" }, { "name": "Zaid", "code": "Zaid" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "season" }, { "name": "year", "type": "esriFieldTypeString", "alias": "Year", "domain": { "type": "codedValue", "name": "croppingyear", "description": "croppingyear", "codedValues": [ { "name": "2022-2023", "code": "2022-2023" }, { "name": "2023-2024", "code": "2023-2024" }, { "name": "2024-2025", "code": "2024-2025" }, { "name": "2025-2026", "code": "2025-2026" }, { "name": "2026-2027", "code": "2026-2027" }, { "name": "2027-2028", "code": "2027-2028" }, { "name": "2028-2029", "code": "2028-2029" }, { "name": "2029-2030", "code": "2029-2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "year" }, { "name": "cropname", "type": "esriFieldTypeString", "alias": "Crop Name", "domain": { "type": "codedValue", "name": "cropdomain", "description": "cropdomain", "codedValues": [ { "name": "Aromatic Paddy", "code": "Aromatic Paddy" }, { "name": "Aromatic Rice", "code": "Aromatic Rice" }, { "name": "Banana", "code": "Banana" }, { "name": "Beans", "code": "Beans" }, { "name": "Ber", "code": "Ber" }, { "name": "Bitter gourd", "code": "Bitter gourd" }, { "name": "Brinjal", "code": "Brinjal" }, { "name": "Broom Stick", "code": "Broom Stick" }, { "name": "Cabbage", "code": "Cabbage" }, { "name": "Carrot", "code": "Carrot" }, { "name": "Cauliflower", "code": "Cauliflower" }, { "name": "Chilli", "code": "Chilli" }, { "name": "Churpi", "code": "Churpi" }, { "name": "Coriander", "code": "Coriander" }, { "name": "Cucumber", "code": "Cucumber" }, { "name": "Elephant Footyam", "code": "Elephant Footyam" }, { "name": "French Been", "code": "French Been" }, { "name": "Garlic", "code": "Garlic" }, { "name": "Ginger", "code": "Ginger" }, { "name": "Green Chillis", "code": "Green Chillis" }, { "name": "Green gram", "code": "Green gram" }, { "name": "Ground nut", "code": "Ground nut" }, { "name": "Kavurol", "code": "Kavurol" }, { "name": "Large Cardamom", "code": "Large Cardamom" }, { "name": "Lentil", "code": "Lentil" }, { "name": "Maize", "code": "Maize" }, { "name": "Mandarin Orange", "code": "Mandarin Orange" }, { "name": "Mango", "code": "Mango" }, { "name": "Mustard", "code": "Mustard" }, { "name": "Okra", "code": "Okra" }, { "name": "Onion", "code": "Onion" }, { "name": "Onion leaf", "code": "Onion leaf" }, { "name": "Paddy", "code": "Paddy" }, { "name": "Pea", "code": "Pea" }, { "name": "Peas", "code": "Peas" }, { "name": "Pointed Gourd", "code": "Pointed Gourd" }, { "name": "POTATO", "code": "POTATO" }, { "name": "Round chilli", "code": "Round chilli" }, { "name": "Sesame", "code": "Sesame" }, { "name": "Squash", "code": "Squash" }, { "name": "Tomato", "code": "Tomato" }, { "name": "Turmeric", "code": "Turmeric" }, { "name": "Watermelon", "code": "Watermelon" }, { "name": "Pulse", "code": "Pulse" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "cropname" }, { "name": "cropvariety", "type": "esriFieldTypeString", "alias": "Crop Variety", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "cropvariety" }, { "name": "area_ha", "type": "esriFieldTypeDouble", "alias": "Area ha", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "area_ha" }, { "name": "estimated_landareaha", "type": "esriFieldTypeDouble", "alias": "Estimated Land Area ha", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "estimated_landareaha" }, { "name": "estimated_producetone", "type": "esriFieldTypeDouble", "alias": "Estimated Produce (Tonnes)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "estimated_producetone" }, { "name": "sowing_date", "type": "esriFieldTypeDate", "alias": "Sowing Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "sowing_date" }, { "name": "remarks", "type": "esriFieldTypeString", "alias": "Remarks", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "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" } ], "indexes": [ { "name": "gdb_18690_schobj", "fields": "schobjectid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r254_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_254", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "wua.sde.scheme_season_cropplaning", "description": "", "prototype": { "attributes": { "remarks": null, "sowing_date": null, "schobjectid": null, "type_of_scheme": null, "season": null, "year": null, "cropname": null, "cropvariety": null, "area_ha": null, "estimated_landareaha": null, "estimated_producetone": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Uploads,Editing,Extract", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "attachmentid", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": false }, { "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": "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": "a6bead4c8c8b4d04b37c6720e967417a" }