Sandy DOT - Local Aid Master Data | Last Updated 14 Jul 2017

THIS DATASET IS FINAL AND NO FURTHER UPDATES ARE EXPECTED. This is a report for all the relevant columns of DOT Local Aid - The Amount Allocated, Obligated and Paid broken down by federal agency, program, site, route, location, county, and municipality. It also includes description of repair being done.

Tags: dot, sandy, sandy-master, local aid

This dataset has the following 30 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
StatusstatustextCurrent status of project. Valid Value: Completed
As of Dateas_of_datecalendar_dateAgency data is up to date as of this date
Federal Agencyfederal_agencytextFederal Agency corresponding to the State Agency. Valid value: US DOT
Funding Sourcefunding_sourcetextFederal Agency that is the funding source for the state Agency, DOT – Local Aid. Valid value: Local Aid
Program Descriptionprogram_descriptiontextShort Description of the Emergency Relief program or any new program
Projectproject_nametextThe name of a DOT – Local Aid project related to Superstorm Sandy. For example: NJ13-01-ATL2
Project Descriptionproject_descriptiontextA textual description of a DOT – Local Aid project related to Superstorm Sandy. For example: NJ13-01-ATL2 = Repair and replace damaged traffic signal components.
Project Typeproject_typetextThe type of project that the funds are being used for
CountycountytextThis is the name of a county where a Superstorm Sandy related project was worked on. This column may have a single name of a county, a value of 'Statewide' for projects being worked on at a State level, or it will contain the value 'Multi County' for those projects that cross more than on County. A comma separated list of multiple counties relating to one project detail is in the column.
MunicipalitymunicipalitytextThis is the Municipality name or names that pertain to a particular project detail. This column may contain either one Municipality Name, multiple Municipality Names separated by commas, 'statewide', etc.
VendorvendortextVendor Name. The name of a vendor who is doing work for DOT – Local Aid on Superstorm Sandy-related projects(s). NPO, direct vendors
Applicantapplicant_nametextApplicant/recipient of the funds. Example: Local Aid
RouteroutetextThe roadway generally affected by the storm.
DirectiondirectiontextThe direction of the roadway where work is occurring.
Mile Post Startmp_starttextThe mile post marker where the work begins.
Mile Post Endmp_endtextThe mile post marker where the work ends.
LocationlocationtextGeneral description of the location of the work.
Damage Descriptiondescription_of_damagetextBrief Description of the proper work done at the particular site to return damaged area to Pre-Sandy conditions.
Structure #structure_numbertextParticular Structure being worked on.
Completion Dateproject_completion_datecalendar_dateThe date when the work was completed.
FHWA Obligated Amountfhwa_oblgtd_amtnumberAmount of money the Federal Highway Administration (FHWA) has set-aside for a particular project. This amount may not include total cost, but rather reflects the amount that FHWA will reimburse for a particular project. FHWA will reimburse 80, 90 or 100% of the project costs depending upon the type of project.
Labor Amountactual_labornumberThe cost of labor for the project.
Equipment Amountactual_equipmentnumberThe cost of equipment needed for the project.
Material Amountactual_materialnumberThe cost of material needed for the project.
Total Costtotal_costnumberThe total cost of the project, including both FHWA reimbursed amounts and other costs.
Awaiting FHWA Amountawaiting_fhwa_approvalnumberMoney paid out by the New Jersey Department of Transportation in advance of the expected reimbursement from FHWA.
FHWA Reimbursement Amountfhwa_rmbrsmnt_amtnumberThe amount of money actually reimbursed by FHWA.
Agency Costagency_actual_costnumberThe amount of money actually expended by the agency administering the project. This may reflect an amount more or less than the FHWA reimbursed amount depending upon timing and the FHWA reimbursement rate.
Obligated Amountobligated_amountnumberFunds committed to this project but not yet spent
Disbursed Amountdisbursed_amountnumberMeasureable quantity for which the funds were disbursed