trees

4,014 rows where qSpecies_id = 40 sorted by Supervisor Districts

✎ 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)
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                    
738 55617 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 411 Laurel St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/14/1983 12:00:00 AM 6   Permit Number 20476 5998121.25588 2115028.99118 37.7873577334097 -122.45030520092 (37.7873577334097, -122.45030520092) 11 6 1 54 31
739 38480 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2515 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/1998 12:00:00 AM 9   Permit Number 40479 5999797.20513 2119471.52027 37.7996515161494 -122.444826245059 (37.7996515161494, -122.444826245059) 13 9 1 57 17
3266 48394 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2520 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/23/2002 12:00:00 AM 14   Permit Number 45776 6002671.64848 2116160.62189 37.7907242663701 -122.434642758376 (37.7907242663701, -122.434642758376) 13 9 1 29490 27
4080 136012 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1001 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6006953.33762 2120481.80968 37.802831303989 -122.420135108266 (37.802831303989, -122.420135108266) 5 1 1 28858 32
6937 68735 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3968 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/1993 12:00:00 AM 3   Permit Number 32653 5995812.60766 2114880.06908 37.7868164408107 -122.458281808143 (37.7868164408107, -122.458281808143) 11 6 1 54 31
9328 47482 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1809 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM 6   Permit Number 45377 5999495.90716 2115146.40334 37.7877586907628 -122.445557657368 (37.7877586907628, -122.445557657368) 13 6 1 29490 31
11026 53052 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2517@ SCOTT Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/27/2006 12:00:00 AM 5   Permit Number 49029 6001372.25817 2117256.0832 37.7936582667653 -122.439217122188 (37.7936582667653, -122.439217122188) 13 9 1 29490 27
11117 12763 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1806 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3X3   5989830.30372 2114748.73304 37.7861102501687 -122.478969342589 (37.7861102501687, -122.478969342589) 11 6 1 55 33
11733 135934 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 98 Spruce St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5997041.86737 2116129.80097 37.7903184311097 -122.454119176269 (37.7903184311097, -122.454119176269) 11 6 1 54 31
11792 135925 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2725 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5999832.27617 2118786.40209 37.7977723656638 -122.444655616678 (37.7977723656638, -122.444655616678) 13 9 1 57 17
13432 48426 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3130 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2002 12:00:00 AM 9   Permit Number 45804 6001942.58238 2118964.92546 37.7983827391207 -122.437366176208 (37.7983827391207, -122.437366176208) 13 9 1 57 17
15130 31987 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 128 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/30/1995 12:00:00 AM 11   Permit Number 35387 5994614.2845 2114627.8658 37.7860550266291 -122.462409396175 (37.7860550266291, -122.462409396175) 11 6 1 54 11
17129 33142 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3148 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 8   Permit Number 37368 6001934.81136 2119023.66644 37.7985435846779 -122.437397274777 (37.7985435846779, -122.437397274777) 13 9 1 57 17
18589 72450 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3880 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5996319.64273 2114949.87112 37.7870372213321 -122.456532645474 (37.7870372213321, -122.456532645474) 11 6 1 54 31
21136 46595 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2480 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2002 12:00:00 AM 3   Permit Number 45794 6001119.43156 2118662.96193 37.7975067967595 -122.440192856927 (37.7975067967595, -122.440192856927) 13 9 1 57 17
22562 135932 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3595 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5997654.80988 2115415.55496 37.7883924295159 -122.451946898042 (37.7883924295159, -122.451946898042) 11 6 1 54 31
22657 250934 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 259 28th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   5987104.95893 2114216.89652 37.7844913413477 -122.488359085227 (37.7844913413477, -122.488359085227) 11 6 1 55 33
23937 48415 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2475 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2002 12:00:00 AM 8   Permit Number 45793 6001140.73556 2118622.32163 37.7973964220563 -122.440116223893 (37.7973964220563, -122.440116223893) 13 9 1 57 17
25934 135966 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2610 Scott St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6001187.63413 2117406.94715 37.7940619922234 -122.439866757361 (37.7940619922234, -122.439866757361) 13 9 1 57 27
27930 45570 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 310 Locust St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2001 12:00:00 AM 3   Permit Number 44312 5997638.34099 2115343.48265 37.788193594804 -122.451998675622 (37.788193594804, -122.451998675622) 11 6 1 54 31
28964 135935 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 98 Spruce St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5997049.33252 2116083.66446 37.7901921806791 -122.45409001394 (37.7901921806791, -122.45409001394) 11 6 1 54 31
31223 108693 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950X Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774617 6001046.33677 2120996.58295 37.8039101397338 -122.440613252117 (37.8039101397338, -122.440613252117) 13 9 1 57 17
31346 43671 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 128 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM 12   Permit Number 43314 5995229.94076 2114692.20799 37.7862671258378 -122.460284069366 (37.7862671258378, -122.460284069366) 11 6 1 54 11
31944 94585 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2725 Greenwich St   Sidewalk: Curb side : Cutout Tree Private 2   09/29/2010 12:00:00 AM   3x3 Permit Number 53761 5999865 2118793 37.7977923490456 -122.444542858 (37.7977923490456, -122.444542858) 13 9 1 57 17
32057 108634 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2610 Lake St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   5987336.48113 2114673.56953 37.7857587403195 -122.487591667787 (37.7857587403195, -122.487591667787) 11 6 1 55 33
32388 120359 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2420 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5987914.20542 2114679.4285 37.7858085051505 -122.485593360498 (37.7858085051505, -122.485593360498) 11 6 1 55 33
32418 18982 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2920 Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000616.67404 2115546.70514 37.7889217363036 -122.441708766757 (37.7889217363036, -122.441708766757) 13 6 1 29490 27
32901 52649 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 46@ LAKE 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/2006 12:00:00 AM 4   Permit Number 48733 5993970.1832 2115226.91418 37.7876627388076 -122.4646813119 (37.7876627388076, -122.4646813119) 11 6 1 54 11
33713 64938 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2810 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1989 12:00:00 AM 11   Permit Number 25967 6004818.34721 2119246.75761 37.7993196438369 -122.427435236266 (37.7993196438369, -122.427435236266) 13 9 1 57 17
34552 36940 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 115 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM 11   Permit Number 39579 5994867.05226 2114773.19638 37.7864686172836 -122.461545434289 (37.7864686172836, -122.461545434289) 11 6 1 54 11
34659 135946 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 33 Cervantes Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001854.08706 2120729.80422 37.8032235999547 -122.437798867946 (37.8032235999547, -122.437798867946) 13 9 1 57 17
35093 135973 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2118 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6003393.93756 2117943.36114 37.7956601891322 -122.432271050962 (37.7956601891322, -122.432271050962) 13 9 1 57 17
35793 7950 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1735 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2008 12:00:00 AM 3 3X3   6005696.54994 2116082.67925 37.7906815134801 -122.424171198144 (37.7906815134801, -122.424171198144) 13 9 1 28858 27
37141 120704 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 21st Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5989296.74954 2115035.23836 37.7868659147395 -122.480836260043 (37.7868659147395, -122.480836260043) 11 6 1 55 33
37177 250524 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 95 26th Ave 4 Sidewalk: Curb side : Yard Tree Private 2     7 Width 6ft   5987685.45058 2115374.99193 37.7877049922276 -122.486435864334 (37.7877049922276, -122.486435864334) 11 6 1 55 33
38213 120706 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 21st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5989297.54688 2115010.04334 37.7867967826872 -122.480831656181 (37.7867967826872, -122.480831656181) 11 6 1 55 33
38841 48912 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1930 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/2002 12:00:00 AM 2 3x3 Permit Number 46107 6004309.09705 2118070.5094 37.7960611527628 -122.429113506091 (37.7960611527628, -122.429113506091) 13 9 1 57 17
39510 41180 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1780 Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM 3   Permit Number 41899 6001541.153 2121088.1531 37.804189731738 -122.438907479297 (37.804189731738, -122.438907479297) 13 9 1 57 17
40378 135957 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2961 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   5999402.43366 2117332.15593 37.7937548548653 -122.446038331519 (37.7937548548653, -122.446038331519) 13 9 1 57 27
42020 250875 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 125 30th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   5986467.14332 2114671.0752 37.7857011507179 -122.490599105783 (37.7857011507179, -122.490599105783) 11 6 1 55 33
43530 135968 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2831 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002535.74001 2117875.30124 37.7954246171123 -122.435235693088 (37.7954246171123, -122.435235693088) 13 9 1 57 17
43969 135922 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2440 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6001259.6305 2118684.30492 37.7975733798607 -122.439709263576 (37.7975733798607, -122.439709263576) 13 9 1 57 17
45422 66088 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2229 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/08/1990 12:00:00 AM 12   Permit Number 29132 6007569.63634 2120087.67012 37.8017838015514 -122.417974436664 (37.8017838015514, -122.417974436664) 5 1 1 28858 32
47096 69243 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2021 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/22/1994 12:00:00 AM 16   Permit Number 33307 6003282.73155 2118223.78108 37.7964238439467 -122.432675884388 (37.7964238439467, -122.432675884388) 13 9 1 57 17
47783 250868 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 133 30th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   5986468.4993 2114649.30576 37.7856414573183 -122.490592812321 (37.7856414573183, -122.490592812321) 11 6 1 55 33
48711 135971 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2300 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002511.97848 2117816.96734 37.7952630979691 -122.435313737159 (37.7952630979691, -122.435313737159) 13 9 1 57 17
48761 135923 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 299 Pixley St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001988.80401 2118923.8728 37.7982726468322 -122.437203294605 (37.7982726468322, -122.437203294605) 13 9 1 57 17
51110 49515 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2360@ FILLMORE Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2003 12:00:00 AM 4   Permit Number 46421 6002343.25635 2117445.35992 37.7942331772802 -122.435870940009 (37.7942331772802, -122.435870940009) 13 9 1 29490 27
51846 120353 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2240 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 6ft   5988483.64082 2114700.05239 37.7858982939261 -122.483624810328 (37.7858982939261, -122.483624810328) 11 6 1 55 33
53836 117560 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2304 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/30/2016 12:00:00 AM 3 4x4 Permit Number 778613 6002499.39832 2117814.1104 37.7952545391263 -122.435357062003 (37.7952545391263, -122.435357062003) 13 9 1 57 17
54032 250328 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 161 27th Ave 3 : Tree Private 2     4 Width 3ft   5987394.32135 2114885.37066 37.7863436587784 -122.487407123146 (37.7863436587784, -122.487407123146) 11 6 1 55 33
54255 18943 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2799X Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2013 12:00:00 AM 3 3x3 Permit Number 769995 6001475.92192 2115618.2324 37.7891670515542 -122.438741019305 (37.7891670515542, -122.438741019305) 13 6 1 29490 27
54488 250523 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 95 26th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     7 Width 6ft   5987685.92853 2115397.50584 37.7877668368263 -122.48643586434 (37.7877668368263, -122.48643586434) 11 6 1 55 33
54600 82096 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1363 Francisco St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   07/01/2009 12:00:00 AM   3x3 Permit Number 52338 6004802.97001971 2120513.88344233 37.8027979755173 -122.427578771479 (37.8027979755173, -122.427578771479) 13 9 1 57 17
56041 135948 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 31 Cervantes Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6001895.29837 2120693.9243 37.8031274264634 -122.437653684066 (37.8031274264634, -122.437653684066) 13 9 1 57 17
56781 135965 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2574 Broadway 7 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6001290.6793 2117307.18376 37.7937939330834 -122.439503056242 (37.7937939330834, -122.439503056242) 13 9 1 57 27
57994 135928 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1960 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6000881.44205 2120995.2314 37.8038970374844 -122.441183782119 (37.8038970374844, -122.441183782119) 13 9 1 57 17
58099 135920 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2495 Filbert St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001110.69798 2118617.54309 37.7973815913536 -122.440219818601 (37.7973815913536, -122.440219818601) 13 9 1 57 17
58549 135919 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2355 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001720.67059 2118356.50999 37.7966995715863 -122.438090451527 (37.7966995715863, -122.438090451527) 13 9 1 57 17
58554 87738 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3200X Van Ness Ave 10 Median : Cutout Tree DPW 1   05/10/2008 12:00:00 AM 3 4x4   6005444.64461 2121623.98788 37.8058823097966 -122.425437295217 (37.8058823097966, -122.425437295217) 5 1 1 28858 32
58762 45577 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3866 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2001 12:00:00 AM 3   Permit Number 44317 5996397.21092 2114961.83643 37.7870745279007 -122.456265143944 (37.7870745279007, -122.456265143944) 11 6 1 54 31
59393 50792 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2740 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2     2   Permit Number 47317 5999864.3976 2118141.20218 37.7960026509676 -122.444498073449 (37.7960026509676, -122.444498073449) 13 9 1 57 17
60598 123574 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 126 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5994298.99246 2114690.05308 37.7862076150689 -122.463504728187 (37.7862076150689, -122.463504728187) 11 6 1 54 11
62335 135977 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2065 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6003684.73578 2117929.31477 37.7956381053729 -122.431263834562 (37.7956381053729, -122.431263834562) 13 9 1 29490 27
64169 250645 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2610 Lake St 6 : Tree Private 2     1 Width 3ft   5987300.52243 2114656.77456 37.7857105288548 -122.487714838772 (37.7857105288548, -122.487714838772) 11 6 1 55 33
64587 123988 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 9 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993914.45172 2115450.72048 37.7882740365456 -122.464890390305 (37.7882740365456, -122.464890390305) 11 6 1 54 11
66018 250870 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 133 30th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5986470.36803 2114630.24299 37.7855892256034 -122.490584944137 (37.7855892256034, -122.490584944137) 11 6 1 55 33
66320 65288 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 41 Rico Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/07/1990 12:00:00 AM 7   Permit Number 28836 6001457.59323 2121333.88235 37.8048596843835 -122.439214266819 (37.8048596843835, -122.439214266819) 13 9 1 57 17
66708 39922 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2335 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/1999 12:00:00 AM 6   Permit Number 41196 6003527.33622 2116558.3105 37.7918647577979 -122.431710530526 (37.7918647577979, -122.431710530526) 13 9 1 29490 27
68770 12835 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2240 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/19/2005 12:00:00 AM 12 5   5988460.73959 2114698.14797 37.7858917318965 -122.48370390161 (37.7858917318965, -122.48370390161) 11 6 1 55 33
69071 250819 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 60 Sea View Ter 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 4ft   5986191.04243 2114164.9353 37.7842953053345 -122.49151705369 (37.7842953053345, -122.49151705369) 11 6 1 55 33
69397 135936 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 98 Spruce St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5997050.12682 2116069.05064 37.7901521005919 -122.454086209825 (37.7901521005919, -122.454086209825) 11 6 1 54 31
70014 135918 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2355 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001698.12763 2118353.29773 37.7966894695005 -122.438168224898 (37.7966894695005, -122.438168224898) 13 9 1 57 17
70404 95588 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2153 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/2009 12:00:00 AM   3x3 Permit Number 767378 6000457 2120611 37.802817854966 -122.442624981194 (37.802817854966, -122.442624981194) 13 9 1 57 17
73417 136013 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1001 Chestnut St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006984.71597 2120484.67695 37.8028409447119 -122.420026726469 (37.8028409447119, -122.420026726469) 5 1 1 28858 32
73667 64340 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2118 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/13/1988 12:00:00 AM 12 3x3 Permit Number 25169 6003411.36684 2117944.79381 37.7956651110998 -122.432210844949 (37.7956651110998, -122.432210844949) 13 9 1 57 17
74709 135926 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2575 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6000595.0032 2118891.41204 37.7981041894114 -122.442023918863 (37.7981041894114, -122.442023918863) 13 9 1 57 17
79234 51284 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2205 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2004 12:00:00 AM 4   Permit Number 47656 6000322.72568 2116238.1776 37.7908035865572 -122.442775457127 (37.7908035865572, -122.442775457127) 13 6 1 29490 27
80154 135938 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 Walnut St 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   5998466.03707 2116398.73144 37.7911384032693 -122.44921105427 (37.7911384032693, -122.44921105427) 13 6 1 54 31
80306 104072 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3020 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2013 12:00:00 AM 4 3x3 Permit Number 770362 6003851.5174 2119222.18029 37.7991974313859 -122.430779048741 (37.7991974313859, -122.430779048741) 13 9 1 57 17
81108 49149 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2721 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2003 12:00:00 AM 8   Permit Number 46272 6001579.27273 2117782.40416 37.7951151846669 -122.438538563903 (37.7951151846669, -122.438538563903) 13 9 1 57 27
83080 135915 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2909 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004293.78648 2119207.639 37.7991825520948 -122.429247608494 (37.7991825520948, -122.429247608494) 13 9 1 57 17
83744 135955 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3035 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6000215.87492 2115769.86788 37.7895116385051 -122.443111506798 (37.7895116385051, -122.443111506798) 13 6 1 29490 27
85537 135952 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2870 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6001073.9556 2115610.46068 37.7891228364056 -122.440131212004 (37.7891228364056, -122.440131212004) 13 6 1 29490 27
86033 46596 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2480 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2002 12:00:00 AM 3   Permit Number 45794 6001101.66117 2118661.22174 37.7975010069291 -122.440254222167 (37.7975010069291, -122.440254222167) 13 9 1 57 17
86919 31989 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 147 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/30/1995 12:00:00 AM 6   Permit Number 35389 5994568.75053 2114560.86481 37.78586843793 -122.462562068449 (37.78586843793, -122.462562068449) 11 6 1 54 11
87380 135941 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 411 Laurel St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5998124.31484 2115011.10892 37.7873088085116 -122.45029332809 (37.7873088085116, -122.45029332809) 11 6 1 54 31
87651 135933 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 98 Spruce St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5997039.44005 2116145.17864 37.7903605148824 -122.45412868571 (37.7903605148824, -122.45412868571) 11 6 1 54 31
88618 135929 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1960 Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6000857.17484 2120992.84894 37.8038891135616 -122.44126758904 (37.8038891135616, -122.44126758904) 13 9 1 57 17
89667 135924 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 273 Pixley St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002069.33792 2118935.23427 37.7983084200504 -122.436925437376 (37.7983084200504, -122.436925437376) 13 9 1 57 17
91140 52876 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 118@ BEACH Cervantes Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2006 12:00:00 AM 3   Permit Number 48887 6001354.74762 2121139.05445 37.8043188860645 -122.439556198976 (37.8043188860645, -122.439556198976) 13 9 1 57 17
93641 135916 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2042 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6003243.98792 2118266.01922 37.7965376216713 -122.432812964457 (37.7965376216713, -122.432812964457) 13 9 1 57 17
94279 135976 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2319 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6003577.71337 2116564.31874 37.7918841103205 -122.43153665472 (37.7918841103205, -122.43153665472) 13 9 1 29490 27
96108 135970 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2300 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002518.2577 2117817.87673 37.7952659515087 -122.435292075163 (37.7952659515087, -122.435292075163) 13 9 1 57 17
96253 135945 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1998 Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5999716.32151 2121244.69535 37.8045155623958 -122.445233686505 (37.8045155623958, -122.445233686505) 13 9 1 57 17
96627 135967 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2831 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002534.88565 2117883.88227 37.7954481298799 -122.435239263394 (37.7954481298799, -122.435239263394) 13 9 1 57 17
96820 135927 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3400 Baker St 2 Sidewalk: Property side : Yard Tree Private 2     13     5999297.26526 2120520.00382 37.8025018265619 -122.446631690727 (37.8025018265619, -122.446631690727) 13 9 1 57 17
98338 250760 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 228 32nd Ave 1 : Tree Private 2     3 Width 3ft   5985903.61307 2114361.31306 37.7848177008131 -122.492525911365 (37.7848177008131, -122.492525911365) 11 6 1 55 33
99004 250882 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 154 29th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     13 Width 4ft   5986822.39512 2114740.35297 37.7859121118945 -122.489375148247 (37.7859121118945, -122.489375148247) 11 6 1 55 33

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