},
'KatastralniUzemi': {
'level_value': 4,
'parent_attribute': 'ObecKod',
'id_attribute': 'Kod'
}
}
for l in list(
set(concept_list).intersection(
set(admunit_cz.get_data_source().list_layers()))):
admunit_cz.append_subgeoconcept(
SubGeoConcept(l,
l,
'AdmUnitFeature',
admunit_cz.get_attributes(),
data_source=DataSource(
admunit_cz.get_data_source().get_type(),
admunit_cz.get_data_source().get_name(), ({
**admunit_cz.get_data_source().get_attributes(),
**{
'layer': l
}
}), None,
admunit_cz.get_data_source().get_data_file()),
supergeoconcept=admunit_cz,
table_inheritance=False,
type='semantic',
subgeoconcepts=[]))
G = apply_function(compilable_node_dictionary(admunit_cz), 'admunit__tree')
# %%
#admunit_cz.get_data_source().download_data('archive.zip',s,'all',os.getcwd())
admunit_cz.get_data_source().set_data_file('20201031_ST_UKSG.xml')
# %%
concept_list=['Staty','Vusc','Okresy','Obce','KatastralniUzemi']
concept_additional_attributes={'Staty':{'level_value':0,'parent_value':'null','id_attribute':'Kod'},
'Vusc':{'level_value':1,'parent_value':'1','id_attribute':'Kod'},
'Okresy':{'level_value':2,'parent_attribute':'VuscKod','id_attribute':'Kod'},
'Obce':{'level_value':3,'parent_attribute':'OkresKod','id_attribute':'Kod'},
'KatastralniUzemi':{'level_value':4,'parent_attribute':'ObecKod','id_attribute':'Kod'}}
# %%
for l in list(set(concept_list).intersection(set(admunit_cz.get_data_source().list_layers()))):
admunit_cz.append_subgeoconcept(SubGeoConcept(l,l,'AdmUnitFeature',admunit_cz.get_attributes(),data_source=DataSource(admunit_cz.get_data_source().get_type(),admunit_cz.get_data_source().get_name(),({**admunit_cz.get_data_source().get_attributes(),**{'layer':l}}),None,admunit_cz.get_data_source().get_data_file()),supergeoconcept=admunit_cz,table_inheritance=False,type='semantic',subgeoconcepts=[]))
# %%
#administrative territorial units
dbs_admin_connection={'dbname':'olu_administrative_units','user':'******','host':'euxdat-db-svc','port':'5432','password':'******'}
dbs_admin=DBStorage(dbs_admin_connection)
dbs_admin.connect()
dbs_admin.disconnect()
dbs_admin.connect()
# %%
admunit_cz.create_table(dbs_admin, name='default',scheme='cz',conflict='append')
# %%
for sub in admunit_cz.get_subgeoconcepts():
sub.set_table(View(sub.get_name(),sub.get_attributes(), sub.get_supergeoconcept().get_table(),"level=%s" % (concept_additional_attributes[sub.get_name()]['level_value']), dbs=dbs_admin, scheme='public', type='usual'))
#admunit_cz.get_data_source().download_data('archive.zip',s,'all',os.getcwd())
admunit_cz.get_data_source().set_data_file('20201031_ST_UKSG.xml')
admunit_cz.create_table(dbs_admin, name='default',scheme='cz',conflict='append')
concept_list=['Staty','Vusc','Okresy','Obce','KatastralniUzemi']
concept_additional_attributes={'Staty':{'level_value':0,'parent_value':'null','id_attribute':'Kod'},
'Vusc':{'level_value':1,'parent_value':'1','id_attribute':'Kod'},
'Okresy':{'level_value':2,'parent_attribute':'VuscKod','id_attribute':'Kod'},
'Obce':{'level_value':3,'parent_attribute':'OkresKod','id_attribute':'Kod'},
'KatastralniUzemi':{'level_value':4,'parent_attribute':'ObecKod','id_attribute':'Kod'}}
for l in list(set(concept_list).intersection(set(admunit_cz.get_data_source().list_layers()))):
admunit_cz.append_subgeoconcept(SubGeoConcept(l,l,'AdmUnitFeature',admunit_cz.get_attributes(),data_source=DataSource(admunit_cz.get_data_source().get_type(),admunit_cz.get_data_source().get_name(),({**admunit_cz.get_data_source().get_attributes(),**{'layer':l}}),None,admunit_cz.get_data_source().get_data_file()),supergeoconcept=admunit_cz,table_inheritance=False,type='semantic',subgeoconcepts=[]))
G=apply_function(compilable_node_dictionary(admunit_cz),'admunit__tree')
lpis_cz__metadata=MetaData('LPIS in Czech Republic',
[{"url":"http://eagri.cz/public/app/eagriapp/lpisdata/[lpis_cz__posledni_aktualizace]-{admunit__tree__level4}-DPB-SHP.zip",
"format":"SHP", "compression":"zip"},{"url":"http://eagri.cz/public/app/eagriapp/lpisdata/[lpis_cz__posledni_aktualizace]-{admunit__tree__level4}-DPB-XML-A.zip",
"format":"XML", "compression":"zip"}],'data')
lpis_cz__ds_xml=ds_from_metadata(lpis_cz__metadata,format='XML')
lpis_cz=GeoConcept('LPIS in Czech Republic','LPIS in Czech Republic. All levels.',
'FeatureWithID',json_feature_structure, data_source=lpis_cz__ds_xml, subgeoconcepts=[], adm_graph_node='1')
url_adresa=lpis_cz.get_data_source().get_attributes()['url']
for i in re.findall('\[.*?\]',url_adresa):
if i in list(replacement_dictionary.keys()):
'KatastralniUzemi': {
'level_value': 4,
'parent_attribute': 'ObecKod',
'id_attribute': 'Kod'
}
}
# %%
for l in list(
set(concept_list).intersection(
set(admunit_cz.get_data_source().list_layers()))):
admunit_cz.append_subgeoconcept(
SubGeoConcept(l,
l,
'AdmUnitFeature',
admunit_cz.get_attributes(),
data_source=DataSource(
admunit_cz.get_data_source().get_type(),
admunit_cz.get_data_source().get_name(), ({
**admunit_cz.get_data_source().get_attributes(),
**{
'layer': l
}
}), None,
admunit_cz.get_data_source().get_data_file()),
supergeoconcept=admunit_cz,
table_inheritance=False,
type='semantic',
subgeoconcepts=[]))
# %%
#corine_cz.get_table().get_scheme()+'.'+corine_cz.get_table().get_name()
#ruian_parcely_cz.get_subgeoconcepts()[0].get_table().get_scheme()+'.'+ruian_parcely_cz.get_subgeoconcepts()[0].get_table().get_name()
# %%
admunit_cz__ds.set_data_file('20201031_ST_UKSG.xml')
# %%
concept_list=['Staty','Vusc','Okresy','Obce','KatastralniUzemi']
concept_additional_attributes={'Staty':{'level_value':0,'parent_value':'null','id_attribute':'Kod'},
'Vusc':{'level_value':1,'parent_value':'1','id_attribute':'Kod'},
'Okresy':{'level_value':2,'parent_attribute':'VuscKod','id_attribute':'Kod'},
'Obce':{'level_value':3,'parent_attribute':'OkresKod','id_attribute':'Kod'},
'KatastralniUzemi':{'level_value':4,'parent_attribute':'ObecKod','id_attribute':'Kod'}}
for l in list(set(concept_list).intersection(set(admunit_cz.get_data_source().list_layers()))):
admunit_cz.append_subgeoconcept(SubGeoConcept(l,l,'AdmUnitFeature',admunit_cz.get_attributes(),data_source=DataSource(admunit_cz.get_data_source().get_type(),admunit_cz.get_data_source().get_name(),({**admunit_cz.get_data_source().get_attributes(),**{'layer':l}}),None,admunit_cz.get_data_source().get_data_file()),supergeoconcept=admunit_cz,table_inheritance=False,type='semantic',subgeoconcepts=[]))
# %%
concept_list=['Parcely']
concept_additional_attributes={'Parcely':{'id_attribute':'Id'}}
for i in re.findall('\{.*?\}',ruian_parcely_cz.get_data_source().get_attributes()['url']):
if i[1:-1] in list(compilable_tree_dictionary(admunit_cz).keys()):
for j in apply_function(compilable_tree_dictionary(admunit_cz),i[1:-1]):
ruian_parcely_cz.append_subgeoconcept(SubGeoConcept(str(j),'RUIAN land parcels in Czech administrative territorial unit %s ' % str(j),'FeatureWithID',ruian_parcely_cz.get_attributes(),data_source=DataSource(ruian_parcely_cz.get_data_source().get_type(),ruian_parcely_cz.get_data_source().get_name(),(dict(ruian_parcely_cz.get_data_source().get_attributes(),**{'url':ruian_parcely_cz.get_data_source().get_attributes()['url'].replace(i,str(j))})),None,None),supergeoconcept=ruian_parcely_cz,table_inheritance=True,subgeoconcepts=[]))
# %%
for i in re.findall('\{.*?\}',lpis_cz.get_data_source().get_attributes()['url']):
if i[1:-1] in list(compilable_tree_dictionary(admunit_cz).keys()):