All Layers and Tables (CNPY_mPeoriaIL/CNPY_mPeoriaIL_SWU

Layers:

Layer: Stormwater Utility Features (0)

Sub Layers:

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: true

MaxRecordCount:

MaxSelectionCount:

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:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

None

Layer: Stormwater Device (1)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

MaxSelectionCount:

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: 0
Label: Unknown
Description: N/A
Symbol:
Value: 5
Label: Pump
Description: N/A
Symbol:
Value: 21
Label: Cleanout
Description: N/A
Symbol:
Value: 22
Label: End Treatment
Description: N/A
Symbol:
Value: 23
Label: Connection
Description: N/A
Symbol:
Value: 26
Label: Weir
Description: N/A
Symbol:
Value: 28
Label: Inlet
Description: N/A
Symbol:
Value: 29
Label: BMP Point
Description: N/A
Symbol:
Value: 30
Label: BMP Inlet
Description: N/A
Symbol:
Value: 32
Label: Manhole
Description: N/A
Symbol:
Value: 33
Label: Turn-down 90
Description: N/A
Symbol:

Transparency:

Labeling Info:

Label Placement:

Label Expression:

Use Coded Values:

Symbol:

Color:

Background Color:

Outline Color:

Vertical Alignment:

Horizontal Alignment:

Right to Left:

Angle:

XOffset:

YOffset:

Size:

Font Family:

Font Style:

Font Weight:

Font Decoration:

Min. Scale:

Max. Scale:

Feature Draw Order:

N/A

Advanced Query Capabilities:

HasZ: true

HasM: true

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

assetid ( nullable: true, length: 64, alias: Structure ID, type: esriFieldTypeString )
OBJECTID ( nullable: false, alias: Object ID, type: esriFieldTypeOID )
assetgroup ( nullable: false, alias: Asset group, type: esriFieldTypeInteger )
assettype ( nullable: false, alias: Asset type, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [2: Diversion Manhole] , [3: Junction Manhole] , ...7 more... )
isconnected ( nullable: false, alias: Is connected, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] , [2: Unknown] )
creationdate ( nullable: true, length: 8, alias: Creation date, type: esriFieldTypeDate )
creator ( nullable: true, length: 255, alias: Creator, type: esriFieldTypeString )
lastupdate ( nullable: true, length: 8, alias: Last update, type: esriFieldTypeDate )
updatedby ( nullable: true, length: 255, alias: Updated by, type: esriFieldTypeString )
globalid ( nullable: false, length: 38, alias: Global ID 2, type: esriFieldTypeGUID )
installdate ( nullable: true, length: 8, alias: Install Date, type: esriFieldTypeDate )
ownedby ( nullable: true, alias: Owned By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
maintby ( nullable: true, alias: Maintained By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
notes ( nullable: true, length: 2000, alias: Notes, type: esriFieldTypeString )
diameter ( nullable: true, alias: Diameter, type: esriFieldTypeDouble )
material ( nullable: true, alias: Material, type: esriFieldTypeSmallInteger )
surfacewater ( nullable: true, alias: Receives Surface Water, type: esriFieldTypeSmallInteger )
lifecyclestatus ( nullable: false, alias: Lifecycle Status, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more... )
spatialsource ( nullable: true, alias: Spatial Source, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more... )
designtype ( nullable: true, alias: Type, type: esriFieldTypeSmallInteger )
length2 ( nullable: true, alias: Length, type: esriFieldTypeDouble )
width ( nullable: true, alias: Width, type: esriFieldTypeDouble )
depth ( nullable: true, alias: Depth, type: esriFieldTypeDouble )
elevation ( nullable: true, alias: Elevation, type: esriFieldTypeDouble )
inletshape ( nullable: true, alias: Inlet Shape, type: esriFieldTypeSmallInteger )
validationstatus ( nullable: true, alias: Validation status, type: esriFieldTypeSmallInteger , Coded Values: [0: No calculation required, no validation required, no error] , [1: No calculation required, no validation required, has error(s)] , [2: No calculation required, validation required, no error] , ...5 more... )
IDOT_survey_code ( nullable: true, alias: IDOT Survey Code, type: esriFieldTypeSmallInteger )
GlobalID_1 ( nullable: false, length: 38, alias: Global ID, type: esriFieldTypeGlobalID )
bottom_elevation ( nullable: true, alias: Bottom Elevation, type: esriFieldTypeDouble )
pipe_count ( nullable: true, alias: Number of Pipes, type: esriFieldTypeSmallInteger )
conetype ( nullable: true, alias: Cone type, type: esriFieldTypeSmallInteger )
location ( nullable: true, alias: Structure Location, type: esriFieldTypeSmallInteger )
surface ( nullable: true, alias: Structure Surface Type, type: esriFieldTypeSmallInteger )
shape_struct ( nullable: true, alias: Inside Strcture Shape, type: esriFieldTypeSmallInteger )
material_struct ( nullable: true, alias: Inside Structure Material, type: esriFieldTypeSmallInteger )
MACP ( nullable: true, alias: MACP score, type: esriFieldTypeDouble )
surveydate ( nullable: true, length: 8, alias: Survey Date, type: esriFieldTypeDate )
inspectdate ( nullable: true, length: 8, alias: Inspection Date, type: esriFieldTypeDate )
CMT_CAD_GIS ( nullable: true, alias: CMT_CAD_GIS, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
sw_system ( nullable: true, alias: sw_system, type: esriFieldTypeSmallInteger , Coded Values: [0: MS4] , [1: CSO] , [2: MS4-GI] , ...1 more... )
add_et ( nullable: true, alias: add_et, type: esriFieldTypeSmallInteger )
frame_type ( nullable: true, length: 255, alias: frame_type, type: esriFieldTypeString )
distance_to_sub_w_year ( nullable: true, alias: distance_to_sub_w_year, type: esriFieldTypeDouble )
CNVYNAME ( nullable: true, length: 250, alias: 7!Subdivision Name, type: esriFieldTypeString )
FREQUENCY ( nullable: true, alias: FREQUENCY, type: esriFieldTypeInteger )
MIN_year_built ( nullable: true, alias: MIN_year_built, type: esriFieldTypeDouble )
Platt_year ( nullable: true, alias: Platt_year, type: esriFieldTypeInteger )
year_final ( nullable: true, length: 255, alias: year_final, type: esriFieldTypeString )
LoFMACP ( nullable: true, alias: LoFMACP, type: esriFieldTypeSingle )
shape ( nullable: false, alias: Shape, type: esriFieldTypeGeometry )
InspectionID ( nullable: true, alias: InspectionID, type: esriFieldTypeInteger )
cmt_proxy_year ( nullable: true, length: 8, alias: CMT Proxy Year, type: esriFieldTypeDate )
near_address ( nullable: true, length: 255, alias: Nearest Address, type: esriFieldTypeString )
fg_length ( nullable: true, alias: Frame & Grate - Length, type: esriFieldTypeDouble )
fg_width ( nullable: true, alias: Frame & Grate - Width, type: esriFieldTypeDouble )
fg_diameter ( nullable: true, alias: Frame & Grate - Diameter, type: esriFieldTypeDouble )
StreetID ( nullable: true, length: 255, alias: Street ID, type: esriFieldTypeString )
cmt_proxy_bottomelev ( nullable: true, alias: CMT Proxy Bottom Elevation, type: esriFieldTypeDouble )
FOTH_DRAC_GIS ( nullable: true, alias: FOTH_DRAC_GIS, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
ESRIGNSS_POSITIONSOURCETYPE ( nullable: true, alias: Position source type, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...3 more... )
ESRIGNSS_RECEIVER ( nullable: true, length: 50, alias: Receiver Name, type: esriFieldTypeString )
ESRIGNSS_LATITUDE ( nullable: true, alias: Latitude, type: esriFieldTypeDouble )
ESRIGNSS_LONGITUDE ( nullable: true, alias: Longitude, type: esriFieldTypeDouble )
ESRIGNSS_ALTITUDE ( nullable: true, alias: Altitude, type: esriFieldTypeDouble )
ESRIGNSS_H_RMS ( nullable: true, alias: Horizontal Accuracy (m), type: esriFieldTypeDouble )
ESRIGNSS_V_RMS ( nullable: true, alias: Vertical Accuracy (m), type: esriFieldTypeDouble )
ESRIGNSS_FIXDATETIME ( nullable: true, length: 8, alias: Fix Time, type: esriFieldTypeDate )
ESRIGNSS_FIXTYPE ( nullable: true, alias: Fix Type, type: esriFieldTypeSmallInteger , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
ESRIGNSS_CORRECTIONAGE ( nullable: true, alias: Correction Age, type: esriFieldTypeDouble )
ESRIGNSS_STATIONID ( nullable: true, alias: Station ID, type: esriFieldTypeSmallInteger , Range: [0, 1023] )
ESRIGNSS_NUMSATS ( nullable: true, alias: Number of Satellites, type: esriFieldTypeSmallInteger , Range: [0, 99] )
ESRIGNSS_PDOP ( nullable: true, alias: PDOP, type: esriFieldTypeDouble )
ESRIGNSS_HDOP ( nullable: true, alias: HDOP, type: esriFieldTypeDouble )
ESRIGNSS_VDOP ( nullable: true, alias: VDOP, type: esriFieldTypeDouble )
ESRIGNSS_DIRECTION ( nullable: true, alias: Direction of travel (°), type: esriFieldTypeDouble )
ESRIGNSS_SPEED ( nullable: true, alias: Speed (km/h), type: esriFieldTypeDouble )
ESRISNSR_AZIMUTH ( nullable: true, alias: Compass reading (°), type: esriFieldTypeDouble )
ESRIGNSS_AVG_H_RMS ( nullable: true, alias: Average Horizontal Accuracy (m), type: esriFieldTypeDouble )
ESRIGNSS_AVG_V_RMS ( nullable: true, alias: Average Vertical Accuracy (m), type: esriFieldTypeDouble )
ESRIGNSS_AVG_POSITIONS ( nullable: true, alias: Averaged Positions, type: esriFieldTypeSmallInteger )
ESRIGNSS_H_STDDEV ( nullable: true, alias: Standard Deviation (m), type: esriFieldTypeDouble )

Types:

isconnected:
Inherited
validationstatus:
Inherited
sw_system:
Inherited
assettype:
Coded Values: [0: Unknown]
CMT_CAD_GIS:
Inherited

designtype:
Coded Values: [0: Unknown] , [1: Centerfugal Pump] , [2: Duplex Pump] , ...4 more...
spatialsource:
Inherited
isconnected:
Inherited
maintby:
Inherited
validationstatus:
Inherited
sw_system:
Inherited
ownedby:
Inherited
assettype:
Coded Values: [0: Unknown] , [61: Pump]
lifecyclestatus:
Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
CMT_CAD_GIS:
Inherited

surface:
Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
shape_struct:
Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
spatialsource:
Inherited
lifecyclestatus:
Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
CMT_CAD_GIS:
Inherited
surfacewater:
Coded Values: [0: Unknown] , [1: Yes] , [2: No]
material:
Coded Values: [100: Other] , [0: Not known] , [1: ABS Plastic] , ...9 more...
material_struct:
Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...30 more...
isconnected:
Inherited
maintby:
Inherited
validationstatus:
Inherited
location:
Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
sw_system:
Inherited
ownedby:
Inherited
assettype:
Coded Values: [0: Unknown] , [281: Broad-Crested] , [282: Combination] , ...4 more...

surface:
Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
spatialsource:
Inherited
lifecyclestatus:
Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
CMT_CAD_GIS:
Inherited
diameter:
Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...27 more...
material:
Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...24 more...
isconnected:
Inherited
maintby:
Inherited
validationstatus:
Inherited
location:
Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
sw_system:
Inherited
ownedby:
Inherited
assettype:
Coded Values: [0: Unknown] , [1: Cleanout]

surface:
Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
spatialsource:
Inherited
lifecyclestatus:
Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
CMT_CAD_GIS:
Inherited
surfacewater:
Coded Values: [0: Unknown] , [1: Yes] , [2: No]
material:
Coded Values: [0: Unknown] , [1: Amended Soil] , [2: Biochar] , ...13 more...
material_struct:
Coded Values: [0: Unknown] , [1: Amended Soil] , [2: Biochar] , ...13 more...
isconnected:
Inherited
maintby:
Inherited
validationstatus:
Inherited
location:
Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
sw_system:
Inherited
ownedby:
Inherited
assettype:
Coded Values: [0: Unknown] , [2: Detention Basin] , [3: Dry Basin] , ...15 more...

surface:
Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
spatialsource:
Inherited
lifecyclestatus:
Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
CMT_CAD_GIS:
Inherited
surfacewater:
Coded Values: [0: Unknown] , [1: Yes] , [2: No]
diameter:
Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
material:
Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...25 more...
designtype:
Coded Values: [0: Unknown] , [9: Tide Gate Chamber] , [11: Flap Gate] , ...5 more...
isconnected:
Inherited
maintby:
Inherited
validationstatus:
Inherited
location:
Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
sw_system:
Inherited
ownedby:
Inherited
assettype:
Coded Values: [0: Unknown] , [6: Apron Inlet] , [7: Pipe Inlet] , ...1 more...

spatialsource:
Inherited
isconnected:
Inherited
maintby:
Inherited
validationstatus:
Inherited
sw_system:
Inherited
ownedby:
Inherited
assettype:
Coded Values: [0: Unknown] , [241: Pipe Connection] , [242: Open Channel Connection] , ...1 more...
lifecyclestatus:
Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
CMT_CAD_GIS:
Inherited

surface:
Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
shape_struct:
Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
spatialsource:
Inherited
lifecyclestatus:
Inherited
CMT_CAD_GIS:
Inherited
surfacewater:
Coded Values: [0: Unknown] , [1: Yes] , [2: No]
diameter:
Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
material:
Coded Values: [100: Other] , [0: Not known] , [1: ABS Plastic] , ...9 more...
designtype:
Coded Values: [0: Unknown] , [3: Solid] , [4: Vented/Slotted] , ...4 more...
inletshape:
Coded Values: [0: Unknown] , [3: Arched (with flat bottom)] , [4: Barrel] , ...9 more...
material_struct:
Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...30 more...
isconnected:
Inherited
maintby:
Inherited
validationstatus:
Inherited
location:
Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
sw_system:
Inherited
ownedby:
Inherited
assettype:
Inherited
conetype:
Coded Values: [0: Unknown] , [1: Straight] , [2: Offset] , ...2 more...

surface:
Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
shape_struct:
Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
spatialsource:
Inherited
lifecyclestatus:
Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
CMT_CAD_GIS:
Inherited
surfacewater:
Coded Values: [0: Unknown] , [1: Yes] , [2: No]
diameter:
Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
material:
Coded Values: [100: Other] , [0: Not known] , [1: ABS Plastic] , ...9 more...
designtype:
Coded Values: [0: Unknown] , [1: Curb Opening] , [2: Grate] , ...1 more...
inletshape:
Coded Values: [0: Unknown] , [1: Round] , [2: Square] , ...1 more...
material_struct:
Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...30 more...
isconnected:
Inherited
maintby:
Inherited
validationstatus:
Inherited
location:
Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
sw_system:
Inherited
ownedby:
Inherited
assettype:
Coded Values: [0: Unknown] , [204: Infiltration] , [210: Drop Inlet] , ...1 more...
conetype:
Coded Values: [0: Unknown] , [1: Straight] , [2: Offset] , ...2 more...

spatialsource:
Inherited
isconnected:
Inherited
maintby:
Inherited
validationstatus:
Inherited
sw_system:
Inherited
ownedby:
Inherited
lifecyclestatus:
Inherited
CMT_CAD_GIS:
Inherited

surface:
Coded Values: [0: Unknown] , [1: Asphalt] , [2: Concrete Pavement] , ...4 more...
spatialsource:
Inherited
lifecyclestatus:
Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
CMT_CAD_GIS:
Inherited
surfacewater:
Coded Values: [0: Unknown] , [1: Yes] , [2: No]
diameter:
Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...31 more...
material:
Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...25 more...
designtype:
Coded Values: [0: Unknown] , [9: Tide Gate Chamber] , [11: Flap Gate] , ...5 more...
isconnected:
Inherited
maintby:
Inherited
validationstatus:
Inherited
location:
Coded Values: [0: Unknown] , [1: Main Highway] , [2: Light Highway] , ...11 more...
add_et:
Coded Values: [0: N/A] , [1: Flap Gate] , [2: Apron] , ...4 more...
sw_system:
Inherited
ownedby:
Inherited
assettype:
Coded Values: [0: Unknown] , [3: Culvert Inlet] , [4: Culvert Outlet] , ...2 more...

Relationships:

SDE.MACP_InspectionRatingsCombined (0) -- Related To: MACP_InspectionRatingsCombined (34)
MACP_Conditions (1) -- Related To: Manhole_Conditions (35)
Manhole Conditions (2) -- Related To: Manhole_Connections (37)
SDE.DischargeInspection_1 (3) -- Related To: End Treatment Inspection (32)

Layer: Stormwater Line (23)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

MaxSelectionCount:

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: 0
Label: Unknown
Description: N/A
Symbol:
Value: 4
Label: Pipe
Description: N/A
Symbol:
Value: 5
Label: Open Channel
Description: N/A
Symbol:
Value: 6
Label: Culvert
Description: N/A
Symbol:
Value: 7
Label: Linear Drain
Description: N/A
Symbol:

Transparency:

Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

HasZ: true

HasM: true

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

OBJECTID ( nullable: false, alias: Object ID, type: esriFieldTypeOID )
assetid ( nullable: true, length: 64, alias: Asset ID, type: esriFieldTypeString )
assetgroup ( nullable: false, alias: Asset group, type: esriFieldTypeInteger )
assettype ( nullable: false, alias: Asset type, type: esriFieldTypeSmallInteger )
pipeshape ( nullable: true, alias: Culvert Shape, Pipe Shape, type: esriFieldTypeSmallInteger )
diameter ( nullable: true, alias: Diameter (in), type: esriFieldTypeDouble )
width ( nullable: true, alias: Width (in), type: esriFieldTypeDouble )
height ( nullable: true, alias: Height (in), type: esriFieldTypeDouble )
material ( nullable: true, alias: Material, type: esriFieldTypeSmallInteger )
us_structure ( nullable: true, length: 255, alias: US Structure ID, type: esriFieldTypeString )
upelev ( nullable: true, alias: Upstream Elevation, type: esriFieldTypeDouble )
ds_structure ( nullable: true, length: 255, alias: DS Structure ID, type: esriFieldTypeString )
downelev ( nullable: true, alias: Downstream Elevation, type: esriFieldTypeDouble )
slope ( nullable: true, alias: Slope (%), type: esriFieldTypeDouble )
measuredlength ( nullable: true, alias: Measured Length (ft), type: esriFieldTypeDouble )
installdate ( nullable: true, length: 8, alias: Install Date, type: esriFieldTypeDate )
surveydate ( nullable: true, length: 8, alias: Survey Date, type: esriFieldTypeDate )
inspected ( nullable: true, alias: inspected, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
inspectdate ( nullable: true, length: 8, alias: Inspection Date, type: esriFieldTypeDate )
pacp_score ( nullable: true, alias: PACP Score, type: esriFieldTypeDouble )
notes ( nullable: true, length: 2000, alias: Notes, type: esriFieldTypeString )
spatialsource ( nullable: true, alias: Spatial Source, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more... )
lifecyclestatus ( nullable: false, alias: Lifecycle Status, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more... )
lined ( nullable: true, alias: Lined?, type: esriFieldTypeSmallInteger )
lineryear ( nullable: true, alias: Liner Year, type: esriFieldTypeSmallInteger )
linermethod ( nullable: true, alias: Liner Method, type: esriFieldTypeSmallInteger )
ownedby ( nullable: true, alias: Owned By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
maintby ( nullable: true, alias: Maintained By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
wall ( nullable: true, alias: Wall (Y/N), type: esriFieldTypeSmallInteger )
CMT_CAD_GIS ( nullable: true, alias: CMT_CAD_GIS, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
derived_year ( nullable: true, length: 255, alias: Derived Year, type: esriFieldTypeString )
sw_system ( nullable: true, alias: SW System, type: esriFieldTypeSmallInteger , Coded Values: [0: MS4] , [1: CSO] , [2: MS4-GI] , ...1 more... )
isconnected ( nullable: false, alias: Is connected, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] , [2: Unknown] )
validationstatus ( nullable: true, alias: Validation status, type: esriFieldTypeSmallInteger , Coded Values: [0: No calculation required, no validation required, no error] , [1: No calculation required, no validation required, has error(s)] , [2: No calculation required, validation required, no error] , ...5 more... )
GlobalID_1 ( nullable: false, length: 38, alias: GlobalID_1, type: esriFieldTypeGlobalID )
globalid ( nullable: false, length: 38, alias: Global ID, type: esriFieldTypeGUID )
creationdate ( nullable: true, length: 8, alias: Creation date, type: esriFieldTypeDate )
creator ( nullable: true, length: 255, alias: Creator, type: esriFieldTypeString )
lastupdate ( nullable: true, length: 8, alias: Last update, type: esriFieldTypeDate )
updatedby ( nullable: true, length: 255, alias: Updated by, type: esriFieldTypeString )
shape ( nullable: false, alias: Shape, type: esriFieldTypeGeometry )
shape.STLength() ( nullable: true, alias: shape.STLength(), type: esriFieldTypeDouble )
LoFPACP ( nullable: true, alias: LoFPACP, type: esriFieldTypeSingle )
InspectionID ( nullable: true, alias: InspectionID, type: esriFieldTypeInteger )
cmt_proxy_year ( nullable: true, length: 8, alias: CMT Proxy Year, type: esriFieldTypeDate )
near_address ( nullable: true, length: 255, alias: near_address, type: esriFieldTypeString )
StreetID ( nullable: true, length: 255, alias: Street ID, type: esriFieldTypeString )
FOTH_DRAC_GIS ( nullable: true, alias: FOTH_DRAC_GIS, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
ESRIGNSS_AVG_H_RMS ( nullable: true, alias: Average Horizontal Accuracy (m), type: esriFieldTypeDouble )
ESRIGNSS_AVG_V_RMS ( nullable: true, alias: Average Vertical Accuracy (m), type: esriFieldTypeDouble )
ESRIGNSS_WORST_H_RMS ( nullable: true, alias: Worst Horizontal Accuracy (m), type: esriFieldTypeDouble )
ESRIGNSS_WORST_V_RMS ( nullable: true, alias: Worst Vertical Accuracy (m), type: esriFieldTypeDouble )
ESRIGNSS_WORST_FIXTYPE ( nullable: true, alias: Worst Fix Type, type: esriFieldTypeSmallInteger , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
ESRIGNSS_MANUAL_LOCATIONS ( nullable: true, alias: Number of Manual Locations, type: esriFieldTypeInteger )

Types:

isconnected:
Inherited
validationstatus:
Inherited
sw_system:
Inherited
assettype:
Coded Values: [0: Unknown]
inspected:
Inherited
CMT_CAD_GIS:
Inherited

spatialsource:
Inherited
lifecyclestatus:
Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
inspected:
Inherited
CMT_CAD_GIS:
Inherited
lined:
Coded Values: [0: Unknown] , [1: Yes] , [2: No]
diameter:
Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...34 more...
material:
Coded Values: [3: Asphalt - ASP] , [13: Galvanized Pipe - GP] , [14: Glass Reinforced Cement - GRC] , ...25 more...
pipeshape:
Coded Values: [0: Unknown] , [1: Circular] , [2: Horseshoe] , ...5 more...
isconnected:
Inherited
maintby:
Inherited
linermethod:
Coded Values: [0: Not Known] , [1: Cured-In-Place Pipe] , [2: Fold and Form or Deform/Reform] , ...11 more...
validationstatus:
Inherited
lineryear:
Range: [1800, 2060]
sw_system:
Inherited
ownedby:
Inherited
assettype:
Coded Values: [0: Unknown] , [3: Gravity Pipe] , [4: Force Pipe] , ...2 more...

material:
Coded Values: [0: Unknown] , [1: Amended Soil] , [2: Biochar] , ...13 more...
spatialsource:
Inherited
isconnected:
Inherited
maintby:
Inherited
validationstatus:
Inherited
sw_system:
Inherited
ownedby:
Inherited
assettype:
Coded Values: [0: Unknown] , [43: Aquaduct Channel] , [44: Spillway Channel] , ...3 more...
lifecyclestatus:
Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
inspected:
Inherited
CMT_CAD_GIS:
Inherited

spatialsource:
Inherited
lifecyclestatus:
Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
inspected:
Inherited
CMT_CAD_GIS:
Inherited
lined:
Coded Values: [0: Unknown] , [1: Yes] , [2: No]
diameter:
Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...34 more...
material:
Coded Values: [3: Asphalt - ASP] , [13: Galvanized Pipe - GP] , [14: Glass Reinforced Cement - GRC] , ...25 more...
pipeshape:
Coded Values: [0: Unknown] , [1: Circular] , [2: Horseshoe] , ...5 more...
isconnected:
Inherited
maintby:
Inherited
linermethod:
Coded Values: [0: Not Known] , [1: Cured-In-Place Pipe] , [2: Fold and Form or Deform/Reform] , ...11 more...
validationstatus:
Inherited
lineryear:
Range: [1800, 2060]
sw_system:
Inherited
ownedby:
Inherited
wall:
Coded Values: [0: Unknown] , [1: Yes] , [2: No]
assettype:
Coded Values: [0: Unknown] , [81: Pipe Culvert] , [82: Pipe Arch] , ...3 more...

spatialsource:
Inherited
lifecyclestatus:
Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
inspected:
Inherited
CMT_CAD_GIS:
Inherited
diameter:
Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...34 more...
material:
Coded Values: [3: Asphalt - ASP] , [13: Galvanized Pipe - GP] , [14: Glass Reinforced Cement - GRC] , ...25 more...
pipeshape:
Coded Values: [0: Unknown] , [1: Circular] , [2: Horseshoe] , ...5 more...
isconnected:
Inherited
maintby:
Inherited
validationstatus:
Inherited
sw_system:
Inherited
ownedby:
Inherited
assettype:
Coded Values: [0: Unknown] , [121: Trench Drain] , [122: Slotted Drain]

Relationships:

PACP Conditions (4) -- Related To: PACP_Conditions (36)
SDE.PACP_InspectionRatingsCombined (5) -- Related To: PACP_InspectionRatingsCombined (33)

Layer: StructureBoundary (29)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

MaxSelectionCount:

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: 0
Label: Unknown
Description: N/A
Symbol:
Value: 401
Label: BMP Boundary
Description: N/A
Symbol:
Value: 404
Label: Storm Lift Station Boundary
Description: N/A
Symbol:

Transparency:

Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

HasZ: true

HasM: true

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

OBJECTID ( nullable: false, alias: Object ID, type: esriFieldTypeOID )
assetid ( nullable: true, length: 64, alias: Asset ID, type: esriFieldTypeString )
assetgroup ( nullable: false, alias: Asset group, type: esriFieldTypeInteger )
assettype ( nullable: false, alias: Asset type, type: esriFieldTypeSmallInteger )
lifecyclestatus ( nullable: false, alias: Lifecycle Status, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more... )
depth ( nullable: true, alias: Depth, type: esriFieldTypeDouble )
bmpclass ( nullable: true, alias: BMP Class, type: esriFieldTypeSmallInteger )
assetcondition ( nullable: true, alias: Condition, type: esriFieldTypeSmallInteger )
notes ( nullable: true, length: 255, alias: Notes, type: esriFieldTypeString )
spatialsource ( nullable: true, alias: Spatial Source, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more... )
spatialconfidence ( nullable: true, alias: Spatial Confidence, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: High] , [2: Medium] , ...1 more... )
sw_system ( nullable: true, alias: SW System, type: esriFieldTypeSmallInteger , Coded Values: [0: MS4] , [1: CSO] , [2: MS4-GI] , ...1 more... )
CMT_CAD_GIS ( nullable: true, alias: CMT_CAD_GIS, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
associationstatus ( nullable: false, alias: Association status, type: esriFieldTypeSmallInteger )
subnetworkname ( nullable: false, length: 2000, alias: Subnetwork name, type: esriFieldTypeString )
globalid ( nullable: false, length: 38, alias: Global ID, type: esriFieldTypeGUID )
GlobalID_1 ( nullable: false, length: 38, alias: GlobalID_1, type: esriFieldTypeGlobalID )
created_user ( nullable: true, length: 255, alias: created_user, type: esriFieldTypeString )
created_date ( nullable: true, length: 8, alias: created_date, type: esriFieldTypeDate )
last_edited_user ( nullable: true, length: 255, alias: last_edited_user, type: esriFieldTypeString )
last_edited_date ( nullable: true, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
shape ( nullable: false, alias: Shape, type: esriFieldTypeGeometry )
shape.STArea() ( nullable: true, alias: shape.STArea(), type: esriFieldTypeDouble )
shape.STLength() ( nullable: true, alias: shape.STLength(), type: esriFieldTypeDouble )
InstallDate ( nullable: true, length: 8, alias: Install Date, type: esriFieldTypeDate )
cmt_proxy_year ( nullable: true, length: 8, alias: CMT Proxy Year, type: esriFieldTypeDate )
near_address ( nullable: true, length: 255, alias: near_address, type: esriFieldTypeString )
StreetID ( nullable: true, length: 255, alias: Street ID, type: esriFieldTypeString )
FOTH_DRAC_GIS ( nullable: true, alias: FOTH_DRAC_GIS, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
ESRIGNSS_AVG_H_RMS ( nullable: true, alias: Average Horizontal Accuracy (m), type: esriFieldTypeDouble )
ESRIGNSS_AVG_V_RMS ( nullable: true, alias: Average Vertical Accuracy (m), type: esriFieldTypeDouble )
ESRIGNSS_WORST_H_RMS ( nullable: true, alias: Worst Horizontal Accuracy (m), type: esriFieldTypeDouble )
ESRIGNSS_WORST_V_RMS ( nullable: true, alias: Worst Vertical Accuracy (m), type: esriFieldTypeDouble )
ESRIGNSS_WORST_FIXTYPE ( nullable: true, alias: Worst Fix Type, type: esriFieldTypeSmallInteger , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
ESRIGNSS_MANUAL_LOCATIONS ( nullable: true, alias: Number of Manual Locations, type: esriFieldTypeInteger )

Types:

spatialconfidence:
Inherited
spatialsource:
Inherited
sw_system:
Inherited
lifecyclestatus:
Inherited
CMT_CAD_GIS:
Inherited

spatialconfidence:
Inherited
assetcondition:
Coded Values: [0: Unknown] , [1: More Data Needed] , [2: Inspection Due] , ...4 more...
spatialsource:
Inherited
sw_system:
Inherited
bmpclass:
Coded Values: [0: Unknown] , [1: Centralized] , [2: Decentralized]
assettype:
Coded Values: [0: Unknown] , [2: Detention Basin] , [3: Dry Basin] , ...15 more...
lifecyclestatus:
Inherited
CMT_CAD_GIS:
Inherited

spatialconfidence:
Inherited
spatialsource:
Inherited
sw_system:
Inherited
assettype:
Coded Values: [0: Unknown] , [42: Lift Station]
lifecyclestatus:
Inherited
CMT_CAD_GIS:
Inherited

Layer: Base Layers (4)

Sub Layers:

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: true

MaxRecordCount:

MaxSelectionCount:

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:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

None

Layer: CCTV_Project_Locations_2022 (30)

Parent Layer:

Base Layers

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

MaxSelectionCount:

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:

Label Placement:

Label Expression:

Use Coded Values:

Symbol:

Color:

Background Color:

Outline Color:

Vertical Alignment:

Horizontal Alignment:

Right to Left:

Angle:

XOffset:

YOffset:

Size:

Font Family:

Font Style:

Font Weight:

Font Decoration:

Min. Scale:

Max. Scale:

Feature Draw Order:

N/A

Advanced Query Capabilities:

HasZ: true

HasM: true

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
Project_ID ( nullable: true, alias: Project ID, type: esriFieldTypeInteger )
MBG_Width ( nullable: true, alias: MBG_Width, type: esriFieldTypeDouble )
MBG_Length ( nullable: true, alias: MBG_Length, type: esriFieldTypeDouble )
Shape ( nullable: true, alias: Shape, type: esriFieldTypeGeometry )
Shape.STArea() ( nullable: true, alias: Shape.STArea(), type: esriFieldTypeDouble )
Shape.STLength() ( nullable: true, alias: Shape.STLength(), type: esriFieldTypeDouble )
ProjectYear ( nullable: true, alias: Project Year, type: esriFieldTypeInteger )

Layer: Municipal_Boundaries (31)

Parent Layer:

Base Layers

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

MaxSelectionCount:

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:

Feature Draw Order:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
NAME ( nullable: true, length: 50, alias: Municipality Name, type: esriFieldTypeString )
MUNITYP ( nullable: true, length: 50, alias: Municipal Type, type: esriFieldTypeString , Coded Values: [City: City] , [Town: Town] , [Village: Village] , ...4 more... )
MUNIAREA ( nullable: true, alias: Area in Square Miles, type: esriFieldTypeDouble )
LOCALFIPS ( nullable: true, length: 5, alias: Local FIPS, type: esriFieldTypeString )
LASTUPDATE ( nullable: true, length: 8, alias: Last Update Date, type: esriFieldTypeDate )
LASTEDITOR ( nullable: true, length: 50, alias: Last Editor, type: esriFieldTypeString )
GlobalID ( nullable: false, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
Shape ( nullable: true, alias: Shape, type: esriFieldTypeGeometry )
Shape.STArea() ( nullable: true, alias: Shape.STArea(), type: esriFieldTypeDouble )
Shape.STLength() ( nullable: true, alias: Shape.STLength(), type: esriFieldTypeDouble )

Tables:

Table: End Treatment Inspection (32)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

MaxSelectionCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

objectid ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
inspector ( nullable: true, length: 50, alias: Inspector, type: esriFieldTypeString )
inspectdt ( nullable: true, length: 8, alias: Inspection Date, type: esriFieldTypeDate )
erosion ( nullable: true, alias: Channel Erosion Severity, type: esriFieldTypeSmallInteger , Coded Values: [1: 1 - Channel bottom, toe and bank are stable] , [2: 2 - Channel bottom is scoured, toe & bank are stable] , [4: 4 - Channel bottom scoured, toe is undercut, bank stable] , ...3 more... )
structure_condition ( nullable: true, alias: Outfall Structural Condition, type: esriFieldTypeSmallInteger , Coded Values: [1: 1 - No signs of failure] , [2: 2 - Cracks are present] , [5: 5 - Structure has moved from original constructure location] , ...2 more... )
notes ( nullable: true, length: 2000, alias: Notes, type: esriFieldTypeString )
dryweather ( nullable: true, alias: Dry Weather Inspection?, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
dateprecip ( nullable: true, length: 8, alias: Date of Last Precipitation, type: esriFieldTypeDate )
amountprecip ( nullable: true, alias: Amount of Last Precipitation, type: esriFieldTypeDouble )
flow ( nullable: true, alias: Flow Present?, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
flowcolor ( nullable: true, alias: Flow contains color?, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
colordesc ( nullable: true, alias: Color Description, type: esriFieldTypeSmallInteger , Coded Values: [1: Redish hue] , [2: Brownish hue] , [3: Yellowish hue] , ...2 more... )
colordesc_other ( nullable: true, length: 50, alias: Specify other, type: esriFieldTypeString )
flowodor ( nullable: true, alias: Flow contains odor?, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
odordesc ( nullable: true, alias: Odor Description, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Musty] , [2: Sewage] , ...5 more... )
odordesc_other ( nullable: true, length: 50, alias: Specify other, type: esriFieldTypeString )
flowfloatable ( nullable: true, alias: Flow contains floatables?, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
floatabledesc ( nullable: true, length: 255, alias: Floatable Description, type: esriFieldTypeString )
recievingwater ( nullable: true, alias: Change in recieving water?, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
recievingwaterdesc ( nullable: true, length: 150, alias: Description of Change, type: esriFieldTypeString )
illicitdischarge ( nullable: true, alias: Is Flow Illicit Discharge?, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
illicitdischargesource ( nullable: true, length: 150, alias: Efforts to determine source, type: esriFieldTypeString )
illicitdischargeaction ( nullable: true, length: 150, alias: Corrective Action Taken, type: esriFieldTypeString )
turbidity ( nullable: true, alias: Turbidity, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Clear] , [2: Slighly Cloudy] , ...2 more... )
assetguid ( nullable: true, length: 38, alias: Asset GUID, type: esriFieldTypeGUID )
globalid ( nullable: false, length: 38, alias: globalid, type: esriFieldTypeGUID )
GlobalID_1 ( nullable: false, length: 38, alias: GlobalID_1, type: esriFieldTypeGlobalID )
creationdate ( nullable: true, length: 8, alias: Creation date, type: esriFieldTypeDate )
creator ( nullable: true, length: 255, alias: Creator, type: esriFieldTypeString )
lastupdate ( nullable: true, length: 8, alias: Last update, type: esriFieldTypeDate )
updatedby ( nullable: true, length: 255, alias: Updated by, type: esriFieldTypeString )
inspector2 ( nullable: true, alias: inspector2, type: esriFieldTypeSmallInteger , Coded Values: [1: JSHELTON] , [2: JHOPWOOD] , [3: JMANKLE] , ...5 more... )
maintenance_required ( nullable: true, alias: maintenance_required, type: esriFieldTypeSmallInteger , Coded Values: [1: 1 - No maintenance required] , [2: 2 - Minor maintenance required (Flow not impeded / routine cleaning only)] , [5: 5 - Moderate maintenance required (Flow impeded / immediate cleaning necessary)] , ...1 more... )
maintenance_note ( nullable: true, length: 255, alias: maintenance_note, type: esriFieldTypeString )

Relationships:

SDE.StormwaterDevice (3) -- Related To: Stormwater Device (1)

Table: PACP_InspectionRatingsCombined (33)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

MaxSelectionCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

Length_Surveyed ( nullable: true, alias: Length_Surveyed, type: esriFieldTypeDouble )
InspectionID ( nullable: true, alias: InspectionID, type: esriFieldTypeInteger )
Downstream_MH ( nullable: false, length: 25, alias: Downstream_MH, type: esriFieldTypeString )
Upstream_MH ( nullable: false, length: 25, alias: Upstream_MH, type: esriFieldTypeString )
Pipe_Segment_Reference ( nullable: true, length: 51, alias: Pipe_Segment_Reference, type: esriFieldTypeString )
OBJECTID ( nullable: false, alias: InspectionID, type: esriFieldTypeOID )
Surveyed_By ( nullable: false, length: 25, alias: Surveyed_By, type: esriFieldTypeString )
Certificate_Number ( nullable: false, length: 15, alias: Certificate_Number, type: esriFieldTypeString )
Reviewed_By ( nullable: true, length: 25, alias: Reviewed_By, type: esriFieldTypeString )
Reviewer_Certificate_Number ( nullable: true, length: 15, alias: Reviewer_Certificate_Number, type: esriFieldTypeString )
Owner ( nullable: true, length: 30, alias: Owner, type: esriFieldTypeString )
Customer ( nullable: true, length: 30, alias: Customer, type: esriFieldTypeString )
PO_Number ( nullable: true, length: 15, alias: PO_Number, type: esriFieldTypeString )
WorkOrder ( nullable: true, length: 20, alias: WorkOrder, type: esriFieldTypeString )
Media_Label ( nullable: true, length: 64, alias: Media_Label, type: esriFieldTypeString )
Project ( nullable: true, length: 64, alias: Project, type: esriFieldTypeString )
Inspection_Date ( nullable: false, length: 8, alias: Inspection_Date, type: esriFieldTypeDate )
Inspection_Time ( nullable: true, length: 8, alias: Inspection_Time, type: esriFieldTypeDate )
Sheet_Number ( nullable: true, alias: Sheet_Number, type: esriFieldTypeInteger )
Weather ( nullable: true, length: 1, alias: Weather, type: esriFieldTypeString , Coded Values: [1: Dry - No precipitation during survey] , [2: Heavy Rain] , [3: Light Rain] , ...2 more... )
PreCleaning ( nullable: false, length: 1, alias: PreCleaning, type: esriFieldTypeString , Coded Values: [H: Heavy Cleaning] , [L: Light Cleaning] , [N: No Pre-Cleaning] , ...2 more... )
Date_Cleaned ( nullable: true, length: 8, alias: Date_Cleaned, type: esriFieldTypeDate )
Flow_Control ( nullable: true, length: 1, alias: Flow_Control, type: esriFieldTypeString , Coded Values: [B: Bypassed] , [D: De-watered Using Jetter] , [L: Lift Station] , ...2 more... )
Purpose ( nullable: true, length: 1, alias: Purpose, type: esriFieldTypeString , Coded Values: [A: Maintenance related] , [B: Infiltration and Inflow investigation] , [C: Post rehabilitation survey] , ...8 more... )
Direction ( nullable: false, length: 1, alias: Direction, type: esriFieldTypeString , Coded Values: [D: Downstream] , [U: Upstream] )
Inspection_Technology_Used_CCTV ( nullable: true, alias: Inspection_Technology_Used_CCTV, type: esriFieldTypeSmallInteger )
Inspection_Technology_Used_Lase ( nullable: true, alias: Inspection_Technology_Used_Laser, type: esriFieldTypeSmallInteger )
Inspection_Technology_Used_Sona ( nullable: true, alias: Inspection_Technology_Used_Sonar, type: esriFieldTypeSmallInteger )
Inspection_Technology_Used_Side ( nullable: true, alias: Inspection_Technology_Used_Sidewall, type: esriFieldTypeSmallInteger )
Inspection_Technology_Used_Zoom ( nullable: true, alias: Inspection_Technology_Used_Zoom, type: esriFieldTypeSmallInteger )
Inspection_Technology_Used_Othe ( nullable: true, alias: Inspection_Technology_Used_Other, type: esriFieldTypeSmallInteger )
Inspection_Status ( nullable: false, length: 2, alias: Inspection_Status, type: esriFieldTypeString , Coded Values: [BM: Buried or Marked] , [DI: Descent Inspection] , [NA: No Access] , ...7 more... )
Consequence_Of_Failure ( nullable: true, length: 4, alias: Consequence_Of_Failure, type: esriFieldTypeString )
Pressure_Value ( nullable: true, alias: Pressure_Value, type: esriFieldTypeDouble )
Drainage_Area ( nullable: true, length: 15, alias: Drainage_Area, type: esriFieldTypeString )
Street ( nullable: false, length: 64, alias: Street, type: esriFieldTypeString )
City ( nullable: false, length: 64, alias: City, type: esriFieldTypeString )
Location_Code ( nullable: true, length: 1, alias: Location_Code, type: esriFieldTypeString , Coded Values: [A: Primary Major Arterial Roads - Interstates, numbered roads or town/city center roads for heavy vehicles] , [B: Secondary Roads - Non-numbered suburban/rural for heavy vehicles] , [C: Local Rural Streets - Light traffic, town and city back streets, estate streets and curbside parking areas] , ...15 more... )
Location_Details ( nullable: true, length: 255, alias: Location_Details, type: esriFieldTypeString )
Pipe_Use ( nullable: true, length: 2, alias: Pipe_Use, type: esriFieldTypeString , Coded Values: [CB: Combined Use] , [DP: Dam Pipe] , [FM: Force Main] , ...7 more... )
Height ( nullable: true, alias: Height, type: esriFieldTypeInteger )
Width ( nullable: true, alias: Width, type: esriFieldTypeInteger )
Material ( nullable: true, length: 4, alias: Material, type: esriFieldTypeString , Coded Values: [ABS: Acrylonitrile Butadiene Styrene] , [AC: Asbestos Cement] , [BR: Brick] , ...24 more... )
Lining_Method ( nullable: true, length: 3, alias: Lining_Method, type: esriFieldTypeString , Coded Values: [CIP: Cured-In-Place Pipe] , [FF: Fold and Form or Deform/Reform] , [FP: Formed-In-Place Liner] , ...11 more... )
Coating_Method ( nullable: true, length: 3, alias: Coating_Method, type: esriFieldTypeString , Coded Values: [CM: Cement Mortar] , [CT: Coal Tar or Bituminous] , [EP: Epoxy] , ...6 more... )
Pipe_Joint_Length ( nullable: true, alias: Pipe_Joint_Length, type: esriFieldTypeDouble )
Total_Length ( nullable: true, alias: Total_Length, type: esriFieldTypeDouble )
Year_Constructed ( nullable: true, alias: Year_Constructed, type: esriFieldTypeInteger )
Year_Renewed ( nullable: true, alias: Year_Renewed, type: esriFieldTypeInteger )
Up_Rim_to_Invert ( nullable: true, alias: Up_Rim_to_Invert, type: esriFieldTypeDouble )
Up_Grade_to_Invert ( nullable: true, alias: Up_Grade_to_Invert, type: esriFieldTypeDouble )
Up_Rim_to_Grade ( nullable: true, alias: Up_Rim_to_Grade, type: esriFieldTypeDouble )
Up_Northing ( nullable: true, length: 50, alias: Up_Northing, type: esriFieldTypeString )
Up_Easting ( nullable: true, length: 50, alias: Up_Easting, type: esriFieldTypeString )
Up_Elevation ( nullable: true, length: 50, alias: Up_Elevation, type: esriFieldTypeString )
Down_Rim_to_Invert ( nullable: true, alias: Down_Rim_to_Invert, type: esriFieldTypeDouble )
Down_Grade_to_Invert ( nullable: true, alias: Down_Grade_to_Invert, type: esriFieldTypeDouble )
Down_Rim_to_Grade ( nullable: true, alias: Down_Rim_to_Grade, type: esriFieldTypeDouble )
Down_Northing ( nullable: true, length: 50, alias: Down_Northing, type: esriFieldTypeString )
Down_Easting ( nullable: true, length: 50, alias: Down_Easting, type: esriFieldTypeString )
Down_Elevation ( nullable: true, length: 50, alias: Down_Elevation, type: esriFieldTypeString )
MH_Coordinate_System ( nullable: true, length: 50, alias: MH_Coordinate_System, type: esriFieldTypeString )
Vertical_Datum ( nullable: true, length: 50, alias: Vertical_Datum, type: esriFieldTypeString )
GPS_Accuracy ( nullable: true, length: 1, alias: GPS_Accuracy, type: esriFieldTypeString )
Additional_Info ( nullable: true, length: 255, alias: Additional_Info, type: esriFieldTypeString )
Reverse_Setup ( nullable: true, alias: Reverse_Setup, type: esriFieldTypeInteger )
IsImperial ( nullable: true, alias: IsImperial, type: esriFieldTypeSmallInteger )
OBJECTID_1 ( nullable: true, alias: OBJECTID_1, type: esriFieldTypeInteger )
STGradeScore1 ( nullable: true, alias: STGradeScore1, type: esriFieldTypeDouble )
STGradeScore2 ( nullable: true, alias: STGradeScore2, type: esriFieldTypeDouble )
STGradeScore3 ( nullable: true, alias: STGradeScore3, type: esriFieldTypeDouble )
STGradeScore4 ( nullable: true, alias: STGradeScore4, type: esriFieldTypeDouble )
STGradeScore5 ( nullable: true, alias: STGradeScore5, type: esriFieldTypeDouble )
OMGradeScore1 ( nullable: true, alias: OMGradeScore1, type: esriFieldTypeDouble )
OMGradeScore2 ( nullable: true, alias: OMGradeScore2, type: esriFieldTypeDouble )
OMGradeScore3 ( nullable: true, alias: OMGradeScore3, type: esriFieldTypeDouble )
OMGradeScore4 ( nullable: true, alias: OMGradeScore4, type: esriFieldTypeDouble )
OMGradeScore5 ( nullable: true, alias: OMGradeScore5, type: esriFieldTypeDouble )
STPipeRating ( nullable: true, alias: STPipeRating, type: esriFieldTypeDouble )
OMPipeRating ( nullable: true, alias: OMPipeRating, type: esriFieldTypeDouble )
OverallPipeRating ( nullable: true, alias: OverallPipeRating, type: esriFieldTypeDouble )
STQuickRating ( nullable: true, length: 4, alias: STQuickRating, type: esriFieldTypeString )
OMQuickRating ( nullable: true, length: 4, alias: OMQuickRating, type: esriFieldTypeString )
PACPQuickRating ( nullable: true, length: 4, alias: PACPQuickRating, type: esriFieldTypeString )
STPipeRatingsIndex ( nullable: true, alias: STPipeRatingsIndex, type: esriFieldTypeDouble )
OMPipeRatingsIndex ( nullable: true, alias: OMPipeRatingsIndex, type: esriFieldTypeDouble )
OverallPipeRatingsIndex ( nullable: true, alias: OverallPipeRatingsIndex, type: esriFieldTypeDouble )
LoFPACP ( nullable: true, alias: LoFPACP, type: esriFieldTypeDouble )
Risk ( nullable: true, alias: Risk, type: esriFieldTypeDouble )
AssetGUID ( nullable: true, length: 38, alias: AssetGUID, type: esriFieldTypeGUID )
Shape ( nullable: true, length: 1, alias: Shape, type: esriFieldTypeString )

Relationships:

SDE.StormwaterLine (5) -- Related To: Stormwater Line (23)

Table: MACP_InspectionRatingsCombined (34)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

MaxSelectionCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

OBJECTID ( nullable: false, alias: InspectionID, type: esriFieldTypeOID )
Surveyed_By ( nullable: false, length: 25, alias: Surveyed_By, type: esriFieldTypeString )
Certificate_Number ( nullable: false, length: 15, alias: Certificate_Number, type: esriFieldTypeString )
Reviewed_By ( nullable: true, length: 25, alias: Reviewed_By, type: esriFieldTypeString )
Reviewer_Certificate_Number ( nullable: true, length: 15, alias: Reviewer_Certificate_Number, type: esriFieldTypeString )
Owner ( nullable: true, length: 30, alias: Owner, type: esriFieldTypeString )
Customer ( nullable: true, length: 30, alias: Customer, type: esriFieldTypeString )
PO_Number ( nullable: true, length: 15, alias: PO_Number, type: esriFieldTypeString )
WorkOrder ( nullable: true, length: 20, alias: WorkOrder, type: esriFieldTypeString )
Media_Label ( nullable: true, length: 64, alias: Media_Label, type: esriFieldTypeString )
Project ( nullable: true, length: 64, alias: Project, type: esriFieldTypeString )
Inspection_Date ( nullable: false, length: 8, alias: Inspection_Date, type: esriFieldTypeDate )
Inspection_Time ( nullable: true, length: 8, alias: Inspection_Time, type: esriFieldTypeDate )
Sheet_Number ( nullable: true, alias: Sheet_Number, type: esriFieldTypeInteger )
Weather ( nullable: true, length: 1, alias: Weather, type: esriFieldTypeString , Coded Values: [1: Dry - No precipitation during survey] , [2: Heavy Rain] , [3: Light Rain] , ...2 more... )
PreCleaning ( nullable: true, length: 1, alias: PreCleaning, type: esriFieldTypeString , Coded Values: [H: Heavy Cleaning] , [L: Light Cleaning] , [N: No Pre-Cleaning] , ...2 more... )
Date_Cleaned ( nullable: true, length: 8, alias: Date_Cleaned, type: esriFieldTypeDate )
Purpose ( nullable: true, length: 1, alias: Purpose, type: esriFieldTypeString , Coded Values: [A: Maintenance related] , [B: Infiltration and Inflow investigation] , [C: Post rehabilitation survey] , ...8 more... )
InspectionLevel ( nullable: false, length: 1, alias: InspectionLevel, type: esriFieldTypeString , Coded Values: [1: Level 1] , [2: Level 2] )
Inspection_Status ( nullable: false, length: 2, alias: Inspection_Status, type: esriFieldTypeString , Coded Values: [BM: Buried or Marked] , [DI: Descent Inspection] , [NA: No Access] , ...7 more... )
Consequence_Of_Failure ( nullable: true, length: 4, alias: Consequence_Of_Failure, type: esriFieldTypeString )
Drainage_Area ( nullable: true, length: 15, alias: Drainage_Area, type: esriFieldTypeString )
Manhole_Number ( nullable: false, length: 25, alias: Manhole_Number, type: esriFieldTypeString )
Street ( nullable: false, length: 64, alias: Street, type: esriFieldTypeString )
City ( nullable: false, length: 64, alias: City, type: esriFieldTypeString )
Location_Code ( nullable: true, length: 1, alias: Location_Code, type: esriFieldTypeString , Coded Values: [A: Primary Major Arterial Roads - Interstates, numbered roads or town/city center roads for heavy vehicles] , [B: Secondary Roads - Non-numbered suburban/rural for heavy vehicles] , [C: Local Rural Streets - Light traffic, town and city back streets, estate streets and curbside parking areas] , ...15 more... )
Surface_Type_Asphalt ( nullable: true, alias: Surface_Type_Asphalt, type: esriFieldTypeSmallInteger )
Surface_Type_ConcretePavement ( nullable: true, alias: Surface_Type_ConcretePavement, type: esriFieldTypeSmallInteger )
Surface_Type_ConcreteCollar ( nullable: true, alias: Surface_Type_ConcreteCollar, type: esriFieldTypeSmallInteger )
Surface_Type_GrassDirt ( nullable: true, alias: Surface_Type_GrassDirt, type: esriFieldTypeSmallInteger )
Surface_Type_Gravel ( nullable: true, alias: Surface_Type_Gravel, type: esriFieldTypeSmallInteger )
Surface_Type_Other ( nullable: true, alias: Surface_Type_Other, type: esriFieldTypeSmallInteger )
Inflow_Potential_from_Runoff ( nullable: true, length: 1, alias: Inflow_Potential_from_Runoff, type: esriFieldTypeString , Coded Values: [I: Inundated] , [N: None] , [P: Ponding] , ...1 more... )
Location_Details ( nullable: true, length: 255, alias: Location_Details, type: esriFieldTypeString )
MH_Use ( nullable: true, length: 2, alias: MH_Use, type: esriFieldTypeString , Coded Values: [CB: Combined] , [DP: Dam] , [FM: Force Main] , ...7 more... )
Access_Type ( nullable: false, length: 4, alias: Access_Type, type: esriFieldTypeString , Coded Values: [ACB: Catch Basin] , [ACOH: Clean Out House] , [ACOM: Clean Out Mainline] , ...7 more... )
Year_Constructed ( nullable: true, alias: Year_Constructed, type: esriFieldTypeSmallInteger )
Year_Renewed ( nullable: true, alias: Year_Renewed, type: esriFieldTypeSmallInteger )
Evidence_Surcharge ( nullable: true, length: 1, alias: Evidence_Surcharge, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
Rim_to_Invert ( nullable: true, alias: Rim_to_Invert, type: esriFieldTypeDouble )
Grade_to_Invert ( nullable: true, alias: Grade_to_Invert, type: esriFieldTypeDouble )
Rim_to_Grade ( nullable: true, alias: Rim_to_Grade, type: esriFieldTypeDouble )
Rim_to_Grade_Exposed ( nullable: true, alias: Rim_to_Grade_Exposed, type: esriFieldTypeDouble )
Northing ( nullable: true, length: 50, alias: Northing, type: esriFieldTypeString )
Easting ( nullable: true, length: 50, alias: Easting, type: esriFieldTypeString )
Elevation ( nullable: true, length: 50, alias: Elevation, type: esriFieldTypeString )
Coordinate_System ( nullable: true, length: 50, alias: Coordinate_System, type: esriFieldTypeString )
Vertical_Datum ( nullable: true, length: 50, alias: Vertical_Datum, type: esriFieldTypeString )
GPS_Accuracy ( nullable: true, length: 1, alias: GPS_Accuracy, type: esriFieldTypeString )
Additional_Info ( nullable: true, length: 255, alias: Additional_Info, type: esriFieldTypeString )
Cover_Type_Bolted ( nullable: true, alias: Cover_Type_Bolted, type: esriFieldTypeSmallInteger )
Cover_Type_Gasketed ( nullable: true, alias: Cover_Type_Gasketed, type: esriFieldTypeSmallInteger )
Cover_Type_Hatch_Double ( nullable: true, alias: Cover_Type_Hatch_Double, type: esriFieldTypeSmallInteger )
Cover_Type_Hatch_Single ( nullable: true, alias: Cover_Type_Hatch_Single, type: esriFieldTypeSmallInteger )
Cover_Type_Inner_Cover ( nullable: true, alias: Cover_Type_Inner_Cover, type: esriFieldTypeSmallInteger )
Cover_Type_Lamphole ( nullable: true, alias: Cover_Type_Lamphole, type: esriFieldTypeSmallInteger )
Cover_Type_Locking ( nullable: true, alias: Cover_Type_Locking, type: esriFieldTypeSmallInteger )
Cover_Type_Removable_Center ( nullable: true, alias: Cover_Type_Removable_Center, type: esriFieldTypeSmallInteger )
Cover_Type_Solid ( nullable: true, alias: Cover_Type_Solid, type: esriFieldTypeSmallInteger )
Cover_Type_Vented ( nullable: true, alias: Cover_Type_Vented, type: esriFieldTypeSmallInteger )
Cover_Shape ( nullable: true, length: 1, alias: Cover_Shape, type: esriFieldTypeString , Coded Values: [C: Circular] , [O: Oval or Elliptical] , [R: Rectangular] , ...3 more... )
Cover_Size ( nullable: true, alias: Cover_Size, type: esriFieldTypeDouble )
Center_Cover_Size ( nullable: true, alias: Center_Cover_Size, type: esriFieldTypeDouble )
Cover_Size_Width ( nullable: true, alias: Cover_Size_Width, type: esriFieldTypeDouble )
Cover_Material ( nullable: true, length: 3, alias: Cover_Material, type: esriFieldTypeString , Coded Values: [AL: Aluminum] , [CAS: Cast Iron] , [CN: Concrete (Cast in Place)] , ...9 more... )
Hole_Diameter ( nullable: true, length: 1, alias: Hole_Diameter, type: esriFieldTypeString , Coded Values: [A: <= 1/2 inch (10mm)] , [B: > 1/2 inch (10mm) <= 1 inch (25mm)] , [C: > 1 inch (25mm) <= 1 1/2 inch (38mm)] , ...2 more... )
Hole_Number ( nullable: true, alias: Hole_Number, type: esriFieldTypeSmallInteger )
Cover_Bearing_Surface_Dia ( nullable: true, alias: Cover_Bearing_Surface_Dia, type: esriFieldTypeDouble )
Cover_Bearing_Surface_Width ( nullable: true, alias: Cover_Bearing_Surface_Width, type: esriFieldTypeDouble )
Cover_Frame_Fit ( nullable: true, length: 1, alias: Cover_Frame_Fit, type: esriFieldTypeString , Coded Values: [G: Good] , [O: Oversized] , [R: Rocks/Wobbles] , ...1 more... )
Cover_Condition_BoltsMissing ( nullable: true, alias: Cover_Condition_BoltsMissing, type: esriFieldTypeSmallInteger )
Cover_Condition_Broken ( nullable: true, alias: Cover_Condition_Broken, type: esriFieldTypeSmallInteger )
Cover_Condition_Corroded ( nullable: true, alias: Cover_Condition_Corroded, type: esriFieldTypeSmallInteger )
Cover_Condition_Cracked ( nullable: true, alias: Cover_Condition_Cracked, type: esriFieldTypeSmallInteger )
Cover_Condition_Missing ( nullable: true, alias: Cover_Condition_Missing, type: esriFieldTypeSmallInteger )
Cover_Condition_Restraint_Defec ( nullable: true, alias: Cover_Condition_Restraint_Defective, type: esriFieldTypeSmallInteger )
Cover_Condition_Restraint_Missi ( nullable: true, alias: Cover_Condition_Restraint_Missing, type: esriFieldTypeSmallInteger )
Cover_Condition_Sound ( nullable: true, alias: Cover_Condition_Sound, type: esriFieldTypeSmallInteger )
Cover_Insert_Type ( nullable: true, length: 1, alias: Cover_Insert_Type, type: esriFieldTypeString , Coded Values: [M: Metal] , [N: None] , [P: Plastic] , ...1 more... )
Insert_Condition_Cracked ( nullable: true, alias: Insert_Condition_Cracked, type: esriFieldTypeSmallInteger )
Insert_Condition_Corroded ( nullable: true, alias: Insert_Condition_Corroded, type: esriFieldTypeSmallInteger )
Insert_Condition_InsertFell ( nullable: true, alias: Insert_Condition_InsertFell, type: esriFieldTypeSmallInteger )
Insert_Condition_Leaking ( nullable: true, alias: Insert_Condition_Leaking, type: esriFieldTypeSmallInteger )
Insert_Condition_PoorlyFitting ( nullable: true, alias: Insert_Condition_PoorlyFitting, type: esriFieldTypeSmallInteger )
Insert_Condition_Sound ( nullable: true, alias: Insert_Condition_Sound, type: esriFieldTypeSmallInteger )
Adjustment_Ring_Type ( nullable: true, length: 1, alias: Adjustment_Ring_Type, type: esriFieldTypeString , Coded Values: [A: Adjustable] , [N: None] , [S: Solid] )
Adjustment_Ring_Material ( nullable: true, length: 3, alias: Adjustment_Ring_Material, type: esriFieldTypeString , Coded Values: [CAS: Cast Iron] , [CN: Concrete (cast in place)] , [CR: Concrete (precast)] , ...8 more... )
Ring_Condition_Broken ( nullable: true, alias: Ring_Condition_Broken, type: esriFieldTypeSmallInteger )
Ring_Condition_Corroded ( nullable: true, alias: Ring_Condition_Corroded, type: esriFieldTypeSmallInteger )
Ring_Condition_Cracked ( nullable: true, alias: Ring_Condition_Cracked, type: esriFieldTypeSmallInteger )
Ring_Condition_Leaking ( nullable: true, alias: Ring_Condition_Leaking, type: esriFieldTypeSmallInteger )
Ring_Condition_PoorInstall ( nullable: true, alias: Ring_Condition_PoorInstall, type: esriFieldTypeSmallInteger )
Ring_Condition_Sound ( nullable: true, alias: Ring_Condition_Sound, type: esriFieldTypeSmallInteger )
Adjustment_Ring_Height ( nullable: true, alias: Adjustment_Ring_Height, type: esriFieldTypeDouble )
Frame_Material ( nullable: true, length: 3, alias: Frame_Material, type: esriFieldTypeString , Coded Values: [CAS: Cast Iron] , [CN: Concrete (cast in place)] , [CR: Concrete (precast)] , ...8 more... )
Frame_Bearing_Surface_Width ( nullable: true, alias: Frame_Bearing_Surface_Width, type: esriFieldTypeDouble )
Frame_Bearing_Surface_Depth ( nullable: true, alias: Frame_Bearing_Surface_Depth, type: esriFieldTypeDouble )
Frame_Clear_Open_Diam ( nullable: true, alias: Frame_Clear_Open_Diam, type: esriFieldTypeDouble )
Frame_Clear_Open_Width ( nullable: true, alias: Frame_Clear_Open_Width, type: esriFieldTypeDouble )
Frame_Condition_Broken ( nullable: true, alias: Frame_Condition_Broken, type: esriFieldTypeSmallInteger )
Frame_Condition_Coated ( nullable: true, alias: Frame_Condition_Coated, type: esriFieldTypeSmallInteger )
Frame_Condition_Corroded ( nullable: true, alias: Frame_Condition_Corroded, type: esriFieldTypeSmallInteger )
Frame_Condition_Cracked ( nullable: true, alias: Frame_Condition_Cracked, type: esriFieldTypeSmallInteger )
Frame_Condition_Missing ( nullable: true, alias: Frame_Condition_Missing, type: esriFieldTypeSmallInteger )
Frame_Condition_Sound ( nullable: true, alias: Frame_Condition_Sound, type: esriFieldTypeSmallInteger )
Seal_Condition_Cracked ( nullable: true, alias: Seal_Condition_Cracked, type: esriFieldTypeSmallInteger )
Seal_Condition_Loose ( nullable: true, alias: Seal_Condition_Loose, type: esriFieldTypeSmallInteger )
Seal_Condition_Missing ( nullable: true, alias: Seal_Condition_Missing, type: esriFieldTypeSmallInteger )
Seal_Condition_Offset ( nullable: true, alias: Seal_Condition_Offset, type: esriFieldTypeSmallInteger )
Seal_Condition_Sound ( nullable: true, alias: Seal_Condition_Sound, type: esriFieldTypeSmallInteger )
Frame_Offset_Distance ( nullable: true, alias: Frame_Offset_Distance, type: esriFieldTypeDouble )
Frame_Seal_Inflow ( nullable: true, length: 2, alias: Frame_Seal_Inflow, type: esriFieldTypeString , Coded Values: [ID: Dripper] , [IG: Gusher] , [IR: Runner] , ...3 more... )
Frame_Depth ( nullable: true, alias: Frame_Depth, type: esriFieldTypeDouble )
Chimney_Present ( nullable: true, length: 1, alias: Chimney_Present, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
Chimney_Material1 ( nullable: true, length: 3, alias: Chimney_Material1, type: esriFieldTypeString , Coded Values: [AC: Asbestos Cement] , [BR: Brick] , [CM: Corrugated Metal] , ...11 more... )
Chimney_Material2 ( nullable: true, length: 3, alias: Chimney_Material2, type: esriFieldTypeString , Coded Values: [AC: Asbestos Cement] , [BR: Brick] , [CM: Corrugated Metal] , ...11 more... )
Chimney_InI ( nullable: true, length: 2, alias: Chimney_InI, type: esriFieldTypeString , Coded Values: [ID: Dripper] , [IG: Gusher] , [IR: Runner] , ...3 more... )
Chimney_Clear_Opening ( nullable: true, alias: Chimney_Clear_Opening, type: esriFieldTypeDouble )
Chimney_Depth ( nullable: true, alias: Chimney_Depth, type: esriFieldTypeDouble )
Chimney_Lining_Interior ( nullable: true, length: 3, alias: Chimney_Lining_Interior, type: esriFieldTypeString , Coded Values: )
Chimney_Lining_Exterior ( nullable: true, length: 3, alias: Chimney_Lining_Exterior, type: esriFieldTypeString , Coded Values: )
Chimney_Condition ( nullable: true, length: 1, alias: Chimney_Condition, type: esriFieldTypeString , Coded Values: [D: Defective] , [S: Sound] , [X: Not Known] )
Cone_Type ( nullable: true, length: 2, alias: Cone_Type, type: esriFieldTypeString , Coded Values: [CC: Conical Centered] , [CO: Conical Off Centered] , [FT: Flat Top] , ...2 more... )
Cone_Material ( nullable: true, length: 3, alias: Cone_Material, type: esriFieldTypeString , Coded Values: [AC: Asbestos Cement] , [BR: Brick] , [CM: Corrugated Metal] , ...11 more... )
Cone_Depth ( nullable: true, alias: Cone_Depth, type: esriFieldTypeDouble )
Cone_Lining_Interior ( nullable: true, length: 3, alias: Cone_Lining_Interior, type: esriFieldTypeString , Coded Values: )
Cone_Lining_Exterior ( nullable: true, length: 3, alias: Cone_Lining_Exterior, type: esriFieldTypeString , Coded Values: )
Cone_Condition ( nullable: true, length: 1, alias: Cone_Condition, type: esriFieldTypeString , Coded Values: [D: Defective] , [S: Sound] , [X: Not Known] )
Wall_Diam ( nullable: true, alias: Wall_Diam, type: esriFieldTypeSmallInteger )
Wall_BySize ( nullable: true, alias: Wall_BySize, type: esriFieldTypeSmallInteger )
Wall_Material ( nullable: true, length: 3, alias: Wall_Material, type: esriFieldTypeString , Coded Values: [AC: Asbestos Cement] , [BR: Brick] , [CM: Corrugated Metal] , ...11 more... )
Wall_Depth ( nullable: true, alias: Wall_Depth, type: esriFieldTypeDouble )
Wall_Lining_Interior ( nullable: true, length: 3, alias: Wall_Lining_Interior, type: esriFieldTypeString , Coded Values: )
Wall_Lining_Exterior ( nullable: true, length: 3, alias: Wall_Lining_Exterior, type: esriFieldTypeString , Coded Values: )
Wall_Condition ( nullable: true, length: 1, alias: Wall_Condition, type: esriFieldTypeString , Coded Values: [D: Defective] , [S: Sound] , [X: Not Known] )
Bench_Present ( nullable: true, length: 1, alias: Bench_Present, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
Bench_Material ( nullable: true, length: 3, alias: Bench_Material, type: esriFieldTypeString , Coded Values: [AC: Asbestos Cement] , [AL: Aluminum] , [BR: Brick] , ...13 more... )
Bench_Lining ( nullable: true, length: 3, alias: Bench_Lining, type: esriFieldTypeString , Coded Values: )
Bench_Condition ( nullable: true, length: 1, alias: Bench_Condition, type: esriFieldTypeString , Coded Values: [D: Defective] , [S: Sound] , [X: Not Known] )
Channel_Installed ( nullable: true, length: 50, alias: Channel_Installed, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
Channel_Material ( nullable: true, length: 3, alias: Channel_Material, type: esriFieldTypeString , Coded Values: [AC: Asbestos Cement] , [AL: Aluminum] , [BR: Brick] , ...13 more... )
Channel_Type ( nullable: true, length: 1, alias: Channel_Type, type: esriFieldTypeString , Coded Values: [F: Formed] , [I: Insert] , [N: None] , ...3 more... )
Channel_Exposure ( nullable: true, length: 1, alias: Channel_Exposure, type: esriFieldTypeString , Coded Values: [C: Closed] , [F: Fully Opened] , [P: Partially Opened] )
Channel_Condition ( nullable: true, length: 1, alias: Channel_Condition, type: esriFieldTypeString , Coded Values: [D: Defective] , [S: Sound] , [X: Not Known] )
Step_Number ( nullable: true, alias: Step_Number, type: esriFieldTypeSmallInteger )
Step_Material ( nullable: true, length: 1, alias: Step_Material, type: esriFieldTypeString , Coded Values: [B: Brick] , [M: Metal] , [P: Plastic] , ...1 more... )
AdditionalComponentInfo ( nullable: true, length: 255, alias: AdditionalComponentInfo, type: esriFieldTypeString )
IsImperial ( nullable: true, alias: IsImperial, type: esriFieldTypeSmallInteger )
OBJECTID_1 ( nullable: true, alias: RatingID, type: esriFieldTypeInteger )
InspectionID ( nullable: true, alias: InspectionID, type: esriFieldTypeInteger )
STGradeScore1 ( nullable: true, alias: STGradeScore1, type: esriFieldTypeDouble )
STGradeScore2 ( nullable: true, alias: STGradeScore2, type: esriFieldTypeDouble )
STGradeScore3 ( nullable: true, alias: STGradeScore3, type: esriFieldTypeDouble )
STGradeScore4 ( nullable: true, alias: STGradeScore4, type: esriFieldTypeDouble )
STGradeScore5 ( nullable: true, alias: STGradeScore5, type: esriFieldTypeDouble )
OMGradeScore1 ( nullable: true, alias: OMGradeScore1, type: esriFieldTypeDouble )
OMGradeScore2 ( nullable: true, alias: OMGradeScore2, type: esriFieldTypeDouble )
OMGradeScore3 ( nullable: true, alias: OMGradeScore3, type: esriFieldTypeDouble )
OMGradeScore4 ( nullable: true, alias: OMGradeScore4, type: esriFieldTypeDouble )
OMGradeScore5 ( nullable: true, alias: OMGradeScore5, type: esriFieldTypeDouble )
STMHRating ( nullable: true, alias: STMHRating, type: esriFieldTypeDouble )
OMMHRating ( nullable: true, alias: OMMHRating, type: esriFieldTypeDouble )
OverallMHRating ( nullable: true, alias: OverallMHRating, type: esriFieldTypeDouble )
STQuickRating ( nullable: true, length: 4, alias: STQuickRating, type: esriFieldTypeString )
OMQuickRating ( nullable: true, length: 4, alias: OMQuickRating, type: esriFieldTypeString )
MACPQuickRating ( nullable: true, length: 4, alias: MACPQuickRating, type: esriFieldTypeString )
STMHRatingsIndex ( nullable: true, alias: STMHRatingsIndex, type: esriFieldTypeDouble )
OMMHRatingsIndex ( nullable: true, alias: OMMHRatingsIndex, type: esriFieldTypeDouble )
OverallMHRatingsIndex ( nullable: true, alias: OverallMHRatingsIndex, type: esriFieldTypeDouble )
LoFMACP ( nullable: true, alias: LoFMACP, type: esriFieldTypeDouble )
Risk ( nullable: true, alias: Risk, type: esriFieldTypeDouble )
CoverType ( nullable: true, length: 255, alias: CoverType, type: esriFieldTypeString )
CoverCondition ( nullable: true, length: 255, alias: CoverCondition, type: esriFieldTypeString )
InsertCondition ( nullable: true, length: 255, alias: InsertCondition, type: esriFieldTypeString )
RingCondition ( nullable: true, length: 255, alias: RingCondition, type: esriFieldTypeString )
FrameCondition ( nullable: true, length: 255, alias: FrameCondition, type: esriFieldTypeString )
SealCondition ( nullable: true, length: 255, alias: SealCondition, type: esriFieldTypeString )
SurfaceType ( nullable: true, length: 255, alias: SurfaceType, type: esriFieldTypeString )
AssetGUID ( nullable: true, length: 38, alias: AssetGUID, type: esriFieldTypeGUID )

Relationships:

SDE.StormwaterDevice (0) -- Related To: Stormwater Device (1)

Table: Manhole_Conditions (35)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

MaxSelectionCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

CMT_CondID ( nullable: true, length: 255, alias: CMT_CondID, type: esriFieldTypeString )
Distance ( nullable: false, alias: Distance, type: esriFieldTypeDouble )
Counter ( nullable: true, alias: Counter, type: esriFieldTypeDouble )
MH_Component_ID ( nullable: false, length: 3, alias: MH_Component_ID, type: esriFieldTypeString , Coded Values: [B: Bench] , [C: Channel] , [CME: Chimney Exterior] , ...5 more... )
MACP_Code ( nullable: false, length: 5, alias: MACP_Code, type: esriFieldTypeString )
Continuous ( nullable: true, length: 3, alias: Continuous, type: esriFieldTypeString )
Value_1st_Dimension ( nullable: true, alias: Value_1st_Dimension, type: esriFieldTypeDouble )
Value_2nd_Dimension ( nullable: true, alias: Value_2nd_Dimension, type: esriFieldTypeDouble )
Value_Percent ( nullable: true, alias: Value_Percent, type: esriFieldTypeDouble )
Joint ( nullable: true, alias: Joint, type: esriFieldTypeSmallInteger )
Step ( nullable: true, alias: Step, type: esriFieldTypeSmallInteger )
Clock_At_From ( nullable: true, alias: Clock_At_From, type: esriFieldTypeSmallInteger )
Clock_To ( nullable: true, alias: Clock_To, type: esriFieldTypeSmallInteger )
Remarks ( nullable: true, length: 255, alias: Remarks, type: esriFieldTypeString )
VCR_Time ( nullable: true, length: 6, alias: VCR_Time, type: esriFieldTypeString )
Grade ( nullable: true, alias: Grade, type: esriFieldTypeSmallInteger )
OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
InspectionID ( nullable: true, alias: InspectionID, type: esriFieldTypeInteger )
AssetGUID ( nullable: true, length: 38, alias: AssetGUID, type: esriFieldTypeGUID )

Relationships:

StormwaterDevice (1) -- Related To: Stormwater Device (1)

Table: PACP_Conditions (36)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

MaxSelectionCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

OBJECTID ( nullable: false, alias: ConditionID, type: esriFieldTypeOID )
InspectionID ( nullable: true, alias: InspectionID, type: esriFieldTypeInteger )
Distance ( nullable: false, alias: Distance, type: esriFieldTypeDouble )
Counter ( nullable: true, alias: Counter, type: esriFieldTypeDouble )
PACP_Code ( nullable: false, length: 5, alias: PACP_Code, type: esriFieldTypeString , Coded Values: [ACB: Access Point Catch Basin] , [ACOM: Access Point Cleanout Mainline] , [AEP: Access Point End of Pipe] , ...124 more... )
Continuous ( nullable: true, length: 3, alias: Continuous, type: esriFieldTypeString )
Value_1st_Dimension ( nullable: true, alias: Value_1st_Dimension, type: esriFieldTypeDouble )
Value_2nd_Dimension ( nullable: true, alias: Value_2nd_Dimension, type: esriFieldTypeDouble )
Value_Percent ( nullable: true, alias: Value_Percent, type: esriFieldTypeDouble )
Joint ( nullable: true, alias: Joint, type: esriFieldTypeSmallInteger )
Clock_At_From ( nullable: true, alias: Clock_At_From, type: esriFieldTypeSmallInteger )
Clock_To ( nullable: true, alias: Clock_To, type: esriFieldTypeSmallInteger )
Remarks ( nullable: true, length: 255, alias: Remarks, type: esriFieldTypeString )
VCR_Time ( nullable: true, length: 6, alias: VCR_Time, type: esriFieldTypeString )
Grade ( nullable: true, alias: Grade, type: esriFieldTypeSmallInteger )
AssetGUID ( nullable: true, length: 38, alias: AssetGUID, type: esriFieldTypeGUID )

Relationships:

Stormwater Line (4) -- Related To: Stormwater Line (23)

Table: Manhole_Connections (37)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

MaxSelectionCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

OBJECTID ( nullable: false, alias: ConnectionID, type: esriFieldTypeOID )
InspectionID ( nullable: false, alias: InspectionID, type: esriFieldTypeInteger )
Pipe_Number ( nullable: false, alias: Pipe_Number, type: esriFieldTypeSmallInteger )
Clock_Position ( nullable: false, alias: Clock_Position, type: esriFieldTypeSmallInteger )
Rim_To_Invert ( nullable: true, alias: Rim_To_Invert, type: esriFieldTypeDouble )
Direction ( nullable: false, length: 1, alias: Direction, type: esriFieldTypeString , Coded Values: [I: In] , [O: Out] )
Material ( nullable: true, length: 4, alias: Material, type: esriFieldTypeString , Coded Values: [ABS: Acrylonitrile Butadiene Styrene] , [AC: Asbestos Cement] , [BR: Brick] , ...24 more... )
PipeShape ( nullable: true, length: 1, alias: Shape, type: esriFieldTypeString , Coded Values: [A: Arched] , [B: Barrel] , [C: Circular] , ...8 more... )
Height ( nullable: true, alias: Height, type: esriFieldTypeSmallInteger )
Width ( nullable: true, alias: Width, type: esriFieldTypeSmallInteger )
Pipe_Condition ( nullable: true, length: 1, alias: Pipe_Condition, type: esriFieldTypeString , Coded Values: [D: Defective] , [S: Sound] , [X: Not Known] )
Pipe_Seal_Condition ( nullable: true, length: 1, alias: Pipe_Seal_Condition, type: esriFieldTypeString , Coded Values: [D: Defective] , [S: Sound] )
Pipe_Type ( nullable: true, length: 2, alias: Pipe_Type, type: esriFieldTypeString , Coded Values: [FM: Force Main] , [GR: Gravity Connection] , [IL: Inside Drop Lower] , ...6 more... )
Structure_ID ( nullable: true, length: 51, alias: Structure_ID, type: esriFieldTypeString )
Pipe_Comments ( nullable: true, length: 255, alias: Pipe_Comments, type: esriFieldTypeString )
AssetGUID ( nullable: true, length: 38, alias: AssetGUID, type: esriFieldTypeGUID )

Relationships:

Stormwater Device (2) -- Related To: Stormwater Device (1)