194,517 rows sorted by rowid descending

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)
194517 265144 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 2166 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 782839 5997501.55835 2109896.92898 37.773230951126 -122.452078795234 (37.773230951126, -122.452078795234) 15 5 11 29492 16
194516 265149 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1201 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006404 2114579 37.7865927014925 -122.421616611631 (37.7865927014925, -122.421616611631) 13 9 11 28858 41
194515 265162 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1699 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006124 2116197 37.791019535338 -122.422700369292 (37.791019535338, -122.422700369292) 13 9 1 28858 27
194514 265151 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1201 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006404 2114579 37.7865927014925 -122.421616611631 (37.7865927014925, -122.421616611631) 13 9 11 28858 41
194513 265163 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1699 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006124 2116197 37.791019535338 -122.422700369292 (37.791019535338, -122.422700369292) 13 9 1 28858 27
194512 246989 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 74 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4   6004681.91881 2101068.44983 37.7493987293702 -122.426612168643 (37.7493987293702, -122.426612168643) 2 4 5 28862 22
194511 23411 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1790 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006198.56305 2116531.68812 37.7919427119246 -122.422466175278 (37.7919427119246, -122.422466175278) 13 9 10 28858 21
194510 133064 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1790 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006197.29283 2116545.94616 37.7919817892855 -122.422471583817 (37.7919817892855, -122.422471583817) 13 9 10 28858 21
194509 134259 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1625 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     8 Width 4ft   6006170.6591 2116000.96505 37.7904839045708 -122.422524994529 (37.7904839045708, -122.422524994529) 13 9 1 28858 27
194508 203796 DPW Maintained 1 Schinus molle :: California Pepper 91 460 Pacheco St 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   5993728.30174 2101878.83793 37.7509985054805 -122.464548580761 (37.7509985054805, -122.464548580761) 1 8 4 29491 12
194507 265147 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1362 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x6   5993998 2106231 37.7629639639015 -122.463931825158 (37.7629639639015, -122.463931825158) 1 5 11 56 12
194506 134257 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1625 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 Width 4ft   6006160.66305 2116055.60858 37.7906333781701 -122.422563464854 (37.7906333781701, -122.422563464854) 13 9 1 28858 27
194505 134258 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1625 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 Width 4ft   6006165.05583 2116021.37931 37.7905396409395 -122.422545832742 (37.7905396409395, -122.422545832742) 13 9 1 28858 27
194504 265143 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 333 Lansdale Ave 1 Front Yard : Yard Tree Private 2       3x3   5995416 2096422 37.7361125310636 -122.458317465478 (37.7361125310636, -122.458317465478) 9 7 4 59 40
194503 265148 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1201 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006404 2114579 37.7865927014925 -122.421616611631 (37.7865927014925, -122.421616611631) 13 9 11 28858 41
194502 265146 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3512 23rd St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006075 2102620 37.753737588166 -122.421905052211 (37.753737588166, -122.421905052211) 2 4 5 28859 19
194501 265145 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 2160 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2021 12:00:00 AM 3 3x3 Permit Number 782838 5997529.09133 2109900.74605 37.7732430089022 -122.451983830898 (37.7732430089022, -122.451983830898) 15 5 11 29492 16
194500 133065 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1790 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6006194.66564 2116570.23884 37.7920483427106 -122.422482400837 (37.7920483427106, -122.422482400837) 13 9 10 28858 21
194499 265142 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 75X Cedro Ave 1 Back Yard : Cutout Tree Private 2       3x3   5992440 2092965 37.7264490050903 -122.468355192232 (37.7264490050903, -122.468355192232) 9 8 4 59 40
194498 265150 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1201 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006404 2114579 37.7865927014925 -122.421616611631 (37.7865927014925, -122.421616611631) 13 9 11 28858 41
194497 161370 DPW Maintained 1 Olea europaea :: Olive Tree 9 530 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3   6002550.45613 2090822.0233 37.7211436611464 -122.433250757115 (37.7211436611464, -122.433250757115) 9 7 6 28861 5
194496 265137 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 90X Broadmoor Dr 1 Sidewalk: Property side : Cutout Tree Private 2       4x6   5991049 2093460 37.7277277099678 -122.47319985648 (37.7277277099678, -122.47319985648) 9 8 4 64 40
194495 265132 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 582 Minna St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2021 12:00:00 AM 3 Width 3ft   6009649.44136 2111748.76797 37.779004025349 -122.410188235924 (37.779004025349, -122.410188235924) 14 2 9 28853 34
194494 264749 Section 806 (d) 5 Quercus suber :: Cork Oak 78 1339 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2021 12:00:00 AM 3 3x3 Permit Number 785207 5991088 2106284 37.7629413570223 -122.474000279679 (37.7629413570223, -122.474000279679) 1 8 11 56 12
194493 198350 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 582 Minna St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2021 12:00:00 AM 3 Width 3ft   6009649.44136 2111748.76797 37.779004025349 -122.410188235924 (37.779004025349, -122.410188235924) 14 2 9 28853 34
194492 198349 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 582 Minna St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2021 12:00:00 AM 3 Width 3ft   6009676.44757 2111773.36743 37.7790730833855 -122.410096547333 (37.7790730833855, -122.410096547333) 14 2 9 28853 34
194491 226546 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 53 Dorland St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6005228 2105709 37.7621714532816 -122.425053942898 (37.7621714532816, -122.425053942898) 8 4 5 28859 19
194490 171446 DPW Maintained 1 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 130 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2017 12:00:00 AM 3 Width 2ft   6004630.97691 2092622.98585 37.7262065159928 -122.426187146329 (37.7262065159928, -122.426187146329) 9 7 6 28861 5
194489 64389 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1050 Van Ness Ave 1 Sidewalk: Curb side : Pot Tree Private 2   04/28/1988 12:00:00 AM 4   Permit Number 25231 6006529.57186 2114155.94695 37.7854381817627 -122.421152111986 (37.7854381817627, -122.421152111986) 13 9 9 28858 36
194488 230144 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 4363 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft Permit Number 784873 6001567.34631 2100557.57487 37.747819415532 -122.437345839845 (37.747819415532, -122.437345839845) 2 4 5 63 22
194487 265122 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2100x Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6006061 2117676 37.7950769441166 -122.423023514153 (37.7950769441166, -122.423023514153) 13 9 10 28858 32
194486 86928 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 838 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/24/2014 12:00:00 AM 3 3x3 Permit Number 774404 6011535 2104444 37.7590523005339 -122.403151323818 (37.7590523005339, -122.403151323818) 10 3 8 28856 29
194485 181039 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 55 Newton St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2017 12:00:00 AM 3 Width 4ft   6000909.27168 2088176.54977 37.7137865448937 -122.438734374192 (37.7137865448937, -122.438734374192) 9 7 6 28861 5
194484 27260 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1300X Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6006404.26283 2115076.39725 37.7879584463594 -122.421651043279 (37.7879584463594, -122.421651043279) 13 9 10 28858 21
194483 265134 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 Winston Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       4x6   5990934 2093194 37.7269906812088 -122.47357801435 (37.7269906812088, -122.47357801435) 9 8 4 64 40
194482 265119 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1900 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   6006128.11756 2117026.5772 37.7932975792601 -122.422745102704 (37.7932975792601, -122.422745102704) 13 9 10 28858 32
194481 256359 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2655 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   04/18/2008 12:00:00 AM   3x3 Permit Number 48401 6005661 2119519 37.8001147748179 -122.424538736295 (37.8001147748179, -122.424538736295) 13 9 1 57 17
194480 265130 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 119X 07th St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/11/2021 12:00:00 AM 3 3x3   6009560.38235 2111747.77793 37.7789963145717 -122.410496258221 (37.7789963145717, -122.410496258221) 14 2 9 28853 34
194479 265136 Undocumented 4 :: Tree 573 100 Winston Dr 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990934 2093194 37.7269906812088 -122.47357801435 (37.7269906812088, -122.47357801435) 9 8 4 64 40
194478 35851 DPW Maintained 1 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 500 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2016 12:00:00 AM 3 3x3 Permit Number 778923 6001833.39372 2090697.41132 37.7207607999542 -122.435720519401 (37.7207607999542, -122.435720519401) 9 7 6 28861 5
194477 265131 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 582 Minna St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2021 12:00:00 AM 3 Width 3ft   6009649.44136 2111748.76797 37.779004025349 -122.410188235924 (37.779004025349, -122.410188235924) 14 2 9 28853 34
194476 179001 DPW Maintained 1 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 500 Paris St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft Permit Number 778923 6001827.05422 2090687.03762 37.7207319560017 -122.435741691253 (37.7207319560017, -122.435741691253) 9 7 6 28861 5
194475 207568 Prune Opt Out 3 Eriobotrya deflexa :: Bronze Loquat 8 1430 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft Permit Number 788015 5993375.17513 2105731.36286 37.7615561785078 -122.466049635587 (37.7615561785078, -122.466049635587) 1 8 11 56 12
194474 265121 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2100x Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6006061 2117676 37.7950769441166 -122.423023514153 (37.7950769441166, -122.423023514153) 13 9 10 28858 32
194473 258633 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 625 Niagara Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2021 12:00:00 AM 3 4x6   5997754 2090591 37.7202360579042 -122.449813998345 (37.7202360579042, -122.449813998345) 9 8 6 28861 24
194472 203213 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 626 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2018 12:00:00 AM 3 10x4 Permit Number 781523 6001387 2090021 37.7188781603148 -122.437215155763 (37.7188781603148, -122.437215155763) 9 7 6 28861 5
194471 179002 DPW Maintained 1 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 500 Paris St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft Permit Number 778923 6001822.18343 2090679.74768 37.7207116627863 -122.43575800674 (37.7207116627863, -122.43575800674) 9 7 6 28861 5
194470 254768 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 415 Victoria St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/28/2018 12:00:00 AM 3 3x3 Permit Number 781626 5993212 2089957 37.7182343284954 -122.4654680237 (37.7182343284954, -122.4654680237) 9 8 6 64 24
194469 28912 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 119X 07th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/11/2021 12:00:00 AM 3 3x3   6009560.38235 2111747.77793 37.7789963145717 -122.410496258221 (37.7789963145717, -122.410496258221) 14 2 9 28853 34
194468 265112 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1300X Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1       3X3   6006404.26283 2115076.39725 37.7879584463594 -122.421651043279 (37.7879584463594, -122.421651043279) 13 9 10 28858 21
194467 265133 Significant Tree 6 Cordyline australis :: Dracena Palm 64 2166 41st Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/11/2021 12:00:00 AM 3 3x3 Permit Number 783123 5983589.67085 2100408.11005 37.7463706120083 -122.499499736486 (37.7463706120083, -122.499499736486) 1 8 3 29491 35
194466 265098 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 880 Urbano Dr 3 Sidewalk: Property side : Cutout Tree Private 2       15x4   5993935 2091989 37.7238553830872 -122.46311629567 (37.7238553830872, -122.46311629567) 9 8 4 59 40
194465 63910 Prune Opt Out 3 Ficus retusa nitida :: Banyan Fig 54 2135 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/18/1991 12:00:00 AM 14   Permit Number 788005 6009385.3216 2121038.8544 37.8044975370449 -122.411758548847 (37.8044975370449, -122.411758548847) 3 1 10 308 23
194464 265097 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 880 Urbano Dr 2 Sidewalk: Property side : Cutout Tree Private 2       15x4   5993935 2091989 37.7238553830872 -122.46311629567 (37.7238553830872, -122.46311629567) 9 8 4 59 40
194463 265099 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 880 Urbano Dr 4 Sidewalk: Property side : Cutout Tree Private 2       15x4   5993935 2091989 37.7238553830872 -122.46311629567 (37.7238553830872, -122.46311629567) 9 8 4 59 40
194462 233115 Prune Opt Out 3 Olea europaea :: Olive Tree 9 29 Kronquist Ct 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft Permit Number 788008 6002251.64499 2100180.50663 37.7468229532305 -122.434952608978 (37.7468229532305, -122.434952608978) 2 7 5 63 22
194461 265095 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 1100 Junipero Serra Blvd 1 Side Yard : Cutout Tree Private 2       10x10   5991104 2090006 37.7182470667789 -122.472757983106 (37.7182470667789, -122.472757983106) 9 8 4 64 40
194460 234487 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 380 Cumberland St 1 Sidewalk: Property side : Yard Tree Private 2     44 Width 3ft   6003189.58252 2104492.34613 37.7587154557579 -122.432017164278 (37.7587154557579, -122.432017164278) 2 4 5 28862 3
194459 248440 Prune Opt Out 3 Pittosporum undulatum :: Victorian Box 36 724 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft Permit Number 788001 5997627.8337 2107978.5557 37.7679708233346 -122.451503597918 (37.7679708233346, -122.451503597918) 15 5 11 29492 9
194458 238322 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Danvers St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5999967 2105076 37.7601348010019 -122.443204214657 (37.7601348010019, -122.443204214657) 2 4 5 28862 3
194457 233114 Prune Opt Out 3 Olea europaea :: Olive Tree 9 29 Kronquist Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft Permit Number 788008 6002253.24641 2100155.04403 37.7467531298542 -122.434945250724 (37.7467531298542, -122.434945250724) 2 7 5 63 22
194456 265094 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 172 Locksley Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       2x2   5994312 2104105 37.7571446085096 -122.462691582653 (37.7571446085096, -122.462691582653) 1 5 4 63 12
194455 238321 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Danvers St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5999967 2105076 37.7601348010019 -122.443204214657 (37.7601348010019, -122.443204214657) 2 4 5 28862 3
194454 160418 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 645 France Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/25/2017 04:39:00 PM 3 Width 0ft   6002625.21582 2089488.77592 37.7174871004251 -122.432897134702 (37.7174871004251, -122.432897134702) 9 7 6 28861 5
194453 265096 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 880 Urbano Dr 1 Sidewalk: Property side : Cutout Tree Private 2       15x4   5993935 2091989 37.7238553830872 -122.46311629567 (37.7238553830872, -122.46311629567) 9 8 4 59 40
194452 237613 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 105 Danvers St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5999967 2105076 37.7601348010019 -122.443204214657 (37.7601348010019, -122.443204214657) 2 4 5 28862 3
194451 238323 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Danvers St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5999967 2105076 37.7601348010019 -122.443204214657 (37.7601348010019, -122.443204214657) 2 4 5 28862 3
194450 234943 Prune Opt Out 3 Pittosporum undulatum :: Victorian Box 36 4339 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft Permit Number 788007 6001670.90597 2100562.91239 37.7478399578525 -122.436988118323 (37.7478399578525, -122.436988118323) 2 4 5 63 22
194449 262095 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 3550 Cesar Chavez St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 785078 6006203 2100616 37.7482422814736 -122.421320098122 (37.7482422814736, -122.421320098122) 2 4 5 28859 19
194448 265090 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 215 Montana St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/04/2021 12:00:00 AM 3 3x3 Permit Number 784731 5994883.78198 2089306.03852 37.7165432206381 -122.459642300713 (37.7165432206381, -122.459642300713) 9 8 6 28861 24
194447 265091 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3550 Cesar Chavez St 10 Sidewalk: Curb side : Cutout Tree Private 2   01/04/2021 12:00:00 AM 3 3x3 Permit Number 785078 6006085.39303 2100598.74488 37.7481882715663 -122.421725554794 (37.7481882715663, -122.421725554794) 2 4 5 28859 19
194446 4132 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3550 Cesar Chavez St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/04/2021 12:00:00 AM 3 3x3 Permit Number 785078 6006390.9849 2100603.33536 37.7482181038931 -122.420669151754 (37.7482181038931, -122.420669151754) 2 4 5 28859 19
194445 24428 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1501 Franklin St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/20/1995 12:00:00 AM 3 3X3   6005809.51077 2115255.80256 37.7884174936216 -122.42372154163 (37.7884174936216, -122.42372154163) 13 9 1 28858 41
194444 4138 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 3550 Cesar Chavez St 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6006105.41199 2100602.05875 37.7481984995675 -122.421656565093 (37.7481984995675, -122.421656565093) 2 4 5 28859 19
194443 231199 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3636 Cesar Chavez St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/04/2021 12:00:00 AM 3 3x3 Permit Number 785078 6005923.7545 2100590.88969 37.7481575867153 -122.422283938475 (37.7481575867153, -122.422283938475) 2 4 5 28859 19
194442 221796 Prune Opt Out 3 Agonis flexuosa :: Peppermint Willow 65 436 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft Permit Number 787981 6004110.94859 2110346.00561 37.7748403836965 -122.429248059072 (37.7748403836965, -122.429248059072) 7 9 11 28852 10
194441 180986 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 363 Munich St 2 Sidewalk: Property side : Yard Tree Private 2   10/11/2017 09:24:00 AM 3 Width 10ft   6004214.2336 2090323.21202 37.7198682794893 -122.427464041535 (37.7198682794893, -122.427464041535) 9 7 6 28861 5
194440 221797 Prune Opt Out 3 Agonis flexuosa :: Peppermint Willow 65 436 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 3ft Permit Number 787981 6004113.21358 2110335.22701 37.7748109165297 -122.429239455258 (37.7748109165297, -122.429239455258) 7 9 11 28852 10
194439 62177 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 33 Meda Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/31/2017 12:00:00 AM 3 3x3 Permit Number 780357 6000151.49887 2091775.04378 37.7236240542963 -122.441611590516 (37.7236240542963, -122.441611590516) 9 7 6 28861 25
194438 225616 Prune Opt Out 3 Ginkgo biloba :: Maidenhair Tree 22 15 Conrad St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft Permit Number 787984 6001852.25626 2097023.92467 37.7381330336073 -122.436107807923 (37.7381330336073, -122.436107807923) 2 7 5 63 7
194437 178494 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 122 Maynard St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2017 12:00:00 AM 3 Width 3ft   6004225.74636 2093744.10414 37.7292619446745 -122.427667848611 (37.7292619446745, -122.427667848611) 9 7 6 28861 5
194436 15776 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4804 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/08/2017 12:00:00 AM 3 3X3 Permit Number 773279 6001272.7685 2090814.9657 37.7210517172508 -122.437666839136 (37.7210517172508, -122.437666839136) 9 7 6 28861 25
194435 103878 DPW Maintained 1 Olea europaea :: Olive Tree 9 791 Vienna St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2017 12:00:00 AM 3 6x6 Permit Number 776939 6002377.91546 2088944.75079 37.7159792979937 -122.433713076995 (37.7159792979937, -122.433713076995) 9 7 6 28861 5
194434 37829 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 450X Moscow St 17 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:54:00 AM 3 3x3 Permit Number 40134 6003878.28183 2090416.42534 37.7201052157501 -122.428631950629 (37.7201052157501, -122.428631950629) 9 7 6 28861 5
194433 211684 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 95 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 3x3 Permit Number 780277 5995309.61761 2090529.04665 37.7199257893373 -122.458258879737 (37.7199257893373, -122.458258879737) 9 8 6 28861 24
194432 15774 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4800 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2017 12:00:00 AM 3 3x3 Permit Number 773279 6001280.0938 2090832.0581 37.7210990656339 -122.437642741249 (37.7210990656339, -122.437642741249) 9 7 6 28861 25
194431 265089 Undocumented 4 Olea europaea :: Olive Tree 9 747 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002550 2089172 37.7166130372881 -122.433134500018 (37.7166130372881, -122.433134500018) 9 7 6 28861 5
194430 206231 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1283 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5995148.67652 2106807.2788 37.7646125217846 -122.459993807784 (37.7646125217846, -122.459993807784) 15 5 11 56 12
194429 160546 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 755 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/2017 08:38:00 AM 3 4x5   6002026.63127 2089400.9055 37.7172118584185 -122.434959882691 (37.7172118584185, -122.434959882691) 9 7 6 28861 5
194428 253435 DPW Maintained 1 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 793 Vienna St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/18/2017 11:49:00 AM 3     6002373 2088903 37.7158643806251 -122.433727084844 (37.7158643806251, -122.433727084844) 9 7 6 28861 5
194427 15775 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4808 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/08/2017 12:00:00 AM 3 3X3 Permit Number 773279 6001261.3736 2090797.0594 37.7210019026793 -122.437704946106 (37.7210019026793, -122.437704946106) 9 7 6 28861 25
194426 211685 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 95 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2017 12:00:00 AM 3 3x3 Permit Number 780277 5995307.7579 2090507.37878 37.7198661876486 -122.458263740606 (37.7198661876486, -122.458263740606) 9 8 6 28861 24
194425 221795 Prune Opt Out 3 Agonis flexuosa :: Peppermint Willow 65 438 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft Permit Number 787981 6004107.34969 2110372.49722 37.7749129194169 -122.42926239785 (37.7749129194169, -122.42926239785) 7 9 11 28852 10
194424 62181 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 18 Meda Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/30/2017 12:00:00 AM 3   Permit Number 778619 6000227.93753 2091768.58709 37.7236106804803 -122.441346893068 (37.7236106804803, -122.441346893068) 9 7 6 28861 25
194423 15800 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 4950 Mission St 8 Sidewalk: Curb side : Cutout Tree DPW 1   10/05/2018 02:11:00 PM 3 4x4   6000889.9210477 2090200.0223298 37.7193414459012 -122.438946180066 (37.7193414459012, -122.438946180066) 9 7 6 28861 25
194422 37823 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:49:00 AM 3 3x3 Permit Number 40134 6003922.69393 2090463.29382 37.7202364196636 -122.428481771941 (37.7202364196636, -122.428481771941) 9 7 6 28861 5
194421 257937 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 430 Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2020 12:00:00 AM 3 3x3   6005729.4209 2111051.1148 37.7768679337671 -122.423699563703 (37.7768679337671, -122.423699563703) 7 9 11 28852 10
194420 265068 DPW Maintained 1 Zelkova serrata :: Sawleaf Zelkova 302 500 France Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     Width 0ft   6002272.40257 2089666.1121 37.7179540086612 -122.434129316516 (37.7179540086612, -122.434129316516) 9 7 6 28861 5
194419 179076 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2 Edinburgh St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 09:01:00 AM 3 Width 3ft   6004489 2093431 37.7284171179042 -122.426735469001 (37.7284171179042, -122.426735469001) 9 7 6 28861 5
194418 265072 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 2027 41st Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5983517.97374 2101348.17171 37.7489475550359 -122.499817124771 (37.7489475550359, -122.499817124771) 1 8 3 29491 35

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