Name: JointUseIssues

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

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":{"authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[197,194,252,255],"toColor":[197,194,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[244,252,179,255],"toColor":[244,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,252,255],"toColor":[179,252,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,189,184,255],"toColor":[252,189,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,187,235,255],"toColor":[252,187,235,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,233,210,255],"toColor":[252,233,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,207,255],"toColor":[179,252,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,222,252,255],"toColor":[179,222,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,232,255],"toColor":[252,212,232,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[231,252,212,255],"toColor":[231,252,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[238,207,252,255],"toColor":[238,207,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[228,179,252,255],"toColor":[228,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[205,252,179,255],"toColor":[205,252,179,255]}]}},"type":"uniqueValue","field1":"audit_type","fieldDelimiter":",","uniqueValueInfos":[{"symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"d2217817-89f3-4875-a69a-038be55158bd","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAACwklEQVRIic1VTWsTURS9CbFkpBVnVs4ULCpitd2UpBvRTURXCbioTcfuU/BPZPInhGYr7TQfCyV1o9iN4iaNbpKmICpd9E1XKbSFaIszcia+8c1kUlJF8GxC3kvuuffce8+L0T9G7L8gME1Tc6LnEtFIRHUcW8OZHXFqi/Pzjb8iWCmXE1E7YkjnpbQsyyTF4yRJknvHmJU3S1Uih4rknBR0XWdnIjBLFUO5qOQ1TaXpqZt99/zs85evufrmh5xZqhT07CNjKAJzrVJTZCWdTM6QIsve+fp2x/1MTyre2bWrV0hTVXr77n3eXKuq+sLc0qkEbuaykn5wP9VHzA6PQ6uVpDjh969eb6ASS6wkFtQcsiDzP8HdO7fpRe1lfqVc9gbAR4CGQnNRFuvwmNSxkdCAwTtUMj11i1qt9jIRJX0EGEVMi9hQaN5gR5RPXXa/ZwTtgWJ9jxLaqK8n+H+ztZXg3z0CzDlGUQyeedai3Owlauwe+QKzg14v2MF3Mt7s0OaTGUqMj3r3UGG1VM08zs7VPAIsEeYcQMCl55+8LIv1PToNyacffSSIg3j+Chxb40ukXRgZODFhQGD0gwNx+MaH7gEah4yQmXFvgtI3/NpzFDZ2qLbdISM14euDCI8A3oL1501GVssPr7uZ8dIhHarjk5MYH6PcrNoXnDHLjecjwNy63iIADRZLx0Q1WO+c3wdHuNv9Rp39fYraP6x+iRwqwluw/qJcgxB2xyzLjcPNL0BwUoBxwVuwNGcFMm+2tsiO2kV+5iMAK1wRxhXmRZlJpW8nRDRbbep2u4XF7O93om+KYFRwRRgXvEWsBJKETUsv8zaxXbauL/gtO3RMYblwRRgXvCXsPeANheaQBZkHgw8k4JXAFWFc8Basf+BFczNHQ6G5KMtQBMAvy3VdEd4SfJMxioOeyqEIRMC4hv2tiJ+daExQg+4bmQAAAABJRU5ErkJggg==","contentType":"image/png","width":18,"height":18},"value":"0","label":"Transfer"},{"symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"ed56da93-35de-4938-80ed-93c4ba34d66c","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAACyElEQVRIic1VTWsTURS9CU3JVBgzAYWkCq26aZONNJsG3QhaC3HXZDp2X5eCfyDJXtybfZ3mYyNRRAU3Sgt+rTLJyg9IOwEFUwM1YnBGzqszvjeZ1IgIntVk3uSee++597wJ+seY+C8IdF2P28HQQjAQiNm2Fcc7K2DX13K5V39FsFGpLAStQEGakjKKopAUDpMkSezMNDt5vVwjsqlE9qCoaZr5RwR6uVqIRqL5eDxGycTc0Lnz7s3bd+svXr5e18vVoqZmC2MR6JvVelSJZlKpsxRVlMOKpNOnZikei9HTZ1t5fbMW01ZXrh1KwDJXoplLFy/QuJCkMOH7R4+foJIOX8mEt+doy9SZSaq+LwtB5iNJSkQS7NnYM6i51xg6P38uTXfr9/MblYo7AAIBBGU9n52jG8+vCwHa+22X4OHuA9rZb7tnJ46cpKXpZZJCYUom5skwWreJKCUQYBQxLY542RlVqGKHC8g/A4vH0iSHZPaM/zeM5sJQizDnGEX3T8fTtP1xSwjWG/So9+2zEBzZ41se6MKdcu3KVXWl7hJgiTDnPHIzKt0ybrq/ja7YdwCt8QJxEE+swLbizhJ5s9v+sHXQmi9tkkNHhSodXQQCSWLxBIJRWJpedgkgNNFBy0CE3v8OLgG8Bevv3Vo5JLuC83osTV9mFfrBNDssnkCAuWXe4oNFj+B+wjro97/Sp26Xgtb3jkDAYFMJ3oL19yLHCe4nrJt9p8PiOObnIRgUYVzwFqw/D2SdiCRJnpR9hQWQecNokhW0Ss47gQCscEUYl58XZWfVoT3g0TBa1O/3i2vqr3tiaIpgVHBFGBe8ha8EgjsbO5x5i8xd8562Klq275jCcuGKMC54i9994AiKnqMtyNwbfCSBUwlcEcYFb8H6e240ljkERc/5toxFAPy0XOaK8BbvnYxRHHVVjkXAA8Y17rc8fgB0rESJdtoyVAAAAABJRU5ErkJggg==","contentType":"image/png","width":18,"height":18},"value":"1","label":"Violation"},{"symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"6539e1fa-5f4c-443b-883f-386172160e99","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADJ0lEQVRIicWVv0tbURzFvy8IiYWASShoNisorU5NOjgrDRStQ63WZnIxrh3bxQ7F/0AwGYSCEY06GOnYSXFo89LFFisk6VJd1Bdw0HTIK59rXrwvRmuH0gMvhPfuPed7vz/ObZF/jJb/LpDOZCIe2xg2xDNUFTtsiHTw3hDDtG3brHqqqfjYmPnXAoq4arwNtgWHwuEOCYfbpdXXKq2tPvX9xLIillWO7H79NrW8sm7a1V9PJyYmDm4lsLSyNnzH58v29T6QrnudTQMIBgLq4XuhWIp8zuV/LmfWEy/GnqVuFIA8FAhk+3rvC5Ffh+PjYwmFQuo/IoFAm2xt7ySXVtYOX46PbjYVIC0XkV+Q7+/vy+t4XO729Mj84mJ9He/fz83Jd9OU2YUF6e7uVqd5PDggG5sfsulMJurUxSVAzkmLTj6Zy4mZy8m0iBJxyNuTSXlSqUhiZESSGxtKhPo8ij6UXO5LUkSiLgGip6BOzh3yiIh6Uum0EiEtkI9WKmrdu709eTM9LcnVVfVN1aRQisDHKeoCtKKec9JC5JCDKRFZTacl6PXKQI0c5P1+RezUA1APq1xm66UAfU4rOiAdREzkkIPn/Gjka36/7MZiMjs/72qArq5OKRZ/sC1VF2CI6HMdjgiRK3INHzVyPXpAwW2x1eG1E0iHM0QOKCibSYseObBPT8Xweq+Q33qS9W4ZaCAHgyJSrBVeb2FwdnYutshhwwkMk/HneAwR5F6tW5y0EDnkQCW5iYhlWeIR48AlgHHhLQhwbIboVZOCkpaiVngSnT06ck322fm54nMJ4IoYlzMHTChDRJ/nGwrqdJcij8VkcmbGVYtCoaT4XAIMBa6IcSHCZDKhDBGb9W5xuovIIe/v778kL5bEsspmfLyJVWC5uCKDQqqUSG1CG4GInhZwYlnyKZc/tI1qwnnnEsDPsVxcEeOibW9qw0byre0d/ib0C+hKm+LnWC6uiHFddx/oIC1EDrlu1U0FAIuwXFwR4yJljD9pA/Q5rUi3UFByTlqaXZ3XDlptcRRXxLjwFmf8GSL6vH4n1wraDH+89GtCPK6r8Lb4DR7Qs0zxzP/eAAAAAElFTkSuQmCC","contentType":"image/png","width":18,"height":18},"value":"3","label":"Unauthorized Attachment"}]},"transparency":0}

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 ...)
• JointUseIssuesReview_count (type: esriFieldTypeString, alias: JointUseIssuesReview_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• JointUseIssuesComments_count (type: esriFieldTypeString, alias: JointUseIssuesComments_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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 ...)
• previous_phase (type: esriFieldTypeInteger, alias: Previous Phase, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Submitted], [1: Notified], [2: Resolved], ... 2 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 ...)

Types:

ID: 0
Name: Transfer
Domains:

• Field Name: entered_into_njuns
  Inherited
  
• Field Name: audit_type
  Inherited
  
• Field Name: owner
  Inherited
  
• Field Name: status
  Inherited
  
• Field Name: notify
  Inherited
  
• Field Name: issueresolved
  Inherited
  
• Field Name: issue_phase
  Inherited
  
Templates:

Name: Transfer
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• audit_type: 0
• status: 0
• issue_phase: 0

---

ID: 1
Name: Violation
Domains:

• Field Name: entered_into_njuns
  Inherited
  
• Field Name: audit_type
  Inherited
  
• Field Name: owner
  Inherited
  
• Field Name: status
  Inherited
  
• Field Name: notify
  Inherited
  
• Field Name: issueresolved
  Inherited
  
• Field Name: issue_phase
  Inherited
  
Templates:

Name: Violation
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• audit_type: 1
• status: 0
• issue_phase: 0

---

ID: 3
Name: Unauthorized Attachment
Domains:

• Field Name: entered_into_njuns
  Inherited
  
• Field Name: audit_type
  Inherited
  
• Field Name: owner
  Inherited
  
• Field Name: status
  Inherited
  
• Field Name: notify
  Inherited
  
• Field Name: issueresolved
  Inherited
  
• Field Name: issue_phase
  Inherited
  
Templates:

Name: Unauthorized Attachment
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• audit_type: 3
• status: 0
• issue_phase: 0

---

Relationships:

• JointUseIssuesReview (0) -- Related To: JointUseIssuesReview (4)
• 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:59 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   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat