Joined: 27/03/2016 23:47:43
I need a list of cities for use in a typeahead-dropdown (using Bootstrap typeahead if you are curious). In order to have a complete list, I am using allCountries.zip.
I wrote a query such as this:
where countrycode = 'us'
and Admin1Code = 'IA'
and name like 'ceda%'
and FeatureClass = 'P'
But then I get matches like this:
Cedar Falls Mobile Home Park
Cedar Falls Mobile Home Village
So my first thought was to narrow it to population > 0
But I have found at least 1 city with a population of 0, that I am familiar with, and I know people that live there.