{"id":"https://openalex.org/W4321372304","doi":"https://doi.org/10.3390/ijgi12020070","title":"A Comparison of Cartographic and Toponymic Databases in a Multilingual Environment: A Methodology for Detecting Redundancies Using ETL and GIS Tools","display_name":"A Comparison of Cartographic and Toponymic Databases in a Multilingual Environment: A Methodology for Detecting Redundancies Using ETL and GIS Tools","publication_year":2023,"publication_date":"2023-02-18","ids":{"openalex":"https://openalex.org/W4321372304","doi":"https://doi.org/10.3390/ijgi12020070"},"language":"en","primary_location":{"id":"doi:10.3390/ijgi12020070","is_oa":true,"landing_page_url":"https://doi.org/10.3390/ijgi12020070","pdf_url":"https://www.mdpi.com/2220-9964/12/2/70/pdf?version=1677122457","source":{"id":"https://openalex.org/S2764431341","display_name":"ISPRS International Journal of Geo-Information","issn_l":"2220-9964","issn":["2220-9964"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ISPRS International Journal of Geo-Information","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.mdpi.com/2220-9964/12/2/70/pdf?version=1677122457","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5013362071","display_name":"Oihana Mitxelena-Hoyos","orcid":"https://orcid.org/0000-0001-6360-9153"},"institutions":[{"id":"https://openalex.org/I169108374","display_name":"University of the Basque Country","ror":"https://ror.org/000xsnr85","country_code":"ES","type":"education","lineage":["https://openalex.org/I169108374"]},{"id":"https://openalex.org/I4210129570","display_name":"Instituto Geogr\u00e1fico Nacional","ror":"https://ror.org/03yycdv57","country_code":"ES","type":"other","lineage":["https://openalex.org/I4210129570"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Oihana Mitxelena-Hoyos","raw_affiliation_strings":["Escuela de Ingenier\u00eda de Gipuzkoa, UPV-EHU, 20018 San Sebastian, Spain","Instituto Geogr\u00e1fico Nacional-Servicio Regional en Cantabria-Pa\u00eds Vasco, 20010 San Sebastian, Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Escuela de Ingenier\u00eda de Gipuzkoa, UPV-EHU, 20018 San Sebastian, Spain","institution_ids":["https://openalex.org/I169108374"]},{"raw_affiliation_string":"Instituto Geogr\u00e1fico Nacional-Servicio Regional en Cantabria-Pa\u00eds Vasco, 20010 San Sebastian, Spain","institution_ids":["https://openalex.org/I4210129570"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5067441007","display_name":"Jos\u00e9-L\u00e1zaro Amaro-Mellado","orcid":"https://orcid.org/0000-0003-1218-1075"},"institutions":[{"id":"https://openalex.org/I4210129570","display_name":"Instituto Geogr\u00e1fico Nacional","ror":"https://ror.org/03yycdv57","country_code":"ES","type":"other","lineage":["https://openalex.org/I4210129570"]},{"id":"https://openalex.org/I79238269","display_name":"Universidad de Sevilla","ror":"https://ror.org/03yxnpp24","country_code":"ES","type":"education","lineage":["https://openalex.org/I79238269"]}],"countries":["ES"],"is_corresponding":true,"raw_author_name":"Jos\u00e9-L\u00e1zaro Amaro-Mellado","raw_affiliation_strings":["Departamento de Ingenier\u00eda Gr\u00e1fica, Universidad de Sevilla, 41092 Seville, Spain","Instituto Geogr\u00e1fico Nacional-Servicio Regional en Andaluc\u00eda, 41013 Seville, Spain"],"raw_orcid":"https://orcid.org/0000-0003-1218-1075","affiliations":[{"raw_affiliation_string":"Departamento de Ingenier\u00eda Gr\u00e1fica, Universidad de Sevilla, 41092 Seville, Spain","institution_ids":["https://openalex.org/I79238269"]},{"raw_affiliation_string":"Instituto Geogr\u00e1fico Nacional-Servicio Regional en Andaluc\u00eda, 41013 Seville, Spain","institution_ids":["https://openalex.org/I4210129570"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5067441007"],"corresponding_institution_ids":["https://openalex.org/I4210129570","https://openalex.org/I79238269"],"apc_list":{"value":1700,"currency":"CHF","value_usd":1893},"apc_paid":{"value":1700,"currency":"CHF","value_usd":1893},"fwci":4.4877,"has_fulltext":true,"cited_by_count":5,"citation_normalized_percentile":{"value":0.94319764,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":"12","issue":"2","first_page":"70","last_page":"70"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10757","display_name":"Geographic Information Systems Studies","score":0.9987000226974487,"subfield":{"id":"https://openalex.org/subfields/3305","display_name":"Geography, Planning and Development"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T10757","display_name":"Geographic Information Systems Studies","score":0.9987000226974487,"subfield":{"id":"https://openalex.org/subfields/3305","display_name":"Geography, Planning and Development"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T13854","display_name":"Historical Geography and Cartography","score":0.9707000255584717,"subfield":{"id":"https://openalex.org/subfields/3305","display_name":"Geography, Planning and Development"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9667999744415283,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/cadastre","display_name":"Cadastre","score":0.9008486270904541},{"id":"https://openalex.org/keywords/toponymy","display_name":"Toponymy","score":0.8290006518363953},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.5589945316314697},{"id":"https://openalex.org/keywords/cartography","display_name":"Cartography","score":0.4791521430015564},{"id":"https://openalex.org/keywords/geographic-information-system","display_name":"Geographic information system","score":0.45993733406066895},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.4443754553794861},{"id":"https://openalex.org/keywords/correlative","display_name":"Correlative","score":0.43475469946861267},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3961881697177887},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3905375897884369},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3340336084365845},{"id":"https://openalex.org/keywords/linguistics","display_name":"Linguistics","score":0.2571062445640564},{"id":"https://openalex.org/keywords/archaeology","display_name":"Archaeology","score":0.1748426854610443}],"concepts":[{"id":"https://openalex.org/C134207755","wikidata":"https://www.wikidata.org/wiki/Q191072","display_name":"Cadastre","level":2,"score":0.9008486270904541},{"id":"https://openalex.org/C116856471","wikidata":"https://www.wikidata.org/wiki/Q485762","display_name":"Toponymy","level":2,"score":0.8290006518363953},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.5589945316314697},{"id":"https://openalex.org/C58640448","wikidata":"https://www.wikidata.org/wiki/Q42515","display_name":"Cartography","level":1,"score":0.4791521430015564},{"id":"https://openalex.org/C41856607","wikidata":"https://www.wikidata.org/wiki/Q483130","display_name":"Geographic information system","level":2,"score":0.45993733406066895},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4443754553794861},{"id":"https://openalex.org/C2776800370","wikidata":"https://www.wikidata.org/wiki/Q5172864","display_name":"Correlative","level":2,"score":0.43475469946861267},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3961881697177887},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3905375897884369},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3340336084365845},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.2571062445640564},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.1748426854610443},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":5,"locations":[{"id":"doi:10.3390/ijgi12020070","is_oa":true,"landing_page_url":"https://doi.org/10.3390/ijgi12020070","pdf_url":"https://www.mdpi.com/2220-9964/12/2/70/pdf?version=1677122457","source":{"id":"https://openalex.org/S2764431341","display_name":"ISPRS International Journal of Geo-Information","issn_l":"2220-9964","issn":["2220-9964"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ISPRS International Journal of Geo-Information","raw_type":"journal-article"},{"id":"pmh:oai:addi.ehu.eus:10810/60187","is_oa":true,"landing_page_url":"http://hdl.handle.net/10810/60187","pdf_url":null,"source":{"id":"https://openalex.org/S4306400469","display_name":"Communities in ADDI (Universidad del Pais Vasco)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210131160","host_organization_name":"Material Physics Center","host_organization_lineage":["https://openalex.org/I4210131160"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:oai:doaj.org/article:ba6b40fc07eb43d0a2cca30995e9ccb5","is_oa":true,"landing_page_url":"https://doaj.org/article/ba6b40fc07eb43d0a2cca30995e9ccb5","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"ISPRS International Journal of Geo-Information, Vol 12, Iss 2, p 70 (2023)","raw_type":"article"},{"id":"pmh:oai:idus.us.es:11441/145972","is_oa":true,"landing_page_url":"https://idus.us.es/handle//11441/145972","pdf_url":null,"source":{"id":"https://openalex.org/S4306400333","display_name":"idUS (Universidad de Sevilla)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I79238269","host_organization_name":"Universidad de Sevilla","host_organization_lineage":["https://openalex.org/I79238269"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:oai:mdpi.com:/2220-9964/12/2/70/","is_oa":true,"landing_page_url":"https://dx.doi.org/10.3390/ijgi12020070","pdf_url":null,"source":{"id":"https://openalex.org/S4306400947","display_name":"MDPI (MDPI AG)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210097602","host_organization_name":"Multidisciplinary Digital Publishing Institute (Switzerland)","host_organization_lineage":["https://openalex.org/I4210097602"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"ISPRS International Journal of Geo-Information","raw_type":"Text"}],"best_oa_location":{"id":"doi:10.3390/ijgi12020070","is_oa":true,"landing_page_url":"https://doi.org/10.3390/ijgi12020070","pdf_url":"https://www.mdpi.com/2220-9964/12/2/70/pdf?version=1677122457","source":{"id":"https://openalex.org/S2764431341","display_name":"ISPRS International Journal of Geo-Information","issn_l":"2220-9964","issn":["2220-9964"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ISPRS International Journal of Geo-Information","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.49000000953674316,"display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":false},"content_urls":{"pdf":"https://content.openalex.org/works/W4321372304.pdf"},"referenced_works_count":67,"referenced_works":["https://openalex.org/W13837911","https://openalex.org/W1523503019","https://openalex.org/W1767073943","https://openalex.org/W1787217762","https://openalex.org/W1982494447","https://openalex.org/W1998268614","https://openalex.org/W2047197963","https://openalex.org/W2058497043","https://openalex.org/W2187812094","https://openalex.org/W2294902511","https://openalex.org/W2331611838","https://openalex.org/W2360947820","https://openalex.org/W2563293575","https://openalex.org/W2574657509","https://openalex.org/W2806189422","https://openalex.org/W2813959750","https://openalex.org/W2883530096","https://openalex.org/W2901011596","https://openalex.org/W2941426123","https://openalex.org/W2948672326","https://openalex.org/W2960153957","https://openalex.org/W2999950802","https://openalex.org/W3029145729","https://openalex.org/W3035820485","https://openalex.org/W3112529232","https://openalex.org/W3118714874","https://openalex.org/W3119055181","https://openalex.org/W3125645131","https://openalex.org/W3135455720","https://openalex.org/W3146112744","https://openalex.org/W3147681753","https://openalex.org/W3154409319","https://openalex.org/W3183822378","https://openalex.org/W3186310779","https://openalex.org/W3187586175","https://openalex.org/W3202583482","https://openalex.org/W3205972334","https://openalex.org/W3206596334","https://openalex.org/W3211521067","https://openalex.org/W3212834916","https://openalex.org/W4200538156","https://openalex.org/W4200582577","https://openalex.org/W4206058752","https://openalex.org/W4206961474","https://openalex.org/W4210368009","https://openalex.org/W4212793723","https://openalex.org/W4213247275","https://openalex.org/W4220669600","https://openalex.org/W4221073812","https://openalex.org/W4223430529","https://openalex.org/W4233533538","https://openalex.org/W4281755977","https://openalex.org/W4283025162","https://openalex.org/W4285109906","https://openalex.org/W4285168347","https://openalex.org/W4286433420","https://openalex.org/W4289515445","https://openalex.org/W4302351293","https://openalex.org/W4304606523","https://openalex.org/W4304693825","https://openalex.org/W4310607949","https://openalex.org/W4312932353","https://openalex.org/W6696824750","https://openalex.org/W6752986547","https://openalex.org/W6789795276","https://openalex.org/W6802035825","https://openalex.org/W6839146922"],"related_works":["https://openalex.org/W2361566382","https://openalex.org/W1562347873","https://openalex.org/W2114233742","https://openalex.org/W4247263692","https://openalex.org/W1963842245","https://openalex.org/W2051591117","https://openalex.org/W2017709107","https://openalex.org/W2359942614","https://openalex.org/W3089081172","https://openalex.org/W2212678439"],"abstract_inverted_index":{"Toponymy,":[0],"a":[1,66,102,118,126,134],"transversal":[2],"discipline":[3],"for":[4,80],"geography,":[5],"linguistics,":[6],"and":[7,25,39,63,73,76,87,125,148,154],"history,":[8],"finds":[9],"one":[10],"of":[11,44,53,65,95,139,150,162],"its":[12,26,155],"main":[13],"supports":[14],"in":[15,110,120],"cartography.":[16],"Due":[17],"to":[18,32,50,92,104,141,158],"exhaustiveness":[19],"on":[20,69],"the":[21,29,45,54,60,84,88,93,105,111,121,137,146,151,159,163],"territory,":[22],"cadastral":[23,85],"cartography":[24],"toponymy":[27],"have":[28],"ideal":[30],"characteristics":[31],"develop":[33],"systematic":[34],"geographical":[35,40],"analyses.":[36],"Moreover,":[37],"cadastre":[38],"names":[41],"are":[42,167],"part":[43],"geographic":[46],"reference":[47],"data":[48,123],"according":[49],"Annex":[51],"1":[52],"INSPIRE":[55],"directive.":[56],"This":[57,114],"work":[58],"presents":[59],"design,":[61],"implementation,":[62],"application":[64],"methodology":[67],"based":[68],"Geographic":[70],"Information":[71],"Systems":[72],"Extract,":[74],"Transform,":[75],"Load":[77],"(ETL)":[78],"tools":[79],"detecting":[81],"coincidences":[82],"between":[83,136],"geoinformation":[86],"official":[89,164],"gazetteer":[90],"corresponding":[91],"province":[94],"Gipuzkoa,":[96],"Spain.":[97],"Methodologically,":[98],"this":[99,144],"study":[100,112],"proposes":[101],"solution":[103],"issues":[106],"raised":[107],"by":[108],"bilingualism":[109],"area.":[113],"problem":[115],"is":[116],"approached":[117],"priori,":[119],"previous":[122],"treatment,":[124],"posteriori,":[127],"applying":[128],"semantic":[129],"criteria.":[130],"The":[131],"results":[132],"show":[133],"match":[135],"datasets":[138],"close":[140],"40%.":[142],"In":[143],"way,":[145],"uniqueness":[147],"richness":[149],"analyzed":[152],"source":[153],"outstanding":[156],"contribution":[157],"potential":[160],"integration":[161],"toponymic":[165],"corpus":[166],"evidenced.":[168]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1}],"updated_date":"2026-08-02T14:50:37.381335","created_date":"2025-10-10T00:00:00"}