Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25933 | 25933 | 207216 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Judson Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 1ft | 5997629.9182 | 2093521.5482700001 | 37.7282755556595 | -122.450454058505 | (37.7282755556595, -122.450454058505) | |||
| 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) | |||
| 28331 | 28331 | 207313 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Ridgewood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996777.96593 | 2094453.90027 | 37.730786773973605 | -122.45346656615101 | (37.7307867739736, -122.453466566151) | |||
| 29934 | 29934 | 129496 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1101 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6007491.98236 | 2119862.03748 | 37.8011599004699 | -122.418227149773 | (37.8011599004699, -122.418227149773) | ||||
| 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) | |||
| 33808 | 33808 | 207309 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 40 Hazelwood Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5996632.84291 | 2093955.22047 | 37.72940919877011 | -122.45393227647699 | (37.7294091987701, -122.453932276477) | |||
| 35444 | 35444 | 31932 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1210 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 7 | Permit Number 35348 | 5981508.8658 | 2106816.8909 | 37.763844998562206 | -122.507170151225 | (37.7638449985622, -122.507170151225) | |
| 42565 | 42565 | 226630 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 17 Temple St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6000001.75416 | 2105889.17936 | 37.7623695721306 | -122.443142420082 | (37.7623695721306, -122.443142420082) | |||
| 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) | |||
| 51460 | 51460 | 226589 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1100 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999827.96585 | 2100023.61803 | 37.7462542624189 | -122.443322166684 | (37.7462542624189, -122.443322166684) | |||
| 52623 | 52623 | 40627 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1118 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1999 12:00:00 AM | 7 | Permit Number 41628 | 6012181.11201 | 2103196.50544 | 37.755663016446 | -122.40082910469 | (37.755663016446, -122.40082910469) | ||
| 53847 | 53847 | 207299 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 111 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996293.5704 | 2094296.85345 | 37.7303277824929 | -122.455129844261 | (37.7303277824929, -122.455129844261) | |||
| 59665 | 59665 | 226580 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 110 Carmel St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5998192.72104 | 2105385.2518599997 | 37.7608825979841 | -122.44936285530599 | (37.7608825979841, -122.449362855306) | |||
| 59888 | 59888 | 177028 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 164 Baltimore Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6002357.56159 | 2086195.5289200002 | 37.7084293823926 | -122.433587065817 | (37.7084293823926, -122.433587065817) | |||
| 60300 | 60300 | 182865 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1845 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5989054.8495 | 2102750.5341 | 37.75312143070521 | -122.480773464165 | (37.7531214307052, -122.480773464165) | |||
| 61063 | 61063 | 207293 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 965 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994659.04342 | 2093888.37752 | 37.729112296585996 | -122.460750997386 | (37.729112296586, -122.460750997386) | |||
| 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) | |||
| 67927 | 67927 | 41944 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 567 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 7 | Permit Number 42302 | 5993743.34162 | 2111650.50193 | 37.7778298007164 | -122.465206260397 | (37.7778298007164, -122.465206260397) | |
| 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) | ||||
| 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) | |||
| 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) | |||
| 70286 | 70286 | 42982 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 469 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 7 | Permit Number 42866 | 6008125.46012 | 2091747.89633 | 37.724000603132 | -122.414044988394 | (37.724000603132, -122.414044988394) | |
| 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) | ||||
| 71287 | 71287 | 207201 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5998416.44412 | 2094074.8160299999 | 37.7298396835571 | -122.447774830644 | (37.7298396835571, -122.447774830644) | |||
| 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) | |||
| 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) | |||
| 76065 | 76065 | 207186 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 50 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000874.80167 | 2094365.21675 | 37.730777259156 | -122.43929683358299 | (37.730777259156, -122.439296833583) | |||
| 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) | ||||
| 80194 | 80194 | 4999 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 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) | |||
| 130406 | 130406 | 207187 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 50 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000857.41139 | 2094366.50638 | 37.730779810542295 | -122.439357046798 | (37.7307798105423, -122.439357046798) | |||
| 131950 | 131950 | 71605 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 178 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994512.31694 | 2086511.3564 | 37.7088483153534 | -122.46072384594 | (37.7088483153534, -122.46072384594) | ||
| 133371 | 133371 | 207206 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 249 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 1ft | 5997427.94217 | 2094345.17262 | 37.730525470566896 | -122.451211668094 | (37.7305254705669, -122.451211668094) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 154328 | 154328 | 35122 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 723 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 7 | Permit Number 38657 | 6001912.16427 | 2089726.3543900002 | 37.7180989685677 | -122.435378807601 | (37.7180989685677, -122.435378807601) | |
| 155074 | 155074 | 207225 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 272 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996551.89898 | 2091549.3096 | 37.7227984982343 | -122.454038414459 | (37.7227984982343, -122.454038414459) | |||
| 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) | |||
| 163785 | 163785 | 207274 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 315 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993100.15501 | 2099667.06703 | 37.7448893164068 | -122.466560010732 | (37.7448893164068, -122.466560010732) | |||
| 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) | |||
| 168579 | 168579 | 43185 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 62 Valmar Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 7 | Permit Number 42987 | 6005330.72095 | 2092724.62519 | 37.7265251215375 | -122.42377539032101 | (37.7265251215375, -122.423775390321) | |
| 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) | |||
| 176378 | 176378 | 207194 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 312 Hearst Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999314.16696 | 2094391.4042099998 | 37.73076022959339 | -122.44469405728901 | (37.7307602295934, -122.444694057289) | |||
| 178299 | 178299 | 207249 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 581 Arch St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992725.89958 | 2091026.00542 | 37.7211415099655 | -122.467225936253 | (37.7211415099655, -122.467225936253) | |||
| 180537 | 180537 | 226627 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 310 Liberty St | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6004024.53424 | 2103933.71517 | 37.7572288881251 | -122.42908968844401 | (37.7572288881251, -122.429089688444) | |||
| 183896 | 183896 | 226577 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 370 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6003494.445309999 | 2099538.93677 | 37.745131838370206 | -122.43060935295601 | (37.7451318383702, -122.430609352956) | |||
| 184253 | 184253 | 207297 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 217 Colon Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5996046.36344 | 2094274.51279 | 37.730252254734104 | -122.455982853036 | (37.7302522547341, -122.455982853036) | |||
| 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) | |||
| 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) | |||
| 186952 | 186952 | 207258 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 532 Arch St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992753.93277 | 2090721.89417 | 37.7203081126976 | -122.46710693523998 | (37.7203081126976, -122.46710693524) | |||
| 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) | ||||
| 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) |
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");