UBoard Data Dictionary - OCR BMKG
UGEMS Data Dictionary – OCR BMKG
ocr_process
ocr_process merupakan tabel yang berisi histori dokumen yang berhasil diproses ocr.
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
filename |
varchar(255) |
255 |
|
file name |
20230110 AWSKGB_3h.pdf |
|
category |
varchar(25) |
25 |
|
file category |
daily |
|
processed_time |
timestamp(6) |
|
|
processed time |
1/19/2023 13:27 |
|
ocr_daily
ocr_daily merupakan tabel yang berisi raw data hasil proses ocr untuk file dokumen yang mengandung nama *_3hr.pdf
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
Waktu |
varchar(32) |
32 |
|
time format |
01.00 |
|
Cuaca |
text |
|
|
weather forecast |
Cerah Berawan |
|
Suhu_celcius |
float8 |
53 |
|
temperature forecast (celcius) |
22.4 |
|
RH_percentage |
float8 |
53 |
|
relative humidity forecast (percentage) |
100 |
|
ArahAngin |
text |
|
|
wind direction forecast |
Utara |
|
KecepatanAngin_kmh |
float8 |
53 |
|
wind velocity forecast (km/h) |
3 |
|
Visibility |
text |
|
|
visibility forecast |
<1 |
|
IntensitasCurahHujan_mm |
float8 |
53 |
|
rainfall intensity forecast |
0 |
|
DurasiHujan_hour |
float8 |
53 |
|
rain duration (hour) |
1 |
|
Tanggal |
varchar(32) |
32 |
|
forecast date |
Rabu, 11 Januari 2023 |
|
PublishDate |
varchar(128) |
128 |
|
publish date |
Selasa, 10 Januari 2023 |
|
SiteLocation |
varchar(128) |
128 |
|
forecast location |
AWS KGB |
|
ProcTime |
timestamp(6) |
|
|
processing time |
1/19/2023 13:27 |
|
fact_bmkg_daily
fact_bmkg_daily merupakan tabel staging dari tabel ocr_daily yang sudah di cleansing dan disesuaikan tipe datanya
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
Lokasi |
varchar(128) |
128 |
|
forecast location |
AWS KGB |
|
Tahun |
int4 |
32 |
|
forecast year |
2,023 |
|
Bulan |
int4 |
32 |
|
forecast month |
1 |
|
Minggu |
int4 |
32 |
|
forecast week |
2 |
|
Hari |
int4 |
32 |
|
forecast day |
11 |
|
Waktu |
numeric(15, 2) |
|
|
time format int (hour) |
1 |
|
Cuaca |
text |
|
|
weather forecast |
Cerah Berawan |
|
Suhu_celcius |
numeric(15, 2) |
|
|
temperature forecast (celcius) |
22.4 |
|
RH_persen |
float8 |
53 |
|
relative humidity forecast (percentage) |
100 |
|
ArahAngin |
text |
|
|
wind direction forecast |
Utara |
|
KecepatanAngin_kmh |
numeric(15, 2) |
|
|
wind velocity forecast (km/h) |
3 |
|
Visibilitas |
text |
|
|
visibility forecast |
<1 |
|
CurahHujan_mm |
numeric(15, 2) |
|
|
rainfall forecast |
0 |
|
IntensitasCurahHujan_mm_jam |
numeric(15, 2) |
|
|
rainfall intensity forecast |
0 |
|
DurasiHujan_jam |
numeric(15, 2) |
|
|
rain duration (hour) |
1 |
|
Tanggal |
date |
|
|
forecast date |
1/11/2023 |
|
TanggalPublish |
date |
|
|
publish date |
1/10/2023 |
|
ProcTime |
timestamp(6) |
|
|
processing time |
1/19/2023 13:27 |
|
fact_bmkg_daily_char
fact_bmkg_daily_char merupakan merupakan tabel datamart dari tabel fact_bmkg_daily yang sudah diformat tertentu dan difilter hanya parameter cuaca yang bertipe string saja
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
Lokasi |
varchar(128) |
128 |
sbx_bmkg.fact_bmkg_daily |
location forecast |
PASOPATI |
|
Tahun |
int4 |
32 |
sbx_bmkg.fact_bmkg_daily |
year forecast |
2,023 |
|
Bulan |
int4 |
32 |
sbx_bmkg.fact_bmkg_daily |
month forecast |
1 |
|
Minggu |
int4 |
32 |
sbx_bmkg.fact_bmkg_daily |
week forecast |
4 |
|
Hari |
int4 |
32 |
sbx_bmkg.fact_bmkg_daily |
day forecast |
23 |
|
Tanggal |
date |
32 |
sbx_bmkg.fact_bmkg_daily |
date forecast |
1/23/2023 |
|
Parameter |
text |
|
sbx_bmkg.fact_bmkg_daily |
meteorological parameters (string only) |
Visibilitas |
|
Jam_01.00 |
text |
|
sbx_bmkg.fact_bmkg_daily |
parameters value at 1 am |
>10 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_01.00' then "parameters_jam" end) as "Jam_01.00" |
Jam_04.00 |
text |
|
sbx_bmkg.fact_bmkg_daily |
parameters value at 4 am |
>10 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_04.00' then "parameters_jam" end) as "Jam_04.00" |
Jam_07.00 |
text |
|
sbx_bmkg.fact_bmkg_daily |
parameters value at 7 am |
<1 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_07.00' then "parameters_jam" end) as "Jam_07.00" |
Jam_10.00 |
text |
|
sbx_bmkg.fact_bmkg_daily |
parameters value at 10 am |
<1 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_10.00' then "parameters_jam" end) as "Jam_10.00" |
Jam_13.00 |
text |
|
sbx_bmkg.fact_bmkg_daily |
parameters value at 1 pm |
<1 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_13.00' then "parameters_jam" end) as "Jam_13.00" |
Jam_16.00 |
text |
|
sbx_bmkg.fact_bmkg_daily |
parameters value at 4 pm |
<1 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_16.00' then "parameters_jam" end) as "Jam_16.00" |
Jam_19.00 |
text |
|
sbx_bmkg.fact_bmkg_daily |
parameters value at 7 pm |
<1 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_19.00' then "parameters_jam" end) as "Jam_19.00" |
Jam_22.00 |
text |
|
sbx_bmkg.fact_bmkg_daily |
parameters value at 10 pm |
<1 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_22.00' then "parameters_jam" end) as "Jam_22.00" |
fact_bmkg_daily_char_unpivot
fact_bmkg_daily_char_unpivot merupakan merupakan tabel datamart dari tabel fact_bmkg_daily yang sudah diformat tertentu dan difilter hanya parameter cuaca yang bertipe string saja
fact_bmkg_daily_num
fact_bmkg_daily_num merupakan merupakan tabel datamart dari tabel fact_bmkg_daily yang sudah diformat tertentu dan difilter hanya parameter cuaca yang bertipe numerik saja
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
Lokasi |
varchar(128) |
128 |
sbx_bmkg.fact_bmkg_daily |
location forecast |
AWS KGU |
|
Tahun |
int4 |
32 |
sbx_bmkg.fact_bmkg_daily |
year forecast |
2,023 |
|
Bulan |
int4 |
32 |
sbx_bmkg.fact_bmkg_daily |
month forecast |
1 |
|
Minggu |
int4 |
32 |
sbx_bmkg.fact_bmkg_daily |
week forecast |
2 |
|
Hari |
int4 |
32 |
sbx_bmkg.fact_bmkg_daily |
day forecast |
13 |
|
Tanggal |
date |
32 |
sbx_bmkg.fact_bmkg_daily |
date forecast |
1/13/2023 |
|
Parameter |
text |
|
sbx_bmkg.fact_bmkg_daily |
meteorological parameters (numeric only) |
Intensitas Curah Hujan |
|
Jam_01.00 |
text |
|
sbx_bmkg.fact_bmkg_daily |
parameters value at 1 am |
0 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_01.00' then "parameters_jam" end) as "Jam_01.00" |
Jam_04.00 |
text |
|
sbx_bmkg.fact_bmkg_daily |
parameters value at 4 am |
0 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_04.00' then "parameters_jam" end) as "Jam_04.00" |
Jam_07.00 |
text |
|
sbx_bmkg.fact_bmkg_daily |
parameters value at 7 am |
0 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_07.00' then "parameters_jam" end) as "Jam_07.00" |
Jam_10.00 |
text |
|
sbx_bmkg.fact_bmkg_daily |
parameters value at 10 am |
0.75 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_10.00' then "parameters_jam" end) as "Jam_10.00" |
Jam_13.00 |
text |
|
sbx_bmkg.fact_bmkg_daily |
parameters value at 1 pm |
1.72 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_13.00' then "parameters_jam" end) as "Jam_13.00" |
Jam_16.00 |
text |
|
sbx_bmkg.fact_bmkg_daily |
parameters value at 4 pm |
0.33 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_16.00' then "parameters_jam" end) as "Jam_16.00" |
Jam_19.00 |
text |
|
sbx_bmkg.fact_bmkg_daily |
parameters value at 7 pm |
5.81 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_19.00' then "parameters_jam" end) as "Jam_19.00" |
Jam_22.00 |
text |
|
sbx_bmkg.fact_bmkg_daily |
parameters value at 10 pm |
0 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_22.00' then "parameters_jam" end) as "Jam_22.00" |
fact_bmkg_daily_num_unpivot
fact_bmkg_daily_num_unpivot merupakan merupakan tabel datamart dari tabel fact_bmkg_daily yang sudah diformat tertentu dan difilter hanya parameter cuaca yang bertipe numerik saja
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
Lokasi |
varchar(128) |
128 |
sbx_bmkg.fact_bmkg_daily |
location forecast |
AWS KGB |
|
Tahun |
int4 |
32 |
sbx_bmkg.fact_bmkg_daily |
year forecast |
2,023 |
|
Bulan |
int4 |
32 |
sbx_bmkg.fact_bmkg_daily |
month forecast |
1 |
|
Minggu |
int4 |
32 |
sbx_bmkg.fact_bmkg_daily |
week forecast |
3 |
|
Hari |
int4 |
32 |
sbx_bmkg.fact_bmkg_daily |
day forecast |
17 |
|
Tanggal |
date |
|
sbx_bmkg.fact_bmkg_daily |
date forecast |
1/17/2023 |
|
TanggalPublish |
date |
|
sbx_bmkg.fact_bmkg_daily |
date publish |
1/17/2023 |
|
Waktu |
numeric(15, 2) |
|
sbx_bmkg.fact_bmkg_daily |
time format int(hour) |
19 |
|
WaktuFormatted |
text |
|
sbx_bmkg.fact_bmkg_daily |
time format jam_hh.00 |
19.00 |
concat(to_char(fbd."Waktu", 'fm00'), '.00') |
Parameter |
text |
|
sbx_bmkg.fact_bmkg_daily |
meteorological parameters (only numeric) |
Kecepatan Angin KM/H |
|
ForecastValue |
text |
|
sbx_bmkg.fact_bmkg_daily |
forecast value |
1.61 |
|
ActualValue |
text |
|
sbx_bmkg.fact_bmkg_daily |
actual value |
[NULL] |
|
ocr_offshore
ocr_offshore merupakan tabel yang berisi raw data hasil proses ocr untuk file dokumen yang mengandung nama BMKG-WeatherForecast.*.pdf
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
Time |
varchar(8) |
8 |
|
time format |
08 |
|
WX |
text |
|
|
|
MOD RA |
|
Visibility |
text |
|
|
visibility forecast |
Clear |
|
Winds_10m_dir |
text |
|
|
|
SW |
|
Winds_10m_spd |
text |
|
|
|
8 |
|
Winds_10m_gust |
text |
|
|
|
12 |
|
Winds_50m_spd |
text |
|
|
|
9 |
|
Waves_total_dir |
text |
|
|
|
SSW |
|
Waves_total_hsig |
text |
|
|
|
0.3 |
|
Waves_total_hmax |
text |
|
|
|
0.5 |
|
Waves_swell_dir |
text |
|
|
|
- |
|
Waves_swell_hgt |
text |
|
|
|
No Swell |
|
Waves_swell_per |
text |
|
|
|
- |
|
Current_surface_dir |
text |
|
|
|
ESE |
|
Current_surface_spd |
text |
|
|
|
6 |
|
Temp_surface_sea |
text |
|
|
|
30.0 |
|
Date |
varchar(32) |
32 |
|
forecast date |
Tuesday, 13 December 2022 |
|
IssuedDate |
varchar(128) |
128 |
|
publish date |
13-Dec-22 |
|
SiteLocation |
varchar(128) |
128 |
|
forecast location |
Borneo Indobara, Anchorage Bunati |
|
ProcTime |
timestamp(6) |
|
|
processing time |
1/11/2023 11:56 |
|
fact_bmkg_offshore
fact_bmkg_offshore merupakan tabel staging dari tabel ocr_offshore yang sudah di cleansing dan disesuaikan tipe datanya
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
Tahun |
int4 |
32 |
|
forecast year |
2,022 |
|
Bulan |
int4 |
32 |
|
forecast month |
12 |
|
Minggu |
int4 |
32 |
|
forecast week |
50 |
|
Hari |
int4 |
32 |
|
forecast day |
13 |
|
Lokasi |
varchar(128) |
128 |
|
forecast location |
Borneo Indobara, Anchorage Bunati |
|
Waktu |
numeric(15, 2) |
|
|
time format int (hour) |
8 |
|
WX |
text |
|
|
|
MOD RA |
|
Visibility |
text |
|
|
visibility forecast |
Clear |
|
Winds_10m_dir |
text |
|
|
|
SW |
|
Winds_10m_spd |
text |
|
|
|
8 |
|
Winds_10m_gust |
text |
|
|
|
12 |
|
Winds_50m_spd |
text |
|
|
|
9 |
|
Waves_total_dir |
text |
|
|
|
SSW |
|
Waves_total_hsig |
numeric(15, 2) |
|
|
|
0.3 |
|
Waves_total_hmax |
numeric(15, 2) |
|
|
|
0.5 |
|
Waves_swell_dir |
text |
|
|
|
[NULL] |
|
Waves_swell_hgt |
numeric(15, 2) |
|
|
|
[NULL] |
|
Waves_swell_per |
numeric(15, 2) |
|
|
|
[NULL] |
|
Current_surface_dir |
text |
|
|
|
ESE |
|
Current_surface_spd |
int4 |
32 |
|
|
6 |
|
Temp_surface_sea |
numeric(15, 2) |
|
|
|
30 |
|
Tanggal |
date |
|
|
forecast date |
12/13/2022 |
|
TanggalInteger |
int4 |
32 |
|
|
20,221,213 |
|
TanggalPublish |
date |
|
|
publish date |
12/13/2022 |
|
ProcTime |
timestamp(6) |
|
|
processing time |
1/11/2023 11:56 |
|
fact_bmkg_offshore_char
fact_bmkg_offshore_char merupakan tabel datamart dari tabel fact_bmkg_offshore yang sudah diformat tertentu dan difilter hanya parameter cuaca yang bertipe string saja
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
Lokasi |
varchar(128) |
128 |
sbx_bmkg.fact_bmkg_offshore |
location forecast |
Borneo Indobara, Anchorage Bunati |
|
Tahun |
int4 |
32 |
sbx_bmkg.fact_bmkg_offshore |
year forecast |
2,023 |
|
Bulan |
int4 |
32 |
sbx_bmkg.fact_bmkg_offshore |
month forecast |
1 |
|
Minggu |
int4 |
32 |
sbx_bmkg.fact_bmkg_offshore |
week forecast |
2 |
|
Hari |
int4 |
32 |
sbx_bmkg.fact_bmkg_offshore |
day forecast |
9 |
|
Tanggal |
date |
32 |
sbx_bmkg.fact_bmkg_offshore |
date forecast |
1/9/2023 |
|
Parameter |
text |
|
sbx_bmkg.fact_bmkg_offshore |
meteorological parameters (only string) |
Waves Swell Dir |
|
Jam_02.00 |
text |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value at 2 am |
WSW |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_02.00' then "parameters_jam" end) as "Jam_02.00" |
Jam_05.00 |
text |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value at 5 am |
WSW |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_05.00' then "parameters_jam" end) as "Jam_05.00" |
Jam_08.00 |
text |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value at 8 am |
WSW |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_08.00' then "parameters_jam" end) as "Jam_08.00" |
Jam_11.00 |
text |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value at 11 am |
WSW |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_11.00' then "parameters_jam" end) as "Jam_11.00" |
Jam_14.00 |
text |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value at 2 pm |
WSW |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_14.00' then "parameters_jam" end) as "Jam_14.00" |
Jam_17.00 |
text |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value at 5 pm |
WSW |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_17.00' then "parameters_jam" end) as "Jam_17.00" |
Jam_20.00 |
text |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value at 8 pm |
WSW |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_20.00' then "parameters_jam" end) as "Jam_20.00" |
Jam_23.00 |
text |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value at 11 pm |
WSW |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_23.00' then "parameters_jam" end) as "Jam_23.00" |
fact_bmkg_offshore_char_unpivot
fact_bmkg_offshore_char_unpivot merupakan tabel datamart dari tabel fact_bmkg_offshore yang sudah diformat tertentu dan difilter hanya parameter cuaca yang bertipe string saja
fact_bmkg_offshore_num
fact_bmkg_offshore_num merupakan tabel datamart dari tabel fact_bmkg_offshore yang sudah diformat tertentu dan difilter hanya parameter cuaca yang bertipe numerik saja
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
Lokasi |
varchar(128) |
128 |
sbx_bmkg.fact_bmkg_offshore |
location forecast |
Borneo Indobara, Anchorage Bunati |
|
Tahun |
int4 |
32 |
sbx_bmkg.fact_bmkg_offshore |
year forecast |
2,022 |
|
Bulan |
int4 |
32 |
sbx_bmkg.fact_bmkg_offshore |
month forecast |
12 |
|
Minggu |
int4 |
32 |
sbx_bmkg.fact_bmkg_offshore |
week forecast |
52 |
|
Hari |
int4 |
32 |
sbx_bmkg.fact_bmkg_offshore |
day forecast |
30 |
|
Tanggal |
date |
|
sbx_bmkg.fact_bmkg_offshore |
date forecast |
12/30/2022 |
|
Parameter |
text |
|
sbx_bmkg.fact_bmkg_offshore |
meteorological parameters (only numeric) |
Waves Swell Height |
|
Jam_02.00 |
numeric |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value at 2 am |
[NULL] |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_02.00' then "parameters_jam" end) as "Jam_02.00" |
Jam_05.00 |
numeric |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value at 5 am |
[NULL] |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_05.00' then "parameters_jam" end) as "Jam_05.00" |
Jam_08.00 |
numeric |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value at 8 am |
0.5 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_08.00' then "parameters_jam" end) as "Jam_08.00" |
Jam_11.00 |
numeric |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value at 11 am |
0.5 |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_11.00' then "parameters_jam" end) as "Jam_11.00" |
Jam_14.00 |
numeric |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value at 2 pm |
[NULL] |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_14.00' then "parameters_jam" end) as "Jam_14.00" |
Jam_17.00 |
numeric |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value at 5 pm |
[NULL] |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_17.00' then "parameters_jam" end) as "Jam_17.00" |
Jam_20.00 |
numeric |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value at 8 pm |
[NULL] |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_20.00' then "parameters_jam" end) as "Jam_20.00" |
Jam_23.00 |
numeric |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value at 11 pm |
[NULL] |
max(case when concat('Jam_', to_char(fbd."Waktu", 'fm00'), '.00') = 'Jam_23.00' then "parameters_jam" end) as "Jam_23.00" |
fact_bmkg_offshore_num_unpivot
fact_bmkg_offshore_num_unpivot merupakan tabel datamart dari tabel fact_bmkg_offshore yang sudah diformat tertentu dan difilter hanya parameter cuaca yang bertipe numerik saja
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
Lokasi |
varchar(128) |
128 |
sbx_bmkg.fact_bmkg_offshore |
location forecast |
Borneo Indobara, Anchorage Bunati |
|
Tahun |
int4 |
32 |
sbx_bmkg.fact_bmkg_offshore |
year forecast |
2,023 |
|
Bulan |
int4 |
32 |
sbx_bmkg.fact_bmkg_offshore |
month forecast |
1 |
|
Minggu |
int4 |
32 |
sbx_bmkg.fact_bmkg_offshore |
week forecast |
3 |
|
Hari |
int4 |
32 |
sbx_bmkg.fact_bmkg_offshore |
day forecast |
17 |
|
Tanggal |
date |
|
sbx_bmkg.fact_bmkg_offshore |
date forecast |
1/17/2023 |
|
TanggalPublish |
date |
|
sbx_bmkg.fact_bmkg_offshore |
date publish |
1/17/2023 |
|
Waktu |
numeric(15, 2) |
|
sbx_bmkg.fact_bmkg_offshore |
time format int(hour) |
11 |
|
WaktuFormatted |
text |
|
sbx_bmkg.fact_bmkg_offshore |
time format jam_hh.00 |
11 |
concat(to_char(fbd."Waktu", 'fm00'), '.00') |
Parameter |
text |
|
sbx_bmkg.fact_bmkg_offshore |
meteorological parameters (only numeric) |
Temp Surface Sea |
|
ForecastValue |
text |
|
sbx_bmkg.fact_bmkg_offshore |
forecast value |
29 |
|
ActualValue |
text |
|
sbx_bmkg.fact_bmkg_offshore |
actual value |
[NULL] |
|
ocr_weekly
ocr_weekly merupakan yang berisi raw data hasil proses ocr untuk file dokumen yang mengandung nama *_24hr.pdf
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
Tanggal |
varchar(32) |
32 |
|
forecast date |
16 Januari |
|
Cuaca |
text |
|
|
weather forecast |
Hujan Ringan |
|
Suhu_celcius |
float8 |
53 |
|
temperature forecast (celcius) |
22 - 31 |
|
RH_percentage |
float8 |
53 |
|
relative humidity forecast (percentage) |
62 - 100 |
|
ArahAngin |
text |
|
|
wind direction forecast |
U |
|
KecepatanAngin_kmh |
float8 |
53 |
|
wind velocity forecast (km/h) |
5.8 |
|
Visibility |
text |
|
|
visibility forecast |
5 - 7 |
|
IntensitasCurahHujan_mm |
float8 |
53 |
|
rainfall intensity forecast |
4.3 |
|
DurasiHujan_hour |
float8 |
53 |
|
rain duration (hour) |
3 |
|
SiteLocation |
varchar(128) |
128 |
|
forecast location |
AWS KGB |
|
PublishDate |
varchar(128) |
128 |
|
publish date |
Senin, 16 Januari 2023 |
|
ProcTime |
timestamp(6) |
|
|
processing time |
1/15/2023 23:32 |
|
fact_bmkg_weekly
fact_bmkg_weekly merupakan tabel staging dari tabel ocr_offshore yang sudah di cleansing dan disesuaikan tipe datanya
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
Lokasi |
varchar(128) |
128 |
|
forecast location |
AWS KGB |
|
Tahun |
int4 |
32 |
|
forecast year |
2,022 |
|
Bulan |
int4 |
32 |
|
forecast month |
12 |
|
Minggu |
int4 |
32 |
|
forecast week |
51 |
|
Hari |
int4 |
32 |
|
forecast day |
19 |
|
Cuaca |
text |
|
|
weather forecast |
Cerah Berawan |
|
Suhu_celcius |
text |
|
|
temperature forecast (celcius) |
22 - 30 |
|
Suhu_celcius_min |
text |
|
|
temperature forecast (celcius) min |
22 |
|
Suhu_celcius_max |
text |
|
|
temperature forecast (celcius) max |
30 |
|
RH_persen |
text |
|
|
relative humidity forecast (percentage) |
65 - 100 |
|
RH_persen_min |
text |
|
|
relative humidity forecast (percentage) min |
65 |
|
RH_persen_max |
text |
|
|
relative humidity forecast (percentage) max |
100 |
|
ArahAngin |
text |
|
|
wind direction forecast |
B |
|
KecepatanAngin_kmh |
numeric(15, 2) |
|
|
wind velocity forecast (km/h) |
6.5 |
|
Visibilitas |
text |
|
|
visibility forecast |
7 - 10 |
|
Visibilitas_min |
text |
|
|
visibility forecast min |
7 |
|
visibilitas_max |
text |
|
|
visibility forecast max |
10 |
|
CurahHujan_mm |
numeric(15, 2) |
|
|
rainfall forecast |
0 |
|
IntensitasCurahHujan_mm_jam |
numeric(15, 2) |
|
|
rainfall intensity forecast |
0 |
|
DurasiHujan_jam |
numeric(15, 2) |
|
|
rain duration (hour) |
0 |
|
Tanggal |
date |
|
|
forecast date |
12/19/2022 |
|
TanggalPublish |
date |
|
|
publish date |
12/19/2022 |
|
ProcTime |
timestamp(6) |
|
|
processing time |
1/11/2023 11:56 |
|
fact_bmkg_weekly_char
fact_bmkg_weekly_char merupakan tabel datamart dari tabel fact_bmkg_weekly yang sudah diformat tertentu dan difilter hanya parameter cuaca yang bertipe string saja
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
Lokasi |
varchar(128) |
128 |
sbx_bmkg.fact_bmkg_weekly |
forecast location |
PASOPATI |
|
Tahun |
int4 |
32 |
sbx_bmkg.fact_bmkg_weekly |
forecast year |
2,023 |
|
Bulan |
int4 |
32 |
sbx_bmkg.fact_bmkg_weekly |
forecast month |
1 |
|
Minggu |
int4 |
32 |
sbx_bmkg.fact_bmkg_weekly |
forecast week |
2 |
|
Hari |
int4 |
32 |
sbx_bmkg.fact_bmkg_weekly |
forecast day |
12 |
|
Tanggal |
date |
|
sbx_bmkg.fact_bmkg_weekly |
forecast date |
1/12/2023 |
|
TanggalPublish |
date |
|
sbx_bmkg.fact_bmkg_weekly |
publish date |
1/9/2023 |
|
Parameter |
text |
|
sbx_bmkg.fact_bmkg_weekly |
meteorological parameters (only char) |
Arah Angin |
|
ForecastValue |
text |
|
sbx_bmkg.fact_bmkg_weekly |
forecast value |
BL |
|
ActualValue |
text |
|
sbx_bmkg.fact_bmkg_weekly |
actual value |
[NULL] |
|
fact_bmkg_weekly_num
fact_bmkg_weekly_num merupakan tabel datamart dari tabel fact_bmkg_weekly yang sudah diformat tertentu dan difilter hanya parameter cuaca yang bertipe numerik saja
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
Lokasi |
varchar(128) |
128 |
sbx_bmkg.fact_bmkg_weekly |
location forecast |
AWS KGB |
|
Tahun |
int4 |
32 |
sbx_bmkg.fact_bmkg_weekly |
year forecast |
2,023 |
|
Bulan |
int4 |
32 |
sbx_bmkg.fact_bmkg_weekly |
month forecast |
1 |
|
Minggu |
int4 |
32 |
sbx_bmkg.fact_bmkg_weekly |
week forecast |
3 |
|
Hari |
int4 |
32 |
sbx_bmkg.fact_bmkg_weekly |
day forecast |
19 |
|
Tanggal |
date |
|
sbx_bmkg.fact_bmkg_weekly |
date forecast |
1/19/2023 |
|
TanggalPublish |
date |
|
sbx_bmkg.fact_bmkg_weekly |
date publish |
1/16/2023 |
|
Parameter |
numeric(15, 2) |
|
sbx_bmkg.fact_bmkg_weekly |
meteorological parameters (only numeric) |
Suhu Celcius |
|
ForecastValue |
text |
|
sbx_bmkg.fact_bmkg_weekly |
forecast value |
23 - 29 |
|
ActualValue |
text |
|
sbx_bmkg.fact_bmkg_weekly |
actual value |
[NULL] |
|
fact_bmkg_weekly_num_day
fact_bmkg_weekly_num_day merupakan tabel datamart dari tabel fact_bmkg_weekly yang sudah diformat tertentu dan difilter hanya parameter cuaca yang bertipe numerik saja
Nama |
Tipe Data |
Length |
Source |
Deskripsi |
Sample |
Formula |
Lokasi |
varchar(128) |
128 |
sbx_bmkg.fact_bmkg_weekly |
forecast location |
AWS KGB |
|
Tahun |
int4 |
32 |
sbx_bmkg.fact_bmkg_weekly |
forecast year |
2,022 |
|
Bulan |
int4 |
32 |
sbx_bmkg.fact_bmkg_weekly |
forecast month |
12 |
|
Minggu |
int4 |
32 |
sbx_bmkg.fact_bmkg_weekly |
forecast week |
51 |
|
Hari |
int4 |
32 |
sbx_bmkg.fact_bmkg_weekly |
forecast day |
19 |
|
Tanggal |
date |
|
sbx_bmkg.fact_bmkg_weekly |
forecast date |
12/19/2022 |
|
TanggalPublish |
date |
|
sbx_bmkg.fact_bmkg_weekly |
publish date |
12/19/2022 |
|
Parameter |
numeric(15, 2) |
|
sbx_bmkg.fact_bmkg_weekly |
meteorological parameters (only numeric) |
Suhu Celcius |
|
ForecastValue |
text |
|
sbx_bmkg.fact_bmkg_weekly |
forecast value |
22 - 30 |
|
ActualValue |
text |
|
sbx_bmkg.fact_bmkg_weekly |
actual value |
[NULL] |
|
Day Name |
text |
|
sbx_bmkg.fact_bmkg_weekly |
day name |
Monday |
|
Day Num |
int4 |
|
sbx_bmkg.fact_bmkg_weekly |
day number |
1 |
|
Data Rainfall Actual
Data Rainfall Actual merupakan data aktual curah hujan dan durasi hujan dengan periode harian yang akan diupload secara manual oleh user.
| Nama | Tipe Data | Length | Source | Deskripsi | Sample | Formula |
| Lokasi | text | location actual | AWS KGB | |||
| Year | integer | 4 | year actual | 2023 | ||
| Month | integer | 2 | month actual | 3 | ||
| Date | integer | 2 | date actual | 1 | ||
| Curah Hujan (mm) | float8 | 4 | rainfall (mm) | 7.09 | ||
| Durasi Hujan (Jam) | float8 | 4 | rain duration (Jam) | 2.72 | ||
| Intensitas Curah Hujan | float8 | 4 | rainfall intensity forecast | 0.61 | IFERROR((Curah Hujan/24)*((24/Durasi Hujan)^(2/3)); 0) | |