163,064 rows where qCaretaker_id = 2 sorted by Fire Prevention Districts descending

View and edit SQL

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)
1021 213351 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 752 Head St 1 : Tree Private 2     3 Width 3ft   5993534.80603 2090819.23886 37.7206204409725 -122.464414798499 (37.7206204409725, -122.464414798499) 9 8 6 64 24
1026 209572 DPW Maintained 1 Maytenus boaria :: Mayten 58 100 Malta Dr 7 Sidewalk: Curb side : Yard Tree Private 2     12     5999439.81114 2096263.84796 37.7359086891413 -122.444394200825 (37.7359086891413, -122.444394200825) 9 7 4 63 40
1031 203993 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 62 Eastwood Dr 2 Sidewalk: Curb side : Yard Tree Private 2     30 Width 3ft   5995660.26957 2093014.24924 37.7267697065318 -122.457226490416 (37.7267697065318, -122.457226490416) 9 7 4 28861 40
1038 259268 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 6 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
1052 65988 Permitted Site 7 Tree(s) :: 17 121 Cresta Vista Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/1990 12:00:00 AM     Permit Number 29018 5995709.58889373 2096251.06183698 37.7356600432467 -122.457290053496 (37.7356600432467, -122.457290053496) 9 7 4 59 40
1056 210964 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1 Pizarro Way 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5995081.73888 2093960.6107 37.7293349426397 -122.459294943706 (37.7293349426397, -122.459294943706) 9 7 4 28861 40
1058 160441 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 201 France Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/07/2019 12:00:00 AM 3 4x6   6001628.58163 2090114.34641 37.7191481986061 -122.436386782123 (37.7191481986061, -122.436386782123) 9 7 6 28861 5
1059 262280 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 10 Niantic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784434 5992391 2086794 37.7095021076955 -122.468075893068 (37.7095021076955, -122.468075893068) 9 8 4 64 24
1063 32734 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 808 Capitol Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM     Permit Number 37117 5995081.95862964 2089664.82981262 37.7175397705127 -122.458983271916 (37.7175397705127, -122.458983271916) 9 8 6 28861 24
1065 180355 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1900 San Jose Ave 33 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999392.39561 2091826.25637 37.7237213933189 -122.444239347485 (37.7237213933189, -122.444239347485) 9 7 6 28861 25
1075 209246 DPW Maintained 1 Maytenus boaria :: Mayten 58 122 Chilton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6001612.99048 2095459.00516 37.7338225308765 -122.436823072927 (37.7338225308765, -122.436823072927) 9 7 5 63 40
1111 99485 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 700X Miramar Ave 6 Median : Cutout Tree Private 2     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204) 9 7 4 28861 40
1123 72265 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 358 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6002353.80444 2091524.36294 37.7230609707806 -122.433980702666 (37.7230609707806, -122.433980702666) 9 7 6 28861 5
1128 178845 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 543 Sawyer St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007634.8415 2086934.39681 37.7107561785306 -122.415400376427 (37.7107561785306, -122.415400376427) 9 7 8 309 39
1145 180443 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 599 University St 10 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008502.54989 2091553.3243 37.7234875219066 -122.412727694727 (37.7234875219066, -122.412727694727) 9 3 7 309 28
1152 259051 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 25 Baden St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000711 2094308 37.7306108324003 -122.439859019702 (37.7306108324003, -122.439859019702) 9 7 4 63 40
1175 217424 DPW Maintained 1 Washingtonia filifera :: California Fan Palm 176 450 Los Palmos Dr 1 Sidewalk: Property side : Yard Tree Private 2     17 Width 3ft   5997245.21557 2095811.54229 37.7345413068394 -122.451949128344 (37.7345413068394, -122.451949128344) 9 7 4 59 40
1182 922 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1253 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3X3   6002943.78693 2094101.1406 37.7301696879821 -122.432125178253 (37.7301696879821, -122.432125178253) 9 7 6 28861 25
1194 213495 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 613 Faxon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994845.46831 2092391.05162 37.725011726204 -122.45999808945 (37.725011726204, -122.45999808945) 9 8 4 28861 40
1203 179432 DPW Maintained 1 Schinus terebinthifolius :: Brazilian Pepper 93 122 Santos St 2 Sidewalk: Property side : Yard Tree Private 2     12 Width 6ft   6006549.42501 2086808.72834 37.7103500527955 -122.419142922204 (37.7103500527955, -122.419142922204) 9 7 8 309 39
1204 72270 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 60 619 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6002965.14713 2089877.08907 37.7185725974338 -122.431749858784 (37.7185725974338, -122.431749858784) 9 7 6 28861 5
1214 44389 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 15 Cordova St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/2001 12:00:00 AM     Permit Number 43749 6001647.0719332 2087964.37014378 37.7132458927569 -122.436169094311 (37.7132458927569, -122.436169094311) 9 7 6 28861 5
1222 16326 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 789X Monterey Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   08/10/1993 12:00:00 AM 3 3X3   5996873.6825 2094683.9462 37.7314239112697 -122.45315226118 (37.7314239112697, -122.45315226118) 9 7 4 59 40
1225 70200 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 651 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6002623.55844 2089844.48662 37.7184637093015 -122.432928262055 (37.7184637093015, -122.432928262055) 9 7 6 28861 5
1233 99298 DPW Maintained 1 Leptospermum scoparium :: New Zealand Tea Tree 157 50 Norton St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2012 12:00:00 AM 4 3x3 Permit Number 768888 6001844.05326 2092273.64854 37.7250893979513 -122.435796391592 (37.7250893979513, -122.435796391592) 9 7 6 28861 25
1245 213791 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 209 Granada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/2020 12:00:00 AM 3 Width 3ft Permit Number 768064 5995620.63174 2091343.81767 37.7221808240739 -122.45724272857 (37.7221808240739, -122.45724272857) 9 8 4 28861 24
1246 160377 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 824 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 3 Width 0ft   6001767.32645 2089068.63157 37.7162847814869 -122.435832414836 (37.7162847814869, -122.435832414836) 9 7 6 28861 5
1247 214916 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 20 Pinehurst Way 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/1993 12:00:00 AM 13 Width 2ft Permit Number 32246 5993222.12997 2093186.27538 37.7271017173463 -122.465667493867 (37.7271017173463, -122.465667493867) 9 8 4 59 40
1269 262440 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
1278 170724 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 540 San Juan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6000352.85514 2092916.82872 37.7267706040626 -122.440997412 (37.7267706040626, -122.440997412) 9 7 6 28861 25
1284 72257 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 671 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6002561.32843 2089744.29585 37.7181850777589 -122.433136210491 (37.7181850777589, -122.433136210491) 9 7 6 28861 5
1293 72151 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 209 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   22     6001102.51971 2093339.22374 37.7279730740759 -122.438436097863 (37.7279730740759, -122.438436097863) 9 7 6 28861 25
1300 214130 DPW Maintained 1 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 459 Mangels Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5998397.60644 2095236.47729 37.7330282541307 -122.447923556932 (37.7330282541307, -122.447923556932) 9 7 4 59 40
1306 78279 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 773 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     6001349.14865 2092521.0021 37.7257404495571 -122.437524926331 (37.7257404495571, -122.437524926331) 9 7 6 28861 25
1309 73822 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 118X Lowell St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10 3x3   5998761.76944 2087100.1867 37.7107086898252 -122.44607953034 (37.7107086898252, -122.44607953034) 9 7 6 28861 5
1314 67685 Permitted Site 7 Tree(s) :: 17 766 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1992 12:00:00 AM     Permit Number 31289 5997024.37469935 2095029.17182905 37.7323804536882 -122.452656198743 (37.7323804536882, -122.452656198743) 9 7 4 59 40
1317 71329 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 346 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6003746.38005 2089169.34853 37.7166735503194 -122.428999024181 (37.7166735503194, -122.428999024181) 9 7 6 28861 5
1324 109608 DPW Maintained 1 Tree(s) :: 17 30 Curtis St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2018 12:00:00 AM 3 3x3 Permit Number 781648 6000500.58572 2088469.85865 37.7145686465987 -122.440167960077 (37.7145686465987, -122.440167960077) 9 7 6 28861 5
1332 215594 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 260 Sagamore St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5994385 2087488 37.7115226229707 -122.461234615187 (37.7115226229707, -122.461234615187) 9 8 6 28861 24
1338 261130 DPW Maintained 1 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 198 Madrid St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 3ft   6003761.7429 2092753.33549 37.7265152577639 -122.429201331188 (37.7265152577639, -122.429201331188) 9 7 6 28861 5
1339 73360 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 236 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6003402.60575 2092794.29016 37.72660737262 -122.430445774353 (37.72660737262, -122.430445774353) 9 7 6 28861 5
1347 109892 Permitted Site 7 Tree(s) :: 17 205 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/09/2015 12:00:00 AM 3 3x6   5995308.1 2091295.6 37.7220304751495 -122.458319579925 (37.7220304751495, -122.458319579925) 9 8 4 28861 24
1351 79811 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 514 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   17     6003624.73165 2089487.21102 37.717539444554 -122.429442157036 (37.717539444554, -122.429442157036) 9 7 6 28861 5
1357 54090 Permitted Site 7 Tree(s) :: 17 115 San Rafael Way 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1972 12:00:00 AM     Permit Number 9817 5991911.06498332 2095358.19732765 37.7329895631391 -122.47035789011 (37.7329895631391, -122.47035789011) 9 8 4 59 40
1370 49770 Permitted Site 7 Olea Majestic Beauty :: 183 333 Schwerin St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM     Permit Number 46559 6008566.26332194 2086145.27295548 37.7086417136506 -122.412125425298 (37.7086417136506, -122.412125425298) 9 7 8 309 39
1373 32746 DPW Maintained 1 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 254 Montana St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM 4   Permit Number 37128 5994350.01319 2089345.90391 37.716621973312 -122.461490145655 (37.716621973312, -122.461490145655) 9 8 6 28861 24
1377 262327 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
1407 177359 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 282 Edinburgh St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003626.27943 2092029.25547 37.724519425612 -122.429618004189 (37.724519425612, -122.429618004189) 9 7 6 28861 5
1409 178109 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 200 Morse St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6000643.20698 2087890.67148 37.7129864468306 -122.439633507395 (37.7129864468306, -122.439633507395) 9 7 6 28861 5
1415 171287 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 339 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 3ft   6003711.94249 2092708.61039 37.7263896332495 -122.429370301207 (37.7263896332495, -122.429370301207) 9 7 6 28861 5
1419 148015 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 703 Italy Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6002502.98722 2088786.72578 37.7155524923237 -122.433269485517 (37.7155524923237, -122.433269485517) 9 7 6 28861 5
1425 170341 DPW Maintained 1 Podocarpus gracilor :: Fern Pine 51 56 San Gabriel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6001088.08008 2093656.24889 37.7288427310959 -122.438508720824 (37.7288427310959, -122.438508720824) 9 7 6 28861 25
1430 67640 Permitted Site 7 Tree(s) :: 17 66 Mount Vernon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/1992 12:00:00 AM     Permit Number 31239 5999465.40351772 2088851.00886819 37.7155562089288 -122.443773323232 (37.7155562089288, -122.443773323232) 9 7 6 28861 25
1437 109607 DPW Maintained 1 Shrub :: Shrub 66 775 Congo St 1 Front Yard : Yard Landscaping Private 2           6000381.8 2095947.7 37.7350943222142 -122.441114705419 (37.7350943222142, -122.441114705419) 9 7 4 63 40
1441 262458 DPW Maintained 1 Podocarpus gracilor :: Fern Pine 51 236 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 2ft   6002498 2094223 37.730479001636 -122.433675025832 (37.730479001636, -122.433675025832) 9 7 5 28861 25
1448 178997 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 800 Edinburgh St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6001810.75276 2089136.90013 37.7164746985284 -122.435687194116 (37.7164746985284, -122.435687194116) 9 7 6 28861 5
1455 176735 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1245 Bacon St 3 Sidewalk: Property side : Yard Tree Private 2   08/17/2019 12:00:00 AM 3 Width 2ft   6007785.06482 2091940.88647 37.7245113883837 -122.415235340041 (37.7245113883837, -122.415235340041) 9 3 7 309 28
1457 209974 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 634 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5995417.8126 2093581.25052 37.7283126275124 -122.458105669454 (37.7283126275124, -122.458105669454) 9 7 4 28861 40
1472 2091 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 943 Bosworth St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1992 12:00:00 AM 6 2X2   6001433.65825 2095553.49813 37.7340717929056 -122.437449841319 (37.7340717929056, -122.437449841319) 9 7 5 63 40
1473 170691 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X San Juan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6000619.24687 2092677.737 37.7261292822292 -122.440059368765 (37.7261292822292, -122.440059368765) 9 7 6 28861 25
1499 262277 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Lee Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996515 2091798 37.7234792274288 -122.454183919247 (37.7234792274288, -122.454183919247) 9 8 4 28861 24
1523 260685 Undocumented 4 Pinus radiata :: Monterey Pine 15 198X Miraloma Dr 2 Median : Yard Tree Private 2       10x10   5994595 2096392 37.7359829456919 -122.461153801837 (37.7359829456919, -122.461153801837) 9 8 4 59 40
1527 155727 DPW Maintained 1 Tree(s) :: 17 251 Upland Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2020 12:00:00 AM 3 Width 3ft Permit Number 787672 5993647.1889 2094105.14579 37.7296492188193 -122.464264763718 (37.7296492188193, -122.464264763718) 9 8 4 59 40
1539 39700 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 360 Colon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41085 5995865.64470652 2094899.35552532 37.7319575477065 -122.456652788497 (37.7319575477065, -122.456652788497) 9 7 4 59 40
1540 57965 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 211 Lowell St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/1977 12:00:00 AM 20   Permit Number 16925 5998963.22576 2086714.9374 37.7096623843901 -122.445355572527 (37.7096623843901, -122.445355572527) 9 7 6 28861 5
1559 68149 Permitted Site 7 Tree(s) :: 17 306 Santa Ana Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/1993 12:00:00 AM     Permit Number 31907 5992597.64738181 2094843.40601485 37.731615747375 -122.467946785243 (37.731615747375, -122.467946785243) 9 8 4 59 40
1573 204937 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1345 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   5995869.1304 2092995.69792 37.7267307623121 -122.456503127921 (37.7267307623121, -122.456503127921) 9 7 4 28861 40
1585 34112 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1398 Plymouth Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37977 5995892.17100072 2093289.41859175 37.7275385716585 -122.456444707829 (37.7275385716585, -122.456444707829) 9 7 4 28861 40
1641 178128 DPW Maintained 1 Picea Spp :: Spruce Spp 200 246 Foote Ave 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 6ft   5998401.02209 2088623.35436 37.7148703538566 -122.447435913053 (37.7148703538566, -122.447435913053) 9 7 6 28861 25
1653 159947 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 157 Bertita St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 0ft   6000525.42449 2090002.91659 37.7187794927682 -122.440191978283 (37.7187794927682, -122.440191978283) 9 7 6 28861 25
1664 75299 DPW Maintained 1 Maytenus boaria :: Mayten 58 1739X Felton St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10 3x3   6005800.51839 2092301.46339 37.7253897211337 -122.422121267299 (37.7253897211337, -122.422121267299) 9 7 7 309 5
1679 262328 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
1688 213308 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 219 Tara St 1 : Tree Private 2     3 Width 3ft   5997858.51511 2090428.83634 37.7197967734736 -122.44944104777 (37.7197967734736, -122.44944104777) 9 8 6 28861 24
1702 46741 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 21 Sargent St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/2002 12:00:00 AM     Permit Number 44848 5993934.28224784 2089153.42556477 37.7160695363268 -122.462913152344 (37.7160695363268, -122.462913152344) 9 8 6 64 24
1714 216680 DPW Maintained 1 Olea europaea :: Olive Tree 9 430 Grafton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2017 07:33:00 AM 3 Width 3ft   5995444.86919 2090582.23732 37.7200796093562 -122.457795211804 (37.7200796093562, -122.457795211804) 9 8 6 28861 24
1726 179199 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 65 Blythdale Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 6ft   6006710.21835 2086918.77417 37.710661269476 -122.41859498419 (37.710661269476, -122.41859498419) 9 7 8 309 39
1731 261128 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 101 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 4ft   6003092 2092654 37.7262045674713 -122.431509515778 (37.7262045674713, -122.431509515778) 9 7 6 28861 5
1750 207422 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 140 Bella Vista Way 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5998335.54163 2097096.40434 37.7381316225622 -122.448272015461 (37.7381316225622, -122.448272015461) 9 7 4 59 40
1769 251583 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 75 Rice St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/30/1995 12:00:00 AM   3x3   5995352 2086409 37.7086155444167 -122.457814401925 (37.7086155444167, -122.457814401925) 9 7 6 28861 25
1773 116537 Significant Tree 6 Tree(s) :: 17 598x MOUNT VERNON AVE 6 Back Yard : Yard Tree Private 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
1788 262276 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Lee Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996515 2091798 37.7234792274288 -122.454183919247 (37.7234792274288, -122.454183919247) 9 8 4 28861 24
1812 52955 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 516 Victoria St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2006 12:00:00 AM     Permit Number 48942 5993282.16384919 2090617.22186434 37.7200511847077 -122.465273429637 (37.7200511847077, -122.465273429637) 9 8 6 64 24
1822 51694 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1205 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2005 12:00:00 AM     Permit Number 47971 5995825.9822194 2092036.11859211 37.7240935095077 -122.456582925823 (37.7240935095077, -122.456582925823) 9 8 4 28861 40
1826 62206 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 50 San Gabriel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1985 12:00:00 AM 13   Permit Number 22328 6001109.87298 2093671.7514 37.7288865370674 -122.438434491679 (37.7288865370674, -122.438434491679) 9 7 6 28861 25
1836 214279 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 422 Edna St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5998780.00952 2094220.12118 37.7302594304325 -122.446528398166 (37.7302594304325, -122.446528398166) 9 7 4 28861 40
1844 212645 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 385 Vernon St 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 6ft   5992447.95571 2090426.49221 37.7194793442858 -122.468143110712 (37.7194793442858, -122.468143110712) 9 8 6 64 24
1853 214288 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 38 Staples Ave 1 Sidewalk: Property side : Yard Tree Private 2   06/23/2000 12:00:00 AM 13 Width 3ft Permit Number 42619 5999806.95305 2093809.09712 37.7291894584065 -122.442948622496 (37.7291894584065, -122.442948622496) 9 7 4 63 40
1881 172208 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 516 Excelsior Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 3 Width 4ft   6003664.03575 2091910.47047 37.7241954061693 -122.429479018436 (37.7241954061693, -122.429479018436) 9 7 6 28861 5
1882 170658 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 399X San Juan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2019 12:00:00 AM 3 4x6   6000800.50336 2092551.29112 37.7257924078835 -122.439423717141 (37.7257924078835, -122.439423717141) 9 7 6 28861 25
1885 209224 DPW Maintained 1 Maytenus boaria :: Mayten 58 895 Foerster St 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5998759.0864 2096192.82641 37.7356748177208 -122.446742618486 (37.7356748177208, -122.446742618486) 9 7 4 59 40
1891 177497 DPW Maintained 1 Maytenus boaria :: Mayten 58 683 London St 1 Sidewalk: Curb side : Yard Tree Private 2     2     6001012.66507 2089830.75462 37.7183345028158 -122.438495457598 (37.7183345028158, -122.438495457598) 9 7 6 28861 5
1905 40652 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 227 Congdon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/10/1999 12:00:00 AM 2   Permit Number 41647 6004715.33788 2093887.46334 37.7296832590634 -122.425985487752 (37.7296832590634, -122.425985487752) 9 7 6 28861 5
1918 262485 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 500X Delta St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6009406 2087980 37.7137265813857 -122.409352565386 (37.7137265813857, -122.409352565386) 9 7 8 309 39
1920 213973 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1061 Capitol Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5995027.24606 2091045.40909 37.7213273674346 -122.459272306869 (37.7213273674346, -122.459272306869) 9 8 6 28861 24
1922 260512 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 180 Stratford Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5990850 2091280 37.7217304489912 -122.473728831815 (37.7217304489912, -122.473728831815) 9 8 4 64 40
1937 78248 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 734 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6002539.24351 2089283.26415 37.716917933889 -122.433179625239 (37.716917933889, -122.433179625239) 9 7 6 28861 5
1938 219404 DPW Maintained 1 Juniperus chinensis :: Juniper 113 471 Mangels Ave 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5998306.28146 2095220.78528 37.7329799470492 -122.448238160486 (37.7329799470492, -122.448238160486) 9 7 4 59 40
1945 44489 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 16 Madison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/26/2001 12:00:00 AM 8   Permit Number 43794 6005364.27294 2093438.07689 37.7284859970226 -122.423710107629 (37.7284859970226, -122.423710107629) 9 7 6 28861 5
1981 40499 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 44 Aptos Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/23/1999 12:00:00 AM   3x3 Permit Number 50329 5993102.74682774 2094714.88282209 37.7312920097199 -122.466191234844 (37.7312920097199, -122.466191234844) 9 8 4 59 40
1988 53775 Permitted Site 7 Tree(s) :: 17 358 San Benito Way 1 Sidewalk: Curb side : Cutout Tree Private 2   02/03/1972 12:00:00 AM     Permit Number 9461 5992772.54452217 2094326.15826887 37.7302056116577 -122.467304539962 (37.7302056116577, -122.467304539962) 9 8 4 59 40

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