Street_Tree_List

Data source: data.sfgov.org

233 rows where qSiteInfo = 2 and qSpecies = 46

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 233 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
24162 24162 215566 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 250 Santa Paula Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5993936.1007 2096327.5375 37.735768007292705 -122.463427186434 (37.7357680072927, -122.463427186434)
24337 24337 198558 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1709 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   6014602.581680001 2096122.3818299999 37.73637372225429 -122.391960171423 (37.7363737222543, -122.391960171423)
25444 25444 198476 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 800 Minnesota St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   6015193.91802 2104744.93458 37.7600822588968 -122.390517973622 (37.7600822588968, -122.390517973622)
25485 25485 198641 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 419 Mission Bay Blvd North 15 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6015975.52657 2108754.29642 37.7711344286414 -122.388094538146 (37.7711344286414, -122.388094538146)
25770 25770 198550 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1743 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6014437.8332 2096238.2314099998 37.736682673554895 -122.392537881536 (37.7366826735549, -122.392537881536)
25771 25771 198601 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6016359.83761 2108655.37305 37.770884091558706 -122.386758280474 (37.7708840915587, -122.386758280474)
25994 25994 198552 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1737 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   6014479.14008 2096215.50605 37.7366225682648 -122.39239347560499 (37.7366225682648, -122.392393475605)
26007 26007 215558 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 240 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994076.83101 2096438.6024200001 37.7360810711916 -122.46294868592699 (37.7360810711916, -122.462948685927)
26682 26682 198540 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1770 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6014330.01059 2096395.8315299999 37.7371094225658 -122.39292169687401 (37.7371094225658, -122.392921696874)
27196 27196 198667 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 124 Russ St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   6010302.39718 2111555.70743 37.778510504382794 -122.407915770511 (37.7785105043828, -122.407915770511)
27464 27464 215498 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 95 Santa Paula Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5993979.5407 2097285.08347 37.7383996933922 -122.46334646239201 (37.7383996933922, -122.463346462392)
27511 27511 215496 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 69 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5993975.721530001 2097357.94979 37.7385995461283 -122.46336495334299 (37.7385995461283, -122.463364953343)
27525 27525 215551 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 212 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994048.13405 2096632.6874900002 37.7366123276804 -122.46306197983401 (37.7366123276804, -122.463061979834)
28058 28058 215555 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 230 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994079.01038 2096505.73845 37.7362655356317 -122.46294602033701 (37.7362655356317, -122.462946020337)
28099 28099 215484 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 21 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5994076.92667 2097749.04597 37.739679229001496 -122.46304340523001 (37.7396792290015, -122.46304340523)
28275 28275 198639 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 419 Mission Bay Blvd North 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6015936.8101699995 2108752.54325 37.7711274696967 -122.38822833839 (37.7711274696967, -122.38822833839)
29756 29756 215492 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 51 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5993992.82093 2097521.50716 37.7390496190449 -122.463317697564 (37.7390496190449, -122.463317697564)
29855 29855 198531 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1750 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 7ft   6014434.12864 2096316.99865 37.736898746479895 -122.392556198035 (37.7368987464799, -122.392556198035)
31013 31013 198560 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1708 Newcomb Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6014655.2828 2096153.01044 37.7364607478562 -122.39178010106899 (37.7364607478562, -122.391780101069)
32201 32201 198478 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 800 Minnesota St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6015196.41735 2104702.3820599997 37.759965557478296 -122.390506356185 (37.7599655574783, -122.390506356185)
32806 32806 215544 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 90 Santa Paula Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5993951.56494 2097251.7365 37.738306519129 -122.46344076888398 (37.738306519129, -122.463440768884)
33083 33083 215539 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 70 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5993947.30597 2097439.0269400002 37.73882052663561 -122.463469082233 (37.7388205266356, -122.463469082233)
33160 33160 215550 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 200 Santa Paula Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994032.03336 2096692.14483 37.7367746553097 -122.463121959218 (37.7367746553097, -122.463121959218)
33717 33717 215511 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 299 Santa Paula Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993997.50574 2096315.53912 37.73573860035479 -122.463214016518 (37.7357386003548, -122.463214016518)
35712 35712 198574 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 425 01st St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6014815.04425 2114132.68239 37.7858379025473 -122.39248498701099 (37.7858379025473, -122.392484987011)
35801 35801 215481 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5994138.58821 2097841.54459 37.739936758872204 -122.462836916405 (37.7399367588722, -122.462836916405)
36126 36126 215491 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 45 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   5993998.37881 2097545.6525 37.7391162363258 -122.463300232728 (37.7391162363258, -122.463300232728)
36409 36409 198632 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 419 Mission Bay Blvd North 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6015782.37645 2108741.7224 37.77108919993629 -122.38876177932501 (37.7710891999363, -122.388761779325)
36418 36418 215485 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 21 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5994064.51337 2097723.86139 37.7396093633696 -122.46308449795299 (37.7396093633696, -122.463084497953)
36619 36619 215549 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 200 Santa Paula Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994024.47246 2096717.6403700002 37.7368442241821 -122.463149949734 (37.7368442241821, -122.463149949734)
37359 37359 215483 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 15 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5994103.6572 2097790.09327 37.7397934743851 -122.46295396047199 (37.7397934743851, -122.462953960472)
38137 38137 215538 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 66 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993953.054409999 2097475.42453 37.7389207965449 -122.46345184763099 (37.7389207965449, -122.463451847631)
39032 39032 198567 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 400 01st St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   6014762.73223 2114145.2039900003 37.785869378824394 -122.39266684969499 (37.7858693788244, -122.392666849695)
39339 39339 198561 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1708 Newcomb Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6014636.301940001 2096168.28095 37.7365016238531 -122.391846793904 (37.7365016238531, -122.391846793904)
39650 39650 215547 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 200 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994018.95115 2096748.4675900002 37.7369285500121 -122.46317127533999 (37.7369285500121, -122.46317127534)
39846 39846 215499 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 95 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5993991.18061 2097202.58443 37.738173842158105 -122.463300232714 (37.7381738421581, -122.463300232714)
39997 39997 215489 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 37 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5994010.31675 2097590.67092 37.739240533433296 -122.463262222872 (37.7392405334333, -122.463262222872)
40762 40762 198606 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     6016250.47578 2108648.85468 37.7708601381228 -122.387136114449 (37.7708601381228, -122.387136114449)
41301 41301 215532 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 42 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5993980.354309999 2097605.67891 37.739280015454604 -122.463366907564 (37.7392800154546, -122.463366907564)
41607 41607 198633 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 419 Mission Bay Blvd North 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6015806.0947900005 2108744.2847599997 37.771097550144404 -122.388679914958 (37.7710975501444, -122.388679914958)
43054 43054 198631 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 419 Mission Bay Blvd North 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6015760.25573 2108742.67593 37.771090592083794 -122.388838362899 (37.7710905920838, -122.388838362899)
43463 43463 215571 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 32 Malta Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5999675.11481 2095972.7575700001 37.7351228462426 -122.443559761297 (37.7351228462426, -122.443559761297)
44229 44229 181868 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2335 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 0ft   5987618.1769 2099375.389 37.7437705756333 -122.48549403463801 (37.7437705756333, -122.485494034638)
44745 44745 198486 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 900 Minnesota St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   6015201.9775 2104548.15133 37.7595423814855 -122.390476349396 (37.7595423814855, -122.390476349396)
45108 45108 198475 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 800 Minnesota St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6015192.04095 2104775.13196 37.760165070275605 -122.39052657564301 (37.7601650702756, -122.390526575643)
45518 45518 198477 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 800 Minnesota St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 6ft   6015195.39275 2104723.40813 37.7600232337056 -122.390511369019 (37.7600232337056, -122.390511369019)
45912 45912 242593 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 960 Elizabeth St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6000277.53945 2101991.5509200003 37.751683359019395 -122.44190882273199 (37.7516833590194, -122.441908822732)
46612 46612 198480 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 800 Minnesota St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   6015199.5579 2104656.07032 37.759838569617706 -122.39049225842501 (37.7598385696177, -122.390492258425)
46975 46975 198638 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 419 Mission Bay Blvd North 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6015910.558069999 2108750.53892 37.7711205116333 -122.388319006239 (37.7711205116333, -122.388319006239)
47189 47189 215569 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 262 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5993829.85654 2096316.71457 37.735732168414 -122.46379372579901 (37.735732168414, -122.463793725799)
47464 47464 215545 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 90 Santa Paula Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993953.28384 2097231.84575 37.7382520031164 -122.46343338275899 (37.7382520031164, -122.463433382759)
48305 48305 215502 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 225 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994102.838830001 2096543.31026 37.7363700710175 -122.462866361103 (37.7363700710175, -122.462866361103)
49155 49155 215568 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 262 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5993854.87202 2096314.6537799998 37.735727951492294 -122.463707088708 (37.7357279514923, -122.463707088708)
49733 49733 198455 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 700 Mariposa St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   6014981.91793 2106268.05786 37.7642526625648 -122.39135766342699 (37.7642526625648, -122.391357663427)
49838 49838 198482 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 900 Minnesota St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6015196.49511 2104613.64131 37.75972189876779 -122.39049988647699 (37.7597218987678, -122.390499886477)
50663 50663 215561 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 240 Santa Paula Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994051.56415 2096391.9131599998 37.7359514186289 -122.46303265654899 (37.7359514186289, -122.463032656549)
53033 53033 198629 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 419 Mission Bay Blvd North 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     6015714.39108 2108739.8004900003 37.7710801545587 -122.38899681088101 (37.7710801545587, -122.388996810881)
53945 53945 198518 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1759 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 7ft   6014349.89775 2096310.6445799998 37.7368766213595 -122.392846979413 (37.7368766213595, -122.392846979413)
54065 54065 198460 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 700 Mariposa St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   6014862.84066 2106274.78772 37.7642645317963 -122.391769991798 (37.7642645317963, -122.391769991798)
54610 54610 198620 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 454 Mission Bay Blvd South 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6015807.975319999 2108623.11457 37.770764947581895 -122.38866495024901 (37.7707649475819, -122.388664950249)
54689 54689 198548 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1748 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6014451.76229 2096301.9779599998 37.7368584820264 -122.39249417986 (37.7368584820264, -122.39249417986)
55185 55185 198604 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6016296.79375 2108651.46445 37.7708698687766 -122.386976080084 (37.7708698687766, -122.386976080084)
55611 55611 198674 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 169 Russ St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   6010536.5691599995 2111353.45515 37.7779682743635 -122.407091416859 (37.7779682743635, -122.407091416859)
55699 55699 198474 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 800 Minnesota St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   6015187.75524 2104800.09072 37.7602333639076 -122.390543142045 (37.7602333639076, -122.390543142045)
55928 55928 198630 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 419 Mission Bay Blvd North 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6015737.06642 2108741.11663 37.7710850252717 -122.38891846733401 (37.7710850252717, -122.388918467334)
56207 56207 198481 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 800 Minnesota St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   6015200.5956 2104639.69489 37.7597936637724 -122.390487525273 (37.7597936637724, -122.390487525273)
56574 56574 198635 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 419 Mission Bay Blvd North 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6015851.9543 2108746.90695 37.7711072915897 -122.38852146699399 (37.7711072915897, -122.388521466994)
56778 56778 198623 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 454 Mission Bay Blvd South 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6015749.91564 2108621.24573 37.7707565982691 -122.38886565105 (37.7707565982691, -122.38886565105)
56932 56932 215513 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 299 Santa Paula Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993924.28661 2096292.23015 37.7356703813878 -122.463465470563 (37.7356703813878, -122.463465470563)
57322 57322 198607 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6016227.74089 2108648.22285 37.7708571442621 -122.387214711603 (37.7708571442621, -122.387214711603)
57468 57468 198571 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 400 01st St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6014800.77369 2114106.0690200003 37.7857640358271 -122.392532497299 (37.7857640358271, -122.392532497299)
58881 58881 198617 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 454 Mission Bay Blvd South 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     6015877.04462 2108628.30945 37.7707830392222 -122.388426398764 (37.7707830392222, -122.388426398764)
59161 59161 198549 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1742 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   6014473.930819999 2096284.0177200001 37.73681039796789 -122.39241627700899 (37.7368103979679, -122.392416277009)
59191 59191 198504 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 785 Rhode Island St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   6011870.75445 2104712.89725 37.75980937761629 -122.40200902239599 (37.7598093776163, -122.402009022396)
59240 59240 198605 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6016273.49532 2108650.02611 37.770864629317 -122.38705657031099 (37.770864629317, -122.387056570311)
59643 59643 215503 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 233 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994106.38436 2096527.49502 37.736326850502294 -122.46285295579901 (37.7363268505023, -122.462852955799)
59755 59755 198619 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 454 Mission Bay Blvd South 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     6015825.0595 2108624.79715 37.770770514383 -122.388605972695 (37.770770514383, -122.388605972695)
59944 59944 198525 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1700 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 7ft   6014663.37225 2096146.01075 37.736441977203995 -122.391751642923 (37.736441977204, -122.391751642923)
61085 61085 198534 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1766 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 7ft   6014341.63524 2096385.88519 37.7370827576597 -122.392880809218 (37.7370827576597, -122.392880809218)
61140 61140 198551 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1739 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   6014460.695 2096227.3713599998 37.736654123686705 -122.392458078374 (37.7366541236867, -122.392458078374)
61411 61411 198456 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 700 Mariposa St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   6014956.8644900005 2106266.70489 37.76424755710789 -122.391444222274 (37.7642475571079, -122.391444222274)
62362 62362 215567 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 254 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5993893.11792 2096318.4579099999 37.735740600456 -122.46357513479201 (37.735740600456, -122.463575134792)
62589 62589 198564 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 400 01st St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6014732.17193 2114176.27095 37.7859529842748 -122.392774754864 (37.7859529842748, -122.392774754864)
63171 63171 198609 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6016187.15273 2108644.67946 37.7708451671001 -122.387354861049 (37.7708451671001, -122.387354861049)
63775 63775 200790 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1582 McKinnon Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   6015482.0599 2095886.5322 37.735774914559 -122.38890295979799 (37.735774914559, -122.388902959798)
63853 63853 198644 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 421 Mission Bay Blvd North 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6016180.118480001 2108766.38719 37.7711789603624 -122.38738768448799 (37.7711789603624, -122.387387684488)
64122 64122 242453 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 140 Belgrave Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 2ft   5997900.49529 2104918.67096 37.7595847638524 -122.45033989586399 (37.7595847638524, -122.450339895864)
64525 64525 215554 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 224 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994072.66196 2096533.8959299999 37.736342483419705 -122.462970011551 (37.7363424834197, -122.462970011551)
64606 64606 215486 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 25 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   5994053.65956 2097702.19422 37.739549245488796 -122.46312045374901 (37.7395492454888, -122.463120453749)
65694 65694 198454 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 700 Mariposa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   6015038.61776 2106270.38005 37.7642621854664 -122.391161715541 (37.7642621854664, -122.391161715541)
66415 66415 215487 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 25 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5994042.19305 2097679.65263 37.7394866913615 -122.46315846449 (37.7394866913615, -122.46315846449)
67701 67701 198625 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 454 Mission Bay Blvd South 14 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6015702.76358 2108617.6361 37.770744073418896 -122.38902850026001 (37.7707440734189, -122.38902850026)
68154 68154 215507 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 255 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994095.64493 2096399.41615 37.735974559073604 -122.462880797029 (37.7359745590736, -122.462880797029)
68206 68206 198563 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 400 01st St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   6014720.16797 2114187.47554 37.7859830827904 -122.392817069764 (37.7859830827904, -122.392817069764)
69313 69313 198648 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 421 Mission Bay Blvd North 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6016263.67679 2108770.7838 37.77119565988 -122.387098957165 (37.77119565988, -122.387098957165)
69805 69805 198553 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1731 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   6014499.16672 2096200.32532 37.736581997166205 -122.392323172901 (37.7365819971662, -122.392323172901)
70303 70303 198576 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 425 01st St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   6014783.084840001 2114165.1217799997 37.7859251988423 -122.39259782854201 (37.7859251988423, -122.392597828542)
70855 70855 198568 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 400 01st St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   6014772.61549 2114134.95579 37.7858417885051 -122.392631938935 (37.7858417885051, -122.392631938935)
71554 71554 215528 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994077.87758 2097807.84952 37.7398407436586 -122.46304438280501 (37.7398407436586, -122.463044382805)
71787 71787 215531 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 40 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5993990.15739 2097631.70954 37.7393520538516 -122.46333490158199 (37.7393520538516, -122.463334901582)

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