8,659 rows where qSpecies_id = 11 sorted by Supervisor Districts

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)
41135 249482 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1400x Van Ness Ave 2 Median : Cutout Tree DPW 1     7 Width 3ft   6006310.58907 2115387.0991 37.7888062741271 -122.421997218416 (37.7888062741271, -122.421997218416) 13 9 1 28858 21
42328 29773 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1323 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/19/2006 12:00:00 AM 8 3x3   6007274.40422 2121764.03489 37.8063700535072 -122.41911505491 (37.8063700535072, -122.41911505491) 5 1 1 28858 32
42472 250057 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1353 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6006085.94998 2114865.54265 37.7873615375443 -122.422737359534 (37.7873615375443, -122.422737359534) 13 9 1 28858 41
42721 49663 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 7   Permit Number 46510 6000228.83335 2120782.17575 37.8032748487093 -122.443426854966 (37.8032748487093, -122.443426854966) 13 9 1 57 17
43306 18899 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2575 Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1     2 3X3   6002504.45373 2115758.05504 37.7896094280702 -122.435192436588 (37.7896094280702, -122.435192436588) 13 9 1 29490 27
43446 44173 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 3898 Washington St 5 Sidewalk: Curb side : Cutout Tree Private 2   10/17/2007 12:00:00 AM   3x3 Permit Number 49758 5996140.20734213 2115579.73573661 37.7887563568945 -122.457199029036 (37.7887563568945, -122.457199029036) 11 6 1 54 31
43473 82028 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2787 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/14/2017 09:51:00 AM 3     6000618.2299 2114794.646 37.7868568655877 -122.441649390834 (37.7868568655877, -122.441649390834) 13 6 1 29490 27
44246 45384 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   2 Sidewalk: Curb side : Cutout Tree Private 2   07/06/2001 12:00:00 AM     Permit Number 44200 5989322.60767277 2117225.76237725 37.7928819736725 -122.480907237859 (37.7928819736725, -122.480907237859) 11   1 61 30
44601 12807 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2100X Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/18/2003 12:00:00 AM 20 5   5988897.58667 2114714.29686 37.7859614909645 -122.482193733009 (37.7859614909645, -122.482193733009) 11 6 1 55 33
44816 116496 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2501x Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 4x4   6002673.7687 2116111.86994 37.790590526381 -122.434631935029 (37.790590526381, -122.434631935029) 13 9 1 29490 27
44886 49661 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 9 Sidewalk: Curb side : Cutout Tree Private 2   04/18/2011 12:00:00 AM 8   Permit Number 46510 6000222.49515 2120829.72457 37.8034050435642 -122.443452205969 (37.8034050435642, -122.443452205969) 13 9 1 57 17
45305 94902 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 3701 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2010 12:00:00 AM     Permit Number 53961 5997125 2115346 37.78817108981 -122.453774920639 (37.78817108981, -122.453774920639) 11 6 1 54 31
45588 129854 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2545 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6000840.45885 2118233.90287 37.7963128271162 -122.441127374852 (37.7963128271162, -122.441127374852) 13 9 1 57 17
45903 12717 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1500X Lake St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/08/1994 12:00:00 AM 65 3x3   5990792.41803 2114766.86784 37.7862158664455 -122.475642042646 (37.7862158664455, -122.475642042646) 11 6 1 54 33
45920 39912 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1926 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41189 6001051.29800396 2114980.79776064 37.7873926549284 -122.44016443305 (37.7873926549284, -122.44016443305) 13 6 1 29490 27
45985 99003 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14         Permit Number 46510 6000381.4 2120794.3 37.8033168379221 -122.442899765771 (37.8033168379221, -122.442899765771) 13 9 1 57 17
46241 13215 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2218 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2003 12:00:00 AM   3X3   6001723.32387 2119444.12324 37.7996860231337 -122.43815922186 (37.7996860231337, -122.43815922186) 13 9 1 57 17
46521 122247 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 47 Lake St 1 Sidewalk: Property side : Yard Tree Private 2     16 Width 4ft   5990771.99578 2114778.57066 37.7862468151678 -122.475713552448 (37.7862468151678, -122.475713552448) 11 6 1 54 33
47167 40137 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2760 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/31/1999 12:00:00 AM 10   Permit Number 41340 6000317.4874 2117510.86907 37.7942977647882 -122.442885012557 (37.7942977647882, -122.442885012557) 13 9 1 57 27
48155 107646 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1600X Franklin St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3   Permit Number 773331 6005773.76538 2115716.99395 37.7896817924241 -122.423878022401 (37.7896817924241, -122.423878022401) 13 9 1 28858 41
48189 129891 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3751 Sacramento St 12 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5996747.37477 2114962.34995 37.7870960324911 -122.455053698681 (37.7870960324911, -122.455053698681) 11 6 1 54 31
48515 124258 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300 Lake St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 6ft   5994743.00178 2114922.14665 37.7868704533367 -122.461985420107 (37.7868704533367, -122.461985420107) 11 6 1 54 11
48942 130255 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2320 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 6ft   6007588.34652 2120300.03904 37.8023679660663 -122.417924753627 (37.8023679660663, -122.417924753627) 5 1 1 308 32
48998 98105 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 850 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6001068 2114562 37.7862436951175 -122.440076605796 (37.7862436951175, -122.440076605796) 13 6 1 29490 27
49182 9893 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1700 Gough St 5 Sidewalk: Curb side : Cutout Tree DPW 1     9 3X3   6005337.6793 2115599.88016 37.7893355988943 -122.425378500212 (37.7893355988943, -122.425378500212) 13 9 1 28858 41
49332 26738 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1300 Post St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/15/2014 12:00:00 AM 3 3X3   6005838.31144 2114533.71115 37.7864364355288 -122.42357053736 (37.7864364355288, -122.42357053736) 13 9 1 28858 41
49385 34897 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2869 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/1997 12:00:00 AM 13 5x12 Permit Number 38502 5999275.6345 2118015.37674 37.7956235561453 -122.446526243416 (37.7956235561453, -122.446526243416) 13 9 1 57 17
49537 68226 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1424 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/27/1993 12:00:00 AM     Permit Number 32020 5991070.89524841 2114789.64633569 37.7862945499483 -122.474680257183 (37.7862945499483, -122.474680257183) 11 6 1 54 33
49811 129942 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2300 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6005058.65641 2117533.91236 37.7946301955676 -122.426481654525 (37.7946301955676, -122.426481654525) 13 9 1 28858 27
50545 30980 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1994 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 17   Permit Number 34767 6004672.88111 2117091.45468 37.7933935036642 -122.427784946623 (37.7933935036642, -122.427784946623) 13 9 1 28858 27
50981 96611 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3652 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2011 12:00:00 AM 5   Permit Number 767972 5997367.41166 2115420.25767 37.7883888763049 -122.452941584197 (37.7883888763049, -122.452941584197) 11 6 1 54 31
51055 18031 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2790 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6000589.8945322 2114844.0214774 37.7869908234104 -122.441750969288 (37.7869908234104, -122.441750969288) 13 6 1 29490 27
51690 129934 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2245 Vallejo St 6 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6002908.44917 2117824.39253 37.7953059929233 -122.433942417617 (37.7953059929233, -122.433942417617) 13 9 1 29490 27
51749 49665 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 6   Permit Number 46510 6000243.34961 2120687.49551 37.8030157099616 -122.443369816371 (37.8030157099616, -122.443369816371) 13 9 1 57 17
51973 106945 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 1150 LOMBARD ST 4 Front Yard : Yard Tree Private 2     13   Permit Number 773092 6006825 2120436.8 37.8027004869705 -122.420576026126 (37.8027004869705, -122.420576026126) 5 1 1 28858 32
52106 129888 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3751 Sacramento St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5996890.78508 2114983.2227 37.7871615696854 -122.454559041882 (37.7871615696854, -122.454559041882) 11 6 1 54 31
53048 129858 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 112 Moulton St 5 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002518.41225 2119368.65314 37.7995239887052 -122.43540252722 (37.7995239887052, -122.43540252722) 13 9 1 57 17
54974 45388 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   1 Sidewalk: Curb side : Cutout Tree Private 2   07/06/2001 12:00:00 AM     Permit Number 44200 5989322.60767277 2117225.76237725 37.7928819736725 -122.480907237859 (37.7928819736725, -122.480907237859) 11   1 61 30
55169 116499 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2501x Clay St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4   6002743.95619 2116120.48888 37.7906181760269 -122.434389707131 (37.7906181760269, -122.434389707131) 13 9 1 29490 27
55584 68144 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2564 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/03/1993 12:00:00 AM     Permit Number 31901 6000326.20966373 2114114.12374563 37.7849716854356 -122.442610830361 (37.7849716854356, -122.442610830361) 15 6 1 29490 27
55668 34594 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3196 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 7   Permit Number 38289 5999039.4413 2116637.89487 37.7918278631246 -122.447244322395 (37.7918278631246, -122.447244322395) 11 6 1 29490 30
55748 17751 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1661 Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 3X3   6005900.15955 2115529.82964 37.7891750204629 -122.423427399464 (37.7891750204629, -122.423427399464) 13 9 1 28858 41
56196 17750 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1661 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/20/2000 12:00:00 AM 4 3X3   6005879.38988 2115527.91702 37.7891685966102 -122.423499124012 (37.7891685966102, -122.423499124012) 13 9 1 28858 41
56316 129898 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 400 Cherry St 6 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5996260.81247 2114721.3486 37.7864063819923 -122.456719650485 (37.7864063819923, -122.456719650485) 11 6 1 54 31
56513 29750 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1333 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2006 12:00:00 AM 8 3x3   6007187.30847 2121846.91915 37.8065927274426 -122.419422349675 (37.8065927274426, -122.419422349675) 5 1 1 28858 32
57681 12756 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1738 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/04/1996 12:00:00 AM 12 3X3   5990012.64242 2114751.50661 37.7861284523683 -122.478338709075 (37.7861284523683, -122.478338709075) 11 6 1 55 33
58118 36175 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 3450 Geary Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/04/1998 12:00:00 AM     Permit Number 39248 5996359.55674118 2112911.23261697 37.781441954704 -122.456247095506 (37.781441954704, -122.456247095506) 11 6 1 54 31
58548 13188 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2051X Lombard St 5 Sidewalk: Curb side : Cutout Tree DPW 1   03/15/2014 12:00:00 AM 1 3x3   6002574.7502816 2119473.5963948 37.7998153348368 -122.435215088035 (37.7998153348368, -122.435215088035) 13 9 1 57 17
59022 13117 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1626 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/15/2014 12:00:00 AM 3 3X3   6004541.8938 2119838.8489 37.8009297345413 -122.428434086559 (37.8009297345413, -122.428434086559) 13 9 1 57 17
59152 129959 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1711 Green St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004840.53299 2118439.74682 37.7971050534142 -122.427300947694 (37.7971050534142, -122.427300947694) 13 9 1 57 17
59551 35247 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 7 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38736 6005802.2 2120854.7 37.8037902383764 -122.424145173625 (37.8037902383764, -122.424145173625) 5 9 1 28858 32
59618 130246 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2638 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6006610.28866 2120310.8084 37.8023424433035 -122.421310085112 (37.8023424433035, -122.421310085112) 5 9 1 28858 32
59654 14475 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 250 Masonic Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   5999023.61918 2112089.68788 37.7793387721051 -122.446971627792 (37.7793387721051, -122.446971627792) 15 5 1 54 16
59847 116495 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2501x CLAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6002786 2116136 37.7906631519982 -122.434245347461 (37.7906631519982, -122.434245347461) 13 9 1 29490 27
60386 44073 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1350 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2000 12:00:00 AM 11   Permit Number 43596 5991224.72438 2114799.36352 37.7863301429585 -122.474148762674 (37.7863301429585, -122.474148762674) 11 6 1 54 33
60633 14458 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 150X Masonic Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/15/2008 12:00:00 AM 3 3X3   5998939.65945 2112558.4834 37.7806211661612 -122.447295828362 (37.7806211661612, -122.447295828362) 15 5 1 54 16
61248 26762 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1500X Franklin St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6005883.21897 2115261.30457 37.7884367612686 -122.423466913964 (37.7884367612686, -122.423466913964) 13 9 1 28858 41
61465 68134 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1626 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM     Permit Number 31886 6000649.34416563 2114229.75316348 37.7853075884876 -122.44150119163 (37.7853075884876, -122.44150119163) 15 6 1 29490 27
62009 129850 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3161 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6003755.93 2119579.28161 37.8001725230921 -122.431135316047 (37.8001725230921, -122.431135316047) 13 9 1 57 17
62640 121059 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2901x Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005984 2121043 37.8043175249008 -122.423529438764 (37.8043175249008, -122.423529438764) 5 1 1 28858 32
62641 130232 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2013 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/16/2018 12:00:00 AM 3 Width 4ft Permit Number 782588 6007201.62912 2119237.06192 37.7994275274066 -122.419187542977 (37.7994275274066, -122.419187542977) 5 1 1 28858 32
62936 129861 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3718 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6000182.92875 2121074.01431 37.8040735411278 -122.443606686105 (37.8040735411278, -122.443606686105) 13 9 1 57 17
63315 130251 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2333 Leavenworth St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007534.87604 2120327.1071 37.8024392787168 -122.418111708292 (37.8024392787168, -122.418111708292) 5 1 1 28858 32
64688 52995 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1810 PINE ST   Sidewalk: Curb side : Cutout Tree Private 2   08/16/2006 12:00:00 AM   3x3 Permit Number 48976 6005259 2115487 37.7890212126999 -122.425642684361 (37.7890212126999, -122.425642684361) 13 9 1 28858 27
64920 129876 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1800 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6000565.08752 2121366.41121 37.8048981726751 -122.442305206121 (37.8048981726751, -122.442305206121) 13 9 1 57 17
64956 41635 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 100 Jordan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/01/2000 12:00:00 AM     Permit Number 42113 5996241.92564567 2113793.75965037 37.7838583861175 -122.456717884501 (37.7838583861175, -122.456717884501) 11 6 1 54 31
65009 48498 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2312(REVISED) Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM     Permit Number 45838 6007594.14807985 2120292.61587813 37.8023479104406 -122.417904150819 (37.8023479104406, -122.417904150819) 5 1 1 308 32
65107 12719 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1522 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   5990686.46435 2114778.99732 37.7862430276294 -122.476009497029 (37.7862430276294, -122.476009497029) 11 6 1 54 33
65561 129883 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3140 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5999094.06877 2116642.96292 37.7918448998751 -122.447055676983 (37.7918448998751, -122.447055676983) 11 6 1 29490 30
65886 53069 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1863 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2006 12:00:00 AM 4 3x3 Permit Number 49040 6003471.12820952 2119597.08628901 37.8002052672436 -122.432122112481 (37.8002052672436, -122.432122112481) 13 9 1 57 17
65973 14463 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 150X Masonic Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1   01/15/2008 12:00:00 AM 3 3x3   5998939.65945 2112558.4834 37.7806211661612 -122.447295828362 (37.7806211661612, -122.447295828362) 15 5 1 54 16
66181 87754 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 19 Cook St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/27/2008 12:00:00 AM   3x3 Permit Number 50410 5997460 2113566 37.7833028815315 -122.452487379595 (37.7833028815315, -122.452487379595) 15 6 1 54 31
66892 12853 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2430 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/26/2001 12:00:00 AM 18 4X4   5987942.80456 2114670.37051 37.7857853007681 -122.485493751784 (37.7857853007681, -122.485493751784) 11 6 1 55 33
67160 116491 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2147 Lyon St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   5999352.0889 2116219.58712 37.7906971598868 -122.446132463558 (37.7906971598868, -122.446132463558) 13 6 1 29490 31
68320 137118 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2150 North Point St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   01/20/2015 12:00:00 AM 0 Width 4ft Permit Number 771149 6000490.48443 2120659.70119 37.8029534840902 -122.442512606897 (37.8029534840902, -122.442512606897) 13 9 1 57 17
68472 250933 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 258 28th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 4ft   5987147.60505 2114230.18053 37.7845303035608 -122.488212522694 (37.7845303035608, -122.488212522694) 11 6 1 55 33
68582 107647 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1600X Franklin St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3   Permit Number 773331 6005773.76538 2115716.99395 37.7896817924241 -122.423878022401 (37.7896817924241, -122.423878022401) 13 9 1 28858 41
68796 14453 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100 Masonic Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5998924.1725 2112667.0746 37.7809184444903 -122.447357223078 (37.7809184444903, -122.447357223078) 15 5 1 54 16
68945 9896 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1800X Pine St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2007 12:00:00 AM 3 3X3   6004999.6173 2115457.4476 37.7889254092316 -122.426538009917 (37.7889254092316, -122.426538009917) 13 9 1 28858 27
69012 129859 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 229 Pixley St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6002241.84831 2118957.72082 37.7983799656199 -122.436330110469 (37.7983799656199, -122.436330110469) 13 9 1 57 17
69382 52411 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2750X Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2013 12:00:00 AM   5x5 Permit Number 769980 6000654 2117712 37.7948691967916 -122.441735085064 (37.7948691967916, -122.441735085064) 13 9 1 57 27
69481 129943 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2300 Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6005055.38542 2117545.63857 37.7946622078574 -122.426493807942 (37.7946622078574, -122.426493807942) 13 9 1 28858 27
70429 87756 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 19 Cook St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/27/2008 12:00:00 AM   3x3 Permit Number 50410 5997460 2113566 37.7833028815315 -122.452487379595 (37.7833028815315, -122.452487379595) 15 6 1 54 31
70863 65091 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1830 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1989 12:00:00 AM     Permit Number 27056 5989804.11356074 2114740.85049779 37.7860870860237 -122.479059375757 (37.7860870860237, -122.479059375757) 11 6 1 55 33
71113 42638 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1651 Union St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/22/2016 02:49:00 PM 3 5x5 Permit Number 42688 6005231.45083 2118842.40752 37.7982327574016 -122.425976953174 (37.7982327574016, -122.425976953174) 13 9 1 57 17
71380 129910 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3101 Van Ness Ave 17 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6005467.67917 2121063.89893 37.8043457515267 -122.425317698873 (37.8043457515267, -122.425317698873) 13 1 1 28858 17
71643 121056 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2901x Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005984 2121043 37.8043175249008 -122.423529438764 (37.8043175249008, -122.423529438764) 5 1 1 28858 32
71791 76065 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 6 4x4   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
71933 26763 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1500X Franklin St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6005883.21897 2115261.30457 37.7884367612686 -122.423466913964 (37.7884367612686, -122.423466913964) 13 9 1 28858 41
72004 87557 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 408X Lake St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private 08/03/2007 12:00:00 AM 3 3x3   5994236.22519 2114896.53302 37.7867709361644 -122.463736876784 (37.7867709361644, -122.463736876784) 11 6 1 54 11
73284 13119 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1641 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/11/2019 12:00:00 AM 3 3x3 Permit Number 782191 6004501.8382 2119760.0821 37.8007111944994 -122.428567078189 (37.8007111944994, -122.428567078189) 13 9 1 57 17
73355 7132 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 408X Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2008 12:00:00 AM 5 4X4   5994235.92349 2114901.52504 37.7867846255071 -122.463738283047 (37.7867846255071, -122.463738283047) 11 6 1 54 11
74324 249484 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1400x Van Ness Ave 4 Median : Cutout Tree DPW 1     5 Width 3ft   6006293.02954 2115454.9396 37.7889915569696 -122.422062793377 (37.7889915569696, -122.422062793377) 13 9 1 28858 21
75064 12666 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1108-1118 Lake St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/28/2013 12:00:00 AM 3 3x3   5992006.63192 2114826.47852 37.7864498571436 -122.471445564886 (37.7864498571436, -122.471445564886) 11 6 1 54 11
75069 47415 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   05/14/2002 12:00:00 AM 9   Permit Number 45326 6000240.55787 2120707.38669 37.8030701666099 -122.443380906816 (37.8030701666099, -122.443380906816) 13 9 1 57 17
75178 114538 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 172 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM 0 3x3 Permit Number 776379 5988062.82598 2114836.36547 37.7862480675093 -122.485090700079 (37.7862480675093, -122.485090700079) 11 6 1 55 33
76631 36890 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3193 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM 6   Permit Number 39544 5999051.40531 2116589.36278 37.7916952904572 -122.447199432709 (37.7916952904572, -122.447199432709) 13 6 1 29490 31
76830 99000 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2190X North Point St 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641) 13 9 1 57 17
76955 99004 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14         Permit Number 46510 6000381.4 2120794.3 37.8033168379221 -122.442899765771 (37.8033168379221, -122.442899765771) 13 9 1 57 17
77070 129896 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 400 Cherry St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5996264.99029 2114681.22571 37.786296455158 -122.456702293584 (37.786296455158, -122.456702293584) 11 6 1 54 31

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)
);