trees
194,517 rows sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2196 | 48265 | Permitted Site 7 | Tree(s) :: 17 | 129 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2203 | 45984 | Permitted Site 7 | Tree(s) :: 17 | 123 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
2214 | 20033 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY51 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
2216 | 63596 | Permitted Site 7 | Tree(s) :: 17 | 253 Wallber St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1987 12:00:00 AM | Permit Number 24230 | |||||||||||||
2217 | 20079 | DPW Maintained 1 | Fraxinus velutina 'Glabra' :: Arizona Ash 198 | 100 STAIRWAY56 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | |||||||||||||
2225 | 44536 | Permitted Site 7 | Tree(s) :: 17 | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
2226 | 44987 | Permitted Site 7 | Tree(s) :: 17 | 59 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
2241 | 46289 | Permitted Site 7 | Robinia x ambigua :: Locust 196 | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
2265 | 48308 | Permitted Site 7 | Tree(s) :: 17 | 174 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2267 | 46716 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
2275 | 46014 | Permitted Site 7 | Tree(s) :: 17 | 200 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
2277 | 44912 | Permitted Site 7 | Tree(s) :: 17 | 185 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
2283 | 49626 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 152211th/10th Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46481 | |||||||||||||
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 | ||||||||||||
2296 | 32307 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1097 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | Permit Number 36882 | |||||||||||||
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 | |||||||||||||
2318 | 61432 | Permitted Site 7 | Tree(s) :: 17 | 234 La Espiral St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/1984 12:00:00 AM | Permit Number 21363 | |||||||||||||
2319 | 34069 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 955 Kennedy Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37965 | |||||||||||||
2323 | 35205 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
2339 | 44535 | Permitted Site 7 | Tree(s) :: 17 | 34 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
2366 | 45917 | Permitted Site 7 | Tree(s) :: 17 | 63 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
2371 | 57894 | Permitted Site 7 | Tree(s) :: 17 | 972 Terminal Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/1977 12:00:00 AM | Permit Number 16848 | |||||||||||||
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 | |||||||||||||
2424 | 61752 | Permitted Site 7 | Tree(s) :: 17 | 3014 Rolison Road | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1984 12:00:00 AM | Permit Number 21763 | |||||||||||||
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 | |||||||||||||
2434 | 44999 | Permitted Site 7 | Tree(s) :: 17 | 103 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
2445 | 48349 | Permitted Site 7 | Tree(s) :: 17 | 152 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2447 | 19649 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 48 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
2451 | 44962 | Permitted Site 7 | Tree(s) :: 17 | 75 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
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 | ||||||||||||
2483 | 34134 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37986 | ||||||||||||||
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 | |||||||||||||
2516 | 45863 | Permitted Site 7 | Tree(s) :: 17 | 85 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
2524 | 30480 | Permitted Site 7 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1956 12:00:00 AM | Permit Number 147 | ||||||||||||||
2534 | 48332 | Permitted Site 7 | Tree(s) :: 17 | 142 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
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 | |||||||||||||
2549 | 31437 | Permitted Site 7 | Tree(s) :: 17 | 4206 02nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1995 12:00:00 AM | Permit Number 35012 | |||||||||||||
2551 | 256191 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
2554 | 48167 | Permitted Site 7 | Tree(s) :: 17 | 60 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2559 | 48211 | Permitted Site 7 | Tree(s) :: 17 | 54 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
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 | |||||||||||||
2566 | 35200 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
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 | |||||||||||||
2573 | 60778 | Permitted Site 7 | Tree(s) :: 17 | 3933 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1983 12:00:00 AM | Permit Number 20448 | |||||||||||||
2582 | 19774 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY17 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20ST | |||||||||||||
2583 | 34124 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37982 | ||||||||||||||
2602 | 42924 | Permitted Site 7 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42829 | ||||||||||||||
2605 | 19985 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100 STAIRWAY46 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | |||||||||||||
2610 | 31853 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1263 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35300 | |||||||||||||
2612 | 48088 | Permitted Site 7 | Tree(s) :: 17 | 198 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2624 | 19842 | DPW Maintained 1 | Sequoiadendron giganteum :: Sierra Redwood 240 | 100 STAIRWAY25 | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
2632 | 48281 | Permitted Site 7 | Tree(s) :: 17 | 91 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
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 | ||||||||||||
2646 | 44909 | Permitted Site 7 | Tree(s) :: 17 | 132 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
2649 | 20050 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY52 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
2656 | 44646 | Permitted Site 7 | Tree(s) :: 17 | 66 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
2664 | 45874 | Permitted Site 7 | Tree(s) :: 17 | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
2666 | 48202 | Permitted Site 7 | Tree(s) :: 17 | 45 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2667 | 66672 | Permitted Site 7 | Tree(s) :: 17 | 4307 02nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1991 12:00:00 AM | Permit Number 29892 | |||||||||||||
2677 | 36640 | Permitted Site 7 | Robinia x ambigua :: Locust 196 | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
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 | |||||||||||||
2690 | 44593 | Permitted Site 7 | Tree(s) :: 17 | 133 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
2691 | 58348 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/1978 12:00:00 AM | Permit Number 17373 | ||||||||||||||
2697 | 49874 | Permitted Site 7 | Tree(s) :: 17 | 0@ 14th ST Trainor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2003 12:00:00 AM | Permit Number 46642 | |||||||||||||
2702 | 48207 | Permitted Site 7 | Tree(s) :: 17 | 50 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2710 | 44606 | Permitted Site 7 | Tree(s) :: 17 | 170 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
2715 | 57888 | Permitted Site 7 | Tree(s) :: 17 | 2382 Fost St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/1977 12:00:00 AM | Permit Number 16841 | |||||||||||||
2716 | 48065 | Permitted Site 7 | Tree(s) :: 17 | 219 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2722 | 48074 | Permitted Site 7 | Tree(s) :: 17 | 240 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
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 | |||||||||||||||
2746 | 44553 | Permitted Site 7 | Tree(s) :: 17 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
2762 | 46200 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
2763 | 48152 | Permitted Site 7 | Tree(s) :: 17 | 262 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2768 | 48107 | Permitted Site 7 | Tree(s) :: 17 | 202 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2775 | 45022 | Permitted Site 7 | Tree(s) :: 17 | 95 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
2777 | 256912 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 26 Lily St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782765 | |||||||||||
2794 | 254529 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 421 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769845 | ||||||||||
2795 | 48259 | Permitted Site 7 | Tree(s) :: 17 | 123 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2809 | 251459 | DPW Maintained 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 651 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2017 12:00:00 AM | 3 | 3x3 | ||||||||||||
2812 | 19775 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY18 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 50ST | |||||||||||||
2814 | 191330 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6014815.79386 | 2110104.24777 | 37.7747767728644 | -122.392200554832 | (37.7747767728644, -122.392200554832) | 14 | 3 | 9 | 310 | ||||
2826 | 20064 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
2832 | 45922 | Permitted Site 7 | Tree(s) :: 17 | 68 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
2835 | 48321 | Permitted Site 7 | Tree(s) :: 17 | 187 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
2849 | 44580 | Permitted Site 7 | Tree(s) :: 17 | 144 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
2851 | 45941 | Permitted Site 7 | Tree(s) :: 17 | 42 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
2852 | 48188 | Permitted Site 7 | Tree(s) :: 17 | 69 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
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 | |||||||||||||||
2871 | 45998 | Permitted Site 7 | Tree(s) :: 17 | 116 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 |
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) );