trees
27,746 rows where qCaretaker_id = 1 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2026 | 19643 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 42 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
2034 | 260230 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
2047 | 20346 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 40 | |||||||||||||
2169 | 19944 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY39 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
2214 | 20033 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY51 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
2217 | 20079 | DPW Maintained 1 | Fraxinus velutina 'Glabra' :: Arizona Ash 198 | 100 STAIRWAY56 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | |||||||||||||
2286 | 20017 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY48 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
2290 | 259356 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1700 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/25/2019 12:00:00 AM | 3 | ||||||||||||
2302 | 19935 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY38 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
2304 | 19829 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY25 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
2306 | 19600 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 100 STAIRWAY4 | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
2382 | 255210 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
2386 | 19745 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 STAIRWAY15 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
2397 | 19696 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 100 STAIRWAY9 | -3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
2427 | 19795 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 100 STAIRWAY20 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
2429 | 19676 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 75 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
2447 | 19649 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 48 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
2475 | 259866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
2511 | 20282 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 20X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
2538 | 20304 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
2564 | 20333 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 101X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
2568 | 20451 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 495X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
2572 | 20316 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
2582 | 19774 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY17 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20ST | |||||||||||||
2605 | 19985 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100 STAIRWAY46 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | |||||||||||||
2624 | 19842 | DPW Maintained 1 | Sequoiadendron giganteum :: Sierra Redwood 240 | 100 STAIRWAY25 | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
2635 | 259636 | DPW Maintained 1 | :: 45 | 98x Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
2649 | 20050 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY52 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
2684 | 19830 | DPW Maintained 1 | Sequoiadendron giganteum :: Sierra Redwood 240 | 100 STAIRWAY25 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60X | |||||||||||||
2687 | 19642 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 41 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
2725 | 118348 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:19:00 AM | 3 | |||||||||||||
2726 | 260522 | DPW Maintained 1 | Griselinia lucida :: Griselinia 242 | 3440x Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | ||||||||||||
2744 | 261957 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 11 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
2812 | 19775 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY18 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 50ST | |||||||||||||
2826 | 20064 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
2858 | 261960 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 14 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
2868 | 255125 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
2883 | 19735 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
2887 | 255158 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3098 Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | |||||||||||||
2950 | 19885 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 STAIRWAY33 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
3000 | 20052 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY53 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
3011 | 19948 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 25ST | |||||||||||||
3018 | 19802 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 100 STAIRWAY22 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 20 | |||||||||||||
3028 | 19906 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 120ST | |||||||||||||
3035 | 259640 | DPW Maintained 1 | :: 45 | 198x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
3041 | 19585 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY4 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
3052 | 19908 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 120ST | |||||||||||||
3055 | 20039 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
3078 | 19568 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 100ST | |||||||||||||
3083 | 19706 | DPW Maintained 1 | Melaleuca spp :: Melaleuca spp 117 | 100 STAIRWAY13 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
3091 | 19871 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 100 STAIRWAY33 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
3098 | 20419 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
3100 | 19586 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY4 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
3106 | 20323 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
3117 | 260221 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2201x 22nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
3125 | 20020 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 STAIRWAY48 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
3129 | 20059 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
3183 | 260224 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2201x 22nd Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
3191 | 19565 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | -11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 100ST | |||||||||||||
3196 | 19917 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY35 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 120ST | |||||||||||||
3208 | 19988 | DPW Maintained 1 | Quercus spp :: Oak 254 | 100 STAIRWAY46 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40 | |||||||||||||
3211 | 19860 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 30ST | |||||||||||||
3222 | 20014 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY47 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
3227 | 259338 | DPW Maintained 1 | Laurus x 'Saratoga' :: Hybrid Laurel 4 | 2x Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
3232 | 20054 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
3265 | 255205 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
3284 | 19710 | DPW Maintained 1 | Melaleuca spp :: Melaleuca spp 117 | 100 STAIRWAY13 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
3296 | 19833 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY25 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60X | |||||||||||||
3319 | 255128 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 6 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
3339 | 19580 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY4 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 8 | |||||||||||||
3352 | 20327 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 101X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
3379 | 258367 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 901 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | ||||||||||||||
3442 | 20392 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 262X Sunset Blvd | 38 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
3448 | 19730 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
3449 | 19754 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY15 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
3457 | 20016 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY48 | 0 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
3460 | 20048 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 STAIRWAY52 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
3477 | 259101 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600 Visitacion Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
3511 | 254247 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 100x Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/2018 12:00:00 AM | 3 | |||||||||||||
3527 | 19876 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY33 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
3534 | 118354 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100X Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:05:00 AM | 3 | |||||||||||||
3552 | 19877 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY33 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 25ST | |||||||||||||
3556 | 20340 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | |||||||||||||
3626 | 20062 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
3634 | 20382 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
3639 | 20284 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
3719 | 258151 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 500X Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | |||||||||||||
3729 | 260419 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | ||||||||||||
3770 | 19669 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 68 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
3808 | 20305 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 50X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
3812 | 19927 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY37 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
3853 | 19924 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY37 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
3868 | 259094 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
3883 | 19686 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 85 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
3904 | 121227 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 4299x 17th St | 3 | Front Yard : Yard | Tree | DPW 1 | |||||||||||||||
3905 | 19979 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY45 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30ST | |||||||||||||
3942 | 19803 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 100 STAIRWAY22 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20 | |||||||||||||
3996 | 19960 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 100 STAIRWAY41 | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
3997 | 20436 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15 | |||||||||||||
4038 | 20457 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 495X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 |
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) );