Name: PNF

Display Field: pnf_K_ProposedProjName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3c4f0f7daec04b25a89fdd7972695b62

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ProjectID ( type: esriFieldTypeString, alias: Project Proponent, length: 36 )
• StepID ( type: esriFieldTypeString, alias: StepID, length: 50 )
• IsComplete ( type: esriFieldTypeSmallInteger, alias: IsComplete , Coded Values: [0: false] , [1: true] )
• pnf_ProjProponent ( type: esriFieldTypeString, alias: Project Proponent, length: 250 )
• pnf_ProjProponentOther ( type: esriFieldTypeString, alias: Project Proponent Other, length: 250 )
• pnf_Date ( type: esriFieldTypeString, alias: Date, length: 100 )
• pnf_Project ( type: esriFieldTypeString, alias: Project, length: 250 )
• pnf_InitiatedBy ( type: esriFieldTypeString, alias: Initiated by, length: 250 )
• pnf_Municipality ( type: esriFieldTypeString, alias: Municipality, length: 250 )
• pnf_TelPhone ( type: esriFieldTypeString, alias: Phone, length: 50 )
• pnf_Title ( type: esriFieldTypeString, alias: Title, length: 250 )
• pnf_Organization ( type: esriFieldTypeString, alias: Organization, length: 250 )
• pnf_Emailid ( type: esriFieldTypeString, alias: Email Id, length: 250 )
• pnf_CompletedBy ( type: esriFieldTypeString, alias: Completed By, length: 250 )
• pnf_MunicipalityOther1 ( type: esriFieldTypeString, alias: Municipality Different Above, length: 250 )
• pnf_TelPhoneSecond ( type: esriFieldTypeString, alias: Tel Phone Different Above, length: 250 )
• pnf_TitleSecond ( type: esriFieldTypeString, alias: Title Different Above, length: 250 )
• pnf_OrganizationSecond ( type: esriFieldTypeString, alias: Organization Different Above, length: 250 )
• pnf_EmailidSecond ( type: esriFieldTypeString, alias: Email Id Different Above, length: 250 )
• pnf_A_Municipality ( type: esriFieldTypeString, alias: Municipality, length: 250 )
• pnf_A_District ( type: esriFieldTypeSmallInteger, alias: District , Coded Values: [1: District 1] , [2: District 2] , [3: District 3] , ...3 more... )
• pnf_A_RPA ( type: esriFieldTypeSmallInteger, alias: RPA , Coded Values: [11: NPEDC] , [10: NMCOG] , [13: PVPC] , ...11 more... )
• pnf_A_IncludeMunicipality ( type: esriFieldTypeSmallInteger, alias: Is More Municipality , Coded Values: [1: Yes] , [0: No] )
• pnf_A_OtherOne ( type: esriFieldTypeString, alias: Other Municipality, length: 250 )
• pnf_A_OtherTwo ( type: esriFieldTypeString, alias: Other Municipality, length: 250 )
• pnf_B_PriRoadwayFacility ( type: esriFieldTypeString, alias: Primary Roadway Facility, length: 250 )
• pnf_C_ProjectType ( type: esriFieldTypeSmallInteger, alias: Project Type , Coded Values: [1: BikewayBikePathConstruction] , [10: Other] , [3: NewConstruction] , ...8 more... )
• pnf_C_InitiationYear ( type: esriFieldTypeString, alias: Project Initiation Year, length: 250 )
• pnf_C_Design ( type: esriFieldTypeSmallInteger, alias: Design , Coded Values: [1: 25] , [0: 0] , [3: 100] , ...2 more... )
• pnf_C_TipYear ( type: esriFieldTypeString, alias: TIPyear, length: 100 )
• pnf_D_LocationUrbanRural ( type: esriFieldTypeSmallInteger, alias: Location In Urban Rural , Coded Values: [1: Urban] , [2: Rural] )
• pnf_E_FuClassPriRoadway ( type: esriFieldTypeSmallInteger, alias: Functional Class of PriRoadway , Coded Values: [1: Interstate] , [2: Principal Arterial - Other Freeways or Expressways] , [3: Principal Arterial - Other] , ...4 more... )
• pnf_F_ProjNationalHighSys ( type: esriFieldTypeSmallInteger, alias: Is Project on NHS , Coded Values: [1: Yes] , [0: No] )
• pnf_G_ADT ( type: esriFieldTypeString, alias: Annual Daily Traffic, length: 100 )
• pnf_G_YearADT ( type: esriFieldTypeString, alias: Year of ADT, length: 100 )
• pnf_H_Ownership ( type: esriFieldTypeSmallInteger, alias: Ownership , Coded Values: [11: Unaccepted] , [10: FederalInstitutional] , [1: MassDOT] , ...8 more... )
• pnf_H_OwnerShipPercent ( type: esriFieldTypeString, alias: OwnerShip Percentage, length: 100 )
• pnf_H_Municipality ( type: esriFieldTypeString, alias: Municipality, length: 250 )
• pnf_H_OwnershipOther ( type: esriFieldTypeSmallInteger, alias: Ownership Other , Coded Values: [11: Unaccepted] , [10: FederalInstitutional] , [1: MassDOT] , ...8 more... )
• pnf_H_OwnerShipOtherper ( type: esriFieldTypeString, alias: OwnerShip Other Percentage, length: 100 )
• pnf_H_MunicipalityOther ( type: esriFieldTypeString, alias: Municipality Other, length: 250 )
• pnf_H_OwnershipOther2 ( type: esriFieldTypeSmallInteger, alias: Ownership Other , Coded Values: [11: Unaccepted] , [10: FederalInstitutional] , [1: MassDOT] , ...8 more... )
• pnf_H_OwnerShipOther2per ( type: esriFieldTypeString, alias: OwnerShip Other Percentage, length: 100 )
• pnf_H_MunicipalityOther2 ( type: esriFieldTypeString, alias: Municipality Other, length: 250 )
• pnf_I_RecentOngoingRoadwayProj ( type: esriFieldTypeSmallInteger, alias: Is Recent Ongoing Roadway Project , Coded Values: [1: Yes] , [0: No] )
• pnf_I_Explain ( type: esriFieldTypeString, alias: Description other ongoing project, length: 1073741822 )
• pnf_J_Explain ( type: esriFieldTypeString, alias: Project Need, length: 3000 )
• pnf_K_ProposedProjName ( type: esriFieldTypeString, alias: Project Name Description, length: 250 )
• pnf_K_ProposedExplain ( type: esriFieldTypeString, alias: Project Description, length: 3000 )
• pnf_L_ProposedtotProjLen ( type: esriFieldTypeString, alias: Proposed Project Length, length: 100 )
• pnf_M_PreliminOfficeEstm ( type: esriFieldTypeString, alias: Preliminary Office Estimate, length: 100 )
• pnf_N_AnnualDaily ( type: esriFieldTypeString, alias: Annual Daily, length: 100 )
• pnf_N_AnnualDaily1 ( type: esriFieldTypeString, alias: Annual Daily1, length: 100 )
• pnf_N_AnnualDaily2 ( type: esriFieldTypeString, alias: Annual Daily2, length: 100 )
• pnf_N_RightOfWay ( type: esriFieldTypeString, alias: Right Of Way, length: 100 )
• pnf_N_RightOfWay1 ( type: esriFieldTypeString, alias: Right Of Way1, length: 100 )
• pnf_N_RightOfWay2 ( type: esriFieldTypeString, alias: Right Of Way2, length: 100 )
• pnf_N_TravelLanes ( type: esriFieldTypeString, alias: Travel Lanes, length: 100 )
• pnf_N_TravelLanes1 ( type: esriFieldTypeString, alias: Travel Lanes1, length: 100 )
• pnf_N_TravelLanes2 ( type: esriFieldTypeString, alias: Travel Lanes2, length: 100 )
• pnf_N_WidthTravelLanes ( type: esriFieldTypeString, alias: WidthTravelLanes, length: 100 )
• pnf_N_WidthTravelLanes1 ( type: esriFieldTypeString, alias: WidthTravelLanes1, length: 100 )
• pnf_N_WidthTravelLanes2 ( type: esriFieldTypeString, alias: WidthTravelLanes2, length: 100 )
• pnf_N_WidthOfShoulders ( type: esriFieldTypeString, alias: WidthOfShoulders, length: 100 )
• pnf_N_WidthOfShoulders1 ( type: esriFieldTypeString, alias: WidthOfShoulders1, length: 100 )
• pnf_N_WidthOfShoulders2 ( type: esriFieldTypeString, alias: WidthOfShoulders2, length: 100 )
• pnf_N_WidthOfBicycle ( type: esriFieldTypeString, alias: Width Of Bicycle, length: 100 )
• pnf_N_WidthOfBicycle1 ( type: esriFieldTypeString, alias: Width Of Bicycle1, length: 100 )
• pnf_N_WidthOfBicycle2 ( type: esriFieldTypeString, alias: Width Of Bicycle2, length: 100 )
• pnf_N_WidthOfSidewalk ( type: esriFieldTypeString, alias: Width Of Sidewalk, length: 100 )
• pnf_N_WidthOfSidewalk1 ( type: esriFieldTypeString, alias: Width Of Sidewalk1, length: 100 )
• pnf_N_WidthOfSidewalk2 ( type: esriFieldTypeString, alias: Width Of Sidewalk2, length: 100 )
• pnf_N_Sidewalksone ( type: esriFieldTypeSmallInteger, alias: Sidewalksone , Coded Values: [1: One] , [3: None] , [2: Both] )
• pnf_N_Sidewalksone1 ( type: esriFieldTypeSmallInteger, alias: Sidewalks one1 , Coded Values: [1: One] , [3: None] , [2: Both] )
• pnf_N_Sidewalksone2 ( type: esriFieldTypeString, alias: Sidewalksone2, length: 100 )
• pnf_N_TurningLanes ( type: esriFieldTypeString, alias: Turning Lanes, length: 100 )
• pnf_N_TurningLanes1 ( type: esriFieldTypeString, alias: Turning Lanes1, length: 100 )
• pnf_N_TurningLanes2 ( type: esriFieldTypeString, alias: Turning Lanes2, length: 100 )
• pnf_N_StreetParking ( type: esriFieldTypeString, alias: StreetParking, length: 100 )
• pnf_N_StreetParking1 ( type: esriFieldTypeString, alias: StreetParking1, length: 100 )
• pnf_N_StreetParking2 ( type: esriFieldTypeString, alias: StreetParking2, length: 100 )
• pnf_N_Bufferwidth ( type: esriFieldTypeString, alias: Buffer width, length: 100 )
• pnf_N_Bufferwidth1 ( type: esriFieldTypeString, alias: Buffer width1, length: 100 )
• pnf_N_Bufferwidth2 ( type: esriFieldTypeString, alias: Buffer width2, length: 100 )
• pnf_N_BusPullouts2 ( type: esriFieldTypeString, alias: Bus Pull outs2, length: 100 )
• pnf_N_CurbExtensions ( type: esriFieldTypeSmallInteger, alias: Curb Extensions , Coded Values: [1: Yes] , [0: No] )
• pnf_N_CurbExtensions1 ( type: esriFieldTypeSmallInteger, alias: Curb Extensions1 , Coded Values: [1: Yes] , [0: No] )
• pnf_N_CurbExtensions2 ( type: esriFieldTypeString, alias: pnf_N_CurbExtensions2, length: 100 )
• pnf_N_PostedSpeed ( type: esriFieldTypeString, alias: PostedSpeed, length: 100 )
• pnf_N_PostedSpeed1 ( type: esriFieldTypeString, alias: PostedSpeed1, length: 100 )
• pnf_N_PostedSpeed2 ( type: esriFieldTypeString, alias: PostedSpeed2, length: 100 )
• pnf_N_RoadwayLighting ( type: esriFieldTypeSmallInteger, alias: pnf_N_RoadwayLighting , Coded Values: [1: Yes] , [0: No] )
• pnf_N_RoadwayLighting1 ( type: esriFieldTypeSmallInteger, alias: pnf_N_RoadwayLighting1 , Coded Values: [1: Yes] , [0: No] )
• pnf_N_RoadwayLighting2 ( type: esriFieldTypeString, alias: Roadway Lighting2, length: 100 )
• pnf_N_TrafficControl ( type: esriFieldTypeSmallInteger, alias: Traffic Control , Coded Values: [1: Yes] , [0: No] )
• pnf_N_TrafficControl1 ( type: esriFieldTypeSmallInteger, alias: pnf_N_TrafficControl1 , Coded Values: [1: Yes] , [0: No] )
• pnf_N_TrafficControl2 ( type: esriFieldTypeString, alias: pnf_N_TrafficControl2, length: 100 )
• pnf_N_TransitRoutes ( type: esriFieldTypeSmallInteger, alias: Transit Routes , Coded Values: [1: Yes] , [0: No] )
• pnf_N_TransitRoutes1 ( type: esriFieldTypeSmallInteger, alias: TransitRoutes1 , Coded Values: [1: Yes] , [0: No] )
• pnf_N_TransitRoutes2 ( type: esriFieldTypeString, alias: TransitRoutes2, length: 250 )
• pnf_N_DailyBicycle ( type: esriFieldTypeString, alias: Daily Bicycle, length: 100 )
• pnf_N_DailyBicycle1 ( type: esriFieldTypeString, alias: Daily Bicycle1, length: 100 )
• pnf_N_DailyBicycle2 ( type: esriFieldTypeString, alias: Daily Bicycle2, length: 100 )
• pnf_N_Dailyped ( type: esriFieldTypeString, alias: Dailyped, length: 100 )
• pnf_N_Dailyped1 ( type: esriFieldTypeString, alias: Dailyped1, length: 100 )
• pnf_N_Dailyped2 ( type: esriFieldTypeString, alias: Dailyped2, length: 100 )
• pnf_N_percentTruck ( type: esriFieldTypeString, alias: percentTruck, length: 100 )
• pnf_N_percentTruck1 ( type: esriFieldTypeString, alias: percentTruck1, length: 100 )
• pnf_N_percentTruck2 ( type: esriFieldTypeString, alias: percentTruck2, length: 100 )
• pnf_O_ProjIntend3R ( type: esriFieldTypeSmallInteger, alias: Is project intended to 3R , Coded Values: [1: Yes] , [0: No] )
• pnf_P_DesignExceptionRPT ( type: esriFieldTypeSmallInteger, alias: Design Exception Report , Coded Values: [1: Yes] , [0: No] )
• pnf_p_descExplainDER ( type: esriFieldTypeString, alias: DER Description, length: 3000 )
• pnf_A_MuniProponentDistrict ( type: esriFieldTypeString, alias: pnf_A_MuniProponentDistrict, length: 3000 )
• pnf_A_MPORegion ( type: esriFieldTypeString, alias: pnf_A_MPORegion, length: 3000 )
• routeList ( type: esriFieldTypeString, alias: routeList, length: 1073741822 )
• pnf_A_Location ( type: esriFieldTypeSmallInteger, alias: pnf_A_Location , Coded Values: [1: Municipality] , [2: District] , [3: Statewide] , ...1 more... )
• PNFApprovedBy ( type: esriFieldTypeString, alias: PNFApprovedBy, length: 250 )
• PNFDateApproved ( type: esriFieldTypeDate, alias: PNFDateApproved, length: 8 )
• pnf_I_Explain_txt ( type: esriFieldTypeString, alias: pnf_I_Explain_txt, length: 3000 )
• pnf_red_sl ( type: esriFieldTypeString, alias: pnf_red_sl, length: 3000 )
• pnf_red_adt ( type: esriFieldTypeString, alias: pnf_red_adt, length: 3000 )
• pnf_red_tf ( type: esriFieldTypeString, alias: pnf_red_tf, length: 3000 )
• pnf_Municipality_value ( type: esriFieldTypeString, alias: pnf_Municipality_value, length: 100 )
• pnf_A_Municipality_value ( type: esriFieldTypeString, alias: pnf_A_Municipality_value, length: 100 )
• pnf_A_OtherOne_value ( type: esriFieldTypeString, alias: pnf_A_OtherOne_value, length: 100 )
• pnf_A_OtherTwo_value ( type: esriFieldTypeString, alias: pnf_A_OtherTwo_value, length: 100 )
• pnf_H_Municipality_value ( type: esriFieldTypeString, alias: pnf_H_Municipality_value, length: 100 )
• pnf_H_MunicipalityOther_value ( type: esriFieldTypeString, alias: pnf_H_MunicipalityOther_value, length: 100 )
• pnf_MunicipalityOther1_value ( type: esriFieldTypeString, alias: pnf_MunicipalityOther1_value, length: 100 )
• pnf_H_MunicipalityOther2_value ( type: esriFieldTypeString, alias: pnf_H_MunicipalityOther2_value, length: 100 )
• pnf_N_BusPullouts ( type: esriFieldTypeDouble, alias: Bus Pull outs )
• pnf_N_BusPullouts1 ( type: esriFieldTypeDouble, alias: Bus Pull outs1 )
• pnf_K_ProjectLimitsBegin ( type: esriFieldTypeString, alias: pnf_K_ProjectLimitsBegin, length: 3000 )
• pnf_K_ProjectLimitsEnd ( type: esriFieldTypeString, alias: pnf_K_ProjectLimitsEnd, length: 3000 )
• pnf_C_OtherInfo ( type: esriFieldTypeString, alias: pnf_C_OtherInfo, length: 3000 )
• pnf_red_ni_1 ( type: esriFieldTypeString, alias: pnf_red_ni_1, length: 3000 )
• pnf_red_ni_2 ( type: esriFieldTypeString, alias: pnf_red_ni_2, length: 3000 )
• pnf_N_Intersections ( type: esriFieldTypeString, alias: pnf_N_Intersections, length: 100 )
• pnf_N_Intersections1 ( type: esriFieldTypeString, alias: pnf_N_Intersections1, length: 100 )
• pnf_N_Intersections2 ( type: esriFieldTypeString, alias: pnf_N_Intersections2, length: 3000 )
• pnf_G_Source ( type: esriFieldTypeSmallInteger, alias: pnf_G_Source , Coded Values: [1: Road Inventory] , [2: Streetlignt] , [3: Field Data Collection] , ...1 more... )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata