How fast I will receive the files
After online payment, the file will be immediately available for download in your account.
Payments made by bank transfer, file will be available in your account after payment is received, this usually takes 3 working days.
Data structure
The structure of the databases is based on administrative divisions. Divisions are managed by each country and not necessarily are equivalent in names but they are similar as administrative level:
| Level |
Name |
Field name |
| 0 |
Group (main land, islands) |
Region0 |
| 1 |
Province / State |
Region1 |
| 2 |
Municipality / County |
Region2 |
| 3 |
District |
Region3 |
| 4 |
Sub-district |
Region4 |
| 5 |
Locality / City / Town / Village |
Locality |
| 6 |
Sub-Locality (suburb, colony, disseminated) |
Sublocality |
| 7 |
Area / Street block |
AreaName |
| 8 |
Street segments |
StreetName |
| 9 |
Street, exterior and interior number |
StreetNum |
Don't have PayPal account
Is not necessary to have a Paypal
account to buy online, depending on the country, Paypal payment page may include an option to pay with credit / debit card.
Is also possible to pay by wire transfer, contact a Divex representative to get bank account, files will be available in your account after payment is received.
I don't receive the payment confirmation e-mail
The e-mail confirming the
payment is directly associated with your PayPal account or the one instructed in the payment form when paying with cards. We
recommend you to check your email program to ensure it is not in the junk folder.
Contact us and we will look into it.
My payment has been denied
Online payments are made across PayPal,
2Checkout, Google or processed directly with our bank's merchant. We do not receive in any moment your credit card and
banking information,
payment is processed by PayPal or bank institution. You must contact Paypal or your bank to check the reason of the charge has been denied.
I didn't receive the link to download files
When you buy a database, an e-mail
is sent with your account login information, please note that after payment you should click the confirmation link on PayPal page, which
takes you to Divex to finish the process and leaves you in your account, ready for download.
The e-mail used to pay will be used as your account's ID.
If you do not receive this e-mail, contact us, please provide the payment receipt received from PayPal which contains the transaction
number.
Download link does not work
Once you pay, PayPal shows a page confirming the transaction, you should click the link that says
"return to Divex" in order to continue, this link will take you to your account, check the transaction and let you download the file.
Be aware that when returning from PayPal, Divex will verify the transaction and amount paid, if amount does not match, your account may be
deactivated temporarily until the mismatch is clarified, in this case you must contact us to reactivate your account after verifying the issue.
During the file download I get an error message
Not usual but our server may have a
temporary work overload.
Please try again, try first using a different browser (Chrome o Explorer recommended).
If problem persist please contact us.
After import, data show strange characters
Our data is encoded using the
international multilingual format: Unicode UTF-8. You must select this encoding while importing the data to any application. If you use a an
application that does not give option for encoding in the import option (this very rare), you must switch your operation system
(PC or Server) default encoding to UTF-8 to proceed then to import, after the import of data, you can switch back to your original
configuration.
How frequent are the data updates
Our database is updated every 3 months.
What is the precision of coordinates
The geographic (latitude,
longitude) is close to 100 meters of the center a postal code, the locality or area that the post code covers. In some countries, the post
code refers to a suburb, a disseminate (ie: a ranch), a district or a street, in this case the coordinates will be to the center of that
specific area.
How can I calculate the distance between two places
DistanceAB = 6371 * ACos( Cos(lat1) * Cos(lat2) * Cos(lon2 - lon1) + Sin(lat1) * Sin(lat2) )
The number obtained is in kilometers from point A to B. If you want miles, change 6371 by 3959.
Attention!
The value of latitude and longitude must the provided in radians: grades * PI/180.
An Excel sheet with the formula is
available here.
List adjacent localities to and specific point
Since the database contains the latitude
(Lat) and longitude (Lng) of localities, you can use the following query:
SELECT Name, 6371 * ACos( Cos(RADIANS(Lat)) * Cos(RADIANS(UserLat)) * Cos(RADIANS(UserLng) -
RADIANS(Lng)) + Sin(RADIANS(Lat)) * Sin(RADIANS(UserLat)) ) AS Distancia FROM [PostalCodes] ORDER BY Distance WHERE Distance <= 5
The values: UserLat e UserLng must be replaced by the latitude and longitude of central point defined. To limit the search to a radius,
we added the clause
WHERE to specify the kilometers radius; Use the clause TOP (in MSSQL o Access) o LIMIT (mySQL) to limit the number of returned records.
How I receive the data
Our data is only available for direct download or web services
retrieval. This guarantee the best price possible, condition impossible obviously for media and delivery.
Can I distribute the data in my application or web page
You can use the data in any form inside your
application or web page as long as data is used as part of operative functionality of your application. You can not show the data in a way it
can be copied, neither distribute the data itself; either paid or for free.
There is a post codes not covered in the data
Our database contains postal codes which correspond to
localities o specific areas such as suburbs, districts, streets, etc. Some countries use postal codes for post offices or administrative
centers or post distribution centers. This postal distribution or postal offices post codes and not covered in our data as we feature
geographic entities only.
I have found an obsolete information
We verify that information contained in our database is as
more precise as possible. However, please notify a representative by providing the data to be analyzed and provide you a response, please
provide the version of data (year / month) along with the data.
I am not satisfied with the acquisition
Our site has been prepared in a way that all details of
the information can be verified online so you know exactly the contents of the data files,
so we do not offer refunds. If any way you feel like you have the right, feel free to send us your request with a detailed description of your
case..
Is possible to obtain the data of a country that is not listed ?
Our database is
constantly adding new data and new countries. Please contact us with your needs and we will be happy to work on it.