View In:   ArcGIS Online Map Viewer

Name: Water Hydrants

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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: 1402335.1323099285
YMin: 278389.1906681955
XMax: 1433650.7022245936
YMax: 334528.55345486104
Spatial Reference: 102697  (102697)

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• 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 )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MANUFACTURER , Coded Values: [American Darling: American Darling] , [Clow Corporation: Clow Corporation] , [Dresser: Dresser] , ...8 more... )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: 1, modelName: OPERABLE , Coded Values: [0: False] , [1: True] )
• LASTSERVICE ( type: esriFieldTypeDate, alias: Last Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTSERVICE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• FLOW ( type: esriFieldTypeDouble, alias: Flow Rate (GPM), editable: true, nullable: true, defaultValue: null, modelName: FLOW )
• 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 )
• ID_FIELD ( type: esriFieldTypeString, alias: Hydrant ID Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ID_FIELD )
• H2OR3WAY ( type: esriFieldTypeString, alias: 2 or 3 Way Hydrant, editable: true, nullable: true, length: 10, defaultValue: null, modelName: H2OR3WAY , Coded Values: [2 Way: 2 Way] , [3 Way: 3 Way] )
• PAINT ( type: esriFieldTypeString, alias: Hydrant Paint, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PAINT )
• WATER_MAIN ( type: esriFieldTypeString, alias: Water Main, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATER_MAIN )
• GRID_ID ( type: esriFieldTypeString, alias: Map Grid ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GRID_ID )
• FLOW_CLASS ( type: esriFieldTypeString, alias: Flow Class, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FLOW_CLASS )
• STATIC ( type: esriFieldTypeInteger, alias: Static, editable: true, nullable: true, defaultValue: null, modelName: STATIC )
• RESIDUAL ( type: esriFieldTypeInteger, alias: Residual, editable: true, nullable: true, defaultValue: null, modelName: RESIDUAL )
• OPENING ( type: esriFieldTypeDouble, alias: Opening, editable: true, nullable: true, defaultValue: null, modelName: OPENING )
• DATE ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE )
• CREW ( type: esriFieldTypeString, alias: Crew, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CREW )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 400, defaultValue: null, modelName: NOTES )
• LAT_DMS ( type: esriFieldTypeString, alias: Latitude Degree Min Sec, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAT_DMS )
• LONG_DMS ( type: esriFieldTypeString, alias: Longitude Degree Min Sec, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LONG_DMS )
• STREET_NUM ( type: esriFieldTypeSmallInteger, alias: Street Address Number, editable: true, nullable: true, defaultValue: null, modelName: STREET_NUM )
• STREET_DIR ( type: esriFieldTypeString, alias: Street Address Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STREET_DIR )
• STREET_NAME ( type: esriFieldTypeString, alias: Street Address Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_NAME )
• STREET_TYPE ( type: esriFieldTypeString, alias: Street Address Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STREET_TYPE )
• UNIT ( type: esriFieldTypeString, alias: Street Address Unit, editable: true, nullable: true, length: 15, defaultValue: null, modelName: UNIT )
• OKAY ( type: esriFieldTypeString, alias: Data Review Code, editable: true, nullable: true, length: 3, defaultValue: null, modelName: OKAY )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED , Coded Values: [BEE_CREEK: Bee Creek] , [COOPER_CREEK: Cooper Creek] , [COPELAND_BRANCH: Copeland Branch] , ...7 more... )
• PRESSUREZN ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRESSUREZN )
• YR_PAINT ( type: esriFieldTypeString, alias: Year Painted, editable: true, nullable: true, length: 10, defaultValue: null, modelName: YR_PAINT )
• CONDITION ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• WATER_MAIN_DIA ( type: esriFieldTypeDouble, alias: Water Main Diameter, editable: true, nullable: true, defaultValue: null, modelName: WATER_MAIN_DIA )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• UT_HYD_ID ( type: esriFieldTypeString, alias: Utilities Hydrant ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UT_HYD_ID )
• HYDRANT_YEAR ( type: esriFieldTypeInteger, alias: Year Hydrant Built, editable: true, nullable: true, defaultValue: null, modelName: HYDRANT_YEAR )
• HYD_SIZE ( type: esriFieldTypeString, alias: Hydrant Size, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYD_SIZE , Coded Values: [5 1/4: 5 1/4] , [4 1/4: 4 1/4] )
• HYD_VLV ( type: esriFieldTypeString, alias: Hydrant Valve Yes/No, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYD_VLV , Coded Values: [Yes: Yes] , [No: No] )
• LATITUDE_DD ( type: esriFieldTypeString, alias: Latitude Decimal Degrees, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LATITUDE_DD )
• LONGITUDE_DD ( type: esriFieldTypeString, alias: Longitude Decimal Degrees, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LONGITUDE_DD )
• LAST_INSPECTION_DATE ( type: esriFieldTypeDate, alias: Date of Last Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_INSPECTION_DATE )
• INSPECTION_STATUS ( type: esriFieldTypeString, alias: Hydrant Inspection Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPECTION_STATUS , Coded Values: [Inspected within a year: Inspected within a year] , [Inspected more than a year ago: Inspected more than a year ago] , [No Data: No Data] )
• NEEDS_REPAIR ( type: esriFieldTypeString, alias: Needs Repair, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEEDS_REPAIR , Coded Values: [Yes: Yes] , [No: No] )
• NEEDS_PAINT ( type: esriFieldTypeString, alias: Needs Repair, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEEDS_PAINT , Coded Values: [Yes: Yes] , [No: No] )
• LEAKING ( type: esriFieldTypeString, alias: Leaking, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LEAKING , Coded Values: [Yes: Yes] , [No: No] )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• PSI ( type: esriFieldTypeSmallInteger, alias: PSI, editable: true, nullable: true, defaultValue: null, modelName: PITOT )

Templates:

• Name: Water Hydrants
  Description:
  Prototype:
  LEAKING: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  MANUFACTURER: null
  OPERABLE: 1
  LASTSERVICE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  FLOW: null
  NEEDS_PAINT: null
  NEEDS_REPAIR: null
  INSPECTION_STATUS: null
  LAST_INSPECTION_DATE: null
  ID_FIELD: null
  H2OR3WAY: null
  PAINT: null
  WATER_MAIN: null
  GRID_ID: null
  FLOW_CLASS: null
  STATIC: null
  RESIDUAL: null
  OPENING: null
  DATE: null
  CREW: null
  NOTES: null
  LAT_DMS: null
  LONG_DMS: null
  STREET_NUM: null
  STREET_DIR: null
  STREET_NAME: null
  STREET_TYPE: null
  UNIT: null
  OKAY: null
  WATERSHED: null
  PRESSUREZN: null
  YR_PAINT: null
  CONDITION: null
  WATER_MAIN_DIA: null
  PSI: null
  UT_HYD_ID: null
  HYDRANT_YEAR: null
  HYD_SIZE: null
  HYD_VLV: null
  LATITUDE_DD: null
  LONGITUDE_DD: 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: true

Supports Coordinates Quantization: true

Supported Operations:   Query   Query DateBins   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata