#844 state county fip data coordination

closed
5
2006-03-17
2006-03-01
msszroberts
No

I am trying to insert a county search feature into my
program. I have a table of states, and now I want to
add a table of state counties
http://www.itl.nist.gov/fipspubs/co-codes/pa.txt

Ex. I have a table which identifies the state of
Pennsylvania as PA 42000

Now I want to make a table which identifies the
counties of PA ex.

42001 Adams
42003 Allegheny
42005 Armstrong
42007 Beaver
42009 Bedford

What is the procedure for uploading a lot of county data?
What is the procedure to link the state code with the
county codes within the mysql table?
What is the best php procedure to extract the data?

Discussion

  • Michal Čihař

    Michal Čihař - 2006-03-02

    Logged In: YES
    user_id=192186

    Best way to upload huge data is using command line mysql,
    you can link InnoDB tables by native relations. Extract data
    as any other.

    I don't see here much phpMyAdmin related.

     
  • Michal Čihař

    Michal Čihař - 2006-03-02
    • assigned_to: nobody --> nijel
    • status: open --> pending
     
  • msszroberts

    msszroberts - 2006-03-02
    • status: pending --> open
     
  • msszroberts

    msszroberts - 2006-03-02

    Logged In: YES
    user_id=1361557

    Hi nijel,

    Hi Nigel,
    You may be right that about my questions not being related
    to phpMyAdmin. If so, then I appologize, but thanks for
    your feedback anyway. I posted to the phpMyAdmin forum
    because that is what I currently use to make small editing
    changes to the tables in my MySql database. I was told that
    it is much easier to manage the databases with phpMyAdmin
    than through MySQL. However, you are suggesting that I was
    given some bad information. Again, my appologies.

     
  • Michal Čihař

    Michal Čihař - 2006-03-02
    • status: open --> pending
     
  • Michal Čihař

    Michal Čihař - 2006-03-02

    Logged In: YES
    user_id=192186

    For small changes it is best :-). Hoverver for uploading big
    database, command line client is better.

     
  • SourceForge Robot

    Logged In: YES
    user_id=1312539

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).

     
  • SourceForge Robot

    • status: pending --> closed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks