View In:   ArcGIS Online Map Viewer

Name: Collections Sampling Station

Display Field: MAG_MANHOLE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 870773f1d91445b993b899ac18e33dc9

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: 6620628.809
YMin: 1957026.4699999988
XMax: 6657157.680999994
YMax: 1977748.9545000046
Spatial Reference: 102642  (2226)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [FACILITYID]
Use Coded Values: true
Symbol:
Color: [52, 52, 52, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 9
Font Family: Calibri
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 24000.0
Max. Scale: 0.0

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• MAG_MANHOLE ( type: esriFieldTypeString, alias: Manhole, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MAG_MANHOLE )
• MAG_STYPE_CD ( type: esriFieldTypeInteger, alias: Subtype, editable: true, nullable: true, defaultValue: 0, modelName: MAG_STYPE_CD )
• MAG_TYPE_CD ( type: esriFieldTypeInteger, alias: Manhole Type, editable: true, nullable: true, defaultValue: null, modelName: MAG_TYPE_CD , Coded Values: [99: OTHER] , [9: Plug] , [8: PVT] , ...9 more... )
• MAG_DEPTH ( type: esriFieldTypeDouble, alias: Manhole Depth (ft), editable: true, nullable: true, defaultValue: null, modelName: MAG_DEPTH )
• MAG_RIM_ELE ( type: esriFieldTypeDouble, alias: Rim Elevation, editable: true, nullable: true, defaultValue: null, modelName: MAG_RIM_ELE )
• MAG_STAT_CD ( type: esriFieldTypeInteger, alias: Status, editable: true, nullable: true, defaultValue: null, modelName: MAG_STAT_CD , Coded Values: [952: Parent Out of Service] , [4: Inactive] , [3: Buried] , ...3 more... )
• MAG_STRC_CD ( type: esriFieldTypeInteger, alias: Structure Type, editable: true, nullable: true, defaultValue: null, modelName: MAG_STRC_CD , Coded Values: [0: N/A] , [1: Standard] , [2: Clean Out] , ...6 more... )
• MAG_GPS ( type: esriFieldTypeSmallInteger, alias: GPS Flag, editable: true, nullable: true, defaultValue: 0, modelName: MAG_GPS , Coded Values: [0: No] , [1: Yes] )
• MAG_MHID ( type: esriFieldTypeInteger, alias: Unique Number, editable: true, nullable: true, defaultValue: null, modelName: MAG_MHID )
• MAG_DB ( type: esriFieldTypeSmallInteger, alias: In GBA Database?, editable: true, nullable: true, defaultValue: 0, modelName: MAG_DB , Coded Values: [0: False] , [1: True] , [-1: True] )
• LastModBy ( type: esriFieldTypeString, alias: Last Modified By, editable: true, nullable: true, length: 40, defaultValue: null, modelName: LastModBy )
• LastModDate ( type: esriFieldTypeDate, alias: Last Modified date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastModDate )
• LastSynDate ( type: esriFieldTypeDate, alias: Last Synchronized Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastSynDate )
• MAG_X ( type: esriFieldTypeDouble, alias: MAG_X, editable: true, nullable: true, defaultValue: null, modelName: MAG_X )
• MAG_Y ( type: esriFieldTypeDouble, alias: MAG_Y, editable: true, nullable: true, defaultValue: null, modelName: MAG_Y )
• DEPTH ( type: esriFieldTypeString, alias: DEPTH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEPTH )
• MAG_CREW ( type: esriFieldTypeString, alias: Rim to invert depth, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MAG_CREW )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• LucityAutoID ( type: esriFieldTypeInteger, alias: Link to Lucity, editable: true, nullable: true, defaultValue: null, modelName: LucityAutoID )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• MAG_USER5 ( type: esriFieldTypeString, alias: User 5, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAG_USER5 )
• InLucity ( type: esriFieldTypeSmallInteger, alias: In Lucity?, editable: true, nullable: true, defaultValue: 0, modelName: InLucity )
• MAG_USER1CD ( type: esriFieldTypeSmallInteger, alias: AREA, editable: true, nullable: true, defaultValue: null, modelName: MAG_USER1CD , Coded Values: [0: NF] , [1: AREA 1] , [2: AREA 2] , ...12 more... )
• MAG_USER6 ( type: esriFieldTypeSmallInteger, alias: Backyard?, editable: true, nullable: true, defaultValue: null, modelName: MAG_USER6 )
• MAG_LOCATIO ( type: esriFieldTypeString, alias: General Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: MAG_LOCATIO )
• MAG_PA_ID ( type: esriFieldTypeInteger, alias: Plant ID, editable: true, nullable: true, defaultValue: null, modelName: MAG_PA_ID )
• MAG_MANG_CD ( type: esriFieldTypeSmallInteger, alias: Managed by, editable: true, nullable: true, defaultValue: null, modelName: MAG_MANG_CD , Coded Values: [5: WWTP] )
• MAG_BR_CD ( type: esriFieldTypeString, alias: Default WO Cat, editable: true, nullable: true, length: 10, defaultValue: CMH, modelName: MAG_BR_CD )
• MAG_AZONE_CD ( type: esriFieldTypeString, alias: Alternate Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAG_AZONE_CD , Coded Values: [CHYDRO10: Sewer Hydro-cleaning Area 10] , [CHYDRO11: Sewer Hydro-cleaning Area 11] , [CHYDRO12: Sewer Hydro-cleaning Area 12] , ...11 more... )
• MAG_ADR_BDG ( type: esriFieldTypeString, alias: MAG_ADR_BDG, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAG_ADR_BDG )
• MAG_ADR_STR ( type: esriFieldTypeString, alias: MAG_ADR-STR, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MAG_ADR_STR )
• MAG_USER25 ( type: esriFieldTypeSmallInteger, alias: Sampling Point, editable: true, nullable: true, defaultValue: null, modelName: MAG_USER25 )
• MAG_USER26 ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAG_USER26 )
• MAG_USER27 ( type: esriFieldTypeString, alias: Sampling Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAG_USER27 )
• MAG_REAS_CD ( type: esriFieldTypeSmallInteger, alias: Reason, editable: true, nullable: true, defaultValue: null, modelName: MAG_REAS_CD , Coded Values: [10: COVID] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ESRIGNSS_POSITIONSOURCETYPE ( type: esriFieldTypeSmallInteger, alias: Position source type, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_POSITIONSOURCETYPE , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...2 more... )
• ESRIGNSS_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ESRIGNSS_RECEIVER )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_LATITUDE )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_LONGITUDE )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_ALTITUDE )
• ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_H_RMS )
• ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_V_RMS )
• ESRIGNSS_FIXDATETIME ( type: esriFieldTypeDate, alias: Fix Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ESRIGNSS_FIXDATETIME )
• ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_FIXTYPE , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• ESRIGNSS_CORRECTIONAGE ( type: esriFieldTypeDouble, alias: Correction Age, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_CORRECTIONAGE )
• ESRIGNSS_STATIONID ( type: esriFieldTypeSmallInteger, alias: Station ID, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_STATIONID , Range: [0, 1023] )
• ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Number of Satellites, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_NUMSATS , Range: [0, 99] )
• ESRIGNSS_PDOP ( type: esriFieldTypeDouble, alias: PDOP, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_PDOP )
• ESRIGNSS_HDOP ( type: esriFieldTypeDouble, alias: HDOP, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_HDOP )
• ESRIGNSS_VDOP ( type: esriFieldTypeDouble, alias: VDOP, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_VDOP )
• ESRIGNSS_DIRECTION ( type: esriFieldTypeDouble, alias: Direction of travel (°), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_DIRECTION )
• ESRIGNSS_SPEED ( type: esriFieldTypeDouble, alias: Speed (km/h), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_SPEED )
• ESRISNSR_AZIMUTH ( type: esriFieldTypeDouble, alias: Compass reading (°), editable: true, nullable: true, defaultValue: null, modelName: ESRISNSR_AZIMUTH )
• ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_H_RMS )
• ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_V_RMS )
• ESRIGNSS_AVG_POSITIONS ( type: esriFieldTypeSmallInteger, alias: Averaged Positions, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_POSITIONS )
• ESRIGNSS_H_STDDEV ( type: esriFieldTypeDouble, alias: Standard Deviation (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_H_STDDEV )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes )
• MAG_MATR_CD ( type: esriFieldTypeSmallInteger, alias: MAG_MATR_CD, editable: true, nullable: true, defaultValue: null, modelName: MAG_MATR_CD , Coded Values: [9: Armorock] , [8: PVC] , [7: Clay] , ...7 more... )

Templates:

• Name: SWNETMHG
  Description:
  Prototype:
  lucity.dbo.swnetmhg.mag_db: 0
  lucity.dbo.swnetmhg.mag_stype_cd: 0
  lucity.dbo.swnetmhg.mag_gps: 0
  Notes: null
  MAG_MANHOLE: null
  MAG_STYPE_CD: 0
  MAG_TYPE_CD: null
  MAG_DEPTH: null
  MAG_RIM_ELE: null
  MAG_STAT_CD: null
  MAG_STRC_CD: null
  MAG_GPS: 0
  MAG_MHID: null
  MAG_DB: 0
  LastModBy: null
  LastModDate: null
  LastSynDate: null
  MAG_X: null
  MAG_Y: null
  DEPTH: null
  MAG_CREW: null
  ESRIGNSS_H_STDDEV: null
  ESRIGNSS_AVG_POSITIONS: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  FACILITYID: null
  LucityAutoID: null
  Enabled: 1
  MAG_USER5: null
  InLucity: 0
  MAG_USER1CD: null
  MAG_USER6: null
  MAG_LOCATIO: null
  MAG_PA_ID: null
  MAG_MANG_CD: null
  MAG_BR_CD: CMH
  MAG_AZONE_CD: null
  MAG_ADR_BDG: null
  MAG_ADR_STR: null
  MAG_USER25: null
  MAG_USER26: null
  MAG_USER27: null
  MAG_REAS_CD: null
  MAG_MATR_CD: null
  ESRIGNSS_POSITIONSOURCETYPE: null
  ESRIGNSS_RECEIVER: null
  ESRIGNSS_LATITUDE: null
  ESRIGNSS_LONGITUDE: null
  ESRIGNSS_ALTITUDE: null
  ESRIGNSS_H_RMS: null
  ESRIGNSS_V_RMS: null
  ESRIGNSS_FIXDATETIME: null
  ESRIGNSS_FIXTYPE: null
  ESRIGNSS_CORRECTIONAGE: null
  ESRIGNSS_STATIONID: null
  ESRIGNSS_NUMSATS: null
  ESRIGNSS_PDOP: null
  ESRIGNSS_HDOP: null
  ESRIGNSS_VDOP: null
  ESRIGNSS_DIRECTION: null
  ESRIGNSS_SPEED: null
  ESRISNSR_AZIMUTH: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata