trees
320 rows where qSpecies_id = 145 sorted by PlotSize descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187134 | 177154 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 734 Peru Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6005364.09678 | 2092392.61851 | 37.7256153880361 | -122.423636416303 | (37.7256153880361, -122.423636416303) | 9 | 7 | 6 | 309 | 5 | |||
| 1024 | 200362 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 3 | : | Tree | Private 2 | 7 | Width 5ft | 6014166.7855 | 2096532.27247 | 37.7374749933851 | -122.393495590258 | (37.7374749933851, -122.393495590258) | 10 | 3 | 8 | 58 | 1 | |||
| 10946 | 200359 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1150 Phelps St | 4 | : | Tree | Private 2 | 9 | Width 5ft | 6014213.14362 | 2096595.32013 | 37.7376506849368 | -122.393339717964 | (37.7376506849368, -122.393339717964) | 10 | 3 | 8 | 58 | 1 | |||
| 24469 | 227936 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 167 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 6004844.7517 | 2099277.52267 | 37.7444904598682 | -122.42592162061 | (37.7444904598682, -122.42592162061) | 2 | 7 | 5 | 63 | 22 | |||
| 34905 | 200353 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 17 | : | Tree | Private 2 | 11 | Width 5ft | 6014392.43301 | 2096834.63166 | 37.738317744462 | -122.392736560653 | (37.738317744462, -122.392736560653) | 10 | 3 | 8 | 58 | 1 | |||
| 35332 | 200356 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6014331.31299 | 2096752.73935 | 37.7380894902424 | -122.392942157366 | (37.7380894902424, -122.392942157366) | 10 | 3 | 8 | 58 | 1 | |||
| 45782 | 200361 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 1 | : | Tree | Private 2 | 7 | Width 5ft | 6014182.02229 | 2096553.32448 | 37.7375336444497 | -122.393444381967 | (37.7375336444497, -122.393444381967) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 133294 | 200351 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6014421.21333 | 2096874.8296 | 37.73842971815 | -122.39263986285 | (37.73842971815, -122.39263986285) | 10 | 3 | 8 | 58 | 1 | |||
| 136267 | 200360 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1150 Phelps St | 5 | : | Tree | Private 2 | 6 | Width 5ft | 6014196.6239 | 2096573.24629 | 37.737589156905 | -122.393395290662 | (37.737589156905, -122.393395290662) | 10 | 3 | 8 | 58 | 1 | |||
| 140150 | 129768 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 489 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6011131.65669 | 2118977.19841 | 37.7989345451634 | -122.405569873672 | (37.7989345451634, -122.405569873672) | 3 | 1 | 10 | 308 | 23 | |||
| 150134 | 200363 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 5 | : | Tree | Private 2 | 8 | Width 5ft | 6014137.38405 | 2096492.68968 | 37.7373646735385 | -122.393594476122 | (37.7373646735385, -122.393594476122) | 10 | 3 | 8 | 58 | 1 | |||
| 150606 | 200358 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1150 Phelps St | 3 | : | Tree | Private 2 | 12 | Width 5ft | 6014239.8641 | 2096632.70057 | 37.7377548084229 | -122.393249946754 | (37.7377548084229, -122.393249946754) | 10 | 3 | 8 | 58 | 1 | |||
| 156702 | 200367 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 9 | : | Tree | Private 2 | 17 | Width 5ft | 6014030.85339 | 2096351.68064 | 37.7369715717905 | -122.393952936896 | (37.7369715717905, -122.393952936896) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 163498 | 200355 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 19 | : | Tree | Private 2 | 11 | Width 5ft | 6014345.08354 | 2096773.39107 | 37.7381469605042 | -122.392895989784 | (37.7381469605042, -122.392895989784) | 10 | 3 | 8 | 58 | 1 | |||
| 170707 | 200364 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 6 | : | Tree | Private 2 | 13 | Width 5ft | 6014077.79977 | 2096412.7772 | 37.7371419393345 | -122.393794896313 | (37.7371419393345, -122.393794896313) | 10 | 3 | 8 | 58 | 1 | |||
| 180511 | 200352 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 16 | : | Tree | Private 2 | 14 | Width 5ft | 6014405.80816 | 2096853.92235 | 37.7383714555731 | -122.392691664697 | (37.7383714555731, -122.392691664697) | 10 | 3 | 8 | 58 | 1 | |||
| 193306 | 200357 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6014316.3111 | 2096732.35884 | 37.7380326962502 | -122.392992601233 | (37.7380326962502, -122.392992601233) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 32545 | 200348 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 10 | : | Tree | Private 2 | 9 | Width 4ft | 6014546.28219 | 2097041.88556 | 37.738895364638 | -122.392219112326 | (37.738895364638, -122.392219112326) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 39193 | 200350 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 12 | : | Tree | Private 2 | 7 | Width 4ft | 6014508.81125 | 2096991.75117 | 37.7387556252824 | -122.392345164903 | (37.7387556252824, -122.392345164903) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 40885 | 227937 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 465 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6002968.42227 | 2098587.52799 | 37.7424896769594 | -122.432360309607 | (37.7424896769594, -122.432360309607) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 58485 | 129758 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 311 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006236.20671 | 2111756.75185 | 37.7788340363914 | -122.421996574482 | (37.7788340363914, -122.421996574482) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 123480 | 129760 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2222 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006381.91218 | 2118496.72963 | 37.7973485646419 | -122.421971438426 | (37.7973485646419, -122.421971438426) | 13 | 9 | 10 | 28858 | 32 | |||
| 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 | |||
| 127399 | 200369 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 650 Townsend St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011472.2786 | 2108553.20224 | 37.7703317423487 | -122.403657370911 | (37.7703317423487, -122.403657370911) | 14 | 2 | 9 | 28853 | 34 | |||
| 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 | |||
| 132689 | 208172 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 154 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994418.09474 | 2099364.41721 | 37.7441342815725 | -122.461980910185 | (37.7441342815725, -122.461980910185) | 1 | 8 | 4 | 59 | 40 | |||
| 136630 | 129791 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011942.54079 | 2120045.79904 | 37.8019139721219 | -122.402839125451 | (37.8019139721219, -122.402839125451) | 3 | 1 | 10 | 28860 | 6 | |||
| 139160 | 129789 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011950.17532 | 2119985.5388 | 37.8017489384237 | -122.402808465741 | (37.8017489384237, -122.402808465741) | 3 | 1 | 10 | 28860 | 6 | |||
| 145404 | 129841 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 238 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6012688.55113 | 2118531.3338 | 37.7977972409088 | -122.400151139076 | (37.7977972409088, -122.400151139076) | 3 | 1 | 10 | 28860 | 6 | |||
| 150172 | 129834 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 733 Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6012777.11642 | 2118676.94706 | 37.7982019978752 | -122.399854906882 | (37.7982019978752, -122.399854906882) | 3 | 1 | 10 | 28860 | 6 | |||
| 154946 | 208171 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 158 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5994395.10908 | 2099344.18308 | 37.744077400365 | -122.462058921884 | (37.744077400365, -122.462058921884) | 1 | 8 | 4 | 59 | 40 | |||
| 155747 | 129836 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 733 Front St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012782.07244 | 2118635.55361 | 37.7980886176578 | -122.399834849323 | (37.7980886176578, -122.399834849323) | 3 | 1 | 10 | 28860 | 6 | |||
| 161885 | 129848 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 103 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012543.75409 | 2118806.63113 | 37.7985450667665 | -122.400671529986 | (37.7985450667665, -122.400671529986) | 3 | 1 | 10 | 28860 | 6 | |||
| 167306 | 200346 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 4 | : | Tree | Private 2 | 9 | Width 4ft | 6014640.20968 | 2097167.32462 | 37.7392450093596 | -122.391903121137 | (37.7392450093596, -122.391903121137) | 10 | 3 | 8 | 58 | 1 | |||
| 178875 | 129839 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 238 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6012727.89407 | 2118536.52905 | 37.7978136994111 | -122.400015365729 | (37.7978136994111, -122.400015365729) | 3 | 1 | 10 | 28860 | 6 | |||
| 179889 | 200347 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 9 | : | Tree | Private 2 | 11 | Width 4ft | 6014556.03183 | 2097054.78425 | 37.7389313231291 | -122.392186304173 | (37.7389313231291, -122.392186304173) | 10 | 3 | 8 | 58 | 1 | |||
| 180495 | 200337 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 9 | : | Tree | Private 2 | 10 | Width 4ft | 6015484.25752 | 2098301.13552 | 37.7424050435698 | -122.389063899405 | (37.7424050435698, -122.389063899405) | 10 | 3 | 8 | 58 | 1 | |||
| 182985 | 200349 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 11 | : | Tree | Private 2 | 8 | Width 4ft | 6014526.62987 | 2097016.75387 | 37.7388252669773 | -122.392285304228 | (37.7388252669773, -122.392285304228) | 10 | 3 | 8 | 58 | 1 | |||
| 186221 | 129792 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6011937.51445 | 2120075.46294 | 37.8019951413282 | -122.402858606545 | (37.8019951413282, -122.402858606545) | 3 | 1 | 10 | 28860 | 6 | |||
| 6777 | 228843 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 709 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007452.72902 | 2097768.34677 | 37.7404936415683 | -122.416796844595 | (37.7404936415683, -122.416796844595) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 29799 | 228851 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 210 Cumberland St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004146.65332 | 2104546.18314 | 37.7589174920696 | -122.42871101271 | (37.7589174920696, -122.42871101271) | 2 | 4 | 5 | 28862 | 3 | |||
| 31986 | 208170 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1225 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5996717.7598 | 2107182.54151 | 37.7657330159006 | -122.454593911282 | (37.7657330159006, -122.454593911282) | 15 | 5 | 11 | 29492 | 12 | |||
| 37605 | 228842 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1010 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999127.09441 | 2106474.67422 | 37.7639272833421 | -122.446209649681 | (37.7639272833421, -122.446209649681) | 15 | 5 | 5 | 29492 | 9 | |||
| 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 | |||
| 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 | |||
| 49670 | 228845 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 4526 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6001290.00365 | 2104097.67072 | 37.7575238972389 | -122.438558485713 | (37.7575238972389, -122.438558485713) | 2 | 4 | 5 | 28862 | 3 | |||
| 53191 | 228841 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 65 Homestead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000998.7373 | 2101290.13943 | 37.7497985212072 | -122.439364559745 | (37.7497985212072, -122.439364559745) | 2 | 4 | 5 | 28862 | 22 | |||
| 55858 | 200333 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 903 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015264.35575 | 2104459.34943 | 37.7593020107061 | -122.39025440841 | (37.7593020107061, -122.39025440841) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 57571 | 124474 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 344 Willard St North | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996301.59979 | 2110522.81259 | 37.7748806555631 | -122.456274850509 | (37.7748806555631, -122.456274850509) | 11 | 6 | 2 | 54 | 16 | |||
| 59419 | 228844 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 709 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007473.72577 | 2097767.91667 | 37.7404936415809 | -122.416724215363 | (37.7404936415809, -122.416724215363) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 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 | |||
| 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 |
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) );