Street_Tree_List

Data source: data.sfgov.org

351 rows where qLegalStatus = 3 and qSpecies = 18

View and edit SQL

qLegalStatus

  • DPW Maintained · 251
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
77667 4142 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3615-3623X Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 3 3X3   6005538.0 2100417.0 37.747658358497404 -122.423605504909 (37.7476583584974, -122.423605504909)
77709 91916 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1555 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5990949.753071 2106534.898314 37.763622247809295 -122.47449673434299 (37.7636222478093, -122.474496734343)
78561 14625 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 15 Matthew Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/12/1998 12:00:00 AM 12 3X4   6017974.7726653 2094204.2737729999 37.7312936151853 -122.380167719121 (37.7312936151853, -122.380167719121)
79188 103042 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 450X Octavia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6005621.8 2110912.7 37.7764818047314 -122.424062011758 (37.7764818047314, -122.424062011758)
79576 89676 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2543 Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/07/2008 12:00:00 AM 3 3x3   5990695.40247 2111954.91498 37.778489399756204 -122.47577226813999 (37.7784893997562, -122.47577226814)
79666 86376 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1343 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/2006 12:00:00 AM 3 3x3   5988009.291975 2106160.192246 37.7624226008214 -122.484639253233 (37.7624226008214, -122.484639253233)
79774 84648 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 301X 29th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/21/2006 12:00:00 AM 10 3x3   6004302.0 2098976.0 37.7436318598049 -122.427776865938 (37.7436318598049, -122.427776865938)
80455 91941 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 925 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5992928.667696 2106602.6844200003 37.7639228286278 -122.467657278128 (37.7639228286278, -122.467657278128)
80485 23868 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1495X Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/30/2011 12:00:00 AM 3 3X3   6003590.023580001 2113875.44534 37.7845018426272 -122.43130203900499 (37.7845018426272, -122.431302039005)
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)
80642 26729 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 710 Lombard St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6008944.94841 2120470.5671200003 37.8029124483908 -122.413242294464 (37.8029124483908, -122.413242294464)
80739 86034 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1284 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987415.003943 2106546.656914 37.763449099217404 -122.486723028948 (37.7634490992174, -122.486723028948)
81177 91970 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1350 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993350.61101 2106290.929173 37.763091183898 -122.466175257659 (37.763091183898, -122.466175257659)
81351 85991 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2222 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987633.933236 2100153.700526 37.7459085303186 -122.48549665823 (37.7459085303186, -122.48549665823)
81410 85988 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2258 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987642.054438 2099919.450203 37.7452658143921 -122.48545138958299 (37.7452658143921, -122.485451389583)
81475 91983 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1239 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993284.406043 2107051.954484 37.7651769393996 -122.46645955171999 (37.7651769393996, -122.46645955172)
81586 85943 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1538 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988095.160504 2104827.59989 37.7587686653948 -122.484244534442 (37.7587686653948, -122.484244534442)
82005 52014 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 301X 29th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/12/2005 12:00:00 AM 9 3x3 Permit Number 48233 6004302.0 2098976.0 37.7436318598049 -122.427776865938 (37.7436318598049, -122.427776865938)
82021 104249 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 8 Octavia St Frontage East 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533)
82772 85934 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1630 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988116.725594 2104200.7569 37.7570487799795 -122.484123984508 (37.7570487799795, -122.484123984508)
83265 91984 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1243 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993285.31415 2107025.55813 37.7651045143653 -122.466454492146 (37.7651045143653, -122.466454492146)
83473 14411 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2001X Mason St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/13/2001 12:00:00 AM 6 3X3   6009024.63169 2120105.21371 37.801913752234704 -122.41294070113399 (37.8019137522347, -122.412940701134)
83935 91902 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1516 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991061.448475 2106578.7477680002 37.7637491175921 -122.474113618488 (37.7637491175921, -122.474113618488)
84020 85942 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1542 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988096.057532 2104801.525596 37.758697124688894 -122.48423951990299 (37.7586971246889, -122.484239519903)
84264 91966 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1376 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993356.433228 2106121.691358 37.76262683713129 -122.466142821616 (37.7626268371313, -122.466142821616)
84503 86007 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1742 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987522.322672 2103422.5340299997 37.7548773659795 -122.48612250342899 (37.7548773659795, -122.486122503429)
84609 91947 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 827 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5993232.703908999 2106613.098951 37.7639689741056 -122.466606473793 (37.7639689741056, -122.466606473793)
84650 85958 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1300 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/21/2006 12:00:00 AM 3 3x3   5988039.866297 2106434.861495 37.7631785479619 -122.48455365718 (37.7631785479619, -122.48455365718)
84697 91953 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 701 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/11/2014 12:00:00 AM 3 3x3   5993618.512619 2106626.3144610003 37.7640275170127 -122.465273046982 (37.7640275170127, -122.465273046982)
84875 4071 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3148 Cesar Chavez St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 4X4   6008736.4549488 2100618.4445096003 37.748391502035204 -122.41255962658701 (37.7483915020352, -122.412559626587)
84968 86321 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1723 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/12/2006 12:00:00 AM 3 3x3   5988408.134093 2103583.601964 37.7553712008265 -122.483070961912 (37.7553712008265, -122.483070961912)
85319 4145 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3615-3623X Cesar Chavez St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 3 3X3   6005538.0 2100417.0 37.747658358497404 -122.423605504909 (37.7476583584974, -122.423605504909)
85360 91951 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 751 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5993470.629208 2106621.248866 37.764005078882796 -122.46578415986299 (37.7640050788828, -122.465784159863)
86154 91926 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1401 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991435.018606 2106551.520732 37.7636959924857 -122.472819581527 (37.7636959924857, -122.472819581527)
86457 91921 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1437 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991322.7803879995 2106547.676066 37.763678937950296 -122.473207494478 (37.7636789379503, -122.473207494478)
86947 91880 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 840 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/11/2008 12:00:00 AM 3 3x3   5993189.659614 2106651.6479599997 37.7640723354625 -122.466758152363 (37.7640723354625, -122.466758152363)
87057 4219 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3957 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/06/1995 12:00:00 AM 3 3X3   6004180.2435918 2100406.5432146 37.7475529128468 -122.428299805317 (37.7475529128468, -122.428299805317)
87144 91948 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 823 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5993244.611031 2106613.506821 37.763970781134795 -122.466565320592 (37.7639707811348, -122.466565320592)
87590 91928 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1201X IRVING ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 2 3x3   5992070.0 2106573.0 37.7637917074669 -122.470624962715 (37.7637917074669, -122.470624962715)
88045 91918 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1523 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991044.965492 2106538.159703 37.7636367187828 -122.474167665735 (37.7636367187828, -122.474167665735)
88119 86581 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2547 27th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/05/2007 12:00:00 AM 3 3x3   5987979.82634 2097967.749244 37.7399266315394 -122.48414034443701 (37.7399266315394, -122.484140344437)
88204 14623 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Matthew Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/12/1998 12:00:00 AM 6 3X4   6018016.8978124 2094239.2837711999 37.7313920698281 -122.38002451510201 (37.7313920698281, -122.380024515102)
88615 100034 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1199@Washington Mason St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
88698 85946 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1490 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988083.436249 2105168.393711 37.7597037099979 -122.48431007589701 (37.7597037099979, -122.484310075897)
88699 86200 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2379 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/19/2007 12:00:00 AM 3 3x3   5988870.37374 2099150.307919 37.743225438056605 -122.481147807758 (37.7432254380566, -122.481147807758)
88891 91942 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 917 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5992952.377119999 2106603.496565 37.76392642748271 -122.467575334102 (37.7639264274827, -122.467575334102)
88917 91030 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1086 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/18/2008 12:00:00 AM 3 3x3   6009941.213427 2111462.810786 37.778235204322904 -122.409158690819 (37.7782352043229, -122.409158690819)
89505 91955 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 621 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5993869.320819 2106634.905708 37.7640655668897 -122.46440620597299 (37.7640655668897, -122.464406205973)
89595 91974 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1332 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993346.580243 2106408.0938330004 37.7634126547611 -122.466197713623 (37.7634126547611, -122.466197713623)
90041 23487 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2500X Van Ness Ave 2 Median : Cutout 11 Tree 1 DPW 2   01/25/2008 12:00:00 AM 3 9   6005837.0202043 2118942.4447679003 37.79854163961021 -122.42388861727899 (37.7985416396102, -122.423888617279)
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)
90605 104256 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 8X Octavia St Frontage East 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533)
91229 86519 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1309 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/26/2006 12:00:00 AM 3 3x3   5987691.436672 2106370.804533 37.7629823684162 -122.485754041828 (37.7629823684162, -122.485754041828)
91240 91969 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1360 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993352.850325 2106225.837693 37.7629125889584 -122.466162782208 (37.7629125889584, -122.466162782208)
91526 91971 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1342 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993348.819558 2106343.002353 37.7632340598338 -122.46618523806299 (37.7632340598338, -122.466185238063)
92143 21664 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1759 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 4X4   6004187.7527688 2114598.9985399 37.786522394554794 -122.429285712666 (37.7865223945548, -122.429285712666)
92706 4122 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3435 Cesar Chavez St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 6 3X3   6006760.09222 2100373.98133 37.7476091457032 -122.419376518884 (37.7476091457032, -122.419376518884)
92878 91982 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1231 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993282.58983 2107104.747155 37.7653217893633 -122.466469670891 (37.7653217893633, -122.466469670891)
93715 91891 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1134 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5992278.307636 2106620.430357 37.7639339819744 -122.469907950407 (37.7639339819744, -122.469907950407)
93800 22521 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 6600 03rd St 1 Median : Cutout 11 Tree 1 DPW 2   02/20/1992 12:00:00 AM 3 3X3   6012847.5284056 2089784.7633558998 37.7188743244909 -122.39758380657601 (37.7188743244909, -122.397583806576)
94130 91875 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 700 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/10/2008 12:00:00 AM 3 3x3   5993617.143263 2106666.291015 37.764137203180205 -122.465280687147 (37.7641372031802, -122.465280687147)
94183 91967 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1372 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993355.537502999 2106147.727912 37.7626982750081 -122.46614781174499 (37.7626982750081, -122.466147811745)
94546 86392 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1579 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2006 12:00:00 AM 3 3x3   5988064.154428 2104565.481775 37.758047154773294 -122.48433254224199 (37.7580471547733, -122.484332542242)
94987 91968 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1368 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993354.641776999 2106173.764513 37.762769713012794 -122.46615280188999 (37.7627697130128, -122.46615280189)
95273 4120 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3435 Cesar Chavez St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 6 3X3   6006760.09222 2100373.98133 37.7476091457032 -122.419376518884 (37.7476091457032, -122.419376518884)
95889 9346 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 217 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/1999 12:00:00 AM 20 2X2   6000803.9441694 2098478.3891844 37.742067037249 -122.43983659070601 (37.742067037249, -122.439836590706)
95984 103790 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 99X Fern St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/2009 12:00:00 AM 3 3x3   6007061.73741 2115197.31568 37.788327510680205 -122.41938487643999 (37.7883275106802, -122.41938487644)
96954 91903 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1534 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991007.891482 2106576.913236 37.7637409778654 -122.47429871990299 (37.7637409778654, -122.474298719903)
97015 10703 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 130X Shields St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3x3   5993684.4832438 2089860.5757616002 37.717996809726 -122.46382786766 (37.717996809726, -122.46382786766)
97122 16435 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1299X Newcomb Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/27/2008 12:00:00 AM 3 3x3   6016431.7799349995 2094795.0104810002 37.7328304099415 -122.385543330143 (37.7328304099415, -122.385543330143)
97257 104250 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 8x Octavia St Frontage East 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533)
97673 91881 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 902 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/11/2008 12:00:00 AM 3 3x3   5992992.499251001 2106644.894373 37.7640424113715 -122.467439575398 (37.7640424113715, -122.467439575398)
97679 86443 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2450 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 12/29/2006 12:00:00 AM 3 3x3   5987997.37774 2098622.10748 37.741724349066 -122.484127634313 (37.741724349066, -122.484127634313)
97758 21655 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1700 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6004345.5648 2114673.53748 37.7867359926545 -122.42874503768101 (37.7867359926545, -122.428745037681)
97771 28352 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3170 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/02/2001 12:00:00 AM 3 3X3   6008602.0157948 2100617.8635816 37.748382361007295 -122.413024474721 (37.7483823610073, -122.413024474721)
97774 91977 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1310 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993341.653751 2106551.295076 37.763805563541204 -122.466225160061 (37.7638055635412, -122.466225160061)
98111 91929 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1201X IRVING ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/11/2014 12:00:00 AM 2 3x3   5992070.0 2106573.0 37.7637917074669 -122.470624962715 (37.7637917074669, -122.470624962715)
98625 91987 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1327 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/2009 12:00:00 AM 3 3x3   5993305.2603050005 2106445.773422 37.7635137289504 -122.466343363346 (37.7635137289504, -122.466343363346)
98643 86320 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1701 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/12/2006 12:00:00 AM 3 3x3   5988402.93355 2103727.2102369997 37.755765207864705 -122.483099472181 (37.7557652078647, -122.483099472181)
98877 4032 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2150 Cesar Chavez St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 3 3X3   6012617.955900401 2100994.1740901 37.749640248492604 -122.39916376626199 (37.7496402484926, -122.399163766262)
99034 106992 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1701X Post St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2012 12:00:00 AM       6004025.8 2114231.4 37.785503891427005 -122.42981979958701 (37.785503891427, -122.429819799587)
100006 86109 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2548 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/17/2007 12:00:00 AM 3 3x3   5988950.841471 2097988.149582 37.7400391325334 -122.480784510326 (37.7400391325334, -122.480784510326)
100303 86387 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1515 26th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/2006 12:00:00 AM 3 3x3   5988049.8019900005 2104982.6702779997 37.7591918054497 -122.4844127767 (37.7591918054497, -122.4844127767)
100305 103832 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98X Myrtle St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/2009 12:00:00 AM 3 3x3   6007204.7906599995 2114178.2136 37.7855373621017 -122.41881763042299 (37.7855373621017, -122.418817630423)
100587 91980 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1256 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993328.468873001 2106934.546237 37.7648571097371 -122.466298616883 (37.7648571097371, -122.466298616883)
100903 91931 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1199 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5992089.071506 2106573.92474 37.7637953493605 -122.470559068172 (37.7637953493605, -122.470559068172)
100962 91945 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 843 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5993185.075419 2106611.467471 37.763961745844895 -122.46677108658501 (37.7639617458449, -122.466771086585)
101052 4160 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3739 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/17/2003 12:00:00 AM 3 4X4   6005605.475964599 2100485.3064168 37.7478497208127 -122.42337703166099 (37.7478497208127, -122.423377031661)
101459 98790 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 950x CLAY ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     3x3 Permit Number 768771 6010160.0 2117472.0 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367)
101626 4147 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3555X Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 3 3X3   6005538.0 2100417.0 37.747658358497404 -122.423605504909 (37.7476583584974, -122.423605504909)
101983 16450 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1395 Newcomb Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6016285.996927 2094866.0167389999 37.733017311739104 -122.386052291775 (37.7330173117391, -122.386052291775)
102400 6398 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4X Matthew Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/13/1998 12:00:00 AM 12 3X3   6018041.9202743 2094226.9871977002 37.7313596862419 -122.379937152762 (37.7313596862419, -122.379937152762)
102711 91954 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 637 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5993821.680813 2106633.2738349997 37.7640583399586 -122.464570858995 (37.7640583399586, -122.464570858995)
103092 4069 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3120 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6008908.10494 2100619.1862301 37.7484031705039 -122.411966114964 (37.7484031705039, -122.411966114964)
103123 103040 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 450X Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6005621.8 2110912.7 37.7764818047314 -122.424062011758 (37.7764818047314, -122.424062011758)
103424 89679 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2531 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/07/2008 12:00:00 AM 3 3x3   5990763.229169999 2111957.72376 37.7785010440115 -122.47553783747601 (37.7785010440115, -122.475537837476)
103508 106991 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1701X Post St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2014 12:00:00 AM       6004025.8 2114231.4 37.785503891427005 -122.42981979958701 (37.785503891427, -122.429819799587)
103727 91901 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1500 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991109.054689 2106580.378462 37.7637563526576 -122.473949083869 (37.7637563526576, -122.473949083869)
103844 23488 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2500X Van Ness Ave 4 Median : Cutout 11 Tree 1 DPW 2   12/09/2004 12:00:00 AM 6 9   6005837.0202043 2118942.4447679003 37.79854163961021 -122.42388861727899 (37.7985416396102, -122.423888617279)
104440 91993 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1385 09th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/2009 12:00:00 AM 3 3x3   5993318.248331 2106068.242865 37.7624778784584 -122.46627100381201 (37.7624778784584, -122.466271003812)

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 73.988ms · Data source: data.sfgov.org