Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5494 | 5494 | 87738 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005444.64461 | 2121623.98788 | 37.8058823097966 | -122.425437295217 | (37.8058823097966, -122.425437295217) | ||
| 8626 | 8626 | 87739 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005433.618530001 | 2121623.41722 | 37.8058801199389 | -122.42547541206699 | (37.8058801199389, -122.425475412067) | ||
| 95840 | 95840 | 51935 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 329 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2005 12:00:00 AM | Permit Number 48161 | 6009200.27838208 | 2121477.92859384 | 37.805692742557 | -122.412429964781 | (37.805692742557, -122.412429964781) | |||
| 115727 | 115727 | 93018 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 963 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2010 12:00:00 AM | 3x3 | Permit Number 53140 | 6006134.0 | 2121397.0 | 37.805297983444 | -122.42303552725402 | (37.805297983444, -122.423035527254) | ||
| 7662 | 7662 | 88451 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/07/2008 12:00:00 AM | 3 | 5x12 | 6005480.84439 | 2121378.35155 | 37.805209901088396 | -122.425294529632 | (37.8052099010884, -122.425294529632) | ||
| 187959 | 187959 | 88452 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/07/2008 12:00:00 AM | 4 | 5x12 | 6005470.42698 | 2121378.16696 | 37.8052088057127 | -122.425330567252 | (37.8052088057127, -122.425330567252) | ||
| 184236 | 184236 | 65288 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | 7 | Permit Number 28836 | 6001457.593230001 | 2121333.88235 | 37.8048596843835 | -122.439214266819 | (37.8048596843835, -122.439214266819) | |
| 119959 | 119959 | 100985 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2190 Powell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 03/23/2016 02:34:00 PM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | |
| 67735 | 67735 | 135944 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1998 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999737.82806 | 2121247.80693 | 37.804525333529796 | -122.44515948523399 | (37.8045253335298, -122.445159485234) | |||
| 59892 | 59892 | 135945 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1998 Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999716.32151 | 2121244.69535 | 37.8045155623958 | -122.44523368650499 | (37.8045155623958, -122.445233686505) | |||
| 187914 | 187914 | 135943 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2056 Jefferson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5999351.778519999 | 2121203.50658 | 37.8043816542415 | -122.446492250814 | (37.8043816542415, -122.446492250814) | |||
| 185006 | 185006 | 52876 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 118@ BEACH Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2006 12:00:00 AM | 3 | Permit Number 48887 | 6001354.74762 | 2121139.05445 | 37.8043188860645 | -122.439556198976 | (37.8043188860645, -122.439556198976) | ||
| 156227 | 156227 | 52875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 118@ BEACH Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48887 | 6001367.786590001 | 2121129.52184 | 37.8042934541427 | -122.439510392889 | (37.8042934541427, -122.439510392889) | |
| 46269 | 46269 | 41181 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1780 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | 11 | Permit Number 41899 | 6001559.95191 | 2121091.33566 | 37.8041995397404 | -122.438842652585 | (37.8041995397404, -122.438842652585) | |
| 149267 | 149267 | 41180 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1780 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | 3 | Permit Number 41899 | 6001541.153 | 2121088.1531 | 37.804189731738 | -122.43890747929701 | (37.804189731738, -122.438907479297) | |
| 127326 | 127326 | 108693 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950X Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774617 | 6001046.33677 | 2120996.58295 | 37.803910139733794 | -122.440613252117 | (37.8039101397338, -122.440613252117) |
| 139925 | 139925 | 108694 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950X Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774617 | 6001046.33677 | 2120996.58295 | 37.803910139733794 | -122.440613252117 | (37.8039101397338, -122.440613252117) |
| 143086 | 143086 | 108692 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950X Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774617 | 6001046.33677 | 2120996.58295 | 37.803910139733794 | -122.440613252117 | (37.8039101397338, -122.440613252117) |
| 165767 | 165767 | 135928 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1960 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000881.44205 | 2120995.2314 | 37.8038970374844 | -122.44118378211901 | (37.8038970374844, -122.441183782119) | |||
| 172041 | 172041 | 135929 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1960 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000857.17484 | 2120992.84894 | 37.8038891135616 | -122.44126758904 | (37.8038891135616, -122.44126758904) | |||
| 154793 | 154793 | 135930 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1960 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000826.2402099995 | 2120988.3379599997 | 37.8038749654115 | -122.441374316075 | (37.8038749654115, -122.441374316075) | |||
| 31936 | 31936 | 48575 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2275 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2002 12:00:00 AM | 6 | Permit Number 45888 | 5999350.9725 | 2120803.18902 | 37.80328244439271 | -122.446466222664 | (37.8032824443927, -122.446466222664) | ||
| 154989 | 154989 | 136018 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Greenwich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6012250.392990001 | 2120519.5939 | 37.8032320823636 | -122.401807129095 | (37.8032320823636, -122.401807129095) | ||||
| 52335 | 52335 | 135946 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 33 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001854.08706 | 2120729.8042200003 | 37.803223599954705 | -122.437798867946 | (37.8032235999547, -122.437798867946) | |||
| 56051 | 56051 | 136019 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Greenwich St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012283.42018 | 2120515.08235 | 37.803221537807204 | -122.401692519489 | (37.8032215378072, -122.401692519489) | ||||
| 26868 | 26868 | 135947 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 31 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001885.41156 | 2120707.63326 | 37.803164505492504 | -122.43768887996201 | (37.8031645054925, -122.437688879962) | |||
| 163690 | 163690 | 135948 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 31 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001895.29837 | 2120693.9243 | 37.8031274264634 | -122.437653684066 | (37.8031274264634, -122.437653684066) | |||
| 48537 | 48537 | 116894 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6001897.52549 | 2120678.68583 | 37.8030857122852 | -122.43764488509899 | (37.8030857122852, -122.437644885099) | |||
| 180053 | 180053 | 135949 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Alhambra St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001899.24184 | 2120659.238 | 37.803032411275794 | -122.43763755203199 | (37.8030324112758, -122.437637552032) | |||
| 80642 | 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) | |||
| 119998 | 119998 | 13086 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6008944.94841 | 2120470.5671200003 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | |||
| 122784 | 122784 | 26727 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008944.94841 | 2120470.5671200003 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | |||
| 128762 | 128762 | 13087 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 3 | 3X3 | 6008944.94841 | 2120470.5671200003 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | ||
| 142447 | 142447 | 26728 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6008944.94841 | 2120470.5671200003 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | |||
| 64904 | 64904 | 249855 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 241 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011547.42399 | 2120404.90985 | 37.802877932936504 | -122.40423171211901 | (37.8028779329365, -122.404231712119) | |||
| 50139 | 50139 | 136013 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1001 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006984.715969999 | 2120484.67695 | 37.8028409447119 | -122.420026726469 | (37.8028409447119, -122.420026726469) | |||
| 163914 | 163914 | 136012 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1001 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006953.337619999 | 2120481.80968 | 37.802831303989 | -122.420135108266 | (37.802831303989, -122.420135108266) | |||
| 84903 | 84903 | 95588 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2153 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767378 | 6000457.0 | 2120611.0 | 37.802817854966 | -122.442624981194 | (37.802817854966, -122.442624981194) | |
| 36163 | 36163 | 66052 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2153 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1990 12:00:00 AM | 5 | Permit Number 29091 | 6000458.6364 | 2120609.1379299997 | 37.8028128355005 | -122.442619184653 | (37.8028128355005, -122.442619184653) | ||
| 149637 | 149637 | 135931 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1361 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004797.09073 | 2120517.98623 | 37.8028089081649 | -122.42759940931002 | (37.8028089081649, -122.42759940931) | |||
| 84751 | 84751 | 82096 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1363 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52338 | 6004802.97001971 | 2120513.88344233 | 37.802797975517294 | -122.42757877147899 | (37.8027979755173, -122.427578771479) | ||
| 172726 | 172726 | 135927 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3400 Baker St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5999297.26526 | 2120520.00382 | 37.8025018265619 | -122.446631690727 | (37.8025018265619, -122.446631690727) | ||||
| 160636 | 160636 | 35253 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2250 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 16 | Permit Number 38739 | 6008088.43141 | 2120207.50426 | 37.8021420203875 | -122.416187651964 | (37.8021420203875, -122.416187651964) | |
| 158284 | 158284 | 250003 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 232 Filbert St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 0ft | 6011516.941380001 | 2120107.55399 | 37.802059763016096 | -122.404316256511 | (37.8020597630161, -122.404316256511) | |||
| 83473 | 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) | ||
| 116783 | 116783 | 14410 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2001X Mason St | 1 | 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) | ||
| 132944 | 132944 | 249940 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 331 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011278.90186 | 2120029.10977 | 37.80183106989429 | -122.40513446418801 | (37.8018310698943, -122.405134464188) | |||
| 171242 | 171242 | 249941 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 331 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6011275.707669999 | 2120025.2952 | 37.8018204174494 | -122.40514524887199 | (37.8018204174494, -122.405145248872) | |||
| 29621 | 29621 | 66088 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2229 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/08/1990 12:00:00 AM | 12 | Permit Number 29132 | 6007569.63634 | 2120087.67012 | 37.8017838015514 | -122.41797443666401 | (37.8017838015514, -122.417974436664) | |
| 163034 | 163034 | 136008 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 979 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008203.73321 | 2119954.656 | 37.8014542449694 | -122.41577073705099 | (37.8014542449694, -122.415770737051) | |||
| 44692 | 44692 | 135950 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3012 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004722.9901 | 2119938.49945 | 37.80121359538229 | -122.427814520823 | (37.8012135953823, -122.427814520823) | |||
| 47983 | 47983 | 136016 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 290 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011568.90675 | 2119422.0677900002 | 37.8001804883964 | -122.40408816056002 | (37.8001804883964, -122.40408816056) | |||
| 71629 | 71629 | 136017 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 290 Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011553.12596 | 2119421.08108 | 37.800176897396604 | -122.404142699051 | (37.8001768973966, -122.404142699051) | |||
| 46218 | 46218 | 34478 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 755 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 16 | Permit Number 38205 | 6009336.13836 | 2119417.92641 | 37.8000441124981 | -122.411814144501 | (37.8000441124981, -122.411814144501) | |
| 37715 | 37715 | 113953 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1665 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6009606.745080001 | 2119405.96484 | 37.8000264462311 | -122.41087689265 | (37.8000264462311, -122.41087689265) | |||
| 44542 | 44542 | 34480 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 771 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 18 | Permit Number 38207 | 6009276.26447 | 2119410.9605 | 37.8000216267413 | -122.412020839304 | (37.8000216267413, -122.412020839304) | |
| 151404 | 151404 | 34481 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 839 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2001 12:00:00 AM | 9 | Permit Number 38208 | 6008950.87239 | 2119364.8911900003 | 37.7998768700862 | -122.41314356464198 | (37.7998768700862, -122.413143564642) | |
| 181976 | 181976 | 136014 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Havens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6007575.68988 | 2119392.2209400004 | 37.7998746136871 | -122.417904161874 | (37.7998746136871, -122.417904161874) | |||
| 69163 | 69163 | 34484 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 845 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 6 | Permit Number 38210 | 6008932.65781 | 2119362.16351 | 37.799868357993105 | -122.41320640114901 | (37.7998683579931, -122.413206401149) | |
| 182770 | 182770 | 34483 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 845 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 8 | Permit Number 38210 | 6008918.6183400005 | 2119360.64227 | 37.7998633928514 | -122.413254875509 | (37.7998633928514, -122.413254875509) | |
| 180553 | 180553 | 136007 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 851 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008899.0755 | 2119356.3922200003 | 37.7998506260751 | -122.413322200567 | (37.7998506260751, -122.413322200567) | |||
| 54230 | 54230 | 34485 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 851 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 8 | Permit Number 38211 | 6008882.966680001 | 2119355.1714 | 37.799846369579704 | -122.41337785691299 | (37.7998463695797, -122.413377856913) | |
| 151561 | 151561 | 136015 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Havens St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6007560.5835 | 2119380.86157 | 37.7998425735334 | -122.417955630044 | (37.7998425735334, -122.417955630044) | |||
| 158667 | 158667 | 38480 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2515 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1998 12:00:00 AM | 9 | Permit Number 40479 | 5999797.205130001 | 2119471.52027 | 37.799651516149396 | -122.44482624505899 | (37.7996515161494, -122.444826245059) | ||
| 32635 | 32635 | 64938 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2810 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1989 12:00:00 AM | 11 | Permit Number 25967 | 6004818.34721 | 2119246.7576099997 | 37.799319643836895 | -122.427435236266 | (37.7993196438369, -122.427435236266) | |
| 52069 | 52069 | 104072 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3020 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770362 | 6003851.5174 | 2119222.18029 | 37.7991974313859 | -122.430779048741 | (37.7991974313859, -122.430779048741) | |
| 163902 | 163902 | 135915 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2909 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004293.78648 | 2119207.639 | 37.7991825520948 | -122.429247608494 | (37.7991825520948, -122.429247608494) | |||
| 169316 | 169316 | 71443 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 924 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 6 | 6012090.037819999 | 2119001.59006 | 37.7990550614973 | -122.40225525407101 | (37.7990550614973, -122.402255254071) | ||
| 161379 | 161379 | 33142 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3148 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2005 12:00:00 AM | 8 | Permit Number 37368 | 6001934.81136 | 2119023.6664400003 | 37.798543584677894 | -122.437397274777 | (37.7985435846779, -122.437397274777) | |
| 90041 | 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) | ||
| 103844 | 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) | ||
| 120512 | 120512 | 23489 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2500X Van Ness Ave | 5 | 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) | ||
| 124893 | 124893 | 29668 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2500 Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/09/2004 12:00:00 AM | 6 | 6005837.0202043 | 2118942.4447679003 | 37.79854163961021 | -122.42388861727899 | (37.7985416396102, -122.423888617279) | |||
| 56604 | 56604 | 33140 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3143 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 6 | Permit Number 37367 | 6001896.074 | 2118984.29093 | 37.798433267540105 | -122.437528496644 | (37.7984332675401, -122.437528496644) | |
| 183771 | 183771 | 33141 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3143 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37367 | 6001898.22805 | 2118969.0422099996 | 37.7983915210181 | -122.437519950413 | (37.7983915210181, -122.437519950413) | |
| 35428 | 35428 | 48426 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3130 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 9 | Permit Number 45804 | 6001942.5823800005 | 2118964.92546 | 37.798382739120704 | -122.437366176208 | (37.7983827391207, -122.437366176208) | |
| 35216 | 35216 | 135924 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 273 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002069.33792 | 2118935.23427 | 37.7983084200504 | -122.436925437376 | (37.7983084200504, -122.436925437376) | |||
| 26957 | 26957 | 135923 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 299 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001988.80401 | 2118923.8728 | 37.7982726468322 | -122.43720329460501 | (37.7982726468322, -122.437203294605) | |||
| 123729 | 123729 | 42840 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1828 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 5 | Permit Number 42772 | 6008289.65137 | 2118753.27916 | 37.7981603934451 | -122.415388321908 | (37.7981603934451, -122.415388321908) | |
| 131832 | 131832 | 135926 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2575 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000595.0032 | 2118891.4120400003 | 37.7981041894114 | -122.44202391886299 | (37.7981041894114, -122.442023918863) | |||
| 126268 | 126268 | 94585 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2725 Greenwich St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2010 12:00:00 AM | 3x3 | Permit Number 53761 | 5999865.0 | 2118793.0 | 37.7977923490456 | -122.44454285799999 | (37.7977923490456, -122.444542858) | |||
| 65782 | 65782 | 135925 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2725 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999832.2761699995 | 2118786.40209 | 37.797772365663796 | -122.444655616678 | (37.7977723656638, -122.444655616678) | |||
| 179645 | 179645 | 135922 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2440 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001259.6305 | 2118684.30492 | 37.7975733798607 | -122.43970926357599 | (37.7975733798607, -122.439709263576) | |||
| 71086 | 71086 | 136009 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1173 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007981.4110900005 | 2118539.47865 | 37.797556021142 | -122.416439775085 | (37.797556021142, -122.416439775085) | |||
| 71708 | 71708 | 66515 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1173 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/1991 12:00:00 AM | 7 | Permit Number 29681 | 6007962.75323 | 2118537.74133 | 37.7975502016423 | -122.41650421331 | (37.7975502016423, -122.41650421331) | ||
| 40854 | 40854 | 64351 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2829 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/1988 12:00:00 AM | 10 | Permit Number 25187 | 5999331.75802 | 2118714.3640900003 | 37.797545994610296 | -122.44638235637501 | (37.7975459946103, -122.446382356375) | ||
| 175252 | 175252 | 51995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2837 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2005 12:00:00 AM | 11 | Permit Number 48213 | 5999309.41845 | 2118712.36147 | 37.797539220023296 | -122.44645951279301 | (37.7975392200233, -122.446459512793) | ||
| 134776 | 134776 | 46595 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2480 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 3 | Permit Number 45794 | 6001119.4315599995 | 2118662.9619299998 | 37.7975067967595 | -122.440192856927 | (37.7975067967595, -122.440192856927) | |
| 150281 | 150281 | 46596 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2480 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 3 | Permit Number 45794 | 6001101.661169999 | 2118661.22174 | 37.7975010069291 | -122.440254222167 | (37.7975010069291, -122.440254222167) | |
| 74882 | 74882 | 48418 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2490 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 5 | Permit Number 45796 | 6001083.868919999 | 2118658.4276799997 | 37.7974923221726 | -122.440315587421 | (37.7974923221726, -122.440315587421) | |
| 26032 | 26032 | 48415 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2475 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 8 | Permit Number 45793 | 6001140.73556 | 2118622.32163 | 37.797396422056295 | -122.440116223893 | (37.7973964220563, -122.440116223893) | |
| 61746 | 61746 | 135921 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2495 Filbert St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001125.354069999 | 2118620.11363 | 37.797389483787 | -122.440169289291 | (37.797389483787, -122.440169289291) | |||
| 46303 | 46303 | 135920 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2495 Filbert St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001110.697980001 | 2118617.5430900003 | 37.797381591353606 | -122.440219818601 | (37.7973815913536, -122.440219818601) | |||
| 68955 | 68955 | 67626 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1334 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/1993 12:00:00 AM | 7 | Permit Number 31212 | 6007155.75192 | 2118470.9352 | 37.7973213520513 | -122.41929191739901 | (37.7973213520513, -122.419291917399) | |
| 150490 | 150490 | 136010 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1761 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007314.88578 | 2118424.776 | 37.797203571436896 | -122.418737997073 | (37.7972035714369, -122.418737997073) | |||
| 65268 | 65268 | 136011 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1761 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007318.32314 | 2118399.04204 | 37.7971331059516 | -122.418724276998 | (37.7971331059516, -122.418724276998) | |||
| 114197 | 114197 | 11071 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1769 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6007332.0 | 2118349.0 | 37.7969964730533 | -122.418673401001 | (37.7969964730533, -122.418673401001) | |||
| 145898 | 145898 | 96036 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1498 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767675 | 6006383.0 | 2118353.0 | 37.7969539806541 | -122.421957458925 | (37.7969539806541, -122.421957458925) | |
| 137373 | 137373 | 136004 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1027 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 3ft | 6008655.5558400005 | 2118272.73317 | 37.796861491822604 | -122.41408816572999 | (37.7968614918226, -122.41408816573) | |||
| 65194 | 65194 | 94744 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1801 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53879 | 6004279.92071 | 2118358.49437 | 37.7968502341069 | -122.42923500719401 | (37.7968502341069, -122.429235007194) |
JSON shape: default, array, newline-delimited
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");