Name: ProjRec_ScoreTable

Display Field: Creator

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• R_LAND_UsePlan (type: esriFieldTypeInteger, alias: LANDUsePlan, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
• R_LAND_Access (type: esriFieldTypeInteger, alias: LAND_Access, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: project is focused on expanding access], [3: expands access somewhat], [0: does not expand access])
• R_LAND_CorridorPlan (type: esriFieldTypeInteger, alias: LANDCorridorPlan, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
• R_SAFETY_Crash (type: esriFieldTypeInteger, alias: SAFETY_Crash, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: project is on a road/corrdior in top 20th percentile EPDO], [3: project is on a road/corrdior in 60th-80th percentile EPDO], [1: project is on a road/corrdior in 40th-60th percential EPDO], ... 1 more ...)
• R_SAFETY_Plan (type: esriFieldTypeInteger, alias: SAFETYPlan, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
• R_SAFETY_Features (type: esriFieldTypeInteger, alias: SAFETYFeatures, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: project includes safety feature(s) or addresses documented issues for multiple modes], [1: project includes safety feature(s) or addresses documented issues for a single mode], [0: project would not include safety design features])
• R_SAFETY_VulnerableUser (type: esriFieldTypeInteger, alias: SAFETY_VulnerableUser, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• R_FUNDING_Existing (type: esriFieldTypeInteger, alias: FUNDINGExisting, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
• R_MAINT_OCI (type: esriFieldTypeInteger, alias: MAINTOCI, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Yes], [0: No])
• R_MAINT_Operations (type: esriFieldTypeInteger, alias: MAINTOperations, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Yes], [0: No])
• R_MAINT_Complaints (type: esriFieldTypeInteger, alias: MAINTComplaints, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
• R_DIVERSITY_NonMotorized (type: esriFieldTypeInteger, alias: DIVERSITY_NonMotorized, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: adds a project in MSB Bike and Ped plan], [3: project adds or improves other transit, bike, ped facilities], [1: maintains existing facility], ... 1 more ...)
• R_DIVERSITY_MultiModal (type: esriFieldTypeInteger, alias: DIVERSITYMultiModal, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Yes], [0: No])
• R_DIVERSITY_Transit (type: esriFieldTypeInteger, alias: DIVERSITYTransit, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: It would add new or improve transit facilities], [3: It would maintain existing transit facilities], [0: It would have no effect on transit facilities])
• R_DIVERISTY_Conflicts (type: esriFieldTypeInteger, alias: DIVERISTYConflicts, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Yes], [0: No])
• R_DIVERSITY_BPP (type: esriFieldTypeInteger, alias: DIVERSITYBPP, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• R_MOBILITY_LOS (type: esriFieldTypeInteger, alias: MOBILITY_LOS, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: project is on a roadway with LOS E or F], [3: project is on a roadway with LOS C or D], [0: project is on a roadway with LOS A or B])
• R_MOBILITY_Freight (type: esriFieldTypeInteger, alias: MOBILITY_Freight, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: on a designated freight network], [3: route has truck volume above 10%], [1: route has truck volume above 5%], ... 1 more ...)
• R_MOBILITY_Gap (type: esriFieldTypeInteger, alias: MOBILITY_Gap, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Yes], [0: No])
• R_RESILIENCY_Vulnerability (type: esriFieldTypeInteger, alias: RESILIENCYVulnerability, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: addressed infrastructure in an identified 100-yr flood zone], [3: reduces the vulnerability of transportation facilities], [0: no change])
• R_RESILIENCY_Environment (type: esriFieldTypeInteger, alias: RESILIENCYEnvironment, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Yes], [0: No])
• R_RESILIENCY_Redundancy (type: esriFieldTypeInteger, alias: RESILIENCYRedundancy, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Provides redundant emergency access to single access community or emergency facility], [1: Improves emergency vehicle access/enhances emergency response], [0: Does not improve emergency access])
• R_PublicSupport (type: esriFieldTypeInteger, alias: PublicSupport, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Resolution of support from organized governing body (e.g., community council, city, RSA)], [3: Documented public support/letters/petitions])
• R_PopReach (type: esriFieldTypeInteger, alias: PopReach, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Regional/areawide users], [3: Less than areawide; single community], [1: Multiple neighborhoods/destinations], ... 1 more ...)
• R_FunctClass (type: esriFieldTypeInteger, alias: FunctClass, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Arterial or greater], [3: Major Collector], [1: Minor Collector], ... 1 more ...)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• LandUseTotal (type: esriFieldTypeDouble, alias: LandUseTotal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SafetyTotal (type: esriFieldTypeDouble, alias: SafetyTotal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FundingTotal (type: esriFieldTypeDouble, alias: FundingTotal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RepairTotal (type: esriFieldTypeDouble, alias: RepairTotal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DiversityTotal (type: esriFieldTypeDouble, alias: DiversityTotal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MobilityTotal (type: esriFieldTypeDouble, alias: MobilityTotal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ResiliencyTotal (type: esriFieldTypeDouble, alias: ResiliencyTotal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OtherTotal (type: esriFieldTypeDouble, alias: OtherTotal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RawSubtotal (type: esriFieldTypeDouble, alias: RawSubtotal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CalculatedTotal (type: esriFieldTypeDouble, alias: CalculatedTotal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Username (type: esriFieldTypeString, alias: Username, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)

Templates:

Name: ProjRec_ScoreTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• ProjectRecommendation_Poly (0) -- Related To: ProjectRecommendations_Poly (4)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/15/2026 11:39:35 PM

Schema Last Edit Date: 4/15/2026 9:21:04 PM

Data Last Edit Date: 4/15/2026 11:39:35 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat