Name: DIAGNOSTICS
Display Field: clc_nomlatin
Type: Table
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Max Record Count: 20000
Supported query Formats: JSON
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:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- fk_obj_arbre (type: esriFieldTypeInteger, alias: FK_OBJ_ARBRE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dte_diagnos (type: esriFieldTypeDate, alias: Date de réalisation, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- fk_auteur (type: esriFieldTypeString, alias: Auteur du diagnostic, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- clc_site (type: esriFieldTypeString, alias: Site, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- id_arbre (type: esriFieldTypeString, alias: Numéro de l’arbre, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- clc_nomlatin (type: esriFieldTypeString, alias: Nom latin, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- fk_site_usage (type: esriFieldTypeString, alias: Usage du site, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [ADMIN: Administratif], [SPORT: Sport/loisir], [SCOL: Scolaire], ... 14 more ...)
- fk_frequentation (type: esriFieldTypeString, alias: Fréquention du site, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [peu fréquenté: peu fréquenté], [moyennement fréquenté: moyennement fréquenté], [très fréquenté: très fréquenté])
- obs_houppier (type: esriFieldTypeString, alias: Observations du houppier, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- obs_charpent (type: esriFieldTypeString, alias: Observations des charpentières, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- obs_tronc (type: esriFieldTypeString, alias: Observations du tronc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- obs_collet (type: esriFieldTypeString, alias: Observations du collet, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- obs_racine (type: esriFieldTypeString, alias: Observations du système racinaire, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- fk_vigueur (type: esriFieldTypeString, alias: Vigueur, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Bonne: Bonne], [Moyenne: Moyenne], [Faible: Faible], ... 2 more ...)
- fk_rupture (type: esriFieldTypeString, alias: Risque de rupture, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [Faible: Faible], [Moyen: Moyen], [Elevé: Elevé])
- fk_conclu_meca (type: esriFieldTypeString, alias: Tenue mécanique, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Mauvaise: Mauvaise], [Bonne: Bonne], [Correcte: Correcte], ... 1 more ...)
- fk_champignons (type: esriFieldTypeString, alias: Présence de champignons, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Oui: Oui], [Non: Non])
- fk_insectes (type: esriFieldTypeString, alias: Présence de vers / insectes, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Oui: Oui], [Non: Non])
- fk_conclu_sani (type: esriFieldTypeString, alias: Etat physiologique et sanitaire, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Mauvais: Mauvais], [Moyen: Moyen], [Bon: Bon], ... 2 more ...)
- fk_tests_real (type: esriFieldTypeString, alias: Tests réalisés, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Visuel: Contrôle visuel], [Maillet: Maillet], [Expertise approfondie: Maillet + expertise approfondie])
- fk_estim_maintien (type: esriFieldTypeString, alias: Espérance de maintien estimée, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Nulle: Nulle], [Court terme: Court terme (0 - 5 ans)], [Moyen terme: Moyen terme (5 - 15 ans)], ... 1 more ...)
- commentaires (type: esriFieldTypeString, alias: Remarques, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- oldoid (type: esriFieldTypeInteger, alias: oldoid, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Guid (type: esriFieldTypeGUID, alias: Guid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- Guid_2 (type: esriFieldTypeGUID, alias: Guid_2, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
Templates:
Name: DIAGNOSTICS
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
- Voir Arbre (0) -- Related To: ARBRES (0)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 11/25/2020 4:53:15 PM
Schema Last Edit Date: 11/25/2020 4:53:15 PM
Data Last Edit Date: 11/25/2020 4:53:15 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Query Related Records
Generate Renderer
Validate SQL
Get Estimates