Name: InspectionRecords_Admin

Display Field: TREE_SPECIES

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 5200bf248e2d4e8da0f96d241fa00494

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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• TREE_SPECIES ( type: esriFieldTypeString, alias: GENERAL | Species, length: 256 , Coded Values: [29746: Abelia x grandiflora] , [29154: Abelia x grandiflora 'Francis Mason'] , [30722: Abelia x grandiflora 'Kaleidoscope'] , ...5398 more... )
• TREE_VIGOR ( type: esriFieldTypeString, alias: GENERAL | Vigor, length: 50 , Coded Values: [EXC: Excellent] , [AVE: Average] , [POOR: Poor] , ...1 more... )
• TREE_GIRTH ( type: esriFieldTypeDouble, alias: GENERAL | Girth (m) , Range: [0.01, 10] )
• TREE_HEIGHT ( type: esriFieldTypeSmallInteger, alias: GENERAL | Height (m) , Range: [1, 50] )
• TREE_REMARKS ( type: esriFieldTypeString, alias: GENERAL | Remarks, length: 512 )
• TP_TREE_REMOVED ( type: esriFieldTypeString, alias: GENERAL | Tree has been removed?, length: 50 , Coded Values: [1: Yes] , [0: No] )
• FOLIAGE_COLOUR ( type: esriFieldTypeString, alias: GENERAL | Foliage Colour, length: 50 , Coded Values: [0: Normal] , [1: Chlorotic] , [2: Necrotic] )
• LEAN ( type: esriFieldTypeString, alias: GENERAL | Lean, length: 50 , Coded Values: [1: Yes] , [0: No] )
• LEAN_DEGREES_FROM_VERTICAL ( type: esriFieldTypeSmallInteger, alias: GENERAL | LEAN | Degrees from vertical , Range: [0, 90] )
• LEAN_DIRECTION_OF_LEAN ( type: esriFieldTypeSmallInteger, alias: GENERAL | LEAN | Direction of lean , Range: [0, 360] )
• LEAN_INFO ( type: esriFieldTypeString, alias: GENERAL | LEAN | Lean Information, length: 50 , Coded Values: [0: natural due to phototropism / self-corrected (sweep)] , [1: unnatural-unnatural / straight] )
• LIFTING_OF_MOUND_OR_CRACK ( type: esriFieldTypeString, alias: GENERAL | Lifting of mound, soil cracks or cracks in structure(s), length: 50 , Coded Values: [1: Yes] , [0: No] )
• CROWN ( type: esriFieldTypeString, alias: CROWN | Crown, length: 50 , Coded Values: [1: Unbalance] , [0: Balance] )
• HEAVY_DENSE_CROWN ( type: esriFieldTypeString, alias: CROWN | Heavy/ dense crown, length: 50 , Coded Values: [1: Yes] , [0: No] )
• LIVE_CROWN_RATIO ( type: esriFieldTypeString, alias: CROWN | Live crown ratio, length: 50 , Coded Values: [0: low (<1/3)] , [1: medium (1/3 - 2/3)] , [2: high (>2/3)] )
• DIEBACK_TWIGS ( type: esriFieldTypeString, alias: CROWN | Dieback twigs, length: 50 , Coded Values: [0: 0-5% crown] , [1: 6-20% crown] , [2: 21-50% crown] , ...1 more... )
• DEFOLIATION ( type: esriFieldTypeString, alias: CROWN | Defoliation, length: 50 , Coded Values: [0: 0-5% crown] , [1: 6-20% crown] , [2: 21-50% crown] , ...1 more... )
• PRUNING_HISTORY ( type: esriFieldTypeString, alias: CROWN | Pruning history, length: 50 , Coded Values: [0: crown cleaned] , [1: raised] , [2: reduced] , ...1 more... )
• BRANCH_INFO_1 ( type: esriFieldTypeString, alias: BRANCH | Branch Information 1, length: 100 , Coded Values: [0: adventitious roots] , [1: bow/ sweep] , [2: cavity] , ...19 more... )
• BRANCH_INFO_2 ( type: esriFieldTypeString, alias: BRANCH | Branch Information 2, length: 100 , Coded Values: [0: adventitious roots] , [1: bow/ sweep] , [2: cavity] , ...19 more... )
• BRANCH_INFO_3 ( type: esriFieldTypeString, alias: BRANCH | Branch Information 3, length: 100 , Coded Values: [0: adventitious roots] , [1: bow/ sweep] , [2: cavity] , ...19 more... )
• BRANCH_INFO_4 ( type: esriFieldTypeString, alias: BRANCH | Branch Information 4, length: 100 , Coded Values: [0: adventitious roots] , [1: bow/ sweep] , [2: cavity] , ...19 more... )
• BRANCH_INFO_5 ( type: esriFieldTypeString, alias: BRANCH | Branch Information 5, length: 100 , Coded Values: [0: adventitious roots] , [1: bow/ sweep] , [2: cavity] , ...19 more... )
• BRANCH_INFO_OTHRS ( type: esriFieldTypeString, alias: BRANCH | Branch Information (others), length: 250 )
• PARASITIC_PLANTS ( type: esriFieldTypeString, alias: BRANCH | Parasitic plants, length: 50 , Coded Values: [1: Yes] , [0: No] )
• EPIPHYTIC_PLANTS ( type: esriFieldTypeString, alias: BRANCH | Epiphytic plants, length: 50 , Coded Values: [0: <5] , [1: >5] )
• CAVITY ( type: esriFieldTypeString, alias: TRUNK | Cavity, length: 50 , Coded Values: [1: Yes] , [0: No] )
• CAVITY_LENGTH ( type: esriFieldTypeDouble, alias: TRUNK | CAVITY | Length (m) )
• CAVITY_WIDTH ( type: esriFieldTypeDouble, alias: TRUNK | CAVITY | Width (m) )
• CAVITY_DEPTH ( type: esriFieldTypeDouble, alias: TRUNK | CAVITY | Depth (m) )
• CAVITY_LOCATION ( type: esriFieldTypeSmallInteger, alias: TRUNK | CAVITY | Location (deg[N]) , Range: [0, 360] )
• CAVITY_HEIGHT ( type: esriFieldTypeDouble, alias: TRUNK | CAVITY | Height (m) )
• DECAY ( type: esriFieldTypeString, alias: TRUNK | Decay, length: 50 , Coded Values: [1: Yes] , [0: No] )
• SMOOTH_BULGE ( type: esriFieldTypeString, alias: TRUNK | Smooth Bulge, length: 50 , Coded Values: [1: Yes] , [0: No] )
• SMOOTH_BULGE_LOCATION ( type: esriFieldTypeSmallInteger, alias: TRUNK | SMOOTH BULGE | Location (deg[N]) , Range: [0, 360] )
• SMOOTH_BULGE_HEIGHT ( type: esriFieldTypeDouble, alias: TRUNK | SMOOTH BULGE | Height (m) )
• TRUNK_INFO_1 ( type: esriFieldTypeString, alias: TRUNK | Trunk Information 1, length: 100 , Coded Values: [0: abnormal bark crack] , [1: adventitious roots] , [2: bow/sweep] , ...16 more... )
• TRUNK_INFO_2 ( type: esriFieldTypeString, alias: TRUNK | Trunk Information 2, length: 100 , Coded Values: [0: abnormal bark crack] , [1: adventitious roots] , [2: bow/sweep] , ...16 more... )
• TRUNK_INFO_3 ( type: esriFieldTypeString, alias: TRUNK | Trunk Information 3, length: 100 , Coded Values: [0: abnormal bark crack] , [1: adventitious roots] , [2: bow/sweep] , ...16 more... )
• TRUNK_INFO_4 ( type: esriFieldTypeString, alias: TRUNK | Trunk Information 4, length: 100 , Coded Values: [0: abnormal bark crack] , [1: adventitious roots] , [2: bow/sweep] , ...16 more... )
• TRUNK_INFO_5 ( type: esriFieldTypeString, alias: TRUNK | Trunk Information 5, length: 100 , Coded Values: [0: abnormal bark crack] , [1: adventitious roots] , [2: bow/sweep] , ...16 more... )
• TRUNK_INFO_OTHRS ( type: esriFieldTypeString, alias: TRUNK | Trunk Information (others), length: 250 )
• ROOTS_INFO_1 ( type: esriFieldTypeString, alias: ROOTS | Roots Information 1, length: 100 , Coded Values: [0: cracks/splits] , [1: cut roots] , [2: dead surface roots] , ...8 more... )
• ROOTS_INFO_2 ( type: esriFieldTypeString, alias: ROOTS | Roots Information 2, length: 100 , Coded Values: [0: cracks/splits] , [1: cut roots] , [2: dead surface roots] , ...8 more... )
• ROOTS_INFO_3 ( type: esriFieldTypeString, alias: ROOTS | Roots Information 3, length: 100 , Coded Values: [0: cracks/splits] , [1: cut roots] , [2: dead surface roots] , ...8 more... )
• ROOTS_INFO_4 ( type: esriFieldTypeString, alias: ROOTS | Roots Information 4, length: 100 , Coded Values: [0: cracks/splits] , [1: cut roots] , [2: dead surface roots] , ...8 more... )
• ROOTS_INFO_5 ( type: esriFieldTypeString, alias: ROOTS | Roots Information 5, length: 100 )
• ROOTS_INFO_OTHRS ( type: esriFieldTypeString, alias: ROOTS | Roots Information (others), length: 100 )
• TOPOGRAPHY ( type: esriFieldTypeString, alias: SITE CONDITIONS | Topography, length: 100 , Coded Values: [1: Slope] , [0: Flat] )
• SOIL_CONDITION_1 ( type: esriFieldTypeString, alias: SITE CONDITIONS | Soil Condition 1, length: 100 , Coded Values: [0: compacted] , [1: limited volume] , [2: pavement over roots] , ...1 more... )
• PAVEMENT_OVER_ROOTS ( type: esriFieldTypeSmallInteger, alias: SITE CONDITIONS | SOIL CONDITIONS | Pavement over roots , Range: [0, 100] )
• SOIL_CONDITION_OTHRS ( type: esriFieldTypeString, alias: SITE CONDITIONS | Soil Condition (others), length: 250 )
• SITE_DISTURBED_BY_CONST_1 ( type: esriFieldTypeString, alias: SITE CONDITIONS | Site disturbed by construction 1, length: 100 , Coded Values: [0: Drain replacement] , [1: Laying of new foot path] , [2: Laying of underground utility services] , ...3 more... )
• LOC_WHR_TREE_IS_GROWING_1 ( type: esriFieldTypeString, alias: SITE CONDITIONS | Location where tree is growing 1, length: 100 , Coded Values: [1: open space/ park] , [2: roadside planting verge] , [3: vacant land] , ...1 more... )
• LOC_WHR_TREE_IS_GROWING_OTHRS ( type: esriFieldTypeString, alias: SITE CONDITIONS | Location where tree is growing (others), length: 250 )
• SITE_DISTURBED_BY_CONST_OTHRS ( type: esriFieldTypeString, alias: SITE CONDITIONS | Site disturbed by construction (others), length: 250 )
• ROOT_GROWTH_RESTR_TYPE_1 ( type: esriFieldTypeString, alias: SITE CONDITIONS | Restriction for root growth 1, length: 100 , Coded Values: [5: container/ planter box] , [0: drain] , [6: footings of railings/ structure] , ...4 more... )
• ROOT_GROWTH_RESTR_TYPE_2 ( type: esriFieldTypeString, alias: SITE CONDITIONS | Restriction for root growth 2, length: 100 , Coded Values: [5: container/ planter box] , [0: drain] , [6: footings of railings/ structure] , ...4 more... )
• ROOT_GROWTH_RESTR_TYPE_3 ( type: esriFieldTypeString, alias: SITE CONDITIONS | Restriction for root growth 3, length: 100 , Coded Values: [5: container/ planter box] , [0: drain] , [6: footings of railings/ structure] , ...4 more... )
• ROOT_GROWTH_RESTR_TYPE_4 ( type: esriFieldTypeString, alias: SITE CONDITIONS | Restriction for root growth 4, length: 100 , Coded Values: [5: container/ planter box] , [0: drain] , [6: footings of railings/ structure] , ...4 more... )
• ROOT_GROWTH_RESTR_TYPE_5 ( type: esriFieldTypeString, alias: SITE CONDITIONS | Restriction for root growth 5, length: 100 , Coded Values: [5: container/ planter box] , [0: drain] , [6: footings of railings/ structure] , ...4 more... )
• ROOT_GROWTH_RESTR_TYPE_OTHRS ( type: esriFieldTypeString, alias: SITE CONDITIONS | Restriction for root growth (others), length: 250 )
• TARGET_ZONE_1 ( type: esriFieldTypeString, alias: TARGET | Use under tree-target zone 1, length: 50 , Coded Values: [0: building] , [1: gathering point] , [2: parking] , ...4 more... )
• CAN_TARGET_BE_MOVED ( type: esriFieldTypeString, alias: TARGET | Can target be moved?, length: 50 , Coded Values: [1: Yes] , [0: No] )
• CAN_USE_OF_SITE_BE_RESTRICTED ( type: esriFieldTypeString, alias: TARGET | Can use of site be restricted?, length: 50 , Coded Values: [1: Yes] , [0: No] )
• MITIGATION_1 ( type: esriFieldTypeString, alias: FOLLOW-UP ACTIONS | Mitigation 1, length: 100 , Coded Values: [0: crown cleaning] , [1: crown lifting] , [2: crown reduction] , ...7 more... )
• GUID ( type: esriFieldTypeGUID, alias: GUID, length: 38 )
• DECAY_LOCATION ( type: esriFieldTypeSmallInteger, alias: TRUNK | DECAY | Location (deg[N]) , Range: [0, 360] )
• DECAY_HEIGHT ( type: esriFieldTypeDouble, alias: TRUNK | DECAY | Height (m) )
• SOIL_CONDITION_2 ( type: esriFieldTypeString, alias: SITE CONDITIONS | Soil Condition 2, length: 100 , Coded Values: [0: compacted] , [1: limited volume] , [2: pavement over roots] , ...1 more... )
• SOIL_CONDITION_3 ( type: esriFieldTypeString, alias: SITE CONDITIONS | Soil Condition 3, length: 100 , Coded Values: [0: compacted] , [1: limited volume] , [2: pavement over roots] , ...1 more... )
• SITE_DISTURBED_BY_CONST_2 ( type: esriFieldTypeString, alias: SITE CONDITIONS | Site disturbed by construction 2, length: 100 , Coded Values: [0: Drain replacement] , [1: Laying of new foot path] , [2: Laying of underground utility services] , ...3 more... )
• SITE_DISTURBED_BY_CONST_3 ( type: esriFieldTypeString, alias: SITE CONDITIONS | Site disturbed by construction 3, length: 100 , Coded Values: [0: Drain replacement] , [1: Laying of new foot path] , [2: Laying of underground utility services] , ...3 more... )
• SITE_DISTURBED_BY_CONST_4 ( type: esriFieldTypeString, alias: SITE CONDITIONS | Site disturbed by construction 4, length: 100 , Coded Values: [0: Drain replacement] , [1: Laying of new foot path] , [2: Laying of underground utility services] , ...3 more... )
• SITE_DISTURBED_BY_CONST_5 ( type: esriFieldTypeString, alias: SITE CONDITIONS | Site disturbed by construction 5, length: 100 , Coded Values: [0: Drain replacement] , [1: Laying of new foot path] , [2: Laying of underground utility services] , ...3 more... )
• LOC_WHR_TREE_IS_GROWING_2 ( type: esriFieldTypeString, alias: SITE CONDITIONS | Location where tree is growing 2, length: 100 , Coded Values: [1: open space/ park] , [2: roadside planting verge] , [3: vacant land] , ...1 more... )
• LOC_WHR_TREE_IS_GROWING_3 ( type: esriFieldTypeString, alias: SITE CONDITIONS | Location where tree is growing 3, length: 100 , Coded Values: [1: open space/ park] , [2: roadside planting verge] , [3: vacant land] , ...1 more... )
• OCCUPANCY ( type: esriFieldTypeString, alias: TARGET | Occupancy, length: 50 , Coded Values: [0: rare] , [1: occasional] , [2: frequent] , ...1 more... )
• MITIGATION_2 ( type: esriFieldTypeString, alias: FOLLOW-UP ACTIONS | Mitigation 2, length: 100 , Coded Values: [0: crown cleaning] , [1: crown lifting] , [2: crown reduction] , ...7 more... )
• MITIGATION_3 ( type: esriFieldTypeString, alias: FOLLOW-UP ACTIONS | Mitigation 3, length: 100 , Coded Values: [0: crown cleaning] , [1: crown lifting] , [2: crown reduction] , ...7 more... )
• MITIGATION_4 ( type: esriFieldTypeString, alias: FOLLOW-UP ACTIONS | Mitigation 4, length: 100 , Coded Values: [0: crown cleaning] , [1: crown lifting] , [2: crown reduction] , ...7 more... )
• MITIGATION_5 ( type: esriFieldTypeString, alias: FOLLOW-UP ACTIONS | Mitigation 5, length: 100 , Coded Values: [0: crown cleaning] , [1: crown lifting] , [2: crown reduction] , ...7 more... )
• MITIGATION_OTHRS ( type: esriFieldTypeString, alias: FOLLOW-UP ACTIONS | Mitigation (others), length: 250 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• TARGET_ZONE_2 ( type: esriFieldTypeString, alias: TARGET | Use under tree-target zone 2, length: 50 , Coded Values: [0: building] , [1: gathering point] , [2: parking] , ...4 more... )
• TARGET_ZONE_3 ( type: esriFieldTypeString, alias: TARGET | Use under tree-target zone 3, length: 50 , Coded Values: [0: building] , [1: gathering point] , [2: parking] , ...4 more... )
• TARGET_ZONE_4 ( type: esriFieldTypeString, alias: TARGET | Use under tree-target zone 4, length: 50 , Coded Values: [0: building] , [1: gathering point] , [2: parking] , ...4 more... )
• TARGET_ZONE_5 ( type: esriFieldTypeString, alias: TARGET | Use under tree-target zone 5, length: 50 , Coded Values: [0: building] , [1: gathering point] , [2: parking] , ...4 more... )
• TARGET_ZONE_OTHRS ( type: esriFieldTypeString, alias: TARGET | Use under tree-target zone (others), length: 250 )
• TRS_ID ( type: esriFieldTypeString, alias: TRS_ID, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• INSPECTION_STATUS ( type: esriFieldTypeString, alias: INSPECTION STATUS, length: 255 , Coded Values: [Completed: Completed Inspection] , [Deleted: Tree Removed] , [Pending: Pending Inspection] , ...1 more... )
• HEIGHT_CODE ( type: esriFieldTypeString, alias: HEIGHT CODE, length: 255 , Coded Values: [H9: H9 [more than 24m]] , [H8: H8 [21m-24m]] , [H7: H7 [18m-21m]] , ...6 more... )

Relationships:

• Trees (0) -- Related To: Trees_Admin (0)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata