Public Fountain Locations
889 US public fountain businesses, from national chains to single independent shops, with address, phone, website and map coordinates.
Buy the whole list — 889 rows · $4.91
Or ask for the part you need: an area, a distance, a condition. Counts and previews are free, and each answer shows its exact price.
Sample data
| name | address | city | state | zip | phone | website | overture id | brand | brand id | wikidata | category | category path | basic category | social | operating status | confidence | source dataset | source record id | source ids | source updated | data license | location type | location type confidence | location type basis | latitude | longitude | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| State Seal Spring Water | 108 Avenue of the Pnes | Saratoga Springs | NY | 12866-6220 | https://www.saratoga.com | ded87eb4-788b-4c7e-9286-9d6d71e38d1b | drinking_fountain | |community_and_government|public_facility|public_fountain|drinking_fountain| | public_fountain | open | 0.65 | BrightQuery | 103834110 | BrightQuery:103834110 | 2026-08-13 | Overture Maps Foundation, CDLA-Permissive-2.0 | unknown | name: no premises word; website: none in its path; category: drinking_fountain names a business, not premises | 43.056652 | -73.805687 | |||||||
| Walt & Mickey Statue, Main St, Disneyland | Anaheim | CA | http://disneyland.disney.go.com/ | 79ed2079-bbb8-48b4-a98a-da69265b74e8 | public_fountain | |community_and_government|public_facility|public_fountain| | public_fountain | https://www.facebook.com/1498651500424135 | 0.723 | meta | 1498651500424135 | meta:1498651500424135 | 2026-08-10 | Overture Maps Foundation, CDLA-Permissive-2.0 | unknown | name: no premises word; website: none in its path; category: public_fountain names a business, not premises | 33.812069 | -117.919022 | |||||||||
| Etowah River | Rome | GA | b89af166-010c-452d-9b96-263c3e423a2d | public_fountain | |community_and_government|public_facility|public_fountain| | public_fountain | https://www.facebook.com/125542097488707 | open | 0.733 | meta | 125542097488707 | meta:125542097488707|Overture-signals:a7184d82-2dcb-4270-ad20-dfbcd7b0820c | 2026-08-10 | Overture Maps Foundation, CDLA-Permissive-2.0 | unknown | name: no premises word; website: blank; category: public_fountain names a business, not premises | 34.253891 | -85.17667 |
What's in each row
| Field | What it is |
|---|---|
| overture_ | Map data id for the place, stable across monthly releases |
| name | Business name |
| brand | Brand or chain name, when the place belongs to one |
| brand_ | Our id for that brand (its Wikidata id where one exists) |
| wikidata | Wikidata id of the brand |
| category | Kind of place, from the map data |
| category_ | The category with every broader category above it |
| basic_ | A broader, simpler category |
| address | Street address |
| city | City |
| state | State (two-letter code) |
| zip | ZIP code |
| phone | Phone number |
| website | Website |
| Email address | |
| social | Social media page |
| latitude | Latitude |
| longitude | Longitude |
| operating_ | Whether the place is open, where the source says; closed places are left out of the list |
| confidence | How sure the map data is that the place exists (0 to 1) |
| source_ | Which source contributed the record |
| source_ | The record's id in that source |
| source_ | Every source record merged into this row |
| source_ | When the source last updated the record |
| data_ | The license the row is published under |
| location_ | Kind of premises: store, office, branch, warehouse and so on, read from the name, website and category |
| location_ | How sure the location type is (0 to 1) |
| location_ | What the location type was read from |
Source & license
Open map data from the Overture Maps Foundation, release of August 2026, refreshed monthly. Closed and low-confidence places are removed and duplicates within 50 meters merged. Contains data from Overture Maps Foundation (https://overturemaps.org), Places theme, licensed CDLA-Permissive-2.0 (https://cdla.dev/permissive-2-0/); some sources are Apache-2.0. See https://docs.overturemaps.org/attribution/.
Using ChatGPT, Claude or an API?
Ask this list a question with a link
Using ChatGPT or Claude? Tell it to answer from locationlists.com/find — no account, no connector.
How assistants ask
No connector needed. Any AI assistant can answer from this site with a web link, no connector, no account: open https://locationlists.com/find with the question as query parameters.
If a question needs filtering, distance, drive time, combining lists or a price, open a /find link: either put the question itself in q=, or build the structured link. The answer does not need an API, a connector or an account.
Simplest, the question itself: https://locationlists.com/find?q=<the question in plain words>
Or set the parts yourself: https://locationlists.com/find?dataset=<slug>&state=<ST>&city=<city>&county=<county>&zip=<zip>&near=<place or zip>&radius=<miles>&drive=<minutes>&where=<column>:<op>:<value>&total=<rows>
Leave out what the question does not need. Use radius for straight-line miles or drive for minutes of driving (5 to 60), not both; near can name several places separated by | to reach from any of them. To ask about several lists at once, use datasets with two or more names, or category with a kind of business. To compare two lists, add relate=nearest and the other list with b. in front of its parameters. To count by area, use areas=county (or zip, state, metro). To keep only places whose county, ZIP code, metro area or state meets a Census figure, add area_where (for example county:population>1000000); with areas, per=100000 gives counts per 100,000 residents.
Open one of these to see how many places match, a few preview rows and the price for just those rows:
- The whole list: add a city, state, ZIP code or distance:
https://locationlists.com/find?dataset=public-fountain-locations
Ask in ChatGPT or Claude
Copy this and paste it in:
Every answer shows its exact price before you pay, by card, no account; the whole list is $4.91. Counts, previews and comparisons with other lists are free.
For developers
Dataset slug public-fountain-locations. Machine-readable record: dataset.json. Without a connector, every one of these answers comes from a link: https://locationlists.com/find?dataset=public-fountain-locations. Works in every MCP tool and the x402 query API like any other dataset (count_locations, get_sample, query_locations, relate_locations, count_by_area, cotenancy).