0

I want to show only APAC countries on the carto map. I re-wrote my SQL query (see below) and clicked 'create a dataset from query'. Although the countries specified were coded in colors, those outside of APAC are still visible on the map.

How do I make non-APAC countries non-visible?

SELECT * FROM apac WHERE country IN ('Australia', 'Brunei', 'Cambodia', 'China', 'Laos', 'Singapore', 'Malaysia', 'Bangladesh', 'India', 'Pakistan', 'Sri Lanka', 'Philippines', 'New Zealand', 'Indonesia', 'South Korea', 'Taiwan', 'Hong Kong', 'Japan', 'North Korea', 'Pupua New Guinea', 'East Timor', 'Vietnam', 'Myanmar', 'Thailand')

enter image description here

Improve this question

1 Answer 1

Reset to default
1

I understand (and correct me if I am wrong) that when you said:

(...) those outside of APAC are still visible on the map.

You are viewing those countries in the basemap. So, in order to get rid of the basemap, you have to click on the Basemap button on the left-bottom corner of the Editor.

enter image description here

Then, select a background color (with good contrast with your layer).

enter image description here

Improve this answer
5
  • No, I want to filter out non-APAC countries so I wrote a SQL query to do that. But I do not think I did it correctly because the non-APAC countries are still visible on the map.
    – Geomap
    Commented Jul 22, 2016 at 13:49
  • Sorry @ramiroaznar I do not really understand your instructions. When I click on the 'change basemap' button at the left-bottom corner of the editor, I do not see any background color option.
    – Geomap
    Commented Jul 25, 2016 at 8:30
  • I have added a couple of screenshots to show you how to change your basemap to a simple background color.
    – ramiroaznar
    Commented Jul 25, 2016 at 18:10
  • You are awesome @ramiroaznar. Once again, thank you for your help.
    – Geomap
    Commented Jul 26, 2016 at 3:04
  • Your welcome! Please check as answered in order to show other people your question is solved. :-)
    – ramiroaznar
    Commented Jul 26, 2016 at 6:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.