Layer: Corvallis_Line (ID:3)

View In: Map Viewer

Name: Corvallis_Line

Display Field: SYSTEM_TYPE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

The City of Corvallis Collections access structures database was derived from paper source maps. The data provides a representation of the geometry and topology of the stormwater and wastewater facilities maintained by the Public Works Collections Crew.

Copyright Text: City of Corvallis, Oregon Geographic Information Services

Min. Scale: 288896

Max. Scale: 0

Default Visibility: true

Max Record Count: 4000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[60,127,39,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
SYSTEM_TYPE (type: esriFieldTypeString, alias: System Type, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [COMBO: COMBO], [SANITARY: SANITARY], [STORM: STORM])
STRUCT_TYP (type: esriFieldTypeString, alias: Structure Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [SANP: SANP], [STMP: STMP], [STMD: STMD], ... 8 more ...)
STRUCT_ID (type: esriFieldTypeString, alias: Structure ID, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
SYS_ID (type: esriFieldTypeDouble, alias: System ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
FROM_NODE_OLD (type: esriFieldTypeString, alias: Old From Node, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
FROM_NODE (type: esriFieldTypeString, alias: From Node, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
FNODE_TYPE (type: esriFieldTypeString, alias: From Node Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
TO_NODE_OR_OLD (type: esriFieldTypeString, alias: Old To Node, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
TO_NODE (type: esriFieldTypeString, alias: To Node, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
TNODE_TYPE (type: esriFieldTypeString, alias: To Node Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
PIPE_TYPE (type: esriFieldTypeString, alias: Pipe Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [CULVERT: CULVERT], [SLOTTED: SLOTTED], [PERF: PERF], ... 2 more ...)
WIDTH (type: esriFieldTypeDouble, alias: Width of Pipe, SQL Type: sqlTypeOther, nullable: true, editable: true)
DIAMETER (type: esriFieldTypeDouble, alias: Diameter of Pipe, SQL Type: sqlTypeOther, nullable: true, editable: true)
MATERIAL (type: esriFieldTypeString, alias: Pipe Material, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BR: Brick], [CSU: Conc. Segments Unbolted], ... 24 more ...)
FLOW_DIR (type: esriFieldTypeString, alias: Flow Direction, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [N: N], [S: S], [E: E], ... 5 more ...)
PROJECT_NO (type: esriFieldTypeString, alias: Project Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
OWNERSHIP (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [AFC: AFC], [STATE: STATE], [OSU: OSU], ... 2 more ...)
CCTV (type: esriFieldTypeString, alias: CCTV, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO], [MINI: MINI])
CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [PLUG: PLUG], [REMOVED: REMOVED], [ABAN: ABAN], ... 1 more ...)
DPIPE_DIAM (type: esriFieldTypeDouble, alias: Down Pipe Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
UP_INVERT (type: esriFieldTypeDouble, alias: Up Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
DN_INVERT (type: esriFieldTypeDouble, alias: Down Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
SLOPE (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
MAX_DEPTH (type: esriFieldTypeDouble, alias: Maximum Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
MIN_DEPTH (type: esriFieldTypeDouble, alias: Minimum Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
AVG_DEPTH (type: esriFieldTypeDouble, alias: Average Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
SURFACE (type: esriFieldTypeString, alias: Surface Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [AC: AC], [NAT: NAT], [PCC: PCC], ... 2 more ...)
BACKFILL (type: esriFieldTypeString, alias: Backfill Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [CDF: CDF], [A: Gravel Fill], [B: Native], ... 1 more ...)
COMMENT (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
YEAR_BUILD (type: esriFieldTypeInteger, alias: Year Built, SQL Type: sqlTypeOther, nullable: true, editable: true)
EASEMENT (type: esriFieldTypeString, alias: Easement, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
CLEANING_FREQ (type: esriFieldTypeString, alias: Cleaning Frequency, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
X_COORD (type: esriFieldTypeDouble, alias: X Coordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
Y_COORD (type: esriFieldTypeDouble, alias: Y Coordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
TV_DATE (type: esriFieldTypeDate, alias: TV Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
AS_BUILT_DATE (type: esriFieldTypeDate, alias: As Built Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CLEANING_DATE (type: esriFieldTypeDate, alias: Cleaning Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
NASSCO_RATING (type: esriFieldTypeString, alias: NASSCO Rating, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [S1: S1], [S2: S2], [S3: S3], ... 1 more ...)
DESCRIPTION (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
CHARACTERISTICS (type: esriFieldTypeString, alias: Characteristics, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [FOG: FOG], [ROOTS: ROOTS], [GRADE: GRADE], ... 2 more ...)
INSTALL_DATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
USEFUL_LIFE (type: esriFieldTypeSmallInteger, alias: Useful Life, SQL Type: sqlTypeOther, nullable: true, editable: true)
VALUE (type: esriFieldTypeSmallInteger, alias: Value, SQL Type: sqlTypeOther, nullable: true, editable: true)
ACCEAL_ID (type: esriFieldTypeInteger, alias: Accela ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
TVREPORT (type: esriFieldTypeString, alias: TV Reports, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
ROOTACTION (type: esriFieldTypeString, alias: Root Actions, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Cut: Cut], [CutFoam: CutFoam])
CUTDATE (type: esriFieldTypeDate, alias: Cut Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
COF (type: esriFieldTypeDouble, alias: COF, SQL Type: sqlTypeOther, nullable: true, editable: true)
POF (type: esriFieldTypeDouble, alias: POF, SQL Type: sqlTypeOther, nullable: true, editable: true)
BRE (type: esriFieldTypeDouble, alias: BRE, SQL Type: sqlTypeOther, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
New_ID (type: esriFieldTypeInteger, alias: New_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

STRUCT_ID:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/11/2024 3:57:32 PM

Schema Last Edit Date: 7/11/2024 3:57:32 PM

Data Last Edit Date: 7/9/2024 4:33:33 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Add Features Update Features Delete Features Apply Edits Calculate Generate Renderer Validate SQL Get Estimates ConvertFormat