View In:   City of Bellevue GIS Portal

Name: wServiceConnections

Display Field: PROJECT_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 100000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -1.3609343446986865E7
YMin: 6030037.7708992455
XMax: -1.3590785362284288E7
YMax: 6050554.471811087
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 5, 138, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Asset Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• ACCOUNTID ( type: esriFieldTypeString, alias: Account Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ACCOUNTID )
• PROJECT_NAME ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROJECT_NAME )
• MAXWORKORDERNUM ( type: esriFieldTypeString, alias: MAXIMO Work Order Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAXWORKORDERNUM )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: Operating, modelName: STATUS , Coded Values: [Abandoned: Abandoned] , [Decommissioned: Decommissioned] , [Operating: Operational] , ...3 more... )
• OWNEDBY ( type: esriFieldTypeString, alias: Owned By, editable: true, nullable: true, length: 10, defaultValue: BELLEVUE, modelName: OWNEDBY , Coded Values: [PARKS: Bellevue Parks Department] , [CWA: Cascade Water Alliance] , [ISSAQUAH: City of Issaquah] , ...11 more... )
• MAINTBY ( type: esriFieldTypeString, alias: Managed By, editable: true, nullable: true, length: 10, defaultValue: BELLEVUE, modelName: MAINTBY , Coded Values: [BELLEVUE: City of Bellevue] , [CCUD: Coal Creek Utility District] , [CWA: Cascade Water Alliance] , ...11 more... )
• EASEMENTFLAG ( type: esriFieldTypeString, alias: In An Easment?, editable: true, nullable: true, length: 3, defaultValue: No, modelName: EASEMENTFLAG , Coded Values: [Yes: Yes] , [No: No] , [UNK: Unknown] )
• EASERECNO ( type: esriFieldTypeString, alias: Easement Recording Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EASERECNO )
• SERVICETYPE ( type: esriFieldTypeString, alias: Service Type, editable: true, nullable: true, length: 50, defaultValue: Domestic, modelName: SERVICETYPE , Coded Values: [Domestic: Domestic] , [Domestic Fire: Domestic Fire] , [High Compound: High Compound] , ...11 more... )
• SERVICEADDRESS ( type: esriFieldTypeString, alias: Service Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SERVICEADDRESS )
• INFOSOURCE ( type: esriFieldTypeString, alias: Info Source, editable: true, nullable: true, length: 10, defaultValue: null, modelName: INFOSOURCE , Coded Values: [Asbuilt: Asbuilt] , [Field: Field] )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Meter Box Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• METINSTDATE ( type: esriFieldTypeDate, alias: Meter Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: METINSTDATE )
• METERSIZE ( type: esriFieldTypeDouble, alias: Meter Size, editable: true, nullable: true, defaultValue: null, modelName: METERSIZE , Coded Values: [0.625: 5/8"] , [0.75: 3/4"] , [1: 1"] , ...11 more... )
• METSERIALNUM ( type: esriFieldTypeString, alias: Meter Serial Number, editable: true, nullable: true, length: 12, defaultValue: null, modelName: METSERIALNUM )
• METERMANUFACTURER ( type: esriFieldTypeString, alias: Meter Manufacturer, editable: true, nullable: true, length: 15, defaultValue: null, modelName: METERMANUFACTURER , Coded Values: [American: American] , [Badger: Badger] , [Calmet: Calmet] , ...20 more... )
• METMODEL ( type: esriFieldTypeString, alias: Meter Model Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: METMODEL )
• DIALCOUNT ( type: esriFieldTypeSmallInteger, alias: Number of Dials, editable: true, nullable: true, defaultValue: null, modelName: DIALCOUNT )
• METINITIALREAD ( type: esriFieldTypeSmallInteger, alias: Meter Initial Read, editable: true, nullable: true, defaultValue: null, modelName: METINITIALREAD )
• TOUCHREADID ( type: esriFieldTypeString, alias: Touch Read ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TOUCHREADID )
• PSERVICETYPE ( type: esriFieldTypeString, alias: Previous Service Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PSERVICETYPE , Coded Values: [Domestic: Domestic] , [Domestic Fire: Domestic Fire] , [High Compound: High Compound] , ...11 more... )
• PMETINSTDATE ( type: esriFieldTypeDate, alias: Previous Meter Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PMETINSTDATE )
• PMETERSIZE ( type: esriFieldTypeDouble, alias: Previous Meter Size, editable: true, nullable: true, defaultValue: null, modelName: PMETERSIZE , Coded Values: [0.625: 5/8"] , [0.75: 3/4"] , [1: 1"] , ...11 more... )
• PMETSERIAL ( type: esriFieldTypeString, alias: Previous Meter Serial Number, editable: true, nullable: true, length: 12, defaultValue: null, modelName: PMETSERIAL )
• PMETERMANUFACTURER ( type: esriFieldTypeString, alias: Previous Meter Manufactuer, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PMETERMANUFACTURER , Coded Values: [American: American] , [Badger: Badger] , [Calmet: Calmet] , ...20 more... )
• PMETMODEL ( type: esriFieldTypeString, alias: Previous Meter Model, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PMETMODEL )
• PMETFINALREAD ( type: esriFieldTypeInteger, alias: Previous Meter Final Read, editable: true, nullable: true, defaultValue: null, modelName: PMETFINALREAD )
• SVCCONNINSTALLDATE ( type: esriFieldTypeDate, alias: Service Connection Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SVCCONNINSTALLDATE )
• SVCLINEINSTALL ( type: esriFieldTypeDate, alias: Service Line Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SVCLINEINSTALL )
• SVCCONNTYPE ( type: esriFieldTypeString, alias: Service Connection Type, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SVCCONNTYPE , Coded Values: [Direct Tap: Direct Tap] , [Saddle: Saddle] , [Tapping Tee: Tapping Tee] , ...2 more... )
• SVCLINESIZE ( type: esriFieldTypeDouble, alias: SVCLINEService Line DiameterSIZE, editable: true, nullable: true, defaultValue: null, modelName: SVCLINESIZE , Coded Values: [0: Unknown] , [0.75: 3/4"] , [1: 1"] , ...38 more... )
• SVCLINEMTL ( type: esriFieldTypeString, alias: Service Line Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SVCLINEMTL , Coded Values: [AC: Asbestos Cement] , [Brass: Brass] , [Carlon: Carlon] , ...13 more... )
• REGCOUNT ( type: esriFieldTypeSmallInteger, alias: Register Count, editable: true, nullable: true, defaultValue: null, modelName: REGCOUNT )
• BOXCOVER ( type: esriFieldTypeString, alias: Meter Box Cover Type, editable: true, nullable: true, length: 6, defaultValue: null, modelName: BOXCOVER , Coded Values: [1118: 11" X 18" - OldCastle Heavywall HDPE] , [1324: 13" X 24" - OldCastle Heavywall HDPE] , [1420: 14" X 20" - Fogtite No. 1] , ...24 more... )
• BOXMODEL ( type: esriFieldTypeString, alias: Meter Box Model Number, editable: true, nullable: true, length: 15, defaultValue: null, modelName: BOXMODEL , Coded Values: [B36: Brooks No. 36] , [B37: Brooks No. 37] , [C1015: Carson 1015] , ...21 more... )
• BOXSURFACE ( type: esriFieldTypeString, alias: Meter Box Surface, editable: true, nullable: true, length: 6, defaultValue: null, modelName: BOXSURFACE , Coded Values: [ASPH: Asphalt] , [CON: Concrete] , [GRVL: Gravel/Stone/Rock] , ...2 more... )
• SETINSTDATE ( type: esriFieldTypeDate, alias: Setter Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SETINSTDATE )
• SETTERSIZE ( type: esriFieldTypeDouble, alias: Setter Size, editable: true, nullable: true, defaultValue: null, modelName: SETTERSIZE , Coded Values: [0.625: 5/8"] , [0.75: 3/4"] , [1: 1"] , ...11 more... )
• SETTERTYPE ( type: esriFieldTypeString, alias: Setter Type, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SETTERTYPE , Coded Values: [AS: Angle Stop] , [H: Horizontal] , [HB: High Bypass] , ...7 more... )
• XMTINSTDATE ( type: esriFieldTypeDate, alias: Transmitter Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: XMTINSTDATE )
• XMTMFG ( type: esriFieldTypeString, alias: Transmitter Manufacturer, editable: true, nullable: true, length: 15, defaultValue: null, modelName: XMTMFG , Coded Values: [NA: Not-Applicable] , [Itron: Itron] )
• XMTMODEL ( type: esriFieldTypeString, alias: Transmitter Model, editable: true, nullable: true, length: 15, defaultValue: null, modelName: XMTMODEL , Coded Values: [OWR500W: OpenWay-Riva 500W] , [NA: Not-Applicable] )
• XMTSERIALNUM ( type: esriFieldTypeString, alias: Transmitter Serial Number, editable: true, nullable: true, length: 12, defaultValue: null, modelName: XMTSERIALNUM )
• XMTMTTYPE ( type: esriFieldTypeString, alias: Transmitter Mount Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: XMTMTTYPE , Coded Values: [RMAntenna: Rod-Mount-with-Antenna] , [XLid: Through-the-Lid] , [DMount: Direct-Mount] , ...4 more... )
• XMTSHIPDATE ( type: esriFieldTypeDate, alias: Transmitter Ship Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: XMTSHIPDATE )
• XMTPART ( type: esriFieldTypeString, alias: Transmitter Part Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: XMTPART )
• XMTPSERIAL ( type: esriFieldTypeString, alias: Transmitter Previous Serial Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: XMTPSERIAL )
• CISDATE ( type: esriFieldTypeDate, alias: Date to CIS, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CISDATE )
• CISCYCLE ( type: esriFieldTypeSmallInteger, alias: CIS Cycle Number, editable: true, nullable: true, defaultValue: null, modelName: CISCYCLE )
• CISROUTE ( type: esriFieldTypeSmallInteger, alias: CIS Route Number, editable: true, nullable: true, defaultValue: null, modelName: CISROUTE )
• METLOC ( type: esriFieldTypeSmallInteger, alias: Meter Location Code, editable: true, nullable: true, defaultValue: null, modelName: METLOC , Coded Values: [0: Location 00 - Outside Property Line] , [1: Location 1 - On Street] , [2: Location 2 - On Street] , ...28 more... )
• RESETTERFLAG ( type: esriFieldTypeString, alias: Resetter?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: RESETTERFLAG , Coded Values: [Yes: Yes] , [No: No] , [UNK: Unknown] )
• DOUBLESERVICEFLAG ( type: esriFieldTypeString, alias: Double Service?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: DOUBLESERVICEFLAG , Coded Values: [Yes: Yes] , [No: No] , [UNK: Unknown] )
• INDIVIDUAL_PRVFLAG ( type: esriFieldTypeString, alias: Individual PRV?, editable: true, nullable: true, length: 3, defaultValue: No, modelName: INDIVIDUAL_PRVFLAG , Coded Values: [Yes: Yes] , [No: No] , [UNK: Unknown] )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• CRITICAL ( type: esriFieldTypeSmallInteger, alias: Critical Customer, editable: true, nullable: true, defaultValue: null, modelName: CRITICAL , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeString, alias: Active Flag, editable: true, nullable: true, length: 3, defaultValue: Yes, modelName: ACTIVEFLAG , Coded Values: [Yes: Yes] , [No: No] , [UNK: Unknown] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 150, defaultValue: null, modelName: COMMENTS )
• PROJECTID ( type: esriFieldTypeString, alias: Project ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PROJECTID )
• GRIDID ( type: esriFieldTypeString, alias: Grid ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GRIDID )
• MAINTENANCEDIST ( type: esriFieldTypeString, alias: Maintenance District, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAINTENANCEDIST )
• PRESSUREZONE ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PRESSUREZONE , Coded Values: [BF220: BF220] , [BIP: Bellevue Issaquah Pipeline] , [BV400: BV400] , ...75 more... )
• SYSCREATEDATE ( type: esriFieldTypeDate, alias: Create Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SYSCREATEDATE )
• SYSCREATEUSER ( type: esriFieldTypeString, alias: Created By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SYSCREATEUSER )
• SYSCHANGEDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SYSCHANGEDATE )
• SYSCHANGEUSER ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SYSCHANGEUSER )
• ACADLAYER ( type: esriFieldTypeString, alias: AutoCAD Layer, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ACADLAYER )
• ACADBLOCK ( type: esriFieldTypeString, alias: AutoCAD Block Name, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ACADBLOCK )
• ACADHANDLE ( type: esriFieldTypeString, alias: AutoCAD Handle, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ACADHANDLE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• CHANGETYPE ( type: esriFieldTypeString, alias: Meter Change Type, editable: true, nullable: true, length: 4, defaultValue: null, modelName: CHANGETYPE , Coded Values: [MEKT: Meter Exchange –Keep Transmitter] , [MERT: Meter Exchange – Replace Transmitter] , [MEAT: Meter Exchange – Add Transmitter] , ...15 more... )

Templates:

• Name: wServiceConnections
  Description:
  Prototype:
  CHANGETYPE: null
  FACILITYID: null
  ACCOUNTID: null
  PROJECT_NAME: null
  MAXWORKORDERNUM: null
  STATUS: Operating
  OWNEDBY: BELLEVUE
  MAINTBY: BELLEVUE
  EASEMENTFLAG: No
  EASERECNO: null
  SERVICETYPE: Domestic
  SERVICEADDRESS: null
  INFOSOURCE: null
  INSTALLDATE: null
  METINSTDATE: null
  METERSIZE: null
  METSERIALNUM: null
  METERMANUFACTURER: null
  METMODEL: null
  DIALCOUNT: null
  METINITIALREAD: null
  TOUCHREADID: null
  PSERVICETYPE: null
  PMETINSTDATE: null
  PMETERSIZE: null
  PMETSERIAL: null
  PMETERMANUFACTURER: null
  PMETMODEL: null
  PMETFINALREAD: null
  SVCCONNINSTALLDATE: null
  SVCLINEINSTALL: null
  SVCCONNTYPE: null
  SVCLINESIZE: null
  SVCLINEMTL: null
  REGCOUNT: null
  BOXCOVER: null
  BOXMODEL: null
  BOXSURFACE: null
  SETINSTDATE: null
  SETTERSIZE: null
  SETTERTYPE: null
  XMTINSTDATE: null
  XMTMFG: null
  XMTMODEL: null
  XMTSERIALNUM: null
  XMTMTTYPE: null
  XMTSHIPDATE: null
  XMTPART: null
  XMTPSERIAL: null
  CISDATE: null
  CISCYCLE: null
  CISROUTE: null
  METLOC: null
  RESETTERFLAG: null
  DOUBLESERVICEFLAG: null
  INDIVIDUAL_PRVFLAG: No
  ROTATION: null
  CRITICAL: null
  ACTIVEFLAG: Yes
  ENABLED: 1
  COMMENTS: null
  PROJECTID: null
  GRIDID: null
  MAINTENANCEDIST: null
  PRESSUREZONE: null
  SYSCREATEDATE: null
  SYSCREATEUSER: null
  SYSCHANGEDATE: null
  SYSCHANGEUSER: null
  ACADLAYER: null
  ACADBLOCK: null
  ACADHANDLE: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata