Name: GDB_TRANS.TRANS.NPDES_CULVERTS
Display Field: STREET_NAME
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: The GDB_TRANS.TRANS.NPDES_CULVERTS feature class is a GIS database created to aid the Transportation Department with the NPDES compliance. The GDB_TRANS.TRANS.NPDES_CULVERTS feature class contains the location of Culverts (storm drains) in Riverside County within theTransportation Department ROW and their maintenance activities such as inspections, cleaning schedules, trash removal tonnage and characterization.POINTID: ID Originated by the GPSCULVERT_ID: Culvert ID NumberCULVERT_NUMBER: Culvert Road NumberRDNUMBER: Road NumberSDI_NUMBER: Storm Data Inventory NumberPRE_DIR: Prefix DirectionSTREET_NAME: Street NameSTREET_TYPE: Street TypeSUF_DIR: Suffix DirectionWATERSHED: Watershed NameSUP_DISTRICT_NUMBER: Supervisorial District NumberDISTRICT_MAINT_YARD: District Maintenance YardTRACT: Tract NumberFEATURE: FeatureMATERIAL: MaterialCULVERT_TYPE: Type of the CulvertNORTHING: Northing Coordinates (NAD_1983_StatePlane_California_VI_FIPS_0406_Feet)EASTING: Easting Coordinates (NAD_1983_StatePlane_California_VI_FIPS_0406_Feet)ELEVATION: Elevation in feetWIDTH_OPENING: Width Measurement in feet. Distance from Opening to OpeningHEIGHT_OPENING: Height Measurement in feet. Distance from Sidewalk Height to Street GroundDIAMETER: Diameter in feetSYSTEM_DATE: Date the data was inputSTART_MAINTENANCE_DATE: Start Maintenance DateSTOP_MAINTENANCE_DATE: Stop Maintenance DateINSPECTION_DATE: Date of the InspectionMAINTENANCE_DATE: Date of the MaintenanceLITTER_TONNAGE: Litter Weight in tons INSPECTION_COMMENTS: Inspection CommentsPHOTO_PTR: Photo Address LocationPLAN_URL: URL Plan Address LocationPLAN_DRAWER: Drawer Plan LocationPLAN_FILE: File Plan Location
Definition Expression: N/A
Copyright Text: This Feature Class was created by Riverside County Transportation Department (RCDT).
Default Visibility: true
MaxRecordCount: 50000
Supported Query Formats: JSON, AMF, geoJSON
Min Scale: 0
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Has Labels: false
Can Modify Layer: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports Datum Transformation: true
Extent:
XMin: 6140813.080127299
YMin: 2102429.7685491443
XMax: 6655891.159221053
YMax: 2316188.38302581
Spatial Reference: 102646
(2230)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 143, 105, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
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:
-
OBJECTID
(
type: esriFieldTypeOID
, alias: OBJECTID
)
-
POINTID
(
type: esriFieldTypeInteger
, alias: POINTID
)
-
CULVERT_ID
(
type: esriFieldTypeInteger
, alias: CULVERT_ID
)
-
CULVERT_NUMBER
(
type: esriFieldTypeString
, alias: CULVERT_NUMBER
, length: 30
)
-
RDNUMBER
(
type: esriFieldTypeString
, alias: RDNUMBER
, length: 30
)
-
SDI_NUMBER
(
type: esriFieldTypeInteger
, alias: SDI_NUMBER
)
-
PRE_DIR
(
type: esriFieldTypeString
, alias: PRE_DIR
, length: 6
)
-
STREET_NAME
(
type: esriFieldTypeString
, alias: STREET_NAME
, length: 30
)
-
STREET_TYPE
(
type: esriFieldTypeString
, alias: STREET_TYPE
, length: 6
)
-
SUF_DIR
(
type: esriFieldTypeString
, alias: SUF_DIR
, length: 6
)
-
WATERSHED
(
type: esriFieldTypeString
, alias: WATERSHED
, length: 40
)
-
SUP_DISTRICT_NUMBER
(
type: esriFieldTypeSmallInteger
, alias: SUP_DISTRICT_NUMBER
)
-
DISTRICT_MAINT_YARD
(
type: esriFieldTypeString
, alias: DISTRICT_MAINT_YARD
, length: 30
)
-
TRACT
(
type: esriFieldTypeString
, alias: TRACT
, length: 30
)
-
FEATURE
(
type: esriFieldTypeString
, alias: FEATURE
, length: 30
)
-
MATERIAL
(
type: esriFieldTypeString
, alias: MATERIAL
, length: 30
)
-
CULVERT_TYPE
(
type: esriFieldTypeString
, alias: CULVERT_TYPE
, length: 30
)
-
NORTHING
(
type: esriFieldTypeDouble
, alias: NORTHING
)
-
EASTING
(
type: esriFieldTypeDouble
, alias: EASTING
)
-
ELEVATION
(
type: esriFieldTypeDouble
, alias: ELEVATION
)
-
WIDTH_OPENING
(
type: esriFieldTypeDouble
, alias: WIDTH_OPENING
)
-
HEIGHT_OPENING
(
type: esriFieldTypeDouble
, alias: HEIGHT_OPENING
)
-
DIAMETER
(
type: esriFieldTypeDouble
, alias: DIAMETER
)
-
SYSTEM_DATE
(
type: esriFieldTypeDate
, alias: SYSTEM_DATE
, length: 8
)
-
START_MAINTENANCE_DATE
(
type: esriFieldTypeDate
, alias: START_MAINTENANCE_DATE
, length: 8
)
-
STOP_MAINTENANCE_DATE
(
type: esriFieldTypeDate
, alias: STOP_MAINTENANCE_DATE
, length: 8
)
-
INSPECTION_DATE
(
type: esriFieldTypeDate
, alias: INSPECTION_DATE
, length: 8
)
-
MAINTENANCE_DATE
(
type: esriFieldTypeDate
, alias: MAINTENANCE_DATE
, length: 8
)
-
LITTER_TONNAGE
(
type: esriFieldTypeDouble
, alias: LITTER_TONNAGE
)
-
INSPECTION_COMMENTS
(
type: esriFieldTypeString
, alias: INSPECTION_COMMENTS
, length: 150
)
-
PHOTO_PTR
(
type: esriFieldTypeString
, alias: PHOTO_PTR
, length: 150
)
-
PLAN_URL
(
type: esriFieldTypeString
, alias: PLAN_URL
, length: 150
)
-
PLAN_DRAWER
(
type: esriFieldTypeString
, alias: PLAN_DRAWER
, length: 30
)
-
PLAN_FILE
(
type: esriFieldTypeString
, alias: PLAN_FILE
, length: 30
)
-
SHAPE
(
type: esriFieldTypeGeometry
, alias: SHAPE
)
Supported Operations:
Query
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata