{"id":"https://openalex.org/W2023413066","doi":"https://doi.org/10.1145/1653771.1653815","title":"Efficiently managing large-scale raster species distribution data in PostgreSQL","display_name":"Efficiently managing large-scale raster species distribution data in PostgreSQL","publication_year":2009,"publication_date":"2009-11-04","ids":{"openalex":"https://openalex.org/W2023413066","doi":"https://doi.org/10.1145/1653771.1653815","mag":"2023413066"},"language":"en","primary_location":{"id":"doi:10.1145/1653771.1653815","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1653771.1653815","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 17th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems","raw_type":"proceedings-article"},"type":"conference-paper","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/A5101482691","display_name":"Jianting Zhang","orcid":"https://orcid.org/0000-0002-0161-9716"},"institutions":[{"id":"https://openalex.org/I125687163","display_name":"City College of New York","ror":"https://ror.org/00wmhkr98","country_code":"US","type":"education","lineage":["https://openalex.org/I125687163"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jianting Zhang","raw_affiliation_strings":["City College of New York, New York, NY"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"City College of New York, New York, NY","institution_ids":["https://openalex.org/I125687163"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061021795","display_name":"Michael Gertz","orcid":"https://orcid.org/0000-0003-4530-6110"},"institutions":[{"id":"https://openalex.org/I223822909","display_name":"Heidelberg University","ror":"https://ror.org/038t36y30","country_code":"DE","type":"education","lineage":["https://openalex.org/I223822909"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Michael Gertz","raw_affiliation_strings":["University of Heidelberg, Heidelberg, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Heidelberg, Heidelberg, Germany","institution_ids":["https://openalex.org/I223822909"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5071062190","display_name":"Le Gruenwald","orcid":"https://orcid.org/0000-0002-5245-4747"},"institutions":[{"id":"https://openalex.org/I8692664","display_name":"University of Oklahoma","ror":"https://ror.org/02aqsxs83","country_code":"US","type":"education","lineage":["https://openalex.org/I8692664"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Le Gruenwald","raw_affiliation_strings":["University of Oklahoma, Norman, OK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Oklahoma, Norman, OK","institution_ids":["https://openalex.org/I8692664"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.9679,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.70441989,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"316","last_page":"325"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998000264167786,"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.9998000264167786,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9782000184059143,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T10895","display_name":"Species Distribution and Climate Change","score":0.9648000001907349,"subfield":{"id":"https://openalex.org/subfields/2302","display_name":"Ecological Modeling"},"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/computer-science","display_name":"Computer science","score":0.7382559776306152},{"id":"https://openalex.org/keywords/quadtree","display_name":"Quadtree","score":0.6423724293708801},{"id":"https://openalex.org/keywords/raster-graphics","display_name":"Raster graphics","score":0.6171221733093262},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5758339762687683},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5436820387840271},{"id":"https://openalex.org/keywords/spatial-database","display_name":"Spatial database","score":0.5350663661956787},{"id":"https://openalex.org/keywords/identifier","display_name":"Identifier","score":0.5167838335037231},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.5099159479141235},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.46549758315086365},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.4469248950481415},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.4235551357269287},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.3246611952781677},{"id":"https://openalex.org/keywords/spatial-analysis","display_name":"Spatial analysis","score":0.3160436749458313},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.26770514249801636},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.25910019874572754},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.13660523295402527},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.13260263204574585},{"id":"https://openalex.org/keywords/remote-sensing","display_name":"Remote sensing","score":0.11456376314163208},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.11076340079307556},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.10096874833106995}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7382559776306152},{"id":"https://openalex.org/C151416825","wikidata":"https://www.wikidata.org/wiki/Q934791","display_name":"Quadtree","level":2,"score":0.6423724293708801},{"id":"https://openalex.org/C181844469","wikidata":"https://www.wikidata.org/wiki/Q182270","display_name":"Raster graphics","level":2,"score":0.6171221733093262},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5758339762687683},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5436820387840271},{"id":"https://openalex.org/C203689450","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial database","level":3,"score":0.5350663661956787},{"id":"https://openalex.org/C154504017","wikidata":"https://www.wikidata.org/wiki/Q853614","display_name":"Identifier","level":2,"score":0.5167838335037231},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.5099159479141235},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.46549758315086365},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.4469248950481415},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.4235551357269287},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.3246611952781677},{"id":"https://openalex.org/C159620131","wikidata":"https://www.wikidata.org/wiki/Q1938983","display_name":"Spatial analysis","level":2,"score":0.3160436749458313},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.26770514249801636},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.25910019874572754},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.13660523295402527},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.13260263204574585},{"id":"https://openalex.org/C62649853","wikidata":"https://www.wikidata.org/wiki/Q199687","display_name":"Remote sensing","level":1,"score":0.11456376314163208},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.11076340079307556},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.10096874833106995},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","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":1,"locations":[{"id":"doi:10.1145/1653771.1653815","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1653771.1653815","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 17th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Life in Land","score":0.7300000190734863,"id":"https://metadata.un.org/sdg/15"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W1497953515","https://openalex.org/W1597494089","https://openalex.org/W1633222579","https://openalex.org/W1980293260","https://openalex.org/W1994286274","https://openalex.org/W2029306088","https://openalex.org/W2041149648","https://openalex.org/W2050576295","https://openalex.org/W2051929917","https://openalex.org/W2068066282","https://openalex.org/W2072847879","https://openalex.org/W2076399175","https://openalex.org/W2094078373","https://openalex.org/W2097280721","https://openalex.org/W2106642566","https://openalex.org/W2116522112","https://openalex.org/W2125258187","https://openalex.org/W2126593637","https://openalex.org/W2128471644","https://openalex.org/W2128811516","https://openalex.org/W2157378728","https://openalex.org/W2169893912","https://openalex.org/W2296487541","https://openalex.org/W2340855105","https://openalex.org/W4206789627"],"related_works":["https://openalex.org/W2029306088","https://openalex.org/W2104906863","https://openalex.org/W2356940829","https://openalex.org/W2122098189","https://openalex.org/W4251016002","https://openalex.org/W2171008029","https://openalex.org/W2362227810","https://openalex.org/W98693435","https://openalex.org/W1003283331","https://openalex.org/W2003701127"],"abstract_inverted_index":{"Species":[0],"distribution":[1,35,152,159,272],"data":[2,36,56,136,160],"play":[3],"an":[4],"important":[5],"role":[6],"in":[7,12,96,109,171],"biodiversity":[8],"related":[9,161],"research,":[10],"especially":[11],"exploring":[13,270],"relationships":[14],"with":[15,113,175,195],"the":[16,19,23,30,142,163,168,179,189,222,235,260],"environment.":[17],"In":[18],"recent":[20],"years,":[21],"both":[22],"number":[24,180],"of":[25,33,86,181],"species":[26,34,111,151,158,173,271],"being":[27],"explored":[28],"and":[29,60,64,93,98,117,145,188,230,269],"spatial":[31,59,103],"resolution":[32],"are":[37,217],"increasing":[38],"fast.":[39],"It":[40],"is":[41,108,146],"thus":[42,258],"imperative":[43],"to":[44,51,73,132,141,162,192,200,206,212,251],"develop":[45],"database":[46,143,182],"systems":[47],"that":[48,167],"allow":[49],"users":[50],"efficiently":[52],"query":[53,94,118,126,213,227,240,245,255],"such":[54,75],"large-scale":[55,150],"based":[57],"on":[58],"non-spatial":[61],"(e.g.,":[62],"taxonomic":[63],"phylogenetics)":[65],"criteria.In":[66],"this":[67],"paper,":[68],"we":[69],"present":[70],"our":[71],"approach":[72,170],"building":[74],"a":[76,83,202],"system":[77,129,261],"by":[78,184],"integrating":[79],"several":[80],"components,":[81],"including":[82],"quadtree":[84,115,176],"representation":[85],"binary":[87,134],"raster":[88,135],"data,":[89],"tree":[90],"path":[91],"indexing":[92],"processing":[95],"PostgreSQL,":[97],"window":[99,125,246],"decomposition":[100],"techniques":[101,257],"for":[102,120,148,225,238,243,263,267],"queries.":[104],"Our":[105,128,254],"unique":[106],"contribution":[107],"associating":[110,172],"identifiers":[112,174,191],"intermediate":[114],"nodes":[116,177],"optimization":[119,256],"multiple":[121],"independent":[122],"queries":[123,216,224,237],"after":[124],"decomposition.":[127],"enables":[130],"PostgreSQL":[131],"support":[133],"without":[137],"requiring":[138],"any":[139],"changes":[140],"backend":[144],"suitable":[147,262],"managing":[149],"data.Our":[153],"experiments":[154],"using":[155],"4000+":[156],"bird":[157],"Western":[164],"hemisphere":[165],"show":[166],"proposed":[169],"reduces":[178],"tuples":[183],"more":[185],"than":[186,221,234],"1/3":[187],"average":[190,226],"be":[193],"associated":[194],"each":[196],"tuple":[197],"from":[198,249],"110.6":[199],"4.8,":[201],"significant":[203],"improvement":[204],"compared":[205],"classic":[207],"quadtree-based":[208],"approaches.":[209],"With":[210],"respect":[211],"optimization,":[214],"optimized":[215],"6--9.5":[218],"times":[219,229,232,242],"faster":[220,233],"baseline":[223,236],"response":[228,241],"5.5--8.3":[231],"maximum":[239],"four":[244],"sizes":[247],"ranging":[248],"0.1":[250],"5.0":[252],"degrees.":[253],"make":[259],"many":[264],"interactive":[265],"applications":[266],"querying":[268],"data.":[273]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}