home / trees

Street_Tree_List

Data source: data.sfgov.org

80 rows where qSpecies = 54

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
242 100244 Property Tree 5 Persea americana :: Avocado 54 71 Sanchez St   Back Yard : Yard 6 Tree 1 Private 2         Interior courtyard 6003507.0 2107903.0 37.7680982797144 -122.431162830878 (37.7680982797144, -122.431162830878) 7 9 5 28862 3
4671 105285 Undocumented 3 Persea americana :: Avocado 54 1055 Ashbury St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     22 3x3   5998993.5 2106394.4 37.763699240068796 -122.44666593484399 (37.7636992400688, -122.446665934844) 15 5 11 29492 9
7509 108625 Property Tree 5 Persea americana :: Avocado 54 100 GENEBERN WAY 1 Front Yard : Yard 4 Tree 1 Private 2     12     6004991.8 2095242.4 37.7334192343039 -122.42512609869301 (37.7334192343039, -122.425126098693) 2 7 7 28861 2
8314 109414 Significant Tree 4 Persea americana :: Avocado 54 4 GUY PL 1 Front Yard : Yard 4 Tree 1 Private 2     14     6014378.1 2114502.6 37.786829336844605 -122.394022608955 (37.7868293368446, -122.394022608955) 6 2 9 28855 6
16943 119277 Undocumented 3 Persea americana :: Avocado 54 20 Granada Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5995666.0 2090047.0 37.7186226756846 -122.45699214816901 (37.7186226756846, -122.456992148169) 9 8 6 28861 24
16944 119278 Undocumented 3 Persea americana :: Avocado 54 20 Granada Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5995666.0 2090047.0 37.7186226756846 -122.45699214816901 (37.7186226756846, -122.456992148169) 9 8 6 28861 24
18213 120799 DPW Maintained 1 Persea americana :: Avocado 54 4400 Fulton St 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     17 Width 5ft   5989706.316769999 2109943.60327 37.77290950024229 -122.479046692921 (37.7729095002423, -122.479046692921) 11 6 2 55 26
30167 132060 DPW Maintained 1 Persea americana :: Avocado 54 2830 Filbert St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     17 Width 5ft   5999380.69747 2118432.66555 37.796775320567 -122.44619273972 (37.796775320567, -122.44619273972) 13 9 1 57 17
30168 132061 DPW Maintained 1 Persea americana :: Avocado 54 15 Marion Pl 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     8     6008345.931469999 2119358.10738 37.7998242642284 -122.415236412952 (37.7998242642284, -122.415236412952) 5 1 10 308 32
30169 132062 DPW Maintained 1 Persea americana :: Avocado 54 2800 Van Ness Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     4 Width 8ft   6005724.41535 2120015.0914 37.801480496195204 -122.424354598679 (37.8014804961952, -122.424354598679) 5 9 1 28858 32
30170 132063 DPW Maintained 1 Persea americana :: Avocado 54 45 Havens St 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     13     6007652.149019999 2119387.88526 37.7998670117008 -122.41763927645201 (37.7998670117008, -122.417639276452) 5 1 1 28858 32
30171 132064 DPW Maintained 1 Persea americana :: Avocado 54 92 MacOndray Ln 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     10     6008105.09756 2119109.3067400004 37.7991275819391 -122.416052161003 (37.7991275819391, -122.416052161003) 5 1 10 308 32
31806 13357 DPW Maintained 1 Persea americana :: Avocado 54 638 Mansell St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3X3   6010007.916563099 2090278.8375457001 37.720072423142796 -122.40743408153799 (37.7200724231428, -122.407434081538) 10 3 7 309 28
41770 143117 DPW Maintained 1 Persea americana :: Avocado 54 1689 Lombard St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 Width 0ft   6004350.9426 2119740.536 37.800648985425404 -122.42908784498998 (37.8006489854254, -122.42908784499) 13 9 1 57 17
42670 1475 Permitted Site 2 Persea americana :: Avocado 54 237 Arguello Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3X3   5995488.21536 2114688.25731 37.7862711314145 -122.45939022597 (37.7862711314145, -122.45939022597) 11 6 1 54 11
49291 178074 DPW Maintained 1 Persea americana :: Avocado 54 200 Rome St 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3 Width 0ft   5998626.69263 2088877.91153 37.7155822032235 -122.446674208866 (37.7155822032235, -122.446674208866) 9 7 6 28861 25
49292 178075 DPW Maintained 1 Persea americana :: Avocado 54 200 Rome St 6 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 0ft   5998616.5971 2088867.6940000001 37.715553571525895 -122.44670836870199 (37.7155535715259, -122.446708368702) 9 7 6 28861 25
49293 178076 DPW Maintained 1 Persea americana :: Avocado 54 184 Mount Vernon Ave 10 Side Yard : Yard 27 Tree 1 Private 2     12     5998937.21643 2089402.34913 37.7170399224441 -122.44563859365401 (37.7170399224441, -122.445638593654) 9 7 6 28861 25
49294 178077 DPW Maintained 1 Persea americana :: Avocado 54 1551 San Jose Ave 1 Side Yard : Yard 27 Tree 1 Private 2     7 Width 3ft   6001736.5287 2094206.7555099998 37.7303911613047 -122.43630637554399 (37.7303911613047, -122.436306375544) 9 7 6 28861 25
49295 178078 DPW Maintained 1 Persea americana :: Avocado 54 230 Rhine St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     5 Width 6ft   5994079.51921 2086287.10063 37.7082076509257 -122.46220339079399 (37.7082076509257, -122.462203390794)   8   28588  
49296 178079 DPW Maintained 1 Persea americana :: Avocado 54 70 La Grande Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 2ft   6005235.97843 2091865.3286 37.7241603326208 -122.424041830676 (37.7241603326208, -122.424041830676) 9 7 6 28861 5
49298 178080 DPW Maintained 1 Persea americana :: Avocado 54 202 University St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 Width 4ft   6008024.94769 2092933.54254 37.727250488618296 -122.41447630233999 (37.7272504886183, -122.41447630234) 9 3 7 309 28
49299 178081 DPW Maintained 1 Persea americana :: Avocado 54 913 Silliman St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 3ft   6008142.94596 2093501.2151799998 37.728815824271 -122.414108525499 (37.728815824271, -122.414108525499) 9 3 7 309 28
52718 181825 DPW Maintained 1 Persea americana :: Avocado 54 2306 33rd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 0ft   5986109.1541 2099495.1904 37.7440114838474 -122.49072061796801 (37.7440114838474, -122.490720617968) 1 8 3 29491 35
65933 194258 DPW Maintained 1 Persea americana :: Avocado 54 1270 Indiana St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 3ft   6015024.42192 2102663.2368 37.7543569580196 -122.390958689992 (37.7543569580196, -122.390958689992) 10 3 8 28856 29
65934 194259 DPW Maintained 1 Persea americana :: Avocado 54 1310 Indiana St 22 : Yard 25 Tree 1 Private 2     1     6014914.86206 2102424.38068 37.753695030018 -122.391320882968 (37.753695030018, -122.391320882968) 10 3 8 28856 29
65936 194260 DPW Maintained 1 Persea americana :: Avocado 54 1310 Indiana St 24 : Yard 25 Tree 1 Private 2     1     6014928.75103 2102386.78077 37.7535925594679 -122.391270223251 (37.7535925594679, -122.391270223251) 10 3 8 28856 29
65937 194261 DPW Maintained 1 Persea americana :: Avocado 54 651 Indiana St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     4 Width 8ft   6014939.02651 2105368.68341 37.7617807949616 -122.39144313498899 (37.7617807949616, -122.391443134989) 10 3 8 28856 29
65938 194262 DPW Maintained 1 Persea americana :: Avocado 54 599 Indiana St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     1 Width 8ft   6014908.4103 2105804.70057 37.76297630423711 -122.39157950999599 (37.7629763042371, -122.391579509996) 14 3 8 28856 29
65939 194263 DPW Maintained 1 Persea americana :: Avocado 54 800 19th St 20 Sidewalk: Property side : Yard 5 Tree 1 Private 2     1 Width 10ft   6014959.8650400005 2105335.6122 37.761691145141896 -122.39136875027 (37.7616911451419, -122.39136875027) 10 3 8 28856 29
65940 194264 DPW Maintained 1 Persea americana :: Avocado 54 128 Texas St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 4ft   6013683.86946 2106397.49876 37.7645359516861 -122.395856347502 (37.7645359516861, -122.395856347502) 14 3 8 28856 29
65941 194265 DPW Maintained 1 Persea americana :: Avocado 54 2045 19th St 2 Side Yard : Yard 27 Tree 1 Private 2     7 Width 5ft   6011630.99539 2105089.40534 37.760829800588205 -122.40286471653299 (37.7608298005882, -122.402864716533) 10 3 8 28856 29
65942 194266 DPW Maintained 1 Persea americana :: Avocado 54 608 Texas St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     19 Width 4ft   6013796.40708 2104277.77726 37.75872192008671 -122.395318605083 (37.7587219200867, -122.395318605083) 10 3 8 28856 29
65943 194267 DPW Maintained 1 Persea americana :: Avocado 54 91 Charter Oak Ave 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     5 Width 9ft   6010928.668190001 2096415.01821 37.7369725871245 -122.404683089975 (37.7369725871245, -122.404683089975) 10 3 8 58 1
65944 194268 Undocumented 3 Persea americana :: Avocado 54 900 Quint St 3 Side Yard : Yard 27 Tree 1 Private 2     7 Width 3ft   6014100.1568599995 2097559.70841 37.7402924173605 -122.393797854205 (37.7402924173605, -122.393797854205) 10 3 8 58 1
65945 194269 DPW Maintained 1 Persea americana :: Avocado 54 44 Maddux Ave 2 : 14 Tree 1 Private 2     2 Width 3ft   6012736.16954 2095503.0804599999 37.734569453803104 -122.39836974218399 (37.7345694538031, -122.398369742184) 10 3 8 58 1
65947 194270 DPW Maintained 1 Persea americana :: Avocado 54 311 Townsend St 8 Sidewalk: Property side : Yard 5 Tree 1 Private 2     15 Width 3ft   6013353.50351 2110262.5660900003 37.775130177638005 -122.39727005749201 (37.775130177638, -122.397270057492) 14 2 9 28856 20
65948 194271 DPW Maintained 1 Persea americana :: Avocado 54 981 Le Conte Ave 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     7     6013188.13717 2089502.23425 37.7181175161869 -122.396386656119 (37.7181175161869, -122.396386656119) 10 3 8 58 1
71153 199689 DPW Maintained 1 Persea americana :: Avocado 54 2000 Jennings St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 0ft   6015575.7202 2092859.8959 37.727469569700105 -122.38836795731599 (37.7274695697001, -122.388367957316) 10 3 8 58 1
71451 199960 DPW Maintained 1 Persea americana :: Avocado 54 1250 Griffith St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 0ft   6017933.4982 2092697.8939 37.7271551121655 -122.380205768947 (37.7271551121655, -122.380205768947) 10 3 8 58 1
73591 202041 DPW Maintained 1 Persea americana :: Avocado 54 98 Exeter St 2 : 14 Tree 1 Private 2     6 Width 1ft   6012452.09567 2090741.6437900001 37.7214796982207 -122.39901779634899 (37.7214796982207, -122.399017796349) 10 3 8 58 1
82626 210893 DPW Maintained 1 Persea americana :: Avocado 54 20 Granada Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     16 Width 3ft   5995639.59833 2090031.7237900002 37.718579214642 -122.457082303022 (37.718579214642, -122.457082303022) 9 8 6 28861 24
82627 210894 DPW Maintained 1 Persea americana :: Avocado 54 20 Granada Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     19 Width 3ft   5995638.85534 2090053.8198099998 37.71863984242339 -122.457086468664 (37.7186398424234, -122.457086468664) 9 8 6 28861 24
82628 210895 DPW Maintained 1 Persea americana :: Avocado 54 178 Tara St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9 Width 6ft   5997929.2878 2090647.6250900002 37.720401564862705 -122.449212166725 (37.7204015648627, -122.449212166725) 9 8 6 28861 24
82629 210896 DPW Maintained 1 Persea americana :: Avocado 54 475 Dewey Blvd 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     2 Width 3ft   5994825.964319999 2100056.8652 37.7460590438856 -122.460620765639 (37.7460590438856, -122.460620765639) 1 8 4 59 40
82630 210897 DPW Maintained 1 Persea americana :: Avocado 54 188 Marietta Dr 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     8 Width 3ft   5998834.07718 2097829.51554 37.740173059348 -122.44660106611 (37.740173059348, -122.44660106611) 9 7 4 59 40
82631 210898 DPW Maintained 1 Persea americana :: Avocado 54 714 Detroit St 4 Side Yard : Yard 27 Tree 1 Private 2     6     5999457.20499 2095395.4919200002 37.7335253804911 -122.44427168171002 (37.7335253804911, -122.44427168171) 9 7 4 63 40
82632 210899 DPW Maintained 1 Persea americana :: Avocado 54 91 Melrose Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     10 Width 4ft   5999501.5563199995 2095473.78302 37.7337428797134 -122.444123970747 (37.7337428797134, -122.444123970747) 9 7 4 63 40
82635 210900 DPW Maintained 1 Persea americana :: Avocado 54 326 Detroit St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     6 Width 7ft   5999451.3137300005 2094274.71088 37.7304476423273 -122.44421153863199 (37.7304476423273, -122.444211538632) 9 7 4 63 40
82636 210901 DPW Maintained 1 Persea americana :: Avocado 54 326 Detroit St 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     2 Width 7ft   5999451.91396 2094291.3923099998 37.7304934798799 -122.44421066181101 (37.7304934798799, -122.444210661811) 9 7 4 63 40
105780 233912 DPW Maintained 1 Persea americana :: Avocado 54 2801 Mariposa St 2 : 14 Tree 1 Private 2     3 Width 3ft   6009119.387159999 2105891.31096 37.7628910880777 -122.411607947957 (37.7628910880777, -122.411607947957) 8 4 7 28859 19
105781 233913 DPW Maintained 1 Persea americana :: Avocado 54 2801 Mariposa St 4 : 14 Tree 1 Private 2     4 Width 3ft   6009155.31558 2105892.6302799997 37.7628967259343 -122.411483776778 (37.7628967259343, -122.411483776778) 8 4 7 28859 19
105782 233914 DPW Maintained 1 Persea americana :: Avocado 54 1100 San Jose Ave 57 Sidewalk: Property side : Yard 5 Tree 1 Private 2     9     6004613.07877 2096547.0336799999 37.7369800631845 -122.42652831044201 (37.7369800631845, -122.426528310442) 2 7 5 63 7
105783 233915 DPW Maintained 1 Persea americana :: Avocado 54 998 York St 9 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     1 Width 7ft   6009943.01185 2103432.65253 37.756186332856295 -122.408585854469 (37.7561863328563, -122.408585854469) 2 4 7 28859 19
105784 233916 DPW Maintained 1 Persea americana :: Avocado 54 3178 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 3ft   6008600.98611 2100616.94315 37.74837977590521 -122.41302797028798 (37.7483797759052, -122.413027970288) 2 4 7 28859 19
105785 233917 Significant Tree 4 Persea americana :: Avocado 54 1011 South Van Ness Ave 1 Front Yard : Yard 4 Tree 1 Private 2     21 Width 3ft   6007639.59401 2103741.6760299997 37.756905567467 -122.416573768674 (37.756905567467, -122.416573768674) 2 4 7 28859 19
105786 233918 DPW Maintained 1 Persea americana :: Avocado 54 60 Murray St 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     17 Width 8ft   6004967.71802 2095266.36658 37.7334836807325 -122.425211061736 (37.7334836807325, -122.425211061736) 2 7 7 28861 2
105787 233919 DPW Maintained 1 Persea americana :: Avocado 54 60 Murray St 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     16 Width 8ft   6004972.9428199995 2095265.2139299999 37.7334808109789 -122.42519291611299 (37.7334808109789, -122.425192916113) 2 7 7 28861 2
105789 233920 DPW Maintained 1 Persea americana :: Avocado 54 1816 Castro St 5 Sidewalk: Property side : Yard 5 Tree 1 Private 2     25     6002583.4958 2100252.3284 37.7470389955649 -122.433810234375 (37.7470389955649, -122.433810234375) 2 7 5 63 22
105790 233921 DPW Maintained 1 Persea americana :: Avocado 54 4110 22nd St 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2     14 Width 2ft   6001448.62339 2102939.09436 37.754351748249604 -122.437926932283 (37.7543517482496, -122.437926932283) 2 4 5 28862 22
105791 233922 DPW Maintained 1 Persea americana :: Avocado 54 1 Harlow St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 Width 1ft   6003978.847019999 2106451.05276 37.7641383101589 -122.42942720671302 (37.7641383101589, -122.429427206713) 8 4 5 28862 3
105792 233923 DPW Maintained 1 Persea americana :: Avocado 54 20 Ohlone Way 1 Back Yard : Yard 6 Tree 1 Private 2     4 Width 2ft   6002185.25785 2096400.06868 37.736438982481395 -122.43491185351299 (37.7364389824814, -122.434911853513) 2 7 5 63 7
116403 244945 DPW Maintained 1 Persea americana :: Avocado 54 301 Fell St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     16 Width 0ft   6005884.7273 2110672.5554 37.775837267046 -122.42313539650499 (37.775837267046, -122.423135396505) 7 9 11 28852 10
118285 246695 DPW Maintained 1 Persea americana :: Avocado 54 1 Bonview St 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     1     6007634.96405 2098994.37065 37.7438702793061 -122.41625355785801 (37.7438702793061, -122.416253557858) 2 7 7 28859 2
118286 246696 DPW Maintained 1 Persea americana :: Avocado 54 1 Bonview St 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     1     6007645.436000001 2099008.4718400002 37.7439095868695 -122.4162183467 (37.7439095868695, -122.4162183467) 2 7 7 28859 2
119745 248086 DPW Maintained 1 Persea americana :: Avocado 54 64 Peralta Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     16 Width 8ft   6010586.08965 2100411.89734 37.747928000597796 -122.406149049637 (37.7479280005978, -122.406149049637) 2 7 7 28859 2
119883 248211 DPW Maintained 1 Persea americana :: Avocado 54 67 Fair Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     10 Width 6ft   6007036.37972 2099436.77793 37.745051353528794 -122.418354689821 (37.7450513535288, -122.418354689821) 2 7 7 28859 2
122854 251383 DPW Maintained 1 Persea americana :: Avocado 54 49x Milan Ter 1 Back Yard : Yard 6 Tree 1 Private 2       3x3   5997587.0 2087495.0 37.711725600519706 -122.450168218052 (37.7117256005197, -122.450168218052) 9 7 6 28861 25
125111 255483 Significant Tree 4 Persea americana :: Avocado 54 1295 Hampshire St 1 Front Yard : Yard 4 Tree 1 Private 2       Width 3ft   6010340.83328 2101731.71507 37.7515382084299 -122.407090155993 (37.7515382084299, -122.407090155993) 10 4 7 28859 19
125213 255607 Undocumented 3 Persea americana :: Avocado 54 347 San Carlos St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006753.0 2104097.0 37.7578313031701 -122.419665158689 (37.7578313031701, -122.419665158689) 2 4 7 28859 19
125216 255610 DPW Maintained 1 Persea americana :: Avocado 54 355X San Carlos St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006938.0 2104061.0 37.757742874896294 -122.419022796788 (37.7577428748963, -122.419022796788) 2 4 7 28859 19
125615 256285 Significant Tree 4 Persea americana :: Avocado 54 155x Caledonia St 1 Back Yard : Yard 6 Tree 1 Private 2       3x3   6006400.0 2106945.0 37.765631353558 -122.421088199968 (37.765631353558, -122.421088199968) 8 4 7 28853 19
125868 256624 DPW Maintained 1 Persea americana :: Avocado 54 2 Fallon Pl 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           6008936.0 2118597.0 37.7977675960784 -122.413140700683 (37.7977675960784, -122.413140700683) 3 1 10 308 21
125869 256625 DPW Maintained 1 Persea americana :: Avocado 54 2 Fallon Pl 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           6008936.0 2118597.0 37.7977675960784 -122.413140700683 (37.7977675960784, -122.413140700683) 3 1 10 308 21
125870 256626 DPW Maintained 1 Persea americana :: Avocado 54 2 Fallon Pl 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           6008936.0 2118597.0 37.7977675960784 -122.413140700683 (37.7977675960784, -122.413140700683) 3 1 10 308 21
130890 30350 DPW Maintained 1 Persea americana :: Avocado 54 440 Arkansas St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/16/1956 12:00:00 AM 20   Permit Number 33 6012926.23946 2104997.75127 37.7606503768407 -122.398378580732 (37.7606503768407, -122.398378580732) 10 3 8 28856 29
134079 33311 DPW Maintained 1 Persea americana :: Avocado 54 1550 Filbert St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/03/2000 12:00:00 AM 12   Permit Number 42771 6005499.96948 2119274.08442 37.799433203944105 -122.42507852865 (37.7994332039441, -122.42507852865) 13 9 1 57 17
148663 46781 DPW Maintained 1 Persea americana :: Avocado 54 62 Theresa St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 04/25/2002 12:00:00 AM 6   Permit Number 44872 6002499.29216 2093456.84356 37.728375383117296 -122.43361582430799 (37.7283753831173, -122.433615824308) 9 7 6 28861 25
172491 6907 Permitted Site 2 Persea americana :: Avocado 54 333 Fell St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 3X3   6005876.1749599995 2110669.2938900003 37.7758278290987 -122.423164749384 (37.7758278290987, -122.423164749384) 7 9 11 28852 10
186449 946 DPW Maintained 1 Persea americana :: Avocado 54 1430 Alemany Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     30 3X3   6002284.93229 2093705.0831099998 37.729044827466 -122.43437461616699 (37.729044827466, -122.434374616167) 9 7 6 28861 25

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" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 24.847ms · Data source: data.sfgov.org