Layers:

Layer: WW_ManholeJunction (0)

Name: WW_ManholeJunction

Display Field: TAG

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Supports Datum Transformation: true

Extent:
XMin: 1392459.340139687
YMin: 561855.0468131304
XMax: 1454516.2578299195
YMax: 622541.4966147542
Spatial Reference: 102685  (2248)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [135, 0, 43, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: true
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• TAG ( type: esriFieldTypeString, alias: Tag, length: 15 )
• DATEABANDONED ( type: esriFieldTypeDate, alias: Date Abandoned, length: 8 )
• LAST_ORG ( type: esriFieldTypeString, alias: Last Organization, length: 3 , Coded Values: [100: Buchart Horn, Inc.] , [110: Chesapeake Environmental Management, Inc.] , [120: Enterprise Information Solutions, Inc.] , ...22 more... )
• CAPTURE_METHOD ( type: esriFieldTypeString, alias: Capture_Method, length: 4 , Coded Values: [PLAT: Wastewater Plat Map] , [CD: Contract Drawing] , [ORTH: Orthophoto Interpretation] , ...13 more... )
• LAST_USER ( type: esriFieldTypeString, alias: Last Editor, length: 20 )
• EDIT_DATE ( type: esriFieldTypeDate, alias: Edit Date, length: 8 )
• MANHOLE_ID ( type: esriFieldTypeString, alias: Manhole ID, length: 15 )
• GROUND_RIM_HEIGHT ( type: esriFieldTypeDouble, alias: GROUND_RIM_HEIGHT )
• RIM_ELEV_CITY ( type: esriFieldTypeDouble, alias: Rim Elevation City Grid )
• RIM_ELEV_SP ( type: esriFieldTypeDouble, alias: Rim Elevation State Plane )
• OVERFLOW ( type: esriFieldTypeString, alias: Overflow, length: 3 , Coded Values: [A: Active] , [I: Inactive] , [E: Eliminated] , ...1 more... )
• OVERFLOW_ELEV_CITY ( type: esriFieldTypeDouble, alias: Overflow Elevation City Grid )
• OVERFLOW_ELEV_SP ( type: esriFieldTypeDouble, alias: Overflow Elevation State Plane )
• FEAT_STATUS ( type: esriFieldTypeString, alias: Feature Status, length: 3 , Coded Values: [ACT: Active] , [ABD: Abandoned] , [PRO: Proposed] , ...6 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• RIM_ELEV_SRC ( type: esriFieldTypeString, alias: RIM_ELEV_SRC, length: 4 , Coded Values: [PLAT: Wastewater Plat Map] , [CDP: Construction Design Plans] , [CAP: Construction As-Built Plans] , ...3 more... )
• RIM_ELEV_DATUM ( type: esriFieldTypeString, alias: RIM_ELEV_DATUM, length: 8 , Coded Values: [NAVD88: Maryland State Plane NAVD88 elevation datum] , [CI: Baltimore City elevation datum] )
• OVERFLOW_ELEV_SRC ( type: esriFieldTypeString, alias: OVERFLOW_ELEV_SRC, length: 4 , Coded Values: [PLAT: Wastewater Plat Map] , [CDP: Construction Design Plans] , [CAP: Construction As-Built Plans] , ...3 more... )
• OVERFLOW_ELEV_DATUM ( type: esriFieldTypeString, alias: OVERFLOW_ELEV_DATUM, length: 8 , Coded Values: [NAVD88: Maryland State Plane NAVD88 elevation datum] , [CI: Baltimore City elevation datum] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED , Coded Values: [0: False] , [1: True] )
• GLOBALOID ( type: esriFieldTypeString, alias: GLOBALOID, length: 38 )
• AGENCY_OWNER ( type: esriFieldTypeString, alias: AGENCY_OWNER, length: 5 , Coded Values: [DPW: Department of Public Works] , [HABC: Housing Authority of Baltimore City] , [PRV: Private] , ...3 more... )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 20 )
• DOCPOPURL ( type: esriFieldTypeString, alias: DOCPOPURL, length: 250 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Relationships:

• WW_MH_Projects (0) -- Related To: Asset_Tracking.DBO.WW_MH_Projects (5)
• MH_Work_Activity_Report (1) -- Related To: Asset_Tracking.DBO.MH_Work_Activity_Report (3)

Layer: WW_Sewer (1)

Name: WW_Sewer

Display Field: TAG

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Supports Datum Transformation: true

Extent:
XMin: 1392368.5732233971
YMin: 560492.8176143467
XMax: 1454640.1042595208
YMax: 622541.4966147542
Spatial Reference: 102685  (2248)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 143, 86, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: true
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• TAG ( type: esriFieldTypeString, alias: Tag, length: 15 )
• DATEABANDONED ( type: esriFieldTypeDate, alias: Date Abandoned, length: 8 )
• LAST_ORG ( type: esriFieldTypeString, alias: Last Organization, length: 3 , Coded Values: [100: Buchart Horn, Inc.] , [110: Chesapeake Environmental Management, Inc.] , [120: Enterprise Information Solutions, Inc.] , ...22 more... )
• CAPTURE_METHOD ( type: esriFieldTypeString, alias: Capture Method, length: 4 , Coded Values: [PLAT: Wastewater Plat Map] , [CD: Contract Drawing] , [ORTH: Orthophoto Interpretation] , ...13 more... )
• LAST_USER ( type: esriFieldTypeString, alias: Last Editor, length: 20 )
• EDIT_DATE ( type: esriFieldTypeDate, alias: Edit Date, length: 8 )
• SEWER_ID ( type: esriFieldTypeString, alias: Sewer ID, length: 15 )
• PIP_MATERIAL ( type: esriFieldTypeString, alias: Pipe Material, length: 3 , Coded Values: [BCO: Brick and Concrete] , [BRK: Brick] , [BST: Brick and Stone] , ...21 more... )
• PIP_PRESSURE ( type: esriFieldTypeString, alias: Pipe Pressure, length: 2 , Coded Values: [GR: Gravity] , [FM: Force Main] , [PS: Pressure Sewer] , ...1 more... )
• COATING_TYPE ( type: esriFieldTypeString, alias: Coating Type, length: 3 , Coded Values: [ASP: Asphalt] , [BIT: Bituminous] , [PES: Polyethelene Sleeve] , ...4 more... )
• LINING_TYPE ( type: esriFieldTypeString, alias: Lining Type, length: 4 , Coded Values: [CMR: Cement Mortar] , [UNK: Unknown] , [CTR: CIP Thermo Resin] , ...9 more... )
• PIP_INSTALL_DATE ( type: esriFieldTypeDate, alias: PIP_INSTALL_DATE, length: 8 )
• LIN_INSTALL_DATE ( type: esriFieldTypeDate, alias: LIN_INSTALL_DATE, length: 8 )
• IN_ELEV_SRC ( type: esriFieldTypeString, alias: IN_ELEV_SRC, length: 4 , Coded Values: [PLAT: Wastewater Plat Map] , [CDP: Construction Design Plans] , [CAP: Construction As-Built Plans] , ...3 more... )
• IN_ELEV_DATUM ( type: esriFieldTypeString, alias: IN_ELEV_DATUM, length: 8 , Coded Values: [NAVD88: Maryland State Plane NAVD88 elevation datum] , [CI: Baltimore City elevation datum] )
• IN_ELEV_CITY ( type: esriFieldTypeDouble, alias: Invert Elevation City Grid )
• IN_ELEV_SP ( type: esriFieldTypeDouble, alias: Invert Elevation State Plane )
• OUT_ELEV_SRC ( type: esriFieldTypeString, alias: OUT_ELEV_SRC, length: 4 , Coded Values: [PLAT: Wastewater Plat Map] , [CDP: Construction Design Plans] , [CAP: Construction As-Built Plans] , ...3 more... )
• OUT_ELEV_DATUM ( type: esriFieldTypeString, alias: OUT_ELEV_DATUM, length: 8 , Coded Values: [NAVD88: Maryland State Plane NAVD88 elevation datum] , [CI: Baltimore City elevation datum] )
• OUT_ELEV_CITY ( type: esriFieldTypeDouble, alias: Output Elevation City Grid )
• OUT_ELEV_SP ( type: esriFieldTypeDouble, alias: Output Elevation State Plane )
• SHAPE_CODE ( type: esriFieldTypeString, alias: Shape Code, length: 3 , Coded Values: [A: Arched (with flat bottom)] , [B: Barrel (beer barrel shape)] , [C: Circular] , ...10 more... )
• SLOPE ( type: esriFieldTypeDouble, alias: Slope )
• HEIGHT ( type: esriFieldTypeInteger, alias: Height )
• WIDTH ( type: esriFieldTypeInteger, alias: Width )
• COMBINED ( type: esriFieldTypeString, alias: Combined, length: 1 )
• CLASS_GAUGE ( type: esriFieldTypeString, alias: Class Gauge, length: 4 , Coded Values: [III: III] , [IV: IV] , [V: V] , ...18 more... )
• FROM_MANHOLE_ID ( type: esriFieldTypeString, alias: From Manhole ID, length: 15 )
• TO_MANHOLE_ID ( type: esriFieldTypeString, alias: To Manhole ID, length: 15 )
• MAINT_CODE ( type: esriFieldTypeString, alias: Maintenance Code, length: 6 , Coded Values: [R: Routine] , [A: Assigned] )
• FEAT_STATUS ( type: esriFieldTypeString, alias: Feature Status, length: 3 , Coded Values: [ACT: Active] , [ABD: Abandoned] , [PRO: Proposed] , ...6 more... )
• SYMBOL ( type: esriFieldTypeString, alias: Symbol, length: 3 )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED , Coded Values: [0: False] , [1: True] )
• GLOBALOID ( type: esriFieldTypeString, alias: GLOBALOID, length: 36 )
• CONNECTION_TYPE ( type: esriFieldTypeString, alias: Connection Type, length: 6 , Coded Values: [ADRP: A Drop] , [BDRP: B Drop] , [CDRP: C Drop] , ...6 more... )
• AGENCY_OWNER ( type: esriFieldTypeString, alias: AGENCY_OWNER, length: 5 , Coded Values: [DPW: Department of Public Works] , [HABC: Housing Authority of Baltimore City] , [PRV: Private] , ...4 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SUBTYPE ( type: esriFieldTypeSmallInteger, alias: SUBTYPE )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 20 )
• DOCPOPURL ( type: esriFieldTypeString, alias: DOCPOPURL, length: 255 )
• BuffDist ( type: esriFieldTypeInteger, alias: BuffDist )
• TREATMENT_PLANT ( type: esriFieldTypeString, alias: TREATMENT_PLANT, length: 10 , Coded Values: [BRWWTP: Back River WWTP] , [PAWWTP: Patapsco WWTP] )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH )
• SLRAT_BS ( type: esriFieldTypeSmallInteger, alias: SL-RAT BASELINE SCORE )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• LINE_TYPE ( type: esriFieldTypeInteger, alias: LINE_TYPE , Coded Values: [1: Facilities – Effluent] , [2: Facilities - High Pressure Effluent Water] , [3: Facilities – Influent] , ...16 more... )

Relationships:

• WW_Sewer_Projects (2) -- Related To: Asset_Tracking.DBO.WW_Sewer_Projects (4)
• Mainline_Work_Activity_Report (3) -- Related To: Asset_Tracking.DBO.Mainline_Work_Activity_Report (2)

Tables:

Table: Asset_Tracking.DBO.Mainline_Work_Activity_Report (2)

Name: Asset_Tracking.DBO.Mainline_Work_Activity_Report

Display Field: Project_Number

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: null

Default Visibility: false

MaxRecordCount: 1000000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: true
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Project_Number ( type: esriFieldTypeString, alias: Project Number, length: 50 , Coded Values: [940: SC940] , [941: SC941] , [1021: SC1021] , ...7 more... )
• Inspected_By ( type: esriFieldTypeString, alias: Inspected By, length: 50 , Coded Values: [Chris Peake: Chris Peake] , [Indranil Goswami: Indranil Goswami] , [Mike Griffith: Mike Griffith] , ...22 more... )
• Inspection_Date ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• Orig_Scope_Work_Activity ( type: esriFieldTypeString, alias: Original Scoped Work Activity, length: 35 , Coded Values: [Clean / Inspect: Clean / Inspect] , [Inspect/CCTV Only: Inspect/CCTV Only] , [CIPP Lining: CIPP Lining] , ...9 more... )
• Pipe_Size ( type: esriFieldTypeSmallInteger, alias: Pipe Size )
• Final_Work_Activity_Same ( type: esriFieldTypeString, alias: Final work activity same as design scope?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Pipe_Work_Activity ( type: esriFieldTypeString, alias: Final Work Activity (As Constructed), length: 30 , Coded Values: [Clean / Inspect: Clean / Inspect] , [Inspect/CCTV Only: Inspect/CCTV Only] , [CIPP Lining: CIPP Lining] , ...9 more... )
• Material_Same ( type: esriFieldTypeString, alias: Pipe Material Same?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Pipe_Material ( type: esriFieldTypeString, alias: Final Pipe Material, length: 3 , Coded Values: [BCO: Brick and Concrete] , [BRK: Brick] , [BST: Brick and Stone] , ...21 more... )
• Final_Pipe_Size ( type: esriFieldTypeSmallInteger, alias: Final Pipe Size (in) )
• Pipe_Length_Same ( type: esriFieldTypeString, alias: Pipe Length Same?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Final_Pipe_Length_FT ( type: esriFieldTypeInteger, alias: Final Pipe Length (ft) )
• Discrepancies ( type: esriFieldTypeString, alias: Discrepancy?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Discrepancy_type ( type: esriFieldTypeString, alias: Discrepancy type, length: 20 , Coded Values: [Alignment: Alignment] , [Slope: Slope] , [Invert Elevation: Invert Elevation] , ...2 more... )
• Work_Activity_Status ( type: esriFieldTypeString, alias: Current Work Activity Status, length: 20 , Coded Values: [Not Complete: Not Complete/Removed from Scope] , [In Progress: In Progress] , [Current Complete: Current Work Activity Complete] , ...2 more... )
• Pipe_Size_Same ( type: esriFieldTypeString, alias: Pipe Size Same? , length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• In_Service ( type: esriFieldTypeString, alias: Is Asset in Service?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Full_Scope_Complete ( type: esriFieldTypeString, alias: Is all work activity complete?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• In_Progress_Comment ( type: esriFieldTypeString, alias: Progress Comment, length: 256 )
• Material ( type: esriFieldTypeString, alias: Material, length: 3 , Coded Values: [BCO: Brick and Concrete] , [BRK: Brick] , [BST: Brick and Stone] , ...21 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 256 )
• RelObjectID ( type: esriFieldTypeInteger, alias: RelObjectID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, length: 8 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 128 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 128 )
• Contractor ( type: esriFieldTypeString, alias: Contractor, length: 30 , Coded Values: [Northeast Remsco Const., Inc: Northeast Remsco Const., Inc] , [Anchor Const., Corp.: Anchor Const., Corp.] , [REI: REI] , ...2 more... )
• SEWER_ID ( type: esriFieldTypeString, alias: SEWER_ID, length: 15 )
• Guid_Core ( type: esriFieldTypeGUID, alias: Guid_Core, length: 38 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )

Relationships:

• WW_Sewer (3) -- Related To: WW_Sewer (1)

Table: Asset_Tracking.DBO.MH_Work_Activity_Report (3)

Name: Asset_Tracking.DBO.MH_Work_Activity_Report

Display Field: Project_Number

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: null

Default Visibility: false

MaxRecordCount: 1000000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: true
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Project_Number ( type: esriFieldTypeString, alias: Project Number, length: 50 , Coded Values: [940: SC940] , [941: SC941] , [1021: SC1021] , ...7 more... )
• Inspected_By ( type: esriFieldTypeString, alias: Inspected By, length: 50 , Coded Values: [Chris Peake: Chris Peake] , [Indranil Goswami: Indranil Goswami] , [Mike Griffith: Mike Griffith] , ...22 more... )
• Inspection_Date ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• Final_Work_Activity_Same ( type: esriFieldTypeString, alias: Final work activity same as design scope?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• MH_Work_Activity ( type: esriFieldTypeString, alias: Manhole Work Activity, length: 3 , Coded Values: [A: Replace Existing Manhole] , [B: Install New Manhole] , [C: Install Doghouse MH] , ...28 more... )
• New_MH_Depth ( type: esriFieldTypeDouble, alias: New Manhole Depth )
• New_MH_Dia ( type: esriFieldTypeDouble, alias: New Manhole Diameter )
• MH_Install_Date ( type: esriFieldTypeDate, alias: Manhole Installation Date, length: 8 )
• MH_Work_Activity_Date ( type: esriFieldTypeDate, alias: Manhole Work Activity Date, length: 8 )
• Discrepancies ( type: esriFieldTypeString, alias: Discrepancy?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Discrepancy_type ( type: esriFieldTypeString, alias: Discrepancy type, length: 20 , Coded Values: [Alignment: Alignment] , [Slope: Slope] , [Invert Elevation: Invert Elevation] , ...2 more... )
• Orig_Scope_Work_Activity ( type: esriFieldTypeString, alias: Original Scopeed Work Activity, length: 3 , Coded Values: [A: Replace Existing Manhole] , [B: Install New Manhole] , [C: Install Doghouse MH] , ...28 more... )
• Work_Activity_Status ( type: esriFieldTypeString, alias: Current Work Activity Status, length: 20 , Coded Values: [Not Complete: Not Complete/Removed from Scope] , [In Progress: In Progress] , [Current Complete: Current Work Activity Complete] , ...2 more... )
• In_Service ( type: esriFieldTypeString, alias: Is Asset in Service?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Full_Scope_Complete ( type: esriFieldTypeString, alias: Is all Work Activity Complete?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• In_Prog_Comment ( type: esriFieldTypeString, alias: Progress Comment, length: 150 )
• Comment ( type: esriFieldTypeString, alias: Comment, length: 256 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 256 )
• RelObjectID ( type: esriFieldTypeInteger, alias: RelObjectID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, length: 8 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 128 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 128 )
• Contractor ( type: esriFieldTypeString, alias: Contractor, length: 30 , Coded Values: [Northeast Remsco Const., Inc: Northeast Remsco Const., Inc] , [Anchor Const., Corp.: Anchor Const., Corp.] , [REI: REI] , ...2 more... )
• MANHOLE_ID ( type: esriFieldTypeString, alias: MANHOLE_ID, length: 15 )
• Guid_Core ( type: esriFieldTypeGUID, alias: Guid_Core, length: 38 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )

Relationships:

• WW_ManholeJunction (1) -- Related To: WW_ManholeJunction (0)

Table: Asset_Tracking.DBO.WW_Sewer_Projects (4)

Name: Asset_Tracking.DBO.WW_Sewer_Projects

Display Field: TAG

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: null

Default Visibility: false

MaxRecordCount: 1000000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: true
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• TAG ( type: esriFieldTypeString, alias: Tag, length: 15 )
• SEWER_ID ( type: esriFieldTypeString, alias: Sewer ID, length: 15 )
• FEAT_STAT ( type: esriFieldTypeString, alias: Feature Status, length: 50 )
• CONTR_NUM ( type: esriFieldTypeString, alias: Contract Number, length: 15 )
• REPAIR_ACT ( type: esriFieldTypeString, alias: Repair Action, length: 50 )
• REPAIR_DET ( type: esriFieldTypeString, alias: Repair Detail, length: 100 )
• ASSET_COMP ( type: esriFieldTypeDate, alias: Asset Completion Date, length: 8 )
• CCTV_REC ( type: esriFieldTypeDate, alias: CCTV Received, length: 8 )
• CCTV_LINK ( type: esriFieldTypeDate, alias: CCTV Linked, length: 8 )
• FLAG_2WKS ( type: esriFieldTypeDate, alias: Two Weeks Notice, length: 8 )
• LAST_USER ( type: esriFieldTypeString, alias: Last User, length: 50 )
• EDIT_DATE ( type: esriFieldTypeDate, alias: Edit Date, length: 8 )
• FROM_MH_ID ( type: esriFieldTypeString, alias: From Manhole ID, length: 15 )
• TO_MH_ID ( type: esriFieldTypeString, alias: To Manhole ID, length: 15 )
• SHAPE_STLength__ ( type: esriFieldTypeDouble, alias: SHAPE_STLength__ )
• DOCPOPURL ( type: esriFieldTypeString, alias: DOCPOPURL, length: 255 )
• SHC_REPAIR ( type: esriFieldTypeSmallInteger, alias: SHC_REPAIR )
• ASSET_COMM ( type: esriFieldTypeString, alias: ASSET_COMM, length: 200 )
• PHASE ( type: esriFieldTypeString, alias: PHASE, length: 50 )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• WW_Sewer (2) -- Related To: WW_Sewer (1)

Table: Asset_Tracking.DBO.WW_MH_Projects (5)

Name: Asset_Tracking.DBO.WW_MH_Projects

Display Field: CONTR_NUM

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: null

Default Visibility: false

MaxRecordCount: 1000000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: true
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID_1 ( type: esriFieldTypeOID, alias: OBJECTID_1 )
• CONTR_NUM ( type: esriFieldTypeString, alias: CONTR_NUM, length: 20 )
• CONTR_STAT ( type: esriFieldTypeString, alias: CONTR_STAT, length: 50 )
• AD_DATE ( type: esriFieldTypeDate, alias: AD_DATE, length: 8 )
• START_DATE ( type: esriFieldTypeDate, alias: START_DATE, length: 8 )
• END_DATE ( type: esriFieldTypeDate, alias: END_DATE, length: 8 )
• START_FY ( type: esriFieldTypeString, alias: START_FY, length: 10 )
• END_FY ( type: esriFieldTypeString, alias: END_FY, length: 10 )
• DESIGN_CONS ( type: esriFieldTypeString, alias: DESIGN_CONS, length: 100 )
• D_PM_CONTACT ( type: esriFieldTypeString, alias: D_PM_CONTACT, length: 50 )
• C_PM_CONTACT ( type: esriFieldTypeString, alias: C_PM_CONTACT, length: 50 )
• CONTRACTOR ( type: esriFieldTypeString, alias: CONTRACTOR, length: 100 )
• REHABGDB_REC ( type: esriFieldTypeDate, alias: REHABGDB_REC, length: 8 )
• REHABGDB_PROC ( type: esriFieldTypeDate, alias: REHABGDB_PROC, length: 8 )
• ASBUILTS_REC ( type: esriFieldTypeDate, alias: ASBUILTS_REC, length: 8 )
• ASBUILTS_LINK ( type: esriFieldTypeDate, alias: ASBUILTS_LINK, length: 8 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 200 )
• INFO_UPDATE ( type: esriFieldTypeDate, alias: INFO_UPDATE, length: 8 )
• CONTR_DESCOP ( type: esriFieldTypeSmallInteger, alias: CONTR_DESCOP )
• OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• TAG ( type: esriFieldTypeString, alias: TAG, length: 15 )
• MANHOLE_ID ( type: esriFieldTypeString, alias: MANHOLE_ID, length: 15 )
• FEAT_STAT ( type: esriFieldTypeString, alias: FEAT_STAT, length: 50 )
• REPAIR_ACT ( type: esriFieldTypeString, alias: REPAIR_ACT, length: 50 )
• REPAIR_DET ( type: esriFieldTypeString, alias: REPAIR_DET, length: 100 )
• ASSET_COMP ( type: esriFieldTypeDate, alias: ASSET_COMP, length: 8 )
• FLAG_2WKS ( type: esriFieldTypeDate, alias: FLAG_2WKS, length: 8 )
• LAST_USER ( type: esriFieldTypeString, alias: LAST_USER, length: 50 )
• EDIT_DATE ( type: esriFieldTypeDate, alias: EDIT_DATE, length: 8 )
• DOCPOPURL ( type: esriFieldTypeString, alias: DOCPOPURL, length: 255 )
• ASSET_COMM ( type: esriFieldTypeString, alias: ASSET_COMM, length: 200 )
• PHASE ( type: esriFieldTypeString, alias: PHASE, length: 50 )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• WW_ManholeJunction (0) -- Related To: WW_ManholeJunction (0)