{"id":"https://openalex.org/W2902782771","doi":"https://doi.org/10.7287/peerj.preprints.27247v1","title":"GeoSQL Journey - A gamified learning experience to introduce (or demystify) geospatial SQL queries","display_name":"GeoSQL Journey - A gamified learning experience to introduce (or demystify) geospatial SQL queries","publication_year":2018,"publication_date":"2018-10-02","ids":{"openalex":"https://openalex.org/W2902782771","doi":"https://doi.org/10.7287/peerj.preprints.27247v1","mag":"2902782771"},"language":"en","primary_location":{"id":"doi:10.7287/peerj.preprints.27247v1","is_oa":true,"landing_page_url":"https://doi.org/10.7287/peerj.preprints.27247v1","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":null,"raw_type":"posted-content"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.7287/peerj.preprints.27247v1","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5030187526","display_name":"Romain Sandoz","orcid":null},"institutions":[{"id":"https://openalex.org/I173439891","display_name":"HES-SO University of Applied Sciences and Arts Western Switzerland","ror":"https://ror.org/01xkakk17","country_code":"CH","type":"education","lineage":["https://openalex.org/I173439891"]}],"countries":["CH"],"is_corresponding":true,"raw_author_name":"Romain Sandoz","raw_affiliation_strings":["Media Engineering Institute, HES-SO // University of Applied Sciences Western Switzerland, St-Roch Campus, CH-1401 Yverdon-les-Bains, Switzerland"],"affiliations":[{"raw_affiliation_string":"Media Engineering Institute, HES-SO // University of Applied Sciences Western Switzerland, St-Roch Campus, CH-1401 Yverdon-les-Bains, Switzerland","institution_ids":["https://openalex.org/I173439891"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084229021","display_name":"Sarah Composto","orcid":null},"institutions":[{"id":"https://openalex.org/I173439891","display_name":"HES-SO University of Applied Sciences and Arts Western Switzerland","ror":"https://ror.org/01xkakk17","country_code":"CH","type":"education","lineage":["https://openalex.org/I173439891"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Sarah Composto","raw_affiliation_strings":["Territorial Engineering Institute, HES-SO // University of Applied Sciences Western Switzerland, Cheseaux Campus, CH-1401 Yverdon-les-Bains, Switzerland"],"affiliations":[{"raw_affiliation_string":"Territorial Engineering Institute, HES-SO // University of Applied Sciences Western Switzerland, Cheseaux Campus, CH-1401 Yverdon-les-Bains, Switzerland","institution_ids":["https://openalex.org/I173439891"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5044139352","display_name":"Sandrine Divorne","orcid":null},"institutions":[{"id":"https://openalex.org/I173439891","display_name":"HES-SO University of Applied Sciences and Arts Western Switzerland","ror":"https://ror.org/01xkakk17","country_code":"CH","type":"education","lineage":["https://openalex.org/I173439891"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Sandrine Divorne","raw_affiliation_strings":["Media Engineering Institute, HES-SO // University of Applied Sciences Western Switzerland, St-Roch Campus, CH-1401 Yverdon-les-Bains, Switzerland"],"affiliations":[{"raw_affiliation_string":"Media Engineering Institute, HES-SO // University of Applied Sciences Western Switzerland, St-Roch Campus, CH-1401 Yverdon-les-Bains, Switzerland","institution_ids":["https://openalex.org/I173439891"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055067476","display_name":"Olivier Ertz","orcid":"https://orcid.org/0000-0002-9062-8453"},"institutions":[{"id":"https://openalex.org/I173439891","display_name":"HES-SO University of Applied Sciences and Arts Western Switzerland","ror":"https://ror.org/01xkakk17","country_code":"CH","type":"education","lineage":["https://openalex.org/I173439891"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Olivier Ertz","raw_affiliation_strings":["Media Engineering Institute, HES-SO // University of Applied Sciences Western Switzerland, St-Roch Campus, CH-1401 Yverdon-les-Bains, Switzerland"],"affiliations":[{"raw_affiliation_string":"Media Engineering Institute, HES-SO // University of Applied Sciences Western Switzerland, St-Roch Campus, CH-1401 Yverdon-les-Bains, Switzerland","institution_ids":["https://openalex.org/I173439891"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5054128936","display_name":"Jens Ingensand","orcid":"https://orcid.org/0000-0003-3330-4986"},"institutions":[{"id":"https://openalex.org/I173439891","display_name":"HES-SO University of Applied Sciences and Arts Western Switzerland","ror":"https://ror.org/01xkakk17","country_code":"CH","type":"education","lineage":["https://openalex.org/I173439891"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Jens Ingensand","raw_affiliation_strings":["Territorial Engineering Institute, HES-SO // University of Applied Sciences Western Switzerland, Cheseaux Campus, CH-1401 Yverdon-les-Bains, Switzerland"],"affiliations":[{"raw_affiliation_string":"Territorial Engineering Institute, HES-SO // University of Applied Sciences Western Switzerland, Cheseaux Campus, CH-1401 Yverdon-les-Bains, Switzerland","institution_ids":["https://openalex.org/I173439891"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5030187526"],"corresponding_institution_ids":["https://openalex.org/I173439891"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.16783728,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10731","display_name":"Educational Games and Gamification","score":0.9908999800682068,"subfield":{"id":"https://openalex.org/subfields/3204","display_name":"Developmental and Educational Psychology"},"field":{"id":"https://openalex.org/fields/32","display_name":"Psychology"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T10731","display_name":"Educational Games and Gamification","score":0.9908999800682068,"subfield":{"id":"https://openalex.org/subfields/3204","display_name":"Developmental and Educational Psychology"},"field":{"id":"https://openalex.org/fields/32","display_name":"Psychology"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T12343","display_name":"Geography Education and Pedagogy","score":0.9207000136375427,"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/geospatial-analysis","display_name":"Geospatial analysis","score":0.7004481554031372},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6369176506996155},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5878541469573975},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5556322932243347},{"id":"https://openalex.org/keywords/usability","display_name":"Usability","score":0.46830618381500244},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3491889238357544},{"id":"https://openalex.org/keywords/multimedia","display_name":"Multimedia","score":0.324789822101593},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.3110615313053131},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.09848660230636597},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.0975848138332367}],"concepts":[{"id":"https://openalex.org/C9770341","wikidata":"https://www.wikidata.org/wiki/Q1938983","display_name":"Geospatial analysis","level":2,"score":0.7004481554031372},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6369176506996155},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5878541469573975},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5556322932243347},{"id":"https://openalex.org/C170130773","wikidata":"https://www.wikidata.org/wiki/Q216378","display_name":"Usability","level":2,"score":0.46830618381500244},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3491889238357544},{"id":"https://openalex.org/C49774154","wikidata":"https://www.wikidata.org/wiki/Q131765","display_name":"Multimedia","level":1,"score":0.324789822101593},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.3110615313053131},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.09848660230636597},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.0975848138332367},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0},{"id":"https://openalex.org/C58640448","wikidata":"https://www.wikidata.org/wiki/Q42515","display_name":"Cartography","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.7287/peerj.preprints.27247v1","is_oa":true,"landing_page_url":"https://doi.org/10.7287/peerj.preprints.27247v1","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":null,"raw_type":"posted-content"}],"best_oa_location":{"id":"doi:10.7287/peerj.preprints.27247v1","is_oa":true,"landing_page_url":"https://doi.org/10.7287/peerj.preprints.27247v1","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":null,"raw_type":"posted-content"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education","score":0.49000000953674316}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4367313141","https://openalex.org/W2187546663","https://openalex.org/W2429057255","https://openalex.org/W148745890","https://openalex.org/W2733999579","https://openalex.org/W2910751785","https://openalex.org/W2110217573","https://openalex.org/W2899790217","https://openalex.org/W4366547507","https://openalex.org/W1576092969"],"abstract_inverted_index":{"In":[0,122],"a":[1,165,176,180,189,203,214,236,249,352,365,372],"digital":[2,7,44,100,184],"world":[3,302],"in":[4,46,86,157,235,334],"the":[5,41,47,68,105,111,142,161,169,219,242,255,258,264,270,308,315,332,335,380,409,414],"making,":[6],"natives":[8],"develop":[9,359,408],"new":[10,173],"learning":[11,32,216,291],"profiles,":[12],"interests,":[13],"and":[14,27,89,131,146,167,197,288,294,299,303,321,327,337,384,402],"way":[15,238],"of":[16,25,43,60,71,92,208,218,245,260,269,311,314],"working.":[17],"Simultaneously":[18],"teachers":[19,81,385],"are":[20],"facing":[21],"students":[22,256,383],"with":[23,29,126,290,296,371,382],"lack":[24],"engagement":[26],"motivation":[28,283],"quite":[30],"traditional":[31],"process":[33],"that":[34],"has":[35,324],"probably":[36],"to":[37,57,66,104,117,140,150,159,163,171,233,240,253,257,279,331,350,358,378,386,394,407],"be":[38,118,405],"reframed":[39],"considering":[40],"effects":[42],"transformation":[45],"education":[48],"sector.":[49],"This":[50,305],"issue":[51],"is":[52,135,202,248,277,349,392],"acute":[53],"when":[54],"it":[55,276,391],"comes":[56],"complex":[58],"subject":[59],"study,":[61],"such":[62],"as":[63,188,273,377],"SQL":[64,200,220,231,261,374],"geospatial":[65,69,232,243,262],"manipulate":[67,241],"characteristic":[70,244],"data.":[72,246],"Indeed,":[73],"some":[74],"common":[75],"difficulties":[76],"have":[77,116],"been":[78,325],"identified":[79],"by":[80],"from":[82,205],"HEIG-VD":[83],"university":[84],"both":[85],"Media":[87],"Engineering":[88],"Geomatics":[90],"fields":[91],"study.":[93],"The":[94,224,343],"user-centered":[95],"approach":[96,138],"aims":[97,149],"at":[98],"creating":[99],"products":[101],"highly":[102],"responding":[103],"user\u2019s":[106],"needs":[107],"through":[108],"techniques":[109],"improving":[110],"user":[112,127],"experience.":[113,199],"Various":[114],"aspects":[115],"considered,":[119],"including":[120],"emotions.":[121],"education,":[123],"gamification,":[124],"along":[125],"experience,":[128],"interface":[129,323],"design":[130,313,381],"usability":[132],"best":[133,338],"practices":[134,339],"one":[136],"promising":[137],"able":[139],"increase":[141,168],"learner's":[143],"engagement,":[144],"interest":[145],"motivation.":[147],"It":[148,192,247],"implement":[151],"game":[152,301,322,369],"mechanics":[153,320],"within":[154,179],"non-game":[155],"context,":[156,182],"order":[158],"motivate":[160],"learner":[162],"accomplish":[164],"task":[166],"ability":[170],"learn":[172,234],"skills.":[174],"Using":[175],"gamification":[177,400],"layer":[178],"given":[181],"being":[183],"or":[185,267],"not,":[186],"act":[187],"motivational":[190],"trigger.":[191],"helps":[193],"giving":[194],"meaningful,":[195],"enjoyable":[196],"empowering":[198],"Island":[201],"project":[204,227,348],"Kaiserslautern":[206],"University":[207],"Technology":[209],"which":[210],"illustrates":[211],"very":[212],"well":[213],"gamified":[215,250],"experience":[217],"special-purpose":[221],"programming":[222],"language.":[223],"GeoSQL":[225,316],"Journey":[226,317],"goes":[228],"further,":[229],"tackling":[230],"fun":[237],"how":[239,396],"pedagogical":[251],"application":[252,361],"introduce":[254],"practice":[259],"during":[263],"first":[265,410],"hours":[266],"days":[268],"course.":[271],"Serving":[272],"an":[274,297,360],"initiation,":[275],"designed":[278],"focus":[280],"on":[281,340],"intrinsic":[282],"(personal":[284],"development,":[285],"quest,":[286],"challenge":[287,379],"fulfillment)":[289],"objectives":[292],"determined":[293],"integrated":[295],"engaging":[298],"coherent":[300],"narrative.":[304],"paper":[306],"describes":[307],"early":[309],"work":[310],"conceptual":[312],"project.":[318],"Game":[319],"conceived":[326],"brought":[328],"together":[329],"according":[330],"literature":[333],"domain":[336],"this":[341,347],"matter.":[342],"following":[344],"step":[345],"for":[346,413],"elaborate":[351],"testing":[353],"method":[354],"without":[355],"yet":[356],"having":[357],"prototype":[362,411],"(e.g.":[363],"organizing":[364],"fairly":[366],"raw":[367],"tabletop":[368],"associated":[370],"classic":[373],"console)":[375],"so":[376],"get":[387],"their":[388],"feedbacks.":[389],"Also,":[390],"envisioned":[393],"evaluate":[395],"existing":[397],"open":[398],"source":[399],"tools":[401],"frameworks":[403],"would":[404],"suitable":[406],"planned":[412],"2019-2020":[415],"academic":[416],"year.":[417]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}