Teknofest Model Sattelite Data Set Example
Example of dataset with actual values measured with RasPi and some sensors
@kaggle.sabrihakandemirba_teknofest_model_sattelite_data_set_example
Organized Data
@kaggle.sabrihakandemirba_teknofest_model_sattelite_data_set_example.organized_data
- 17.49 KB
- 340 rows
- 20 columns
paket_numarasiPaket Numarasi | uydu_statusuUydu Statusu | hata_koduHata Kodu | gonderme_saatGonderme Saat | basinc1Basinc1 | basinc2Basinc2 | yukseklik1Yukseklik1 | yukseklik2Yukseklik2 | irtifa_farkiIrtifa Farki | inis_hiziInis Hizi | sicaklikSicaklik | pil_gerilimPil Gerilim | gps_latitudeGps Latitude | gps_longitudeGps Longitude | gps_altitudeGps Altitude | pitchPitch | yawYaw | rollRoll | takim_noTakim No | video_aktarim_bilgisiVideo Aktarim Bilgisi |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1/0/0/0/0 | Time | 92725 | 741.93 | 741.93 | -0.6200000000000045 | 16 | 39.94623715221963 | 32.69056253482102 | 134101 | 2 | ||||||||
| 1 | 1/1/0/0/0 | Time | 92731 | 741.4 | 741.4 | 0.4400000000000545 | 16 | 39.94623715221963 | 32.69056253482102 | 134101 | 2 | ||||||||
| 1 | 1/0/0/0/0 | Time | 92718 | 742.56 | 742.56 | -0.8099999999999454 | 16.1 | 39.94623715221963 | 32.69056253482102 | 134101 | 2 | ||||||||
| 4 | 1/1/0/0/0 | Time | 92727 | 741.75 | 741.75 | 0.0900000000000318 | 16.1 | 39.94623715221963 | 32.69056253482102 | 134101 | 2 | ||||||||
| 5 | 1/1/0/0/0 | Time | 92728 | 741.66 | 741.66 | 0.0900000000000318 | 16.2 | 39.94623715221963 | 32.69056253482102 | 134101 | 2 | ||||||||
| 6 | 1/0/0/0/0 | Time | 92726 | 741.84 | 741.84 | -0.1800000000000636 | 16.2 | 39.94623715221963 | 32.69056253482102 | 134101 | 2 | ||||||||
| 7 | 1/1/0/0/0 | Time | 92730 | 741.49 | 741.49 | 0.3500000000000227 | 16.2 | 39.94623715221963 | 32.69056253482102 | 134101 | 2 | ||||||||
| 8 | 1/0/0/0/0 | Time | 92722 | 742.2 | 742.2 | -0.7100000000000364 | 16.2 | 39.94623715221963 | 32.69056253482102 | 134101 | 2 | ||||||||
| 9 | 1/1/0/0/0 | Time | 92727 | 741.75 | 741.75 | 0.4500000000000455 | 16.2 | 39.94623715221963 | 32.69056253482102 | 134101 | 2 | ||||||||
| 10 | 1/0/0/0/0 | Time | 92725 | 741.93 | 741.93 | -0.1799999999999499 | 16.1 | 39.94623715221963 | 32.69056253482102 | 134101 | 2 |
CREATE TABLE organized_data (
"paket_numarasi" BIGINT,
"uydu_statusu" BIGINT,
"hata_kodu" VARCHAR,
"gonderme_saat" VARCHAR,
"basinc1" BIGINT,
"basinc2" BIGINT,
"yukseklik1" DOUBLE,
"yukseklik2" BIGINT,
"irtifa_farki" DOUBLE,
"inis_hizi" DOUBLE,
"sicaklik" DOUBLE,
"pil_gerilim" BIGINT,
"gps_latitude" DOUBLE,
"gps_longitude" DOUBLE,
"gps_altitude" BIGINT,
"pitch" DOUBLE,
"yaw" DOUBLE,
"roll" DOUBLE,
"takim_no" BIGINT,
"video_aktarim_bilgisi" DOUBLE
);