Name: tbl_Surveys

Display Field: SurveyID

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SurveyID (type: esriFieldTypeInteger, alias: SurveyID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SurveyDate (type: esriFieldTypeDate, alias: SurveyDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SiteID (type: esriFieldTypeInteger, alias: SiteID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Start_Time (type: esriFieldTypeDate, alias: Start_Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• End_Time (type: esriFieldTypeDate, alias: End_Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CastSurveyors (type: esriFieldTypeString, alias: CastSurveyors, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SurveyProtocol (type: esriFieldTypeString, alias: SurveyProtocol, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SurveyorFieldnote (type: esriFieldTypeString, alias: SurveyorFieldnote, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Project (type: esriFieldTypeString, alias: Project, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• TotalAreaSQM (type: esriFieldTypeString, alias: TotalAreaSQM, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• PolygonCount (type: esriFieldTypeInteger, alias: PolygonCount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GeoDiv (type: esriFieldTypeString, alias: GeoDiv, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• CastSurveyNotes (type: esriFieldTypeString, alias: CastSurveyNotes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• CastFloraNotes (type: esriFieldTypeString, alias: CastFloraNotes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• CastFaunaNotes (type: esriFieldTypeString, alias: CastFaunaNotes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• NorthBase (type: esriFieldTypeString, alias: NorthBase, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• CastGeoNotes (type: esriFieldTypeString, alias: CastGeoNotes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• WQFieldDevices (type: esriFieldTypeString, alias: WQFieldDevices, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• WQCollectionComments (type: esriFieldTypeString, alias: WQCollectionComments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CastWQResultsNotes (type: esriFieldTypeString, alias: CastWQResultsNotes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• PolygonData (type: esriFieldTypeInteger, alias: PolygonData, SQL Type: sqlTypeOther, nullable: false, editable: true)
• SoilData (type: esriFieldTypeInteger, alias: SoilData, SQL Type: sqlTypeOther, nullable: false, editable: true)
• GeologyData (type: esriFieldTypeInteger, alias: GeologyData, SQL Type: sqlTypeOther, nullable: false, editable: true)
• H20QtyData (type: esriFieldTypeInteger, alias: H20QtyData, SQL Type: sqlTypeOther, nullable: false, editable: true)
• H20QualData (type: esriFieldTypeInteger, alias: H20QualData, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ImageData (type: esriFieldTypeInteger, alias: ImageData, SQL Type: sqlTypeOther, nullable: false, editable: true)
• FloraData (type: esriFieldTypeInteger, alias: FloraData, SQL Type: sqlTypeOther, nullable: false, editable: true)
• InvertData (type: esriFieldTypeInteger, alias: InvertData, SQL Type: sqlTypeOther, nullable: false, editable: true)
• VertData (type: esriFieldTypeInteger, alias: VertData, SQL Type: sqlTypeOther, nullable: false, editable: true)
• SEAPData (type: esriFieldTypeInteger, alias: SEAPData, SQL Type: sqlTypeOther, nullable: false, editable: true)
• CulturalData (type: esriFieldTypeInteger, alias: CulturalData, SQL Type: sqlTypeOther, nullable: false, editable: true)
• EOD (type: esriFieldTypeInteger, alias: EOD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LoginAddedSurvey (type: esriFieldTypeString, alias: LoginAddedSurvey, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LoginDateAddedSurvey (type: esriFieldTypeDate, alias: LoginDateAddedSurvey, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LoginChangedSurvey (type: esriFieldTypeString, alias: LoginChangedSurvey, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LoginChangedDateSurvey (type: esriFieldTypeDate, alias: LoginChangedDateSurvey, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SurveyFlag (type: esriFieldTypeInteger, alias: SurveyFlag, SQL Type: sqlTypeOther, nullable: false, editable: true)
• QAQCDate (type: esriFieldTypeDate, alias: QAQCDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• QAQCBy (type: esriFieldTypeString, alias: QAQCBy, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• CastQAQCComments (type: esriFieldTypeString, alias: CastQAQCComments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• CastSurveyReportHyperlink (type: esriFieldTypeString, alias: CastSurveyReportHyperlink, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• CastImageComments (type: esriFieldTypeString, alias: CastImageComments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• initialtimestamp (type: esriFieldTypeDate, alias: initialtimestamp, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Weather (type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• SfcWaterOccur (type: esriFieldTypeString, alias: SfcWaterOccur, SQL Type: sqlTypeOther, length: 45, nullable: true, editable: true)
• Area_Method (type: esriFieldTypeString, alias: Area_Method, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

Name: tbl_Surveys
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• gde_surveys (46) -- Related To: gde_surveys (7)
• tbl_WQData (99) -- Related To: tbl_WQData (53)
• tbl_flow (56) -- Related To: tbl_flow (22)
• tbl_wqlocation (100) -- Related To: tbl_wqlocation (55)
• tbl_sadaprotocols (93) -- Related To: tbl_sadaprotocols (39)
• gdelu_areamethod (49) -- Related To: gdelu_areamethod (9)
• tbl_qtyvolume (75) -- Related To: tbl_qtyvolume (32)
• tbl_HydroQuality (57) -- Related To: tbl_HydroQuality (23)
• tbl_images (58) -- Related To: tbl_images (24)
• tbl_SEAP_Scores (94) -- Related To: tbl_SEAP_Scores (40)
• tlu_weather (101) -- Related To: tlu_weather (149)
• tlu_surveyprotocol (102) -- Related To: tlu_surveyprotocol (141)
• tbl_InvertSampling (62) -- Related To: tbl_InvertSampling (26)
• tbl_seapscore (96) -- Related To: tbl_seapscore (42)
• tbl_project (74) -- Related To: tbl_project (31)
• tbl_seapsummary (97) -- Related To: tbl_seapsummary (43)
• tbl_VertSurvey (103) -- Related To: tbl_VertSurvey (52)
• tbl_PolygonSurvey (73) -- Related To: tbl_PolygonSurvey (30)
• tlu_sfcwateroccur (104) -- Related To: tlu_sfcwateroccur (131)
• tbl_seapcultscores (95) -- Related To: tbl_seapcultscores (41)
• tbl_reports (80) -- Related To: tbl_reports (38)
• World_Springs (0) -- Related To: Spring Reported (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/2/2023 1:46:49 AM

Schema Last Edit Date: 3/2/2023 1:46:49 AM

Data Last Edit Date: 3/2/2023 1:46:49 AM

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