39,840 rows where qLegalStatus_id = 7 sorted by PermitNotes

View and edit SQL

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)
94 260654 Permitted Site 7 :: 45 2590 Buchanan St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   10/03/2019 12:00:00 AM 3 3.5x3                      
111 97355 Permitted Site 7 Tree(s) :: 17   5 Unaccepted Street : Yard Tree Private 2                              
135 99586 Permitted Site 7 Tree(s) :: 17 2299 Market St 4 Sidewalk: Curb side : Cutout Tree Private 2           6002978.6 2106459.9 37.7641059209125 -122.432887400675 (37.7641059209125, -122.432887400675) 15 4 5 28862 3
158 100607 Permitted Site 7 Tree(s) :: 17 270x 05th St 5 Sidewalk: Curb side : Cutout Tree Private 2           6011410.5 2112131.8 37.7801542961347 -122.404122955966 (37.7801542961347, -122.404122955966) 14 2 9 28853 34
165 104843 Permitted Site 7 :: 45 1320 21st Ave   Sidewalk: Curb side : Cutout Tree Private 2           5989622 2106334.7 37.7629955389606 -122.479074319647 (37.7629955389606, -122.479074319647) 1 8 3 56 35
193 100595 Permitted Site 7 Tree(s) :: 17 401x Clementina St 10 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
203 56596 Permitted Site 7 Tree(s) :: 17 536 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003173.97949504 2096124.55404861 37.7357385703685 -122.431473765394 (37.7357385703685, -122.431473765394) 2 7 5 63 7
226 56655 Permitted Site 7 Tree(s) :: 17 491 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2           5993749.22353597 2090472.28724098 37.7196801529508 -122.463648462413 (37.7196801529508, -122.463648462413) 9 8 6 64 24
236 27345 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 664 Fell St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/01/2008 12:00:00 AM 4 4x4   6004282.41706 2110648.93551 37.7756818605142 -122.428676512776 (37.7756818605142, -122.428676512776) 7 9 11 28852 10
257 115298 Permitted Site 7 :: 45 84 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5992506.3 2098571.2 37.7418460572185 -122.468533715231 (37.7418460572185, -122.468533715231) 1 8 4 29491 40
260 56449 Permitted Site 7 Tree(s) :: 17 1439 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5982754.68200032 2105326.56088651 37.7598262733968 -122.502750996927 (37.7598262733968, -122.502750996927) 1 8 3 56 35
305 56460 Permitted Site 7 Tree(s) :: 17 2430 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2           6006920.19744074 2104198.59660265 37.7581196808576 -122.419094125211 (37.7581196808576, -122.419094125211) 2 4 7 28859 19
308 102295 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 1500 Michigan St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6016449 2101073.5 37.7500708170088 -122.385921283567 (37.7500708170088, -122.385921283567) 10 3 8 58 1
319 96811 Permitted Site 7 Schinus molle :: California Pepper 91 356 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996379.5 2106960.2 37.7651031164685 -122.455747798641 (37.7651031164685, -122.455747798641) 15 5 11 29492 12
347 108327 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
407 56529 Permitted Site 7 Tree(s) :: 17 4721 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2           5998571.81433707 2105652.41045975 37.7616378261686 -122.448070980729 (37.7616378261686, -122.448070980729) 15 5 11 29492 12
414 8435 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1730 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   05/28/1997 12:00:00 AM 13 3X3   6003010.73492 2113853.74303 37.784409407274 -122.433304626878 (37.784409407274, -122.433304626878) 13 9 11 29490 13
435 108949 Permitted Site 7 :: 45 254 Dublin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6003932.1 2088992 37.7161971007686 -122.428344449747 (37.7161971007686, -122.428344449747) 9 7 6 28861 5
438 16548 Permitted Site 7 Ceratonia siliqua :: Carob 5 400X Newhall St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016043.45751 2097947.55726 37.7414651721818 -122.387105680372 (37.7414651721818, -122.387105680372) 10 3 8 58 1
461 56448 Permitted Site 7 Tree(s) :: 17 1410 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5982800.36611702 2105511.04189371 37.7603354906122 -122.502606655486 (37.7603354906122, -122.502606655486) 1 8 3 56 35
521 100638 Permitted Site 7 Tree(s) :: 17 401X Clementina St 8 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
532 261313 Permitted Site 7 :: 45 2700 Broadway 1 Sidewalk: Property side : Cutout Landscaping Private 2   12/31/2019 12:00:00 AM 3 6x40   6000687.88763 2117206.96839 37.7934844433083 -122.441581569821 (37.7934844433083, -122.441581569821) 13 9 1 57 27
611 10613 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 34 Hawkins Ln 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/1993 12:00:00 AM 18 3X3   6016953.5018076 2095595.9312574 37.7350584319022 -122.383795333225 (37.7350584319022, -122.383795333225) 10 3 8 58 1
633 9792 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 997X Gough St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5     36 3x3   6005630.9126204 2113075.2727517 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881) 7 9 11 28852 41
740 105361 Permitted Site 7 :: 45 850 Guerrero St 3 Sidewalk: Property side : Cutout Tree Private 2       12x2.75   6005583.5 2103975.8 37.7574325683666 -122.423701164602 (37.7574325683666, -122.423701164602) 2 4 5 28859 19
852 108444 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1 Sycamore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 2 3x2.5   6014877 2117007 37.7937335561349 -122.392471758503 (37.7937335561349, -122.392471758503) 12 2 9 28855 6
866 28332 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 3247 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2004 12:00:00 AM 9 3x3   6006498.83651 2099346.51324 37.74477323292 -122.420207017141 (37.74477323292, -122.420207017141) 2 7 7 28859 2
913 128077 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 10 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6009569.08364 2121877.54409 37.8068106763465 -122.411181901328 (37.8068106763465, -122.411181901328) 3 1 10 308 23
920 91853 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 601x Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2007 12:00:00 AM 3 3x3   6014039.760938 2113573.418065 37.7842592071543 -122.395128082808 (37.7842592071543, -122.395128082808) 6 2 9 28856 6
992 192119 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     22 Width 4ft   6010836.94593 2113119.25584 37.782833554469 -122.406176740686 (37.782833554469, -122.406176740686) 12 2 9 28853 34
1040 94769 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
1045 17359 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 2221X Franklin St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005488.40666 2117587.01663 37.7948002909451 -122.424998441372 (37.7948002909451, -122.424998441372) 13 9 1 28858 27
1076 260666 Permitted Site 7 Aesculus californica :: California Buckeye 168 2X Serrano Dr 4 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6                      
1112 8732 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 3210 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   02/21/1996 12:00:00 AM 6 3X3   5997102.31429 2113088.26659 37.7819706522719 -122.453690315182 (37.7819706522719, -122.453690315182) 11 6 1 54 31
1137 24844 Permitted Site 7 Casurina stricta :: Beefwood: Drooping She-Oak 173 200X Alemany Blvd 22 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   01/12/1996 12:00:00 AM 20 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
1143 29069 Permitted Site 7 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1002X Laguna St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5   12/15/2005 12:00:00 AM 15 3x3   6004818.3149515 2112301.2204093 37.7802489436872 -122.4269404119 (37.7802489436872, -122.4269404119) 7 9 11 28852 41
1244 27591 Permitted Site 7 Quercus suber :: Cork Oak 78 2100X San Bruno Ave 4 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   06/21/2001 12:00:00 AM 3 3x3   6009789.2811665 2096218.949435 37.7363704769246 -122.408608649696 (37.7363704769246, -122.408608649696) 10 7 7 309 2
1257 260668 Permitted Site 7 Aesculus californica :: California Buckeye 168 9 Cardenas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5989909.11704 2090923.47277 37.7206969761498 -122.47695514418 (37.7206969761498, -122.47695514418) 1 8 4 64 14
1265 120363 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 6118 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5988496.49362 2114018.15896 37.7840267560995 -122.483530334528 (37.7840267560995, -122.483530334528) 11 6 2 55 26
1331 25415 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 895X Mansell St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5   07/19/1996 12:00:00 AM 9 3X3   6009314.2175931 2089925.7733477 37.719064130172 -122.409807064317 (37.719064130172, -122.409807064317) 9 3 8 309 18
1346 260123 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 3195X Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2019 12:00:00 AM 3 3x3                      
1347 109892 Permitted Site 7 Tree(s) :: 17 205 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/09/2015 12:00:00 AM 3 3x6   5995308.1 2091295.6 37.7220304751495 -122.458319579925 (37.7220304751495, -122.458319579925) 9 8 4 28861 24
1358 109891 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1398x MARIPOSA ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013218 2106201 37.7639704813344 -122.397453893083 (37.7639704813344, -122.397453893083) 14 3 8 28856 29
1382 4111 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3385X Cesar Chavez St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/01/1995 12:00:00 AM 3 3x3   6007239.656 2100524.9644 37.7480507095515 -122.417728911573 (37.7480507095515, -122.417728911573) 2 4 7 28859 2
1402 128081 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 14 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6009658.72737 2121889.09987 37.8068474325394 -122.410872486877 (37.8068474325394, -122.410872486877) 3 1 10 308 23
1472 2091 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 943 Bosworth St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1992 12:00:00 AM 6 2X2   6001433.65825 2095553.49813 37.7340717929056 -122.437449841319 (37.7340717929056, -122.437449841319) 9 7 5 63 40
1501 27903 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 280 The Embarcadero 33 Sidewalk: Curb side : Cutout Tree Port 6   01/31/2001 12:00:00 AM 12     6015937.152 2112771.705 37.7821632154212 -122.388507741674 (37.7821632154212, -122.388507741674) 6 2 9 28856 6
1518 99500 Permitted Site 7 Aesculus hippocastanum :: White Horsechestnut 190 2698@Divisadero Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2           6000656 2117555 37.7944382299983 -122.441716891944 (37.7944382299983, -122.441716891944) 13 9 1 57 27
1546 86589 Permitted Site 7 Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 2680 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2007 12:00:00 AM 6 3x3   6009770 2101729 37.7514987921589 -122.40906398531 (37.7514987921589, -122.40906398531) 2 4 7 28859 19
1561 24107 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 105X Whitney Young Cir 14 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.081358 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885) 10 3 8 58 1
1663 27797 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8   03/17/2001 12:00:00 AM 3 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
1742 28048 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 4 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
1748 56640 Permitted Site 7 Tree(s) :: 17 2016 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2           6004277.89575757 2115357.17634953 37.7886092629589 -122.429027916831 (37.7886092629589, -122.429027916831) 13 9 11 29490 27
1852 24074 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 161X Whitney Young Cir 4 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6016395.7853594 2095946.5828375 37.735990405317 -122.385748008424 (37.735990405317, -122.385748008424) 10 3 8 58 1
1900 141936 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1101 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout Tree Office of Mayor 9   10/12/1994 12:00:00 AM 8 Width 0ft   6003954.1428 2112136.7195 37.7797483635991 -122.429918243479 (37.7797483635991, -122.429918243479) 7 9 11 29490 41
2025 97297 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 450 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5994062.8 2112448.2 37.7800384821655 -122.464159075962 (37.7800384821655, -122.464159075962) 11 6 2 54 11
2087 261314 Permitted Site 7 :: 45 2601 Divisadero St 1 Sidewalk: Property side : Cutout Landscaping Private 2   12/31/2019 12:00:00 AM 3 6x106                      
2118 73083 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3246 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1999 12:00:00 AM   3x3   6007158.13725384 2106179.72119915 37.7635727856768 -122.418411696436 (37.7635727856768, -122.418411696436) 8 4 7 28859 19
2124 209922 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 870 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5990546.69569 2099087.99208 37.7431516445476 -122.475347038257 (37.7431516445476, -122.475347038257) 1 8 4 29491 40
2153 100644 Permitted Site 7 Tree(s) :: 17 401X Clementina St 14 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
2222 20236 Permitted Site 7 Maytenus boaria :: Mayten 58 1750X Steiner St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/05/1992 12:00:00 AM 6 4X4   6002603.6550052 2114233.7432168 37.7854296891778 -122.434740163706 (37.7854296891778, -122.434740163706) 13 9 11 29490 13
2260 94780 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 13 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
2294 84947 Permitted Site 7 Tree(s) :: 17 1812 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003475 2114918 37.7873579154126 -122.431774444579 (37.7873579154126, -122.431774444579) 13 9 11 29490 27
2315 87492 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2085 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2010 12:00:00 AM 3 3x3   6015789.87829 2105903.76161 37.7632971922443 -122.388537703233 (37.7632971922443, -122.388537703233) 14 3 8 28856 29
2338 260969 Permitted Site 7 :: 45 897 37th Ave 1 Sidewalk: Curb side : Cutout Landscaping Private 2   11/05/2019 12:00:00 AM 3 10X27   5984476.51719 2109749.52706 37.7720715265353 -122.497122586729 (37.7720715265353, -122.497122586729) 11 6 2 55 26
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
2484 20118 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 875X Fell St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/06/1992 12:00:00 AM 12 2X2   6003233.15229 2110304.12624 37.774675660821 -122.432281545934 (37.774675660821, -122.432281545934) 15 9 11 29492 10
2507 103065 Permitted Site 7 Carpinus betulus 'Fastigiata' :: Upright European Hornbeam 234 255 Broadway 4 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6012256.1 2118721.6 37.7982955442476 -122.401660929382 (37.7982955442476, -122.401660929382) 3 1 10 28860 6
2509 27941 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 699 The Embarcadero 2 Median : Cutout Tree Port 6   02/01/2001 12:00:00 AM 24     6012787.5534626 2119857.700218 37.8014446443351 -122.399901749617 (37.8014446443351, -122.399901749617) 3 1 10 28860 6
2592 6305 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1797X Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/10/1997 12:00:00 AM 9 3X3   6002532.11938 2112833.28187 37.7815803152054 -122.434887466275 (37.7815803152054, -122.434887466275) 15 5 11 29490 41
2597 259971 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1606 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2019 12:00:00 AM 3 3x3   6008397.52034 2117962.2391 37.7959944556119 -122.414959044438 (37.7959944556119, -122.414959044438) 5 1 10 308 21
2665 93046 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 155 26th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5987682.5 2114946.6 37.7865285787391 -122.486414608476 (37.7865285787391, -122.486414608476) 11 6 1 55 33
2689 8750 Permitted Site 7 Olea europaea :: Olive Tree 9 3301 Geary Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   5996889.89707 2112871.05246 37.7813620597582 -122.454409481549 (37.7813620597582, -122.454409481549) 11 6 2 54 16
2703 2795 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 6530X California St 2 Sidewalk: Curb side : Cutout Tree Private 2     75 5   5987349.71414 2113973.97564 37.783838627391 -122.487494476151 (37.783838627391, -122.487494476151) 11 6 1 55 33
2714 113322 Permitted Site 7 Olea europaea :: Olive Tree 9 100 Church St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6004079.74050315 2108375.213269 37.7694273021614 -122.42921545709 (37.7694273021614, -122.42921545709) 7 9 5 28862 3
2738 140731 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 2023 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/02/2004 12:00:00 AM 12 Width 0ft   6001651.0062 2113204.4884 37.7825494877114 -122.437962288192 (37.7825494877114, -122.437962288192) 15 5 11 29490 41
2779 117319 Permitted Site 7 :: 45 1935 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5993426.4 2102307.1 37.7521569948021 -122.465623688401 (37.7521569948021, -122.465623688401) 1 8 4 29491 12
2917 4317 Permitted Site 7 Dracaena draco :: Dragon Tree 156 751 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6002188.03903 2095709.93291 37.7345441864792 -122.434852898904 (37.7345441864792, -122.434852898904) 2 7 5 63 7
2968 108902 Permitted Site 7 Ficus laurel :: 247 33 Gough St 4 Sidewalk: Curb side : Cutout Tree Private 2     21 4x6   6006450.1 2109317.2 37.7721476754667 -122.421083366581 (37.7721476754667, -122.421083366581) 8 2 9 28853 19
3012 15898 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 5647X Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/23/2005 12:00:00 AM 3 3X3   5998341.15292 2087120.08013 37.7107392839911 -122.447534700696 (37.7107392839911, -122.447534700696) 9 7 6 28861 5
3105 56728 Permitted Site 7 Tree(s) :: 17 1543 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           6015672.6894307 2095677.74798122 37.7352121997354 -122.388229306646 (37.7352121997354, -122.388229306646) 10 3 8 58 1
3133 53387 Permitted Site 7 Tree(s) :: 17 272 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5994766.71798377 2090393.02640531 37.7195210985022 -122.460125633496 (37.7195210985022, -122.460125633496) 9 8 6 28861 24
3159 94569 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100@ Cole Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998051 2107197 37.7658490933668 -122.449983584058 (37.7658490933668, -122.449983584058) 15 5 11 29492 9
3240 23833 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1302X Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2008 12:00:00 AM 3 3X3   6003750.8656173 2113176.0104319 37.7825904834742 -122.43069565207 (37.7825904834742, -122.43069565207) 7 9 11 29490 41
3264 1125 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 2466 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     25 3X3   5998958.39293 2088881.75103 37.7156116878713 -122.445527983003 (37.7156116878713, -122.445527983003) 9 7 6 28861 25
3325 11719 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 9 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
3413 128074 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 7 Sidewalk: Curb side : Cutout Tree Private 2   11/05/2019 12:00:00 AM 3 Width 4ft   6009478.77374 2121864.7268 37.8067704181858 -122.411493531709 (37.8067704181858, -122.411493531709) 3 1 10 308 23
3437 79 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 899 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     26 3X3   6002864.3199934 2107660.1796498 37.7673951141913 -122.433368437593 (37.7673951141913, -122.433368437593) 15 5 5 28862 3
3522 25785 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 500X The Embarcadero 4 Median : Cutout Tree Port 6   08/30/1996 12:00:00 AM 36 10   6013445.7547399 2119056.6213274 37.7992817461076 -122.397567846492 (37.7992817461076, -122.397567846492) 3 1 10 28860 6
3574 218861 Permitted Site 7 Olea europaea :: Olive Tree 9 44 Hugo St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5995517.64423 2107073.72636 37.7653653316693 -122.458736946766 (37.7653653316693, -122.458736946766) 15 5 11 56 12
3691 121048 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2652 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6006192.78395747 2119877.54417008 37.8011292630692 -122.422724050002 (37.8011292630692, -122.422724050002) 13 9 1 28858 32
3840 102234 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1285X Castro St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6002552.3 2101854.8 37.7514372340624 -122.434032637699 (37.7514372340624, -122.434032637699) 2 4 5 28862 22
3857 104292 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2245 Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2           5999485.4 2120797.2 37.8032736772553 -122.446000602494 (37.8032736772553, -122.446000602494) 13 9 1 57 17
3923 25589 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 1380X Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     40 3X3   6009160.7320011 2097455.9675675 37.7397318376167 -122.410869155933 (37.7397318376167, -122.410869155933) 10 7 7 28859 2
3938 12945 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 25 Lillian St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM 6 3X3   6017779.2478327 2094371.10413 37.7317409092053 -122.380855284503 (37.7317409092053, -122.380855284503) 10 3 8 58 1
3958 29691 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 235X Hahn St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/17/2006 12:00:00 AM 3 3X3   6007408.6946 2087074.91278 37.7111292927788 -122.416191939068 (37.7111292927788, -122.416191939068) 9 7 8 309 39
3975 56564 Permitted Site 7 Tree(s) :: 17 250 San Fernando Way 1 Sidewalk: Curb side : Cutout Tree Private 2           5992102.77849477 2095182.39763056 37.7325179438205 -122.469682298657 (37.7325179438205, -122.469682298657) 9 8 4 59 40
4051 260659 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2 Varela Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5990178.30137 2091110.96603 37.7212273981358 -122.476038353928 (37.7212273981358, -122.476038353928) 1 8 4 64 14
4128 109223 Permitted Site 7 Eucalyptus melliodora :: Yellow Box 188 1675 OWENS ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 4x4   6014234 2107598 37.7678628533553 -122.394037627847 (37.7678628533553, -122.394037627847) 14 3 9 310 20
4162 9982 Permitted Site 7 Maytenus boaria :: Mayten 58 660X Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3X3   5999273.00844 2110518.1825 37.7750380665947 -122.44599582765 (37.7750380665947, -122.44599582765) 15 5 11 29492 16

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);