trees
320 rows where qSpecies_id = 145
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );