Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCareAssistant, DBH
qCaretaker ✖
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 621 | 621 | 251339 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/28/2012 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) | |||
| 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) | |||
| 54906 | 54906 | 249573 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006042.707780001 | 2113571.74375 | 37.7838066452086 | -122.422794986325 | (37.7838066452086, -122.422794986325) | |||
| 171813 | 171813 | 249416 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 650 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006834.06276 | 2112935.18598 | 37.7821034308803 | -122.42001200005899 | (37.7821034308803, -122.420012000059) | |||
| 163510 | 163510 | 248272 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 155 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006707.09266 | 2098676.55719 | 37.742945416513 | -122.419439385544 | (37.742945416513, -122.419439385544) | |||
| 63993 | 63993 | 248030 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 155 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010347.266969999 | 2099079.20277 | 37.7442553510029 | -122.406880978172 | (37.7442553510029, -122.406880978172) | |||
| 118176 | 118176 | 247757 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 64 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6001625.44981 | 2108428.3343599997 | 37.769433914972794 | -122.437708531026 | (37.7694339149728, -122.437708531026) | |||
| 138221 | 138221 | 247570 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 398 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6008218.8093 | 2095126.8275400002 | 37.7332836661113 | -122.41396121114401 | (37.7332836661113, -122.413961211144) | |||
| 174349 | 174349 | 247046 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 555 Valley St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6002319.09845 | 2099130.9656 | 37.7439449895856 | -122.434644325878 | (37.7439449895856, -122.434644325878) | |||
| 50950 | 50950 | 246860 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1198 Oak St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6001322.98115 | 2109744.38173 | 37.773030249875795 | -122.43884907734301 | (37.7730302498758, -122.438849077343) | |||
| 179692 | 179692 | 246859 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1198 Oak St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6001348.19607 | 2109746.2469900004 | 37.7730368059387 | -122.43876198966998 | (37.7730368059387, -122.43876198967) | |||
| 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) | |||
| 173599 | 173599 | 246851 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 398 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6001242.813130001 | 2109957.23852 | 37.7736101399319 | -122.439141646592 | (37.7736101399319, -122.439141646592) | |||
| 175810 | 175810 | 246512 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 50 Laguna St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005254.0996199995 | 2109149.02764 | 37.7716184212706 | -122.425208466318 | (37.7716184212706, -122.425208466318) | |||
| 35858 | 35858 | 246494 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 365 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6004182.0093 | 2099825.58993 | 37.745957849487795 | -122.428252301803 | (37.7459578494878, -122.428252301803) | |||
| 133181 | 133181 | 242915 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 111 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005066.82423 | 2099579.80768 | 37.7453330131246 | -122.425175243547 | (37.7453330131246, -122.425175243547) | |||
| 150136 | 150136 | 242914 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 326 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003748.60562 | 2099259.79726 | 37.7443797812115 | -122.429710605574 | (37.7443797812115, -122.429710605574) | |||
| 153134 | 153134 | 242913 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 510 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003222.68782 | 2098941.90353 | 37.74347712448029 | -122.431506428479 | (37.7434771244803, -122.431506428479) | |||
| 132171 | 132171 | 242912 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1154 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6004415.185819999 | 2102148.8561 | 37.7523501901347 | -122.427611502469 | (37.7523501901347, -122.427611502469) | |||
| 74244 | 74244 | 242911 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1750 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004608.20816 | 2098643.6107799998 | 37.74273651209621 | -122.426694407136 | (37.7427365120962, -122.426694407136) | |||
| 34285 | 34285 | 242910 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 360 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6004800.5697 | 2110038.5843599997 | 37.774035296231105 | -122.426840616201 | (37.7740352962311, -122.426840616201) | |||
| 157683 | 157683 | 242909 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 360 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6004814.05925 | 2110039.42445 | 37.7740383656155 | -122.426794013354 | (37.7740383656155, -122.426794013354) | |||
| 36920 | 36920 | 242908 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 320 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6004832.66793 | 2110043.51339 | 37.7740506449575 | -122.426729933953 | (37.7740506449575, -122.426729933953) | |||
| 26512 | 26512 | 242907 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 320 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6004859.69332 | 2110047.4287099997 | 37.774062923387795 | -122.426636727297 | (37.7740629233878, -122.426636727297) | |||
| 35027 | 35027 | 242906 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2641 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010204.149619999 | 2104543.2646 | 37.759250446279005 | -122.407761055636 | (37.759250446279, -122.407761055636) | |||
| 178227 | 178227 | 242905 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3699 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005206.83897 | 2101930.88885 | 37.751796449653796 | -122.424858329659 | (37.7517964496538, -122.424858329659) | |||
| 62996 | 62996 | 242904 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3699 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005195.07588 | 2101930.11385 | 37.7517936572624 | -122.424898952928 | (37.7517936572624, -122.424898952928) | |||
| 132483 | 132483 | 242903 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3488 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005177.3134 | 2103144.11006 | 37.7551260051884 | -122.42504674661899 | (37.7551260051884, -122.425046746619) | |||
| 169009 | 169009 | 242902 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3666 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005844.93191 | 2104346.37616 | 37.7584648381049 | -122.42282336352801 | (37.7584648381049, -122.422823363528) | |||
| 35907 | 35907 | 242901 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3666 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005862.21716 | 2104347.95143 | 37.758470138701895 | -122.422763695285 | (37.7584701387019, -122.422763695285) | |||
| 147392 | 147392 | 242900 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 York St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009967.375580001 | 2103010.90025 | 37.7550296598983 | -122.408471847422 | (37.7550296598983, -122.408471847422) | |||
| 56748 | 56748 | 242899 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009967.68817 | 2103026.2265 | 37.7550717598627 | -122.408471847423 | (37.7550717598627, -122.408471847423) | |||
| 40310 | 40310 | 242898 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009967.25969 | 2103043.9270599997 | 37.755120337650105 | -122.408474577742 | (37.7551203376501, -122.408474577742) | |||
| 23708 | 23708 | 242897 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2240 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009615.11015 | 2104286.89095 | 37.7585135094078 | -122.409780150527 | (37.7585135094078, -122.409780150527) | |||
| 133434 | 133434 | 242896 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2240 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009613.5702599995 | 2104303.49439 | 37.758559012408206 | -122.40978664815901 | (37.7585590124082, -122.409786648159) | |||
| 59128 | 59128 | 242895 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2240 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009610.63956 | 2104317.7201799997 | 37.758597908975794 | -122.409797788038 | (37.7585979089758, -122.409797788038) | |||
| 62590 | 62590 | 242894 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2240 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009610.93402 | 2104332.14774 | 37.75863754029871 | -122.409797788056 | (37.7586375402987, -122.409797788056) | |||
| 54863 | 54863 | 242893 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009611.06825 | 2104365.0211099996 | 37.758727810669 | -122.40979964426201 | (37.758727810669, -122.409799644262) | |||
| 56012 | 56012 | 242892 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009607.80803 | 2104389.4106400004 | 37.7587945961009 | -122.40981264124599 | (37.7587945961009, -122.409812641246) | |||
| 54252 | 54252 | 242891 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009605.6935 | 2104404.1546400003 | 37.7588349612916 | -122.40982099504801 | (37.7588349612916, -122.409820995048) | |||
| 32025 | 32025 | 242890 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009606.26166 | 2104418.84355 | 37.7588753255595 | -122.40982006693999 | (37.7588753255595, -122.40982006694) | |||
| 69237 | 69237 | 242889 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2299 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009692.14861 | 2104038.45682 | 37.7578356822768 | -122.40949618239999 | (37.7578356822768, -122.4094961824) | |||
| 35758 | 35758 | 242888 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005717.8738400005 | 2102519.39452 | 37.753441201753205 | -122.423132926343 | (37.7534412017532, -122.423132926343) | |||
| 58664 | 58664 | 242887 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005696.3409 | 2102856.44643 | 37.754365453022 | -122.423231349069 | (37.754365453022, -122.423231349069) | |||
| 148742 | 148742 | 242886 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 435 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007448.19697 | 2107143.49662 | 37.766235412247894 | -122.417476777052 | (37.7662354122479, -122.417476777052) | |||
| 159410 | 159410 | 242885 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 435 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007449.5098 | 2107068.51077 | 37.7660295925224 | -122.417466921388 | (37.7660295925224, -122.417466921388) | |||
| 158673 | 158673 | 242884 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 798 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007497.35986 | 2105057.20463 | 37.7605097057872 | -122.41715888377199 | (37.7605097057872, -122.417158883772) | |||
| 160152 | 160152 | 242883 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 235 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007114.04394 | 2107899.15094 | 37.7682914540022 | -122.418686143969 | (37.7682914540022, -122.418686143969) | |||
| 50918 | 50918 | 242882 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1399 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007001.44379 | 2107374.71472 | 37.7668451355276 | -122.419038415585 | (37.7668451355276, -122.419038415585) | |||
| 168908 | 168908 | 242881 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1334 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007152.90115 | 2107695.77387 | 37.767735216134604 | -122.41853731696301 | (37.7677352161346, -122.418537316963) | |||
| 64340 | 64340 | 242880 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1321 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6007174.89238 | 2107740.52123 | 37.7678593198724 | -122.41846442511101 | (37.7678593198724, -122.418464425111) | |||
| 65248 | 65248 | 242879 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1474 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007562.74357 | 2107381.13607 | 37.7668943590015 | -122.41709742140301 | (37.7668943590015, -122.417097421403) | |||
| 47240 | 47240 | 242878 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1470 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007581.63696 | 2107382.48327 | 37.7668991209285 | -122.417032167507 | (37.7668991209285, -122.417032167507) | |||
| 74338 | 74338 | 242877 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3298 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6004980.057 | 2106654.52331 | 37.7647536263021 | -122.425978794106 | (37.7647536263021, -122.425978794106) | |||
| 25557 | 25557 | 242876 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3298 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6005033.62978 | 2106658.32415 | 37.7647670900596 | -122.425793770266 | (37.7647670900596, -122.425793770266) | |||
| 76900 | 76900 | 242875 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2600 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010748.80165 | 2102292.81523 | 37.753101687901605 | -122.40571886164699 | (37.7531016879016, -122.405718861647) | |||
| 181292 | 181292 | 242874 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 62 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005180.17722 | 2105756.65507 | 37.7622996012591 | -122.425222734963 | (37.7622996012591, -122.425222734963) | |||
| 157952 | 157952 | 242873 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2650 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6010144.5827 | 2103997.84571 | 37.757749513755705 | -122.40792860561501 | (37.7577495137557, -122.407928605615) | |||
| 176526 | 176526 | 242872 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2650 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6010155.11126 | 2103998.01915 | 37.7577505794312 | -122.407892205568 | (37.7577505794312, -122.407892205568) | |||
| 170628 | 170628 | 242871 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1700 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009441.4286 | 2106739.88678 | 37.765239142394 | -122.410554039658 | (37.765239142394, -122.410554039658) | |||
| 152310 | 152310 | 242870 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 498 Oak St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6004648.6662099995 | 2110205.3941200003 | 37.7744847252106 | -122.42737796202 | (37.7744847252106, -122.42737796202) | |||
| 176200 | 176200 | 242869 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 348 Church St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6004153.4659400005 | 2106885.51591 | 37.7653411264215 | -122.428854226135 | (37.7653411264215, -122.428854226135) | |||
| 165104 | 165104 | 242868 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 388 Guerrero St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6005479.97294 | 2106783.54072 | 37.7651361178728 | -122.42425889015301 | (37.7651361178728, -122.424258890153) | |||
| 121794 | 121794 | 242867 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1346 Stevenson St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6006264.314669999 | 2108835.25141 | 37.7708138850713 | -122.421691777169 | (37.7708138850713, -122.421691777169) | |||
| 31159 | 31159 | 242866 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 98 McCoppin St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006095.439119999 | 2109158.70233 | 37.7716924795429 | -122.422298906788 | (37.7716924795429, -122.422298906788) | |||
| 63163 | 63163 | 242865 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 98 McCoppin St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006113.4001 | 2109160.84618 | 37.7716993791617 | -122.422236930889 | (37.7716993791617, -122.422236930889) | |||
| 61287 | 61287 | 242864 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 98 McCoppin St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006148.77092 | 2109162.88394 | 37.771706969419796 | -122.422114725619 | (37.7717069694198, -122.422114725619) | |||
| 36650 | 36650 | 242863 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 98 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006168.47171 | 2109163.73568 | 37.7717104192431 | -122.422046639762 | (37.7717104192431, -122.422046639762) | |||
| 38673 | 38673 | 242350 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 70 McCoppin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006095.21609 | 2109159.69147 | 37.771695182903706 | -122.42229974855302 | (37.7716951829037, -122.422299748553) | |||
| 184495 | 184495 | 242349 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 70 McCoppin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006130.70544 | 2109162.10737 | 37.7717038181943 | -122.422177160163 | (37.7717038181943, -122.422177160163) | |||
| 176503 | 176503 | 242348 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 70 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006148.63629 | 2109163.83557 | 37.7717095747744 | -122.422115258931 | (37.7717095747744, -122.422115258931) | |||
| 187580 | 187580 | 242347 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1338 Stevenson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6006258.64946 | 2108864.05359 | 37.7708926495153 | -122.42171341936199 | (37.7708926495153, -122.421713419362) | |||
| 179775 | 179775 | 242346 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1353 Stevenson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006282.631569999 | 2108802.50666 | 37.7707250086772 | -122.421626092471 | (37.7707250086772, -122.421626092471) | |||
| 182205 | 182205 | 242345 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 33 Digby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6003025.15888 | 2097332.31594 | 37.7390463716034 | -122.43207451582501 | (37.7390463716034, -122.432074515825) | |||
| 55397 | 55397 | 242344 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 147 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002611.74141 | 2096837.65353 | 37.7376646954683 | -122.43346858283199 | (37.7376646954683, -122.433468582832) | |||
| 135307 | 135307 | 242343 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 55 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002574.88674 | 2096054.3803299998 | 37.7355119163433 | -122.433540046544 | (37.7355119163433, -122.433540046544) | |||
| 29092 | 29092 | 242342 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 50 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004264.15883 | 2097942.68629 | 37.740792476382 | -122.427834099074 | (37.740792476382, -122.427834099074) | |||
| 31564 | 31564 | 242341 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1867 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004609.18081 | 2097837.81117 | 37.7405240251544 | -122.426633675907 | (37.7405240251544, -122.426633675907) | |||
| 54192 | 54192 | 242340 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 232 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5997593.66914 | 2106162.79262 | 37.76298324339871 | -122.45149078527099 | (37.7629832433987, -122.451490785271) | |||
| 176191 | 176191 | 242339 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1035 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001342.6727 | 2100671.2124799998 | 37.748118662255294 | -122.438130887736 | (37.7481186622553, -122.438130887736) | |||
| 170877 | 170877 | 242338 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1407 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5999569.11021 | 2107684.75025 | 37.7672750825135 | -122.44476784037701 | (37.7672750825135, -122.444767840377) | |||
| 33722 | 33722 | 242337 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 157 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004758.7797 | 2102744.04826 | 37.754003877891606 | -122.42646567447599 | (37.7540038778916, -122.426465674476) | |||
| 42765 | 42765 | 242336 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1404 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003892.07763 | 2100038.4689599997 | 37.7465259566162 | -122.429270023211 | (37.7465259566162, -122.429270023211) | |||
| 45828 | 45828 | 242335 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 240 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004310.20228 | 2099583.9062799998 | 37.7453014945788 | -122.427791810249 | (37.7453014945788, -122.427791810249) | |||
| 166466 | 166466 | 242334 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 206 28th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004464.328980001 | 2099597.23068 | 37.7453467979142 | -122.427259814498 | (37.7453467979142, -122.427259814498) | |||
| 155359 | 155359 | 242333 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 206 28th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004491.06856 | 2099598.53181 | 37.7453518826974 | -122.427167446043 | (37.7453518826974, -122.427167446043) | |||
| 23715 | 23715 | 242332 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 206 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004510.161859999 | 2099597.97023 | 37.7453514204499 | -122.42710138452101 | (37.7453514204499, -122.427101384521) | |||
| 26764 | 26764 | 242331 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 206 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004526.0717 | 2099598.82102 | 37.74535465619329 | -122.427046431465 | (37.7453546561933, -122.427046431465) | |||
| 166295 | 166295 | 242330 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 110 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6005175.96727 | 2099631.57497 | 37.745481319400795 | -122.424801526695 | (37.7454813194008, -122.424801526695) | |||
| 49855 | 49855 | 242329 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 107 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005095.8624599995 | 2099583.89393 | 37.745345873425705 | -122.42507512473699 | (37.7453458734257, -122.425075124737) |
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");