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)
78 237365 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2463 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008244.71386 2104091.00553 37.7578987598438 -122.414505749733 (37.7578987598438, -122.414505749733) 2 4 7 28859 19
538 214628 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1442 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5992754.41359 2105631.11276 37.7612450859223 -122.468189283707 (37.7612450859223, -122.468189283707) 1 8 4 56 12
632 23885 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1750X Geary Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6003231.6817 2113926.646 37.7846221123784 -122.432545437068 (37.7846221123784, -122.432545437068) 13 9 11 29490 13
708 214648 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 Hillway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5996112.80548 2106851.31964 37.7647888500462 -122.456662349289 (37.7647888500462, -122.456662349289) 15 5 11 29492 12
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
995 238517 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 258 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6001824.70148 2096208.99046 37.7358938476086 -122.436144777258 (37.7358938476086, -122.436144777258) 2 7 5 63 7
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
1029 65280 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 435 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/14/1989 12:00:00 AM 1   Permit Number 28085 6011091.92612 2112217.73363 37.7803724445696 -122.405231107147 (37.7803724445696, -122.405231107147) 14 2 9 28853 34
1048 213392 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 850 Quintara St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5990796.21432 2101134.59376 37.7487855419178 -122.474633614169 (37.7487855419178, -122.474633614169) 1 8 4 29491 12
1115 238053 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 426 Lily St 2 : Tree Private 2     9 Width 3ft   6004459.53739 2109991.59452 37.7738869854343 -122.428016956418 (37.7738869854343, -122.428016956418) 7 9 11 28852 10
1122 238295 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4331 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 5x5   6001522.95996 2105232.46628 37.7606530190412 -122.437834106978 (37.7606530190412, -122.437834106978) 2 4 5 28862 3
1131 238080 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 690X Jarboe Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6008716.17738 2096910.13853 37.7382081728556 -122.412367671831 (37.7382081728556, -122.412367671831) 10 7 7 28859 2
1166 196429 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 506 Utah St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010627.65958 2105903.22248 37.7630082841384 -122.406392171455 (37.7630082841384, -122.406392171455) 8 4 8 28859 19
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
1334 73744 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 35 Almaden Ct 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5995854.8721 2112478.16796 37.7802238906314 -122.45796169979 (37.7802238906314, -122.45796169979) 11 6 2 54 16
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
1360 238060 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2x Montezuma St 1 Median : Cutout Tree DPW 1     3 Width 3ft   6007260.48935 2099759.47356 37.7459500163869 -122.417602623671 (37.7459500163869, -122.417602623671) 2 7 7 28859 2
1382 4111 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3385X Cesar Chavez St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/01/1995 12:00:00 AM 3 3x3   6007239.656 2100524.9644 37.7480507095515 -122.417728911573 (37.7480507095515, -122.417728911573) 2 4 7 28859 2
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
1497 213565 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 125 Merced Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994666.93375 2099556.29013 37.744675439634 -122.461134390953 (37.744675439634, -122.461134390953) 1 8 4 59 40
1549 239487 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 500 Andover St 9 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007556.24914 2097139.11134 37.7387717222454 -122.416394353017 (37.7387717222454, -122.416394353017) 2 7 7 28859 2
1598 135994 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6009269.53041 2117367.69461 37.7944109435695 -122.411899674537 (37.7944109435695, -122.411899674537) 3 1 10 28857 21
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
1705 31912 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2256 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM 9   Permit Number 35336 5991754.81336 2100091.67364 37.745977450207 -122.471242839091 (37.745977450207, -122.471242839091) 1 8 4 29491 40
1895 73501 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1045 Diamond St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767446 6001962.16426713 2101054.16463509 37.7492053706113 -122.436016109621 (37.7492053706113, -122.436016109621) 2 4 5 28862 22
1941 40950 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 543 21st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM 6   Permit Number 42451 5989371.25434 2111628.81002 37.7775171478462 -122.480329070335 (37.7775171478462, -122.480329070335) 11 6 2 55 26
2029 239485 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 679 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007429.64294 2095798.50666 37.7350835962332 -122.416737151198 (37.7350835962332, -122.416737151198) 2 7 7 28859 2
2070 213331 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 151 Byxbee St 1 : Tree Private 2     6 Width 2ft   5991924.78555 2089552.62516 37.7170496899626 -122.469887910591 (37.7170496899626, -122.469887910591) 9 8 6 64 24
2081 238328 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 230 Collingwood St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002043.41709 2104477.94194 37.7586108592227 -122.435980092511 (37.7586108592227, -122.435980092511) 2 4 5 28862 3
2289 72333 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 522 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     5989411.86479 2111751.27895 37.7778557732807 -122.48019755247 (37.7778557732807, -122.48019755247) 11 6 2 55 26
2321 48402 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 706 Wisconsin St 1 Sidewalk: Property side : Yard Tree Private 2   11/19/2010 12:00:00 AM     Permit Number 53935 6012689.64928807 2104214.1545054 37.7584856101735 -122.399141839868 (37.7584856101735, -122.399141839868) 10 3 8 28856 29
2388 237117 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1086 Guerrero St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6005704.96367 2102692.93709 37.7539169809013 -122.423189907394 (37.7539169809013, -122.423189907394) 2 4 5 28859 19
2431 237346 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1499X Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6008796.40457 2097657.68171 37.7402652650326 -122.412143102127 (37.7402652650326, -122.412143102127) 10 7 7 28859 2
2470 68950 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 734 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM 6   Permit Number 32939 5988846.075 2110312.98983 37.7738737393837 -122.482049401575 (37.7738737393837, -122.482049401575) 11 6 2 55 26
2473 88167 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 189 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2013 12:00:00 AM 1 3x3 Permit Number 51184 6010014.6058 2087504.2072 37.7124542316575 -122.407215472312 (37.7124542316575, -122.407215472312) 9 7 8 309 39
2569 49452 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1483 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/02/2003 12:00:00 AM 4   Permit Number 46386 6011771.85534 2101466.16969 37.7508890570981 -122.402122808245 (37.7508890570981, -122.402122808245) 10 3 8 28856 29
2608 94102 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 252 Holyoke St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2010 12:00:00 AM 5 3x3 Permit Number 53477 6009512.58757 2093214.72689 37.7281060226502 -122.409353352981 (37.7281060226502, -122.409353352981) 10 3 7 309 28
2670 262494 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 41 Miraloma Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5994945 2097531 37.7391304944698 -122.4600262078 (37.7391304944698, -122.4600262078) 9 7 4 59 40
2717 237342 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 11x Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6007526 2096627 37.7373638762388 -122.416462675749 (37.7373638762388, -122.416462675749) 2 7 7 28859 2
2743 238264 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4076 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002529.27285 2104747.10596 37.7593775078944 -122.434319028496 (37.7593775078944, -122.434319028496) 2 4 5 28862 3
2753 237072 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3399 Cesar Chavez St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6007248.37653 2100524.57734 37.7480501375056 -122.417698728809 (37.7480501375056, -122.417698728809) 2 4 7 28859 2
2772 108460 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 944 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 3 3x3 Permit Number 773734 6010189.19593 2103716.38941 37.7569791954421 -122.407754468243 (37.7569791954421, -122.407754468243) 2 4 7 28859 19
2806 91889 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1112 Irving St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/18/2009 12:00:00 AM 3 3x3   5992343.82828 2106622.674723 37.7639439315835 -122.469681499547 (37.7639439315835, -122.469681499547) 11 8 11 56 12
2810 178982 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 38 Whipple Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5998252.81183 2087192.10261 37.7109319923872 -122.447845208002 (37.7109319923872, -122.447845208002) 9 7 6 28861 25
2989 261184 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 380 Benton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006769 2095411 37.733982408401 -122.41899375969 (37.733982408401, -122.41899375969) 2 7 7 28859 2
3019 70395 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 190 Madison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     6005551.02847 2092833.80452 37.7268373382622 -122.423021551618 (37.7268373382622, -122.423021551618) 9 7 7 309 5
3032 4178 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3814 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/19/2016 05:09:00 AM 3 4x4   6005035.97287 2100499.61266 37.7478568435292 -122.425347365702 (37.7478568435292, -122.425347365702) 2 4 5 63 22
3057 70502 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 78 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11 6x7   6004601.41978 2093074.4867 37.727444566791 -122.426321455564 (37.727444566791, -122.426321455564) 9 7 6 28861 5
3215 48784 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 268 Onondaga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/2002 12:00:00 AM 7   Permit Number 46039 6000083.90087 2091529.02554 37.7229446929396 -122.441827615748 (37.7229446929396, -122.441827615748) 9 7 6 28861 25
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
3267 50930 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2287 Cecelia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2004 12:00:00 AM     Permit Number 47426 5991460.4982554 2099833.27531374 37.7452509262864 -122.472241698597 (37.7452509262864, -122.472241698597) 1 8 4 29491 40
3312 102758 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1392 09TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5993422.3 2106025.2 37.7623656970292 -122.465908002531 (37.7623656970292, -122.465908002531) 1 8 11 56 12
3396 214751 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 115 Eastwood Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5995612.00056 2093441.40457 37.7279398000583 -122.457424244157 (37.7279398000583, -122.457424244157) 9 7 4 28861 40
3431 80385 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1754 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6011729.10125 2092748.56003 37.7269499630479 -122.401657992736 (37.7269499630479, -122.401657992736) 10 3 8 58 1
3444 213580 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 45 Merced Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5995131.70851 2099996.48556 37.74591084191 -122.459559177141 (37.74591084191, -122.459559177141) 1 8 4 59 40
3445 21666 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1765 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2014 12:00:00 AM 3 4X4 Permit Number 774582 6004178.5577 2114595.027 37.7865109691436 -122.429317242018 (37.7865109691436, -122.429317242018) 13 9 11 29490 13
3465 123273 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 578 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5993791.71774 2111566.05198 37.7776007134003 -122.465032776868 (37.7776007134003, -122.465032776868) 11 6 2 54 11
3608 71395 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1553 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6015450.35777 2096531.9462 37.7375453329415 -122.389057616714 (37.7375453329415, -122.389057616714) 10 3 8 58 1
3679 238393 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 84 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001698 2105474 37.7613261636576 -122.437246018283 (37.7613261636576, -122.437246018283) 15 4 5 28862 3
3725 73662 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 828 Brannan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6011416.18719 2109390.39573 37.7726273509159 -122.403910314231 (37.7726273509159, -122.403910314231) 14 2 9 28853 34
3746 237347 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1499X Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6008785.61167 2097659.00145 37.7402682831545 -122.412180513039 (37.7402682831545, -122.412180513039) 10 7 7 28859 2
3765 37799 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 425 Somerset St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/06/1998 12:00:00 AM 6   Permit Number 40126 6010088.32636 2092511.70686 37.7262079180568 -122.407313455853 (37.7262079180568, -122.407313455853) 10 3 7 309 28
3776 261180 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 340 Benton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006673 2095420 37.7340017140914 -122.419326300122 (37.7340017140914, -122.419326300122) 2 7 7 28859 2
3806 237447 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 837 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001298.41812 2101483.90892 37.7503476157529 -122.438342133081 (37.7503476157529, -122.438342133081) 2 4 5 28862 22
3847 239502 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 81 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008343.66274 2098237.09844 37.7418308021463 -122.413749481054 (37.7418308021463, -122.413749481054) 2 7 7 28859 2
3851 68224 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1500 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/01/2012 12:00:00 AM 1   Permit Number 769229 5990833.38749 2113424.07906 37.7825313172153 -122.47540222512 (37.7825313172153, -122.47540222512) 11 6 2 54 26
3867 33659 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 545 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/03/1996 12:00:00 AM 8   Permit Number 37747 6004792.43502 2110705.04365 37.7758647708832 -122.426916230306 (37.7758647708832, -122.426916230306) 7 9 11 28852 10
3894 178998 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 800 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001820.55644 2089152.21762 37.7165173138053 -122.435654403046 (37.7165173138053, -122.435654403046) 9 7 6 28861 5
3897 214702 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 520 Darien Way 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5992979.91933 2094883.59777 37.7317481717454 -122.466628127212 (37.7317481717454, -122.466628127212) 9 8 4 59 40
3915 79787 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1000 Russia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6003769.36441 2089501.77219 37.7175876140639 -122.428943265313 (37.7175876140639, -122.428943265313) 9 7 6 28861 5
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
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
4116 262380 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008843.96123 2117672.51917 37.7952240323069 -122.413393767718 (37.7952240323069, -122.413393767718) 5 1 10 308 21
4321 214786 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 34 Fairfield Way 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5993908.89145 2093024.31926 37.7266966141529 -122.463281639244 (37.7266966141529, -122.463281639244) 9 8 4 59 40
4327 213589 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1971 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5993451.57313 2102072.49612 37.7515142846609 -122.465519594973 (37.7515142846609, -122.465519594973) 1 8 4 29491 12
4459 78281 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 34 Wanda St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6000546.67018 2091525.62315 37.7229617089923 -122.440227677765 (37.7229617089923, -122.440227677765) 9 7 6 28861 25
4500 239551 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 121 Kingston St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6005985.55135 2098206.06147 37.7416128748431 -122.421900865949 (37.7416128748431, -122.421900865949) 2 7 7 28859 2
4692 74315 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Delano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6000588.28843 2093013.22945 37.7270487050229 -122.440190437741 (37.7270487050229, -122.440190437741) 9 7 6 28861 25
4825 238155 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 720 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001723.2813 2102070.97007 37.7519837019852 -122.436914952169 (37.7519837019852, -122.436914952169) 2 4 5 28862 22
4831 238452 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 74 Carmelita St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002631.46535 2108682.38304 37.7701886206411 -122.434246935272 (37.7701886206411, -122.434246935272) 15 5 5 29492 9
4873 151570 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1300x Vermont St 2 Side Yard : Cutout Tree Private 2 DPW 06/22/2019 12:00:00 AM 3 Width 4ft   6011393.71667 2102232.58713 37.7529723581964 -122.403484369222 (37.7529723581964, -122.403484369222) 10 4 8 28859 19
4965 70417 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 124 Yale St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6007053.10759 2093048.17382 37.7275105968359 -122.417844078137 (37.7275105968359, -122.417844078137) 9 3 7 309 5
4971 214807 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 550 Judson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5996780.18786 2093638.94841 37.7285492382588 -122.453400068478 (37.7285492382588, -122.453400068478) 9 7 4 28861 40
5031 124472 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2474 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5995885.81707 2110375.20896 37.7744514982012 -122.457702438809 (37.7744514982012, -122.457702438809) 11 5 2 54 16
5062 80388 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1746 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6011768.66094 2092717.74347 37.7268675545821 -122.401519069956 (37.7268675545821, -122.401519069956) 10 3 8 58 1
5311 237438 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1249 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001996.99133 2100364.87543 37.7473147241062 -122.435846365126 (37.7473147241062, -122.435846365126) 2 4 5 63 22
5431 214776 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 36 Sotelo Ave 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   5993929.13917 2101136.44437 37.7489716575191 -122.463800191051 (37.7489716575191, -122.463800191051) 1 8 4 29491 40
5458 238288 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 115 Diamond St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001740.25021 2105130.8583 37.7603863817444 -122.437075324682 (37.7603863817444, -122.437075324682) 2 4 5 28862 3
5538 178975 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 60 Dichiera Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 1ft   5998617.79966 2087941.66603 37.7130109785485 -122.44663762445 (37.7130109785485, -122.44663762445) 9 7 6 28861 25
5576 238143 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 574 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6001412.71542 2101470.20367 37.7503164848156 -122.437945904402 (37.7503164848156, -122.437945904402) 2 4 5 28862 22
5590 238162 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3886 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002578.83158 2102997.86594 37.754577326999 -122.434022589469 (37.754577326999, -122.434022589469) 2 4 5 28862 22
5639 85379 - 12 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3390 Cesar Chavez St 6 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6007302.06128 2100623.11206 37.7483237124677 -122.417520070933 (37.7483237124677, -122.417520070933) 2 4 7 28859 19
5656 71498 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 44 Almaden Ct 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5995892.99596 2112465.99366 37.7801926535255 -122.457828931472 (37.7801926535255, -122.457828931472) 11 6 2 54 16
5924 214716 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 163 Westgate Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5993482.35353 2094088.81019 37.729594862901 -122.464833426615 (37.729594862901, -122.464833426615) 9 8 4 59 40
5935 30897 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 252 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 7   Permit Number 34724 6007528.97575 2097493.20201 37.7397424432633 -122.416513727228 (37.7397424432633, -122.416513727228) 2 7 7 28859 2
6060 239556 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 222 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006749.08669 2098198.68674 37.741635656457 -122.419260290053 (37.741635656457, -122.419260290053) 2 7 7 28859 2
6061 72942 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 115 Gladstone Dr 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6006185.1456 2093706.67224 37.7292698047343 -122.420891365245 (37.7292698047343, -122.420891365245) 9 7 6 28861 5
6076 123107 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 526 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5992541.35538 2111846.16706 37.7782976564198 -122.469378557612 (37.7782976564198, -122.469378557612) 11 6 2 54 11
6082 237213 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 470 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002920.23053 2098629.95648 37.7426034430062 -122.432529972083 (37.7426034430062, -122.432529972083) 2 7 5 63 22

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