1,098 rows where qCaretaker_id = 4 sorted by Latitude

View and edit SQL

PlantType

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)
80 260998 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 600X Lake Merced Blvd 1 Sidewalk: Property side : Yard Tree SFUSD 4       10x10                      
148959 108780 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 2055 Sunnydale Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 773821 6006878.58529 2087505.45215 37.7122816418905 -122.418054633195 (37.7122816418905, -122.418054633195) 9 7 8 309 39
131878 112062 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1199 VISITACION AVE 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 08/18/2015 12:00:00 AM   4x4   6009231 2087548 37.7125305915537 -122.409926954579 (37.7125305915537, -122.409926954579) 9 7 8 309 39
154395 112063 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1199 VISITACION AVE 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     4x4   6009231 2087548 37.7125305915537 -122.409926954579 (37.7125305915537, -122.409926954579) 9 7 8 309 39
159171 112058 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1199 VISITACION AVE 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     4x4   6009231 2087548 37.7125305915537 -122.409926954579 (37.7125305915537, -122.409926954579) 9 7 8 309 39
178370 112061 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1199 VISITACION AVE 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     4x4   6009231 2087548 37.7125305915537 -122.409926954579 (37.7125305915537, -122.409926954579) 9 7 8 309 39
180505 112060 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1199 VISITACION AVE 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     4x4   6009231 2087548 37.7125305915537 -122.409926954579 (37.7125305915537, -122.409926954579) 9 7 8 309 39
13279 108789 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1100-1198X Schwerin St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773823 6009097.13658 2087632.54285 37.7127552255458 -122.410395595682 (37.7127552255458, -122.410395595682) 9 7 8 309 39
48321 108786 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1100-1198X Schwerin St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773823 6009097.13658 2087632.54285 37.7127552255458 -122.410395595682 (37.7127552255458, -122.410395595682) 9 7 8 309 39
68022 108785 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1100-1198X Schwerin St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773823 6009097.13658 2087632.54285 37.7127552255458 -122.410395595682 (37.7127552255458, -122.410395595682) 9 7 8 309 39
107282 108787 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1100-1198X Schwerin St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773823 6009097.13658 2087632.54285 37.7127552255458 -122.410395595682 (37.7127552255458, -122.410395595682) 9 7 8 309 39
187308 108788 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1100-1198X Schwerin St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773823 6009097.13658 2087632.54285 37.7127552255458 -122.410395595682 (37.7127552255458, -122.410395595682) 9 7 8 309 39
67548 108784 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2055 Sunnydale Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 773821 6005634.22998 2088024.32377 37.7136362375916 -122.422392346349 (37.7136362375916, -122.422392346349) 9 7 8 309 18
130378 108783 DPW Maintained 1 Arbutus unedo :: Strawberry Tree 106 2055 Sunnydale Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 773821 6005623.18894 2088028.75541 37.7136477830893 -122.422430822919 (37.7136477830893, -122.422430822919) 9 7 8 309 18
185247 108782 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2055 Sunnydale Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 773821 6005606.4158 2088034.4515 37.713662477117 -122.422489201534 (37.713662477117, -122.422489201534) 9 7 8 309 18
163683 108781 DPW Maintained 1 Arbutus unedo :: Strawberry Tree 106 2055 Sunnydale Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 773821 6005591.90568 2088038.18998 37.7136719236049 -122.422539619323 (37.7136719236049, -122.422539619323) 9 7 8 309 18
70634 108779 DPW Maintained 1 Arbutus unedo :: Strawberry Tree 106 2055 Sunnydale Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 773821 6005562.18075 2088048.73923 37.7136992126121 -122.422643108799 (37.7136992126121, -122.422643108799) 9 7 8 309 18
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
62860 32726 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 200X Farallones St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 20 6x9 Permit Number 37116 5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
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
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
119464 76771 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
129428 76768 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
140619 76757 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
174971 76749 DPW Maintained 1 Schinus terebinthifolius :: Brazilian Pepper 93 200X Farallones St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 8 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
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
129766 32725 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.24753 2088599.26436 37.7146106620382 -122.45910563734 (37.7146106620382, -122.45910563734) 9 8 6 28861 24
178848 32728 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.59612 2088615.91363 37.714656397048 -122.459105637326 (37.714656397048, -122.459105637326) 9 8 6 28861 24
190377 32727 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.97569 2088634.0427 37.7147061970204 -122.459105637321 (37.7147061970204, -122.459105637321) 9 8 6 28861 24
18361 173682 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 450x Raymond Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6008515 2088365 37.7147337500707 -122.412459395375 (37.7147337500707, -122.412459395375) 9 7 8 309 18
56734 173683 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 450x Raymond Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6008515 2088365 37.7147337500707 -122.412459395375 (37.7147337500707, -122.412459395375) 9 7 8 309 18
65943 32730 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.58898 2088651.07748 37.7147529482781 -122.459108206688 (37.7147529482781, -122.459108206688) 9 8 6 28861 24
77942 32731 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.91433 2088666.61691 37.7147956345921 -122.459108206687 (37.7147956345921, -122.459108206687) 9 8 6 28861 24
51808 111862 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201x LOBOS ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5994528 2088713 37.7148944123502 -122.460829096166 (37.7148944123502, -122.460829096166) 9 8 6 28861 24
60043 111861 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201x LOBOS ST 3 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5994528 2088713 37.7148944123502 -122.460829096166 (37.7148944123502, -122.460829096166) 9 8 6 28861 24
132862 111863 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201x LOBOS ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5994528 2088713 37.7148944123502 -122.460829096166 (37.7148944123502, -122.460829096166) 9 8 6 28861 24
125839 102115 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1035 Gilman Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3 Permit Number 52469 6015181.7 2089440.8 37.7180595657824 -122.389491420596 (37.7180595657824, -122.389491420596) 10 3 8 58 1
35455 47256 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1035 Gilman Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/09/2002 12:00:00 AM 6 3x3 Permit Number 45198 6015368.10493708 2089617.80548286 37.7185559218928 -122.388859444456 (37.7185559218928, -122.388859444456) 10 3 8 58 1
70173 66890 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1035 Gilman Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/07/2005 12:00:00 AM 6 3x3 Permit Number 45482 6015368.10493708 2089617.80548286 37.7185559218928 -122.388859444456 (37.7185559218928, -122.388859444456) 10 3 8 58 1
72589 47255 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1035 Gilman Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 05/09/2002 12:00:00 AM 6 3x3 Permit Number 45198 6015368.10493708 2089617.80548286 37.7185559218928 -122.388859444456 (37.7185559218928, -122.388859444456) 10 3 8 58 1
194156 47257 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1035 Gilman Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/08/2009 12:00:00 AM 6 3x3 Permit Number 52469 6015368.10493708 2089617.80548286 37.7185559218928 -122.388859444456 (37.7185559218928, -122.388859444456) 10 3 8 58 1
154114 37833 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 20 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003832.66245 2090342.46114 37.7198995444156 -122.428784371324 (37.7198995444156, -122.428784371324) 9 7 6 28861 5
36159 37832 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 19 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 06/22/2006 12:00:00 AM 3 3x3 Permit Number 48867 6003860.1558 2090386.44981 37.7200218836872 -122.42869247048 (37.7200218836872, -122.42869247048) 9 7 6 28861 5
161401 37831 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 18 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003870.23097 2090403.35388 37.7200688687581 -122.428658848427 (37.7200688687581, -122.428658848427) 9 7 6 28861 5
194434 37829 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 450X Moscow St 17 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:54:00 AM 3 3x3 Permit Number 40134 6003878.28183 2090416.42534 37.7201052157501 -122.428631950629 (37.7201052157501, -122.428631950629) 9 7 6 28861 5
163795 37830 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451 Athens St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/09/2007 12:00:00 AM 3 6x6 Permit Number 49480 6003635.85955 2090436.92041 37.7201477680848 -122.429471383195 (37.7201477680848, -122.429471383195) 9 7 6 28861 5
169000 37827 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 450X Moscow St 15 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003888.33038 2090432.03853 37.7201486548235 -122.428598328547 (37.7201486548235, -122.428598328547) 9 7 6 28861 5
194372 37826 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003896.37457 2090444.78719 37.7201841150858 -122.428571430748 (37.7201841150858, -122.428571430748) 9 7 6 28861 5
98004 37838 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451 Athens St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 4x6 Permit Number 40134 6003644.26117 2090451.27602 37.7201876611143 -122.429443364835 (37.7201876611143, -122.429443364835) 9 7 6 28861 5
189866 37825 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 13 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003912.01731 2090448.66207 37.7201956398999 -122.428517635078 (37.7201956398999, -122.428517635078) 9 7 6 28861 5
42544 37824 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 450X Moscow St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003906.75378 2090460.71651 37.7202284408775 -122.428536688136 (37.7202284408775, -122.428536688136) 9 7 6 28861 5
194422 37823 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:49:00 AM 3 3x3 Permit Number 40134 6003922.69393 2090463.29382 37.7202364196636 -122.428481771941 (37.7202364196636, -122.428481771941) 9 7 6 28861 5
27765 37839 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451 Athens St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 4x6 Permit Number 40134 6003658.01474 2090473.5929 37.7202497170415 -122.42939741397 (37.7202497170415, -122.42939741397) 9 7 6 28861 5
76214 37822 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 10 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:46:00 AM 3 3x3 Permit Number 40134 6003933.77466 2090481.79158 37.7202878374987 -122.428444787301 (37.7202878374987, -122.428444787301) 9 7 6 28861 5
181911 37840 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451 Athens St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/09/2007 12:00:00 AM 3 4x6 Permit Number 49480 6003672.4294 2090496.54171 37.7203135455184 -122.429349222898 (37.7203135455184, -122.429349222898) 9 7 6 28861 5
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
176834 37820 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003945.80086 2090498.97809 37.7203357084188 -122.428404441018 (37.7203357084188, -122.428404441018) 9 7 6 28861 5
103631 37819 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 450X Moscow St 7 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003953.55423 2090513.34715 37.7203756014419 -122.428378663762 (37.7203756014419, -122.428378663762) 9 7 6 28861 5
76659 37818 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 450X Moscow St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003946.32629 2090524.47356 37.720405743114 -122.428404441023 (37.720405743114, -122.428404441023) 9 7 6 28861 5
92790 37817 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 5 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003961.27408 2090526.10251 37.7204110616965 -122.428352887393 (37.7204110616965, -122.428352887393) 9 7 6 28861 5
37421 37816 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003955.66683 2090537.19552 37.720441203374 -122.428373060073 (37.720441203374, -122.428373060073) 9 7 6 28861 5
5047 37814 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003977.37565 2090552.2455 37.720483755714 -122.428299091747 (37.720483755714, -122.428299091747) 9 7 6 28861 5
84190 253150 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 3 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:41:00 AM 3 3x3   6003965.72194 2090553.13154 37.7204855291627 -122.428339438009 (37.7204855291627, -122.428339438009) 9 7 6 28861 5
184336 37815 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 2 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003965.72194 2090553.13154 37.7204855291627 -122.428339438009 (37.7204855291627, -122.428339438009) 9 7 6 28861 5
108068 107643 DPW Maintained 1 Tree(s) :: 17 455 ATHENS ST   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF     4x4   6003769 2090659.8 37.7207672837341 -122.429027043999 (37.7207672837341, -122.429027043999) 9 7 6 28861 5
49903 37828 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 15 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/22/2006 12:00:00 AM 8 3x3 Permit Number 48867 6003752 2090699 37.720873955994 -122.429088601305 (37.720873955994, -122.429088601305) 9 7 6 28861 5
80555 37837 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 23 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003752 2090699 37.720873955994 -122.429088601305 (37.720873955994, -122.429088601305) 9 7 6 28861 5
187446 37835 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 21 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003752 2090699 37.720873955994 -122.429088601305 (37.720873955994, -122.429088601305) 9 7 6 28861 5
27100 92958 Permitted Site 7 Tree(s) :: 17 300 Seneca Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
142685 92960 Permitted Site 7 Tree(s) :: 17 300 Seneca Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
180121 92959 Permitted Site 7 Tree(s) :: 17 300 Seneca Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
189331 92957 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 300 Seneca Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
190901 92956 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 300 Seneca Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
6926 96580 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 5 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
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
23915 96577 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 401x Otsego Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM 2 3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
31248 96579 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 4 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
122635 96583 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 401x Otsego Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
128118 96585 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 401x Otsego Ave 10 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
166189 96581 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 6 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
169868 96576 DPW Maintained 1 Quercus coccinea :: Scarlet Oak 134 401x Otsego Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4     4     6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
172028 96582 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 7 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
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
182392 97247 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003399 2092092 37.7246788362927 -122.430408153397 (37.7246788362927, -122.430408153397) 9 7 6 28861 5
90004 97245 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:18:00 PM 3 4x4 Permit Number 767495 6003351.72812 2092154.84242 37.7248487096971 -122.430576048361 (37.7248487096971, -122.430576048361) 9 7 6 28861 5
141169 97246 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:11:00 PM 3 4x4 Permit Number 767495 6003334.6314 2092165.82905 37.7248779079737 -122.430635933307 (37.7248779079737, -122.430635933307) 9 7 6 28861 5
67335 97240 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003400.64895 2092179.59067 37.7249194341684 -122.430408699814 (37.7249194341684, -122.430408699814) 9 7 6 28861 5
163627 253146 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:29:00 PM 3 3x3 Permit Number 767495 6003400.64895 2092179.59067 37.7249194341684 -122.430408699814 (37.7249194341684, -122.430408699814) 9 7 6 28861 5
80956 97248 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003299.02479 2092188.30414 37.7249376022835 -122.430760624301 (37.7249376022835, -122.430760624301) 9 7 6 28861 5
118902 97239 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 03:49:00 PM 3 3x3 Permit Number 767495 6003412.15812 2092196.84002 37.7249674489828 -122.430370144078 (37.7249674489828, -122.430370144078) 9 7 6 28861 5
121431 97249 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003279.34346 2092200.52554 37.7249700444293 -122.430829532173 (37.7249700444293, -122.430829532173) 9 7 6 28861 5
158362 97250 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003264.30376 2092207.68877 37.724988860924 -122.430882033691 (37.724988860924, -122.430882033691) 9 7 6 28861 5
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
49228 97251 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003227.5697 2092233.02297 37.7250563415646 -122.431010826505 (37.7250563415646, -122.431010826505) 9 7 6 28861 5
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
44331 95756 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:16:00 PM 3 3x3 Permit Number 767495 6003442.24703 2092244.67659 37.7251005018853 -122.430269541405 (37.7251005018853, -122.430269541405) 9 7 6 28861 5
30203 95755 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003450.90146 2092257.04406 37.7251349504027 -122.430240505894 (37.7251349504027, -122.430240505894) 9 7 6 28861 5
76622 95754 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003464.56282 2092279.46461 37.7251972860232 -122.43019487879 (37.7251972860232, -122.43019487879) 9 7 6 28861 5
38894 95753 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003478.85461 2092303.36569 37.7252637225375 -122.430147177848 (37.7252637225375, -122.430147177848) 9 7 6 28861 5
7953 97241 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003464 2092306.9 37.7252725856131 -122.430198780788 (37.7252725856131, -122.430198780788) 9 7 6 28861 5

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