Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 118847 | 118847 | 108695 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 511 Alvarado St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774625 | 6003049.10666 | 2102687.45843 | 37.7537516993963 | -122.432374086122 | (37.7537516993963, -122.432374086122) | |
| 5413 | 5413 | 14844 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 1327 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/1987 12:00:00 AM | 6 | 3x3 | 6002796.5861 | 2111629.8173 | 37.7782909152526 | -122.43388649174999 | (37.7782909152526, -122.43388649175) | ||
| 7889 | 7889 | 29752 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 532 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 6009988.1989 | 2119378.2609 | 37.7999717596155 | -122.40955495470502 | (37.7999717596155, -122.409554954705) | |||
| 15015 | 15015 | 106001 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6015262.44728 | 2104479.57944 | 37.75935745211439 | -122.390262422266 | (37.7593574521144, -122.390262422266) | |||
| 16326 | 16326 | 66490 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 280 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2015 12:00:00 AM | 3 | Permit Number 775748 | 6010181.76408 | 2110999.12752 | 37.776975511839396 | -122.408293821201 | (37.7769755118394, -122.408293821201) | |
| 16571 | 16571 | 97169 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 290 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6009519.6482 | 2110372.42586 | 37.7752176376301 | -122.410540028225 | (37.7752176376301, -122.410540028225) | |||
| 16836 | 16836 | 15111 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6013962.82131 | 2116101.4847 | 37.79119641403479 | -122.395571449475 | (37.7911964140348, -122.395571449475) | |||
| 24184 | 24184 | 208171 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 158 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994395.10908 | 2099344.18308 | 37.744077400365 | -122.46205892188401 | (37.744077400365, -122.462058921884) | |||
| 25678 | 25678 | 129817 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 241 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012643.50693 | 2117148.0023 | 37.793996430738 | -122.40020979915899 | (37.793996430738, -122.400209799159) | |||
| 28769 | 28769 | 129827 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6012617.00039 | 2117213.20404 | 37.7941739812068 | -122.400306096749 | (37.7941739812068, -122.400306096749) | |||
| 31378 | 31378 | 129821 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 504 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012337.50928 | 2117203.47544 | 37.7941316797929 | -122.40127248843201 | (37.7941316797929, -122.401272488432) | |||
| 32287 | 32287 | 227937 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 465 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6002968.42227 | 2098587.5279900003 | 37.7424896769594 | -122.43236030960699 | (37.7424896769594, -122.432360309607) | |||
| 33596 | 33596 | 227938 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 25 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004713.51107 | 2103480.2352 | 37.756022715594604 | -122.426674645426 | (37.7560227155946, -122.426674645426) | |||
| 34082 | 34082 | 129826 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 510 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012620.11049 | 2117309.3448900003 | 37.7944381345611 | -122.400302091187 | (37.7944381345611, -122.400302091187) | |||
| 36450 | 36450 | 39386 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2710 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 9 | Permit Number 40925 | 6000600.16704 | 2117204.05937 | 37.7934714577907 | -122.441884880082 | (37.7934714577907, -122.441884880082) | ||
| 36798 | 36798 | 129763 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1379 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6006382.65003 | 2118656.3506099996 | 37.7977868852004 | -122.421980230217 | (37.7977868852004, -122.421980230217) | |||
| 38264 | 38264 | 200368 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 199 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6014118.97804 | 2116248.97229 | 37.7916100652992 | -122.395041482589 | (37.7916100652992, -122.395041482589) | |||
| 38577 | 38577 | 129810 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 435 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012477.08259 | 2117150.1123 | 37.7939929431787 | -122.40078579605101 | (37.7939929431787, -122.400785796051) | |||
| 39753 | 39753 | 129794 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1180 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6011926.85553 | 2120176.70877 | 37.802272542593 | -122.40290261667101 | (37.802272542593, -122.402902616671) | |||
| 40130 | 40130 | 228846 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004252.08143 | 2104552.56077 | 37.758940969765 | -122.428346847525 | (37.758940969765, -122.428346847525) | |||
| 41186 | 41186 | 228842 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1010 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999127.094409999 | 2106474.67422 | 37.7639272833421 | -122.446209649681 | (37.7639272833421, -122.446209649681) | |||
| 43828 | 43828 | 208173 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 170 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994847.17518 | 2099430.14012 | 37.744339434016794 | -122.460502016448 | (37.7443394340168, -122.460502016448) | |||
| 46833 | 46833 | 227936 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 167 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 6004844.7517 | 2099277.52267 | 37.7444904598682 | -122.42592162061001 | (37.7444904598682, -122.42592162061) | |||
| 47917 | 47917 | 129784 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1600 Montgomery St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6011334.32807 | 2120989.68408 | 37.8044716700829 | -122.405010336152 | (37.8044716700829, -122.405010336152) | |||
| 51118 | 51118 | 62971 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1833 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | 6 | Permit Number 23358 | 6008235.84849 | 2118785.82593 | 37.7982467346621 | -122.415576801855 | (37.7982467346621, -122.415576801855) | |
| 53935 | 53935 | 208172 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 154 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994418.094740001 | 2099364.4172099996 | 37.7441342815725 | -122.46198091018499 | (37.7441342815725, -122.461980910185) | |||
| 55932 | 55932 | 143040 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1760 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010444.0727 | 2120551.0606 | 37.8032175128046 | -122.408060206321 | (37.8032175128046, -122.408060206321) | |||
| 57135 | 57135 | 65057 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/1989 12:00:00 AM | 14 | Permit Number 27011 | 6012481.29964 | 2118678.07069 | 37.7981885871952 | -122.400878606079 | (37.7981885871952, -122.400878606079) | ||
| 58412 | 58412 | 129758 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 311 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006236.20671 | 2111756.75185 | 37.778834036391395 | -122.42199657448201 | (37.7788340363914, -122.421996574482) | |||
| 61384 | 61384 | 63581 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1360 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1987 12:00:00 AM | 13 | Permit Number 24204 | 6006506.63769 | 2118721.20057 | 37.7979719387185 | -122.421555805959 | (37.7979719387185, -122.421555805959) | |
| 62252 | 62252 | 227934 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1731 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005814.854180001 | 2107243.32997 | 37.7664174935056 | -122.423133300469 | (37.7664174935056, -122.423133300469) | |||
| 63604 | 63604 | 142487 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1527 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6010095.4595 | 2119399.2703 | 37.800035455862606 | -122.409185274056 | (37.8000354558626, -122.409185274056) | |||
| 66960 | 66960 | 200333 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 903 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6015264.35575 | 2104459.34943 | 37.7593020107061 | -122.39025440841002 | (37.7593020107061, -122.39025440841) | |||
| 67057 | 67057 | 66847 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 45 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | 2 | Permit Number 30151 | 5998689.6182 | 2110496.1606 | 37.7749442695784 | -122.448012307244 | (37.7749442695784, -122.448012307244) | |
| 69311 | 69311 | 129760 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2222 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006381.91218 | 2118496.72963 | 37.7973485646419 | -122.421971438426 | (37.7973485646419, -122.421971438426) | |||
| 75710 | 75710 | 129769 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 80 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6013010.632 | 2119281.7619 | 37.7998756901686 | -122.39908934370101 | (37.7998756901686, -122.399089343701) | |||
| 75743 | 75743 | 17631 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 11/15/1992 12:00:00 AM | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | ||
| 78762 | 78762 | 85037 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 170 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994836.8 | 2099436.6 | 37.7443565743554 | -122.460538359387 | (37.7443565743554, -122.460538359387) | |||||
| 83335 | 83335 | 31389 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36942 | 6014160.17669171 | 2116306.66761031 | 37.7917707740774 | -122.394902977188 | (37.7917707740774, -122.394902977188) | |||
| 84551 | 84551 | 45668 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 46(REVISED) Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 44364 | 6004865.19751473 | 2101080.41704042 | 37.7494419484142 | -122.425979237767 | (37.7494419484142, -122.425979237767) | ||
| 88337 | 88337 | 96318 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011857.0 | 2120322.0 | 37.802667576079 | -122.403154578184 | (37.802667576079, -122.403154578184) | |||
| 90132 | 90132 | 61067 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 532 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | Permit Number 46064 | 6010044.29985327 | 2119322.50303189 | 37.7998218055895 | -122.40935688621799 | (37.7998218055895, -122.409356886218) | |||
| 90452 | 90452 | 86806 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 700X Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 9 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | |||
| 90896 | 90896 | 115305 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1199x KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x5 | 6011077.0 | 2118941.0 | 37.7988320967672 | -122.405756453764 | (37.7988320967672, -122.405756453764) | ||||
| 90926 | 90926 | 114099 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 201x VIDAL DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5987665.0 | 2090646.0 | 37.719804665893605 | -122.484691919383 | (37.7198046658936, -122.484691919383) | ||||
| 91345 | 91345 | 108649 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
| 94681 | 94681 | 63072 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 709 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1986 12:00:00 AM | Permit Number 23550 | 6007407.20126882 | 2097784.26133742 | 37.740534778558605 | -122.416955389518 | (37.7405347785586, -122.416955389518) | ||
| 98558 | 98558 | 50617 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 222X Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/2004 12:00:00 AM | Permit Number 47216 | 6004288.29588296 | 2104553.28636794 | 37.7589450112214 | -122.42822165267 | (37.7589450112214, -122.42822165267) | ||
| 104025 | 104025 | 17656 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 11/15/1992 12:00:00 AM | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | ||
| 114181 | 114181 | 100694 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 120148 | 120148 | 7766 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 325X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006199.471782 | 2111757.686674 | 37.7788345313197 | -122.42212372172101 | (37.7788345313197, -122.422123721721) | |||
| 120380 | 120380 | 64146 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 465 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24921 | 6002780.16143913 | 2098575.90057442 | 37.7424470739996 | -122.433010428517 | (37.7424470739996, -122.433010428517) | ||
| 129842 | 129842 | 228840 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 104 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004701.59069 | 2103023.11733 | 37.754766903184 | -122.426683319388 | (37.754766903184, -122.426683319388) | |||
| 133858 | 133858 | 38495 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1353 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40489 | 6006548.48859 | 2118678.2473299997 | 37.7978563596483 | -122.421407937635 | (37.7978563596483, -122.421407937635) |
| 134068 | 134068 | 142927 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 501 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6011089.2103 | 2118971.3611 | 37.79891614378229 | -122.405716341604 | (37.7989161437823, -122.405716341604) | |||
| 134069 | 134069 | 124474 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 344 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996301.59979 | 2110522.81259 | 37.7748806555631 | -122.45627485050899 | (37.7748806555631, -122.456274850509) | |||
| 144120 | 144120 | 114104 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 400x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 3x3 | 5988116.0 | 2090625.0 | 37.7197732605649 | -122.48313145165001 | (37.7197732605649, -122.48313145165) | |||
| 145231 | 145231 | 68365 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 945 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32186 | 6010298.82314684 | 2116844.8632648997 | 37.7930330672197 | -122.40830128766501 | (37.7930330672197, -122.408301287665) | ||
| 151478 | 151478 | 228845 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 4526 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6001290.00365 | 2104097.6707200003 | 37.7575238972389 | -122.438558485713 | (37.7575238972389, -122.438558485713) | |||
| 154064 | 154064 | 208170 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1225 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5996717.7598 | 2107182.54151 | 37.7657330159006 | -122.454593911282 | (37.7657330159006, -122.454593911282) | |||
| 155277 | 155277 | 228844 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 709 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007473.725769999 | 2097767.91667 | 37.7404936415809 | -122.416724215363 | (37.7404936415809, -122.416724215363) | |||
| 156540 | 156540 | 129834 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 733 Front St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6012777.11642 | 2118676.9470599997 | 37.7982019978752 | -122.399854906882 | (37.7982019978752, -122.399854906882) | |||
| 157370 | 157370 | 129766 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1375 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6006461.42741 | 2118668.07402 | 37.797823517302206 | -122.42170847129199 | (37.7978235173022, -122.421708471292) | |||
| 158244 | 158244 | 129814 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 433 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012557.97886 | 2117161.9578299997 | 37.7940299799473 | -122.40050671752199 | (37.7940299799473, -122.400506717522) | |||
| 160462 | 160462 | 177154 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 734 Peru Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6005364.09678 | 2092392.61851 | 37.725615388036104 | -122.42363641630301 | (37.7256153880361, -122.423636416303) | |||
| 161074 | 161074 | 129768 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 489 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6011131.656690001 | 2118977.1984099997 | 37.7989345451634 | -122.40556987367201 | (37.7989345451634, -122.405569873672) | |||
| 161111 | 161111 | 129785 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011966.59622 | 2119867.2001900002 | 37.8014249261853 | -122.402743314356 | (37.8014249261853, -122.402743314356) | |||
| 164671 | 164671 | 64662 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2786 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/1989 12:00:00 AM | 14 | 6x4 | Permit Number 26052 | 5999613.31909 | 2118454.39818 | 37.796848274496206 | -122.445389381638 | (37.7968482744962, -122.445389381638) | |
| 166496 | 166496 | 51593 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1960 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53890 | 5998519.8939 | 2110042.61 | 37.773689232881395 | -122.44856674553301 | (37.7736892328814, -122.448566745533) | |
| 166582 | 166582 | 142921 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 546 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6009942.6265 | 2119419.3871 | 37.800082128353 | -122.409715557637 | (37.800082128353, -122.409715557637) | |||
| 168272 | 168272 | 129750 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2320 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000760.50701 | 2119657.6711 | 37.800217563850296 | -122.44150624394301 | (37.8002175638503, -122.441506243943) | |||
| 168339 | 168339 | 49588 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2333 REVISED Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2003 12:00:00 AM | 16 | Permit Number 46464 | 6003709.90767 | 2116419.2146400004 | 37.7914931831193 | -122.431068901134 | (37.7914931831193, -122.431068901134) | ||
| 169203 | 169203 | 129777 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Front St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6012748.89649 | 2119266.86751 | 37.79982020469429 | -122.399994005922 | (37.7998202046943, -122.399994005922) | |||
| 169282 | 169282 | 200361 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 5ft | 6014182.02229 | 2096553.32448 | 37.7375336444497 | -122.39344438196699 | (37.7375336444497, -122.393444381967) | |||
| 169758 | 169758 | 208167 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2590 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991441.567009999 | 2097783.56953 | 37.7396218639513 | -122.47215777968201 | (37.7396218639513, -122.472157779682) | |||
| 173137 | 173137 | 227935 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 705 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6008535.61915 | 2104408.30699 | 37.7587863358342 | -122.413522114462 | (37.7587863358342, -122.413522114462) | |||
| 176440 | 176440 | 62970 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1827 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | 10 | Permit Number 23357 | 6008241.174219999 | 2118766.33453 | 37.7981935154844 | -122.41555699245701 | (37.7981935154844, -122.415556992457) | |
| 179760 | 179760 | 129847 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 103 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6012509.67235 | 2118803.01279 | 37.798533230779 | -122.40078920986099 | (37.798533230779, -122.400789209861) | |||
| 184232 | 184232 | 129802 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6010252.4995 | 2116845.85776 | 37.79303320378 | -122.40846164098801 | (37.79303320378, -122.408461640988) | |||
| 187275 | 187275 | 129839 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 238 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6012727.894069999 | 2118536.52905 | 37.7978136994111 | -122.400015365729 | (37.7978136994111, -122.400015365729) | |||
| 187663 | 187663 | 129748 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2300 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000804.68172 | 2119664.29702 | 37.800238273442396 | -122.441353858292 | (37.8002382734424, -122.441353858292) | |||
| 188297 | 188297 | 129845 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 485 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6011739.20457 | 2118363.85261 | 37.797284398923004 | -122.40342437184201 | (37.797284398923, -122.403424371842) | |||
| 460 | 460 | 142327 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1652 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999940.0 | 2110256.0 | 37.774356244626205 | -122.44366972691601 | (37.7743562446262, -122.443669726916) | |||
| 5782 | 5782 | 29753 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 532 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 6009968.1915 | 2119398.824 | 37.8000270997238 | -122.409625640361 | (37.8000270997238, -122.409625640361) | |||
| 13518 | 13518 | 106002 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015261.96303 | 2104498.62679 | 37.759409725189705 | -122.39026542781299 | (37.7594097251897, -122.390265427813) | |||
| 14513 | 14513 | 15112 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6013977.3910300005 | 2116114.5164400004 | 37.7912330065583 | -122.395521951701 | (37.7912330065583, -122.395521951701) | |||
| 15958 | 15958 | 35692 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 24992 | 24992 | 129842 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Battery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6012477.73931 | 2118700.3434099997 | 37.7982495441479 | -122.400892491621 | (37.7982495441479, -122.400892491621) | |||
| 30051 | 30051 | 129811 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 435 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012498.509190001 | 2117154.1734 | 37.794005289065794 | -122.40071194282801 | (37.7940052890658, -122.400711942828) | |||
| 32083 | 32083 | 129818 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 241 Battery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012648.53437 | 2117119.11483 | 37.79391739292829 | -122.400190373809 | (37.7939173929283, -122.400190373809) | |||
| 32103 | 32103 | 38388 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1150 Phelps St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1998 12:00:00 AM | 5 | Permit Number 40446 | 6014255.1081300005 | 2096652.83017 | 37.737810927032704 | -122.39319864851801 | (37.7378109270327, -122.393198648518) | ||
| 44261 | 44261 | 129795 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1180 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011922.61764 | 2120202.56088 | 37.8023432895615 | -122.40291910123699 | (37.8023432895615, -122.402919101237) | |||
| 45773 | 45773 | 129823 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 504 Battery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012601.68821 | 2117444.3368599997 | 37.7948077631249 | -122.40037532116501 | (37.7948077631249, -122.400375321165) | |||
| 46581 | 46581 | 228841 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 65 Homestead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6000998.7373 | 2101290.13943 | 37.749798521207204 | -122.439364559745 | (37.7497985212072, -122.439364559745) | |||
| 50680 | 50680 | 129764 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1379 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006404.89602 | 2118659.8041 | 37.7977976222176 | -122.42190349824101 | (37.7977976222176, -122.421903498241) | |||
| 52414 | 52414 | 129846 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 485 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6011762.70539 | 2118367.67112 | 37.797296196209295 | -122.40334332133999 | (37.7972961962093, -122.40334332134) | |||
| 55664 | 55664 | 129767 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1375 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6006477.1660400005 | 2118669.59087 | 37.7978285696796 | -122.421654118939 | (37.7978285696796, -122.421654118939) | |||
| 55972 | 55972 | 129835 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 733 Front St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6012779.55401 | 2118654.25305 | 37.7981398214472 | -122.399844877638 | (37.7981398214472, -122.399844877638) | |||
| 66199 | 66199 | 7767 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 325X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/2010 12:00:00 AM | 3X3 | 6006199.471782 | 2111757.686674 | 37.7788345313197 | -122.42212372172101 | (37.7788345313197, -122.422123721721) | |||
| 67539 | 67539 | 129822 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 504 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6012331.01864 | 2117278.3358 | 37.7943368663928 | -122.401300210056 | (37.7943368663928, -122.401300210056) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");