OpenStreetMap – How to Seek and Use Colombia Municipality Geometries from GADM

colombiadatagadmopenstreetmap

I'm looking for shapefiles (or some similar format) of Colombia's municipality boundaries.

Wikipedia has a map that seems to be correct and which matches another dataset that I will eventually be merging in based on municipality names and DANE codes. I've tried contacting the file creator about the underlying source data, but without success.

I've tried GADM, but some of the municipalities are missing/incorrect, e.g. all the way in the South Amazons should have 11 municipalities, not 8.

Here's OpenStreeMap with data export via Mapzen. Many municipalities are simply just missing, although the borders for those that are there appear to be correct and more detailed than GADM.

I guess I could try to combine departments that OpenStreeMap had all municipalities for with the GADM data, but it looks like that would still only partially get me there. And in general it just makes me a bit suspicious about using the GADM data at all.

Best Answer

You can try the WFS or WMS servers of the Instituto Geográfico Agustín Codazzi (here:http://www.igac.gov.co/wps/portal/igac/raiz/iniciohome/MapasdeColombia/Descargas).

These services have different layers for geodesic features and demographics.

If that doesn't work, you can check this link with the shapefile I use for Colombian municipalities: https://www.dropbox.com/sh/i0ao837gj5wpkic/AAAnzZf-tJIKUmZvTKrvXPMpa?dl=0

Related Solutions

[GIS] Seeking Canadian postal code geometries

As a heads-up, they changed the projection format between 2011 and 2016 in case you are upgrading your local data from 2011 to 2016. The 2011 shape file is NAD83 (4269), but the 2016 seems to be using Lambert projection (3348). I say seems because when I load the shape file it doesn't specifically seem to say the exact EPSG/SRID. I ended up converting the shape file to be 4326 so that it's the same as Google Maps.

2016 FSA Census Boundary files are now available (as of Sept 13, 2017 according to their site).

Stats Canada has since released the Forward Sortation Areas Boundary files (as of February 5, 2013 according to their site).

Download Page for all 2011 Census Boundary Files

Download Page for all 2016 Census Boundary Files

Statistics Canada has a page dedicated to making available different Shape files regarding Canadian Boundaries, both Geographical and Digital. (link is the same as the one mentioned above)

http://www12.statcan.gc.ca/census-recensement/2011/geo/bound-limit/bound-limit-2011-eng.cfm

If you only need the geographic center of the postalcodes however (instead of the boundary), check out the free database at http://geocoder.ca/. You can obtain the approx center of the FSA from this as well by grouping them by the first three digits of the PostalCode and then averaging the Latitude/Longitude. SQL would help do this much easier if you import the data into a database first.

Here's a query do do what I mean.

IF NOT EXISTS(SELECT * FROM zipcodeset WHERE LEN(PostalCode) = 3)
BEGIN
    INSERT INTO zipcodeset(PostalCode, Latitude, Longitude)
    SELECT LEFT(PostalCode,3), Avg(Latitude), Avg(Longitude)
    FROM zipcodeset
    GROUP BY LEFT(PostalCode,3)
END

FSA Boundary shapefiles are now published.

[GIS] Shapefiles *.dbf data, encoding problem

The problem was because, originally data in *.dbf file for Russian langauge exactly are often saved in OEM-866 encoding format.

QGIS seems to be are marking convertions to the Unicode.

For e.g. if you want to get the normal text (in UTF-8 for e.g.) from *.dbf you can do the next (sorry, that I'm provding only C# code, but I think in other programming languages operations are similar):

static string Convert866ToUTF8(string value)
{
    var resultValue = Encoding.UTF8.GetString(Encoding.GetEncoding(866).GetBytes(value));
    return resultValue;
}

It has hepled me in developing some cleint application with C# langauge.

Best Answer

Related Solutions

[GIS] Seeking Canadian postal code geometries

[GIS] Shapefiles *.dbf data, encoding problem

Related Question