Name: CBI_Inspection_Shift_Join_2025

Display Field:

Type: Table

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• AGENCY2 (type: esriFieldTypeString, alias: AGENCY, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• AGENCY_ID2 (type: esriFieldTypeInteger, alias: AGENCY_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSPECTOR_ID2 (type: esriFieldTypeInteger, alias: INSPECTOR_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SITE_ID2 (type: esriFieldTypeInteger, alias: SITE_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SITE_NAME2 (type: esriFieldTypeString, alias: SITE_NAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• INSP_DATE1 (type: esriFieldTypeDate, alias: INSP_DATE1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INSPN_TIME (type: esriFieldTypeString, alias: INSPN_TIME, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DIR_IN_OUT (type: esriFieldTypeString, alias: DIR_IN_OUT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [ENTERING: ENTERING], [LEAVING: LEAVING])
• MOTORIZED (type: esriFieldTypeString, alias: MOTORIZED, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• NUM_NM_BOATS (type: esriFieldTypeInteger, alias: NUM_NM_BOATS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STATE_REG (type: esriFieldTypeString, alias: REG_STATE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [ME: ME - MAINE], [MA: MS - MASSACHUSETTS], [NH: NH - NEW HAMPSHIRE], ... 73 more ...)
• REG_NUMBER (type: esriFieldTypeString, alias: REG_NUMBER, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• STICKER (type: esriFieldTypeString, alias: STICKER, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• LAST_WATER1 (type: esriFieldTypeString, alias: LAST_WATER1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [SAME: SAME AS CURRENT WATERBODY], [DIFF: DIFFERENT WATERBODY IN MAINE OR OUT OF STATE (CHOOSE FROM LIST BELOW)], [OTHER: UNKNOWN / FIRST TIME / DECLINE TO ANSWER])
• LAST_WATER (type: esriFieldTypeString, alias: LAST_WATER, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Other: Other/New (enter name on next line if known)], [ATLANTIC OCEAN: ATLANTIC OCEAN / SALT WATER], [Adams Pond: Adams Pond/Rock Haven Lake, ME], ... 166 more ...)
• LAST_WATER_NEW (type: esriFieldTypeString, alias: LAST_WATER_NEW, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LAST_WATERBODY (type: esriFieldTypeString, alias: LAST_WATERBODY, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LAST_TOWN (type: esriFieldTypeString, alias: LAST_TOWN, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LAST_STATE (type: esriFieldTypeString, alias: LAST_STATE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [ME: ME - MAINE], [MA: MA - MASSACHUSETTS], [NH: NH - NEW HAMPSHIRE], ... 72 more ...)
• WATER_REGION_LAST_ID (type: esriFieldTypeInteger, alias: WATER_REGION_LAST_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MIDAS_LAST (type: esriFieldTypeString, alias: MIDAS_LAST, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LAST_LAT (type: esriFieldTypeDouble, alias: LAST_LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAST_LON (type: esriFieldTypeDouble, alias: LAST_LON, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PLANT_YN (type: esriFieldTypeString, alias: PLANT_YN, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• PLANT_LOCATION (type: esriFieldTypeString, alias: PLANT_LOCATION, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• PLANT_LOC_OTHER (type: esriFieldTypeString, alias: PLANT_LOC_OTHER, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• INVADER_YN (type: esriFieldTypeString, alias: INVADER_YN, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes (verified by expert)], [N: No], [UNK: I don't know (submit for identification)])
• ID_EXPERT_NAME (type: esriFieldTypeString, alias: ID_EXPERT_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Lake Assc.: Lake Assc.], [LSM: LSM], [DEP: DEP], ... 1 more ...)
• OTHER_EXPERT (type: esriFieldTypeString, alias: OTHER_EXPERT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• INSPCOUNT (type: esriFieldTypeSmallInteger, alias: INSPCOUNT, SQL Type: sqlTypeOther, 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)
• globalid_1745606204261 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• DATE1 (type: esriFieldTypeDate, alias: DATE1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VISIT_DATE (type: esriFieldTypeString, alias: VISIT_DATE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DAY_OF_WEEK (type: esriFieldTypeString, alias: DAY_OF_WEEK, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AGENCY_ID (type: esriFieldTypeString, alias: AGENCY_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [096: 30 Mile River Watershed Association], [128: 7 Lakes Alliance], [072: Alamoosook Lake Association (ALA)], ... 62 more ...)
• AGENCY_DESC (type: esriFieldTypeString, alias: AGENCY_DESC, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• SITE_NAME (type: esriFieldTypeString, alias: SITE_NAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• SITE_ID (type: esriFieldTypeInteger, alias: SITE_ID, SQL Type: sqlTypeOther, 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)
• TOWN (type: esriFieldTypeString, alias: TOWN, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WATER_REGION_ID (type: esriFieldTypeInteger, alias: WATER_REGION_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WATERBODY (type: esriFieldTypeString, alias: WATERBODY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MIDAS (type: esriFieldTypeString, alias: MIDAS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• NAME_FL (type: esriFieldTypeString, alias: NAME_FL, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FNAME (type: esriFieldTypeString, alias: FNAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LNAME (type: esriFieldTypeString, alias: LNAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• INSPECTOR_ID (type: esriFieldTypeInteger, alias: INSPECTOR_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PAY_VOL (type: esriFieldTypeString, alias: PAY_VOL, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [V: Volunteer], [P: Paid])
• SHIFT_START (type: esriFieldTypeString, alias: SHIFT_START, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• TRAILERS (type: esriFieldTypeSmallInteger, alias: TRAILERS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSPECTIONS (type: esriFieldTypeString, alias: INSPECTIONS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• SHIFT_END (type: esriFieldTypeString, alias: SHIFT_END, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SHIFT_LENGTH (type: esriFieldTypeDouble, alias: SHIFT_LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_NM (type: esriFieldTypeInteger, alias: TOTAL_NM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_M (type: esriFieldTypeInteger, alias: TOTAL_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTALINSP (type: esriFieldTypeInteger, alias: TOTALINSP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NUMINVASIVE (type: esriFieldTypeInteger, alias: NUMINVASIVE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REFUSALS (type: esriFieldTypeInteger, alias: REFUSALS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• EMAIL (type: esriFieldTypeString, alias: EMAIL, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• COORDEMAIL (type: esriFieldTypeString, alias: COORDEMAIL, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Version (type: esriFieldTypeString, alias: VERSION, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CreationDate_1745606204261 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1745606204261 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1745606204261 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1745606204261 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/3/2026 4:58:03 PM

Schema Last Edit Date: 4/25/2025 5:19:38 PM

Data Last Edit Date: 4/25/2025 5:19:10 PM

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