View In:   ArcGIS Online Map Viewer

Parent Layer: PDB Line

Name: Consumer

Display Field: consumer_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: dbo.v_geo_db_consumers

Service Item Id: 2a942edce08a442d98576eb2a68c2707

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 3000.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: 9991480.957400002
YMin: 2428018.9992999993
XMax: 1.0267381173500001E7
YMax: 2887921.745000001
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• object_id ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: object_id, alias: object_id )
• zone_id ( modelName: zone_id, nullable: true, editable: true, defaultValue: null, alias: zone_id, type: esriFieldTypeInteger )
• circle_id ( modelName: circle_id, nullable: true, editable: true, defaultValue: null, alias: circle_id, type: esriFieldTypeInteger )
• snd_id ( modelName: snd_id, nullable: true, editable: true, defaultValue: null, alias: snd_id, type: esriFieldTypeInteger )
• esu_id ( modelName: esu_id, nullable: true, editable: true, defaultValue: null, alias: esu_id, type: esriFieldTypeInteger )
• substation_id ( modelName: substation_id, nullable: true, editable: true, defaultValue: null, alias: substation_id, type: esriFieldTypeInteger )
• ht_feederline_id ( modelName: ht_feederline_id, nullable: true, editable: true, defaultValue: null, alias: ht_feederline_id, type: esriFieldTypeInteger )
• dt_id ( modelName: dt_id, nullable: true, editable: true, defaultValue: null, alias: dt_id, type: esriFieldTypeInteger )
• lt_feederline_uid ( modelName: lt_feederline_uid, nullable: true, editable: true, defaultValue: null, alias: lt_feederline_uid, type: esriFieldTypeInteger )
• lt_feederline_id ( modelName: lt_feederline_id, nullable: true, editable: true, defaultValue: null, alias: lt_feederline_id, type: esriFieldTypeInteger )
• service_point_id ( modelName: service_point_id, nullable: true, editable: true, defaultValue: null, alias: service_point_id, type: esriFieldTypeInteger )
• service_point_code ( modelName: service_point_code, nullable: true, editable: true, defaultValue: null, length: 50, alias: service_point_code, type: esriFieldTypeString )
• consumer_id ( modelName: consumer_id, nullable: true, editable: true, defaultValue: null, alias: consumer_id, type: esriFieldTypeInteger )
• consumer_no ( modelName: consumer_no, nullable: true, editable: true, defaultValue: null, length: 50, alias: consumer_no, type: esriFieldTypeString )
• distance_from_sp ( modelName: distance_from_sp, nullable: true, editable: true, defaultValue: null, alias: distance_from_sp, type: esriFieldTypeDouble )
• meter_no ( modelName: meter_no, nullable: true, editable: true, defaultValue: null, length: 250, alias: meter_no, type: esriFieldTypeString )
• consumer_name ( modelName: consumer_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: consumer_name, type: esriFieldTypeString )
• consumer_name_bng ( modelName: consumer_name_bng, nullable: true, editable: true, defaultValue: null, length: 250, alias: consumer_name_bng, type: esriFieldTypeString )
• consumer_nid ( modelName: consumer_nid, nullable: true, editable: true, defaultValue: null, length: 250, alias: consumer_nid, type: esriFieldTypeString )
• father_name ( modelName: father_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: father_name, type: esriFieldTypeString )
• mobile_no ( modelName: mobile_no, nullable: true, editable: true, defaultValue: null, length: 250, alias: mobile_no, type: esriFieldTypeString )
• tariff ( modelName: tariff, nullable: true, editable: true, defaultValue: null, length: 250, alias: tariff, type: esriFieldTypeString )
• tariff_category_id ( modelName: tariff_category_id, nullable: true, editable: true, defaultValue: null, alias: tariff_category_id, type: esriFieldTypeInteger )
• tariff_sub_category_id ( modelName: tariff_sub_category_id, nullable: true, editable: true, defaultValue: null, alias: tariff_sub_category_id, type: esriFieldTypeInteger )
• tarrif_category_name ( modelName: tarrif_category_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: tarrif_category_name, type: esriFieldTypeString )
• tarrif_sub_category_name ( modelName: tarrif_sub_category_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: tarrif_sub_category_name, type: esriFieldTypeString )
• phasing_code_type_id ( modelName: phasing_code_type_id, nullable: true, editable: true, defaultValue: null, alias: phasing_code_type_id, type: esriFieldTypeInteger )
• phasing_code_type_name ( modelName: phasing_code_type_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: phasing_code_type_name, type: esriFieldTypeString )
• consumer_type_id ( modelName: consumer_type_id, nullable: true, editable: true, defaultValue: null, alias: consumer_type_id, type: esriFieldTypeInteger )
• consumer_type_name ( modelName: consumer_type_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: consumer_type_name, type: esriFieldTypeString )
• operating_voltage_id ( modelName: operating_voltage_id, nullable: true, editable: true, defaultValue: null, alias: operating_voltage_id, type: esriFieldTypeInteger )
• operating_voltage_name ( modelName: operating_voltage_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: operating_voltage_name, type: esriFieldTypeString )
• 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, alias: connection_status_id, type: esriFieldTypeInteger )
• connection_status_name ( modelName: connection_status_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: connection_status_name, type: esriFieldTypeString )
• connection_type_id ( modelName: connection_type_id, nullable: true, editable: true, defaultValue: null, alias: connection_type_id, type: esriFieldTypeInteger )
• connection_type_name ( modelName: connection_type_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: connection_type_name, type: esriFieldTypeString )
• meter_type_id ( modelName: meter_type_id, nullable: true, editable: true, defaultValue: null, alias: meter_type_id, type: esriFieldTypeInteger )
• meter_type_name ( modelName: meter_type_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: meter_type_name, type: esriFieldTypeString )
• meter_model ( modelName: meter_model, nullable: true, editable: true, defaultValue: null, length: 250, alias: meter_model, type: esriFieldTypeString )
• meter_manufacture ( modelName: meter_manufacture, nullable: true, editable: true, defaultValue: null, length: 250, alias: meter_manufacture, type: esriFieldTypeString )
• sanctioned_load ( modelName: sanctioned_load, nullable: true, editable: true, defaultValue: null, alias: sanctioned_load, type: esriFieldTypeDouble )
• connected_load ( modelName: connected_load, nullable: true, editable: true, defaultValue: null, alias: connected_load, type: esriFieldTypeDouble )
• business_type_id ( modelName: business_type_id, nullable: true, editable: true, defaultValue: null, alias: business_type_id, type: esriFieldTypeInteger )
• business_type_name ( modelName: business_type_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: business_type_name, type: esriFieldTypeString )
• others_business ( modelName: others_business, nullable: true, editable: true, defaultValue: null, length: 250, alias: others_business, type: esriFieldTypeString )
• account_no ( modelName: account_no, nullable: true, editable: true, defaultValue: null, length: 250, alias: account_no, type: esriFieldTypeString )
• special_code ( modelName: special_code, nullable: true, editable: true, defaultValue: null, length: 250, alias: special_code, type: esriFieldTypeString )
• special_type ( modelName: special_type, nullable: true, editable: true, defaultValue: null, length: 250, alias: special_type, type: esriFieldTypeString )
• location_id ( modelName: location_id, nullable: true, editable: true, defaultValue: null, alias: location_id, type: esriFieldTypeInteger )
• location_name ( modelName: location_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: location_name, type: esriFieldTypeString )
• bill_group ( modelName: bill_group, nullable: true, editable: true, defaultValue: null, length: 250, alias: bill_group, type: esriFieldTypeString )
• book_no ( modelName: book_no, nullable: true, editable: true, defaultValue: null, length: 250, alias: book_no, type: esriFieldTypeString )
• omf_kwh ( modelName: omf_kwh, nullable: true, editable: true, defaultValue: null, alias: omf_kwh, type: esriFieldTypeDouble )
• meter_reading ( modelName: meter_reading, nullable: true, editable: true, defaultValue: null, alias: meter_reading, type: esriFieldTypeDouble )
• service_cable_size ( modelName: service_cable_size, nullable: true, editable: true, defaultValue: null, alias: service_cable_size, type: esriFieldTypeInteger )
• service_cable_type_id ( modelName: service_cable_type_id, nullable: true, editable: true, defaultValue: null, alias: service_cable_type_id, type: esriFieldTypeInteger )
• service_cable_type_name ( modelName: service_cable_type_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: service_cable_type_name, type: esriFieldTypeString )
• customer_address ( modelName: customer_address, nullable: true, editable: true, defaultValue: null, length: 250, alias: customer_address, type: esriFieldTypeString )
• district_geo_code ( modelName: district_geo_code, nullable: true, editable: true, defaultValue: null, length: 4, alias: district_geo_code, type: esriFieldTypeString )
• upazila_geo_code ( modelName: upazila_geo_code, nullable: true, editable: true, defaultValue: null, length: 6, alias: upazila_geo_code, type: esriFieldTypeString )
• union_geo_code ( modelName: union_geo_code, nullable: true, editable: true, defaultValue: null, length: 8, alias: union_geo_code, type: esriFieldTypeString )
• district_name ( modelName: district_name, nullable: true, editable: true, defaultValue: null, length: 50, alias: district_name, type: esriFieldTypeString )
• upazila_name ( modelName: upazila_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: upazila_name, type: esriFieldTypeString )
• union_name ( modelName: union_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: union_name, type: esriFieldTypeString )
• plot_no ( modelName: plot_no, nullable: true, editable: true, defaultValue: null, length: 250, alias: plot_no, type: esriFieldTypeString )
• apartment_no ( modelName: apartment_no, nullable: true, editable: true, defaultValue: null, length: 250, alias: apartment_no, type: esriFieldTypeString )
• premise_name ( modelName: premise_name, nullable: true, editable: true, defaultValue: null, length: 250, 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, length: 250, alias: structure_id, type: esriFieldTypeString )
• structure_map_no ( modelName: structure_map_no, nullable: true, editable: true, defaultValue: null, length: 250, alias: structure_map_no, type: esriFieldTypeString )
• structure_type_id ( modelName: structure_type_id, nullable: true, editable: true, defaultValue: null, alias: structure_type_id, type: esriFieldTypeInteger )
• structure_type_name ( modelName: structure_type_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: structure_type_name, type: esriFieldTypeString )
• no_of_floor ( modelName: no_of_floor, nullable: true, editable: true, defaultValue: null, alias: no_of_floor, type: esriFieldTypeInteger )
• activation_status_id ( modelName: activation_status_id, nullable: true, editable: true, defaultValue: null, alias: activation_status_id, type: esriFieldTypeInteger )
• activation_status_name ( modelName: activation_status_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: activation_status_name, type: esriFieldTypeString )
• verification_state_id ( modelName: verification_state_id, nullable: true, editable: true, defaultValue: null, alias: verification_state_id, type: esriFieldTypeInteger )
• verification_state_name ( modelName: verification_state_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: verification_state_name, type: esriFieldTypeString )
• remarks ( modelName: remarks, nullable: true, editable: true, defaultValue: null, length: 250, alias: remarks, type: esriFieldTypeString )
• pole_details_id ( modelName: pole_details_id, nullable: true, editable: true, defaultValue: null, alias: pole_details_id, type: esriFieldTypeInteger )

Templates:

• Name: Consumer
  Description:
  Prototype:
  phasing_code_type_id: null
  upazila_name: null
  verification_state_name: null
  circle_id: null
  plot_no: null
  connection_status_id: null
  meter_manufacture: null
  connection_type_name: null
  business_type_name: null
  structure_id: null
  bill_group: null
  account_no: null
  book_no: null
  location_id: null
  operating_voltage_name: null
  structure_map_no: null
  consumer_type_id: null
  lt_feederline_uid: null
  install_date: null
  omf_kwh: null
  structure_type_name: null
  dt_id: null
  phasing_code_type_name: null
  longitude: null
  meter_type_id: null
  sanctioned_load: null
  special_type: null
  customer_address: null
  service_cable_size: null
  consumer_nid: null
  service_point_code: null
  ht_feederline_id: null
  operating_voltage_id: null
  connection_type_id: null
  special_code: null
  no_of_floor: null
  union_name: null
  location_name: null
  pole_details_id: null
  father_name: null
  connection_status_name: null
  apartment_no: null
  esu_id: null
  survey_date: null
  tarrif_sub_category_name: null
  business_type_id: null
  meter_reading: null
  service_point_id: null
  premise_name: null
  upazila_geo_code: null
  latitude: null
  mobile_no: null
  tarrif_category_name: null
  snd_id: null
  verification_state_id: null
  others_business: null
  zone_id: null
  consumer_id: null
  district_name: null
  consumer_name: null
  connected_load: null
  meter_type_name: null
  tariff: null
  meter_no: null
  distance_from_sp: null
  activation_status_id: null
  structure_type_id: null
  lt_feederline_id: null
  service_cable_type_id: null
  union_geo_code: null
  consumer_type_name: null
  activation_status_name: null
  tariff_category_id: null
  meter_model: null
  service_cable_type_name: null
  substation_id: null
  consumer_name_bng: null
  remarks: null
  tariff_sub_category_id: null
  consumer_no: null
  district_geo_code: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata