View In:   ArcGIS Online Map Viewer

Name: Sign Structure

Display Field: notes

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1132814.9866468906
YMin: 722022.9462385625
XMax: 1853513.6197218
YMax: 818834.2782060653
Spatial Reference: 103130  (6551)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [230, 0, 0, 255]
Size: 10.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• notes ( type: esriFieldTypeString, alias: notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: notes )
• sy ( type: esriFieldTypeDouble, alias: sy, editable: true, nullable: true, defaultValue: null, modelName: sy )
• cy ( type: esriFieldTypeDouble, alias: cy, editable: true, nullable: true, defaultValue: null, modelName: cy )
• length ( type: esriFieldTypeDouble, alias: length, editable: true, nullable: true, defaultValue: null, modelName: length )
• quantity ( type: esriFieldTypeInteger, alias: quantity, editable: true, nullable: true, defaultValue: null, modelName: quantity )
• pay_item ( type: esriFieldTypeInteger, alias: pay_item, editable: true, nullable: true, defaultValue: null, modelName: pay_item , Coded Values: [9061: 100111000 EA - MIS-56 - Riser, Street Lighting Circuit] , [9012: 100116900 EA - MIS-500 - Pole, To Be Wired, 2-Wire] , [9071: 1001C10000 LS - MIS-1 - Streetlight Lockout/Tagout] , ...3751 more... )
• group_pay_item ( type: esriFieldTypeInteger, alias: group_pay_item, editable: true, nullable: true, defaultValue: null, modelName: group_pay_item , Coded Values: [1637: EA - INSTALL NEW SIGN] , [1624: EA - RELOCATE RESIDENTIAL STREET NAME SIGN] , [1623: EA - RELOCATE WITH NEW STOP SIGN] )
• favorite_pay_item ( type: esriFieldTypeInteger, alias: favorite_pay_item, editable: true, nullable: true, defaultValue: null, modelName: favorite_pay_item , Coded Values: [1734: REMOVAL OF GROUND MOUNTED SIGN AND DISPOSAL] , [1733: REMOVAL OF GROUND MOUNTED SIGN AND REERECTION] , [1823: REMOVAL OF POLE MOUNTED SIGN AND DISPOSAL] )
• plan_label ( type: esriFieldTypeString, alias: plan_label, editable: true, nullable: true, length: 255, defaultValue: null, modelName: plan_label )
• plan_sheet ( type: esriFieldTypeString, alias: plan_sheet, editable: true, nullable: true, length: 255, defaultValue: null, modelName: plan_sheet )
• side ( type: esriFieldTypeString, alias: side, editable: true, nullable: true, length: 255, defaultValue: null, modelName: side , Coded Values: [R: Right] , [L: Left] , [M: Middle] )
• PayItemOrigin ( type: esriFieldTypeInteger, alias: PayItemOrigin, editable: true, nullable: true, defaultValue: null, modelName: PayItemOrigin , Coded Values: [6: ADA] , [7: CIP] , [10: NEW] , ...4 more... )
• PayItemNumber ( type: esriFieldTypeString, alias: PayItemNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PayItemNumber , Coded Values: [10: 10] , [100: 100] , [1001: 1001] , ...121 more... )
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectNumber )
• ProjectStatus ( type: esriFieldTypeString, alias: ProjectStatus, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectStatus )
• ParticipationCodeId ( type: esriFieldTypeInteger, alias: ParticipationCodeId, editable: true, nullable: true, defaultValue: null, modelName: ParticipationCodeId , Coded Values: [12: 99 - NOV] , [1: Default - Sytem Default] , [2: PC1 - COC DPS, Resurfacing] , ...10 more... )
• ParticipationCode ( type: esriFieldTypeString, alias: ParticipationCode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ParticipationCode )
• pay_item_tag ( type: esriFieldTypeSmallInteger, alias: pay_item_tag, editable: true, nullable: true, defaultValue: null, modelName: pay_item_tag , Coded Values: [21: ADA PAVEMENT MARKINGS] , [20: ADA SIGNS] , [25: Adjustments] , ...9 more... )
• ProjectId ( type: esriFieldTypeString, alias: ProjectId, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectId , Coded Values: [374: 374 - 530282-922023 : Resurfacing - 2023 Project 2] , [375: 375 - 530282-999999: Unassigned - ADA] , [376: 376 - 530087-100043: ADA Ramp Projects - CDBG Curb Ramps (2023)] , ...50 more... )
• intersection_id ( type: esriFieldTypeInteger, alias: intersection_id, editable: true, nullable: true, defaultValue: null, modelName: intersection_id , Coded Values: [-1: -1] , [-10: -10] , [101679: 101679] , ...5165 more... )
• use_default_project ( type: esriFieldTypeSmallInteger, alias: use_default_project, editable: true, nullable: true, defaultValue: 1, modelName: use_default_project , Coded Values: [1: Yes] , [0: No] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• structure_size ( type: esriFieldTypeString, alias: structure_size, editable: true, nullable: true, length: 255, defaultValue: null, modelName: structure_size , Coded Values: [12x18: 12x18] , [30x36: 30x36] )
• station ( type: esriFieldTypeString, alias: station, editable: true, nullable: true, length: 20, defaultValue: null, modelName: station )
• attachment ( type: esriFieldTypeBlob, alias: attachment, editable: true, nullable: true, defaultValue: null, modelName: attachment )
• sign_pay_item ( type: esriFieldTypeInteger, alias: sign_pay_item, editable: true, nullable: true, defaultValue: null, modelName: sign_pay_item , Coded Values: [9061: 100111000 EA - MIS-56 - Riser, Street Lighting Circuit] , [9012: 100116900 EA - MIS-500 - Pole, To Be Wired, 2-Wire] , [9071: 1001C10000 LS - MIS-1 - Streetlight Lockout/Tagout] , ...3751 more... )
• sign_group_pay_item ( type: esriFieldTypeInteger, alias: sign_group_pay_item, editable: true, nullable: true, defaultValue: null, modelName: sign_group_pay_item , Coded Values: )
• sign_favorite_pay_item ( type: esriFieldTypeInteger, alias: sign_favorite_pay_item, editable: true, nullable: true, defaultValue: null, modelName: sign_favorite_pay_item , Coded Values: )
• sign_pay_item_origin ( type: esriFieldTypeInteger, alias: sign_pay_item_origin, editable: true, nullable: true, defaultValue: null, modelName: sign_pay_item_origin , Coded Values: [6: ADA] , [7: CIP] , [10: NEW] , ...4 more... )
• sign_pay_item_number ( type: esriFieldTypeString, alias: sign_pay_item_number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sign_pay_item_number , Coded Values: [10: 10] , [100: 100] , [1001: 1001] , ...121 more... )
• sign_pay_item_tag ( type: esriFieldTypeSmallInteger, alias: sign_pay_item_tag, editable: true, nullable: true, defaultValue: null, modelName: sign_pay_item_tag , Coded Values: [21: ADA PAVEMENT MARKINGS] , [20: ADA SIGNS] , [25: Adjustments] , ...9 more... )
• removal_pay_item ( type: esriFieldTypeInteger, alias: removal_pay_item, editable: true, nullable: true, defaultValue: null, modelName: removal_pay_item , Coded Values: [9061: 100111000 EA - MIS-56 - Riser, Street Lighting Circuit] , [9012: 100116900 EA - MIS-500 - Pole, To Be Wired, 2-Wire] , [9071: 1001C10000 LS - MIS-1 - Streetlight Lockout/Tagout] , ...3751 more... )
• removal_group_pay_item ( type: esriFieldTypeInteger, alias: removal_group_pay_item, editable: true, nullable: true, defaultValue: null, modelName: removal_group_pay_item , Coded Values: )
• removal_favorite_pay_item ( type: esriFieldTypeInteger, alias: removal_favorite_pay_item, editable: true, nullable: true, defaultValue: null, modelName: removal_favorite_pay_item , Coded Values: )
• removal_pay_item_origin ( type: esriFieldTypeInteger, alias: removal_pay_item_origin, editable: true, nullable: true, defaultValue: null, modelName: removal_pay_item_origin , Coded Values: [6: ADA] , [7: CIP] , [10: NEW] , ...4 more... )
• removal_pay_item_number ( type: esriFieldTypeString, alias: removal_pay_item_number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: removal_pay_item_number , Coded Values: [10: 10] , [100: 100] , [1001: 1001] , ...121 more... )
• removal_pay_item_tag ( type: esriFieldTypeSmallInteger, alias: removal_pay_item_tag, editable: true, nullable: true, defaultValue: null, modelName: removal_pay_item_tag , Coded Values: [21: ADA PAVEMENT MARKINGS] , [20: ADA SIGNS] , [25: Adjustments] , ...9 more... )
• mount_type ( type: esriFieldTypeSmallInteger, alias: mount_type, editable: true, nullable: true, defaultValue: null, modelName: mount_type , Coded Values: [0: Cantilever] , [1: Signal] , [2: Butterfly] , ...1 more... )
• remove_add ( type: esriFieldTypeInteger, alias: Add or Remove Signs, editable: true, nullable: true, defaultValue: null, modelName: remove_add , Coded Values: [0: Add] , [1: Remove] , [2: Both] )
• work_limit_id ( type: esriFieldTypeInteger, alias: work_limit_id, editable: true, nullable: true, defaultValue: null, modelName: work_limit_id , Coded Values: [10000: 10000] , [10001: 10001] , [10002: 10002] , ...1226 more... )
• primary_association ( type: esriFieldTypeSmallInteger, alias: primary_association, editable: true, nullable: true, defaultValue: null, modelName: primary_association , Coded Values: [0: ADA] , [1: Roadway] )
• structure_label ( type: esriFieldTypeString, alias: Unique Structure Label, editable: true, nullable: true, length: 255, defaultValue: null, modelName: structure_label )
• sign_cy ( type: esriFieldTypeDouble, alias: sign_cy, editable: true, nullable: true, defaultValue: null, modelName: sign_cy )
• sign_sy ( type: esriFieldTypeDouble, alias: sign_sy, editable: true, nullable: true, defaultValue: null, modelName: sign_sy )
• sign_length ( type: esriFieldTypeDouble, alias: sign_length, editable: true, nullable: true, defaultValue: null, modelName: sign_length )
• sign_quantity ( type: esriFieldTypeInteger, alias: sign_quantity, editable: true, nullable: true, defaultValue: null, modelName: sign_quantity )
• remove_sy ( type: esriFieldTypeDouble, alias: remove_sy, editable: true, nullable: true, defaultValue: null, modelName: remove_sy )
• remove_cy ( type: esriFieldTypeDouble, alias: remove_cy, editable: true, nullable: true, defaultValue: null, modelName: remove_cy )
• remove_length ( type: esriFieldTypeDouble, alias: remove_length, editable: true, nullable: true, defaultValue: null, modelName: remove_length )
• remove_quantity ( type: esriFieldTypeInteger, alias: remove_quantity, editable: true, nullable: true, defaultValue: null, modelName: remove_quantity )
• creator ( type: esriFieldTypeString, alias: creator, editable: true, nullable: true, length: 277, defaultValue: null, modelName: creator )
• created ( type: esriFieldTypeDate, alias: created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created )
• editor ( type: esriFieldTypeString, alias: editor, editable: true, nullable: true, length: 277, defaultValue: null, modelName: editor )
• edited ( type: esriFieldTypeDate, alias: edited, editable: true, nullable: true, length: 8, defaultValue: null, modelName: edited )
• sign_added ( type: esriFieldTypeString, alias: sign_added, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sign_added )
• message ( type: esriFieldTypeString, alias: message, editable: true, nullable: true, length: 255, defaultValue: null, modelName: message )
• contingency ( type: esriFieldTypeSmallInteger, alias: contingency, editable: true, nullable: true, defaultValue: 0, modelName: contingency , Coded Values: [1: Yes] , [0: No] )
• LocationId ( type: esriFieldTypeInteger, alias: Location ID, editable: true, nullable: true, defaultValue: null, modelName: LocationId )

Templates:

• Name: Sign Structure
  Description:
  Prototype:
  contingency: 0
  notes: null
  sy: null
  cy: null
  length: null
  quantity: null
  pay_item: null
  group_pay_item: null
  favorite_pay_item: null
  plan_label: null
  plan_sheet: null
  side: null
  PayItemOrigin: null
  PayItemNumber: null
  ProjectNumber: null
  ProjectStatus: null
  ParticipationCodeId: null
  ParticipationCode: null
  pay_item_tag: null
  ProjectId: null
  intersection_id: null
  use_default_project: 1
  LocationId: null
  structure_size: null
  station: null
  attachment: null
  sign_pay_item: null
  sign_group_pay_item: null
  sign_favorite_pay_item: null
  sign_pay_item_origin: null
  sign_pay_item_number: null
  sign_pay_item_tag: null
  removal_pay_item: null
  removal_group_pay_item: null
  removal_favorite_pay_item: null
  removal_pay_item_origin: null
  removal_pay_item_number: null
  removal_pay_item_tag: null
  mount_type: null
  remove_add: null
  work_limit_id: null
  primary_association: null
  structure_label: null
  sign_cy: null
  sign_sy: null
  sign_length: null
  sign_quantity: null
  remove_sy: null
  remove_cy: null
  remove_length: null
  remove_quantity: null
  creator: null
  created: null
  editor: null
  edited: null
  sign_added: null
  message: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• attachment_remove (0) -- Related To: Signs to Remove (9)
• attachment_add (1) -- Related To: Signs to Add (8)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata