trees

163,064 rows where qCaretaker_id = 2 sorted by SiteOrder

✎ View and edit SQL

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)
99 255073 Private 9 Tree(s) :: 17 173R Glenview Dr   Back Yard : Yard Tree Private 2                              
162 105806 Undocumented 4 Tree(s) :: 17 1248X ANZA ST   Sidewalk: Curb side : Cutout Tree Private 2       6x3   5994834 2112130 37.7792092085373 -122.461468091676 (37.7792092085373, -122.461468091676) 11 6 2 54 11
165 104843 Permitted Site 7 :: 45 1320 21st Ave   Sidewalk: Curb side : Cutout Tree Private 2           5989622 2106334.7 37.7629955389606 -122.479074319647 (37.7629955389606, -122.479074319647) 1 8 3 56 35
170 108637 Property Tree 8 Pinus radiata :: Monterey Pine 15 15 TUCKER AVE   Back Yard : Yard Tree Private 2           6011049.2 2088423.2 37.7150354478954 -122.403704200211 (37.7150354478954, -122.403704200211) 9 7 8 309 39
227 102275 Property Tree 8 Tree(s) :: 17 267 Topaz Way   Back Yard : Yard Landscaping Private 2           6001225.6 2097744.2 37.7400751189117 -122.438326054857 (37.7400751189117, -122.438326054857) 2 7 5 63 7
361 107141 Undocumented 4 Tree(s) :: 17 3498 16TH ST   Sidewalk: Curb side : Cutout Tree Private 2           6003565.7 2106565.7 37.764429704069 -122.430864344516 (37.764429704069, -122.430864344516) 15 4 5 28862 3
391 104857 DPW Maintained 1 :: 45 2555 46th Ave   Sidewalk: Curb side : Cutout Landscaping Private 2           5982069.8 2097707.6 37.7388664658919 -122.504555139124 (37.7388664658919, -122.504555139124) 1 8 3 29491 35
533 257925 Property Tree 8 Pinus radiata :: Monterey Pine 15 274 Staples Ave   Back Yard : Yard Tree Private 2       10x10   5998272.17919 2093819.44967 37.7291302611298 -122.448255187535 (37.7291302611298, -122.448255187535) 9 7 4 28861 40
980 96180 Permitted Site 7 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158     Unaccepted Street : Cutout Tree Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767812                    
1105 106501 Undocumented 4 Tree(s) :: 17 1266 09TH AVE   Sidewalk: Curb side : Cutout Tree Private 2       3x6   5993358 2106830.8 37.764573953722 -122.46618893715 (37.764573953722, -122.46618893715) 11 8 11 56 12
1361 105851 Undocumented 4 Tree(s) :: 17 2590 16TH AVE   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991465.4 2097806.4 37.7396859298071 -122.472077039908 (37.7396859298071, -122.472077039908) 1 8 4 29491 40
1558 256904 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1571 37th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/03/2019 12:00:00 AM 3 3x3 Permit Number 782743 5984651.59496 2104500.79365 37.7576702424259 -122.496129679735 (37.7576702424259, -122.496129679735) 1 8 3 56 35
1694 100166 Property Tree 8 Salix spp :: Willow 203 2340 Twin Peaks Blvd   Front Yard : Yard Tree Private 2         Permit Number 769026                    
2116 108701 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 478 30th St   Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774626 6003507.49152 2098366.33094 37.7419128730633 -122.43048058961 (37.7419128730633, -122.43048058961) 2 7 5 63 22
2238 88648 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 74 Carmelita St   Sidewalk: Curb side : Cutout Tree Private 2   08/05/2008 12:00:00 AM   3x3 Permit Number 51628 6002619 2108775 37.7704422164895 -122.434296675208 (37.7704422164895, -122.434296675208) 15 5 5 29492 9
2335 262272 Undocumented 4 Tree(s) :: 17 99X Glendale St   Unaccepted Street : Yard Tree Private 2       3x3   5999984 2103563 37.7559814441149 -122.443036761048 (37.7559814441149, -122.443036761048) 2 5 5 28862 38
2548 104858 DPW Maintained 1 :: 45 4205 24th St   Sidewalk: Property side : Cutout Landscaping Private 2           6001816 2101720.7 37.7510272133613 -122.436569249202 (37.7510272133613, -122.436569249202) 2 4 5 28862 22
2598 95032 - 12 Tree(s) :: 17 211 Maynard St   Front Yard : Cutout Landscaping Private 2           6004772 2093802 37.7294517978782 -122.425783519869 (37.7294517978782, -122.425783519869) 9 7 6 28861 5
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                    
2862 261320 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 872 Ingerson Ave   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014869 2089377 37.7178670406836 -122.390567842363 (37.7178670406836, -122.390567842363) 10 3 8 58 1
2911 258680 Undocumented 4 Potential Site :: Potential Site 48 2824 21st St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009247 2103976 37.7576392372832 -122.411031286576 (37.7576392372832, -122.411031286576) 2 4 7 28859 19
3226 107892 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 162 Brewster St   Front Yard : Cutout Tree Private 2   11/04/2014 12:00:00 AM 3 3x3 Permit Number 773952 6010231.01704 2099016.49618 37.7440766668365 -122.407278527778 (37.7440766668365, -122.407278527778) 2 7 7 28859 2
3289 262310 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1356 20th Ave   Sidewalk: Curb side : Cutout Tree Private 2   08/26/2016 12:00:00 AM       5989914.31197 2106134.19071 37.7624619657204 -122.478048663847 (37.7624619657204, -122.478048663847) 1 8 3 56 35
3380 261217 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 3400 Vicente St   : Cutout Tree Private 2 FUF     3x3   5982420.06104 2097439.60235 37.738151214353 -122.503324281602 (37.738151214353, -122.503324281602) 1 8 3 29491 35
3667 97254 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 601 Tompkins Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2011 12:00:00 AM     Permit Number 768271 6008616.2 2096553.7 37.7372238594213 -122.412688154144 (37.7372238594213, -122.412688154144) 10 7 7 28859 2
3681 106711 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3990 FOLSOM ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008366.1 2096547.2 37.7371919715517 -122.413552407719 (37.7371919715517, -122.413552407719) 2 7 7 28859 2
3740 102276 DPW Maintained 1 Tree(s) :: 17 279 Topaz Way   Back Yard : Yard Landscaping Private 2           6001205.6 2097796.6 37.7402178594385 -122.438398959733 (37.7402178594385, -122.438398959733) 2 7 5 63 7
3798 262575 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 141 Topaz Way   Front Yard : Yard Tree Private 2       3x3   6001722 2097902 37.7405366227001 -122.436621002014 (37.7405366227001, -122.436621002014) 2 7 5 63 7
3941 92078 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1151 Sutter St   Sidewalk: Curb side : Cutout Tree Private 2   06/22/2009 12:00:00 AM   3x3 Permit Number 52192 6007083 2115004 37.7877979108835 -122.419297592258 (37.7877979108835, -122.419297592258) 13 9 10 28858 21
3994 256688 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 1477 Green St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/21/2018 12:00:00 AM 3 3x3 Permit Number 782620                    
4231 261663 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 1099x Broadway   Sidewalk: Curb side : Cutout Tree Private 2   10/28/2020 12:00:00 AM 3 3x3   6008393 2118190 37.7966195766837 -122.414990814528 (37.7966195766837, -122.414990814528) 5 1 10 308 21
4377 88323 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 125 Lisbon St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51312 6003417 2092629 37.7261543381556 -122.430384225952 (37.7261543381556, -122.430384225952) 9 7 6 28861 5
4537 96174 Permitted Site 7 Malus sylvestris :: Apple 277     Unaccepted Street : Cutout Tree Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767807                    
4623 106966 Undocumented 4 Tree(s) :: 17 2391 47TH AVE   Sidewalk: Curb side : Cutout Tree Private 2           5981720.8 2098834.4 37.7419398125124 -122.505845312535 (37.7419398125124, -122.505845312535) 1 8 3 29491 35
4853 107519 Undocumented 4 Tree(s) :: 17 100x CHURCH ST   Sidewalk: Curb side : Cutout Tree Private 2           6004015.5 2108290.9 37.7691921614924 -122.429431648714 (37.7691921614924, -122.429431648714) 7 9 5 28862 3
5012 261384 Undocumented 4 Potential Site :: Potential Site 48 246 Leavenworth St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008558 2113314 37.7832405398106 -122.41407474629 (37.7832405398106, -122.41407474629) 7 10 9 28852 36
5227 96177 Permitted Site 7 Diospyros kaki :: Persimmon 288     Unaccepted Street : Cutout Tree Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767810                    
5239 112929 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
5290 89193 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
5320 88554 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 579 16th Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/24/2008 12:00:00 AM   3x3 Permit Number 51499 5990911.3 2111462.4 37.7771496035915 -122.474989443149 (37.7771496035915, -122.474989443149) 11 6 2 54 26
5429 116488 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2149 LYON ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999319 2116238 37.7907458271484 -122.446248274058 (37.7907458271484, -122.446248274058) 13 6 1 29490 31
5477 88381 Permitted Site 7 Maytenus boaria :: Mayten 58 423 16th Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51359 5990873.7 2112494.8 37.7799821106609 -122.475194900005 (37.7799821106609, -122.475194900005) 11 6 2 54 26
5724 87766 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 3896 22nd St   Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM   3x3 Permit Number 50469 6002488 2102987 37.7545423364482 -122.434335932006 (37.7545423364482, -122.434335932006) 2 4 5 28862 22
5768 87061 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52     unknown : Yard Tree Private 2       3x3 Permit Number 50003                    
6097 95161 Significant Tree 6 Acer palmatum :: Japanese Maple 216 2721 Pacific Ave   Front Yard : Yard Tree Private 2         Permit Number 54078 6001026.7 2116843.3 37.7925052022591 -122.440383162252 (37.7925052022591, -122.440383162252) 13 6 1 29490 27
6343 96176 Permitted Site 7 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158     Unaccepted Street : Cutout Tree Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767809                    
6402 94573 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3978 18th St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/20/2010 12:00:00 AM   3x3 Permit Number 53752 6003116 2105363 37.761101890414 -122.432333828196 (37.761101890414, -122.432333828196) 15 4 5 28862 3
6593 261297 Permitted Site 7 :: 45 3180 18th St   Sidewalk: Curb side : Cutout Landscaping Private 2   05/01/2013 12:00:00 AM 3     6008239.4944 2105648.95562 37.762176240156 -122.414634049312 (37.762176240156, -122.414634049312) 8 4 7 28859 19
6730 96175 Permitted Site 7 Malus sylvestris :: Apple 277     Unaccepted Street : Cutout Tree Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767808                    
6758 95372 Significant Tree 6 Pinus radiata :: Monterey Pine 15 180 Yukon St   Back Yard : Cutout Tree Private 2     15   Permit Number 767755 6000174.3 2103956.9 37.7570738455347 -122.442406920559 (37.7570738455347, -122.442406920559) 2 4 5 28862 3
6813 256911 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 26 Lily St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3 3x3 Permit Number 782765                    
6833 109426 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 132 Locust St   Sidewalk: Curb side : Cutout Tree Private 2   02/13/2015 12:00:00 AM 3     5997544.3 2115966.4 37.7898985728773 -122.452369007612 (37.7898985728773, -122.452369007612) 11 6 1 54 31
7105 262039 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1251 Hyde St   Sidewalk: Curb side : Cutout Tree Private 2   04/16/2020 12:00:00 AM 3 3x3 Permit Number 783100 6007540 2116706 37.7924969115625 -122.417837146347 (37.7924969115625, -122.417837146347) 5 1 10 28858 21
7291 105130 Significant Tree 6 Tree(s) :: 17 4045 MORAGA ST   Sidewalk: Property side : Yard Tree Private 2           5981665.2 2103465.9 37.7546533409301 -122.506380933635 (37.7546533409301, -122.506380933635) 1 8 3 56 35
7310 96412 Significant Tree 6 Acer palmatum :: Japanese Maple 216 185 Chilton Ave   Front Yard : Yard Tree Private 2   05/18/2011 12:00:00 AM     Permit Number 767805 6001587.1 2095138.7 37.732941575251 -122.436889661497 (37.732941575251, -122.436889661497) 9 7 5 63 40
7333 262326 Undocumented 4 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 10 Roemer Way   Sidewalk: Property side : Cutout Tree Private 2       3x3   5998623 2086576 37.7092614661016 -122.446521459005 (37.7092614661016, -122.446521459005) 9 7 6 28861 5
7665 107118 Undocumented 4 Tree(s) :: 17 49 Elsie St   Sidewalk: Curb side : Cutout Tree Private 2   07/31/2014 12:00:00 AM   6x3 Permit Number 773429 6007534.56738 2099145.89717 37.7442806914439 -122.41661143894 (37.7442806914439, -122.41661143894) 2 7 7 28859 2
7770 98170 Significant Tree 6 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 2324 Sacramento St   Front Yard : Yard Tree Private 2   12/22/2011 12:00:00 AM 3   Permit Number 768454 6003670.2 2115963.1 37.7902385582714 -122.431173718492 (37.7902385582714, -122.431173718492) 13 9 1 29490 27
8281 87805 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 21 Mallorca Way   Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50570 6001886.8 2119949.6 37.8010832252731 -122.437629755692 (37.8010832252731, -122.437629755692) 13 9 1 57 17
8305 86762 Permitted Site 7 Tree(s) :: 17 500 Brotherhood Way   unknown : Yard Tree Private 2   10/04/2007 12:00:00 AM     Permit Number 49739 5992573.4 2087955 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031) 9 8 6 64 24
8362 96178 Permitted Site 7 Citrus aurantifolia 'Bearss' :: Seedless Lime 290     Unaccepted Street : Cutout Tree Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767810                    
8384 104821 Undocumented 4 Ficus nitida :: Laurel Fig 53 2173 15TH ST   Sidewalk: Curb side : Cutout Tree Private 2     20     6003063.7 2107068.1 37.7657807169148 -122.432636512343 (37.7657807169148, -122.432636512343) 15 5 5 28862 3
8520 108716 Permitted Site 7 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 201 Randall St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773302 6004213.21698 2097517.41416 37.7396218942487 -122.427979939698 (37.7396218942487, -122.427979939698) 2 7 5 63 7
8544 256668 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1835 Hyde St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/2018 12:00:00 AM 3 3x3 Permit Number 782601                    
8593 91087 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 134 Ralston St   Sidewalk: Curb side : Cutout Tree Private 2   12/31/2008 12:00:00 AM   3x3 Permit Number 51982 5992207 2088764 37.7149006256244 -122.46885508368 (37.7149006256244, -122.46885508368) 9 8 6 64 24
8599 262043 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 245 11th St   : Cutout Tree Private 2 FUF 04/14/2020 12:00:00 AM 3   Permit Number 785251 6008265.74007 2109435.35593 37.7725742877847 -122.414811260337 (37.7725742877847, -122.414811260337) 8 2 9 28853 34
8700 106117 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 405 Lisbon St   Sidewalk: Curb side : Cutout Tree Private 2   03/24/2014 12:00:00 AM   3x3 Permit Number 772749 6002458.5 2091056.7 37.7217828139374 -122.433585385445 (37.7217828139374, -122.433585385445) 9 7 6 28861 5
8887 261586 Undocumented 4 Calocedrus decurrens :: Incense Cedar 206 20 Aptos Ave   Sidewalk: Property side : Yard Tree Private 2       3x3   5993103 2094790 37.7314982775013 -122.466195816439 (37.7314982775013, -122.466195816439) 9 8 4 59 40
8975 256665 Permitted Site 7 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 1381 Filbert St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/2018 12:00:00 AM 3 5x5 Permit Number 782595 6006338.70929 2119347.35531 37.7996817310416 -122.422181395696 (37.7996817310416, -122.422181395696) 13 9 1 28858 32
9277 85291 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 7350 Geary Blvd   Sidewalk: Curb side : Cutout Tree Private 2   07/24/2007 12:00:00 AM 2 4x72 Permit Number 49578 5984127.30348 2112512.4695 37.779637298343 -122.498534651264 (37.779637298343, -122.498534651264) 11 6 2 55 26
9283 94134 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 18 Nebraska St   Sidewalk: Curb side : Cutout Tree Private 2   06/11/2010 12:00:00 AM   3x3 Permit Number 53498 6009291 2097948 37.7410901551317 -122.410453476975 (37.7410901551317, -122.410453476975) 10 7 7 28859 2
9358 252934 DPW Maintained 1 Olea europaea :: Olive Tree 9 78 Edgar Ave   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997141 2091229 37.7219527643602 -122.451978930217 (37.7219527643602, -122.451978930217) 9 8 6 28861 24
9573 108831 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 46 Ney St   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 774658 6003763.1265 2093992.42876 37.7299176091889 -122.429284866217 (37.7299176091889, -122.429284866217) 9 7 6 28861 5
9674 97174 Significant Tree 6 Tristaniopsis laurina :: Swamp Myrtle 1 26 Gilbert St   Sidewalk: Property side : Cutout Tree Private 2 FUF         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458) 14 2 9 28853 34
10067 88529 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14     Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51479                    
10084 91045 Permitted Site 7 Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 1100X Chestnut St   Sidewalk: Curb side : Cutout Tree Private 2   01/09/2006 12:00:00 AM   3x3 Permit Number 48418 6006545 2120445 37.8027072182013 -122.42154555229 (37.8027072182013, -122.42154555229) 5 9 1 28858 32
10118 108815 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 474 Munich St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774652 6003779.44726 2089723.38143 37.7181966752665 -122.428924204145 (37.7181966752665, -122.428924204145) 9 7 6 28861 5
10126 88578 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1799 Cabrillo St   Sidewalk: Curb side : Cutout Tree Private 2   07/31/2008 12:00:00 AM 1 3x3 Permit Number 51517 5990110.26399 2110629.43192 37.7748160474001 -122.477699547866 (37.7748160474001, -122.477699547866) 11 6 2 55 26
10379 95953 Significant Tree 6 Tree(s) :: 17 499 Buena Vista East Ave   Front Yard : Yard Tree Private 2   03/18/2011 12:00:00 AM 21   Permit Number 57015 6000177 2107098 37.7656986843565 -122.442623109531 (37.7656986843565, -122.442623109531) 15 5 5 29492 3
10409 256902 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 2051 34th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2018 12:00:00 AM 3 3x3 Permit Number 782737 5985693.46852 2101265.2111 37.7488471905551 -122.492288254945 (37.7488471905551, -122.492288254945) 1 8 3 29491 35
10436 105254 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 130 GONZALEZ DR   Front Yard : Yard Tree Private 2     2     5990327 2090136 37.7185590045312 -122.47545320092 (37.7185590045312, -122.47545320092) 1 8 4 64 14
10600 254532 Permitted Site 7 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 154 Arleta Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/2018 12:00:00 AM 3 3x3 Permit Number 781436                    
10957 253622 DPW Maintained 1 Pittosporum spp :: Pittosporum spp 170 300x Naglee Ave   Unaccepted Street : Yard Tree Private 2                              
11017 88581 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 515 21st Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/31/2008 12:00:00 AM 5 3x3 Permit Number 51523 5989364.70117 2111797.63767 37.777980320812 -122.480364100125 (37.777980320812, -122.480364100125) 11 6 2 55 26
11108 86883 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 550 Jersey St   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49808 6001589 2101474 37.750336931821 -122.43733657342 (37.750336931821, -122.43733657342) 2 4 5 28862 22
11448 96234 Permitted Site 7 Tree(s) :: 17     Sidewalk: Curb side : Cutout Landscaping Private 2   04/15/2011 12:00:00 AM     Permit Number 767856                    
11572 96179 Permitted Site 7 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158     Unaccepted Street : Cutout Tree Private 2       3x3 Permit Number 767811                    
11682 89044 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 44 Surrey St   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51783 6002618 2096049 37.7354995892493 -122.433390603486 (37.7354995892493, -122.433390603486) 2 7 5 63 7
11701 87286 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1272 42nd Ave   Sidewalk: Property side : Yard Tree Private 2   03/18/2007 12:00:00 AM     Permit Number 50303 5983096.8 2106514.6 37.7631083916796 -122.501655692289 (37.7631083916796, -122.501655692289) 1 8 3 56 35
12063 95300 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 701 Golden Gate Ave   Front Yard : Yard Tree Private 2   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617 -122.422419858646 (37.780652317617, -122.422419858646) 7 9 11 28852 41
12231 96231 Permitted Site 7 Tree(s) :: 17     Sidewalk: Curb side : Cutout Landscaping Private 2                              
12237 88560 Permitted Site 7 Prunus spp :: Cherry 68 2901 Pierce St   Sidewalk: Curb side : Cutout Tree Private 2   07/24/2008 12:00:00 AM   3x3 Permit Number 51505 6001501 2118350 37.7966692015857 -122.438850093229 (37.7966692015857, -122.438850093229) 13 9 1 57 17
12244 261985 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 1500x Bancroft Ave   Front Yard : Yard Tree Private 2           6014696 2091834 37.7246038778524 -122.391337493735 (37.7246038778524, -122.391337493735) 10 3 8 58 1
12300 93053 Permitted Site 7 Pinus Spp :: Pine Spp 100     Front Yard : Yard Tree Private 2   04/28/2010 12:00:00 AM 36   Permit Number 53387                    
12345 107864 Permitted Site 7 Tree(s) :: 17 362 BRANNAN ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014441.4 2112297.4 37.7807778793576 -122.393649202889 (37.7807778793576, -122.393649202889) 6 2 9 28856 6
12387 88728 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 68 Pontiac St   Sidewalk: Curb side : Cutout Tree Private 2   08/11/2008 12:00:00 AM   3x3 Permit Number 51663 6010467.8 2117974.1 37.7961431384766 -122.407796278381 (37.7961431384766, -122.407796278381) 3 1 10 308 4
12615 87685 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 118 Virginia Ave   Sidewalk: Curb side : Cutout Tree Private 2   05/23/2008 12:00:00 AM   4x4 Permit Number 776560 6006594.8 2098480.6 37.7424010366351 -122.419813761733 (37.7424010366351, -122.419813761733) 2 7 7 28859 2
13046 112126 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 8245 Geary Blvd   Sidewalk: Curb side : Cutout Tree Private 2     55 3x3   5981385.27932 2112314.25515 37.7789318748139 -122.508005614464 (37.7789318748139, -122.508005614464) 11 6 2 55 26
13104 88055 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 52 Robblee Ave   Sidewalk: Curb side : Cutout Tree Private 2   06/24/2008 12:00:00 AM   3x3 Permit Number 51065 6012498 2095923.9 37.7357116661186 -122.399222709682 (37.7357116661186, -122.399222709682) 10 3 8 58 1
13212 87784 Permitted Site 7 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 48 Santa Ysabel Ave   Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50524 6000929.5 2093152.6 37.7274508049284 -122.439020861215 (37.7274508049284, -122.439020861215) 9 7 6 28861 25

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);