8 votes

Worldwide database of locations (cities)?

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?
abitmol's user avatar
  • 81
7 votes
Accepted

Where to find Geology data for Europe - GIS

Whilst onegeology.org is great, and certainly there are a lot of European Geology WMS and some WFS services available. In this situation I think that currently (a) you might be better off going to ...
nmtoken's user avatar
  • 566
6 votes
Accepted

Ontological Database of Objects

...but extracting the hierarchical information is non-trivial. DBpedia T-Box dump is available to download as a separate file from this page. Wikidata classes and properties dumps are available to ...
Stanislav Kralin's user avatar
5 votes

Can I use another database instead of PostgreSQL in CKAN?

No, the only currently supported database backend is PostgreSQL. It was chosen as it is an open source, well supported and widely available solution. Support for other backends would need to be added ...
amercader's user avatar
  • 568
5 votes
Accepted

Worldwide database of locations (cities)?

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, ...
juminet's user avatar
  • 406
4 votes

Where to find Geology data for Europe - GIS

Can I suggest OneGeology.org. It's a portal for open geological data from around the world. It's mostly designed around their web map portal; http://portal.onegeology.org/OnegeologyGlobal/ which ...
aidenprice's user avatar
4 votes

US Fire Database

If you're fine with textual or GIS data, you'll probably find it in the NASA VIIRS Active Fire Data page. It's updated frequently and contains worldwide fire hotspots of the past 24 hours up to one ...
ulrich's user avatar
  • 331
4 votes
Accepted

Save Scraped Data to an Open Database

A quick an easy way to provide open access to your scraped data would be pushing it to GitHub or another easily accessible online repo in a text format (CSV/TSV or JSON if it's less structured -- this ...
DGinzberg's user avatar
  • 326
4 votes
Accepted

Where can I find the list of NCIC assisiged "Originating Agency Identifier"?

API (clean data) It's available at the Crime Data API end point, you have to first request a data.gov api key then you can access it on https://api.usa.gov/crime/fbi/sapi/api/agencies?api_key=<...
Evan Carroll's user avatar
4 votes

Worldwide database of locations (cities)?

check (and collaborate!) at Data Packaged Core Datasets the specific datasets: https://github.com/datasets/population-city https://github.com/datasets/world-cities Both are related to https://github....
Peter Krauss's user avatar
3 votes

Looking for database of US companies

Opencorporates is a good start, if you tell us more about the geographies you are interested in we might be able to help more. Look also at the datasets listed here, all trade registries are free and ...
marfi's user avatar
  • 583
3 votes
Accepted

PETS 2006 Dataset

These sites are working for me: ftp://ftp.cs.rdg.ac.uk/pub/PETS2006/ ftp://ftp.cs.rdg.ac.uk/pub/groups/cvg/PETS2006/ Not working: http://ftp.cs.rdg.ac.uk/PETS2006/ So you'd have to replace the ...
philshem's user avatar
  • 17.6k
3 votes

Worldwide database of locations (cities)?

I've developed an online REST service called GeoDB Cities that wraps the GeoNames data (and also leverages WikiData for translations). It should give you exactly what you need. You'll need to get the ...
Michael Mogley's user avatar
3 votes

Worldwide database of locations (cities)?

Check out citypopulation.de, a well-curated website of all the world's big citites and agglomerations. The guy who maintains the site (I think it is only one person, Thomas Brinkhoff - see the Terms ...
knb's user avatar
  • 1,227
3 votes
Accepted

90ies Windows .exe database on CD: Extract underlying data

I received some help on it. Something along these lines with xor in Python did the job: with open('...dat', 'rb') as f: with open('...txt', 'w') as out: xor = 1 s = "" ...
moezelot's user avatar
  • 153
3 votes

price of commercial real estate (office space) per zip code

I'm the head researcher for a commerical real estate brokerage firm. I don't know of a perfect source for what you are looking for, but here are some proxys you might try Paid option: Costar http://...
Tim_K's user avatar
  • 206
3 votes

US Fire Database

Two U.S. federal options: InciWeb - Incident Information System - National Wildfire Coordinating Group (NWCG) Wildfire - Wildland Fire Information
albert's user avatar
  • 11.8k
3 votes
Accepted

mean/median age for each US zip code

I did a quick export of data from the 2014 5-year ACS of the population and median age of every ZIP code: https://www.dropbox.com/s/utnthc601i82iff/census.csv?dl=0
sirwart's user avatar
  • 261
3 votes

Is there a comprehensive geocoding DB available?

Nominatim has an API that gives data on at the very least the street level. You can provide a latitude and longitude and have an address returned.
Lio Elbammalf's user avatar
3 votes

Where can I find databases in .rdf or in .ttl format

Information Retrieval Dataset - Internet Movie Database (IMDB) Description This dataset was constructed for an Information Retrieval research project to obtain a master's degree at the Federal ...
Orophile's user avatar
  • 1,721
2 votes

mean/median age for each US zip code

American Fact Finder includes median age in their General Population and Housing Statistics reports; General Population and Housing Statistics for Zip Code 23662 is one such table, from the 2010 US ...
albert's user avatar
  • 11.8k
2 votes

Database of Cars in Qatar

It seems as though right now, Qatar has open data policies in place, but are still fulfilling them on a case by case basis. They have explicitly stated on this site here: http://www.ictqatar.qa/en/...
Brian Back's user avatar
2 votes

Where can I find the list of NCIC assisiged "Originating Agency Identifier"?

You can download a comprehensive file through UMich's ICPSR repository (sign up is free): https://www.icpsr.umich.edu/web/ICPSR/series/366 Here's a sample of the data – I believe the ICPSR's ToC ...
dancow's user avatar
  • 161
1 vote

Downloadable list of all majors across U.S. schools/colleges?

For a really broad answer, you can use Wikidata via a Sparql query on the property "Academic Major". From my quick query, I think the data would need to be cleaned up a bit, and also made specific to ...
philshem's user avatar
  • 17.6k
1 vote

Open Source Information about Colleges and Universities

If you are looking for data in the US, I would look at IPED. The Integrated Postsecondary Education Data System (IPEDS) is the Department of Education’s National Center for Education Statistics’ (...
Christopher Klaus's user avatar
1 vote
Accepted

Is there any pro wrestling dataset available ?

The Internet Wrestling Database is a free resource of professional wrestling information.  http://www.profightdb.com/tos.html
Christopher Klaus's user avatar
1 vote
Accepted

Public International Database of Literature Works?

The best solution so far came from comments. Thanks to @StanislavKralin who suggested to use public Wikidata as a source. Here's the link to SPARQL query that can be tried: http://tinyurl.com/...
Gino Pane's user avatar
  • 141
1 vote

Database with multiple values for the same ID

It's a bit strange that the same unique ID can be associated with more than one name. The database schema must have a design problem. One solution might be to clean up your 50,000 transactions one day ...
Ettore Rizza's user avatar
1 vote

Where to find Geology data for Europe - GIS

Free data (https://energy.usgs.gov/OilGas/AssessmentsData/WorldPetroleumAssessment/WorldGeologicMaps.aspx) U.S. Department of the Interior | U.S. Geological Survey | DOI Inspector General Atention! ...
Panait Valentin's user avatar
1 vote

Searching for database for Colorado soils that goes back to 1990's

The ISRIC (International Soil Reference and Information Centre) Soil Data Hub has world-wide soil data from multiple sources. You can search by data extent. It returned 102 search results for a ...
csk's user avatar
  • 1,355

Only top scored, non community-wiki answers of a minimum length are eligible