Street_Tree_List

Data source: data.sfgov.org

288 rows where qSpecies = 119 sorted by qAddress

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
61415 61415 215472 Undocumented 2 Ulmus americana :: American Elm 119 1 Sola Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   5994924.36549 2100698.72724 37.7478270966613 -122.46032700748002 (37.7478270966613, -122.46032700748)
168042 168042 219574 Undocumented 2 Ulmus americana :: American Elm 119 100 Montalvo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 3ft   5993666.81553 2099677.65694 37.7449510773443 -122.464601388053 (37.7449510773443, -122.464601388053)
54548 54548 219587 Undocumented 2 Ulmus americana :: American Elm 119 100 Santa Ana Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 5ft   5992597.45757 2095923.8327099998 37.734582318619296 -122.468026001902 (37.7345823186193, -122.468026001902)
74863 74863 242362 Undocumented 2 Ulmus americana :: American Elm 119 1060 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6003143.14835 2102033.6901599998 37.7519619384111 -122.432002187867 (37.7519619384111, -122.432002187867)
25593 25593 215447 Undocumented 2 Ulmus americana :: American Elm 119 110 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5992597.98393 2095879.53795 37.7344607266837 -122.468020961215 (37.7344607266837, -122.468020961215)
27131 27131 215446 Undocumented 2 Ulmus americana :: American Elm 119 110 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5992597.86385 2095891.15575 37.7344926193226 -122.468022221156 (37.7344926193226, -122.468022221156)
35979 35979 215448 Undocumented 2 Ulmus americana :: American Elm 119 110 Santa Ana Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   5992599.75801 2095859.8997900002 37.7344069076591 -122.46801339970501 (37.7344069076591, -122.468013399705)
185662 185662 219455 Undocumented 2 Ulmus americana :: American Elm 119 113 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   5992638.64408 2095929.54956 37.73460039407979 -122.467884023242 (37.7346003940798, -122.467884023242)
42070 42070 219456 Undocumented 2 Ulmus americana :: American Elm 119 115 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   5992639.24928 2095904.23823 37.734530930444 -122.467880090494 (37.734530930444, -122.467880090494)
17763 17763 23637 DPW Maintained 3 Ulmus americana :: American Elm 119 116 Virginia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/24/1998 12:00:00 AM 10 3X3   6006587.56141 2098481.46204 37.74240299581479 -122.419838851803 (37.7424029958148, -122.419838851803)
59802 59802 215449 Undocumented 2 Ulmus americana :: American Elm 119 120 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5992601.94776 2095825.37047 37.7343122252356 -122.46800331831301 (37.7343122252356, -122.468003318313)
183119 183119 215450 Undocumented 2 Ulmus americana :: American Elm 119 120 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 5ft   5992601.064590001 2095800.7065299999 37.7342444532197 -122.46800457827 (37.7342444532197, -122.46800457827)
61980 61980 219526 Undocumented 2 Ulmus americana :: American Elm 119 121 Sagamore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995598.71297 2087377.82947 37.711289895587896 -122.45703176651699 (37.7112898955879, -122.457031766517)
36374 36374 219457 Undocumented 2 Ulmus americana :: American Elm 119 125 Santa Ana Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5992642.51774 2095825.25253 37.734314244193 -122.467863047447 (37.734314244193, -122.467863047447)
67028 67028 219459 Undocumented 2 Ulmus americana :: American Elm 119 125 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5992643.39064 2095794.6488700002 37.7342302645957 -122.467857804419 (37.7342302645957, -122.467857804419)
148186 148186 219458 Undocumented 2 Ulmus americana :: American Elm 119 125 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5992642.59495 2095810.90237 37.7342748466983 -122.46786173712299 (37.7342748466983, -122.467861737123)
100662 100662 19049 DPW Maintained 3 Ulmus americana :: American Elm 119 129 Sagamore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3X3   5995630.2780118 2087392.9172085 37.7113331356468 -122.456923761037 (37.7113331356468, -122.456923761037)
142214 142214 19048 DPW Maintained 3 Ulmus americana :: American Elm 119 129 Sagamore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3X3   5995630.2780118 2087392.9172085 37.7113331356468 -122.456923761037 (37.7113331356468, -122.456923761037)
29496 29496 215453 Undocumented 2 Ulmus americana :: American Elm 119 130 Santa Ana Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   5992604.15491 2095739.66057 37.734077014732705 -122.46798945526501 (37.7340770147327, -122.467989455265)
33548 33548 215452 Undocumented 2 Ulmus americana :: American Elm 119 130 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5992604.2406 2095761.0748 37.7341358178054 -122.467990716115 (37.7341358178054, -122.467990716115)
148812 148812 215451 Undocumented 2 Ulmus americana :: American Elm 119 130 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 5ft   5992603.36881 2095771.61937 37.73416472021471 -122.46799449687599 (37.7341647202147, -122.467994496876)
161886 161886 215466 Undocumented 2 Ulmus americana :: American Elm 119 131 Magellan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 4ft   5995052.95095 2100968.80441 37.74857605654171 -122.459901929455 (37.7485760565417, -122.459901929455)
169785 169785 215467 Undocumented 2 Ulmus americana :: American Elm 119 131 Magellan Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 4ft   5995042.95861 2100982.3963599997 37.7486128019409 -122.459937467057 (37.7486128019409, -122.459937467057)
43988 43988 219460 Undocumented 2 Ulmus americana :: American Elm 119 131 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5992644.33525 2095767.44219 37.7341556163962 -122.46785256046999 (37.7341556163962, -122.46785256047)
176174 176174 219461 Undocumented 2 Ulmus americana :: American Elm 119 131 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5992643.55955 2095748.57888 37.734103777666895 -122.467853870763 (37.7341037776669, -122.467853870763)
13379 13379 84297 Permitted Site 1 Ulmus americana :: American Elm 119 1369-1369 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/07/2009 12:00:00 AM 3 3x3 Permit Number 52440 6008956.5592 2109575.0604 37.772996675036 -122.41243151373999 (37.772996675036, -122.41243151374)
15168 15168 82753 Permitted Site 1 Ulmus americana :: American Elm 119 1369-1369 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/07/2009 12:00:00 AM 3 3x3 Permit Number 52440 6008965.8436 2109583.1338 37.7730193637194 -122.412399968507 (37.7730193637194, -122.412399968507)
63391 63391 215468 Undocumented 2 Ulmus americana :: American Elm 119 140 Magellan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   5995041.47526 2100911.57821 37.748418267804496 -122.45993746705601 (37.7484182678045, -122.459937467056)
63776 63776 219573 Undocumented 2 Ulmus americana :: American Elm 119 140 Montalvo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 3ft   5993734.74084 2099541.05519 37.7445799190316 -122.46435660067 (37.7445799190316, -122.46435660067)
127330 127330 109501 Private 5 Ulmus americana :: American Elm 119 1400X on Filbert Montgomery St 1 Unaccepted Street : Yard 14 Tree 1 Private 1         see 279 Filbert St. Same tree; shared responsibility 6011485.9 2120124.8 37.802105381717894 -122.404424889694 (37.8021053817179, -122.404424889694)
148298 148298 219463 Undocumented 2 Ulmus americana :: American Elm 119 141 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   5992649.22089 2095675.20622 37.7339026415776 -122.46782896316002 (37.7339026415776, -122.46782896316)
176152 176152 219462 Undocumented 2 Ulmus americana :: American Elm 119 141 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   5992648.10165 2095694.10938 37.7339544803051 -122.467834207082 (37.7339544803051, -122.467834207082)
20282 20282 19054 DPW Maintained 3 Ulmus americana :: American Elm 119 147 Sagamore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3X3   5995468.13357 2087379.87793 37.7112880204961 -122.457483227074 (37.7112880204961, -122.457483227074)
43894 43894 219521 Undocumented 2 Ulmus americana :: American Elm 119 15 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 8ft   5992605.36477 2096774.53089 37.7369185792154 -122.468060524183 (37.7369185792154, -122.468060524183)
152622 152622 219520 Undocumented 2 Ulmus americana :: American Elm 119 15 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   5992608.23435 2096751.02117 37.7368541931494 -122.468048893267 (37.7368541931494, -122.468048893267)
40840 40840 219464 Undocumented 2 Ulmus americana :: American Elm 119 151 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5992648.371590001 2095634.82133 37.733791705711 -122.467828963142 (37.733791705711, -122.467828963142)
26508 26508 215465 Undocumented 2 Ulmus americana :: American Elm 119 155 Magellan Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   5995078.643630001 2100761.22837 37.748007582495 -122.45979805143601 (37.748007582495, -122.459798051436)
68104 68104 215464 Undocumented 2 Ulmus americana :: American Elm 119 155 Magellan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 4ft   5995075.02131 2100739.26228 37.7479470608168 -122.45980898629601 (37.7479470608168, -122.459808986296)
161809 161809 219465 Undocumented 2 Ulmus americana :: American Elm 119 157 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5992651.10608 2095584.5432900002 37.733653812663 -122.467815853722 (37.733653812663, -122.467815853722)
173927 173927 219466 Undocumented 2 Ulmus americana :: American Elm 119 157 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5992652.074519999 2095558.46871 37.7335822742946 -122.46781060978 (37.7335822742946, -122.46781060978)
41848 41848 215469 Undocumented 2 Ulmus americana :: American Elm 119 160 Magellan Ave 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 4ft   5995028.58035 2100711.10786 37.7478670849985 -122.45996753678499 (37.7478670849985, -122.459967536785)
38616 38616 215454 Undocumented 2 Ulmus americana :: American Elm 119 160 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   5992606.05096 2095656.4975700001 37.733848779404795 -122.46797685305401 (37.7338487794048, -122.467976853054)
55349 55349 215455 Undocumented 2 Ulmus americana :: American Elm 119 160 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5992606.291130001 2095633.2616299998 37.733784993186205 -122.467974333173 (37.7337849931862, -122.467974333173)
161368 161368 219467 Undocumented 2 Ulmus americana :: American Elm 119 165 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   5992654.89634 2095512.3426 37.7334557864464 -122.467797500378 (37.7334557864464, -122.467797500378)
23738 23738 215457 Undocumented 2 Ulmus americana :: American Elm 119 170 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5992608.79004 2095578.76173 37.7336354943765 -122.467961730965 (37.7336354943765, -122.467961730965)
40492 40492 215456 Undocumented 2 Ulmus americana :: American Elm 119 170 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5992607.47204 2095602.74615 37.73370127349371 -122.46796803159599 (37.7337012734937, -122.467968031596)
57107 57107 215460 Undocumented 2 Ulmus americana :: American Elm 119 180 Santa Ana Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 5ft   5992612.98876 2095518.41795 37.7334700478853 -122.467942827217 (37.7334700478853, -122.467942827217)
170326 170326 215459 Undocumented 2 Ulmus americana :: American Elm 119 180 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 5ft   5992611.44157 2095531.51805 37.733505928144204 -122.46794912877199 (37.7335059281442, -122.467949128772)
174935 174935 215458 Undocumented 2 Ulmus americana :: American Elm 119 180 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 5ft   5992610.41916 2095552.22945 37.733562737437204 -122.467954169463 (37.7335627374372, -122.467954169463)
11790 11790 1012 DPW Maintained 3 Ulmus americana :: American Elm 119 1845 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 3X3   6001257.97709 2091441.7763099999 37.722771956545294 -122.437762838379 (37.7227719565453, -122.437762838379)
12221 12221 1017 Permitted Site 1 Ulmus americana :: American Elm 119 1863 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3x3   6001211.31639 2091358.64779 37.7225410511223 -122.437918182794 (37.7225410511223, -122.437918182794)
11506 11506 1018 DPW Maintained 3 Ulmus americana :: American Elm 119 1867 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     32 3x3   6001202.49586 2091340.5101 37.7224907475345 -122.43794737479799 (37.7224907475345, -122.437947374798)
188346 188346 215463 Undocumented 2 Ulmus americana :: American Elm 119 187 Magellan Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   5995065.4232 2100715.05952 37.747880054141 -122.459840423011 (37.747880054141, -122.459840423011)
11316 11316 1020 DPW Maintained 3 Ulmus americana :: American Elm 119 1871 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     26 3x3   6001188.68996 2091314.6663799998 37.72241900141479 -122.437993248302 (37.7224190014148, -122.437993248302)
11442 11442 17221 DPW Maintained 3 Ulmus americana :: American Elm 119 1875X Alemany Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3x3   6001098.52222 2091140.53503 37.7219357480204 -122.438292468038 (37.7219357480204, -122.438292468038)
12167 12167 17220 DPW Maintained 3 Ulmus americana :: American Elm 119 1875X Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3x3   6001085.65168 2091116.1737099998 37.7218681252969 -122.438335213721 (37.7218681252969, -122.438335213721)
12838 12838 17219 DPW Maintained 3 Ulmus americana :: American Elm 119 1875X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3x3   6001071.69008 2091082.82466 37.7217757622246 -122.438381087239 (37.7217757622246, -122.438381087239)
11388 11388 1022 DPW Maintained 3 Ulmus americana :: American Elm 119 1909 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6000975.40411 2090904.61398 37.721280958817296 -122.43870115865101 (37.7212809588173, -122.438701158651)
11151 11151 1023 DPW Maintained 3 Ulmus americana :: American Elm 119 1925 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6000937.4135 2090832.4174 37.7210805620079 -122.43882731013599 (37.7210805620079, -122.438827310136)
74703 74703 219470 Undocumented 2 Ulmus americana :: American Elm 119 195 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5992655.362840001 2095444.36492 37.733269163630396 -122.467790945215 (37.7332691636304, -122.467790945215)
167661 167661 219469 Undocumented 2 Ulmus americana :: American Elm 119 195 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5992654.63062 2095463.6379099998 37.733322040173704 -122.467794877931 (37.7333220401737, -122.467794877931)
179647 179647 219468 Undocumented 2 Ulmus americana :: American Elm 119 195 Santa Ana Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5992655.03542 2095482.8869900003 37.7333749167204 -122.467794877953 (37.7333749167204, -122.467794877953)
39016 39016 215462 Undocumented 2 Ulmus americana :: American Elm 119 196 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5992612.6930599995 2095452.3609 37.733288654633704 -122.467939046451 (37.7332886546337, -122.467939046451)
76880 76880 215461 Undocumented 2 Ulmus americana :: American Elm 119 196 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5992613.18906 2095475.9445900002 37.7333534382047 -122.467939046448 (37.7333534382047, -122.467939046448)
60812 60812 180507 Undocumented 2 Ulmus americana :: American Elm 119 1971 Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 2ft   6000896.20852 2090750.67644 37.7208537754604 -122.438963888373 (37.7208537754604, -122.438963888373)
57335 57335 180503 Undocumented 2 Ulmus americana :: American Elm 119 1985 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 2ft   6000822.0474 2090606.84585 37.7204546293715 -122.43920993661301 (37.7204546293715, -122.439209936613)
63310 63310 180506 Undocumented 2 Ulmus americana :: American Elm 119 1985 Alemany Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 2ft   6000867.32742 2090696.0115200002 37.720702034663205 -122.43905980559299 (37.7207020346632, -122.439059805593)
70096 70096 180505 Undocumented 2 Ulmus americana :: American Elm 119 1985 Alemany Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 2ft   6000851.907819999 2090665.09489 37.7206162672045 -122.43911089157 (37.7206162672045, -122.43911089157)
170062 170062 180504 Undocumented 2 Ulmus americana :: American Elm 119 1985 Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     34 Width 2ft   6000839.04929 2090641.3338 37.720550292949 -122.439153637233 (37.720550292949, -122.439153637233)
44494 44494 219471 Undocumented 2 Ulmus americana :: American Elm 119 2 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 8ft   5992545.99069 2096862.54215 37.7371568069404 -122.46827220569901 (37.7371568069404, -122.468272205699)
57563 57563 219473 Undocumented 2 Ulmus americana :: American Elm 119 2 Santa Ana Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   5992552.54486 2096838.2851099998 37.7370905817533 -122.468247781032 (37.7370905817533, -122.468247781032)
178764 178764 219472 Undocumented 2 Ulmus americana :: American Elm 119 2 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 8ft   5992548.15428 2096853.45183 37.7371319721693 -122.46826406414101 (37.7371319721693, -122.468264064141)
184102 184102 219474 Undocumented 2 Ulmus americana :: American Elm 119 2 Santa Ana Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 8ft   5992559.602630001 2096805.97754 37.737002280914204 -122.46822102977801 (37.7370022809142, -122.468221029778)
153107 153107 215470 Undocumented 2 Ulmus americana :: American Elm 119 2 Sola Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   5994985.87708 2100710.42792 37.7478627619652 -122.460115152419 (37.7478627619652, -122.460115152419)
69365 69365 219475 Undocumented 2 Ulmus americana :: American Elm 119 20 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 8ft   5992563.4880099995 2096782.78152 37.736938814873795 -122.46820590948201 (37.7369388148738, -122.468205909482)
134379 134379 219476 Undocumented 2 Ulmus americana :: American Elm 119 20 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   5992566.29417 2096756.2581900002 37.7368661505438 -122.468194278545 (37.7368661505438, -122.468194278545)
63618 63618 180502 Undocumented 2 Ulmus americana :: American Elm 119 2003 Alemany Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   6000738.6193 2090458.82485 37.7200434494224 -122.4394877147 (37.7200434494224, -122.4394877147)
31613 31613 219582 Undocumented 2 Ulmus americana :: American Elm 119 201 Montalvo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 3ft   5993843.784419999 2099442.0098200003 37.7443142502938 -122.46397236443998 (37.7443142502938, -122.46397236444)
162457 162457 219583 Undocumented 2 Ulmus americana :: American Elm 119 201 Montalvo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 3ft   5993863.59028 2099405.6094299997 37.7442154454004 -122.46390123884399 (37.7442154454004, -122.463901238844)
175855 175855 219581 Undocumented 2 Ulmus americana :: American Elm 119 201 Montalvo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 3ft   5993830.50755 2099471.62985 37.7443948142649 -122.464020422411 (37.7443948142649, -122.464020422411)
169445 169445 180501 Undocumented 2 Ulmus americana :: American Elm 119 2019 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 3ft   6000600.83666 2090287.11698 37.71956413596121 -122.43995167583401 (37.7195641359612, -122.439951675834)
176195 176195 242356 Undocumented 2 Ulmus americana :: American Elm 119 205 Virginia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6006761.93151 2098429.31569 37.7422696353456 -122.419232232979 (37.7422696353456, -122.419232232979)
171958 171958 180500 Undocumented 2 Ulmus americana :: American Elm 119 2051 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 3ft   6000567.81295 2090256.9791599999 37.719479504361 -122.440063666607 (37.719479504361, -122.440063666607)
188563 188563 180499 Undocumented 2 Ulmus americana :: American Elm 119 2055 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6000543.565280001 2090231.5563 37.7194083185059 -122.440145659613 (37.7194083185059, -122.440145659613)
59648 59648 180498 Undocumented 2 Ulmus americana :: American Elm 119 2059 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6000514.10075 2090205.66552 37.7193355507714 -122.44024565161301 (37.7193355507714, -122.440245651613)
180274 180274 180497 Undocumented 2 Ulmus americana :: American Elm 119 2061 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6000499.29084 2090188.9771099999 37.7192888849654 -122.440295647643 (37.7192888849654, -122.440295647643)
67025 67025 180496 Undocumented 2 Ulmus americana :: American Elm 119 2067 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   6000450.00528 2090141.8929 37.719156796129205 -122.440462633746 (37.7191567961292, -122.440462633746)
76496 76496 180487 Undocumented 2 Ulmus americana :: American Elm 119 2079 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 4ft   6000343.28213 2090036.1119400002 37.7188602680644 -122.440823949885 (37.7188602680644, -122.440823949885)
12967 12967 1067 DPW Maintained 3 Ulmus americana :: American Elm 119 2087X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3X3   6000311.61814 2090004.87585 37.7187726974675 -122.440931159865 (37.7187726974675, -122.440931159865)
13222 13222 1814 DPW Maintained 3 Ulmus americana :: American Elm 119 2090 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/01/1997 12:00:00 AM 6 3X3   6012058.52275 2087947.72362 37.713786216628996 -122.400182154876 (37.713786216629, -122.400182154876)
46437 46437 180486 Undocumented 2 Ulmus americana :: American Elm 119 2091 Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 3ft   6000288.07511 2089979.94333 37.7187028974975 -122.441010750768 (37.7187028974975, -122.441010750768)
11998 11998 1070 DPW Maintained 3 Ulmus americana :: American Elm 119 2101 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     32 3X3   6000193.5332 2089890.50062 37.718451922793605 -122.441331128839 (37.7184519227936, -122.441331128839)
17990 17990 21036 DPW Maintained 3 Ulmus americana :: American Elm 119 2101X Sunset Blvd 17 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60   5984980.9284488 2100900.997098 37.7478054765444 -122.49472533299699 (37.7478054765444, -122.494725332997)
85306 85306 21035 DPW Maintained 3 Ulmus americana :: American Elm 119 2101X Sunset Blvd 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60   5984980.9284488 2100900.997098 37.7478054765444 -122.49472533299699 (37.7478054765444, -122.494725332997)
111569 111569 21045 DPW Maintained 3 Ulmus americana :: American Elm 119 2101X Sunset Blvd 26 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60   5984980.9284488 2100900.997098 37.7478054765444 -122.49472533299699 (37.7478054765444, -122.494725332997)
12128 12128 25430 DPW Maintained 3 Ulmus americana :: American Elm 119 2118 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/01/1997 12:00:00 AM 6 3X3   6011929.296130001 2087786.5725 37.7133365214367 -122.400617498717 (37.7133365214367, -122.400617498717)
18243 18243 19076 DPW Maintained 3 Ulmus americana :: American Elm 119 212 Sagamore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3x3   5994913.18282 2087466.94262 37.711495187435006 -122.459407564904 (37.711495187435, -122.459407564904)
11403 11403 1077 DPW Maintained 3 Ulmus americana :: American Elm 119 2125 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3X3   6000118.830569999 2089820.5947599998 37.7182557213131 -122.44158433025 (37.7182557213131, -122.44158433025)
10687 10687 1080 Permitted Site 1 Ulmus americana :: American Elm 119 2143 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   6000078.80203 2089782.4585099998 37.718148727148794 -122.441719956114 (37.7181487271488, -122.441719956114)
11733 11733 1082 DPW Maintained 3 Ulmus americana :: American Elm 119 2149 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3X3   6000045.941869999 2089750.00425 37.7180577427488 -122.44183121126001 (37.7180577427488, -122.44183121126)

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