Name: Corvallis_Meter
Display Field: ST_NAME
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 GIS 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: -13743063.5526
YMin: 5543513.1436
XMax: -13718116.3793
YMax: 5561468.3329
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[54,35,130,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, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- RECORD (type: esriFieldTypeDouble, alias: RECORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ST_NUMBR (type: esriFieldTypeString, alias: Street Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- ST_PFX (type: esriFieldTypeString, alias: Street Prefix, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- ST_NAME (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- ST_TYPE (type: esriFieldTypeString, alias: Street Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- UNIT (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- TAX_ID (type: esriFieldTypeDouble, alias: Tax ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- UNIT_TYPE (type: esriFieldTypeString, alias: Unit Type, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
- ORIGIN (type: esriFieldTypeString, alias: Origin, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
- CUSTID (type: esriFieldTypeDouble, alias: Customer ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SERVICE (type: esriFieldTypeString, alias: Service, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- METERNO (type: esriFieldTypeString, alias: Meter Number1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- IOCODE (type: esriFieldTypeString, alias: IO Code, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- RTCLASS (type: esriFieldTypeString, alias: RT Class, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- METERSIZE (type: esriFieldTypeString, alias: Meter Size, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [0.625: 5/8''], [0.75: 3/4''], [1: 1''], ... 8 more ...)
- CUSTSTAT (type: esriFieldTypeString, alias: Customer Stat, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- CUSTTYPE (type: esriFieldTypeString, alias: Customer Type, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- CUSTNAME (type: esriFieldTypeString, alias: Customer Name, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- LOCSTAT (type: esriFieldTypeString, alias: Location Status, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- TAP_NUM (type: esriFieldTypeString, alias: Tap Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- INSTALDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- METER_NUM (type: esriFieldTypeString, alias: Meter Number2, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
- METER_SER (type: esriFieldTypeString, alias: Meter Service, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- METER_SIZE (type: esriFieldTypeString, alias: Meter Size2, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- TAP_LOCAT (type: esriFieldTypeString, alias: Tap Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- METR_LOCAT (type: esriFieldTypeString, alias: Meter Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- TAP_SIZE (type: esriFieldTypeString, alias: Tap Size, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- UTILACCNUM (type: esriFieldTypeString, alias: UT Billing Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- LEVEL_ (type: esriFieldTypeString, alias: Service Level, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
- SEV_TYPE (type: esriFieldTypeString, alias: Service Type, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- CUST_TYPE (type: esriFieldTypeString, alias: Customer Type, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- SEQ_NUM (type: esriFieldTypeString, alias: Sequence Number, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- NUM_UNITS (type: esriFieldTypeString, alias: Number Units, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- DATE_PAID (type: esriFieldTypeDate, alias: Date Paid, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- MAKE (type: esriFieldTypeString, alias: Make, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [SENSUS: Sensus], [NEPTUNE: Neptune], [BADGER: Badger], ... 1 more ...)
- MODEL (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- TAP_TYPE (type: esriFieldTypeString, alias: Tap Type, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- REMARKS (type: esriFieldTypeString, alias: Remarks, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
- CASE_ID (type: esriFieldTypeString, alias: Case ID, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
- SERVLEVEL (type: esriFieldTypeDouble, alias: Service Level2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- BUILDING (type: esriFieldTypeString, alias: Building, SQL Type: sqlTypeOther, length: 48, nullable: true, editable: true)
- LOCID (type: esriFieldTypeDouble, alias: Location ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DATE_SERV (type: esriFieldTypeDate, alias: Date Served, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- MDIST1 (type: esriFieldTypeString, alias: Measure Distance 1, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
- MDIRECT1 (type: esriFieldTypeString, alias: MDIRECT1, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- MOBJDIR1 (type: esriFieldTypeString, alias: Measure Object 1, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
- MDIST2 (type: esriFieldTypeString, alias: Measure Distance 2, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
- MDIRECT2 (type: esriFieldTypeString, alias: Measure Direction 2, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- MOBJDIR2 (type: esriFieldTypeString, alias: Measure Object Direction 2, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
- MOBJECT2 (type: esriFieldTypeString, alias: Measure Object 2, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
- TDIST1 (type: esriFieldTypeString, alias: TDIST1, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
- TDIRECT1 (type: esriFieldTypeString, alias: TDIRECT1, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- TOBJDIR1 (type: esriFieldTypeString, alias: TOBJDIR1, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
- TOBJECT1 (type: esriFieldTypeString, alias: TOBJECT1, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
- TDIST2 (type: esriFieldTypeString, alias: TDIST2, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
- TDIRECT2 (type: esriFieldTypeString, alias: TDIRECT2, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- TOBJDIR2 (type: esriFieldTypeString, alias: TOBJDIR2, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
- TOBJECT2 (type: esriFieldTypeString, alias: TOBJECT2, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
- MOBJECT1 (type: esriFieldTypeString, alias: MOBJECT1, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
- MXU (type: esriFieldTypeString, alias: MXU, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- CHK_LOC (type: esriFieldTypeSmallInteger, alias: CHK_LOC, SQL Type: sqlTypeOther, nullable: true, editable: true)
- UPDATE_ (type: esriFieldTypeDate, alias: UPDATE_, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- UPDATETIME (type: esriFieldTypeString, alias: UPDATETIME, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
- INST_PRESS (type: esriFieldTypeSmallInteger, alias: INST_PRESS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ID (type: esriFieldTypeDouble, alias: ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GPMS1 (type: esriFieldTypeDouble, alias: GPM Small First Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GPMS2 (type: esriFieldTypeDouble, alias: GPM Small Second Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GPML1 (type: esriFieldTypeDouble, alias: GPM Large First Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GPML2 (type: esriFieldTypeDouble, alias: GPM Large Second Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GPML3 (type: esriFieldTypeDouble, alias: GPM Large Third Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CUS1 (type: esriFieldTypeDouble, alias: CubicFeet Small First Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CUS2 (type: esriFieldTypeDouble, alias: CubicFeet Small Second Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CUL1 (type: esriFieldTypeDouble, alias: CubicFeet Large First Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CUL2 (type: esriFieldTypeDouble, alias: CubicFeet Large Second Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CUL3 (type: esriFieldTypeDouble, alias: CubicFeet Large Third Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ACCUS1 (type: esriFieldTypeDouble, alias: Accuracy Small First Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ACCUS2 (type: esriFieldTypeDouble, alias: Accuracy Small Second Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ACCUL1 (type: esriFieldTypeDouble, alias: Accuracy Large First Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ACCUL2 (type: esriFieldTypeDouble, alias: Accuracy Large Second Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ACCUL3 (type: esriFieldTypeDouble, alias: Accuracy Large Third Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
- BYPASS (type: esriFieldTypeSmallInteger, alias: Bypass, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DONE (type: esriFieldTypeSmallInteger, alias: Done, SQL Type: sqlTypeOther, nullable: true, editable: true)
- STATIC_PSI (type: esriFieldTypeDouble, alias: Static PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
- X_COORD (type: esriFieldTypeDouble, alias: X_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Y_COORD (type: esriFieldTypeDouble, alias: Y_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DATE_PUBLISHED (type: esriFieldTypeDate, alias: DATE_PUBLISHED, 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)
- STRUCT_ID (type: esriFieldTypeString, alias: Structure ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- METER_TYPE (type: esriFieldTypeString, alias: Meter Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [TURBO: Turbo], [COMPOUND: Compound], [FIRE: Fire], ... 1 more ...)
- 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)
- 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)
- SYS_ID (type: esriFieldTypeDouble, alias: SYS_ID, 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 ...)
- GPSD (type: esriFieldTypeString, alias: GPS Verified, SQL Type: sqlTypeOther, length: 50, 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)
Templates:
Name: Corvallis_Meter
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
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