Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: Yes
Sort: lng
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 p.lng 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	Phone	Hours	Photos
ChIJR0c4XE0NkFQRxiiq5S8cB40	Redmond Library	15990 NE 85th St, Redmond, WA 98052, USA	47.6789090	-122.1280780	385,863 m	family-friendly	library	establishment,library,point_of_interest	Page \| Maps \| Website	(425) 885-1861	View Hours Monday: 10:00 AM – 6:00 PM Tuesday: 12:00 – 8:00 PM Wednesday: 12:00 – 8:00 PM Thursday: 10:00 AM – 6:00 PM Friday: 10:00 AM – 6:00 PM Saturday: 11:00 AM – 6:00 PM Sunday: 11:00 AM – 6:00 PM	View Photos (4)
ChIJebCqymldv1QR2ivpC1qxzWI	Tamolitch Falls (Blue Pool)	National Forest Road 2672-655, McKenzie Bridge, OR 97413, USA	44.3120370	-122.0270490	68,043 m	outdoors	point-of-interest	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 822-3381	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)
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)
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)
ChIJnX2OP0w3v1QRa6S6FFt3zCg	Hoodoo Ski Area	27400 Big Lake Road, Sisters, OR 97759, USA	44.4086440	-121.8714160	57,494 m	outdoors	skiing	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 822-3799	View Hours Monday: Closed Tuesday: Closed Wednesday: 9:00 AM – 9:00 PM Thursday: 9:00 AM – 9:00 PM Friday: 9:00 AM – 9:00 PM Saturday: 9:00 AM – 9:00 PM Sunday: 9:00 AM – 4:00 PM	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
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)
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)
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)
ChIJJ0TZvdNLv1QRZgNE0WppWpc	Chush Falls Trailhead	Blue River, OR 97413, USA	44.1774230	-121.6667700	40,673 m		hiking	establishment,park,point_of_interest	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)
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)
ChIJ41tFB4kXv1QRiVae7AA9LZg	Riverside Campground	12500 SW River Rd, Camp Sherman, OR 97730, USA	44.4414740	-121.6335990	41,087 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website			View Photos (3)
ChIJ6cUIobY5v1QRyxfG8DOpTZQ	Cold Spring Campground	McKenzie Hwy, Sisters, OR 97759, USA	44.3091480	-121.6305030	36,567 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 338-7869		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)
ChIJ-ZJJxf01v1QRtP4XTV7EPjI	Three Creek Lake Campground	NF-16, Sisters, OR 97759, USA	44.0969420	-121.6238110	40,847 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 383-5300		View Photos (4)
ChIJbZz3G-87v1QReu-cFiQyh0Q	Indian ford campground	Indian Ford Rd, Sisters, OR 97759, USA	44.3587800	-121.6105130	36,032 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(877) 444-6777		View Photos (3)
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)
ChIJf77LbKmxuFQRwbXLms9PoIM	Tumalo Falls Viewpoint	Tumalo Falls, OR 97703, USA	44.0335870	-121.5668450	41,099 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website			View Photos (4)
ChIJ872DeEWxuFQRZrbIFmucvng	Farewell Trail	Oregon 97703, USA	44.0385810	-121.5646660	40,607 m		mountain biking	establishment,gym,health,point_of_interest	Page \| Maps \| Website		View Hours Monday: 5:30 AM – 8:00 PM Tuesday: 5:30 AM – 8:00 PM Wednesday: 5:30 AM – 8:00 PM Thursday: 5:30 AM – 8:00 PM Friday: 5:30 AM – 8:00 PM Saturday: 7:00 AM – 7:00 PM Sunday: 7:00 AM – 7:00 PM	View Photos (2)
ChIJRRDliMswv1QRRSCxZesqb20	Sisters Creekside Campground	504 S Locust St, Sisters, OR 97759, USA	44.2876610	-121.5437420	29,488 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 588-0445		View Photos (4)
ChIJvWZuOTC9uFQRjRJuzpU0XFc	Oregon Observatory at Sunriver Nature Center & Observatory	57245 River Rd, Sunriver, OR 97707, USA	43.8852940	-121.4477870	48,306 m	outdoors	hiking, point-of-interest	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 593-4394	View Hours Monday: Closed Tuesday: Closed Wednesday: 10:00 AM – 3:00 PM, 7:00 – 8:30 PM Thursday: 10:00 AM – 3:00 PM Friday: 10:00 AM – 3:00 PM Saturday: 10:00 AM – 3:00 PM, 7:00 – 8:30 PM Sunday: 10:00 AM – 3:00 PM	View Photos (4)
ChIJQ53B0SfivlQRCroFzC_DOeA	Perry South Campground	Montgomery Rd, Culver, OR 97734, USA	44.5848450	-121.4475810	40,958 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(877) 444-6777		View Photos (4)
ChIJV4DGzCzhvlQRWUHAt7S5hxQ	Oregon HooDoos Trailhead	Montgomery Rd, Culver, OR 97734, USA	44.5752500	-121.4234860	39,053 m		hiking	establishment,park,point_of_interest	Page \| Maps	(208) 369-7822		View Photos (4)
ChIJSxInVMsnv1QRQeWs3XKUMNY	Alder Springs Trailhead	CROOKED RIVER, OR 97760, USA	44.4332760	-121.3577690	23,083 m		hiking	establishment,park,point_of_interest	Page \| Maps \| Website			View Photos (4)