Name: Project Scoping

Display Field: USERNAME

Type: Table

Description:

Copyright Text:

Max Record Count: 32000

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)
• OBJECTIVES (type: esriFieldTypeString, alias: Objectives, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• DESCRIPTION (type: esriFieldTypeString, alias: Location / Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• LEVELSTUDYREQUIRED (type: esriFieldTypeSmallInteger, alias: Level of Study Required, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Through Design], [2: To Letting], [0: Through Planning (to concept)])
• DESIREDFISCALYEAR (type: esriFieldTypeSmallInteger, alias: Desired Fiscal Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRAFFICCRITICAL (type: esriFieldTypeSmallInteger, alias: Traffic Critical?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: Unknown])
• LEVIESAFFECTED (type: esriFieldTypeSmallInteger, alias: Levies Affected?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: Unknown])
• INTERCHANGEREQUIRED (type: esriFieldTypeSmallInteger, alias: Operation Report (IJR/IOR) Required?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: Unknown])
• OUTSIDESERVICES (type: esriFieldTypeSmallInteger, alias: Outside Services Expected?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: Unknown])
• ROWNEED (type: esriFieldTypeSmallInteger, alias: Anticipated Range of ROW Required, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0 Acres], [1: 0.1-1 Acres], [2: 1-5 Acres], ... 2 more ...)
• ACQUISITIONANTICIPATED (type: esriFieldTypeSmallInteger, alias: Acquisition Anticipated?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: Unknown])
• ROWRELOCATION (type: esriFieldTypeSmallInteger, alias: Residential/Commercial Relocation Needed?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: Unknown])
• TITLEANTICIPATED (type: esriFieldTypeSmallInteger, alias: Title Anticipated?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: New], [1: Modify Existing], [2: Unknown])
• EASEMENTANTICIPATED (type: esriFieldTypeSmallInteger, alias: Easement Anticipated?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: Unknown])
• ROWDISPOSAL (type: esriFieldTypeSmallInteger, alias: ROW Disposals?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: Unknown])
• TANDE (type: esriFieldTypeSmallInteger, alias: Potential Threatened & Endangered Species?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: Unknown])
• CULTURALSITE (type: esriFieldTypeSmallInteger, alias: Known Archaeological Site?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: Unknown])
• HISTORICALSITE (type: esriFieldTypeSmallInteger, alias: Known Historical Site?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: Unknown])
• FLOODPLAIN (type: esriFieldTypeSmallInteger, alias: Floodplain?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: Unknown])
• CONCURRENCEPOINT (type: esriFieldTypeSmallInteger, alias: Concurrence Point Process?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: Unknown])
• LEVELOFDOCUMENTATION (type: esriFieldTypeSmallInteger, alias: Environmental Classification, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Environmental Impact Statement], [2: Environmental Assessment], [3: Categorical Exclusion], ... 2 more ...)
• BUDGETRANGEMIN (type: esriFieldTypeDouble, alias: Budget Range Min (1,000’s), SQL Type: sqlTypeOther, nullable: true, editable: true)
• BUDGETRANGEMAX (type: esriFieldTypeDouble, alias: Budget Range Max (1,000’s), SQL Type: sqlTypeOther, nullable: true, editable: true)
• CREATED_USER (type: esriFieldTypeString, alias: CREATED_USER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CREATED_DATE (type: esriFieldTypeDate, alias: created_date (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LAST_EDITED_USER (type: esriFieldTypeString, alias: LAST_EDITED_USER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LAST_EDITED_DATE (type: esriFieldTypeDate, alias: last_edited_date (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• USERNAME (type: esriFieldTypeString, alias: DOT Username, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PIN_ID (type: esriFieldTypeDouble, alias: PIN ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIN (type: esriFieldTypeString, alias: PIN, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• PROJECT_TYPE (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MITIGATION (type: esriFieldTypeString, alias: Mitigation, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• PERMIT_404_REQUIRED (type: esriFieldTypeString, alias: Permit 404 Required?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• FIRST_LETTING (type: esriFieldTypeDate, alias: First Letting Date (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PROG_EST_SUM (type: esriFieldTypeDouble, alias: Prog Est Sum, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DEV_EST_SUM (type: esriFieldTypeDouble, alias: Dev Est Sum, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FUNDS (type: esriFieldTypeString, alias: Funds, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• COUNTY_NAME (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 67, nullable: true, editable: true)
• ALL_ROUTES (type: esriFieldTypeString, alias: All Routes, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• WKGROUP (type: esriFieldTypeString, alias: Work Type, SQL Type: sqlTypeOther, length: 400, nullable: true, editable: true)
• ROUTE_1 (type: esriFieldTypeString, alias: Route 1, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ROUTE_2 (type: esriFieldTypeString, alias: Route 2, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ROUTE_3 (type: esriFieldTypeString, alias: Route 3, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ROUTE_4 (type: esriFieldTypeString, alias: Route 4, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• HIGHWAY_CLASS (type: esriFieldTypeString, alias: Highway Class, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• RECORD_LAST_UPDATED (type: esriFieldTypeDate, alias: Record Last Updated (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COUNTY_1 (type: esriFieldTypeString, alias: County 1, SQL Type: sqlTypeOther, length: 67, nullable: true, editable: true)
• COUNTY_2 (type: esriFieldTypeString, alias: County 2, SQL Type: sqlTypeOther, length: 67, nullable: true, editable: true)
• COUNTY_3 (type: esriFieldTypeString, alias: County 3, SQL Type: sqlTypeOther, length: 67, nullable: true, editable: true)
• COUNTY_4 (type: esriFieldTypeString, alias: County 4, SQL Type: sqlTypeOther, length: 67, nullable: true, editable: true)
• CREATION_DATE (type: esriFieldTypeDate, alias: Record Creation Date (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ACCESS_CONTROL (type: esriFieldTypeString, alias: Access Control, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• BEGIN_MILEPOST (type: esriFieldTypeString, alias: Begin Milepost, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• CORRIDOR (type: esriFieldTypeString, alias: Corridor, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• DISTRICT (type: esriFieldTypeSmallInteger, alias: District, SQL Type: sqlTypeOther, nullable: true, editable: true)
• END_MILEPOST (type: esriFieldTypeString, alias: End Milepost, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• LIGHTING (type: esriFieldTypeString, alias: Lighting, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• MATERIALS_ENGINEER (type: esriFieldTypeString, alias: Material Engineer, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• MILES (type: esriFieldTypeDouble, alias: Miles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROJECT_MANAGER (type: esriFieldTypeString, alias: Project Manager, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• RAILROAD_INVOLVED (type: esriFieldTypeString, alias: Railroad Involved, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• SEGMENT_MANAGER (type: esriFieldTypeString, alias: Segment Manager, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• TRAFFIC_SIGNALS (type: esriFieldTypeString, alias: Traffic Signals, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• TRAFFIC_SIGNS (type: esriFieldTypeString, alias: Traffic Signs, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• UTILITIES (type: esriFieldTypeString, alias: Utilities, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• UTILITIES_IMPACTED (type: esriFieldTypeString, alias: Utilities Impacted, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• UTILITY_STATUS (type: esriFieldTypeString, alias: Utility Status, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• REST_UPDATED (type: esriFieldTypeDate, alias: REST Service Last Updated (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PARK_INSTITUTION (type: esriFieldTypeString, alias: Park Institution, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• UTC_OFFSET (type: esriFieldTypeString, alias: UTC Offset, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• PRIMARY_ROUTE (type: esriFieldTypeString, alias: Primary Route, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DISTRICT_PRIORITY (type: esriFieldTypeDouble, alias: District Priority, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: 1], [2: 2], ... 3 more ...)
• HOLD_FISCAL_YEAR (type: esriFieldTypeSmallInteger, alias: Hold Fiscal Year, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• PD_COMPLETED_BY (type: esriFieldTypeSmallInteger, alias: Project Development Completed by, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: District], [2: Office of Design], ... 6 more ...)
• PD_COMPLETED_BY_OTHER (type: esriFieldTypeString, alias: Project Development Completed by Other, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DESIRED_FISCAL_MONTH (type: esriFieldTypeSmallInteger, alias: Desired Month, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No Preference], [5: May], [1: Jan], ... 10 more ...)
• READABLE_PRIMARY_ROUTE (type: esriFieldTypeString, alias: Scoping Primary Route, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Project Scoping
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• DESIRED_FISCAL_MONTH: 0
• BUDGETRANGEMIN: 0
• HOLD_FISCAL_YEAR: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/25/2023 10:10:41 PM

Schema Last Edit Date: 6/25/2023 10:10:41 PM

Data Last Edit Date: 6/25/2023 10:10:39 PM

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