Layers:

Layer: Valid Fire Flow Tests (0)

Name: Valid Fire Flow Tests

Display Field: RESIDUALID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: FIREFLOWDB.dbo.FireFlowLayer

Service Item Id: 3699c00440214400aae564d2f6b7276d

Copyright Text: LAYER>CREDITS

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:
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 )

Relationships:

• %ValidFlowTest2yrIncludesPrivate (0) -- Related To: ValidFlowTest2yrIncludesPrivate (3)

Layer: Fire Hydrants (2)

Name: Fire Hydrants

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3699c00440214400aae564d2f6b7276d

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: City of Durham/Pending City Acceptance; City of Durham (Partial Certification)
  Description: N/A
  Symbol:
  
• Value: DNC-PC
  Label: City of Durham/Pending City Acceptance; City of Durham (Partial Certification)
  Description: N/A
  Symbol:
  
• Value: PEND
  Label: City of Durham/Pending City Acceptance; City of Durham (Partial Certification)
  Description: N/A
  Symbol:
  
• Value: BUT
  Label: Private/Other Municipalities
  Description: N/A
  Symbol:
  
• Value: CARY
  Label: Private/Other Municipalities
  Description: N/A
  Symbol:
  
• Value: CHAT
  Label: Private/Other Municipalities
  Description: N/A
  Symbol:
  
• Value: CNTY
  Label: Private/Other Municipalities
  Description: N/A
  Symbol:
  
• Value: DUKE
  Label: Private/Other Municipalities
  Description: N/A
  Symbol:
  
• Value: HILLS
  Label: Private/Other Municipalities
  Description: N/A
  Symbol:
  
• Value: OWASA
  Label: Private/Other Municipalities
  Description: N/A
  Symbol:
  
• Value: PVT
  Label: Private/Other Municipalities
  Description: N/A
  Symbol:
  
• Value: RAL
  Label: Private/Other Municipalities
  Description: N/A
  Symbol:
  
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: ValidFlowTest2yrIncludesPrivate (3)

Name: ValidFlowTest2yrIncludesPrivate

Display Field: Case_Number

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3699c00440214400aae564d2f6b7276d

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 )
• Case_Number ( type: esriFieldTypeString, alias: Case_Number, length: 50 )
• Test_Number ( type: esriFieldTypeInteger, alias: Test_Number )
• TestDate ( type: esriFieldTypeString, alias: TestDate, length: 30 )
• Test_Time ( type: esriFieldTypeString, alias: Test_Time, length: 50 )
• Test_Type ( type: esriFieldTypeString, alias: Test_Type, length: 50 )
• Tested_By ( type: esriFieldTypeString, alias: Tested_By, length: 50 )
• Ports_Open ( type: esriFieldTypeString, alias: Ports_Open, length: 10 )
• Flow_HydrantID ( type: esriFieldTypeString, alias: Flow_HydrantID, length: 50 )
• Flow_Hydrant_Location ( type: esriFieldTypeString, alias: Flow_Hydrant_Location, length: 1073741823 )
• Residual_HydrantID ( type: esriFieldTypeString, alias: Residual_HydrantID, length: 50 )
• Residual_Hydrant_Location ( type: esriFieldTypeString, alias: Residual_Hydrant_Location, length: 1073741823 )
• Static_Pressure ( type: esriFieldTypeDouble, alias: Static_Pressure )
• Residual_Pressure ( type: esriFieldTypeDouble, alias: Residual_Pressure )
• Test_Comments ( type: esriFieldTypeString, alias: Test_Comments, length: 1073741822 )
• Calculated_Flow ( type: esriFieldTypeDouble, alias: Calculated_Flow )
• Q20 ( type: esriFieldTypeDouble, alias: Q20 )
• Parcel_ID ( type: esriFieldTypeString, alias: Parcel_ID, length: 50 )
• FLOWTESTDATE ( type: esriFieldTypeDate, alias: FLOWTESTDATE, length: 8 )

Relationships:

• FIREFLOWDB.FIREFLOWDBRO.%FireFlowLayer_1 (0) -- Related To: Valid Fire Flow Tests (0)