Street_Tree_List

Data source: data.sfgov.org

3,127 rows where qSpecies = 44 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location
147053 147053 226002 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 169 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 9ft   6005477.49545 2100188.99105 37.7470288826965 -122.42379851640499 (37.7470288826965, -122.423798516405)
47942 47942 219125 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 149 Hamerton Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 8ft   6001356.75125 2095315.06653 37.733412742195505 -122.43769866186899 (37.7334127421955, -122.437698661869)
48307 48307 192459 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 651 Indiana St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   6014938.7100599995 2105394.68115 37.761852161564605 -122.391446047021 (37.7618521615646, -122.391446047021)
49658 49658 190382 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 2350 20th St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 8ft   6011068.2259 2104645.22046 37.7595787284893 -122.404779824648 (37.7595787284893, -122.404779824648)
58695 58695 190381 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 2350 20th St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 8ft   6011079.30934 2104645.54641 37.7595802429642 -122.404741515334 (37.7595802429642, -122.404741515334)
71798 71798 192460 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 651 Indiana St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 8ft   6014934.120519999 2105449.3054400003 37.7620018933059 -122.391465739479 (37.7620018933059, -122.391465739479)
164823 164823 226270 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 4491 24th St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     26 Width 8ft   6000072.435819999 2101640.71207 37.7507083509117 -122.442592908247 (37.7507083509117, -122.442592908247)
66255 66255 226004 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 94 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 7ft   6006211.975430001 2099539.93145 37.745288147737796 -122.42121266156099 (37.7452881477378, -122.421212661561)
27480 27480 120474 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 88 West Clay St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5988469.711569999 2115060.56996 37.78688736184021 -122.483699443255 (37.7868873618402, -122.483699443255)
29287 29287 120447 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 55 22nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   5988944.82314 2114949.71234 37.7866106225502 -122.482047561852 (37.7866106225502, -122.482047561852)
32867 32867 219077 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 494 Victoria St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 6ft   5993267.6387 2090426.62452 37.7195270128342 -122.465309800205 (37.7195270128342, -122.465309800205)
33326 33326 120459 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 67 West Clay St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   5988568.8662 2114996.16494 37.7867162951637 -122.48335167219999 (37.7867162951637, -122.4833516722)
33767 33767 190391 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 571 Texas St 2 : 4 Tree 1 Private 1     1 Width 6ft   6013851.28196 2104449.17868 37.75919560292179 -122.395140827087 (37.7591956029218, -122.395140827087)
36111 36111 190489 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 543 Delancey St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 6ft   6015419.98604 2113488.70595 37.7841032649961 -122.390347029604 (37.7841032649961, -122.390347029604)
36189 36189 120471 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 88 West Clay St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   5988434.04491 2115070.90864 37.7869136727274 -122.483823598526 (37.7869136727274, -122.483823598526)
36527 36527 190498 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 538 Delancey St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 6ft   6015168.4177 2113757.9053 37.784828467492396 -122.39123619648599 (37.7848284674924, -122.391236196486)
37978 37978 120443 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 77 22nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   5988946.9866 2114882.9089200003 37.786427325124 -122.48203518126199 (37.786427325124, -122.482035181262)
40645 40645 190496 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 541 Delancey St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 6ft   6015207.26145 2113719.36295 37.7847247945658 -122.39109911375799 (37.7847247945658, -122.391099113758)
43317 43317 190454 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 25 Pomona St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   6014177.43025 2094543.7925 37.732015626522106 -122.39331967567101 (37.7320156265221, -122.393319675671)
55262 55262 190485 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 543 Delancey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 6ft   6015539.69218 2113369.9861 37.783783926534205 -122.38992459017 (37.7837839265342, -122.38992459017)
59808 59808 190492 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 541 Delancey St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 6ft   6015312.24709 2113599.7666599997 37.78440223562829 -122.390727534552 (37.7844022356283, -122.390727534552)
62558 62558 190490 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 543 Delancey St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 6ft   6015415.34325 2113497.1894099996 37.7841263011177 -122.39036368505501 (37.7841263011177, -122.390363685055)
65669 65669 120444 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 65 22nd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   5988946.42808 2114912.8547400003 37.786509515373794 -122.48203930813101 (37.7865095153738, -122.482039308131)
70192 70192 120446 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 55 22nd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   5988945.575730001 2114940.19348 37.7865845302304 -122.482044260519 (37.7865845302304, -122.482044260519)
71418 71418 120472 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 88 West Clay St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   5988447.19453 2115067.03638 37.786903806069 -122.483777820382 (37.786903806069, -122.483777820382)
72091 72091 176525 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 555 Lisbon St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6001927.74225 2090254.03018 37.7195487332566 -122.435362686337 (37.7195487332566, -122.435362686337)
73119 73119 120442 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 77 22nd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   5988947.55811 2114864.8414 37.7863777500738 -122.482031879947 (37.7863777500738, -122.482031879947)
73721 73721 190497 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 538 Delancey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 6ft   6015173.48225 2113768.9969200003 37.7848592036193 -122.391219450233 (37.7848592036193, -122.391219450233)
76471 76471 120473 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 88 West Clay St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5988459.1629 2115064.1874700002 37.7868966804599 -122.483736204114 (37.7868966804599, -122.483736204114)
129993 129993 128906 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 586 Spruce St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 6ft   5997146.092730001 2113991.53957 37.7844533108166 -122.453604104844 (37.7844533108166, -122.453604104844)
137708 137708 120445 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 65 22nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   5988945.83143 2114929.73493 37.7865558288888 -122.482042609422 (37.7865558288888, -122.482042609422)
149353 149353 226003 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 101 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 6ft   6005787.68664 2100206.63449 37.7470948335555 -122.42272715405899 (37.7470948335555, -122.422727154059)
149723 149723 190487 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 543 Delancey St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 6ft   6015525.841469999 2113384.34733 37.7838225910846 -122.389973512379 (37.7838225910846, -122.389973512379)
150465 150465 190494 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 541 Delancey St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 6ft   6015224.29962 2113700.39003 37.7846736447102 -122.39103884028499 (37.7846736447102, -122.391038840285)
158730 158730 190493 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 541 Delancey St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 6ft   6015305.914580001 2113614.1863700002 37.784441477541 -122.390750451073 (37.784441477541, -122.390750451073)
160828 160828 190495 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 541 Delancey St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 6ft   6015210.04745 2113708.9413099997 37.7846963337125 -122.391088746357 (37.7846963337125, -122.391088746357)
165064 165064 226139 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 1406 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 6ft   6003891.6342400005 2100016.96395 37.7464668837446 -122.42927002320499 (37.7464668837446, -122.429270023205)
165744 165744 190488 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 543 Delancey St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 6ft   6015434.43193 2113480.36737 37.7840811704488 -122.39029646881501 (37.7840811704488, -122.390296468815)
178936 178936 120460 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 67 West Clay St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   5988559.61165 2114998.49915 37.7867221656327 -122.483383861528 (37.7867221656327, -122.483383861528)
182666 182666 120458 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 67 West Clay St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   5988579.7702 2114992.84531 37.7867078149969 -122.483313703981 (37.7867078149969, -122.483313703981)
183754 183754 190491 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 541 Delancey St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 6ft   6015329.13045 2113592.35808 37.7843828300441 -122.390668605586 (37.7843828300441, -122.390668605586)
184777 184777 190486 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 543 Delancey St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 6ft   6015531.29876 2113374.48851 37.7837958236503 -122.38995394312201 (37.7837958236503, -122.389953943122)
1991 1991 123758 Permitted Site 1 Ginkgo biloba :: Maidenhair Tree 44 201 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   5994989.32477 2110751.87532 37.7754341833406 -122.46083085861 (37.7754341833406, -122.46083085861)
23651 23651 190549 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 888 07th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6012420.73101 2108662.95487 37.7706860338703 -122.400384364769 (37.7706860338703, -122.400384364769)
25489 25489 190577 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 450 South St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6016001.60495 2107966.2922099996 37.7689721859532 -122.387949335392 (37.7689721859532, -122.387949335392)
26155 26155 190587 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 1245 03rd St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   6015583.31199 2109308.81865 37.7726352865222 -122.38948996669701 (37.7726352865222, -122.389489966697)
26284 26284 248135 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 115 Rutledge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6010354.084919999 2099463.5381099996 37.745311033696105 -122.406884485526 (37.7453110336961, -122.406884485526)
27105 27105 190584 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 448 South St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015754.04725 2107952.30918 37.7689200738306 -122.388804652706 (37.7689200738306, -122.388804652706)
28937 28937 190459 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 5 Anthony St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6012789.14548 2115174.16236 37.788584851165204 -122.399567224573 (37.7885848511652, -122.399567224573)
29506 29506 226156 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 246 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 5ft   6004770.05084 2100194.87108 37.747005065928 -122.42624521916201 (37.747005065928, -122.426245219162)
32484 32484 190550 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 888 07th St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6012436.95281 2108645.13993 37.7706380226612 -122.400327001491 (37.7706380226612, -122.400327001491)
34761 34761 190464 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 560 Mission St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6012895.81714 2115160.20532 37.7885524737596 -122.39919717422701 (37.7885524737596, -122.399197174227)
34866 34866 128940 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 999 Geary St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6007019.651319999 2114299.92893 37.7858611365224 -122.419466797772 (37.7858611365224, -122.419466797772)
35951 35951 190593 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 526 Nelson Rising Ln 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6015368.52983 2108277.33516 37.769791149064496 -122.39016085285601 (37.7697911490645, -122.390160852856)
38170 38170 190579 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 450 South St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015952.68728 2107963.87261 37.7689628321048 -122.38811837108801 (37.7689628321048, -122.388118371088)
38500 38500 190544 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 888 07th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6012334.18585 2108753.30483 37.770929287873294 -122.400690075812 (37.7709292878733, -122.400690075812)
38707 38707 225742 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 1111 Noe St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6003207.588690001 2101761.35624 37.7512178267583 -122.431759901518 (37.7512178267583, -122.431759901518)
38754 38754 219028 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 1490 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 5ft   5991185.310269999 2105281.9213400004 37.76019555188989 -122.473590620024 (37.7601955518899, -122.473590620024)
39200 39200 190545 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 888 07th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6012350.80552 2108735.87054 37.770882344183704 -122.400631362642 (37.7708823441837, -122.400631362642)
39648 39648 190568 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 550 South St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6016318.75266 2107983.43695 37.7690368265244 -122.386853527668 (37.7690368265244, -122.386853527668)
41276 41276 128931 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 2101 Washington St 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6004999.26308 2116762.74652 37.79250941163579 -122.42663222261999 (37.7925094116358, -122.42663222262)
41841 41841 190594 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 526 Nelson Rising Ln 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6015350.67018 2108276.18439 37.7697869987055 -122.390222549028 (37.7697869987055, -122.390222549028)
42788 42788 246481 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 330 Duncan St 1 : 4 Tree 1 Private 1     10 Width 5ft   6004176.06205 2099871.25195 37.74608289033021 -122.42827612036301 (37.7460828903302, -122.428276120363)
44030 44030 128939 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 999 Geary St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6007005.09645 2114299.52069 37.7858591957899 -122.41951712470801 (37.7858591957899, -122.419517124708)
45130 45130 190604 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 355 Campus Way 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015329.13458 2107531.20473 37.7677402532417 -122.39024498531299 (37.7677402532417, -122.390244985313)
46136 46136 190606 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 355 Campus Way 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015393.80416 2107532.25368 37.76774672025999 -122.390021372499 (37.76774672026, -122.390021372499)
47039 47039 190601 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 355 Campus Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015245.92181 2107529.35278 37.76773055225821 -122.39053268113899 (37.7677305522582, -122.390532681139)
49672 49672 190578 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 450 South St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6015978.3721199995 2107965.30085 37.768968176771395 -122.388029627781 (37.7689681767714, -122.388029627781)
49885 49885 190607 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 355 Campus Way 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015421.42625 2107533.65832 37.76775210899579 -122.389925928363 (37.7677521089958, -122.389925928363)
51886 51886 190547 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 888 07th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6012386.15818 2108699.40492 37.7707841894616 -122.400506514263 (37.7707841894616, -122.400506514263)
52960 52960 123591 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 26 05th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 5ft   5994270.79581 2115427.05215 37.7882295890949 -122.463655789773 (37.7882295890949, -122.463655789773)
57549 57549 128941 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 999 Geary St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6007034.604069999 2114302.44848 37.78586889678329 -122.41941524411301 (37.7858688967833, -122.419415244113)
57668 57668 190463 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 560 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6012913.646000001 2115176.9585700002 37.7885994678435 -122.39913666512399 (37.7885994678435, -122.399136665124)
60223 60223 190599 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 526 Nelson Rising Ln 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6015261.35764 2108269.67472 37.7697641703179 -122.39053102639299 (37.7697641703179, -122.390531026393)
62810 62810 226012 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 3625 24th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6005661.282790001 2101957.0961 37.751894066561604 -122.42328866194201 (37.7518940665616, -122.423288661942)
62949 62949 190609 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 355 Campus Way 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015498.37431 2107537.59988 37.767767198735 -122.389660047398 (37.767767198735, -122.389660047398)
63716 63716 226060 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 164 Liberty St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6005261.59596 2104022.79121 37.757543418817896 -122.42481778101299 (37.7575434188179, -122.424817781013)
65769 65769 123537 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 21 05th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 5ft   5994224.72449 2115479.15004 37.7883699808955 -122.46381897053301 (37.7883699808955, -122.463818970533)
67212 67212 190592 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 526 Nelson Rising Ln 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6015387.1631 2108279.22626 37.7697973750821 -122.390096532449 (37.7697973750821, -122.390096532449)
69040 69040 225763 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 590 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 5ft   6003622.090559999 2104863.22767 37.7597583186054 -122.430547817747 (37.7597583186054, -122.430547817747)
69347 69347 190573 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 550 South St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6016194.38649 2107976.86529 37.7690118955188 -122.387283248044 (37.7690118955188, -122.387283248044)
72370 72370 190571 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 550 South St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   6016244.2177 2107979.82534 37.7690227827156 -122.387111089925 (37.7690227827156, -122.387111089925)
72932 72932 190570 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 550 South St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6016269.160069999 2107982.6264299997 37.769031855059204 -122.387025010418 (37.7690318550592, -122.387025010418)
74680 74680 129015 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 1500 Sansome St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6011821.67405 2120927.2444 37.8043274566138 -122.403319427258 (37.8043274566138, -122.403319427258)
76648 76648 190575 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 450 South St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6016046.537719999 2107968.65243 37.7689811557707 -122.387794079147 (37.7689811557707, -122.387794079147)
115467 115467 190586 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 1245 03rd St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   6015582.84086 2109273.77078 37.7725390266763 -122.389489148317 (37.7725390266763, -122.389489148317)
118108 118108 225644 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 400 Eugenia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6006911.1309400005 2097916.3935 37.7408696670086 -122.418679980019 (37.7408696670086, -122.418679980019)
119123 119123 190566 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 550 South St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6016411.49198 2107989.98551 37.7690599417774 -122.38653320177099 (37.7690599417774, -122.386533201771)
129934 129934 190569 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 550 South St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   6016293.39232 2107983.1291900002 37.7690345773055 -122.38694122686199 (37.7690345773055, -122.386941226862)
131836 131836 190600 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 355 Campus Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015217.08572 2107526.40267 37.7677208521577 -122.390632216307 (37.7677208521577, -122.390632216307)
132353 132353 190598 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 526 Nelson Rising Ln 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6015283.47377 2108274.8964299997 37.7697797348675 -122.390454891574 (37.7697797348675, -122.390454891574)
132597 132597 190461 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 560 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6012948.597569999 2115205.3755200002 37.788679441854 -122.39901773250799 (37.788679441854, -122.399017732508)
132811 132811 225743 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 1111 Noe St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6003206.55355 2101776.90911 37.7512604725972 -122.431764591488 (37.7512604725972, -122.431764591488)
133099 133099 190572 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 550 South St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   6016218.95037 2107977.3612900004 37.769014617752106 -122.38719831694901 (37.7690146177521, -122.387198316949)
133701 133701 123780 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 1101 Cabrillo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   5992128.669869999 2110647.16676 37.7749816699912 -122.470718819766 (37.7749816699912, -122.470718819766)
134467 134467 190581 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 450 South St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6015854.60324 2107958.79566 37.7689434570894 -122.388457286 (37.7689434570894, -122.388457286)
134899 134899 190608 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 355 Campus Way 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015462.45363 2107535.1849599998 37.7677585760219 -122.389784125064 (37.7677585760219, -122.389784125064)
136177 136177 190585 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 448 South St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015704.367430001 2107948.44562 37.768906711711004 -122.388976223597 (37.768906711711, -122.388976223597)
138035 138035 190456 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 1709 Revere Ave 5 : 4 Tree 1 Private 1     3 Width 5ft   6014599.96347 2094732.12435 37.7325562135041 -122.391872039683 (37.7325562135041, -122.391872039683)
147125 147125 190460 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 5 Anthony St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6012767.43065 2115195.29722 37.788641672116796 -122.399643839601 (37.7886416721168, -122.399643839601)

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