trees
406 rows where qSpecies_id = 110 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 110847 | 240009 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/28/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782632 | 6003475.02148 | 2105636.19313 | 37.7618723639267 | -122.431111627899 | (37.7618723639267, -122.431111627899) | 15 | 4 | 5 | 28862 | 3 |
| 154653 | 240010 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1 Ford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/28/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782632 | 6003488.35732 | 2105638.42156 | 37.7618792383441 | -122.431065663574 | (37.7618792383441, -122.431065663574) | 15 | 4 | 5 | 28862 | 3 |
| 52479 | 221633 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6004094.26555 | 2103005.18329 | 37.7546833058068 | -122.428782337947 | (37.7546833058068, -122.428782337947) | 2 | 4 | 5 | 28862 | 22 | |||
| 92782 | 86620 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1000x Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010457.56671 | 2109345.42379 | 37.7724502653908 | -122.407223128867 | (37.7724502653908, -122.407223128867) | 14 | 2 | 9 | 28853 | 34 | ||
| 167940 | 221629 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1013 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002523.57066 | 2102515.34708 | 37.7532493089089 | -122.434179203726 | (37.7532493089089, -122.434179203726) | 2 | 4 | 5 | 28862 | 22 | |||
| 55082 | 108822 | Section 143 10 | Acer buergeranum :: Trident Maple 110 | 101x FREMONT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6013648.6 | 2115847.1 | 37.7904804500674 | -122.396640813258 | (37.7904804500674, -122.396640813258) | 12 | 2 | 9 | 28855 | 6 | ||||
| 62944 | 108821 | Section 143 10 | Acer buergeranum :: Trident Maple 110 | 101x FREMONT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2015 12:00:00 AM | 3 | 5x5 | Permit Number 774616 | 6013648.6 | 2115847.1 | 37.7904804500674 | -122.396640813258 | (37.7904804500674, -122.396640813258) | 12 | 2 | 9 | 28855 | 6 | |
| 193590 | 108823 | Section 143 10 | Acer buergeranum :: Trident Maple 110 | 101x FREMONT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6013648.6 | 2115847.1 | 37.7904804500674 | -122.396640813258 | (37.7904804500674, -122.396640813258) | 12 | 2 | 9 | 28855 | 6 | ||||
| 15624 | 187814 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1020 Le Conte Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 2ft | 6013124.66356 | 2089609.91274 | 37.718409647453 | -122.396613602732 | (37.718409647453, -122.396613602732) | 10 | 3 | 8 | 58 | 1 | |||
| 63829 | 187815 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1020 Le Conte Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 2ft | 6013104.71933 | 2089623.63357 | 37.7184462121049 | -122.396683503446 | (37.7184462121049, -122.396683503446) | 10 | 3 | 8 | 58 | 1 | |||
| 85931 | 187816 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1020 Le Conte Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 2ft | 6013083.51747 | 2089639.65326 | 37.7184890189273 | -122.396757912441 | (37.7184890189273, -122.396757912441) | 10 | 3 | 8 | 58 | 1 | |||
| 4565 | 187804 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1022 Minna St | 8 | : | Tree | Private 2 | 3 | Width 3ft | 6007516.81394 | 2109678.2468 | 37.7731990993886 | -122.417419096312 | (37.7731990993886, -122.417419096312) | 8 | 2 | 9 | 28853 | 19 | |||
| 93973 | 187803 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1022 Minna St | 7 | : | Tree | Private 2 | 3 | Width 3ft | 6007519.60902 | 2109677.84071 | 37.7731981416251 | -122.417409398951 | (37.7731981416251, -122.417409398951) | 8 | 2 | 9 | 28853 | 19 | |||
| 159883 | 187805 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1022 Minna St | 9 | : | Tree | Private 2 | 3 | Width 3ft | 6007514.25506 | 2109673.06496 | 37.7731847273119 | -122.417427580535 | (37.7731847273119, -122.417427580535) | 8 | 2 | 9 | 28853 | 19 | |||
| 164333 | 187802 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1022 Minna St | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6007522.48988 | 2109681.62001 | 37.7732086807745 | -122.417399701534 | (37.7732086807745, -122.417399701534) | 8 | 2 | 9 | 28853 | 19 | |||
| 193917 | 187801 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1022 Minna St | 5 | : | Tree | Private 2 | 3 | Width 3ft | 6007525.39905 | 2109686.79434 | 37.7732230519369 | -122.417390005067 | (37.7732230519369, -122.417390005067) | 8 | 2 | 9 | 28853 | 19 | |||
| 187236 | 39587 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1028 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773106 | 6011879.4313 | 2103580.86378 | 37.7567015481622 | -122.401899435531 | (37.7567015481622, -122.401899435531) | 10 | 3 | 8 | 28856 | 29 |
| 95571 | 40819 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1040 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2004 12:00:00 AM | 8 | 3x3 | Permit Number 47715 | 6010221.45597 | 2111748.63053 | 37.7790356940769 | -122.40820938835 | (37.7790356940769, -122.40820938835) | 14 | 2 | 9 | 28853 | 34 | |
| 72312 | 221632 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1045 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003827.60048 | 2102209.17649 | 37.7524825622315 | -122.429647769055 | (37.7524825622315, -122.429647769055) | 2 | 4 | 5 | 28862 | 22 | |||
| 143963 | 175080 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 105 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001743.47572 | 2090827.16461 | 37.7211119654402 | -122.436040617777 | (37.7211119654402, -122.436040617777) | 9 | 7 | 6 | 28861 | 5 | |||
| 154200 | 83369 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1055 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2014 12:00:00 AM | 1 | Permit Number 772823 | 6012226.74604 | 2103450.91527 | 37.7563641153385 | -122.400689158504 | (37.7563641153385, -122.400689158504) | 10 | 3 | 8 | 28856 | 29 | |
| 8476 | 86613 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1060 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010229.12599 | 2109123.99636 | 37.7718294894697 | -122.407997713136 | (37.7718294894697, -122.407997713136) | 14 | 2 | 9 | 28853 | 34 | ||
| 84131 | 221625 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1060 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007407.13697 | 2101163.221 | 37.7498126414567 | -122.417194987975 | (37.7498126414567, -122.417194987975) | 2 | 4 | 7 | 28859 | 19 | |||
| 58173 | 221626 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1062 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007406.75349 | 2101144.50432 | 37.7497612281125 | -122.417194987955 | (37.7497612281125, -122.417194987955) | 2 | 4 | 7 | 28859 | 19 | |||
| 113546 | 125329 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1075 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008994.54084 | 2117986.90274 | 37.7960957056184 | -122.412894974939 | (37.7960957056184, -122.412894974939) | 3 | 1 | 10 | 308 | 21 | |||
| 120669 | 32979 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1078 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 5 | Permit Number 37292 | 6015506.57798 | 2104082.98749 | 37.758282033796 | -122.389390396476 | (37.758282033796, -122.389390396476) | 10 | 3 | 8 | 28856 | 29 | |
| 20348 | 86615 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1090 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/03/2011 12:00:00 AM | 3 | 3x3 | 6010138.02723 | 2109041.45906 | 37.7715977602665 | -122.40830700887 | (37.7715977602665, -122.40830700887) | 14 | 2 | 9 | 28853 | 34 | ||
| 78782 | 86617 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1090 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010113.47615 | 2109019.50593 | 37.7715361072268 | -122.408390384123 | (37.7715361072268, -122.408390384123) | 14 | 2 | 9 | 28853 | 34 | ||
| 81599 | 86619 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1090 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010092.09688 | 2109000.58526 | 37.7714829581888 | -122.408463001672 | (37.7714829581888, -122.408463001672) | 14 | 2 | 9 | 28853 | 34 | ||
| 101082 | 86616 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1090 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010124.54627 | 2109028.57121 | 37.7715616183058 | -122.408352731315 | (37.7715616183058, -122.408352731315) | 14 | 2 | 9 | 28853 | 34 | ||
| 162740 | 86618 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1090 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010101.61266 | 2109009.68223 | 37.7715084692605 | -122.408430727721 | (37.7715084692605, -122.408430727721) | 14 | 2 | 9 | 28853 | 34 | ||
| 55621 | 42196 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1102 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | Permit Number 42472 | 6009955.25206 | 2108867.50993 | 37.7711098996337 | -122.408926966424 | (37.7711098996337, -122.408926966424) | 8 | 2 | 9 | 28853 | 34 | |
| 89918 | 42197 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1102 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 2 | Permit Number 42472 | 6009958.13472 | 2108871.8243 | 37.7711219073685 | -122.408917299608 | (37.7711219073685, -122.408917299608) | 8 | 2 | 9 | 28853 | 34 | |
| 12384 | 149800 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1155 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6015047.89525 | 2103254.40668 | 37.7559814870696 | -122.390918826658 | (37.7559814870696, -122.390918826658) | 10 | 3 | 8 | 28856 | 29 | |||
| 185151 | 40153 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1175 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 3 | Permit Number 42703 | 6007420.25533 | 2118807.46679 | 37.7982602766535 | -122.418400539955 | (37.7982602766535, -122.418400539955) | 5 | 1 | 10 | 28858 | 32 | |
| 36009 | 72129 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1183 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 6012255.77606 | 2102909.56429 | 37.7548793031435 | -122.400550735745 | (37.7548793031435, -122.400550735745) | 10 | 3 | 8 | 28856 | 29 | ||
| 135896 | 114985 | Planning Code 138.1 required 2 | Acer buergeranum :: Trident Maple 110 | 1188 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | Permit Number 773128 | 6003158.9 | 2101346.9 | 37.7500770674438 | -122.43189868142 | (37.7500770674438, -122.43189868142) | 2 | 4 | 5 | 28862 | 22 | |||
| 142090 | 221630 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1188 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003175.61372 | 2101336.19411 | 37.7500486190657 | -122.431840120148 | (37.7500486190657, -122.431840120148) | 2 | 4 | 5 | 28862 | 22 | |||
| 97200 | 255579 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1190 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779634 | 6008996.02698 | 2117368.14655 | 37.794396836513 | -122.412846064643 | (37.794396836513, -122.412846064643) | 3 | 1 | 10 | 28857 | 21 | |
| 109406 | 255578 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1190 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779634 | 6008996.02698 | 2117368.14655 | 37.794396836513 | -122.412846064643 | (37.794396836513, -122.412846064643) | 3 | 1 | 10 | 28857 | 21 | |
| 44232 | 254806 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1199 Sanchez St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779042 | 6003870.87143 | 2101301.44093 | 37.7499925830654 | -122.429433403164 | (37.7499925830654, -122.429433403164) | 2 | 4 | 5 | 28862 | 22 | |
| 105052 | 254805 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1199 Sanchez St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779042 | 6003870.87143 | 2101301.44093 | 37.7499925830654 | -122.429433403164 | (37.7499925830654, -122.429433403164) | 2 | 4 | 5 | 28862 | 22 | |
| 190841 | 221587 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1208 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010276.83998 | 2102096.75701 | 37.7525369514393 | -122.407337185386 | (37.7525369514393, -122.407337185386) | 2 | 4 | 7 | 28859 | 19 | |||
| 83118 | 114545 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1219 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 2 | Permit Number 772772 | 6011988.90891 | 2102695.16148 | 37.7542757132549 | -122.401458575266 | (37.7542757132549, -122.401458575266) | 10 | 3 | 8 | 28856 | 29 | ||
| 13281 | 61790 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1249 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1985 12:00:00 AM | 5 | Permit Number 21813 | 6011995.77759 | 2102561.7862 | 37.7539098771551 | -122.401425448751 | (37.7539098771551, -122.401425448751) | 10 | 3 | 8 | 28856 | 29 | |
| 16729 | 203303 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1256 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5994883.99772 | 2106952.30042 | 37.7649954872656 | -122.460919765941 | (37.7649954872656, -122.460919765941) | 15 | 5 | 11 | 56 | 12 | |||
| 45621 | 221605 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 126 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007327.7514 | 2096972.1243 | 37.7383003605723 | -122.417172563378 | (37.7383003605723, -122.417172563378) | 2 | 7 | 7 | 28859 | 2 | |||
| 12613 | 260641 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 1278 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004430 | 2101447 | 37.7504238948486 | -122.427510275493 | (37.7504238948486, -122.427510275493) | 2 | 4 | 5 | 28862 | 22 | ||||
| 169808 | 254825 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1278 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781640 | 6004467.99728 | 2101448.30969 | 37.7504296400347 | -122.427378971399 | (37.7504296400347, -122.427378971399) | 2 | 4 | 5 | 28862 | 22 |
| 14341 | 165739 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 129 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6007603.82454 | 2098022.48872 | 37.7411999565157 | -122.416292409479 | (37.7411999565157, -122.416292409479) | 2 | 7 | 7 | 28859 | 2 | |||
| 38384 | 221588 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1298 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010295.88664 | 2101729.17377 | 37.751528715192 | -122.407245408661 | (37.751528715192, -122.407245408661) | 2 | 4 | 7 | 28859 | 19 | |||
| 44546 | 221589 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1298 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010298.25709 | 2101707.85409 | 37.7514703087269 | -122.407235708582 | (37.7514703087269, -122.407235708582) | 2 | 4 | 7 | 28859 | 19 | |||
| 7412 | 171245 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 130 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 4ft | 6003958.26769 | 2093062.28889 | 37.7273746984644 | -122.428543965437 | (37.7273746984644, -122.428543965437) | 9 | 7 | 6 | 28861 | 5 | ||
| 185563 | 255577 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1302 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779634 | 6008965.40911 | 2117359.87271 | 37.7943723999461 | -122.41295142124 | (37.7943723999461, -122.41295142124) | 3 | 1 | 10 | 28857 | 21 |
| 149809 | 125331 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 133 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012433.64101 | 2119151.44833 | 37.7994857099489 | -122.40107679955 | (37.7994857099489, -122.40107679955) | 3 | 1 | 10 | 28860 | 6 | |||
| 158784 | 125333 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 133 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012493.13402 | 2119160.53204 | 37.7995139702525 | -122.400871569787 | (37.7995139702525, -122.400871569787) | 3 | 1 | 10 | 28860 | 6 | |||
| 159319 | 125332 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 133 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012465.96545 | 2119155.6928 | 37.799499167399 | -122.400965243151 | (37.799499167399, -122.400965243151) | 3 | 1 | 10 | 28860 | 6 | |||
| 46794 | 125330 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1335 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007763.34926 | 2117482.29154 | 37.7946409829411 | -122.417119380172 | (37.7946409829411, -122.417119380172) | 5 | 1 | 10 | 28858 | 32 | |||
| 97697 | 175090 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 137 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000668.43551 | 2092436.91423 | 37.7254708381835 | -122.439872067837 | (37.7254708381835, -122.439872067837) | 9 | 7 | 6 | 28861 | 25 | |||
| 83540 | 9618 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1400 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2018 12:00:00 AM | 3 | 3X3 | Permit Number 782015 | 6002831.8444 | 2112032.7875 | 37.7793993714118 | -122.433793329826 | (37.7793993714118, -122.433793329826) | 15 | 5 | 11 | 29490 | 41 | |
| 190528 | 9621 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1402 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2018 12:00:00 AM | 3 | 3X3 | Permit Number 782015 | 6002809.5086 | 2112030.0801 | 37.779390670103 | -122.43387040511 | (37.779390670103, -122.43387040511) | 15 | 5 | 11 | 29490 | 41 | |
| 133365 | 9622 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1404 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2018 12:00:00 AM | 3 | 3X3 | Permit Number 782015 | 6002793.2644 | 2112026.6959 | 37.7793804561129 | -122.433926358604 | (37.7793804561129, -122.433926358604) | 15 | 5 | 11 | 29490 | 41 | |
| 94410 | 203298 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1405 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992698.71061 | 2105851.9736 | 37.7618482944917 | -122.468398003763 | (37.7618482944917, -122.468398003763) | 1 | 8 | 4 | 56 | 12 | |||
| 120521 | 203297 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1405 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992697.6604 | 2105877.83419 | 37.7619192402087 | -122.468403517504 | (37.7619192402087, -122.468403517504) | 1 | 8 | 4 | 56 | 12 | |||
| 9861 | 259369 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1415 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6015886.92436 | 2093428.61021 | 37.729048386007 | -122.387331768509 | (37.729048386007, -122.387331768509) | 10 | 3 | 8 | 58 | 1 | ||
| 158573 | 50684 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 143 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | Permit Number 47256 | 6007969.07490995 | 2097962.19651327 | 37.7410549393222 | -122.415025233758 | (37.7410549393222, -122.415025233758) | 2 | 7 | 7 | 28859 | 2 | |||
| 122947 | 4842 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 144 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/20/2003 12:00:00 AM | 3 | 4X4 | 6006504.57355 | 2097544.92188 | 37.7398267906861 | -122.420059351163 | (37.7398267906861, -122.420059351163) | 2 | 7 | 7 | 28859 | 2 | ||
| 175233 | 64715 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 144 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2005 12:00:00 AM | Permit Number 25667 | 6006489.13363316 | 2097549.49596669 | 37.7398384801749 | -122.420113060533 | (37.7398384801749, -122.420113060533) | 2 | 7 | 7 | 28859 | 2 | ||
| 135270 | 254842 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 145 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 5993002 | 2114530 | 37.7856933397401 | -122.467980297479 | (37.7856933397401, -122.467980297479) | 11 | 6 | 2 | 54 | 11 | |
| 97105 | 187808 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 145 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2019 12:00:00 AM | 3 | Width 5ft | 6013749.71831 | 2115764.74251 | 37.7902599427975 | -122.396285173032 | (37.7902599427975, -122.396285173032) | 12 | 2 | 9 | 28855 | 6 | ||
| 70425 | 221597 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1485 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003972.05422 | 2099640.99596 | 37.7454391151181 | -122.428965139531 | (37.7454391151181, -122.428965139531) | 2 | 7 | 5 | 63 | 22 | |||
| 140397 | 95399 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1485 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767273 | 6003966 | 2099628 | 37.7454030885252 | -122.42898514766 | (37.7454030885252, -122.42898514766) | 2 | 7 | 5 | 63 | 22 |
| 161312 | 30648 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 15 Lafayette St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34588 | 6007479.30687 | 2109694.71788 | 37.7732422146752 | -122.417550006149 | (37.7732422146752, -122.417550006149) | 8 | 2 | 9 | 28853 | 19 |
| 18232 | 187807 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1501 25th St | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014157.8907 | 2101958.46235 | 37.7523736777015 | -122.393906067809 | (37.7523736777015, -122.393906067809) | 10 | 3 | 8 | 28856 | 1 | ||||
| 62176 | 158618 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 151 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781235 | 6000399.06528 | 2094337.95711 | 37.7306753264052 | -122.440939570324 | (37.7306753264052, -122.440939570324) | 9 | 7 | 4 | 63 | 40 |
| 106565 | 81273 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 1525 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2003 12:00:00 AM | 4 | 3x3 | 6008409.48076779 | 2109046.83588112 | 37.7715155784821 | -122.414286550731 | (37.7715155784821, -122.414286550731) | 8 | 2 | 9 | 28853 | 19 | ||
| 43101 | 200960 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1527 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6008413.1986 | 2109048.8424 | 37.7715212967515 | -122.414273832498 | (37.7715212967515, -122.414273832498) | 8 | 2 | 9 | 28853 | 19 | |||
| 170738 | 200959 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1527 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6008393.6527 | 2109024.2847 | 37.7714527691166 | -122.414339705165 | (37.7714527691166, -122.414339705165) | 8 | 2 | 9 | 28853 | 19 | |||
| 858 | 136518 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 153 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6013525.33028 | 2117958.01087 | 37.7962696533665 | -122.397215406586 | (37.7962696533665, -122.397215406586) | 3 | 1 | 10 | 28860 | 6 | |||
| 36079 | 32938 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1530 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 6 | Permit Number 37258 | 6013021.62102 | 2105688.27422 | 37.7625517136065 | -122.398097141493 | (37.7625517136065, -122.398097141493) | 14 | 3 | 8 | 28856 | 29 | |
| 126277 | 110029 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1531 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775205 | 5992093.6 | 2105006.6 | 37.7594921516048 | -122.470429253084 | (37.7594921516048, -122.470429253084) | 1 | 8 | 4 | 56 | 12 |
| 134328 | 203304 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1531 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992105.89675 | 2105003.70672 | 37.7594849184085 | -122.470386514529 | (37.7594849184085, -122.470386514529) | 1 | 8 | 4 | 56 | 12 | |||
| 51860 | 51384 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1535 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2004 12:00:00 AM | 5 | 3x3 | Permit Number 47713 | 6008370.90757832 | 2109003.97067657 | 37.7713957138636 | -122.41441694433 | (37.7713957138636, -122.41441694433) | 8 | 2 | 9 | 28853 | 19 | |
| 134573 | 51383 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1535 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2004 12:00:00 AM | Permit Number 47713 | 6008370.90757832 | 2109003.97067657 | 37.7713957138636 | -122.41441694433 | (37.7713957138636, -122.41441694433) | 8 | 2 | 9 | 28853 | 19 | |||
| 189774 | 182405 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1543 34th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985575.3942 | 2104706.1132 | 37.7582880604292 | -122.492949973167 | (37.7582880604292, -122.492949973167) | 1 | 8 | 3 | 56 | 35 | |||
| 15286 | 30757 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1553 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2020 12:00:00 AM | 11 | Permit Number 34638 | 6014989.6074 | 2093734.2507 | 37.7298378772398 | -122.390455236274 | (37.7298378772398, -122.390455236274) | 10 | 3 | 8 | 58 | 1 | |
| 102584 | 221592 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1555 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010533.99072 | 2100457.08761 | 37.7480491689492 | -122.406332389938 | (37.7480491689492, -122.406332389938) | 2 | 7 | 7 | 28859 | 2 | |||
| 179140 | 82695 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1555-1557 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50231 | 6010513.29558366 | 2100547.672123 | 37.7482967364932 | -122.406410335122 | (37.7482967364932, -122.406410335122) | 2 | 7 | 7 | 28859 | 2 | ||
| 7124 | 240695 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 156 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/31/2018 12:00:00 AM | 3 | Width 3ft | 6004515.89032 | 2108795.08829 | 37.7706048583673 | -122.42773675377 | (37.7706048583673, -122.42773675377) | 7 | 9 | 11 | 28852 | 10 | |
| 175008 | 52160 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1565 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52359 | 6015412.30091 | 2096564.37197 | 37.7376322578292 | -122.389191461922 | (37.7376322578292, -122.389191461922) | 10 | 3 | 8 | 58 | 1 | |
| 25746 | 220337 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1606 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002558.37947 | 2100838.96388 | 37.7486483332527 | -122.433939010086 | (37.7486483332527, -122.433939010086) | 2 | 4 | 5 | 28862 | 22 | |||
| 131930 | 220338 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1606 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002559.21572 | 2100822.56122 | 37.7486033428715 | -122.433934946057 | (37.7486033428715, -122.433934946057) | 2 | 4 | 5 | 28862 | 22 | |||
| 87260 | 221616 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 162 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001900.71778 | 2096497.17148 | 37.7366894445647 | -122.435902572748 | (37.7366894445647, -122.435902572748) | 2 | 7 | 5 | 63 | 7 | |||
| 3662 | 154048 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1655 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6014874.64448 | 2096968.67917 | 37.7387125819245 | -122.391078663176 | (37.7387125819245, -122.391078663176) | 10 | 3 | 8 | 58 | 1 | |||
| 12309 | 36034 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1660X BRYANT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | 4 | Permit Number 39178 | 6009346 | 2106886 | 37.7656349852358 | -122.410894426294 | (37.7656349852358, -122.410894426294) | 8 | 4 | 7 | 28853 | 19 | |
| 187247 | 36036 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1660X BRYANT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39178 | 6009450 | 2107109 | 37.7662531230435 | -122.410550460301 | (37.7662531230435, -122.410550460301) | 8 | 4 | 7 | 28853 | 19 |
| 19253 | 154044 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1671 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x4 | 6014806.60938 | 2097019.04115 | 37.738847089929 | -122.391317417882 | (37.738847089929, -122.391317417882) | 10 | 3 | 8 | 58 | 1 | |||
| 62467 | 221591 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1705 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009346.65041 | 2099513.2038 | 37.745390981613 | -122.410371547427 | (37.745390981613, -122.410371547427) | 2 | 7 | 7 | 28859 | 2 | |||
| 92323 | 87083 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1711 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781930 | 6000537.4917 | 2114630.4681 | 37.7864014751637 | -122.441916937328 | (37.7864014751637, -122.441916937328) | 13 | 6 | 1 | 29490 | 27 | |
| 35151 | 92974 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1739 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2010 12:00:00 AM | Permit Number 53130 | 6001710 | 2112178 | 37.7797343655013 | -122.437684657223 | (37.7797343655013, -122.437684657223) | 15 | 5 | 11 | 29490 | 41 |
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) );