Name: VenteCanaux

Display Field: created_user

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 6ad2c44b031e4140be151bd8f2f220c0

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• code_insee ( type: esriFieldTypeString, alias: Code insee, editable: true, nullable: false, length: 5, defaultValue: null, modelName: code_insee )
• nomcom ( type: esriFieldTypeString, alias: Nom de la commune, editable: true, nullable: false, length: 150, defaultValue: null, modelName: nomcom )
• guid ( type: esriFieldTypeGUID, alias: GUID, editable: false, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: guid )
• lieu_type ( type: esriFieldTypeSmallInteger, alias: Type de lieu de vente, editable: true, nullable: false, defaultValue: 1, modelName: lieu_type )
• lieu_sstype ( type: esriFieldTypeString, alias: lieu_sstype, editable: true, nullable: true, length: 50, defaultValue: null, modelName: lieu_sstype )
• lieu_nom ( type: esriFieldTypeString, alias: lieu_nom, editable: true, nullable: false, length: 150, defaultValue: null, modelName: lieu_nom )
• lieu_drive ( type: esriFieldTypeSmallInteger, alias: lieu_drive, editable: true, nullable: false, defaultValue: 0, modelName: lieu_drive )
• ouverture_plage1jour ( type: esriFieldTypeString, alias: Jour d'ouverture avec la plage 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ouverture_plage1jour )
• ouverture_plage2jour ( type: esriFieldTypeString, alias: Jour d'ouverture avec la plage 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ouverture_plage2jour )
• ouverture_plage3jour ( type: esriFieldTypeString, alias: Jour d'ouverture avec la plage 3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ouverture_plage3jour )
• ouverture_plage4jour ( type: esriFieldTypeString, alias: Jour d'ouverture avec la plage 4, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ouverture_plage4jour )
• ouverture_plageouverture1 ( type: esriFieldTypeString, alias: Ouverture de la plage 1, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ouverture_plageouverture1 )
• ouvertre_plagefermeture1 ( type: esriFieldTypeString, alias: Fermeture de la plage 1, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ouvertre_plagefermeture1 )
• ouverture_plageouverture2 ( type: esriFieldTypeString, alias: Ouverture de la plage 2, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ouverture_plageouverture2 )
• ouvertre_plagefermeture2 ( type: esriFieldTypeString, alias: Fermeture de la plage 2, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ouvertre_plagefermeture2 )
• ouverture_plageouverture3 ( type: esriFieldTypeString, alias: Ouverture de la plage 3, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ouverture_plageouverture3 )
• ouvertre_plagefermeture3 ( type: esriFieldTypeString, alias: Fermeture de la plage 3, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ouvertre_plagefermeture3 )
• ouverture_plageouverture4 ( type: esriFieldTypeString, alias: Ouverture de la plage 4, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ouverture_plageouverture4 )
• ouvertre_plagefermeture4 ( type: esriFieldTypeString, alias: Fermeture de la plage 4, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ouvertre_plagefermeture4 )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid )
• guid_producteur ( type: esriFieldTypeGUID, alias: GUID_producteur, editable: true, nullable: true, length: 38, defaultValue: null, modelName: guid_producteur )

Types:

ID: 1
Name: Vente directe
Domains:
• lieu_sstype:
  Coded Values: [communal: Marché communal] , [site: Sur site] , [relais: Sur un point relais] , ...1 more...
Templates:
• Name: Vente directe
  Description:
  Prototype:
  guid_producteur: null
  ouvertre_plagefermeture4: null
  ouverture_plageouverture4: null
  ouvertre_plagefermeture3: null
  ouverture_plageouverture3: null
  ouvertre_plagefermeture2: null
  code_insee:
  nomcom:
  ouverture_plageouverture2: null
  lieu_type: 1
  lieu_sstype: null
  lieu_nom:
  lieu_drive: 0
  ouverture_plage1jour: null
  ouverture_plage2jour: null
  ouverture_plage3jour: null
  ouverture_plage4jour: null
  ouverture_plageouverture1: null
  ouvertre_plagefermeture1: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 2
Name: Marché
Domains:
• lieu_sstype:
  Coded Values: [communal: Marché communal]
Templates:
• Name: Marché
  Description:
  Prototype:
  guid_producteur: null
  ouvertre_plagefermeture4: null
  ouverture_plageouverture4: null
  ouvertre_plagefermeture3: null
  ouverture_plageouverture3: null
  ouvertre_plagefermeture2: null
  code_insee:
  nomcom:
  ouverture_plageouverture2: null
  lieu_type: 2
  lieu_sstype: null
  lieu_nom:
  lieu_drive: 0
  ouverture_plage1jour: null
  ouverture_plage2jour: null
  ouverture_plage3jour: null
  ouverture_plage4jour: null
  ouverture_plageouverture1: null
  ouvertre_plagefermeture1: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 3
Name: Magasin
Domains:
• lieu_sstype:
  Coded Values: [producteur: Magazin de producteur] , [grande surface: Grande surface]
Templates:
• Name: Magasin
  Description:
  Prototype:
  guid_producteur: null
  ouvertre_plagefermeture4: null
  ouverture_plageouverture4: null
  ouvertre_plagefermeture3: null
  ouverture_plageouverture3: null
  ouvertre_plagefermeture2: null
  code_insee:
  nomcom:
  ouverture_plageouverture2: null
  lieu_type: 3
  lieu_sstype: null
  lieu_nom:
  lieu_drive: 0
  ouverture_plage1jour: null
  ouverture_plage2jour: null
  ouverture_plage3jour: null
  ouverture_plage4jour: null
  ouverture_plageouverture1: null
  ouvertre_plagefermeture1: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 4
Name: Drive paysan
Domains:
Templates:
• Name: Drive paysan
  Description:
  Prototype:
  guid_producteur: null
  ouvertre_plagefermeture4: null
  ouverture_plageouverture4: null
  ouvertre_plagefermeture3: null
  ouverture_plageouverture3: null
  ouvertre_plagefermeture2: null
  code_insee:
  nomcom:
  ouverture_plageouverture2: null
  lieu_type: 4
  lieu_sstype: null
  lieu_nom:
  lieu_drive: 0
  ouverture_plage1jour: null
  ouverture_plage2jour: null
  ouverture_plage3jour: null
  ouverture_plage4jour: null
  ouverture_plageouverture1: null
  ouvertre_plagefermeture1: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 5
Name: AMAP
Domains:
Templates:
• Name: AMAP
  Description:
  Prototype:
  guid_producteur: null
  ouvertre_plagefermeture4: null
  ouverture_plageouverture4: null
  ouvertre_plagefermeture3: null
  ouverture_plageouverture3: null
  ouvertre_plagefermeture2: null
  code_insee:
  nomcom:
  ouverture_plageouverture2: null
  lieu_type: 5
  lieu_sstype: null
  lieu_nom:
  lieu_drive: 0
  ouverture_plage1jour: null
  ouverture_plage2jour: null
  ouverture_plage3jour: null
  ouverture_plage4jour: null
  ouverture_plageouverture1: null
  ouvertre_plagefermeture1: null
  
  Drawing Tool: esriFeatureEditToolNone

---

Relationships:

• Vers canaux de vente (4) -- Related To: TableAssociationVente (5)
• Vers producteur (2) -- Related To: Producteur locaux (0)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata