The "Attributes " tab lists all the data's attribute fields, specifying their name, alias, type, description and language.
| Definition | List of attribute table fields |
|---|---|
| Indications | The scan returns the name, type and comment/alias of each attribute to the database. You therefore need to fill in: - the alias, - a description, - the language. |
| Example | Name: type_epci Alias: Type d'intercommunalité Type: char(80) Description: Type d'EPCI (source OSM) : - CC = Communauté de Communes (1900) - CA = Communauté d'Agglomération (222) - CU = Communauté Urbaine (15) - metropole = Métropole (1) - SAN = Syndicat d'Agglomération Nouvelle (4) - NULL = non renseigné (3) Language : French |
| INSPIRE requirement | Optional |
| Batch editing | Yes, incremental |
| Scan | Yes |
| Search engine | No |
| Resource sheet | No |
| Service sheet | No |
Batch editing of attribute language¶
To make it easier to enter the language of attributes, it is possible to assign it at once only to text fields containing translatable text. In line with best practice in relational database modeling, the following types are eligible:
- clob ;
- char ;
- nvarchar ;
- nvarchar2 ;
- string ;
- text ;
- text ;
- varchar ;
- varchar2.
Export and import attributes in CSV¶
To facilitate the documentation of attributes by users who do not have access to the platform, for example, you can export the attributes so that they can be completed in a spreadsheet, and then import the completed table into the metadata sheet.
For your information, markdown and line breaks are handled on export and import.
Export¶
In view mode, attributes can be exported in CSV format. The delimiter for separating fields can be specified during export between :
- Semicolon ; (ideal for opening with Excel)
- Comma ,
- Pipe |
- Custom delimiter (a character entered manually in a text field)
To know more
If the character chosen to delimit the fields is present in one of the fields, it will be removed from the field in question.
The exported file is then a CSV file encoded in UTF-8, whose character strings are delimited by quotation marks ", and has 7 columns:
| Column name | Champ Isogeo |
|---|---|
| name | Name |
| alias | Alias |
| how | Alias, italicized in the case of DB data |
| dataType | Type |
| description | Description |
| language | Language |
| _id | Isogeo attribute identifier |
Import¶
In edit mode, attributes can be imported from a CSV file encoded in UTF-8. Character strings can be delimited by quotation marks " or not. This practice depends on the spreadsheet program used (Excel, Libre Office etc.). The column delimiter is automatically identified.
The content of the file must respect the presence of the following columns:
| Column name | Champ Isogeo |
|---|---|
| name | Name |
| alias | Alias |
| how | Alias, italicized in the case of DB data |
| dataType | Type |
| description | Description |
| language | Language |
| _id | Isogeo attribute identifier |
To know more
If there are several copies of an attribute, only the last copy will be imported.
Before validating the import, two options can be selected:
- Only update fields that have been filled in;
- Add new attributes.
Update only filled-in fields¶
If attributes are already documented in the file and fields are empty in the CSV file, the import will only modify the fields in the file and will not overwrite attributes already documented. If you wish to overwrite the content of all fields (even empty ones), you will need to uncheck this option.
Add new attributes¶
By default, the import only updates attributes with names similar to those already present in the file. If you wish to add new attributes to the file, you will need to check this option.