notebook.community

Edit and run 





In [1]:



    


import os
import sys
import csv
import matplotlib.pyplot as plt
import numpy as np
sys.path.append('/home/vincent/Documents/Urbanhack2014/urbandatahack2014')
import urbandata.parser as parser
import urbandata.kde as kde
from scipy import stats
import pandas as pd
filename = './../data/WCC_CleansingAntiSocialBehaviour.csv'

# Loading the data
data_anti_social = parser.get_anti_social_data()
data_pub = parser.get_licensing_data(True)

#data_vomit = data_anti_social[data_anti_social['Vomit']]

#data_pub = data_licensing[data_licensing['Premisesuse'] == 'Type - Night clubs and discos']
def coord_from_data(data):
    x = -np.asarray(data['lon_to_gw'])
    y = np.asarray(data['lat_to_gw'])
    I = np.where(x != 0)[0]
    x =x[I]
    y =y[I]
    return (x,y)



    











In [2]:



    


# density estimation on pubs
x_p = np.asarray(data_pub['Long'])
y_p = np.asarray(data_pub['Lat'])
I = np.where(x_p != 0)[0]
x_p =x_p[I]
y_p =y_p[I]

(x_p,y_p) = coord_from_data(data_pub)

k_p =  kde.get_kernel_density(x_p,y_p)
Z_p = kde.evaluate_kernel_density_on_grid(x_p,y_p,k_p)



    











In [3]:



    


# density estimation on all antisocial behavior
data_as = data_anti_social
(x_as,y_as) = coord_from_data(data_as)

k_as =  kde.get_kernel_density(x_as,y_as)
Z_as = kde.evaluate_kernel_density_on_grid(x_as,y_as,k_as)



    











In [8]:



    


kde.plot_kde(x_p,y_p,Z_p)
kde.plot_kde(x_as,y_as,Z_as)



    


















    

















    
























In [9]:



    


xmin = x_as.min()
xmax = x_as.max()
ymin = y_as.min()
ymax = y_as.max()
fig = plt.figure(figsize=(15,10))
ax = fig.add_subplot(111)
ax.plot(x_p, y_p, 'r.', markersize=5)
ax.plot(x_as, y_as, 'k.', markersize=5)
ax.axis('equal')
ax.set_xlim([xmin, xmax])
ax.set_ylim([ymin, ymax])

plt.ylabel('(m)')
plt.xlabel('(m)')

plt.show()



    


















    
























In [49]:



    


# distance to nearest pub
import scipy.spatial.distance as dist
X_p =np.transpose(np.vstack([x_p,y_p]))
X_as =np.transpose(np.vstack([x_as,y_as]))
d = dist.cdist(X_p,X_as)
d_min = np.amin(d,axis=0)



    











In [50]:



    


# evaluating pub density on anti social behavior points


data_as = data_anti_social[data_anti_social['Urine']]
(x_as,y_as) = coord_from_data(data_as)


Z_as = kde.evaluate_kernel_density_on_grid(x_as,y_as,k_p)
#kde.plot_kde(x,y,Z)

k_as =  kde.get_kernel_density(x_as,y_as)

nbins = 50

z_as_p = kde.evaluate_kernel_density(x_as,y_as,k_p)
z_as_as = kde.evaluate_kernel_density(x_as,y_as,k_as)

plt.plot(z_as_p,z_as_as,'*')
plt.xlabel('antisocial density')
plt.ylabel('pub density')
plt.show()

plt.hist(z_as_p,nbins)
plt.ylabel('antisocial count')
plt.xlabel('pub density')
plt.show()

plt.hist(log(z_as_p),nbins)
plt.ylabel('antisocial count')
plt.xlabel('log pub density')
plt.show()


X_as =np.transpose(np.vstack([x_as,y_as]))
d = dist.cdist(X_p,X_as)
d_min = np.amin(d,axis=0)
plt.hist(d_min,nbins)
plt.ylabel('antisocial count')
plt.xlabel('distance to nearest pub density')
plt.show()


plt.plot(1/d_min,z_as_as,'*')
plt.ylabel('antisocial count')
plt.xlabel('inverse distance to nearest pub')
plt.show()



    


















    

















    

















    

















    

















    
























In [51]:



    


plt.plot(1/(d_min+0.001),z_as_p,'*')
plt.show()



    


















    
























In [52]:



    


# evaluating pub density on anti social behavior points

data_as = data_anti_social[data_anti_social['Vomit']]
(x_as,y_as) = coord_from_data(data_as)


Z_as = kde.evaluate_kernel_density_on_grid(x_as,y_as,k_p)
#kde.plot_kde(x,y,Z)

nbins = 50
z_as = kde.evaluate_kernel_density(x_as,y_as,k_p)
plt.hist(z_as,nbins)
plt.show()

X_as =np.transpose(np.vstack([x_as,y_as]))
d = dist.cdist(X_p,X_as)
d_min = np.amin(d,axis=0)
plt.hist(d_min,nbins)
plt.show()



    


















    

















    
























In [52]:



    






    











In [52]:



    






    











In [53]:



    


type(X_as)



    


















    
Out[53]:








numpy.ndarray

















In [54]:



    


len(data_pub)



    


















    
Out[54]:








438

















In [55]:



    


data_as = data_anti_social[data_anti_social['Urine']]
(x_as,y_as) = coord_from_data(data_as)
k_as =  kde.get_kernel_density(x_as,y_as)
z_p_as = kde.evaluate_kernel_density(x_p,y_p,k_as)
i_sort = np.argsort(-z_p_as)           
sort = np.sort(-z_p_as)           
I[i_sort]
names = data_pub['Tradingname']
top = names[:20]
print(top)



    


















    






IssuedDate
2006-09-29                   Escape Nightclub
2006-10-11                              Finos
2006-10-16                  Shampers Wine Bar
2006-10-31               Gallery Public House
2006-11-10       Freemasons Arms Public House
2006-11-15                   L'autre Wine Bar
2006-11-21              The Westbourne Tavern
2006-11-22              Dover Street Wine Bar
2006-11-23               The Metropolitan Bar
2006-12-06                        Mother Mash
2006-12-06                     Andrew Edmunds
2006-12-18                       Academy Club
2007-01-17    Duke Of Wellington Public House
2007-01-20                 The Ship & Shovell
2007-02-28                   L'artiste Muscle
2007-02-28                   Gordons Wine Bar
2007-03-01         Cock & Bottle Public House
2007-03-07              The Star Public House
2007-03-19          The Chequers Public House
2007-03-23        Coach & Horses Public House
Name: Tradingname, dtype: object

















In [56]:



    


data_as = data_anti_social[data_anti_social['Blood']]
(x_as,y_as) = coord_from_data(data_as)
k_as =  kde.get_kernel_density(x_as,y_as)
z_p_as = kde.evaluate_kernel_density(x_p,y_p,k_as)
i_sort = np.argsort(-z_p_as)           
sort = np.sort(-z_p_as)           
I[i_sort]
names = data_pub['Tradingname']
top = names[:20]
print(top)



    


















    






IssuedDate
2006-09-29                   Escape Nightclub
2006-10-11                              Finos
2006-10-16                  Shampers Wine Bar
2006-10-31               Gallery Public House
2006-11-10       Freemasons Arms Public House
2006-11-15                   L'autre Wine Bar
2006-11-21              The Westbourne Tavern
2006-11-22              Dover Street Wine Bar
2006-11-23               The Metropolitan Bar
2006-12-06                        Mother Mash
2006-12-06                     Andrew Edmunds
2006-12-18                       Academy Club
2007-01-17    Duke Of Wellington Public House
2007-01-20                 The Ship & Shovell
2007-02-28                   L'artiste Muscle
2007-02-28                   Gordons Wine Bar
2007-03-01         Cock & Bottle Public House
2007-03-07              The Star Public House
2007-03-19          The Chequers Public House
2007-03-23        Coach & Horses Public House
Name: Tradingname, dtype: object

















In [57]:



    


z_p_p = kde.evaluate_kernel_density(x_p,y_p,k_p)
i_sort = np.argsort(-z_p_p)           
sort = np.sort(-z_p_p)           
I[i_sort]
names = data_pub['Tradingname']
top = names[:20]
print(top)



    


















    






IssuedDate
2006-09-29                   Escape Nightclub
2006-10-11                              Finos
2006-10-16                  Shampers Wine Bar
2006-10-31               Gallery Public House
2006-11-10       Freemasons Arms Public House
2006-11-15                   L'autre Wine Bar
2006-11-21              The Westbourne Tavern
2006-11-22              Dover Street Wine Bar
2006-11-23               The Metropolitan Bar
2006-12-06                        Mother Mash
2006-12-06                     Andrew Edmunds
2006-12-18                       Academy Club
2007-01-17    Duke Of Wellington Public House
2007-01-20                 The Ship & Shovell
2007-02-28                   L'artiste Muscle
2007-02-28                   Gordons Wine Bar
2007-03-01         Cock & Bottle Public House
2007-03-07              The Star Public House
2007-03-19          The Chequers Public House
2007-03-23        Coach & Horses Public House
Name: Tradingname, dtype: object

















In [58]:



    


y_as



    


















    
Out[58]:








array([ 109282.12927743,  115397.09411738,  111737.42445267,
        117515.86896662,  112599.76334779,  113937.03801358,
        112763.5979527 ,  113937.03801358,  116411.4587162 ,
        117313.49420013,  114162.54132482,  116670.29826645,
        113154.6927487 ,  114264.55155052,  112884.82266173,
        114807.84996211,  112749.94321571,  113937.03801358,
        114631.1167457 ,  114081.59141822,  113855.24302554,
        113440.70833901,  114807.84996211,  113706.64212558,
        114631.1167457 ,  113972.70934605,  113645.01789723,
        115877.50067846,  114206.93033954,  115477.5547663 ,
        113468.86289444,  114569.35908344,  114569.35908344,
        113534.82372492,  111579.57213481,  114807.84996211,
        115166.3646446 ,  113551.94774363,  115166.3646446 ,
        110869.39237731,  111886.3811764 ,  114347.94774551,
        109181.72025867,  114631.1167457 ,  114452.20410873,
        113551.94774363,  113551.94774363,  113440.70833901,
        113440.70833901,  114315.47882693,  115609.23179844,
        114631.1167457 ,  110113.68941685,  113551.94774363,
        116268.84010329,  113319.32795709,  109054.2019168 ,
        113319.32795709,  114203.61673072,  112763.5979527 ,
        115237.70730953,  112450.4285613 ,  113551.94774363,
        115520.98750465,  114631.1167457 ,  114631.1167457 ,
        113154.6927487 ,  112450.4285613 ,  113551.94774363,
        114145.595218  ,  114451.95947989,  112829.89236797,
        118168.00497241,  110201.73355977,  110201.73355977,
        111737.42445267,  116900.22713576])

















In [59]:



    


data_pub



    


















    
Out[59]:










  
    

      
      Tradingname
      Address
      Premisesuse
      Ward
      Url
      Lat
      Long
      lat_to_gw
      lon_to_gw
    

    

      IssuedDate
      
      
      
      
      
      
      
      
      
    

  
  
    

      2006-09-29
                        Escape Nightclub
                        10A Brewer Street London W1F 0SU
               Type - Night clubs and discos
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.512488
      -0.133913
       113972.206745
        9304.250227
    

    

      2006-10-11
                                   Finos
                             12 North Row London W1K 7DF
                             Type - Wine bar
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.512783
      -0.157089
       114037.700557
       10914.565954
    

    

      2006-10-16
                       Shampers Wine Bar
             Ground Floor 4 Kingly Street London W1B 5PE
                             Type - Wine bar
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.512330
      -0.138646
       113936.937938
        9633.136586
    

    

      2006-10-31
                    Gallery Public House
                          1 Lupus Street London SW1V 3AS
       Type - Public house or pub restaurant
                         Tachbrook
       http://idoxpa.westminster.gov.uk/online-applic...
       51.488674
      -0.134352
       108676.165853
        9334.788077
    

    

      2006-11-10
            Freemasons Arms Public House
                         81-82 Long Acre London WC2E 9NG
       Type - Public house or pub restaurant
                        St James's
       http://idoxpa.westminster.gov.uk/online-applic...
       51.514458
      -0.122677
       114410.294741
        8523.591707
    

    

      2006-11-15
                        L'autre Wine Bar
                       5B Shepherd Street London W1J 7HP
                             Type - Wine bar
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.506171
      -0.146664
       112567.283310
       10190.217499
    

    

      2006-11-21
                   The Westbourne Tavern
                101 Westbourne Park Villas London W2 5ED
       Type - Public house or pub restaurant
                         Bayswater
       http://idoxpa.westminster.gov.uk/online-applic...
       51.519449
      -0.194859
       115520.204692
       13538.775528
    

    

      2006-11-22
                   Dover Street Wine Bar
         Ground Floor Left 8 Dover Street London W1S 4LD
                             Type - Wine bar
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.508060
      -0.141587
       112987.384414
        9837.464065
    

    

      2006-11-23
                    The Metropolitan Bar
       7 Station Approach Marylebone Road London NW1 5LD
       Type - Public house or pub restaurant
                     Regent's Park
       http://idoxpa.westminster.gov.uk/online-applic...
       51.522631
      -0.156634
       116227.931490
       10882.936573
    

    

      2006-12-06
                             Mother Mash
                         26 Ganton Street London W1F 7QY
       Type - Public house or pub restaurant
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.512935
      -0.139414
       114071.637248
        9686.495142
    

    

      2006-12-06
                          Andrew Edmunds
       Basement And Ground Floor 46 Lexington Street ...
                             Type - Wine bar
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.513145
      -0.136206
       114118.305759
        9463.601912
    

    

      2006-12-18
                            Academy Club
       First Floor Front 46 Lexington Street London W...
                             Type - Wine bar
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.513145
      -0.136206
       114118.305759
        9463.601912
    

    

      2007-01-17
         Duke Of Wellington Public House
                        63 Eaton Terrace London SW1W 8TR
       Type - Public house or pub restaurant
       Knightsbridge and Belgravia
       http://idoxpa.westminster.gov.uk/online-applic...
       51.493147
      -0.153300
       109670.793352
       10651.306234
    

    

      2007-01-20
                      The Ship & Shovell
           Ground Floor 1 Craven Passage London WC2N 5PH
       Type - Public house or pub restaurant
                        St James's
       http://idoxpa.westminster.gov.uk/online-applic...
       51.507584
      -0.124660
       112881.469023
        8661.369852
    

    

      2007-02-28
                        L'artiste Muscle
                        1 Shepherd Market London W1J 7PA
                             Type - Wine bar
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.506385
      -0.146526
       112614.794678
       10180.604941
    

    

      2007-02-28
                        Gordons Wine Bar
                      47 Villiers Street London WC2N 6NE
                             Type - Wine bar
                        St James's
       http://idoxpa.westminster.gov.uk/online-applic...
       51.507968
      -0.123390
       112966.944563
        8573.166382
    

    

      2007-03-01
              Cock & Bottle Public House
          Cock And Bottle 17 Needham Road London W11 2RP
       Type - Public house or pub restaurant
                         Bayswater
       http://idoxpa.westminster.gov.uk/online-applic...
       51.515381
      -0.197585
       114615.607277
       13728.195378
    

    

      2007-03-07
                   The Star Public House
                38 St John's Wood Terrace London NW8 6LS
       Type - Public house or pub restaurant
                        Abbey Road
       http://idoxpa.westminster.gov.uk/online-applic...
       51.534988
      -0.168780
       118976.009579
       11726.853160
    

    

      2007-03-19
               The Chequers Public House
               16 Duke Street St James's London SW1Y 6DB
       Type - Public house or pub restaurant
                        St James's
       http://idoxpa.westminster.gov.uk/online-applic...
       51.507559
      -0.137803
       112876.044934
        9574.556609
    

    

      2007-03-23
             Coach & Horses Public House
                            5 Hill Street London W1J 5LD
       Type - Public house or pub restaurant
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.509140
      -0.147322
       113227.543217
       10235.915190
    

    

      2007-03-23
           Callaghan's Irish Bar & Grill
                20 - 22 Glasshouse Street London W1B 5DJ
       Type - Public house or pub restaurant
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.510538
      -0.136212
       113538.370843
        9463.987526
    

    

      2007-03-25
                   Red Lion Public House
                        23 Crown Passage London SW1Y 6PP
       Type - Public house or pub restaurant
                        St James's
       http://idoxpa.westminster.gov.uk/online-applic...
       51.505679
      -0.137750
       112457.889741
        9570.872084
    

    

      2007-03-25
                         The Lincoln Inn
                      44 Blandford Street London W1U 7HS
       Type - Public house or pub restaurant
            Marylebone High Street
       http://idoxpa.westminster.gov.uk/online-applic...
       51.518548
      -0.153729
       115319.842554
       10681.079803
    

    

      2007-04-01
                          Ebury Wine Bar
                        139 Ebury Street London SW1W 9QU
                             Type - Wine bar
                           Warwick
       http://idoxpa.westminster.gov.uk/online-applic...
       51.493274
      -0.149967
       109699.108028
       10419.738426
    

    

      2007-04-03
                 Nag's Head Public House
                     53 Kinnerton Street London SW1X 8ED
       Type - Public house or pub restaurant
       Knightsbridge and Belgravia
       http://idoxpa.westminster.gov.uk/online-applic...
       51.501120
      -0.157113
       111443.992161
       10916.223746
    

    

      2007-04-05
       The Pride Of Pimlico Public House
                     85 Tachbrook Street London SW1V 2QA
       Type - Public house or pub restaurant
                         Tachbrook
       http://idoxpa.westminster.gov.uk/online-applic...
       51.489966
      -0.135322
       108963.575828
        9402.182287
    

    

      2007-04-22
                  The Globe Public House
                          47 Lisson Grove London NW1 6UB
       Type - Public house or pub restaurant
                     Church Street
       http://idoxpa.westminster.gov.uk/online-applic...
       51.522549
      -0.165719
       116209.606566
       11514.144308
    

    

      2007-05-01
                    Beehive Public House
                           7 Homer Street London W1H 4NU
       Type - Public house or pub restaurant
       Bryanston and Dorset Square
       http://idoxpa.westminster.gov.uk/online-applic...
       51.519399
      -0.164981
       115509.096319
       11462.848614
    

    

      2007-05-13
                         Jazz After Dark
              Ground Floor 9 Greek Street London W1D 4DQ
               Type - Night clubs and discos
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.514502
      -0.131049
       114420.030969
        9105.267150
    

    

      2007-05-13
               The Victoria Public House
                      10A Strathearn Place London W2 2NH
       Type - Public house or pub restaurant
                         Hyde Park
       http://idoxpa.westminster.gov.uk/online-applic...
       51.513499
      -0.171242
       114196.953931
       11897.887212
    

    

      2007-05-18
                                 The Oak
                  137 Westbourne Park Road London W2 5QL
       Type - Public house or pub restaurant
                         Bayswater
       http://idoxpa.westminster.gov.uk/online-applic...
       51.518646
      -0.197615
       115341.645655
       13730.256850
    

    

      2007-05-22
                      Bedford And Strand
                       1A Bedford Street London WC2E 9HD
                             Type - Wine bar
                        St James's
       http://idoxpa.westminster.gov.uk/online-applic...
       51.509746
      -0.123764
       113362.244751
        8599.131058
    

    

      2007-05-22
                Wilton Arms Public House
                     71 Kinnerton Street London SW1X 8ED
       Type - Public house or pub restaurant
       Knightsbridge and Belgravia
       http://idoxpa.westminster.gov.uk/online-applic...
       51.501508
      -0.157213
       111530.335021
       10923.143954
    

    

      2007-06-05
                               Belgravia
                        152 Ebury Street London SW1W 9JL
       Type - Public house or pub restaurant
       Knightsbridge and Belgravia
       http://idoxpa.westminster.gov.uk/online-applic...
       51.492509
      -0.151626
       109528.937537
       10534.991850
    

    

      2007-06-11
                 Blue Posts Public House
                         28 Rupert Street London W1D 6DJ
       Type - Public house or pub restaurant
                        St James's
       http://idoxpa.westminster.gov.uk/online-applic...
       51.511155
      -0.132641
       113675.729936
        9215.915440
    

    

      2007-06-22
                   Cellar Door Jazz Cafe
       Development Site At Former Wellington Street T...
                             Type - Wine bar
                        St James's
       http://idoxpa.westminster.gov.uk/online-applic...
       51.511491
      -0.119311
       113750.355075
        8289.750514
    

    

      2007-07-02
            The Cock & Lion Public House
                        62 Wigmore Street London W1U 2SA
       Type - Public house or pub restaurant
            Marylebone High Street
       http://idoxpa.westminster.gov.uk/online-applic...
       51.516373
      -0.149824
       114836.200221
       10409.797922
    

    

      2007-07-09
                The Beehive Public House
                      126 Crawford Street London W1U 6BF
       Type - Public house or pub restaurant
            Marylebone High Street
       http://idoxpa.westminster.gov.uk/online-applic...
       51.520053
      -0.157344
       115654.456999
       10932.234023
    

    

      2007-07-09
                 Dog & Duck Public House
                        18 Bateman Street London W1D 3AJ
       Type - Public house or pub restaurant
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.514005
      -0.132035
       114309.532122
        9173.771651
    

    

      2007-08-02
              Lord Burleigh Public House
                250 Vauxhall Bridge Road London SW1V 1AU
       Type - Public house or pub restaurant
                    Vincent Square
       http://idoxpa.westminster.gov.uk/online-applic...
       51.494467
      -0.140670
       109964.385765
        9773.782866
    

    

      2007-10-03
                 The Larrik Public House
                        32 Crawford Place London W1H 5NN
       Type - Public house or pub restaurant
       Bryanston and Dorset Square
       http://idoxpa.westminster.gov.uk/online-applic...
       51.518706
      -0.164922
       115354.904538
       11458.775696
    

    

      2008-02-11
                 Chippenham Public House
                         207 Shirland Road London W9 2EX
       Type - Public house or pub restaurant
                       Harrow Road
       http://idoxpa.westminster.gov.uk/online-applic...
       51.527945
      -0.197046
       117409.517691
       13690.722730
    

    

      2008-07-09
                             The Victory
                         4 Brendon Street London W1H 5HE
       Type - Public house or pub restaurant
       Bryanston and Dorset Square
       http://idoxpa.westminster.gov.uk/online-applic...
       51.517481
      -0.164784
       115082.448057
       11449.178424
    

    

      2008-09-03
                         Cheshire Cheese
       Cheshire Cheese 5 Little Essex Street London W...
       Type - Public house or pub restaurant
                        St James's
       http://idoxpa.westminster.gov.uk/online-applic...
       51.512444
      -0.113161
       113962.370442
        7862.456851
    

    

      2008-10-14
                       The Market Tavern
                        7 Shepherd Street London W1J 7HR
       Type - Public house or pub restaurant
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.506147
      -0.146867
       112561.997103
       10204.301790
    

    

      2008-12-11
                 Kings Head Public House
                   13 Westmoreland Street London W1G 8PJ
       Type - Public house or pub restaurant
            Marylebone High Street
       http://idoxpa.westminster.gov.uk/online-applic...
       51.519716
      -0.150237
       115579.585007
       10438.442442
    

    

      2008-12-16
             The Kings Arms Public House
                         23 Poland Street London W1F 8QJ
       Type - Public house or pub restaurant
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.515184
      -0.137175
       114571.691953
        9530.921779
    

    

      2009-01-14
                    Sports Bar And Grill
       Unit 14 Marylebone Station Melcombe Place Lond...
       Type - Public house or pub restaurant
       Bryanston and Dorset Square
       http://idoxpa.westminster.gov.uk/online-applic...
       51.523100
      -0.163015
       116332.187853
       11326.314856
    

    

      2009-02-17
                                    BBAR
               43 Buckingham Palace Road London SW1W 0PP
                             Type - Wine bar
                        St James's
       http://idoxpa.westminster.gov.uk/online-applic...
       51.498164
      -0.143603
       110786.656680
        9977.546167
    

    

      2009-02-24
               Daniel Gooch Public House
                        40 Porchester Road London W2 6ES
       Type - Public house or pub restaurant
                         Bayswater
       http://idoxpa.westminster.gov.uk/online-applic...
       51.517154
      -0.187743
       115009.844442
       13044.365575
    

    

      2009-03-05
                        Westminster Arms
                         9 Storey's Gate London SW1P 3AT
       Type - Public house or pub restaurant
                        St James's
       http://idoxpa.westminster.gov.uk/online-applic...
       51.500563
      -0.129890
       111320.161043
        9024.762064
    

    

      2009-04-06
                           Madame Jojo's
                     6 - 10 Brewer Street London W1F 0SE
               Type - Night clubs and discos
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.512549
      -0.133795
       113985.788093
        9296.066178
    

    

      2009-04-27
                                  Crobar
           Ground Floor 17 Manette Street London W1D 4AS
               Type - Night clubs and discos
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.514913
      -0.130326
       114511.459885
        9055.030331
    

    

      2009-06-15
                  Coal Hole Public House
                  Coal Hole 91-92 Strand London WC2R 0DW
       Type - Public house or pub restaurant
                        St James's
       http://idoxpa.westminster.gov.uk/online-applic...
       51.510316
      -0.121176
       113489.020311
        8419.275130
    

    

      2009-08-06
          Marquis Of Granby Public House
                        2 Rathbone Street London W1T 1NR
       Type - Public house or pub restaurant
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.518058
      -0.134680
       115210.822600
        9357.535134
    

    

      2009-08-19
                                 The Oak
                  137 Westbourne Park Road London W2 5QL
       Type - Public house or pub restaurant
                         Bayswater
       http://idoxpa.westminster.gov.uk/online-applic...
       51.518646
      -0.197615
       115341.645655
       13730.256850
    

    

      2009-08-27
                    Cask Pub And Kitchen
                      6 Charlwood Street London SW1V 2EE
       Type - Public house or pub restaurant
                         Tachbrook
       http://idoxpa.westminster.gov.uk/online-applic...
       51.491095
      -0.137322
       109214.622837
        9541.104073
    

    

      2009-09-14
            The Traders Inn Public House
                         52 Church Street London NW8 8EP
       Type - Public house or pub restaurant
                     Church Street
       http://idoxpa.westminster.gov.uk/online-applic...
       51.523725
      -0.170212
       116471.192631
       11826.356162
    

    

      2009-10-12
                            The Windmill
              17-19 Great Windmill Street London W1D 7LQ
               Type - Night clubs and discos
                          West End
       http://idoxpa.westminster.gov.uk/online-applic...
       51.511306
      -0.134206
       113709.264102
        9324.629406
    

    

      2009-10-14
                Queens Arms Public House
                      1 Kilburn High Road London NW6 5SE
       Type - Public house or pub restaurant
                        Maida Vale
       http://idoxpa.westminster.gov.uk/online-applic...
       51.535051
      -0.190175
       118989.851123
       13213.383318
    

    

      
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
    

  



438 rows × 9 columns



















In [59]:



    






    











In [59]:



    






    











In [59]:



    






    











In [ ]:

Content source: vincentadam87/urbandatahack2014

Similar notebooks:

notebook.community | gallery | about