View In:   ArcGIS Online Map Viewer

Name: wHydrant_Curr

Display Field: ARCGIS_DBO_Audit_Fire_Hydrant_N

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 5c5a5fb82a974bc3b4d63f6d340b10c8

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 1353164.2658133656
YMin: 172294.35838355124
XMax: 2.730109865632251E7
YMax: 2.940514178095436E7
Spatial Reference: 103069  (6488)  LatestVCSWkid(0)

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• ARCGIS_DBO_Audit_Fire_Hydrant_N ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ARCGIS_DBO_Audit_Fire_Hydrant_Notes )
• ARCGIS_DBO_Audit_Fire_Hydrant_I ( type: esriFieldTypeString, alias: Identifier, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ARCGIS_DBO_Audit_Fire_Hydrant_Identifier )
• ARCGIS_DBO_Audit_Fire_Hydrant_3 ( type: esriFieldTypeString, alias: CONFIDENCE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONFIDENCE )
• ARCGIS_DBO_Audit_Fire_Hydrant_4 ( type: esriFieldTypeInteger, alias: IDENTIFIER_2, editable: true, nullable: true, defaultValue: null, modelName: IDENTIFIER_2 )
• ARCGIS_DBO_HydrantDataTable2017 ( type: esriFieldTypeInteger, alias: OBJECTID, editable: true, nullable: true, defaultValue: null, modelName: OBJECTID )
• ARCGIS_DBO_HydrantDataTable20_1 ( type: esriFieldTypeInteger, alias: Hydrant No, editable: true, nullable: true, defaultValue: null, modelName: Hydrant_No )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Location_No ( type: esriFieldTypeInteger, alias: Location No, editable: true, nullable: true, defaultValue: null, modelName: Location_No )
• Water_System ( type: esriFieldTypeString, alias: Water System, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Water_System )
• Sub_System ( type: esriFieldTypeString, alias: Sub System, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Sub_System )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Location )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Manufacturer )
• ModelNo ( type: esriFieldTypeString, alias: ModelNo, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ModelNo )
• Traffic_Hydrant ( type: esriFieldTypeString, alias: Traffic Hydrant, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Traffic_Hydrant )
• Year ( type: esriFieldTypeString, alias: Year, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Year )
• Iso_ValveLocation ( type: esriFieldTypeString, alias: IsoValveLocation, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Iso_ValveLocation )
• Iso_Valve_Distance ( type: esriFieldTypeInteger, alias: Iso Valve Distance, editable: true, nullable: true, defaultValue: null, modelName: Iso_Valve_Distance )
• Audit_Date ( type: esriFieldTypeString, alias: Audit Date, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Audit_Date )
• Static_Press ( type: esriFieldTypeInteger, alias: Static Press, editable: true, nullable: true, defaultValue: null, modelName: Static_Press )
• Flow_Test_PSI ( type: esriFieldTypeInteger, alias: Flow Test PSI, editable: true, nullable: true, defaultValue: null, modelName: Flow_Test_PSI )
• Residual_Pressure ( type: esriFieldTypeInteger, alias: Residual Pressure, editable: true, nullable: true, defaultValue: null, modelName: Residual_Pressure )
• Flow_Test_GPM ( type: esriFieldTypeInteger, alias: Flow Test GPM, editable: true, nullable: true, defaultValue: null, modelName: Flow_Test_GPM )
• F20_PSI_Flow_Rate ( type: esriFieldTypeInteger, alias: 20 PSI Flow Rate, editable: true, nullable: true, defaultValue: null, modelName: F20_PSI_Flow_Rate )
• Class_AA ( type: esriFieldTypeString, alias: Class AA, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Class_AA )
• Class_A ( type: esriFieldTypeString, alias: Class A, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Class_A )
• Class_B ( type: esriFieldTypeString, alias: Class B, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Class_B )
• Class_C ( type: esriFieldTypeString, alias: Class C, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Class_C )
• Comments___Repairs ( type: esriFieldTypeString, alias: Comments / Repairs, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Comments___Repairs )
• Need_Extension ( type: esriFieldTypeString, alias: Need Extension, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Need_Extension )
• Extension_Length ( type: esriFieldTypeInteger, alias: Extension Length, editable: true, nullable: true, defaultValue: null, modelName: Extension_Length )
• Out_of_service ( type: esriFieldTypeString, alias: Out of service, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Out_of_service )
• Main_Valve_Size ( type: esriFieldTypeDouble, alias: MainValveSize, editable: true, nullable: true, defaultValue: null, modelName: Main_Valve_Size )
• Main_Valve_Open_Right ( type: esriFieldTypeString, alias: Main Valve Open Right, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Main_Valve_Open_Right )
• Pumper_Height ( type: esriFieldTypeDouble, alias: Pumper Height, editable: true, nullable: true, defaultValue: null, modelName: Pumper_Height )
• Hose_Nozzle_Size ( type: esriFieldTypeDouble, alias: Hose_Nozzle_Size, editable: true, nullable: true, defaultValue: null, modelName: Hose_Nozzle_Size )
• Hose_Nozzle_NST ( type: esriFieldTypeString, alias: Hose Nozzle NST, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Hose_Nozzle_NST )
• Oper_Nut_Size ( type: esriFieldTypeDouble, alias: Oper Nut Size, editable: true, nullable: true, defaultValue: null, modelName: Oper_Nut_Size )
• Oper_Nut_Shape ( type: esriFieldTypeString, alias: Oper Nut Shape, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Oper_Nut_Shape )
• Pumper_Nozzle_Size ( type: esriFieldTypeDouble, alias: PumperNozzleSize, editable: true, nullable: true, defaultValue: null, modelName: Pumper_Nozzle_Size )
• Pumper_Nozzle_NST ( type: esriFieldTypeString, alias: Pumper Nozzle NST, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Pumper_Nozzle_NST )
• 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 )
• NEAR_FID ( type: esriFieldTypeInteger, alias: NEAR_FID, editable: true, nullable: true, defaultValue: null, modelName: NEAR_FID )
• NEAR_DIST ( type: esriFieldTypeDouble, alias: NEAR_DIST, editable: true, nullable: true, defaultValue: null, modelName: NEAR_DIST )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X, editable: true, nullable: true, defaultValue: null, modelName: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y, editable: true, nullable: true, defaultValue: null, modelName: POINT_Y )
• ADDRESS ( type: esriFieldTypeInteger, alias: ADDRESS, editable: true, nullable: true, defaultValue: null, modelName: ADDRESS )
• Feeder_Size ( type: esriFieldTypeInteger, alias: Feeder_Size, editable: true, nullable: true, defaultValue: null, modelName: Feeder_Size )
• Main_Size ( type: esriFieldTypeInteger, alias: Main_Size, editable: true, nullable: true, defaultValue: null, modelName: Main_Size )
• CAP_COLOR ( type: esriFieldTypeString, alias: CAP_COLOR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CAP_COLOR )
• PAINTED_DATE ( type: esriFieldTypeString, alias: PAINTED_DATE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PAINTED_DATE )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OWNER )
• INSPECTION_STATUS ( type: esriFieldTypeString, alias: INSPECTION_STATUS, editable: true, nullable: true, length: 255, defaultValue: 0, modelName: INSPECTION_STATUS , Coded Values: [0: Inspection Not Started] , [1: Needs Painted] , [2: Needs Inspected] , ...1 more... )
• INSPECTION_DATE ( type: esriFieldTypeDate, alias: INSPECTION_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSPECTION_DATE )

Templates:

• Name: wHydrant_Curr
  Description:
  Prototype:
  INSPECTION_STATUS: 0
  ARCGIS_DBO_Audit_Fire_Hydrant_N: null
  ARCGIS_DBO_Audit_Fire_Hydrant_I: null
  ARCGIS_DBO_Audit_Fire_Hydrant_3: null
  ARCGIS_DBO_Audit_Fire_Hydrant_4: null
  ARCGIS_DBO_HydrantDataTable2017: null
  ARCGIS_DBO_HydrantDataTable20_1: null
  INSPECTION_DATE: null
  OWNER: null
  Location_No: null
  Water_System: null
  Sub_System: null
  Location: null
  Manufacturer: null
  ModelNo: null
  Traffic_Hydrant: null
  Year: null
  Iso_ValveLocation: null
  Iso_Valve_Distance: null
  Audit_Date: null
  Static_Press: null
  Flow_Test_PSI: null
  Residual_Pressure: null
  Flow_Test_GPM: null
  F20_PSI_Flow_Rate: null
  Class_AA: null
  Class_A: null
  Class_B: null
  Class_C: null
  Comments___Repairs: null
  Need_Extension: null
  Extension_Length: null
  Out_of_service: null
  Main_Valve_Size: null
  Main_Valve_Open_Right: null
  Pumper_Height: null
  Hose_Nozzle_Size: null
  Hose_Nozzle_NST: null
  Oper_Nut_Size: null
  Oper_Nut_Shape: null
  Pumper_Nozzle_Size: null
  Pumper_Nozzle_NST: null
  PAINTED_DATE: null
  CAP_COLOR: null
  Main_Size: null
  Feeder_Size: null
  NEAR_FID: null
  NEAR_DIST: null
  POINT_X: null
  POINT_Y: null
  ADDRESS: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

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

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata