trees
39,840 rows where qLegalStatus_id = 7 sorted by qCaretaker_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7530 | 27369 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 251 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | 7 | 9 | 11 | 28852 | 10 | |||
10223 | 7769 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | 7 | 9 | 11 | 28852 | 10 | |||
33198 | 27368 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 251 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | 7 | 9 | 11 | 28852 | 10 | |||
36932 | 27367 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 251 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | 7 | 9 | 11 | 28852 | 10 | |||
52534 | 7773 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | 7 | 9 | 11 | 28852 | 10 | |||
63035 | 7774 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 6 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | 7 | 9 | 11 | 28852 | 10 | |||
69608 | 27372 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 251 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | 7 | 9 | 11 | 28852 | 10 | |||
93928 | 7776 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 8 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 04/16/1990 12:00:00 AM | 6 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | 7 | 9 | 11 | 28852 | 10 | ||
141249 | 7777 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 9 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | 7 | 9 | 11 | 28852 | 10 | |||
145620 | 7771 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | 7 | 9 | 11 | 28852 | 10 | |||
164126 | 27373 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 251 Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | 7 | 9 | 11 | 28852 | 10 | |||
174805 | 27371 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 251 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 18 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | 7 | 9 | 11 | 28852 | 10 | |||
176638 | 27370 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 251 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | 7 | 9 | 11 | 28852 | 10 | |||
177792 | 7775 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 7 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | 7 | 9 | 11 | 28852 | 10 | |||
178470 | 7770 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | 7 | 9 | 11 | 28852 | 10 | |||
19639 | 6826 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
20856 | 6820 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
21328 | 6821 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
23319 | 6827 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
27391 | 6825 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
28370 | 29458 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1809X Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016520.1701445 | 2092944.0657869 | 37.7277529727716 | -122.385108820711 | (37.7277529727716, -122.385108820711) | 10 | 3 | 8 | 58 | 1 | ||
31471 | 6631 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/15/2001 12:00:00 AM | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | 10 | 3 | 8 | 58 | 1 | ||
35237 | 116382 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2501 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | DPW for City Agency | 3x3 | 6011435.88896489 | 2101815.42613948 | 37.7518292809831 | -122.403309184671 | (37.7518292809831, -122.403309184671) | 10 | 4 | 8 | 28859 | 19 | |||
37080 | 6828 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
41490 | 6632 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | 10 | 3 | 8 | 58 | 1 | |||
42315 | 29508 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1850X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 3 | 3x3 | 6016520.1701445 | 2092944.0657869 | 37.7277529727716 | -122.385108820711 | (37.7277529727716, -122.385108820711) | 10 | 3 | 8 | 58 | 1 | ||
42767 | 6830 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
46216 | 6816 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
56232 | 6621 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | 10 | 3 | 8 | 58 | 1 | |||
63178 | 67338 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2501 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | DPW for City Agency | 07/22/1992 12:00:00 AM | 3x3 | Permit Number 30822 | 6011435.88896489 | 2101815.42613948 | 37.7518292809831 | -122.403309184671 | (37.7518292809831, -122.403309184671) | 10 | 4 | 8 | 28859 | 19 | |
64162 | 29457 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1809X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016492.91829 | 2092912.51025 | 37.7276648199576 | -122.38520083393 | (37.7276648199576, -122.38520083393) | 10 | 3 | 8 | 58 | 1 | ||
64865 | 29451 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1829X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016488.0524002 | 2092900.9411781 | 37.7276327843847 | -122.385216849755 | (37.7276327843847, -122.385216849755) | 10 | 3 | 8 | 58 | 1 | ||
67214 | 29455 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1809X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016520.1701445 | 2092944.0657869 | 37.7277529727716 | -122.385108820711 | (37.7277529727716, -122.385108820711) | 10 | 3 | 8 | 58 | 1 | ||
86267 | 29509 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1850X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016520.1701445 | 2092944.0657869 | 37.7277529727716 | -122.385108820711 | (37.7277529727716, -122.385108820711) | 10 | 3 | 8 | 58 | 1 | ||
94432 | 29453 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1829X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016488.0524002 | 2092900.9411781 | 37.7276327843847 | -122.385216849755 | (37.7276327843847, -122.385216849755) | 10 | 3 | 8 | 58 | 1 | ||
115039 | 6823 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1450X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
115268 | 6817 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
120363 | 29456 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1809X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/27/2008 12:00:00 AM | 3 | 3X3 | 6016520.1701445 | 2092944.0657869 | 37.7277529727716 | -122.385108820711 | (37.7277529727716, -122.385108820711) | 10 | 3 | 8 | 58 | 1 | ||
124059 | 29454 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1829X Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016488.0524002 | 2092900.9411781 | 37.7276327843847 | -122.385216849755 | (37.7276327843847, -122.385216849755) | 10 | 3 | 8 | 58 | 1 | ||
129171 | 27857 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
131896 | 6822 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
150090 | 29507 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1850X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 16 | 3x3 | 6016520.1701445 | 2092944.0657869 | 37.7277529727716 | -122.385108820711 | (37.7277529727716, -122.385108820711) | 10 | 3 | 8 | 58 | 1 | ||
155772 | 6824 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
158152 | 6829 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
165985 | 6831 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1450X Fairfax Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
170395 | 29452 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1829X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016488.0524002 | 2092900.9411781 | 37.7276327843847 | -122.385216849755 | (37.7276327843847, -122.385216849755) | 10 | 3 | 8 | 58 | 1 | ||
188909 | 6818 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
190734 | 6815 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
157876 | 111096 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 67 SAINT CHARLES AVE | 31 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 15 | 5992079 | 2088073 | 37.7129959107362 | -122.469247237289 | (37.7129959107362, -122.469247237289) | 9 | 8 | 6 | 64 | 24 | |||
175730 | 254646 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 67 Saint Charles Ave | 31 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Private | 3x3 | 5992096 | 2088072 | 37.7129941473192 | -122.469188407447 | (37.7129941473192, -122.469188407447) | 9 | 8 | 6 | 64 | 24 | |||
10820 | 27018 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1525 Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 12 | 3X3 | 6010513.2597857 | 2094754.7801651 | 37.7323906999135 | -122.4060024251 | (37.7323906999135, -122.4060024251) | 10 | 3 | 7 | 309 | 28 | |||
23960 | 18408 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 999X Potrero Ave | 15 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 05/23/1997 12:00:00 AM | 18 | 2X4 | 6010520.259169 | 2103656.1388783 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | 10 | 4 | 8 | 28859 | 19 | ||
29131 | 18432 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001X Potrero Ave | 7 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 01/20/2016 12:00:00 AM | 40 | 3X3 | 6010537.1589047 | 2103412.4254884 | 37.7561640514811 | -122.406529656376 | (37.7561640514811, -122.406529656376) | 10 | 4 | 8 | 28859 | 19 | ||
36693 | 18442 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001X Potrero Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 01/20/2016 12:00:00 AM | 40 | 3X3 | 6010537.1589047 | 2103412.4254884 | 37.7561640514811 | -122.406529656376 | (37.7561640514811, -122.406529656376) | 10 | 4 | 8 | 28859 | 19 | ||
37801 | 18399 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 999X Potrero Ave | 6 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 24 | 4x4 | 6010520.259169 | 2103656.1388783 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | 10 | 4 | 8 | 28859 | 19 | |||
43737 | 18435 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001X Potrero Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 24 | 4X4 | 6010537.1589047 | 2103412.4254884 | 37.7561640514811 | -122.406529656376 | (37.7561640514811, -122.406529656376) | 10 | 4 | 8 | 28859 | 19 | |||
49279 | 25482 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 999X Potrero Ave | 16 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 18 | 3x3 | 6010520.259169 | 2103656.1388783 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | 10 | 4 | 8 | 28859 | 19 | |||
53335 | 18438 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001X Potrero Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 40 | 3X3 | 6010537.1589047 | 2103412.4254884 | 37.7561640514811 | -122.406529656376 | (37.7561640514811, -122.406529656376) | 10 | 4 | 8 | 28859 | 19 | |||
75845 | 25486 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 999X Potrero Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 45 | 3X3 | 6010520.259169 | 2103656.1388783 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | 10 | 4 | 8 | 28859 | 19 | |||
79416 | 25483 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 999X Potrero Ave | 17 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 12 | 3X3 | 6010520.259169 | 2103656.1388783 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | 10 | 4 | 8 | 28859 | 19 | |||
90642 | 27017 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1525 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 12 | 3X3 | 6010513.2597857 | 2094754.7801651 | 37.7323906999135 | -122.4060024251 | (37.7323906999135, -122.4060024251) | 10 | 3 | 7 | 309 | 28 | |||
92473 | 18426 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001X Potrero Ave | 1 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 01/20/2016 12:00:00 AM | 30 | 3X3 | 6010537.1589047 | 2103412.4254884 | 37.7561640514811 | -122.406529656376 | (37.7561640514811, -122.406529656376) | 10 | 4 | 8 | 28859 | 19 | ||
105831 | 18429 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001X Potrero Ave | 4 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 30 | 3x3 | 6010537.1589047 | 2103412.4254884 | 37.7561640514811 | -122.406529656376 | (37.7561640514811, -122.406529656376) | 10 | 4 | 8 | 28859 | 19 | |||
108885 | 27019 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1525 Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 12 | 3X3 | 6010513.2597857 | 2094754.7801651 | 37.7323906999135 | -122.4060024251 | (37.7323906999135, -122.4060024251) | 10 | 3 | 7 | 309 | 28 | |||
113572 | 18428 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001X Potrero Ave | 3 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 24 | 3X3 | 6010537.1589047 | 2103412.4254884 | 37.7561640514811 | -122.406529656376 | (37.7561640514811, -122.406529656376) | 10 | 4 | 8 | 28859 | 19 | |||
117271 | 18427 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001X Potrero Ave | 2 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 40 | 3X3 | 6010537.1589047 | 2103412.4254884 | 37.7561640514811 | -122.406529656376 | (37.7561640514811, -122.406529656376) | 10 | 4 | 8 | 28859 | 19 | |||
124054 | 18434 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001X Potrero Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 40 | 3X3 | 6010537.1589047 | 2103412.4254884 | 37.7561640514811 | -122.406529656376 | (37.7561640514811, -122.406529656376) | 10 | 4 | 8 | 28859 | 19 | |||
136266 | 27016 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1525 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 18 | 3X3 | 6010513.2597857 | 2094754.7801651 | 37.7323906999135 | -122.4060024251 | (37.7323906999135, -122.4060024251) | 10 | 3 | 7 | 309 | 28 | |||
143525 | 18439 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001X Potrero Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 40 | 3x3 | 6010537.1589047 | 2103412.4254884 | 37.7561640514811 | -122.406529656376 | (37.7561640514811, -122.406529656376) | 10 | 4 | 8 | 28859 | 19 | |||
148001 | 18430 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001X Potrero Ave | 5 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 30 | 3X3 | 6010537.1589047 | 2103412.4254884 | 37.7561640514811 | -122.406529656376 | (37.7561640514811, -122.406529656376) | 10 | 4 | 8 | 28859 | 19 | |||
154762 | 18437 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001X Potrero Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 40 | 3X3 | 6010537.1589047 | 2103412.4254884 | 37.7561640514811 | -122.406529656376 | (37.7561640514811, -122.406529656376) | 10 | 4 | 8 | 28859 | 19 | |||
157580 | 25485 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 999X Potrero Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 05/23/1997 12:00:00 AM | 8 | 3X3 | 6010520.259169 | 2103656.1388783 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | 10 | 4 | 8 | 28859 | 19 | ||
158969 | 18436 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001X Potrero Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 40 | 3X3 | 6010537.1589047 | 2103412.4254884 | 37.7561640514811 | -122.406529656376 | (37.7561640514811, -122.406529656376) | 10 | 4 | 8 | 28859 | 19 | |||
163918 | 18401 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 999X Potrero Ave | 8 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 18 | 4x4 | 6010520.259169 | 2103656.1388783 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | 10 | 4 | 8 | 28859 | 19 | |||
171987 | 18431 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001X Potrero Ave | 6 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 01/20/2016 12:00:00 AM | 24 | 3X3 | 6010537.1589047 | 2103412.4254884 | 37.7561640514811 | -122.406529656376 | (37.7561640514811, -122.406529656376) | 10 | 4 | 8 | 28859 | 19 | ||
183203 | 17737 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1802X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 12 | 3X3 | 6002240.5506838 | 2112991.3064345 | 37.78199765203 | -122.435907463701 | (37.78199765203, -122.435907463701) | 15 | 5 | 11 | 29490 | 41 | |||
192557 | 25484 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 999X Potrero Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 3 | 3x3 | 6010520.259169 | 2103656.1388783 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | 10 | 4 | 8 | 28859 | 19 | |||
33150 | 30749 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 5075 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 03/08/2013 12:00:00 AM | 3 | 3x3 | Permit Number 53643 | 6014764.79010723 | 2094744.21942808 | 37.7325985731591 | -122.391303034813 | (37.7325985731591, -122.391303034813) | 10 | 3 | 8 | 58 | 1 | |
52492 | 15728 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4400 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 04/20/1995 12:00:00 AM | 4 | 3X3 | 6002668.6888386 | 2093023.5286977 | 37.7271952084184 | -122.432999267314 | (37.7271952084184, -122.432999267314) | 9 | 7 | 6 | 28861 | 25 | ||
59636 | 15729 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4400 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 04/20/1995 12:00:00 AM | 6 | 3X3 | 6002668.6888386 | 2093023.5286977 | 37.7271952084184 | -122.432999267314 | (37.7271952084184, -122.432999267314) | 9 | 7 | 6 | 28861 | 25 | ||
72345 | 22312 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 5075 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 07/08/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53643 | 6014763.8406325 | 2094744.5347125 | 37.7325993861716 | -122.391306339437 | (37.7325993861716, -122.391306339437) | 10 | 3 | 8 | 58 | 1 | |
101029 | 108939 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1801 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Private | 01/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774694 | 6004341.9 | 2118349.2 | 37.7968282226561 | -122.429019881342 | (37.7968282226561, -122.429019881342) | 13 | 9 | 1 | 57 | 17 |
122791 | 91912 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1701X Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 12/15/2008 12:00:00 AM | 3 | 3x3 | 5990490.453055 | 2106519.165342 | 37.7635524271157 | -122.47608414324 | (37.7635524271157, -122.47608414324) | 1 | 8 | 3 | 56 | 12 | ||
133801 | 102879 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1680X Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Private | 07/23/2010 12:00:00 AM | 2 | 4x4 | Permit Number 53643 | 6014844.7 | 2094689.6 | 37.7324530338407 | -122.391022948435 | (37.7324530338407, -122.391022948435) | 10 | 3 | 8 | 58 | 1 |
169152 | 15730 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4400 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 04/20/1995 12:00:00 AM | 7 | 3X3 | 6002668.6888386 | 2093023.5286977 | 37.7271952084184 | -122.432999267314 | (37.7271952084184, -122.432999267314) | 9 | 7 | 6 | 28861 | 25 | ||
185383 | 91913 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1701X Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 12/15/2008 12:00:00 AM | 3 | 3x3 | 5990490.453055 | 2106519.165342 | 37.7635524271157 | -122.47608414324 | (37.7635524271157, -122.47608414324) | 1 | 8 | 3 | 56 | 12 | ||
19385 | 16804 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2060 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 18 | 4x3 | 6001450.7704065 | 2113227.696464 | 37.7826018222756 | -122.438656679492 | (37.7826018222756, -122.438656679492) | 15 | 5 | 11 | 29490 | 41 | |||
23982 | 5293 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1500 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 12 | 3x3 | 6001245.27295 | 2113493.90626 | 37.7833210739867 | -122.439386698953 | (37.7833210739867, -122.439386698953) | 15 | 5 | 11 | 29490 | 41 | |||
30080 | 8550 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2121 Geary Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 30 | 3X3 | 6001601.9223045 | 2113552.6348977 | 37.7835026179143 | -122.438157044438 | (37.7835026179143, -122.438157044438) | 15 | 5 | 11 | 29490 | 41 | |||
31354 | 5288 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1450 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 01/01/2010 12:00:00 AM | 3 | 3X3 | 6001279.3901091 | 2113342.5749494 | 37.7829074983832 | -122.439257816981 | (37.7829074983832, -122.439257816981) | 15 | 5 | 11 | 29490 | 41 | ||
37348 | 116701 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1450 Divisadero St | 6 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 3X3 | 6001279.3901091 | 2113342.5749494 | 37.7829074983832 | -122.439257816981 | (37.7829074983832, -122.439257816981) | 15 | 5 | 11 | 29490 | 41 | ||||
48986 | 16794 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2040 O'Farrell St | 5 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 24 | 4X3 | 6001550.4196916 | 2113241.6119033 | 37.7826456988205 | -122.438312933736 | (37.7826456988205, -122.438312933736) | 15 | 5 | 11 | 29490 | 41 | |||
56959 | 8553 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2121 Geary Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 24 | 3X3 | 6001601.9223045 | 2113552.6348977 | 37.7835026179143 | -122.438157044438 | (37.7835026179143, -122.438157044438) | 15 | 5 | 11 | 29490 | 41 | |||
63682 | 8551 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2121 Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 24 | 3X3 | 6001601.9223045 | 2113552.6348977 | 37.7835026179143 | -122.438157044438 | (37.7835026179143, -122.438157044438) | 15 | 5 | 11 | 29490 | 41 | |||
68592 | 116702 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1450 Divisadero St | 7 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 3X3 | 6001279.3901091 | 2113342.5749494 | 37.7829074983832 | -122.439257816981 | (37.7829074983832, -122.439257816981) | 15 | 5 | 11 | 29490 | 41 | ||||
70417 | 5290 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2070X O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 18 | 3X3 | 6001402.6275094 | 2113220.9735965 | 37.78258062415 | -122.43882275095 | (37.78258062415, -122.43882275095) | 15 | 5 | 11 | 29490 | 41 | |||
91254 | 16810 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2060 O'Farrell St | 7 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 18 | 3x3 | 6001450.7704065 | 2113227.696464 | 37.7826018222756 | -122.438656679492 | (37.7826018222756, -122.438656679492) | 15 | 5 | 11 | 29490 | 41 | |||
108469 | 16808 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2060 O'Farrell St | 5 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 18 | 4x3 | 6001450.7704065 | 2113227.696464 | 37.7826018222756 | -122.438656679492 | (37.7826018222756, -122.438656679492) | 15 | 5 | 11 | 29490 | 41 | |||
109789 | 5289 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2070X O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 18 | 3X3 | 6001402.6275094 | 2113220.9735965 | 37.78258062415 | -122.43882275095 | (37.78258062415, -122.43882275095) | 15 | 5 | 11 | 29490 | 41 | |||
115041 | 8552 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2121 Geary Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 30 | 3X3 | 6001601.9223045 | 2113552.6348977 | 37.7835026179143 | -122.438157044438 | (37.7835026179143, -122.438157044438) | 15 | 5 | 11 | 29490 | 41 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );