Street_Tree_List

Data source: data.sfgov.org

308 rows where DBH = 6 and qSpecies = 18

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize

DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
131 237033 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Octavia St 7 : 4 Tree 1 DPW 2     6 Width 4ft   6005718.98472 2109769.85153 37.7733493059578 -122.423644547079 (37.7733493059578, -122.423644547079)
1495 213442 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2455 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2002 12:00:00 AM 6 Width 3ft Permit Number 45711 5992014.67382 2098752.22599 37.742314697659204 -122.470246761681 (37.7423146976592, -122.470246761681)
4328 28085 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2255 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3x3   6002770.4091 2114749.1272 37.786854268374796 -122.43420010239201 (37.7868542683748, -122.434200102392)
8875 2624 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1822 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6004615.6699 2115060.0567 37.7878125608959 -122.427838089219 (37.7878125608959, -122.427838089219)
10340 28256 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3476 San Bruno Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/19/2003 12:00:00 AM 6 3x3   6012060.981000001 2089540.1901200002 37.7181589470551 -122.400285438425 (37.7181589470551, -122.400285438425)
11313 26979 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 538 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6004789.78173 2093487.7597 37.728589968546 -122.42569968949199 (37.728589968546, -122.425699689492)
11481 28255 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3476 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/25/2003 12:00:00 AM 6 3x3   6012058.005419999 2089554.66958 37.7181985388057 -122.400296740219 (37.7181985388057, -122.400296740219)
12793 13368 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 900 Mansell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X50   6009218.46856 2090025.7710400003 37.719333336630896 -122.410145089137 (37.7193333366309, -122.410145089137)
17409 4836 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 123 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/15/2000 12:00:00 AM 6 3X3   6006379.67825 2097659.7420099997 37.7401350234134 -122.420499335499 (37.7401350234134, -122.420499335499)
18266 4090 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3215 Cesar Chavez St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/31/1995 12:00:00 AM 6 3X3   6008246.07333 2100530.81306 37.748123352213504 -122.41424916149201 (37.7481233522135, -122.414249161492)
18339 3945 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 129 Castro St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/2000 12:00:00 AM 6 3X3   6002246.22679 2107489.51068 37.7668914137434 -122.435494123149 (37.7668914137434, -122.435494123149)
18631 10219 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1361 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/2002 12:00:00 AM 6 3X3   6005865.11973 2101072.64646 37.7494770729178 -122.422520923317 (37.7494770729178, -122.422520923317)
18995 19331 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 301 Shields St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/05/2000 12:00:00 AM 6 3x3   5993203.76699 2089824.45321 37.7178699121392 -122.465486857851 (37.7178699121392, -122.465486857851)
19214 10228 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1411 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/02/2002 12:00:00 AM 6 3X3   6005886.64477 2100667.53648 37.7483659479448 -122.422417708118 (37.7483659479448, -122.422417708118)
19308 4173 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3807X Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/30/1995 12:00:00 AM 6 3X3   6005111.29038 2100461.84082 37.7477573856943 -122.42508423394301 (37.7477573856943, -122.425084233943)
20721 10215 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1335 Guerrero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/24/2000 12:00:00 AM 6 3X3   6005858.33864 2101181.45988 37.749775467064 -122.42255210370199 (37.749775467064, -122.422552103702)
21265 27509 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1335 Guerrero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/24/2000 12:00:00 AM 6 3X3   6005856.94451 2101204.3999 37.749838376446206 -122.42255855456001 (37.7498383764462, -122.42255855456)
21301 3944 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 129 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/1999 12:00:00 AM 6 3X3   6002248.02502 2107476.74068 37.7668564525859 -122.435486989749 (37.7668564525859, -122.435486989749)
21380 4200 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3890 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/1995 12:00:00 AM 6 3X3   6004657.19405 2100480.3462900002 37.7477825352565 -122.42665579384399 (37.7477825352565, -122.426655793844)
22029 25409 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3763-3767 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/19/1996 12:00:00 AM 6 3x3   6005453.81691 2100480.39517 37.7478276749239 -122.42390111285 (37.7478276749239, -122.42390111285)
23606 31666 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4066 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1995 12:00:00 AM 6   Permit Number 35467 6002585.751619999 2104753.963 37.7593995412727 -122.434124187708 (37.7593995412727, -122.434124187708)
24659 239434 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 641 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002846.37462 2095677.3876200002 37.734492180455 -122.43257449123699 (37.734492180455, -122.432574491237)
24891 213671 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 120 Edgehill Way 7 Front Yard : Yard 7 Tree 1 Private 1     6 Width 3ft   5994885.5088599995 2098943.91671 37.7430065910919 -122.460334245238 (37.7430065910919, -122.460334245238)
26326 213639 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 32 Malta Dr 21 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5999561.36601 2096051.1462299998 37.7353315950748 -122.44395866097099 (37.7353315950748, -122.443958660971)
26912 237377 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 979 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6009171.618530001 2103483.06464 37.7562815207028 -122.411257166497 (37.7562815207028, -122.411257166497)
27195 135991 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1040 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008482.86494 2115597.67171 37.789506729108204 -122.414496332055 (37.7895067291082, -122.414496332055)
27694 238465 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 71 Potomac St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6003081.83351 2108772.32809 37.7704611394919 -122.43269554267599 (37.7704611394919, -122.432695542676)
27986 237283 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 614 Ellsworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6007963.94281 2096020.98872 37.7357245205556 -122.414905620711 (37.7357245205556, -122.414905620711)
29054 238048 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 400 Lily St 3 : 4 Tree 1 Private 1     6 Width 3ft   6004553.97154 2110004.0488299998 37.7739265241283 -122.427691180609 (37.7739265241283, -122.427691180609)
29842 238504 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 68 Wilder St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002684.617740001 2095553.88907 37.7341439071982 -122.433124916788 (37.7341439071982, -122.433124916788)
30210 237187 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 904 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6004333.66814 2103620.22544 37.7563856136086 -122.427998244239 (37.7563856136086, -122.427998244239)
30565 238390 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 80 Collingwood St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6001989.17062 2105400.26005 37.7611402393495 -122.436233705824 (37.7611402393495, -122.436233705824)
30633 95739 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 612 Excelsior Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM 6 3x3 Permit Number 767485 6003904.92985 2091757.6805900002 37.7237895151604 -122.428635396826 (37.7237895151604, -122.428635396826)
31003 124618 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 700 Euclid Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5996155.438130001 2113845.79893 37.78399630583271 -122.45702086273 (37.7839963058327, -122.45702086273)
31403 238374 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 587 Liberty St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002502.863419999 2103825.71172 37.7568460818083 -122.434344490133 (37.7568460818083, -122.434344490133)
31639 213343 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 117 Vernon St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992434.92339 2088648.0359 37.7145953816368 -122.468058861341 (37.7145953816368, -122.468058861341)
31646 237358 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1400 Treat Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008695.940169999 2100749.23036 37.7487483369695 -122.41270897086399 (37.7487483369695, -122.412708970864)
31936 48575 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2275 Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/27/2002 12:00:00 AM 6   Permit Number 45888 5999350.9725 2120803.18902 37.80328244439271 -122.446466222664 (37.8032824443927, -122.446466222664)
32170 111793 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 55X Sherman St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     6 3x3   6010868.84129 2110834.34163 37.7765614981606 -122.405905386452 (37.7765614981606, -122.405905386452)
32602 213579 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 464 Dewey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5994822.2189 2100134.8158400003 37.7462728613029 -122.460639364526 (37.7462728613029, -122.460639364526)
32843 31989 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 147 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/30/1995 12:00:00 AM 6   Permit Number 35389 5994568.75053 2114560.8648099997 37.78586843793 -122.462562068449 (37.78586843793, -122.462562068449)
33510 40676 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 191 Maynard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/04/2005 12:00:00 AM 6   Permit Number 47920 6004632.23626 2093798.9275599997 37.7294354625595 -122.426266478225 (37.7294354625595, -122.426266478225)
34110 213580 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 45 Merced Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5995131.70851 2099996.48556 37.74591084191 -122.459559177141 (37.74591084191, -122.459559177141)
34117 237115 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Hwy 101 Southbound 6 Back Yard : Yard 13 Tree 1 Private 1     6     6005846.05822 2108984.84199 37.7712010306339 -122.42314917169399 (37.7712010306339, -122.423149171694)
34178 213551 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 159 Valdez Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5996188.75737 2094532.8518700001 37.73096976354329 -122.455509245751 (37.7309697635433, -122.455509245751)
34374 213557 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 50 Valdez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5996396.856430001 2093987.6566700002 37.7294847274146 -122.454750441903 (37.7294847274146, -122.454750441903)
34490 68541 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 501 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM 6   Permit Number 32425 5982517.9924800005 2112299.68917 37.778958557712606 -122.504086094205 (37.7789585577126, -122.504086094205)
34515 237052 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1359 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6010359.96313 2101381.9177099997 37.7505788125805 -122.40699934965099 (37.7505788125805, -122.406999349651)
34790 237110 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 380 Lexington St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 1ft   6006531.04727 2103908.9188900003 37.7573023708184 -122.420419415431 (37.7573023708184, -122.420419415431)
35079 213616 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 282 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5995109.982340001 2095633.16995 37.733929007011206 -122.459318378264 (37.7339290070112, -122.459318378264)
35288 238420 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 242 Corbett Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5999803.1371 2105544.26543 37.7614111970029 -122.443804579221 (37.7614111970029, -122.443804579221)
35668 213507 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 170 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5995650.65208 2093847.52813 37.729057137577 -122.457319993841 (37.729057137577, -122.457319993841)
36221 239472 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 192 Upper Ter 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   5999641.79555 2106531.14704 37.764111724386204 -122.44443351741998 (37.7641117243862, -122.44443351742)
37063 213321 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 325 Monticello St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   5991673.594880001 2090710.5616 37.7202145769251 -122.470840448236 (37.7202145769251, -122.470840448236)
37224 238146 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 816 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6001874.44025 2101652.14409 37.750842295952104 -122.436362251334 (37.7508422959521, -122.436362251334)
38356 213463 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 314 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5993094.88579 2099699.80528 37.7449789032567 -122.46658060972 (37.7449789032567, -122.46658060972)
38505 237174 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1530 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008721.73548 2099825.28397 37.746212833362605 -122.412554466435 (37.7462128333626, -122.412554466435)
38891 238204 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3753 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6003355.958330001 2103579.02376 37.7562171211382 -122.43137656370399 (37.7562171211382, -122.431376563704)
39061 238237 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3851 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6003263.10271 2105914.5471 37.7626246459451 -122.43186444678899 (37.7626246459451, -122.431864446789)
39066 124480 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 276 Willard St North 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   5996245.79674 2110923.35846 37.7759772459796 -122.456496854767 (37.7759772459796, -122.456496854767)
39076 123168 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 598 10th Ave 1 Side Yard : Yard 17 Tree 1 Private 1     6     5992809.72377 2111438.2053099996 37.7771930089585 -122.468420491782 (37.7771930089585, -122.468420491782)
39376 239418 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2106 Castro St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6     6002637.419840001 2099337.55033 37.7445302890331 -122.433558405315 (37.7445302890331, -122.433558405315)
40172 213418 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1500 Ulloa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5991335.33208 2098431.48094 37.741394714585496 -122.47257231588301 (37.7413947145855, -122.472572315883)
40185 62775 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 40 Delano Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/24/1986 12:00:00 AM 6   Permit Number 23130 6000616.95925 2093064.6604900002 37.727191555121706 -122.440095009781 (37.7271915551217, -122.440095009781)
40381 250676 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 735 El Camino Del Mar 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986293.297259999 2114811.88275 37.786077611448 -122.49121092176 (37.786077611448, -122.49121092176)
40751 68941 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 730 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 6   Permit Number 32928 5989462.36102 2110347.5276900004 37.774004395159295 -122.479920119491 (37.7740043951593, -122.479920119491)
41185 238302 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 224 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6001725.92578 2104522.1250400003 37.758714133770496 -122.437081282675 (37.7587141337705, -122.437081282675)
41337 238326 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 358 Eureka St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6001462.98209 2103653.8418 37.7563150887866 -122.437928468325 (37.7563150887866, -122.437928468325)
41344 196448 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2 Madera St 2 : 4 Tree 1 Private 1     6 Width 3ft   6012976.23669 2103282.94556 37.755944680513295 -122.398085357651 (37.7559446805133, -122.398085357651)
42511 214723 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 591 Miramar Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5995322.28894 2093286.2773099998 37.7274972131074 -122.45841455420299 (37.7274972131074, -122.458414554203)
42810 237421 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4347 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6001594.69603 2100278.73808 37.74705535061779 -122.43723130398199 (37.7470553506178, -122.437231303982)
42915 214589 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 99 Lurline St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5991796.94128 2105115.28006 37.7597734011291 -122.47146315499701 (37.7597734011291, -122.471463154997)
43022 238228 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3831 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6004247.41053 2101874.23621 37.751586656701 -122.428172127243 (37.751586656701, -122.428172127243)
43621 239463 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 200 Palo Alto Ave 1 : 4 Tree 1 Private 1     6 Width 3ft   5997639.21555 2103894.3138099997 37.7567571793145 -122.451169653584 (37.7567571793145, -122.451169653584)
43622 239460 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 134 Surrey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002209.73333 2096210.1693 37.7359189522033 -122.43481365563801 (37.7359189522033, -122.434813655638)
44371 213690 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 531 Gennessee St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5997444.64303 2095159.4948599997 37.732762361473604 -122.451212635762 (37.7327623614736, -122.451212635762)
44592 237271 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 530 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6007683.52656 2096864.1843700001 37.7380239899033 -122.41593482283399 (37.7380239899033, -122.415934822834)
48217 32078 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3847 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1995 12:00:00 AM 6   Permit Number 35451 6003283.17124 2105912.34445 37.7626197356314 -122.431794879733 (37.7626197356314, -122.431794879733)
48235 179065 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 252 Otsego Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6000349.56267 2091773.3269599997 37.7236306229466 -122.440926797246 (37.7236306229466, -122.440926797246)
48259 237401 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3511 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006078.7375300005 2102562.31872 37.7535794194659 -122.421888029913 (37.7535794194659, -122.421888029913)
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)
49079 238346 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 213 Collingwood St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002078.3851 2104627.3949 37.759023207373296 -122.43586985090599 (37.7590232073733, -122.435869850906)
49933 78363 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 575 Lisbon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/12/2000 12:00:00 AM 6     6001858.247830001 2090145.2543799998 37.719246112288104 -122.43559512512199 (37.7192461122881, -122.435595125122)
49995 135934 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98 Spruce St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997041.86737 2116129.80097 37.790318431109704 -122.454119176269 (37.7903184311097, -122.454119176269)
50362 237418 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 786 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6001460.61655 2100008.82783 37.746306618271205 -122.437675611364 (37.7463066182712, -122.437675611364)
50364 74315 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 50 Delano Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2000 12:00:00 AM 6     6000588.288430001 2093013.22945 37.727048705022895 -122.440190437741 (37.7270487050229, -122.440190437741)
50623 239509 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 444 Prentiss St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008753.78485 2096712.524 37.737667676711794 -122.412223680483 (37.7376676767118, -122.412223680483)
50959 196483 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 65 Colin P Kelly Jr St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6015356.8087 2112701.6743900003 37.7819387497011 -122.39051059018699 (37.7819387497011, -122.390510590187)
51050 196476 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2074 Revere Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6012584.77785 2096296.25792 37.7367389189762 -122.398948809344 (37.7367389189762, -122.398948809344)
51473 237339 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 328 Bocana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006792.98874 2097141.4032700001 37.738735064080295 -122.41903351700199 (37.7387350640803, -122.419033517002)
51530 237012 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 401 Lily St 2 : 4 Tree 1 Private 1     6 Width 2ft   6004502.75117 2109973.05936 37.7738385371506 -122.42786615182399 (37.7738385371506, -122.427866151824)
51659 178979 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 190 Rae Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5997616.63139 2087136.8467599999 37.7107438892848 -122.450040007061 (37.7107438892848, -122.450040007061)
51756 179117 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 212 Maynard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6004824.04554 2093769.3744299999 37.7293651562744 -122.4256012722 (37.7293651562744, -122.4256012722)
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)
52624 86960 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 208 Head St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2007 12:00:00 AM 6 3x3 Permit Number 49928 5993493.7535 2087361.9529 37.71112519553311 -122.464305827668 (37.7111251955331, -122.464305827668)
53349 238145 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 820 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6001874.13959 2101637.6151400004 37.7508023858328 -122.436362251332 (37.7508023858328, -122.436362251332)
53430 238419 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 242 Corbett Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5999814.22869 2105549.6420400003 37.761426592486 -122.443766604438 (37.761426592486, -122.443766604438)
53559 237338 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 123 Ellert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6007275.446930001 2097014.4227200001 37.7384135600251 -122.41735640368 (37.7384135600251, -122.41735640368)
53858 214650 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 28 Hillway Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   5996115.71323 2106752.8498400003 37.7645186442469 -122.45664517043899 (37.7645186442469, -122.456645170439)
53955 213335 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 53 Byxbee St 1 : 4 Tree 1 Private 1     6 Width 3ft   5991917.8551 2088918.99095 37.715309483835 -122.469865758501 (37.715309483835, -122.469865758501)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 1679.935ms · Data source: data.sfgov.org