View In:   ArcGIS Online Map Viewer

Parent Layer: Transportation Dataset

Name: Sign Post

Display Field: OnStreetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The sign post feature displays signs. All signs are captured in a table and have a one to many relationship with the sign post that displays them. The relationship used the Facility ID to maintain the relationship. Sign Posts can be displayed in Cityworks and the Sign table can be populated and maintained in Cityworks. The sign post feature and the sign table were both created to aid in the inspection process. The FHWA established a compliance rule regarding sign reflectivity that must be met by 1/22/2015 for all traffic signs, including: white on red and black on white regulatory signs (such as STOP signs and Speed Limit signs); black on yellow warning signs; and post-mounted white on green guide signs (except street name signs). Compliance by1/22/2018 for all overhead guide signs and all street name signs.

Copyright Text: Lebanon's Enterprise GIS (LEGIS), Lebanon's Engineering Department, and Lebanon's Public Works Department

Default Visibility: false

MaxRecordCount: 10000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 72223.819286

Max Scale: 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: 1471480.5362499803
YMin: 504351.3180000037
XMax: 1495840.9944999814
YMax: 538797.4669999927
Spatial Reference: 102723  (3735)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Subtype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: Other Values
UniqueValueInfos:
• Value: 16
  Label: Bricks
  Description: N/A
  Symbol:
  
• Value: 15
  Label: Concrete
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Decorative Pole
  Description: N/A
  Symbol:
  
• Value: 7
  Label: Iron Beam
  Description: N/A
  Symbol:
  
• Value: 10
  Label: Mast Arm
  Description: N/A
  Symbol:
  
• Value: 11
  Label: Overpass
  Description: N/A
  Symbol:
  
• Value: 12
  Label: Parking Meter
  Description: N/A
  Symbol:
  
• Value: 6
  Label: Perforated Square
  Description: N/A
  Symbol:
  
• Value: 5
  Label: Round Steel
  Description: N/A
  Symbol:
  
• Value: 8
  Label: Signal Pole
  Description: N/A
  Symbol:
  
• Value: 9
  Label: Signal Wire
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Streetlight
  Description: N/A
  Symbol:
  
• Value: 1
  Label: U-Channel
  Description: N/A
  Symbol:
  
• Value: 3
  Label: Utility Pole
  Description: N/A
  Symbol:
  
• Value: 13
  Label: Wall
  Description: N/A
  Symbol:
  
• Value: 14
  Label: Wooden Post
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Subtype

Fields:

• Subtype ( type: esriFieldTypeInteger, alias: Post Type, editable: true, nullable: true, defaultValue: 1, modelName: Subtype )
• InspArea ( type: esriFieldTypeString, alias: Inspection Area, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InspArea , Coded Values: [NE: NE] , [SE: SE] , [SW: SW] , ...5 more... )
• OnStreetName ( type: esriFieldTypeString, alias: On Street Name, editable: true, nullable: true, length: 25, defaultValue: null, modelName: OnStreetName , Coded Values: [AFFIRMED: AFFIRMED CT] , [ALGONQUIN: ALGONQUIN DR] , [APPLEBLOSSOM: APPLE BLOSSOM CT] , ...340 more... )
• PCond ( type: esriFieldTypeString, alias: Post Condition, editable: true, nullable: true, length: 25, defaultValue: GOOD, modelName: PCond , Coded Values: [FAIR: Fair (minor damage)] , [POOR: Poor (major damage schedule replacement)] , [VPOOR: Very Poor (replace post immediately)] , ...3 more... )
• SHgt ( type: esriFieldTypeString, alias: Sign Hgt meets OMUTCD, editable: true, nullable: true, length: 25, defaultValue: YES, modelName: SHgt , Coded Values: [YES: Yes (meets standard)] , [2LOW: Too Low (sign ht too low per OMUTCD)] , [2CLOSE: Too Close (post too close to EOP per OMUTCD)] , ...2 more... )
• Breakaway ( type: esriFieldTypeString, alias: Breakaway (YN), editable: true, nullable: true, length: 25, defaultValue: N, modelName: Breakaway , Coded Values: [Y: Yes] , [N: No] )
• Beacon ( type: esriFieldTypeString, alias: Warning Beacon (YN), editable: true, nullable: true, length: 25, defaultValue: N, modelName: Beacon , Coded Values: [Y: Yes] , [N: No] )
• SonPost ( type: esriFieldTypeString, alias: Signs on Post, editable: true, nullable: true, length: 25, defaultValue: 1, modelName: SonPost )
• Comments ( type: esriFieldTypeString, alias: Additional Comments, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Comments )
• Location ( type: esriFieldTypeString, alias: Descriptive Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• POINT_X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: POINT_Y )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ET_EDITOR ( type: esriFieldTypeString, alias: ET_EDITOR, editable: false, nullable: true, length: 255, defaultValue: null, modelName: ET_EDITOR )
• ET_EDITED ( type: esriFieldTypeDate, alias: ET_EDITED, editable: false, nullable: true, length: 8, defaultValue: null, modelName: ET_EDITED )
• DWG_NO ( type: esriFieldTypeString, alias: Drawing No, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DWG_NO )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )

Types:

ID: 16
Name: Bricks
Domains:
• InspArea:
  Inherited
• OnStreetName:
  Inherited
• PCond:
  Inherited
• SHgt:
  Inherited
• Breakaway:
  Inherited
• Beacon:
  Inherited
Templates:
• Name: Bricks
  Description:
  Prototype:
  SHgt: YES
  Subtype: 16
  PCond: GOOD
  SonPost: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 15
Name: Concrete
Domains:
• InspArea:
  Inherited
• OnStreetName:
  Inherited
• PCond:
  Inherited
• SHgt:
  Inherited
• Breakaway:
  Inherited
• Beacon:
  Inherited
Templates:
• Name: Concrete
  Description:
  Prototype:
  SHgt: YES
  Subtype: 15
  PCond: GOOD
  SonPost: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Decorative Pole
Domains:
• InspArea:
  Inherited
• OnStreetName:
  Inherited
• PCond:
  Inherited
• SHgt:
  Inherited
• Breakaway:
  Inherited
• Beacon:
  Inherited
Templates:
• Name: Decorative Pole
  Description:
  Prototype:
  SHgt: YES
  Subtype: 2
  PCond: GOOD
  SonPost: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 7
Name: Iron Beam
Domains:
• InspArea:
  Inherited
• OnStreetName:
  Inherited
• PCond:
  Inherited
• SHgt:
  Inherited
• Breakaway:
  Inherited
• Beacon:
  Inherited
Templates:
• Name: Iron Beam
  Description:
  Prototype:
  SHgt: YES
  Subtype: 7
  PCond: GOOD
  SonPost: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 10
Name: Mast Arm
Domains:
• InspArea:
  Inherited
• OnStreetName:
  Inherited
• PCond:
  Inherited
• SHgt:
  Inherited
• Breakaway:
  Inherited
• Beacon:
  Inherited
Templates:
• Name: Mast Arm
  Description:
  Prototype:
  SHgt: YES
  Subtype: 10
  PCond: GOOD
  SonPost: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 11
Name: Overpass
Domains:
• InspArea:
  Inherited
• OnStreetName:
  Inherited
• PCond:
  Inherited
• SHgt:
  Inherited
• Breakaway:
  Inherited
• Beacon:
  Inherited
Templates:
• Name: Overpass
  Description:
  Prototype:
  SHgt: YES
  Subtype: 11
  PCond: GOOD
  SonPost: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 12
Name: Parking Meter
Domains:
• InspArea:
  Inherited
• OnStreetName:
  Inherited
• PCond:
  Inherited
• SHgt:
  Inherited
• Breakaway:
  Inherited
• Beacon:
  Inherited
Templates:
• Name: Parking Meter
  Description:
  Prototype:
  SHgt: YES
  Subtype: 12
  PCond: GOOD
  SonPost: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 6
Name: Perforated Square
Domains:
• InspArea:
  Inherited
• OnStreetName:
  Inherited
• PCond:
  Inherited
• SHgt:
  Inherited
• Breakaway:
  Inherited
• Beacon:
  Inherited
Templates:
• Name: Perforated Square
  Description:
  Prototype:
  SHgt: YES
  Subtype: 6
  PCond: GOOD
  SonPost: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: Round Steel
Domains:
• InspArea:
  Inherited
• OnStreetName:
  Inherited
• PCond:
  Inherited
• SHgt:
  Inherited
• Breakaway:
  Inherited
• Beacon:
  Inherited
Templates:
• Name: Round Steel
  Description:
  Prototype:
  SHgt: YES
  Subtype: 5
  PCond: GOOD
  SonPost: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 8
Name: Signal Pole
Domains:
• InspArea:
  Inherited
• OnStreetName:
  Inherited
• PCond:
  Inherited
• SHgt:
  Inherited
• Breakaway:
  Inherited
• Beacon:
  Inherited
Templates:
• Name: Signal Pole
  Description:
  Prototype:
  SHgt: YES
  Subtype: 8
  PCond: GOOD
  SonPost: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 9
Name: Signal Wire
Domains:
• InspArea:
  Inherited
• OnStreetName:
  Inherited
• PCond:
  Inherited
• SHgt:
  Inherited
• Breakaway:
  Inherited
• Beacon:
  Inherited
Templates:
• Name: Signal Wire
  Description:
  Prototype:
  SHgt: YES
  Subtype: 9
  PCond: GOOD
  SonPost: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Streetlight
Domains:
• InspArea:
  Inherited
• OnStreetName:
  Inherited
• PCond:
  Inherited
• SHgt:
  Inherited
• Breakaway:
  Inherited
• Beacon:
  Inherited
Templates:
• Name: Streetlight
  Description:
  Prototype:
  SHgt: YES
  Subtype: 4
  PCond: GOOD
  SonPost: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: U-Channel
Domains:
• InspArea:
  Inherited
• OnStreetName:
  Inherited
• PCond:
  Inherited
• SHgt:
  Inherited
• Breakaway:
  Inherited
• Beacon:
  Inherited
Templates:
• Name: U-Channel
  Description:
  Prototype:
  SHgt: YES
  Subtype: 1
  PCond: GOOD
  SonPost: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Utility Pole
Domains:
• InspArea:
  Inherited
• OnStreetName:
  Inherited
• PCond:
  Inherited
• SHgt:
  Inherited
• Breakaway:
  Inherited
• Beacon:
  Inherited
Templates:
• Name: Utility Pole
  Description:
  Prototype:
  SHgt: YES
  Subtype: 3
  PCond: GOOD
  SonPost: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 13
Name: Wall
Domains:
• InspArea:
  Inherited
• OnStreetName:
  Inherited
• PCond:
  Inherited
• SHgt:
  Inherited
• Breakaway:
  Inherited
• Beacon:
  Inherited
Templates:
• Name: Wall
  Description:
  Prototype:
  SHgt: YES
  Subtype: 13
  PCond: GOOD
  SonPost: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 14
Name: Wooden Post
Domains:
• InspArea:
  Inherited
• OnStreetName:
  Inherited
• PCond:
  Inherited
• SHgt:
  Inherited
• Breakaway:
  Inherited
• Beacon:
  Inherited
Templates:
• Name: Wooden Post
  Description:
  Prototype:
  SHgt: YES
  Subtype: 14
  PCond: GOOD
  SonPost: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• GIS.GISADMIN.rSign (0) -- Related To: GIS.GISADMIN.rSign (79)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: ET_CREATED
• Creator Field: ET_CREATOR
• Edit Date Field: ET_EDITED
• Editor Field: ET_EDITOR

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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