Name: Problems_DEV

Display Field: POCFULLNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 4622325

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -16651561.1274457
YMin: 9503210.66137724
XMax: -16115210.9277437
YMax: 9713580.78925142
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"color":[150,49,165,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,0,0,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"}}},"transparency":0}

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)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CATEGORY (type: esriFieldTypeString, alias: Category, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Abandoned Vehicle: Abandoned Vehicle], [Animal: Animal], [Land Use: Land Use], ... 3 more ...)
• PROBTYPE (type: esriFieldTypeString, alias: Type of Problem, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Abandoned Vehicle: Abandoned Vehicle])
• DETAILS (type: esriFieldTypeString, alias: Details, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• POCFULLNAME (type: esriFieldTypeString, alias: Full Name (optional), SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• POCFIRSTNAME (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• POCLASTNAME (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• POCPHONE (type: esriFieldTypeString, alias: Phone Number (optional), SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• POCEMAIL (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Submitted: Submitted], [Received: Received], [In Progress: In Progress], ... 3 more ...)
• LOCDESC (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USERID (type: esriFieldTypeString, alias: User Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• NUMVOTES (type: esriFieldTypeSmallInteger, alias: Number of Votes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSIGNEDTO (type: esriFieldTypeString, alias: Assigned To, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Rural Services: Rural Services], [Animal Control: Animal Control], [Transportation: Transportation], ... 1 more ...)
• RESOLUTION (type: esriFieldTypeString, alias: Resolution, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RESOLUTIONDT (type: esriFieldTypeDate, alias: Resolved On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EMAILSTATUS (type: esriFieldTypeString, alias: Email Status, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• COMMISSIONERDT (type: esriFieldTypeDate, alias: Contacted Commissioner, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• probguid (type: esriFieldTypeGUID, alias: Problem ID, SQL Type: sqlTypeOther, length: 38, 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)
• case_num (type: esriFieldTypeInteger, alias: Case Number, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Abandoned Vehicle Problem
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• CATEGORY: Abandoned Vehicle
• STATUS: Submitted
• ASSIGNEDTO:
• PROBTYPE: Abandoned Vehicle

Relationships:

• (0) -- Related To: Comments (1)
• (1) -- Related To: Surveys (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/22/2023 7:25:38 PM

Schema Last Edit Date: 11/30/2022 6:58:11 PM

Data Last Edit Date: 5/22/2023 7:25:38 PM

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