Name: swMain_PipeRepairs

Display Field: CollectionSystem.DBO.swMain.FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 6c1a58059e6c49bc8ac11121c4af41c2

Copyright Text:

Default Visibility: false

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: -85.91105686441293
YMin: 41.20489276749691
XMax: -85.74040250181265
YMax: 41.28496553228507
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [197, 0, 255, 255]
Width: 6
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: SHAPE.STLength() )
• CollectionSystem.DBO.swMain.SHAPE_STLength_1 ( type: esriFieldTypeDouble, alias: SHAPE.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: CollectionSystem.DBO.swMain.Street, length: 250 )
• CollectionSystem.DBO.swMain.MATERIAL ( type: esriFieldTypeString, alias: MATERIAL_1, length: 255 )
• CollectionSystem.DBO.swMain.Field ( type: esriFieldTypeInteger, alias: CollectionSystem.DBO.swMain.Field )
• CollectionSystem.DBO.swMain.Feet ( type: esriFieldTypeDouble, alias: CollectionSystem.DBO.swMain.Feet )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• ElementsXS.DBO.%Request Lining Mains_3.TaskID ( type: esriFieldTypeInteger, alias: TaskID )
• ElementsXS.DBO.%Request Lining Mains_3.ServiceOrderDetailID ( type: esriFieldTypeInteger, alias: ServiceOrderDetailID )
• ElementsXS.DBO.%Request Lining Mains_3.CreatedByID ( type: esriFieldTypeInteger, alias: CreatedByID )
• ElementsXS.DBO.%Request Lining Mains_3.DateCreated ( type: esriFieldTypeDate, alias: DateCreated, length: 8 )
• ElementsXS.DBO.%Request Lining Mains_3.ScheduledStartDate ( type: esriFieldTypeDate, alias: ScheduledStartDate, length: 8 )
• ElementsXS.DBO.%Request Lining Mains_3.ScheduledEndDate ( type: esriFieldTypeDate, alias: ScheduledEndDate, length: 8 )
• ElementsXS.DBO.%Request Lining Mains_3.ActualStartDate ( type: esriFieldTypeDate, alias: ActualStartDate, length: 8 )
• ElementsXS.DBO.%Request Lining Mains_3.ActualEndDate ( type: esriFieldTypeDate, alias: ActualEndDate, length: 8 )
• ElementsXS.DBO.%Request Lining Mains_3.Priority ( type: esriFieldTypeString, alias: Priority, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.Status ( type: esriFieldTypeString, alias: Status, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.TaskType ( type: esriFieldTypeString, alias: TaskType, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.Completed ( type: esriFieldTypeSmallInteger, alias: Completed )
• ElementsXS.DBO.%Request Lining Mains_3.IsWorkItemType ( type: esriFieldTypeSmallInteger, alias: IsWorkItemType )
• ElementsXS.DBO.%Request Lining Mains_3.ServiceOrderNumber ( type: esriFieldTypeString, alias: ServiceOrderNumber, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.ServiceOrderID ( type: esriFieldTypeInteger, alias: ServiceOrderID )
• ElementsXS.DBO.%Request Lining Mains_3.IsLocation ( type: esriFieldTypeSmallInteger, alias: IsLocation )
• ElementsXS.DBO.%Request Lining Mains_3.LocationID ( type: esriFieldTypeString, alias: LocationID, length: 250 )
• ElementsXS.DBO.%Request Lining Mains_3.LocationNo ( type: esriFieldTypeString, alias: LocationNo, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.Location ( type: esriFieldTypeString, alias: Location, length: 250 )
• ElementsXS.DBO.%Request Lining Mains_3.IsCustomer ( type: esriFieldTypeSmallInteger, alias: IsCustomer )
• ElementsXS.DBO.%Request Lining Mains_3.CustomerID ( type: esriFieldTypeString, alias: CustomerID, length: 250 )
• ElementsXS.DBO.%Request Lining Mains_3.CustomerNo ( type: esriFieldTypeString, alias: CustomerNo, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.Customer ( type: esriFieldTypeString, alias: Customer, length: 250 )
• ElementsXS.DBO.%Request Lining Mains_3.IsService ( type: esriFieldTypeSmallInteger, alias: IsService )
• ElementsXS.DBO.%Request Lining Mains_3.ServiceID ( type: esriFieldTypeString, alias: ServiceID, length: 250 )
• ElementsXS.DBO.%Request Lining Mains_3.Service ( type: esriFieldTypeString, alias: Service, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.IsMeter ( type: esriFieldTypeSmallInteger, alias: IsMeter )
• ElementsXS.DBO.%Request Lining Mains_3.MeterID ( type: esriFieldTypeString, alias: MeterID, length: 250 )
• ElementsXS.DBO.%Request Lining Mains_3.MeterNo ( type: esriFieldTypeString, alias: MeterNo, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.IsGISAsset ( type: esriFieldTypeSmallInteger, alias: IsGISAsset )
• ElementsXS.DBO.%Request Lining Mains_3.GISFileID ( type: esriFieldTypeInteger, alias: GISFileID )
• ElementsXS.DBO.%Request Lining Mains_3.GISLayer ( type: esriFieldTypeString, alias: GISLayer, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.IsAsset ( type: esriFieldTypeSmallInteger, alias: IsAsset )
• ElementsXS.DBO.%Request Lining Mains_3.SchemaDocGuid ( type: esriFieldTypeGUID, alias: SchemaDocGuid, length: 38 )
• ElementsXS.DBO.%Request Lining Mains_3.UtilityBillingServiceCodeTypeID ( type: esriFieldTypeInteger, alias: UtilityBillingServiceCodeTypeID )
• ElementsXS.DBO.%Request Lining Mains_3.IsUtilityBillingServiceOrder ( type: esriFieldTypeSmallInteger, alias: IsUtilityBillingServiceOrder )
• ElementsXS.DBO.%Request Lining Mains_3.FeePosted ( type: esriFieldTypeSmallInteger, alias: FeePosted )
• ElementsXS.DBO.%Request Lining Mains_3.PriorityColor ( type: esriFieldTypeString, alias: PriorityColor, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.FeeAmount ( type: esriFieldTypeDouble, alias: FeeAmount )
• ElementsXS.DBO.%Request Lining Mains_3.BillToAccount ( type: esriFieldTypeString, alias: BillToAccount, length: 250 )
• ElementsXS.DBO.%Request Lining Mains_3.CompletedByFirstName ( type: esriFieldTypeString, alias: CompletedByFirstName, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.CompletedByLast ( type: esriFieldTypeString, alias: CompletedByLast, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.LastModifiedByID ( type: esriFieldTypeInteger, alias: LastModifiedByID )
• ElementsXS.DBO.%Request Lining Mains_3.LastModified ( type: esriFieldTypeDate, alias: LastModified, length: 8 )
• ElementsXS.DBO.%Request Lining Mains_3.PriorityID ( type: esriFieldTypeInteger, alias: PriorityID )
• ElementsXS.DBO.%Request Lining Mains_3.StatusID ( type: esriFieldTypeInteger, alias: StatusID )
• ElementsXS.DBO.%Request Lining Mains_3.TaskTypeID ( type: esriFieldTypeInteger, alias: TaskTypeID )
• ElementsXS.DBO.%Request Lining Mains_3.ServiceOrderDetailTypeID ( type: esriFieldTypeInteger, alias: ServiceOrderDetailTypeID )
• ElementsXS.DBO.%Request Lining Mains_3.LOC_Address ( type: esriFieldTypeString, alias: LOC_Address, length: 500 )
• ElementsXS.DBO.%Request Lining Mains_3.LOC_City ( type: esriFieldTypeString, alias: LOC_City, length: 500 )
• ElementsXS.DBO.%Request Lining Mains_3.CUST_Name ( type: esriFieldTypeString, alias: CUST_Name, length: 500 )
• ElementsXS.DBO.%Request Lining Mains_3.GIS_AssetTag ( type: esriFieldTypeString, alias: GIS_AssetTag, length: 500 )
• ElementsXS.DBO.%Request Lining Mains_3.AssetNo ( type: esriFieldTypeInteger, alias: AssetNo )
• ElementsXS.DBO.%Request Lining Mains_3.ASSET_AssetTag ( type: esriFieldTypeString, alias: ASSET_AssetTag, length: 500 )
• ElementsXS.DBO.%Request Lining Mains_3.AssetID ( type: esriFieldTypeString, alias: AssetID, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.AssetLocation ( type: esriFieldTypeString, alias: AssetLocation, length: 1073741822 )
• ElementsXS.DBO.%Request Lining Mains_3.AssetStatus ( type: esriFieldTypeString, alias: AssetStatus, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.AssetType ( type: esriFieldTypeString, alias: AssetType, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.TaskAssignmentCrews ( type: esriFieldTypeString, alias: TaskAssignmentCrews, length: 1073741822 )
• ElementsXS.DBO.%Request Lining Mains_3.TaskAssignmentUsers ( type: esriFieldTypeString, alias: TaskAssignmentUsers, length: 1073741822 )
• ElementsXS.DBO.%Request Lining Mains_3.TaskAssignmentContacts ( type: esriFieldTypeString, alias: TaskAssignmentContacts, length: 1073741822 )
• ElementsXS.DBO.%Request Lining Mains_3.GISAssetNo ( type: esriFieldTypeString, alias: GISAssetNo, length: 250 )
• ElementsXS.DBO.%Request Lining Mains_3.DivisionID ( type: esriFieldTypeInteger, alias: DivisionID )
• ElementsXS.DBO.%Request Lining Mains_3.Expr1 ( type: esriFieldTypeInteger, alias: Expr1 )
• ElementsXS.DBO.%Request Lining Mains_3.NoteCount ( type: esriFieldTypeInteger, alias: NoteCount )
• ElementsXS.DBO.%Request Lining Mains_3.Division ( type: esriFieldTypeString, alias: Division, length: 250 )
• ElementsXS.DBO.%Request Lining Mains_3.Problem ( type: esriFieldTypeString, alias: Problem, length: 1073741822 )
• ElementsXS.DBO.%Request Lining Mains_3.ResourcesCount ( type: esriFieldTypeInteger, alias: ResourcesCount )
• ElementsXS.DBO.%Request Lining Mains_3.ServiceOrderCategory ( type: esriFieldTypeString, alias: ServiceOrderCategory, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.ServiceOrderDescription ( type: esriFieldTypeString, alias: ServiceOrderDescription, length: 1073741822 )
• ElementsXS.DBO.%Request Lining Mains_3.Type ( type: esriFieldTypeString, alias: Type, length: 150 )
• ElementsXS.DBO.%Request Lining Mains_3.Resolution ( type: esriFieldTypeString, alias: Resolution, length: 1073741822 )
• ElementsXS.DBO.%Request Lining Mains_3.Total_Labor_Hours ( type: esriFieldTypeDouble, alias: Total_Labor_Hours )
• ElementsXS.DBO.%Request Lining Mains_3.Total_Labor_Cost ( type: esriFieldTypeDouble, alias: Total_Labor_Cost )
• ElementsXS.DBO.%Request Lining Mains_3.Total_Inventory_fCost ( type: esriFieldTypeDouble, alias: Total_Inventory_fCost )
• ElementsXS.DBO.%Request Lining Mains_3.InitialResponseByFirstName ( type: esriFieldTypeString, alias: ElementsXS.DBO.%Request Lining Mains_3.InitialResponseByFirstName, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.InitialResponseByLastName ( type: esriFieldTypeString, alias: ElementsXS.DBO.%Request Lining Mains_3.InitialResponseByLastName, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.WorkCompletedByFirstName ( type: esriFieldTypeString, alias: ElementsXS.DBO.%Request Lining Mains_3.WorkCompletedByFirstName, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.WorkCompletedByLastName ( type: esriFieldTypeString, alias: ElementsXS.DBO.%Request Lining Mains_3.WorkCompletedByLastName, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.AdminCompletedByFirstName ( type: esriFieldTypeString, alias: ElementsXS.DBO.%Request Lining Mains_3.AdminCompletedByFirstName, length: 50 )
• ElementsXS.DBO.%Request Lining Mains_3.AdminCompletedByLastName ( type: esriFieldTypeString, alias: ElementsXS.DBO.%Request Lining Mains_3.AdminCompletedByLastName, length: 50 )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata