trees
4,014 rows where qSpecies_id = 40 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101856 | 218135 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 0 Noriega St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5992409.03176 | 2103467.31015 | 37.7552838973381 | -122.469226308173 | (37.7552838973381, -122.469226308173) | 1 | 8 | 4 | 56 | 12 | |||
| 42066 | 237057 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Albion St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6005792.84324 | 2107206.95019 | 37.7663163611242 | -122.423206846131 | (37.7663163611242, -122.423206846131) | 8 | 4 | 5 | 28853 | 19 | |||
| 142977 | 237056 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Albion St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6005793.31637 | 2107190.9812 | 37.7662725407724 | -122.423204074428 | (37.7662725407724, -122.423204074428) | 8 | 4 | 5 | 28853 | 19 | |||
| 178354 | 237054 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6005797.63986 | 2107141.4188 | 37.7661366981867 | -122.423185596933 | (37.7661366981867, -122.423185596933) | 8 | 4 | 5 | 28853 | 19 | |||
| 181743 | 237055 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Albion St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6005794.81287 | 2107159.83009 | 37.7661870916781 | -122.423196683796 | (37.7661870916781, -122.423196683796) | 8 | 4 | 5 | 28853 | 19 | |||
| 177623 | 237100 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005826.47763 | 2105998.82514 | 37.7630010337862 | -122.423004634461 | (37.7630010337862, -122.423004634461) | 8 | 4 | 5 | 28859 | 19 | |||
| 189925 | 237101 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Dearborn St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005826.7194 | 2106021.63498 | 37.7630636778686 | -122.423005419568 | (37.7630636778686, -122.423005419568) | 8 | 4 | 5 | 28859 | 19 | |||
| 15257 | 258903 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Massasoit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100 | 2099291 | 37.7448230609493 | -122.407750909418 | (37.7448230609493, -122.407750909418) | 2 | 7 | 7 | 28859 | 2 | ||||
| 142295 | 196471 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Middle Point Rd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6018269.46967 | 2096338.3756 | 37.7371696942217 | -122.379297066815 | (37.7371696942217, -122.379297066815) | 10 | 3 | 8 | 58 | 1 | |||
| 181549 | 237163 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Norwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009249.65239 | 2099454.99726 | 37.7452257212815 | -122.410702842362 | (37.7452257212815, -122.410702842362) | 2 | 7 | 7 | 28859 | 2 | |||
| 111271 | 213482 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Sola Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994974.83822 | 2100674.05314 | 37.7477622510295 | -122.460150689121 | (37.7477622510295, -122.460150689121) | 1 | 8 | 4 | 29491 | 40 | |||
| 183523 | 238521 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6002789.51517 | 2096155.18282 | 37.7358008721014 | -122.432805194307 | (37.7358008721014, -122.432805194307) | 2 | 7 | 5 | 63 | 7 | |||
| 81175 | 213652 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 10 Edgehill Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994842.29481 | 2099078.88139 | 37.7433746845052 | -122.460493444131 | (37.7433746845052, -122.460493444131) | 1 | 8 | 4 | 59 | 40 | |||
| 143652 | 213654 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 10 Edgehill Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5994824.07884 | 2099066.74247 | 37.7433403061049 | -122.460555550413 | (37.7433403061049, -122.460555550413) | 1 | 8 | 4 | 59 | 40 | |||
| 164635 | 213651 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 10 Edgehill Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5994859.86261 | 2099088.6488 | 37.7434025140107 | -122.460433407183 | (37.7434025140107, -122.460433407183) | 1 | 8 | 4 | 59 | 40 | |||
| 183414 | 213653 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 10 Edgehill Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994833.21817 | 2099074.30171 | 37.7433615876766 | -122.460524496827 | (37.7433615876766, -122.460524496827) | 1 | 8 | 4 | 59 | 40 | |||
| 64315 | 14623 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 10 Matthew Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018016.8978124 | 2094239.2837712 | 37.7313920698281 | -122.380024515102 | (37.7313920698281, -122.380024515102) | 10 | 3 | 8 | 58 | 1 | ||
| 107896 | 213569 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 10 Merced Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5995296.87532 | 2100197.80172 | 37.7464731016692 | -122.459002630776 | (37.7464731016692, -122.459002630776) | 1 | 8 | 4 | 59 | 40 | |||
| 82570 | 237164 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 10 Norwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009246.95837 | 2099498.34897 | 37.7453446044841 | -122.410715218849 | (37.7453446044841, -122.410715218849) | 2 | 7 | 7 | 28859 | 2 | |||
| 109799 | 213555 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 10 Valdez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5996402.0458 | 2093842.94884 | 37.7290876920423 | -122.454722051206 | (37.7290876920423, -122.454722051206) | 9 | 7 | 4 | 28861 | 40 | |||
| 25994 | 179109 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 10 Valmar Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005498.42194 | 2092990.6944 | 37.7272651547613 | -122.42321455871 | (37.7272651547613, -122.42321455871) | 9 | 7 | 6 | 28861 | 5 | |||
| 42333 | 237115 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Hwy 101 Southbound | 6 | Back Yard : Yard | Tree | Private 2 | 6 | 6005846.05822 | 2108984.84199 | 37.7712010306339 | -122.423149171694 | (37.7712010306339, -122.423149171694) | 8 | 2 | 5 | 28853 | 19 | ||||
| 53799 | 237116 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Hwy 101 Southbound | 4 | Back Yard : Yard | Tree | Private 2 | 5 | 6005840.35144 | 2109000.46624 | 37.7712436090254 | -122.423170022474 | (37.7712436090254, -122.423170022474) | 8 | 2 | 5 | 28853 | 19 | ||||
| 131449 | 83237 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769756 | 6004043.10746 | 2093201.4009 | 37.7277614698948 | -122.428260584571 | (37.7277614698948, -122.428260584571) | 9 | 7 | 6 | 28861 | 5 |
| 75771 | 238063 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Manchester St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008227.61512 | 2099350.56436 | 37.7448816154881 | -122.414229497799 | (37.7448816154881, -122.414229497799) | 2 | 7 | 7 | 28859 | 2 | |||
| 76218 | 179092 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Naples St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6004478.25383 | 2092876.73529 | 37.7268946223776 | -122.426733164302 | (37.7268946223776, -122.426733164302) | 9 | 7 | 6 | 28861 | 5 | |||
| 78950 | 237033 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Octavia St | 7 | : | Tree | DPW 1 | 6 | Width 4ft | 6005718.98472 | 2109769.85153 | 37.7733493059578 | -122.423644547079 | (37.7733493059578, -122.423644547079) | 7 | 9 | 11 | 28852 | 10 | |||
| 131106 | 237030 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Octavia St | 4 | : | Tree | DPW 1 | 5 | Width 4ft | 6005725.94025 | 2109733.85532 | 37.7732508616652 | -122.423617927146 | (37.7732508616652, -122.423617927146) | 7 | 9 | 11 | 28852 | 10 | |||
| 131435 | 237032 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Octavia St | 6 | : | Tree | Private 2 | 5 | Width 4ft | 6005721.49565 | 2109758.3052 | 37.7733177442556 | -122.423635040324 | (37.7733177442556, -122.423635040324) | 7 | 9 | 11 | 28852 | 10 | |||
| 178694 | 237031 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Octavia St | 5 | : | Tree | Private 2 | 5 | Width 4ft | 6005723.44032 | 2109745.94906 | 37.773283927046 | -122.423627434762 | (37.773283927046, -122.423627434762) | 7 | 9 | 11 | 28852 | 10 | |||
| 84290 | 213576 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994554.19808 | 2099981.39248 | 37.7458361756945 | -122.461555020073 | (37.7458361756945, -122.461555020073) | 1 | 8 | 4 | 29491 | 40 | |||
| 85965 | 213577 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994569.97359 | 2099964.16864 | 37.745789791378 | -122.46149922251 | (37.745789791378, -122.46149922251) | 1 | 8 | 4 | 29491 | 40 | |||
| 34019 | 99712 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Paloma Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 65809 | 99710 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Paloma Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 110354 | 99709 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Paloma Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 145661 | 99708 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Paloma Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 182177 | 99711 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Paloma Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 163767 | 62880 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1986 12:00:00 AM | 3x3 | Permit Number 49921 | 6008828.47380472 | 2098062.83988383 | 37.7413795400306 | -122.41206084487 | (37.7413795400306, -122.41206084487) | 10 | 7 | 7 | 28859 | 2 | ||
| 50338 | 237406 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003490.74781 | 2095180.09106 | 37.7331632378897 | -122.430311212408 | (37.7331632378897, -122.430311212408) | 9 | 7 | 5 | 28861 | 25 | |||
| 128162 | 94680 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53816 | 6003489 | 2095230 | 37.7333001775342 | -122.430320814613 | (37.7333001775342, -122.430320814613) | 9 | 7 | 5 | 28861 | 25 | |
| 84472 | 179116 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Yale St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006991.89793 | 2093240.59071 | 37.7280354870245 | -122.418069316059 | (37.7280354870245, -122.418069316059) | 9 | 3 | 7 | 309 | 5 | |||
| 135805 | 179114 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Yale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006904.09352 | 2093533.23761 | 37.7288340895016 | -122.418393600792 | (37.7288340895016, -122.418393600792) | 9 | 3 | 7 | 309 | 5 | |||
| 144435 | 179115 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Yale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6006932.90152 | 2093437.92283 | 37.7285739974769 | -122.41828725417 | (37.7285739974769, -122.41828725417) | 9 | 3 | 7 | 309 | 5 | |||
| 3915 | 79787 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1000 Russia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6003769.36441 | 2089501.77219 | 37.7175876140639 | -122.428943265313 | (37.7175876140639, -122.428943265313) | 9 | 7 | 6 | 28861 | 5 | |||
| 8215 | 78428 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1000 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6003760.55793 | 2089507.02649 | 37.7176015427445 | -122.428974079707 | (37.7176015427445, -122.428974079707) | 9 | 7 | 6 | 28861 | 5 | |||
| 124385 | 196469 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1001 Cesar Chavez St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6015764.4296 | 2101073.59632 | 37.750033173207 | -122.388288593857 | (37.750033173207, -122.388288593857) | 10 | 3 | 8 | 58 | 1 | |||
| 4080 | 136012 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1001 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006953.33762 | 2120481.80968 | 37.802831303989 | -122.420135108266 | (37.802831303989, -122.420135108266) | 5 | 1 | 1 | 28858 | 32 | |||
| 73417 | 136013 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1001 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006984.71597 | 2120484.67695 | 37.8028409447119 | -122.420026726469 | (37.8028409447119, -122.420026726469) | 5 | 1 | 1 | 28858 | 32 | |||
| 29809 | 47252 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1001 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767654 | 6013117.42744406 | 2089558.25653077 | 37.718267407089 | -122.396634995972 | (37.718267407089, -122.396634995972) | 10 | 3 | 8 | 58 | 1 | |
| 18514 | 79061 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1006 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012156.57413 | 2103666.55961 | 37.7569523133274 | -122.400946989616 | (37.7569523133274, -122.400946989616) | 10 | 3 | 8 | 28856 | 29 | |||
| 150596 | 99706 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100@Moncada Paloma Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 164649 | 99707 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100@Moncada Paloma Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 79193 | 103760 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100X Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006758.9 | 2115521.2 | 37.7891997559918 | -122.420455645258 | (37.7891997559918, -122.420455645258) | 13 | 9 | 10 | 28858 | 21 | ||
| 123947 | 27248 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100X CORTLAND AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2000 12:00:00 AM | 4 | 3X3 | 6006272 | 2097672 | 37.7401626122958 | -122.420872513823 | (37.7401626122958, -122.420872513823) | 2 | 7 | 7 | 28859 | 2 | ||
| 48521 | 87154 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50137 | 5992080.87589 | 2114715.15142 | 37.7861484784179 | -122.47118058794 | (37.7861484784179, -122.47118058794) | 11 | 6 | 2 | 54 | 11 | |
| 58326 | 68685 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50137 | 5992080.71456 | 2114734.20286 | 37.7862007790713 | -122.47118253461 | (37.7862007790713, -122.47118253461) | 11 | 6 | 2 | 54 | 11 | |
| 66885 | 87155 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 12th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50137 | 5992081.9043 | 2114697.20231 | 37.7860992546106 | -122.471175721775 | (37.7860992546106, -122.471175721775) | 11 | 6 | 2 | 54 | 11 | |
| 192558 | 214766 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Alton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5993866.28574 | 2101627.27037 | 37.7503157185921 | -122.464053162237 | (37.7503157185921, -122.464053162237) | 1 | 8 | 4 | 29491 | 40 | |||
| 64507 | 214754 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5995607.36531 | 2093372.70982 | 37.7277509145579 | -122.457435300396 | (37.7277509145579, -122.457435300396) | 9 | 7 | 4 | 28861 | 40 | |||
| 19755 | 40666 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Maynard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767516 | 6004070.62612566 | 2093782.39936272 | 37.7293583191123 | -122.428206841061 | (37.7293583191123, -122.428206841061) | 9 | 7 | 6 | 28861 | 5 | |
| 77408 | 40667 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Maynard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767516 | 6004070.62612566 | 2093782.39936272 | 37.7293583191123 | -122.428206841061 | (37.7293583191123, -122.428206841061) | 9 | 7 | 6 | 28861 | 5 | |
| 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 | |||
| 119462 | 237040 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Octavia St | 3 | : | Tree | Private 2 | 5 | Width 4ft | 6005610.09761 | 2109720.52403 | 37.7732077175873 | -122.424017694677 | (37.7732077175873, -122.424017694677) | 7 | 9 | 11 | 28852 | 10 | |||
| 170909 | 237039 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Octavia St | 2 | : | Tree | Private 2 | 7 | Width 4ft | 6005609.24206 | 2109730.37641 | 37.7732347215415 | -122.424021354908 | (37.7732347215415, -122.424021354908) | 7 | 9 | 11 | 28852 | 10 | |||
| 126154 | 237307 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6008865.15222 | 2098033.02792 | 37.741299740778 | -122.411931917026 | (37.741299740778, -122.411931917026) | 10 | 7 | 7 | 28859 | 2 | |||
| 170681 | 89313 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Scott St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/2011 12:00:00 AM | 3x3 | Permit Number 767419 | 6002340 | 2108819 | 37.7705471897255 | -122.435264883718 | (37.7705471897255, -122.435264883718) | 15 | 5 | 11 | 29492 | 9 | |
| 89344 | 179141 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Woolsey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011519.75007 | 2092135.22888 | 37.7252541978079 | -122.402338614032 | (37.7252541978079, -122.402338614032) | 10 | 3 | 7 | 309 | 28 | |||
| 133446 | 179140 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011506.15031 | 2092130.79684 | 37.7252412691581 | -122.402385315842 | (37.7252412691581, -122.402385315842) | 10 | 3 | 7 | 309 | 28 | |||
| 178892 | 179139 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011492.5608 | 2092126.86899 | 37.7252297254637 | -122.402432017638 | (37.7252297254637, -122.402432017638) | 10 | 3 | 7 | 309 | 28 | |||
| 189431 | 179142 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101 Woolsey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011536.91523 | 2092140.59723 | 37.7252698963774 | -122.402279652698 | (37.7252698963774, -122.402279652698) | 10 | 3 | 7 | 309 | 28 | |||
| 34394 | 238168 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1010 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1989 12:00:00 AM | 14 | Width 4ft | Permit Number 27196 | 6003119.41534 | 2102323.30502 | 37.7527558068522 | -122.432104939916 | (37.7527558068522, -122.432104939916) | 2 | 4 | 5 | 28862 | 22 | |
| 16447 | 237246 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1011 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5998816.10599 | 2106399.33422 | 37.763702653385 | -122.447279838404 | (37.763702653385, -122.447279838404) | 15 | 5 | 11 | 29492 | 9 | |||
| 71979 | 237248 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1018 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5998867.29891 | 2106367.84933 | 37.7636191288389 | -122.447100512681 | (37.7636191288389, -122.447100512681) | 15 | 5 | 11 | 29492 | 9 | |||
| 74600 | 238169 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1018 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1989 12:00:00 AM | 2 | Width 4ft | Permit Number 27197 | 6003120.08624 | 2102266.16095 | 37.7525989407879 | -122.432098539422 | (37.7525989407879, -122.432098539422) | 2 | 4 | 5 | 28862 | 22 | |
| 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 | ||
| 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 | ||
| 153221 | 239523 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 102 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009546.51282 | 2097971.75612 | 37.7411697051097 | -122.409571678707 | (37.7411697051097, -122.409571678707) | 10 | 7 | 7 | 28859 | 2 | |||
| 192966 | 237178 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 102 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010211.56612 | 2100240.61937 | 37.7474367531234 | -122.407432068339 | (37.7474367531234, -122.407432068339) | 2 | 7 | 7 | 28859 | 2 | |||
| 123212 | 179145 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 102 Wayland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011376.8849 | 2092609.12278 | 37.7265474363946 | -122.402865802033 | (37.7265474363946, -122.402865802033) | 10 | 3 | 7 | 309 | 28 | |||
| 181672 | 179146 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 102 Wayland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011358.3265 | 2092604.64263 | 37.7265340985502 | -122.402929643103 | (37.7265340985502, -122.402929643103) | 10 | 3 | 7 | 309 | 28 | |||
| 130446 | 237362 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1024 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008600.1572 | 2102553.65045 | 37.7536974932443 | -122.413167765379 | (37.7536974932443, -122.413167765379) | 2 | 4 | 7 | 28859 | 19 | |||
| 192928 | 237124 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1025 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6008637.74753 | 2102555.44614 | 37.7537045340508 | -122.413037896084 | (37.7537045340508, -122.413037896084) | 2 | 4 | 7 | 28859 | 19 | |||
| 65209 | 51286 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1026 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767263 | 6004381.40328388 | 2102911.72608688 | 37.7544429415209 | -122.427782679143 | (37.7544429415209, -122.427782679143) | 2 | 4 | 5 | 28862 | 22 | |
| 167572 | 237191 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1026 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004373.7656 | 2102888.22747 | 37.7543779877776 | -122.427807417997 | (37.7543779877776, -122.427807417997) | 2 | 4 | 5 | 28862 | 22 | |||
| 72492 | 136004 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1027 Broadway | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 19 | Width 3ft | 6008655.55584 | 2118272.73317 | 37.7968614918226 | -122.41408816573 | (37.7968614918226, -122.41408816573) | 5 | 1 | 10 | 308 | 21 | |||
| 41071 | 178969 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1029 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008570.63643 | 2086915.27252 | 37.710756219889 | -122.412164693966 | (37.710756219889, -122.412164693966) | 9 | 7 | 8 | 309 | 39 | |||
| 50426 | 178970 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1029 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008583.66239 | 2086910.82676 | 37.7107447436356 | -122.412119359132 | (37.7107447436356, -122.412119359132) | 9 | 7 | 8 | 309 | 39 | |||
| 88047 | 178968 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1029 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008554.00356 | 2086922.92709 | 37.710776304465 | -122.412222721805 | (37.710776304465, -122.412222721805) | 9 | 7 | 8 | 309 | 39 | |||
| 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 | |
| 170480 | 238484 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 103 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 7 | Width 3ft | Permit Number 37768 | 6003723.3725 | 2108822.3529 | 37.7706348579377 | -122.430480026835 | (37.7706348579377, -122.430480026835) | 15 | 9 | 11 | 29492 | 10 | |
| 64285 | 238527 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 103 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6004847.13558 | 2097543.60322 | 37.7397296468092 | -122.425789984144 | (37.7397296468092, -122.425789984144) | 2 | 7 | 5 | 63 | 7 | |||
| 64457 | 213288 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1039 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995905.05181 | 2090820.42623 | 37.7207600463335 | -122.456221739052 | (37.7207600463335, -122.456221739052) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | ||
| 68044 | 103784 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 103X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006741.56415 | 2115141.24736 | 37.7881555229055 | -122.420488644345 | (37.7881555229055, -122.420488644345) | 13 | 9 | 10 | 28858 | 21 | ||
| 25813 | 214712 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 104 Aptos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993048.10072 | 2094327.00059 | 37.7302238280612 | -122.466351975066 | (37.7302238280612, -122.466351975066) | 9 | 8 | 4 | 59 | 40 | |||
| 42125 | 214713 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 104 Aptos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993041.99484 | 2094312.53309 | 37.730183751567 | -122.466372032662 | (37.730183751567, -122.466372032662) | 9 | 8 | 4 | 59 | 40 | |||
| 76800 | 135991 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1040 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008482.86494 | 2115597.67171 | 37.7895067291082 | -122.414496332055 | (37.7895067291082, -122.414496332055) | 5 | 1 | 10 | 28858 | 21 | |||
| 26102 | 136002 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009478.99985 | 2116817.49063 | 37.7929119670677 | -122.411135999022 | (37.7929119670677, -122.411135999022) | 3 | 1 | 10 | 28857 | 21 | |||
| 33557 | 135998 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009470.07385 | 2116888.98279 | 37.7931077665596 | -122.411171935935 | (37.7931077665596, -122.411171935935) | 3 | 1 | 10 | 28857 | 21 | |||
| 58470 | 136000 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009476.57256 | 2116845.84647 | 37.7929896891793 | -122.411146401493 | (37.7929896891793, -122.411146401493) | 3 | 1 | 10 | 28857 | 21 |
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) );