4,014 rows where qSpecies_id = 40 sorted by qCareAssistant

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

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