Street list of Colombia in Excel, SQL, CSV or XML

 

Some companies or ambitious projects need geographical data and require a list of the streets of the communes in Colombia. In order to help these large projects, Postcodezip has prepared a database listing [Count Street] streets, spread over [Count Cities] cities with [Count Postcode] postal codes in Colombia

 

List of streets in Colombia

This type of database provides a list of streets for many types of projects. To help developers better understand the possibilities, here is a shortlist of possible applications of the database:

 
  • Form entry.
  • Development of applications requiring the use of postal data.
  • Pre-fill in the street name more easily in a form requesting a postal address.
  • Verify the correctness of an address entered by a user.
  • Generate the postal address of a profile, based on real data.
  • For an application that already has postal addresses, this database of addresses makes it easier to cross-reference the data and to group buildings, establishments, or customers more easily, based on their postal addresses.
  • Make various statistics to know the number of "blocks" or "driveway" for each area [Of Country]. Same if they wish to know the number of the streets called "Carrera 1"  in Colombia.
 

Did you know: in Colombia there are [Count Street] streets / avenues / places / driveways / boulevards... associated with the name of "Rue de l'Église"!

Table data

The database contains 4 tables with data that complement each other: streets, municipalities, departments, and the type of roads.

Table of streets in Colombia:

 
  • Iso: country code (INSEE code)
  • Country: country wording
  • Region: Name of the region
  • Commune name: full name of the commune
  • Postal code: postal code
  • Street: full street name, with the type of lane
  • Latitude: GPS coordinates
  • Longitude: GPS coordinates
  • Elevation: GPS coordinates

Table of communes in Colombia

 
  • Iso: country code (INSEE code)
  • Country: country wording
  • Region: Name of the region
  • Commune name: full name of the commune
  • Postal code: postal code
 

Take note: for a more complete list, please use the more complete list of communes in Colombia. The INSEE code is used as a reference to link the data together.

 

Table of departments/region in Colombia:

 
  • Iso: country code (INSEE code)
  • Country: country wording
  • Region 1: main region
  • Region 2: secondary region
  • Region 3: Tertiary region
  • Region 4: regional sub-division

Extract from the database

To assess what the data looks like and what can be contained in such a list, you can download a small sample database of the 100 streets in Colombia.

 

Download the list of street names in Colombia

Or

Download the database of all cities in Colombia

Take note:

 
  • The list contains [Count Street] streets, spread over [Count Cities] towns and cities in Colombia.
  • Every week, streets are added, modified, or deleted, therefore the list cannot be guaranteed to be 100% accurate.

Buy

If you are interested in the list of all the streets in Colombia, make a purchase directly on this site.

Make good use of these tables and don't hesitate to share your ideas and creations with others about what you could accomplish with this database.

Additional information like the nature of the lanes or INSEE, NUTS, or FIPS codes for statistical studies is available on request. Please contact us.