title: Getting city data from geonames.org dump files
body: <p>I exported the US.zip, allcountries.zip and the cities1000.zip file from geonames.org with the intention of using it for a list of cities, states and longitude/latitude info in the US. I noticed after looking through the data that there is a whole lot more than just cities and states. 
  Ex. Here is one row</p>
  
  <pre><code>7534318              The San Francisco School              The San Francisco School              NULL     37.73275               -122.41167         S             SCH        US          NULL     CA          075        NULL     NULL     0             10               19           America/Los_Angeles      NULL
  </code></pre>
  
  <p>This contains other data about some data point in San Francisco, CA for a school. Although this is nice it seems that if all I want is city/state/country/lat/long data then it will be very hard to filter this data for just what I’m looking for.</p>
  
  <p>My question. If all I want is a list of cities in the US with their state and long/lat information is there an easy way to get it from <a href="http://download.geonames.org/export/dump/" rel="nofollow">http://download.geonames.org/export/dump/</a> data export dump files? It doesn't seem like there is one specific column that has city names?</p>
  
  <p>Thank you for any help!</p>