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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80666 | 80666 | 85452 | Section 143 8 | Tree(s) :: 17 | 275 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006138.0 | 2107427.0 | 37.7669400383946 | -122.422028645748 | (37.7669400383946, -122.422028645748) | |
| 81723 | 81723 | 85457 | Section 143 8 | Tree(s) :: 17 | 265 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006135.0 | 2107486.0 | 37.7671018691982 | -122.42204321408998 | (37.7671018691982, -122.42204321409) | |
| 86995 | 86995 | 85449 | Section 143 8 | Tree(s) :: 17 | 287 GUERRERO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6005798.0 | 2107491.2 | 37.7670971345308 | -122.42320921716801 | (37.7670971345308, -122.423209217168) | |
| 88908 | 88908 | 107533 | Section 143 8 | Tree(s) :: 17 | 130 MATEO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774373 | 6003821.3 | 2096389.2 | 37.7365018950939 | -122.429254591879 | (37.7365018950939, -122.429254591879) | |
| 94493 | 94493 | 110787 | Section 143 8 | Tree(s) :: 17 | 850x SANCHEZ ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777427 | 6003717.0 | 2103349.0 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | |
| 95747 | 95747 | 85451 | Section 143 8 | Tree(s) :: 17 | 281 GUERRERO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6005518.5 | 2107341.2 | 37.7666694929162 | -122.424165297356 | (37.7666694929162, -122.424165297356) | |
| 97717 | 97717 | 85456 | Section 143 8 | Tree(s) :: 17 | 265 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006135.0 | 2107486.0 | 37.7671018691982 | -122.42204321408998 | (37.7671018691982, -122.42204321409) | |
| 101156 | 101156 | 111313 | Section 143 8 | Tree(s) :: 17 | 3400x Wawona St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.6213900002 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | ||
| 105420 | 105420 | 85455 | Section 143 8 | Tree(s) :: 17 | 265 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006135.0 | 2107486.0 | 37.7671018691982 | -122.42204321408998 | (37.7671018691982, -122.42204321409) | |
| 106507 | 106507 | 85450 | Section 143 8 | Tree(s) :: 17 | 285 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006141.0 | 2107369.0 | 37.7667809533476 | -122.42201414851601 | (37.7667809533476, -122.422014148516) | |
| 107223 | 107223 | 85454 | Section 143 8 | Tree(s) :: 17 | 269 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006135.0 | 2107486.0 | 37.7671018691982 | -122.42204321408998 | (37.7671018691982, -122.42204321409) | |
| 108448 | 108448 | 85460 | Section 143 8 | Tree(s) :: 17 | 245x Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006128.0 | 2107603.0 | 37.7674227286224 | -122.422075738783 | (37.7674227286224, -122.422075738783) | |
| 111923 | 111923 | 85461 | Section 143 8 | Tree(s) :: 17 | 245x Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006128.0 | 2107603.0 | 37.7674227286224 | -122.422075738783 | (37.7674227286224, -122.422075738783) | |
| 112158 | 112158 | 111315 | Section 143 8 | Tree(s) :: 17 | 3400x Wawona St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.6213900002 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | ||
| 113824 | 113824 | 111316 | Section 143 8 | Tree(s) :: 17 | 3400x Wawona St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.6213900002 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | ||
| 114269 | 114269 | 111632 | Section 143 8 | Tree(s) :: 17 | 1758 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774682 | 5985071.0 | 2103231.6 | 37.7542099449347 | -122.49458566251002 | (37.7542099449347, -122.49458566251) | |
| 116308 | 116308 | 85459 | Section 143 8 | Tree(s) :: 17 | 245x Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006128.0 | 2107603.0 | 37.7674227286224 | -122.422075738783 | (37.7674227286224, -122.422075738783) | |
| 117182 | 117182 | 111314 | Section 143 8 | Tree(s) :: 17 | 3400x Wawona St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.6213900002 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | ||
| 126492 | 126492 | 85458 | Section 143 8 | Tree(s) :: 17 | 265 Guerrero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006135.0 | 2107486.0 | 37.7671018691982 | -122.42204321408998 | (37.7671018691982, -122.42204321409) | |
| 140578 | 140578 | 85453 | Section 143 8 | Tree(s) :: 17 | 271 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006135.0 | 2107486.0 | 37.7671018691982 | -122.42204321408998 | (37.7671018691982, -122.42204321409) | |
| 142954 | 142954 | 110788 | Section 143 8 | Tree(s) :: 17 | 850x SANCHEZ ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777427 | 6003717.0 | 2103349.0 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | |
| 77987 | 77987 | 100070 | Property Tree 7 | Tree(s) :: 17 | 331 Serrano Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 777990 | 5990400.0 | 2090718.0 | 37.7201612636948 | -122.47524333880699 | (37.7201612636948, -122.475243338807) | ||||
| 80672 | 80672 | 98502 | Property Tree 7 | Tree(s) :: 17 | 244 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999066.0 | 2100737.0 | 37.7481695560511 | -122.44600824337601 | (37.7481695560511, -122.446008243376) | ||||||
| 82720 | 82720 | 98465 | Property Tree 7 | Tree(s) :: 17 | 190 Portola Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999550.3 | 2100620.3 | 37.7478767693988 | -122.444325170302 | (37.7478767693988, -122.444325170302) | ||||||
| 89166 | 89166 | 102275 | Property Tree 7 | Tree(s) :: 17 | 267 Topaz Way | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6001225.6 | 2097744.2 | 37.740075118911705 | -122.438326054857 | (37.7400751189117, -122.438326054857) | ||||||
| 90103 | 90103 | 100046 | Property Tree 7 | Tree(s) :: 17 | 562 28th St | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/28/2012 12:00:00 AM | 17 | Permit Number 769057 | 6002262.0 | 2099459.0 | 37.7448424535299 | -122.43486521318898 | (37.7448424535299, -122.434865213189) | |||
| 91108 | 91108 | 97177 | Property Tree 7 | Tree(s) :: 17 | 257 Roosevelt Way | Back Yard : Yard 13 | Tree 1 | Private 1 | Monterey cypress tree in backyard on private property; not a Significant tree | 6000848.1 | 2107127.9 | 37.765819014897296 | -122.44030407045099 | (37.7658190148973, -122.440304070451) | |||||
| 92938 | 92938 | 99277 | Property Tree 7 | Tree(s) :: 17 | 85X 10th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517.0 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | |||
| 94734 | 94734 | 98893 | Property Tree 7 | Tree(s) :: 17 | 216 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998910.0 | 2100761.0 | 37.7482265448319 | -122.44654941060699 | (37.7482265448319, -122.446549410607) | ||||||
| 97530 | 97530 | 99275 | Property Tree 7 | Tree(s) :: 17 | 85X 10th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517.0 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | |||
| 98291 | 98291 | 98892 | Property Tree 7 | Tree(s) :: 17 | 220 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998935.0 | 2100753.0 | 37.7482060067302 | -122.44646238623999 | (37.7482060067302, -122.44646238624) | ||||||
| 98786 | 98786 | 100139 | Property Tree 7 | Tree(s) :: 17 | 155 05th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769024 | 6011029.6 | 2112857.4 | 37.782125333955705 | -122.40549178692301 | (37.7821253339557, -122.405491786923) | ||||
| 99802 | 99802 | 98890 | Property Tree 7 | Tree(s) :: 17 | 256 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999134.0 | 2100748.0 | 37.748203642185395 | -122.44577389345 | (37.7482036421854, -122.44577389345) | ||||||
| 100224 | 100224 | 91109 | Property Tree 7 | Tree(s) :: 17 | 2650 Turk Blvd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | On campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 103103 | 103103 | 91108 | Property Tree 7 | Tree(s) :: 17 | 2650 Turk Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | On campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 103600 | 103600 | 98436 | Property Tree 7 | Tree(s) :: 17 | 238 Glenview Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999035.0 | 2100736.0 | 37.7481650400364 | -122.446115368035 | (37.7481650400364, -122.446115368035) | ||||||
| 108324 | 108324 | 105353 | Property Tree 7 | Tree(s) :: 17 | 1979 SAN JOSE AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/16/2014 12:00:00 AM | 27 | Permit Number 772405 | 5999886.5 | 2092393.4 | 37.7253068164695 | -122.442572018552 | (37.7253068164695, -122.442572018552) | ||
| 112498 | 112498 | 106458 | Property Tree 7 | Tree(s) :: 17 | 71 HANCOCK ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003861.6 | 2105050.0 | 37.7602847161222 | -122.429732794413 | (37.7602847161222, -122.429732794413) | ||||||
| 113071 | 113071 | 108574 | Property Tree 7 | Tree(s) :: 17 | 1891 15th St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7x8 | 6004884.86016 | 2107160.4412599998 | 37.7661373754728 | -122.426344078904 | (37.7661373754728, -122.426344078904) | ||||
| 115357 | 115357 | 98501 | Property Tree 7 | Tree(s) :: 17 | 232 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998998.0 | 2100740.0 | 37.748173910048706 | -122.446243600021 | (37.7481739100487, -122.446243600021) | ||||||
| 120804 | 120804 | 96938 | Property Tree 7 | Tree(s) :: 17 | 1306 Cole St | Back Yard : Yard 13 | Tree 1 | Private 1 | Backyard tree on private property | 5998246.0 | 2105961.0 | 37.7624665052811 | -122.449220068104 | (37.7624665052811, -122.449220068104) | |||||
| 125343 | 125343 | 99276 | Property Tree 7 | Tree(s) :: 17 | 85X 10th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517.0 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | |||
| 125346 | 125346 | 100148 | Property Tree 7 | Tree(s) :: 17 | 209 Vicksburg St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004141.0 | 2102142.0 | 37.7523158521071 | -122.428559192815 | (37.7523158521071, -122.428559192815) | ||||||
| 126465 | 126465 | 101951 | Property Tree 7 | Tree(s) :: 17 | 21 Lyell St | unknown : Yard 19 | Tree 1 | Private 1 | 6003106.0 | 2094969.0 | 37.7325618289587 | -122.43162632292 | (37.7325618289587, -122.43162632292) | ||||||
| 129004 | 129004 | 108871 | Property Tree 7 | Tree(s) :: 17 | 99x OAKWOOD ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6005305.0 | 2104962.0 | 37.760124716943295 | -122.424734485609 | (37.7601247169433, -122.424734485609) | |||||
| 129310 | 129310 | 99268 | Property Tree 7 | Tree(s) :: 17 | 292 Whitney St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6004280.0 | 2096681.0 | 37.7373290690714 | -122.42768945491501 | (37.7373290690714, -122.427689454915) | ||||||
| 145716 | 145716 | 98878 | Property Tree 7 | Tree(s) :: 17 | 11 Panorama Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998029.0 | 2100213.0 | 37.7466715093679 | -122.449556386849 | (37.7466715093679, -122.449556386849) | ||||||
| 563 | 563 | 173951 | Significant Tree 6 | Tree(s) :: 17 | 2646 Union St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/11/2017 12:00:00 AM | 3 | 10x10 | Permit Number 779549 | 6000338.0 | 2118225.0 | 37.796259749404605 | -122.442865342513 | (37.7962597494046, -122.442865342513) | |
| 1357 | 1357 | 173636 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |
| 1358 | 1358 | 173635 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |
| 2059 | 2059 | 173596 | Significant Tree 6 | Tree(s) :: 17 | 200 Howard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | Permit Number 779179 | 6014439.0 | 2115766.0 | 37.790301726009204 | -122.393900378517 | (37.7903017260092, -122.393900378517) | |||
| 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) | |
| 2169 | 2169 | 89310 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780094 | 6000399.0 | 2109002.0 | 37.7709392449299 | -122.441991937871 | (37.7709392449299, -122.441991937871) | |
| 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) | |
| 2184 | 2184 | 89309 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780094 | 6000399.0 | 2109002.0 | 37.7709392449299 | -122.441991937871 | (37.7709392449299, -122.441991937871) | |
| 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) | |
| 7681 | 7681 | 103657 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 8197 | 8197 | 103668 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 9148 | 9148 | 85030 | Significant Tree 6 | Tree(s) :: 17 | 411 Panama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2007 12:00:00 AM | Permit Number 49384 | ||||||||
| 9848 | 9848 | 122687 | Significant Tree 6 | Tree(s) :: 17 | 1462 Funston Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/04/2017 12:00:00 AM | 3 | 3x8 | Permit Number 779171 | 5992142.99696903 | 2105491.66018597 | 37.7608268551195 | -122.470293739312 | (37.7608268551195, -122.470293739312) | |
| 10010 | 10010 | 173778 | Significant Tree 6 | Tree(s) :: 17 | 99X Cleveland St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 3x3 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 11212 | 11212 | 103658 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 12113 | 12113 | 103660 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 12885 | 12885 | 103661 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 15949 | 15949 | 103659 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 17858 | 17858 | 121173 | Significant Tree 6 | Tree(s) :: 17 | 950 Duncan St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000333.0 | 2099683.0 | 37.7453477932295 | -122.44155138616101 | (37.7453477932295, -122.441551386161) | ||||
| 19018 | 19018 | 102131 | Significant Tree 6 | Tree(s) :: 17 | 850 Treat Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/24/2012 12:00:00 AM | Permit Number 769452 | 6008548.2 | 2103592.2 | 37.7565461982029 | -122.41342088796499 | (37.7565461982029, -122.413420887965) | |||
| 19360 | 19360 | 105328 | Significant Tree 6 | Tree(s) :: 17 | 2051 03rd St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 771015 | 6015779.9 | 2106081.5 | 37.7637846705736 | -122.388584622631 | (37.7637846705736, -122.388584622631) | ||||
| 19405 | 19405 | 103965 | Significant Tree 6 | Tree(s) :: 17 | 141 Marview Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/11/2013 12:00:00 AM | Permit Number 770303 | 5998318.6 | 2103174.0 | 37.7548182509721 | -122.448768222318 | (37.7548182509721, -122.448768222318) | |||
| 20656 | 20656 | 107549 | Significant Tree 6 | Tree(s) :: 17 | 198X Jennings St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | ||
| 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 | |||||||
| 22894 | 22894 | 206842 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994803.1874 | 2087784.4983 | 37.712360795684 | -122.45981072288001 | (37.712360795684, -122.45981072288) | |
| 22897 | 22897 | 215094 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994821.63014 | 2087784.2030900002 | 37.7123610457095 | -122.45974695827199 | (37.7123610457095, -122.459746958272) | |
| 50166 | 50166 | 95953 | Significant Tree 6 | Tree(s) :: 17 | 499 Buena Vista East Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/18/2011 12:00:00 AM | 21 | Permit Number 57015 | 6000177.0 | 2107098.0 | 37.7656986843565 | -122.442623109531 | (37.7656986843565, -122.442623109531) | |||
| 50498 | 50498 | 100711 | Significant Tree 6 | Tree(s) :: 17 | 966-968 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/27/2012 12:00:00 AM | 14 | Permit Number 769148 | 6005605.8 | 2103343.5 | 37.7556976788024 | -122.423579088745 | (37.7556976788024, -122.423579088745) | ||
| 52917 | 52917 | 116537 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754.0 | 2090179.0 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | |
| 52920 | 52920 | 120918 | Significant Tree 6 | Tree(s) :: 17 | 555x SAN JOSE AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778877 | 6006305.0 | 2100249.0 | 37.747240333103 | -122.420941331562 | (37.747240333103, -122.420941331562) | |
| 53190 | 53190 | 94850 | Significant Tree 6 | Tree(s) :: 17 | 1107 Bowdoin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/17/2010 12:00:00 AM | Permit Number 53929 | 6009593.0 | 2091048.0 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | |||
| 62496 | 62496 | 103654 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 3 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.2033599997 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | |||
| 75158 | 75158 | 95137 | Significant Tree 6 | Tree(s) :: 17 | 2130 Fulton St | 127 | Front Yard : 25 | Tree 1 | Private 1 | 01/07/2011 12:00:00 AM | 3x3 | Permit Number 54069 | 5997590.0 | 2110608.0 | 37.7751884337973 | -122.45182417211599 | (37.7751884337973, -122.451824172116) | ||
| 77945 | 77945 | 95138 | Significant Tree 6 | Tree(s) :: 17 | 2130 Fulton St | 128 | Front Yard : 25 | Tree 1 | Private 1 | 01/07/2011 12:00:00 AM | 3x3 | Permit Number 54069 | 5997590.0 | 2110608.0 | 37.7751884337973 | -122.45182417211599 | (37.7751884337973, -122.451824172116) | ||
| 78125 | 78125 | 106567 | Significant Tree 6 | Tree(s) :: 17 | 50 Mendell St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/09/2014 12:00:00 AM | Permit Number 772455 | 6017061.8 | 2098665.7 | 37.743493385022795 | -122.383634554004 | (37.7434933850228, -122.383634554004) | |||
| 78156 | 78156 | 105239 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.42640959235099 | (37.7846133478309, -122.426409592351) | |||
| 79120 | 79120 | 107551 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 79360 | 79360 | 112811 | Significant Tree 6 | Tree(s) :: 17 | 2023 43rd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5982877.4 | 2101339.2 | 37.748885310102104 | -122.502031530859 | (37.7488853101021, -122.502031530859) | |||||
| 79722 | 79722 | 93222 | Significant Tree 6 | Tree(s) :: 17 | 85 Santa Rita Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/26/2010 12:00:00 AM | Permit Number 53213 | 5993788.0 | 2100441.0 | 37.7470540096767 | -122.46423776520399 | (37.7470540096767, -122.464237765204) | |||
| 80154 | 80154 | 99623 | Significant Tree 6 | Tree(s) :: 17 | 380 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/23/2012 12:00:00 AM | Permit Number 768850 | 6013171.4 | 2105301.7 | 37.7614986071193 | -122.39755199325701 | (37.7614986071193, -122.397551993257) | |||
| 80420 | 80420 | 105844 | Significant Tree 6 | Tree(s) :: 17 | 355 Buena Vista Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/03/2014 12:00:00 AM | Permit Number 771052 | 6000886.5 | 2107736.6 | 37.767492540377 | -122.44021490806801 | (37.767492540377, -122.440214908068) | ||||
| 80662 | 80662 | 110904 | Significant Tree 6 | Tree(s) :: 17 | 203 CORBETT AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 3x3 | 6000094.0 | 2105620.0 | 37.7616357315689 | -122.442804047122 | (37.7616357315689, -122.442804047122) | |||
| 81053 | 81053 | 88569 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 60 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 81076 | 81076 | 88608 | Significant Tree 6 | Tree(s) :: 17 | 350 Urbano Dr | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | Permit Number 51562 | 5991996.0 | 2092560.0 | 37.72531132011171 | -122.46986059313801 | (37.7253113201117, -122.469860593138) | |||
| 82211 | 82211 | 115446 | Significant Tree 6 | Tree(s) :: 17 | 546 FRANCONIA ST | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777844 | 6009931.0 | 2098208.0 | 37.7418399166086 | -122.40825891223801 | (37.7418399166086, -122.408258912238) | |
| 82320 | 82320 | 113769 | Significant Tree 6 | Tree(s) :: 17 | 2550 Broadway | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6001418.65940389 | 2117313.19689891 | 37.7938177263924 | -122.439060665499 | (37.7938177263924, -122.439060665499) | |||||
| 82961 | 82961 | 96186 | Significant Tree 6 | Tree(s) :: 17 | 333 Harrison St | 3 | Sidewalk: Property side : 26 | Tree 1 | Private 1 | Permit Number 767224 | 6015127.7 | 2114620.1 | 37.7871935976335 | -122.39143736362 | (37.7871935976335, -122.39143736362) | ||||
| 83219 | 83219 | 108097 | Significant Tree 6 | Tree(s) :: 17 | 3370 Washington St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5998663.3699 | 2115944.3199400003 | 37.789901994506 | -122.44849555223101 | (37.789901994506, -122.448495552231) | |||||
| 84182 | 84182 | 104279 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 84297 | 84297 | 121446 | Significant Tree 6 | Tree(s) :: 17 | 500 Terry A Francois Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6016102.0 | 2110410.0 | 37.775687633053 | -122.38777260103399 | (37.775687633053, -122.387772601034) | ||||
| 84519 | 84519 | 106568 | Significant Tree 6 | Tree(s) :: 17 | 50 Mendell St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/09/2014 12:00:00 AM | Permit Number 772455 | 6017061.8 | 2098665.7 | 37.743493385022795 | -122.383634554004 | (37.7434933850228, -122.383634554004) | |||
| 84569 | 84569 | 105964 | Significant Tree 6 | Tree(s) :: 17 | 360 MISSOURI ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6013401.8 | 2105413.2 | 37.761817588008206 | -122.39676294611401 | (37.7618175880082, -122.396762946114) | |||||
| 84673 | 84673 | 110840 | Significant Tree 6 | Tree(s) :: 17 | 2037 TURK BLVD | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000252.0 | 2111948.0 | 37.779019836036206 | -122.442711981138 | (37.7790198360362, -122.442711981138) |
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");