Street_Tree_List

Data source: data.sfgov.org

251 rows where DBH = 1 and qSpecies = 18 sorted by Longitude

View and edit SQL

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

DBH

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
67142 118470 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 510 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5981008.92024 2112222.55161 37.7786579010228 -122.50930075514499 (37.7786579010228, -122.509300755145)
148645 34700 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 546 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/23/2009 12:00:00 AM 1 3x3 Permit Number 52703 5981644.97521 2112008.50675 37.7781076783894 -122.507084551143 (37.7781076783894, -122.507084551143)
147767 119067 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 575 45th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5981914.59302 2111829.39054 37.7776317534825 -122.506138577528 (37.7776317534825, -122.506138577528)
163678 81982 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 563 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/11/2007 12:00:00 AM 1 3x3 Permit Number 49998 5982533.65676 2111927.12728 37.7779365331701 -122.504004303472 (37.7779365331701, -122.504004303472)
136410 82431 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 650 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/2009 12:00:00 AM 1 3x3 Permit Number 52680 5982600.56645 2111346.95635 37.7763474878375 -122.503729865488 (37.7763474878375, -122.503729865488)
50531 96079 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 664 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2011 12:00:00 AM 1 3x3 Permit Number 767703 5983226.11153 2111277.81973 37.7761944189321 -122.501560849986 (37.7761944189321, -122.501560849986)
135433 96081 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 790 41st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2011 12:00:00 AM 1 3x3 Permit Number 767704 5983251.84023 2110453.37841 37.773932253218 -122.501410848383 (37.773932253218, -122.501410848383)
23887 83255 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 790 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   1     5983253.61867 2110435.38712 37.773882958787205 -122.501403365431 (37.7738829587872, -122.501403365431)
180951 73633 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 782 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/1996 12:00:00 AM 1     5983562.4874599995 2110479.0519 37.7740209842304 -122.500338183608 (37.7740209842304, -122.500338183608)
160586 95194 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 517 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2011 12:00:00 AM 1 3x3 Permit Number 767108 5985627.976369999 2112321.20657 37.7792000368481 -122.49332915492701 (37.7792000368481, -122.493329154927)
75705 250820 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 60 Sea View Ter 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5986182.97775 2114165.47247 37.7842963089586 -122.49154499381599 (37.7842963089586, -122.491544993816)
153946 250819 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 60 Sea View Ter 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5986191.04243 2114164.9353 37.7842953053345 -122.49151705368999 (37.7842953053345, -122.49151705369)
155038 119498 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 811 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5986314.77262 2110365.9929400003 37.773871723515 -122.49080937068999 (37.773871723515, -122.49080937069)
185212 119495 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 831 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5986317.41656 2110242.64878 37.773533209765795 -122.49079114745199 (37.7735332097658, -122.490791147452)
135875 250645 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2610 Lake St 6 : 4 Tree 1 Private 1     1 Width 3ft   5987300.52243 2114656.77456 37.78571052885479 -122.48771483877199 (37.7857105288548, -122.487714838772)
75805 120094 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 749 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5987846.68793 2110842.25702 37.7752687833001 -122.485545250327 (37.7752687833001, -122.485545250327)
40632 120241 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 288 24th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5988396.42783 2114046.0373400003 37.784097477489794 -122.483878566425 (37.7840974774898, -122.483878566425)
37977 72335 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 775 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/17/1996 12:00:00 AM 1     5988805.09626 2110041.06897 37.773124736634294 -122.482171226619 (37.7731247366343, -122.482171226619)
37932 120691 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 346 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5989055.073580001 2112994.27839 37.7812479638107 -122.481522861281 (37.7812479638107, -122.481522861281)
54653 51291 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2020 Clement St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/26/2004 12:00:00 AM 1   Permit Number 47663 5989189.38676 2113364.18569 37.7822714342333 -122.481085302679 (37.7822714342333, -122.481085302679)
48514 50297 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2909 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/2004 12:00:00 AM 1   Permit Number 47009 5989047.82914 2095849.4982599998 37.7341725865769 -122.48029267728701 (37.7341725865769, -122.480292677287)
56297 179040 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2945 24th Ave 4 : 4 Tree 1 Private 1     1 Width 2ft   5989055.545969999 2095618.79902 37.7335395942586 -122.480249118621 (37.7335395942586, -122.480249118621)
64127 105980 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 750 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/12/2014 12:00:00 AM 1 3x4 Permit Number 772437 5989466.7948900005 2110227.47578 37.7736750233383 -122.479895995237 (37.7736750233383, -122.479895995237)
10315 47259 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1487 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/11/2014 12:00:00 AM 1 3x3 Permit Number 770986 5989591.7291 2105266.36 37.7600604072843 -122.479100863475 (37.7600604072843, -122.479100863475)
126323 103499 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1850X Cabrillo St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/12/2014 12:00:00 AM 1 3x3 Permit Number 771036 5989789.80565 2110619.51755 37.774770222886204 -122.478807342211 (37.7747702228862, -122.478807342211)
180438 103498 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1850X Cabrillo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/12/2014 12:00:00 AM 1 3x3 Permit Number 771036 5989807.55073 2110619.1422900003 37.774770222887604 -122.478745931564 (37.7747702228876, -122.478745931564)
146930 103497 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1850X Cabrillo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/12/2014 12:00:00 AM 1 3x3 Permit Number 771036 5989824.39083 2110619.3957 37.7747718964667 -122.47868769738001 (37.7747718964667, -122.47868769738)
44697 103496 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1850X Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/12/2014 12:00:00 AM 1 3x3 Permit Number 771036 5989840.04595 2110621.50302 37.7747785915425 -122.478633697845 (37.7747785915425, -122.478633697845)
28695 214477 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1587 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5990545.71643 2104592.61626 37.758265842404 -122.47575231233601 (37.758265842404, -122.475752312336)
171618 68224 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1500 Clement St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/01/2012 12:00:00 AM 1   Permit Number 769229 5990833.387490001 2113424.07906 37.782531317215295 -122.47540222511999 (37.7825313172153, -122.47540222512)
51276 214657 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2033 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5990646.87273 2101531.01352 37.7498653525019 -122.475178967532 (37.7498653525019, -122.475178967532)
147133 68292 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/27/1993 12:00:00 AM 1   Permit Number 32101 5991174.54811 2115022.5246200003 37.7869399743547 -122.47433864858101 (37.7869399743547, -122.474338648581)
169229 214485 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2027 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5990955.91795 2101581.62177 37.7500222167656 -122.47411397779 (37.7500222167656, -122.47411397779)
121797 214666 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2116 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5991020.8875 2100990.67096 37.7484033831124 -122.473846204659 (37.7484033831124, -122.473846204659)
148771 214488 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1627 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5991131.791019999 2104317.70681 37.757544974643295 -122.473705376225 (37.7575449746433, -122.473705376225)
60325 214563 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1450 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5991226.48085 2106597.45408 37.7638100387342 -122.47354419252599 (37.7638100387342, -122.473544192526)
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)
177005 214490 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2083 16th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5991275.47389 2101260.33758 37.7491585600375 -122.47298552109 (37.7491585600375, -122.47298552109)
34050 214489 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2083 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5991276.32219 2101284.43599 37.7492247771203 -122.47298434476801 (37.7492247771203, -122.472984344768)
184263 214495 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1475 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5991461.16113 2105386.7472200003 37.7604993473767 -122.47264423464199 (37.7604993473767, -122.472644234642)
43645 213424 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2329 Cecilia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5991443.60729 2099536.95345 37.7444363251911 -122.47227850735001 (37.7444363251911, -122.47227850735)
179381 213434 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2326 Cecilia Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5991474.66936 2099581.1439400003 37.7445594585564 -122.47217432268499 (37.7445594585564, -122.472174322685)
30946 214679 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2662 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5991458.95209 2097290.33549 37.7382685749396 -122.472061728486 (37.7382685749396, -122.472061728486)
24941 214585 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1275 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5991735.0327699995 2106752.18709 37.7642643321484 -122.471796560669 (37.7642643321484, -122.471796560669)
159935 123886 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 235 12th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992114.67796 2113795.92215 37.7836264835221 -122.47099665339701 (37.7836264835221, -122.470996653397)
24786 123887 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 235 12th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992115.40766 2113777.13838 37.783574950661794 -122.47099276010701 (37.7835749506618, -122.470992760107)
69474 214675 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2666 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5991784.11224 2097296.36475 37.7383039407656 -122.47093793473199 (37.7383039407656, -122.470937934732)
53314 95695 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 523 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/09/2011 12:00:00 AM 1 3x3 Permit Number 767449 5992184.07474 2111863.6623299997 37.7783250403386 -122.47061578659999 (37.7783250403386, -122.4706157866)
170172 59138 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 531 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/23/1980 12:00:00 AM 1   Permit Number 18444 5992185.73773 2111803.62567 37.7781602921817 -122.47060565987302 (37.7781602921817, -122.470605659873)
132392 41910 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 595 12th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/20/2000 12:00:00 AM 1   Permit Number 42273 5992200.00918 2111450.35788 37.7771911401531 -122.470530554439 (37.7771911401531, -122.470530554439)
67236 123076 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 715 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992228.91883 2110544.82187 37.7747064553196 -122.470364585283 (37.7747064553196, -122.470364585283)
75419 123083 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 761 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992242.95608 2110253.84595 37.7739083256607 -122.47029483379801 (37.7739083256607, -122.470294833798)
160348 218239 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 333 Wawona St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 2ft   5992027.82558 2097196.10935 37.738042756963296 -122.47008800346599 (37.7380427569633, -122.470088003466)
56542 213324 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 355 Byxbee St 1 : 4 Tree 1 Private 1     1 Width 3ft   5991941.51913 2090886.05993 37.7207119433918 -122.469927103079 (37.7207119433918, -122.469927103079)
34728 123892 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 285 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5992432.92995 2113586.68874 37.7830703873676 -122.469880394252 (37.7830703873676, -122.469880394252)
31810 214634 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1258 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992402.51004 2106874.95458 37.764640016757795 -122.469496904268 (37.7646400167578, -122.469496904268)
186644 123107 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 526 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992541.355380001 2111846.16706 37.778297656419795 -122.469378557612 (37.7782976564198, -122.469378557612)
137826 123110 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 538 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992545.70931 2111780.6216599997 37.7781179381566 -122.46935872370399 (37.7781179381566, -122.469358723704)
71087 123089 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 667 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5992530.32341 2110923.09875 37.775762523428504 -122.46934951505501 (37.7757625234285, -122.469349515055)
177092 94734 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 706 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/28/2010 12:00:00 AM 1 3x3 Permit Number 53865 5992586.2471199995 2110603.0007 37.7748868521692 -122.46913276056002 (37.7748868521692, -122.46913276056)
186079 213586 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2146 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992608.85526 2100815.1518900003 37.748013300381395 -122.468342327659 (37.7480133003814, -122.468342327659)
54381 123144 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 572 10th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   5992865.77571 2111587.1444200003 37.7776051929209 -122.46823742950501 (37.7776051929209, -122.468237429505)
168286 214628 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1442 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5992754.41359 2105631.11276 37.7612450859223 -122.468189283707 (37.7612450859223, -122.468189283707)
155840 123928 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 229 09th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993040.69288 2113905.84608 37.783981818349396 -122.467801020728 (37.7839818183494, -122.467801020728)
65949 214701 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 289 Santa Ana Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992648.14001 2094956.6542099998 37.7319296144386 -122.467780457307 (37.7319296144386, -122.467780457307)
154905 214630 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1603 10th Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993055.4787 2104534.05584 37.758250237384 -122.46706827337499 (37.758250237384, -122.467068273375)
33846 123222 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 738 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5993211.31332 2110438.04706 37.7744700313031 -122.466958548333 (37.7744700313031, -122.466958548333)
172144 214549 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 820 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993190.74703 2106665.16617 37.7641095156677 -122.466755374078 (37.7641095156677, -122.466755374078)
43899 214548 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 800 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     1 Width 4ft   5993241.508719999 2106665.1801299998 37.7641124834295 -122.46657980664 (37.7641124834295, -122.46657980664)
169821 213590 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1922 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993177.337040001 2102373.1853099996 37.7523240792136 -122.466489781784 (37.7523240792136, -122.466489781784)
41091 214637 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1231 09th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993277.56181 2107122.2146799997 37.765369460447296 -122.466488331178 (37.7653694604473, -122.466488331178)
29788 214638 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1239 09th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993279.003830001 2107062.36881 37.7652052226678 -122.466478993514 (37.7652052226678, -122.466478993514)
182210 214639 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1243 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993279.97178 2107044.2021 37.7651553975224 -122.46647432513399 (37.7651553975224, -122.466474325134)
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)
165715 214643 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1262 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5993331.87743 2106912.72627 37.764797394518204 -122.466285241766 (37.7647973945182, -122.466285241766)
49034 214547 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 754 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993387.3182 2106668.96839 37.764131298133 -122.46607577350099 (37.764131298133, -122.466075773501)
33473 214546 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 714 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993519.43334 2106675.98145 37.7641581752734 -122.465619338785 (37.7641581752734, -122.465619338785)
70081 214717 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 151 Westgate Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993452.86708 2094012.79018 37.729384430533706 -122.464929844743 (37.7293844305337, -122.464929844743)
48960 214716 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 163 Westgate Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993482.35353 2094088.81019 37.729594862901 -122.46483342661502 (37.729594862901, -122.464833426615)
65415 214681 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 18 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993846.98731 2099285.74524 37.743885371716 -122.463949948827 (37.743885371716, -122.463949948827)
158648 123574 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 126 05th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5994298.992459999 2114690.05308 37.786207615068896 -122.463504728187 (37.7862076150689, -122.463504728187)
152202 214767 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 333 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5994252.85515 2100808.3467 37.7480894333884 -122.462656990837 (37.7480894333884, -122.462656990837)
166393 214768 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 48 Marcela Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5994762.16541 2100788.31407 37.7480637478616 -122.460894375369 (37.7480637478616, -122.460894375369)
136084 214838 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 525 Faxon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5994748.09139 2092048.02975 37.7240642697395 -122.460309866434 (37.7240642697395, -122.460309866434)
56087 58297 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 284 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/27/1978 12:00:00 AM 1   Permit Number 17314 5995266.20192 2113689.20735 37.783515241763894 -122.46008592615101 (37.7835152417639, -122.460085926151)
62219 213573 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 401 Dewey Blvd 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5995208.70184 2100413.07322 37.7470591142869 -122.459323109585 (37.7470591142869, -122.459323109585)
180014 100870 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 23 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/18/2012 12:00:00 AM 1 3x3 Permit Number 769325 5995481.9791 2111446.40578 37.7773695144675 -122.45917696584299 (37.7773695144675, -122.459176965843)
175693 124157 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 970 Anza St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5995831.42602 2112225.3212200003 37.779528293484894 -122.45802450638 (37.7795282934849, -122.45802450638)
28184 214762 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 81 Northwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5995454.99385 2094213.2008599997 37.730049946826796 -122.45802284817199 (37.7300499468268, -122.458022848172)
166562 214763 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 81 Northwood Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5995479.81772 2094208.1402 37.7300374777322 -122.457936663441 (37.7300374777322, -122.457936663441)
181872 124180 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 8X Almaden Ct 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 9ft   5995876.0 2112606.0 37.7805760973259 -122.457897862346 (37.7805760973259, -122.457897862346)
154824 124154 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 950 Anza St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5996038.476969999 2112254.19163 37.779619458078706 -122.457310322373 (37.7796194580787, -122.457310322373)
28640 124153 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 950 Anza St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5996057.73725 2112257.8824 37.7796306981474 -122.45724396024201 (37.7796306981474, -122.457243960242)
150341 72450 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3880 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/13/1996 12:00:00 AM 1     5996319.64273 2114949.8711200003 37.7870372213321 -122.456532645474 (37.7870372213321, -122.456532645474)
3100 124475 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 336 Willard St North 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2008 12:00:00 AM 1 Width 3ft Permit Number 51142 5996295.75285 2110564.44719 37.7749946376288 -122.456298087251 (37.7749946376288, -122.456298087251)
165673 213384 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 337 Parnassus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   5996440.690219999 2106573.21313 37.7640440612137 -122.45550818547899 (37.7640440612137, -122.455508185479)
63304 213383 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 337 Parnassus Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   5996461.62761 2106582.16791 37.764069850154904 -122.455436416867 (37.7640698501549, -122.455436416867)
66928 214803 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 861 Rockdale Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5996696.54151 2098246.82779 37.741196566960795 -122.454021889422 (37.7411965669608, -122.454021889422)
55168 214804 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 861 Rockdale Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5996707.74048 2098249.43953 37.7412043802882 -122.45398335617399 (37.7412043802882, -122.453983356174)
189007 214828 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 14 Holloway Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5996730.05288 2091219.63097 37.7219034920315 -122.453398786937 (37.7219034920315, -122.453398786937)

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