Layers:

Layer: Water Backflows (0)

Name: Water Backflows

Display Field: ACCT_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: af4e1f063bae44108f75dbb94e1fef5f

Copyright Text:

Default Visibility: true

MaxRecordCount: 4000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.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: 2049362.84821239
YMin: 668369.648361132
XMax: 2218264.8922974
YMax: 825496.6989357921
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: DEVICE_TYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: Unknown
UniqueValueInfos:
• Value: DC
  Label: Double Check
  Description: N/A
  Symbol:
  
• Value: DCDA
  Label: Double Check Detector Assembly
  Description: N/A
  Symbol:
  
• Value: DCDA-II
  Label: Double Check Detector Assembly - II
  Description: N/A
  Symbol:
  
• Value: PVB
  Label: Pressure Vacuum Breaker
  Description: N/A
  Symbol:
  
• Value: RP
  Label: Reduced Pressure
  Description: N/A
  Symbol:
  
• Value: RPDA
  Label: Reduced Pressure Detector Assembly
  Description: N/A
  Symbol:
  
• Value: RPDA-II
  Label: Reduced Pressure Detector Assembly - II
  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
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SP_ID ( type: esriFieldTypeString, alias: SP_ID, length: 20 )
• PREM_ID ( type: esriFieldTypeString, alias: PREM_ID, length: 20 )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 20 )
• BF_SERIAL ( type: esriFieldTypeString, alias: Backflow Serial Number, length: 50 )
• COMPBKFL ( type: esriFieldTypeString, alias: Backflow Compliance Status, length: 50 , Coded Values: [FAIL: Fail] , [PASS: Pass] )
• COMPDATE ( type: esriFieldTypeDate, alias: Backflow Compliance Date, length: 8 )
• COMP_EXT ( type: esriFieldTypeDate, alias: Backflow Compliance Extension Date, length: 8 )
• BF_LOC ( type: esriFieldTypeString, alias: Backflow Location, length: 254 )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• MODEL ( type: esriFieldTypeString, alias: Device Model, length: 50 )
• DEVICE_SIZE ( type: esriFieldTypeString, alias: Device Size, length: 50 )
• DEVICE_TYPE ( type: esriFieldTypeString, alias: Device Type, length: 50 )
• LAST_TEST_DATE ( type: esriFieldTypeDate, alias: Last Test Date, length: 8 )
• TEST_ENTERED_ON ( type: esriFieldTypeString, alias: Test Entered On, length: 50 )
• LAST_TEST_PASS_FAIL ( type: esriFieldTypeString, alias: Last Test Pass/Fail, length: 50 , Coded Values: [FAIL: Fail] , [PASS: Pass] )
• FACILITY_TYPE ( type: esriFieldTypeString, alias: Facility Type, length: 50 )
• COMP_EXT_APP_DATE ( type: esriFieldTypeString, alias: Exemption Approval Date, length: 50 )
• BFA_REQ ( type: esriFieldTypeString, alias: BFA Required, length: 50 )
• EXTENSION ( type: esriFieldTypeString, alias: Extension, length: 50 )
• SITE_SURVEY ( type: esriFieldTypeString, alias: Site Survey Performed, length: 50 )
• SITE_SURVEY_DATE ( type: esriFieldTypeDate, alias: Last Survey Date, length: 8 )
• PROP_SURVEY ( type: esriFieldTypeString, alias: Property Survey Received, length: 50 )
• PROP_SURVEY_DATE ( type: esriFieldTypeDate, alias: Property Survey Received Date, length: 8 )
• CONTACT_EMAIL ( type: esriFieldTypeString, alias: Contact Email, length: 100 )
• CONTACT_PHONE ( type: esriFieldTypeString, alias: Contact Phone, length: 20 )
• DAYS_COMP ( type: esriFieldTypeString, alias: Days Since Compliant, length: 50 )
• OA_PWISD ( type: esriFieldTypeString, alias: Organization Account PWISD, length: 50 )
• OA_RSG ( type: esriFieldTypeString, alias: Organization Account RSG, length: 50 )
• CCN ( type: esriFieldTypeString, alias: CCN, length: 50 )
• USEAGE_CLASS ( type: esriFieldTypeString, alias: Usage Class, length: 16 )
• USEAGE_CLASS_DESCRIPTION ( type: esriFieldTypeString, alias: Usage Class Description, length: 60 )
• COMPTIER ( type: esriFieldTypeString, alias: Hazard Tier, length: 16 , Coded Values: [T1: High severity HAZ potential determined by Wake County Type] , [T1G: Govt hazard potential determined by Wake County Type] , [T2M: Metered Irrigation determined] , ...12 more... )
• COMPHZRD ( type: esriFieldTypeString, alias: Backflow Hazard Severity, length: 16 , Coded Values: [RESIDENTIAL: Residential] , [MODERATE: Moderate] , [SEVERE: Severe] , ...1 more... )
• COMPOWNR ( type: esriFieldTypeString, alias: Backflow Owner Type, length: 256 )
• COMP_EXP ( type: esriFieldTypeString, alias: Backflow Approved Exemption, length: 256 )
• ACCT_ID ( type: esriFieldTypeString, alias: Account ID, length: 10 )
• ACCT_EMAIL ( type: esriFieldTypeString, alias: Account Email, length: 254 )
• ACCT_PHONE ( type: esriFieldTypeString, alias: Account Phone, length: 50 )
• ACCT_NAME ( type: esriFieldTypeString, alias: Account Name, length: 254 )
• ACCT_ADDRESS ( type: esriFieldTypeString, alias: Account Address, length: 254 )
• ACCT_ADDRESS_2 ( type: esriFieldTypeString, alias: Account Address 2, length: 254 )
• ACCT_CITY ( type: esriFieldTypeString, alias: Account City, length: 90 )
• ACCT_STATE ( type: esriFieldTypeString, alias: Account State, length: 90 )
• ACCT_ZIP ( type: esriFieldTypeString, alias: Account Zip Code, length: 12 )
• OWN_ACCT_ID ( type: esriFieldTypeString, alias: Owner Account ID, length: 10 )
• OWN_EMAIL ( type: esriFieldTypeString, alias: Owner Email, length: 254 )
• OWN_PHONE ( type: esriFieldTypeString, alias: Owner Phone, length: 50 )
• OWN_NAME ( type: esriFieldTypeString, alias: Owner Name, length: 254 )
• OWN_ADDRESS ( type: esriFieldTypeString, alias: Owner Address, length: 254 )
• OWN_ADDRESS_2 ( type: esriFieldTypeString, alias: Owner Address 2, length: 254 )
• OWN_CITY ( type: esriFieldTypeString, alias: Owner City, length: 90 )
• OWN_STATE ( type: esriFieldTypeString, alias: Owner State, length: 90 )
• OWN_ZIP ( type: esriFieldTypeString, alias: Owner Zip Code, length: 12 )
• EDITEDBY ( type: esriFieldTypeString, alias: Edited By, length: 256 )
• EDITEDON ( type: esriFieldTypeDate, alias: Edited On, length: 8 )
• CREATEDBY ( type: esriFieldTypeString, alias: Created By, length: 256 )
• CREATEDON ( type: esriFieldTypeDate, alias: Created On, length: 8 )
• ADDR1 ( type: esriFieldTypeString, alias: ADDR1, length: 254 )
• ADDR2 ( type: esriFieldTypeString, alias: ADDR2, length: 254 )
• ADDR3 ( type: esriFieldTypeString, alias: ADDR3, length: 254 )
• REID ( type: esriFieldTypeString, alias: REID, length: 20 )
• SITE_ADDRESS ( type: esriFieldTypeString, alias: SITE_ADDRESS, length: 254 )
• CCB_SERVICE_ADDRESS ( type: esriFieldTypeString, alias: CCB Service Address, length: 255 )
• BACKFLOW_COMPLIANCE_STATUS ( type: esriFieldTypeString, alias: Backflow Compliance Status, length: 50 , Coded Values: [NON-SURVEYED: Non-Surveyed] , [COMPLIANT: Compliant property] , [NON-COMP_TESTNOV: Non-Compliant Testing NOV] , ...5 more... )
• BACKFLOW_COMPLIANCE_HIERARCHY ( type: esriFieldTypeSmallInteger, alias: BACKFLOW_COMPLIANCE_HIERARCHY )
• LAST_PASS_TEST_DATE ( type: esriFieldTypeDate, alias: Last Passing Test Date, length: 8 )
• NEXT_DEVICE_DUE_DATE ( type: esriFieldTypeDate, alias: Next Device Due Date, length: 8 )
• INSTALLATION_DUE_DATE ( type: esriFieldTypeDate, alias: Installation Due Date, length: 8 )
• INSTALL_DAYS_OUT_OF_COMPLIANCE ( type: esriFieldTypeSmallInteger, alias: Installation Days Out of Compliance )
• VALIDITY_PERIOD ( type: esriFieldTypeSmallInteger, alias: Testing Validity Period )
• ACCEPTANCE_OPEN ( type: esriFieldTypeSmallInteger, alias: Acceptance Open )
• ACCEPTANCE_CLOSE ( type: esriFieldTypeSmallInteger, alias: Acceptance Close )
• COMP_LETTER_OWNER ( type: esriFieldTypeString, alias: COMP_LETTER_OWNER, length: 255 )
• PIN ( type: esriFieldTypeString, alias: PIN, length: 10 )
• RID ( type: esriFieldTypeString, alias: RID, length: 10 )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active , Coded Values: [1: Active] , [2: Inactive] , [3: Abandoned] , ...2 more... )
• GOVERNMENT ( type: esriFieldTypeString, alias: Government, length: 20 )
• FREEZE_ADDRESS ( type: esriFieldTypeString, alias: FREEZE_ADDRESS, length: 255 )
• ORGANIZATION_ACCOUNT_NUMBER ( type: esriFieldTypeString, alias: Organization Account Number, length: 255 )
• CCB_UPDATE ( type: esriFieldTypeDate, alias: CCB Update, length: 8 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• O_VALUE ( type: esriFieldTypeString, alias: O_VALUE, length: 1073741822 )
• ADDRESS ( type: esriFieldTypeString, alias: Address, length: 256 )
• CITY ( type: esriFieldTypeString, alias: City, length: 90 )
• STATE ( type: esriFieldTypeString, alias: State, length: 6 )
• ZIP ( type: esriFieldTypeString, alias: Zipcode, length: 16 )
• BACKFLOW ( type: esriFieldTypeString, alias: Backflow Status, length: 16 , Coded Values: [NON-SURVEYED: Non-Surveyed] , [COMPLIANT: Compliant property] , [NON-COMP_TESTNOV: Non-Compliant Testing NOV] , ...5 more... )
• COMPTYPE ( type: esriFieldTypeString, alias: Backflow Compliance Type, length: 16 , Coded Values: [DOMESTIC: Domestic Service] , [DOMESTIC IRRIG: Irrigation Service on Domestic Meter] , [FIRE: Fire Service] , ...7 more... )
• METER ( type: esriFieldTypeString, alias: Meter, length: 16 )
• METER_SIZE ( type: esriFieldTypeString, alias: Meter Size, length: 512 )
• VCC_NUMBER ( type: esriFieldTypeString, alias: VCC Number, length: 20 )
• WATER_UTILITY ( type: esriFieldTypeString, alias: Water Utility, length: 20 )
• VEPO_UPDATE ( type: esriFieldTypeDate, alias: VEPO Update, length: 8 )
• VEPO_VALUE ( type: esriFieldTypeString, alias: VEPO Value, length: 1073741822 )
• VEPO_ID ( type: esriFieldTypeInteger, alias: VEPO ID )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )

Layer: FOG Interceptors (1)

Name: FOG Interceptors

Display Field: FACILITY_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: af4e1f063bae44108f75dbb94e1fef5f

Copyright Text:

Default Visibility: true

MaxRecordCount: 4000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.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: 2054883.06354989
YMin: 674616.607323885
XMax: 2217668.26488173
YMax: 821559.32459271
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: FOG Interceptors
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
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, length: 20 )
• EST_TYPE ( type: esriFieldTypeString, alias: Facility Type, length: 10 , Coded Values: [FSE: Food Service Establishment] , [VMF: Vehicle Maintenance Facility] , [UNK: Unknown] )
• FACILITY_NAME ( type: esriFieldTypeString, alias: Facility Name, length: 255 )
• HAZARD_LEVEL ( type: esriFieldTypeDouble, alias: Hazard Level , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...2 more... )
• DEVICE_TYPE ( type: esriFieldTypeString, alias: Device Type, length: 20 , Coded Values: [GGI: GGI] , [HGI: HGI] , [OWS: OWS] , ...2 more... )
• CREATEDBY ( type: esriFieldTypeString, alias: CREATEDBY, length: 256 )
• CREATEDON ( type: esriFieldTypeDate, alias: CREATEDON, length: 8 )
• EDITEDBY ( type: esriFieldTypeString, alias: EDITEDBY, length: 256 )
• EDITEDON ( type: esriFieldTypeDate, alias: EDITEDON, length: 8 )
• PREVIOUS_HAZARD_LEVEL ( type: esriFieldTypeSmallInteger, alias: Previous Hazard Level , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...2 more... )
• HAZARD_LEVEL_CHANGE_DATE ( type: esriFieldTypeDate, alias: Hazard Level Change Date, length: 8 )
• HAZARD_LEVEL_CHANGE_REASON ( type: esriFieldTypeString, alias: Hazard Level Change Reason, length: 50 , Coded Values: [Non-Compliance History: Non-Compliance History] , [Improved Compliance History: Improved Compliance History] , [Interceptor Condition: Interceptor Condition] , ...4 more... )
• LOCATION_ADDRESS ( type: esriFieldTypeString, alias: Location Address, length: 255 )
• LOCATION_CITY ( type: esriFieldTypeString, alias: Location City, length: 25 )
• LOCATION_ZIP ( type: esriFieldTypeString, alias: LOCATION_ZIP, length: 10 )
• APPROVAL_COMMENTS ( type: esriFieldTypeString, alias: Approval Comments, length: 1073741822 )
• ACTIVE_DATE ( type: esriFieldTypeDate, alias: Active Date, length: 8 )
• REGISTERED_AGENT ( type: esriFieldTypeString, alias: Registered Agent, length: 50 )
• INTER_TYPE ( type: esriFieldTypeString, alias: Interceptor Type, length: 50 )
• INTER_USE ( type: esriFieldTypeString, alias: Interceptor Use, length: 50 , Coded Values: [Single Use: Single Use] , [Community: Community] )
• INTER_COUNT ( type: esriFieldTypeSmallInteger, alias: Interceptor Count )
• INTER_LOCATION ( type: esriFieldTypeString, alias: Interceptor Location, length: 7 )
• INTER_LOCATION_DES ( type: esriFieldTypeString, alias: Interceptor Location Description, length: 255 )
• INTER_LID_COUNT ( type: esriFieldTypeSmallInteger, alias: Interceptor Lid Count )
• INTER_GALLONS ( type: esriFieldTypeInteger, alias: Interceptor Gallons )
• INTER_STATUS ( type: esriFieldTypeSmallInteger, alias: Interceptor Status )
• INTER_COMMENTS ( type: esriFieldTypeString, alias: Interceptor Comments, length: 1200 )
• INTER_MAKE ( type: esriFieldTypeString, alias: Interceptor Make, length: 50 )
• INTER_MODEL ( type: esriFieldTypeString, alias: Interceptor Model, length: 50 )
• ACCOUNT_STATUS ( type: esriFieldTypeSmallInteger, alias: Account Status )
• PREM_ID ( type: esriFieldTypeString, alias: PREM_ID, length: 20 )
• ESTABUPD ( type: esriFieldTypeString, alias: Establisments Updated, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [NYC: Not Yet Constructed] )
• FOG_UNIT ( type: esriFieldTypeDouble, alias: Number of Establishments )
• SP_ID ( type: esriFieldTypeString, alias: SP_ID, length: 20 )
• FOG_ZONE ( type: esriFieldTypeDouble, alias: FOG_ZONE , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: ACTIVEFLAG , Coded Values: [0: Related] , [1: Active] , [2: Inactive] , ...3 more... )
• PIN_NUM ( type: esriFieldTypeString, alias: PIN_NUM, length: 11 )
• REID ( type: esriFieldTypeString, alias: REID, length: 20 )
• STNAME ( type: esriFieldTypeString, alias: STNAME, length: 25 )
• STYPE ( type: esriFieldTypeString, alias: STYPE, length: 4 )
• STPRE ( type: esriFieldTypeString, alias: STPRE, length: 2 )
• STSUF ( type: esriFieldTypeString, alias: STSUF, length: 2 )
• STNUM ( type: esriFieldTypeInteger, alias: STNUM )
• STMISC ( type: esriFieldTypeString, alias: STMISC, length: 6 )
• SITE_ADDRESS ( type: esriFieldTypeString, alias: SITE_ADDRESS, length: 77 )
• FULL_STREET_NAME ( type: esriFieldTypeString, alias: FULL_STREET_NAME, length: 36 )
• CITY ( type: esriFieldTypeString, alias: CITY, length: 50 )
• TOWNSHIP ( type: esriFieldTypeString, alias: TOWNSHIP, length: 50 )
• SITE ( type: esriFieldTypeSmallInteger, alias: SITE )
• ZIPCODE ( type: esriFieldTypeString, alias: ZIPCODE, length: 5 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )

Relationships:

• RPUD.ssFOGEstablishments (0) -- Related To: FOG Establishments (3)

Layer: Water Service Connections (2)

Name: Water Service Connections

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: af4e1f063bae44108f75dbb94e1fef5f

Copyright Text:

Default Visibility: true

MaxRecordCount: 4000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.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: 2049362.84821239
YMin: 668369.648361132
XMax: 2222584.72486506
YMax: 825820.47551921
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: Water Service Connections
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
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 20 )
• SP_ID ( type: esriFieldTypeString, alias: SP_ID, length: 20 )
• CSA_ID ( type: esriFieldTypeString, alias: CSA_ID, length: 15 )
• PREM_ID ( type: esriFieldTypeString, alias: PREM_ID, length: 20 )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag , Coded Values: [1: Active] , [2: Inactive] , [3: Abandoned] , ...2 more... )
• CRITICAL ( type: esriFieldTypeString, alias: Critical, length: 256 , Coded Values: [YES: YES] , [NO: NO] )
• CITY_LIMITS ( type: esriFieldTypeString, alias: City Limits, length: 16 )
• ADDRESS ( type: esriFieldTypeString, alias: Address, length: 256 )
• CITY ( type: esriFieldTypeString, alias: City, length: 90 )
• STATE ( type: esriFieldTypeString, alias: State, length: 6 )
• ZIP ( type: esriFieldTypeString, alias: Zip Code, length: 12 )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, length: 1073741822 )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• METER ( type: esriFieldTypeString, alias: Meter, length: 16 )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• STATUS ( type: esriFieldTypeString, alias: Status, length: 60 )
• PRESSUREZONE ( type: esriFieldTypeSmallInteger, alias: Pressure Zone )
• PRESSURE_SUBZONE ( type: esriFieldTypeString, alias: Sub-Pressure Zone, length: 5 )
• CONFINED ( type: esriFieldTypeString, alias: Confined, length: 25 , Coded Values: [CONFINED: Confined] , [NOT_CONFINED: Not Confined] )
• INSIDE_NEW ( type: esriFieldTypeString, alias: Inside New, length: 20 )
• BOXTYPE ( type: esriFieldTypeString, alias: Box Type, length: 256 , Coded Values: [STD: Standard] , [COFFIN: Coffin] , [CAST: Cast Iron] , ...2 more... )
• SERVICEMATERIAL ( type: esriFieldTypeString, alias: Service Material, length: 5 , Coded Values: [CU: Copper] , [GAL: Galvanized] , [HDPE: HDPE] , ...2 more... )
• SP_CODE ( type: esriFieldTypeString, alias: SP Code, length: 8 )
• SP_TYPE_DESCRIPTION ( type: esriFieldTypeString, alias: SP Type Description, length: 60 )
• SP_SIZE ( type: esriFieldTypeString, alias: SP Size, length: 16 )
• SP_SIZE_DESCRIPTION ( type: esriFieldTypeString, alias: SP Size Description, length: 60 )
• UOM ( type: esriFieldTypeString, alias: UOM, length: 30 )
• METER_CONFIG ( type: esriFieldTypeString, alias: Meter Configuration, length: 12 )
• USEAGE_CLASS ( type: esriFieldTypeString, alias: Usage Class, length: 16 )
• USEAGE_CLASS_DESCRIPTION ( type: esriFieldTypeString, alias: Usage Class Description, length: 60 )
• SERVICE_CYCLE ( type: esriFieldTypeString, alias: Service Cycle, length: 16 )
• ROUTE ( type: esriFieldTypeString, alias: Route, length: 16 )
• ROUTE_SEQ ( type: esriFieldTypeString, alias: Route Sequence, length: 8 )
• SP_CREATED ( type: esriFieldTypeDate, alias: SP Created, length: 8 )
• X_LONGITUDE ( type: esriFieldTypeDouble, alias: X Longitude )
• Y_LATITUDE ( type: esriFieldTypeDouble, alias: Y Latitude )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By )
• MAINTAINEDBY ( type: esriFieldTypeSmallInteger, alias: Maintained By )
• NOTES ( type: esriFieldTypeString, alias: Notes, length: 250 )
• EDITEDBY ( type: esriFieldTypeString, alias: Edited By, length: 256 )
• EDITEDON ( type: esriFieldTypeDate, alias: Edited On, length: 8 )
• CREATEDBY ( type: esriFieldTypeString, alias: Created By, length: 256 )
• CREATEDON ( type: esriFieldTypeDate, alias: Created On, length: 8 )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude )
• ESRIGNSS_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, length: 50 )
• ESRIGNSS_FIXDATETIME ( type: esriFieldTypeDate, alias: Fix Time, length: 8 )
• ESRIGNSS_AVG_POSITIONS ( type: esriFieldTypeSmallInteger, alias: Averaged Positions )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude )
• ESRIGNSS_PDOP ( type: esriFieldTypeDouble, alias: PDOP )
• ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m) )
• ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m) )
• ESRIGNSS_CORRECTIONAGE ( type: esriFieldTypeDouble, alias: Correction Age )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude )
• ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type )
• ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m) )
• ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m) )
• ESRIGNSS_STATIONID ( type: esriFieldTypeSmallInteger, alias: Station ID )
• ESRIGNSS_HDOP ( type: esriFieldTypeDouble, alias: HDOP )
• ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Number of Satellites )
• ESRIGNSS_VDOP ( type: esriFieldTypeDouble, alias: VDOP )
• ESRIGNSS_H_STDDEV ( type: esriFieldTypeDouble, alias: Standard Deviation (m) )
• L_ID ( type: esriFieldTypeString, alias: Location ID, length: 20 )
• RESETTER ( type: esriFieldTypeString, alias: Resetter, length: 20 , Coded Values: [None: None] , [AYM: AYM] , [Ford: Ford] , ...3 more... )
• COPPERSETTER ( type: esriFieldTypeString, alias: Copper Setter, length: 20 , Coded Values: [None: None] , [AYM: AYM] , [Ford: Ford] , ...3 more... )
• MAST_MTR ( type: esriFieldTypeString, alias: MAST_MTR, length: 256 , Coded Values: [YES: The SP is master metered] , [NO: The SP is not master metered] )
• COMP_FAC ( type: esriFieldTypeString, alias: COMP_FAC, length: 16 , Coded Values: [COMPLIANT: Compliant] , [NOT_COMPLIANT: Not Compliant] )
• BACKFLOW ( type: esriFieldTypeString, alias: Backflow Status, length: 16 , Coded Values: [NON-SURVEYED: Non-Surveyed] , [COMPLIANT: Compliant property] , [NON-COMP_TESTNOV: Non-Compliant Testing NOV] , ...5 more... )
• COMPTYPE ( type: esriFieldTypeString, alias: COMPTYPE, length: 16 , Coded Values: [DOMESTIC: Domestic Service] , [DOMESTIC IRRIG: Irrigation Service on Domestic Meter] , [FIRE: Fire Service] , ...7 more... )
• COMPTIER ( type: esriFieldTypeString, alias: COMPTIER, length: 16 )
• COMPHZRD ( type: esriFieldTypeString, alias: COMPHZRD, length: 16 )
• COMPOWNR ( type: esriFieldTypeString, alias: COMPOWNR, length: 256 )
• COMP_EXP ( type: esriFieldTypeString, alias: COMP_EXP, length: 256 )
• ACCT_ID ( type: esriFieldTypeString, alias: ACCT_ID, length: 10 )
• ACCT_EMAIL ( type: esriFieldTypeString, alias: ACCT_EMAIL, length: 254 )
• ACCT_PHONE ( type: esriFieldTypeString, alias: ACCT_PHONE, length: 50 )
• ACCT_NAME ( type: esriFieldTypeString, alias: ACCT_NAME, length: 254 )
• ACCT_ADDRESS ( type: esriFieldTypeString, alias: ACCT_ADDRESS, length: 254 )
• ACCT_ADDRESS_2 ( type: esriFieldTypeString, alias: ACCT_ADDRESS_2, length: 254 )
• ACCT_CITY ( type: esriFieldTypeString, alias: ACCT_CITY, length: 90 )
• ACCT_STATE ( type: esriFieldTypeString, alias: ACCT_STATE, length: 90 )
• OWN_ACCT_ID ( type: esriFieldTypeString, alias: OWN_ACCT_ID, length: 10 )
• OWN_EMAIL ( type: esriFieldTypeString, alias: OWN_EMAIL, length: 254 )
• OWN_PHONE ( type: esriFieldTypeString, alias: OWN_PHONE, length: 50 )
• OWN_NAME ( type: esriFieldTypeString, alias: OWN_NAME, length: 254 )
• OWN_ADDRESS ( type: esriFieldTypeString, alias: OWN_ADDRESS, length: 254 )
• OWN_ADDRESS_2 ( type: esriFieldTypeString, alias: OWN_ADDRESS_2, length: 254 )
• OWN_CITY ( type: esriFieldTypeString, alias: OWN_CITY, length: 90 )
• OWN_STATE ( type: esriFieldTypeString, alias: OWN_STATE, length: 90 )
• OWN_ZIP ( type: esriFieldTypeString, alias: OWN_ZIP, length: 12 )
• METERSIZ ( type: esriFieldTypeString, alias: METERSIZ, length: 60 )
• SP_SRC_STATUS_FLG ( type: esriFieldTypeString, alias: SP_SRC_STATUS_FLG, length: 60 )
• METER_SIZE ( type: esriFieldTypeString, alias: METER_SIZE, length: 512 )
• ACCT_ZIP ( type: esriFieldTypeString, alias: ACCT_ZIP, length: 12 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• CCB_UPDATE ( type: esriFieldTypeDate, alias: CCB Update, length: 8 )
• O_VALUE ( type: esriFieldTypeString, alias: O_VALUE, length: 1073741822 )
• CUSTOMERMATERIAL ( type: esriFieldTypeString, alias: Customer Material, length: 5 , Coded Values: [CU: Copper] , [GAL: Galvanized] , [PLA: Plastic] , ...5 more... )
• DUALCHECK ( type: esriFieldTypeString, alias: Dual Check, length: 50 , Coded Values: [Unknown: Unknown] , [None: None] , [Ford: Ford] , ...2 more... )
• ACCT_TEMP_EXPT_ID ( type: esriFieldTypeString, alias: Account Temp Exempt ID, length: 10 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• ALT_CSA_ID ( type: esriFieldTypeString, alias: ALT_CSA_ID, length: 15 )

Tables:

Table: FOG Establishments (3)

Name: FOG Establishments

Display Field: ESTABLISHMENT_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: af4e1f063bae44108f75dbb94e1fef5f

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 4000

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, length: 25 )
• ESTABLISHMENT_NAME ( type: esriFieldTypeString, alias: Establishment Name, length: 255 )
• ESTABLISHMENT_TYPE ( type: esriFieldTypeString, alias: Establishment Type, length: 100 , Coded Values: [FSE: Food Service Establishment] , [VMF: Vehicle Maintenance Facility] , [UNK: Unknown] )
• ESTABLISHMENT_ADDRESS ( type: esriFieldTypeString, alias: Establishment Address, length: 100 )
• CLASSIFICATION_TYPE ( type: esriFieldTypeString, alias: Classification Type, length: 50 )
• STREET_NUMBER ( type: esriFieldTypeString, alias: Street Number, length: 50 )
• STREET_NAME ( type: esriFieldTypeString, alias: Street Name, length: 50 )
• STREET_CITY ( type: esriFieldTypeString, alias: City, length: 50 )
• CREATEDON ( type: esriFieldTypeDate, alias: Created On, length: 8 )
• CREATEDBY ( type: esriFieldTypeString, alias: Created By, length: 256 )
• EDITEDON ( type: esriFieldTypeDate, alias: Edited On, length: 8 )
• EDITEDBY ( type: esriFieldTypeString, alias: Edited By, length: 256 )
• SP_ID ( type: esriFieldTypeString, alias: Service Point ID, length: 20 )
• PREM_ID ( type: esriFieldTypeString, alias: Premise ID, length: 20 )
• STATUS ( type: esriFieldTypeSmallInteger, alias: Status )
• ACTIVEFLAG ( type: esriFieldTypeInteger, alias: Active , Coded Values: [0: Related] , [1: Active] , [2: Inactive] , ...3 more... )
• STREET_ZIPCODE ( type: esriFieldTypeString, alias: Zip Code, length: 10 )
• PIN_NUM ( type: esriFieldTypeString, alias: PIN Number, length: 11 )
• REID ( type: esriFieldTypeString, alias: REID, length: 20 )
• STNAME ( type: esriFieldTypeString, alias: Street Name, length: 25 )
• STYPE ( type: esriFieldTypeString, alias: Street Type, length: 4 )
• STPRE ( type: esriFieldTypeString, alias: Street Prefix, length: 2 )
• STSUF ( type: esriFieldTypeString, alias: Street Suffix, length: 2 )
• STNUM ( type: esriFieldTypeInteger, alias: Street Number )
• STMISC ( type: esriFieldTypeString, alias: Street Misc, length: 6 )
• SITE_ADDRESS ( type: esriFieldTypeString, alias: Site Address, length: 77 )
• FULL_STREET_NAME ( type: esriFieldTypeString, alias: Full Street Name, length: 36 )
• CITY ( type: esriFieldTypeString, alias: City, length: 50 )
• TOWNSHIP ( type: esriFieldTypeString, alias: Township, length: 50 )
• SITE ( type: esriFieldTypeSmallInteger, alias: Site )
• ZIPCODE ( type: esriFieldTypeString, alias: Zipcode, length: 5 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• ESTABLISHMENT_ID ( type: esriFieldTypeString, alias: Establisment ID, length: 20 )
• CCB_UPDATE ( type: esriFieldTypeDate, alias: CCB Update, length: 8 )
• O_VALUE ( type: esriFieldTypeString, alias: O_VALUE, length: 2000 )

Relationships:

• RPUD.ssFOGInterceptors (0) -- Related To: FOG Interceptors (1)

Table: FOG Establishments Summary Test (4)

Name: FOG Establishments Summary Test

Display Field: PREM_ID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: af4e1f063bae44108f75dbb94e1fef5f

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 4000

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PREM_ID ( type: esriFieldTypeString, alias: PREM_ID, length: 20 )
• SP_ID ( type: esriFieldTypeString, alias: SP_ID, length: 20 )
• FOG_UNIT ( type: esriFieldTypeDouble, alias: FOG_UNIT )

Table: FOG Establishments Summary CCB (5)

Name: FOG Establishments Summary CCB

Display Field: PREM_ID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: af4e1f063bae44108f75dbb94e1fef5f

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 4000

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PREM_ID ( type: esriFieldTypeString, alias: PREM_ID, length: 20 )
• SP_ID ( type: esriFieldTypeString, alias: SP_ID, length: 20 )
• FOG_UNIT ( type: esriFieldTypeDouble, alias: FOG_UNIT )
• CCB_UPDATE ( type: esriFieldTypeDate, alias: CCB_UPDATE, length: 8 )