Name: c20231008_FoodpandaOrderPlacementData_001_XYTableToPoint

Display Field: receiptId

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 6.32778044253391E-09
YMin: 5.6649236412909E-09
XMax: 12720700.851929
YMax: 2572988.50471919
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"heatmap","field":"","legendOptions":{"minLabel":"Sparse","maxLabel":"Dense"},"colorStops":[{"ratio":0,"color":[133,193,200,0]},{"ratio":0.01,"color":[133,193,200,0]},{"ratio":0.01,"color":[133,193,200,0]},{"ratio":0.01,"color":[133,193,200,0]},{"ratio":0.07896037,"color":[133,193,200,255]},{"ratio":0.15551303,"color":[144,161,190,255]},{"ratio":0.23206569,"color":[156,129,132,255]},{"ratio":0.30861835,"color":[167,97,170,255]},{"ratio":0.38517101,"color":[175,73,128,255]},{"ratio":0.46172367,"color":[184,48,85,255]},{"ratio":0.53827633,"color":[192,24,42,255]},{"ratio":0.61482899,"color":[200,0,0,255]},{"ratio":0.69138165,"color":[211,51,0,255]},{"ratio":0.76793431,"color":[222,102,0,255]},{"ratio":0.84448697,"color":[233,153,0,255]},{"ratio":0.92103963,"color":[244,204,0,255]},{"ratio":0.9975923,"color":[255,255,0,255]}],"radius":10,"minDensity":0,"maxDensity":1.2518499555301064},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• accountEmailId (type: esriFieldTypeBigInteger, alias: accountEmailId, SQL Type: sqlTypeOther, nullable: true, editable: true)
• receiptId (type: esriFieldTypeString, alias: receiptId, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• receivedDate (type: esriFieldTypeInteger, alias: receivedDate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• orderId (type: esriFieldTypeString, alias: orderId, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• totalCharged (type: esriFieldTypeDouble, alias: totalCharged, SQL Type: sqlTypeOther, nullable: true, editable: true)
• totalChargedUSD (type: esriFieldTypeDouble, alias: totalChargedUSD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• currency (type: esriFieldTypeString, alias: currency, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• paymentMethod (type: esriFieldTypeString, alias: paymentMethod, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• city (type: esriFieldTypeString, alias: city, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• state (type: esriFieldTypeString, alias: state, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• stateDistrict (type: esriFieldTypeString, alias: stateDistrict, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• country (type: esriFieldTypeString, alias: country, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• countryCode (type: esriFieldTypeString, alias: countryCode, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• orderTime (type: esriFieldTypeInteger, alias: orderTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pickupTime (type: esriFieldTypeInteger, alias: pickupTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dropoffTime (type: esriFieldTypeInteger, alias: dropoffTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pickupLat (type: esriFieldTypeDouble, alias: pickupLat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pickupLon (type: esriFieldTypeDouble, alias: pickupLon, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dropoffLat (type: esriFieldTypeDouble, alias: dropoffLat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dropoffLon (type: esriFieldTypeDouble, alias: dropoffLon, SQL Type: sqlTypeOther, nullable: true, editable: true)
• isPickupOrder (type: esriFieldTypeString, alias: isPickupOrder, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• serviceType (type: esriFieldTypeString, alias: serviceType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• restaurant (type: esriFieldTypeString, alias: restaurant, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• deliveryFee (type: esriFieldTypeInteger, alias: deliveryFee, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deliveryFeeUSD (type: esriFieldTypeDouble, alias: deliveryFeeUSD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• priceItems (type: esriFieldTypeString, alias: priceItems, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• productItems (type: esriFieldTypeString, alias: productItems, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• driverId (type: esriFieldTypeString, alias: driverId, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• osType (type: esriFieldTypeString, alias: osType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• isSyncing (type: esriFieldTypeString, alias: isSyncing, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• firstEmailReceivedAt (type: esriFieldTypeInteger, alias: firstEmailReceivedAt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lastEmailReceivedAt (type: esriFieldTypeInteger, alias: lastEmailReceivedAt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• accountCreatedAt (type: esriFieldTypeInteger, alias: accountCreatedAt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• syncDisabledOn (type: esriFieldTypeInteger, alias: syncDisabledOn, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sector (type: esriFieldTypeString, alias: sector, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Templates:

Name: 20087281
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• accountEmailId: 2147578048.5

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/12/2025 2:52:04 AM

Schema Last Edit Date: 3/12/2025 2:52:04 AM

Data Last Edit Date: 3/12/2025 2:52:04 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat