trees
406 rows where qSpecies_id = 110 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194258 | 175137 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1802 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | Width 4ft | Permit Number 785586 | 6001243.74865 | 2091600.63197 | 37.7232073291514 | -122.437823395139 | (37.7232073291514, -122.437823395139) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | |||
| 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 | ||||
| 192502 | 125325 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2400 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6003273.61956 | 2115917.5849 | 37.7900911040648 | -122.432542603966 | (37.7900911040648, -122.432542603966) | 13 | 9 | 1 | 29490 | 27 | |||
| 192375 | 95820 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 266 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767557 | 6009763.87551 | 2108880.1615 | 37.7711339160337 | -122.409589840524 | (37.7711339160337, -122.409589840524) | 8 | 2 | 9 | 28853 | 34 |
| 191513 | 221648 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2010 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004071.5645 | 2107189.70142 | 37.766171710583 | -122.429159195237 | (37.766171710583, -122.429159195237) | 8 | 4 | 5 | 28862 | 3 | |||
| 191148 | 1164 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2849X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5997509.53468 | 2087964.66518 | 37.7130107600005 | -122.450469794845 | (37.7130107600005, -122.450469794845) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | |||
| 190676 | 187792 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 474 Bryant St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6013963.38885 | 2112691.55929 | 37.7818335775918 | -122.395330507617 | (37.7818335775918, -122.395330507617) | 6 | 2 | 9 | 28856 | 6 | |||
| 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 | |
| 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 | |||
| 189372 | 221575 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 98 Elgin Park | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6005819.47243 | 2108576.64689 | 37.7700787243885 | -122.423212112556 | (37.7700787243885, -122.423212112556) | 8 | 2 | 5 | 28853 | 19 | |||
| 188184 | 32219 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 544 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | 4 | Permit Number 48561 | 6009486.27914 | 2100215.48999 | 37.7473271311603 | -122.409938299007 | (37.7473271311603, -122.409938299007) | 2 | 7 | 7 | 28859 | 2 | |
| 188099 | 175083 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 3143 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5996140.52774 | 2087004.46938 | 37.7102958353443 | -122.455132166333 | (37.7102958353443, -122.455132166333) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 |
| 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 |
| 186520 | 81759 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 461 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2003 12:00:00 AM | 4 | 3x3 | 6007414.19918083 | 2097287.04503193 | 37.7391699263071 | -122.416895974515 | (37.7391699263071, -122.416895974515) | 2 | 7 | 7 | 28859 | 2 | ||
| 185582 | 198911 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 631 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Width 5ft | 6011003.91473 | 2105261.92736 | 37.7612684727711 | -122.405045669642 | (37.7612684727711, -122.405045669642) | 10 | 3 | 8 | 28856 | 29 | ||
| 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 |
| 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 | |
| 185040 | 41281 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 850 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2013 12:00:00 AM | 1 | Permit Number 770203 | 6012419.16584 | 2119105.18058 | 37.79935786234 | -122.401123636248 | (37.79935786234, -122.401123636248) | 3 | 1 | 10 | 28860 | 6 | ||
| 184161 | 255528 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 245 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6002749.62849 | 2109376.39797 | 37.7721009206767 | -122.433887824362 | (37.7721009206767, -122.433887824362) | 15 | 5 | 11 | 29492 | 9 | |||
| 183961 | 187795 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 660 Bryant St | 5 | : | Tree | Private 2 | 6 | Width 3ft | 6012596.8957 | 2111389.55131 | 37.7781824694894 | -122.399966507348 | (37.7781824694894, -122.399966507348) | 6 | 2 | 9 | 28856 | 34 | |||
| 183517 | 221628 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 4000 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001765.60614 | 2102951.60804 | 37.7544041283635 | -122.436831622779 | (37.7544041283635, -122.436831622779) | 2 | 4 | 5 | 28862 | 22 | |||
| 183238 | 187818 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 205 Salinas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6012618.73899 | 2090601.35029 | 37.7211037654109 | -122.398431913204 | (37.7211037654109, -122.398431913204) | 10 | 3 | 8 | 58 | 1 | |||
| 182747 | 256564 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 2501 California St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002352 | 2115365 | 37.7885215412843 | -122.435691777518 | (37.7885215412843, -122.435691777518) | 13 | 6 | 1 | 29490 | 27 | |||||
| 180478 | 203307 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2675 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991740.25886 | 2097238.14622 | 37.7381415510917 | -122.471085316559 | (37.7381415510917, -122.471085316559) | 1 | 8 | 4 | 29491 | 40 | |||
| 180123 | 187797 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 703 Bryant St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012415.74144 | 2111222.32214 | 37.7777131951528 | -122.400581439494 | (37.7777131951528, -122.400581439494) | 14 | 2 | 9 | 28856 | 34 | |||
| 179701 | 109056 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 340 Hanover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772773 | 5999449.8 | 2086496.1 | 37.7090892698694 | -122.443658181084 | (37.7090892698694, -122.443658181084) | 9 | 7 | 6 | 28861 | 5 |
| 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 | ||
| 178500 | 221635 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 378 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003552.28463 | 2106090.63355 | 37.7631245259893 | -122.430876838313 | (37.7631245259893, -122.430876838313) | 15 | 4 | 5 | 28862 | 3 | |||
| 177136 | 111059 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1851 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | 8 | 4 | 8 | 28859 | 19 | ||||
| 177085 | 255878 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 690x Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6012554 | 2111333 | 37.7780248009388 | -122.400110927552 | (37.7780248009388, -122.400110927552) | 6 | 2 | 9 | 28856 | 34 | ||||
| 177063 | 1247 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 3725 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2008 12:00:00 AM | 3 | 3X3 | 5993078.34594 | 2087556.76692 | 37.7116361552477 | -122.465755711083 | (37.7116361552477, -122.465755711083) | 9 | 8 | 4 | 64 | 24 | ||
| 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 | ||
| 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 | |
| 174599 | 1172 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2900 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5996885.41862 | 2087511.89971 | 37.7117318296412 | -122.45259428042 | (37.7117318296412, -122.45259428042) | 9 | 7 | 6 | 28861 | 25 | ||
| 174577 | 221652 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 303 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004504.7671 | 2098377.5922 | 37.7420002371236 | -122.427033134087 | (37.7420002371236, -122.427033134087) | 2 | 7 | 5 | 63 | 7 | |||
| 173732 | 187799 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 804 Bryant St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6011732.346 | 2110569.44577 | 37.7758824101801 | -122.402899621945 | (37.7758824101801, -122.402899621945) | 14 | 2 | 9 | 28853 | 34 | |||
| 173148 | 187812 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 501 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6015686.38843 | 2114228.80536 | 37.7861501840288 | -122.389477068617 | (37.7861501840288, -122.389477068617) | 6 | 2 | 9 | 28856 | 6 | |||
| 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 | |||
| 170161 | 23951 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2400X Sacramento St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003144.33072 | 2115898.20328 | 37.7900305545192 | -122.432988547211 | (37.7900305545192, -122.432988547211) | 13 | 9 | 1 | 29490 | 27 | |
| 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 |
| 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 | |||
| 167782 | 85677 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 750 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012237.71739 | 2111051.30981 | 37.7772337045105 | -122.401185269499 | (37.7772337045105, -122.401185269499) | 14 | 2 | 9 | 28856 | 34 | ||
| 167022 | 116212 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 3801 SACRAMENTO ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778748 | 5996623 | 2114922 | 37.7869781063352 | -122.455481088021 | (37.7869781063352, -122.455481088021) | 11 | 6 | 1 | 54 | 31 | |
| 165661 | 87984 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 809 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51021 | 6002006 | 2111228 | 37.777142730335 | -122.43659264798 | (37.777142730335, -122.43659264798) | 15 | 5 | 11 | 29492 | 41 | ||
| 165191 | 1237 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 3702X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/1992 12:00:00 AM | 25 | 3X5 | 5993171.03745 | 2087640.69975 | 37.7118719610995 | -122.465441440287 | (37.7118719610995, -122.465441440287) | 9 | 8 | 4 | 64 | 24 | ||
| 164726 | 85690 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 570 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/05/2011 12:00:00 AM | 3 | 3x3 | 6013313.89043 | 2112083.07139 | 37.7801266652608 | -122.39753479629 | (37.7801266652608, -122.39753479629) | 6 | 2 | 9 | 28856 | 34 | ||
| 164582 | 175086 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 812 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001790.79227 | 2089105.59743 | 37.7163876144767 | -122.435753948985 | (37.7163876144767, -122.435753948985) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 163760 | 52401 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 47@ MISSION Santa Marina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2005 12:00:00 AM | Permit Number 48521 | 6005927.5376712 | 2097730.99268597 | 37.7403051709369 | -122.422067716571 | (37.7403051709369, -122.422067716571) | 2 | 7 | 7 | 28859 | 2 | ||
| 163215 | 221582 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1801 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009541.12472 | 2106040.44893 | 37.7633242348594 | -122.410159828117 | (37.7633242348594, -122.410159828117) | 8 | 4 | 8 | 28859 | 19 | |||
| 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 | ||
| 162368 | 111058 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1851 Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | 8 | 4 | 8 | 28859 | 19 | ||||
| 162098 | 221584 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1801 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009533.60745 | 2106163.71232 | 37.7636622666144 | -122.410194531154 | (37.7636622666144, -122.410194531154) | 8 | 4 | 8 | 28859 | 19 | |||
| 161921 | 51533 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 772 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2005 12:00:00 AM | 5 | Permit Number 47835 | 6012012.48578 | 2110839.92908 | 37.7766407338169 | -122.401949559218 | (37.7766407338169, -122.401949559218) | 14 | 2 | 9 | 28856 | 34 | ||
| 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 |
| 160500 | 221621 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 337 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007130.84207 | 2097321.03633 | 37.7392473161223 | -122.417878106717 | (37.7392473161223, -122.417878106717) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 159870 | 11073 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1800 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3X3 | Permit Number 782592 | 6007352.3421 | 2118515.85002 | 37.797455746746 | -122.418614850203 | (37.797455746746, -122.418614850203) | 5 | 1 | 10 | 28858 | 32 | |
| 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 | |||
| 159132 | 221577 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 98 Elgin Park | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6005820.32066 | 2108557.45054 | 37.7700260636763 | -122.423207813799 | (37.7700260636763, -122.423207813799) | 8 | 2 | 5 | 28853 | 19 | |||
| 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 | |||
| 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 | |||
| 157222 | 221608 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2901 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009434.74782 | 2102163.68308 | 37.7526735485626 | -122.410254020432 | (37.7526735485626, -122.410254020432) | 2 | 4 | 7 | 28859 | 19 | |||
| 154967 | 102080 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 27 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769730 | 6007460.8 | 2099922.6 | 37.7464091944673 | -122.416921530448 | (37.7464091944673, -122.416921530448) | 2 | 7 | 7 | 28859 | 2 | |
| 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 |
| 154621 | 109236 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 284 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773603 | 6004130.6 | 2098710.6 | 37.7428934350545 | -122.428350613465 | (37.7428934350545, -122.428350613465) | 2 | 7 | 5 | 63 | 22 |
| 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 | |
| 152867 | 1163 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2849X Alemany Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5997232.58602 | 2087721.56451 | 37.7123274065466 | -122.451409493752 | (37.7123274065466, -122.451409493752) | 9 | 7 | 6 | 28861 | 25 | ||
| 152556 | 1245 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 3715 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2008 12:00:00 AM | 3 | 3X3 | 5993121.79741 | 2087558.19139 | 37.7116425728285 | -122.465605635801 | (37.7116425728285, -122.465605635801) | 9 | 8 | 4 | 64 | 24 | ||
| 151341 | 121985 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 454 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5991269.55621 | 2112312.02155 | 37.7795031869908 | -122.473812131609 | (37.7795031869908, -122.473812131609) | 11 | 6 | 2 | 54 | 26 | |||
| 150346 | 175093 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 44 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003678.86336 | 2093990.74117 | 37.7299082046944 | -122.429576053496 | (37.7299082046944, -122.429576053496) | 9 | 7 | 6 | 28861 | 5 | |||
| 149998 | 40710 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 82 West View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52485 | 6007191.35202 | 2094307.49546 | 37.7309761999828 | -122.417455375872 | (37.7309761999828, -122.417455375872) | 9 | 3 | 7 | 309 | 28 | |
| 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 | |||
| 149757 | 86630 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 760 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6012073.82351 | 2110895.00183 | 37.7767953740371 | -122.401741244761 | (37.7767953740371, -122.401741244761) | 14 | 2 | 9 | 28856 | 34 | ||
| 149662 | 221601 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 418 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5998530.76454 | 2106730.59265 | 37.7645958968999 | -122.448290597257 | (37.7645958968999, -122.448290597257) | 15 | 5 | 11 | 29492 | 9 | |||
| 149389 | 85680 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 600 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012945.93643 | 2111731.57619 | 37.7791410451674 | -122.398783049916 | (37.7791410451674, -122.398783049916) | 6 | 2 | 9 | 28856 | 34 | ||
| 147584 | 187791 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 470 Bryant St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6013974.48447 | 2112705.93616 | 37.7818736702837 | -122.395293129083 | (37.7818736702837, -122.395293129083) | 6 | 2 | 9 | 28856 | 6 | |||
| 147114 | 221604 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 463 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007492.29073 | 2097272.21959 | 37.739133611216 | -122.416624918515 | (37.739133611216, -122.416624918515) | 2 | 7 | 7 | 28859 | 2 | |||
| 146454 | 114964 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 365 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 775367 | 6005522.4 | 2101591.5 | 37.75088238498 | -122.423742946306 | (37.75088238498, -122.423742946306) | 2 | 4 | 5 | 28859 | 19 | |||
| 145374 | 221618 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 629 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007896.11595 | 2095711.25449 | 37.7348702464625 | -122.415118207847 | (37.7348702464625, -122.415118207847) | 2 | 7 | 7 | 28859 | 2 | |||
| 144856 | 221574 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 80 Elgin Park | 1 | : | Tree | Private 2 | 2 | Width 2ft | 6005813.30509 | 2108654.41752 | 37.7702919158617 | -122.423238974413 | (37.7702919158617, -122.423238974413) | 8 | 2 | 5 | 28853 | 19 | |||
| 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 | |||
| 142528 | 175089 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 3602 Alemany Blvd | 2 | : | Tree | Private 2 | 2 | Width 3ft | 5993467.05206 | 2087598.83028 | 37.7117740654009 | -122.464415301235 | (37.7117740654009, -122.464415301235) | 9 | 8 | 4 | 64 | 24 | |||
| 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 | |||
| 141652 | 221645 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 841 Church St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004369.11216 | 2104095.58562 | 37.7576928456553 | -122.427909537811 | (37.7576928456553, -122.427909537811) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 |
| 139908 | 23948 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2400X Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003227.15919 | 2115908.88128 | 37.7900645713585 | -122.432702730963 | (37.7900645713585, -122.432702730963) | 13 | 9 | 1 | 29490 | 27 | |
| 138230 | 84453 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1851 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2009 12:00:00 AM | 3x3 | Permit Number 52645 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | 8 | 4 | 8 | 28859 | 19 | ||
| 137184 | 221595 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 206 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004515.09933 | 2098718.51485 | 37.7429369170054 | -122.427021684812 | (37.7429369170054, -122.427021684812) | 2 | 7 | 5 | 63 | 22 | |||
| 136017 | 140762 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 48 TERRA VISTA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 769846 | 6000287.3355 | 2112871.989 | 37.7815588874389 | -122.4426561036 | (37.7815588874389, -122.4426561036) | 15 | 5 | 1 | 29490 | 16 | |
| 135940 | 221643 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 841 Church St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004370.46442 | 2104050.63168 | 37.757569489259 | -122.427901657939 | (37.757569489259, -122.427901657939) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 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 | |
| 134724 | 45195 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 533 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/2013 12:00:00 AM | 1 | Permit Number 770806 | 6013564.94322 | 2104599.17131 | 37.7595915222398 | -122.396141643024 | (37.7595915222398, -122.396141643024) | 10 | 3 | 8 | 28856 | 29 | |
| 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 | |||
| 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 | |||
| 133833 | 108521 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1969 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Fire Dept | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773668 | 5990944.21476 | 2102008.8699 | 37.7511946505392 | -122.474185618824 | (37.7511946505392, -122.474185618824) | 1 | 8 | 4 | 29491 | 12 |
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) );