Layers:

Layer: Assy Device (0)

Name: Assy Device

Display Field: Size

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1.3201209627125815E7
YMin: 685909.0947200358
XMax: 1.3245397031445503E7
YMax: 753411.9767730385
Spatial Reference: 2898  (2898)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: PassFail
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Pass
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [76, 230, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 2
  Label: Fail
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 0, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 3
  Label: Testing Due
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 0, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 0, 255] Width: 1
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Address ( type: esriFieldTypeString, alias: Address, length: 255 )
• AssyType ( type: esriFieldTypeSmallInteger, alias: Type , Coded Values: [1: RPZ] , [2: RPDA] , [3: PVB] , ...3 more... )
• SerialNo ( type: esriFieldTypeString, alias: Serial No, length: 255 )
• Size ( type: esriFieldTypeString, alias: Size, length: 255 , Coded Values: [0.5: 0.5 in] , [0.75: 0.75 in] , [1.00: 1.00 in] , ...11 more... )
• Make ( type: esriFieldTypeString, alias: Make, length: 255 , Coded Values: [Air Gap: Air Gap] , [Ames: Ames] , [Apollo: Apollo] , ...20 more... )
• Model ( type: esriFieldTypeString, alias: Model, length: 255 )
• AssyPurpose ( type: esriFieldTypeSmallInteger, alias: Purpose , Coded Values: [1: Mainline] , [2: Isolation] )
• BldgLocation ( type: esriFieldTypeString, alias: BldgLocation, length: 255 , Coded Values: [Basement: Basement] , [Boiler: Boiler] , [Boiler Room: Boiler Room] , ...8 more... )
• PassFail ( type: esriFieldTypeSmallInteger, alias: Pass / Fail , Coded Values: [1: Pass] , [2: Fail] , [3: Testing Due] )
• Tester ( type: esriFieldTypeString, alias: Tester, length: 255 )
• CertificationNo ( type: esriFieldTypeString, alias: CertificationNo, length: 255 )
• TestDate ( type: esriFieldTypeDate, alias: Test Date, length: 8 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 400 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Relationships:

• DBO.CCCPAccounts (0) -- Related To: CCCP Accounts (8)

Layer: CCCP Accounts (8)

Name: CCCP Accounts

Display Field: CCCPAddress

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

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

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1.3193937910482645E7
YMin: 658642.6090846956
XMax: 1.3271493765725598E7
YMax: 754673.9163047969
Spatial Reference: 2898  (2898)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: Status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Due
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [104, 104, 104, 127]
  Outline:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
• Value: 2
  Label: Pass
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [85, 255, 0, 127]
  Outline:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
• Value: 3
  Label: Pass - Missing Requirement
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 0, 197, 127]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 1
• Value: 4
  Label: Yellow Tag
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 255, 0, 127]
  Outline:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
• Value: 5
  Label: Appointment Scheduled
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 170, 0, 127]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 1
• Value: 6
  Label: Fail
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 0, 0, 127]
  Outline:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
• Value: 7
  Label: Fail -FTC
  Description: N/A
  Symbol:
  Style: esriSFSBackwardDiagonal
  Color: [255, 0, 0, 127]
  Outline:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
• Value: 8
  Label: Fail - Off at Road
  Description: N/A
  Symbol:
  Style: esriSFSBackwardDiagonal
  Color: [255, 0, 0, 127]
  Outline:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
• Value: 9
  Label: Pass- Off at Road
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [85, 255, 0, 153]
  Outline:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
• Value: 99
  Label: Not Due
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [207, 189, 252, 0]
  Outline:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
Transparency: 0
Labeling Info:
Label Placement: esriServerPolygonPlacementAlwaysHorizontal
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 1500.0
Max. Scale: 0.0

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


HasZ: true

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Status ( type: esriFieldTypeSmallInteger, alias: Status , Coded Values: [1: Due] , [2: Pass] , [3: Pass - Missing Requirement] , ...7 more... )
• StatusDate ( type: esriFieldTypeDate, alias: Status Updated On, length: 8 )
• Comments ( type: esriFieldTypeString, alias: Comments/Notes, length: 300 )
• OwnerBiz ( type: esriFieldTypeString, alias: Owner/Biz, length: 255 )
• CCCPAddress ( type: esriFieldTypeString, alias: CCCP Address, length: 255 )
• IR ( type: esriFieldTypeSmallInteger, alias: Irrigation Line , Coded Values: [0: No] , [1: Yes] )
• Freq ( type: esriFieldTypeSmallInteger, alias: Freq (yrs) , Coded Values: [1: 1] , [3: 3] , [10: 10] )
• HazardType ( type: esriFieldTypeSmallInteger, alias: Hazard Type , Coded Values: [1: Low] , [2: High] )
• Class ( type: esriFieldTypeSmallInteger, alias: Class , Coded Values: [1: Residential] , [2: Commercial] , [3: Non-CCCP Lot] , ...1 more... )
• RouteBook ( type: esriFieldTypeString, alias: Route Book, length: 255 , Coded Values: [0101: 0101] , [0102: 0102] , [0103: 0103] , ...25 more... )
• LetterDate ( type: esriFieldTypeDate, alias: LetterDate, length: 8 )
• MailingComments ( type: esriFieldTypeString, alias: Mailing Comments, length: 300 )
• MailingRecipient ( type: esriFieldTypeString, alias: Letter Recipient, length: 300 )
• MailingAddress ( type: esriFieldTypeString, alias: Letter Address, length: 255 )
• MailingCityStateZip ( type: esriFieldTypeString, alias: Letter State Zip, length: 255 )
• AccessAddress ( type: esriFieldTypeString, alias: Access Address, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• PCOMBINED ( type: esriFieldTypeString, alias: PCOMBINED, length: 255 )
• PSNUMBER ( type: esriFieldTypeDouble, alias: PSNUMBER )
• PDRESSDIR ( type: esriFieldTypeString, alias: PDRESSDIR, length: 255 )
• PSSSTREET ( type: esriFieldTypeString, alias: PSSSTREET, length: 255 )
• PDRESSZIP ( type: esriFieldTypeString, alias: PDRESSZIP, length: 255 )
• Tax_ID ( type: esriFieldTypeString, alias: Tax_ID, length: 255 )
• PRTYCLASS ( type: esriFieldTypeString, alias: PRTYCLASS, length: 255 )
• SIMPROVED ( type: esriFieldTypeDouble, alias: SIMPROVED )
• TCLEUNITS ( type: esriFieldTypeDouble, alias: TCLEUNITS )
• PTYSTATUS ( type: esriFieldTypeString, alias: PTYSTATUS, length: 255 )
• ParcelUpdated ( type: esriFieldTypeDate, alias: ParcelUpdated, length: 8 )

Relationships:

• DBO.CCCPInspection (1) -- Related To: Inspection Form (10)
• DBO.XCFound (2) -- Related To: XC Found Form (11)
• DBO.AssyDevice (0) -- Related To: Assy Device (0)

Tables:

Table: Inspection Form (10)

Name: Inspection Form

Display Field: InspectorName

Type: Table

Geometry Type: N/A

Description: null

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• OwnerContact ( type: esriFieldTypeString, alias: Owner / Contact, length: 255 )
• PhoneNo ( type: esriFieldTypeString, alias: Phone No, length: 255 )
• AddressLocation ( type: esriFieldTypeString, alias: Address, length: 255 )
• InspDate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• InspectorName ( type: esriFieldTypeString, alias: Inspector's Name, length: 255 )
• InspType ( type: esriFieldTypeSmallInteger, alias: Inspection Type , Coded Values: [1: Initial Inspection] , [2: Renewal Inspection] , [3: Re-Inspection] )
• CCCPClass ( type: esriFieldTypeSmallInteger, alias: Class , Coded Values: [1: Residential] , [2: Commercial] , [3: Non-CCCP Lot] , ...1 more... )
• HazardType ( type: esriFieldTypeSmallInteger, alias: Hazard Type , Coded Values: [1: Low] , [2: High] )
• HeatSource ( type: esriFieldTypeSmallInteger, alias: Heat Source , Coded Values: [1: Forced Air] , [2: Boiler (protected)] , [3: Boiler (unprotected)] , ...1 more... )
• Question1 ( type: esriFieldTypeSmallInteger, alias: Question 1: Is there any type of secondary water supply within the property? , Coded Values: [0: No] , [1: Yes] )
• Q1SurfaceWater ( type: esriFieldTypeSmallInteger, alias: Surface Water , Coded Values: [0: No] , [1: Yes] )
• Q1WellSupply ( type: esriFieldTypeSmallInteger, alias: Well supply , Coded Values: [0: No] , [1: Yes] )
• Q1StorageTank ( type: esriFieldTypeSmallInteger, alias: Storage tank , Coded Values: [0: No] , [1: Yes] )
• Q1Recirculated ( type: esriFieldTypeSmallInteger, alias: Recirculated , Coded Values: [0: No] , [1: Yes] )
• Q1Other ( type: esriFieldTypeSmallInteger, alias: Other, see comments , Coded Values: [0: No] , [1: Yes] )
• Question2 ( type: esriFieldTypeSmallInteger, alias: Question 2: Are there any cross connections by submerged inlet? , Coded Values: [0: No] , [1: Yes] )
• Q2Boiler ( type: esriFieldTypeSmallInteger, alias: Boilers , Coded Values: [0: No] , [1: Yes] )
• Q2Lab ( type: esriFieldTypeSmallInteger, alias: Laboratories , Coded Values: [0: No] , [1: Yes] )
• Q2Sprinkler ( type: esriFieldTypeSmallInteger, alias: Lawn sprinkling system , Coded Values: [0: No] , [1: Yes] )
• Q2Autopsy ( type: esriFieldTypeSmallInteger, alias: Autopsy / mortuary table , Coded Values: [0: No] , [1: Yes] )
• Q2Other ( type: esriFieldTypeSmallInteger, alias: Other, see comments , Coded Values: [0: No] , [1: Yes] )
• Question3 ( type: esriFieldTypeSmallInteger, alias: Question 3: Are there any cross connections with piping which may contain sanitary water or a waste or a chemical contaminate? , Coded Values: [0: No] , [1: Yes] )
• Q3FireProtection ( type: esriFieldTypeSmallInteger, alias: Piping for fire protection , Coded Values: [0: No] , [1: Yes] )
• Q3Softner ( type: esriFieldTypeSmallInteger, alias: Equipment drained to sewer-water softner , Coded Values: [0: No] , [1: Yes] )
• Q3Refrigeration ( type: esriFieldTypeSmallInteger, alias: Refrigeration system , Coded Values: [0: No] , [1: Yes] )
• Q3Other ( type: esriFieldTypeSmallInteger, alias: Other, see comments , Coded Values: [0: No] , [1: Yes] )
• Question4 ( type: esriFieldTypeSmallInteger, alias: Question 4: Are there any cross connections with piping immersed in a tank or vessel? , Coded Values: [0: No] , [1: Yes] )
• Q4ComLaundry ( type: esriFieldTypeSmallInteger, alias: Commerical laundry , Coded Values: [0: No] , [1: Yes] )
• Q4SteamLines ( type: esriFieldTypeSmallInteger, alias: Steam lines to keep storage tank from freezing , Coded Values: [0: No] , [1: Yes] )
• Q4Coils ( type: esriFieldTypeSmallInteger, alias: Coils within plating or rinse tanks , Coded Values: [0: No] , [1: Yes] )
• Q4Other ( type: esriFieldTypeSmallInteger, alias: Other, see comments , Coded Values: [0: No] , [1: Yes] )
• Question5 ( type: esriFieldTypeSmallInteger, alias: Question 5: Are any hoses connected to possible contaminates? , Coded Values: [1: No] , [2: Yes - Protected by an approved vacuum breaker] , [3: Yes - NOT protected] )
• Question6 ( type: esriFieldTypeSmallInteger, alias: Question 6: Is the potable water supply within the propert satisfactory? , Coded Values: [0: No] , [1: Yes] )
• AirGap ( type: esriFieldTypeSmallInteger, alias: Air Gaps , Coded Values: [0: No] , [1: Yes] )
• VacuumBr ( type: esriFieldTypeSmallInteger, alias: Vacuum Breakers , Coded Values: [0: No] , [1: Yes] )
• PressureVaccuumBr ( type: esriFieldTypeSmallInteger, alias: Pressure Vaccuum Breaker , Coded Values: [0: No] , [1: Yes] )
• DoubleCkValveAssy ( type: esriFieldTypeSmallInteger, alias: Double Check Valve Assy , Coded Values: [0: No] , [1: Yes] )
• VentedDouble_Ck ( type: esriFieldTypeSmallInteger, alias: Vented Double Check , Coded Values: [0: No] , [1: Yes] )
• RPZ ( type: esriFieldTypeSmallInteger, alias: RPZ , Coded Values: [0: No] , [1: Yes] )
• RPDA ( type: esriFieldTypeSmallInteger, alias: RPDA , Coded Values: [0: No] , [1: Yes] )
• Question8 ( type: esriFieldTypeSmallInteger, alias: Question 8: Any required protection? , Coded Values: [0: No] , [1: Yes] )
• ReqProtection ( type: esriFieldTypeString, alias: Required Protection:, length: 400 )
• InspFreq ( type: esriFieldTypeSmallInteger, alias: Inspection Frequency? , Coded Values: [1: 1] , [3: 3] , [10: 10] )
• MainLinContain ( type: esriFieldTypeSmallInteger, alias: Main Line Containment? , Coded Values: [0: No] , [1: Yes] )
• InspOutcome ( type: esriFieldTypeSmallInteger, alias: Inspection Outcome , Coded Values: [1: Approved] , [2: Failed] )
• HBVBTotal ( type: esriFieldTypeSmallInteger, alias: # HBVB Given , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...8 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 400 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Related_GlobalID ( type: esriFieldTypeGUID, alias: Related_GlobalID, length: 38 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Relationships:

• DBO.CCCPAccounts (1) -- Related To: CCCP Accounts (8)

Table: XC Found Form (11)

Name: XC Found Form

Display Field: AddressLocation

Type: Table

Geometry Type: N/A

Description: null

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• AddressLocation ( type: esriFieldTypeString, alias: Address, length: 255 )
• XCFoundDate ( type: esriFieldTypeDate, alias: XC Found Date, length: 8 )
• XCDescription ( type: esriFieldTypeString, alias: XC Description, length: 400 )
• XCStatus ( type: esriFieldTypeSmallInteger, alias: XC Status , Coded Values: [1: Existing] , [2: Resolved] )
• XCResolvedDate ( type: esriFieldTypeDate, alias: XC Resolved Date, length: 8 )
• XCComments ( type: esriFieldTypeString, alias: XC Comments, length: 400 )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Relationships:

• DBO.CCCPAccounts (2) -- Related To: CCCP Accounts (8)