NYCPlanning / db-data-library

📚 Data Library
https://nycplanning.github.io/db-data-library/library/index.html
MIT License
0 stars 1 forks source link

Update URL for `usdot_ports` #342

Closed mbh329 closed 1 year ago

mbh329 commented 1 year ago

One reviewer required. Addresses issue #341.

After some more sleuthing, I found a dataset that matches the older version of the usdot_ports dataset we need for facilities database. To test, you can run this locally (withour pushing to s3) and view the file as a csv. This dataset contains records "_The location of a manmade water-land interface structure often used for access to boats or ships.

The Docks dataset was compiled on June 08, 2020 from the United States Army Corp of Engineers (USACE) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The dataset contains physical information on commercial facilities at U.S. Coastal, Great Lakes and Inland Ports. The data consists of location description, street address, city, county name, congressional district FIPS code, type of construction, cargo-handling equipment, water depth alongside the facility, facility type (dock, fleeting area, lock and/or dam) berthing space, latitude, longitude, current operators and owner's information, list of commodities handled at facility, road/railway connections, equipment available at facility, storage facilities, cranes, transit sheds, grain elevators, marine repair plants, fleeting areas, and docking, and facility start/stop date._"

AmandaDoyle commented 1 year ago

@mbh329 - glad you found this. The dataset looks good and I confirmed that all fields that it has the fields that are needed for FacDB and we do not need to change field names.