All Layers and Tables (CBI_Inspection_Shift_Join

Layers:

Tables:

CBI_Inspection_Shift_Join_2025 (0)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: