Street_Tree_List

Data source: data.sfgov.org

3,530 rows where qSpecies = 60 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
184572 184572 119961 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 450 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 4ft   5987197.92043 2112907.45085 37.780901400579296 -122.48794122965299 (37.7809014005793, -122.487941229653)
184475 184475 222134 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 181 Henry St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6002383.1294599995 2107348.26301 37.7665113566521 -122.435010496549 (37.7665113566521, -122.435010496549)
184458 184458 212074 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 99 San Pablo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 6ft   5994256.6309 2097391.5669400003 37.738708030453 -122.462396147864 (37.738708030453, -122.462396147864)
184442 184442 141153 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1970 O'Farrell St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 0ft   6001825.2934 2113278.2643 37.782761967251794 -122.437364615403 (37.7827619672518, -122.437364615403)
184420 184420 201549 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 601 Innes Ave 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 6ft   6020789.549380001 2093251.9329799998 37.728833562500206 -122.370370588629 (37.7288335625002, -122.370370588629)
184352 184352 245900 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1085 Page St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6001380.4441 2109353.6946 37.771960789741996 -122.43862230722999 (37.771960789742, -122.43862230723)
184287 184287 248137 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 232 Rutledge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6010014.43727 2099509.45576 37.7454181024656 -122.408062173836 (37.7454181024656, -122.408062173836)
184228 184228 176027 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 343 Alpha St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 Width 3ft   6010655.072790001 2087637.48051 37.71285599659021 -122.40501118873199 (37.7128559965902, -122.405011188732)
184198 184198 212301 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 1000x Junipero Serra Blvd 17 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   5991188.84719 2090215.0879099998 37.7188260821255 -122.47247994019199 (37.7188260821255, -122.472479940192)
184196 184196 212014 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 12 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     43 Width 8ft   5992297.48126 2096582.96013 37.736374788861205 -122.469111066343 (37.7363747888612, -122.469111066343)
184153 184153 206344 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 102 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 3ft   5992999.81177 2098311.82197 37.7411623657427 -122.466808476338 (37.7411623657427, -122.466808476338)
184142 184142 121486 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 381 Wilde Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 3x3   6010841.281330001 2089139.2910200001 37.716990071210205 -122.404473235851 (37.7169900712102, -122.404473235851)
184128 184128 126286 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1819 Mason St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6009103.85324 2119545.7916900003 37.8003821649739 -122.412626986872 (37.8003821649739, -122.412626986872)
184066 184066 176047 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 0 Gonzalez Dr 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24     5988958.7133 2089588.42281 37.7169760831658 -122.480142699133 (37.7169760831658, -122.480142699133)
184035 184035 248813 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 66 Woodland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 5ft   5997123.1490400005 2106092.58883 37.762763526430994 -122.453113075912 (37.762763526431, -122.453113075912)
183980 183980 212024 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 70 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 8ft   5992351.29301 2096226.79986 37.735399971427604 -122.468899107835 (37.7353999714276, -122.468899107835)
183917 183917 248726 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1800 Folsom St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   6007996.84764 2107526.36051 37.767317522420704 -122.41560620428001 (37.7673175224207, -122.41560620428)
183865 183865 222945 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 654 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002583.33438 2108874.36058 37.7707130117228 -122.434427147715 (37.7707130117228, -122.434427147715)
183837 183837 248720 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1800 Folsom St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   6007986.94611 2107740.3439700003 37.767904514417296 -122.415655604923 (37.7679045144173, -122.415655604923)
183791 183791 126217 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2342 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 4ft   6003470.04395 2115943.11425 37.790172338042005 -122.431864815529 (37.790172338042, -122.431864815529)
183741 183741 212089 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 223 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 4ft   5994065.04722 2096675.37629 37.7367305147902 -122.463006600482 (37.7367305147902, -122.463006600482)
183695 183695 248633 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1550 Bryant St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6009395.0721 2107534.93214 37.767419555005 -122.410770529855 (37.767419555005, -122.410770529855)
183535 183535 248764 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 3235 18th St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6008029.676530001 2105592.5030400003 37.762009444000796 -122.415355734976 (37.7620094440008, -122.415355734976)
183513 183513 138385 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1916 Scott St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 0ft   6001516.6978 2115025.7345 37.7875425246475 -122.438557470268 (37.7875425246475, -122.438557470268)
183466 183466 140640 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 450 STANYAN ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 0ft   5996856.1757 2110026.5378 37.7735498337191 -122.454320611441 (37.7735498337191, -122.454320611441)
183413 183413 142423 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 10 MAYFAIR DR 38 Sidewalk: Property side : Yard 9 Tree 1 Private 1     26 Width 0ft   5997605.1735 2114516.8881 37.7859220855908 -122.45205376754801 (37.7859220855908, -122.452053767548)
183381 183381 141733 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1550 O'Farrell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 0ft   6003850.579 2113561.9176 37.783655736688296 -122.430378229205 (37.7836557366883, -122.430378229205)
183263 183263 201474 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 200 Catalina St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   6017913.7738 2095996.98532 37.73621268247221 -122.380503161112 (37.7362126824722, -122.380503161112)
183254 183254 126148 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1535 Chestnut St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6004474.30573 2120123.1658 37.8017065704734 -122.428688249077 (37.8017065704734, -122.428688249077)
183252 183252 249775 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 102 Pfeiffer St 6 Side Yard : Yard 17 Tree 1 Private 1     21 Width 0ft   6010401.04426 2121152.2311400003 37.8048657692012 -122.40825153418999 (37.8048657692012, -122.40825153419)
183214 183214 248761 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2995 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6008325.75729 2103272.24141 37.75565517256911 -122.41416754082199 (37.7556551725691, -122.414167540822)
183177 183177 123548 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 61 05th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     34 Width 8ft   5994235.7315 2115185.59254 37.787564586392605 -122.463759573058 (37.7875645863926, -122.463759573058)
183171 183171 248860 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1800 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6007702.84177 2107906.06122 37.7683435607327 -122.416650032975 (37.7683435607327, -122.416650032975)
183037 183037 137523 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1300 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   6002284.7946 2113025.2803 37.782093448931604 -122.43575683171001 (37.7820934489316, -122.43575683171)
183025 183025 212126 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 400x Miramar Ave 2 Median : Yard 3 Tree 1 DPW 2     7     5995367.13793 2092485.42648 37.725300846538 -122.458201574057 (37.725300846538, -122.458201574057)
183004 183004 124438 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 349 Cherry St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996187.96111 2114964.97685 37.7870711366417 -122.456989324693 (37.7870711366417, -122.456989324693)
182959 182959 206392 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 128 San Pablo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   5994243.34729 2097107.2475700001 37.7379265951457 -122.46242145931002 (37.7379265951457, -122.46242145931)
182952 182952 205103 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Junipero Serra Blvd 37 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   5991326.973119999 2092437.01185 37.724934930379206 -122.47216437168899 (37.7249349303792, -122.472164371689)
182927 182927 205086 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 1000x Junipero Serra Blvd 39 Median : Cutout 11 Tree 1 DPW 2     12 Width 0ft   5991226.90116 2090814.4677099998 37.7204740340313 -122.472392075543 (37.7204740340313, -122.472392075543)
182817 182817 244245 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 176 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   6005740.1233 2110010.337 37.7740108141999 -122.42358852680401 (37.7740108141999, -122.423588526804)
182810 182810 212062 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 31 San Pablo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   5994561.16155 2097812.55217 37.7398814829331 -122.461373742812 (37.7398814829331, -122.461373742812)
182771 182771 206350 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 184 Granville Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     38 Width 4ft   5994323.43209 2098716.7593099996 37.7423505248605 -122.462261267567 (37.7423505248605, -122.462261267567)
182768 182768 205503 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1106 Noriega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 4ft   5990538.13175 2103170.07444 37.7543594797245 -122.475674667545 (37.7543594797245, -122.475674667545)
182636 182636 212094 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1901 08th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 6ft   5993744.934230001 2102518.09307 37.7527546952954 -122.464537475935 (37.7527546952954, -122.464537475935)
182611 182611 222130 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 885 Church St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   6004385.859759999 2103714.04754 37.7566461795833 -122.42782443225 (37.7566461795833, -122.42782443225)
182603 182603 126303 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 150 Lombard St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6011649.709869999 2120828.01575 37.804045393249105 -122.40390753979601 (37.8040453932491, -122.403907539796)
182593 182593 248759 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2987 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6008379.36946 2103275.26244 37.755666478840794 -122.41398234611201 (37.7556664788408, -122.413982346112)
182543 182543 244902 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1479 Page St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   5999486.2858 2109089.2489 37.771126754619296 -122.44515530342599 (37.7711267546193, -122.445155303426)
182345 182345 126247 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 649 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6006451.94637 2112482.08949 37.7808378023715 -122.42130176638099 (37.7808378023715, -122.421301766381)
182338 182338 124436 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 349 Cherry St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5996183.98307 2114995.74085 37.78715537789021 -122.457005313806 (37.7871553778902, -122.457005313806)
182337 182337 201470 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 300 Catalina St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   6017720.50763 2095978.01132 37.7361499169812 -122.381170049779 (37.7361499169812, -122.381170049779)
182289 182289 142429 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 10 MAYFAIR DR 44 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 0ft   5997546.2881 2114509.7813 37.785899199038404 -122.45225698079399 (37.7858991990384, -122.452256980794)
182257 182257 212115 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 1902x Monterey Blvd 3 Median : Yard 3 Tree 1 DPW 2     20 Width 10ft   5992194.67664 2095416.97281 37.7331673397011 -122.46938165614401 (37.7331673397011, -122.469381656144)
182229 182229 106951 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 156 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2014 12:00:00 AM 22 3x3 Permit Number 773389 5987431.57269 2114958.38797 37.7865463157209 -122.487283609867 (37.7865463157209, -122.487283609867)
182169 182169 212152 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Miramar Ave 2 Median : Yard 3 Tree 1 DPW 2     6     5995399.05929 2094305.60657 37.730300456589106 -122.458222905079 (37.7303004565891, -122.458222905079)
182006 182006 142450 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 10 MAYFAIR DR 65 Sidewalk: Property side : Yard 9 Tree 1 Private 1     28 Width 0ft   5997309.2236 2114478.6465 37.7858001276963 -122.45307490578199 (37.7858001276963, -122.453074905782)
181975 181975 189522 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 211 Acacia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6018001.89898 2096225.38149 37.7368446756287 -122.380214340243 (37.7368446756287, -122.380214340243)
181938 181938 205102 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Junipero Serra Blvd 36 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   5991324.44766 2092411.88768 37.7248657994962 -122.472171271311 (37.7248657994962, -122.472171271311)
181936 181936 123474 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 500 Arguello Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5995635.04193 2112771.30555 37.7810161358776 -122.45874341644199 (37.7810161358776, -122.458743416442)
181805 181805 217819 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 1x Junipero Serra Blvd 6 Median : Yard 3 Tree 1 DPW 2     33     5991622.365809999 2095679.35409 37.733854682528204 -122.471379381376 (37.7338546825282, -122.471379381376)
181804 181804 126277 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2245 Larkin St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 3ft   6006750.98374 2118968.9394799997 37.7986659419281 -122.42072789367799 (37.7986659419281, -122.420727893678)
181706 181706 120384 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 221 El Camino Del Mar 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   5987878.79334 2115302.0322 37.7875159336053 -122.48576158708201 (37.7875159336053, -122.485761587082)
181695 181695 99878 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 261 Laurel St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 6x8   5998035.65095 2115667.71588 37.7891066027242 -122.450647442448 (37.7891066027242, -122.450647442448)
181681 181681 245831 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1550 Bryant St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6009391.30468 2107606.84722 37.7676168059854 -122.410788640404 (37.7676168059854, -122.410788640404)
181486 181486 206349 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 585 Dewey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   5994065.68943 2099332.8123 37.744027207395504 -122.463197147941 (37.7440272073955, -122.463197147941)
181420 181420 245897 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1079 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   6001422.324 2109361.3393 37.7719841624955 -122.43847798964899 (37.7719841624955, -122.438477989649)
181387 181387 123862 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 360 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 6ft   5994314.68424 2114911.0304900003 37.7868152630267 -122.46346648151899 (37.7868152630267, -122.463466481519)
181348 181348 248866 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2952 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6008525.96691 2103326.42191 37.755815183527204 -122.413478982074 (37.7558151835272, -122.413478982074)
181318 181318 189500 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 210 Acacia Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6017962.8634 2096182.15193 37.7367238220301 -122.38034630134399 (37.7367238220301, -122.380346301344)
181176 181176 46349 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 600@Washington St Montgomery St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/27/2002 12:00:00 AM 15   Permit Number 44594 6011797.44129 2117605.10565 37.795204314679204 -122.40316945722401 (37.7952043146792, -122.403169457224)
181175 181175 246201 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 737 Buena Vista Ave West 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   5999867.4062 2107975.6789 37.7680909179697 -122.44375698405099 (37.7680909179697, -122.443756984051)
181091 181091 189479 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 149 Brannan St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 6ft   6015989.350430001 2113670.21229 37.78463320668921 -122.388389888999 (37.7846332066892, -122.388389888999)
181034 181034 189481 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 21 Commer Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 4ft   6016437.42975 2094713.06601 37.732605719368 -122.38551808840599 (37.732605719368, -122.385518088406)
181032 181032 126307 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 19 Chestnut St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 5ft   6011412.75588 2121088.95225 37.8047486199155 -122.40474592110901 (37.8047486199155, -122.404745921109)
181020 181020 248837 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 25 Coleridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 3ft   6007006.28464 2099607.0473 37.7455171807726 -122.41847082467301 (37.7455171807726, -122.418470824673)
180978 180978 248644 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 3531 17th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 5ft   6005345.612919999 2106028.31476 37.7630548591151 -122.424669880304 (37.7630548591151, -122.424669880304)
180926 180926 126181 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1451 Bay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6003742.08845 2120700.5958 37.8032505760096 -122.431263297686 (37.8032505760096, -122.431263297686)
180869 180869 126302 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 150 Lombard St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft   6011734.76105 2120835.8555 37.8040716705345 -122.40361376458799 (37.8040716705345, -122.403613764588)
180861 180861 124265 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 198 Lake St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 5ft   5994917.96135 2114932.47737 37.7869088898941 -122.461380853946 (37.7869088898941, -122.461380853946)
180770 180770 212087 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 167 San Pablo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   5994327.30745 2096736.9968299998 37.7369148128582 -122.462104326864 (37.7369148128582, -122.462104326864)
180636 180636 206368 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 80 Southwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     39 Width 3ft   5995490.98867 2092437.7384400002 37.7251770224761 -122.457769987599 (37.7251770224761, -122.457769987599)
180628 180628 249479 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 1300x Van Ness Ave 3 Median : Yard 3 Tree 1 DPW 2     13     6006342.53317 2115134.23147 37.7881137637835 -122.42186872687799 (37.7881137637835, -122.421868726878)
180622 180622 248823 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 179 Bocana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   6007303.73593 2098009.03207 37.741146128478604 -122.41732905800801 (37.7411461284786, -122.417329058008)
180603 180603 206418 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 99x Castenada Ave 16 Median : Cutout 11 Tree 1 DPW 2     17 Width 5ft   5993828.80673 2100251.01259 37.7465347043225 -122.464082870453 (37.7465347043225, -122.464082870453)
180572 180572 138566 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2610 Pine St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     29 Width 0ft   6001380.6936 2114953.3963 37.7873361651051 -122.439022830324 (37.7873361651051, -122.439022830324)
180471 180471 139674 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2130 O'Farrell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6001010.6483 2113164.7145 37.782403842642495 -122.440174791199 (37.7824038426425, -122.440174791199)
180393 180393 120221 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 250 25th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft   5988083.13088 2114289.3007900002 37.7847471664462 -122.48498030073401 (37.7847471664462, -122.484980300734)
180222 180222 124152 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 950 Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   5996091.59731 2112260.8127 37.779640688597105 -122.45712703643 (37.7796406885971, -122.45712703643)
180199 180199 206399 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 180 San Pablo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5994282.11485 2096795.55872 37.737073007196706 -122.46226482258899 (37.7370730071967, -122.462264822589)
180128 180128 201468 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 300 Catalina St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   6017677.66407 2095970.41595 37.7361266964906 -122.381317651001 (37.7361266964906, -122.381317651001)
180124 180124 248649 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2x Lyell St 3 Median : Yard 3 Tree 1 DPW 2     14     6002995.03876 2095080.26155 37.732861037793 -122.43201788462 (37.732861037793, -122.43201788462)
180108 180108 189433 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 301 Mendell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6016822.99867 2097792.72493 37.741083170550105 -122.384399488272 (37.7410831705501, -122.384399488272)
180098 180098 126325 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 514 Commercial St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   6012207.85144 2117304.6767599997 37.7944023199544 -122.401728237874 (37.7944023199544, -122.401728237874)
180084 180084 212221 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1120 Bosworth St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   6000906.19434 2095834.6392700002 37.7348137393466 -122.439293588824 (37.7348137393466, -122.439293588824)
180044 180044 120055 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 146 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 5ft   5987431.73679 2114982.94917 37.786613763301794 -122.48728484684099 (37.7866137633018, -122.487284846841)
179786 179786 212148 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 700x Miramar Ave 3 Median : Yard 3 Tree 1 DPW 2     2     5995395.17866 2094120.1752900002 37.7297910841891 -122.45822290508801 (37.7297910841891, -122.458222905088)
179714 179714 212205 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 920 Bosworth St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17     6001520.45314 2095614.45375 37.7342440970832 -122.43715412776301 (37.7342440970832, -122.437154127763)
179659 179659 189493 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1556 Kirkwood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 3ft   6015494.57113 2096576.90512 37.737671231745296 -122.388907886803 (37.7376712317453, -122.388907886803)
179527 179527 212281 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 751 Junipero Serra Blvd 26 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 3ft   5991407.58411 2092857.5665 37.726094333681104 -122.47191634855801 (37.7260943336811, -122.471916348558)
179457 179457 126275 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2836 Larkin St 7 Side Yard : Yard 17 Tree 1 Private 1     26     6006511.2494 2120976.42855 37.8041644823576 -122.421700114785 (37.8041644823576, -122.421700114785)

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