Page 1 of 1

Pocket Queries for USA

Posted: Tue Mar 15, 2016 7:46 pm
by fitzet
I was looking to set-up a PQ for the USA for caches published in 2000. USA isn't included in the Country List (within the section labelled "Within"). However, US States are included in the list of States / Provinces.

Anyone know why ?

Re: Pocket Queries for USA

Posted: Tue Mar 15, 2016 10:56 pm
by klossner
That's a strange oversight.

You can select multiple states by using control-left-click. I set up a PQ to select all fifty states and the District of Columbia for the year 2000; the result has 92 caches. (I would send you the resulting GPX file but I was once told in no uncertain terms that doing so is a violation of Groundspeak's terms of service.)

You can save some clicking by selecting only these states, the ones that have year-2000 caches:
Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, Florida, Georgia, Hawaii, Idaho, Illinois, Indiana, Kansas, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Nevada, New Hampshire, New Jersey, New York, North Carolina, Oregon, Pennsylvania, Rhode Island, South Carolina, Texas, Utah, Vermont, Virginia, Washington

Re: Pocket Queries for USA

Posted: Wed Mar 16, 2016 9:24 pm
by fitzet
Thanks
I recall seeing USA listed first, seperate to the full list. And, if this were a bug, that it would have been flagged long before now.

Re: Pocket Queries for USA

Posted: Thu Mar 17, 2016 6:28 pm
by klossner
It's interesting to look at the HTML source for the pocket query page, extract the list of countries, and sort by ID number. This gives an idea of when the countries were added and what's missing.

The first nine countries are Australia, Belgium, Canada, Chile, Ireland, Luxembourg, New Zealand, Sweden, and United Kingdom. These start at ID #3. I speculate that "United States" was once ID #2 and has since been removed. (Perhaps because the database can't handle a query over such a large dataset?)

The next batch of countries runs alphabetically from Afghanistan (#12) to Vietnam (#215). After that comes a hodgepodge of countries, apparently added a few at a time. The most recent are Palestine, Saba, and South Sudan at #278.

Re: Pocket Queries for USA

Posted: Thu Mar 17, 2016 11:54 pm
by klossner
I found a bookmark list for year-2000 caches: https://www.geocaching.com/bookmarks/vi ... 45890a601e

Re: Pocket Queries for USA

Posted: Thu Mar 17, 2016 11:59 pm
by fitzet
That's great, thanks.

I have a list for my blank months in Europe and was looking to see what additional months might be available in California or Nevada. Very little, for my needs, as it turns out.