ArcGIS REST Services Directory
Home
>
services
>
FireHydrantInspection_flowtests_b42a950f7f1b477dbebd04606a42d341 (FeatureServer)
>
All Layers and Tables
|
API Reference
JSON
All Layers and Tables (FireHydrantInspection_flowtests_b42a950f7f1b477dbebd04606a42d341)
Layers:
Layer:
Fire Hydrant
(501007)
Name:
Fire Hydrant
Display Field:
assettype
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Is View:
true
Is Updatable View:
true
Source Schema Changes Allowed:
true
Description:
Copyright Text:
Min. Scale:
288896
Max. Scale:
0
Default Visibility:
true
Max Record Count:
2000
Supported query Formats:
JSON, geoJSON, PBF
Use Standardized Queries:
True
Extent:
XMin: -9821496.03370861
YMin: 5115549.93593752
XMax: -9804798.11008962
YMax: 5137938.83238724
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"ASSETTYPE","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,255,255],"size":12.75,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.5}},"defaultLabel":"Other","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"bcbf3571-1afb-4c99-b024-8b76d91e3361","imageData":"iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAED0lEQVRIic2Wz0tcVxTHP0+dXGM7c+Oo1zY6Dx4zsyh1bCKmm44uJouICIGk0H8ghMCsuuteSxexBAqBLFyVrgL5URDTLHQRcBOFQOaBi9EMDBlLx3HMU6M+ZLxdzMzTcWZIS6T0rB733Xs+99z7PefcNv5Da/v/wbp0H20E0VzkiKA3rtkHchyyxrZR/DhYj45gEOaIIKUG/w3OAxHOEUHpIiVsNo3cv4f16FE0fWhgAosRhrAYQnABQScA22TYIMMDHpECDEbp0Tk2jBf/HFYFxejkDjcJk2g4L4BFAIu7JFhjgSQzaPpQ+hp54/mHYVXQBBbfcpPPGAK4QYGEs4rf3cV/sMOh7OZNe5AndPNS9EKYBA+xmGSaFNClr7BpLDWH9eiIF1EF9AV73Gadr90884vznFSBlJKfBgZYF0W+J0Ih4LOYYorrJDGIENA1wqmFGYTRwJ1j0D1W6eYQhGBgYADbtr3poVAIKSWSPf7gNWMMUhC+Tu5ziyQz+BgFntbDunQfRwSZwKre0W3WyyDAtm2y2WzN3mzbxnVdotEoAL+xwhiD5SOdYJ5ZMgR0sBrdMaytIu+R4zsawakBKaVwXRfHcVBKoZTCtm2EEJimid/d5YYo8JhuiGExSwYfYeAUTHMRAKsMG3ffsri8SCgU8kDDw8Pk83lviVLK24yUkuXlZcbjHTwW3XCZq8ACrcdF4BhWrQyCCwD+gx3WHQfHKUfnui7ZbBbTNL0l6XTagy8uLgIQ/CsD5qVyWpz0SyPpVxLW7+7WDDuO491N1aSUpNPpOhfNrGkF2cBX57iRSSm96AF22v3lD5ctoFo/T8E0+xicZ5sMAax1+TlCCKLRqCd3pRTpdNoDK6XIZrMIIYjFYqRSKTKicmpbZABobQSDHBBhowx7Qjf34nGEELiuSzqd9u6lCsxms+TzeUzTRClFPB7nR8qi4T3vACjRIKkPWeMcER7wiLskXopeVtw/uUSJaDSKEKImoR3HQVQSvSqaVwctzMn+8oRnzHt+62DbRhGli6SANRYIk/hBfMnv7pKXR1JKLzoA0zQ90Aod/NpeOcI1FpglQwvF5uWqhI3BKElmeIhVCPisMQaZcV4Rlh11yqvmX6Y9yC8Hn/Ba9pbbTpIZz98Jq4VtGjl6dA5NH5NMM8XUjvi08zsxwrj7lvHoV3wT3QOggI837UF+RjIn+kFQBk0yDYBm9XQjrZf+hvECpa+RAq6T5D63CJOYE/1lp82s2s8ADHIUattLYxhA3nhOl76CQYQkM0wwTwyLy1z1KoPLFltkeM87nlWKbjWiBqDmMIBNY4mAXsPHKLNkKs4Wms5v4SPeIEBFSU8J6CA+wrQS9GqdZp9W9ilRPJvXVS30g87OBnZG9jeb9ZwD8bQiVwAAAABJRU5ErkJggg==","contentType":"image/png","width":20,"height":20,"angle":0,"xoffset":0,"yoffset":0},"value":"0","label":"Unknown"},{"symbol":{"type":"esriPMS","url":"ec1e8eb6-b98c-466c-8497-8b74519a59f2","imageData":"iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAEMklEQVRIic2WUUhbVxjHf1dN0w5Na9RgbmBwl6jzwbU1dntJ3RYf2nWphbUvLRT6ULQs7EXYy15M0bc6BmOFNvNpMGHFMjGZtg9xrN2e6l2FFIqrISDNjdWqNaRoED17uMlNryZ0ozJ2nu4957v/H993/uc7t4r/cFT9/2B1wkUVdgQy29iNecE6kGKTBBlp5c1gDcKDhJtt7GyVWJc4AHjYhweHWGGLRyxLqX8PaxCdCFwIIIDCcdpRaMfKIazUApAhyRJJbnCbOCDRSYNIsSTd++ewAqiNWq5wFjf+knE2FGwoXMNPgimCDCNw4RAnWJTuvh5WAAVQOMdZGmkHkCdG8MbGURMP8W5uo1oqoNWL83wf6nsd4MbPLRQGGCIO1IljLEsPysMahMfIKA+Sk7No336Jdj/CuO8S3sOfGeHRxTl6P/8YlBb4JgL1ToVBBjlDEAkPNmEyjhkm4UYAV/IZPVZxhnrQEn8CEJ6f4WbbSSM88mwObSMLj1U4KSP/mkGrqanlOpcJMoyFTmBsN6xOuNjGTgClsEfyD1+j5kE9bx8xgQDjPTw/o09c7ICxWb2kAWJESWIT9kJ2RVhV3t7H9T3yxsZJ34+YQOraAvL+apzWasLzM6RzWTPwuYY8MYJ26gK0oRAliQU3sAMmkAFQdBg/hxnvOEd0cY7+Jh/q2gLd06N4DzaayggQatbXQ80+In9MET51AY7SBUxRWWwCRVihM1g5BJB++gTv4TZDXN5fTcDhKZYsDwk4PDit1Uz7LukZTo/qizYUky6lrJ8/sIGKt0zTTms16VzWNKeuLdDf5NsVV26U7SCqpWKXcKmRzmXNgHp9N8ixChT65w6YYB2JA2RIYkNRZRfq2gJXn/xumCDybM7YHwBtI4u6toDTWk1v/I5uItml662SBKCyFAxSgIclHSaf76O77zTaRhanVQcW9qW/yUc6p4MCDg+98TuGgZxXf9TVXvICgC1KHOpNEuzDww1ucw2/9v5HnP7gU7TffjJMEWr2GSVzWvUj0D09arjSeeRD1K5uXW+SmKG7C5aRVnCIFeJAginc+NXQ98if/IK2kSU8P4O6tmBkB3q7KoBo9SJ/MYRK/vsoSSpYKd+utniERCdBhrmFotlqFHlSQ77Ygfb0L0LNReelc1m8Bxv1o9HqhZ4QkZZ39WsnyLCh98oww5alFA0ihcDFAEMMMqjV1NQyNos3Nk54YoTe2Hd6Ketl0u+04PzqZrF0GZIMMASAYG7nRbrb+kvSPRziBHHgDEGucxk3frWr2xDVXgk3ngv3GYBEiufm66U0DGBRukudOIaEhyDDBIjRhsJRuozOkGOVVZK85AWT+aZbyKgEqDwMYFl6gE0ksNBJlGRebKpsfAVv8A8C5J00hk3YseCmErvR6wTrVLLOFit783dlhr5WbG9gezT+Bj8btV2PiD2CAAAAAElFTkSuQmCC","contentType":"image/png","width":20,"height":20,"angle":0,"xoffset":0,"yoffset":0},"value":"321","label":"Fire Hydrant"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[245,252,210,255],"toColor":[245,252,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[209,184,252,255],"toColor":[209,184,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,189,255],"toColor":[252,184,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,233,252,255],"toColor":[187,233,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,252,189,255],"toColor":[187,252,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,202,238,255],"toColor":[252,202,238,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,235,255],"toColor":[179,252,235,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,226,215,255],"toColor":[252,226,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[197,208,252,255],"toColor":[197,208,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,223,182,255],"toColor":[252,223,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[249,182,252,255],"toColor":[249,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,210,217,255],"toColor":[252,210,217,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,246,179,255],"toColor":[252,246,179,255]}]}},"visualVariables":[{"type":"rotationInfo","valueExpressionTitle":"Custom","valueExpression":"$feature.symbolrotation","rotationType":"arithmetic"}]},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.assetid"},"labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","removeDuplicates":"none","useCodedValues":true,"maxScale":0,"minScale":1750,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[78,78,78,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,190,190,127],"haloSize":0.5,"font":{"family":"Tahoma","size":8,"style":"normal","weight":"bold","decoration":"none"}}}]}
HasZ:
true
HasM:
true
Has Attachments:
true
Has Geometry Properties:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Object ID Field:
OBJECTID
Unique ID Field:
Name : OBJECTID
IsSystemMaintained : True
Global ID Field:
globalid
Type ID Field:
assettype
Fields:
OBJECTID
(type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
assettype
(type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [321: Fire Hydrant], [56: TestDomain])
assetid
(type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
diameter
(type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [4: 4"], [4.5: 4 1/2"], ... 4 more ...)
secondarydiameter
(type: esriFieldTypeDouble, alias: Nozzle Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [2.5: 2 1/2"], [4.5: 4 1/2"], ... 4 more ...)
manufacturer
(type: esriFieldTypeSmallInteger, alias: Manufacturer, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [60: American Darling], [61: Clow Corporation], ... 12 more ...)
model
(type: esriFieldTypeInteger, alias: Model, SQL Type: sqlTypeOther, nullable: true, editable: true)
installdate
(type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
lifecyclestatus
(type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 7 more ...)
inservicedate
(type: esriFieldTypeDate, alias: In-Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
retireddate
(type: esriFieldTypeDate, alias: Retired Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
notes
(type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
lastmaint
(type: esriFieldTypeDate, alias: Last Maintenance, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ownedby
(type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
maintby
(type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
spatialsource
(type: esriFieldTypeSmallInteger, alias: Spatial Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: As-Built], [2: CAD], ... 3 more ...)
spatialconfidence
(type: esriFieldTypeSmallInteger, alias: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: High], [2: Medium], ... 1 more ...)
symbolrotation
(type: esriFieldTypeSmallInteger, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 359])
globalid
(type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
creationdate
(type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
creator
(type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
lastupdate
(type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
updatedby
(type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
ESRIGNSS_POSITIONSOURCETYPE
(type: esriFieldTypeSmallInteger, alias: Position source type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: User defined], [2: Integrated (System) Location Provider], ... 2 more ...)
ESRIGNSS_RECEIVER
(type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ESRIGNSS_LATITUDE
(type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_LONGITUDE
(type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_ALTITUDE
(type: esriFieldTypeDouble, alias: Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_H_RMS
(type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_V_RMS
(type: esriFieldTypeDouble, alias: Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_FIXDATETIME
(type: esriFieldTypeDate, alias: Fix Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ESRIGNSS_FIXTYPE
(type: esriFieldTypeSmallInteger, alias: Fix Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Fix not valid], [1: GPS], [2: Differential GPS], ... 2 more ...)
ESRIGNSS_CORRECTIONAGE
(type: esriFieldTypeDouble, alias: Correction Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_STATIONID
(type: esriFieldTypeSmallInteger, alias: Station ID, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 1023])
ESRIGNSS_NUMSATS
(type: esriFieldTypeSmallInteger, alias: Number of Satellites, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 99])
ESRIGNSS_PDOP
(type: esriFieldTypeDouble, alias: PDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_HDOP
(type: esriFieldTypeDouble, alias: HDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_VDOP
(type: esriFieldTypeDouble, alias: VDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_DIRECTION
(type: esriFieldTypeDouble, alias: Direction of travel (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_SPEED
(type: esriFieldTypeDouble, alias: Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRISNSR_AZIMUTH
(type: esriFieldTypeDouble, alias: Compass reading (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_AVG_H_RMS
(type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_AVG_V_RMS
(type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_AVG_POSITIONS
(type: esriFieldTypeSmallInteger, alias: Averaged Positions, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_H_STDDEV
(type: esriFieldTypeDouble, alias: Standard Deviation (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
assignmenttype
(type: esriFieldTypeInteger, alias: Assignment Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Flow Test], [2: Flush])
assignmentdue
(type: esriFieldTypeDate, alias: Assignment Due, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
assignedon
(type: esriFieldTypeDate, alias: Assigned On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
station
(type: esriFieldTypeString, alias: Assigned Station, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
shift
(type: esriFieldTypeString, alias: Assigned Shift, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
adoptionstatus
(type: esriFieldTypeString, alias: Adoption Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Available: Available], [Adopted: Adopted])
nickname
(type: esriFieldTypeString, alias: Nickname, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
publicview
(type: esriFieldTypeString, alias: Public View, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
adoptedby
(type: esriFieldTypeString, alias: Adopted By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
adoptedon
(type: esriFieldTypeDate, alias: Adopted On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Types:
ID: 0
Name: Unknown
Domains:
Field Name: assettype
Inherited
Field Name: diameter
Inherited
Field Name: secondarydiameter
Inherited
Field Name: manufacturer
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: symbolrotation
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited
Templates:
Name: Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
secondarydiameter
: 0
diameter
: 0
ownedby
: 1
spatialsource
: 0
assettype
: 0
manufacturer
: 0
lifecyclestatus
: 8
maintby
: 1
spatialconfidence
: 0
ID: 321
Name: Fire Hydrant
Domains:
Field Name: assettype
Inherited
Field Name: diameter
Inherited
Field Name: secondarydiameter
Inherited
Field Name: manufacturer
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: symbolrotation
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited
Templates:
Name: Fire Hydrant
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
ownedby
: 1
spatialsource
: 0
secondarydiameter
: 0
assettype
: 321
manufacturer
: 0
lifecyclestatus
: 8
maintby
: 1
spatialconfidence
: 0
Name: 6" Fire Hydrant
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
ownedby
: 1
spatialsource
: 0
secondarydiameter
: 0
assettype
: 321
manufacturer
: 0
lifecyclestatus
: 8
maintby
: 1
spatialconfidence
: 0
Relationships:
Fire Hydrant Maintenance Inspection (2) --
Related To
:
Hydrant Maintenance Inspection
(5010070)
Is Data Versioned:
false
Has Contingent Values:
false
Supports Rollback On Failure Parameter:
true
Last Edit Date:
4/7/2025 6:05:44 PM
Schema Last Edit Date:
3/24/2025 1:31:02 PM
Data Last Edit Date:
1/16/2025 6:35:23 PM
Tables:
Hydrant Maintenance Inspection
(5010070)
Name:
Hydrant Maintenance Inspection
Display Field:
pressure
Type:
Table
Is View:
true
Is Updatable View:
true
Source Schema Changes Allowed:
true
Description:
Copyright Text:
Max Record Count:
2000
Supported query Formats:
JSON, geoJSON, PBF
Use Standardized Queries:
True
HasZ:
false
HasM:
false
Has Attachments:
true
Has Geometry Properties:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Object ID Field:
OBJECTID
Unique ID Field:
Name : OBJECTID
IsSystemMaintained : True
Global ID Field:
globalid
Type ID Field:
Fields:
OBJECTID
(type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
maintstatus
(type: esriFieldTypeInteger, alias: Maintenance Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Submitted], [2: Acknowledged], [3: Planned], ... 3 more ...)
inspector
(type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
insdate
(type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
chains
(type: esriFieldTypeSmallInteger, alias: Are chains missing?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
paint
(type: esriFieldTypeSmallInteger, alias: Needs to be painted?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
marker
(type: esriFieldTypeSmallInteger, alias: Needs marker?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
oil
(type: esriFieldTypeSmallInteger, alias: Needs lubrication?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
greased
(type: esriFieldTypeSmallInteger, alias: Needs grease?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
drain
(type: esriFieldTypeSmallInteger, alias: Drains correctly?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
notes
(type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
pressure
(type: esriFieldTypeDouble, alias: Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
flowrate
(type: esriFieldTypeDouble, alias: Flow Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
flowduration
(type: esriFieldTypeDouble, alias: Flow Duration, SQL Type: sqlTypeOther, nullable: true, editable: true)
assetguid
(type: esriFieldTypeGUID, alias: Asset GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
globalid
(type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
creator
(type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
creationdate
(type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
updatedby
(type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
lastupdate
(type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
leaking
(type: esriFieldTypeInteger, alias: Is the hydrant leaking?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
operable
(type: esriFieldTypeInteger, alias: Is the hydrant operable?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
inspgroup
(type: esriFieldTypeString, alias: Inspection Group, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [0: Water Company], [1: Fire Department], [2: Contractor])
firestation
(type: esriFieldTypeString, alias: Station Completing Inspection, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [1: Station 1], [2: Station 2], [3: Station 3], ... 7 more ...)
totalused
(type: esriFieldTypeDouble, alias: Total Water Used, SQL Type: sqlTypeOther, nullable: true, editable: true)
inspectiontype
(type: esriFieldTypeInteger, alias: Inspection Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Flow Test], [2: Flush])
dischargecoe
(type: esriFieldTypeDouble, alias: Discharge Coefficient, SQL Type: sqlTypeOther, nullable: true, editable: true)
outletdiameter
(type: esriFieldTypeDouble, alias: Outlet Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
discharge
(type: esriFieldTypeDouble, alias: Available Fire Flow, SQL Type: sqlTypeOther, nullable: true, editable: true)
staticpressure
(type: esriFieldTypeDouble, alias: Static Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
residualpressure
(type: esriFieldTypeInteger, alias: Residual Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
flush
(type: esriFieldTypeInteger, alias: Flush, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
pitotpressure
(type: esriFieldTypeDouble, alias: Pitot Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: Hydrant Maintenance Inspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
Relationships:
Fire Hydrant (2) --
Related To
:
Fire Hydrant
(501007)
Is Data Versioned:
false
Has Contingent Values:
false
Supports Rollback On Failure Parameter:
true
Last Edit Date:
4/7/2025 6:05:44 PM
Schema Last Edit Date:
3/24/2025 1:31:02 PM
Data Last Edit Date:
1/16/2025 6:35:23 PM