{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "meter_no", "role": "esriRelRoleOrigin", "composite": false, "name": "Consumer_Data", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": true, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Consumer_Info_Table", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "sanctioned_load": null, "connected_load": null, "consumer_name": null, "father_name": null, "tariff": null, "meter_no": null, "consumer_no": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.1, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Consumer_Info_Table", "displayField": "consumer_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "consumer_no", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "consumer_no", "length": 255, "alias": "Consumer Number", "type": "esriFieldTypeString" }, { "modelName": "meter_no", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "meter_no", "length": 255, "alias": "Meter Number", "type": "esriFieldTypeString" }, { "modelName": "consumer_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "consumer_name", "length": 255, "alias": "Consumer Name", "type": "esriFieldTypeString" }, { "modelName": "father_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "father_name", "length": 255, "alias": "Father/ Husband Name", "type": "esriFieldTypeString" }, { "modelName": "tariff", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tariff", "length": 255, "alias": "Tariff", "type": "esriFieldTypeString" }, { "modelName": "sanctioned_load", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sanctioned_load", "length": 255, "alias": "Sanctioned Load", "type": "esriFieldTypeString" }, { "modelName": "connected_load", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "connected_load", "length": 255, "alias": "Connected Load", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "globalid" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": true, "indexes": [ { "name": "g7386meter_no", "isUnique": false, "description": "", "fields": "meter_no", "isAscending": true }, { "name": "r2804_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_2804", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "44f6270cbe5545bbb3d2596e5e97a652", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Editing,Sync,Extract,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 2774464.4397, "xmin": 187818.37189999968, "ymax": 2794182.0966, "xmax": 210903.81460000016, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 32646, "zTolerance": 0.001, "wkid": 32646, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "filter_value", "role": "esriRelRoleDestination", "composite": false, "name": "Consumer_Info_Table", "relatedTableId": 1, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": true, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Consumer_Data", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "phasing_code_type_id": null, "circle_id": null, "other_remarks": null, "plot_no": null, "filter_by": null, "feeder_uid": null, "connection_status_id": null, "meter_manufacture": null, "structure_id": null, "bill_group": null, "has_bpdb_lock": null, "account_no": null, "book_no": null, "location_id": null, "meter_location_name": null, "structure_map_no": null, "consumer_type_id": null, "install_date": null, "omf_kwh": null, "feederline_id": null, "dt_id": null, "longitude": null, "maximum_demand": null, "meter_type_id": null, "sanctioned_load": null, "special_type": null, "customer_address": null, "sp_id_pole_id": null, "service_cable_size": null, "has_bill_copy": null, "feeder_name": null, "consumer_nid": null, "operating_voltage_id": null, "connection_type_id": null, "special_code": null, "no_of_floor": null, "pole_details_id": null, "father_name": null, "apartment_no": null, "esu_id": null, "survey_date": null, "ending_date": null, "business_type_id": null, "meter_reading": null, "service_point_id": null, "premise_name": null, "meter_location_name_other": null, "latitude": null, "mobile_no": null, "snd_id": null, "verification_state_id": null, "others_business": null, "survey_started_at": null, "zone_id": null, "consumer_id": null, "filter_value": null, "consumer_name": null, "connected_load": null, "tariff": null, "meter_no": null, "feeder_uid_": null, "email": null, "activation_status_id": null, "distance_from_sp": null, "structure_type_id": null, "starting_date": null, "total_no_of_meter": null, "join_id": null, "service_cable_type_id": null, "union_geo_code": null, "surveyor_id": null, "tariff_category_id": null, "service_cable_joint_status": null, "meter_model": null, "transformer_number": null, "substation_id": null, "consumer_name_bng": null, "remarks": null, "tariff_sub_category_id": null, "consumer_no": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.1, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Consumer_Data", "allowTrueCurvesUpdates": false, "displayField": "feeder_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "survey_started_at", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "survey_started_at", "length": 255, "alias": "survey_started_at", "type": "esriFieldTypeString" }, { "modelName": "surveyor_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "surveyor_id", "length": 255, "alias": "Surveyor", "type": "esriFieldTypeString" }, { "modelName": "filter_by", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_filter_by", "description": "", "type": "codedValue", "codedValues": [ { "code": "Consumer", "name": "Consumer" }, { "code": "Meter", "name": "Meter" }, { "code": "Account", "name": "Account" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "filter_by", "length": 255, "alias": "By", "type": "esriFieldTypeString" }, { "modelName": "filter_value", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "filter_value", "length": 255, "alias": "Number", "type": "esriFieldTypeString" }, { "modelName": "sp_id_pole_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sp_id_pole_id", "length": 255, "alias": "SP ID/ Pole ID", "type": "esriFieldTypeString" }, { "modelName": "zone_id", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_zone_id", "description": "", "type": "codedValue", "codedValues": [ { "code": 3, "name": "Mymensingh" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "zone_id", "alias": "Zone", "type": "esriFieldTypeInteger" }, { "modelName": "circle_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "circle_id", "length": 255, "alias": "Circle", "type": "esriFieldTypeString" }, { "modelName": "snd_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "snd_id", "length": 255, "alias": "SND", "type": "esriFieldTypeString" }, { "modelName": "esu_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esu_id", "length": 255, "alias": "ESU", "type": "esriFieldTypeString" }, { "modelName": "substation_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "substation_id", "length": 255, "alias": "Substation", "type": "esriFieldTypeString" }, { "modelName": "feederline_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feederline_id", "alias": "Feeder Line", "type": "esriFieldTypeInteger" }, { "modelName": "feeder_uid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feeder_uid", "alias": "Feeder UID", "type": "esriFieldTypeInteger" }, { "modelName": "dt_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dt_id", "alias": "DT ID", "type": "esriFieldTypeInteger" }, { "modelName": "pole_details_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pole_details_id", "alias": "Pole Details ID", "type": "esriFieldTypeInteger" }, { "modelName": "feeder_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feeder_name", "length": 255, "alias": "Feeder Name", "type": "esriFieldTypeString" }, { "modelName": "feeder_uid_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feeder_uid_", "length": 255, "alias": "Feeder UID", "type": "esriFieldTypeString" }, { "modelName": "transformer_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "transformer_number", "length": 255, "alias": "Transformer Number", "type": "esriFieldTypeString" }, { "modelName": "consumer_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "consumer_id", "alias": "Consumer ID", "type": "esriFieldTypeInteger" }, { "modelName": "service_point_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "service_point_id", "alias": "Service Point ID", "type": "esriFieldTypeInteger" }, { "modelName": "consumer_no", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "consumer_no", "length": 255, "alias": "Consumer Number", "type": "esriFieldTypeString" }, { "modelName": "meter_no", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "meter_no", "length": 255, "alias": "Meter Number", "type": "esriFieldTypeString" }, { "modelName": "consumer_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "consumer_name", "length": 255, "alias": "Consumer Name", "type": "esriFieldTypeString" }, { "modelName": "consumer_name_bng", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "consumer_name_bng", "length": 255, "alias": "Consumer Name (Bangla)", "type": "esriFieldTypeString" }, { "modelName": "consumer_nid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "consumer_nid", "length": 255, "alias": "Consumer NID", "type": "esriFieldTypeString" }, { "modelName": "father_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "father_name", "length": 255, "alias": "Father/ Husband Name", "type": "esriFieldTypeString" }, { "modelName": "mobile_no", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mobile_no", "length": 255, "alias": "Mobile No.", "type": "esriFieldTypeString" }, { "modelName": "email", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "email", "length": 255, "alias": "Email", "type": "esriFieldTypeString" }, { "modelName": "tariff", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tariff", "length": 255, "alias": "Tariff", "type": "esriFieldTypeString" }, { "modelName": "phasing_code_type_id", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_phasing_code_type_id", "description": "", "type": "codedValue", "codedValues": [ { "code": "1", "name": "R" }, { "code": "2", "name": "Y" }, { "code": "3", "name": "B" }, { "code": "4", "name": "RYB" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "phasing_code_type_id", "length": 255, "alias": "Phasing Code ID", "type": "esriFieldTypeString" }, { "modelName": "consumer_type_id", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_consumer_type_id", "description": "", "type": "codedValue", "codedValues": [ { "code": "1", "name": "Govt." }, { "code": "2", "name": "Private" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "consumer_type_id", "length": 255, "alias": "Consumer Type ID", "type": "esriFieldTypeString" }, { "modelName": "operating_voltage_id", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_operating_voltage_id", "description": "", "type": "codedValue", "codedValues": [ { "code": "11 kV", "name": "11 kV" }, { "code": "400 V", "name": "400 V" }, { "code": "230 V", "name": "230 V" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "operating_voltage_id", "length": 255, "alias": "Operating Voltage ID", "type": "esriFieldTypeString" }, { "modelName": "install_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "install_date", "length": 29, "alias": "Install Date", "type": "esriFieldTypeDate" }, { "modelName": "connection_status_id", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_connection_status_id", "description": "", "type": "codedValue", "codedValues": [ { "code": "1", "name": "Regular" }, { "code": "2", "name": "Temporary Discontinued" }, { "code": "3", "name": "Permanent Discontinued" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "connection_status_id", "length": 255, "alias": "Connection Status ID", "type": "esriFieldTypeString" }, { "modelName": "connection_type_id", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_connection_type_id", "description": "", "type": "codedValue", "codedValues": [ { "code": "1", "name": "Mother Meter" }, { "code": "2", "name": "Child Meter" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "connection_type_id", "length": 255, "alias": "Connection Type ID", "type": "esriFieldTypeString" }, { "modelName": "meter_type_id", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_meter_type_id", "description": "", "type": "codedValue", "codedValues": [ { "code": "1", "name": "Prepaid (Card Based)" }, { "code": "2", "name": "Prepaid (Keypad)" }, { "code": "3", "name": "Prepaid (Smart)" }, { "code": "4", "name": "Postpaid (Digital)" }, { "code": "5", "name": "Postpaid (Analogue)" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "meter_type_id", "length": 255, "alias": "Meter Type ID", "type": "esriFieldTypeString" }, { "modelName": "meter_model", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "meter_model", "length": 255, "alias": "Meter Model", "type": "esriFieldTypeString" }, { "modelName": "meter_manufacture", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "meter_manufacture", "length": 255, "alias": "Meter Manufacture", "type": "esriFieldTypeString" }, { "modelName": "sanctioned_load", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sanctioned_load", "length": 255, "alias": "Sanctioned Load", "type": "esriFieldTypeString" }, { "modelName": "connected_load", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "connected_load", "length": 255, "alias": "Connected Load", "type": "esriFieldTypeString" }, { "modelName": "business_type_id", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_business_type_id", "description": "", "type": "codedValue", "codedValues": [ { "code": "11", "name": "Single Flat" }, { "code": "12", "name": "Multiple flat (Residential)" }, { "code": "13", "name": "Multiple flat (Mixed Residential Complex)" }, { "code": "15", "name": "Other Residential" }, { "code": "21", "name": "Irrigation, Shallow tube well Low lift pump" }, { "code": "22", "name": "Irrigation, Deep Tube well" }, { "code": "29", "name": "Agriculture (Others)" }, { "code": "31", "name": "Steel & Engineering" }, { "code": "32", "name": "Food & Allied Products" }, { "code": "33", "name": "Fuel & Power" }, { "code": "34", "name": "Jute" }, { "code": "35", "name": "Textile" }, { "code": "36", "name": "Paper & Printing" }, { "code": "37", "name": "Chemicals & Pharmaceuticals" }, { "code": "38", "name": "Hotels" }, { "code": "39", "name": "Leather & Tanneries" }, { "code": "41", "name": "Educational" }, { "code": "42", "name": "Religious" }, { "code": "43", "name": "Charitable" }, { "code": "44", "name": "Govt. Hospital" }, { "code": "45", "name": "Religious (Registered)" }, { "code": "49", "name": "Religious" }, { "code": "50", "name": "Non - Residential (Others)" }, { "code": "51", "name": "Shops" }, { "code": "52", "name": "Hotel & Restaurant" }, { "code": "53", "name": "Cinema" }, { "code": "54", "name": "Shopping Center" }, { "code": "55", "name": "Private Hospital & Clinic etc." }, { "code": "56", "name": "Office" }, { "code": "57", "name": "Othre Office" }, { "code": "59", "name": "Commercial (Others)" }, { "code": "71", "name": "Garments" }, { "code": "72", "name": "Potato Cold storage" }, { "code": "73", "name": "Cold Storage" }, { "code": "79", "name": "Small Industries(Others)" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "business_type_id", "length": 255, "alias": "Business Type ID", "type": "esriFieldTypeString" }, { "modelName": "others_business", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "others_business", "length": 255, "alias": "Other Business", "type": "esriFieldTypeString" }, { "modelName": "account_no", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "account_no", "length": 255, "alias": "Account Number", "type": "esriFieldTypeString" }, { "modelName": "special_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "special_code", "length": 255, "alias": "Special Code", "type": "esriFieldTypeString" }, { "modelName": "special_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "special_type", "length": 255, "alias": "Special Type", "type": "esriFieldTypeString" }, { "modelName": "location_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location_id", "length": 255, "alias": "Location DB", "type": "esriFieldTypeString" }, { "modelName": "bill_group", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bill_group", "length": 255, "alias": "Bill Group", "type": "esriFieldTypeString" }, { "modelName": "book_no", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "book_no", "length": 255, "alias": "Book Number", "type": "esriFieldTypeString" }, { "modelName": "omf_kwh", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "omf_kwh", "length": 255, "alias": "OMF (KWH)", "type": "esriFieldTypeString" }, { "modelName": "meter_reading", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "meter_reading", "length": 255, "alias": "Meter Reading", "type": "esriFieldTypeString" }, { "modelName": "service_cable_size", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_service_cable_size", "description": "", "type": "codedValue", "codedValues": [ { "code": "4 RM", "name": "4 RM" }, { "code": "6 RM", "name": "6 RM" }, { "code": "10 RM", "name": "10 RM" }, { "code": "16 RM", "name": "16 RM" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "service_cable_size", "length": 255, "alias": "Service Cable Size", "type": "esriFieldTypeString" }, { "modelName": "service_cable_type_id", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_service_cable_type_id", "description": "", "type": "codedValue", "codedValues": [ { "code": "PVC", "name": "PVC" }, { "code": "Concentric", "name": "Concentric" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "service_cable_type_id", "length": 255, "alias": "Service Cable Type ID", "type": "esriFieldTypeString" }, { "modelName": "customer_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "customer_address", "length": 255, "alias": "Customer Address", "type": "esriFieldTypeString" }, { "modelName": "union_geo_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "union_geo_code", "length": 255, "alias": "Union GEO Code", "type": "esriFieldTypeString" }, { "modelName": "plot_no", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "plot_no", "length": 255, "alias": "Plot No.", "type": "esriFieldTypeString" }, { "modelName": "apartment_no", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "apartment_no", "length": 255, "alias": "Apartment No.", "type": "esriFieldTypeString" }, { "modelName": "premise_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "premise_name", "length": 255, "alias": "Premise Name", "type": "esriFieldTypeString" }, { "modelName": "survey_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "survey_date", "length": 29, "alias": "Survey Date", "type": "esriFieldTypeDate" }, { "modelName": "latitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "latitude", "alias": "Latitude", "type": "esriFieldTypeDouble" }, { "modelName": "longitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "longitude", "alias": "Longitude", "type": "esriFieldTypeDouble" }, { "modelName": "structure_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "structure_id", "alias": "Structure ID", "type": "esriFieldTypeInteger" }, { "modelName": "structure_map_no", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "structure_map_no", "length": 255, "alias": "Structure Map No", "type": "esriFieldTypeString" }, { "modelName": "structure_type_id", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_structure_type_id", "description": "", "type": "codedValue", "codedValues": [ { "code": "1", "name": "Pucca" }, { "code": "2", "name": "Semi-Pucca" }, { "code": "3", "name": "Wooden" }, { "code": "4", "name": "Earthen" }, { "code": "5", "name": "Kutcha" }, { "code": "6", "name": "Jupri" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "structure_type_id", "length": 255, "alias": "Structure Type ID", "type": "esriFieldTypeString" }, { "modelName": "total_no_of_meter", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_no_of_meter", "alias": "Total Meter in House", "type": "esriFieldTypeInteger" }, { "modelName": "no_of_floor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "no_of_floor", "alias": "No of Floor", "type": "esriFieldTypeInteger" }, { "modelName": "starting_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "starting_date", "length": 255, "alias": "Starting Date", "type": "esriFieldTypeString" }, { "modelName": "ending_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ending_date", "length": 255, "alias": "Ending Date", "type": "esriFieldTypeString" }, { "modelName": "activation_status_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "activation_status_id", "alias": "Activation Status ID", "type": "esriFieldTypeInteger" }, { "modelName": "verification_state_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "verification_state_id", "alias": "Verification State ID", "type": "esriFieldTypeInteger" }, { "modelName": "remarks", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "remarks", "length": 255, "alias": "NID Remarks", "type": "esriFieldTypeString" }, { "modelName": "other_remarks", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_remarks", "length": 255, "alias": "Remarks", "type": "esriFieldTypeString" }, { "modelName": "tariff_category_id", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_tariff_category_id", "description": "", "type": "codedValue", "codedValues": [ { "code": 1, "name": "LT" }, { "code": 2, "name": "MT" }, { "code": 3, "name": "HT" }, { "code": 4, "name": "EHT" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "tariff_category_id", "alias": "Tariff Category ID", "type": "esriFieldTypeInteger" }, { "modelName": "tariff_sub_category_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tariff_sub_category_id", "alias": "Tariff Sub Category ID", "type": "esriFieldTypeInteger" }, { "modelName": "distance_from_sp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "distance_from_sp", "alias": "Distance from SP", "type": "esriFieldTypeDouble" }, { "modelName": "meter_location_name", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_meter_location_name", "description": "", "type": "codedValue", "codedValues": [ { "code": "1", "name": "Stair" }, { "code": "2", "name": "Noth West Corner of the Building" }, { "code": "3", "name": "Noth East Corner of the Building" }, { "code": "4", "name": "South West Corner of the Building" }, { "code": "5", "name": "South East Corner of the Building" }, { "code": "6", "name": "Attached with Tree" }, { "code": "7", "name": "Attached with Wall" }, { "code": "8", "name": "Attached with Pole" }, { "code": "9", "name": "Others" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "meter_location_name", "length": 255, "alias": "Meter Location Name", "type": "esriFieldTypeString" }, { "modelName": "meter_location_name_other", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "meter_location_name_other", "length": 255, "alias": "Other (meter Location)", "type": "esriFieldTypeString" }, { "modelName": "has_bill_copy", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_has_bill_copy", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "has_bill_copy", "length": 255, "alias": "Has Bill Copy?", "type": "esriFieldTypeString" }, { "modelName": "has_bpdb_lock", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_has_bpdb_lock", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "has_bpdb_lock", "length": 255, "alias": "Has BPDB Seal (Lock)?", "type": "esriFieldTypeString" }, { "modelName": "service_cable_joint_status", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "service_8ce6a79be5c94aa98bda1ca7fefb4c87_cvd_service_cable_joint_status", "description": "", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "service_cable_joint_status", "length": 255, "alias": "Does the service cable have a joint?", "type": "esriFieldTypeString" }, { "modelName": "maximum_demand", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "maximum_demand", "alias": "Maximum Demand (md)", "type": "esriFieldTypeInteger" }, { "modelName": "join_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "join_id", "alias": "Join_ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": true, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "g7385filter_valu", "isUnique": false, "description": "", "fields": "filter_value", "isAscending": true }, { "name": "r2803_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_2803", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a2230_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": true, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "44f6270cbe5545bbb3d2596e5e97a652", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Editing,Sync,Extract,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0 }, "color": [ 230, 0, 0, 255 ], "size": 10, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true } ] }