trees
27,746 rows where qCaretaker_id = 1 sorted by Police Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6995 | 9735 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 727X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6005653.63672 | 2112026.60995 | 37.7795421273786 | -122.424031111893 | (37.7795421273786, -122.424031111893) | 7 | 9 | 11 | 28852 | 41 | |||
7015 | 23789 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1100X Webster St | 4 | Median : Cutout | Tree | DPW 1 | 20 | 20 | 6003791.7059 | 2112684.1999 | 37.7812424081927 | -122.430519258933 | (37.7812424081927, -122.430519258933) | 15 | 9 | 11 | 29490 | 41 | |||
7085 | 260395 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
7103 | 244384 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 257 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6005748.2149 | 2110309.2015 | 37.7748318806023 | -122.423581789147 | (37.7748318806023, -122.423581789147) | 7 | 9 | 11 | 28852 | 10 | |||
7124 | 240695 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 156 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/31/2018 12:00:00 AM | 3 | Width 3ft | 6004515.89032 | 2108795.08829 | 37.7706048583673 | -122.42773675377 | (37.7706048583673, -122.42773675377) | 7 | 9 | 11 | 28852 | 10 | |
7199 | 5759 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 27 | 3X3 | 6003976.63728 | 2108405.62354 | 37.7695049641016 | -122.42957425574 | (37.7695049641016, -122.42957425574) | 7 | 9 | 5 | 29492 | 10 | |||
7279 | 12251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 512 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/24/2014 12:00:00 AM | 3 | 3X3 | 6005037.9059 | 2110678.2828 | 37.77580516874 | -122.426065177531 | (37.77580516874, -122.426065177531) | 7 | 9 | 11 | 28852 | 10 | ||
7307 | 17780 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1791 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005376.6767315 | 2115458.3552628 | 37.7889492101001 | -122.425233498798 | (37.7889492101001, -122.425233498798) | 13 | 9 | 1 | 28858 | 41 | |||
7342 | 26844 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | Permit Number 775213 | 6006969.72882 | 2110998.7322 | 37.7767940394414 | -122.419405236481 | (37.7767940394414, -122.419405236481) | 7 | 9 | 9 | 28852 | 36 | ||
7388 | 29904 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 Fell St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6004657.19551 | 2110576.88809 | 37.7755052392808 | -122.427374927138 | (37.7755052392808, -122.427374927138) | 7 | 9 | 11 | 28852 | 10 | ||||||
7398 | 13267 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000572.6787 | 2119285.0637 | 37.7991837803388 | -122.442129440006 | (37.7991837803388, -122.442129440006) | 13 | 9 | 1 | 57 | 17 | |
7419 | 9585 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1291 Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/2004 12:00:00 AM | 3 | 3X3 | 6003420.42274 | 2112074.32264 | 37.7795467977493 | -122.431760157134 | (37.7795467977493, -122.431760157134) | 15 | 9 | 11 | 29490 | 41 | ||
7547 | 119857 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 401 Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
7548 | 6171 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1075 Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | 7 | 9 | 11 | 28858 | 41 | |||
7614 | 6251 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1315 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004480.8051 | 2113256.6545 | 37.7828532389184 | -122.428176124144 | (37.7828532389184, -122.428176124144) | 7 | 9 | 11 | 29490 | 41 | |||
7650 | 28640 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300 Webster St | 2 | Median : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 20 | 6003714.7015 | 2113244.5448 | 37.7827766127993 | -122.430825656777 | (37.7827766127993, -122.430825656777) | 15 | 9 | 11 | 29490 | 41 | ||
7683 | 38 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 775 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6003673.2104 | 2107707.71827 | 37.7675715008638 | -122.430573990716 | (37.7675715008638, -122.430573990716) | 7 | 9 | 5 | 28862 | 3 | |||
7742 | 21626 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1610 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004833.69671 | 2114745.44523 | 37.7869610478907 | -122.427061339905 | (37.7869610478907, -122.427061339905) | 13 | 9 | 11 | 28858 | 27 | |||
7894 | 7178 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 837 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/24/2020 11:28:00 AM | 12 | 6x6 | 6003458.7438 | 2111235.1971 | 37.7772449397217 | -122.431567664925 | (37.7772449397217, -122.431567664925) | 15 | 9 | 11 | 29492 | 10 | ||
7932 | 18681 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 155 Richardson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3X3 | 5999165.53622 | 2119642.20723 | 37.8000841081609 | -122.447024330929 | (37.8000841081609, -122.447024330929) | 13 | 9 | 1 | 57 | 17 | |||
7955 | 6258 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1338X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/2010 12:00:00 AM | 3 | 3X3 | 6004383.57489 | 2113288.83653 | 37.7829361010006 | -122.428514794701 | (37.7829361010006, -122.428514794701) | 7 | 9 | 11 | 29490 | 41 | ||
8043 | 23950 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2400X Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003173.29907 | 2115903.30394 | 37.7900462027047 | -122.432888683778 | (37.7900462027047, -122.432888683778) | 13 | 9 | 1 | 29490 | 27 | |
8126 | 28056 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 33 Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4X4 | 6005944.78414 | 2109618.42708 | 37.7729462740038 | -122.42285271058 | (37.7729462740038, -122.42285271058) | 7 | 9 | 11 | 28852 | 10 | |||
8212 | 138185 | DPW Maintained 1 | Prunus subhirtella 'Pendula' :: Weeping Cherry 235 | 1865 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6003940.6794 | 2114739.7851 | 37.786894968468 | -122.43015057261 | (37.786894968468, -122.43015057261) | 13 | 9 | 11 | 29490 | 27 | |||
8274 | 2988 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2266X California St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003528.90719 | 2115622.95537 | 37.7892965998021 | -122.431638286196 | (37.7892965998021, -122.431638286196) | 13 | 9 | 1 | 29490 | 27 | |||
8328 | 141427 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 306 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | Width 0ft | 6005914.5406 | 2110724.5553 | 37.7759817285641 | -122.423035961371 | (37.7759817285641, -122.423035961371) | 7 | 9 | 11 | 28852 | 10 | |||
8341 | 16938 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 595X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004175.1129 | 2110087.9596 | 37.7741354848182 | -122.429007699423 | (37.7741354848182, -122.429007699423) | 7 | 9 | 11 | 28852 | 10 | |||
8371 | 12302 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 945X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004623.92182 | 2111884.23425 | 37.7790930089412 | -122.427583190964 | (37.7790930089412, -122.427583190964) | 7 | 9 | 11 | 29490 | 41 | |||
8395 | 244281 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 595 Oak St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6004143 | 2110087 | 37.7741310322057 | -122.429118715156 | (37.7741310322057, -122.429118715156) | 7 | 9 | 11 | 28852 | 10 | |||
8442 | 43966 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 08/24/2000 12:00:00 AM | 9 | Permit Number 43534 | 6006884.39072 | 2112892.55093 | 37.7819892007742 | -122.419834861512 | (37.7819892007742, -122.419834861512) | 7 | 9 | 9 | 28852 | 36 | |
8607 | 23185 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 560X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6006458.921066 | 2112191.041059 | 37.7800390474075 | -122.421256963785 | (37.7800390474075, -122.421256963785) | 7 | 9 | 11 | 28852 | 41 | |||
8764 | 13266 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000592.3683 | 2119282.3787 | 37.7991775301158 | -122.442061114605 | (37.7991775301158, -122.442061114605) | 13 | 9 | 1 | 57 | 17 | |
8801 | 138109 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6004876.0712 | 2114750.6655 | 37.7869777775164 | -122.426915105637 | (37.7869777775164, -122.426915105637) | 13 | 9 | 11 | 28858 | 27 | |||
8911 | 87411 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 898X Ellis St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006570.640875 | 2113589.260791 | 37.7838845156579 | -122.420969775985 | (37.7838845156579, -122.420969775985) | 7 | 9 | 9 | 28858 | 36 | |||
8972 | 23214 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006727.4886023 | 2112541.6876005 | 37.7810169750537 | -122.42035276087 | (37.7810169750537, -122.42035276087) | 7 | 9 | 9 | 28852 | 36 | ||
9007 | 23899 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1600X Webster St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 6 | 6003605.1476962 | 2114190.7261663 | 37.785368381567 | -122.431272227533 | (37.785368381567, -122.431272227533) | 13 | 9 | 11 | 29490 | 13 | |||
9076 | 9908 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1809 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 6x6 | 6005225.98494 | 2115998.17525 | 37.7904229062421 | -122.425793311632 | (37.7904229062421, -122.425793311632) | 13 | 9 | 1 | 28858 | 27 | |||
9178 | 10645 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 906 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6003455.1435 | 2110726.9996 | 37.7758493511517 | -122.431543829861 | (37.7758493511517, -122.431543829861) | 15 | 9 | 11 | 29492 | 10 | |||
9188 | 250134 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2550x Lyon St | 2 | Median : Yard | Tree | DPW 1 | 15 | 5999224.86929 | 2117537.18532 | 37.7943076699218 | -122.446667476532 | (37.7943076699218, -122.446667476532) | 13 | 9 | 1 | 57 | 27 | ||||
9194 | 260391 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
9233 | 17847 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2082 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003983.5737 | 2115317.762 | 37.7884843766402 | -122.430043414021 | (37.7884843766402, -122.430043414021) | 13 | 9 | 11 | 29490 | 27 | |||
9366 | 13179 | DPW Maintained 1 | Tristania conferta :: 61 | 1976 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/1997 12:00:00 AM | 14 | 3X3 | 6002902.1538 | 2119607.7128 | 37.8002021701058 | -122.434091743886 | (37.8002021701058, -122.434091743886) | 13 | 9 | 1 | 57 | 17 | ||
9369 | 130083 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 633 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2016 11:15:00 AM | 2 | Width 4ft | 6006236.08792 | 2112182.41564 | 37.7800027989227 | -122.422027232369 | (37.7800027989227, -122.422027232369) | 7 | 9 | 11 | 28852 | 41 | ||
9471 | 119842 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 350 Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
9640 | 17196 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2235X Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 24 | 20 | 6004629.78741 | 2116932.39582 | 37.792954330542 | -122.427922714666 | (37.792954330542, -122.427922714666) | 13 | 9 | 1 | 28858 | 27 | |||
9706 | 260678 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601x McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006263 | 2112118 | 37.7798274470499 | -122.421929554146 | (37.7798274470499, -122.421929554146) | 7 | 9 | 11 | 28852 | 10 | ||||
9753 | 4511 | DPW Maintained 1 | Ficus macrophylla :: Morton Bay Fig 322 | 20X Cleary Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.426426402111 | (37.7846101140023, -122.426426402111) | 13 | 9 | 11 | 28858 | 41 | |||
9794 | 26872 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 969 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003239 | 2110629 | 37.7755680153799 | -122.432284524402 | (37.7755680153799, -122.432284524402) | 15 | 9 | 11 | 29492 | 10 | |||
9867 | 18856 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2201 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004191.66186 | 2115995.22985 | 37.79035631503 | -122.429371791378 | (37.79035631503, -122.429371791378) | 13 | 9 | 1 | 29490 | 27 | |||
9875 | 23182 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 3 | 3X3 | 6006776.0786915 | 2112192.9314348 | 37.7800621132124 | -122.42015990463 | (37.7800621132124, -122.42015990463) | 7 | 9 | 9 | 28852 | 36 | ||
9948 | 16864 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 230 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005857.5291 | 2110371.9412 | 37.7750103183132 | -122.423208108745 | (37.7750103183132, -122.423208108745) | 7 | 9 | 11 | 28852 | 10 | |||
10018 | 259741 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 639 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/11/2019 12:00:00 AM | 3 | 6004752.1306 | 2111210.76413 | 37.7772510764575 | -122.427091682563 | (37.7772510764575, -122.427091682563) | 7 | 9 | 11 | 28852 | 10 | ||
10053 | 23735 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 805 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2016 12:00:00 AM | 12 | 4X4 | 6003900.7925 | 2111534.0109 | 37.7780904537405 | -122.430059798517 | (37.7780904537405, -122.430059798517) | 15 | 9 | 11 | 29492 | 41 | ||
10336 | 244255 | DPW Maintained 1 | Chitalpa tashkentensis :: 114 | 200x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005643.2766 | 2110040.2561 | 37.7740874977816 | -122.423925664351 | (37.7740874977816, -122.423925664351) | 7 | 9 | 11 | 28852 | 10 | |||
10459 | 16731 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 19X Hollis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6003892.01293 | 2113485.99196 | 37.7834496108007 | -122.4302294651 | (37.7834496108007, -122.4302294651) | 7 | 9 | 11 | 29490 | 41 | |||
10515 | 7366 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2360 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002774.54957 | 2116438.38146 | 37.7914927640347 | -122.434306592692 | (37.7914927640347, -122.434306592692) | 13 | 9 | 1 | 29490 | 27 | |||
10590 | 13232 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2301 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 10 | 3X3 | 6001301 | 2119283 | 37.7992195934801 | -122.439609056557 | (37.7992195934801, -122.439609056557) | 13 | 9 | 1 | 57 | 17 | ||
10625 | 8037 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/18/2015 12:00:00 AM | 6 | 3X3 | 6005159.5163 | 2111612.2048 | 37.7783763628277 | -122.425710983373 | (37.7783763628277, -122.425710983373) | 7 | 9 | 11 | 28852 | 10 | ||
10644 | 260392 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
10676 | 26756 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1399 Post St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6005569.26951 | 2114444.1495 | 37.7861753317646 | -122.424494982868 | (37.7861753317646, -122.424494982868) | 13 | 9 | 1 | 28858 | 41 | |||
10697 | 261213 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1805 Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4X4 | 6002990.933 | 2114560.8146 | 37.7863497234839 | -122.433423679579 | (37.7863497234839, -122.433423679579) | 13 | 9 | 11 | 29490 | 27 | ||||
10966 | 109166 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 5 | Median : Cutout | Tree | DPW 1 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | ||||
11077 | 141992 | DPW Maintained 1 | Tristania conferta :: 61 | 818 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/31/1991 12:00:00 AM | 9 | Width 0ft | 6003994.291 | 2111559.6951 | 37.7781662710742 | -122.429738185966 | (37.7781662710742, -122.429738185966) | 7 | 9 | 11 | 29490 | 41 | ||
11081 | 17829 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1955 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004588.8583705 | 2115348.8927865 | 37.7886041154805 | -122.427951442059 | (37.7886041154805, -122.427951442059) | 13 | 9 | 11 | 28858 | 27 | |||
11420 | 261214 | DPW Maintained 1 | Ficus rubiginosa :: Port Jackson Fig 339 | 1805 Fillmore St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4X4 | 6002990.933 | 2114560.8146 | 37.7863497234839 | -122.433423679579 | (37.7863497234839, -122.433423679579) | 13 | 9 | 11 | 29490 | 27 | ||||
11520 | 23902 | DPW Maintained 1 | Prunus subhirtella 'Pendula' :: Weeping Cherry 235 | 1600X Webster St | 5 | Median : Cutout | Tree | DPW 1 | 8 | 20 | 6003560.0188 | 2114334.411 | 37.7857603463241 | -122.431438620741 | (37.7857603463241, -122.431438620741) | 13 | 9 | 11 | 29490 | 13 | |||
11646 | 23200 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 520X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006725.22564 | 2112390.29825 | 37.7806011691535 | -122.420349841196 | (37.7806011691535, -122.420349841196) | 7 | 9 | 9 | 28852 | 36 | |||
11729 | 244288 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005589.8116 | 2110006.6495 | 37.7739922036556 | -122.424108218812 | (37.7739922036556, -122.424108218812) | 7 | 9 | 11 | 28852 | 10 | |||
11761 | 10268 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215X Haight St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 6005053.18335 | 2109512.97249 | 37.7726063733294 | -122.425929359246 | (37.7726063733294, -122.425929359246) | 7 | 9 | 5 | 28852 | 10 | ||||
11809 | 7237 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1065 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003359.4574 | 2111944.18191 | 37.7791860077197 | -122.431961766737 | (37.7791860077197, -122.431961766737) | 15 | 9 | 11 | 29490 | 41 | |||
11930 | 4545 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
12006 | 17808 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1900X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6004382.775 | 2115429.5647 | 37.7888139592602 | -122.4286702126 | (37.7888139592602, -122.4286702126) | 13 | 9 | 11 | 28858 | 27 | |||
12085 | 9686 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6005996.09112 | 2110833.49174 | 37.7762854431535 | -122.422761599875 | (37.7762854431535, -122.422761599875) | 7 | 9 | 11 | 28852 | 10 | |||
12168 | 16904 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 436 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2019 12:00:00 AM | 0 | 5x5 | 6004894.34322 | 2110238.30688 | 37.7745889872376 | -122.426530461628 | (37.7745889872376, -122.426530461628) | 7 | 9 | 11 | 28852 | 10 | ||
12176 | 8052 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 604 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | 7 | 9 | 11 | 28852 | 41 | |||
12245 | 2989 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2266X California St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 09:54:00 AM | 3 | 3X3 | 6003501.08129 | 2115612.2522 | 37.789265634363 | -122.431733795974 | (37.789265634363, -122.431733795974) | 13 | 9 | 1 | 29490 | 27 | ||
12247 | 16942 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 599X Oak St | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
12342 | 25 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 736 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/17/1995 12:00:00 AM | 0 | 6003903.5250844 | 2107767.6234363 | 37.7677490306877 | -122.429781635515 | (37.7677490306877, -122.429781635515) | 7 | 9 | 5 | 28862 | 3 | |||
12388 | 6901 | DPW Maintained 1 | Tristania conferta :: 61 | 333 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/14/2015 12:30:00 PM | 3 | 3x3 | 6005680.1943 | 2110643.4354 | 37.775745766228 | -122.423840858061 | (37.775745766228, -122.423840858061) | 7 | 9 | 11 | 28852 | 10 | ||
12603 | 18228 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1737-1795 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2004 12:00:00 AM | 12 | 3X3 | 6003682.1522 | 2114179.2812 | 37.7853413201744 | -122.431004998109 | (37.7853413201744, -122.431004998109) | 13 | 9 | 11 | 29490 | 13 | ||
12724 | 14708 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 835 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | 7 | 9 | 11 | 28852 | 41 | |||
12768 | 5972 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1990 12:00:00 AM | 8 | 3X3 | 6003044.0843 | 2112751.363 | 37.7813844410266 | -122.433110458849 | (37.7813844410266, -122.433110458849) | 15 | 9 | 11 | 29490 | 41 | ||
12814 | 7340 | DPW Maintained 1 | Ficus macrophylla :: Morton Bay Fig 322 | 2126 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/2017 12:00:00 AM | 3 | 3X3 | 6002883.51227 | 2115702.89267 | 37.7894794841288 | -122.433876990144 | (37.7894794841288, -122.433876990144) | 13 | 9 | 1 | 29490 | 27 | ||
12842 | 23729 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 800X Webster St | 4 | Median : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 6 | 6003943.6522 | 2111620.2321 | 37.7783296231018 | -122.429917683229 | (37.7783296231018, -122.429917683229) | 7 | 9 | 11 | 29490 | 41 | ||
13007 | 23212 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 595X Van Ness Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6006669.9178 | 2112533.82047 | 37.7809921295165 | -122.420551368612 | (37.7809921295165, -122.420551368612) | 7 | 9 | 11 | 28852 | 41 | |||
13073 | 16756 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1432X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6002754.8302515 | 2113154.9795466 | 37.7824762583226 | -122.434139998025 | (37.7824762583226, -122.434139998025) | 15 | 9 | 11 | 29490 | 41 | |||
13137 | 2961 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2092 California St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6004397.71473 | 2115760.22352 | 37.7897227105129 | -122.428642103302 | (37.7897227105129, -122.428642103302) | 13 | 9 | 1 | 28858 | 27 | |||
13229 | 21689 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1881 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6003724.339 | 2114539.1952 | 37.7863319437467 | -122.43088473956 | (37.7863319437467, -122.43088473956) | 13 | 9 | 11 | 29490 | 13 | |||
13273 | 4537 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 65 Cleary Ct | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/1994 12:00:00 AM | 12 | 3X3 | 6004884.4780546 | 2113657.3543136 | 37.7839762927328 | -122.426808129214 | (37.7839762927328, -122.426808129214) | 7 | 9 | 11 | 28858 | 41 | ||
13346 | 261570 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1100 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/06/2001 12:00:00 AM | 6003395 | 2112193 | 37.7798712150659 | -122.43185658143 | (37.7798712150659, -122.43185658143) | 15 | 9 | 11 | 29490 | 41 | ||||
13372 | 249467 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000x Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6006503.72956 | 2113992.67034 | 37.7849884074321 | -122.421229920427 | (37.7849884074321, -122.421229920427) | 13 | 9 | 11 | 28858 | 36 | |||
13447 | 6878 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 250 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/28/1994 12:00:00 AM | 6 | 3X3 | 6006200.5661 | 2110766.80377 | 37.7761138687045 | -122.422049524766 | (37.7761138687045, -122.422049524766) | 7 | 9 | 11 | 28852 | 10 | ||
13704 | 9704 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 499X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 16 | 3x3 | 6005878.26798 | 2111295.24256 | 37.7775466504055 | -122.423202013315 | (37.7775466504055, -122.423202013315) | 7 | 9 | 11 | 28852 | 10 | ||
13855 | 260394 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
13887 | 2618 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.7877691866782 | -122.426932689756 | (37.7877691866782, -122.426932689756) | 13 | 9 | 11 | 28858 | 27 | |||
14044 | 262450 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2001 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003839 | 2115372 | 37.7886251115209 | -122.43054748798 | (37.7886251115209, -122.43054748798) | 13 | 9 | 1 | 29490 | 27 | ||||
14066 | 141995 | DPW Maintained 1 | Tristania conferta :: 61 | 818 WEBSTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/1999 12:00:00 AM | 5 | Width 0ft | 6003983.7554 | 2111636.8614 | 37.778377554053 | -122.429780137803 | (37.778377554053, -122.429780137803) | 7 | 9 | 11 | 29490 | 41 | ||
14067 | 17211 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 221X Olive St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006417.7103 | 2113696.81595 | 37.7841712140925 | -122.421506501194 | (37.7841712140925, -122.421506501194) | 7 | 9 | 11 | 28858 | 41 | |||
14092 | 23172 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 214 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006926.9126711 | 2111261.9734357 | 37.7775144249112 | -122.419572031751 | (37.7775144249112, -122.419572031751) | 7 | 9 | 9 | 28852 | 36 | |||
14102 | 10249 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 115 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/1996 12:00:00 AM | 20 | 3X3 | 6005554.00593 | 2109582.93221 | 37.7728267566811 | -122.424201936088 | (37.7728267566811, -122.424201936088) | 7 | 9 | 11 | 28852 | 10 |
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) );