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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 144482 | 144482 | 98742 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 03/21/2012 12:00:00 AM | 3 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | |
| 145720 | 145720 | 98741 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 03/21/2012 12:00:00 AM | 3 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | |
| 95213 | 95213 | 113810 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4101x 25TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | |||
| 106701 | 106701 | 113812 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4101x 25TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 1 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
| 42751 | 42751 | 108789 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 79513 | 79513 | 95519 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5 | 3x3 | 5985993.74648 | 2111883.3180400003 | 37.7780191077803 | -122.49203157445 | (37.7780191077803, -122.49203157445) | |||
| 82210 | 82210 | 108786 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 84872 | 84872 | 108785 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 91382 | 91382 | 95488 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986007.7101 | 2111508.12486 | 37.776989750535 | -122.491955639862 | (37.776989750535, -122.491955639862) | |||
| 93377 | 93377 | 95497 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5985999.2312900005 | 2111660.71954 | 37.777408236422296 | -122.491996207782 | (37.7774082364223, -122.491996207782) | |||
| 94030 | 94030 | 95491 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986009.30138 | 2111441.61533 | 37.776807227327396 | -122.491945237383 | (37.7768072273274, -122.491945237383) | |||
| 96578 | 96578 | 95515 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5985992.57608 | 2111969.58011 | 37.7782558903759 | -122.492041976045 | (37.7782558903759, -122.492041976045) | |||
| 96802 | 96802 | 95494 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986000.13497 | 2111717.2940599998 | 37.7775636267397 | -122.491997248036 | (37.7775636267397, -122.491997248036) | |||
| 99342 | 99342 | 95260 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 99997 | 99997 | 108787 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 101527 | 101527 | 95518 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5 | 3x3 | 5985992.056890001 | 2111902.81718 | 37.778072548088495 | -122.49203885528601 | (37.7780725480885, -122.492038855286) | |||
| 106816 | 106816 | 95261 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 107004 | 107004 | 95516 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5 | 3x3 | 5985994.45155 | 2111944.6872400003 | 37.778187651292896 | -122.492033654948 | (37.7781876512929, -122.492033654948) | |||
| 108571 | 108571 | 95509 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 02/19/2015 02:37:00 PM | 3 | 3x3 | 5985988.58257 | 2112092.73248 | 37.7785937981587 | -122.492064860632 | (37.7785937981587, -122.492064860632) | ||
| 111692 | 111692 | 95487 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986008.46306 | 2111529.3689900003 | 37.777048124873296 | -122.49195459962401 | (37.7770481248733, -122.491954599624) | |||
| 112142 | 112142 | 95511 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 02/19/2015 02:32:00 PM | 3 | 3x3 | 5985988.37339 | 2112068.78219 | 37.7785280252799 | -122.492063820389 | (37.7785280252799, -122.492063820389) | ||
| 117880 | 117880 | 95486 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986007.39345 | 2111549.75354 | 37.777104032517705 | -122.49195980083701 | (37.7771040325177, -122.491959800837) | |||
| 119088 | 119088 | 95258 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 120188 | 120188 | 95514 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 02/19/2015 02:29:00 PM | 3 | 3x3 | 5985991.7561 | 2111987.56369 | 37.7783052202186 | -122.492046137036 | (37.7783052202186, -122.492046137036) | ||
| 123561 | 123561 | 95485 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | 3x3 | 5986006.6183 | 2111569.83262 | 37.777159118639496 | -122.49196396094601 | (37.7771591186395, -122.491963960946) | |||
| 124692 | 124692 | 95484 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986002.98697 | 2111639.37953 | 37.777349862368496 | -122.491981644298 | (37.7773498623685, -122.491981644298) | |||
| 138703 | 138703 | 95262 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 139550 | 139550 | 95513 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5985988.88946 | 2112008.2856099997 | 37.7783619491242 | -122.49205757976002 | (37.7783619491242, -122.49205757976) | |||
| 140987 | 140987 | 95489 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986007.8525 | 2111486.5622099997 | 37.7769305539658 | -122.49195355936199 | (37.7769305539658, -122.491953559362) | |||
| 141798 | 141798 | 95490 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986007.65609 | 2111463.21002 | 37.7768664240251 | -122.49195251911199 | (37.7768664240251, -122.491952519112) | |||
| 142332 | 142332 | 95517 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | 3x3 | 5985993.99278 | 2111923.13747 | 37.778128454962 | -122.49203365493601 | (37.778128454962, -122.492033654936) | |||
| 142592 | 142592 | 96085 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 142924 | 142924 | 108788 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 145208 | 145208 | 95259 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 17358 | 17358 | 4165 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3770 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2016 12:00:00 AM | 3 | 3X3 | Permit Number 774303 | 6005421.09901 | 2100523.30385 | 37.747943645176704 | -122.424017300779 | (37.7479436451767, -122.424017300779) | |
| 17728 | 17728 | 10153 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 978 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2016 06:51:00 AM | 3 | 3x4 | 6005672.85931 | 2103292.97405 | 37.7555627312558 | -122.423343584439 | (37.7555627312558, -122.423343584439) | ||
| 18209 | 18209 | 10188 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1148 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/05/2016 12:00:00 AM | 3 | 2x4 | 6005734.612380001 | 2102244.83146 | 37.75268825965679 | -122.423055527089 | (37.7526882596568, -122.423055527089) | ||
| 18648 | 18648 | 10186 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1130 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2015 04:47:00 AM | 3 | 4x5 | 6005723.69305 | 2102361.07491 | 37.753006821117296 | -122.423101549889 | (37.7530068211173, -122.423101549889) | ||
| 18695 | 18695 | 16874 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 269 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/21/2015 08:43:00 AM | 3 | 3X3 | 6005705.9301 | 2110300.3269 | 37.7748051262311 | -122.423727430112 | (37.7748051262311, -122.423727430112) | ||
| 18818 | 18818 | 10127 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 892 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6005646.424 | 2103793.6441599997 | 37.7569359627397 | -122.42347059841002 | (37.7569359627397, -122.42347059841) | |||
| 19486 | 19486 | 10095 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 727 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 05:21:00 AM | 3 | 2X2 | 6005664.2360000005 | 2104708.85405 | 37.759449920391 | -122.423474060781 | (37.759449920391, -122.423474060781) | ||
| 19508 | 19508 | 90355 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 745 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993230.153419999 | 2111367.69142 | 37.777023672198794 | -122.46696097646699 | (37.7770236721988, -122.466960976467) | ||
| 19807 | 19807 | 93394 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3077 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5996268.61185 | 2111428.40102 | 37.777365269924296 | -122.456454460594 | (37.7773652699243, -122.456454460594) | ||
| 20345 | 20345 | 5583 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1069 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6005153.43733 | 2102137.63056 | 37.752361098006894 | -122.42505770847299 | (37.7523610980069, -122.425057708473) | |||
| 20425 | 20425 | 10057 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 439 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2016 06:50:00 AM | 3 | 3X3 | 6005566.67326 | 2106440.43668 | 37.7641989307536 | -122.423934614407 | (37.7641989307536, -122.423934614407) | ||
| 20752 | 20752 | 27680 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 320 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/2014 06:28:00 AM | 3 | 3x3 | 6005461.15776 | 2107102.0666400003 | 37.7660096518439 | -122.42434662439501 | (37.7660096518439, -122.424346624395) | ||
| 20785 | 20785 | 856 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 400X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2001 12:00:00 AM | 8 | 3x3 | 6008178.91279 | 2095102.6011299998 | 37.7332149048351 | -122.414097431452 | (37.7332149048351, -122.414097431452) | ||
| 21046 | 21046 | 10125 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 876 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2015 02:57:00 PM | 3 | 3x3 | 6005640.441980001 | 2103866.83654 | 37.757136594295396 | -122.423496489872 | (37.7571365942954, -122.423496489872) | ||
| 21052 | 21052 | 16925 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 512 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 25 | 6004419.62206 | 2110173.45228 | 37.7743840640969 | -122.42816799305099 | (37.7743840640969, -122.428167993051) | ||||
| 21836 | 21836 | 10190 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1160 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/2015 09:38:00 AM | 3 | 2x2 | 6005734.23383 | 2102203.6860700003 | 37.7525752625596 | -122.42305391193001 | (37.7525752625596, -122.42305391193) | ||
| 21922 | 21922 | 10107 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 799X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2014 06:59:00 AM | 3 | 3x4 | 6005682.50344 | 2104371.2203900004 | 37.7585238884792 | -122.423386880525 | (37.7585238884792, -122.423386880525) | ||
| 22160 | 22160 | 24821 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 400X Alemany Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 12 | 3x3 | 6007884.87342 | 2094945.99869 | 37.7327683887373 | -122.41510292745701 | (37.7327683887373, -122.415102927457) | ||
| 22211 | 22211 | 10150 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 966 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/2012 12:00:00 AM | 3 | 3x3 | 6005669.65476 | 2103355.68664 | 37.7557347445795 | -122.423359124725 | (37.7557347445795, -122.423359124725) | ||
| 22422 | 22422 | 7875 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2014 02:38:00 PM | 3 | 4X4 | 6006070.45315 | 2113764.9909599996 | 37.7843388199314 | -122.422712735214 | (37.7843388199314, -122.422712735214) | ||
| 22997 | 22997 | 12121 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6016540.00349 | 2094984.34395 | 37.733356269266295 | -122.38518235797899 | (37.7333562692663, -122.385182357979) | |||
| 23024 | 23024 | 2316 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2263 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 6009682.41451 | 2104184.36513 | 37.7582357681755 | -122.409540144857 | (37.7582357681755, -122.409540144857) | ||||
| 23088 | 23088 | 29 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 742 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6003854.77769 | 2107764.13441 | 37.7677366901162 | -122.42994999788799 | (37.7677366901162, -122.429949997888) | |||
| 23242 | 23242 | 1673 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 200 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 5994963.861330001 | 2111486.70203 | 37.7774503572538 | -122.460972213003 | (37.7774503572538, -122.460972213003) | ||||
| 23334 | 23334 | 8279 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1601 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x3 | 6015771.79311 | 2097687.24817 | 37.740735369454605 | -122.388026849781 | (37.7407353694546, -122.388026849781) | |||
| 29751 | 29751 | 219429 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900x Kirkham St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 4ft | 5992085.46562 | 2105232.9931400004 | 37.7601132972171 | -122.47047387378099 | (37.7601132972171, -122.470473873781) | |||
| 38671 | 38671 | 180422 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003342.53075 | 2094283.93013 | 37.7306941860739 | -122.43075970881901 | (37.7306941860739, -122.430759708819) | |||
| 47439 | 47439 | 21845 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 211X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5994919.338930001 | 2111427.06219 | 37.7772840400997 | -122.461121905578 | (37.7772840400997, -122.461121905578) | |||
| 50167 | 50167 | 122876 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 51014 | 51014 | 180421 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003365.77706 | 2094291.48085 | 37.7307162356701 | -122.430679881378 | (37.7307162356701, -122.430679881378) | |||
| 57854 | 57854 | 180417 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003506.26836 | 2094339.1696799998 | 37.730855136838606 | -122.430197582161 | (37.7308551368386, -122.430197582161) | |||
| 58391 | 58391 | 182082 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1109 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2017 12:00:00 AM | 3 | Width 0ft | 5989746.1732 | 2098995.6798 | 37.7428517447762 | -122.47810825386001 | (37.7428517447762, -122.47810825386) | ||
| 64285 | 64285 | 180415 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003554.97456 | 2094355.58631 | 37.7309029717957 | -122.43003036762899 | (37.7309029717957, -122.430030367629) | |||
| 64598 | 64598 | 123720 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | Width 3ft | 5995264.25203 | 2111440.07761 | 37.7773396195467 | -122.459929691175 | (37.7773396195467, -122.459929691175) | ||
| 66122 | 66122 | 180418 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003475.18041 | 2094328.74311 | 37.73082474696329 | -122.430304314596 | (37.7308247469633, -122.430304314596) | |||
| 69274 | 69274 | 25308 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 279X Ocean Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2011 12:00:00 AM | 3 | 3x3 | 6000039.97311 | 2091577.8604700002 | 37.7230762793257 | -122.44198296803499 | (37.7230762793257, -122.441982968035) | ||
| 76907 | 76907 | 180414 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003758.53299 | 2094425.58203 | 37.73110669070989 | -122.42933162228 | (37.7311066907099, -122.42933162228) |
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");