320 rows where qSpecies_id = 145 sorted by Police 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)
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                    
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
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
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
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
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
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
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
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
96501 129759 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1827 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008241.72856 2118745.4751 37.7981362718366 -122.415553596641 (37.7981362718366, -122.415553596641) 5 1 10 28858 21
108714 129843 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 750 Battery St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6012472.98586 2118729.74451 37.7983300073669 -122.400911006864 (37.7983300073669, -122.400911006864) 3 1 10 28860 6
108765 129801 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Sansome St 9 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6011895.86595 2120414.05559 37.8029225087266 -122.403026560337 (37.8029225087266, -122.403026560337) 3 1 10 28860 6
109468 129802 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 901 Sacramento St 1 Sidewalk: Curb side : Pot Tree Private 2     10 Width 3ft   6010252.4995 2116845.85776 37.79303320378 -122.408461640988 (37.79303320378, -122.408461640988) 3 1 10 28857 4
111169 129785 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1160 Sansome St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6011966.59622 2119867.20019 37.8014249261853 -122.402743314356 (37.8014249261853, -122.402743314356) 3 1 10 28860 6
111817 129819 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 241 Battery St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6012648.9601 2117092.83821 37.7938452673045 -122.400187054399 (37.7938452673045, -122.400187054399) 4 1 10 28860 6
112521 129808 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 901 Sacramento St 7 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6010404.49438 2116867.87948 37.7931021808659 -122.407937281392 (37.7931021808659, -122.407937281392) 3 1 10 28857 4
114242 129797 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Sansome St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6011917.15823 2120261.12287 37.8025037816892 -122.402942114884 (37.8025037816892, -122.402942114884) 3 1 10 28860 6
114612 129813 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 435 Sacramento St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2018 12:00:00 AM 3 Width 3ft   6012536.38879 2117159.9438 37.7940232458398 -122.400581280298 (37.7940232458398, -122.400581280298) 4 1 10 28860 6
114811 129835 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 733 Front St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6012779.55401 2118654.25305 37.7981398214472 -122.399844877638 (37.7981398214472, -122.399844877638) 3 1 10 28860 6
115183 129780 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 900 Front St 8 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6012726.99956 2119408.50299 37.8002078808339 -122.400079730213 (37.8002078808339, -122.400079730213) 3 1 10 28860 6
115807 129822 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 504 Sansome St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6012331.01864 2117278.3358 37.7943368663928 -122.401300210056 (37.7943368663928, -122.401300210056) 3 1 10 28860 4
116930 129788 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1160 Sansome St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6011956.16596 2119957.68161 37.8016727838339 -122.402785774963 (37.8016727838339, -122.402785774963) 3 1 10 28860 6
119941 129842 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 750 Battery St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6012477.73931 2118700.34341 37.7982495441479 -122.400892491621 (37.7982495441479, -122.400892491621) 3 1 10 28860 6
123142 129844 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 750 Battery St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6012469.34241 2118758.90101 37.7984098608851 -122.400925663989 (37.7984098608851, -122.400925663989) 3 1 10 28860 6
124727 129838 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 733 Front St 5 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6012789.03405 2118594.11911 37.7979752365279 -122.39980784898 (37.7979752365279, -122.39980784898) 3 1 10 28860 6
125463 129830 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 354 Sacramento St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6012498.4118 2117199.54922 37.7941298748476 -122.400715469043 (37.7941298748476, -122.400715469043) 3 1 10 28860 4
126383 108650 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 1200x SANSOME ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011928 2119969 37.8017022887014 -122.402884039163 (37.8017022887014, -122.402884039163) 3 1 10 28860 23
126645 62971 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1833 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/21/1986 12:00:00 AM 6   Permit Number 23358 6008235.84849 2118785.82593 37.7982467346621 -122.415576801855 (37.7982467346621, -122.415576801855) 5 1 10 28858 21
129427 142487 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1527 STOCKTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6010095.4595 2119399.2703 37.8000354558626 -122.409185274056 (37.8000354558626, -122.409185274056) 3 1 10 308 23
129470 129778 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 900 Front St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6012744.14452 2119292.42038 37.7998901017986 -122.400012245068 (37.7998901017986, -122.400012245068) 3 1 10 28860 6
131028 96322 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1300X Sansome St 5 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
132115 129825 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 333 Battery St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6012609.83657 2117389.63944 37.7946580314036 -122.400343282842 (37.7946580314036, -122.400343282842) 3 1 10 28860 4
132394 129794 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Sansome St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6011926.85553 2120176.70877 37.802272542593 -122.402902616671 (37.802272542593, -122.402902616671) 3 1 10 28860 6
135729 65057 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 750 Battery St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/23/1989 12:00:00 AM 14   Permit Number 27011 6012481.29964 2118678.07069 37.7981885871952 -122.400878606079 (37.7981885871952, -122.400878606079) 3 1 10 28860 6

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