Street_Tree_List

Data source: data.sfgov.org

4,048 rows where qSpecies = 18 sorted by PermitNotes descending

View and edit SQL

Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes ▲ XCoord YCoord Latitude Longitude Location
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)
141034 4148 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3631 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/17/1999 12:00:00 AM 3 3X3 She would like to be kept in the loop on what happens with this. 6006082.4281665 2100506.5376626 37.7479349243864 -122.421729258843 (37.7479349243864, -122.421729258843)
4329 239457 Planning Code 138.1 required 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 165 Sussex St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001959.66963 2096487.1672 37.7366653238346 -122.435698035437 (37.7366653238346, -122.435698035437)
4404 239458 Planning Code 138.1 required 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 165 Sussex St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001977.4736 2096494.97635 37.7366877772239 -122.435637038029 (37.7366877772239, -122.435637038029)
2996 178926 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 406 Capistrano Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3 Permit Number 780238 6000939.854169999 2092384.3608900001 37.7253419851205 -122.43893003518801 (37.7253419851205, -122.438930035188)
22921 187655 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1548 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/14/2017 12:00:00 AM 3 3x3 Permit Number 779523 6003789.0 2099328.0 37.744569337434 -122.42957579341999 (37.744569337434, -122.42957579342)
71360 78237 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1215 Cayuga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2000 12:00:00 AM 3   Permit Number 779512 5999758.88688 2090259.2057 37.7194395330998 -122.442859978114 (37.7194395330998, -122.442859978114)
3846 239484 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 725 Andover St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/12/2017 12:00:00 AM 8 Width 3ft Permit Number 779370 6007401.15098 2095467.39415 37.7341728312175 -122.416812207728 (37.7341728312175, -122.416812207728)
9780 65693 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3779 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2016 12:00:00 AM 3 4x4 Permit Number 779357 6005288.42845233 2101344.00549356 37.7501896116955 -122.424534439725 (37.7501896116955, -122.424534439725)
12147 62165 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 38 Meda Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/14/2017 12:00:00 AM 3 3x3 Permit Number 779350 6000139.34294 2091815.10105 37.723733349795 -122.441656484657 (37.723733349795, -122.441656484657)
6091 34255 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2280 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/23/2016 12:00:00 AM 3 6x4 Permit Number 779106 6002701.36974 2117843.10011 37.7953456053627 -122.43466028347099 (37.7953456053627, -122.434660283471)
19460 16615 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 113 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2016 12:00:00 AM 3 3X3 Permit Number 778956 6002889.7801 2107581.65027 37.7671809360695 -122.433274762729 (37.7671809360695, -122.433274762729)
10479 35851 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 500 Paris St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/2016 12:00:00 AM 3 3x3 Permit Number 778923 6001833.39372 2090697.4113200002 37.720760799954206 -122.435720519401 (37.7207607999542, -122.435720519401)
4841 88280 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3261 Clay St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/26/2017 12:00:00 AM 3 3x3 Permit Number 778851 5999200.48769 2115630.5359099996 37.789071121774796 -122.446614594592 (37.7890711217748, -122.446614594592)
84730 37606 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 443 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/22/2016 12:00:00 AM 3 3x3 Permit Number 778736 5990893.1561900005 2112363.8827299997 37.7796237756063 -122.47511803318301 (37.7796237756063, -122.475118033183)
93511 67139 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1256 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/13/2016 12:00:00 AM 3 3x3 Permit Number 778711 5995503.40408063 2107002.8233616003 37.765169831893104 -122.45878106616199 (37.7651698318931, -122.458781066162)
12339 62181 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 18 Meda Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/17/2016 12:00:00 AM 3   Permit Number 778619 6000227.937530001 2091768.58709 37.7236106804803 -122.44134689306802 (37.7236106804803, -122.441346893068)
3412 117560 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2304 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/30/2016 12:00:00 AM 3 4x4 Permit Number 778613 6002499.39832 2117814.1104 37.7952545391263 -122.435357062003 (37.7952545391263, -122.435357062003)
99639 117331 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 631 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/07/2016 12:00:00 AM 3   Permit Number 778489 5991238.8 2111099.9 37.7761732520862 -122.47383007619601 (37.7761732520862, -122.473830076196)
91912 115432 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 121 Edgehill Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/01/2016 12:00:00 AM 3   Permit Number 777500 5994912.6 2098995.5 37.7431497843009 -122.460244308613 (37.7431497843009, -122.460244308613)
129278 115431 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 121 Edgehill Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/01/2016 12:00:00 AM 3   Permit Number 777500 5994912.6 2098995.5 37.7431497843009 -122.460244308613 (37.7431497843009, -122.460244308613)
84286 82615 Planning Code 138.1 required 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2901 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777487 6010040.72394239 2101604.72592715 37.751172725188106 -122.408119020981 (37.7511727251881, -122.408119020981)
104169 115503 Planning Code 138.1 required 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2901 25th St 72 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777487 6010040.72394239 2101604.72592715 37.751172725188106 -122.408119020981 (37.7511727251881, -122.408119020981)
120641 115504 Planning Code 138.1 required 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2901 25th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777487 6010040.72394239 2101604.72592715 37.751172725188106 -122.408119020981 (37.7511727251881, -122.408119020981)
128347 104667 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 172 Clipper St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1 FUF 1 01/19/2016 12:00:00 AM   6x12 Permit Number 777366 6003998.6 2101043.1 37.749290469922705 -122.42897329466999 (37.7492904699227, -122.42897329467)
96235 115195 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 288 Hartford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/19/2016 12:00:00 AM     Permit Number 777365 6002703.4 2104224.0 37.7579510666244 -122.43367942577 (37.7579510666244, -122.43367942577)
142293 115196 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 288 Hartford St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/19/2016 12:00:00 AM     Permit Number 777365 6002703.4 2104224.0 37.7579510666244 -122.43367942577 (37.7579510666244, -122.43367942577)
23166 26519 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2851 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/04/2015 12:00:00 AM 1 1X1 Permit Number 777140 6009004.2746 2101873.01384 37.751851296609296 -122.411722142074 (37.7518512966093, -122.411722142074)
127008 114760 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2849 Harrison St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/04/2015 12:00:00 AM     Permit Number 777140 6009026.4 2101883.5 37.7518813304133 -122.41164636991999 (37.7518813304133, -122.41164636992)
121219 62877 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 251 Gates St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/21/1986 12:00:00 AM     Permit Number 776425 6008284.37229523 2097420.40805091 37.739585020251106 -122.413896730256 (37.7395850202511, -122.413896730256)
88468 115340 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 566 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/26/2016 12:00:00 AM 3   Permit Number 776419 5993501.9 2111635.8 37.777775507129505 -122.46604041549699 (37.7777755071295, -122.466040415497)
96866 46685 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1563 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/04/2016 12:00:00 AM     Permit Number 776034 5992114.70084954 2104801.75310053 37.758930915917 -122.470341358559 (37.758930915917, -122.470341358559)
125967 115302 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 333 Wawona St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/2016 12:00:00 AM     Permit Number 775906 5992046.2 2097184.7 37.738012491984 -122.47002364404699 (37.738012491984, -122.470023644047)
145305 115301 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 333 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/2016 12:00:00 AM     Permit Number 775906 5992046.2 2097184.7 37.738012491984 -122.47002364404699 (37.738012491984, -122.470023644047)
69506 51979 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 201 Otsego Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/2015 12:00:00 AM 7 3x3 Permit Number 775837 6000531.055869999 2092082.3650200001 37.7244895060779 -122.440321560704 (37.7244895060779, -122.440321560704)
108407 58726 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 69 Carmelita St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/06/2015 12:00:00 AM     Permit Number 775773 6002576.94899683 2108749.8894507 37.7703708822162 -122.43444033398701 (37.7703708822162, -122.434440333987)
103477 115280 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1670 Sloat Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/21/2016 12:00:00 AM     Permit Number 775682 5985986.6 2095938.5 37.73423859995479 -122.49088271409599 (37.7342385999548, -122.490882714096)
105490 115279 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1670 Sloat Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/21/2016 12:00:00 AM     Permit Number 775682 5985986.6 2095938.5 37.73423859995479 -122.49088271409599 (37.7342385999548, -122.490882714096)
7213 105719 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2317 Washington St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/27/2015 12:00:00 AM 3 3x3 Permit Number 775548 6003614.61217 2116568.84347 37.791898625373705 -122.43140930798799 (37.7918986253737, -122.431409307988)
7289 111196 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2317 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/27/2015 12:00:00 AM 3   Permit Number 775548 6003599.3502400005 2116566.69152 37.7918918516902 -122.43146196059601 (37.7918918516902, -122.431461960596)
141960 108241 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 201 SUSSEX ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/06/2015 12:00:00 AM 3 3x3 Permit Number 775545 6001706.4 2096365.4 37.736316590068895 -122.436564983425 (37.7363165900689, -122.436564983425)
99492 110751 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 510 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2015 12:00:00 AM 3   Permit Number 775489 5981042.2 2112214.0 37.778636382962 -122.509184994454 (37.778636382962, -122.509184994454)
15561 43296 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 589 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/12/2015 12:00:00 AM 3   Permit Number 775309 6013581.06232 2104334.57728 37.758865901566296 -122.39606735184601 (37.7588659015663, -122.396067351846)
8629 98380 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2610 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/08/2015 12:00:00 AM 3 3x3 Permit Number 775239 6001192.51464 2117382.3552900003 37.7939947472129 -122.439848106311 (37.7939947472129, -122.439848106311)
8777 98381 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2610 Scott St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/08/2015 12:00:00 AM 3 3x3 Permit Number 775239 6001191.27881 2117387.7488599997 37.7940094862005 -122.43985276928801 (37.7940094862005, -122.439852769288)
96409 109901 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2271 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/09/2015 12:00:00 AM 3 3x3 Permit Number 775113 5987275.3 2099830.0 37.7449988337527 -122.486712981387 (37.7449988337527, -122.486712981387)
84502 109792 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2083 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/03/2015 12:00:00 AM 3 3x3 Permit Number 775060 5991259.8 2101279.3 37.7492097184614 -122.47304110371999 (37.7492097184614, -122.47304110372)
125655 109793 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2083 16th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/03/2015 12:00:00 AM 3 3x3 Permit Number 775060 5991259.8 2101279.3 37.7492097184614 -122.47304110371999 (37.7492097184614, -122.47304110372)
57170 114542 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2035 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/24/2015 12:00:00 AM 1   Permit Number 774983 6011944.84803 2103714.6650900003 37.757072587740296 -122.401682603564 (37.7570725877403, -122.401682603564)
158832 114543 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2035 22nd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/24/2015 12:00:00 AM 1   Permit Number 774983 6011964.29912 2103715.1701700003 37.7570750599871 -122.401615369369 (37.7570750599871, -122.401615369369)
45768 109206 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2322 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3 Permit Number 774968 5991447.56759 2112037.47435 37.77875966432521 -122.47317629235901 (37.7787596643252, -122.473176292359)
96398 109207 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2322 ANZA ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/2015 12:00:00 AM 3 3x3 Permit Number 774968 5991452.0 2112065.7 37.778837420858395 -122.473163018087 (37.7788374208584, -122.473163018087)
113100 109290 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2X Clover St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/06/2015 12:00:00 AM 3 3x3 Permit Number 774871 6000451.13785 2105044.8413 37.760076841062 -122.441527580895 (37.760076841062, -122.441527580895)
145693 59830 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 338 Lexington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/11/2015 12:00:00 AM 3 3x3 Permit Number 774862 6006503.62307489 2104130.4907972002 37.757909210444105 -122.420529986932 (37.7579092104441, -122.420529986932)
124629 109379 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 515 Nevada St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/12/2015 12:00:00 AM 3 3x3 Permit Number 774800 6008907.5 2095937.9 37.7355493512503 -122.41163749598199 (37.7355493512503, -122.411637495982)
95947 46181 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 337 Parnassus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/18/2015 12:00:00 AM 3   Permit Number 774705 5996482.47714154 2106592.89280999 37.7641004943074 -122.45536508001801 (37.7641004943074, -122.455365080018)
117215 46182 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 337 Parnassus Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/18/2015 12:00:00 AM 3   Permit Number 774705 5996482.47714154 2106592.89280999 37.7641004943074 -122.45536508001801 (37.7641004943074, -122.455365080018)
123805 108831 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 46 Ney St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     3x3 Permit Number 774658 6003763.1265 2093992.4287599998 37.7299176091889 -122.429284866217 (37.7299176091889, -122.429284866217)
127326 108693 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1950X Beach St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774617 6001046.33677 2120996.58295 37.803910139733794 -122.440613252117 (37.8039101397338, -122.440613252117)
139925 108694 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1950X Beach St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774617 6001046.33677 2120996.58295 37.803910139733794 -122.440613252117 (37.8039101397338, -122.440613252117)
143086 108692 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1950X Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774617 6001046.33677 2120996.58295 37.803910139733794 -122.440613252117 (37.8039101397338, -122.440613252117)
145525 108648 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 196 Lippard Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774607 6001751.75522 2094959.06379 37.7324576925005 -122.436307555189 (37.7324576925005, -122.436307555189)
139650 108635 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2610 Lake St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774602 5987336.48113 2114673.56953 37.7857587403195 -122.487591667787 (37.7857587403195, -122.487591667787)
8180 21666 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1765 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/2014 12:00:00 AM 3 4X4 Permit Number 774582 6004178.5577 2114595.027 37.7865109691436 -122.42931724201799 (37.7865109691436, -122.429317242018)
108584 8437 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1720X Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/10/2015 12:00:00 AM 3 3X3 Permit Number 774582 6003236.76685 2113929.6842 37.7846307428776 -122.432528061255 (37.7846307428776, -122.432528061255)
125207 33423 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 163 Westgate Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/01/2015 12:00:00 AM     Permit Number 774515 5993446.55612201 2094023.66864414 37.729413936236604 -122.464952451879 (37.7294139362366, -122.464952451879)
14555 86928 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 838 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/24/2014 12:00:00 AM 3 3x3 Permit Number 774404 6011553.2134300005 2104436.20347 37.759031910124 -122.403087784389 (37.759031910124, -122.403087784389)
85956 112887 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 738 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/26/2015 12:00:00 AM     Permit Number 774322 5993235.7 2110443.8 37.7744872348519 -122.46687460915399 (37.7744872348519, -122.466874609154)
5453 21659 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1750 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/26/2015 12:00:00 AM 3 4X4 Permit Number 774105 6004291.1629 2114663.74 37.786706012119296 -122.428932556586 (37.7867060121193, -122.428932556586)
5495 21662 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1750 Sutter St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/26/2015 12:00:00 AM 3 4X4 Permit Number 774105 6004219.9241 2114651.242 37.7866676632245 -122.42917813434201 (37.7866676632245, -122.429178134342)
8301 21660 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1750 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/26/2015 12:00:00 AM 3 4x4 Permit Number 774105 6004267.4166 2114661.2404 37.7866978047254 -122.429014534836 (37.7866978047254, -122.429014534836)
8744 21661 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1750 Sutter St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/26/2015 12:00:00 AM 3 4X4 Permit Number 774105 6004243.6704 2114654.9914 37.7866793023692 -122.429096245288 (37.7866793023692, -122.429096245288)
11888 108379 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Bertita St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/19/2014 12:00:00 AM 3 3x3 Permit Number 773806 6000690.090969999 2090159.58738 37.7192190489897 -122.439634019098 (37.7192190489897, -122.439634019098)
103165 108498 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 762 10th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773796 5992905.3087 2110276.51424 37.774008838888996 -122.468005315635 (37.774008838889, -122.468005315635)
102061 109092 Property Tree 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 237 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773766 6004335.1 2099509.2 37.7450977767532 -122.427700396282 (37.7450977767532, -122.427700396282)
12716 108567 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 450 Hamilton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773758 6009500.29517 2092233.5680799999 37.725411278805296 -122.409326636833 (37.7254112788053, -122.409326636833)
72213 108460 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 944 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/22/2014 12:00:00 AM 3 3x3 Permit Number 773734 6010189.19593 2103716.38941 37.7569791954421 -122.40775446824301 (37.7569791954421, -122.407754468243)
78760 63239 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3620-3622 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/22/2014 12:00:00 AM 3 3x3 Permit Number 773724 6006149.84854852 2104367.47863685 37.7585399802366 -122.421770322909 (37.7585399802366, -122.421770322909)
127421 47277 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2633 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/22/2014 12:00:00 AM 3   Permit Number 773722 6010344.90771607 2104548.95765438 37.7592739569349 -122.40727464517599 (37.7592739569349, -122.407274645176)
84620 37565 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4722 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/16/2014 12:00:00 AM 3   Permit Number 773499 6000146.90061434 2104650.61343097 37.758977050667795 -122.442551483621 (37.7589770506678, -122.442551483621)
112397 109046 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2033 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/22/2015 12:00:00 AM 3 3x3 Permit Number 773275 5990629.8 2101538.2 37.7498840951568 -122.475238529801 (37.7498840951568, -122.475238529801)
78225 109311 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 85 29th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/10/2015 12:00:00 AM 3 3x3 Permit Number 773228 6005854.7 2099005.5 37.7438005719751 -122.422410095961 (37.7438005719751, -122.422410095961)
110677 59721 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2188 15th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/11/2015 12:00:00 AM     Permit Number 773212 6002973.40402277 2107132.19230856 37.7659515776119 -122.432953405988 (37.7659515776119, -122.432953405988)
83718 55747 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 220 Gates St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/16/2014 12:00:00 AM     Permit Number 773163 6008245.8646592 2097574.24301154 37.7400052545437 -122.41404075354099 (37.7400052545437, -122.414040753541)
14693 67488 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1117 De Haro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3   Permit Number 773109 6012239.52235 2103185.1315 37.7556350439301 -122.400626303061 (37.7556350439301, -122.400626303061)
13385 108724 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 566 Rhode Island St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773100 6011759.6093 2105732.18704 37.762601916479504 -122.40246509469401 (37.7626019164795, -122.402465094694)
43330 108919 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 624 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 773067 6007633.7 2096431.2 37.7368323085558 -122.416076443366 (37.7368323085558, -122.416076443366)
85838 58303 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 150 Delmar St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/06/2016 12:00:00 AM 3   Permit Number 772898 5999424.90355926 2107324.72926963 37.766278324847605 -122.445240741314 (37.7662783248476, -122.445240741314)
1252 61532 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 347 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2017 12:00:00 AM 3   Permit Number 772896 5991195.07104 2113068.5037599998 37.781575964268896 -122.474125016615 (37.7815759642689, -122.474125016615)
6793 106875 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3200X Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/2014 12:00:00 AM 9 3x3 Permit Number 772880 5999376.012619999 2115702.7008599997 37.7892792923525 -122.446012495778 (37.7892792923525, -122.446012495778)
7650 88367 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3200X Clay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/2014 12:00:00 AM 3 3x3 Permit Number 772880 5999340.32482 2115698.11509 37.7892646630799 -122.44613564087099 (37.7892646630799, -122.446135640871)
106708 109099 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 605 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/27/2015 12:00:00 AM 3 3x3 Permit Number 772813 5995572.0 2112087.6 37.7791352386671 -122.458911991714 (37.7791352386671, -122.458911991714)
97508 108899 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 16 Hanover St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772775 6000547.04329 2086890.00633 37.710233369404605 -122.43989417722 (37.7102333694046, -122.43989417722)
12718 109057 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 825 Huron Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772770 5997289.5352300005 2087142.99435 37.7107420465867 -122.45117096298401 (37.7107420465867, -122.451170962984)
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)
140778 108402 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1285 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/19/2014 12:00:00 AM 3 3x3 Permit Number 772748 6010079.79191 2101731.52319 37.7515230698123 -122.407992860037 (37.7515230698123, -122.407992860037)
82049 69397 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1137 Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/23/2015 12:00:00 AM 3   Permit Number 772744 6001523.93675849 2087030.79827901 37.7106755138649 -122.436527911504 (37.7106755138649, -122.436527911504)
146266 109076 Property Tree 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1137 Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     3x3 Permit Number 772744 6001554.7 2087011.6 37.7106245477128 -122.43642021389401 (37.7106245477128, -122.436420213894)
140557 109055 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 320 Hanover St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772693 5999569.6 2086544.4 37.70922872292179 -122.443247602414 (37.7092287229218, -122.443247602414)
141116 66638 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 952-956 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/22/2014 12:00:00 AM 3   Permit Number 772673 6010185.68090669 2103671.40205978 37.756855473473394 -122.407763452505 (37.7568554734734, -122.407763452505)

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 2493.947ms · Data source: data.sfgov.org