Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
76252 | 76252 | 136003 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1043 Mason St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009481.94772 | 2116801.23595 | 37.7928675009884 | -122.411124650506 | (37.7928675009884, -122.411124650506) | |||
130216 | 130216 | 135999 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1043 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009475.36486 | 2116853.62807 | 37.79301098783029 | -122.411151130141 | (37.7930109878303, -122.411151130141) | |||
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) | |||
169477 | 169477 | 136000 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1043 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009476.57256 | 2116845.84647 | 37.792989689179294 | -122.411146401493 | (37.7929896891793, -122.411146401493) | |||
20479 | 20479 | 73501 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767446 | 6001962.16426713 | 2101054.16463509 | 37.74920537061129 | -122.436016109621 | (37.7492053706113, -122.436016109621) | |
24761 | 24761 | 239379 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001966.9971 | 2100951.6663900004 | 37.7489242092946 | -122.43599206429899 | (37.7489242092946, -122.435992064299) | |||
68872 | 68872 | 239378 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001967.26718 | 2100937.20425 | 37.7488845150303 | -122.435990095661 | (37.7488845150303, -122.435990095661) | |||
97124 | 97124 | 71983 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767446 | 6001962.16426713 | 2101054.16463509 | 37.74920537061129 | -122.436016109621 | (37.7492053706113, -122.436016109621) | |
129792 | 129792 | 239380 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001965.88505 | 2100966.71291 | 37.748965460295295 | -122.435996986282 | (37.7489654602953, -122.435996986282) | |||
143111 | 143111 | 70987 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767446 | 6001962.16426713 | 2101054.16463509 | 37.74920537061129 | -122.436016109621 | (37.7492053706113, -122.436016109621) | |
165754 | 165754 | 239381 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001965.34817 | 2100982.03085 | 37.749007489225896 | -122.43599993875 | (37.7490074892259, -122.43599993875) | |||
83146 | 83146 | 121562 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1046 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6003754.0 | 2102204.0 | 37.7524641810183 | -122.42990192261499 | (37.7524641810183, -122.429901922615) | |||
57338 | 57338 | 237123 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1049 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6008643.89723 | 2102440.9012700003 | 37.7533903648753 | -122.41300853052799 | (37.7533903648753, -122.413008530528) | |||
102743 | 102743 | 107954 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Danvers St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771125 | 5999967.5 | 2105076.1 | 37.760135104087794 | -122.44320249258301 | (37.7601351040878, -122.443202492583) | |
115650 | 115650 | 107953 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Danvers St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771125 | 5999967.5 | 2105076.1 | 37.760135104087794 | -122.44320249258301 | (37.7601351040878, -122.443202492583) | |
117774 | 117774 | 81336 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771125 | 5999938.45094538 | 2105136.44437451 | 37.760299138392 | -122.44330729346599 | (37.760299138392, -122.443307293466) | |
63078 | 63078 | 179090 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004283.33861 | 2092987.6886900002 | 37.727188253710295 | -122.427414882796 | (37.7271882537103, -122.427414882796) | |||
70697 | 70697 | 179091 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004289.65055 | 2092997.26304 | 37.72721489973979 | -122.42739374423 | (37.7272148997398, -122.42739374423) | |||
91235 | 91235 | 47701 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45497 | 6003509.82655426 | 2097791.42406059 | 37.7403344433628 | -122.430431505695 | (37.7403344433628, -122.430431505695) | ||
129147 | 129147 | 47700 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45497 | 6003509.82655426 | 2097791.42406059 | 37.7403344433628 | -122.430431505695 | (37.7403344433628, -122.430431505695) | ||
162531 | 162531 | 238498 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003477.3432599995 | 2097803.5179 | 37.7403658101453 | -122.43054468270901 | (37.7403658101453, -122.430544682709) | |||
172900 | 172900 | 238499 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003467.41472 | 2097812.46812 | 37.7403898229362 | -122.43057965014401 | (37.7403898229362, -122.430579650144) | |||
33130 | 33130 | 237129 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1050 York St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009970.37435 | 2102983.71181 | 37.7549551744519 | -122.408459559056 | (37.7549551744519, -122.408459559056) | |||
73 | 73 | 65479 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1051 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1997 12:00:00 AM | 10 | 3x3 | Permit Number 28361 | 6008468.497880001 | 2115537.43749 | 37.789340533487795 | -122.41454177659901 | (37.7893405334878, -122.414541776599) |
81215 | 81215 | 53899 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1057 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2009 12:00:00 AM | Permit Number 52970 | 6011224.04910165 | 2089865.72837227 | 37.7190061040508 | -122.403201256455 | (37.7190061040508, -122.403201256455) | |||
88581 | 88581 | 94959 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1059 Evans Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/09/2010 12:00:00 AM | 6018613.9 | 2096078.3 | 37.7364745658864 | -122.37808815314199 | (37.7364745658864, -122.378088153142) | ||||
66203 | 66203 | 214714 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106 Aptos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993036.39091 | 2094292.8856099998 | 37.7301294810876 | -122.466389978617 | (37.7301294810876, -122.466389978617) | |||
160182 | 160182 | 214715 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106 Aptos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993029.000080001 | 2094275.40431 | 37.7300810552916 | -122.466414259408 | (37.7300810552916, -122.466414259408) | |||
56842 | 56842 | 237298 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008651.85996 | 2097990.76516 | 37.741171727704504 | -122.412666422143 | (37.7411717277045, -122.412666422143) | |||
160427 | 160427 | 213522 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995639.49669 | 2093392.9328599998 | 37.7278082877035 | -122.45732568475401 | (37.7278082877035, -122.457325684754) | |||
69055 | 69055 | 239532 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007362.80754 | 2097682.06201 | 37.7402516645702 | -122.41710164643801 | (37.7402516645702, -122.417101646438) | |||
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) | |||
13060 | 13060 | 109069 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1065 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772763 | 6002105.570119999 | 2087176.80573 | 37.7111094529054 | -122.434528092094 | (37.7111094529054, -122.434528092094) |
6501 | 6501 | 103875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106X Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006702.4202 | 2115509.69435 | 37.7891649813311 | -122.42065024171002 | (37.7891649813311, -122.42065024171) | ||
6617 | 6617 | 103761 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106X Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006685.575019999 | 2115508.13748 | 37.7891597571573 | -122.42070841348101 | (37.7891597571573, -122.420708413481) | ||
6991 | 6991 | 103876 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106X Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006716.01893 | 2115511.31786 | 37.7891702054911 | -122.420603306998 | (37.7891702054911, -122.420603306998) | ||
32182 | 32182 | 238284 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002049.03443 | 2105187.74161 | 37.7605601163763 | -122.43601145548 | (37.7605601163763, -122.43601145548) | |||
63918 | 63918 | 238286 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Collingwood St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002042.41083 | 2105231.1567 | 37.7606789473897 | -122.436037470178 | (37.7606789473897, -122.436037470178) | |||
67901 | 67901 | 238285 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002043.60824 | 2105208.24435 | 37.7606161036621 | -122.43603168931001 | (37.7606161036621, -122.43603168931) | |||
163704 | 163704 | 214753 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995611.1547 | 2093431.54917 | 37.7279126909161 | -122.457426455583 | (37.7279126909161, -122.457426455583) | |||
180962 | 180962 | 214752 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5995609.0834800005 | 2093408.98072 | 37.727850604413796 | -122.457431983704 | (37.7278506044138, -122.457431983704) | |||
17026 | 17026 | 16614 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | privately planted on dpw street without permit | 6002879.45304 | 2107636.12058 | 37.7673299123847 | -122.433314375152 | (37.7673299123847, -122.433314375152) | ||
59126 | 59126 | 238103 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1070 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007408.1692 | 2101126.1965400004 | 37.7497110387337 | -122.41718879522101 | (37.7497110387337, -122.417188795221) | |||
183886 | 183886 | 238104 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1070 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007407.26502 | 2101103.9240599996 | 37.7496498326723 | -122.417190343875 | (37.7496498326723, -122.417190343875) | |||
134002 | 134002 | 237375 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1071 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009203.81222 | 2102937.13478 | 37.7547843257492 | -122.41110726841299 | (37.7547843257492, -122.411107268413) | |||
17633 | 17633 | 23053 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1074 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/16/1992 12:00:00 AM | 18 | 3X3 | 6006318.63458 | 2103360.59062 | 37.7557848161263 | -122.421115089604 | (37.7557848161263, -122.421115089604) | ||
72980 | 72980 | 69395 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1075 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33499 | 6002066.46838 | 2087158.9447 | 37.711058190666705 | -122.43466196070801 | (37.7110581906667, -122.434661960708) | |
63276 | 63276 | 59606 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1077 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 1 | 3x3 | Permit Number 19007 | 6015566.4484 | 2104073.9972599996 | 37.7582606677124 | -122.38918270881099 | (37.7582606677124, -122.389182708811) | |
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) | |
56435 | 56435 | 237076 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 108 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005382.34798 | 2103034.44526 | 37.7548364711386 | -122.42432987721901 | (37.7548364711386, -122.424329877219) | |||
72170 | 72170 | 213468 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 108 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992714.16407 | 2098359.03254 | 37.7412755040554 | -122.467799567899 | (37.7412755040554, -122.467799567899) | |||
107794 | 107794 | 50098 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 108 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52733 | 5992719.49980491 | 2098392.60521716 | 37.74136799423071 | -122.46778356014099 | (37.7413679942307, -122.467783560141) | ||
56131 | 56131 | 49551 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1084REVISED Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2003 12:00:00 AM | 5 | Permit Number 46441 | 6009968.28689 | 2111507.46699 | 37.7783593364429 | -122.40906818514601 | (37.7783593364429, -122.409068185146) | ||
64071 | 64071 | 238105 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1086 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007413.8685800005 | 2101032.90286 | 37.7494551960109 | -122.41716247657 | (37.7494551960109, -122.41716247657) | |||
18694 | 18694 | 10178 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1086 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/29/2001 12:00:00 AM | 16 | 2X2 | 6005705.19862 | 2102704.3683 | 37.7539483816144 | -122.423189907382 | (37.7539483816144, -122.423189907382) | ||
65343 | 65343 | 237117 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1086 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005704.9636699995 | 2102692.93709 | 37.7539169809013 | -122.423189907394 | (37.7539169809013, -122.423189907394) | |||
88917 | 88917 | 91030 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1086 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6009941.213427 | 2111462.810786 | 37.778235204322904 | -122.409158690819 | (37.7782352043229, -122.409158690819) | ||
61341 | 61341 | 237229 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 109 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998076.1875599995 | 2106198.82247 | 37.7631097915092 | -122.449824524095 | (37.7631097915092, -122.449824524095) | |||
62370 | 62370 | 213314 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 109 Caine Ave | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997314.23204 | 2089197.70588 | 37.716385224975795 | -122.45123369250601 | (37.7163852249758, -122.451233692506) | |||
66393 | 66393 | 213312 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 109 Caine Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997293.25449 | 2089167.74263 | 37.716301751698204 | -122.451304041065 | (37.7163017516982, -122.451304041065) | |||
147069 | 147069 | 213311 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 109 Caine Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997282.73831 | 2089151.44786 | 37.716256407882106 | -122.451339215357 | (37.7162564078821, -122.451339215357) | |||
180916 | 180916 | 213313 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 109 Caine Ave | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997305.300980001 | 2089185.13122 | 37.7163501865023 | -122.45126365610099 | (37.7163501865023, -122.451263656101) | |||
80030 | 80030 | 84222 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1099 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50699 | 6008536.64493866 | 2086928.58742632 | 37.710790872531796 | -122.412283117187 | (37.7107908725318, -122.412283117187) | ||
93504 | 93504 | 84211 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1099 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50699 | 6008536.64493866 | 2086928.58742632 | 37.710790872531796 | -122.412283117187 | (37.7107908725318, -122.412283117187) | ||
141941 | 141941 | 84223 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1099 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50699 | 6008536.64493866 | 2086928.58742632 | 37.710790872531796 | -122.412283117187 | (37.7107908725318, -122.412283117187) | ||
48583 | 48583 | 239537 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007207.949109999 | 2097619.73987 | 37.7400718289571 | -122.41763267000799 | (37.7400718289571, -122.417632670008) | |||
56051 | 56051 | 136019 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Greenwich St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012283.42018 | 2120515.08235 | 37.803221537807204 | -122.401692519489 | (37.8032215378072, -122.401692519489) | ||||
154989 | 154989 | 136018 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Greenwich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6012250.392990001 | 2120519.5939 | 37.8032320823636 | -122.401807129095 | (37.8032320823636, -122.401807129095) | ||||
54370 | 54370 | 238412 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Hattie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000623.254480001 | 2105558.02265 | 37.761495715270904 | -122.44096912924499 | (37.7614957152709, -122.440969129245) | |||
176728 | 176728 | 238413 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Hattie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000620.6168 | 2105576.07492 | 37.761545132131296 | -122.440979546976 | (37.7615451321313, -122.440979546976) | |||
36765 | 36765 | 179054 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Santa Ysabel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000895.42593 | 2093107.17468 | 37.7273241385819 | -122.439135400803 | (37.7273241385819, -122.439135400803) | |||
64721 | 64721 | 179055 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Santa Ysabel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000916.39944 | 2093093.66767 | 37.7272882448407 | -122.439061927974 | (37.7272882448407, -122.439061927974) | |||
73030 | 73030 | 179053 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Santa Ysabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000877.24807 | 2093119.8452299999 | 37.7273578946334 | -122.439199149238 | (37.7273578946334, -122.439199149238) | |||
132833 | 132833 | 179056 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Santa Ysabel Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6000936.563080001 | 2093078.77727 | 37.7272485065017 | -122.438991155826 | (37.7272485065017, -122.438991155826) | |||
25845 | 25845 | 237234 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 110 Carmel St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 5998175.72217 | 2105385.27781 | 37.7608816968555 | -122.449421648503 | (37.7608816968555, -122.449421648503) | |||
133870 | 133870 | 237233 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 110 Carmel St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5998197.90052 | 2105385.6119999997 | 37.760883883112506 | -122.449344967798 | (37.7608838831125, -122.449344967798) | |||
13686 | 13686 | 27731 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015524.1696 | 2101161.19501 | 37.7502603851148 | -122.38912554882 | (37.7502603851148, -122.38912554882) | ||
14286 | 14286 | 27729 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015622.7491 | 2101166.85438 | 37.75028138877779 | -122.38878504659999 | (37.7502813887778, -122.3887850466) | ||
52380 | 52380 | 119254 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008843.9612300005 | 2117672.51917 | 37.7952240323069 | -122.41339376771799 | (37.7952240323069, -122.413393767718) | |||
29713 | 29713 | 88413 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51386 | 6009439.10659 | 2116768.27237 | 37.792774588415796 | -122.411270553799 | (37.7927745884158, -122.411270553799) | |
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) | |
81508 | 81508 | 88416 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
97381 | 97381 | 88421 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
112603 | 112603 | 88418 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
116912 | 116912 | 88417 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
138283 | 138283 | 88419 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
146280 | 146280 | 88420 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
153833 | 153833 | 88415 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009399.28346 | 2116763.19844 | 37.792758423123495 | -122.41140798549601 | (37.7927584231235, -122.411407985496) | |
155637 | 155637 | 88414 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009411.74152 | 2116765.8223 | 37.7927663263429 | -122.41136506535 | (37.7927663263429, -122.41136506535) | |
148518 | 148518 | 237374 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6009217.6012 | 2102696.19703 | 37.7541235380848 | -122.41104256485599 | (37.7541235380848, -122.411042564856) | |||
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) | |||
164565 | 164565 | 237372 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6009220.63177 | 2102661.3564299997 | 37.7540280435643 | -122.41102962363199 | (37.7540280435643, -122.411029623632) | |||
51355 | 51355 | 196467 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 8 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6015482.81101 | 2101057.8670900003 | 37.7499743755266 | -122.389261356351 | (37.7499743755266, -122.389261356351) | |||
55544 | 55544 | 196465 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015262.99985 | 2101056.82815 | 37.7499593343528 | -122.39002140848801 | (37.7499593343528, -122.390021408488) | |||
151967 | 151967 | 196468 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 12 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6015629.24905 | 2101065.86664 | 37.7500044578413 | -122.38875552004801 | (37.7500044578413, -122.388755520048) | |||
171137 | 171137 | 196466 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6015450.2681 | 2101056.0343 | 37.7499675388841 | -122.389373764399 | (37.7499675388841, -122.389373764399) | |||
60536 | 60536 | 214519 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992317.04824 | 2106570.7861599997 | 37.763799911465 | -122.46977034493901 | (37.763799911465, -122.469770344939) | |||
69153 | 69153 | 237112 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 San Jose Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004834.0708099995 | 2096408.3013799998 | 37.736611626213495 | -122.425754370088 | (37.7366116262135, -122.425754370088) | ||||
89616 | 89616 | 237113 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 San Jose Ave | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004838.14282 | 2096415.36394 | 37.7366312485184 | -122.425740793928 | (37.7366312485184, -122.425740793928) | ||||
130170 | 130170 | 237114 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 San Jose Ave | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004844.31996 | 2096418.97753 | 37.736641519684504 | -122.425719694004 | (37.7366415196845, -122.425719694004) |
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");