Layers:

Layer: AAR_Report (0)

Name: AAR_Report

Display Field: LICENCE_HOLDER_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: a04b64058d6b4d768d3b41bd6618b708

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: -1.39188095774E7
YMin: -1.51378970346E7
XMax: 7903683.8463
YMax: 8817493.7189
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• INDUSTRY_REPORT_TYPE ( type: esriFieldTypeString, alias: Report Type, length: 255 )
• FALLOW_FOR_REPORTING_YEAR_YN ( type: esriFieldTypeString, alias: Operational status, length: 255 )
• FILED_DATE ( type: esriFieldTypeDate, alias: Date Filed, length: 8 )
• DFO_REGION ( type: esriFieldTypeString, alias: DFO Region, length: 255 )
• PROVINCE ( type: esriFieldTypeString, alias: Province, length: 255 )
• LICENCE_HOLDER_NAME ( type: esriFieldTypeString, alias: Licence Holder Name(s), length: 255 )
• FACILITY_REFERENCE_NO ( type: esriFieldTypeString, alias: Facility Reference Number, length: 255 )
• PROV_FED_LICENCE_NO ( type: esriFieldTypeString, alias: Provincial or Federal Licence Number, length: 255 )
• PROV_FED_LEASE_NO ( type: esriFieldTypeString, alias: Provincial or Federal Lease Number, length: 255 )
• OPERATION_TYPE ( type: esriFieldTypeString, alias: Operation Type, length: 255 )
• OPERATION_TYPE_OTHER ( type: esriFieldTypeString, alias: Other Operation Type, length: 255 )
• LATITUDE_DEGREE ( type: esriFieldTypeInteger, alias: Latitude Degrees )
• LATITUDE_DM ( type: esriFieldTypeDouble, alias: Latitude Minutes )
• LONGITUDE_DEGREE ( type: esriFieldTypeInteger, alias: Longitude Degrees )
• LONGITUDE_DM ( type: esriFieldTypeDouble, alias: Longitude Minutes )
• UTM_NORTHING ( type: esriFieldTypeDouble, alias: Northing )
• UTM_EASTING ( type: esriFieldTypeDouble, alias: Easting )
• UTM_ZONE ( type: esriFieldTypeInteger, alias: UTM Zone )
• TOTAL_TENURE_SIZE ( type: esriFieldTypeDouble, alias: Hectares )
• CONTACT_NAME ( type: esriFieldTypeString, alias: Contact Name, length: 255 )
• CONTACT_EMAIL ( type: esriFieldTypeString, alias: Email Address, length: 255 )
• NUMBER_OF_FISH ( type: esriFieldTypeInteger, alias: Maximum Number of Fish )
• MAXIMUM_BIOMASS_T ( type: esriFieldTypeInteger, alias: Maximum Biomass (tonnes) )
• FEED_QUOTA_T ( type: esriFieldTypeInteger, alias: Feed Quota (tonnes) )
• SEC_1_1 ( type: esriFieldTypeString, alias: Sec_1_1, length: 255 )
• SEC_1_2 ( type: esriFieldTypeString, alias: Sec_1_2, length: 255 )
• SEC_1_OTHER ( type: esriFieldTypeString, alias: Sec_1_Other, length: 1024 )
• SEC_2_1 ( type: esriFieldTypeString, alias: Sec_2_1, length: 255 )
• SEC_2_2_TO_2_5 ( type: esriFieldTypeString, alias: Sec_2_2_To_2_5, length: 255 )
• SEC_2_OTHER ( type: esriFieldTypeString, alias: Sec_2_Other, length: 1024 )
• SEC_3_1_1 ( type: esriFieldTypeString, alias: Sec_3_1_1, length: 255 )
• SEC_3_1_2_TO_3_1_13_LBRPT ( type: esriFieldTypeString, alias: Sec_3_1_2_To_3_1_13_LBRPT, length: 255 )
• SEC_3_1_2_TO_3_1_16_CFRPT ( type: esriFieldTypeString, alias: Sec_3_1_2_To_3_1_16_CFRPT, length: 255 )
• SEC_3_1_OTHER ( type: esriFieldTypeString, alias: Sec_3_1_Other, length: 1024 )
• SEC_3_2_1 ( type: esriFieldTypeString, alias: Sec_3_2_1, length: 255 )
• SEC_3_2_2 ( type: esriFieldTypeString, alias: Sec_3_2_2, length: 255 )
• SEC_3_2_2_1_TO_3_2_2_3_LBRPT ( type: esriFieldTypeString, alias: Sec_3_2_2_1_To_3_2_2_3_LBRPT, length: 255 )
• SEC_3_2_2_1_TO_3_2_2_4_CFRPT ( type: esriFieldTypeString, alias: Sec_3_2_2_1_To_3_2_2_4_CFRPT, length: 255 )
• SEC_3_2_3_LBRPT ( type: esriFieldTypeString, alias: Sec3_2_3_LBRPT, length: 255 )
• SEC_3_2_3_CFRPT ( type: esriFieldTypeString, alias: Sec_3_2_3_CFRPT, length: 255 )
• SEC_3_2_4_CFRPT ( type: esriFieldTypeString, alias: Sec_3_2_4_CFRPT, length: 255 )
• SEC_3_2_OTHER ( type: esriFieldTypeString, alias: Sec_3_2_Other, length: 1024 )
• SEC_4_1_TO_4_5_LBRPT ( type: esriFieldTypeString, alias: Sec_4_1_TO_4_5_LBRPT, length: 255 )
• SEC_4_1_TO_4_3_CFRPT ( type: esriFieldTypeString, alias: Sec_4_1_TO_4_3_CFRPT, length: 255 )
• SEC_4_OTHER ( type: esriFieldTypeString, alias: Sec_4_Other, length: 1024 )
• SEC_5_1_LBRPT ( type: esriFieldTypeString, alias: Sec_5_1_LBRPT, length: 255 )
• SEC_5_2_TO_5_3_LBRPT ( type: esriFieldTypeString, alias: Sec_5_2_To_5_3_LBRPT, length: 255 )
• SEC_5_1_TO_5_4_CFRPT ( type: esriFieldTypeString, alias: Sec_5_1_To_5_4_CFRPT, length: 255 )
• SEC_5_OTHER ( type: esriFieldTypeString, alias: Sec_5_Other, length: 1024 )
• SEC_6_1_CFRPT ( type: esriFieldTypeString, alias: Sec_6_1_CFRPT, length: 255 )
• SEC_6_2_TO_6_3_CFRPT ( type: esriFieldTypeString, alias: Sec_6_2_To_6_3_CFRPT, length: 255 )
• SEC_1_1_SFRPT ( type: esriFieldTypeString, alias: Sec_1_1_SFRPT, length: 255 )
• SEC_1_2_TO_1_10_SFRPT ( type: esriFieldTypeString, alias: Sec_1_2_To_1_10_SFRPT, length: 255 )
• SEC_1_OTHER_SFRPT ( type: esriFieldTypeString, alias: Sec_1_Other_SFRPT, length: 1024 )
• SEC_2_1_SFRPT ( type: esriFieldTypeString, alias: Sec_2_1_SFRPT, length: 255 )
• SEC_2_2_TO_2_3_SFRPT ( type: esriFieldTypeString, alias: Sec_2_2_TO_2_3_SFRPT, length: 255 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: Last Edited User, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: Last Edited Date, length: 8 )
• DFO_DOMAIN_USERNAME ( type: esriFieldTypeString, alias: DFO Domain Username, length: 255 )
• SURVEY_START_DATE ( type: esriFieldTypeDate, alias: Survey Start Date, length: 8 )
• SURVEY_END_DATE ( type: esriFieldTypeDate, alias: Survey End Date, length: 8 )
• REPORT_VERSION_NO ( type: esriFieldTypeString, alias: Report Version Number, length: 255 )
• INDUSTRY_REPORT_ID ( type: esriFieldTypeDouble, alias: Industry Report ID )
• REPORTING_YEAR ( type: esriFieldTypeSmallInteger, alias: Reporting Period Year )
• TOTAL_TENURE_SIZE_UOM ( type: esriFieldTypeString, alias: Acres, length: 255 )
• CONTACT_PHONE ( type: esriFieldTypeDouble, alias: Telephone Number )
• REPORTING_YEAR_DISPLAY ( type: esriFieldTypeString, alias: Reporting Year, length: 255 )
• CONTACT_PHONE_INPUT ( type: esriFieldTypeString, alias: Contact Phone, length: 255 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• FACILITY_NAME ( type: esriFieldTypeString, alias: Facility Name, length: 255 )

Relationships:

• AAR_REPORT_ADMINISTRATOR_USER.aar_table2 (1) -- Related To: aar_table2 (3)
• MSHAO.aar_table1 (0) -- Related To: aar_table1 (2)

Tables:

Table: aar_table1 (2)

Name: aar_table1

Display Field: SPECIES_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: a04b64058d6b4d768d3b41bd6618b708

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SPECIES_NAME ( type: esriFieldTypeString, alias: Species, length: 255 )
• NUMBER_OF_FISH_SPECIES ( type: esriFieldTypeInteger, alias: Maximum Number of Fish )
• MAXIMUM_BIOMASS_T_SPECIES ( type: esriFieldTypeInteger, alias: Maximum Biomass (tonnes) )
• FEED_QUOTA_T_SPECIES ( type: esriFieldTypeInteger, alias: Feed Quota (tonnes) )
• PARENTGLOBALID ( type: esriFieldTypeGUID, alias: ParentGlobalID, length: 38 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Relationships:

• MSHAO.AAR_Report (0) -- Related To: AAR_Report (0)

Table: aar_table2 (3)

Name: aar_table2

Display Field: TREATMENT_DATE

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: a04b64058d6b4d768d3b41bd6618b708

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• TREATMENT_DATE ( type: esriFieldTypeDate, alias: Treatment Start Date, length: 8 )
• TREATMENT_END_DATE ( type: esriFieldTypeDate, alias: Treatment End Date, length: 8 )
• TREATMENT_NO ( type: esriFieldTypeSmallInteger, alias: Treatment # )
• FISH_HEALTH_PRODUCT_V2 ( type: esriFieldTypeString, alias: Product Name, length: 100 )
• ACTIVE_INGREDIENTS ( type: esriFieldTypeString, alias: Active Ingredients, length: 500 )
• DRUG_TREATMENT_PURPOSE_VAL_V2 ( type: esriFieldTypeString, alias: Treatment Reason, length: 100 )
• SPECIES_VAL_V2 ( type: esriFieldTypeString, alias: Species Treated, length: 100 )
• TOTAL_PRODUCT_QUANTITY_L ( type: esriFieldTypeDouble, alias: Total Aqueous Product (Litres) )
• TOTAL_PRODUCT_QUANTITY_KG ( type: esriFieldTypeDouble, alias: Total Medicated Feed (Kg) )
• TOTAL_ACTIVE_INGREDIENT_KG ( type: esriFieldTypeDouble, alias: Total Active Ingredient (Kg) )
• NOTES ( type: esriFieldTypeString, alias: Notes, length: 255 )
• PARENTGLOBALID ( type: esriFieldTypeGUID, alias: ParentGlobalID, length: 38 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )

Relationships:

• AAR_REPORT_ADMINISTRATOR_USER.AAR_Report (1) -- Related To: AAR_Report (0)