View In:   ArcGIS Online Map Viewer

Name: utilities.SDE.wControlValvesBC_n

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: a18a21b4b2f841b0a5c437f321f67157

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: -9558477.180330109
YMin: 3499398.829226122
XMax: -9513107.958875673
YMax: 3553753.000620564
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: NumberOfTurns
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [13, 128, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label:
UniqueValueInfos:
• Value: 0
  Label: New Subtype
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [110, 150, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
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: NumberOfTurns

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• REGION ( type: esriFieldTypeString, alias: Region, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REGION , Coded Values: [Cedar Grove-Mexico Beach: Cedar Grove-Mexico Beach] , [Bay County Central: Bay County Central] , [North Bay-West Bay: North Bay-West Bay] )
• ROTATION ( type: esriFieldTypeDouble, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION , Coded Values: [Normally Open: Normally Open] , [Normally Closed: Normally Closed] )
• VALVETYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VALVETYPE , Coded Values: [Altitude: Altitude] , [Blowoff: Blowoff] , [Combination: Combination] , ...19 more... )
• SIZE ( type: esriFieldTypeDouble, alias: Size, editable: true, nullable: true, defaultValue: null, modelName: SIZE )
• BypassValve ( type: esriFieldTypeString, alias: Bypass Valve, editable: true, nullable: true, length: 3, defaultValue: null, modelName: BypassValve , Coded Values: [Yes: Yes] , [No: No] )
• HydrantValve ( type: esriFieldTypeString, alias: Hydrant Valve, editable: true, nullable: true, length: 3, defaultValue: null, modelName: HydrantValve , Coded Values: [Yes: Yes] , [No: No] )
• ValvePosition ( type: esriFieldTypeSmallInteger, alias: Valve Position, editable: true, nullable: true, defaultValue: null, modelName: ValvePosition , Coded Values: [Normally Open: Normally Open] , [Normally Closed: Normally Closed] )
• OpenLeft ( type: esriFieldTypeString, alias: Turns Left, editable: true, nullable: true, length: 3, defaultValue: null, modelName: OpenLeft , Coded Values: [Yes: Yes] , [No: No] )
• NumberOfTurns ( type: esriFieldTypeSmallInteger, alias: Turns to Open, editable: true, nullable: true, defaultValue: 0, modelName: NumberOfTurns )
• Operable ( type: esriFieldTypeString, alias: Operable, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Operable , Coded Values: [Yes: Yes] , [No: No] )
• LastInspectionDate ( type: esriFieldTypeDate, alias: LastInspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastInspectionDate )
• ValveCondition ( type: esriFieldTypeString, alias: ValveCondition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ValveCondition , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• Enabled ( type: esriFieldTypeString, alias: Enabled, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Enabled , Coded Values: [Yes: Yes] , [No: No] )
• Active ( type: esriFieldTypeString, alias: Active, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Active , Coded Values: [Yes: Yes] , [No: No] )
• OwnedBy ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: OwnedBy , Coded Values: [-1: Private] , [-2: Other] , [1: Bay County] , ...15 more... )
• ManagedBy ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: null, modelName: ManagedBy , Coded Values: [-1: Private] , [-2: Other] , [1: Bay County] , ...15 more... )
• DRAWINGS ( type: esriFieldTypeString, alias: DRAWINGS, editable: true, nullable: true, length: 250, defaultValue: null, modelName: DRAWINGS )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Notes )
• CL_Rd_DistFeet ( type: esriFieldTypeDouble, alias: Center of Road Distance, editable: true, nullable: true, defaultValue: null, modelName: CL_Rd_DistFeet )
• EP_DistFeet ( type: esriFieldTypeDouble, alias: Edge of Pavement Distance, editable: true, nullable: true, defaultValue: null, modelName: EP_DistFeet )
• AccessType ( type: esriFieldTypeString, alias: Access Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AccessType , Coded Values: [Valve Casing Box: Valve Casing Box] , [Subsurface Vault: Subsurface Vault] , [Surface or Above Ground: Surface or Above Ground] )
• Function_ ( type: esriFieldTypeString, alias: Function, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Function , Coded Values: [Inline: Inline] , [Branch: Branch] , [Bypass: Bypass] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Manufacturer )
• GPSTIMESTAMP ( type: esriFieldTypeDate, alias: GPS Timestamp, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPSTIMESTAMP )
• Elev_CasingBoxCover ( type: esriFieldTypeString, alias: Box Cover Elevation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Elev_CasingBoxCover )
• ValveNutDepth ( type: esriFieldTypeString, alias: Valve Nut Depth, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ValveNutDepth )
• Elev_TopOfNut ( type: esriFieldTypeString, alias: Top of Nut Elevation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Elev_TopOfNut )
• Elev_TopPipe ( type: esriFieldTypeString, alias: Top of Pipe Elevation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Elev_TopPipe )
• LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• NORTHING ( type: esriFieldTypeDouble, alias: Northing, editable: true, nullable: true, defaultValue: null, modelName: NORTHING )
• EASTING ( type: esriFieldTypeDouble, alias: Easting, editable: true, nullable: true, defaultValue: null, modelName: EASTING )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• CarteID ( type: esriFieldTypeString, alias: CarteID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CarteID )
• Precision_Type ( type: esriFieldTypeString, alias: Precision_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Precision_Type , Coded Values: [Survey GPS: Survey GPS] , [Imagery: Imagery] , [Record Survey: Record Survey] )

Types:

ID: 0
Name: New Subtype
Domains:
• REGION:
  Inherited
• ROTATION:
  Inherited
• VALVETYPE:
  Inherited
• BypassValve:
  Inherited
• HydrantValve:
  Inherited
• ValvePosition:
  Inherited
• OpenLeft:
  Inherited
• Operable:
  Inherited
• ValveCondition:
  Inherited
• Enabled:
  Inherited
• Active:
  Inherited
• OwnedBy:
  Inherited
• ManagedBy:
  Inherited
• AccessType:
  Inherited
• Function_:
  Inherited
Templates:
• Name: New Subtype
  Description:
  Prototype:
  CarteID: null
  Precision_Type: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  REGION: null
  ROTATION: null
  VALVETYPE: null
  SIZE: null
  BypassValve: null
  HydrantValve: null
  ValvePosition: null
  OpenLeft: null
  NumberOfTurns: 0
  Operable: null
  LastInspectionDate: null
  ValveCondition: null
  Enabled: null
  Active: null
  OwnedBy: null
  ManagedBy: null
  DRAWINGS: null
  Notes: null
  CL_Rd_DistFeet: null
  EP_DistFeet: null
  AccessType: null
  Function_: null
  Manufacturer: null
  GPSTIMESTAMP: null
  Elev_CasingBoxCover: null
  ValveNutDepth: null
  Elev_TopOfNut: null
  Elev_TopPipe: null
  LATITUDE: null
  LONGITUDE: null
  NORTHING: null
  EASTING: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata