trees
1,732 rows where qLegalStatus_id = 6 sorted by TreeID 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47218 | 99951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1160 Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 06/19/2012 12:00:00 AM | Permit Number 768993 | 6012314.3 | 2120017.7 | 37.8018575696458 | -122.401550680127 | (37.8018575696458, -122.401550680127) | 3 | 1 | 10 | 28860 | 6 | |||
167818 | 99950 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1545 05th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 08/14/2012 12:00:00 AM | Permit Number 768941 | 5994712.1 | 2105033.7 | 37.7597176147703 | -122.461375215787 | (37.7597176147703, -122.461375215787) | 1 | 5 | 4 | 56 | 12 | |||
164727 | 99894 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 99 | 1636 Bush St | 1 | Front Yard : Yard | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 768849 | 6005665 | 2115204 | 37.7882670981083 | -122.424217840789 | (37.7882670981083, -122.424217840789) | 13 | 9 | 1 | 28858 | 41 | |||
40225 | 99859 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 4443 19th St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.438930324474 | (37.7589248414166, -122.438930324474) | 2 | 4 | 5 | 28862 | 3 | ||||
68299 | 99852 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 86 Nordhoff St | 1 | Front Yard : Yard | Tree | Private 2 | 6000395 | 2095652 | 37.7342831509698 | -122.441047861045 | (37.7342831509698, -122.441047861045) | 9 | 7 | 5 | 63 | 40 | |||||
99362 | 99847 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850@14th Ave Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991942 | 2105939 | 37.7620435090796 | -122.471021481615 | (37.7620435090796, -122.471021481615) | 1 | 8 | 11 | 56 | 12 | |||||
100759 | 99832 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 3 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
187077 | 99831 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 2 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
80605 | 99830 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 1 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
30713 | 99829 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 2398 Broadway | 3 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
62300 | 99828 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2398 Broadway | 2 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
184201 | 99827 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
185053 | 99826 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Cascade Walk | 1 | Front Yard : Yard | Tree | Private 2 | 5992183.1 | 2103187.3 | 37.7545020044945 | -122.469987253468 | (37.7545020044945, -122.469987253468) | 1 | 8 | 4 | 56 | 12 | |||||
168323 | 99734 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 44 | 145 Irving St | 2 | Front Yard : Yard | Tree | Private 2 | 08/21/2012 12:00:00 AM | Permit Number 768746 | 5995340.8 | 2106458.8 | 37.76366673695 | -122.45930407086 | (37.76366673695, -122.45930407086) | 15 | 5 | 11 | 56 | 12 | |||
153784 | 99733 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 44 | 145 Irving St | 1 | Front Yard : Yard | Tree | Private 2 | 08/21/2012 12:00:00 AM | Permit Number 768746 | 5995340.8 | 2106458.8 | 37.76366673695 | -122.45930407086 | (37.76366673695, -122.45930407086) | 15 | 5 | 11 | 56 | 12 | |||
188669 | 99699 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1750 Divisadero St | 2 | Front Yard : Cutout | Tree | Private 2 | 6001124 | 2114376 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | 15 | 6 | 1 | 29490 | 27 | |||||
8456 | 99698 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1750 Divisadero St | 1 | Front Yard : Cutout | Tree | Private 2 | 6001124 | 2114376 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | 15 | 6 | 1 | 29490 | 27 | |||||
172353 | 99662 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1337 Portola Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5993559.3 | 2097744.3 | 37.7396363671104 | -122.464832777968 | (37.7396363671104, -122.464832777968) | 1 | 8 | 4 | 59 | 40 | |||||
52837 | 99659 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1325 Portola Dr | 3 | Front Yard : Yard | Tree | Private 2 | 5993615.2 | 2097760.6 | 37.7396843456359 | -122.464640684629 | (37.7396843456359, -122.464640684629) | 1 | 8 | 4 | 59 | 40 | |||||
91423 | 99643 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 1268 Lombard St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6006289 | 2120073 | 37.8016713630652 | -122.42240499597 | (37.8016713630652, -122.42240499597) | 5 | 9 | 1 | 28858 | 32 | ||||
43892 | 99623 | Significant Tree 6 | Tree(s) :: 17 | 380 Connecticut St | 1 | Front Yard : Yard | Tree | Private 2 | 05/23/2012 12:00:00 AM | Permit Number 768850 | 6013171.4 | 2105301.7 | 37.7614986071193 | -122.397551993257 | (37.7614986071193, -122.397551993257) | 10 | 3 | 8 | 28856 | 29 | |||
193192 | 99376 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 206 | 1088 Ashbury St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 768767 | 5998994 | 2106195 | 37.7631517661679 | -122.446649857914 | (37.7631517661679, -122.446649857914) | 15 | 5 | 5 | 29492 | 9 | ||||
61598 | 99299 | Significant Tree 6 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 1457 Willard St | 1 | Front Yard : | Tree | Private 2 | 05/02/2012 12:00:00 AM | Permit Number 768720 | 5996809.7 | 2106270.3 | 37.763233506694 | -122.454210015753 | (37.763233506694, -122.454210015753) | 15 | 5 | 11 | 29492 | 12 | |||
176820 | 99289 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 845 Marina Blvd | 2 | Front Yard : Yard | Tree | Private 2 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998887.79124 | 2121333.18312 | 37.8047111982366 | -122.448107254257 | (37.8047111982366, -122.448107254257) | 13 | 9 | 1 | 57 | 17 | ||
50429 | 99288 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 845 Marina Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998881.62913 | 2121328.006 | 37.8046966310161 | -122.448128205765 | (37.8046966310161, -122.448128205765) | 13 | 9 | 1 | 57 | 17 | ||
84386 | 99192 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1155@Sansome Battery St | 3 | Front Yard : Yard | Tree | Private 2 | Plaza | Permit Number 768022 | 6012245 | 2120028 | 37.8018819838627 | -122.401791216362 | (37.8018819838627, -122.401791216362) | 3 | 1 | 10 | 28860 | 6 | |||
93882 | 99191 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 1155@Sansome Battery St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | Plaza | Permit Number 768022 | 6012232.15659 | 2120086.23158 | 37.8020411569217 | -122.401839756495 | (37.8020411569217, -122.401839756495) | 3 | 1 | 10 | 28860 | 6 | ||
138273 | 99106 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1400 Evans Ave | 3 | Front Yard : Yard | Tree | Private 2 | 04/09/2012 12:00:00 AM | Permit Number 768768 | 6016404 | 2098045.1 | 37.7417529632601 | -122.385865834439 | (37.7417529632601, -122.385865834439) | 10 | 3 | 8 | 58 | 1 | |||
26236 | 99105 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1400@ Mendell Evans Ave | 1 | Front Yard : Yard | Tree | Private 2 | 04/09/2012 12:00:00 AM | Permit Number 768768 | 6016404 | 2098045.1 | 37.7417529632601 | -122.385865834439 | (37.7417529632601, -122.385865834439) | 10 | 3 | 8 | 58 | 1 | |||
150390 | 99101 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 55x Santa Monica Way | 1 | Median : Yard | Tree | Private 2 | 04/07/2012 12:00:00 AM | Permit Number 768464 | 5993693.6 | 2097654.3 | 37.7393969918941 | -122.464361897304 | (37.7393969918941, -122.464361897304) | 1 | 8 | 4 | 59 | 40 | |||
60308 | 99100 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Santa Monica Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993700.7 | 2097327 | 37.7384987171226 | -122.464313592449 | (37.7384987171226, -122.464313592449) | 1 | 8 | 4 | 59 | 40 | |||||
187809 | 99099 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 65X Santa Monica Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2012 12:00:00 AM | Permit Number 768467 | 5993743.4 | 2097365.9 | 37.7386079879791 | -122.464168780849 | (37.7386079879791, -122.464168780849) | 1 | 8 | 4 | 59 | 40 | |||
146154 | 99098 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 66 Santa Monica Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2012 12:00:00 AM | Permit Number 768466 | 5993736.6 | 2097303.5 | 37.7384362612216 | -122.464187762983 | (37.7384362612216, -122.464187762983) | 1 | 8 | 4 | 59 | 40 | |||
62177 | 99097 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5994003.8 | 2097131.6 | 37.7379796635799 | -122.463251452094 | (37.7379796635799, -122.463251452094) | 9 | 8 | 4 | 59 | 40 | |||||
80590 | 98954 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 302 Ivy St | 20 | Front Yard : Yard | Tree | Private 2 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | |||||
71208 | 98953 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 302 Ivy St | 19 | Front Yard : Yard | Tree | Private 2 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | |||||
31523 | 98952 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 302 Ivy St | 18 | Front Yard : Yard | Tree | Private 2 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | |||||
140823 | 98951 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 401 Grove St | 11 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
48151 | 98950 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 10 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
176793 | 98949 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 401 Grove St | 9 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
69454 | 98948 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 8 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
60074 | 98947 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 401 Grove St | 7 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
27831 | 98834 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 333 Pacheco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994230.9 | 2100817.4 | 37.748113026994 | -122.462733567037 | (37.748113026994, -122.462733567037) | 1 | 8 | 4 | 29491 | 40 | |||||
107818 | 98757 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 340 Castenada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5993579.1 | 2100062.8 | 37.7460035255592 | -122.464932655613 | (37.7460035255592, -122.464932655613) | 1 | 8 | 4 | 29491 | 40 | |||||
145768 | 98703 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 7070@ 32nd Ave California St | 4 | Front Yard : | Tree | Private 2 | 03/10/2012 12:00:00 AM | Permit Number 767466 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.493376058427 | (37.7850123376907, -122.493376058427) | 11 | 6 | 1 | 55 | 33 | |||
172767 | 98696 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 191@Clarendon Forest Knolls Dr | 3 | Back Yard : Yard | Tree | Private 2 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.7543910951738 | -122.455633951336 | (37.7543910951738, -122.455633951336) | 1 | 5 | 4 | 63 | 12 | |||
175269 | 98695 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 191@Clarendon Forest Knolls Dr | 2 | Back Yard : Yard | Tree | Private 2 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.7543910951738 | -122.455633951336 | (37.7543910951738, -122.455633951336) | 1 | 5 | 4 | 63 | 12 | |||
55746 | 98694 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 191@Clarendon Forest Knolls Dr | 1 | Back Yard : Yard | Tree | Private 2 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.7543910951738 | -122.455633951336 | (37.7543910951738, -122.455633951336) | 1 | 5 | 4 | 63 | 12 | |||
23065 | 98547 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 555@Rio Teresita Blvd | 3 | Front Yard : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
38717 | 98546 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 555@Rio Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
116509 | 98545 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 555@Rio Teresita Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
92073 | 98492 | Significant Tree 6 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2149 Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6004211.7 | 2116183 | 37.7908730187591 | -122.429315856087 | (37.7908730187591, -122.429315856087) | 13 | 9 | 1 | 29490 | 27 | |||||
174679 | 98491 | Significant Tree 6 | Robinia pseudoacacia :: Black Locust 286 | 55X Perine Pl | 1 | Back Yard : Cutout | Tree | Private 2 | Permit Number 768655 | 6002130.5 | 2115544.8 | 37.7890026421633 | -122.436471006098 | (37.7890026421633, -122.436471006098) | 13 | 6 | 1 | 29490 | 27 | ||||
39513 | 98455 | Significant Tree 6 | Washingtonia filifera :: California Fan Palm 176 | 2200 22nd St | 1 | Front Yard : Yard | Tree | Private 2 | 6011565.2 | 2103754.7 | 37.7571613219705 | -122.402998394603 | (37.7571613219705, -122.402998394603) | 10 | 3 | 8 | 28856 | 29 | |||||
135121 | 98310 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 1499@Newhall Evans Ave | 2 | Front Yard : | Tree | Private 2 | 01/25/2012 12:00:00 AM | 4 | Permit Number 768575 | 6016248.7932 | 2098029.27381 | 37.7417009175609 | -122.386401389915 | (37.7417009175609, -122.386401389915) | 10 | 3 | 8 | 58 | 1 | ||
89508 | 98309 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 401X Newhall St | 1 | Front Yard : | Tree | Private 2 | 6 | 3x3 | 6016081.14502 | 2097910.94016 | 37.7413667159929 | -122.386972815546 | (37.7413667159929, -122.386972815546) | 10 | 3 | 8 | 58 | 1 | |||
37942 | 98308 | Significant Tree 6 | Tree(s) :: 17 | 1490 Fairfax Ave | 1 | Front Yard : | Tree | Private 2 | 01/25/2012 12:00:00 AM | 3x3 | Permit Number 768575 | 6016246.6 | 2097899.9 | 37.7413455620636 | -122.386399955147 | (37.7413455620636, -122.386399955147) | 10 | 3 | 8 | 58 | 1 | ||
125728 | 98303 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 6 Locksley Ave | 3 | Front Yard : Yard | Tree | Private 2 | 5994194 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | 1 | 5 | 4 | 56 | 12 | |||||
123649 | 98302 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 6 Locksley Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5994194 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | 1 | 5 | 4 | 56 | 12 | |||||
180522 | 98301 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 6 Locksley Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5994194 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | 1 | 5 | 4 | 56 | 12 | |||||
143852 | 98290 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 300 Mangels Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 4 | 59 | 40 | |||
37139 | 98289 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 300 Mangels Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 4 | 59 | 40 | |||
165161 | 98288 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 300 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 4 | 59 | 40 | |||
129559 | 98274 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 766 Anderson St | Front Yard : Yard | Tree | Private 2 | 01/23/2012 12:00:00 AM | 18 | Permit Number 768445 | 6007723 | 2095324 | 37.7337971999422 | -122.415689321062 | (37.7337971999422, -122.415689321062) | 2 | 7 | 7 | 28859 | 2 | |||
71235 | 98244 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 901 Bay St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6006420.63185 | 2121080.7781 | 37.8044458892203 | -122.422021121489 | (37.8044458892203, -122.422021121489) | 5 | 1 | 1 | 28858 | 32 | ||||
127638 | 98241 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 3760 Washington St | 1 | Front Yard : Yard | Tree | Private 2 | 01/10/2012 12:00:00 AM | 9 | Permit Number 768462 | 5996814.46778 | 2115674.04938 | 37.7890540175629 | -122.45487301497 | (37.7890540175629, -122.45487301497) | 11 | 6 | 1 | 54 | 31 | ||
7770 | 98170 | Significant Tree 6 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2324 Sacramento St | Front Yard : Yard | Tree | Private 2 | 12/22/2011 12:00:00 AM | 3 | Permit Number 768454 | 6003670.2 | 2115963.1 | 37.7902385582714 | -122.431173718492 | (37.7902385582714, -122.431173718492) | 13 | 9 | 1 | 29490 | 27 | |||
129267 | 98161 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 600 Front St | Front Yard : Yard | Tree | Private 2 | 12/21/2011 12:00:00 AM | Permit Number 768589 | 6012888.4 | 2118392.6 | 37.7974274520849 | -122.399449857041 | (37.7974274520849, -122.399449857041) | 3 | 1 | 10 | 28860 | 6 | ||||
183500 | 98157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 149x Chaves Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5996703.5 | 2098396.7 | 37.7416084783757 | -122.454008650942 | (37.7416084783757, -122.454008650942) | 9 | 7 | 4 | 59 | 40 | |||||
89599 | 98156 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 149x Chaves Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5996703.5 | 2098396.7 | 37.7416084783757 | -122.454008650942 | (37.7416084783757, -122.454008650942) | 9 | 7 | 4 | 59 | 40 | |||||
85195 | 98151 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 850 Rockdale Dr | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | 9 | 7 | 4 | 59 | 40 | ||||
75471 | 98104 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1@Carl Irving St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | ||||
48765 | 98082 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 525 Grafton Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5995193.7 | 2090526.9 | 37.7199132334677 | -122.45865940878 | (37.7199132334677, -122.45865940878) | 9 | 8 | 6 | 28861 | 24 | |||||
94461 | 98038 | Significant Tree 6 | Tree(s) :: 17 | 147 Lake St | 1 | Front Yard : Yard | Tree | Private 2 | 12/09/2011 12:00:00 AM | Permit Number 768423 | 5994977.2 | 2114852.5 | 37.7866927029397 | -122.461170103848 | (37.7866927029397, -122.461170103848) | 11 | 6 | 1 | 54 | 11 | |||
35440 | 97955 | Significant Tree 6 | Liquidambar styraciflua 'Slender Silhoutte' :: Upright Liquidambar 438 | 2 Mendosa Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12/05/2011 12:00:00 AM | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.7489597362933 | -122.464854121346 | (37.7489597362933, -122.464854121346) | 1 | 8 | 4 | 29491 | 40 | |||
42536 | 97945 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2 Mendosa Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.7489597362933 | -122.464854121346 | (37.7489597362933, -122.464854121346) | 1 | 8 | 4 | 29491 | 40 | ||||
144070 | 97894 | Significant Tree 6 | Tree(s) :: 17 | 2927 Folsom St | Front Yard : Yard | Tree | Private 2 | 02/29/2012 12:00:00 AM | 30 | Permit Number 768566 | 6008395 | 2101384 | 37.7504743768844 | -122.413794517972 | (37.7504743768844, -122.413794517972) | 2 | 4 | 7 | 28859 | 19 | |||
24668 | 97534 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 203 Surrey St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 768282 | 6002070 | 2096079.6 | 37.7355525046422 | -122.435287431957 | (37.7355525046422, -122.435287431957) | 2 | 7 | 5 | 63 | 7 | ||||
96506 | 97264 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 300 Newhall St | 1 | Front Yard : Yard | Tree | Private 2 | 09/09/2011 12:00:00 AM | Permit Number 768179 | 6016549.1 | 2098591.6 | 37.7432615694897 | -122.385402196424 | (37.7432615694897, -122.385402196424) | 10 | 3 | 8 | 58 | 1 | |||
162331 | 97175 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 1 | 26 Gilbert St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | 14 | 2 | 9 | 28853 | 34 | |||||
9674 | 97174 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 1 | 26 Gilbert St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | 14 | 2 | 9 | 28853 | 34 | |||||
173631 | 96998 | Significant Tree 6 | Prunus spp :: Cherry 68 | 2451X Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.387194089236 | (37.7197277910807, -122.387194089236) | 10 | 3 | 8 | 58 | 1 | |||||
175413 | 96996 | Significant Tree 6 | Malus :: Crab Apple 82 | 2451X Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.387194089236 | (37.7197277910807, -122.387194089236) | 10 | 3 | 8 | 58 | 1 | |||||
64053 | 96906 | Significant Tree 6 | Ulmus 'Frontier' :: Frontier Elm 115 | 1155@Sansome Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 08/05/2011 12:00:00 AM | Plaza | Permit Number 768022 | 6012245 | 2120028 | 37.8018819838627 | -122.401791216362 | (37.8018819838627, -122.401791216362) | 3 | 1 | 10 | 28860 | 6 | ||
57862 | 96848 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 1486 Innes Ave | Front Yard : Yard | Tree | Private 2 | 6016133.4 | 2096820.6 | 37.7383757570157 | -122.386716118251 | (37.7383757570157, -122.386716118251) | 10 | 3 | 8 | 58 | 1 | ||||||
90328 | 96835 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 6001 Geary Blvd | 1 | Front Yard : Cutout | Tree | Private 2 | 5988352.4 | 2112527.1 | 37.779924341439 | -122.483919468894 | (37.779924341439, -122.483919468894) | 11 | 6 | 2 | 55 | 26 | |||||
177101 | 96784 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 615 Rhode Island St | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/19/2011 12:00:00 AM | Permit Number 767987 | 6011854.6 | 2105476.9 | 37.7619062576766 | -122.402118605761 | (37.7619062576766, -122.402118605761) | 10 | 3 | 8 | 28856 | 29 | ||||
178454 | 96779 | Significant Tree 6 | Tree(s) :: 17 | 555 Melrose Ave | 1 | Back Yard : Yard | Tree | Private 2 | 07/18/2011 12:00:00 AM | Permit Number 767966 | 5996882.6 | 2095364.1 | 37.7332919614683 | -122.45317051412 | (37.7332919614683, -122.45317051412) | 9 | 7 | 4 | 59 | 40 | |||
81307 | 96767 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 2229 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Permit Number 768245 | 6003236 | 2116309 | 37.7911636966224 | -122.432700736457 | (37.7911636966224, -122.432700736457) | 13 | 9 | 1 | 29490 | 27 | |||
14822 | 96765 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 184 Edgewood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 07/12/2011 12:00:00 AM | Permit Number 767998 | 5996632 | 2105999 | 37.7624783944866 | -122.454805014883 | (37.7624783944866, -122.454805014883) | 15 | 5 | 11 | 29492 | 12 | |||
170957 | 96618 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ 19th St 19th St | 268 | Sidewalk: Property side : | Tree | Rec/Park 5 | Permit Number 771218 | 6006277 | 2104934 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | 2 | 4 | 7 | 28859 | 19 | ||||
144623 | 96617 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ Valencia 19th St | 251 | Sidewalk: Property side : | Tree | Rec/Park 5 | Permit Number 771218 | 6006277 | 2104934 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | 2 | 4 | 7 | 28859 | 19 | ||||
13082 | 96572 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
135340 | 96571 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
54868 | 96570 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
41336 | 96569 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
103743 | 96568 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
7373 | 96567 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
110019 | 96485 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
109546 | 96484 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 |
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) );