Name: VRMP_Join

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"VRMP Field Data Sheet-Short Form","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• ORGANIZATION2 (type: esriFieldTypeString, alias: ORGANIZATION2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• SAMPLE_DATE2 (type: esriFieldTypeString, alias: SAMPLE_DATE2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WATERBODY (type: esriFieldTypeString, alias: WATERBODY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WATERBODY_NEW (type: esriFieldTypeString, alias: WATERBODY_NEW, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SITE_NAME_ID (type: esriFieldTypeString, alias: SITE_NAME_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SITE_ID_NEW (type: esriFieldTypeString, alias: SITE_ID_NEW, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NEW_SITE_LAT (type: esriFieldTypeDouble, alias: NEW_SITE_LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NEW_SITE_LON (type: esriFieldTypeDouble, alias: NEW_SITE_LON, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SITE_ID (type: esriFieldTypeString, alias: SITE_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SITE_NAME (type: esriFieldTypeString, alias: SITE_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PROJECT_SITE (type: esriFieldTypeString, alias: PROJECT_SITE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SAMPLE_POINT_NAME (type: esriFieldTypeString, alias: SAMPLE_POINT_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SAMPLE_ID (type: esriFieldTypeString, alias: SAMPLE_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• EGAD_SEQ (type: esriFieldTypeString, alias: EGAD_SEQ, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SITE_TIDAL (type: esriFieldTypeString, alias: SITE_TIDAL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ORG_SITE_ID (type: esriFieldTypeString, alias: ORG_SITE_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SAMPLES (type: esriFieldTypeString, alias: Did you take meter readings and/or grab samples?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Grab: Grab Sample Only], [Meter: Meter Readings Only (DO and/or SPC)], [Both: Grab Sample and Meter Readings])
• FIELD_DUP (type: esriFieldTypeString, alias: FIELD_DUP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [METER: METER READING], [DUP_METER: DUPLICATE METER READING FOR QA/QC])
• QC_TYPE (type: esriFieldTypeString, alias: QC_TYPE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• SAMPLE_TIME1 (type: esriFieldTypeTimeOnly, alias: Time Sampled, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SAMPLE_TIME (type: esriFieldTypeString, alias: SAMPLE_TIME, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• SAMPLE_LOCATION (type: esriFieldTypeString, alias: SAMPLE_LOCATION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [WADING: 1) WADING], [BRIDGE: 2) BRIDGE], [BOAT: 3) BOAT], ... 3 more ...)
• VERTICAL_DEPTH (type: esriFieldTypeString, alias: VERTICAL_DEPTH, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Non-wadeable: MID-DEPTH: 1) Non-wadeable: MID-DEPTH], [Non-wadeable: 3 FT BELOW SURFACE: 2) Non-wadeable: 3 FT BELOW SURFACE], [Wadeable: MID-DEPTH: 3) Wadeable: MID-DEPTH], ... 1 more ...)
• DO_METHOD (type: esriFieldTypeString, alias: DO_METHOD, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [EXTENSION POLE & PROBE: 1) EXTENSION POLE & PROBE], [PROBE ONLY (DIRECT PROBE): 5) PROBE ONLY (DIRECT PROBE)], [NOT MEASURED: 6) NOT MEASURED])
• WATER_TEMPERATURE (type: esriFieldTypeString, alias: WATER_TEMPERATURE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DO_MGL (type: esriFieldTypeDouble, alias: DO_MGL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DO_SAT (type: esriFieldTypeDouble, alias: DO_SAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPC (type: esriFieldTypeDouble, alias: SPC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SALINITY (type: esriFieldTypeDouble, alias: SALINITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GRAB_TYPE (type: esriFieldTypeString, alias: LAB_YN, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [LAB: GRAB SAMPLE], [DUP_LAB: DUPLICATE GRAB SAMPLE FOR QA/QC])
• LAB_QC_TYPE (type: esriFieldTypeString, alias: LAB_QC_TYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SAMPLE_CONTAINER (type: esriFieldTypeString, alias: SAMPLE_CONTAINER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [PLASTIC: 1) PLASTIC], [GLASS: 2) GLASS], [WHIRLPACK: 2) WHIRLPACK])
• BACTERIA (type: esriFieldTypeString, alias: BACTERIA, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [E. COLI BACTERIA: E. COLI], [ENTEROCOCCI: ENTEROCOCCI], [OTHER ANALYTES: OTHER ANALYTES])
• OTHER_ANALYSIS (type: esriFieldTypeString, alias: OTHER_ANALYSIS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BACTERIA_LAB (type: esriFieldTypeString, alias: BACTERIA_LAB, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AMSD: ANSON-MADISON SANITARY DISTRICT], [DMC: DARLING MARINE CENTER-MARINE WATER QUALITY LAB], [EMRO: MEDEP (EASTERN MAINE REGIONAL OFFICE)], ... 11 more ...)
• BACTERIA_METHOD (type: esriFieldTypeString, alias: BACTERIA_METHOD, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [SM9223B(COLILERT_QUANTI)_2004: Colilert/Quanti tray (SM9223B)], [D6503-99: Enterolert (ASTM D6503-99)], [IDX: IDEXX], ... 1 more ...)
• BACTERIA_NUM (type: esriFieldTypeDouble, alias: BACTERIA_NUM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BACTERIA_MODIFIER (type: esriFieldTypeString, alias: BACTERIA_MODIFIER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [>: > (greater than)], [<: < (less than)])
• BACTERIA_UNITS (type: esriFieldTypeString, alias: BACTERIA_UNITS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [MPN/100ML: MPN/100ML], [CFU/100ML: CFU/100ML])
• BACTERIA_RESULT (type: esriFieldTypeString, alias: BACTERIA_RESULT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• QAQC_VRMP (type: esriFieldTypeString, alias: QAQC_VRMP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• QAQCDate (type: esriFieldTypeString, alias: QAQCDate, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• QAQCNotes (type: esriFieldTypeString, alias: QAQCNotes, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• LAT (type: esriFieldTypeDouble, alias: LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONG (type: esriFieldTypeDouble, alias: LONG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAP_LAT (type: esriFieldTypeDouble, alias: MAP_LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAP_LON (type: esriFieldTypeDouble, alias: MAP_LON, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INCORRECT_LOC (type: esriFieldTypeString, alias: INCORRECT_LOC, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SITENUM (type: esriFieldTypeSmallInteger, alias: SITENUM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SITECONCAT (type: esriFieldTypeString, alias: SITECONCAT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• SAMPLE_YEAR2 (type: esriFieldTypeString, alias: SAMPLE_YEAR2, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• WATER_TEMP (type: esriFieldTypeDouble, alias: WATER_TEMP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SAMPLE_DATE3 (type: esriFieldTypeDate, alias: SAMPLE_DATE3, SQL Type: sqlTypeOther, length: 0, nullable: true, editable: true)
• globalid_1727373251438 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• ORGANIZATION (type: esriFieldTypeString, alias: ORGANIZATION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [ANDROSCOGGIN RIVER WATERSHED COUNCIL: ANDROSCOGGIN RIVER WATERSHED COUNCIL], [BIDDEFORD CONSERVATION COMMISSION: BIDDEFORD CONSERVATION COMMISSION], [FRIENDS OF MERRYMEETING BAY: FRIENDS OF MERRYMEETING BAY], ... 8 more ...)
• SAMPLE_DATE (type: esriFieldTypeString, alias: SAMPLE_DATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SAMPLE_DATE_mdy (type: esriFieldTypeString, alias: SAMPLE_DATE_mdy, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• SAMPLE_YEAR (type: esriFieldTypeString, alias: SAMPLE_YEAR, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• SAMPLED_BY (type: esriFieldTypeString, alias: SAMPLED_BY, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DO_METER_TYPE (type: esriFieldTypeString, alias: DO_METER_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [None: No DO Meter used], [YSI 85: YSI 85], [YSI Pro2030: YSI Pro2030], ... 4 more ...)
• DO_METER_OTHER (type: esriFieldTypeString, alias: DO_METER_OTHER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DO_METER_NUM (type: esriFieldTypeString, alias: DO_METER_NUM, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TIME_TO_CAL (type: esriFieldTypeDouble, alias: TIME_TO_CAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DO_READING (type: esriFieldTypeDouble, alias: DO_READING, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ZERO_SAT_DO (type: esriFieldTypeString, alias: ZERO_SAT_DO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No/Not applicable])
• ZERO_SAT_DO_DATE (type: esriFieldTypeString, alias: ZERO_SAT_DO_DATE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DO_KIT_READING (type: esriFieldTypeDouble, alias: DO_KIT_READING, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPC_METER_TYPE (type: esriFieldTypeString, alias: SPC_METER_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [None: No SPC meter used], [Combined with DO meter: Combined with DO meter], [YSI EC300: YSI EC300], ... 2 more ...)
• SPC_METER_OTHER (type: esriFieldTypeString, alias: SPC_METER_OTHER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SPC_METER_NUM (type: esriFieldTypeString, alias: SPC_METER_NUM, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SITELIST (type: esriFieldTypeString, alias: SITELIST, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• FIELD_NOTES (type: esriFieldTypeString, alias: FIELD_NOTES, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• PHOTO1_DESC (type: esriFieldTypeString, alias: PHOTO1_DESC, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• PHOTO2_DESC (type: esriFieldTypeString, alias: PHOTO2_DESC, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• EMAIL1 (type: esriFieldTypeString, alias: EMAIL1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• EMAIL2 (type: esriFieldTypeString, alias: EMAIL2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CreationDate_1727373251438 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1727373251438 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1727373251438 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1727373251438 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• SAMPLE_DATE1 (type: esriFieldTypeDate, alias: SAMPLE_DATE1, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/12/2025 6:28:11 PM

Schema Last Edit Date: 9/24/2024 1:15:16 PM

Data Last Edit Date: 9/24/2024 1:15:16 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat