search

datasets-br / state-codes

Brazilian states 2-letter codes (ISO 3166-2:BR), official abbreviations throughout the country's history
http://datasets.OK.org.br/state-codes
29 stars 11 forks source link

Review and change field names #17

Open ppKrauss opened 6 years ago

ppKrauss commented 6 years ago

Now SchemaOrg have eg. https://pending.schema.org/termCode to complement a name in the context of DefinedTerm or CategoryCode.

Use also temporalCoverage, but checking the best format for CSV interchange. For ISO 3601 the open-end is possible by ".." in the future ISO version.

Suggestion:

[state|code ascii text +PK2;temporalCoverage +PK3; name text; region_code text; wd_id int +PK; ibge_id int +PK4; lexLabel ascii text +PK3; isCurrent boolean; info JSONb{bg:tomato}]

[region|code ascii text +PK2;temporalCoverage +PK3; name text;fullname text;wd_id int +PK;lexLabel ascii text  +PK3;isCurrent boolean; info JSONb]

[city|name text;state_code ascii text +PK2;temporalCoverage +PK2; wd_id int +PK;ibge_id int +PK3;lexLabel ascii text +PK2;isCurrent boolean; info JSONb{bg:sandybrown}]

[wd_synonym|name text +PK; synonym_type ascii text  +PK;wd_id int +PK;ref;isOfficial boolean;info JSONb]

[state]2..*---1[region]
[city]1..*--->in[state]

[wd_synonym]*----1[state]
[wd_synonym]*----1[city]
[wd_synonym]*----1[region]
ppKrauss commented 6 years ago

Movendo para projeto separado para não confundir dadasets com suas tools, https://github.com/datasets-br/datasets-br