4,014 rows where qSpecies_id = 40 sorted by SiteOrder

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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
11905 237259 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 325 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6006662.65242 2096074.47296 37.7357981696519 -122.419408489336 (37.7357981696519, -122.419408489336) 2 7 7 28859 2
11922 78132 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 738 Dartmouth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6009313.83221 2090783.01669 37.7214179201914 -122.409868876754 (37.7214179201914, -122.409868876754) 9 3 7 309 28
11936 213433 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2326 Cecilia Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5991473.33081 2099563.75033 37.7445116227142 -122.472177683457 (37.7445116227142, -122.472177683457) 1 8 4 29491 40
12067 78234 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1200 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5999806.62934 2090324.19629 37.7196207041996 -122.44269961461 (37.7196207041996, -122.44269961461) 9 7 6 28861 25
12076 110751 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 510 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2015 12:00:00 AM 3   Permit Number 775489 5981042.2 2112214 37.778636382962 -122.509184994454 (37.778636382962, -122.509184994454) 11 6 2 55 26
12174 237303 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 375 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6008815.17724 2097064.11104 37.7386365028681 -122.412036256383 (37.7386365028681, -122.412036256383) 10 7 7 28859 2
12254 213339 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 375 Ralston St 1 : Tree Private 2     4 Width 3ft   5992194.58269 2090348.43318 37.7192503768696 -122.469013242585 (37.7192503768696, -122.469013242585) 9 8 6 64 24
12351 238094 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1106 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6009181.56819 2102633.1404 37.7539483780274 -122.411162722403 (37.7539483780274, -122.411162722403) 2 4 7 28859 19
12803 64859 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 45 Almaden Ct 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1989 12:00:00 AM 10   Permit Number 25875 5995863.10867 2112429.78445 37.7800915155758 -122.457929703566 (37.7800915155758, -122.457929703566) 11 6 2 54 16
13306 84576 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3966 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 4 3x3 Permit Number 769743 6003390.40048346 2101879.79659646 37.7515533971776 -122.431136171604 (37.7515533971776, -122.431136171604) 2 4 5 28862 22
13363 238529 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 32 Harry St 1 Sidewalk: Property side : Yard Tree Private 2     3     6003245.12676 2097701.12571 37.7400715069955 -122.431340287739 (37.7400715069955, -122.431340287739) 2 7 5 63 7
13408 28246 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3326 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/23/2002 12:00:00 AM 3 2X3   6011947.80562 2090200.17318 37.7199648154144 -122.400722979282 (37.7199648154144, -122.400722979282) 10 7 8 309 28
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
13439 238206 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 427 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2     28 Width 3ft   6003541.49659 2103297.00416 37.7554532756756 -122.430714784966 (37.7554532756756, -122.430714784966) 2 4 5 28862 22
13452 214499 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1314 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5992102.94479 2106463.61182 37.7634932615306 -122.470503050471 (37.7634932615306, -122.470503050471) 1 8 11 56 12
13508 237345 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 899 Jarboe Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6009109.05137 2096909.74742 37.7382291378753 -122.411009275572 (37.7382291378753, -122.411009275572) 10 7 7 28859 2
13720 91923 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1427 Irving St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/18/2009 12:00:00 AM 3 3x3   5991353.957672 2106548.744029 37.76368367545 -122.473099740894 (37.76368367545, -122.473099740894) 1 8 11 56 12
14093 238081 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 690X Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008596.10001 2098083.7185 37.741423827457 -122.412865791044 (37.741423827457, -122.412865791044) 10 7 7 28859 2
14192 28301 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3336 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2003 12:00:00 AM 8 3X3   6011974.10308 2090046.14983 37.719543365213 -122.400621263274 (37.719543365213, -122.400621263274) 10 7 8 309 28
14257 238498 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003477.34326 2097803.5179 37.7403658101453 -122.430544682709 (37.7403658101453, -122.430544682709) 2 7 5 63 7
14275 72259 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 231 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6002836.88949 2092205.70744 37.7249591941085 -122.432359414777 (37.7249591941085, -122.432359414777) 9 7 6 28861 5
14334 70497 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 182 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6003784.02088 2092788.04528 37.7266118242601 -122.429126790893 (37.7266118242601, -122.429126790893) 9 7 6 28861 5

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