97 rows where DBH = 10 and qCaretaker_id = 4 sorted by qCareAssistant

View and edit SQL

These facets timed out: DBH

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant ▼ PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
56509 95507 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 600X 32nd Ave 13 Sidewalk: Curb side : Cutout Tree SFUSD 4     10 3x3   5985983.58763 2112182.96811 37.7788412674233 -122.492088785464 (37.7788412674233, -122.492088785464) 11 6 2 55 26
80723 142526 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 17 Sidewalk: Curb side : Cutout Tree SFUSD 4     10 Width 0ft   6009810.3798 2121222.957 37.8050268727325 -122.410300597206 (37.8050268727325, -122.410300597206) 3 1 10 308 23
106937 95512 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X 32nd Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4     10 3x3   5985990.17986 2112026.52369 37.7784121011104 -122.492054459017 (37.7784121011104, -122.492054459017) 11 6 2 55 26
152853 95517 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 600X 32nd Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4     10 3x3   5985993.99278 2111923.13747 37.778128454962 -122.492033654936 (37.778128454962, -122.492033654936) 11 6 2 55 26
161839 95485 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 600X 32nd Ave 13 Sidewalk: Curb side : Cutout Tree SFUSD 4     10 3x3   5986006.6183 2111569.83262 37.7771591186395 -122.491963960946 (37.7771591186395, -122.491963960946) 11 6 2 55 26
135797 97066 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1599X Newcomb Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   10 3x3   6015231.1 2095663.5 37.7351486000155 -122.389755060411 (37.7351486000155, -122.389755060411) 10 3 8 58 1
168139 34691 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 3101X Webster St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 07/28/1997 12:00:00 AM 10 3x3 Permit Number 38352 6002820.98316 2119293.45008 37.7993346796145 -122.434350145047 (37.7993346796145, -122.434350145047) 13 9 1 57 17
1121 77643 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1300X Silliman St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 4x4   6006923.44086 2093174.37286 37.7278498138936 -122.418301281799 (37.7278498138936, -122.418301281799) 9 3 7 309 5
1502 77647 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1300X Silliman St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006841.82551 2093150.82877 37.7277805724005 -122.418581759638 (37.7277805724005, -122.418581759638) 9 3 7 309 5
3789 77644 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1300X Silliman St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 4x5   6006907.53511 2093169.55905 37.7278357008551 -122.41835592728 (37.7278357008551, -122.41835592728) 9 3 7 309 5
3976 75213 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 125 Excelsior Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 4x5   6002883.60734 2092451.48886 37.7256367037627 -122.43221546119 (37.7256367037627, -122.43221546119) 9 7 6 28861 5
5484 71815 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 151X Palm Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5995888.68435 2113315.23973 37.7825242096287 -122.45790532062 (37.7825242096287, -122.45790532062) 11 6 1 54 31
7775 77645 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1300X Silliman St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 4x4   6006883.85072 2093162.97754 37.7278162961767 -122.418437338432 (37.7278162961767, -122.418437338432) 9 3 7 309 5
9148 76641 DPW Maintained 1 Olea europaea :: Olive Tree 9 148X Paris St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6002952.72216 2092480.76402 37.7257210052939 -122.43197862653 (37.7257210052939, -122.43197862653) 9 7 6 28861 5
9619 75308 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 125 Excelsior Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 4x5   6002852.68268 2092471.30856 37.7256893707662 -122.43232378004 (37.7256893707662, -122.43232378004) 9 7 6 28861 5
12386 73495 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 250 23rd Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10     5988730.14838 2113498.62278 37.7826138532986 -122.482683898749 (37.7826138532986, -122.482683898749) 11 6 2 55 26
17590 73937 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/07/1990 12:00:00 AM 10 3x3   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
21542 98642 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3500X Fillmore St 21 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6002233.86885 2120387.28696 37.8023047257379 -122.436460093962 (37.8023047257379, -122.436460093962) 13 9 1 57 17
23432 95461 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 601X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5986588.1418 2111391.86812 37.7767044523908 -122.489939222082 (37.7767044523908, -122.489939222082) 11 6 2 55 26
23498 76685 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 163X London St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/1992 12:00:00 AM 10 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
25347 98970 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
28466 98940 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1400X San Bruno Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6011147.5 2101806.3 37.7517881116631 -122.404305836485 (37.7517881116631, -122.404305836485) 10 4 8 28859 19
30370 98969 DPW Maintained 1 Arbutus unedo :: Strawberry Tree 106 825 Shotwell St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
33247 99356 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5986838.12863 2112989.55693 37.781105845983 -122.489191947731 (37.781105845983, -122.489191947731) 11 6 2 55 26
34496 99371 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 25 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5986853.20034 2112633.29686 37.7801285370834 -122.489113608336 (37.7801285370834, -122.489113608336) 11 6 2 55 26
35960 99029 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
39397 99695 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1550X Washington St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6007274.7 2117123.2 37.7936275055362 -122.418784695641 (37.7936275055362, -122.418784695641) 5 1 10 28858 32
40144 40254 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 10 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
40964 99037 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
44884 99367 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 21 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5986848.24353 2112713.43374 37.7803482808136 -122.489136649255 (37.7803482808136, -122.489136649255) 11 6 2 55 26
46230 99035 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
48192 99026 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3 Permit Number 41415 6006571 2102346.4 37.7530143054678 -122.420170352411 (37.7530143054678, -122.420170352411) 2 4 7 28859 19
49808 99350 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5986835.93382 2113116.06056 37.7814530607414 -122.489208844148 (37.7814530607414, -122.489208844148) 11 6 2 55 26
52590 73289 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X GREEN ST 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1999 12:00:00 AM 10 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
52988 99678 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1250X Shrader St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 4x4 Permit Number 770537 5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
54757 97063 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1599X Newcomb Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6015231.1 2095663.5 37.7351486000155 -122.389755060411 (37.7351486000155, -122.389755060411) 10 3 8 58 1
59247 98633 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3500X Fillmore St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6002258.36283 2120214.87059 37.8018327075615 -122.436362986088 (37.8018327075615, -122.436362986088) 13 9 1 57 17
61370 76728 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 10 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
62996 99030 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
66131 99697 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1451 Jackson St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6007296.6569 2117418.12417 37.794438530258 -122.418729647781 (37.794438530258, -122.418729647781) 5 1 10 28858 32
66136 99033 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
68065 98931 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1401X Utah St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6010911 2101810 37.7517850526072 -122.405123950338 (37.7517850526072, -122.405123950338) 10 4 8 28859 19
77291 98936 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2641 25th St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3 Permit Number 48158 6011034 2101686.1 37.7514517258235 -122.404689875871 (37.7514517258235, -122.404689875871) 10 4 8 28859 19
79000 99679 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 165 Grattan St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
79676 75385 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 163X London St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/1992 12:00:00 AM 10 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
81644 110960 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 940 Filbert St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 5x5   6008419.49323 2119686.5094 37.8007301081687 -122.415005118088 (37.8007301081687, -122.415005118088) 5 1 10 308 32
82737 42644 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X GREEN ST 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/26/2000 12:00:00 AM 10 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
83941 98943 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1400X San Bruno Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6011147.5 2101806.3 37.7517881116631 -122.404305836485 (37.7517881116631, -122.404305836485) 10 4 8 28859 19
84632 77991 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 163X London St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 04/01/2000 12:00:00 AM 10 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
86823 95152 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 250 23rd Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10     5988720.65561 2113620.62822 37.7829482935383 -122.482725682965 (37.7829482935383, -122.482725682965) 11 6 2 55 26
90271 98937 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2641 25th St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3 Permit Number 48158 6011051 2101800 37.7517654203601 -122.404639104893 (37.7517654203601, -122.404639104893) 10 4 8 28859 19
91952 98933 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1401X Utah St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6010911 2101810 37.7517850526072 -122.405123950338 (37.7517850526072, -122.405123950338) 10 4 8 28859 19
92010 97064 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1599X Newcomb Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6015231.1 2095663.5 37.7351486000155 -122.389755060411 (37.7351486000155, -122.389755060411) 10 3 8 58 1
92129 98641 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3500X Fillmore St 20 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6002235.03073 2120370.79549 37.8022595105266 -122.436454892273 (37.8022595105266, -122.436454892273) 13 9 1 57 17
94599 76762 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 200X Farallones St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 10 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
95158 97065 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1599X Newcomb Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6015231.1 2095663.5 37.7351486000155 -122.389755060411 (37.7351486000155, -122.389755060411) 10 3 8 58 1
95964 51930 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2641 25th St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/21/2005 12:00:00 AM 10 3x3 Permit Number 48158 6011052.19017876 2101794.26112893 37.7517497291988 -122.404634585115 (37.7517497291988, -122.404634585115) 10 4 8 28859 19
98082 99360 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5986841.26301 2112907.24873 37.7808800340934 -122.489175051323 (37.7808800340934, -122.489175051323) 11 6 2 55 26
98389 99034 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
100312 98971 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
102622 99027 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
103561 42990 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2X Yale St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/05/2000 12:00:00 AM 10 5x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
104016 110959 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 940 Filbert St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 5x5   6008435.02538 2119688.12069 37.8007354051603 -122.414951484348 (37.8007354051603, -122.414951484348) 5 1 10 308 32
105771 99036 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
110301 42989 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2X Yale St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/05/2000 12:00:00 AM 10 5x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
110307 42646 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1600X GREEN ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/26/2000 12:00:00 AM 10 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
111399 98935 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1401X Utah St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6010911 2101810 37.7517850526072 -122.405123950338 (37.7517850526072, -122.405123950338) 10 4 8 28859 19
112087 98638 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3500X Fillmore St 17 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6002513 2120207.2 37.8018261113234 -122.435481274987 (37.8018261113234, -122.435481274987) 13 9 1 57 17
114759 99670 DPW Maintained 1 Tree(s) :: 17 150X Alma St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
117506 47203 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801X Clement St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/2002 12:00:00 AM 10 3x3 Permit Number 45157 5986727.74959 2113216.77029 37.7817232655044 -122.489590512271 (37.7817232655044, -122.489590512271) 11 6 2 55 26
117978 99025 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006571 2102346.4 37.7530143054678 -122.420170352411 (37.7530143054678, -122.420170352411) 2 4 7 28859 19
118273 99694 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1550X Washington St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6007274.7 2117123.2 37.7936275055362 -122.418784695641 (37.7936275055362, -122.418784695641) 5 1 10 28858 32
120765 42988 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2X Yale St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/16/2000 12:00:00 AM 10 4x5 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
127029 99028 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
131177 98630 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3500X Fillmore St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6002266.09398 2120152.58331 37.8016621223571 -122.436331772404 (37.8016621223571, -122.436331772404) 13 9 1 57 17
133673 77636 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2X Yale St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/26/1984 12:00:00 AM 10 4x4   6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
134642 99031 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
135683 77635 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2X Yale St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/26/1984 12:00:00 AM 10 4x4   6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
136557 99365 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 19 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5986845.14154 2112755.50502 37.7804636155038 -122.489150474302 (37.7804636155038, -122.489150474302) 11 6 2 55 26
143111 99364 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 18 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3 Permit Number 773617 5986846.87705 2112774.48123 37.7805158200694 -122.489145865965 (37.7805158200694, -122.489145865965) 11 6 2 55 26
149215 99352 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5986835.92891 2113074.05562 37.7813377268782 -122.489205771916 (37.7813377268782, -122.489205771916) 11 6 2 55 26
149558 73421 Undocumented 4 Pyrus calleryana :: Ornamental Pear 44 450X Banks St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/1994 12:00:00 AM 10 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
149644 95479 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 601X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5986565.4115 2111984.30283 37.7783297825409 -122.490061437893 (37.7783297825409, -122.490061437893) 11 6 2 55 26
149681 98932 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1401X Utah St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6010911 2101810 37.7517850526072 -122.405123950338 (37.7517850526072, -122.405123950338) 10 4 8 28859 19
150203 99348 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5986834.12581 2113156.33503 37.7815635374039 -122.489218060874 (37.7815635374039, -122.489218060874) 11 6 2 55 26
151982 99038 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
154771 98634 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3500X Fillmore St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6002253.74096 2120233.67924 37.8018840885493 -122.436380326794 (37.8018840885493, -122.436380326794) 13 9 1 57 17
156345 72536 DPW Maintained 1 Tree(s) :: 17 1250X Shrader St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/21/1992 12:00:00 AM 10 3x3   5997766.568459 2106397.97443782 37.7636388926021 -122.45090974788 (37.7636388926021, -122.45090974788) 15 5 11 29492 9
160840 74160 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/07/1990 12:00:00 AM 10 3x3   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
165159 98934 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1401X Utah St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6010911 2101810 37.7517850526072 -122.405123950338 (37.7517850526072, -122.405123950338) 10 4 8 28859 19
165853 40251 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 10 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
170036 99040 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
171377 99688 DPW Maintained 1 Tree(s) :: 17 165 Grattan St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
174822 75386 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 163X London St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/1992 12:00:00 AM 10 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
176883 99366 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 20 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5986848.25067 2112734.65735 37.7804065552175 -122.489138185351 (37.7804065552175, -122.489138185351) 11 6 2 55 26
182167 99024 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006571 2102346.4 37.7530143054678 -122.420170352411 (37.7530143054678, -122.420170352411) 2 4 7 28859 19
185623 99257 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 151X Palm Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5995884.63149 2113369.41772 37.7826727350965 -122.457923263549 (37.7826727350965, -122.457923263549) 11 6 1 54 31

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);