View In:   ArcGIS Online Map Viewer

Name: Consumer_Data

Display Field: feeder_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 44f6270cbe5545bbb3d2596e5e97a652

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 187818.37189999968
YMin: 2774464.4397
XMax: 210903.81460000016
YMax: 2794182.0966
Spatial Reference: 32646  (32646)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [230, 0, 0, 255]
Size: 10.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• survey_started_at ( modelName: survey_started_at, nullable: true, editable: true, defaultValue: null, length: 255, alias: survey_started_at, type: esriFieldTypeString )
• surveyor_id ( modelName: surveyor_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Surveyor, type: esriFieldTypeString )
• filter_by ( modelName: filter_by, nullable: true, editable: true, defaultValue: null, length: 255, alias: By, type: esriFieldTypeString , Coded Values: [Consumer: Consumer] , [Meter: Meter] , [Account: Account] )
• filter_value ( modelName: filter_value, nullable: true, editable: true, defaultValue: null, length: 255, alias: Number, type: esriFieldTypeString )
• sp_id_pole_id ( modelName: sp_id_pole_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: SP ID/ Pole ID, type: esriFieldTypeString )
• zone_id ( modelName: zone_id, nullable: true, editable: true, defaultValue: null, alias: Zone, type: esriFieldTypeInteger , Coded Values: [3: Mymensingh] )
• circle_id ( modelName: circle_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Circle, type: esriFieldTypeString )
• snd_id ( modelName: snd_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: SND, type: esriFieldTypeString )
• esu_id ( modelName: esu_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: ESU, type: esriFieldTypeString )
• substation_id ( modelName: substation_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Substation, type: esriFieldTypeString )
• feederline_id ( modelName: feederline_id, nullable: true, editable: true, defaultValue: null, alias: Feeder Line, type: esriFieldTypeInteger )
• feeder_uid ( modelName: feeder_uid, nullable: true, editable: true, defaultValue: null, alias: Feeder UID, type: esriFieldTypeInteger )
• dt_id ( modelName: dt_id, nullable: true, editable: true, defaultValue: null, alias: DT ID, type: esriFieldTypeInteger )
• pole_details_id ( modelName: pole_details_id, nullable: true, editable: true, defaultValue: null, alias: Pole Details ID, type: esriFieldTypeInteger )
• feeder_name ( modelName: feeder_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Feeder Name, type: esriFieldTypeString )
• feeder_uid_ ( modelName: feeder_uid_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Feeder UID, type: esriFieldTypeString )
• transformer_number ( modelName: transformer_number, nullable: true, editable: true, defaultValue: null, length: 255, alias: Transformer Number, type: esriFieldTypeString )
• consumer_id ( modelName: consumer_id, nullable: true, editable: true, defaultValue: null, alias: Consumer ID, type: esriFieldTypeInteger )
• service_point_id ( modelName: service_point_id, nullable: true, editable: true, defaultValue: null, alias: Service Point ID, type: esriFieldTypeInteger )
• consumer_no ( modelName: consumer_no, nullable: true, editable: true, defaultValue: null, length: 255, alias: Consumer Number, type: esriFieldTypeString )
• meter_no ( modelName: meter_no, nullable: true, editable: true, defaultValue: null, length: 255, alias: Meter Number, type: esriFieldTypeString )
• consumer_name ( modelName: consumer_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Consumer Name, type: esriFieldTypeString )
• consumer_name_bng ( modelName: consumer_name_bng, nullable: true, editable: true, defaultValue: null, length: 255, alias: Consumer Name (Bangla), type: esriFieldTypeString )
• consumer_nid ( modelName: consumer_nid, nullable: true, editable: true, defaultValue: null, length: 255, alias: Consumer NID, type: esriFieldTypeString )
• father_name ( modelName: father_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Father/ Husband Name, type: esriFieldTypeString )
• mobile_no ( modelName: mobile_no, nullable: true, editable: true, defaultValue: null, length: 255, alias: Mobile No., type: esriFieldTypeString )
• email ( modelName: email, nullable: true, editable: true, defaultValue: null, length: 255, alias: Email, type: esriFieldTypeString )
• tariff ( modelName: tariff, nullable: true, editable: true, defaultValue: null, length: 255, alias: Tariff, type: esriFieldTypeString )
• phasing_code_type_id ( modelName: phasing_code_type_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Phasing Code ID, type: esriFieldTypeString , Coded Values: [1: R] , [2: Y] , [3: B] , ...1 more... )
• consumer_type_id ( modelName: consumer_type_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Consumer Type ID, type: esriFieldTypeString , Coded Values: [1: Govt.] , [2: Private] )
• operating_voltage_id ( modelName: operating_voltage_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Operating Voltage ID, type: esriFieldTypeString , Coded Values: [11 kV: 11 kV] , [400 V: 400 V] , [230 V: 230 V] )
• install_date ( modelName: install_date, nullable: true, editable: true, defaultValue: null, length: 29, alias: Install Date, type: esriFieldTypeDate )
• connection_status_id ( modelName: connection_status_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Connection Status ID, type: esriFieldTypeString , Coded Values: [1: Regular] , [2: Temporary Discontinued] , [3: Permanent Discontinued] )
• connection_type_id ( modelName: connection_type_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Connection Type ID, type: esriFieldTypeString , Coded Values: [1: Mother Meter] , [2: Child Meter] )
• meter_type_id ( modelName: meter_type_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Meter Type ID, type: esriFieldTypeString , Coded Values: [1: Prepaid (Card Based)] , [2: Prepaid (Keypad)] , [3: Prepaid (Smart)] , ...2 more... )
• meter_model ( modelName: meter_model, nullable: true, editable: true, defaultValue: null, length: 255, alias: Meter Model, type: esriFieldTypeString )
• meter_manufacture ( modelName: meter_manufacture, nullable: true, editable: true, defaultValue: null, length: 255, alias: Meter Manufacture, type: esriFieldTypeString )
• sanctioned_load ( modelName: sanctioned_load, nullable: true, editable: true, defaultValue: null, length: 255, alias: Sanctioned Load, type: esriFieldTypeString )
• connected_load ( modelName: connected_load, nullable: true, editable: true, defaultValue: null, length: 255, alias: Connected Load, type: esriFieldTypeString )
• business_type_id ( modelName: business_type_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Business Type ID, type: esriFieldTypeString , Coded Values: [11: Single Flat] , [12: Multiple flat (Residential)] , [13: Multiple flat (Mixed Residential Complex)] , ...32 more... )
• others_business ( modelName: others_business, nullable: true, editable: true, defaultValue: null, length: 255, alias: Other Business, type: esriFieldTypeString )
• account_no ( modelName: account_no, nullable: true, editable: true, defaultValue: null, length: 255, alias: Account Number, type: esriFieldTypeString )
• special_code ( modelName: special_code, nullable: true, editable: true, defaultValue: null, length: 255, alias: Special Code, type: esriFieldTypeString )
• special_type ( modelName: special_type, nullable: true, editable: true, defaultValue: null, length: 255, alias: Special Type, type: esriFieldTypeString )
• location_id ( modelName: location_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Location DB, type: esriFieldTypeString )
• bill_group ( modelName: bill_group, nullable: true, editable: true, defaultValue: null, length: 255, alias: Bill Group, type: esriFieldTypeString )
• book_no ( modelName: book_no, nullable: true, editable: true, defaultValue: null, length: 255, alias: Book Number, type: esriFieldTypeString )
• omf_kwh ( modelName: omf_kwh, nullable: true, editable: true, defaultValue: null, length: 255, alias: OMF (KWH), type: esriFieldTypeString )
• meter_reading ( modelName: meter_reading, nullable: true, editable: true, defaultValue: null, length: 255, alias: Meter Reading, type: esriFieldTypeString )
• service_cable_size ( modelName: service_cable_size, nullable: true, editable: true, defaultValue: null, length: 255, alias: Service Cable Size, type: esriFieldTypeString , Coded Values: [4 RM: 4 RM] , [6 RM: 6 RM] , [10 RM: 10 RM] , ...1 more... )
• service_cable_type_id ( modelName: service_cable_type_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Service Cable Type ID, type: esriFieldTypeString , Coded Values: [PVC: PVC] , [Concentric: Concentric] )
• customer_address ( modelName: customer_address, nullable: true, editable: true, defaultValue: null, length: 255, alias: Customer Address, type: esriFieldTypeString )
• union_geo_code ( modelName: union_geo_code, nullable: true, editable: true, defaultValue: null, length: 255, alias: Union GEO Code, type: esriFieldTypeString )
• plot_no ( modelName: plot_no, nullable: true, editable: true, defaultValue: null, length: 255, alias: Plot No., type: esriFieldTypeString )
• apartment_no ( modelName: apartment_no, nullable: true, editable: true, defaultValue: null, length: 255, alias: Apartment No., type: esriFieldTypeString )
• premise_name ( modelName: premise_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Premise Name, type: esriFieldTypeString )
• survey_date ( modelName: survey_date, nullable: true, editable: true, defaultValue: null, length: 29, alias: Survey Date, type: esriFieldTypeDate )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• structure_id ( modelName: structure_id, nullable: true, editable: true, defaultValue: null, alias: Structure ID, type: esriFieldTypeInteger )
• structure_map_no ( modelName: structure_map_no, nullable: true, editable: true, defaultValue: null, length: 255, alias: Structure Map No, type: esriFieldTypeString )
• structure_type_id ( modelName: structure_type_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Structure Type ID, type: esriFieldTypeString , Coded Values: [1: Pucca] , [2: Semi-Pucca] , [3: Wooden] , ...3 more... )
• total_no_of_meter ( modelName: total_no_of_meter, nullable: true, editable: true, defaultValue: null, alias: Total Meter in House, type: esriFieldTypeInteger )
• no_of_floor ( modelName: no_of_floor, nullable: true, editable: true, defaultValue: null, alias: No of Floor, type: esriFieldTypeInteger )
• starting_date ( modelName: starting_date, nullable: true, editable: true, defaultValue: null, length: 255, alias: Starting Date, type: esriFieldTypeString )
• ending_date ( modelName: ending_date, nullable: true, editable: true, defaultValue: null, length: 255, alias: Ending Date, type: esriFieldTypeString )
• activation_status_id ( modelName: activation_status_id, nullable: true, editable: true, defaultValue: null, alias: Activation Status ID, type: esriFieldTypeInteger )
• verification_state_id ( modelName: verification_state_id, nullable: true, editable: true, defaultValue: null, alias: Verification State ID, type: esriFieldTypeInteger )
• remarks ( modelName: remarks, nullable: true, editable: true, defaultValue: null, length: 255, alias: NID Remarks, type: esriFieldTypeString )
• other_remarks ( modelName: other_remarks, nullable: true, editable: true, defaultValue: null, length: 255, alias: Remarks, type: esriFieldTypeString )
• tariff_category_id ( modelName: tariff_category_id, nullable: true, editable: true, defaultValue: null, alias: Tariff Category ID, type: esriFieldTypeInteger , Coded Values: [1: LT] , [2: MT] , [3: HT] , ...1 more... )
• tariff_sub_category_id ( modelName: tariff_sub_category_id, nullable: true, editable: true, defaultValue: null, alias: Tariff Sub Category ID, type: esriFieldTypeInteger )
• distance_from_sp ( modelName: distance_from_sp, nullable: true, editable: true, defaultValue: null, alias: Distance from SP, type: esriFieldTypeDouble )
• meter_location_name ( modelName: meter_location_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Meter Location Name, type: esriFieldTypeString , Coded Values: [1: Stair] , [2: Noth West Corner of the Building] , [3: Noth East Corner of the Building] , ...6 more... )
• meter_location_name_other ( modelName: meter_location_name_other, nullable: true, editable: true, defaultValue: null, length: 255, alias: Other (meter Location), type: esriFieldTypeString )
• has_bill_copy ( modelName: has_bill_copy, nullable: true, editable: true, defaultValue: null, length: 255, alias: Has Bill Copy?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• has_bpdb_lock ( modelName: has_bpdb_lock, nullable: true, editable: true, defaultValue: null, length: 255, alias: Has BPDB Seal (Lock)?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• service_cable_joint_status ( modelName: service_cable_joint_status, nullable: true, editable: true, defaultValue: null, length: 255, alias: Does the service cable have a joint?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• maximum_demand ( modelName: maximum_demand, nullable: true, editable: true, defaultValue: null, alias: Maximum Demand (md), type: esriFieldTypeInteger )
• join_id ( modelName: join_id, nullable: true, editable: true, defaultValue: null, alias: Join_ID, type: esriFieldTypeInteger )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Templates:

• Name: Consumer_Data
  Description:
  Prototype:
  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
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• Consumer_Info_Table (0) -- Related To: Consumer_Info_Table (1)

Capabilities: Query,Create,Update,Delete,Editing,Sync,Extract,Uploads

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata