Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: No
Sort: name
Order: ASC

Pagination:

Current Page: 22
Limit per Page: 25
Offset: 525
Total Pages: 26

Results:

Total Available Records: 645
Total After Limits: 645
Results Loaded: 25

Query:

SELECT p.place_id, COALESCE(NULLIF(e.name, ''), p.name) AS name, IF(e.name IS NOT NULL AND e.name != '', 1, 0) AS has_edit_name, COALESCE(NULLIF(e.address, ''), p.formatted_address) AS formatted_address, IF(e.address IS NOT NULL AND e.address != '', 1, 0) AS has_edit_address, p.lat, p.lng, p.weighted_rating, p.composite_score, p.distance, COALESCE(NULLIF(e.redmond_category, ''), p.redmond_category) AS redmond_category, IF(e.redmond_category IS NOT NULL AND e.redmond_category != '', 1, 0) AS has_edit_redmond_category, COALESCE(NULLIF(e.redmond_search_term, ''), p.redmond_search_term) AS redmond_search_term, IF(e.redmond_search_term IS NOT NULL AND e.redmond_search_term != '', 1, 0) AS has_edit_redmond_search_term, COALESCE(NULLIF(e.types, ''), p.types) AS types, IF(e.types IS NOT NULL AND e.types != '', 1, 0) AS has_edit_types, COALESCE(NULLIF(e.website, ''), p.website) AS website, IF(e.website IS NOT NULL AND e.website != '', 1, 0) AS has_edit_website, COALESCE(NULLIF(e.phone, ''), p.formatted_phone_number) AS formatted_phone_number, IF(e.phone IS NOT NULL AND e.phone != '', 1, 0) AS has_edit_phone, CASE WHEN e.place_id IS NOT NULL THEN 1 ELSE 0 END AS has_edits, e.is_published 
                 FROM wp_redmond_explorer_places p
                 LEFT JOIN wp_redmond_explorer_edits e ON p.place_id = e.place_id
                  WHERE (e.is_published IS NULL OR e.is_published = 1) AND NOT EXISTS (
                SELECT 1 FROM wp_redmond_explorer_edits e2 
                WHERE e2.place_id = p.place_id AND e2.is_published = 0
            ) ORDER BY COALESCE(e.name, p.name) ASC LIMIT 525, 25

Previous Next

Page 22 of 26

Showing 526 to 550 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJH8jLKpLWvlQRon0OlkWRbXg	Smith Rock Climbing Guides	9297 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3606920	-121.1385530	10,189 m		rock climbing	establishment,point_of_interest,school	Page \| Maps \| Website	(541) 788-6225	View Hours Monday: 8:00 AM – 8:00 PM Tuesday: 8:00 AM – 8:00 PM Wednesday: 8:00 AM – 8:00 PM Thursday: 8:00 AM – 8:00 PM Friday: 8:00 AM – 8:00 PM Saturday: 8:00 AM – 8:00 PM Sunday: 8:00 AM – 8:00 PM	View Photos (4)
ChIJOYjHWdAqv1QRZbzXuJ6MdlU	Smith Rock Coffee Roasters	Redmond, OR 97756, USA	44.2726660	-121.1739210	5 m		coffee shops	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 699-1964		View Photos (4)
ChIJeQE_c5kqv1QRNvA6yP2rCdE	Smith Rock Golf Course & Driving Range	1401 NE Maple Ave, Redmond, OR 97756, USA	44.2925930	-121.1515710	2,846 m		driving range	establishment,point_of_interest	Page \| Maps	(541) 923-3426		View Photos (4)
ChIJHcjLKpLWvlQRl17g5s7mOGQ	Smith Rock State Park	CROOKED RIVER, OR 97760, USA	44.3682460	-121.1405810	10,959 m	outdoors	point of interest, point of interest, rock climbing, state parks, state parks,hiking,mountain biking,rock climbing, tourist attraction	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(800) 551-6949		View Photos (4)
ChIJQUyFQFPXvlQR-LS_xFdfMqM	Smith Rock State Park Welcome Center	CROOKED RIVER, OR 97760, USA	44.3658890	-121.1373730	10,771 m		state parks	establishment,point_of_interest,travel_agency	Page \| Maps \| Website		View Hours Monday: 8:00 AM – 1:00 AM Tuesday: Closed Wednesday: 8:00 AM – 1:00 AM Thursday: 8:00 AM – 1:00 PM Friday: 8:00 AM – 4:00 PM Saturday: 8:00 AM – 4:00 PM Sunday: 8:00 AM – 4:00 PM	View Photos (4)
ChIJmwluEQbZvlQRj1kzGEwsj7k	Smith Rock Trail Rides	20890a NW Butler Rd, Terrebonne, OR 97760, USA	44.3615150	-121.1148880	10,944 m		horseback rides	establishment,point_of_interest,travel_agency	Page \| Maps \| Website	(541) 604-6769	View Hours Monday: 7:00 AM – 7:00 PM Tuesday: 7:00 AM – 7:00 PM Wednesday: 7:00 AM – 7:00 PM Thursday: 7:00 AM – 7:00 PM Friday: 7:00 AM – 7:00 PM Saturday: 7:00 AM – 7:00 PM Sunday: 9:00 AM – 7:00 PM	View Photos (4)
ChIJq4LmROkqv1QRlXojK1yuw7w	Sno-Cap Drive In Redmond	1053 NW 6th St, Redmond, OR 97756, USA	44.2863570	-121.1743480	1,528 m		bars, bars,pubs,desserts,family friendly, desserts, food trucks, lunch, pubs, restaurants	establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 548-2343	View Hours Monday: 11:00 AM – 9:00 PM Tuesday: 11:00 AM – 9:00 PM Wednesday: 11:00 AM – 9:00 PM Thursday: 11:00 AM – 9:00 PM Friday: 11:00 AM – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJa_YtIysrv1QR9MS6eYVxv8I	Society of Saint Vincent de Paul Redmond – Food Distribution Center	651 SW Veterans Way, Redmond, OR 97756, USA	44.2631000	-121.1750180	1,062 m		thrift stores	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 923-5264	View Hours Monday: Closed Tuesday: 10:00 AM – 6:00 PM Wednesday: 10:00 AM – 1:30 PM Thursday: 10:00 AM – 1:30 PM Friday: Closed Saturday: Closed Sunday: Closed	No photos available
ChIJsWHRMI0qv1QRDAg2Iqp7fW8	Sonic Drive-In	500 NW Oak tree Ln, Redmond, OR 97756, USA	44.2942140	-121.1732090	2,402 m		bars	establishment,food,meal_takeaway,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 526-5855	View Hours Monday: 7:00 AM – 11:00 PM Tuesday: 7:00 AM – 11:00 PM Wednesday: 7:00 AM – 11:00 PM Thursday: 7:00 AM – 11:00 PM Friday: 7:00 AM – 12:00 AM Saturday: 8:00 AM – 12:00 AM Sunday: 8:00 AM – 11:00 PM	View Photos (4)
ChIJwR4Q3HXVuFQR3Z8mr4Xu-zA	Sora Sushi	3853 SW 21st St Ste 109, Redmond, OR 97756, USA	44.2404830	-121.1939890	3,915 m		bars, bars,pubs, pubs, restaurants	establishment,food,meal_takeaway,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-9867	View Hours Monday: 11:00 AM – 9:00 PM Tuesday: Closed Wednesday: 11:00 AM – 9:00 PM Thursday: 11:00 AM – 9:00 PM Friday: 11:00 AM – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJ-T9KAozVuFQRAHURKAbiIR4	SOUTH SISTER	3800 SE Airport Way, Redmond, OR 97756, USA	44.2373240	-121.1853160	4,028 m		event venues	establishment,point_of_interest	Page \| Maps			No photos available
ChIJjc6HNScrv1QRO2xbroQsfac	Spudbowl City Park	SW 15th St @, SW Black Butte Blvd, Redmond, OR 97756, USA	44.2752840	-121.1833910	810 m		parks, parks,playgrounds,rock climbing, playgrounds	establishment,park,point_of_interest	Page \| Maps		View Hours Monday: 6:30 AM – 9:00 PM Tuesday: 6:30 AM – 9:00 PM Wednesday: 6:30 AM – 9:00 PM Thursday: 6:30 AM – 9:00 PM Friday: 6:30 AM – 9:00 PM Saturday: 6:30 AM – 9:00 PM Sunday: 6:30 AM – 9:00 PM	View Photos (4)
ChIJm3h5Lysrv1QRPI5Q-Q6IvmU	St. Vincent De Paul Thrift Store	651 SW Veterans Way, Redmond, OR 97756, USA	44.2631000	-121.1750180	1,062 m		antiques,thrift stores, shopping, thrift stores	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 504-9840	View Hours Monday: 9:00 AM – 6:00 PM Tuesday: 9:00 AM – 6:00 PM Wednesday: 9:00 AM – 6:00 PM Thursday: 9:00 AM – 6:00 PM Friday: 9:00 AM – 6:00 PM Saturday: 9:00 AM – 6:00 PM Sunday: Closed	View Photos (4)
ChIJvXiWadArv1QRfMl_xU_ABxM	Stable Inn & Mountain View POA’s	3099 NW Williams Way, Redmond, OR 97756, USA	44.3270550	-121.2040260	6,510 m		horseback rides	establishment,point_of_interest,tourist_attraction,travel_agency	Page \| Maps \| Website	(541) 419-6445	View Hours Monday: 9:00 AM – 5:00 PM Tuesday: 9:00 AM – 5:00 PM Wednesday: 9:00 AM – 5:00 PM Thursday: 9:00 AM – 5:00 PM Friday: 9:00 AM – 5:00 PM Saturday: 9:00 AM – 5:00 PM Sunday: 9:00 AM – 5:00 PM	View Photos (4)
ChIJkYRUxO4qv1QRtBbjiXCA4vk	Stack Park	820 NW Kingwood Pl, Redmond, OR 97756, USA	44.2871550	-121.1770800	1,636 m		parks, parks,playgrounds,hiking, playgrounds, state parks	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 548-7275	View Hours Monday: 8:00 AM – 6:00 PM Tuesday: 8:00 AM – 6:00 PM Wednesday: 8:00 AM – 6:00 PM Thursday: 8:00 AM – 6:00 PM Friday: 8:00 AM – 6:00 PM Saturday: 8:00 AM – 6:00 PM Sunday: 8:00 AM – 6:00 PM	View Photos (4)
ChIJC1sVINYqv1QRSsXG481xViY	Starbucks (edited)	944 SW 9th St, Redmond, OR 97756, USA (edited)	44.2677300	-121.1761600	572 m	coffee-treats (edited)	breakfast, coffee shops (edited)	cafe,store,food,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 504-5100	View Hours Monday: 7:00 AM – 7:00 PM Tuesday: 7:00 AM – 7:00 PM Wednesday: 7:00 AM – 7:00 PM Thursday: 7:00 AM – 7:00 PM Friday: 7:00 AM – 7:00 PM Saturday: 7:00 AM – 7:00 PM Sunday: 7:00 AM – 7:00 PM	View Photos (4)
ChIJo91SskXSuFQRPh7s9eU3-8Q	Starbucks (edited)	1705 The Dalles-California Hwy, S Hwy 97, Redmond, OR 97756, USA (edited)	44.2607500	-121.1795400	1,394 m	coffee-treats (edited)	breakfast, coffee shops (edited)	cafe,food,point_of_interest,store,establishment (edited)	Page \| Maps \| Website (edited)	(541) 504-4160	View Hours Monday: 6:00 AM – 6:00 PM Tuesday: 6:00 AM – 6:00 PM Wednesday: 6:00 AM – 6:00 PM Thursday: 6:00 AM – 6:00 PM Friday: 6:00 AM – 6:00 PM Saturday: 6:00 AM – 6:00 PM Sunday: 6:00 AM – 6:00 PM	View Photos (3)
ChIJkQoHICUrv1QR7JDaRE-upUA	Starbucks Coffee Company	885 SW Rimrock Way, Redmond, OR 97756, USA	44.2689400	-121.1927900	1,557 m		breakfast, coffee shops, shopping	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 548-9679	View Hours Monday: 4:30 AM – 9:00 PM Tuesday: 4:30 AM – 9:00 PM Wednesday: 4:30 AM – 9:00 PM Thursday: 4:30 AM – 9:00 PM Friday: 4:30 AM – 9:00 PM Saturday: 5:00 AM – 9:00 PM Sunday: 5:00 AM – 9:00 PM	View Photos (4)
ChIJO-hUAJUrv1QRm6xAjtwZWXo	Starbucks Coffee Company	1830 NW 6th St, Redmond, OR 97756, USA	44.2936000	-121.1734000	2,333 m		breakfast, coffee shops	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(689) 800-7044	View Hours Monday: 4:30 AM – 9:00 PM Tuesday: 4:30 AM – 9:00 PM Wednesday: 4:30 AM – 9:00 PM Thursday: 4:30 AM – 9:00 PM Friday: 4:30 AM – 9:00 PM Saturday: 5:00 AM – 9:00 PM Sunday: 5:00 AM – 9:00 PM	View Photos (4)
ChIJt2IOuSsrv1QRX1uuuvYxrCw	Starbucks Coffee Company	1400 SW Canal Blvd, Redmond, OR 97756, USA	44.2637100	-121.1776900	1,035 m		breakfast, coffee shops	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 923-4188	View Hours Monday: 4:30 AM – 9:00 PM Tuesday: 4:30 AM – 9:00 PM Wednesday: 4:30 AM – 9:00 PM Thursday: 4:30 AM – 9:00 PM Friday: 4:30 AM – 9:00 PM Saturday: 4:30 AM – 9:00 PM Sunday: 4:30 AM – 9:00 PM	View Photos (4)
ChIJi_uRyIknv1QR0FuGWUeeQGY	Steelhead Falls	Deschutes River, Oregon, Terrebonne, OR 97760, USA	44.4164590	-121.2898970	18,463 m	outdoors	point of interest	establishment,park,point_of_interest	Page \| Maps		View Hours Monday: 6:00 AM – 10:00 PM Tuesday: 6:00 AM – 10:00 PM Wednesday: 6:00 AM – 10:00 PM Thursday: 6:00 AM – 10:00 PM Friday: 6:00 AM – 10:00 PM Saturday: 6:00 AM – 10:00 PM Sunday: 6:00 AM – 10:00 PM	View Photos (4)
ChIJz1FQEAAnv1QRMk5rk-fi1Cc	Steelhead Falls Trail	Steelhead falls, SW River Rd, Terrebonne, OR 97760, USA	44.4110400	-121.2921890	18,038 m		trailheads	establishment,point_of_interest	Page \| Maps			No photos available
ChIJ7xpR6j4rv1QRsRiGAabBjGU	Steep Teahouse and Gifts	307 NW 7th St, Redmond, OR 97756, USA	44.2785330	-121.1756440	672 m		desserts,gift shops,vintage	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 508-1286	View Hours Monday: Closed Tuesday: 10:00 AM – 4:00 PM Wednesday: 10:00 AM – 4:00 PM Thursday: 10:00 AM – 4:00 PM Friday: 10:00 AM – 4:00 PM Saturday: 10:00 AM – 3:00 PM Sunday: Closed	View Photos (4)
ChIJ79s0CZ8muVQR5Dc2mXeiD8E	Stillwater Campground	Stillwater Campground Rd, Prineville, OR 97754, USA	44.1450790	-120.8292970	30,913 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 416-6700	View Hours Monday: Open 24 hours Tuesday: Open 24 hours Wednesday: Open 24 hours Thursday: Open 24 hours Friday: Open 24 hours Saturday: Open 24 hours Sunday: Open 24 hours	View Photos (4)
ChIJ0eHyjnYrv1QRAJfslpXkNpc	Stoop Waffle at Pangaea Guild Hall	652 SW 6th St Unit 2, Redmond, OR 97756, USA	44.2707640	-121.1739930	207 m		restaurants,breakfast,lunch,family friendly	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 526-7641	View Hours Monday: Closed Tuesday: 9:00 AM – 5:00 PM Wednesday: 9:00 AM – 5:00 PM Thursday: 9:00 AM – 5:00 PM Friday: 9:00 AM – 5:00 PM Saturday: 9:00 AM – 5:00 PM Sunday: 9:00 AM – 5:00 PM	View Photos (4)