Name: Water Service Connections/Meters

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 9aa8d21d81a54a8aa9d4d431c187f940

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 6620617.92916492
YMin: 1956994.7320355102
XMax: 6731042.1358095035
YMax: 1986848.72055576
Spatial Reference: 102642  (2226)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, length: 20 )
• ACCOUNTID ( type: esriFieldTypeString, alias: Account Number, length: 30 )
• METSERVICE ( type: esriFieldTypeString, alias: Metered Service, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• SERVICETYPE ( type: esriFieldTypeSmallInteger, alias: Service Type , Coded Values: [6: VACANT PARCEL] , [5: CONDO COMMON AREA (LBV)] , [3: PARKS - CITY OF DAVIS] , ...3 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, length: 200 )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation )
• LOCATIONID ( type: esriFieldTypeString, alias: Location Identifier, length: 20 )
• CRITICAL ( type: esriFieldTypeSmallInteger, alias: CriticalCustomer , Coded Values: [0: No] , [1: Yes] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag , Coded Values: [0: No] , [1: Yes] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [2: UC Davis] , [1: City of Davis] , [0: N/A] )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, length: 8 )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SCG_PROPTAG ( type: esriFieldTypeString, alias: Property ID Tag, length: 20 )
• SCG_USER24 ( type: esriFieldTypeString, alias: MTU, length: 30 )
• SCG_USER23 ( type: esriFieldTypeString, alias: Meter Size, length: 30 )
• SCG_USER21 ( type: esriFieldTypeString, alias: Meter No, length: 30 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• LucityAutoID ( type: esriFieldTypeInteger, alias: Link to Lucity )
• InLucity ( type: esriFieldTypeSmallInteger, alias: In Lucity? )
• LastModBy ( type: esriFieldTypeString, alias: Last Modified By, length: 40 )
• LastModDate ( type: esriFieldTypeDate, alias: Last Modified date, length: 8 )
• LastSynDate ( type: esriFieldTypeDate, alias: Last Synchronized Date, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SCG_ADR_DIR ( type: esriFieldTypeString, alias: SCG_ADR_DIR, length: 50 )
• SCG_MT_LOC1 ( type: esriFieldTypeString, alias: Meter Loc 1, length: 100 )
• SCG_ADR_STR ( type: esriFieldTypeString, alias: Street Name, length: 50 )
• SCG_ADR_BDG ( type: esriFieldTypeInteger, alias: Building )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y )
• Duplicate ( type: esriFieldTypeSmallInteger, alias: Duplicate SC_ID/Link to Lucity? )
• SERVICETYPE1 ( type: esriFieldTypeString, alias: SERVICETYPE1, length: 50 , Coded Values: [Domestic: Domestic] , [Commercial: Commercial] , [Industrial: Industrial] , ...3 more... )
• AsBuilt_Status ( type: esriFieldTypeSmallInteger, alias: AsBuilt_Status , Coded Values: [2: Under Review] , [3: Accepted] , [4: Planned] , ...1 more... )
• ESRIGNSS_POSITIONSOURCETYPE ( type: esriFieldTypeSmallInteger, alias: Position source type , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...2 more... )
• ESRIGNSS_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, length: 50 )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude )
• ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m) )
• ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m) )
• ESRIGNSS_FIXDATETIME ( type: esriFieldTypeDate, alias: Fix Time, length: 8 )
• ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• ESRIGNSS_CORRECTIONAGE ( type: esriFieldTypeDouble, alias: Correction Age )
• ESRIGNSS_STATIONID ( type: esriFieldTypeSmallInteger, alias: Station ID , Range: [0, 1023] )
• ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Number of Satellites , Range: [0, 99] )
• ESRIGNSS_PDOP ( type: esriFieldTypeDouble, alias: PDOP )
• ESRIGNSS_HDOP ( type: esriFieldTypeDouble, alias: HDOP )
• ESRIGNSS_VDOP ( type: esriFieldTypeDouble, alias: VDOP )
• ESRIGNSS_DIRECTION ( type: esriFieldTypeDouble, alias: Direction of travel (°) )
• ESRIGNSS_SPEED ( type: esriFieldTypeDouble, alias: Speed (km/h) )
• ESRISNSR_AZIMUTH ( type: esriFieldTypeDouble, alias: Compass reading (°) )
• ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m) )
• ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m) )
• ESRIGNSS_AVG_POSITIONS ( type: esriFieldTypeSmallInteger, alias: Averaged Positions )
• ESRIGNSS_H_STDDEV ( type: esriFieldTypeDouble, alias: Standard Deviation (m) )
• GPS ( type: esriFieldTypeSmallInteger, alias: GPS Flag , Coded Values: [0: No] , [1: Yes] )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• SCG_UTIL_CD ( type: esriFieldTypeSmallInteger, alias: SC_UTIL_CD , Coded Values: [7: Galvanized] , [6: Brass] , [5: Asbestos Cement] , ...6 more... )
• SCG_CONS_CD ( type: esriFieldTypeSmallInteger, alias: SC_CONS_CD , Coded Values: [8: Ductile Iron] , [7: Galvanized] , [6: Brass] , ...6 more... )
• metersize_normalized ( type: esriFieldTypeString, alias: metersize_normalized, length: 255 )
• SCG_USER16CD ( type: esriFieldTypeSmallInteger, alias: SC_USER16CD , Coded Values: [2: WI (Irrigation)] , [1: WA (Water)] )
• ZIP ( type: esriFieldTypeString, alias: ZIP, length: 8 )
• YEAR_BUILT ( type: esriFieldTypeString, alias: YEAR_BUILT, length: 255 )
• ESTIMATED_YEAR_BUILT ( type: esriFieldTypeString, alias: Year Built, length: 255 )
• SCG_USER25 ( type: esriFieldTypeString, alias: SCG_USER25, length: 255 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata