trees
8,298 rows where qLegalStatus_id = 4 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
162517 | 104734 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 5490x 03RD ST | 1 | Median : Cutout | Tree | DPW 1 | 40 | 9x9 | 6014203 | 2093127 | 37.7281268221954 | -122.393132175736 | (37.7281268221954, -122.393132175736) | 10 | 3 | 8 | 58 | 1 | |||
162805 | 113892 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 1x STORRIE ST | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | 11 | 6000722 | 2105303 | 37.7608011093363 | -122.440609317727 | (37.7608011093363, -122.440609317727) | 15 | 4 | 5 | 28862 | 3 | ||||
163104 | 74968 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 493 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2013 12:00:00 AM | 6x6 | Permit Number 769961 | 6011188.26118785 | 2118621.30079081 | 37.7979605016561 | -122.405348925503 | (37.7979605016561, -122.405348925503) | 3 | 1 | 10 | 308 | 23 | ||
165374 | 109158 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 200 Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | |||
165516 | 110458 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2471 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5x5 | 6008273 | 2104056 | 37.7578042316996 | -122.414405447195 | (37.7578042316996, -122.414405447195) | 2 | 4 | 7 | 28859 | 19 | |||
166046 | 109248 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 200x BAKER ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000999 | 2109836 | 37.773263372988 | -122.439976336261 | (37.773263372988, -122.439976336261) | 15 | 5 | 11 | 29492 | 10 | ||||
166327 | 107497 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 826 JUNIPERO SERRA BLVD | 1 | Median : Cutout | Tree | DPW 1 | 36 | 5991253.8 | 2091935.2 | 37.7235528447013 | -122.472380755006 | (37.7235528447013, -122.472380755006) | 9 | 8 | 4 | 64 | 40 | ||||
166461 | 109197 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2401x CASTRO ST | 3 | Median : Yard | Tree | DPW 1 | 12 | 6002698 | 2098487 | 37.7421983129634 | -122.433288166914 | (37.7421983129634, -122.433288166914) | 2 | 7 | 5 | 63 | 7 | ||||
166973 | 109639 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1X Geneva Ave | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6001799 | 2091822 | 37.723846713797 | -122.435919833731 | (37.723846713797, -122.435919833731) | 9 | 7 | 6 | 28861 | 25 | ||||
167911 | 116614 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 299X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6007772 | 2106483 | 37.7644400562771 | -122.416310015149 | (37.7644400562771, -122.416310015149) | 8 | 4 | 7 | 28859 | 19 | |||
167922 | 113676 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X THE EMBARCADERO | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013440 | 2119057 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | 3 | 1 | 10 | 28860 | 6 | ||||
168968 | 113893 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 5x STORRIE ST | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | 60 | 6000722 | 2105303 | 37.7608011093363 | -122.440609317727 | (37.7608011093363, -122.440609317727) | 15 | 4 | 5 | 28862 | 3 | ||||
169343 | 109156 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 200 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2015 01:49:00 PM | 3 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||
171124 | 111239 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 399x LIBERTY ST | 1 | Median : Yard | Tree | DPW 1 | 40 | 3x3 | 6003700 | 2103889 | 37.7570877346209 | -122.430208863755 | (37.7570877346209, -122.430208863755) | 2 | 4 | 5 | 28862 | 3 | |||
173852 | 109668 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200X GELLERT DR | 32 | Median : Cutout | Tree | DPW 1 | 30x200 | 5985380 | 2094516.3 | 37.730298158605 | -122.492875173009 | (37.730298158605, -122.492875173009) | 1 | 8 | 4 | 64 | 35 | ||||
174778 | 109652 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 23 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
175844 | 116451 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 250X CASHMERE ST | 5 | Median : Yard | Tree | DPW 1 | 6016081 | 2096072 | 37.7363173516773 | -122.386845101275 | (37.7363173516773, -122.386845101275) | 10 | 3 | 8 | 58 | 1 | |||||
177407 | 113669 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X THE EMBARCADERO | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013440 | 2119057 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | 3 | 1 | 10 | 28860 | 6 | ||||
177550 | 113687 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X THE EMBARCADERO | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013440 | 2119057 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | 3 | 1 | 10 | 28860 | 6 | ||||
178338 | 108584 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1610 HYDE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2016 02:11:00 PM | 3 | 3x3 | 6007458.4 | 2117914.1 | 37.7958094617611 | -122.41820517617 | (37.7958094617611, -122.41820517617) | 5 | 1 | 10 | 28858 | 32 | ||
178349 | 113671 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X THE EMBARCADERO | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013440 | 2119057 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | 3 | 1 | 10 | 28860 | 6 | ||||
178687 | 112543 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 448 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011394 | 2118786 | 37.798424226523 | -122.404648607058 | (37.798424226523, -122.404648607058) | 3 | 1 | 10 | 308 | 23 | ||||
178870 | 112526 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 471 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011292 | 2118586 | 37.7978693737352 | -122.404987470864 | (37.7978693737352, -122.404987470864) | 3 | 1 | 10 | 308 | 23 | ||||
179370 | 113659 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 855x CLIPPER ST | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 62 | 3x3 | 5999765 | 2100345 | 37.7471331091489 | -122.443562976791 | (37.7471331091489, -122.443562976791) | 2 | 4 | 5 | 63 | 22 | |||
180282 | 109244 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 200x BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000999 | 2109836 | 37.773263372988 | -122.439976336261 | (37.773263372988, -122.439976336261) | 15 | 5 | 11 | 29492 | 10 | ||||
181630 | 256051 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | ||||
183035 | 111052 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2059X MARKET ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6004434 | 2107851 | 37.7680079876693 | -122.427952728751 | (37.7680079876693, -122.427952728751) | 8 | 4 | 5 | 28862 | 3 | ||||
186424 | 109247 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 200x BAKER ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000999 | 2109836 | 37.773263372988 | -122.439976336261 | (37.773263372988, -122.439976336261) | 15 | 5 | 11 | 29492 | 10 | ||||
187514 | 110688 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 1 EDDY ST | 6 | Median : Cutout | Tree | DPW 1 | 3x3 | 6010419 | 2113787 | 37.7846436353836 | -122.40766976216 | (37.7846436353836, -122.40766976216) | 14 | 10 | 10 | 28852 | 36 | ||||
188233 | 109165 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 4 | Median : Cutout | Tree | DPW 1 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | ||||
188525 | 113667 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X THE EMBARCADERO | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013440 | 2119057 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | 3 | 1 | 10 | 28860 | 6 | ||||
188882 | 256045 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | ||||
191343 | 254839 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 673 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 5994992 | 2110964 | 37.776016775414 | -122.460836981253 | (37.776016775414, -122.460836981253) | 11 | 6 | 2 | 54 | 11 | |
191717 | 255636 | Undocumented 4 | Fraxinus oxycarpa :: Ash 213 | 590 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5999354 | 2110868 | 37.7760032005164 | -122.445740824021 | (37.7760032005164, -122.445740824021) | 15 | 5 | 11 | 29492 | 16 | ||||
191873 | 256046 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | ||||
193545 | 109651 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 22 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
194193 | 108718 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1103 GOUGH ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005549.7 | 2113553.5 | 37.7837287235103 | -122.424499312595 | (37.7837287235103, -122.424499312595) | 7 | 9 | 11 | 28858 | 41 | ||||
194380 | 255779 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 45 Niagara Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/08/2017 12:00:00 AM | 3 | 3x3 | 5999808 | 2089058 | 37.7161440949055 | -122.442604012325 | (37.7161440949055, -122.442604012325) | 9 | 7 | 6 | 28861 | 25 | |
10 | 264794 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 31 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | 6011433 | 2091603 | 37.7237879639177 | -122.40260109208 | (37.7237879639177, -122.40260109208) | 10 | 3 | 7 | 309 | 28 | ||
12 | 264792 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 99 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 3x3 | 6011432 | 2091645 | 37.7239032314516 | -122.402607501044 | (37.7239032314516, -122.402607501044) | 10 | 3 | 7 | 309 | 28 | ||
20 | 264793 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 99 Dwight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 3x3 | 6011432 | 2091645 | 37.7239032314516 | -122.402607501044 | (37.7239032314516, -122.402607501044) | 10 | 3 | 7 | 309 | 28 | ||
47 | 264965 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 951 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994993 | 2090257 | 37.7191606150529 | -122.45933361899 | (37.7191606150529, -122.45933361899) | 9 | 8 | 6 | 28861 | 24 | ||||
52 | 264970 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1026 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014048 | 2089990 | 37.7195046364539 | -122.393448574201 | (37.7195046364539, -122.393448574201) | 10 | 3 | 8 | 58 | 1 | ||||
53 | 264969 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1099X Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15x15 | 6014337 | 2089983 | 37.719501468928 | -122.392449109694 | (37.719501468928, -122.392449109694) | 10 | 3 | 8 | 58 | 1 | |||
116 | 113159 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 555 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005146 | 2111243 | 37.777361853017 | -122.425731455878 | (37.777361853017, -122.425731455878) | 7 | 9 | 11 | 28852 | 10 | ||||
117 | 108152 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2232 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
121 | 120916 | Undocumented 4 | Tree(s) :: 17 | 1430 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778800 | 5990886 | 2105639 | 37.7611586563939 | -122.474651843595 | (37.7611586563939, -122.474651843595) | 1 | 8 | 4 | 56 | 12 | |
125 | 92934 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 339 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5992211 | 2096907 | 37.737259523291 | -122.46943364564 | (37.737259523291, -122.46943364564) | 1 | 8 | 4 | 59 | 40 | ||||
128 | 110722 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1898X 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | 1 | 8 | 4 | 56 | 12 | |||||
131 | 109387 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 300X BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000704 | 2110147 | 37.7741005029649 | -122.441019094263 | (37.7741005029649, -122.441019094263) | 15 | 5 | 11 | 29492 | 16 | ||||
140 | 97920 | Undocumented 4 | Tree(s) :: 17 | 399X Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6000685 | 2110085 | 37.7739291843989 | -122.441080369401 | (37.7739291843989, -122.441080369401) | 15 | 5 | 11 | 29492 | 16 | |||
144 | 108797 | Undocumented 4 | :: 45 | 501-599 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
148 | 108238 | Undocumented 4 | Tree(s) :: 17 | 764x JUNIPERO SERRA BLVD | 1 | Median : Yard | Tree | Private 2 | 5991289.6 | 2092496.8 | 37.7250969308873 | -122.472297921456 | (37.7250969308873, -122.472297921456) | 9 | 8 | 4 | 64 | 40 | |||||
149 | 244279 | Undocumented 4 | :: 45 | 585 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004230.7823 | 2110095.842 | 37.7741602789386 | -122.428815691218 | (37.7741602789386, -122.428815691218) | 7 | 9 | 11 | 28852 | 10 | |||
157 | 114186 | Undocumented 4 | Shrub :: Shrub 66 | 2200 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997096 | 2109871 | 37.7731365175856 | -122.453479795748 | (37.7731365175856, -122.453479795748) | 15 | 5 | 2 | 29492 | 16 | ||||
159 | 117627 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 890x VERMONT ST | 4 | Unaccepted Street : Yard | Tree | Private 2 | 6011292 | 2104239 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | 10 | 3 | 8 | 28856 | 29 | |||||
162 | 105806 | Undocumented 4 | Tree(s) :: 17 | 1248X ANZA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x3 | 5994834 | 2112130 | 37.7792092085373 | -122.461468091676 | (37.7792092085373, -122.461468091676) | 11 | 6 | 2 | 54 | 11 | |||||
188 | 112351 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992711 | 2097652 | 37.7393339885882 | -122.467759098278 | (37.7393339885882, -122.467759098278) | 1 | 8 | 4 | 59 | 40 | ||||
194 | 112359 | Undocumented 4 | Tree(s) :: 17 | 1129 DOUGLASS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001379 | 2100423 | 37.7474391957634 | -122.437987492815 | (37.7474391957634, -122.437987492815) | 2 | 4 | 5 | 63 | 22 | ||||
197 | 104920 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 750 Gonzalez Dr | 1 | Median : Yard | Tree | Private 2 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | |||||
198 | 102463 | Undocumented 4 | Tree(s) :: 17 | 3119 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6007346.2 | 2103903.1 | 37.7573322957921 | -122.417599878082 | (37.7573322957921, -122.417599878082) | 2 | 4 | 7 | 28859 | 19 | |||
208 | 107457 | Undocumented 4 | Prunus spp :: Cherry 68 | 2682 16TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991487.4 | 2097177.7 | 37.7379609526954 | -122.471955163509 | (37.7379609526954, -122.471955163509) | 1 | 8 | 4 | 29491 | 40 | |||||
217 | 105438 | Undocumented 4 | :: 45 | 1116 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002483 | 2102334 | 37.7527490702591 | -122.434306541099 | (37.7527490702591, -122.434306541099) | 2 | 4 | 5 | 28862 | 22 | ||||
228 | 256437 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 3001 Sunset Blvd | 25 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
229 | 121402 | Undocumented 4 | :: 45 | 346X Duncan St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6004011 | 2099874 | 37.7460810947058 | -122.428847079389 | (37.7460810947058, -122.428847079389) | 2 | 7 | 5 | 63 | 22 | ||||
230 | 114428 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 34x HIGUERA AVE | 2 | Median : Yard | Tree | Private 2 | 56 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | ||||
231 | 116978 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 111 BAY ST | 4 | Front Yard : Yard | Tree | Private 2 | 6010550 | 2121704 | 37.8063891294227 | -122.407774985143 | (37.8063891294227, -122.407774985143) | 3 | 1 | 10 | 308 | 23 | |||||
233 | 100684 | Undocumented 4 | Tree(s) :: 17 | 400 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6012367 | 2116823 | 37.7930886299645 | -122.401143699021 | (37.7930886299645, -122.401143699021) | 4 | 1 | 10 | 28854 | 6 | |||||
261 | 119280 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 95 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995293 | 2090512 | 37.7198780283713 | -122.458315087488 | (37.7198780283713, -122.458315087488) | 9 | 8 | 6 | 28861 | 24 | ||||
264 | 103685 | Undocumented 4 | Prunus amygdalus :: Almond 80 | 901X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6008052 | 2102672 | 37.7539916655216 | -122.415071798268 | (37.7539916655216, -122.415071798268) | 2 | 4 | 7 | 28859 | 19 | |||
277 | 110381 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 2235 PALOU AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27x18 | 6011689 | 2097713 | 37.740579036374 | -122.402145495204 | (37.740579036374, -122.402145495204) | 10 | 3 | 8 | 58 | 1 | ||||
293 | 102283 | Undocumented 4 | Tree(s) :: 17 | 4428 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6000463 | 2102288 | 37.7525079029002 | -122.441288746114 | (37.7525079029002, -122.441288746114) | 2 | 4 | 5 | 28862 | 22 | |||
298 | 107634 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2431 24TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011247.3 | 2102253.3 | 37.7530210518745 | -122.403992166267 | (37.7530210518745, -122.403992166267) | 10 | 4 | 8 | 28859 | 19 | |||
299 | 116945 | Undocumented 4 | :: 45 | 3676 23RD ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005238 | 2102584 | 37.7535915013127 | -122.424797029407 | (37.7535915013127, -122.424797029407) | 2 | 4 | 5 | 28859 | 19 | ||||
301 | 108803 | Undocumented 4 | :: 45 | 401-499 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
307 | 99748 | Undocumented 4 | Tree(s) :: 17 | 4224 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002441 | 2100645 | 37.7481090922721 | -122.434331041256 | (37.7481090922721, -122.434331041256) | 2 | 4 | 5 | 28862 | 22 | ||||
315 | 106681 | Undocumented 4 | Acer spp :: Maple 88 | 272 COLLINGWOOD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002031.2 | 2104270.9 | 37.7580416780136 | -122.436007529668 | (37.7580416780136, -122.436007529668) | 2 | 4 | 5 | 28862 | 3 | |||||
323 | 106136 | Undocumented 4 | Tree(s) :: 17 | 200X RIDGEWOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996801 | 2094865 | 37.7319168756422 | -122.453416604011 | (37.7319168756422, -122.453416604011) | 9 | 7 | 4 | 59 | 40 | ||||
329 | 101063 | Undocumented 4 | Tree(s) :: 17 | 710 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001857 | 2102025 | 37.7518650783703 | -122.436449244442 | (37.7518650783703, -122.436449244442) | 2 | 4 | 5 | 28862 | 22 | ||||
335 | 102831 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
350 | 119661 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699x Missouri St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
359 | 113255 | Undocumented 4 | Tree(s) :: 17 | 178 Edgewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5996632.6 | 2106029.8 | 37.7625629978497 | -122.454805165139 | (37.7625629978497, -122.454805165139) | 15 | 5 | 11 | 29492 | 12 | |||||
361 | 107141 | Undocumented 4 | Tree(s) :: 17 | 3498 16TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003565.7 | 2106565.7 | 37.764429704069 | -122.430864344516 | (37.764429704069, -122.430864344516) | 15 | 4 | 5 | 28862 | 3 | ||||||
369 | 138522 | Undocumented 4 | Tristania conferta :: 61 | 1602 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001658.1955 | 2114019.9111 | 37.7847888393579 | -122.437995843174 | (37.7847888393579, -122.437995843174) | 13 | 6 | 11 | 29490 | 13 | |||
392 | 108811 | Undocumented 4 | :: 45 | 301-399 University St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
400 | 104991 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 669X NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6003139 | 2104447 | 37.7585880783392 | -122.432188863302 | (37.7585880783392, -122.432188863302) | 2 | 4 | 5 | 28862 | 3 | |||
403 | 108117 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 148 28TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987142.8 | 2114987.8 | 37.7866102289445 | -122.488284841308 | (37.7866102289445, -122.488284841308) | 11 | 6 | 1 | 55 | 33 | |||||
405 | 113785 | Undocumented 4 | Ficus Spp. :: 101 | 1164 SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007978 | 2101134 | 37.7497645063146 | -122.415218844485 | (37.7497645063146, -122.415218844485) | 2 | 4 | 7 | 28859 | 19 | ||||
412 | 121036 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1830 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006566 | 2117108 | 37.7935458417616 | -122.421235781398 | (37.7935458417616, -122.421235781398) | 13 | 9 | 10 | 28858 | 32 | ||||
427 | 114621 | Undocumented 4 | :: 45 | 2400X Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | 15 | 6 | 11 | 29490 | 13 | |||||
434 | 102445 | Undocumented 4 | Tree(s) :: 17 | 900 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001563.3 | 2088855.6 | 37.7156882523244 | -122.436522388875 | (37.7156882523244, -122.436522388875) | 9 | 7 | 6 | 28861 | 5 | |||
443 | 107383 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 73 HILL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6005896.4 | 2103362 | 37.7557648742481 | -122.422575414787 | (37.7557648742481, -122.422575414787) | 2 | 4 | 5 | 28859 | 19 | ||||
445 | 110235 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 2346x CASTRO ST | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 6002664.5 | 2098664.4 | 37.7426835115852 | -122.433416673574 | (37.7426835115852, -122.433416673574) | 2 | 7 | 5 | 63 | 7 | ||||
447 | 114683 | Undocumented 4 | Ficus Spp. :: 101 | 235 GEARY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010571 | 2114715 | 37.7872002104764 | -122.407209329428 | (37.7872002104764, -122.407209329428) | 5 | 10 | 10 | 28852 | 6 | ||||
451 | 114938 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4400x OCEAN AVE | 14 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | ||||
463 | 116745 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 2998x SLOAT BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981657 | 2096559 | 37.7356884360348 | -122.505897251941 | (37.7356884360348, -122.505897251941) | 1 | 8 | 3 | 29491 | 35 | ||||
465 | 105354 | Undocumented 4 | Tree(s) :: 17 | 3294 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007856.1 | 2100992.4 | 37.7493688530402 | -122.415630356523 | (37.7493688530402, -122.415630356523) | 2 | 4 | 7 | 28859 | 19 | ||||
468 | 121614 | Undocumented 4 | :: 45 | 800X Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001168 | 2102650 | 37.7535420028484 | -122.438876681597 | (37.7535420028484, -122.438876681597) | 2 | 4 | 5 | 28862 | 22 | ||||
475 | 102627 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2039 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001422 | 2115424 | 37.7886306717674 | -122.438913657053 | (37.7886306717674, -122.438913657053) | 13 | 6 | 1 | 29490 | 27 | |||
476 | 102238 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 1104 York St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009987 | 2102770 | 37.7543693005663 | -122.408386989199 | (37.7543693005663, -122.408386989199) | 2 | 4 | 7 | 28859 | 19 |
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) );