Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
100882 | 100882 | 99854 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 755 Marina Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x7 | Permit Number 768797 | 5999383.5 | 2121460.3 | 37.805088551244204 | -122.446400961387 | (37.8050885512442, -122.446400961387) | |||
124199 | 124199 | 99853 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 755 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x12 | Permit Number 768797 | 5999383.5 | 2121460.3 | 37.805088551244204 | -122.446400961387 | (37.8050885512442, -122.446400961387) | |||
120219 | 120219 | 98758 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 141 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 768795 | 6001830.6 | 2121663.0 | 37.8057845723141 | -122.437947027917 | (37.8057845723141, -122.437947027917) | |||
105523 | 105523 | 98600 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2195X Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1981 12:00:00 AM | 3x3 | Permit Number 768644 | 6002468.0 | 2118693.0 | 37.7976659583882 | -122.435528609991 | (37.7976659583882, -122.435528609991) | ||
99850 | 99850 | 97888 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 30 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768367 | 6003432.2 | 2108510.8 | 37.7697629112822 | -122.431464951074 | (37.7697629112822, -122.431464951074) | ||||
118080 | 118080 | 97889 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 30 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768367 | 6003432.2 | 2108510.8 | 37.7697629112822 | -122.431464951074 | (37.7697629112822, -122.431464951074) | ||||
108852 | 108852 | 98702 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3150 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2012 12:00:00 AM | 4x4 | Permit Number 768335 | 5999122.2 | 2116336.3 | 37.79100449175579 | -122.446936266113 | (37.7910044917558, -122.446936266113) | ||
98077 | 98077 | 96646 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2350 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2011 12:00:00 AM | Permit Number 768028 | 5991735.4 | 2099423.9 | 37.7441427924065 | -122.471261322589 | (37.7441427924065, -122.471261322589) | |||
119269 | 119269 | 96645 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2350 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2011 12:00:00 AM | Permit Number 768028 | 5991735.4 | 2099423.9 | 37.7441427924065 | -122.471261322589 | (37.7441427924065, -122.471261322589) | |||
40606 | 40606 | 97979 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 3x105 | Permit Number 767976 | 6008557.48708 | 2094193.9971900003 | 37.730741330331995 | -122.412724380735 | (37.730741330332, -122.412724380735) | ||
129157 | 129157 | 97980 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x105 | Permit Number 767976 | 6008582.5 | 2094142.5 | 37.730601333974796 | -122.412634267782 | (37.7306013339748, -122.412634267782) | |||
131037 | 131037 | 97978 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767976 | 6008558.536309999 | 2094188.79818 | 37.7307271138572 | -122.412720385963 | (37.7307271138572, -122.412720385963) | |
154807 | 154807 | 97976 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 18 | 3x3 | Permit Number 767976 | 6008561.06273 | 2094180.5010099998 | 37.7307044734101 | -122.412711065359 | (37.7307044734101, -122.412711065359) | |
162444 | 162444 | 97973 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 3x105 | Permit Number 767976 | 6008571.293930001 | 2094144.04925 | 37.7306049589414 | -122.412673118464 | (37.7306049589414, -122.412673118464) | ||
168523 | 168523 | 97977 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 3x105 | Permit Number 767976 | 6008560.783419999 | 2094185.6842900002 | 37.7307186899072 | -122.41271239727301 | (37.7307186899072, -122.412712397273) | ||
172978 | 172978 | 97975 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 3x105 | Permit Number 767976 | 6008564.43786 | 2094166.6254 | 37.73066656339879 | -122.41269841641399 | (37.7306665633988, -122.412698416414) | ||
177689 | 177689 | 97972 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767976 | 6008572.265240001 | 2094125.62068 | 37.7305544125591 | -122.412668458206 | (37.7305544125591, -122.412668458206) | |
185638 | 185638 | 97974 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 14 | 3x3 | Permit Number 767976 | 6008567.92648 | 2094152.82902 | 37.7306288773042 | -122.412685380727 | (37.7306288773042, -122.412685380727) | |
96476 | 96476 | 30421 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 530 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/1956 12:00:00 AM | Permit Number 75 | 6009285.11323863 | 2120849.80325768 | 37.803972827810995 | -122.412091961384 | (37.803972827811, -122.412091961384) | |||
81571 | 81571 | 30419 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 599 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/1956 12:00:00 AM | Permit Number 74 | 6011244.65303661 | 2117958.27162773 | 37.7961431366669 | -122.40510708151699 | (37.7961431366669, -122.405107081517) | |||
88576 | 88576 | 30420 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 599 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/1956 12:00:00 AM | Permit Number 74 | 6011244.65303661 | 2117958.27162773 | 37.7961431366669 | -122.40510708151699 | (37.7961431366669, -122.405107081517) | |||
116158 | 116158 | 89312 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1969 12:00:00 AM | 3x3 | Permit Number 6484 | 6002340.0 | 2108819.0 | 37.7705471897255 | -122.43526488371799 | (37.7705471897255, -122.435264883718) | ||
6921 | 6921 | 53479 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3600 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1969 12:00:00 AM | 36 | 6x12 | Permit Number 6388 | 5997506.20792 | 2115767.61462 | 37.7893505789022 | -122.45248645079201 | (37.7893505789022, -122.452486450792) | |
92597 | 92597 | 103410 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 Executive Park Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.711336259389206 | -122.392574697929 | (37.7113362593892, -122.392574697929) | ||||
98508 | 98508 | 103408 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 Executive Park Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.711336259389206 | -122.392574697929 | (37.7113362593892, -122.392574697929) | ||||
141472 | 141472 | 103409 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 Executive Park Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.711336259389206 | -122.392574697929 | (37.7113362593892, -122.392574697929) | ||||
181375 | 181375 | 94795 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 223 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | 12 | 2x2 | Permit Number 53893 | 5988023.34122 | 2114443.34668 | 37.78516664988479 | -122.485198457494 | (37.7851666498848, -122.485198457494) | |
89685 | 89685 | 94648 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1811 Pierce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 53785 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | ||||
178371 | 178371 | 94602 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2939 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/07/2010 12:00:00 AM | 9 | Permit Number 53770 | 5999468.945859999 | 2117347.95354 | 37.7938020288031 | -122.445809330858 | (37.7938020288031, -122.445809330858) | ||
107225 | 107225 | 41576 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/22/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53640 | 6004804.85382115 | 2107218.95663379 | 37.7662935218736 | -122.426624972491 | (37.7662935218736, -122.426624972491) | |
144074 | 144074 | 92957 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
145041 | 145041 | 92956 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
109255 | 109255 | 92815 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 54 Cerritos Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/06/2009 12:00:00 AM | 3x3 | Permit Number 53023 | 5992579.4 | 2093009.1 | 37.72657814349439 | -122.46787650278 | (37.7265781434944, -122.46787650278) | ||
103795 | 103795 | 92788 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53006 | 6001506.4 | 2107657.3 | 37.7673100756575 | -122.438065079874 | (37.7673100756575, -122.438065079874) | |||
56575 | 56575 | 91400 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 222 Maple St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52096 | 5996639.65876 | 2115525.86158 | 37.7886371044596 | -122.455467113417 | (37.7886371044596, -122.455467113417) | |
42619 | 42619 | 91061 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2475 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2008 12:00:00 AM | 15 | 3x3 | Permit Number 51968 | 6001778.15599 | 2117308.9761 | 37.793826585689104 | -122.43781647395299 | (37.7938265856891, -122.437816473953) | |
127713 | 127713 | 66977 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 87 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1992 12:00:00 AM | 3x3 | Permit Number 51959 | 6008713.44526342 | 2098219.93166523 | 37.7418044249338 | -122.412469676471 | (37.7418044249338, -122.412469676471) | ||
145878 | 145878 | 89262 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Polk St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||||
88626 | 88626 | 89211 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1540 Pacheco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51845 | 5990117.7 | 2101817.3 | 37.7506207352004 | -122.47702976858 | (37.7506207352004, -122.47702976858) | |||
112878 | 112878 | 89212 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1540 Pacheco St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51845 | 5990117.7 | 2101817.3 | 37.7506207352004 | -122.47702976858 | (37.7506207352004, -122.47702976858) | |||
122336 | 122336 | 89213 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1540 Pacheco St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51845 | 5990117.7 | 2101817.3 | 37.7506207352004 | -122.47702976858 | (37.7506207352004, -122.47702976858) | |||
116342 | 116342 | 88989 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1696 McAllister St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51741 | 5997688.0 | 2111682.0 | 37.7781429711136 | -122.451562655149 | (37.7781429711136, -122.451562655149) | ||||
83315 | 83315 | 88823 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 110 Clayton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51710 | 5998275.0 | 2110294.0 | 37.7743654794888 | -122.44943198445 | (37.7743654794888, -122.44943198445) | ||||
102905 | 102905 | 88602 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 370 Parnassus Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51547 | 5996151.9 | 2106560.1 | 37.7639914803102 | -122.45650607155001 | (37.7639914803102, -122.45650607155) | |||
130766 | 130766 | 88460 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2665 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2008 12:00:00 AM | 22 | 3x3 | Permit Number 51419 | 5999588.65387 | 2118008.6000099997 | 37.7956228231833 | -122.44544265745701 | (37.7956228231833, -122.445442657457) | |
136179 | 136179 | 88458 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2665 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2008 12:00:00 AM | 19 | 3x3 | Permit Number 51419 | 5999585.28862 | 2118036.11604 | 37.7956981827846 | -122.445456281295 | (37.7956981827846, -122.445456281295) | |
159907 | 159907 | 88459 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2665 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2008 12:00:00 AM | 22 | 3x3 | Permit Number 51419 | 5999585.78852 | 2118019.58187 | 37.795652812882 | -122.445453362079 | (37.795652812882, -122.445453362079) | |
93038 | 93038 | 42562 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 San Benito Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51025 | 5992910.18577839 | 2095362.95085697 | 37.7330603317539 | -122.46690404336 | (37.7330603317539, -122.46690404336) | ||
98432 | 98432 | 87964 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 393 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50997 | 6008895.0 | 2121449.0 | 37.8055961756376 | -122.413484381593 | (37.8055961756376, -122.413484381593) | ||
99503 | 99503 | 87963 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 393 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50997 | 6008895.0 | 2121449.0 | 37.8055961756376 | -122.413484381593 | (37.8055961756376, -122.413484381593) | ||
87228 | 87228 | 87839 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 815 Buena Vista West Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50724 | 5999858.0 | 2108239.0 | 37.76881339508 | -122.44380843942301 | (37.76881339508, -122.443808439423) | ||
147648 | 147648 | 49871 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2519SCOTT Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 13 | 3x3 | Permit Number 50540 | 6001316.09409 | 2117246.4111 | 37.7936285135915 | -122.439410760611 | (37.7936285135915, -122.439410760611) | |
93554 | 93554 | 87293 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 763 45th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | |||
106304 | 106304 | 87292 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 763 45th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | |||
126772 | 126772 | 87291 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 763 45th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | |||
86741 | 86741 | 87252 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 20 Burr Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50276 | 6007848.5 | 2086602.7 | 37.709857414252795 | -122.414638464087 | (37.7098574142528, -122.414638464087) | |||
36388 | 36388 | 87087 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 20501 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 28 | Permit Number 50035 | 5999440.60645 | 2115900.3485 | 37.7898256691591 | -122.44580322984 | (37.7898256691591, -122.44580322984) | ||
82420 | 82420 | 87086 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2298 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50031 | 6002046.0 | 2118096.0 | 37.7960027754164 | -122.436946080345 | (37.7960027754164, -122.436946080345) | |||
36213 | 36213 | 87049 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 139 Welsh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 13 | 3x3 | Permit Number 49986 | 6013117.93675 | 2111529.65612 | 37.7785962007824 | -122.398173856333 | (37.7785962007824, -122.398173856333) | |
180477 | 180477 | 87050 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 139 Welsh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | Permit Number 49986 | 6013132.69582 | 2111542.77268 | 37.7786330379242 | -122.398123719151 | (37.7786330379242, -122.398123719151) | ||
20617 | 20617 | 87007 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
72223 | 72223 | 87002 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | 3x3 | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | ||
81600 | 81600 | 87004 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
95384 | 95384 | 87010 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
121870 | 121870 | 87003 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
125318 | 125318 | 87006 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
140596 | 140596 | 87005 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
85969 | 85969 | 86887 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 56 Casa Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49816 | 6001536.6 | 2121651.4 | 37.8057359986938 | -122.43896362504499 | (37.8057359986938, -122.438963625045) | ||||
88318 | 88318 | 44175 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3898 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2000 12:00:00 AM | 3x3 | Permit Number 49758 | 5996140.20734213 | 2115579.73573661 | 37.788756356894496 | -122.457199029036 | (37.7887563568945, -122.457199029036) | ||
125686 | 125686 | 44174 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3898 Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2000 12:00:00 AM | 3x3 | Permit Number 49758 | 5996140.20734213 | 2115579.73573661 | 37.788756356894496 | -122.457199029036 | (37.7887563568945, -122.457199029036) | ||
94339 | 94339 | 85503 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
120969 | 120969 | 85508 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
140801 | 140801 | 85504 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
92902 | 92902 | 85305 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 365 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2007 12:00:00 AM | Permit Number 49591 | 5995968.6 | 2095545.0 | 37.733736241833704 | -122.456343520233 | (37.7337362418337, -122.456343520233) | |||
81857 | 81857 | 53099 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 370@HILL WAY Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2006 12:00:00 AM | Permit Number 49061 | 5996124.75088045 | 2106531.46709728 | 37.763911303006296 | -122.45659790095199 | (37.7639113030063, -122.456597900952) | |||
142443 | 142443 | 53040 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3666@ GUERRERO 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/2006 12:00:00 AM | Permit Number 49018 | 6005866.70904359 | 2104351.76912463 | 37.758480874637 | -122.42274843163 | (37.758480874637, -122.42274843163) | ||
121443 | 121443 | 52926 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 171 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48909 | 5988008.14773 | 2114828.39565 | 37.786222999509704 | -122.485279285217 | (37.7862229995097, -122.485279285217) |
87663 | 87663 | 52883 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1801@ NORIEGA 08th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48888 | 5993719.57975271 | 2103223.93352011 | 37.7546912902093 | -122.464676406209 | (37.7546912902093, -122.464676406209) | ||||
97219 | 97219 | 52877 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1801@ NORIEGA 08th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48888 | 5993719.57975271 | 2103223.93352011 | 37.7546912902093 | -122.464676406209 | (37.7546912902093, -122.464676406209) | ||||
115360 | 115360 | 52878 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1801@ NORIEGA 08th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48888 | 5993719.57975271 | 2103223.93352011 | 37.7546912902093 | -122.464676406209 | (37.7546912902093, -122.464676406209) | ||||
120400 | 120400 | 36261 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 60 Elmhurst Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 48818 | 5991187.85899012 | 2094553.0256483997 | 37.7307369236006 | -122.47279948850701 | (37.7307369236006, -122.472799488507) | ||
169164 | 169164 | 52614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 230@ AVILA Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2006 12:00:00 AM | 10 | Permit Number 48779 | 6000874.42374 | 2121481.75095 | 37.8052324902599 | -122.441242997973 | (37.8052324902599, -122.441242997973) | ||
90645 | 90645 | 52661 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1596 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2006 12:00:00 AM | 7x6 | Permit Number 48740 | 5993413.6797412 | 2104632.19014775 | 37.7585403580185 | -122.465836598218 | (37.7585403580185, -122.465836598218) | ||
103798 | 103798 | 52660 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1596 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2006 12:00:00 AM | 5.5x6 | Permit Number 48740 | 5993413.6797412 | 2104632.19014775 | 37.7585403580185 | -122.465836598218 | (37.7585403580185, -122.465836598218) | ||
180368 | 180368 | 52048 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2440 Pacific Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/2005 12:00:00 AM | 32 | Permit Number 48253 | 6002224.0088599995 | 2117083.39027 | 37.7932325277104 | -122.43625763230101 | (37.7932325277104, -122.436257632301) | ||
73295 | 73295 | 52034 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2960 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Permit Number 48246 | 6002027.71863 | 2118348.63065 | 37.7966953942316 | -122.437027433096 | (37.7966953942316, -122.437027433096) | |||
174887 | 174887 | 51878 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2251 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | 14 | Permit Number 48095 | 6002306.75433 | 2116015.7173900004 | 37.790305674209 | -122.43589489884701 | (37.790305674209, -122.435894898847) | ||
88587 | 88587 | 51791 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 485 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2005 12:00:00 AM | Permit Number 48040 | 5995434.95012874 | 2095496.4695716 | 37.733572339482 | -122.458184982463 | (37.733572339482, -122.458184982463) | |||
45050 | 45050 | 51789 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1238 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2005 12:00:00 AM | 13 | Permit Number 48038 | 5987411.1576 | 2106813.4078 | 37.7641812994666 | -122.486755921101 | (37.7641812994666, -122.486755921101) | ||
164063 | 164063 | 51682 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2209 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2005 12:00:00 AM | 15 | 3x3 | Permit Number 47962 | 6001952.8314 | 2114287.6119999997 | 37.7855406286981 | -122.436995673401 | (37.7855406286981, -122.436995673401) | |
101445 | 101445 | 51666 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 444 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2005 12:00:00 AM | Permit Number 47943 | 5998559.54409269 | 2106579.38545488 | 37.7641823653154 | -122.44818016830799 | (37.7641823653154, -122.448180168308) | |||
104818 | 104818 | 51665 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 444 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2005 12:00:00 AM | Permit Number 47943 | 5998559.54409269 | 2106579.38545488 | 37.7641823653154 | -122.44818016830799 | (37.7641823653154, -122.448180168308) | |||
101295 | 101295 | 51634 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 77 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47924 | 6005437.59121376 | 2109217.8235753 | 37.771817682613296 | -122.42457865203698 | (37.7718176826133, -122.424578652037) | |||
112996 | 112996 | 51624 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 25 Short St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Permit Number 47918 | 6000046.75417134 | 2104161.05228348 | 37.7576271269874 | -122.44286268101001 | (37.7576271269874, -122.44286268101) | |||
145588 | 145588 | 51623 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 25 Short St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47918 | 6000046.75417134 | 2104161.05228348 | 37.7576271269874 | -122.44286268101001 | (37.7576271269874, -122.44286268101) | ||||
67804 | 67804 | 51571 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 494 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | Permit Number 47868 | 5984728.581040001 | 2112539.46721 | 37.779746669398 | -122.4964565965 | (37.779746669398, -122.4964565965) | ||
87192 | 87192 | 51553 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3800 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2005 12:00:00 AM | Permit Number 47852 | 5996586.74903344 | 2115641.8686237 | 37.788952592538706 | -122.455658560713 | (37.7889525925387, -122.455658560713) | |||
107434 | 107434 | 42535 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3800 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2005 12:00:00 AM | Permit Number 47852 | 5996586.74903344 | 2115641.8686237 | 37.788952592538706 | -122.455658560713 | (37.7889525925387, -122.455658560713) | |||
940 | 940 | 51496 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1350 REVISED Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47808 | 6000958.86990754 | 2110035.78536621 | 37.773809648853 | -122.44012948036101 | (37.773809648853, -122.440129480361) | |||
49151 | 49151 | 51005 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 674 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | 14 | Permit Number 47484 | 5995056.39173 | 2110967.50064 | 37.776030092024 | -122.460614488586 | (37.776030092024, -122.460614488586) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");