Layer: Corvallis_Valve (ID:5)

View In: Map Viewer

Name: Corvallis_Valve

Display Field: OPEN_DIREC

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

The City of Corvallis Water Distribution system was derived from a variety of source maps including; Asbuilt construction plans(PIPC), City designed projects (CIP), field crew edits and historic field maps. New developments generally come from private contracts and use survey data to ensure accuracy.

Copyright Text: City of Corvallis, Oregon Geographic Information System Services

Min. Scale: 288896

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[87,168,40,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID_12, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
SYS_ID (type: esriFieldTypeDouble, alias: System ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
OPEN_DIREC (type: esriFieldTypeString, alias: Open Direction, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
TURNS (type: esriFieldTypeDouble, alias: Turns, SQL Type: sqlTypeOther, nullable: true, editable: true)
OWNERSHIP (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [AFC: AFC], [CITY: City], [PVT: Private])
TYPE (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SIZE (type: esriFieldTypeString, alias: Valve Size, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
NORM_OPEN (type: esriFieldTypeString, alias: Normally Open, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [T: True], [F: False])
COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 141, nullable: true, editable: true)
LOCATION (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
RUN_OF_PIPE (type: esriFieldTypeString, alias: Run of Pipe, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
DEPTH_TO_O (type: esriFieldTypeString, alias: Depth to Nut, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
LINE_ID (type: esriFieldTypeDouble, alias: Line ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
DISTFROMLINE (type: esriFieldTypeDouble, alias: Distance From Line, SQL Type: sqlTypeOther, nullable: true, editable: true)
UPDATE_ (type: esriFieldTypeDate, alias: UPDATE_, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
DIST1 (type: esriFieldTypeString, alias: Distance 1, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
DIRECT1 (type: esriFieldTypeString, alias: Direction 1, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
OBJDIR1 (type: esriFieldTypeString, alias: OBJDIR1, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
OBJECT1 (type: esriFieldTypeString, alias: Object 1, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
DIST2 (type: esriFieldTypeString, alias: Distance 2, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
DIRECT2 (type: esriFieldTypeString, alias: Direction 2, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
OBJDIR2 (type: esriFieldTypeString, alias: Object 2, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
OBJECT2 (type: esriFieldTypeString, alias: OBJECT2, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
ABANDONED (type: esriFieldTypeDate, alias: Abandoned Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
UPDATETIME (type: esriFieldTypeString, alias: Update Time, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
CHK_LOC (type: esriFieldTypeDouble, alias: Check Location, SQL Type: sqlTypeOther, nullable: true, editable: true)
GAL_MIN (type: esriFieldTypeInteger, alias: Gallons Per Minute, SQL Type: sqlTypeOther, nullable: true, editable: true)
MINUTES (type: esriFieldTypeSmallInteger, alias: Minutes, SQL Type: sqlTypeOther, nullable: true, editable: true)
CHLORINE_S (type: esriFieldTypeDouble, alias: Chlorine Start, SQL Type: sqlTypeOther, nullable: true, editable: true)
CHLORINE_E (type: esriFieldTypeDouble, alias: Cholorine End, SQL Type: sqlTypeOther, nullable: true, editable: true)
NTU_START (type: esriFieldTypeDouble, alias: NTU Start, SQL Type: sqlTypeOther, nullable: true, editable: true)
NTU_END (type: esriFieldTypeDouble, alias: NTU End, SQL Type: sqlTypeOther, nullable: true, editable: true)
PIPE_LENGTH (type: esriFieldTypeDouble, alias: Pipe Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
CREW (type: esriFieldTypeString, alias: Crew, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
FLUSH_COMM (type: esriFieldTypeString, alias: Flush Comments, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
FLUSH_DATE (type: esriFieldTypeDate, alias: Flush Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
FLUSHED (type: esriFieldTypeString, alias: Flushed, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
STRUCT_ID (type: esriFieldTypeString, alias: Structure ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
PROJECT (type: esriFieldTypeString, alias: Project Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
GAL_FLUSH (type: esriFieldTypeInteger, alias: Gallons Flushed, SQL Type: sqlTypeOther, nullable: true, editable: true)
CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ABAN: ABANDONDED], [RMVD: REMOVED], [PLUG: PLUGGED], ... 4 more ...)
ORIGIN (type: esriFieldTypeString, alias: Origin, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AFC: AFC], [ASB: ASB], [CITY: City], ... 4 more ...)
AIR_TEST (type: esriFieldTypeString, alias: Air Test, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
EXCHANGE (type: esriFieldTypeString, alias: Exchange, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
SCOUR (type: esriFieldTypeString, alias: Scour, SQL Type: sqlTypeOther, length: 5, 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)
DECHLOR (type: esriFieldTypeDouble, alias: Dechlorination, SQL Type: sqlTypeOther, nullable: true, editable: true)
FLUSHTYPE (type: esriFieldTypeString, alias: Flush Type, SQL Type: sqlTypeOther, length: 50, 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 Editd Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
INSTALL_DATE (type: esriFieldTypeSmallInteger, alias: Install Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
SERVICE_LEVEL (type: esriFieldTypeString, alias: Service Level, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
DESCRIPTION (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
CONNECTION_TYPE (type: esriFieldTypeString, alias: Connection Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [MJ: MJ], [FLG: FLG], [FLGxMJ: FLGxMJ], ... 2 more ...)
VALUE (type: esriFieldTypeSmallInteger, alias: Value, SQL Type: sqlTypeOther, nullable: true, editable: true)
USEFUL_LIFE (type: esriFieldTypeSmallInteger, alias: Useful Life, SQL Type: sqlTypeOther, 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)
MAKE (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Ohio Brass: Ohio Brass], [Kennedy: Kennedy], [Clow: Clow], ... 7 more ...)

Templates:

TYPE: GATE
SIZE: 8
CONDITION: OPEN

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/11/2024 3:55:47 PM

Schema Last Edit Date: 7/11/2024 3:55:47 PM

Data Last Edit Date: 7/11/2024 3:55:24 PM

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