1,098 rows where qCaretaker_id = 4 sorted by SiteOrder descending

View and edit SQL

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)
7677 258687 Property Tree 8 Acacia melanoxylon :: Blackwood Acacia 70 100x Whitney Young Cir 9 Sidewalk: Curb side : Yard Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
7682 76663 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 148X Paris St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6002979.0601 2092519.08061 37.725827707182 -122.431890313086 (37.725827707182, -122.431890313086) 9 7 6 28861 5
8555 77658 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6006705.39704 2093310.53877 37.7282114196192 -122.419064719886 (37.7282114196192, -122.419064719886) 9 3 7 309 5
23426 99331 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 450 30th Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5986581.6367 2112796.91447 37.7805619300043 -122.490065095801 (37.7805619300043, -122.490065095801) 11 6 2 55 26
30715 73286 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X GREEN ST 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1999 12:00:00 AM 8 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
36285 95758 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003422.17585 2092210.81209 37.7250063806226 -122.430336510319 (37.7250063806226, -122.430336510319) 9 7 6 28861 5
37151 77198 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 3 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
45783 99671 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 150X Alma St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
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
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
61217 98752 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 540X Eureka St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
63809 99258 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 151X Palm Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   5995889.58772 2113188.82138 37.7821771504315 -122.45789304424 (37.7821771504315, -122.45789304424) 11 6 1 54 31
65057 142547 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301 FRANCISCO ST 9 Sidewalk: Curb side : Cutout Tree SFUSD 4     20 Width 0ft   6009612.5597 2121193.6724 37.8049353736756 -122.410983109438 (37.8049353736756, -122.410983109438) 3 1 10 308 23
66219 100977 DPW Maintained 1 Maytenus boaria :: Mayten 58 450X Chestnut St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3   Permit Number 37341 6009542.7178 2120879.1139 37.8040677578058 -122.411202572075 (37.8040677578058, -122.411202572075) 3 1 10 308 23
72982 42350 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
99360 99687 DPW Maintained 1 Tree(s) :: 17 165 Grattan St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
100065 98885 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   5994871.8 2088553.5 37.7144762388107 -122.459629241673 (37.7144762388107, -122.459629241673) 9 8 6 28861 24
100591 96499 DPW Maintained 1 Washingtonia filifera :: California Fan Palm 176 2500X Harrison St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     5x5   6008744 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409) 2 4 7 28859 19
101654 42639 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 1651 Union St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/2014 12:00:00 AM 8 3x3 Permit Number 42688 6005258.41678 2118846.41372 37.7982452813572 -122.425883928195 (37.7982452813572, -122.425883928195) 13 9 1 57 17
101825 97903 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 375X Precita Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
102172 97726 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 4x4   6005802.2 2120854.7 37.8037902383764 -122.424145173625 (37.8037902383764, -122.424145173625) 5 9 1 28858 32
105467 98620 DPW Maintained 1 Vitex lucens :: Puriri tree 492 2501X Franklin St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6005340.01128 2118634.45898 37.79766791839 -122.42558649364 (37.79766791839, -122.42558649364) 13 9 1 57 17
108397 102154 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 450X Banks St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512) 10 7 7 28859 2
112874 95489 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 600X 32nd Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4     6 3x3   5986007.8525 2111486.56221 37.7769305539658 -122.491953559362 (37.7769305539658, -122.491953559362) 11 6 2 55 26
115408 99355 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   12 3x3   5986839.02344 2113010.76146 37.7811641198035 -122.489190411627 (37.7811641198035, -122.489190411627) 11 6 2 55 26
119161 37821 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 450X Moscow St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003927.90297 2090495.79555 37.7203259570536 -122.428466081444 (37.7203259570536, -122.428466081444) 9 7 6 28861 5
119920 76639 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 163X London St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/1992 12:00:00 AM 8 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
122873 99555 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 200X Henry St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   30 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
123453 95261 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2290X 14th Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
127080 112029 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2101x 22nd Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4   07/23/2015 12:00:00 AM 3 9x9   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
129312 77648 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1300X Silliman St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 01/01/2011 12:00:00 AM 3 3x3   6006817.14742 2093142.98247 37.7277576387802 -122.418666516263 (37.7277576387802, -122.418666516263) 9 3 7 309 5
130000 102029 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
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
132288 97076 DPW Maintained 1 Tree(s) :: 17 1551 Newcomb Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   12 4x4   6015475.3 2095481.7 37.7346629526589 -122.388898077079 (37.7346629526589, -122.388898077079) 10 3 8 58 1
137518 98655 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   6 5x5   6002650.75991 2119226.56813 37.7991413757273 -122.434934390513 (37.7991413757273, -122.434934390513) 13 9 1 57 17
137680 98571 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301X Francisco St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
141010 77633 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2X Yale St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/26/1984 12:00:00 AM 8 3x3   6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
142043 97731 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1150 Francisco St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3 Permit Number 50638 6005778.11415 2120709.05822 37.8033889834786 -122.424218159845 (37.8033889834786, -122.424218159845) 5 9 1 28858 32
143067 122749 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 693 Vermont St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5     6011285.50671 2105214.92948 37.7611551645106 -122.404068449214 (37.7611551645106, -122.404068449214) 10 3 8 28856 29
149298 95153 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 250 23rd Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18     5988721.45224 2113658.22406 37.783051567455 -122.482725682991 (37.783051567455, -122.482725682991) 11 6 2 55 26
151033 225509 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4     22 6x6   6004197.80145 2106206.80833 37.7634800675805 -122.428652494712 (37.7634800675805, -122.428652494712) 8 4 5 28862 3
153795 98792 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 950 Clay St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/16/2012 12:00:00 AM   5x4 Permit Number 768771 6010160.7 2117472.9 37.7947497683853 -122.408823532788 (37.7947497683853, -122.408823532788) 3 1 10 28857 4
161881 42369 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 Foerster St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
169010 102195 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 3999X Folsom St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
171291 76271 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/14/1994 12:00:00 AM 8 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
176902 51363 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014143.51923 2094573.18836 37.7320944574823 -122.393438970749 (37.7320944574823, -122.393438970749) 10 3 8 58 1
177073 95511 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 600X 32nd Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4   02/19/2015 02:32:00 PM 3 3x3   5985988.37339 2112068.78219 37.7785280252799 -122.492063820389 (37.7785280252799, -122.492063820389) 11 6 2 55 26
178733 115972 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4     8 3x3   5986817.4474 2104547.1317 37.7579240985888 -122.488642781125 (37.7579240985888, -122.488642781125) 1 8 3 56 35
180230 96584 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
183365 251680 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
184781 116053 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 650x Kansas St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   11 4x4   6011508.10962 2105241.51829 37.7612406063998 -122.403300427289 (37.7612406063998, -122.403300427289) 10 3 8 28856 29
192694 95270 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2245 Jones St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/23/2016 02:41:00 PM 3     6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
1406 75132 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 148X Paris St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6002992.10347 2092540.72564 37.7258878789975 -122.431846767938 (37.7258878789975, -122.431846767938) 9 7 6 28861 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
5758 262529 Property Tree 8 Pinus pinea :: Italian Stone Pine 63 555 Portola Dr 8 Front Yard : Yard Tree SFUSD 4       10x10   5997546 2099815 37.7455510557903 -122.451197845188 (37.7455510557903, -122.451197845188) 2 7 5 63 7
11170 76785 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1501X 42nd Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   24 3x12   5983097.8243 2104541.5546 37.75769102754 -122.501506182606 (37.75769102754, -122.501506182606) 1 8 3 56 35
12066 258686 Property Tree 8 Acacia melanoxylon :: Blackwood Acacia 70 100x Whitney Young Cir 8 Sidewalk: Curb side : Yard Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
16157 263597 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830x Harrison St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 Private 03/07/2007 12:00:00 AM   3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
17259 77657 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6006712.15653 2093290.62233 37.7281571140509 -122.41903993995 (37.7281571140509, -122.41903993995) 9 3 7 309 5
19907 102028 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
21099 76027 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 6 4x4   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
23905 96578 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
24545 70470 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 450X Banks St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/1994 12:00:00 AM 3 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
30221 95757 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:33:00 PM 3 3x3 Permit Number 767495 6003435.4103 2092233.16774 37.7250685138993 -122.430292354528 (37.7250685138993, -122.430292354528) 9 7 6 28861 5
31112 96772 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1300X Lane St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   2 3x3   6015407.2 2095381.5 37.7343840488548 -122.389126529878 (37.7343840488548, -122.389126529878) 10 3 8 58 1
34106 31711 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1250X Shrader St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/19/1995 12:00:00 AM 6 3x3 Permit Number 35211 5997882.313818 2106467.94501531 37.7638376395234 -122.450514467435 (37.7638376395234, -122.450514467435) 15 5 11 29492 9
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
48885 98651 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2110 Greenwich St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   23 5x5   6002674.17203 2119228.66956 37.7991484749737 -122.434853527066 (37.7991484749737, -122.434853527066) 13 9 1 57 17
58864 116052 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 650x Kansas St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 01/23/2018 12:00:00 AM 3 4x4   6011506.55629 2105277.69862 37.7613398627543 -122.403308344903 (37.7613398627543, -122.403308344903) 10 3 8 28856 29
65139 97730 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1150 Francisco St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3 Permit Number 50638 6005803.34745 2120703.57786 37.8033753605476 -122.424130448959 (37.8033753605476, -122.424130448959) 5 9 1 28858 32
66912 95490 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 600X 32nd Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4     3 3x3   5986007.65609 2111463.21002 37.7768664240251 -122.491952519112 (37.7768664240251, -122.491952519112) 11 6 2 55 26
68707 32729 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 200X Farallones St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 12 3x3 Permit Number 37116 5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
70543 51357 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 50 Pomona St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014147.24137 2094593.61459 37.732150750552 -122.393427531355 (37.732150750552, -122.393427531355) 10 3 8 58 1
71113 42638 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1651 Union St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/22/2016 02:49:00 PM 3 5x5 Permit Number 42688 6005231.45083 2118842.40752 37.7982327574016 -122.425976953174 (37.7982327574016, -122.425976953174) 13 9 1 57 17
71668 142546 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 8 Sidewalk: Curb side : Cutout Tree SFUSD 4   03/26/2016 09:47:00 AM 23 Width 0ft   6009592.8375 2121191.8795 37.8049293448711 -122.411051233847 (37.8049293448711, -122.411051233847) 3 1 10 308 23
75380 46955 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 4 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
77215 99354 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   5986839.80551 2113026.66255 37.7812078253097 -122.489188875507 (37.7812078253097, -122.489188875507) 11 6 2 55 26
83901 97074 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1551 Newcomb Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 08/20/2015 05:52:00 PM 3 4x4   6015475.3 2095481.7 37.7346629526589 -122.388898077079 (37.7346629526589, -122.388898077079) 10 3 8 58 1
84800 97902 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 375X Precita Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
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
87699 76252 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/14/1994 12:00:00 AM 8 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
95651 73287 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X GREEN ST 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1999 12:00:00 AM 8 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
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
102329 91788 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 830X Harrison St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4   03/07/2007 12:00:00 AM 3 3x3   6012494.965717 2112152.388469 37.7802713613915 -122.400372717325 (37.7802713613915, -122.400372717325) 6 2 9 28856 34
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
104954 95260 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2290X 14th Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
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
108541 42349 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
114301 98806 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950x CLAY ST 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3 Permit Number 768771 6010160 2117472 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367) 3 1 10 28857 4
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
115483 99554 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 200X Henry St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   20 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
122926 122750 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 693 Vermont St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   9     6011285.1392 2105241.40164 37.7612278306072 -122.404071583333 (37.7612278306072, -122.404071583333) 10 3 8 28856 29
124180 96506 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2360X Harrison St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
128028 98619 DPW Maintained 1 Vitex lucens :: Puriri tree 492 2501X Franklin St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6005336.89801 2118653.35554 37.7977196276222 -122.425598612003 (37.7977196276222, -122.425598612003) 13 9 1 57 17
128554 30747 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 60 496X Page St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004231.9845 2109799.7949 37.7733474740483 -122.428790423308 (37.7733474740483, -122.428790423308) 7 9 11 28852 10
130673 102193 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 3999X Folsom St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
139610 98609 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2340 Jackson St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   9 3x3   6003008.4 2116877.5 37.7927117414369 -122.433528869724 (37.7927117414369, -122.433528869724) 13 9 1 29490 27
151965 98629 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3500X Fillmore St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 6x6   6002271.75666 2120123.52327 37.8015826528763 -122.436310096028 (37.8015826528763, -122.436310096028) 13 9 1 57 17
152290 115971 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4     4 3x3   5986813.9683 2104572.6448 37.757993947556 -122.488656688385 (37.757993947556, -122.488656688385) 1 8 3 56 35
152503 98570 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/26/2016 09:47:00 AM 3 3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23

Next page

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)
);