Name: CC_complaints_master

Display Field: OBJECTID

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: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -115211411.338416
YMin: -93821070.4960547
XMax: 128334744.67175
YMax: 76478306.0228868
Spatial Reference: 102642 (2226)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[50,87,147,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

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)
• SUB_NAME (type: esriFieldTypeString, alias: Submission Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SUB_ADDR (type: esriFieldTypeString, alias: Submission Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SUB_CITY (type: esriFieldTypeString, alias: Submission City, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SUB_STATE (type: esriFieldTypeString, alias: Submission State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• SUB_ZIP (type: esriFieldTypeString, alias: Submission Zip Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SUB_PHONE (type: esriFieldTypeString, alias: Submission Phone Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• SUB_EMAIL (type: esriFieldTypeString, alias: Submission Email, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• VLTN_ADDR (type: esriFieldTypeString, alias: Violation Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• VLTN_CITY (type: esriFieldTypeString, alias: Violation City, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [ACAN: American Canyon], [ANGW: Angwin], [CALI: Calistoga], ... 8 more ...)
• VLTN_STATE (type: esriFieldTypeString, alias: Violation State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• VLTN_ZIP (type: esriFieldTypeString, alias: Violation Zip, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• VLTN_INFO (type: esriFieldTypeString, alias: Violation Info, SQL Type: sqlTypeOther, length: 3000, nullable: true, editable: true)
• FOLLOW_UP (type: esriFieldTypeString, alias: Request for Follow-Up?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SUB_ID (type: esriFieldTypeString, alias: Complaint ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Intake: Intake], [In Progress: In Progress], [Resolved: Resolved], ... 4 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• DATE_RECEIVED (type: esriFieldTypeDate, alias: Date Received, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Processed_ (type: esriFieldTypeString, alias: Processed?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Source (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [complaint: Complaint], [observed: Observed])
• Req_Taken (type: esriFieldTypeString, alias: Request Taken By, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)

Templates:

Name: CC_complaints_master
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/10/2025 2:01:30 AM

Schema Last Edit Date: 1/16/2025 10:22:47 PM

Data Last Edit Date: 4/10/2025 2:01:30 AM

Supported Operations:   Add Features   Apply Edits   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat