Name: HUSA_Hydrant

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9115121.3753
YMin: 3235542.1999
XMax: -9102080.0732
YMax: 3242970.9496
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,44,148,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• HydrantID (type: esriFieldTypeString, alias: Hydrant ID, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Inspector (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• InspectDate (type: esriFieldTypeDate, alias: Inspection Date and Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• StreetNumber (type: esriFieldTypeInteger, alias: Street Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• StreetName (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CrossStreet (type: esriFieldTypeString, alias: Cross Street, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LocationDescription (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• OperatingConditionID (type: esriFieldTypeString, alias: Operating Condition, SQL Type: sqlTypeOther, length: 144, nullable: true, editable: true)
• FoundOutOfServiceID (type: esriFieldTypeString, alias: Found Out of Service, SQL Type: sqlTypeOther, length: 83, nullable: true, editable: true)
• CNAHydrantReasonID (type: esriFieldTypeString, alias: CNA Hydrant Reason, SQL Type: sqlTypeOther, length: 93, nullable: true, editable: true)
• ManufacturerID (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 314, nullable: true, editable: true)
• ModelID (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 1019, nullable: true, editable: true)
• Year (type: esriFieldTypeInteger, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MainValveSize (type: esriFieldTypeDouble, alias: Main Valve Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TrafficHydrant (type: esriFieldTypeString, alias: Traffic Hydrant, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• StorzConnection (type: esriFieldTypeString, alias: Storz Connection, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• PumperHeight (type: esriFieldTypeInteger, alias: Pumper Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• StaticPressure (type: esriFieldTypeInteger, alias: Static Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PitotPressure (type: esriFieldTypeInteger, alias: Pitot Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LowFlow (type: esriFieldTypeString, alias: Low Flow Hydrant, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• ResidualPressure (type: esriFieldTypeInteger, alias: Residual Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MinutesFlowed (type: esriFieldTypeInteger, alias: Minutes Flowed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlushIncrement (type: esriFieldTypeInteger, alias: Flush Increment, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DiffuserTypeID (type: esriFieldTypeString, alias: Diffuser Type, SQL Type: sqlTypeOther, length: 48, nullable: true, editable: true)
• TestHydrantCoefficient (type: esriFieldTypeDouble, alias: TestHydrantCoefficient, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TestHydrantDiameter (type: esriFieldTypeDouble, alias: TestHydrantDiameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TestlHydGallonsPerMinute (type: esriFieldTypeInteger, alias: TestlHydGallonsPerMinute, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GallonsFlowed (type: esriFieldTypeInteger, alias: Gallons Flowed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• M17TypeID (type: esriFieldTypeString, alias: M17TypeID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CumulativeGPM (type: esriFieldTypeDouble, alias: CumulativeGPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Flow20 (type: esriFieldTypeDouble, alias: Flow at 20 psi, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SoloPortDiameter (type: esriFieldTypeDouble, alias: SoloPortDiameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SoloPortCoefficient (type: esriFieldTypeDouble, alias: SoloPortCoefficient, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SoloPortPSI (type: esriFieldTypeDouble, alias: SoloPortPSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SoloHydrantPSI (type: esriFieldTypeDouble, alias: SoloHydrantPSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SoloPortGPM (type: esriFieldTypeDouble, alias: SoloPortGPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlowHydrantID (type: esriFieldTypeString, alias: FlowHydrantID, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FlowHydrantPSI (type: esriFieldTypeDouble, alias: FlowHydrantPSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlowHydrantPortDiameter (type: esriFieldTypeDouble, alias: FlowHydrantPortDiameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlowHydrantCoefficient (type: esriFieldTypeDouble, alias: FlowHydrantCoefficient, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlowHydrantTestHydrantPSI (type: esriFieldTypeDouble, alias: FlowHydrantTestHydrantPSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlowHydrantGPM (type: esriFieldTypeDouble, alias: FlowHydrantGPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TestHydSufficientDrawdown (type: esriFieldTypeString, alias: TestHydSufficientDrawdown, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• FlowHydrantAdditionalPort (type: esriFieldTypeSmallInteger, alias: FlowHydrantAdditionalPort, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlowPortDiameter (type: esriFieldTypeDouble, alias: FlowPortDiameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlowPortCoefficient (type: esriFieldTypeDouble, alias: FlowPortCoefficient, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlowPortHydrantPSI (type: esriFieldTypeDouble, alias: FlowPortHydrantPSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlowPortTestHydrantPSI (type: esriFieldTypeDouble, alias: FlowPortTestHydrantPSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlowPortGPM (type: esriFieldTypeDouble, alias: FlowPortGPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TagID (type: esriFieldTypeString, alias: Tagged, SQL Type: sqlTypeOther, length: 66, nullable: true, editable: true)
• MarkerID (type: esriFieldTypeString, alias: Markered, SQL Type: sqlTypeOther, length: 76, nullable: true, editable: true)
• BrushID (type: esriFieldTypeString, alias: Brushed, SQL Type: sqlTypeOther, length: 74, nullable: true, editable: true)
• PaintID (type: esriFieldTypeString, alias: Painted, SQL Type: sqlTypeOther, length: 74, nullable: true, editable: true)
• FieldComment (type: esriFieldTypeString, alias: Field Comment, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DeliverableID (type: esriFieldTypeString, alias: Deliverable ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• HorizontalAccuracy (type: esriFieldTypeDouble, alias: Horizontal Accuracy, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RepairTypeID (type: esriFieldTypeString, alias: Repairs, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• RepairComment (type: esriFieldTypeString, alias: Repair Comment, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• RepairDate (type: esriFieldTypeDate, alias: Repair Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RepairByID (type: esriFieldTypeString, alias: Repairing Party, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• RepairStatusID (type: esriFieldTypeString, alias: Repair Status, SQL Type: sqlTypeOther, length: 68, nullable: true, editable: true)
• RepairReasonID (type: esriFieldTypeString, alias: Repair Reason, SQL Type: sqlTypeOther, length: 467, nullable: true, editable: true)
• OutOfServiceTypeID (type: esriFieldTypeString, alias: Out of Service Type, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• OutOfServiceComment (type: esriFieldTypeString, alias: Out of Service Comment, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• OutOfServiceDateNotified (type: esriFieldTypeDate, alias: Out of Service Date Notified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Easting (type: esriFieldTypeDouble, alias: Easting, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Northing (type: esriFieldTypeDouble, alias: Northing, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Z (type: esriFieldTypeDouble, alias: Z, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HydrantInspectionGUID (type: esriFieldTypeString, alias: HydrantInspectionGUID, SQL Type: sqlTypeOther, length: 2048, nullable: true, editable: true)

Templates:

Name: HUSA_Hydrant
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/21/2024 6:39:24 PM

Schema Last Edit Date: 6/21/2024 6:39:24 PM

Data Last Edit Date: 6/21/2024 6:39:24 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat