Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187604 | 187604 | 213526 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 54 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995666.10329 | 2092922.0821200002 | 37.72651697277671 | -122.457199659138 | (37.7265169727767, -122.457199659138) | |||
| 187355 | 187355 | 50504 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 671 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 9 | Permit Number 47140 | 6001297.56946 | 2089761.94857 | 37.7181617790314 | -122.437505740198 | (37.7181617790314, -122.437505740198) | |
| 185226 | 185226 | 238386 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 65 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002028.57432 | 2105508.39612 | 37.7614393934265 | -122.43610516394301 | (37.7614393934265, -122.436105163943) | |||
| 185087 | 185087 | 70501 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 75 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 9 | 6004654.404130001 | 2093072.1677599999 | 37.72744119435129 | -122.42613812337 | (37.7274411943513, -122.42613812337) | ||
| 184937 | 184937 | 36732 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 9 | Permit Number 39511 | 6014611.904019999 | 2112877.2892299998 | 37.7823795964711 | -122.393099929045 | (37.7823795964711, -122.393099929045) | |
| 184483 | 184483 | 237163 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009249.65239 | 2099454.9972599996 | 37.7452257212815 | -122.410702842362 | (37.7452257212815, -122.410702842362) | |||
| 184173 | 184173 | 214724 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 Miramar Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995334.30904 | 2093270.0825 | 37.7274534368222 | -122.458371829198 | (37.7274534368222, -122.458371829198) | |||
| 183916 | 183916 | 179084 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 27 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6004500.91436 | 2093334.46115 | 37.7281527172689 | -122.42668740860901 | (37.7281527172689, -122.426687408609) | |||
| 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) | |
| 181685 | 181685 | 238036 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1345 Stevenson St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6006282.85406 | 2108818.1643 | 37.77076801336371 | -122.421626435124 | (37.7707680133637, -122.421626435124) | |||
| 181383 | 181383 | 238200 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3980 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003293.55564 | 2101869.5981799997 | 37.751519906332895 | -122.43147034498999 | (37.7515199063329, -122.43147034499) | |||
| 179705 | 179705 | 70127 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 236 Avalon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 9 | 6003416.21624 | 2092787.3454599997 | 37.726589075011894 | -122.430398228113 | (37.7265890750119, -122.430398228113) | ||
| 178775 | 178775 | 238261 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4060 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002607.1830400005 | 2104755.89921 | 37.7594060739501 | -122.43405020584999 | (37.7594060739501, -122.43405020585) | |||
| 178476 | 178476 | 43281 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 731 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 9 | Permit Number 43050 | 6009296.58944 | 2092411.7929900002 | 37.725889231602395 | -122.410043408191 | (37.7258892316024, -122.410043408191) | |
| 175428 | 175428 | 179005 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 500 Paris St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6001802.30971 | 2090646.62638 | 37.7206195902147 | -122.435824335343 | (37.7206195902147, -122.435824335343) | |||
| 175268 | 175268 | 213644 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5999501.838169999 | 2096096.8027 | 37.7354535611166 | -122.44416774976001 | (37.7354535611166, -122.44416774976) | |||
| 174760 | 174760 | 237341 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 243 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006870.36192 | 2096612.0084799998 | 37.7372858200831 | -122.418728463366 | (37.7372858200831, -122.418728463366) | |||
| 174583 | 174583 | 196509 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Matthew Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6017994.96949 | 2094236.9761 | 37.731384523654704 | -122.380100165912 | (37.7313845236547, -122.380100165912) | |||
| 170518 | 170518 | 213299 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 745 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5994590.06389 | 2089907.66357 | 37.7181782455958 | -122.46070110299401 | (37.7181782455958, -122.460701102994) | |||
| 169720 | 169720 | 239500 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 129 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008306.86121 | 2097792.18102 | 37.7406070901435 | -122.41384526427099 | (37.7406070901435, -122.413845264271) | |||
| 167681 | 167681 | 237432 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1204 Diamond St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6001926.67486 | 2100538.92391 | 37.7477886254592 | -122.436101966853 | (37.7477886254592, -122.436101966853) | ||||
| 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) | |||
| 162878 | 162878 | 179044 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 185 Rousseau St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003599.63308 | 2094623.16042 | 37.7316401991384 | -122.429895054706 | (37.7316401991384, -122.429895054706) | |||
| 160555 | 160555 | 237373 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009218.81749 | 2102679.40367 | 37.7540774954946 | -122.41103717251998 | (37.7540774954946, -122.41103717252) | |||
| 158713 | 158713 | 237322 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 33 Bronte St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6009369.40904 | 2097222.26631 | 37.7391018435688 | -122.410131141556 | (37.7391018435688, -122.410131141556) | |||
| 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) | ||
| 156239 | 156239 | 213510 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 154 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995679.789 | 2093745.03939 | 37.728777401642 | -122.457211854858 | (37.728777401642, -122.457211854858) | |||
| 154946 | 154946 | 239468 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 163 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5997553.16556 | 2107080.05988 | 37.7654995069206 | -122.451697043888 | (37.7654995069206, -122.451697043888) | |||
| 154441 | 154441 | 237326 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 63 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 1ft | 6007291.38561 | 2099119.3862900003 | 37.744194218700294 | -122.417450433195 | (37.7441942187003, -122.417450433195) | |||
| 153510 | 153510 | 179083 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 31 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004487.94293 | 2093313.4408200001 | 37.7280942667373 | -122.426730755029 | (37.7280942667373, -122.426730755029) | |||
| 153192 | 153192 | 238481 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 140 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003606.4439900005 | 2108831.51888 | 37.7706534010546 | -122.43088513814199 | (37.7706534010546, -122.430885138142) | |||
| 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) | |
| 149523 | 149523 | 179051 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 81 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000564.26285 | 2092887.9227099998 | 37.7267032736144 | -122.440264511299 | (37.7267032736144, -122.440264511299) | |||
| 148749 | 148749 | 237175 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1526 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009304.4397599995 | 2100402.9931 | 37.7478317803246 | -122.410580327728 | (37.7478317803246, -122.410580327728) | |||
| 148683 | 148683 | 46833 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 471 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | 9 | Permit Number 44906 | 6002821.93172 | 2091174.08119 | 37.7221257307043 | -122.4323374767 | (37.7221257307043, -122.4323374767) | |
| 148552 | 148552 | 237066 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3425 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006736.51306 | 2100522.37025 | 37.7480152599946 | -122.41946858020701 | (37.7480152599946, -122.419468580207) | |||
| 135742 | 135742 | 239398 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 204 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000596.07239 | 2102206.68161 | 37.752292201824396 | -122.440822727712 | (37.7522922018244, -122.440822727712) | |||
| 135376 | 135376 | 237347 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 207 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008785.61167 | 2097659.00145 | 37.7402682831545 | -122.412180513039 | (37.7402682831545, -122.412180513039) | |||
| 135345 | 135345 | 238107 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 149 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6006184.05234 | 2102126.82183 | 37.752389584027796 | -122.42149290108601 | (37.7523895840278, -122.421492901086) | |||
| 135228 | 135228 | 237060 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 199 Tiffany Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6006047.428119999 | 2099152.06421 | 37.7442138742778 | -122.421754094776 | (37.7442138742778, -122.421754094776) | |||
| 134623 | 134623 | 237323 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 85 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009349.15826 | 2096986.9873 | 37.7384546833378 | -122.410184553188 | (37.7384546833378, -122.410184553188) | |||
| 133940 | 133940 | 32103 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 237 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 9 | Permit Number 35475 | 6002723.82147 | 2104526.537 | 37.7587829193134 | -122.43363042122101 | (37.7587829193134, -122.433630421221) | |
| 133729 | 133729 | 239375 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4407 24th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6000535.569069999 | 2101672.81424 | 37.750822884967704 | -122.440993660945 | (37.7508228849677, -122.440993660945) | |||
| 132632 | 132632 | 66574 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 275 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | 9 | Permit Number 29764 | 6005180.346969999 | 2093822.91903 | 37.729532304260104 | -122.42437331088199 | (37.7295323042601, -122.424373310882) | |
| 132153 | 132153 | 238242 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 185 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003074.67279 | 2105029.92031 | 37.760184990255794 | -122.432452970336 | (37.7601849902558, -122.432452970336) | |||
| 131819 | 131819 | 38505 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1123 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1998 12:00:00 AM | 9 | Permit Number 40496 | 6008719.38643 | 2117949.78915 | 37.795978352179205 | -122.41384444046699 | (37.7959783521792, -122.413844440467) | ||
| 130692 | 130692 | 178998 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 800 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001820.55644 | 2089152.21762 | 37.7165173138053 | -122.435654403046 | (37.7165173138053, -122.435654403046) | |||
| 129624 | 129624 | 179067 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Meda Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000191.90379 | 2091755.2266900002 | 37.723571943081204 | -122.441470496792 | (37.7235719430812, -122.441470496792) | |||
| 122954 | 122954 | 214793 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 283 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995486.378930001 | 2097483.8393599996 | 37.739032125438 | -122.45815096470801 | (37.739032125438, -122.458150964708) | |||
| 117358 | 117358 | 51015 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 168 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | 9 | 3x3 | Permit Number 48063 | 6005440.48678199 | 2099065.68713562 | 37.7439424571986 | -122.42384662792699 | (37.7439424571986, -122.423846627927) | |
| 82005 | 82005 | 52014 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301X 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/12/2005 12:00:00 AM | 9 | 3x3 | Permit Number 48233 | 6004302.0 | 2098976.0 | 37.7436318598049 | -122.427776865938 | (37.7436318598049, -122.427776865938) | |
| 76634 | 76634 | 237056 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Albion St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6005793.31637 | 2107190.9812 | 37.7662725407724 | -122.423204074428 | (37.7662725407724, -122.423204074428) | |||
| 76359 | 76359 | 80388 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1746 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 9 | 6011768.66094 | 2092717.74347 | 37.7268675545821 | -122.401519069956 | (37.7268675545821, -122.401519069956) | ||
| 76291 | 76291 | 213654 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Edgehill Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994824.078840001 | 2099066.74247 | 37.7433403061049 | -122.460555550413 | (37.7433403061049, -122.460555550413) | |||
| 76097 | 76097 | 214678 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2682 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991462.8798400005 | 2097179.7313200003 | 37.7379651112972 | -122.47204008897499 | (37.7379651112972, -122.472040088975) | |||
| 74662 | 74662 | 179015 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 570 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003097.37584 | 2090169.87122 | 37.7193840071539 | -122.431313686676 | (37.7193840071539, -122.431313686676) | |||
| 72377 | 72377 | 238330 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 246 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002691.78046 | 2104466.49417 | 37.7586162380656 | -122.43373694232099 | (37.7586162380656, -122.433736942321) | |||
| 72023 | 72023 | 40646 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 108 Congdon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 9 | Permit Number 41644 | 6004664.1042599995 | 2094195.33475 | 37.7305257097718 | -122.426184517611 | (37.7305257097718, -122.426184517611) | |
| 71686 | 71686 | 237107 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | 9 | Width 4ft | Permit Number 39047 | 6006621.1232900005 | 2105778.70866 | 37.7624414540443 | -122.42024059875 | (37.7624414540443, -122.42024059875) | |
| 70102 | 70102 | 44491 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 55 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 9 | Permit Number 45395 | 6005461.21441 | 2093276.5457799998 | 37.728047939957 | -122.42336349723499 | (37.728047939957, -122.423363497235) | |
| 68841 | 68841 | 196464 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Cesar Chavez St | 6 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6015016.3527 | 2101061.7401099997 | 37.7499591392145 | -122.390874677125 | (37.7499591392145, -122.390874677125) | |||
| 68733 | 68733 | 31023 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 330 Naylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34788 | 6002794.80361 | 2086503.3822400002 | 37.7092994800486 | -122.43209787574 | (37.7092994800486, -122.43209787574) | |
| 67770 | 67770 | 213506 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 170 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995645.91598 | 2093857.2294299998 | 37.7290835029864 | -122.457337068356 | (37.7290835029864, -122.457337068356) | |||
| 67636 | 67636 | 237305 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 185 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008838.31822 | 2097699.45702 | 37.7403823225842 | -122.412001132442 | (37.7403823225842, -122.412001132442) | |||
| 66508 | 66508 | 246474 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 312 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004388.68199 | 2099882.3051 | 37.746125268169706 | -122.42754169531601 | (37.7461252681697, -122.427541695316) | |||
| 64645 | 64645 | 213553 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 119 Valdez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5996273.88735 | 2094337.4099 | 37.730438011494996 | -122.455200820562 | (37.730438011495, -122.455200820562) | |||
| 62895 | 62895 | 40654 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Congdon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | 9 | Permit Number 47919 | 6004685.50571 | 2093693.1599299998 | 37.7291480590261 | -122.426074794035 | (37.7291480590261, -122.426074794035) | |
| 62829 | 62829 | 237383 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 827 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007380.0217699995 | 2102480.66392 | 37.75342851503579 | -122.417382106324 | (37.7534285150358, -122.417382106324) | |||
| 62091 | 62091 | 214816 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 655 Hearst Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 5997091.21284 | 2094378.0504 | 37.7305964594612 | -122.452378156221 | (37.7305964594612, -122.452378156221) | |||
| 61681 | 61681 | 239417 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1386 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6003241.87066 | 2100172.27936 | 37.746856537504705 | -122.43152791778799 | (37.7468565375047, -122.431527917788) | |||
| 61622 | 61622 | 179071 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 315 Delano Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999909.366830001 | 2092009.96893 | 37.724255306416296 | -122.44246545454399 | (37.7242553064163, -122.442465454544) | |||
| 61123 | 61123 | 213601 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994302.03638 | 2101543.53453 | 37.7501109051904 | -122.462540245329 | (37.7501109051904, -122.462540245329) | |||
| 61082 | 61082 | 237312 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 275 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008994.00868 | 2097057.18443 | 37.73862751595421 | -122.411417450854 | (37.7386275159542, -122.411417450854) | |||
| 60872 | 60872 | 213416 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2493 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991370.65568 | 2098470.68683 | 37.7415044084939 | -122.472453037893 | (37.7415044084939, -122.472453037893) | |||
| 60431 | 60431 | 238505 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Wilder St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002715.93525 | 2095546.35382 | 37.7341249935801 | -122.43301610421801 | (37.7341249935801, -122.433016104218) | |||
| 60122 | 60122 | 213603 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Sotelo Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994000.56505 | 2100962.8135 | 37.74849902692429 | -122.46354060263701 | (37.7484990269243, -122.463540602637) | |||
| 60065 | 60065 | 65973 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2245 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1990 12:00:00 AM | 9 | Permit Number 28997 | 5988612.04832 | 2110519.74016 | 37.7744278044001 | -122.48287408378 | (37.7744278044001, -122.48287408378) | ||
| 59592 | 59592 | 68878 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 535 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 9 | Permit Number 32849 | 5994664.33554 | 2111876.7239 | 37.778504013274 | -122.462036654628 | (37.778504013274, -122.462036654628) | |
| 59162 | 59162 | 67443 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 161 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1992 12:00:00 AM | 9 | Permit Number 30946 | 5994572.42148 | 2114474.4165 | 37.785631285707105 | -122.46254309514099 | (37.7856312857071, -122.462543095141) | ||
| 58971 | 58971 | 213698 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 54 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5999705.61228 | 2093800.4183 | 37.7291598500291 | -122.443298341854 | (37.7291598500291, -122.443298341854) | |||
| 58434 | 58434 | 135942 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 420 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998162.588409999 | 2115059.8609 | 37.7874448588433 | -122.450164425556 | (37.7874448588433, -122.450164425556) | |||
| 57336 | 57336 | 214818 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 143 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6000452.08249 | 2094337.12961 | 37.7306760737326 | -122.44075622284201 | (37.7306760737326, -122.440756222842) | |||
| 56167 | 56167 | 214822 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 481 Flood Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997551.672230001 | 2094088.1550099999 | 37.729826844818504 | -122.450765393012 | (37.7298268448185, -122.450765393012) | |||
| 55558 | 55558 | 239549 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 511 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006925.075680001 | 2097949.2793900003 | 37.740960749435295 | -122.41863409569099 | (37.7409607494353, -122.418634095691) | |||
| 52973 | 52973 | 238319 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 143 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000024.20764 | 2104904.5196 | 37.7596672199772 | -122.442994046358 | (37.7596672199772, -122.442994046358) | |||
| 52472 | 52472 | 213543 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 175 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5996110.621719999 | 2094080.6199 | 37.7297235594719 | -122.45574669468 | (37.7297235594719, -122.45574669468) | |||
| 50146 | 50146 | 214726 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 Southwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995147.95146 | 2092472.32767 | 37.7252522831394 | -122.458958327485 | (37.7252522831394, -122.458958327485) | |||
| 49985 | 49985 | 31912 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2256 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 9 | Permit Number 35336 | 5991754.81336 | 2100091.67364 | 37.745977450207 | -122.47124283909099 | (37.745977450207, -122.471242839091) | |
| 46283 | 46283 | 31905 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2259 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 9 | Permit Number 35330 | 5991969.67434 | 2100068.6545599997 | 37.7459266717829 | -122.47049820945 | (37.7459266717829, -122.47049820945) | |
| 45488 | 45488 | 238055 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 438 Lily St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6004413.04242 | 2109984.42979 | 37.7738646822544 | -122.428177279482 | (37.7738646822544, -122.428177279482) | |||
| 45412 | 45412 | 239546 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 234 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007043.97235 | 2097599.78307 | 37.7400078035106 | -122.418198221295 | (37.7400078035106, -122.418198221295) | |||
| 45333 | 45333 | 237311 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 273 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008997.34657 | 2097088.95234 | 37.7387149309411 | -122.411408153666 | (37.7387149309411, -122.411408153666) | |||
| 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) | |||
| 43698 | 43698 | 214744 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 143 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995639.7235199995 | 2093649.0582299998 | 37.7285115593587 | -122.457343422077 | (37.7285115593587, -122.457343422077) | |||
| 43648 | 43648 | 239467 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1285 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 5997501.9107 | 2105032.0283 | 37.7598731953164 | -122.451726570432 | (37.7598731953164, -122.451726570432) | |||
| 43020 | 43020 | 238528 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 28 Harry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6003301.9628099995 | 2097731.40275 | 37.740157861699295 | -122.431145932563 | (37.7401578616993, -122.431145932563) | |||
| 42081 | 42081 | 214792 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 285 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995449.681340001 | 2097473.05136 | 37.7390003955387 | -122.45827706673 | (37.7390003955387, -122.45827706673) | |||
| 40366 | 40366 | 237376 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1065 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009202.551580001 | 2102951.7552400003 | 37.7548243995487 | -122.41111266074199 | (37.7548243995487, -122.411112660742) | |||
| 39930 | 39930 | 237223 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 478 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003374.63036 | 2100117.4180099997 | 37.7467134247776 | -122.431064932422 | (37.7467134247776, -122.431064932422) | |||
| 39904 | 39904 | 238093 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1128 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009186.03745 | 2102591.03497 | 37.7538330166071 | -122.411144292581 | (37.7538330166071, -122.411144292581) |
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");