ArcGIS REST Services Directory
Login
Home
>
services
>
Storm_MasterITPipes (MapServer)
>
All Layers and Tables
Help
|
API Reference
JSON
All Layers and Tables (Storm_MasterITPipes)
Layers:
Layer:
CollectionSystem.DBO.swMain
(0)
Name:
CollectionSystem.DBO.swMain
Display Field:
FACILITYID
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
Service Item Id:
a2e4f8c5b49a4c218b7035a1ce8620d1
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON
Min Scale:
0
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 260916.8001726605
YMin: 2169748.6575299054
XMax: 307793.67951582745
YMax: 2198837.765362069
Spatial Reference: 2244 (2965)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSLSSolid
Color:
[130, 0, 82, 255]
Width:
1
Label:
Description:
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
FACILITYID
( type: esriFieldTypeString, alias: Facility Identifier, length: 30 )
INSTALLDATE
( type: esriFieldTypeDate, alias: Install Date, length: 8 )
MAINSHAPE
( type: esriFieldTypeString, alias: Main Shape, length: 50 )
LINEDYEAR
( type: esriFieldTypeString, alias: Year Lined, length: 4 )
LINERTYPE
( type: esriFieldTypeString, alias: Liner Type, length: 20 )
FROMMH
( type: esriFieldTypeString, alias: From Manhole, length: 11 )
TOMH
( type: esriFieldTypeString, alias: To Manhole, length: 11 )
ACTIVEFLAG
( type: esriFieldTypeSmallInteger, alias: Active Flag ,
Coded Values:
[0: False] , [1: True] )
SUMFLOW
( type: esriFieldTypeDouble, alias: Flow Summary )
LASTUPDATE
( type: esriFieldTypeDate, alias: Last Update Date, length: 8 )
LASTEDITOR
( type: esriFieldTypeString, alias: Last Editor, length: 50 )
DOWNELEV
( type: esriFieldTypeDouble, alias: Downstream Elevation )
UPELEV
( type: esriFieldTypeDouble, alias: Upstream Elevation )
SLOPE
( type: esriFieldTypeDouble, alias: Slope )
TYPE
( type: esriFieldTypeString, alias: TYPE, length: 25 )
PIPE_SIZE
( type: esriFieldTypeSmallInteger, alias: PIPE_SIZE )
NOTES
( type: esriFieldTypeString, alias: NOTES, length: 50 )
STATUS
( type: esriFieldTypeString, alias: STATUS, length: 50 )
Enabled
( type: esriFieldTypeSmallInteger, alias: Enabled ,
Coded Values:
[0: False] , [1: True] )
UPMH
( type: esriFieldTypeString, alias: UPMH, length: 10 )
DNMH
( type: esriFieldTypeString, alias: DNMH, length: 10 )
UNIQUEID
( type: esriFieldTypeString, alias: UNIQUEID, length: 21 )
Road
( type: esriFieldTypeString, alias: Road, length: 50 )
RuleID
( type: esriFieldTypeInteger, alias: RuleID ,
Coded Values:
[1:
] , [2:
] , [3: ABANDONED]
, ...5 more...
)
GIS_Length
( type: esriFieldTypeDouble, alias: GIS_Length )
CCTV_Length
( type: esriFieldTypeDouble, alias: CCTV_Length )
CITY
( type: esriFieldTypeString, alias: CITY, length: 25 )
GridPage
( type: esriFieldTypeString, alias: GridPage, length: 3 )
Page
( type: esriFieldTypeString, alias: Page, length: 3 )
Owner
( type: esriFieldTypeString, alias: Owner, length: 50 )
Customer
( type: esriFieldTypeString, alias: Customer, length: 50 )
USE_
( type: esriFieldTypeString, alias: USE, length: 3 )
CCTV_Video
( type: esriFieldTypeString, alias: CCTV_Video, length: 150 )
CCTV_Date
( type: esriFieldTypeString, alias: CCTV_Date, length: 50 )
CCTV_Sheet
( type: esriFieldTypeSmallInteger, alias: CCTV_Sheet )
created_user
( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date
( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
SHAPE_STLength__
( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
SHAPE_STLength_1
( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
SHAPE
( type: esriFieldTypeGeometry, alias: SHAPE )
FROMTYPE
( type: esriFieldTypeString, alias: FROMTYPE, length: 50 )
TOTYPE
( type: esriFieldTypeString, alias: TOTYPE, length: 50 )
DataSource
( type: esriFieldTypeString, alias: DataSource, length: 150 )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
DIAMETER
( type: esriFieldTypeDouble, alias: DIAMETER )
MATERIAL_CCTV
( type: esriFieldTypeString, alias: MATERIAL_CCTV, length: 150 )
Street
( type: esriFieldTypeString, alias: Street, length: 250 )
MATERIAL
( type: esriFieldTypeString, alias: MATERIAL, length: 255 )
Field
( type: esriFieldTypeInteger, alias: Field )
Feet
( type: esriFieldTypeDouble, alias: Feet )
SHAPE.STLength()
( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
Relationships:
Storm_Master.DBO.%QueryITPipesStorm_Master (0) --
Related To
:
Storm_Master.DBO.QueryITPipesStorm_Master
(1)
Storm_Master.DBO.%QueryITPipesStorm_Master_1 (1) --
Related To
:
Storm_Master.DBO.QueryITPipesStorm_Master_NOT
(4)
Layer:
Storm_Master.DBO.QueryITPipesStorm_Master
(1)
Name:
Storm_Master.DBO.QueryITPipesStorm_Master
Display Field:
ML_Name
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
Service Item Id:
a2e4f8c5b49a4c218b7035a1ce8620d1
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON
Min Scale:
0
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 267683.37292557955
YMin: 2169758.612234406
XMax: 293477.55755757913
YMax: 2198837.765362069
Spatial Reference: 2244 (2965)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSLSSolid
Color:
[0, 0, 0, 255]
Width:
1
Label:
Description:
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
null
Fields:
ML_ID
( type: esriFieldTypeOID, alias: ML_ID )
US_MH
( type: esriFieldTypeString, alias: US_MH, length: 50 )
DS_MH
( type: esriFieldTypeString, alias: DS_MH, length: 50 )
ML_Name
( type: esriFieldTypeString, alias: ML_Name, length: 51 )
Inspection_Direction
( type: esriFieldTypeString, alias: Inspection_Direction, length: 50 )
Inspected_Length
( type: esriFieldTypeDouble, alias: Inspected_Length )
Operator
( type: esriFieldTypeString, alias: Operator, length: 50 )
Media_Path_ID
( type: esriFieldTypeInteger, alias: Media_Path_ID )
File_Name
( type: esriFieldTypeString, alias: File_Name, length: 255 )
Media_ID
( type: esriFieldTypeInteger, alias: Media_ID )
File_Path
( type: esriFieldTypeString, alias: File_Path, length: 255 )
FACILITYID
( type: esriFieldTypeString, alias: FACILITYID, length: 30 )
SHAPE
( type: esriFieldTypeGeometry, alias: SHAPE )
SHAPE_STLength_1
( type: esriFieldTypeDouble, alias: SHAPE_STLength_1 )
SHAPE_STLength__
( type: esriFieldTypeDouble, alias: SHAPE_STLength__ )
Inspection_Date
( type: esriFieldTypeDate, alias: Inspection_Date, length: 8 )
Pipe_Height
( type: esriFieldTypeDouble, alias: Pipe_Height )
Relationships:
CollectionSystem.DBO.swMain (0) --
Related To
:
CollectionSystem.DBO.swMain
(0)
Layer:
cctv storm
(2)
Name:
cctv storm
Display Field:
CollectionSystem.DBO.swMain.FACILITYID
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
Service Item Id:
a2e4f8c5b49a4c218b7035a1ce8620d1
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON
Min Scale:
0
Max Scale:
0
Supports Advanced Queries:
false
Supports Statistics:
false
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 260916.8001726605
YMin: 2169748.6575299054
XMax: 307793.67951582745
YMax: 2198837.765362069
Spatial Reference: 2244 (2965)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSLSSolid
Color:
[0, 0, 0, 255]
Width:
1
Label:
Description:
Transparency:
0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: false
Supports OrderBy: false
Supports Distinct: false
Supports Pagination: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: false
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
null
Fields:
CollectionSystem.DBO.swMain.OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
CollectionSystem.DBO.swMain.FACILITYID
( type: esriFieldTypeString, alias: Facility Identifier, length: 30 )
CollectionSystem.DBO.swMain.INSTALLDATE
( type: esriFieldTypeDate, alias: Install Date, length: 8 )
CollectionSystem.DBO.swMain.MAINSHAPE
( type: esriFieldTypeString, alias: Main Shape, length: 50 )
CollectionSystem.DBO.swMain.LINEDYEAR
( type: esriFieldTypeString, alias: Year Lined, length: 4 )
CollectionSystem.DBO.swMain.LINERTYPE
( type: esriFieldTypeString, alias: Liner Type, length: 20 )
CollectionSystem.DBO.swMain.FROMMH
( type: esriFieldTypeString, alias: From Manhole, length: 11 )
CollectionSystem.DBO.swMain.TOMH
( type: esriFieldTypeString, alias: To Manhole, length: 11 )
CollectionSystem.DBO.swMain.ACTIVEFLAG
( type: esriFieldTypeSmallInteger, alias: Active Flag ,
Coded Values:
[0: False] , [1: True] )
CollectionSystem.DBO.swMain.SUMFLOW
( type: esriFieldTypeDouble, alias: Flow Summary )
CollectionSystem.DBO.swMain.LASTUPDATE
( type: esriFieldTypeDate, alias: Last Update Date, length: 8 )
CollectionSystem.DBO.swMain.LASTEDITOR
( type: esriFieldTypeString, alias: Last Editor, length: 50 )
CollectionSystem.DBO.swMain.DOWNELEV
( type: esriFieldTypeDouble, alias: Downstream Elevation )
CollectionSystem.DBO.swMain.UPELEV
( type: esriFieldTypeDouble, alias: Upstream Elevation )
CollectionSystem.DBO.swMain.SLOPE
( type: esriFieldTypeDouble, alias: Slope )
CollectionSystem.DBO.swMain.TYPE
( type: esriFieldTypeString, alias: TYPE, length: 25 )
CollectionSystem.DBO.swMain.PIPE_SIZE
( type: esriFieldTypeSmallInteger, alias: PIPE_SIZE )
CollectionSystem.DBO.swMain.NOTES
( type: esriFieldTypeString, alias: NOTES, length: 50 )
CollectionSystem.DBO.swMain.STATUS
( type: esriFieldTypeString, alias: STATUS, length: 50 )
CollectionSystem.DBO.swMain.Enabled
( type: esriFieldTypeSmallInteger, alias: Enabled ,
Coded Values:
[0: False] , [1: True] )
CollectionSystem.DBO.swMain.UPMH
( type: esriFieldTypeString, alias: UPMH, length: 10 )
CollectionSystem.DBO.swMain.DNMH
( type: esriFieldTypeString, alias: DNMH, length: 10 )
CollectionSystem.DBO.swMain.UNIQUEID
( type: esriFieldTypeString, alias: UNIQUEID, length: 21 )
CollectionSystem.DBO.swMain.Road
( type: esriFieldTypeString, alias: Road, length: 50 )
CollectionSystem.DBO.swMain.RuleID
( type: esriFieldTypeInteger, alias: RuleID ,
Coded Values:
[1:
] , [2:
] , [3: ABANDONED]
, ...5 more...
)
CollectionSystem.DBO.swMain.GIS_Length
( type: esriFieldTypeDouble, alias: GIS_Length )
CollectionSystem.DBO.swMain.CCTV_Length
( type: esriFieldTypeDouble, alias: CCTV_Length )
CollectionSystem.DBO.swMain.CITY
( type: esriFieldTypeString, alias: CITY, length: 25 )
CollectionSystem.DBO.swMain.GridPage
( type: esriFieldTypeString, alias: GridPage, length: 3 )
CollectionSystem.DBO.swMain.Page
( type: esriFieldTypeString, alias: Page, length: 3 )
CollectionSystem.DBO.swMain.Owner
( type: esriFieldTypeString, alias: Owner, length: 50 )
CollectionSystem.DBO.swMain.Customer
( type: esriFieldTypeString, alias: Customer, length: 50 )
CollectionSystem.DBO.swMain.USE_
( type: esriFieldTypeString, alias: USE, length: 3 )
CollectionSystem.DBO.swMain.CCTV_Video
( type: esriFieldTypeString, alias: CCTV_Video, length: 150 )
CollectionSystem.DBO.swMain.CCTV_Date
( type: esriFieldTypeString, alias: CCTV_Date, length: 50 )
CollectionSystem.DBO.swMain.CCTV_Sheet
( type: esriFieldTypeSmallInteger, alias: CCTV_Sheet )
CollectionSystem.DBO.swMain.created_user
( type: esriFieldTypeString, alias: created_user, length: 255 )
CollectionSystem.DBO.swMain.created_date
( type: esriFieldTypeDate, alias: created_date, length: 8 )
CollectionSystem.DBO.swMain.last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
CollectionSystem.DBO.swMain.last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
CollectionSystem.DBO.swMain.SHAPE_STLength__
( type: esriFieldTypeDouble, alias: STLength() )
CollectionSystem.DBO.swMain.SHAPE_STLength_1
( type: esriFieldTypeDouble, alias: STLength() )
CollectionSystem.DBO.swMain.SHAPE
( type: esriFieldTypeGeometry, alias: SHAPE )
CollectionSystem.DBO.swMain.FROMTYPE
( type: esriFieldTypeString, alias: FROMTYPE, length: 50 )
CollectionSystem.DBO.swMain.TOTYPE
( type: esriFieldTypeString, alias: TOTYPE, length: 50 )
CollectionSystem.DBO.swMain.DataSource
( type: esriFieldTypeString, alias: DataSource, length: 150 )
CollectionSystem.DBO.swMain.GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
CollectionSystem.DBO.swMain.DIAMETER
( type: esriFieldTypeDouble, alias: DIAMETER )
CollectionSystem.DBO.swMain.MATERIAL_CCTV
( type: esriFieldTypeString, alias: MATERIAL_CCTV, length: 150 )
CollectionSystem.DBO.swMain.Street
( type: esriFieldTypeString, alias: Street, length: 250 )
CollectionSystem.DBO.swMain.MATERIAL
( type: esriFieldTypeString, alias: MATERIAL, length: 255 )
CollectionSystem.DBO.swMain.Field
( type: esriFieldTypeInteger, alias: Field )
CollectionSystem.DBO.swMain.Feet
( type: esriFieldTypeDouble, alias: CollectionSystem.DBO.swMain.Feet )
SHAPE.STLength()
( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
ElementsXS.DBO.%Storm CCTV.TaskID
( type: esriFieldTypeInteger, alias: TaskID )
ElementsXS.DBO.%Storm CCTV.ServiceOrderDetailID
( type: esriFieldTypeInteger, alias: ServiceOrderDetailID )
ElementsXS.DBO.%Storm CCTV.CreatedByID
( type: esriFieldTypeInteger, alias: CreatedByID )
ElementsXS.DBO.%Storm CCTV.DateCreated
( type: esriFieldTypeDate, alias: DateCreated, length: 8 )
ElementsXS.DBO.%Storm CCTV.ScheduledStartDate
( type: esriFieldTypeDate, alias: ScheduledStartDate, length: 8 )
ElementsXS.DBO.%Storm CCTV.ScheduledEndDate
( type: esriFieldTypeDate, alias: ScheduledEndDate, length: 8 )
ElementsXS.DBO.%Storm CCTV.ActualStartDate
( type: esriFieldTypeDate, alias: ActualStartDate, length: 8 )
ElementsXS.DBO.%Storm CCTV.ActualEndDate
( type: esriFieldTypeDate, alias: ActualEndDate, length: 8 )
ElementsXS.DBO.%Storm CCTV.Priority
( type: esriFieldTypeString, alias: Priority, length: 50 )
ElementsXS.DBO.%Storm CCTV.Status
( type: esriFieldTypeString, alias: Status, length: 50 )
ElementsXS.DBO.%Storm CCTV.TaskType
( type: esriFieldTypeString, alias: TaskType, length: 50 )
ElementsXS.DBO.%Storm CCTV.Completed
( type: esriFieldTypeSmallInteger, alias: Completed )
ElementsXS.DBO.%Storm CCTV.IsWorkItemType
( type: esriFieldTypeSmallInteger, alias: IsWorkItemType )
ElementsXS.DBO.%Storm CCTV.ServiceOrderNumber
( type: esriFieldTypeString, alias: ServiceOrderNumber, length: 50 )
ElementsXS.DBO.%Storm CCTV.ServiceOrderID
( type: esriFieldTypeInteger, alias: ServiceOrderID )
ElementsXS.DBO.%Storm CCTV.IsLocation
( type: esriFieldTypeSmallInteger, alias: IsLocation )
ElementsXS.DBO.%Storm CCTV.LocationID
( type: esriFieldTypeString, alias: LocationID, length: 250 )
ElementsXS.DBO.%Storm CCTV.LocationNo
( type: esriFieldTypeString, alias: LocationNo, length: 50 )
ElementsXS.DBO.%Storm CCTV.Location
( type: esriFieldTypeString, alias: Location, length: 250 )
ElementsXS.DBO.%Storm CCTV.IsCustomer
( type: esriFieldTypeSmallInteger, alias: IsCustomer )
ElementsXS.DBO.%Storm CCTV.CustomerID
( type: esriFieldTypeString, alias: CustomerID, length: 250 )
ElementsXS.DBO.%Storm CCTV.CustomerNo
( type: esriFieldTypeString, alias: CustomerNo, length: 50 )
ElementsXS.DBO.%Storm CCTV.Customer
( type: esriFieldTypeString, alias: Customer, length: 250 )
ElementsXS.DBO.%Storm CCTV.IsService
( type: esriFieldTypeSmallInteger, alias: IsService )
ElementsXS.DBO.%Storm CCTV.ServiceID
( type: esriFieldTypeString, alias: ServiceID, length: 250 )
ElementsXS.DBO.%Storm CCTV.Service
( type: esriFieldTypeString, alias: Service, length: 50 )
ElementsXS.DBO.%Storm CCTV.IsMeter
( type: esriFieldTypeSmallInteger, alias: IsMeter )
ElementsXS.DBO.%Storm CCTV.MeterID
( type: esriFieldTypeString, alias: MeterID, length: 250 )
ElementsXS.DBO.%Storm CCTV.MeterNo
( type: esriFieldTypeString, alias: MeterNo, length: 50 )
ElementsXS.DBO.%Storm CCTV.IsGISAsset
( type: esriFieldTypeSmallInteger, alias: IsGISAsset )
ElementsXS.DBO.%Storm CCTV.GISFileID
( type: esriFieldTypeInteger, alias: GISFileID )
ElementsXS.DBO.%Storm CCTV.GISLayer
( type: esriFieldTypeString, alias: GISLayer, length: 50 )
ElementsXS.DBO.%Storm CCTV.IsAsset
( type: esriFieldTypeSmallInteger, alias: IsAsset )
ElementsXS.DBO.%Storm CCTV.SchemaDocGuid
( type: esriFieldTypeGUID, alias: SchemaDocGuid, length: 38 )
ElementsXS.DBO.%Storm CCTV.UtilityBillingServiceCodeTypeID
( type: esriFieldTypeInteger, alias: UtilityBillingServiceCodeTypeID )
ElementsXS.DBO.%Storm CCTV.IsUtilityBillingServiceOrder
( type: esriFieldTypeSmallInteger, alias: IsUtilityBillingServiceOrder )
ElementsXS.DBO.%Storm CCTV.FeePosted
( type: esriFieldTypeSmallInteger, alias: FeePosted )
ElementsXS.DBO.%Storm CCTV.PriorityColor
( type: esriFieldTypeString, alias: PriorityColor, length: 50 )
ElementsXS.DBO.%Storm CCTV.FeeAmount
( type: esriFieldTypeDouble, alias: FeeAmount )
ElementsXS.DBO.%Storm CCTV.BillToAccount
( type: esriFieldTypeString, alias: ElementsXS.DBO.%Storm CCTV.BillToAccount, length: 250 )
ElementsXS.DBO.%Storm CCTV.CompletedByFirstName
( type: esriFieldTypeString, alias: CompletedByFirstName, length: 50 )
ElementsXS.DBO.%Storm CCTV.CompletedByLast
( type: esriFieldTypeString, alias: CompletedByLast, length: 50 )
ElementsXS.DBO.%Storm CCTV.LastModifiedByID
( type: esriFieldTypeInteger, alias: LastModifiedByID )
ElementsXS.DBO.%Storm CCTV.LastModified
( type: esriFieldTypeDate, alias: LastModified, length: 8 )
ElementsXS.DBO.%Storm CCTV.PriorityID
( type: esriFieldTypeInteger, alias: PriorityID )
ElementsXS.DBO.%Storm CCTV.StatusID
( type: esriFieldTypeInteger, alias: StatusID )
ElementsXS.DBO.%Storm CCTV.TaskTypeID
( type: esriFieldTypeInteger, alias: TaskTypeID )
ElementsXS.DBO.%Storm CCTV.ServiceOrderDetailTypeID
( type: esriFieldTypeInteger, alias: ServiceOrderDetailTypeID )
ElementsXS.DBO.%Storm CCTV.LOC_Address
( type: esriFieldTypeString, alias: LOC_Address, length: 500 )
ElementsXS.DBO.%Storm CCTV.LOC_City
( type: esriFieldTypeString, alias: LOC_City, length: 500 )
ElementsXS.DBO.%Storm CCTV.CUST_Name
( type: esriFieldTypeString, alias: CUST_Name, length: 500 )
ElementsXS.DBO.%Storm CCTV.GIS_AssetTag
( type: esriFieldTypeString, alias: GIS_AssetTag, length: 500 )
ElementsXS.DBO.%Storm CCTV.AssetNo
( type: esriFieldTypeInteger, alias: AssetNo )
ElementsXS.DBO.%Storm CCTV.ASSET_AssetTag
( type: esriFieldTypeString, alias: ASSET_AssetTag, length: 500 )
ElementsXS.DBO.%Storm CCTV.AssetID
( type: esriFieldTypeString, alias: AssetID, length: 50 )
ElementsXS.DBO.%Storm CCTV.AssetLocation
( type: esriFieldTypeString, alias: AssetLocation, length: 1073741822 )
ElementsXS.DBO.%Storm CCTV.AssetStatus
( type: esriFieldTypeString, alias: AssetStatus, length: 50 )
ElementsXS.DBO.%Storm CCTV.AssetType
( type: esriFieldTypeString, alias: AssetType, length: 50 )
ElementsXS.DBO.%Storm CCTV.TaskAssignmentCrews
( type: esriFieldTypeString, alias: TaskAssignmentCrews, length: 1073741822 )
ElementsXS.DBO.%Storm CCTV.TaskAssignmentUsers
( type: esriFieldTypeString, alias: TaskAssignmentUsers, length: 1073741822 )
ElementsXS.DBO.%Storm CCTV.TaskAssignmentContacts
( type: esriFieldTypeString, alias: TaskAssignmentContacts, length: 1073741822 )
ElementsXS.DBO.%Storm CCTV.GISAssetNo
( type: esriFieldTypeString, alias: GISAssetNo, length: 250 )
ElementsXS.DBO.%Storm CCTV.DivisionID
( type: esriFieldTypeInteger, alias: DivisionID )
ElementsXS.DBO.%Storm CCTV.Expr1
( type: esriFieldTypeInteger, alias: Expr1 )
ElementsXS.DBO.%Storm CCTV.NoteCount
( type: esriFieldTypeInteger, alias: NoteCount )
ElementsXS.DBO.%Storm CCTV.Division
( type: esriFieldTypeString, alias: Division, length: 250 )
ElementsXS.DBO.%Storm CCTV.Problem
( type: esriFieldTypeString, alias: Problem, length: 1073741822 )
ElementsXS.DBO.%Storm CCTV.ResourcesCount
( type: esriFieldTypeInteger, alias: ResourcesCount )
ElementsXS.DBO.%Storm CCTV.ServiceOrderCategory
( type: esriFieldTypeString, alias: ServiceOrderCategory, length: 50 )
ElementsXS.DBO.%Storm CCTV.ServiceOrderDescription
( type: esriFieldTypeString, alias: ServiceOrderDescription, length: 1073741822 )
ElementsXS.DBO.%Storm CCTV.Type
( type: esriFieldTypeString, alias: Type, length: 150 )
ElementsXS.DBO.%Storm CCTV.Resolution
( type: esriFieldTypeString, alias: Resolution, length: 1073741822 )
ElementsXS.DBO.%Storm CCTV.Total_Labor_Hours
( type: esriFieldTypeDouble, alias: Total_Labor_Hours )
ElementsXS.DBO.%Storm CCTV.Total_Labor_Cost
( type: esriFieldTypeDouble, alias: Total_Labor_Cost )
ElementsXS.DBO.%Storm CCTV.Total_Inventory_fCost
( type: esriFieldTypeDouble, alias: Total_Inventory_fCost )
ElementsXS.DBO.%Storm CCTV.InitialResponseByFirstName
( type: esriFieldTypeString, alias: ElementsXS.DBO.%Storm CCTV.InitialResponseByFirstName, length: 50 )
ElementsXS.DBO.%Storm CCTV.InitialResponseByLastName
( type: esriFieldTypeString, alias: ElementsXS.DBO.%Storm CCTV.InitialResponseByLastName, length: 50 )
ElementsXS.DBO.%Storm CCTV.WorkCompletedByFirstName
( type: esriFieldTypeString, alias: ElementsXS.DBO.%Storm CCTV.WorkCompletedByFirstName, length: 50 )
ElementsXS.DBO.%Storm CCTV.WorkCompletedByLastName
( type: esriFieldTypeString, alias: ElementsXS.DBO.%Storm CCTV.WorkCompletedByLastName, length: 50 )
ElementsXS.DBO.%Storm CCTV.AdminCompletedByFirstName
( type: esriFieldTypeString, alias: ElementsXS.DBO.%Storm CCTV.AdminCompletedByFirstName, length: 50 )
ElementsXS.DBO.%Storm CCTV.AdminCompletedByLastName
( type: esriFieldTypeString, alias: ElementsXS.DBO.%Storm CCTV.AdminCompletedByLastName, length: 50 )
Layer:
ElementsXS.DBO.Storm CCTV
(3)
Name:
ElementsXS.DBO.Storm CCTV
Display Field:
CompletedByFirstName
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
Service Item Id:
a2e4f8c5b49a4c218b7035a1ce8620d1
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON
Min Scale:
0
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 267717.32590395113
YMin: 2169881.8196934504
XMax: 293492.91566235747
YMax: 2198791.3223005277
Spatial Reference: 2244 (2965)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[0, 171, 0, 255]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
1
Label:
Description:
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
null
Fields:
TaskID
( type: esriFieldTypeOID, alias: TaskID )
ServiceOrderDetailID
( type: esriFieldTypeInteger, alias: ServiceOrderDetailID )
CreatedByID
( type: esriFieldTypeInteger, alias: CreatedByID )
DateCreated
( type: esriFieldTypeDate, alias: DateCreated, length: 8 )
ScheduledStartDate
( type: esriFieldTypeDate, alias: ScheduledStartDate, length: 8 )
ScheduledEndDate
( type: esriFieldTypeDate, alias: ScheduledEndDate, length: 8 )
ActualStartDate
( type: esriFieldTypeDate, alias: ActualStartDate, length: 8 )
ActualEndDate
( type: esriFieldTypeDate, alias: ActualEndDate, length: 8 )
Priority
( type: esriFieldTypeString, alias: Priority, length: 50 )
Status
( type: esriFieldTypeString, alias: Status, length: 50 )
TaskType
( type: esriFieldTypeString, alias: TaskType, length: 50 )
Completed
( type: esriFieldTypeSmallInteger, alias: Completed )
IsWorkItemType
( type: esriFieldTypeSmallInteger, alias: IsWorkItemType )
ServiceOrderNumber
( type: esriFieldTypeString, alias: ServiceOrderNumber, length: 50 )
ServiceOrderID
( type: esriFieldTypeInteger, alias: ServiceOrderID )
IsLocation
( type: esriFieldTypeSmallInteger, alias: IsLocation )
LocationID
( type: esriFieldTypeString, alias: LocationID, length: 250 )
LocationNo
( type: esriFieldTypeString, alias: LocationNo, length: 50 )
Location
( type: esriFieldTypeString, alias: Location, length: 250 )
IsCustomer
( type: esriFieldTypeSmallInteger, alias: IsCustomer )
CustomerID
( type: esriFieldTypeString, alias: CustomerID, length: 250 )
CustomerNo
( type: esriFieldTypeString, alias: CustomerNo, length: 50 )
Customer
( type: esriFieldTypeString, alias: Customer, length: 250 )
IsService
( type: esriFieldTypeSmallInteger, alias: IsService )
ServiceID
( type: esriFieldTypeString, alias: ServiceID, length: 250 )
Service
( type: esriFieldTypeString, alias: Service, length: 50 )
IsMeter
( type: esriFieldTypeSmallInteger, alias: IsMeter )
MeterID
( type: esriFieldTypeString, alias: MeterID, length: 250 )
MeterNo
( type: esriFieldTypeString, alias: MeterNo, length: 50 )
IsGISAsset
( type: esriFieldTypeSmallInteger, alias: IsGISAsset )
GISFileID
( type: esriFieldTypeInteger, alias: GISFileID )
GISLayer
( type: esriFieldTypeString, alias: GISLayer, length: 50 )
IsAsset
( type: esriFieldTypeSmallInteger, alias: IsAsset )
SchemaDocGuid
( type: esriFieldTypeGUID, alias: SchemaDocGuid, length: 38 )
UtilityBillingServiceCodeTypeID
( type: esriFieldTypeInteger, alias: UtilityBillingServiceCodeTypeID )
IsUtilityBillingServiceOrder
( type: esriFieldTypeSmallInteger, alias: IsUtilityBillingServiceOrder )
FeePosted
( type: esriFieldTypeSmallInteger, alias: FeePosted )
PriorityColor
( type: esriFieldTypeString, alias: PriorityColor, length: 50 )
FeeAmount
( type: esriFieldTypeDouble, alias: FeeAmount )
BillToAccount
( type: esriFieldTypeString, alias: BillToAccount, length: 250 )
CompletedByFirstName
( type: esriFieldTypeString, alias: CompletedByFirstName, length: 50 )
CompletedByLast
( type: esriFieldTypeString, alias: CompletedByLast, length: 50 )
LastModifiedByID
( type: esriFieldTypeInteger, alias: LastModifiedByID )
LastModified
( type: esriFieldTypeDate, alias: LastModified, length: 8 )
PriorityID
( type: esriFieldTypeInteger, alias: PriorityID )
StatusID
( type: esriFieldTypeInteger, alias: StatusID )
TaskTypeID
( type: esriFieldTypeInteger, alias: TaskTypeID )
ServiceOrderDetailTypeID
( type: esriFieldTypeInteger, alias: ServiceOrderDetailTypeID )
LOC_Address
( type: esriFieldTypeString, alias: LOC_Address, length: 500 )
LOC_City
( type: esriFieldTypeString, alias: LOC_City, length: 500 )
CUST_Name
( type: esriFieldTypeString, alias: CUST_Name, length: 500 )
GIS_AssetTag
( type: esriFieldTypeString, alias: GIS_AssetTag, length: 500 )
AssetNo
( type: esriFieldTypeInteger, alias: AssetNo )
ASSET_AssetTag
( type: esriFieldTypeString, alias: ASSET_AssetTag, length: 500 )
GeoShape
( type: esriFieldTypeGeometry, alias: GeoShape )
AssetID
( type: esriFieldTypeString, alias: AssetID, length: 50 )
AssetLocation
( type: esriFieldTypeString, alias: AssetLocation, length: 1073741822 )
AssetStatus
( type: esriFieldTypeString, alias: AssetStatus, length: 50 )
AssetType
( type: esriFieldTypeString, alias: AssetType, length: 50 )
TaskAssignmentCrews
( type: esriFieldTypeString, alias: TaskAssignmentCrews, length: 1073741822 )
TaskAssignmentUsers
( type: esriFieldTypeString, alias: TaskAssignmentUsers, length: 1073741822 )
TaskAssignmentContacts
( type: esriFieldTypeString, alias: TaskAssignmentContacts, length: 1073741822 )
GISAssetNo
( type: esriFieldTypeString, alias: GISAssetNo, length: 250 )
DivisionID
( type: esriFieldTypeInteger, alias: DivisionID )
Expr1
( type: esriFieldTypeInteger, alias: Expr1 )
NoteCount
( type: esriFieldTypeInteger, alias: NoteCount )
Division
( type: esriFieldTypeString, alias: Division, length: 250 )
Problem
( type: esriFieldTypeString, alias: Problem, length: 1073741822 )
ResourcesCount
( type: esriFieldTypeInteger, alias: ResourcesCount )
ServiceOrderCategory
( type: esriFieldTypeString, alias: ServiceOrderCategory, length: 50 )
ServiceOrderDescription
( type: esriFieldTypeString, alias: ServiceOrderDescription, length: 1073741822 )
Type
( type: esriFieldTypeString, alias: Type, length: 150 )
Resolution
( type: esriFieldTypeString, alias: Resolution, length: 1073741822 )
Total_Labor_Hours
( type: esriFieldTypeDouble, alias: Total_Labor_Hours )
Total_Labor_Cost
( type: esriFieldTypeDouble, alias: Total_Labor_Cost )
Total_Inventory_fCost
( type: esriFieldTypeDouble, alias: Total_Inventory_fCost )
InitialResponseByFirstName
( type: esriFieldTypeString, alias: InitialResponseByFirstName, length: 50 )
InitialResponseByLastName
( type: esriFieldTypeString, alias: InitialResponseByLastName, length: 50 )
WorkCompletedByFirstName
( type: esriFieldTypeString, alias: WorkCompletedByFirstName, length: 50 )
WorkCompletedByLastName
( type: esriFieldTypeString, alias: WorkCompletedByLastName, length: 50 )
AdminCompletedByFirstName
( type: esriFieldTypeString, alias: AdminCompletedByFirstName, length: 50 )
AdminCompletedByLastName
( type: esriFieldTypeString, alias: AdminCompletedByLastName, length: 50 )
Layer:
Storm_Master.DBO.QueryITPipesStorm_Master_NOT
(4)
Name:
Storm_Master.DBO.QueryITPipesStorm_Master_NOT
Display Field:
ML_Name
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
Service Item Id:
a2e4f8c5b49a4c218b7035a1ce8620d1
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON
Min Scale:
0
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 273965.4515687451
YMin: 2169765.589910738
XMax: 288378.5356034115
YMax: 2198330.499972403
Spatial Reference: 2244 (2965)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSLSSolid
Color:
[255, 0, 0, 255]
Width:
8
Label:
Description:
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
null
Fields:
ML_ID
( type: esriFieldTypeOID, alias: ML_ID )
US_MH
( type: esriFieldTypeString, alias: US_MH, length: 50 )
DS_MH
( type: esriFieldTypeString, alias: DS_MH, length: 50 )
ML_Name
( type: esriFieldTypeString, alias: ML_Name, length: 51 )
Inspection_Direction
( type: esriFieldTypeString, alias: Inspection_Direction, length: 50 )
Inspected_Length
( type: esriFieldTypeDouble, alias: Inspected_Length )
Operator
( type: esriFieldTypeString, alias: Operator, length: 50 )
Media_Path_ID
( type: esriFieldTypeInteger, alias: Media_Path_ID )
File_Name
( type: esriFieldTypeString, alias: File_Name, length: 255 )
Media_ID
( type: esriFieldTypeInteger, alias: Media_ID )
File_Path
( type: esriFieldTypeString, alias: File_Path, length: 255 )
FACILITYID
( type: esriFieldTypeString, alias: FACILITYID, length: 30 )
SHAPE
( type: esriFieldTypeGeometry, alias: SHAPE )
SHAPE_STLength_1
( type: esriFieldTypeDouble, alias: SHAPE_STLength_1 )
SHAPE_STLength__
( type: esriFieldTypeDouble, alias: SHAPE_STLength__ )
Inspection_Date
( type: esriFieldTypeDate, alias: Inspection_Date, length: 8 )
Pipe_Height
( type: esriFieldTypeDouble, alias: Pipe_Height )
Relationships:
CollectionSystem.DBO.swMain (1) --
Related To
:
CollectionSystem.DBO.swMain
(0)
Tables:
Table:
Sum_Output
(5)
Name:
Sum_Output
Display Field:
Pipe_Heigh
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
a2e4f8c5b49a4c218b7035a1ce8620d1
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON
Supports Advanced Queries:
false
Supports Statistics:
false
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: false
Supports OrderBy: false
Supports Distinct: false
Supports Pagination: false
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: false
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
OID
( type: esriFieldTypeOID, alias: OID )
Pipe_Heigh
( type: esriFieldTypeDouble, alias: Pipe_Height )
Cnt_Pipe_H
( type: esriFieldTypeInteger, alias: Count_Pipe_Height )
Sum_SHAPE_
( type: esriFieldTypeDouble, alias: Sum_SHAPE_STLength__ )