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?
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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=<...
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....
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 ...
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 ...
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 ...
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 ...
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 = ""
...
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://...
3
votes
US Fire Database
Two U.S. federal options:
InciWeb - Incident Information System - National Wildfire Coordinating Group (NWCG)
Wildfire - Wildland Fire Information
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
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.
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 ...
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 ...
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/...
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 ...
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 ...
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’ (...
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
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/...
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 ...
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! ...
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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
database × 75data-request × 29
api × 10
usa × 5
medical × 4
machine-learning × 4
food × 4
geospatial × 3
city × 3
geocoding × 3
companies × 3
json × 3
real-estate × 3
books × 3
openfda × 2
uses-of-open-data × 2
images × 2
transportation × 2
demographics × 2
data-format × 2
sparql × 2
postal-code × 2
csv × 2
ontology × 2
games × 2