Stations

official_name
Official name
name
Name
name_locative
Name in locative
station_id
Station numeric ID
xml_id
Station text ID
elevation
Elevation
longitude
Longitude
latitude
Latitude

14 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ official_name name name_locative station_id xml_id elevation longitude latitude
1 1 Bilje Nova Gorica v Novi Gorici 1402 NOVA-GOR_BILJE 55 13.628606 45.895872
2 2 Celje Medlog Celje v Celju 1025 CELJE_MEDLOG 242 15.230694 46.236887
3 3 Kočevje Kočevje v Kočevju 1426 KOCEVJE 468 14.854372 45.646079
4 4 Kredarica Kredarica na Kredarici 1430 KREDA-ICA 2513 13.853571 46.379059
5 5 Lesce Lesce v Lescah 1034 LESCE 509 14.17649 46.362333
6 6 Letališče Portorož Portorož v Portorožu 1008 PORTOROZ_SECOVLJE 2 13.620635 45.475612
7 7 Lisca Lisca na Lisci 1435 LISCA 947 15.289718 46.068059
8 8 Ljubljana Bežigrad Ljubljana v Ljubljani 1495 LJUBL-ANA_BEZIGRAD 299 14.517092 46.065813
9 9 Maribor Vrbanski plato Maribor v Mariboru 1491 MARIBOR_VRBAN-PLA 279 15.630923 46.568108
10 10 Novo mesto Novo mesto v Novem mestu 1447 NOVO-MES 220 15.18206 45.80208
11 11 Postojna Postojna v Postojni 1455 POSTOJNA 538 14.201984 45.772531
12 12 Rakičan Murska Sobota v Murski Soboti 1444 MURSK-SOB 187 16.196241 46.652401
13 13 Vogel Vogel na Voglu 1481 VOGEL 1515 13.84428 46.259784
14 14 Šmartno pri Slovenj Gradcu Šmartno pri Slovenj Gradcu v Šmartnem pri Slovenj Gradcu 1471 SLOVE-GRA 444 15.11605 46.489897

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "temperature.slovenia_stations" (
   "official_name" TEXT,
   "name" TEXT,
   "name_locative" TEXT,
   "station_id" INTEGER,
   "xml_id" TEXT,
   "elevation" INTEGER,
   "longitude" REAL,
   "latitude" REAL
);