Name: JointUseIssues

Display Field: name

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: -9821496.03370861
YMin: 5115549.93593752
XMax: -9804798.11008962
YMax: 5137938.83238724
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[52,163,129,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: 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: audit_type

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)
• 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)
• assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• date_recorded (type: esriFieldTypeDate, alias: Date Recorded, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• njuns_ticket_number (type: esriFieldTypeString, alias: NJUNS Ticket Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• entered_into_njuns (type: esriFieldTypeSmallInteger, alias: Entered Into NJUNS, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Yes], [2: No])
• audit_type (type: esriFieldTypeSmallInteger, alias: Audit Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Transfer], [1: Violation], [3: Unauthorized Attachment])
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• owner (type: esriFieldTypeSmallInteger, alias: Owner, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: AT&T])
• status (type: esriFieldTypeSmallInteger, alias: Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Open], [1: Closed])
• AssetGUID (type: esriFieldTypeGUID, alias: AssetGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• datenotified (type: esriFieldTypeDate, alias: Date Notified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• dateresolved (type: esriFieldTypeDate, alias: Date Resolved, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• name (type: esriFieldTypeString, alias: name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• notify (type: esriFieldTypeInteger, alias: Notify, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• issueresolved (type: esriFieldTypeInteger, alias: Issue Resolved, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• issue_phase (type: esriFieldTypeSmallInteger, alias: Issue Phase, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Submitted], [1: Notified], [2: Resolved], ... 2 more ...)
• issuecompleted (type: esriFieldTypeInteger, alias: Issue Completed, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• owner_label (type: esriFieldTypeString, alias: Owner Label, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• status_label (type: esriFieldTypeString, alias: Status Label, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• phase_label (type: esriFieldTypeString, alias: Phase Label, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• placement (type: esriFieldTypeInteger, alias: Placement, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 3 more ...)
• audit_label (type: esriFieldTypeString, alias: Audit Label, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• attachmenttype (type: esriFieldTypeString, alias: Attachment Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Cable: Cable], [Fiber: Fiber], ... 1 more ...)

Templates:

Name: JointUseIssues
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Relationships:

• JointUseIssuesComments (1) -- Related To: JointUseIssuesComments (3)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/1/2025 8:49:58 PM

Schema Last Edit Date: 7/9/2024 6:00:04 PM

Data Last Edit Date: 5/1/2025 8:49:59 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