Home Colombia Forum Colombia Guide Moving to Colombia Real Estate Healthcare in Colombia
Plaza de Bolivar in Bogota
Colombia
Resources
City Guides
Plaza de Bolivar in Bogota
JoinSign In

Living in Colombia > Bogota > 10 Tips for Living in Bogota

10 Tips for Living in Bogota

By Betsy Burlingame

Last updated on: Dec 07, 2016

Expats offer advice for others considering a move to Bogota, Colombia. Topics include safety in Bogota, best neighborhoods for expats, international schools in Bogota and more.

Safety in Bogota

"Like any big city Bogota can be dangerous... but I find it no more dangerous than NYC for example. Colombia as a whole is safe but there are some areas that at you don't go to. The expat community is larger in Bogota than other cities but I find there is little socializing between the expats. Most of my friends are Colombian," described one expat living in Bogota. Another expat living in Bogota said, "I always hail cabs off the street with no issues. Use common sense, don't carry too much cash, passport, or credit cards on you. It is very seldom you need your passport or cards here so only take them when needed. It doesn't hurt to have some self-defense training, too. Thugs pick off the weaker, easy targets. I know for a fact I've been sized up a few times, but I walk around alert and will stare back at anyone giving me the eye and they will always back down. Those bad elements search out easy fast prey so just keep your eyes open and keep alert. Don't walk around with your head glued to your cell, and avoid speaking in English in public so as not to draw attention to yourself until you feel comfortable." Another expat said, "I lived in Bogota for 19 months, and I called for taxis at night, to the airport, or long distances, like to Corferias or Santa Fe. I rode the TM twice - too crowded for me. During the day, I had no problem grabbing a taxi on the street. You must be able to give the address in Spanish. A few of the drivers speak some English, but don't count on it. (I'm female, light-skinned with blue eyes. No way they could have mistaken me for Colombian!) I did this only during the day, and only where I knew the area. It is safe to travel in groups at night, but call for the taxi. I spoke English sometimes, several drivers enjoyed practicing their English skills and learning what I liked about living in Bogota. I got to practice my Spanish as well! Do not underestimate the possibility of theft. Leave valuables at home. No big jewelery or fancy cell phones. I carried my "flecha" to make calls with. I carried a mochilla most places, not the big purses many women use. Maybe they thought I was poor! My Colombian friends also warned me often about safety. Use common sense, stay away from unsafe areas, keep valuables at home, speak the language. I never felt threatened or in danger." Another said, "just about everyone I know has been robbed at some point, on the street, in TransMillenio, or in a taxi."

Jobs in Bogota

An expat in Bogota said, "Teaching jobs are easy to come across. El Tiempo news paper." Teaching in private schools is recommended. One expat said, "Teachers typically make minimum wages at public schools. Private school teachers typically have their masters degrees and are well educated." Another expat who taught in Bogota cautioned, "Absolutely do not go public. I taught for a year in a private school and lived there for over a year and a half learning about the culture. Private is the only way to go, and the prices you quote are reasonable." Another English teacher said, "I moved to Bogota eight months ago, job in hand. However, I am a certified English teacher; finding a job at a bilingual school was fairly easy for me. If you are looking at teaching here in Colombia. there are some requirements. I did not need a TEFL, although I have been told it would be good to have regardless. Make sure you get a visa that allows you to work."

Schools in Bogota

An expat whose children attend Colegio Gran Bretana in Bogota advised, "do seriously consider this school, especially if your child is from an English-speaking country. Almost all of the Secondary teachers are native English speakers from Australia, the UK, the US, etc... So, the school's English programs are top notch. The teachers are stellar, the academics challenging, and the community welcoming and diverse." There are other schools, such as Colegio Los Nogales, Knightsbridge Schools International in Bogota and The English School.

What to Bring to Bogota

"Word of advice -- pay the extra bag fees and bring your stuff with you. $50 for an extra 50 pound bag or $80-100 for a tiny box to be shipped here weighing around 20 pounds. I wish I had just brought my extra stuff with me. You can use the post office website to calculate your shipping cost," advised an expat in Bogota. Another expat said, "I shipped approximately 35 large boxes, to include my mattresses, but wish I had brought alot more stuff. I would not have brought my refrigerator, but definitely the washer and dryer. Appliances cost approximately twice as much in this country. I believe you have 90 days from the date you enter Colombia to ship your household goods to Colombia."

Weather in Bogota

Climate is also an individual thing. I actually like Bogota. Coming from England, I find it is like a Spring day, all year round. I am not too hot, and not too cold. Most of the time I wear simple Polo or T-shirts, and I feel absolutely comfortable. If I want a little more heat, I simply drive down the mountains, and within a couple of hours can be in 30-40 degrees, but 3 or 4 days is enough for me .

Best Bogota Neighborhoods for Expats

An expat advised, "I know Bogota is a great city with a lot cultural events. It has several nice malls and shopping center. You need to live in the north part of the city like El Chico and similar areas. Bogota is safer than many cities in U.S. Restaurants and night life are great. Christmas is an incredible time with fantastic decorations and lights everywhere. Cali is hot and humid, but nice and smaller than Bogota." Another said, "I like the Los Nogales and Santa Barbara neighborhoods; Los Nogales is accessible to downtown; Santa Barbara is more north, near everyone's favorite mall," UniCentro. One expat in Bogota wrote at length about the best neighborhoods, "I can only talk with confidence about this city. So if you are looking at Bogota, then I must say, avoid anywhere in the south. The best areas are to the north, and from my own experience, areas like Mazuren and Cedritos are excellent in terms of safety, standards and quality of life and its residents, whilst still remaining reasonable pricewise. Don't go too far north though, or northwest, for the rapid pace of development continues, and what is now on the edge of the city will be swallowed up by development, and you'll find yourself in the middle of a concrete jungle in a few years. At least they can't build much more to the east of Mazuren or Cedritos, as the mountains prevent that, so you will always be near the edge of the city without having to commute for hours. (Commuting is crap). Both areas mentioned are very close to the Transmilenio, a rapid articulated bus service that has its own designated carriageways, so is fast, and cheap, too, but gets somewhat crowded in rush hour. In just 14 years, my in-laws property, near calle 150, was actually on the northern edge of the city, but now, I think the streets go up to calle two hundred-ish, and still going up. Also, Suba, to the northwest was actually a separate town, and Chia too. Now the expansion has simply gone around them, and they have been swallowed in urban development. Chia is still a separate town, but is suffering the same. Like I said, they can't build much more to the east, so you shouldn't get swallowed up in non-stop development."

Adjusting to the Altitude in Bogota

"Bogota is up high in the mountains, so if you aren't used to the altitude be sure to allow yourself 2 or 3 days to adjust and try to find yourself some coca tea to help. Getting dizzy all of a sudden or falling asleep while your walking can be a hazard -- as can taking taxis off the street without calling on the phone for one," advised one expat.

Gated Communities vs. Conjunto Cerrados

An insightful discussion about gated communities and conjunto cerrados took place on the Colombia forum. One expat said, "As I have always understood it, a gated community is rather more isolationist, where people can live without even going out of the complex. Everything they could need for living, will usually be found on the site, and the residents can live without necessarily mixing with the natives, and keeping themselves very much unto themselves. I understand that in some countries, they are particularly attractive to older residents, much like "old people's homes", but in their own property, living alongside other elderly people. This type of lifestyle is the one where I am opposed to the concept, and personally wouldn't like to live in one, as it really does segregate you from the rest of society. But there are also "conjunto cerrados," which are developments of maybe a few tower blocks, maybe a few blocks of houses, all surrounded by a nice fence to keep unwanted intruders out, and there is usually a security guy on the gate. This allows the residents to live in a safer way than if they were a simple tower block or house on the open street, but of course, they are not totally self sufficient or isolationist at all. You have to go to work, you have to do your shopping, the kids go to school in the normal manner, and all normal life is outside of the gates, which encourages you to mix with, and interact with the local population. But of course, by its nature, it is a lot safer for the kids to play outside, knowing that they won't be able to get out, or intruders able to get in. The danger of traffic too, is diminished, so the kids can ride their bikes etc, in safety."

Another expat shared his experiences, "A lot of great point of views. I don't know a great deal about communities outside of my own city. But I live in a gated community (condos). I have a son (but 18 months old) and feel very comfortable that everyone in our community knows him, drives by slow and we all watch out for each other, like a big dysfunctional family. If we did move I would prefer moving to another gated community just for the added piece of mind of not having people speed past my home or vagrants walking through. I feel it is much safer from aggressive type crimes but there have been 2 brake ins in the past 3 years. Not too bad in my opinion."

Driving in Bogota

"Have a car by all means, but do take a bus from time to time, or the Transmilenio, even in the rush hour, where you get shoved into a bus like sardines. It's part of normal living for Colombians, and so it should be for you too. In fact, if you choose Bogota, you won't be able to use your car for half the week anyway, as they have a scheme (Pico Y Placa) where certain number plates are not allowed on the roads at peak periods (rush hour)," explained an expat living in Bogota. Another expat reiterated, "driving in Bogota is more like an amusement park ride. I take taxis - don't have a car yet. Lines in the road are guidelines, motorcycles make their own lanes between cars, and everyone moves over when cars and busses pass each other over a double yellow line. They have a tendency not to stop for ambulances. Traffic is bad. Most major cities have pico y placa - allowing you to drive your car on certain days."

Opening a Bank Account in Bogota

In his article, Expat Life in Colombia, John Douglas wrote, "another issue is a need for personal references in Colombia, necessary for opening a bank account or establishing a rental contact. Generally, one needs a "backup" person who would be willing to sign their name to a rental agreement and continue payments should the tenant default. It is a good idea to open a bank account as well, but not all banks will allow non-residents to do so. Thus, ask about the requirements from any of the many banks in Colombia. There are no US based banks in Bogota but there are banks headquartered in other countries with a presence in the US and Colombia.

Cigna Expat Health InsuranceExpatriate Health Insurance

Get a quote for expat health insurance in Colombia from our partner, Cigna Global Health.
Get a Quote

More about Bogota

Healthcare in Colombia

Healthcare in Colombia

Our guide to healthcare in Colombia covers public and private healthcare in Colombia, hospitals, vaccinations, prescription medications and more.

Culture Shock in Bogota

An expat in Bogota, Colombia provides some perspective on the process of settling into the Colombian culture, and the value of having lived abroad before.

Culture Shock in Bogota

A woman who was born in Colombia and left when she was four years old moved back 58 years later to search for a place to retire. The challenges for her are getting a better grip on the language, making friends, learning to pace herself, and being patient and tolerant.

Join our Colombia Expat Forum

Visit our Colombia Forum and talk with other expats who can offer you insight and tips about living in Bogota, Colombia.

More about Colombia

10-Tips-for-Living-in-Colombia10 Tips for Living in Colombia

Colombia is an up-and-coming expat destination. With it's low cost of living, and wonderful people, Colombia has a lot to offer.

6-Best-Places-to-Live-in-Colombia6 Best Places to Live in Colombia

Colombia has made an incredible transformation. Expats in Colombia have a lot to say about the best places to live in Colombia. From cities on the Caribbean coast to inland cities, here are 6 of the best places to live in Colombia.

9-Tips-for-Buying-Property-in-Colombia9 Tips for Buying Property in Colombia

Expats in Colombia share insightful tips for buying property in Colombia. If you're thinking about buying real estate in Colombia, there is much to learn from their experiences.

12-Important-Tips-about-Healthcare12 Important Tips about Healthcare for Expats in Colombia

Expats in Colombia share experiences with the Colombian healthcare system. Tips cover EPS, quality of medical care, hospital stays and more.

About the Author

Betsy Burlingame Betsy Burlingame is the Founder of Expat Exchange. She launched Expat Exchange in 1997 as her Master's thesis project at NYU. Some of Betsy's more popular articles include 6 Best Places to Live in Costa Rica, 12 Things to Know Before Moving to The Dominican Republic and 7 Tips for Obtaining Residence in Italy. Betsy loves to travel and spend time with her family. Connect with Betsy on LinkedIn.

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Comments about this Article

BrendanCorrigan
May 5, 2014 11:24

For more info on Bogotá and Colombia in general, check out http://blogs.eltiempo.com/wrong-way-corrigan/ and www.wwcorrigan.blogspot.com.

Andresd7
Nov 29, 2014 01:59

When visiting Bogota, DO NOT stay in La Candelaria where most hostals are located. I being Colombian find it VERY IRONIC that most foreigners stay in La Candelaria.There are many nice neighborhoods to stay in that feel a lot safer at night. DO NOT stay in the center or South of the city, The center/La Candelaria is an interesting area to visit during the day, cultural events, bohemian, etc. I spend a lot of time there for events but it gets dodgy/sketchy late at night. At night, many junkies from the crime pockets start wandering into the center of the city. I often see clean-looking Colombians rushing to get out of La Candelaria late at night to avoid getting robbed while foreigners who stick-out like sore thumbs are staying there. What the hell!? As I mentioned, there are many nice neighborhoods to stay in. Try Airbnb, etc. Colombians are extremely friendly and will give you tips about places to visit, there are also beautiful suburban/country-side areas outside of Bogota that many Bogota-residents frequent. Go to language exchange groups and get info from locals, but don´t stay in La Candelaria. I am a local and I´m telling you this with all honesty, I´m just trying to save some face and doing what I can so that people visitng my country enjoy it, so stop staying in the dodgiest areas of the city you crazy tourists! Also, my sister and I have been showing foreigners around the city and taking them to gorgeous natural areas and smaller towns outside of the city as a hobby. I lived in the United States but returned to Colombia recently, it is definitely a country worth visiting, there are awesome places to see, it is a very diverse country and it is a shame that many people who come visit miss-out on many incredible locations and events just due to lack of information. If you would like any tips on your visit to Colombia, I´ll be glad to offer my feedback: My name is Andres Duran

Residente
Dec 7, 2016 14:37

Regarding opening a bank account in Colombia: My experience after arriving last year in Cali was a surprise. Having a temporary residence (cedula de extrajeria) I was albe to open a savings account after residing three months, but only found one bank that would do this, Falabella. The others I went to, maybe a half dozen, required six months residence. They would not open a checking account unless I had a permanent residency (which requires three years as a temporary resident). Forget acquiring a credit card until permant residency is established. I have been using my US credit cards with rarely a problem.

First Published: May 03, 2014

Cigna Expat Health InsuranceExpatriate Health Insurance

Get a quote for expat health insurance in Colombia from our partner, Cigna Global Health.
Get a Quote

Guide to Living in BogotaGuide to Living in Bogota

Expats offer advice for others considering a move to Bogota, Colombia. Topics include safety in Bogota, best neighborhoods for expats, international schools in Bogota and more.

Healthcare in ColombiaHealthcare in Colombia

Our guide to healthcare in Colombia covers public and private healthcare in Colombia, hospitals, vaccinations, prescription medications and more.

Restaurants in BogotaRestaurants in Bogota

Support your favorite restaurants in Bogota as they recover from the pandemic. Submit a free listing for them on Expat Exchange to help spread the word about them to the expat community.

Culture Shock in Bogota

An expat in Bogota, Colombia provides some perspective on the process of settling into the Colombian culture, and the value of having lived abroad before.

Culture Shock in Bogota

A woman who was born in Colombia and left when she was four years old moved back 58 years later to search for a place to retire. The challenges for her are getting a better grip on the language, making friends, learning to pace herself, and being patient and tolerant.

10-Tips-for-Living-in-Colombia10 Tips for Living in Colombia

Colombia is an up-and-coming expat destination. With it's low cost of living, and wonderful people, Colombia has a lot to offer.

6-Best-Places-to-Live-in-Colombia6 Best Places to Live in Colombia

Colombia has made an incredible transformation. Expats in Colombia have a lot to say about the best places to live in Colombia. From cities on the Caribbean coast to inland cities, here are 6 of the best places to live in Colombia.

Colombia Guide
Other Links
Our Story Our Team Contact Us Submit an Article Advertising Travel Warnings

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /lib_rd.cfm
Time Stamp 04-Jun-20 07:40 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.62.46
Host Name 172.69.62.46


Execution Time

Total Time Avg Time Count Template
80 ms 80 ms 1 top level /home/www/html/lib_rd.cfm
23 ms 23 ms 1 /home/www/html/navcontentboxcitymobile.cfm
14 ms 14 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
13 ms 13 ms 1 /home/www/html/navcontentboxcitypc.cfm
13 ms 13 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/breadcrumb_ctygd.cfm
10 ms 10 ms 1 /home/www/html/commentsnew_rdesign4.cfm
8 ms 8 ms 1 /home/www/html/lib_rd_ctygd_readnext.cfm
8 ms 8 ms 1 /home/www/html/navtop_ctygd2.cfm
5 ms 5 ms 1 /home/www/html/navbottomad_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/navmpu_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
1 ms 1 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 6 /home/www/html/rewritearticle.cfm
0 ms 0 ms 4 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 4 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 4 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
86 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 19:40:38.038
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 19:40:38.038
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 19:40:38.038
	Select *
	From articles
	Where articleID = 4371
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 19:40:38.038
	Select *
	From sponcers
	Where sponcerID = 287 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 19:40:38.038
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 4371 
	and articles.articleID = 4371 
	and articlePlacement.networkID = Networks.networkID
	and articles.hinet = 'y'
  and (articles.general = 'no' or articles.general = 'city')
    and articles.hitopic <> ''
    and articles.hidescript <> ''
	and isCity <> "hold"
	AND networktype <> 2
	AND networktype <> 3
	AND networktype <> 4
	AND networktype <> 5
	AND networkname <> 'national'
	AND networkname <> 'Global Listing'
	AND (isCity = 'Country') 
citystatus (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 19:40:38.038
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 4371
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 4371
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 19:40:38.038
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 19:40:38.038
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 32 
getcities (Datasource=expert, Time=0ms, Records=5, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 19:40:38.038
	Select *
	From citynetworks
	Where networkID = 32
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 19:40:38.038
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
commentcount (Datasource=forum, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 19:40:38.038
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 4371 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 19:40:38.038
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
and logtime > "2020-03-05"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 19:40:38.038
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
and logtime > "2020-06-04 00:00:00.000"
and logtime < "2020-06-04 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 19:40:38.038
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
and logtime > "2020-05-28"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 19:40:38.038
	SELECT *
	From contentcountcountry
	Where networkid = 32 
citycontentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 19:40:38.038
	SELECT *
	From contentcountcity
	Where citynetworkid = 4550 
citykeyimg (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 19:40:38.038
	SELECT *
	From countryphotos
	Where citynetworkid = 4550
	and keyimg <> ''
	and usekey = 'y'
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 19:40:38.038
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4371 
checkcitynetwork (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 19:40:38.038
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 4371 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getlivingintro (Datasource=expert, Time=9ms, Records=0) in /home/www/html/breadcrumb_ctygd.cfm @ 19:40:38.038
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 32 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
      and keycity = 0
    and cityintro = 'n'
    and sectionintro = 'y'
   and articleCategories.section = '6'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
     and hpimg <> 'none'
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-04"

    ORDER by articles.articleID asc   
    
getnatadcount (Datasource=expert, Time=1ms, Records=48) in /home/www/html/lib_rd.cfm @ 19:40:38.038
SELECT tag
FROM natadoptions 
gettaxgeneral2 (Datasource=expert, Time=4ms, Records=0) in /home/www/html/navcontentboxcitymobile.cfm @ 19:40:38.038
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articleCategories, articlecityplace
	Where hitopic <> ''
	and hidescript <> ''
    and type = '3'
   and articlecityplace.citynetworkid = 4550
	and articlecityplace.articleid = articles.articleID
     and articleCategories.articleID = articles.articleID
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = 0
    and cityintro = 'n'
    and summary <> ''
    
    and articles.articleID <> '4371'
	
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-04" 
    ORDER by articles.articleID desc  
gethealthsummary (Datasource=expert, Time=7ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 19:40:38.038
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 32 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
checkculturefeature (Datasource=expert, Time=9ms, Records=2) in /home/www/html/navcontentboxcitymobile.cfm @ 19:40:38.038
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
         and networkid = 32
          and citynetworkid = 4550
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 19:40:38.038
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 73452 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 19:40:38.038
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 71056 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd_ctygd_readnext.cfm @ 19:40:38.038
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4371 
gettaxgeneral (Datasource=expert, Time=7ms, Records=4) in /home/www/html/lib_rd_ctygd_readnext.cfm @ 19:40:38.038
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 32 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and articles.articleID <> 4371
    and publishdate < "2020-06-04"
    and publishdate > "2014-01-01"
 
    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navbottomad_rdesign5.cfm @ 19:40:38.038
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-06-03"
    and fromDate < "2020-06-04"
    and bannerPlacement.networkid = 32
    and bannerPlacement.bannerid = banners.bannerid
    and banners.promised = ''
    and banners.type <> 'swf'
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 19:40:38.038
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight = 10 
    and toDate > "2020-06-03"
    and fromDate < "2020-06-04"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 19:40:38.038
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 19:40:38.038
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-06-03 19:40:38'}
    and fromDate <{ts '2020-06-04 19:40:38'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 19:40:38.038
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=0ms, Records=3) in /home/www/html/commentsnew_rdesign4.cfm @ 19:40:38.038
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 4371 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 19:40:38.038
  SELECT *
  FROM users
  WHERE userid = 69045 
GetUser (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 19:40:38.038
  SELECT *
  FROM users
  WHERE userid = 107064 
GetUser (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 19:40:38.038
  SELECT *
  FROM users
  WHERE userid = 173930 
getguidesummary (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 19:40:38.038
	Select summary, hiimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4550
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
gethealthsummary (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 19:40:38.038
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 32 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
checkculturefeature (Datasource=expert, Time=9ms, Records=2) in /home/www/html/navcontentboxcitypc.cfm @ 19:40:38.038
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
                    
         and networkid = 32
          and citynetworkid = 4550
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 19:40:38.038
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 73452 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 19:40:38.038
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 71056 


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/lib_rd.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/lib_rd.cfm
QUERY_STRING=articleID=4371&networkid=32
REMOTE_ADDR=172.69.62.46
REMOTE_HOST=172.69.62.46
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/lib_rd.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Session Variables:
cfid=29012538
cftoken=57198058
sessionid=IBEXPATEXCHANGE.COM_29012538_57198058
urltoken=CFID=29012538&CFTOKEN=57198058
URL Parameters:
articleID=4371
networkid=32
Debug Rendering Time: 12 ms