I’ve been at it again with GeoDjango , this time I’ve pulled data on all Taco Bells locations from a popular social media site, took that data and added to a Django project, and finally plotted them in a view using Google Maps :
Wow, that is a lot of Taco Bells !
Since this is Django, we are also able to view and edit from the admin :
As well as the shell :
django-cities was used tie it all together, which allows me to do searches like how many Taco Bells do the cities with the highest population have:
In : from cities.models import City In : from hub.models import Location In : for city in City.objects.order_by('-population')[:20]: locations = Location.objects.filter(cities_city=city) print '%s with population %s has %s Taco Bells' % ( city.name, city.population, len(locations)) ...: New York City with population 8175133 has 0 Taco Bells Los Angeles with population 3792621 has 34 Taco Bells Chicago with population 2695598 has 15 Taco Bells Brooklyn with population 2300664 has 5 Taco Bells Borough of Queens with population 2272771 has 0 Taco Bells Houston with population 2099451 has 54 Taco Bells Philadelphia with population 1526006 has 13 Taco Bells Manhattan with population 1487536 has 1 Taco Bells Phoenix with population 1445632 has 34 Taco Bells The Bronx with population 1385108 has 0 Taco Bells San Antonio with population 1327407 has 22 Taco Bells San Diego with population 1307402 has 22 Taco Bells Dallas with population 1197816 has 27 Taco Bells San Jose with population 945942 has 18 Taco Bells Indianapolis with population 829718 has 30 Taco Bells Jacksonville with population 821784 has 18 Taco Bells San Francisco with population 805235 has 11 Taco Bells Austin with population 790390 has 25 Taco Bells Columbus with population 787033 has 23 Taco Bells Fort Worth with population 741206 has 16 Taco Bells
Or how may Taco Bells each state in the United State has:
In : from cities.models import Region In : from hub.models import Location In : for region in Region.objects.all()[:10]: locations = Location.objects.filter(cities_state=region) print '%s has %s Taco Bells' % (region.name, len(locations)) ...: Arkansas has 58 Taco Bells Washington, D.C. has 5 Taco Bells Delaware has 14 Taco Bells Florida has 363 Taco Bells Georgia has 193 Taco Bells Kansas has 65 Taco Bells Louisiana has 92 Taco Bells Maryland has 91 Taco Bells Missouri has 157 Taco Bells Mississippi has 48 Taco Bells