Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186579 | 186579 | 207184 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 300 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5997470.84744 | 2094454.3152599998 | 37.7308276067915 | -122.451071206573 | (37.7308276067915, -122.451071206573) | |||
| 184811 | 184811 | 177015 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 81 Lamartine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002665.86181 | 2094349.24813 | 37.730835173699106 | -122.433103720676 | (37.7308351736991, -122.433103720676) | |||
| 70729 | 70729 | 177010 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 78 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002632.11132 | 2094355.1655700002 | 37.73084950708879 | -122.433220824095 | (37.7308495070888, -122.433220824095) | |||
| 168658 | 168658 | 207185 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 300 Gennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5997471.20746 | 2094471.58174 | 37.7308750370476 | -122.451071206592 | (37.7308750370476, -122.451071206592) | |||
| 73988 | 73988 | 207312 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996777.2193 | 2094487.3918299999 | 37.730878690977704 | -122.45347156457399 | (37.7308786909777, -122.453471564574) | |||
| 33843 | 33843 | 177016 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 81 Lamartine St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002658.8277900005 | 2094369.8725599998 | 37.7308914046921 | -122.433129511441 | (37.7308914046921, -122.433129511441) | |||
| 28926 | 28926 | 207301 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 145 Hazelwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996452.48883 | 2094524.36789 | 37.7309615985977 | -122.454596874545 | (37.7309615985977, -122.454596874545) | |||
| 62171 | 62171 | 207300 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 145 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996448.99813 | 2094535.9636799998 | 37.730993237639105 | -122.45460977981199 | (37.7309932376391, -122.454609779812) | |||
| 43733 | 43733 | 207159 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 345 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992101.70168 | 2094641.4985900002 | 37.7310327079752 | -122.469646658486 | (37.7310327079752, -122.469646658486) | |||
| 70030 | 70030 | 177026 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Sweeny St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6008206.81715 | 2094351.9900900002 | 37.7311554564421 | -122.41394787781601 | (37.7311554564421, -122.413947877816) | |||
| 20702 | 20702 | 16302 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 747 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1992 12:00:00 AM | 3 | 3X3 | 5997139.1851 | 2094676.1292299998 | 37.73141766098679 | -122.452233809638 | (37.7314176609868, -122.452233809638) | ||
| 39694 | 39694 | 191411 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 462 Thornton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6012808.38143 | 2094403.0124599999 | 37.7315529172119 | -122.39804293216001 | (37.7315529172119, -122.39804293216) | |||
| 67611 | 67611 | 43211 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 353 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 5 | Permit Number 43002 | 6008758.60086 | 2094527.34935 | 37.73166792973 | -122.412052645639 | (37.73166792973, -122.412052645639) | |
| 70124 | 70124 | 207280 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 595 Darien Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993435.14458 | 2094919.26873 | 37.731872375313294 | -122.46505692344299 | (37.7318723753133, -122.465056923443) | |||
| 54556 | 54556 | 207281 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 595 Darien Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993428.290469999 | 2094922.6798 | 37.731881346040794 | -122.46508086700001 | (37.7318813460408, -122.465080867) | |||
| 31369 | 31369 | 207346 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 628 Edna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998595.0741 | 2094889.9944099998 | 37.7320881793139 | -122.44721593437201 | (37.7320881793139, -122.447215934372) | |||
| 73643 | 73643 | 207345 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 628 Edna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998591.38299 | 2094890.7633 | 37.732090079596794 | -122.44722875061399 | (37.7320900795968, -122.447228750614) | |||
| 76321 | 76321 | 207202 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 436 Gennessee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5997481.98173 | 2094926.0647599997 | 37.7321235559578 | -122.45106671987301 | (37.7321235559578, -122.451066719873) | ||||
| 74258 | 74258 | 207354 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 236 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996818.09015 | 2094943.97322 | 37.732134696764 | -122.453363219655 | (37.732134696764, -122.453363219655) | |||
| 75032 | 75032 | 207204 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 655 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5997746.28105 | 2094978.11771 | 37.7322816091084 | -122.450156733641 | (37.7322816091084, -122.450156733641) | |||
| 27028 | 27028 | 207203 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 659 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5997731.1976 | 2094979.2607200001 | 37.732283884374 | -122.450208962681 | (37.732283884374, -122.450208962681) | |||
| 68354 | 68354 | 207353 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 678 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5997598.43347 | 2095021.49363 | 37.7323922472992 | -122.45067100017201 | (37.7323922472992, -122.450671000172) | |||
| 156798 | 156798 | 207352 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 630 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5997888.696769999 | 2095016.78994 | 37.732395942619 | -122.44966715802299 | (37.732395942619, -122.449667158023) | ||||
| 71088 | 71088 | 207340 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 538 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998514.78137 | 2095005.5292 | 37.732400822345205 | -122.44750183606001 | (37.7324008223452, -122.44750183606) | ||||
| 75474 | 75474 | 207342 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 538 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998499.20735 | 2095008.2855900002 | 37.7324075007117 | -122.447555877206 | (37.7324075007117, -122.447555877206) | ||||
| 42650 | 42650 | 207339 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 436 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5999175.62485 | 2094995.5474599998 | 37.7324111582276 | -122.445216436593 | (37.7324111582276, -122.445216436593) | |||
| 69070 | 69070 | 207341 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 538 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5998515.2216 | 2095011.0330299998 | 37.7324159597185 | -122.447500710116 | (37.7324159597185, -122.447500710116) | ||||
| 59196 | 59196 | 78418 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2987 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 6 | 5988809.97189 | 2095328.5114400003 | 37.732728266388 | -122.481076880696 | (37.732728266388, -122.481076880696) | ||
| 159473 | 159473 | 78478 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2987 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 6 | 5988808.95801 | 2095345.9881400003 | 37.7327761939684 | -122.481081665112 | (37.7327761939684, -122.481081665112) | ||
| 3187 | 3187 | 207331 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 432 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/05/2002 12:00:00 AM | 8 | Width 8ft | Permit Number 45704 | 6000124.74065 | 2095150.49618 | 37.7328907415174 | -122.441946248045 | (37.7328907415174, -122.441946248045) | |
| 55314 | 55314 | 207344 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 543 Foerster St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 5998095.360119999 | 2095203.1187900002 | 37.7329193786311 | -122.448966095125 | (37.7329193786311, -122.448966095125) | |||
| 150214 | 150214 | 207343 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 543 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998102.37114 | 2095220.43245 | 37.732967318787296 | -122.448943103064 | (37.7329673187873, -122.448943103064) | |||
| 36611 | 36611 | 207332 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 139 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6000483.56606 | 2095198.0934400002 | 37.7330418734682 | -122.44070911276 | (37.7330418734682, -122.44070911276) | |||
| 70323 | 70323 | 207350 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 618 Mangels Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997300.95019 | 2095282.96772 | 37.7330931600175 | -122.451718319154 | (37.7330931600175, -122.451718319154) | |||
| 44325 | 44325 | 207349 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 618 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5997332.96655 | 2095282.6428599998 | 37.733094101592705 | -122.451607607218 | (37.7330941015927, -122.451607607218) | |||
| 112212 | 112212 | 207333 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 378 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998914.45517 | 2095254.7812700002 | 37.7331080419878 | -122.446137997991 | (37.7331080419878, -122.446137997991) | |||
| 133764 | 133764 | 207351 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 662 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5997053.67683 | 2095305.7853299999 | 37.7331416469589 | -122.45257485054701 | (37.7331416469589, -122.452574850547) | |||
| 152184 | 152184 | 50302 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 59 Inverness Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2004 12:00:00 AM | 4 | Permit Number 47012 | 5988294.3182 | 2095513.1698900003 | 37.7332053009864 | -122.482873130798 | (37.7332053009864, -122.482873130798) | |
| 57515 | 57515 | 67671 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1780 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1992 12:00:00 AM | 3 | Permit Number 31274 | 6014163.98928 | 2095111.2366 | 37.733572965423896 | -122.3934058406 | (37.7335729654239, -122.3934058406) | ||
| 186764 | 186764 | 207347 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 383 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 5997585.73238 | 2095504.5869999998 | 37.73371797929771 | -122.45074972953002 | (37.7337179792977, -122.45074972953) | |||
| 134996 | 134996 | 207348 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 359 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5997745.23089 | 2095505.757 | 37.733730320683605 | -122.450198383048 | (37.7337303206836, -122.450198383048) | |||
| 137313 | 137313 | 207334 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 27 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5999906.0481 | 2095478.3381 | 37.7337784541927 | -122.44272585413799 | (37.7337784541927, -122.442725854138) | |||
| 35186 | 35186 | 45487 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2934 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 3 | Permit Number 44266 | 5990011.75655 | 2095686.43247 | 37.7337808158159 | -122.476948200207 | (37.7337808158159, -122.476948200207) | |
| 24450 | 24450 | 45488 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2934 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 4 | Permit Number 44266 | 5990009.93985 | 2095708.66875 | 37.733841765574205 | -122.476956105249 | (37.7338417655742, -122.476956105249) | |
| 182796 | 182796 | 207336 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 114 Melrose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5999335.46736 | 2095537.54616 | 37.7339084817781 | -122.444702769016 | (37.7339084817781, -122.444702769016) | |||
| 188039 | 188039 | 207335 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 114 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5999338.03809 | 2095537.4927400001 | 37.7339084817987 | -122.444693877414 | (37.7339084817987, -122.444693877414) | |||
| 59479 | 59479 | 207337 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 114 Melrose Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5999331.40158 | 2095537.8442099998 | 37.7339090681372 | -122.44471684701901 | (37.7339090681372, -122.444716847019) | |||
| 158421 | 158421 | 207171 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 240 Stillings Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5999241.01629 | 2095793.3410200002 | 37.7346054437908 | -122.445047696791 | (37.7346054437908, -122.445047696791) | |||
| 178259 | 178259 | 207338 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 620 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000133.83069 | 2095802.7969900002 | 37.7346823250329 | -122.441961624641 | (37.7346823250329, -122.441961624641) | |||
| 172268 | 172268 | 51484 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 63 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2005 12:00:00 AM | 3 | Permit Number 47795 | 6013789.90035 | 2095538.1570700002 | 37.7347244096963 | -122.394729070715 | (37.7347244096963, -122.394729070715) | ||
| 181540 | 181540 | 43847 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2828 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 3 | Permit Number 43469 | 5985600.1899 | 2096127.6598 | 37.734735400872204 | -122.492232562099 | (37.7347354008722, -122.492232562099) | |
| 123823 | 123823 | 207323 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 734 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998893.471580001 | 2095962.39727 | 37.7350497898071 | -122.446261428139 | (37.7350497898071, -122.446261428139) | |||
| 37609 | 37609 | 207322 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 734 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998892.3170300005 | 2095965.24165 | 37.7350575338629 | -122.44626562436001 | (37.7350575338629, -122.44626562436) | |||
| 172280 | 172280 | 207170 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 100 Vista Verde Ct | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 10ft | 5999209.0212900005 | 2096067.6439599998 | 37.7353567886676 | -122.44517802836799 | (37.7353567886676, -122.445178028368) | |||
| 166542 | 166542 | 227701 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1201 San Jose Ave | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004423.64254 | 2096032.0928 | 37.7355554408308 | -122.427146608748 | (37.7355554408308, -122.427146608748) | ||||
| 138075 | 138075 | 227702 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1201 San Jose Ave | 44 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004467.63219 | 2096063.7098700001 | 37.7356447417011 | -122.426996770882 | (37.7356447417011, -122.426996770882) | ||||
| 149732 | 149732 | 191412 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1998 Revere Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6013024.42365 | 2095944.26783 | 37.7357969159791 | -122.39740407446001 | (37.7357969159791, -122.39740407446) | ||||
| 59995 | 59995 | 226605 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 276 Bemis St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6002989.382569999 | 2096277.75645 | 37.7361487649474 | -122.432122925433 | (37.7361487649474, -122.432122925433) | |||
| 30975 | 30975 | 227700 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 276 Bemis St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6002994.65302 | 2096282.17867 | 37.7361612061647 | -122.432105019051 | (37.7361612061647, -122.432105019051) | |||
| 27878 | 27878 | 226609 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4005 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008395.3202599995 | 2096426.5831400002 | 37.736862424666704 | -122.413442851824 | (37.7368624246667, -122.413442851824) | |||
| 34009 | 34009 | 70454 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2631 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 1 | 5982726.9666 | 2097193.7529 | 37.7374942155975 | -122.502244984058 | (37.7374942155975, -122.502244984058) | ||
| 129591 | 129591 | 185132 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2675 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985816.5603 | 2097133.8948 | 37.7375109017116 | -122.491558549707 | (37.7375109017116, -122.491558549707) | |||
| 60876 | 60876 | 226631 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 141 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6002644.82708 | 2096800.8937799998 | 37.737565638743895 | -122.43335156393299 | (37.7375656387439, -122.433351563933) | |||
| 167231 | 167231 | 207166 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 174 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5995172.17423 | 2097043.6524099999 | 37.737805421392295 | -122.459205466579 | (37.7378054213923, -122.459205466579) | |||
| 79917 | 79917 | 1384 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2550X Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X2 | 6002245.07965 | 2096962.3294799998 | 37.737986217166096 | -122.43474521929 | (37.7379862171661, -122.43474521929) | |||
| 57514 | 57514 | 226606 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2560 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6002251.74918 | 2096967.99127 | 37.7380021417799 | -122.434722564214 | (37.7380021417799, -122.434722564214) | |||
| 29724 | 29724 | 207328 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 400x Marietta Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5999485.75789 | 2097034.69989 | 37.738027887567796 | -122.444290723035 | (37.7380278875678, -122.444290723035) | |||
| 27445 | 27445 | 207324 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 85 Sequoia Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5998176.702190001 | 2097175.31508 | 37.7383392103809 | -122.44882688276199 | (37.7383392103809, -122.448826882762) | |||
| 129828 | 129828 | 226614 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 322 Elsie St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006361.987980001 | 2097015.1421299998 | 37.738364099132795 | -122.42051475707399 | (37.7383640991328, -122.420514757074) | |||
| 63672 | 63672 | 226582 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 383 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006413.772530001 | 2097021.64328 | 37.738384868057295 | -122.420336172385 | (37.7383848680573, -122.420336172385) | |||
| 152673 | 152673 | 226615 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 10 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005546.7514 | 2097096.0791900002 | 37.7385403572369 | -122.423339202051 | (37.7385403572369, -122.423339202051) | |||
| 52054 | 52054 | 226616 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005523.88104 | 2097105.4034 | 37.7385646686269 | -122.42341893953899 | (37.7385646686269, -122.423418939539) | |||
| 131253 | 131253 | 185261 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2177 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986220.9115 | 2097517.551 | 37.7385879417998 | -122.49018874910401 | (37.7385879417998, -122.490188749104) | |||
| 66099 | 66099 | 185262 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2167 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986237.8922 | 2097517.551 | 37.738588933455404 | -122.490130038774 | (37.7385889334554, -122.490130038774) | |||
| 51665 | 51665 | 185263 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2157 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986253.2809 | 2097519.1429 | 37.738594203049004 | -122.4900769498 | (37.738594203049, -122.4900769498) | |||
| 75227 | 75227 | 185264 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2147 Vicente St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986264.4244 | 2097520.2042 | 37.7385977678327 | -122.490038499473 | (37.7385977678327, -122.490038499473) | |||
| 59140 | 59140 | 207326 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 43 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998477.362380001 | 2097389.2678 | 37.7389438623547 | -122.447802750104 | (37.7389438623547, -122.447802750104) | |||
| 188987 | 188987 | 207327 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 48 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998437.39477 | 2097397.71392 | 37.7389647688951 | -122.44794154698401 | (37.7389647688951, -122.447941546984) | |||
| 61977 | 61977 | 226613 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 322 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006488.43942 | 2097246.62658 | 37.7390068293023 | -122.42009397237601 | (37.7390068293023, -122.420093972376) | |||
| 11855 | 11855 | 112294 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2606 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x2 | 5989896.9401 | 2097604.9354 | 37.7390418709124 | -122.47748532406099 | (37.7390418709124, -122.477485324061) | |||
| 11700 | 11700 | 109233 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2570 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x9 | 5986169.5717 | 2097728.0842 | 37.7391630116047 | -122.490381738824 | (37.7391630116047, -122.490381738824) | |||
| 133243 | 133243 | 226583 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 65 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005675.46056 | 2097328.12115 | 37.7391847556639 | -122.422910674207 | (37.7391847556639, -122.422910674207) | |||
| 135470 | 135470 | 207277 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 236 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992402.86272 | 2097663.9953099997 | 37.7393491274725 | -122.46882536342 | (37.7393491274725, -122.46882536342) | |||
| 50277 | 50277 | 226617 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 58 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005670.60555 | 2097390.14395 | 37.739354782382996 | -122.422931867621 | (37.739354782383, -122.422931867621) | |||
| 74830 | 74830 | 207158 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 237 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992472.8250400005 | 2097675.82148 | 37.739385640835295 | -122.468584327098 | (37.7393856408353, -122.468584327098) | |||
| 34491 | 34491 | 207157 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 237 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992487.55481 | 2097691.20205 | 37.7394287228632 | -122.468534517269 | (37.7394287228632, -122.468534517269) | |||
| 103991 | 103991 | 100461 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 236 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992450.0 | 2097712.0 | 37.7394836593705 | -122.468665877071 | (37.7394836593705, -122.468665877071) | |||||
| 137737 | 137737 | 207316 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 540 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991234.77071 | 2097748.67502 | 37.739514082899795 | -122.47287024148899 | (37.7395140828998, -122.472870241489) | |||
| 184863 | 184863 | 226581 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 110 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006265.98852 | 2097494.29518 | 37.739674335789 | -122.420880685817 | (37.739674335789, -122.420880685817) | |||
| 184400 | 184400 | 207325 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 530 Rockdale Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5997976.81268 | 2097718.94755 | 37.739820461255604 | -122.449557161036 | (37.7398204612556, -122.449557161036) | |||
| 179554 | 179554 | 42889 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2249 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 3 | Permit Number 42809 | 5988969.9668 | 2098294.7493 | 37.7408820870559 | -122.48074082372801 | (37.7408820870559, -122.480740823728) | |
| 76937 | 76937 | 42890 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2249 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 3 | Permit Number 42809 | 5988984.6022 | 2098295.481 | 37.7408849467502 | -122.48069027409402 | (37.7408849467502, -122.480690274094) | |
| 181601 | 181601 | 207172 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995322.34396 | 2098236.54105 | 37.741089431634705 | -122.458772597671 | (37.7410894316347, -122.458772597671) | |||
| 152617 | 152617 | 207174 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5995326.26295 | 2098236.71907 | 37.741090145688894 | -122.458759060198 | (37.7410901456889, -122.458759060198) | |||
| 160296 | 160296 | 207175 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995328.909969999 | 2098238.4831 | 37.7410951414231 | -122.458750035501 | (37.7410951414231, -122.458750035501) | |||
| 42221 | 42221 | 207173 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5995323.713819999 | 2098239.63146 | 37.7410979958728 | -122.45876808490601 | (37.7410979958728, -122.458768084906) | |||
| 76247 | 76247 | 207177 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5995331.55155 | 2098239.9871900002 | 37.7410994231129 | -122.458741010797 | (37.7410994231129, -122.458741010797) | |||
| 151636 | 151636 | 207176 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995327.39898 | 2098241.1137 | 37.741102277551896 | -122.45875545032301 | (37.7411022775519, -122.458755450323) | |||
| 187623 | 187623 | 226610 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 187 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007102.33802 | 2097997.69789 | 37.7411036742096 | -122.418024617936 | (37.7411036742096, -122.418024617936) | |||
| 57155 | 57155 | 207179 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5995334.19857 | 2098241.75122 | 37.741104418845794 | -122.458731986098 | (37.7411044188458, -122.458731986098) |
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");