View In:   ArcGIS Online Map Viewer

Name: Hydrant

Display Field: PLAN_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 83935a088d5d4083bfe4ead665f537c2

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

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: true

Supports Datum Transformation: true

Extent:

XMin: 2508610.6894632727
YMin: 7078076.593848705
XMax: 2547441.840313673
YMax: 7107430.7988949865
Spatial Reference: 102738  (2276)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: AncillaryRole, editable: true, nullable: true, defaultValue: 0, modelName: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• ADMINISTRATIVEAREA ( type: esriFieldTypeString, alias: AdministrativeArea, editable: true, nullable: true, length: 200, defaultValue: null, modelName: AdministrativeArea , Coded Values: [N: North] , [S: South] , [E: East] , ...3 more... )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: InstalledDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: LocationDescription, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LocationDescription )
• OPERATIONALAREA ( type: esriFieldTypeString, alias: OperationalArea, editable: true, nullable: true, length: 200, defaultValue: null, modelName: OperationalArea , Coded Values: [Unk: Unknown] , [Oth: Others] , [D1: Grid 1] , ...61 more... )
• ROTATION ( type: esriFieldTypeDouble, alias: ROTATION, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LifecycleStatus, editable: true, nullable: true, length: 20, defaultValue: Active, modelName: LifecycleStatus , Coded Values: [Proposed: Proposed] , [Active: Active] , [Abandoned: Abandoned] , ...2 more... )
• SUBTYPE ( type: esriFieldTypeInteger, alias: Subtype, editable: true, nullable: true, defaultValue: 1, modelName: Subtype )
• WORKORDERID ( type: esriFieldTypeString, alias: WORKORDERID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WORKORDERID )
• ELEVATION ( type: esriFieldTypeDouble, alias: ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• WATERTYPE ( type: esriFieldTypeString, alias: WaterType, editable: true, nullable: true, length: 255, defaultValue: Potable, modelName: WaterType , Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...6 more... )
• BARRELDIAMETER ( type: esriFieldTypeInteger, alias: BarrelDiameter, editable: true, nullable: true, defaultValue: 6, modelName: BarrelDiameter , Coded Values: [1: 1 inch] , [2: 2 inch] , [4: 4 inch] , ...21 more... )
• MAINVALVETYPE ( type: esriFieldTypeString, alias: MAINVALVETYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MAINVALVETYPE )
• NOZZLEDIAMETER1 ( type: esriFieldTypeInteger, alias: NozzleDiameter1, editable: true, nullable: true, defaultValue: 5, modelName: NozzleDiameter1 , Coded Values: [1: 1 inch] , [2: 2 inch] , [4: 4 inch] , ...21 more... )
• NOZZLEDIAMETER2 ( type: esriFieldTypeInteger, alias: NozzleDiameter2, editable: true, nullable: true, defaultValue: 5, modelName: NozzleDiameter2 , Coded Values: [1: 1 inch] , [2: 2 inch] , [4: 4 inch] , ...21 more... )
• NOZZLEDIAMETER3 ( type: esriFieldTypeInteger, alias: NozzleDiameter3, editable: true, nullable: true, defaultValue: 5, modelName: NozzleDiameter3 , Coded Values: [1: 1 inch] , [2: 2 inch] , [4: 4 inch] , ...21 more... )
• NOZZLEDIAMETER4 ( type: esriFieldTypeInteger, alias: NozzleDiameter4, editable: true, nullable: true, defaultValue: null, modelName: NozzleDiameter4 , Coded Values: [1: 1 inch] , [2: 2 inch] , [4: 4 inch] , ...21 more... )
• OUTLETCONFIGURATION ( type: esriFieldTypeString, alias: OUTLETCONFIGURATION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OUTLETCONFIGURATION )
• SEATDIAMETER ( type: esriFieldTypeInteger, alias: SEATDIAMETER, editable: true, nullable: true, defaultValue: null, modelName: SEATDIAMETER )
• SUBDIVISION ( type: esriFieldTypeString, alias: Subdivision, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Subdivision )
• SUBDIVISION_ID ( type: esriFieldTypeInteger, alias: Subdivision_ID, editable: true, nullable: true, defaultValue: null, modelName: Subdivision_ID )
• COLOR_CODE ( type: esriFieldTypeInteger, alias: Hydrant Color Code, editable: true, nullable: true, defaultValue: 0, modelName: Color_Code , Coded Values: [0: Blue] , [1: Red] , [2: Silver] , ...2 more... )
• Hydrant_I ( type: esriFieldTypeString, alias: Hydrant ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HYDRANT_ID )
• YearProduct ( type: esriFieldTypeSmallInteger, alias: Year of Production, editable: true, nullable: true, defaultValue: null, modelName: FYEAR , Coded Values: [2000: 2000] , [2001: 2001] , [2002: 2002] , ...58 more... )
• MAIN_SIZE ( type: esriFieldTypeInteger, alias: MAIN_SIZE, editable: true, nullable: true, defaultValue: null, modelName: MAIN_SIZE , Coded Values: [1: 1 inch] , [2: 2 inch] , [4: 4 inch] , ...21 more... )
• PaintDate ( type: esriFieldTypeDate, alias: Date Hydrant Painted, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PAINT_DATE )
• FLUSHED ( type: esriFieldTypeSmallInteger, alias: FLUSHED (GPM), editable: true, nullable: true, defaultValue: null, modelName: FLUSHED )
• PRESSURE ( type: esriFieldTypeSmallInteger, alias: PRESSURE, editable: true, nullable: true, defaultValue: null, modelName: PRESSURE )
• LEAD_VALVE ( type: esriFieldTypeSmallInteger, alias: LEAD_VALVE, editable: true, nullable: true, defaultValue: null, modelName: LEAD_VALVE , Coded Values: [1: Yes] , [0: No] )
• RadioID ( type: esriFieldTypeSmallInteger, alias: Radio ID, editable: true, nullable: true, defaultValue: null, modelName: RADIO_ID , Coded Values: [603: 603] , [610: 610] , [611: 611] , ...36 more... )
• Model ( type: esriFieldTypeString, alias: Hydrant Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MODEL , Coded Values: [2700: 2700] , [2780: 2780] , [IMPROVED: IMPROVED] , ...11 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 60, defaultValue: null, modelName: Comments )
• Date_Inspect ( type: esriFieldTypeDate, alias: Date of Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_Inspect )
• Manufacturer ( type: esriFieldTypeString, alias: Hydrant Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer , Coded Values: [AVK: AVK] , [MUELLER: MUELLER] , [MandH: M and H] , ...6 more... )
• SUBDIVISIONCCADID ( type: esriFieldTypeInteger, alias: Subdivision CCAD ID, editable: true, nullable: true, defaultValue: null, modelName: SUBDIVISIONCCADID )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Ownedby ( type: esriFieldTypeSmallInteger, alias: Owned by, editable: true, nullable: true, defaultValue: null, modelName: Ownedby , Coded Values: [0: Public] , [1: Private] , [2: Other] )
• MaintainedBy ( type: esriFieldTypeString, alias: Maintained by, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MaintainedBy , Coded Values: [Allen: Allen] , [NTMWD: NTMWD] , [Plano: Plano] , ...7 more... )
• PLAN_NAME ( type: esriFieldTypeString, alias: PLAN_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PLAN_NAME )
• CWID ( type: esriFieldTypeString, alias: CWID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CWID )
• SCANFILE ( type: esriFieldTypeString, alias: SCANFILE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SCANFILE )
• DateofService ( type: esriFieldTypeDate, alias: Date of Service, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateofService )
• TrafficRepair ( type: esriFieldTypeSmallInteger, alias: Traffic repair?, editable: true, nullable: true, defaultValue: null, modelName: TrafficRepair , Coded Values: [1: Yes] , [0: No] )
• RepairComment ( type: esriFieldTypeString, alias: Repair Comment, editable: true, nullable: true, length: 120, defaultValue: null, modelName: RepairComment )
• LowerMVAssemb ( type: esriFieldTypeSmallInteger, alias: Lower main valve assembly, editable: true, nullable: true, defaultValue: null, modelName: LowerMVAssemb , Coded Values: [1: Yes] , [0: No] )
• InspectedBy ( type: esriFieldTypeString, alias: Inspected By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectedBy )
• ReplaceLowerMVA ( type: esriFieldTypeSmallInteger, alias: Replace Lower Main Valve Assembly?, editable: true, nullable: true, defaultValue: null, modelName: ReplaceLowerMVA , Coded Values: [1: Yes] , [0: No] )
• Piciture ( type: esriFieldTypeString, alias: Pciture, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Piciture )

Templates:

• Name: Hydrant
  Description:
  Prototype:
  ReplaceLowerMVA: null
  ANCILLARYROLE: 0
  ROTATION: null
  LIFECYCLESTATUS: Active
  ELEVATION: null
  WATERTYPE: Potable
  MAINVALVETYPE: null
  NOZZLEDIAMETER1: 5
  NOZZLEDIAMETER2: 5
  SUBDIVISION_ID: null
  ENABLED: 1
  ADMINISTRATIVEAREA: null
  FACILITYID: null
  INSTALLDATE: null
  LOCATIONDESCRIPTION: null
  OPERATIONALAREA: null
  SUBTYPE: 1
  WORKORDERID: null
  BARRELDIAMETER: 6
  NOZZLEDIAMETER3: 5
  NOZZLEDIAMETER4: null
  OUTLETCONFIGURATION: null
  SEATDIAMETER: null
  SUBDIVISION: null
  COLOR_CODE: 0
  Hydrant_I: null
  YearProduct: null
  MAIN_SIZE: null
  PaintDate: null
  FLUSHED: null
  PRESSURE: null
  LEAD_VALVE: null
  RadioID: null
  Model: null
  Comments: null
  Date_Inspect: null
  Manufacturer: null
  SUBDIVISIONCCADID: null
  InspectedBy: null
  LowerMVAssemb: null
  RepairComment: null
  TrafficRepair: null
  Piciture: null
  Ownedby: null
  MaintainedBy: null
  PLAN_NAME: null
  CWID: null
  SCANFILE: null
  DateofService: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

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   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata