Automated QA/QC procedures for cablevision's landbase database
Somkid Nimnual
Sr. GIS programmer/Analyst, Cablevision Systems Corporation
1111 Stewart Ave., Bethpage, NY 11714-3581, Office: (516) 803-3907
Fax: (516) 803-3796
Timothy G. McKee
Sr. Engagement Manager, Navigant Consulting, Inc.
2100 Wharton Street, Pittsburgh, PA 15203
Office: (412) 390-2050
Fax: (412) 390-2049
Introduction
Cablevision Systems Corporation is one of the nations leading telecommunications and
entertainment companies. Its operations range from high-speed Internet access and robust
cable television packages to professional sports teams and national television program
networks. The corporation was founded in 1973 as a cable television operator serving
1,500 households in New York's Long Island suburbs. Today, From the headquarters on
Long Island, Cablevision serve more than 3.4 million subscribers primarily in the New
York, New Jersey, Connecticut, Boston and Cleveland metropolitan areas.
Cablevision has implemented Smallworld and Model.it application since 1998, to replace
the existing non-GIS AutoCAD and Magic design application. The goal is to provide the
operational support system (OSS) applications for end-to-end design and management of
Fiber networks, from inside plant (rack-mounted equipment), fiber plant, coax plant to
outside plant design and build network elements and supporting structures. Also, the
application be integrated with OSI NetExpert system for network fault conditions,
Remedy system for ticketing, and Field's mobile application.
The initial implementation included:
- Documenting the Fiber network in Long Island area.
- Installed a central data server in Long Island Head-quarter's office with a WAN
connection to local persistent cache server and workstations in engineering offices
which located in Bronx, Islandia, Hickville, New Jersey, and other locations.
- Installed Smallworld and Model.it applications, building images.
- Landbase data conversion.
Landbase Source Data
The Enhanced Dynamap/2000 from Geographic Data Technology, Inc (GDT) was
selected as the based-map for the Model.it application. GDT provided the enhancement
using 1-meter ortho-rectified aerial photography known as Digital Orthophoto Quads
(DOQ) acquired through the National Digital Orthophoto Program, managed by the US
Geologic Survey, as the source data to rectify the existing Dynamap/2000. The
orthophotography meets the National Map Accuracy Standards (NMAS) which specify
that 90 percent of the well-defined points tested must fall within 1/30 inch (33.3 feet) at
1:12,000 scale. The measurement using the differential GPS (DGPS) ground coordinates
for existing intersections yielded a horizontal coordinate accuracy ranging between 4.2
and 7.8 meters RMSE (root mean square error).
The Enhanced Dynamap/2000 was delivered county by county in decimal degree unit and
ArcView' shape file format. The map will be projected to Lambert Conformal Conic
Projection (East-West shape preservation), which based on two standard parallels, NAD
83 datum, GRS80 spheroid, and unit in feet. The Enhanced Dynamap/2000 comes in a
nationwide directory (USA) with state and county sub directories and layers. The
interested layers that were used in Cablevision's Model.it data model are Streets,
Railroad, Water Segments, Water Polygon, Park, Institutions, Large Area Landmarks,
Recreational Areas, Retail Centers, Transportation Terminal, Airports, Zip Code, Minor
and Sub Civil Divisions (MCDs). Each layer composed of spatial geographical records
that are classified by the Feature Class Codes (FCC). The series of FCC codes, is based
on the USGS classification code in the DLG-3 file, provides more detailed information
on the classification of the line segment, such as class of road, class of stream, and so
forth. For example, A11 is assigned to the limited access and undivided highway and A15
is assigned to the limited access and divided highway. This FCC assignment will be used
to separate each type of records into different classes of Landbase objects in Model.it
data model. The Landbase source data are illustrated in Figure 1.a using ArcView
application.
Figure 1.a Shows the GDT's Enhanced Dynamap/2000 in ArcView
application and
Figure 1.b Shows the Landbase data model in Model.it
application.