Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4863 | 4863 | 253702 | Undocumented 2 | Tree(s) :: 17 | 293 Capp St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007203.0 | 2105623.0 | 37.76204668432629 | -122.41821705685899 | (37.7620466843263, -122.418217056859) | ||||
| 4871 | 4871 | 253700 | Undocumented 2 | Tree(s) :: 17 | 293 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007203.0 | 2105623.0 | 37.76204668432629 | -122.41821705685899 | (37.7620466843263, -122.418217056859) | ||||
| 4865 | 4865 | 253699 | Undocumented 2 | Tree(s) :: 17 | 3076 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000057.0 | 2105400.0 | 37.761029556529294 | -122.44291621566002 | (37.7610295565293, -122.44291621566) | ||||
| 4870 | 4870 | 253696 | Undocumented 2 | Tree(s) :: 17 | 235 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6003605.0 | 2109124.0 | 37.77145640087421 | -122.430911009882 | (37.7714564008742, -122.430911009882) | ||||
| 4719 | 4719 | 253672 | DPW Maintained 3 | Tree(s) :: 17 | 390 06th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 4002 | 4002 | 253607 | Undocumented 2 | Tree(s) :: 17 | 499x Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010464.0 | 2112150.0 | 37.7801513385768 | -122.407398630227 | (37.7801513385768, -122.407398630227) | ||||
| 4089 | 4089 | 253606 | Undocumented 2 | Tree(s) :: 17 | 499x Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010464.0 | 2112150.0 | 37.7801513385768 | -122.407398630227 | (37.7801513385768, -122.407398630227) | ||||
| 3965 | 3965 | 253596 | Permitted Site 1 | Tree(s) :: 17 | 198X Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780230 | ||||||
| 4771 | 4771 | 253556 | Permitted Site 1 | Tree(s) :: 17 | 27 Ceres St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:00:00 AM | 3 | Permit Number 780682 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | |
| 3649 | 3649 | 253514 | Permitted Site 1 | Tree(s) :: 17 | 128 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2007 12:00:00 AM | Permit No. 49290 | 5994510.638119999 | 2105337.44986 | 37.760540036372205 | -122.46209399567199 | (37.7605400363722, -122.462093995672) | |||
| 3699 | 3699 | 253406 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3692 | 3692 | 253403 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3697 | 3697 | 253402 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3686 | 3686 | 253401 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3690 | 3690 | 253398 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3703 | 3703 | 253397 | Undocumented 2 | Tree(s) :: 17 | 400x Newhall St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6016185.0 | 2098125.0 | 37.741960230665995 | -122.38662864108801 | (37.741960230666, -122.386628641088) | |
| 3696 | 3696 | 253396 | Undocumented 2 | Tree(s) :: 17 | 400x Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6016185.0 | 2098125.0 | 37.741960230665995 | -122.38662864108801 | (37.741960230666, -122.386628641088) | |
| 3198 | 3198 | 253367 | Permitted Site 1 | Tree(s) :: 17 | 600 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1999 12:00:00 AM | Permit Number 23367 | 6010620.1417 | 2118945.4017 | 37.798818623722 | -122.40733765055599 | (37.798818623722, -122.407337650556) | |||
| 3048 | 3048 | 253287 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 1237 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780510 | 6016839.12241 | 2092718.7941400001 | 37.727152059320204 | -122.383990506478 | (37.7271520593202, -122.383990506478) | |
| 3879 | 3879 | 253286 | Significant Tree 6 | Tree(s) :: 17 | 40 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2017 12:00:00 AM | 3 | 6x10 | Permit Number 780599 | 5993445.0 | 2101187.0 | 37.7490825597194 | -122.465478005037 | (37.7490825597194, -122.465478005037) | |
| 2816 | 2816 | 253217 | Permitted Site 1 | Tree(s) :: 17 | 301 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2017 12:00:00 AM | 3 | 3x3 | 6001651.75029 | 2086494.56012 | 37.7092103839364 | -122.436047813177 | (37.7092103839364, -122.436047813177) | ||
| 5154 | 5154 | 253212 | Permitted Site 1 | Tree(s) :: 17 | 15 Liberty St | 2 | Side Yard : Cutout 18 | tree 3 | Private 1 | 11/08/2017 12:00:00 AM | 3 | 5x5 | Permit Number 780777 | 6006173.0 | 2104008.0 | 37.75755424109929 | -122.421664722498 | (37.7575542410993, -122.421664722498) | |
| 2687 | 2687 | 253164 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 146 Cambridge St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/27/2017 12:00:00 AM | 3 | 4x4 | 6006598.94029 | 2094006.4119099998 | 37.7301161400075 | -122.419482094225 | (37.7301161400075, -122.419482094225) | ||
| 2583 | 2583 | 253127 | Permitted Site 1 | Tree(s) :: 17 | 1639 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780367 | 5982187.14146 | 2103946.19954 | 37.7560028231362 | -122.50461153424999 | (37.7560028231362, -122.50461153425) | |
| 2571 | 2571 | 253124 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 399x Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780530 | ||||||
| 2050 | 2050 | 252861 | DPW Maintained 3 | Tree(s) :: 17 | 988 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779759 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | |
| 2497 | 2497 | 252857 | Undocumented 2 | Tree(s) :: 17 | 124 Persia Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 780172 | 6002102.0 | 2091308.0 | 37.7224525933916 | -122.43483567372 | (37.7224525933916, -122.43483567372) | |||
| 2006 | 2006 | 252850 | Undocumented 2 | Tree(s) :: 17 | 2 Hernandez Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5996271.0 | 2100083.0 | 37.7462138338134 | -122.45562593978599 | (37.7462138338134, -122.455625939786) | ||||
| 1972 | 1972 | 252849 | Undocumented 2 | Tree(s) :: 17 | 200 Woodside Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5996376.0 | 2100052.0 | 37.7461347404292 | -122.455260624993 | (37.7461347404292, -122.455260624993) | ||||
| 1934 | 1934 | 252840 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 80 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997842.0 | 2113206.0 | 37.782336294689 | -122.45113984781099 | (37.782336294689, -122.451139847811) | ||||
| 1691 | 1691 | 251656 | Undocumented 2 | Tree(s) :: 17 | 31x Malta Dr | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 3x3 | 5999423.0 | 2096089.0 | 37.7354276387403 | -122.44443976141001 | (37.7354276387403, -122.44443976141) | ||||
| 2479 | 2479 | 251647 | Permitted Site 1 | Tree(s) :: 17 | 690 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780215 | 6007452.0 | 2105652.0 | 37.7621403241605 | -122.417357915219 | (37.7621403241605, -122.417357915219) | |
| 1659 | 1659 | 251643 | Undocumented 2 | Tree(s) :: 17 | 2701 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6007328.0 | 2121670.0 | 37.8061148757045 | -122.418922903139 | (37.8061148757045, -122.418922903139) | |||
| 3399 | 3399 | 251598 | Undocumented 2 | Tree(s) :: 17 | 900x Moraga St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 09/06/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780206 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | |
| 1483 | 1483 | 251556 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1486 | 1486 | 251555 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1501 | 1501 | 251554 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1510 | 1510 | 251552 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1865 | 1865 | 251511 | Undocumented 2 | Tree(s) :: 17 | 498X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780030 | 6013725.0 | 2112487.0 | 37.7812586433919 | -122.396140887502 | (37.7812586433919, -122.396140887502) | |
| 1860 | 1860 | 251510 | Undocumented 2 | Tree(s) :: 17 | 498X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780030 | 6013725.0 | 2112487.0 | 37.7812586433919 | -122.396140887502 | (37.7812586433919, -122.396140887502) | |
| 1305 | 1305 | 251497 | Undocumented 2 | Tree(s) :: 17 | 329x Warren Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5994610.0 | 2103362.0 | 37.7551216790189 | -122.461607123764 | (37.7551216790189, -122.461607123764) | ||||
| 2180 | 2180 | 251495 | Significant Tree 6 | Tree(s) :: 17 | 2448 Clay St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 10x10 | Permit Number 780000 | 6003026.0 | 2116224.0 | 37.7909183964794 | -122.433421252488 | (37.7909183964794, -122.433421252488) | |
| 2105 | 2105 | 251411 | Significant Tree 6 | Tree(s) :: 17 | 2751 Buchanan St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 06/21/2017 12:00:00 AM | 3 | 6x6 | Permit Number 779887 | 6003497.0 | 2117826.0 | 37.7953437887296 | -122.431906052505 | (37.7953437887296, -122.431906052505) | |
| 597 | 597 | 251329 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | ||
| 588 | 588 | 251328 | Undocumented 2 | Tree(s) :: 17 | 95x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | |||
| 610 | 610 | 251327 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | ||
| 427 | 427 | 251307 | Undocumented 2 | Tree(s) :: 17 | 200 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6016315.0 | 2096328.0 | 37.7370332293639 | -122.38605389871 | (37.7370332293639, -122.38605389871) | ||||
| 245 | 245 | 251255 | Undocumented 2 | Tree(s) :: 17 | 4089x Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991686.0 | 2086822.0 | 37.7095382490701 | -122.47051450746099 | (37.7095382490701, -122.470514507461) | ||||
| 169 | 169 | 251221 | Permitted Site 1 | Tree(s) :: 17 | 2401X Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778039 | ||||||
| 89 | 89 | 251189 | Permitted Site 1 | Tree(s) :: 17 | 1493 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | 3x3 | 6016267.45517 | 2096986.6643299998 | 37.7388391569445 | -122.38626419104999 | (37.7388391569445, -122.38626419105) | ||
| 24522 | 24522 | 251177 | Undocumented 2 | Tree(s) :: 17 | 178 Bluxome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6012557.0 | 2110038.0 | 37.7744691941496 | -122.400009583897 | (37.7744691941496, -122.400009583897) | ||||
| 22866 | 22866 | 251139 | Significant Tree 6 | Tree(s) :: 17 | 621X Gough St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 03/10/2017 12:00:00 AM | 3 | Permit Number 779685 | |||||||
| 22827 | 22827 | 251129 | Undocumented 2 | Tree(s) :: 17 | 32 Cross St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2017 12:00:00 AM | 3 | 12x2 | 6000049.0 | 2088229.0 | 37.7138815826944 | -122.441711543213 | (37.7138815826944, -122.441711543213) | ||
| 158746 | 158746 | 251040 | Undocumented 2 | Tree(s) :: 17 | 5455 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990029.1728 | 2112611.0353 | 37.780252275913206 | -122.478124966747 | (37.7802522759132, -122.478124966747) | |||
| 1334 | 1334 | 250499 | Undocumented 2 | Tree(s) :: 17 | 540 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 05/10/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779924 | 5986884.24135 | 2115388.89729 | 37.7876964378791 | -122.489208879795 | (37.7876964378791, -122.489208879795) | |
| 37693 | 37693 | 248557 | Undocumented 2 | Tree(s) :: 17 | 137 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997345.4456 | 2107752.4938 | 37.7673339403594 | -122.452464026369 | (37.7673339403594, -122.452464026369) | |||
| 152654 | 152654 | 248542 | Undocumented 2 | Tree(s) :: 17 | 258 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998812.5011 | 2107653.6201 | 37.7671464005807 | -122.44738259118 | (37.7671464005807, -122.44738259118) | |||
| 25896 | 25896 | 248494 | Undocumented 2 | Tree(s) :: 17 | 757 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5997598.3079 | 2107875.2909999997 | 37.7676855940341 | -122.45159827426501 | (37.7676855940341, -122.451598274265) | |||
| 72753 | 72753 | 248464 | Undocumented 2 | Tree(s) :: 17 | 780 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997153.4520000005 | 2107886.4957 | 37.7676908735162 | -122.45313777620501 | (37.7676908735162, -122.453137776205) | |||
| 23938 | 23938 | 248425 | Undocumented 2 | Tree(s) :: 17 | 731 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998544.0431 | 2108064.7106 | 37.7682598065536 | -122.448340749888 | (37.7682598065536, -122.448340749888) | |||
| 188881 | 188881 | 248375 | Undocumented 2 | Tree(s) :: 17 | 1605 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997870.7026 | 2108171.6093 | 37.7685148040368 | -122.45067746589199 | (37.7685148040368, -122.450677465892) | |||
| 170604 | 170604 | 248347 | Undocumented 2 | Tree(s) :: 17 | 721 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999017.0621 | 2108165.2499 | 37.7685628940185 | -122.446711864634 | (37.7685628940185, -122.446711864634) | |||
| 25334 | 25334 | 248306 | Undocumented 2 | Tree(s) :: 17 | 2445 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009304.6458 | 2106837.3362 | 37.7654990466844 | -122.411034024362 | (37.7654990466844, -122.411034024362) | |||
| 162290 | 162290 | 248305 | Undocumented 2 | Tree(s) :: 17 | 2445 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009252.3493 | 2106835.4345 | 37.7654908922731 | -122.41121477248501 | (37.7654908922731, -122.411214772485) | |||
| 159012 | 159012 | 247342 | Undocumented 2 | Tree(s) :: 17 | 415 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998861.9742 | 2109259.5681 | 37.771558753373604 | -122.447327071467 | (37.7715587533736, -122.447327071467) | |||
| 153000 | 153000 | 247341 | Undocumented 2 | Tree(s) :: 17 | 403 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998858.5562 | 2109285.2031 | 37.771628945240394 | -122.44734073985799 | (37.7716289452404, -122.447340739858) | |||
| 1734 | 1734 | 247340 | Permitted Site 1 | Tree(s) :: 17 | 307 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779988 | 6003225.5695 | 2109437.2242 | 37.7722949315945 | -122.43224585173401 | (37.7722949315945, -122.432245851734) | |
| 53653 | 53653 | 247275 | Undocumented 2 | Tree(s) :: 17 | 1665 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999077.5213 | 2109368.3030000003 | 37.771869626177896 | -122.44658930936701 | (37.7718696261779, -122.446589309367) | |||
| 3853 | 3853 | 246912 | Undocumented 2 | Tree(s) :: 17 | 457 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780340 | 5997564.78588 | 2107435.89495 | 37.7664772048727 | -122.451682522529 | (37.7664772048727, -122.451682522529) | |
| 46710 | 46710 | 246411 | Undocumented 2 | Tree(s) :: 17 | 22 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998217.2905 | 2108458.9941 | 37.769323722170796 | -122.449499363561 | (37.7693237221708, -122.449499363561) | |||
| 33644 | 33644 | 246232 | Undocumented 2 | Tree(s) :: 17 | 110 Frederick St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999396.2041 | 2107735.5354 | 37.767404657023505 | -122.445369547591 | (37.7674046570235, -122.445369547591) | |||
| 175806 | 175806 | 246166 | Undocumented 2 | Tree(s) :: 17 | 699 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997552.2779 | 2108203.1035 | 37.7685830471749 | -122.45178113630199 | (37.7685830471749, -122.451781136302) | |||
| 168268 | 168268 | 246139 | Undocumented 2 | Tree(s) :: 17 | 636 Shrader St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5997577.8669 | 2108330.4431 | 37.7689341546251 | -122.45170181346 | (37.7689341546251, -122.45170181346) | |||
| 139870 | 139870 | 246065 | Undocumented 2 | Tree(s) :: 17 | 30 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998222.7414 | 2108415.9924 | 37.7692059622877 | -122.449477410381 | (37.7692059622877, -122.449477410381) | |||
| 133439 | 133439 | 245890 | Undocumented 2 | Tree(s) :: 17 | 1003 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6001676.2626 | 2109393.2478 | 37.7720862166392 | -122.43760188398599 | (37.7720862166392, -122.437601883986) | |||
| 2482 | 2482 | 245639 | Undocumented 2 | Tree(s) :: 17 | 910 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007964.74692 | 2102552.0898 | 37.7536575156842 | -122.415365052856 | (37.7536575156842, -122.415365052856) | |||
| 168871 | 168871 | 245449 | Undocumented 2 | Tree(s) :: 17 | 2798 16th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008185.848999999 | 2106828.0579 | 37.7654107681137 | -122.414903044666 | (37.7654107681137, -122.414903044666) | |||
| 46488 | 46488 | 245431 | Undocumented 2 | Tree(s) :: 17 | 2400 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009345.194 | 2106891.7791 | 37.765650808121 | -122.410897622285 | (37.765650808121, -122.410897622285) | |||
| 72680 | 72680 | 245430 | Undocumented 2 | Tree(s) :: 17 | 2400 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009369.9216 | 2106893.6812 | 37.7656574173752 | -122.410812228941 | (37.7656574173752, -122.410812228941) | |||
| 176167 | 176167 | 245429 | Undocumented 2 | Tree(s) :: 17 | 2400 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009412.7194 | 2106896.5344 | 37.7656676512165 | -122.41066440163 | (37.7656676512165, -122.41066440163) | |||
| 174418 | 174418 | 245423 | Undocumented 2 | Tree(s) :: 17 | 2440 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009278.6196 | 2106887.9748 | 37.7656366291234 | -122.411127620702 | (37.7656366291234, -122.411127620702) | |||
| 163496 | 163496 | 245422 | Undocumented 2 | Tree(s) :: 17 | 2440 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6009304.2983 | 2106887.9748 | 37.76563806915021 | -122.41103880337299 | (37.7656380691502, -122.411038803373) | |||
| 74808 | 74808 | 245381 | Undocumented 2 | Tree(s) :: 17 | 3450 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005782.5786 | 2098187.8175 | 37.741551332022 | -122.42260138200301 | (37.741551332022, -122.422601382003) | |||
| 59267 | 59267 | 245110 | Undocumented 2 | Tree(s) :: 17 | 135 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 6000770.1938 | 2109453.5749 | 37.772200302029205 | -122.44074036886002 | (37.7722003020292, -122.44074036886) | |||
| 67702 | 67702 | 245047 | Undocumented 2 | Tree(s) :: 17 | 1034 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001580.3709 | 2109426.6521 | 37.7721724839727 | -122.43793597352101 | (37.7721724839727, -122.437935973521) | |||
| 63475 | 63475 | 244957 | Undocumented 2 | Tree(s) :: 17 | 291 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005191.7976 | 2109882.6208 | 37.7736291707374 | -122.425476189168 | (37.7736291707374, -122.425476189168) | |||
| 161000 | 161000 | 244932 | Undocumented 2 | Tree(s) :: 17 | 276 Page St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 6005259.2596 | 2109945.2207 | 37.7738048663185 | -122.425247283021 | (37.7738048663185, -122.425247283021) | |||
| 55125 | 55125 | 244874 | Undocumented 2 | Tree(s) :: 17 | 1303 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000283.9747 | 2109200.4937 | 37.7714777032527 | -122.442404064945 | (37.7714777032527, -122.442404064945) | |||
| 49727 | 49727 | 244223 | Undocumented 2 | Tree(s) :: 17 | 1830 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997801.2012 | 2108901.6698 | 37.7705153847611 | -122.45097051473302 | (37.7705153847611, -122.450970514733) | |||
| 27 | 27 | 244214 | Private 5 | Tree(s) :: 17 | 342 Scott St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/20/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779666 | 6002262.2202 | 2109717.5413 | 37.7730099442883 | -122.43559821674499 | (37.7730099442883, -122.435598216745) | |
| 167295 | 167295 | 244211 | Undocumented 2 | Tree(s) :: 17 | 787 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002859.2926 | 2109561.26 | 37.7726147287694 | -122.43352170101002 | (37.7726147287694, -122.43352170101) | |||
| 64519 | 64519 | 244206 | Undocumented 2 | Tree(s) :: 17 | 6146 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003482.0997 | 2109688.9395 | 37.77300062178271 | -122.43137646296199 | (37.7730006217827, -122.431376462962) | |||
| 74268 | 74268 | 244204 | Undocumented 2 | Tree(s) :: 17 | 610 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003538.4887 | 2109697.3737 | 37.7730269756515 | -122.43118200869101 | (37.7730269756515, -122.431182008691) | |||
| 174527 | 174527 | 244196 | Undocumented 2 | Tree(s) :: 17 | 508 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998471.7891 | 2108892.6681 | 37.7705290359785 | -122.448650307908 | (37.7705290359785, -122.448650307908) | |||
| 48260 | 48260 | 244096 | Undocumented 2 | Tree(s) :: 17 | 416 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997487.1651 | 2108993.3495 | 37.7707491304172 | -122.452063378018 | (37.7707491304172, -122.452063378018) | |||
| 75944 | 75944 | 242822 | Undocumented 2 | Tree(s) :: 17 | 18 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 46 | Width 5ft | 6002178.85689 | 2096424.55585 | 37.7365058551638 | -122.434935735002 | (37.7365058551638, -122.434935735002) | |||
| 174189 | 174189 | 242821 | Undocumented 2 | Tree(s) :: 17 | 18 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 37 | Width 5ft | 6002176.86514 | 2096431.6975599998 | 37.7365253515621 | -122.43494313191499 | (37.7365253515621, -122.434943131915) | |||
| 50449 | 50449 | 242820 | Undocumented 2 | Tree(s) :: 17 | 37 Poppy Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 2ft | 6002456.61791 | 2096763.3951400002 | 37.7374519967974 | -122.4339996118 | (37.7374519967974, -122.4339996118) | |||
| 179312 | 179312 | 242819 | Undocumented 2 | Tree(s) :: 17 | 173 Addison St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002620.3556 | 2097408.25534 | 37.7392319251012 | -122.43347956444299 | (37.7392319251012, -122.433479564443) | |||
| 5130 | 5130 | 240879 | Permitted Site 1 | Tree(s) :: 17 | 3659 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780848 | 6005174.01235 | 2105435.79092 | 37.7614182359708 | -122.42522122409201 | (37.7614182359708, -122.425221224092) |
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");