Peripheral Cities

DANE Comparison

Units By City
	Barranquilla	Bogotá	Medellín	Total
UnitsFromData	76,871	346,859	94,034	517,764
UnitsFromDANE	85,653	327,804	100,917	514,374
Difference	-8,782	19,055	-6,883	3,390

Overview: Cities, Municipalities, Projects, Units

Total Projects: 1,378

Total Units: 550,048

Included Municipalities: Barranquilla, Bello, Bogota, Cajicá, Caldas, Chía, Copacabana, Envigado, Funza, Galapa, Girardota, Itagüí, La Calera, La Estrella, Madrid, Malambo, Medellin, Mosquera, Sabaneta, Soacha, Soledad

Included Municipalities Only
City	Municipality	Projects	Units
Barranquilla	Barranquilla	67	34,327
Barranquilla	Galapa	3	3,337
Barranquilla	Malambo	2	248
Barranquilla	Soledad	97	34,032
Bogota	Bogota	538	208,918
Bogota	Cajicá	11	5,414
Bogota	Chía	12	5,133
Bogota	Funza	22	7,124
Bogota	La Calera	7	1,219
Bogota	Madrid	50	29,720
Bogota	Mosquera	41	15,504
Bogota	Soacha	283	121,226
Bogota	Tocancipá	20	11,700
Medellin	Bello	50	21,213
Medellin	Caldas	5	2,057
Medellin	Copacabana	9	1,651
Medellin	Envigado	3	1,912
Medellin	Girardota	3	506
Medellin	Itagüí	13	4,652
Medellin	La Estrella	8	3,068
Medellin	Medellin	143	43,580
Medellin	Sabaneta	11	5,207

Builder Statistics

Projects and Units By Builder and City (Greater than 10 Projects)
City	Constructor	Projects	Units
Barranquilla	Const. Bolivar	32	16,018
Barranquilla	Marval	21	10,140
Barranquilla	Villa Linda	13	2,163
Barranquilla	Amarilo	10	4,632
Bogota	Const. Bolivar	124	61,430
Bogota	Amarilo	70	24,684
Bogota	Apiros	60	36,488
Bogota	Prodesa	40	17,770
Bogota	Const. Las Galias	36	27,048
Bogota	Const. Capital	34	18,093
Bogota	Marval	29	13,713
Bogota	Urbansa	27	11,103
Bogota	Triada	23	7,476
Bogota	Const. Colpatria	21	9,116
Bogota	Ingeurbe	21	9,402
Bogota	Mendebal	19	9,627
Bogota	A.R. Const.	17	11,033
Bogota	Cusezar	15	4,513
Bogota	Norco	14	6,757
Bogota	Buenvivir Cons.	13	8,245
Bogota	Fund. Compartir	13	4,501
Bogota	Grupo Construmax	12	2,974
Bogota	Obreval	11	3,832
Medellin	Conaltura	24	10,158
Medellin	Const. Capital	23	9,775

Builder Size

Categories:

Large Constructors: 10 or more projects

Medium Constructors: 5-9 projects

Small Constructors: 2-4 projects

Single Project Constructors: 1 project

Multi-City Builders

Multi-City Constructors
Constructor	Medellin	Barranquilla	Bogota	Total_Projects
Const. Bolivar	0	32	124	156
Amarilo	0	10	70	80
Const. Capital	23	0	34	57
Marval	0	21	29	50
Prodesa	0	6	40	46
Conaltura	24	2	2	28
Const. Colpatria	0	2	21	23
A.R. Const.	0	1	17	18
Coninsa Ramon H.	5	3	8	16
Fund. Compartir	2	0	13	15
Obycon	0	3	9	12
Arq. & Concreto	2	1	7	10
Acierto Inm.	6	0	1	7
C.A.S.A	5	0	2	7
Inacar	0	1	6	7
Conconcreto	4	1	1	6
Convel	0	1	1	2

Project Size by Large Constructor

Construction Over Time

Financier

Financier by City

Multi-City Financiers
Trustee	Barranquilla	Bogota	Medellin	Total_Projects
Bogotá	38	423	22	483
Davivienda	37	239	9	285
Alianza	24	96	50	170
No	56	69	44	169
Acción	6	17	49	72
Colmena	1	52	0	53
Bancolombia	1	25	17	43
Corficolombiana	1	2	26	29
Central	0	16	8	24
Credicorp Capital	3	12	5	20
Colpatria	1	13	2	16
Occidente	0	13	0	13
Valle	0	0	6	6
BBVA	0	2	2	4
Popular	0	0	3	3
La Previsora	0	2	0	2
Corfisura	0	1	0	1
Desistido	1	0	0	1
Fiduagraria	0	0	1	1
Itaú	0	0	1	1
Petrol	0	1	0	1
NA	0	1	0	1

Financier by Project Size

Financiers and Constructors

VIS NVIS Yearly by City

Counts

Percentages

Data Appendices:

Appendix 1: All Stats

Towers: decided by creating three columns, the sum, and max of “Number of Towers Column, and also extracting the max number from tower description. When two or all three of these agreed, that was the number. After that, I took the largest number of the three that was between 0 and 100. If both of these failed, the value was removed. This created 152 NAs out of 1222

Units: added up all units from each stage of the project

Value: added up all units from each stage of the project

Area: added up all units from each stage of the project

Floors: added up all units from each stage of the project

Completion date was filtered by year, eliminating 3 projects pre 2007

Characteristic	Overall, N = 1,4551	Barranquilla, N = 1691	Bogota, N = 1,0341	Medellin, N = 2521
Stratum
1	6 (0.4%)	5 (3.0%)	1 (<0.1%)	0 (0%)
2	518 (36%)	104 (62%)	387 (37%)	27 (11%)
3	865 (59%)	57 (34%)	610 (59%)	198 (79%)
4	61 (4.2%)	3 (1.8%)	32 (3.1%)	26 (10%)
5	5 (0.3%)	0 (0%)	4 (0.4%)	1 (0.4%)
VIS_Type
Vip /	68 (4.7%)	30 (18%)	38 (3.7%)	0 (0%)
Vipa/	31 (2.1%)	10 (5.9%)	21 (2.0%)	0 (0%)
Vis Renov./	15 (1.0%)	2 (1.2%)	11 (1.1%)	2 (0.8%)
Vis/	1,341 (92%)	127 (75%)	964 (93%)	250 (99%)
Type
Apto	1,272 (87%)	107 (63%)	933 (90%)	232 (92%)
Casa	181 (12%)	62 (37%)	100 (9.7%)	19 (7.5%)
Lote	2 (0.1%)	0 (0%)	1 (<0.1%)	1 (0.4%)
TowersNo	11.6 (0.0, 10.0, 125.0)	21.1 (0.0, 17.0, 125.0)	12.4 (0.0, 11.0, 60.0)	4.0 (1.0, 2.0, 22.0)
Unknown	183	62	101	20
Units	397.7 (6.0, 336.0, 2,891.0)	425.7 (6.0, 318.0, 2,891.0)	408.5 (8.0, 352.0, 2,108.0)	334.7 (20.0, 237.0, 1,900.0)
Value	34,181.7 (198.0, 24,376.0, 330,600.0)	35,197.2 (198.0, 29,347.0, 221,707.0)	35,190.2 (564.0, 25,145.5, 298,895.0)	29,362.3 (800.0, 17,002.5, 330,600.0)
Area	19,893.3 (210.0, 16,620.0, 149,659.0)	21,872.2 (210.0, 16,500.0, 149,659.0)	20,497.7 (319.0, 17,507.0, 122,310.0)	16,086.1 (960.0, 11,702.5, 96,900.0)
Floors	30.5 (0.0, 18.0, 340.0)	32.6 (1.0, 15.0, 180.0)	27.4 (0.0, 18.0, 264.0)	41.7 (0.0, 25.0, 340.0)
Completion_Date
2007	9 (0.6%)	0 (0%)	4 (0.4%)	5 (2.0%)
2008	27 (1.9%)	5 (3.0%)	14 (1.4%)	8 (3.2%)
2009	67 (4.6%)	3 (1.8%)	46 (4.4%)	18 (7.1%)
2010	86 (5.9%)	4 (2.4%)	62 (6.0%)	20 (7.9%)
2011	120 (8.2%)	5 (3.0%)	88 (8.5%)	27 (11%)
2012	125 (8.6%)	9 (5.3%)	92 (8.9%)	24 (9.5%)
2013	102 (7.0%)	2 (1.2%)	80 (7.7%)	20 (7.9%)
2014	98 (6.7%)	5 (3.0%)	80 (7.7%)	13 (5.2%)
2015	91 (6.3%)	4 (2.4%)	78 (7.5%)	9 (3.6%)
2016	87 (6.0%)	6 (3.6%)	68 (6.6%)	13 (5.2%)
2017	85 (5.8%)	11 (6.5%)	61 (5.9%)	13 (5.2%)
2018	63 (4.3%)	8 (4.7%)	47 (4.5%)	8 (3.2%)
2019	87 (6.0%)	12 (7.1%)	54 (5.2%)	21 (8.3%)
2020	73 (5.0%)	14 (8.3%)	53 (5.1%)	6 (2.4%)
2021	104 (7.1%)	22 (13%)	68 (6.6%)	14 (5.6%)
2022	110 (7.6%)	23 (14%)	66 (6.4%)	21 (8.3%)
2023	121 (8.3%)	36 (21%)	73 (7.1%)	12 (4.8%)
UnitsPerFloor	21.9 (1.2, 12.0, 205.0)	25.6 (4.0, 8.1, 144.0)	24.4 (1.2, 14.8, 205.0)	10.5 (2.0, 7.5, 77.0)
Unknown	194	62	108	24
AreaPerUnit	50.2 (17.6, 49.8, 96.5)	53.0 (30.0, 52.1, 81.0)	50.3 (17.6, 49.6, 96.5)	48.0 (28.0, 49.4, 64.0)
Total_Project_Units	425.6 (6.0, 360.0, 2,891.0)	476.1 (6.0, 384.0, 2,891.0)	429.7 (8.0, 372.0, 2,512.0)	375.1 (20.0, 269.0, 2,350.0)
Unknown	1	0	1	0
Initial_Down_Payment_Percentage	0.3 (0.0, 0.3, 30.0)	0.3 (0.0, 0.3, 1.0)	0.3 (0.0, 0.3, 30.0)	0.3 (0.0, 0.3, 1.0)
Unknown	1	0	1	0
Delivery_Type
Acabados/	81 (5.7%)	21 (14%)	60 (5.8%)	0 (0%)
Acabados/Obra Gris/	2 (0.1%)	0 (0%)	2 (0.2%)	0 (0%)
Acabados/Semi Acabados/	2 (0.1%)	2 (1.4%)	0 (0%)	0 (0%)
N.A./	2 (0.1%)	0 (0%)	1 (<0.1%)	1 (0.4%)
Obra Gris/	1,281 (90%)	100 (68%)	930 (90%)	251 (100%)
Obra Gris/Semi Acabados/	4 (0.3%)	2 (1.4%)	2 (0.2%)	0 (0%)
Semi Acabados/	57 (4.0%)	21 (14%)	36 (3.5%)	0 (0%)
Unknown	26	23	3	0
Partial_or_Total_Trustee
0	2 (0.2%)	0 (0%)	2 (0.2%)	0 (0%)
Falta Inf.	2 (0.2%)	0 (0%)	2 (0.2%)	0 (0%)
No	278 (27%)	0 (0%)	278 (34%)	0 (0%)
No Aplica	23 (2.2%)	19 (15%)	4 (0.5%)	0 (0%)
No tiene	10 (1.0%)	0 (0%)	0 (0%)	10 (11%)
No Tiene	1 (<0.1%)	0 (0%)	0 (0%)	1 (1.1%)
parcial	3 (0.3%)	3 (2.4%)	0 (0%)	0 (0%)
Parcial	326 (32%)	58 (47%)	249 (31%)	19 (20%)
Por Definir	1 (<0.1%)	0 (0%)	1 (0.1%)	0 (0%)
total	1 (<0.1%)	0 (0%)	1 (0.1%)	0 (0%)
Total	380 (37%)	44 (35%)	273 (34%)	63 (68%)
Unknown	428	45	224	159
Basements_Count
0	484 (87%)	81 (94%)	166 (76%)	237 (94%)
1	53 (9.5%)	3 (3.5%)	44 (20%)	6 (2.4%)
2	15 (2.7%)	2 (2.3%)	6 (2.7%)	7 (2.8%)
2.3	1 (0.2%)	0 (0%)	0 (0%)	1 (0.4%)
3	3 (0.5%)	0 (0%)	3 (1.4%)	0 (0%)
4	1 (0.2%)	0 (0%)	0 (0%)	1 (0.4%)
Unknown	898	83	815	0
Semi_Basements_Count
0	509 (92%)	84 (97%)	190 (88%)	235 (93%)
1	36 (6.5%)	3 (3.4%)	26 (12%)	7 (2.8%)
2	7 (1.3%)	0 (0%)	0 (0%)	7 (2.8%)
2.3	1 (0.2%)	0 (0%)	0 (0%)	1 (0.4%)
3	3 (0.5%)	0 (0%)	1 (0.5%)	2 (0.8%)
Unknown	899	82	817	0
External_Parking_Floors_Count	0.3 (0.0, 0.0, 11.0)	0.3 (0.0, 0.0, 9.0)	0.4 (0.0, 0.0, 7.0)	0.4 (0.0, 0.0, 11.0)
Unknown	898	83	815	0
Internal_Parking_Floors_Count
0	508 (90%)	86 (100%)	192 (85%)	230 (91%)
1	35 (6.2%)	0 (0%)	23 (10%)	12 (4.8%)
2	7 (1.2%)	0 (0%)	0 (0%)	7 (2.8%)
2.3	1 (0.2%)	0 (0%)	0 (0%)	1 (0.4%)
3	11 (2.0%)	0 (0%)	10 (4.4%)	1 (0.4%)
4	1 (0.2%)	0 (0%)	1 (0.4%)	0 (0%)
7	1 (0.2%)	0 (0%)	0 (0%)	1 (0.4%)
Unknown	891	83	808	0
Other_Use
-	2 (0.2%)	0 (0%)	0 (0%)	2 (2.8%)
0	159 (17%)	1 (0.7%)	158 (22%)	0 (0%)
1 Local	3 (0.3%)	0 (0%)	0 (0%)	3 (4.2%)
2 Locales	2 (0.2%)	0 (0%)	1 (0.1%)	1 (1.4%)
22 Locales 1 Ancla No se venden	1 (0.1%)	0 (0%)	0 (0%)	1 (1.4%)
3 locales	1 (0.1%)	0 (0%)	0 (0%)	1 (1.4%)
4 Locales	1 (0.1%)	0 (0%)	0 (0%)	1 (1.4%)
5 Locales Futuros	2 (0.2%)	0 (0%)	0 (0%)	2 (2.8%)
8 locales	1 (0.1%)	0 (0%)	1 (0.1%)	0 (0%)
9 Locales No Están en Venta	1 (0.1%)	0 (0%)	0 (0%)	1 (1.4%)
Comercio	2 (0.2%)	0 (0%)	0 (0%)	2 (2.8%)
Futuro	2 (0.2%)	0 (0%)	0 (0%)	2 (2.8%)
Locales	42 (4.5%)	14 (10%)	28 (3.9%)	0 (0%)
Mall Futuro	2 (0.2%)	0 (0%)	0 (0%)	2 (2.8%)
no	13 (1.4%)	7 (5.2%)	6 (0.8%)	0 (0%)
No	697 (75%)	113 (84%)	533 (73%)	51 (72%)
NO	1 (0.1%)	0 (0%)	0 (0%)	1 (1.4%)
Por definir	1 (0.1%)	0 (0%)	0 (0%)	1 (1.4%)
Unknown	522	34	307	181
Sustainable_Certification
Casa Colombia	5 (0.3%)	0 (0%)	3 (0.3%)	2 (0.8%)
Edge	42 (2.9%)	13 (7.7%)	29 (2.8%)	0 (0%)
En Proceso	1 (<0.1%)	0 (0%)	0 (0%)	1 (0.4%)
HQE	4 (0.3%)	0 (0%)	4 (0.4%)	0 (0%)
No	1,402 (96%)	156 (92%)	997 (97%)	249 (99%)
Unknown	1	0	1	0
Price_RelationTo_MinWage
No	1,349 (93%)	156 (92%)	972 (94%)	221 (88%)
Si	105 (7.2%)	13 (7.7%)	61 (5.9%)	31 (12%)
Unknown	1	0	1	0
IntegratedKitchen
No	1,367 (94%)	149 (88%)	966 (94%)	252 (100%)
Semi	61 (4.2%)	17 (10%)	44 (4.3%)	0 (0%)
Si	26 (1.8%)	3 (1.8%)	23 (2.2%)	0 (0%)
Unknown	1	0	1	0
Extractor
Falta Inf.	1 (<0.1%)	1 (0.6%)	0 (0%)	0 (0%)
No	1,434 (99%)	165 (98%)	1,017 (98%)	252 (100%)
Si	19 (1.3%)	3 (1.8%)	16 (1.5%)	0 (0%)
Unknown	1	0	1	0
LaundryInstallation
Lav./Sec.	248 (17%)	25 (15%)	39 (3.8%)	184 (73%)
Lavadora	961 (66%)	121 (72%)	774 (75%)	66 (26%)
No	243 (17%)	22 (13%)	219 (21%)	2 (0.8%)
Secadora	2 (0.1%)	1 (0.6%)	1 (<0.1%)	0 (0%)
Unknown	1	0	1	0
StoveGasElectric
Electrica	15 (1.0%)	0 (0%)	15 (1.5%)	0 (0%)
Falta Inf.	1 (<0.1%)	1 (0.6%)	0 (0%)	0 (0%)
Gas	519 (36%)	113 (67%)	397 (38%)	9 (3.6%)
No	919 (63%)	55 (33%)	621 (60%)	243 (96%)
Unknown	1	0	1	0
OvenGasElectric
Electrico	10 (0.7%)	0 (0%)	10 (1.0%)	0 (0%)
Falta Inf.	1 (<0.1%)	1 (0.6%)	0 (0%)	0 (0%)
Gas	21 (1.4%)	6 (3.6%)	14 (1.4%)	1 (0.4%)
No	1,422 (98%)	162 (96%)	1,009 (98%)	251 (100%)
Unknown	1	0	1	0
HeaterGasElectric
Electrico	8 (0.6%)	0 (0%)	8 (0.8%)	0 (0%)
Falta Inf.	1 (<0.1%)	1 (0.6%)	0 (0%)	0 (0%)
Gas	42 (2.9%)	0 (0%)	42 (4.1%)	0 (0%)
No	1,357 (93%)	168 (99%)	937 (91%)	252 (100%)
Punto	46 (3.2%)	0 (0%)	46 (4.5%)	0 (0%)
Unknown	1	0	1	0
Fireplaces
No	1,452 (100%)	169 (100%)	1,031 (100%)	252 (100%)
Si	2 (0.1%)	0 (0%)	2 (0.2%)	0 (0%)
Unknown	1	0	1	0
Tubs
No	1,454 (100%)	169 (100%)	1,033 (100%)	252 (100%)
Unknown	1	0	1	0
ShowerDoors
Acrilico	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
No	1,440 (99%)	169 (100%)	1,019 (99%)	252 (100%)
Opcional	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Vidrio Temp.	12 (0.8%)	0 (0%)	12 (1.2%)	0 (0%)
Unknown	1	0	1	0
Storage
Falta Inf.	2 (0.1%)	0 (0%)	2 (0.2%)	0 (0%)
No	1,417 (97%)	168 (99%)	1,005 (97%)	244 (97%)
Opcional	6 (0.4%)	0 (0%)	3 (0.3%)	3 (1.2%)
Por Definir	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Si	28 (1.9%)	1 (0.6%)	22 (2.1%)	5 (2.0%)
Unknown	1	0	1	0
Doorman
No	132 (9.1%)	51 (30%)	21 (2.0%)	60 (24%)
Si	1,320 (91%)	118 (70%)	1,010 (98%)	192 (76%)
Video Portero	2 (0.1%)	0 (0%)	2 (0.2%)	0 (0%)
Unknown	1	0	1	0
SocialRoom
0	148 (10%)	60 (36%)	25 (2.4%)	63 (25%)
1	1,169 (80%)	102 (60%)	887 (86%)	180 (71%)
2	96 (6.6%)	6 (3.6%)	83 (8.0%)	7 (2.8%)
3	38 (2.6%)	1 (0.6%)	35 (3.4%)	2 (0.8%)
4	2 (0.1%)	0 (0%)	2 (0.2%)	0 (0%)
7	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Unknown	1	0	1	0
KidsPark
No	365 (25%)	24 (14%)	285 (28%)	56 (22%)
Por Definir	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Si	1,088 (75%)	145 (86%)	747 (72%)	196 (78%)
Unknown	1	0	1	0
Courts
Futbol	20 (1.4%)	4 (2.4%)	8 (0.8%)	8 (3.2%)
Futbol 5	2 (0.1%)	0 (0%)	2 (0.2%)	0 (0%)
Multiple	264 (18%)	77 (46%)	108 (10%)	79 (31%)
No	1,130 (78%)	85 (50%)	896 (87%)	149 (59%)
Squash	4 (0.3%)	0 (0%)	3 (0.3%)	1 (0.4%)
Varios	33 (2.3%)	3 (1.8%)	15 (1.5%)	15 (6.0%)
Voley Playa	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Unknown	1	0	1	0
Gym
Biosaludable	28 (1.9%)	8 (4.7%)	17 (1.6%)	3 (1.2%)
Dotado	101 (6.9%)	4 (2.4%)	51 (4.9%)	46 (18%)
Espacio	50 (3.4%)	10 (5.9%)	31 (3.0%)	9 (3.6%)
No	1,072 (74%)	121 (72%)	774 (75%)	177 (70%)
Por Definir	4 (0.3%)	1 (0.6%)	1 (<0.1%)	2 (0.8%)
Semidotado	197 (14%)	25 (15%)	157 (15%)	15 (6.0%)
TRX	2 (0.1%)	0 (0%)	2 (0.2%)	0 (0%)
Unknown	1	0	1	0
BuildingBackupGenerator
Falta Inf.	5 (0.3%)	1 (0.6%)	4 (0.4%)	0 (0%)
No	1,125 (77%)	134 (79%)	781 (76%)	210 (83%)
Parcial	319 (22%)	34 (20%)	243 (24%)	42 (17%)
Por Definir	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Total	4 (0.3%)	0 (0%)	4 (0.4%)	0 (0%)
Unknown	1	0	1	0
Pool
Comunal	174 (12%)	0 (0%)	61 (5.9%)	113 (45%)
Comunal Adul./Niños	93 (6.4%)	77 (46%)	10 (1.0%)	6 (2.4%)
Falta Inf.	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
No	1,186 (82%)	92 (54%)	961 (93%)	133 (53%)
Unknown	1	0	1	0
TrashChute
Cuarto	1,022 (70%)	80 (47%)	910 (88%)	32 (13%)
Cuarto/Shut	202 (14%)	3 (1.8%)	5 (0.5%)	194 (77%)
Falta Inf.	5 (0.3%)	0 (0%)	5 (0.5%)	0 (0%)
No	120 (8.3%)	60 (36%)	35 (3.4%)	25 (9.9%)
Por Definir	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Shut	104 (7.2%)	26 (15%)	77 (7.5%)	1 (0.4%)
Unknown	1	0	1	0
WetAreas
Jacuzzi	6 (0.4%)	0 (0%)	2 (0.2%)	4 (1.6%)
Jacuzzi/Sauna/Turco	9 (0.6%)	0 (0%)	6 (0.6%)	3 (1.2%)
Jacuzzi/Turco	3 (0.2%)	0 (0%)	0 (0%)	3 (1.2%)
No	1,382 (95%)	168 (99%)	1,007 (97%)	207 (82%)
Sauna	5 (0.3%)	0 (0%)	5 (0.5%)	0 (0%)
Sauna/Turco	27 (1.9%)	0 (0%)	12 (1.2%)	15 (6.0%)
Turco	22 (1.5%)	1 (0.6%)	1 (<0.1%)	20 (7.9%)
Unknown	1	0	1	0
NumberOfElevatorsPerTowerMinimum
0	984 (68%)	132 (78%)	769 (74%)	83 (33%)
1	196 (13%)	27 (16%)	140 (14%)	29 (12%)
2	240 (17%)	9 (5.3%)	104 (10%)	127 (50%)
3	24 (1.7%)	1 (0.6%)	13 (1.3%)	10 (4.0%)
4	6 (0.4%)	0 (0%)	4 (0.4%)	2 (0.8%)
5	1 (<0.1%)	0 (0%)	0 (0%)	1 (0.4%)
Falta Inf.	2 (0.1%)	0 (0%)	2 (0.2%)	0 (0%)
No	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Unknown	1	0	1	0
BBQ
Falta Inf.	63 (13%)	1 (0.9%)	2 (0.8%)	60 (53%)
No	239 (50%)	95 (82%)	104 (42%)	40 (35%)
Si	172 (36%)	20 (17%)	139 (57%)	13 (12%)
Unknown	981	53	789	139
PetArea
Falta Inf.	63 (13%)	1 (0.9%)	2 (0.8%)	60 (53%)
No	336 (71%)	112 (97%)	184 (76%)	40 (35%)
Si	73 (15%)	3 (2.6%)	57 (23%)	13 (12%)
Unknown	983	53	791	139
UrbanizationType
Abierto	147 (10%)	49 (29%)	37 (3.6%)	61 (24%)
Cerrado	1,249 (86%)	113 (67%)	946 (92%)	190 (75%)
Edificio	57 (3.9%)	7 (4.1%)	49 (4.7%)	1 (0.4%)
Falta Inf.	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Unknown	1	0	1	0
ParkingType
Falta Inf.	2 (0.1%)	2 (1.2%)	0 (0%)	0 (0%)
Industrializada	770 (53%)	124 (73%)	443 (43%)	203 (81%)
Mamposteria Est.	571 (39%)	2 (1.2%)	538 (52%)	31 (12%)
Mixta	1 (<0.1%)	0 (0%)	0 (0%)	1 (0.4%)
No	2 (0.1%)	0 (0%)	1 (<0.1%)	1 (0.4%)
Tradicional	108 (7.4%)	41 (24%)	51 (4.9%)	16 (6.3%)
Unknown	1	0	1	0
Facade
Carraplast/Estuco Plastico/Graniplas	49 (3.4%)	2 (1.2%)	46 (4.5%)	1 (0.4%)
Concreto	55 (3.8%)	0 (0%)	42 (4.1%)	13 (5.2%)
Falta Inf.	3 (0.2%)	3 (1.8%)	0 (0%)	0 (0%)
Ladrillo	1,112 (76%)	4 (2.4%)	916 (89%)	192 (76%)
No	2 (0.1%)	0 (0%)	1 (<0.1%)	1 (0.4%)
Otro	4 (0.3%)	2 (1.2%)	1 (<0.1%)	1 (0.4%)
Pañete y Pintura	226 (16%)	158 (93%)	25 (2.4%)	43 (17%)
Piedra	1 (<0.1%)	0 (0%)	0 (0%)	1 (0.4%)
Vidrio	2 (0.1%)	0 (0%)	2 (0.2%)	0 (0%)
Unknown	1	0	1	0
Ventilation
Aluminio	1,288 (89%)	155 (92%)	900 (87%)	233 (92%)
Madera	1 (<0.1%)	1 (0.6%)	0 (0%)	0 (0%)
Metalica	96 (6.6%)	0 (0%)	96 (9.3%)	0 (0%)
No	2 (0.1%)	0 (0%)	1 (<0.1%)	1 (0.4%)
Por Definir	2 (0.1%)	2 (1.2%)	0 (0%)	0 (0%)
PVC	65 (4.5%)	11 (6.5%)	36 (3.5%)	18 (7.1%)
Unknown	1	0	1	0
CarpentryDoorsClosets
Entamborada-Chapilla	106 (7.3%)	25 (15%)	81 (7.8%)	0 (0%)
Madecor	137 (9.4%)	1 (0.6%)	119 (12%)	17 (6.7%)
Madera	12 (0.8%)	1 (0.6%)	10 (1.0%)	1 (0.4%)
Materiales Aglomerados	176 (12%)	39 (23%)	137 (13%)	0 (0%)
Melamina	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
No	1,012 (70%)	97 (57%)	681 (66%)	234 (93%)
Por Definir	10 (0.7%)	6 (3.6%)	4 (0.4%)	0 (0%)
Unknown	1	0	1	0
KitchenFurniture
Entamborada-Chapilla	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Falta Inf.	5 (0.3%)	4 (2.4%)	1 (<0.1%)	0 (0%)
Formica	18 (1.2%)	0 (0%)	18 (1.7%)	0 (0%)
Madecor	97 (6.7%)	2 (1.2%)	78 (7.6%)	17 (6.7%)
Madeflex	3 (0.2%)	0 (0%)	3 (0.3%)	0 (0%)
Madera	3 (0.2%)	0 (0%)	2 (0.2%)	1 (0.4%)
Materiales Aglomerados	25 (1.7%)	13 (7.7%)	12 (1.2%)	0 (0%)
Melamina	6 (0.4%)	0 (0%)	6 (0.6%)	0 (0%)
No	1,282 (88%)	146 (86%)	902 (87%)	234 (93%)
Otro	4 (0.3%)	4 (2.4%)	0 (0%)	0 (0%)
Por Definir	10 (0.7%)	0 (0%)	10 (1.0%)	0 (0%)
Unknown	1	0	1	0
KitchenCounter
Acero Inoxidable	611 (42%)	134 (79%)	354 (34%)	123 (49%)
Cemento	97 (6.7%)	12 (7.1%)	77 (7.5%)	8 (3.2%)
Ceramica	18 (1.2%)	0 (0%)	18 (1.7%)	0 (0%)
Falta Inf.	6 (0.4%)	5 (3.0%)	1 (<0.1%)	0 (0%)
Formica	6 (0.4%)	0 (0%)	6 (0.6%)	0 (0%)
Granito Natural	95 (6.5%)	4 (2.4%)	91 (8.8%)	0 (0%)
Granito Pulido	514 (35%)	0 (0%)	431 (42%)	83 (33%)
Marmol	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
No	64 (4.4%)	4 (2.4%)	22 (2.1%)	38 (15%)
Otro	13 (0.9%)	10 (5.9%)	3 (0.3%)	0 (0%)
Policuarzo	22 (1.5%)	0 (0%)	22 (2.1%)	0 (0%)
Por Definir	5 (0.3%)	0 (0%)	5 (0.5%)	0 (0%)
Quarztone	2 (0.1%)	0 (0%)	2 (0.2%)	0 (0%)
Unknown	1	0	1	0
BathroomCounter
Falta Inf.	4 (0.3%)	4 (2.4%)	0 (0%)	0 (0%)
Formica	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Granito Natural	5 (0.3%)	0 (0%)	5 (0.5%)	0 (0%)
Granito Pulido	2 (0.1%)	0 (0%)	2 (0.2%)	0 (0%)
Marmol	34 (2.3%)	0 (0%)	34 (3.3%)	0 (0%)
No	1,400 (96%)	165 (98%)	985 (95%)	250 (99%)
Otro	3 (0.2%)	0 (0%)	1 (<0.1%)	2 (0.8%)
Policuarzo	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Por Definir	3 (0.2%)	0 (0%)	3 (0.3%)	0 (0%)
Quarztone	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Unknown	1	0	1	0
CommonHallwaysFlooring
Adoquin	202 (14%)	1 (0.6%)	200 (19%)	1 (0.4%)
Cemento	443 (30%)	52 (31%)	302 (29%)	89 (35%)
Cemento Afinado	1 (<0.1%)	1 (0.6%)	0 (0%)	0 (0%)
Ceramica	266 (18%)	19 (11%)	240 (23%)	7 (2.8%)
Ceramica De Gress	462 (32%)	85 (50%)	230 (22%)	147 (58%)
No	6 (0.4%)	1 (0.6%)	2 (0.2%)	3 (1.2%)
Otro	18 (1.2%)	3 (1.8%)	13 (1.3%)	2 (0.8%)
Por Definir	48 (3.3%)	4 (2.4%)	43 (4.2%)	1 (0.4%)
Porcelanato	8 (0.6%)	3 (1.8%)	3 (0.3%)	2 (0.8%)
Unknown	1	0	1	0
LivingHallwaysFlooring
Alfombra	20 (1.4%)	0 (0%)	20 (1.9%)	0 (0%)
Cemento	261 (18%)	82 (49%)	118 (11%)	61 (24%)
Cemento Afinado	930 (64%)	29 (17%)	742 (72%)	159 (63%)
Ceramica	141 (9.7%)	49 (29%)	77 (7.5%)	15 (6.0%)
Madera Laminada	39 (2.7%)	0 (0%)	38 (3.7%)	1 (0.4%)
No	19 (1.3%)	1 (0.6%)	7 (0.7%)	11 (4.4%)
Otro	5 (0.3%)	1 (0.6%)	3 (0.3%)	1 (0.4%)
Por Definir	8 (0.6%)	4 (2.4%)	4 (0.4%)	0 (0%)
Porcelanato	4 (0.3%)	3 (1.8%)	1 (<0.1%)	0 (0%)
Tableta De Gress	6 (0.4%)	0 (0%)	5 (0.5%)	1 (0.4%)
Vinilo	21 (1.4%)	0 (0%)	18 (1.7%)	3 (1.2%)
Unknown	1	0	1	0
BedroomFlooring
Alfombra	42 (2.9%)	0 (0%)	42 (4.1%)	0 (0%)
Cemento	164 (11%)	79 (47%)	57 (5.5%)	28 (11%)
Cemento Afinado	844 (58%)	1 (0.6%)	840 (81%)	3 (1.2%)
Ceramica	45 (3.1%)	24 (14%)	21 (2.0%)	0 (0%)
Falta Inf.	293 (20%)	62 (37%)	13 (1.3%)	218 (87%)
Madera Laminada	35 (2.4%)	0 (0%)	35 (3.4%)	0 (0%)
Marmol	1 (<0.1%)	1 (0.6%)	0 (0%)	0 (0%)
No	5 (0.3%)	0 (0%)	5 (0.5%)	0 (0%)
Otro	8 (0.6%)	1 (0.6%)	7 (0.7%)	0 (0%)
Por Definir	3 (0.2%)	0 (0%)	0 (0%)	3 (1.2%)
Porcelanato	2 (0.1%)	1 (0.6%)	1 (<0.1%)	0 (0%)
Vinilo	12 (0.8%)	0 (0%)	12 (1.2%)	0 (0%)
Unknown	1	0	1	0
SocialAreaFlooring
Alfombra	28 (1.9%)	0 (0%)	28 (2.7%)	0 (0%)
Cemento	164 (11%)	80 (47%)	57 (5.5%)	27 (11%)
Cemento Afinado	833 (57%)	1 (0.6%)	828 (80%)	4 (1.6%)
Ceramica	55 (3.8%)	24 (14%)	31 (3.0%)	0 (0%)
Falta Inf.	292 (20%)	62 (37%)	12 (1.2%)	218 (87%)
Madera Laminada	44 (3.0%)	0 (0%)	44 (4.3%)	0 (0%)
Marmol	1 (<0.1%)	1 (0.6%)	0 (0%)	0 (0%)
No	9 (0.6%)	0 (0%)	9 (0.9%)	0 (0%)
Otro	7 (0.5%)	1 (0.6%)	6 (0.6%)	0 (0%)
Por Definir	5 (0.3%)	0 (0%)	2 (0.2%)	3 (1.2%)
Porcelanato	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Tableta de Gress	3 (0.2%)	0 (0%)	3 (0.3%)	0 (0%)
Vinilo	12 (0.8%)	0 (0%)	12 (1.2%)	0 (0%)
Unknown	1	0	1	0
BathroomFlooring
Cemento	52 (3.6%)	39 (23%)	1 (<0.1%)	12 (4.8%)
Cemento Afinado	348 (24%)	0 (0%)	347 (34%)	1 (0.4%)
Ceramica	739 (51%)	67 (40%)	654 (63%)	18 (7.1%)
Falta Inf.	294 (20%)	62 (37%)	14 (1.4%)	218 (87%)
No	5 (0.3%)	0 (0%)	5 (0.5%)	0 (0%)
Otro	2 (0.1%)	1 (0.6%)	1 (<0.1%)	0 (0%)
Por Definir	11 (0.8%)	0 (0%)	8 (0.8%)	3 (1.2%)
Porcelanato	3 (0.2%)	0 (0%)	3 (0.3%)	0 (0%)
Unknown	1	0	1	0
KitchenFlooring
Cemento	149 (10%)	70 (41%)	53 (5.1%)	26 (10%)
Cemento Afinado	709 (49%)	0 (0%)	706 (68%)	3 (1.2%)
Ceramica	269 (19%)	36 (21%)	231 (22%)	2 (0.8%)
Falta Inf.	296 (20%)	62 (37%)	16 (1.5%)	218 (87%)
Madera Laminada	4 (0.3%)	0 (0%)	4 (0.4%)	0 (0%)
No	12 (0.8%)	0 (0%)	12 (1.2%)	0 (0%)
Otro	2 (0.1%)	1 (0.6%)	1 (<0.1%)	0 (0%)
Por Definir	11 (0.8%)	0 (0%)	8 (0.8%)	3 (1.2%)
Porcelanato	2 (0.1%)	0 (0%)	2 (0.2%)	0 (0%)
Unknown	1	0	1	0
KitchenWalls
Bloque	4 (0.3%)	0 (0%)	3 (0.3%)	1 (0.4%)
Cemento	2 (0.1%)	0 (0%)	0 (0%)	2 (0.8%)
Concreto	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Enchape 1/2 Altura	6 (0.4%)	0 (0%)	4 (0.4%)	2 (0.8%)
Enchape Salpicadero	225 (15%)	147 (87%)	67 (6.5%)	11 (4.4%)
Estuco	87 (6.0%)	1 (0.6%)	74 (7.2%)	12 (4.8%)
No	817 (56%)	1 (0.6%)	736 (71%)	80 (32%)
Otro	180 (12%)	0 (0%)	48 (4.6%)	132 (52%)
Pintura	124 (8.5%)	16 (9.5%)	97 (9.4%)	11 (4.4%)
Por Definir	8 (0.6%)	4 (2.4%)	3 (0.3%)	1 (0.4%)
Unknown	1	0	1	0
BathroomWalls
Enchape (C.D)	545 (37%)	0 (0%)	529 (51%)	16 (6.3%)
Enchape (Z.H)	807 (56%)	162 (96%)	429 (42%)	216 (86%)
Enchape 1/2 Altura	11 (0.8%)	0 (0%)	11 (1.1%)	0 (0%)
Enchape Salpicadero	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Enchape Total	12 (0.8%)	1 (0.6%)	11 (1.1%)	0 (0%)
No	72 (5.0%)	2 (1.2%)	50 (4.8%)	20 (7.9%)
Por Definir	6 (0.4%)	4 (2.4%)	2 (0.2%)	0 (0%)
Unknown	1	0	1	0
SinkCabinet
Falta Inf.	7 (0.5%)	7 (4.1%)	0 (0%)	0 (0%)
Formica	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Madecor	13 (0.9%)	0 (0%)	11 (1.1%)	2 (0.8%)
Materiales Aglomerados	2 (0.1%)	2 (1.2%)	0 (0%)	0 (0%)
Melamina	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
No	1,429 (98%)	160 (95%)	1,019 (99%)	250 (99%)
Por Definir	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Unknown	1	0	1	0
LaundryArea
Cemento	377 (26%)	87 (51%)	285 (28%)	5 (2.0%)
Fibra De Vidrio	140 (9.6%)	42 (25%)	91 (8.8%)	7 (2.8%)
Granito Pulido	858 (59%)	29 (17%)	607 (59%)	222 (88%)
No	52 (3.6%)	4 (2.4%)	37 (3.6%)	11 (4.4%)
Otro	9 (0.6%)	1 (0.6%)	3 (0.3%)	5 (2.0%)
Plastico	4 (0.3%)	0 (0%)	4 (0.4%)	0 (0%)
Por Definir	12 (0.8%)	6 (3.6%)	6 (0.6%)	0 (0%)
Porcelana Fria	2 (0.1%)	0 (0%)	0 (0%)	2 (0.8%)
Unknown	1	0	1	0
AirConditioning
Falta Inf.	62 (4.7%)	0 (0%)	2 (0.2%)	60 (53%)
No	1,241 (94%)	157 (93%)	1,031 (100%)	53 (47%)
Punto	12 (0.9%)	12 (7.1%)	0 (0%)	0 (0%)
Unknown	140	0	1	139
InteriorWalls
Bloque	393 (32%)	5 (3.0%)	384 (37%)	4 (15%)
Concreto	631 (51%)	96 (57%)	519 (50%)	16 (62%)
Falta Inf.	74 (6.0%)	68 (40%)	6 (0.6%)	0 (0%)
Ladrillo	117 (9.5%)	0 (0%)	112 (11%)	5 (19%)
No	2 (0.2%)	0 (0%)	1 (<0.1%)	1 (3.8%)
Por Definir	11 (0.9%)	0 (0%)	11 (1.1%)	0 (0%)
Unknown	227	0	1	226
MainBedroomToiletType
1 Pieza	30 (2.4%)	0 (0%)	28 (2.7%)	2 (8.0%)
2 Piezas	207 (17%)	101 (60%)	104 (10%)	2 (8.0%)
Falta Inf.	514 (42%)	68 (40%)	446 (43%)	0 (0%)
Instalaciones	11 (0.9%)	0 (0%)	2 (0.2%)	9 (36%)
No	464 (38%)	0 (0%)	452 (44%)	12 (48%)
Por Definir	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Unknown	228	0	1	227
ShowerWall
Ceramica	1,054 (86%)	98 (58%)	934 (90%)	22 (88%)
Estuco	41 (3.3%)	0 (0%)	40 (3.9%)	1 (4.0%)
Falta Inf.	82 (6.7%)	71 (42%)	11 (1.1%)	0 (0%)
Ladrillo	5 (0.4%)	0 (0%)	5 (0.5%)	0 (0%)
No	36 (2.9%)	0 (0%)	34 (3.3%)	2 (8.0%)
Por Definir	8 (0.7%)	0 (0%)	8 (0.8%)	0 (0%)
Porcelanato	1 (<0.1%)	0 (0%)	1 (<0.1%)	0 (0%)
Unknown	228	0	1	227
SinkFaucetType
Convencional	1,059 (86%)	81 (48%)	961 (93%)	17 (68%)
Falta Inf.	86 (7.0%)	72 (43%)	14 (1.4%)	0 (0%)
Monocontrol	53 (4.3%)	16 (9.5%)	33 (3.2%)	4 (16%)
No	16 (1.3%)	0 (0%)	12 (1.2%)	4 (16%)
Por Definir	13 (1.1%)	0 (0%)	13 (1.3%)	0 (0%)
Unknown	228	0	1	227
ShowerFaucetType
Convencional	1,080 (88%)	93 (55%)	965 (93%)	22 (88%)
Falta Inf.	87 (7.1%)	71 (42%)	16 (1.5%)	0 (0%)
Monocontrol	29 (2.4%)	5 (3.0%)	24 (2.3%)	0 (0%)
No	16 (1.3%)	0 (0%)	13 (1.3%)	3 (12%)
Por Definir	15 (1.2%)	0 (0%)	15 (1.5%)	0 (0%)
Unknown	228	0	1	227
OtherBathroomsToiletType
1 Pieza	19 (1.5%)	0 (0%)	12 (1.2%)	7 (28%)
2 Piezas	895 (73%)	13 (7.7%)	868 (84%)	14 (56%)
Falta Inf.	86 (7.0%)	71 (42%)	15 (1.5%)	0 (0%)
Instalaciones	53 (4.3%)	50 (30%)	1 (<0.1%)	2 (8.0%)
No	162 (13%)	35 (21%)	125 (12%)	2 (8.0%)
Por Definir	12 (1.0%)	0 (0%)	12 (1.2%)	0 (0%)
Unknown	228	0	1	227
SinkType
Convencional	1,000 (81%)	98 (58%)	884 (86%)	18 (72%)
Falta Inf.	88 (7.2%)	71 (42%)	17 (1.6%)	0 (0%)
Incrustar	61 (5.0%)	0 (0%)	60 (5.8%)	1 (4.0%)
No	8 (0.7%)	0 (0%)	6 (0.6%)	2 (8.0%)
Pedestal	39 (3.2%)	0 (0%)	35 (3.4%)	4 (16%)
Por Definir	10 (0.8%)	0 (0%)	10 (1.0%)	0 (0%)
Sobreponer	21 (1.7%)	0 (0%)	21 (2.0%)	0 (0%)
Unknown	228	0	1	227
ShowerType
Convencional	1,117 (91%)	101 (60%)	995 (96%)	21 (84%)
Falta Inf.	82 (6.7%)	68 (40%)	14 (1.4%)	0 (0%)
No	14 (1.1%)	0 (0%)	11 (1.1%)	3 (12%)
Plato	4 (0.3%)	0 (0%)	3 (0.3%)	1 (4.0%)
Por Definir	10 (0.8%)	0 (0%)	10 (1.0%)	0 (0%)
Unknown	228	0	1	227
KitchenSinkFaucetType
Convencional	1,038 (85%)	77 (46%)	942 (91%)	19 (76%)
Falta Inf.	86 (7.0%)	68 (40%)	18 (1.7%)	0 (0%)
Monocontrol	53 (4.3%)	24 (14%)	25 (2.4%)	4 (16%)
No	37 (3.0%)	0 (0%)	35 (3.4%)	2 (8.0%)
Por Definir	13 (1.1%)	0 (0%)	13 (1.3%)	0 (0%)
Unknown	228	0	1	227
1 n (%); Mean (Minimum, Median, Maximum)

Appendix 2: Full List of Included Municipalities, Projects and Units

Included Municipalities Bolded, Excluded Not Bold

City	Municipality	Count
Barranquilla	Barranquilla	67
Barranquilla	Galapa	3
Barranquilla	Malambo	2
Barranquilla	Soledad	97
Bogota	Bogota	538
Bogota	Cajicá	11
Bogota	Chía	12
Bogota	Facatativa	22
Bogota	Funza	22
Bogota	Gachancipá	9
Bogota	La Calera	7
Bogota	Madrid	50
Bogota	Mosquera	41
Bogota	Nemocon	2
Bogota	Soacha	283
Bogota	Sopó	2
Bogota	Tabio	2
Bogota	Tenjo	1
Bogota	Tocancipá	20
Bogota	Zipaquirá	39
Medellin	Bello	50
Medellin	Caldas	5
Medellin	Copacabana	9
Medellin	El Carmen de Viboral	3
Medellin	Envigado	3
Medellin	Girardota	3
Medellin	Guarne	2
Medellin	Itagüí	13
Medellin	La Ceja	11
Medellin	La Estrella	8
Medellin	La Union	1
Medellin	Medellin	143
Medellin	Rionegro	17
Medellin	Sabaneta	11
Medellin	Santa Fé de Antioquia	1
Medellin	Sopetrán	3

Appendix 3: Projects and Units by Builder and City

Projects and Units By Builder and City

City	Constructor	Projects	Units
Barranquilla	Const. Bolivar	32	16,018
Barranquilla	Marval	21	10,140
Barranquilla	Villa Linda	13	2,163
Barranquilla	Amarilo	10	4,632
Barranquilla	Prodesa	6	3,192
Barranquilla	ACF SAS	5	6,520
Barranquilla	Urbamoras	5	1,098
Barranquilla	Const. G.P.P.	4	243
Barranquilla	Alejandro Char	3	1,759
Barranquilla	Castro Panesso	3	2,323
Barranquilla	Conaco	3	1,008
Barranquilla	Coninsa Ramon H.	3	574
Barranquilla	Cusules	3	489
Barranquilla	Obycon	3	1,216
Barranquilla	Valorcon	3	3,337
Barranquilla	Alas Diseño y Const.	2	248
Barranquilla	Balcones de la Colina	2	345
Barranquilla	Conaltura	2	1,080
Barranquilla	Const. Colpatria	2	1,216
Barranquilla	Fund. Mario Santodomingo	2	1,793
Barranquilla	Funprodec Habitat	2	1,140
Barranquilla	Grama Const.	2	2,080
Barranquilla	Mi Hogar	2	501
Barranquilla	A.R. Const.	1	200
Barranquilla	AG Constructora SAS	1	320
Barranquilla	Alvarez Lascano	1	170
Barranquilla	Arq. & Concreto	1	316
Barranquilla	BSJ Construcciones	1	384
Barranquilla	Block Inm.	1	80
Barranquilla	Cohala Construcciones	1	160
Barranquilla	Comfamiliar del Atlantico	1	202
Barranquilla	Conconcreto	1	290
Barranquilla	Const. D&B	1	160
Barranquilla	Const. E Inv. Badie	1	23
Barranquilla	Const. E Inv. Beta	1	140
Barranquilla	Const. E Inv. Trifer	1	532
Barranquilla	Const. L.G.	1	24
Barranquilla	Const. Pubenza.	1	95
Barranquilla	Convel	1	144
Barranquilla	Convias	1	240
Barranquilla	Deinca	1	260
Barranquilla	Fundacovis	1	35
Barranquilla	Gerardo Espinosa y Cia.	1	115
Barranquilla	Guadix Inversiones	1	140
Barranquilla	H.G. Const.	1	160
Barranquilla	Inacar	1	394
Barranquilla	Inv. Andrade y Angulo	1	258
Barranquilla	Inv. Oyaga	1	91
Barranquilla	Inversiones C.B.S.	1	306
Barranquilla	Ivesur Colombia	1	60
Barranquilla	Jaime Arango Robledo	1	50
Barranquilla	Macarlu	1	160
Barranquilla	Mas House	1	384
Barranquilla	Maya y Asoc.	1	438
Barranquilla	Metropoli	1	256
Barranquilla	Prom. Los Nogales	1	398
Barranquilla	Union Temporal Ciudad Verde	1	600
Barranquilla	Unisocial	1	269
Barranquilla	Urb. Metropolitana	1	975
Bogota	Const. Bolivar	124	61,430
Bogota	Amarilo	70	24,684
Bogota	Apiros	60	36,488
Bogota	Prodesa	40	17,770
Bogota	Const. Capital	38	20,381
Bogota	Const. Las Galias	38	28,448
Bogota	Marval	38	16,885
Bogota	Urbansa	27	11,103
Bogota	Triada	23	7,476
Bogota	Const. Colpatria	21	9,116
Bogota	Ingeurbe	21	9,402
Bogota	Mendebal	19	9,627
Bogota	A.R. Const.	18	11,897
Bogota	Cusezar	15	4,513
Bogota	Inv. Alcabama	15	8,154
Bogota	Norco	14	6,757
Bogota	Buenvivir Cons.	13	8,245
Bogota	Fund. Compartir	13	4,501
Bogota	Grupo Construmax	13	3,474
Bogota	Obreval	11	3,832
Bogota	C.A.S.A	9	2,228
Bogota	Obycon	9	3,228
Bogota	Vavilco	9	3,048
Bogota	Bioconstrucciones	8	2,547
Bogota	Coninsa Ramon H.	8	3,338
Bogota	Los Sauces Construcciones	8	3,550
Bogota	Maeco	8	2,434
Bogota	Arq. & Concreto	7	5,550
Bogota	Incol/Laterizio	7	2,736
Bogota	Tenco	7	2,183
Bogota	Const. C.E.P.	6	588
Bogota	Inacar	6	1,068
Bogota	Suprema Inm.	6	2,382
Bogota	Tenco/Maz Proyectos Inm.	6	2,556
Bogota	Colsubsidio	5	1,725
Bogota	Grupo Solerium	5	1,018
Bogota	Prom. Convivienda	5	2,325
Bogota	Cumbrera	4	1,372
Bogota	I.C. Const.	4	888
Bogota	Incol	4	871
Bogota	Nodos	4	1,016
Bogota	Prabyc	4	2,812
Bogota	Prom. Vivendum	4	1,109
Bogota	Ampitec	3	371
Bogota	Arpro Const.	3	1,074
Bogota	CFC & A Const.	3	610
Bogota	Caminos Inm.	3	494
Bogota	Coandes	3	729
Bogota	Comerc. S.F.S.	3	451
Bogota	Conaltura	3	568
Bogota	Const. Lares	3	411
Bogota	Const. Nemesis	3	1,906
Bogota	Const. Normandia	3	1,360
Bogota	Desarrollos Urbanos	3	312
Bogota	Gerinco	3	1,464
Bogota	Gutierrez Faccini	3	1,414
Bogota	Habitus Const.	3	1,174
Bogota	Independiente	3	64
Bogota	Inv. Boyaca	3	640
Bogota	Oikos	3	896
Bogota	Soc. Const. Bogota	3	680
Bogota	Socovis	3	368
Bogota	Soluciones Inm.	3	708
Bogota	Uraki Const.	3	354
Bogota	Balcones de Iguazu	2	324
Bogota	C. G. Const.	2	508
Bogota	C.N.V. Consts.	2	441
Bogota	Casa Activa	2	429
Bogota	Const. Agora	2	490
Bogota	Const. Alcaparros	2	903
Bogota	Const. Arawak	2	565
Bogota	Const. Bosques del Oriente	2	48
Bogota	Const. J y G	2	680
Bogota	Const. Ormiga	2	544
Bogota	Const. Robles Rodriguez	2	242
Bogota	Const. Sevillana	2	429
Bogota	Const. Ulloa	2	1,216
Bogota	Construactiva	2	492
Bogota	Conurbes	2	99
Bogota	ICI	2	526
Bogota	Inv. Edecios	2	2,774
Bogota	Inv. Monsalve	2	46
Bogota	Korner Arquitectura y Construccion	2	785
Bogota	Kuman	2	418
Bogota	Lagos de Malibu	2	583
Bogota	Opus Const.	2	137
Bogota	Petropolis	2	298
Bogota	Polaris Const.	2	439
Bogota	Prom. Caledonia	2	1,181
Bogota	Tecnourbana	2	333
Bogota	Territorio	2	516
Bogota	Urbanistika	2	863
Bogota	Urbatek	2	49
Bogota	V2K Constructora	2	1,282
Bogota	Vindico	2	453
Bogota	A.V.P. Aso. de Viv.	1	252
Bogota	AH Siscon	1	36
Bogota	Acierto Inm.	1	220
Bogota	Albina Construcciones	1	24
Bogota	Ambientti	1	148
Bogota	Angel Diaz	1	300
Bogota	Apotema	1	168
Bogota	Area Cuadrada	1	94
Bogota	Arketia	1	204
Bogota	Arquingo Ing.	1	14
Bogota	Asoc. Caminos de Esp.	1	410
Bogota	Avintia	1	384
Bogota	BP Const.	1	180
Bogota	CG Constructora	1	352
Bogota	CMS + GMP	1	428
Bogota	CMS + GMP/Arpro Const.	1	2,108
Bogota	Canales Desarrolladores	1	100
Bogota	Caninde	1	624
Bogota	Codisplan	1	143
Bogota	Compensar	1	112
Bogota	Conconcreto	1	528
Bogota	Conigsa	1	1,300
Bogota	Cons. Edificar	1	140
Bogota	Consor. Vis Vip Sibate	1	940
Bogota	Const. Alonso & Rodriguez	1	32
Bogota	Const. Aprix	1	90
Bogota	Const. Arpreco	1	45
Bogota	Const. Avanza S.A.S	1	35
Bogota	Const. Bariloche	1	764
Bogota	Const. Beracca	1	576
Bogota	Const. Crisalida	1	24
Bogota	Const. Edificar 2000	1	42
Bogota	Const. Flormorado	1	285
Bogota	Const. Forteza	1	110
Bogota	Const. Gran Terra	1	144
Bogota	Const. Imperius	1	8
Bogota	Const. Incor	1	231
Bogota	Const. Kadas	1	230
Bogota	Const. Muraglia	1	280
Bogota	Const. Parque Central	1	192
Bogota	Const. Planificadas	1	400
Bogota	Const. RMG	1	241
Bogota	Const. Reserva del Alamo	1	176
Bogota	Const. San Cristobal	1	114
Bogota	Const. Solar	1	96
Bogota	Const. Torres de Lucerna	1	660
Bogota	Construcciones Crear S.A.S	1	50
Bogota	Construcciones Zabdi	1	192
Bogota	Construcrear	1	56
Bogota	Construimos UT	1	85
Bogota	Construlinea	1	47
Bogota	Convel	1	760
Bogota	Convinor	1	100
Bogota	Covitotal	1	946
Bogota	Delta Proyectos	1	68
Bogota	Desarro. Integ. De proy.	1	75
Bogota	Desproing	1	272
Bogota	Digeniar Const.	1	43
Bogota	Eco	1	60
Bogota	Ecosur	1	432
Bogota	Edifisa	1	84
Bogota	Espacios e Ideas	1	313
Bogota	Fdo. de Inver. Inm.	1	244
Bogota	Fernando Mazuera	1	766
Bogota	Flor Const.	1	156
Bogota	Fores	1	84
Bogota	Forjar Inv.	1	471
Bogota	Fortaleza Const.	1	99
Bogota	Fund. Construimos	1	120
Bogota	Grupo ICO	1	168
Bogota	Grupo Valor Colombia	1	512
Bogota	Guimar Const.	1	23
Bogota	Horizonte 2000	1	275
Bogota	IA Constructores	1	32
Bogota	IDC Const.	1	408
Bogota	Impulsa Colombia	1	460
Bogota	Ingenal	1	264
Bogota	Ingeosin	1	18
Bogota	Ingges	1	336
Bogota	Inv. B D P	1	666
Bogota	Inv. Bosque Izquierdo	1	104
Bogota	Inv. Cargil S.A.	1	48
Bogota	Inv. Dipreca	1	72
Bogota	Inv. G.V.M	1	30
Bogota	Inv. Huertas	1	294
Bogota	Inv. Miv. SA	1	236
Bogota	Inv. Sekanias	1	716
Bogota	Inv. Y Proyectos Andico	1	192
Bogota	Inv. la Castellana	1	296
Bogota	Inver Casa	1	105
Bogota	Investpro	1	93
Bogota	Isarco/Toro Ortiz	1	556
Bogota	JDS Grupo Construccion	1	51
Bogota	Julio C. Guerrero y Arq. Ltda	1	96
Bogota	K & E Const.	1	70
Bogota	M&C Diseño	1	36
Bogota	M+D Const.	1	168
Bogota	MYH Ingenieros	1	384
Bogota	Mansol Const.	1	143
Bogota	Maz Proyectos Inm.	1	408
Bogota	Megaconstrucciones MB	1	410
Bogota	Milan Des. Inmob.	1	616
Bogota	Ormeco	1	100
Bogota	Ospinas	1	406
Bogota	Pedro Gomez	1	198
Bogota	Pixel Living	1	50
Bogota	Poli Urbe	1	243
Bogota	Por Definir	1	432
Bogota	Prodesic	1	52
Bogota	Proinsa	1	180
Bogota	Prom. de Proyectos	1	10
Bogota	Prom. de Vivienda Sevilla	1	228
Bogota	Prominsa	1	82
Bogota	Proy. HG	1	80
Bogota	Proyectar	1	300
Bogota	Quira	1	340
Bogota	R.D.N. Asociados	1	71
Bogota	RCH Const.	1	43
Bogota	Rios Duarte	1	83
Bogota	SENY	1	68
Bogota	SP Arquitectos	1	32
Bogota	Segura M y Cia	1	22
Bogota	Sigma Ing y Cons.	1	150
Bogota	Sistema Integral Inm.	1	84
Bogota	Soluciones Bochica	1	240
Bogota	Strukto 38	1	40
Bogota	Urbal	1	47
Bogota	Urbana 2020	1	85
Bogota	Urbark	1	144
Bogota	Vanguardia Inm.	1	456
Bogota	Vector Const.	1	372
Bogota	Villa Daniela	1	152
Bogota	Vinculo Urbano	1	24
Bogota	Vivarco	1	789
Bogota	Zoom Const.	1	102
Medellin	Conaltura	24	10,158
Medellin	Const. Capital	23	9,775
Medellin	Grupo CDO	9	1,892
Medellin	Mensula	8	3,801
Medellin	Optima	7	1,908
Medellin	Acierto Inm.	6	4,296
Medellin	Bienes y Bienes	6	1,881
Medellin	C.A.S.A	5	1,135
Medellin	Coninsa Ramon H.	5	1,064
Medellin	Covin	5	2,622
Medellin	Valoriza Const.	5	931
Medellin	AEI Const.	4	1,974
Medellin	C.I.V. Const.	4	468
Medellin	Coactuar	4	210
Medellin	Conconcreto	4	998
Medellin	Const. Entreverdes	4	3,229
Medellin	Const. Peso	4	196
Medellin	Apic de Colombia	3	375
Medellin	Const. Monserrate	3	1,103
Medellin	Creativa DC	3	471
Medellin	Giraldo Alzate Constructora	3	136
Medellin	ISC Inserco	3	1,574
Medellin	Obrasde	3	1,829
Medellin	Prom. Escala	3	887
Medellin	Proyeco	3	390
Medellin	Sol. Civiles	3	1,102
Medellin	Acca Const.	2	336
Medellin	Arq. & Concreto	2	441
Medellin	Asoc. de Vivienda Torre Libertadores	2	152
Medellin	Cefraco	2	416
Medellin	Concepto Ingenieria	2	608
Medellin	Const. Prohogar	2	1,554
Medellin	Contex	2	822
Medellin	Fund. Compartir	2	600
Medellin	GIC Gerencia Inter y Consultoria	2	606
Medellin	Incil	2	722
Medellin	Indec	2	266
Medellin	Inv. Lina Maria	2	622
Medellin	Jorge Gonzalez Ings.	2	2,022
Medellin	PSI Edicreto	2	791
Medellin	Sohinco	2	812
Medellin	Viviendas de Colombia	2	124
Medellin	A.I.A.	1	396
Medellin	Asfalto y Hormigon	1	252
Medellin	Axor Ing.	1	1,720
Medellin	Bepamar Constructora de Obras	1	184
Medellin	C.I Del Sur	1	480
Medellin	Calculos y Construcciones	1	135
Medellin	Comfama	1	608
Medellin	Conatum	1	200
Medellin	Conhabitat	1	45
Medellin	Conhogar	1	114
Medellin	Conmesetas	1	70
Medellin	Consor. Ciudadela Antioquia	1	100
Medellin	Consor. Los Pinos	1	37
Medellin	Consorcio Moras	1	192
Medellin	Const. Centro Sur	1	120
Medellin	Const. Concypa	1	1,900
Medellin	Const. GADA	1	157
Medellin	Const. Galapagos S.A.	1	80
Medellin	Const. Riva S.A.	1	24
Medellin	Const. SAS	1	72
Medellin	Const. Soporte	1	700
Medellin	Constructora JIPG	1	235
Medellin	Consts. Civiles Cervantes	1	98
Medellin	Covian	1	54
Medellin	Desarrollos Inm.	1	84
Medellin	Estructurar	1	250
Medellin	Fabricasas	1	344
Medellin	Finanzas y Proy.	1	184
Medellin	Fund. Monem	1	85
Medellin	Garces y Jaramillo	1	35
Medellin	Gerinsa Gerencia Inm.	1	59
Medellin	Gestion Inm.	1	56
Medellin	HH Grupo Empresarial	1	239
Medellin	Hc Inv. y Const.	1	504
Medellin	Indeco	1	374
Medellin	Indresfer	1	20
Medellin	Ing. y Vivienda	1	766
Medellin	Ingral	1	78
Medellin	Innobilia	1	404
Medellin	Inv. Inm. Total	1	562
Medellin	Inverlaureles	1	30
Medellin	Jahem Constructora	1	420
Medellin	Jardines	1	104
Medellin	Manatiales Propiedad Raiz	1	120
Medellin	Mivsa	1	752
Medellin	Obras y Terrenos	1	354
Medellin	Pactar	1	688
Medellin	Perfek	1	134
Medellin	Porticos	1	72
Medellin	Profesionales en Concreto	1	70
Medellin	Prom. Erraga	1	702
Medellin	Prom. de Proy. Robledo	1	412
Medellin	Prom. del Rio	1	560
Medellin	Proy. de Const. de Viviendas	1	97
Medellin	Rios Const.	1	214
Medellin	S.G. Prop. Raiz	1	64
Medellin	SP Inmobiliaria	1	186
Medellin	Solucion Vivienda Social	1	150
Medellin	Suramerica Const.	1	320
Medellin	Torre La Vega del Sur	1	516
Medellin	Tree Group	1	20
Medellin	U.P.L.	1	120
Medellin	Urbana de Proyectos	1	88
Medellin	Urco	1	410
Medellin	Viviendas Financiadas Constructora de Obras	1	90
Medellin	Viviendas del Norte	1	324

Appendix 4: VIS By City

## `summarise()` has grouped output by 'City', 'Completion_Date'. You can override
## using the `.groups` argument.

Type of VIS by City and Year

City	Completion_Date	Vis/	Vipa/	Vip /	Vis Renov./
Barranquilla	2008	1,975
Barranquilla	2009	622
Barranquilla	2010	214
Barranquilla	2011	1,596
Barranquilla	2012	2,199
Barranquilla	2013	2,264
Barranquilla	2014	664
Barranquilla	2015	814	318
Barranquilla	2016	280	3,300
Barranquilla	2017	2,321	3,265
Barranquilla	2018	1,328	760	249
Barranquilla	2019	3,511	920	1,200
Barranquilla	2020	4,350		3,895
Barranquilla	2021	4,419		6,202
Barranquilla	2022	8,841		1,460	247
Barranquilla	2023	8,770		5,960
Bogota	2007	1,135
Bogota	2008	3,142
Bogota	2009	14,569
Bogota	2010	20,098
Bogota	2011	28,781
Bogota	2012	34,269
Bogota	2013	28,764		1,836
Bogota	2014	29,403		2,716
Bogota	2015	25,425	5,408	3,088
Bogota	2016	27,972	1,892	624
Bogota	2017	21,669	6,585	384
Bogota	2018	19,046		2,572
Bogota	2019	21,759		666
Bogota	2020	29,008		202	309
Bogota	2021	28,975		1,379	900
Bogota	2022	28,818		1,104	338
Bogota	2023	27,241		281	2,036
Medellin	2007	258
Medellin	2008	1,227
Medellin	2009	4,414
Medellin	2010	4,131
Medellin	2011	4,782			990
Medellin	2012	5,754
Medellin	2013	4,512
Medellin	2014	3,597
Medellin	2015	5,108
Medellin	2016	4,050
Medellin	2017	5,893
Medellin	2018	5,123
Medellin	2019	10,875
Medellin	2020	2,770
Medellin	2021	6,961
Medellin	2022	9,511
Medellin	2023	4,377