All Layers and Tables (Macomb_County_Final_TIP_Application

Layers:

Layer: MacombCounty_TIP_Phase_II_Full_Application_Details_attachments (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"Planned_Investment_Category","uniqueValueGroups":[{"heading":"Planned Investment Category","classes":[{"label":"Capital Preventive Maintenance","description":"Capital Preventive Maintenance","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[62,173,179,255],"width":2},"values":[["Capital Preventive Maintenance"]]},{"label":"Reconstruction (Recon)","description":"Reconstruction (Recon)","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[225,81,232,255],"width":2},"values":[["Reconstruction (Recon)"]]},{"label":"Reconstruction and Widening (Wi","description":"Reconstruction and Widening (Wi","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[237,128,88,255],"width":2},"values":[["Reconstruction and Widening (Wi"]]},{"label":"Rehabilitation (Rehab)","description":"Rehabilitation (Rehab)","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[185,235,84,255],"width":2},"values":[["Rehabilitation (Rehab)"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[62,173,179,255],"width":2},"value":"Capital Preventive Maintenance","label":"Capital Preventive Maintenance"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[225,81,232,255],"width":2},"value":"Reconstruction (Recon)","label":"Reconstruction (Recon)"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[237,128,88,255],"width":2},"value":"Reconstruction and Widening (Wi","label":"Reconstruction and Widening (Wi"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[185,235,84,255],"width":2},"value":"Rehabilitation (Rehab)","label":"Rehabilitation (Rehab)"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[116,93,245,255],"toColor":[116,93,245,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,237,88,255],"toColor":[212,237,88,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[250,110,136,255],"toColor":[250,110,136,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[72,158,171,255],"toColor":[72,158,171,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[130,114,51,255],"toColor":[130,114,51,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[230,165,250,255],"toColor":[230,165,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[117,250,179,255],"toColor":[117,250,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[47,63,128,255],"toColor":[47,63,128,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[140,79,114,255],"toColor":[140,79,114,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[56,130,84,255],"toColor":[56,130,84,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[230,170,154,255],"toColor":[230,170,154,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[98,250,87,255],"toColor":[98,250,87,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[108,150,224,255],"toColor":[108,150,224,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
ProjectID (type: esriFieldTypeDouble, alias: ProjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Project_ID (type: esriFieldTypeInteger, alias: Project ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
OBJECTID_1 (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
ObjectID_12 (type: esriFieldTypeInteger, alias: ObjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_Points (type: esriFieldTypeInteger, alias: Total Points, SQL Type: sqlTypeOther, nullable: true, editable: true)
Project_Name (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Phase_I_Score (type: esriFieldTypeInteger, alias: Phase I Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
Submitting_Agency (type: esriFieldTypeString, alias: Submitting Agency, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Geographic_Location1 (type: esriFieldTypeString, alias: Geographic Location1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Geographic_2 (type: esriFieldTypeString, alias: Geographic 2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Does_this_include_work_in_the_i (type: esriFieldTypeString, alias: Does this include work in the intersection(s)?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Please_provide_any_additional_i (type: esriFieldTypeString, alias: Please provide any additional information about the project limits., SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Project_Lane_Mile (type: esriFieldTypeDouble, alias: Project Lane Mile, SQL Type: sqlTypeOther, nullable: true, editable: true)
Year_s__Applying_For_ (type: esriFieldTypeInteger, alias: Year(s) Applying For:, SQL Type: sqlTypeOther, nullable: true, editable: true)
Project_Justification (type: esriFieldTypeString, alias: Project Justification, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Total_Estimated_Project_Cost (type: esriFieldTypeString, alias: Total Estimated Project Cost, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Amount_of_Non_participating_Pro (type: esriFieldTypeString, alias: Amount of Non-participating Project Costs included in previous question_Phase I, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Total_Amount_of_Federal_Aid_Eli (type: esriFieldTypeString, alias: Total Amount of Federal-Aid Eligible Project Cost_Phase I, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Total_Amount_of_Federal_Aid_Req (type: esriFieldTypeString, alias: Total Amount of Federal-Aid Requested_Phase I, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Planned_Investment_Category (type: esriFieldTypeString, alias: Planned Investment Category, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
How_many_lanes_does_the_new_pro (type: esriFieldTypeInteger, alias: How many lanes does the new proposed facility have?, SQL Type: sqlTypeOther, nullable: true, editable: true)
Project_Lane_Mile_1 (type: esriFieldTypeDouble, alias: Project Lane Mile, SQL Type: sqlTypeOther, nullable: true, editable: true)
Project_Impact_and_Coordination (type: esriFieldTypeString, alias: Project Impact and Coordination, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
National_Functional_Classificat (type: esriFieldTypeString, alias: National Functional Classification, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
National_Highway_System (type: esriFieldTypeString, alias: National Highway System, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
MCDR_Corridor_of_Significance (type: esriFieldTypeString, alias: MCDR Corridor of Significance, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Macomb_County_Critical_Linkages (type: esriFieldTypeString, alias: Macomb County Critical Linkages, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Existing_Pavement_Type (type: esriFieldTypeString, alias: Existing Pavement Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Pavement_Surface_Condition (type: esriFieldTypeInteger, alias: Pavement Surface Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
Year_of_Eval (type: esriFieldTypeInteger, alias: Year of Eval, SQL Type: sqlTypeOther, nullable: true, editable: true)
RFF (type: esriFieldTypeInteger, alias: RFF, SQL Type: sqlTypeOther, nullable: true, editable: true)
Project_Support (type: esriFieldTypeString, alias: Project Support, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Total_Plans (type: esriFieldTypeInteger, alias: Total Plans, SQL Type: sqlTypeOther, nullable: true, editable: true)
Other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Project_Support_Documentation (type: esriFieldTypeString, alias: Project Support Documentation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Previous_Roadway_Reconstruction (type: esriFieldTypeInteger, alias: Previous Roadway Reconstructions, SQL Type: sqlTypeOther, nullable: true, editable: true)
Date_of_Last_Major_Project (type: esriFieldTypeString, alias: Date of Last Major Project, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Year (type: esriFieldTypeString, alias: Year, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Previous_Road_Work (type: esriFieldTypeString, alias: Previous Road Work, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Average_Annual_Daily_Traffic__A (type: esriFieldTypeString, alias: Average Annual Daily Traffic (AADT), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Commercial_Average_Annual_Daily (type: esriFieldTypeString, alias: Commercial Average Annual Daily Traffic (CAADT), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
High_Frequency_Crash_Locations (type: esriFieldTypeString, alias: High-Frequency Crash Locations, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Targeted_Deficiencies (type: esriFieldTypeString, alias: Targeted Deficiencies, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Targeted_Deficiencies___additio (type: esriFieldTypeString, alias: Targeted Deficiencies - additional information, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Drainage_or_Access (type: esriFieldTypeString, alias: Drainage or Access, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Roadside_Improvements (type: esriFieldTypeString, alias: Roadside Improvements, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Project_Support_1 (type: esriFieldTypeString, alias: Project Support, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Coordination_with_Other_Agencie (type: esriFieldTypeString, alias: Coordination with Other Agencies and Organizations, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Other_1 (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Coordination (type: esriFieldTypeInteger, alias: Coordination, SQL Type: sqlTypeOther, nullable: true, editable: true)
Applicant_Priority (type: esriFieldTypeString, alias: Applicant Priority, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Applicant_Priority_1 (type: esriFieldTypeString, alias: Applicant Priority, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Applicant_Priority_12 (type: esriFieldTypeString, alias: Applicant Priority, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Additional_Funding_Sources (type: esriFieldTypeString, alias: Additional Funding Sources, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Additional_Funding_Sources_1 (type: esriFieldTypeString, alias: Additional Funding Sources, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Cost_per_Lane_Mile (type: esriFieldTypeString, alias: Cost per Lane Mile, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Notes_based_on_responses (type: esriFieldTypeString, alias: Notes based on responses, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Key_Scope_Elements (type: esriFieldTypeString, alias: Were Key Scope Elements Changed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Updates_to_Key_Scope_Elements (type: esriFieldTypeString, alias: Updates to Key Scope Elements, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Location__roadway_ (type: esriFieldTypeString, alias: Location (roadway) Changes, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Location___feedback (type: esriFieldTypeInteger, alias: Location - feedback, SQL Type: sqlTypeOther, nullable: true, editable: true)
Limits (type: esriFieldTypeString, alias: Changes to Limits, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Limits___feedback (type: esriFieldTypeString, alias: Limits - feedback, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Planned_Investment_Category_1 (type: esriFieldTypeString, alias: Changes to Planned Investment Category, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Investment_Category___feedback (type: esriFieldTypeString, alias: Investment Category - feedback, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
ADT (type: esriFieldTypeInteger, alias: ADT, SQL Type: sqlTypeOther, nullable: true, editable: true)
CADT (type: esriFieldTypeInteger, alias: CADT, SQL Type: sqlTypeOther, nullable: true, editable: true)
Statement_of_Contribution_to_Co (type: esriFieldTypeString, alias: Statement of Contribution to Countywide Network, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Contribution_Points (type: esriFieldTypeString, alias: Contribution Points, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Right_Fix_Factor (type: esriFieldTypeString, alias: Right Fix Factor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
RFF_Points (type: esriFieldTypeInteger, alias: RFF Points, SQL Type: sqlTypeOther, nullable: true, editable: true)
Pavement_Repair (type: esriFieldTypeString, alias: Pavement Repair, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Pavement_Repair_Points (type: esriFieldTypeInteger, alias: Pavement Repair Points, SQL Type: sqlTypeOther, nullable: true, editable: true)
Aggregate_Base_Repair (type: esriFieldTypeString, alias: Aggregate Base Repair, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Agg_Base_Points (type: esriFieldTypeInteger, alias: Agg Base Points, SQL Type: sqlTypeOther, nullable: true, editable: true)
Drainage (type: esriFieldTypeString, alias: Drainage, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Drainage_Points (type: esriFieldTypeInteger, alias: Drainage Points, SQL Type: sqlTypeOther, nullable: true, editable: true)
Safety_Countermeasures (type: esriFieldTypeString, alias: Safety Countermeasures, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Safety_points (type: esriFieldTypeString, alias: Safety points, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Planned_Investment_Category_12 (type: esriFieldTypeString, alias: Planned Investment Category, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Existing_PASER_Rating (type: esriFieldTypeInteger, alias: Existing PASER Rating, SQL Type: sqlTypeOther, nullable: true, editable: true)
Expected_PASER_Rating (type: esriFieldTypeInteger, alias: Expected PASER Rating, SQL Type: sqlTypeOther, nullable: true, editable: true)
Preferred_Project_Development_P (type: esriFieldTypeString, alias: Preferred Project Development Plan, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
ROW_and_Utilities (type: esriFieldTypeString, alias: ROW and Utilities, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Submitting_Agency_1 (type: esriFieldTypeString, alias: Submitting Agency, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Funding_Obligations (type: esriFieldTypeString, alias: Funding Obligations, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Phase_II_Cost_Estimate (type: esriFieldTypeString, alias: Phase II Cost Estimate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
F__Change (type: esriFieldTypeString, alias: $ Change between Phase I and Phase II, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
F81_85__Fed_Aid (type: esriFieldTypeString, alias: 81.85% Fed Aid Amount, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Cost_per_Lane_Mile_1 (type: esriFieldTypeString, alias: Cost per Lane Mile (Phase II), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
APP (type: esriFieldTypeString, alias: APP, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
HDC (type: esriFieldTypeString, alias: HDC, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Project_Impact_and_Coordinati_1 (type: esriFieldTypeString, alias: Project Impact and Coordination, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Public_Transportation (type: esriFieldTypeString, alias: Public Transportation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Public_tranport___feedback (type: esriFieldTypeString, alias: Public tranport - feedback, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Non_Motorized_Active (type: esriFieldTypeString, alias: Non-Motorized/Active Transportation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Fiscal_Year (type: esriFieldTypeString, alias: Fiscal Year, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SEMCOG_RTP_Goals (type: esriFieldTypeString, alias: SEMCOG RTP Goals, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SEMCOG_Goals___feedback (type: esriFieldTypeString, alias: SEMCOG Goals - feedback, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Additional_Information (type: esriFieldTypeString, alias: Additional Information, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Text_ID (type: esriFieldTypeString, alias: Text_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

Planned_Investment_Category: Capital Preventive Maintenance

Planned_Investment_Category: Reconstruction (Recon)

Planned_Investment_Category: Reconstruction and Widening (Wi

Planned_Investment_Category: Rehabilitation (Rehab)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

All Layers and Tables (Macomb_County_Final_TIP_Application_Data)

Layers:

Layer: MacombCounty_TIP_Phase_II_Full_Application_Details_attachments (0)