Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189090 | 189090 | 238416 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 68 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001018.956780001 | 2106039.93414 | 37.7628414553775 | -122.439635110868 | (37.7628414553775, -122.439635110868) | |||
| 189048 | 189048 | 95921 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 275 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767619 | 5988991.254980001 | 2113497.8107 | 37.782626811071296 | -122.48178053312701 | (37.7826268110713, -122.481780533127) |
| 188763 | 188763 | 213318 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 347 Howth St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997130.27848 | 2090199.39045 | 37.7191250833297 | -122.45194174763 | (37.7191250833297, -122.45194174763) | |||
| 188706 | 188706 | 98034 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1817 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768344 | 5999961.07212 | 2115342.88884 | 37.788324733938396 | -122.44396240304899 | (37.7883247339384, -122.443962403049) | |
| 188578 | 188578 | 213560 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996382.63845 | 2094254.1039 | 37.7302155120395 | -122.454818838046 | (37.7302155120395, -122.454818838046) | |||
| 188545 | 188545 | 214625 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1449 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5992706.45428 | 2105582.72685 | 37.7611094609571 | -122.46835163292 | (37.7611094609571, -122.46835163292) | |||
| 188228 | 188228 | 237211 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 144 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004988.02286 | 2098744.77183 | 37.743035743513 | -122.42538831273701 | (37.743035743513, -122.425388312737) | |||
| 187658 | 187658 | 92257 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 862 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52706 | 5981411.16308 | 2109852.88199 | 37.7721751933845 | -122.50773337462299 | (37.7721751933845, -122.507733374623) | |
| 187125 | 187125 | 214605 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1336 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993356.31377 | 2106389.87121 | 37.76336318179771 | -122.46616272445499 | (37.7633631817977, -122.466162724455) | |||
| 186975 | 186975 | 119011 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 501 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5982518.7729400005 | 2112266.03771 | 37.778866206576794 | -122.504080901039 | (37.7788662065768, -122.504080901039) | |||
| 186659 | 186659 | 94703 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 658 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53843 | 5992262.68777 | 2110962.91491 | 37.77585637803789 | -122.470278225754 | (37.7758563780379, -122.470278225754) |
| 186651 | 186651 | 96029 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 730 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767669 | 6007514.32648 | 2113867.32169 | 37.78470115228 | -122.417724680544 | (37.78470115228, -122.417724680544) |
| 186346 | 186346 | 238431 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 308 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999560.07225 | 2105167.63212 | 37.760363188228396 | -122.444618165306 | (37.7603631882284, -122.444618165306) | |||
| 186273 | 186273 | 237139 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1333 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010091.8415 | 2101431.32988 | 37.75069948002071 | -122.407930023866 | (37.7506994800207, -122.407930023866) | |||
| 186097 | 186097 | 214552 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 910 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992905.53931 | 2106654.87937 | 37.764064806773206 | -122.46774106792 | (37.7640648067732, -122.46774106792) | |||
| 186096 | 186096 | 246690 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 51 Stoneman St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6008005.33416 | 2099391.14992 | 37.7449805661161 | -122.41500097851002 | (37.7449805661161, -122.41500097851) | ||||
| 185931 | 185931 | 118627 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 494 46th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5981628.0956 | 2112437.91019 | 37.7792856992778 | -122.50717480668301 | (37.7792856992778, -122.507174806683) | |||
| 185578 | 185578 | 214698 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 550 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 5994208.796569999 | 2099551.1927 | 37.7446350681495 | -122.46271815822901 | (37.7446350681495, -122.462718158229) | |||
| 185392 | 185392 | 238527 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6004847.1355800005 | 2097543.60322 | 37.7397296468092 | -122.425789984144 | (37.7397296468092, -122.425789984144) | |||
| 185251 | 185251 | 213304 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 252 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994495.39623 | 2087783.3442799998 | 37.71233992151021 | -122.460874450904 | (37.7123399215102, -122.460874450904) | |||
| 185167 | 185167 | 238180 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1309 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002576.2436 | 2101693.56325 | 37.7509958749713 | -122.433938314014 | (37.7509958749713, -122.433938314014) | |||
| 185006 | 185006 | 52876 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 118@ BEACH Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2006 12:00:00 AM | 3 | Permit Number 48887 | 6001354.74762 | 2121139.05445 | 37.8043188860645 | -122.439556198976 | (37.8043188860645, -122.439556198976) | ||
| 184812 | 184812 | 94696 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2443 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53831 | 5987889.1247 | 2113258.0139599997 | 37.7819042437171 | -122.48557577955201 | (37.7819042437171, -122.485575779552) |
| 184698 | 184698 | 213460 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 360 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5992857.49918 | 2099683.78553 | 37.7449212153419 | -122.46740027790199 | (37.7449212153419, -122.467400277902) | |||
| 184687 | 184687 | 238475 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 381 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003837.74726 | 2108996.21108 | 37.771118708489794 | -122.430096807715 | (37.7711187084898, -122.430096807715) | |||
| 184592 | 184592 | 214611 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1327 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993298.90225 | 2106431.45371 | 37.763474043919295 | -122.466364312861 | (37.7634740439193, -122.466364312861) | |||
| 184337 | 184337 | 118091 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6909 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5985501.15731 | 2112457.22496 | 37.779566085611 | -122.493777893955 | (37.779566085611, -122.493777893955) | |||
| 184323 | 184323 | 45553 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 168 Sylvan Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44300 | 5987588.08064 | 2094826.81646 | 37.7312796348483 | -122.485264410152 | (37.7312796348483, -122.485264410152) | |
| 184160 | 184160 | 45526 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3001 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/2001 12:00:00 AM | 3 | Permit Number 44287 | 5988554.87545 | 2095154.91197 | 37.732236774288396 | -122.481946089834 | (37.7322367742884, -122.481946089834) | |
| 184114 | 184114 | 218215 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 126 Lenox Way | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5993412.17188 | 2098613.00635 | 37.74201313250371 | -122.465404568079 | (37.7420131325037, -122.465404568079) | |||
| 183965 | 183965 | 120704 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 21st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5989296.74954 | 2115035.23836 | 37.7868659147395 | -122.48083626004299 | (37.7868659147395, -122.480836260043) | |||
| 183510 | 183510 | 238491 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 151 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006355.34413 | 2110387.19122 | 37.7750802724623 | -122.42148713912901 | (37.7750802724623, -122.421487139129) | |||
| 183477 | 183477 | 179148 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004516.54682 | 2091330.1429599999 | 37.722650185652 | -122.426490709795 | (37.722650185652, -122.426490709795) | |||
| 183294 | 183294 | 237062 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 189 Tiffany Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6006064.26727 | 2099183.21264 | 37.7443003503954 | -122.421698080498 | (37.7443003503954, -122.421698080498) | |||
| 183055 | 183055 | 179125 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Somerset St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009972.5795599995 | 2092885.80828 | 37.7272286431674 | -122.407739954855 | (37.7272286431674, -122.407739954855) | |||
| 183052 | 183052 | 135918 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2355 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001698.12763 | 2118353.2977299998 | 37.7966894695005 | -122.43816822489799 | (37.7966894695005, -122.438168224898) | |||
| 182583 | 182583 | 237382 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 223 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007180.72487 | 2106080.52677 | 37.7633016924289 | -122.41832653924999 | (37.7633016924289, -122.41832653925) | |||
| 181957 | 181957 | 238070 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 23 Newman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007003.04935 | 2096826.4026799998 | 37.7378819689729 | -122.41828489702499 | (37.7378819689729, -122.418284897025) | |||
| 181943 | 181943 | 119012 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 501 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5982519.09297 | 2112280.9796700003 | 37.778907251633704 | -122.50408090101801 | (37.7789072516337, -122.504080901018) | |||
| 180118 | 180118 | 179152 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002842.979780001 | 2092426.64855 | 37.725566194215006 | -122.43235413394699 | (37.725566194215, -122.432354133947) | |||
| 180091 | 180091 | 238403 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1957 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004421.06325 | 2107163.44561 | 37.766119397013505 | -122.42794847576799 | (37.7661193970135, -122.427948475768) | |||
| 179971 | 179971 | 214513 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201 Irving St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991875.48637 | 2106556.84064 | 37.763736088371 | -122.471296542118 | (37.763736088371, -122.471296542118) | |||
| 179645 | 179645 | 135922 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2440 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001259.6305 | 2118684.30492 | 37.7975733798607 | -122.43970926357599 | (37.7975733798607, -122.439709263576) | |||
| 179528 | 179528 | 237424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4301 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001903.00903 | 2100295.23121 | 37.7471181583961 | -122.436166365499 | (37.7471181583961, -122.436166365499) | |||
| 178957 | 178957 | 214501 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1939 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5992837.9582400005 | 2102354.50952 | 37.7522532108234 | -122.467662039975 | (37.7522532108234, -122.467662039975) | |||
| 178872 | 178872 | 213578 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 468 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994798.52341 | 2100109.7667799997 | 37.7462027195744 | -122.46071948511101 | (37.7462027195744, -122.460719485111) | |||
| 178303 | 178303 | 238513 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 315 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6004368.50682 | 2096368.4709 | 37.7364759409995 | -122.42736118879299 | (37.7364759409995, -122.427361188793) | |||
| 178265 | 178265 | 95761 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 211 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767498 | 6004841.33495 | 2091865.6988400002 | 37.724139060046795 | -122.425406081532 | (37.7241390600468, -122.425406081532) |
| 177958 | 177958 | 45540 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 159 Middlefield Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44295 | 5987294.0576 | 2094889.97142 | 37.7314359091244 | -122.48628552285801 | (37.7314359091244, -122.486285522858) | |
| 177726 | 177726 | 214581 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990758.8518199995 | 2105161.61747 | 37.7598405229314 | -122.475056740701 | (37.7598405229314, -122.475056740701) | |||
| 177420 | 177420 | 237080 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1407 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011199.55068 | 2101731.4680000003 | 37.7515855478467 | -122.404120571211 | (37.7515855478467, -122.404120571211) | |||
| 176543 | 176543 | 179052 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000689.90663 | 2093113.92443 | 37.7273309752317 | -122.439846362535 | (37.7273309752317, -122.439846362535) | |||
| 176489 | 176489 | 214502 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1961 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5992840.591519999 | 2102255.41953 | 37.7519812873159 | -122.46764572807501 | (37.7519812873159, -122.467645728075) | |||
| 176209 | 176209 | 32514 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 814 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 3 | Permit Number 37016 | 6007565.02408 | 2095597.87607 | 37.7345403220735 | -122.41625488347799 | (37.7345403220735, -122.416254883478) | |
| 175798 | 175798 | 123040 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 586 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5991933.82363 | 2111460.09457 | 37.7772024792906 | -122.47145207590499 | (37.7772024792906, -122.471452075905) | |||
| 175714 | 175714 | 238464 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 595 Waller St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6002882.5169400005 | 2108867.91188 | 37.7707122832869 | -122.433391810394 | (37.7707122832869, -122.433391810394) | |||
| 175710 | 175710 | 124184 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Almaden Ct | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 5995890.93647 | 2112594.82496 | 37.780546271753295 | -122.457845381425 | (37.7805462717533, -122.457845381425) | |||
| 175674 | 175674 | 45552 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 168 Sylvan Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2003 12:00:00 AM | 3 | Permit Number 44300 | 5987586.8772599995 | 2094815.36489 | 37.7312481217032 | -122.485267730441 | (37.7312481217032, -122.485267730441) | |
| 175417 | 175417 | 239456 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 166 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001880.41701 | 2096488.18318 | 37.7366636115241 | -122.435972118232 | (37.7366636115241, -122.435972118232) | |||
| 175243 | 175243 | 96075 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 411 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767701 | 5983103.04582 | 2113013.19289 | 37.7809520179972 | -122.50211500631399 | (37.7809520179972, -122.502115006314) |
| 174755 | 174755 | 179072 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 90 Arago St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5999599.07977 | 2092991.3421200002 | 37.7269322392262 | -122.443608534205 | (37.7269322392262, -122.443608534205) | |||
| 174331 | 174331 | 238437 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 404 Loma Vista Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5999965.68289 | 2106731.28661 | 37.7646797326031 | -122.443327665152 | (37.7646797326031, -122.443327665152) | |||
| 173307 | 173307 | 238149 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4275 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001414.53306 | 2101716.5345900003 | 37.75099295398571 | -122.43795726103001 | (37.7509929539857, -122.43795726103) | |||
| 173291 | 173291 | 237310 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 239 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009010.16713 | 2097233.8854900002 | 37.7391136049037 | -122.411374062159 | (37.7391136049037, -122.411374062159) | |||
| 172774 | 172774 | 238515 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 469 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6003819.77989 | 2095937.7691900001 | 37.7352622825199 | -122.429227667822 | (37.7352622825199, -122.429227667822) | |||
| 172057 | 172057 | 237137 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1447 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6010126.81888 | 2100822.77716 | 37.749030486662605 | -122.40776616289 | (37.7490304866626, -122.40776616289) | |||
| 171945 | 171945 | 237018 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 203 Webster St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004183.2035300005 | 2109550.4627400003 | 37.7726601078159 | -122.428941383946 | (37.7726601078159, -122.428941383946) | |||
| 171477 | 171477 | 238485 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Lily St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006368.4074800005 | 2110255.5826 | 37.77471964342 | -122.42143260153401 | (37.77471964342, -122.421432601534) | |||
| 171422 | 171422 | 213295 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 845 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996972.211569999 | 2090510.38577 | 37.719969948743206 | -122.452510552626 | (37.7199699487432, -122.452510552626) | |||
| 170235 | 170235 | 214614 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1375 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993310.36537 | 2106132.80589 | 37.7626546967712 | -122.466302960229 | (37.7626546967712, -122.466302960229) | |||
| 170160 | 170160 | 122116 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 167 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990825.0478300005 | 2114299.67117 | 37.78493496629989 | -122.47549502825899 | (37.7849349662999, -122.475495028259) | |||
| 170094 | 170094 | 214665 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1701 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992152.8233 | 2103808.38445 | 37.7562055900288 | -122.470137180189 | (37.7562055900288, -122.470137180189) | |||
| 169629 | 169629 | 178987 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 438 Delano Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5999543.39819 | 2091383.90085 | 37.722515400656 | -122.443685595329 | (37.722515400656, -122.443685595329) | |||
| 169602 | 169602 | 119955 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 330 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5987168.01965 | 2113716.3796200003 | 37.7831207441699 | -122.48810412836 | (37.7831207441699, -122.48810412836) | |||
| 169371 | 169371 | 122246 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 47 Lake St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5990773.91586 | 2114787.49655 | 37.7862714344835 | -122.47570756157499 | (37.7862714344835, -122.475707561575) | |||
| 168524 | 168524 | 214544 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 700 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993561.95258 | 2106676.18947 | 37.764161198806 | -122.46547229331101 | (37.764161198806, -122.465472293311) | |||
| 168210 | 168210 | 218135 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 0 Noriega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5992409.03176 | 2103467.31015 | 37.7552838973381 | -122.469226308173 | (37.7552838973381, -122.469226308173) | |||
| 167897 | 167897 | 214613 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1369 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993308.24603 | 2106182.69027 | 37.7627915439172 | -122.466313915779 | (37.7627915439172, -122.466313915779) | |||
| 167555 | 167555 | 237041 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2655 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010117.3537800005 | 2103952.14788 | 37.757622513287004 | -122.40801955226699 | (37.757622513287, -122.408019552267) | |||
| 167213 | 167213 | 213484 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Magellan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994952.79314 | 2100602.87802 | 37.7475655540149 | -122.460221763422 | (37.7475655540149, -122.460221763422) | |||
| 167177 | 167177 | 135919 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2355 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001720.67059 | 2118356.50999 | 37.7966995715863 | -122.438090451527 | (37.7966995715863, -122.438090451527) | |||
| 167048 | 167048 | 239471 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 908 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999208.84596 | 2107066.66194 | 37.7655574016784 | -122.44596947762699 | (37.7655574016784, -122.445969477627) | |||
| 167041 | 167041 | 237045 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1650 Bryant St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009424.6793 | 2107033.19319 | 37.7660435553884 | -122.41063268625 | (37.7660435553884, -122.41063268625) | |||
| 166577 | 166577 | 214570 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1555 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990874.08043 | 2106521.95233 | 37.7635823169014 | -122.47475751465001 | (37.7635823169014, -122.47475751465) | |||
| 166558 | 166558 | 68939 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 491 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/2010 12:00:00 AM | 3 | Permit Number 53187 | 5989664.28625 | 2112063.79605 | 37.7787285224831 | -122.479347217114 | (37.7787285224831, -122.479347217114) | |
| 166475 | 166475 | 214560 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1404 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991393.16564 | 2106601.6389900004 | 37.7638311808955 | -122.472967991486 | (37.7638311808955, -122.472967991486) | |||
| 165599 | 165599 | 68952 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 747 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 3 | Permit Number 32941 | 5988797.45218 | 2110217.11495 | 37.7736076654938 | -122.482210568345 | (37.7736076654938, -122.482210568345) | |
| 165465 | 165465 | 213351 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 752 Head St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5993534.806030001 | 2090819.23886 | 37.7206204409725 | -122.46441479849899 | (37.7206204409725, -122.464414798499) | |||
| 165448 | 165448 | 238489 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Lily St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006240.43536 | 2110240.5964200003 | 37.7746712787972 | -122.42187421903799 | (37.7746712787972, -122.421874219038) | |||
| 165411 | 165411 | 214565 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1514 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991019.54025 | 2106590.00929 | 37.763777610971296 | -122.474259386484 | (37.7637776109713, -122.474259386484) | |||
| 165270 | 165270 | 95771 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 335 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767506 | 6003734.79279 | 2091608.3124 | 37.7233697529841 | -122.429212886579 | (37.7233697529841, -122.429212886579) |
| 164473 | 164473 | 136005 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1237x Robert C Levy Tunl | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6007661.46268 | 2118150.4985 | 37.7964699809712 | -122.417519302367 | (37.7964699809712, -122.417519302367) | ||||
| 164122 | 164122 | 238327 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 311 Collingwood St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6002110.45234 | 2104015.2995700003 | 37.7573443628555 | -122.43571515492701 | (37.7573443628555, -122.435715154927) | |||
| 163914 | 163914 | 136012 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1001 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006953.337619999 | 2120481.80968 | 37.802831303989 | -122.420135108266 | (37.802831303989, -122.420135108266) | |||
| 162349 | 162349 | 238193 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3934 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003602.17561 | 2101885.64933 | 37.751581465823605 | -122.43040424458401 | (37.7515814658236, -122.430404244584) | |||
| 162231 | 162231 | 136002 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1043 Mason St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009478.99985 | 2116817.49063 | 37.7929119670677 | -122.41113599902201 | (37.7929119670677, -122.411135999022) | |||
| 162051 | 162051 | 238494 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1352 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002520.02655 | 2101564.36007 | 37.7506379232008 | -122.434123482635 | (37.7506379232008, -122.434123482635) | |||
| 161896 | 161896 | 214837 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 527 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994748.36207 | 2092060.94977 | 37.7240997605754 | -122.46030986640899 | (37.7240997605754, -122.460309866409) | |||
| 161730 | 161730 | 179133 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Somerset St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009923.85676 | 2093045.64408 | 37.7276647909784 | -122.407919656493 | (37.7276647909784, -122.407919656493) | |||
| 161720 | 161720 | 88140 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2445 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51172 | 5987869.621169999 | 2113257.1957099997 | 37.78190086066029 | -122.485643191826 | (37.7819008606603, -122.485643191826) |
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");