View In:   ArcGIS Online Map Viewer

Name: Posts

Display Field: Post

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;font-size:12pt"><DIV><DIV><P><SPAN>The posts are drawn from DOT's traffic sign inventory database which is used by the Iowa DOT in managing its inventory of sign post installations in the State of Iowa. The database keeps track of the description, location, installation and inspection dates for DOT traffic posts that are predominately on the primary road system and/or posts that are owned or maintained by the Iowa DOT. This data has been collected mainly through in field data collection efforts of field maintenance staff utilizing either the Collector application or the older laptop based sign inventory program. This data is updated nearly daily by field maintenance staff. The signs and posts datasets need to be used in combination.</SPAN></P></DIV></DIV></DIV>

Service Item Id: 5b1f2e2e9fce4473b20cc256cad7a006

Copyright Text: Iowa Department of Transportation | Office of Traffic & Safety

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 1155581.108577

Max Scale: 400

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: -2.003750706717919E7
YMin: -1.0587092044399805E7
XMax: 2.00375070671792E7
YMax: 3.024097195838655E7
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Post
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
• Value: 2
  Label: 002-Structure
  Description: N/A
  Symbol:
  
• Value: 3
  Label: 003-Truss/Cantilever
  Description: N/A
  Symbol:
  
• Value: 5
  Label: 005-Utility/Signal Pole
  Description: N/A
  Symbol:
  
• Value: 100
  Label: 100-I-Beam Steel Breakaway (W6x9)
  Description: N/A
  Symbol:
  
• Value: 101
  Label: 101-I-Beam Steel Breakaway (W6x12)
  Description: N/A
  Symbol:
  
• Value: 102
  Label: 102-I-Beam Steel Breakaway (W6x15)
  Description: N/A
  Symbol:
  
• Value: 103
  Label: 103-I-Beam Steel Breakaway (W8x18)
  Description: N/A
  Symbol:
  
• Value: 104
  Label: 104-I-Beam Steel Breakaway (W8x21)
  Description: N/A
  Symbol:
  
• Value: 105
  Label: 105-I-Beam Steel Breakaway (W10x22)
  Description: N/A
  Symbol:
  
• Value: 106
  Label: 106-I-Beam Steel Breakaway (W10x26)
  Description: N/A
  Symbol:
  
• Value: 107
  Label: 107-I-Beam Steel Breakaway (W12x26)
  Description: N/A
  Symbol:
  
• Value: 200
  Label: 200-Perforated Square Steel Tubing (PSST) (Telespar) (1.50"x12')
  Description: N/A
  Symbol:
  
• Value: 201
  Label: 201-Perforated Square Steel Tubing (PSST) (Telespar) (1.75"x12')
  Description: N/A
  Symbol:
  
• Value: 202
  Label: 202-Perforated Square Steel Tubing (PSST) (Telespar) (2.00"x12')
  Description: N/A
  Symbol:
  
• Value: 203
  Label: 203-Perforated Square Steel Tubing (PSST) (Telespar) (2.25"x12')
  Description: N/A
  Symbol:
  
• Value: 204
  Label: 204-Perforated Square Steel Tubing (PSST) (Telespar) (2.50"x12')
  Description: N/A
  Symbol:
  
• Value: 400
  Label: 400-U-Shaped Delineator - Type 1 (2lbs/ft-galvanized)
  Description: N/A
  Symbol:
  
• Value: 401
  Label: 401-U-Shaped Delineator - Type 2 (1.12lbs/ft-galvanized)
  Description: N/A
  Symbol:
  
• Value: 402
  Label: 402-U-Shaped Delineator - Type 3 (1.12lbs/ft-painted)
  Description: N/A
  Symbol:
  
• Value: 403
  Label: 403-U-Shaped Delineator - Type 1A
  Description: N/A
  Symbol:
  
• Value: 600
  Label: 600-Wood Posts (4"x4")
  Description: N/A
  Symbol:
  
• Value: 601
  Label: 601-Wood Posts (4"x6")
  Description: N/A
  Symbol:
  
• Value: 700
  Label: 700-Rectangular Square Steel Tube - MASSH-400 (4"x4")
  Description: N/A
  Symbol:
  
• Value: 701
  Label: 701-Rectangular Square Steel Tube (4"x6")
  Description: N/A
  Symbol:
  
• Value: 0
  Label: 000-Unknown
  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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Post

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ID ( type: esriFieldTypeString, alias: ID (Sign Inventory), editable: true, nullable: true, length: 32, defaultValue: null, modelName: ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• REL_GlobalID ( type: esriFieldTypeGUID, alias: REL_GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: REL_GlobalID )
• Post ( type: esriFieldTypeInteger, alias: Post, editable: true, nullable: true, defaultValue: 202, modelName: Post , Coded Values: [0: 000-Unknown] , [2: 002-Structure] , [3: 003-Truss/Cantilever] , ...21 more... )
• NumberPosts ( type: esriFieldTypeInteger, alias: Number of posts, editable: true, nullable: true, defaultValue: 1, modelName: NumberPosts )
• PostLength1 ( type: esriFieldTypeInteger, alias: Length of post 1 (ft), editable: true, nullable: true, defaultValue: null, modelName: PostLength1 )
• PostLength2 ( type: esriFieldTypeInteger, alias: Length of post 2 (if applicable - ft), editable: true, nullable: true, defaultValue: null, modelName: PostLength2 )
• PostLength3 ( type: esriFieldTypeInteger, alias: Length of post 3 (if applicable- ft), editable: true, nullable: true, defaultValue: null, modelName: PostLength3 )
• DOTDistrict ( type: esriFieldTypeInteger, alias: DOT District, editable: false, nullable: true, defaultValue: null, modelName: DOTDistrict , Coded Values: [1: 1-District 1 (Central)] , [2: 2-District 2 (Northeast)] , [3: 3-District 3 (Northwest)] , ...3 more... )
• SideOfRoad ( type: esriFieldTypeInteger, alias: Side of road, editable: true, nullable: true, defaultValue: 4, modelName: SideOfRoad , Coded Values: [0: 0-Not indicated] , [1: 1-Left] , [2: 2-Median] , ...2 more... )
• PostPrimaryUse ( type: esriFieldTypeInteger, alias: Primary use of post, editable: true, nullable: true, defaultValue: 1, modelName: PostPrimaryUse , Coded Values: [1: 1-Sign] , [2: 2-Signal] , [3: 3-Streetlight] , ...3 more... )
• JointUsage ( type: esriFieldTypeInteger, alias: Is post being used for multiple functions, editable: true, nullable: true, defaultValue: 0, modelName: JointUsage , Coded Values: [0: 0-No] , [1: 1-Yes] )
• OwnedBy ( type: esriFieldTypeInteger, alias: Post owner, editable: true, nullable: true, defaultValue: 1, modelName: OwnedBy , Coded Values: [1: 1-Iowa DOT] , [2: 2-Other public agency] , [3: 3-Private] )
• ManagedBy ( type: esriFieldTypeInteger, alias: Post managed by, editable: true, nullable: true, defaultValue: 1, modelName: ManagedBy , Coded Values: [1: 1-Iowa DOT] , [2: 2-Other public agency] , [3: 3-Private] )
• OnOrNearRampSideroadLocation ( type: esriFieldTypeInteger, alias: Is location on or near ramp or sideroad?, editable: true, nullable: true, defaultValue: 0, modelName: OnOrNearRampSideroadLocation , Coded Values: [0: 0-No] , [1: 1-Yes] )
• GarageCostCenter ( type: esriFieldTypeInteger, alias: Cost Center / Garage, editable: true, nullable: true, defaultValue: null, modelName: GarageCostCenter , Coded Values: [554602: 554602-Adair Garage] , [553802: 553802-Akron Garage] , [555668: 555668-Albia Garage] , ...106 more... )
• InstallationDate ( type: esriFieldTypeDate, alias: Installation date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• PostBaseType ( type: esriFieldTypeInteger, alias: Post base type, editable: true, nullable: true, defaultValue: 0, modelName: PostBaseType , Coded Values: [0: 0-None] , [1: 1-Slip base] , [2: 2-Soil anchor] , ...1 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• RouteID ( type: esriFieldTypeString, alias: Route, editable: true, nullable: true, length: 15, defaultValue: null, modelName: RouteID , Coded Values: [S001910029N: I 29 N] , [S001910029S: I 29 S] , [S001910035N: I 35 N] , ...269 more... )
• Measure ( type: esriFieldTypeDouble, alias: Measure, editable: true, nullable: true, defaultValue: null, modelName: Measure )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: false, nullable: true, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: false, nullable: true, defaultValue: null, modelName: Longitude )
• SignTypical ( type: esriFieldTypeInteger, alias: Signing typical, editable: true, nullable: true, defaultValue: 0, modelName: SignTypical , Coded Values: [0: 000-None] , [1: 001-TAS-801 - Primary Highway Intersections] , [2: 002-TAS-802 - Intersection of Primary and Secondary Road with Destination Signs] , ...34 more... )
• Milepost ( type: esriFieldTypeString, alias: Milepost, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Milepost )
• MilepostOffset ( type: esriFieldTypeDouble, alias: Milepost offset, editable: true, nullable: true, defaultValue: null, modelName: MilepostOffset )
• NumberSignsOnPost ( type: esriFieldTypeInteger, alias: Number of signs (on post), editable: true, nullable: true, defaultValue: 1, modelName: NumberSignsOnPost )
• BridgeID ( type: esriFieldTypeString, alias: BridgeID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BridgeID )
• Zone ( type: esriFieldTypeSmallInteger, alias: Zone, editable: true, nullable: true, defaultValue: null, modelName: Zone , Range: [1, 36] )

Types:

ID: 2
Name: 002-Structure
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 002-Structure
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 2
  Measure: null
  poststatus: 1
  SideOfRoad: 3
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: 003-Truss/Cantilever
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 003-Truss/Cantilever
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 3
  Measure: null
  poststatus: 1
  SideOfRoad: 3
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: 005-Utility/Signal Pole
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 005-Utility/Signal Pole
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 5
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 100
Name: 100-I-Beam Steel Breakaway (W6x9)
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 100-I-Beam Steel Breakaway (W6x9)
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 100
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 101
Name: 101-I-Beam Steel Breakaway (W6x12)
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 101-I-Beam Steel Breakaway (W6x12)
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 101
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 102
Name: 102-I-Beam Steel Breakaway (W6x15)
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 102-I-Beam Steel Breakaway (W6x15)
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 102
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 103
Name: 103-I-Beam Steel Breakaway (W8x18)
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 103-I-Beam Steel Breakaway (W8x18)
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 103
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 104
Name: 104-I-Beam Steel Breakaway (W8x21)
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 104-I-Beam Steel Breakaway (W8x21)
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 104
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 105
Name: 105-I-Beam Steel Breakaway (W10x22)
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 105-I-Beam Steel Breakaway (W10x22)
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 105
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 106
Name: 106-I-Beam Steel Breakaway (W10x26)
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 106-I-Beam Steel Breakaway (W10x26)
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 106
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 107
Name: 107-I-Beam Steel Breakaway (W12x26)
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 107-I-Beam Steel Breakaway (W12x26)
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 107
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 200
Name: 200-Perforated Square Steel Tubing (PSST) (Telespar) (1.50"x12')
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 200-Perforated Square Steel Tubing (PSST) (Telespar) (1.50"x12')
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 200
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 201
Name: 201-Perforated Square Steel Tubing (PSST) (Telespar) (1.75"x12')
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 201-Perforated Square Steel Tubing (PSST) (Telespar) (1.75"x12')
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 201
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 202
Name: 202-Perforated Square Steel Tubing (PSST) (Telespar) (2.00"x12')
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 202-Perforated Square Steel Tubing (PSST) (Telespar) (2.00"x12')
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 202
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 203
Name: 203-Perforated Square Steel Tubing (PSST) (Telespar) (2.25"x12')
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 203-Perforated Square Steel Tubing (PSST) (Telespar) (2.25"x12')
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 203
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 204
Name: 204-Perforated Square Steel Tubing (PSST) (Telespar) (2.50"x12')
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 204-Perforated Square Steel Tubing (PSST) (Telespar) (2.50"x12')
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 204
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 400
Name: 400-U-Shaped Delineator - Type 1 (2lbs/ft-galvanized)
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 400-U-Shaped Delineator - Type 1 (2lbs/ft-galvanized)
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 400
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 401
Name: 401-U-Shaped Delineator - Type 2 (1.12lbs/ft-galvanized)
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 401-U-Shaped Delineator - Type 2 (1.12lbs/ft-galvanized)
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 401
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 402
Name: 402-U-Shaped Delineator - Type 3 (1.12lbs/ft-painted)
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 402-U-Shaped Delineator - Type 3 (1.12lbs/ft-painted)
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 402
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 403
Name: 403-U-Shaped Delineator - Type 1A
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 403-U-Shaped Delineator - Type 1A
  Description:
  Prototype:
  BridgeID: null
  NumberSignsOnPost: null
  Zone: null
  ID: null
  MilepostOffset: null
  Milepost: null
  SignTypical: null
  RouteID: null
  REL_GlobalID: null
  Post: 403
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  Measure: null
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  ManagedBy: 1
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  InstallationDate: null
  PostBaseType: 0
  Comments: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 600
Name: 600-Wood Posts (4"x4")
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 600-Wood Posts (4"x4")
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 600
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 601
Name: 601-Wood Posts (4"x6")
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 601-Wood Posts (4"x6")
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 601
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 700
Name: 700-Rectangular Square Steel Tube - MASSH-400 (4"x4")
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 700-Rectangular Square Steel Tube - MASSH-400 (4"x4")
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 700
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 701
Name: 701-Rectangular Square Steel Tube (4"x6")
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 701-Rectangular Square Steel Tube (4"x6")
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 701
  Measure: null
  poststatus: 1
  SideOfRoad: 4
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 0
Name: 000-Unknown
Domains:
• DOTDistrict:
  Inherited
• SideOfRoad:
  Inherited
• PostPrimaryUse:
  Inherited
• JointUsage:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• OnOrNearRampSideroadLocation:
  Inherited
• GarageCostCenter:
  Inherited
• PostBaseType:
  Inherited
• RouteID:
  Inherited
• SignTypical:
  Inherited
Templates:
• Name: 000-Unknown
  Description:
  Prototype:
  REL_GlobalID: null
  Post: 0
  Measure: null
  poststatus: 1
  SideOfRoad: 0
  PostPrimaryUse: 1
  JointUsage: 0
  OwnedBy: 1
  postrating: 1
  ManagedBy: 1
  InstallationDate: null
  Comments: null
  MilepostOffset: null
  BridgeID: null
  Zone: null
  ID: null
  NumberSignsOnPost: 1
  Milepost: null
  SignTypical: 0
  RouteID: null
  NumberPosts: 1
  PostLength1: null
  PostLength2: null
  PostLength3: null
  OnOrNearRampSideroadLocation: 0
  GarageCostCenter: null
  PostBaseType: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• Inspection (0) -- Related To: PostsInspection (2)

Capabilities: Query,Extract

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: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata