{"id":"https://openalex.org/W2990280262","doi":"https://doi.org/10.1145/3356395.3365598","title":"In-Database Geospatial Analytics using Python","display_name":"In-Database Geospatial Analytics using Python","publication_year":2019,"publication_date":"2019-11-05","ids":{"openalex":"https://openalex.org/W2990280262","doi":"https://doi.org/10.1145/3356395.3365598","mag":"2990280262"},"language":"en","primary_location":{"id":"doi:10.1145/3356395.3365598","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3356395.3365598","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2nd ACM SIGSPATIAL International Workshop on Advances on Resilient and Intelligent Cities","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5001639803","display_name":"Avipsa Roy","orcid":"https://orcid.org/0000-0002-9110-4643"},"institutions":[{"id":"https://openalex.org/I55732556","display_name":"Arizona State University","ror":"https://ror.org/03efmqc40","country_code":"US","type":"education","lineage":["https://openalex.org/I55732556"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Avipsa Roy","raw_affiliation_strings":["Arizona State University, Tempe, AZ, USA"],"affiliations":[{"raw_affiliation_string":"Arizona State University, Tempe, AZ, USA","institution_ids":["https://openalex.org/I55732556"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034787716","display_name":"Edouard Fouch\u00e9","orcid":"https://orcid.org/0000-0003-0157-7648"},"institutions":[{"id":"https://openalex.org/I102335020","display_name":"Karlsruhe Institute of Technology","ror":"https://ror.org/04t3en479","country_code":"DE","type":"education","lineage":["https://openalex.org/I102335020","https://openalex.org/I1305996414"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Edouard Fouch\u00e9","raw_affiliation_strings":["Karlsruhe Institute of Technology, Karlsruhe, Germany"],"affiliations":[{"raw_affiliation_string":"Karlsruhe Institute of Technology, Karlsruhe, Germany","institution_ids":["https://openalex.org/I102335020"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5025523536","display_name":"Rafael Rodriguez Morales","orcid":null},"institutions":[{"id":"https://openalex.org/I78650965","display_name":"TU Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Rafael Rodriguez Morales","raw_affiliation_strings":["Technische Universit\u00e4t Dresden, Dresden, Germany"],"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t Dresden, Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5070367529","display_name":"Gregor M\u00f6hler","orcid":null},"institutions":[{"id":"https://openalex.org/I4210095996","display_name":"IBM (Germany)","ror":"https://ror.org/00pm7rm97","country_code":"DE","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210095996"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Gregor M\u00f6hler","raw_affiliation_strings":["IBM Deutschland Research and Development GmbH, B\u00f6blingen, Germany"],"affiliations":[{"raw_affiliation_string":"IBM Deutschland Research and Development GmbH, B\u00f6blingen, Germany","institution_ids":["https://openalex.org/I4210095996"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5001639803"],"corresponding_institution_ids":["https://openalex.org/I55732556"],"apc_list":null,"apc_paid":null,"fwci":0.3317,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.57548791,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"17","last_page":"24"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9979000091552734,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9979000091552734,"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/T10799","display_name":"Data Visualization and Analytics","score":0.9933000206947327,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T11344","display_name":"Traffic Prediction and Management Techniques","score":0.9926000237464905,"subfield":{"id":"https://openalex.org/subfields/2215","display_name":"Building and Construction"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8329161405563354},{"id":"https://openalex.org/keywords/geospatial-analysis","display_name":"Geospatial analysis","score":0.8302284479141235},{"id":"https://openalex.org/keywords/python","display_name":"Python (programming language)","score":0.7663115859031677},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.599909782409668},{"id":"https://openalex.org/keywords/spatial-database","display_name":"Spatial database","score":0.5757578611373901},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.547883152961731},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5373284816741943},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.5156892538070679},{"id":"https://openalex.org/keywords/spatial-analysis","display_name":"Spatial analysis","score":0.5015358924865723},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4376298487186432},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.4338659942150116},{"id":"https://openalex.org/keywords/data-visualization","display_name":"Data visualization","score":0.4103524088859558},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.35566192865371704}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8329161405563354},{"id":"https://openalex.org/C9770341","wikidata":"https://www.wikidata.org/wiki/Q1938983","display_name":"Geospatial analysis","level":2,"score":0.8302284479141235},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.7663115859031677},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.599909782409668},{"id":"https://openalex.org/C203689450","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial database","level":3,"score":0.5757578611373901},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.547883152961731},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5373284816741943},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.5156892538070679},{"id":"https://openalex.org/C159620131","wikidata":"https://www.wikidata.org/wiki/Q1938983","display_name":"Spatial analysis","level":2,"score":0.5015358924865723},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4376298487186432},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.4338659942150116},{"id":"https://openalex.org/C172367668","wikidata":"https://www.wikidata.org/wiki/Q6504956","display_name":"Data visualization","level":3,"score":0.4103524088859558},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.35566192865371704},{"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/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C58640448","wikidata":"https://www.wikidata.org/wiki/Q42515","display_name":"Cartography","level":1,"score":0.0},{"id":"https://openalex.org/C62649853","wikidata":"https://www.wikidata.org/wiki/Q199687","display_name":"Remote sensing","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/C127313418","wikidata":"https://www.wikidata.org/wiki/Q1069","display_name":"Geology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3356395.3365598","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3356395.3365598","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2nd ACM SIGSPATIAL International Workshop on Advances on Resilient and Intelligent Cities","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W1538244879","https://openalex.org/W1571188373","https://openalex.org/W1980365054","https://openalex.org/W2021204860","https://openalex.org/W2032327513","https://openalex.org/W2058719260","https://openalex.org/W2115583184","https://openalex.org/W2154733731","https://openalex.org/W2168702601","https://openalex.org/W2436533802","https://openalex.org/W2472803348","https://openalex.org/W2513948012","https://openalex.org/W2610815847","https://openalex.org/W2757470978","https://openalex.org/W2760935401","https://openalex.org/W2821473132","https://openalex.org/W2888965704"],"related_works":["https://openalex.org/W4281688633","https://openalex.org/W3027702097","https://openalex.org/W2573939812","https://openalex.org/W4301373648","https://openalex.org/W1985100943","https://openalex.org/W4388159383","https://openalex.org/W2120098008","https://openalex.org/W1639806124","https://openalex.org/W4366145086","https://openalex.org/W2898771714"],"abstract_inverted_index":{"The":[0,190],"amount":[1],"of":[2,25,43,60,91,122,208,231,250],"spatial":[3,27,61,92,123,162,184,195,232,271],"data":[4,28,62,93,114,169],"acquired":[5],"from":[6,63],"crowdsourced":[7],"platforms,":[8],"mobile":[9],"devices,":[10],"sensors":[11],"and":[12,33,49,56,89,134,160,213],"cartographic":[13],"agencies":[14],"has":[15],"grown":[16],"exponentially":[17],"over":[18],"the":[19,26,72,79,83,102,112,168,194,199,206,229,248,269],"past":[20],"few":[21],"years.":[22],"Nearly":[23],"half":[24],"available":[29],"currently":[30],"are":[31,126],"stored":[32,94],"processed":[34],"through":[35,152],"large":[36,58],"relational":[37,96],"databases.":[38,65,97],"Due":[39],"to":[40,68,77,110,143,157,166,227],"a":[41,120,149,173,183,254],"lack":[42],"generic":[44],"open":[45,154],"source":[46,155],"tools,":[47],"researchers":[48],"analysts":[50],"often":[51],"have":[52],"difficulty":[53],"in":[54,82,95,176,258,264],"extracting":[55],"analyzing":[57],"amounts":[59],"traditional":[64],"In":[66],"order":[67],"overcome":[69],"this":[70,145],"challenge,":[71],"most":[73],"effective":[74],"way":[75],"is":[76,142],"perform":[78,158],"analysis":[80,124,163],"directly":[81],"database,":[84],"which":[85,178,204,259],"enables":[86],"quick":[87],"retrieval":[88],"visualization":[90,235],"Also,":[98],"working":[99],"in-database":[100,270],"reduces":[101],"network":[103],"overhead,":[104],"as":[105,218,220,238],"users":[106],"do":[107,130],"not":[108,131],"need":[109],"replicate":[111],"complete":[113],"into":[115,182,201],"their":[116],"local":[117],"system.":[118],"While":[119],"number":[121],"libraries":[125],"readily":[127],"available,":[128],"they":[129],"work":[132],"in-database,":[133],"typically":[135],"require":[136],"additional":[137],"platform-specific":[138],"software.":[139],"Our":[140],"goal":[141],"bridge":[144],"gap":[146],"by":[147,198],"developing":[148],"new":[150],"method":[151],"an":[153],"software":[156],"fast":[159],"seamless":[161],"without":[164],"having":[165],"store":[167],"in-memory.":[170],"We":[171,223],"propose":[172],"framework":[174,191],"implemented":[175],"Python,":[177],"embeds":[179],"geospatial":[180],"analytics":[181],"database":[185],"(i.e.":[186],"IBM":[187],"DB2":[188],"\u00ae).":[189],"internally":[192],"translates":[193],"functions":[196],"written":[197],"user":[200],"SQL":[202],"queries,":[203],"follow":[205],"standards":[207],"Open":[209],"Geospatial":[210],"Consortium":[211],"(OGC)":[212],"can":[214],"operate":[215],"on":[216],"single":[217],"well":[219],"multiple":[221],"geometries.":[222],"then":[224],"demonstrate":[225],"how":[226],"combine":[228],"results":[230],"operations":[233],"with":[234],"methods":[236],"such":[237],"choropleth":[239],"maps":[240],"within":[241],"Jupyter":[242],"notebooks.":[243],"Finally,":[244],"we":[245,260],"elaborate":[246],"upon":[247],"benefits":[249],"our":[251],"approach":[252],"via":[253],"real-world":[255],"use":[256],"case,":[257],"analyze":[261],"crime":[262],"hotspots":[263],"New":[265],"York":[266],"City":[267],"using":[268],"functions.":[272]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}