|
HTMUA Asset Management System Database Dictionary |
|
Potable Water System - Polygon Features |
|
The structure of Polygon features including item definitions and attribute domains for below listed feature class is as follows:
|
|
· Casing · Easements and · Water Structure |
|
Item Definitions: |
|
Common Items: |
|
Sl.No. |
Description |
Item Name |
Type |
Width |
|
|
Common Items |
|
|
|
|
1 |
Internal Unique Number |
ObjectID |
ObjectID |
4 |
|
2 |
GIS Facility ID |
FacilityID |
String |
40 |
|
3 |
Feature Type in Integer |
Subtype |
Long |
4 |
|
4 |
Feature Type / Name in String |
SubtypeName |
String |
50 |
|
5 |
Field Verification Code |
FieldVerification |
String |
15 |
|
6 |
Length of Poly |
Shape_Length |
Double |
8 |
|
7 |
Area of Polygon |
Shape_Area |
Double |
8 |
|
8 |
Length of Line |
LineLength |
Double |
8 |
|
9 |
Area of Polygon |
PolyArea |
Double |
8 |
|
|
Casing |
|
|
|
|
10 |
Casing Width |
Width |
Double |
8 |
|
|
Easements |
|
|
|
|
11 |
Instrument Number |
InstrumentNumber |
String |
255 |
|
12 |
Easement Width |
Width |
Double |
8 |
|
13 |
Easement Shared |
Shared |
String |
255 |
|
|
Water Structure |
|
|
|
|
14 |
Operational Date |
OperationalDate |
Date |
8 |
|
15 |
Facility type |
FacilityName |
String |
25 |
|
16 |
Reference ID |
ReferenceID |
String |
15 |
|
ObjectID |
Unique, non-null identifier for each pipe or service. This field is populated by default in the system, whenever the features are Deleted/Added. |
|||||
|
|
||||||
|
|
|
|
|
|
|
|
|
FacilityID |
Unique, non-null identifier for each pipe or service. The GIS facility ID will be unique for each polygon in any feature class. The GIS facility ID is comprised of a four-digit grid number "3612" and a four-digit number. (e.g., "36123000"). FacilityID Numbering scheme for more details on each Feature Class. |
|||||
|
|
||||||
|
|
||||||
|
|
||||||
|
|
||||||
|
|
|
|
|
|
|
|
|
Subtype |
Facility type code in integer form. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SubtypeName |
Facility type code in Character form. Valid Values include: |
|
|
|||
|
Casing SubtypeName |
Subtype |
|
|
|
|
|
|
|
"SteelCasing" |
1 |
|
|
|
|
|
|
"ConcreteEncasement" |
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Easement SubtypeName |
Subtype |
|
|
|
|
|
|
"MeterBox" |
1 |
|
|
|
|
|
|
"Reservoir" |
2 |
|
|
|
|
|
|
"WellSite" |
3 |
|
|
|
|
|
|
"TreatmentPlantBldg" |
4 |
|
|
|
|
|
|
"Vault" |
5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
FieldVerification |
Three-letter non-null code indicating whether or not the feature was field verified. Valid Values Include: |
|||||
|
|
||||||
|
|
"Yes" |
Field verification needed. |
|
|
||
|
|
"No" |
Field verification not needed. |
|
|
||
|
|
|
|
|
|
|
|
|
Shape_Length |
Length of Poly, populated for use in Geo Viewer IMS. |
|
|
|||
|
|
|
|
|
|
|
|
|
Shape_Area |
Area of Polygon, populated for use in Geo Veiwer IMS. |
|
|
|||
|
|
|
|
|
|
|
|
|
LineLength |
Length of Poly, populated for use in Geo Viewer IMS. |
|
|
|||
|
|
|
|
|
|
|
|
|
PolyArea |
Area of Polygon, populated for use in Geo Veiwer IMS. |
|
|
|||
|
|
|
|
|
|
|
|
|
Casing |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Width |
Casing diameter, in inches. Diameter may be any positive, non-zero value. Enter "999" when unknown. |
|||||
|
|
||||||
|
|
|
|
|
|
|
|
|
Easements |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
InstrumentNumber |
Instrument Number from Easement Atlas (If any). |
|
|
|||
|
|
|
|
|
|
|
|
|
Width |
Easement diameter, in Feet. Diameter may be any positive, non-zero value. Enter "999" when unknown. |
|||||
|
|
||||||
|
|
|
|
|
|
|
|
|
Shared |
Shared status of Easement. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Water Structure |
|
|
||||