Street_Tree_List

Data source: data.sfgov.org

2,323 rows where qSpecies = 46 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location
109285 109285 98270 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 990X York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/2012 12:00:00 AM   witin landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.40858435969801 (37.7562208239384, -122.408584359698)
106640 106640 98271 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 990X York St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.40858435969801 (37.7562208239384, -122.408584359698)
107595 107595 98272 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 990X York St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.40858435969801 (37.7562208239384, -122.408584359698)
118014 118014 98273 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 990X York St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.40858435969801 (37.7562208239384, -122.408584359698)
26492 26492 242374 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2x McCoppin St 2 Median : Yard 3 Tree 1 DPW 2     5 Width 9ft   6006546.0037 2109148.1970900004 37.771689039651896 -122.42073962714899 (37.7716890396519, -122.420739627149)
159564 159564 242778 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1 McCoppin St 1 : 4 Tree 1 Private 1     4 Width 9ft   6006595.78841 2109152.55753 37.7717038182152 -122.420567728011 (37.7717038182152, -122.420567728011)
160927 160927 242373 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2x McCoppin St 1 Median : Yard 3 Tree 1 DPW 2     5 Width 9ft   6006573.34583 2109150.3275 37.771696430266 -122.420645200112 (37.771696430266, -122.420645200112)
166774 166774 242781 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 95x McCoppin St 2 Median : Yard 3 Tree 1 DPW 2     4 Width 9ft   6006152.38517 2109124.27435 37.771601160584 -122.42209948031099 (37.771601160584, -122.422099480311)
184354 184354 242780 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 95 McCoppin St 1 : 4 Tree 1 Private 1     3 Width 9ft   6006179.77173 2109125.10938 37.7716049979898 -122.422004807797 (37.7716049979898, -122.422004807797)
185473 185473 242779 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x McCoppin St 2 Median : Yard 3 Tree 1 DPW 2     4 Width 9ft   6006556.42632 2109149.52189 37.77169326466979 -122.420703668659 (37.7716932646698, -122.420703668659)
25133 25133 198661 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   6013934.2668 2107404.04412 37.7673136301584 -122.39506079103 (37.7673136301584, -122.39506079103)
28071 28071 198653 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 8ft   6014062.16151 2107274.8882299997 37.7669661078202 -122.39460937273701 (37.7669661078202, -122.394609372737)
40192 40192 246545 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 12 Median : Yard 3 Tree 1 DPW 2     8 Width 8ft   6005664.26886 2109539.08097 37.7727125769595 -122.423817404855 (37.7727125769595, -122.423817404855)
41617 41617 198662 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   6013921.99886 2107418.77263 37.767353389178204 -122.395104256175 (37.7673533891782, -122.395104256175)
43669 43669 246542 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 8 Median : Yard 3 Tree 1 DPW 2     9 Width 8ft   6005675.49099 2109463.50167 37.772505687922 -122.42377321126001 (37.772505687922, -122.42377321126)
50390 50390 246538 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 4 Median : Yard 3 Tree 1 DPW 2     7 Width 8ft   6005690.17012 2109380.36656 37.7722782475712 -122.423716522495 (37.7722782475712, -122.423716522495)
57780 57780 246553 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 20x Octavia St 7 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   6005726.464930001 2109532.06592 37.7726968262309 -122.42360176272699 (37.7726968262309, -122.423601762727)
75717 75717 246541 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 7 Median : Yard 3 Tree 1 DPW 2     7 Width 8ft   6005680.0153 2109440.15852 37.772441848655795 -122.423755901126 (37.7724418486558, -122.423755901126)
131030 131030 246540 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 6 Median : Yard 3 Tree 1 DPW 2     8 Width 8ft   6005683.44933 2109420.77798 37.7723888282128 -122.423742644211 (37.7723888282128, -122.423742644211)
131563 131563 198656 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   6014014.86759 2107324.11249 37.7670986373305 -122.394776403817 (37.7670986373305, -122.394776403817)
132426 132426 198664 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   6013893.51882 2107448.48806 37.7674333973606 -122.39520484712 (37.7674333973606, -122.39520484712)
133254 133254 215479 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 85 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   5992627.2877 2096233.3886799999 37.7354340044744 -122.467945378584 (37.7354340044744, -122.467945378584)
133946 133946 198657 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   6013998.084530001 2107337.5024 37.7671344699085 -122.39483539216499 (37.7671344699085, -122.394835392165)
136228 136228 246554 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 20x Octavia St 8 Median : Yard 3 Tree 1 DPW 2     5 Width 8ft   6005723.73891 2109547.7321 37.772739687913706 -122.423612306376 (37.7727396879137, -122.423612306376)
148557 148557 215480 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 55 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 8ft   5992620.877830001 2096424.4716400001 37.7359583002413 -122.467981434219 (37.7359583002413, -122.467981434219)
150445 150445 180561 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1134 Naples St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 8ft   6001348.51244 2087850.78247 37.712917038962495 -122.437192888562 (37.7129170389625, -122.437192888562)
151969 151969 246544 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 11 Median : Yard 3 Tree 1 DPW 2     4 Width 8ft   6005666.89387 2109521.5509099998 37.7726645918273 -122.42380707793998 (37.7726645918273, -122.42380707794)
155019 155019 246537 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 3 Median : Yard 3 Tree 1 DPW 2     7 Width 8ft   6005694.1719 2109365.05441 37.7722364299905 -122.423701591057 (37.7722364299905, -122.423701591057)
157554 157554 198658 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   6013985.93072 2107349.0106 37.767165393099205 -122.39487823676001 (37.7671653930992, -122.39487823676)
161482 161482 198659 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   6013968.57822 2107369.74118 37.7672213498189 -122.39493970902001 (37.7672213498189, -122.39493970902)
165192 165192 180560 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1134 Naples St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 8ft   6001363.50733 2087875.35573 37.7129853640648 -122.437142819708 (37.7129853640648, -122.437142819708)
167424 167424 198655 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   6014030.31136 2107306.6382299997 37.7670515155374 -122.3947217619 (37.7670515155374, -122.3947217619)
169845 169845 198665 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 25 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 8ft   6013878.81115 2107466.84131 37.767482973376396 -122.395257005115 (37.7674829733764, -122.395257005115)
169909 169909 198663 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   6013906.856240001 2107433.3805400003 37.7673926571763 -122.395157656112 (37.7673926571763, -122.395157656112)
175443 175443 246555 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 20x Octavia St 9 Median : Yard 3 Tree 1 DPW 2     7 Width 8ft   6005721.04041 2109575.32182 37.772815290316295 -122.423623602744 (37.7728152903163, -122.423623602744)
178300 178300 246552 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 20x Octavia St 6 Median : Yard 3 Tree 1 DPW 2     5 Width 8ft   6005729.77249 2109512.91923 37.77264444073 -122.423588959979 (37.77264444073, -122.423588959979)
178916 178916 198666 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 27 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   6013864.8595 2107478.20715 37.7675134055349 -122.39530605864901 (37.7675134055349, -122.395306058649)
181312 181312 246539 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 5 Median : Yard 3 Tree 1 DPW 2     6 Width 8ft   6005686.56992 2109401.16217 37.7723351440794 -122.423730454802 (37.7723351440794, -122.423730454802)
182574 182574 198654 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   6014045.1024400005 2107292.39517 37.7670132295924 -122.39466960392201 (37.7670132295924, -122.394669603922)
183718 183718 246549 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 20x Octavia St 3 Median : Yard 3 Tree 1 DPW 2     3 Width 8ft   6005737.248 2109452.9268900002 37.77248013816789 -122.423558835368 (37.7724801381679, -122.423558835368)
186182 186182 180540 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2134 San Jose Ave 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 8ft   5998917.8755 2091146.4939599999 37.7218278392563 -122.445830812055 (37.7218278392563, -122.445830812055)
186900 186900 198660 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   6013952.391369999 2107385.9793599998 37.767265036187204 -122.39499683484101 (37.7672650361872, -122.394996834841)
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)
34416 34416 198529 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1722 Newcomb Ave 2 : 4 Tree 1 Private 1     7 Width 7ft   6014569.28946 2096208.9031099998 37.73660944358 -122.392081326305 (37.73660944358, -122.392081326305)
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)
58767 58767 198517 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1763 Newcomb Ave 2 : 4 Tree 1 Private 1     5 Width 7ft   6014346.73951 2096322.78373 37.736909777547204 -122.392858747949 (37.7369097775472, -122.392858747949)
59151 59151 198532 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1762 Newcomb Ave 1 : 4 Tree 1 Private 1     4 Width 7ft   6014372.17182 2096354.40755 37.736998022638105 -122.39277302817301 (37.7369980226381, -122.392773028173)
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)
76234 76234 198526 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1700 Newcomb Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 7ft   6014646.0524 2096160.0564599999 37.736479582376 -122.391812507248 (37.736479582376, -122.391812507248)
129816 129816 198516 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1763 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 7ft   6014335.026380001 2096322.17337 37.736907451020606 -122.392899203062 (37.7369074510206, -122.392899203062)
131093 131093 198520 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1737 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 7ft   6014468.3432 2096223.93289 37.7366451070745 -122.392431394602 (37.7366451070745, -122.392431394602)
135251 135251 198533 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1762 Newcomb Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 7ft   6014374.32844 2096361.3025900002 37.737017074781896 -122.392766053934 (37.7370170747819, -122.392766053934)
137036 137036 198519 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1743 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 7ft   6014430.37923 2096250.7581099998 37.7367166553422 -122.39256452932699 (37.7367166553422, -122.392564529327)
149140 149140 198515 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1799 Newcomb Ave 1 : 4 Tree 1 Private 1     6 Width 7ft   6014195.4851 2096428.16661 37.7371907347515 -122.39338907816999 (37.7371907347515, -122.39338907817)
149918 149918 198528 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1712 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 7ft   6014599.09575 2096195.7007900001 37.736574847558295 -122.39197734938601 (37.7365748475583, -122.391977349386)
150324 150324 198535 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1770 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 7ft   6014325.04496 2096399.73326 37.73711986009079 -122.392939138341 (37.7371198600908, -122.392939138341)
154449 154449 198530 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1748 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 7ft   6014455.10696 2096302.51395 37.7368601394856 -122.39248265324899 (37.7368601394856, -122.392482653249)
154868 154868 198522 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1725 Newcomb Ave 2 : 4 Tree 1 Private 1     3 Width 7ft   6014552.77288 2096169.8984700001 37.736501427800896 -122.392135704718 (37.7365014278009, -122.392135704718)
158886 158886 198521 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1737 Newcomb Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 7ft   6014485.10287 2096211.0948599998 37.7366107871579 -122.39237255107099 (37.7366107871579, -122.392372551071)
161771 161771 198523 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1721 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 7ft   6014565.5806599995 2096150.99697 37.7364502392755 -122.392090100993 (37.7364502392755, -122.392090100993)
168657 168657 198524 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1709 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 7ft   6014591.36063 2096131.8328599997 37.7363990498707 -122.391999628307 (37.7363990498707, -122.391999628307)
185967 185967 198527 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1700 Newcomb Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 7ft   6014634.66691 2096168.3212099997 37.736501643630795 -122.39185244975599 (37.7365016436308, -122.391852449756)
186460 186460 198536 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1782 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 7ft   6014278.07437 2096434.6477400002 37.7372131188949 -122.393103980488 (37.7372131188949, -122.393103980488)
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)
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)
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)
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)
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)
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)
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)
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)
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)
39642 39642 198442 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 500 Mariposa St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 6ft   6015430.62355 2106285.94365 37.7643266659781 -122.389806954341 (37.7643266659781, -122.389806954341)
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)
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)
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)
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)
50386 50386 198449 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 500 Mariposa St 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 6ft   6015277.30133 2106281.40363 37.764305696480896 -122.39033694009599 (37.7643056964809, -122.390336940096)
52590 52590 198500 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1215 Michigan St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 6ft   6016504.90448 2102523.10402 37.754054221042 -122.385828988529 (37.754054221042, -122.385828988529)
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)
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)
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)
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)
59511 59511 198436 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 500 Mariposa St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 6ft   6015560.81783 2106295.35578 37.7643597286383 -122.389357302304 (37.7643597286383, -122.389357302304)
61396 61396 198447 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 500 Mariposa St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 6ft   6015324.46824 2106281.29518 37.7643080149349 -122.390173794086 (37.7643080149349, -122.390173794086)
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)
62501 62501 198450 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 500 Mariposa St 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 6ft   6015258.23224 2106279.65666 37.7642998419001 -122.390402773191 (37.7642998419001, -122.390402773191)
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)
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)

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