KIPOT_DB

Tables (38)

avg_road_data

  • id — bigint — NOT NULL
  • road_msg — character — 구간별
  • road_traffic_idx — character — 구간별
  • road_traffic_spd — double — 구간별
  • road_traffic_time — character — 도로
  • kt_meta_detail_id — bigint — KT

bus_detail

  • id — bigint — NOT NULL
  • rte_arrv_stn1 — character — 첫
  • rte_arrv_stn2 — character — 두
  • rte_arrv_tm1 — character — 첫
  • rte_arrv_tm2 — character — 두
  • rte_congest1 — character — 첫
  • rte_congest2 — character — 두
  • rte_id — character — 버스
  • rte_nm — character — 버스
  • rte_sect — character — 버스
  • rte_stn_nm — character — 현재
  • bus_stn_stts_id — bigint — 버스

bus_stn_stts

  • id — bigint — NOT NULL
  • bus_ars_id — character — 정류소
  • bus_result_msg — character — 버스데이터
  • bus_stn_id — character — 정류소ID
  • bus_stn_nm — character — 정류소명
  • bus_stnx — character — 정류소
  • bus_stny — character — 정류소
  • kt_meta_detail_id — bigint — 상세
  • h3_index — character — 공간

charger_details

  • id — bigint — NOT NULL
  • charger_id — character — 충전기
  • charger_stat — character — 충전기
  • charger_type — character — 충전기
  • lst_end_time — character — 충전기
  • lst_strt_time — character — 충전기
  • method — character — 충전기
  • crrnt_strt_time — character — 충전기
  • capacity — character — 충전기
  • stat_updt_time — character — 충전기
  • charger_stts_id — bigint — 전기차충전소

charger_stts

  • id — bigint — NOT NULL
  • h3_index — character — 공간
  • stat_addr — character — 전기차
  • stat_id — character — 전기차충전소
  • stat_kind_detail — character — 전기차충전소
  • stat_limit_detail — character — 전기차충전소
  • stat_limit_yn — character — 전기차충전소
  • stat_nm — character — 전기차충전소명
  • stat_park_pay — character — 전기가충전소
  • stat_usetime — character — 전기차충전소
  • x — character — 전기차충전소
  • y — character — 전기차충전소
  • kt_meta_detail_id — bigint — 상세

cmrcl_rsb

  • id — bigint — NOT NULL
  • rsb_lrg_ctgr — character — 상권
  • rsb_mct_cnt — integer — 점포
  • rsb_mct_time — character — 점포
  • rsb_mid_ctgr — character — 상권
  • rsb_payment_lvl — character — 상권
  • rsb_sh_payment_amt_max — integer — 점포별
  • rsb_sh_payment_amt_min — integer — 점포별
  • rsb_sh_payment_cnt — integer — 점포별
  • live_cmrcl_stts_id — bigint — 실시간

event_stts

  • id — bigint — NOT NULL
  • event_etc_detail — character — 문화행사
  • event_nm — character — 문화행사명
  • event_period — character — 문화행사
  • event_place — character — 문화행사
  • eventx — double — 문화행사
  • eventy — double — 문화행사
  • pay_yn — character — 유무료
  • thumbnail — character — 문화행사
  • url — character — 문화행사
  • kt_meta_detail_id — bigint — 상세
  • h3_index — character — 공간

fcst_24_hours

  • id — bigint — NOT NULL
  • fcst_dt — character — 예보시간
  • precipitation — character — 강수량
  • precpt_type — character — 강수형태
  • rain_chance — character — 강수확률
  • sky_stts — character — 하늘상태
  • temp — character — 기온
  • weather_stts_id — bigint — 실시간

fcst_ppltn

  • id — bigint — NOT NULL
  • fcst_congest_lvl — character — 장소
  • fcst_ppltn_max — integer — 예측
  • fcst_ppltn_min — integer — 예측
  • fcst_time — character — 인구
  • live_ppltn_stts_id — bigint — 실시간

hdong

  • id — bigint — NOT NULL
  • hdong_cd — character — NOT NULL
  • hdong_addr — text — NOT NULL — 행정동

kt_meta_detail

  • id — bigint — NOT NULL
  • kt_meta_root_id — bigint — 데이터

kt_meta_root

  • id — bigint — NOT NULL
  • area_name — character — 지역명
  • collected_at — timestamp(6) — 데이터
  • collected_at_epoch — bigint — NOT NULL — 데이터
  • common_timestamp — timestamp(6) — 공통
  • data_update_time_epoch — bigint — NOT NULL — 수집한
  • list_total_count — integer — 목록
  • result_code — character — 결과
  • result_message — character — 결과

live_bus_ppltn

  • id — bigint — NOT NULL
  • bus10wthn_gtoff_ppltn_max — integer — 10분
  • bus10wthn_gtoff_ppltn_min — integer — 10분
  • bus10wthn_gton_ppltn_max — integer — 10분
  • bus10wthn_gton_ppltn_min — integer — 10분
  • bus30wthn_gtoff_ppltn_max — integer — 30분
  • bus30wthn_gtoff_ppltn_min — integer — 30분
  • bus30wthn_gton_ppltn_max — integer — 30분
  • bus30wthn_gton_ppltn_min — integer — 30분
  • bus5wthn_gtoff_ppltn_max — integer — 5분
  • bus5wthn_gtoff_ppltn_min — integer — 5분
  • bus5wthn_gton_ppltn_max — integer — 5분
  • bus5wthn_gton_ppltn_min — integer — 5분
  • bus_acml_gtoff_ppltn_max — integer — 첫차이후(당일)
  • bus_acml_gtoff_ppltn_min — integer — 첫차이후(당일)
  • bus_acml_gton_ppltn_max — integer — 첫차이후(당일)
  • bus_acml_gton_ppltn_min — integer — 첫차이후(당일)
  • bus_stn_cnt — integer — 장소
  • bus_stn_time — date — 버스정류장
  • kt_meta_detail_id — bigint — KT

live_cmrcl_stts

  • id — bigint — NOT NULL
  • area_cmrcl_lvl — character — 상권
  • area_sh_payment_amt_max — integer — 상권
  • area_sh_payment_amt_min — integer — 상권
  • area_sh_payment_cnt — character — 상권
  • cmrcl_10_rate — double — 10대
  • cmrcl_20_rate — double — 20대
  • cmrcl_30_rate — double — 30대
  • cmrcl_40_rate — double — 40대
  • cmrcl_50_rate — double — 50대
  • cmrcl_60_rate — double — 60대
  • cmrcl_corporation_rate — double — 법인
  • cmrcl_female_rate — double — 여성
  • cmrcl_male_rate — double — 남성
  • cmrcl_personal_rate — double — 개인
  • cmrcl_time — character — 관측
  • h3_index — character — 상권
  • kt_meta_detail_id — bigint — KT

live_ppltn_stts

  • id — bigint — NOT NULL
  • area_cd — character — 지역
  • area_congest_lvl — character — 장소
  • area_congest_msg — character — 혼잡도
  • area_nm — character — 지역명
  • area_ppltn_max — integer — 실시간
  • area_ppltn_min — integer — 실시간
  • fcst_yn — character — 인구
  • female_ppltn_rate — double — 여성
  • h3_index — character — 공간
  • male_ppltn_rate — double — 남성
  • non_resnt_ppltn_rate — double — 비상주
  • ppltn_rate0 — double — 0~10세
  • ppltn_rate10 — double — 10대
  • ppltn_rate20 — double — 20대
  • ppltn_rate30 — double — 30대
  • ppltn_rate40 — double — 40대
  • ppltn_rate50 — double — 50대
  • ppltn_rate60 — double — 60대
  • ppltn_rate70 — double — 70대
  • ppltn_time — character — 실시간
  • replace_yn — character — 대체
  • resnt_ppltn_rate — double — 상주
  • kt_meta_detail_id — bigint — 상세

live_sub_ppltn

  • id — bigint — NOT NULL
  • sub10wthn_gtoff_ppltn_max — integer — 10분
  • sub10wthn_gtoff_ppltn_min — integer — 10분
  • sub10wthn_gton_ppltn_max — integer — 10분
  • sub10wthn_gton_ppltn_min — integer — 10분
  • sub30wthn_gtoff_ppltn_max — integer — 30분
  • sub30wthn_gtoff_ppltn_min — integer — 30분
  • sub30wthn_gton_ppltn_max — integer — 30분
  • sub30wthn_gton_ppltn_min — integer — 30분
  • sub5wthn_gtoff_ppltn_max — integer — 5분
  • sub5wthn_gtoff_ppltn_min — integer — 5분
  • sub5wthn_gton_ppltn_max — integer — 5분
  • sub5wthn_gton_ppltn_min — integer — 5분
  • sub_acml_gtoff_ppltn_max — integer — 첫차이후(당일)
  • sub_acml_gtoff_ppltn_min — integer — 첫차이후(당일)
  • sub_acml_gton_ppltn_max — integer — 첫차이후(당일)
  • sub_acml_gton_ppltn_min — integer — 첫차이후(당일)
  • sub_stn_cnt — integer — 장소
  • sub_stn_time — date — 지하철역
  • kt_meta_detail_id — bigint — NOT NULL — KT

prk_stts

  • id — bigint — NOT NULL
  • add_rates — character — 추가
  • add_time_rates — character — 추가
  • addr — character — 지번
  • capacity — character — 주차장
  • cur_prk_cnt — character — 주차장
  • cur_prk_time — character — 현재
  • cur_prk_yn — character — 실시간
  • h3_index — character — 공간
  • x — character — 경도
  • y — character — 위도
  • pay_yn — character — 유무료
  • prk_cd — character — 주차장
  • prk_nm — character — 주차장명
  • prk_type — character — 주차장
  • rates — character — 기본
  • time_rates — character — 기본
  • kt_city_api_data_detail_id — bigint — 상세
  • kt_meta_id — bigint — KT

road_traffic_stts

  • id — bigint — NOT NULL
  • dist — double — 도로구간
  • end_nd_cd — character — 도로노드
  • end_nd_nm — character — 도로노드
  • end_nd_xy — character — 도로노드
  • h3_index — character — 공간
  • idx — character — 전체
  • link_id — character — 도로구간
  • road_nm — character — 도로명
  • spd — double — 전체
  • start_nd_cd — character — 도로노드 fdsfdasfsdafds
  • start_nd_nm — character — 도로노드
  • start_nd_xy — character — 도로노드
  • xy_list — character — 링크아이디
  • kt_meta_detail_id — bigint — 상세

sbike_stts

  • id — bigint — NOT NULL
  • h3_index — character — 공간
  • sbike_parking_cnt — character — 따릉이
  • sbike_rack_cnt — character — 따릉이
  • sbike_shared — character — 따릉이
  • sbike_spot_id — character — 따릉이
  • sbike_spot_nm — character — 따릉이
  • x — double — 따릉이
  • y — double — 따릉이
  • kt_meta_detail_id — bigint — 상세

seoul_road_data

  • id — bigint — NOT NULL
  • api_data_json — text — API
  • end_node_id — character — 도착
  • epoch_time — bigint — 에포크
  • link_id — character — 도로
  • prcs_spd — numeric(38,2) — 도로
  • prcs_trv_time — integer — 도로
  • start_node_id — character — 출발
  • common_timestamp — timestamp(6) — 데이터

sk_feature

  • id — bigint — NOT NULL
  • f_00 — double — NOT NULL — 0-10세
  • f_10 — double — NOT NULL — 10대
  • f_20 — double — NOT NULL — 20대
  • f_30 — double — NOT NULL — 30대
  • f_40 — double — NOT NULL — 40대
  • f_50 — double — NOT NULL — 50대
  • f_60 — double — NOT NULL — 60대
  • f_70 — double — NOT NULL — 70대
  • h3_index — character — H3
  • m_00 — double — NOT NULL — 0-10세
  • m_10 — double — NOT NULL — 10대
  • m_20 — double — NOT NULL — 20대
  • m_30 — double — NOT NULL — 30대
  • m_40 — double — NOT NULL — 40대
  • m_50 — double — NOT NULL — 50대
  • m_60 — double — NOT NULL — 60대
  • m_70 — double — NOT NULL — 70대
  • recordid — character — 레코드ID
  • x — double — NOT NULL — X좌표
  • y — double — NOT NULL — Y좌표
  • sk_meta_data_id — bigint — 메타데이터ID

sk_flow_pop

  • x — numeric(38,8)
  • y — numeric(38,8) — Y좌표
  • m_10 — numeric(18,2) — 10대
  • m_20 — numeric(18,2) — 20대
  • m_30 — numeric(18,2) — 30대
  • m_40 — numeric(18,2) — 40대
  • m_50 — numeric(18,2) — 50대
  • m_60 — numeric(18,2) — 60대
  • m_70u — numeric(18,2) — 70대
  • w_10 — numeric(18,2) — 10대
  • w_20 — numeric(18,2) — 20대
  • w_30 — numeric(18,2) — 30대
  • w_40 — numeric(18,2) — 40대
  • w_50 — numeric(18,2) — 50대
  • w_60 — numeric(18,2) — 60대
  • w_70u — numeric(18,2) — 70대
  • common_timestamp — timestamp — 공통

sk_foreign_pop

  • hdong_cd — character
  • foreign_cd — character — 국적
  • pop — numeric(18,2) — 외국인
  • common_timestamp — timestamp — 공통
  • id — bigint — NOT NULL

sk_meta_data

  • id — bigint — NOT NULL
  • epoch_timestamp — bigint — 에포크
  • message — character
  • region — character — 지역
  • status — integer — NOT NULL — 상태
  • tot_cnt — integer — NOT NULL — 자식
  • common_timestamp — timestamp(6) — 데이터

sub_detail

  • id — bigint — NOT NULL
  • sub_armg1 — character — 열차
  • sub_armg2 — character — 열차
  • sub_arv_time — integer — 열차
  • sub_arvinfo — character — 열차
  • sub_bf_stn — character — 이전역
  • sub_dir — character — 지하철
  • sub_line — character — 지하철
  • sub_nt_stn — character — 다음역
  • sub_ord — character — 도착
  • sub_route_nm — character — 지하철
  • sub_terminal — character — 종착역
  • sub_stts_id — bigint — 지하철

sub_faci_info

  • id — bigint — NOT NULL
  • elvtr_nm — character — 승강기명
  • elvtr_se — character — 승강기
  • instl_pstn — character — 설치
  • opr_sec — character — 운행
  • use_yn — character — 운행
  • sub_stts_id — bigint — 지하철

sub_stts

  • id — bigint — NOT NULL
  • grid_key10x10 — character — 10x10
  • h3_index — character — 공간
  • sub_stn_line — character — 지하철역
  • sub_stn_nm — character — 지하철역명
  • sub_stn_addr — character — 지하철역
  • x — numeric — 지하철역
  • y — numeric — 지하철역
  • kt_meta_detail_id — bigint — KT

weather_news

  • id — bigint — NOT NULL
  • announce_time — character — 기상
  • cancel_yn — character — 기상
  • command — character — 기상
  • warn_msg — character — 기상
  • warn_stress — character — 기상
  • warn_val — character — 기상
  • weather_stts_id — bigint — 기상

weather_stts

  • id — bigint — NOT NULL
  • air_idx — character — 통합대기환경
  • air_idx_main — character — 통합대기환경
  • air_idx_mvl — character — 통합대기환경
  • air_msg — character — 통합대기환경
  • h3_index — character — 공간
  • humidity — integer — 습도
  • max_temp — numeric(38,2) — 일
  • min_temp — numeric(38,2) — 일
  • pcp_msg — character — 강수
  • pm10 — integer — 미세먼지
  • pm10_index — character — 미세먼지
  • pm25 — integer — 초미세먼지
  • pm25_index — character — 초미세먼지
  • precipitation — character — 강수량
  • precpt_type — character — 강수
  • sensible_temp — numeric(38,2) — 체감온도
  • sunrise — time — 일출
  • sunset — time — 일몰
  • temp — numeric(38,2) — 기온
  • uv_index — character — 자외선
  • uv_index_lvl — character — 자외선
  • uv_msg — character — 자외선
  • weather_time — timestamp — 날씨
  • wind_dirct — character — 풍향
  • wind_spd — numeric(38,2) — 풍속
  • kt_meta_detail_id — bigint — KT

white_scan_bus

  • id — bigint — NOT NULL
  • area_nm — character
  • bustp_id — bigint — NOT NULL — 버스정류장
  • bustp_nm — character — 버스정류장명
  • emd_nm — character — 읍면동명
  • sgg_nm — character — 시군구명
  • voalgt — integer — NOT NULL — 하차량
  • votaca — integer — NOT NULL — 승차량
  • common_timestamp — timestamp — 공통
  • clcln_ymd — date

white_scan_cell

  • id — bigint — NOT NULL
  • area_nm — text — 장소명
  • area_ppltn_min — integer — 실시간
  • area_ppltn_max — integer — 실시간
  • cell_id — bigint — NOT NULL — 셀
  • cell_x — real — 셀
  • cell_y — real — 셀
  • h3index — text — 공간
  • male_ppltn_rate — real — 남성
  • female_ppltn_rate — real — 여성
  • ppltn_rate_0 — real — 0~10세
  • ppltn_rate_10 — real — 10대
  • ppltn_rate_20 — real — 20대
  • ppltn_rate_30 — real — 30대
  • ppltn_rate_40 — real — 40대
  • ppltn_rate_50 — real — 50대
  • ppltn_rate_60 — real — 60대
  • ppltn_rate_70 — real — 70대
  • resnt_ppltn_rate — real — 상주
  • non_resnt_ppltn_rate — real — 비상주
  • replace_yn — text — 대체
  • ppltn_epochtime — bigint — NOT NULL — 실시간
  • ppltn_time — timestamp — NOT NULL — 실시간

white_scan_cell_202410

  • id — bigint — NOT NULL
  • area_nm — text
  • area_ppltn_min — integer
  • area_ppltn_max — integer
  • cell_id — bigint — NOT NULL
  • cell_x — real
  • cell_y — real
  • h3index — text
  • male_ppltn_rate — real
  • female_ppltn_rate — real
  • ppltn_rate_0 — real
  • ppltn_rate_10 — real
  • ppltn_rate_20 — real
  • ppltn_rate_30 — real
  • ppltn_rate_40 — real
  • ppltn_rate_50 — real
  • ppltn_rate_60 — real
  • ppltn_rate_70 — real
  • resnt_ppltn_rate — real
  • non_resnt_ppltn_rate — real
  • replace_yn — text
  • ppltn_epochtime — bigint — NOT NULL
  • ppltn_time — timestamp — NOT NULL

white_scan_event

  • id — bigint — NOT NULL
  • area_nm — character
  • evnt_nm — character — 문화행사명
  • evnt_type — character — 문화행사유형
  • overvw — character — 개요
  • sub_evnt — character — 부대행사
  • prgrm — character — 행사프로그램
  • age_lmt — character — 관람가능연령
  • evnt_strt_dt — date — 행사시작일
  • evnt_end_dt — date — 행사종료일
  • ply_tm — character — 공연시간
  • spnd_tm_evnt — character — 관람소요시간
  • evnt_plc — character — 행사장소
  • sgg_nm — character — 시군구명
  • addr — character — 주소
  • addr2 — character — 상세주소
  • zip_cd — bigint — 우편번호
  • x_coord — character — X좌표
  • y_coord — character — Y좌표
  • plc_info — character — 행사장위치안내
  • evnt_img — character — 대표이미지
  • evnt_url — character — 행사
  • bkng_plc — character — 예매처
  • pay_info — character — 요금안내
  • dscnt_info — character — 할인정보
  • hst_info — character — 주관사
  • hst_tel — character — 주관사
  • org_info — character — 주최자
  • org_tel — character — 주최자
  • crt_dt — character — 등록일시
  • mod_dt — character — 수정일시
  • fetched_at — timestamp

white_scan_foot_traffic

  • id — bigint — NOT NULL
  • area_nm — character — 장소명
  • cell_id — bigint — NOT NULL — 셀
  • cell_x — real — NOT NULL — 셀
  • cell_y — real — NOT NULL — 셀
  • ppltn_female_0 — real — NOT NULL — 10세
  • ppltn_female_10 — real — NOT NULL — 10~14세
  • ppltn_female_15 — real — NOT NULL — 15~19세
  • ppltn_female_20 — real — NOT NULL — 20~24세
  • ppltn_female_25 — real — NOT NULL — 25~29세
  • ppltn_female_30 — real — NOT NULL — 30~34세
  • ppltn_female_35 — real — NOT NULL — 35~39세
  • ppltn_female_40 — real — NOT NULL — 40~44세
  • ppltn_female_45 — real — NOT NULL — 45~49세
  • ppltn_female_50 — real — NOT NULL — 50~54세
  • ppltn_female_55 — real — NOT NULL — 55~59세
  • ppltn_female_60 — real — NOT NULL — 60~64세
  • ppltn_female_65 — real — NOT NULL — 65~69세
  • ppltn_female_70 — real — NOT NULL — 70세
  • ppltn_male_0 — real — NOT NULL — 10세
  • ppltn_male_10 — real — NOT NULL — 10~14세
  • ppltn_male_15 — real — NOT NULL — 15~19세
  • ppltn_male_20 — real — NOT NULL — 20~24세
  • ppltn_male_25 — real — NOT NULL — 25~29세
  • ppltn_male_30 — real — NOT NULL — 30~34세
  • ppltn_male_35 — real — NOT NULL — 35~39세
  • ppltn_male_40 — real — NOT NULL — 40~44세
  • ppltn_male_45 — real — NOT NULL — 45~49세
  • ppltn_male_50 — real — NOT NULL — 50~54세
  • ppltn_male_55 — real — NOT NULL — 55~59세
  • ppltn_male_60 — real — NOT NULL — 60~64세
  • ppltn_male_65 — real — NOT NULL — 65~69세
  • ppltn_male_70 — real — NOT NULL — 70세
  • total — bigint — NOT NULL — 총
  • epoch_time — bigint — NOT NULL — 실시간
  • h3index — character — 공간
  • crtr_ymd — date

white_scan_hot_spot

  • id — bigint — NOT NULL
  • area_nm — character — 장소명
  • area_ppltn_max — bigint — NOT NULL — 실시간
  • area_ppltn_min — bigint — NOT NULL — 실시간
  • female_ppltn_rate — real — NOT NULL — 여성
  • male_ppltn_rate — real — NOT NULL — 남성
  • non_resnt_ppltn_rate — real — NOT NULL — 비상주
  • ppltn_rate_0 — real — NOT NULL — 0~10세
  • ppltn_rate_10 — real — NOT NULL — 10대
  • ppltn_rate_20 — real — NOT NULL — 20대
  • ppltn_rate_30 — real — NOT NULL — 30대
  • ppltn_rate_40 — real — NOT NULL — 40대
  • ppltn_rate_50 — real — NOT NULL — 50대
  • ppltn_rate_60 — real — NOT NULL — 60대
  • ppltn_rate_70 — real — NOT NULL — 70대
  • replace_yn — character(1) — NOT NULL — 대체
  • resnt_ppltn_rate — real — NOT NULL — 상주
  • ppltn_epochtime — bigint — 실시간
  • common_timestamp — timestamp(6) — 실시간

white_scan_live

  • id — bigint — NOT NULL
  • area_nm — character — 장소명
  • cell_x — real — NOT NULL — 셀
  • cell_y — real — NOT NULL — 셀
  • home_female — real — NOT NULL — 전체
  • home_female_10 — real — NOT NULL — 10~14세
  • home_female_15 — real — NOT NULL — 15~19세
  • home_female_20 — real — NOT NULL — 20~24세
  • home_female_25 — real — NOT NULL — 25~29세
  • home_female_30 — real — NOT NULL — 30~34세
  • home_female_35 — real — NOT NULL — 35~39세
  • home_female_40 — real — NOT NULL — 40~44세
  • home_female_45 — real — NOT NULL — 45~49세
  • home_female_50 — real — NOT NULL — 50~54세
  • home_female_55 — real — NOT NULL — 55~59세
  • home_female_60 — real — NOT NULL — 60~64세
  • home_female_65 — real — NOT NULL — 65~69세
  • home_female_70 — real — NOT NULL — 70~74세
  • home_female_75 — real — NOT NULL — 75세
  • home_male — real — NOT NULL — 전체
  • home_male_10 — real — NOT NULL — 10~14세
  • home_male_15 — real — NOT NULL — 15~19세
  • home_male_20 — real — NOT NULL — 20~24세
  • home_male_25 — real — NOT NULL — 25~29세
  • home_male_30 — real — NOT NULL — 30~34세
  • home_male_35 — real — NOT NULL — 35~39세
  • home_male_40 — real — NOT NULL — 40~44세
  • home_male_45 — real — NOT NULL — 45~49세
  • home_male_50 — real — NOT NULL — 50~54세
  • home_male_55 — real — NOT NULL — 55~59세
  • home_male_60 — real — NOT NULL — 60~64세
  • home_male_65 — real — NOT NULL — 65~69세
  • home_male_70 — real — NOT NULL — 70~74세
  • home_male_75 — real — NOT NULL — 75세
  • total — real — NOT NULL — 총
  • visit_female — real — NOT NULL — 전체
  • visit_female_10 — real — NOT NULL — 10~14세
  • visit_female_15 — real — NOT NULL — 15~19세
  • visit_female_20 — real — NOT NULL — 20~24세
  • visit_female_25 — real — NOT NULL — 25~29세
  • visit_female_30 — real — NOT NULL — 30~34세
  • visit_female_35 — real — NOT NULL — 35~39세
  • visit_female_40 — real — NOT NULL — 40~44세
  • visit_female_45 — real — NOT NULL — 45~49세
  • visit_female_50 — real — NOT NULL — 50~54세
  • visit_female_55 — real — NOT NULL — 55~59세
  • visit_female_60 — real — NOT NULL — 60~64세
  • visit_female_65 — real — NOT NULL — 65~69세
  • visit_female_70 — real — NOT NULL — 70~74세
  • visit_female_75 — real — NOT NULL — 75세
  • visit_male — real — NOT NULL — 전체
  • visit_male_10 — real — NOT NULL — 10~14세
  • visit_male_15 — real — NOT NULL — 15~19세
  • visit_male_20 — real — NOT NULL — 20~24세
  • visit_male_25 — real — NOT NULL — 25~29세
  • visit_male_30 — real — NOT NULL — 30~34세
  • visit_male_35 — real — NOT NULL — 35~39세
  • visit_male_40 — real — NOT NULL — 40~44세
  • visit_male_45 — real — NOT NULL — 45~49세
  • visit_male_50 — real — NOT NULL — 50~54세
  • … +38

white_scan_route

  • id — bigint — NOT NULL
  • area_nm — character — 장소명
  • crtr_tm — integer — NOT NULL
  • crtr_ymd — date
  • geometry — text — 경로
  • route_id — integer — NOT NULL — 경로
  • route_lst — text — 경로
  • route_rate — real — NOT NULL — 경로
  • week_yn — character(1) — NOT NULL — 주중
  • epoch_time — bigint — NOT NULL — 실시간
  • common_timestamp — timestamp — 공통

white_scan_subway

  • id — bigint — NOT NULL
  • area_nm — character
  • emd_nm — character — 읍면동명
  • sbwystn_id — bigint — NOT NULL — 지하철역
  • sbwystn_nm — character — 지하철역명
  • sgg_nm — character — 시군구명
  • voalgt — integer — NOT NULL — 하차량
  • votaca — integer — NOT NULL — 승차량
  • common_timestamp — timestamp — 공통
  • clcln_ymd — date