sc.yml

{
   "$schema":"https://specs.frictionlessdata.io/schemas/table-schema.json",
   "name":"Inidicateur Pilote sans contraintes",
   "title":"Inidicateur Pilote sans contraintes",
   "description":"Spécification d'un fichier d'import d'indicateur Pilote sans contraintes",
   "keywords":[
      "pilote",
      "ditp"
   ],
   "countryCode":"FR",
   "homepage":"https://github.com/DITP-pilotage/poc-imports",
   "path":"https://raw.githubusercontent.com/DITP-pilotage/poc-imports/master/schemas/schema_pilote_sans_contraintes.json",
   "licenses":[
      {
         "title":"-",
         "name":"-",
         "path":"-"
      }
   ],
   "resources":[
      {
         "title":"Fichier valide (CSV)",
         "name":"exemple-valide-csv",
         "path":"todo"
      },
      {
         "title":"Ressource valide (XLSX)",
         "name":"exemple-valide-xlsx",
         "path":"todo"
      }
   ],
   "sources":[
      
   ],
   "created":"2023-02-17",
   "lastModified":"2023-02-17",
   "version":"0.0.1",
   "contributors":[
      {
         "title":"Colin Dugeai",
         "email":"colin.dugeai@modernisation.gouv.fr",
         "organisation":"DITP",
         "role":"author"
      },
      {
         "title":"Geoffrey Aldebert",
         "email":"geoffrey.aldebert@data.gouv.fr",
         "organisation":"Etalab",
         "role":"contributor"
      }
   ],
   "fields":[
      {
         "name":"indic_id",
         "description":"Identifiant de l'indicateur. Au format 'IND-XXX'",
         "example":"IND-001",
         "type":"string",
         "constraints":{
            "required":true,
            "pattern":"^IND-[0-9]{3}$"
         }
      },
      {
         "name":"zone_id",
         "description":"Identifiant de la zone pour laquelle on importe une valeur.",
         "example":"D46",
         "type":"string",
         "constraints":{
            "required":true,
            "pattern":"^((D[0-9]{2,3})|(R[0-9]{2,3})|(A[0-9]{2,3})|FRANCE)$"
         }
      },
      {
         "name":"metric_date",
         "description":"Date à laquelle a été mesurée l'indicateur. Au format AAAA-MM-JJ",
         "example":"2023-01-31",
         "type":"date",
         "format":"%Y-%m-%d",
         "constraints":{
            "required":true
         }
      },
      {
         "name":"metric_type",
         "description":"Type de la donnée importée. vi/va/vc",
         "example":"vi",
         "type":"string",
         "constraints":{
            "required":true,
            "enum":[
               "vi",
               "va",
               "vc"
            ]
         }
      },
      {
         "name":"metric_value",
         "description":"Valeur de l'indicateur",
         "example":"12.23",
         "type":"number",
         "constraints":{
            "required":true
         }
      }
   ],
   "primaryKey":[
      "indic_id",
      "zone_id",
      "metric_date",
      "metric_type"
   ]
}