trees

320 rows where qSpecies_id = 145 sorted by Supervisor Districts

✎ View and edit SQL

This data as json, CSV (advanced)

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)
845 35702 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   15 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
1180 35696 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   6 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
4226 35703 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   16 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
4373 35701 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   13 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
4732 35697 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   8 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
4846 35692 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   2 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
5266 35698 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   10 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
6671 35694 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   4 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
7472 35704 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   17 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
8118 35693 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   3 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
11339 35700 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   14 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
17394 35705 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   7 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
17489 35695 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   5 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
17537 35699 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   11 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
18253 35690 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145   9 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
26081 129751 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2320 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6000742.15542 2119656.12238 37.8002122659526 -122.441569636242 (37.8002122659526, -122.441569636242) 13 9 1 57 17
32409 39384 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2710 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM 7   Permit Number 40925 6000588.20452 2117202.12069 37.7934654530274 -122.441926131987 (37.7934654530274, -122.441926131987) 13 9 1 57 27
55303 122998 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 42 07th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     14 Width 4ft   5993660.47545 2115225.1028 37.7876399054327 -122.465752700208 (37.7876399054327, -122.465752700208) 11 6 1 54 11
66382 129748 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2300 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6000804.68172 2119664.29702 37.8002382734424 -122.441353858292 (37.8002382734424, -122.441353858292) 13 9 1 57 17
71233 129753 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2407 Clay St 6 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6003149.59406 2116175.6254 37.7907925833731 -122.432990165069 (37.7907925833731, -122.432990165069) 13 9 1 29490 27
71386 129756 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2315 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 5ft   6003701.89513 2116476.82371 37.7916509089176 -122.43110073801 (37.7916509089176, -122.43110073801) 13 9 1 29490 27
73025 64662 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2786 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/17/1989 12:00:00 AM 14 6x4 Permit Number 26052 5999613.31909 2118454.39818 37.7968482744962 -122.445389381638 (37.7968482744962, -122.445389381638) 13 9 1 57 17
100102 129752 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2407 Clay St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6003040.06059 2116163.94493 37.7907542983172 -122.433368310202 (37.7907542983172, -122.433368310202) 13 9 1 29490 27
101429 39387 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2710 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM 7   Permit Number 40925 6000579.41048 2117201.67826 37.7934637371134 -122.441956528179 (37.7934637371134, -122.441956528179) 13 9 1 57 27
105525 129749 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2300 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6000782.42382 2119661.2506 37.8002286408033 -122.441430660416 (37.8002286408033, -122.441430660416) 13 9 1 57 17
129360 129755 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2407 Clay St 8 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003208.43493 2116180.994 37.7908106615232 -122.432786962347 (37.7908106615232, -122.432786962347) 13 9 1 29490 27
136315 39385 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2710 Broadway 4 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM 9   Permit Number 40925 6000567.4477 2117199.73959 37.7934577323376 -122.441997780973 (37.7934577323376, -122.441997780973) 13 9 1 57 27
141698 129750 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2320 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6000760.50701 2119657.6711 37.8002175638503 -122.441506243943 (37.8002175638503, -122.441506243943) 13 9 1 57 17
149057 39386 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2710 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM 9   Permit Number 40925 6000600.16704 2117204.05937 37.7934714577907 -122.441884880082 (37.7934714577907, -122.441884880082) 13 9 1 57 27
149516 49588 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2333 REVISED Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2003 12:00:00 AM 16   Permit Number 46464 6003709.90767 2116419.21464 37.7914931831193 -122.431068901134 (37.7914931831193, -122.431068901134) 13 9 1 29490 27
157192 129757 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2315 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6003704.65718 2116456.32668 37.7915947858084 -122.431089717742 (37.7915947858084, -122.431089717742) 13 9 1 29490 27
162059 129754 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2407 Clay St 7 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6003179.18897 2116177.33789 37.7907989640458 -122.432887890589 (37.7907989640458, -122.432887890589) 13 9 1 29490 27
10517 129837 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 733 Front St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6012785.65581 2118614.39014 37.7980307075983 -122.399820962885 (37.7980307075983, -122.399820962885) 3 1 10 28860 6
12984 38495 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1353 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1998 12:00:00 AM 9 3x3 Permit Number 40489 6006548.48859 2118678.24733 37.7978563596483 -122.421407937635 (37.7978563596483, -122.421407937635) 13 9 10 28858 32
14628 96325 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1300X Sansome St 8 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2011 12:00:00 AM 5 4x4 Permit Number 768012 6011919 2120150.9 37.8022012393453 -122.402927984504 (37.8022012393453, -122.402927984504) 3 1 10 28860 6
19163 129769 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 80 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   6013010.632 2119281.7619 37.7998756901686 -122.399089343701 (37.7998756901686, -122.399089343701) 3 1 10 28860 6
22641 129809 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 901 Sacramento St 8 Sidewalk: Curb side : Pot Tree Private 2     12 Width 3ft   6010417.7029 2116870.15869 37.7931091785103 -122.407891739714 (37.7931091785103, -122.407891739714) 3 1 10 28857 4
28094 129831 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 354 Sacramento St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6012476.45918 2117195.30949 37.7941170091435 -122.40079112993 (37.7941170091435, -122.40079112993) 3 1 10 28860 4
29034 129824 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 333 Battery St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6012608.14 2117404.20841 37.7946979397237 -122.400350177025 (37.7946979397237, -122.400350177025) 3 1 10 28860 4
29140 108656 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1200x SANSOME ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011928 2119969 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163) 3 1 10 28860 23
29654 29755 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 532 Columbus Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     45 3x3   6010020.30224 2119411.75263 37.800065518477 -122.409446229453 (37.800065518477, -122.409446229453) 3 1 10 308 23
30466 129799 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Sansome St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6011905.71705 2120324.12534 37.8026761322601 -122.4029861412 (37.8026761322601, -122.4029861412) 3 1 10 28860 6
32934 129796 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Sansome St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6011917.98876 2120230.87285 37.8024207688713 -122.402937111974 (37.8024207688713, -122.402937111974) 3 1 10 28860 6
33465 96320 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1300X Sansome St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 4x4   6011919 2120150.9 37.8022012393453 -122.402927984504 (37.8022012393453, -122.402927984504) 3 1 10 28860 6
33900 103111 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 300 Post St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010691 2115198.3 37.7885339521538 -122.40682822806 (37.7885339521538, -122.40682822806) 5 1 10 28857 6
36379 63581 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1360 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/30/1987 12:00:00 AM 13   Permit Number 24204 6006506.63769 2118721.20057 37.7979719387185 -122.421555805959 (37.7979719387185, -122.421555805959) 13 9 10 28858 32
40742 129762 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2222 Polk St 6 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6006368.54903 2118610.8656 37.797661199563 -122.422025790757 (37.797661199563, -122.422025790757) 13 9 10 28858 32
40856 129790 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1160 Sansome St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6011945.5166 2120015.13463 37.8018299412604 -122.402826669824 (37.8018299412604, -122.402826669824) 3 1 10 28860 6
41885 129807 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 901 Sacramento St 6 Sidewalk: Curb side : Pot Tree Private 2     11 Width 3ft   6010390.20829 2116866.53247 37.7930976824694 -122.407986617304 (37.7930976824694, -122.407986617304) 3 1 10 28857 4
44116 129771 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 80 Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6012935.02914 2119270.4372 37.7998403818928 -122.399350164196 (37.7998403818928, -122.399350164196) 3 1 10 28860 6
44709 96323 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1300X Sansome St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 4x4   6011919 2120150.9 37.8022012393453 -122.402927984504 (37.8022012393453, -122.402927984504) 3 1 10 28860 6
47457 129798 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Sansome St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6011911.92184 2120288.00736 37.8025773075571 -122.402962127524 (37.8025773075571, -122.402962127524) 3 1 10 28860 6
47873 129815 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 433 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6012587.02488 2117167.29458 37.7940462531923 -122.400406589716 (37.7940462531923, -122.400406589716) 3 1 10 28860 6
49455 129816 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 433 Sacramento St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6012609.05006 2117170.52576 37.7940563534572 -122.400330606896 (37.7940563534572, -122.400330606896) 3 1 10 28860 6
50047 129847 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 103 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6012509.67235 2118803.01279 37.798533230779 -122.400789209861 (37.798533230779, -122.400789209861) 3 1 10 28860 6
55878 129828 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 354 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6012548.89522 2117204.86317 37.7941472812331 -122.400541163364 (37.7941472812331, -122.400541163364) 3 1 10 28860 4
55981 129840 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 238 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6012708.88892 2118533.80702 37.7978051657442 -122.400080938001 (37.7978051657442, -122.400080938001) 3 1 10 28860 6
56968 143040 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1760 Grant Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6010444.0727 2120551.0606 37.8032175128046 -122.408060206321 (37.8032175128046, -122.408060206321) 3 1 10 308 23
57735 97618 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 333 Battery St 3 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
61012 61067 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 532 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2002 12:00:00 AM     Permit Number 46064 6010044.29985327 2119322.50303189 37.7998218055895 -122.409356886218 (37.7998218055895, -122.409356886218) 3 1 10 308 23
61782 108657 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1200x SANSOME ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011928 2119969 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163) 3 1 10 28860 23
62138 129846 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 485 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6011762.70539 2118367.67112 37.7972961962093 -122.40334332134 (37.7972961962093, -122.40334332134) 3 1 10 308 4
62750 129804 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 901 Sacramento St 3 Sidewalk: Curb side : Pot Tree Private 2     12 Width 3ft   6010351.68054 2116862.21581 37.7930836728157 -122.408119621635 (37.7930836728157, -122.408119621635) 3 1 10 28857 4
62839 129795 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Sansome St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6011922.61764 2120202.56088 37.8023432895615 -122.402919101237 (37.8023432895615, -122.402919101237) 3 1 10 28860 6
62966 108652 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1200x SANSOME ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011928 2119969 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163) 3 1 10 28860 23
63039 129800 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Sansome St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6011900.25036 2120353.89385 37.8027575640746 -122.403007153861 (37.8027575640746, -122.403007153861) 3 1 10 28860 6
65779 96326 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1300X Sansome St 9 Sidewalk: Curb side : Cutout Tree Private 2     5 4x4   6011919 2120150.9 37.8022012393453 -122.402927984504 (37.8022012393453, -122.402927984504) 3 1 10 28860 6
66349 129826 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 333 Battery St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6012620.11049 2117309.34489 37.7944381345611 -122.400302091187 (37.7944381345611, -122.400302091187) 3 1 10 28860 4
66376 129763 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1379 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6006382.65003 2118656.35061 37.7977868852004 -122.421980230217 (37.7977868852004, -122.421980230217) 13 9 10 28858 32
67026 97617 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 333 Battery St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
67296 129812 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 435 Sacramento St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2018 12:00:00 AM 3 Width 3ft   6012517.23545 2117156.65433 37.794013145532 -122.400647322033 (37.794013145532, -122.400647322033) 4 1 10 28860 6
67507 115305 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1199x KEARNY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       6x5   6011077 2118941 37.7988320967672 -122.405756453764 (37.7988320967672, -122.405756453764) 3 1 10 308 23
67848 129786 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1160 Sansome St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6011965.83445 2119897.8199 37.8015089579449 -122.402748105054 (37.8015089579449, -122.402748105054) 3 1 10 28860 6
69464 96318 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1300X Sansome St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 4x4   6011857 2120322 37.802667576079 -122.403154578184 (37.802667576079, -122.403154578184) 3 1 10 308 23
69887 142486 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1501 STOCKTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6010093.7913 2119417.8989 37.8000865119614 -122.409192361945 (37.8000865119614, -122.409192361945) 3 1 10 308 23
69975 129767 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1375 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6006477.16604 2118669.59087 37.7978285696796 -122.421654118939 (37.7978285696796, -122.421654118939) 13 9 10 28858 32
72090 108651 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1200x SANSOME ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011928 2119969 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163) 3 1 10 28860 23
72850 129775 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 80 Vallejo St 7 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6012820.86947 2119255.17116 37.7997921017684 -122.399744129295 (37.7997921017684, -122.399744129295) 3 1 10 28860 6
73571 129849 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 103 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6012584.80341 2118810.70115 37.7985585314168 -122.400529771657 (37.7985585314168, -122.400529771657) 3 1 10 28860 6
73734 129810 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 435 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2018 12:00:00 AM 3 Width 3ft   6012477.08259 2117150.1123 37.7939929431787 -122.400785796051 (37.7939929431787, -122.400785796051) 4 1 10 28860 6
75864 129793 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1160 Sansome St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6011934.29934 2120106.56325 37.8020803556973 -122.402871921008 (37.8020803556973, -122.402871921008) 3 1 10 28860 6
77431 108649 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1200x SANSOME ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011928 2119969 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163) 3 1 10 28860 23
77678 129832 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 354 Sacramento St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6012451.48028 2117191.95794 37.7941064133197 -122.400877324536 (37.7941064133197, -122.400877324536) 3 1 10 28860 4
78811 129764 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1379 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006404.89602 2118659.8041 37.7977976222176 -122.421903498241 (37.7977976222176, -122.421903498241) 13 9 10 28858 32
81217 253611 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 900 Front St 12 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6012712.81893 2119514.81479 37.8004989968021 -122.400136271497 (37.8004989968021, -122.400136271497) 3 1 10 28860 6
81266 129784 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1600 Montgomery St 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6011334.32807 2120989.68408 37.8044716700829 -122.405010336152 (37.8044716700829, -122.405010336152) 3 1 10 28860 6
82047 129761 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2222 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6006380.65068 2118525.27839 37.7974268811919 -122.421977832627 (37.7974268811919, -122.421977832627) 13 9 10 28858 32
84419 129806 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 901 Sacramento St 5 Sidewalk: Curb side : Pot Tree Private 2     6 Width 3ft   6010377.17129 2116863.70379 37.7930891856797 -122.408031526727 (37.7930891856797, -122.408031526727) 3 1 10 28857 4
85481 62970 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1827 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/21/1986 12:00:00 AM 10   Permit Number 23357 6008241.17422 2118766.33453 37.7981935154844 -122.415556992457 (37.7981935154844, -122.415556992457) 5 1 10 28858 21
85887 129766 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1375 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6006461.42741 2118668.07402 37.7978235173022 -122.421708471292 (37.7978235173022, -122.421708471292) 13 9 10 28858 32
87581 129811 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 435 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6012498.50919 2117154.1734 37.7940052890658 -122.400711942828 (37.7940052890658, -122.400711942828) 4 1 10 28860 6
88454 129787 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1160 Sansome St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6011959.46477 2119924.96913 37.8015831474946 -122.402772057584 (37.8015831474946, -122.402772057584) 3 1 10 28860 6
88776 129827 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 354 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6012617.00039 2117213.20404 37.7941739812068 -122.400306096749 (37.7941739812068, -122.400306096749) 3 1 10 28860 4
89600 129814 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 433 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6012557.97886 2117161.95783 37.7940299799473 -122.400506717522 (37.7940299799473, -122.400506717522) 4 1 10 28860 6
90481 129774 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 80 Vallejo St 6 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6012849.95348 2119259.82939 37.7998065134132 -122.399643814425 (37.7998065134132, -122.399643814425) 3 1 10 28860 6
90645 97619 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 333 Battery St 4 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
91339 29753 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 532 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     35 3x3   6009968.1915 2119398.824 37.8000270997238 -122.409625640361 (37.8000270997238, -122.409625640361) 3 1 10 308 23
93232 115306 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1199x KEARNY ST 2 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6011157 2118940 37.7988338244478 -122.405479555764 (37.7988338244478, -122.405479555764) 3 1 10 308 23
93331 96324 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1300X Sansome St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 4x4   6011919 2120150.9 37.8022012393453 -122.402927984504 (37.8022012393453, -122.402927984504) 3 1 10 28860 6
94655 29754 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 532 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     45 3x3   6009953.7417 2119408.8277 37.800053757709 -122.409676348881 (37.800053757709, -122.409676348881) 3 1 10 308 23

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