Street_Tree_List

Data source: data.sfgov.org

178 rows where PlotSize = "Width 3ft" and qSpecies = 27 sorted by Latitude

✎ View and edit SQL

This data as json, CSV (advanced)

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

PlotSize ✖

  • Width 3ft · 178 ✖
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude ▼ Longitude Location
157438 157438 177007 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 216 Saint Charles Ave 1 : 4 Tree 1 Private 1     5 Width 3ft   5992028.26989 2086999.54978 37.710045543251205 -122.469344489883 (37.7100455432512, -122.469344489883)
177917 177917 177001 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 154 Gillette Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6013011.29164 2086676.67622 37.7103492505861 -122.396799956671 (37.7103492505861, -122.396799956671)
44944 44944 176990 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Morse St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5998584.85135 2087137.0809 37.7107998882796 -122.446693649496 (37.7107998882796, -122.446693649496)
166521 166521 176991 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Morse St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5998612.37791 2087142.9006400001 37.710817440355704 -122.446598930212 (37.7108174403557, -122.446598930212)
26959 26959 176992 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Morse St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5998628.254290001 2087146.50399 37.7108282412039 -122.446544317082 (37.7108282412039, -122.446544317082)
57399 57399 176993 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Morse St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5998644.90157 2087151.5668400002 37.7108430935156 -122.44648714447099 (37.7108430935156, -122.446487144471)
39601 39601 176994 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Morse St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5998658.093780001 2087156.70124 37.7108579449184 -122.446441918457 (37.7108579449184, -122.446441918457)
158570 158570 176995 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Morse St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5998691.25418 2087172.2379400001 37.7109024991335 -122.44632842581301 (37.7109024991335, -122.446328425813)
72391 72391 176996 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Morse St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5998705.41323 2087176.369 37.7109146507487 -122.44627978598999 (37.7109146507487, -122.44627978599)
137436 137436 177005 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 362 Arleta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6009172.07817 2088408.58756 37.714890285531794 -122.410191328669 (37.7148902855318, -122.410191328669)
40455 40455 177006 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 271 Teddy Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009831.15293 2088401.27476 37.7149071271443 -122.40791276406 (37.7149071271443, -122.40791276406)
46658 46658 207264 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 319 Victoria St 1 : 4 Tree 1 Private 1     5 Width 3ft   5993222.99582 2089325.40947 37.716500767187 -122.465384161548 (37.716500767187, -122.465384161548)
36484 36484 207243 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 324 Lakeview Ave 1 : 4 Tree 1 Private 1     1 Width 3ft   5996808.75565 2089668.4523599998 37.7176488300194 -122.453014817795 (37.7176488300194, -122.453014817795)
156794 156794 207268 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 321 Shields St 1 : 4 Tree 1 Private 1     4 Width 3ft   5993118.56975 2089825.8623400002 37.7178688671261 -122.46578144695299 (37.7178688671261, -122.465781446953)
158423 158423 207267 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 800 Shields St 1 : 4 Tree 1 Private 1     4 Width 3ft   5991908.73686 2089873.18907 37.71792895264 -122.469966710089 (37.71792895264, -122.469966710089)
2094 2094 252881 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 3536 Jennings St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 3ft   6013049.3063900005 2089480.54762 37.718050242412296 -122.39686501810199 (37.7180502424123, -122.396865018102)
131761 131761 207244 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 246 Monticello St 1 : 4 Tree 1 Private 1     4 Width 3ft   5991705.04474 2090167.4544799998 37.7187251566245 -122.47069219949199 (37.7187251566245, -122.470692199492)
185209 185209 207231 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 250 Faxon Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   5994770.3606900005 2090247.29491 37.7191211640843 -122.46010248996099 (37.7191211640843, -122.460102489961)
51445 51445 207262 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 510 Ramsell St 2 : 4 Tree 1 Private 1     4 Width 3ft   5993010.6580300005 2090589.3329599998 37.7199589473287 -122.466209899286 (37.7199589473287, -122.466209899286)
176364 176364 207259 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 531 Arch St 1 : 4 Tree 1 Private 1     5 Width 3ft   5992719.90357 2090700.8696700002 37.720248420215 -122.467223034109 (37.720248420215, -122.467223034109)
186952 186952 207258 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 532 Arch St 1 : 4 Tree 1 Private 1     7 Width 3ft   5992753.93277 2090721.89417 37.7203081126976 -122.46710693523998 (37.7203081126976, -122.46710693524)
62400 62400 207257 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 545 Arch St 2 : 4 Tree 1 Private 1     8 Width 3ft   5992721.30272 2090787.38196 37.7204860426843 -122.467224484748 (37.7204860426843, -122.467224484748)
134488 134488 207256 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 545 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992721.58386 2090800.7544 37.720522776379596 -122.467224484746 (37.7205227763796, -122.467224484746)
39672 39672 207255 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 551 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992722.91506 2090824.1387 37.72058706082171 -122.467221582632 (37.7205870608217, -122.467221582632)
137140 137140 207254 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 559 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992720.910730001 2090888.5643799999 37.720763842354 -122.467233192875 (37.720763842354, -122.467233192875)
171030 171030 207253 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 556 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992754.265459999 2090897.47883 37.7207902446595 -122.46711854461 (37.7207902446595, -122.46711854461)
174314 174314 207252 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 560 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992752.3271699995 2090925.11248 37.7208660080514 -122.467127252727 (37.7208660080514, -122.467127252727)
138093 138093 207251 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 567 Arch St 1 : 4 Tree 1 Private 1     2 Width 3ft   5992723.294480001 2090942.0276900001 37.720910777190795 -122.46722883836 (37.7209107771908, -122.46722883836)
48128 48128 207250 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 571 Arch St 1 : 4 Tree 1 Private 1     5 Width 3ft   5992722.93824 2090965.0292099998 37.7209739131985 -122.467231741345 (37.7209739131985, -122.467231741345)
178299 178299 207249 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 581 Arch St 1 : 4 Tree 1 Private 1     7 Width 3ft   5992725.89958 2091026.00542 37.7211415099655 -122.467225936253 (37.7211415099655, -122.467225936253)
24738 24738 207248 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 574 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992756.55156 2091026.1972 37.7211438059241 -122.46711999608401 (37.7211438059241, -122.467119996084)
166192 166192 207245 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 495 Ralston St 3 : 4 Tree 1 Private 1     4 Width 3ft   5992206.61176 2091125.8340200002 37.7213856246322 -122.469028209083 (37.7213856246322, -122.469028209083)
187054 187054 207246 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 495 Ralston St 2 : 4 Tree 1 Private 1     4 Width 3ft   5992206.82998 2091154.32928 37.7214638782474 -122.469029527495 (37.7214638782474, -122.469029527495)
156004 156004 207247 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 495 Ralston St 1 : 4 Tree 1 Private 1     4 Width 3ft   5992207.674790001 2091176.35111 37.721524393612 -122.46902820910299 (37.721524393612, -122.469028209103)
37320 37320 207230 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 437 Holloway Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5995450.98225 2091203.60917 37.7217860999295 -122.457819021351 (37.7217860999295, -122.457819021351)
56436 56436 207226 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 224 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5995369.52282 2091446.6873400002 37.722448854419795 -122.45811818710399 (37.7224488544198, -122.458118187104)
155074 155074 207225 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 272 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996551.89898 2091549.3096 37.7227984982343 -122.454038414459 (37.7227984982343, -122.454038414459)
133337 133337 177023 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1628 Burrows St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6006643.54009 2092125.7831400002 37.7249548539585 -122.419194556805 (37.7249548539585, -122.419194556805)
172270 172270 177022 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1628 Burrows St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6006681.726369999 2092138.2756599998 37.724991306183796 -122.419063436538 (37.7249913061838, -122.419063436538)
34210 34210 177025 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 300 Hamilton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009309.80145 2092849.9581799998 37.727093081168604 -122.410028653892 (37.7270930811686, -122.410028653892)
153631 153631 207288 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 80 Manor Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993609.88258 2093413.56437 37.7277481554518 -122.46434354343599 (37.7277481554518, -122.464343543436)
155331 155331 207287 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 80 Manor Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993617.196719999 2093428.42881 37.7277893911619 -122.464319337265 (37.7277893911619, -122.464319337265)
54753 54753 207286 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 80 Manor Dr 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993623.31026 2093437.41863 37.7278144273955 -122.464298855206 (37.7278144273955, -122.464298855206)
63518 63518 207294 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1414 Plymouth Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5995890.4022699995 2093395.3891200002 37.727829439763106 -122.456458481978 (37.7278294397631, -122.456458481978)
179484 179484 207285 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 84 Manor Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5993629.18842 2093448.0222200002 37.7278438810755 -122.464279303953 (37.7278438810755, -122.464279303953)
130898 130898 207284 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 84 Manor Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993637.22552 2093458.84875 37.727874071330106 -122.464252305417 (37.7278740713301, -122.464252305417)
130433 130433 207283 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 84 Manor Dr 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993642.59329 2093470.80397 37.7279072068291 -122.464234616632 (37.7279072068291, -122.464234616632)
173504 173504 207289 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 81 Pinehurst Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5993404.50324 2093508.25253 37.727996305369395 -122.465060411924 (37.7279963053694, -122.465060411924)
31710 31710 207290 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 81 Pinehurst Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5993410.050430001 2093515.91328 37.7280176597738 -122.465041791443 (37.7280176597738, -122.465041791443)
59419 59419 207291 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 135 Pinehurst Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5993593.95913 2093848.0757900001 37.7289402994475 -122.464430125662 (37.7289402994475, -122.464430125662)
43666 43666 207282 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 163 Westwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5995118.51339 2093829.85755 37.7289780403896 -122.459158347475 (37.7289780403896, -122.459158347475)
61063 61063 207293 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 965 Darien Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5994659.04342 2093888.37752 37.729112296585996 -122.460750997386 (37.729112296586, -122.460750997386)
131611 131611 207292 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 965 Darien Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5994659.45419 2093917.36528 37.729191913559205 -122.460751677241 (37.7291919135592, -122.460751677241)
166261 166261 207306 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 40 Hazelwood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5996625.80083 2093939.75542 37.7293663316726 -122.453955505049 (37.7293663316726, -122.453955505049)
149640 149640 207307 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 40 Hazelwood Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5996632.29133 2093946.6824400001 37.7293857237559 -122.453933566973 (37.7293857237559, -122.453933566973)
32289 32289 207308 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 40 Hazelwood Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5996630.86084 2093949.68597 37.7293938887121 -122.453938729108 (37.7293938887121, -122.453938729108)
33808 33808 207309 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 40 Hazelwood Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5996632.84291 2093955.22047 37.72940919877011 -122.45393227647699 (37.7294091987701, -122.453932276477)
56956 56956 207310 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 40 Hazelwood Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5996630.650640001 2093957.49673 37.7294153231391 -122.453940019643 (37.7294153231391, -122.453940019643)
149202 149202 207311 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 40 Hazelwood Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5996623.9577 2093958.7514099998 37.729418384438894 -122.453963248219 (37.7294183844389, -122.453963248219)
147662 147662 207305 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 45 Hazelwood Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5996586.90838 2093990.0061299999 37.7295020780524 -122.454093586973 (37.7295020780524, -122.454093586973)
42179 42179 207304 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 53 Hazelwood Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5996585.7495 2094006.0145 37.72954596675461 -122.454098749052 (37.7295459667546, -122.454098749052)
58147 58147 207303 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 59 Hazelwood Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5996585.5854400005 2094033.89672 37.7296225152507 -122.45410132920601 (37.7296225152507, -122.454101329206)
37568 37568 207302 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 65 Hazelwood Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5996572.7806400005 2094082.116 37.72975417960021 -122.45414907781799 (37.7297541796002, -122.454149077818)
133706 133706 207160 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 384 Santa Ana Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992464.42361 2094258.2447 37.7300013456858 -122.46836480621799 (37.7300013456858, -122.468364806218)
184253 184253 207297 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 217 Colon Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5996046.36344 2094274.51279 37.730252254734104 -122.455982853036 (37.7302522547341, -122.455982853036)
74649 74649 207296 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 217 Colon Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5996041.08515 2094289.8634799998 37.7302941010767 -122.456002210028 (37.7302941010767, -122.456002210028)
61510 61510 207295 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 217 Colon Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5996039.75572 2094297.6973299999 37.7303155346371 -122.45600737215 (37.7303155346371, -122.45600737215)
53847 53847 207299 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 111 Valdez Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996293.5704 2094296.85345 37.7303277824929 -122.455129844261 (37.7303277824929, -122.455129844261)
76051 76051 207298 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 111 Valdez Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5996286.51947 2094316.70178 37.73038187671379 -122.45515565391099 (37.7303818767138, -122.455155653911)
173392 173392 207197 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 580 Hearst Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997566.05489 2094416.0866599998 37.730728090525 -122.45073930547899 (37.730728090525, -122.450739305479)
27919 27919 207196 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 580 Hearst Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997574.55439 2094416.3667 37.7307293459771 -122.450709941708 (37.7307293459771, -122.450709941708)
29133 29133 207198 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 580 Hearst Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5997541.97184 2094417.04598 37.7307293459865 -122.450822633076 (37.7307293459865, -122.450822633076)
179463 179463 207199 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 580 Hearst Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5997518.57205 2094417.76245 37.7307299736956 -122.450903581047 (37.7307299736956, -122.450903581047)
52824 52824 207200 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 580 Hearst Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5997508.4902099995 2094418.65818 37.7307318559937 -122.45093849993401 (37.7307318559937, -122.450938499934)
125304 125304 177013 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 78 Lamartine St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002644.59595 2094315.3545 37.7307409031583 -122.433174819278 (37.7307409031583, -122.433174819278)
91369 91369 177012 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 78 Lamartine St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002642.0398 2094328.25695 37.730776185352504 -122.433184577831 (37.7307761853525, -122.433184577831)
28331 28331 207313 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 101 Ridgewood Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996777.96593 2094453.90027 37.730786773973605 -122.45346656615101 (37.7307867739736, -122.453466566151)
38221 38221 177011 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 78 Lamartine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6002637.06105 2094341.00901 37.73081091718 -122.433202700959 (37.73081091718, -122.433202700959)
70729 70729 177010 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 78 Lamartine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002632.11132 2094355.1655700002 37.73084950708879 -122.433220824095 (37.7308495070888, -122.433220824095)
73988 73988 207312 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 101 Ridgewood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996777.2193 2094487.3918299999 37.730878690977704 -122.45347156457399 (37.7308786909777, -122.453471564574)
28926 28926 207301 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 145 Hazelwood Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5996452.48883 2094524.36789 37.7309615985977 -122.454596874545 (37.7309615985977, -122.454596874545)
62171 62171 207300 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 145 Hazelwood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996448.99813 2094535.9636799998 37.730993237639105 -122.45460977981199 (37.7309932376391, -122.454609779812)
43733 43733 207159 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 345 San Fernando Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992101.70168 2094641.4985900002 37.7310327079752 -122.469646658486 (37.7310327079752, -122.469646658486)
39694 39694 191411 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 462 Thornton Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   6012808.38143 2094403.0124599999 37.7315529172119 -122.39804293216001 (37.7315529172119, -122.39804293216)
70124 70124 207280 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 595 Darien Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993435.14458 2094919.26873 37.731872375313294 -122.46505692344299 (37.7318723753133, -122.465056923443)
54556 54556 207281 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 595 Darien Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993428.290469999 2094922.6798 37.731881346040794 -122.46508086700001 (37.7318813460408, -122.465080867)
150214 150214 207343 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 543 Foerster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5998102.37114 2095220.43245 37.732967318787296 -122.448943103064 (37.7329673187873, -122.448943103064)
70323 70323 207350 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 618 Mangels Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5997300.95019 2095282.96772 37.7330931600175 -122.451718319154 (37.7330931600175, -122.451718319154)
133764 133764 207351 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 662 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   5997053.67683 2095305.7853299999 37.7331416469589 -122.45257485054701 (37.7331416469589, -122.452574850547)
178259 178259 207338 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 620 Congo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6000133.83069 2095802.7969900002 37.7346823250329 -122.441961624641 (37.7346823250329, -122.441961624641)
123823 123823 207323 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 734 Teresita Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5998893.471580001 2095962.39727 37.7350497898071 -122.446261428139 (37.7350497898071, -122.446261428139)
37609 37609 207322 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 734 Teresita Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5998892.3170300005 2095965.24165 37.7350575338629 -122.44626562436001 (37.7350575338629, -122.44626562436)
27878 27878 226609 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 4005 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008395.3202599995 2096426.5831400002 37.736862424666704 -122.413442851824 (37.7368624246667, -122.413442851824)
29724 29724 207328 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 400x Marietta Dr 10 Median : Cutout 11 Tree 1 DPW 2     5 Width 3ft   5999485.75789 2097034.69989 37.738027887567796 -122.444290723035 (37.7380278875678, -122.444290723035)
27445 27445 207324 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 85 Sequoia Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5998176.702190001 2097175.31508 37.7383392103809 -122.44882688276199 (37.7383392103809, -122.448826882762)
129828 129828 226614 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 322 Elsie St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006361.987980001 2097015.1421299998 37.738364099132795 -122.42051475707399 (37.7383640991328, -122.420514757074)
63672 63672 226582 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 383 Elsie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006413.772530001 2097021.64328 37.738384868057295 -122.420336172385 (37.7383848680573, -122.420336172385)
152673 152673 226615 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 10 Appleton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6005546.7514 2097096.0791900002 37.7385403572369 -122.423339202051 (37.7385403572369, -122.423339202051)
52054 52054 226616 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 2 Appleton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6005523.88104 2097105.4034 37.7385646686269 -122.42341893953899 (37.7385646686269, -122.423418939539)
59140 59140 207326 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 43 Gaviota Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   5998477.362380001 2097389.2678 37.7389438623547 -122.447802750104 (37.7389438623547, -122.447802750104)

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