Poles.shp.xml
XML file 40 KB Posted
- Attached to
- Middle Mile Design & Engineering
- Solicitation number
- 072024-01
- Issued by
- Clay County, Tennessee
About this file
The provided file is a geospatial database XML metadata document for GIS support structure data, specifically related to pole mapping and infrastructure for Newport Utilities in Tennessee. The file appears to be a technical schema describing a geospatial database of support structures, potentially connected to a middle mile fiber infrastructure project in Cocke County, Tennessee. The document details database field configurations, including additions and deletions of fields related to support structures, GPS coordinates, ownership information, and utility attachments.
The metadata indicates the database uses the NAD_1983_StatePlane_Tennessee_FIPS_4100_Feet coordinate system and includes detailed tracking of support structure attributes such as installation dates, materials, heights, manufacturers, foundation types, and utility attachments for entities like AT&T, Charter, Comcast, and others. The file suggests a comprehensive mapping and inventory effort for telecommunications and utility infrastructure, likely supporting the Middle Mile Design & Engineering project for fiber line builds in Cocke County, which aims to enhance regional telecommunications infrastructure.
Text of this file
20240808 16503500 1.0 FALSE gs45206_master.DBO.gs_support_structure 002 2743084.260768 2882593.377853 532041.992492 671254.603369 1 Server=localhost,1433; Service=sde:sqlserver:localhost,1433; Database=gs45206; User=gs45206; Version=dbo.DEFAULT ArcSDE Connection Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_Tennessee_FIPS_4100_Feet <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.1'><WKT>PROJCS["NAD_1983_StatePlane_Tennessee_FIPS_4100_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1968500.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-86.0],PARAMETER["Standard_Parallel_1",35.25],PARAMETER["Standard_Parallel_2",36.41666666666666],PARAMETER["Latitude_Of_Origin",34.33333333333334],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2274]]</WKT><XOrigin>-121521299.99817827</XOrigin><YOrigin>-93933999.992492586</YOrigin><XYScale>1593.3224626890221</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.020083819031832491</XYTolerance><ZTolerance>2</ZTolerance><MTolerance>2</MTolerance><HighPrecision>true</HighPrecision><WKID>102736</WKID><LatestWKID>2274</LatestWKID></ProjectedCoordinateSystem> AddIndex E:\ivue_mapping_staking\master_database\gs45206_master.sde\GS_SUPPORT_STRUCTURE gs_vc_revision gs_vc_revision NON_UNIQUE NON_ASCENDING AddIndex E:\ivue_mapping_staking\master_database\gs45206_master.sde\GS_SUPPORT_STRUCTURE gs_subtype_cd gs_subtype_cd NON_UNIQUE NON_ASCENDING AddIndex E:\ivue_mapping_staking\master_database\gs45206_master.sde\GS_SUPPORT_STRUCTURE gs_facility_id gs_facility_id NON_UNIQUE NON_ASCENDING AddIndex E:\ivue_mapping_staking\master_database\gs45206_master.sde\GS_SUPPORT_STRUCTURE gs_equipment_location gs_equipment_location NON_UNIQUE NON_ASCENDING DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_attachments DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_nu DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_att DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_charter DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_comcast DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_haywood DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_video DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_nu_attached DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_att_attached DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_charter_attached DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_comcast_attached DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_haywood_attached DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure ju_owner DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure ju_insp_date DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure ju_inspector DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure ju_att_attached DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure j_own DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure j_ATT DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure j_CHA DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure j_COM DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure j_HAY DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure j_nu DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure j_inspection DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure pi_access1 DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure pi_date DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure pi_access2 DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure pi_access3 DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure pi_access4 DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure pi_insp DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure pi_stat DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure pi_action DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure pi_hardware1 DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure pi_hardware2 DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure pi_anch_guy DeleteField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure pi_grnd AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_gps_x DOUBLE # # # # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_gps_y DOUBLE # # # # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_abandoned TEXT # # 5 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_source_transformer_present TEXT # # 5 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_transformer_present TEXT # # 5 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_double_wood TEXT # # 25 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_transfer_type TEXT # # 25 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_insp_date TEXT # # 25 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_inspector TEXT # # 10 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_owner TEXT # # 50 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_owner_2 TEXT # # 50 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_owner_3 TEXT # # 50 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_owner_4 TEXT # # 50 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_owner_5 TEXT # # 50 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_owner_6 TEXT # # 50 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_type TEXT # # 50 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_type_2 TEXT # # 50 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_type_3 TEXT # # 50 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_type_4 TEXT # # 50 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_type_5 TEXT # # 50 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_type_6 TEXT # # 50 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_quantity SHORT # # # # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_quantity_2 SHORT # # # # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_quantity_3 SHORT # # # # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_quantity_4 SHORT # # # # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_quantity_5 SHORT # # # # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_ju_quantity_6 SHORT # # # # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_attached_to_old_pole TEXT # # 5 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_attached_to_old_pole_2 TEXT # # 5 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_attached_to_old_pole_3 TEXT # # 5 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_attached_to_old_pole_4 TEXT # # 5 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_attached_to_old_pole_5 TEXT # # 5 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_attached_to_old_pole_6 TEXT # # 5 # NULLABLE NON_REQUIRED # AddField F:\ivue_mapping_staking\master_database\gs45206_master.sde\gs_support_structure gs_hazard_violation TEXT # # 100 # NULLABLE NON_REQUIRED # AddField C:/ivue_mapping_staking/gs45206_master.sde\gs45206_master.DBO.gs_support_structure gs_source_db TEXT 20 # # # NULLABLE NON_REQUIRED # 20151022 16093400 20151022 16093400 Microsoft Windows 7 Version 6.1 (Build 7601) Service Pack 1; Esri ArcGIS 10.1.1.3143 gs45206_master.DBO.gs_support_structure 1 -83.388728 -82.903862 36.148873 35.755432 SDE Feature Class dataset EPSG 7.11.2 40693 Simple FALSE 40693 TRUE FALSE gs45206_master.DBO.gs_support_structure Feature Class 40693 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. gs_guid gs_guid String 38 0 0 gs_vc_revision gs_vc_revision Integer 4 10 0 gs_vc_modified_sw gs_vc_modified_sw SmallInteger 2 5 0 gs_old_objectid gs_old_objectid Integer 4 10 0 gs_symbol_rotation gs_symbol_rotation Double 8 38 8 gs_subtype_cd gs_subtype_cd Integer 4 10 0 gs_equipment_location gs_equipment_location String 25 0 0 gs_description gs_description String 50 0 0 gs_height gs_height String 5 0 0 gs_class gs_class String 5 0 0 gs_installation_date gs_installation_date Date 36 0 0 gs_comments gs_comments String 100 0 0 gs_date_created gs_date_created Date 36 0 0 gs_date_modified gs_date_modified Date 36 0 0 gs_diameter gs_diameter Double 8 38 8 gs_foundation_type gs_foundation_type String 5 0 0 gs_grounded gs_grounded String 5 0 0 gs_manufacturer gs_manufacturer String 50 0 0 gs_material gs_material String 5 0 0 gs_owner gs_owner Integer 4 10 0 gs_pole_count gs_pole_count Integer 4 10 0 gs_style gs_style String 5 0 0 gs_treatment_type gs_treatment_type String 5 0 0 gs_usage_type gs_usage_type String 5 0 0 gs_year_manufactured gs_year_manufactured String 5 0 0 gs_facility_id gs_facility_id String 30 0 0 gs_work_initiation_id gs_work_initiation_id String 30 0 0 gs_shape_from_gps_sw gs_shape_from_gps_sw String 5 0 0 gs_damaged gs_damaged String 4 0 0 gs_gps_type gs_gps_type String 10 0 0 gs_construction_unit gs_construction_unit String 30 0 0 gs_map_no gs_map_no String 20 0 0 gs_framing gs_framing String 50 0 0 gs_attachments gs_attachments String 50 0 0 gs_nu gs_nu String 5 0 0 gs_att gs_att String 5 0 0 gs_charter gs_charter String 5 0 0 gs_comcast gs_comcast String 5 0 0 gs_haywood gs_haywood String 5 0 0 gs_video gs_video String 1 0 0 gs_work_initiation_id_older_a gs_work_initiation_id_older_a String 50 0 0 SHAPE SHAPE Geometry 4 0 0 Feature geometry. Esri Coordinates defining the features. gs_related_staking_guid gs_related_staking_guid String 38 0 0 gs_nu_attached nu_attached String 1 0 0 gs_att_attached att_attached String 1 0 0 gs_charter_attached charter_attached String 1 0 0 gs_comcast_attached comcast_attached String 1 0 0 gs_haywood_attached haywood_attached String 1 0 0 ju_owner Joint Use Owner Integer 4 10 0 ju_insp_date Joint Use Inspection Date Date 36 0 0 ju_inspector ju_inspector String 60 0 0 ju_att_attached AT&T Attached String 1 0 0 Newport Utilities 0 gs_symbol_rotation 0 gs_subtype_cd 0 ATT 1 gs_symbol_rotation 0 gs_subtype_cd 1 Unknown 2 gs_symbol_rotation 0 gs_subtype_cd 1 Tline 3 gs_symbol_rotation 0 gs_subtype_cd 1 20151022
Other files
| File | Type | Posted |
|---|---|---|
| Poles.sbn | — | |
| Poles.shp | — | |
| Q&A Document 1.pdf | ||
| Q&A Document 2.pdf | ||
| Q&A Document 4.pdf | ||
| South_340.kmz | KMZ file | |
| Middle Mile Design Area Estimated Mileage.xlsx | XLSX spreadsheet | |
| Middle Mile Scope of Work Design.pdf | ||
| Poles.cpg | — | |
| Poles.dbf | DBF file | |
| Poles.prj | — | |
| Poles.shx | — | |
| Q&A Document 3.pdf | ||
| Zoom meeting Design _ Engineering.pdf | ||
| Byrd Anti-Lobbying Certification.pdf | ||
| Middle Mile Contract Design.pdf | ||
| Poles.sbx | — | |
| Q&A Document 6.pdf | ||
| Q&A Document 7.pdf | ||
| West_Parrottsville.kmz | KMZ file | |
| Contract Certifications.pdf | ||
| Liberty_Hill.kmz | KMZ file | |
| Q&A Document 5.pdf | ||
| Q&A Document 8.pdf | ||
| Wiley_Town.kmz | KMZ file |
Show all 25
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
File details come from the government source that posted it. Updated .