261 rows where qCaretaker_id = 8 sorted by rowid 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)
119788 17656 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1000X Phelps St 1 Sidewalk: Curb side : Cutout Tree PUC 8   11/15/1992 12:00:00 AM 6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407) 10 3 8 58 1
119413 11722 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 899X Junipero Serra Blvd 13 Sidewalk: Curb side : Cutout Tree PUC 8     18 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
119183 11700 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 799X Junipero Serra Blvd 32 Sidewalk: Curb side : Cutout Tree PUC 8     18 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
118544 11877 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1501X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8     18 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061) 9 8 4 64 24
118053 12488 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 307 Lake Merced Blvd 33 Sidewalk: Curb side : Cutout Tree PUC 8     24 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
117872 11693 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 10 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
117481 11872 Permitted Site 7 Juglans hindsii :: Walnut: Black (n.calif) 457 1499X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991566.5284818 2087248.8358641 37.7107033285334 -122.470958490818 (37.7107033285334, -122.470958490818) 9 8 4 64 24
117421 12495 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 307 Lake Merced Blvd 40 Sidewalk: Curb side : Cutout Tree PUC 8     18 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
116763 1740 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 111 Bay St 3 Sidewalk: Curb side : Cutout Tree PUC 8     12 5   6010239.3355 2121619.2312 37.8061389791251 -122.408844115422 (37.8061389791251, -122.408844115422) 3 1 10 308 23
116132 11816 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1201X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8     6 3X3   5991184.5559808 2089595.7938425 37.7171254042551 -122.472449649239 (37.7171254042551, -122.472449649239) 9 8 6 64 24
114230 11633 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 499X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991474.53212 2093889.5616418 37.7289318087747 -122.471760091134 (37.7289318087747, -122.471760091134) 9 8 4 59 40
112341 12467 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 12 Sidewalk: Curb side : Cutout Tree PUC 8     6 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
112297 11148 Permitted Site 7 Olea europaea :: Olive Tree 9 2595X Hyde St 4 Sidewalk: Curb side : Cutout Tree PUC 8     40 3X3   6006932.7654086 2121177.816266 37.8047412018915 -122.420255726238 (37.8047412018915, -122.420255726238) 5 1 1 28858 32
112077 253339 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 2019X 24th Ave 1 Sidewalk: Property side : Yard Tree PUC 8       3x3   5988853 2101569 37.7498655183494 -122.481384971136 (37.7498655183494, -122.481384971136) 1 8 3 29491 35
111891 11145 Permitted Site 7 Olea europaea :: Olive Tree 9 2595X Hyde St 1 Sidewalk: Curb side : Cutout Tree PUC 8     36 3X3   6006932.7654086 2121177.816266 37.8047412018915 -122.420255726238 (37.8047412018915, -122.420255726238) 5 1 1 28858 32
111345 12472 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 17 Sidewalk: Curb side : Cutout Tree PUC 8     12 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
110339 87629 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 900X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991221.225523 2091214.465808 37.7215720016004 -122.472440839907 (37.7215720016004, -122.472440839907) 9 8 4 64 40
108007 11876 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1501X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8     12 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061) 9 8 4 64 24
106861 27800 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 799X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8   03/17/2001 12:00:00 AM 12 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
106118 1744 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 111 Bay St 10 Sidewalk: Curb side : Cutout Tree PUC 8     18 5   6010455.5729 2121649.3164 37.8062336952468 -122.408097909479 (37.8062336952468, -122.408097909479) 3 1 10 308 23
105965 1725 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 50X Bay St 7 Sidewalk: Curb side : Cutout Tree PUC 8   12/15/1992 12:00:00 AM 6 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732) 3 1 10 308 23
103141 1756 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 111 Bay St 19 Sidewalk: Curb side : Cutout Tree PUC 8     24 5   6010168.4492363 2121611.1016263 37.8061126865638 -122.409088856241 (37.8061126865638, -122.409088856241) 3 1 10 308 23
103044 116823 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 10 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
102742 11150 Permitted Site 7 Olea europaea :: Olive Tree 9 2595X Hyde St 6 Sidewalk: Curb side : Cutout Tree PUC 8     36 3X3   6006932.7654086 2121177.816266 37.8047412018915 -122.420255726238 (37.8047412018915, -122.420255726238) 5 1 1 28858 32
102121 1739 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 111 Bay St 3 Sidewalk: Curb side : Cutout Tree PUC 8   08/19/2006 12:00:00 AM 3     6010211.1306 2121614.8438 37.8061253525476 -122.408941413862 (37.8061253525476, -122.408941413862) 3 1 10 308 23
101704 87697 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 699X Junipero Serra Blvd 12 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991401.754734 2093132.84952 37.7268498550224 -122.471956555148 (37.7268498550224, -122.471956555148) 9 8 4 59 40
100522 11761 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 999X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991260.9047733 2090529.2081036 37.7196927494004 -122.472253753748 (37.7196927494004, -122.472253753748) 9 8 6 64 24
100357 11657 Permitted Site 7 Fraxinus spp :: Ash Spp 121 699X Junipero Serra Blvd 18 Sidewalk: Curb side : Cutout Tree PUC 8     12 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
100294 11789 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1199X Junipero Serra Blvd 10 Sidewalk: Curb side : Cutout Tree PUC 8     24 3x4   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
99349 11760 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 999X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree PUC 8     24 3x3   5991260.9047733 2090529.2081036 37.7196927494004 -122.472253753748 (37.7196927494004, -122.472253753748) 9 8 6 64 24
99332 1726 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 50X Bay St 8 Sidewalk: Curb side : Cutout Tree PUC 8     12 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732) 3 1 10 308 23
99292 11656 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 699X Junipero Serra Blvd 16 Sidewalk: Curb side : Cutout Tree PUC 8     18 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
98606 87710 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 999X Junipero Serra Blvd 12 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991255.914982 2090529.52698 37.719693336177 -122.47227102474 (37.719693336177, -122.47227102474) 9 8 6 64 24
97083 29837 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1700X Evans Ave 4 Sidewalk: Curb side : Cutout Tree PUC 8   09/11/2006 12:00:00 AM 3 4X4   6015003.68842 2099041.04772 37.7444100379867 -122.390777273371 (37.7444100379867, -122.390777273371) 10 3 8 58 1
96264 12461 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 6 Sidewalk: Curb side : Cutout Tree PUC 8     6 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
95450 24397 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 699X Junipero Serra Blvd 17 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
94628 12468 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 13 Sidewalk: Curb side : Cutout Tree PUC 8     12 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
94550 87703 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 899X Junipero Serra Blvd 6 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991284.231533 2091244.723898 37.7216587293859 -122.472225251777 (37.7216587293859, -122.472225251777) 9 8 4 64 40
94438 11699 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 24 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
94104 1754 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 111 Bay St 17 Sidewalk: Curb side : Cutout Tree PUC 8     12 5   6010168.4492363 2121611.1016263 37.8061126865638 -122.409088856241 (37.8061126865638, -122.409088856241) 3 1 10 308 23
92807 87707 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 999X Junipero Serra Blvd 5 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991255.914982 2090529.52698 37.719693336177 -122.47227102474 (37.719693336177, -122.47227102474) 9 8 6 64 24
92194 24401 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 16 Sidewalk: Curb side : Cutout Tree PUC 8   03/17/2001 12:00:00 AM 12 3X3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
92138 1748 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 111 Bay St 12 Sidewalk: Curb side : Cutout Tree PUC 8     18 5   6010555.2301 2121661.2252 37.8062719732238 -122.407753867308 (37.8062719732238, -122.407753867308) 3 1 10 308 23
91535 1732 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 50X Bay St 14 Sidewalk: Curb side : Cutout Tree PUC 8   08/19/2006 12:00:00 AM 3 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732) 3 1 10 308 23
91312 85425 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 29 Sidewalk: Curb side : Cutout Tree PUC 8     36 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335) 9 8 4 59 40
91152 11692 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 9 Sidewalk: Curb side : Cutout Tree PUC 8     24 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
90664 116825 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 12 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
89514 11634 Permitted Site 7 Fraxinus spp :: Ash Spp 121 499X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8     12 3   5991474.53212 2093889.5616418 37.7289318087747 -122.471760091134 (37.7289318087747, -122.471760091134) 9 8 4 59 40
88015 87706 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 999X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991255.914982 2090529.52698 37.719693336177 -122.47227102474 (37.719693336177, -122.47227102474) 9 8 6 64 24
87342 11143 DPW Maintained 1 Olea europaea :: Olive Tree 9 2553X Hyde St 1 Sidewalk: Curb side : Cutout Tree PUC 8     36 3X3   6006932.12852 2121148.49105 37.804660646435 -122.420255847653 (37.804660646435, -122.420255847653) 5 1 1 28858 32
86803 24393 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 699X Junipero Serra Blvd 6 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
85615 11723 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 899X Junipero Serra Blvd 14 Sidewalk: Curb side : Cutout Tree PUC 8     18 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
85341 11654 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 699X Junipero Serra Blvd 13 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
85016 107866 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 300 ALEMANY BLVD 1 Sidewalk: Property side : Cutout Tree PUC 8     15 3x3   6008820.4 2095497.5 37.7343352217744 -122.411907523711 (37.7343352217744, -122.411907523711) 10 7 7 28859 2
83736 12475 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 20 Sidewalk: Curb side : Cutout Tree PUC 8     12 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
83541 12482 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 27 Sidewalk: Curb side : Cutout Tree PUC 8     12 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
83487 11823 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1299X Junipero Serra Blvd 15 Sidewalk: Curb side : Cutout Tree PUC 8     24 3   5991432.1718154 2088660.0347764 37.7145703669544 -122.471525618465 (37.7145703669544, -122.471525618465) 9 8 6 64 24
83353 24460 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1199X Junipero Serra Blvd 9 Sidewalk: Curb side : Cutout Tree PUC 8   06/22/1995 12:00:00 AM 6 3x3   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
81357 87704 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 899X Junipero Serra Blvd 10 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991284.231533 2091244.723898 37.7216587293859 -122.472225251777 (37.7216587293859, -122.472225251777) 9 8 4 64 40
81049 116820 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 7 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
81034 116831 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 18 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
80444 12496 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 307 Lake Merced Blvd 41 Sidewalk: Curb side : Cutout Tree PUC 8     24 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
79957 12463 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 8 Sidewalk: Curb side : Cutout Tree PUC 8     6 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
79561 11788 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1199X Junipero Serra Blvd 8 Sidewalk: Curb side : Cutout Tree PUC 8     18 3x4   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
79092 24391 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 699X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree PUC 8   06/21/1995 12:00:00 AM 12 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
76918 11791 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1199X Junipero Serra Blvd 14 Sidewalk: Curb side : Cutout Tree PUC 8     30 3x4   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
76902 24461 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1199X Junipero Serra Blvd 7 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
75317 11659 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 699X Junipero Serra Blvd 20 Sidewalk: Curb side : Cutout Tree PUC 8     12 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
74809 24402 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 17 Sidewalk: Curb side : Cutout Tree PUC 8   03/01/2000 12:00:00 AM 6 3X3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
73084 27799 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 23 Sidewalk: Curb side : Cutout Tree PUC 8   03/08/2005 12:00:00 AM 3 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
72539 11655 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 699X Junipero Serra Blvd 15 Sidewalk: Curb side : Cutout Tree PUC 8     12 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
71990 24457 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 999X Junipero Serra Blvd 13 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991260.9047733 2090529.2081036 37.7196927494004 -122.472253753748 (37.7196927494004, -122.472253753748) 9 8 6 64 24
69590 11697 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 21 Sidewalk: Curb side : Cutout Tree PUC 8   06/21/1995 12:00:00 AM 6 3x3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
68289 11690 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 6 Sidewalk: Curb side : Cutout Tree PUC 8     30 3x3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
67784 24399 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 13 Sidewalk: Curb side : Cutout Tree PUC 8   06/15/1995 12:00:00 AM 12 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
66468 87630 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 900X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991221.225523 2091214.465808 37.7215720016004 -122.472440839907 (37.7215720016004, -122.472440839907) 9 8 4 64 40
65884 11698 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 799X Junipero Serra Blvd 19 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
65281 24390 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 501X Junipero Serra Blvd 6 Sidewalk: Curb side : Cutout Tree PUC 8   06/22/1995 12:00:00 AM 6 3   5991485.44871 2094112.76804 37.7295453093597 -122.471738611958 (37.7295453093597, -122.471738611958) 9 8 4 59 40
65090 11694 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 11 Sidewalk: Curb side : Cutout Tree PUC 8     18 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
64783 87702 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 799X Junipero Serra Blvd 28 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335) 9 8 4 59 40
63614 17661 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1000X Phelps St 6 Sidewalk: Curb side : Cutout Tree PUC 8     12 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407) 10 3 8 58 1
63325 87708 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 999X Junipero Serra Blvd 7 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991255.914982 2090529.52698 37.719693336177 -122.47227102474 (37.719693336177, -122.47227102474) 9 8 6 64 24
61669 12456 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 1 Sidewalk: Curb side : Cutout Tree PUC 8     6 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
61387 114840 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2455x HYDE ST   Sidewalk: Curb side : Cutout Tree PUC 8     12 3x3   6006980 2120877 37.8039178984324 -122.420070904619 (37.8039178984324, -122.420070904619) 5 1 1 28858 32
60969 11688 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 5 Sidewalk: Curb side : Cutout Tree PUC 8     36 3x3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
58585 1736 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 50X Bay St 18 Sidewalk: Curb side : Cutout Tree PUC 8     18 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732) 3 1 10 308 23
57984 116822 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 9 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
57719 11785 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1199X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree PUC 8     30 3x3   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
56955 87696 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 699X Junipero Serra Blvd 7 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991401.754734 2093132.84952 37.7268498550224 -122.471956555148 (37.7268498550224, -122.471956555148) 9 8 4 59 40
56325 12483 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 28 Sidewalk: Curb side : Cutout Tree PUC 8     18 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
55364 11774 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1199X Junipero Serra Blvd 19 Sidewalk: Curb side : Cutout Tree PUC 8     18 2x3   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
55084 24459 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1199X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
54579 12458 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8     6 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
53972 116826 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 13 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
53415 254271 Property Tree 8 Pinus radiata :: Monterey Pine 15 1201X Junipero Serra Blvd 1 Side Yard : Yard Tree PUC 8       10x10   5991180 2089593 37.717117469349 -122.472465193375 (37.717117469349, -122.472465193375) 9 8 6 64 24
52940 17658 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1000X Phelps St 3 Sidewalk: Curb side : Cutout Tree PUC 8     6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407) 10 3 8 58 1
52387 24398 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 30 Sidewalk: Curb side : Cutout Tree PUC 8   03/01/2000 12:00:00 AM 12 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
51469 12490 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 307 Lake Merced Blvd 35 Sidewalk: Curb side : Cutout Tree PUC 8     24 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
49919 11696 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 15 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
49681 116977 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 100x CARGO WAY 117 Front Yard : Yard Tree PUC 8 DPW for City Agency         6019010 2097405 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1

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