4,014 rows where qSpecies_id = 40

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)
6141 69800 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 367 Delano Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5999779.7835 2091764.72169 37.7235745268131 -122.442895800812 (37.7235745268131, -122.442895800812) 9 7 6 28861 25
6211 44491 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 55 Madison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM 9   Permit Number 45395 6005461.21441 2093276.54578 37.728047939957 -122.423363497235 (37.728047939957, -122.423363497235) 9 7 7 309 5
6325 213549 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 167 Valdez Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5996164.20068 2094572.39502 37.7310769303549 -122.455596998927 (37.7310769303549, -122.455596998927) 9 7 4 28861 40
6337 55153 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3933 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2009 12:00:00 AM   3x3 Permit Number 52132 6003602.67369464 2101839.43403285 37.7514545976895 -122.430399225072 (37.7514545976895, -122.430399225072) 2 4 5 28862 22
6401 70501 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 75 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6004654.40413 2093072.16776 37.7274411943513 -122.42613812337 (37.7274411943513, -122.42613812337) 9 7 6 28861 5
6437 238199 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3980 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003307.88707 2101869.812 37.7515213056834 -122.431420800429 (37.7515213056834, -122.431420800429) 2 4 5 28862 22
6493 214723 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 591 Miramar Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5995322.28894 2093286.27731 37.7274972131074 -122.458414554203 (37.7274972131074, -122.458414554203) 9 7 4 28861 40
6547 238340 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 227 Collingwood St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2020 12:00:00 AM 3 Width 3ft Permit Number 787829 6002088.29914 2104514.86028 37.7587147776761 -122.435827511746 (37.7587147776761, -122.435827511746) 2 4 5 28862 3
6552 119000 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 623 43rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5982547.10807 2111503.78055 37.776774937935 -122.503926407866 (37.776774937935, -122.503926407866) 11 6 2 55 26
6581 214481 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1623 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5990862.01954 2104342.15602 37.7575964779098 -122.474640129733 (37.7575964779098, -122.474640129733) 1 8 4 56 12
6608 47030 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 22 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2002 12:00:00 AM     Permit Number 45025 6005541.3 2109365.2 37.7722281991235 -122.424230399247 (37.7722281991235, -122.424230399247) 7 9 11 28852 10
6690 79764 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 26 Wanda St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6000559.45557 2091550.49268 37.7230307229714 -122.440185263946 (37.7230307229714, -122.440185263946) 9 7 6 28861 25
6764 95833 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 520 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/29/2011 12:00:00 AM 2 3x3 Permit Number 767565 6010212.70231 2112022.42286 37.7797869733249 -122.408258986859 (37.7797869733249, -122.408258986859) 14 2 9 28853 34
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                    
6873 238355 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 677 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6003708.60882 2104373.36592 37.7584181758823 -122.43021364585 (37.7584181758823, -122.43021364585) 2 4 5 28862 3
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
6973 214477 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1587 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5990545.71643 2104592.61626 37.758265842404 -122.475752312336 (37.758265842404, -122.475752312336) 1 8 4 56 12
7018 213561 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 130 Montecito Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5996368.30466 2094246.96905 37.7301950992263 -122.454867876251 (37.7301950992263, -122.454867876251) 9 7 4 28861 40
7072 179119 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 621 Bowdoin St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008944.10696 2093176.6835 37.7279696962286 -122.411315930896 (37.7279696962286, -122.411315930896) 9 3 7 309 28
7115 4034 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2150 Cesar Chavez St 8 Sidewalk: Curb side : Cutout Tree DPW 1   04/28/1995 12:00:00 AM 3 3X3   6012617.9559004 2100994.1740901 37.7496402484926 -122.399163766262 (37.7496402484926, -122.399163766262) 10 3 8 58 1
7312 254991 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1508 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/21/2020 12:00:00 PM 3 4x4   6002019 2093366 37.7280986838153 -122.435269719024 (37.7280986838153, -122.435269719024) 9 7 6 28861 25
7345 124346 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 804 Balboa St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993044.54414 2111416.29684 37.7771464148252 -122.467606586696 (37.7771464148252, -122.467606586696) 11 6 2 54 11
7371 213371 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1695 12th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5992456.73021 2103998.57674 37.7567453730203 -122.46910001725 (37.7567453730203, -122.46910001725) 1 8 4 56 12
7449 238083 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 690X Powhattan Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008630.1472 2098081.04423 37.7414183955492 -122.412747878228 (37.7414183955492, -122.412747878228) 10 7 7 28859 2
7488 21658 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1745 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6004251.7833336 2114607.9002324 37.7865504610901 -122.42906481766 (37.7865504610901, -122.42906481766) 13 9 11 29490 13
7565 121637 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 298x Otsego Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000311 2091736 37.7235259352509 -122.441057424661 (37.7235259352509, -122.441057424661) 9 7 6 28861 25
7591 213529 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1301 Plymouth Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5995838.74514 2092736.52805 37.7260173993826 -122.456589434062 (37.7260173993826, -122.456589434062) 9 7 4 28861 40
7667 238373 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 587 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002476.35848 2103824.63673 37.7568416256553 -122.434436077082 (37.7568416256553, -122.434436077082) 2 4 5 28862 3
7738 73633 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 782 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5983562.48746 2110479.0519 37.7740209842304 -122.500338183608 (37.7740209842304, -122.500338183608) 11 6 2 55 26
7761 238135 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 60 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6006116.90537 2099100.80672 37.7440770505137 -122.421510217522 (37.7440770505137, -122.421510217522) 2 7 7 28859 2
7852 238334 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 286 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6002701.12407 2104251.52183 37.7580265058249 -122.433689263855 (37.7580265058249, -122.433689263855) 2 4 5 28862 3
7876 196488 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 Jack London Aly 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6014277.71699 2112657.65169 37.7817579518025 -122.394240695653 (37.7817579518025, -122.394240695653) 6 2 9 28856 6
7882 68956 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 874 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM 7   Permit Number 32945 5988542.5052 2110035.33246 37.7730937088544 -122.483079131422 (37.7730937088544, -122.483079131422) 11 6 2 55 26
7896 4158 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3739-3737 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/31/1989 12:00:00 AM 12 3X3   6005577.78119 2100485.82594 37.7478495841857 -122.423472835916 (37.7478495841857, -122.423472835916) 2 4 5 28859 22
7901 70504 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 437 Peru Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   18     6004727.68791 2092850.78229 37.7268374605684 -122.425869029139 (37.7268374605684, -122.425869029139) 9 7 6 28861 5
7935 213699 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 62 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/21/2000 12:00:00 AM 8 Width 3ft Permit Number 42424 5999655.47058 2093801.73285 37.7291606000606 -122.443471779698 (37.7291606000606, -122.443471779698) 9 7 4 63 40
8095 67626 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1334 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/1992 12:00:00 AM 7   Permit Number 31212 6007155.75192 2118470.9352 37.7973213520513 -122.419291917399 (37.7973213520513, -122.419291917399) 5 1 10 28858 32
8150 179100 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 135 Craut St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6004051.95756 2094086.86306 37.7301932520093 -122.428293070766 (37.7301932520093, -122.428293070766) 9 7 6 28861 5
8166 135996 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Washington St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6009314.46183 2117374.97438 37.7944334526921 -122.411744720456 (37.7944334526921, -122.411744720456) 3 1 10 28857 21
8215 78428 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1000 Russia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6003760.55793 2089507.02649 37.7176015427445 -122.428974079707 (37.7176015427445, -122.428974079707) 9 7 6 28861 5
8306 179066 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 252 Otsego Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6000335.97419 2091752.60204 37.723572943118 -122.440972284042 (37.723572943118, -122.440972284042) 9 7 6 28861 25
8324 78480 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 575 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6001855.96209 2090141.35003 37.719235261989 -122.435602746878 (37.719235261989, -122.435602746878) 9 7 6 28861 5
8326 72143 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 12 Meda Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6000249.61025 2091756.38076 37.7235783992966 -122.441271099083 (37.7235783992966, -122.441271099083) 9 7 6 28861 25
8391 238054 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 432 Lily St 1 Sidewalk: Property side : Cutout Tree Private 2     11 Width 3ft   6004439.8336 2109989.04683 37.7738788753301 -122.428084933487 (37.7738788753301, -122.428084933487) 7 9 11 28852 10
8455 79359 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 567 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5985009.75382 2112015.61326 37.7783247854299 -122.495445265062 (37.7783247854299, -122.495445265062) 11 6 2 55 26
8641 41286 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 494 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52403 6005499.65147882 2107857.73967205 37.7680867232876 -122.424267232407 (37.7680867232876, -122.424267232407) 8 4 5 28853 19
8680 179049 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 179 Santa Rosa Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6001280.87762 2093214.71451 37.7276413438501 -122.437810596884 (37.7276413438501, -122.437810596884) 9 7 6 28861 25
8799 28348 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3136 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2001 12:00:00 AM 3 3X3   6008810.2764485 2100618.7635013 37.748396520659 -122.412304375108 (37.748396520659, -122.412304375108) 2 4 7 28859 19
8800 53644 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4051 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/2009 12:00:00 AM   3x3 Permit Number 52604 6002653.10802153 2105292.31520624 37.7608815491861 -122.433929717717 (37.7608815491861, -122.433929717717) 2 4 5 28862 3
9027 238423 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4328 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6000572.71339 2105813.81036 37.7621951665895 -122.441162282037 (37.7621951665895, -122.441162282037) 15 5 5 28862 3
9062 68953 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 750 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM 3 3x3 Permit Number 32942 5988850.38114 2110206.21118 37.7735808052559 -122.482026682299 (37.7735808052559, -122.482026682299) 11 6 2 55 26
9128 238117 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3017 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6009237.77363 2104492.70808 37.7590574832375 -122.411099692516 (37.7590574832375, -122.411099692516) 2 4 7 28859 19
9167 213451 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4 Cortes Ave 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   5993177.52134 2099659.66969 37.7448734694269 -122.466291957027 (37.7448734694269, -122.466291957027) 1 8 4 29491 40
9279 196461 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 615 Mississippi St 1 : Tree Private 2     1 Width 3ft   6014144.28645 2104277.08263 37.7587393543665 -122.39411542099 (37.7587393543665, -122.39411542099) 10 3 8 28856 29
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
9300 34481 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 839 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM 9   Permit Number 38208 6008950.87239 2119364.89119 37.7998768700862 -122.413143564642 (37.7998768700862, -122.413143564642) 3 1 10 308 32
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
9518 65278 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 415 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/14/1989 12:00:00 AM 1   Permit Number 28081 6011215.3927 2112332.46737 37.7806943784819 -122.40481205634 (37.7806943784819, -122.40481205634) 14 2 9 28853 34
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
9707 213504 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 435 Montecito Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5995680.74302 2093936.83291 37.7293040752209 -122.457222425468 (37.7293040752209, -122.457222425468) 9 7 4 28861 40
9716 91569 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 301 Girard St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2009 12:00:00 AM   3x3 Permit Number 52142 6010768 2093361 37.7285779166605 -122.405023621917 (37.7285779166605, -122.405023621917) 10 3 7 309 28
9801 72374 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 766 19th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5990089.45799 2110137.86742 37.7734651388758 -122.477735579303 (37.7734651388758, -122.477735579303) 11 6 2 55 26
9950 78381 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 631 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6003379.38532 2089522.9059 37.7176235608499 -122.430292752023 (37.7176235608499, -122.430292752023) 9 7 6 28861 5
9953 73879 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 345 Congdon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6004728.86924 2093550.80398 37.7287596319363 -122.425914753389 (37.7287596319363, -122.425914753389) 9 7 6 28861 5
10066 91129 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2100X Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2009 12:00:00 AM 3 3x3 Permit Number 52620 5989031.08283 2111274.17492 37.776523645314 -122.481479844539 (37.776523645314, -122.481479844539) 11 6 2 55 26
10161 214669 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2222 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5991758.11686 2100299.12618 37.7465472525561 -122.471246528119 (37.7465472525561, -122.471246528119) 1 8 4 29491 40
10193 124493 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3148 Turk Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5995905.24735 2111438.77615 37.7773728899422 -122.45771219988 (37.7773728899422, -122.45771219988) 11 6 2 54 16
10261 89402 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1914 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2008 12:00:00 AM 3 3x3   5992725.99788 2112086.29643 37.7789676550624 -122.468757294436 (37.7789676550624, -122.468757294436) 11 6 2 54 11
10348 91136 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 480 14th St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/26/2009 12:00:00 AM   3x3 Permit Number 52024 6005604 2107874.4 37.7681383601012 -122.423907486341 (37.7681383601012, -122.423907486341) 8 4 5 28853 19
10361 70279 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 90 Arago St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5999591.10411 2092976.06015 37.7268898235963 -122.443635008456 (37.7268898235963, -122.443635008456) 9 7 6 28861 25
10377 91396 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 14 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/26/2009 12:00:00 AM   3x3 Permit Number 52091 5996731.3 2091236.4 37.7219496073249 -122.453395686079 (37.7219496073249, -122.453395686079) 9 8 4 28861 24
10385 239400 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 338 Hoffman Ave 4 Sidewalk: Property side : Yard Tree Private 2     2 Width 3ft   6000612.89044 2101776.73481 37.7511126294541 -122.440733730797 (37.7511126294541, -122.440733730797) 2 4 5 28862 22
10496 68949 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 726 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM 4   Permit Number 32938 5988844.72891 2110346.33242 37.7739652106004 -122.482056500957 (37.7739652106004, -122.482056500957) 11 6 2 55 26
10577 76677 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 423 Burrows St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6010109 2093148 37.7279562025478 -122.407286823302 (37.7279562025478, -122.407286823302) 10 3 7 309 28
10579 237349 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1103X Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6008183.53987 2097707.79876 37.7403684685413 -122.414265694627 (37.7403684685413, -122.414265694627) 2 7 7 28859 2
10601 78363 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 575 Lisbon St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6001858.24783 2090145.25438 37.7192461122881 -122.435595125122 (37.7192461122881, -122.435595125122) 9 7 6 28861 5
10602 104255 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8X Octavia St Frontage East 9 Sidewalk: Curb side : Cutout Tree DPW 1     3 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
10728 237359 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1398 Treat Way 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6008689.76614 2100834.9062 37.7489832371873 -122.412736376802 (37.7489832371873, -122.412736376802) 2 4 7 28859 19
10833 135992 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6009196.7187 2117357.70571 37.7943794313202 -122.412150906452 (37.7943794313202, -122.412150906452) 3 1 10 28857 21
10881 50928 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2261 Cecelia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2004 12:00:00 AM     Permit Number 47425 5991475.24491559 2099916.59093812 37.7454805429508 -122.472196779655 (37.7454805429508, -122.472196779655) 1 8 4 29491 40
10901 4185 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3836 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6004920.4543 2100493.66271 37.7478339791697 -122.425746400299 (37.7478339791697, -122.425746400299) 2 4 5 63 22
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
11099 45514 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2917 26th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/2001 12:00:00 AM 2   Permit Number 44278 5988535.25971 2095760.72309 37.7338990344167 -122.482058269478 (37.7338990344167, -122.482058269478) 1 8 4 64 35
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
11139 57395 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1415 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/15/1994 12:00:00 AM 4   Permit Number 33423 6007958.46126 2117300.9237 37.7941539658926 -122.416431412305 (37.7941539658926, -122.416431412305) 5 1 10 28858 32
11209 27513 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1212 Guerrero St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2001 12:00:00 AM 8 3X3   6005754.33518 2101803.91881 37.7514787281818 -122.422955987444 (37.7514787281818, -122.422955987444) 2 4 5 28859 19
11336 213698 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 54 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/21/2000 12:00:00 AM 9 Width 2ft Permit Number 42422 5999705.61228 2093800.4183 37.7291598500291 -122.443298341854 (37.7291598500291, -122.443298341854) 9 7 4 63 40
11361 78243 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 30 Delano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6000646.02726 2093117.37413 37.7273379494759 -122.439998300301 (37.7273379494759, -122.439998300301) 9 7 6 28861 25
11396 237049 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1420 Hampshire St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010399.81858 2100970.62017 37.7494517102366 -122.406832541612 (37.7494517102366, -122.406832541612) 2 4 7 28859 19
11529 179062 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 18 Colonial Way 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6000439.3413 2093583.91766 37.7286072022493 -122.440746262842 (37.7286072022493, -122.440746262842) 9 7 6 28861 25
11603 238318 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 23 Clover Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6000458.56738 2105088.99316 37.7601984944918 -122.441505054123 (37.7601984944918, -122.441505054123) 2 4 5 28862 3
11648 238436 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 404 Loma Vista Ter 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5999965.40666 2106753.04147 37.7647394502792 -122.443330183252 (37.7647394502792, -122.443330183252) 15 5 5 29492 3
11713 214758 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 47 Eastwood Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5995620 2092942 37.7265690145806 -122.457360475692 (37.7265690145806, -122.457360475692) 9 7 4 28861 40
11716 31909 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2227 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM 14   Permit Number 35333 5991726.96722 2100261.52129 37.7464421973476 -122.471351499672 (37.7464421973476, -122.471351499672) 1 8 4 29491 40
11717 78354 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1125 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6000366.91048 2090562.17909 37.7203060748337 -122.440779991907 (37.7203060748337, -122.440779991907) 9 7 6 28861 25
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
11785 72266 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 359 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6002393.10905 2091502.19798 37.7230023412585 -122.43384325117 (37.7230023412585, -122.43384325117) 9 7 6 28861 5
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
11848 238215 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 164 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004052.17675 2101028.41452 37.7492531795117 -122.428786978444 (37.7492531795117, -122.428786978444) 2 4 5 28862 22
11855 237398 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1345 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6005860.83532 2101136.51471 37.7496521987857 -122.422540276735 (37.7496521987857, -122.422540276735) 2 4 5 28859 19

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