apscale
Advanced tools
| Metadata-Version: 2.4 | ||
| Name: apscale | ||
| Version: 4.2.1 | ||
| Version: 4.2.2 | ||
| Summary: Advanced Pipeline for Simple yet Comprehensive AnaLysEs of DNA metabarcoding data | ||
@@ -5,0 +5,0 @@ Home-page: https://github.com/DominikBuchner/apscale |
@@ -573,3 +573,3 @@ import duckdb, pyproj, time, requests, random, zipfile, glob, shutil | ||
| CAST(taxonkey AS BIGINT) AS taxonkey, | ||
| ST_Collect(ARRAY_AGG(ST_Point(decimallongitude, decimallatitude))) AS multipoints | ||
| ST_ConvexHull(ST_Collect(ARRAY_AGG(ST_Point(decimallongitude, decimallatitude)))) AS convex_hull | ||
| FROM read_parquet('{temp_folder.joinpath("occurrence.parquet", ("*"))}') | ||
@@ -605,13 +605,25 @@ GROUP BY taxonkey | ||
| f""" | ||
| CREATE OR REPLACE TABLE main.validation_data AS | ||
| CREATE OR REPLACE TABLE main.seqs_to_validate AS | ||
| SELECT | ||
| DISTINCT(wd.sequence_idx), | ||
| dd.gbif_usage_key, | ||
| wd.wkt_string, | ||
| god.multipoints | ||
| wd.wkt_string | ||
| FROM wkt_data AS wd | ||
| LEFT JOIN distribution_data AS dd | ||
| ON wd.sequence_idx = dd.sequence_idx | ||
| """ | ||
| ) | ||
| # collect the polygon data | ||
| temp_db_con.execute( | ||
| f""" | ||
| CREATE OR REPLACE TABLE main.validation_data AS | ||
| SELECT | ||
| stv.sequence_idx, | ||
| stv.gbif_usage_key, | ||
| stv.wkt_string, | ||
| god.convex_hull | ||
| FROM main.seqs_to_validate AS stv | ||
| LEFT JOIN gbif_data.occ_data AS god | ||
| ON dd.gbif_usage_key = god.taxonkey | ||
| ON stv.gbif_usage_key = god.taxonkey | ||
| """ | ||
@@ -631,3 +643,3 @@ ) | ||
| WHEN ST_Intersects( | ||
| multipoints, | ||
| convex_hull, | ||
| ST_GeomFromText(wkt_string) | ||
@@ -634,0 +646,0 @@ ) THEN 'plausible' |
+1
-1
| Metadata-Version: 2.4 | ||
| Name: apscale | ||
| Version: 4.2.1 | ||
| Version: 4.2.2 | ||
| Summary: Advanced Pipeline for Simple yet Comprehensive AnaLysEs of DNA metabarcoding data | ||
@@ -5,0 +5,0 @@ Home-page: https://github.com/DominikBuchner/apscale |
+1
-1
@@ -8,3 +8,3 @@ import setuptools | ||
| name="apscale", | ||
| version="4.2.1", | ||
| version="4.2.2", | ||
| author="Dominik Buchner", | ||
@@ -11,0 +11,0 @@ author_email="dominik.buchner524@googlemail.com", |
Alert delta unavailable
Currently unable to show alert delta for PyPI packages.
267890
0.12%5808
0.19%