View In:   ArcGIS Online Map Viewer

Name: GuardrailLog

Display Field: DIRECTION

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.31280192939E7
YMin: 3630652.2347
XMax: -9027181.4844
YMax: 4159637.3807
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [109, 0, 143, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
• DIRECTION ( type: esriFieldTypeString , alias: Direction , editable: true , nullable: true , length: 3 , Coded Values: [NB: Northbound] , [SB: Southbound] , [WB: Westbound] , ...3 more... )
• ROAD_SIDE ( type: esriFieldTypeString , alias: Side of Road , editable: true , nullable: true , length: 10 , Coded Values: [R: Right] , [L: Left] )
• LOCATION_MP ( type: esriFieldTypeString , alias: Location or Milepost , editable: true , nullable: true , length: 250 )
• RAIL_TYPE ( type: esriFieldTypeString , alias: Rail Type , editable: true , nullable: true , length: 2 , Coded Values: [CB: Cable Barrier] , [TB: T-Beam] , [WB: W-Beam] , ...3 more... )
• ANCHOR_TYPE ( type: esriFieldTypeString , alias: Anchor Type , editable: true , nullable: true , length: 3 , Coded Values: [1: 1] , [12: 12] , [6: 6] , ...3 more... )
• DAMAGE_HEIGHT ( type: esriFieldTypeSmallInteger , alias: Damaged Height , editable: true , nullable: true , Coded Values: [31: 31"] , [27: 27"] )
• REPAIR_HEIGHT ( type: esriFieldTypeSmallInteger , alias: Repair Height , editable: true , nullable: true , Coded Values: [31: 31"] , [27: 27"] )
• STATUS ( type: esriFieldTypeString , alias: Status , editable: true , nullable: true , length: 3 , Coded Values: [F: Functional] , [NF: Non-Functional] , [L1A: Level 1-A] , ...1 more... )
• DAMAGE_LENGTH ( type: esriFieldTypeDouble , alias: Damaged Length , editable: true , nullable: true )
• DATE_CONTRACTOR_NOTIFIED ( type: esriFieldTypeDate , alias: Date Contractor Notified , editable: true , nullable: true , length: 8 )
• REPAIR_STATUS ( type: esriFieldTypeSmallInteger , alias: Repair Status , editable: true , nullable: true , Coded Values: [3: Repaired] , [2: Removed] , [0: Not Assigned to Contractor] , ...3 more... )
• GLOBALID ( type: esriFieldTypeGlobalID , alias: GLOBALID , editable: false , nullable: false , length: 38 )
• REPORTED_FROM ( type: esriFieldTypeSmallInteger , alias: Reported By , editable: true , nullable: true , Coded Values: [1: Arcadis Inspector] , [2: GDOT Staff] , [3: HERO Crash Report] , ...7 more... )
• REPAIR_ISSUES ( type: esriFieldTypeSmallInteger , alias: Repair Issues , editable: true , nullable: true , Coded Values: [1: Utility locates] , [2: Brush removals] , [3: Cannot find damage] , ...8 more... )
• REPAIR_ISSUES_REPORTED ( type: esriFieldTypeDate , alias: Date Repair Issues Reported , editable: true , nullable: true , length: 8 )
• REPAIR_ISSUES_RESOLVED ( type: esriFieldTypeDate , alias: Date Repair Issues Resolved , editable: true , nullable: true , length: 8 )
• INSPECTOR ( type: esriFieldTypeSmallInteger , alias: Inspector , editable: true , nullable: true , Coded Values: [1: Akins Edward] , [2: Baldwin Joe] , [3: Bannister Anthony] , ...54 more... )
• RAMP ( type: esriFieldTypeSmallInteger , alias: Ramp , editable: true , nullable: true , Coded Values: [0: No] , [1: Yes] )
• DAYSTOCOMPLETE ( type: esriFieldTypeSmallInteger , alias: Days to Complete , editable: true , nullable: true )
• QCCOMPLETE ( type: esriFieldTypeSmallInteger , alias: QC Complete , editable: true , nullable: true , Coded Values: [0: No] , [1: Yes] )
• ID ( type: esriFieldTypeString , alias: ID , editable: true , nullable: true , length: 150 )
• INVOICE_DATE ( type: esriFieldTypeDate , alias: Invoice Date , editable: true , nullable: true , length: 8 )
• GENERAL_NOTES ( type: esriFieldTypeString , alias: General Notes , editable: true , nullable: true , length: 1000 )
• REPAIR_ISSUES_NOTES ( type: esriFieldTypeString , alias: Repair Issue Notes , editable: true , nullable: true , length: 1000 )
• CONTRACTOR_NOTES ( type: esriFieldTypeString , alias: Contractor Notes , editable: true , nullable: true , length: 1000 )
• GDOT_DAYS_OUTSTANDING ( type: esriFieldTypeSmallInteger , alias: GDOT Days Outstanding , editable: true , nullable: true )
• FIELD_VERIFIED ( type: esriFieldTypeSmallInteger , alias: Field Verified , editable: true , nullable: true , Coded Values: [0: No] , [1: Yes] )
• FIELD_VERIFIED_NOTES ( type: esriFieldTypeString , alias: Field Verified Notes , editable: true , nullable: true , length: 1000 )
• FIELD_VERIFIED_INSPECTOR ( type: esriFieldTypeSmallInteger , alias: Field Verified Inspector , editable: true , nullable: true , Coded Values: [1: Akins Edward] , [2: Baldwin Joe] , [3: Bannister Anthony] , ...54 more... )
• DATE_FIELD_VERIFIED ( type: esriFieldTypeDate , alias: Date Field Verified , editable: true , nullable: true , length: 8 )
• REPAIRED_BY ( type: esriFieldTypeString , alias: Repaired By , editable: true , nullable: true , length: 10 , Coded Values: [MR: Martin Robbins] , [DBI: DBI] , [SCA: Sweeping Corp of America] , ...14 more... )
• ASSIGNED_TO ( type: esriFieldTypeString , alias: Assigned To , editable: true , nullable: true , length: 10 , Coded Values: [MR: Martin Robbins] , [DBI: DBI] , [SCA: Sweeping Corp of America] , ...14 more... )
• REPAIR_COMPLETED ( type: esriFieldTypeSmallInteger , alias: Repair Completed , editable: true , nullable: true , Coded Values: [0: No] , [1: Yes] )
• CABLE_BARRIER_ID ( type: esriFieldTypeString , alias: Cable Barrier ID , editable: true , nullable: true , length: 50 )
• CONTRACT_ID ( type: esriFieldTypeString , alias: Contract ID , editable: true , nullable: true , length: 50 )
• ROUTE ( type: esriFieldTypeString , alias: Route , editable: true , nullable: true , length: 100 , Coded Values: [1: 1] , [2: 10] , [3: 100] , ...550 more... )
• COUNTY ( type: esriFieldTypeString , alias: County , editable: true , nullable: true , length: 50 , Coded Values: [1: Appling] , [3: Atkinson] , [5: Bacon] , ...156 more... )
• REPAIR_DATE ( type: esriFieldTypeDate , alias: Repair Date , editable: true , nullable: true , length: 8 )
• DISTRICT ( type: esriFieldTypeString , alias: District , editable: true , nullable: true , length: 50 , Coded Values: [1: D1] , [2: D2] , [3: D3] , ...4 more... )
• LOCATION_LINK ( type: esriFieldTypeString , alias: Location Link , editable: true , nullable: true , length: 250 )
• CONTRACT_NUMBER ( type: esriFieldTypeString , alias: Contract Number , editable: true , nullable: true , length: 150 )
• LATITUDE ( type: esriFieldTypeDouble , alias: Latitude , editable: true , nullable: true )
• LONGITUDE ( type: esriFieldTypeDouble , alias: Longitude , editable: true , nullable: true )
• LAST_UPDATED_DATE ( type: esriFieldTypeDate , alias: Last Updated Date , editable: false , nullable: true , length: 8 )
• LAST_UPDATED_BY ( type: esriFieldTypeString , alias: Last Updated By , editable: false , nullable: true , length: 150 )
• CREATED_DATE ( type: esriFieldTypeDate , alias: Created Date , editable: false , nullable: true , length: 8 )
• CREATED_BY ( type: esriFieldTypeString , alias: Created By , editable: false , nullable: true , length: 150 )
• PHOTO_LINK ( type: esriFieldTypeString , alias: Photo Link , editable: true , nullable: true , length: 500 )
• FIELD_VERIFIED_LENGTH ( type: esriFieldTypeDouble , alias: Field Verified Length , editable: true , nullable: true )
• FIELD_VERIFIED_POSTS ( type: esriFieldTypeDouble , alias: Field Verified Posts , editable: true , nullable: true )
• APPROVED ( type: esriFieldTypeSmallInteger , alias: Approved , editable: true , nullable: true , Coded Values: [0: No] , [1: Yes] )
• APPROVED_NOTES ( type: esriFieldTypeString , alias: Approved Notes , editable: true , nullable: true , length: 255 )
• APPROVED_DATE ( type: esriFieldTypeDate , alias: Approved Date , editable: true , nullable: true , length: 8 )
• REASSIGNED_DATE ( type: esriFieldTypeDate , alias: Reassigned Date , editable: true , nullable: true , length: 8 )
• SUBMIT_DATE ( type: esriFieldTypeDate , alias: Submit Date , editable: true , nullable: true , length: 8 )
• CREATED_BY_FN ( type: esriFieldTypeString , alias: CREATED_BY_FN , editable: true , nullable: true , length: 100 )
• FIELDINSPECTOR ( type: esriFieldTypeInteger , alias: FIELDINSPECTOR , editable: true , nullable: true )
• FIELD_VERIFIED_INSPECTOR_ALL ( type: esriFieldTypeInteger , alias: FIELD_VERIFIED_INSPECTOR_ALL , editable: true , nullable: true )
• APPROVED_NOTES_2 ( type: esriFieldTypeString , alias: APPROVED_NOTES_2 , editable: true , nullable: true , length: 1073741822 )
• BASE_COST ( type: esriFieldTypeDouble , alias: Base Cost , editable: true , nullable: true )
• LOCATION_DOLLAR_TOTAL ( type: esriFieldTypeDouble , alias: Location Dollar Total , editable: true , nullable: true )
• END_TREATMENT_ID ( type: esriFieldTypeString , alias: END_TREATMENT_ID , editable: true , nullable: true , length: 50 )
• RAIL_ID ( type: esriFieldTypeString , alias: RAIL_ID , editable: true , nullable: true , length: 50 )

Templates:

• Name: GuardrailLog
  Description:
  Prototype:
  RAIL_TYPE: null
  DATE_CONTRACTOR_NOTIFIED: null
  INSPECTOR: null
  DAYSTOCOMPLETE: null
  GDOT_DAYS_OUTSTANDING: null
  REPAIRED_BY: null
  ASSIGNED_TO: NA
  RAIL_ID: null
  DIRECTION: null
  ROAD_SIDE: null
  LOCATION_MP: null
  ANCHOR_TYPE: NA
  DAMAGE_HEIGHT: null
  REPAIR_HEIGHT: null
  STATUS: null
  DAMAGE_LENGTH: null
  REPAIR_STATUS: 0
  END_TREATMENT_ID: null
  REPORTED_FROM: null
  REPAIR_ISSUES: null
  REPAIR_ISSUES_REPORTED: null
  REPAIR_ISSUES_RESOLVED: null
  RAMP: 0
  QCCOMPLETE: 0
  ID: null
  INVOICE_DATE: null
  GENERAL_NOTES: null
  REPAIR_ISSUES_NOTES: null
  CONTRACTOR_NOTES: null
  FIELD_VERIFIED: 0
  FIELD_VERIFIED_NOTES: null
  FIELD_VERIFIED_INSPECTOR: null
  DATE_FIELD_VERIFIED: null
  REPAIR_COMPLETED: 0
  CABLE_BARRIER_ID: null
  CONTRACT_ID: null
  ROUTE: null
  COUNTY: null
  REPAIR_DATE: null
  DISTRICT: null
  LOCATION_LINK: null
  CONTRACT_NUMBER: null
  LATITUDE: null
  LONGITUDE: null
  LOCATION_DOLLAR_TOTAL: null
  BASE_COST: null
  APPROVED_NOTES_2: null
  FIELD_VERIFIED_INSPECTOR_ALL: null
  PHOTO_LINK: null
  FIELD_VERIFIED_LENGTH: null
  FIELD_VERIFIED_POSTS: null
  APPROVED: null
  APPROVED_NOTES: null
  APPROVED_DATE: null
  REASSIGNED_DATE: null
  SUBMIT_DATE: null
  CREATED_BY_FN: null
  FIELDINSPECTOR: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

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

Edit Fields Info:

• Creation Date Field: CREATED_DATE
• Creator Field: CREATED_BY
• Edit Date Field: LAST_UPDATED_DATE
• Editor Field: LAST_UPDATED_BY

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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