{"id":"https://openalex.org/W3167795652","doi":"https://doi.org/10.3390/app11115129","title":"Accurate Algorithms for Spatial Operations on the Spheroid in a Spatial Database Management System","display_name":"Accurate Algorithms for Spatial Operations on the Spheroid in a Spatial Database Management System","publication_year":2021,"publication_date":"2021-05-31","ids":{"openalex":"https://openalex.org/W3167795652","doi":"https://doi.org/10.3390/app11115129","mag":"3167795652"},"language":"en","primary_location":{"id":"doi:10.3390/app11115129","doi":"https://doi.org/10.3390/app11115129","is_oa":true,"landing_page_url":"https://doi.org/10.3390/app11115129","pdf_url":"https://www.mdpi.com/2076-3417/11/11/5129/pdf?version=1623232696","source":{"id":"https://openalex.org/S4210205812","display_name":"Applied Sciences","issn_l":"2076-3417","issn":["2076-3417"],"is_oa":true,"is_in_doaj":true,"is_core":true,"listed_in":["anvur-class-a","anvur-scientific","cwts-core","doaj","norway-1","oarl","poland-100","russia-white-list-2","vabb-shw"],"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":"Applied Sciences","raw_type":"journal-article"},"volume":null,"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.mdpi.com/2076-3417/11/11/5129/pdf?version=1623232696","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5061442120","display_name":"Jos\u00e9 Carlos Mart\u00ednez-Llario","orcid":"https://orcid.org/0000-0002-1037-5178","observed_orcids":["https://orcid.org/0000-0002-1037-5178"]},"institutions":[{"id":"https://openalex.org/I60053951","display_name":"Universitat Polit\u00e8cnica de Val\u00e8ncia","ror":"https://ror.org/01460j859","country_code":"ES","type":"education","lineage":["https://openalex.org/I60053951"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Jos\u00e9 Carlos Mart\u00ednez-Llario","raw_affiliation_strings":["Instituto ITACA, Universitat Polit\u00e8cnica de Val\u00e8ncia, Camino de Vera s/n, 46022 Val\u00e8ncia, Spain"],"raw_orcid":"https://orcid.org/0000-0002-1037-5178","affiliations":[{"raw_affiliation_string":"Instituto ITACA, Universitat Polit\u00e8cnica de Val\u00e8ncia, Camino de Vera s/n, 46022 Val\u00e8ncia, Spain","institution_ids":["https://openalex.org/I60053951"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018231099","display_name":"Sergio Baselga","orcid":"https://orcid.org/0000-0002-0492-4003","observed_orcids":["https://orcid.org/0000-0002-0492-4003"]},"institutions":[{"id":"https://openalex.org/I60053951","display_name":"Universitat Polit\u00e8cnica de Val\u00e8ncia","ror":"https://ror.org/01460j859","country_code":"ES","type":"education","lineage":["https://openalex.org/I60053951"]}],"countries":["ES"],"is_corresponding":true,"raw_author_name":"Sergio Baselga","raw_affiliation_strings":["Cartographic Engineering, Geodesy and Photogrammetry Department, Universitat Polit\u00e8cnica de Val\u00e8ncia, Camino de Vera s/n, 46022 Val\u00e8ncia, Spain"],"raw_orcid":"https://orcid.org/0000-0002-0492-4003","affiliations":[{"raw_affiliation_string":"Cartographic Engineering, Geodesy and Photogrammetry Department, Universitat Polit\u00e8cnica de Val\u00e8ncia, Camino de Vera s/n, 46022 Val\u00e8ncia, Spain","institution_ids":["https://openalex.org/I60053951"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5074433844","display_name":"Elo\u00edna Coll Aliaga","orcid":"https://orcid.org/0000-0001-8938-9216","observed_orcids":["https://orcid.org/0000-0001-8938-9216"]},"institutions":[{"id":"https://openalex.org/I60053951","display_name":"Universitat Polit\u00e8cnica de Val\u00e8ncia","ror":"https://ror.org/01460j859","country_code":"ES","type":"education","lineage":["https://openalex.org/I60053951"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Elo\u00edna Coll","raw_affiliation_strings":["Instituto ITACA, Universitat Polit\u00e8cnica de Val\u00e8ncia, Camino de Vera s/n, 46022 Val\u00e8ncia, Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Instituto ITACA, Universitat Polit\u00e8cnica de Val\u00e8ncia, Camino de Vera s/n, 46022 Val\u00e8ncia, Spain","institution_ids":["https://openalex.org/I60053951"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5018231099"],"corresponding_institution_ids":["https://openalex.org/I60053951"],"apc_list":{"value":2000,"currency":"CHF","value_usd":2160},"apc_paid":{"value":2000,"currency":"CHF","value_usd":2160},"fwci":7.3297,"has_fulltext":true,"cited_by_count":11,"citation_normalized_percentile":{"value":0.96757583,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"11","issue":"11","first_page":"5129","last_page":"5129"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13854","display_name":"Historical Geography and Cartography","score":0.35690000653266907,"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/T13854","display_name":"Historical Geography and Cartography","score":0.35690000653266907,"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.32499998807907104,"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"}},{"id":"https://openalex.org/T10757","display_name":"Geographic Information Systems Studies","score":0.10050000250339508,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/ellipsoids","display_name":"ellipsoids","score":0.8389999866485596},{"id":"https://openalex.org/keywords/spheroids","display_name":"spheroids","score":0.8100000023841858},{"id":"https://openalex.org/keywords/spatial-database-management-systems","display_name":"spatial database management systems","score":0.7609999775886536},{"id":"https://openalex.org/keywords/spatial-analysis-software","display_name":"spatial analysis software","score":0.6269999742507935},{"id":"https://openalex.org/keywords/computational-accuracy","display_name":"computational accuracy","score":0.7590000033378601},{"id":"https://openalex.org/keywords/spatial-operators","display_name":"spatial operators","score":0.40700000524520874}],"concepts":[{"id":"https://openalex.org/C57489055","wikidata":"https://www.wikidata.org/wiki/Q190046","display_name":"Ellipsoid","level":2,"score":0.8534516096115112},{"id":"https://openalex.org/C165818556","wikidata":"https://www.wikidata.org/wiki/Q213488","display_name":"Geodesic","level":2,"score":0.7597711682319641},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.6779722571372986},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5508496761322021},{"id":"https://openalex.org/C64543145","wikidata":"https://www.wikidata.org/wiki/Q162942","display_name":"Intersection (aeronautics)","level":2,"score":0.5408819317817688},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.5396220088005066},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.5109032988548279},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.4334748387336731},{"id":"https://openalex.org/C198082294","wikidata":"https://www.wikidata.org/wiki/Q3399648","display_name":"Position (finance)","level":2,"score":0.42974787950515747},{"id":"https://openalex.org/C16038011","wikidata":"https://www.wikidata.org/wiki/Q62912","display_name":"Cartesian coordinate system","level":2,"score":0.41854721307754517},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.3611249029636383},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.3217148780822754},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.19851988554000854},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.1949085295200348},{"id":"https://openalex.org/C58640448","wikidata":"https://www.wikidata.org/wiki/Q42515","display_name":"Cartography","level":1,"score":0.09292972087860107},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.3390/app11115129","doi":"https://doi.org/10.3390/app11115129","is_oa":true,"landing_page_url":"https://doi.org/10.3390/app11115129","pdf_url":"https://www.mdpi.com/2076-3417/11/11/5129/pdf?version=1623232696","source":{"id":"https://openalex.org/S4210205812","display_name":"Applied Sciences","issn_l":"2076-3417","issn":["2076-3417"],"is_oa":true,"is_in_doaj":true,"is_core":true,"listed_in":["anvur-class-a","anvur-scientific","cwts-core","doaj","norway-1","oarl","poland-100","russia-white-list-2","vabb-shw"],"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":"Applied Sciences","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:6dea2f67e6064fb2a6edaaf7d70724d3","doi":null,"is_oa":true,"landing_page_url":"https://doaj.org/article/6dea2f67e6064fb2a6edaaf7d70724d3","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,"listed_in":[],"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":"Applied Sciences, Vol 11, Iss 11, p 5129 (2021)","raw_type":"article"},{"id":"pmh:oai:riunet.upv.es:10251/182721","doi":null,"is_oa":true,"landing_page_url":"http://hdl.handle.net/10251/182721","pdf_url":null,"source":{"id":"https://openalex.org/S4306400639","display_name":"RiuNet (Universitat Polit\u00e8cnica de Val\u00e8ncia)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I60053951","host_organization_name":"Universitat Polit\u00e8cnica de Val\u00e8ncia","host_organization_lineage":["https://openalex.org/I60053951"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"doi:10.3390/app11115129","doi":"https://doi.org/10.3390/app11115129","is_oa":true,"landing_page_url":"https://doi.org/10.3390/app11115129","pdf_url":"https://www.mdpi.com/2076-3417/11/11/5129/pdf?version=1623232696","source":{"id":"https://openalex.org/S4210205812","display_name":"Applied Sciences","issn_l":"2076-3417","issn":["2076-3417"],"is_oa":true,"is_in_doaj":true,"is_core":true,"listed_in":["anvur-class-a","anvur-scientific","cwts-core","doaj","norway-1","oarl","poland-100","russia-white-list-2","vabb-shw"],"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":"Applied Sciences","raw_type":"journal-article"},"sustainable_development_goals":[],"sustainable_development_goals_aurora":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3167795652.pdf","grobid_xml":"https://content.openalex.org/works/W3167795652.grobid-xml"},"referenced_works_count":18,"referenced_works":["https://openalex.org/W189113474","https://openalex.org/W1631447473","https://openalex.org/W1987514088","https://openalex.org/W1995930895","https://openalex.org/W2112176043","https://openalex.org/W2118067965","https://openalex.org/W2147132450","https://openalex.org/W2169004268","https://openalex.org/W2492450223","https://openalex.org/W2604936657","https://openalex.org/W2605014934","https://openalex.org/W2769999519","https://openalex.org/W3105934536","https://openalex.org/W3167795652","https://openalex.org/W4206789627","https://openalex.org/W4235140465","https://openalex.org/W4239705526","https://openalex.org/W6686749315"],"related_works":["https://openalex.org/W2769999519","https://openalex.org/W2969328805","https://openalex.org/W2054510684","https://openalex.org/W1495384655","https://openalex.org/W2118067965","https://openalex.org/W1977596913","https://openalex.org/W4394924420","https://openalex.org/W3014900595","https://openalex.org/W3012140466","https://openalex.org/W7097584016"],"abstract_inverted_index":{"Some":[0],"of":[1,43,51,54,73,94,112,115,133,145,153,187],"the":[2,24,31,48,74,95,109,113,125,131,151,174,185,191],"most":[3,93],"powerful":[4],"spatial":[5,96,183],"analysis":[6,97],"software":[7,98],"solutions":[8],"(Oracle,":[9],"Google":[10],"Earth":[11],"Engine,":[12],"PostgreSQL":[13],"+":[14],"PostGIS,":[15],"etc.)":[16],"are":[17,67,177],"currently":[18],"performing":[19],"geometric":[20,171],"calculations":[21,104,135,172],"directly":[22],"on":[23,124,173],"ellipsoid":[25,134,175],"(a":[26],"quadratic":[27],"surface":[28],"that":[29,64,92,156,176],"models":[30],"earth":[32],"shape),":[33],"with":[34,158],"a":[35,40,88,142,195,198],"double":[36],"purpose:":[37],"to":[38,46,69,106,130,179,197],"attain":[39],"high":[41,159],"degree":[42],"accuracy":[44,160],"and":[45,81,165,190],"allow":[47],"full":[49],"management":[50],"large":[52],"areas":[53],"territory":[55],"(countries":[56],"or":[57],"even":[58],"continents).":[59],"It":[60],"is":[61,128],"well":[62],"known":[63],"both":[65],"objectives":[66],"impossible":[68],"achieve":[70],"by":[71],"means":[72],"traditional":[75],"approach":[76],"using":[77,141],"local":[78],"mathematical":[79],"projections":[80],"Cartesian":[82],"coordinates.":[83],"This":[84,127,148],"paper":[85,149],"demonstrates":[86],"in":[87,103,136],"quantitative":[89],"methodological":[90],"way":[91,139],"products":[99],"make":[100],"important":[101],"deviations":[102],"regarding":[105],"geodesics,":[107],"being":[108],"users":[110],"unaware":[111],"magnitude":[114],"these":[116],"inaccuracies,":[117],"which":[118],"can":[119],"easily":[120],"reach":[121],"meters":[122],"depending":[123],"distance.":[126],"due":[129],"use":[132],"an":[137,146],"approximate":[138],"(e.g.,":[140],"sphere":[143],"instead":[144],"ellipsoid).":[147],"presents":[150],"implementation":[152],"two":[154,169,188],"algorithms":[155],"solve":[157],"(less":[161],"than":[162],"100":[163],"nm)":[164],"efficiently":[166],"(few":[167],"iterations)":[168],"basic":[170],"essential":[178],"build":[180],"more":[181],"complex":[182],"operators:":[184],"intersection":[186],"geodesics":[189],"minimum":[192],"distance":[193],"from":[194],"point":[196],"geodesic.":[199]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":2}],"updated_date":"2026-10-16T09:59:22.235173","created_date":"2021-06-22T00:00:00"}