KCI provided field inventory/inspection and GIS Implementation Services to Denton County, Texas. Our geospatial solutions team is responsible for project management, database design, requirements, ArcSDE implementation / replication, data migration and compilation, QA/QC, training county staff, and the development of a custom blowdown template.
KCI met with county stakeholders to discuss database design and requirements. Based on this meeting, our team created a geodatabase design document which was submitted to the County for review. Once review comments were incorporated, KCI developed a conduit geodatabase for a manhole’s underground facility. The feature classes include the following: conduit, walls, floors, ductbanks, and ducts. KCI developed an ArcObjects-based Add-In for ArcGIS Desktop version 10.1+ using C# .Net. The add-in is being used to create, edit and manage underground facilities within ArcMap, based on a submitted data model and function with any ESRI compliant spatial database.
Our team reviewed the current county GIS, CADD datasets and record drawings (as-builts, construction drawings, etc.) for incorporation into a plan for a geodatabase design that is the result of a collaboration of county and KCI personnel. KCI performed an intensive gap analysis between the current spatial data sources and the future geodatabase model to identify where data needs to be added, removed and field verified. Analysts established a defined workflow for moving the existing digital data into the new repository while maintaining the accuracy of the spatial data and associated attributes, which were documented in a data migration plan. This plan outlined possible changes to the data during the migration process. Specifically the plan detailed any cleanup routines or automated population of attributes that may occur.
The field collection efforts consisted of both Outside Plant (OSP) and Inside Plant (ISP) data collection. The OSP portion included manhole and hand-hole data collection. Each location was audited to include hole size, cover markings, number of conduit and size, conduit occupancy, cable type, cable ID, slack storage and splice enclosure information. Data collected during the OSP portion was transferred to the custom blowdown templates and integrated into the database. For the ISP portion, our technicians tested all open fibers at both the Courts and Administrative Buildings. Testing included unidirectional OTDR testing at 1550 nm from all open ports. KCI analyzed all test data and provided an out-of-spec report based on standard splice and end-to-end loss expectations. In addition, Field crews identified all visible splice locations and geocoded those in the database using the correct algorithms to account for slack and cable helix factor. KCI provided patch panel details as well as rack diagrams for each terminated location. The completed panel details and rack diagrams are being integrated into the database.
Our team consulted with county stakeholders to determine the most efficient and cost-effective fiber manager software that met their requirements. KCI implemented CrescentLink Fiber Optic Network Management Solution for the county. Built on ESRI ArcGIS, with its easily understood architecture, CrescentLink offered a reliable, responsive, high quality fiber optic mapping system. In addition KCI created a custom blowdown template tool that ran alongside of CrescentLink and ESRI. One of the major selling points of this system is that data can be viewed, edited and managed using all three software or using only ESRI if the workflow allows. This independence of the data to the software saves on licenses fees, while still meeting all of the minimum requirements of a fiber management system. KCI is migrating the collected field data into the CrescentLink Fiber Optic Network Management Solution, which will allow Denton to track every individual strand in every cable and every cable in every conduit and trace or step along any circuit showing cables, panels, splitters, electronics and patch cables.