trees
39,840 rows where qLegalStatus_id = 7 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );