trees
11,761 rows where qSpecies_id = 17 sorted by qSiteInfo descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 132026 | 102129 | Permitted Site 7 | Tree(s) :: 17 | 79 Starview Way | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | Permit Number 769583 | 5997451.3 | 2101874.2 | 37.7511996890852 | -122.451673814863 | (37.7511996890852, -122.451673814863) | 1 | 5 | 4 | 63 | 38 | |||
| 133059 | 253652 | Significant Tree 6 | Tree(s) :: 17 | 131 Font Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | 10x10 | Permit Number 780806 | 5990844 | 2088883 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | 1 | 8 | 4 | 64 | 14 | |
| 133776 | 187233 | DPW Maintained 1 | Tree(s) :: 17 | 2401 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984955.1932 | 2098637.2484 | 37.7415883305025 | -122.494647457647 | (37.7415883305025, -122.494647457647) | 1 | 8 | 3 | 29491 | 35 | |||
| 134078 | 113992 | Undocumented 4 | Tree(s) :: 17 | 5500x DIAMOND HEIGHTS BLVD | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6001796 | 2097543 | 37.7395550974381 | -122.43633945252 | (37.7395550974381, -122.43633945252) | 2 | 7 | 5 | 63 | 7 | ||||
| 136500 | 101477 | Permitted Site 7 | Tree(s) :: 17 | 1 Oak Park Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/07/2012 12:00:00 AM | Permit Number 769453 | 5996419.1 | 2103319 | 37.7551075796122 | -122.455347659049 | (37.7551075796122, -122.455347659049) | 1 | 5 | 4 | 63 | 12 | |||
| 140962 | 93083 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
| 142997 | 185442 | DPW Maintained 1 | Tree(s) :: 17 | 2300 Sunset Blvd | 59 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985068.6448 | 2099480.8089 | 37.7439111594648 | -122.494317351186 | (37.7439111594648, -122.494317351186) | 1 | 8 | 3 | 29491 | 35 | |||
| 146060 | 110019 | DPW Maintained 1 | Tree(s) :: 17 | 1970X Pacheco St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/17/2015 12:00:00 AM | 3 | 10x10 | Permit Number 775175 | 5988957.75596 | 2101724.09263 | 37.7502974516687 | -122.481034078879 | (37.7502974516687, -122.481034078879) | 1 | 8 | 3 | 29491 | 35 | |
| 152620 | 121725 | Undocumented 4 | Tree(s) :: 17 | 2650 Diamond St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 3x3 | 6002274 | 2096516 | 37.7367623413593 | -122.434613321972 | (37.7367623413593, -122.434613321972) | 2 | 7 | 5 | 63 | 7 | |||
| 155656 | 105435 | Significant Tree 6 | Tree(s) :: 17 | 610 PARNASSUS AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/05/2014 12:00:00 AM | 16 | Permit Number 771221 | 5995151.3 | 2106193.4 | 37.762927120329 | -122.459940260935 | (37.762927120329, -122.459940260935) | 15 | 5 | 11 | 56 | 12 | ||
| 155699 | 109175 | Undocumented 4 | Tree(s) :: 17 | 435 COLON AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5995612.6 | 2095239.4 | 37.7328766952503 | -122.457552206396 | (37.7328766952503, -122.457552206396) | 9 | 7 | 4 | 59 | 40 | ||||
| 156380 | 186814 | DPW Maintained 1 | Tree(s) :: 17 | 1200 Sunset Blvd | 113 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984809.4922 | 2106874.2257 | 37.7641962707422 | -122.495758685523 | (37.7641962707422, -122.495758685523) | 1 | 8 | 3 | 56 | 35 | |||
| 167683 | 118289 | Undocumented 4 | Tree(s) :: 17 | 280 DENSLOWE DR | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/03/2017 12:00:00 AM | 3 | 3x20 | Permit Number 778582 | 5990605 | 2090671 | 37.7200440933176 | -122.474531301553 | (37.7200440933176, -122.474531301553) | 9 | 8 | 4 | 64 | 40 | |
| 170695 | 66980 | Permitted Site 7 | Tree(s) :: 17 | 320 Santa Ana Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | Permit Number 769440 | 5992591.07178475 | 2094730.63231779 | 37.7313057191225 | -122.467961318401 | (37.7313057191225, -122.467961318401) | 9 | 8 | 4 | 59 | 40 | |||
| 174687 | 181931 | DPW Maintained 1 | Tree(s) :: 17 | 2434 32nd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986447.2375 | 2098665.0417 | 37.7417518608642 | -122.489490587336 | (37.7417518608642, -122.489490587336) | 1 | 8 | 3 | 29491 | 35 | |||
| 175677 | 184866 | DPW Maintained 1 | Tree(s) :: 17 | 1201 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984637.6691 | 2106828.2325 | 37.7640599223867 | -122.496349569481 | (37.7640599223867, -122.496349569481) | 1 | 8 | 3 | 56 | 35 | |||
| 182332 | 258021 | Significant Tree 6 | Tree(s) :: 17 | 201x Gough St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006013 | 2110374 | 37.7750247439455 | -122.422670446803 | (37.7750247439455, -122.422670446803) | 7 | 9 | 11 | 28852 | 10 | ||||
| 184396 | 184868 | DPW Maintained 1 | Tree(s) :: 17 | 1201 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984647.5418 | 2106829.3717 | 37.7640636286505 | -122.496315507283 | (37.7640636286505, -122.496315507283) | 1 | 8 | 3 | 56 | 35 | |||
| 184603 | 251177 | DPW Maintained 1 | Tree(s) :: 17 | 178 Bluxome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6012557 | 2110038 | 37.7744691941496 | -122.400009583897 | (37.7744691941496, -122.400009583897) | 14 | 2 | 9 | 28856 | 20 | ||||
| 184778 | 93081 | Permitted Site 7 | Tree(s) :: 17 | 1230 Twin Peaks Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | 2 | 5 | 4 | 63 | 38 | |||
| 187189 | 184817 | DPW Maintained 1 | Tree(s) :: 17 | 1201 Sunset Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984676.4005 | 2106956.7675 | 37.764415112141 | -122.496225095071 | (37.764415112141, -122.496225095071) | 1 | 8 | 3 | 56 | 35 | |||
| 189599 | 102464 | Undocumented 4 | Tree(s) :: 17 | 280 Casitas Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5994944.5 | 2096334.7 | 37.735845720803 | -122.459941299214 | (37.735845720803, -122.459941299214) | 9 | 7 | 4 | 59 | 40 | ||||
| 191707 | 187258 | DPW Maintained 1 | Tree(s) :: 17 | 2401 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984954.3762 | 2098434.6407 | 37.7410319765896 | -122.494635349253 | (37.7410319765896, -122.494635349253) | 1 | 8 | 3 | 29491 | 35 | |||
| 194229 | 98736 | Undocumented 4 | Tree(s) :: 17 | 89 Paradise Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 6000827.4 | 2096045.9 | 37.7353893278652 | -122.439581147409 | (37.7353893278652, -122.439581147409) | 2 | 7 | 5 | 63 | 7 | ||||||
| 194349 | 265045 | Section 806 (d) 5 | Tree(s) :: 17 | 1250 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
| 54127 | 110312 | DPW Maintained 1 | Tree(s) :: 17 | 899x Stanyan St | 6 | Sidewalk: Property side : Pot | Tree | Dept of Real Estate 7 | 04/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774992 | 5997166.64381 | 2107575.86009 | 37.7668387037649 | -122.45306972129 | (37.7668387037649, -122.45306972129) | 15 | 5 | 11 | 29492 | 8 | |
| 70819 | 107748 | Permitted Site 7 | Tree(s) :: 17 | 475 Florida St | 3 | Sidewalk: Property side : Pot | Tree | Private 2 | 10/22/2014 12:00:00 AM | 3 | Permit Number 774008 | 6009222.84948 | 2106151.80329 | 37.7636121434561 | -122.411268508959 | (37.7636121434561, -122.411268508959) | 8 | 4 | 7 | 28859 | 19 | ||
| 80854 | 107747 | Permitted Site 7 | Tree(s) :: 17 | 475 Florida St | 2 | Sidewalk: Property side : Pot | Tree | Private 2 | 10/22/2014 12:00:00 AM | 3 | Permit Number 774008 | 6009222.84948 | 2106151.80329 | 37.7636121434561 | -122.411268508959 | (37.7636121434561, -122.411268508959) | 8 | 4 | 7 | 28859 | 19 | ||
| 96885 | 107746 | Permitted Site 7 | Tree(s) :: 17 | 475 Florida St | 1 | Sidewalk: Property side : Pot | Tree | Private 2 | 10/22/2014 12:00:00 AM | 3 | Permit Number 774008 | 6009222.84948 | 2106151.80329 | 37.7636121434561 | -122.411268508959 | (37.7636121434561, -122.411268508959) | 8 | 4 | 7 | 28859 | 19 | ||
| 98553 | 94229 | Permitted Site 7 | Tree(s) :: 17 | 45 Stonecrest Dr | 1 | Sidewalk: Property side : Pot | Tree | Private 2 | 06/28/2010 12:00:00 AM | 60 | Permit Number 53610 | 5991334 | 2093833 | 37.7287683725713 | -122.47224179475 | (37.7287683725713, -122.47224179475) | 9 | 8 | 4 | 64 | 40 | ||
| 111458 | 93908 | Permitted Site 7 | Tree(s) :: 17 | 1238 Sutter St | Sidewalk: Property side : Pot | Tree | Private 2 | 04/26/2010 12:00:00 AM | Permit Number 53382 | 6006657 | 2114990 | 37.7877354690453 | -122.420770480664 | (37.7877354690453, -122.420770480664) | 13 | 9 | 10 | 28858 | 21 | ||||
| 120050 | 96291 | DPW Maintained 1 | Tree(s) :: 17 | 1294 Union St | Sidewalk: Property side : Pot | Landscaping | Private 2 | 03/21/2011 12:00:00 AM | 6006773 | 2119090 | 37.7989995844362 | -122.420660308797 | (37.7989995844362, -122.420660308797) | 5 | 9 | 1 | 28858 | 32 | |||||
| 153742 | 96292 | DPW Maintained 1 | Tree(s) :: 17 | 1294 Union St | Sidewalk: Property side : Pot | Landscaping | Private 2 | 03/21/2011 12:00:00 AM | 6006773 | 2119090 | 37.7989995844362 | -122.420660308797 | (37.7989995844362, -122.420660308797) | 5 | 9 | 1 | 28858 | 32 | |||||
| 183568 | 93909 | Permitted Site 7 | Tree(s) :: 17 | 1238 Sutter St | 2 | Sidewalk: Property side : Pot | Tree | Private 2 | 04/26/2010 12:00:00 AM | Permit Number 53382 | 6006657 | 2114990 | 37.7877354690453 | -122.420770480664 | (37.7877354690453, -122.420770480664) | 13 | 9 | 10 | 28858 | 21 | |||
| 2057 | 111315 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.62139 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | 1 | 8 | 3 | 29491 | 35 | ||
| 2230 | 256764 | Undocumented 4 | Tree(s) :: 17 | 25 Serrano Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/25/2019 12:00:00 AM | 3 | 6x6 | Permit Number 782398 | 5990027 | 2090605 | 37.7198293671123 | -122.476524410241 | (37.7198293671123, -122.476524410241) | 1 | 8 | 4 | 64 | 14 | |
| 3247 | 69218 | Permitted Site 7 | Tree(s) :: 17 | 1196 Treat Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/02/2015 12:00:00 AM | 3x3 | Permit Number 776894 | 6008647.40418625 | 2101585.3758574 | 37.7510414812393 | -122.412935918741 | (37.7510414812393, -122.412935918741) | 2 | 4 | 7 | 28859 | 19 | ||
| 6364 | 264920 | Significant Tree 6 | Tree(s) :: 17 | 99X Everglade Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 6x10 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |
| 7796 | 264921 | Significant Tree 6 | Tree(s) :: 17 | 99X Everglade Dr | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 6x10 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |
| 9406 | 111316 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.62139 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | 1 | 8 | 3 | 29491 | 35 | ||
| 11386 | 234835 | Permitted Site 7 | Tree(s) :: 17 | 5407 Diamond Heights Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/06/2020 12:00:00 AM | 3 | 5x5 | Permit Number 784399 | 6002085.73354 | 2098136.94746 | 37.7412023972767 | -122.435380156586 | (37.7412023972767, -122.435380156586) | 2 | 7 | 5 | 63 | 7 | |
| 13426 | 260872 | Private 9 | Tree(s) :: 17 | 1736 Fitzgerald Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011805.50809 | 2092676.7551 | 37.7267570649137 | -122.401388810186 | (37.7267570649137, -122.401388810186) | 10 | 3 | 8 | 58 | 1 | |||
| 15160 | 260680 | Significant Tree 6 | Tree(s) :: 17 | 1450x Laguna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6004617 | 2113883 | 37.7845807327875 | -122.42774958855 | (37.7845807327875, -122.42774958855) | 13 | 9 | 11 | 28858 | 41 | ||||
| 16055 | 260578 | Significant Tree 6 | Tree(s) :: 17 | 1879 Funston Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 784834 | 5992075.37659 | 2102679.56742 | 37.7531016753032 | -122.470322812874 | (37.7531016753032, -122.470322812874) | 1 | 8 | 4 | 56 | 12 | |
| 16460 | 234836 | Permitted Site 7 | Tree(s) :: 17 | 5407 Diamond Heights Blvd | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/06/2020 12:00:00 AM | 3 | 5x5 | Permit Number 784399 | 6002085.11371 | 2098147.92436 | 37.7412325020832 | -122.435383084755 | (37.7412325020832, -122.435383084755) | 2 | 7 | 5 | 63 | 7 | |
| 16827 | 111314 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.62139 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | 1 | 8 | 3 | 29491 | 35 | ||
| 17482 | 111313 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.62139 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | 1 | 8 | 3 | 29491 | 35 | ||
| 17829 | 106868 | Undocumented 4 | Tree(s) :: 17 | 1956 GREAT HWY | Sidewalk: Property side : Cutout | Tree | Private 2 | 5981193.7 | 2101737.6 | 37.7498801477899 | -122.507883225183 | (37.7498801477899, -122.507883225183) | 1 | 8 | 3 | 29491 | 35 | ||||||
| 19136 | 102260 | Undocumented 4 | Tree(s) :: 17 | 1350 46th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 24 | 4x6 | 5981875.8 | 2105892.8 | 37.7613293147111 | -122.505832545781 | (37.7613293147111, -122.505832545781) | 1 | 8 | 3 | 56 | 35 | |||
| 20658 | 116460 | Undocumented 4 | Tree(s) :: 17 | 66 AERIAL WAY | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 30 | 3x3 | Permit Number 777893 | 5992280 | 2102576 | 37.7528291346084 | -122.469607652393 | (37.7528291346084, -122.469607652393) | 1 | 8 | 4 | 56 | 12 | ||
| 25358 | 107912 | Permitted Site 7 | Tree(s) :: 17 | 65X Newburg St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770183 | 6002412.15669 | 2099793.63341 | 37.7457698026645 | -122.434369920352 | (37.7457698026645, -122.434369920352) | 2 | 7 | 5 | 63 | 22 | ||
| 26280 | 107595 | Undocumented 4 | Tree(s) :: 17 | 1846 POST ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003338.5 | 2114199.3 | 37.7853768084061 | -122.432195360195 | (37.7853768084061, -122.432195360195) | 13 | 9 | 11 | 29490 | 13 | |||
| 29577 | 101809 | Undocumented 4 | Tree(s) :: 17 | 370 Hermann St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6003497 | 2108649 | 37.7701460471638 | -122.43125067595 | (37.7701460471638, -122.43125067595) | 15 | 9 | 11 | 29492 | 10 | ||||
| 35286 | 101960 | Permitted Site 7 | Tree(s) :: 17 | 896 De Haro St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | 10 | 3 | 8 | 28856 | 29 | |||
| 35848 | 97518 | Permitted Site 7 | Tree(s) :: 17 | 2507 Pacific Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/18/2011 12:00:00 AM | Permit Number 768390 | 6002058 | 2116985.3 | 37.7929537637119 | -122.436825007685 | (37.7929537637119, -122.436825007685) | 13 | 6 | 1 | 29490 | 27 | |||
| 38975 | 116839 | Undocumented 4 | Tree(s) :: 17 | 690 ROCKDALE DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5997625 | 2098222 | 37.7411815887471 | -122.45080983743 | (37.7411815887471, -122.45080983743) | 9 | 7 | 4 | 59 | 40 | ||||
| 39818 | 94053 | Permitted Site 7 | Tree(s) :: 17 | 2495 33rd Ave | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/25/2010 12:00:00 AM | Permit Number 53457 | 5986086.2 | 2098276.2 | 37.7406631217311 | -122.490710314749 | (37.7406631217311, -122.490710314749) | 1 | 8 | 3 | 29491 | 35 | |||
| 40219 | 101965 | Permitted Site 7 | Tree(s) :: 17 | 896 De Haro St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | 10 | 3 | 8 | 28856 | 29 | |||
| 40356 | 107952 | Permitted Site 7 | Tree(s) :: 17 | 2200 JERROLD AVE | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6012443.5 | 2099218.7 | 37.7447554536478 | -122.399642400815 | (37.7447554536478, -122.399642400815) | 10 | 3 | 8 | 58 | 1 | ||||
| 41328 | 121446 | Significant Tree 6 | Tree(s) :: 17 | 500 Terry A Francois Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6016102 | 2110410 | 37.775687633053 | -122.387772601034 | (37.775687633053, -122.387772601034) | 14 | 3 | 9 | 310 | 20 | ||||
| 42283 | 101966 | Permitted Site 7 | Tree(s) :: 17 | 896 De Haro St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | 10 | 3 | 8 | 28856 | 29 | |||
| 43625 | 256876 | DPW Maintained 1 | Tree(s) :: 17 | 2449 Golden Gate Ave | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 10x10 | Permit Number 782666 | 5997716 | 2111278 | 37.7770352956542 | -122.451436646998 | (37.7770352956542, -122.451436646998) | 15 | 6 | 2 | 29492 | 16 | |
| 45364 | 96878 | Permitted Site 7 | Tree(s) :: 17 | 2200X San Jose Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/30/2014 12:00:00 AM | Permit Number 773235 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||
| 46946 | 112740 | Undocumented 4 | Tree(s) :: 17 | 2514 CLAY ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/09/2015 12:00:00 AM | 3x3 | Permit Number 776637 | 6002696 | 2116178 | 37.7907733646004 | -122.43455974658 | (37.7907733646004, -122.43455974658) | 13 | 9 | 1 | 29490 | 27 | ||
| 47379 | 119268 | Permitted Site 7 | Tree(s) :: 17 | 109 Gates St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778717 | 6008342 | 2098018 | 37.7412291127161 | -122.41373973636 | (37.7412291127161, -122.41373973636) | 2 | 7 | 7 | 28859 | 2 | |
| 49479 | 112562 | Permitted Site 7 | Tree(s) :: 17 | 1000X 17th Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/06/2015 12:00:00 AM | Permit Number 774340 | 5990959.97324 | 2102133.59106 | 37.7515380150924 | -122.474140224193 | (37.7515380150924, -122.474140224193) | 1 | 8 | 4 | 29491 | 12 | ||||
| 49922 | 107911 | Permitted Site 7 | Tree(s) :: 17 | 65X Newburg St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770183 | 6002412.15669 | 2099793.63341 | 37.7457698026645 | -122.434369920352 | (37.7457698026645, -122.434369920352) | 2 | 7 | 5 | 63 | 22 | ||
| 50034 | 204345 | DPW Maintained 1 | Tree(s) :: 17 | 44 Southwood Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/22/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 781011 | 5995599.60309 | 2092472.80372 | 37.7252795425123 | -122.45739705673 | (37.7252795425123, -122.45739705673) | 9 | 7 | 4 | 28861 | 40 | |
| 50329 | 112431 | DPW Maintained 1 | Tree(s) :: 17 | 19 Arguello Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/29/2015 12:00:00 AM | 3x3 | Permit Number 774101 | 5995479 | 2115773.8 | 37.7892512085361 | -122.459500756916 | (37.7892512085361, -122.459500756916) | 11 | 6 | 1 | 54 | 11 | ||
| 50467 | 105357 | Undocumented 4 | Tree(s) :: 17 | 171X Dorado Ter | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 18 | 3x9 | 5994283.2391 | 2093059.23457 | 37.7268140423665 | -122.461990071604 | (37.7268140423665, -122.461990071604) | 9 | 8 | 4 | 28861 | 40 | |||
| 55138 | 112807 | Undocumented 4 | Tree(s) :: 17 | 85 LOMITA AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5991376 | 2104593 | 37.7583149976739 | -122.472880884893 | (37.7583149976739, -122.472880884893) | 1 | 8 | 4 | 56 | 12 | ||||
| 55462 | 94961 | DPW Maintained 1 | Tree(s) :: 17 | 3098 PACIFIC AVE | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 10/25/2010 12:00:00 AM | 5999362 | 2116697 | 37.792008575714 | -122.446132526841 | (37.792008575714, -122.446132526841) | 13 | 6 | 1 | 29490 | 27 | ||||
| 56668 | 113769 | Significant Tree 6 | Tree(s) :: 17 | 2550 Broadway | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001418.65940389 | 2117313.19689891 | 37.7938177263924 | -122.439060665499 | (37.7938177263924, -122.439060665499) | 13 | 9 | 1 | 57 | 27 | |||||
| 57078 | 101964 | Permitted Site 7 | Tree(s) :: 17 | 896 De Haro St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | 10 | 3 | 8 | 28856 | 29 | |||
| 57766 | 101731 | DPW Maintained 1 | Tree(s) :: 17 | 1300X Lyon St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/25/2013 12:00:00 AM | 3x3 | Permit Number 770262 | 5999795.2 | 2113332.1 | 37.7827941670798 | -122.444391727519 | (37.7827941670798, -122.444391727519) | 15 | 5 | 1 | 29490 | 31 | ||
| 60755 | 252849 | DPW Maintained 1 | Tree(s) :: 17 | 200 Woodside Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996376 | 2100052 | 37.7461347404292 | -122.455260624993 | (37.7461347404292, -122.455260624993) | 1 | 5 | 4 | 59 | 40 | ||||
| 63535 | 101699 | Undocumented 4 | Tree(s) :: 17 | 2700 18th St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/13/2012 12:00:00 AM | 2x3 | Permit Number 769052 | 6009810.4 | 2105505.4 | 37.7618702017999 | -122.409190731152 | (37.7618702017999, -122.409190731152) | 8 | 4 | 8 | 28859 | 19 | ||
| 64237 | 114607 | Undocumented 4 | Tree(s) :: 17 | 2399X 15TH AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | Permit Number 779471 | 5991654 | 2099150 | 37.7433860243849 | -122.471522828523 | (37.7433860243849, -122.471522828523) | 1 | 8 | 4 | 29491 | 40 | |||
| 70272 | 97161 | Undocumented 4 | Tree(s) :: 17 | 3170 23rd St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 30 | 3x3 | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373 | (37.7541940143569, -122.41572017373) | 2 | 4 | 7 | 28859 | 19 | ||
| 73343 | 122634 | Significant Tree 6 | Tree(s) :: 17 | 3680X 19th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/05/2016 12:00:00 AM | 3 | 3x10 | Permit Number 779220 | 5990592 | 2091224 | 37.7215617409212 | -122.474616575991 | (37.7215617409212, -122.474616575991) | 9 | 8 | 4 | 64 | 40 | |
| 74511 | 110307 | DPW Maintained 1 | Tree(s) :: 17 | 899x Stanyan St | 2 | Sidewalk: Property side : Cutout | Tree | Dept of Real Estate 7 | 04/03/2015 12:00:00 AM | 3 | 4x11 | Permit Number 774992 | 5997166.64381 | 2107575.86009 | 37.7668387037649 | -122.45306972129 | (37.7668387037649, -122.45306972129) | 15 | 5 | 11 | 29492 | 8 | |
| 78433 | 104459 | DPW Maintained 1 | Tree(s) :: 17 | 1601X Kansas St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 4 | 3x6 | 6011789.30586 | 2100707.09327 | 37.748805772054 | -122.402009105448 | (37.748805772054, -122.402009105448) | 10 | 3 | 8 | 58 | 1 | |||
| 78516 | 102584 | Undocumented 4 | Tree(s) :: 17 | 22 Gennessee St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5997479.4 | 2093692.8 | 37.7287371564084 | -122.450986747444 | (37.7287371564084, -122.450986747444) | 9 | 7 | 4 | 28861 | 40 | |||||
| 81780 | 206842 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994803.1874 | 2087784.4983 | 37.712360795684 | -122.45981072288 | (37.712360795684, -122.45981072288) | 9 | 8 | 6 | 28861 | 24 | |
| 81800 | 101961 | Permitted Site 7 | Tree(s) :: 17 | 896 De Haro St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | 10 | 3 | 8 | 28856 | 29 | |||
| 82368 | 99295 | Permitted Site 7 | Tree(s) :: 17 | 947 Lincoln Way | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5992761.5 | 2107248.3 | 37.7656858649034 | -122.468282426864 | (37.7656858649034, -122.468282426864) | 11 | 8 | 11 | 56 | 12 | |||||
| 82614 | 101963 | Permitted Site 7 | Tree(s) :: 17 | 896 De Haro St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | 10 | 3 | 8 | 28856 | 29 | |||
| 82814 | 95351 | Permitted Site 7 | Tree(s) :: 17 | 2316 Golden Gate Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/14/2011 12:00:00 AM | 2x2 | Permit Number 767218 | 5998391.3 | 2111446.7 | 37.77753714844 | -122.449112740848 | (37.77753714844, -122.449112740848) | 15 | 6 | 2 | 54 | 16 | ||
| 87462 | 107036 | Significant Tree 6 | Tree(s) :: 17 | 350 08th St | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/23/2014 12:00:00 AM | 7x7 | Permit Number 772214 | 6009826 | 2110084 | 37.7744428576765 | -122.409459923405 | (37.7744428576765, -122.409459923405) | 8 | 2 | 9 | 28853 | 34 | |||
| 88950 | 96879 | Permitted Site 7 | Tree(s) :: 17 | 2200X San Jose Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/30/2014 12:00:00 AM | Permit Number 773235 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||
| 91104 | 87151 | Permitted Site 7 | Tree(s) :: 17 | 4 Bellair Pl | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6010093 | 2120950 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | 3 | 1 | 10 | 308 | 23 | ||||
| 91217 | 107949 | Permitted Site 7 | Tree(s) :: 17 | 2200 JERROLD AVE | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6012443.5 | 2099218.7 | 37.7447554536478 | -122.399642400815 | (37.7447554536478, -122.399642400815) | 10 | 3 | 8 | 58 | 1 | ||||
| 91537 | 85195 | DPW Maintained 1 | Tree(s) :: 17 | 333 Eucalyptus Dr | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 5990168 | 2094689 | 37.7310511825826 | -122.476335191755 | (37.7310511825826, -122.476335191755) | 1 | 8 | 4 | 64 | 14 | ||||||
| 93980 | 204163 | DPW Maintained 1 | Tree(s) :: 17 | 44 Southwood Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/22/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 781011 | 5995611.13254 | 2092478.8947 | 37.7252969291056 | -122.45735764125 | (37.7252969291056, -122.45735764125) | 9 | 7 | 4 | 28861 | 40 | |
| 99018 | 106237 | Undocumented 4 | Tree(s) :: 17 | 607 BRUSSELS ST | Sidewalk: Property side : Cutout | Tree | Private 2 | 6010922.6 | 2091903.6 | 37.724584840414 | -122.404386617586 | (37.724584840414, -122.404386617586) | 10 | 3 | 7 | 309 | 28 | ||||||
| 99131 | 94962 | DPW Maintained 1 | Tree(s) :: 17 | 3098@Lyon Pacific Ave | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 10/25/2010 12:00:00 AM | 5999362 | 2116697.3 | 37.7920093994348 | -122.446132548429 | (37.7920093994348, -122.446132548429) | 13 | 6 | 1 | 29490 | 27 | |||||
| 99421 | 107910 | Permitted Site 7 | Tree(s) :: 17 | 65X Newburg St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770183 | 6002412.15669 | 2099793.63341 | 37.7457698026645 | -122.434369920352 | (37.7457698026645, -122.434369920352) | 2 | 7 | 5 | 63 | 22 | ||
| 102632 | 94633 | Permitted Site 7 | Tree(s) :: 17 | 3600 16th St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/18/2010 12:00:00 AM | 3x3 | Permit Number 53781 | 6002902 | 2106490 | 37.7641842232844 | -122.433154488347 | (37.7641842232844, -122.433154488347) | 15 | 4 | 5 | 28862 | 3 | ||
| 105272 | 115099 | Undocumented 4 | Tree(s) :: 17 | 1061X PACHECO ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/16/2017 12:00:00 AM | 3 | 3x10 | Permit Number 779333 | 5991641 | 2102174 | 37.7516883950984 | -122.471788116316 | (37.7516883950984, -122.471788116316) | 1 | 8 | 4 | 29491 | 12 | |
| 105443 | 101967 | Permitted Site 7 | Tree(s) :: 17 | 896 De Haro St | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | 10 | 3 | 8 | 28856 | 29 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );