320 rows where qSpecies_id = 145

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)
63614 17661 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1000X Phelps St 6 Sidewalk: Curb side : Cutout Tree PUC 8     12 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407) 10 3 8 58 1
65172 228847 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 210 Cumberland St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6004213.13115 2104548.41319 37.758927377407 -122.428481260227 (37.758927377407, -122.428481260227) 2 4 5 28862 3
65204 100696 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 3 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 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
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
66822 15112 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 201 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6013977.39103 2116114.51644 37.7912330065583 -122.395521951701 (37.7912330065583, -122.395521951701) 12 2 9 28855 6
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
70762 100699 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 6 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
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
71834 17642 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 600X Phelps St 3 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     6 2x2   6015304.738625 2098066.4602575 37.7417507208067 -122.38966824015 (37.7417507208067, -122.38966824015) 10 3 8 58 1
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
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
73225 100695 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 2 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
73344 208167 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 2590 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5991441.56701 2097783.56953 37.7396218639513 -122.472157779682 (37.7396218639513, -122.472157779682) 1 8 4 29491 40
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
74365 17636 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 420X Phelps St 6 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.388649846738 (37.7428823403387, -122.388649846738) 10 3 8 58 1
74537 200366 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Phelps St 8 : Tree Private 2     12 Width 5ft   6014047.10627 2096372.45752 37.7370295240776 -122.393898196954 (37.7370295240776, -122.393898196954) 10 3 8 58 1
75159 86806 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 700X Phelps St 1 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     9 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992) 10 3 8 58 1
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
76029 114099 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 201x VIDAL DR 1 Sidewalk: Curb side : Cutout Tree Private 2     14     5987665 2090646 37.7198046658936 -122.484691919383 (37.7198046658936, -122.484691919383) 1 8 4 64 14
76043 49214 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 500 Howard St 19 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
76067 100146 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 222X Cumberland St 5 Sidewalk: Curb side : Cutout Tree Private 2           6004147.2 2104574.7 37.7589958235368 -122.428711154895 (37.7589958235368, -122.428711154895) 2 4 5 28862 3
76139 200345 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 900 Phelps St 3 : Tree Private 2     6 Width 4ft   6014658.54117 2097192.95407 37.7393164002222 -122.391841530176 (37.7393164002222, -122.391841530176) 10 3 8 58 1
76827 52992 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1800 Oakdale Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 48973 6013995.42685531 2096291.44248921 37.7368042013217 -122.394071207374 (37.7368042013217, -122.394071207374) 10 3 8 58 1
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
77597 200340 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 750 Phelps St 23 : Tree Private 2     8 Width 2ft   6015300.13853 2098052.9717 37.7417134289277 -122.389683204014 (37.7417134289277, -122.389683204014) 10 3 8 58 1
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
78700 86807 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 700X Phelps St 2 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     6 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992) 10 3 8 58 1
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
78987 228846 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 210 Cumberland St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6004252.08143 2104552.56077 37.758940969765 -122.428346847525 (37.758940969765, -122.428346847525) 2 4 5 28862 3
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
84528 17645 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 600X Phelps St 6 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     10 2x2   6015304.738625 2098066.4602575 37.7417507208067 -122.38966824015 (37.7417507208067, -122.38966824015) 10 3 8 58 1
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
88892 200368 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 201 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6014118.97804 2116248.97229 37.7916100652992 -122.395041482589 (37.7916100652992, -122.395041482589) 12 2 9 28855 6
89260 49223 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 500 Howard St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
89345 17639 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 420X Phelps St 9 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     6 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.388649846738 (37.7428823403387, -122.388649846738) 10 3 8 58 1
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
95161 63072 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 709 Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/21/1986 12:00:00 AM     Permit Number 23550 6007407.20126882 2097784.26133742 37.7405347785586 -122.416955389518 (37.7405347785586, -122.416955389518) 2 7 7 28859 2
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
96572 49230 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 500 Howard St 11 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
98870 100701 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 8 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
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
100518 100698 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 5 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
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
102617 50617 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 222X Cumberland St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/04/2004 12:00:00 AM     Permit Number 47216 6004288.29588296 2104553.28636794 37.7589450112214 -122.42822165267 (37.7589450112214, -122.42822165267) 2 4 5 28862 3
103802 32407 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 201 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/03/1996 12:00:00 AM     Permit Number 36942 6014160.17669171 2116306.66761031 37.7917707740774 -122.394902977188 (37.7917707740774, -122.394902977188) 12 2 9 28855 6
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
107333 200344 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 750 Phelps St 40 : Tree Private 2     4 Width 4ft   6015132.05324 2097828.30985 37.7410872318817 -122.390248699517 (37.7410872318817, -122.390248699517) 10 3 8 58 1
107948 200343 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 750 Phelps St 39 : Tree Private 2     8 Width 4ft   6015141.18947 2097840.20057 37.7411203881093 -122.390217940008 (37.7411203881093, -122.390217940008) 10 3 8 58 1
108380 17634 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 420X Phelps St 4 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     6 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.388649846738 (37.7428823403387, -122.388649846738) 10 3 8 58 1
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
109808 15116 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 201 Mission St 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6014033.61686 2116167.83271 37.7913825278275 -122.39533114703 (37.7913825278275, -122.39533114703) 12 2 9 28855 6
110687 227935 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 705 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6008535.61915 2104408.30699 37.7587863358342 -122.413522114462 (37.7587863358342, -122.413522114462) 2 4 7 28859 19
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
112046 227938 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 25 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004713.51107 2103480.2352 37.7560227155946 -122.426674645426 (37.7560227155946, -122.426674645426) 2 4 5 28862 22
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
113405 38388 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1150 Phelps St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/17/1998 12:00:00 AM 5   Permit Number 40446 6014255.10813 2096652.83017 37.7378109270327 -122.393198648518 (37.7378109270327, -122.393198648518) 10 3 8 58 1
114103 200341 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 750 Phelps St 24 : Tree Private 2     8 Width 2ft   6015282.07626 2098027.62068 37.7416428186622 -122.389743887597 (37.7416428186622, -122.389743887597) 10 3 8 58 1
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
114333 200365 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 1300 Phelps St 7 : Tree Private 2     6 Width 5ft   6014060.81183 2096393.54047 37.7370881751809 -122.393852285648 (37.7370881751809, -122.393852285648) 10 3 8 58 1
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
114788 200339 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 750 Phelps St 22 : Tree Private 2     5 Width 2ft   6015308.33502 2098065.16508 37.7417473639376 -122.389655714464 (37.7417473639376, -122.389655714464) 10 3 8 58 1
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
116439 17643 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 600X Phelps St 4 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     8 2x2   6015304.738625 2098066.4602575 37.7417507208067 -122.38966824015 (37.7417507208067, -122.38966824015) 10 3 8 58 1
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
117859 200354 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 900 Phelps St 18 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   6014359.7983 2096791.80766 37.7381983459865 -122.392846401168 (37.7381983459865, -122.392846401168) 10 3 8 58 1
119788 17656 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1000X Phelps St 1 Sidewalk: Curb side : Cutout Tree PUC 8   11/15/1992 12:00:00 AM 6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407) 10 3 8 58 1
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
120354 228840 DPW Maintained 1 Liriodendron tulipifera :: Tulip Tree 145 104 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6004701.59069 2103023.11733 37.754766903184 -122.426683319388 (37.754766903184, -122.426683319388) 2 4 5 28862 22
121482 31388 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 201 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/03/1996 12:00:00 AM     Permit Number 36942 6014160.17669171 2116306.66761031 37.7917707740774 -122.394902977188 (37.7917707740774, -122.394902977188) 12 2 9 28855 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

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