trees
39,840 rows where qLegalStatus_id = 7 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9444 | 205868 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 312 Lakeview Ave | 1 | : | Tree | Private 2 | 11/04/1969 12:00:00 AM | 13 | Width 3ft | Permit Number 6398 | 5996845.79725 | 2089640.92362 | 37.7175753652817 | -122.452884796511 | (37.7175753652817, -122.452884796511) | 9 | 8 | 6 | 28861 | 24 | |
9586 | 191511 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 392 04th St | 2 | : | Tree | Private 2 | 09/27/2001 12:00:00 AM | 5 | Width 3ft | Permit Number 44376 | 6012652.22642 | 2112454.21838 | 37.7811088850041 | -122.399849876973 | (37.7811088850041, -122.399849876973) | 6 | 2 | 9 | 28856 | 34 | |
12141 | 219848 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 47 Clarendon Ave | 1 | : | Tree | Private 2 | 06/20/2010 12:00:00 AM | 4 | Width 3ft | Permit Number 768045 | 5998024.44262 | 2104629.5149 | 37.7587979065061 | -122.449890386836 | (37.7587979065061, -122.449890386836) | 15 | 5 | 4 | 28862 | 38 | |
13108 | 207243 | Permitted Site 7 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 324 Lakeview Ave | 1 | : | Tree | Private 2 | 08/19/2015 12:00:00 AM | 1 | Width 3ft | Permit Number 776404 | 5996808.75565 | 2089668.45236 | 37.7176488300194 | -122.453014817795 | (37.7176488300194, -122.453014817795) | 9 | 8 | 6 | 28861 | 24 | |
17243 | 218510 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 330 Lakeview Ave | 1 | : | Tree | Private 2 | 07/25/2000 12:00:00 AM | 7 | Width 3ft | Permit Number 43360 | 5996781.43157 | 2089689.53525 | 37.7177051527504 | -122.453110785357 | (37.7177051527504, -122.453110785357) | 9 | 8 | 6 | 28861 | 24 | |
30656 | 256908 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 751 25th Ave | : | Tree | Private 2 | FUF | 01/04/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782750 | 5988160.57678 | 2110864.58172 | 37.7753483638678 | -122.484461088261 | (37.7753483638678, -122.484461088261) | 11 | 6 | 2 | 55 | 26 | |
31884 | 255500 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 463 Arlington St | : | Tree | Private 2 | FUF | 06/01/2018 12:00:00 AM | 3 | Permit Number 779226 | 6003846.45772 | 2095958.75203 | 37.7353214068723 | -122.429136928426 | (37.7353214068723, -122.429136928426) | 2 | 7 | 5 | 63 | 7 | ||
38044 | 255484 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2147 Beach St | : | Tree | Private 2 | FUF | 05/30/2018 12:00:00 AM | 3 | Permit Number 781954 | 5999947.25363 | 2120887.03087 | 37.8035466909489 | -122.444408807729 | (37.8035466909489, -122.444408807729) | 13 | 9 | 1 | 57 | 17 | ||
43839 | 247801 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 462 30th St | 1 | : | Tree | Private 2 | 12/05/1987 12:00:00 AM | 8 | Width 3ft | Permit Number 24911 | 6003630.84189 | 2098375.23957 | 37.7419443208891 | -122.430054719445 | (37.7419443208891, -122.430054719445) | 2 | 7 | 5 | 63 | 22 | |
47743 | 254574 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2343 42nd Ave | : | Tree | Private 2 | FUF | 03/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781480 | 5983281.30564 | 2099193.73405 | 37.7430181719151 | -122.500476236571 | (37.7430181719151, -122.500476236571) | 1 | 8 | 3 | 29491 | 35 | |
54518 | 200335 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 7 | : | Tree | Purchasing Dept 18 | 4 | Width 2ft | 6015505.4551 | 2098329.2709 | 37.7424834725483 | -122.388992567847 | (37.7424834725483, -122.388992567847) | 10 | 3 | 8 | 58 | 1 | |||
56075 | 94645 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 30 Middle Point Rd | 34 | : | Tree | Private 2 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||||
81370 | 256662 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1306 Broadway | : | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | Permit Number 782593 | 6007370.8774 | 2118134.97157 | 37.7964109931986 | -122.418523691035 | (37.7964109931986, -122.418523691035) | 5 | 1 | 10 | 28858 | 32 | ||
92612 | 238575 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 127 Buchanan St | 1 | : | Tree | Private 2 | 05/02/2002 12:00:00 AM | 7 | Width 3ft | Permit Number 45000 | 6004751.79623 | 2108930.40583 | 37.7709897493005 | -122.426930391028 | (37.7709897493005, -122.426930391028) | 7 | 9 | 11 | 28852 | 10 | |
132986 | 200334 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 4 | : | Tree | Purchasing Dept 18 | 11/15/1992 12:00:00 AM | 8 | Width 3ft | 6015528.91481 | 2098358.82009 | 37.7425659089002 | -122.388913512973 | (37.7425659089002, -122.388913512973) | 10 | 3 | 8 | 58 | 1 | ||
133480 | 94646 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 30 Middle Point Rd | 35 | : | Tree | Private 2 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||||
145159 | 255476 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3099 California St | : | Tree | Private 2 | FUF | 05/25/2018 12:00:00 AM | 3 | Permit Number 780282 | 5999555.47805 | 2115010.95429 | 37.7873901837957 | -122.445341811443 | (37.7873901837957, -122.445341811443) | 15 | 6 | 1 | 29490 | 31 | ||
183886 | 105148 | Permitted Site 7 | Tree(s) :: 17 | 185 Stratford Dr | : | Tree | Private 2 | 12/26/2013 12:00:00 AM | Permit Number 770387 | 5990916.9 | 2091282.3 | 37.7217406386467 | -122.473497746062 | (37.7217406386467, -122.473497746062) | 9 | 8 | 4 | 64 | 40 | ||||
8599 | 262043 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 245 11th St | : Cutout | Tree | Private 2 | FUF | 04/14/2020 12:00:00 AM | 3 | Permit Number 785251 | 6008265.74007 | 2109435.35593 | 37.7725742877847 | -122.414811260337 | (37.7725742877847, -122.414811260337) | 8 | 2 | 9 | 28853 | 34 | ||
31000 | 104827 | Permitted Site 7 | :: 45 | 4366 26th St | : Cutout | Tree | Private 2 | 3X3 | 6001535.3 | 2100615.2 | 37.7479758185871 | -122.437460780102 | (37.7479758185871, -122.437460780102) | 2 | 4 | 5 | 28862 | 22 | |||||
47339 | 257897 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1920 41st Ave | : Cutout | Tree | Private 2 | FUF | 01/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782788 | 5983533.51637 | 2102067.62361 | 37.7509238827647 | -122.499816549562 | (37.7509238827647, -122.499816549562) | 1 | 8 | 3 | 29491 | 35 | |
124043 | 93976 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3261 Harrison St | : Cutout | Tree | Private 2 | 05/06/2010 12:00:00 AM | Permit Number 53402 | 6009036 | 2099698 | 37.7458809718535 | -122.411458783557 | (37.7458809718535, -122.411458783557) | 2 | 7 | 7 | 28859 | 2 | ||||
193154 | 87273 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 4 Miraloma Dr | 1 | Back Yard : Cutout | Tree | Private 2 | 03/12/2008 12:00:00 AM | Permit Number 50295 | 5995203 | 2097905 | 37.7401722415629 | -122.45916124145 | (37.7401722415629, -122.45916124145) | 9 | 7 | 4 | 59 | 40 | |||
6104 | 92481 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 12 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
8529 | 108850 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 250x MONTCALM ST | 1 | Back Yard : Yard | Tree | Private 2 | 02/09/2015 12:00:00 AM | 3 | Permit Number 774524 | 6009909.2 | 2099657.1 | 37.7458176084011 | -122.40843648152 | (37.7458176084011, -122.40843648152) | 2 | 7 | 7 | 28859 | 2 | ||
50549 | 113192 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 150X Museum Way | 1 | Back Yard : Yard | Tree | Private 2 | 09/11/2015 12:00:00 AM | Permit Number 774288 | 6001029.7 | 2106463.5 | 37.7640050744287 | -122.439628320832 | (37.7640050744287, -122.439628320832) | 15 | 5 | 5 | 28862 | 3 | |||
59701 | 86946 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 495 Pacheco St | 1 | Back Yard : Yard | Tree | Private 2 | 11/20/2007 12:00:00 AM | 3x3 | Permit Number 51051 | 5993544.7 | 2101797.8 | 37.750765410178 | -122.465177603148 | (37.750765410178, -122.465177603148) | 1 | 8 | 4 | 29491 | 40 | ||
61377 | 92475 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 5 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
62383 | 92476 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 6 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
63865 | 92484 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 15 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
74399 | 92474 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 4 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
92843 | 87388 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 201 Topeka Ave | 2 | Back Yard : Yard | Tree | Private 2 | 04/24/2008 12:00:00 AM | Permit Number 50366 | 6012955.9 | 2095077.8 | 37.7334139596128 | -122.397580237664 | (37.7334139596128, -122.397580237664) | 10 | 3 | 8 | 58 | 1 | |||
94535 | 87564 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 3 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
113800 | 87387 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 201 Topeka Ave | Back Yard : Yard | Tree | Private 2 | 04/24/2008 12:00:00 AM | Permit Number 50366 | 6012955.9 | 2095077.8 | 37.7334139596128 | -122.397580237664 | (37.7334139596128, -122.397580237664) | 10 | 3 | 8 | 58 | 1 | ||||
130338 | 92480 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 10 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
133016 | 87389 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 201 Topeka Ave | 3 | Back Yard : Yard | Tree | Private 2 | 04/24/2008 12:00:00 AM | Permit Number 50366 | 6012955.9 | 2095077.8 | 37.7334139596128 | -122.397580237664 | (37.7334139596128, -122.397580237664) | 10 | 3 | 8 | 58 | 1 | |||
139299 | 87562 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 1 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
147070 | 88028 | Permitted Site 7 | Tree(s) :: 17 | 495 Pacheco St | 1 | Back Yard : Yard | Tree | Private 2 | 06/23/2008 12:00:00 AM | Permit Number 51051 | 5993544.7 | 2101797.8 | 37.750765410178 | -122.465177603148 | (37.750765410178, -122.465177603148) | 1 | 8 | 4 | 29491 | 40 | |||
181279 | 87563 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 2 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
192331 | 92485 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 11 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
3226 | 107892 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 162 Brewster St | Front Yard : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773952 | 6010231.01704 | 2099016.49618 | 37.7440766668365 | -122.407278527778 | (37.7440766668365, -122.407278527778) | 2 | 7 | 7 | 28859 | 2 | ||
20835 | 63301 | Permitted Site 7 | Tree(s) :: 17 | 3261 Harrison St | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | 18 | Permit Number 53402 | 6009046.03746796 | 2099701.90725396 | 37.7458922633049 | -122.411424351246 | (37.7458922633049, -122.411424351246) | 2 | 7 | 7 | 28859 | 2 | |
23525 | 36443 | Permitted Site 7 | Tree(s) :: 17 | 1260 Plymouth Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 11/20/2009 12:00:00 AM | 3x3 | Permit Number 53041 | 5995883.45550893 | 2092448.59347632 | 37.725229366758 | -122.456414062747 | (37.725229366758, -122.456414062747) | 9 | 7 | 4 | 28861 | 40 | ||
27136 | 114680 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 54 Colby St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | Permit Number 774571 | 6007954.9 | 2093861 | 37.7297931519994 | -122.414784067206 | (37.7297931519994, -122.414784067206) | 9 | 3 | 7 | 309 | 28 | |||
29146 | 31647 | Permitted Site 7 | Tree(s) :: 17 | 4500 Ulloa St | 4 | Front Yard : Cutout | Tree | Private 2 | 02/13/2009 12:00:00 AM | 3x3 | Permit Number 52054 | 5982086.63822537 | 2098111.49533937 | 37.7399764418309 | -122.504526837106 | (37.7399764418309, -122.504526837106) | 1 | 8 | 3 | 29491 | 35 | ||
31678 | 104497 | Permitted Site 7 | Chionanthus retusa :: Chinese Fringe Tree 428 | 26 Allston Way | 1 | Front Yard : Cutout | Tree | Private 2 | 10/11/2013 12:00:00 AM | 3x3 | Permit Number 770732 | 5994373.7 | 2098352 | 37.7413518812257 | -122.462061011692 | (37.7413518812257, -122.462061011692) | 1 | 8 | 4 | 59 | 40 | ||
38995 | 88447 | Permitted Site 7 | Tree(s) :: 17 | 93 Prentiss St | 1 | Front Yard : Cutout | Tree | Private 2 | 07/14/2008 12:00:00 AM | 3x3 | Permit Number 51413 | 6008891.7 | 2098141.7 | 37.7415996198956 | -122.411847801096 | (37.7415996198956, -122.411847801096) | 10 | 7 | 7 | 28859 | 2 | ||
40018 | 105804 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 117 ALPINE TER | 1 | Front Yard : Cutout | Tree | Private 2 | 04/10/2014 12:00:00 AM | 14 | 3x3 | Permit Number 772090 | 6001724.2 | 2108149.5 | 37.7686739192463 | -122.437346990121 | (37.7686739192463, -122.437346990121) | 15 | 5 | 5 | 29492 | 3 | |
42746 | 87674 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 770 Golden Gate Ave | 10 | Front Yard : Cutout | Tree | Private 2 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.423348359154 | (37.7807698496384, -122.423348359154) | 7 | 9 | 11 | 28852 | 41 | ||
48260 | 94583 | Permitted Site 7 | Tree(s) :: 17 | 90 Joost Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6001518 | 2094975.2 | 37.732488714298 | -122.437116855647 | (37.732488714298, -122.437116855647) | 9 | 7 | 5 | 63 | 40 | ||||
55917 | 86731 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Pico Ave | Front Yard : Cutout | Tree | Private 2 | Permit Number 49705 | 5994102.9 | 2092171.9 | 37.7243672527805 | -122.462549157922 | (37.7243672527805, -122.462549157922) | 9 | 8 | 4 | 59 | 40 | |||||
57298 | 109497 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 785 Mangels Ave | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 02/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771883 | 5996438 | 2095245 | 37.7329394498659 | -122.45469900823 | (37.7329394498659, -122.45469900823) | 9 | 7 | 4 | 59 | 40 |
57525 | 54809 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 150 Carmel St | 2 | Front Yard : Cutout | Tree | Private 2 | 03/12/2007 12:00:00 AM | 5 | 3x3 | Permit Number 773425 | 5998092.51354995 | 2105385.25255364 | 37.7608768673293 | -122.449709427273 | (37.7608768673293, -122.449709427273) | 15 | 5 | 11 | 29492 | 12 | |
57527 | 98528 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 428 11th St | 1 | Front Yard : Cutout | Tree | Private 2 | 02/22/2012 12:00:00 AM | 3x3 | Permit Number 768342 | 6009030 | 2108561 | 37.7702164230423 | -122.412105792177 | (37.7702164230423, -122.412105792177) | 8 | 2 | 9 | 28853 | 19 | ||
59660 | 89359 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 308 Tocoloma Ave | 3 | Front Yard : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50704 | 6012556.9 | 2087009.2 | 37.7112369933076 | -122.398393755853 | (37.7112369933076, -122.398393755853) | 10 | 3 | 8 | 309 | 1 | ||
67887 | 108239 | Permitted Site 7 | Tree(s) :: 17 | 15 ASHBURY TER | 1 | Front Yard : Cutout | Tree | Private 2 | 01/14/2015 12:00:00 AM | 3 | 5x50 | Permit Number 774721 | 5999554.7 | 2106911.6 | 37.7651513833487 | -122.444762103204 | (37.7651513833487, -122.444762103204) | 15 | 5 | 5 | 29492 | 9 | |
74522 | 98327 | Permitted Site 7 | Acacia spp :: Acacia Spp 105 | 143 Alhambra St | 2 | Front Yard : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49254 | 6001613.1 | 2120268.4 | 37.8019430002039 | -122.438599729252 | (37.8019430002039, -122.438599729252) | 13 | 9 | 1 | 57 | 17 | ||
83211 | 93959 | Permitted Site 7 | Prunus spp :: Cherry 68 | 419 Elizabeth St | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 53399 | 6003681 | 2102149 | 37.7523090296265 | -122.430150445418 | (37.7523090296265, -122.430150445418) | 2 | 4 | 5 | 28862 | 22 | ||||
105490 | 31648 | Permitted Site 7 | Tree(s) :: 17 | 4500 Ulloa St | 3 | Front Yard : Cutout | Tree | Private 2 | 02/13/2009 12:00:00 AM | 3x3 | Permit Number 52054 | 5982086.63822537 | 2098111.49533937 | 37.7399764418309 | -122.504526837106 | (37.7399764418309, -122.504526837106) | 1 | 8 | 3 | 29491 | 35 | ||
123102 | 87075 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 395 Byxbee St | 6 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
123260 | 87819 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 390 Lansdale Ave | 1 | Front Yard : Cutout | Tree | Private 2 | Permit Number 50681 | 5995630.7 | 2096410.1 | 37.7360921919213 | -122.457574304331 | (37.7360921919213, -122.457574304331) | 9 | 7 | 4 | 59 | 40 | ||||
131019 | 114688 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 231 Dwight St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | Permit Number 774702 | 6010865.8 | 2091429.3 | 37.7232793364177 | -122.404549596707 | (37.7232793364177, -122.404549596707) | 10 | 3 | 7 | 309 | 28 | |||
132540 | 87073 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 395 Byxbee St | 4 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
134671 | 87072 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 395 Byxbee St | 3 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
137939 | 31646 | Permitted Site 7 | Tree(s) :: 17 | 4500 Ulloa St | 2 | Front Yard : Cutout | Tree | Private 2 | 02/13/2009 12:00:00 AM | 3x3 | Permit Number 52054 | 5982086.63822537 | 2098111.49533937 | 37.7399764418309 | -122.504526837106 | (37.7399764418309, -122.504526837106) | 1 | 8 | 3 | 29491 | 35 | ||
141663 | 87074 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 395 Byxbee St | 5 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
144917 | 107863 | Permitted Site 7 | Arbutus unedo :: Strawberry Tree 106 | 218 HOWTH ST | 1 | Front Yard : Cutout | Tree | Private 2 | 3 | 5997350.1 | 2090721.9 | 37.7205723611581 | -122.451219574954 | (37.7205723611581, -122.451219574954) | 9 | 8 | 6 | 28861 | 24 | ||||
150229 | 87675 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 770 Golden Gate Ave | 11 | Front Yard : Cutout | Tree | Private 2 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.423348359154 | (37.7807698496384, -122.423348359154) | 7 | 9 | 11 | 28852 | 41 | ||
154426 | 104498 | Permitted Site 7 | Chionanthus retusa :: Chinese Fringe Tree 428 | 26 Allston Way | 2 | Front Yard : Cutout | Tree | Private 2 | 10/11/2013 12:00:00 AM | 3x3 | Permit Number 770732 | 5994373.7 | 2098352 | 37.7413518812257 | -122.462061011692 | (37.7413518812257, -122.462061011692) | 1 | 8 | 4 | 59 | 40 | ||
158579 | 108442 | Permitted Site 7 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 | 750 12th Ave | Front Yard : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773771 | 5992283.6285 | 2110333.09253 | 37.7741282667999 | -122.470159914203 | (37.7741282667999, -122.470159914203) | 11 | 6 | 2 | 54 | 11 | |||
160866 | 98529 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 428 11th St | 2 | Front Yard : Cutout | Tree | Private 2 | 02/22/2012 12:00:00 AM | 3x3 | Permit Number 768342 | 6009030 | 2108561 | 37.7702164230423 | -122.412105792177 | (37.7702164230423, -122.412105792177) | 8 | 2 | 9 | 28853 | 19 | ||
171612 | 120534 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2043 32nd Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 08/10/2016 12:00:00 AM | 3 | 3x3 | 5986293 | 2101328 | 37.7490546230695 | -122.490219722326 | (37.7490546230695, -122.490219722326) | 1 | 8 | 3 | 29491 | 35 | ||
172950 | 87071 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 395 Byxbee St | 2 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
184104 | 254588 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2014 47th Ave | Front Yard : Cutout | Tree | Private 2 | FUF | 03/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781514 | 5981693.27527 | 2101363.93313 | 37.7488835852013 | -122.50612799747 | (37.7488835852013, -122.50612799747) | 1 | 8 | 3 | 29491 | 35 | |
188216 | 87070 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 395 Byxbee St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
499 | 180799 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Mount Vernon Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 8x8 | Permit Number 782754 | 5998557.73755 | 2089669.84713 | 37.7177527376786 | -122.446969503064 | (37.7177527376786, -122.446969503064) | 9 | 7 | 6 | 28861 | 25 | |
1978 | 87100 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 700 Connecticut St | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 3x3 | Permit Number 50056 | |||||||||||||
2478 | 110785 | Permitted Site 7 | Tree(s) :: 17 | 2 Edna St | 2 | Front Yard : Yard | Tree | Private 2 | 05/06/2015 12:00:00 AM | 3 | 5998788.4 | 2092979.9 | 37.7268545527586 | -122.446410203741 | (37.7268545527586, -122.446410203741) | 9 | 7 | 4 | 28861 | 40 | |||
2885 | 102680 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 333 Eucalyptus Dr | 6 | Front Yard : Yard | Tree | Private 2 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133155 | -122.476573573496 | (37.731002133155, -122.476573573496) | 1 | 8 | 4 | 64 | 14 | |||
8846 | 97906 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 401 Upper Ter | 1 | Front Yard : Yard | Tree | Private 2 | 12/01/2011 12:00:00 AM | 60 | Permit Number 768366 | 5999222.6 | 2106240.8 | 37.7632905770055 | -122.44586250428 | (37.7632905770055, -122.44586250428) | 15 | 5 | 5 | 29492 | 9 | ||
12300 | 93053 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | Front Yard : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | 36 | Permit Number 53387 | ||||||||||||||
12574 | 58273 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 211 Brighton Ave | 1 | Front Yard : Yard | Tree | Private 2 | 09/20/1978 12:00:00 AM | Permit Number 17285 | 5996205.3244984 | 2091294.13562794 | 37.7220779724875 | -122.455218010255 | (37.7220779724875, -122.455218010255) | 9 | 8 | 4 | 28861 | 24 | |||
17896 | 100177 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 252 States St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 768965 | 6000636 | 2106677.4 | 37.7645699751489 | -122.44100535545 | (37.7645699751489, -122.44100535545) | 15 | 5 | 5 | 28862 | 3 | ||||
17986 | 93585 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 6 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
22984 | 92756 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
26253 | 92760 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
27055 | 110561 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 401x FRANCONIA ST | 1 | Front Yard : Yard | Tree | Private 2 | 05/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777241 | 6009999 | 2098658 | 37.7430793263277 | -122.408055517439 | (37.7430793263277, -122.408055517439) | 10 | 7 | 7 | 28859 | 2 | |
29260 | 94420 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 5800 03rd St | 17 | Front Yard : Yard | Tree | Private 2 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849 | 2092184 | 37.7255178628117 | -122.394289979276 | (37.7255178628117, -122.394289979276) | 10 | 3 | 8 | 58 | 1 | ||
29317 | 92765 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
32197 | 93580 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
32209 | 93594 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 15 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
33508 | 92764 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
34099 | 105230 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 69 KEYSTONE WAY | 1 | Front Yard : Yard | Tree | Private 2 | 06/17/2014 12:00:00 AM | 30 | Permit Number 773353 | 5994093.4 | 2093229.9 | 37.7272717167315 | -122.462658710338 | (37.7272717167315, -122.462658710338) | 9 | 8 | 4 | 59 | 40 | ||
34561 | 87199 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 71 Mansfield St | Front Yard : Yard | Tree | Private 2 | 01/31/2008 12:00:00 AM | 3x3 | Permit Number 50216 | 6005338 | 2091826 | 37.7240581044071 | -122.423686361989 | (37.7240581044071, -122.423686361989) | 9 | 7 | 6 | 309 | 5 | |||
35919 | 93595 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 16 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
36571 | 102678 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 333 Eucalyptus Dr | 4 | Front Yard : Yard | Tree | Private 2 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133155 | -122.476573573496 | (37.731002133155, -122.476573573496) | 1 | 8 | 4 | 64 | 14 | |||
38873 | 92763 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
42517 | 93597 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 18 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
43379 | 93610 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 31 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
44736 | 93606 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 27 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 |
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) );