Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19182 | 19182 | 4299 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4366 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001539.555819999 | 2100311.7976 | 37.747142989565 | -122.437424340763 | (37.747142989565, -122.437424340763) | ||
| 19279 | 19279 | 91934 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1115 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992339.241228 | 2106582.494136 | 37.7638333412086 | -122.46969443927 | (37.7638333412086, -122.46969443927) | ||
| 19442 | 19442 | 5816 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 949 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2009 12:00:00 AM | 3 | 3X3 | 6000363.39173 | 2099612.7288599997 | 37.745156576909 | -122.441441255331 | (37.745156576909, -122.441441255331) | ||
| 19460 | 19460 | 16615 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2016 12:00:00 AM | 3 | 3X3 | Permit Number 778956 | 6002889.7801 | 2107581.65027 | 37.7671809360695 | -122.433274762729 | (37.7671809360695, -122.433274762729) | |
| 19589 | 19589 | 4075 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3187 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6008490.22185 | 2100532.98453 | 37.748143025801 | -122.413405055098 | (37.748143025801, -122.413405055098) | ||
| 19764 | 19764 | 4267 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4182 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/1995 12:00:00 AM | 3 | 3X3 | 6002831.44442 | 2100380.32351 | 37.7474045070076 | -122.43296199290899 | (37.7474045070076, -122.432961992909) | ||
| 19895 | 19895 | 4295 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4342 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2003 12:00:00 AM | 3 | 3X3 | 6001671.89746 | 2100317.83526 | 37.7471670905043 | -122.436967147015 | (37.7471670905043, -122.436967147015) | ||
| 19906 | 19906 | 1353 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5999905.46078 | 2099295.02318 | 37.7442581344216 | -122.44300188482401 | (37.7442581344216, -122.443001884824) | |||
| 19981 | 19981 | 28779 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4065 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2004 12:00:00 AM | 3 | 3X3 | 6003498.496040001 | 2100372.77288 | 37.747421587832 | -122.430654836155 | (37.747421587832, -122.430654836155) | ||
| 20172 | 20172 | 4056 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2987 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1995 12:00:00 AM | 3 | 3x3 | 6009651.14757 | 2100536.83905 | 37.7482187235208 | -122.409390868191 | (37.7482187235208, -122.409390868191) | ||
| 20524 | 20524 | 26480 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2011 12:00:00 AM | 3 | 3x3 | 6001160.50342 | 2098677.8339 | 37.742634955228894 | -122.438618011821 | (37.7426349552289, -122.438618011821) | ||
| 20594 | 20594 | 4060 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3017 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/1998 12:00:00 AM | 3 | 3X3 | 6009461.72254 | 2100536.5932400003 | 37.7482074334345 | -122.410045879537 | (37.7482074334345, -122.410045879537) | ||
| 20694 | 20694 | 4134 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3550 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2000 12:00:00 AM | 3 | 3x3 | 6006304.68418 | 2100605.7275799997 | 37.7482198080922 | -122.42096774735901 | (37.7482198080922, -122.420967747359) | ||
| 20714 | 20714 | 12956 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 3 | 5x5 | 6001961.90749 | 2095766.9942400001 | 37.7346880222327 | -122.435638790816 | (37.7346880222327, -122.435638790816) | ||
| 20735 | 20735 | 1373 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 49 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/1999 12:00:00 AM | 3 | 1X1 | 5999002.70945 | 2100014.0540299998 | 37.7461809074259 | -122.446175104021 | (37.7461809074259, -122.446175104021) | ||
| 20763 | 20763 | 36 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 773 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003693.31613 | 2107706.2481400003 | 37.7675686032223 | -122.430504342717 | (37.7675686032223, -122.430504342717) | |||
| 20787 | 20787 | 4288 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4314 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001830.459 | 2100325.99082 | 37.7471984948291 | -122.436419438314 | (37.7471984948291, -122.436419438314) | ||
| 20828 | 20828 | 4100 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3321 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/2000 12:00:00 AM | 3 | 3x3 | 6007597.59872 | 2100526.27366 | 37.748074440783796 | -122.416491248692 | (37.7480744407838, -122.416491248692) | ||
| 20836 | 20836 | 4276 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4221 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1995 12:00:00 AM | 3 | 3x3 | 6002451.40883 | 2100314.3802 | 37.7472018789671 | -122.434271414787 | (37.7472018789671, -122.434271414787) | ||
| 20906 | 20906 | 89402 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1914 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5992725.997880001 | 2112086.29643 | 37.7789676550624 | -122.468757294436 | (37.7789676550624, -122.468757294436) | ||
| 21015 | 21015 | 19321 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/26/2010 12:00:00 AM | 3 | 3X3 | 5993639.27417 | 2089852.22483 | 37.7179712747243 | -122.46398352863001 | (37.7179712747243, -122.46398352863) | ||
| 21277 | 21277 | 4291 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4324 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001780.20994 | 2100324.37087 | 37.7471911914402 | -122.43659307941999 | (37.7471911914402, -122.43659307942) | ||
| 21329 | 21329 | 16625 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 143 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2007 12:00:00 AM | 3 | 3x3 | 6002893.733109999 | 2107470.63526 | 37.7668763401938 | -122.43325315650401 | (37.7668763401938, -122.433253156504) | ||
| 21356 | 21356 | 4210 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3932 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/05/2004 12:00:00 AM | 3 | 3X3 | 6004303.84786 | 2100460.14425 | 37.7477070821197 | -122.427876208032 | (37.7477070821197, -122.427876208032) | ||
| 21554 | 21554 | 10197 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2004 12:00:00 AM | 3 | 2X2 | 6005817.7414 | 2101914.20762 | 37.7517851334751 | -122.42274455772301 | (37.7517851334751, -122.422744557723) | ||
| 21660 | 21660 | 10102 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 771 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 3 | 2X2 | 6005674.239019999 | 2104513.09601 | 37.758912979273205 | -122.423425548652 | (37.7589129792732, -122.423425548652) | ||
| 21715 | 21715 | 4289 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4318 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001802.38664 | 2100324.70976 | 37.747193382168604 | -122.43651641850799 | (37.7471933821686, -122.436516418508) | ||
| 21989 | 21989 | 10059 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 481 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2010 12:00:00 AM | 3 | 3X3 | 6005579.31828 | 2106221.1938400003 | 37.763597655717504 | -122.42387528793002 | (37.7635976557175, -122.42387528793) | ||
| 22002 | 22002 | 4306 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4390 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001409.31695 | 2100304.12131 | 37.747114507137205 | -122.437874145675 | (37.7471145071372, -122.437874145675) | ||
| 22030 | 22030 | 4104 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3330 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1999 12:00:00 AM | 3 | 3X3 | 6007482.20732 | 2100611.45835 | 37.7483018487579 | -122.416896303343 | (37.7483018487579, -122.416896303343) | ||
| 22114 | 22114 | 10208 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1286 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/1991 12:00:00 AM | 3 | 2X2 | 6005769.15445 | 2101526.21369 | 37.750717050048706 | -122.422885005752 | (37.7507170500487, -122.422885005752) | ||
| 22261 | 22261 | 4054 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2957 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/1999 12:00:00 AM | 3 | 3X3 | 6009770.62771 | 2100537.88813 | 37.7482282977114 | -122.40897778170799 | (37.7482282977114, -122.408977781708) | ||
| 22921 | 22921 | 187655 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1548 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779523 | 6003789.0 | 2099328.0 | 37.744569337434 | -122.42957579341999 | (37.744569337434, -122.42957579342) | |
| 22957 | 22957 | 108702 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2382 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772586 | 6001605.971969999 | 2118381.98302 | 37.79676299019629 | -122.438489159966 | (37.7967629901963, -122.438489159966) |
| 22977 | 22977 | 109971 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1435 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2015 12:00:00 AM | 3 | 3x3 | 5999653.8 | 2113835.4 | 37.7841680297741 | -122.444917101722 | (37.7841680297741, -122.444917101722) | ||
| 22982 | 22982 | 106990 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1737-1795 Post St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2014 02:15:00 PM | 3 | 6003734.5 | 2114103.2 | 37.785135386369795 | -122.43081845921101 | (37.7851353863698, -122.430818459211) | |||
| 23327 | 23327 | 54378 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2105 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2013 12:00:00 AM | 3 | 0 | Permit Number 769000 | 6003486.81156 | 2117545.01589 | 37.7945717009834 | -122.43192123267401 | (37.7945717009834, -122.431921232674) | |
| 23601 | 23601 | 238482 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003589.43942 | 2108803.81702 | 37.7705763750292 | -122.430941979801 | (37.7705763750292, -122.430941979801) | |||
| 23779 | 23779 | 213682 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6000730.9848 | 2095013.8875 | 37.7325501736469 | -122.43984052053801 | (37.7325501736469, -122.439840520538) | |||
| 24090 | 24090 | 238060 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2x Montezuma St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6007260.48935 | 2099759.47356 | 37.7459500163869 | -122.417602623671 | (37.7459500163869, -122.417602623671) | |||
| 24591 | 24591 | 214612 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1333 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993302.748930001 | 2106373.33223 | 37.7633146795475 | -122.466346784179 | (37.7633146795475, -122.466346784179) | |||
| 24965 | 24965 | 213284 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 152 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994475.62527 | 2090947.51619 | 37.7210268472907 | -122.461171998816 | (37.7210268472907, -122.461171998816) | |||
| 25325 | 25325 | 213664 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Edgehill Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994722.94591 | 2098926.36641 | 37.7429490497558 | -122.460895067856 | (37.7429490497558, -122.460895067856) | |||
| 25585 | 25585 | 214545 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 712 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993540.20804 | 2106676.4015599997 | 37.7641605270218 | -122.465547516199 | (37.7641605270218, -122.465547516199) | |||
| 25624 | 25624 | 33992 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2034 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2013 12:00:00 AM | 3 | Permit Number 769995 | 6001444.58 | 2115566.6422 | 37.7890236150982 | -122.438845759727 | (37.7890236150982, -122.438845759727) | ||
| 26583 | 26583 | 213686 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 13 Melrose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6000083.84654 | 2095468.8539 | 37.7337625470113 | -122.44211047322901 | (37.7337625470113, -122.442110473229) | |||
| 26946 | 26946 | 238487 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Lily St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006307.1511699995 | 2110249.94796 | 37.774700718098394 | -122.42164409961 | (37.7747007180984, -122.42164409961) | |||
| 27276 | 27276 | 84392 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2101 Jerrold Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 3 | 6012504.257680001 | 2099077.65785 | 37.744371568599796 | -122.39942241122499 | (37.7443715685998, -122.399422411225) | ||
| 27309 | 27309 | 239553 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 119 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006419.09504 | 2098176.68739 | 37.7415566609206 | -122.42039973105801 | (37.7415566609206, -122.420399731058) | |||
| 27317 | 27317 | 45508 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2929 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 3 | Permit Number 44276 | 5988794.6572900005 | 2095738.11606 | 37.7338520448427 | -122.48115980898899 | (37.7338520448427, -122.481159808989) | |
| 27433 | 27433 | 239505 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 407 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008610.5608 | 2096828.12275 | 37.737977048001106 | -122.412727046317 | (37.7379770480011, -122.412727046317) | |||
| 27626 | 27626 | 67962 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 859 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 3 | Permit Number 31683 | 5986944.37754 | 2110090.6261299998 | 37.773152403641205 | -122.488611249777 | (37.7731524036412, -122.488611249777) | |
| 27750 | 27750 | 122272 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1620 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990523.26932 | 2111325.70202 | 37.7767517731765 | -122.476321762187 | (37.7767517731765, -122.476321762187) | |||
| 27793 | 27793 | 213495 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 613 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994845.468309999 | 2092391.05162 | 37.725011726204 | -122.45999808945 | (37.725011726204, -122.45999808945) | |||
| 28020 | 28020 | 213316 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Howth St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997165.98186 | 2090264.50059 | 37.7193059055324 | -122.451823029928 | (37.7193059055324, -122.451823029928) | |||
| 28173 | 28173 | 237442 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 682 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000862.680819999 | 2100906.70612 | 37.7487379614889 | -122.439807560394 | (37.7487379614889, -122.439807560394) | |||
| 28287 | 28287 | 214683 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 55 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992915.77843 | 2098808.5427900003 | 37.74252138525579 | -122.467135137076 | (37.7425213852558, -122.467135137076) | |||
| 28568 | 28568 | 214647 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 350 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5996480.71634 | 2106982.6463200003 | 37.765170556498205 | -122.455399340518 | (37.7651705564982, -122.455399340518) | |||
| 28678 | 28678 | 179035 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 178 Desmond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010379.06325 | 2086412.1514400002 | 37.709476057444796 | -122.40587891040899 | (37.7094760574448, -122.405878910409) | |||
| 28749 | 28749 | 213408 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2261 Cecilia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991501.450540001 | 2100021.96662 | 37.745771393951 | -122.47211384508101 | (37.745771393951, -122.472113845081) | |||
| 29313 | 29313 | 179001 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 500 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001827.054219999 | 2090687.03762 | 37.7207319560017 | -122.435741691253 | (37.7207319560017, -122.435741691253) | |||
| 29661 | 29661 | 179112 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 261 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006571.20289 | 2092730.1435099998 | 37.7266102225609 | -122.419487475869 | (37.7266102225609, -122.419487475869) | |||
| 29900 | 29900 | 213665 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 3ft | 5994824.1493 | 2098927.22664 | 37.7429572344905 | -122.460545199208 | (37.7429572344905, -122.460545199208) | |||
| 30234 | 30234 | 213394 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 850 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5990770.424 | 2101133.1430200003 | 37.7487800641525 | -122.47472269021002 | (37.7487800641525, -122.47472269021) | |||
| 30548 | 30548 | 45544 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 79 Riverton Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44297 | 5987024.26021 | 2095319.08797 | 37.732598422284205 | -122.48724975796301 | (37.7325984222842, -122.487249757963) | |
| 30750 | 30750 | 213598 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 128 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994427.44461 | 2101171.23368 | 37.749095882669295 | -122.462079583807 | (37.7490958826693, -122.462079583807) | |||
| 31016 | 31016 | 238039 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 89 Elgin Park | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6005843.94387 | 2108584.75014 | 37.7701023549756 | -122.423128042119 | (37.7701023549756, -122.423128042119) | |||
| 31155 | 31155 | 87154 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50137 | 5992080.87589 | 2114715.15142 | 37.7861484784179 | -122.47118058793998 | (37.7861484784179, -122.47118058794) | |
| 31216 | 31216 | 213440 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2319 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991023.406330001 | 2099608.90148 | 37.74460954810829 | -122.47373670861 | (37.7446095481083, -122.47373670861) | |||
| 31476 | 31476 | 179124 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Somerset St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009979.33211 | 2092867.06279 | 37.727177550003205 | -122.40771529004101 | (37.7271775500032, -122.407715290041) | |||
| 31565 | 31565 | 238486 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Lily St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006336.802730001 | 2110252.01922 | 37.774708077239794 | -122.421541675834 | (37.7747080772398, -122.421541675834) | |||
| 31826 | 31826 | 88412 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009452.7788 | 2116769.6537 | 37.792779147992796 | -122.411223344786 | (37.7927791479928, -122.411223344786) | |
| 32250 | 32250 | 178990 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 342 Oneida Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5999327.15458 | 2091397.10095 | 37.7225393091341 | -122.44443404622 | (37.7225393091341, -122.44443404622) | |||
| 32271 | 32271 | 237025 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Octavia St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 6ft | 6005760.04076 | 2109480.81274 | 37.7725579925006 | -122.423481975714 | (37.7725579925006, -122.423481975714) | |||
| 32482 | 32482 | 237157 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 944 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6010187.69815 | 2103705.30637 | 37.7569486800479 | -122.407758866688 | (37.7569486800479, -122.407758866688) | |||
| 32529 | 32529 | 120326 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 738 23rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 2ft | 5988846.16685 | 2110288.25768 | 37.773805837099 | -122.48204727167901 | (37.773805837099, -122.482047271679) | |||
| 32603 | 32603 | 214680 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 529 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993021.81014 | 2099410.76453 | 37.7441810535062 | -122.46681228227501 | (37.7441810535062, -122.466812282275) | |||
| 33154 | 33154 | 196457 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Cesar Chavez St | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012824.47283 | 2101012.7675799998 | 37.7497028090569 | -122.398450923095 | (37.7497028090569, -122.398450923095) | |||
| 33311 | 33311 | 124175 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5995849.29862 | 2112517.39926 | 37.7803312891441 | -122.45798382080099 | (37.7803312891441, -122.457983820801) | |||
| 33430 | 33430 | 239425 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 415 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001523.27772 | 2103394.61139 | 37.7556067332821 | -122.43770138051501 | (37.7556067332821, -122.437701380515) | |||
| 33753 | 33753 | 47399 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 627 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 3 | Permit Number 45310 | 5994686.98675 | 2111235.69119 | 37.776745212476705 | -122.461911800485 | (37.7767452124767, -122.461911800485) | |
| 33821 | 33821 | 213667 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 3ft | 5994852.48941 | 2098936.7686799997 | 37.7429850649213 | -122.46044789885401 | (37.7429850649213, -122.460447898854) | |||
| 34225 | 34225 | 213687 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 375 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5999599.32431 | 2094947.53041 | 37.7323034904989 | -122.443748164757 | (37.7323034904989, -122.443748164757) | |||
| 34475 | 34475 | 237398 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1345 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005860.83532 | 2101136.51471 | 37.749652198785704 | -122.422540276735 | (37.7496521987857, -122.422540276735) | |||
| 34957 | 34957 | 214766 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993866.28574 | 2101627.27037 | 37.7503157185921 | -122.464053162237 | (37.7503157185921, -122.464053162237) | |||
| 35007 | 35007 | 213475 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994274.0259300005 | 2098747.57141 | 37.7424322822248 | -122.46243433218201 | (37.7424322822248, -122.462434332182) | |||
| 35301 | 35301 | 214617 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1385 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993312.95617 | 2106045.0582 | 37.7624139140953 | -122.46628762228 | (37.7624139140953, -122.46628762228) | |||
| 35880 | 35880 | 179128 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Somerset St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009952.22714 | 2092954.05683 | 37.727414899966504 | -122.407815123785 | (37.7274148999665, -122.407815123785) | |||
| 36267 | 36267 | 214778 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1725 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5992728.97885 | 2095354.01208 | 37.7330253277621 | -122.467529868417 | (37.7330253277621, -122.467529868417) | |||
| 36390 | 36390 | 238190 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3904 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003741.74395 | 2101892.1967 | 37.7516073483179 | -122.429922066763 | (37.7516073483179, -122.429922066763) | |||
| 37055 | 37055 | 214500 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1933 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5992834.07498 | 2102380.33006 | 37.7523238831472 | -122.467677346446 | (37.7523238831472, -122.467677346446) | |||
| 37098 | 37098 | 37620 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 630 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 3 | Permit Number 40044 | 5990677.73899 | 2111070.74016 | 37.7760606748146 | -122.47576878804199 | (37.7760606748146, -122.475768788042) | |
| 37338 | 37338 | 238201 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3998 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003254.23396 | 2101860.98354 | 37.7514940238505 | -122.43160570915701 | (37.7514940238505, -122.431605709157) | |||
| 37511 | 37511 | 114854 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1416x Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006727.45782 | 2115352.7364 | 37.788735424647 | -122.420552468331 | (37.788735424647, -122.420552468331) | |||
| 37553 | 37553 | 87825 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 451 47th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3 | 2x3 | Permit Number 50716 | 5981267.84329 | 2112567.4887599996 | 37.7796202589611 | -122.508430668506 | (37.7796202589611, -122.508430668506) | |
| 37916 | 37916 | 124377 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 43 Jordan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5996171.6686 | 2114245.1499900003 | 37.7850937492478 | -122.45699360696501 | (37.7850937492478, -122.456993606965) | |||
| 37981 | 37981 | 213375 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1239 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993278.62034 | 2107063.27366 | 37.7652076850186 | -122.466480385674 | (37.7652076850186, -122.466480385674) | |||
| 37984 | 37984 | 237159 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 952 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010190.97123 | 2103671.66986 | 37.7568565049508 | -122.407745175399 | (37.7568565049508, -122.407745175399) | |||
| 38328 | 38328 | 213300 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 729 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5994737.406330001 | 2089905.17069 | 37.7181798769692 | -122.46019162623699 | (37.7181798769692, -122.460191626237) | |||
| 38594 | 38594 | 214646 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1266 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5993643.69211 | 2106877.8728099996 | 37.764719682297894 | -122.46520423240801 | (37.7647196822979, -122.465204232408) |
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");