Click for next page ( 47


The National Academies | 500 Fifth St. N.W. | Washington, D.C. 20001
Copyright © National Academy of Sciences. All rights reserved.
Terms of Use and Privacy Statement



Below are the first 10 and last 10 pages of uncorrected machine-read text (when available) of this chapter, followed by the top 30 algorithmically extracted key phrases from the chapter as a whole.
Intended to provide our own search engines and external engines with highly rich, chapter-representative searchable text on the opening pages of each chapter. Because it is UNCORRECTED material, please consider the following text as a useful but insufficient proxy for the authoritative book pages.

Do not use for reproduction, copying, pasting, or reading; exclusively for search engines.

OCR for page 46
46 version in the series, which was published in 1998 in collab- BTS with data support from a large number of agencies. oration with Canada and Mexico (121). NORTAD contained BTS collects data that those agencies produce and/or main- updated NTAD datasets, border crossings, and datasets depict- tain, reprocesses the data into a central repository, and ing Canadian and Mexican transportation infrastructure then makes the data available to users. This approach takes facilities. advantage of existing resources at individual data produc- Early NTAD versions followed an American Standard Code ers while avoiding data collection and data processing for Information Interchange (ASCII) fixed-record-length for- redundancy. BTS's coordination role helps to improve the mat that included six distinct record types, as follows (121): availability and standardization of critical transportation data and metadata. 1. Link (.lnk file extension); Develop spatial data programs that use industry stan- 2. Node (.nod file extension); dards. Originally, NTAD used an ASCII fixed-record-length 3. Point (.pnt file extension); format. However, modern encoding schemes such as 4. Area (.are file extension); Unicode started replacing the ASCII format. In addition, 5. Geography (.geo file extension), which contains shape infor- although data conversion tools to enable the conversion of mation for network links and area boundaries; and NTAD data to other file formats were available, in practice, 6. Attribute (.txx file extensions, e.g., .t01, .t02, and .t03). the ESRI shapefile format became a de facto standard. As a result, since the early 2000s, BTS has published NTAD in Combinations of different record types defined the geom- this format. etry, topology, and attributes of point, network, and area fea- The advantage of using a de facto standard such as the ture types. BTS made these file formats available to GIS ven- ESRI shapefile format is that this format is widely used, dors on a temporary basis to facilitate the development of data which facilitates data exchange. The disadvantage is that conversion software tools. In practice, although BTS intended the shapefile format is an old data format that ESRI no to migrate NTAD to the federal Spatial Data Transfer Standard longer maintains (although ESRI GIS software applica- (SDTS), the ESRI shapefile format became a de facto standard. tions provide shapefile format backward compatibility). As a result, since the early 2000s, BTS has published NTAD in With the introduction of ArcGIS 8 in 1999, ESRI started this format. It is also worth noting that, although ASCII is still using "geodatabases" to store geographic datasets. A geo- in use, it is quickly being replaced by more modern encoding database could be a "personal geodatabase" (in Microsoft schemes such as Unicode. Access format) or an "ArcSDETM geodatabase" (with the A number of agencies contribute data to NTAD, includ- data stored in a relational database such as Oracle, ing BEA, FAA, FHWA, FMCSA, FRA, FTA, the U.S. Census Microsoft Structured Query Language [SQL] Server, IBM DB2, or IBM Informix) (124). Recently, ESRI introduced Bureau, and USACE (Table 7). BTS collects data from these a "file geodatabase" format to address the file size limita- participating agencies and then processes and publishes the data tions of personal databases (Access files cannot exceed within NTAD. Data gathering for NTAD typically starts in 2 gigabytes in size). Although the use of geodatabases is November of each year. In general, data creation, maintenance, increasing, at this point it is not clear to what degree federal update, spatial positional accuracy and resolution, and quality agencies have started to require their use for data exchange control responsibilities remain with the data source agencies. purposes. Depending on data format, quality, and completeness, BTS processes data by checking spatial and attribute data character- istics, inserting additional attribute data, and recompiling meta- General Observations data using the FGDC metadata standard (122). Most data pro- and Lessons Learned cessing takes place in an ESRI ArcGISTM environment. The previous sections included a summary of data sources, systems, and architectures relevant to the freight community. Lessons Learned Table 1 provides a listing of the freight data sources, systems, and architectures reviewed, whereas Appendix A of the con- NTAD is a popular data series that remains an important tractor's final report (available on the project web page) program within BTS and RITA, along with the operation of the includes a detailed description of each data source, system, or FGDC transportation subcommittee (123). Budgetary changes architecture. Although not comprehensive, the review pro- have forced the agency to cut back other GIS programs. vides a sample of the typical data sources, systems, and archi- Lessons learned in connection with the development, evo- tectures that could be included in a national freight data lution, and maintenance of NTAD follow: architecture, as well as any potential implementations that could derive from that data architecture. Implement interagency data exchange programs with In general, the material in Appendix A describes the cur- centralized data coordination. NTAD is a product led by rent status and characteristics of the data sources, systems,

OCR for page 46
47 and architectures reviewed. For the research, it also was impor- portation aspects or components (see Chapters 3 and 4 for a tant to learn about the process, institutional arrangements, more detailed discussion of those aspects and components). and challenges associated with the development and mainte- From this perspective, all of the systems and architectures in nance of the systems, as well as any strategies that have been this report should be included at some level in the design of a deployed to address challenges and other data integration national freight data architecture if this data architecture is issues, such as data quality, timeliness, and proprietary and indeed designed to address the needs of both public and pri- privacy concerns. Given the large number of data sources, sys- vate decisionmakers not just at the national level, but also at tems, and architectures uncovered during the literature search the state and local levels. (49 according to Table 1), it was not practical to conduct a However, identifying which data sources, systems, and comprehensive review of historical developments for all of architectures to include in a national freight data architecture them. However, a few systems and architectures in Table 1 depends to a large degree on the vision that is laid out for this were of interest because of the processes that led to their devel- data architecture. As Chapter 4 describes in more detail, it is opment (e.g., in the form of issues, motivations, challenges, possible to outline a number of competing implementation legislative efforts, and implemented strategies). Lessons learned alternatives, some of them more comprehensive and ambi- from those processes can provide valuable information for, tious in scope than others. For example, a freight data archi- and help to minimize the cost of, the development and imple- tecture that only focuses on commodity flow aspects for plan- mentation of a national freight data architecture. ning purposes at the national level requires data sources, The sample of systems and architectures selected for the systems, and architectures that are both commodity-related detailed historical analysis covered a wide spectrum of topics and relevant at the national level. By comparison, a freight related to freight transportation and included the following: data architecture that includes commodity, transportation network, vehicle, and safety aspects to address the needs of ACE/ITDS, federal and state governments would require the inclusion of Carload Waybill Sample, a larger number of finer resolution data sources, systems, and CFS, architectures. Likewise, a freight data architecture that includes EDI standards, real-time supply chain data from the private sector would FAF, require conducting an analysis of the risks the private sector HPMS, would assume if it shares sensitive and/or confidential data NIPAs, elements that could undermine its competitive position and National ITS Architecture, decisionmaking process. NSDI, and Chapter 4 addresses different implementation alternatives NTAD. that may be possible for a national freight data architecture. However, a summarized list of lessons learned from all of For this sample of systems and architectures, the analysis the systems and architectures reviewed is appropriate here covered several topics, including the following: because many of the lessons learned are sufficiently generic and, consequently, could be used to guide the development Purpose and intended benefits; and implementation of any freight data architecture, regard- Content; less of implementation level. The summarized list of lessons Institutional arrangements used for developing and main- learned follows: taining the system or architecture; Challenges and issues faced in creating and maintaining Develop systems that are relevant to stakeholders, include the architecture or system; adequate stakeholder participation, and provide incentives Strategies and methods for dealing with data integration to encourage participation, particularly in the case of state issues, such as data quality, timeliness, and proprietary and and local entities (ACE/ITDS, NSDI); privacy concerns; Clearly define expected outcomes and development and Adaptability to serve evolving purposes and data sources; coordination plan (ACE/ITDS); and Articulate programs well; provide clear, uniform guidance; Assessment of how well the system or architecture works and provide good documentation (Carload Waybill Sample, in the form of lessons learned. NSDI); Develop applications that rely on widely used data standards In general, all of the systems and architectures reviewed in (EDI standards, National ITS Architecture, NSDI); this report (including those described in detail in this chap- Develop and compare candidate architecture concepts ter) relate to processes that affect one or more freight trans- (National ITS Architecture);

OCR for page 46
48 Consider federal legislation to support and develop the Evaluate data disaggregation level requirements to ensure program (National ITS Architecture); statistical significance (HPMS); Develop tools to measure benefits and costs early (National Provide adequate resources for data collection, fully under- ITS Architecture); stand the implications of small sample sizes, and continue Integrate archived data needs into frameworks and archi- to involve the U.S. Census Bureau for the use of survey tectures early and develop data programs that use industry instruments (CFS); standards (National ITS Architecture, NTAD); Emphasize data access, quality, reliability, confidentiality, Implement interagency data exchange programs with cen- and integrity (Carload Waybill Sample, FAF, NIPAs); tralized data coordination (NTAD); Participate in the standards development process (EDI stan- Use available data sources and develop long-term plans dards, National ITS Architecture, NSDI); while keeping systems flexible to respond to changes and Create crosswalks to ensure compatibility of survey data new data sources (FAF, HPMS, National ITS Architecture); internally over time and externally across other datasets Schedule major and regular revisions effectively while avoid- (CFS); ing scope creep (HPMS, NIPAs); Involve stakeholders early and often through a variety of Develop systems that are consistent with input data limi- mechanisms and technologies (ACE/ITDS, FAF, HPMS, tations (FAF); National ITS Architecture); and Develop applications with backward compatibility (EDI Develop and implement professional capacity and training standards); programs early (National ITS Architecture).