Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50040 | 50040 | 87823 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 451 47th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 4 | 2x3 | Permit Number 50716 | 5981265.5826900005 | 2112596.97795 | 37.7797010943021 | -122.508440678428 | (37.7797010943021, -122.508440678428) | ||
| 4128 | 4128 | 135978 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006877.42 | 2115159.3392 | 37.788212853775896 | -122.420019889812 | (37.7882128537759, -122.420019889812) | ||
| 4162 | 4162 | 135980 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.58425 | 2115187.77482 | 37.7882922360442 | -122.419941763898 | (37.7882922360442, -122.419941763898) | ||
| 4821 | 4821 | 214558 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1340 Irving St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 4 | Width 3ft | 5991564.93185 | 2106609.34919 | 37.7638622938456 | -122.472374472204 | (37.7638622938456, -122.472374472204) | ||
| 10801 | 10801 | 83237 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769756 | 6004043.10746 | 2093201.4009 | 37.727761469894794 | -122.42826058457099 | (37.7277614698948, -122.428260584571) |
| 12196 | 12196 | 86961 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 212 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49929 | 5993495.99209 | 2087406.2303400002 | 37.7112468999028 | -122.464301303157 | (37.7112468999028, -122.464301303157) | |
| 20662 | 20662 | 84576 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3966 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769743 | 6003390.40048346 | 2101879.79659646 | 37.7515533971776 | -122.43113617160401 | (37.7515533971776, -122.431136171604) |
| 23585 | 23585 | 237396 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2797 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008140.86181 | 2106769.2911 | 37.7652468801621 | -122.415054485502 | (37.7652468801621, -122.415054485502) | |||
| 23875 | 23875 | 123972 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 75 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993617.67519 | 2115041.45387 | 37.78713318686079 | -122.46588743043002 | (37.7871331868608, -122.46588743043) | |||
| 24513 | 24513 | 213290 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 155 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5994132.71522 | 2090951.16156 | 37.721017116620004 | -122.46235759304399 | (37.72101711662, -122.462357593044) | |||
| 25641 | 25641 | 239502 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 81 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008343.6627400005 | 2098237.0984400003 | 37.741830802146296 | -122.413749481054 | (37.7418308021463, -122.413749481054) | |||
| 25834 | 25834 | 214493 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1359 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991433.81997 | 2106159.32578 | 37.762619060232296 | -122.47279512831001 | (37.7626190602323, -122.47279512831) | |||
| 26022 | 26022 | 214523 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 929 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992854.95804 | 2106590.6252900003 | 37.7638854612741 | -122.46791133836099 | (37.7638854612741, -122.467911338361) | |||
| 27484 | 27484 | 238143 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 574 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001412.715419999 | 2101470.20367 | 37.7503164848156 | -122.43794590440201 | (37.7503164848156, -122.437945904402) | |||
| 27655 | 27655 | 135992 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009196.7187 | 2117357.70571 | 37.7943794313202 | -122.41215090645201 | (37.7943794313202, -122.412150906452) | |||
| 27798 | 27798 | 238400 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 111 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002888.32666 | 2107612.09162 | 37.7672644381318 | -122.433281965392 | (37.7672644381318, -122.433281965392) | |||
| 28128 | 28128 | 179162 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 171 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002093.74544 | 2086607.8879 | 37.7095466578231 | -122.434528308849 | (37.7095466578231, -122.434528308849) | |||
| 28267 | 28267 | 214528 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 839 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993110.1935 | 2106600.58981 | 37.7639275567412 | -122.467029287771 | (37.7639275567412, -122.467029287771) | |||
| 28288 | 28288 | 237148 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 416 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005481.686509999 | 2101250.07635 | 37.7499426159557 | -122.423859462545 | (37.7499426159557, -122.423859462545) | |||
| 28530 | 28530 | 178973 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1501 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001853.9573099995 | 2094253.8181599998 | 37.7305270560629 | -122.43590377514299 | (37.7305270560629, -122.435903775143) | |||
| 29566 | 29566 | 135956 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3168 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5999589.9929599995 | 2115734.38967 | 37.789378518158 | -122.44527443117599 | (37.789378518158, -122.445274431176) | |||
| 30177 | 30177 | 237230 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 156 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997906.75784 | 2105953.1562 | 37.7624255585064 | -122.450392811082 | (37.7624255585064, -122.450392811082) | |||
| 30298 | 30298 | 214610 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1317 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993294.793 | 2106507.24559 | 37.7636819114108 | -122.466384034097 | (37.7636819114108, -122.466384034097) | |||
| 30826 | 30826 | 51284 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2205 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2004 12:00:00 AM | 4 | Permit Number 47656 | 6000322.72568 | 2116238.1776 | 37.7908035865572 | -122.442775457127 | (37.7908035865572, -122.442775457127) | ||
| 30897 | 30897 | 214641 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1281 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993288.48621 | 2106790.9815599998 | 37.7644606118874 | -122.46642647040501 | (37.7644606118874, -122.466426470405) | |||
| 31409 | 31409 | 135955 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3035 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6000215.874919999 | 2115769.86788 | 37.789511638505104 | -122.443111506798 | (37.7895116385051, -122.443111506798) | |||
| 32051 | 32051 | 68219 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 263 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 4 | Permit Number 32006 | 5990848.54158 | 2113649.76494 | 37.7831518664143 | -122.475366281729 | (37.7831518664143, -122.475366281729) | |
| 33035 | 33035 | 238142 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 525 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001732.91125 | 2101443.22488 | 37.750260610843796 | -122.436836716552 | (37.7502606108438, -122.436836716552) | |||
| 33377 | 33377 | 59100 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 574 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 4 | Permit Number 53750 | 5993480.53201 | 2111592.2596 | 37.777654724152896 | -122.46611116933201 | (37.7776547241529, -122.466111169332) | ||
| 33711 | 33711 | 49142 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 520 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 4 | Permit Number 46265 | 5985047.031690001 | 2112314.4789400003 | 37.7791475672211 | -122.495338355641 | (37.7791475672211, -122.495338355641) | ||
| 34126 | 34126 | 45776 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 782 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2001 12:00:00 AM | 4 | Permit Number 44418 | 5991347.84343 | 2110102.5113 | 37.7734410095192 | -122.47338010572399 | (37.7734410095192, -122.473380105724) | ||
| 34629 | 34629 | 238303 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 259 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001471.3059 | 2104316.27209 | 37.7581344352787 | -122.43794712837901 | (37.7581344352787, -122.437947128379) | |||
| 35028 | 35028 | 196446 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 701 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012741.003 | 2104236.29493 | 37.7585492646472 | -122.398965788556 | (37.7585492646472, -122.398965788556) | |||
| 35334 | 35334 | 238213 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 430 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003567.91941 | 2102172.09705 | 37.752366043358 | -122.43054314396002 | (37.752366043358, -122.43054314396) | |||
| 36336 | 36336 | 214656 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1797 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993098.06749 | 2103308.53562 | 37.7548877351851 | -122.466831895581 | (37.7548877351851, -122.466831895581) | |||
| 36539 | 36539 | 179000 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002131.90364 | 2089651.07814 | 37.7179047536928 | -122.43461388473699 | (37.7179047536928, -122.434613884737) | |||
| 37540 | 37540 | 237268 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 170 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007556.9387 | 2097846.2780299997 | 37.740713484431296 | -122.416442045889 | (37.7407134844313, -122.416442045889) | |||
| 37655 | 37655 | 213628 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 518 Rockdale Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5997988.71827 | 2097660.25448 | 37.739659985321495 | -122.449511768669 | (37.7396599853215, -122.449511768669) | |||
| 37962 | 37962 | 31466 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 512 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 35032 | 6002998.75397 | 2102141.19875 | 37.7522489444334 | -122.432509202251 | (37.7522489444334, -122.432509202251) | ||
| 38427 | 38427 | 213600 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994324.50306 | 2101547.6622200003 | 37.7501235325769 | -122.46246285419501 | (37.7501235325769, -122.462462854195) | |||
| 39453 | 39453 | 68949 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 726 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 4 | Permit Number 32938 | 5988844.72891 | 2110346.33242 | 37.7739652106004 | -122.48205650095699 | (37.7739652106004, -122.482056500957) | |
| 39823 | 39823 | 213412 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2295 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991244.48359 | 2099804.88144 | 37.7451604602052 | -122.472986563398 | (37.7451604602052, -122.472986563398) | |||
| 40188 | 40188 | 213362 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Elmhurst Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5991224.3842 | 2094533.07073 | 37.730684246775205 | -122.472671762002 | (37.7306842467752, -122.472671762002) | |||
| 41715 | 41715 | 52943 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 428 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 4 | Permit Number 48930 | 6000112.39427 | 2091327.92801 | 37.722394148651 | -122.44171469507299 | (37.722394148651, -122.441714695073) | |
| 41729 | 41729 | 135951 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3566 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997226.42135 | 2116056.02078 | 37.790126431251394 | -122.453475306653 | (37.7901264312514, -122.453475306653) | |||
| 41923 | 41923 | 213613 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 47 El Verano Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994697.15129 | 2094857.83515 | 37.7317763834666 | -122.460689482843 | (37.7317763834666, -122.460689482843) | |||
| 42344 | 42344 | 238318 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 23 Clover Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6000458.56738 | 2105088.99316 | 37.760198494491796 | -122.441505054123 | (37.7601984944918, -122.441505054123) | |||
| 43068 | 43068 | 196481 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2075 Palou Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6012348.976530001 | 2097093.78891 | 37.738915629056 | -122.399820067148 | (37.738915629056, -122.399820067148) | |||
| 43236 | 43236 | 50295 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3052 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 4 | Permit Number 47008 | 5990301.1325 | 2094963.1495599998 | 37.7318116476733 | -122.47589494839501 | (37.7318116476733, -122.475894948395) | |
| 43690 | 43690 | 135985 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91 Cedar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006979.98142 | 2114482.04959 | 37.7863589607546 | -122.419616971064 | (37.7863589607546, -122.419616971064) | |||
| 43768 | 43768 | 81737 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49969 | 5983468.0529 | 2111801.95258 | 37.7776477425111 | -122.500762690576 | (37.7776477425111, -122.500762690576) | |
| 44141 | 44141 | 88407 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009407.88363 | 2117347.72867 | 37.7943638829406 | -122.411419542685 | (37.7943638829406, -122.411419542685) | |
| 44379 | 44379 | 214636 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1254 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992710.27647 | 2106925.6088900003 | 37.7647968818831 | -122.46843611705299 | (37.7647968818831, -122.468436117053) | |||
| 45036 | 45036 | 214593 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1359 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993615.46246 | 2106240.58605 | 37.7629682319156 | -122.46525557650801 | (37.7629682319156, -122.465255576508) | |||
| 45503 | 45503 | 214551 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 904 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992951.517530001 | 2106656.3795 | 37.7640715804553 | -122.46758215319299 | (37.7640715804553, -122.467582153193) | |||
| 45639 | 45639 | 237145 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 47 Linda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005834.28826 | 2105246.67983 | 37.7609362605317 | -122.422924160421 | (37.7609362605317, -122.422924160421) | |||
| 45659 | 45659 | 238401 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 153 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001728.46337 | 2107942.5756599996 | 37.7681059985158 | -122.43731742486601 | (37.7681059985158, -122.437317424866) | |||
| 45705 | 45705 | 239520 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009174.2731800005 | 2097387.06102 | 37.739543394514705 | -122.41081747084299 | (37.7395433945147, -122.410817470843) | |||
| 45874 | 45874 | 213559 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Montecito Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996394.710419999 | 2094260.17076 | 37.7302328626481 | -122.45477754205099 | (37.7302328626481, -122.454777542051) | |||
| 46295 | 46295 | 213353 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 315 Bright St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993739.98906 | 2089300.2829200001 | 37.7164615783281 | -122.46359536864401 | (37.7164615783281, -122.463595368644) | |||
| 47842 | 47842 | 52649 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 46@ LAKE 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2006 12:00:00 AM | 4 | Permit Number 48733 | 5993970.1832 | 2115226.91418 | 37.787662738807605 | -122.46468131190001 | (37.7876627388076, -122.4646813119) | ||
| 48001 | 48001 | 239526 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 90 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009313.28362 | 2096939.56022 | 37.738322447926706 | -122.410305243092 | (37.7383224479267, -122.410305243092) | |||
| 48451 | 48451 | 239392 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4182 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002032.982890001 | 2101799.84301 | 37.7512568492269 | -122.43582456377199 | (37.7512568492269, -122.435824563772) | |||
| 48714 | 48714 | 238099 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 869 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007946.69375 | 2102872.98642 | 37.7545376102364 | -122.41545020157301 | (37.7545376102364, -122.415450201573) | |||
| 49073 | 49073 | 179123 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 332 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009698.7682 | 2094025.87435 | 37.730343691484705 | -122.40876691948401 | (37.7303436914847, -122.408766919484) | |||
| 49643 | 49643 | 214599 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1372 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993361.64911 | 2106161.3799 | 37.7627361123925 | -122.466127666177 | (37.7627361123925, -122.466127666177) | |||
| 50228 | 50228 | 238074 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007150.37364 | 2097131.4565700002 | 37.7387278712849 | -122.41779714071801 | (37.7387278712849, -122.417797140718) | |||
| 50905 | 50905 | 214533 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 755 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993378.22609 | 2106609.29475 | 37.763966925444606 | -122.466102883542 | (37.7639669254446, -122.466102883542) | |||
| 51565 | 51565 | 213609 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 439 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995965.41912 | 2096410.19135 | 37.736111664324795 | -122.45641705831699 | (37.7361116643248, -122.456417058317) | |||
| 52062 | 52062 | 179041 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2908 20th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5990269.38069 | 2095895.56899 | 37.734369993170795 | -122.476072795627 | (37.7343699931708, -122.476072795627) | |||
| 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) | |
| 52617 | 52617 | 238192 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3930 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003625.5701 | 2101885.45788 | 37.7515822653155 | -122.430323329856 | (37.7515822653155, -122.430323329856) | |||
| 53361 | 53361 | 214622 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1443 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992398.43059 | 2105617.15858 | 37.76118620548821 | -122.469419451044 | (37.7611862054882, -122.469419451044) | |||
| 53429 | 53429 | 237393 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3249 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007200.26558 | 2106129.0428400002 | 37.763436006193295 | -122.41826239419201 | (37.7634360061933, -122.418262394192) | |||
| 53666 | 53666 | 237053 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 123 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005912.27788 | 2106519.83607 | 37.76443644800921 | -122.42274490845301 | (37.7644364480092, -122.422744908453) | |||
| 54328 | 54328 | 214539 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 621 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993819.49237 | 2106624.0632700003 | 37.7640329239982 | -122.46457775927601 | (37.7640329239982, -122.464577759276) | |||
| 54370 | 54370 | 238412 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Hattie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000623.254480001 | 2105558.02265 | 37.761495715270904 | -122.44096912924499 | (37.7614957152709, -122.440969129245) | |||
| 54577 | 54577 | 238195 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3966 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003383.67863 | 2101872.83344 | 37.7515338970787 | -122.43115891964199 | (37.7515338970787, -122.431158919642) | |||
| 54929 | 54929 | 213632 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 235 Evelyn Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997843.93752 | 2098898.14021 | 37.7430506362943 | -122.450101555747 | (37.7430506362943, -122.450101555747) | |||
| 55825 | 55825 | 67395 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 755 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1992 12:00:00 AM | 4 | Permit Number 30892 | 5990662.93226 | 2110247.15301 | 37.7737984716316 | -122.47575985163 | (37.7737984716316, -122.47575985163) | |
| 55983 | 55983 | 238357 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 327 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003461.42121 | 2104463.75613 | 37.7586523620214 | -122.431074981444 | (37.7586523620214, -122.431074981444) | |||
| 56213 | 56213 | 213675 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 178 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001823.54146 | 2095259.6315400002 | 37.7332870610355 | -122.43608087414101 | (37.7332870610355, -122.436080874141) | |||
| 56430 | 56430 | 135998 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1043 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009470.07385 | 2116888.9827900003 | 37.7931077665596 | -122.411171935935 | (37.7931077665596, -122.411171935935) | |||
| 56503 | 56503 | 213593 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2042 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993205.21101 | 2101561.12228 | 37.7500959710504 | -122.46633437715201 | (37.7500959710504, -122.466334377152) | |||
| 56569 | 56569 | 213355 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 430 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992826.5059 | 2090512.32679 | 37.7197368804329 | -122.466840849243 | (37.7197368804329, -122.466840849243) | |||
| 56761 | 56761 | 213382 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1543 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996878.23561 | 2105885.03685 | 37.762179602025796 | -122.453945150266 | (37.7621796020258, -122.453945150266) | |||
| 56762 | 56762 | 49698 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 87@ TUCKER Alpha St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50825 | 6011117.29096 | 2088288.9421 | 37.7146706063491 | -122.403459407649 | (37.7146706063491, -122.403459407649) | |
| 56771 | 56771 | 238468 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 139 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002785.88822 | 2109064.42785 | 37.7712463852336 | -122.433740098024 | (37.7712463852336, -122.433740098024) | |||
| 57130 | 57130 | 92234 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 530 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52677 | 5982879.44866 | 2112163.93194 | 37.778607057674996 | -122.50282564106199 | (37.778607057675, -122.502825641062) |
| 57185 | 57185 | 119537 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 871 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5986635.90405 | 2110003.72423 | 37.772895790248 | -122.489671893334 | (37.772895790248, -122.489671893334) | |||
| 57869 | 57869 | 49452 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1483 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 4 | Permit Number 46386 | 6011771.85534 | 2101466.1696900004 | 37.7508890570981 | -122.402122808245 | (37.7508890570981, -122.402122808245) | |
| 58101 | 58101 | 196489 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Jack London Aly | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6014409.66856 | 2112518.16121 | 37.781382276221706 | -122.393774434946 | (37.7813822762217, -122.393774434946) | |||
| 58497 | 58497 | 179110 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 815 Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005507.996180001 | 2092102.1157099998 | 37.7248258525216 | -122.42311832767 | (37.7248258525216, -122.42311832767) | |||
| 59082 | 59082 | 46513 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2563 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | 4 | Permit Number 44679 | 6002506.83642 | 2116089.37205 | 37.790519274906 | -122.435207900427 | (37.790519274906, -122.435207900427) | ||
| 59327 | 59327 | 237119 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2112 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009543.7477 | 2104893.47773 | 37.760175059952104 | -122.41006977811001 | (37.7601750599521, -122.41006977811) | |||
| 59547 | 59547 | 237170 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1541 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008764.92252 | 2099786.5599 | 37.746108929296206 | -122.412402393769 | (37.7461089292962, -122.412402393769) | |||
| 60295 | 60295 | 214530 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 829 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993181.45103 | 2106600.0811 | 37.7639302726919 | -122.466782794395 | (37.7639302726919, -122.466782794395) | |||
| 60368 | 60368 | 69413 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 73 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33518 | 6001961.1999 | 2087395.4649599998 | 37.711701646594 | -122.43504269857 | (37.711701646594, -122.43504269857) | |
| 60536 | 60536 | 214519 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992317.04824 | 2106570.7861599997 | 37.763799911465 | -122.46977034493901 | (37.763799911465, -122.469770344939) | |||
| 60635 | 60635 | 238356 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 336 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003422.57978 | 2104501.9637599997 | 37.7587550700125 | -122.43121203991998 | (37.7587550700125, -122.43121203992) |
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");