Name: SurveyQ

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

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:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• Waterway (type: esriFieldTypeString, alias: Waterway Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Acorn Woman Lakes: Acorn Woman Lakes], [Agate Lake: Agate Lake], [Agency Lake: Agency Lake], ... 360 more ...)
• WaterwayOther (type: esriFieldTypeString, alias: Other Waterway Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• T_Month (type: esriFieldTypeString, alias: Month, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [January: (01) - January], [February: (02) - February], [March: (03) - March], ... 9 more ...)
• T_Days (type: esriFieldTypeInteger, alias: Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BoatType (type: esriFieldTypeString, alias: Boat Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [open motor: open motor (tow, runabout, fishing)], [paddlecraft: paddlecraft (kayak, canoe, SUP)], [drift boat: drift boat (row)], ... 9 more ...)
• MotorType (type: esriFieldTypeString, alias: Motor Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [small gas: internal combustion motor with less than 10hp], [gas: internal combustion motor with 10hp or more], [electric: electric motor only], ... 1 more ...)
• BoatOwn (type: esriFieldTypeString, alias: Boat Ownership, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [owner: boat I own], [friend: friend or family member's boat], [rental: boat I rented], ... 1 more ...)
• Transport (type: esriFieldTypeString, alias: Transportation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [trailer: trailer / towed], [roof rack: roof rack / truck bed], [pack: inflatable / pack], ... 3 more ...)
• Activity (type: esriFieldTypeString, alias: Activity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [cruising: overnight cruising (motoring) or sailing], [day trip: day cruising (motoring), sightseeing, or sailing], [flatwater: flat-water rowing or paddling], ... 5 more ...)
• ParticipantsAdult (type: esriFieldTypeInteger, alias: Adults, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ParticipantsKids (type: esriFieldTypeInteger, alias: Kids, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ParticipantsTotal (type: esriFieldTypeInteger, alias: Total Participants, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PFD (type: esriFieldTypeString, alias: Life Jackets, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [always: always], [sometimes: sometimes], [never: never])
• BoatComment (type: esriFieldTypeString, alias: Additional Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, 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)
• wT_Days (type: esriFieldTypeDouble, alias: Weighted Use Days, SQL Type: sqlTypeOther, nullable: true, editable: true)

Relationships:

• Boating_Survey_SurveyQ (1) -- Related To: Boating_Survey (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/29/2024 8:30:01 PM

Schema Last Edit Date: 1/12/2024 5:49:28 PM

Data Last Edit Date: 2/29/2024 8:30:01 PM

Supported Operations:   Add Features   Apply Edits   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat