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
MaxRecordCount: 1000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: customerservice
Description: Survey Data Locations
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
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 Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
-
objectid
(
nullable: false, editable: false, defaultValue: null, alias: ObjectID, type: esriFieldTypeOID
)
-
globalid
(
nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID
)
-
date_time
(
nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: วันที่และเวลาที่สำรวจ, type: esriFieldTypeDate
)
-
nme_cus
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: ชื่อลูกค้า, type: esriFieldTypeString
)
-
nme_build
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: ชื่ออาคาร, type: esriFieldTypeString
)
-
building
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: ประเภทอาคาร, type: esriFieldTypeString
, Coded Values:
[1: ตึกสูง]
)
-
status
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: status, type: esriFieldTypeString
)
-
address
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: เลขที่, type: esriFieldTypeString
)
-
province_name
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: จังหวัด, type: esriFieldTypeString
, Coded Values:
[กรุงเทพมหานคร: กรุงเทพมหานคร]
, [นครปฐม: นครปฐม]
, [นนทบุรี: นนทบุรี]
, ...3 more...
)
-
district_name
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: อำเภอ/เขต, type: esriFieldTypeString
)
-
sub_district_name
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: ตำบล/แขวง, type: esriFieldTypeString
)
-
email
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: อีเมล์, type: esriFieldTypeString
)
-
phone
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: เบอร์โทร, type: esriFieldTypeString
)
-
fax
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: โทรสาร, type: esriFieldTypeString
)
-
user_name
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: user_name, type: esriFieldTypeString
)
-
tube_e14
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: e14, type: esriFieldTypeString
, Coded Values:
[0: ไม่เลือก]
, [150: LED 4w (40/6) / 150.-]
)
-
watt_e14
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: วัตต์ที่เปลี่ยน, type: esriFieldTypeString
)
-
num_e140
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนหลอด, type: esriFieldTypeInteger
)
-
num_e14
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: num_e14, type: esriFieldTypeString
)
-
watt_e140
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: watt_e140, type: esriFieldTypeString
)
-
tube_e27
(
nullable: true, editable: true, defaultValue: null, 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: null, length: 255, alias: วัตต์ที่เปลี่ยน, type: esriFieldTypeString
)
-
num_e270
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนหลอด, type: esriFieldTypeInteger
)
-
num_e27
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: num_e27, type: esriFieldTypeString
)
-
watt_e270
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: watt_e270, type: esriFieldTypeString
)
-
tube_t8
(
nullable: true, editable: true, defaultValue: null, 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: null, length: 255, alias: วัตต์ที่เปลี่ยน, type: esriFieldTypeString
)
-
num_t80
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนหลอด, type: esriFieldTypeInteger
)
-
num_t8
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: num_t8, type: esriFieldTypeString
)
-
watt_t80
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: watt_t80, type: esriFieldTypeString
)
-
tube_gu53
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: gu53, type: esriFieldTypeString
, Coded Values:
[0: ไม่เลือก]
, [155: TUBE Ecofit 10w / 155.-]
)
-
watt_gu53
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: วัตต์ที่เปลี่ยน, type: esriFieldTypeString
)
-
num_gu530
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนหลอด, type: esriFieldTypeInteger
)
-
num_gu53
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: num_gu53, type: esriFieldTypeString
)
-
watt_gu530
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: watt_gu530, type: esriFieldTypeString
)
-
cost_e14
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวมหลอดจำปา, type: esriFieldTypeInteger
)
-
cost_e27
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวมหลอดบัพฟ์, type: esriFieldTypeInteger
)
-
cost_t8
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวมหลอดฟลูออเรสเซ้นท์, type: esriFieldTypeInteger
)
-
cost_gu53
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวมหลอดฮาโลเจน, type: esriFieldTypeInteger
)
-
sum_tube
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวมหลอดไฟ, type: esriFieldTypeInteger
)
-
sum_watt
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนวัตต์ที่ลดลง, type: esriFieldTypeInteger
)
-
cost_totalyear
(
nullable: true, editable: true, defaultValue: null, alias: ค่าไฟฟ้าที่ลดลง บาท/ปี, type: esriFieldTypeDouble
)
-
cost_sum
(
nullable: true, editable: true, defaultValue: null, alias: ระยะเวลาคุ้มทุน (เดือน), type: esriFieldTypeDouble
)
-
cost_unit
(
nullable: true, editable: true, defaultValue: null, alias: ราคาค่าไฟฟ้าต่อยูนิต, type: esriFieldTypeDouble
)
-
timehour
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนชั่วโมงที่ใช้ไฟฟ้าต่อวัน, type: esriFieldTypeDouble
)
-
kw_total
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: kw_total, type: esriFieldTypeString
)
-
unit
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: unit, type: esriFieldTypeString
)
-
cost_totalday
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: cost_totalday, type: esriFieldTypeString
)
-
cost_totalmonth
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: cost_totalmonth, type: esriFieldTypeString
)
-
buy_rec2
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: buy_rec2, type: esriFieldTypeString
)
-
cus_num
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: cus_num, type: esriFieldTypeString
)
-
due_year
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: due_year, type: esriFieldTypeString
)
-
due_date1
(
nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: วัน/เดือนปี/สั่งซื้อ, type: esriFieldTypeDate
)
-
type01
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: type01, type: esriFieldTypeString
)
-
tube2_1
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: tube2_1, type: esriFieldTypeString
)
-
e14_amo1
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนหลอด(E14), type: esriFieldTypeInteger
)
-
e14_price1
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวม(E14), type: esriFieldTypeDouble
)
-
tube3_1
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: tube3_1, type: esriFieldTypeString
)
-
e27_amo1
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนหลอด(E27), type: esriFieldTypeInteger
)
-
e27_price1
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวม(E27), type: esriFieldTypeDouble
)
-
tube4_1
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: tube4_1, type: esriFieldTypeString
)
-
g13_amo1
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนหลอด(G13), type: esriFieldTypeInteger
)
-
g13_price1
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวม(G13), type: esriFieldTypeDouble
)
-
tube5_1
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: tube5_1, type: esriFieldTypeString
)
-
g53_amo1
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนหลอด(GU53), type: esriFieldTypeInteger
)
-
g53_price1
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวม(GU53), type: esriFieldTypeDouble
)
-
all_price1
(
nullable: true, editable: true, defaultValue: null, alias: ยอดขายรวม, type: esriFieldTypeDouble
)
-
sell_nam1
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: ชื่อพนักงานขาย, type: esriFieldTypeString
)
-
due_date2
(
nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: วัน/เดือนปี/สั่งซื้อ, type: esriFieldTypeDate
)
-
type02
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: type02, type: esriFieldTypeString
)
-
tube2_2
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: tube2_2, type: esriFieldTypeString
)
-
e14_amo2
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนหลอด(E14), type: esriFieldTypeInteger
)
-
e14_price2
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวม(E14), type: esriFieldTypeDouble
)
-
tube3_2
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: tube3_2, type: esriFieldTypeString
)
-
e27_amo2
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนหลอด(E27), type: esriFieldTypeInteger
)
-
e27_price2
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวม(E27), type: esriFieldTypeDouble
)
-
tube4_2
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: tube4_2, type: esriFieldTypeString
)
-
g13_amo2
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนหลอด(G13), type: esriFieldTypeInteger
)
-
g13_price2
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวม(G13), type: esriFieldTypeDouble
)
-
tube5_2
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: tube5_2, type: esriFieldTypeString
)
-
g53_amo2
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนหลอด(GU53), type: esriFieldTypeInteger
)
-
g53_price2
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวม(GU53), type: esriFieldTypeDouble
)
-
all_price2
(
nullable: true, editable: true, defaultValue: null, alias: ยอดขายรวม, type: esriFieldTypeDouble
)
-
sell_nam2
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: ชื่อพนักงานขาย, type: esriFieldTypeString
)
-
due_date3
(
nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: วัน/เดือนปี/สั่งซื้อ, type: esriFieldTypeDate
)
-
type03
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: type03, type: esriFieldTypeString
)
-
tube2_3
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: tube2_3, type: esriFieldTypeString
)
-
e14_amo3
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนหลอด(E14), type: esriFieldTypeInteger
)
-
e14_price3
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวม(E14), type: esriFieldTypeDouble
)
-
tube3_3
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: tube3_3, type: esriFieldTypeString
)
-
e27_amo3
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนหลอด(E27), type: esriFieldTypeInteger
)
-
e27_price3
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวม(E27), type: esriFieldTypeDouble
)
-
tube4_3
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: tube4_3, type: esriFieldTypeString
)
-
g13_amo3
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนหลอด(G13), type: esriFieldTypeInteger
)
-
g13_price3
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวม(G13), type: esriFieldTypeDouble
)
-
tube5_3
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: tube5_3, type: esriFieldTypeString
)
-
g53_amo3
(
nullable: true, editable: true, defaultValue: null, alias: จำนวนหลอด(GU53), type: esriFieldTypeInteger
)
-
g53_price3
(
nullable: true, editable: true, defaultValue: null, alias: ราคารวม(GU53), type: esriFieldTypeDouble
)
-
all_price3
(
nullable: true, editable: true, defaultValue: null, alias: ยอดขายรวม, type: esriFieldTypeDouble
)
-
sell_nam3
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: ชื่อพนักงานขาย, type: esriFieldTypeString
)
-
ajob_date
(
nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: วันที่นัดพบ, type: esriFieldTypeDate
)
-
ajob_per
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: ajob_per, type: esriFieldTypeString
)
-
created_user
(
nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString
)
-
created_date
(
nullable: true, editable: false, defaultValue: null, precision: 1, 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, 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:
Field Groups
  
Contingent Values
Supported Operations:
Query
Query Attachments
Query Analytic
Query Top Features
Query Bins
Apply Edits
Add Features
Update Features
Delete Features
Calculate
Append
Validate SQL
Generate Renderer
Return Updates
Metadata
Update Metadata