Layers:

Layer: Fire Flow Test (0)

Name: Fire Flow Test

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;font-size:12pt"><P><SPAN>Fire flow tests that have been conducted within the past two years. This layer is stored as a view in the FIREFLOW database and represents a join between the water system fire hydrant layer and the a of fire flow tests. The view is limited to tests that have been conducted within the past two years from the current date.</SPAN></P></DIV>

Service Item Id: 7367b77c7aab4f84bc5992aeb575a138

Copyright Text: Public Works GIS

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 2000664.57848306
YMin: 770939.4317381382
XMax: 2068473.4999515563
YMax: 863289.3448069841
Spatial Reference: 102719  (2264)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [168, 0, 0, 76]
Size: 24.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[168, 0, 0, 0] Width: 0
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• RESIDUALID ( type: esriFieldTypeString, alias: RESIDUALID, length: 50 )
• TestCount ( type: esriFieldTypeInteger, alias: TestCount )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 20 )
• LEGACYID ( type: esriFieldTypeString, alias: LEGACYID, length: 50 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 200 )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: CONDITIONDATE, length: 8 )
• CONDITIONSCORE ( type: esriFieldTypeInteger, alias: CONDITIONSCORE )
• RISKSCORE ( type: esriFieldTypeDouble, alias: RISKSCORE )
• ADMINISTRATIVEAREA ( type: esriFieldTypeString, alias: ADMINISTRATIVEAREA, length: 32 )
• OPERATIONALAREA ( type: esriFieldTypeString, alias: OPERATIONALAREA, length: 32 )
• DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, length: 50 )
• FMZ ( type: esriFieldTypeString, alias: FMZ, length: 50 )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LIFECYCLESTATUS, length: 20 )
• OWNER ( type: esriFieldTypeString, alias: OWNER, length: 50 )
• PROJECTID ( type: esriFieldTypeString, alias: PROJECTID, length: 10 )
• ASBUILTID ( type: esriFieldTypeString, alias: ASBUILTID, length: 18 )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, length: 8 )
• ACCEPTDATE ( type: esriFieldTypeDate, alias: ACCEPTDATE, length: 8 )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 32 )
• COMMENT ( type: esriFieldTypeString, alias: COMMENT, length: 200 )
• MAKE ( type: esriFieldTypeString, alias: MAKE, length: 30 )
• MODEL ( type: esriFieldTypeString, alias: MODEL, length: 30 )
• CASTINGYEAR ( type: esriFieldTypeString, alias: CASTINGYEAR, length: 4 )
• STORZ ( type: esriFieldTypeString, alias: STORZ, length: 50 )
• TAGSTATUS ( type: esriFieldTypeString, alias: TAGSTATUS, length: 25 )
• VERIFYDATE ( type: esriFieldTypeDate, alias: VERIFYDATE, length: 8 )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• ELEVATIONESTIMATE ( type: esriFieldTypeDouble, alias: ELEVATIONESTIMATE )
• ELEVATION ( type: esriFieldTypeDouble, alias: ELEVATION )
• CREATEDATE ( type: esriFieldTypeDate, alias: CREATEDATE, length: 8 )
• CREATEDBY ( type: esriFieldTypeString, alias: CREATEDBY, length: 16 )
• EDITDATE ( type: esriFieldTypeDate, alias: EDITDATE, length: 8 )
• EDITEDBY ( type: esriFieldTypeString, alias: EDITEDBY, length: 16 )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, length: 32 )
• SOURCECOMMENT ( type: esriFieldTypeString, alias: SOURCECOMMENT, length: 255 )
• SOURCEXYZ ( type: esriFieldTypeString, alias: SOURCEXYZ, length: 32 )
• SOURCEXYZDATE ( type: esriFieldTypeDate, alias: SOURCEXYZDATE, length: 8 )
• WATERTYPE ( type: esriFieldTypeString, alias: WATERTYPE, length: 32 )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED )
• WKT ( type: esriFieldTypeString, alias: WKT, length: 1073741822 )
• geom ( type: esriFieldTypeGeometry, alias: geom )

Layer: Fire Hydrant (2)

Name: Fire Hydrant

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 7367b77c7aab4f84bc5992aeb575a138

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1992901.5502138585
YMin: 763432.103344053
XMax: 2070395.1706814468
YMax: 880887.7570527643
Spatial Reference: 102719  (2264)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: OWNER
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: DNC
  Label: Public
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [168, 0, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [168, 0, 0, 255] Width: 0
• Value: DNC-PC
  Label: Public
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [168, 0, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [168, 0, 0, 255] Width: 0
• Value: PEND
  Label: Public
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [168, 0, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [168, 0, 0, 255] Width: 0
• Value: BUT
  Label: Private
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 77, 168, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 77, 168, 255] Width: 0
• Value: CARY
  Label: Private
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 77, 168, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 77, 168, 255] Width: 0
• Value: CHAT
  Label: Private
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 77, 168, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 77, 168, 255] Width: 0
• Value: CNTY
  Label: Private
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 77, 168, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 77, 168, 255] Width: 0
• Value: DUKE
  Label: Private
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 77, 168, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 77, 168, 255] Width: 0
• Value: HILLS
  Label: Private
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 77, 168, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 77, 168, 255] Width: 0
• Value: OWASA
  Label: Private
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 77, 168, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 77, 168, 255] Width: 0
• Value: PVT
  Label: Private
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 77, 168, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 77, 168, 255] Width: 0
• Value: RAL
  Label: Private
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 77, 168, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 77, 168, 255] Width: 0
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 20 )
• LEGACYID ( type: esriFieldTypeString, alias: Legacy ID, length: 50 )
• LOCATION ( type: esriFieldTypeString, alias: Location, length: 200 )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: Condition Date, length: 8 )
• CONDITIONSCORE ( type: esriFieldTypeInteger, alias: Condition Score )
• RISKSCORE ( type: esriFieldTypeDouble, alias: Risk Score )
• ADMINISTRATIVEAREA ( type: esriFieldTypeString, alias: Administrative Area, length: 32 , Coded Values: [Butner: Town of Butner] , [Cary: Town of Cary] , [Chatham: Chatham County] , ...7 more... )
• OPERATIONALAREA ( type: esriFieldTypeString, alias: Pressure Zone, length: 32 , Coded Values: [CHAT: Chatham County] , [HILL: Hillsborough] , [Oth: Other] , ...7 more... )
• DISTRICT ( type: esriFieldTypeString, alias: Fire District, length: 50 )
• FMZ ( type: esriFieldTypeString, alias: FMZ, length: 50 )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: Life Cycle Status, length: 20 , Coded Values: [Abandoned: Abandoned] , [Active: Active] , [Inactive: Inactive] , ...1 more... )
• OWNER ( type: esriFieldTypeString, alias: Owner, length: 50 , Coded Values: [BUT: Town of Butner] , [CARY: Town of Cary] , [CHAT: Chatham County] , ...9 more... )
• PROJECTID ( type: esriFieldTypeString, alias: Project ID, length: 10 )
• ASBUILTID ( type: esriFieldTypeString, alias: As-Built ID, length: 18 )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• ACCEPTDATE ( type: esriFieldTypeDate, alias: Accept Date, length: 8 )
• TYPE ( type: esriFieldTypeString, alias: Type, length: 32 , Coded Values: [STANDARD: Standard Hydrant] , [FLUSHING: Flushing Hydrant] , [BLOWOFF: Blow-Off Hydrant] )
• COMMENT ( type: esriFieldTypeString, alias: Comment, length: 200 )
• MAKE ( type: esriFieldTypeString, alias: Make, length: 30 , Coded Values: [AMDARLING: American Darling] , [AVK: AVK] , [CLOW: Clow] , ...6 more... )
• MODEL ( type: esriFieldTypeString, alias: Model, length: 30 )
• CASTINGYEAR ( type: esriFieldTypeString, alias: Casting Year, length: 4 )
• STORZ ( type: esriFieldTypeString, alias: STORZ Connection, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• TAGSTATUS ( type: esriFieldTypeString, alias: Tag Status, length: 25 )
• VERIFYDATE ( type: esriFieldTypeDate, alias: Verify Date, length: 8 )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• ELEVATIONESTIMATE ( type: esriFieldTypeDouble, alias: Elevation Estimate )
• ELEVATION ( type: esriFieldTypeDouble, alias: Elevation )
• CREATEDATE ( type: esriFieldTypeDate, alias: Create Date, length: 8 )
• CREATEDBY ( type: esriFieldTypeString, alias: Created By, length: 16 )
• EDITDATE ( type: esriFieldTypeDate, alias: Edit Date, length: 8 )
• EDITEDBY ( type: esriFieldTypeString, alias: Edited By, length: 16 )
• SOURCE ( type: esriFieldTypeString, alias: Source, length: 32 , Coded Values: [ASBUILT: As-Built Plan] , [CCTV: CCTV] , [CONSTRUCTION: Construction Plan] , ...5 more... )
• SOURCECOMMENT ( type: esriFieldTypeString, alias: Source Comment, length: 255 )
• SOURCEXYZ ( type: esriFieldTypeString, alias: Source XYZ, length: 32 , Coded Values: [DIGITAL SUBMITTAL: Digital Submittal] , [GPS-NAD83(CORS)/NAVD88: GPS-NAD83(CORS)/NAVD88] , [GPS-NAD83(2011)/NAVD88(GEOID09): GPS-NAD83(2011)/NAVD88(GEOID09)] )
• SOURCEXYZDATE ( type: esriFieldTypeDate, alias: Source XYZ Date, length: 8 )
• WATERTYPE ( type: esriFieldTypeString, alias: Water Type, length: 32 , Coded Values: [Combined: Combined Waste Water] , [Potable: Potable Water] , [Raw: Raw Water] , ...1 more... )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: Global ID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• DIAMETER ( type: esriFieldTypeSingle, alias: DIAMETER , Coded Values: [2.125: 2 1/8"] , [4: 4"] , [4.25: 4 1/4"] , ...6 more... )

Tables:

Table: ValidFlowTest2yrIncludesPrivate2 (3)

Name: ValidFlowTest2yrIncludesPrivate2

Display Field: CaseNumber

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 7367b77c7aab4f84bc5992aeb575a138

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• ID ( type: esriFieldTypeOID, alias: ID )
• CaseNumber ( type: esriFieldTypeString, alias: CaseNumber, length: 50 )
• TestNumber ( type: esriFieldTypeInteger, alias: TestNumber )
• TestDate ( type: esriFieldTypeString, alias: TestDate, length: 30 )
• FlowTestTime ( type: esriFieldTypeString, alias: FlowTestTime, length: 50 )
• TestType ( type: esriFieldTypeString, alias: TestType, length: 50 )
• TestedBy ( type: esriFieldTypeString, alias: TestedBy, length: 50 )
• FlowHydrantId ( type: esriFieldTypeString, alias: FlowHydrantId, length: 50 )
• FlowLocation ( type: esriFieldTypeString, alias: FlowLocation, length: 1073741823 )
• PressureHydrantID ( type: esriFieldTypeString, alias: PressureHydrantID, length: 50 )
• PressureLocation ( type: esriFieldTypeString, alias: PressureLocation, length: 1073741823 )
• FlowHydrantElevation ( type: esriFieldTypeDouble, alias: FlowHydrantElevation )
• ResidualHydrantElevation ( type: esriFieldTypeDouble, alias: ResidualHydrantElevation )
• NozzleDiameter ( type: esriFieldTypeDouble, alias: NozzleDiameter )
• PortsOpen ( type: esriFieldTypeString, alias: PortsOpen, length: 10 )
• CoefficientOfDischarge ( type: esriFieldTypeDouble, alias: CoefficientOfDischarge )
• StaticPressure ( type: esriFieldTypeDouble, alias: StaticPressure )
• ResidualPressure ( type: esriFieldTypeDouble, alias: ResidualPressure )
• DiffuserPitotReading ( type: esriFieldTypeDouble, alias: DiffuserPitotReading )
• CalculatedFlow ( type: esriFieldTypeDouble, alias: CalculatedFlow )
• Test_Comments ( type: esriFieldTypeString, alias: Test_Comments, length: 1073741822 )