256 rows where qSpecies_id = 151 sorted by YCoord

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord ▼ Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
14190 67936 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 78 Saint Mary's Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM     Permit Number 31649                    
18660 264656 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1199 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/08/2020 04:53:00 PM   3x3                      
76546 177523 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 321 Ellington Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5998908.35184 2087935.66658 37.7130110981499 -122.44563295221 (37.7130110981499, -122.44563295221) 9 7 6 28861 25
21835 65598 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 966 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/1990 12:00:00 AM     Permit Number 28500 6001950.73496364 2088338.48153862 37.7142903680478 -122.435146273727 (37.7142903680478, -122.435146273727) 9 7 6 28861 5
43235 57575 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 30 Beverly St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1994 12:00:00 AM     Permit Number 16442 5991446.93129096 2089419.02625002 37.7166552263353 -122.471529877911 (37.7166552263353, -122.471529877911) 9 8 6 64 24
170769 53492 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 255 Ralston St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1994 12:00:00 AM     Permit Number 6402 5992175.72287884 2089558.97106605 37.7170816163747 -122.469021010071 (37.7170816163747, -122.469021010071) 9 8 6 64 24
127221 53339 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 701 Shields St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1994 12:00:00 AM     Permit Number 6231 5992196.93740977 2089828.37078741 37.7178225482589 -122.468967276491 (37.7178225482589, -122.468967276491) 9 8 6 64 24
16040 78382 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 606 Lisbon St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12     6001696.66297 2089972.42102 37.7187623714737 -122.436141300492 (37.7187623714737, -122.436141300492) 9 7 6 28861 5
122547 67014 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 26 Brighton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/1992 12:00:00 AM     Permit Number 30369 5996236.04729315 2090068.29308484 37.7187138605807 -122.455023275935 (37.7187138605807, -122.455023275935) 9 8 6 28861 24
44026 45318 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 651 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/2001 12:00:00 AM     Permit Number 44155 5993484.7456852 2090166.18126819 37.718824416648 -122.464540445707 (37.718824416648, -122.464540445707) 9 8 6 64 24
49524 209294 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 246 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994759.39259 2090227.21808 37.7190654070329 -122.460138948468 (37.7190654070329, -122.460138948468) 9 8 6 28861 24
82559 45319 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 671 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/2001 12:00:00 AM     Permit Number 44156 5993486.1732944 2090289.68128716 37.7191636002321 -122.464544473629 (37.7191636002321, -122.464544473629) 9 8 6 64 24
18805 78255 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 512 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6001977.46264 2090420.81734 37.7200095171006 -122.435202744616 (37.7200095171006, -122.435202744616) 9 7 6 28861 5
120920 46820 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 470 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/25/2002 12:00:00 AM 10   Permit Number 44898 6003678.47918 2090585.52708 37.7205582222597 -122.429334652987 (37.7205582222597, -122.429334652987) 9 7 6 28861 5
116585 35845 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 478 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1998 12:00:00 AM 14   Permit Number 39072 6001935.45212 2090855.28224 37.7212000747131 -122.435379022551 (37.7212000747131, -122.435379022551) 9 7 6 28861 5
97669 46851 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 440 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/25/2002 12:00:00 AM 8   Permit Number 44919 6003321.97716 2091035.01696 37.7217722323726 -122.430599024221 (37.7217722323726, -122.430599024221) 9 7 6 28861 5
153381 45327 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1385 Holloway Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2001 12:00:00 AM     Permit Number 44161 5991450.97971793 2091205.24216012 37.7215599710698 -122.471645977425 (37.7215599710698, -122.471645977425) 9 8 6 64 24
168262 45325 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1385 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2001 12:00:00 AM     Permit Number 44161 5991450.97971793 2091205.24216012 37.7215599710698 -122.471645977425 (37.7215599710698, -122.471645977425) 9 8 6 64 24
173866 45326 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1385 Holloway Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2001 12:00:00 AM     Permit Number 44161 5991450.97971793 2091205.24216012 37.7215599710698 -122.471645977425 (37.7215599710698, -122.471645977425) 9 8 6 64 24
78371 33939 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 378 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1989 12:00:00 AM     Permit Number 37898 6003089.72357803 2091687.1316724 37.72354963405 -122.431448393386 (37.72354963405, -122.431448393386) 9 7 6 28861 5
121517 254611 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 49 Ocean Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1   10/05/2018 02:11:00 PM 3 3X3   6001570.75814 2091771.51604 37.7236951277094 -122.436705214986 (37.7236951277094, -122.436705214986) 9 7 6 28861 25
167774 42973 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 538 Cambridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2000 12:00:00 AM 8   Permit Number 42858 6007050.21421 2092033.4761 37.7247242929748 -122.4177821868 (37.7247242929748, -122.4177821868) 9 7 7 309 28
161958 43169 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 351 Madison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2000 12:00:00 AM 6   Permit Number 42978 6005826.41516 2092089.07714 37.7248080153712 -122.422016663551 (37.7248080153712, -122.422016663551) 9 7 7 309 5
9740 75309 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 125 Excelsior Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6002784.56496 2092514.51527 37.7258041440316 -122.432562342276 (37.7258041440316, -122.432562342276) 9 7 6 28861 5
1406 75132 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 148X Paris St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6002992.10347 2092540.72564 37.7258878789975 -122.431846767938 (37.7258878789975, -122.431846767938) 9 7 6 28861 5
84565 177524 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 151 London St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002754.06698 2092583.57784 37.725992044773 -122.432672702599 (37.725992044773, -122.432672702599) 9 7 6 28861 5
97377 77990 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 163X London St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 04/01/2000 12:00:00 AM 8 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
163496 77992 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 163X London St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 04/01/2000 12:00:00 AM 16 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
174822 75386 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 163X London St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/1992 12:00:00 AM 10 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
192102 37860 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 147 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/1998 12:00:00 AM 13 6x8 Permit Number 40147 6003940.89934 2092950.10622 37.7270656869264 -122.428596014613 (37.7270656869264, -122.428596014613) 9 7 6 28861 5
51461 83403 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 24 Otsego Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2008 12:00:00 AM   3x3 Permit Number 50775 6000910.29193694 2092966.50207531 37.7269387297254 -122.439073931559 (37.7269387297254, -122.439073931559) 9 7 6 28861 25
152379 43141 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 45 Gambier St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2000 12:00:00 AM 10   Permit Number 42954 6005755.19133 2093338.41647 37.7282344107702 -122.422351602551 (37.7282344107702, -122.422351602551) 9 7 7 309 5
1945 44489 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 16 Madison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/26/2001 12:00:00 AM 8   Permit Number 43794 6005364.27294 2093438.07689 37.7284859970226 -122.423710107629 (37.7284859970226, -122.423710107629) 9 7 6 28861 5
96848 43137 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1 Gambier St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2000 12:00:00 AM 7   Permit Number 42953 6005718.46144 2093462.75751 37.728573751977 -122.422487410986 (37.728573751977, -122.422487410986) 9 7 7 309 5
51718 43139 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1 Gambier St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/11/2000 12:00:00 AM 4   Permit Number 42953 6005713.11166 2093478.24293 37.7286159697368 -122.422507005398 (37.7286159697368, -122.422507005398) 9 7 7 309 5
165181 43138 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1 Gambier St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/11/2000 12:00:00 AM 4   Permit Number 42953 6005709.81909 2093489.20943 37.7286458955884 -122.422519166951 (37.7286458955884, -122.422519166951) 9 7 7 309 5
179940 62390 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 259 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1985 12:00:00 AM     Permit Number 22540 6000848.37769972 2093515.20006186 37.7284418053746 -122.439327280294 (37.7284418053746, -122.439327280294) 9 7 6 28861 25
146059 67909 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 124 Judson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1993 12:00:00 AM     Permit Number 32837 5999245.55939042 2093517.24429142 37.7283560753919 -122.444868429871 (37.7283560753919, -122.444868429871) 9 7 4 28861 40
114407 68863 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 152 Judson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1993 12:00:00 AM     Permit Number 32826 5999067.96340072 2093519.65088656 37.7283525462917 -122.445482558018 (37.7283525462917, -122.445482558018) 9 7 4 28861 40
106884 177525 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 100 Yale St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006897.82744 2093555.37403 37.7288945185586 -122.418416832071 (37.7288945185586, -122.418416832071) 9 3 7 309 5
16439 67516 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 327 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/22/1992 12:00:00 AM     Permit Number 31052 5997915.17390153 2093778.82856929 37.7289983088646 -122.449486452558 (37.7289983088646, -122.449486452558) 9 7 4 28861 40
184631 47495 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 222 Cotter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM 10   Permit Number 45388 6001706.9707 2093841.21109 37.7293857804089 -122.436382409642 (37.7293857804089, -122.436382409642) 9 7 6 28861 25
83465 68848 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 227 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1993 12:00:00 AM     Permit Number 32811 5999239.62014085 2094052.0632873 37.7298242245316 -122.444927391996 (37.7298242245316, -122.444927391996) 9 7 4 28861 40
188615 68833 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 178 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/30/1993 12:00:00 AM     Permit Number 32784 5999570.75659197 2094098.77581282 37.7299713792854 -122.443785974037 (37.7299713792854, -122.443785974037) 9 7 4 63 40
25626 68823 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 306 Detroit St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/30/1993 12:00:00 AM     Permit Number 32772 5999450.43970514 2094100.18276953 37.729968379033 -122.444202023687 (37.729968379033, -122.444202023687) 9 7 4 63 40
144783 47523 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 253 Theresa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM 10   Permit Number 45394 6001752.07719 2094109.13644 37.7301240051048 -122.436245638924 (37.7301240051048, -122.436245638924) 9 7 6 28861 25
55302 42355 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 380X Flood Ave 14 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 9 8x90 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
70737 42344 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 380X Flood Ave 3 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 8 8x45 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
193722 77213 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 499X Hearst Ave 20 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 8 6x50   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
154668 66320 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 221 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29437 6000609.84219196 2094923.1600046 37.7322941604972 -122.440252834618 (37.7322941604972, -122.440252834618) 9 7 4 63 40
140306 57830 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 307 Baden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29419 6000730.804091 2094971.1282722 37.7324327564376 -122.439838080651 (37.7324327564376, -122.439838080651) 9 7 5 63 40
115628 66305 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 309 Baden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29420 6000730.88542732 2094976.31898746 37.7324470135678 -122.439838171481 (37.7324470135678, -122.439838171481) 9 7 5 63 40
43590 66306 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 311 Baden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29421 6000730.96676364 2094981.50970271 37.7324612706981 -122.439838262312 (37.7324612706981, -122.439838262312) 9 7 5 63 40
60513 66307 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 312 Baden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29422 6000783.0417172 2094985.88569991 37.7324762502781 -122.439658540918 (37.7324762502781, -122.439658540918) 9 7 5 63 40
91979 66308 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 324 Baden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29423 6000783.52973512 2095017.02999143 37.7325617930594 -122.439659085695 (37.7325617930594, -122.439659085695) 9 7 5 63 40
188557 231955 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 136 Marsily St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004248.08815 2095120.37618 37.7330421432752 -122.42768862922 (37.7330421432752, -122.42768862922) 9 7 5 28861 25
111329 67925 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 118 Milton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM     Permit Number 31638 6003735.12063535 2095135.9515003 37.7330558796375 -122.42946320321 (37.7330558796375, -122.42946320321) 9 7 5 28861 25
103700 66325 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 131 Mangels Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1990 12:00:00 AM     Permit Number 29444 6000554.87735499 2095194.20587313 37.7330352599042 -122.440462292733 (37.7330352599042, -122.440462292733) 9 7 5 63 40
34670 66326 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 135 Mangels Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1990 12:00:00 AM     Permit Number 29445 6000528.81306712 2095194.53475792 37.7330346787859 -122.440552427184 (37.7330346787859, -122.440552427184) 9 7 5 63 40
87351 67921 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 136 Marsily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM     Permit Number 31632 6004231.25027354 2095231.88967626 37.7333473817874 -122.427754784883 (37.7333473817874, -122.427754784883) 9 7 5 28861 25
99696 66392 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 736 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29518 6007726.21493711 2095490.25955401 37.7342538931553 -122.41568997407 (37.7342538931553, -122.41568997407) 2 7 7 28859 2
100849 67916 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 28 Cuvier St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM     Permit Number 31626 6003939.73244877 2095599.86834432 37.7343412731947 -122.428788866832 (37.7343412731947, -122.428788866832) 2 7 5 28861 25
167755 231969 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 78 Saint Marys Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6004355.63348 2095669.80517 37.7345568345381 -122.427355942145 (37.7345568345381, -122.427355942145) 2 7 5 28861 2
98619 67938 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 86 Saint Mary's Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM     Permit Number 31651 6004312.01802966 2095698.91217619 37.7346342889879 -122.427508808325 (37.7346342889879, -122.427508808325) 2 7 5 28861 2
32169 231956 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 162 College Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6004841.81484 2095922.14472 37.7352771869788 -122.425693003951 (37.7352771869788, -122.425693003951) 2 7 5 28861 2
22314 231968 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 177 College Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6004880.9264 2095958.67753 37.735379707894 -122.425560380023 (37.735379707894, -122.425560380023) 2 7 5 28861 2
128399 66439 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 256 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM     Permit Number 29583 6006068.54082746 2096076.77967326 37.7357710232065 -122.421462732945 (37.7357710232065, -122.421462732945) 2 7 7 28859 2
174951 47805 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 51 Escondido Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2002 12:00:00 AM 0   Permit Number 45573 5986262.03154998 2096094.88833599 37.7346840880203 -122.489941970727 (37.7346840880203, -122.489941970727) 1 8 3 64 35
123369 45291 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 678 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/2005 12:00:00 AM     Permit Number 47958 6007614.60724398 2096238.5150245 37.7363021643783 -122.416128813466 (37.7363021643783, -122.416128813466) 2 7 7 28859 2
66509 67173 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 308 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1992 12:00:00 AM     Permit Number 30617 6006778.80431339 2096277.81486238 37.7363630429498 -122.419021324056 (37.7363630429498, -122.419021324056) 2 7 7 28859 2
161821 231948 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 365 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6007200.80171 2096289.89745 37.7364199734891 -122.417563155128 (37.7364199734891, -122.417563155128) 2 7 7 28859 2
31598 5809 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 25 Dukes Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/09/1998 12:00:00 AM 6 3X4   6016112.32175 2096327.0001 37.7370192646182 -122.386754585178 (37.7370192646182, -122.386754585178) 10 3 8 58 1
127670 45284 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 541 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/2001 12:00:00 AM     Permit Number 44126 6008215.69383326 2096339.71567531 37.7366138182396 -122.414057758062 (37.7366138182396, -122.414057758062) 2 7 7 28859 2
14127 45367 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 546 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/28/2001 12:00:00 AM     Permit Number 44192 6007805.03016333 2096352.99475391 37.7366272057089 -122.415478542826 (37.7366272057089, -122.415478542826) 2 7 7 28859 2
25935 66407 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 533 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29534 6008039.98859373 2096389.06187115 37.7367394418447 -122.414668739511 (37.7367394418447, -122.414668739511) 2 7 7 28859 2
34596 66400 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 531 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29526 6007491.7583768 2096409.40123315 37.7367644721833 -122.416565655603 (37.7367644721833, -122.416565655603) 2 7 7 28859 2
53579 66397 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 508 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29523 6007446.33784222 2096483.57459282 37.7369655813708 -122.416727947771 (37.7369655813708, -122.416727947771) 2 7 7 28859 2
42735 63835 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 480 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1987 12:00:00 AM     Permit Number 24525 6007455.04270761 2096578.56376841 37.737226890345 -122.416704578376 (37.737226890345, -122.416704578376) 2 7 7 28859 2
159201 231947 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1101 San Jose Ave 64 Sidewalk: Curb side : Yard Tree Private 2     4 Width 8ft   6005025.65555 2096592.3987 37.7371279405099 -122.425105073942 (37.7371279405099, -122.425105073942) 2 7 5 28859 2
144291 66433 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 118 Highland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/1991 12:00:00 AM     Permit Number 29576 6005529.27345058 2096644.50573799 37.7372994514328 -122.423367539465 (37.7372994514328, -122.423367539465) 2 7 7 28859 2
177910 59774 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 460 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/24/1991 12:00:00 AM     Permit Number 29632 6007462.52860048 2096660.25076168 37.7374516058806 -122.416684481311 (37.7374516058806, -122.416684481311) 2 7 7 28859 2
184194 63836 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 449 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1987 12:00:00 AM     Permit Number 24527 6007531.71339338 2096844.47873768 37.7379613462812 -122.416458322142 (37.7379613462812, -122.416458322142) 2 7 7 28859 2
172297 63837 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 443 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1987 12:00:00 AM     Permit Number 24528 6007534.27332128 2096872.17856811 37.7380375478753 -122.416451432701 (37.7380375478753, -122.416451432701) 2 7 7 28859 2
174781 193532 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 200 Jennings St 7 : Tree Private 2     2 Width 3ft   6018580.21539 2096908.74747 37.7387529542923 -122.378262250201 (37.7387529542923, -122.378262250201) 10 3 8 58 1
168613 25930 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1940 Oakdale Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   12/24/2008 12:00:00 AM 12 3x3   6013172.33562 2096908.97422 37.7384540331375 -122.396960298598 (37.7384540331375, -122.396960298598) 10 3 8 58 1
98723 231959 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 500 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6007536.6214 2096940.11899 37.7382242293514 -122.416448125283 (37.7382242293514, -122.416448125283) 2 7 7 28859 2
163588 63364 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 103 Holly Park Cir 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1992 12:00:00 AM     Permit Number 30639 6006732.73114879 2096957.82345997 37.7382276012884 -122.419228840922 (37.7382276012884, -122.419228840922) 2 7 7 28859 2
85647 193531 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 200 Jennings St 4 : Tree Private 2     3 Width 3ft   6018621.46299 2096962.90365 37.7389039297614 -122.378123392174 (37.7389039297614, -122.378123392174) 10 3 8 58 1
186935 62942 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 375 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1992 12:00:00 AM     Permit Number 30478 6006773.07754365 2097002.00015366 37.7383511728239 -122.419092475387 (37.7383511728239, -122.419092475387) 2 7 7 28859 2
99971 231960 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 500 Andover St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007542.74737 2097017.75117 37.7384377347063 -122.416432442006 (37.7384377347063, -122.416432442006) 2 7 7 28859 2
58332 231961 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 500 Andover St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007544.54493 2097042.23546 37.7385050642556 -122.416427960701 (37.7385050642556, -122.416427960701) 2 7 7 28859 2
175004 231962 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 500 Andover St 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6007543.01124 2097062.2707 37.7385599903583 -122.416434682233 (37.7385599903583, -122.416434682233) 2 7 7 28859 2
84836 66660 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1500 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1992 12:00:00 AM   3x3 Permit Number 31265 6016229.06481316 2097072.60827917 37.7390730165912 -122.386402918839 (37.7390730165912, -122.386402918839) 10 3 8 58 1
91294 231963 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 500 Andover St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007553.14308 2097114.00894 37.7387026219233 -122.416403314785 (37.7387026219233, -122.416403314785) 2 7 7 28859 2
77589 63838 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 310 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1987 12:00:00 AM     Permit Number 24529 6007512.21907746 2097215.58579661 37.7389792281053 -122.416552004438 (37.7389792281053, -122.416552004438) 2 7 7 28859 2
29365 231964 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 332 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008801.63861 2097226.11377 37.7390805674202 -122.412094512652 (37.7390805674202, -122.412094512652) 10 7 7 28859 2
170715 66902 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 280 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1991 12:00:00 AM     Permit Number 30220 6007505.06075356 2097348.955435 37.7393450290906 -122.416586199821 (37.7393450290906, -122.416586199821) 2 7 7 28859 2
164763 66919 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 256 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1991 12:00:00 AM   3x3 Permit Number 30240 6007515.01387925 2097464.03098478 37.7396615608777 -122.416559935715 (37.7396615608777, -122.416559935715) 2 7 7 28859 2
124362 231967 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 36 Gladys St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6005715.33692 2097471.12412 37.7395796596638 -122.422782959663 (37.7395796596638, -122.422782959663) 2 7 7 28859 2
191295 66903 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 228 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1991 12:00:00 AM     Permit Number 30221 6007526.62585922 2097598.28579286 37.7400308479341 -122.416529293976 (37.7400308479341, -122.416529293976) 2 7 7 28859 2

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);