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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3571 | 3571 | 39975 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
11073 | 11073 | 30310 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 228 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 8 | |||||||||
13382 | 13382 | 39972 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
14068 | 14068 | 30309 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 228 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 8 | |||||||||
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) | |||
147827 | 147827 | 59324 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1370 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/2012 12:00:00 AM | 1 | Permit Number 769281 | 5983406.5406 | 2105829.5951 | 37.761245750286996 | -122.50053376884199 | (37.761245750287, -122.500533768842) | ||
120651 | 120651 | 30332 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1783 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/1956 12:00:00 AM | Permit Number 23 | 5983455.10471621 | 2103020.95546664 | 37.753536865117795 | -122.5001581692 | (37.7535368651178, -122.5001581692) | |||
10993 | 10993 | 764 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3 | 5984614.2914 | 2106873.7688 | 37.76418358274471 | -122.496433785178 | (37.7641835827447, -122.496433785178) | |||
37565 | 37565 | 113088 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 494 36th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5984725.43026 | 2112610.82785 | 37.7799424204954 | -122.49647276346701 | (37.7799424204954, -122.496472763467) | |||
176755 | 176755 | 113087 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 494 36th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5984726.14635 | 2112591.8256599996 | 37.77989028792871 | -122.49646888365601 | (37.7798902879287, -122.496468883656) | |||
61856 | 61856 | 113086 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 494 36th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5984727.03316 | 2112580.82435 | 37.7798601334655 | -122.496465003816 | (37.7798601334655, -122.496465003816) | |||
61900 | 61900 | 113085 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 494 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5984727.7654 | 2112562.56652 | 37.7798100456413 | -122.496461123088 | (37.7798100456413, -122.496461123088) | |||
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) | ||
157835 | 157835 | 113089 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 494 36th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5984740.35768 | 2112618.32743 | 37.77996388666671 | -122.496421677178 | (37.7799638866667, -122.496421677178) | |||
95715 | 95715 | 20475 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1203X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
123025 | 123025 | 20477 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1203X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
101610 | 101610 | 20510 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1211X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
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) | |||
147463 | 147463 | 55934 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2665 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1973 12:00:00 AM | 9 | Permit Number 11998 | 5986719.3111 | 2097252.7279 | 37.7378899014651 | -122.48844608721501 | (37.7378899014651, -122.488446087215) | ||
72373 | 72373 | 122576 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1910 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | Permit Number 779012 | 5986951.5849 | 2102234.0134 | 37.75158073125021 | -122.48800892313601 | (37.7515807312502, -122.488008923136) | ||
4840 | 4840 | 64237 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 557 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779942 | 5987180.23832 | 2112140.30179 | 37.778793995563895 | -122.48794601676599 | (37.7787939955639, -122.487946016766) | |
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) | ||
166659 | 166659 | 61642 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 275 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/1987 12:00:00 AM | 13 | Permit Number 24615 | 5987729.039059999 | 2114139.72181 | 37.7843158342142 | -122.48619434147899 | (37.7843158342142, -122.486194341479) | ||
144489 | 144489 | 94796 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 223 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 5987953.6 | 2114461.6 | 37.7852127054212 | -122.48544107738199 | (37.7852127054212, -122.485441077382) | ||||
175147 | 175147 | 38476 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1998 12:00:00 AM | 19 | Permit Number 40477 | 5987961.29875 | 2115305.89755 | 37.78753135395029 | -122.485476422304 | (37.7875313539503, -122.485476422304) | ||
173830 | 173830 | 38477 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1998 12:00:00 AM | 12 | Permit Number 40477 | 5987973.38245 | 2115305.78698 | 37.787531754358795 | -122.48543460753 | (37.7875317543588, -122.48543460753) | ||
137748 | 137748 | 38478 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1998 12:00:00 AM | 21 | Permit Number 40477 | 5987978.37889 | 2115306.2666 | 37.787533362348704 | -122.48541735627501 | (37.7875333623487, -122.485417356275) | ||
145385 | 145385 | 102631 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 175 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769999 | 5987997.5 | 2114816.6 | 37.7861899917282 | -122.485315257259 | (37.7861899917282, -122.485315257259) | |||
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) |
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) | |
120199 | 120199 | 67608 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 261 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/1992 12:00:00 AM | 10 | Permit Number 31186 | 5988028.8714 | 2114260.1815400003 | 37.784664052693294 | -122.485165880985 | (37.7846640526933, -122.485165880985) | ||
41597 | 41597 | 102629 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 168 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 769953 | 5988063.8153 | 2114882.99878 | 37.7863761669029 | -122.485090700066 | (37.7863761669029, -122.485090700066) | |||
120507 | 120507 | 102630 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 168 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5988081.5 | 2114873.1 | 37.7863500177909 | -122.48502878974399 | (37.7863500177909, -122.485028789744) | |||||
119447 | 119447 | 12833 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2235 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 5988515.78975 | 2114643.77047 | 37.785745630994 | -122.483509457664 | (37.785745630994, -122.483509457664) | |||
101444 | 101444 | 12809 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2112 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 5 | 5988863.55424 | 2114711.62184 | 37.7859521665696 | -122.482311278452 | (37.7859521665696, -122.482311278452) | |||
108564 | 108564 | 12808 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2112 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5 | 5988878.34651 | 2114712.3148 | 37.7859549296707 | -122.482260152644 | (37.7859549296707, -122.482260152644) | |||
93494 | 93494 | 12757 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1739 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 5990002.61461 | 2114703.0924299997 | 37.7859949384969 | -122.47836986084299 | (37.7859949384969, -122.478369860843) | |||
91072 | 91072 | 32418 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | Permit Number 36947 | 5990009.30581449 | 2102467.22445118 | 37.752398967394 | -122.477452096473 | (37.752398967394, -122.477452096473) | |||
141176 | 141176 | 32419 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | Permit Number 36947 | 5990009.30581449 | 2102467.22445118 | 37.752398967394 | -122.477452096473 | (37.752398967394, -122.477452096473) | |||
103717 | 103717 | 12749 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1714 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3X3 | 5990095.47734 | 2114754.58354 | 37.7861417091128 | -122.478052350416 | (37.7861417091128, -122.478052350416) | |||
114826 | 114826 | 12748 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1714 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 5990114.56006 | 2114756.24917 | 37.7861473900704 | -122.477986451795 | (37.7861473900704, -122.477986451795) | |||
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) | |||
108115 | 108115 | 12747 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1711 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 5x5 | 5990137.03852 | 2114678.28277 | 37.7859346208741 | -122.47790298136299 | (37.7859346208741, -122.477902981363) | |||
92803 | 92803 | 12746 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1708 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5990140.905069999 | 2114757.41663 | 37.7861521246527 | -122.477895391404 | (37.7861521246527, -122.477895391404) | |||
93574 | 93574 | 100394 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1800X Lincoln Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | ||||
102735 | 102735 | 100393 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1800X Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | ||||
114747 | 114747 | 100395 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1800X Lincoln Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | ||||
140356 | 140356 | 100392 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1800X Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769124 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | ||||
80818 | 80818 | 12743 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1641 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5990285.065780001 | 2114712.64103 | 37.7860375492525 | -122.477393365207 | (37.7860375492525, -122.477393365207) | |||
96356 | 96356 | 12740 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1637 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 5990313.43665 | 2114711.3516599997 | 37.7860356551531 | -122.477295116444 | (37.7860356551531, -122.477295116444) | |||
77970 | 77970 | 12741 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1638 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 4X4 | 5990321.4540800005 | 2114762.4147099997 | 37.786176325151295 | -122.47727111168899 | (37.7861763251513, -122.477271111689) | |||
160965 | 160965 | 65714 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1630 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1990 12:00:00 AM | 16 | Permit Number 28646 | 5990406.783530001 | 2113406.96053 | 37.7824595769169 | -122.47687682313699 | (37.7824595769169, -122.476876823137) | ||
141134 | 141134 | 12730 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1619 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | 5990437.55256 | 2114717.69591 | 37.786060275243294 | -122.476866177185 | (37.7860602752433, -122.476866177185) | |||
140687 | 140687 | 12731 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1619 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 5990457.99077 | 2114717.95371 | 37.7860621686583 | -122.476795486066 | (37.7860621686583, -122.476795486066) | |||
98768 | 98768 | 12732 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1619 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5990481.52989 | 2114717.45643 | 37.7860621686584 | -122.476714011555 | (37.7860621686584, -122.476714011555) | |||
24716 | 24716 | 47878 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 41X 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45624 | 5990495.13219 | 2114853.7022700002 | 37.786437050562704 | -122.476676909352 | (37.7864370505627, -122.476676909352) | |
173090 | 173090 | 109385 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 41X 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5990496.07684 | 2114830.6827 | 37.7863739000635 | -122.47667195873301 | (37.7863739000635, -122.476671958733) | |||
38645 | 38645 | 32303 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 750 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 36880 | 5990706.9497 | 2110266.1077900003 | 37.773853068141605 | -122.47560897417699 | (37.7738530681416, -122.475608974177) | |||
111922 | 111922 | 44211 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1466 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43658 | 5990873.69248126 | 2105421.34105709 | 37.76056030978 | -122.474678523283 | (37.76056030978, -122.474678523283) | ||||
111033 | 111033 | 111337 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2178 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | 3x10 | Permit Number 775561 | 5991058.1 | 2100603.7 | 37.7473430166558 | -122.47368930100001 | (37.7473430166558, -122.473689301) | |
79124 | 79124 | 11774 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 2x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
91193 | 91193 | 11791 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
92042 | 92042 | 11788 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
102978 | 102978 | 11789 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
111936 | 111936 | 11787 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
121435 | 121435 | 11773 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
112455 | 112455 | 11817 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
122991 | 122991 | 11815 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
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) | ||
48911 | 48911 | 68331 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2338 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32146 | 5991366.81812 | 2112033.7901 | 37.778744872635606 | -122.473455364804 | (37.7787448726356, -122.473455364804) | ||
96683 | 96683 | 11823 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1299X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | |||
118852 | 118852 | 11820 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1299X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | |||
94557 | 94557 | 38644 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2371 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/1998 12:00:00 AM | Permit Number 40569 | 5991667.78903268 | 2099298.30551377 | 37.7437940310181 | -122.47148595434099 | (37.7437940310181, -122.471485954341) | |||
99323 | 99323 | 38645 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2371 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 40569 | 5991667.78903268 | 2099298.30551377 | 37.7437940310181 | -122.47148595434099 | (37.7437940310181, -122.471485954341) | ||||
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) | |||
156775 | 156775 | 68873 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 161 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 10 | Permit Number 32844 | 5992095.21626 | 2114354.3372400003 | 37.7851586118271 | -122.47110467851499 | (37.7851586118271, -122.471104678515) | |
94268 | 94268 | 50109 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1562 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46831 | 5992344.65613496 | 2096805.82402753 | 37.736989442757505 | -122.468964178249 | (37.7369894427575, -122.468964178249) | ||
94598 | 94598 | 50108 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1562 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46831 | 5992344.65613496 | 2096805.82402753 | 37.736989442757505 | -122.468964178249 | (37.7369894427575, -122.468964178249) | ||
141974 | 141974 | 50107 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1562 Portola Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46831 | 5992344.65613496 | 2096805.82402753 | 37.736989442757505 | -122.468964178249 | (37.7369894427575, -122.468964178249) | ||
92887 | 92887 | 121667 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 243 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992346.75268289 | 2097836.73381964 | 37.7398201819052 | -122.469031933295 | (37.7398201819052, -122.469031933295) | |||||
19684 | 19684 | 50106 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1550 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46830 | 5992376.29027554 | 2096837.8582672002 | 37.7370792283941 | -122.468857136293 | (37.7370792283941, -122.468857136293) | ||
93820 | 93820 | 50105 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1550 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46830 | 5992376.29027554 | 2096837.8582672002 | 37.7370792283941 | -122.468857136293 | (37.7370792283941, -122.468857136293) | ||
102797 | 102797 | 50102 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1530 Portola Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46829 | 5992435.00755539 | 2096888.46432184 | 37.737221572040205 | -122.468657807095 | (37.7372215720402, -122.468657807095) | ||
109013 | 109013 | 50104 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1530 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46829 | 5992435.00755539 | 2096888.46432184 | 37.737221572040205 | -122.468657807095 | (37.7372215720402, -122.468657807095) | ||
128368 | 128368 | 50103 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1530 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46829 | 5992435.00755539 | 2096888.46432184 | 37.737221572040205 | -122.468657807095 | (37.7372215720402, -122.468657807095) | ||
86002 | 86002 | 50101 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1520 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46828 | 5992463.83947388 | 2096912.47054003 | 37.7372891525979 | -122.46855986898599 | (37.7372891525979, -122.468559868986) | ||
122709 | 122709 | 50100 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1520 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46828 | 5992463.83947388 | 2096912.47054003 | 37.7372891525979 | -122.46855986898599 | (37.7372891525979, -122.468559868986) | ||
92300 | 92300 | 50099 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1510 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46827 | 5992486.72879777 | 2096933.93018279 | 37.7373493975579 | -122.468482291601 | (37.7373493975579, -122.468482291601) | ||
22305 | 22305 | 68937 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 518 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/2017 12:00:00 AM | 3 | Permit Number 779489 | 5992539.41235 | 2111890.04765 | 37.7784180283155 | -122.46938847408998 | (37.7784180283155, -122.46938847409) |
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");