1,098 rows where qCaretaker_id = 4 sorted by PermitNotes 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)
49986 96493 DPW Maintained 1 Tree(s) :: 17 2500X Harrison St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/24/2014 12:00:00 AM 3 5x5 Permit Number 774006 6008744 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409) 2 4 7 28859 19
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
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
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
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
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
165116 99363 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 17 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3 Permit Number 773617 5986845.56233 2112796.17507 37.7805753084335 -122.489152009534 (37.7805753084335, -122.489152009534) 11 6 2 55 26
133386 98658 DPW Maintained 1 Tree(s) :: 17 2110 Greenwich St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 06/20/2014 12:00:00 AM   6x6 Permit Number 772915 6002683.8 2119245.6 37.7991955081761 -122.434821422435 (37.7991955081761, -122.434821422435) 13 9 1 57 17
91388 105784 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 1570 31ST AVE 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   04/18/2014 12:00:00 AM     Permit Number 772914 5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
11856 107887 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 941 Washington St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
171481 107886 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 941 Washington St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
23622 99684 DPW Maintained 1 Tree(s) :: 17 165 Grattan St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/04/2013 12:00:00 AM 8 3x3 Permit Number 770537 5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
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
56802 99677 DPW Maintained 1 Tree(s) :: 17 1250X Shrader St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/04/2013 12:00:00 AM 16 3x3 Permit Number 770537 5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
67135 99683 DPW Maintained 1 Tree(s) :: 17 165 Grattan St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/04/2013 12:00:00 AM 8 3x3 Permit Number 770537 5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
37736 101041 Significant Tree 6 Tree(s) :: 17 3750 18th St 1 Front Yard : Yard Tree SFUSD 4   03/15/2012 12:00:00 AM 30   Permit Number 769376 6005230 2105481 37.7615455321967 -122.425030802687 (37.7615455321967, -122.425030802687) 8 4 5 28859 19
58584 57790 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 950 Clay St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 02/08/1977 12:00:00 AM 15 4x4 Permit Number 768771 6010215.62504 2117204.00661 37.7940145286904 -122.408614505968 (37.7940145286904, -122.408614505968) 3 1 10 28857 4
84271 98794 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 950@Washington Clay St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3 Permit Number 768771 6010160.7 2117472.9 37.7947497683853 -122.408823532788 (37.7947497683853, -122.408823532788) 3 1 10 28857 4
104181 98790 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 950x CLAY ST 5 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
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
121110 98804 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950x Clay St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010297.35863 2117215.00262 37.7940492982967 -122.408332474088 (37.7940492982967, -122.408332474088) 3 1 10 28857 4
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
157895 98793 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 950x CLAY ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x6 Permit Number 768771 6010160 2117472 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367) 3 1 10 28857 4
169090 98805 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950x Clay St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/16/2012 12:00:00 AM 1 3x3 Permit Number 768771 6010143.10639 2117195.10642 37.793986029186 -122.408864800763 (37.793986029186, -122.408864800763) 3 1 10 28857 4
170083 98803 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950x Clay St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/16/2012 12:00:00 AM   3x3 Permit Number 768771 6010160.7 2117472.9 37.7947497683853 -122.408823532788 (37.7947497683853, -122.408823532788) 3 1 10 28857 4
179485 98802 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950x CLAY ST 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/16/2012 12:00:00 AM   3x3 Permit Number 768771 6010160 2117472 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367) 3 1 10 28857 4
188988 98791 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950 Clay St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   1 3x6 Permit Number 768771 6010164.1906 2117196.54488 37.7939911598214 -122.408791948484 (37.7939911598214, -122.408791948484) 3 1 10 28857 4
7701 97237 Property Tree 8 Olea europaea :: Olive Tree 9 125 Excelsior Ave   Sidewalk: Property side : Yard Tree SFUSD 4 FUF 09/07/2011 12:00:00 AM     Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 9 7 6 28861 5
21821 97236 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 125 Excelsior Ave   Sidewalk: Property side : Yard Tree SFUSD 4 FUF 09/07/2011 12:00:00 AM     Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 9 7 6 28861 5
106561 97238 Property Tree 8 Olea europaea :: Olive Tree 9 125 Excelsior Ave 1 Sidewalk: Property side : Yard Tree SFUSD 4 FUF 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 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
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
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
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
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
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
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
50118 95752 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 03:47:00 PM 3 3x3 Permit Number 767495 6003490.3309 2092321.64943 37.7253145756058 -122.430108809186 (37.7253145756058, -122.430108809186) 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
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
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
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
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
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
145588 95750 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003564.18987 2092436.84432 37.7256350580097 -122.429861698861 (37.7256350580097, -122.429861698861) 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
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
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
183530 95751 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:36:00 PM 3 3x3 Permit Number 767495 6003552.81378 2092420.08444 37.7255883948789 -122.429899830124 (37.7255883948789, -122.429899830124) 9 7 6 28861 5
98248 94927 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 325 Sanchez St   Sidewalk: Curb side : Cutout Tree SFUSD 4   12/07/2010 12:00:00 AM   3x3 Permit Number 53976 6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
82714 94895 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
84292 94894 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
132285 94893 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
167565 94892 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
44433 94516 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1106X Wisconsin St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   08/27/2010 12:00:00 AM 2   Permit Number 53703 6012787.7377 2102360.94736 37.7534025731789 -122.398672553793 (37.7534025731789, -122.398672553793) 10 3 8 28856 29
68245 34754 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 825 Shotwell St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 04/07/2010 12:00:00 AM 5 3x3 Permit Number 53353 6007982.56974873 2103121.8781615 37.7552230267666 -122.415343751113 (37.7552230267666, -122.415343751113) 2 4 7 28859 19
87632 98968 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/16/2015 08:08:00 AM 3 3x3 Permit Number 53353 6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
12599 93632 DPW Maintained 1 Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 151X Palm Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 01/31/2018 12:00:00 AM 3 3x3 Permit Number 53266 5995882.07932 2113403.99303 37.7827675230466 -122.457934595796 (37.7827675230466, -122.457934595796) 11 6 1 54 31
85175 93633 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 151X Palm Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/16/2010 12:00:00 AM 3 3x3 Permit Number 53266 5995881.0393 2113432.55638 37.7828458906338 -122.457940261495 (37.7828458906338, -122.457940261495) 11 6 1 54 31
165305 93105 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 151X Palm Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 02/02/2010 12:00:00 AM 3 3x3 Permit Number 53160 5995888.42271 2113224.45495 37.7822749237882 -122.457899654053 (37.7822749237882, -122.457899654053) 11 6 1 54 31
184091 92963 Permitted Site 7 Tree(s) :: 17 1515 Quintara St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/24/2009 12:00:00 AM   3x3 Permit Number 53121 5988690.8 2100920.9 37.7480765758445 -122.481898390884 (37.7480765758445, -122.481898390884) 1 8 3 29491 35
121060 92961 DPW Maintained 1 Tree(s) :: 17 2051 34th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/24/2009 12:00:00 AM   3x3 Permit Number 53120 5985698.5 2101265.4 37.748848003369 -122.492270870248 (37.748848003369, -122.492270870248) 1 8 3 29491 35
129395 92962 DPW Maintained 1 Tree(s) :: 17 2051 34th Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/24/2009 12:00:00 AM   3x3 Permit Number 53120 5985698.5 2101265.4 37.748848003369 -122.492270870248 (37.748848003369, -122.492270870248) 1 8 3 29491 35
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
71723 79386 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2355 Folsom St 16 Sidewalk: Curb side : Cutout Tree SFUSD 4   10/30/2009 12:00:00 AM     Permit Number 53016 6008491.21757684 2104497.38565881 37.7590284322587 -122.4136819767 (37.7590284322587, -122.4136819767) 2 4 7 28859 19
141407 92806 Permitted Site 7 Tree(s) :: 17 2355 Folsom St 15 Sidewalk: Curb side : Cutout Tree SFUSD 4   10/30/2009 12:00:00 AM     Permit Number 53016 6008199.4 2104720.1 37.7596235634815 -122.414706984191 (37.7596235634815, -122.414706984191) 2 4 7 28859 19
111390 92750 DPW Maintained 1 Myoporum laetum :: Myoporum 62 2049 Grove St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/02/2009 12:00:00 AM 12 3x3 Permit Number 52971 5998090.3691 2110284.0117 37.7743274908907 -122.450069934151 (37.7743274908907, -122.450069934151) 15 5 11 29492 16
111421 51367 DPW Maintained 1 Celtis sinensis :: Chinese Hackberry 153 50 Pomona St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/09/2009 12:00:00 AM 3 3x3 Permit Number 52508 6014166.48709 2094684.74927 37.7324020570933 -122.39336736943 (37.7324020570933, -122.39336736943) 10 3 8 58 1
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
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
152397 78332 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 50 Pomona St 15 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/01/2009 12:00:00 AM 3 3x3 Permit Number 52305 6014106.86245 2094390.75811 37.7315915044312 -122.393552939125 (37.7315915044312, -122.393552939125) 10 3 8 58 1
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
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
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
37719 81999 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1150 Francisco St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/04/2008 12:00:00 AM 5 3x3 Permit Number 50638 6005960.45556 2120727.09731 37.8034488081703 -122.423588442877 (37.8034488081703, -122.423588442877) 5 9 1 28858 32
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
73331 97736 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1150 Francisco St 15 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 01/31/2017 12:02:00 PM 3 3x3 Permit Number 50638 6005674.32361 2120686.81612 37.8033220514443 -122.424575748272 (37.8033220514443, -122.424575748272) 5 9 1 28858 32
76994 82000 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1150 Francisco St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/04/2008 12:00:00 AM 6 3x3 Permit Number 50638 6005983.68719 2120729.63993 37.8034571008393 -122.423508229633 (37.8034571008393, -122.423508229633) 5 9 1 28858 32
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
147715 81997 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1150 Francisco St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/04/2008 12:00:00 AM 5 3x3 Permit Number 50638 6005918.11487 2120722.35908 37.8034334081868 -122.42373462766 (37.8034334081868, -122.42373462766) 5 9 1 28858 32
151130 97735 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1150 Francisco St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/22/2016 02:46:00 PM 3 3x3 Permit Number 50638 6005694.979 2120690.49004 37.8033333055591 -122.424504530974 (37.8033333055591, -122.424504530974) 5 9 1 28858 32
153204 81998 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1150 Francisco St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/04/2008 12:00:00 AM 4 3x3 Permit Number 50638 6005939.39797 2120724.94139 37.8034416999448 -122.42366116025 (37.8034416999448, -122.42366116025) 5 9 1 28858 32
156701 97732 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1150 Francisco St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3 Permit Number 50638 6005757.30775 2120698.05289 37.8033575908394 -122.424289378073 (37.8033575908394, -122.424289378073) 5 9 1 28858 32
173163 97729 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1150 Francisco St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3 Permit Number 50638 6005819.00921 2120706.70735 37.8033848375917 -122.424076473471 (37.8033848375917, -122.424076473471) 5 9 1 28858 32
175602 97728 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1150 Francisco St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3 Permit Number 50638 6005878.13407 2120716.4935 37.8034150458325 -122.423872565669 (37.8034150458325, -122.423872565669) 5 9 1 28858 32
184931 97734 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1150 Francisco St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3 Permit Number 50638 6005715.83773 2120693.51258 37.8033427825912 -122.424432563629 (37.8033427825912, -122.424432563629) 5 9 1 28858 32
188131 97727 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1150 Francisco St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3 Permit Number 50638 6005898.3389 2120719.31411 37.8034239311172 -122.423802846647 (37.8034239311172, -122.423802846647) 5 9 1 28858 32

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