|
|
# DeStatis fetcher
|
|
|
|
|
|
## Website
|
|
|
|
|
|
To get a preview of a datacube (ex: 51000BJ001), follow:
|
|
|
- click on "Themes" link (in "Available data" menu)
|
|
|
- Select given theme (here 51 "Foreign Trade")
|
|
|
- Click on "Time series icon"
|
|
|
- Click on chosen datacube (here 51000BJ001)
|
|
|
- Click on "Value Retrieval" button
|
|
|
|
|
|
## Glossary
|
|
|
- Wert: value
|
|
|
- Fall: default value
|
... | ... | @@ -35,5 +44,17 @@ and datacube value file: |
|
|
curl "https://www-genesis.destatis.de/genesisWS/web/ExportService_2010?method=DatenExport&kennung={USER_NAME}&passwort={PASSWORD}&namen={DATACUBE_CODE}&bereich=Alle&format=csv&werte=true&metadaten=false&zusatz=false&startjahr=&endjahr=&zeitscheiben=&inhalte=®ionalmerkmal=®ionalschluessel=&sachmerkmal=&sachschluessel=&sachmerkmal2=&sachschluessel2=&sachmerkmal3=&sachschluessel3=&stand=&sprache=en" -o {CAT}/{DATACUBE_CODE}.xml
|
|
|
```
|
|
|
|
|
|
## Convert
|
|
|
|
|
|
Gets all unique unit values from structure xml files:
|
|
|
|
|
|
```
|
|
|
xmlstarlet sel -t -m "//merkmale[art='I']" -v "concat('=',masseinheit,'=')" */*.structure.xml | sed -e $'s/==*/\\\n/g' | sort -u
|
|
|
```
|
|
|
|
|
|
Gets all unique types of period values:
|
|
|
|
|
|
```
|
|
|
xmlstarlet sel -t -m "//zeitraum" -v "concat('=',.,'=')" */*.structure.xml | sed -e $'s/==*/\\\n/g' | sort -u
|
|
|
```
|
|
|
|