Street_Tree_List

Data source: data.sfgov.org

4,048 rows where qSpecies = 18 sorted by XCoord

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord ▼ YCoord Latitude Longitude Location
67142 118470 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 510 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5981008.92024 2112222.55161 37.7786579010228 -122.50930075514499 (37.7786579010228, -122.509300755145)
67642 118478 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 578 48th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5981024.51617 2111800.84509 37.7775009394111 -122.509215478972 (37.7775009394111, -122.509215478972)
99492 110751 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 510 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2015 12:00:00 AM 3   Permit Number 775489 5981042.2 2112214.0 37.778636382962 -122.509184994454 (37.778636382962, -122.509184994454)
50040 87823 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 451 47th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/05/2008 12:00:00 AM 4 2x3 Permit Number 50716 5981265.5826900005 2112596.97795 37.7797010943021 -122.508440678428 (37.7797010943021, -122.508440678428)
37553 87825 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 451 47th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/05/2008 12:00:00 AM 3 2x3 Permit Number 50716 5981267.84329 2112567.4887599996 37.7796202589611 -122.508430668506 (37.7796202589611, -122.508430668506)
46301 87824 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 451 47th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/05/2008 12:00:00 AM 3 2x3 Permit Number 50716 5981268.94768 2112581.1831099996 37.7796579246713 -122.50842786485799 (37.7796579246713, -122.508427864858)
150585 56095 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 783 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/12/2009 12:00:00 AM 2 3x3 Permit Number 52001 5981348.38409 2110404.98623 37.7736874110676 -122.507991510924 (37.7736874110676, -122.507991510924)
187658 92257 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 862 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/23/2009 12:00:00 AM 3 3x3 Permit Number 52706 5981411.16308 2109852.88199 37.7721751933845 -122.50773337462299 (37.7721751933845, -122.507733374623)
185931 118627 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 494 46th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5981628.0956 2112437.91019 37.7792856992778 -122.50717480668301 (37.7792856992778, -122.507174806683)
131729 34701 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 546 46th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/23/2009 12:00:00 AM 3 3x3 Permit Number 52703 5981643.1854 2112019.5317 37.7781378442384 -122.507091560706 (37.7781378442384, -122.507091560706)
148645 34700 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 546 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/23/2009 12:00:00 AM 1 3x3 Permit Number 52703 5981644.97521 2112008.50675 37.7781076783894 -122.507084551143 (37.7781076783894, -122.507084551143)
65153 50405 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 815 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/23/2009 12:00:00 AM 3 3x3 Permit Number 52709 5981666.2240699995 2110158.20965 37.7730285573555 -122.506873764155 (37.7730285573555, -122.506873764155)
31693 119100 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 855 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5981674.98764 2109913.6134599997 37.772357483762704 -122.50682530453399 (37.7723574837627, -122.506825304534)
148211 68564 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 575 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM 4   Permit Number 32454 5981914.34705 2111854.14558 37.7776997090602 -122.506141264398 (37.7776997090602, -122.506141264398)
147767 119067 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 575 45th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5981914.59302 2111829.39054 37.7776317534825 -122.506138577528 (37.7776317534825, -122.506138577528)
52139 118798 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 810 45th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   5982020.13723 2110219.13712 37.7732166816615 -122.50565407298599 (37.7732166816615, -122.505654072986)
46117 68549 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 543 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM 3   Permit Number 32436 5982217.68828 2112054.92779 37.7782688503059 -122.50510680493 (37.7782688503059, -122.50510680493)
34490 68541 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 501 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM 6   Permit Number 32425 5982517.9924800005 2112299.68917 37.778958557712606 -122.504086094205 (37.7789585577126, -122.504086094205)
186975 119011 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 501 43rd Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5982518.7729400005 2112266.03771 37.778866206576794 -122.504080901039 (37.7788662065768, -122.504080901039)
181943 119012 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 501 43rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5982519.09297 2112280.9796700003 37.778907251633704 -122.50408090101801 (37.7789072516337, -122.504080901018)
105625 68543 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 519 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM     Permit Number 32427 5982523.73467 2112217.34809 37.7787328109508 -122.504060129291 (37.7787328109508, -122.504060129291)
183324 68544 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 571 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM 8   Permit Number 32430 5982530.7498 2111896.5441900003 37.777852390021 -122.504012093664 (37.777852390021, -122.504012093664)
163678 81982 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 563 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/11/2007 12:00:00 AM 1 3x3 Permit Number 49998 5982533.65676 2111927.12728 37.7779365331701 -122.504004303472 (37.7779365331701, -122.504004303472)
54483 119001 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 623 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5982546.8216699995 2111525.4630400003 37.7768344548721 -122.503929004913 (37.7768344548721, -122.503929004913)
59474 119000 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 623 43rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5982547.10807 2111503.78055 37.776774937935 -122.503926407866 (37.776774937935, -122.503926407866)
136410 82431 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 650 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/2009 12:00:00 AM 1 3x3 Permit Number 52680 5982600.56645 2111346.95635 37.7763474878375 -122.503729865488 (37.7763474878375, -122.503729865488)
61940 92237 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 710 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/2009 12:00:00 AM 3 3x3 Permit Number 52681 5982614.54862 2110914.94505 37.7751621329201 -122.503649497706 (37.7751621329201, -122.503649497706)
57130 92234 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 530 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/22/2009 12:00:00 AM 4 3x3 Permit Number 52677 5982879.44866 2112163.93194 37.778607057674996 -122.50282564106199 (37.778607057675, -122.502825641062)
30074 47440 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 859 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 5   Permit Number 45351 5982914.18523 2109947.95579 37.7725246733221 -122.50254141771099 (37.7725246733221, -122.502541417711)
102770 96076 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 411 41st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     3x3 Permit Number 767701 5983098.7 2113007.7 37.780936680817206 -122.502129633812 (37.7809366808172, -122.502129633812)
175243 96075 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 411 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2011 12:00:00 AM 3 3x3 Permit Number 767701 5983103.04582 2113013.19289 37.7809520179972 -122.50211500631399 (37.7809520179972, -122.502115006314)
153533 117710 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 477 41st Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 8ft   5983117.17834 2112671.33055 37.7800141944428 -122.502040811752 (37.7800141944428, -122.502040811752)
50531 96079 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 664 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2011 12:00:00 AM 1 3x3 Permit Number 767703 5983226.11153 2111277.81973 37.7761944189321 -122.501560849986 (37.7761944189321, -122.501560849986)
135433 96081 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 790 41st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2011 12:00:00 AM 1 3x3 Permit Number 767704 5983251.84023 2110453.37841 37.773932253218 -122.501410848383 (37.773932253218, -122.501410848383)
23887 83255 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 790 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   1     5983253.61867 2110435.38712 37.773882958787205 -122.501403365431 (37.7738829587872, -122.501403365431)
94281 96080 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 790 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2011 12:00:00 AM   3x3 Permit Number 767704 5983278.4 2110433.5 37.7738792326413 -122.501317504516 (37.7738792326413, -122.501317504516)
130514 117789 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3921 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5983401.92135 2111008.87073 37.7754662872697 -122.500932791041 (37.7754662872697, -122.500932791041)
43768 81737 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 591 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/07/2007 12:00:00 AM 4 3x3 Permit Number 49969 5983468.0529 2111801.95258 37.7776477425111 -122.500762690576 (37.7776477425111, -122.500762690576)
140762 92430 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1758 41st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2009 12:00:00 AM   3x3 Permit Number 52821 5983521.6 2103180.6 37.7539791070225 -122.499940017573 (37.7539791070225, -122.499940017573)
168858 117913 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 893 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5983541.21756 2109770.57795 37.7720744705229 -122.500359367665 (37.7720744705229, -122.500359367665)
166746 117912 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 889 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   5983541.524809999 2109784.94999 37.772113950042794 -122.50035936764999 (37.7721139500428, -122.50035936765)
180951 73633 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 782 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/1996 12:00:00 AM 1     5983562.4874599995 2110479.0519 37.7740209842304 -122.500338183608 (37.7740209842304, -122.500338183608)
158906 82734 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 663 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2009 12:00:00 AM 3 3x3 Permit Number 52670 5983795.84033 2111312.2935099998 37.776322519429606 -122.499592582815 (37.7763225194296, -122.499592582815)
61829 79376 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 683 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2009 12:00:00 AM 3 3x3 Permit Number 52671 5983799.61702 2111191.23616 37.7759903525694 -122.499570569578 (37.7759903525694, -122.499570569578)
156479 94817 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 683 39th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/10/2009 12:00:00 AM 3 3x3 Permit Number 52671 5983800.6479400005 2111169.09276 37.775929613686294 -122.499565366534 (37.7759296136863, -122.499565366534)
158895 92228 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 819 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2009 12:00:00 AM 2 3x3 Permit Number 52552 5984148.0757 2110235.49072 37.77338659024161 -122.498294572929 (37.7733865902416, -122.498294572929)
147200 92229 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 831 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2009 12:00:00 AM 2 3x3 Permit Number 52669 5984149.10381 2110157.50395 37.7731725212481 -122.498285255587 (37.7731725212481, -122.498285255587)
24823 47425 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 754 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 5   Permit Number 45336 5984176.15569 2110679.3098400002 37.7746068364777 -122.49823022658701 (37.7746068364777, -122.498230226587)
71854 81961 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 485 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/07/2007 12:00:00 AM 2   Permit Number 49960 5984369.11349 2112553.91349 37.779765269334504 -122.49770119972901 (37.7797652693345, -122.497701199729)
90446 90655 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3434 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/2008 12:00:00 AM 3 3x3   5984935.16156 2110442.47233 37.774001023784706 -122.495587241992 (37.7740010237847, -122.495587241992)
165384 79359 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 567 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/28/2004 12:00:00 AM 4     5985009.753819999 2112015.61326 37.778324785429895 -122.495445265062 (37.7783247854299, -122.495445265062)
85362 87022 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 569 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2007 12:00:00 AM   3x3 Permit Number 49956 5985016.5 2111999.9 37.7782820363511 -122.49542076869 (37.7782820363511, -122.49542076869)
33711 49142 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 520 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2003 12:00:00 AM 4   Permit Number 46265 5985047.031690001 2112314.4789400003 37.7791475672211 -122.495338355641 (37.7791475672211, -122.495338355641)
112200 115223 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 741 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   5985056.66405 2110813.18731 37.7750260153576 -122.49519429373699 (37.7750260153576, -122.495194293737)
175612 118209 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 574 35th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 3ft   5985058.9891 2111965.86595 37.7781910764099 -122.495271274867 (37.7781910764099, -122.495271274867)
47309 118074 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 490 34th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   5985345.158419999 2112648.80165 37.780082972151796 -122.494331678402 (37.7800829721518, -122.494331678402)
154069 43063 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 490 34th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/2008 12:00:00 AM 2 3x3 Permit Number 51464 5985346.9900400005 2112594.40853 37.779933731493294 -122.49432133158399 (37.7799337314933, -122.494321331584)
114388 28783 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 6938 Geary Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3   5985480.3602 2112543.9942799998 37.7798031124689 -122.493856235161 (37.7798031124689, -122.493856235161)
80503 28782 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 6938 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3   5985488.09937 2112541.18326 37.7797958470089 -122.493829255147 (37.7797958470089, -122.493829255147)
59367 118092 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 6909 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5985489.9688800005 2112456.39359 37.7795631483254 -122.493816537688 (37.7795631483254, -122.493816537688)
84850 28781 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 6938 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3   5985497.48939 2112543.62929 37.7798031124744 -122.493796951714 (37.7798031124744, -122.493796951714)
184337 118091 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 6909 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5985501.15731 2112457.22496 37.779566085611 -122.493777893955 (37.779566085611, -122.493777893955)
32455 118090 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 6909 Geary Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5985513.83516 2112457.38253 37.779567259959 -122.493734048085 (37.779567259959, -122.493734048085)
110260 28780 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 6918 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   5985532.54019 2112610.11302 37.7799877082801 -122.493680597714 (37.7799877082801, -122.493680597714)
160586 95194 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 517 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2011 12:00:00 AM 1 3x3 Permit Number 767108 5985627.976369999 2112321.20657 37.7792000368481 -122.49332915492701 (37.7792000368481, -122.493329154927)
170118 250758 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 214 32nd Ave 1 : 4 Tree 1 Private 1     6 Width 3ft   5985901.94322 2114466.62788 37.785106767213705 -122.49253944703699 (37.7851067672137, -122.492539447037)
147077 250761 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 228 32nd Ave 2 : 4 Tree 1 Private 1     6 Width 3ft   5985903.37202 2114379.41265 37.7848673829594 -122.49252807871001 (37.7848673829594, -122.49252807871)
73215 250760 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 228 32nd Ave 1 : 4 Tree 1 Private 1     3 Width 3ft   5985903.61307 2114361.31306 37.7848177008131 -122.492525911365 (37.7848177008131, -122.492525911365)
103477 115280 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1670 Sloat Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/21/2016 12:00:00 AM     Permit Number 775682 5985986.6 2095938.5 37.73423859995479 -122.49088271409599 (37.7342385999548, -122.490882714096)
105490 115279 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1670 Sloat Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/21/2016 12:00:00 AM     Permit Number 775682 5985986.6 2095938.5 37.73423859995479 -122.49088271409599 (37.7342385999548, -122.490882714096)
108780 92311 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2211 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/2008 12:00:00 AM 3 3x3   5986022.3 2100155.2 37.7458186185696 -122.491069496457 (37.7458186185696, -122.491069496457)
80522 90634 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3040 Cabrillo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/2008 12:00:00 AM 3 3x3   5986072.775219999 2110484.3905599997 37.774182669931996 -122.49165518484101 (37.774182669932, -122.491655184841)
142580 90633 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3040 Cabrillo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/2008 12:00:00 AM 3 3x3   5986086.317840001 2110484.4196099997 37.7741835411504 -122.491608341302 (37.7741835411504, -122.491608341302)
127018 90632 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3040 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/2008 12:00:00 AM 3 3x3   5986103.36345 2110484.3741200003 37.774184412397794 -122.491549374976 (37.7741844123978, -122.491549374976)
75705 250820 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 60 Sea View Ter 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5986182.97775 2114165.47247 37.7842963089586 -122.49154499381599 (37.7842963089586, -122.491544993816)
153946 250819 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 60 Sea View Ter 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5986191.04243 2114164.9353 37.7842953053345 -122.49151705368999 (37.7842953053345, -122.49151705369)
121235 108310 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1563 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/15/2014 12:00:00 AM 3     5986200.157869999 2104606.03112 37.7580497793679 -122.49078193256099 (37.7580497793679, -122.490781932561)
40381 250676 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 735 El Camino Del Mar 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986293.297259999 2114811.88275 37.786077611448 -122.49121092176 (37.786077611448, -122.49121092176)
178867 250677 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 735 El Camino Del Mar 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5986302.66224 2114812.53014 37.78607993617911 -122.49117856955 (37.7860799361791, -122.49117856955)
155038 119498 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 811 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5986314.77262 2110365.9929400003 37.773871723515 -122.49080937068999 (37.773871723515, -122.49080937069)
185212 119495 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 831 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5986317.41656 2110242.64878 37.773533209765795 -122.49079114745199 (37.7735332097658, -122.490791147452)
129882 95990 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 734 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2011 12:00:00 AM 2 3x3 Permit Number 767642 5986340.19492 2110900.5686 37.7753410020486 -122.490760773635 (37.7753410020486, -122.490760773635)
165506 95992 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 858 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2011 12:00:00 AM 2 3x3 Permit Number 767644 5986371.40114 2110056.12968 37.7730242344515 -122.490590683906 (37.7730242344515, -122.490590683906)
166433 250875 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 30th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986467.14332 2114671.0752 37.7857011507179 -122.490599105783 (37.7857011507179, -122.490599105783)
86942 95442 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2536 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/03/2011 12:00:00 AM   3x3 Permit Number 767304 5986467.3 2097980.9 37.7398745611118 -122.489370926882 (37.7398745611118, -122.489370926882)
71891 250874 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5986467.3841 2114682.3933599996 37.7857322411853 -122.490599105779 (37.7857322411853, -122.490599105779)
56077 250876 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 30th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986468.29527 2114661.08637 37.7856737915584 -122.490594385245 (37.7856737915584, -122.490594385245)
180995 250869 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 133 30th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986468.30668 2114640.25117 37.785616584774104 -122.490592812307 (37.7856165847741, -122.490592812307)
132130 250868 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 133 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986468.4993 2114649.30576 37.7856414573183 -122.490592812321 (37.7856414573183, -122.490592812321)
166651 250870 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 133 30th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986470.3680300005 2114630.24299 37.7855892256034 -122.490584944137 (37.7855892256034, -122.490584944137)
172196 35478 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 524 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/18/1998 12:00:00 AM 6   Permit Number 38890 5986598.81458 2112347.1481 37.779328002919705 -122.489972580124 (37.7793280029197, -122.489972580124)
128801 95991 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 741 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2011 12:00:00 AM   3x3 Permit Number 767643 5986614.1 2110873.8 37.7752834997455 -122.48981131617901 (37.7752834997455, -122.489811316179)
57185 119537 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 871 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5986635.90405 2110003.72423 37.772895790248 -122.489671893334 (37.772895790248, -122.489671893334)
71320 119536 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 871 30th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5986636.85825 2109986.6532900003 37.772848973963 -122.489667337074 (37.772848973963, -122.489667337074)
83350 87229 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2575X Judah St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/14/2007 12:00:00 AM   3x3 Permit Number 50266 5986663.0 2105714.0 37.7611189843543 -122.4892627097 (37.7611189843543, -122.4892627097)
92397 87232 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2575X Judah St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/14/2007 12:00:00 AM   3x3 Permit Number 50266 5986663.0 2105714.0 37.7611189843543 -122.4892627097 (37.7611189843543, -122.4892627097)
97753 87227 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2575X Judah St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/14/2007 12:00:00 AM   3x3 Permit Number 50266 5986663.0 2105714.0 37.7611189843543 -122.4892627097 (37.7611189843543, -122.4892627097)
99097 87228 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2575X Judah St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/14/2007 12:00:00 AM   3x3 Permit Number 50266 5986663.0 2105714.0 37.7611189843543 -122.4892627097 (37.7611189843543, -122.4892627097)
70024 250882 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 154 29th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   5986822.39512 2114740.35297 37.7859121118945 -122.48937514824699 (37.7859121118945, -122.489375148247)
172451 250881 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 154 29th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5986823.250630001 2114733.9114599996 37.78589447530229 -122.489371714655 (37.7858944753023, -122.489371714655)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 2017.292ms · Data source: data.sfgov.org