test
Tables (34)
bus
- gid — int4 — Primary key — NOT NULL
- geom — geometry(linestring, 4326)
- srcid — text
- center_lane — int4
- right_lane — int4
link
- gid — int4 — Primary key — NOT NULL
- link_id — text
- from_node_id — text
- to_node_id — text
- road_cate — text
- route_road_cate — text
- link_cate — text
- facil_cate — text
- route_level — text
- road_name — text
- facil_name — text
- road_number_1 — text
- road_number_2 — text
- road_number_3 — text
- lane_count — text
- pass_limit — text
- speed_limit — text
- height_limit — text
- weight_limit — text
- toll_flag — text
- pave_flag — text
- median_flag — text
- motorway_flag — text
- schoolzone_flag — text
- frc — text
- link_length — text
- car_only — text
- indirect_road — text
- topology — text
- virtual_info — text
- strideti — text
- road_name_kol — varchar(50)
- road_name_eng — varchar(50)
- frr_name — text
- f_elev — text
- t_elev — text
- road_cate_2 — int4
- road_cate_3 — int4
- p_slink_id — text
- n_slink_id — text
- geom — geometry(linestring, 4326)
link_dir
- gid — int4 — Primary key — NOT NULL
- link_id — text
- short_name_f — text
- middle_name_f — text
- long_name_f — text
- short_name_b — text
- middle_name_b — text
- long_name_b — text
- cnt_f — int8
- cnt_b — int8
- geom — geometry(linestring, 4326)
link_frr
- link_id — text — Primary key — NOT NULL
- frr_id — int4
- frr_ids — text
- frr_cnt — int8
- frr_name — text
link_lane
- gid — int4 — Primary key — NOT NULL
- link_id — text
- lane_guide_f — text
- lane_guide_b — text
- cnt_f — int8
- cnt_b — int8
- road_cate — text
- link_cate — text
- facil_cate — text
- lane_count — text
- geom — geometry(linestring, 4326)
link_road_cate_2
- link_id — text — Primary key — NOT NULL
- road_cate_2 — int4
link_road_cate_3
- link_id — text — Primary key — NOT NULL
- road_cate_3 — int4
link_road_num_cate
- road_cate — int4
- road_number — int4
- len — float8
- rnk — int8
link_strideti
- gid — int4 — Primary key — NOT NULL
- link_id — text
- sig_cd — varchar(5)
- rn_cd — varchar(7)
- strideti — text
- road_name — text
- road_name_kol — text
- road_name_eng — text
- dist — float8
- geom — geometry(linestring, 4326)
- r_gid — int4
- r_geom — geometry(multilinestring, 5179)
link_strideti_chk
- strideti — text — Primary key — NOT NULL
- road_name — varchar(50) — NOT NULL
- road_name_kol — varchar(50) — NOT NULL
- road_name_eng — varchar(50) — NOT NULL
node
- gid — int8 — Primary key — NOT NULL
- node_id — text
- node_cate — text
- node_name — text
- ts_flag — text
- group_node_id — text
- adj_node_id — text
- conn_link_cnt — text
- x — text
- y — text
- geom — geometry(point, 4326)
node_lc_mat
- gid — int8 — Primary key — NOT NULL
- node_id — text
- node_cate — text
- node_name — text
- ts_flag — text
- group_node_id — text
- adj_node_id — text
- conn_link_cnt — text
- x — text
- y — text
- geom — geometry
- lcgid — int4
- lcgeom — geometry(point, 4326)
- typ — int4
- dist — float8
- link_id — text
path_info
- in_link_id — text — Primary key — NOT NULL
- node_id — text — Primary key — NOT NULL
- out_link_id — text — Primary key — NOT NULL
- turn_code — text
- ment_code — text
- jv_code — text
- memo — text
- cond_id — text
payment_method
- gid — int8 — Primary key — NOT NULL
- geom — geometry
- node_id — text
- tot_lane — int4
- etc_lane — text
- x — text
- y — text
- direction — text
- period — text
- tg_id — text
- tg_nm — text
- angle — text
- hp_code — text
- mhp_code — text
- mhp_type — text
- thp_lane — text
- mahp_lane — text
- hp_cate — text
poi_addr_corrected
- srcid — text
- parent_id — text
- relation_type — text
- p_catid — text
- catid — text
- attrib1 — text
- attrib2 — text
- attrib3 — text
- snam1 — text
- snam1lc — text
- snam2 — text
- snam2lc — text
- snam3 — text
- snam3lc — text
- bnam1 — text
- bnam1lc — text
- bnam2 — text
- bnam2lc — text
- bnam3 — text
- bnam3lc — text
- anam1 — text
- anam1lc — text
- anam2 — text
- anam2lc — text
- anam3 — text
- anam3lc — text
- tlccode — text
- tlacode — text
- tlnumber — text
- faxccode — text
- faxacode — text
- faxnumber — text
- email — text
- url — text
- postcode — text
- epaxco — text
- epayco — text
- xco — text
- yco — text
- aptnewid — text
- aptoldid — text
- laid — text
- aaid — text
- budpoi — text
- use_stage — text
- attrib4 — text
- importance — text
- opentime — text
- l_odr1n1 — varchar(200)
- l_odr1n1lc — varchar(3)
- l_odr1n2 — varchar(200)
- l_odr1n2lc — varchar(3)
- l_odr1n3 — varchar(200)
- l_odr1n3lc — varchar(3)
- l_odr1oc — numeric(2)
- l_odr7n1 — varchar(200)
- l_odr7n1lc — varchar(3)
- l_odr7n2 — varchar(200)
- l_odr7n2lc — varchar(3)
- l_odr7n3 — varchar(200)
- … +31
poi_addr_corrected_match
- srcid — text — Primary key — NOT NULL
- ao_matched — int4
- an_matched — int4
poi_citycenter
- srcid — text
- parent_id — text
- relation_type — text
- p_catid — text
- catid — text
- attrib1 — text
- attrib2 — text
- attrib3 — text
- snam1 — text
- snam1lc — text
- snam2 — text
- snam2lc — text
- snam3 — text
- snam3lc — text
- bnam1 — text
- bnam1lc — text
- bnam2 — text
- bnam2lc — text
- bnam3 — text
- bnam3lc — text
- anam1 — text
- anam1lc — text
- anam2 — text
- anam2lc — text
- anam3 — text
- anam3lc — text
- tlccode — text
- tlacode — text
- tlnumber — text
- faxccode — text
- faxacode — text
- faxnumber — text
- email — text
- url — text
- postcode — text
- epaxco — text
- epayco — text
- xco — text
- yco — text
- aptnewid — text
- aptoldid — text
- laid — text
- aaid — text
- budpoi — text
- use_stage — text
- attrib4 — text
- importance — text
- opentime — text
- l_odr1n1 — text
- l_odr1n1lc — text
- l_odr1n2 — text
- l_odr1n2lc — text
- l_odr1n3 — text
- l_odr1n3lc — text
- l_odr1oc — text
- l_odr7n1 — text
- l_odr7n1lc — text
- l_odr7n2 — text
- l_odr7n2lc — text
- l_odr7n3 — text
- … +31
poi_citycenter_admin
- srcid — text
- parent_id — text
- relation_type — text
- p_catid — text
- catid — text
- attrib1 — text
- attrib2 — text
- attrib3 — text
- snam1 — text
- snam1lc — text
- snam2 — text
- snam2lc — text
- snam3 — text
- snam3lc — text
- bnam1 — text
- bnam1lc — text
- bnam2 — text
- bnam2lc — text
- bnam3 — text
- bnam3lc — text
- anam1 — text
- anam1lc — text
- anam2 — text
- anam2lc — text
- anam3 — text
- anam3lc — text
- tlccode — text
- tlacode — text
- tlnumber — text
- faxccode — text
- faxacode — text
- faxnumber — text
- email — text
- url — text
- postcode — text
- epaxco — text
- epayco — text
- xco — text
- yco — text
- aptnewid — text
- aptoldid — text
- laid — text
- aaid — text
- budpoi — text
- use_stage — text
- attrib4 — text
- importance — text
- opentime — text
- l_odr1n1 — text
- l_odr1n1lc — text
- l_odr1n2 — text
- l_odr1n2lc — text
- l_odr1n3 — text
- l_odr1n3lc — text
- l_odr1oc — text
- l_odr7n1 — text
- l_odr7n1lc — text
- l_odr7n2 — text
- l_odr7n2lc — text
- l_odr7n3 — text
- … +31
poi_citycenter_legal
- srcid — text
- parent_id — text
- relation_type — text
- p_catid — text
- catid — text
- attrib1 — text
- attrib2 — text
- attrib3 — text
- snam1 — text
- snam1lc — text
- snam2 — text
- snam2lc — text
- snam3 — text
- snam3lc — text
- bnam1 — text
- bnam1lc — text
- bnam2 — text
- bnam2lc — text
- bnam3 — text
- bnam3lc — text
- anam1 — text
- anam1lc — text
- anam2 — text
- anam2lc — text
- anam3 — text
- anam3lc — text
- tlccode — text
- tlacode — text
- tlnumber — text
- faxccode — text
- faxacode — text
- faxnumber — text
- email — text
- url — text
- postcode — text
- epaxco — text
- epayco — text
- xco — text
- yco — text
- aptnewid — text
- aptoldid — text
- laid — text
- aaid — text
- budpoi — text
- use_stage — text
- attrib4 — text
- importance — text
- opentime — text
- l_odr1n1 — text
- l_odr1n1lc — text
- l_odr1n2 — text
- l_odr1n2lc — text
- l_odr1n3 — text
- l_odr1n3lc — text
- l_odr1oc — text
- l_odr7n1 — text
- l_odr7n1lc — text
- l_odr7n2 — text
- l_odr7n2lc — text
- l_odr7n3 — text
- … +31
poi_covid
- srcid — text
- parent_id — text
- relation_type — text
- p_catid — text
- catid — text
- attrib1 — text
- attrib2 — text
- attrib3 — text
- snam1 — text
- snam1lc — text
- snam2 — text
- snam2lc — text
- snam3 — text
- snam3lc — text
- bnam1 — text
- bnam1lc — text
- bnam2 — text
- bnam2lc — text
- bnam3 — text
- bnam3lc — text
- anam1 — text
- anam1lc — text
- anam2 — text
- anam2lc — text
- anam3 — text
- anam3lc — text
- tlccode — text
- tlacode — text
- tlnumber — text
- faxccode — text
- faxacode — text
- faxnumber — text
- email — text
- url — text
- postcode — text
- epaxco — text
- epayco — text
- xco — text
- yco — text
- aptnewid — text
- aptoldid — text
- laid — text
- aaid — text
- budpoi — text
- use_stage — text
- attrib4 — text
- importance — text
- opentime — text
- l_odr1n1 — text
- l_odr1n1lc — text
- l_odr1n2 — text
- l_odr1n2lc — text
- l_odr1n3 — text
- l_odr1n3lc — text
- l_odr1oc — text
- l_odr7n1 — text
- l_odr7n1lc — text
- l_odr7n2 — text
- l_odr7n2lc — text
- l_odr7n3 — text
- … +31
poi_fromnet
- node_id — varchar(16)
- srcid — text
- p_catid — text
- catid — text
- snam1 — varchar(75)
- xco — numeric
- yco — numeric
- budpoi — text
- tg_nm — text
- tg_type — text
poi_onlyengname
- srcid — text — Primary key — NOT NULL
- column_name — text — Primary key — NOT NULL
- nam1 — text — NOT NULL
- nam1kor — text — NOT NULL
poi_postcode
- srcid — text — Primary key — NOT NULL
- postcode — text
poi_premiumcar
- srcid — text
- parent_id — text
- relation_type — text
- p_catid — text
- catid — text
- attrib1 — text
- attrib2 — text
- attrib3 — text
- snam1 — text
- snam1lc — text
- snam2 — text
- snam2lc — text
- snam3 — text
- snam3lc — text
- bnam1 — text
- bnam1lc — text
- bnam2 — text
- bnam2lc — text
- bnam3 — text
- bnam3lc — text
- anam1 — text
- anam1lc — text
- anam2 — text
- anam2lc — text
- anam3 — text
- anam3lc — text
- tlccode — text
- tlacode — text
- tlnumber — text
- faxccode — text
- faxacode — text
- faxnumber — text
- email — text
- url — text
- postcode — text
- epaxco — text
- epayco — text
- xco — text
- yco — text
- aptnewid — text
- aptoldid — text
- laid — text
- aaid — text
- budpoi — text
- use_stage — text
- attrib4 — text
- importance — text
- opentime — text
- l_odr1n1 — text
- l_odr1n1lc — text
- l_odr1n2 — text
- l_odr1n2lc — text
- l_odr1n3 — text
- l_odr1n3lc — text
- l_odr1oc — text
- l_odr7n1 — text
- l_odr7n1lc — text
- l_odr7n2 — text
- l_odr7n2lc — text
- l_odr7n3 — text
- … +31
poi_restarea_facil
- match_case — text
- srcid — text
- snam1 — text
- fsrcid — text
- p_catid — text
- fsnam1 — text
- attrib — int4
- dist — float8
- geom — geometry
- fgeom — geometry
- is_valid — int2 — NOT NULL
poi_restarea_ndmap
- srcid — text
- p_catid — text
- catid — text
- snam1 — text
- xco — text
- yco — text
- node_id — text
- sa_nm — text
- phone_id — text
- oil_brand — text
- gas_brand — text
- oa_flag — text
- cc_flag — text
- atm_flag — text
- wireless_flag — text
- cargo_flag — text
- x — text
- y — text
- ref_nm — text
- rnum — int8
- ndgeom — geometry
- pgeom — geometry
restriction
- gid — int4
- link_id — varchar(16)
- geom — geometry(linestring, 4326)
- r_srcid — varchar(16)
- f_srcid — varchar(16)
- restrtyp — varchar(2)
- direct — numeric(1)
- speedval — numeric(3)
- val — numeric(10, 1)
- vehtypesid — varchar(2)
- tdstring — varchar(200)
- tdgdfstrin — varchar(200)
- fuzzytd — varchar(200)
- weight — numeric(5)
- hazmat — numeric(1)
- lanevalid — varchar(10)
- ly_type — numeric(1)
- sp_type — numeric(1)
- tr_type — numeric(1)
- troute_type — numeric(1)
- except_ — numeric(1)
- ungoods — varchar(10)
- rnum — int8
restriction_src
- gid — serial4 — Primary key — NOT NULL
- link_id — varchar(16) — NOT NULL
- geom — geometry(linestring, 4326)
- r_srcid — varchar(16)
- f_srcid — varchar(16)
- restrtyp — varchar(2)
- direct — numeric(1)
- speedval — numeric(3)
- val — numeric(10, 1)
- vehtypesid — varchar(2)
- tdstring — varchar(200)
- tdgdfstrin — varchar(200)
- fuzzytd — varchar(200)
- weight — numeric(5)
- hazmat — numeric(1)
- lanevalid — varchar(10)
- ly_type — numeric(1)
- sp_type — numeric(1)
- tr_type — numeric(1)
- troute_type — numeric(1)
- except_ — numeric(1)
- ungoods — varchar(10)
restriction_src_rnum
- gid — int4
- link_id — varchar(16)
- geom — geometry(linestring, 4326)
- r_srcid — varchar(16)
- f_srcid — varchar(16)
- restrtyp — varchar(2)
- direct — numeric(1)
- speedval — numeric(3)
- val — numeric(10, 1)
- vehtypesid — varchar(2)
- tdstring — varchar(200)
- tdgdfstrin — varchar(200)
- fuzzytd — varchar(200)
- weight — numeric(5)
- hazmat — numeric(1)
- lanevalid — varchar(10)
- ly_type — numeric(1)
- sp_type — numeric(1)
- tr_type — numeric(1)
- troute_type — numeric(1)
- except_ — numeric(1)
- ungoods — varchar(10)
- rnum — int8
signpost
- gid — int4 — Primary key — NOT NULL
- path_uid — text
- edge1 — text
- edge2 — text
- nextedges — text
- via_node_id — text
- short_name — text
- middle_name — text
- long_name — text
- geom — geometry
toll_cost
- s_tg_id — int4
- e_tg_id — int4
- dup_code — int4
- c_tg_id — int4
- toll_cost — int4
- vt — text
- period — text
- is_excepted — int2
toll_cost_etc
- s_tg_id — int4
- e_tg_id — int4
- dup_code — int4
- c_tg_id — int4
- toll_cost — int4
- vt — text
- period — text
- is_excepted — int2
traffic_sign
- gid — int4 — Primary key — NOT NULL
- 분류code — text
- id — text
- 제한속도 — text
- 원점x — text
- 원점y — text
- 원점각도 — text
- 유도점유형 — text
- 유도점x — text
- 유도점y — text
- 유도점각도 — text
- 카메라유형 — text
- 로드피아 — text
- geom — geometry
- link_id — text
- road_cate — text
- route_road_cate — text
- link_cate — text
- facil_cate — text
- azimuth — int4
- dist — float8
- is_matched — int4
- is_same_way — int4
- is_excepted — int4
traffic_sign_unmatched
- gid — int4 — Primary key — NOT NULL
- 분류code — text
- id — text
- 제한속도 — text
- 원점x — text
- 원점y — text
- 원점각도 — text
- 유도점유형 — text
- 유도점x — text
- 유도점y — text
- 유도점각도 — text
- 카메라유형 — text
- 로드피아 — text
- geom — geometry