Street_Tree_List

Data source: data.sfgov.org

221 rows where qSiteInfo = 2 and qSpecies = 12 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 221 ✖
Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
188944 188944 184944 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1990 41st Ave 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5983563.2069 2101275.9659 37.748751952115505 -122.49965537495702 (37.7487519521155, -122.499655374957)
188930 188930 250562 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 445 El Camino Del Mar 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5987191.81534 2115294.08526 37.7874540598079 -122.488137777348 (37.7874540598079, -122.488137777348)
188924 188924 218143 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 72 Ridge Ln 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5997148.20318 2090029.45832 37.718659516001 -122.451867536453 (37.718659516001, -122.451867536453)
188874 188874 175294 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 760 Mansell St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   6009619.4023 2090150.4820700001 37.7196982320664 -122.408767998643 (37.7196982320664, -122.408767998643)
188784 188784 184377 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1521 Rivera St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   5988408.1936 2100317.5308 37.7464034445307 -122.48283140934299 (37.7464034445307, -122.482831409343)
188007 188007 175344 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2 Brotherhood Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5993634.16802 2087703.44428 37.7120709424008 -122.463845295648 (37.7120709424008, -122.463845295648)
187900 187900 250616 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 107 28th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5987080.55182 2115289.10715 37.7874338997015 -122.488522355317 (37.7874338997015, -122.488522355317)
187833 187833 204943 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 101 Santa Paula Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   5994032.70638 2097142.34763 37.7380108391394 -122.46315228886101 (37.7380108391394, -122.463152288861)
186888 186888 175547 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 348 Chicago Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6002373.36986 2086487.8856799998 37.709233027364995 -122.433553309758 (37.709233027365, -122.433553309758)
186739 186739 184949 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1990 41st Ave 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5983558.4689 2101406.2583 37.749109421016605 -122.499681387134 (37.7491094210166, -122.499681387134)
185937 185937 175354 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2 Brotherhood Way 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5992875.91855 2087892.32357 37.712545834802604 -122.46647972197901 (37.7125458348026, -122.466479721979)
185571 185571 204815 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1801 08th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5993723.97604 2103200.32785 37.75462672856371 -122.46465948875601 (37.7546267285637, -122.464659488756)
185082 185082 188203 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 251 Executive Park Blvd 14 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6014389.30237 2087003.03012 37.7113219591221 -122.39206003394399 (37.7113219591221, -122.392060033944)
184907 184907 188201 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 251 Executive Park Blvd 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6014503.81395 2086993.06554 37.711300955448706 -122.39166355343399 (37.7113009554487, -122.391663553434)
184799 184799 184945 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1990 41st Ave 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5983563.2069 2101296.9480000003 37.7488095631642 -122.49965692549101 (37.7488095631642, -122.499656925491)
184782 184782 204025 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 345 Grafton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5995726.34615 2090539.6194900002 37.7199787576063 -122.456819166779 (37.7199787576063, -122.456819166779)
183782 183782 204034 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 90 Lobos St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     5995999.69668 2088710.81573 37.7149729844955 -122.455742167474 (37.7149729844955, -122.455742167474)
182404 182404 182722 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1723 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5985925.1892 2103477.2512 37.754934393373496 -122.49164978734801 (37.7549343933735, -122.491649787348)
181866 181866 188021 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1001 17th St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 2ft   6014166.75536 2106634.96887 37.7652148445035 -122.394202790137 (37.7652148445035, -122.394202790137)
181253 181253 204942 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 55 San Lorenzo Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   5993727.74592 2097576.18572 37.73918447778829 -122.464238167152 (37.7391844777883, -122.464238167152)
180888 180888 205071 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 751 Junipero Serra Blvd 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5991360.7446800005 2092152.3739200002 37.7241553395843 -122.472026891444 (37.7241553395843, -122.472026891444)
180225 180225 250564 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 501 El Camino Del Mar 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5987034.5187099995 2115351.01486 37.787601194276206 -122.488686170456 (37.7876011942762, -122.488686170456)
179407 179407 222044 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 201 Treat Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   6008934.48658 2107737.73779 37.7679505767784 -122.41237797446199 (37.7679505767784, -122.412377974462)
179178 179178 222042 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 201 Treat Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   6008921.89984 2107704.72386 37.7678592218483 -122.41241917689699 (37.7678592218483, -122.412419176897)
178749 178749 219643 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 453 Valley St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19     6003027.9388 2099186.49327 37.7441376711314 -122.432197284976 (37.7441376711314, -122.432197284976)
178179 178179 204100 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2 Brotherhood Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5993729.19042 2087617.8937400002 37.7118415163357 -122.46351066868 (37.7118415163357, -122.46351066868)
178095 178095 204796 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1964 16th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5991297.713880001 2102046.6126 37.7513187540815 -122.472965944645 (37.7513187540815, -122.472965944645)
177515 177515 117771 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 401 38th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5984040.463409999 2113093.42371 37.781227336507705 -122.498877996337 (37.7812273365077, -122.498877996337)
177411 177411 250451 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 190 Seacliff Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5987248.64548 2115760.65458 37.788738440071 -122.48797545423099 (37.788738440071, -122.487975454231)
177173 177173 219663 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 101 Carmel St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5998207.34442 2105345.19067 37.760773436477706 -122.449309393328 (37.7607734364777, -122.449309393328)
175845 175845 250917 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 287 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5987111.03944 2114049.93943 37.7840332797446 -122.488325775231 (37.7840332797446, -122.488325775231)
175617 175617 222046 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 201 Treat Ave 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   6008949.0881900005 2107769.84292 37.768039549403504 -122.41232973843901 (37.7680395494035, -122.412329738439)
175356 175356 175345 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2 Brotherhood Way 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 5ft   5993607.01879 2087723.8804799998 37.7121254907785 -122.463940612974 (37.7121254907785, -122.463940612974)
174509 174509 204957 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 460 Pacheco St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   5993693.78698 2101896.46232 37.7510449078018 -122.464669214927 (37.7510449078018, -122.464669214927)
172997 172997 250921 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 282 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5987155.66741 2114065.86584 37.784079612815795 -122.488172551429 (37.7840796128158, -122.488172551429)
171931 171931 204019 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 551 Junipero Serra Blvd 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5991451.54656 2093545.31958 37.727985276083395 -122.47181447517 (37.7279852760834, -122.47181447517)
171715 171715 175349 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2 Brotherhood Way 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5993438.390819999 2087824.9996200001 37.7123934203956 -122.4645307733 (37.7123934203956, -122.4645307733)
171665 171665 219756 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1335 Douglass St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 2ft   6001388.58619 2099788.88641 37.7456986154004 -122.43790893236601 (37.7456986154004, -122.437908932366)
171033 171033 119594 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 3145 Cabrillo St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 2ft   5985824.5308 2110420.315 37.7739922254809 -122.492509174554 (37.7739922254809, -122.492509174554)
170680 170680 204949 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 135 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   5994022.774119999 2096956.70637 37.737500542219 -122.46317316303002 (37.737500542219, -122.46317316303)
170322 170322 188198 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 251 Executive Park Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6014615.61789 2086983.20072 37.711280074094205 -122.39127643847999 (37.7112800740942, -122.39127643848)
170049 170049 204946 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 101 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5994008.44212 2097065.4765599999 37.7377983724866 -122.463230605425 (37.7377983724866, -122.463230605425)
168337 168337 204795 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1964 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   5991296.36687 2102036.80057 37.7512917348225 -122.47296988727501 (37.7512917348225, -122.472969887275)
167342 167342 222040 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 201 Treat Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   6008911.780730001 2107668.87189 37.7677602127833 -122.41245164333401 (37.7677602127833, -122.412451643334)
165557 165557 204945 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 101 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5994007.17215 2097079.9143 37.737837941769 -122.463236043629 (37.737837941769, -122.463236043629)
165533 165533 175297 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 800 Mansell St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   6009452.06912 2090099.6823599997 37.7195493726733 -122.409342829102 (37.7195493726733, -122.409342829102)
165504 165504 125598 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 55 Laurel St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 5ft   5997962.54777 2116175.89912 37.790497754121795 -122.450937027734 (37.7904977541218, -122.450937027734)
165131 165131 175348 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2 Brotherhood Way 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   5993488.42633 2087804.6670900001 37.7123404763923 -122.464356361476 (37.7123404763923, -122.464356361476)
163862 163862 218200 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 950 Ulloa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 2ft   5993085.15224 2098374.09173 37.741338267754294 -122.466517926976 (37.7413382677543, -122.466517926976)
163301 163301 250618 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 108 28th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5987122.80154 2115273.55204 37.787393655047104 -122.488375038274 (37.7873936550471, -122.488375038274)
158059 158059 120756 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 33 20th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5989560.64886 2114955.0041900002 37.7866609499601 -122.479917366138 (37.7866609499601, -122.479917366138)
157667 157667 204960 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 35 Rockwood Ct 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5995790.8650400005 2098821.17747 37.7427216175128 -122.45719491342301 (37.7427216175128, -122.457194913423)
157424 157424 204017 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 551 Junipero Serra Blvd 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5991443.38091 2093425.61385 37.727656121533705 -122.47183398327499 (37.7276561215337, -122.471833983275)
157133 157133 175298 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1498 Geneva Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   6002915.8546400005 2087711.61866 37.712623896842295 -122.431765713815 (37.7126238968423, -122.431765713815)
156853 156853 205068 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 851 Junipero Serra Blvd 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5991321.67962 2091578.12457 37.7225763324184 -122.47212009448799 (37.7225763324184, -122.472120094488)
154783 154783 183727 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2255 35th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5985430.1991 2099855.1597 37.744960177470205 -122.493094769051 (37.7449601774702, -122.493094769051)
154638 154638 184947 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1990 41st Ave 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5983560.8379 2101339.2508 37.7489255759542 -122.49966824346701 (37.7489255759542, -122.499668243467)
154011 154011 221012 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 675 Sanchez St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   6003707.3772 2104386.93833 37.7584553727299 -122.43021887361401 (37.7584553727299, -122.430218873614)
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)
152935 152935 117770 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 401 38th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5984040.53311 2113104.0044 37.781256392087606 -122.498878537141 (37.7812563920876, -122.498878537141)
152915 152915 117972 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 420 38th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5984093.27919 2112967.0901900004 37.780883559180104 -122.498685947337 (37.7808835591801, -122.498685947337)
152811 152811 175355 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2 Brotherhood Way 14 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 5ft   5992860.6815599995 2087893.2281099998 37.7125474391986 -122.46653245101001 (37.7125474391986, -122.46653245101)
151763 151763 175286 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 325 Olmstead St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6010711.19323 2090926.76022 37.721890824193004 -122.405048677871 (37.721890824193, -122.405048677871)
151357 151357 219778 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 929 Elizabeth St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6000431.24087 2101957.7943700003 37.751599428891204 -122.44137488264201 (37.7515994288912, -122.441374882642)
150936 150936 125586 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1570 Greenwich St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   6005351.57668 2119600.69848 37.800321618997295 -122.425615279117 (37.8003216189973, -122.425615279117)
150513 150513 188202 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 251 Executive Park Blvd 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   6014410.24908 2087000.56675 37.711316358145794 -122.39198746407101 (37.7113163581458, -122.391987464071)
149507 149507 245035 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 21 Baker St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   6000804.6982 2109205.0004 37.7715197437189 -122.44060318310899 (37.7715197437189, -122.440603183109)
148859 148859 181851 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2301 25th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5988541.8992 2099607.3772 37.744461328811 -122.482317054002 (37.744461328811, -122.482317054002)
148357 148357 204948 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 111 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   5994014.61795 2097029.94632 37.737701171061396 -122.463206675372 (37.7377011710614, -122.463206675372)
148220 148220 175296 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 760 Mansell St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6009588.23355 2090141.41392 37.7196715869614 -122.40887509890499 (37.7196715869614, -122.408875098905)
147983 147983 184948 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1990 41st Ave 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5983561.1763 2101354.4797 37.7489674101607 -122.49966819869101 (37.7489674101607, -122.499668198691)
147559 147559 124079 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 701 Funston Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5991941.58389 2110150.4186299997 37.7736069135372 -122.471329782846 (37.7736069135372, -122.471329782846)
147087 147087 204950 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 135 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   5994024.2821 2096935.7591799998 37.73744311331011 -122.463166429792 (37.7374431133101, -122.463166429792)
146365 146365 204101 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2 Brotherhood Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 5ft   5993659.00835 2087684.8091799999 37.712021206289 -122.46375808926099 (37.712021206289, -122.463758089261)
143123 143123 250613 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 501 El Camino Del Mar 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   5987051.19605 2115348.6411599996 37.787595649976296 -122.488628296378 (37.7875956499763, -122.488628296378)
137855 137855 250452 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 190 Seacliff Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5987230.75462 2115760.09761 37.7887358671233 -122.48803731227301 (37.7887358671233, -122.488037312273)
136217 136217 204944 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 101 Santa Paula Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5994019.05211 2097121.33108 37.7379523463344 -122.463197973519 (37.7379523463344, -122.463197973519)
135747 135747 117747 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 429 39th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5983737.9655 2112912.98734 37.780714163442894 -122.499911131684 (37.7807141634429, -122.499911131684)
135636 135636 117968 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 414 38th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5984091.8335 2113030.1543400004 37.781056630188104 -122.498695608696 (37.7810566301881, -122.498695608696)
135404 135404 117969 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 414 38th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5984091.66198 2113022.12438 37.7810345721966 -122.49869560869 (37.7810345721966, -122.49869560869)
135273 135273 204988 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 361 Kensington Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5994123.90476 2099085.28191 37.7433509046111 -122.46297789860701 (37.7433509046111, -122.462977898607)
134460 134460 175544 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 187 Seville St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   6001192.72242 2087375.86302 37.7116041582787 -122.437697356964 (37.7116041582787, -122.437697356964)
134243 134243 184946 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1990 41st Ave 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5983561.8532 2101319.6223 37.7488717410938 -122.49966328209801 (37.7488717410938, -122.499663282098)
133973 133973 250614 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 107 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5987083.69063 2115313.12063 37.7875000169526 -122.48851326139999 (37.7875000169526, -122.4885132614)
133358 133358 250617 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 108 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5987120.23284 2115251.6203799997 37.7873332871477 -122.48838231292 (37.7873332871477, -122.48838231292)
133215 133215 118534 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 7915 Geary Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5982448.31014 2112345.83773 37.7790811700363 -122.504330568895 (37.7790811700363, -122.504330568895)
132141 132141 175546 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 298 Cordova St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 8ft   6001847.622269999 2087157.43402 37.7110416161394 -122.435418236567 (37.7110416161394, -122.435418236567)
131569 131569 222048 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 201 Treat Ave 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   6008966.61771 2107803.04506 37.768131698438204 -122.412271452472 (37.7681316984382, -122.412271452472)
130948 130948 204852 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 601 Moraga St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5992428.45263 2103856.05172 37.7563524025705 -122.46918743764401 (37.7563524025705, -122.469187437644)
130647 130647 204779 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1811 17th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 2ft   5990906.362980001 2103054.34687 37.754063063173 -122.4743927982 (37.754063063173, -122.4743927982)
130249 130249 246809 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 161 Brewster St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   6010252.11367 2098972.92466 37.7439582096165 -122.407202509188 (37.7439582096165, -122.407202509188)
129935 129935 184951 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1990 41st Ave 15 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5983556.4384 2101452.6221 37.7492366040439 -122.49969183478001 (37.7492366040439, -122.49969183478)
129800 129800 175351 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2 Brotherhood Way 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5993236.647480001 2087885.91358 37.7125490435751 -122.465232475607 (37.7125490435751, -122.465232475607)
129213 129213 204947 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 111 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5994012.76503 2097046.5891200001 37.737746761309296 -122.463214289036 (37.7377467613093, -122.463214289036)
126914 126914 94321 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 501 El Camino Del Mar 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/15/2010 12:00:00 AM     Permit Number 53625 5987118.0 2115378.0 37.7876801589176 -122.488399329426 (37.7876801589176, -122.488399329426)
125056 125056 183143 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2315 38th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5984514.4702 2099409.3038 37.743682379514496 -122.49622825542 (37.7436823795145, -122.49622825542)
118385 118385 250922 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 282 28th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5987155.11745 2114076.2326 37.784108044888 -122.488175216114 (37.784108044888, -122.488175216114)
108814 108814 94323 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 501@ 28th Ave El Camino Del Mar 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/15/2010 12:00:00 AM     Permit Number 53625 5987118.0 2115378.0 37.7876801589176 -122.488399329426 (37.7876801589176, -122.488399329426)
105503 105503 94325 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 501@ 28th Ave El Camino Del Mar 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/15/2010 12:00:00 AM     Permit Number 53625 5987118.0 2115378.0 37.7876801589176 -122.488399329426 (37.7876801589176, -122.488399329426)
98037 98037 94322 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 501 El Camino Del Mar 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/15/2010 12:00:00 AM     Permit Number 53625 5987118.0 2115378.0 37.7876801589176 -122.488399329426 (37.7876801589176, -122.488399329426)

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