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)
193977 24413 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1199X Junipero Serra Blvd 13 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
193865 26172 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 17 Sidewalk: Curb side : Cutout Tree PUC 8     12 3x3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
193079 12476 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 21 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
192724 116815 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 2 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
192043 12457 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 2 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
191989 116816 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 3 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
189495 12470 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 15 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
189236 1750 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 111 Bay St 14 Sidewalk: Curb side : Cutout Tree PUC 8     18 5   6010626.0557 2121671.8803 37.8063051940875 -122.4075095136 (37.8063051940875, -122.4075095136) 3 1 10 308 23
187882 11147 Permitted Site 7 Olea europaea :: Olive Tree 9 2595X Hyde St 3 Sidewalk: Curb side : Cutout Tree PUC 8     6 3X3   6006932.7654086 2121177.816266 37.8047412018915 -122.420255726238 (37.8047412018915, -122.420255726238) 5 1 1 28858 32
187851 116819 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 111 Bay St 20 Sidewalk: Curb side : Yard Tree PUC 8     11     6010427.9948 2121647.4361 37.8062269882557 -122.408193215955 (37.8062269882557, -122.408193215955) 3 1 10 308 23
187741 29844 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1700X Evans Ave 10 Sidewalk: Curb side : Cutout Tree PUC 8   09/11/2006 12:00:00 AM 3 4X4   6014896.13106 2099120.97008 37.74462351995 -122.3911547728 (37.74462351995, -122.3911547728) 10 3 8 58 1
186993 11824 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1299X Junipero Serra Blvd 14 Sidewalk: Curb side : Yard Tree PUC 8   03/13/2013 12:00:00 AM 2 3   5991432.1718154 2088660.0347764 37.7145703669544 -122.471525618465 (37.7145703669544, -122.471525618465) 9 8 6 64 24
185799 11726 Permitted Site 7 Ulmus americana :: American Elm 74 899X Junipero Serra Blvd 21 Sidewalk: Curb side : Cutout Tree PUC 8   06/15/1995 12:00:00 AM 18 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
184861 11724 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 18 Sidewalk: Curb side : Cutout Tree PUC 8   03/17/2001 12:00:00 AM 12 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
184611 1729 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 50X Bay St 11 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
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
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
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
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
181483 11653 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 699X Junipero Serra Blvd 10 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
181008 1720 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 50X Bay St 2 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
180766 11725 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 899X Junipero Serra Blvd 20 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
180453 116829 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 16 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
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
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
179439 29858 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1700X Evans Ave 13 Sidewalk: Curb side : Cutout Tree PUC 8     12 4X4   6014689.41423 2099276.62431 37.7450394402319 -122.391880446552 (37.7450394402319, -122.391880446552) 10 3 8 58 1
178282 29835 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1700X Evans Ave 2 Sidewalk: Curb side : Cutout Tree PUC 8   09/11/2006 12:00:00 AM 3 4X4   6015037.39009 2099016.77397 37.7443452571283 -122.390659043104 (37.7443452571283, -122.390659043104) 10 3 8 58 1
177266 1749 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 111 Bay St 18 Sidewalk: Curb side : Cutout Tree PUC 8     18 5   6010575.9137 2121665.6126 37.8062851777933 -122.407682597345 (37.8062851777933, -122.407682597345) 3 1 10 308 23
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
176383 11790 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1199X Junipero Serra Blvd 12 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
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
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
170648 27826 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 26 Sidewalk: Curb side : Cutout Tree PUC 8   03/08/2005 12:00:00 AM 3 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
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
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
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
170020 24405 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 999X Junipero Serra Blvd 10 Sidewalk: Curb side : Cutout Tree PUC 8   01/28/2000 12:00:00 AM 12 3X3   5991260.9047733 2090529.2081036 37.7196927494004 -122.472253753748 (37.7196927494004, -122.472253753748) 9 8 6 64 24
169679 12474 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 19 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
167696 11773 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1199X Junipero Serra Blvd 18 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
167632 1730 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 50X Bay St 12 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
166972 1755 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 111 Bay St 18 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
166971 1733 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 50X Bay St 15 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
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
166318 11721 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 899X Junipero Serra Blvd 12 Sidewalk: Curb side : Cutout Tree PUC 8     12 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
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
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
161775 1751 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 111 Bay St 15 Sidewalk: Curb side : Cutout Tree PUC 8     24 5   6010656.7677 2121676.8945 37.8063206808441 -122.407403582579 (37.8063206808441, -122.407403582579) 3 1 10 308 23
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
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
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
157419 85427 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 18 Sidewalk: Curb side : Cutout Tree PUC 8     18 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335) 9 8 4 59 40
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
154418 11144 DPW Maintained 1 Olea europaea :: Olive Tree 9 2553X Hyde St 2 Sidewalk: Curb side : Cutout Tree PUC 8     36 3X3   6006934.8566 2121129.59308 37.8046089111446 -122.420245064768 (37.8046089111446, -122.420245064768) 5 1 1 28858 32
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
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
152891 11815 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1201X Junipero Serra Blvd 1 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
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
152045 12477 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 22 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
150522 24395 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 699X Junipero Serra Blvd 21 Sidewalk: Curb side : Cutout Tree PUC 8   06/22/1995 12:00:00 AM 6 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
149148 116809 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 1 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
148376 11822 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1299X Junipero Serra Blvd 16 Sidewalk: Curb side : Yard Tree PUC 8     10 3   5991432.1718154 2088660.0347764 37.7145703669544 -122.471525618465 (37.7145703669544, -122.471525618465) 9 8 6 64 24
148363 12479 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 24 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
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
145403 1731 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 50X Bay St 13 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
145164 12478 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 23 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
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
144238 11689 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 2 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
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
141266 11695 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 12 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
141108 11786 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1199X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8   03/17/2001 12:00:00 AM 6 3x4   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
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
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
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
137835 12481 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 26 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
137783 26171 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 16 Sidewalk: Curb side : Cutout Tree PUC 8   03/01/2000 12:00:00 AM 30 3x3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
135230 29836 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1700X Evans Ave 3 Sidewalk: Curb side : Cutout Tree PUC 8   09/11/2006 12:00:00 AM 3 4X4   6015024.36841 2099025.21413 37.7443677096073 -122.390704659402 (37.7443677096073, -122.390704659402) 10 3 8 58 1
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
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
134245 11817 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1201X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8     12 3X3   5991184.5559808 2089595.7938425 37.7171254042551 -122.472449649239 (37.7171254042551, -122.472449649239) 9 8 6 64 24
134137 24414 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1199X Junipero Serra Blvd 17 Sidewalk: Curb side : Cutout Tree PUC 8   06/23/1995 12:00:00 AM 12 3x3   5991174.5545657 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828) 9 8 6 64 24
133930 12465 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 10 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
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
133157 12473 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 18 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
132603 74892 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 141X Arleta Ave 2 Sidewalk: Curb side : Cutout Tree PUC 8 FUF 02/24/2016 12:00:00 AM 3   This is for the trees adjacent to the lot between 141-143 Arleta 6010470.01061258 2087860.00753073 37.7134566637798 -122.405666490875 (37.7134566637798, -122.405666490875) 9 7 8 309 39
132074 11715 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8   06/15/1995 12:00:00 AM 12 3X3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
132022 87700 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 799X Junipero Serra Blvd 25 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
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
131664 87713 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1199X Junipero Serra Blvd 11 Sidewalk: Curb side : Cutout Tree PUC 8   01/18/2008 12:00:00 AM 3 3x3   5991170.406953 2089609.549246 37.7171623542714 -122.472499557475 (37.7171623542714, -122.472499557475) 9 8 6 64 24
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
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
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
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
126220 116830 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 17 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
126039 24400 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 799X Junipero Serra Blvd 22 Sidewalk: Curb side : Cutout Tree PUC 8   06/15/1995 12:00:00 AM 6 3x3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
125664 29834 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1700X Evans Ave 1 Sidewalk: Curb side : Cutout Tree PUC 8   09/11/2006 12:00:00 AM 3 4X4   6015058.47657 2099001.06615 37.7443032965649 -122.390585032484 (37.7443032965649, -122.390585032484) 10 3 8 58 1
123948 75029 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 141X Arleta Ave 1 Sidewalk: Curb side : Cutout Tree PUC 8 FUF 02/24/2016 12:00:00 AM 3   This record is for lthe ot between 141-143 Arleta Ave. 6010470.01061258 2087860.00753073 37.7134566637798 -122.405666490875 (37.7134566637798, -122.405666490875) 9 7 8 309 39
123899 12471 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 16 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
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
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

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