Name: src_lethbridge_tbl

Display Field: AGGREG_FIELD_NAME

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

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)
• CROP_YEAR (type: esriFieldTypeInteger, alias: Crop Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DFRP_NUMBER (type: esriFieldTypeInteger, alias: Farm Location, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AGGREG_FIELD_NAME (type: esriFieldTypeString, alias: Aggregate Field Name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• MULTI_FIELD_NAME (type: esriFieldTypeString, alias: Field Listings, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• MULTI_PLOT_IDENTIFIER (type: esriFieldTypeString, alias: Sample Plots, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• APPLICATION_TYPE (type: esriFieldTypeString, alias: Application Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• TASK_APPROVAL (type: esriFieldTypeInteger, alias: Task Approval, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Approved], [2: Rejected], [3: Needs Approval])
• PEST_APPLICATION_NUMBER (type: esriFieldTypeDouble, alias: Pesticide Application Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PEST_TO_BE_CONTROLLED (type: esriFieldTypeString, alias: Pest To Be Controlled, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_NOZZLE_TYPE (type: esriFieldTypeString, alias: Pesticide Nozzle Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_SPRAY_TYPE_DESC (type: esriFieldTypeString, alias: Pesticide Special Instructions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PEST_CONTROL_TYPE (type: esriFieldTypeString, alias: Pest Control Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_WATER_VOL (type: esriFieldTypeDouble, alias: Pesticide Water Volume, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PEST_SPRAY_TYPE_1 (type: esriFieldTypeString, alias: Pesticide 1 Spray Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_PRODUCT_1 (type: esriFieldTypeString, alias: Pesticide 1 Product, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_ACTIVE_MATERIAL_1 (type: esriFieldTypeString, alias: Pesticide 1 Active Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_PCP_REGISTRATION_1 (type: esriFieldTypeString, alias: Pesticide 1 PCP Registration Number, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_GROUP_1 (type: esriFieldTypeString, alias: Pesticide 1 Mode of Action, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_APPLICATION_RATE_1 (type: esriFieldTypeDouble, alias: Pesticide 1 Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PEST_APPLICATION_UNITS_1 (type: esriFieldTypeString, alias: Pesticide 1 Rate Units, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_SPRAY_TYPE_2 (type: esriFieldTypeString, alias: Pesticide 2 Spray Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_PRODUCT_2 (type: esriFieldTypeString, alias: Pesticide 2 Product, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_ACTIVE_MATERIAL_2 (type: esriFieldTypeString, alias: Pesticide 2 Active Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_PCP_REGISTRATION_2 (type: esriFieldTypeString, alias: Pesticide 2 PCP Registration Number, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_GROUP_2 (type: esriFieldTypeString, alias: Pesticide 2 Mode of Action, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_APPLICATION_RATE_2 (type: esriFieldTypeDouble, alias: Pesticide 2 Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PEST_APPLICATION_UNITS_2 (type: esriFieldTypeString, alias: Pesticide 2 Rate Units, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PEST_SPRAY_TYPE_3 (type: esriFieldTypeString, alias: Pesticide 3 Spray Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_PRODUCT_3 (type: esriFieldTypeString, alias: Pesticide 3 Product, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_ACTIVE_MATERIAL_3 (type: esriFieldTypeString, alias: Pesticide 3 Active Material, SQL Type: sqlTypeOther, length: 259, nullable: true, editable: true)
• PEST_PCP_REGISTRATION_3 (type: esriFieldTypeString, alias: Pesticide 3 PCP Registration Number, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_GROUP_3 (type: esriFieldTypeString, alias: Pesticide 3 Mode of Action, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_APPLICATION_RATE_3 (type: esriFieldTypeDouble, alias: Pesticide 3 Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PEST_APPLICATION_UNITS_3 (type: esriFieldTypeString, alias: Pesticide 3 Rate Units, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PEST_SPRAY_TYPE_4 (type: esriFieldTypeString, alias: Pesticide 4 Spray Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_PRODUCT_4 (type: esriFieldTypeString, alias: Pesticide 4 Product, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_ACTIVE_MATERIAL_4 (type: esriFieldTypeString, alias: Pesticide 4 Active Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_PCP_REGISTRATION_4 (type: esriFieldTypeString, alias: Pesticide 4 PCP Registration Number, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_GROUP_4 (type: esriFieldTypeString, alias: Pesticide 4 Mode of Action, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_APPLICATION_RATE_4 (type: esriFieldTypeDouble, alias: Pesticide 4 Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PEST_APPLICATION_UNITS_4 (type: esriFieldTypeString, alias: Pesticide 4 Rate Units, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PEST_ADJ_EXISTS (type: esriFieldTypeString, alias: Pesticide Adjuvant Exists, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PEST_ADJ_NUMBER (type: esriFieldTypeInteger, alias: Pesticide Adjuvant Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PEST_ADJ_TYPE_1 (type: esriFieldTypeString, alias: Pesticide Adjuvant 1 Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_ADJ_RATE_1 (type: esriFieldTypeDouble, alias: Pesticide Adjuvant 1 Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PEST_ADJ_RATE_UNITS_1 (type: esriFieldTypeString, alias: Pesticide Adjuvant 1 Units, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_ADJ_TYPE_2 (type: esriFieldTypeString, alias: Pesticide Adjuvant 2 Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_ADJ_RATE_2 (type: esriFieldTypeDouble, alias: Pesticide Adjuvant 2 Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PEST_ADJ_RATE_UNITS_2 (type: esriFieldTypeString, alias: Pesticide Adjuvant 2 Units, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_ADJ_TYPE_3 (type: esriFieldTypeString, alias: Pesticide Adjuvant 3 Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_ADJ_RATE_3 (type: esriFieldTypeDouble, alias: Pesticide Adjuvant 3 Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PEST_ADJ_RATE_UNITS_3 (type: esriFieldTypeString, alias: Pesticide Adjuvant 3 Units, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_ADJ_TYPE_4 (type: esriFieldTypeString, alias: Pesticide Adjuvant 4 Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_ADJ_RATE_4 (type: esriFieldTypeDouble, alias: Pesticide Adjuvant 4 Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PEST_ADJ_RATE_UNITS_4 (type: esriFieldTypeString, alias: Pesticide Adjuvant 4 Units, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PEST_FIELD_STATUS (type: esriFieldTypeString, alias: Pesticide Field Status, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PEST_RE_ENTRY_TIME (type: esriFieldTypeInteger, alias: Pesticide Re-Entry Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PEST_RE_ENTRY_DATE (type: esriFieldTypeDate, alias: Pesticide Re-Entry Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FERT_BLEND (type: esriFieldTypeString, alias: Fertilizer Blend, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• FERT_PRODUCT_RATE (type: esriFieldTypeDouble, alias: Fertilizer Product Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FERT_PRODUCT_RATE_UNITS (type: esriFieldTypeString, alias: Fertilizer Product Rate Units, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• FERT_TYPE (type: esriFieldTypeString, alias: Fertilizer Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• FERT_INCORPORATION (type: esriFieldTypeString, alias: Fertilizer Incorporation, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• SEED_CROP (type: esriFieldTypeString, alias: Seeding Crop, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• SEED_TYPE (type: esriFieldTypeString, alias: Seeding Crop Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• SEED_VARIETY (type: esriFieldTypeString, alias: Seeding Variety, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• SEED_RATE (type: esriFieldTypeDouble, alias: Seeding Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SEED_RATE_UNITS (type: esriFieldTypeString, alias: Seeding Rate Units, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• SEED_DEPTH (type: esriFieldTypeDouble, alias: Seeding Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SEED_GERM (type: esriFieldTypeInteger, alias: Seeding Germination Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SEED_TKW (type: esriFieldTypeDouble, alias: Seeding TKW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CULTIV_DEPTH (type: esriFieldTypeDouble, alias: Cultivation Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IRRIG_VOLUME_L_AC (type: esriFieldTypeDouble, alias: Irrigation Volume, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IRRIG_SPRINKLER_TYPE (type: esriFieldTypeString, alias: Irrigation Sprinkler Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• IRRIG_FIELD_STATUS (type: esriFieldTypeString, alias: Irrigation Field Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• IRRIG_RE_ENTRY_TIME (type: esriFieldTypeDouble, alias: Irrigation Hours Closed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IRRIG_RE_ENTRY_DATE (type: esriFieldTypeDate, alias: Irrigation Opening Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HARV_TYPE (type: esriFieldTypeString, alias: Harvest Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• HARV_MOSITURE_PERC (type: esriFieldTypeString, alias: Harvest Moisture Percent, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• HARV_YIELD_RATE (type: esriFieldTypeString, alias: Harvest Yield Rate, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• HARV_YIELD_RATE_UNITS (type: esriFieldTypeString, alias: Harvest Yield Units, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• WTHR_CAPTURE (type: esriFieldTypeInteger, alias: Weather Capture, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Automatic], [2: No Weather Collection], [3: Manual])
• WTHR_DATE_RECORDED (type: esriFieldTypeDate, alias: Weather Recorded Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WTHR_WIND_SPEED (type: esriFieldTypeDouble, alias: Weather Wind Speed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WTHR_WIND_DIR (type: esriFieldTypeInteger, alias: Weather Wind Direction, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WTHR_SKY_COND (type: esriFieldTypeString, alias: Weather Sky Condition, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• WTHR_TEMP (type: esriFieldTypeDouble, alias: Weather Temperature, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WTHR_HUMIDITY (type: esriFieldTypeDouble, alias: Weather Humidity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WTHR_WIND_SPEED_UNITS (type: esriFieldTypeString, alias: Weather Wind Speed Units, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• WTHR_WIND_SPEED_NAME (type: esriFieldTypeString, alias: Weather Wind Speed Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• WTHR_WIND_DIR_CODE (type: esriFieldTypeString, alias: Weather Wind Direction Code, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• WTHR_CITY_ID (type: esriFieldTypeInteger, alias: Weather City ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WTHR_CITY_NAME (type: esriFieldTypeString, alias: Weather City Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• WTHR_TEMP_UNITS (type: esriFieldTypeString, alias: Weather Temperature Units, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• SOIL_CONDITIONS (type: esriFieldTypeString, alias: Weather Soil Conditions, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• SOIL_TEMPERATURE (type: esriFieldTypeDouble, alias: Weather Soil Temperature, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONTACT_NAME (type: esriFieldTypeString, alias: Contact Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• CONTACT_NUMBER (type: esriFieldTypeString, alias: Contact Number, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• ADDN_COMMENTS (type: esriFieldTypeString, alias: Contact Additional Comments, SQL Type: sqlTypeOther, length: 2048, nullable: true, editable: true)
• PARENT_GLOBALID (type: esriFieldTypeString, alias: Parent Global ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• PROCESSED_DATE (type: esriFieldTypeDate, alias: Processed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• workorderid (type: esriFieldTypeString, alias: Work Order ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: Created User, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Last Edited User, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last Edited Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CONTACT_EMAIL (type: esriFieldTypeString, alias: Contact Email, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• SEED_DIRECTION (type: esriFieldTypeString, alias: Seed Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CULTIV_DIRECTION (type: esriFieldTypeString, alias: Cultivation Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• APPLICATION_DATE (type: esriFieldTypeDate, alias: Application Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• APPLICATION_IMPLEMENT (type: esriFieldTypeString, alias: Application Implement, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• WORKFORCE_LINK (type: esriFieldTypeString, alias: Workforce Link, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• APPLICATION_DATE_PROPOSED (type: esriFieldTypeDate, alias: Application Date - Proposed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TOTAL_REQUEST_ACRES (type: esriFieldTypeDouble, alias: Total Request Acres, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_REQUEST_HECTARES (type: esriFieldTypeDouble, alias: Total Request Hectares, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TASK_STATUS (type: esriFieldTypeString, alias: Task Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• REQUEST_ACCESSCODE (type: esriFieldTypeString, alias: Access Code, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• REQUEST_INITIALS (type: esriFieldTypeString, alias: Initials, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• REQUEST_ACCESSCODE_STATUS (type: esriFieldTypeString, alias: Access Code Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• APPLICATION_INFO (type: esriFieldTypeString, alias: Application Info, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: src_lethbridge_tbl
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/21/2025 3:43:07 PM

Schema Last Edit Date: 7/21/2025 3:42:48 PM

Data Last Edit Date: 7/21/2025 3:43:07 PM

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