trees
7,322 rows where qSpecies_id = 1 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10561 | 261942 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Verna St | 7 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
| 10736 | 262270 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 4 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
| 12694 | 262268 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 2 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
| 14968 | 262269 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 3 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
| 16422 | 262267 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 1 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
| 1125 | 101207 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 7381 | 261038 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2701 Phelps St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6011783.11668 | 2093247.60163 | 37.728323242206 | -122.401506319354 | (37.728323242206, -122.401506319354) | 10 | 3 | 8 | 58 | 1 | ||
| 8848 | 180194 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 162 Tioga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6010134.95637 | 2089163.33615 | 37.7170165958166 | -122.406916365593 | (37.7170165958166, -122.406916365593) | 9 | 7 | 8 | 309 | 39 | ||||
| 9992 | 242301 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 21 Digby St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6003131.09192 | 2097221.83137 | 37.7387490116556 | -122.431700361905 | (37.7387490116556, -122.431700361905) | 2 | 7 | 5 | 63 | 7 | ||||
| 11388 | 101208 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 16908 | 218566 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 80 Rossmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5990820.10787 | 2094527.49185 | 37.7306455183576 | -122.474068986495 | (37.7306455183576, -122.474068986495) | 9 | 8 | 4 | 64 | 40 | |||
| 17820 | 101211 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 19405 | 136810 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2509 Pierce St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6001666.14129 | 2117099.39038 | 37.7932447477064 | -122.438189033412 | (37.7932447477064, -122.438189033412) | 13 | 6 | 1 | 29490 | 27 | |||
| 21667 | 198053 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Illinois St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 9ft | 6015994.50717 | 2105252.59433 | 37.7615205644539 | -122.387784515751 | (37.7615205644539, -122.387784515751) | 10 | 3 | 8 | 28856 | 29 | |||
| 23159 | 192045 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013178.04643 | 2110099.77457 | 37.7746734191738 | -122.397865584934 | (37.7746734191738, -122.397865584934) | 14 | 2 | 9 | 28856 | 20 | |
| 23780 | 136812 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2509 Pierce St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6001667.70874 | 2117080.51294 | 37.7931930043084 | -122.438182257008 | (37.7931930043084, -122.438182257008) | 13 | 6 | 1 | 29490 | 27 | |||
| 23916 | 198058 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Illinois St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 6016003.50284 | 2105138.76714 | 37.7612085176665 | -122.387745460881 | (37.7612085176665, -122.387745460881) | 10 | 3 | 8 | 28856 | 29 | |||
| 30878 | 136886 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2655 Polk St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6006127.92223 | 2119929.33879 | 37.8012678182029 | -122.422952183303 | (37.8012678182029, -122.422952183303) | 13 | 9 | 1 | 28858 | 32 | |||
| 32474 | 180256 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003464.1171 | 2094730.21395 | 37.7319264686289 | -122.430371195377 | (37.7319264686289, -122.430371195377) | 9 | 7 | 5 | 28861 | 25 | |||
| 33863 | 91157 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 245 Fowler Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | 9 | 7 | 4 | 59 | 40 | ||
| 34933 | 180259 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003405.48601 | 2094728.18397 | 37.7319175734374 | -122.430573750589 | (37.7319175734374, -122.430573750589) | 9 | 7 | 5 | 28861 | 25 | |||
| 41678 | 136813 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2509 Pierce St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6001669.86096 | 2117066.81611 | 37.7931555187762 | -122.438173828567 | (37.7931555187762, -122.438173828567) | 13 | 6 | 1 | 29490 | 27 | |||
| 43064 | 180257 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003441.65592 | 2094728.25721 | 37.7319198235266 | -122.430448708839 | (37.7319198235266, -122.430448708839) | 9 | 7 | 5 | 28861 | 25 | |||
| 43154 | 136814 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2509 Pierce St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6001670.66437 | 2117042.7739 | 37.7930895508067 | -122.438169325648 | (37.7930895508067, -122.438169325648) | 13 | 6 | 1 | 29490 | 27 | |||
| 46960 | 242300 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 23 Digby St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6003110.46195 | 2097242.14325 | 37.738803614002 | -122.431773140441 | (37.738803614002, -122.431773140441) | 2 | 7 | 5 | 63 | 7 | ||||
| 49722 | 198059 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Illinois St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 6016002.244 | 2105125.97833 | 37.7611733325983 | -122.387748922377 | (37.7611733325983, -122.387748922377) | 10 | 3 | 8 | 28856 | 29 | |||
| 49791 | 180327 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 443 Capistrano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6000920.89478 | 2092230.14333 | 37.7249174601452 | -122.438984528709 | (37.7249174601452, -122.438984528709) | 9 | 7 | 6 | 28861 | 25 | ||||
| 56445 | 101209 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 56949 | 218749 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 45 Burlwood Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5996533.16877 | 2095960.73872 | 37.7349101538644 | -122.454421671348 | (37.7349101538644, -122.454421671348) | 9 | 7 | 4 | 59 | 40 | |||
| 58188 | 192049 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013269.50597 | 2110186.98089 | 37.7749179610178 | -122.397555323332 | (37.7749179610178, -122.397555323332) | 14 | 2 | 9 | 28856 | 20 | |
| 59080 | 91155 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 245 Fowler Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/30/2009 12:00:00 AM | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | 9 | 7 | 4 | 59 | 40 | |
| 60465 | 202209 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1988 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6012983.51399 | 2093557.83656 | 37.7292419905249 | -122.39737821176 | (37.7292419905249, -122.39737821176) | 10 | 3 | 8 | 58 | 1 | |||
| 60487 | 101205 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 62493 | 91154 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 245 Fowler Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | 9 | 7 | 4 | 59 | 40 | ||
| 63854 | 202208 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1978 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 6012988.24456 | 2093553.53748 | 37.7292304495144 | -122.397361556292 | (37.7292304495144, -122.397361556292) | 10 | 3 | 8 | 58 | 1 | |||
| 65504 | 218567 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 80 Rossmoor Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5990805.65582 | 2094520.08565 | 37.7306243456255 | -122.474118408742 | (37.7306243456255, -122.474118408742) | 9 | 8 | 4 | 64 | 40 | |||
| 65639 | 101210 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 66752 | 198054 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Illinois St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015996.1825 | 2105236.6253 | 37.7614768097219 | -122.387777607167 | (37.7614768097219, -122.387777607167) | 10 | 3 | 8 | 28856 | 29 | |||
| 67232 | 256000 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 8 Springfield Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/21/2018 12:00:00 AM | 3 | 6x10 | Permit Number 780036 | 5986792.13129 | 2095812.03329 | 37.733938381975 | -122.488088482457 | (37.733938381975, -122.488088482457) | 1 | 8 | 4 | 64 | 35 | |
| 68075 | 136107 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2844 Fillmore St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/30/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781955 | 6002576.03515 | 2117998.39641 | 37.7957648926996 | -122.435105073747 | (37.7957648926996, -122.435105073747) | 13 | 9 | 1 | 57 | 17 | |
| 68869 | 218744 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 141 Cresta Vista Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995904.89403 | 2096229.21076 | 37.7356112608569 | -122.456613232829 | (37.7356112608569, -122.456613232829) | 9 | 7 | 4 | 59 | 40 | |||
| 69069 | 101525 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 630 28th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 15 ft wide public RoW | 6001829 | 2099440 | 37.7447656902201 | -122.436361083968 | (37.7447656902201, -122.436361083968) | 2 | 7 | 5 | 63 | 22 | |||
| 69143 | 214897 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 199 Lomita Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 5991255.59741 | 2104165.1607 | 37.7571332928818 | -122.473266082583 | (37.7571332928818, -122.473266082583) | 1 | 8 | 4 | 56 | 12 | |||
| 69537 | 198051 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 Indiana St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 6015071.52893 | 2101713.75148 | 37.75175248631 | -122.390729432117 | (37.75175248631, -122.390729432117) | 10 | 3 | 8 | 28856 | 1 | |||
| 70031 | 185181 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2500 Sunset Blvd | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5985173.8643 | 2097833.419 | 37.7393940276326 | -122.493832155461 | (37.7393940276326, -122.493832155461) | 1 | 8 | 3 | 29491 | 35 | |||
| 70856 | 198050 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 Indiana St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6015069.99067 | 2101754.678 | 37.7518647765405 | -122.39073761146 | (37.7518647765405, -122.39073761146) | 10 | 3 | 8 | 28856 | 1 | |||
| 71529 | 255511 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 638 Head St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | FUF | 6x15 | 5993525.36191 | 2090091.06114 | 37.7186204962068 | -122.464394601529 | (37.7186204962068, -122.464394601529) | 9 | 8 | 6 | 64 | 24 | |||
| 71774 | 214994 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 776 Ulloa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5993711.57582 | 2098146.88521 | 37.7407505437099 | -122.464335498987 | (37.7407505437099, -122.464335498987) | 1 | 8 | 4 | 59 | 40 | |||
| 72175 | 180262 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 76 Rotteck St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003305.93949 | 2094720.0194 | 37.7318895154806 | -122.430917321302 | (37.7318895154806, -122.430917321302) | 9 | 7 | 5 | 28861 | 25 | |||
| 74958 | 198056 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Illinois St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015997.12564 | 2105199.4171 | 37.7613746962157 | -122.387771748977 | (37.7613746962157, -122.387771748977) | 10 | 3 | 8 | 28856 | 29 | |||
| 75117 | 124094 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 Funston Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5991885.08534 | 2111292.19604 | 37.7767386560308 | -122.47160843755 | (37.7767386560308, -122.47160843755) | 11 | 6 | 2 | 54 | 11 | ||||
| 75161 | 136811 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2509 Pierce St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6001665.7086 | 2117089.02897 | 37.7932162733587 | -122.438189787947 | (37.7932162733587, -122.438189787947) | 13 | 6 | 1 | 29490 | 27 | |||
| 86115 | 180255 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003484.65095 | 2094730.37892 | 37.7319280847153 | -122.4303002173 | (37.7319280847153, -122.4303002173) | 9 | 7 | 5 | 28861 | 25 | |||
| 88667 | 180141 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1118 Russia Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6004021.03877 | 2089333.04789 | 37.717138576267 | -122.428061324472 | (37.717138576267, -122.428061324472) | 9 | 7 | 6 | 28861 | 5 | |||
| 89853 | 180244 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 289 Cayuga Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6002287.23694 | 2094077.32836 | 37.7300670591354 | -122.434393252264 | (37.7300670591354, -122.434393252264) | 9 | 7 | 5 | 28861 | 25 | |||
| 91447 | 136776 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2600 Richardson Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5999020.04225 | 2119778.41485 | 37.8004497840758 | -122.447537603903 | (37.8004497840758, -122.447537603903) | 13 | 9 | 1 | 57 | 17 | ||||
| 92412 | 198046 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 Indiana St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 6015063.38208 | 2101850.3789 | 37.7521271843206 | -122.390767152403 | (37.7521271843206, -122.390767152403) | 10 | 3 | 8 | 28856 | 1 | |||
| 92448 | 242298 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 297 Addison St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6002506.63703 | 2097692.2502 | 37.7400052566372 | -122.433893045753 | (37.7400052566372, -122.433893045753) | 2 | 7 | 5 | 63 | 7 | |||
| 95015 | 218489 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 471 Orizaba Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994001.40662 | 2089639.16253 | 37.7174071201144 | -122.462716356901 | (37.7174071201144, -122.462716356901) | 9 | 8 | 6 | 64 | 24 | |||
| 95669 | 136775 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2600 Francisco St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5999017.84714 | 2119772.04283 | 37.8004321627783 | -122.447544740905 | (37.8004321627783, -122.447544740905) | 13 | 9 | 1 | 57 | 17 | ||||
| 97068 | 136807 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2509 Pierce St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6001660.6114 | 2117127.81463 | 37.7933224788022 | -122.438210204336 | (37.7933224788022, -122.438210204336) | 13 | 6 | 1 | 29490 | 27 | |||
| 98559 | 180251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003572.96144 | 2094730.3764 | 37.7319330795535 | -122.429994909138 | (37.7319330795535, -122.429994909138) | 9 | 7 | 5 | 28861 | 25 | |||
| 101478 | 198253 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1000 Oakdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6018226.96048 | 2093133.19997 | 37.7283665652516 | -122.3792214842 | (37.7283665652516, -122.3792214842) | 10 | 3 | 8 | 58 | 1 | ||||
| 102697 | 192050 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013285.99525 | 2110202.74852 | 37.774962173497 | -122.397499389085 | (37.774962173497, -122.397499389085) | 14 | 2 | 9 | 28856 | 20 | |
| 107696 | 179993 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1297 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6007905.78975 | 2087167.109 | 37.7114103831536 | -122.414480370891 | (37.7114103831536, -122.414480370891) | 9 | 7 | 8 | 309 | 39 | |||
| 107722 | 180320 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 817 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6001210.40568 | 2092189.73212 | 37.7248229683925 | -122.437980831368 | (37.7248229683925, -122.437980831368) | 9 | 7 | 6 | 28861 | 25 | |||
| 108982 | 91159 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 245 Fowler Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/30/2009 12:00:00 AM | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | 9 | 7 | 4 | 59 | 40 | |
| 112876 | 180326 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 467 Capistrano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6000881.2183 | 2092142.07592 | 37.7246733895406 | -122.439115376482 | (37.7246733895406, -122.439115376482) | 9 | 7 | 6 | 28861 | 25 | ||||
| 113325 | 241422 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 687 28th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6001495.68949 | 2099380.02037 | 37.7445820558098 | -122.437509311417 | (37.7445820558098, -122.437509311417) | 2 | 7 | 5 | 63 | 22 | |||
| 114741 | 180263 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 Still St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003281.32559 | 2094718.10689 | 37.7318828694844 | -122.431002280233 | (37.7318828694844, -122.431002280233) | 9 | 7 | 5 | 28861 | 25 | |||
| 121011 | 198047 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 Indiana St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 7ft | 6015066.24104 | 2101813.84862 | 37.7520270385183 | -122.390754712971 | (37.7520270385183, -122.390754712971) | 10 | 3 | 8 | 28856 | 1 | |||
| 123036 | 241423 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 630 28th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6001786.54168 | 2099450.84639 | 37.7447930592582 | -122.436508672655 | (37.7447930592582, -122.436508672655) | 2 | 7 | 5 | 63 | 22 | |||
| 123551 | 214895 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 199 Lomita Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5991278.31882 | 2104203.15861 | 37.7572389407347 | -122.473190275108 | (37.7572389407347, -122.473190275108) | 1 | 8 | 4 | 56 | 12 | |||
| 124953 | 214896 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 199 Lomita Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5991273.67519 | 2104194.37709 | 37.7572145601258 | -122.473205694003 | (37.7572145601258, -122.473205694003) | 1 | 8 | 4 | 56 | 12 | |||
| 125124 | 198060 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Illinois St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 9ft | 6016003.71174 | 2105110.97053 | 37.7611322056943 | -122.387742798886 | (37.7611322056943, -122.387742798886) | 10 | 3 | 8 | 28856 | 29 | |||
| 125382 | 136774 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2600 Francisco St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5999022.27584 | 2119774.26108 | 37.8004385065862 | -122.447529575653 | (37.8004385065862, -122.447529575653) | 13 | 9 | 1 | 57 | 17 | ||||
| 125712 | 91156 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 245 Fowler Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | 9 | 7 | 4 | 59 | 40 | ||
| 131546 | 180261 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 81 Rotteck St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003329.74924 | 2094722.2171 | 37.7318968989209 | -122.430835162816 | (37.7318968989209, -122.430835162816) | 9 | 7 | 5 | 28861 | 25 | |||
| 132602 | 218449 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 360 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5998375.26262 | 2094122.26977 | 37.7299676265075 | -122.447920614357 | (37.7299676265075, -122.447920614357) | 9 | 7 | 4 | 28861 | 40 | |||
| 133869 | 218743 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 141 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 07/06/1988 12:00:00 AM | 8 | Width 3ft | Permit Number 25334 | 5995930.53241 | 2096235.39856 | 37.7356297230374 | -122.456525038998 | (37.7356297230374, -122.456525038998) | 9 | 7 | 4 | 59 | 40 | |
| 135240 | 192047 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013240.39967 | 2110155.04551 | 37.7748286529654 | -122.397653768512 | (37.7748286529654, -122.397653768512) | 14 | 2 | 9 | 28856 | 20 | |
| 136187 | 185177 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2500 Sunset Blvd | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5985174.5283 | 2097805.5293 | 37.7393174888485 | -122.49382780495 | (37.7393174888485, -122.49382780495) | 1 | 8 | 3 | 29491 | 35 | |||
| 137461 | 198068 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 Illinois St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6016017.70443 | 2106165.43113 | 37.7640283032988 | -122.387767979012 | (37.7640283032988, -122.387767979012) | 14 | 3 | 8 | 310 | 29 | ||||
| 139717 | 180243 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 289 Cayuga Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6002278.84858 | 2094070.11762 | 37.7300467839328 | -122.43442173649 | (37.7300467839328, -122.43442173649) | 9 | 7 | 5 | 28861 | 25 | |||
| 141630 | 91153 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 245 Fowler Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/30/2009 12:00:00 AM | 3 | 10x90 | Permit Number 52034 | 5997288.6 | 2099113.8 | 37.743610991306 | -122.452037308764 | (37.743610991306, -122.452037308764) | 9 | 7 | 4 | 59 | 40 | |
| 142586 | 180142 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1118 Russia Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6004028.1507 | 2089329.03946 | 37.7171279723626 | -122.428036456426 | (37.7171279723626, -122.428036456426) | 9 | 7 | 6 | 28861 | 5 | |||
| 146864 | 242299 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 158 Everson St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6002812.35302 | 2097377.01993 | 37.739157051169 | -122.432813493262 | (37.739157051169, -122.432813493262) | 2 | 7 | 5 | 63 | 7 | |||
| 148512 | 101206 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 149690 | 198057 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Illinois St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015999.46733 | 2105182.54146 | 37.7613284890375 | -122.387762472475 | (37.7613284890375, -122.387762472475) | 10 | 3 | 8 | 28856 | 29 | |||
| 151335 | 101212 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 151502 | 180253 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003528.91801 | 2094729.13365 | 37.7319271727957 | -122.430147087941 | (37.7319271727957, -122.430147087941) | 9 | 7 | 5 | 28861 | 25 | |||
| 151529 | 180258 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003421.15336 | 2094728.39885 | 37.7319190510051 | -122.430519600598 | (37.7319190510051, -122.430519600598) | 9 | 7 | 5 | 28861 | 25 | |||
| 152594 | 198049 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 Indiana St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 6015069.63855 | 2101758.53914 | 37.7518753588787 | -122.390739098952 | (37.7518753588787, -122.390739098952) | 10 | 3 | 8 | 28856 | 1 | |||
| 153163 | 198055 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Illinois St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015997.74921 | 2105213.0549 | 37.7614121772375 | -122.387770543876 | (37.7614121772375, -122.387770543876) | 10 | 3 | 8 | 28856 | 29 | |||
| 159151 | 218558 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 55 Rossmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5990953.73418 | 2094508.65771 | 37.7306015442135 | -122.47360565129 | (37.7306015442135, -122.47360565129) | 9 | 8 | 4 | 64 | 40 | |||
| 159457 | 180252 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003553.26198 | 2094731.05162 | 37.7319338178795 | -122.430063062478 | (37.7319338178795, -122.430063062478) | 9 | 7 | 5 | 28861 | 25 | |||
| 164677 | 242288 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 521 30th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6003236.82693 | 2098315.43327 | 37.7417577834996 | -122.431412827037 | (37.7417577834996, -122.431412827037) | 2 | 7 | 5 | 63 | 7 | |||
| 164784 | 180264 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 Still St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003250.76202 | 2094715.77972 | 37.7318747477193 | -122.431107778807 | (37.7318747477193, -122.431107778807) | 9 | 7 | 5 | 28861 | 25 | |||
| 165097 | 136808 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2509 Pierce St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6001661.89951 | 2117116.97181 | 37.7932927804972 | -122.438204970286 | (37.7932927804972, -122.438204970286) | 13 | 6 | 1 | 29490 | 27 | |||
| 165106 | 241532 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Collingwood St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6002143.4753 | 2103472.95674 | 37.7558570955525 | -122.435562150599 | (37.7558570955525, -122.435562150599) | 2 | 4 | 5 | 28862 | 22 |
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) );