189 rows where Police Districts = 7 and qCaretaker_id = 4 sorted by TreeID

View and edit SQL

Police Districts

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)
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
78897 102155 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 450X Banks St 10 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
153285 102156 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 450X Banks St 11 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
69126 102186 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3999X Folsom St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
160561 102187 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3999X Folsom St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
33305 102189 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 3999X Folsom St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
52882 102190 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 3999X Folsom St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
103551 102191 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 3999X Folsom St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
183831 102192 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 3999X Folsom St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
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
57109 102194 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 3999X Folsom St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
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
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
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
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
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
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
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
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
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
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
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
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
92761 110187 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 625 Holly Park Cir 3 Sidewalk: Curb side : Cutout Tree SFUSD 4           6006167.62160945 2096413.49051844 37.7367011423593 -122.421144072665 (37.7367011423593, -122.421144072665) 2 7 7 28859 2
91360 110190 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 625 Holly Park Cir 6 Sidewalk: Curb side : Cutout Tree SFUSD 4           6006167.62160945 2096413.49051844 37.7367011423593 -122.421144072665 (37.7367011423593, -122.421144072665) 2 7 7 28859 2
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
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
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
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
68964 113434 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 198x HIGHLAND AVE 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     12 4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
87145 113435 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 198x HIGHLAND AVE 2 Sidewalk: Curb side : Cutout Tree SFUSD 4       4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
51837 113436 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 198x HIGHLAND AVE 3 Sidewalk: Curb side : Cutout Tree SFUSD 4       4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
58400 113437 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 198x HIGHLAND AVE 4 Sidewalk: Curb side : Cutout Tree SFUSD 4       4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
23669 42343 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 2 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
70737 42344 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 380X Flood Ave 3 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 8 8x45 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
72021 42345 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 4 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
162866 42347 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 6 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
15793 42348 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 7 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 3 8x45 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
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
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
130186 42352 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 11 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
82711 42354 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 13 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
55302 42355 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 380X Flood Ave 14 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 9 8x90 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
182513 42356 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 15 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
160859 42357 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 16 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 3 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
180710 42358 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 17 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 4x4 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
81932 42360 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 19 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
144395 42361 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 Foerster St 1 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
147728 42365 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 Foerster St 5 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
82359 42366 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 Foerster St 6 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
154352 42367 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 Foerster St 7 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
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
153384 43310 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 150X Paris St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/04/2008 12:00:00 AM 3 3x3 Permit Number 50666 6002773.36898986 2092525.07870875 37.7258325139415 -122.432601800105 (37.7258325139415, -122.432601800105) 9 7 6 28861 5
123128 43311 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 148X Paris St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/04/2008 12:00:00 AM 6 3x3 Permit Number 50666 6003068.93568 2092663.25214 37.7262286645003 -122.431589908071 (37.7262286645003, -122.431589908071) 9 7 6 28861 5
149448 43312 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 148X Paris St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/04/2008 12:00:00 AM 6 3x3 Permit Number 50666 6003053.84834 2092643.73268 37.7261742132654 -122.431640671199 (37.7261742132654, -122.431640671199) 9 7 6 28861 5
23641 43313 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 148X Paris St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/04/2008 12:00:00 AM 3 3x3 Permit Number 50666 6003041.97819 2092624.14713 37.7261197629015 -122.431680307904 (37.7261197629015, -122.431680307904) 9 7 6 28861 5
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
25379 70471 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 450X Banks St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/1994 12:00:00 AM 32 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
97154 70472 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 450X Banks St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/1994 12:00:00 AM 4 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
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
155971 73874 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 450X Banks St 4 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
46177 73875 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 450X Banks St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/1994 12:00:00 AM 8 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
176008 74108 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 555 Tompkins Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/1994 12:00:00 AM 3 3x3   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
151372 74109 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 555 Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/1994 12:00:00 AM 3 3x3   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
112205 74759 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 250 Foerster St 13 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 30 5x7   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
189005 75040 DPW Maintained 1 Tree(s) :: 17 499X Hearst Ave 2 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 18 6x20   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
7380 75048 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 148X Paris St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6003019.45241 2092585.35122 37.7260119611657 -122.431755409402 (37.7260119611657, -122.431755409402) 9 7 6 28861 5
14855 75049 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 148X Paris St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6003005.92399 2092563.39586 37.7259509097926 -122.431800609333 (37.7259509097926, -122.431800609333) 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)
);