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 |