trees
27,746 rows where qCaretaker_id = 1 sorted by SiteOrder descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28540 | 25054 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 35 | 20 | 6005073.8483 | 2102816.15893 | 37.7542196827988 | -122.425381222462 | (37.7542196827988, -122.425381222462) | 2 | 4 | 5 | 28862 | 22 | |||
| 28991 | 2078 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 900X Bosworth St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 6001652.8683328 | 2095576.0345147 | 37.7341461328318 | -122.436693577752 | (37.7341461328318, -122.436693577752) | 2 | 7 | 5 | 63 | 7 | |||
| 29210 | 176917 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 9 | Median : Yard | Tree | DPW 1 | 3 | 6001514.03799 | 2088123.65893 | 37.7136757052349 | -122.436640299224 | (37.7136757052349, -122.436640299224) | 9 | 7 | 6 | 28861 | 5 | ||||
| 29587 | 112207 | DPW Maintained 1 | Fraxinus americana :: American Ash 381 | 2000X Turk Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6000150.3593 | 2112028.2188 | 37.7792343016328 | -122.443069358849 | (37.7792343016328, -122.443069358849) | 15 | 5 | 1 | 29490 | 16 | |||
| 30168 | 12899 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 255X Larch St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006360.81512 | 2112999.88713 | 37.7822544100736 | -122.421653822027 | (37.7822544100736, -122.421653822027) | 7 | 9 | 11 | 28852 | 41 | |||
| 30266 | 102965 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | 9 | 8 | 6 | 64 | 24 | |||
| 30628 | 110780 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 9 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:30:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
| 31585 | 119691 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 32179 | 87737 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 9 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.28256 | 37.8051028305372 | -122.4252793245 | (37.8051028305372, -122.4252793245) | 5 | 1 | 1 | 28858 | 32 | ||
| 33090 | 181225 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2000x Bay Shore Blvd | 9 | Median : Cutout | Tree | DPW 1 | 14 | Width 5ft | 6012142.64872 | 2087966.32727 | 37.713841988985 | -122.399892688298 | (37.713841988985, -122.399892688298) | 10 | 7 | 8 | 309 | 39 | |||
| 33234 | 208271 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 9 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 5996099.48169 | 2098476.66946 | 37.7417934029459 | -122.456102909823 | (37.7417934029459, -122.456102909823) | 9 | 7 | 4 | 59 | 40 | |||
| 33448 | 8513 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2099X Geary Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6001704.2218086 | 2113592.1733887 | 37.7836169980639 | -122.437805961293 | (37.7836169980639, -122.437805961293) | 15 | 5 | 11 | 29490 | 41 | |||
| 34015 | 23229 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 655X Van Ness Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4X4 | 6006626.36739 | 2112726.37233 | 37.7815183756303 | -122.420715704793 | (37.7815183756303, -122.420715704793) | 7 | 9 | 11 | 28852 | 41 | |||
| 34286 | 20805 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1792X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.495403216296 | (37.7535582155387, -122.495403216296) | 1 | 8 | 3 | 56 | 35 | |||
| 34378 | 109203 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2401x CASTRO ST | 9 | Median : Yard | Tree | DPW 1 | 6002698 | 2098487 | 37.7421983129634 | -122.433288166914 | (37.7421983129634, -122.433288166914) | 2 | 7 | 5 | 63 | 7 | |||||
| 34524 | 9420 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6005985.41292 | 2112474.48884 | 37.7807906194317 | -122.422915195091 | (37.7807906194317, -122.422915195091) | 7 | 9 | 11 | 28852 | 41 | |||
| 34988 | 20754 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1692X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984807.4869191 | 2103677.7923597 | 37.7554196391607 | -122.495529849669 | (37.7554196391607, -122.495529849669) | 1 | 8 | 3 | 56 | 35 | |||
| 35125 | 4920 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/26/2015 05:54:00 AM | 3 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | ||
| 35243 | 181250 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2200x Bay Shore Blvd | 9 | Median : Cutout | Tree | DPW 1 | 15 | Width 6ft | 6011135.05622 | 2087186.9706 | 37.7116458067799 | -122.403320528015 | (37.7116458067799, -122.403320528015) | 9 | 7 | 8 | 309 | 1 | |||
| 35291 | 93363 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2800 Turk Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5997683.2 | 2111662.6 | 37.7780894288895 | -122.451577860296 | (37.7780894288895, -122.451577860296) | 15 | 6 | 2 | 54 | 16 | ||
| 35862 | 1540 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | 11 | 6 | 1 | 54 | 31 | |||
| 36233 | 398 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 2 | 5990471.16794 | 2090846.61881 | 37.7205185437854 | -122.475006721555 | (37.7205185437854, -122.475006721555) | 9 | 8 | 4 | 64 | 40 | |||
| 36559 | 195772 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 700x King St | 9 | Median : Yard | Tree | DPW 1 | 10 | Width 8ft | 6013930.44742 | 2110363.99396 | 37.7754407791936 | -122.395281372244 | (37.7754407791936, -122.395281372244) | 6 | 2 | 9 | 28856 | 20 | |||
| 36760 | 16015 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 100X Monterey Blvd | 9 | Median : Cutout | Tree | DPW 1 | 12 | 4 | 6000956.04768 | 2094656.76286 | 37.7315824005883 | -122.439036840479 | (37.7315824005883, -122.439036840479) | 9 | 7 | 4 | 63 | 40 | |||
| 37400 | 10722 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.7831447510095 | -122.430058726681 | (37.7831447510095, -122.430058726681) | 7 | 9 | 11 | 29490 | 41 | |||
| 37416 | 24066 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 21X Whitfield Ct | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6017547.7495644 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | 10 | 3 | 8 | 58 | 1 | |||
| 37684 | 94810 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3695X 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015935.10482 | 2098700.92618 | 37.7435277680723 | -122.387532876065 | (37.7435277680723, -122.387532876065) | 10 | 3 | 8 | 58 | 1 | |||
| 37967 | 246565 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 9 | Median : Yard | Tree | DPW 1 | 11 | Width 7ft | 6005706.10974 | 2109468.40026 | 37.7725208666788 | -122.423667646169 | (37.7725208666788, -122.423667646169) | 7 | 9 | 11 | 28852 | 10 | |||
| 38086 | 85870 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2310 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/2007 12:00:00 AM | 3 | 3x3 | 6008150.98253 | 2104964.863142 | 37.7602929064273 | -122.414891759956 | (37.7602929064273, -122.414891759956) | 2 | 4 | 7 | 28859 | 19 | ||
| 38316 | 107558 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
| 39279 | 217440 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 601x Monterey Blvd | 9 | Median : Cutout | Tree | DPW 1 | 12 | Width 4ft | 5997608.12096 | 2094709.93286 | 37.731537330169 | -122.450615054238 | (37.731537330169, -122.450615054238) | 9 | 7 | 4 | 59 | 40 | |||
| 39338 | 180295 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500x Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6001915.65954 | 2093123.81591 | 37.7274278322296 | -122.435609650978 | (37.7274278322296, -122.435609650978) | 9 | 7 | 6 | 28861 | 25 | |||
| 39660 | 111514 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 9 | Front Yard : Yard | Tree | DPW 1 | 12 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 39717 | 30064 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 510X Brotherhood Way | 9 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642524 | 2087870.68608 | 37.7124705349467 | -122.467429580771 | (37.7124705349467, -122.467429580771) | 9 | 8 | 4 | 64 | 24 | ||
| 40163 | 110645 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200x DRUMM ST | 9 | Median : Cutout | Tree | DPW 1 | 6013666 | 2117675 | 37.7955004026749 | -122.396708806749 | (37.7955004026749, -122.396708806749) | 4 | 1 | 10 | 28860 | 6 | |||||
| 40416 | 206821 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 335x Pacheco St | 9 | Median : Yard | Tree | DPW 1 | 3 | Width 8ft | 5994174.99878 | 2101175.06788 | 37.7490918726007 | -122.462952815645 | (37.7490918726007, -122.462952815645) | 1 | 8 | 4 | 29491 | 40 | |||
| 40632 | 21271 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2492X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984994.4282385 | 2098239.2478178 | 37.740497824548 | -122.494482465671 | (37.740497824548, -122.494482465671) | 1 | 8 | 3 | 29491 | 35 | |||
| 40877 | 211250 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 99x San Marcos Ave | 9 | Median : Cutout | Tree | DPW 1 | 33 | Width 5ft | 5993746.09289 | 2100276.06203 | 37.7465987162755 | -122.464370702046 | (37.7465987162755, -122.464370702046) | 1 | 8 | 4 | 29491 | 40 | |||
| 40918 | 97229 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 9 | Median : Cutout | Tree | DPW 1 | 28 | 15x200 | 6016636.94251 | 2094930.84044 | 37.7332147213866 | -122.384843483567 | (37.7332147213866, -122.384843483567) | 10 | 3 | 8 | 58 | 1 | |||
| 41302 | 221436 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:05:00 AM | 1 | Width 3ft | 6005440.21619 | 2108132.10005 | 37.7688366949854 | -122.424492330751 | (37.7688366949854, -122.424492330751) | 8 | 4 | 5 | 28853 | 19 | ||
| 42580 | 28156 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
| 43098 | 25024 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 700X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005003.84878 | 2104046.64903 | 37.7575943654175 | -122.425710873457 | (37.7575943654175, -122.425710873457) | 2 | 4 | 5 | 28862 | 3 | |||
| 43256 | 12008 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1230X La Salle Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | 10 | 3 | 8 | 58 | 1 | |||
| 43282 | 4044 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2014 12:00:00 AM | 3 | 2X3 | 6012170.1171 | 2100910.58495 | 37.7493857629599 | -122.400706546863 | (37.7493857629599, -122.400706546863) | 10 | 3 | 8 | 58 | 1 | ||
| 43334 | 180421 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1132x Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6003365.77706 | 2094291.48085 | 37.7307162356701 | -122.430679881378 | (37.7307162356701, -122.430679881378) | 9 | 7 | 6 | 28861 | 25 | |||
| 44200 | 8840 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4000 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | 11 | 6 | 2 | 54 | 11 | |||
| 44481 | 221476 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 04/29/2015 09:37:00 AM | 1 | Width 3ft | 6005539.09271 | 2106307.48846 | 37.7638323293302 | -122.424020552718 | (37.7638323293302, -122.424020552718) | 8 | 4 | 5 | 28859 | 19 | ||
| 44747 | 30819 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 151 Lippard Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/06/1995 12:00:00 AM | 4 | Permit Number 34679 | 6001850.40599 | 2095237.97524 | 37.7332291240165 | -122.435986447137 | (37.7332291240165, -122.435986447137) | 9 | 7 | 5 | 63 | 40 | ||
| 45064 | 28647 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1600X Webster St | 9 | Median : Cutout | Tree | DPW 1 | 8 | 6 | 6003547.8453 | 2114380.4001 | 37.7858859308492 | -122.431484021877 | (37.7858859308492, -122.431484021877) | 13 | 9 | 11 | 29490 | 13 | |||
| 45659 | 28107 | DPW Maintained 1 | Fraxinus x Moraine :: Moraine Ash 344 | 1355X Webster St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003646.0046556 | 2113350.9191197 | 37.7830647975963 | -122.431070913528 | (37.7830647975963, -122.431070913528) | 15 | 9 | 11 | 29490 | 41 | |||
| 45689 | 221513 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005831.83209 | 2101056.03846 | 37.7494295931996 | -122.422634853028 | (37.7494295931996, -122.422634853028) | 2 | 4 | 5 | 28859 | 19 | |||
| 46127 | 25143 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1798X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 50 | 20 | 6005303.4758509 | 2097774.014097 | 37.7403880804322 | -122.42422853473 | (37.7403880804322, -122.42422853473) | 2 | 7 | 5 | 28859 | 7 | |||
| 46391 | 87610 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 800X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/03/2014 12:00:00 AM | 3 | 3x3 | 5991263.805475 | 2092171.02552 | 37.7242009421806 | -122.472363351561 | (37.7242009421806, -122.472363351561) | 9 | 8 | 4 | 64 | 40 | ||
| 46706 | 2041 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 700X Bosworth St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/11/1994 12:00:00 AM | 6 | 3X3 | 6002154.6210393 | 2095431.8532492 | 37.7337787461998 | -122.434948555048 | (37.7337787461998, -122.434948555048) | 2 | 7 | 5 | 63 | 7 | ||
| 46803 | 24102 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 105X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 | |||
| 46886 | 2120 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1100X Bosworth St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/06/2005 12:00:00 AM | 3 | 3X3 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||
| 47050 | 18291 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2000 Post St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1992 12:00:00 AM | 6 | 4X4 | 6002309.6948 | 2114045.1862 | 37.7848952663203 | -122.435743681544 | (37.7848952663203, -122.435743681544) | 13 | 6 | 11 | 29490 | 13 | ||
| 47290 | 110626 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 9 | Median : Cutout | Tree | DPW 1 | 04/29/2015 09:37:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
| 47326 | 29265 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 9 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5999025.51534 | 2100236.39083 | 37.746792692825 | -122.446112234204 | (37.746792692825, -122.446112234204) | 2 | 7 | 5 | 63 | 22 | ||
| 47389 | 87404 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300 Webster St | 9 | Median : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 6003683.0746 | 2113412.9921 | 37.7832373349481 | -122.430947098227 | (37.7832373349481, -122.430947098227) | 15 | 9 | 11 | 29490 | 41 | ||
| 47630 | 93326 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
| 47741 | 97385 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 1401X Broadway | 9 | Median : Cutout | Tree | DPW 1 | 3 | 6006527.03038 | 2118000.68045 | 37.7959947216224 | -122.42143404497 | (37.7959947216224, -122.42143404497) | 13 | 9 | 10 | 28858 | 32 | ||||
| 47925 | 211629 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 299x Magellan Ave | 9 | Median : Cutout | Tree | DPW 1 | 7 | Width 6ft | 5994463.26259 | 2100123.19006 | 37.7462202815386 | -122.461879740062 | (37.7462202815386, -122.461879740062) | 1 | 8 | 4 | 29491 | 40 | |||
| 48382 | 12087 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1261X La Salle Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457 | -122.383068698568 | (37.732064349457, -122.383068698568) | 10 | 3 | 8 | 58 | 1 | |||
| 48659 | 16518 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 330 Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | ||
| 49167 | 16426 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2007 12:00:00 AM | 12 | 3x3 | 6016278.230833 | 2094877.189867 | 37.7330475611009 | -122.386079920066 | (37.7330475611009, -122.386079920066) | 10 | 3 | 8 | 58 | 1 | ||
| 49369 | 25015 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004955.91822 | 2104917.6837 | 37.7599833128008 | -122.42593863935 | (37.7599833128008, -122.42593863935) | 2 | 4 | 5 | 28862 | 3 | |||
| 49472 | 24271 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300X Winding Way | 9 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6001388.30533 | 2086462.26856 | 37.7091067481538 | -122.436956008017 | (37.7091067481538, -122.436956008017) | 9 | 7 | 6 | 28861 | 5 | |||
| 49832 | 8949 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4800 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | 11 | 6 | 2 | 54 | 11 | |||
| 49862 | 340 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3590X 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | |||
| 50282 | 16487 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 220 Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2000 12:00:00 AM | 2 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 | ||
| 50328 | 29168 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3311 Ortega St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 3x3 | 5983780.4899722 | 2102201.743436 | 37.7513066285159 | -122.49897241277 | (37.7513066285159, -122.49897241277) | 1 | 8 | 3 | 29491 | 35 | ||
| 50720 | 25534 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 9 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002560.5766 | 2106158.8258 | 37.7632555258533 | -122.434311693987 | (37.7632555258533, -122.434311693987) | 15 | 4 | 5 | 28862 | 3 | ||
| 50745 | 14823 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1234 McAllister St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2001 12:00:00 AM | 3 | 4X4 | 6003134.879 | 2111723.2201 | 37.778566567554 | -122.432722886511 | (37.778566567554, -122.432722886511) | 15 | 9 | 11 | 29490 | 41 | ||
| 51103 | 91433 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800X Portola Dr | 9 | Median : Cutout | Tree | DPW 1 | 10/01/2005 12:00:00 AM | 4x4 | 5996711.121131 | 2099335.742872 | 37.7441872967186 | -122.454050104178 | (37.7441872967186, -122.454050104178) | 1 | 7 | 4 | 59 | 40 | |||
| 51189 | 29209 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2002X 41st Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983557.6109598 | 2101506.6699283 | 37.7493850732351 | -122.499691774232 | (37.7493850732351, -122.499691774232) | 1 | 8 | 3 | 29491 | 35 | |||
| 51262 | 9181 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6100 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987959.6305 | 2112590.5589 | 37.7800757085683 | -122.485282874223 | (37.7800757085683, -122.485282874223) | 11 | 6 | 2 | 55 | 26 | |||
| 51441 | 17864 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2121 Pine St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003749.9172 | 2115228.4651 | 37.7882259541053 | -122.430845453567 | (37.7882259541053, -122.430845453567) | 13 | 9 | 11 | 29490 | 27 | |||
| 51547 | 197881 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 9 | Median : Yard | Tree | DPW 1 | 11 | Width 7ft | 6015646.32257 | 2101941.32655 | 37.7524092333136 | -122.388757586711 | (37.7524092333136, -122.388757586711) | 10 | 3 | 8 | 28856 | 1 | |||
| 51784 | 121350 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
| 51863 | 4546 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 66 Cleary Ct | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2016 10:30:00 AM | 3 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | ||
| 52013 | 190990 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 301x Cashmere St | 9 | Median : Yard | Tree | DPW 1 | 8 | 6016177.27303 | 2096204.98812 | 37.7366878401785 | -122.386521512362 | (37.7366878401785, -122.386521512362) | 10 | 3 | 8 | 58 | 1 | ||||
| 52094 | 152420 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005641.89151 | 2104501.69931 | 37.7588798608311 | -122.42353661134 | (37.7588798608311, -122.42353661134) | 2 | 4 | 5 | 28859 | 19 | |||
| 52331 | 29994 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 9 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005883.22983 | 2099389.42314 | 37.7448563472359 | -122.422338718883 | (37.7448563472359, -122.422338718883) | 2 | 7 | 5 | 28859 | 2 | ||
| 53353 | 11254 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1145X Ingalls St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/1998 12:00:00 AM | 12 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | 10 | 3 | 8 | 58 | 1 | ||
| 53552 | 28226 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 53571 | 221464 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:25:00 AM | 2 | Width 3ft | 6005509.87291 | 2106837.48432 | 37.7652859224425 | -122.42415931 | (37.7652859224425, -122.42415931) | 8 | 4 | 5 | 28853 | 19 | ||
| 53780 | 11895 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604X Keith St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017303.30396 | 2096401.31923 | 37.7372891970298 | -122.382641953956 | (37.7372891970298, -122.382641953956) | 10 | 3 | 8 | 58 | 1 | |||
| 54416 | 3477 | DPW Maintained 1 | Quercus spp :: Oak 254 | 301X Cargo Way | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/1999 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | ||
| 54513 | 20559 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1305X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10 | 5984811.9199471 | 2106303.0061321 | 37.7626280043626 | -122.495708151398 | (37.7626280043626, -122.495708151398) | 1 | 8 | 3 | 56 | 35 | |||
| 54553 | 212136 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500x Miramar Ave | 9 | Median : Yard | Tree | DPW 1 | 4 | 5995379.948 | 2093237.13475 | 37.7273655928402 | -122.458211672546 | (37.7273655928402, -122.458211672546) | 9 | 7 | 4 | 28861 | 40 | ||||
| 54911 | 16498 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 305X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016898.45948 | 2098256.16023 | 37.7423598423185 | -122.384170835605 | (37.7423598423185, -122.384170835605) | 10 | 3 | 8 | 58 | 1 | |||
| 55015 | 20969 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2002X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
| 55309 | 30017 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750X San Jose Ave | 9 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005697.924 | 2098794.21109 | 37.743211575362 | -122.422937177222 | (37.743211575362, -122.422937177222) | 2 | 7 | 7 | 28859 | 2 | ||
| 55608 | 43458 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999537.11613 | 2091248.65338 | 37.72214368387 | -122.443697599487 | (37.72214368387, -122.443697599487) | 9 | 7 | 6 | 28861 | 25 | |
| 55736 | 122871 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2900X Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 3x3 | 5996824 | 2087575 | 37.7119015691826 | -122.452811110275 | (37.7119015691826, -122.452811110275) | 9 | 7 | 6 | 28861 | 25 | ||||
| 55864 | 3937 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100X Castro St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2x2 | 6002197.8017 | 2107402.73286 | 37.7666503927258 | -122.435655408473 | (37.7666503927258, -122.435655408473) | 15 | 5 | 5 | 28862 | 3 | |||
| 56371 | 112316 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2500X Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 08/06/2015 09:14:00 AM | 3 | 3x3 | 5998526.38122 | 2088580.63045 | 37.7147602066992 | -122.446999548499 | (37.7147602066992, -122.446999548499) | 9 | 7 | 6 | 28861 | 25 | ||
| 57533 | 2823 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100X California St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6008783.89307 | 2116347.56178 | 37.7915826512753 | -122.413507861114 | (37.7915826512753, -122.413507861114) | 5 | 1 | 10 | 28857 | 21 | |||
| 57731 | 7796 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601 Franklin St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006248.95348 | 2112141.93432 | 37.7798923726783 | -122.421979848041 | (37.7798923726783, -122.421979848041) | 7 | 9 | 11 | 28852 | 41 |
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) );