23
My open data project (I am a co-founder) has a free list of all the cities in the world, along with their area centroid (lat/lng), as a CSV file. It is compiled from the USGS/GNIS (US) and NGA/GNS (non-US) databases.
http://www.opengeocode.org/download.php#cities
As an alternate source, the United Nations Statistical Division publishes an annual yearbook ...
15
You have been misled, CBSA files are in fact what you are looking for. Check the documentation detailing what each type of shapefile contains.
Want more verification? Here is the description of the GEOID field for the CBSA shapefile: 2010 Census metropolitan statistical area/micropolitan statistical area code found in CBSAFP10. And here is the description ...
10
Wikidata has a category called "city" which will give you a list of world cities
https://www.wikidata.org/wiki/Q515
You can use SPARQL to query Wikidata
https://www.mediawiki.org/wiki/Wikidata_query_service/User_Manual
https://query.wikidata.org/
A sample SPARQL query will give you the city name in the target language
SELECT ?city ?cityLabel ?country ?...
9
I found an API from Numbeo (documentation) that claims
1,485,832 prices in 4,786 cities entered by 177,368 users
(information updated 2014-11-25)
Here is their page related to the Cost of Living.
And an overview of the data for Zurich.
Their Terms of Service state that the license is CC BY-SA 3.0 and GNU Free Document License (GFDL).
What I can't ...
8
If you don't need programmatic access (i.e. an API), you can use the Google Advanced Image Search.
You can also get there by following these simple steps:
Go to search.creativecommons.org
Enter your search term (e.g. berlin)
Select your license requirements (use for commercial purposes and/or modify, adapt, or build upon)
Click on Google Images
On Google ...
8
The US Census Bureau also has a national gazeteer file with state and city info, including incorporation information.
For metadata/excel file column please have a look at HERE.
8
I guess the Geonames project is the closest answer to your question. You can download the data directly on the website or you can also find it here and download it/use the api.
Cheers
8
Why don't you use OSM's API?
A similar question was asked on gis:
How to get a list of OSM relations (id numbers) of cities and countries only?
7
This is a goal of the DemocracyMap project, which is still nascent.
The DemocracyMap API aims to provide normalized structured data for
all of the contact details and other primary information for every
government body and government official that represents you. Currently
this API is more of a meta-API that aggregates, normalizes, and caches
...
7
GreenButtonData.org (open source) is compiling this type of information from its users. They currently claim that upto 60 million households can access their monitoring/analysis system via partnerships with utility companies.
They have a REST API, but I do not know how much aggregated data is available yet. They have though given some datasets (or samples),...
6
The Open Data Policy and Executive Order are for federal datasets and does not mandate the same for state or local governments, although such policies does influence more local policies.
See http://www.data.gov/opendatasites for a large (but not comprehensive) listing of Open Data sites at the international, state and local levels.
For state-level open ...
6
While this won't be of help for a while, we at the U.S. Energy Information Administration (EIA) are beginning to develop a data set that may be helpful in the future. We received approval for a new data collection from Balancing Authorities in the lower 48 United States that will collect hourly generation, consumption, and transfer of electricity. The data ...
6
UN/LOCODE includes over 103,034 locations in 249 countries and installations in international waters. It is used by most major shipping companies, by freight forwarders and in the manufacturing industry around the world. It is also applied by national governments and in trade related activities, such as statistics where it is used by the European Union, by ...
6
i think open ei has this in their building energy data book:
http://en.openei.org/doe-opendata/dataset/buildings-energy-data-book
here's a section from that which is a survey of building energy consumption and extends past 2011:
http://www.eia.gov/consumption/commercial/data/2012/
lastly, try the data hub for the energy performance of buildings for the eu:
...
6
I have a CSV file you can download that lists all US cities by state. The data was compiled from the US Census 2013 Gazetteer.
http://www.opengeocode.org/download.php#statecity
In case you must have the data from that domain, each state's information is listed on the states index pagef, and follows similar naming conventions. For example, here's Virginia'...
6
From Wikipedia:
A Cadastre is normally a parcel based, and up-to-date land information
system containing a record of interests in land (e.g. rights,
restrictions and responsibilities). It usually includes a geometric
description of land parcels linked to other records describing the
nature of the interests, the ownership or control of those ...
6
The data you want are in these files.
The primary source for this data was a US Census Bureau dataset of ~7500 incorporated cities whose populations surpassed 2500 people at some point in their existence. Additional cities were added from a variety of sources (...)
6
I think that geonames.org has the data you require.
It's datasets contain:
The main 'geoname' table has the following fields :
---------------------------------------------------
geonameid : integer id of record in geonames database
name : name of geographical point (utf8) varchar(200)
asciiname : name of geographical point in ...
5
I concur with Kotebiya. MSAs are identified by a CBSA identifier. Below is the definition from the Tiger line handbook (ftp://ftp2.census.gov/geo/tiger/TIGER2013/2013-FolderNames-Defined.pdf)
CBSA Metropolitan Statistical Area / Micropolitan Statistical Area
5
European Network of Transmission System Operators for Electricity (ENTSOE) provides Consumption and Production data for individual countries (and Exchange data between countries). (Link to Data Portal.)
Link to ENTSOE Consumption data
For your application, you would probably want one of these country hourly load data sets. They are at the country ...
5
The City of Gainesville has an open data portal that seems to be worth the title. They offer huge amounts of data. Among them are these two, both updated since January 2012:
Customer electric consumption, by address, by month
Natural gas consumption by month, by service
address
So while the temporal resolution is not stellar, spatial resolution is better ...
5
I would take a look at these sources:
OpenStreetMap (OSM)
All about POIs (points of interest) in OSM
Question on help.OSM about extracting POIs from a region
Foursquare
POI API (aka Venues) (note: not open data)
Yelp
Search / Business APIs (note: not open data)
5
Here is my obligatory pointer to overpass turbo, a "graphic" way to explore the data quality for certain POIs (points of interest) in the OpenStreetMap database.
This examplary query for amenity=restaurant in Rome (patience: the query takes several seconds to execute) yields (probably incomplete) 543 locations with varying metadata.
How-to: For a given POI,...
5
The WHO provides global data for many cities. It doesn't seem to break down the overall air pollution into molecular components, though.
Website with details
Ambient (outdoor) air pollution database, by country and city (Excel file)
Many individual cities or regions provide air quality data. A short example, although basically every city or region will ...
5
You might try using data from the Geonames.org database. You can download gazateer data by country from this list.
Another potential source is the the MaxMind GeoLite2 dataset.
5
As a variation of above, if you want all the labels in all the languages, you can get it from Wikidata like so:
SELECT DISTINCT ?city ?country (lang(?label) AS ?language) ?label
WHERE
{
?city wdt:P31/wdt:P279* wd:Q515 . # find instances of subclasses of city
?city wdt:P17 ?country # Also find the country of the city
OPTIONAL { ?city rdfs:...
5
Greater Geelong, Australia's Cadastral GIS Data
and here is Montana's Cadastral Map/Data if state level is not too big for your example.
5
You can try the Geonames database.
The GeoNames geographical database covers all countries and contains over eleven million placenames that are available for download free of charge.
You may have to subselect it as it contains many geographic names that are not cities or towns. With advanced search, you can select the feature city, village, … that may ...
5
I suggest to try Geonames, which is a well-recognized open database of geolocalized places worldwide. Geonames links the name of places (from hotel to cities) to coordinates (longitude & latitude, in WGS84) as well as other information when available (population, zip code, ...). You can have a look of webservices based on geonames here.
Among the ...
Only top voted, non community-wiki answers of a minimum length are eligible