All Layers and Tables (Waterbury/Sedaru

Layers:

Layer: Customers (215)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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: Permits (11)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Unique Value Renderer:

Field 1:

Field 2:

Field 3:

Field Delimiter:

Default Symbol:

N/A

Default Label:

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:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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: Cleaned Pipes (22)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Unique Value Renderer:

Field 1:

Field 2:

Field 3:

Field Delimiter:

Default Symbol:

Style:

Color:

Outline:

Style:

Color:

Width:

Default Label:

UniqueValueInfos:

Value: Emergency
Label: Emergency
Description:
Symbol:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: true

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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: Sub Areas (13)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Outline:

Style:

Color:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Outline:

Style:

Color:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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: FOG Inspected (33)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Outline:

Style:

Color:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Outline:

Style:

Color:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Outline:

Style:

Color:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Outline:

Style:

Color:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

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 )