ArcGIS REST Services Directory
Login
|
Get Token
Home
>
services
>
AssetTracker
>
WaterAssetTracker_Pilot (FeatureServer)
>
All Layers and Tables
Help
|
API Reference
JSON
All Layers and Tables (AssetTracker/WaterAssetTracker_Pilot)
Layers:
Layer:
WA_Meter
(1)
Name:
WA_Meter
Display Field:
TAG
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
Meters are instruments used to measure the quantity of water consumption by a customer for the purposes of billing.
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Can Scale Symbols:
false
Supports ValidateSQL:
true
Supports Calculate:
true
Supports Datum Transformation:
true
Extent:
XMin: -8539635.7548
YMin: 4759904.835000001
XMax: -8528247.2308
YMax: 4773961.181999996
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[115, 133, 0, 255]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
1
Label:
N/A
Description:
N/A
Transparency:
0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
TAG
( type: esriFieldTypeString, alias: Tag, editable: true, nullable: true, length: 15, defaultValue: null, modelName: TAG )
DATEABANDONED
( type: esriFieldTypeDate, alias: DATEABANDONED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEABANDONED )
LAST_ORGANIZATION
( type: esriFieldTypeString, alias: LAST_ORGANIZATION, editable: true, nullable: true, length: 3, defaultValue: null, modelName: LAST_ORGANIZATION ,
Coded Values:
[100: Buchart Horn Inc] , [110: Chesapeake Environmental Management Inc] , [120: Enterprise Information Solutions, Inc.]
, ...12 more...
)
CAPTURE_METHOD
( type: esriFieldTypeString, alias: CAPTURE_METHOD, editable: true, nullable: true, length: 4, defaultValue: PLAT, modelName: CAPTURE_METHOD ,
Coded Values:
[PLAT: Plat Map] , [CD: Contract Drawing] , [GN: Geometric Network]
, ...11 more...
)
LAST_USER
( type: esriFieldTypeString, alias: LAST_USER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAST_USER )
EDIT_DATE
( type: esriFieldTypeDate, alias: EDIT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EDIT_DATE )
METER_NO
( type: esriFieldTypeString, alias: METER_NO, editable: true, nullable: true, length: 10, defaultValue: null, modelName: METER_NO )
MT_SIZE
( type: esriFieldTypeDouble, alias: MT_SIZE, editable: true, nullable: true, defaultValue: null, modelName: MT_SIZE )
METER_TYPE_CD
( type: esriFieldTypeString, alias: METER_TYPE_CD, editable: true, nullable: true, length: 1, defaultValue: null, modelName: METER_TYPE_CD ,
Coded Values:
[2: Removed] , [3: MFM-MVR] , [4: Hersey MVR]
, ...43 more...
)
ACCOUNT_NO
( type: esriFieldTypeString, alias: ACCOUNT_NO, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ACCOUNT_NO )
INSTALL_DATE
( type: esriFieldTypeDate, alias: INSTALL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_DATE )
METERTYPE
( type: esriFieldTypeInteger, alias: METERTYPE, editable: true, nullable: true, defaultValue: 1, modelName: METERTYPE )
FEAT_STATUS
( type: esriFieldTypeString, alias: FEAT_STATUS, editable: true, nullable: true, length: 3, defaultValue: ACT, modelName: FEAT_STATUS ,
Coded Values:
[ABD: Abandoned] , [ACT: Active] , [PRO: Proposed]
, ...11 more...
)
ENABLED
( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED ,
Coded Values:
[0: False] , [1: True] )
SERVICE_SIZE
( type: esriFieldTypeDouble, alias: SERVICE_SIZE, editable: true, nullable: true, defaultValue: null, modelName: SERVICE_SIZE )
FacilityID
( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
DOCPOPURL
( type: esriFieldTypeString, alias: DOCPOPURL, editable: true, nullable: true, length: 250, defaultValue: null, modelName: DOCPOPURL )
LOCATION
( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 120, defaultValue: null, modelName: LOCATION )
IN_SCOPE
( type: esriFieldTypeString, alias: IN_SCOPE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: IN_SCOPE ,
Coded Values:
[Yes: Yes] , [No: No] )
PROJECT
( type: esriFieldTypeString, alias: PROJECT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECT ,
Coded Values:
[1291: WC1291] , [1275: WC1275] , [1287: WC1287]
, ...1 more...
)
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
Name: WA_Meter
Description:
Prototype:
PROJECT:
null
IN_SCOPE:
null
TAG:
null
DATEABANDONED:
null
LAST_ORGANIZATION:
null
CAPTURE_METHOD:
PLAT
LAST_USER:
null
EDIT_DATE:
null
METER_NO:
null
MT_SIZE:
null
METER_TYPE_CD:
null
ACCOUNT_NO:
null
INSTALL_DATE:
null
METERTYPE:
1
FEAT_STATUS:
ACT
ENABLED:
1
SERVICE_SIZE:
null
FacilityID:
null
DOCPOPURL:
null
LOCATION:
null
Drawing Tool: esriFeatureEditToolPoint
Relationships:
(0) --
Related To
:
AssetTrackers_DevelopmentDB.ASSET_TRACKER.Meter_Work_Report
(7)
Layer:
WA_Hydrant
(2)
Name:
WA_Hydrant
Display Field:
STREET_NAME
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
A hydrant is composed of a discharge pipe with a valve and a spout at which water may be drawn from a water main as for fighting fires.
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Can Scale Symbols:
false
Supports ValidateSQL:
true
Supports Calculate:
true
Supports Datum Transformation:
true
Extent:
XMin: -8539569.4022
YMin: 4760038.8957
XMax: -8528188.2824
YMax: 4773982.085900001
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[163, 0, 120, 255]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
1
Label:
N/A
Description:
N/A
Transparency:
0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
MANUF_MODEL_CD
( type: esriFieldTypeSmallInteger, alias: MANUF_MODEL_CD, editable: true, nullable: true, defaultValue: 20, modelName: MANUF_MODEL_CD ,
Coded Values:
[1: AMER_DARLING--B62B] , [2: AMER_DARLING--UNK] , [3: AP_SMITH--BALT_STD_2_PORT]
, ...18 more...
)
LOCK_MODEL_CD
( type: esriFieldTypeString, alias: LOCK_MODEL_CD, editable: true, nullable: true, length: 3, defaultValue: UNK, modelName: LOCK_MODEL_CD ,
Coded Values:
[UNK: Unknown] , [MCG: McGard] , [RON: Recessed Op Nut]
, ...4 more...
)
LAT_SIZE
( type: esriFieldTypeDouble, alias: LAT_SIZE, editable: true, nullable: true, defaultValue: 6, modelName: LAT_SIZE ,
Coded Values:
[0.75: 0.75"] , [1: 1"] , [1.5: 1.5"]
, ...40 more...
)
SRC_MAIN_SIZE
( type: esriFieldTypeDouble, alias: SRC_MAIN_SIZE, editable: true, nullable: true, defaultValue: 0, modelName: SRC_MAIN_SIZE ,
Coded Values:
[0.75: 0.75"] , [1: 1"] , [1.5: 1.5"]
, ...40 more...
)
PRESSURE_ZONE
( type: esriFieldTypeString, alias: PRESSURE_ZONE, editable: true, nullable: true, length: 4, defaultValue: UNK, modelName: PRESSURE_ZONE ,
Coded Values:
[1: First] , [2: Second] , [2C: Colgate Second]
, ...17 more...
)
BREAKAWAY
( type: esriFieldTypeString, alias: BREAKAWAY, editable: true, nullable: true, length: 3, defaultValue: UNK, modelName: BREAKAWAY ,
Coded Values:
[Y: Yes] , [N: No] , [CND: Could Not Determine]
, ...1 more...
)
FEAT_STATUS
( type: esriFieldTypeString, alias: FEAT_STATUS, editable: true, nullable: true, length: 3, defaultValue: ACT, modelName: FEAT_STATUS ,
Coded Values:
[ABD: Abandoned] , [ACT: Active] , [PRO: Proposed]
, ...11 more...
)
ENABLED
( type: esriFieldTypeSmallInteger, alias: ENABLED, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED ,
Coded Values:
[0: False] , [1: True] )
RESP_AGENCY
( type: esriFieldTypeString, alias: RESP_AGENCY, editable: true, nullable: true, length: 4, defaultValue: null, modelName: RESP_AGENCY ,
Coded Values:
[DPW: DPW] , [NDPW: Non-DPW] , [AA: Anne Arundel]
, ...10 more...
)
LAST_ORGANIZATION
( type: esriFieldTypeString, alias: LAST_ORGANIZATION, editable: true, nullable: true, length: 3, defaultValue: null, modelName: LAST_ORGANIZATION ,
Coded Values:
[100: Buchart Horn Inc] , [110: Chesapeake Environmental Management Inc] , [120: Enterprise Information Solutions, Inc.]
, ...12 more...
)
CAPTURE_METHOD
( type: esriFieldTypeString, alias: CAPTURE_METHOD, editable: true, nullable: true, length: 4, defaultValue: null, modelName: CAPTURE_METHOD ,
Coded Values:
[PLAT: Plat Map] , [CD: Contract Drawing] , [GN: Geometric Network]
, ...11 more...
)
LAST_USER
( type: esriFieldTypeString, alias: LAST_USER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAST_USER )
TAG
( type: esriFieldTypeString, alias: TAG, editable: true, nullable: true, length: 15, defaultValue: null, modelName: TAG )
DATEABANDONED
( type: esriFieldTypeDate, alias: DATEABANDONED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEABANDONED )
EDIT_DATE
( type: esriFieldTypeDate, alias: EDIT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EDIT_DATE )
HYDRANT_ID
( type: esriFieldTypeString, alias: HYDRANT_ID, editable: true, nullable: true, length: 15, defaultValue: UNK, modelName: HYDRANT_ID )
STATIC_PRESSURE
( type: esriFieldTypeDouble, alias: STATIC_PRESSURE, editable: true, nullable: true, defaultValue: 0, modelName: STATIC_PRESSURE )
INSTALL_DATE
( type: esriFieldTypeDate, alias: INSTALL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_DATE )
OPER_DATE
( type: esriFieldTypeDate, alias: OPER_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: OPER_DATE )
FAB_DATE
( type: esriFieldTypeDate, alias: FAB_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FAB_DATE )
BURY
( type: esriFieldTypeDouble, alias: BURY, editable: true, nullable: true, defaultValue: 0, modelName: BURY )
MAX_FLOW_RATE
( type: esriFieldTypeDouble, alias: MAX_FLOW_RATE, editable: true, nullable: true, defaultValue: 0, modelName: MAX_FLOW_RATE )
EDIT_COMMENT
( type: esriFieldTypeString, alias: EDIT_COMMENT, editable: true, nullable: true, length: 255, defaultValue: NONE, modelName: EDIT_COMMENT )
CITY_ENUM
( type: esriFieldTypeString, alias: CITY_ENUM, editable: true, nullable: true, length: 6, defaultValue: null, modelName: CITY_ENUM )
DOCPOPURL
( type: esriFieldTypeString, alias: DOCPOPURL, editable: true, nullable: true, length: 300, defaultValue: null, modelName: DOCPOPURL )
ELEVATION
( type: esriFieldTypeDouble, alias: ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
FacilityID
( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
BFD_FIELDCHECK_DATE
( type: esriFieldTypeDate, alias: BFD_FIELDCHECK_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BFD_FIELDCHECK_DATE )
BFD_FIELDCHECK_STATUS
( type: esriFieldTypeSmallInteger, alias: BFD_FIELDCHECK_STATUS, editable: true, nullable: true, defaultValue: null, modelName: BFD_FIELDCHECK_STATUS ,
Coded Values:
[0: Hydrant does not exist] , [1: Hydrant exists] , [2: Hydrant needs field check]
, ...1 more...
)
LOCATION_TYPE
( type: esriFieldTypeString, alias: LOCATION_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATION_TYPE ,
Coded Values:
[INT: INTERSECTION] , [ADDR: ADDRESS] , [BLK: BLOCK] )
STREET_NUM
( type: esriFieldTypeString, alias: STREET_NUM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_NUM )
STREET_NAME
( type: esriFieldTypeString, alias: STREET_NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STREET_NAME )
CAD_ADDR
( type: esriFieldTypeString, alias: CAD_ADDR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CAD_ADDR )
CROSS_STREET
( type: esriFieldTypeString, alias: CROSS_STREET, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CROSS_STREET )
CORNER_POSITION
( type: esriFieldTypeString, alias: CORNER_POSITION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CORNER_POSITION ,
Coded Values:
[NE: NE] , [SE: SE] , [NW: NW]
, ...5 more...
)
LOCATION_DESCRIPTION
( type: esriFieldTypeString, alias: LOCATION_DESCRIPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATION_DESCRIPTION )
DISTRICT
( type: esriFieldTypeString, alias: DISTRICT, editable: true, nullable: true, length: 6, defaultValue: null, modelName: DISTRICT )
HYDR_ZONE
( type: esriFieldTypeInteger, alias: HYDR_ZONE, editable: true, nullable: true, defaultValue: null, modelName: HYDR_ZONE )
LOCATION_DESCRIPTION2
( type: esriFieldTypeString, alias: LOCATION_DESCRIPTION2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATION_DESCRIPTION2 )
IN_SCOPE
( type: esriFieldTypeString, alias: IN_SCOPE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: IN_SCOPE ,
Coded Values:
[Yes: Yes] , [No: No] )
PROJECT
( type: esriFieldTypeString, alias: PROJECT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECT ,
Coded Values:
[1291: WC1291] , [1275: WC1275] , [1287: WC1287]
, ...1 more...
)
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
Name: WA_Hydrant
Description:
Prototype:
PROJECT:
null
IN_SCOPE:
null
MANUF_MODEL_CD:
20
LOCK_MODEL_CD:
UNK
LAT_SIZE:
6
SRC_MAIN_SIZE:
0
PRESSURE_ZONE:
UNK
BREAKAWAY:
UNK
FEAT_STATUS:
ACT
ENABLED:
1
RESP_AGENCY:
null
LAST_ORGANIZATION:
null
CAPTURE_METHOD:
null
LAST_USER:
null
TAG:
null
DATEABANDONED:
null
EDIT_DATE:
null
HYDRANT_ID:
UNK
STATIC_PRESSURE:
0
INSTALL_DATE:
null
OPER_DATE:
null
FAB_DATE:
null
BURY:
0
MAX_FLOW_RATE:
0
EDIT_COMMENT:
NONE
CITY_ENUM:
null
DOCPOPURL:
null
ELEVATION:
null
FacilityID:
null
BFD_FIELDCHECK_DATE:
null
BFD_FIELDCHECK_STATUS:
null
LOCATION_TYPE:
null
STREET_NUM:
null
STREET_NAME:
null
CAD_ADDR:
null
CROSS_STREET:
null
CORNER_POSITION:
null
LOCATION_DESCRIPTION:
null
DISTRICT:
null
HYDR_ZONE:
null
LOCATION_DESCRIPTION2:
null
Drawing Tool: esriFeatureEditToolPoint
Relationships:
(1) --
Related To
:
AssetTrackers_DevelopmentDB.ASSET_TRACKER.Hydrant_Work_Report
(5)
Layer:
WA_Valve
(0)
Name:
WA_Valve
Display Field:
MANUF_CD
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
Valves used to regulate flow and isolate portions of the collection system.
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Can Scale Symbols:
false
Supports ValidateSQL:
true
Supports Calculate:
true
Supports Datum Transformation:
true
Extent:
XMin: -8539603.2199
YMin: 4760024.961099997
XMax: -8528183.072
YMax: 4773991.601999998
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[150, 143, 0, 255]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
1
Label:
N/A
Description:
N/A
Transparency:
0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
VALVE_USE
( type: esriFieldTypeInteger, alias: VALVE_USE, editable: true, nullable: true, defaultValue: null, modelName: VALVE_USE ,
Coded Values:
[2: Division Valve] , [5: Shutoff Valve] , [8: Hydrant Lead Valve]
, ...7 more...
)
MANUF_CD
( type: esriFieldTypeString, alias: MANUF_CD, editable: true, nullable: true, length: 3, defaultValue: UNK, modelName: MANUF_CD ,
Coded Values:
[AFC: American Flow Control / ACIPCO] , [AMD: American Darling] , [AMS: Ames]
, ...28 more...
)
VLV_SIZE
( type: esriFieldTypeDouble, alias: VLV_SIZE, editable: true, nullable: true, defaultValue: 0, modelName: VLV_SIZE ,
Coded Values:
[0.75: 0.75"] , [1: 1"] , [1.5: 1.5"]
, ...37 more...
)
VLV_CLOSE_DIR
( type: esriFieldTypeString, alias: VLV_CLOSE_DIR, editable: true, nullable: true, length: 3, defaultValue: UNK, modelName: VLV_CLOSE_DIR ,
Coded Values:
[CW: Clockwise] , [CCW: Counter-Clockwise] , [CND: Could Not Determine]
, ...1 more...
)
STRUCTURE
( type: esriFieldTypeString, alias: STRUCTURE, editable: true, nullable: true, length: 3, defaultValue: UNK, modelName: STRUCTURE ,
Coded Values:
[RBX: Roadway Box] , [VLT: Vault] , [OTH: Other]
, ...2 more...
)
FEAT_STATUS
( type: esriFieldTypeString, alias: FEAT_STATUS, editable: true, nullable: true, length: 3, defaultValue: ACT, modelName: FEAT_STATUS ,
Coded Values:
[ABD: Abandoned] , [ACT: Active] , [PRO: Proposed]
, ...11 more...
)
CONDITION
( type: esriFieldTypeString, alias: CONDITION, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CONDITION ,
Coded Values:
[F: FAIR] , [G: GOOD] , [IO: INOPERABLE]
, ...5 more...
)
LAST_ORGANIZATION
( type: esriFieldTypeString, alias: LAST_ORGANIZATION, editable: true, nullable: true, length: 3, defaultValue: UNK, modelName: LAST_ORGANIZATION ,
Coded Values:
[100: Buchart Horn Inc] , [110: Chesapeake Environmental Management Inc] , [120: Enterprise Information Solutions, Inc.]
, ...12 more...
)
CAPTURE_METHOD
( type: esriFieldTypeString, alias: CAPTURE_METHOD, editable: true, nullable: true, length: 4, defaultValue: null, modelName: CAPTURE_METHOD ,
Coded Values:
[PLAT: Plat Map] , [CD: Contract Drawing] , [GN: Geometric Network]
, ...11 more...
)
LAST_USER
( type: esriFieldTypeString, alias: LAST_USER, editable: true, nullable: true, length: 20, defaultValue: UNK, modelName: LAST_USER )
TAG
( type: esriFieldTypeString, alias: TAG, editable: true, nullable: true, length: 15, defaultValue: UNK, modelName: TAG )
DATEABANDONED
( type: esriFieldTypeDate, alias: DATEABANDONED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEABANDONED )
EDIT_DATE
( type: esriFieldTypeDate, alias: EDIT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EDIT_DATE )
VLV_ID
( type: esriFieldTypeString, alias: VLV_ID, editable: true, nullable: true, length: 15, defaultValue: UNK, modelName: VLV_ID )
COVER_DEPTH
( type: esriFieldTypeDouble, alias: COVER_DEPTH, editable: true, nullable: true, defaultValue: 0, modelName: COVER_DEPTH )
OPNUT_DEPTH
( type: esriFieldTypeDouble, alias: OPNUT_DEPTH, editable: true, nullable: true, defaultValue: 0, modelName: OPNUT_DEPTH )
INSTALL_DATE
( type: esriFieldTypeDate, alias: INSTALL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_DATE )
DATE_OPERATED
( type: esriFieldTypeDate, alias: DATE_OPERATED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_OPERATED )
DOCPOPURL
( type: esriFieldTypeString, alias: DOCPOPURL, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: DOCPOPURL )
BYP_VALVE_PRESENT
( type: esriFieldTypeSmallInteger, alias: BYP_VALVE_PRESENT, editable: true, nullable: true, defaultValue: null, modelName: BYP_VALVE_PRESENT ,
Coded Values:
[0: False] , [1: True] )
ELEVATION
( type: esriFieldTypeDouble, alias: ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
MAX_TURNS
( type: esriFieldTypeDouble, alias: MAX_TURNS, editable: true, nullable: true, defaultValue: null, modelName: MAX_TURNS )
Enabled
( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled ,
Coded Values:
[0: False] , [1: True] )
MAXIMUM_MAX_TORQUE
( type: esriFieldTypeDouble, alias: MAXIMUM_MAX_TORQUE, editable: true, nullable: true, defaultValue: null, modelName: MAXIMUM_MAX_TORQUE )
ORIENTATION
( type: esriFieldTypeString, alias: ORIENTATION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ORIENTATION ,
Coded Values:
[VERTICAL: VERTICAL] , [HORIZONTAL: HORIZONTAL] , [NOT APPLICABLE: NOT APPLICABLE]
, ...1 more...
)
VALVE_TYPE
( type: esriFieldTypeString, alias: VALVE_TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_TYPE ,
Coded Values:
[GATE NOT GEARED: GATE NOT GEARED] , [INTERNAL GEARED GATE: INTERNAL GEARED GATE] , [EXTERNAL GEARED GATE: EXTERNAL GEARED GATE]
, ...11 more...
)
CITY_ENUM
( type: esriFieldTypeString, alias: CITY_ENUM, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CITY_ENUM )
FacilityID
( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
MAXIMUM_FINAL_TORQUE
( type: esriFieldTypeDouble, alias: MAXIMUM_FINAL_TORQUE, editable: true, nullable: true, defaultValue: null, modelName: MAXIMUM_FINAL_TORQUE )
BYP_MAX_TURNS
( type: esriFieldTypeDouble, alias: BYP_MAX_TURNS, editable: true, nullable: true, defaultValue: null, modelName: BYP_MAX_TURNS )
POSITION_LEFT
( type: esriFieldTypeString, alias: POSITION_LEFT, editable: true, nullable: true, length: 20, defaultValue: null, modelName: POSITION_LEFT )
FROZEN
( type: esriFieldTypeString, alias: FROZEN, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FROZEN )
EXERCISE
( type: esriFieldTypeString, alias: EXERCISE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EXERCISE )
ACCESS
( type: esriFieldTypeString, alias: ACCESS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ACCESS )
IN_SCOPE
( type: esriFieldTypeString, alias: IN_SCOPE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: IN_SCOPE ,
Coded Values:
[Yes: Yes] , [No: No] )
PROJECT
( type: esriFieldTypeString, alias: PROJECT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECT ,
Coded Values:
[1291: WC1291] , [1275: WC1275] , [1287: WC1287]
, ...1 more...
)
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
Name: WA_Valve
Description:
Prototype:
PROJECT:
null
IN_SCOPE:
null
VALVE_USE:
null
MANUF_CD:
UNK
VLV_SIZE:
0
VLV_CLOSE_DIR:
UNK
STRUCTURE:
UNK
FEAT_STATUS:
ACT
CONDITION:
null
LAST_ORGANIZATION:
UNK
CAPTURE_METHOD:
null
LAST_USER:
UNK
TAG:
UNK
DATEABANDONED:
null
EDIT_DATE:
null
VLV_ID:
UNK
COVER_DEPTH:
0
OPNUT_DEPTH:
0
INSTALL_DATE:
null
DATE_OPERATED:
null
DOCPOPURL:
null
BYP_VALVE_PRESENT:
null
ELEVATION:
null
MAX_TURNS:
null
Enabled:
1
MAXIMUM_MAX_TORQUE:
null
ORIENTATION:
null
VALVE_TYPE:
null
CITY_ENUM:
null
FacilityID:
null
MAXIMUM_FINAL_TORQUE:
null
BYP_MAX_TURNS:
null
POSITION_LEFT:
null
FROZEN:
null
EXERCISE:
null
ACCESS:
null
Drawing Tool: esriFeatureEditToolPoint
Relationships:
(2) --
Related To
:
AssetTrackers_DevelopmentDB.ASSET_TRACKER.Valve_Work_Report
(9)
Layer:
WA_Service
(3)
Name:
WA_Service
Display Field:
TAG
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
A service is a pipe that runs between the main and the customer’s place of consumption.
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Can Scale Symbols:
false
Supports ValidateSQL:
true
Supports Calculate:
true
Supports Datum Transformation:
true
Extent:
XMin: -8539449.8174
YMin: 4760017.822099999
XMax: -8528236.9929
YMax: 4773961.181999996
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSLSSolid
Color:
[70, 145, 0, 255]
Width:
1
Label:
N/A
Description:
N/A
Transparency:
0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
TAG
( type: esriFieldTypeString, alias: Tag, editable: true, nullable: true, length: 15, defaultValue: null, modelName: TAG )
DATEABANDONED
( type: esriFieldTypeDate, alias: DATEABANDONED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEABANDONED )
LAST_ORGANIZATION
( type: esriFieldTypeString, alias: LAST_ORGANIZATION, editable: true, nullable: true, length: 3, defaultValue: null, modelName: LAST_ORGANIZATION ,
Coded Values:
[100: Buchart Horn Inc] , [110: Chesapeake Environmental Management Inc] , [120: Enterprise Information Solutions, Inc.]
, ...12 more...
)
CAPTURE_METHOD
( type: esriFieldTypeString, alias: CAPTURE_METHOD, editable: true, nullable: true, length: 4, defaultValue: null, modelName: CAPTURE_METHOD ,
Coded Values:
[PLAT: Plat Map] , [CD: Contract Drawing] , [GN: Geometric Network]
, ...11 more...
)
LAST_USER
( type: esriFieldTypeString, alias: LAST_USER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAST_USER )
EDIT_DATE
( type: esriFieldTypeDate, alias: EDIT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EDIT_DATE )
CLASS_TYPE
( type: esriFieldTypeString, alias: CLASS_TYPE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CLASS_TYPE ,
Coded Values:
[22: Class 22] , [23: Class 23] , [24: Class 24]
, ...14 more...
)
INSTALL_DATE
( type: esriFieldTypeDate, alias: INSTALL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_DATE )
MATERIAL_CD
( type: esriFieldTypeString, alias: MATERIAL_CD, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MATERIAL_CD ,
Coded Values:
[CI: Cast Iron] , [COP: Copper] , [DI: Ductile Iron]
, ...6 more...
)
PIP_SIZE
( type: esriFieldTypeDouble, alias: PIP_SIZE, editable: true, nullable: true, defaultValue: null, modelName: PIP_SIZE ,
Coded Values:
[0.63: .63"] , [0.75: .75"] , [1: 1"]
, ...10 more...
)
SERVICETYPE
( type: esriFieldTypeInteger, alias: SERVICETYPE, editable: true, nullable: true, defaultValue: 1, modelName: SERVICETYPE )
FEAT_STATUS
( type: esriFieldTypeString, alias: FEAT_STATUS, editable: true, nullable: true, length: 3, defaultValue: ACT, modelName: FEAT_STATUS ,
Coded Values:
[ABD: Abandoned] , [ACT: Active] , [PRO: Proposed]
, ...11 more...
)
ENABLED
( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED ,
Coded Values:
[0: False] , [1: True] )
OWNER_CD
( type: esriFieldTypeString, alias: OWNER_CD, editable: true, nullable: true, length: 4, defaultValue: null, modelName: OWNER_CD ,
Coded Values:
[DPW: DPW] , [NDPW: Non-DPW] , [AA: Anne Arundel]
, ...10 more...
)
FacilityID
( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
LENGTH
( type: esriFieldTypeDouble, alias: LENGTH, editable: true, nullable: true, defaultValue: null, modelName: LENGTH )
IN_SCOPE
( type: esriFieldTypeString, alias: IN_SCOPE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: IN_SCOPE ,
Coded Values:
[Yes: Yes] , [No: No] )
PROJECT
( type: esriFieldTypeString, alias: PROJECT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECT ,
Coded Values:
[1291: WC1291] , [1275: WC1275] , [1287: WC1287]
, ...1 more...
)
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Shape__Length
( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )
Templates:
Name: WA_Service
Description:
Prototype:
IN_SCOPE:
null
PROJECT:
null
TAG:
null
DATEABANDONED:
null
LAST_ORGANIZATION:
null
CAPTURE_METHOD:
null
LAST_USER:
null
EDIT_DATE:
null
CLASS_TYPE:
null
INSTALL_DATE:
null
MATERIAL_CD:
null
PIP_SIZE:
null
SERVICETYPE:
1
FEAT_STATUS:
ACT
ENABLED:
1
OWNER_CD:
null
FacilityID:
null
LENGTH:
null
Drawing Tool: esriFeatureEditToolLine
Relationships:
(3) --
Related To
:
AssetTrackers_DevelopmentDB.ASSET_TRACKER.Service_Work_Report
(8)
Layer:
WA_Main
(4)
Name:
WA_Main
Display Field:
CLASS
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
A main is a water pipe operated and maintained for the purpose of transmission and/or distribution of water to customers.
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Can Scale Symbols:
false
Supports ValidateSQL:
true
Supports Calculate:
true
Supports Datum Transformation:
true
Extent:
XMin: -8539746.8407
YMin: 4759745.394100003
XMax: -8528183.072
YMax: 4773991.601999998
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSLSSolid
Color:
[106, 128, 0, 255]
Width:
1
Label:
N/A
Description:
N/A
Transparency:
0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
CLASS
( type: esriFieldTypeString, alias: CLASS, editable: true, nullable: true, length: 4, defaultValue: null, modelName: CLASS ,
Coded Values:
[22: Class 22] , [23: Class 23] , [24: Class 24]
, ...14 more...
)
LINE_TYPE
( type: esriFieldTypeInteger, alias: LINE_TYPE, editable: true, nullable: true, defaultValue: null, modelName: LINE_TYPE ,
Coded Values:
[4: Hydrant Lead] , [5: Main Line] , [6: Unknown]
, ...4 more...
)
PIP_SIZE
( type: esriFieldTypeDouble, alias: PIP_SIZE, editable: true, nullable: true, defaultValue: 0, modelName: PIP_SIZE ,
Coded Values:
[0.75: 0.75"] , [1: 1"] , [1.5: 1.5"]
, ...40 more...
)
DATEABANDONED
( type: esriFieldTypeDate, alias: DATEABANDONED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEABANDONED )
MATERIAL_CD
( type: esriFieldTypeString, alias: MATERIAL_CD, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MATERIAL_CD ,
Coded Values:
[ASC: Asbestos Concrete Main] , [CI: Cast Iron Main] , [CON: Concrete Main]
, ...14 more...
)
COATING_TYPE_CD
( type: esriFieldTypeString, alias: COATING_TYPE_CD, editable: true, nullable: true, length: 3, defaultValue: null, modelName: COATING_TYPE_CD ,
Coded Values:
[AC: Asphaltic Compound] , [BI: Bituminous] , [CTE: Coal Tar Epoxy]
, ...10 more...
)
NORM_OP_PRESSURE
( type: esriFieldTypeDouble, alias: NORM_OP_PRESSURE, editable: true, nullable: true, defaultValue: 0, modelName: NORM_OP_PRESSURE )
MAX_OP_PRESSURE
( type: esriFieldTypeDouble, alias: MAX_OP_PRESSURE, editable: true, nullable: true, defaultValue: 0, modelName: MAX_OP_PRESSURE )
PRESSURE_CD
( type: esriFieldTypeString, alias: PRESSURE_CD, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PRESSURE_CD ,
Coded Values:
[HI: High Pressure] , [INT: Intermediate Pressure] , [LOW: Low Pressure]
, ...2 more...
)
PRESSURE_ZONE
( type: esriFieldTypeString, alias: PRESSURE_ZONE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: PRESSURE_ZONE ,
Coded Values:
[1: First] , [2: Second] , [2C: Colgate Second]
, ...17 more...
)
DEAD_END_IND
( type: esriFieldTypeString, alias: DEAD_END_IND, editable: true, nullable: true, length: 1, defaultValue: null, modelName: DEAD_END_IND ,
Coded Values:
[T: True] , [F: False] , [N: Could Not Determine]
, ...1 more...
)
FEAT_STATUS
( type: esriFieldTypeString, alias: FEAT_STATUS, editable: true, nullable: true, length: 3, defaultValue: ACT, modelName: FEAT_STATUS ,
Coded Values:
[ABD: Abandoned] , [ACT: Active] , [PRO: Proposed]
, ...11 more...
)
ENABLED
( type: esriFieldTypeSmallInteger, alias: ENABLED, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED ,
Coded Values:
[0: False] , [1: True] )
RESP_AGENCY
( type: esriFieldTypeString, alias: RESP_AGENCY, editable: true, nullable: true, length: 4, defaultValue: null, modelName: RESP_AGENCY ,
Coded Values:
[DPW: DPW] , [NDPW: Non-DPW] , [AA: Anne Arundel]
, ...10 more...
)
SYMBOL
( type: esriFieldTypeString, alias: SYMBOL, editable: true, nullable: true, length: 3, defaultValue: UNK, modelName: SYMBOL )
LAST_ORGANIZATION
( type: esriFieldTypeString, alias: LAST_ORGANIZATION, editable: true, nullable: true, length: 3, defaultValue: null, modelName: LAST_ORGANIZATION ,
Coded Values:
[100: Buchart Horn Inc] , [110: Chesapeake Environmental Management Inc] , [120: Enterprise Information Solutions, Inc.]
, ...12 more...
)
CAPTURE_METHOD
( type: esriFieldTypeString, alias: CAPTURE_METHOD, editable: true, nullable: true, length: 4, defaultValue: null, modelName: CAPTURE_METHOD ,
Coded Values:
[PLAT: Plat Map] , [CD: Contract Drawing] , [GN: Geometric Network]
, ...11 more...
)
LAST_USER
( type: esriFieldTypeString, alias: LAST_USER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAST_USER )
TAG
( type: esriFieldTypeString, alias: TAG, editable: true, nullable: true, length: 15, defaultValue: UNK, modelName: TAG )
EDIT_DATE
( type: esriFieldTypeDate, alias: EDIT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EDIT_DATE )
MAIN_ID
( type: esriFieldTypeString, alias: MAIN_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MAIN_ID )
COVER_DEPTH
( type: esriFieldTypeDouble, alias: COVER_DEPTH, editable: true, nullable: true, defaultValue: 0, modelName: COVER_DEPTH )
INSTALL_DATE
( type: esriFieldTypeDate, alias: INSTALL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_DATE )
LINING_DATE
( type: esriFieldTypeDate, alias: LINING_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LINING_DATE )
DOCPOPURL
( type: esriFieldTypeString, alias: DOCPOPURL, editable: true, nullable: true, length: 300, defaultValue: null, modelName: DOCPOPURL )
CITY_ENUM
( type: esriFieldTypeString, alias: CITY_ENUM, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CITY_ENUM )
LENGTH
( type: esriFieldTypeDouble, alias: LENGTH, editable: true, nullable: true, defaultValue: null, modelName: LENGTH )
LENGTH_divided_by_subsegs
( type: esriFieldTypeDouble, alias: LENGTH_divided_by_subsegs, editable: true, nullable: true, defaultValue: null, modelName: LENGTH_divided_by_subsegs )
LINING_TYPE_CD
( type: esriFieldTypeString, alias: LINING_TYPE_CD, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LINING_TYPE_CD ,
Coded Values:
[UNK: Unknown whether lining present] , [CLCM: Cleaned and Lined with Cement Mortar] , [PLCM: Pre-Lined with Cement Mortar]
, ...2 more...
)
FacilityID
( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
created_user
( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
created_date
( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
IN_SCOPE
( type: esriFieldTypeString, alias: IN_SCOPE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: IN_SCOPE ,
Coded Values:
[Yes: Yes] , [No: No] )
PROJECT
( type: esriFieldTypeString, alias: PROJECT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECT ,
Coded Values:
[1291: WC1291] , [1275: WC1275] , [1287: WC1287]
, ...1 more...
)
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Shape__Length
( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )
Templates:
Name: WA_Main
Description:
Prototype:
IN_SCOPE:
null
PROJECT:
null
CLASS:
null
LINE_TYPE:
null
PIP_SIZE:
0
DATEABANDONED:
null
MATERIAL_CD:
null
COATING_TYPE_CD:
null
NORM_OP_PRESSURE:
0
MAX_OP_PRESSURE:
0
PRESSURE_CD:
null
PRESSURE_ZONE:
null
DEAD_END_IND:
null
FEAT_STATUS:
ACT
ENABLED:
1
RESP_AGENCY:
null
SYMBOL:
UNK
LAST_ORGANIZATION:
null
CAPTURE_METHOD:
null
LAST_USER:
null
TAG:
UNK
EDIT_DATE:
null
MAIN_ID:
null
COVER_DEPTH:
0
INSTALL_DATE:
null
LINING_DATE:
null
DOCPOPURL:
null
CITY_ENUM:
null
LENGTH:
null
LENGTH_divided_by_subsegs:
null
LINING_TYPE_CD:
null
FacilityID:
null
created_user:
null
created_date:
null
last_edited_user:
null
last_edited_date:
null
Drawing Tool: esriFeatureEditToolLine
Relationships:
(4) --
Related To
:
AssetTrackers_DevelopmentDB.ASSET_TRACKER.Main_Work_Report
(6)
Tables:
Table:
AssetTrackers_DevelopmentDB.ASSET_TRACKER.Hydrant_Work_Report
(5)
Name:
AssetTrackers_DevelopmentDB.ASSET_TRACKER.Hydrant_Work_Report
Display Field:
Contractor
Type:
Table
Geometry Type:
N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Contractor
( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Contractor ,
Coded Values:
[J. Fletcher Creamer & Son, Inc: J. Fletcher Creamer & Son, Inc] , [Civil Construction LLC: Civil Construction LLC] )
Project_Number
( type: esriFieldTypeString, alias: Project_Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Project_Number ,
Coded Values:
[1291: WC1291] , [1275: WC1275] , [1287: WC1287]
, ...1 more...
)
Inspected_By
( type: esriFieldTypeString, alias: Inspected_By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspected_By ,
Coded Values:
[Ashley Galloway: Ashley Galloway] , [Luke Mulry: Luke Mulry] , [Clarence Wayman: Clarence Wayman]
, ...11 more...
)
Inspection_Date
( type: esriFieldTypeDate, alias: Inspection_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inspection_Date )
Hydrant_Work_Activity
( type: esriFieldTypeString, alias: Hydrant_Work_Activity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Hydrant_Work_Activity ,
Coded Values:
[Exercise/Test/Flush Fire Hydrants (Maintenance): Exercise/Test/Flush Fire Hydrants (Maintenance)] , [Painting/Repair of Fire Hydrants (Maintenance): Painting/Repair of Fire Hydrants (Maintenance)] , [Install New Fire Hydrant: Install New Fire Hydrant]
, ...3 more...
)
New_Lat_Size
( type: esriFieldTypeDouble, alias: New_Lat_Size, editable: true, nullable: true, defaultValue: null, modelName: New_Lat_Size )
New_Src_Main_Size
( type: esriFieldTypeDouble, alias: New_SRC_Main_Size, editable: true, nullable: true, defaultValue: null, modelName: New_Src_Main_Size )
Hydrant_Install_Date
( type: esriFieldTypeDate, alias: Hydrant_Install_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Hydrant_Install_Date )
Additional_Work_Activity
( type: esriFieldTypeString, alias: Additional_Work_Activity, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Additional_Work_Activity ,
Coded Values:
[Yes: Yes] , [No: No] )
Hydrant_Work_Activity1
( type: esriFieldTypeString, alias: Hydrant_Work_Activity1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Hydrant_Work_Activity1 ,
Coded Values:
[Exercise/Test/Flush Fire Hydrants (Maintenance): Exercise/Test/Flush Fire Hydrants (Maintenance)] , [Painting/Repair of Fire Hydrants (Maintenance): Painting/Repair of Fire Hydrants (Maintenance)] , [Install New Fire Hydrant: Install New Fire Hydrant]
, ...3 more...
)
Work_Activity_Date
( type: esriFieldTypeDate, alias: Work_Activity_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Work_Activity_Date )
Comment
( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 70, defaultValue: null, modelName: Comment )
Discrepancies
( type: esriFieldTypeString, alias: Discrepancies, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Discrepancies ,
Coded Values:
[Yes: Yes] , [No: No] )
Discrepancy_Type
( type: esriFieldTypeString, alias: Discrepancy_Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Discrepancy_Type ,
Coded Values:
[Attribute: Attribute] , [Geometry: Geometry] , [Other: Other (see comments)] )
Comments
( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Comments )
Work_Activity_Status
( type: esriFieldTypeString, alias: Work_Activity_Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Work_Activity_Status ,
Coded Values:
[Not Complete: Not Complete/In Progress] , [Current Complete: Current Work Activity Complete] , [All Complete: All Work Activities Complete]
, ...1 more...
)
In_Prog_Comment
( type: esriFieldTypeString, alias: In_Prog_Comment, editable: true, nullable: true, length: 150, defaultValue: null, modelName: In_Prog_Comment )
In_Service
( type: esriFieldTypeString, alias: In_Service, editable: true, nullable: true, length: 3, defaultValue: null, modelName: In_Service ,
Coded Values:
[Yes: Yes] , [No: No] )
All_Work_Complete
( type: esriFieldTypeString, alias: All_Work_Complete, editable: true, nullable: true, length: 3, defaultValue: null, modelName: All_Work_Complete ,
Coded Values:
[Yes: Yes] , [No: No] )
RelObjectID
( type: esriFieldTypeInteger, alias: RelObjectID, editable: true, nullable: true, defaultValue: null, modelName: RelObjectID )
Lat_Size_Same
( type: esriFieldTypeString, alias: Lat_Size_Same, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Lat_Size_Same ,
Coded Values:
[Yes: Yes] , [No: No] )
Src_Main_Size_Same
( type: esriFieldTypeString, alias: Src_Main_Size_Same, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Src_Main_Size_Same ,
Coded Values:
[Yes: Yes] , [No: No] )
Guid
( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
Hydrant_ID
( type: esriFieldTypeString, alias: Hydrant_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Hydrant_ID )
In_Scope
( type: esriFieldTypeString, alias: In_Scope, editable: true, nullable: true, length: 3, defaultValue: null, modelName: In_Scope ,
Coded Values:
[Yes: Yes] , [No: No] )
Templates:
Name: AssetTrackers_DevelopmentDB.ASSET_TRACKER.Hydrant_Work_Report
Description:
Prototype:
Hydrant_ID:
null
In_Scope:
null
Contractor:
null
Project_Number:
null
Inspected_By:
null
Inspection_Date:
null
Hydrant_Work_Activity:
null
New_Lat_Size:
null
New_Src_Main_Size:
null
Hydrant_Install_Date:
null
Additional_Work_Activity:
null
Hydrant_Work_Activity1:
null
Work_Activity_Date:
null
Comment:
null
Discrepancies:
null
Discrepancy_Type:
null
Comments:
null
Work_Activity_Status:
null
In_Prog_Comment:
null
In_Service:
null
All_Work_Complete:
null
RelObjectID:
null
Lat_Size_Same:
null
Src_Main_Size_Same:
null
Guid:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
(1) --
Related To
:
WA_Hydrant
(2)
Table:
AssetTrackers_DevelopmentDB.ASSET_TRACKER.Main_Work_Report
(6)
Name:
AssetTrackers_DevelopmentDB.ASSET_TRACKER.Main_Work_Report
Display Field:
Project_Number
Type:
Table
Geometry Type:
N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Project_Number
( type: esriFieldTypeString, alias: Project_Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Project_Number ,
Coded Values:
[1291: WC1291] , [1275: WC1275] , [1287: WC1287]
, ...1 more...
)
Contractor
( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Contractor ,
Coded Values:
[J. Fletcher Creamer & Son, Inc: J. Fletcher Creamer & Son, Inc] , [Civil Construction LLC: Civil Construction LLC] )
Inspected_By
( type: esriFieldTypeString, alias: Inspected_By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspected_By ,
Coded Values:
[Ashley Galloway: Ashley Galloway] , [Luke Mulry: Luke Mulry] , [Clarence Wayman: Clarence Wayman]
, ...11 more...
)
Inspection_Date
( type: esriFieldTypeDate, alias: Inspection_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inspection_Date )
Main_Work_Activity
( type: esriFieldTypeString, alias: Main_Work_Activity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Main_Work_Activity ,
Coded Values:
[CIPP Lining: CIPP Lining] , [Internal Joint Seal Repairs: Internal Joint Seal Repairs] , [Sliplining: Sliplining]
, ...10 more...
)
Pipe_Size_Same
( type: esriFieldTypeString, alias: Pipe_Size_Same, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Pipe_Size_Same ,
Coded Values:
[Yes: Yes] , [No: No] )
New_Pipe_Size
( type: esriFieldTypeDouble, alias: New_Pipe_Size, editable: true, nullable: true, defaultValue: null, modelName: New_Pipe_Size ,
Coded Values:
[0.75: 0.75"] , [1: 1"] , [1.5: 1.5"]
, ...40 more...
)
Material_Same
( type: esriFieldTypeString, alias: Material_Same, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Material_Same ,
Coded Values:
[Yes: Yes] , [No: No] )
New_Material
( type: esriFieldTypeString, alias: New_Material, editable: true, nullable: true, length: 3, defaultValue: null, modelName: New_Material ,
Coded Values:
[ASC: Asbestos Concrete Main] , [CI: Cast Iron Main] , [CON: Concrete Main]
, ...14 more...
)
Length_Same
( type: esriFieldTypeString, alias: Length_Same, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Length_Same ,
Coded Values:
[Yes: Yes] , [No: No] )
New_Length
( type: esriFieldTypeDouble, alias: New_Length, editable: true, nullable: true, defaultValue: null, modelName: New_Length )
Additional_Work_Activity
( type: esriFieldTypeString, alias: Additional_Work_Activity, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Additional_Work_Activity ,
Coded Values:
[Yes: Yes] , [No: No] )
Main_Work_Activity1
( type: esriFieldTypeString, alias: Main_Work_Activity1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Main_Work_Activity1 ,
Coded Values:
[CIPP Lining: CIPP Lining] , [Internal Joint Seal Repairs: Internal Joint Seal Repairs] , [Sliplining: Sliplining]
, ...10 more...
)
Discrepancies
( type: esriFieldTypeString, alias: Discrepancies, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Discrepancies ,
Coded Values:
[Yes: Yes] , [No: No] )
Discrepancy_Type
( type: esriFieldTypeString, alias: Discrepancy_Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Discrepancy_Type ,
Coded Values:
[Attribute: Attribute] , [Geometry: Geometry] , [Other: Other (see comments)] )
Comments
( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Comments )
Work_Activity_Status
( type: esriFieldTypeString, alias: Work_Activity_Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Work_Activity_Status ,
Coded Values:
[Not Complete: Not Complete/In Progress] , [Current Complete: Current Work Activity Complete] , [All Complete: All Work Activities Complete]
, ...1 more...
)
In_Prog_Comment
( type: esriFieldTypeString, alias: In_Prog_Comment, editable: true, nullable: true, length: 150, defaultValue: null, modelName: In_Prog_Comment )
In_Service
( type: esriFieldTypeString, alias: In_Service, editable: true, nullable: true, length: 3, defaultValue: null, modelName: In_Service ,
Coded Values:
[Yes: Yes] , [No: No] )
All_Work_Complete
( type: esriFieldTypeString, alias: All_Work_Complete, editable: true, nullable: true, length: 3, defaultValue: null, modelName: All_Work_Complete ,
Coded Values:
[Yes: Yes] , [No: No] )
RelObjectID
( type: esriFieldTypeInteger, alias: RelGlobalID, editable: true, nullable: true, defaultValue: null, modelName: RelObjectID )
Guid
( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
Main_ID
( type: esriFieldTypeString, alias: Main_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Main_ID )
In_Scope
( type: esriFieldTypeString, alias: In_Scope, editable: true, nullable: true, length: 3, defaultValue: null, modelName: In_Scope ,
Coded Values:
[Yes: Yes] , [No: No] )
Work_Activity_Date
( type: esriFieldTypeDate, alias: Work_Activity_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Work_Activity_Date )
Templates:
Name: AssetTrackers_DevelopmentDB.ASSET_TRACKER.Main_Work_Report
Description:
Prototype:
In_Scope:
null
Work_Activity_Date:
null
Project_Number:
null
Contractor:
null
Inspected_By:
null
Inspection_Date:
null
Main_Work_Activity:
null
Pipe_Size_Same:
null
New_Pipe_Size:
null
Material_Same:
null
New_Material:
null
Length_Same:
null
New_Length:
null
Additional_Work_Activity:
null
Main_Work_Activity1:
null
Discrepancies:
null
Discrepancy_Type:
null
Comments:
null
Work_Activity_Status:
null
In_Prog_Comment:
null
In_Service:
null
All_Work_Complete:
null
RelObjectID:
null
Guid:
null
Main_ID:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
(4) --
Related To
:
WA_Main
(4)
Table:
AssetTrackers_DevelopmentDB.ASSET_TRACKER.Meter_Work_Report
(7)
Name:
AssetTrackers_DevelopmentDB.ASSET_TRACKER.Meter_Work_Report
Display Field:
Contractor
Type:
Table
Geometry Type:
N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Contractor
( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Contractor ,
Coded Values:
[J. Fletcher Creamer & Son, Inc: J. Fletcher Creamer & Son, Inc] , [Civil Construction LLC: Civil Construction LLC] )
Project_Number
( type: esriFieldTypeString, alias: Project_Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Project_Number ,
Coded Values:
[1291: WC1291] , [1275: WC1275] , [1287: WC1287]
, ...1 more...
)
Inspected_By
( type: esriFieldTypeString, alias: Inspected_By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspected_By ,
Coded Values:
[Ashley Galloway: Ashley Galloway] , [Luke Mulry: Luke Mulry] , [Clarence Wayman: Clarence Wayman]
, ...11 more...
)
Inspection_Date
( type: esriFieldTypeDate, alias: Inspection_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inspection_Date )
Meter_Work_Activity
( type: esriFieldTypeString, alias: Meter_Work_Activity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Meter_Work_Activity ,
Coded Values:
[Retrofit / Repair Ex. Water Meter: Retrofit / Repair Ex. Water Meter] , [Replace Setting and Vault: Replace Setting and Vault] , [Replace Existing Water Meter: Replace Existing Water Meter]
, ...3 more...
)
MT_Size_Same
( type: esriFieldTypeString, alias: MT_Size_Same, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MT_Size_Same ,
Coded Values:
[Yes: Yes] , [No: No] )
New_MT_Size
( type: esriFieldTypeDouble, alias: New_MT_Size, editable: true, nullable: true, defaultValue: null, modelName: New_MT_Size )
Additional_Work_Activity
( type: esriFieldTypeString, alias: Additional_Work_Activity, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Additional_Work_Activity ,
Coded Values:
[Yes: Yes] , [No: No] )
Meter_Work_Activity1
( type: esriFieldTypeString, alias: Meter_Work_Activity1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Meter_Work_Activity1 ,
Coded Values:
[Retrofit / Repair Ex. Water Meter: Retrofit / Repair Ex. Water Meter] , [Replace Setting and Vault: Replace Setting and Vault] , [Replace Existing Water Meter: Replace Existing Water Meter]
, ...3 more...
)
Work_Activity_Date
( type: esriFieldTypeDate, alias: Work_Activity_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Work_Activity_Date )
Comment
( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 70, defaultValue: null, modelName: Comment )
Discrepancies
( type: esriFieldTypeString, alias: Discrepancies, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Discrepancies ,
Coded Values:
[Yes: Yes] , [No: No] )
Discrepancy_Type
( type: esriFieldTypeString, alias: Discrepancy_Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Discrepancy_Type ,
Coded Values:
[Attribute: Attribute] , [Geometry: Geometry] , [Other: Other (see comments)] )
Comments
( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Comments )
Work_Activity_Status
( type: esriFieldTypeString, alias: Work_Activity_Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Work_Activity_Status ,
Coded Values:
[Not Complete: Not Complete/In Progress] , [Current Complete: Current Work Activity Complete] , [All Complete: All Work Activities Complete]
, ...1 more...
)
In_Prog_Comment
( type: esriFieldTypeString, alias: In_Prog_Comment, editable: true, nullable: true, length: 150, defaultValue: null, modelName: In_Prog_Comment )
In_Service
( type: esriFieldTypeString, alias: In_Service, editable: true, nullable: true, length: 3, defaultValue: null, modelName: In_Service ,
Coded Values:
[Yes: Yes] , [No: No] )
All_Work_Complete
( type: esriFieldTypeString, alias: All_Work_Complete, editable: true, nullable: true, length: 3, defaultValue: null, modelName: All_Work_Complete ,
Coded Values:
[Yes: Yes] , [No: No] )
RelObjectID
( type: esriFieldTypeInteger, alias: RelObjectID, editable: true, nullable: true, defaultValue: null, modelName: RelObjectID )
Meter_Install_Date
( type: esriFieldTypeDate, alias: Meter_Install_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Meter_Install_Date )
Guid
( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
Meter_No
( type: esriFieldTypeString, alias: Meter_No, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Meter_No )
In_Scope
( type: esriFieldTypeString, alias: In_Scope, editable: true, nullable: true, length: 3, defaultValue: null, modelName: In_Scope ,
Coded Values:
[Yes: Yes] , [No: No] )
Templates:
Name: AssetTrackers_DevelopmentDB.ASSET_TRACKER.Meter_Work_Report
Description:
Prototype:
Meter_No:
null
In_Scope:
null
Contractor:
null
Project_Number:
null
Inspected_By:
null
Inspection_Date:
null
Meter_Work_Activity:
null
MT_Size_Same:
null
New_MT_Size:
null
Additional_Work_Activity:
null
Meter_Work_Activity1:
null
Work_Activity_Date:
null
Comment:
null
Discrepancies:
null
Discrepancy_Type:
null
Comments:
null
Work_Activity_Status:
null
In_Prog_Comment:
null
In_Service:
null
All_Work_Complete:
null
RelObjectID:
null
Meter_Install_Date:
null
Guid:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
(0) --
Related To
:
WA_Meter
(1)
Table:
AssetTrackers_DevelopmentDB.ASSET_TRACKER.Service_Work_Report
(8)
Name:
AssetTrackers_DevelopmentDB.ASSET_TRACKER.Service_Work_Report
Display Field:
Project_Number
Type:
Table
Geometry Type:
N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Project_Number
( type: esriFieldTypeString, alias: Project_Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Project_Number ,
Coded Values:
[1291: WC1291] , [1275: WC1275] , [1287: WC1287]
, ...1 more...
)
Contractor
( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Contractor ,
Coded Values:
[J. Fletcher Creamer & Son, Inc: J. Fletcher Creamer & Son, Inc] , [Civil Construction LLC: Civil Construction LLC] )
Inspected_By
( type: esriFieldTypeString, alias: Inspected_By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspected_By ,
Coded Values:
[Ashley Galloway: Ashley Galloway] , [Luke Mulry: Luke Mulry] , [Clarence Wayman: Clarence Wayman]
, ...11 more...
)
Inspection_Date
( type: esriFieldTypeDate, alias: Inspection_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inspection_Date )
Service_Work_Act
( type: esriFieldTypeString, alias: Service_Work_Act, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Service_Work_Act ,
Coded Values:
[Renew Water Service: Renew Water Service] , [New Water Service: New Water Service] , [Replace Existing Water Service: Replace Existing Water Service]
, ...2 more...
)
Pipe_Size_Same
( type: esriFieldTypeString, alias: Pipe_Size_Same, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Pipe_Size_Same ,
Coded Values:
[Yes: Yes] , [No: No] )
New_Pipe_Size
( type: esriFieldTypeDouble, alias: New_Pipe_Size, editable: true, nullable: true, defaultValue: null, modelName: New_Pipe_Size ,
Coded Values:
[0.63: .63"] , [0.75: .75"] , [1: 1"]
, ...10 more...
)
Material_Same
( type: esriFieldTypeString, alias: Material_Same, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Material_Same ,
Coded Values:
[Yes: Yes] , [No: No] )
New_Material
( type: esriFieldTypeString, alias: New_Material, editable: true, nullable: true, length: 3, defaultValue: null, modelName: New_Material ,
Coded Values:
[CI: Cast Iron] , [COP: Copper] , [DI: Ductile Iron]
, ...6 more...
)
Length_Same
( type: esriFieldTypeString, alias: Length_Same, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Length_Same ,
Coded Values:
[Yes: Yes] , [No: No] )
New_Length
( type: esriFieldTypeDouble, alias: New_Length, editable: true, nullable: true, defaultValue: null, modelName: New_Length )
Additional_Work_Activity
( type: esriFieldTypeString, alias: Additional_Work_Activity, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Additional_Work_Activity ,
Coded Values:
[Yes: Yes] , [No: No] )
Service_Work_Act1
( type: esriFieldTypeString, alias: Service_Work_Act1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Service_Work_Act1 ,
Coded Values:
[Renew Water Service: Renew Water Service] , [New Water Service: New Water Service] , [Replace Existing Water Service: Replace Existing Water Service]
, ...2 more...
)
Discrepancies
( type: esriFieldTypeString, alias: Discrepancies, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Discrepancies ,
Coded Values:
[Yes: Yes] , [No: No] )
Discrepancy_Type
( type: esriFieldTypeString, alias: Discrepancy_Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Discrepancy_Type ,
Coded Values:
[Attribute: Attribute] , [Geometry: Geometry] , [Other: Other (see comments)] )
Comments
( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Comments )
Work_Activity_Status
( type: esriFieldTypeString, alias: Work_Activity_Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Work_Activity_Status ,
Coded Values:
[Not Complete: Not Complete/In Progress] , [Current Complete: Current Work Activity Complete] , [All Complete: All Work Activities Complete]
, ...1 more...
)
In_Prog_Comment
( type: esriFieldTypeString, alias: In_Prog_Comment, editable: true, nullable: true, length: 150, defaultValue: null, modelName: In_Prog_Comment )
In_Service
( type: esriFieldTypeString, alias: In_Service, editable: true, nullable: true, length: 3, defaultValue: null, modelName: In_Service ,
Coded Values:
[Yes: Yes] , [No: No] )
All_Work_Complete
( type: esriFieldTypeString, alias: All_Work_Complete, editable: true, nullable: true, length: 3, defaultValue: null, modelName: All_Work_Complete ,
Coded Values:
[Yes: Yes] , [No: No] )
RelObjectID
( type: esriFieldTypeInteger, alias: RelGlobalID, editable: true, nullable: true, defaultValue: null, modelName: RelObjectID )
Guid
( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
FacilityID
( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
In_Scope
( type: esriFieldTypeString, alias: In_Scope, editable: true, nullable: true, length: 3, defaultValue: null, modelName: In_Scope ,
Coded Values:
[Yes: Yes] , [No: No] )
Work_Activity_Date
( type: esriFieldTypeDate, alias: Work_Activity_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Work_Activity_Date )
Templates:
Name: AssetTrackers_DevelopmentDB.ASSET_TRACKER.Service_Work_Report
Description:
Prototype:
In_Scope:
null
Work_Activity_Date:
null
Project_Number:
null
Contractor:
null
Inspected_By:
null
Inspection_Date:
null
Service_Work_Act:
null
Pipe_Size_Same:
null
New_Pipe_Size:
null
Material_Same:
null
New_Material:
null
Length_Same:
null
New_Length:
null
Additional_Work_Activity:
null
Service_Work_Act1:
null
Discrepancies:
null
Discrepancy_Type:
null
Comments:
null
Work_Activity_Status:
null
In_Prog_Comment:
null
In_Service:
null
All_Work_Complete:
null
RelObjectID:
null
Guid:
null
FacilityID:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
(3) --
Related To
:
WA_Service
(3)
Table:
AssetTrackers_DevelopmentDB.ASSET_TRACKER.Valve_Work_Report
(9)
Name:
AssetTrackers_DevelopmentDB.ASSET_TRACKER.Valve_Work_Report
Display Field:
Contractor
Type:
Table
Geometry Type:
N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Contractor
( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Contractor ,
Coded Values:
[J. Fletcher Creamer & Son, Inc: J. Fletcher Creamer & Son, Inc] , [Civil Construction LLC: Civil Construction LLC] )
Project_Number
( type: esriFieldTypeString, alias: Project_Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Project_Number ,
Coded Values:
[1291: WC1291] , [1275: WC1275] , [1287: WC1287]
, ...1 more...
)
Inspected_By
( type: esriFieldTypeString, alias: Inspected_By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspected_By ,
Coded Values:
[Ashley Galloway: Ashley Galloway] , [Luke Mulry: Luke Mulry] , [Clarence Wayman: Clarence Wayman]
, ...11 more...
)
Inspection_Date
( type: esriFieldTypeDate, alias: Inspection_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inspection_Date )
Valve_Work_Activity
( type: esriFieldTypeString, alias: Valve_Work_Activity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Valve_Work_Activity ,
Coded Values:
[Exercise Water Valves (Maintenance): Exercise Water Valves (Maintenance)] , [New Water Valve and Vault: New Water Valve and Vault] , [Replace Existing Water Valve: Replace Existing Water Valve]
, ...3 more...
)
VLV_Size_Same
( type: esriFieldTypeString, alias: VLV_Size_Same, editable: true, nullable: true, length: 3, defaultValue: null, modelName: VLV_Size_Same ,
Coded Values:
[Yes: Yes] , [No: No] )
New_VLV_Size
( type: esriFieldTypeDouble, alias: New_VLV_Size, editable: true, nullable: true, defaultValue: null, modelName: New_VLV_Size )
Additional_Work_Activity
( type: esriFieldTypeString, alias: Additional_Work_Activity, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Additional_Work_Activity ,
Coded Values:
[Yes: Yes] , [No: No] )
Valve_Work_Activity1
( type: esriFieldTypeString, alias: Valve_Work_Activity1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Valve_Work_Activity1 ,
Coded Values:
[Exercise Water Valves (Maintenance): Exercise Water Valves (Maintenance)] , [New Water Valve and Vault: New Water Valve and Vault] , [Replace Existing Water Valve: Replace Existing Water Valve]
, ...3 more...
)
Work_Activity_Date
( type: esriFieldTypeDate, alias: Work_Activity_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Work_Activity_Date )
Comment
( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 70, defaultValue: null, modelName: Comment )
Discrepancies
( type: esriFieldTypeString, alias: Discrepancies, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Discrepancies ,
Coded Values:
[Yes: Yes] , [No: No] )
Discrepancy_Type
( type: esriFieldTypeString, alias: Discrepancy_Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Discrepancy_Type ,
Coded Values:
[Attribute: Attribute] , [Geometry: Geometry] , [Other: Other (see comments)] )
Comments
( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Comments )
Work_Activity_Status
( type: esriFieldTypeString, alias: Work_Activity_Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Work_Activity_Status ,
Coded Values:
[Not Complete: Not Complete/In Progress] , [Current Complete: Current Work Activity Complete] , [All Complete: All Work Activities Complete]
, ...1 more...
)
In_Prog_Comment
( type: esriFieldTypeString, alias: In_Prog_Comment, editable: true, nullable: true, length: 150, defaultValue: null, modelName: In_Prog_Comment )
In_Service
( type: esriFieldTypeString, alias: In_Service, editable: true, nullable: true, length: 3, defaultValue: null, modelName: In_Service ,
Coded Values:
[Yes: Yes] , [No: No] )
All_Work_Complete
( type: esriFieldTypeString, alias: All_Work_Complete, editable: true, nullable: true, length: 3, defaultValue: null, modelName: All_Work_Complete ,
Coded Values:
[Yes: Yes] , [No: No] )
RelObjectID
( type: esriFieldTypeInteger, alias: RelObjectID, editable: true, nullable: true, defaultValue: null, modelName: RelObjectID )
Valve_Install_Date
( type: esriFieldTypeDate, alias: Valve_Install_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Valve_Install_Date )
Guid
( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
VLV_ID
( type: esriFieldTypeString, alias: VLV_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: VLV_ID )
In_Scope
( type: esriFieldTypeString, alias: In_Scope, editable: true, nullable: true, length: 3, defaultValue: null, modelName: In_Scope ,
Coded Values:
[Yes: Yes] , [No: No] )
Templates:
Name: AssetTrackers_DevelopmentDB.ASSET_TRACKER.Valve_Work_Report
Description:
Prototype:
VLV_ID:
null
In_Scope:
null
Contractor:
null
Project_Number:
null
Inspected_By:
null
Inspection_Date:
null
Valve_Work_Activity:
null
VLV_Size_Same:
null
New_VLV_Size:
null
Additional_Work_Activity:
null
Valve_Work_Activity1:
null
Work_Activity_Date:
null
Comment:
null
Discrepancies:
null
Discrepancy_Type:
null
Comments:
null
Work_Activity_Status:
null
In_Prog_Comment:
null
In_Service:
null
All_Work_Complete:
null
RelObjectID:
null
Valve_Install_Date:
null
Guid:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
(2) --
Related To
:
WA_Valve
(0)