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:
XMin: -13747629.6797
YMin: 5543509.8806
XMax: -13718131.5275
YMax: 5561485.8265
Spatial Reference: 102100 (3857)
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:
IsSystemMaintained : True
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:
Name: Corvallis_Valve
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- 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