trees
4,014 rows where qSpecies_id = 40 sorted by Police Districts descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 632 | 23885 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1750X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6003231.6817 | 2113926.646 | 37.7846221123784 | -122.432545437068 | (37.7846221123784, -122.432545437068) | 13 | 9 | 11 | 29490 | 13 | |||
| 739 | 38480 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2515 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1998 12:00:00 AM | 9 | Permit Number 40479 | 5999797.20513 | 2119471.52027 | 37.7996515161494 | -122.444826245059 | (37.7996515161494, -122.444826245059) | 13 | 9 | 1 | 57 | 17 | ||
| 1115 | 238053 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 426 Lily St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6004459.53739 | 2109991.59452 | 37.7738869854343 | -122.428016956418 | (37.7738869854343, -122.428016956418) | 7 | 9 | 11 | 28852 | 10 | |||
| 3266 | 48394 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2520 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/23/2002 12:00:00 AM | 14 | Permit Number 45776 | 6002671.64848 | 2116160.62189 | 37.7907242663701 | -122.434642758376 | (37.7907242663701, -122.434642758376) | 13 | 9 | 1 | 29490 | 27 | |
| 3445 | 21666 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1765 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 4X4 | Permit Number 774582 | 6004178.5577 | 2114595.027 | 37.7865109691436 | -122.429317242018 | (37.7865109691436, -122.429317242018) | 13 | 9 | 11 | 29490 | 13 |
| 3867 | 33659 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 545 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 8 | Permit Number 37747 | 6004792.43502 | 2110705.04365 | 37.7758647708832 | -122.426916230306 | (37.7758647708832, -122.426916230306) | 7 | 9 | 11 | 28852 | 10 | |
| 3941 | 92078 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1151 Sutter St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2009 12:00:00 AM | 3x3 | Permit Number 52192 | 6007083 | 2115004 | 37.7877979108835 | -122.419297592258 | (37.7877979108835, -122.419297592258) | 13 | 9 | 10 | 28858 | 21 | |||
| 6608 | 47030 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 22 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45025 | 6005541.3 | 2109365.2 | 37.7722281991235 | -122.424230399247 | (37.7722281991235, -122.424230399247) | 7 | 9 | 11 | 28852 | 10 | ||
| 7488 | 21658 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1745 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004251.7833336 | 2114607.9002324 | 37.7865504610901 | -122.42906481766 | (37.7865504610901, -122.42906481766) | 13 | 9 | 11 | 29490 | 13 | |||
| 8391 | 238054 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 432 Lily St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004439.8336 | 2109989.04683 | 37.7738788753301 | -122.428084933487 | (37.7738788753301, -122.428084933487) | 7 | 9 | 11 | 28852 | 10 | |||
| 11026 | 53052 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2517@ SCOTT Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/2006 12:00:00 AM | 5 | Permit Number 49029 | 6001372.25817 | 2117256.0832 | 37.7936582667653 | -122.439217122188 | (37.7936582667653, -122.439217122188) | 13 | 9 | 1 | 29490 | 27 | |
| 11792 | 135925 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2725 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5999832.27617 | 2118786.40209 | 37.7977723656638 | -122.444655616678 | (37.7977723656638, -122.444655616678) | 13 | 9 | 1 | 57 | 17 | |||
| 13432 | 48426 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3130 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | 9 | Permit Number 45804 | 6001942.58238 | 2118964.92546 | 37.7983827391207 | -122.437366176208 | (37.7983827391207, -122.437366176208) | 13 | 9 | 1 | 57 | 17 | |
| 15012 | 114856 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1416x Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2016 12:00:00 AM | 3 | 3x3 | 6006677.76742 | 2115342.38606 | 37.7887042046809 | -122.420723655192 | (37.7887042046809, -122.420723655192) | 13 | 9 | 10 | 28858 | 21 | ||
| 17129 | 33142 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3148 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 8 | Permit Number 37368 | 6001934.81136 | 2119023.66644 | 37.7985435846779 | -122.437397274777 | (37.7985435846779, -122.437397274777) | 13 | 9 | 1 | 57 | 17 | |
| 17260 | 57706 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 268 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52597 | 6003986.30319774 | 2108724.10323801 | 37.7703799791966 | -122.429563538214 | (37.7703799791966, -122.429563538214) | 7 | 9 | 11 | 29492 | 10 | ||
| 18199 | 254500 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1715 Octavia St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769839 | 6004851.87126 | 2115244.61878 | 37.7883326812086 | -122.427034026756 | (37.7883326812086, -122.427034026756) | 13 | 9 | 11 | 28858 | 27 | |
| 18621 | 238048 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400 Lily St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6004553.97154 | 2110004.04883 | 37.7739265241283 | -122.427691180609 | (37.7739265241283, -122.427691180609) | 7 | 9 | 11 | 28852 | 10 | |||
| 20779 | 103766 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101X Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006706.11036 | 2115484.69473 | 37.7890965465282 | -122.420635698799 | (37.7890965465282, -122.420635698799) | 13 | 9 | 10 | 28858 | 21 | ||
| 21136 | 46595 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2480 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | 3 | Permit Number 45794 | 6001119.43156 | 2118662.96193 | 37.7975067967595 | -122.440192856927 | (37.7975067967595, -122.440192856927) | 13 | 9 | 1 | 57 | 17 | |
| 22117 | 238046 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400 Lily St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6004578.89431 | 2110007.96592 | 37.7739386892479 | -122.427605247709 | (37.7739386892479, -122.427605247709) | 7 | 9 | 11 | 28852 | 10 | |||
| 22969 | 103049 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400X Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005072 | 2110257 | 37.7746503556504 | -122.425917242315 | (37.7746503556504, -122.425917242315) | 7 | 9 | 11 | 28852 | 10 | |||
| 23030 | 135979 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.63841 | 2115164.21663 | 37.7882275541095 | -122.419939904112 | (37.7882275541095, -122.419939904112) | 13 | 9 | 10 | 28858 | 21 | ||
| 23777 | 88528 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 771 14th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51478 | 6003493 | 2107743 | 37.7676581652647 | -122.431199833454 | (37.7676581652647, -122.431199833454) | 15 | 9 | 5 | 28862 | 3 | |||
| 23842 | 103777 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
| 23937 | 48415 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2475 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | 8 | Permit Number 45793 | 6001140.73556 | 2118622.32163 | 37.7973964220563 | -122.440116223893 | (37.7973964220563, -122.440116223893) | 13 | 9 | 1 | 57 | 17 | |
| 24376 | 237016 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 401 Lily St | 6 | : | Tree | Private 2 | 10 | Width 2ft | 6004555.22046 | 2109981.30616 | 37.773864148951 | -122.42768523968 | (37.773864148951, -122.42768523968) | 7 | 9 | 11 | 28852 | 10 | |||
| 24571 | 29668 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2500 Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 12/09/2004 12:00:00 AM | 6 | 6005837.0202043 | 2118942.4447679 | 37.7985416396102 | -122.423888617279 | (37.7985416396102, -122.423888617279) | 13 | 9 | 10 | 28858 | 32 | |||
| 24698 | 8097 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 762 Fulton St | 8 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004143.8911021 | 2111521.3201229 | 37.7780693729621 | -122.4292179278 | (37.7780693729621, -122.4292179278) | 7 | 9 | 11 | 28852 | 41 | ||
| 25013 | 93220 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1675 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2010 12:00:00 AM | 3x3 | Permit Number 53212 | 6004290 | 2108739 | 37.7704380729677 | -122.42851411253 | (37.7704380729677, -122.42851411253) | 7 | 9 | 5 | 29492 | 10 | ||
| 25934 | 135966 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2610 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6001187.63413 | 2117406.94715 | 37.7940619922234 | -122.439866757361 | (37.7940619922234, -122.439866757361) | 13 | 9 | 1 | 57 | 27 | |||
| 28084 | 103765 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101X Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006551.29204 | 2115477.084 | 37.7890669227742 | -122.42117081077 | (37.7890669227742, -122.42117081077) | 13 | 9 | 10 | 28858 | 21 | ||
| 28308 | 237185 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 78 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004315.99922 | 2108931.71426 | 37.7709686907843 | -122.428437919182 | (37.7709686907843, -122.428437919182) | 7 | 9 | 11 | 28852 | 10 | |||
| 29810 | 51964 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 624 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/2005 12:00:00 AM | Permit Number 48186 | 6004986.46742486 | 2111098.21623731 | 37.7769552960255 | -122.426273020817 | (37.7769552960255, -122.426273020817) | 7 | 9 | 11 | 28852 | 10 | ||
| 30730 | 96024 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 668 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 0 | 3x3 | Permit Number 767665 | 6007552 | 2113596 | 37.78395828879 | -122.41757510582 | (37.78395828879, -122.41757510582) | 7 | 9 | 9 | 28858 | 36 |
| 31223 | 108693 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950X Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774617 | 6001046.33677 | 2120996.58295 | 37.8039101397338 | -122.440613252117 | (37.8039101397338, -122.440613252117) | 13 | 9 | 1 | 57 | 17 |
| 31840 | 103051 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400X Octavia St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6005072 | 2110257 | 37.7746503556504 | -122.425917242315 | (37.7746503556504, -122.425917242315) | 7 | 9 | 11 | 28852 | 10 | |||
| 31877 | 96029 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 730 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767669 | 6007514.32648 | 2113867.32169 | 37.78470115228 | -122.417724680544 | (37.78470115228, -122.417724680544) | 7 | 9 | 9 | 28858 | 36 |
| 31944 | 94585 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2725 Greenwich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2010 12:00:00 AM | 3x3 | Permit Number 53761 | 5999865 | 2118793 | 37.7977923490456 | -122.444542858 | (37.7977923490456, -122.444542858) | 13 | 9 | 1 | 57 | 17 | |||
| 33713 | 64938 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2810 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1989 12:00:00 AM | 11 | Permit Number 25967 | 6004818.34721 | 2119246.75761 | 37.7993196438369 | -122.427435236266 | (37.7993196438369, -122.427435236266) | 13 | 9 | 1 | 57 | 17 | |
| 33834 | 238052 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 426 Lily St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6004475.89025 | 2109993.473 | 37.7738930684378 | -122.42796052306 | (37.7738930684378, -122.42796052306) | 7 | 9 | 11 | 28852 | 10 | |||
| 34659 | 135946 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 33 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001854.08706 | 2120729.80422 | 37.8032235999547 | -122.437798867946 | (37.8032235999547, -122.437798867946) | 13 | 9 | 1 | 57 | 17 | |||
| 35093 | 135973 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2118 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6003393.93756 | 2117943.36114 | 37.7956601891322 | -122.432271050962 | (37.7956601891322, -122.432271050962) | 13 | 9 | 1 | 57 | 17 | |||
| 35727 | 238050 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400 Lily St | 5 | : | Tree | Private 2 | 4 | Width 3ft | 6004531.27247 | 2110000.08562 | 37.7739143581026 | -122.427769418044 | (37.7739143581026, -122.427769418044) | 7 | 9 | 11 | 28852 | 10 | |||
| 35793 | 7950 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1735 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3 | 3X3 | 6005696.54994 | 2116082.67925 | 37.7906815134801 | -122.424171198144 | (37.7906815134801, -122.424171198144) | 13 | 9 | 1 | 28858 | 27 | ||
| 36730 | 88755 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 990 Polk St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
| 36796 | 30881 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 59 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | 1 | Permit Number 34714 | 6004013.78951 | 2108865.19521 | 37.7707689396642 | -122.429478526513 | (37.7707689396642, -122.429478526513) | 7 | 9 | 11 | 29492 | 10 | ||
| 38841 | 48912 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1930 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2002 12:00:00 AM | 2 | 3x3 | Permit Number 46107 | 6004309.09705 | 2118070.5094 | 37.7960611527628 | -122.429113506091 | (37.7960611527628, -122.429113506091) | 13 | 9 | 1 | 57 | 17 |
| 39361 | 82980 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 535-537 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52398 | 6004842.87299878 | 2110699.22399126 | 37.7758516433121 | -122.426741337783 | (37.7758516433121, -122.426741337783) | 7 | 9 | 11 | 28852 | 10 | ||
| 39510 | 41180 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1780 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | 3 | Permit Number 41899 | 6001541.153 | 2121088.1531 | 37.804189731738 | -122.438907479297 | (37.804189731738, -122.438907479297) | 13 | 9 | 1 | 57 | 17 | |
| 39680 | 237014 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 401 Lily St | 4 | : | Tree | Private 2 | 5 | Width 2ft | 6004527.81122 | 2109977.01256 | 37.7738508093129 | -122.427779746755 | (37.7738508093129, -122.427779746755) | 7 | 9 | 11 | 28852 | 10 | |||
| 40378 | 135957 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2961 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5999402.43366 | 2117332.15593 | 37.7937548548653 | -122.446038331519 | (37.7937548548653, -122.446038331519) | 13 | 9 | 1 | 57 | 27 | |||
| 40450 | 238405 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 25 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003809.56512 | 2108171.76515 | 37.7688533845966 | -122.430135465991 | (37.7688533845966, -122.430135465991) | 7 | 9 | 5 | 28862 | 3 | |||
| 40675 | 47009 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 463 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45007 | 6003641.69340393 | 2109907.77842423 | 37.7736105432433 | -122.430840029306 | (37.7736105432433, -122.430840029306) | 15 | 9 | 11 | 29492 | 10 | ||
| 41061 | 88754 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 990 Polk St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
| 41478 | 238404 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 91 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003826.96845 | 2107845.69213 | 37.7679590529034 | -122.430052005311 | (37.7679590529034, -122.430052005311) | 7 | 9 | 5 | 28862 | 3 | |||
| 42345 | 135983 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 664 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6007541.15354 | 2113647.81181 | 37.7840999411125 | -122.417616304154 | (37.7840999411125, -122.417616304154) | 7 | 9 | 9 | 28858 | 36 | |||
| 43530 | 135968 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2831 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002535.74001 | 2117875.30124 | 37.7954246171123 | -122.435235693088 | (37.7954246171123, -122.435235693088) | 13 | 9 | 1 | 57 | 17 | |||
| 43969 | 135922 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2440 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001259.6305 | 2118684.30492 | 37.7975733798607 | -122.439709263576 | (37.7975733798607, -122.439709263576) | 13 | 9 | 1 | 57 | 17 | |||
| 46076 | 65441 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 625 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51040 | 6007520.81272 | 2113468.90286 | 37.7836075559752 | -122.417673991168 | (37.7836075559752, -122.417673991168) | 7 | 9 | 9 | 28858 | 36 | |
| 46712 | 96028 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 730 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767669 | 6007516.24853 | 2113853.8784 | 37.7846643484356 | -122.417717077682 | (37.7846643484356, -122.417717077682) | 7 | 9 | 9 | 28858 | 36 |
| 47096 | 69243 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2021 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/1994 12:00:00 AM | 16 | Permit Number 33307 | 6003282.73155 | 2118223.78108 | 37.7964238439467 | -122.432675884388 | (37.7964238439467, -122.432675884388) | 13 | 9 | 1 | 57 | 17 | ||
| 48274 | 103042 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 450X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005621.8 | 2110912.7 | 37.7764818047314 | -122.424062011758 | (37.7764818047314, -122.424062011758) | 7 | 9 | 11 | 28852 | 10 | |||
| 48711 | 135971 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2300 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002511.97848 | 2117816.96734 | 37.7952630979691 | -122.435313737159 | (37.7952630979691, -122.435313737159) | 13 | 9 | 1 | 57 | 17 | |||
| 48761 | 135923 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 299 Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001988.80401 | 2118923.8728 | 37.7982726468322 | -122.437203294605 | (37.7982726468322, -122.437203294605) | 13 | 9 | 1 | 57 | 17 | |||
| 49196 | 238049 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400 Lily St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6004542.42912 | 2110001.70207 | 37.7739194275845 | -122.427730940528 | (37.7739194275845, -122.427730940528) | 7 | 9 | 11 | 28852 | 10 | |||
| 49777 | 47033 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 22 Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45025 | 6005541.3 | 2109365.2 | 37.7722281991235 | -122.424230399247 | (37.7722281991235, -122.424230399247) | 7 | 9 | 11 | 28852 | 10 | ||
| 50233 | 237038 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Octavia St | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6005608.42983 | 2109742.33589 | 37.773267513529 | -122.424025015163 | (37.773267513529, -122.424025015163) | 7 | 9 | 11 | 28852 | 10 | |||
| 50320 | 28085 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2255 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6002770.4091 | 2114749.1272 | 37.7868542683748 | -122.434200102392 | (37.7868542683748, -122.434200102392) | 13 | 9 | 11 | 29490 | 27 | |||
| 50672 | 238483 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 103 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 13 | Width 3ft | Permit Number 37768 | 6003709.01097 | 2108821.61027 | 37.7706320052989 | -122.430529650538 | (37.7706320052989, -122.430529650538) | 15 | 9 | 11 | 29492 | 10 | |
| 51110 | 49515 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2360@ FILLMORE Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2003 12:00:00 AM | 4 | Permit Number 46421 | 6002343.25635 | 2117445.35992 | 37.7942331772802 | -122.435870940009 | (37.7942331772802, -122.435870940009) | 13 | 9 | 1 | 29490 | 27 | ||
| 53836 | 117560 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2304 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 4x4 | Permit Number 778613 | 6002499.39832 | 2117814.1104 | 37.7952545391263 | -122.435357062003 | (37.7952545391263, -122.435357062003) | 13 | 9 | 1 | 57 | 17 | |
| 54306 | 237027 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Octavia St | 8 | : | Tree | Private 2 | 5 | Width 6ft | 6005758.33223 | 2109504.65873 | 37.7726233714135 | -122.423489581302 | (37.7726233714135, -122.423489581302) | 7 | 9 | 11 | 28852 | 10 | |||
| 54600 | 82096 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1363 Francisco St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52338 | 6004802.97001971 | 2120513.88344233 | 37.8027979755173 | -122.427578771479 | (37.8027979755173, -122.427578771479) | 13 | 9 | 1 | 57 | 17 | ||
| 54764 | 237017 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 401 Lily St | 7 | : | Tree | Private 2 | 8 | Width 2ft | 6004569.305 | 2109982.95925 | 37.7738694846242 | -122.427636636743 | (37.7738694846242, -122.427636636743) | 7 | 9 | 11 | 28852 | 10 | |||
| 54770 | 237029 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Octavia St | 10 | : | Tree | Private 2 | 3 | Width 6ft | 6005753.2097 | 2109536.23847 | 37.7727097926437 | -122.423509546241 | (37.7727097926437, -122.423509546241) | 7 | 9 | 11 | 28852 | 10 | |||
| 55163 | 238478 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 46 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004072.80326 | 2108893.58954 | 37.7708502446648 | -122.429276421875 | (37.7708502446648, -122.429276421875) | 7 | 9 | 11 | 29492 | 10 | |||
| 55373 | 23868 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1495X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2011 12:00:00 AM | 3 | 3X3 | 6003590.02358 | 2113875.44534 | 37.7845018426272 | -122.431302039005 | (37.7845018426272, -122.431302039005) | 13 | 9 | 11 | 29490 | 41 | ||
| 55599 | 238475 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 381 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003837.74726 | 2108996.21108 | 37.7711187084898 | -122.430096807715 | (37.7711187084898, -122.430096807715) | 7 | 9 | 11 | 29492 | 10 | |||
| 55857 | 237026 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Octavia St | 7 | : | Tree | Private 2 | 3 | Width 6ft | 6005759.75569 | 2109493.68206 | 37.7725933124646 | -122.423483876889 | (37.7725933124646, -122.423483876889) | 7 | 9 | 11 | 28852 | 10 | |||
| 55987 | 238471 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003403.57137 | 2108474.9085 | 37.7696627393757 | -122.431561413932 | (37.7696627393757, -122.431561413932) | 15 | 9 | 5 | 29492 | 10 | |||
| 56041 | 135948 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 31 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001895.29837 | 2120693.9243 | 37.8031274264634 | -122.437653684066 | (37.8031274264634, -122.437653684066) | 13 | 9 | 1 | 57 | 17 | |||
| 56781 | 135965 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2574 Broadway | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6001290.6793 | 2117307.18376 | 37.7937939330834 | -122.439503056242 | (37.7937939330834, -122.439503056242) | 13 | 9 | 1 | 57 | 27 | |||
| 57994 | 135928 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1960 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000881.44205 | 2120995.2314 | 37.8038970374844 | -122.441183782119 | (37.8038970374844, -122.441183782119) | 13 | 9 | 1 | 57 | 17 | |||
| 58099 | 135920 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2495 Filbert St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001110.69798 | 2118617.54309 | 37.7973815913536 | -122.440219818601 | (37.7973815913536, -122.440219818601) | 13 | 9 | 1 | 57 | 17 | |||
| 58549 | 135919 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2355 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001720.67059 | 2118356.50999 | 37.7966995715863 | -122.438090451527 | (37.7966995715863, -122.438090451527) | 13 | 9 | 1 | 57 | 17 | |||
| 58600 | 2451 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1805X Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6003959.520066 | 2114567.2690482 | 37.7864223498862 | -122.430073076908 | (37.7864223498862, -122.430073076908) | 13 | 9 | 11 | 29490 | 13 | |||
| 59393 | 50792 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2740 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 47317 | 5999864.3976 | 2118141.20218 | 37.7960026509676 | -122.444498073449 | (37.7960026509676, -122.444498073449) | 13 | 9 | 1 | 57 | 17 | |||
| 60351 | 135978 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006877.42 | 2115159.3392 | 37.7882128537759 | -122.420019889812 | (37.7882128537759, -122.420019889812) | 13 | 9 | 10 | 28858 | 21 | ||
| 60607 | 103806 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Hemlock St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006930.58351 | 2114841.83487 | 37.7873440601297 | -122.419813414468 | (37.7873440601297, -122.419813414468) | 13 | 9 | 10 | 28858 | 21 | ||
| 61126 | 88757 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 990 Polk St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
| 61675 | 135990 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90 Myrtle St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6007019.38816 | 2114166.03312 | 37.7854934765818 | -122.419458205643 | (37.7854934765818, -122.419458205643) | 13 | 9 | 9 | 28858 | 36 | |||
| 61691 | 135987 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90 Myrtle St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6007069.18975 | 2114172.43083 | 37.7855138480361 | -122.419286360472 | (37.7855138480361, -122.419286360472) | 13 | 9 | 9 | 28858 | 36 | |||
| 61739 | 238469 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 434 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003617.97734 | 2109021.69866 | 37.7711762417126 | -122.430858818585 | (37.7711762417126, -122.430858818585) | 15 | 9 | 11 | 29492 | 10 | |||
| 61746 | 103815 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Hemlock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006959.84507 | 2114826.77891 | 37.7873043685578 | -122.419711106691 | (37.7873043685578, -122.419711106691) | 13 | 9 | 10 | 28858 | 21 | ||
| 62220 | 238479 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 82 Germania St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003859.40004 | 2108866.56108 | 37.7707639475293 | -122.43001265998 | (37.7707639475293, -122.43001265998) | 7 | 9 | 11 | 29492 | 10 | |||
| 62335 | 135977 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2065 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6003684.73578 | 2117929.31477 | 37.7956381053729 | -122.431263834562 | (37.7956381053729, -122.431263834562) | 13 | 9 | 1 | 29490 | 27 | |||
| 63425 | 103785 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 103X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006767.43674 | 2115144.46398 | 37.7881658129506 | -122.420399357843 | (37.7881658129506, -122.420399357843) | 13 | 9 | 10 | 28858 | 21 | ||
| 66320 | 65288 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 41 Rico Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1990 12:00:00 AM | 7 | Permit Number 28836 | 6001457.59323 | 2121333.88235 | 37.8048596843835 | -122.439214266819 | (37.8048596843835, -122.439214266819) | 13 | 9 | 1 | 57 | 17 | |
| 66327 | 238470 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003405.92625 | 2108464.16893 | 37.7696333846125 | -122.431552501661 | (37.7696333846125, -122.431552501661) | 15 | 9 | 5 | 29492 | 10 |
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) );