{"id":34030,"name":"occurrence-cube","description":"User defined functions (UDF) to aggregate species occurrence data with SQL","url":"https://github.com/gbif/occurrence-cube","last_synced_at":"2025-09-05T06:03:57.617Z","repository":{"id":149782411,"uuid":"613830889","full_name":"gbif/occurrence-cube","owner":"gbif","description":"User defined functions (UDF) to aggregate species occurrence data with SQL","archived":false,"fork":false,"pushed_at":"2025-03-20T19:36:15.000Z","size":418,"stargazers_count":6,"open_issues_count":26,"forks_count":2,"subscribers_count":12,"default_branch":"master","last_synced_at":"2025-04-13T01:49:35.597Z","etag":null,"topics":[],"latest_commit_sha":null,"homepage":"https://techdocs.gbif.org/en/data-use/api-sql-download-functions","language":"Java","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"apache-2.0","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/gbif.png","metadata":{"files":{"readme":"README.md","changelog":null,"contributing":null,"funding":null,"license":"LICENSE-APACHE","code_of_conduct":null,"threat_model":null,"audit":null,"citation":"CITATION.cff","codeowners":null,"security":null,"support":null,"governance":null,"roadmap":null,"authors":null,"dei":null,"publiccode":null,"codemeta":null,"zenodo":null}},"created_at":"2023-03-14T11:04:57.000Z","updated_at":"2025-03-20T19:36:19.000Z","dependencies_parsed_at":"2025-02-28T11:37:49.519Z","dependency_job_id":"35d620f6-b92a-441a-8e61-8f99f61381c3","html_url":"https://github.com/gbif/occurrence-cube","commit_stats":null,"previous_names":[],"tags_count":7,"template":false,"template_full_name":null,"purl":"pkg:github/gbif/occurrence-cube","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/gbif%2Foccurrence-cube","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/gbif%2Foccurrence-cube/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/gbif%2Foccurrence-cube/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/gbif%2Foccurrence-cube/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/gbif","download_url":"https://codeload.github.com/gbif/occurrence-cube/tar.gz/refs/heads/master","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/gbif%2Foccurrence-cube/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":273718350,"owners_count":25155495,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2022-07-04T15:15:14.044Z","status":"online","status_checked_at":"2025-09-05T02:00:09.113Z","response_time":402,"last_error":null,"robots_txt_status":"success","robots_txt_updated_at":"2025-07-24T06:49:26.215Z","robots_txt_url":"https://github.com/robots.txt","online":true,"can_crawl_api":true,"host_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories","repository_names_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repository_names","owners_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners"}},"owner":{"login":"gbif","name":"Global Biodiversity Information Facility","uuid":"1963797","kind":"organization","description":"","email":null,"website":"https://www.gbif.org","location":"Copenhagen, Denmark","twitter":null,"company":null,"icon_url":"https://avatars.githubusercontent.com/u/1963797?v=4","repositories_count":288,"last_synced_at":"2024-04-14T06:45:04.085Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/gbif","funding_links":[],"total_stars":760,"followers":101,"following":0,"created_at":"2022-11-05T14:41:11.499Z","updated_at":"2024-04-14T06:46:12.959Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/gbif","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/gbif/repositories"},"packages":[],"commits":{"message":"Repository syncing started."},"issues_stats":{"full_name":"gbif/occurrence-cube","html_url":"https://github.com/gbif/occurrence-cube","last_synced_at":"2025-08-31T16:26:55.986Z","status":null,"issues_count":25,"pull_requests_count":2,"avg_time_to_close_issue":15893774.4375,"avg_time_to_close_pull_request":38592.5,"issues_closed_count":16,"pull_requests_closed_count":2,"pull_request_authors_count":2,"issue_authors_count":12,"avg_comments_per_issue":2.08,"avg_comments_per_pull_request":0.5,"merged_pull_requests_count":2,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":18,"past_year_pull_requests_count":2,"past_year_avg_time_to_close_issue":1260323.5555555555,"past_year_avg_time_to_close_pull_request":38592.5,"past_year_issues_closed_count":9,"past_year_pull_requests_closed_count":2,"past_year_pull_request_authors_count":2,"past_year_issue_authors_count":11,"past_year_avg_comments_per_issue":1.722222222222222,"past_year_avg_comments_per_pull_request":0.5,"past_year_bot_issues_count":0,"past_year_bot_pull_requests_count":0,"past_year_merged_pull_requests_count":2,"created_at":"2025-08-30T15:33:40.679Z","updated_at":"2025-09-02T01:57:39.527Z","repository_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/gbif%2Foccurrence-cube","issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/gbif%2Foccurrence-cube/issues","issue_labels_count":{"enhancement":5,"SHOULD":5,"MUST":4,"bug":1,"MAY":1},"pull_request_labels_count":{},"issue_author_associations_count":{"MEMBER":31,"NONE":10,"COLLABORATOR":1},"pull_request_author_associations_count":{"MEMBER":2,"NONE":1},"issue_authors":{"MattBlissett":17,"peterdesmet":7,"MortenHofft":3,"jhnwllr":2,"timrobertson100":2,"andrewrodrigues":2,"shawndove":2,"qgroom":1,"wlangera":1,"EmmaCartuyvels1":1,"mdoering":1,"dnoesgaard":1,"linamaes":1,"damianooldoni":1},"pull_request_authors":{"peterdesmet":2,"frafra":1},"host":{"name":"GitHub","url":"https://github.com","kind":"github","last_synced_at":"2025-09-05T00:00:10.444Z","repositories_count":10087320,"issues_count":31306968,"pull_requests_count":96469683,"authors_count":10696025,"icon_url":"https://github.com/github.png","host_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories","owners_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/owners","authors_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors"},"past_year_issue_labels_count":{"enhancement":5,"bug":1},"past_year_pull_request_labels_count":{},"past_year_issue_author_associations_count":{"MEMBER":12,"NONE":5,"COLLABORATOR":1},"past_year_pull_request_author_associations_count":{"MEMBER":1,"NONE":1},"past_year_issue_authors":{"peterdesmet":4,"MortenHofft":3,"andrewrodrigues":2,"MattBlissett":2,"damianooldoni":1,"dnoesgaard":1,"EmmaCartuyvels1":1,"jhnwllr":1,"mdoering":1,"timrobertson100":1,"wlangera":1},"past_year_pull_request_authors":{"frafra":1,"peterdesmet":1},"maintainers":[{"login":"MattBlissett","count":17,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/MattBlissett"},{"login":"peterdesmet","count":9,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/peterdesmet"},{"login":"MortenHofft","count":3,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/MortenHofft"},{"login":"timrobertson100","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/timrobertson100"},{"login":"dnoesgaard","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/dnoesgaard"},{"login":"damianooldoni","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/damianooldoni"},{"login":"mdoering","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/mdoering"}],"active_maintainers":[{"login":"peterdesmet","count":5,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/peterdesmet"},{"login":"MortenHofft","count":3,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/MortenHofft"},{"login":"MattBlissett","count":2,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/MattBlissett"},{"login":"mdoering","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/mdoering"},{"login":"dnoesgaard","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/dnoesgaard"},{"login":"timrobertson100","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/timrobertson100"},{"login":"damianooldoni","count":1,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/damianooldoni"}]},"events":{"total":{"CreateEvent":2,"ReleaseEvent":1,"IssuesEvent":38,"WatchEvent":2,"DeleteEvent":1,"IssueCommentEvent":55,"PushEvent":9,"PullRequestEvent":3,"ForkEvent":2},"last_year":{"CreateEvent":2,"ReleaseEvent":1,"IssuesEvent":38,"WatchEvent":2,"DeleteEvent":1,"IssueCommentEvent":55,"PushEvent":9,"PullRequestEvent":3,"ForkEvent":2}},"keywords":[],"dependencies":[{"ecosystem":"maven","filepath":"pom.xml","sha":null,"kind":"manifest","created_at":"2024-01-22T16:56:36.720Z","updated_at":"2024-01-22T16:56:36.720Z","repository_link":"https://github.com/gbif/occurrence-cube/blob/master/pom.xml","dependencies":[{"id":15761302056,"package_name":"org.geotools:gt-referencing","ecosystem":"maven","requirements":"20.5","direct":true,"kind":"runtime","optional":false},{"id":15761302062,"package_name":"org.geotools:gt-epsg-hsql","ecosystem":"maven","requirements":"20.5","direct":true,"kind":"runtime","optional":false},{"id":15761302064,"package_name":"org.apache.spark:spark-core_2.11","ecosystem":"maven","requirements":"2.3.0","direct":true,"kind":"provided","optional":false},{"id":15761302065,"package_name":"org.apache.spark:spark-sql_2.11","ecosystem":"maven","requirements":"2.3.0","direct":true,"kind":"provided","optional":false},{"id":15761302066,"package_name":"org.apache.spark:spark-hive_2.11","ecosystem":"maven","requirements":"2.3.0","direct":true,"kind":"provided","optional":false},{"id":15761302067,"package_name":"junit:junit","ecosystem":"maven","requirements":"4.13.2","direct":true,"kind":"test","optional":false}]},{"ecosystem":"maven","filepath":"cube-functions/pom.xml","sha":null,"kind":"manifest","created_at":"2024-01-29T16:17:34.579Z","updated_at":"2024-01-29T16:17:34.579Z","repository_link":"https://github.com/gbif/occurrence-cube/blob/master/cube-functions/pom.xml","dependencies":[{"id":15901905213,"package_name":"org.geotools:gt-referencing","ecosystem":"maven","requirements":null,"direct":true,"kind":"runtime","optional":false},{"id":15901906884,"package_name":"org.geotools:gt-epsg-hsql","ecosystem":"maven","requirements":null,"direct":true,"kind":"runtime","optional":false},{"id":15901907698,"package_name":"mil.nga:mgrs","ecosystem":"maven","requirements":null,"direct":true,"kind":"runtime","optional":false},{"id":15901907699,"package_name":"junit:junit","ecosystem":"maven","requirements":null,"direct":true,"kind":"test","optional":false}]},{"ecosystem":"maven","filepath":"cube-hive/pom.xml","sha":null,"kind":"manifest","created_at":"2024-01-29T16:17:39.563Z","updated_at":"2024-01-29T16:17:39.563Z","repository_link":"https://github.com/gbif/occurrence-cube/blob/master/cube-hive/pom.xml","dependencies":[{"id":15901907700,"package_name":"org.gbif.occurrence:cube-functions","ecosystem":"maven","requirements":null,"direct":true,"kind":"runtime","optional":false},{"id":15901907701,"package_name":"org.geotools:gt-referencing","ecosystem":"maven","requirements":null,"direct":true,"kind":"runtime","optional":false},{"id":15901907702,"package_name":"org.geotools:gt-epsg-hsql","ecosystem":"maven","requirements":null,"direct":true,"kind":"runtime","optional":false},{"id":15901907703,"package_name":"org.apache.hadoop:hadoop-common","ecosystem":"maven","requirements":"2.6.0-cdh5.16.2","direct":true,"kind":"runtime","optional":false},{"id":15901907704,"package_name":"org.apache.hive:hive-exec","ecosystem":"maven","requirements":"1.1.0-cdh5.16.2","direct":true,"kind":"provided","optional":false},{"id":15901907705,"package_name":"junit:junit","ecosystem":"maven","requirements":null,"direct":true,"kind":"test","optional":false}]},{"ecosystem":"maven","filepath":"cube-spark/pom.xml","sha":null,"kind":"manifest","created_at":"2024-01-29T16:17:40.108Z","updated_at":"2024-01-29T16:17:40.108Z","repository_link":"https://github.com/gbif/occurrence-cube/blob/master/cube-spark/pom.xml","dependencies":[{"id":15901907706,"package_name":"org.gbif.occurrence:cube-functions","ecosystem":"maven","requirements":null,"direct":true,"kind":"runtime","optional":false},{"id":15901907707,"package_name":"org.geotools:gt-referencing","ecosystem":"maven","requirements":null,"direct":true,"kind":"runtime","optional":false},{"id":15901907708,"package_name":"org.geotools:gt-epsg-hsql","ecosystem":"maven","requirements":null,"direct":true,"kind":"runtime","optional":false},{"id":15901907709,"package_name":"org.apache.spark:spark-core_${scala.tools.version}","ecosystem":"maven","requirements":null,"direct":true,"kind":"provided","optional":false},{"id":15901907710,"package_name":"org.apache.spark:spark-sql_${scala.tools.version}","ecosystem":"maven","requirements":null,"direct":true,"kind":"provided","optional":false},{"id":15901907711,"package_name":"org.apache.spark:spark-hive_${scala.tools.version}","ecosystem":"maven","requirements":null,"direct":true,"kind":"provided","optional":false},{"id":15901907712,"package_name":"junit:junit","ecosystem":"maven","requirements":null,"direct":true,"kind":"test","optional":false}]},{"ecosystem":"maven","filepath":"grid-generator/pom.xml","sha":null,"kind":"manifest","created_at":"2025-02-28T11:37:44.367Z","updated_at":"2025-02-28T11:37:44.367Z","repository_link":"https://github.com/gbif/occurrence-cube/blob/master/grid-generator/pom.xml","dependencies":[{"id":22063294214,"package_name":"org.gbif.occurrence:cube-functions","ecosystem":"maven","requirements":null,"direct":true,"kind":"runtime","optional":false},{"id":22063294357,"package_name":"org.geotools:gt-geopkg","ecosystem":"maven","requirements":"31.2","direct":true,"kind":"runtime","optional":false},{"id":22063294549,"package_name":"org.geotools:gt-epsg-hsql","ecosystem":"maven","requirements":"31.2","direct":true,"kind":"runtime","optional":false},{"id":22063294578,"package_name":"org.geotools:gt-referencing","ecosystem":"maven","requirements":"31.2","direct":true,"kind":"runtime","optional":false}]}],"score":null,"created_at":"2025-09-04T15:51:07.379Z","updated_at":"2025-10-07T08:14:16.948Z","avatar_url":"https://github.com/gbif.png","language":"Java","category":null,"sub_category":null,"monthly_downloads":0,"funding_links":[],"readme_doi_urls":["https://doi.org/10.5281/zenodo.10607133","https://doi.org/10.3030/101059592"],"works":{},"citation_counts":{},"total_citations":0,"keywords_from_contributors":[],"project_url":"https://science.ecosyste.ms/api/v1/projects/34030","html_url":"https://science.ecosyste.ms/projects/34030","bibtex_url":"https://science.ecosyste.ms/projects/34030/export.bibtex","apalike_url":"https://science.ecosyste.ms/projects/34030/export.apalike"}