|
The best of the rest
|
Automated QA/QC procedures for cablevision's landbase database
Model.IT Landbase Data Model
In Smallworld's Model.it application, the database models are classified as different
categories, depends on the application's modules. These categories are the outside plant
equipment, the drafting and drawing, the Landbase, the dxf object, the rack mounted
equipment, the circuit, the copper, the microwave, the conduit, the relationship table and
miscellaneous.
In the Landbase category, the data model is sub-classed into manifolds mainly include
address, building, campus, complex, count, lot, non-political boundary, political
boundary, road edge, street, street annotation, transportation boundary, transportation
route, waterbody, and waterway (Figure 1.b). Each of manifolds is further sub-divided
into classes depends on the geometry type (point, line or polygon) and real world objects.
For example, political boundary consisted of geometry type of polygon and real world
objects of state boundary, city boundary, province boundary, town boundary, and zip
code boundary and school boundary. The Smallworld's Model.it Landbase data models
are summarized in Table 1.
Table 1. Shows the geometry type and real world objects in the Model.it
Landbase Data Model.
| Landbase Manifolds |
Geometry Type |
Real World Objects |
| Street |
Line |
Street center line |
| Street Annotation |
Text |
Street name, prefix, suffix,designation |
| Road Edge |
Line |
Street edge |
| Political Boundary |
Polygon |
State, city, town, province,zip code, school |
| Non-Political Boundary |
Polygon |
Park, golf course, cemetery,worship, hospital, stadium |
| Transportation Route |
Line |
Railroad, subway, tunnel,bridge |
| Transportation Boundary |
Polygon |
Airport, bus terminal, train station |
| Waterway |
Line |
River, stream, canal, creek,ditch |
| Other:Address, count Building, campus, lot |
Point Polygon |
Address, counts Building, campus, lot |
QA/AC Standard Checked List
Cablevision has performed preliminary study to convert the GDT's Enhanced
Dynamap/2000 source data into Smallworld's environment using ArcView and Data
Automation Kit from ESRI for data manipulation and Safe Software's Feature
Manipulation Engine (FME) to convert and project the data to Model.it Landbase
database. The data manipulation were included:
- Selection of records of particular type, such as, school from Institutions and
Large Area Landmark Layers.
- Reduce segments and check connectivity from line type geometry, such as,
Street, Water Segments and Railroad.
- Create Rode Edge object for Street centerline.
- Check number of original objects, duplication objects, object's name and
name/attribute's type compatibility.
- Check overlapping of polygon geometry such as park, golf course, zip code,
city, county boundary.
- Create polygon from point geometry such as school, church, cemetery,
stadium and hospital.
The conversion from ESRI's Shape file to Model.it data model was performed through a
one-to-one mapping file for each Shapefile layer to the Landbase objects. The projection
was also scripted in the mapping file.
After the conversion is completed, the Landbase objects were checked in Smallworld's
environment by using,
- Object Browser Engine to visually check the number of object conversion, name/type
compatibility and duplicated objects.
- Network Follower for connectivity, edge matching and manifold identity.
- Projection was checked by comparison to the reference point.
|
|
