View In:   ArcGIS Online Map Viewer

Name: Water Control Valves

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 868a552870694e61b3de1e06cea6427b

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: 2297176.6861950606
YMin: 1207794.6214772314
XMax: 2325385.884369716
YMax: 1243368.8751317263
Spatial Reference: 102655  (2233)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [138, 5, 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: true
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• NAME ( type: esriFieldTypeString, alias: Asset Class, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NAME )
• GPS_DATE ( type: esriFieldTypeDate, alias: GPS_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_DATE )
• FEATURECLA ( type: esriFieldTypeString, alias: FEATURECLA, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FEATURECLA )
• FEATURE ( type: esriFieldTypeString, alias: FEATURE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FEATURE )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OWNERSHIP )
• OUL_CV ( type: esriFieldTypeSmallInteger, alias: OUL_CV, editable: true, nullable: true, defaultValue: null, modelName: OUL_CV )
• yr_install ( type: esriFieldTypeSmallInteger, alias: yr_install, editable: true, nullable: true, defaultValue: null, modelName: yr_install )
• yr_rehab ( type: esriFieldTypeSmallInteger, alias: yr_rehab, editable: true, nullable: true, defaultValue: null, modelName: yr_rehab )
• cv_inspect ( type: esriFieldTypeString, alias: cv_inspect, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cv_inspect )
• cv_inspect_by ( type: esriFieldTypeString, alias: cv_inspect_by, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cv_inspect_by )
• cv_inspect_yr ( type: esriFieldTypeSmallInteger, alias: cv_inspect_yr, editable: true, nullable: true, defaultValue: null, modelName: cv_inspect_yr )
• DIAMETER ( type: esriFieldTypeString, alias: DIAMETER, editable: true, nullable: true, length: 12, defaultValue: null, modelName: DIAMETER )
• DATUM ( type: esriFieldTypeString, alias: DATUM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DATUM )
• vault_spt ( type: esriFieldTypeInteger, alias: vault_spt, editable: true, nullable: true, defaultValue: null, modelName: vault_spt )
• elev_vault ( type: esriFieldTypeDouble, alias: elev_vault, editable: true, nullable: true, defaultValue: null, modelName: elev_vault )
• elev_vlv ( type: esriFieldTypeDouble, alias: elev_vlv, editable: true, nullable: true, defaultValue: null, modelName: elev_vlv )
• FFE_SSF ( type: esriFieldTypeDouble, alias: FFE_SSF, editable: true, nullable: true, defaultValue: null, modelName: FFE_SSF )
• I_vlv_size ( type: esriFieldTypeSmallInteger, alias: I_vlv_size, editable: true, nullable: true, defaultValue: null, modelName: I_vlv_size )
• PRV_main_size ( type: esriFieldTypeSmallInteger, alias: PRV_main_size, editable: true, nullable: true, defaultValue: null, modelName: PRV_main_size )
• PRV_low_size ( type: esriFieldTypeSmallInteger, alias: PRV_low_size, editable: true, nullable: true, defaultValue: null, modelName: PRV_low_size )
• O_vlv_size ( type: esriFieldTypeSmallInteger, alias: O_vlv_size, editable: true, nullable: true, defaultValue: null, modelName: O_vlv_size )
• AdditionalInfo ( type: esriFieldTypeString, alias: AdditionalInfo, editable: true, nullable: true, length: 250, defaultValue: null, modelName: AdditionalInfo )
• replace_cv ( type: esriFieldTypeSmallInteger, alias: replace_cv, editable: true, nullable: true, defaultValue: null, modelName: replace_cv , Coded Values: [0: No] , [500: Yes] )
• RUL_yr ( type: esriFieldTypeSmallInteger, alias: RUL_yr, editable: true, nullable: true, defaultValue: null, modelName: RUL_yr )
• RUL_value ( type: esriFieldTypeSmallInteger, alias: RUL_value, editable: true, nullable: true, defaultValue: null, modelName: RUL_value )
• cond_valve ( type: esriFieldTypeSmallInteger, alias: cond_valve, editable: true, nullable: true, defaultValue: null, modelName: cond_valve , Coded Values: [40: Minor Defects] , [60: Moderate Defects] , [80: Above Normal Defects] , ...2 more... )
• maint_valve ( type: esriFieldTypeSmallInteger, alias: maint_valve, editable: true, nullable: true, defaultValue: null, modelName: maint_valve , Coded Values: [20: Good - 0% Maintenance Required] , [40: Minor Defects - 5% Maintenance Required] , [60: Moderate Maintenance Required - 10-20% Maintenance Required] , ...2 more... )
• cond_struc ( type: esriFieldTypeSmallInteger, alias: cond_struc, editable: true, nullable: true, defaultValue: null, modelName: cond_struc , Coded Values: [20: Good - 0% Maintenance Required] , [40: Minor Defects - 5% Maintenance Required] , [80: Requires Renewal - 20-40% Maintenance Required] , ...3 more... )
• cond_equip ( type: esriFieldTypeSmallInteger, alias: cond_equip, editable: true, nullable: true, defaultValue: null, modelName: cond_equip , Coded Values: [10: Good - 0% Maintenance Required] , [20: Minor Defects - 5% Maintenance Required] , [40: Requires Renewal - 20-40% Maintenance Required] , ...3 more... )
• cond_elec ( type: esriFieldTypeSmallInteger, alias: cond_elec, editable: true, nullable: true, defaultValue: null, modelName: cond_elec , Coded Values: [10: Good - 0% Maintenance Required] , [20: Minor Defects - 5% Maintenance Required] , [30: Moderate Defects - 10-20% Maintenance Required] , ...3 more... )
• failure_rtg ( type: esriFieldTypeSmallInteger, alias: failure_rtg, editable: true, nullable: true, defaultValue: null, modelName: failure_rtg )
• cmpl_regs ( type: esriFieldTypeSmallInteger, alias: cmpl_regs, editable: true, nullable: true, defaultValue: null, modelName: cmpl_regs , Coded Values: [30: Negligible - 100% compliance with permits] , [60: Low - Violation but no enforcement action] , [90: Moderate - Violation with minor enforcement action] , ...2 more... )
• FEMA_FLOODZONE ( type: esriFieldTypeString, alias: FEMA_FloodZone, editable: true, nullable: true, length: 150, defaultValue: null, modelName: FEMA_FLOODZONE )
• EHS ( type: esriFieldTypeSmallInteger, alias: EHS, editable: true, nullable: true, defaultValue: null, modelName: EHS , Coded Values: [20: Negligible - No injuries or adverse health effects] , [40: Low - within 200 FT Waterway Buffer (No Floodplain)] , [60: Moderate - within 500-year Floodplain] , ...2 more... )
• finan ( type: esriFieldTypeSmallInteger, alias: finan, editable: true, nullable: true, defaultValue: null, modelName: finan , Coded Values: [30: Absorbed within budget line item<$5,000] , [90: Requires some transfer from reserves] , [120: Requires a large transfer from reserves] , ...2 more... )
• publ_conf ( type: esriFieldTypeSmallInteger, alias: publ_conf, editable: true, nullable: true, defaultValue: null, modelName: publ_conf , Coded Values: [20: Insignificant - No event or loss of public confidence] , [40: Minor - Minor event with limited news coverage] , [60: Moderate - Some losses in public confidence] , ...2 more... )
• criticality_rtg ( type: esriFieldTypeSmallInteger, alias: criticality_rtg, editable: true, nullable: true, defaultValue: null, modelName: criticality_rtg )
• risk_rtg ( type: esriFieldTypeSmallInteger, alias: risk_rtg, editable: true, nullable: true, defaultValue: null, modelName: risk_rtg )
• yr_current ( type: esriFieldTypeSmallInteger, alias: yr_current, editable: true, nullable: true, defaultValue: null, modelName: yr_current )
• yr_costs ( type: esriFieldTypeSmallInteger, alias: yr_costs, editable: true, nullable: true, defaultValue: null, modelName: yr_costs )
• RD_CIP_YR ( type: esriFieldTypeSmallInteger, alias: RD_CIP_YR, editable: true, nullable: true, defaultValue: null, modelName: RD_CIP_YR )
• RD_CIP_PRJ_TYP ( type: esriFieldTypeString, alias: RD_CIP_PRJ_TYP, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RD_CIP_PRJ_TYP , Coded Values: [HA-5: HA-5] , [Mill & Overlay: Mill & Overlay] , [OGFC: OGFC] , ...2 more... )
• cv_size_cost ( type: esriFieldTypeDouble, alias: cv_size_cost, editable: true, nullable: true, defaultValue: null, modelName: cv_size_cost , Coded Values: [483.12: 1/2-inch ARV] , [505.62: 3/4-inch ARV] , [662.02: 1-inch ARV] , ...54 more... )
• cv_cost_total ( type: esriFieldTypeDouble, alias: cv_cost_total, editable: true, nullable: true, defaultValue: null, modelName: cv_cost_total )
• cv_cost_install ( type: esriFieldTypeDouble, alias: cv_cost_install, editable: true, nullable: true, defaultValue: null, modelName: cv_cost_install )
• cv_const_const ( type: esriFieldTypeDouble, alias: cv_const_const, editable: true, nullable: true, defaultValue: null, modelName: cv_const_const )
• cv_const_eng ( type: esriFieldTypeDouble, alias: cv_const_eng, editable: true, nullable: true, defaultValue: null, modelName: cv_const_eng )
• cv_const_cont ( type: esriFieldTypeDouble, alias: cv_const_cont, editable: true, nullable: true, defaultValue: null, modelName: cv_const_cont )
• cost_cv ( type: esriFieldTypeDouble, alias: cost_cv, editable: true, nullable: true, defaultValue: null, modelName: cost_cv )
• type_cip_project ( type: esriFieldTypeDouble, alias: type_cip_project, editable: true, nullable: true, defaultValue: null, modelName: type_cip_project , Coded Values: [0.5: Rehabilitate] , [1: Replace] , [0: None] )
• yr_cip_project ( type: esriFieldTypeSmallInteger, alias: yr_cip_project, editable: true, nullable: true, defaultValue: null, modelName: yr_cip_project )
• cost_cip_project ( type: esriFieldTypeDouble, alias: cost_cip_project, editable: true, nullable: true, defaultValue: null, modelName: cost_cip_project )
• descrip_cip_project ( type: esriFieldTypeString, alias: descrip_cip_project, editable: true, nullable: true, length: 250, defaultValue: null, modelName: descrip_cip_project )
• VALVETYPE ( type: esriFieldTypeInteger, alias: VALVETYPE, editable: true, nullable: true, defaultValue: null, modelName: VALVETYPE )
• CLASSIFICATION ( type: esriFieldTypeInteger, alias: CLASSIFICATION, editable: true, nullable: true, defaultValue: null, modelName: CLASSIFICATION )
• PRESSUREZONE ( type: esriFieldTypeInteger, alias: PRESSUREZONE, editable: true, nullable: true, defaultValue: null, modelName: PRESSUREZONE )
• SYSTEM ( type: esriFieldTypeInteger, alias: SYSTEM, editable: true, nullable: true, defaultValue: null, modelName: SYSTEM , Coded Values: [6: Pressure Maintenance] , [5: Irrigation Line] , [4: Fire Suppression] , ...4 more... )
• GEOADDR ( type: esriFieldTypeString, alias: GEOADDR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GEOADDR )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 80, defaultValue: null, modelName: LOCATION )
• ADR_B2 ( type: esriFieldTypeString, alias: ADR_B2, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ADR_B2 )
• ADR_BDG ( type: esriFieldTypeInteger, alias: ADR_BDG, editable: true, nullable: true, defaultValue: null, modelName: ADR_BDG )
• ADR_DIR ( type: esriFieldTypeString, alias: ADR_DIR, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ADR_DIR )
• ADR_PT ( type: esriFieldTypeString, alias: ADR_PT, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ADR_PT )
• ADR_SFX ( type: esriFieldTypeString, alias: ADR_SFX, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ADR_SFX )
• ADR_STR ( type: esriFieldTypeString, alias: ADR_STR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADR_STR )
• ADR_TY ( type: esriFieldTypeString, alias: ADR_TY, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ADR_TY )
• tempaddr ( type: esriFieldTypeString, alias: tempaddr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tempaddr )
• VC_ID ( type: esriFieldTypeInteger, alias: VC_ID, editable: true, nullable: true, defaultValue: null, modelName: VC_ID )
• VC_NUMBER ( type: esriFieldTypeString, alias: Valve Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VC_NUMBER )
• InLucity ( type: esriFieldTypeSmallInteger, alias: In Lucity?, editable: true, nullable: true, defaultValue: 0, modelName: InLucity )
• LastModBy ( type: esriFieldTypeString, alias: Last Modified By, editable: true, nullable: true, length: 40, defaultValue: null, modelName: LastModBy )
• LastModDate ( type: esriFieldTypeDate, alias: Last Modified date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastModDate )
• LastSynDate ( type: esriFieldTypeDate, alias: Last Synchronized Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastSynDate )
• 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 )
• VC_PP_ID ( type: esriFieldTypeInteger, alias: VC_PP_ID, editable: true, nullable: true, defaultValue: null, modelName: VC_PP_ID )
• VC_PP_NUMBER ( type: esriFieldTypeString, alias: VC_PP_NUMBER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VC_PP_NUMBER )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Water Control Valves
  Description:
  Prototype:
  VC_PP_NUMBER: null
  VC_PP_ID: null
  NAME: null
  GPS_DATE: null
  FEATURECLA: null
  FEATURE: null
  OWNERSHIP: null
  OUL_CV: null
  yr_install: null
  yr_rehab: null
  cv_inspect: null
  cv_inspect_by: null
  cv_inspect_yr: null
  DIAMETER: null
  DATUM: null
  vault_spt: null
  elev_vault: null
  elev_vlv: null
  FFE_SSF: null
  I_vlv_size: null
  PRV_main_size: null
  PRV_low_size: null
  O_vlv_size: null
  AdditionalInfo: null
  replace_cv: null
  RUL_yr: null
  RUL_value: null
  cond_valve: null
  maint_valve: null
  cond_struc: null
  cond_equip: null
  cond_elec: null
  failure_rtg: null
  cmpl_regs: null
  FEMA_FLOODZONE: null
  EHS: null
  finan: null
  publ_conf: null
  criticality_rtg: null
  risk_rtg: null
  yr_current: null
  yr_costs: null
  RD_CIP_YR: null
  RD_CIP_PRJ_TYP: null
  cv_size_cost: null
  cv_cost_total: null
  cv_cost_install: null
  cv_const_const: null
  cv_const_eng: null
  cv_const_cont: null
  cost_cv: null
  type_cip_project: null
  yr_cip_project: null
  cost_cip_project: null
  descrip_cip_project: null
  VALVETYPE: null
  CLASSIFICATION: null
  PRESSUREZONE: null
  SYSTEM: null
  GEOADDR: null
  LOCATION: null
  ADR_B2: null
  ADR_BDG: null
  ADR_DIR: null
  ADR_PT: null
  ADR_SFX: null
  ADR_STR: null
  ADR_TY: null
  tempaddr: null
  VC_ID: null
  VC_NUMBER: null
  InLucity: 0
  LastModBy: null
  LastModDate: null
  LastSynDate: 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