Addresses / POIs / streets database



We have built a unique and worldwide address, POIs (point of interest), streets, cities, and administrative divisions databases of 500+ million entries. Available country per country and in CSV or SQL format to simplify things. We use open data from best open data sources : Openstreetmap, Openaddresses, Geonames, Quattroshapes.

Why it is different ?

You would probably (logically) wonder what we've got that's better than Openaddresses. Well, we do some processing to clean, de-duplicate and add information (e.g : the administrative divisions), we also consolidate with openstreetmap addresses and cross the several datasets. We do not just concatenate the datasets, instead, for each record of each dataset, we :

  • Merge the information (e.g : for an address, we can take the alternate names, elevation and population of the city from Geonames, the shape and speed limit of the street from Openstreetmap and the house number from openaddresses).
  • De-duplicate : a place or address can be present in several datasets, we take care to only keep one
  • Consolidate : based on the feedbacks of our customers, we add some useful calculated fields (see below)
  • Correct and normalize : sometimes some entries are not entered the right way or are incorrect, we got some algorithm that takes care to correct data when it is possible.

Each dataset imported is more or less specialized in one category, we mix and cross them so we have a unique and comprehensive database with the best of each data source.

AddressesStreetsPoint of interestCityCity shapes
Openstreetmapcheckedcheckedcheckedcheckedcheckedcheckedcheckedcheckedcheckedcheckedcheckedcheckedchecked
Openaddressescheckedcheckedcheckedcheckedcheckedcheckedchecked
Geonamescheckedcheckedcheckedcheckedcheckedcheckedcheckedchecked
Quattroshapescheckedcheckedcheckedcheckedcheckedcheckedchecked
Gisgraphy
checkedcheckedchecked

checkedcheckedchecked

checkedcheckedchecked

checkedcheckedchecked

checkedcheckedchecked

It is also different because of specific fields useful for routing, GPS, navigation, vehicle tracking, and more : length in meters, number of lanes, speed limit, whether the street is toll or not, and the azimuth at the beginning and end of the streets (ordinal orientation in degrees). Those fields allow to build very cool stuff and develop very quickly.

The Database for the entire planet is about 80 Go compressed and about 450 Go uncompressed.

A list of available Points of interest (POIs) is available on this page


Each row of our dataset has an ID and you can import CSV /TSV For instance when using a Postgresql relational database, you can then perform a request like 'get all streets of a city' or 'addresses in a bounding box'. Check out our integration guide.

Coverage and samples

Before your purchase, you are able to determine and view the scope of our data for any county. You can get a quote, see coverage and download sample with our on line tool.

You can also download the JSON feed that got all the statistics for all the countries

Our database is in CSV / TSV Format, each dataset has its own formats. See the description of each one in the integration guide.

- Addresses : +416 million
- POIs : +40 million
- Cities and administrative division : +4.8 million
- streets : +110 Million

+416 million

Addresses

+40 million

Points of interest (POIs)

+4.8 million

Cities and administrative divisions

+110 Million

Streets

Gisgraphy SQL dumps

If you want to run Gisgraphy on your servers, you will need the data so we also provide the option to purchase some or all of the Gisgraphy SQL dumps. The schema is the same one used by the gisgraphy framework, so you just have to inject the dump. It already contains all the datasets. By purchasing a SQL dump, you save time because the import of data is a VERY long process.

Just choose the countries you need.

Buy your Dump Get a quote

Which format to choose ? SQL or CSV ?

We produce data in several formats and you may wonder which one to choose :

  • Gisgraphy SQL dump : This format is a SQL dump of the data after they have been imported into PostgreSQL and SolR. You have to choose this format if you want to use the Gisgraphy framework, without the need to run the importer.
  • CSV format : This format is the one to choose when you need data and you do not plan to use the data in the Gisgraphy framework. The CSV / TSV datasets is a structured format that allows being used in many ways. It can be used in Excel, or in a database, or anything that can process a text file or read a TSV file. You can see an example of use in our Premium guide

Before buying you probably wonder How the CSV / TSV files look like. You will find the description of each field on the premium documentation

Free Openstreetmap PBF extracts

When we process the openstreetmap datasets, we first split the entire planet by countries. We freely give the PBF files on our download servers

Download

Database updates

Do you always want to be up to date and get data updates based on a regular basis ? contact us

License and attributions

Gisgraphy is a LGPL license. You can also consult terms and conditions and the attributions page.