def initialize(self):
self.link_id_mapping = HwyLinkMappingNiPro()
self.hwy_facil_name = HwyFacilNameNiPro()
self.hwy_line_name = HwyLineNameNiPro()
self.data_mng = HwyDataMngNiPro.instance()
if self.data_mng:
self.data_mng.initialize()
self.hwy_route = HwyRouteNiPro(self.data_mng)
self.hwy_facil = HwyFacilityNiPro(self.data_mng)
self.hwy_mapping = HwyMappingRDF(self)
self.service_info = HwyServiceInfoRDF()
self.store = HwyStoreRDF()
self.adjust_link = HwyAdjustLinkType()
self.node_addinfo = HwyNodeAddInfoNiPro(self.data_mng)
self.sapa_info = HwySaPaInfoNiPro()
self.hwy_toll = HwyTollgateRDF()
self.hwy_parallel = HwyParallelPathNiPro()
self.hwy_juntion = HwyJunction()
def initialize(self):
self.data_mng = HwyDataMngRDF.instance()
self.data_mng.initialize()
country = getProjCountry().upper()
if country in (
"HKG",
"ASE",
"SGP",
"MYS",
"THA", # 香港, 东南亚
"BRA", # 巴西
):
self.hwy_route = HwyRouteRDF_HKG(self.data_mng)
elif country in ("MEA", "MEA8", "ARG"):
self.hwy_route = HwyRouteRDF(self.data_mng)
else:
self.log.error('Unkown country=%s.' % country)
self.hwy_route = HwyRouteRDF(self.data_mng)
if country in ("MEA", "MEA8"):
self.hwy_facil = HwyFacilityRDFMea(self.data_mng)
elif country in ("ASE", ):
self.hwy_facil = HwyFacilityRDFAse(self.data_mng)
elif country in ("BRA", "BRA5"):
self.hwy_facil = HwyFacilityRDFBra(self.data_mng)
elif country in ("ARG"):
self.hwy_facil = HwyFacilityRDFArg(self.data_mng)
# elif country in ("HKG"):
# self.hwy_facil = HwyFacilityRDFHkg(self.data_mng)
else:
self.hwy_facil = HwyFacilityRDF(self.data_mng)
self.hwy_mapping = HwyMappingRDF(self)
self.hwy_exit_poi = HwyPoiExitNameRDF()
self.hwy_exit = HwyExitNameRDF()
self.sapa_info = HwySapaInfoRDF()
self.link_id_mapping = HwyLinkMapping()
self.service_info = HwyServiceInfoRDF()
self.store = HwyStoreRDF()
self.adjust_link = HwyAdjustLinkType()
self.node_addinfo = HwyNodeAddInfoRDF(self.data_mng,
'HwyNodeAddInfoRDF')
self.hwy_toll = None # HwyTollgateRDF()
def initialize(self):
self.data_mng = HwyDataMngZenrin.instance()
self.data_mng.initialize()
self.hwy_route = HwyRouteZenrin(self.data_mng)
self.hwy_facil = HwyFacilityZenrin(self.data_mng)
self.hwy_mapping = HwyMappingRDF(self)
self.hwy_exit_poi = None
self.hwy_exit = None
self.sapa_info = None
self.link_id_mapping = HwyLinkMappingZenrin()
self.service_info = HwyServiceInfoRDF()
self.store = None
self.adjust_link = HwyAdjustLinkType()
def initialize(self):
self.link_id_mapping = HwyLinkMappingMMi()
self.hwy_exit = None
self.sapa_info = HwySapaInfoMMI()
self.data_mng = HwyDataMngMMi.instance()
if self.data_mng:
self.data_mng.initialize()
self.hwy_route = HwyRouteRDF_HKG(self.data_mng,
min_distance=ROUTE_DISTANCE_1600M,
margin_dist=ROUTE_DISTANCE_1600M,
ItemName='Highway_Route_Mmi')
self.hwy_facil = HwyFacilityMmi(self.data_mng)
self.hwy_mapping = HwyMappingRDF(self)
self.service_info = HwyServiceInfoRDF()
self.store = HwyStoreRDF()
self.adjust_link = HwyAdjustLinkType()
def initialize(self):
self.link_id_mapping = HwyLinkMappingNi()
self.hwy_exit_poi = HwyExitEnterNameNi()
self.hwy_exit = None
self.sapa_info = HwySaPaInfoNi()
self.data_mng = HwyDataMngNi.instance()
if self.data_mng:
self.data_mng.initialize()
self.hwy_route = HwyRouteNi(self.data_mng)
self.hwy_facil = HwyFacilityNi(self.data_mng)
self.hwy_mapping = HwyMappingRDF(self)
self.service_info = HwyServiceInfoRDF()
self.store = HwyStoreRDF()
self.adjust_link = HwyAdjustLinkType()
self.node_addinfo = HwyNodeAddInfoRDF(self.data_mng,
'HwyNodeAddInfoNI')
self.hwy_toll = None # HwyTollgateRDF()
def initialize(self):
self.link_id_mapping = HwyLinkMappingTa()
self.hwy_exit = HwyExitNameTa()
self.sapa_info = HwySapaInfoTa()
self.data_mng = HwyDataMngTa.instance()
self.data_mng.initialize()
self.hwy_route = HwyRouteTa(self.data_mng)
country = getProjCountry().upper()
if country in ("SAF", "SAF8",): # 南非
self.hwy_facil = HwyFacilityTaSaf(self.data_mng)
elif country in ("AUS",): # 澳洲
self.hwy_facil = HwyFacilityTa(self.data_mng)
else:
self.log.error('Wrong PROJ Country.')
self.hwy_mapping = HwyMappingRDF(self)
self.service_info = HwyServiceInfoRDF()
self.store = HwyStoreTa()
self.adjust_link = HwyAdjustLinkType()
class HighwayNiPro(HighwayRDF):
'''
classdocs
'''
def __init__(self, ItemName='HighwayNiPro'):
'''
Constructor
'''
HighwayRDF.__init__(self, ItemName)
self.hwy_parallel = None
def initialize(self):
self.link_id_mapping = HwyLinkMappingNiPro()
self.hwy_facil_name = HwyFacilNameNiPro()
self.hwy_line_name = HwyLineNameNiPro()
self.data_mng = HwyDataMngNiPro.instance()
if self.data_mng:
self.data_mng.initialize()
self.hwy_route = HwyRouteNiPro(self.data_mng)
self.hwy_facil = HwyFacilityNiPro(self.data_mng)
self.hwy_mapping = HwyMappingRDF(self)
self.service_info = HwyServiceInfoRDF()
self.store = HwyStoreRDF()
self.adjust_link = HwyAdjustLinkType()
self.node_addinfo = HwyNodeAddInfoNiPro(self.data_mng)
self.sapa_info = HwySaPaInfoNiPro()
self.hwy_toll = HwyTollgateRDF()
self.hwy_parallel = HwyParallelPathNiPro()
self.hwy_juntion = HwyJunction()
def _Do(self):
self.initialize()
from component.default.dictionary import comp_dictionary
dictionary = comp_dictionary()
dictionary.set_language_code()
# ## 原link id ==> Middle link id
if self.link_id_mapping:
self.link_id_mapping.Make() # ORG Link_id ==> Middle Link_id
del self.link_id_mapping
self.link_id_mapping = None
# ## 设施名称
if self.hwy_facil_name:
self.hwy_facil_name.Make()
del self.hwy_facil_name
self.hwy_facil_name = None
# ## 合理Org设施，转化设施的inlinkid和outlinkid到新的linkId.
if self.hwy_juntion:
self.hwy_juntion.Make()
# ## 高速线路名称
if self.hwy_line_name:
self.hwy_line_name.Make()
del self.hwy_line_name
self.hwy_line_name = None
if self.sapa_info:
self.sapa_info.Make()
if self.data_mng:
self.data_mng.Make()
# load Highway Main Link.
self.data_mng.load_hwy_main_link()
self.data_mng.load_hwy_ic_link()
self.data_mng.load_first_ics_link()
self.data_mng.load_hwy_path_id()
else:
self.log.error('Higway Data Manager is None.')
return 0
# ## 高速路线
self._make_hwy_route()
if self.hwy_parallel:
self.hwy_parallel.Make()
if self.data_mng:
# 加载高速road_code
self.data_mng.load_hwy_road_code()
self.data_mng.load_hwy_regulation()
self.data_mng.load_tollgate()
self.data_mng.load_hwy_ic_link()
self.data_mng.load_hwy_inout_link()
self.data_mng.load_hwy_path_id()
# 加载专用数据设施番号
self.data_mng.load_org_facil_id()
# 制作高速线路及设施(原始设施情报)
self._make_hwy_facil()
# 收费站情报
if self.hwy_toll:
self.hwy_toll.Make()
# ## 道路情报
self._make_road_no() # 道路番号
self._make_road_info() # 道路情报
# ## 设置ic_no
if self.data_mng:
self.data_mng.load_hwy_node_facilcls() # 加载设施种别
if self._make_ic_no(): # ic_no
self._make_facility_id() # 设施ID
# Mapping
if self.hwy_mapping:
self.hwy_mapping.Make()
# 设施情报
if self.data_mng:
self._make_ic_info()
# 附加情报(最终)
if self.node_addinfo:
self.node_addinfo.Make()
# 服务情报(For SAPA)
if self.service_info:
self.service_info.Make()
# 店铺情报(For SAPA)
if self.store:
self.store.Make()
# 调整link_type: Ramp ==> SAPA, Ramp ==> JCT
# if self.adjust_link:
# self.adjust_link.Make()
def _make_ic_info(self):
self.log.info('Making IC Info.')
self.pg.connect1()
self.pg.connect2()
self.CreateTable2('highway_ic_info')
self.CreateTable2('highway_path_point')
self.CreateTable2('highway_conn_info')
self.CreateTable2('highway_toll_info')
self.CreateTable2('mid_hwy_node_add_info')
# self.CreateTable2('mid_hwy_node_add_info')
for ic_no, facility_id, facil_list in self.data_mng.get_ic_list():
if facility_id != HWY_INVALID_FACIL_ID_17CY: # 非边界点
ic_info = HwyICInfoNIPro(ic_no, facility_id,
facil_list, self.data_mng)
ic_info.set_ic_info() # 设置料金情报
self._insert_ic_info(ic_info)
self._insert_path_point(ic_info)
self._insert_conn_info(ic_info)
# 先不做收费站情报
# self._insert_toll_info(ic_info)
self._insert_temp_add_info(ic_info)
else:
# 边界出口点（离开当前Tile）
ic_info = HwyBoundaryOutInfoRDF(ic_no, facility_id,
facil_list, self.data_mng)
ic_info.set_ic_info()
self._insert_ic_info(ic_info)
self._insert_path_point(ic_info)
# 边界进入点（进入Tile的点）
ic_info = HwyBoundaryInInfoRDF(ic_no, facility_id,
facil_list, self.data_mng)
ic_info.set_ic_info()
self._insert_ic_info(ic_info)
self._insert_path_point(ic_info)
self.pg.commit1()
self.CreateIndex2('highway_ic_info_ic_no_idx')
self.CreateIndex2('highway_toll_info_ic_no_conn_ic_no_node_id_idx')
self.CreateIndex2('highway_conn_info_ic_no_conn'
'_ic_no_conn_direction_idx')
self._add_geom_column()
class HighwayRDF(Highway):
'''
classdocs
'''
def __init__(self, ItemName='HighwayRDF'):
'''
Constructor
'''
Highway.__init__(self, ItemName)
self.hwy_route = None
self.data_mng = None
self.hwy_facil = None
self.hwy_mapping = None
self.hwy_exit_poi = None
self.hwy_exit = None
self.sapa_info = None
self.link_id_mapping = None
self.service_info = None
self.store = None
self.adjust_link = None
self.node_addinfo = None
self.hwy_toll = None
def initialize(self):
self.data_mng = HwyDataMngRDF.instance()
self.data_mng.initialize()
country = getProjCountry().upper()
if country in (
"HKG",
"ASE",
"SGP",
"MYS",
"THA", # 香港, 东南亚
"BRA", # 巴西
):
self.hwy_route = HwyRouteRDF_HKG(self.data_mng)
elif country in ("MEA", "MEA8", "ARG"):
self.hwy_route = HwyRouteRDF(self.data_mng)
else:
self.log.error('Unkown country=%s.' % country)
self.hwy_route = HwyRouteRDF(self.data_mng)
if country in ("MEA", "MEA8"):
self.hwy_facil = HwyFacilityRDFMea(self.data_mng)
elif country in ("ASE", ):
self.hwy_facil = HwyFacilityRDFAse(self.data_mng)
elif country in ("BRA", "BRA5"):
self.hwy_facil = HwyFacilityRDFBra(self.data_mng)
elif country in ("ARG"):
self.hwy_facil = HwyFacilityRDFArg(self.data_mng)
# elif country in ("HKG"):
# self.hwy_facil = HwyFacilityRDFHkg(self.data_mng)
else:
self.hwy_facil = HwyFacilityRDF(self.data_mng)
self.hwy_mapping = HwyMappingRDF(self)
self.hwy_exit_poi = HwyPoiExitNameRDF()
self.hwy_exit = HwyExitNameRDF()
self.sapa_info = HwySapaInfoRDF()
self.link_id_mapping = HwyLinkMapping()
self.service_info = HwyServiceInfoRDF()
self.store = HwyStoreRDF()
self.adjust_link = HwyAdjustLinkType()
self.node_addinfo = HwyNodeAddInfoRDF(self.data_mng,
'HwyNodeAddInfoRDF')
self.hwy_toll = None # HwyTollgateRDF()
def _Do(self):
self.initialize()
from component.default.dictionary import comp_dictionary
dictionary = comp_dictionary()
dictionary.set_language_code()
if self.link_id_mapping:
self.link_id_mapping.Make() # ORG Link_id ==> Middle Link_id
if self.hwy_exit_poi: # 来源POI
self.hwy_exit_poi.Make()
if self.hwy_exit: # 来源道路名称
self.hwy_exit.Make() # 出口番号/交叉点名称
if self.sapa_info:
self.sapa_info.Make() # SAPA情报
if self.data_mng:
self.data_mng.Make()
# load Highway Main Link.
self.data_mng.load_hwy_main_link()
# 加载元数据的设施号
self.data_mng.load_org_facil_id()
else:
self.log.error('Higway Data Manager is None.')
return 0
# ## 高速路线
self._make_hwy_route()
if self.data_mng:
# 加载高速road_code
self.data_mng.load_hwy_road_code()
self.data_mng.load_hwy_ic_link()
self.data_mng.load_junction_name()
self.data_mng.load_hwy_inout_link()
self.data_mng.load_hwy_regulation()
self.data_mng.load_signpost()
# Temp
self.data_mng.load_exit_name()
self.data_mng.load_tollgate()
self.data_mng.load_exit_poi_name()
# 制作高速线路及设施(原始设施情报)
self._make_hwy_facil()
# 收费站情报
if self.hwy_toll:
self.hwy_toll.Make()
# ## 道路情报
self._make_road_no() # 道路番号
self._make_road_info() # 道路情报
# ## 设置ic_no
if self.data_mng:
self.data_mng.load_hwy_node_facilcls() # 加载设施种别
if self._make_ic_no(): # ic_no
self._make_facility_id() # 设施ID
# Mapping
if self.hwy_mapping:
self.hwy_mapping.Make()
# 设施情报
if self.data_mng:
self._make_ic_info()
# 附加情报(最终)
if self.node_addinfo:
self.node_addinfo.Make()
# 服务情报(For SAPA)
if self.service_info:
self.service_info.Make()
# 店铺情报(For SAPA)
if self.store:
self.store.Make()
# 调整link_type: Ramp ==> SAPA, Ramp ==> JCT
# if self.adjust_link:
# self.adjust_link.Make()
def _make_hwy_route(self):
'''高速路线'''
if self.hwy_route:
self.hwy_route.Make()
def _make_hwy_facil(self):
# ########################################
# temp
if self.hwy_facil:
# ########################################
self.hwy_facil.Make()
def _make_ic_no(self):
if not self.data_mng:
return False
self.log.info('Start Make IC NO.')
self.CreateTable2('mid_hwy_ic_no')
self.pg.connect1()
curr_idx = 0
ic_no = 1
data = self.data_mng.get_road_code_path()
for hwy in data:
road_code = hwy[0]
updown = hwy[1]
node_list = hwy[2]
cycle_flag = is_cycle_path(node_list)
if cycle_flag:
node_list.pop()
ic_list = self._get_ic_list(road_code, updown, node_list,
cycle_flag)
curr_idx = 0
while curr_idx < len(ic_list):
curr_facil = ic_list[curr_idx]
next_idx = curr_idx + 1
if next_idx == len(ic_list):
pass
if curr_facil.boundary_flag and not curr_facil.road_point:
# 边界点
pass
elif next_idx < len(ic_list):
while next_idx < len(ic_list):
next_facil = ic_list[next_idx]
if (curr_facil.road_code == next_facil.road_code and
curr_facil.road_point == next_facil.road_point
and curr_facil.facilcls
== next_facil.facilcls):
if (curr_facil.inout == INOUT_TYPE_OUT
and next_facil.inout == INOUT_TYPE_IN):
next_idx += 1
else:
pass
break
else: # 最后一个设施
pass
self._insert_ic_no(ic_no, ic_list[curr_idx:next_idx])
ic_no += 1
curr_idx = next_idx
self.pg.commit1()
self.CreateIndex2('mid_hwy_ic_no_node_id_idx')
self.CreateIndex2('mid_hwy_ic_no_node_id_road_code_idx')
self.CreateIndex2('mid_hwy_ic_no_node_id_road_code'
'_road_seq_updown_idx')
self.log.info('End Make IC NO.')
return True
def _get_ic_list(self, road_code, updown, node_list, cycle_flag):
G = self.data_mng.get_graph()
ic_group = [] # 一个点上的所有设施做为一个元素
for node_idx in range(0, len(node_list)):
node_id = node_list[node_idx]
if node_idx == 0 or node_idx == len(node_list) - 1:
# 起末点，不做边界点
boundary_flag = False
else:
# 判断第十层Tile边界
boundary_flag = self.is_hwy_tile_boundary(node_id, road_code)
if boundary_flag:
ml_object = MultiLangNameRDF('ENG', HWY_TILE_BOUNDARY_NAME)
bd_name = ml_object.json_format_dump()
boundary_facil_info = HwyFacilInfo(road_code,
HWY_INVALID_FACIL_ID_17CY,
IC_TYPE_INVALID, updown,
node_id, INOUT_TYPE_NONE,
bd_name)
boundary_facil_info.boundary_flag = boundary_flag
toll_flag = G.is_tollgate(node_id)
if G.is_hwy_node(node_id) or toll_flag:
# get facilities of this node
facil_infos = self.data_mng.get_hwy_facils_by_nodeid(
node_id, road_code)
if boundary_flag:
facil_infos.append(boundary_facil_info)
# 对当前点的多个设施进行排序
facil_infos = self._sort_facils(facil_infos)
if facil_infos:
ic_group.append(facil_infos)
elif boundary_flag: # 边界
ic_group.append([boundary_facil_info])
ic_list = []
# ## 重排头尾设施
# 第一个设施(同个点上可能有多个)
ic_list += self._sort_start_facils(ic_group[0], cycle_flag)
# 最后一个设施(同个点上可能有多个)
ic_group[-1] = self._sort_end_facils(ic_group[-1], cycle_flag)
for ic_group_idx in range(1, len(ic_group) - 1):
ic_list += ic_group[ic_group_idx]
ic_list += ic_group[-1]
return ic_list
def _sort_facils(self, facil_infos):
'''对同个点的设施进行排序。按设施种别排序'''
ic_list = []
if not facil_infos:
return []
# 按road_seq排序
facil_infos = self._sort_facils_by_seq(facil_infos)
# ## 入口
sapa_outs = self.get_sapa_in(facil_infos)
for sapa_in in sapa_outs:
ic_list.append(sapa_in)
jct_ins = self.get_jct_in(facil_infos)
for jct_in in jct_ins:
ic_list.append(jct_in)
ic_ins = self.get_ic_in(facil_infos)
for ic_in in ic_ins:
ic_list.append(ic_in)
# ## 料金所
tolls = self.get_tolls(facil_infos)
for toll in tolls:
ic_list.append(toll)
# 边界点
for facil_info in facil_infos:
if facil_info.boundary_flag:
ic_list.append(facil_info)
# ## 出口
ic_outs = self.get_ic_out(facil_infos)
for ic_out in ic_outs:
ic_list.append(ic_out)
jct_outs = self.get_jct_out(facil_infos)
for jct_out in jct_outs:
ic_list.append(jct_out)
sapa_outs = self.get_sapa_out(facil_infos)
for sapa_out in sapa_outs:
ic_list.append(sapa_out)
return ic_list
def is_hwy_tile_boundary(self, node_id, roadcode):
'''判断是不是第十层边界: 进入本线link的TileId与出去本线link的TielId不同。'''
G = self.data_mng.get_graph()
in_tile, out_tile = None, None
in_tiles = G.get_in_tile(node_id, roadcode)
if in_tiles:
if len(in_tiles) > 1:
self.log.warning('Main InTile > 1,boundary_node=%s' % node_id)
in_tile = convert_tile_id(in_tiles[0])
out_tiles = G.get_out_tile(node_id, roadcode)
if out_tiles:
if len(out_tiles) > 1:
self.log.warning('Main OutTile > 1,boundary_node=%s' % node_id)
out_tile = convert_tile_id(out_tiles[0])
if not in_tile or not out_tile:
self.log.warning('No InTile or No OutTile. boundary_node=%s' %
node_id)
return False
return in_tile != out_tile
def _make_facility_id(self):
'''生成1到N的设施番号，边界点没有设施号'''
self.CreateTable2('mid_hwy_facility_id')
sqlcmd = """
INSERT INTO mid_hwy_facility_id(road_code, road_seq)
(
SELECT distinct road_code, road_seq
from hwy_node
order by road_code, road_seq
);
"""
self.pg.execute2(sqlcmd)
self.pg.commit2()
self.CreateIndex2('mid_hwy_facility_id_road_code_road_seq_idx')
# 更新边界点的设施id, 边界点的设施id设成[无效设施id]
sqlcmd = """
UPDATE mid_hwy_ic_no set facility_id = %s
WHERE road_seq = %s;
"""
self.pg.execute2(
sqlcmd, (HWY_INVALID_FACIL_ID_17CY, HWY_INVALID_FACIL_ID_17CY))
self.pg.commit2()
# 更新ic_no表的设施id
sqlcmd = """
UPDATE mid_hwy_ic_no as ic set facility_id = facil.facility_id
FROM mid_hwy_facility_id as facil
WHERE ic.road_code = facil.road_code
and ic.road_seq = facil.road_seq;
"""
self.pg.execute2(sqlcmd)
self.pg.commit2()
def _make_road_no(self):
'''道路番号(上下共用)'''
self.log.info('Start Make Road No.')
self.pg.connect2()
if not self.pg.IsExistTable('hwy_link_road_code_info'):
self.log.error('No table hwy_link_road_code_info.')
return 0
self.CreateTable2('mid_hwy_road_no')
# 当一条道路有多种road_type时，取link数据最多的
sqlcmd = """
INSERT INTO mid_hwy_road_no(road_code, road_type)
(
SELECT road_code, (array_agg(road_type))[1] as road_type
FROM (
SELECT road_code, road_type, count(road_type) as link_num
FROM hwy_link_road_code_info as a
LEFT JOIN link_tbl as b
on a.link_id = b.link_id
where a.link_id is not null
group by road_code, road_type
order by road_code, link_num DESC
) AS b
group by road_code
order by road_code
);
"""
self.pg.execute2(sqlcmd)
self.pg.commit2()
self.log.info('End Make Road No.')
def _make_road_info(self):
'''道路情报'''
self.log.info('Start Make Road Info.')
if not self.pg.IsExistTable('mid_hwy_road_no'):
self.log.error('No table mid_hwy_road_no.')
return 0
if not self.pg.IsExistTable('hwy_link_road_code_info'):
self.log.error('No table hwy_link_road_code_info.')
return 0
self.CreateTable2('highway_road_info')
self.pg.connect1()
sqlcmd = """
INSERT INTO highway_road_info(
road_no, iddn_road_kind, road_kind,
road_attr, loop, "new",
un_open, name, up_down,
road_number)
VALUES (%s, %s, %s,
%s, %s, %s,
%s, %s, %s,
%s);
"""
data = self.__get_road_info()
for info in data:
road_no, t_updown, road_kind, path, road_name, road_num = info[0:6]
road_attr = self.convert_road_attr(t_updown)
updown = self.convert_updown(t_updown)
iddn_road_kind = 0 # 高速
if is_cycle_path(path):
loop = HWY_TRUE
else:
loop = HWY_FALSE
new, un_open = HWY_FALSE, HWY_FALSE
self.pg.execute1(sqlcmd,
(road_no, iddn_road_kind, road_kind, road_attr,
loop, new, un_open, road_name, updown, road_num))
self.pg.commit1()
self.log.info('Start End Road Info.')
def convert_updown(self, updown):
# 0…下り、1…上り、2…RESERVED、3…上下線共有
if updown == HWY_UPDOWN_TYPE_UP:
return 1
elif updown == HWY_UPDOWN_TYPE_DOWN:
return 0
else:
return None
def convert_road_attr(self, updown):
if updown == HWY_UPDOWN_TYPE_UP:
return ROAD_ATTR_UP
elif updown == HWY_UPDOWN_TYPE_DOWN:
return ROAD_ATTR_DOWN
else:
return None
def __get_road_info(self):
sqlcmd = """
SELECT road_no, updown, road_type,
path, road_name, road_number
FROM mid_hwy_road_no AS a
LEFT JOIN (
SELECT road_code, updown, ARRAY_AGG(node_id) AS path
FROM (
SELECT road_code, updown, node_id, seq_nm
FROM hwy_link_road_code_info
ORDER BY road_code, updown, seq_nm
) AS A
GROUP BY road_code, updown
) AS b
ON a.road_code = b.road_code
LEFT JOIN road_code_info as c
ON a.road_code = c.road_code
ORDER BY road_no, updown
"""
return self.get_batch_data(sqlcmd)
def _make_ic_info(self):
self.log.info('Making IC Info.')
self.pg.connect1()
self.pg.connect2()
self.CreateTable2('highway_ic_info')
self.CreateTable2('highway_path_point')
self.CreateTable2('highway_conn_info')
self.CreateTable2('highway_toll_info')
self.CreateTable2('mid_hwy_node_add_info')
# self.CreateTable2('mid_hwy_node_add_info')
for ic_no, facility_id, facil_list in self.data_mng.get_ic_list():
if facility_id != HWY_INVALID_FACIL_ID_17CY: # 非边界点
ic_info = HwyICInfoRDF(ic_no, facility_id, facil_list,
self.data_mng)
ic_info.set_ic_info() # 设置料金情报
self._insert_ic_info(ic_info)
self._insert_path_point(ic_info)
self._insert_conn_info(ic_info)
# self.__insert_toll_info(ic_info)
# self.__insert_temp_add_info(ic_info)
else:
# 边界出口点（离开当前Tile）
ic_info = HwyBoundaryOutInfoRDF(ic_no, facility_id, facil_list,
self.data_mng)
ic_info.set_ic_info()
self._insert_ic_info(ic_info)
self._insert_path_point(ic_info)
# 边界进入点（进入Tile的点）
ic_info = HwyBoundaryInInfoRDF(ic_no, facility_id, facil_list,
self.data_mng)
ic_info.set_ic_info()
self._insert_ic_info(ic_info)
self._insert_path_point(ic_info)
self.pg.commit1()
self.CreateIndex2('highway_ic_info_ic_no_idx')
self.CreateIndex2('highway_toll_info_ic_no_conn_ic_no_node_id_idx')
self.CreateIndex2('highway_conn_info_ic_no_conn'
'_ic_no_conn_direction_idx')
# self._add_geom_column()
# ==========================================================================
# 插入
# ==========================================================================
def _insert_ic_no(self, ic_no, facil_info_list):
sqlcmd = """
INSERT INTO mid_hwy_ic_no(
ic_no, node_id,
road_code, road_seq,
updown, facilclass_c,
inout_c, facil_name)
VALUES (%s, %s,
%s, %s,
%s, %s,
%s, %s);
"""
for facil in facil_info_list:
self.pg.execute1(
sqlcmd,
(ic_no, facil.node_id, facil.road_code, facil.road_point,
facil.updown, facil.facilcls, facil.inout, facil.facil_name))
def _insert_ic_info(self, ic):
sqlcmd = """
INSERT INTO highway_ic_info(
ic_no, up_down, facility_id,
between_distance, inside_distance, enter,
exit, tollgate, jct,
pa, sa, ic,
ramp, smart_ic, barrier,
dummy, boundary, "new",
unopen, forward_flag, reverse_flag,
toll_count, enter_direction, path_count,
vics_count, conn_count, illust_count,
store_count, servise_flag, road_no,
"name", conn_tile_id, tile_id,
node_id)
VALUES (%s, %s, %s,
%s, %s, %s,
%s, %s, %s,
%s, %s, %s,
%s, %s, %s,
%s, %s, %s,
%s, %s, %s,
%s, %s, %s,
%s, %s, %s,
%s, %s, %s,
%s, %s, %s,
%s);
"""
params = (ic.ic_no, ic.updown, ic.facility_id, ic.between_distance,
ic.inside_distance, ic.enter, ic.exit, ic.tollgate, ic.jct,
ic.pa, ic.sa, ic.ic, ic.ramp, ic.smart_ic, ic.barrier,
ic.dummy, ic.boundary, ic.new, ic.unopen, ic.forward_flag,
ic.reverse_flag, ic.toll_count, ic.enter_direction,
ic.path_count, ic.vics_count, ic.conn_count, ic.illust_count,
ic.store_count, ic.servise_flag, ic.road_no, ic.name,
ic.conn_tile_id, ic.tile_id, ic.facil_list[0].node_id)
self.pg.execute1(sqlcmd, params)
def _insert_path_point(self, ic):
sqlcmd = """
INSERT INTO highway_path_point(
ic_no, enter_flag,
exit_flag, main_flag,
center_flag, new_flag,
unopen_flag, pos_flag,
link_id, node_id,
tile_id)
VALUES (%s, %s,
%s, %s,
%s, %s,
%s, %s,
%s, %s,
%s);
"""
for point in ic.path_points:
self.pg.execute1(
sqlcmd, (point.ic_no, point.enter_flag, point.exit_flag,
point.main_flag, point.center_flag, point.new_flag,
point.unopen_flag, point.pos_flag, point.link_id,
point.node_id, point.tile_id))
# self.pg.commit1()
def _insert_conn_info(self, ic_info):
sqlcmd = """
INSERT INTO highway_conn_info(
ic_no, road_attr,
conn_direction, same_road_flag,
tile_change_flag, uturn_flag,
new_flag, unopen_flag,
vics_flag, toll_flag,
conn_road_no, conn_ic_no,
conn_link_length, conn_tile_id,
toll_count, vics_count,
tile_id, ic_name,
conn_ic_name)
VALUES (%s, %s, %s, %s,
%s, %s, %s, %s,
%s, %s, %s, %s,
%s, %s, %s, %s,
%s, %s, %s);
"""
for conn in ic_info.get_conn_info():
self.pg.execute1(
sqlcmd, (conn.ic_no, conn.road_attr, conn.conn_direction,
conn.same_road_flag, conn.tile_change_flag,
conn.uturn_flag, conn.new_flag, conn.unopen_flag,
conn.vics_flag, conn.toll_flag, conn.conn_road_no,
conn.conn_ic_no, conn.conn_length, conn.conn_tile_id,
conn.toll_count, conn.vics_count, conn.tile_id,
conn.ic_name, conn.conn_ic_name))
# self.pg.commit1()
def _insert_toll_info(self, ic_info):
'''料金情报。'''
sqlcmd = """
INSERT INTO highway_toll_info(
ic_no, conn_ic_no,
toll_class, class_name,
up_down, facility_id,
tollgate_count, etc_antenna,
enter, exit,
jct, sa_pa,
gate, unopen,
dummy, non_ticket_gate,
check_gate, single_gate,
cal_gate, ticket_gate,
nest, uturn,
not_guide, normal_toll,
etc_toll, etc_section,
node_id, road_code,
road_seq, "name",
dummy_toll_node)
values(%s, %s, %s, %s, %s, %s,
%s, %s, %s, %s, %s, %s,
%s, %s, %s, %s, %s, %s,
%s, %s, %s, %s, %s, %s,
%s, %s, %s, %s, %s, %s,
%s);
"""
for toll in ic_info.get_all_toll_info():
toll_type = toll.toll_type
param = (toll.ic_no, toll.conn_ic_no, toll.toll_class,
toll.class_name, toll.updown, toll.facility_id,
toll.tollgate_count, toll_type.etc_antenna,
toll_type.enter, toll_type.exit, toll_type.jct,
toll_type.sa_pa, toll_type.gate, toll_type.unopen,
toll_type.dummy_facil, toll_type.non_ticket_gate,
toll_type.check_gate, toll_type.single_gate,
toll_type.cal_gate, toll_type.ticket_gate, toll_type.nest,
toll_type.uturn, toll_type.not_guide,
toll_type.normal_toll, toll_type.etc_toll,
toll_type.etc_section, toll.node_id, toll.road_code,
toll.road_seq, toll.name_kanji, toll.dummy_toll_node)
self.pg.execute1(sqlcmd, param)
def _insert_temp_add_info(self, ic_info, toll_flag=IC_TYPE_TRUE):
'''临时附加情报'''
sqlcmd = """
INSERT INTO mid_hwy_node_add_info(ic_no, updown,
facility_id, facilcls,
in_out, link_lid,
node_lid, add_node_id,
add_link_id, pos_type,
pos_type_name, name_kanji,
name_yomi, toll_flag,
dir_s_node, dir_e_node,
from_linkid, path_type,
in_linkid, ic_num
)
VALUES(%s, %s, %s, %s,
%s, %s, %s, %s,
%s, %s, %s, %s,
%s, %s, %s, %s,
%s, %s, %s, %s)
"""
for add_info in ic_info.get_add_info():
param = (ic_info.ic_no, ic_info.updown, ic_info.facility_id,
add_info.get('facilcls'), add_info.get('in_out'),
add_info.get('link_lid'), add_info.get('node_lid'),
add_info.get('add_node'), add_info.get('add_link'),
add_info.get('pos_type'), add_info.get('pos_type_name'),
ic_info.name, ic_info.name_yomi, toll_flag,
add_info.get('dir_s_node'), add_info.get('dir_e_node'),
add_info.get('from_linkid'), add_info.get('path_type'),
add_info.get('in_linkid'), add_info.get('ic_num'))
self.pg.execute1(sqlcmd, param)