Name: Street Signs

Display Field: Project

Type: Table

Geometry Type: N/A

Description: The street signs are related to the street post. This table is used for creating work orders in Cityworks.

Service Item Id: d206e06458574946b1801aa370dbee58

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Project ( type: esriFieldTypeString, alias: Project, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Project )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Description , Coded Values: [2 Way Traffic: 2 Way Traffic] , [20 Minute Limit: 20 Minute Limit] , [2hr Consecutive Parking: 2hr Consecutive Parking] , ...137 more... )
• MUTCD_TYPE ( type: esriFieldTypeString, alias: MUTCD_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MUTCD_TYPE )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Source , Coded Values: [GPS: GPS] , [Electronic Asbuilts: Electronic Asbuilts] , [Cyvl AI: Cyvl AI] )
• Install_Date ( type: esriFieldTypeDate, alias: Install_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Install_Date )
• Sign_size ( type: esriFieldTypeString, alias: Sign_size, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Sign_size )
• Sign_shape ( type: esriFieldTypeString, alias: Sign_shape, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Sign_shape , Coded Values: [Rectangular: Rectangular] , [Diamond: Diamond] , [Circular: Circular] , ...4 more... )
• Sign_condition ( type: esriFieldTypeString, alias: Sign_condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Sign_condition , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• Legend_Color ( type: esriFieldTypeString, alias: Legend_Color, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Legend_Color , Coded Values: [Red: Red] , [White: White] , [Black: Black] , ...4 more... )
• Background ( type: esriFieldTypeString, alias: Background, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Background , Coded Values: [Blue: Blue] , [Brown: Brown] , [FYG: FYG] , ...4 more... )
• Post_style ( type: esriFieldTypeString, alias: Post_style, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Post_style , Coded Values: [Green Square: Green Square] , [Round: Round] , [Square: Square] , ...5 more... )
• Post_Condition ( type: esriFieldTypeString, alias: Post_Condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Post_Condition , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AssetID )
• LocationID ( type: esriFieldTypeString, alias: LocationID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LocationID )
• Series ( type: esriFieldTypeString, alias: Series, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Series , Coded Values: [Regulatory: Regulatory] , [Warning: Warning] , [Construction: Construction] , ...10 more... )
• Speed ( type: esriFieldTypeSmallInteger, alias: Speed, editable: true, nullable: true, defaultValue: null, modelName: Speed )
• Date_Mapped ( type: esriFieldTypeDate, alias: Date_Mapped, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_Mapped )
• Route ( type: esriFieldTypeString, alias: Route, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Route )
• Dir_Travel ( type: esriFieldTypeString, alias: Dir_Travel, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Dir_Travel , Coded Values: [NB: NB] , [SB: SB] , [WB: WB] , ...1 more... )
• Side_Rd ( type: esriFieldTypeString, alias: Side_Rd, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Side_Rd , Coded Values: [Left: Left] , [Right: Right] , [Center: Center] )
• Lat_Offset ( type: esriFieldTypeSmallInteger, alias: Lat_Offset, editable: true, nullable: true, defaultValue: null, modelName: Lat_Offset )
• Height ( type: esriFieldTypeSmallInteger, alias: Height, editable: true, nullable: true, defaultValue: null, modelName: Height )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Comments )
• Hyperlink ( type: esriFieldTypeString, alias: Hyperlink, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Hyperlink )
• RelateID ( type: esriFieldTypeString, alias: RelateID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RelateID )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyDate )
• Field_ID ( type: esriFieldTypeSmallInteger, alias: Field_ID, editable: true, nullable: true, defaultValue: null, modelName: Field_ID )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Owner )

Templates:

• Name: Street Signs
  Description:
  Prototype:
  Field_ID: null
  Owner: null
  Project: null
  Description: null
  MUTCD_TYPE: null
  Source: null
  Install_Date: null
  Sign_size: null
  Sign_shape: null
  Sign_condition: null
  Legend_Color: null
  Background: null
  Post_style: null
  Post_Condition: null
  AssetID: null
  LocationID: null
  Series: null
  Speed: null
  Date_Mapped: null
  Route: null
  Dir_Travel: null
  Side_Rd: null
  Lat_Offset: null
  Height: null
  Comments: null
  Hyperlink: null
  RelateID: null
  WarrantyDate: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• post (0) -- Related To: Sign Post (9)

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

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