Results 1 to 9 of 9

Thread: Draw Data Mining

  1. #1
    Member L. G.'s Avatar
    Join Date
    Oct 2007
    Location
    N'ern S.E. AK
    Posts
    838

    Default Draw Data Mining

    So, ADF&G released the draw results in a PDF.

    I've been trying to export the data to that it can be sorted by City or by Hunt No (column fields).

    I first exported the PDF file to and txt file. This was good as the data is space delimited.

    Then I copied and pasted the text to an Excel file. This is were problems arose. ADF&G didn't think out their fields very well. Cities with two names and a few other fields get messed up - data gets bumped over one column. I don't feel like manually editing 137 pages of data.

    Anyone found a way to skin this cat?
    Last edited by L. G.; 04-21-2010 at 11:17. Reason: . . .

  2. #2
    Forum Admin Brian M's Avatar
    Join Date
    Sep 2005
    Location
    Eagle River, AK
    Posts
    13,396

    Default

    Someone has. There was a thread in here last week about draw results by city/town of residence. Scroll over to page #2 or 3 and you should find it.

  3. #3
    Supporting Member sigabrt's Avatar
    Join Date
    Aug 2009
    Location
    Southcentral
    Posts
    174

    Default In a Database

    I have it in a sqlite3 database - not excel.

  4. #4
    Member
    Join Date
    Nov 2007
    Location
    Juneau
    Posts
    459

    Default

    Close enough. Lots of data entry errors by winners, but this is it roughly...Change the .txt extension to .xls
    Attached Files Attached Files

  5. #5
    Member 379 Peterbilt's Avatar
    Join Date
    Apr 2006
    Location
    Alcan Highway
    Posts
    202

    Default

    In all past years results, all winners were listed with a STREET ADDRESS (including name/city/state/zip) This year I can't find a a way to look up any hunts that lists the winners' STREET ADDRESS.

    Anyone here figgured this out or have the secret link?

  6. #6

    Default

    Quote Originally Posted by 379 Peterbilt View Post
    In all past years results, all winners were listed with a STREET ADDRESS (including name/city/state/zip) This year I can't find a a way to look up any hunts that lists the winners' STREET ADDRESS.

    Anyone here figgured this out or have the secret link?
    This is the very reason I apply with my P.O. Box.

  7. #7
    Moderator hunt_ak's Avatar
    Join Date
    Mar 2007
    Location
    Wasilla--Cantwell Transplant
    Posts
    4,600

    Default

    Quote Originally Posted by Alaska_Lanche View Post
    This is the very reason I apply with my P.O. Box.
    With your double-layered tinfoil hat?

  8. #8

    Default

    Quote Originally Posted by hunt_ak View Post
    With your double-layered tinfoil hat?
    Only a double???

  9. #9
    Member L. G.'s Avatar
    Join Date
    Oct 2007
    Location
    N'ern S.E. AK
    Posts
    838

    Default

    Quote Originally Posted by Dr.No View Post
    Close enough. Lots of data entry errors by winners, but this is it roughly...Change the .txt extension to .xls

    BINGO!!! You da man!

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •