View In:   ArcGIS Online Map Viewer

Name: customerservice

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 8a450ca245b6403aa7c5f3e1324efa8c

Copyright Text:

Default Visibility: true

Max Result Window: N/A

Max Record Count: 1000

Standard Max Record Count No Geometry: 16000

Max Record Count Factor: 1

Standard MaxRecord Count: 16000

Tile Max Record Count: 4000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -180.0
YMin: -90.0
XMax: 180.0
YMax: 90.0
Spatial Reference: 4326

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: customerservice
Description: Survey Data Locations
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, editable: false, defaultValue: N/A, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: N/A, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• date_time ( nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 29, alias: วันที่และเวลาที่สำรวจ, type: esriFieldTypeDate )
• nme_cus ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: ชื่อลูกค้า, type: esriFieldTypeString )
• nme_build ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: ชื่ออาคาร, type: esriFieldTypeString )
• building ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: ประเภทอาคาร, type: esriFieldTypeString , Coded Values: [1: ตึกสูง] )
• status ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: status, type: esriFieldTypeString )
• address ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: เลขที่, type: esriFieldTypeString )
• province_name ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: จังหวัด, type: esriFieldTypeString , Coded Values: [กรุงเทพมหานคร: กรุงเทพมหานคร] , [นครปฐม: นครปฐม] , [นนทบุรี: นนทบุรี] , ...3 more... )
• district_name ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: อำเภอ/เขต, type: esriFieldTypeString )
• sub_district_name ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: ตำบล/แขวง, type: esriFieldTypeString )
• email ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: อีเมล์, type: esriFieldTypeString )
• phone ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: เบอร์โทร, type: esriFieldTypeString )
• fax ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: โทรสาร, type: esriFieldTypeString )
• user_name ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: user_name, type: esriFieldTypeString )
• tube_e14 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: e14, type: esriFieldTypeString , Coded Values: [0: ไม่เลือก] , [150: LED 4w (40/6) / 150.-] )
• watt_e14 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: วัตต์ที่เปลี่ยน, type: esriFieldTypeString )
• num_e140 ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนหลอด, type: esriFieldTypeInteger )
• num_e14 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: num_e14, type: esriFieldTypeString )
• watt_e140 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: watt_e140, type: esriFieldTypeString )
• tube_e27 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: e27, type: esriFieldTypeString , Coded Values: [0: ไม่เลือก] , [59: LED 3w (25/5) / 59.-] , [69: LED 4w (40/6) / 69.-] , ...5 more... )
• watt_e27 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: วัตต์ที่เปลี่ยน, type: esriFieldTypeString )
• num_e270 ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนหลอด, type: esriFieldTypeInteger )
• num_e27 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: num_e27, type: esriFieldTypeString )
• watt_e270 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: watt_e270, type: esriFieldTypeString )
• tube_t8 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: t8, type: esriFieldTypeString , Coded Values: [0: ไม่เลือก] , [289: TUBE Ecofit 14.5w / 289.-] , [500: TUBE Ecofit 16w /500 .-] , ...2 more... )
• watt_t8 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: วัตต์ที่เปลี่ยน, type: esriFieldTypeString )
• num_t80 ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนหลอด, type: esriFieldTypeInteger )
• num_t8 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: num_t8, type: esriFieldTypeString )
• watt_t80 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: watt_t80, type: esriFieldTypeString )
• tube_gu53 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: gu53, type: esriFieldTypeString , Coded Values: [0: ไม่เลือก] , [155: TUBE Ecofit 10w / 155.-] )
• watt_gu53 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: วัตต์ที่เปลี่ยน, type: esriFieldTypeString )
• num_gu530 ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนหลอด, type: esriFieldTypeInteger )
• num_gu53 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: num_gu53, type: esriFieldTypeString )
• watt_gu530 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: watt_gu530, type: esriFieldTypeString )
• cost_e14 ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวมหลอดจำปา, type: esriFieldTypeInteger )
• cost_e27 ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวมหลอดบัพฟ์, type: esriFieldTypeInteger )
• cost_t8 ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวมหลอดฟลูออเรสเซ้นท์, type: esriFieldTypeInteger )
• cost_gu53 ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวมหลอดฮาโลเจน, type: esriFieldTypeInteger )
• sum_tube ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวมหลอดไฟ, type: esriFieldTypeInteger )
• sum_watt ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนวัตต์ที่ลดลง, type: esriFieldTypeInteger )
• cost_totalyear ( nullable: true, editable: true, defaultValue: N/A, alias: ค่าไฟฟ้าที่ลดลง บาท/ปี, type: esriFieldTypeDouble )
• cost_sum ( nullable: true, editable: true, defaultValue: N/A, alias: ระยะเวลาคุ้มทุน (เดือน), type: esriFieldTypeDouble )
• cost_unit ( nullable: true, editable: true, defaultValue: N/A, alias: ราคาค่าไฟฟ้าต่อยูนิต, type: esriFieldTypeDouble )
• timehour ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนชั่วโมงที่ใช้ไฟฟ้าต่อวัน, type: esriFieldTypeDouble )
• kw_total ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: kw_total, type: esriFieldTypeString )
• unit ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: unit, type: esriFieldTypeString )
• cost_totalday ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: cost_totalday, type: esriFieldTypeString )
• cost_totalmonth ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: cost_totalmonth, type: esriFieldTypeString )
• buy_rec2 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: buy_rec2, type: esriFieldTypeString )
• cus_num ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: cus_num, type: esriFieldTypeString )
• due_year ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: due_year, type: esriFieldTypeString )
• due_date1 ( nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 29, alias: วัน/เดือนปี/สั่งซื้อ, type: esriFieldTypeDate )
• type01 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: type01, type: esriFieldTypeString )
• tube2_1 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: tube2_1, type: esriFieldTypeString )
• e14_amo1 ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนหลอด(E14), type: esriFieldTypeInteger )
• e14_price1 ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวม(E14), type: esriFieldTypeDouble )
• tube3_1 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: tube3_1, type: esriFieldTypeString )
• e27_amo1 ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนหลอด(E27), type: esriFieldTypeInteger )
• e27_price1 ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวม(E27), type: esriFieldTypeDouble )
• tube4_1 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: tube4_1, type: esriFieldTypeString )
• g13_amo1 ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนหลอด(G13), type: esriFieldTypeInteger )
• g13_price1 ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวม(G13), type: esriFieldTypeDouble )
• tube5_1 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: tube5_1, type: esriFieldTypeString )
• g53_amo1 ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนหลอด(GU53), type: esriFieldTypeInteger )
• g53_price1 ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวม(GU53), type: esriFieldTypeDouble )
• all_price1 ( nullable: true, editable: true, defaultValue: N/A, alias: ยอดขายรวม, type: esriFieldTypeDouble )
• sell_nam1 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: ชื่อพนักงานขาย, type: esriFieldTypeString )
• due_date2 ( nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 29, alias: วัน/เดือนปี/สั่งซื้อ, type: esriFieldTypeDate )
• type02 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: type02, type: esriFieldTypeString )
• tube2_2 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: tube2_2, type: esriFieldTypeString )
• e14_amo2 ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนหลอด(E14), type: esriFieldTypeInteger )
• e14_price2 ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวม(E14), type: esriFieldTypeDouble )
• tube3_2 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: tube3_2, type: esriFieldTypeString )
• e27_amo2 ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนหลอด(E27), type: esriFieldTypeInteger )
• e27_price2 ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวม(E27), type: esriFieldTypeDouble )
• tube4_2 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: tube4_2, type: esriFieldTypeString )
• g13_amo2 ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนหลอด(G13), type: esriFieldTypeInteger )
• g13_price2 ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวม(G13), type: esriFieldTypeDouble )
• tube5_2 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: tube5_2, type: esriFieldTypeString )
• g53_amo2 ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนหลอด(GU53), type: esriFieldTypeInteger )
• g53_price2 ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวม(GU53), type: esriFieldTypeDouble )
• all_price2 ( nullable: true, editable: true, defaultValue: N/A, alias: ยอดขายรวม, type: esriFieldTypeDouble )
• sell_nam2 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: ชื่อพนักงานขาย, type: esriFieldTypeString )
• due_date3 ( nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 29, alias: วัน/เดือนปี/สั่งซื้อ, type: esriFieldTypeDate )
• type03 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: type03, type: esriFieldTypeString )
• tube2_3 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: tube2_3, type: esriFieldTypeString )
• e14_amo3 ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนหลอด(E14), type: esriFieldTypeInteger )
• e14_price3 ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวม(E14), type: esriFieldTypeDouble )
• tube3_3 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: tube3_3, type: esriFieldTypeString )
• e27_amo3 ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนหลอด(E27), type: esriFieldTypeInteger )
• e27_price3 ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวม(E27), type: esriFieldTypeDouble )
• tube4_3 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: tube4_3, type: esriFieldTypeString )
• g13_amo3 ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนหลอด(G13), type: esriFieldTypeInteger )
• g13_price3 ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวม(G13), type: esriFieldTypeDouble )
• tube5_3 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: tube5_3, type: esriFieldTypeString )
• g53_amo3 ( nullable: true, editable: true, defaultValue: N/A, alias: จำนวนหลอด(GU53), type: esriFieldTypeInteger )
• g53_price3 ( nullable: true, editable: true, defaultValue: N/A, alias: ราคารวม(GU53), type: esriFieldTypeDouble )
• all_price3 ( nullable: true, editable: true, defaultValue: N/A, alias: ยอดขายรวม, type: esriFieldTypeDouble )
• sell_nam3 ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: ชื่อพนักงานขาย, type: esriFieldTypeString )
• ajob_date ( nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 29, alias: วันที่นัดพบ, type: esriFieldTypeDate )
• ajob_per ( nullable: true, editable: true, defaultValue: N/A, length: 255, alias: ajob_per, type: esriFieldTypeString )
• created_user ( nullable: true, editable: false, defaultValue: N/A, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: N/A, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: N/A, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: N/A, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Templates:

• Name: New Feature
  Description:
  Prototype:
  timehour: null
  e14_price1: null
  cost_t8: null
  building: null
  tube_e27: null
  fax: null
  watt_e27: null
  watt_t80: null
  tube5_3: null
  sum_tube: null
  tube5_2: null
  tube5_1: null
  province_name: null
  tube_gu53: null
  phone: null
  tube_e14: null
  e14_price2: null
  e14_price3: null
  g53_amo3: null
  watt_e14: null
  g53_amo1: null
  g53_amo2: null
  status: null
  num_gu53: null
  user_name: null
  sell_nam3: null
  sell_nam2: null
  sell_nam1: null
  cost_e27: null
  sub_district_name: null
  tube_t8: null
  due_year: null
  email: null
  cost_unit: null
  num_e140: null
  cost_e14: null
  address: null
  cost_totalyear: null
  kw_total: null
  e14_amo1: null
  tube4_3: null
  e14_amo2: null
  e14_amo3: null
  cost_sum: null
  tube4_2: null
  tube4_1: null
  type03: null
  type02: null
  type01: null
  cost_totalday: null
  num_e270: null
  due_date2: null
  due_date1: null
  due_date3: null
  watt_gu530: null
  watt_e270: null
  e27_amo1: null
  date_time: null
  e27_amo3: null
  e27_amo2: null
  cost_totalmonth: null
  g13_amo3: null
  g13_amo1: null
  g13_amo2: null
  nme_build: null
  nme_cus: null
  tube3_1: null
  tube3_3: null
  tube3_2: null
  watt_gu53: null
  unit: null
  g13_price1: null
  g13_price2: null
  ajob_per: null
  cus_num: null
  e27_price2: null
  e27_price3: null
  e27_price1: null
  num_t8: null
  g13_price3: null
  num_e14: null
  all_price3: null
  district_name: null
  g53_price2: null
  g53_price1: null
  cost_gu53: null
  g53_price3: null
  all_price1: null
  all_price2: null
  sum_watt: null
  tube2_2: null
  buy_rec2: null
  tube2_1: null
  tube2_3: null
  num_e27: null
  watt_e140: null
  num_t80: null
  ajob_date: null
  watt_t8: null
  num_gu530: null
  
  Drawing Tool: N/A

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

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

Child Resources:

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