Name: production.DBO.ssLateral_Inspections
Display Field: FACILITYID
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
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
)
-
FACILITYID
(
type: esriFieldTypeString, alias: Facility Identifier, length: 35
)
-
INSPECTIONDATE
(
type: esriFieldTypeDate, alias: Inspection Date, length: 8
)
-
ADDRESSSTREET
(
type: esriFieldTypeString, alias: Address - Street, length: 50
)
-
DSSTATION
(
type: esriFieldTypeSmallInteger, alias: Downstream Station
)
-
CLOCKPOSDS
(
type: esriFieldTypeSmallInteger, alias: Clock Position (downstream)
)
-
UNCONFIRMEDFLOW
(
type: esriFieldTypeInteger, alias: Unconfirmed Flow
)
-
CONFIRMEDII
(
type: esriFieldTypeInteger, alias: Confirmed I/I
)
-
NEEDSDIG
(
type: esriFieldTypeString, alias: Needs Dig Repair?, length: 10
)
-
NEEDSADDINV
(
type: esriFieldTypeString, alias: Needs Additional Investigation?, length: 10
)
-
SEWERMAINID
(
type: esriFieldTypeString, alias: Sewer Main ID, length: 20
)
-
DIAMETER
(
type: esriFieldTypeDouble, alias: Diameter (in)
)
-
MATERIAL
(
type: esriFieldTypeString, alias: Material, length: 20
)
-
ESTTOTALLENGTH
(
type: esriFieldTypeSmallInteger, alias: Estimated Total Length (ft)
)
-
IICOMMENT
(
type: esriFieldTypeString, alias: I/I Comments, length: 250
)
-
STRCOMMENT
(
type: esriFieldTypeString, alias: Structural Comments, length: 250
)
-
ROOTS
(
type: esriFieldTypeSmallInteger, alias: Roots Observed?
)
-
LETTER
(
type: esriFieldTypeSmallInteger, alias: Send Structural Letter?
)
-
CONDITION
(
type: esriFieldTypeString, alias: Condition, length: 10
)
-
SPR
(
type: esriFieldTypeSmallInteger, alias: SPR
)
-
MPR
(
type: esriFieldTypeSmallInteger, alias: MPR
)
-
OPR
(
type: esriFieldTypeSmallInteger, alias: OPR
)
-
PACP_OPRI
(
type: esriFieldTypeDouble, alias: PACP OPRI
)
-
OPRI_PLF
(
type: esriFieldTypeDouble, alias: OPRI PLF
)
-
HAS90
(
type: esriFieldTypeSmallInteger, alias: Has 90?
)
-
SUMP
(
type: esriFieldTypeString, alias: Sump?, length: 10
)
-
RELATEFIELD
(
type: esriFieldTypeString, alias: RELATEFIELD, length: 50
)
-
REPORTNUMBER
(
type: esriFieldTypeString, alias: Report Number, length: 15
)
-
PROJECTID
(
type: esriFieldTypeString, alias: PROJECTID, length: 20
)
-
GISHYPERLINK
(
type: esriFieldTypeString, alias: GISHYPERLINK, length: 250
)
-
FIELDHYPERLINK
(
type: esriFieldTypeString, alias: FIELDHYPERLINK, length: 250
)
-
PARENTGUI
(
type: esriFieldTypeGUID, alias: PARENTGUI, length: 38
)
-
COMM_RES4
(
type: esriFieldTypeString, alias: Commercial vs Residential <4, length: 20
)
-
ADDRESSNO
(
type: esriFieldTypeString, alias: Address - Number, length: 30
)
-
YEARLASTPAVED
(
type: esriFieldTypeString, alias: Year Last Paved, length: 25
)
-
FUTUREPAVING
(
type: esriFieldTypeString, alias: Future Planned Paving, length: 25
)
-
LENGTHINSPECTED
(
type: esriFieldTypeDouble, alias: Length Inspected (ft)
)
-
VIDEOFOLDER
(
type: esriFieldTypeString, alias: VIDEO FOLDER, length: 15
)
Relationships:
Supported Operations:
Query
Query Attachments
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata