trees
3,965 rows where qSpecies_id = 70 sorted by PermitNotes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101150 | 99904 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
119395 | 99900 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
132716 | 125217 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2101 Washington St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 5ft | Permit Number 768908 | 6005070.35193 | 2116772.06135 | 37.79253900653 | -122.426386916319 | (37.79253900653, -122.426386916319) | 13 | 9 | 1 | 28858 | 27 | ||
156825 | 99905 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
184283 | 99907 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
189388 | 99899 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||
189714 | 99906 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
63702 | 98819 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 62 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768816 | 6000868 | 2109174 | 37.7714382288844 | -122.440381995657 | (37.7714382288844, -122.440381995657) | 15 | 5 | 11 | 29492 | 9 | ||||
23626 | 99853 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 755 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x12 | Permit Number 768797 | 5999383.5 | 2121460.3 | 37.8050885512442 | -122.446400961387 | (37.8050885512442, -122.446400961387) | 13 | 9 | 1 | 57 | 17 | |||
111262 | 99854 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 755 Marina Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x7 | Permit Number 768797 | 5999383.5 | 2121460.3 | 37.8050885512442 | -122.446400961387 | (37.8050885512442, -122.446400961387) | 13 | 9 | 1 | 57 | 17 | |||
161863 | 98758 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 141 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 768795 | 6001830.6 | 2121663 | 37.8057845723141 | -122.437947027917 | (37.8057845723141, -122.437947027917) | 13 | 9 | 1 | 57 | 17 | |||
114773 | 98600 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2195X Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1981 12:00:00 AM | 3x3 | Permit Number 768644 | 6002468 | 2118693 | 37.7976659583882 | -122.435528609991 | (37.7976659583882, -122.435528609991) | 13 | 9 | 1 | 57 | 17 | ||
112187 | 97888 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 30 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768367 | 6003432.2 | 2108510.8 | 37.7697629112822 | -122.431464951074 | (37.7697629112822, -122.431464951074) | 15 | 9 | 5 | 29492 | 10 | ||||
159769 | 97889 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 30 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768367 | 6003432.2 | 2108510.8 | 37.7697629112822 | -122.431464951074 | (37.7697629112822, -122.431464951074) | 15 | 9 | 5 | 29492 | 10 | ||||
114499 | 98702 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3150 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2012 12:00:00 AM | 4x4 | Permit Number 768335 | 5999122.2 | 2116336.3 | 37.7910044917558 | -122.446936266113 | (37.7910044917558, -122.446936266113) | 13 | 6 | 1 | 29490 | 31 | ||
101546 | 96646 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2350 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2011 12:00:00 AM | Permit Number 768028 | 5991735.4 | 2099423.9 | 37.7441427924065 | -122.471261322589 | (37.7441427924065, -122.471261322589) | 1 | 8 | 4 | 29491 | 40 | |||
164381 | 96645 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2350 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2011 12:00:00 AM | Permit Number 768028 | 5991735.4 | 2099423.9 | 37.7441427924065 | -122.471261322589 | (37.7441427924065, -122.471261322589) | 1 | 8 | 4 | 29491 | 40 | |||
25108 | 97979 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 9 | Front Yard : Yard | Tree | Private 2 | 17 | 3x105 | Permit Number 767976 | 6008557.48708 | 2094193.99719 | 37.730741330332 | -122.412724380735 | (37.730741330332, -122.412724380735) | 9 | 3 | 7 | 309 | 28 | ||
25538 | 97980 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 10 | Front Yard : Yard | Tree | Private 2 | 3x105 | Permit Number 767976 | 6008582.5 | 2094142.5 | 37.7306013339748 | -122.412634267782 | (37.7306013339748, -122.412634267782) | 9 | 3 | 7 | 309 | 28 | |||
38725 | 97974 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 14 | 3x3 | Permit Number 767976 | 6008567.92648 | 2094152.82902 | 37.7306288773042 | -122.412685380727 | (37.7306288773042, -122.412685380727) | 9 | 3 | 7 | 309 | 28 | |
39911 | 97975 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 5 | Front Yard : Yard | Tree | Private 2 | 10 | 3x105 | Permit Number 767976 | 6008564.43786 | 2094166.6254 | 37.7306665633988 | -122.412698416414 | (37.7306665633988, -122.412698416414) | 9 | 3 | 7 | 309 | 28 | ||
103927 | 97976 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 18 | 3x3 | Permit Number 767976 | 6008561.06273 | 2094180.50101 | 37.7307044734101 | -122.412711065359 | (37.7307044734101, -122.412711065359) | 9 | 3 | 7 | 309 | 28 | |
110893 | 97972 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767976 | 6008572.26524 | 2094125.62068 | 37.7305544125591 | -122.412668458206 | (37.7305544125591, -122.412668458206) | 9 | 3 | 7 | 309 | 28 | |
123051 | 97973 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 3 | Front Yard : Yard | Tree | Private 2 | 21 | 3x105 | Permit Number 767976 | 6008571.29393 | 2094144.04925 | 37.7306049589414 | -122.412673118464 | (37.7306049589414, -122.412673118464) | 9 | 3 | 7 | 309 | 28 | ||
158637 | 97978 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767976 | 6008558.53631 | 2094188.79818 | 37.7307271138572 | -122.412720385963 | (37.7307271138572, -122.412720385963) | 9 | 3 | 7 | 309 | 28 | |
178478 | 97977 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 7 | Front Yard : Yard | Tree | Private 2 | 17 | 3x105 | Permit Number 767976 | 6008560.78342 | 2094185.68429 | 37.7307186899072 | -122.412712397273 | (37.7307186899072, -122.412712397273) | 9 | 3 | 7 | 309 | 28 | ||
92771 | 30421 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 530 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/1956 12:00:00 AM | Permit Number 75 | 6009285.11323863 | 2120849.80325768 | 37.803972827811 | -122.412091961384 | (37.803972827811, -122.412091961384) | 3 | 1 | 10 | 308 | 23 | |||
52641 | 30419 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 599 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/1956 12:00:00 AM | Permit Number 74 | 6011244.65303661 | 2117958.27162773 | 37.7961431366669 | -122.405107081517 | (37.7961431366669, -122.405107081517) | 3 | 1 | 10 | 28857 | 4 | |||
68481 | 30420 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 599 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/1956 12:00:00 AM | Permit Number 74 | 6011244.65303661 | 2117958.27162773 | 37.7961431366669 | -122.405107081517 | (37.7961431366669, -122.405107081517) | 3 | 1 | 10 | 28857 | 4 | |||
150425 | 89312 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1969 12:00:00 AM | 3x3 | Permit Number 6484 | 6002340 | 2108819 | 37.7705471897255 | -122.435264883718 | (37.7705471897255, -122.435264883718) | 15 | 5 | 11 | 29492 | 9 | ||
44508 | 53479 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3600 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1969 12:00:00 AM | 36 | 6x12 | Permit Number 6388 | 5997506.20792 | 2115767.61462 | 37.7893505789022 | -122.452486450792 | (37.7893505789022, -122.452486450792) | 11 | 6 | 1 | 54 | 31 | |
87109 | 103410 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Executive Park Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.7113362593892 | -122.392574697929 | (37.7113362593892, -122.392574697929) | 10 | 3 | 8 | 58 | 1 | ||||
101910 | 103408 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Executive Park Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.7113362593892 | -122.392574697929 | (37.7113362593892, -122.392574697929) | 10 | 3 | 8 | 58 | 1 | ||||
188484 | 103409 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Executive Park Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.7113362593892 | -122.392574697929 | (37.7113362593892, -122.392574697929) | 10 | 3 | 8 | 58 | 1 | ||||
114544 | 94795 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 223 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2010 12:00:00 AM | 12 | 2x2 | Permit Number 53893 | 5988023.34122 | 2114443.34668 | 37.7851666498848 | -122.485198457494 | (37.7851666498848, -122.485198457494) | 11 | 6 | 2 | 55 | 26 | |
62131 | 94648 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1811 Pierce St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 53785 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | 13 | 6 | 11 | 29490 | 27 | ||||
175371 | 94602 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2939 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 10/07/2010 12:00:00 AM | 9 | Permit Number 53770 | 5999468.94586 | 2117347.95354 | 37.7938020288031 | -122.445809330858 | (37.7938020288031, -122.445809330858) | 13 | 9 | 1 | 57 | 27 | ||
122402 | 41576 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/22/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53640 | 6004804.85382115 | 2107218.95663379 | 37.7662935218736 | -122.426624972491 | (37.7662935218736, -122.426624972491) | 8 | 4 | 5 | 28862 | 3 | |
189331 | 92957 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.7217103076746 | -122.444931280306 | (37.7217103076746, -122.444931280306) | 9 | 7 | 6 | 28861 | 25 | |
190901 | 92956 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.7217103076746 | -122.444931280306 | (37.7217103076746, -122.444931280306) | 9 | 7 | 6 | 28861 | 25 | |
114494 | 92815 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Cerritos Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/06/2009 12:00:00 AM | 3x3 | Permit Number 53023 | 5992579.4 | 2093009.1 | 37.7265781434944 | -122.46787650278 | (37.7265781434944, -122.46787650278) | 9 | 8 | 4 | 59 | 40 | ||
104618 | 92788 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53006 | 6001506.4 | 2107657.3 | 37.7673100756575 | -122.438065079874 | (37.7673100756575, -122.438065079874) | 15 | 5 | 5 | 29492 | 3 | |||
186118 | 91400 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 Maple St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52096 | 5996639.65876 | 2115525.86158 | 37.7886371044596 | -122.455467113417 | (37.7886371044596, -122.455467113417) | 11 | 6 | 1 | 54 | 31 | |
79529 | 91061 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2475 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2008 12:00:00 AM | 15 | 3x3 | Permit Number 51968 | 6001778.15599 | 2117308.9761 | 37.7938265856891 | -122.437816473953 | (37.7938265856891, -122.437816473953) | 13 | 9 | 1 | 29490 | 27 | |
31329 | 66977 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 87 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1992 12:00:00 AM | 3x3 | Permit Number 51959 | 6008713.44526342 | 2098219.93166523 | 37.7418044249338 | -122.412469676471 | (37.7418044249338, -122.412469676471) | 10 | 7 | 7 | 28859 | 2 | ||
192979 | 89262 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Polk St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||||
70861 | 89211 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1540 Pacheco St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51845 | 5990117.7 | 2101817.3 | 37.7506207352004 | -122.47702976858 | (37.7506207352004, -122.47702976858) | 1 | 8 | 3 | 29491 | 35 | |||
133602 | 89212 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1540 Pacheco St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51845 | 5990117.7 | 2101817.3 | 37.7506207352004 | -122.47702976858 | (37.7506207352004, -122.47702976858) | 1 | 8 | 3 | 29491 | 35 | |||
158472 | 89213 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1540 Pacheco St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51845 | 5990117.7 | 2101817.3 | 37.7506207352004 | -122.47702976858 | (37.7506207352004, -122.47702976858) | 1 | 8 | 3 | 29491 | 35 | |||
138773 | 88989 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1696 McAllister St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51741 | 5997688 | 2111682 | 37.7781429711136 | -122.451562655149 | (37.7781429711136, -122.451562655149) | 15 | 6 | 2 | 54 | 16 | ||||
39912 | 88823 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 110 Clayton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51710 | 5998275 | 2110294 | 37.7743654794888 | -122.44943198445 | (37.7743654794888, -122.44943198445) | 15 | 5 | 11 | 29492 | 16 | ||||
95376 | 88602 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 370 Parnassus Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51547 | 5996151.9 | 2106560.1 | 37.7639914803102 | -122.45650607155 | (37.7639914803102, -122.45650607155) | 15 | 5 | 11 | 29492 | 12 | |||
71424 | 88458 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2665 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2008 12:00:00 AM | 19 | 3x3 | Permit Number 51419 | 5999585.28862 | 2118036.11604 | 37.7956981827846 | -122.445456281295 | (37.7956981827846, -122.445456281295) | 13 | 9 | 1 | 57 | 17 | |
128012 | 88459 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2665 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2008 12:00:00 AM | 22 | 3x3 | Permit Number 51419 | 5999585.78852 | 2118019.58187 | 37.795652812882 | -122.445453362079 | (37.795652812882, -122.445453362079) | 13 | 9 | 1 | 57 | 17 | |
171472 | 88460 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2665 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2008 12:00:00 AM | 22 | 3x3 | Permit Number 51419 | 5999588.65387 | 2118008.60001 | 37.7956228231833 | -122.445442657457 | (37.7956228231833, -122.445442657457) | 13 | 9 | 1 | 57 | 17 | |
84675 | 42562 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 San Benito Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51025 | 5992910.18577839 | 2095362.95085697 | 37.7330603317539 | -122.46690404336 | (37.7330603317539, -122.46690404336) | 9 | 8 | 4 | 59 | 40 | ||
104514 | 87964 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 393 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50997 | 6008895 | 2121449 | 37.8055961756376 | -122.413484381593 | (37.8055961756376, -122.413484381593) | 3 | 1 | 10 | 308 | 23 | ||
105134 | 87963 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 393 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50997 | 6008895 | 2121449 | 37.8055961756376 | -122.413484381593 | (37.8055961756376, -122.413484381593) | 3 | 1 | 10 | 308 | 23 | ||
66217 | 87839 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 815 Buena Vista West Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50724 | 5999858 | 2108239 | 37.76881339508 | -122.443808439423 | (37.76881339508, -122.443808439423) | 15 | 5 | 11 | 29492 | 9 | ||
187313 | 49871 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2519SCOTT Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 13 | 3x3 | Permit Number 50540 | 6001316.09409 | 2117246.4111 | 37.7936285135915 | -122.439410760611 | (37.7936285135915, -122.439410760611) | 13 | 9 | 1 | 29490 | 27 | |
25335 | 87291 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 763 45th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | 11 | 6 | 2 | 55 | 26 | |||
88938 | 87293 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 763 45th Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | 11 | 6 | 2 | 55 | 26 | |||
123206 | 87292 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 763 45th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | 11 | 6 | 2 | 55 | 26 | |||
71908 | 87252 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 20 Burr Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50276 | 6007848.5 | 2086602.7 | 37.7098574142528 | -122.414638464087 | (37.7098574142528, -122.414638464087) | 9 | 7 | 8 | 309 | 39 | |||
13825 | 87087 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 20501 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 28 | Permit Number 50035 | 5999440.60645 | 2115900.3485 | 37.7898256691591 | -122.44580322984 | (37.7898256691591, -122.44580322984) | 13 | 6 | 1 | 29490 | 27 | ||
49696 | 87086 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2298 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50031 | 6002046 | 2118096 | 37.7960027754164 | -122.436946080345 | (37.7960027754164, -122.436946080345) | 13 | 9 | 1 | 57 | 17 | |||
46769 | 87049 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 139 Welsh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2007 12:00:00 AM | 13 | 3x3 | Permit Number 49986 | 6013117.93675 | 2111529.65612 | 37.7785962007824 | -122.398173856333 | (37.7785962007824, -122.398173856333) | 6 | 2 | 9 | 28856 | 34 | |
150374 | 87050 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 139 Welsh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | Permit Number 49986 | 6013132.69582 | 2111542.77268 | 37.7786330379242 | -122.398123719151 | (37.7786330379242, -122.398123719151) | 6 | 2 | 9 | 28856 | 34 | ||
2063 | 87007 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
5419 | 87002 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | 3x3 | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | ||
25512 | 87006 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
50374 | 87004 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
81766 | 87010 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
164945 | 87003 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
174127 | 87005 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
63703 | 86887 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 56 Casa Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49816 | 6001536.6 | 2121651.4 | 37.8057359986938 | -122.438963625045 | (37.8057359986938, -122.438963625045) | 13 | 9 | 1 | 57 | 17 | ||||
29051 | 44174 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3898 Washington St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2000 12:00:00 AM | 3x3 | Permit Number 49758 | 5996140.20734213 | 2115579.73573661 | 37.7887563568945 | -122.457199029036 | (37.7887563568945, -122.457199029036) | 11 | 6 | 1 | 54 | 31 | ||
57659 | 44175 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3898 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2000 12:00:00 AM | 3x3 | Permit Number 49758 | 5996140.20734213 | 2115579.73573661 | 37.7887563568945 | -122.457199029036 | (37.7887563568945, -122.457199029036) | 11 | 6 | 1 | 54 | 31 | ||
77073 | 85503 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Nebraska St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
168560 | 85508 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Nebraska St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
183443 | 85504 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
89490 | 85305 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 365 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2007 12:00:00 AM | Permit Number 49591 | 5995968.6 | 2095545 | 37.7337362418337 | -122.456343520233 | (37.7337362418337, -122.456343520233) | 9 | 7 | 4 | 59 | 40 | |||
56173 | 53099 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 370@HILL WAY Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2006 12:00:00 AM | Permit Number 49061 | 5996124.75088045 | 2106531.46709728 | 37.7639113030063 | -122.456597900952 | (37.7639113030063, -122.456597900952) | 15 | 5 | 11 | 29492 | 12 | |||
182129 | 53040 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3666@ GUERRERO 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/19/2006 12:00:00 AM | Permit Number 49018 | 6005866.70904359 | 2104351.76912463 | 37.758480874637 | -122.42274843163 | (37.758480874637, -122.42274843163) | 2 | 4 | 5 | 28859 | 19 | ||
16802 | 52926 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 171 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | Permit Number 48909 | 5988008.14773 | 2114828.39565 | 37.7862229995097 | -122.485279285217 | (37.7862229995097, -122.485279285217) | 11 | 6 | 1 | 55 | 33 | |
75638 | 52883 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801@ NORIEGA 08th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48888 | 5993719.57975271 | 2103223.93352011 | 37.7546912902093 | -122.464676406209 | (37.7546912902093, -122.464676406209) | 1 | 8 | 4 | 56 | 12 | ||||
89524 | 52877 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801@ NORIEGA 08th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48888 | 5993719.57975271 | 2103223.93352011 | 37.7546912902093 | -122.464676406209 | (37.7546912902093, -122.464676406209) | 1 | 8 | 4 | 56 | 12 | ||||
148043 | 52878 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801@ NORIEGA 08th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48888 | 5993719.57975271 | 2103223.93352011 | 37.7546912902093 | -122.464676406209 | (37.7546912902093, -122.464676406209) | 1 | 8 | 4 | 56 | 12 | ||||
156355 | 36261 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Elmhurst Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 48818 | 5991187.85899012 | 2094553.0256484 | 37.7307369236006 | -122.472799488507 | (37.7307369236006, -122.472799488507) | 9 | 8 | 4 | 64 | 40 | ||
129109 | 52614 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 230@ AVILA Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2006 12:00:00 AM | 10 | Permit Number 48779 | 6000874.42374 | 2121481.75095 | 37.8052324902599 | -122.441242997973 | (37.8052324902599, -122.441242997973) | 13 | 9 | 1 | 57 | 17 | ||
65596 | 52661 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1596 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | 7x6 | Permit Number 48740 | 5993413.6797412 | 2104632.19014775 | 37.7585403580185 | -122.465836598218 | (37.7585403580185, -122.465836598218) | 1 | 8 | 4 | 56 | 12 | ||
98534 | 52660 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1596 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | 5.5x6 | Permit Number 48740 | 5993413.6797412 | 2104632.19014775 | 37.7585403580185 | -122.465836598218 | (37.7585403580185, -122.465836598218) | 1 | 8 | 4 | 56 | 12 | ||
139348 | 52048 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2440 Pacific Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2005 12:00:00 AM | 32 | Permit Number 48253 | 6002224.00886 | 2117083.39027 | 37.7932325277104 | -122.436257632301 | (37.7932325277104, -122.436257632301) | 13 | 9 | 1 | 29490 | 27 | ||
59144 | 52034 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2960 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Permit Number 48246 | 6002027.71863 | 2118348.63065 | 37.7966953942316 | -122.437027433096 | (37.7966953942316, -122.437027433096) | 13 | 9 | 1 | 57 | 17 | |||
27527 | 51878 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2251 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | 14 | Permit Number 48095 | 6002306.75433 | 2116015.71739 | 37.790305674209 | -122.435894898847 | (37.790305674209, -122.435894898847) | 13 | 9 | 1 | 29490 | 27 | ||
69908 | 51791 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 485 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2005 12:00:00 AM | Permit Number 48040 | 5995434.95012874 | 2095496.4695716 | 37.733572339482 | -122.458184982463 | (37.733572339482, -122.458184982463) | 9 | 7 | 4 | 59 | 40 | |||
147233 | 51789 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1238 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2005 12:00:00 AM | 13 | Permit Number 48038 | 5987411.1576 | 2106813.4078 | 37.7641812994666 | -122.486755921101 | (37.7641812994666, -122.486755921101) | 1 | 8 | 3 | 56 | 35 | ||
103937 | 51682 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2209 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | 15 | 3x3 | Permit Number 47962 | 6001952.8314 | 2114287.612 | 37.7855406286981 | -122.436995673401 | (37.7855406286981, -122.436995673401) | 13 | 6 | 11 | 29490 | 13 | |
100329 | 51666 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 444 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2005 12:00:00 AM | Permit Number 47943 | 5998559.54409269 | 2106579.38545488 | 37.7641823653154 | -122.448180168308 | (37.7641823653154, -122.448180168308) | 15 | 5 | 11 | 29492 | 9 | |||
121826 | 51665 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 444 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2005 12:00:00 AM | Permit Number 47943 | 5998559.54409269 | 2106579.38545488 | 37.7641823653154 | -122.448180168308 | (37.7641823653154, -122.448180168308) | 15 | 5 | 11 | 29492 | 9 |
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) );