Street_Tree_List

Data source: data.sfgov.org

5,577 rows where qSpecies = 12 sorted by SiteOrder descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▲ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
44167 44167 204151 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 161 : 4 Tree 1 Private 1     6 Width 0ft   5991207.7087199995 2091371.2859599998 37.722001808625706 -122.47249899053499 (37.7220018086257, -122.472498990535)
130653 130653 204150 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 158 : 4 Tree 1 Private 1     7 Width 0ft   5991209.7349 2091396.16713 37.722070243443206 -122.47249379964799 (37.7220702434432, -122.472493799648)
177342 177342 204149 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 154 : 4 Tree 1 Private 1     6 Width 0ft   5991212.71454 2091446.3716400003 37.722208265075004 -122.47248715816299 (37.722208265075, -122.472487158163)
152085 152085 204148 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 148 : 4 Tree 1 Private 1     5 Width 0ft   5991212.9902099995 2091479.34405 37.7222988151126 -122.472488607883 (37.7222988151126, -122.472488607883)
32909 32909 204147 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 143 : 4 Tree 1 Private 1     8 Width 0ft   5991215.11855 2091556.56269 37.7225109615814 -122.47248687756 (37.7225109615814, -122.47248687756)
44766 44766 204146 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 136 : 4 Tree 1 Private 1     7 Width 0ft   5991223.21581 2091608.2334599998 37.7226533053988 -122.472462652551 (37.7226533053988, -122.472462652551)
63674 63674 204145 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 135 : 4 Tree 1 Private 1     5 Width 0ft   5991223.03412 2091647.11797 37.722760062121104 -122.472466114031 (37.7227600621211, -122.472466114031)
44251 44251 204144 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 131 : 4 Tree 1 Private 1     3 Width 0ft   5991226.84892 2091709.3466 37.7229311473308 -122.47245746165599 (37.7229311473308, -122.472457461656)
167990 167990 204143 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 127 : 4 Tree 1 Private 1     4 Width 0ft   5991229.50143 2091740.19596 37.7230160055595 -122.47245054047801 (37.7230160055595, -122.472450540478)
26935 26935 204142 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 126 : 4 Tree 1 Private 1     3 Width 0ft   5991215.491640001 2091740.4912900003 37.7230160055721 -122.47249899053001 (37.7230160055721, -122.47249899053)
171798 171798 204141 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 122 : 4 Tree 1 Private 1     5 Width 0ft   5991228.41386 2091783.5857799998 37.723135080309 -122.472457461666 (37.723135080309, -122.472457461666)
186048 186048 204140 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 121 : 4 Tree 1 Private 1     3 Width 0ft   5991218.48026 2091787.2847 37.7231446616675 -122.472492069365 (37.7231446616675, -122.472492069365)
167615 167615 204139 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 120 : 4 Tree 1 Private 1     2 Width 0ft   5991219.21165 2091798.23539 37.7231747718824 -122.47249033908501 (37.7231747718824, -122.472490339085)
152667 152667 204138 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 118 : 4 Tree 1 Private 1     3 Width 0ft   5991222.04967 2091814.1267099997 37.723218569775796 -122.47248168668001 (37.7232185697758, -122.47248168668)
61374 61374 204137 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 117 : 4 Tree 1 Private 1     2 Width 0ft   5991221.343090001 2091828.09873 37.7232568925832 -122.472485147293 (37.7232568925832, -122.472485147293)
183959 183959 204136 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 115 : 4 Tree 1 Private 1     2 Width 0ft   5991237.83729 2091850.68057 37.7233198514003 -122.472429776026 (37.7233198514003, -122.472429776026)
41931 41931 204135 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 114 : 4 Tree 1 Private 1     1 Width 0ft   5991224.97526 2091857.93043 37.72333901327 -122.47247476549299 (37.72333901327, -122.472474765493)
167766 167766 204134 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 112 : 4 Tree 1 Private 1     1 Width 0ft   5991228.00205 2091882.78985 37.7234074462669 -122.472466114014 (37.7234074462669, -122.472466114014)
162792 162792 204133 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 111 : 4 Tree 1 Private 1     4 Width 0ft   5991241.7215 2091892.4700799999 37.723434819851704 -122.47241939423401 (37.7234348198517, -122.472419394234)
70012 70012 204132 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 110 : 4 Tree 1 Private 1     1 Width 0ft   5991228.632230001 2091912.6848400002 37.7234895669738 -122.47246611402001 (37.7234895669738, -122.47246611402)
41648 41648 204157 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 900 Junipero Serra Blvd 109 : 4 Tree 1 Private 1     2 Width 0ft   5991141.76494 2090345.5990099998 37.7191817082419 -122.47265219366899 (37.7191817082419, -122.472652193669)
134489 134489 204131 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 107 : 4 Tree 1 Private 1     2 Width 0ft   5991246.04706 2091955.1858 37.723607272029604 -122.472409011575 (37.7236072720296, -122.472409011575)
25562 25562 204156 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 900 Junipero Serra Blvd 106 : 4 Tree 1 Private 1     3 Width 0ft   5991140.12525 2090380.53407 37.719277536403496 -122.472660407165 (37.7192775364035, -122.472660407165)
57729 57729 204130 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 105 : 4 Tree 1 Private 1     3 Width 0ft   5991232.43649 2091974.41455 37.7236592816427 -122.47245746163901 (37.7236592816427, -122.472457461639)
161329 161329 204155 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 900 Junipero Serra Blvd 103 : 4 Tree 1 Private 1     1 Width 0ft   5991146.25454 2090417.6717700001 37.7193798621823 -122.47264192698 (37.7193798621823, -122.47264192698)
38682 38682 204129 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 96 : 4 Tree 1 Private 1     6 Width 0ft   5991250.64251 2092078.2102299999 37.723945332582105 -122.472402090391 (37.7239453325821, -122.472402090391)
67179 67179 204154 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 900 Junipero Serra Blvd 96 : 4 Tree 1 Private 1     3 Width 0ft   5991156.52869 2090538.7202700002 37.7197128262716 -122.47261523421001 (37.7197128262716, -122.47261523421)
188245 188245 204128 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 93 : 4 Tree 1 Private 1     8 Width 0ft   5991254.18034 2092103.55707 37.72401513347929 -122.472391707724 (37.7240151334793, -122.472391707724)
34026 34026 204127 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 91 : 4 Tree 1 Private 1     2 Width 0ft   5991259.14537 2092125.38495 37.7240753547864 -122.472376135061 (37.7240753547864, -122.472376135061)
41191 41191 204126 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 82 : 4 Tree 1 Private 1     7 Width 0ft   5991258.86268 2092183.21278 37.7242341192967 -122.472381325945 (37.7242341192967, -122.472381325945)
68648 68648 204125 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 81 : 4 Tree 1 Private 1     2 Width 0ft   5991261.30507 2092204.0965 37.724291602167895 -122.472374404752 (37.7242916021679, -122.472374404752)
150795 150795 204124 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 77 : 4 Tree 1 Private 1     2 Width 0ft   5991262.393519999 2092231.98748 37.7243682468726 -122.47237267447201 (37.7243682468726, -122.472372674472)
129874 129874 204123 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 73 : 4 Tree 1 Private 1     2 Width 0ft   5991264.39886 2092255.8714400001 37.7244339423611 -122.47236748268101 (37.7244339423611, -122.472367482681)
29593 29593 204122 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 72 : 4 Tree 1 Private 1     5 Width 0ft   5991266.86488 2092279.49348 37.7244989453441 -122.472360679302 (37.7244989453441, -122.472360679302)
170045 170045 204116 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 500 Junipero Serra Blvd 72 : 4 Tree 1 Private 1     5 Width 0ft   5991324.66318 2093228.93526 37.727109221303294 -122.472230057288 (37.7271092213033, -122.472230057288)
68593 68593 204115 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 500 Junipero Serra Blvd 71 : 4 Tree 1 Private 1     3 Width 0ft   5991313.39141 2093228.77227 37.7271081214352 -122.472269011404 (37.7271081214352, -122.472269011404)
60437 60437 188011 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1301 Minnesota St 68 Front Yard : Yard 7 Tree 1 Private 1     8     6015362.17662 2102309.48184 37.753404357443706 -122.389765930854 (37.7534043574437, -122.389765930854)
36272 36272 188010 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1301 Minnesota St 67 Front Yard : Yard 7 Tree 1 Private 1     6     6015365.19065 2102314.31194 37.7534177870144 -122.389755844955 (37.7534177870144, -122.389755844955)
172096 172096 204121 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 65 : 4 Tree 1 Private 1     4 Width 0ft   5991270.79215 2092345.4595299999 37.7246802990344 -122.472351910019 (37.7246802990344, -122.472351910019)
147792 147792 188009 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1301 Minnesota St 63 Front Yard : Yard 7 Tree 1 Private 1     9     6015359.2445 2102354.25155 37.7535271230016 -122.38977919765 (37.7535271230016, -122.38977919765)
178748 178748 188008 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1301 Minnesota St 62 Front Yard : Yard 7 Tree 1 Private 1     9     6015360.85476 2102358.97833 37.7535401910343 -122.389773959104 (37.7535401910343, -122.389773959104)
31270 31270 204114 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 500 Junipero Serra Blvd 61 : 4 Tree 1 Private 1     3 Width 0ft   5991316.326090001 2093291.62937 37.727280881195604 -122.472263446404 (37.7272808811956, -122.472263446404)
45020 45020 204113 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 500 Junipero Serra Blvd 60 : 4 Tree 1 Private 1     3 Width 0ft   5991329.44333 2093302.97472 37.7273127918355 -122.472218927258 (37.7273127918355, -122.472218927258)
161668 161668 204120 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 60 : 4 Tree 1 Private 1     6 Width 0ft   5991274.407240001 2092398.22017 37.724825375875604 -122.472343257638 (37.7248253758756, -122.472343257638)
182072 182072 204153 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 900 Junipero Serra Blvd 52 : 4 Tree 1 Private 1     1 Width 0ft   5991161.67549 2090655.1387900002 37.720032780762104 -122.47260592714198 (37.7200327807621, -122.472605927142)
42574 42574 204112 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 500 Junipero Serra Blvd 50 : 4 Tree 1 Private 1     4 Width 0ft   5991337.23651 2093405.4040700002 37.727594488284 -122.472199449765 (37.727594488284, -122.472199449765)
54034 54034 204119 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 43 : 4 Tree 1 Private 1     3 Width 0ft   5991263.55519 2092524.5586400002 37.725171641833 -122.47238997742599 (37.725171641833, -122.472389977426)
130626 130626 204118 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 42 : 4 Tree 1 Private 1     2 Width 0ft   5991251.557569999 2092525.31005 37.72517301061529 -122.47243150632 (37.7251730106153, -122.47243150632)
73592 73592 204117 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700 Junipero Serra Blvd 40 : 4 Tree 1 Private 1     7 Width 0ft   5991283.0301 2092546.08035 37.7252318622439 -122.472324223488 (37.7252318622439, -122.472324223488)
187020 187020 204105 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 300 Junipero Serra Blvd 40 : 4 Tree 1 Private 1     3 Width 0ft   5991399.0300199995 2094388.9297200001 37.7302985797068 -122.47205748816499 (37.7302985797068, -122.472057488165)
26979 26979 125684 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 900 Green St 39 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 5ft   6008551.13913 2119021.83646 37.7989124784736 -122.414502507697 (37.7989124784736, -122.414502507697)
72899 72899 219591 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1201 San Jose Ave 39 Front Yard : Yard 7 Tree 1 Private 1     1     6004442.021000001 2096044.89637 37.7355916358349 -122.427083979057 (37.7355916358349, -122.427083979057)
163206 163206 125683 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 900 Green St 38 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   6008554.76721 2119022.07601 37.7989133400383 -122.414489970262 (37.7989133400383, -122.414489970262)
21425 21425 11754 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700X Junipero Serra Blvd 37 Median : Cutout 11 Tree 1 DPW 2   03/09/2013 12:00:00 AM 3 6X6   5991270.92454 2092589.2026099998 37.725349564621204 -122.472369212969 (37.7253495646212, -122.472369212969)
38738 38738 125682 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 900 Green St 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   6008560.62871 2119023.68152 37.798918077657 -122.41446980113899 (37.798918077657, -122.414469801139)
164264 164264 219590 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1201 San Jose Ave 37 Front Yard : Yard 7 Tree 1 Private 1     1     6004431.32479 2096032.9751400002 37.7355582979675 -122.42712011110399 (37.7355582979675, -122.427120111104)
175436 175436 204152 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 900 Junipero Serra Blvd 37 : 4 Tree 1 Private 1     1 Width 0ft   5991169.92245 2090751.38969 37.7202975393725 -122.472584434247 (37.7202975393725, -122.472584434247)
33952 33952 184916 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1990 41st Ave 35 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5983535.2871 2102054.6745 37.750888432010996 -122.499809469293 (37.750888432011, -122.499809469293)
18049 18049 11751 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700X Junipero Serra Blvd 34 Median : Cutout 11 Tree 1 DPW 2   03/09/2013 12:00:00 AM 3 2X2   5991273.90921 2092612.06859 37.7254125216598 -122.47236056150801 (37.7254125216598, -122.472360561508)
187849 187849 184915 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1990 41st Ave 34 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5983535.9639 2102026.9239 37.750812276276996 -122.499805077969 (37.750812276277, -122.499805077969)
20481 20481 11750 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700X Junipero Serra Blvd 33 Median : Cutout 11 Tree 1 DPW 2   03/09/2013 12:00:00 AM 3 6X6   5991277.22617 2092626.95248 37.725453581094996 -122.472350179722 (37.725453581095, -122.472350179722)
94582 94582 87628 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 800X Junipero Serra Blvd 33 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/18/2008 12:00:00 AM 8 3x3   5991263.805475 2092171.0255200001 37.7242009421806 -122.47236335156099 (37.7242009421806, -122.472363351561)
18245 18245 29623 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 900X Junipero Serra Blvd 32 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3 3X3   5991172.61835 2090822.9081 37.720494067337796 -122.472580327015 (37.7204940673378, -122.472580327015)
21943 21943 11749 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700X Junipero Serra Blvd 32 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3 3X3   5991277.44671 2092637.4154400001 37.725482322545 -122.472350179738 (37.725482322545, -122.472350179738)
26929 26929 219589 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1201 San Jose Ave 32 Front Yard : Yard 7 Tree 1 Private 1     1     6004392.47127 2096007.06435 37.7354849555631 -122.42725259745 (37.7354849555631, -122.42725259745)
80910 80910 87623 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 800X Junipero Serra Blvd 32 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/18/2008 12:00:00 AM 5 3x3   5991263.805475 2092171.0255200001 37.7242009421806 -122.47236335156099 (37.7242009421806, -122.472363351561)
161064 161064 184913 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1990 41st Ave 32 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5983536.9792 2101984.2827 37.7506952549475 -122.499798415618 (37.7506952549475, -122.499798415618)
19373 19373 29622 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 900X Junipero Serra Blvd 31 Median : Cutout 11 Tree 1 DPW 2   03/09/2013 12:00:00 AM 3 3X3   5991174.87312 2090845.33876 37.720555786911 -122.472574167584 (37.720555786911, -122.472574167584)
46461 46461 184912 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1990 41st Ave 31 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5983537.656 2101960.5932 37.7506302498652 -122.499794324452 (37.7506302498652, -122.499794324452)
52864 52864 188080 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2001 Revere Ave 30 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1     6012562.79318 2096248.54902 37.7366066952456 -122.399021472774 (37.7366066952456, -122.399021472774)
66487 66487 204111 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 500 Junipero Serra Blvd 30 : 4 Tree 1 Private 1     3 Width 0ft   5991347.410519999 2093620.7950099998 37.728186486813 -122.47217997225 (37.728186486813, -122.47217997225)
87579 87579 87627 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 800X Junipero Serra Blvd 30 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/18/2008 12:00:00 AM 3 3x3   5991263.805475 2092171.0255200001 37.7242009421806 -122.47236335156099 (37.7242009421806, -122.472363351561)
172694 172694 184911 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1990 41st Ave 30 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5983537.9944 2101938.9342 37.750570800114204 -122.499791553552 (37.7505708001142, -122.499791553552)
43412 43412 188019 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1900 03rd St 29 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015659.8896 2106367.60395 37.76456359865 -122.389019682425 (37.76456359865, -122.389019682425)
73765 73765 184910 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1990 41st Ave 29 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5983538.6713 2101914.2294 37.7505030073038 -122.49978738701701 (37.7505030073038, -122.499787387017)
104186 104186 87626 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 800X Junipero Serra Blvd 29 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/18/2008 12:00:00 AM 3 3x3   5991263.805475 2092171.0255200001 37.7242009421806 -122.47236335156099 (37.7242009421806, -122.472363351561)
154655 154655 188079 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2001 Revere Ave 29 : 4 Tree 1 Private 1     1 Width 3ft   6012534.30778 2096270.76721 37.73666611435429 -122.399121518759 (37.7366661143543, -122.399121518759)
20123 20123 11745 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 700X Junipero Serra Blvd 28 Median : Cutout 11 Tree 1 DPW 2     24 2X2   5991283.014280001 2092711.56765 37.7256862482988 -122.472336336474 (37.7256862482988, -122.472336336474)
22054 22054 29619 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 900X Junipero Serra Blvd 28 Median : Cutout 11 Tree 1 DPW 2   03/09/2013 12:00:00 AM 3 3X3   5991173.80248 2090879.07845 37.720648365804294 -122.47258032701599 (37.7206483658043, -122.472580327016)
87918 87918 87702 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 799X Junipero Serra Blvd 28 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13   01/18/2008 12:00:00 AM 3 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335)
93001 93001 87625 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 800X Junipero Serra Blvd 28 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/18/2008 12:00:00 AM 3 3x3   5991263.805475 2092171.0255200001 37.7242009421806 -122.47236335156099 (37.7242009421806, -122.472363351561)
148168 148168 188078 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2001 Revere Ave 28 : 4 Tree 1 Private 1     1 Width 3ft   6012505.18891 2096292.6832 37.7367246682956 -122.399223733893 (37.7367246682956, -122.399223733893)
153053 153053 205075 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 751 Junipero Serra Blvd 28 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5991410.23162 2092923.6944900001 37.72627605788671 -122.471912013823 (37.7262760578867, -122.471912013823)
2721 2721 175371 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 27 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   5993471.88559 2087712.01586 37.712085124705204 -122.464406808033 (37.7120851247052, -122.464406808033)
73831 73831 188018 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1900 03rd St 27 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015657.72984 2106408.64657 37.7646761730861 -122.389030018324 (37.7646761730861, -122.389030018324)
122924 122924 87624 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 800X Junipero Serra Blvd 27 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/18/2008 12:00:00 AM 3 3x3   5991263.805475 2092171.0255200001 37.7242009421806 -122.47236335156099 (37.7242009421806, -122.472363351561)
148724 148724 184908 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1990 41st Ave 27 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5983541.3786 2101839.0998 37.7502968811125 -122.49977247274201 (37.7502968811125, -122.499772472742)
2708 2708 175370 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 26 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5993448.13741 2087722.6413599998 37.712112930839 -122.464489658971 (37.712112930839, -122.464489658971)
98019 98019 26777 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 800X Junipero Serra Blvd 26 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/18/2008 12:00:00 AM 3 4x4   5991258.8213354 2092171.434032 37.7242017753849 -122.472380610595 (37.7242017753849, -122.472380610595)
144279 144279 11287 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1176X Ingalls St 26 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/01/2015 10:00:00 AM 3 3X3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
157106 157106 184907 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1990 41st Ave 26 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5983543.4092 2101815.4102 37.750231955192206 -122.499763700161 (37.7502319551922, -122.499763700161)
2720 2720 175369 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 25 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   5993431.63462 2087732.39125 37.7121387503812 -122.46454740445101 (37.7121387503812, -122.464547404451)
67782 67782 205074 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 751 Junipero Serra Blvd 25 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5991407.03171 2092831.35427 37.7260223294526 -122.471916348573 (37.7260223294526, -122.471916348573)
83971 83971 87622 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 800X Junipero Serra Blvd 25 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/18/2008 12:00:00 AM 3 3x3   5991263.805475 2092171.0255200001 37.7242009421806 -122.47236335156099 (37.7242009421806, -122.472363351561)
99220 99220 88821 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 55 Page St 25 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/09/2008 12:00:00 AM   3x3 Permit Number 51708 6006333.0 2111428.0 37.7779368220791 -122.421638371919 (37.7779368220791, -122.421638371919)
110010 110010 87700 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 799X Junipero Serra Blvd 25 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13   01/18/2008 12:00:00 AM 3 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335)
173009 173009 188017 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1900 03rd St 25 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015655.49058 2106454.5994700002 37.764802225678295 -122.38904097209 (37.7648022256783, -122.38904097209)
181471 181471 112223 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2000X Turk Blvd 25 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   6000205.46291 2111993.0991599998 37.779141013771 -122.442876210646 (37.779141013771, -122.442876210646)
2722 2722 175368 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 24 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5993415.10175 2087740.6954 37.7121605985029 -122.464605149022 (37.7121605985029, -122.464605149022)
49636 49636 88820 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 55 Page St 24 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/09/2008 12:00:00 AM   3x3 Permit Number 51708 6006333.0 2111428.0 37.7779368220791 -122.421638371919 (37.7779368220791, -122.421638371919)

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