Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Jan. 29, 2013 Update: I've created a CSV dataset of all the cities and populated places in the world, along with a latitude/longitude area centroid, and placed into the public domain. I combined data from the USGS GNIS server for the US, and the NGA GNS server for all other countries. Below is the metadata for the CSV file layout and link to the dataset:</p> <p><a href="http://www.opengeocode.org/download.php#cities" rel="nofollow">http://www.opengeocode.org/download.php#cities</a></p> <p>Column 1: ISO 3166-1 alpha-2 country code. <br/> Column 2: US FIPS 5-2 1st level administrative division code (e.g., state/province). <br/> Column 3: NGA GNS Feature Description (DSG) code. <br/> Column 4: NGA GNS Unique Feature Identifier (UFI). <br/> Column 5: ISO 639-1 alpha-2/3 code for language corresponding to the feature name. <br/> Column 6: Language script (e.g., latin, arabic, chinese, etc) corresponding to the feature name. <br/> Column 7: Feature name. <br/> Column 8: Latitude coordinate of the area centroid. <br/> Column 9: Longitude coordinate of the area centroid.<br/></p> <hr> <p>I looked at the solution from Jonperl. It could use some comments. First, I believe geonames.org gets the US city data from the USGS GNIS server. One can directly get a download file from them.</p> <p><a href="http://geonames.usgs.gov/domestic/download_data.htm" rel="nofollow">http://geonames.usgs.gov/domestic/download_data.htm</a></p> <p>A few points someone should know: ADM1 stands for first level administrative division. For the US, these are the 50 states, District of Columbia, the 5 US territories, and 4 freely associated states. </p> <p>ADM2 stands for second level administrative division. For the US, these are counties, boroughs and census designated areas for Alaska, parishes for Louisiana, municipios for Puerto Rico, islands for the Virgin Islands, Marshall Islands, U.S. Minor Outlying Islands, districts for American Samoa, and municipalities for Nothern Mariana Islands. </p> <p>PPL are populated places. I'm not sure how geonames.org sorts these, but this category includes with cities: large subdivisions, unicorporated areas and large trailer parks. Thney also include some historical places.</p> <p>I can answer alot of these questions. I'm part of a public domain geospatial team at OpenGeoCode.Org</p> <p>Andrew </p>
    singulars
    1. This table or related slice is empty.
    1. POHow to extract Geographic data from open street map or Google maps
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAndrew - OpenGeoCode
    1. USAndrew - OpenGeoCode
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COthanks Andrew for the insight.. i just checked the OpenGeoCode.Org site...is OpenGeoCode only deals with North america data or worldwide ..? am interested in a solution that covers worldwide geographical data....
      singulars
      1. PO
      1. USRameshVel
    2. COOpenGeoCode will provide some high level geodata worldwide. But for now, we only plan to do detailed geodata for North America. We are focused on high accuracy of the data, so that's why the more narrow target. There's more data in the pipeline, but it all goes thru a review/tuning process.
      singulars
      1. PO
      1. USAndrew - OpenGeoCode
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload