Name: Complaint Template used for public reporting and field collection

Display Field: CEName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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: -125938627.483313
YMin: -91452962.8468314
XMax: 129875627.483313
YMax: 37469186.0827986
Spatial Reference: 102660 (2238)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[156,62,0,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

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: Complaintant First Name (Required):, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• COMPlast (type: esriFieldTypeString, alias: Complaintant Last Name (Required):, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• COMPnum (type: esriFieldTypeString, alias: Complaintant Phone Number (Required):, SQL Type: sqlTypeOther, length: 20, 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: [0: Unverified], [1: Jeff McVay], [2: Clifton Hollington], ... 7 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: Open], [Closed: Closed], [Unverified: Unverified])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

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

Attributes:

• CASESTATUS: Unverified
• COMP1st:
• COMPlast:
• COMPnum:
• VIOReport:
• CEName: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/16/2018 4:18:37 PM

Schema Last Edit Date: 7/16/2018 4:18:37 PM

Data Last Edit Date: 7/16/2018 4:18:37 PM

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