Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▼ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 154 | 154 | 830 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1384 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:15:00 PM | 3 | 5.5x6.5 | 5981549.5887 | 2105676.5499 | 37.7607163481902 | -122.506944712409 | (37.7607163481902, -122.506944712409) | ||
| 163 | 163 | 29943 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 242 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:23:00 PM | 3 | 3x3 | 5994593.32204167 | 2088106.90572275 | 37.7132339790874 | -122.460559423837 | (37.7132339790874, -122.460559423837) | ||
| 628 | 628 | 251337 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
| 629 | 629 | 251338 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2012 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
| 634 | 634 | 251340 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
| 2079 | 2079 | 181058 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5258 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 5999890.56935 | 2088656.9040700002 | 37.7150474825255 | -122.442289836724 | (37.7150474825255, -122.442289836724) | |||
| 2127 | 2127 | 252902 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2375 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 3x3 | 5992177.0 | 2094185.0 | 37.7297836282973 | -122.469353126495 | (37.7297836282973, -122.469353126495) | |||
| 2218 | 2218 | 114579 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3 | 3x3 | 6002950.36974 | 2121305.2817599997 | 37.8048659859314 | -122.43404631360701 | (37.8048659859314, -122.434046313607) | ||
| 2333 | 2333 | 253025 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1754 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2017 12:00:00 AM | 3 | 5993444.58369 | 2103545.63859 | 37.7555587516047 | -122.465650780273 | (37.7555587516047, -122.465650780273) | |||
| 2511 | 2511 | 246852 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 300 Broderick St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6001238.428669999 | 2109976.67902 | 37.7736632691848 | -122.43915820668998 | (37.7736632691848, -122.43915820669) | |||
| 2885 | 2885 | 205488 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1430 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5990862.44739 | 2105654.74875 | 37.761200533507 | -122.474734450646 | (37.761200533507, -122.474734450646) | |||
| 2988 | 2988 | 118173 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3221 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/13/2008 12:00:00 AM | 2 | Width 3ft | 5985542.20124 | 2111089.15517 | 37.7758121588594 | -122.49353507754299 | (37.7758121588594, -122.493535077543) | ||
| 3661 | 3661 | 253519 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 701 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6015696.1864 | 2103920.99342 | 37.7578477430893 | -122.38872333331899 | (37.7578477430893, -122.388723333319) | ||||
| 3809 | 3809 | 95203 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 314 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | Permit Number 769992 | 5998598.6333800005 | 2115400.1597599997 | 37.7884041728517 | -122.44868032474 | (37.7884041728517, -122.44868032474) | ||
| 4081 | 4081 | 102392 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 30X Harriet St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6010436.41014 | 2111752.09711 | 37.7790572463352 | -122.40746601596202 | (37.7790572463352, -122.407466015962) | |||
| 4320 | 4320 | 178028 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 398x Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 09:59:00 AM | 3 | Width 3ft | 6004185.0 | 2091264.0 | 37.7224498233553 | -122.427632084441 | (37.7224498233553, -122.427632084441) | ||
| 4352 | 4352 | 178029 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 398x Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 10:03:00 AM | 3 | Width 3ft | 6003930.0 | 2091029.0 | 37.7217901378795 | -122.428496818895 | (37.7217901378795, -122.428496818895) | ||
| 4422 | 4422 | 253158 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 07:47:00 AM | 3 | 3x3 | 6004446.0 | 2092174.0 | 37.7249632430066 | -122.426794641082 | (37.7249632430066, -122.426794641082) | ||
| 4434 | 4434 | 253623 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1331 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778744 | 5983976.422619999 | 2106100.27997 | 37.7620224120695 | -122.498582815109 | (37.7620224120695, -122.498582815109) | |
| 4745 | 4745 | 253432 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501X Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2017 04:09:00 PM | 3 | 3x3 | 6002703.0 | 2090930.0 | 37.721448793681 | -122.43273116699801 | (37.721448793681, -122.432731166998) | ||
| 4758 | 4758 | 161382 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 523 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2017 03:54:00 PM | 3 | Width 0ft | 6002614.99011 | 2090841.7835900001 | 37.721201579268495 | -122.43302909312901 | (37.7212015792685, -122.433029093129) | ||
| 4788 | 4788 | 253430 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501X Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2017 04:04:00 PM | 3 | 3x3 | 6002703.0 | 2090930.0 | 37.721448793681 | -122.43273116699801 | (37.721448793681, -122.432731166998) | ||
| 4805 | 4805 | 253431 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501X Madrid St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2017 04:07:00 PM | 3 | 3x3 | 6002703.0 | 2090930.0 | 37.721448793681 | -122.43273116699801 | (37.721448793681, -122.432731166998) | ||
| 4984 | 4984 | 44099 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1880 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774618 | 6003969.398019999 | 2119063.44467 | 37.798768262294395 | -122.43035980995701 | (37.7987682622944, -122.430359809957) | |
| 5559 | 5559 | 98004 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1908 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/2015 12:00:00 AM | 14 | 5x5 | Permit Number 775450 | 6003753.55269 | 2119031.9849799997 | 37.79866965343071 | -122.43110445762301 | (37.7986696534307, -122.431104457623) | |
| 5769 | 5769 | 39272 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2740 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 3 | Permit Number 774808 | 5999918.5789 | 2117802.13868 | 37.7950747637355 | -122.44428621834999 | (37.7950747637355, -122.44428621835) | ||
| 5807 | 5807 | 47379 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4453 Manzanita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45296 | ||||||||
| 5982 | 5982 | 39271 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2740 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2015 12:00:00 AM | 3 | Permit Number 774808 | 5999943.4858099995 | 2117805.21945 | 37.7950846436855 | -122.444200258451 | (37.7950846436855, -122.444200258451) | ||
| 6209 | 6209 | 91354 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2131 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 52063 | 6007623.63084 | 2119707.2305900003 | 37.8007422490107 | -122.417760608464 | (37.8007422490107, -122.417760608464) | |
| 6520 | 6520 | 121576 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3553-3555 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5997856.717119999 | 2115116.32362 | 37.787582382260396 | -122.451226746117 | (37.7875823822604, -122.451226746117) | |||
| 6649 | 6649 | 114581 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3 | 3x3 | 6002967.5258 | 2121305.9196 | 37.8048687108976 | -122.433986988903 | (37.8048687108976, -122.433986988903) | ||
| 6718 | 6718 | 97922 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2939 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000509.433540001 | 2118403.315 | 37.7967591273891 | -122.442284956098 | (37.7967591273891, -122.442284956098) | |||
| 6827 | 6827 | 100292 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3701 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003061.81659 | 2121064.97367 | 37.804212487284005 | -122.43364345509701 | (37.804212487284, -122.433643455097) | |||
| 7392 | 7392 | 61776 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2939 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1993 12:00:00 AM | 6 | 3x3 | 6000507.69204 | 2118417.15605 | 37.7967970320012 | -122.44229197620001 | (37.7967970320012, -122.4422919762) | ||
| 8183 | 8183 | 112515 | Section 143 8 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2646 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6000218.93903 | 2118886.7143900003 | 37.7980698532985 | -122.443324869154 | (37.7980698532985, -122.443324869154) | |||
| 8240 | 8240 | 111918 | Section 143 8 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 41 Toledo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773012 | 6001705.38657 | 2120044.83908 | 37.801334410325104 | -122.438264349848 | (37.8013344103251, -122.438264349848) | |
| 8700 | 8700 | 94740 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3208 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53872 | 6001386.25296 | 2119488.63139 | 37.799789054867794 | -122.439328800002 | (37.7997890548678, -122.439328800002) | |
| 8887 | 8887 | 97923 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2939 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000511.871719999 | 2118390.4696 | 37.7967239962744 | -122.442275596851 | (37.7967239962744, -122.442275596851) | |||
| 9112 | 9112 | 122861 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:43:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9186 | 9186 | 10962 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1431 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 3 | 3X4 | 6016563.2925523 | 2096760.0557493 | 37.7382333059102 | -122.385225528118 | (37.7382333059102, -122.385225528118) | ||
| 9209 | 9209 | 122858 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:48:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9268 | 9268 | 122855 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:30:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9272 | 9272 | 122860 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:54:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9280 | 9280 | 122859 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:46:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9291 | 9291 | 122856 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:13:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9327 | 9327 | 122854 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:40:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9354 | 9354 | 122862 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:57:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9396 | 9396 | 27585 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2295X Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2000 12:00:00 AM | 6 | 3X3 | 6009694.1199724 | 2103987.6509207003 | 37.7576962911825 | -122.40948577896401 | (37.7576962911825, -122.409485778964) | ||
| 9406 | 9406 | 122857 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:17:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 9415 | 9415 | 15943 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5810X MISSION ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 5997175.0 | 2086632.0 | 37.7093324147693 | -122.451529986796 | (37.7093324147693, -122.451529986796) | |||
| 9493 | 9493 | 29077 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2275 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 5 | 3x3 | 6009685.8295 | 2104144.07057 | 37.7581253197533 | -122.40952549043001 | (37.7581253197533, -122.40952549043) | ||
| 9629 | 9629 | 173614 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2955 20th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776469 | 5990236.78382 | 2095590.4495400002 | 37.7335303227244 | -122.476163213901 | (37.7335303227244, -122.476163213901) | |
| 9631 | 9631 | 173613 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2955 20th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776469 | 5990236.78382 | 2095590.4495400002 | 37.7335303227244 | -122.476163213901 | (37.7335303227244, -122.476163213901) | |
| 9705 | 9705 | 110500 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900X JESSIE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6007667.0 | 2110717.0 | 37.7760597176113 | -122.416973193872 | (37.7760597176113, -122.416973193872) | |||
| 9707 | 9707 | 110499 | Section 143 8 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900X JESSIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6007667.0 | 2110717.0 | 37.7760597176113 | -122.416973193872 | (37.7760597176113, -122.416973193872) | |||
| 9708 | 9708 | 110501 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900X JESSIE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6007667.0 | 2110717.0 | 37.7760597176113 | -122.416973193872 | (37.7760597176113, -122.416973193872) | |||
| 9732 | 9732 | 106018 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5285 DIAMOND HEIGHTS BLVD | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/2016 07:34:00 AM | 3 | 3x3 | 6001339.5 | 2099171.1 | 37.7439995285584 | -122.438034420154 | (37.7439995285584, -122.438034420154) | ||
| 9823 | 9823 | 63407 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2125 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770314 | 6000344.0086 | 2116075.3402400003 | 37.790357690994504 | -122.442690122255 | (37.7903576909945, -122.442690122255) | |
| 10028 | 10028 | 161764 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 142 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779227 | 6000990.7389 | 2087787.91218 | 37.7127240669257 | -122.43842496696001 | (37.7127240669257, -122.43842496696) | |
| 10621 | 10621 | 52188 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 76 Camona Av | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2005 12:00:00 AM | Permit Number 48379 | ||||||||
| 10929 | 10929 | 28307 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1818 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2003 12:00:00 AM | 3 | 6000526.74804 | 2093584.98162 | 37.7286151010044 | -122.440444169789 | (37.7286151010044, -122.440444169789) | |||
| 11064 | 11064 | 25312 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 163 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 3 | 3X3 | 6000515.96101 | 2091667.5202400002 | 37.7233495775944 | -122.440344004183 | (37.7233495775944, -122.440344004183) | ||
| 11259 | 11259 | 25305 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 300 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/1996 12:00:00 AM | 12 | 3X3 | 5999583.38871 | 2091602.23425 | 37.7231171747905 | -122.443563033915 | (37.7231171747905, -122.443563033915) | ||
| 11646 | 11646 | 27701 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1136 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/26/2000 12:00:00 AM | 6 | 6008329.0437900005 | 2093834.9235 | 37.729742566663106 | -122.413488762206 | (37.7297425666631, -122.413488762206) | |||
| 11707 | 11707 | 28306 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1818 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2003 12:00:00 AM | 3 | 6000533.35164 | 2093598.6883900003 | 37.7286531126447 | -122.440422323457 | (37.7286531126447, -122.440422323457) | |||
| 11724 | 11724 | 25307 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 355 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/1996 12:00:00 AM | 6 | 3X3 | 5999438.14042 | 2091535.09661 | 37.7229245454182 | -122.444060305044 | (37.7229245454182, -122.444060305044) | ||
| 12132 | 12132 | 99909 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 210 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774553 | 6009399.78383 | 2095020.3189400001 | 37.7330574731105 | -122.40987072487499 | (37.7330574731105, -122.409870724875) | |
| 12406 | 12406 | 27090 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 725 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X3 | 6006149.91754 | 2093595.5123 | 37.7289625981285 | -122.42100526258801 | (37.7289625981285, -122.421005262588) | |||
| 12419 | 12419 | 981 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1604 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2003 12:00:00 AM | 6 | 3X3 | 6001745.7594099995 | 2092854.52102 | 37.7266787581039 | -122.436177732017 | (37.7266787581039, -122.436177732017) | ||
| 12474 | 12474 | 28305 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1818 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2003 12:00:00 AM | 3 | 6000543.0489 | 2093613.5897099997 | 37.7286945803894 | -122.440389867794 | (37.7286945803894, -122.440389867794) | |||
| 12988 | 12988 | 904 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1179 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2016 12:00:00 AM | 3 | 2X2 | 6003419.3756099995 | 2094263.29224 | 37.7306418725253 | -122.430492572378 | (37.7306418725253, -122.430492572378) | ||
| 13082 | 13082 | 15846 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5256 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | 6 | 3x3 | Permit Number 775938 | 5999899.043409999 | 2088666.4410599999 | 37.7150741519211 | -122.442261231071 | (37.7150741519211, -122.442261231071) | |
| 13358 | 13358 | 79034 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Moss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2002 12:00:00 AM | 1 | 2.5x4 | 6010138.62156 | 2111398.24518 | 37.7780689795412 | -122.40847122506399 | (37.7780689795412, -122.408471225064) | ||
| 13359 | 13359 | 99591 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1855X Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769738 | 6014314.47679 | 2099474.93569 | 37.745563139741996 | -122.39319079741301 | (37.745563139742, -122.393190797413) | |
| 13583 | 13583 | 100891 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013606.47382 | 2111993.91964 | 37.7798981618967 | -122.396516359044 | (37.7798981618967, -122.396516359044) | |||
| 13779 | 13779 | 101367 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 551 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2012 12:00:00 AM | 1 | 3x5 | Permit Number 769423 | 6009889.66847 | 2111940.62383 | 37.779544278688604 | -122.409370733267 | (37.7795442786886, -122.409370733267) | |
| 13984 | 13984 | 21894 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2068 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2003 12:00:00 AM | 3 | 2X3 | 6015677.89854 | 2105976.47682 | 37.7634906462863 | -122.388930084758 | (37.7634906462863, -122.388930084758) | ||
| 14003 | 14003 | 100882 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013366.225459999 | 2111763.75465 | 37.7792528084154 | -122.397331345366 | (37.7792528084154, -122.397331345366) | |||
| 14019 | 14019 | 95844 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 152 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767916 | 6010308.44062 | 2112179.38157 | 37.7802233055096 | -122.40793885609502 | (37.7802233055096, -122.407938856095) | |
| 14258 | 14258 | 100759 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 362 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6014440.04423 | 2112282.11717 | 37.780735840838396 | -122.39365282322201 | (37.7807358408384, -122.393652823222) | |||
| 14268 | 14268 | 12235 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1574 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/1997 12:00:00 AM | 6 | 3X3 | 6015715.635319999 | 2096065.54177 | 37.736279382483204 | -122.38810787958201 | (37.7362793824832, -122.388107879582) | ||
| 14420 | 14420 | 27150 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1735 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011122.20395 | 2095139.1072200001 | 37.73348002049129 | -122.403924187157 | (37.7334800204913, -122.403924187157) | |||
| 14587 | 14587 | 100888 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013550.27415 | 2111938.66795 | 37.7797433256341 | -122.396706905611 | (37.7797433256341, -122.396706905611) | |||
| 14663 | 14663 | 28516 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 117 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | 6010207.243969999 | 2112381.64795 | 37.7807730152091 | -122.40830321374901 | (37.7807730152091, -122.408303213749) | |||
| 14801 | 14801 | 22531 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6619 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2015 08:00:00 AM | 3 | 3X3 | 6012836.07271 | 2089639.80613 | 37.7184756630977 | -122.397613243265 | (37.7184756630977, -122.397613243265) | ||
| 15042 | 15042 | 94225 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 625 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53569 | 6014481.04423 | 2111852.0491299997 | 37.7795572495918 | -122.393480876451 | (37.7795572495918, -122.393480876451) | |
| 15078 | 15078 | 2525 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1570 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 02:24:00 PM | 3 | 3X3 | 6016567.66909 | 2098923.0431 | 37.7441726718323 | -122.385361080243 | (37.7441726718323, -122.385361080243) | ||
| 15099 | 15099 | 99592 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1855X Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014373.22453 | 2099430.50237 | 37.7454443986533 | -122.392984546922 | (37.7454443986533, -122.392984546922) | |||
| 15100 | 15100 | 48913 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 77 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768553 | 6013169.41892 | 2106659.71709 | 37.765227311822294 | -122.397654097675 | (37.7652273118223, -122.397654097675) | |
| 15164 | 15164 | 51415 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 7121 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2004 12:00:00 AM | Permit Number 47739 | ||||||||
| 15205 | 15205 | 102387 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 84 Harriet St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010709.4483199995 | 2111466.67522 | 37.778288823307 | -122.406501343779 | (37.778288823307, -122.406501343779) | |||
| 15396 | 15396 | 100890 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013579.59012 | 2111966.26913 | 37.779820743762606 | -122.39660742352 | (37.7798207437626, -122.39660742352) | |||
| 15469 | 15469 | 12131 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400X La Salle Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016434.11275 | 2095220.18267 | 37.7339979769066 | -122.38556488553499 | (37.7339979769066, -122.385564885535) | |||
| 15592 | 15592 | 102388 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 90X Harriet St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010739.31321 | 2111434.0362400003 | 37.778200875001104 | -122.406395729189 | (37.7782008750011, -122.406395729189) | |||
| 15713 | 15713 | 100889 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013566.0867800005 | 2111954.86803 | 37.7797886874229 | -122.396653338395 | (37.7797886874229, -122.396653338395) | |||
| 15863 | 15863 | 100892 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013627.65977 | 2112013.31498 | 37.7799525960738 | -122.396444426786 | (37.7799525960738, -122.396444426786) | |||
| 16089 | 16089 | 71389 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770154 | 6015658.34523 | 2096378.9353200002 | 37.7371367232675 | -122.388327823184 | (37.7371367232675, -122.388327823184) | |
| 16098 | 16098 | 100884 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013403.42787 | 2111798.46493 | 37.7793501860944 | -122.397205080544 | (37.7793501860944, -122.397205080544) | |||
| 16106 | 16106 | 12141 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400X La Salle Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016374.05041 | 2095443.42618 | 37.7346076354195 | -122.38578809634899 | (37.7346076354195, -122.385788096349) | |||
| 16215 | 16215 | 2527 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1570 Burke Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 02:21:00 PM | 3 | 3X3 | 6016536.91868 | 2098947.33995 | 37.7442376847211 | -122.38546910231001 | (37.7442376847211, -122.38546910231) |
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");