View In:   ArcGIS Online map viewer

Name: WaterValve

Display Field: DirectiontoTurn

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

XMin: -9016674.238497797
YMin: 5021653.571464966
XMax: -8994396.15286897
YMax: 5032204.288140025
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [230, 0, 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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
• DirectiontoTurn ( type: esriFieldTypeString , alias: DirectiontoTurn , editable: true , nullable: true , length: 50 )
• Manufacturer ( type: esriFieldTypeString , alias: Manufacturer , editable: true , nullable: true , length: 50 )
• Model ( type: esriFieldTypeString , alias: Model , editable: true , nullable: true , length: 50 )
• ValveType ( type: esriFieldTypeString , alias: ValveType , editable: true , nullable: true , length: 50 )
• WaterType ( type: esriFieldTypeString , alias: WaterType , editable: true , nullable: true , length: 50 )
• ValveSize ( type: esriFieldTypeDouble , alias: ValveSize , editable: true , nullable: true )
• ValveSize_unit ( type: esriFieldTypeString , alias: ValveSize_unit , editable: true , nullable: true , length: 10 )
• SerialNumber ( type: esriFieldTypeString , alias: SerialNumber , editable: true , nullable: true , length: 50 )
• Retired ( type: esriFieldTypeDate , alias: Retired , editable: true , nullable: true , length: 8 )
• Replaced ( type: esriFieldTypeDate , alias: Replaced , editable: true , nullable: true , length: 8 )
• Installed ( type: esriFieldTypeDate , alias: Installed , editable: true , nullable: true , length: 8 )
• LocatorCity ( type: esriFieldTypeString , alias: LocatorCity , editable: true , nullable: true , length: 50 )
• LocatorStreet ( type: esriFieldTypeString , alias: LocatorStreet , editable: true , nullable: true , length: 50 )
• LocatorAddressNumber ( type: esriFieldTypeString , alias: LocatorAddressNumber , editable: true , nullable: true , length: 15 )
• AddressNumber ( type: esriFieldTypeDouble , alias: AddressNumber , editable: true , nullable: true )
• CartegraphID ( type: esriFieldTypeString , alias: CartegraphID , editable: true , nullable: true , length: 50 )
• TotalCost ( type: esriFieldTypeDouble , alias: TotalCost , editable: true , nullable: true )
• ConditionGroup ( type: esriFieldTypeString , alias: ConditionGroup , editable: true , nullable: true , length: 150 )
• Jurisdiction ( type: esriFieldTypeString , alias: Jurisdiction , editable: true , nullable: true , length: 35 )
• Notes ( type: esriFieldTypeString , alias: Notes , editable: true , nullable: true , length: 500 )
• EstimatedOCI ( type: esriFieldTypeDouble , alias: EstimatedOCI , editable: true , nullable: true )
• PredictionGroup ( type: esriFieldTypeString , alias: PredictionGroup , editable: true , nullable: true , length: 50 )
• LocationDescription ( type: esriFieldTypeString , alias: LocationDescription , editable: true , nullable: true , length: 500 )
• EstimatedOCR ( type: esriFieldTypeString , alias: EstimatedOCR , editable: true , nullable: true , length: 50 )
• EstimatedCCR ( type: esriFieldTypeString , alias: EstimatedCCR , editable: true , nullable: true , length: 50 )
• CriticalityFactor ( type: esriFieldTypeDouble , alias: CriticalityFactor , editable: true , nullable: true )
• CurrentInspectionID ( type: esriFieldTypeString , alias: CurrentInspectionID , editable: true , nullable: true , length: 50 )
• EstimatedCCI ( type: esriFieldTypeDouble , alias: EstimatedCCI , editable: true , nullable: true )
• ActBefore ( type: esriFieldTypeDate , alias: ActBefore , editable: true , nullable: true , length: 8 )
• County ( type: esriFieldTypeString , alias: County , editable: true , nullable: true , length: 32 )
• Street ( type: esriFieldTypeString , alias: Street , editable: true , nullable: true , length: 50 )
• StateValue ( type: esriFieldTypeString , alias: StateValue , editable: true , nullable: true , length: 50 )
• City ( type: esriFieldTypeString , alias: City , editable: true , nullable: true , length: 50 )
• StorageTank ( type: esriFieldTypeString , alias: StorageTank , editable: true , nullable: true , length: 50 )
• Main ( type: esriFieldTypeString , alias: Main , editable: true , nullable: true , length: 50 )
• CurrentInspectionDate ( type: esriFieldTypeDate , alias: CurrentInspectionDate , editable: true , nullable: true , length: 8 )
• CurrentInspectionOCI ( type: esriFieldTypeDouble , alias: CurrentInspectionOCI , editable: true , nullable: true )
• CurrentInspectionOCR ( type: esriFieldTypeString , alias: CurrentInspectionOCR , editable: true , nullable: true , length: 50 )
• CurrentInspectionNotes ( type: esriFieldTypeString , alias: CurrentInspectionNotes , editable: true , nullable: true , length: 500 )
• cgRiskScore ( type: esriFieldTypeDouble , alias: cgRiskScore , editable: true , nullable: true )
• cgRiskRating ( type: esriFieldTypeString , alias: cgRiskRating , editable: true , nullable: true , length: 50 )
• cgConsequenceOfFailureScore ( type: esriFieldTypeDouble , alias: cgConsequenceOfFailureScore , editable: true , nullable: true )
• cgProbabilityOfFailureScore ( type: esriFieldTypeDouble , alias: cgProbabilityOfFailureScore , editable: true , nullable: true )
• cgRedundancyValue ( type: esriFieldTypeDouble , alias: cgRedundancyValue , editable: true , nullable: true )
• cgRedundancyValue_unit ( type: esriFieldTypeString , alias: cgRedundancyValue_unit , editable: true , nullable: true , length: 10 )
• VALVE_ID ( type: esriFieldTypeString , alias: VALVE_ID , editable: true , nullable: true , length: 20 )
• FTR_CODE ( type: esriFieldTypeString , alias: FTR_CODE , editable: true , nullable: true , length: 20 )
• X_COORD ( type: esriFieldTypeDouble , alias: X_COORD , editable: true , nullable: true )
• Y_COORD ( type: esriFieldTypeDouble , alias: Y_COORD , editable: true , nullable: true )
• WATER_DISTRICT ( type: esriFieldTypeString , alias: WATER_DISTRICT , editable: true , nullable: true , length: 30 )
• created_user ( type: esriFieldTypeString , alias: created_user , editable: false , nullable: true , length: 255 )
• created_date ( type: esriFieldTypeDate , alias: created_date , editable: false , nullable: true , length: 8 )
• last_edited_user ( type: esriFieldTypeString , alias: last_edited_user , editable: false , nullable: true , length: 255 )
• last_edited_date ( type: esriFieldTypeDate , alias: last_edited_date , editable: false , nullable: true , length: 8 )

Templates:

• Name: sde.DBO.test_WaterValve
  Description:
  Prototype:
  WATER_DISTRICT: null
  DirectiontoTurn: null
  Manufacturer: null
  Model: null
  ValveType: null
  WaterType: null
  ValveSize: null
  ValveSize_unit: null
  SerialNumber: null
  Retired: null
  Replaced: null
  Installed: null
  LocatorCity: null
  LocatorStreet: null
  LocatorAddressNumber: null
  AddressNumber: null
  CartegraphID: null
  TotalCost: null
  ConditionGroup: null
  Jurisdiction: null
  Notes: null
  EstimatedOCI: null
  PredictionGroup: null
  LocationDescription: null
  EstimatedOCR: null
  EstimatedCCR: null
  CriticalityFactor: null
  CurrentInspectionID: null
  EstimatedCCI: null
  ActBefore: null
  County: null
  Street: null
  StateValue: null
  City: null
  StorageTank: null
  Main: null
  CurrentInspectionDate: null
  CurrentInspectionOCI: null
  CurrentInspectionOCR: null
  CurrentInspectionNotes: null
  cgRiskScore: null
  cgRiskRating: null
  cgConsequenceOfFailureScore: null
  cgProbabilityOfFailureScore: null
  cgRedundancyValue: null
  cgRedundancyValue_unit: null
  VALVE_ID: null
  FTR_CODE: null
  X_COORD: null
  Y_COORD: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Update,Uploads,Editing

Sync Can Return Changes: false

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

Supported Operations:   Query   Apply Edits   Update Features   Validate SQL   Generate Renderer   Return Updates