Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: Yes
Sort: formatted_phone_number
Order: ASC

Pagination:

Current Page: 1
Limit per Page: 25
Offset: 0
Total Pages: 24

Results:

Total Available Records: 583
Total After Limits: 583
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 1=1 ORDER BY COALESCE(e.phone, p.formatted_phone_number) ASC LIMIT 0, 25

Page 1 of 24

Showing 1 to 25 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Hours	Photos
ChIJacNUik48v1QRogv1QRP2AXs	Black Butte	Black Butte, Oregon 97730, USA	44.3995610	-121.6344960	39,256 m	outdoors	hiking, point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJ3cb8CDLAuFQRdWzBCK6gLGY	Boyd Cave	Bend, OR 97702, USA	43.9422140	-121.1983280	36,791 m	outdoors	hiking, point-of-interest	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website	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)
ChIJOdxKoGzbvlQRFakpdx8wuMU	Haystack Reservoir	Haystack Reservoir, Oregon 97734, USA	44.4943170	-121.1481090	24,737 m	outdoors	hiking, point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJ2Z5ETSGvuFQRBJrDIKwKQi4	Mount Bachelor	Mount Bachelor, Oregon 97703, USA	43.9791670	-121.6886110	52,463 m	outdoors	hiking, point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJo3Pt7_IVv1QRGvAy6B6lC78	Suttle Lake	Suttle Lake, Oregon 97759, USA	44.4250720	-121.7329210	47,572 m	outdoors	hiking, point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJNX5fYxSzuFQRM0FghCexq_o	Three Creek Lake	Three Creek Lake, Oregon 97703, USA	44.0990330	-121.6272880	40,980 m	outdoors	hiking, point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJP81I0g6xuFQRDzFmHl2j-yU	Tumalo Falls	Tumalo Falls, Oregon 97703, USA	44.0339560	-121.5668790	41,074 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJsaeU5yRYx1QRsk9oajNEs-8	Cascade Lakes	Cascade Lakes, Oregon 97413, USA	43.9000000	-121.8000000	64,940 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps		No photos available
ChIJs9KxmVNov1QRuP5g446ZuzU	Clear Lake	Clear Lake, Oregon 97759, USA	44.3686930	-121.9943910	66,139 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJWUtgagQPx1QRh17ukFOxTC8	Crescent Lake	Crescent Lake, Oregon 97733, USA	43.4747940	-121.9854810	110,008 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (3)
ChIJBZpxAVUcvlQR6qmut8B2HYM	Mount Hood	Mt Hood, Oregon 97041, USA	45.3736150	-121.6959510	129,162 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJZf5BqxwFvFQRWHHAosT_saE	Painted Hills	Painted Hills, Oregon 97750, USA	44.6615220	-120.2730730	83,548 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJ1VfCqzePuFQRm_qLJANFiLU	Paulina Lake Hot Spring	Little Crater Campground, La Pine, OR 97739, USA	43.7320950	-121.2523330	60,430 m	outdoors	point-of-interest	establishment,point_of_interest,tourist_attraction	Page \| Maps		View Photos (4)
ChIJ_-zwLdBQv1QRYNW5J1HOkrk	Proxy Falls	Proxy Falls, Oregon 97413, USA	44.1617860	-121.9278260	61,332 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJlyhXsl9MuVQRw4aTaK_aW3E	White Fir Spring	White Fir Spring, Oregon 97754, USA	44.4045760	-120.5533500	51,488 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (1)
ChIJ9Wl0voQsv1QRe6Z3VAlhkkc	Cline Falls State Park	7012 McKenzie Hwy, Redmond, OR 97756, USA	44.2686620	-121.2561080	6,559 m	outdoors	point-of-interest, state parks	establishment,parking,point_of_interest	Page \| Maps		View Photos (4)
ChIJPWUNQyUrv1QRdpIVQnbQzxs	Dry Canyon Park & Trail System	Unnamed Road, Redmond, OR 97756, USA	44.3022990	-121.1902760	3,548 m	outdoors	hiking, mountain biking, point-of-interest	establishment,park,point_of_interest	Page \| Maps	View Hours Monday: 6:00 AM – 9:30 PM Tuesday: 6:00 AM – 9:30 PM Wednesday: 6:00 AM – 9:30 PM Thursday: 6:00 AM – 9:30 PM Friday: 6:00 AM – 9:30 PM Saturday: 6:00 AM – 9:30 PM Sunday: 6:00 AM – 9:30 PM	View Photos (4)
ChIJ2duG4fEqv1QRuOdOz8cwD8I	Paul Hathaway Memorial Park	1021 NW Rockcrest Ct, Redmond, OR 97756, USA	44.2906730	-121.1800210	2,065 m	outdoors	parks, point-of-interest	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: 7:00 AM – 9:30 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)
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)
ChIJt7CAXJ4qv1QRmWDMsvLPYCk	The Radlands	1859 NE Maple Ave, Redmond, OR 97756, USA	44.2919890	-121.1461790	3,085 m	outdoors	mountain biking, point-of-interest	establishment,point_of_interest	Page \| Maps	View Hours Monday: 6:00 AM – 7:30 PM Tuesday: 6:00 AM – 7:30 PM Wednesday: 6:00 AM – 7:30 PM Thursday: 6:00 AM – 7:30 PM Friday: 6:00 AM – 7:30 PM Saturday: 6:00 AM – 7:30 PM Sunday: 6:00 AM – 7:30 PM	View Photos (4)
ChIJ-49RKeHdvlQRchgSVuOkk-k	Culver water park	Culver, OR 97734, USA	44.5241230	-121.2078900	28,096 m		tourist attraction	tourist_attraction,point_of_interest,establishment	Page \| Maps		View Photos (1)
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
ChIJ0bDcnyQrv1QRMLBMPuAVSVs	Highland Grub and Go	1501 SW Highland Ave, Redmond, OR 97756, USA	44.2697810	-121.1853190	961 m		food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps	View Hours Monday: 5:00 AM – 8:00 PM Tuesday: 5:00 AM – 8:00 PM Wednesday: 5:00 AM – 8:00 PM Thursday: 5:00 AM – 8:00 PM Friday: 5:00 AM – 8:00 PM Saturday: 6:00 AM – 9:00 PM Sunday: 6:00 AM – 8:00 PM	View Photos (4)
ChIJ1_-hR9oqv1QRKuTyO-w_f94	Food Fellas	332 SW 5th St, Redmond, OR 97756, USA	44.2737650	-121.1728670	152 m		brewery, food trucks, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps	View Hours Monday: 11:30 AM – 9:00 PM Tuesday: Closed Wednesday: Closed Thursday: 11:30 AM – 9:00 PM Friday: 11:30 AM – 9:00 PM Saturday: 11:30 AM – 9:00 PM Sunday: 11:30 AM – 9:00 PM	View Photos (4)
ChIJ2-PcF58rv1QRcnwAfnTwveY	The Burger Cart	845 SW 17th St, Redmond, OR 97756, USA	44.2690320	-121.1876970	1,167 m		dining, food trucks	restaurant,food,point_of_interest,establishment	Page \| Maps	View Hours Monday: Closed Tuesday: 11:30 AM – 8:00 PM Wednesday: 11:30 AM – 8:00 PM Thursday: 11:30 AM – 8:00 PM Friday: 11:30 AM – 8:00 PM Saturday: 11:30 AM – 8:00 PM Sunday: 11:30 AM – 7:00 PM	View Photos (4)