View In:   ArcGIS Online Map Viewer

Name: Pavement Maintenance

Display Field: streetname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Centerline file with potential address ranges and begin and end log points. A cooperative agreement among local agencies within Franklin County to maintain one road centerline file. The file contains a 7 mile buffer outside of Franklin in order to provide complete coverage to cities that extend outside of the county boundary. The Franklin County portion of the file is part of the ODOT/OGRIP statewide LBRS program and will eventually be incorporated into their system.

Copyright Text:

Default Visibility: true

MaxRecordCount: 5000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: -83.19951314299999
YMin: 40.06575629900004
XMax: -83.08971376699998
YMax: 40.16315357000008
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: maintenance_suggestion
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [204, 204, 204, 255]
Width: 2
Default Label: Others
UniqueValueInfos:
• Value: Defer Maintenance
  Label: Defer Maintenance
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 2
• Value: Preventive Maintenance
  Label: Preventive Maintenance
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 2
• Value: Rehabilitation
  Label: Rehabilitation
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 2
• Value: Reclamation
  Label: Reclamation
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 2
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: maintenance_suggestion

Fields:

• objectid ( type: esriFieldTypeOID, alias: objectid, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• streetname ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: streetname )
• fromstreetname ( type: esriFieldTypeString, alias: From Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: fromstreetname )
• tostreetname ( type: esriFieldTypeString, alias: To Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tostreetname )
• pci ( type: esriFieldTypeSmallInteger, alias: PCI, editable: true, nullable: true, defaultValue: null, modelName: pci )
• maintenance_suggestion ( type: esriFieldTypeString, alias: Maintenance Suggestion, editable: true, nullable: true, length: 255, defaultValue: null, modelName: maintenance_suggestion )
• estimated_cost ( type: esriFieldTypeInteger, alias: Estimated Cost ($), editable: true, nullable: true, defaultValue: null, modelName: estimated_cost )
• repair_priority ( type: esriFieldTypeDouble, alias: Repair Priority, editable: true, nullable: true, defaultValue: null, modelName: repair_priority )
• functional_class ( type: esriFieldTypeString, alias: Functional Class, editable: true, nullable: true, length: 255, defaultValue: null, modelName: functional_class )
• functional_class_id ( type: esriFieldTypeSmallInteger, alias: Functional Class ID, editable: true, nullable: true, defaultValue: null, modelName: functional_class_id )
• surface_type ( type: esriFieldTypeString, alias: Surface Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: surface_type )
• survey_date ( type: esriFieldTypeString, alias: Survey Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: survey_date )
• width_ft ( type: esriFieldTypeDouble, alias: Width (ft), editable: true, nullable: true, defaultValue: null, modelName: width_ft )
• length_ft ( type: esriFieldTypeInteger, alias: Length (ft), editable: true, nullable: true, defaultValue: null, modelName: length_ft )
• area_sy ( type: esriFieldTypeDouble, alias: Area (sy), editable: true, nullable: true, defaultValue: null, modelName: area_sy )
• last_repair_method ( type: esriFieldTypeString, alias: Last Repair Method, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_repair_method )
• last_repair_cost ( type: esriFieldTypeInteger, alias: Last Repair Cost, editable: true, nullable: true, defaultValue: null, modelName: last_repair_cost )
• last_repair_date ( type: esriFieldTypeDate, alias: Last Repair Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_repair_date )
• future_event ( type: esriFieldTypeString, alias: Future Event, editable: true, nullable: true, length: 255, defaultValue: null, modelName: future_event )
• future_event_date ( type: esriFieldTypeDate, alias: Future Event Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: future_event_date )
• editor_note ( type: esriFieldTypeString, alias: Editor Note, editable: true, nullable: true, length: 255, defaultValue: null, modelName: editor_note )
• editor_name ( type: esriFieldTypeString, alias: Editor Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: editor_name )
• editor_id ( type: esriFieldTypeInteger, alias: Editor ID, editable: true, nullable: true, defaultValue: null, modelName: editor_id )
• last_edit ( type: esriFieldTypeDate, alias: Last Edit, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edit )
• ss_id ( type: esriFieldTypeInteger, alias: SS ID, editable: true, nullable: true, defaultValue: null, modelName: ss_id )
• installdat ( type: esriFieldTypeString, alias: INSTALLDAT, editable: true, nullable: true, length: 9, defaultValue: null, modelName: installdat )
• seg_id ( type: esriFieldTypeInteger, alias: SEG_ID, editable: true, nullable: true, defaultValue: null, modelName: seg_id )
• rte_cd ( type: esriFieldTypeString, alias: RTE_CD, editable: true, nullable: true, length: 2, defaultValue: null, modelName: rte_cd )
• stype ( type: esriFieldTypeString, alias: STYPE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: stype )
• dir_trav ( type: esriFieldTypeString, alias: DIR_TRAV, editable: true, nullable: true, length: 1, defaultValue: null, modelName: dir_trav )
• div ( type: esriFieldTypeString, alias: DIV, editable: true, nullable: true, length: 3, defaultValue: null, modelName: div )
• lanes ( type: esriFieldTypeString, alias: LANES, editable: true, nullable: true, length: 1, defaultValue: null, modelName: lanes )
• speed ( type: esriFieldTypeString, alias: SPEED, editable: true, nullable: true, length: 2, defaultValue: null, modelName: speed )
• oneway ( type: esriFieldTypeString, alias: ONEWAY, editable: true, nullable: true, length: 2, defaultValue: null, modelName: oneway )
• culdesac ( type: esriFieldTypeSmallInteger, alias: CULDESAC, editable: true, nullable: true, defaultValue: null, modelName: culdesac )
• l_comm ( type: esriFieldTypeString, alias: L_COMM, editable: true, nullable: true, length: 14, defaultValue: null, modelName: l_comm )
• r_comm ( type: esriFieldTypeString, alias: R_COMM, editable: true, nullable: true, length: 14, defaultValue: null, modelName: r_comm )
• symbology ( type: esriFieldTypeSmallInteger, alias: SYMBOLOGY, editable: true, nullable: true, defaultValue: null, modelName: symbology )
• seg_uniq ( type: esriFieldTypeString, alias: SEG_UNIQ, editable: true, nullable: true, length: 12, defaultValue: null, modelName: seg_uniq )
• snowroute ( type: esriFieldTypeString, alias: SNOWROUTE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: snowroute )
• refuserte ( type: esriFieldTypeString, alias: REFUSERTE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: refuserte )
• dubfunclas ( type: esriFieldTypeString, alias: DUBFUNCLAS, editable: true, nullable: true, length: 14, defaultValue: null, modelName: dubfunclas )
• roadwidth ( type: esriFieldTypeDouble, alias: ROADWIDTH, editable: true, nullable: true, defaultValue: null, modelName: roadwidth )
• trafficcou ( type: esriFieldTypeInteger, alias: TRAFFICCOU, editable: true, nullable: true, defaultValue: null, modelName: trafficcou )
• trafficc_1 ( type: esriFieldTypeDate, alias: TRAFFICC_1, editable: true, nullable: true, length: 8, defaultValue: null, modelName: trafficc_1 )
• dublinarea ( type: esriFieldTypeSmallInteger, alias: DUBLINAREA, editable: true, nullable: true, defaultValue: null, modelName: dublinarea )
• facilityid ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 6, defaultValue: null, modelName: facilityid )
• paser_avg ( type: esriFieldTypeDouble, alias: PASER_AVG, editable: true, nullable: true, defaultValue: null, modelName: paser_avg )
• paser_min ( type: esriFieldTypeSmallInteger, alias: PASER_MIN, editable: true, nullable: true, defaultValue: null, modelName: paser_min )
• new_paser_ ( type: esriFieldTypeDouble, alias: NEW_PASER_, editable: true, nullable: true, defaultValue: null, modelName: new_paser_ )
• new_paser2 ( type: esriFieldTypeSmallInteger, alias: NEW_PASER2, editable: true, nullable: true, defaultValue: null, modelName: new_paser2 )
• updated_ ( type: esriFieldTypeString, alias: UPDATED_, editable: true, nullable: true, length: 7, defaultValue: null, modelName: updated_ )
• pci_avg ( type: esriFieldTypeDouble, alias: PCI_AVG, editable: true, nullable: true, defaultValue: null, modelName: pci_avg )
• pci_min ( type: esriFieldTypeSmallInteger, alias: PCI_MIN, editable: true, nullable: true, defaultValue: null, modelName: pci_min )
• location ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 15, defaultValue: null, modelName: location )
• ownership ( type: esriFieldTypeString, alias: OWNERSHIP, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ownership )
• maint_resp ( type: esriFieldTypeString, alias: MAINT_RESP, editable: true, nullable: true, length: 6, defaultValue: null, modelName: maint_resp )
• insp_resp ( type: esriFieldTypeString, alias: INSP_RESP, editable: true, nullable: true, length: 6, defaultValue: null, modelName: insp_resp )
• inspected_ ( type: esriFieldTypeDate, alias: INSPECTED_, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inspected_ )
• condscore ( type: esriFieldTypeDouble, alias: CONDSCORE, editable: true, nullable: true, defaultValue: null, modelName: condscore )
• rehabdate ( type: esriFieldTypeString, alias: REHABDATE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: rehabdate )
• workplanye ( type: esriFieldTypeSmallInteger, alias: WORKPLANYE, editable: true, nullable: true, defaultValue: null, modelName: workplanye )
• projectnum ( type: esriFieldTypeString, alias: PROJECTNUM, editable: true, nullable: true, length: 9, defaultValue: null, modelName: projectnum )
• locationde ( type: esriFieldTypeString, alias: LOCATIONDE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: locationde )
• hyperlink ( type: esriFieldTypeString, alias: HYPERLINK, editable: true, nullable: true, length: 42, defaultValue: null, modelName: hyperlink )
• pavementar ( type: esriFieldTypeDouble, alias: PAVEMENTAR, editable: true, nullable: true, defaultValue: null, modelName: pavementar )
• lanemiles ( type: esriFieldTypeDouble, alias: LANEMILES, editable: true, nullable: true, defaultValue: null, modelName: lanemiles )
• snowzone ( type: esriFieldTypeString, alias: SNOWZONE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: snowzone )
• snowpriori ( type: esriFieldTypeString, alias: SNOWPRIORI, editable: true, nullable: true, length: 10, defaultValue: null, modelName: snowpriori )
• thickness ( type: esriFieldTypeDouble, alias: THICKNESS, editable: true, nullable: true, defaultValue: null, modelName: thickness )
• created_us ( type: esriFieldTypeString, alias: CREATED_US, editable: true, nullable: true, length: 32, defaultValue: null, modelName: created_us )
• created_da ( type: esriFieldTypeDate, alias: CREATED_DA, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_da )
• last_edite ( type: esriFieldTypeString, alias: LAST_EDITE, editable: true, nullable: true, length: 32, defaultValue: null, modelName: last_edite )
• last_edi_1 ( type: esriFieldTypeDate, alias: LAST_EDI_1, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edi_1 )
• unitprice ( type: esriFieldTypeDouble, alias: UNITPRICE, editable: true, nullable: true, defaultValue: null, modelName: unitprice )
• estimate ( type: esriFieldTypeDouble, alias: ESTIMATE, editable: true, nullable: true, defaultValue: null, modelName: estimate )
• sidewalkpr ( type: esriFieldTypeString, alias: SIDEWALKPR, editable: true, nullable: true, length: 10, defaultValue: null, modelName: sidewalkpr )
• curbtype ( type: esriFieldTypeString, alias: CURBTYPE, editable: true, nullable: true, length: 24, defaultValue: null, modelName: curbtype )
• curblength ( type: esriFieldTypeDouble, alias: CURBLENGTH, editable: true, nullable: true, defaultValue: null, modelName: curblength )
• curbcondit ( type: esriFieldTypeString, alias: CURBCONDIT, editable: true, nullable: true, length: 4, defaultValue: null, modelName: curbcondit )
• sweepingco ( type: esriFieldTypeString, alias: SWEEPINGCO, editable: true, nullable: true, length: 3, defaultValue: null, modelName: sweepingco )
• globalid ( type: esriFieldTypeString, alias: GLOBALID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: globalid )
• rehab_type ( type: esriFieldTypeString, alias: REHAB_TYPE, editable: true, nullable: true, length: 21, defaultValue: null, modelName: rehab_type )
• Shape__Length ( type: esriFieldTypeDouble, alias: st_length(shape), editable: false, nullable: false, defaultValue: null, modelName: st_length(shape) )
• start_date_ss ( type: esriFieldTypeDate, alias: start_date_ss, editable: true, nullable: true, length: 8, defaultValue: null, modelName: start_date_ss )
• end_date_ss ( type: esriFieldTypeDate, alias: end_date_ss, editable: true, nullable: true, length: 8, defaultValue: null, modelName: end_date_ss )
• objectid_slx ( type: esriFieldTypeInteger, alias: objectid_slx, editable: true, nullable: true, defaultValue: null, modelName: objectid_slx )
• clx_uid ( type: esriFieldTypeInteger, alias: clx_uid, editable: true, nullable: true, defaultValue: null, modelName: clx_uid )

Types:

ID: Defer Maintenance
Name: Defer Maintenance
Domains:
Templates:
• Name: Defer Maintenance
  Description:
  Prototype:
  objectid_slx: null
  clx_uid: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  pci: null
  maintenance_suggestion: Defer Maintenance
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  surface_type: null
  survey_date: null
  width_ft: null
  length_ft: null
  area_sy: null
  last_repair_method: null
  last_repair_cost: null
  last_repair_date: null
  future_event: null
  future_event_date: null
  editor_note: null
  editor_name: null
  editor_id: null
  last_edit: null
  ss_id: null
  installdat: null
  seg_id: null
  rte_cd: null
  stype: null
  dir_trav: null
  div: null
  lanes: null
  speed: null
  oneway: null
  culdesac: null
  l_comm: null
  r_comm: null
  symbology: null
  seg_uniq: null
  snowroute: null
  refuserte: null
  dubfunclas: null
  roadwidth: null
  trafficcou: null
  trafficc_1: null
  dublinarea: null
  facilityid: null
  paser_avg: null
  paser_min: null
  new_paser_: null
  new_paser2: null
  updated_: null
  pci_avg: null
  pci_min: null
  location: null
  ownership: null
  maint_resp: null
  insp_resp: null
  inspected_: null
  condscore: null
  rehabdate: null
  workplanye: null
  projectnum: null
  locationde: null
  hyperlink: null
  pavementar: null
  lanemiles: null
  snowzone: null
  snowpriori: null
  thickness: null
  created_us: null
  created_da: null
  last_edite: null
  last_edi_1: null
  unitprice: null
  estimate: null
  sidewalkpr: null
  curbtype: null
  curblength: null
  curbcondit: null
  sweepingco: null
  globalid: null
  rehab_type: null
  end_date_ss: null
  start_date_ss: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Preventive Maintenance
Name: Preventive Maintenance
Domains:
Templates:
• Name: Preventive Maintenance
  Description:
  Prototype:
  objectid_slx: null
  clx_uid: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  pci: null
  maintenance_suggestion: Preventive Maintenance
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  surface_type: null
  survey_date: null
  width_ft: null
  length_ft: null
  area_sy: null
  last_repair_method: null
  last_repair_cost: null
  last_repair_date: null
  future_event: null
  future_event_date: null
  editor_note: null
  editor_name: null
  editor_id: null
  last_edit: null
  ss_id: null
  installdat: null
  seg_id: null
  rte_cd: null
  stype: null
  dir_trav: null
  div: null
  lanes: null
  speed: null
  oneway: null
  culdesac: null
  l_comm: null
  r_comm: null
  symbology: null
  seg_uniq: null
  snowroute: null
  refuserte: null
  dubfunclas: null
  roadwidth: null
  trafficcou: null
  trafficc_1: null
  dublinarea: null
  facilityid: null
  paser_avg: null
  paser_min: null
  new_paser_: null
  new_paser2: null
  updated_: null
  pci_avg: null
  pci_min: null
  location: null
  ownership: null
  maint_resp: null
  insp_resp: null
  inspected_: null
  condscore: null
  rehabdate: null
  workplanye: null
  projectnum: null
  locationde: null
  hyperlink: null
  pavementar: null
  lanemiles: null
  snowzone: null
  snowpriori: null
  thickness: null
  created_us: null
  created_da: null
  last_edite: null
  last_edi_1: null
  unitprice: null
  estimate: null
  sidewalkpr: null
  curbtype: null
  curblength: null
  curbcondit: null
  sweepingco: null
  globalid: null
  rehab_type: null
  end_date_ss: null
  start_date_ss: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Rehabilitation
Name: Rehabilitation
Domains:
Templates:
• Name: Rehabilitation
  Description:
  Prototype:
  objectid_slx: null
  clx_uid: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  pci: null
  maintenance_suggestion: Rehabilitation
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  surface_type: null
  survey_date: null
  width_ft: null
  length_ft: null
  area_sy: null
  last_repair_method: null
  last_repair_cost: null
  last_repair_date: null
  future_event: null
  future_event_date: null
  editor_note: null
  editor_name: null
  editor_id: null
  last_edit: null
  ss_id: null
  installdat: null
  seg_id: null
  rte_cd: null
  stype: null
  dir_trav: null
  div: null
  lanes: null
  speed: null
  oneway: null
  culdesac: null
  l_comm: null
  r_comm: null
  symbology: null
  seg_uniq: null
  snowroute: null
  refuserte: null
  dubfunclas: null
  roadwidth: null
  trafficcou: null
  trafficc_1: null
  dublinarea: null
  facilityid: null
  paser_avg: null
  paser_min: null
  new_paser_: null
  new_paser2: null
  updated_: null
  pci_avg: null
  pci_min: null
  location: null
  ownership: null
  maint_resp: null
  insp_resp: null
  inspected_: null
  condscore: null
  rehabdate: null
  workplanye: null
  projectnum: null
  locationde: null
  hyperlink: null
  pavementar: null
  lanemiles: null
  snowzone: null
  snowpriori: null
  thickness: null
  created_us: null
  created_da: null
  last_edite: null
  last_edi_1: null
  unitprice: null
  estimate: null
  sidewalkpr: null
  curbtype: null
  curblength: null
  curbcondit: null
  sweepingco: null
  globalid: null
  rehab_type: null
  end_date_ss: null
  start_date_ss: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Reclamation
Name: Reclamation
Domains:
Templates:
• Name: Reclamation
  Description:
  Prototype:
  objectid_slx: null
  clx_uid: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  pci: null
  maintenance_suggestion: Reclamation
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  surface_type: null
  survey_date: null
  width_ft: null
  length_ft: null
  area_sy: null
  last_repair_method: null
  last_repair_cost: null
  last_repair_date: null
  future_event: null
  future_event_date: null
  editor_note: null
  editor_name: null
  editor_id: null
  last_edit: null
  ss_id: null
  installdat: null
  seg_id: null
  rte_cd: null
  stype: null
  dir_trav: null
  div: null
  lanes: null
  speed: null
  oneway: null
  culdesac: null
  l_comm: null
  r_comm: null
  symbology: null
  seg_uniq: null
  snowroute: null
  refuserte: null
  dubfunclas: null
  roadwidth: null
  trafficcou: null
  trafficc_1: null
  dublinarea: null
  facilityid: null
  paser_avg: null
  paser_min: null
  new_paser_: null
  new_paser2: null
  updated_: null
  pci_avg: null
  pci_min: null
  location: null
  ownership: null
  maint_resp: null
  insp_resp: null
  inspected_: null
  condscore: null
  rehabdate: null
  workplanye: null
  projectnum: null
  locationde: null
  hyperlink: null
  pavementar: null
  lanemiles: null
  snowzone: null
  snowpriori: null
  thickness: null
  created_us: null
  created_da: null
  last_edite: null
  last_edi_1: null
  unitprice: null
  estimate: null
  sidewalkpr: null
  curbtype: null
  curblength: null
  curbcondit: null
  sweepingco: null
  globalid: null
  rehab_type: null
  end_date_ss: null
  start_date_ss: null
  
  Drawing Tool: esriFeatureEditToolLine

---

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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