{"id":"https://openalex.org/W4399910978","doi":"https://doi.org/10.1145/3653946.3653959","title":"A Unified Database Schema for Geometric and Semantic Data: Continuous Volumetric Stocktaking in Gravel Quarries","display_name":"A Unified Database Schema for Geometric and Semantic Data: Continuous Volumetric Stocktaking in Gravel Quarries","publication_year":2024,"publication_date":"2024-03-12","ids":{"openalex":"https://openalex.org/W4399910978","doi":"https://doi.org/10.1145/3653946.3653959"},"language":"en","primary_location":{"id":"doi:10.1145/3653946.3653959","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3653946.3653959","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3653946.3653959","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2024 7th International Conference on Machine Vision and Applications","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3653946.3653959","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5026006856","display_name":"Marco Wallner","orcid":"https://orcid.org/0000-0002-3757-090X"},"institutions":[{"id":"https://openalex.org/I132118926","display_name":"Austrian Institute of Technology","ror":"https://ror.org/04knbh022","country_code":"AT","type":"facility","lineage":["https://openalex.org/I132118926"]}],"countries":["AT"],"is_corresponding":true,"raw_author_name":"Marco Wallner","raw_affiliation_strings":["Center for Vision, Automation &amp; Control, AIT Austrian Institute of Technology, Austria"],"raw_orcid":"https://orcid.org/0000-0002-3757-090X","affiliations":[{"raw_affiliation_string":"Center for Vision, Automation &amp; Control, AIT Austrian Institute of Technology, Austria","institution_ids":["https://openalex.org/I132118926"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018565644","display_name":"Matthias Sch\u00f6rghuber","orcid":"https://orcid.org/0000-0001-7629-0348"},"institutions":[{"id":"https://openalex.org/I132118926","display_name":"Austrian Institute of Technology","ror":"https://ror.org/04knbh022","country_code":"AT","type":"facility","lineage":["https://openalex.org/I132118926"]}],"countries":["AT"],"is_corresponding":false,"raw_author_name":"Matthias Sch\u00f6rghuber","raw_affiliation_strings":["Center for Vision, Automation &amp; Control, AIT Austrian Institute of Technology, Austria"],"raw_orcid":"https://orcid.org/0000-0001-7629-0348","affiliations":[{"raw_affiliation_string":"Center for Vision, Automation &amp; Control, AIT Austrian Institute of Technology, Austria","institution_ids":["https://openalex.org/I132118926"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5082220436","display_name":"Markus Hofst\u00e4tter","orcid":"https://orcid.org/0000-0003-3479-7567"},"institutions":[{"id":"https://openalex.org/I132118926","display_name":"Austrian Institute of Technology","ror":"https://ror.org/04knbh022","country_code":"AT","type":"facility","lineage":["https://openalex.org/I132118926"]}],"countries":["AT"],"is_corresponding":false,"raw_author_name":"Markus Hofst\u00e4tter","raw_affiliation_strings":["Center for Vision, Automation &amp; Control, AIT Austrian Institute of Technology, Austria"],"raw_orcid":"https://orcid.org/0000-0003-3479-7567","affiliations":[{"raw_affiliation_string":"Center for Vision, Automation &amp; Control, AIT Austrian Institute of Technology, Austria","institution_ids":["https://openalex.org/I132118926"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5026006856"],"corresponding_institution_ids":["https://openalex.org/I132118926"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.11792355,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"84","last_page":"91"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10191","display_name":"Robotics and Sensor-Based Localization","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/2202","display_name":"Aerospace Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10191","display_name":"Robotics and Sensor-Based Localization","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/2202","display_name":"Aerospace Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11211","display_name":"3D Surveying and Cultural Heritage","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1907","display_name":"Geology"},"field":{"id":"https://openalex.org/fields/19","display_name":"Earth and Planetary Sciences"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11164","display_name":"Remote Sensing and LiDAR Applications","score":0.9990000128746033,"subfield":{"id":"https://openalex.org/subfields/2305","display_name":"Environmental Engineering"},"field":{"id":"https://openalex.org/fields/23","display_name":"Environmental Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/point-cloud","display_name":"Point cloud","score":0.7903326749801636},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7884194850921631},{"id":"https://openalex.org/keywords/lidar","display_name":"Lidar","score":0.5516602993011475},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5335970520973206},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5326874852180481},{"id":"https://openalex.org/keywords/thematic-map","display_name":"Thematic map","score":0.46820738911628723},{"id":"https://openalex.org/keywords/pipeline","display_name":"Pipeline (software)","score":0.4637022614479065},{"id":"https://openalex.org/keywords/geospatial-analysis","display_name":"Geospatial analysis","score":0.46032989025115967},{"id":"https://openalex.org/keywords/volume","display_name":"Volume (thermodynamics)","score":0.4495960474014282},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.4454897344112396},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.4157068133354187},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.24950620532035828},{"id":"https://openalex.org/keywords/remote-sensing","display_name":"Remote sensing","score":0.22763246297836304},{"id":"https://openalex.org/keywords/geology","display_name":"Geology","score":0.16246604919433594},{"id":"https://openalex.org/keywords/computer-vision","display_name":"Computer vision","score":0.14632472395896912},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.10224109888076782}],"concepts":[{"id":"https://openalex.org/C131979681","wikidata":"https://www.wikidata.org/wiki/Q1899648","display_name":"Point cloud","level":2,"score":0.7903326749801636},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7884194850921631},{"id":"https://openalex.org/C51399673","wikidata":"https://www.wikidata.org/wiki/Q504027","display_name":"Lidar","level":2,"score":0.5516602993011475},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5335970520973206},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5326874852180481},{"id":"https://openalex.org/C93692415","wikidata":"https://www.wikidata.org/wiki/Q1502030","display_name":"Thematic map","level":2,"score":0.46820738911628723},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.4637022614479065},{"id":"https://openalex.org/C9770341","wikidata":"https://www.wikidata.org/wiki/Q1938983","display_name":"Geospatial analysis","level":2,"score":0.46032989025115967},{"id":"https://openalex.org/C20556612","wikidata":"https://www.wikidata.org/wiki/Q4469374","display_name":"Volume (thermodynamics)","level":2,"score":0.4495960474014282},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.4454897344112396},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.4157068133354187},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.24950620532035828},{"id":"https://openalex.org/C62649853","wikidata":"https://www.wikidata.org/wiki/Q199687","display_name":"Remote sensing","level":1,"score":0.22763246297836304},{"id":"https://openalex.org/C127313418","wikidata":"https://www.wikidata.org/wiki/Q1069","display_name":"Geology","level":0,"score":0.16246604919433594},{"id":"https://openalex.org/C31972630","wikidata":"https://www.wikidata.org/wiki/Q844240","display_name":"Computer vision","level":1,"score":0.14632472395896912},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.10224109888076782},{"id":"https://openalex.org/C58640448","wikidata":"https://www.wikidata.org/wiki/Q42515","display_name":"Cartography","level":1,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","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},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3653946.3653959","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3653946.3653959","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3653946.3653959","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2024 7th International Conference on Machine Vision and Applications","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3653946.3653959","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3653946.3653959","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3653946.3653959","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2024 7th International Conference on Machine Vision and Applications","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":false},"content_urls":{"pdf":"https://content.openalex.org/works/W4399910978.pdf"},"referenced_works_count":15,"referenced_works":["https://openalex.org/W1514151998","https://openalex.org/W1989750313","https://openalex.org/W2100522523","https://openalex.org/W2746349752","https://openalex.org/W2770176163","https://openalex.org/W2783685009","https://openalex.org/W2905509562","https://openalex.org/W2977977449","https://openalex.org/W3019288965","https://openalex.org/W3103957575","https://openalex.org/W3105489439","https://openalex.org/W3163573497","https://openalex.org/W4312629830","https://openalex.org/W4312802722","https://openalex.org/W6968783156"],"related_works":["https://openalex.org/W4319317934","https://openalex.org/W2901265155","https://openalex.org/W2956374172","https://openalex.org/W4319837668","https://openalex.org/W4308071650","https://openalex.org/W3188333020","https://openalex.org/W4281783339","https://openalex.org/W1964041166","https://openalex.org/W4293094720","https://openalex.org/W2739701376"],"abstract_inverted_index":{"In":[0],"mining":[1,232],"and":[2,6,17,32,36,51,57,79,102,107,160,186,219,228,233],"quarry":[3,159,234],"operations,":[4],"continuous":[5,137],"accurate":[7],"monitoring":[8,56,227],"of":[9,60,70,81,133,139,154,221],"material":[10,61],"volumes":[11],"is":[12,142],"imperative":[13],"for":[14,75,97,111,136,224],"operational":[15],"efficiency":[16],"inventory":[18],"management.":[19],"Current":[20],"methods":[21],"often":[22],"rely":[23],"on":[24],"standalone,":[25],"offline":[26,213],"tools,":[27],"necessitating":[28],"intermittent":[29],"data":[30,83,116,164],"collection":[31],"processing,":[33],"introducing":[34],"delays":[35],"potential":[37],"inaccuracies.":[38],"This":[39,173],"paper":[40],"presents":[41],"a":[42,119,147,210],"novel":[43],"unified":[44],"database":[45,196],"schema":[46,73,135],"that":[47],"seamlessly":[48],"integrates":[49],"geometric":[50],"semantic":[52,109],"data,":[53],"facilitating":[54],"real-time":[55,226],"volume":[58,148,187,206,229],"estimation":[59,149,230],"heaps":[62,141],"in":[63,118,231],"gravel":[64,140],"quarries.":[65],"Utilizing":[66],"the":[67,76,158,190,195,205,217],"PostGIS":[68],"extension":[69],"PostgreSQL,":[71],"our":[72,201,222],"allows":[74],"robust":[77],"storage":[78],"management":[80],"spatial":[82],"alongside":[84],"easy":[85],"integration":[86],"with":[87,124,189,209],"open-source":[88],"geospatial":[89],"tools":[90],"like":[91],"QGIS.":[92],"We":[93,199],"have":[94],"developed":[95],"interfaces":[96],"visual":[98],"SLAM":[99],"algorithms":[100],"(openVSLAM":[101],"maplab),":[103],"2D":[104],"LiDAR":[105],"maps,":[106],"proprietary":[108],"maps":[110],"intralogistics":[112],"use":[113],"cases,":[114],"enabling":[115],"aggregation":[117],"common":[120],"reference":[121,129],"frame":[122],"or":[123,171],"stored":[125],"transformation":[126],"between":[127],"different":[128],"frames.":[130],"An":[131],"application":[132],"this":[134],"stocktaking":[138],"demonstrated.":[143],"Our":[144],"system":[145,223],"executes":[146],"pipeline":[150,174],"by":[151,203],"defining":[152],"Regions":[153],"Interest":[155],"(ROIs)":[156],"within":[157],"employing":[161],"point":[162,179],"cloud":[163],"generated":[165],"via":[166],"Structure":[167],"from":[168,178],"Motion":[169],"(SfM)":[170],"LiDAR.":[172],"includes":[175],"ROI":[176],"extraction":[177],"clouds,":[180],"ground":[181],"plane":[182],"detection,":[183],"mesh":[184],"generation,":[185],"estimation,":[188],"results":[191],"written":[192],"back":[193],"to":[194],"as":[197],"meta-information.":[198],"validate":[200],"approach":[202],"comparing":[204],"estimates":[207],"obtained":[208],"commercially":[211],"available":[212],"tool,":[214],"Pix4D,":[215],"showcasing":[216],"efficacy":[218],"precision":[220],"continuous,":[225],"environments.":[235]},"counts_by_year":[],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}
