Street_Tree_List

Data source: data.sfgov.org

4,665 rows where qSiteInfo = 11 sorted by SiteOrder descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▲ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
141527 141527 204542 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 76 Median : Cutout 11 Tree 1 DPW 2     10 Width 3ft   5999719.35071 2097204.76728 37.738508176809 -122.44349529248801 (37.738508176809, -122.443495292488)
136448 136448 204543 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 75 Median : Cutout 11 Tree 1 DPW 2     13 Width 3ft   5999719.20316 2097210.6996400002 37.7385244572495 -122.44349622866301 (37.7385244572495, -122.443496228663)
152488 152488 204544 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 74 Median : Cutout 11 Tree 1 DPW 2     16 Width 3ft   5999721.65299 2097224.39457 37.7385621999964 -122.443488741827 (37.7385621999964, -122.443488741827)
27066 27066 204545 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 73 Median : Cutout 11 Tree 1 DPW 2     15 Width 3ft   5999723.14356 2097244.03838 37.7386162222515 -122.44348499883999 (37.7386162222515, -122.44348499884)
186357 186357 211055 DPW Maintained 3 Pinus muricata :: Bishop Pine 302 300x Marietta Dr 72 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   5999722.47175 2097250.7906299997 37.7386347240172 -122.443487806529 (37.7386347240172, -122.443487806529)
186128 186128 204546 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 69 Median : Cutout 11 Tree 1 DPW 2     13 Width 5ft   5999726.305480001 2097318.0909700003 37.738819733438504 -122.443479384359 (37.7388197334385, -122.443479384359)
54902 54902 204547 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 68 Median : Cutout 11 Tree 1 DPW 2     15 Width 5ft   5999723.97514 2097336.19746 37.738869316670204 -122.443488741839 (37.7388693166702, -122.443488741839)
180985 180985 204548 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 67 Median : Cutout 11 Tree 1 DPW 2     13 Width 5ft   5999721.47669 2097346.22168 37.738896698316005 -122.443498100161 (37.738896698316, -122.443498100161)
180648 180648 204549 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 66 Median : Cutout 11 Tree 1 DPW 2     12 Width 5ft   5999718.509930001 2097359.75923 37.7389337000243 -122.44350932999 (37.7389337000243, -122.44350932999)
71033 71033 211427 DPW Maintained 3 Pittosporum crassifolium :: Karo Tree 108 300x Marietta Dr 65 Median : Cutout 11 Tree 1 DPW 2     7 Width 5ft   5999709.393759999 2097376.92843 37.73898032267461 -122.443542082395 (37.7389803226746, -122.443542082395)
67188 67188 204553 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 64 Median : Cutout 11 Tree 1 DPW 2     14 Width 5ft   5999694.8834 2097395.01803 37.7390291648714 -122.443593551518 (37.7390291648714, -122.443593551518)
133892 133892 204554 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 63 Median : Cutout 11 Tree 1 DPW 2     17 Width 5ft   5999684.52262 2097404.39689 37.7390543260871 -122.443630047808 (37.7390543260871, -122.443630047808)
182627 182627 200520 DPW Maintained 3 Tristania conferta :: 79 1400x La Salle Ave 63 Median : Cutout 11 Tree 1 DPW 2     2 Width 0ft   6016476.5475 2095041.1188 37.7335086511389 -122.38540570010599 (37.7335086511389, -122.385405700106)
45970 45970 204550 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 62 Median : Cutout 11 Tree 1 DPW 2     12 Width 5ft   5999656.91248 2097430.30525 37.739123889545496 -122.44372737153499 (37.7391238895455, -122.443727371535)
58587 58587 200519 DPW Maintained 3 Tristania conferta :: 79 1400x La Salle Ave 62 Median : Cutout 11 Tree 1 DPW 2     1 Width 0ft   6016469.2023 2095054.3401 37.7335445478075 -122.38543201583401 (37.7335445478075, -122.385432015834)
38728 38728 200604 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1400x La Salle Ave 61 Median : Cutout 11 Tree 1 DPW 2     8 Width 0ft   6016455.981000001 2095075.886 37.7336029770488 -122.385479227084 (37.7336029770488, -122.385479227084)
136728 136728 204551 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 61 Median : Cutout 11 Tree 1 DPW 2     13 Width 5ft   5999648.64901 2097436.4062 37.739140169982 -122.44375638096201 (37.739140169982, -122.443756380962)
26004 26004 204552 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 60 Median : Cutout 11 Tree 1 DPW 2     11 Width 5ft   5999641.44525 2097441.40723 37.7391534907361 -122.443781647414 (37.7391534907361, -122.443781647414)
137132 137132 200619 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1400x La Salle Ave 60 Median : Cutout 11 Tree 1 DPW 2     8 Width 0ft   6016453.0429 2095085.1899 37.733628361140106 -122.38549003320101 (37.7336283611401, -122.385490033201)
30866 30866 200618 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1400x La Salle Ave 59 Median : Cutout 11 Tree 1 DPW 2     3 Width 0ft   6016445.2081 2095088.6176 37.733637339432 -122.38551735943399 (37.733637339432, -122.385517359434)
68371 68371 204555 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 59 Median : Cutout 11 Tree 1 DPW 2     14 Width 5ft   5999635.81986 2097444.2193400003 37.7391608912586 -122.443801299384 (37.7391608912586, -122.443801299384)
58287 58287 200617 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 58 Median : Cutout 11 Tree 1 DPW 2     18 Width 0ft   6016444.7184 2095097.4319 37.7336615146436 -122.385519666546 (37.7336615146436, -122.385519666546)
134194 134194 204556 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 58 Median : Cutout 11 Tree 1 DPW 2     15 Width 5ft   5999628.6217 2097449.4898200002 37.739174952168206 -122.443826565843 (37.7391749521682, -122.443826565843)
76733 76733 200616 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1400x La Salle Ave 57 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   6016436.8835 2095099.8803 37.7336678039609 -122.385546924914 (37.7336678039609, -122.385546924914)
146647 146647 204557 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 57 Median : Cutout 11 Tree 1 DPW 2     13 Width 5ft   5999620.61184 2097454.77716 37.7391890130662 -122.443854640005 (37.7391890130662, -122.443854640005)
25223 25223 208086 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 800x Junipero Serra Blvd 56 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   5991357.47228 2092905.4597099999 37.7262229367261 -122.472093069866 (37.7262229367261, -122.472093069866)
164960 164960 200615 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 56 Median : Cutout 11 Tree 1 DPW 2     13 Width 0ft   6016438.8423 2095106.2461 37.7336853915549 -122.38554059619301 (37.7336853915549, -122.385540596193)
175385 175385 204558 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 56 Median : Cutout 11 Tree 1 DPW 2     13 Width 5ft   5999610.45434 2097460.9174599997 37.739205293478896 -122.44389020099399 (37.7392052934789, -122.443890200994)
72294 72294 200614 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1400x La Salle Ave 55 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   6016432.4764 2095111.6325 37.73369982930821 -122.385562980445 (37.7336998293082, -122.385562980445)
127427 127427 106795 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 199X ARLINGTON ST 55 Median : Cutout 11 Tree 1 DPW 2     12     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
150230 150230 208085 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 800x Junipero Serra Blvd 55 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   5991358.2999 2092881.5903900003 37.726157445407296 -122.47208846980301 (37.7261574454073, -122.472088469803)
174282 174282 204559 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 55 Median : Cutout 11 Tree 1 DPW 2     16 Width 5ft   5999606.142519999 2097461.8157099998 37.739207513906706 -122.443905173798 (37.7392075139067, -122.443905173798)
56579 56579 204560 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 54 Median : Cutout 11 Tree 1 DPW 2     16 Width 5ft   5999598.12734 2097466.8336099996 37.7392208346642 -122.443933247029 (37.7392208346642, -122.443933247029)
134524 134524 180080 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1900x Alemany Blvd 54 Median : Cutout 11 Tree 1 DPW 2     2 Width 2ft   6000250.536280001 2090007.01678 37.7187750968802 -122.441142448362 (37.7187750968802, -122.441142448362)
136924 136924 200613 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 54 Median : Cutout 11 Tree 1 DPW 2     15 Width 0ft   6016431.4971 2095119.9571 37.733722632810604 -122.38556694616501 (37.7337226328106, -122.385566946165)
177434 177434 211173 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 800x Junipero Serra Blvd 54 Median : Cutout 11 Tree 1 DPW 2     24 Width 0ft   5991356.551080001 2092861.75062 37.7261028691334 -122.472093069844 (37.7261028691334, -122.472093069844)
38457 38457 208084 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 800x Junipero Serra Blvd 53 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   5991354.011469999 2092835.9648 37.726031920722605 -122.47209997035 (37.7260319207226, -122.47209997035)
43625 43625 180079 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1900x Alemany Blvd 53 Median : Cutout 11 Tree 1 DPW 2     2 Width 2ft   6000270.676519999 2090025.31664 37.71882649133779 -122.44107414397699 (37.7188264913378, -122.441074143977)
74116 74116 211428 DPW Maintained 3 Pittosporum crassifolium :: Karo Tree 108 300x Marietta Dr 53 Median : Cutout 11 Tree 1 DPW 2     10 Width 5ft   5999583.37084 2097473.06947 37.7392371150928 -122.44398471614099 (37.7392371150928, -122.443984716141)
76333 76333 200612 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1400x La Salle Ave 53 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   6016428.558999999 2095128.7713 37.7337466722751 -122.385577718213 (37.7337466722751, -122.385577718213)
133379 133379 207242 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 53 Median : Cutout 11 Tree 1 DPW 2     8 Width 0ft   5996583.3083 2088999.01444 37.7157977869175 -122.453745768776 (37.7157977869175, -122.453745768776)
23851 23851 200603 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1400x La Salle Ave 52 Median : Cutout 11 Tree 1 DPW 2     17 Width 0ft   6016419.7448 2095144.9307 37.733790555057 -122.38560931762301 (37.733790555057, -122.385609317623)
70458 70458 205113 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Junipero Serra Blvd 52 Median : Cutout 11 Tree 1 DPW 2     12 Width 0ft   5991352.77429 2092808.82601 37.7259573327624 -122.47210226989701 (37.7259573327624, -122.472102269897)
74189 74189 206440 DPW Maintained 3 Cotoneaster SPP :: Cotoneaster 234 1x Minerva St 52 Median : Cutout 11 Tree 1 DPW 2     28 Width 0ft   5996572.23219 2088998.68039 37.7157962346852 -122.45378402860399 (37.7157962346852, -122.453784028604)
166211 166211 211429 DPW Maintained 3 Pittosporum crassifolium :: Karo Tree 108 300x Marietta Dr 52 Median : Cutout 11 Tree 1 DPW 2     10 Width 5ft   5999576.15591 2097477.53164 37.739248955579 -122.44400998258001 (37.739248955579, -122.44400998258)
36741 36741 213231 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1x Minerva St 51 Median : Cutout 11 Tree 1 DPW 2     27 Width 0ft   5996543.8328 2088997.86009 37.7157923540991 -122.45388213025299 (37.7157923540991, -122.453882130253)
106180 106180 106794 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 199X ARLINGTON ST 51 Median : Cutout 11 Tree 1 DPW 2     18     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
134038 134038 212168 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 300x Marietta Dr 51 Median : Cutout 11 Tree 1 DPW 2     28 Width 5ft   5999567.44917 2097481.1748599997 37.7392584623161 -122.444040348193 (37.7392584623161, -122.444040348193)
137314 137314 200611 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1400x La Salle Ave 51 Median : Cutout 11 Tree 1 DPW 2     9 Width 0ft   6016421.2138 2095153.2552 37.7338134937512 -122.385604818769 (37.7338134937512, -122.385604818769)
159126 159126 180078 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1900x Alemany Blvd 51 Median : Cutout 11 Tree 1 DPW 2     2 Width 2ft   6000292.29675 2090045.26571 37.7188824984081 -122.44100084202101 (37.7188824984081, -122.441000842021)
166185 166185 215369 DPW Maintained 3 Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 400x Marietta Dr 51 Median : Cutout 11 Tree 1 DPW 2     4 Width 3ft   5998949.60068 2096892.4863200001 37.73760679890071 -122.44613425049499 (37.7376067989007, -122.446134250495)
32721 32721 217463 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1x Minerva St 50 Median : Cutout 11 Tree 1 DPW 2     17 Width 0ft   5996525.6642 2088997.67416 37.7157908018682 -122.45394491554701 (37.7157908018682, -122.453944915547)
48363 48363 205112 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Junipero Serra Blvd 50 Median : Cutout 11 Tree 1 DPW 2     10 Width 0ft   5991349.718230001 2092758.5362599997 37.7258190727658 -122.47210917039699 (37.7258190727658, -122.472109170397)
59915 59915 200610 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1400x La Salle Ave 50 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   6016417.2964 2095161.5798 37.733836134681795 -122.385618942498 (37.7338361346818, -122.385618942498)
137907 137907 205971 DPW Maintained 3 Cedrus deodara :: Deodar Cedar 129 400x Marietta Dr 50 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   5998959.86382 2096907.2672400002 37.737647969883206 -122.446099828942 (37.7376479698832, -122.446099828942)
185520 185520 206438 DPW Maintained 3 Cotoneaster SPP :: Cotoneaster 234 300x Marietta Dr 50 Median : Cutout 11 Tree 1 DPW 2     7 Width 5ft   5999556.5851300005 2097486.39574 37.73927217785771 -122.44407828610001 (37.7392721778577, -122.4440782861)
30424 30424 205111 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Junipero Serra Blvd 49 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   5991346.44389 2092729.4529400002 37.725739027717204 -122.472118370494 (37.7257390277172, -122.472118370494)
51011 51011 180077 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1900x Alemany Blvd 49 Median : Cutout 11 Tree 1 DPW 2     2 Width 2ft   6000313.69602 2090066.17904 37.718941140487104 -122.44092837286199 (37.7189411404871, -122.440928372862)
55316 55316 200609 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1400x La Salle Ave 49 Median : Cutout 11 Tree 1 DPW 2     1 Width 0ft   6016412.3996 2095168.4353 37.7338546875634 -122.385636349995 (37.7338546875634, -122.385636349995)
65373 65373 206437 DPW Maintained 3 Cotoneaster SPP :: Cotoneaster 234 300x Marietta Dr 49 Median : Cutout 11 Tree 1 DPW 2     9 Width 5ft   5999552.5631800005 2097488.9767299998 37.7392790352022 -122.444092377567 (37.7392790352022, -122.444092377567)
103283 103283 106793 DPW Maintained 3 Eucalyptus camaldulensis :: River Red Gum 340 199X ARLINGTON ST 49 Median : Cutout 11 Tree 1 DPW 2     9     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
181858 181858 205972 DPW Maintained 3 Cedrus deodara :: Deodar Cedar 129 400x Marietta Dr 49 Median : Cutout 11 Tree 1 DPW 2     2 Width 3ft   5998976.04571 2096922.6715 37.7376911903888 -122.446044988292 (37.7376911903888, -122.446044988292)
66335 66335 204517 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 48 Median : Cutout 11 Tree 1 DPW 2     17 Width 3ft   5998995.15377 2096935.4716400001 37.7377274276678 -122.445979843191 (37.7377274276678, -122.445979843191)
115225 115225 99164 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 302X Pacheco St 48 Median : Cutout 11 Tree 1 Private 1     24     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
131211 131211 200607 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1400x La Salle Ave 48 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   6016406.5235 2095183.1256 37.73389469904829 -122.385657689133 (37.7338946990483, -122.385657689133)
151365 151365 206436 DPW Maintained 3 Cotoneaster SPP :: Cotoneaster 234 300x Marietta Dr 48 Median : Cutout 11 Tree 1 DPW 2     26 Width 5ft   5999547.88846 2097490.32273 37.7392824643167 -122.44410863729999 (37.7392824643167, -122.4441086373)
166549 166549 180076 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1900x Alemany Blvd 48 Median : Cutout 11 Tree 1 DPW 2     3 Width 2ft   6000336.55563 2090087.7823400002 37.7190017601923 -122.440850905243 (37.7190017601923, -122.440850905243)
172148 172148 205110 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Junipero Serra Blvd 48 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   5991343.90426 2092703.6667900002 37.725668078393504 -122.472125270987 (37.7256680783935, -122.472125270987)
179057 179057 217462 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1x Minerva St 48 Median : Cutout 11 Tree 1 DPW 2     16 Width 0ft   5996487.36469 2088998.4739599999 37.7157908018916 -122.454077353311 (37.7157908018916, -122.454077353311)
38657 38657 204518 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 47 Median : Cutout 11 Tree 1 DPW 2     17 Width 3ft   5999003.37096 2096940.1521400001 37.737740748427704 -122.445951769058 (37.7377407484277, -122.445951769058)
55694 55694 180075 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1900x Alemany Blvd 47 Median : Cutout 11 Tree 1 DPW 2     3 Width 2ft   6000353.03268 2090103.7584400002 37.7190465653394 -122.44079509604401 (37.7190465653394, -122.440795096044)
130157 130157 200606 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1400x La Salle Ave 47 Median : Cutout 11 Tree 1 DPW 2     10 Width 0ft   6016400.6473 2095190.9605 37.7339158869669 -122.385678551006 (37.7339158869669, -122.385678551006)
131557 131557 210095 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 1x Minerva St 47 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   5996479.95925 2088997.21564 37.7157869222034 -122.454102858955 (37.7157869222034, -122.454102858955)
145757 145757 99163 Undocumented 2 Pinus radiata :: Monterey Pine 3 302X Pacheco St 47 Median : Cutout 11 Tree 1 Private 1     18     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
159485 159485 205109 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Junipero Serra Blvd 47 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   5991344.09487 2092681.13577 37.7256062248454 -122.472122970506 (37.7256062248454, -122.472122970506)
166845 166845 219229 DPW Maintained 3 Ilex spp :: Holly Species 163 300x Marietta Dr 47 Median : Cutout 11 Tree 1 DPW 2     11 Width 5ft   5999539.4664199995 2097492.37053 37.7392876066259 -122.44413790396601 (37.7392876066259, -122.444137903966)
33929 33929 207241 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 46 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   5996475.13618 2088997.3163599998 37.7157869221947 -122.45411953688601 (37.7157869221947, -122.454119536886)
64280 64280 180074 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1900x Alemany Blvd 46 Median : Cutout 11 Tree 1 DPW 2     3 Width 2ft   6000367.52322 2090116.8961 37.719083463616 -122.44074594986401 (37.719083463616, -122.440745949864)
65001 65001 208083 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1000x Junipero Serra Blvd 46 Median : Cutout 11 Tree 1 DPW 2     3 Width 0ft   5991231.056580001 2090980.0304 37.720928868853896 -122.472389775075 (37.7209288688539, -122.472389775075)
88064 88064 99162 Undocumented 2 Pinus radiata :: Monterey Pine 3 302X Pacheco St 46 Median : Cutout 11 Tree 1 Private 1     24     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
147123 147123 211172 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 800x Junipero Serra Blvd 46 Median : Cutout 11 Tree 1 DPW 2     18 Width 0ft   5991341.68086 2092661.31002 37.7255516485661 -122.47212987099199 (37.7255516485661, -122.472129870992)
149502 149502 215370 DPW Maintained 3 Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 400x Marietta Dr 46 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   5999044.03469 2096956.28637 37.7377873710787 -122.445812335482 (37.7377873710787, -122.445812335482)
159406 159406 200605 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1400x La Salle Ave 46 Median : Cutout 11 Tree 1 DPW 2     9 Width 0ft   6016398.6886 2095199.7747 37.7339399806144 -122.385685937001 (37.7339399806144, -122.385685937001)
184827 184827 176107 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 700x Mansell St 46 Median : Cutout 11 Tree 1 DPW 2     61 Width 0ft   6008982.60232 2089910.3513099998 37.7190031946297 -122.41095224595699 (37.7190031946297, -122.410952245957)
33216 33216 208082 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1000x Junipero Serra Blvd 45 Median : Cutout 11 Tree 1 DPW 2     3 Width 0ft   5991232.009819999 2090962.1201799999 37.720879746979705 -122.47238517505 (37.7208797469797, -122.47238517505)
42338 42338 179342 DPW Maintained 3 Quercus agrifolia :: Coast Live Oak 180 700x Mansell St 45 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   6009054.2584 2089931.4323900002 37.7190650967554 -122.410706045769 (37.7190650967554, -122.410706045769)
102180 102180 99161 Undocumented 2 Pinus radiata :: Monterey Pine 3 302X Pacheco St 45 Median : Cutout 11 Tree 1 Private 1     18     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
133114 133114 215371 DPW Maintained 3 Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 400x Marietta Dr 45 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   5999058.22079 2096961.6514400002 37.737802912270205 -122.445763673175 (37.7378029122702, -122.445763673175)
134500 134500 180073 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1900x Alemany Blvd 45 Median : Cutout 11 Tree 1 DPW 2     4 Width 2ft   6000381.06487 2090130.7736900002 37.719122339514605 -122.44070013662201 (37.7191223395146, -122.440700136622)
149487 149487 208977 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 300x Marietta Dr 45 Median : Cutout 11 Tree 1 DPW 2     27 Width 5ft   5999505.82373 2097502.74743 37.7393141797969 -122.44425497048401 (37.7393141797969, -122.444254970484)
177749 177749 200602 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1400x La Salle Ave 45 Median : Cutout 11 Tree 1 DPW 2     13 Width 0ft   6016396.2402 2095212.996 37.7339761481789 -122.385695323117 (37.7339761481789, -122.385695323117)
42569 42569 175629 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 700x Mansell St 44 Median : Cutout 11 Tree 1 DPW 2     17 Width 0ft   6009095.75789 2089908.2938299999 37.719003889795104 -122.410560964431 (37.7190038897951, -122.410560964431)
60138 60138 203309 DPW Maintained 3 Acer macrophyllum :: Big Leaf Maple 159 300x Marietta Dr 44 Median : Cutout 11 Tree 1 DPW 2     12 Width 5ft   5999493.35383 2097506.1285599996 37.7393227521334 -122.444298328617 (37.7393227521334, -122.444298328617)
62628 62628 200574 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1400x La Salle Ave 44 Median : Cutout 11 Tree 1 DPW 2     1 Width 0ft   6016364.4111 2095326.6015 37.734286324847005 -122.385813282871 (37.734286324847, -122.385813282871)
65599 65599 207240 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 44 Median : Cutout 11 Tree 1 DPW 2     14 Width 0ft   5996458.70543 2088998.7901400002 37.7157900266684 -122.45417643520001 (37.7157900266684, -122.4541764352)
68941 68941 205108 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Junipero Serra Blvd 44 Median : Cutout 11 Tree 1 DPW 2     8 Width 0ft   5991339.84346 2092605.6938200002 37.7253988339751 -122.472132170572 (37.7253988339751, -122.472132170572)
70422 70422 205090 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 1000x Junipero Serra Blvd 44 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   5991232.93514 2090942.88536 37.7208269864641 -122.472380575028 (37.7208269864641, -122.472380575028)
76514 76514 210024 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 400x Marietta Dr 44 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   5999068.6414 2096968.17305 37.737821414033796 -122.445728113076 (37.7378214140338, -122.445728113076)
89044 89044 99160 Undocumented 2 Pinus radiata :: Monterey Pine 3 302X Pacheco St 44 Median : Cutout 11 Tree 1 Private 1     48     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
122029 122029 114995 DPW Maintained 3 Eucalyptus camaldulensis :: River Red Gum 340 199x ARLINGTON ST 44 Median : Cutout 11 Tree 1 DPW 2     20 3x3   6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)

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