Name: production.DBO.ssLateral_Inspections
Display Field: FACILITYID
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: null
Default Visibility: false
MaxRecordCount: 2000
MaxSelectionCount: 0
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Feature Draw Order:
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: false
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
)
-
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
)
-
created_user
(
type: esriFieldTypeString, alias: created_user, length: 255
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, length: 8
)
-
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, length: 255
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, length: 8
)
Relationships:
Supported Operations:
Query
Query Attachments
Query Analytic
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata