261 rows where qCaretaker_id = 8 sorted by SiteOrder 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)
3325 11719 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 9 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
18185 11652 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 699X Junipero Serra Blvd 9 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
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
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
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
140623 1727 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 50X Bay St 9 Sidewalk: Curb side : Cutout Tree PUC 8     6 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732) 3 1 10 308 23
152100 12464 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 9 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
23878 116821 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 111 Bay St 8 Sidewalk: Curb side : Yard Tree PUC 8     14     6010478.7636 2121651.8235 37.806241877556 -122.408017830638 (37.806241877556, -122.408017830638) 3 1 10 308 23
29682 11651 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 699X Junipero Serra Blvd 8 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
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
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
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
134263 11686 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 8 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
139815 11152 Permitted Site 7 Olea europaea :: Olive Tree 9 2595X Hyde St 8 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
159354 87632 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 900X Junipero Serra Blvd 8 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
170407 87709 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 999X Junipero Serra Blvd 8 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
27122 29840 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1700X Evans Ave 7 Sidewalk: Curb side : Cutout Tree PUC 8   09/11/2006 12:00:00 AM 3 4X4   6014944.2776 2099085.41213 37.7445285569526 -122.390985805465 (37.7445285569526, -122.390985805465) 10 3 8 58 1
38711 116976 Undocumented 4 Salix spp :: Willow 203 100x CARGO WAY 7 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
48416 87631 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 900X Junipero Serra Blvd 7 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
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
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
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
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
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
130244 17662 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1000X Phelps St 7 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
152984 11820 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1299X Junipero Serra Blvd 7 Sidewalk: Curb side : Cutout Tree PUC 8     12 3   5991432.1718154 2088660.0347764 37.7145703669544 -122.471525618465 (37.7145703669544, -122.471525618465) 9 8 6 64 24
161832 11151 Permitted Site 7 Olea europaea :: Olive Tree 9 2595X Hyde St 7 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
164371 11691 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 7 Sidewalk: Curb side : Cutout Tree PUC 8   03/17/2001 12:00:00 AM 9 3x3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
166529 11718 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 899X Junipero Serra Blvd 7 Sidewalk: Curb side : Cutout Tree PUC 8     36 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
179845 116832 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2 Midway St 7 Front Yard : Yard Tree PUC 8           6010125.275107 2121295.55695439 37.8052438606833 -122.409215987298 (37.8052438606833, -122.409215987298) 3 1 10 308 23
183869 12462 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 7 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
48230 11762 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 999X Junipero Serra Blvd 6 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
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
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
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
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
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
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
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
144621 1724 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 50X Bay St 6 Sidewalk: Curb side : Cutout Tree PUC 8     6 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732) 3 1 10 308 23
145746 11787 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1199X Junipero Serra Blvd 6 Sidewalk: Curb side : Cutout Tree PUC 8     12 3x4   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
170514 1742 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 111 Bay St 6 Sidewalk: Curb side : Cutout Tree PUC 8     12 5   6010362.8102 2121638.0345 37.8061975236724 -122.408418135849 (37.8061975236724, -122.408418135849) 3 1 10 308 23
173000 116975 Undocumented 4 Salix spp :: Willow 203 100x CARGO WAY 6 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
20881 17660 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1000X Phelps St 5 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
37295 12460 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 5 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
41533 29838 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1700X Evans Ave 5 Sidewalk: Curb side : Cutout Tree PUC 8   09/11/2006 12:00:00 AM 3 4X4   6014986.46906 2099054.93467 37.7444472132656 -122.39083778516 (37.7444472132656, -122.39083778516) 10 3 8 58 1
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
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
133362 116818 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 5 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
139221 1723 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 50X Bay St 5 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
143263 1741 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 111 Bay St 5 Sidewalk: Curb side : Cutout Tree PUC 8     12 5   6010277.5688 2121623.6186 37.8061531673047 -122.408712111835 (37.8061531673047, -122.408712111835) 3 1 10 308 23
156707 11149 Permitted Site 7 Olea europaea :: Olive Tree 9 2595X Hyde St 5 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
174279 11650 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 699X Junipero Serra Blvd 5 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
182237 11819 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1201X Junipero Serra Blvd 5 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
183178 11637 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 499X Junipero Serra Blvd 5 Sidewalk: Curb side : Cutout Tree PUC 8     18 3   5991474.53212 2093889.5616418 37.7289318087747 -122.471760091134 (37.7289318087747, -122.471760091134) 9 8 4 59 40
183477 11717 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 5 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
31631 12498 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 43 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
21901 12497 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 42 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
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
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
6276 11636 Permitted Site 7 Fraxinus spp :: Ash Spp 121 499X Junipero Serra Blvd 4 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
27360 11818 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1201X Junipero Serra Blvd 4 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
35001 116817 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 4 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
35376 24410 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1199X Junipero Serra Blvd 4 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
39758 87698 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 799X Junipero Serra Blvd 4 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
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
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
123225 1722 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 50X Bay St 4 Sidewalk: Curb side : Cutout Tree PUC 8     6 3x9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732) 3 1 10 308 23
131821 12459 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 4 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
153368 11649 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 699X Junipero Serra Blvd 4 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
158167 17659 Permitted Site 7 Liriodendron tulipifera :: Tulip Tree 145 1000X Phelps St 4 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
176701 11878 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1501X Junipero Serra Blvd 4 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
179933 11874 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 1499X Junipero Serra Blvd 4 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
28949 12494 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 307 Lake Merced Blvd 39 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
24518 12493 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 307 Lake Merced Blvd 38 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
18515 12492 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 307 Lake Merced Blvd 37 Sidewalk: Curb side : Cutout Tree PUC 8     36 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
134816 12491 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 36 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
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
168859 12489 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 34 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
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
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
128289 12487 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 32 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
131171 24456 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 31 Sidewalk: Curb side : Cutout Tree PUC 8   06/22/1995 12:00:00 AM 12 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
170244 12486 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 31 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
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
160450 12485 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 30 Sidewalk: Curb side : Cutout Tree PUC 8     36 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
1663 27797 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8   03/17/2001 12:00:00 AM 3 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
21093 11635 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 499X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8     18 3   5991474.53212 2093889.5616418 37.7289318087747 -122.471760091134 (37.7289318087747, -122.471760091134) 9 8 4 59 40
27092 1721 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 50X Bay St 3 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
36728 85667 Permitted Site 7 Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 639 Bryant St 3 Sidewalk: Curb side : Cutout Tree PUC 8   04/23/2007 12:00:00 AM 3 3x3   6012912 2111624 37.7788437746878 -122.398892898465 (37.7788437746878, -122.398892898465) 6 2 9 28856 34
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
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
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
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
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
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
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
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
119872 11873 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 1499X Junipero Serra Blvd 3 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
126974 11648 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 699X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8   01/28/2000 12:00:00 AM 3 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40

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