Spaces:
Sleeping
Sleeping
File size: 1,791 Bytes
c2fd183 c399c9b c2fd183 c399c9b c2fd183 c399c9b c2fd183 c399c9b c2fd183 c399c9b c2fd183 c399c9b c2fd183 c399c9b c2fd183 c399c9b |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 |
library(duckdb.agent)
library(duckdbfs)
library(dplyr)
library(ellmer)
duckdb_secrets(Sys.getenv("MINIO_KEY"),
Sys.getenv("MINIO_SECRET"),
"minio.carlboettiger.info")
gbif <- open_dataset("s3://public-gbif/2024-10-01", tblname = "gbif")
tracts_url <- "https://minio.carlboettiger.info/public-social-vulnerability/2022-tracts-h3-z8.parquet"
tracts_h3 <- open_dataset(tracts_url, tblname = "censustracts")
system_prompt = create_prompt(additional_instructions =
"Note that the column h8 contains a geohash representing a H3 hexagon index.
If asked for data that requires both tables, you should always seek to join on
the h8 column. Always aggregate results to count the number of rows matching
the query in each h8 hexagon")
agent <- ellmer::chat_vllm(
base_url = "https://llm.cirrus.carlboettiger.info/v1/",
model = "kosbu/Llama-3.3-70B-Instruct-AWQ",
api_key = Sys.getenv("CIRRUS_LLM_KEY"),
system_prompt = system_prompt,
api_args = list(temperature = 0)
)
resp <- agent$chat("Birds in Yolo County")
out <- agent_query(resp)
bench::bench_time({
out |> rename(h3id = h6) |> to_h3j("s3://public-data/test5.h3j")
})
library(mapgl)
url = "https://minio.carlboettiger.info/public-data/test5.h3j"
maplibre(center=c(-110, 38), zoom = 3, pitch = 30) |>
add_h3j_source("h3j_source",
url = url
) |>
add_fill_extrusion_layer(
id = "h3j_layer",
source = "h3j_source",
fill_extrusion_color = interpolate(
column = "count",
values = c(0, 1000),
stops = c("#430254", "#f83c70")
),
fill_extrusion_height = list(
"interpolate",
list("linear"),
list("zoom"),
0,
0,
100,
list("*", 2, list("get", "count"))
),
fill_extrusion_opacity = 0.7
)
|