Street_Tree_List

Data source: data.sfgov.org

1,636 rows where qSpecies = 1 sorted by rowid descending

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
189138 232332 Undocumented 2 Myoporum laetum :: Myoporum 1 90 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   6001483.73316 2099106.7788299997 37.7438311192153 -122.437531090286 (37.7438311192153, -122.437531090286)
189131 137675 Undocumented 2 Myoporum laetum :: Myoporum 1 1750 MCALLISTER ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   6000771.1568 2111397.1454 37.777536910919 -122.440876486346 (37.777536910919, -122.440876486346)
189120 98169 Permitted Site 1 Myoporum laetum :: Myoporum 1 2941 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/30/2015 12:00:00 AM 19 3x3 Permit Number 775039 6000613.54695 2116154.22533 37.7905896504327 -122.44176320452299 (37.7905896504327, -122.441763204523)
189107 119207 Undocumented 2 Myoporum laetum :: Myoporum 1 851 48th Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5981051.50114 2110011.96585 37.7725907952116 -122.50898926789499 (37.7725907952116, -122.508989267895)
189026 248177 Undocumented 2 Myoporum laetum :: Myoporum 1 218 Esmeralda Ave 6 Side Yard : Yard 17 Tree 1 Private 1     14     6007380.96811 2098703.14115 37.743056342490796 -122.417111187331 (37.7430563424908, -122.417111187331)
189002 186741 Undocumented 2 Myoporum laetum :: Myoporum 1 1200 Sunset Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984866.449 2106632.432 37.7635357085517 -122.495543856208 (37.7635357085517, -122.495543856208)
188594 232351 Undocumented 2 Myoporum laetum :: Myoporum 1 591 27th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 4ft   6002754.32401 2100037.48203 37.7464587700721 -122.433204176748 (37.7464587700721, -122.433204176748)
188549 138262 Undocumented 2 Myoporum laetum :: Myoporum 1 2600 GEARY BLVD 30 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8 Width 0ft   5999046.0043 2113182.6602 37.7823410698302 -122.44697286174801 (37.7823410698302, -122.446972861748)
188301 232288 Undocumented 2 Myoporum laetum :: Myoporum 1 1 Day St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6005609.575130001 2098736.17342 37.7430472314506 -122.423238540044 (37.7430472314506, -122.423238540044)
188202 248243 Undocumented 2 Myoporum laetum :: Myoporum 1 296 Esmeralda Ave 3 Side Yard : Yard 17 Tree 1 Private 1     7     6006794.0541900005 2099005.53684 37.743853618456995 -122.41916202653299 (37.743853618457, -122.419162026533)
188149 69118 Permitted Site 1 Myoporum laetum :: Myoporum 1 2165 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/18/1994 12:00:00 AM 15   Permit Number 33135 5990058.1358 2100634.1785 37.7473687383221 -122.477149295728 (37.7473687383221, -122.477149295728)
188136 119190 Undocumented 2 Myoporum laetum :: Myoporum 1 850 La Playa 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5980791.5999300005 2109976.85312 37.7724790610914 -122.50988566798999 (37.7724790610914, -122.50988566799)
188122 184539 Undocumented 2 Myoporum laetum :: Myoporum 1 1939 47th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 0ft   5981627.7505 2101868.0843 37.7502639852004 -122.50639195948 (37.7502639852004, -122.50639195948)
188014 113280 Permitted Site 1 Myoporum laetum :: Myoporum 1 2001 Union St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19     6003340.59835 2118579.59665 37.7974041031652 -122.432501080454 (37.7974041031652, -122.432501080454)
188004 181605 Undocumented 2 Myoporum laetum :: Myoporum 1 1352 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   5981543.7588 2105882.1849 37.7612806196192 -122.506980129167 (37.7612806196192, -122.506980129167)
187810 138265 Undocumented 2 Myoporum laetum :: Myoporum 1 2600 GEARY BLVD 33 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 0ft   5999027.3911 2113166.4159 37.7822954037862 -122.447036085573 (37.7822954037862, -122.447036085573)
187698 183262 Undocumented 2 Myoporum laetum :: Myoporum 1 1227 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   5981160.7547 2106692.5355 37.7634830454186 -122.508364908995 (37.7634830454186, -122.508364908995)
187599 184484 Undocumented 2 Myoporum laetum :: Myoporum 1 2023 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   5982272.9737 2101322.4989 37.7488039266584 -122.504120365121 (37.7488039266584, -122.504120365121)
187547 119178 Undocumented 2 Myoporum laetum :: Myoporum 1 756 La Playa 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5980765.96509 2110596.91774 37.7741800640196 -122.510020413475 (37.7741800640196, -122.510020413475)
187357 182916 Undocumented 2 Myoporum laetum :: Myoporum 1 2721 47th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5981813.2277 2096626.2195 37.7358821968093 -122.505362102343 (37.7358821968093, -122.505362102343)
187284 139491 Undocumented 2 Myoporum laetum :: Myoporum 1 634 BAKER ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6000585.2313 2111232.5891 37.7770744904126 -122.441507851651 (37.7770744904126, -122.441507851651)
187153 245032 Undocumented 2 Myoporum laetum :: Myoporum 1 201 Central Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 0ft   5999841.5231 2109202.7939 37.7714587904356 -122.44393468835301 (37.7714587904356, -122.443934688353)
187126 142895 Undocumented 2 Myoporum laetum :: Myoporum 1 1015 DIVISADERO ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 0ft   6000919.8741 2115393.3679 37.788517982728294 -122.440648735369 (37.7885179827283, -122.440648735369)
187019 232344 Undocumented 2 Myoporum laetum :: Myoporum 1 685 29th St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6002211.07877 2098832.45348 37.7431192122771 -122.434996487813 (37.7431192122771, -122.434996487813)
186980 137717 Undocumented 2 Myoporum laetum :: Myoporum 1 1715 MCALLISTER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   6000915.8866 2111365.991 37.7774596105153 -122.440373583969 (37.7774596105153, -122.440373583969)
186787 182907 Undocumented 2 Myoporum laetum :: Myoporum 1 2988 Sloat Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5981661.6147 2096543.3062 37.735645616787 -122.505880134271 (37.735645616787, -122.505880134271)
186750 232347 Undocumented 2 Myoporum laetum :: Myoporum 1 683 29th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6002236.903630001 2098838.13664 37.743136283220004 -122.434907598826 (37.74313628322, -122.434907598826)
186525 210514 Undocumented 2 Myoporum laetum :: Myoporum 1 405 Detroit St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 2ft   5999413.51386 2094469.4998 37.7309803305562 -122.44435621076599 (37.7309803305562, -122.444356210766)
186489 232384 Undocumented 2 Myoporum laetum :: Myoporum 1 436 Alvarado St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 3ft   6003536.05619 2102755.84722 37.753967078541 -122.430694984601 (37.753967078541, -122.430694984601)
186324 194062 Undocumented 2 Myoporum laetum :: Myoporum 1 570 Barneveld Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     6010992.45281 2097208.4358099997 37.7391547075314 -122.404518390821 (37.7391547075314, -122.404518390821)
185679 118921 Undocumented 2 Myoporum laetum :: Myoporum 1 855 La Playa 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   5980742.3657 2109876.07038 37.77219943749321 -122.510048482225 (37.7721994374932, -122.510048482225)
185303 210564 Undocumented 2 Myoporum laetum :: Myoporum 1 174 Stillings Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 3ft   5999604.446330001 2095791.84825 37.734622081233 -122.44379109388201 (37.734622081233, -122.443791093882)
185275 182167 Undocumented 2 Myoporum laetum :: Myoporum 1 1519 Lawton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5989538.7754 2104438.5632 37.7577844240279 -122.479223446179 (37.7577844240279, -122.479223446179)
185068 194059 Undocumented 2 Myoporum laetum :: Myoporum 1 540 Barneveld Ave 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 10ft   6011016.84858 2097513.47253 37.7399936365049 -122.404455506617 (37.7399936365049, -122.404455506617)
185011 184464 Undocumented 2 Myoporum laetum :: Myoporum 1 2149 48th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   5981372.6025 2100411.6366 37.746249963664496 -122.50716622744899 (37.7462499636645, -122.507166227449)
184980 61774 Permitted Site 1 Myoporum laetum :: Myoporum 1 2574 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/1984 12:00:00 AM 17   Permit Number 21793 5983996.4567 2097655.6872 37.7388370676495 -122.497889927941 (37.7388370676495, -122.497889927941)
184821 131744 Undocumented 2 Myoporum laetum :: Myoporum 1 2760 Divisadero St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 5ft   6000643.38971 2117843.6395400004 37.7952300397944 -122.44178125031401 (37.7952300397944, -122.441781250314)
184785 113031 DPW Maintained 3 Myoporum laetum :: Myoporum 1 251 06th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     14 3x3   5993971.49407 2113867.66105 37.7839306754778 -122.464578040665 (37.7839306754778, -122.464578040665)
184453 131714 Undocumented 2 Myoporum laetum :: Myoporum 1 3250 Pacific Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   5998496.90584 2116567.36238 37.791603184595104 -122.44911640329398 (37.7916031845951, -122.449116403294)
184351 210509 Undocumented 2 Myoporum laetum :: Myoporum 1 57 Agua Way 12 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     13 Width 6ft   5997270.91609 2098557.47378 37.7420824423506 -122.452058324935 (37.7420824423506, -122.452058324935)
184202 177807 Undocumented 2 Myoporum laetum :: Myoporum 1 62 Tomaso Ct 12 Front Yard : Yard 7 Tree 1 Private 1     19 Width 8ft   6009274.965480001 2086528.64182 37.7097341062031 -122.409703090337 (37.7097341062031, -122.409703090337)
184175 232387 Undocumented 2 Myoporum laetum :: Myoporum 1 421 Alvarado St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 3ft   6003627.95342 2102718.00342 37.7538683743317 -122.43037448240601 (37.7538683743317, -122.430374482406)
184068 182901 Undocumented 2 Myoporum laetum :: Myoporum 1 2741 47th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5981815.2582 2096575.1178 37.735742005024704 -122.505351295814 (37.7357420050247, -122.505351295814)
183762 232287 Undocumented 2 Myoporum laetum :: Myoporum 1 101 Webster St 1 : 4 Tree 1 Private 1     18 Width 3ft   6004240.14437 2109135.1756700003 37.7715230535659 -122.42871480966801 (37.7715230535659, -122.428714809668)
183582 210494 Undocumented 2 Myoporum laetum :: Myoporum 1 357 San Leandro Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   5992317.252180001 2094479.3094400002 37.7305998328129 -122.468889672143 (37.7305998328129, -122.468889672143)
183405 210488 Undocumented 2 Myoporum laetum :: Myoporum 1 151 Merced Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 4ft   5994442.89864 2099348.29317 37.744091436984604 -122.461893975434 (37.7440914369846, -122.461893975434)
183303 181622 Undocumented 2 Myoporum laetum :: Myoporum 1 1290 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   5988346.4954 2106522.0072 37.7634356778204 -122.483499531609 (37.7634356778204, -122.483499531609)
183151 210481 Undocumented 2 Myoporum laetum :: Myoporum 1 190 Lomita Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   5991247.86955 2104080.60012 37.7569006643627 -122.47328664107401 (37.7569006643627, -122.473286641074)
183143 183616 Undocumented 2 Myoporum laetum :: Myoporum 1 1411 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   5982133.8491 2105471.1201 37.7601866870275 -122.504908829221 (37.7601866870275, -122.504908829221)
183007 141570 Undocumented 2 Myoporum laetum :: Myoporum 1 1500 GROVE ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   6000544.9798 2110674.7391 37.7755404825215 -122.441607051112 (37.7755404825215, -122.441607051112)
182795 177819 Undocumented 2 Myoporum laetum :: Myoporum 1 35 Tomaso Ct 6 Side Yard : Yard 17 Tree 1 Private 1     16 Width 3ft   6009193.28856 2086304.97531 37.709115386123 -122.40996960262501 (37.709115386123, -122.409969602625)
182740 118457 Undocumented 2 Myoporum laetum :: Myoporum 1 490 48th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft   5981011.746169999 2112476.4222 37.779355120923 -122.509309837992 (37.779355120923, -122.509309837992)
182654 140831 Undocumented 2 Myoporum laetum :: Myoporum 1 395 EUCLID AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   5997480.2959 2113812.6324 37.78398123184021 -122.45243496777799 (37.7839812318402, -122.452434967778)
182531 184453 Undocumented 2 Myoporum laetum :: Myoporum 1 2127 45th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   5982298.6938 2100612.8284 37.746856881718294 -122.503978870033 (37.7468568817183, -122.503978870033)
182272 131763 Undocumented 2 Myoporum laetum :: Myoporum 1 1457 Jones St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     16 Width 3ft   6008417.06699 2117517.79175 37.794775211263705 -122.414859937834 (37.7947752112637, -122.414859937834)
182255 186502 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 30 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5980892.5842 2105334.0684 37.7597372788194 -122.509191521679 (37.7597372788194, -122.509191521679)
182248 232293 Undocumented 2 Myoporum laetum :: Myoporum 1 200 Eugenia Ave 37 Front Yard : Yard 7 Tree 1 Private 1     17     6006572.50895 2098130.46557 37.741438390175205 -122.41986599782301 (37.7414383901752, -122.419865997823)
182180 210572 Undocumented 2 Myoporum laetum :: Myoporum 1 300 Melrose Ave 4 Side Yard : Yard 17 Tree 1 Private 1     12     5998021.954 2095543.6754599998 37.7338502677764 -122.449244404708 (37.7338502677764, -122.449244404708)
182170 185694 Undocumented 2 Myoporum laetum :: Myoporum 1 2101 Sunset Blvd 26 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984861.0881 2100529.8889 37.7467794993444 -122.495112367353 (37.7467794993444, -122.495112367353)
182075 186798 Undocumented 2 Myoporum laetum :: Myoporum 1 1200 Sunset Blvd 76 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984847.2394 2106906.9776 37.7642884087703 -122.495630546663 (37.7642884087703, -122.495630546663)
182026 122478 Undocumented 2 Myoporum laetum :: Myoporum 1 4350 Irving St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3x3   5982167.0839 2106280.7818 37.762411742125394 -122.504853884793 (37.7624117421254, -122.504853884793)
181911 186516 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 2 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5980905.2686 2104991.5894 37.758797677676704 -122.509122221366 (37.7587976776767, -122.509122221366)
181863 131761 Undocumented 2 Myoporum laetum :: Myoporum 1 24 Priest St 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 10ft   6008326.19973 2117161.77492 37.7937925706325 -122.415149139144 (37.7937925706325, -122.415149139144)
181572 232385 Undocumented 2 Myoporum laetum :: Myoporum 1 465 Alvarado St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6003363.45944 2102701.3394400002 37.753807633235795 -122.431287974181 (37.7538076332358, -122.431287974181)
181410 244039 Undocumented 2 Myoporum laetum :: Myoporum 1 575 Cole St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5997978.8773 2108635.6714 37.7697951913876 -122.45033675709401 (37.7697951913876, -122.450336757094)
181372 66297 Permitted Site 1 Myoporum laetum :: Myoporum 1 2054 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/27/1990 12:00:00 AM 14   Permit Number 29408 5986536.6056 2097051.3953 37.7373264330852 -122.489062983875 (37.7373264330852, -122.489062983875)
181346 245103 Undocumented 2 Myoporum laetum :: Myoporum 1 250 Central Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5999859.4717 2109392.5831 37.7719809274281 -122.44388624152701 (37.7719809274281, -122.443886241527)
181337 186724 Undocumented 2 Myoporum laetum :: Myoporum 1 1300 Sunset Blvd 58 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 0ft   5984849.7405 2106204.9407 37.762360958924106 -122.49557011228998 (37.7623609589241, -122.49557011229)
181266 194071 Undocumented 2 Myoporum laetum :: Myoporum 1 2260 Palou Ave 1 : 4 Tree 1 Private 1     13     6011443.9729 2097950.47892 37.7412174231363 -122.403009408459 (37.7412174231363, -122.403009408459)
180900 232341 Undocumented 2 Myoporum laetum :: Myoporum 1 689 29th St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25     6002137.6004 2098831.04756 37.7431111795389 -122.435250455448 (37.7431111795389, -122.435250455448)
180704 115482 Permitted Site 1 Myoporum laetum :: Myoporum 1 4508 IRVING ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x3   5981714.0 2106294.0 37.7624213702268 -122.506421887419 (37.7624213702268, -122.506421887419)
180498 210470 Undocumented 2 Myoporum laetum :: Myoporum 1 1690 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft   5991162.02278 2103898.4672 37.7563956041803 -122.47357024317499 (37.7563956041803, -122.473570243175)
180494 119201 Undocumented 2 Myoporum laetum :: Myoporum 1 851 48th Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5981058.88623 2109735.33972 37.771831696349395 -122.508943178948 (37.7718316963494, -122.508943178948)
180452 177816 Undocumented 2 Myoporum laetum :: Myoporum 1 60 Tomaso Ct 1 Front Yard : Yard 7 Tree 1 Private 1     15 Width 3ft   6009147.33252 2086269.1354099999 37.7090144012735 -122.41012590570601 (37.7090144012735, -122.410125905706)
180343 177809 Undocumented 2 Myoporum laetum :: Myoporum 1 968 Athens St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 4ft   6002194.0253 2088207.5246700002 37.7139446016244 -122.434296011252 (37.7139446016244, -122.434296011252)
180202 232328 Undocumented 2 Myoporum laetum :: Myoporum 1 1801 Diamond St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 6ft   6002075.48932 2098744.22684 37.742869262806295 -122.435459009147 (37.7428692628063, -122.435459009147)
180143 194090 Undocumented 2 Myoporum laetum :: Myoporum 1 1 Apparel Way 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14     6011245.93679 2097821.82718 37.740853112271 -122.403685100604 (37.740853112271, -122.403685100604)
179863 131710 Undocumented 2 Myoporum laetum :: Myoporum 1 3883 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5996211.855140001 2115544.15441 37.788662774721296 -122.45694856482099 (37.7886627747213, -122.456948564821)
179582 131713 Undocumented 2 Myoporum laetum :: Myoporum 1 3250 Pacific Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   5998501.34187 2116568.43338 37.791606378991 -122.449101131933 (37.791606378991, -122.449101131933)
179465 118837 Undocumented 2 Myoporum laetum :: Myoporum 1 600 46th Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 5ft   5981666.867000001 2111590.99028 37.776962590483606 -122.506977842076 (37.7769625904836, -122.506977842076)
179361 118518 Undocumented 2 Myoporum laetum :: Myoporum 1 8101 Geary Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   5981838.6124 2112334.07721 37.7790130012815 -122.506438851987 (37.7790130012815, -122.506438851987)
179327 109508 Undocumented 2 Myoporum laetum :: Myoporum 1 7200X Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 3x3   5981051.27607 2109621.18503 37.771517812403296 -122.508961024865 (37.7715178124033, -122.508961024865)
179324 141572 Undocumented 2 Myoporum laetum :: Myoporum 1 1500 GROVE ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 0ft   6000505.2315 2110670.5234 37.7755266425728 -122.441744247068 (37.7755266425728, -122.441744247068)
179305 119189 Undocumented 2 Myoporum laetum :: Myoporum 1 850 La Playa 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5980788.77167 2110011.06332 37.7725728254374 -122.509897992863 (37.7725728254374, -122.509897992863)
178803 186506 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 6 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5980906.3041 2105016.4405 37.7588659727132 -122.50912048557801 (37.7588659727132, -122.509120485578)
178712 141016 Undocumented 2 Myoporum laetum :: Myoporum 1 173 Blake St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   5997892.832 2112650.4919 37.780813925104 -122.450923923692 (37.780813925104, -122.450923923692)
178603 210523 Undocumented 2 Myoporum laetum :: Myoporum 1 296 Lobos St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   5994101.23211 2088733.3492 37.7149257215239 -122.46230564910499 (37.7149257215239, -122.462305649105)
178554 177808 Undocumented 2 Myoporum laetum :: Myoporum 1 35 Melra Ct 1 : 4 Tree 1 Private 1     22 Width 4ft   6008994.91617 2086485.2732900002 37.709599327506794 -122.410667934296 (37.7095993275068, -122.410667934296)
178367 141014 Undocumented 2 Myoporum laetum :: Myoporum 1 169 Blake St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   5997888.4326 2112693.4715 37.7809316839906 -122.450942243363 (37.7809316839906, -122.450942243363)
178024 210539 Undocumented 2 Myoporum laetum :: Myoporum 1 2385 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   5992618.35497 2099256.92458 37.7437353549177 -122.468196141042 (37.7437353549177, -122.468196141042)
178017 118671 Undocumented 2 Myoporum laetum :: Myoporum 1 4550 Balboa St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   5981403.18631 2110994.97114 37.775310565245206 -122.50784573679199 (37.7753105652452, -122.507845736792)
178015 210527 Undocumented 2 Myoporum laetum :: Myoporum 1 491 Bright St 1 : 4 Tree 1 Private 1     15 Width 3ft   5993759.26647 2090422.7728900001 37.7195447771444 -122.463610156198 (37.7195447771444, -122.463610156198)
177972 183099 Undocumented 2 Myoporum laetum :: Myoporum 1 2255 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5982636.6711 2099764.8205 37.744548355551 -122.50274743432301 (37.744548355551, -122.502747434323)
177905 43789 Permitted Site 1 Myoporum laetum :: Myoporum 1 121 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/26/2000 12:00:00 AM 10   Permit Number 43419 5988953.60454 2114542.0898700003 37.7854919174236 -122.481987309149 (37.7854919174236, -122.481987309149)
177720 184654 Undocumented 2 Myoporum laetum :: Myoporum 1 1692 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   5983179.841 2103606.2411 37.755127736003104 -122.501153362005 (37.7551277360031, -122.501153362005)
177669 232327 Undocumented 2 Myoporum laetum :: Myoporum 1 636 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 2ft   6001758.35109 2099439.0334400004 37.744759021714394 -122.436605304811 (37.7447590217144, -122.436605304811)
177620 210577 Undocumented 2 Myoporum laetum :: Myoporum 1 371 Staples Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     27 Width 5ft   5997627.625030001 2093788.53301 37.72900850132 -122.45048122525499 (37.72900850132, -122.450481225255)
177387 210491 Undocumented 2 Myoporum laetum :: Myoporum 1 325 San Leandro Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   5992370.72105 2094745.70098 37.7313343666897 -122.46872420046499 (37.7313343666897, -122.468724200465)
177255 210529 Undocumented 2 Myoporum laetum :: Myoporum 1 233 Garfield St 1 : 4 Tree 1 Private 1     15 Width 3ft   5993351.020380001 2090459.95557 37.7196233401215 -122.465024001983 (37.7196233401215, -122.465024001983)
177134 246704 Undocumented 2 Myoporum laetum :: Myoporum 1 1 Bonview St 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6007707.12573 2099125.1145 37.7442333302171 -122.416013295873 (37.7442333302171, -122.416013295873)

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