Identification_Information: Citation: Citation_Information: Originator: VCGI GIS Database Administrator Publication_Date: 20100630 Publication_Time: unknown Title: TransStructures_TRANSTRUC Edition: 2010A Geospatial_Data_Presentation_Form: vector digital data Series_Information: Series_Name: VT Bridges and Culverts (transportation structures) Issue_Identification: 2010A 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. 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 3 tables of primary interest, including 1) BC_LocalInventoryTable, 2) BC_VTransInventoryTable_Primary, 3) and BC_VTransInventoryTable_Other 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, Vermont's RPCs, and municipalities. Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 062010 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). 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. - 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 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 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 Process_Step: Process_Description: VTrans provided VCGI with a new data extract from VOBCIT (6/18/2010). VTrans also provided VCGI with an updated extract from the BIS and an updated GIS point layer (BC_VTransInventoryTable_Primary) from 6/16/2010. 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 11/30/2009. However it did no comply with the BC_GeomorphicInventoryTable specifications as defined in the VGIS BC Standard, therefore ANR's geomorphic data has been dropped from TRANSTRUC. PGDB and shapefile versions were generated, metadata was updated, and the data was loaded into the VGIS Data Warehouse for distribution. Release 2010A. Process_Date: 20100630 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 Enumerated_Domain: Enumerated_Domain_Value: BNDOL Enumerated_Domain_Value_Definition: Potential Overlapping Point along town boundary Enumerated_Domain: Enumerated_Domain_Value: FC Enumerated_Domain_Value_Definition: Field Check needed 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 - Bridge Inventory System Manual (included with TRANSTRUC.ZIP download) Attribute: Attribute_Label: STRUCT_NUM Attribute_Definition: Item 8 - Structure Number Attribute: Attribute_Label: DATE_INSP Attribute_Definition: Item 90 - Inspection Date Attribute: Attribute_Label: LOC_DESC Attribute_Definition: Item 9 - Location Attribute: Attribute_Label: STRUC_MAT Attribute_Definition: Item 43 - Strucutre Type, Main -- A: Kind of material and/or design Attribute: Attribute_Label: STRUC_TYPE Attribute_Definition: Item 43 - Structure Type, Main -- B: Type of design and/or construction Attribute: Attribute_Label: STRUC_LEN Attribute_Definition: Item 49 - Structure Length Attribute: Attribute_Label: WIDTH Attribute_Definition: ?? Item 51 - Bridge Roadway Width, Curb-to-Curb OR Item 52 - Deck Width, Out-to-Out -- NOT SURE WHICH -- Attribute: Attribute_Label: HEIGHT Attribute_Definition: ?? Item 53 - Minimum Vertical Clearance Over Bridge Roadway Attribute: Attribute_Label: UCLEARREF Attribute_Definition: ?? Item 54 - Minimum Verical Underclearance -- A: Reference Feature Attribute: Attribute_Label: UCLEARANCE Attribute_Definition: ?? Item 54 - Minimum Vertical Underclearance -- B: Minimum Vertical Under Clearance Attribute: Attribute_Label: WLIMIT Attribute_Definition: ?? Attribute: Attribute_Label: CCONDITION Attribute_Definition: ?? NOT SURE WHICH ITEM 58-62 Attribute: Attribute_Label: YR_BUILT Attribute_Definition: Item 27 - Year Built Attribute: Attribute_Label: REPAIRCOST Attribute_Definition: ?? Item 94 - Bridge Improvement Cost Attribute: Attribute_Label: REPLCCOST Attribute_Definition: ?? Attribute: Attribute_Label: YR_REPAIR Attribute_Definition: ?? Attribute: Attribute_Label: ApproachGuardRail Attribute_Definition: Item 36 - Traffic Safety Features - C Approach guard rail Attribute: Attribute_Label: ApproachGuardRailEnds Attribute_Definition: Item 36 - Traffic Safety Features - D Approach guard rail ends Attribute: Attribute_Label: ApproachRailMaterial Attribute_Definition: Item 221 - Type of Bridge Rail - C Material/Design of Rail Attribute: Attribute_Label: ApproachRoadwayAlignment Attribute_Definition: Item 72 - Approach Roadway Alignment Attribute: Attribute_Label: ApproachRoadwayWidth Attribute_Definition: Item 32 - Approach Roadway Width Attribute: Attribute_Label: ApproachStructureMaterial Attribute_Definition: Item 44 - Structure Type, Approach Spans -- A: Kind of material and/or design Attribute: Attribute_Label: ApproachStructureType Attribute_Definition: Item 44 - Structure Type, Approach Spans -- B: Type of design and/or construction Attribute: Attribute_Label: AverageCoverOverCulvert Attribute_Definition: ?? Attribute: Attribute_Label: BridgeCurbType Attribute_Definition: ?? Attribute: Attribute_Label: BridgeDeckAlignment Attribute_Definition: State Item No. 220 - Alignment of Bridge Deck and Superstructure Attribute: Attribute_Label: BridgeMedian Attribute_Definition: Item 33 - Bridge Median Attribute: Attribute_Label: BridgePlansOnFile Attribute_Definition: State Item No. 241 - Bridge Plans on File Attribute: Attribute_Label: BridgePosting Attribute_Definition: Item 70 - Bridge Posting Attribute: Attribute_Label: BridgeRailings Attribute_Definition: ?? Attribute: Attribute_Label: BridgeRailMaterial Attribute_Definition: State Item 221 - Type of Bridge Rail -- C: Material/Design of Rail Attribute: Attribute_Label: BridgeRailPostMaterial Attribute_Definition: State Item 221 - Type of Bridge Rail -- A: Material/Design of Posts Attribute: Attribute_Label: BridgeType Attribute_Definition: ?? State Item No. 800 - Bridge Type Attribute: Attribute_Label: ChannelRating Attribute_Definition: Item 61 - Channel and Channel Protection Attribute: Attribute_Label: CountyCode Attribute_Definition: Item 3 - County Code Attribute: Attribute_Label: CoveredBridgeIndicator Attribute_Definition: ?? Attribute: Attribute_Label: CoveredBridgeRoofCondition Attribute_Definition: ?? Attribute: Attribute_Label: CoveredBridgeRoofType Attribute_Definition: ?? Attribute: Attribute_Label: CoveredBridgeSideBoardCond Attribute_Definition: ?? Attribute: Attribute_Label: CoveredBridgeTrussType Attribute_Definition: ?? Attribute: Attribute_Label: CrossReferenceBridgeNumber Attribute_Definition: State Item No. 244 - Cross Reference Bridge No. Attribute: Attribute_Label: CrossReferenceRouteNumber Attribute_Definition: State Item No. 243 - Cross Reference Route Number Attribute: Attribute_Label: CulvertBarrelLength Attribute_Definition: ?? Attribute: Attribute_Label: CulvertWingHeaderRating Attribute_Definition: ?? Attribute: Attribute_Label: CurbSidewalkWidthLeft Attribute_Definition: Item 50 - Curb or Sidewalk Widths -- A: Left Curb or Sidewalk Width Attribute: Attribute_Label: CurbSidewalkWidthRight Attribute_Definition: Item 50 - Curb or Sidewalk Widths -- B: Right Curb or Sidewalk Width Attribute: Attribute_Label: DeckProtection Attribute_Definition: Item 108 - Wearing Surface/Protection System -- C: Deck Protection Attribute: Attribute_Label: DeckRating Attribute_Definition: ?? Attribute: Attribute_Label: DeckStructureType Attribute_Definition: Item 107 - Deck Structure Type Attribute: Attribute_Label: DeckWidth Attribute_Definition: Item 52 - Deck Width Attribute: Attribute_Label: DeficiencyStatus Attribute_Definition: Structural deficiency status Attribute_Definition_Source: State Item No. 239 - Deficiency Status of Structure Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: FD Enumerated_Domain_Value_Definition: functional deficiency Enumerated_Domain: Enumerated_Domain_Value: NA Enumerated_Domain_Value_Definition: not applicable Enumerated_Domain: Enumerated_Domain_Value: ND Enumerated_Domain_Value_Definition: no deficiency Enumerated_Domain: Enumerated_Domain_Value: SD Enumerated_Domain_Value_Definition: structural deficiency Attribute: Attribute_Label: DesignLoad Attribute_Definition: Item 31 - Design Load Attribute: Attribute_Label: DetourLength Attribute_Definition: Item 19 - Bypass, Detour Length Attribute: Attribute_Label: ExpansionBearingType Attribute_Definition: State Item 224 - Type of Expansion Bearing Device Attribute: Attribute_Label: ExpansionJointType Attribute_Definition: State Item 223 - Type of Expansion Joint Attribute: Attribute_Label: FacilityCarried Attribute_Definition: Item 7 - Facility Carried by Structure Attribute: Attribute_Label: FeaturesIntersected Attribute_Definition: Item 6 - Features Intersected Attribute: Attribute_Label: FederalSufficiencyRating Attribute_Definition: State Item No. 237 - Federal Sufficiency Rating Attribute: Attribute_Label: FoundationTypeAbutment1 Attribute_Definition: State Item 225 - Type of Foundation Attribute: Attribute_Label: FoundationTypeAbutment2 Attribute_Definition: State Item 225 A - Type of Foundation (1st and 2nd digits) Attribute: Attribute_Label: FoundationTypePier1 Attribute_Definition: State Item 225 C,D,E,F &G (5th through 14th digits) Attribute: Attribute_Label: FoundationTypePier2 Attribute_Definition: State Item 225 C,D,E,F &G (5th through 14th digits) Attribute: Attribute_Label: FoundationTypePier3 Attribute_Definition: State Item 225 C,D,E,F &G (5th through 14th digits) Attribute: Attribute_Label: FoundationTypePier4 Attribute_Definition: State Item 225 C,D,E,F &G (5th through 14th digits) Attribute: Attribute_Label: FoundationTypePier5 Attribute_Definition: State Item 225 C,D,E,F &G (5th through 14th digits) Attribute: Attribute_Label: GreaseCoated Attribute_Definition: State Item 212 - Bridge Paint -- C: Is structural steel grease coated? Attribute: Attribute_Label: HistoricalSignificance Attribute_Definition: Item 37 - Historical Significance Attribute: Attribute_Label: HydraulicReport Attribute_Definition: State Item 217 - Hydraulic Report Available Attribute: Attribute_Label: HydraulicReportYear Attribute_Definition: State Item 218 - Year of Hydraulic Report Attribute: Attribute_Label: HydraulicStructure Attribute_Definition: State Item 216 - Hydraulic Structure Attribute: Attribute_Label: ImprovementCostYear Attribute_Definition: ?? Item 97 - Year of Improvement Cost Estimate Attribute: Attribute_Label: InspectionFrequency Attribute_Definition: Item 91 - Designated Inspection Frequency Attribute: Attribute_Label: InventoryRatingLoad Attribute_Definition: Item 66 - Inventory Rating -- B: Gross Load in Tons Attribute: Attribute_Label: InventoryRatingMethod Attribute_Definition: ?? Attribute: Attribute_Label: InventoryRatingType Attribute_Definition: Item 66 - Inventory Rating -- A: Type of Loading Attribute: Attribute_Label: LanesOnStructure Attribute_Definition: Item 28 - Lanes On and Under the Structure -- A: On Attribute: Attribute_Label: LanesUnderStructure Attribute_Definition: Item 28 - Lanes On and Under the Structure -- B: Under Attribute: Attribute_Label: LastProjectNumber Attribute_Definition: State Item 208 - Last Project No. Attribute: Attribute_Label: LeadPaintRemoved Attribute_Definition: State Item 212 - Bridge Paint -- D: Was lead paint completely removed from structural steel before non-lead paint was applied? Attribute: Attribute_Label: LoadPosting Attribute_Definition: State Item 236 - Load Posting Sign Attribute: Attribute_Label: MaintenanceActivityYear1 Attribute_Definition: State Items 214, 214-1, 214-2 - Year of Last Maintenance Activity Attribute: Attribute_Label: MaintenanceActivityYear2 Attribute_Definition: State Items 214, 214-1, 214-2 - year of Last Maintenance Activity Attribute: Attribute_Label: MaintenanceActivityYear3 Attribute_Definition: State Items 214, 214-1, 214-2 - year of Last Maintenance Activity Attribute: Attribute_Label: MaintenancePerformed1 Attribute_Definition: State Item 215,215-1,215-2 - Type of Maintenance Performed Attribute: Attribute_Label: MaintenancePerformed2 Attribute_Definition: State Item 215,215-1,215-2 - Type of Maintenance Performed Attribute: Attribute_Label: MaintenancePerformed3 Attribute_Definition: State Item 215,215-1,215-2 - Type of Maintenance Performed Attribute: Attribute_Label: MaintenanceResponsibility Attribute_Definition: Item 21 - Maintenance Responsibility Attribute: Attribute_Label: MaximumSpan Attribute_Definition: Item 48 - Length of Maximum Span Attribute: Attribute_Label: MembraneType Attribute_Definition: Item 108 - Wearing Surface/Protection System -- B: Type of Membrane Attribute: Attribute_Label: MinimumLateralUnderClr Attribute_Definition: Item 55 - Minimum Lateral Underclearance on Right -- B: Minimum Lateral Underclearance Attribute: Attribute_Label: MinimumLateralUnderClrLt Attribute_Definition: Item 56 - Minimal Lateral Underclearance on Left Attribute: Attribute_Label: MinimumLateralUnderClrRef Attribute_Definition: Item 55 - Minimum Lateral Underclearance on Right -- A: Reference Feature Attribute: Attribute_Label: MultiPlateBoltLineCrackingInd Attribute_Definition: ?? Attribute: Attribute_Label: NavigationControl Attribute_Definition: Item 38 - Navigation Control Attribute: Attribute_Label: NavigationHorizontalClear Attribute_Definition: Item 40 - Navigation Horizontal Clearance Attribute: Attribute_Label: NavigationMinimumVertical Attribute_Definition: Item 39 - Navigation Vertical Clearance Attribute: Attribute_Label: NavigationProtection Attribute_Definition: ?? Item 111 - Pier or Abutment Protection (for Navigation) Attribute: Attribute_Label: NavigationVerticalClearance Attribute_Definition: Item 116 - Minimum Navigation Vertical Clearance Vertical Lift Bridge Attribute: Attribute_Label: NumberSpansApproachUnit Attribute_Definition: Item 46 - Number of Approach Spans Attribute: Attribute_Label: NumberSpansMainUnit Attribute_Definition: Item 45 - Number of Spans in Main Unit Attribute: Attribute_Label: OperatingRating3S2Truck Attribute_Definition: State Item No. 233 - 3S2 Truck at 75% Yield Point Attribute: Attribute_Label: OperatingRating6AxleTruck Attribute_Definition: State Item No. 235 - 6 Axle Semi-Trailer Truck at 75% Yield Point Attribute: Attribute_Label: OperatingRatingLoad Attribute_Definition: Item 64 - Operating Rating -- B: Gross Load in Tons Attribute: Attribute_Label: OperatingRatingMethod Attribute_Definition: ?? Attribute: Attribute_Label: OperatingRatingType Attribute_Definition: Item 64 - Operating Rating -- A: Type of Loading Attribute: Attribute_Label: Owner Attribute_Definition: Item 22 - Owner Attribute: Attribute_Label: PaintColor Attribute_Definition: State Item 212B - Bridge Paint Attribute: Attribute_Label: PaintRating Attribute_Definition: State Item No. 211 - Rating of Paint Attribute: Attribute_Label: ParallelStructureDesignation Attribute_Definition: Item 101 - Parallel Structure Designation Attribute: Attribute_Label: PercentResponsibility Attribute_Definition: Item 98 - Border Bridge -- B: Percent Responsibility Attribute: Attribute_Label: PostingRating3AxleTruck Attribute_Definition: State Item No. 230 - 3 Axle Straight Truck 2 digits at 67% Yield Point Attribute: Attribute_Label: PostingRating3S2Truck Attribute_Definition: State Item No. 232 - 3S2 Truck at 67% Yield Point Attribute: Attribute_Label: PostingRating4AxleTruck Attribute_Definition: State Item No. 231 - 4 Axle Straight Truck at 67% Yield Point Attribute: Attribute_Label: PostingRating5AxleTruck Attribute_Definition: State Item No. 234 - 5 Axle Semi-Trailer Truck (SHT. W.B.) at 67% YP Attribute: Attribute_Label: PostingRatingHTruck Attribute_Definition: State Item No. 229 Attribute: Attribute_Label: PrincipalDuplicateInd Attribute_Definition: State Item 204 - Principal or Duplicate Report Indicator Attribute: Attribute_Label: RecordType Attribute_Definition: Item 5A - Record Type Attribute: Attribute_Label: RouteLogBridgeNumber Attribute_Definition: State Item 240 - Route Log Bridge No. Attribute: Attribute_Label: RouteName Attribute_Definition: State Item No. 405 - Route Name Attribute: Attribute_Label: RouteNumber Attribute_Definition: Item 5D - Route Number Attribute: Attribute_Label: ScourCriticalBridges Attribute_Definition: Item 113 - Scour Critical Bridges Attribute: Attribute_Label: SingleTwinBridgeIndicator Attribute_Definition: State Item No. 201 - Single or Twin Bridge Indicator Attribute: Attribute_Label: Skew Attribute_Definition: Item 34 - Skew Attribute: Attribute_Label: SteelCulvertCorrosionIndicator Attribute_Definition: ?? Attribute: Attribute_Label: StructuralAdequacy Attribute_Definition: State Item No. 406 - Structural Adequacy and Safety Attribute: Attribute_Label: StructureFlared Attribute_Definition: Item 35 - Structure Flared Attribute: Attribute_Label: StructureOpenPostedClosed Attribute_Definition: Item 41 - Structure Open, Posted, or Closed to Traffic Attribute: Attribute_Label: SubstructureRating Attribute_Definition: Item 60 - Substructure Attribute: Attribute_Label: SuperstructureRating Attribute_Definition: ?? Attribute: Attribute_Label: TempStructureDesignation Attribute_Definition: Item 103 - Temporary Structure Designation Attribute: Attribute_Label: TownName Attribute_Definition: State Item No. 401 - Town Name Attribute: Attribute_Label: Utilities Attribute_Definition: State Item No. 213 - Number of Utilities Attribute: Attribute_Label: VerticalClearHighwayUnder Attribute_Definition: State Item 226 - Verical Clearance Under Bridge (Highway) Attribute: Attribute_Label: VerticalClearRailroadUnder Attribute_Definition: State Item 227 - Vertical Clearance Unders Bridge (Railroad) Attribute: Attribute_Label: VerticalClearWaterwayUnder Attribute_Definition: State Item 228 - Vertical Clearance Under Bridge (Waterway) Attribute: Attribute_Label: WaterwayAdequacy Attribute_Definition: Item 71 - Waterway Adequacy Attribute: Attribute_Label: WaterwayAreaThroughCulvert Attribute_Definition: ?? Attribute: Attribute_Label: WearingSurfaceType Attribute_Definition: Item 108 - Wearing Surface/Protection System -- A: Type of Wearing System Attribute: Attribute_Label: WeightStructuralSteel Attribute_Definition: State Item 210 - Weight of Structural Steel Attribute: Attribute_Label: YearLastPainted Attribute_Definition: State Item 212A - Year Structure Last Painted Attribute: Attribute_Label: Longitude Attribute_Definition: Item 17 - Longitude Attribute: Attribute_Label: Latitude Attribute_Definition: Item 16 - Latitude Detailed_Description: Entity_Type: Entity_Type_Label: T_SINVENT_SEC - This table has been discontinued by VTrans. 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: DVD 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: 20100630 Time_of_Day: Unknown Metadata_Reference_Information: Metadata_Date: 20100630 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