Made a copy of the existing data from the beta site, in a folder called rc_site (for "release candidate"). I also cloned the db as citystatsDNS (a Star Trek theme), and then did the following to remove the Philadelphia data:

• Deleted the 1970 and 1980 tables for Philadelphia.
• Commented out Philadelphia in the city list from JD's PHP code.
• Gave the appropriate user the appropriate permissions on the new copy of the db.
• Opened my test_query.php page, and uncommented these calls:

    buildIndexes();
    echo buildTractLookupTable();
  

  which call functions from query.php which rebuild some of my ancillary tables, based on the tables, so that Philadelphia data is no longer included. This functionality should be added into the upload.php code, perhaps in such a way that it can be called independently (as you might need to do if you've manually edited the core data tables), and/or is called automatically when upload.php is run. Probably, at the end of upload.php, it should redirect to an appropriate page, which would run these functions; then that page should redirect back again, to show the results of upload.php (which currently needs to be refreshed to show its results).
• Tested and confirmed that Philadelphia no longer shows up in the old query interface, or the new wizard.
• Informed JS-R that the release candidate is in place, so he can test it.

Barring any more bugs, this will probably go live before Christmas.