trees
261 rows where qCaretaker_id = 8 sorted by SiteOrder
This data as json, CSV (advanced)
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||||
| 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 | |||
| 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 | ||
| 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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );