ArcGIS REST Services Directory
Login
Home
>
services
>
ssTelevisingHistoryFeatureLayer (FeatureServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (ssTelevisingHistoryFeatureLayer)
Layers:
Layer:
Sanitary Sewer Mains
(6)
Name:
Sanitary Sewer Mains
Display Field:
MainID
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
Service Item Id:
3296ff1e7c2c4c318ddf47dfab0470a7
Copyright Text:
Default Visibility: true
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0.0
Max Scale:
0.0
Supports Advanced Queries:
true
Supports Statistics:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Supports Datum Transformation:
true
Extent:
XMin: 846908.8628408909
YMin: 511103.01077747345
XMax: 875219.3619940579
YMax: 532441.1268938035
Spatial Reference: 103412 (8193) LatestVCSWkid(0)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1:
TelevisedMainStatus
Field 2:
N/A
Field 3:
N/A
Field Delimiter:
,
Default Symbol:
Style:
esriSLSSolid
Color:
[130, 130, 130, 255]
Width:
1
Default Label:
<all other values>
UniqueValueInfos:
Value:
Yes
Label:
Yes
Description:
N/A
Symbol:
Style:
esriSLSSolid
Color:
[55, 166, 0, 255]
Width:
2
Value:
No
Label:
No
Description:
N/A
Symbol:
Style:
esriSLSSolid
Color:
[255, 117, 225, 255]
Width:
2
Value:
NA
Label:
Not Accessible
Description:
N/A
Symbol:
Style:
esriSLSSolid
Color:
[0, 0, 0, 255]
Width:
2
Value:
A
Label:
Assigned
Description:
N/A
Symbol:
Style:
esriSLSSolid
Color:
[0, 112, 255, 255]
Width:
2
Value:
P
Label:
Partial
Description:
N/A
Symbol:
Style:
esriSLSSolid
Color:
[255, 170, 0, 255]
Width:
2
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: true
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
true
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
TelevisedMainStatus
Fields:
AccessIssue
( type: esriFieldTypeString, alias: Access Issue, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AccessIssue ,
Coded Values:
[1: Not Applicable] , [2: Cannot Access] , [3: Obstruction Needs Evaluation]
, ...1 more...
)
Notes
( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Notes )
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
FacilityID
( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
ActiveFlag
( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ActiveFlag ,
Coded Values:
[0: False] , [1: True] )
InstallDate
( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
RetireDate
( type: esriFieldTypeDate, alias: Retire Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RetireDate )
LastEditor
( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LastEditor )
LastUpdate
( type: esriFieldTypeDate, alias: Last Update, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LastUpdate )
OwnedBy
( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OwnedBy ,
Coded Values:
[1: Our Agency] , [-1: Private] , [-2: Other]
, ...1 more...
)
MaintBy
( type: esriFieldTypeSmallInteger, alias: Maint By, editable: true, nullable: true, defaultValue: 1, modelName: MaintBy ,
Coded Values:
[1: Our Agency] , [-1: Private] , [-2: Other]
, ...1 more...
)
LocDesc
( type: esriFieldTypeString, alias: Location Desc, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocDesc )
Material
( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Material ,
Coded Values:
[C-900: C-900] , [Cast Iron: Cast Iron] , [OTHER: OTHER]
, ...10 more...
)
Diameter
( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: Diameter ,
Coded Values:
[42: 42"] , [36: 36"] , [30: 30"]
, ...9 more...
)
LinedDate
( type: esriFieldTypeDate, alias: Lined Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LinedDate )
FromMH
( type: esriFieldTypeString, alias: From MH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FromMH )
ToMH
( type: esriFieldTypeString, alias: To MH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ToMH )
UpElev
( type: esriFieldTypeDouble, alias: Up Elev, editable: true, nullable: true, defaultValue: null, modelName: UpElev )
DwnElev
( type: esriFieldTypeDouble, alias: Dwn Elev, editable: true, nullable: true, defaultValue: null, modelName: DwnElev )
StreetName
( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StreetName ,
Coded Values:
[A ST: A ST] , [ABBINGTON CT: ABBINGTON CT] , [ABBOTT LN: ABBOTT LN]
, ...623 more...
)
Slope
( type: esriFieldTypeDouble, alias: Slope, editable: true, nullable: true, defaultValue: null, modelName: Slope )
Length
( type: esriFieldTypeDouble, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: Length )
PipeDrop
( type: esriFieldTypeString, alias: Pipe Drop, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PipeDrop ,
Coded Values:
[Inside Drop: Inside Drop] , [Outside Drop: Outside Drop] , [Not Applicable: Not Applicable]
, ...1 more...
)
DropMH
( type: esriFieldTypeString, alias: Drop MH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DropMH )
MainType
( type: esriFieldTypeString, alias: Main Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MainType ,
Coded Values:
[FMAIN: FORCE MAIN] , [INTCPTR: INTERCEPTOR] , [MAIN: MAIN]
, ...3 more...
)
Label
( type: esriFieldTypeString, alias: Label, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Label )
UpDepth
( type: esriFieldTypeDouble, alias: Up Depth, editable: true, nullable: true, defaultValue: null, modelName: UpDepth )
DownDepth
( type: esriFieldTypeDouble, alias: Down Depth, editable: true, nullable: true, defaultValue: null, modelName: DownDepth )
Asbuilt
( type: esriFieldTypeString, alias: Asbuilt, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Asbuilt )
Subdivision
( type: esriFieldTypeString, alias: Subdivision, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Subdivision )
Contractor
( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Contractor )
Source
( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Source ,
Coded Values:
[CAD: CAD] , [DIG: Digitized] , [GPS: GPS]
, ...7 more...
)
Flag_SpatialChange
( type: esriFieldTypeString, alias: Flag_SpatialChange, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Flag_SpatialChange )
Flag_GeneralNotes
( type: esriFieldTypeString, alias: Flag_GeneralNotes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Flag_GeneralNotes )
Flag_UpStreamIE_Source
( type: esriFieldTypeString, alias: Flag_UpStreamIE_Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Flag_UpStreamIE_Source )
Flag_DownStreamIE_Source
( type: esriFieldTypeString, alias: Flag_DownStreamIE_Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Flag_DownStreamIE_Source )
Added_UpDepth_LastFieldWork
( type: esriFieldTypeString, alias: Added_UpDepth_LastFieldWork, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Added_UpDepth_LastFieldWork )
Added_DownDepth_LastFieldWork
( type: esriFieldTypeString, alias: Added_DownDepth_LastFieldWork, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Added_DownDepth_LastFieldWork )
LineContractor
( type: esriFieldTypeString, alias: Line Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LineContractor )
Vacuumed
( type: esriFieldTypeString, alias: Vacuumed, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Vacuumed ,
Coded Values:
[Yes: Yes] , [No: No] )
CleaningStatus
( type: esriFieldTypeString, alias: Cleaning Status, editable: true, nullable: true, length: 10, defaultValue: No, modelName: MainJetStatus ,
Coded Values:
[Yes: Yes] , [No: No] , [Assigned: Assigned]
, ...1 more...
)
YearCleaned
( type: esriFieldTypeString, alias: Year Cleaned, editable: true, nullable: true, length: 30, defaultValue: null, modelName: YearCleaned )
EditComplete
( type: esriFieldTypeString, alias: Edit Complete, editable: true, nullable: true, length: 4, defaultValue: null, modelName: EditComplete ,
Coded Values:
[Yes: Yes] , [No: No] )
WOrder
( type: esriFieldTypeString, alias: Work Order, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WOrder )
WinCan_Join
( type: esriFieldTypeString, alias: WinCan_Join, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WinCan_Join )
TelevisedMainStatus
( type: esriFieldTypeString, alias: Televising Status , editable: true, nullable: true, length: 4, defaultValue: null, modelName: TelevisedMainStatus ,
Coded Values:
[A: Assigned] , [Yes: Yes] , [No: No]
, ...2 more...
)
LiningMainStatus
( type: esriFieldTypeString, alias: Lining Status, editable: true, nullable: true, length: 4, defaultValue: No, modelName: LiningMainStatus ,
Coded Values:
[Yes: Yes] , [No: No] )
CleaningType
( type: esriFieldTypeString, alias: Cleaning Type, editable: true, nullable: true, length: 50, defaultValue: Jet, modelName: CleaningType )
YearCleaned2
( type: esriFieldTypeString, alias: Year Cleaned 2, editable: true, nullable: true, length: 4, defaultValue: null, modelName: YearCleaned2 )
YearCleaned3
( type: esriFieldTypeString, alias: Year Cleaned 3, editable: true, nullable: true, length: 4, defaultValue: null, modelName: YearCleaned3 )
YearCleaned4
( type: esriFieldTypeString, alias: Year Cleaned 4, editable: true, nullable: true, length: 4, defaultValue: null, modelName: YearCleaned4 )
created_user
( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
created_date
( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
MainID
( type: esriFieldTypeString, alias: Main ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MainID )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
ReviewComplete
( type: esriFieldTypeString, alias: Review Complete, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ReviewComplete ,
Coded Values:
[Yes: Yes] , [No: No] )
Video
( type: esriFieldTypeString, alias: Video, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Video )
LastYearCleaned
( type: esriFieldTypeString, alias: LastYearCleaned, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LastYearCleaned )
StrQuickRating
( type: esriFieldTypeString, alias: StrQuickRating, editable: true, nullable: true, length: 10, defaultValue: null, modelName: StrQuickRating )
OMQuickRating
( type: esriFieldTypeString, alias: OMQuickRating, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OMQuickRating )
OverallQuickRating
( type: esriFieldTypeString, alias: OverallQuickRating, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OverallQuickRating )
JettingFrequency
( type: esriFieldTypeInteger, alias: JettingFrequency, editable: true, nullable: true, defaultValue: 36, modelName: JettingFrequency ,
Coded Values:
[1: Monthly] , [2: 2 Months] , [6: 6 Months]
, ...5 more...
)
LastJettedDate
( type: esriFieldTypeDate, alias: LastJettedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastJettedDate )
Shape__Length
( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )
Types:
ID: Yes
Name: Yes
Domains:
AccessIssue:
Inherited
ActiveFlag:
Inherited
OwnedBy:
Inherited
MaintBy:
Inherited
Material:
Inherited
Diameter:
Inherited
StreetName:
Inherited
PipeDrop:
Inherited
MainType:
Inherited
Source:
Inherited
Vacuumed:
Inherited
CleaningStatus:
Inherited
EditComplete:
Inherited
TelevisedMainStatus:
Inherited
LiningMainStatus:
Inherited
ReviewComplete:
Inherited
JettingFrequency:
Inherited
Templates:
Name: Yes
Description:
Prototype:
WinCan_Join:
null
LastJettedDate:
null
AccessIssue:
null
Notes:
null
FacilityID:
null
ActiveFlag:
1
InstallDate:
null
RetireDate:
null
OverallQuickRating:
null
OMQuickRating:
null
OwnedBy:
1
MaintBy:
1
LocDesc:
null
Material:
null
Diameter:
null
LinedDate:
null
FromMH:
null
ToMH:
null
UpElev:
null
DwnElev:
null
StreetName:
null
Slope:
null
Length:
null
PipeDrop:
null
DropMH:
null
MainType:
null
Label:
null
UpDepth:
null
DownDepth:
null
Asbuilt:
null
Subdivision:
null
Contractor:
null
Source:
null
Flag_SpatialChange:
null
Flag_GeneralNotes:
null
Flag_UpStreamIE_Source:
null
Flag_DownStreamIE_Source:
null
Added_UpDepth_LastFieldWork:
null
Added_DownDepth_LastFieldWork:
null
LineContractor:
null
Vacuumed:
null
CleaningStatus:
No
YearCleaned:
null
EditComplete:
null
WOrder:
null
TelevisedMainStatus:
Yes
LiningMainStatus:
No
CleaningType:
Jet
YearCleaned2:
null
YearCleaned3:
null
YearCleaned4:
null
StrQuickRating:
null
LastYearCleaned:
null
MainID:
null
JettingFrequency:
36
ReviewComplete:
null
Video:
null
Drawing Tool: esriFeatureEditToolLine
ID: No
Name: No
Domains:
AccessIssue:
Inherited
ActiveFlag:
Inherited
OwnedBy:
Inherited
MaintBy:
Inherited
Material:
Inherited
Diameter:
Inherited
StreetName:
Inherited
PipeDrop:
Inherited
MainType:
Inherited
Source:
Inherited
Vacuumed:
Inherited
CleaningStatus:
Inherited
EditComplete:
Inherited
TelevisedMainStatus:
Inherited
LiningMainStatus:
Inherited
ReviewComplete:
Inherited
JettingFrequency:
Inherited
Templates:
Name: No
Description:
Prototype:
WinCan_Join:
null
LastJettedDate:
null
AccessIssue:
null
Notes:
null
FacilityID:
null
ActiveFlag:
1
InstallDate:
null
RetireDate:
null
OverallQuickRating:
null
OMQuickRating:
null
OwnedBy:
1
MaintBy:
1
LocDesc:
null
Material:
null
Diameter:
null
LinedDate:
null
FromMH:
null
ToMH:
null
UpElev:
null
DwnElev:
null
StreetName:
null
Slope:
null
Length:
null
PipeDrop:
null
DropMH:
null
MainType:
null
Label:
null
UpDepth:
null
DownDepth:
null
Asbuilt:
null
Subdivision:
null
Contractor:
null
Source:
null
Flag_SpatialChange:
null
Flag_GeneralNotes:
null
Flag_UpStreamIE_Source:
null
Flag_DownStreamIE_Source:
null
Added_UpDepth_LastFieldWork:
null
Added_DownDepth_LastFieldWork:
null
LineContractor:
null
Vacuumed:
null
CleaningStatus:
No
YearCleaned:
null
EditComplete:
null
WOrder:
null
TelevisedMainStatus:
No
LiningMainStatus:
No
CleaningType:
Jet
YearCleaned2:
null
YearCleaned3:
null
YearCleaned4:
null
StrQuickRating:
null
LastYearCleaned:
null
MainID:
null
JettingFrequency:
36
ReviewComplete:
null
Video:
null
Drawing Tool: esriFeatureEditToolLine
ID: NA
Name: Not Accessible
Domains:
AccessIssue:
Inherited
ActiveFlag:
Inherited
OwnedBy:
Inherited
MaintBy:
Inherited
Material:
Inherited
Diameter:
Inherited
StreetName:
Inherited
PipeDrop:
Inherited
MainType:
Inherited
Source:
Inherited
Vacuumed:
Inherited
CleaningStatus:
Inherited
EditComplete:
Inherited
TelevisedMainStatus:
Inherited
LiningMainStatus:
Inherited
ReviewComplete:
Inherited
JettingFrequency:
Inherited
Templates:
Name: Not Accessible
Description:
Prototype:
WinCan_Join:
null
LastJettedDate:
null
AccessIssue:
null
Notes:
null
FacilityID:
null
ActiveFlag:
1
InstallDate:
null
RetireDate:
null
OverallQuickRating:
null
OMQuickRating:
null
OwnedBy:
1
MaintBy:
1
LocDesc:
null
Material:
null
Diameter:
null
LinedDate:
null
FromMH:
null
ToMH:
null
UpElev:
null
DwnElev:
null
StreetName:
null
Slope:
null
Length:
null
PipeDrop:
null
DropMH:
null
MainType:
null
Label:
null
UpDepth:
null
DownDepth:
null
Asbuilt:
null
Subdivision:
null
Contractor:
null
Source:
null
Flag_SpatialChange:
null
Flag_GeneralNotes:
null
Flag_UpStreamIE_Source:
null
Flag_DownStreamIE_Source:
null
Added_UpDepth_LastFieldWork:
null
Added_DownDepth_LastFieldWork:
null
LineContractor:
null
Vacuumed:
null
CleaningStatus:
No
YearCleaned:
null
EditComplete:
null
WOrder:
null
TelevisedMainStatus:
NA
LiningMainStatus:
No
CleaningType:
Jet
YearCleaned2:
null
YearCleaned3:
null
YearCleaned4:
null
StrQuickRating:
null
LastYearCleaned:
null
MainID:
null
JettingFrequency:
36
ReviewComplete:
null
Video:
null
Drawing Tool: esriFeatureEditToolLine
ID: A
Name: Assigned
Domains:
AccessIssue:
Inherited
ActiveFlag:
Inherited
OwnedBy:
Inherited
MaintBy:
Inherited
Material:
Inherited
Diameter:
Inherited
StreetName:
Inherited
PipeDrop:
Inherited
MainType:
Inherited
Source:
Inherited
Vacuumed:
Inherited
CleaningStatus:
Inherited
EditComplete:
Inherited
TelevisedMainStatus:
Inherited
LiningMainStatus:
Inherited
ReviewComplete:
Inherited
JettingFrequency:
Inherited
Templates:
Name: Assigned
Description:
Prototype:
WinCan_Join:
null
LastJettedDate:
null
AccessIssue:
null
Notes:
null
FacilityID:
null
ActiveFlag:
1
InstallDate:
null
RetireDate:
null
OverallQuickRating:
null
OMQuickRating:
null
OwnedBy:
1
MaintBy:
1
LocDesc:
null
Material:
null
Diameter:
null
LinedDate:
null
FromMH:
null
ToMH:
null
UpElev:
null
DwnElev:
null
StreetName:
null
Slope:
null
Length:
null
PipeDrop:
null
DropMH:
null
MainType:
null
Label:
null
UpDepth:
null
DownDepth:
null
Asbuilt:
null
Subdivision:
null
Contractor:
null
Source:
null
Flag_SpatialChange:
null
Flag_GeneralNotes:
null
Flag_UpStreamIE_Source:
null
Flag_DownStreamIE_Source:
null
Added_UpDepth_LastFieldWork:
null
Added_DownDepth_LastFieldWork:
null
LineContractor:
null
Vacuumed:
null
CleaningStatus:
No
YearCleaned:
null
EditComplete:
null
WOrder:
null
TelevisedMainStatus:
A
LiningMainStatus:
No
CleaningType:
Jet
YearCleaned2:
null
YearCleaned3:
null
YearCleaned4:
null
StrQuickRating:
null
LastYearCleaned:
null
MainID:
null
JettingFrequency:
36
ReviewComplete:
null
Video:
null
Drawing Tool: esriFeatureEditToolLine
ID: P
Name: Partial
Domains:
AccessIssue:
Inherited
ActiveFlag:
Inherited
OwnedBy:
Inherited
MaintBy:
Inherited
Material:
Inherited
Diameter:
Inherited
StreetName:
Inherited
PipeDrop:
Inherited
MainType:
Inherited
Source:
Inherited
Vacuumed:
Inherited
CleaningStatus:
Inherited
EditComplete:
Inherited
TelevisedMainStatus:
Inherited
LiningMainStatus:
Inherited
ReviewComplete:
Inherited
JettingFrequency:
Inherited
Templates:
Name: Partial
Description:
Prototype:
WinCan_Join:
null
LastJettedDate:
null
AccessIssue:
null
Notes:
null
FacilityID:
null
ActiveFlag:
1
InstallDate:
null
RetireDate:
null
OverallQuickRating:
null
OMQuickRating:
null
OwnedBy:
1
MaintBy:
1
LocDesc:
null
Material:
null
Diameter:
null
LinedDate:
null
FromMH:
null
ToMH:
null
UpElev:
null
DwnElev:
null
StreetName:
null
Slope:
null
Length:
null
PipeDrop:
null
DropMH:
null
MainType:
null
Label:
null
UpDepth:
null
DownDepth:
null
Asbuilt:
null
Subdivision:
null
Contractor:
null
Source:
null
Flag_SpatialChange:
null
Flag_GeneralNotes:
null
Flag_UpStreamIE_Source:
null
Flag_DownStreamIE_Source:
null
Added_UpDepth_LastFieldWork:
null
Added_DownDepth_LastFieldWork:
null
LineContractor:
null
Vacuumed:
null
CleaningStatus:
No
YearCleaned:
null
EditComplete:
null
WOrder:
null
TelevisedMainStatus:
P
LiningMainStatus:
No
CleaningType:
Jet
YearCleaned2:
null
YearCleaned3:
null
YearCleaned4:
null
StrQuickRating:
null
LastYearCleaned:
null
MainID:
null
JettingFrequency:
36
ReviewComplete:
null
Video:
null
Drawing Tool: esriFeatureEditToolLine
Relationships:
DBO.ssTelevising (0) --
Related To
:
ssTelevising
(4)
Layer:
Sanitary Sewer Laterals
(5)
Name:
Sanitary Sewer Laterals
Display Field:
LateralLineID
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
Service Item Id:
3296ff1e7c2c4c318ddf47dfab0470a7
Copyright Text:
Default Visibility: true
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0.0
Max Scale:
0.0
Supports Advanced Queries:
true
Supports Statistics:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Supports Datum Transformation:
true
Extent:
XMin: 846911.9940682203
YMin: 511018.04047498107
XMax: 875233.9361118823
YMax: 532255.9799543917
Spatial Reference: 103412 (8193) LatestVCSWkid(0)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1:
TelevisedLateralStatus
Field 2:
N/A
Field 3:
N/A
Field Delimiter:
,
Default Symbol:
Style:
esriSLSSolid
Color:
[255, 115, 223, 255]
Width:
1
Default Label:
<all other values>
UniqueValueInfos:
Value:
Yes
Label:
Yes
Description:
N/A
Symbol:
Style:
esriSLSSolid
Color:
[55, 166, 0, 255]
Width:
1
Value:
No
Label:
No
Description:
N/A
Symbol:
Style:
esriSLSSolid
Color:
[255, 117, 225, 255]
Width:
1
Value:
NA
Label:
Not Accessible
Description:
N/A
Symbol:
Style:
esriSLSSolid
Color:
[0, 0, 0, 255]
Width:
1
Value:
A
Label:
Assigned
Description:
N/A
Symbol:
Style:
esriSLSSolid
Color:
[0, 112, 255, 255]
Width:
2
Value:
P
Label:
Partial
Description:
N/A
Symbol:
Style:
esriSLSSolid
Color:
[255, 170, 0, 255]
Width:
1
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: true
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
true
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
TelevisedLateralStatus
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
FacilityID
( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
ActiveFlag
( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ActiveFlag ,
Coded Values:
[0: False] , [1: True] )
InstallDate
( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
RetireDate
( type: esriFieldTypeDate, alias: Retire Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RetireDate )
LastEditor
( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LastEditor )
LastUpdate
( type: esriFieldTypeDate, alias: Last Update, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LastUpdate )
OwnedBy
( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: -1, modelName: OwnedBy ,
Coded Values:
[1: Our Agency] , [-1: Private] , [-2: Other]
, ...1 more...
)
MaintBy
( type: esriFieldTypeSmallInteger, alias: Maint By, editable: true, nullable: true, defaultValue: -1, modelName: MaintBy ,
Coded Values:
[1: Our Agency] , [-1: Private] , [-2: Other]
, ...1 more...
)
LocDesc
( type: esriFieldTypeString, alias: Location Desc, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocDesc )
TapPosition
( type: esriFieldTypeSmallInteger, alias: Tap Position, editable: true, nullable: true, defaultValue: null, modelName: TapPosition )
TapType
( type: esriFieldTypeString, alias: Tap Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TapType ,
Coded Values:
[Pretruding: Pretruding] , [Factory: Factory] , [Breakin: Breakin]
, ...1 more...
)
DepthCurb
( type: esriFieldTypeDouble, alias: Depth at Curb, editable: true, nullable: true, defaultValue: null, modelName: DepthCurb )
DistROW
( type: esriFieldTypeDouble, alias: Televise Length, editable: true, nullable: true, defaultValue: null, modelName: DistROW )
Grouted
( type: esriFieldTypeString, alias: Grouted, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Grouted ,
Coded Values:
[Yes: Yes] , [No: No] )
Material
( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Material ,
Coded Values:
[C-900: C-900] , [Cast Iron: Cast Iron] , [OTHER: OTHER]
, ...10 more...
)
LinedDate
( type: esriFieldTypeDate, alias: Lined Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LinedDate )
Diameter
( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: Diameter ,
Coded Values:
[42: 42"] , [36: 36"] , [30: 30"]
, ...9 more...
)
Length
( type: esriFieldTypeDouble, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: Length )
Notes
( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Notes )
UnitType
( type: esriFieldTypeString, alias: Unit Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UnitType ,
Coded Values:
[DI WYE: DI WYE] , [OTHR: OTHER] , [TAP: TAP]
, ...2 more...
)
UpMH
( type: esriFieldTypeString, alias: Up Manhole, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UpMH )
DwnMH
( type: esriFieldTypeString, alias: Down Manhole, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DwnMH )
DistMH
( type: esriFieldTypeDouble, alias: Distance to Manhole, editable: true, nullable: true, defaultValue: null, modelName: DistMH )
WyeElev
( type: esriFieldTypeDouble, alias: Wye Elev, editable: true, nullable: true, defaultValue: null, modelName: WyeElev )
EndElev
( type: esriFieldTypeDouble, alias: End Elevation, editable: true, nullable: true, defaultValue: null, modelName: EndElev )
Asbuilt
( type: esriFieldTypeString, alias: Asbuilt, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Asbuilt )
Subdivision
( type: esriFieldTypeString, alias: Subdivision, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Subdivision )
Contractor
( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Contractor )
Source
( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Source ,
Coded Values:
[CAD: CAD] , [DIG: Digitized] , [GPS: GPS]
, ...7 more...
)
UpMHDist
( type: esriFieldTypeDouble, alias: Up MH Distance, editable: true, nullable: true, defaultValue: null, modelName: UpMHDist )
DwnMHDist
( type: esriFieldTypeDouble, alias: Dwn MH Distance, editable: true, nullable: true, defaultValue: null, modelName: DwnMHDist )
TeleviseBook
( type: esriFieldTypeString, alias: Televise Book, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TeleviseBook )
TapDiameter
( type: esriFieldTypeDouble, alias: Tap Diameter, editable: true, nullable: true, defaultValue: null, modelName: TapDiameter ,
Coded Values:
[42: 42"] , [36: 36"] , [30: 30"]
, ...9 more...
)
ROWDepth
( type: esriFieldTypeDouble, alias: ROW Depth, editable: true, nullable: true, defaultValue: null, modelName: ROWDepth )
ObjectType
( type: esriFieldTypeString, alias: WinCan_Join, editable: true, nullable: true, length: 10, defaultValue: LAT, modelName: ObjectType )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
created_user
( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
created_date
( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
LateralLineID
( type: esriFieldTypeString, alias: NEWFacilityID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LateralLineID )
ReviewComplete
( type: esriFieldTypeString, alias: Review Complete, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ReviewComplete ,
Coded Values:
[Yes: Yes] , [No: No] )
Video
( type: esriFieldTypeString, alias: Video, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Video )
TelevisedLateralStatus
( type: esriFieldTypeString, alias: Televising Status , editable: true, nullable: true, length: 4, defaultValue: null, modelName: TelevisedLateralStatus ,
Coded Values:
[A: Assigned] , [Yes: Yes] , [No: No]
, ...2 more...
)
Shape__Length
( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )
Types:
ID: Yes
Name: Yes
Domains:
ActiveFlag:
Inherited
OwnedBy:
Inherited
MaintBy:
Inherited
TapType:
Inherited
Grouted:
Inherited
Material:
Inherited
Diameter:
Inherited
UnitType:
Inherited
Source:
Inherited
TapDiameter:
Inherited
ReviewComplete:
Inherited
TelevisedLateralStatus:
Inherited
Templates:
Name: Yes
Description:
Prototype:
Video:
null
TelevisedLateralStatus:
Yes
FacilityID:
null
ActiveFlag:
1
InstallDate:
null
RetireDate:
null
LateralLineID:
null
ReviewComplete:
null
OwnedBy:
-1
MaintBy:
-1
LocDesc:
null
TapPosition:
null
TapType:
null
DepthCurb:
null
DistROW:
null
Grouted:
null
Material:
null
LinedDate:
null
Diameter:
null
Length:
null
Notes:
null
UnitType:
null
UpMH:
null
DwnMH:
null
DistMH:
null
WyeElev:
null
EndElev:
null
Asbuilt:
null
Subdivision:
null
Contractor:
null
Source:
null
UpMHDist:
null
DwnMHDist:
null
TeleviseBook:
null
TapDiameter:
null
ROWDepth:
null
ObjectType:
LAT
Drawing Tool: esriFeatureEditToolLine
ID: No
Name: No
Domains:
ActiveFlag:
Inherited
OwnedBy:
Inherited
MaintBy:
Inherited
TapType:
Inherited
Grouted:
Inherited
Material:
Inherited
Diameter:
Inherited
UnitType:
Inherited
Source:
Inherited
TapDiameter:
Inherited
ReviewComplete:
Inherited
TelevisedLateralStatus:
Inherited
Templates:
Name: No
Description:
Prototype:
Video:
null
TelevisedLateralStatus:
No
FacilityID:
null
ActiveFlag:
1
InstallDate:
null
RetireDate:
null
LateralLineID:
null
ReviewComplete:
null
OwnedBy:
-1
MaintBy:
-1
LocDesc:
null
TapPosition:
null
TapType:
null
DepthCurb:
null
DistROW:
null
Grouted:
null
Material:
null
LinedDate:
null
Diameter:
null
Length:
null
Notes:
null
UnitType:
null
UpMH:
null
DwnMH:
null
DistMH:
null
WyeElev:
null
EndElev:
null
Asbuilt:
null
Subdivision:
null
Contractor:
null
Source:
null
UpMHDist:
null
DwnMHDist:
null
TeleviseBook:
null
TapDiameter:
null
ROWDepth:
null
ObjectType:
LAT
Drawing Tool: esriFeatureEditToolLine
ID: NA
Name: Not Accessible
Domains:
ActiveFlag:
Inherited
OwnedBy:
Inherited
MaintBy:
Inherited
TapType:
Inherited
Grouted:
Inherited
Material:
Inherited
Diameter:
Inherited
UnitType:
Inherited
Source:
Inherited
TapDiameter:
Inherited
ReviewComplete:
Inherited
TelevisedLateralStatus:
Inherited
Templates:
Name: Not Accessible
Description:
Prototype:
Video:
null
TelevisedLateralStatus:
NA
FacilityID:
null
ActiveFlag:
1
InstallDate:
null
RetireDate:
null
LateralLineID:
null
ReviewComplete:
null
OwnedBy:
-1
MaintBy:
-1
LocDesc:
null
TapPosition:
null
TapType:
null
DepthCurb:
null
DistROW:
null
Grouted:
null
Material:
null
LinedDate:
null
Diameter:
null
Length:
null
Notes:
null
UnitType:
null
UpMH:
null
DwnMH:
null
DistMH:
null
WyeElev:
null
EndElev:
null
Asbuilt:
null
Subdivision:
null
Contractor:
null
Source:
null
UpMHDist:
null
DwnMHDist:
null
TeleviseBook:
null
TapDiameter:
null
ROWDepth:
null
ObjectType:
LAT
Drawing Tool: esriFeatureEditToolLine
ID: A
Name: Assigned
Domains:
ActiveFlag:
Inherited
OwnedBy:
Inherited
MaintBy:
Inherited
TapType:
Inherited
Grouted:
Inherited
Material:
Inherited
Diameter:
Inherited
UnitType:
Inherited
Source:
Inherited
TapDiameter:
Inherited
ReviewComplete:
Inherited
TelevisedLateralStatus:
Inherited
Templates:
Name: Assigned
Description:
Prototype:
Video:
null
TelevisedLateralStatus:
A
FacilityID:
null
ActiveFlag:
1
InstallDate:
null
RetireDate:
null
LateralLineID:
null
ReviewComplete:
null
OwnedBy:
-1
MaintBy:
-1
LocDesc:
null
TapPosition:
null
TapType:
null
DepthCurb:
null
DistROW:
null
Grouted:
null
Material:
null
LinedDate:
null
Diameter:
null
Length:
null
Notes:
null
UnitType:
null
UpMH:
null
DwnMH:
null
DistMH:
null
WyeElev:
null
EndElev:
null
Asbuilt:
null
Subdivision:
null
Contractor:
null
Source:
null
UpMHDist:
null
DwnMHDist:
null
TeleviseBook:
null
TapDiameter:
null
ROWDepth:
null
ObjectType:
LAT
Drawing Tool: esriFeatureEditToolLine
ID: P
Name: Partial
Domains:
ActiveFlag:
Inherited
OwnedBy:
Inherited
MaintBy:
Inherited
TapType:
Inherited
Grouted:
Inherited
Material:
Inherited
Diameter:
Inherited
UnitType:
Inherited
Source:
Inherited
TapDiameter:
Inherited
ReviewComplete:
Inherited
TelevisedLateralStatus:
Inherited
Templates:
Name: Partial
Description:
Prototype:
Video:
null
TelevisedLateralStatus:
P
FacilityID:
null
ActiveFlag:
1
InstallDate:
null
RetireDate:
null
LateralLineID:
null
ReviewComplete:
null
OwnedBy:
-1
MaintBy:
-1
LocDesc:
null
TapPosition:
null
TapType:
null
DepthCurb:
null
DistROW:
null
Grouted:
null
Material:
null
LinedDate:
null
Diameter:
null
Length:
null
Notes:
null
UnitType:
null
UpMH:
null
DwnMH:
null
DistMH:
null
WyeElev:
null
EndElev:
null
Asbuilt:
null
Subdivision:
null
Contractor:
null
Source:
null
UpMHDist:
null
DwnMHDist:
null
TeleviseBook:
null
TapDiameter:
null
ROWDepth:
null
ObjectType:
LAT
Drawing Tool: esriFeatureEditToolLine
Relationships:
DBO.ssTelevising (1) --
Related To
:
ssTelevising
(4)
Tables:
Table:
ssTelevising
(4)
Name:
ssTelevising
Display Field:
FacilityID
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
3296ff1e7c2c4c318ddf47dfab0470a7
Copyright Text:
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
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: true
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
true
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
FacilityID
( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FacilityID )
TelevisedDate
( type: esriFieldTypeDate, alias: TelevisedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TelevisedDate )
Notes
( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 140, defaultValue: null, modelName: Notes )
Length
( type: esriFieldTypeDouble, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: Length )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
LineType
( type: esriFieldTypeString, alias: LineType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LineType ,
Coded Values:
[Main: Main] , [Lateral: Lateral] )
Templates:
Name: ssTelevising
Description:
Prototype:
LineType:
null
FacilityID:
null
TelevisedDate:
null
Notes:
null
Length:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
DBO.ssLateralLine (1) --
Related To
:
Sanitary Sewer Laterals
(5)
DBO.ssMains (0) --
Related To
:
Sanitary Sewer Mains
(6)