https://www.transitwiki.org/TransitWiki/index.php?title=Urban_Integrated_National_Transit_Database&feed=atom&action=historyUrban Integrated National Transit Database - Revision history2024-03-29T06:53:00ZRevision history for this page on the wikiMediaWiki 1.35.1https://www.transitwiki.org/TransitWiki/index.php?title=Urban_Integrated_National_Transit_Database&diff=4243&oldid=prevRabiabonour: /* How it Works */2017-05-31T20:43:28Z<p><span dir="auto"><span class="autocomment">How it Works</span></span></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 20:43, 31 May 2017</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l4" >Line 4:</td>
<td colspan="2" class="diff-lineno">Line 4:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==How it Works==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==How it Works==</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Transit agencies that receive funds from the Federal Transit Administration (FTA) are required to report operating data to the NTD. About 850 agencies are included in the database<ref>[https://www.transit.dot.gov/ntd/what-national-transit-database-ntd-program Federal Transit Administration. "What is the National Transit Database?" 2016.]</ref><del class="diffchange diffchange-inline">. </del>This information is technically public, but is presented as a series of excel files which require knowledge of the data schema to use and experience with Microsoft Excel in order to analyze. iNTD brings all of this information into a central system. The data can be sorted by agency, year, and individual NTD forms.</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Transit agencies that receive funds from the Federal Transit Administration (FTA) are required to report operating data to the NTD. About 850 agencies are included in the database<ins class="diffchange diffchange-inline">.</ins><ref>[https://www.transit.dot.gov/ntd/what-national-transit-database-ntd-program Federal Transit Administration. "What is the National Transit Database?" 2016.]</ref> This information is technically public, but is presented as a series of excel files which require knowledge of the data schema to use and experience with Microsoft Excel in order to analyze. iNTD brings all of this information into a central system. The data can be sorted by agency, year, and individual NTD forms.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Peer Comparisons==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Peer Comparisons==</div></td></tr>
</table>Rabiabonourhttps://www.transitwiki.org/TransitWiki/index.php?title=Urban_Integrated_National_Transit_Database&diff=3801&oldid=prevRabiabonour at 19:55, 12 February 20172017-02-12T19:55:24Z<p></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 19:55, 12 February 2017</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Ftis1.jpg|right|thumb|600px|iNTD lets users search NTD data using a simple interface. Source: [http://www.ftis.org/ FTIS]]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Ftis1.jpg|right|thumb|600px|iNTD lets users search NTD data using a simple interface. Source: [http://www.ftis.org/ FTIS]]]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Introduction==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Introduction==</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>The National Transit Database (NTD) is important source of data for transit agencies, especially for benchmarking performance and planning service. While most of these data are publicly available, they are cumbersome to access, especially when comparing multiple agencies or years. The Florida Transit Information System (FTIS) makes it easy to examine NTD information with a free web-based tool called the Urban Integrated National Transit Database (Urban iNTD). Developed by Florida International University’s Lehman Center for Transportation Research for the Florida Department of Transportation, this tool gives transit planners an increased ability to both retrieve and analyze NTD data.</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>The <ins class="diffchange diffchange-inline">[[National Transit Database | </ins>National Transit Database (NTD)<ins class="diffchange diffchange-inline">]] </ins>is important source of data for transit agencies, especially for benchmarking performance and planning service. While most of these data are publicly available, they are cumbersome to access, especially when comparing multiple agencies or years. The Florida Transit Information System (FTIS) makes it easy to examine NTD information with a free web-based tool called the Urban Integrated National Transit Database (Urban iNTD). Developed by Florida International University’s Lehman Center for Transportation Research for the Florida Department of Transportation, this tool gives transit planners an increased ability to both retrieve and analyze NTD data.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==How it Works==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==How it Works==</div></td></tr>
</table>Rabiabonourhttps://www.transitwiki.org/TransitWiki/index.php?title=Urban_Integrated_National_Transit_Database&diff=3285&oldid=prevJmatute at 20:07, 19 December 20162016-12-19T20:07:57Z<p></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 20:07, 19 December 2016</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Ftis1.jpg|right|thumb|600px|iNTD lets users search NTD data using a simple interface. Source: [http://www.ftis.org/ FTIS]]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Ftis1.jpg|right|thumb|600px|iNTD lets users search NTD data using a simple interface. Source: [http://www.ftis.org/ FTIS]]]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Introduction==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Introduction==</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">Information from the </del>National Transit Database (NTD) is <del class="diffchange diffchange-inline">vitally </del>important <del class="diffchange diffchange-inline">to </del>transit agencies for benchmarking performance and planning service. While most of these data are <del class="diffchange diffchange-inline">publically </del>available, they are cumbersome to access, especially when comparing multiple agencies or years. The Florida Transit Information System (FTIS) makes it easy to examine <del class="diffchange diffchange-inline">this </del>information with a free web-based tool called the Urban Integrated National Transit Database (Urban iNTD). Developed by Florida International University’s Lehman Center for Transportation Research for the Florida Department of Transportation, this tool gives transit planners an increased ability to both retrieve and analyze NTD data.</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">The </ins>National Transit Database (NTD) is important <ins class="diffchange diffchange-inline">source of data for </ins>transit agencies<ins class="diffchange diffchange-inline">, especially </ins>for benchmarking performance and planning service. While most of these data are <ins class="diffchange diffchange-inline">publicly </ins>available, they are cumbersome to access, especially when comparing multiple agencies or years. The Florida Transit Information System (FTIS) makes it easy to examine <ins class="diffchange diffchange-inline">NTD </ins>information with a free web-based tool called the Urban Integrated National Transit Database (Urban iNTD). Developed by Florida International University’s Lehman Center for Transportation Research for the Florida Department of Transportation, this tool gives transit planners an increased ability to both retrieve and analyze NTD data.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==How it Works==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==How it Works==</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Transit agencies that receive funds from the Federal Transit Administration (FTA) are required to report operating data to the NTD. About 850 agencies are included in the database<ref>[https://www.transit.dot.gov/ntd/what-national-transit-database-ntd-program Federal Transit Administration. "What is the National Transit Database?" 2016.]</ref>. This information is technically public, but <del class="diffchange diffchange-inline">it </del>is <del class="diffchange diffchange-inline">difficult </del>to <del class="diffchange diffchange-inline">access. The FTA keeps limited data online </del>and <del class="diffchange diffchange-inline">makes you retrieve it one sheet at a time</del>. iNTD brings all of this information into a central system. The data can be sorted by agency, year, and individual NTD forms.</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Transit agencies that receive funds from the Federal Transit Administration (FTA) are required to report operating data to the NTD. About 850 agencies are included in the database<ref>[https://www.transit.dot.gov/ntd/what-national-transit-database-ntd-program Federal Transit Administration. "What is the National Transit Database?" 2016.]</ref>. This information is technically public, but is <ins class="diffchange diffchange-inline">presented as a series of excel files which require knowledge of the data schema </ins>to <ins class="diffchange diffchange-inline">use </ins>and <ins class="diffchange diffchange-inline">experience with Microsoft Excel in order to analyze</ins>. iNTD brings all of this information into a central system. The data can be sorted by agency, year, and individual NTD forms.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Peer Comparisons==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Peer Comparisons==</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>One of the most useful features of iNTD is the ability to easily compare an agency to its peers. Peer comparison is useful for benchmarking performance against comparable agencies and for understanding how agencies with different funding structures, riderships, or other factors operate.</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>One of the most useful features of iNTD is the ability to easily compare an agency to its peers. Peer comparison is useful for benchmarking performance against comparable agencies and for understanding how agencies with different funding structures, riderships, or other factors operate.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>The first step in the comparison process is <del class="diffchange diffchange-inline">setting your </del>peer group. After inputting an agency, iNTD will automatically identify potential matches and sort them by how comparable they are. A user can then manually trim down this list to the desired peer agencies. The comparison can be filtered to look at entire agencies or specific modes (bus, rail, etc.) and can distinguish between directly operated and purchased service. This step also allows the user to select what years to use in the analysis. NTD data is <del class="diffchange diffchange-inline">not always up-to-date</del>, so the most recent years <del class="diffchange diffchange-inline">will likely </del>be <del class="diffchange diffchange-inline">incomplete</del>.</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>The first step in the comparison process is <ins class="diffchange diffchange-inline">to establish an agency's </ins>peer group. After inputting an agency, iNTD will automatically identify potential matches and sort them by how comparable they are. A user can then manually trim down this list to the desired peer agencies. The comparison can be filtered to look at entire agencies or specific modes (bus, rail, etc.) and can distinguish between directly operated and purchased service. This step also allows the user to select what years to use in the analysis. NTD data is <ins class="diffchange diffchange-inline">published in the fall for the preceding year</ins>, so the most recent years <ins class="diffchange diffchange-inline">may not </ins>be <ins class="diffchange diffchange-inline">available</ins>.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Ftis2.jpg|right|thumb|400px|A partial example of a report generated by iNTD. Source: [http://www.ftis.org/ FTIS]]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:Ftis2.jpg|right|thumb|400px|A partial example of a report generated by iNTD. Source: [http://www.ftis.org/ FTIS]]]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Once the peer group is established, the next step is to select performance measures. NTD measures can be selected individually, but iNTD also allows for the selection of predefined variable groups. Once the desires variables have been selected, they can be saved as a new group for future use.</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Once the peer group is established, the next step is to select performance measures. NTD measures can be selected individually, but iNTD also allows for the selection of predefined variable groups. Once the desires variables have been selected, they can be saved as a new group for future use.</div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l34" >Line 34:</td>
<td colspan="2" class="diff-lineno">Line 34:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>: This report contains both illustrated instructions for using iNTD and a more in-depth framework for measuring performance and comparing it to peer agencies. Note: iNTD was previously called INTDAS, which is what the report refers to it as. The instructions are still relevant.</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>: This report contains both illustrated instructions for using iNTD and a more in-depth framework for measuring performance and comparing it to peer agencies. Note: iNTD was previously called INTDAS, which is what the report refers to it as. The instructions are still relevant.</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[Category:Applications]]</ins></div></td></tr>
</table>Jmatutehttps://www.transitwiki.org/TransitWiki/index.php?title=Urban_Integrated_National_Transit_Database&diff=3281&oldid=prevRabiabonour: Created page with "iNTD lets users search NTD data using a simple interface. Source: [http://www.ftis.org/ FTIS] ==Introduction== Information from the Natio..."2016-12-17T19:13:47Z<p>Created page with "<a href="/TransitWiki/index.php/File:Ftis1.jpg" title="File:Ftis1.jpg">right|thumb|600px|iNTD lets users search NTD data using a simple interface. Source: [http://www.ftis.org/ FTIS</a>] ==Introduction== Information from the Natio..."</p>
<p><b>New page</b></p><div>[[Image:Ftis1.jpg|right|thumb|600px|iNTD lets users search NTD data using a simple interface. Source: [http://www.ftis.org/ FTIS]]]<br />
==Introduction==<br />
Information from the National Transit Database (NTD) is vitally important to transit agencies for benchmarking performance and planning service. While most of these data are publically available, they are cumbersome to access, especially when comparing multiple agencies or years. The Florida Transit Information System (FTIS) makes it easy to examine this information with a free web-based tool called the Urban Integrated National Transit Database (Urban iNTD). Developed by Florida International University’s Lehman Center for Transportation Research for the Florida Department of Transportation, this tool gives transit planners an increased ability to both retrieve and analyze NTD data.<br />
<br />
==How it Works==<br />
Transit agencies that receive funds from the Federal Transit Administration (FTA) are required to report operating data to the NTD. About 850 agencies are included in the database<ref>[https://www.transit.dot.gov/ntd/what-national-transit-database-ntd-program Federal Transit Administration. "What is the National Transit Database?" 2016.]</ref>. This information is technically public, but it is difficult to access. The FTA keeps limited data online and makes you retrieve it one sheet at a time. iNTD brings all of this information into a central system. The data can be sorted by agency, year, and individual NTD forms.<br />
<br />
==Peer Comparisons==<br />
One of the most useful features of iNTD is the ability to easily compare an agency to its peers. Peer comparison is useful for benchmarking performance against comparable agencies and for understanding how agencies with different funding structures, riderships, or other factors operate.<br />
<br />
The first step in the comparison process is setting your peer group. After inputting an agency, iNTD will automatically identify potential matches and sort them by how comparable they are. A user can then manually trim down this list to the desired peer agencies. The comparison can be filtered to look at entire agencies or specific modes (bus, rail, etc.) and can distinguish between directly operated and purchased service. This step also allows the user to select what years to use in the analysis. NTD data is not always up-to-date, so the most recent years will likely be incomplete.<br />
[[Image:Ftis2.jpg|right|thumb|400px|A partial example of a report generated by iNTD. Source: [http://www.ftis.org/ FTIS]]]<br />
Once the peer group is established, the next step is to select performance measures. NTD measures can be selected individually, but iNTD also allows for the selection of predefined variable groups. Once the desires variables have been selected, they can be saved as a new group for future use.<br />
<br />
After the peer group and performance measures have been specified, iNTD will retrieve the data. There are multiple ways that the data can be presented. It is possible to look at the actual NTD forms, though this is the least clear way of exploring the data. To get a quick snapshot of the information, the tool can create summary reports looking at mode data for either a single agency across all selected years or all selected agencies for a single year.<br />
<br />
For more in-depth analysis, iNTD can create a table containing all the selected data. iNTD provides tools within the app that lets users sort the data, adjust monetary values for inflation, make charts, and perform summations and regressions. The table can also be exported as an Excel file for further work.<br />
<br />
==Case Studies==<br />
===San Jose, CA===<br />
When looking to assess the efficacy of its light rail maintenance program, the Santa Clara Valley Transportation Authority (VTA) turned in part to iNTD. The tool helped the agency establish a peer group, which it then edited to account for VTA’s specific vehicle type. VTA also used iNTD to retrieve data for variables such as fleet age, miles of track, and maintenance costs. The analysis shows that, even after accounting for high labor costs in the San Francisco Bay Area, VTA has very high maintenance costs compared to its peers. The data also showed that VTA has an unusually high spare ratio, which could drive some of these costs.<br />
<br />
===Knoxville, TN===<br />
Most of the funding for Knoxville Area Transit comes from the city’s general fund. The agency was curious to see how its performance compared to agencies that are similar, but have a dedicated funding source. It selected a peer group and used NTD data to eliminate agencies without dedicated funding. It then found data for variables like operating expense per capita, boardings per revenue hour, and percentage of operating costs that are subsidized. It discovered while the region’s investment in transit is relatively low, the agency’s service compares well to its peers.<br />
<br />
==[http://www.ftis.org/urban_iNTD.aspx Urban Integrated National Transit Database]==<br />
<br />
==References==<br />
<references /><br />
<br />
==Additional Reading==<br />
<br />
[http://www.trb.org/Publications/Blurbs/163872.aspx Parks, J., Ryus, P., Coffel, K. Gan, A., Perk, V., Cherrington, L., Arndt, J., & Nakanishi, Y. (2010). A Methodology for Performance Measurement and Peer Comparison in the Public Transportation Industry. Transit Cooperative Research Program.]<br />
<br />
: This report contains both illustrated instructions for using iNTD and a more in-depth framework for measuring performance and comparing it to peer agencies. Note: iNTD was previously called INTDAS, which is what the report refers to it as. The instructions are still relevant.</div>Rabiabonour