Layers:

Layer: Current Projects (Points) (0)

Name: Current Projects (Points)

Display Field: PID_NBR

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Transportation infrastructure projects at point locations (bridges, culverts, etc.) Current Projects is the All Projects Points dataset filtered by BEGIN_CONSTR_MILESTONE_DT and END_CONSTR_MILESTONE_DT.

Service Item Id: aef960a4d3904c28884245ff343e56b6

Copyright Text: ODOT Office of Transportation and Economic Development

Default Visibility: false

MaxRecordCount: 2000000

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: -2.0037507842788246E7
YMin: -3.024097145838615E7
XMax: 2.0037507842788246E7
YMax: 3.024097145838615E7
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [PID_NBR] CONCAT NEWLINE CONCAT [PRIMARY_WORK_CATEGORY]
Use Coded Values: true
Symbol:
Color: [52, 52, 52, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 144447.638572
Max. Scale: 0.0

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

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: ObjectID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GIS_ID ( type: esriFieldTypeDouble, alias: GIS_ID, editable: true, nullable: false, defaultValue: null, modelName: GIS_ID )
• PID_NBR ( type: esriFieldTypeInteger, alias: PID_NBR, editable: true, nullable: true, defaultValue: null, modelName: PID_NBR )
• DISTRICT_NBR ( type: esriFieldTypeInteger, alias: DISTRICT_NBR, editable: true, nullable: true, defaultValue: null, modelName: DISTRICT_NBR )
• LOCALE_SHORT_NME ( type: esriFieldTypeString, alias: LOCALE_SHORT_NME, editable: true, nullable: true, length: 40, defaultValue: null, modelName: LOCALE_SHORT_NME )
• PROJECT_NME ( type: esriFieldTypeString, alias: PROJECT_NME, editable: true, nullable: true, length: 32, defaultValue: null, modelName: PROJECT_NME )
• PRIMARY_FUND_CATEGORY_TXT ( type: esriFieldTypeString, alias: PRIMARY_FUND_CATEGORY_TXT, editable: true, nullable: true, length: 40, defaultValue: null, modelName: PRIMARY_FUND_CATEGORY_TXT )
• SCHEDULE_TYPE_SHORT_NME ( type: esriFieldTypeString, alias: SCHEDULE_TYPE_SHORT_NME, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SCHEDULE_TYPE_SHORT_NME )
• AREA_ENGINEER_NME ( type: esriFieldTypeString, alias: AREA_ENGINEER_NME, editable: true, nullable: true, length: 120, defaultValue: null, modelName: AREA_ENGINEER_NME )
• PROJECT_ENGINEER_NME ( type: esriFieldTypeString, alias: PROJECT_ENGINEER_NME, editable: true, nullable: true, length: 120, defaultValue: null, modelName: PROJECT_ENGINEER_NME )
• PRIMARY_WORK_CATEGORY ( type: esriFieldTypeString, alias: PRIMARY_WORK_CATEGORY, editable: true, nullable: true, length: 40, defaultValue: null, modelName: PRIMARY_WORK_CATEGORY )
• FISCAL_YEAR ( type: esriFieldTypeString, alias: FISCAL_YEAR, editable: true, nullable: true, length: 4, defaultValue: null, modelName: FISCAL_YEAR )
• INHOUSE_DESIGN_FULL_NME ( type: esriFieldTypeString, alias: INHOUSE_DESIGN_FULL_NME, editable: true, nullable: true, length: 120, defaultValue: null, modelName: INHOUSE_DESIGN_FULL_NME )
• CURRENT_STIP_CO_AMT ( type: esriFieldTypeDouble, alias: CURRENT_STIP_CO_AMT, editable: true, nullable: true, defaultValue: null, modelName: CURRENT_STIP_CO_AMT )
• PROJECT_PLANS_URL ( type: esriFieldTypeString, alias: PROJECT_PLANS_URL, editable: true, nullable: true, length: 300, defaultValue: null, modelName: PROJECT_PLANS_URL )
• PROJECT_ADDENDA_URL ( type: esriFieldTypeString, alias: PROJECT_ADDENDA_URL, editable: true, nullable: true, length: 300, defaultValue: null, modelName: PROJECT_ADDENDA_URL )
• PROJECT_PROPOSAL_URL ( type: esriFieldTypeString, alias: PROJECT_PROPOSAL_URL, editable: true, nullable: true, length: 300, defaultValue: null, modelName: PROJECT_PROPOSAL_URL )
• FMIS_PROJ_DESC ( type: esriFieldTypeString, alias: FMIS_PROJ_DESC, editable: true, nullable: true, length: 500, defaultValue: null, modelName: FMIS_PROJ_DESC )
• AWARD_MILESTONE_DT ( type: esriFieldTypeDate, alias: AWARD_MILESTONE_DT, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: AWARD_MILESTONE_DT )
• BEGIN_CONSTR_MILESTONE_DT ( type: esriFieldTypeDate, alias: BEGIN_CONSTR_MILESTONE_DT, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: BEGIN_CONSTR_MILESTONE_DT )
• END_CONSTR_MILESTONE_DT ( type: esriFieldTypeDate, alias: END_CONSTR_MILESTONE_DT, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: END_CONSTR_MILESTONE_DT )
• OPEN_TRAFFIC_DT ( type: esriFieldTypeDate, alias: OPEN_TRAFFIC_DT, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: OPEN_TRAFFIC_DT )
• CENTRAL_OFFICE_CLOSE_DT ( type: esriFieldTypeDate, alias: CENTRAL_OFFICE_CLOSE_DT, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: CENTRAL_OFFICE_CLOSE_DT )
• SOURCE_LAST_UPDATED ( type: esriFieldTypeDate, alias: SOURCE_LAST_UPDATED, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: SOURCE_LAST_UPDATED )
• COD_LAST_UPDATED ( type: esriFieldTypeDate, alias: COD_LAST_UPDATED, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: COD_LAST_UPDATED )
• PRESERV_FUNDS_IND ( type: esriFieldTypeString, alias: PRESERV_FUNDS_IND, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PRESERV_FUNDS_IND )
• MAJOR_BRG_FUNDS_IND ( type: esriFieldTypeString, alias: MAJOR_BRG_FUNDS_IND, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MAJOR_BRG_FUNDS_IND )
• MAJOR_NEW_FUNDS_IND ( type: esriFieldTypeString, alias: MAJOR_NEW_FUNDS_IND, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MAJOR_NEW_FUNDS_IND )
• MAJOR_REHAB_FUNDS_IND ( type: esriFieldTypeString, alias: MAJOR_REHAB_FUNDS_IND, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MAJOR_REHAB_FUNDS_IND )
• MPO_FUNDS_IND ( type: esriFieldTypeString, alias: MPO_FUNDS_IND, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MPO_FUNDS_IND )
• SAFETY_FUNDS_IND ( type: esriFieldTypeString, alias: SAFETY_FUNDS_IND, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SAFETY_FUNDS_IND )
• LOCAL_FUNDS_IND ( type: esriFieldTypeString, alias: LOCAL_FUNDS_IND, editable: true, nullable: true, length: 3, defaultValue: null, modelName: LOCAL_FUNDS_IND )
• OTHER_FUNDS_IND ( type: esriFieldTypeString, alias: OTHER_FUNDS_IND, editable: true, nullable: true, length: 3, defaultValue: null, modelName: OTHER_FUNDS_IND )
• NLF_ID ( type: esriFieldTypeString, alias: NLF_ID, editable: true, nullable: true, length: 14, defaultValue: null, modelName: NLF_ID )
• GIS_FEATURE_TYPE ( type: esriFieldTypeString, alias: GIS_FEATURE_TYPE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GIS_FEATURE_TYPE )
• ROUTE_TYPE ( type: esriFieldTypeString, alias: ROUTE_TYPE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ROUTE_TYPE )
• ROUTE_ID ( type: esriFieldTypeString, alias: ROUTE_ID, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ROUTE_ID )
• STRUCTURE_FILE_NBR ( type: esriFieldTypeString, alias: STRUCTURE_FILE_NBR, editable: true, nullable: true, length: 7, defaultValue: null, modelName: STRUCTURE_FILE_NBR )
• DECK_AREA ( type: esriFieldTypeInteger, alias: DECK_AREA, editable: true, nullable: true, defaultValue: null, modelName: DECK_AREA )
• LONGITUDE_BEGIN_NBR ( type: esriFieldTypeDouble, alias: LONGITUDE_BEGIN_NBR, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE_BEGIN_NBR )
• LATITUDE_BEGIN_NBR ( type: esriFieldTypeDouble, alias: LATITUDE_BEGIN_NBR, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE_BEGIN_NBR )
• LONGITUDE_END_NBR ( type: esriFieldTypeDouble, alias: LONGITUDE_END_NBR, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE_END_NBR )
• LATITUDE_END_NBR ( type: esriFieldTypeDouble, alias: LATITUDE_END_NBR, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE_END_NBR )
• COUNTY_NME ( type: esriFieldTypeString, alias: COUNTY_NME, editable: true, nullable: true, length: 80, defaultValue: null, modelName: COUNTY_NME )
• CONTRACT_TYPE ( type: esriFieldTypeString, alias: CONTRACT_TYPE, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CONTRACT_TYPE )
• PROJECT_MANAGER_NME ( type: esriFieldTypeString, alias: PROJECT_MANAGER_NME, editable: true, nullable: true, length: 120, defaultValue: null, modelName: PROJECT_MANAGER_NME )
• RESERVOIR_YEAR ( type: esriFieldTypeInteger, alias: RESERVOIR_YEAR, editable: true, nullable: true, defaultValue: null, modelName: RESERVOIR_YEAR )
• TIER ( type: esriFieldTypeString, alias: TIER, editable: true, nullable: true, length: 40, defaultValue: null, modelName: TIER )
• ODOT_LETTING ( type: esriFieldTypeString, alias: ODOT_LETTING, editable: true, nullable: true, length: 40, defaultValue: null, modelName: ODOT_LETTING )
• ENV_PROJECT_MANAGER_NME ( type: esriFieldTypeString, alias: ENV_PROJECT_MANAGER_NME, editable: true, nullable: true, length: 120, defaultValue: null, modelName: ENV_PROJECT_MANAGER_NME )
• DESIGN_AGENCY ( type: esriFieldTypeString, alias: DESIGN_AGENCY, editable: true, nullable: true, length: 80, defaultValue: null, modelName: DESIGN_AGENCY )
• SPONSORING_AGENCY ( type: esriFieldTypeString, alias: SPONSORING_AGENCY, editable: true, nullable: true, length: 80, defaultValue: null, modelName: SPONSORING_AGENCY )
• PDP_SHORT_NAME ( type: esriFieldTypeString, alias: PDP_SHORT_NAME, editable: true, nullable: true, length: 40, defaultValue: null, modelName: PDP_SHORT_NAME )
• PROJECT_STATUS ( type: esriFieldTypeString, alias: PROJECT_STATUS, editable: true, nullable: true, length: 40, defaultValue: null, modelName: PROJECT_STATUS )
• EST_TOTAL_CONSTR_COST ( type: esriFieldTypeDouble, alias: EST_TOTAL_CONSTR_COST, editable: true, nullable: true, defaultValue: null, modelName: EST_TOTAL_CONSTR_COST )
• STATE_PROJECT_NBR ( type: esriFieldTypeString, alias: STATE_PROJECT_NBR, editable: true, nullable: true, length: 6, defaultValue: null, modelName: STATE_PROJECT_NBR )
• CONSTR_VENDOR_NME ( type: esriFieldTypeString, alias: CONSTR_VENDOR_NME, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CONSTR_VENDOR_NME )
• STIP_FLAG ( type: esriFieldTypeString, alias: MAJOR_BRG_FUNDS_IND, editable: true, nullable: true, length: 3, defaultValue: null, modelName: STIP_FLAG )
• CTL_BEGIN ( type: esriFieldTypeDouble, alias: CTL_BEGIN, editable: true, nullable: true, defaultValue: null, modelName: CTL_BEGIN )
• CTL_END ( type: esriFieldTypeDouble, alias: CTL_END, editable: true, nullable: true, defaultValue: null, modelName: CTL_END )
• MAIN_STRUCTURE_TYPE ( type: esriFieldTypeString, alias: MAIN_STRUCTURE_TYPE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: MAIN_STRUCTURE_TYPE )
• SUFFICIENCY_RATING ( type: esriFieldTypeString, alias: SUFFICIENCY_RATING, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SUFFICIENCY_RATING )
• OVRL_STRUCTURE_LENGTH ( type: esriFieldTypeDouble, alias: OVRL_STRUCTURE_LENGTH, editable: true, nullable: true, defaultValue: null, modelName: OVRL_STRUCTURE_LENGTH )
• DECK_WIDTH ( type: esriFieldTypeDouble, alias: DECK_WIDTH, editable: true, nullable: true, defaultValue: null, modelName: DECK_WIDTH )
• FEATURE_INTERSECT ( type: esriFieldTypeString, alias: FEATURE_INTERSECT, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FEATURE_INTERSECT )
• YEAR_BUILT ( type: esriFieldTypeString, alias: YEAR_BUILT, editable: true, nullable: true, length: 4, defaultValue: null, modelName: YEAR_BUILT )
• COUNTY_CD_WORK_LOCATION ( type: esriFieldTypeString, alias: COUNTY_CD_WORK_LOCATION, editable: true, nullable: true, length: 3, defaultValue: null, modelName: COUNTY_CD_WORK_LOCATION )
• COUNTY_NME_WORK_LOCATION ( type: esriFieldTypeString, alias: COUNTY_NME_WORK_LOCATION, editable: true, nullable: true, length: 15, defaultValue: null, modelName: COUNTY_NME_WORK_LOCATION )
• DISTRICT_WORK_LOCATION ( type: esriFieldTypeString, alias: DISTRICT_WORK_LOCATION, editable: true, nullable: true, length: 2, defaultValue: null, modelName: DISTRICT_WORK_LOCATION )
• PAVEMENT_TREATMENT_TYPE ( type: esriFieldTypeString, alias: PAVEMENT_TREATMENT_TYPE, editable: true, nullable: true, length: 80, defaultValue: null, modelName: PAVEMENT_TREATMENT_TYPE )
• PAVEMENT_TREATMENT_CATEGORY ( type: esriFieldTypeString, alias: PAVEMENT_TREATMENT_CATEGORY, editable: true, nullable: true, length: 80, defaultValue: null, modelName: PAVEMENT_TREATMENT_CATEGORY )
• GDB_GEOMATTR_DATA ( type: esriFieldTypeBlob, alias: GDB_GEOMATTR_DATA, editable: true, nullable: true, defaultValue: null, modelName: GDB_GEOMATTR_DATA )
Templates:
• Name: Current Projects (Points)
  Description:
  Prototype:
  PAVEMENT_TREATMENT_CATEGORY: null
  GIS_ID: 0
  PID_NBR: null
  DISTRICT_NBR: null
  LOCALE_SHORT_NME: null
  PROJECT_NME: null
  PRIMARY_FUND_CATEGORY_TXT: null
  SCHEDULE_TYPE_SHORT_NME: null
  AREA_ENGINEER_NME: null
  PROJECT_ENGINEER_NME: null
  PRIMARY_WORK_CATEGORY: null
  FISCAL_YEAR: null
  INHOUSE_DESIGN_FULL_NME: null
  CURRENT_STIP_CO_AMT: null
  PROJECT_PLANS_URL: null
  PROJECT_ADDENDA_URL: null
  PROJECT_PROPOSAL_URL: null
  FMIS_PROJ_DESC: null
  AWARD_MILESTONE_DT: null
  BEGIN_CONSTR_MILESTONE_DT: null
  END_CONSTR_MILESTONE_DT: null
  OPEN_TRAFFIC_DT: null
  CENTRAL_OFFICE_CLOSE_DT: null
  SOURCE_LAST_UPDATED: null
  COD_LAST_UPDATED: null
  PRESERV_FUNDS_IND: null
  MAJOR_BRG_FUNDS_IND: null
  MAJOR_NEW_FUNDS_IND: null
  MAJOR_REHAB_FUNDS_IND: null
  MPO_FUNDS_IND: null
  SAFETY_FUNDS_IND: null
  LOCAL_FUNDS_IND: null
  OTHER_FUNDS_IND: null
  NLF_ID: null
  GIS_FEATURE_TYPE: null
  ROUTE_TYPE: null
  ROUTE_ID: null
  STRUCTURE_FILE_NBR: null
  DECK_AREA: null
  LONGITUDE_BEGIN_NBR: null
  LATITUDE_BEGIN_NBR: null
  LONGITUDE_END_NBR: null
  LATITUDE_END_NBR: null
  COUNTY_NME: null
  CONTRACT_TYPE: null
  PROJECT_MANAGER_NME: null
  RESERVOIR_YEAR: null
  TIER: null
  ODOT_LETTING: null
  ENV_PROJECT_MANAGER_NME: null
  DESIGN_AGENCY: null
  SPONSORING_AGENCY: null
  PDP_SHORT_NAME: null
  PROJECT_STATUS: null
  EST_TOTAL_CONSTR_COST: null
  STATE_PROJECT_NBR: null
  CONSTR_VENDOR_NME: null
  STIP_FLAG: null
  CTL_BEGIN: null
  CTL_END: null
  MAIN_STRUCTURE_TYPE: null
  SUFFICIENCY_RATING: null
  OVRL_STRUCTURE_LENGTH: null
  DECK_WIDTH: null
  FEATURE_INTERSECT: null
  YEAR_BUILT: null
  COUNTY_CD_WORK_LOCATION: null
  COUNTY_NME_WORK_LOCATION: null
  DISTRICT_WORK_LOCATION: null
  PAVEMENT_TREATMENT_TYPE: null
  GDB_GEOMATTR_DATA: null
  
  Drawing Tool: esriFeatureEditToolPoint