View In:   ArcGIS Online Map Viewer

Parent Layer: PDB Line

Name: Service Point

Display Field: zone_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: dbo.v_geo_db_service_points

Service Item Id: 2a942edce08a442d98576eb2a68c2707

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000.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: 9991859.944600001
YMin: 2428049.713799998
XMax: 1.0290640175500002E7
YMax: 2898971.269200001
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 127, 127, 255]
Size: 7.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: 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 )
• feederline_id ( modelName: feederline_id, nullable: true, editable: true, defaultValue: null, alias: feederline_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_id ( modelName: lt_feederline_id, nullable: true, editable: true, defaultValue: null, alias: lt_feederline_id, type: esriFieldTypeInteger )
• pole_details_id ( modelName: pole_details_id, nullable: true, editable: true, defaultValue: null, alias: pole_details_id, type: esriFieldTypeInteger )
• pole_code ( modelName: pole_code, nullable: true, editable: true, defaultValue: null, length: 50, alias: pole_code, type: esriFieldTypeString )
• pole_uid ( modelName: pole_uid, nullable: true, editable: true, defaultValue: null, length: 50, alias: pole_uid, type: esriFieldTypeString )
• zone_name ( modelName: zone_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: zone_name, type: esriFieldTypeString )
• circle_name ( modelName: circle_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: circle_name, type: esriFieldTypeString )
• snd_name ( modelName: snd_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: snd_name, type: esriFieldTypeString )
• esu_name ( modelName: esu_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: esu_name, type: esriFieldTypeString )
• substation_name ( modelName: substation_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: substation_name, type: esriFieldTypeString )
• feeder_name ( modelName: feeder_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: feeder_name, type: esriFieldTypeString )
• feeder_wise_serial_no ( modelName: feeder_wise_serial_no, nullable: true, editable: true, defaultValue: null, alias: feeder_wise_serial_no, type: esriFieldTypeInteger )
• pole_no ( modelName: pole_no, nullable: true, editable: true, defaultValue: null, length: 250, alias: pole_no, type: esriFieldTypeString )
• pole_number ( modelName: pole_number, nullable: true, editable: true, defaultValue: null, length: 50, alias: pole_number, type: esriFieldTypeString )
• prev_pole_no ( modelName: prev_pole_no, nullable: true, editable: true, defaultValue: null, length: 250, alias: prev_pole_no, type: esriFieldTypeString )
• 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 )
• pole_type_id ( modelName: pole_type_id, nullable: true, editable: true, defaultValue: null, alias: pole_type_id, type: esriFieldTypeInteger )
• line_type_id ( modelName: line_type_id, nullable: true, editable: true, defaultValue: null, alias: line_type_id, type: esriFieldTypeInteger )
• back_span ( modelName: back_span, nullable: true, editable: true, defaultValue: null, alias: back_span, type: esriFieldTypeDouble )
• type_of_wire_id ( modelName: type_of_wire_id, nullable: true, editable: true, defaultValue: null, alias: type_of_wire_id, type: esriFieldTypeInteger )
• no_of_wire_ht ( modelName: no_of_wire_ht, nullable: true, editable: true, defaultValue: null, alias: no_of_wire_ht, type: esriFieldTypeInteger )
• no_of_wire_lt ( modelName: no_of_wire_lt, nullable: true, editable: true, defaultValue: null, alias: no_of_wire_lt, type: esriFieldTypeInteger )
• wire_length ( modelName: wire_length, nullable: true, editable: true, defaultValue: null, alias: wire_length, type: esriFieldTypeDouble )
• wire_condition_id ( modelName: wire_condition_id, nullable: true, editable: true, defaultValue: null, alias: wire_condition_id, type: esriFieldTypeInteger )
• msj_no ( modelName: msj_no, nullable: true, editable: true, defaultValue: null, length: 250, alias: msj_no, type: esriFieldTypeString )
• sleeve_no ( modelName: sleeve_no, nullable: true, editable: true, defaultValue: null, length: 250, alias: sleeve_no, type: esriFieldTypeString )
• twist_no ( modelName: twist_no, nullable: true, editable: true, defaultValue: null, length: 250, alias: twist_no, type: esriFieldTypeString )
• neutral ( modelName: neutral, nullable: true, editable: true, defaultValue: null, alias: neutral, type: esriFieldTypeSmallInteger )
• street_light ( modelName: street_light, nullable: true, editable: true, defaultValue: null, alias: street_light, type: esriFieldTypeSmallInteger )
• has_street_light ( modelName: has_street_light, nullable: true, editable: true, defaultValue: null, length: 3, alias: has_street_light, type: esriFieldTypeString )
• is_transformer_exist ( modelName: is_transformer_exist, nullable: true, editable: true, defaultValue: null, alias: is_transformer_exist, type: esriFieldTypeSmallInteger )
• has_dt ( modelName: has_dt, nullable: true, editable: true, defaultValue: null, length: 3, alias: has_dt, type: esriFieldTypeString )
• common_pole ( modelName: common_pole, nullable: true, editable: true, defaultValue: null, alias: common_pole, type: esriFieldTypeSmallInteger )
• is_common_pole ( modelName: is_common_pole, nullable: true, editable: true, defaultValue: null, length: 3, alias: is_common_pole, type: esriFieldTypeString )
• tap ( modelName: tap, nullable: true, editable: true, defaultValue: null, alias: tap, type: esriFieldTypeSmallInteger )
• has_tapping ( modelName: has_tapping, nullable: true, editable: true, defaultValue: null, length: 3, alias: has_tapping, type: esriFieldTypeString )
• pole_condition_id ( modelName: pole_condition_id, nullable: true, editable: true, defaultValue: null, alias: pole_condition_id, type: esriFieldTypeInteger )
• phase_a_id ( modelName: phase_a_id, nullable: true, editable: true, defaultValue: null, length: 6, alias: phase_a_id, type: esriFieldTypeString )
• phase_b_id ( modelName: phase_b_id, nullable: true, editable: true, defaultValue: null, length: 6, alias: phase_b_id, type: esriFieldTypeString )
• phase_c_id ( modelName: phase_c_id, nullable: true, editable: true, defaultValue: null, length: 6, alias: phase_c_id, type: esriFieldTypeString )
• wire_condition_name ( modelName: wire_condition_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: wire_condition_name, type: esriFieldTypeString )
• pole_type_name ( modelName: pole_type_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: pole_type_name, type: esriFieldTypeString )
• condition_name ( modelName: condition_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: condition_name, type: esriFieldTypeString )
• line_type_name ( modelName: line_type_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: line_type_name, type: esriFieldTypeString )
• type_of_wire_name ( modelName: type_of_wire_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: type_of_wire_name, type: esriFieldTypeString )
• sp_latitude ( modelName: sp_latitude, nullable: true, editable: true, defaultValue: null, alias: sp_latitude, type: esriFieldTypeDouble )
• sp_longitude ( modelName: sp_longitude, nullable: true, editable: true, defaultValue: null, alias: sp_longitude, type: esriFieldTypeDouble )
• is_service_point ( modelName: is_service_point, nullable: true, editable: true, defaultValue: null, alias: is_service_point, type: esriFieldTypeSmallInteger )
• has_service_point ( modelName: has_service_point, nullable: true, editable: true, defaultValue: null, length: 3, alias: has_service_point, type: esriFieldTypeString )
• service_point_type_id ( modelName: service_point_type_id, nullable: true, editable: true, defaultValue: null, alias: service_point_type_id, type: esriFieldTypeInteger )
• voltage_category_id ( modelName: voltage_category_id, nullable: true, editable: true, defaultValue: null, alias: voltage_category_id, type: esriFieldTypeInteger )
• transformer_no ( modelName: transformer_no, nullable: true, editable: true, defaultValue: null, length: 250, alias: transformer_no, type: esriFieldTypeString )
• aggregate_load_kw ( modelName: aggregate_load_kw, nullable: true, editable: true, defaultValue: null, alias: aggregate_load_kw, type: esriFieldTypeDouble )
• no_of_consumers_r ( modelName: no_of_consumers_r, nullable: true, editable: true, defaultValue: null, alias: no_of_consumers_r, type: esriFieldTypeInteger )
• no_of_consumers_y ( modelName: no_of_consumers_y, nullable: true, editable: true, defaultValue: null, alias: no_of_consumers_y, type: esriFieldTypeInteger )
• no_of_consumers_b ( modelName: no_of_consumers_b, nullable: true, editable: true, defaultValue: null, alias: no_of_consumers_b, type: esriFieldTypeInteger )
• no_of_consumers_ryb ( modelName: no_of_consumers_ryb, nullable: true, editable: true, defaultValue: null, alias: no_of_consumers_ryb, type: esriFieldTypeInteger )
• road_name ( modelName: road_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: road_name, type: esriFieldTypeString )
• village_area_name ( modelName: village_area_name, nullable: true, editable: true, defaultValue: null, length: 250, alias: village_area_name, type: esriFieldTypeString )
• ward ( modelName: ward, nullable: true, editable: true, defaultValue: null, length: 250, alias: ward, type: esriFieldTypeString )
• primary_landmark ( modelName: primary_landmark, nullable: true, editable: true, defaultValue: null, length: 250, alias: primary_landmark, type: esriFieldTypeString )
• lt_pole_code ( modelName: lt_pole_code, nullable: true, editable: true, defaultValue: null, length: 30, alias: lt_pole_code, type: esriFieldTypeString )
• prev_lt_pole_code ( modelName: prev_lt_pole_code, nullable: true, editable: true, defaultValue: null, length: 30, alias: prev_lt_pole_code, type: esriFieldTypeString )
• distance_from_dt ( modelName: distance_from_dt, nullable: true, editable: true, defaultValue: null, alias: distance_from_dt, type: esriFieldTypeDouble )
• city_town ( modelName: city_town, nullable: true, editable: true, defaultValue: null, length: 250, alias: city_town, type: esriFieldTypeString )
• sp_lt_id ( modelName: sp_lt_id, nullable: true, editable: true, defaultValue: null, alias: sp_lt_id, type: esriFieldTypeInteger )
• service_point_code ( modelName: service_point_code, nullable: true, editable: true, defaultValue: null, length: 50, alias: service_point_code, type: esriFieldTypeString )

Templates:

• Name: Service Point
  Description:
  Prototype:
  sp_longitude: null
  circle_id: null
  snd_name: null
  no_of_consumers_y: null
  service_point_type_id: null
  no_of_consumers_r: null
  type_of_wire_id: null
  phase_a_id: null
  pole_uid: null
  esu_name: null
  circle_name: null
  twist_no: null
  condition_name: null
  feederline_id: null
  dt_id: null
  pole_type_name: null
  has_service_point: null
  longitude: null
  sleeve_no: null
  road_name: null
  tap: null
  feeder_name: null
  service_point_code: null
  neutral: null
  voltage_category_id: null
  ht_feederline_id: null
  pole_type_id: null
  is_transformer_exist: null
  has_tapping: null
  pole_details_id: null
  phase_b_id: null
  back_span: null
  aggregate_load_kw: null
  esu_id: null
  transformer_no: null
  no_of_consumers_ryb: null
  latitude: null
  common_pole: null
  wire_condition_id: null
  zone_name: null
  snd_id: null
  ward: null
  zone_id: null
  street_light: null
  has_dt: null
  prev_lt_pole_code: null
  feeder_wise_serial_no: null
  pole_number: null
  phase_c_id: null
  lt_pole_code: null
  no_of_wire_ht: null
  msj_no: null
  substation_name: null
  wire_length: null
  no_of_wire_lt: null
  sp_latitude: null
  pole_code: null
  type_of_wire_name: null
  distance_from_dt: null
  pole_no: null
  lt_feederline_id: null
  has_street_light: null
  village_area_name: null
  line_type_id: null
  is_common_pole: null
  wire_condition_name: null
  pole_condition_id: null
  line_type_name: null
  sp_lt_id: null
  prev_pole_no: null
  city_town: null
  primary_landmark: null
  substation_id: null
  no_of_consumers_b: null
  is_service_point: 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