Name: Complaint Template used for public reporting and field collection

Display Field: CEName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -51086578.4162816
YMin: -981558.573726025
XMax: 22475979.1521961
YMax: 15347566.6722011
Spatial Reference: 102660 (2238)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[138,0,85,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Time Info:

Start Time Field: CreationDate
End Time Field: null
Track ID Field: null
Time Extent
[5/10/2025 10:19:03 AM UTC, 7/18/2025 2:44:07 PM UTC]

Time Reference: UTC
Time Interval: 0
Time Interval Units:
Has Live Data: false
Export Options:

Use Time: false
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• COMP1st (type: esriFieldTypeString, alias: Complainant First Name (Required):, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• COMPlast (type: esriFieldTypeString, alias: Complainant Last Name (Required):, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• COMPnum (type: esriFieldTypeString, alias: Complainant Phone Number (Required):, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
• COMPadd (type: esriFieldTypeString, alias: Complainant Street Address (Required):, SQL Type: sqlTypeOther, length: 100, nullable: false, editable: true)
• COMPcity (type: esriFieldTypeString, alias: Complainant City (Required):, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• COMPstate (type: esriFieldTypeString, alias: Complainant State (Required):, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true)
• COMPzip (type: esriFieldTypeString, alias: Complainant Zip Code (Required):, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true)
• VIOReport (type: esriFieldTypeString, alias: Violation Reported (Required):, SQL Type: sqlTypeOther, length: 200, nullable: false, editable: true)
• VIOloc (type: esriFieldTypeString, alias: Violation Location (If Address Not Known):, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• VIOaddress (type: esriFieldTypeString, alias: Violation Address:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• VIObus (type: esriFieldTypeString, alias: Violator Business Name (If Applicable):, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• VIO1st (type: esriFieldTypeString, alias: Violator First Name:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• VIOlast (type: esriFieldTypeString, alias: Violator Last Name:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• VIOparcid (type: esriFieldTypeString, alias: Violation Parcel ID:, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CEName (type: esriFieldTypeString, alias: TDC Code Enforcement Officer Assigned:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Clifton Hollington: Clifton Hollington], [Danny Garner: Danny Garner], [Dan Ratcliffe: Dan Ratcliffe], ... 23 more ...)
• VIOInvest (type: esriFieldTypeString, alias: VIOInvest, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
• INVdate (type: esriFieldTypeDate, alias: Investigation Date:, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INVcomments (type: esriFieldTypeString, alias: Investigation Comments:, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• COMPDate (type: esriFieldTypeDate, alias: Complaint Date:, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CASESTATUS (type: esriFieldTypeString, alias: CASESTATUS, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true, Coded Values: [Open: Assigned], [Closed: Closed], [Unverified: Unassigned])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• COMPEMAIL (type: esriFieldTypeString, alias: Complainant Email:, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: Complaint Template used for public reporting and field collection
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• CASESTATUS: Unverified
• COMP1st:
• COMPlast:
• COMPzip:
• COMPnum:
• COMPadd:
• COMPcity:
• COMPstate:
• VIOReport:
• CEName: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/18/2025 2:44:09 PM

Schema Last Edit Date: 7/18/2025 2:44:09 PM

Data Last Edit Date: 7/18/2025 2:44:09 PM

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