Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 27070 | 27070 | 118586 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 110 Point Lobos Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 5982415.39383 | 2112637.72046 | 37.779880658188794 | -122.50446606808501 | (37.7798806581888, -122.504466068085) | |||
| 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) | |||
| 30391 | 30391 | 207358 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 171 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998941.871780001 | 2093762.1788299999 | 37.7290112721346 | -122.445935896945 | (37.7290112721346, -122.445935896945) | ||||
| 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) | |||
| 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) | |||
| 33118 | 33118 | 118541 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981337.423690001 | 2112399.66579 | 37.779163567264 | -122.50817750438699 | (37.779163567264, -122.508177504387) | ||||
| 35068 | 35068 | 207355 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 430 Edna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998789.17566 | 2094262.87598 | 37.730377348622106 | -122.446499784464 | (37.7303773486221, -122.446499784464) | ||||
| 35498 | 35498 | 129498 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 855 Chestnut St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 6ft | 6007778.02269 | 2120584.45961 | 37.803159586216395 | -122.417288546245 | (37.8031595862164, -122.417288546245) | |||
| 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) | |||
| 37207 | 37207 | 207145 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1418 14th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5991828.31268 | 2105750.01462 | 37.7615180292623 | -122.471400907553 | (37.7615180292623, -122.471400907553) | |||
| 37229 | 37229 | 207260 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 282 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5992744.11171 | 2089090.22365 | 37.7158273737034 | -122.46702231894 | (37.7158273737034, -122.46702231894) | |||
| 38449 | 38449 | 226599 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1832 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6002599.9125 | 2100157.5460099997 | 37.746779676940896 | -122.43374669365 | (37.7467796769409, -122.43374669365) | |||
| 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) | |||
| 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) | |||
| 47578 | 47578 | 226625 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 311 Collingwood St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6002111.00363 | 2104000.9193700003 | 37.7573049096042 | -122.43571221954299 | (37.7573049096042, -122.435712219543) | |||
| 47592 | 47592 | 207190 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5999972.7522599995 | 2094392.56954 | 37.7308009895699 | -122.44241731471399 | (37.7308009895699, -122.442417314714) | ||||
| 51466 | 51466 | 118540 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981337.117190001 | 2112394.76177 | 37.7791500842164 | -122.50817820058701 | (37.7791500842164, -122.508178200587) | ||||
| 52088 | 52088 | 177024 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 11 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6005372.1534 | 2093185.8595 | 37.7277939084451 | -122.42366493918301 | (37.7277939084451, -122.423664939183) | ||||
| 53679 | 53679 | 207188 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5999995.26886 | 2094392.10213 | 37.7308009895535 | -122.442339437931 | (37.7308009895535, -122.442339437931) | ||||
| 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) | |||
| 56500 | 56500 | 177008 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 67 Capistrano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6001385.71309 | 2093783.96595 | 37.7292103388668 | -122.43748892737301 | (37.7292103388668, -122.437488927373) | ||||
| 59113 | 59113 | 207317 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2146 12th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5992616.43475 | 2100823.70057 | 37.748037210643396 | -122.46831674014 | (37.7480372106434, -122.46831674014) | |||
| 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) | |||
| 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) | |||
| 59513 | 59513 | 207233 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 422 Orizaba Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5994045.888719999 | 2089197.1437900001 | 37.7161960040241 | -122.462530559657 | (37.7161960040241, -122.462530559657) | |||
| 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) | |||
| 63132 | 63132 | 207265 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 542 Head St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5993523.314809999 | 2089466.4912400001 | 37.7169054593937 | -122.464356356062 | (37.7169054593937, -122.464356356062) | |||
| 63480 | 63480 | 177019 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 25 Madrid St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6004214.26597 | 2093378.8456299999 | 37.728258376811496 | -122.427681523704 | (37.7282583768115, -122.427681523704) | ||||
| 63586 | 63586 | 207359 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 149 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5999079.1567400005 | 2093759.91373 | 37.729012890930704 | -122.445461131336 | (37.7290128909307, -122.445461131336) | |||
| 67219 | 67219 | 129495 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1136 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 6007480.35855 | 2119354.0245 | 37.7997643702969 | -122.418231335218 | (37.7997643702969, -122.418231335218) | |||
| 67340 | 67340 | 246731 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Ripley St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6008584.453369999 | 2099107.91594 | 37.7442353941634 | -122.41297845991001 | (37.7442353941634, -122.41297845991) | |||
| 68141 | 68141 | 207220 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 143 Judson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5999153.87241 | 2093460.82982 | 37.7281959413875 | -122.445181340549 | (37.7281959413875, -122.445181340549) | ||||
| 68271 | 68271 | 177021 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1538 Burrows St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6006775.37088 | 2092172.2563099999 | 37.72508988269 | -122.41874212587 | (37.72508988269, -122.41874212587) | |||
| 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) | |||
| 68812 | 68812 | 207209 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 342 Edna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5998785.841580001 | 2094004.8345400002 | 37.7296686369961 | -122.446492753553 | (37.7296686369961, -122.446492753553) | |||
| 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) | ||||
| 69462 | 69462 | 119126 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 601 46th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5981603.35382 | 2111608.79109 | 37.777007725640104 | -122.507198870746 | (37.7770077256401, -122.507198870746) | |||
| 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) | |||
| 70085 | 70085 | 207207 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Foerster St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5998074.45641 | 2093829.28565 | 37.7291459626917 | -122.44893943651199 | (37.7291459626917, -122.448939436512) | |||
| 70722 | 70722 | 207218 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 147 Judson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5999123.66307 | 2093458.3174700001 | 37.7281873186821 | -122.445285594449 | (37.7281873186821, -122.445285594449) | ||||
| 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) | ||||
| 72894 | 72894 | 207221 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 125 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5999184.61823 | 2093461.48115 | 37.7281994846941 | -122.44507509826401 | (37.7281994846941, -122.445075098264) | ||||
| 73346 | 73346 | 226593 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4301 26th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6001851.9880099995 | 2100572.11343 | 37.7478755125637 | -122.43636260477301 | (37.7478755125637, -122.436362604773) | |||
| 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) | |||
| 73920 | 73920 | 207210 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 146 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5999095.98576 | 2093806.86087 | 37.7291427575169 | -122.445406326639 | (37.7291427575169, -122.445406326639) | ||||
| 75063 | 75063 | 123520 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2808 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5994672.01997 | 2110241.5879900004 | 37.774014807441795 | -122.461891472498 | (37.7740148074418, -122.461891472498) | |||
| 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) | ||||
| 76282 | 76282 | 226604 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 495 Collingwood St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6002163.6712 | 2103050.21539 | 37.7546974962127 | -122.435462066843 | (37.7546974962127, -122.435462066843) | |||
| 76289 | 76289 | 250091 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1620 Gough St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6005381.25743 | 2115289.65998 | 37.7884862737667 | -122.425205641527 | (37.7884862737667, -122.425205641527) | |||
| 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) | ||||
| 116496 | 116496 | 177009 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 425 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6002141.25462 | 2093891.34658 | 37.729548108055 | -122.434884635528 | (37.729548108055, -122.434884635528) | |||
| 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) | |||
| 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) | |||
| 133848 | 133848 | 207319 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995627.90301 | 2100275.99182 | 37.7467068156796 | -122.45786363851299 | (37.7467068156796, -122.457863638513) | |||
| 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) | |||
| 135933 | 135933 | 176997 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 131 Farragut Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5997268.75573 | 2087384.8014900002 | 37.7114048037631 | -122.451260209013 | (37.7114048037631, -122.451260209013) | |||
| 136022 | 136022 | 118580 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 7900 Geary Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5982502.32297 | 2112445.62468 | 37.7793583322752 | -122.504151113367 | (37.7793583322752, -122.504151113367) | |||
| 136134 | 136134 | 207263 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 582 Ramsell St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5993025.1293 | 2091125.2182900002 | 37.7214311932731 | -122.46619880075899 | (37.7214311932731, -122.466198800759) | |||
| 147909 | 147909 | 226624 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 366 Eureka St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6001461.5255 | 2103604.00302 | 37.75617816071271 | -122.437929936033 | (37.7561781607127, -122.437929936033) | |||
| 147919 | 147919 | 226594 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4301 26th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6001878.86211 | 2100572.13278 | 37.747877092657795 | -122.43626967691799 | (37.7478770926578, -122.436269676918) | |||
| 150333 | 150333 | 207234 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 422 Orizaba Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5994046.18721 | 2089200.86778 | 37.716206246401896 | -122.462529797908 | (37.7162062464019, -122.462529797908) | |||
| 151529 | 151529 | 118577 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 7900 Geary Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5982502.68903 | 2112449.1000200002 | 37.7793678960656 | -122.504150104536 | (37.7793678960656, -122.504150104536) | |||
| 152419 | 152419 | 207191 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999968.7786 | 2094392.65203 | 37.7308009895755 | -122.442431058168 | (37.7308009895755, -122.442431058168) | ||||
| 156575 | 156575 | 118539 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5981337.09939 | 2112389.25007 | 37.7791349496719 | -122.508177852958 | (37.7791349496719, -122.508177852958) | ||||
| 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) | ||||
| 158267 | 158267 | 207227 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 314 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 5994211.43434 | 2092004.54355 | 37.7239139822334 | -122.46216184121799 | (37.7239139822334, -122.462161841218) | |||
| 158363 | 158363 | 207189 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999987.6528199995 | 2094392.26023 | 37.7308009895722 | -122.442365779062 | (37.7308009895722, -122.442365779062) | ||||
| 159577 | 159577 | 226592 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4301 26th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6001848.149780001 | 2100568.16422 | 37.7478644508775 | -122.43637559457198 | (37.7478644508775, -122.436375594572) | |||
| 161558 | 161558 | 123521 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2808 Fulton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5994656.80881 | 2110239.6852599997 | 37.7740087073423 | -122.46194395210199 | (37.7740087073423, -122.461943952102) | |||
| 162033 | 162033 | 129497 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 855 Chestnut St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 6007750.73846 | 2120580.85704 | 37.803148159410604 | -122.417382708871 | (37.8031481594106, -122.417382708871) | |||
| 162483 | 162483 | 207356 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 247 Staples Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5998447.51248 | 2093764.7485200001 | 37.7289900868122 | -122.447645112433 | (37.7289900868122, -122.447645112433) | ||||
| 162797 | 162797 | 207229 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1162 Capitol Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 1ft | 5995089.6840699995 | 2091648.0085099998 | 37.7229855509323 | -122.459100089412 | (37.7229855509323, -122.459100089412) | |||
| 162804 | 162804 | 207261 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 274 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5992740.415519999 | 2089036.58294 | 37.715679875902296 | -122.467031197028 | (37.7156798759023, -122.467031197028) | |||
| 166031 | 166031 | 129493 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 660 Bay St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6007573.98162 | 2121316.69576 | 37.8051586397294 | -122.418046578505 | (37.8051586397294, -122.418046578505) | |||
| 166888 | 166888 | 207141 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1832 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5990964.44749 | 2102904.31775 | 37.7536544876696 | -122.474180983561 | (37.7536544876696, -122.474180983561) | |||
| 168553 | 168553 | 191409 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1201 20th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 6014316.155809999 | 2104772.8809 | 37.760110260198495 | -122.39355571261999 | (37.7601102601985, -122.39355571262) | |||
| 171574 | 171574 | 177017 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 345 Mount Vernon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 5998458.65026 | 2089723.00143 | 37.7178930256111 | -122.447315825681 | (37.7178930256111, -122.447315825681) | |||
| 171748 | 171748 | 207363 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 98 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999482.34141 | 2093540.9124 | 37.7284345728794 | -122.444051566321 | (37.7284345728794, -122.444051566321) | ||||
| 175015 | 175015 | 207318 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5995646.386969999 | 2100270.85159 | 37.746693763801204 | -122.457799351359 | (37.7466937638012, -122.457799351359) | |||
| 177980 | 177980 | 207320 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995605.62076 | 2100279.71012 | 37.746715745033 | -122.45794095682699 | (37.746715745033, -122.457940956827) | |||
| 178122 | 178122 | 207321 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995570.24881 | 2100282.2016 | 37.746720553705 | -122.458063448969 | (37.746720553705, -122.458063448969) | |||
| 179233 | 179233 | 129494 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 14 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6007592.27134 | 2119390.32661 | 37.7998703454969 | -122.417846649312 | (37.7998703454969, -122.417846649312) | ||||
| 182650 | 182650 | 207192 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5999965.474330001 | 2094393.0504400001 | 37.730801895176896 | -122.442442510114 | (37.7308018951769, -122.442442510114) | ||||
| 182658 | 182658 | 129487 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3310 Baker St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5999338.381580001 | 2120194.27566 | 37.8016098133151 | -122.446465960942 | (37.8016098133151, -122.446465960942) | |||
| 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) | |||
| 184301 | 184301 | 207208 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Foerster St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998074.52147 | 2093832.4092700002 | 37.7291545431359 | -122.44893943651199 | (37.7291545431359, -122.448939436512) | |||
| 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) | |||
| 185209 | 185209 | 207231 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 250 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5994770.3606900005 | 2090247.29491 | 37.7191211640843 | -122.46010248996099 | (37.7191211640843, -122.460102489961) | |||
| 185589 | 185589 | 207219 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 147 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999123.85922 | 2093459.79448 | 37.728191385403704 | -122.445285022505 | (37.7281913854037, -122.445285022505) | ||||
| 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) | |||
| 186793 | 186793 | 177018 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 401 Ocean Ave | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 5999065.383280001 | 2091517.8288599998 | 37.722855860592105 | -122.44534760363399 | (37.7228558605921, -122.445347603634) | |||
| 187631 | 187631 | 207235 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 44 Montana St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5996222.23222 | 2089333.72162 | 37.716696107125394 | -122.455017978523 | (37.7166961071254, -122.455017978523) | ||||
| 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) | |||
| 188791 | 188791 | 177020 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 235 Vienna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6004327.3137300005 | 2092022.6110200002 | 37.724540851055 | -122.42719414780599 | (37.724540851055, -122.427194147806) | ||||
| 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) |
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");