141 rows where Zip Codes = 28861 and qCaretaker_id = 4 sorted by qCareAssistant

View and edit SQL

These facets timed out: Zip Codes

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)
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
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
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
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
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
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
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
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
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
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
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
1406 75132 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 148X Paris St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6002992.10347 2092540.72564 37.7258878789975 -122.431846767938 (37.7258878789975, -122.431846767938) 9 7 6 28861 5
3976 75213 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 125 Excelsior Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 4x5   6002883.60734 2092451.48886 37.7256367037627 -122.43221546119 (37.7256367037627, -122.43221546119) 9 7 6 28861 5
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
5378 76652 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 148X Paris St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   6002965.38435 2092499.73249 37.7257738062998 -122.43193620819 (37.7257738062998, -122.43193620819) 9 7 6 28861 5
6227 77210 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 17 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 5 3x3   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
7682 76663 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 148X Paris St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6002979.0601 2092519.08061 37.725827707182 -122.431890313086 (37.725827707182, -122.431890313086) 9 7 6 28861 5
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
9148 76641 DPW Maintained 1 Olea europaea :: Olive Tree 9 148X Paris St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6002952.72216 2092480.76402 37.7257210052939 -122.43197862653 (37.7257210052939, -122.43197862653) 9 7 6 28861 5
9619 75308 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 125 Excelsior Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 4x5   6002852.68268 2092471.30856 37.7256893707662 -122.43232378004 (37.7256893707662, -122.43232378004) 9 7 6 28861 5
9740 75309 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 125 Excelsior Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6002784.56496 2092514.51527 37.7258041440316 -122.432562342276 (37.7258041440316, -122.432562342276) 9 7 6 28861 5
14144 75133 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 125 Excelsior Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   14 4x4   6002899.19862 2092441.61812 37.7256104849218 -122.432160858845 (37.7256104849218, -122.432160858845) 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
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
18509 76705 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 148X Paris St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3   6003030.53484 2092605.75448 37.7260686121528 -122.431718554264 (37.7260686121528, -122.431718554264) 9 7 6 28861 5
23498 76685 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 163X London St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/1992 12:00:00 AM 10 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
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
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
24208 76687 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 163X London St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/1992 12:00:00 AM 8 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
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
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
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
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
37102 77218 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 499X Hearst Ave 22 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 3 6x50   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
37151 77198 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 3 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
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
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
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
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
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
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
50176 99498 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 125 Excelsior Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6002794.02408 2092508.79842 37.7257889832596 -122.432529234659 (37.7257889832596, -122.432529234659) 9 7 6 28861 5
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
58278 75214 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 125 Excelsior Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/1992 12:00:00 AM 14 4x5   6002868.59368 2092460.80856 37.7256614422973 -122.432268027453 (37.7256614422973, -122.432268027453) 9 7 6 28861 5
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
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
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
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
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
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
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
76451 77217 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 21 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 4 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
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
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
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
79676 75385 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 163X London St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/1992 12:00:00 AM 10 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
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
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
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
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
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
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
84632 77991 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 163X London St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 04/01/2000 12:00:00 AM 10 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
89171 77219 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 23 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 4 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
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
90903 77212 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 19 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 4 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
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
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
97377 77990 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 163X London St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 04/01/2000 12:00:00 AM 8 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 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
99306 77204 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 6 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
99818 77211 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 18 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 8 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
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
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
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
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
115123 77207 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 5 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
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
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
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
119920 76639 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 163X London St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/1992 12:00:00 AM 8 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
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
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
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
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
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
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
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

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