Name: Customers

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 144448

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -12353958.0282961
YMin: 3793154.4758963
XMax: -12350115.8817927
YMax: 3795088.99651387
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"visualVariables":[{"type":"sizeInfo","valueExpression":"$view.scale","stops":[{"size":11.599854227405245,"value":564.248588},{"size":9.279883381924197,"value":4513.988705},{"size":4.6399416909620985,"value":36111.909643},{"size":2.3199708454810493,"value":288895.277144}]}],"type":"uniqueValue","field1":"Status","uniqueValueInfos":[{"label":"Complete","symbol":{"color":[176,32,32,255],"size":10.61,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"value":"C"},{"value":"P","label":"Pending","symbol":{"color":[86,156,42,255],"size":10.6125,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}},{"value":"I","label":"In Progress","symbol":{"color":[240,176,26,255],"size":10.6125,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}}]},"transparency":0}

HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field: Status

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Name (type: esriFieldTypeString, alias: Customer Name, SQL Type: sqlTypeOther, length: 65, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 65, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [P: Pending], [I: In Progress], [C: Complete])
• FollowUp (type: esriFieldTypeString, alias: Follow Up Required, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CustomerID (type: esriFieldTypeString, alias: CustomerID, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CustomerType (type: esriFieldTypeString, alias: Customer Type, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Residential: Residential], [Commercial: Commercial], [Municipal: Municipal], ... 1 more ...)
• Agency (type: esriFieldTypeString, alias: Agency Name, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [City: City ], [County: County], [State: State], ... 1 more ...)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• CountyName (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• MaintReq (type: esriFieldTypeInteger, alias: # of Maintenance Requests, SQL Type: sqlTypeOther, nullable: true, editable: true)

Types:

ID: C
Name: Complete
Domains:

Templates:

Name: Complete
Description: Install Completed
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Status: C
• FollowUp: N
• City: Tucson

---

ID: P
Name: Pending
Domains:

Templates:

Name: Pending
Description: Contract Pending
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Status: P
• FollowUp: Y
• City: Tucson

---

ID: I
Name: In Progress
Domains:

Templates:

Name: In Progress
Description: Install In Progress
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Status: I
• FollowUp: Y
• City: Tucson

---

Relationships:

• Install (0) -- Related To: Installation_Record (1)
• Maintenance (1) -- Related To: Maintenance_Request (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/20/2025 2:53:26 AM

Schema Last Edit Date: 7/16/2024 10:21:21 PM

Data Last Edit Date: 1/20/2025 2:53:26 AM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat