Name: Water_Complaints
Display Field: Name
Type: Table
Has Views: true
Source Schema Changes Allowed: true
Views
Description:
Copyright Text:
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: true
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- LeakType (type: esriFieldTypeString, alias: Leak Type, SQL Type: sqlTypeOther, length: 500, nullable: false, editable: true)
- Description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Address (type: esriFieldTypeString, alias: Address Number, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- StreetName (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [E BEVERLY RD: E BEVERLY RD], [E CAPITOL DR: E CAPITOL DR], [E CONGRESS ST: E CONGRESS ST], ... 48 more ...)
- Name (type: esriFieldTypeString, alias: Contact Person Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Phone (type: esriFieldTypeString, alias: Contact Person Phone Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ReportDate (type: esriFieldTypeDate, alias: Report Date, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true)
- FixedDate (type: esriFieldTypeDate, alias: Fixed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Status (type: esriFieldTypeString, alias: Has Issue Been Fixed, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true, Coded Values: [Fixed: Fixed], [Reported: Reported], [InProgress: In Progress])
- ServiceStreet (type: esriFieldTypeString, alias: Service Street, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [E BEVERLY RD: E BEVERLY RD], [E CAPITOL DR: E CAPITOL DR], [E CONGRESS ST: E CONGRESS ST], ... 48 more ...)
- CurbStopGUID (type: esriFieldTypeGUID, alias: CurbStopGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Templates:
Name: Water_Complaints
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
- LeakType:
- ReportDate: -2209161600000
- Status:
Relationships:
- WATER_COMPLAINTS (0) -- Related To: Curb Stops (2)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 9/25/2026 4:17:01 PM
Schema Last Edit Date: 9/25/2026 4:17:01 PM
Data Last Edit Date: 9/24/2026 7:59:16 PM
Supported Operations:
Add Features
Apply Edits
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat