TransStructures_TRANSTRUC

Metadata:

• Identification_Information
• Data_Quality_Information
• Spatial_Data_Organization_Information
• Spatial_Reference_Information
• Entity_and_Attribute_Information
• Distribution_Information
• Metadata_Reference_Information

Identification_Information:

Citation:

Citation_Information:

Originator: VCGI GIS Database Administrator

Publication_Date: 20080616

Publication_Time: unknown

Title: TransStructures_TRANSTRUC

Edition: 2008A

Geospatial_Data_Presentation_Form: vector digital data

Series_Information:

Series_Name: VT Bridges and Culverts (transportation structures)

Issue_Identification: 2008A

Publication_Information:

Publication_Place: Waterbury VT 05676

Publisher: GIS Database Administrator

Other_Citation_Details: Tile Structure - STATE

Online_Linkage:

<http://www.vcgi.org/dataware/default.cfm?layer=TransStructures_TRANSTRUC>

Online_Linkage: <http://apps.vtrans.vermont.gov/BridgeAndCulvert>

Online_Linkage:

<http://www.vcgi.org/techres/white_papers/bcfaq/VT_BridgeCulvertData_FAQ.pdf>

Description:

Abstract:

TRANSTRUC is a statewide bridge and culvert database of transportation structures. It includes all bridges and culverts inventoried by the Vermont Agency of Transportation (VTrans). It also include some local culvert and bridge information collected by RPCs and Municipalities. Additionally, the dataset includes subset of structures inventoried by the Vermont Agency of Natural Resources (ANR) in support of their Geomorphic Assessment Initiative.
TRANSTRUC has been developed in accordance with the "VGIS Bridge & Culvert Data Exchange Standard" (<http://www.vcgi.org/techres/standards/>). The database is distributed as an MS Access 2000 database containing multiple tables.
There are 4 tables of primary interest, including 1) BC_LocalInventoryTable, 2) BC_VTransInventoryTable_Primary, 3) BC_VTransInventoryTable_Other, and 4) BC_GeomorphicInventoryTable. The X_COORD/Y_COORD values in these tables can be used to generate a GIS layer (search for "x,y, coordinate data, adding to maps" in the ArcGIS help Index). Refer to the VGIS B/C Standard for additional information about the tables and attributes in the TRANSTRUC.MDB database. VCGI also offers the database in two other formats; 1) ESRI shapefile and 2) ESRI ArcGIS Personal Geodatabase.
WARNING! DO NOT perform updates to TRANSTRUC data downloaded from VCGI! All local/municipal inventory updates performed by RPCs, towns, and consultants should be done by using the "Vermont Online Bridge and Culvert Inventory Tool (VOBCIT)". Refer to the URL below.
<http://apps.vtrans.vermont.gov/BridgeAndCulvert>
Refer to the following FAQ for additional information:
<http://www.vcgi.org/techres/white_papers/bcfaq/VT_BridgeCulvertData_FAQ.pdf>

Purpose:

To provide users with a single statewide bridge and culvert dataset for Vermont. The TRANSTRUC database is maintained collaboratively between several organizations including VTrans, ANR, Vermont's RPCs, and municipalities.

Time_Period_of_Content:

Time_Period_Information:

Single_Date/Time:

Calendar_Date: 20080616

Currentness_Reference: Publication date

Status:

Progress: Complete

Maintenance_and_Update_Frequency: As needed

Spatial_Domain:

Bounding_Coordinates:

West_Bounding_Coordinate: -73.454162

East_Bounding_Coordinate: -71.465281

North_Bounding_Coordinate: 45.018361

South_Bounding_Coordinate: 42.722789

Keywords:

Theme:

Theme_Keyword_Thesaurus: ISO 19115 Topic Category

Theme_Keyword: transportation

Theme:

Theme_Keyword_Thesaurus: None

Theme_Keyword: bridges

Theme_Keyword: culverts

Theme_Keyword: road

Theme_Keyword: transportation

Theme_Keyword: structure

Theme_Keyword: geomorphic assessment

Theme_Keyword: geomorphology

Place:

Place_Keyword_Thesaurus: None

Place_Keyword: Vermont

Access_Constraints:

VCGI and the State of VT make no representations of any kind, including but not limited to the warranties of merchantability or fitness for a particular use, nor are any such warranties to be implied with respect to the data.

Use_Constraints: None.

Point_of_Contact:

Contact_Information:

Contact_Organization_Primary:

Contact_Organization: VT Center for Geographic Information

Contact_Address:

Address_Type: Mailing and Physical Address

Address: 58 South Main Street, Suite 2

City: Waterbury

State_or_Province: VT

Postal_Code: 05676

Country: USA

Contact_Voice_Telephone: 802/882-3000

Contact_TDD/TTY_Telephone: None

Contact_Facsimile_Telephone: 802/882-3001

Contact_Electronic_Mail_Address: info@vcgi.org

Hours_of_Service: 9am - 5pm, M-F

Data_Set_Credit:

Vermont Center for Geographic Information (VCGI), Vermont Agency of Transportation (VTrans), Regional Planning Commissions (RPCs), and Municipalities.

Security_Information:

Security_Classification_System: N/A

Security_Classification: Unclassified

Security_Handling_Description: No Security Considerations

Native_Data_Set_Environment: Arc/Info

Data_Quality_Information:

Attribute_Accuracy:

Attribute_Accuracy_Report:

All attributes have values that are within specific domains as defined by the "VGIS Bridge & Culvert Data Standard". However, there are are number of records that don't meet the standard. They have been flagged with QC_FLAGs (refer to QC_FLAG attribute below). Generally this is limited to a small number of special cases which will be resolved over time.

Logical_Consistency_Report:

The TRANSTRUC data layer includes all bridges and culverts listed in VTrans's Bridge Inventory System (BIS). The BIS includes all long/short structures (long >= 20ft, short < 20ft >= 6ft) on Interstate, U.S., and State highways. It also includes long structures on town highways (class 1,2,3, and 4 roads). The BIS no longer contains inventory records for town shorts. However, VCGI used an old set of town short records from VTran's Mainframe system as a guide. As a result, the TRANSTRUC layer includes all long/short structures on Interstate, U.S., State, and town highways. There are a number of structures with special coding issues. These include bridges along the state border with New Hampshire and New York, those not managed by Vermont (QC_FLAG = NYM or NHM). They were assigned STRUCT_NUMs from the respective state's inventory database and tagged with a QC_FLAG (refer to QC_FLAG documentation in Entity_and_Attribute_Information below). Other special cases include structures that need to be field checked by VTrans (QC_FLAG = FC), structures which potentiall overlap (duplicate) other structures (QC_FLAG = POL), and structures which overlap other structure along a town boundary (QC_FLAG = BNDOL).
ANR GEOMORPHIC ASSESSMENT INVENTORY NOTES: The VT Agency of Natural Resources (ANR) has submitted a copy of its structures data (bridges/culverts) from the Stream Geomorphic Assessment Data Managment System (SGA-DMS) to VCGI for integration into TRANSTRUC. The data was submitted in a format which is compliant with the VGIS B/C Exchange Standard. The data included the following required "state fields" as defined in the standard (as well as geomorph specific attributes). STRUCT_NUM, CATEGORY, LOCMETH, SRCORG, X_COORD, Y_COORD, FIPS6. These attributes were "joined" to the master SGA-DMS records/points using a "spatial join operation" to attach those records in VOBCIT which are within a certain spatial proximity of SGA-DMS records/points. Therefore the values for these 7 fields reflect what is in VOBCIT, not what was actually captured in SGA-DMS. Mismatched records are possible, therefore the data should be used with caution.
LOCAL INVENTORY NOTES (for data provided by RPCs and/or Towns): These notes apply to data originally provided by Towns and/or RPCs to VCGI. VCGI integrated these into TRANSTRUC. These have been subsequently loaded (1/1/2007) into VT Online Bridge & Culvert Inventory Tool (VOBCIT). As a result the following notes are a historically snapshot which will be purged from the metadata as some point in the future.
- Hyde Park (2002 data) VCGI received culvert data from Lamoille County RPC. "Culverts were inventoried before we arrived and distances between culverts were recorded with a wheel. We had hoped to use this information in helping to reconcile what turned out to be spotty GPS data on culverts. (We had 2 different road crew members accompany us, but even with both in the vehicle they were unable to identify many culverts.) The inventory information and the GPS information were very difficult to reconcile. In some cases we collected more culverts than were inventoried and often the distances measured by the town crew appeared unreliable based on our GPS. In the end, we located 470 culverts. Each has an inventory record, though some inventory data are incomplete. Approximately 113 of these culvert point features were not GPS-based but were entered by in post-field review of all the available data." Robert Turner, R. J. Turner Company (sub-contractor to LCPC 2002)
- Barnet, Brighton, Ryegate, and St Johnsbury (2002 data) VCGI received culvert data for these towns from Lyndon State College. The data was reviewed by VCGI. It meet all requirements specified in the "VGIS Bridge & Culvert Data Standard". A few corrections had to be made. The data was then integrated into the master TRANSTRUC layer.
- Bolton, Charlotte, Hinesburg, Huntington, Richmod, Shelburne (2002 data) VCGI received culvert data for these towns from Chittenden County RPC (CCRPC). The information was collected by a CCRPC Intern. The data was reviewed by VCGI. The data generally meet VGIS requirements, however, duplicate STRUCT_NUMs and overlapping points had to be removed by VCGI.
- 85 additional towns were integrated into TRANSTRUC in 2004. Refer to the associated lookup table called TRANSTRUC_INTEGRATION_LOG. This tables includes a list of towns and when the were integrated, along with some notes.
- 36 additional towns were integrated into TRANSTRUC in 2005. Refer to the associated lookup table called TRANSTRUC_INTEGRATION_LOG. This tables includes a list of towns and when the were integrated, along with some notes.
- 62 additional towns were integrated into TRANSTRUC in 2006. Refer to the associated lookup table called TRANSTRUC_INTEGRATION_LOG. This tables includes a list of towns and when the were integrated, along with some notes. The data was then submitted to VTrans for integration into VOBCIT.
- ALL updates after 1/1/2007 have been made via VOBCIT.

Positional_Accuracy:

Horizontal_Positional_Accuracy:

Horizontal_Positional_Accuracy_Report:

A variety of methods and sources were used to create the TransStructures_TRANSTRUC data layer. The majority of the bridge/culvert points were digitized from RF5000 scale digital orthophotography (from the VT Mapping Program). VCGI used the intersection of RF5000 scale roads (TransRoad_RDS) and surface waters for those features that could not be identified on the orthos. A lesser number of points were captured using dynamic segmentation (based on bridge mileage) and points extracted from VTran's Highway Mapping System (HMS). GPS was used to capture most of the local culvert data. Refer to the LOCMETH attribute the determine how a specific point was digitized/located. Many of the bridge and culvert points were derived from existing datasets including data created by VCGI, VTrans, and RPCs. Refer to the SRCORG attribute for more information.

Vertical_Positional_Accuracy:

Lineage:

Source_Information:

Source_Citation:

Citation_Information:

Originator: VTrans

Publication_Date: various

Publication_Time: unknown

Title: VT Online Bridge and Culvert Inventory Tool (VOBCIT)

Geospatial_Data_Presentation_Form: digital data

Publication_Information:

Publication_Place: Montpelier, VT

Publisher: VTrans VOBCIT extract

Source_Scale_Denominator: Generally RF5000 scale data. Refer to LOCMETH attribute.

Type_of_Source_Media: Various. Refer to LOCMETH attribute.

Source_Time_Period_of_Content:

Time_Period_Information:

Single_Date/Time:

Calendar_Date: 20080612

Time_of_Day: Unknown

Source_Currentness_Reference: Publication Date

Source_Citation_Abbreviation: VOBCIT

Source_Contribution: RPCs, Towns, and Consultants

Source_Information:

Source_Citation:

Citation_Information:

Originator: Vermont Agency of Transportation (VTrans)

Publication_Date: various

Publication_Time: unknown

Title: VTrans Bridge Inventory System (BIS) and GIS data

Geospatial_Data_Presentation_Form: digital data

Publication_Information:

Publication_Place: Montpelier, VT

Publisher: VTrans VOBCIT extract

Source_Scale_Denominator: Generally RF5000 scale data. Refer to LOCMETH attribute.

Type_of_Source_Media: Various. Refer to LOCMETH attribute.

Source_Time_Period_of_Content:

Time_Period_Information:

Single_Date/Time:

Calendar_Date: 20080414

Time_of_Day: Unknown

Source_Currentness_Reference: Publication Date

Source_Citation_Abbreviation: VTrans BIS and GIS data

Source_Contribution: VTrans

Source_Information:

Source_Citation:

Citation_Information:

Originator: Vermont Agency of Natural Resources (ANR)

Publication_Date: various

Publication_Time: unknown

Title:

ANR Stream Geomorphic Assessment Data Management System (SGA-DMS)

Geospatial_Data_Presentation_Form: digital data

Publication_Information:

Publication_Place: Waterbury, VT

Publisher: ANR

Source_Scale_Denominator: Generally RF5000 scale data. Refer to LOCMETH attribute.

Type_of_Source_Media: Various. Refer to LOCMETH attribute.

Source_Time_Period_of_Content:

Time_Period_Information:

Single_Date/Time:

Calendar_Date: 20080613

Time_of_Day: Unknown

Source_Currentness_Reference: Publication Date

Source_Citation_Abbreviation: ANR SGA-DMS

Source_Contribution: ANR, RPCs, and contractors

Process_Step:

Process_Description:

VCGI and VTrans completed initial creation of TRANSTRUC data layer. The data layer was QA/QCed by VCGI and VTrans. It meets all requirements specified in the "VGIS Bridge & Culvert Data Standard".

Process_Date: 20021010

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

VCGI received culvert data for 4 towns in the NVDA area from Lyndon State College. The data was reviewed by VCGI. It meet all requirements specified in the "VGIS Bridge & Culvert Data Standard". A few corrections had to be made. The data was then integrated into the master TRANSTRUC layer. Towns include Barnet, Brighton, Ryegate, and St Johnsbury.

Process_Date: 20030115

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

VCGI received an updated version of T_SINVENT_SEC from VTrans. The original one had problems. VCGI loaded the new data into the VGIS Data Warehouse. VCGI also created DBF version to T_SINVENT_PRIM and T_SINVENT_SEC for those who have problems reading the MDB versions. However, the DBF versions have only a small subset of attributes what were DBF compatible.

Process_Date: 20030121

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

VCGI received culvert data for Hyde Park from LCPC. The data was reviewed by VCGI. It was reformated into the VGIS Bridge & Culvert Standard format. A few corrections had to be made. The data was then integrated into the master TRANSTRUC layer. The data included an LINVENT table (TRANSTRUC.LINVENT15025). The table included some no standard items which were retained for local use. Refer to additional notes for Hyde Park under the Logical Consistency Report section.

Process_Date: 20030211

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

VCGI received culvert data for Hyde Park from LCPC. The data was reviewed by VCGI. It was reformated into the VGIS Bridge & Culvert Standard format. A few corrections had to be made. The data was then integrated into the master TRANSTRUC layer. The data included an LINVENT table (TRANSTRUC.LINVENT15025). The table included some no standard items which were retained for local use. Refer to additional notes for Hyde Park under the Logical Consistency Report section.

Process_Date: 20030211

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

VCGI received culvert data for Bolton, Charlotte, Hinesburg, Huntington, Richmod, Shelburne from CCRPC. The data was reviewed by VCGI. It generally meet VGIS Bridge & Culvert Standard requirements. A few corrections had to be made (duplicate STRUCT_NUMs and overlapping points). The <NUM> portion of all STRUCT_NUMs was refreshed for each town. The data included a LINVENT table attributes. The table included some no standard items which were retained for local use (LOCAL_ID,ID_ORIG,WIDTH_IN,HEIGHT_IN). The WIDTH and HEIGHT field units were changed from inches to 100th of a foot. The data was then integrated into the master TRANSTRUC layer.

Process_Date: 20030416

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

VCGI checked-out a copy of TRANSTRUC to VTrans for update on 5/7/2004. An updated version of TRANSTRUC was checked-in on 6/24/2004. UPDATE SUMMARY - VTrans deleted 22 points (refer to TRANSTRUC.DELETED). 17 points were added (UPDACT = A) and 5 were moved (UPDACT = M). Quality control scripts and reports were generated in order to verify compliance with VGIS standards. VCGI resolved some attribute coding problems in the added points (eg: null values). VCGI recalculated all points with a RPC = 'UV' to 'TR' since the Upper Valley RPC no longer services any Vermont towns. The revised data was loaded into the VGIS Data Warehouse. VTrans also provided a new copy of TRANSTRUC_SINVENT.MDB, which includes tables dumped from VTran's Bridge Inventory System (BIS). VCGI created DBF versions of the T_SINVENT_PRIM and T_SINVENT_SEC tables for those who can't read MDB files. However, the DBF versions have only a small subset of attributes what were DBF compatible. VCGI also determine that 7 bridge points did not have matching records in the new TRANSTRUC_SINVENT.MDB dump. This problem has been communicated to VTrans and will hopefully be resolved in the near future. Release 2004-1

Process_Date: 20040629

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

VCGI received 85 towns from a number of RPCs. The data was reviewed by VCGI. Files were reformated into the VGIS Bridge & Culvert Standard format. A few corrections had to be made. The data was then integrated into the master TRANSTRUC layer. Refer to the integration log file (TRANSTRUC.INTEGRATION_LOG) for the list of towns and special notes. Release 2004-2

Process_Date: 20040929

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

INTEGRATION OF VTRANS UPDATES - 2005 1) Checked-out copy of TRANSTRUC to VTrans on 4/28/2005. Checked out as a personal geodatabase. 2) VTrans returned updated copy to VCGI on 6/15/2005 3) Integration notes
Prep work - Selected records out of transtruc_point with UPDACT = M and A (2 records). Saved to transtruc_AddsMoves - Created a VTRANSADDS and VTRANSMOVED coverage - Exported transtruc_modified to INFO file (transtruc.struct_num_changelog). - Exported transtruc_deleted to INFO file (transtruc.deletednew).
Integrate updates
-Deletions - Merged transtruc.deleted with transtruc.deletednew. Added STRUCT_NUM and xy coordinates to delete table. - Deleted 18 points in TRANSTRUC deleted by VTrans (those documented in deletednew). Did not tag 70003200631420X for deletion. No way to determine if TL structure added by VTrans should actually replace the 2 foot diameter culverted by by SW RPC. As a result the point has been kept.
-Adds/Moves - There was one point moved by VTrans (VTRANSMOVED). It was used to replaced the old point. UPDACT = 'M' - QA/QCed VTRANSADDS using chkitems and qc_codes. Found the following problems - Bad CTCODE/FIPS values (FIXED) - POINTIDs = 0 (FIXED) - Bad RPC codes ('UV' no longer supported). (FIXED) - Duplicate STRUCT_NUMs in Moretown (waiting for VTrans response) (FIXED) - - Calculated ANGLE attribute - Appended VTRANSADD to TRANSTRUC
- Corrected BADPTS - Integrated revised QC_FLAG = BADPT points provided by VTrans (replaced previous 6 points). - One changed to QC_FLAG = FC. - Calced QA_FLAG = '' for two remaining points with QC_FLAG = 'BADPT'. No one can resolve them, so consider it good.
- Modifications to QC_FLAG = SNT points - Replaced existing SNT points with updated points from VTrans

OTHER UPDATES MADE TO TRANSTRUC
- Deleted points with STRUCT_NUM = '?' - PUT points with STRUCT_NUM = '?' to a coverage called QUESTIONPTS - Pulled these records into TRANSTRUC.DELETED INFO file for history tracking. - Copied QUESTIONPTS.PAT to TRANSTRUC.QUESTIONPTS in case someone wants to deal with it in the future or something.
- Assign a STRC_LBL to records where STRC_LBL = '?'. Used structure number portion of STRUCT_NUM.
- Removed records from TRANSTRUC.NOTES INFO file where STRUCT_NUM = '?'. No way to relate these to points so they were dropped.
- Joined TRANSTRUC.NOTES to TRANSTRUC.NOT_FOUND. Deleted TRANSTRUC.NOTES (only 3 had a match to actual TRANSTRUC points, and the 3 that matched didn't have much to say).
- STRUCT_NUM errors - Fix STRUCT_NUMs in Lyndon State data with 'xx' in Town Highway number portion of number. - Logged changes in TRANSTRUC.STRUCTNUM_CHANGELOG
- Generated new State BIS inventory DBF tables and MDB from data provided by VTrans
- Deleted TRANSTRUC.NO_INVENT

Process_Date: 20040929

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

VCGI received bridge/culvert data for 36 towns from several RPCs. The data was migrated to the new VGIS B/C Data Exchange Standard and merged with the existing TRANSTRUC data. The existing TRANSTRUC data was also migrated to the new standard. Metadata was revised and data was submitted to VTrans.

Process_Date: 20050929

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

VCGI corrected some data content and formating issues. VCGI also created shapefile and personal geodatabase versions of TRANSTRUC.MDB. Metadata was revised and data was submitted to VTrans.

Process_Date: 20051005

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description: Loaded data into VGIS Data Warehouse.

Process_Date: 20051019

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

Corrected errors in the OWNER field for VTrans_Primary and VTrans_Secondary tables. First all values in OWNER were calced based on the value of STRUCTYPE, where STRUCTYPE = SL/SS/SU then OWNER = '01'. Where STRUCTYPE = TL,TS,TU then OWNER = '03'. VCGI then joined T_SINVENT_PRIM via STRUCT_NUM then calced all OWNER values equal to those in T_SINVENT_PRIM (those which were not equal to NULL). OWNER is therefore derived from a mix of sources, and should be used with caution. The dTRANSTRUC_OWNER PGDB domain and Lookup_OWNER table were revised to reflect the full set of NBIS codes. Refer to November 2005 revision of VGIS Bridge & Culvert Data Exchange Standard for details. Revised data was loaded into the VGIS Data Warehouse.

Process_Date: 20051109

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

INTEGRATION OF VTRANS UPDATES - 2006 (release 2006A) 1) Checked-out copy of TRANSTRUC to VTrans on 7/27/2006. Checked out as a personal geodatabase. 2) VTrans returned updated copy to VCGI on 8/28/2006 3) VCGI Integration notes
-Deletes/Adds/Moves - Reviewed VTRANS_MODIFICATIONS table included in checkin MDB provided by VTrans. - Deleted one recored from master BC_VTransInventoryTable_Primary as noted - Appended new/added records to master BC_VTransInventoryTable_Primary as noted - Updated STRUCT_NUM_Change_Log to reflect deleted structure and STRUCT_NUM
-Integrated new BIS dump into TRANSTRUC.MDB (T_SINVENT_* tables).
-Identified omission/commission errors between BC_VTransInventoryTables_* and T_SINVENT_* tables and submitted them to VTrans for resolution.
- VTrans resubmitted data on 9/21/2006 with corrections. VTrans wasn't able to resolve every ommission/commission error.
- Integrated re-submitted data. Several records were tagged with a QCFLAG = MID (Missing Inventory Data). These were records in the BC_VTransInventoryTable_Primary which didn't have matching inventory records in the T_SINVENT_PRIM table.
- Revised metadata and posted data on the VGIS Data Warehouse for public access.

Process_Date: 20060926

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

VCGI received bridge/culvert data for 62 towns from several RPCs. The data was migrated to the new VGIS B/C Data Exchange Standard and merged with the existing TRANSTRUC data. Other data edits were made to ensure consistency throughout data database. Some formatting changes were also made based on a new draft version of the BC Standard (version 2c - draft 2). Metadata was revised and data was submitted to VTrans for loading into the new VT Online Bridge and Culvert Inventory Tool (VOBCIT). The data has NOT been loaded into the VGIS Data Warehouse yet pending final tweaks by VTrans during loading into VOBCIT. VTrans plans to return a modified version to VCGI for posting to the VGIS Data Warehouse. Release 2006A.

Process_Date: 20061130

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

VTrans provided VCGI with a data extract from VOBCIT (January 2007). The extract included the BC_LocalInventoryTable and a STRUCT_NUM_Changelog. These two tables were loaded into TRANSTRUC.MDB (2006A). The format of the data was modified to match version 2c of the "VGIS Bridge and Culvert Data Exchange Standard". PGDB and shapefile versions were generated, metadata was updated, and the data was loaded into the VGIS Data Warehouse for distribution. Release 2007A.

Process_Date: 20070404

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

VTrans provided VCGI with a new data extract from VOBCIT (4/19/2007). The extract included the BC_LocalInventoryTable and a STRUCT_NUM_Changelog. These two tables were loaded into TRANSTRUC.MDB. The format of the data was modified to match version 2d of the "VGIS Bridge and Culvert Data Exchange Standard". ANR provided VCGI with an extract from its SGA-DMS system from 4/27/2007. The table was integrated into TRANSTRUC as BC_GeomorphicInventoryTable as defined in the VGIS BC Standard. PGDB and shapefile versions were generated, metadata was updated, and the data was loaded into the VGIS Data Warehouse for distribution. Release 2007B.

Process_Date: 20070430

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

VTrans provided VCGI with a new data extract from VOBCIT (8/3/2007). VTrans also provided VCGI with an updated extract from the BIS and an updated GIS point layer (BC_VTransInventoryTable_Primary) from 7/1/2007. VTrans has chosen to discontinue the BC_VTransInventoryTable_Secondary table. This change has not been reflected in version 2d of the VGIS Bridge and Culvert Data Exchange Standard. All VTrans updates were integrated into TRANSTRUC.MDB ANR provided VCGI with an extract from its SGA-DMS system from 8/8/2007. The table was integrated into TRANSTRUC as BC_GeomorphicInventoryTable as defined in the VGIS BC Standard. PGDB and shapefile versions were generated, metadata was updated, and the data was loaded into the VGIS Data Warehouse for distribution. Release 2007C.

Process_Date: 20070808

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Process_Step:

Process_Description:

VTrans provided VCGI with a new data extract from VOBCIT (6/12/2008). VTrans also provided VCGI with an updated extract from the BIS and an updated GIS point layer (BC_VTransInventoryTable_Primary) from 4/14/2008. VTrans has chosen to discontinue the BC_VTransInventoryTable_Secondary table. This change has not been reflected in version 2d of the VGIS Bridge and Culvert Data Exchange Standard. All VTrans updates were integrated into TRANSTRUC.MDB ANR provided VCGI with an extract from its SGA-DMS system from 6/13/2008. The table was integrated into TRANSTRUC as BC_GeomorphicInventoryTable as defined in the VGIS BC Standard. PGDB and shapefile versions were generated, metadata was updated, and the data was loaded into the VGIS Data Warehouse for distribution. Release 2008A.

Process_Date: 20080616

Process_Time: Unknown

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Steve Sharp

Contact_Organization: VCGI

Contact_Position: GIS Database Administrator

Spatial_Data_Organization_Information:

Indirect_Spatial_Reference: POINT

Direct_Spatial_Reference_Method: Vector

Point_and_Vector_Object_Information:

SDTS_Terms_Description:

SDTS_Point_and_Vector_Object_Type: Point

Point_and_Vector_Object_Count: 80000

Spatial_Reference_Information:

Horizontal_Coordinate_System_Definition:

Planar:

Grid_Coordinate_System:

Grid_Coordinate_System_Name: State Plane Coordinate System 1983

State_Plane_Coordinate_System:

SPCS_Zone_Identifier: 4400

Transverse_Mercator:

Scale_Factor_at_Central_Meridian: 0.999964

Longitude_of_Central_Meridian: -72.500000

Latitude_of_Projection_Origin: 42.500000

False_Easting: 500000.000000

False_Northing: 0.000000

Planar_Coordinate_Information:

Planar_Coordinate_Encoding_Method: coordinate pair

Coordinate_Representation:

Abscissa_Resolution: 0.001

Ordinate_Resolution: 0.001

Planar_Distance_Units: Meters

Geodetic_Model:

Horizontal_Datum_Name: North American Datum of 1983

Ellipsoid_Name: Geodetic Reference System 80

Semi-major_Axis: 6378137

Denominator_of_Flattening_Ratio: 1 / 298.25722210

Entity_and_Attribute_Information:

Detailed_Description:

Entity_Type:

Entity_Type_Label: TRANSTRUC.MDB

Entity_Type_Definition:

Vermont's bridge & culvert database. There are 5 tables of primary interest to most users. Refer to Abstract at the top of the metadata for more details.

Entity_Type_Definition_Source:

Refer to VGIS Bridge & Culvert Data Exchange Standard (<http://www.vcgi.org/techres/standards/>)

Attribute:

Attribute_Label: STRUCT_NUM

Attribute_Definition: Unique Structure ID number

Attribute_Definition_Source: VTrans

Attribute:

Attribute_Label: QC_FLAG

Attribute_Definition: Quality Control flag

Attribute_Definition_Source: Various

Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value: POL

Enumerated_Domain_Value_Definition: Potential Overlapping Point

Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value: BNDOL

Enumerated_Domain_Value_Definition: Potential Overlapping Point along town boundary

Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value: FC

Enumerated_Domain_Value_Definition: Field Check needed

Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value: MID

Enumerated_Domain_Value_Definition: Missing Inventory Data from VTrans BIS

Detailed_Description:

Entity_Type:

Entity_Type_Label:

T_SINVENT_PRIM (table stored in TRANSTRUC.MDB MS Access database, also a subset of attributes available in T_SINVENT_PRIM.DBF). Can be related to TRANSTRUC points via STRUCT_NUM. To load the table into ArcView 3.x go to the Project pulldown menu and select SQL Connect. Under Access to MS Access Database as the database type. Choose the TRANSTRUC.MDB file, then specify the remaining parameters to load the table.

Entity_Type_Definition:

State (VTrans) Bridge & Culvert Inventory table for all primary bridge records.

Entity_Type_Definition_Source: VTrans - BIS

Attribute:

Attribute_Label: DeficiencyStatus

Attribute_Definition: Structural deficiency status

Attribute_Definition_Source: VTrans - BIS

Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value: FD

Enumerated_Domain_Value_Definition: functional deficiency

Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value: NA

Enumerated_Domain_Value_Definition: not applicable

Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value: ND

Enumerated_Domain_Value_Definition: no deficiency

Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value: SD

Enumerated_Domain_Value_Definition: structural deficiency

Detailed_Description:

Entity_Type:

Entity_Type_Label: T_SINVENT_SEC - This table has been discontinued by VTrans.

Detailed_Description:

Entity_Type:

Entity_Type_Label:

TRANSTRUC_INTEGRATION_LOG table (table stored in TRANSTRUC.MDB MS Access database)

Entity_Type_Definition:

This table is a log of all local/RPC culvert/bridge data integrated into TRANSTRUC. It includes the date of integration and some notes. This table is only valid for data integrated by VCGI prior to 1/1/2007. All data added to the BC_LocalInventoryTable after that data have been done via VOBCIT and therefore are not reflected in the integration log table.

Entity_Type_Definition_Source: VCGI

Detailed_Description:

Entity_Type:

Entity_Type_Label:

STRUCT_NUM_CHANGELOG_* table (table stored in TRANSTRUC.MDB MS Access database)

Entity_Type_Definition:

List of retired STRUCT_NUMs. Includes old number and new number, enabling users to cross reference as needed.

Entity_Type_Definition_Source: VTrans

Distribution_Information:

Distributor:

Contact_Information:

Contact_Organization_Primary:

Contact_Organization: VT Center for Geographic Information

Contact_Address:

Address_Type: Mailing and Physical Address

Address: 58 South Main Street, Suite 2

City: Waterbury

State_or_Province: VT

Postal_Code: 05676

Country: USA

Contact_Voice_Telephone: 802/882-3006

Contact_TDD/TTY_Telephone: None

Contact_Facsimile_Telephone: 802/882-3001

Contact_Electronic_Mail_Address: info@vcgi.org

Hours_of_Service: 9am - 5pm, M-F

Resource_Description: TransStructures_TRANSTRUC

Distribution_Liability:

VCGI and the State of Vermont make no representations of any kind, including but not limited to the warranties of merchantability or fitness for a particular use, nor are any such warranties to be implied with respect to the data.

Standard_Order_Process:

Digital_Form:

Digital_Transfer_Information:

Format_Name: SHP

Format_Specification: ESRI Shapefile format (compressed into ZIP file format)

Format_Information_Content: geospatial data

File_Decompression_Technique: ZIP extraction tool

Digital_Transfer_Option:

Online_Option:

Computer_Contact_Information:

Network_Address:

Network_Resource_Name:

<http://www.vcgi.org/dataware/default.cfm?layer=TransStructures_TRANSTRUC>

Access_Instructions: Download from web site.

Offline_Option:

Offline_Media: CD-ROM

Offline_Option:

Offline_Media: 3-1/2 inch floppy disk

Offline_Option:

Offline_Media: 4 mm cartridge tape

Fees:

No charge when downloading from the internet, and when no custom processing is required.

Ordering_Instructions:

Download from web site or mail-fax a copy of the VCGI 'Data Request Form' which is available from the VGIS web site <http://www.vcgi.org/dataware/order_forms>

Turnaround: About 5 days.

Custom_Order_Process:

Mail or Fax a copy of the VCGI 'Data Request Form' which is available from <http://www.vcgi.org/dataware/order_forms>

Technical_Prerequisites: ESRI Arc/Info, ArcView, or ArcExplorer software.

Available_Time_Period:

Time_Period_Information:

Single_Date/Time:

Calendar_Date: 20080616

Time_of_Day: Unknown

Metadata_Reference_Information:

Metadata_Date: 20080616

Metadata_Contact:

Contact_Information:

Contact_Organization_Primary:

Contact_Organization: VT Center for Geographic Information

Contact_Person: GIS Database Administrator

Contact_Address:

Address_Type: Mailing and Physical Address

Address: 58 South Main Street, Suite 2

City: Waterbury

State_or_Province: VT

Postal_Code: 05676

Country: USA

Contact_Voice_Telephone: 802/882-3000

Contact_TDD/TTY_Telephone: None

Contact_Facsimile_Telephone: 802/882-3001

Metadata_Standard_Name: FGDC Content Standards for Digital Metadata

Metadata_Standard_Version: FGDC-STD-001-1998

Metadata_Time_Convention: Local time

Metadata_Access_Constraints: None

Metadata_Use_Constraints: None

Metadata_Security_Information:

Metadata_Security_Classification_System: N/A

Metadata_Security_Classification: Unclassified

Metadata_Security_Handling_Description: No security considerations