Name: Control Valve Retired

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 5000

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: 419594.43065143004
YMin: 2080713.4041703641
XMax: 508600.21162901074
YMax: 2187541.035002865
Spatial Reference: 2244  (2965)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, length: 20 )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• HOUSE_NUMBER ( type: esriFieldTypeInteger, alias: House Number )
• ONSTREETMEAS ( type: esriFieldTypeString, alias: On Street Measurement, length: 20 )
• ONSTREET ( type: esriFieldTypeString, alias: On Street, length: 100 )
• CROSSSTREETMEAS ( type: esriFieldTypeString, alias: Cross Street Measurement, length: 20 )
• CROSSSTREET ( type: esriFieldTypeString, alias: Cross Street, length: 100 )
• ON_DIST_FT ( type: esriFieldTypeInteger, alias: ON_DIST_FT )
• ON_DIR ( type: esriFieldTypeString, alias: ON_DIR, length: 3 )
• ON_PL ( type: esriFieldTypeString, alias: ON_PL, length: 3 )
• CROSS_DIST_FT ( type: esriFieldTypeInteger, alias: CROSS_DIST_FT )
• CROSS_DIR ( type: esriFieldTypeString, alias: CROSS_DIR, length: 3 )
• CROSS_PL ( type: esriFieldTypeString, alias: CROSS_PL, length: 3 )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation )
• VALVESIZE ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [1.5: 1 1/2"] , [1: 1"] , [0.5: 1/2"] , ...19 more... )
• POINTTYPE ( type: esriFieldTypeString, alias: Valve Type, length: 10 , Coded Values: [AV: Air Release Valve] , [BO: Blow Off] , [BP: Backflow Preventer] , ...4 more... )
• LASTINSPECTED ( type: esriFieldTypeDate, alias: Last Inspected Date, length: 8 )
• STATUS ( type: esriFieldTypeString, alias: Status of the Asset, length: 10 , Coded Values: [AB: Abandoned] , [AT: Active] , [VA: Vacated] , ...2 more... )
• OWNEDBY ( type: esriFieldTypeString, alias: Owned By, length: 10 , Coded Values: [ACRWSD: Allen County Regional Water and Sewer District] , [AQIN: AquaIndiana] , [ARMY: Army Corps of Engineers] , ...9 more... )
• MAINTBY ( type: esriFieldTypeString, alias: Managed By, length: 5 , Coded Values: [ACRWS: Allen County Regional Water and Sewer District] , [AQIN: AquaIndiana] , [ARMY: Army Corps of Engineers] , ...9 more... )
• MANUFACTURER ( type: esriFieldTypeInteger, alias: Manufacturer , Coded Values: [1000: A.P. Smith] , [1003: American Darling] , [1005: American Flow Control] , ...20 more... )
• SEGID ( type: esriFieldTypeInteger, alias: Segment ID )
• MAINID ( type: esriFieldTypeString, alias: Main ID, length: 20 )
• REMARKS ( type: esriFieldTypeString, alias: Remarks, length: 300 )
• X ( type: esriFieldTypeDouble, alias: X coordinate )
• Y ( type: esriFieldTypeDouble, alias: Y coordinate )
• BYPASSVALVE ( type: esriFieldTypeString, alias: Bypass Valve, length: 1 , Coded Values: [N: No] , [Y: Yes] )
• CLOCKTOCLOSE ( type: esriFieldTypeString, alias: Clockwise To Close, length: 1 , Coded Values: [N: No] , [Y: Yes] )
• OPENSTO ( type: esriFieldTypeString, alias: Opens To, length: 1 , Coded Values: [L: Left] , [R: Right] , [U: Unknown] )
• VALVEPURPOSE ( type: esriFieldTypeString, alias: Valve Purpose, length: 5 , Coded Values: [FSA: Fire Service Valve] , [ML: Mainline Valve] , [SERV: Service Valve] )
• OPER ( type: esriFieldTypeString, alias: Operation Type, length: 10 , Coded Values: [GN: Geared Nut] , [NU: Nut] , [TH: T-Head] , ...2 more... )
• ENDS ( type: esriFieldTypeString, alias: Valve Ends, length: 10 , Coded Values: [FL: Flange] , [HU: Hub] , [MJ: Mechanical Joint] , ...5 more... )
• SETT ( type: esriFieldTypeString, alias: Valve Setting, length: 10 , Coded Values: [PI: Pit] , [UNK: Unknown] , [VB: Valve Box] )
• WO ( type: esriFieldTypeString, alias: Work Order Number, length: 10 )
• CONT ( type: esriFieldTypeString, alias: Contract Number, length: 10 )
• LTURNS ( type: esriFieldTypeDouble, alias: Last Inspected Number of Turns )
• VLEFT ( type: esriFieldTypeString, alias: Last Inspected Valve Left, length: 1 , Coded Values: [C: Closed] , [O: Open] )
• CRSCODE1 ( type: esriFieldTypeInteger, alias: Street Code ID of Cross Street 1 )
• CRSCODE2 ( type: esriFieldTypeInteger, alias: Street Code ID of Cross Street 2 )
• FUNCSCODE ( type: esriFieldTypeInteger, alias: Street Code ID of nearest Cross Street )
• FUNCDIR ( type: esriFieldTypeString, alias: Valve Function Direction, length: 3 , Coded Values: [E: East] , [N: North] , [S: South] , ...1 more... )
• LDATE2 ( type: esriFieldTypeDate, alias: Previous Inspected Date 2, length: 8 )
• LTURNS2 ( type: esriFieldTypeDouble, alias: Previous Inspected # of turns 2 )
• VLEFT2 ( type: esriFieldTypeString, alias: Previous Inspected Valve Left 2, length: 1 , Coded Values: [C: Closed] , [O: Open] )
• LDATE3 ( type: esriFieldTypeDate, alias: Previous Inspected Date 3, length: 8 )
• LTURNS3 ( type: esriFieldTypeDouble, alias: Previous Inspected # of turns 3 )
• VLEFT3 ( type: esriFieldTypeString, alias: Previous Inspected Valve Left 3, length: 1 , Coded Values: [C: Closed] , [O: Open] )
• WORK_ORDER_NUM ( type: esriFieldTypeString, alias: Work Order Number, length: 25 )
• CONTRACT_NUM ( type: esriFieldTypeString, alias: Contract Number, length: 30 )
• DRAWINGNUM ( type: esriFieldTypeString, alias: Drawing Number, length: 30 )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• UNITID ( type: esriFieldTypeString, alias: UNITID, length: 20 )
• COMPTYPE ( type: esriFieldTypeSmallInteger, alias: COMPTYPE )
• COMPKEY ( type: esriFieldTypeInteger, alias: COMPKEY )
• MainCOMPKEY ( type: esriFieldTypeInteger, alias: MainCOMPKEY )
• AddressKey ( type: esriFieldTypeInteger, alias: AddressKey )
• SegmentCOMPKEY ( type: esriFieldTypeInteger, alias: SegmentCOMPKEY )
• IntersectionCOMPKEY ( type: esriFieldTypeInteger, alias: IntersectionCOMPKEY )
• 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 )
• UNITTYPE ( type: esriFieldTypeString, alias: UNITTYPE, length: 10 , Coded Values: [AV: Air Release Valve] , [BO: Blow Off] , [BP: Backflow Preventer] , ...4 more... )
• Visibility ( type: esriFieldTypeString, alias: Visibility, length: 255 , Coded Values: [All: All] , [Internal: Internal] )
• ESRIGNSS_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, length: 255 )
• ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy m )
• ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy m )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude )
• ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Number of Satellites , Range: [0, 99] )
• ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• Data_Source ( type: esriFieldTypeString, alias: Data Source, length: 255 , Coded Values: [Aerial: Visually From an Aerial or Map] , [GPS: GPS] , [Survey: High-Accuracy Survey with Benchmark] , ...1 more... )
• Date_Collected ( type: esriFieldTypeDate, alias: Date Collected, length: 8 )
• Collected_By ( type: esriFieldTypeString, alias: Collected By, length: 255 , Coded Values: [CH2M: CH2MHILL] , [CSS: Construction Support Services] , [CUE: City Utilities Engineering] , ...13 more... )
• QA_QC_By ( type: esriFieldTypeString, alias: QA QC By, length: 255 )
• QA_QC_Date ( type: esriFieldTypeDate, alias: QA QC Date, length: 8 )
• NUMBEROFTURNS ( type: esriFieldTypeString, alias: NUMBER OF TURNS, length: 4 )
• ADDRESS ( type: esriFieldTypeString, alias: Address, length: 150 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Valve_Operation_Status ( type: esriFieldTypeString, alias: Valve Operation Status, length: 10 , Coded Values: [OP: Open] , [CL: Closed] , [BU: Buried] )
• Valve_Operation_State ( type: esriFieldTypeString, alias: Valve Operation State, length: 10 , Coded Values: [OP: Operable] , [TC: Temporary Closed] , [BR: Broken] , ...3 more... )
• WATERTYPE ( type: esriFieldTypeString, alias: Water Type, length: 10 , Coded Values: [Potable: Potable Water] , [Raw: Raw Water] , [Reclaimed: Reclaimed Water] , ...5 more... )

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata