trees
27,746 rows where qCaretaker_id = 1 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 454 | 11293 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1199X Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.7305086962257 | -122.381402471608 | (37.7305086962257, -122.381402471608) | 10 | 3 | 8 | 58 | 1 | |||
| 455 | 30164 | DPW Maintained 1 | Shrub :: Shrub 66 | 410X Mansell St | 21 | Median : Cutout | Tree | DPW 1 | 0 | POT | 6010678.994322 | 2090457.626596 | 37.7206008798567 | -122.405126964413 | (37.7206008798567, -122.405126964413) | 10 | 3 | 7 | 309 | 28 | |||
| 456 | 247507 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400x Divisadero St | 2 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001724.6395 | 2109878.2699 | 37.7734207168265 | -122.437469283257 | (37.7734207168265, -122.437469283257) | 15 | 5 | 11 | 29492 | 10 | |||
| 464 | 173918 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2160X 09th Ave | 6 | Median : Cutout | Tree | DPW 1 | 6x10 | 5993671 | 2100995 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | 1 | 8 | 4 | 29491 | 40 | ||||
| 467 | 211626 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 299x Magellan Ave | 6 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 5994442.33797 | 2100102.58449 | 37.7461624991943 | -122.461950600334 | (37.7461624991943, -122.461950600334) | 1 | 8 | 4 | 29491 | 40 | |||
| 470 | 119711 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 4 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 471 | 205972 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 400x Marietta Dr | 49 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 5998976.04571 | 2096922.6715 | 37.7376911903888 | -122.446044988292 | (37.7376911903888, -122.446044988292) | 9 | 7 | 4 | 59 | 40 | |||
| 477 | 113497 | DPW Maintained 1 | Tree(s) :: 17 | 200x MANSELL ST | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6011136 | 2090597 | 37.7210091086741 | -122.403557031831 | (37.7210091086741, -122.403557031831) | 10 | 3 | 7 | 309 | 28 | ||||
| 481 | 119782 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 2 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 485 | 251655 | DPW Maintained 1 | Shrub :: Shrub 66 | 300x Chester Ave | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 5991691 | 2087193 | 37.7105572148468 | -122.470524229297 | (37.7105572148468, -122.470524229297) | 9 | 8 | 4 | 64 | 24 | ||||
| 488 | 20353 | DPW Maintained 1 | Acacia decurrens :: Acacia: Silver Wattle 111 | 262X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
| 496 | 6869 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 4 | 5x5 | 6006554.4326182 | 2110816.1011215 | 37.7762691791752 | -122.420828904096 | (37.7762691791752, -122.420828904096) | 7 | 9 | 11 | 28852 | 10 | ||
| 509 | 19905 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 120ST | |||||||||||||
| 535 | 50166 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 159 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46878 | 6010492.5895 | 2111415.08321 | 37.7781350293519 | -122.407247904281 | (37.7781350293519, -122.407247904281) | 14 | 2 | 9 | 28853 | 34 | |
| 537 | 261951 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 544 | 259763 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2701 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2019 12:00:00 AM | 3 | |||||||||||||
| 545 | 90279 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4338 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982078.08793 | 2111023.84587 | 37.7754295872152 | -122.505513277346 | (37.7754295872152, -122.505513277346) | 11 | 6 | 2 | 55 | 26 | ||
| 550 | 19742 | DPW Maintained 1 | Melaleuca spp :: Melaleuca spp 117 | 100 STAIRWAY15 | -9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1OST | |||||||||||||
| 561 | 19835 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY25 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60X | |||||||||||||
| 582 | 20409 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 451X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10 | |||||||||||||
| 594 | 20063 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 595 | 261954 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 604 | 20034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
| 624 | 20956 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2000X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984893.4728491 | 2101578.9445242 | 37.749661815397 | -122.495077729215 | (37.749661815397, -122.495077729215) | 1 | 8 | 3 | 29491 | 35 | |||
| 632 | 23885 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1750X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6003231.6817 | 2113926.646 | 37.7846221123784 | -122.432545437068 | (37.7846221123784, -122.432545437068) | 13 | 9 | 11 | 29490 | 13 | |||
| 639 | 261347 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 657 | 20296 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 20X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
| 659 | 11520 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 6 | 3X3 | 6018495.90717 | 2096693.85175 | 37.738158246093 | -122.378538834904 | (37.738158246093, -122.378538834904) | 10 | 3 | 8 | 58 | 1 | ||
| 668 | 19865 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
| 682 | 16784 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1961 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 5999039.4234543 | 2112720.6314145 | 37.781072082708 | -122.446962370058 | (37.781072082708, -122.446962370058) | 15 | 5 | 1 | 54 | 16 | |||
| 689 | 119914 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 400X Brotherhood Way | 1 | Front Yard : Yard | Tree | DPW 1 | 100x100 | ||||||||||||||
| 690 | 19651 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 50 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
| 695 | 20360 | DPW Maintained 1 | Acacia decurrens :: Acacia: Silver Wattle 111 | 262X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
| 697 | 19206 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 630 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012230.08543 | 2117977.14861 | 37.7962500076802 | -122.401698594427 | (37.7962500076802, -122.401698594427) | 3 | 1 | 10 | 28860 | 4 | |||
| 704 | 10945 | DPW Maintained 1 | Quercus coccinea :: Scarlet Oak 134 | 1400X Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6016738.0241541 | 2096692.24342 | 37.7380567715564 | -122.384616664641 | (37.7380567715564, -122.384616664641) | 10 | 3 | 8 | 58 | 1 | ||
| 705 | 89736 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1331 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5994511.74446 | 2112094.8458 | 37.7790941312548 | -122.462580347401 | (37.7790941312548, -122.462580347401) | 11 | 6 | 2 | 54 | 11 | ||
| 707 | 27746 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1399 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6014867.8526066 | 2101105.5872465 | 37.7500712934283 | -122.391391267014 | (37.7500712934283, -122.391391267014) | 10 | 3 | 8 | 28856 | 1 | |||
| 710 | 256206 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 11 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
| 720 | 19950 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
| 750 | 11540 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018782.49291 | 2097080.98118 | 37.7392370206652 | -122.37757481115 | (37.7392370206652, -122.37757481115) | 10 | 3 | 8 | 58 | 1 | |||
| 760 | 112380 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3250 CESAR CHAVEZ ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6007972 | 2100641 | 37.7484105018638 | -122.415204699043 | (37.7484105018638, -122.415204699043) | 2 | 4 | 7 | 28859 | 19 | |||
| 766 | 17084 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1575 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5999487.0395 | 2109431.3054 | 37.7720659980909 | -122.445177292475 | (37.7720659980909, -122.445177292475) | 15 | 5 | 11 | 29492 | 9 | |||
| 768 | 20385 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 262X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
| 775 | 584 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3035 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/20/2019 10:48:00 AM | 3 | 4x4 | 6008750.98529 | 2102125.48957 | 37.7525303261177 | -122.412615900926 | (37.7525303261177, -122.412615900926) | 2 | 4 | 7 | 28859 | 19 | ||
| 776 | 113502 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200x MANSELL ST | 8 | Median : Cutout | Tree | DPW 1 | 30 | 3x3 | 6011136 | 2090597 | 37.7210091086741 | -122.403557031831 | (37.7210091086741, -122.403557031831) | 10 | 3 | 7 | 309 | 28 | |||
| 785 | 262387 | DPW Maintained 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1525 Galvez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/2017 12:18:00 PM | 6016246.49948 | 2097351.8889 | 37.739840829559 | -122.38636210374 | (37.739840829559, -122.38636210374) | 10 | 3 | 8 | 58 | 1 | ||||
| 788 | 200933 | DPW Maintained 1 | Tristania conferta :: 61 | 4210 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6015403.5213 | 2097186.1672 | 37.7393390938031 | -122.389265224086 | (37.7393390938031, -122.389265224086) | 10 | 3 | 8 | 58 | 1 | |||
| 795 | 19570 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 100ST | |||||||||||||
| 798 | 19725 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
| 808 | 19837 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY25 | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
| 813 | 221494 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:53:00 PM | 2 | 3x3 | Permit Number 56125 | 6005589.49697 | 2105398.29386 | 37.7613387412987 | -122.423781567769 | (37.7613387412987, -122.423781567769) | 2 | 4 | 5 | 28859 | 19 | |
| 815 | 20416 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 453X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
| 819 | 20315 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
| 822 | 112248 | DPW Maintained 1 | Acer spp :: Maple 88 | 1799X TAYLOR ST | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 15 | 6008739 | 2118839 | 37.7984210068607 | -122.413839504702 | (37.7984210068607, -122.413839504702) | 5 | 1 | 10 | 308 | 21 | ||||
| 825 | 175382 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80x Junipero Serra Blvd | 19 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 2 | Width 3ft | 5991305.51807 | 2089124.29272 | 37.7158377779634 | -122.471997198511 | (37.7158377779634, -122.471997198511) | 9 | 8 | 6 | 64 | 24 | |||
| 831 | 245412 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2802 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6009963.8161 | 2102233.787 | 37.7528956807716 | -122.408429345015 | (37.7528956807716, -122.408429345015) | 2 | 4 | 7 | 28859 | 19 | |||
| 833 | 106379 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 6 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
| 840 | 1046 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2009X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/15/1992 12:00:00 AM | 12 | 4X4 | 6000674.20134 | 2090359.18139 | 37.7197661846273 | -122.439703245137 | (37.7197661846273, -122.439703245137) | 9 | 7 | 6 | 28861 | 25 | ||
| 844 | 254210 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300x Esmeralda Ave | 20 | Unaccepted Street : Yard | Tree | DPW 1 | |||||||||||||||
| 848 | 116677 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 100 Esmeralda Ave | 16 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 857 | 189910 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 3ft | 6016250.22154 | 2098227.10108 | 37.7422441899167 | -122.386410241063 | (37.7422441899167, -122.386410241063) | 10 | 3 | 8 | 58 | 1 | |||
| 859 | 10756 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1120X Hudson Ave | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | |||
| 860 | 9301 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1 Mansell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6011832.70408 | 2090706.21234 | 37.7213478755834 | -122.401156387751 | (37.7213478755834, -122.401156387751) | 10 | 7 | 8 | 309 | 28 | |||
| 874 | 19715 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
| 875 | 19954 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY39 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
| 876 | 5429 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 465 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6004961.54975 | 2105631.51156 | 37.7619436334085 | -122.42596997713 | (37.7619436334085, -122.42596997713) | 8 | 4 | 5 | 28859 | 19 | |||
| 878 | 126969 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2701 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 3ft | 5999145.58694 | 2118075.75757 | 37.795781916869 | -122.44698057642 | (37.795781916869, -122.44698057642) | 11 | 1 | 57 | 30 | ||||
| 895 | 56729 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1547 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 5 | Permit Number 769649 | 6015653.0224 | 2095684.4557 | 37.7352295280363 | -122.388297771341 | (37.7352295280363, -122.388297771341) | 10 | 3 | 8 | 58 | 1 | ||
| 898 | 262453 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2005 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003839 | 2115372 | 37.7886251115209 | -122.43054748798 | (37.7886251115209, -122.43054748798) | 13 | 9 | 1 | 29490 | 27 | ||||
| 900 | 19637 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY5 | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
| 906 | 25069 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000X Dolores St | 12 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005114.64614 | 2102050.12648 | 37.752118640771 | -122.425185628926 | (37.752118640771, -122.425185628926) | 2 | 4 | 5 | 28862 | 22 | |||
| 922 | 91748 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008877.354104 | 2103306.550106 | 37.7557803438331 | -122.412262362741 | (37.7557803438331, -122.412262362741) | 2 | 4 | 7 | 28859 | 19 | ||
| 929 | 257972 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2091 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 5982601.27724 | 2100898.28737 | 37.7476584613609 | -122.502953711343 | (37.7476584613609, -122.502953711343) | 1 | 8 | 3 | 29491 | 35 | ||||
| 932 | 111099 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 480X LAKESHORE DR | 20 | Median : Cutout | Tree | DPW 1 | 30x200 | 5984942 | 2095282 | 37.7323749444343 | -122.494445798495 | (37.7323749444343, -122.494445798495) | 1 | 8 | 4 | 64 | 35 | ||||
| 946 | 133881 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2864 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 4ft | Permit Number 782825 | 5999916.99907 | 2117104.86853 | 37.7931601538699 | -122.444241554422 | (37.7931601538699, -122.444241554422) | 13 | 9 | 1 | 57 | 27 | ||
| 952 | 90962 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4449X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981706.97988 | 2110951.27348 | 37.7752084783718 | -122.506791621288 | (37.7752084783718, -122.506791621288) | 11 | 6 | 2 | 55 | 26 | ||
| 954 | 20324 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
| 971 | 16508 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 325 Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016639.93914 | 2098306.03692 | 37.7424824967653 | -122.385068203435 | (37.7424824967653, -122.385068203435) | 10 | 3 | 8 | 58 | 1 | |||
| 973 | 176338 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100x Mansell St | 6 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6011479.2515 | 2090641.1055 | 37.721149380822 | -122.402373605767 | (37.721149380822, -122.402373605767) | 10 | 7 | 8 | 309 | 28 | |||
| 975 | 4380 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2421X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007006.0129161 | 2120659.6131485 | 37.8033224749672 | -122.419965449311 | (37.8033224749672, -122.419965449311) | 5 | 1 | 1 | 28858 | 32 | |||
| 978 | 8142 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 924 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003320.2078 | 2111406.4501 | 37.7777073047982 | -122.432059137251 | (37.7777073047982, -122.432059137251) | 15 | 9 | 11 | 29492 | 41 | |||
| 981 | 221424 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005689.53453 | 2103630.03961 | 37.7564891759384 | -122.423309876046 | (37.7564891759384, -122.423309876046) | 2 | 4 | 5 | 28859 | 19 | ||
| 993 | 67493 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 740 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/1992 12:00:00 AM | 8 | Permit Number 31018 | 6011800.9294 | 2105019.52264 | 37.7606474054712 | -122.402272073209 | (37.7606474054712, -122.402272073209) | 10 | 3 | 8 | 28856 | 29 | ||
| 1012 | 24992 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 340 Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004882.50848 | 2106257.62148 | 37.7636583150142 | -122.426287928865 | (37.7636583150142, -122.426287928865) | 8 | 4 | 5 | 28859 | 3 | |||
| 1043 | 99282 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1500 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 6003016.20305 | 2114040.83621 | 37.7849234280868 | -122.433299082538 | (37.7849234280868, -122.433299082538) | 13 | 9 | 11 | 29490 | 13 | |||
| 1049 | 120626 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
| 1062 | 20065 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 STAIRWAY54 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15ST | |||||||||||||
| 1071 | 240683 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005765.02468 | 2102281.28975 | 37.7527900818195 | -122.422952946818 | (37.7527900818195, -122.422952946818) | 2 | 4 | 5 | 28859 | 19 | ||
| 1077 | 149677 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 1 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011154.9566 | 2106050.92707 | 37.7634433311543 | -122.404578819881 | (37.7634433311543, -122.404578819881) | 8 | 3 | 8 | 28856 | 29 | |
| 1082 | 261856 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 937x Meade Ave | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6012763 | 2089349 | 37.7176730984513 | -122.397845439416 | (37.7176730984513, -122.397845439416) | 10 | 3 | 8 | 58 | 1 | ||||
| 1083 | 94032 | DPW Maintained 1 | Arecastrum romanzoffianum :: Queen Palm 135 | 1500 Oakdale Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015583.39088 | 2095096.21149 | 37.733610469696 | -122.388497468614 | (37.733610469696, -122.388497468614) | 10 | 3 | 8 | 58 | 1 | ||||
| 1086 | 91876 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 700 Irving St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/03/2015 02:50:00 PM | 3 | 3x3 | 5993617.143263 | 2106666.291015 | 37.7641372031802 | -122.465280687147 | (37.7641372031802, -122.465280687147) | 11 | 8 | 11 | 56 | 12 | ||
| 1088 | 20259 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/2015 07:41:00 AM | 3 | 3X3 | 6009947.7744 | 2120592.07204 | 37.8033023200197 | -122.40978056566 | (37.8033023200197, -122.40978056566) | 3 | 1 | 10 | 308 | 23 | ||
| 1108 | 627 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3166 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6007870.94281 | 2102116.96374 | 37.7524574855488 | -122.415658642859 | (37.7524574855488, -122.415658642859) | 2 | 4 | 7 | 28859 | 19 | |||
| 1142 | 260393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 1144 | 20400 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 45 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
| 1146 | 6579 | DPW Maintained 1 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 1337 Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/24/1998 12:00:00 AM | 3 | 3X3 | 6017048.7081546 | 2097427.5062586 | 37.7400928320588 | -122.383593638958 | (37.7400928320588, -122.383593638958) | 10 | 3 | 8 | 58 | 1 | ||
| 1150 | 97170 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 289 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6009625.74334 | 2110365.68554 | 37.7752050776892 | -122.41017254363 | (37.7752050776892, -122.41017254363) | 8 | 2 | 9 | 28853 | 34 | |||
| 1164 | 24021 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 21 Westbrook Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/23/1995 12:00:00 AM | 3 | 3X4 | 6017459.387304 | 2095522.0819228 | 37.7348836077988 | -122.382041153064 | (37.7348836077988, -122.382041153064) | 10 | 3 | 8 | 58 | 1 | ||
| 1171 | 19952 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY39 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST |
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) );