Layers:

Layer: Customers (215)

Name: Customers

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 3000

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: 906118.7990235537
YMin: 748402.8003915995
XMax: 943230.6162011027
YMax: 783986.2098936737
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• mbl ( type: esriFieldTypeString, alias: mbl, length: 50 )
• owner ( type: esriFieldTypeString, alias: owner, length: 50 )
• address ( type: esriFieldTypeString, alias: address, length: 50 )
• house_num ( type: esriFieldTypeString, alias: house_num, length: 50 )
• prefix ( type: esriFieldTypeString, alias: prefix, length: 50 )
• pretype ( type: esriFieldTypeString, alias: pretype, length: 50 )
• name ( type: esriFieldTypeString, alias: name, length: 50 )
• type ( type: esriFieldTypeString, alias: type, length: 50 )
• suffix ( type: esriFieldTypeString, alias: suffix, length: 50 )
• unit ( type: esriFieldTypeString, alias: unit, length: 50 )
• condo ( type: esriFieldTypeString, alias: condo, length: 50 )
• zip ( type: esriFieldTypeString, alias: zip, length: 50 )
• city ( type: esriFieldTypeString, alias: city, length: 50 )
• lat ( type: esriFieldTypeDouble, alias: lat )
• lon ( type: esriFieldTypeDouble, alias: lon )
• picweb ( type: esriFieldTypeString, alias: picweb, length: 255 )
• picfile ( type: esriFieldTypeString, alias: picfile, length: 255 )
• police ( type: esriFieldTypeString, alias: police, length: 50 )
• fire ( type: esriFieldTypeString, alias: fire, length: 50 )
• ems ( type: esriFieldTypeString, alias: ems, length: 50 )
• dynamap_id ( type: esriFieldTypeInteger, alias: dynamap_id )
• commonnames ( type: esriFieldTypeString, alias: commonnames, length: 100 )
• shape ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: Inspected Manholes (21)

Name: Inspected Manholes

Display Field: mh_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 6000

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: 906412.8761914074
YMin: 747498.3294575661
XMax: 943049.217288658
YMax: 783509.789258644
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• mh_id ( type: esriFieldTypeString, alias: mh_id, length: 20 )
• subarea ( type: esriFieldTypeString, alias: subarea, length: 50 )
• mh_num ( type: esriFieldTypeString, alias: mh_num, length: 10 )
• street ( type: esriFieldTypeString, alias: street, length: 100 )
• easement ( type: esriFieldTypeString, alias: easement, length: 10 )
• interceptor ( type: esriFieldTypeString, alias: interceptor, length: 50 )
• inter_pipe ( type: esriFieldTypeString, alias: inter_pipe, length: 50 )
• owner ( type: esriFieldTypeString, alias: owner, length: 20 )
• mh_type ( type: esriFieldTypeString, alias: mh_type, length: 50 )
• mapnum_400 ( type: esriFieldTypeString, alias: mapnum_400, length: 10 )
• topframe ( type: esriFieldTypeDouble, alias: topframe )
• gps_match ( type: esriFieldTypeString, alias: gps_match, length: 10 )
• gps_elevation ( type: esriFieldTypeDouble, alias: gps_elevation )
• gps_date ( type: esriFieldTypeDate, alias: gps_date, length: 8 )
• gps_latitude ( type: esriFieldTypeDouble, alias: gps_latitude )
• gps_longitude ( type: esriFieldTypeDouble, alias: gps_longitude )
• gps_northing ( type: esriFieldTypeDouble, alias: gps_northing )
• gps_easting ( type: esriFieldTypeDouble, alias: gps_easting )
• scan_link1 ( type: esriFieldTypeString, alias: scan_link1, length: 254 )
• scan_link2 ( type: esriFieldTypeString, alias: scan_link2, length: 254 )
• scan_link3 ( type: esriFieldTypeString, alias: scan_link3, length: 254 )
• scan_link4 ( type: esriFieldTypeString, alias: scan_link4, length: 254 )
• scan_link5 ( type: esriFieldTypeString, alias: scan_link5, length: 254 )
• notes ( type: esriFieldTypeString, alias: notes, length: 254 )
• shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• insp_date ( type: esriFieldTypeDate, alias: insp_date, length: 8 )

Layer: Historic Inspections (218)

Name: Historic Inspections

Display Field: mh_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 6000

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: 906412.8761914074
YMin: 747498.3294575661
XMax: 943049.217288658
YMax: 783509.789258644
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• mh_id ( type: esriFieldTypeString, alias: mh_id, length: 20 )
• subarea ( type: esriFieldTypeString, alias: subarea, length: 50 )
• mh_num ( type: esriFieldTypeString, alias: mh_num, length: 10 )
• street ( type: esriFieldTypeString, alias: street, length: 100 )
• easement ( type: esriFieldTypeString, alias: easement, length: 10 )
• interceptor ( type: esriFieldTypeString, alias: interceptor, length: 50 )
• inter_pipe ( type: esriFieldTypeString, alias: inter_pipe, length: 50 )
• owner ( type: esriFieldTypeString, alias: owner, length: 20 )
• mh_type ( type: esriFieldTypeString, alias: mh_type, length: 50 )
• mapnum_400 ( type: esriFieldTypeString, alias: mapnum_400, length: 10 )
• topframe ( type: esriFieldTypeDouble, alias: topframe )
• gps_match ( type: esriFieldTypeString, alias: gps_match, length: 10 )
• gps_elevation ( type: esriFieldTypeDouble, alias: gps_elevation )
• gps_date ( type: esriFieldTypeDate, alias: gps_date, length: 8 )
• gps_latitude ( type: esriFieldTypeDouble, alias: gps_latitude )
• gps_longitude ( type: esriFieldTypeDouble, alias: gps_longitude )
• gps_northing ( type: esriFieldTypeDouble, alias: gps_northing )
• gps_easting ( type: esriFieldTypeDouble, alias: gps_easting )
• scan_link1 ( type: esriFieldTypeString, alias: scan_link1, length: 254 )
• scan_link2 ( type: esriFieldTypeString, alias: scan_link2, length: 254 )
• scan_link3 ( type: esriFieldTypeString, alias: scan_link3, length: 254 )
• scan_link4 ( type: esriFieldTypeString, alias: scan_link4, length: 254 )
• scan_link5 ( type: esriFieldTypeString, alias: scan_link5, length: 254 )
• notes ( type: esriFieldTypeString, alias: notes, length: 254 )
• shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• insp_date ( type: esriFieldTypeDate, alias: insp_date, length: 8 )

Layer: No Inspection Manholes (222)

Name: No Inspection Manholes

Display Field: mh_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 6000

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: 906412.8761914074
YMin: 747498.3294575661
XMax: 943049.217288658
YMax: 783509.789258644
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• mh_id ( type: esriFieldTypeString, alias: mh_id, length: 20 )
• subarea ( type: esriFieldTypeString, alias: subarea, length: 50 )
• mh_num ( type: esriFieldTypeString, alias: mh_num, length: 10 )
• street ( type: esriFieldTypeString, alias: street, length: 100 )
• easement ( type: esriFieldTypeString, alias: easement, length: 10 )
• interceptor ( type: esriFieldTypeString, alias: interceptor, length: 50 )
• inter_pipe ( type: esriFieldTypeString, alias: inter_pipe, length: 50 )
• owner ( type: esriFieldTypeString, alias: owner, length: 20 )
• mh_type ( type: esriFieldTypeString, alias: mh_type, length: 50 )
• mapnum_400 ( type: esriFieldTypeString, alias: mapnum_400, length: 10 )
• topframe ( type: esriFieldTypeDouble, alias: topframe )
• gps_match ( type: esriFieldTypeString, alias: gps_match, length: 10 )
• gps_elevation ( type: esriFieldTypeDouble, alias: gps_elevation )
• gps_date ( type: esriFieldTypeDate, alias: gps_date, length: 8 )
• gps_latitude ( type: esriFieldTypeDouble, alias: gps_latitude )
• gps_longitude ( type: esriFieldTypeDouble, alias: gps_longitude )
• gps_northing ( type: esriFieldTypeDouble, alias: gps_northing )
• gps_easting ( type: esriFieldTypeDouble, alias: gps_easting )
• scan_link1 ( type: esriFieldTypeString, alias: scan_link1, length: 254 )
• scan_link2 ( type: esriFieldTypeString, alias: scan_link2, length: 254 )
• scan_link3 ( type: esriFieldTypeString, alias: scan_link3, length: 254 )
• scan_link4 ( type: esriFieldTypeString, alias: scan_link4, length: 254 )
• scan_link5 ( type: esriFieldTypeString, alias: scan_link5, length: 254 )
• notes ( type: esriFieldTypeString, alias: notes, length: 254 )
• shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• insp_date ( type: esriFieldTypeDate, alias: insp_date, length: 8 )

Layer: SSES Manholes (918)

Name: SSES Manholes

Display Field: MH_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

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: 910898.1611840129
YMin: 752230.8908585012
XMax: 937110.9899918437
YMax: 783377.2271877527
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• MH_ID ( type: esriFieldTypeString, alias: MH_ID, length: 20 )
• SUBAREA ( type: esriFieldTypeString, alias: SUBAREA, length: 50 )
• MH_NUM ( type: esriFieldTypeString, alias: MH_NUM, length: 10 )
• STREET ( type: esriFieldTypeString, alias: STREET, length: 100 )
• EASEMENT ( type: esriFieldTypeString, alias: EASEMENT, length: 10 )
• INTERCEPTOR ( type: esriFieldTypeString, alias: INTERCEPTOR, length: 50 )
• INTER_PIPE ( type: esriFieldTypeString, alias: INTER_PIPE, length: 50 )
• OWNER ( type: esriFieldTypeString, alias: OWNER, length: 20 )
• MH_TYPE ( type: esriFieldTypeString, alias: MH_TYPE, length: 50 )
• MAPNUM_400 ( type: esriFieldTypeString, alias: MAPNUM_400, length: 10 )
• TOPFRAME ( type: esriFieldTypeDouble, alias: TOPFRAME )
• GPS_MATCH ( type: esriFieldTypeString, alias: GPS_MATCH, length: 10 )
• GPS_ELEVATION ( type: esriFieldTypeDouble, alias: GPS_ELEVATION )
• GPS_DATE ( type: esriFieldTypeDate, alias: GPS_DATE, length: 8 )
• GPS_LATITUDE ( type: esriFieldTypeDouble, alias: GPS_LATITUDE )
• GPS_LONGITUDE ( type: esriFieldTypeDouble, alias: GPS_LONGITUDE )
• GPS_NORTHING ( type: esriFieldTypeDouble, alias: GPS_NORTHING )
• GPS_EASTING ( type: esriFieldTypeDouble, alias: GPS_EASTING )
• SCAN_LINK1 ( type: esriFieldTypeString, alias: SCAN_LINK1, length: 254 )
• SCAN_LINK2 ( type: esriFieldTypeString, alias: SCAN_LINK2, length: 254 )
• SCAN_LINK3 ( type: esriFieldTypeString, alias: SCAN_LINK3, length: 254 )
• SCAN_LINK4 ( type: esriFieldTypeString, alias: SCAN_LINK4, length: 254 )
• SCAN_LINK5 ( type: esriFieldTypeString, alias: SCAN_LINK5, length: 254 )
• NOTES ( type: esriFieldTypeString, alias: NOTES, length: 254 )
• INSPSTATUS ( type: esriFieldTypeString, alias: INSPSTATUS, length: 10 )
• MHDEPTH ( type: esriFieldTypeDouble, alias: MHDEPTH )
• WaterburyGIS.GISEDITOR.SSES_MHs.FID ( type: esriFieldTypeDouble, alias: FID )
• MH_ID_1 ( type: esriFieldTypeString, alias: MH_ID_1, length: 255 )
• SSES_ID ( type: esriFieldTypeInteger, alias: SSES_ID )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: Permits (11)

Name: Permits

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 3000

Max Scale: 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: 906118.7990235537
YMin: 748402.8003915995
XMax: 943322.0185731649
YMax: 783986.2098936737
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [house_num]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• mbl ( type: esriFieldTypeString, alias: mbl, length: 50 )
• owner ( type: esriFieldTypeString, alias: owner, length: 50 )
• address ( type: esriFieldTypeString, alias: address, length: 50 )
• house_num ( type: esriFieldTypeString, alias: house_num, length: 50 )
• prefix ( type: esriFieldTypeString, alias: prefix, length: 50 )
• pretype ( type: esriFieldTypeString, alias: pretype, length: 50 )
• name ( type: esriFieldTypeString, alias: name, length: 50 )
• type ( type: esriFieldTypeString, alias: type, length: 50 )
• suffix ( type: esriFieldTypeString, alias: suffix, length: 50 )
• unit ( type: esriFieldTypeString, alias: unit, length: 50 )
• condo ( type: esriFieldTypeString, alias: condo, length: 50 )
• zip ( type: esriFieldTypeString, alias: zip, length: 50 )
• city ( type: esriFieldTypeString, alias: city, length: 50 )
• lat ( type: esriFieldTypeDouble, alias: lat )
• lon ( type: esriFieldTypeDouble, alias: lon )
• picweb ( type: esriFieldTypeString, alias: picweb, length: 255 )
• picfile ( type: esriFieldTypeString, alias: picfile, length: 255 )
• police ( type: esriFieldTypeString, alias: police, length: 50 )
• fire ( type: esriFieldTypeString, alias: fire, length: 50 )
• ems ( type: esriFieldTypeString, alias: ems, length: 50 )
• dynamap_id ( type: esriFieldTypeInteger, alias: dynamap_id )
• commonnames ( type: esriFieldTypeString, alias: commonnames, length: 100 )
• shape ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: Sanitary Features (8)

Name: Sanitary Features

Display Field: sanitary_type

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 10000

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: 907353.2437332422
YMin: 749759.0500017256
XMax: 941401.456804663
YMax: 779696.3936702311
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: sanitary_type
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Box
  Label: Box
  Description:
  Symbol:
  
• Value: Diversion Chamber
  Label: Diversion Chamber
  Description:
  Symbol:
  
• Value: Meter Chamber
  Label: Meter Chamber
  Description:
  Symbol:
  
• Value: Meter Station
  Label: Meter Station
  Description:
  Symbol:
  
• Value: PLUG
  Label: PLUG
  Description:
  Symbol:
  
• Value: Sanitary Vent
  Label: Sanitary Vent
  Description:
  Symbol:
  
• Value: Siphon Inlet Chamber
  Label: Siphon Inlet Chamber
  Description:
  Symbol:
  
• Value: Siphon Outlet Chamber
  Label: Siphon Outlet Chamber
  Description:
  Symbol:
  
• Value: Street Chamber
  Label: Street Chamber
  Description:
  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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• sanitary_type ( type: esriFieldTypeString, alias: sanitary_type, length: 50 )
• details ( type: esriFieldTypeString, alias: details, length: 50 )
• scan_link1 ( type: esriFieldTypeString, alias: scan_link1, length: 255 )
• scan_link2 ( type: esriFieldTypeString, alias: scan_link2, length: 255 )
• scan_link3 ( type: esriFieldTypeString, alias: scan_link3, length: 255 )
• scan_link4 ( type: esriFieldTypeString, alias: scan_link4, length: 255 )
• gps_match ( type: esriFieldTypeString, alias: gps_match, length: 10 )
• mbl ( type: esriFieldTypeString, alias: mbl, length: 30 )
• easement ( type: esriFieldTypeString, alias: easement, length: 15 )
• address ( type: esriFieldTypeString, alias: address, length: 150 )
• address_notes ( type: esriFieldTypeString, alias: address_notes, length: 150 )
• num_map ( type: esriFieldTypeString, alias: num_map, length: 30 )
• details_aka ( type: esriFieldTypeString, alias: details_aka, length: 50 )
• lat ( type: esriFieldTypeDouble, alias: lat )
• lon ( type: esriFieldTypeDouble, alias: lon )
• zip_code ( type: esriFieldTypeString, alias: zip_code, length: 10 )
• elevation ( type: esriFieldTypeDouble, alias: elevation )
• shape ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: Lift Stations (4)

Name: Lift Stations

Display Field: sanitary_type

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

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: 907353.2437332422
YMin: 749759.0500017256
XMax: 941401.456804663
YMax: 779696.3936702311
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• sanitary_type ( type: esriFieldTypeString, alias: sanitary_type, length: 50 )
• details ( type: esriFieldTypeString, alias: details, length: 50 )
• scan_link1 ( type: esriFieldTypeString, alias: scan_link1, length: 255 )
• scan_link2 ( type: esriFieldTypeString, alias: scan_link2, length: 255 )
• scan_link3 ( type: esriFieldTypeString, alias: scan_link3, length: 255 )
• scan_link4 ( type: esriFieldTypeString, alias: scan_link4, length: 255 )
• gps_match ( type: esriFieldTypeString, alias: gps_match, length: 10 )
• mbl ( type: esriFieldTypeString, alias: mbl, length: 30 )
• easement ( type: esriFieldTypeString, alias: easement, length: 15 )
• address ( type: esriFieldTypeString, alias: address, length: 150 )
• address_notes ( type: esriFieldTypeString, alias: address_notes, length: 150 )
• num_map ( type: esriFieldTypeString, alias: num_map, length: 30 )
• details_aka ( type: esriFieldTypeString, alias: details_aka, length: 50 )
• lat ( type: esriFieldTypeDouble, alias: lat )
• lon ( type: esriFieldTypeDouble, alias: lon )
• zip_code ( type: esriFieldTypeString, alias: zip_code, length: 10 )
• elevation ( type: esriFieldTypeDouble, alias: elevation )
• shape ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: Manholes (1)

Name: Manholes

Display Field: mh_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 6000

Max Scale: 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: 906412.8761914074
YMin: 747498.3294575661
XMax: 943049.217288658
YMax: 783509.789258644
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [mh_id]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 4000.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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• mh_id ( type: esriFieldTypeString, alias: mh_id, length: 20 )
• subarea ( type: esriFieldTypeString, alias: subarea, length: 50 )
• mh_num ( type: esriFieldTypeString, alias: mh_num, length: 10 )
• street ( type: esriFieldTypeString, alias: street, length: 100 )
• easement ( type: esriFieldTypeString, alias: easement, length: 10 )
• interceptor ( type: esriFieldTypeString, alias: interceptor, length: 50 )
• inter_pipe ( type: esriFieldTypeString, alias: inter_pipe, length: 50 )
• owner ( type: esriFieldTypeString, alias: owner, length: 20 )
• mh_type ( type: esriFieldTypeString, alias: mh_type, length: 50 )
• mapnum_400 ( type: esriFieldTypeString, alias: mapnum_400, length: 10 )
• topframe ( type: esriFieldTypeDouble, alias: topframe )
• gps_match ( type: esriFieldTypeString, alias: gps_match, length: 10 )
• gps_elevation ( type: esriFieldTypeDouble, alias: gps_elevation )
• gps_date ( type: esriFieldTypeDate, alias: gps_date, length: 8 )
• gps_latitude ( type: esriFieldTypeDouble, alias: gps_latitude )
• gps_longitude ( type: esriFieldTypeDouble, alias: gps_longitude )
• gps_northing ( type: esriFieldTypeDouble, alias: gps_northing )
• gps_easting ( type: esriFieldTypeDouble, alias: gps_easting )
• scan_link1 ( type: esriFieldTypeString, alias: scan_link1, length: 254 )
• scan_link2 ( type: esriFieldTypeString, alias: scan_link2, length: 254 )
• scan_link3 ( type: esriFieldTypeString, alias: scan_link3, length: 254 )
• scan_link4 ( type: esriFieldTypeString, alias: scan_link4, length: 254 )
• scan_link5 ( type: esriFieldTypeString, alias: scan_link5, length: 254 )
• notes ( type: esriFieldTypeString, alias: notes, length: 254 )
• insp_date ( type: esriFieldTypeDate, alias: insp_date, length: 8 )
• shape ( type: esriFieldTypeGeometry, alias: SHAPE )

Layer: Flow Meter Manholes (913)

Name: Flow Meter Manholes

Display Field: mh_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 6000

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: 906412.8761914074
YMin: 747498.3294575661
XMax: 943049.217288658
YMax: 783509.789258644
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• mh_id ( type: esriFieldTypeString, alias: mh_id, length: 20 )
• subarea ( type: esriFieldTypeString, alias: subarea, length: 50 )
• mh_num ( type: esriFieldTypeString, alias: mh_num, length: 10 )
• street ( type: esriFieldTypeString, alias: street, length: 100 )
• easement ( type: esriFieldTypeString, alias: easement, length: 10 )
• interceptor ( type: esriFieldTypeString, alias: interceptor, length: 50 )
• inter_pipe ( type: esriFieldTypeString, alias: inter_pipe, length: 50 )
• owner ( type: esriFieldTypeString, alias: owner, length: 20 )
• mh_type ( type: esriFieldTypeString, alias: mh_type, length: 50 )
• mapnum_400 ( type: esriFieldTypeString, alias: mapnum_400, length: 10 )
• topframe ( type: esriFieldTypeDouble, alias: topframe )
• gps_match ( type: esriFieldTypeString, alias: gps_match, length: 10 )
• gps_elevation ( type: esriFieldTypeDouble, alias: gps_elevation )
• gps_date ( type: esriFieldTypeDate, alias: gps_date, length: 8 )
• gps_latitude ( type: esriFieldTypeDouble, alias: gps_latitude )
• gps_longitude ( type: esriFieldTypeDouble, alias: gps_longitude )
• gps_northing ( type: esriFieldTypeDouble, alias: gps_northing )
• gps_easting ( type: esriFieldTypeDouble, alias: gps_easting )
• scan_link1 ( type: esriFieldTypeString, alias: scan_link1, length: 254 )
• scan_link2 ( type: esriFieldTypeString, alias: scan_link2, length: 254 )
• scan_link3 ( type: esriFieldTypeString, alias: scan_link3, length: 254 )
• scan_link4 ( type: esriFieldTypeString, alias: scan_link4, length: 254 )
• scan_link5 ( type: esriFieldTypeString, alias: scan_link5, length: 254 )
• notes ( type: esriFieldTypeString, alias: notes, length: 254 )
• shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• insp_date ( type: esriFieldTypeDate, alias: insp_date, length: 8 )

Layer: Flow Meters Installed (915)

Name: Flow Meters Installed

Display Field: mh_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 6000

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: 906412.8761914074
YMin: 747498.3294575661
XMax: 943049.217288658
YMax: 783509.789258644
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• mh_id ( type: esriFieldTypeString, alias: mh_id, length: 20 )
• subarea ( type: esriFieldTypeString, alias: subarea, length: 50 )
• mh_num ( type: esriFieldTypeString, alias: mh_num, length: 10 )
• street ( type: esriFieldTypeString, alias: street, length: 100 )
• easement ( type: esriFieldTypeString, alias: easement, length: 10 )
• interceptor ( type: esriFieldTypeString, alias: interceptor, length: 50 )
• inter_pipe ( type: esriFieldTypeString, alias: inter_pipe, length: 50 )
• owner ( type: esriFieldTypeString, alias: owner, length: 20 )
• mh_type ( type: esriFieldTypeString, alias: mh_type, length: 50 )
• mapnum_400 ( type: esriFieldTypeString, alias: mapnum_400, length: 10 )
• topframe ( type: esriFieldTypeDouble, alias: topframe )
• gps_match ( type: esriFieldTypeString, alias: gps_match, length: 10 )
• gps_elevation ( type: esriFieldTypeDouble, alias: gps_elevation )
• gps_date ( type: esriFieldTypeDate, alias: gps_date, length: 8 )
• gps_latitude ( type: esriFieldTypeDouble, alias: gps_latitude )
• gps_longitude ( type: esriFieldTypeDouble, alias: gps_longitude )
• gps_northing ( type: esriFieldTypeDouble, alias: gps_northing )
• gps_easting ( type: esriFieldTypeDouble, alias: gps_easting )
• scan_link1 ( type: esriFieldTypeString, alias: scan_link1, length: 254 )
• scan_link2 ( type: esriFieldTypeString, alias: scan_link2, length: 254 )
• scan_link3 ( type: esriFieldTypeString, alias: scan_link3, length: 254 )
• scan_link4 ( type: esriFieldTypeString, alias: scan_link4, length: 254 )
• scan_link5 ( type: esriFieldTypeString, alias: scan_link5, length: 254 )
• notes ( type: esriFieldTypeString, alias: notes, length: 254 )
• shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• insp_date ( type: esriFieldTypeDate, alias: insp_date, length: 8 )

Layer: Cleaned Pipes (22)

Name: Cleaned Pipes

Display Field: pipe_id

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 30000

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: 906412.8761914074
YMin: 747498.3294575661
XMax: 943049.217288658
YMax: 783509.789258644
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 6
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• pipe_id ( type: esriFieldTypeString, alias: pipe_id, length: 20 )
• subarea ( type: esriFieldTypeString, alias: subarea, length: 10 )
• mh_from ( type: esriFieldTypeString, alias: mh_from, length: 20 )
• mh_to ( type: esriFieldTypeString, alias: mh_to, length: 20 )
• street ( type: esriFieldTypeString, alias: street, length: 100 )
• easement ( type: esriFieldTypeString, alias: easement, length: 20 )
• interceptor ( type: esriFieldTypeString, alias: interceptor, length: 50 )
• inter_pipe ( type: esriFieldTypeString, alias: inter_pipe, length: 50 )
• owner ( type: esriFieldTypeString, alias: owner, length: 20 )
• pipe_type ( type: esriFieldTypeString, alias: pipe_type, length: 50 )
• pipe_diameter ( type: esriFieldTypeSmallInteger, alias: PIPEDIAMETER )
• pipe_material ( type: esriFieldTypeString, alias: PIPEMATERIAL, length: 50 )
• pipe_year ( type: esriFieldTypeString, alias: PIPEYEAR, length: 20 )
• pipe_slope ( type: esriFieldTypeDouble, alias: PIPESLOPE )
• pipe_inv_up ( type: esriFieldTypeDouble, alias: pipe_inv_up )
• pipe_inv_dn ( type: esriFieldTypeDouble, alias: pipe_inv_dn )
• pipe_length ( type: esriFieldTypeDouble, alias: pipe_length )
• scan_link1 ( type: esriFieldTypeString, alias: scan_link1, length: 254 )
• scan_link2 ( type: esriFieldTypeString, alias: scan_link2, length: 254 )
• scan_link3 ( type: esriFieldTypeString, alias: scan_link3, length: 254 )
• scan_link4 ( type: esriFieldTypeString, alias: scan_link4, length: 254 )
• scan_link5 ( type: esriFieldTypeString, alias: scan_link5, length: 254 )
• scan_link6 ( type: esriFieldTypeString, alias: scan_link6, length: 254 )
• scan_link7 ( type: esriFieldTypeString, alias: scan_link7, length: 254 )
• scan_link8 ( type: esriFieldTypeString, alias: scan_link8, length: 254 )
• notes ( type: esriFieldTypeString, alias: notes, length: 254 )
• datecleaned ( type: esriFieldTypeDate, alias: datecleaned, length: 8 )
• pipelength ( type: esriFieldTypeDouble, alias: pipelength )
• shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• shape.STLength() ( type: esriFieldTypeDouble, alias: shape.STLength() )

Layer: Streets (50)

Name: Streets

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 10000

Max Scale: 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: 906090.828279078
YMin: 748211.7939098924
XMax: 943505.9250366688
YMax: 783981.4749950618
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSNull
Color: [0, 0, 0, 0]
Width: 0
Label:
Description:
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementCenterAlong
Label Expression: [label]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: FID )
• fnode_ ( type: esriFieldTypeDouble, alias: fnode_ )
• tnode_ ( type: esriFieldTypeDouble, alias: tnode_ )
• lpoly_ ( type: esriFieldTypeDouble, alias: lpoly_ )
• rpoly_ ( type: esriFieldTypeDouble, alias: rpoly_ )
• length ( type: esriFieldTypeDouble, alias: length )
• cl_99_ ( type: esriFieldTypeDouble, alias: cl_99_ )
• cl_99_id ( type: esriFieldTypeDouble, alias: cl_99_id )
• segment_id ( type: esriFieldTypeInteger, alias: segment_id )
• ctbna90l ( type: esriFieldTypeString, alias: ctbna90l, length: 6 )
• ctbna90r ( type: esriFieldTypeString, alias: ctbna90r, length: 6 )
• blk90l ( type: esriFieldTypeString, alias: blk90l, length: 4 )
• blk90r ( type: esriFieldTypeString, alias: blk90r, length: 4 )
• relay ( type: esriFieldTypeInteger, alias: relay )
• route ( type: esriFieldTypeString, alias: route, length: 10 )
• day_recyc ( type: esriFieldTypeInteger, alias: day_recyc )
• recycle ( type: esriFieldTypeInteger, alias: recycle )
• day_garb ( type: esriFieldTypeInteger, alias: day_garb )
• garbage ( type: esriFieldTypeInteger, alias: garbage )
• district ( type: esriFieldTypeString, alias: district, length: 6 )
• subdistric ( type: esriFieldTypeInteger, alias: subdistric )
• garb_day_n ( type: esriFieldTypeString, alias: garb_day_n, length: 50 )
• recyc_day_ ( type: esriFieldTypeString, alias: recyc_day_, length: 50 )
• state_road ( type: esriFieldTypeString, alias: state_road, length: 10 )
• state_rout ( type: esriFieldTypeString, alias: state_rout, length: 10 )
• label ( type: esriFieldTypeString, alias: label, length: 75 )
• miles ( type: esriFieldTypeDouble, alias: miles )
• owner ( type: esriFieldTypeString, alias: owner, length: 25 )
• func_class ( type: esriFieldTypeString, alias: func_class, length: 50 )
• year_accpt ( type: esriFieldTypeString, alias: year_accpt, length: 25 )
• street_id ( type: esriFieldTypeString, alias: street_id, length: 50 )
• sidewalk ( type: esriFieldTypeString, alias: sidewalk, length: 10 )
• label2 ( type: esriFieldTypeString, alias: label2, length: 50 )
• prefix ( type: esriFieldTypeString, alias: prefix, length: 2 )
• pretype ( type: esriFieldTypeString, alias: pretype, length: 10 )
• name ( type: esriFieldTypeString, alias: name, length: 50 )
• type ( type: esriFieldTypeString, alias: type, length: 6 )
• suffix ( type: esriFieldTypeString, alias: suffix, length: 2 )
• l_f_add ( type: esriFieldTypeString, alias: l_f_add, length: 11 )
• l_t_add ( type: esriFieldTypeString, alias: l_t_add, length: 11 )
• r_f_add ( type: esriFieldTypeString, alias: r_f_add, length: 11 )
• r_t_add ( type: esriFieldTypeString, alias: r_t_add, length: 11 )
• postal_l ( type: esriFieldTypeString, alias: postal_l, length: 5 )
• postal_r ( type: esriFieldTypeString, alias: postal_r, length: 5 )
• join_id ( type: esriFieldTypeInteger, alias: join_id )
• venue ( type: esriFieldTypeString, alias: venue, length: 50 )
• shape_leng ( type: esriFieldTypeDouble, alias: shape_leng )
• shape ( type: esriFieldTypeGeometry, alias: shape )
• shape.STLength() ( type: esriFieldTypeDouble, alias: shape.STLength() )

Layer: Dig Tickets (217)

Name: Dig Tickets

Display Field: contactname

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

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: 850604.9893294493
YMin: 747135.0362280853
XMax: 943714.7599184519
YMax: 824355.2241190124
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: priority
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Style: esriSFSSolid
Color: [0, 0, 0, 0]
Outline:
Style: esriSLSSolid
Color: [130, 130, 130, 255]
Width: 1
Default Label:
UniqueValueInfos:
• Value: Emergency
  Label: Emergency
  Description:
  Symbol:
  Style: esriSFSSolid
  Color: [0, 0, 0, 0]
  Outline:
  Style: esriSLSSolid
  Color: [255, 0, 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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• ticketid ( type: esriFieldTypeString, alias: TicketID, length: 50 )
• revision ( type: esriFieldTypeString, alias: StartDate, length: 50 )
• accountid ( type: esriFieldTypeString, alias: AccountID, length: 50 )
• startdate ( type: esriFieldTypeDate, alias: StartDate, length: 8 )
• hoursnotice ( type: esriFieldTypeSmallInteger, alias: HoursNotice )
• responserequired ( type: esriFieldTypeString, alias: ResponseRequired, length: 50 )
• responseduedate ( type: esriFieldTypeDate, alias: ResponseDueDate, length: 8 )
• priority ( type: esriFieldTypeString, alias: Priority, length: 50 )
• prioritytype ( type: esriFieldTypeString, alias: Type, length: 50 )
• crossstreet ( type: esriFieldTypeString, alias: CrossStreet, length: 100 )
• delineated ( type: esriFieldTypeString, alias: Delineated, length: 50 )
• delineationtype ( type: esriFieldTypeString, alias: DelineationType, length: 50 )
• instructions ( type: esriFieldTypeString, alias: Instructions, length: 255 )
• constructiontype ( type: esriFieldTypeString, alias: WorkorderKey, length: 50 )
• contactname ( type: esriFieldTypeString, alias: ContactName, length: 50 )
• address1 ( type: esriFieldTypeString, alias: Address1, length: 100 )
• address2 ( type: esriFieldTypeString, alias: Address2, length: 100 )
• city ( type: esriFieldTypeString, alias: City, length: 50 )
• state ( type: esriFieldTypeString, alias: State, length: 50 )
• zip ( type: esriFieldTypeString, alias: Zip, length: 50 )
• phone ( type: esriFieldTypeString, alias: Phone, length: 50 )
• email ( type: esriFieldTypeString, alias: Email, length: 50 )
• location ( type: esriFieldTypeString, alias: Location, length: 255 )
• comments ( type: esriFieldTypeString, alias: Comments, length: 1073741822 )
• tickettext ( type: esriFieldTypeString, alias: TicketText, length: 1073741822 )
• shape ( type: esriFieldTypeGeometry, alias: shape )
• field_status ( type: esriFieldTypeString, alias: field_status, length: 50 )
• ticketaddress ( type: esriFieldTypeString, alias: TicketAddress, length: 100 )
• ticketstreet ( type: esriFieldTypeString, alias: TicketStreet, length: 100 )
• ticketcity ( type: esriFieldTypeString, alias: TicketCity, length: 50 )
• ticketstate ( type: esriFieldTypeString, alias: TicketState, length: 50 )
• shape.STArea() ( type: esriFieldTypeDouble, alias: shape.STArea() )
• shape.STLength() ( type: esriFieldTypeDouble, alias: shape.STLength() )

Layer: Laterals (6)

Name: Laterals

Display Field: permit_number

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

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: 909778.6532524973
YMin: 749368.3601663113
XMax: 939512.8437839895
YMax: 782171.2213977277
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [85, 255, 0, 255]
Width: 1
Label:
Description:
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


HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• permit_number ( type: esriFieldTypeString, alias: permit_number, length: 12 )
• permit_date ( type: esriFieldTypeDate, alias: permit_date, length: 8 )
• contractor ( type: esriFieldTypeString, alias: contractor, length: 50 )
• wye_distance ( type: esriFieldTypeDouble, alias: wye_distance )
• house_number ( type: esriFieldTypeString, alias: house_number, length: 12 )
• street ( type: esriFieldTypeString, alias: street, length: 50 )
• permit_link ( type: esriFieldTypeString, alias: permit_link, length: 50 )
• map_link ( type: esriFieldTypeString, alias: Sewer Map Link, length: 256 )
• type ( type: esriFieldTypeString, alias: type, length: 50 )
• shape ( type: esriFieldTypeGeometry, alias: Shape )
• shape.STLength() ( type: esriFieldTypeDouble, alias: shape.STLength() )

Layer: Pipes (2)

Name: Pipes

Display Field: pipe_id

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 30000

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: 906412.8761914074
YMin: 747498.3294575661
XMax: 943049.217288658
YMax: 783509.789258644
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 6
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• pipe_id ( type: esriFieldTypeString, alias: pipe_id, length: 20 )
• subarea ( type: esriFieldTypeString, alias: subarea, length: 10 )
• mh_from ( type: esriFieldTypeString, alias: mh_from, length: 20 )
• mh_to ( type: esriFieldTypeString, alias: mh_to, length: 20 )
• street ( type: esriFieldTypeString, alias: street, length: 100 )
• easement ( type: esriFieldTypeString, alias: easement, length: 20 )
• interceptor ( type: esriFieldTypeString, alias: interceptor, length: 50 )
• inter_pipe ( type: esriFieldTypeString, alias: inter_pipe, length: 50 )
• owner ( type: esriFieldTypeString, alias: owner, length: 20 )
• pipe_type ( type: esriFieldTypeString, alias: pipe_type, length: 50 )
• pipe_diameter ( type: esriFieldTypeSmallInteger, alias: PIPEDIAMETER )
• pipe_material ( type: esriFieldTypeString, alias: PIPEMATERIAL, length: 50 )
• pipe_year ( type: esriFieldTypeString, alias: PIPEYEAR, length: 20 )
• pipe_slope ( type: esriFieldTypeDouble, alias: PIPESLOPE )
• pipe_inv_up ( type: esriFieldTypeDouble, alias: pipe_inv_up )
• pipe_inv_dn ( type: esriFieldTypeDouble, alias: pipe_inv_dn )
• pipe_length ( type: esriFieldTypeDouble, alias: pipe_length )
• scan_link1 ( type: esriFieldTypeString, alias: scan_link1, length: 254 )
• scan_link2 ( type: esriFieldTypeString, alias: scan_link2, length: 254 )
• scan_link3 ( type: esriFieldTypeString, alias: scan_link3, length: 254 )
• scan_link4 ( type: esriFieldTypeString, alias: scan_link4, length: 254 )
• scan_link5 ( type: esriFieldTypeString, alias: scan_link5, length: 254 )
• scan_link6 ( type: esriFieldTypeString, alias: scan_link6, length: 254 )
• scan_link7 ( type: esriFieldTypeString, alias: scan_link7, length: 254 )
• scan_link8 ( type: esriFieldTypeString, alias: scan_link8, length: 254 )
• notes ( type: esriFieldTypeString, alias: notes, length: 254 )
• datecleaned ( type: esriFieldTypeDate, alias: datecleaned, length: 8 )
• pipelength ( type: esriFieldTypeDouble, alias: pipelength )
• shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• shape.STLength() ( type: esriFieldTypeDouble, alias: shape.STLength() )

Layer: SSES Pipes (917)

Name: SSES Pipes

Display Field: PIPE_ID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

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: 910847.955903843
YMin: 752551.5539310873
XMax: 936567.6859603375
YMax: 783509.7892585844
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [255, 255, 0, 255]
Width: 5
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PIPE_ID ( type: esriFieldTypeString, alias: PIPE_ID, length: 20 )
• SUBAREA ( type: esriFieldTypeString, alias: SUBAREA, length: 10 )
• MH_FROM ( type: esriFieldTypeString, alias: MH_FROM, length: 20 )
• MH_TO ( type: esriFieldTypeString, alias: MH_TO, length: 20 )
• STREET ( type: esriFieldTypeString, alias: STREET, length: 100 )
• EASEMENT ( type: esriFieldTypeString, alias: EASEMENT, length: 20 )
• INTERCEPTOR ( type: esriFieldTypeString, alias: INTERCEPTOR, length: 50 )
• INTER_PIPE ( type: esriFieldTypeString, alias: INTER_PIPE, length: 50 )
• OWNER ( type: esriFieldTypeString, alias: OWNER, length: 20 )
• PIPE_TYPE ( type: esriFieldTypeString, alias: PIPE_TYPE, length: 50 )
• PIPE_DIAMETER ( type: esriFieldTypeSmallInteger, alias: PIPEDIAMETER )
• PIPE_MATERIAL ( type: esriFieldTypeString, alias: PIPEMATERIAL, length: 50 )
• PIPE_YEAR ( type: esriFieldTypeString, alias: PIPEYEAR, length: 20 )
• PIPE_SLOPE ( type: esriFieldTypeDouble, alias: PIPESLOPE )
• PIPE_INV_UP ( type: esriFieldTypeDouble, alias: PIPE_INV_UP )
• PIPE_INV_DN ( type: esriFieldTypeDouble, alias: PIPE_INV_DN )
• PIPE_LENGTH ( type: esriFieldTypeDouble, alias: PIPE_LENGTH )
• SCAN_LINK1 ( type: esriFieldTypeString, alias: SCAN_LINK1, length: 254 )
• SCAN_LINK2 ( type: esriFieldTypeString, alias: SCAN_LINK2, length: 254 )
• SCAN_LINK3 ( type: esriFieldTypeString, alias: SCAN_LINK3, length: 254 )
• SCAN_LINK4 ( type: esriFieldTypeString, alias: SCAN_LINK4, length: 254 )
• SCAN_LINK5 ( type: esriFieldTypeString, alias: SCAN_LINK5, length: 254 )
• SCAN_LINK6 ( type: esriFieldTypeString, alias: SCAN_LINK6, length: 254 )
• SCAN_LINK7 ( type: esriFieldTypeString, alias: SCAN_LINK7, length: 254 )
• SCAN_LINK8 ( type: esriFieldTypeString, alias: SCAN_LINK8, length: 254 )
• NOTES ( type: esriFieldTypeString, alias: NOTES, length: 254 )
• OBJECTID_1 ( type: esriFieldTypeDouble, alias: OBJECTID_1 )
• PIPE_ID_1 ( type: esriFieldTypeString, alias: PIPE_ID_1, length: 255 )
• SSES_ID ( type: esriFieldTypeInteger, alias: SSES_ID )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )

Layer: Sub Areas (13)

Name: Sub Areas

Display Field: subarea

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 100000

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: 905955.2501381636
YMin: 748344.5000093132
XMax: 943477.6665629894
YMax: 784141.1679171473
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [0, 0, 0, 0]
Outline:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 3
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• subarea ( type: esriFieldTypeString, alias: subarea, length: 5 )
• shape_leng ( type: esriFieldTypeDouble, alias: shape_leng )
• shape ( type: esriFieldTypeGeometry, alias: Shape )
• shape.STArea() ( type: esriFieldTypeDouble, alias: shape.STArea() )
• shape.STLength() ( type: esriFieldTypeDouble, alias: shape.STLength() )

Layer: Septic Properties (12)

Name: Septic Properties

Display Field: street_name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 10000

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: 907237.5900931656
YMin: 748486.1778755635
XMax: 942651.3201185763
YMax: 784913.4088267237
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• unique_id ( type: esriFieldTypeString, alias: unique_id, length: 25 )
• mbl ( type: esriFieldTypeString, alias: mbl, length: 50 )
• mblu ( type: esriFieldTypeString, alias: mblu, length: 50 )
• description ( type: esriFieldTypeString, alias: description, length: 255 )
• street_uni_1 ( type: esriFieldTypeString, alias: street_uni_1, length: 11 )
• comment ( type: esriFieldTypeString, alias: comment, length: 50 )
• map ( type: esriFieldTypeString, alias: map, length: 255 )
• block ( type: esriFieldTypeString, alias: block, length: 255 )
• lot ( type: esriFieldTypeString, alias: lot, length: 255 )
• unit ( type: esriFieldTypeString, alias: unit, length: 255 )
• num_street ( type: esriFieldTypeDouble, alias: num_street )
• street_number ( type: esriFieldTypeString, alias: street_number, length: 255 )
• street_name ( type: esriFieldTypeString, alias: street_name, length: 255 )
• location ( type: esriFieldTypeString, alias: location, length: 255 )
• owner ( type: esriFieldTypeString, alias: owner, length: 255 )
• owner2 ( type: esriFieldTypeString, alias: owner2, length: 255 )
• mailaddr ( type: esriFieldTypeString, alias: mailaddr, length: 255 )
• mailcity ( type: esriFieldTypeString, alias: mailcity, length: 255 )
• mailstate ( type: esriFieldTypeString, alias: mailstate, length: 255 )
• mailzip ( type: esriFieldTypeString, alias: mailzip, length: 255 )
• volume ( type: esriFieldTypeString, alias: volume, length: 255 )
• page ( type: esriFieldTypeString, alias: page, length: 255 )
• nbhd ( type: esriFieldTypeString, alias: nbhd, length: 255 )
• zone1 ( type: esriFieldTypeString, alias: zone1, length: 255 )
• primary_use ( type: esriFieldTypeString, alias: primary_use, length: 255 )
• acres ( type: esriFieldTypeString, alias: acres, length: 255 )
• app_bldg ( type: esriFieldTypeString, alias: app_bldg, length: 255 )
• tax_bldg ( type: esriFieldTypeString, alias: tax_bldg, length: 255 )
• app_land ( type: esriFieldTypeString, alias: app_land, length: 255 )
• tax_land ( type: esriFieldTypeString, alias: tax_land, length: 255 )
• app_outb ( type: esriFieldTypeString, alias: app_outb, length: 255 )
• tax_outb ( type: esriFieldTypeString, alias: tax_outb, length: 255 )
• app_total ( type: esriFieldTypeString, alias: app_total, length: 255 )
• tax_total ( type: esriFieldTypeString, alias: tax_total, length: 255 )
• condo ( type: esriFieldTypeString, alias: condo, length: 10 )
• lot_label ( type: esriFieldTypeSmallInteger, alias: lot_label )
• police_points ( type: esriFieldTypeString, alias: police_points, length: 50 )
• police_notes ( type: esriFieldTypeString, alias: police_notes, length: 50 )
• sale_date ( type: esriFieldTypeDate, alias: sale_date, length: 8 )
• year_built ( type: esriFieldTypeSmallInteger, alias: year_built )
• total_living_area ( type: esriFieldTypeSmallInteger, alias: total_living_area )
• design_type ( type: esriFieldTypeString, alias: design_type, length: 50 )
• bedrooms ( type: esriFieldTypeSmallInteger, alias: bedrooms )
• full_baths ( type: esriFieldTypeSmallInteger, alias: full_baths )
• half_baths ( type: esriFieldTypeSmallInteger, alias: half_baths )
• edit_date ( type: esriFieldTypeString, alias: edit_date, length: 50 )
• edit_type ( type: esriFieldTypeString, alias: edit_type, length: 50 )
• edit_source ( type: esriFieldTypeString, alias: edit_source, length: 255 )
• edit_notes ( type: esriFieldTypeString, alias: edit_notes, length: 50 )
• gis_zone ( type: esriFieldTypeString, alias: gis_zone, length: 15 )
• dev_num ( type: esriFieldTypeString, alias: dev_num, length: 25 )
• dev_num2 ( type: esriFieldTypeString, alias: dev_num2, length: 25 )
• gis_acres ( type: esriFieldTypeDouble, alias: gis_acres )
• cama_acres ( type: esriFieldTypeDouble, alias: cama_acres )
• acre_diff ( type: esriFieldTypeDouble, alias: acre_diff )
• lat ( type: esriFieldTypeDouble, alias: lat )
• lon ( type: esriFieldTypeDouble, alias: lon )
• objectid_1 ( type: esriFieldTypeInteger, alias: OBJECTID )
• acct_ ( type: esriFieldTypeString, alias: acct_, length: 255 )
• street ( type: esriFieldTypeString, alias: street, length: 255 )
• house__ ( type: esriFieldTypeDouble, alias: house__ )
• sr_added_info ( type: esriFieldTypeDouble, alias: sr_added_info )
• m_b_l ( type: esriFieldTypeString, alias: m_b_l, length: 255 )
• mbl_1 ( type: esriFieldTypeString, alias: mbl_1, length: 255 )
• sanitary_sewer_availability ( type: esriFieldTypeString, alias: sanitary_sewer_availability, length: 255 )
• sanitary_map_number ( type: esriFieldTypeString, alias: sanitary_map_number, length: 255 )
• field10 ( type: esriFieldTypeString, alias: field10, length: 255 )
• notes ( type: esriFieldTypeString, alias: notes, length: 255 )
• permit__date ( type: esriFieldTypeString, alias: permit__date, length: 255 )
• field11 ( type: esriFieldTypeString, alias: field11, length: 255 )
• shape ( type: esriFieldTypeGeometry, alias: Shape )
• shape.STArea() ( type: esriFieldTypeDouble, alias: shape.STArea() )
• shape.STLength() ( type: esriFieldTypeDouble, alias: shape.STLength() )

Layer: FOG (3)

Name: FOG

Display Field: Name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 10000

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: 859230.5565142483
YMin: 743109.5865946412
XMax: 940852.1153836697
YMax: 855156.492421642
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: STATUS
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Style: esriSFSSolid
Color: [255, 0, 0, 255]
Outline:
Style: esriSLSSolid
Color: [255, 0, 0, 255]
Width: 0
Default Label:
UniqueValueInfos:
• Value: Active
  Label: Active
  Description:
  Symbol:
  Style: esriSFSBackwardDiagonal
  Color: [255, 85, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [255, 85, 0, 255]
  Width: 2
• Value: Inactive
  Label: Inactive
  Description:
  Symbol:
  Style: esriSFSBackwardDiagonal
  Color: [178, 178, 178, 255]
  Outline:
  Style: esriSLSSolid
  Color: [156, 156, 156, 255]
  Width: 2
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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• Name ( type: esriFieldTypeString, alias: name, length: 255 )
• Street_Name_1 ( type: esriFieldTypeString, alias: street_name_1, length: 255 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspected ( type: esriFieldTypeDate, alias: inspected, length: 8 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• UNIQUE_ID ( type: esriFieldTypeString, alias: UNIQUE_ID, length: 50 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 25 )
• OBJECTID_12 ( type: esriFieldTypeInteger, alias: OBJECTID )
• UNIQUE_ID_1 ( type: esriFieldTypeString, alias: UNIQUE_ID_1, length: 255 )
• MBL ( type: esriFieldTypeString, alias: MBL, length: 255 )
• FSE_NAME ( type: esriFieldTypeString, alias: FSE_NAME, length: 255 )
• CLASS_ID ( type: esriFieldTypeDouble, alias: CLASS_ID )
• FSE_ADDR_NUM ( type: esriFieldTypeDouble, alias: FSE_ADDR_NUM )
• FSE_ADDR_STREET ( type: esriFieldTypeString, alias: FSE_ADDR_STREET, length: 255 )
• LAST_INSPECT ( type: esriFieldTypeDate, alias: LAST_INSPECT, length: 8 )
• FOG_DEVICE_1 ( type: esriFieldTypeString, alias: FOG_DEVICE_1, length: 255 )
• FOG_DEVICE_TYPE ( type: esriFieldTypeString, alias: FOG_DEVICE_TYPE, length: 255 )
• COMPLAINT ( type: esriFieldTypeString, alias: COMPLAINT, length: 255 )
• LETTER_SENT ( type: esriFieldTypeString, alias: LETTER_SENT, length: 255 )
• OTHER_ISSUES ( type: esriFieldTypeString, alias: OTHER_ISSUES, length: 255 )
• MAINTENANCE_LOG_PRESENT ( type: esriFieldTypeString, alias: MAINTENANCE_LOG_PRESENT, length: 255 )
• DEVICE_NOT_MAINTAINED ( type: esriFieldTypeString, alias: DEVICE_NOT_MAINTAINED, length: 255 )
• DEVICE_OFFLINE ( type: esriFieldTypeString, alias: DEVICE_OFFLINE, length: 255 )
• STAFF_NOT_TRAINED ( type: esriFieldTypeString, alias: STAFF_NOT_TRAINED, length: 255 )
• REASON_NOT_REQ ( type: esriFieldTypeString, alias: REASON_NOT_REQ, length: 255 )
• NO_ ( type: esriFieldTypeString, alias: NO_, length: 255 )
• YES ( type: esriFieldTypeDouble, alias: YES )
• NOT_REQ ( type: esriFieldTypeString, alias: NOT_REQ, length: 255 )
• COUNT_ ( type: esriFieldTypeDouble, alias: COUNT_ )
• LAST_INSP_HEALTH ( type: esriFieldTypeDate, alias: LAST_INSP_HEALTH, length: 8 )
• LAST_INSP_WPC ( type: esriFieldTypeDate, alias: LAST_INSP_WPC, length: 8 )
• WPC_NOTES_SEDARU ( type: esriFieldTypeString, alias: WPC_NOTES_SEDARU, length: 255 )
• WPC_NOTES_OFFLINE ( type: esriFieldTypeString, alias: WPC_NOTES_OFFLINE, length: 255 )
• DEVICE_ACCESSIBLE ( type: esriFieldTypeString, alias: DEVICE_ACCESSIBLE, length: 255 )
• FOODWASTE_TRAP ( type: esriFieldTypeString, alias: FOODWASTE_TRAP, length: 255 )
• CLEAN_DOCUMENT ( type: esriFieldTypeString, alias: CLEAN_DOCUMENT, length: 255 )
• MAINT_LOG ( type: esriFieldTypeString, alias: MAINT_LOG, length: 255 )
• TRAP_CLEANED_REG ( type: esriFieldTypeString, alias: TRAP_CLEANED_REG, length: 255 )
• DATE_CLEANED ( type: esriFieldTypeDate, alias: DATE_CLEANED, length: 8 )
• CLEANED_BY ( type: esriFieldTypeString, alias: CLEANED_BY, length: 255 )
• EFFECTIVE_VOLUME ( type: esriFieldTypeString, alias: EFFECTIVE_VOLUME, length: 255 )
• FOG_DEPTH_REPORT ( type: esriFieldTypeString, alias: FOG_DEPTH_REPORT, length: 255 )
• GALS_PUMPED ( type: esriFieldTypeString, alias: GALS_PUMPED, length: 255 )
• LOG_SIGNED ( type: esriFieldTypeString, alias: LOG_SIGNED, length: 255 )
• STAFF_TRAINED_BMP ( type: esriFieldTypeString, alias: STAFF_TRAINED_BMP, length: 255 )
• GREASE_SIGN ( type: esriFieldTypeString, alias: GREASE_SIGN, length: 255 )
• RECYCLE_REC ( type: esriFieldTypeString, alias: RECYCLE_REC, length: 255 )
• FOOD_WASTE_DISP ( type: esriFieldTypeString, alias: FOOD_WASTE_DISP, length: 255 )
• FOG_SYS_COVERED ( type: esriFieldTypeString, alias: FOG_SYS_COVERED, length: 255 )
• STORM_PROECTION ( type: esriFieldTypeString, alias: STORM_PROECTION, length: 255 )
• SPP_AVAILABLE ( type: esriFieldTypeString, alias: SPP_AVAILABLE, length: 255 )
• EXHAUST_UNITS ( type: esriFieldTypeString, alias: EXHAUST_UNITS, length: 255 )
• CLEAN_FREQ ( type: esriFieldTypeString, alias: CLEAN_FREQ, length: 255 )
• CLEAN_EQUIP ( type: esriFieldTypeString, alias: CLEAN_EQUIP, length: 255 )
• EQUIP_STATE ( type: esriFieldTypeString, alias: EQUIP_STATE, length: 255 )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• ADDRESS_LINK ( type: esriFieldTypeString, alias: ADDRESS_LINK, length: 100 )

Layer: FOG Inspected (33)

Name: FOG Inspected

Display Field: Name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 10000

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: 859230.5565142483
YMin: 743109.5865946412
XMax: 940852.1153836697
YMax: 855156.492421642
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: STATUS
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Active
  Label: Active
  Description:
  Symbol:
  Style: esriSFSForwardDiagonal
  Color: [85, 255, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [85, 255, 0, 255]
  Width: 2
• Value: Inactive
  Label: Inactive
  Description:
  Symbol:
  Style: esriSFSForwardDiagonal
  Color: [178, 178, 178, 255]
  Outline:
  Style: esriSLSSolid
  Color: [178, 178, 178, 255]
  Width: 2
Transparency: 65
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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Name ( type: esriFieldTypeString, alias: name, length: 255 )
• Street_Name_1 ( type: esriFieldTypeString, alias: street_name_1, length: 255 )
• inspected ( type: esriFieldTypeDate, alias: inspected, length: 8 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: shape.STLength() )
• UNIQUE_ID ( type: esriFieldTypeString, alias: UNIQUE_ID, length: 50 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 25 )
• OBJECTID_12 ( type: esriFieldTypeInteger, alias: OBJECTID )
• UNIQUE_ID_1 ( type: esriFieldTypeString, alias: UNIQUE_ID_1, length: 255 )
• MBL ( type: esriFieldTypeString, alias: MBL, length: 255 )
• FSE_NAME ( type: esriFieldTypeString, alias: FSE_NAME, length: 255 )
• CLASS_ID ( type: esriFieldTypeDouble, alias: CLASS_ID )
• FSE_ADDR_NUM ( type: esriFieldTypeDouble, alias: FSE_ADDR_NUM )
• FSE_ADDR_STREET ( type: esriFieldTypeString, alias: FSE_ADDR_STREET, length: 255 )
• LAST_INSPECT ( type: esriFieldTypeDate, alias: LAST_INSPECT, length: 8 )
• FOG_DEVICE_1 ( type: esriFieldTypeString, alias: FOG_DEVICE_1, length: 255 )
• FOG_DEVICE_TYPE ( type: esriFieldTypeString, alias: FOG_DEVICE_TYPE, length: 255 )
• COMPLAINT ( type: esriFieldTypeString, alias: COMPLAINT, length: 255 )
• LETTER_SENT ( type: esriFieldTypeString, alias: LETTER_SENT, length: 255 )
• OTHER_ISSUES ( type: esriFieldTypeString, alias: OTHER_ISSUES, length: 255 )
• MAINTENANCE_LOG_PRESENT ( type: esriFieldTypeString, alias: MAINTENANCE_LOG_PRESENT, length: 255 )
• DEVICE_NOT_MAINTAINED ( type: esriFieldTypeString, alias: DEVICE_NOT_MAINTAINED, length: 255 )
• DEVICE_OFFLINE ( type: esriFieldTypeString, alias: DEVICE_OFFLINE, length: 255 )
• STAFF_NOT_TRAINED ( type: esriFieldTypeString, alias: STAFF_NOT_TRAINED, length: 255 )
• REASON_NOT_REQ ( type: esriFieldTypeString, alias: REASON_NOT_REQ, length: 255 )
• NO_ ( type: esriFieldTypeString, alias: NO_, length: 255 )
• YES ( type: esriFieldTypeDouble, alias: YES )
• NOT_REQ ( type: esriFieldTypeString, alias: NOT_REQ, length: 255 )
• COUNT_ ( type: esriFieldTypeDouble, alias: COUNT_ )
• LAST_INSP_HEALTH ( type: esriFieldTypeDate, alias: LAST_INSP_HEALTH, length: 8 )
• LAST_INSP_WPC ( type: esriFieldTypeDate, alias: LAST_INSP_WPC, length: 8 )
• WPC_NOTES_SEDARU ( type: esriFieldTypeString, alias: WPC_NOTES_SEDARU, length: 255 )
• WPC_NOTES_OFFLINE ( type: esriFieldTypeString, alias: WPC_NOTES_OFFLINE, length: 255 )
• DEVICE_ACCESSIBLE ( type: esriFieldTypeString, alias: DEVICE_ACCESSIBLE, length: 255 )
• FOODWASTE_TRAP ( type: esriFieldTypeString, alias: FOODWASTE_TRAP, length: 255 )
• CLEAN_DOCUMENT ( type: esriFieldTypeString, alias: CLEAN_DOCUMENT, length: 255 )
• MAINT_LOG ( type: esriFieldTypeString, alias: MAINT_LOG, length: 255 )
• TRAP_CLEANED_REG ( type: esriFieldTypeString, alias: TRAP_CLEANED_REG, length: 255 )
• DATE_CLEANED ( type: esriFieldTypeDate, alias: DATE_CLEANED, length: 8 )
• CLEANED_BY ( type: esriFieldTypeString, alias: CLEANED_BY, length: 255 )
• EFFECTIVE_VOLUME ( type: esriFieldTypeString, alias: EFFECTIVE_VOLUME, length: 255 )
• FOG_DEPTH_REPORT ( type: esriFieldTypeString, alias: FOG_DEPTH_REPORT, length: 255 )
• GALS_PUMPED ( type: esriFieldTypeString, alias: GALS_PUMPED, length: 255 )
• LOG_SIGNED ( type: esriFieldTypeString, alias: LOG_SIGNED, length: 255 )
• STAFF_TRAINED_BMP ( type: esriFieldTypeString, alias: STAFF_TRAINED_BMP, length: 255 )
• GREASE_SIGN ( type: esriFieldTypeString, alias: GREASE_SIGN, length: 255 )
• RECYCLE_REC ( type: esriFieldTypeString, alias: RECYCLE_REC, length: 255 )
• FOOD_WASTE_DISP ( type: esriFieldTypeString, alias: FOOD_WASTE_DISP, length: 255 )
• FOG_SYS_COVERED ( type: esriFieldTypeString, alias: FOG_SYS_COVERED, length: 255 )
• STORM_PROECTION ( type: esriFieldTypeString, alias: STORM_PROECTION, length: 255 )
• SPP_AVAILABLE ( type: esriFieldTypeString, alias: SPP_AVAILABLE, length: 255 )
• EXHAUST_UNITS ( type: esriFieldTypeString, alias: EXHAUST_UNITS, length: 255 )
• CLEAN_FREQ ( type: esriFieldTypeString, alias: CLEAN_FREQ, length: 255 )
• CLEAN_EQUIP ( type: esriFieldTypeString, alias: CLEAN_EQUIP, length: 255 )
• EQUIP_STATE ( type: esriFieldTypeString, alias: EQUIP_STATE, length: 255 )
• ADDRESS_LINK ( type: esriFieldTypeString, alias: ADDRESS_LINK, length: 100 )

Layer: IPP (5)

Name: IPP

Display Field: bussiness_name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 10000

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: 897415.6002227515
YMin: 753821.329934895
XMax: 943049.8301483244
YMax: 785932.9264727235
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSBackwardDiagonal
Color: [132, 0, 168, 255]
Outline:
Style: esriSLSSolid
Color: [132, 0, 168, 255]
Width: 3
Label:
Description:
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


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 )
• map_block_lot ( type: esriFieldTypeString, alias: map_block_lot, length: 255 )
• bussiness_name ( type: esriFieldTypeString, alias: bussiness_name, length: 255 )
• description_1 ( type: esriFieldTypeString, alias: description_1, length: 255 )
• unique_id ( type: esriFieldTypeString, alias: unique_id, length: 50 )
• insp_date ( type: esriFieldTypeDate, alias: insp_date, length: 8 )
• shape ( type: esriFieldTypeGeometry, alias: Shape )
• shape.STArea() ( type: esriFieldTypeDouble, alias: shape.STArea() )
• shape.STLength() ( type: esriFieldTypeDouble, alias: shape.STLength() )

Layer: IPP Inspected (55)

Name: IPP Inspected

Display Field: bussiness_name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Min Scale: 10000

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: 897415.6002227515
YMin: 753821.329934895
XMax: 943049.8301483244
YMax: 785932.9264727235
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [115, 178, 115, 255]
Outline:
Style: esriSLSNull
Color: [110, 110, 110, 255]
Width: 0
Label:
Description:
Transparency: 65
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


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 )
• map_block_lot ( type: esriFieldTypeString, alias: map_block_lot, length: 255 )
• bussiness_name ( type: esriFieldTypeString, alias: bussiness_name, length: 255 )
• description_1 ( type: esriFieldTypeString, alias: description_1, length: 255 )
• unique_id ( type: esriFieldTypeString, alias: unique_id, length: 50 )
• insp_date ( type: esriFieldTypeDate, alias: insp_date, length: 8 )
• shape ( type: esriFieldTypeGeometry, alias: Shape )
• shape.STArea() ( type: esriFieldTypeDouble, alias: shape.STArea() )
• shape.STLength() ( type: esriFieldTypeDouble, alias: shape.STLength() )

Layer: Parcels (10)

Name: Parcels

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

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: 905806.5453829765
YMin: 748259.7101525664
XMax: 943373.0201186389
YMax: 785083.689982146
Spatial Reference: 102656  (2234)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [0, 0, 0, 0]
Outline:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 0
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• UNIQUE_ID ( type: esriFieldTypeString, alias: unique_id, length: 25 )
• MBL ( type: esriFieldTypeString, alias: mbl, length: 50 )
• MBLU ( type: esriFieldTypeString, alias: mblu, length: 50 )
• Description ( type: esriFieldTypeString, alias: description, length: 255 )
• STREET_UNI_1 ( type: esriFieldTypeString, alias: street_uni_1, length: 11 )
• COMMENT ( type: esriFieldTypeString, alias: comment, length: 50 )
• MAP ( type: esriFieldTypeString, alias: map, length: 255 )
• BLOCK ( type: esriFieldTypeString, alias: block, length: 255 )
• LOT ( type: esriFieldTypeString, alias: lot, length: 255 )
• UNIT ( type: esriFieldTypeString, alias: unit, length: 255 )
• NUM_STREET ( type: esriFieldTypeDouble, alias: num_street )
• STREET_NUMBER ( type: esriFieldTypeString, alias: street_number, length: 255 )
• STREET_NAME ( type: esriFieldTypeString, alias: street_name, length: 255 )
• LOCATION ( type: esriFieldTypeString, alias: location, length: 255 )
• OWNER ( type: esriFieldTypeString, alias: owner, length: 255 )
• OWNER2 ( type: esriFieldTypeString, alias: owner2, length: 255 )
• MAILADDR ( type: esriFieldTypeString, alias: mailaddr, length: 255 )
• MAILCITY ( type: esriFieldTypeString, alias: mailcity, length: 255 )
• MAILSTATE ( type: esriFieldTypeString, alias: mailstate, length: 255 )
• MAILZIP ( type: esriFieldTypeString, alias: mailzip, length: 255 )
• VOLUME ( type: esriFieldTypeString, alias: volume, length: 255 )
• PAGE ( type: esriFieldTypeString, alias: page, length: 255 )
• NBHD ( type: esriFieldTypeString, alias: nbhd, length: 255 )
• ZONE1 ( type: esriFieldTypeString, alias: zone1, length: 255 )
• PRIMARY_USE ( type: esriFieldTypeString, alias: primary_use, length: 255 )
• ACRES ( type: esriFieldTypeString, alias: acres, length: 255 )
• APP_BLDG ( type: esriFieldTypeString, alias: app_bldg, length: 255 )
• TAX_BLDG ( type: esriFieldTypeString, alias: tax_bldg, length: 255 )
• APP_LAND ( type: esriFieldTypeString, alias: app_land, length: 255 )
• TAX_LAND ( type: esriFieldTypeString, alias: tax_land, length: 255 )
• APP_OUTB ( type: esriFieldTypeString, alias: app_outb, length: 255 )
• TAX_OUTB ( type: esriFieldTypeString, alias: tax_outb, length: 255 )
• APP_TOTAL ( type: esriFieldTypeString, alias: app_total, length: 255 )
• TAX_TOTAL ( type: esriFieldTypeString, alias: tax_total, length: 255 )
• CONDO ( type: esriFieldTypeString, alias: condo, length: 10 )
• LOT_LABEL ( type: esriFieldTypeSmallInteger, alias: lot_label )
• Police_Points ( type: esriFieldTypeString, alias: police_points, length: 50 )
• Police_Notes ( type: esriFieldTypeString, alias: police_notes, length: 50 )
• Sale_Date ( type: esriFieldTypeDate, alias: sale_date, length: 8 )
• Year_Built ( type: esriFieldTypeSmallInteger, alias: year_built )
• Total_Living_Area ( type: esriFieldTypeSmallInteger, alias: total_living_area )
• Design_Type ( type: esriFieldTypeString, alias: design_type, length: 50 )
• Bedrooms ( type: esriFieldTypeSmallInteger, alias: bedrooms )
• Full_Baths ( type: esriFieldTypeSmallInteger, alias: full_baths )
• Half_Baths ( type: esriFieldTypeSmallInteger, alias: half_baths )
• Edit_Date ( type: esriFieldTypeString, alias: edit_date, length: 50 )
• Edit_Type ( type: esriFieldTypeString, alias: edit_type, length: 50 )
• Edit_Source ( type: esriFieldTypeString, alias: edit_source, length: 255 )
• Edit_Notes ( type: esriFieldTypeString, alias: edit_notes, length: 50 )
• GIS_ZONE ( type: esriFieldTypeString, alias: gis_zone, length: 15 )
• DEV_NUM ( type: esriFieldTypeString, alias: dev_num, length: 25 )
• DEV_NUM2 ( type: esriFieldTypeString, alias: dev_num2, length: 25 )
• GIS_Acres ( type: esriFieldTypeDouble, alias: gis_acres )
• CAMA_Acres ( type: esriFieldTypeDouble, alias: cama_acres )
• Acre_Diff ( type: esriFieldTypeDouble, alias: acre_diff )
• LAT ( type: esriFieldTypeDouble, alias: lat )
• LON ( type: esriFieldTypeDouble, alias: lon )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: shape.STLength() )
• Unique_ID_1 ( type: esriFieldTypeString, alias: Unique_ID_1, length: 25 )
• MBL_1 ( type: esriFieldTypeString, alias: MBL_1, length: 25 )
• MBLU_1 ( type: esriFieldTypeString, alias: MBLU_1, length: 30 )
• MAP_1 ( type: esriFieldTypeString, alias: MAP_1, length: 4 )
• BLOCK_1 ( type: esriFieldTypeString, alias: BLOCK_1, length: 4 )
• LOT_1 ( type: esriFieldTypeString, alias: LOT_1, length: 4 )
• UNIT_1 ( type: esriFieldTypeString, alias: UNIT_1, length: 4 )
• NUM_STREET_1 ( type: esriFieldTypeDouble, alias: NUM_STREET_1 )
• STREET_NUMBER_1 ( type: esriFieldTypeString, alias: STREET_NUMBER_1, length: 10 )
• STREET_NAME_1 ( type: esriFieldTypeString, alias: STREET_NAME_1, length: 30 )
• LOCATION_1 ( type: esriFieldTypeString, alias: LOCATION_1, length: 41 )
• OWNER_1 ( type: esriFieldTypeString, alias: OWNER_1, length: 40 )
• OWNER2_1 ( type: esriFieldTypeString, alias: OWNER2_1, length: 40 )
• MAILADDR_1 ( type: esriFieldTypeString, alias: MAILADDR_1, length: 40 )
• MAILCITY_1 ( type: esriFieldTypeString, alias: MAILCITY_1, length: 40 )
• MAILSTATE_1 ( type: esriFieldTypeString, alias: MAILSTATE_1, length: 2 )
• MAILZIP_1 ( type: esriFieldTypeString, alias: MAILZIP_1, length: 9 )
• VOLUME_1 ( type: esriFieldTypeString, alias: VOLUME_1, length: 5 )
• PAGE_1 ( type: esriFieldTypeString, alias: PAGE_1, length: 5 )
• NBHD_1 ( type: esriFieldTypeString, alias: NBHD_1, length: 100 )
• ZONE_ ( type: esriFieldTypeString, alias: ZONE_, length: 100 )
• PRIMARY_USE_1 ( type: esriFieldTypeString, alias: PRIMARY_USE_1, length: 100 )
• ACRES_1 ( type: esriFieldTypeDouble, alias: ACRES_1 )
• APP_BLDG_1 ( type: esriFieldTypeString, alias: APP_BLDG_1, length: 41 )
• TAX_BLDG_1 ( type: esriFieldTypeString, alias: TAX_BLDG_1, length: 41 )
• APP_LAND_1 ( type: esriFieldTypeString, alias: APP_LAND_1, length: 41 )
• TAX_LAND_1 ( type: esriFieldTypeString, alias: TAX_LAND_1, length: 41 )
• APP_OUTB_1 ( type: esriFieldTypeString, alias: APP_OUTB_1, length: 41 )
• TAX_OUTB_1 ( type: esriFieldTypeString, alias: TAX_OUTB_1, length: 41 )
• APP_TOTAL_1 ( type: esriFieldTypeString, alias: APP_TOTAL_1, length: 41 )
• TAX_TOTAL_1 ( type: esriFieldTypeString, alias: TAX_TOTAL_1, length: 41 )

Tables:

Table: sedaSewerMainHistory (100)

Name: sedaSewerMainHistory

Display Field: workby

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• workby ( type: esriFieldTypeString, alias: OperatedBy, length: 30 )
• assetkey ( type: esriFieldTypeString, alias: PipelineID, length: 30 )
• workdate ( type: esriFieldTypeDate, alias: DateStamp, length: 8 )
• comments ( type: esriFieldTypeString, alias: comments, length: 1000 )
• worktype ( type: esriFieldTypeString, alias: worktype, length: 40 )
• attachmentid01 ( type: esriFieldTypeInteger, alias: attachmentid01 )
• attachmentid02 ( type: esriFieldTypeInteger, alias: attachmentid02 )
• frommh ( type: esriFieldTypeString, alias: frommh, length: 20 )
• tomh ( type: esriFieldTypeString, alias: tomh, length: 20 )
• direction ( type: esriFieldTypeString, alias: direction, length: 30 , Coded Values: [Downstream: Downstream] , [Upstream: Upstream] )
• subsection ( type: esriFieldTypeString, alias: subsection, length: 30 )
• feetjetted ( type: esriFieldTypeDouble, alias: feetjetted )
• nozzletype ( type: esriFieldTypeString, alias: nozzletype, length: 30 , Coded Values: [Regular Nozzle: Regular Nozzle] , [Cutter: Cutter] )
• clean ( type: esriFieldTypeString, alias: clean, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• rocks ( type: esriFieldTypeString, alias: rocks, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• grit ( type: esriFieldTypeString, alias: grit, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• grease ( type: esriFieldTypeString, alias: Grease, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• septic ( type: esriFieldTypeString, alias: septic, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• mud ( type: esriFieldTypeString, alias: mud, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• roots ( type: esriFieldTypeString, alias: Roots, length: 10 , Coded Values: [Light: Light] , [Medium: Medium] , [Heavy: Heavy] , ...1 more... )
• rags ( type: esriFieldTypeString, alias: rags, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• trash ( type: esriFieldTypeString, alias: trash, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• sticks ( type: esriFieldTypeString, alias: sticks, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• detritus ( type: esriFieldTypeString, alias: detritus, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• otherconditions ( type: esriFieldTypeString, alias: otherconditions, length: 250 )
• locations ( type: esriFieldTypeString, alias: locations, length: 250 )
• start ( type: esriFieldTypeDate, alias: start, length: 8 )
• finish ( type: esriFieldTypeDate, alias: finish, length: 8 )
• timeduration ( type: esriFieldTypeDouble, alias: timeduration )
• datescheduled ( type: esriFieldTypeDate, alias: datescheduled, length: 8 )
• datecompleted ( type: esriFieldTypeDate, alias: datecompleted, length: 8 )
• crewcontractor ( type: esriFieldTypeString, alias: crewcontractor, length: 50 )
• attachedinvoice ( type: esriFieldTypeString, alias: attachedinvoice, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• hoursworked ( type: esriFieldTypeDouble, alias: hoursworked )
• equipment ( type: esriFieldTypeString, alias: equipment, length: 250 )
• totalcost ( type: esriFieldTypeDouble, alias: totalcost )
• sectionrepaired ( type: esriFieldTypeString, alias: sectionrepaired, length: 50 , Coded Values: [I&I: I&I] , [Sag: Sag] , [Crack: Crack] , ...2 more... )
• cleaningtype ( type: esriFieldTypeString, alias: cleaningtype, length: 30 , Coded Values: [Roots: Roots] , [Grease: Grease] , [Silt/Rock/Deposit: Silt/Rock/Deposit] )
• lengthrepaired ( type: esriFieldTypeDouble, alias: lengthrepaired )
• material ( type: esriFieldTypeString, alias: material, length: 250 )
• diameter ( type: esriFieldTypeDouble, alias: diameter )
• repairmethod ( type: esriFieldTypeString, alias: repairmethod, length: 30 , Coded Values: [Replaced: Replaced] , [CIP: CIP] , [Gunite: Gunite] )
• smokedyedate ( type: esriFieldTypeDate, alias: smokedyedate, length: 8 )
• smokedycrew ( type: esriFieldTypeString, alias: smokedycrew, length: 100 )
• smokedyeaddress ( type: esriFieldTypeString, alias: smokedyeaddress, length: 100 )
• issueconcern ( type: esriFieldTypeString, alias: issueconcern, length: 50 , Coded Values: [I&I: I&I] , [Connection/Permit Verification: Connection/Permit Verification] , [Upstream/Downstream Verification: Upstream/Downstream Verification] )
• smokedyeactivity ( type: esriFieldTypeString, alias: smokedyeactivity, length: 50 , Coded Values: [Flow Monitoring: Flow Monitoring] , [Flow Isolations: Flow Isolations] , [Smoke Testing: Smoke Testing] , ...4 more... )
• feetintoline ( type: esriFieldTypeDouble, alias: feetintoline )
• cctv_length ( type: esriFieldTypeDouble, alias: cctv_length )
• cctv_comments ( type: esriFieldTypeString, alias: cctv_comments, length: 1000 )
• cctv_level ( type: esriFieldTypeString, alias: cctv_level, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• cctv_roots ( type: esriFieldTypeString, alias: cctv_roots, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• cctv_sag ( type: esriFieldTypeString, alias: cctv_sag, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• cctv_ini ( type: esriFieldTypeString, alias: cctv_ini, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• cctv_rockdeposits ( type: esriFieldTypeString, alias: cctv_rockdeposits, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• cctv_brokenpipe ( type: esriFieldTypeString, alias: cctv_brokenpipe, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• cctv_offsetpipe ( type: esriFieldTypeString, alias: cctv_offsetpipe, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• cctv_grease ( type: esriFieldTypeString, alias: cctv_grease, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• cameraunderwater ( type: esriFieldTypeString, alias: cameraunderwater, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• cctv_leak ( type: esriFieldTypeString, alias: cctv_leak, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• correectiveaction ( type: esriFieldTypeString, alias: correectiveaction, length: 50 )
• actionsschedule ( type: esriFieldTypeDate, alias: actionsschedule, length: 8 )
• acionstatus ( type: esriFieldTypeString, alias: acionstatus, length: 50 )
• cip_type ( type: esriFieldTypeString, alias: cip_type, length: 50 )
• maint_type ( type: esriFieldTypeString, alias: maint_type, length: 50 )
• noactionreason ( type: esriFieldTypeString, alias: noactionreason, length: 50 )
• cctv_crack ( type: esriFieldTypeString, alias: cctv_crack, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• jetting_dir ( type: esriFieldTypeString, alias: jetting_dir, length: 20 , Coded Values: [With Flow: With Flow] , [Against Flow: Against Flow] )
• camera_dir ( type: esriFieldTypeString, alias: camera_dir, length: 20 , Coded Values: [With Flow: With Flow] , [Against Flow: Against Flow] )
• wocomments ( type: esriFieldTypeString, alias: wocomments, length: 1073741822 )
• wodescription ( type: esriFieldTypeString, alias: wodescription, length: 255 )
• Date ( type: esriFieldTypeDate, alias: Date, length: 8 )
• Crew ( type: esriFieldTypeString, alias: Crew, length: 50 )
• Street ( type: esriFieldTypeString, alias: Street, length: 50 )
• Sub_Basin ( type: esriFieldTypeString, alias: Sub_Basin, length: 50 )
• USMH ( type: esriFieldTypeString, alias: USMH, length: 50 )
• DSMH ( type: esriFieldTypeString, alias: DSMH, length: 50 )
• Pipe_Length ( type: esriFieldTypeString, alias: Pipe_Length, length: 50 )
• Measure_Code ( type: esriFieldTypeString, alias: Measure_Code, length: 50 , Coded Values: [1 (GIS): 1 (GIS)] , [2 (Wheeled): 2 (Wheeled)] , [3 (Tape): 3 (Tape)] , ...1 more... )
• Inspection_Status ( type: esriFieldTypeString, alias: Inspection_Status, length: 50 , Coded Values: [1 (C.N.L): 1 (C.N.L)] , [2 (D.N.E): 2 (D.N.E)] , [3 (Buried MH): 3 (Buried MH)] , ...4 more... )
• Temperature ( type: esriFieldTypeString, alias: Temperature, length: 50 , Coded Values: [1 (110-90 degrees): 1 (110-90 degrees)] , [2 (90-80): 2 (90-80)] , [3 (80-70): 3 (80-70)] , ...1 more... )
• Precipitation ( type: esriFieldTypeString, alias: Precipitation, length: 50 , Coded Values: [1 (Dry): 1 (Dry)] , [2 (Drizzle): 2 (Drizzle)] , [3 (Rain): 3 (Rain)] )
• Ground_Condition ( type: esriFieldTypeString, alias: Ground_Condition, length: 50 , Coded Values: [1 (Dry): 1 (Dry)] , [2 (Moist): 2 (Moist)] , [3 (Wet): 3 (Wet)] , ...1 more... )
• Last_Rain_Event ( type: esriFieldTypeDate, alias: Last_Rain_Event, length: 8 )
• Over_All_Comments ( type: esriFieldTypeString, alias: Over_All_Comments, length: 50 )
• Site_Sketch ( type: esriFieldTypeInteger, alias: Site_Sketch )
• Site_Sketch2 ( type: esriFieldTypeInteger, alias: Site_Sketch2 )
• Defect_1_Location ( type: esriFieldTypeString, alias: Defect_1_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_1_Address ( type: esriFieldTypeString, alias: Defect_1_Address, length: 50 )
• Defect_1_Type ( type: esriFieldTypeString, alias: Defect_1_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_1_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_1_Footage_From_USMH, length: 50 )
• Defect_1_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_1_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_1_Tributary_Area ( type: esriFieldTypeString, alias: Defect_1_Tributary_Area, length: 50 )
• Defect_1_Comment ( type: esriFieldTypeString, alias: Defect_1_Comment, length: 50 )
• Defect_1_Photo ( type: esriFieldTypeInteger, alias: Defect_1_Photo )
• Defect_2_Location ( type: esriFieldTypeString, alias: Defect_2_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_2_Address ( type: esriFieldTypeString, alias: Defect_2_Address, length: 50 )
• Defect_2_Type ( type: esriFieldTypeString, alias: Defect_2_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_2_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_2_Footage_From_USMH, length: 50 )
• Defect_2_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_2_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_2_Tributary_Area ( type: esriFieldTypeString, alias: Defect_2_Tributary_Area, length: 50 )
• Defect_2_Comment ( type: esriFieldTypeString, alias: Defect_2_Comment, length: 50 )
• Defect_2_Photo ( type: esriFieldTypeInteger, alias: Defect_2_Photo )
• Defect_3_Location ( type: esriFieldTypeString, alias: Defect_3_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_3_Address ( type: esriFieldTypeString, alias: Defect_3_Address, length: 50 )
• Defect_3_Type ( type: esriFieldTypeString, alias: Defect_3_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_3_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_3_Footage_From_USMH, length: 50 )
• Defect_3_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_3_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_3_Tributary_Area ( type: esriFieldTypeString, alias: Defect_3_Tributary_Area, length: 50 )
• Defect_3_Comment ( type: esriFieldTypeString, alias: Defect_3_Comment, length: 50 )
• Defect_3_Photo ( type: esriFieldTypeInteger, alias: Defect_3_Photo )
• Defect_4_Location ( type: esriFieldTypeString, alias: Defect_4_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_4_Address ( type: esriFieldTypeString, alias: Defect_4_, length: 50 )
• Defect_4_Type ( type: esriFieldTypeString, alias: Defect_4_, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_4_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_4_Footage_From_USMH, length: 50 )
• Defect_4_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_4_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_4_Tributary_Area ( type: esriFieldTypeString, alias: Defect_4_Tributary_Area, length: 50 )
• Defect_4_Comment ( type: esriFieldTypeString, alias: Defect_4_Comment, length: 50 )
• Defect_4_Photo ( type: esriFieldTypeInteger, alias: Defect_4_Photo )
• Defect_5_Location ( type: esriFieldTypeString, alias: Defect_5_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_5_Address ( type: esriFieldTypeString, alias: Defect_5_Address, length: 50 )
• Defect_5_Type ( type: esriFieldTypeString, alias: Defect_5_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_5_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_5_Footage_From_USMH, length: 50 )
• Defect_5_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_5_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_5_Tributary_Area ( type: esriFieldTypeString, alias: Defect_5_Tributary_Area, length: 50 )
• Defect_5_Comment ( type: esriFieldTypeString, alias: Defect_5_Comment, length: 50 )
• Defect_5_Photo ( type: esriFieldTypeInteger, alias: Defect_5_Photo )
• Defect_6_Location ( type: esriFieldTypeString, alias: Defect_6_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_6_Address ( type: esriFieldTypeString, alias: Defect_6_Address, length: 50 )
• Defect_6_Type ( type: esriFieldTypeString, alias: Defect_6_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_6_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_6_Footage_From_USMH, length: 50 )
• Defect_6_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_6_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_6_Tributary_Area ( type: esriFieldTypeString, alias: Defect_6_Tributary_Area, length: 50 )
• Defect_6_Comment ( type: esriFieldTypeString, alias: Defect_6_Comment, length: 50 )
• Defect_6_Photo ( type: esriFieldTypeInteger, alias: Defect_6_Photo )
• Defect_7_Location ( type: esriFieldTypeString, alias: Defect_7_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_7_Address ( type: esriFieldTypeString, alias: Defect_7_Address, length: 50 )
• Defect_7_Type ( type: esriFieldTypeString, alias: Defect_7_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_7_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_7_Footage_From_USMH, length: 50 )
• Defect_7_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_7_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_7_Tributary_Area ( type: esriFieldTypeString, alias: Defect_7_Tributary_Area, length: 50 )
• Defect_7_Comment ( type: esriFieldTypeString, alias: Defect_7_Comment, length: 50 )
• Defect_7_Photo ( type: esriFieldTypeInteger, alias: Defect_7_Photo )
• Defect_8_Location ( type: esriFieldTypeString, alias: Defect_8_, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_8_Address ( type: esriFieldTypeString, alias: Defect_8_Address, length: 50 )
• Defect_8_Type ( type: esriFieldTypeString, alias: Defect_8_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_8_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_8_Footage_From_USMH, length: 50 )
• Defect_8_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_8_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_8_Tributary_Area ( type: esriFieldTypeString, alias: Defect_8_Tributary_Area, length: 50 )
• Defect_8_Comment ( type: esriFieldTypeString, alias: Defect_8_Comment, length: 50 )
• Defect_8_Photo ( type: esriFieldTypeInteger, alias: Defect_8_Photo )
• Defect_9_Location ( type: esriFieldTypeString, alias: Defect_9_, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_9_Address ( type: esriFieldTypeString, alias: Defect_9_Address, length: 50 )
• Defect_9_Type ( type: esriFieldTypeString, alias: Defect_9_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_9_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_9_Footage_From_USMH, length: 50 )
• Defect_9_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_9_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_9_Tributary_Area ( type: esriFieldTypeString, alias: Defect_9_Tributary_Area, length: 50 )
• Defect_9_Comment ( type: esriFieldTypeString, alias: Defect_9_, length: 50 )
• Defect_9_Photo ( type: esriFieldTypeInteger, alias: Defect_9_Photo )
• Defect_10_Location ( type: esriFieldTypeString, alias: Defect_10_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_10_Address ( type: esriFieldTypeString, alias: Defect_10_Address, length: 50 )
• Defect_10_Type ( type: esriFieldTypeString, alias: Defect_10_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_10_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_10_Footage_From_USMH, length: 50 )
• Defect_10_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_10_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_10_Tributary_Area ( type: esriFieldTypeString, alias: Defect_10_Tributary_Area, length: 50 )
• Defect_10_Comment ( type: esriFieldTypeString, alias: Defect_10_Comment, length: 50 )
• Defect_10_Photo ( type: esriFieldTypeInteger, alias: Defect_10_Photo )

Table: sedaManholeHistory (101)

Name: sedaManholeHistory

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: ManholeID, length: 30 )
• workby ( type: esriFieldTypeString, alias: WorkBy, length: 30 , Coded Values: [Staff: Staff] , [Contractor: Contractor] )
• workdate ( type: esriFieldTypeDate, alias: DateStamp, length: 8 )
• mhdepth ( type: esriFieldTypeDouble, alias: mhdepth )
• dropmanhole ( type: esriFieldTypeString, alias: dropmanhole, length: 10 , Coded Values: [Inside: Inside] , [Outside: Outside] , [No: No] )
• comments ( type: esriFieldTypeString, alias: comments, length: 1000 )
• worktype ( type: esriFieldTypeString, alias: worktype, length: 50 )
• attachmentid01 ( type: esriFieldTypeInteger, alias: attachmentid01 )
• attachmentid02 ( type: esriFieldTypeInteger, alias: attachmentid02 )
• waterway ( type: esriFieldTypeString, alias: waterway, length: 50 )
• mhcovercondition ( type: esriFieldTypeString, alias: mhcovercondition, length: 30 , Coded Values: [Worn: Worn] , [Sound: Sound] , [Cracked: Cracked] , ...6 more... )
• mhcovertype ( type: esriFieldTypeString, alias: mhcovertype, length: 50 , Coded Values: [Standard - 1 hole in center: Standard - 1 hole in center] , [Standard – No hole: Standard – No hole] , [Standard – Many holes: Standard – Many holes] , ...6 more... )
• mhcoversize ( type: esriFieldTypeString, alias: mhcoversize, length: 10 , Coded Values: [24: 24] , [30: 30] , [36: 36] , ...1 more... )
• locking ( type: esriFieldTypeString, alias: locking, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• mhcoverlabel ( type: esriFieldTypeInteger, alias: mhcoverlable , Coded Values: [1: WSD] , [2: WSS] , [3: Storm] , ...6 more... )
• ringframecond ( type: esriFieldTypeString, alias: ringframecond, length: 30 , Coded Values: [Serviceable: Serviceable] , [Unsafe: Unsafe] , [Missing: Missing] , ...1 more... )
• ringframegrade ( type: esriFieldTypeString, alias: ringframegrade, length: 30 , Coded Values: [Good: Good] , [Needs Raising: Needs Raising] , [Needs Lowering: Needs Lowering] )
• mhmaterial ( type: esriFieldTypeString, alias: mhmaterial, length: 30 , Coded Values: [Brick: Brick] , [Concrete Block: Concrete Block] , [Asbestos Cement: Asbestos Cement] , ...13 more... )
• interceptor ( type: esriFieldTypeString, alias: interceptor, length: 30 )
• location ( type: esriFieldTypeString, alias: location, length: 100 , Coded Values: [Roadway: Roadway] , [Gutter: Gutter] , [Paved Alley: Paved Alley] , ...5 more... )
• mhlining ( type: esriFieldTypeString, alias: mhlining, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• stepconditon ( type: esriFieldTypeString, alias: stepconditon, length: 30 , Coded Values: [Serviceable: Serviceable] , [Unsafe: Unsafe] , [Missing: Missing] , ...1 more... )
• conecondition ( type: esriFieldTypeString, alias: conecondition, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken: Broken] , [Sulfided: Sulfided] , ...2 more... )
• risercondition ( type: esriFieldTypeString, alias: risercondition, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken: Broken] , [Sulfided: Sulfided] , ...3 more... )
• shelftype ( type: esriFieldTypeString, alias: shelftype, length: 30 , Coded Values: [Brick: Brick] , [Concrete/PreCast: Concrete/PreCast] )
• shelfcondition ( type: esriFieldTypeString, alias: shelfcondition, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken: Broken] , [Dirty: Dirty] , ...2 more... )
• channelcondition ( type: esriFieldTypeString, alias: channelcondition, length: 30 , Coded Values: [Serviceable: Serviceable] , [Obstructed: Obstructed] , [Sulfided: Sulfided] , ...2 more... )
• flow ( type: esriFieldTypeString, alias: flow, length: 30 , Coded Values: [Steady: Steady] , [Pulsing: Pulsing] , [Turbulent: Turbulent] , ...4 more... )
• ini ( type: esriFieldTypeString, alias: ini, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• flowdepth ( type: esriFieldTypeDouble, alias: flowdepth )
• weather ( type: esriFieldTypeString, alias: weather, length: 30 , Coded Values: [Dry: Dry] , [Heavy Rain: Heavy Rain] , [Light Rain: Light Rain] , ...4 more... )
• surchargeevidence ( type: esriFieldTypeString, alias: surchargeevidence, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• depthstatus ( type: esriFieldTypeString, alias: depthstatus, length: 20 , Coded Values: [Changed: Changed] , [Verified: Verified] )
• ssodate ( type: esriFieldTypeDate, alias: ssodate, length: 8 )
• ssoasset ( type: esriFieldTypeString, alias: ssoasset, length: 30 , Coded Values: [Manhole: Manhole] , [Sanitary Sewer: Sanitary Sewer] , [Pump Station: Pump Station] , ...4 more... )
• bypass_cause ( type: esriFieldTypeString, alias: bypass_cuase, length: 250 , Coded Values: [Construction/Repairs: Construction/Repairs] , [Obstruction: Obstruction] , [Grease: Grease] , ...3 more... )
• ssoblockage_type ( type: esriFieldTypeString, alias: blockage_type, length: 50 , Coded Values: [Grease: Grease] , [Debris: Debris] , [Collapse: Collapse] , ...2 more... )
• substandardcond ( type: esriFieldTypeString, alias: substandardcond, length: 30 , Coded Values: [Electrical: Electrical] , [Mechanical: Mechanical] , [Structural: Structural] , ...4 more... )
• substandard_practice ( type: esriFieldTypeString, alias: substandard_practice, length: 50 )
• sso_spill_loc ( type: esriFieldTypeString, alias: sso_spill_loc, length: 30 , Coded Values: [Ground: Ground] , [Street: Street] , [Surface Water: Surface Water] , ...1 more... )
• spill_locname ( type: esriFieldTypeString, alias: spill_locname, length: 100 )
• sso_duration ( type: esriFieldTypeDouble, alias: sso_duration )
• sso_galsreleased ( type: esriFieldTypeDouble, alias: sso_galsreleased )
• sso_cleanmethod ( type: esriFieldTypeString, alias: sso_cleanmethod, length: 50 , Coded Values: [Jetting: Jetting] , [Clamming: Clamming] )
• sso_lastevent ( type: esriFieldTypeDate, alias: sso_lastevent, length: 8 )
• sso_preventaction ( type: esriFieldTypeString, alias: ss0_preventaction, length: 50 , Coded Values: [CCTV: CCTV] , [CIPP: CIPP] , [Dig and Replace: Dig and Replace] , ...2 more... )
• sso_volume_estmeth ( type: esriFieldTypeString, alias: sso_volume_est, length: 30 , Coded Values: [Visual: Visual] , [Calculated: Calculated] , [Measured: Measured] )
• discovered ( type: esriFieldTypeDate, alias: discovered, length: 8 )
• stopped ( type: esriFieldTypeDate, alias: stopped, length: 8 )
• howdiscovered ( type: esriFieldTypeString, alias: howdiscovered, length: 30 )
• sso_resp_party ( type: esriFieldTypeString, alias: sso_resp_party, length: 250 )
• sso_investigatedby ( type: esriFieldTypeString, alias: sso_investigatedby, length: 50 , Coded Values: [Maurice Fortier: Maurice Fortier] , [Ken Ferreira: Ken Ferreira] , [Denis Cuevas: Denis Cuevas] , ...6 more... )
• address ( type: esriFieldTypeString, alias: address, length: 250 )
• sso_disinfectmethod ( type: esriFieldTypeString, alias: sso_disinfectmethod, length: 30 , Coded Values: [Sodium Hypochlorite: Sodium Hypochlorite] , [Lime: Lime] , [None: None] )
• sso_correctiveaction ( type: esriFieldTypeString, alias: sso_correctiveaction, length: 50 , Coded Values: [Change in Conveyance: Change in Conveyance] , [Dig and Replace: Dig and Replace] , [Jet or Vac Line: Jet or Vac Line] , ...1 more... )
• notify_deep2hr ( type: esriFieldTypeString, alias: notify_deep2hr, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• notify_deep5day ( type: esriFieldTypeString, alias: notify_deep5day, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• chimneymaterial ( type: esriFieldTypeString, alias: chimneymaterial, length: 30 , Coded Values: [Brick: Brick] , [Plastic: Plastic] , [Concrete/Precast: Concrete/Precast] , ...1 more... )
• chimneycondition ( type: esriFieldTypeString, alias: chimneycondition, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken: Broken] , [Sulfided: Sulfided] , ...2 more... )
• wallcondition ( type: esriFieldTypeString, alias: wallcondition, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken: Broken] , [Sulfided: Sulfided] , ...3 more... )
• datescheduled ( type: esriFieldTypeDate, alias: datescheduled, length: 8 )
• datecompleted ( type: esriFieldTypeDate, alias: datecompleted, length: 8 )
• crewcontractor ( type: esriFieldTypeString, alias: crewcontractor, length: 50 )
• hoursworked ( type: esriFieldTypeDouble, alias: hoursworked )
• totalcost ( type: esriFieldTypeDouble, alias: totalcost )
• sectionrepaired ( type: esriFieldTypeString, alias: sectionrepaired, length: 50 , Coded Values: [Ring: Ring] , [Chimney: Chimney] , [Bench: Bench] , ...9 more... )
• repairsize ( type: esriFieldTypeDouble, alias: repairsize )
• quoteattached ( type: esriFieldTypeString, alias: quoteattached, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• equipment ( type: esriFieldTypeString, alias: equipment, length: 250 )
• material ( type: esriFieldTypeString, alias: material, length: 250 )
• ringcondition ( type: esriFieldTypeString, alias: ringcondition, length: 50 , Coded Values: [Sound: Sound] , [Worn: Worn] , [Cracked: Cracked] , ...5 more... )
• framecondition ( type: esriFieldTypeString, alias: framecondition, length: 50 , Coded Values: [Serviceable: Serviceable] , [Worn: Worn] , [Loose: Loose] , ...4 more... )
• numberofrings ( type: esriFieldTypeSmallInteger, alias: numberofrings )
• repairtype ( type: esriFieldTypeString, alias: repairtype, length: 30 , Coded Values: [Corrective Maintenance: Corrective Maintenance] , [Preventative Maintenance: Preventative Maintenance] )
• ringrepair ( type: esriFieldTypeString, alias: ringrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• chimneyrepair ( type: esriFieldTypeString, alias: chimneyrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• benchrepair ( type: esriFieldTypeString, alias: benchrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• steprepair ( type: esriFieldTypeString, alias: steprepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• conerepair ( type: esriFieldTypeString, alias: conrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• wallrepair ( type: esriFieldTypeString, alias: wallrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• shelfrepair ( type: esriFieldTypeString, alias: shelfrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• coverrepair ( type: esriFieldTypeString, alias: coverrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• channelrepair ( type: esriFieldTypeString, alias: channelrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• dropinletrepair ( type: esriFieldTypeString, alias: dropinletrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• cert_no ( type: esriFieldTypeString, alias: cert_no, length: 20 , Coded Values: [U-313-17671: U-313-17671] , [U-313-17662: U-313-17662] , [U-313-17659: U-313-17659] , ...1 more... )
• insp_status ( type: esriFieldTypeString, alias: insp_status, length: 50 , Coded Values: [Internal Inspection: Internal Inspection] , [Surface Inspection: Surface Inspection] , [Not Found: Not Found] , ...6 more... )
• insp_purpose ( type: esriFieldTypeString, alias: insp_purpose, length: 50 , Coded Values: [Maintenance Related: Maintenance Related] , [I/I Study: I/I Study] , [Pre Rehab Survey: Pre Rehab Survey] , ...7 more... )
• loc_code ( type: esriFieldTypeString, alias: loc_code, length: 30 , Coded Values: [Main Hwy/4-Lane: Main Hwy/4-Lane] , [Main Hwy/2-Lane: Main Hwy/2-Lane] , [Local Roads: Local Roads] , ...12 more... )
• surf_type ( type: esriFieldTypeString, alias: surf_type, length: 30 , Coded Values: [Asphalt: Asphalt] , [Concrete/Pavement: Concrete/Pavement] , [Concrete Collar: Concrete Collar] , ...3 more... )
• runoff ( type: esriFieldTypeString, alias: runoff, length: 20 , Coded Values: [None: None] , [Sheeting: Sheeting] , [Ponding: Ponding] , ...1 more... )
• coverfit ( type: esriFieldTypeString, alias: coverfit, length: 30 , Coded Values: [Good: Good] , [Oversized - too tight: Oversized - too tight] , [Undersized - too loose: Undersized - too loose] , ...1 more... )
• frameoffset ( type: esriFieldTypeString, alias: frameoffset, length: 30 , Coded Values: [On Center: On Center] , [Off Center by 2-3": Off Center by 2-3"] , [Off Center by >3": Off Center by >3"] )
• framedepth ( type: esriFieldTypeString, alias: framedepth, length: 10 , Coded Values: [8": 8"] , [6": 6"] , [4": 4"] , ...1 more... )
• sealcondition ( type: esriFieldTypeString, alias: sealcondition, length: 30 , Coded Values: [Sound: Sound] , [Cracked: Cracked] , [Loose: Loose (Not Attached)] , ...3 more... )
• rungcondition ( type: esriFieldTypeString, alias: rungcondition, length: 30 , Coded Values: [Serviceable: Serviceable] , [None/Missing: None/Missing] , [Unsafe: Unsafe] , ...2 more... )
• surchevidence ( type: esriFieldTypeString, alias: surchevidence, length: 30 , Coded Values: [None: None] , [Grease/Debris on Shelf: Grease/Debris on Shelf] , [Grease/Debris on sides/Rungs: Grease/Debris on sides/Rungs] )
• mhmaterial2 ( type: esriFieldTypeString, alias: mhmaterial2, length: 30 , Coded Values: [None - No Coating: None - No Coating] , [Cementitious: Cementitious] , [Epoxy: Epoxy] , ...7 more... )
• chimneyi ( type: esriFieldTypeString, alias: chimneyi, length: 20 , Coded Values: [None: None] , [Weeper: Weeper] , [Dripper: Dripper] , ...3 more... )
• structurecondition ( type: esriFieldTypeString, alias: structurecondition, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken/Cracked: Broken/Cracked] , [Sulfided: Sulfided] , ...2 more... )
• conetype ( type: esriFieldTypeString, alias: conetype, length: 30 , Coded Values: [Flattop: Flattop] , [Conical - Centered: Conical - Centered] , [Conical - One Side: Conical - One Side] )
• structurecond2 ( type: esriFieldTypeString, alias: structurecond2, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken/Cracked: Broken/Cracked] , [Dirty: Dirty] , ...4 more... )
• chan_exposure ( type: esriFieldTypeString, alias: chan_exposure, length: 50 , Coded Values: [Open - > 50% visible: Open - > 50% visible] , [Partially Open - < 50% visible: Partially Open - < 50% visible] , [Closed – channel completely covered: Closed – channel completely covered] )
• structurecond3 ( type: esriFieldTypeString, alias: structurecond3, length: 50 , Coded Values: [Serviceable: Serviceable] , [Obstructed: Obstructed] , [Sulfided: Sulfided] , ...4 more... )
• channelconstruct ( type: esriFieldTypeString, alias: channelconstruct, length: 30 , Coded Values: [Sweeping 90: Sweeping 90] , [Sweeping Tee: Sweeping Tee] , [Sweeping Cross: Sweeping Cross] , ...5 more... )
• addl_pipes ( type: esriFieldTypeString, alias: addl_pipes, length: 10 , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...2 more... )
• flowclarity ( type: esriFieldTypeString, alias: flowclarity, length: 50 , Coded Values: [Turbid Sewage Appearance: Turbid Sewage Appearance] , [Clear Water Appearance: Clear Water Appearance] , [No Flow: No Flow] , ...1 more... )
• dropinlet ( type: esriFieldTypeString, alias: dropinlet, length: 50 , Coded Values: [Interior Drop - Serviceable: Interior Drop - Serviceable] , [Interior Drop - Not Serviceable: Interior Drop - Not Serviceable] , [Exterior Drop - Serviceable: Exterior Drop - Serviceable] , ...2 more... )
• distance_ft ( type: esriFieldTypeDouble, alias: distance_ft )
• subarea ( type: esriFieldTypeString, alias: subarea, length: 10 )
• conematerial ( type: esriFieldTypeString, alias: conematerial, length: 30 , Coded Values: [Brick: Brick] , [Concrete Block: Concrete Block] , [Asbestos Cement: Asbestos Cement] , ...13 more... )
• conecond ( type: esriFieldTypeString, alias: conecond, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken: Broken] , [Sulfided: Sulfided] , ...2 more... )
• coneii ( type: esriFieldTypeString, alias: coneii, length: 30 , Coded Values: [None: None] , [Weeper: Weeper] , [Dripper: Dripper] , ...3 more... )
• wallcond ( type: esriFieldTypeString, alias: wallcond, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken: Broken] , [Sulfided: Sulfided] , ...2 more... )
• wallmaterial ( type: esriFieldTypeString, alias: wallmaterial, length: 50 , Coded Values: [Brick: Brick] , [Concrete Block: Concrete Block] , [Asbestos Cement: Asbestos Cement] , ...13 more... )
• wallii ( type: esriFieldTypeString, alias: wallii, length: 30 , Coded Values: [None: None] , [Weeper: Weeper] , [Dripper: Dripper] , ...3 more... )
• benchmaterial ( type: esriFieldTypeString, alias: benchmaterial, length: 50 , Coded Values: [Brick: Brick] , [Concrete Block: Concrete Block] , [Asbestos Cement: Asbestos Cement] , ...13 more... )
• benchcond ( type: esriFieldTypeString, alias: benchcond, length: 50 , Coded Values: [Serviceable: Serviceable] , [Broken/Cracked: Broken/Cracked] , [Dirty: Dirty] , ...3 more... )
• benchii ( type: esriFieldTypeString, alias: benchii, length: 30 , Coded Values: [None: None] , [Weeper: Weeper] , [Dripper: Dripper] , ...3 more... )
• channelmaterial ( type: esriFieldTypeString, alias: channelmaterial, length: 30 , Coded Values: [Brick: Brick] , [Concrete Block: Concrete Block] , [Asbestos Cement: Asbestos Cement] , ...13 more... )
• rimtoinvert ( type: esriFieldTypeDouble, alias: rimtoinvert )
• gradetoinvert ( type: esriFieldTypeDouble, alias: gradetoinvert )
• pavedover ( type: esriFieldTypeString, alias: pavedover, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• wocomments ( type: esriFieldTypeString, alias: wocomments, length: 1073741822 )
• wodescription ( type: esriFieldTypeString, alias: wodescription, length: 255 )
• MH_Aerial_Photo ( type: esriFieldTypeInteger, alias: MH_Aerial_Photo )
• MH_Interior_Photo ( type: esriFieldTypeInteger, alias: MH_Interior_Photo )
• MH_Defect_1 ( type: esriFieldTypeInteger, alias: MH_Defect_1 )
• MH_Defect_2 ( type: esriFieldTypeInteger, alias: MH_Defect_2 )
• MH_Defect_3 ( type: esriFieldTypeInteger, alias: MH_Defect_3 )
• Pipe_1_Seal_Condition ( type: esriFieldTypeString, alias: Pipe_1_Seal_Condition, length: 50 , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] , ...1 more... )
• Pipe_2_Seal_Condition ( type: esriFieldTypeString, alias: Pipe_2_Seal_Condition, length: 50 , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] , ...1 more... )
• Pipe_3_Seal_Condition ( type: esriFieldTypeString, alias: Pipe_3_Seal_Condition, length: 50 , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] , ...1 more... )
• Pipe_4_Seal_Condition ( type: esriFieldTypeString, alias: Pipe_4_Seal_Condition, length: 50 , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] , ...1 more... )
• Pipe_5_Seal_Condition ( type: esriFieldTypeString, alias: Pipe_5_Seal_Condition, length: 50 , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] , ...1 more... )
• Interior_Pipe_1_Photo ( type: esriFieldTypeInteger, alias: Interior_Pipe_1_Photo )
• Interior_Pipe_2_Photo ( type: esriFieldTypeInteger, alias: Interior_Pipe_2_Photo )
• Interior_Pipe_3_Photo ( type: esriFieldTypeInteger, alias: Interior_Pipe_3_Photo )
• Interior_Pipe_4_Photo ( type: esriFieldTypeInteger, alias: Interior_Pipe_4_Photo )
• Interior_Pipe_5_Photo ( type: esriFieldTypeInteger, alias: Interior_Pipe_5_Photo )
• MH_Sketch ( type: esriFieldTypeInteger, alias: MH_Sketch )

Table: sedaSewerLateralHistory (102)

Name: sedaSewerLateralHistory

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, length: 20 )
• workorderid ( type: esriFieldTypeString, alias: Workorder Key, length: 50 )
• workdate ( type: esriFieldTypeDate, alias: Work Date, length: 8 )
• workby ( type: esriFieldTypeString, alias: Work By, length: 50 , Coded Values: [Staff: Staff] , [Contractor: Contractor] )
• worktype ( type: esriFieldTypeString, alias: Work Type, length: 50 )
• attachmentid ( type: esriFieldTypeInteger, alias: AttachmentID )
• emergency ( type: esriFieldTypeString, alias: emergency, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• flush ( type: esriFieldTypeString, alias: flush, length: 30 , Coded Values: [Flush: Flush] , [Rod: Rod] , [Plunge: Plunge] , ...3 more... )
• lateralrep ( type: esriFieldTypeString, alias: lateralrep, length: 30 , Coded Values: [Open Trench: Open Trench] , [Trencless: Trencless] , [C.O. Cap/Lid: C.O. Cap/Lid] )
• problem1 ( type: esriFieldTypeString, alias: problem1, length: 30 , Coded Values: [ROOT: Roots] , [GRSE: Grease] , [DEBR: Debris] , ...14 more... )
• problem2 ( type: esriFieldTypeString, alias: problem2, length: 30 , Coded Values: [ROOT: Roots] , [GRSE: Grease] , [DEBR: Debris] , ...14 more... )
• problem3 ( type: esriFieldTypeString, alias: problem3, length: 30 , Coded Values: [ROOT: Roots] , [GRSE: Grease] , [DEBR: Debris] , ...14 more... )
• failure ( type: esriFieldTypeString, alias: failure, length: 30 , Coded Values: [None: None] , [Stoppage: Stoppage] , [Overflow: Overflow] , ...1 more... )
• recommendation ( type: esriFieldTypeString, alias: recommendation, length: 50 , Coded Values: [Repair: Repair] , [Replace: Replace] , [Flush: Flush] , ...5 more... )
• comments ( type: esriFieldTypeString, alias: comments, length: 1000 )
• serviceadd ( type: esriFieldTypeString, alias: serviceadd, length: 1000 )
• repairtype ( type: esriFieldTypeString, alias: repairtype, length: 25 , Coded Values: [Open Trench: Open Trench] , [Trenchless: Trenchless] )
• repairstatus ( type: esriFieldTypeString, alias: repairstatus, length: 25 , Coded Values: [Complete: Complete] , [Pending: Pending] )
• repairlength ( type: esriFieldTypeDouble, alias: repairlength )
• mhdistance ( type: esriFieldTypeString, alias: mhdistance, length: 10 )
• insptype ( type: esriFieldTypeString, alias: insptype, length: 25 , Coded Values: [CCTV: CCTV] , [Visual: Visual] , [Dye Test: Dye Test] , ...1 more... )
• inspreason ( type: esriFieldTypeString, alias: inspreason, length: 50 , Coded Values: [RT: Routine] , [FOL: Follow up] , [CALL: Called Out] , ...2 more... )
• stormdrain ( type: esriFieldTypeSmallInteger, alias: stormdrain , Coded Values: [1: Yes] , [0: No] )
• statewaters ( type: esriFieldTypeSmallInteger, alias: statewaters , Coded Values: [1: Yes] , [0: No] )
• fullrecover ( type: esriFieldTypeSmallInteger, alias: fullrecover , Coded Values: [1: Yes] , [0: No] )
• gals1000 ( type: esriFieldTypeSmallInteger, alias: gals1000 , Coded Values: [1: Yes] , [0: No] )
• estvolume ( type: esriFieldTypeSmallInteger, alias: estvolume )
• overflowtype ( type: esriFieldTypeString, alias: overflowtype, length: 20 , Coded Values: [SSO: SSO] , [Backup: Backup] , [Private: Private] )
• attachmentid01 ( type: esriFieldTypeInteger, alias: attachmentid01 )
• attachmentid02 ( type: esriFieldTypeInteger, alias: attachmentid02 )
• overflowcategory ( type: esriFieldTypeSmallInteger, alias: overflowcategory , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• wocomments ( type: esriFieldTypeString, alias: wocomments, length: 1073741822 )
• wodescription ( type: esriFieldTypeString, alias: wodescription, length: 255 )

Table: sedaFOGHistory (103)

Name: sedaFOGHistory

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, length: 20 )
• workorderid ( type: esriFieldTypeString, alias: Workorder Key, length: 50 )
• attachmentid1 ( type: esriFieldTypeInteger, alias: AttachmentID1 )
• attachmentid2 ( type: esriFieldTypeInteger, alias: AttachmentID2 )
• workdate ( type: esriFieldTypeDate, alias: WorkDate, length: 8 )
• workby ( type: esriFieldTypeString, alias: WorkBy, length: 50 )
• worktype ( type: esriFieldTypeString, alias: worktype, length: 50 )
• comments ( type: esriFieldTypeString, alias: comments, length: 1000 )
• facility ( type: esriFieldTypeString, alias: facility, length: 50 )
• address ( type: esriFieldTypeString, alias: address, length: 100 )
• contact ( type: esriFieldTypeString, alias: contact, length: 50 )
• contactphone ( type: esriFieldTypeString, alias: contactphone, length: 20 )
• inspector ( type: esriFieldTypeString, alias: inspector, length: 50 , Coded Values: [Maurice Fortier: Maurice Fortier] , [Ken Ferreira: Ken Ferreira] , [Mark Giglio: Mark Giglio] , ...4 more... )
• inspectorphone ( type: esriFieldTypeString, alias: inspectorphone, length: 20 )
• lastinspected ( type: esriFieldTypeDate, alias: lastinspected, length: 8 )
• trapph ( type: esriFieldTypeDouble, alias: trapph )
• foodwasteintrap ( type: esriFieldTypeString, alias: foodwasteintrap, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• deviceaccessible ( type: esriFieldTypeString, alias: deviceaccessible, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• notes ( type: esriFieldTypeString, alias: notes, length: 250 )
• maintlog ( type: esriFieldTypeString, alias: maintlog, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• trapcleanedregularly ( type: esriFieldTypeString, alias: trapcleanedregularly, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• cleaningdocumented ( type: esriFieldTypeString, alias: cleaningdocumented, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• datecleaned ( type: esriFieldTypeDate, alias: datecleaned, length: 8 )
• cleaningcompany ( type: esriFieldTypeString, alias: cleaningcompany, length: 50 , Coded Values: )
• effectivevolume ( type: esriFieldTypeDouble, alias: effectivevolume )
• galspumped ( type: esriFieldTypeDouble, alias: galspumped )
• logentrysigned ( type: esriFieldTypeString, alias: logentrysigned, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• fogdepthreported ( type: esriFieldTypeString, alias: fogdepthreported, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• stafftrainedbmps ( type: esriFieldTypeString, alias: stafftrainedbmps, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• greasesignsposted ( type: esriFieldTypeString, alias: greasesignsposted, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• recyclerecords ( type: esriFieldTypeString, alias: recyclerecords, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• foodwastedisposal ( type: esriFieldTypeString, alias: foodwastedisposal, length: 20 , Coded Values: [Recycled: Recycled] , [Solid Waste Removal: Solid Waste Removal] )
• fogsystemcovered ( type: esriFieldTypeString, alias: fogsystemcovered, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• stormdrainprotection ( type: esriFieldTypeString, alias: stormdrainprotection, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• sppavailable ( type: esriFieldTypeString, alias: sppavailable, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• exhaustunitsclean ( type: esriFieldTypeString, alias: exhaustunitsclean, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• fogdepthintrap ( type: esriFieldTypeDouble, alias: fogdepthintrap )
• comliant ( type: esriFieldTypeString, alias: comliant, length: 30 , Coded Values: [Compliant: Compliant] , [Not Compliant: Not Compliant] )
• insideoutside ( type: esriFieldTypeString, alias: insideoutside, length: 10 , Coded Values: [Inside: Inside] , [Outside: Outside] )
• compliant ( type: esriFieldTypeString, alias: compliant, length: 50 )
• typeoftrap ( type: esriFieldTypeString, alias: typeoftrap, length: 30 )
• cleanfreqvalue ( type: esriFieldTypeDouble, alias: cleanfreqvalue )
• cleanfrequnit ( type: esriFieldTypeString, alias: cleanfrequnit, length: 30 )
• wocomments ( type: esriFieldTypeString, alias: wocomments, length: 1073741822 )
• wodescription ( type: esriFieldTypeString, alias: wodescription, length: 1000 )
• inspection_date ( type: esriFieldTypeDate, alias: inspection_date, length: 8 )
• fog_device_present ( type: esriFieldTypeString, alias: fog_device_present, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• primary_fog_device ( type: esriFieldTypeString, alias: primary_fog_device, length: 50 , Coded Values: [AGRU: AGRU] , [PASSIVE - INSIDE: PASSIVE - INSIDE] , [PASSIVE - INSIDE, ABOVEGROUND: PASSIVE - INSIDE, ABOVEGROUND] , ...3 more... )
• Additional_Fog_Devices ( type: esriFieldTypeString, alias: Additional_Fog_Devices, length: 50 )
• devicesubtypeoeffectivevolume ( type: esriFieldTypeString, alias: device_subtype_or_effective_volume, length: 50 )
• fog_device_capacity ( type: esriFieldTypeString, alias: fog_device_capacity, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• fog_device_maintained ( type: esriFieldTypeString, alias: fog_device_maintained, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• fog_device ( type: esriFieldTypeString, alias: fog_device, length: 50 )
• online_operational ( type: esriFieldTypeString, alias: online_operational, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• food_waste_filter_present ( type: esriFieldTypeString, alias: food_waste_filter_present, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• fog_device_online_operational ( type: esriFieldTypeString, alias: fog_device_online_operational, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• fog_storage_containers_labeled ( type: esriFieldTypeString, alias: fog_storage_containers_labeled, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• follow_up_required ( type: esriFieldTypeString, alias: follow_up_required, length: 50 )
• maintenance_log_present ( type: esriFieldTypeString, alias: maintenance_log_present, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• self_inspections_documented ( type: esriFieldTypeString, alias: self_inspections_documented, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• cleaning_frequency ( type: esriFieldTypeString, alias: cleaning_frequency, length: 50 , Coded Values: [Daily: Daily] , [Weekly: Weekly] , [Bi-Monthly: Bi-Monthly] , ...4 more... )
• spill_control_materials_present ( type: esriFieldTypeString, alias: spill_control_materials_present, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• outdoorfogprotectfromstormwater ( type: esriFieldTypeString, alias: outdoor_fog_storage_protected_from_discharge_to_storm_water, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ImageName ( type: esriFieldTypeString, alias: ImageName, length: 250 )
• ImagePath ( type: esriFieldTypeString, alias: ImagePath, length: 255 )
• ImageDate ( type: esriFieldTypeDate, alias: ImageDate, length: 8 )
• INSPECTION_ID ( type: esriFieldTypeInteger, alias: INSPECTION_ID )

Table: sedaSewerPumpHistory (104)

Name: sedaSewerPumpHistory

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, length: 20 )
• workorderid ( type: esriFieldTypeString, alias: Workorder Key, length: 50 )
• workdate ( type: esriFieldTypeDate, alias: Work Date, length: 8 )
• workby ( type: esriFieldTypeString, alias: Work By, length: 50 )
• worktype ( type: esriFieldTypeString, alias: Work Type, length: 50 )
• attachmentid ( type: esriFieldTypeInteger, alias: AttachmentID )
• breakersexercised ( type: esriFieldTypeSmallInteger, alias: breakersexercised , Coded Values: [1: Yes] , [0: No] )
• valvesexercised ( type: esriFieldTypeSmallInteger, alias: valvesexercised , Coded Values: [1: Yes] , [0: No] )
• gatevalvecondition ( type: esriFieldTypeString, alias: gatevalvecondition, length: 10 , Coded Values: [NEW: New] , [GOOD: Good] , [FAIR: Fair] , ...2 more... )
• checkvalvecondition ( type: esriFieldTypeString, alias: checkvalvecondition, length: 10 , Coded Values: [NEW: New] , [GOOD: Good] , [FAIR: Fair] , ...2 more... )
• leaksdeterioration ( type: esriFieldTypeString, alias: leaksdeterioration, length: 10 , Coded Values: [NONE: None] , [LGHT: Light] , [MED: Medium] , ...1 more... )
• motor1vl1l2 ( type: esriFieldTypeSmallInteger, alias: voltsl1l2 )
• motor1vl2l3 ( type: esriFieldTypeSmallInteger, alias: voltsl2l3 )
• motor1vl1l3 ( type: esriFieldTypeSmallInteger, alias: voltsl1l3 )
• motor2vl1l2 ( type: esriFieldTypeSmallInteger, alias: motor2vl1l2 )
• motor2vl2l3 ( type: esriFieldTypeSmallInteger, alias: motor2vl2l3 )
• motor2vl1l3 ( type: esriFieldTypeSmallInteger, alias: motor2vl1l3 )
• motor1ampsl1 ( type: esriFieldTypeSmallInteger, alias: motor1ampsl1 )
• motor1ampsl2 ( type: esriFieldTypeSmallInteger, alias: motor1ampsl2 )
• motor1ampsl3 ( type: esriFieldTypeSmallInteger, alias: motor1ampsl3 )
• motor2ampsl1 ( type: esriFieldTypeSmallInteger, alias: motor2ampsl1 )
• motor2ampsl2 ( type: esriFieldTypeSmallInteger, alias: motor2ampsl2 )
• motor2ampsl3 ( type: esriFieldTypeSmallInteger, alias: motor2ampsl3 )
• motor1megt1 ( type: esriFieldTypeDouble, alias: motor1megt1 )
• motor1megt2 ( type: esriFieldTypeDouble, alias: motor1megt2 )
• motor1megt3 ( type: esriFieldTypeDouble, alias: motor1megt3 )
• motor2megt1 ( type: esriFieldTypeDouble, alias: motor2megt1 )
• motor2megt2 ( type: esriFieldTypeDouble, alias: motor2megt2 )
• motor2megt3 ( type: esriFieldTypeDouble, alias: motor2megt3 )
• airvalvecleaned ( type: esriFieldTypeSmallInteger, alias: airvalvecleaned , Coded Values: [1: Yes] , [0: No] )
• vaultinspected ( type: esriFieldTypeSmallInteger, alias: vaultinspected , Coded Values: [1: Yes] , [0: No] )
• holddownbolts ( type: esriFieldTypeSmallInteger, alias: holddownbolts , Coded Values: [1: Yes] , [0: No] )
• ejectorpotscleaned ( type: esriFieldTypeSmallInteger, alias: ejectorpotscleaned , Coded Values: [1: Yes] , [0: No] )
• electrodescleaned ( type: esriFieldTypeSmallInteger, alias: electrodescleaned , Coded Values: [1: Yes] , [0: No] )
• starter1insp ( type: esriFieldTypeSmallInteger, alias: starter1insp , Coded Values: [1: Yes] , [0: No] )
• starter2insp ( type: esriFieldTypeSmallInteger, alias: starter2insp , Coded Values: [1: Yes] , [0: No] )
• starter3insp ( type: esriFieldTypeSmallInteger, alias: starter3insp , Coded Values: [1: Yes] , [0: No] )
• rotofloattested ( type: esriFieldTypeSmallInteger, alias: rotofloattested , Coded Values: [1: Yes] , [0: No] )
• interiorcondition ( type: esriFieldTypeString, alias: interiorcondtion, length: 10 , Coded Values: [NEW: New] , [GOOD: Good] , [FAIR: Fair] , ...2 more... )
• exteriorcondition ( type: esriFieldTypeString, alias: exteriorcondition, length: 10 , Coded Values: [NEW: New] , [GOOD: Good] , [FAIR: Fair] , ...2 more... )
• flushwetwell ( type: esriFieldTypeSmallInteger, alias: flushwetwell , Coded Values: [1: Yes] , [0: No] )
• pumplinescleared ( type: esriFieldTypeSmallInteger, alias: pumplinecleared , Coded Values: [1: Yes] , [0: No] )
• pumpsalternate ( type: esriFieldTypeSmallInteger, alias: pumpsalternate , Coded Values: [1: Yes] , [0: No] )
• standbyoperate ( type: esriFieldTypeSmallInteger, alias: standbyoperate , Coded Values: [1: Yes] , [0: No] )
• sumpinspected ( type: esriFieldTypeSmallInteger, alias: sumpinspected , Coded Values: [1: Yes] , [0: No] )
• sumpholecleaned ( type: esriFieldTypeSmallInteger, alias: sumpholecleaned , Coded Values: [1: Yes] , [0: No] )
• generatorinspected ( type: esriFieldTypeSmallInteger, alias: generatorinspected , Coded Values: [1: Yes] , [0: No] )
• pump1hours ( type: esriFieldTypeInteger, alias: pump1hours )
• pump2hours ( type: esriFieldTypeInteger, alias: pump2hours )
• pump3hours ( type: esriFieldTypeInteger, alias: pump3hours )
• pump4hours ( type: esriFieldTypeInteger, alias: pump4hours )
• comments ( type: esriFieldTypeString, alias: comments, length: 1000 )
• wocomments ( type: esriFieldTypeString, alias: wocomments, length: 1073741822 )
• wodescription ( type: esriFieldTypeString, alias: wodescription, length: 255 )

Table: AssetHistoryConfig (200)

Name: AssetHistoryConfig

Display Field: historytablename

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• assettype ( type: esriFieldTypeString, alias: assettype, length: 100 )
• historytablename ( type: esriFieldTypeString, alias: historytablename, length: 255 )
• cmmstablename ( type: esriFieldTypeString, alias: cmmstablename, length: 255 )
• workorderkeyfield ( type: esriFieldTypeString, alias: workorderkeyfield, length: 100 )
• assetkeyfield ( type: esriFieldTypeString, alias: assetkeyfield, length: 50 )

Table: Employee (201)

Name: Employee

Display Field: name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• name ( type: esriFieldTypeString, alias: name, length: 50 )
• hourlyrate ( type: esriFieldTypeDouble, alias: hourlyrate )
• employeeid ( type: esriFieldTypeString, alias: employeeid, length: 50 )
• username ( type: esriFieldTypeString, alias: username, length: 50 )

Table: EmployeeCost (202)

Name: EmployeeCost

Display Field: ratetype

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• hours ( type: esriFieldTypeDouble, alias: hours )
• ratetype ( type: esriFieldTypeString, alias: ratetype, length: 50 )
• hourlyrate ( type: esriFieldTypeDouble, alias: cost )
• datestamp ( type: esriFieldTypeDate, alias: datestamp, length: 8 )
• workorderkey ( type: esriFieldTypeString, alias: workorderkey, length: 50 )
• employeeid ( type: esriFieldTypeString, alias: employeeid, length: 50 )
• totalcost ( type: esriFieldTypeDouble, alias: hourlyrate )
• change_status ( type: esriFieldTypeString, alias: change_status, length: 50 )

Table: Equipment (203)

Name: Equipment

Display Field: equipmentid

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• hourlyrate ( type: esriFieldTypeDouble, alias: hourlyrate )
• equipmentid ( type: esriFieldTypeString, alias: equipmentid, length: 30 )
• serialnumber ( type: esriFieldTypeString, alias: equipmentnumber, length: 50 )
• equipmenttype ( type: esriFieldTypeString, alias: equipmenttype, length: 50 )
• description ( type: esriFieldTypeString, alias: description, length: 255 )

Table: EquipmentCost (204)

Name: EquipmentCost

Display Field: workorderkey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• equipmentid ( type: esriFieldTypeInteger, alias: equipmentid )
• units ( type: esriFieldTypeInteger, alias: units )
• hours ( type: esriFieldTypeDouble, alias: hours )
• unitcost ( type: esriFieldTypeDouble, alias: unitcost )
• datestamp ( type: esriFieldTypeDate, alias: datestamp, length: 8 )
• workorderkey ( type: esriFieldTypeString, alias: workorderkey, length: 50 )
• totalcost ( type: esriFieldTypeDouble, alias: totalcost )
• change_status ( type: esriFieldTypeString, alias: change_status, length: 50 )
• ratetype ( type: esriFieldTypeString, alias: ratetype, length: 50 )

Table: Inspection (205)

Name: Inspection

Display Field: inspectiontype

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• inspectiontypeid ( type: esriFieldTypeInteger, alias: inspectiontypeid )
• inspectiontype ( type: esriFieldTypeString, alias: inspectiontype, length: 255 )
• attributeid ( type: esriFieldTypeInteger, alias: attributeid )
• attributedescription ( type: esriFieldTypeString, alias: attributedescription, length: 255 )
• attributesequence ( type: esriFieldTypeSmallInteger, alias: attributesequence )
• attributerequired ( type: esriFieldTypeSmallInteger, alias: attributerequired )
• valueid ( type: esriFieldTypeInteger, alias: valueid )
• value ( type: esriFieldTypeString, alias: value, length: 255 )
• valueformat ( type: esriFieldTypeString, alias: VlueFormat, length: 50 )

Table: InspectionResults (206)

Name: InspectionResults

Display Field: inspectionkey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• inspectionkey ( type: esriFieldTypeString, alias: InspectionKey, length: 50 )
• attributeid ( type: esriFieldTypeInteger, alias: AttributeID )
• valueid ( type: esriFieldTypeInteger, alias: ValueID )
• value ( type: esriFieldTypeString, alias: Value, length: 255 )

Table: Material (207)

Name: Material

Display Field: description

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• materialid ( type: esriFieldTypeInteger, alias: materialid )
• description ( type: esriFieldTypeString, alias: description, length: 255 )
• unitcost ( type: esriFieldTypeDouble, alias: unitcost )
• partnumber ( type: esriFieldTypeString, alias: partnumber, length: 50 )

Table: MaterialCost (208)

Name: MaterialCost

Display Field: workorderkey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• materialid ( type: esriFieldTypeInteger, alias: materialid )
• units ( type: esriFieldTypeInteger, alias: units )
• unitcost ( type: esriFieldTypeDouble, alias: unitcost )
• datestamp ( type: esriFieldTypeDate, alias: datestamp, length: 8 )
• workorderkey ( type: esriFieldTypeString, alias: workorderkey, length: 50 )
• totalcost ( type: esriFieldTypeDouble, alias: totalcost )
• change_status ( type: esriFieldTypeString, alias: change_status, length: 50 )

Table: Task (209)

Name: Task

Display Field: name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• name ( type: esriFieldTypeString, alias: name, length: 50 )
• description ( type: esriFieldTypeString, alias: description, length: 255 )
• assignedto ( type: esriFieldTypeString, alias: assignedto, length: 50 )
• comments ( type: esriFieldTypeString, alias: comments, length: 255 )
• taskid ( type: esriFieldTypeString, alias: taskid, length: 50 )
• wotemplateid ( type: esriFieldTypeString, alias: wotemplateid, length: 50 )

Table: WorkAsset (210)

Name: WorkAsset

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: assetkey, length: 50 )
• assettype ( type: esriFieldTypeString, alias: assettype, length: 50 )
• workorderkey ( type: esriFieldTypeString, alias: workorderkey, length: 50 )
• iscompleted ( type: esriFieldTypeSmallInteger, alias: iscompleted )
• change_status ( type: esriFieldTypeString, alias: change_status, length: 50 )
• workinspectionkey ( type: esriFieldTypeString, alias: workinspectionkey, length: 100 )
• systemid ( type: esriFieldTypeString, alias: systemid, length: 100 )
• assetoid ( type: esriFieldTypeInteger, alias: assetoid )

Table: WorkInspection (211)

Name: WorkInspection

Display Field: assettype

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• inspectiontypeid ( type: esriFieldTypeInteger, alias: inspectiontypeid )
• assettype ( type: esriFieldTypeString, alias: assettype, length: 50 )
• assetkey ( type: esriFieldTypeString, alias: AssetKey, length: 100 )
• assetoid ( type: esriFieldTypeInteger, alias: assetoid )
• workorderkey ( type: esriFieldTypeString, alias: workorderkey, length: 50 )
• inspectionkey ( type: esriFieldTypeString, alias: InspectionID, length: 50 )
• systemid ( type: esriFieldTypeString, alias: systemid, length: 50 )
• inspectionby ( type: esriFieldTypeString, alias: InspectedBy, length: 100 )
• inspectiondate ( type: esriFieldTypeDate, alias: InspectedDate, length: 8 )
• status ( type: esriFieldTypeString, alias: Status, length: 50 )
• change_status ( type: esriFieldTypeString, alias: Change_Status, length: 50 )

Table: WorkOrder (212)

Name: WorkOrder

Display Field: customername

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• workorderkey ( type: esriFieldTypeString, alias: workorderkey, length: 50 )
• worktype ( type: esriFieldTypeString, alias: worktype, length: 100 )
• status ( type: esriFieldTypeString, alias: status, length: 50 )
• createddate ( type: esriFieldTypeDate, alias: createddate, length: 8 )
• createdby ( type: esriFieldTypeString, alias: createdby, length: 50 )
• startdate ( type: esriFieldTypeDate, alias: startdate, length: 8 )
• completeddate ( type: esriFieldTypeDate, alias: completeddate, length: 8 )
• completedby ( type: esriFieldTypeString, alias: completedby, length: 50 )
• assignedto ( type: esriFieldTypeString, alias: assignedto, length: 1073741822 )
• priority ( type: esriFieldTypeSmallInteger, alias: priority )
• location ( type: esriFieldTypeString, alias: location, length: 255 )
• customername ( type: esriFieldTypeString, alias: customername, length: 255 )
• contactinfo ( type: esriFieldTypeString, alias: contactinfo, length: 255 )
• description ( type: esriFieldTypeString, alias: description, length: 255 )
• comments ( type: esriFieldTypeString, alias: comments, length: 1073741822 )
• iscorrective ( type: esriFieldTypeSmallInteger, alias: iscorrective )
• change_status ( type: esriFieldTypeString, alias: change_status, length: 50 )
• budgetid ( type: esriFieldTypeString, alias: budgetid, length: 50 )
• systemid ( type: esriFieldTypeString, alias: systemid, length: 100 )
• accountnumber ( type: esriFieldTypeString, alias: accountnumber, length: 50 )
• parentworkorderkey ( type: esriFieldTypeString, alias: workorderparentkey, length: 50 )
• xcoordinate ( type: esriFieldTypeDouble, alias: xcoordinate )
• ycoordinate ( type: esriFieldTypeDouble, alias: ycoordinate )
• isrequest ( type: esriFieldTypeSmallInteger, alias: isrequest )
• worktypeid ( type: esriFieldTypeString, alias: worktypeid, length: 50 )

Table: WorkSchedule (213)

Name: WorkSchedule

Display Field: id

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• id ( type: esriFieldTypeString, alias: id, length: 50 )
• type ( type: esriFieldTypeString, alias: type, length: 50 )
• status ( type: esriFieldTypeString, alias: status, length: 20 )
• recurrence_time ( type: esriFieldTypeDate, alias: recurrence_time, length: 8 )
• frequency_type ( type: esriFieldTypeString, alias: frequency_type, length: 50 )
• start_date ( type: esriFieldTypeDate, alias: start_date, length: 8 )
• end_date ( type: esriFieldTypeDate, alias: end_date, length: 8 )
• daily_everydays ( type: esriFieldTypeInteger, alias: daily_everydays )
• weekly_everyweek ( type: esriFieldTypeInteger, alias: weekly_everyweek )
• weekly_selected ( type: esriFieldTypeString, alias: weekly_selected, length: 20 )
• monthly_isday ( type: esriFieldTypeSmallInteger, alias: monthly_isday )
• monthly_day ( type: esriFieldTypeInteger, alias: monthly_day )
• monthly_everymonth ( type: esriFieldTypeInteger, alias: monthly_everymonth )
• yearly_everyyear ( type: esriFieldTypeInteger, alias: yearly_everyyear )
• yearly_specificday ( type: esriFieldTypeSmallInteger, alias: yearly_specificday )
• yearly_month ( type: esriFieldTypeString, alias: yearly_month, length: 50 )
• yearly_day ( type: esriFieldTypeInteger, alias: yearly_day )
• last_run_datetime ( type: esriFieldTypeDate, alias: last_run_datetime, length: 8 )
• last_run_status ( type: esriFieldTypeString, alias: last_run_status, length: 250 )
• next_run_datetime ( type: esriFieldTypeDate, alias: next_run_datetime, length: 8 )
• monthly_nth ( type: esriFieldTypeInteger, alias: monthly_nth )
• monthly_weekday ( type: esriFieldTypeInteger, alias: monthly_weekday )
• yearly_nth ( type: esriFieldTypeInteger, alias: yearly_nth )
• yearly_weekday ( type: esriFieldTypeInteger, alias: yearly_weekday )
• key_ ( type: esriFieldTypeString, alias: key, length: 50 )

Table: WorkTask (214)

Name: WorkTask

Display Field: worktaskid

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• worktaskid ( type: esriFieldTypeString, alias: worktaskid, length: 50 )
• description ( type: esriFieldTypeString, alias: description, length: 255 )
• status ( type: esriFieldTypeString, alias: status, length: 50 )
• workorderkey ( type: esriFieldTypeString, alias: workorderkey, length: 50 )
• sequence ( type: esriFieldTypeInteger, alias: sequence )
• taskkey ( type: esriFieldTypeString, alias: taskkey, length: 50 )
• assignedto ( type: esriFieldTypeString, alias: assignedto, length: 50 )
• completeddate ( type: esriFieldTypeDate, alias: completeddate, length: 8 )
• change_status ( type: esriFieldTypeString, alias: change_status, length: 50 )

Table: sedaCustomerHistory (105)

Name: sedaCustomerHistory

Display Field: customername

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: assetkey, length: 20 )
• workorderid ( type: esriFieldTypeString, alias: workorderid, length: 50 )
• workdate ( type: esriFieldTypeDate, alias: workdate, length: 8 )
• worktype ( type: esriFieldTypeString, alias: worktype, length: 50 )
• workby ( type: esriFieldTypeString, alias: workby, length: 50 )
• metersize ( type: esriFieldTypeDouble, alias: metersize , Coded Values: [0.625: 5/8"] , [0.75: 3/4"] , [1: 1''] , ...16 more... )
• meternum_old ( type: esriFieldTypeString, alias: meternum_old, length: 25 )
• meternum_new ( type: esriFieldTypeString, alias: meternum_new, length: 25 )
• miu ( type: esriFieldTypeString, alias: miu, length: 25 )
• mfg ( type: esriFieldTypeString, alias: mfg, length: 50 )
• model ( type: esriFieldTypeString, alias: model, length: 50 )
• location ( type: esriFieldTypeString, alias: location, length: 250 )
• meterread ( type: esriFieldTypeDouble, alias: meterread )
• meterread_last ( type: esriFieldTypeDouble, alias: meterread_last )
• arrival ( type: esriFieldTypeDate, alias: arrival, length: 8 )
• departure ( type: esriFieldTypeDate, alias: departure, length: 8 )
• address ( type: esriFieldTypeString, alias: address, length: 100 )
• account ( type: esriFieldTypeString, alias: account, length: 20 )
• complaint ( type: esriFieldTypeString, alias: complaint, length: 250 )
• wodesc ( type: esriFieldTypeString, alias: wodesc, length: 250 )
• wonotes ( type: esriFieldTypeString, alias: wonotes, length: 250 )
• customername ( type: esriFieldTypeString, alias: customername, length: 50 )
• contactinfo ( type: esriFieldTypeString, alias: contactinfo, length: 50 )
• conditionfound ( type: esriFieldTypeString, alias: conditionfound, length: 100 )
• waterusebkp ( type: esriFieldTypeString, alias: waterusebkp, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• lateralproblem ( type: esriFieldTypeString, alias: lateralproblem, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• ssmhchecked ( type: esriFieldTypeString, alias: ssmhchecked, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• surcharged ( type: esriFieldTypeString, alias: surcharged, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• sewerflow ( type: esriFieldTypeString, alias: sewerflow, length: 20 , Coded Values: [None: None] , [Light: Light] , [Medium: Medium] , ...2 more... )
• excavation ( type: esriFieldTypeString, alias: excavation, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• jettingconditions ( type: esriFieldTypeString, alias: jettingconditions, length: 250 )
• videoinspected ( type: esriFieldTypeString, alias: videoinspected, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• videofindings ( type: esriFieldTypeString, alias: videofindings, length: 250 )
• homedamage ( type: esriFieldTypeString, alias: homedamage, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• homedamagedesc ( type: esriFieldTypeString, alias: homedamagedesc, length: 250 )
• supernotified ( type: esriFieldTypeString, alias: supernotified, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• datenotified ( type: esriFieldTypeDate, alias: datenotified, length: 8 )
• depnotified ( type: esriFieldTypeDate, alias: depnotified, length: 8 )
• bypassreport ( type: esriFieldTypeString, alias: bypassreport, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• otheractions ( type: esriFieldTypeString, alias: otheractions, length: 250 )
• upstreamcheck ( type: esriFieldTypeString, alias: upstreamcheck, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• upstreamflow ( type: esriFieldTypeString, alias: upstreamflow, length: 20 , Coded Values: [None: None] , [Light: Light] , [Medium: Medium] , ...2 more... )
• downstreamcheck ( type: esriFieldTypeString, alias: downstreamcheck, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• downstreamflow ( type: esriFieldTypeString, alias: downstreamflow, length: 20 , Coded Values: [None: None] , [Light: Light] , [Medium: Medium] , ...2 more... )
• onsiteactions ( type: esriFieldTypeString, alias: onsiteactions, length: 250 , Coded Values: [General: General] , [Repaired/Replaced: Repaired/Replaced] , [Jetted Line: Jetted Line] , ...3 more... )
• blockageremoved ( type: esriFieldTypeDate, alias: blockageremoved, length: 8 )
• estflowrate ( type: esriFieldTypeDouble, alias: estflowrate )
• overflowduration ( type: esriFieldTypeDouble, alias: overflowduration )
• sewagefate ( type: esriFieldTypeString, alias: sewagefate, length: 250 )
• contactperson ( type: esriFieldTypeString, alias: contactperson, length: 100 )
• addressaffected ( type: esriFieldTypeString, alias: addressaffected, length: 100 )
• contactphone ( type: esriFieldTypeString, alias: contactphone, length: 30 )
• deptrepnotified ( type: esriFieldTypeString, alias: deptrepnotified, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• deepreminder ( type: esriFieldTypeDate, alias: DEEPreminder, length: 8 )
• supervisit ( type: esriFieldTypeString, alias: supervisit, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• riskmgmtnotified ( type: esriFieldTypeString, alias: riskmgmtnotified, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• sewagecleanup ( type: esriFieldTypeString, alias: sewagecleanup, length: 250 )
• damagedesc ( type: esriFieldTypeString, alias: damagedesc, length: 250 )
• comments ( type: esriFieldTypeString, alias: comments, length: 1000 )
• attachmentid1 ( type: esriFieldTypeInteger, alias: attachmentid1 )
• attachmentid2 ( type: esriFieldTypeInteger, alias: attachmentid2 )
• attachmentid3 ( type: esriFieldTypeInteger, alias: attachmentid3 )
• revisitnecessary ( type: esriFieldTypeString, alias: revisitnecessary, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• crewneeded ( type: esriFieldTypeString, alias: crewneeded, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• createdby ( type: esriFieldTypeString, alias: createdby, length: 50 )
• mainjetted ( type: esriFieldTypeString, alias: mainjetted, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• owneronsite ( type: esriFieldTypeString, alias: owneronsite, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• ssocause ( type: esriFieldTypeString, alias: ssocause, length: 50 , Coded Values: [General: General] , [Mechanical Failure: Mechanical Failure] , [Blockage: Blockage] , ...8 more... )
• ssolocation ( type: esriFieldTypeString, alias: ssolocation, length: 250 )
• bypassfound ( type: esriFieldTypeDate, alias: bypassfound, length: 8 )
• bypassvolume ( type: esriFieldTypeDouble, alias: bypassvolume )
• volumemethod ( type: esriFieldTypeString, alias: volumemethod, length: 50 )
• receivingwaters ( type: esriFieldTypeString, alias: receivingwaters, length: 50 , Coded Values: [Connecticut River: Connecticut River] , [Mattabessett River: Mattabessett River] , [Coginchaug River: Coginchaug River] , ...6 more... )
• areacleaned ( type: esriFieldTypeString, alias: areacleaned, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• overflowresult ( type: esriFieldTypeString, alias: overflowresult, length: 75 , Coded Values: [Release to Ground: Release to Ground] , [Release to Street: Release to Street] , [Release to Basement: Release to Basement] , ...5 more... )
• cleanmethod ( type: esriFieldTypeString, alias: cleanmethod, length: 50 , Coded Values: [Wash Down: Wash Down] , [Wash Down & Disinfect: Wash Down & Disinfect] , [Contractor: Contractor] )
• stepstominimize ( type: esriFieldTypeString, alias: stepstominimize, length: 100 )
• stepstoeliminate ( type: esriFieldTypeString, alias: stepstoeliminate, length: 100 )
• preventrecurrence ( type: esriFieldTypeString, alias: preventrecurrence, length: 100 )
• supervisor ( type: esriFieldTypeString, alias: supervisor, length: 50 , Coded Values: [Tom Tetrault: Tom Tetrault] , [Devin Darley: Devin Darley] , [Brian Robillard: Brian Robillard] , ...1 more... )
• deptrepname ( type: esriFieldTypeString, alias: deptrepname, length: 50 , Coded Values: [Tom Tetrault: Tom Tetrault] , [Devin Darley: Devin Darley] , [Brian Robillard: Brian Robillard] , ...1 more... )
• complaintfrom ( type: esriFieldTypeString, alias: complaintfrom, length: 100 )
• street ( type: esriFieldTypeString, alias: street, length: 50 )
• crossstreet ( type: esriFieldTypeString, alias: crossstreet, length: 50 )
• qalert_problem ( type: esriFieldTypeString, alias: qalert_problem, length: 50 , Coded Values: [Backup: Backup] , [Odor: Odor] , [Water in Street: Water in Street] , ...2 more... )
• qalert_date ( type: esriFieldTypeDate, alias: qalert_date, length: 8 )
• qalert_response ( type: esriFieldTypeString, alias: qalert_response, length: 100 )
• subsection ( type: esriFieldTypeString, alias: subsection, length: 50 )
• qalert_number ( type: esriFieldTypeString, alias: qalert_number, length: 20 )
• qalert_status ( type: esriFieldTypeString, alias: qalert_status, length: 50 )
• investigatedby ( type: esriFieldTypeString, alias: investigatedby, length: 50 )
• wocomments ( type: esriFieldTypeString, alias: wocomments, length: 1000 )
• wodescription ( type: esriFieldTypeString, alias: wodescription, length: 1000 )

Table: sedaIPPHistory (106)

Name: sedaIPPHistory

Display Field: facname

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, length: 20 )
• workorderid ( type: esriFieldTypeString, alias: Workorder Key, length: 50 )
• attachmentid1 ( type: esriFieldTypeInteger, alias: AttachmentID1 )
• attachmentid2 ( type: esriFieldTypeInteger, alias: AttachmentID2 )
• workdate ( type: esriFieldTypeDate, alias: WorkDate, length: 8 )
• workby ( type: esriFieldTypeString, alias: WorkBy, length: 50 )
• worktype ( type: esriFieldTypeString, alias: worktype, length: 50 )
• comments ( type: esriFieldTypeString, alias: comments, length: 1000 )
• facname ( type: esriFieldTypeString, alias: facname, length: 50 )
• address ( type: esriFieldTypeString, alias: address, length: 150 )
• city ( type: esriFieldTypeString, alias: city, length: 50 )
• contactname ( type: esriFieldTypeString, alias: contactname, length: 100 )
• phone ( type: esriFieldTypeString, alias: phone, length: 20 )
• email ( type: esriFieldTypeString, alias: email, length: 50 )
• services ( type: esriFieldTypeString, alias: services, length: 50 )
• source_consump ( type: esriFieldTypeString, alias: source_consump, length: 100 , Coded Values: [Public Supply: Public Supply] , [Private Supply: Private Supply] , [Wells: Wells] , ...1 more... )
• sourcegpd ( type: esriFieldTypeDouble, alias: gpd )
• dischargetype ( type: esriFieldTypeString, alias: dischargetype, length: 50 , Coded Values: [Domestic Waste: Domestic Waste] , [Non-Contact Cooling Water: Non-Contact Cooling Water] , [Contact Cooling Water: Contact Cooling Water] , ...7 more... )
• dischargegpd ( type: esriFieldTypeDouble, alias: gpd )
• hoursperday ( type: esriFieldTypeDouble, alias: hoursperday )
• employees ( type: esriFieldTypeInteger, alias: employees )
• shifts ( type: esriFieldTypeString, alias: shifts, length: 1 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• prod_process ( type: esriFieldTypeString, alias: prod_process, length: 20 , Coded Values: [Batch: Batch] , [Continuous: Continuous] , [Both: Both] )
• seasonal_prod ( type: esriFieldTypeString, alias: seasonal_prod, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• seasonal_comments ( type: esriFieldTypeString, alias: seasonal_comments, length: 250 )
• annualshutdown ( type: esriFieldTypeString, alias: annualshutdown, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• dischargeserial ( type: esriFieldTypeString, alias: dischargeserial, length: 20 )
• dischpermitcurrent ( type: esriFieldTypeString, alias: dischpermitcurrent, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• dischpermitnumber ( type: esriFieldTypeString, alias: dischpermitnumber, length: 20 )
• samplecollected ( type: esriFieldTypeDate, alias: samplecollected, length: 8 )
• sampletype ( type: esriFieldTypeString, alias: sampletype, length: 20 , Coded Values: [Grab: Grab] , [Composite: Composite] )
• samplelocation ( type: esriFieldTypeString, alias: samplelocation, length: 100 )
• phrange ( type: esriFieldTypeString, alias: phrange, length: 20 )
• samplecomments ( type: esriFieldTypeString, alias: samplecomments, length: 250 )
• labname ( type: esriFieldTypeString, alias: labname, length: 100 )
• labaddress ( type: esriFieldTypeString, alias: labaddress, length: 100 )
• labcertified ( type: esriFieldTypeString, alias: labcertified, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• holdingtimesmet ( type: esriFieldTypeString, alias: holdingtimesmet, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• analysisperformed ( type: esriFieldTypeString, alias: analysisperformed, length: 20 , Coded Values: [Internal: Internal] , [External: External] )
• analyticalmethod ( type: esriFieldTypeString, alias: analyticalmethod, length: 30 )
• dmr_dsn ( type: esriFieldTypeString, alias: dmr_dsn, length: 20 )
• permitviolations ( type: esriFieldTypeString, alias: permitviolations, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• incompliance ( type: esriFieldTypeString, alias: incompliance, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• deepnotified ( type: esriFieldTypeDate, alias: deepnotified, length: 8 )
• potwnotified ( type: esriFieldTypeDate, alias: potwnotified, length: 8 )
• consistentflow ( type: esriFieldTypeString, alias: consistentflow, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• montlyavgflow ( type: esriFieldTypeDouble, alias: montlyavgflow )
• dmrsubmitted ( type: esriFieldTypeString, alias: dmrsubmitted, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• orpchart ( type: esriFieldTypeString, alias: orpchart, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• flowchart ( type: esriFieldTypeString, alias: flowchart, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• phchart ( type: esriFieldTypeString, alias: phchart, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• otherchart ( type: esriFieldTypeString, alias: otherchart, length: 50 )
• chartcheckeddaily ( type: esriFieldTypeString, alias: chartcheckeddaily, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• siu ( type: esriFieldTypeString, alias: siu, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• categorical ( type: esriFieldTypeString, alias: categorical, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• spp_plan ( type: esriFieldTypeString, alias: spp_plan, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• logbookbound ( type: esriFieldTypeString, alias: logbookbound, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• calib_maintrecords ( type: esriFieldTypeString, alias: calib_maintrecords, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• fiveyrsofrecords ( type: esriFieldTypeString, alias: fiveyrsofrecords, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• solventmgmtplan ( type: esriFieldTypeString, alias: solventmgmtplan, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• cooledtransport ( type: esriFieldTypeString, alias: cooledtransport, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• conformwith40cfr126 ( type: esriFieldTypeString, alias: conformwith40cfr126, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• monitoredperpermit ( type: esriFieldTypeString, alias: monitoredperpermit, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• selfmonitoringcomments ( type: esriFieldTypeString, alias: selfmonitoringcomments, length: 250 )
• sludgedisposal ( type: esriFieldTypeString, alias: sludgedisposal, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• sludgetransporter ( type: esriFieldTypeString, alias: sludgetransporter, length: 50 )
• wastename ( type: esriFieldTypeString, alias: wastename, length: 50 )
• hazardous ( type: esriFieldTypeString, alias: hazardous, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• hazardousdesignation ( type: esriFieldTypeString, alias: hazardousdesignation, length: 50 )
• disposal_location ( type: esriFieldTypeString, alias: disposal_location, length: 100 )
• disposal_quantity ( type: esriFieldTypeDouble, alias: disposal_quantity )
• disposal_units ( type: esriFieldTypeString, alias: disposal_units, length: 20 , Coded Values: [Pounds: Pounds] , [Gallons: Gallons] , [Tons: Tons] , ...2 more... )
• disposal_frequency ( type: esriFieldTypeString, alias: disposal_frequency, length: 20 , Coded Values: [Daily: Daily] , [Weekly: Weekly] , [Bi-Weekly: Bi-Weekly] , ...3 more... )
• dewateringmethod ( type: esriFieldTypeString, alias: dewateringmethod, length: 30 , Coded Values: [Gravity Belt: Gravity Belt] , [Belt Press: Belt Press] , [Vacuum: Vacuum] , ...3 more... )
• filtratetreated ( type: esriFieldTypeString, alias: filtratetreated, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• sludgecomments ( type: esriFieldTypeString, alias: sludgecomments, length: 250 )
• modsapprovedbydeep ( type: esriFieldTypeString, alias: modsapprovedbydeep, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• hrsinoperation ( type: esriFieldTypeDouble, alias: hrsinoperation )
• dischargehrs ( type: esriFieldTypeDouble, alias: dischargehrs )
• facbypasses ( type: esriFieldTypeString, alias: facbypasses, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• potwnotifiedofbypass ( type: esriFieldTypeString, alias: potwnotifiedofbypass, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• sitereviewcomments ( type: esriFieldTypeString, alias: sitereviewcomments, length: 250 )
• pms_scheduled ( type: esriFieldTypeString, alias: pms_scheduled, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• probes ( type: esriFieldTypeString, alias: probes, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• alarmsystem ( type: esriFieldTypeString, alias: alarmsystem, length: 20 , Coded Values: [pH: pH] , [ORP: ORP] , [High/Low Level: High/Low Level] , ...3 more... )
• flowmeasuredevice ( type: esriFieldTypeString, alias: flowmeasuredevice, length: 20 , Coded Values: [Parshall Flume: Parshall Flume] , [Magnetic: Magnetic] , [Ultrasonic: Ultrasonic] , ...2 more... )
• lastcalibrated ( type: esriFieldTypeDate, alias: lastcalibrated, length: 8 )
• flowlocation ( type: esriFieldTypeString, alias: flowlocation, length: 100 )
• flowdevicedsn ( type: esriFieldTypeString, alias: flowdevicedsn, length: 20 )
• flowdevicemfg ( type: esriFieldTypeString, alias: flowdevicemfg, length: 30 )
• instantaneousflow ( type: esriFieldTypeString, alias: instantaneousflow, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• flowcomments ( type: esriFieldTypeString, alias: flowcomments, length: 250 )
• permitlocation ( type: esriFieldTypeString, alias: specifiedlocation, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• repsamples ( type: esriFieldTypeString, alias: repsamples, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• samplesmeetparam ( type: esriFieldTypeString, alias: samplesmeetparam, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• infrequencyofpermit ( type: esriFieldTypeString, alias: infrequencyofpermit, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ttorequired ( type: esriFieldTypeString, alias: ttorequired, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• freqreqmet ( type: esriFieldTypeString, alias: freqrequirementmet, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• collectionmethod ( type: esriFieldTypeString, alias: collectionmethod, length: 50 , Coded Values: [Grab: Grab] , [Grab Sample Average: Grab Sample Average] , [Manual Composite: Manual Composite] , ...4 more... )
• properpreservation ( type: esriFieldTypeString, alias: properpreservation, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• modificationsmade ( type: esriFieldTypeString, alias: modificationsmade, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• allunitsinservice ( type: esriFieldTypeString, alias: allunitsinservice, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• om_manual ( type: esriFieldTypeString, alias: om_manual, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• permitmodpackage ( type: esriFieldTypeString, alias: permitmodpackage, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• proportionalflow ( type: esriFieldTypeString, alias: proportionalflow, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• compliant ( type: esriFieldTypeString, alias: compliant, length: 30 , Coded Values: [Compliant: Compliant] , [Not Compliant: Not Compliant] )
• disch_permit ( type: esriFieldTypeDate, alias: disch_permit, length: 8 )
• lastviolation ( type: esriFieldTypeDate, alias: lastviolation, length: 8 )
• wocomments ( type: esriFieldTypeString, alias: wocomments, length: 1073741822 )
• wodescription ( type: esriFieldTypeString, alias: wodescription, length: 255 )

Table: DigTicketHistory (173)

Name: DigTicketHistory

Display Field: contactname

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: objectid )
• ticketid ( type: esriFieldTypeString, alias: TicketID, length: 50 )
• revision ( type: esriFieldTypeString, alias: StartDate, length: 50 )
• accountid ( type: esriFieldTypeString, alias: AccountID, length: 50 )
• startdate ( type: esriFieldTypeDate, alias: StartDate, length: 8 )
• hoursnotice ( type: esriFieldTypeSmallInteger, alias: HoursNotice )
• responserequired ( type: esriFieldTypeString, alias: ResponseRequired, length: 50 )
• responseduedate ( type: esriFieldTypeDate, alias: ResponseDueDate, length: 8 )
• priority ( type: esriFieldTypeString, alias: Priority, length: 50 )
• prioritytype ( type: esriFieldTypeString, alias: Type, length: 50 )
• fromaddress ( type: esriFieldTypeString, alias: FromAddress, length: 50 )
• toaddress ( type: esriFieldTypeString, alias: ToAddress, length: 50 )
• street ( type: esriFieldTypeString, alias: Street, length: 50 )
• crossstreet ( type: esriFieldTypeString, alias: CrossStreet, length: 50 )
• delineated ( type: esriFieldTypeString, alias: Delineated, length: 50 )
• delineationtype ( type: esriFieldTypeString, alias: DelineationType, length: 50 )
• instructions ( type: esriFieldTypeString, alias: Instructions, length: 255 )
• constructiontype ( type: esriFieldTypeString, alias: WorkorderKey, length: 255 )
• contactname ( type: esriFieldTypeString, alias: ContactName, length: 100 )
• address1 ( type: esriFieldTypeString, alias: Address1, length: 100 )
• address2 ( type: esriFieldTypeString, alias: Address2, length: 100 )
• city ( type: esriFieldTypeString, alias: City, length: 50 )
• state ( type: esriFieldTypeString, alias: State, length: 50 )
• zip ( type: esriFieldTypeString, alias: Zip, length: 50 )
• phone ( type: esriFieldTypeString, alias: Phone, length: 50 )
• email ( type: esriFieldTypeString, alias: Email, length: 50 )
• location ( type: esriFieldTypeString, alias: Location, length: 1073741822 )
• comments ( type: esriFieldTypeString, alias: Comments, length: 1073741822 )
• tickettext ( type: esriFieldTypeString, alias: TicketText, length: 1073741822 )
• assetkey ( type: esriFieldTypeString, alias: assetkey, length: 20 )
• workorderkey ( type: esriFieldTypeString, alias: workorderkey, length: 50 )
• workdate ( type: esriFieldTypeDate, alias: workdate, length: 8 )
• workby ( type: esriFieldTypeString, alias: workby, length: 50 )
• worktype ( type: esriFieldTypeString, alias: worktype, length: 50 )
• assetsin ( type: esriFieldTypeString, alias: assetsin, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• needfieldverification ( type: esriFieldTypeString, alias: needfieldverification, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• attachmentid ( type: esriFieldTypeInteger, alias: attachmentid )
• status ( type: esriFieldTypeString, alias: status, length: 50 , Coded Values: [Marked: Marked] , [Work Already Completed: Work Already Completed] , [No Conflict: No Conflict] , ...1 more... )
• attachmentid2 ( type: esriFieldTypeInteger, alias: attachmentid2 )
• attachmentid3 ( type: esriFieldTypeInteger, alias: attachmentid3 )

Table: PermitHistory (107)

Name: PermitHistory

Display Field: contractorname

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, length: 20 )
• workorderid ( type: esriFieldTypeString, alias: Workorder Key, length: 50 )
• attachmentid1 ( type: esriFieldTypeInteger, alias: AttachmentID1 )
• attachmentid2 ( type: esriFieldTypeInteger, alias: AttachmentID2 )
• workdate ( type: esriFieldTypeDate, alias: WorkDate, length: 8 )
• workby ( type: esriFieldTypeString, alias: WorkBy, length: 50 )
• worktype ( type: esriFieldTypeString, alias: worktype, length: 50 )
• comments ( type: esriFieldTypeString, alias: comments, length: 1000 )
• permittype ( type: esriFieldTypeString, alias: permittype, length: 30 , Coded Values: [Connection: Connection] , [Disconnection: Disconnection] , [Repair: Repair] )
• permitnum ( type: esriFieldTypeString, alias: permitnum, length: 20 )
• bldgtype ( type: esriFieldTypeString, alias: bldgtype, length: 30 , Coded Values: [Commercial: Commercial] , [Industrial: Industrial] , [School: School] , ...10 more... )
• numberunits ( type: esriFieldTypeSmallInteger, alias: numberunits )
• jobtype ( type: esriFieldTypeString, alias: jobtype, length: 30 , Coded Values: [New Construction: New Construction] , [Addition: Addition] , [Repairs Only: Repairs Only] , ...3 more... )
• address ( type: esriFieldTypeString, alias: address, length: 150 )
• hub_used ( type: esriFieldTypeString, alias: hub_used, length: 50 )
• sewermap ( type: esriFieldTypeDouble, alias: sewermap )
• contractorname ( type: esriFieldTypeString, alias: contractorname, length: 100 )
• contractoraddr ( type: esriFieldTypeString, alias: contractoraddr, length: 150 )
• contractorphone ( type: esriFieldTypeString, alias: contractorphone, length: 20 )
• installer ( type: esriFieldTypeString, alias: installer, length: 100 )
• feepaid ( type: esriFieldTypeString, alias: feepaid, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• sketchadded ( type: esriFieldTypeString, alias: sketchadded, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• connectfeepaid ( type: esriFieldTypeString, alias: connectfeepaid, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• connected ( type: esriFieldTypeDate, alias: connected, length: 8 )
• asbuiltrecvd ( type: esriFieldTypeDate, alias: asbuiltrecvd, length: 8 )
• occ_cert ( type: esriFieldTypeDate, alias: occ_cert, length: 8 )
• repairtype ( type: esriFieldTypeString, alias: repairtype, length: 30 , Coded Values: [Corrective Maintenance: Corrective Maintenance] , [Preventative Maintenance: Preventative Maintenance] )
• wocomments ( type: esriFieldTypeString, alias: wocomments, length: 1073741822 )
• wodescription ( type: esriFieldTypeString, alias: wodescription, length: 255 )
• attachmentid3 ( type: esriFieldTypeInteger, alias: attachmentid3 )
• Work_Origin ( type: esriFieldTypeString, alias: Work_Origin, length: 50 , Coded Values: [Emergency: Emergency] , [Long-Term Maintenance Plan: Long-Term Maintenance Plan] )
• Inspection_Type ( type: esriFieldTypeString, alias: Inspection_Type`, length: 50 , Coded Values: [Internal: Internal] , [External: External] )
• Street_Name ( type: esriFieldTypeString, alias: Street_Name, length: 50 )
• Street_No ( type: esriFieldTypeString, alias: Street_No, length: 50 )
• Building_Type ( type: esriFieldTypeString, alias: Building_Type, length: 50 , Coded Values: [Single Family: Single Family] , [Multi Family: Multi Family] , [Apartment: Apartment] , ...2 more... )
• Sewer_SubArea ( type: esriFieldTypeString, alias: Sewer_SubArea, length: 50 )
• Map_No ( type: esriFieldTypeString, alias: Map_No, length: 50 )
• Line_Segment ( type: esriFieldTypeString, alias: Line_Segment, length: 50 )
• Upstream_MH ( type: esriFieldTypeString, alias: Upstream_MH, length: 50 )
• Downstream_MH ( type: esriFieldTypeString, alias: Downstream_MH, length: 50 )
• Owner_Contact_Name ( type: esriFieldTypeString, alias: Owner_Contact_Name, length: 50 )
• Owner_Contact_Number ( type: esriFieldTypeString, alias: Owner_Contact_Number, length: 50 )
• Inspection_Attempt ( type: esriFieldTypeString, alias: Inspection_Attempt, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• Date_Historical_Flooding ( type: esriFieldTypeString, alias: Date_Historical_Flooding, length: 50 )
• Source_Historical_Flooding ( type: esriFieldTypeString, alias: Source_Historical_Flooding, length: 50 )
• Actions_Take_After_Flooding ( type: esriFieldTypeString, alias: Actions_Take_After_Flooding, length: 50 )
• Foundation_Type ( type: esriFieldTypeString, alias: Foundation_Typep, length: 50 , Coded Values: [Slab: Slab] , [Crawl Space: Crawl Space] , [Unfinished Basement: Unfinished Basement] , ...3 more... )
• RoofDrain_Discharge_to_SS ( type: esriFieldTypeString, alias: RoofDrain_Discharge_to_SS, length: 50 )
• FoundationDrain_Discharge_to_SS ( type: esriFieldTypeString, alias: FoundationDrain_Discharge_to_SS, length: 50 )
• Curb_Box_Present ( type: esriFieldTypeString, alias: Curb_Box_Present, length: 50 , Coded Values: [1: Yes] , [2: No] )
• PatioDrain_Discharges_to_SS ( type: esriFieldTypeString, alias: PatioDrain_Discharges_to_SS, length: 50 )
• DrivewayDrain_Discharges_to_SS ( type: esriFieldTypeString, alias: DrivewayDrain_Discharges_to_SS, length: 50 )
• WindowWellDrain_to_SS ( type: esriFieldTypeString, alias: WindowWellDrain_Discharges_to_SS, length: 50 )
• StairwellSidewalkDrain_to_SS ( type: esriFieldTypeString, alias: StairwellSidewalkDrain_Discharges_to_SS, length: 50 )
• Diverter_Valve_On_Storm_Water ( type: esriFieldTypeString, alias: Diverter_Valve_On_Storm_Water, length: 50 )
• Comment ( type: esriFieldTypeString, alias: Comment, length: 1000 )
• Picture1 ( type: esriFieldTypeInteger, alias: Picture1 )
• Picture2 ( type: esriFieldTypeInteger, alias: Picture2 )
• Combination_Pump ( type: esriFieldTypeString, alias: Combination_Pump, length: 50 )
• YardDrain_Discharges_SS ( type: esriFieldTypeString, alias: YardDrain_Discharges_SS, length: 50 )
• SuspectConnection ( type: esriFieldTypeString, alias: SuspectConnection, length: 50 )
• PermissionGranted ( type: esriFieldTypeString, alias: PermissionGranted, length: 50 )
• Dye_Test_Results ( type: esriFieldTypeString, alias: Dye_Test_Results, length: 50 )
• Dye_test_comments ( type: esriFieldTypeString, alias: Dye_test_comments, length: 1000 )

Table: WaterburyGIS.GISEDITOR.sedaParcelHistory (920)

Name: WaterburyGIS.GISEDITOR.sedaParcelHistory

Display Field: contractorname

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, length: 20 )
• workorderid ( type: esriFieldTypeString, alias: Workorder Key, length: 50 )
• attachmentid1 ( type: esriFieldTypeInteger, alias: AttachmentID1 )
• attachmentid2 ( type: esriFieldTypeInteger, alias: AttachmentID2 )
• workdate ( type: esriFieldTypeDate, alias: WorkDate, length: 8 )
• workby ( type: esriFieldTypeString, alias: WorkBy, length: 50 )
• worktype ( type: esriFieldTypeString, alias: worktype, length: 50 )
• comments ( type: esriFieldTypeString, alias: comments, length: 1000 )
• permittype ( type: esriFieldTypeString, alias: permittype, length: 30 , Coded Values: [Connection: Connection] , [Disconnection: Disconnection] , [Repair: Repair] )
• permitnum ( type: esriFieldTypeString, alias: permitnum, length: 20 )
• bldgtype ( type: esriFieldTypeString, alias: bldgtype, length: 30 , Coded Values: [Commercial: Commercial] , [Industrial: Industrial] , [School: School] , ...10 more... )
• numberunits ( type: esriFieldTypeSmallInteger, alias: numberunits )
• jobtype ( type: esriFieldTypeString, alias: jobtype, length: 30 , Coded Values: [New Construction: New Construction] , [Addition: Addition] , [Repairs Only: Repairs Only] , ...3 more... )
• address ( type: esriFieldTypeString, alias: address, length: 150 )
• hub_used ( type: esriFieldTypeString, alias: hub_used, length: 50 )
• sewermap ( type: esriFieldTypeDouble, alias: sewermap )
• contractorname ( type: esriFieldTypeString, alias: contractorname, length: 100 )
• contractoraddr ( type: esriFieldTypeString, alias: contractoraddr, length: 150 )
• contractorphone ( type: esriFieldTypeString, alias: contractorphone, length: 20 )
• installer ( type: esriFieldTypeString, alias: installer, length: 100 )
• feepaid ( type: esriFieldTypeString, alias: feepaid, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• sketchadded ( type: esriFieldTypeString, alias: sketchadded, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• connectfeepaid ( type: esriFieldTypeString, alias: connectfeepaid, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• connected ( type: esriFieldTypeDate, alias: connected, length: 8 )
• asbuiltrecvd ( type: esriFieldTypeDate, alias: asbuiltrecvd, length: 8 )
• occ_cert ( type: esriFieldTypeDate, alias: occ_cert, length: 8 )
• repairtype ( type: esriFieldTypeString, alias: repairtype, length: 30 , Coded Values: [Corrective Maintenance: Corrective Maintenance] , [Preventative Maintenance: Preventative Maintenance] )
• wocomments ( type: esriFieldTypeString, alias: wocomments, length: 1073741822 )
• wodescription ( type: esriFieldTypeString, alias: wodescription, length: 255 )
• attachmentid3 ( type: esriFieldTypeInteger, alias: attachmentid3 )
• Work_Origin ( type: esriFieldTypeString, alias: Work_Origin, length: 50 , Coded Values: [Emergency: Emergency] , [Long-Term Maintenance Plan: Long-Term Maintenance Plan] )
• Inspection_Type ( type: esriFieldTypeString, alias: Inspection_Type`, length: 50 , Coded Values: [Internal: Internal] , [External: External] )
• Street_Name ( type: esriFieldTypeString, alias: Street_Name, length: 50 )
• Street_No ( type: esriFieldTypeString, alias: Street_No, length: 50 )
• Building_Type ( type: esriFieldTypeString, alias: Building_Type, length: 50 , Coded Values: [Single Family: Single Family] , [Multi Family: Multi Family] , [Apartment: Apartment] , ...2 more... )
• Sewer_SubArea ( type: esriFieldTypeString, alias: Sewer_SubArea, length: 50 )
• Map_No ( type: esriFieldTypeString, alias: Map_No, length: 50 )
• Line_Segment ( type: esriFieldTypeString, alias: Line_Segment, length: 50 )
• Upstream_MH ( type: esriFieldTypeString, alias: Upstream_MH, length: 50 )
• Downstream_MH ( type: esriFieldTypeString, alias: Downstream_MH, length: 50 )
• Owner_Contact_Name ( type: esriFieldTypeString, alias: Owner_Contact_Name, length: 50 )
• Owner_Contact_Number ( type: esriFieldTypeString, alias: Owner_Contact_Number, length: 50 )
• Inspection_Attempt ( type: esriFieldTypeString, alias: Inspection_Attempt, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• Date_Historical_Flooding ( type: esriFieldTypeString, alias: Date_Historical_Flooding, length: 50 )
• Source_Historical_Flooding ( type: esriFieldTypeString, alias: Source_Historical_Flooding, length: 50 )
• Actions_Take_After_Flooding ( type: esriFieldTypeString, alias: Actions_Take_After_Flooding, length: 50 )
• Foundation_Type ( type: esriFieldTypeString, alias: Foundation_Typep, length: 50 , Coded Values: [Slab: Slab] , [Crawl Space: Crawl Space] , [Unfinished Basement: Unfinished Basement] , ...3 more... )
• RoofDrain_Discharge_to_SS ( type: esriFieldTypeString, alias: RoofDrain_Discharge_to_SS, length: 50 )
• FoundationDrain_Discharge_to_SS ( type: esriFieldTypeString, alias: FoundationDrain_Discharge_to_SS, length: 50 )
• Curb_Box_Present ( type: esriFieldTypeString, alias: Curb_Box_Present, length: 50 , Coded Values: [1: Yes] , [2: No] )
• PatioDrain_Discharges_to_SS ( type: esriFieldTypeString, alias: PatioDrain_Discharges_to_SS, length: 50 )
• DrivewayDrain_Discharges_to_SS ( type: esriFieldTypeString, alias: DrivewayDrain_Discharges_to_SS, length: 50 )
• WindowWellDrain_to_SS ( type: esriFieldTypeString, alias: WindowWellDrain_Discharges_to_SS, length: 50 )
• StairwellSidewalkDrain_to_SS ( type: esriFieldTypeString, alias: StairwellSidewalkDrain_Discharges_to_SS, length: 50 )
• Diverter_Valve_On_Storm_Water ( type: esriFieldTypeString, alias: Diverter_Valve_On_Storm_Water, length: 50 )
• Comment ( type: esriFieldTypeString, alias: Comment, length: 1000 )
• Picture1 ( type: esriFieldTypeInteger, alias: Picture1 )
• Picture2 ( type: esriFieldTypeInteger, alias: Picture2 )
• Combination_Pump ( type: esriFieldTypeString, alias: Combination_Pump, length: 50 )
• YardDrain_Discharges_SS ( type: esriFieldTypeString, alias: YardDrain_Discharges_SS, length: 50 )
• SuspectConnection ( type: esriFieldTypeString, alias: SuspectConnection, length: 50 )
• PermissionGranted ( type: esriFieldTypeString, alias: PermissionGranted, length: 50 )
• Dye_Test_Results ( type: esriFieldTypeString, alias: Dye_Test_Results, length: 50 )
• Dye_test_comments ( type: esriFieldTypeString, alias: Dye_test_comments, length: 1000 )
• Inspectedby ( type: esriFieldTypeString, alias: Inspectedby, length: 50 )

Table: WaterburyGIS.GISEDITOR.sedaPipeHistory (921)

Name: WaterburyGIS.GISEDITOR.sedaPipeHistory

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: objectid )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, length: 20 )
• workorderid ( type: esriFieldTypeString, alias: Workorder Key, length: 50 )
• leaktype ( type: esriFieldTypeString, alias: LeakType, length: 50 )
• reporteddate ( type: esriFieldTypeDate, alias: ReportedDate, length: 8 )
• repaireddate ( type: esriFieldTypeDate, alias: RepairedDate, length: 8 )
• pipeclamp ( type: esriFieldTypeString, alias: PipeClamp, length: 50 )
• feetreplaced ( type: esriFieldTypeDouble, alias: FeetReplaced )
• sampledate ( type: esriFieldTypeDate, alias: SampleDate, length: 8 )
• publicnotified ( type: esriFieldTypeString, alias: PublicNotified, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• cl2residual ( type: esriFieldTypeDouble, alias: Cl2Residual )
• streetpatchtype ( type: esriFieldTypeString, alias: StreetPatchType, length: 50 )
• squarefeetpatched ( type: esriFieldTypeDouble, alias: SquareFeetPatched )
• streetpatchdate ( type: esriFieldTypeDate, alias: StreetPatchDate, length: 8 )
• workdate ( type: esriFieldTypeDate, alias: WorkDate, length: 8 )
• workby ( type: esriFieldTypeString, alias: WorkBy, length: 50 )
• worktype ( type: esriFieldTypeString, alias: worktype, length: 50 )
• short_measurement ( type: esriFieldTypeString, alias: short_measurement, length: 1000 )
• long_measurement ( type: esriFieldTypeString, alias: long_measurement, length: 1000 )
• meter_information ( type: esriFieldTypeString, alias: meter_information, length: 1000 )
• labor_entry ( type: esriFieldTypeString, alias: labor_entry, length: 1000 )
• equipment_used ( type: esriFieldTypeString, alias: equipment_used, length: 1000 )
• material_used ( type: esriFieldTypeString, alias: material_used, length: 1000 )
• excavation_details ( type: esriFieldTypeString, alias: excavation_details, length: 1000 )
• pipe_depth ( type: esriFieldTypeDouble, alias: pipe_depth )
• pavement_thickness ( type: esriFieldTypeDouble, alias: pavement_thickness )
• corrosion_details ( type: esriFieldTypeString, alias: corrosion_details, length: 1000 )
• report_prepared_by ( type: esriFieldTypeString, alias: report_prepared_by, length: 100 )
• report_prepared_date ( type: esriFieldTypeDate, alias: report_prepared_date, length: 8 )
• est_waterloss ( type: esriFieldTypeDouble, alias: est_waterloss )
• outage_id ( type: esriFieldTypeString, alias: outage_id, length: 50 )
• event_time ( type: esriFieldTypeDate, alias: event_time, length: 8 )
• valves_closed_time ( type: esriFieldTypeDate, alias: valves_closed_time, length: 8 )
• flow_rate ( type: esriFieldTypeDouble, alias: flow_rate )
• pipe_diameter ( type: esriFieldTypeDouble, alias: pipe_diameter )
• estimated_pressure ( type: esriFieldTypeDouble, alias: estimated_pressure )
• break_type ( type: esriFieldTypeString, alias: break_type, length: 50 )
• break_width ( type: esriFieldTypeDouble, alias: break_width )
• break_height ( type: esriFieldTypeDouble, alias: break_height )
• comments ( type: esriFieldTypeString, alias: comments, length: 2000 )
• start ( type: esriFieldTypeDate, alias: start, length: 8 )
• finish ( type: esriFieldTypeDate, alias: finish, length: 8 )
• wocomments ( type: esriFieldTypeString, alias: wocomments, length: 1073741822 )
• wodescription ( type: esriFieldTypeString, alias: wodescription, length: 255 )
• Date ( type: esriFieldTypeDate, alias: Date, length: 8 )
• Crew ( type: esriFieldTypeString, alias: Crew, length: 50 )
• Street ( type: esriFieldTypeString, alias: Street, length: 50 )
• Sub_Basin ( type: esriFieldTypeString, alias: Sub_Basin, length: 50 )
• USMH ( type: esriFieldTypeString, alias: USMH, length: 50 )
• DSMH ( type: esriFieldTypeString, alias: DSMH, length: 50 )
• Pipe_Length ( type: esriFieldTypeString, alias: Pipe_Length, length: 50 )
• Measure_Code ( type: esriFieldTypeString, alias: Measure_Code, length: 50 , Coded Values: [1 (GIS): 1 (GIS)] , [2 (Wheeled): 2 (Wheeled)] , [3 (Tape): 3 (Tape)] , ...1 more... )
• Inspection_Status ( type: esriFieldTypeString, alias: Inspection_Status, length: 50 , Coded Values: [1 (C.N.L): 1 (C.N.L)] , [2 (D.N.E): 2 (D.N.E)] , [3 (Buried MH): 3 (Buried MH)] , ...4 more... )
• Temperature ( type: esriFieldTypeString, alias: Temperature, length: 50 , Coded Values: [1 (110-90 degrees): 1 (110-90 degrees)] , [2 (90-80): 2 (90-80)] , [3 (80-70): 3 (80-70)] , ...1 more... )
• Precipitation ( type: esriFieldTypeString, alias: Precipitation, length: 50 , Coded Values: [1 (Dry): 1 (Dry)] , [2 (Drizzle): 2 (Drizzle)] , [3 (Rain): 3 (Rain)] )
• Ground_Condition ( type: esriFieldTypeString, alias: Ground_Condition, length: 50 , Coded Values: [1 (Dry): 1 (Dry)] , [2 (Moist): 2 (Moist)] , [3 (Wet): 3 (Wet)] , ...1 more... )
• Last_Rain_Event ( type: esriFieldTypeDate, alias: Last_Rain_Event, length: 8 )
• Over_All_Comments ( type: esriFieldTypeString, alias: Over_All_Comments, length: 50 )
• Site_Sketch ( type: esriFieldTypeInteger, alias: Site_Sketch )
• Site_Sketch2 ( type: esriFieldTypeInteger, alias: Site_Sketch2 )
• Defect_1_Location ( type: esriFieldTypeString, alias: Defect_1_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_1_Address ( type: esriFieldTypeString, alias: Defect_1_Address, length: 50 )
• Defect_1_Type ( type: esriFieldTypeString, alias: Defect_1_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_1_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_1_Footage_From_USMH, length: 50 )
• Defect_1_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_1_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_1_Tributary_Area ( type: esriFieldTypeString, alias: Defect_1_Tributary_Area, length: 50 )
• Defect_1_Comment ( type: esriFieldTypeString, alias: Defect_1_Comment, length: 50 )
• Defect_1_Photo ( type: esriFieldTypeInteger, alias: Defect_1_Photo )
• Defect_2_Location ( type: esriFieldTypeString, alias: Defect_2_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_2_Address ( type: esriFieldTypeString, alias: Defect_2_Address, length: 50 )
• Defect_2_Type ( type: esriFieldTypeString, alias: Defect_2_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_2_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_2_Footage_From_USMH, length: 50 )
• Defect_2_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_2_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_2_Tributary_Area ( type: esriFieldTypeString, alias: Defect_2_Tributary_Area, length: 50 )
• Defect_2_Comment ( type: esriFieldTypeString, alias: Defect_2_Comment, length: 50 )
• Defect_2_Photo ( type: esriFieldTypeInteger, alias: Defect_2_Photo )
• Defect_3_Location ( type: esriFieldTypeString, alias: Defect_3_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_3_Address ( type: esriFieldTypeString, alias: Defect_3_Address, length: 50 )
• Defect_3_Type ( type: esriFieldTypeString, alias: Defect_3_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_3_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_3_Footage_From_USMH, length: 50 )
• Defect_3_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_3_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_3_Tributary_Area ( type: esriFieldTypeString, alias: Defect_3_Tributary_Area, length: 50 )
• Defect_3_Comment ( type: esriFieldTypeString, alias: Defect_3_Comment, length: 50 )
• Defect_3_Photo ( type: esriFieldTypeInteger, alias: Defect_3_Photo )
• Defect_4_Location ( type: esriFieldTypeString, alias: Defect_4_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_4_Address ( type: esriFieldTypeString, alias: Defect_4_, length: 50 )
• Defect_4_Type ( type: esriFieldTypeString, alias: Defect_4_, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_4_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_4_Footage_From_USMH, length: 50 )
• Defect_4_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_4_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_4_Tributary_Area ( type: esriFieldTypeString, alias: Defect_4_Tributary_Area, length: 50 )
• Defect_4_Comment ( type: esriFieldTypeString, alias: Defect_4_Comment, length: 50 )
• Defect_4_Photo ( type: esriFieldTypeInteger, alias: Defect_4_Photo )
• Defect_5_Location ( type: esriFieldTypeString, alias: Defect_5_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_5_Address ( type: esriFieldTypeString, alias: Defect_5_Address, length: 50 )
• Defect_5_Type ( type: esriFieldTypeString, alias: Defect_5_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_5_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_5_Footage_From_USMH, length: 50 )
• Defect_5_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_5_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_5_Tributary_Area ( type: esriFieldTypeString, alias: Defect_5_Tributary_Area, length: 50 )
• Defect_5_Comment ( type: esriFieldTypeString, alias: Defect_5_Comment, length: 50 )
• Defect_5_Photo ( type: esriFieldTypeInteger, alias: Defect_5_Photo )
• Defect_6_Location ( type: esriFieldTypeString, alias: Defect_6_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_6_Address ( type: esriFieldTypeString, alias: Defect_6_Address, length: 50 )
• Defect_6_Type ( type: esriFieldTypeString, alias: Defect_6_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_6_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_6_Footage_From_USMH, length: 50 )
• Defect_6_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_6_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_6_Tributary_Area ( type: esriFieldTypeString, alias: Defect_6_Tributary_Area, length: 50 )
• Defect_6_Comment ( type: esriFieldTypeString, alias: Defect_6_Comment, length: 50 )
• Defect_6_Photo ( type: esriFieldTypeInteger, alias: Defect_6_Photo )
• Defect_7_Location ( type: esriFieldTypeString, alias: Defect_7_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_7_Address ( type: esriFieldTypeString, alias: Defect_7_Address, length: 50 )
• Defect_7_Type ( type: esriFieldTypeString, alias: Defect_7_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_7_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_7_Footage_From_USMH, length: 50 )
• Defect_7_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_7_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_7_Tributary_Area ( type: esriFieldTypeString, alias: Defect_7_Tributary_Area, length: 50 )
• Defect_7_Comment ( type: esriFieldTypeString, alias: Defect_7_Comment, length: 50 )
• Defect_7_Photo ( type: esriFieldTypeInteger, alias: Defect_7_Photo )
• Defect_8_Location ( type: esriFieldTypeString, alias: Defect_8_, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_8_Address ( type: esriFieldTypeString, alias: Defect_8_Address, length: 50 )
• Defect_8_Type ( type: esriFieldTypeString, alias: Defect_8_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_8_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_8_Footage_From_USMH, length: 50 )
• Defect_8_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_8_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_8_Tributary_Area ( type: esriFieldTypeString, alias: Defect_8_Tributary_Area, length: 50 )
• Defect_8_Comment ( type: esriFieldTypeString, alias: Defect_8_Comment, length: 50 )
• Defect_8_Photo ( type: esriFieldTypeInteger, alias: Defect_8_Photo )
• Defect_9_Location ( type: esriFieldTypeString, alias: Defect_9_, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_9_Address ( type: esriFieldTypeString, alias: Defect_9_Address, length: 50 )
• Defect_9_Type ( type: esriFieldTypeString, alias: Defect_9_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_9_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_9_Footage_From_USMH, length: 50 )
• Defect_9_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_9_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_9_Tributary_Area ( type: esriFieldTypeString, alias: Defect_9_Tributary_Area, length: 50 )
• Defect_9_Comment ( type: esriFieldTypeString, alias: Defect_9_, length: 50 )
• Defect_9_Photo ( type: esriFieldTypeInteger, alias: Defect_9_Photo )
• Defect_10_Location ( type: esriFieldTypeString, alias: Defect_10_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_10_Address ( type: esriFieldTypeString, alias: Defect_10_Address, length: 50 )
• Defect_10_Type ( type: esriFieldTypeString, alias: Defect_10_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_10_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_10_Footage_From_USMH, length: 50 )
• Defect_10_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_10_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_10_Tributary_Area ( type: esriFieldTypeString, alias: Defect_10_Tributary_Area, length: 50 )
• Defect_10_Comment ( type: esriFieldTypeString, alias: Defect_10_Comment, length: 50 )
• Defect_10_Photo ( type: esriFieldTypeInteger, alias: Defect_10_Photo )