Layers:

Layer: Lateral CCTV (0)

Name: Lateral CCTV

Display Field: Operations.GIS_ADMIN.Lateral_Address_Points.LAST_USER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 10000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1113893.3677024394
YMin: 473845.7884528488
XMax: 1485096.5846121013
YMax: 780331.3595356047
Spatial Reference: 102685  (2248)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• Operations.GIS_ADMIN.Lateral_Address_Points.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Operations.GIS_ADMIN.Lateral_Address_Points.LAST_USER ( type: esriFieldTypeString, alias: LAST_USER, length: 20 )
• Operations.GIS_ADMIN.Lateral_Address_Points.EDIT_DATE ( type: esriFieldTypeDate, alias: EDIT_DATE, length: 8 )
• Operations.GIS_ADMIN.Lateral_Address_Points.POINT_ID ( type: esriFieldTypeInteger, alias: POINT_ID )
• Operations.GIS_ADMIN.Lateral_Address_Points.PARCEL_PIN ( type: esriFieldTypeString, alias: PARCEL_PIN, length: 15 )
• Operations.GIS_ADMIN.Lateral_Address_Points.ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 100 )
• Operations.GIS_ADMIN.Lateral_Address_Points.ZIP ( type: esriFieldTypeInteger, alias: ZIP )
• Operations.GIS_ADMIN.Lateral_Address_Points.LATERAL_TAG ( type: esriFieldTypeString, alias: LATERAL_TAG, length: 15 )
• Operations.GIS_ADMIN.Lateral_Address_Points.MATCH_CONFIDENCE ( type: esriFieldTypeSmallInteger, alias: MATCH_CONFIDENCE , Coded Values: [0: No Match] , [1: Highest] , [2: High] , ...3 more... )
• Operations.GIS_ADMIN.Lateral_Address_Points.LATERAL_MATERIAL ( type: esriFieldTypeString, alias: LATERAL_MATERIAL, length: 50 , Coded Values: [CL: Clay] , [CI: Cast Iron] , [DI: Ductile Iron] , ...2 more... )
• Operations.GIS_ADMIN.Lateral_Address_Points.LATERAL_LENGTH ( type: esriFieldTypeDouble, alias: LATERAL_LENGTH )
• Operations.GIS_ADMIN.Lateral_Address_Points.SEWER_ID ( type: esriFieldTypeString, alias: SEWER_ID, length: 15 )
• Operations.GIS_ADMIN.Lateral_Address_Points.CO_EXIST ( type: esriFieldTypeString, alias: CO_EXIST, length: 1 , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• Operations.GIS_ADMIN.Lateral_Address_Points.CO_LOCATION ( type: esriFieldTypeString, alias: CO_LOCATION, length: 1 , Coded Values: [F: Front] , [S: Side] , [R: Rear] , ...2 more... )
• Operations.GIS_ADMIN.Lateral_Address_Points.CO_MATERIAL ( type: esriFieldTypeString, alias: CO_MATERIAL, length: 5 , Coded Values: [CI: Cast Iron] , [M: Metal] , [P: Plastic] , ...4 more... )
• Operations.GIS_ADMIN.Lateral_Address_Points.CO_EST_DEPTH ( type: esriFieldTypeDouble, alias: CO_EST_DEPTH )
• Operations.GIS_ADMIN.Lateral_Address_Points.M2P_LENGTH ( type: esriFieldTypeDouble, alias: M2P_LENGTH )
• Operations.GIS_ADMIN.Lateral_Address_Points.MANHOLE_DEPTH ( type: esriFieldTypeDouble, alias: MANHOLE_DEPTH )
• Operations.GIS_ADMIN.Lateral_Address_Points.VIDEO_COUNT ( type: esriFieldTypeSmallInteger, alias: VIDEO_COUNT )
• Operations.GIS_ADMIN.Lateral_Address_Points.COMMENT ( type: esriFieldTypeString, alias: COMMENT, length: 255 )
• Operations.GIS_ADMIN.Lateral_Address_Points.SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• Operations.GIS_ADMIN.Lateral_Address_Points.NEIGHBORHOOD ( type: esriFieldTypeString, alias: NEIGHBORHOOD, length: 50 , Coded Values: [ABELL: ABELL] , [ALLENDALE: ALLENDALE] , [ARCADIA: ARCADIA] , ...268 more... )
• Operations.GIS_ADMIN.Lateral_Address_Points.COUNCIL_DISTRICT ( type: esriFieldTypeSmallInteger, alias: CONUNCIL_DISTRICT , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...11 more... )
• Operations.GIS_ADMIN.Lateral_Address_Points.CO_DIAMETER ( type: esriFieldTypeDouble, alias: CO_DIAMETER )
• Operations.GIS_ADMIN.Lateral_Address_Points.GlobalID ( type: esriFieldTypeGlobalID, alias: Operations.GIS_ADMIN.Lateral_Address_Points.GlobalID, length: 38 )
• Operations.GIS_ADMIN.Lateral_Address_Points.created_user ( type: esriFieldTypeString, alias: Operations.GIS_ADMIN.Lateral_Address_Points.created_user, length: 255 )
• Operations.GIS_ADMIN.Lateral_Address_Points.created_date ( type: esriFieldTypeDate, alias: Operations.GIS_ADMIN.Lateral_Address_Points.created_date, length: 8 )
• Operations.GIS_ADMIN.Lateral_Address_Points.last_edited_user ( type: esriFieldTypeString, alias: Operations.GIS_ADMIN.Lateral_Address_Points.last_edited_user, length: 255 )
• Operations.GIS_ADMIN.Lateral_Address_Points.last_edited_date ( type: esriFieldTypeDate, alias: Operations.GIS_ADMIN.Lateral_Address_Points.last_edited_date, length: 8 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.LAST_USER ( type: esriFieldTypeString, alias: LAST_USER, length: 20 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.EDIT_DATE ( type: esriFieldTypeDate, alias: EDIT_DATE, length: 8 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.VIDEO_ID ( type: esriFieldTypeInteger, alias: VIDEO_ID )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.VIDEO_FILE ( type: esriFieldTypeString, alias: VIDEO_FILE, length: 100 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.VIDEO_FILE_PATH ( type: esriFieldTypeString, alias: VIDEO_FILE_PATH, length: 255 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.CCTV_DATE ( type: esriFieldTypeDate, alias: CCTV_DATE, length: 8 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.CCTV_TIME ( type: esriFieldTypeDate, alias: CCTV_TIME, length: 8 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.POINT_ID ( type: esriFieldTypeInteger, alias: POINT_ID )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 100 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.HSE_NUMBER ( type: esriFieldTypeInteger, alias: HSE_NUMBER )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, length: 50 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.WO_ID ( type: esriFieldTypeInteger, alias: WO_ID )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.SOURCE ( type: esriFieldTypeString, alias: SOURCE, length: 30 , Coded Values: [MNT: DPW Maintenance Division] , [LIRP: Lateral Inspection and Renewal Program] , [SSO/WIC: Contractor CCTV for SSO/WIC Investigation] )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.SURVEY_LENGTH ( type: esriFieldTypeDouble, alias: SURVEY_LENGTH )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.TOTAL_LENGTH ( type: esriFieldTypeDouble, alias: TOTAL_LENGTH )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.PURPOSE ( type: esriFieldTypeString, alias: PURPOSE, length: 1 , Coded Values: [B: I/I Investigation] , [C: Post Rehab Survey] , [D: Pre-Rehab Survey] , ...7 more... )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.PRECLEANING ( type: esriFieldTypeString, alias: PRECLEANING, length: 1 , Coded Values: [H: Heavy Clean] , [J: Jetting] , [N: No Pre-Cleaning] , ...1 more... )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.OPERATOR ( type: esriFieldTypeString, alias: OPERATOR, length: 50 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.DIAMETER ( type: esriFieldTypeInteger, alias: DIAMETER )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.MATERIAL_OBSERVED ( type: esriFieldTypeString, alias: MATERIAL_OBSERVED, length: 10 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.LINING_OBSERVED ( type: esriFieldTypeString, alias: LINING_OBSERVED, length: 10 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.LENGTH_PROPERTY_LINE ( type: esriFieldTypeDouble, alias: LENGTH_PROPERTY_LINE )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.TAP_LOCATION ( type: esriFieldTypeString, alias: TAP_LOCATION, length: 38 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.US_MH ( type: esriFieldTypeString, alias: US_MH, length: 20 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.DS_MH ( type: esriFieldTypeString, alias: DS_MH, length: 20 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.SURVEY_DIRECTION ( type: esriFieldTypeString, alias: SURVEY_DIRECTION, length: 10 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.STRUCT_QUICK_RATING ( type: esriFieldTypeString, alias: STRUCT_QUICK_RATING, length: 10 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.OM_QUICK_RATING ( type: esriFieldTypeString, alias: OM_QUICK_RATING, length: 10 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.WORK_PACKAGE_ID ( type: esriFieldTypeInteger, alias: WORK_PACKAGE_ID )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.PRIORITY_STATUS ( type: esriFieldTypeString, alias: PRIORITY_STATUS, length: 3 , Coded Values: [P1: P1] , [P2: P2] , [P3: P3] , ...3 more... )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.NO_REVIEW_NEEDED ( type: esriFieldTypeSmallInteger, alias: NO_REPAIR_NEEDED , Coded Values: [0: False] , [1: True] )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.NO_CCTV_AS_OF ( type: esriFieldTypeDate, alias: NO_CCTV_AS_OF, length: 8 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.CCTV_DATABASE ( type: esriFieldTypeString, alias: CCTV_DATABASE, length: 25 )
• Operations.GIS_ADMIN.Lateral_CCTV_Reference.DATABASE_PROJECT ( type: esriFieldTypeString, alias: DATABASE_PROJECT, length: 25 )

Layer: Lateral Program (1)

Name: Lateral Program

Display Field: Operations.GIS_ADMIN.Lateral_Address_Points.LAST_USER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 10000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1113893.3677024394
YMin: 473845.7884528488
XMax: 1485096.5846121013
YMax: 780331.3595356047
Spatial Reference: 102685  (2248)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• Operations.GIS_ADMIN.Lateral_Address_Points.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Operations.GIS_ADMIN.Lateral_Address_Points.LAST_USER ( type: esriFieldTypeString, alias: LAST_USER, length: 20 )
• Operations.GIS_ADMIN.Lateral_Address_Points.EDIT_DATE ( type: esriFieldTypeDate, alias: EDIT_DATE, length: 8 )
• Operations.GIS_ADMIN.Lateral_Address_Points.POINT_ID ( type: esriFieldTypeInteger, alias: POINT_ID )
• Operations.GIS_ADMIN.Lateral_Address_Points.PARCEL_PIN ( type: esriFieldTypeString, alias: PARCEL_PIN, length: 15 )
• Operations.GIS_ADMIN.Lateral_Address_Points.ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 100 )
• Operations.GIS_ADMIN.Lateral_Address_Points.ZIP ( type: esriFieldTypeInteger, alias: ZIP )
• Operations.GIS_ADMIN.Lateral_Address_Points.LATERAL_TAG ( type: esriFieldTypeString, alias: LATERAL_TAG, length: 15 )
• Operations.GIS_ADMIN.Lateral_Address_Points.MATCH_CONFIDENCE ( type: esriFieldTypeSmallInteger, alias: MATCH_CONFIDENCE , Coded Values: [0: No Match] , [1: Highest] , [2: High] , ...3 more... )
• Operations.GIS_ADMIN.Lateral_Address_Points.LATERAL_MATERIAL ( type: esriFieldTypeString, alias: LATERAL_MATERIAL, length: 50 , Coded Values: [CL: Clay] , [CI: Cast Iron] , [DI: Ductile Iron] , ...2 more... )
• Operations.GIS_ADMIN.Lateral_Address_Points.LATERAL_LENGTH ( type: esriFieldTypeDouble, alias: LATERAL_LENGTH )
• Operations.GIS_ADMIN.Lateral_Address_Points.SEWER_ID ( type: esriFieldTypeString, alias: SEWER_ID, length: 15 )
• Operations.GIS_ADMIN.Lateral_Address_Points.CO_EXIST ( type: esriFieldTypeString, alias: CO_EXIST, length: 1 , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• Operations.GIS_ADMIN.Lateral_Address_Points.CO_LOCATION ( type: esriFieldTypeString, alias: CO_LOCATION, length: 1 , Coded Values: [F: Front] , [S: Side] , [R: Rear] , ...2 more... )
• Operations.GIS_ADMIN.Lateral_Address_Points.CO_MATERIAL ( type: esriFieldTypeString, alias: CO_MATERIAL, length: 5 , Coded Values: [CI: Cast Iron] , [M: Metal] , [P: Plastic] , ...4 more... )
• Operations.GIS_ADMIN.Lateral_Address_Points.CO_EST_DEPTH ( type: esriFieldTypeDouble, alias: CO_EST_DEPTH )
• Operations.GIS_ADMIN.Lateral_Address_Points.M2P_LENGTH ( type: esriFieldTypeDouble, alias: M2P_LENGTH )
• Operations.GIS_ADMIN.Lateral_Address_Points.MANHOLE_DEPTH ( type: esriFieldTypeDouble, alias: MANHOLE_DEPTH )
• Operations.GIS_ADMIN.Lateral_Address_Points.VIDEO_COUNT ( type: esriFieldTypeSmallInteger, alias: VIDEO_COUNT )
• Operations.GIS_ADMIN.Lateral_Address_Points.COMMENT ( type: esriFieldTypeString, alias: COMMENT, length: 255 )
• Operations.GIS_ADMIN.Lateral_Address_Points.SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• Operations.GIS_ADMIN.Lateral_Address_Points.NEIGHBORHOOD ( type: esriFieldTypeString, alias: NEIGHBORHOOD, length: 50 , Coded Values: [ABELL: ABELL] , [ALLENDALE: ALLENDALE] , [ARCADIA: ARCADIA] , ...268 more... )
• Operations.GIS_ADMIN.Lateral_Address_Points.COUNCIL_DISTRICT ( type: esriFieldTypeSmallInteger, alias: CONUNCIL_DISTRICT , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...11 more... )
• Operations.GIS_ADMIN.Lateral_Address_Points.CO_DIAMETER ( type: esriFieldTypeDouble, alias: CO_DIAMETER )
• Operations.GIS_ADMIN.Lateral_Address_Points.GlobalID ( type: esriFieldTypeGlobalID, alias: Operations.GIS_ADMIN.Lateral_Address_Points.GlobalID, length: 38 )
• Operations.GIS_ADMIN.Lateral_Address_Points.created_user ( type: esriFieldTypeString, alias: Operations.GIS_ADMIN.Lateral_Address_Points.created_user, length: 255 )
• Operations.GIS_ADMIN.Lateral_Address_Points.created_date ( type: esriFieldTypeDate, alias: Operations.GIS_ADMIN.Lateral_Address_Points.created_date, length: 8 )
• Operations.GIS_ADMIN.Lateral_Address_Points.last_edited_user ( type: esriFieldTypeString, alias: Operations.GIS_ADMIN.Lateral_Address_Points.last_edited_user, length: 255 )
• Operations.GIS_ADMIN.Lateral_Address_Points.last_edited_date ( type: esriFieldTypeDate, alias: Operations.GIS_ADMIN.Lateral_Address_Points.last_edited_date, length: 8 )
• Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog.OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog.POINT_ID ( type: esriFieldTypeInteger, alias: POINT_ID )
• Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog.ADDRESS ( type: esriFieldTypeString, alias: Address, length: 255 )
• Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog.CHOKES ( type: esriFieldTypeInteger, alias: CHOKES )
• Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog.MOST_RECENT_CHOKE ( type: esriFieldTypeDate, alias: Most_Recent_Choke, length: 8 )
• Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog.REPAIRS ( type: esriFieldTypeInteger, alias: REPAIRS )
• Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog.MOST_RECENT_REPAIR ( type: esriFieldTypeDate, alias: Most_Recent_Repair, length: 8 )
• Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog.ASSESSMENT_YEAR ( type: esriFieldTypeSmallInteger, alias: ASSESSMENT_YEAR )
• Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog.ASSESSMENT_PRIORITY ( type: esriFieldTypeSmallInteger, alias: ASSESSMENT_PRIORITY )
• Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog.NEIGHBORHOOD ( type: esriFieldTypeString, alias: Neighborhood, length: 50 , Coded Values: [ABELL: ABELL] , [ALLENDALE: ALLENDALE] , [ARCADIA: ARCADIA] , ...268 more... )
• Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog.COUNCIL_DISTRICT ( type: esriFieldTypeSmallInteger, alias: Council_District , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...11 more... )
• Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog.COUNCIL_DISTRICT_CONTACT ( type: esriFieldTypeString, alias: Council_District_Contact, length: 50 )
• Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog.IN_ORIG_BACKLOG ( type: esriFieldTypeString, alias: IN_ORIG_BACKLOG, length: 255 )
• Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog.DATE_MAPPED ( type: esriFieldTypeDate, alias: Date_Mapped, length: 8 )
• Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog.MOST_RECENT_SURVEY ( type: esriFieldTypeDate, alias: MOST RECENT_SURVEY, length: 8 )

Tables:

Table: Operations.GIS_ADMIN.Lateral_CCTV_Reference (2)

Name: Operations.GIS_ADMIN.Lateral_CCTV_Reference

Display Field: STREET_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• LAST_USER ( type: esriFieldTypeString, alias: LAST_USER, length: 20 )
• EDIT_DATE ( type: esriFieldTypeDate, alias: EDIT_DATE, length: 8 )
• VIDEO_ID ( type: esriFieldTypeInteger, alias: VIDEO_ID )
• VIDEO_FILE ( type: esriFieldTypeString, alias: VIDEO_FILE, length: 100 )
• VIDEO_FILE_PATH ( type: esriFieldTypeString, alias: VIDEO_FILE_PATH, length: 255 )
• CCTV_DATE ( type: esriFieldTypeDate, alias: CCTV_DATE, length: 8 )
• CCTV_TIME ( type: esriFieldTypeDate, alias: CCTV_TIME, length: 8 )
• POINT_ID ( type: esriFieldTypeInteger, alias: POINT_ID )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 100 )
• HSE_NUMBER ( type: esriFieldTypeInteger, alias: HSE_NUMBER )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, length: 50 )
• WO_ID ( type: esriFieldTypeInteger, alias: WO_ID )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, length: 30 , Coded Values: [MNT: DPW Maintenance Division] , [LIRP: Lateral Inspection and Renewal Program] , [SSO/WIC: Contractor CCTV for SSO/WIC Investigation] )
• SURVEY_LENGTH ( type: esriFieldTypeDouble, alias: SURVEY_LENGTH )
• TOTAL_LENGTH ( type: esriFieldTypeDouble, alias: TOTAL_LENGTH )
• PURPOSE ( type: esriFieldTypeString, alias: PURPOSE, length: 1 , Coded Values: [B: I/I Investigation] , [C: Post Rehab Survey] , [D: Pre-Rehab Survey] , ...7 more... )
• PRECLEANING ( type: esriFieldTypeString, alias: PRECLEANING, length: 1 , Coded Values: [H: Heavy Clean] , [J: Jetting] , [N: No Pre-Cleaning] , ...1 more... )
• OPERATOR ( type: esriFieldTypeString, alias: OPERATOR, length: 50 )
• DIAMETER ( type: esriFieldTypeInteger, alias: DIAMETER )
• MATERIAL_OBSERVED ( type: esriFieldTypeString, alias: MATERIAL_OBSERVED, length: 10 )
• LINING_OBSERVED ( type: esriFieldTypeString, alias: LINING_OBSERVED, length: 10 )
• LENGTH_PROPERTY_LINE ( type: esriFieldTypeDouble, alias: LENGTH_PROPERTY_LINE )
• TAP_LOCATION ( type: esriFieldTypeString, alias: TAP_LOCATION, length: 38 )
• US_MH ( type: esriFieldTypeString, alias: US_MH, length: 20 )
• DS_MH ( type: esriFieldTypeString, alias: DS_MH, length: 20 )
• SURVEY_DIRECTION ( type: esriFieldTypeString, alias: SURVEY_DIRECTION, length: 10 )
• STRUCT_QUICK_RATING ( type: esriFieldTypeString, alias: STRUCT_QUICK_RATING, length: 10 )
• OM_QUICK_RATING ( type: esriFieldTypeString, alias: OM_QUICK_RATING, length: 10 )
• WORK_PACKAGE_ID ( type: esriFieldTypeInteger, alias: WORK_PACKAGE_ID )
• PRIORITY_STATUS ( type: esriFieldTypeString, alias: PRIORITY_STATUS, length: 3 , Coded Values: [P1: P1] , [P2: P2] , [P3: P3] , ...3 more... )
• NO_REVIEW_NEEDED ( type: esriFieldTypeSmallInteger, alias: NO_REPAIR_NEEDED , Coded Values: [0: False] , [1: True] )
• NO_CCTV_AS_OF ( type: esriFieldTypeDate, alias: NO_CCTV_AS_OF, length: 8 )
• CCTV_DATABASE ( type: esriFieldTypeString, alias: CCTV_DATABASE, length: 25 )
• DATABASE_PROJECT ( type: esriFieldTypeString, alias: DATABASE_PROJECT, length: 25 )

Table: Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog (3)

Name: Operations.GIS_ADMIN.Lateral_Renewal_Program_Backlog

Display Field: ADDRESS

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• POINT_ID ( type: esriFieldTypeInteger, alias: POINT_ID )
• ADDRESS ( type: esriFieldTypeString, alias: Address, length: 255 )
• CHOKES ( type: esriFieldTypeInteger, alias: CHOKES )
• MOST_RECENT_CHOKE ( type: esriFieldTypeDate, alias: Most_Recent_Choke, length: 8 )
• REPAIRS ( type: esriFieldTypeInteger, alias: REPAIRS )
• MOST_RECENT_REPAIR ( type: esriFieldTypeDate, alias: Most_Recent_Repair, length: 8 )
• ASSESSMENT_YEAR ( type: esriFieldTypeSmallInteger, alias: ASSESSMENT_YEAR )
• ASSESSMENT_PRIORITY ( type: esriFieldTypeSmallInteger, alias: ASSESSMENT_PRIORITY )
• NEIGHBORHOOD ( type: esriFieldTypeString, alias: Neighborhood, length: 50 , Coded Values: [ABELL: ABELL] , [ALLENDALE: ALLENDALE] , [ARCADIA: ARCADIA] , ...268 more... )
• COUNCIL_DISTRICT ( type: esriFieldTypeSmallInteger, alias: Council_District , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...11 more... )
• COUNCIL_DISTRICT_CONTACT ( type: esriFieldTypeString, alias: Council_District_Contact, length: 50 )
• IN_ORIG_BACKLOG ( type: esriFieldTypeString, alias: IN_ORIG_BACKLOG, length: 255 )
• DATE_MAPPED ( type: esriFieldTypeDate, alias: Date_Mapped, length: 8 )
• MOST_RECENT_SURVEY ( type: esriFieldTypeDate, alias: MOST RECENT_SURVEY, length: 8 )