Keenable SELECT showcaseAsk your own question →GitHubNearest Zoo Voronoi Atlas — United States
Trajectory · 29 messages, 16 tool calls · report · all reports
user
show me a voroni diagram mapping out all Nearest Zoo locations in the USA. go state-by-state then aggregate
assistant
tool call · select
SELECT
url,
title,
published_at,
SEM_EXTRACT(
content,
dataset_name := 'name of the zoo location dataset or directory',
scope := 'which United States zoo locations it includes',
location_fields := 'available geographic fields such as state, city, latitude, and longitude',
record_count := 'number of zoo or aquarium locations, number only',
evidence := 'per_field'
) AS info
FROM WEB_SEARCH(
'United States zoos dataset latitude longitude CSV',
'US zoo locations geocoded dataset download',
'GitHub USA zoos latitude longitude csv',
'data.gov zoo locations United States',
'all zoos in America map coordinates directory',
'OpenStreetMap United States zoos geodata download',
'AZA accredited zoo list locations state directory',
'Wikipedia list of zoos United States by state'
)
WHERE SEM_MATCH(content, 'describes or contains a multi-location dataset or directory of zoos in the United States'){
"show_preview": false
}tool call · select
SELECT
url,
title,
published_at,
SEM_EXTRACT(
content,
publisher := 'organization publishing the zoo directory',
inclusion_rule := 'eligibility or inclusion rule for listed zoological facilities',
facility_count := 'number of listed United States facilities, number only',
has_addresses := 'whether individual facility addresses or cities and states are provided',
evidence := 'per_field'
) AS info
FROM WEB_SEARCH(
'official Association of Zoos Aquariums accredited facilities United States list',
'AZA find a zoo aquarium directory map United States',
'Zoological Association of America accredited facilities directory USA',
'American zoo association member directory locations',
'USDA licensed zoo list United States facilities',
'state by state zoo directory USA official',
'accredited zoos by state United States 2026'
)
WHERE SEM_MATCH(content, 'is an official or authoritative directory or list of zoological facilities with locations'){
"show_preview": false
}tool result (35932 chars)
result_set_id: rc0de91b002d
total_rows: 45
columns[4]: info,published_at,title,url
rows[45]:
- url: "https://en.wikipedia.org/wiki/List_of_zoos_in_the_United_States"
title: List of zoos in the United States
published_at: "2026-08-09T17:15:39"
info:
dataset_name: List of zoos in the United States
scope: United States
location_fields: null
record_count: null
dataset_name_evidence[1]: This is an incomplete list of existing zoos in the United States.
scope_evidence[1]: This is an incomplete list of existing zoos in the United States.
location_fields_evidence: null
record_count_evidence: null
- url: "http://officialusa.com/stateguides/zoos"
title: "USA Zoos, Zoos in the United States"
published_at: null
info:
dataset_name: "Complete directory of zoos, aquariums, safari parks, wildlife sanctuaries, and nature preserves"
scope: across all 50 states
location_fields: null
record_count: null
dataset_name_evidence[3]: "Complete directory of zoos, aquariums, safari parks, wildlife sanctuaries, and nature preserves across all 50 states.",About This Zoo Directory,"This comprehensive directory lists zoos, aquariums, safari parks, wildlife sanctuaries, and nature preserves across all 50 United States."
scope_evidence[3]: "Complete directory of zoos, aquariums, safari parks, wildlife sanctuaries, and nature preserves across all 50 states.",About This Zoo Directory,"This comprehensive directory lists zoos, aquariums, safari parks, wildlife sanctuaries, and nature preserves across all 50 United States."
location_fields_evidence: null
record_count_evidence: null
- url: "https://officialusa.com/stateguides/zoos"
title: "USA Zoos, Zoos in the United States"
published_at: null
info:
dataset_name: "USA Zoos, Aquariums & Wildlife Parks"
scope: all 50 states
location_fields: null
record_count: null
dataset_name_evidence[2]: "# USA Zoos, Aquariums & Wildlife Parks","Complete directory of zoos, aquariums, safari parks, wildlife sanctuaries, and nature preserves across all 50 states."
scope_evidence[2]: "# USA Zoos, Aquariums & Wildlife Parks","Complete directory of zoos, aquariums, safari parks, wildlife sanctuaries, and nature preserves across all 50 states."
location_fields_evidence: null
record_count_evidence: null
- url: "https://grokipedia.com/page/List_of_zoos_in_the_United_States"
title: List of zoos in the United States
published_at: "2026-01-17T04:20:04"
info:
dataset_name: List of zoos in the United States
scope: all 50 states and the District of Columbia
location_fields: null
record_count: null
dataset_name_evidence[1]: # List of zoos in the United States
scope_evidence[2]: # List of zoos in the United States,"The list of zoos in the United States comprises a diverse collection of facilities that house and display animals for purposes of public education, scientific research, and wildlife conservation, spanning from large urban institutions to smaller regional parks across all 50 states and the District of Columbia.[1]"
location_fields_evidence: null
record_count_evidence: null
- url: "https://americanzoos.info/find-zoo-aquarium"
title: Find Zoo or Aquarium | U.S. List of Zoos & Aquariums
published_at: "2017-10-16T13:50:25"
info:
dataset_name: US List of Zoos & Aquariums
scope: United States of America
location_fields: "city, state"
record_count: null
dataset_name_evidence[1]: # US List of Zoos & Aquariums
scope_evidence[2]: # US List of Zoos & Aquariums,United States of America
location_fields_evidence[2]: # US List of Zoos & Aquariums,"** [Abilene Zoological Gardens](http://www.americanzoos.info/texas/abilene-zoological-gardens/)** , Abilene , Texas"
record_count_evidence: null
- url: "https://simple.wikipedia.org/wiki/List_of_zoos_in_the_United_States"
title: List of zoos in the United States
published_at: "2026-06-25T18:50:17"
info:
dataset_name: null
scope: United States
location_fields: null
record_count: null
dataset_name_evidence: null
scope_evidence[1]: This is a list of zoos in the United States.
location_fields_evidence: null
record_count_evidence: null
- url: "https://usa-zoos.com/zoo-links"
title: Zoo Links
published_at: null
info:
dataset_name: USA Zoo Links
scope: "Zoos, Aquariums, Conservation Centers, Observatories, and Sanctuaries located the United States."
location_fields: State and city
record_count: null
dataset_name_evidence[1]: USA Zoo Links
scope_evidence[2]: USA Zoo Links,"Zoos, Aquariums, Conservation Centers, Observatories, and Sanctuaries located the United States."
location_fields_evidence[4]: USA Zoo Links,Pick a State,Alabama,"- [Birmingham Zoo](http://www.birminghamzoo.com/), Birmingham"
record_count_evidence: null
- url: "https://en-wikipedia--on--ipfs-org.ipns.dweb.link/wiki/List_of_zoos_in_the_United_States"
title: List of zoos in the United States
published_at: null
info:
dataset_name: List of zoos in the United States
scope: United States
location_fields: "state, city"
record_count: null
dataset_name_evidence[1]: # List of zoos in the United States
scope_evidence[2]: # List of zoos in the United States,"This is an incomplete list of existing, reputable [zoos](Zoo) in the [United States](United_States)."
location_fields_evidence[3]: # List of zoos in the United States,"This is an incomplete list of existing, reputable [zoos](Zoo) in the [United States](United_States).","- [Alabama Gulf Coast Zoo](Alabama_Gulf_Coast_Zoo), [Gulf Shores](Gulf_Shores%2C_Alabama)"
record_count_evidence: null
- url: "https://kiwix.enszfarms.org/content/wikipedia_en_all_maxi_2025-08/List_of_zoos_in_the_United_States"
title: List of zoos in the United States
published_at: null
info:
dataset_name: List of zoos in the United States
scope: existing zoos in the United States
location_fields: null
record_count: null
dataset_name_evidence[1]: # List of zoos in the United States
scope_evidence[1]: # List of zoos in the United States
location_fields_evidence: null
record_count_evidence: null
- url: "https://a.osmarks.net/content/wikipedia_en_all_maxi_2020-08/A/List_of_zoos_in_the_United_States"
title: List of zoos in the United States
published_at: null
info:
dataset_name: List of zoos in the United States
scope: "existing, reputable zoos in the United States"
location_fields: null
record_count: null
dataset_name_evidence[1]: # List of zoos in the United States
scope_evidence[1]: # List of zoos in the United States
location_fields_evidence: null
record_count_evidence: null
- url: "https://bio.wikisort.org/zoo/en/Zoo/List_of_zoos_in_the_United_States"
title: List of zoos in the United States - Zoo
published_at: null
info:
dataset_name: List of zoos in the United States
scope: United States
location_fields: "state, city"
record_count: null
dataset_name_evidence[2]: **bio.wikisort.org - Zoo**," This is an incomplete list of existing, reputable zoos in the United States."
scope_evidence[2]: **bio.wikisort.org - Zoo**," This is an incomplete list of existing, reputable zoos in the United States."
location_fields_evidence[4]: **bio.wikisort.org - Zoo**," This is an incomplete list of existing, reputable zoos in the United States.",### Alabama,"- [Alabama Gulf Coast Zoo](//bio.wikisort.org/zoo/en/Zoo/Alabama_Gulf_Coast_Zoo), [Gulf Shores](//geo.wikisort.org/coast/en/Coast/Gulf_Shores,_Alabama)"
record_count_evidence: null
- url: "https://alphabeticalordering.com/united-states/list-of-zoos-in-usa"
title: Alphabetical List of Zoos in the United States
published_at: "2024-05-11T00:00:00"
info:
dataset_name: Alphabetical List of Zoos in the United States
scope: United States
location_fields: null
record_count: 687
dataset_name_evidence[1]: # Alphabetical List of Zoos in the United States
scope_evidence[2]: # Alphabetical List of Zoos in the United States,There are total of 687 Zoo in USA.
location_fields_evidence: null
record_count_evidence[2]: # Alphabetical List of Zoos in the United States,There are total of 687 Zoo in USA.
- url: "https://en.wikipedia.org/wiki/List_of_zoos_by_country"
title: List of zoos by country
published_at: "2026-07-23T22:08:39"
info:
dataset_name: null
scope: The United States
location_fields: null
record_count: null
dataset_name_evidence: null
scope_evidence[3]: This is a list of zoological gardens ( zoos) around the world.,### United States,The United States has over 400 zoos.
location_fields_evidence: null
record_count_evidence: null
- url: "https://americanzoos.info"
title: Zoos & Aquariums of America
published_at: null
info:
dataset_name: Zoos and Aquariums of America
scope: American
location_fields: "addresses, telephone & fax numbers"
record_count: null
dataset_name_evidence[1]: "## [Welcome to the Zoos and Aquariums of America!](https://americanzoos.info/welcome-to-the-zoos-and-aquariums-of-america/)"
scope_evidence[2]: "Every American zoo and aquarium has a quick information sheet with details about the institution containing addresses, telephone & fax numbers, staff, animal holdings, size (in hectares), number of visitors, entrance fees, emails and web sites.","## [Welcome to the Zoos and Aquariums of America!](https://americanzoos.info/welcome-to-the-zoos-and-aquariums-of-america/)"
location_fields_evidence[2]: "Every American zoo and aquarium has a quick information sheet with details about the institution containing addresses, telephone & fax numbers, staff, animal holdings, size (in hectares), number of visitors, entrance fees, emails and web sites.","## [Welcome to the Zoos and Aquariums of America!](https://americanzoos.info/welcome-to-the-zoos-and-aquariums-of-america/)"
record_count_evidence: null
- url: "http://doitintheamericas.com/us/attractions/zoos.htm"
title: Zoos in the United States
published_at: null
info:
dataset_name: Zoos in the United States
scope: United States
location_fields: "state, city"
record_count: null
dataset_name_evidence[1]: # Zoos in the United States Where to find zoos in the United States.
scope_evidence[1]: # Zoos in the United States Where to find zoos in the United States.
location_fields_evidence[2]: # Zoos in the United States Where to find zoos in the United States.,"Alabama Zoos Alabama Gulf Coast Zoo, Gulf Shores Birmingham Zoo, Birmingham Montgomery Zoo, Montgomery"
record_count_evidence: null
- url: "https://zootrack.me/zoos"
title: 4000+ Zoos Worldwide — Browse Species & Animal Lists | ZooTrack
published_at: null
info:
dataset_name: ZooTrack
scope: worldwide
location_fields: null
record_count: null
dataset_name_evidence[2]: # Zoos on ZooTrack,ZooTrack tracks 4000+ zoos worldwide.
scope_evidence[2]: ZooTrack tracks 4000+ zoos worldwide.,Explore zoos tracked by the ZooTrack community across 59 countries.
location_fields_evidence: null
record_count_evidence: null
- url: "https://onlinelibrary.wiley.com/doi/10.1111/j.1748-1090.2006.00004.x"
title: Index to list of zoos and aquariums of the world
published_at: "2006-06-28T00:00:00"
info:
dataset_name: list of zoos and aquariums of the world
scope: United States of America
location_fields: null
record_count: null
dataset_name_evidence[1]: index to list of zoos and aquariums of the world
scope_evidence[2]: In addition towns in Canada and the United States of America which do not appear as the first word(s) in the name of an institution are listed with the appropriate state and country.,index to list of zoos and aquariums of the world
location_fields_evidence: null
record_count_evidence: null
- url: "https://rascasse.com/explore/us/top/subtype/zoo-page-3"
title: Top 100 Zoos in United States 2026 — Ranked by Fan Data | Rascasse
published_at: "2026-07-11T00:00:00"
info:
dataset_name: Top 100
scope: United States
location_fields: null
record_count: 100
dataset_name_evidence[2]: "Position in the Top 100, sorted by audience size from largest to smallest. Updated weekly.",How is this Top 100 list compiled?
scope_evidence[4]: "Estimated number of unique people in United States who actively engage with this audience, derived from anonymized search-behavior signals.",Share of the global audience that is active in United States. A higher value means the audience is more locally concentrated here.,"Average age in years across the people who engage with this audience in United States, derived from anonymized search-behavior signals. A dash means demographic data is not yet available.","Share of women among the people who engage with this audience in United States. 50% is gender-balanced; values above mean female-skewed, below mean male-skewed."
location_fields_evidence: null
record_count_evidence[2]: "Position in the Top 100, sorted by audience size from largest to smallest. Updated weekly.",How is this Top 100 list compiled?
- url: "https://worldatlas.com/places/the-largest-zoos-in-the-united-states-56569.html"
title: The Largest Zoos In the United States
published_at: "2026-06-22T08:30:00"
info:
dataset_name: The Largest Zoos In the United States
scope: ten largest zoos in the United States by land area
location_fields: null
record_count: null
dataset_name_evidence[2]: # The Largest Zoos In the United States,"These are the ten largest zoos in the United States by land area, biggest first, and they are far weirder than the word \"zoo\" suggests."
scope_evidence[1]: "These are the ten largest zoos in the United States by land area, biggest first, and they are far weirder than the word \"zoo\" suggests."
location_fields_evidence: null
record_count_evidence: null
- url: "https://officialusa.com/stateguides/zoos/states/texas.html"
title: Zoos and Wildlife in Texas
published_at: null
info:
dataset_name: null
scope: Texas
location_fields: null
record_count: null
dataset_name_evidence: null
scope_evidence[2]: # Texas Zoos and Aquariums,"Discover Texas' vibrant zoo and aquarium community, featuring 15 AZA-accredited facilities, wildlife sanctuaries, and interactive animal experiences across the Lone Star State."
location_fields_evidence: null
record_count_evidence: null
- url: "https://owiki.org/wiki/List_of_zoos"
title: "List of zoos by country ::: Open WIKI"
published_at: null
info:
dataset_name: List of zoos by country
scope: United States
location_fields: null
record_count: null
dataset_name_evidence[2]: # List of zoos by country,This is a list of **zoological gardens** around the world.
scope_evidence[3]: # List of zoos by country,"### [[United States](/wiki/%5BUnited_States)]","[The United States](/wiki/The_United_States) has over 400 zoos."
location_fields_evidence: null
record_count_evidence: null
- url: "https://aza.org/find-a-zoo-or-aquarium?locale=es"
title: Find a Zoo or Aquarium Near Me
published_at: null
info:
dataset_name: AZA-accredited institutions
scope: AZA-accredited institutions
location_fields: null
record_count: 240
dataset_name_evidence[2]: Currently Accredited Zoos and Aquariums Look for the Association of Zoos and Aquariums (AZA) logo whenever you visit a zoo or aquarium.,As of September 2025 there are currently 240 AZA-accredited institutions.
scope_evidence[2]: Currently Accredited Zoos and Aquariums Look for the Association of Zoos and Aquariums (AZA) logo whenever you visit a zoo or aquarium.,As of September 2025 there are currently 240 AZA-accredited institutions.
location_fields_evidence: null
record_count_evidence[2]: Currently Accredited Zoos and Aquariums Look for the Association of Zoos and Aquariums (AZA) logo whenever you visit a zoo or aquarium.,As of September 2025 there are currently 240 AZA-accredited institutions.
- url: "https://rentechdigital.com/smartscraper/business-report-details/united-states/list-of-zoos-in-colorado"
title: List Of Zoos in Colorado
published_at: null
info:
dataset_name: List of Zoos in Colorado
scope: Zoos in Colorado
location_fields: "address, city, State/Territory, country, lat, lng"
record_count: 34
dataset_name_evidence[1]: # List of Zoos in Colorado
scope_evidence[3]: # List of Zoos in Colorado,"Number of Zoos in Colorado with email address, phone number, geocoded address,social media profiles and other key details for download.","There are a total of 34 Zoos in Colorado as of April 01, 2026."
location_fields_evidence[3]: # List of Zoos in Colorado,"Number of Zoos in Colorado with email address, phone number, geocoded address,social media profiles and other key details for download.",| name | address | city | State/Territory | country | email | phone | Review Count | Rating Scores | url | Facebook Profile | Instagram Handle | LinkedIn | Twitter | TikTok | YouTube |
record_count_evidence[2]: # List of Zoos in Colorado,"There are a total of 34 Zoos in Colorado as of April 01, 2026."
- url: "https://thezooreview.org/zoos-by-state"
title: Zoos by State - The Zoo Review
published_at: "2018-07-20T21:03:12"
info:
dataset_name: Zoos by State
scope: "Arizona, California, Connecticut, Delaware, Florida, Georgia, Hawaii, Idaho, Illinois, Indiana, Iowa, Kentucky, Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Montana, Nevada, New Hampshire, New Jersey, New York, North Carolina, North Dakota, Ohio, Oregon, Pennsylvania, Rhode Island, South Carolina, South Dakota, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin, Wyoming"
location_fields: null
record_count: null
dataset_name_evidence[1]: ## Zoos by State
scope_evidence[39]: ## Zoos by State,Zoos in Arizona,Zoos in California,Zoos in Connecticut,Zoos in Delaware,Zoos in Florida,Zoos in Georgia,Zoos in Hawaii,Zoos in Idaho,Zoos in Illinois,Zoos in Indiana,Zoos in Iowa,Zoos in Kentucky,Zoos in Maine,Zoos in Maryland,Zoos in Massachusetts,Zoos in Michigan,Zoos in Minnesota,Zoos in Mississippi,Zoos in Montana,Zoos in Nevada,Zoos in New Hampshire,Zoos in New Jersey,Zoos in New York,Zoos in North Carolina,Zoos in North Dakota,Zoos in Ohio,Zoos in Oregon,Zoos in Pennsylvania,Zoos in Rhode Island,Zoos in South Carolina,Zoos in South Dakota,Zoos in Utah,Zoos in Vermont,Zoos in Virginia,Zoos in Washington,Zoos in West Virginia,Zoos in Wisconsin,Zoos in Wyoming
location_fields_evidence: null
record_count_evidence: null
- url: "https://daytripper28.com/the-largest-zoo-in-every-state-a-complete-guide"
title: "The Largest Zoo in Every State: A Complete Guide"
published_at: "2025-08-12T12:26:30"
info:
dataset_name: "The Largest Zoo in Every State: A Complete Guide"
scope: the largest zoo in each state
location_fields: null
record_count: null
dataset_name_evidence[1]: "# The Largest Zoo in Every State: A Complete Guide"
scope_evidence[2]: "IWe’ll highlight the largest zoo in each state, whether measured by land size, number of species, or significance.","# The Largest Zoo in Every State: A Complete Guide"
location_fields_evidence: null
record_count_evidence: null
- url: "https://pettingzoo.fun/petting-zoo-finder"
title: Petting Zoo Finder - 🐾 Petting Zoo 🐾
published_at: "2025-08-16T15:46:11"
info:
dataset_name: Petting Zoos by State
scope: United States
location_fields: null
record_count: null
dataset_name_evidence[2]: # Browse Petting Zoos by State,"Our petting zoo directory is constantly growing with new family farms, animal sanctuaries, and unique animal encounters."
scope_evidence[2]: # Browse Petting Zoos by State,We are actively adding new locations across the country.
location_fields_evidence: null
record_count_evidence: null
- url: "https://integrativebiology.natsci.msu.edu/undergraduate-program/hands-on-opportunities/internships/list-of-non-aza-accredited-facilities"
title: List of non-AZA Accredited Facilities
published_at: null
info:
dataset_name: "list of zoos, aquaria, and centers not accredited by the Association of Zoos & Aquariums (AZA)"
scope: state-by-state
location_fields: null
record_count: null
dataset_name_evidence[1]: "This list of zoos, aquaria, and centers not accredited by the Association of Zoos & Aquariums (AZA) was researched and is indexed state-by-state."
scope_evidence[1]: "This list of zoos, aquaria, and centers not accredited by the Association of Zoos & Aquariums (AZA) was researched and is indexed state-by-state."
location_fields_evidence: null
record_count_evidence: null
- url: "https://wikiwand.com/en/List_of_zoos"
title: List of zoos by country - Wikiwand
published_at: null
info:
dataset_name: List of zoos by country
scope: United States
location_fields: null
record_count: null
dataset_name_evidence[1]: # List of zoos by country
scope_evidence[2]: # List of zoos by country,"### [United States](./United_States)"
location_fields_evidence: null
record_count_evidence: null
- url: "https://ourusaadventures.com/best-zoos-in-every-state"
title: "Animal Adventures: Discovering the Best Zoos in Every U.S. State"
published_at: "2024-08-09T19:03:05"
info:
dataset_name: "Animal Adventures: Discovering the Best Zoos in Every U.S. State"
scope: every state across the U.S.
location_fields: null
record_count: null
dataset_name_evidence[1]: "# Animal Adventures: Discovering the Best Zoos in Every U.S. State"
scope_evidence[2]: "We’ve compiled a list of the best zoos in every state across the U.S., highlighting what makes each one special.","# Animal Adventures: Discovering the Best Zoos in Every U.S. State"
location_fields_evidence: null
record_count_evidence: null
- url: "https://jetpunk.com/user-quizzes/1447459/aza-accredited-zoos/stats"
title: "Stats: AZA Accredited Zoos"
published_at: null
info: null
- url: "https://sportandspineclinic.com/top-50-zoos-in-the-us"
title: Top 50 Zoos In The Us
published_at: "2026-05-23T08:08:16"
info:
dataset_name: null
scope: US
location_fields: null
record_count: null
dataset_name_evidence: null
scope_evidence[2]: "Top 50 Zoos in the US: Discover the Best Wildlife Experiences Across America","Exploring the **top 50 zoos in the US** is one of the most rewarding ways to connect with nature, learn about endangered species, and create unforgettable family memories."
location_fields_evidence: null
record_count_evidence: null
- url: "https://theglobalstatistics.com/best-zoos-in-the-us"
title: Best Zoos in the US 2025 | Stats & Facts about US Zoos
published_at: "2025-08-20T14:18:35"
info:
dataset_name: Best Zoos in the US
scope: "San Diego Zoo, Bronx Zoo, Smithsonian National Zoo, Lincoln Park Zoo, Houston Zoo, Denver Zoo, Zoo Atlanta, Cincinnati Zoo, Central Park Zoo, Oregon Zoo"
location_fields: null
record_count: null
dataset_name_evidence[4]: # Best Zoos in the US 2025 | Stats & Facts about US Zoos,## Best Zoos in the US,| **Rank** | **Zoo Name** | **Location** | **Size (Acres)** | **Annual Visitors** | **Notable Features** |,"| **1** | **San Diego Zoo** | San Diego, California | **100 acres** | **4.2 million** | World-renowned conservation programs |"
scope_evidence[13]: # Best Zoos in the US 2025 | Stats & Facts about US Zoos,## Best Zoos in the US,| **Rank** | **Zoo Name** | **Location** | **Size (Acres)** | **Annual Visitors** | **Notable Features** |,"| **1** | **San Diego Zoo** | San Diego, California | **100 acres** | **4.2 million** | World-renowned conservation programs |","| **2** | **Bronx Zoo** | Bronx, New York | **265 acres** | **2.2 million** | America’s largest metropolitan zoo |","| **3** | **Smithsonian National Zoo** | Washington, DC | **163 acres** | **2.5 million** | Giant panda conservation center |","| **4** | **Lincoln Park Zoo** | Chicago, Illinois | **35 acres** | **3.0 million** | Free admission since 1868 |","| **5** | **Houston Zoo** | Houston, Texas | **55 acres** | **2.55 million** | Leading elephant conservation facility |","| **6** | **Denver Zoo** | Denver, Colorado | **84 acres** | **2.3 million** | High-altitude animal adaptations |","| **7** | **Zoo Atlanta** | Atlanta, Georgia | **40 acres** | **1.3 million** | Largest zoological collection in Southeast |","| **8** | **Cincinnati Zoo** | Cincinnati, Ohio | **75 acres** | **1.87 million** | America’s second oldest zoo |","| **9** | **Central Park Zoo** | New York City, New York | **6.5 acres** | **1.2 million** | Premium urban zoo experience |","| **10** | **Oregon Zoo** | Portland, Oregon | **64 acres** | **1.6 million** | Pacific Northwest wildlife expertise |"
location_fields_evidence: null
record_count_evidence: null
- url: "https://wikipedia-org.zproxy.org/wiki/List_of_zoos_by_country"
title: Wikimedia list article
published_at: "2002-08-08T14:02:00"
info:
dataset_name: List of zoos by country
scope: The United States has over 400 zoos.
location_fields: null
record_count: null
dataset_name_evidence[2]: # List of zoos by country,"This is a list of **zoological gardens** ([zoos](/wiki/Zoo)) around the world."
scope_evidence[4]: # List of zoos by country,"This is a list of **zoological gardens** ([zoos](/wiki/Zoo)) around the world.",The United States has over 400 zoos.,"Some of the most well-known and highly rated zoos in the United States include:"
location_fields_evidence: null
record_count_evidence: null
- url: "https://rd.com/list/best-zoo-every-state"
title: The Best Zoo in Every State in America
published_at: "2019-04-03T16:08:28"
info:
dataset_name: The Best Zoo in Every State in America
scope: Each state across the United States
location_fields: null
record_count: null
dataset_name_evidence[1]: # The Best Zoo in Every State in America
scope_evidence[2]: # The Best Zoo in Every State in America,"From the largest to the oldest to the most fascinating, these are the best zoos in each state across the United States."
location_fields_evidence: null
record_count_evidence: null
- url: "https://apps.apple.com/us/app/zoo-scout-zoo-maps/id6499110122?l=vi"
title: Ứng dụng Zoo Scout - Zoo Maps - App Store
published_at: "2024-07-26T14:07:21"
info:
dataset_name: Zoo Scout
scope: United States
location_fields: "State, City, Country"
record_count: 25
dataset_name_evidence[3]: #,Zoo Scout - Zoo Maps,Current Zoos Available in Zoo Scout ==========================
scope_evidence[2]: Current Zoos Available in Zoo Scout ==========================,"- Bronx Zoo, NY, USA"
location_fields_evidence[2]: Current Zoos Available in Zoo Scout ==========================,"- Bronx Zoo, NY, USA"
record_count_evidence[26]: Current Zoos Available in Zoo Scout ==========================,"- Bronx Zoo, NY, USA","- Brookfield Zoo, IL, USA","- Central Park Zoo, NY, USA","- Cincinnati Zoo, OH, USA","- Cleveland Metroparks Zoo, OH, USA","- Como Park Zoo & Conservatory, MN, USA","- Denver Zoo, CO, USA","- Detroit Zoo, MI, USA","- Houston Zoo, TX, USA","- Lincoln Park Zoo, IL, USA","- Los Angeles Zoo, CA, USA","- Milwaukee County Zoo, WI, USA","- Omaha’s Henery Doorly Zoo & Aquarium, NE, USA","- Oregon Zoo, OR, USA","- Paris Zoological Park, France","- Phoenix Zoo, AZ,USA","- Riverbanks Zoo, SC, USA","- San Diego Zoo, CA, USA","- San Francisco Zoo, CA, USA","- Smithsonian National Zoo, DC, USA","- St. Louis Zoo, MO, USA","- Woodland Park Zoo, WA, USA","- Zoo Atlanta, GA, USA","- Zoo Miami, FL, USA","- ZooTampa at Lory Park, FL, USA"
- url: "https://geojango.com/products/best-zoos-in-the-usa-map"
title: Zoo Map USA
published_at: null
info:
dataset_name: Zoo Lover's Map
scope: the top 60 zoos in the USA
location_fields: null
record_count: null
dataset_name_evidence[2]: # Map of the Best Zoos in the USA,Embark on a journey through America's finest zoos with our exclusive Zoo Lover's Map!
scope_evidence[2]: # Map of the Best Zoos in the USA,"Designed for wildlife enthusiasts and adventure seekers alike, this map showcases the top 60 zoos in the USA."
location_fields_evidence: null
record_count_evidence: null
- url: "https://doi.org/10.1111/j.1748-1090.2009.00110.x"
title: Index to list of Zoos and Aquariums of the World
published_at: "2010-01-01T00:00:00"
info: null
- url: "https://a.osmarks.net/content/wikipedia_en_all_maxi_2020-08/A/List_of_AZA_member_zoos_and_aquaria"
title: List of AZA member zoos and aquaria
published_at: null
info:
dataset_name: null
scope: United States and international locations
location_fields: null
record_count: null
dataset_name_evidence: null
scope_evidence[3]: "Name\nAddress\nCity\nState/country\nWebsite","[Abilene Zoological Gardens](Abilene_Zoological_Gardens)\n2070 Zoo Ln\n[Abilene](Abilene%2C_Texas)\n[Texas](Texas), [United States](United_States)\n[Website](http://www.abilenezoo.org/)","Acuario de Veracruz\nBlvd. Manuel Ávila Camacho S/N, Ricardo Flores Magón\nVeracruz\n[Veracruz](Veracruz), [Mexico](Mexico)\n[Website](https://web.archive.org/web/20140204231441/http://www.acuariodeveracruz.com/home.html)"
location_fields_evidence: null
record_count_evidence: null
- url: "https://onlinelibrary.wiley.com/doi/10.1111/j.1748-1090.2009.00110.x"
title: Index to list of Zoos and Aquariums of the World
published_at: "2010-01-01T00:00:00"
info: null
- url: "https://apify.com/straightforward_hydra/us-attractions-museums-directory"
title: US Tourist Attractions & Museums Directory Scraper · Apify
published_at: "2026-07-19T17:34:55"
info:
dataset_name: US Tourist Attractions & Museums Directory Scraper
scope: any US state
location_fields: null
record_count: null
dataset_name_evidence[2]: US Tourist Attractions & Museums Directory Scraper 🏛️,US Tourist Attractions & Museums Directory Scraper
scope_evidence[2]: "Extract tourist attractions in any US state — museums, galleries, zoos, theme parks, monuments, castles, memorials and landmarks — with name, type, address, website and GPS coordinates.",US Tourist Attractions & Museums Directory Scraper
location_fields_evidence: null
record_count_evidence: null
- url: "https://poidata.io/index.php/report/zoo/united-states/new-mexico"
title: "Zoo in New Mexico, United States - Business Data & Market Insights"
published_at: null
info:
dataset_name: null
scope: "New Mexico, United States"
location_fields: null
record_count: null
dataset_name_evidence: null
scope_evidence[2]: "# How many Zoos are there in New Mexico, United States?","There are **6** Zoos in New Mexico, United States as of May, 2026."
location_fields_evidence: null
record_count_evidence: null
- url: "https://kiwix.enszfarms.org/content/wikipedia_en_all_maxi_2025-08/List_of_zoos"
title: List of zoos by country
published_at: null
info:
dataset_name: null
scope: United States
location_fields: null
record_count: null
dataset_name_evidence: null
scope_evidence[2]: # List of zoos by country,"Some of the most well-known and highly rated zoos in the United States include:[59][60]"
location_fields_evidence: null
record_count_evidence: null
- url: "https://poidata.io/report/zoo/united-states/nevada"
title: "Zoo in Nevada, United States - Business Data & Market Insights"
published_at: null
info:
dataset_name: "List of Zoos in Nevada, United States?"
scope: "Nevada, United States"
location_fields: "Complete Street Address, Website URL, Phone Number, Email Address, Customer Rating, Review Count, Photo Count, Business Timezone, Latitude Coordinates, Longitude Coordinates, Business Categories, Price Range Information, Rating Distribution, Business Photos, Popular Times Data, Additional Business Info, Key Business Highlights, Operating Hours, Topic Categories, Owner Information, Business age, Last Updated Date, Social Media Profiles"
record_count: 11
dataset_name_evidence[1]: "# List of Zoos in Nevada, United States?"
scope_evidence[2]: "# List of Zoos in Nevada, United States?","There are **11** Zoos in Nevada, United States as of April, 2026."
location_fields_evidence[25]: "# List of Zoos in Nevada, United States?","#### Complete Data Fields for Zoos in Nevada, United States:",Complete Street Address,Website URL,Phone Number,Email Address,Customer Rating,Review Count,Photo Count,Business Timezone,Latitude Coordinates,Longitude Coordinates,Business Categories,Price Range Information,Rating Distribution,Business Photos,Popular Times Data,Additional Business Info,Key Business Highlights,Operating Hours,Topic Categories,Owner Information,Business age,Last Updated Date,Social Media Profiles
record_count_evidence[2]: "# List of Zoos in Nevada, United States?","There are **11** Zoos in Nevada, United States as of April, 2026."
- url: "https://newsbreak.com/a-z-animals-1693032/3503445999516-the-10-largest-zoos-in-the-united-states-in-2024"
title: The 10 Largest Zoos in the United States in 2024 - NewsBreak
published_at: "2024-06-24T17:34:54"
info:
dataset_name: The 10 Largest Zoos in the United States in 2024
scope: The 10 largest zoos in the United States
location_fields: null
record_count: null
dataset_name_evidence[2]: # The 10 Largest Zoos in the United States in 2024,The 10 Largest Zoos in the United States in 2024
scope_evidence[2]: The 10 largest zoos in the United States are home to thousands of animals representing many species.,# The 10 Largest Zoos in the United States in 2024
location_fields_evidence: null
record_count_evidence: null
- url: "https://attractionsofamerica.com/thingstodo/zoological-parks.php"
title: 30 Best Zoos in the US You Must Visit | Attractions of America
published_at: null
info:
dataset_name: 30 Best Zoos in the US You Must Visit
scope: 30 zoos listed below are the best of them all
location_fields: null
record_count: null
dataset_name_evidence[1]: # 30 Best Zoos in the US You Must Visit
scope_evidence[2]: # 30 Best Zoos in the US You Must Visit,"It may be hard to decide which are the best zoos in the USA to visit, but the 30 zoos listed below are the best of them all."
location_fields_evidence: null
record_count_evidence: null
notes[2,]{text}:
Merged 8 queries (1599 total) → 895 unique results
"Search result set: rd0a4f55419e (895 rows), reference it as FROM rd0a4f55419e in follow-up queries"result set rc0de91b002d · 45 rows
| url | title | published_at | info |
|---|---|---|---|
| https://en.wikipedia.org/wiki/List_of_zoos_in_the_United_States | List of zoos in the United States | 2026-08-09T17:15:39 | {"dataset_name": "List of zoos in the United States", "scope": "United States", "location_fields": null, "record_count": null, "dataset_name_evidence": ["This … |
| http://officialusa.com/stateguides/zoos | USA Zoos, Zoos in the United States | null | {"dataset_name": "Complete directory of zoos, aquariums, safari parks, wildlife sanctuaries, and nature preserves", "scope": "across all 50 states", "location_… |
| https://officialusa.com/stateguides/zoos | USA Zoos, Zoos in the United States | null | {"dataset_name": "USA Zoos, Aquariums & Wildlife Parks", "scope": "all 50 states", "location_fields": null, "record_count": null, "dataset_name_evidence": ["# … |
| https://grokipedia.com/page/List_of_zoos_in_the_United_States | List of zoos in the United States | 2026-01-17T04:20:04 | {"dataset_name": "List of zoos in the United States", "scope": "all 50 states and the District of Columbia", "location_fields": null, "record_count": null, "da… |
| https://americanzoos.info/find-zoo-aquarium | Find Zoo or Aquarium | U.S. List of Zoos & Aquariums | 2017-10-16T13:50:25 | {"dataset_name": "US List of Zoos & Aquariums", "scope": "United States of America", "location_fields": "city, state", "record_count": null, "dataset_name_evid… |
tool result (25468 chars)
result_set_id: re603e60883c
total_rows: 40
columns[4]: info,published_at,title,url
rows[40]:
- url: "https://aza.org/inst-status"
title: Association of Zoos & Aquariums
published_at: null
info:
publisher: AZA
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: "# [](https://www.aza.org/connect?utm_source=inst_status&utm_medium=square&utm_campaign=connect&utm_content=vulture&term=read_connect)AZA-Accredited Members","As of March 2026, there are currently 240 AZA-accredited institutions and 14 AZA-accredited related facilities."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://en.wikipedia.org/wiki/Association_of_Zoos_and_Aquariums"
title: Association of Zoos and Aquariums
published_at: "2026-08-20T12:22:27"
info:
publisher: Association of Zoos and Aquariums
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: "The Association of Zoos and Aquariums ( AZA), originally the American Association of Zoological Parks and Aquariums ( AAZPA), is an American 501(c)(3) nonprofit organization founded in 1924 and dedicated to the advancement of zoos and public aquariums in the areas of conservation, education, science, and recreation.",List of member zoos and aquariums
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://aza.org/current-accreditation-list"
title: Association of Zoos & Aquariums
published_at: null
info:
publisher: AZA
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: AZA-Accredited Members,"As of March 2026, there are currently 240 AZA-accredited institutions and 14 AZA-accredited related facilities."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "http://aza.org/inst-status"
title: Association of Zoos & Aquariums
published_at: null
info:
publisher: AZA
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: "# [](https://www.aza.org/connect?utm_source=inst_status&utm_medium=square&utm_campaign=connect&utm_content=vulture&term=read_connect)AZA-Accredited Members","As of March 2026, there are currently 240 AZA-accredited institutions and 14 AZA-accredited related facilities."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://aza.org/inst-status?locale="
title: Association of Zoos & Aquariums
published_at: null
info:
publisher: AZA
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: "# [](https://www.aza.org/connect?utm_source=inst_status&utm_medium=square&utm_campaign=connect&utm_content=vulture&term=read_connect)AZA-Accredited Members","As of March 2026, there are currently 240 AZA-accredited institutions and 14 AZA-accredited related facilities."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://en.wikipedia.org/wiki/List_of_AZA_member_zoos_and_aquariums"
title: Association of Zoos and Aquariums
published_at: "2026-06-11T00:44:29"
info:
publisher: Association of Zoos and Aquariums
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: "The Association of Zoos and Aquariums ( AZA), originally the American Association of Zoological Parks and Aquariums ( AAZPA), is an American 501(c)(3) nonprofit organization founded in 1924 and dedicated to the advancement of zoos and public aquariums in the areas of conservation, education, science, and recreation.",## List of member zoos and aquariums
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://aza.org/find-a-zoo-or-aquarium?locale=es"
title: Find a Zoo or Aquarium Near Me
published_at: null
info:
publisher: Association of Zoos and Aquariums
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: Currently Accredited Zoos and Aquariums Look for the Association of Zoos and Aquariums (AZA) logo whenever you visit a zoo or aquarium.,As of September 2025 there are currently 240 AZA-accredited institutions.
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://owiki.org/wiki/Association_of_Zoos_and_Aquariums"
title: "Association of Zoos and Aquariums ::: Open WIKI"
published_at: null
info:
publisher: Association of Zoos and Aquariums
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: # Association of Zoos and Aquariums,"The **Association of Zoos and Aquariums**, originally the **American Association of Zoological Parks and Aquariums**, is an American [501(c)(3)](/wiki/501%28c%29%283%29)\n[nonprofit organization](/wiki/Nonprofit_organization) founded in 1924 and dedicated to the advancement of [zoo](/wiki/Zoo)s and [public aquarium](/wiki/Public_aquarium)s in the areas of [conservation](/wiki/Conservation_movement), education, science, and recreation."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://aza.org/inst-status?q=Ocean%20Park"
title: Association of Zoos & Aquariums
published_at: null
info:
publisher: AZA
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: "# [](https://www.aza.org/connect?utm_source=inst_status&utm_medium=square&utm_campaign=connect&utm_content=vulture&term=read_connect)AZA-Accredited Members","As of March 2026, there are currently 240 AZA-accredited institutions and 14 AZA-accredited related facilities."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://web.archive.org/web/20240415140208/https:/www.aza.org/inst-status"
title: Association of Zoos & Aquariums
published_at: null
info:
publisher: AZA
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: AZA-Accredited Members,"As of March 2024, there are currently 236 AZA-accredited institutions and 15 AZA-accredited related facilities. Please see the complete list of AZA institutional members below, organized by location, or click **[here](/web/20240415140208/https://www.aza.org/search-by-zip-code)** to search by zip code."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://zoos.regionaldirectory.us"
title: Zoos Directory
published_at: null
info:
publisher: RegionalDirectory.us
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: Copyright © 2010-2026 RegionalDirectory.us. All rights reserved.,Zoos Directory |
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://aza.org/find-a-zoo-or-aquarium?loccountry=US&locdistance=25&locsearch=98112&sortdir=distance-asc"
title: Find a Zoo or Aquarium Near Me
published_at: null
info: null
- url: "https://americanzoos.info"
title: Zoos & Aquariums of America
published_at: null
info: null
- url: "https://web.archive.org/web/20191101151357/https:/www.aza.org/current-accreditation-list"
title: Currently Accredited Zoos and Aquariums
published_at: null
info:
publisher: AZA
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[1]: The total number of AZA-accredited zoos and aquariums is 239.
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://olps.co.za/kiwix/content/wikipedia_en_all_maxi_2024-01/A/List_of_WAZA_member_zoos_and_aquariums"
title: List of WAZA member zoos and aquariums
published_at: null
info: null
- url: "https://calmzoo.org/wp-content/uploads/2026/07/State-Reciprocal-Zoo-Museum-List-updated2026-SA.pdf"
title: State Reciprocal Zoo & Museum List - updated2026- SA
published_at: "2026-07-30T20:30:33"
info:
publisher: CALM Zoo
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: Below is a reciprocity list of zoos & museums that have chosen to participate in a reciprocal admission program with CALM Zoo.,"Each of the listed zoos &\nmuseums will reciprocate either free admission or 50% admission for CALM Zoo members."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://it.wikipedia.org/wiki/Giardini_zoologici_e_acquari_dei_membri_WAZA"
title: Giardini zoologici e acquari dei membri WAZA
published_at: "2026-07-15T17:15:23"
info:
publisher: World Association of Zoos and Aquariums
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[1]: Questa è una lista dell'World Association of Zoos and Aquariums ( WAZA) dove sono mostrati gli zoo e acquari che fanno parte dell'organizzazione.
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://assets.speakcdn.com/assets/2332/aza_bucket-list_member-checklist_final.pdf"
title: AZA_Bucket-List_Member-Checklist_Final.indd
published_at: "2023-08-29T20:17:55"
info:
publisher: AZA
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[8]: "AZA MEMBERS \nCHECKLIST","As of March 2023, there are \n238 AZA-accredited institutions \nand 15 AZA-accredited related \nfacilities.","For the latest list of all AZA \nmembers, visit www.aza.org/\ninst-status.",AZA MEMBERS CHECKLIST,"SPANNING THE \nGLOBE",As of March 2023,* = Accredited Related Facility,"AZA-accredited institutions \nand 15 AZA-accredited related \nfacilities."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://assets.speakcdn.com/assets/2332/reciprocity_chart.pdf"
title: Always call the zoo or aquarium you plan to visit ahead of time ...
published_at: "2026-06-18T18:04:09"
info:
publisher: AZA
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: "This is a Reciprocity List of AZA Zoos \nand Aquariums that have chosen to \nparticipate in the Reciprocity \nAdmission Program.","In addition,\nparticipating institutions located in close geographic proximity to each other are not required to offer free or discounted admission to each \nother’s members in order to participate in AZA’s Reciprocal Admissions Program; for instance—Milwaukee County Zoo does not \nreciprocate with Henry Vilas Zoo, Lincoln Park Zoo, NEW Zoo & Adventure Park or Racine Zoo."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://floridaiguana.com/Zoological-Association-of-America"
title: FloridaIguana.com
published_at: null
info:
publisher: Zoological Association of America
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: # Accredited ZAA Facilities,"[ Proud Member of Zoological Association of America](http://zaa.org/accreditation/accredited-facilities)"
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://web.archive.org/web/20150622112515/https:/www.aza.org/findzooaquarium"
title: Find an AZA-Accredited Zoo or Aquarium
published_at: "2014-08-26T00:04:32"
info:
publisher: Association of Zoos and Aquariums (AZA)
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[1]: "Look for the Association of Zoos and Aquariums (AZA) logo whenever you visit a zoo or aquarium as your assurance that you are supporting a facility dedicated to providing excellent care for animals, a great experience for you, and a better future for all living things."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://infoplease.com/math-science/biology/plants-animals/us-zoos-and-aquariums"
title: U.S. Zoos and Aquariums
published_at: "2017-02-11T17:23:04"
info:
publisher: American Zoo and Aquarium Association (AZA)
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[1]: "Source: The facilities listed are members of, and accredited by, the American Zoo and Aquarium Association (AZA) to ensure that they are maintaining professional standards."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://marylandzoo.org/wp-content/uploads/2026/01/AZA-Reciprocal-List2026.pdf"
title: AZA Reciprocal List2026
published_at: "2026-01-19T20:03:17"
info:
publisher: The Maryland Zoo
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: Reciprocal List - 2026,Below is a list of institutions which offer discounted admission (50% off) to members of The Maryland Zoo for the 2026 calendar year.
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://aza.org/reciprocity?locale=es"
title: AZA Reciprocal Admissions | Free Zoos and Aquarium Admission
published_at: null
info:
publisher: AZA
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[1]: "AZA Reciprocal Admissions Program By becoming a member of your local AZA-accredited zoo or aquarium, you can gain access to discounted admissions to other AZA-accredited zoos and aquariums that choose to participate in our Reciprocal Admissions Program."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://phoenixzoo.org/wp-content/uploads/2026/05/AZA-Reciprocal-Zoos-List.pdf"
title: AZA Reciprocal Zoos List
published_at: "2026-05-05T18:45:44"
info:
publisher: Phoenix Zoo
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: Phoenix Zoo,The following is a list of zoos and aquariums offering Phoenix Zoo Members free or reduced admission.
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://phoenixzoo.org/wp-content/uploads/2026/04/AZA-Reciprocal-Zoos-List.pdf"
title: AZA Reciprocal Zoos List
published_at: "2026-04-03T18:11:44"
info:
publisher: Phoenix Zoo
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: Phoenix Zoo,The following is a list of zoos and aquariums offering Phoenix Zoo Members free or reduced admission.
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://zooguideusa.com"
title: Zoo Guide USA
published_at: null
info:
publisher: Zoo Guide USA
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: | Zoo Pic |,"| | **\"Zoo Guide**** USA\"** | |"
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://americanzoos.info/welcome-to-the-zoos-and-aquariums-of-america"
title: Welcome to the Zoos and Aquariums of America!
published_at: "2017-10-16T05:49:48"
info: null
- url: "https://docslib.org/doc/3504987/zoos-aquariums"
title: Zoos & Aquariums
published_at: null
info:
publisher: Richard K. Miller & Associates
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: "ZOOS & AQUARIUMS The following zoos and aquariums are accredited by the American Zoo and Aquarium Association: Alabama • Birmingham Zoo (Birmingham; www.birminghamzoo.com) • Montgomery Zoo and Mann Wildlife Learning Museum (Montgomery; www.montgomeryzoo.com) Alaska • Alaska SeaLife Center (Seward; www.alaskasealife.org) Arizona • Arizona-Sonora Desert Museum (Tucson; www.desertmuseum.org) • Phoenix Zoo (Phoenix; www.phoenixzoo.org) • Reid Park Zoo (Tucson; www.tucsonzoo.org) Arkansas • Little Rock Zoo (Little Rock; www.littlerockzoo.com) California • Aquarium of the Bay (San Francisco; www.aquariumofthebay.org) • Aquarium of the Pacific (Long Beach; www.aquariumofpacific.org) • Birch Aquarium at Scripps Inst. of Oceanography (La Jolla; www.aquarium.ucsd.edu) • Cabrillo Marine Aquarium (San Pedro; www.cabrillomarineaquarium.org) • California Science Center (Los Angeles; www.californiasciencecenter.org) • Charles Paddock Zoo (Atascadero; www.charlespaddockzoo.org) • CuriOdyssey (San Mateo; www.curiodyssey.org) • Fresno Chaffee Zoo (Fresno; www.chaffeezoo.org) • Happy Hollow Zoo (San Jose; www.hhpz.org) • Living Desert (Palm Desert; www.livingdesert.org) • Los Angeles Zoo and Botanical Gardens (Los Angeles; www.lazoo.org) • Monterey Bay Aquarium (Monterey; www.montereybayaquarium.org) • Oakland Zoo (Oakland; www.oaklandzoo.org) • Sacramento Zoo (Sacramento; www.saczoo.org) • Safari West Wildlife Preserve (Santa Rosa; www.safariwest.com) • San Diego Zoo (San Diego; www.sandiegozoo.org) • San Diego Zoo Safari Park (Escondido; www.sdzsafaripark.org) • San Francisco Zoological Gardens (San Francisco; www.sfzoo.org) RICHARD K. MILLER & ASSOCIATES • 1 •",ZOOS & AQUARIUMS
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://ams.aza.org/eweb/DynamicPage.aspx?Action=Add&DoNotSave=yes&ObjectKeyFROM=1A83491A-9853-4C87-86A4-F7D95601C2E2&ParentDataObject=Invoice%20Detail&ParentObject=CentralizedOrderEntry&WebCode=ProdDetailAdd&ivd_cst_key=00000000-0000-0000-0000-000000000000&ivd_cst_ship_key=00000000-0000-0000-0000-000000000000&ivd_formkey=69202792-63d7-4ba2-bf4e-a0da41270555&ivd_prc_prd_key=F30C0EF3-E4C1-4464-A35B-FB438B101E28"
title: Online Store
published_at: null
info:
publisher: AZA
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[1]: "To learn how the default name and title of the record can be replaced with a generic title (ex: Gift Buyer), please [contact](mailto:membership@aza.org) AZA's Membership Services Department."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "http://zooguideusa.com"
title: Zoo Guide USA
published_at: null
info:
publisher: Zoo Guide USA
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: | Zoo Pic |,"| | **\"Zoo Guide**** USA\"** | |"
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://marylandzoo.org/wp-content/uploads/2024/12/AZA-Reciprocal-List_2025.docx.pdf"
title: AZA Reciprocal List_2025.docx
published_at: null
info:
publisher: The Maryland Zoo
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: Reciprocal List - 2025,"Below is a list of institutions which offer discounted admission (50% off) to members of The\nMaryland Zoo for the 2025 calendar year."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://upload.wikimedia.org/wikipedia/commons/c/cc/Animal_welfare._List_of_licensed_exhibitors_and_registered_exhibitors_-_United_States_Department_of_Agriculture%2C_Animal_and_Plant_Health_Inspection_Service._%28IA_CAT10878887003%29.pdf"
title: "Animal welfare. List of licensed exhibitors and registered exhibitors / United States Department of Agriculture, Animal and Plant Health Inspection Service."
published_at: "2018-06-12T16:56:17"
info:
publisher: United States Department of Agriculture
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[1]: "United States \nDepartment of \nAgriculture"
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://factmonster.com/math-science/biology/plants-animals/us-zoos-and-aquariums"
title: U.S. Zoos and Aquariums
published_at: null
info:
publisher: American Zoo and Aquarium Association (AZA)
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: / Math & Science / Biology / Plant Kingdom / U.S. Zoos and Aquariums,"The facilities listed are members of, and accredited by, the American Zoo and Aquarium Association (AZA) to ensure that they are maintaining professional standards."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://marylandzoo.org/wp-content/uploads/2026/05/AZA-Reciprocal-List_May2026.pdf"
title: AZA Reciprocal List_May2026
published_at: "2026-05-12T16:43:14"
info:
publisher: The Maryland Zoo
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: Below is a list of institutions which offer discounted admission (50% off) to members of The Maryland Zoo for the 2026 calendar year.,Reciprocal List - 2026
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "http://odp.org/Science/Biology/Zoology/Zoos_and_Aquariums/North_America/United_States/Florida"
title: "Florida Web Directory: ODP.org > Science > Biology > Zoology > Zoos and Aquariums > North America > United States"
published_at: null
info:
publisher: DMOZ
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[1]: "Thanks to DMOZ, which built a great web directory for nearly two decades and freely shared it with the web."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "http://odp.org/Science/Biology/Zoology/Zoos_and_Aquariums/North_America/United_States/New_York"
title: "New York Web Directory: ODP.org > Science > Biology > Zoology > Zoos and Aquariums > North America > United States"
published_at: null
info:
publisher: DMOZ
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[2]: Directory of New York Resources,"Thanks to DMOZ, which built a great web directory for nearly two decades and freely shared it with the web."
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://upload.wikimedia.org/wikipedia/commons/b/bd/Animal_welfare._List_of_licensed_exhibitors_-_United_States_Department_of_Agriculture%2C_Animal_and_Plant_Health_Inspection_Service%2C_Veterinary_Services._%28IA_CAT10416602002%29.pdf"
title: "Animal welfare. List of licensed exhibitors / United States Department of Agriculture, Animal and Plant Health Inspection Service, Veterinary Services."
published_at: "2018-06-12T15:43:46"
info:
publisher: United States Department of Agriculture Animal and Plant Health Inspection Service Veterinary Services
inclusion_rule: null
facility_count: null
has_addresses: null
publisher_evidence[1]: "United States \nDepartment of \nAgriculture \n\nAnimal and \nPlant Health \nInspection \nService \n\nVeterinary \nServices"
inclusion_rule_evidence: null
facility_count_evidence: null
has_addresses_evidence: null
- url: "https://kingsnake.com/zoos/by_state.php?state=NY"
title: "kingsnake.com - Locate a Zoo, Aquarium, & Wildlife Park"
published_at: null
info: null
- url: "https://aazk.org/institutional"
title: Institutional Members Archive - AAZK
published_at: null
info: null
notes[2,]{text}:
Merged 7 queries (1399 total) → 853 unique results
"Search result set: rbb3285f5f22 (853 rows), reference it as FROM rbb3285f5f22 in follow-up queries"result set re603e60883c · 40 rows
| url | title | published_at | info |
|---|---|---|---|
| https://aza.org/inst-status | Association of Zoos & Aquariums | null | {"publisher": "AZA", "inclusion_rule": null, "facility_count": null, "has_addresses": null, "publisher_evidence": ["# [![Connect Your Source for Zoo and Aquari… |
| https://en.wikipedia.org/wiki/Association_of_Zoos_and_Aquariums | Association of Zoos and Aquariums | 2026-08-20T12:22:27 | {"publisher": "Association of Zoos and Aquariums", "inclusion_rule": null, "facility_count": null, "has_addresses": null, "publisher_evidence": ["The Associati… |
| https://aza.org/current-accreditation-list | Association of Zoos & Aquariums | null | {"publisher": "AZA", "inclusion_rule": null, "facility_count": null, "has_addresses": null, "publisher_evidence": ["AZA-Accredited Members", "As of March 2026,… |
| http://aza.org/inst-status | Association of Zoos & Aquariums | null | {"publisher": "AZA", "inclusion_rule": null, "facility_count": null, "has_addresses": null, "publisher_evidence": ["# [![Connect Your Source for Zoo and Aquari… |
| https://aza.org/inst-status?locale= | Association of Zoos & Aquariums | null | {"publisher": "AZA", "inclusion_rule": null, "facility_count": null, "has_addresses": null, "publisher_evidence": ["# [![Connect Your Source for Zoo and Aquari… |
assistant
tool call · select
SELECT
url,
title,
SEM_EXTRACT(
content,
repository_or_dataset := 'repository or dataset name',
direct_download_url := 'direct URL of a CSV, GeoJSON, JSON, KML, or other machine-readable file',
record_scope := 'types and geography of animal facilities represented',
coordinate_fields := 'names of latitude and longitude fields',
license := 'data license',
evidence := 'per_field'
) AS data
FROM WEB_SEARCH(
'site:github.com zoos USA latitude longitude csv',
'site:github.com US zoo GeoJSON',
'site:raw.githubusercontent.com zoo latitude longitude United States',
'site:data.world zoos United States coordinates',
'site:kaggle.com datasets USA zoos latitude longitude',
'OpenStreetMap zoo United States GeoJSON dataset',
'Overpass Turbo zoo USA export GeoJSON',
'US zoos coordinates CSV download'
)
WHERE SEM_MATCH(content, 'offers machine-readable location data for many United States zoos and includes or can provide geographic coordinates'){
"show_preview": false
}tool result (945 chars)
result_set_id: r00a8ba8feb5
total_rows: 1
columns[3]: data,title,url
rows[1]:
- url: "http://poi-factory.com/node/32532"
title: "Zoo's AZA, CAZA & WAZA World plus"
data:
repository_or_dataset: "Zoo's AZA, CAZA & WAZA World plus"
direct_download_url: null
record_scope: null
coordinate_fields: null
license: null
repository_or_dataset_evidence[2]: "# Zoo's AZA, CAZA & WAZA World plus","Raw file: Zoo's AZA, CAZA & WAZA World Plus.csv (59.98 KB)"
direct_download_url_evidence: null
record_scope_evidence: null
coordinate_fields_evidence: null
license_evidence: null
notes[3,]{text}:
Merged 8 queries (1550 total) → 1495 unique results
"Search result set: r95fa66449ec (1495 rows), reference it as FROM r95fa66449ec in follow-up queries"
"WARNING: semantic extraction failed on 1 of 1495 rows — extracted values are null on those rows. First error: timed_out after 90.0s"result set r00a8ba8feb5 · 1 rows
| url | title | data |
|---|---|---|
| http://poi-factory.com/node/32532 | Zoo's AZA, CAZA & WAZA World plus | {"repository_or_dataset": "Zoo's AZA, CAZA & WAZA World plus", "direct_download_url": null, "record_scope": null, "coordinate_fields": null, "license": null, "… |
assistant
tool call · select
SELECT
url,
title,
length(content) AS content_length,
substr(content, 1, 1000) AS content_head
FROM WEB_FETCH(
'https://overpass-api.de/api/interpreter?data=%5Bout%3Ajson%5D%5Btimeout%3A180%5D%3Barea%5B%22ISO3166-1%22%3D%22US%22%5D%5Badmin_level%3D2%5D-%3E.a%3Bnwr%5B%22tourism%22%3D%22zoo%22%5D%28area.a%29%3Bout%20center%20tags%3B'
){
"show_preview": false
}tool result (67 chars)
error: "An unexpected error occurred during fetch: HTTPStatusError"
assistant
tool call · select
SELECT
url,
title,
SEM_EXTRACT(
content,
file_url := 'direct download URL for the raw CSV file',
updated_date := 'date dataset was last updated, YYYY-MM-DD',
location_count := 'number of locations, number only',
geographic_scope := 'countries or region covered',
evidence := 'per_field'
) AS file
FROM WEB_SEARCH(
'"Zoo’s AZA, CAZA & WAZA World Plus.csv"',
'"Zoo''s AZA, CAZA & WAZA World Plus.csv"',
'site:poi-factory.com "Zoo''s AZA" csv',
'POI Factory zoos CSV download latitude longitude',
'"Raw file" "World Plus.csv" zoos',
'"Zoo''s AZA, CAZA & WAZA" download'
)
WHERE SEM_MATCH(content, 'provides the raw CSV file or download metadata for the zoo POI dataset'){
"show_preview": false
}tool call · select
SELECT
url,
title,
SEM_EXTRACT(
content,
endpoint_or_file := 'direct API endpoint or machine-readable download URL',
format := 'response format such as JSON, GeoJSON, or CSV',
us_zoo_count := 'number of United States zoo features, number only',
query_method := 'how the United States zoo data was queried or exported',
evidence := 'per_field'
) AS data
FROM WEB_SEARCH(
'Overpass API United States tourism=zoo JSON result',
'Overpass turbo USA zoos export GeoJSON URL',
'OpenStreetMap all US zoos download GeoJSON',
'Geofabrik USA points of interest zoo shapefile',
'HOT export United States tourism zoo data',
'OSM zoo POI United States API data'
)
WHERE SEM_MATCH(content, 'provides a machine-readable API or file for extracting zoo points from OpenStreetMap in the United States'){
"show_preview": false
}tool result (1121 chars)
result_set_id: rd8af542cb98
total_rows: 2
columns[3]: file,title,url
rows[2]:
- url: "http://poi-factory.com/node/35070"
title: transferring POI error messages | POI Factory
file:
file_url: "C:\\Downloads\\zoo's_aza_&_ caza_approved_plus.csv"
updated_date: null
location_count: null
geographic_scope: null
file_url_evidence[2]: "Has numerous issues listed below from the \"verifier\"","C:\\Downloads\\zoo's_aza_&_ caza_approved_plus.csv"
updated_date_evidence: null
location_count_evidence: null
geographic_scope_evidence: null
- url: "http://poi-factory.com/node/750"
title: UK Zoos | POI Factory
file:
file_url: null
updated_date: 2007-04-01
location_count: null
geographic_scope: null
file_url_evidence: null
updated_date_evidence[2]: # UK Zoos,Last updated 01/04/2007
location_count_evidence: null
geographic_scope_evidence: null
notes[2,]{text}:
Merged 6 queries (210 total) → 200 unique results
"Search result set: r46b281108c2 (200 rows), reference it as FROM r46b281108c2 in follow-up queries"result set rd8af542cb98 · 2 rows
| url | title | file |
|---|---|---|
| http://poi-factory.com/node/35070 | transferring POI error messages | POI Factory | {"file_url": "C:\\Downloads\\zoo's_aza_&_ caza_approved_plus.csv", "updated_date": null, "location_count": null, "geographic_scope": null, "file_url_evidence":… |
| http://poi-factory.com/node/750 | UK Zoos | POI Factory | {"file_url": null, "updated_date": "2007-04-01", "location_count": null, "geographic_scope": null, "file_url_evidence": null, "updated_date_evidence": ["# UK Z… |
tool result (521 chars)
result_set_id: rb38287c1880
total_rows: 0
columns[0]:
notes[4,]{text}:
This result set is empty (0 rows) and cannot be queried — query its input result set instead.
Merged 6 queries (1200 total) → 1101 unique results
"Search result set: r47d076bc633 (1101 rows), reference it as FROM r47d076bc633 in follow-up queries"
The query returned 0 rows. The unfiltered input is saved as result set r47d076bc633 (1101 rows) — loosen the conditions and query FROM r47d076bc633 again; do NOT re-run the search or extraction.assistant
tool call · select
SELECT
url,
title,
length(content) AS content_length,
substr(content, 1, 3000) AS content_head
FROM WEB_FETCH(
'https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ43501%20%3B%20wdt%3AP17%20wd%3AQ30%20%3B%20wdt%3AP625%20%3Fcoord%20.%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP131%2A%20%3Fstate%20.%20%3Fstate%20wdt%3AP31%20wd%3AQ35657%20.%20%7D%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%7D%20%7D&format=csv'
){
"show_preview": false
}tool result (4123 chars)
result_set_id: r1e19d61754c
total_rows: 1
columns[4]: content_head,content_length,title,url
rows[1,]{url,title,content_length,content_head}:
"https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ43501%20%3B%20wdt%3AP17%20wd%3AQ30%20%3B%20wdt%3AP625%20%3Fcoord%20.%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP131%2A%20%3Fstate%20.%20%3Fstate%20wdt%3AP31%20wd%3AQ35657%20.%20%7D%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%7D%20%7D&format=csv",null,223801,"<?xml version='1.0' encoding='UTF-8'?>\n<sparql xmlns='http://www.w3.org/2005/sparql-results#'>\n\t<head>\n\t\t<variable name='item'/>\n\t\t<variable name='itemLabel'/>\n\t\t<variable name='coord'/>\n\t\t<variable name='state'/>\n\t\t<variable name='stateLabel'/>\n\t</head>\n\t<results>\n\t\t<result>\n\t\t\t<binding name='item'>\n\t\t\t\t<uri>http://www.wikidata.org/entity/Q6518868</uri>\n\t\t\t</binding>\n\t\t\t<binding name='state'>\n\t\t\t\t<uri>http://www.wikidata.org/entity/Q1400</uri>\n\t\t\t</binding>\n\t\t\t<binding name='coord'>\n\t\t\t\t<literal datatype='http://www.opengis.net/ont/geosparql#wktLiteral'>Point(-75.626 40.6583)</literal>\n\t\t\t</binding>\n\t\t\t<binding name='itemLabel'>\n\t\t\t\t<literal xml:lang='en'>Lehigh Valley Zoo</literal>\n\t\t\t</binding>\n\t\t\t<binding name='stateLabel'>\n\t\t\t\t<literal xml:lang='en'>Pennsylvania</literal>\n\t\t\t</binding>\n\t\t</result>\n\t\t<result>\n\t\t\t<binding name='item'>\n\t\t\t\t<uri>http://www.wikidata.org/entity/Q6761437</uri>\n\t\t\t</binding>\n\t\t\t<binding name='state'>\n\t\t\t\t<uri>http://www.wikidata.org/entity/Q771</uri>\n\t\t\t</binding>\n\t\t\t<binding name='coord'>\n\t\t\t\t<literal datatype='http://www.opengis.net/ont/geosparql#wktLiteral'>Point(-70.0959 41.2819)</literal>\n\t\t\t</binding>\n\t\t\t<binding name='itemLabel'>\n\t\t\t\t<literal xml:lang='en'>Maria Mitchell Aquarium</literal>\n\t\t\t</binding>\n\t\t\t<binding name='stateLabel'>\n\t\t\t\t<literal xml:lang='en'>Massachusetts</literal>\n\t\t\t</binding>\n\t\t</result>\n\t\t<result>\n\t\t\t<binding name='item'>\n\t\t\t\t<uri>http://www.wikidata.org/entity/Q7419807</uri>\n\t\t\t</binding>\n\t\t\t<binding name='state'>\n\t\t\t\t<uri>http://www.wikidata.org/entity/Q99</uri>\n\t\t\t</binding>\n\t\t\t<binding name='coord'>\n\t\t\t\t<literal datatype='http://www.opengis.net/ont/geosparql#wktLiteral'>Point(-118.495833333 34.01)</literal>\n\t\t\t</binding>\n\t\t\t<binding name='itemLabel'>\n\t\t\t\t<literal xml:lang='en'>Heal the Bay Aquarium</literal>\n\t\t\t</binding>\n\t\t\t<binding name='stateLabel'>\n\t\t\t\t<literal xml:lang='en'>California</literal>\n\t\t\t</binding>\n\t\t</result>\n\t\t<result>\n\t\t\t<binding name='item'>\n\t\t\t\t<uri>http://www.wikidata.org/entity/Q7776908</uri>\n\t\t\t</binding>\n\t\t\t<binding name='state'>\n\t\t\t\t<uri>http://www.wikidata.org/entity/Q1387</uri>\n\t\t\t</binding>\n\t\t\t<binding name='coord'>\n\t\t\t\t<literal datatype='http://www.opengis.net/ont/geosparql#wktLiteral'>Point(-71.4163 41.7899)</literal>\n\t\t\t</binding>\n\t\t\t<binding name='itemLabel'>\n\t\t\t\t<literal xml:lang='en'>The Zoo In Forest Park</literal>\n\t\t\t</binding>\n\t\t\t<binding name='stateLabel'>\n\t\t\t\t<literal xml:lang='en'>Rhode Island</literal>\n\t\t\t</binding>\n\t\t</result>\n\t\t<result>\n\t\t\t<binding name='item'>\n\t\t\t\t<uri>http://www.wikidata.org/entity/Q6715234</uri>\n\t\t\t</binding>\n\t\t\t<binding name='state'>\n\t\t\t\t<uri>http://www.wikidata.org/entity/Q1415</uri>\n\t\t\t</binding>\n\t\t\t<binding name='coord'>\n\t\t\t\t<literal datatype='http://www.opengis.net/ont/geosparql#wktLiteral'>Point(-85.209 40.1196)</literal>\n\t\t\t</binding>\n\t\t\t<binding name='itemLabel'>\n\t\t\t\t<literal xml:lang='en'>ME's Zoo</literal>\n\t\t\t</binding>\n\t\t\t<binding name='stateLabel'>\n\t\t\t\t<literal xml:lang='en'>Indiana</literal>\n\t\t\t</binding>\n\t\t"
notes[1,]{text}:
"Fetch result set: ree24654de4a (1 rows), reference it as FROM ree24654de4a in follow-up queries"result set r1e19d61754c · 1 rows
| url | title | content_length | content_head |
|---|---|---|---|
| https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2F… | null | 223801 | <?xml version='1.0' encoding='UTF-8'?> <sparql xmlns='http://www.w3.org/2005/sparql-results#'> <head> <variable name='item'/> <variable name='itemLabel'/>… |
assistant
tool call · select
SELECT
regexp_extract(block, '<binding name=''item''>[\\s\\S]*?<uri>([^<]+)</uri>', 1) AS wikidata_url,
regexp_extract(block, '<binding name=''itemLabel''>[\\s\\S]*?<literal[^>]*>([^<]+)</literal>', 1) AS zoo,
regexp_extract(block, '<binding name=''stateLabel''>[\\s\\S]*?<literal[^>]*>([^<]+)</literal>', 1) AS state,
TRY_CAST(regexp_extract(block, 'Point\\(([-0-9.]+) [-0-9.]+\\)', 1) AS DOUBLE) AS longitude,
TRY_CAST(regexp_extract(block, 'Point\\([-0-9.]+ ([-0-9.]+)\\)', 1) AS DOUBLE) AS latitude,
source_url
FROM (
SELECT
url AS source_url,
UNNEST(
regexp_extract_all(content, '<result>[\\s\\S]*?</result>', 0),
recursive := true
) AS block
FROM WEB_FETCH(
'https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ43501%20%3B%20wdt%3AP17%20wd%3AQ30%20%3B%20wdt%3AP625%20%3Fcoord%20.%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP131%2A%20%3Fstate%20.%20%3Fstate%20wdt%3AP31%20wd%3AQ35657%20.%20%7D%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%7D%20%7D&format=xml'
)
)
WHERE state <> ''
AND zoo <> ''
AND latitude BETWEEN 18 AND 72
AND longitude BETWEEN -180 AND -60
ORDER BY
state,
zoo{
"show_preview": false
}tool result (460 chars)
result_set_id: r3ecea7fda90
total_rows: 0
columns[0]:
notes[3,]{text}:
This result set is empty (0 rows) and cannot be queried — query its input result set instead.
"Fetch result set: r6d96aa9df4f (1 rows), reference it as FROM r6d96aa9df4f in follow-up queries"
The query returned 0 rows. The unfiltered input is saved as result set r6d96aa9df4f (1 rows) — loosen the conditions and query FROM r6d96aa9df4f again; do NOT re-run the search or extraction.assistant
tool call · select
SELECT
zoo,
state,
latitude,
longitude,
COUNT(*) OVER (PARTITION BY state) AS zoos_in_state,
source_url,
wikidata_url
FROM (
SELECT
html_decode(regexp_extract(block, '(?s)<binding name=''itemLabel''>.*?<literal[^>]*>(.*?)</literal>', 1)) AS zoo,
html_decode(regexp_extract(block, '(?s)<binding name=''stateLabel''>.*?<literal[^>]*>(.*?)</literal>', 1)) AS state,
TRY_CAST(regexp_extract(block, 'Point\\(([-0-9.]+) [-0-9.]+\\)', 1) AS DOUBLE) AS longitude,
TRY_CAST(regexp_extract(block, 'Point\\([-0-9.]+ ([-0-9.]+)\\)', 1) AS DOUBLE) AS latitude,
regexp_extract(block, '(?s)<binding name=''item''>.*?<uri>(.*?)</uri>', 1) AS wikidata_url,
url AS source_url
FROM (
SELECT
url,
UNNEST(
regexp_extract_all(content, '(?s)<result>(.*?)</result>', 1),
recursive := true
) AS block
FROM r6d96aa9df4f
)
)
WHERE zoo <> ''
AND state <> ''
AND latitude BETWEEN 18 AND 72
AND longitude BETWEEN -180 AND -60
ORDER BY
state,
zoo{
"show_preview": false
}tool result (407 chars)
error: "SQL execution failed: Catalog Error: Scalar Function with name html_decode does not exist!\nDid you mean \"url_decode\"?\n\nLINE 1: ...) AS zoos_in_state, source_url, wikidata_url FROM (SELECT HTML_DECODE(REGEXP_EXTRACT(block, '(?s)<binding name=''item...\n ^\nTables in this query: r6d96aa9df4f(content, published_at, title, url)"
assistant
tool call · select
SELECT
zoo,
state,
latitude,
longitude,
COUNT(*) OVER (PARTITION BY state) AS zoos_in_state,
source_url,
wikidata_url
FROM (
SELECT
regexp_replace(regexp_extract(block, '(?s)<binding name=''itemLabel''>.*?<literal[^>]*>(.*?)</literal>', 1), '&', '&', 'g') AS zoo,
regexp_replace(regexp_extract(block, '(?s)<binding name=''stateLabel''>.*?<literal[^>]*>(.*?)</literal>', 1), '&', '&', 'g') AS state,
TRY_CAST(regexp_extract(block, 'Point\\(([-0-9.]+) [-0-9.]+\\)', 1) AS DOUBLE) AS longitude,
TRY_CAST(regexp_extract(block, 'Point\\([-0-9.]+ ([-0-9.]+)\\)', 1) AS DOUBLE) AS latitude,
regexp_extract(block, '(?s)<binding name=''item''>.*?<uri>(.*?)</uri>', 1) AS wikidata_url,
url AS source_url
FROM (
SELECT
url,
UNNEST(
regexp_extract_all(content, '(?s)<result>(.*?)</result>', 1),
recursive := true
) AS block
FROM r6d96aa9df4f
)
)
WHERE zoo <> ''
AND state <> ''
AND latitude BETWEEN 18 AND 72
AND longitude BETWEEN -180 AND -60
ORDER BY
state,
zoo{
"show_preview": false
}tool result (166 chars)
result_set_id: rca1ab91d07d
total_rows: 0
columns[0]:
notes[1,]{text}:
This result set is empty (0 rows) and cannot be queried — query its input result set instead.assistant
tool call · generate_html_report
{"brief":"The user asked, verbatim: “show me a voroni diagram mapping out all Nearest Zoo locations in the USA. go state-by-state then aggregate”. Correct the spelling discreetly to “Voronoi.” Build a beautiful, interactive atlas whose lead visual is a nationwide Voronoi diagram of zoo locations, followed by a state-by-state explorer and aggregate summaries.\n\nUse r6d96aa9df4f as the core data. It contains one row whose `content` is a Wikidata SPARQL XML result set. Parse every `<result>` block. For each result, extract: zoo entity URL from binding `item`; zoo name from `itemLabel`; coordinate from `coord`, whose WKT is `Point(longitude latitude)`; state entity from `state`; and state name from `stateLabel`. Decode XML entities and deduplicate by zoo entity URL. Keep the 50 US states plus the District of Columbia when present. One row represents one mapped zoo location. Treat this as the complete set returned by the stated query, not as every zoo that exists in reality. The SPARQL query selected Wikidata entities that are an instance/subclass of zoo, country United States, have coordinates, and have a state in their administrative-location chain.\n\nLead with ONE large visual: an interactive contiguous-US Voronoi/tessellation map generated from every parsed zoo point, with Alaska and Hawaii as well-designed insets. Clip cells to US/state boundaries. Each cell means places geographically nearest to that zoo among this dataset; it is not a driving-time service area. Plot a visible point at each zoo and use restrained categorical colors by state. Tooltip: zoo, state, latitude, longitude, Wikidata link. Offer zoom, pan, search, and state filtering. Include a toggle between national competition (cells computed from all US zoo points) and within-state competition (cells recomputed using only zoos in the selected state and clipped to that state).\n\nThen provide a state-by-state explorer, alphabetically, with one compact state map/card per state showing its zoo points and within-state Voronoi cells. Clearly flag states with zero returned locations rather than silently omitting them. Add an aggregate ranked bar chart/table of mapped zoo count by state, plus KPI totals: unique zoos, states/DC represented, states with zero results, and the extraction date 2026-08-31. Counts must be computed from the parsed unique zoo rows, not copied from secondary pages.\n\nrc0de91b002d contains web-source context. Cite the Wikidata query URL from r6d96aa9df4f as the primary source. Use rc0de91b002d only for a methodology/context note that other directories differ in scope: Wikipedia calls its US list incomplete, OfficialUSA describes a directory spanning all 50 states, and AZA reported 240 accredited institutions as of September 2025. Do not blend those directory counts into the mapped dataset.\n\nImportant caveats: “nearest” is straight-line/geographic proximity based on point coordinates, not road distance or travel time; Voronoi areas can look huge in sparsely represented regions; Wikidata coverage and classification are incomplete and may include facilities whose names say aquarium if Wikidata classifies them under zoo; coordinates can be missing or imperfect. Label the map “Wikidata zoo locations returned by query” rather than “all US zoos.” Make the report polished, accessible, responsive, and visually striking, with an animal/natural-history palette and clear legends.","result_set_ids":["r6d96aa9df4f","rc0de91b002d"],"title":"Nearest Zoo Voronoi Atlas — United States","prev_report_token":null}assistant
tool call · select
SELECT
source_url,
UNNEST(
SEM_EXTRACT_ALL(
content,
'a zoo result in the Wikidata SPARQL XML response',
zoo := 'English zoo or facility label',
state := 'United States state or District of Columbia label',
latitude := 'latitude from the WKT Point coordinate, number only',
longitude := 'longitude from the WKT Point coordinate, number only',
wikidata_url := 'Wikidata entity URL for the zoo or facility'
),
recursive := true
)
FROM (
SELECT
url AS source_url,
content
FROM r6d96aa9df4f
){
"show_preview": false
}tool result (1662 chars)
result_set_id: ra0d8e86b00f
total_rows: 635
columns[6]: latitude,longitude,source_url,state,wikidata_url,zoo
preview:
sample_rows[3,]{source_url,zoo,state,latitude,longitude,wikidata_url}:
"https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ43501%20%3B%20wdt%3AP17%20wd%3AQ30%20%3B%20wdt%3AP625%20%3Fcoord%20.%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP131%2A%20%3Fst... [truncated in preview]",Idaho Aquarium,null,null,null,null
"https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ43501%20%3B%20wdt%3AP17%20wd%3AQ30%20%3B%20wdt%3AP625%20%3Fcoord%20.%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP131%2A%20%3Fst... [truncated in preview]",null,null,38.7712,null,null
"https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ43501%20%3B%20wdt%3AP17%20wd%3AQ30%20%3B%20wdt%3AP625%20%3Fcoord%20.%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP131%2A%20%3Fst... [truncated in preview]",null,null,null,null,"http://www.wikidata.org/entity/Q7452551"
notes[1,]{text}:
"The full table is too large to return in one response. This is a preview, not the data — do not draw conclusions from it alone. Query the result set by id: SEM_EXTRACT fields, filter with exact WHERE, aggregate, or page with LIMIT/OFFSET. Even if the preview looks irrelevant, probe the full result set before searching again."result set ra0d8e86b00f · 635 rows
| source_url | zoo | state | latitude | longitude | wikidata_url |
|---|---|---|---|---|---|
| https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2F… | Idaho Aquarium | null | null | null | null |
| https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2F… | null | Idaho | null | null | null |
| https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2F… | null | null | 43.60541 | null | null |
| https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2F… | null | null | null | -116.27333 | null |
| https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2F… | null | null | null | null | http://www.wikidata.org/entity/Q5987303 |
assistant
tool call · select
SELECT
zoo,
state,
latitude,
longitude,
wikidata_url,
source_url
FROM (
SELECT
regexp_extract(clean_block, '<binding name=''itemLabel''>.*?<literal[^>]*>([^<]+)</literal>', 1) AS zoo,
regexp_extract(clean_block, '<binding name=''stateLabel''>.*?<literal[^>]*>([^<]+)</literal>', 1) AS state,
TRY_CAST(regexp_extract(clean_block, 'Point\\(([-0-9.]+) [-0-9.]+\\)', 1) AS DOUBLE) AS longitude,
TRY_CAST(regexp_extract(clean_block, 'Point\\([-0-9.]+ ([-0-9.]+)\\)', 1) AS DOUBLE) AS latitude,
regexp_extract(clean_block, '<binding name=''item''>.*?<uri>([^<]+)</uri>', 1) AS wikidata_url,
source_url
FROM (
SELECT
url AS source_url,
regexp_replace(block, '[[:space:]]+', ' ', 'g') AS clean_block
FROM (
SELECT
url,
UNNEST(string_split(content, '<result>'), recursive := true) AS block
FROM r6d96aa9df4f
)
)
)
WHERE zoo <> ''
AND state <> ''
AND latitude IS NOT NULL
AND longitude IS NOT NULL
ORDER BY
state,
zoo{
"show_preview": false
}tool result (166 chars)
result_set_id: rec56b84126c
total_rows: 0
columns[0]:
notes[1,]{text}:
This result set is empty (0 rows) and cannot be queried — query its input result set instead.assistant
tool call · select
SELECT
regexp_extract(block, '<binding name=''item''>[^<]*<uri>([^<]+)</uri>', 1) AS wikidata_url,
regexp_extract(block, '<binding name=''itemLabel''>[^<]*<literal[^>]*>([^<]+)</literal>', 1) AS zoo,
regexp_extract(block, '<binding name=''stateLabel''>[^<]*<literal[^>]*>([^<]+)</literal>', 1) AS state,
TRY_CAST(regexp_extract(block, 'Point\\(([-0-9.]+) [-0-9.]+\\)', 1) AS DOUBLE) AS longitude,
TRY_CAST(regexp_extract(block, 'Point\\([-0-9.]+ ([-0-9.]+)\\)', 1) AS DOUBLE) AS latitude,
url AS source_url
FROM (
SELECT
url,
UNNEST(string_split(replace(replace(content, chr(10), ' '), chr(9), ' '), '<result>'), recursive := true) AS block
FROM r6d96aa9df4f
)
WHERE block LIKE '%itemLabel%'
AND block LIKE '%stateLabel%'
AND block LIKE '%Point(%'
ORDER BY
state,
zoo{
"show_preview": false
}tool result (1771 chars)
result_set_id: r1704e3f7341
total_rows: 382
columns[6]: latitude,longitude,source_url,state,wikidata_url,zoo
preview:
sample_rows[3,]{wikidata_url,zoo,state,longitude,latitude,source_url}:
"http://www.wikidata.org/entity/Q4705255",Alabama Gulf Coast Zoo,Alabama,null,null,"https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ43501%20%3B%20wdt%3AP17%20wd%3AQ30%20%3B%20wdt%3AP625%20%3Fcoord%20.%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP131%2A%20%3Fst... [truncated in preview]"
"http://www.wikidata.org/entity/Q14692574",Como Zoo,Minnesota,null,null,"https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ43501%20%3B%20wdt%3AP17%20wd%3AQ30%20%3B%20wdt%3AP625%20%3Fcoord%20.%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP131%2A%20%3Fst... [truncated in preview]"
"http://www.wikidata.org/entity/Q49577277",Washington Park,Wisconsin,null,null,"https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ43501%20%3B%20wdt%3AP17%20wd%3AQ30%20%3B%20wdt%3AP625%20%3Fcoord%20.%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP131%2A%20%3Fst... [truncated in preview]"
notes[1,]{text}:
"The full table is too large to return in one response. This is a preview, not the data — do not draw conclusions from it alone. Query the result set by id: SEM_EXTRACT fields, filter with exact WHERE, aggregate, or page with LIMIT/OFFSET. Even if the preview looks irrelevant, probe the full result set before searching again."result set r1704e3f7341 · 382 rows
| wikidata_url | zoo | state | longitude | latitude | source_url |
|---|---|---|---|---|---|
| http://www.wikidata.org/entity/Q4705255 | Alabama Gulf Coast Zoo | Alabama | null | null | https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2F… |
| http://www.wikidata.org/entity/Q865749 | Birmingham Zoo | Alabama | null | null | https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2F… |
| http://www.wikidata.org/entity/Q6905834 | Montgomery Zoo | Alabama | null | null | https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2F… |
| http://www.wikidata.org/entity/Q4708604 | Alaska SeaLife Center | Alaska | null | null | https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2F… |
| http://www.wikidata.org/entity/Q4708633 | Alaska Wildlife Conservation Center | Alaska | null | null | https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2F… |
assistant
tool call · select
SELECT
zoo,
state,
TRY_CAST(split_part(split_part(block, 'Point(', 2), ' ', 1) AS DOUBLE) AS longitude,
TRY_CAST(split_part(split_part(split_part(block, 'Point(', 2), ' ', 2), ')', 1) AS DOUBLE) AS latitude,
wikidata_url,
source_url
FROM (
SELECT
regexp_extract(block, '<binding name=''item''>[^<]*<uri>([^<]+)</uri>', 1) AS wikidata_url,
regexp_extract(block, '<binding name=''itemLabel''>[^<]*<literal[^>]*>([^<]+)</literal>', 1) AS zoo,
regexp_extract(block, '<binding name=''stateLabel''>[^<]*<literal[^>]*>([^<]+)</literal>', 1) AS state,
block,
url AS source_url
FROM (
SELECT
url,
UNNEST(string_split(replace(replace(content, chr(10), ' '), chr(9), ' '), '<result>'), recursive := true) AS block
FROM r6d96aa9df4f
)
)
WHERE zoo <> ''
AND state <> ''
AND block LIKE '%Point(%'
ORDER BY
state,
zoo{
"show_preview": false
}tool result (1790 chars)
result_set_id: rbdfe7f6beed
total_rows: 382
columns[6]: latitude,longitude,source_url,state,wikidata_url,zoo
preview:
sample_rows[3,]{zoo,state,longitude,latitude,wikidata_url,source_url}:
Alabama Gulf Coast Zoo,Alabama,-87.6885,30.2617,"http://www.wikidata.org/entity/Q4705255","https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ43501%20%3B%20wdt%3AP17%20wd%3AQ30%20%3B%20wdt%3AP625%20%3Fcoord%20.%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP131%2A%20%3Fst... [truncated in preview]"
Como Zoo,Minnesota,-93.1539,44.9822,"http://www.wikidata.org/entity/Q14692574","https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ43501%20%3B%20wdt%3AP17%20wd%3AQ30%20%3B%20wdt%3AP625%20%3Fcoord%20.%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP131%2A%20%3Fst... [truncated in preview]"
Washington Park,Wisconsin,-87.968,43.053,"http://www.wikidata.org/entity/Q49577277","https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ43501%20%3B%20wdt%3AP17%20wd%3AQ30%20%3B%20wdt%3AP625%20%3Fcoord%20.%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP131%2A%20%3Fst... [truncated in preview]"
notes[1,]{text}:
"The full table is too large to return in one response. This is a preview, not the data — do not draw conclusions from it alone. Query the result set by id: SEM_EXTRACT fields, filter with exact WHERE, aggregate, or page with LIMIT/OFFSET. Even if the preview looks irrelevant, probe the full result set before searching again."result set rbdfe7f6beed · 382 rows
| zoo | state | longitude | latitude | wikidata_url | source_url |
|---|---|---|---|---|---|
| Alabama Gulf Coast Zoo | Alabama | -87.6885 | 30.2617 | http://www.wikidata.org/entity/Q4705255 | https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2F… |
| Birmingham Zoo | Alabama | -86.7796 | 33.4874 | http://www.wikidata.org/entity/Q865749 | https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2F… |
| Montgomery Zoo | Alabama | -86.2772 | 32.4201 | http://www.wikidata.org/entity/Q6905834 | https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2F… |
| Alaska SeaLife Center | Alaska | -149.441 | 60.1 | http://www.wikidata.org/entity/Q4708604 | https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2F… |
| Alaska Wildlife Conservation Center | Alaska | -148.9844 | 60.8215 | http://www.wikidata.org/entity/Q4708633 | https://query.wikidata.org/sparql?query=SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fcoord%20%3Fstate%20%3FstateLabel%20WHERE%20%7B%20%3Fitem%20wdt%3AP31%2F… |
assistant
tool call · generate_html_report
{"brief":"The user asked, verbatim: “show me a voroni diagram mapping out all Nearest Zoo locations in the USA. go state-by-state then aggregate”. Correct the spelling discreetly to “Voronoi.” Create a beautiful interactive atlas led by a nationwide Voronoi map, with state-by-state views and aggregates.\n\nrbdfe7f6beed is the primary, ready-to-map dataset: 382 Wikidata-returned US zoo/facility rows with zoo name, state, latitude, longitude, Wikidata entity URL, and the source SPARQL URL. Deduplicate by wikidata_url before calculating totals if any duplicates remain. The underlying Wikidata query selected entities that are an instance/subclass of zoo, country United States, have coordinates, and resolve through their administrative-location chain to a US state. The finding to state prominently: the query returned 382 geocoded facilities. Compute the number of states/DC represented and every per-state count directly from these rows. Report extraction date: 2026-08-31.\n\nLead with ONE large visual: interactive US Voronoi/tessellation map generated from all point coordinates. Clip cells to US/state boundaries. Show contiguous US, with Alaska and Hawaii as clear insets. Each cell is the region geographically nearest to that zoo among this dataset. Plot visible zoo points. Color cells categorically by state with a restrained natural-history palette. Tooltip: zoo, state, latitude, longitude, clickable Wikidata URL. Include zoom, pan, search, and state filter. If feasible, include a toggle: “National” computes cells from all 382 facilities; “Within selected state” computes cells only from that state and clips to its border.\n\nNext, go state-by-state alphabetically. Use small state maps/cards with that state’s points and within-state Voronoi cells; show the state count clearly. Include all 50 states plus District of Columbia and flag zero-result jurisdictions instead of omitting them. Then aggregate: a ranked horizontal bar chart/table of mapped facility count by state plus KPIs for unique facilities, states/DC represented, and zero-result states. Use a full US state list when calculating zero-result states.\n\nrc0de91b002d is context/source material. Use it only for a concise coverage caveat: Wikipedia calls its US zoo list incomplete; OfficialUSA says its broader directory spans all 50 states; AZA reported 240 accredited institutions as of September 2025. These sources have different inclusion rules, so do not blend their counts with the 382 mapped rows.\n\nCritical labeling and caveats: Title the mapped universe “Wikidata zoo locations returned by query,” not “every zoo that exists.” “Nearest” means straight-line/geographic proximity from point coordinates, not driving distance or travel time. Voronoi cells may appear very large where Wikidata has sparse coverage. Wikidata classification can include aquarium-named facilities classified under zoo, and can omit or misplace facilities. The map describes proximity only within this returned dataset. Make the experience accessible, responsive, polished, and visually striking with strong legends and brief methodology.","result_set_ids":["rbdfe7f6beed","rc0de91b002d"],"title":"Nearest Zoo Voronoi Atlas — United States","prev_report_token":null}