Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: Yes
Sort: lat
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.lat 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
ChIJnzjFzwt1uFQR86h1XRnR7Ow	Fort Rock State Natural Area	Co Road 5-11A, Fort Rock, OR 97735, USA	43.3729120	-121.0661830	100,416 m	outdoors	point-of-interest	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(800) 551-6949		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)
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)
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)
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
ChIJn0EJ6w-RuFQRiuPCpdLD-YA	Newberry National Volcanic Monument	Bend, OR 97702, USA	43.9098550	-121.3568950	42,903 m	outdoors	hiking, point-of-interest	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 383-5300	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)
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)
ChIJmbBM85_duFQR8DqG6fWxp70	Oregon Badlands Wilderness	Oregon Badlands Wilderness, Bend, OR 97701, USA	43.9571920	-121.0481800	36,482 m	outdoors	hiking, point-of-interest	establishment,park,point_of_interest,tourist_attraction	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)
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)
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)
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)
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)
ChIJIy3nywTGuFQRnE_rjHPpr8U	Pilot Butte	Pilot Butte, Bend, OR 97701, USA	44.0606730	-121.2833640	25,132 m	outdoors (edited)	point of interest (edited)	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)
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)
ChIJSbrw9PrJuFQR2hiNzKwfcU8	Historic Old Cabin Ruins	Deschutes County, OR 97703, USA	44.1033890	-121.3393840	22,982 m		historic landmarks	establishment,point_of_interest	Page \| Maps			View Photos (4)
ChIJ9csSlychuVQRhXmYz4C4QRc	Poison Butte Campground	OR-27, Prineville, OR 97754, USA	44.1204050	-120.7982720	34,399 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)
ChIJjbYtQ6fOuFQRZYlEbF4DpH8	Tumalo State Park	Oregon 97703, USA	44.1284080	-121.3307740	20,334 m	outdoors	hiking, point-of-interest, state parks	establishment,park,point_of_interest	Page \| Maps \| Website	(800) 551-6949	View Hours Monday: 8:00 AM – 5:00 PM Tuesday: 8:00 AM – 5:00 PM Wednesday: 8:00 AM – 5:00 PM Thursday: 8:00 AM – 5:00 PM Friday: 8:00 AM – 5:00 PM Saturday: 8:00 AM – 5:00 PM Sunday: 8:00 AM – 5:00 PM	View Photos (4)
ChIJ94Uf_qXOuFQRG1RDdaNdVmI	Tumalo State Park Campground	64185 O. B. Riley Rd, Tumalo, OR 97703, USA	44.1289110	-121.3310380	20,303 m		campgrounds, state parks	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 388-6055		View Photos (4)
ChIJMwqh-f4juVQRppulN5J4yqQ	Post Pile Campground	OR-27, Prineville, OR 97754, USA	44.1289380	-120.8005150	33,783 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)
ChIJwdyeMqsmuVQR6O0horlcM9k	Cobble Rock Campground	Crooked River Hwy, Prineville, OR 97754, USA	44.1289460	-120.8106000	33,076 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)
ChIJQb3g8rcmuVQRYSJ9Dv2rX-Q	Lone Pine Campground	OR-27, Prineville, OR 97754, USA	44.1296040	-120.8369880	31,214 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)
ChIJYbd4bq4muVQRx-ZgTg9MOv8	Palisades Campground	Palisades Campground, Crooked River Hwy, Prineville, OR 97754, USA	44.1315820	-120.8221660	32,127 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)
ChIJxQLW4qcmuVQR21i6am9TyU8	Chimney Rock Campground	Chimney Rock Campground, Crooked River Hwy, Prineville, OR 97754, USA	44.1375110	-120.8162650	32,225 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 416-6700		View Photos (4)
ChIJgUThwhnMuFQR6cfTBOP0Ess	Fly Spur Ranch	64460 Research Rd, Tumalo, OR 97703, USA	44.1410890	-121.3366310	19,548 m		horseback rides	establishment,point_of_interest,travel_agency	Page \| Maps \| Website	(541) 389-4995	View Hours Monday: Closed 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 – 7:00 PM Sunday: 8:00 AM – 5:00 PM	View Photos (4)