4,014 rows where qSpecies_id = 40 sorted by PermitNotes

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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
11861 238293 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 500 Noe St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6002958.3348 2105235.38504 37.7607425492493 -122.432870006646 (37.7607425492493, -122.432870006646) 2 4 5 28862 3
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
12131 253666 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 578 07th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   5993791.71774 2111566.05198 37.7776007134003 -122.465032776868 (37.7776007134003, -122.465032776868) 11 6 2 54 11
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
12532 238079 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 690X Jarboe Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008738.1032 2096906.59496 37.7381996733624 -122.412291612561 (37.7381996733624, -122.412291612561) 10 7 7 28859 2
13146 237136 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1346 York St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 6ft   6010061.84572 2101335.33586 37.7504342222613 -122.408026983369 (37.7504342222613, -122.408026983369) 2 4 7 28859 19
13155 196442 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 971 Kansas St 3 Sidewalk: Curb side : Pot Tree Private 2     1 Width 5ft   6011633.49107 2103859.13783 37.7574518984069 -122.402769561075 (37.7574518984069, -122.402769561075) 10 3 8 28856 29
13259 237350 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1103X Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6008148.75924 2097711.60284 37.7403769599395 -122.414386221764 (37.7403769599395, -122.414386221764) 2 7 7 28859 2
13277 135995 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6009287.1824 2117369.66466 37.7944173431466 -122.411838735572 (37.7944173431466, -122.411838735572) 3 1 10 28857 21
13292 136017 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 290 Green St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6011553.12596 2119421.08108 37.8001768973966 -122.404142699051 (37.8001768973966, -122.404142699051) 3 1 10 308 23
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
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
13441 82704 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 67 Jennings Ct 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6012930.12709 2089200.71503 37.7172752435332 -122.397257359943 (37.7172752435332, -122.397257359943) 10 3 8 58 1
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
13539 239376 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 475 Hoffman Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6000689.17836 2101277.96611 37.749747474776 -122.440434152212 (37.749747474776, -122.440434152212) 2 4 5 28862 22
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
13745 118798 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 810 45th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   5982020.13723 2110219.13712 37.7732166816615 -122.505654072986 (37.7732166816615, -122.505654072986) 11 6 2 55 26
13878 237207 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 483 Valley St 2 Sidewalk: Curb side : Yard Tree Private 2     1     6002742.12056 2099166.74161 37.7440672281147 -122.433184169536 (37.7440672281147, -122.433184169536) 2 7 5 63 22
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
14380 70403 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 215 Oxford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   18     6006511.50188 2092924.30251 37.7271399781258 -122.419707630826 (37.7271399781258, -122.419707630826) 9 7 7 309 5
14535 119254 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008843.96123 2117672.51917 37.7952240323069 -122.413393767718 (37.7952240323069, -122.413393767718) 5 1 10 308 21
14565 99798 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 723-725 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001735 2102034 37.7518828570558 -122.436871780919 (37.7518828570558, -122.436871780919) 2 4 5 28862 22
14586 237305 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 185 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6008838.31822 2097699.45702 37.7403823225842 -122.412001132442 (37.7403823225842, -122.412001132442) 10 7 7 28859 2
14705 78251 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 559 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     6002953.55708 2090366.3939 37.7199154633005 -122.431824838869 (37.7199154633005, -122.431824838869) 9 7 6 28861 5
14747 260897 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 65 Colin P Kelly Jr St 10 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6015356.8087 2112701.67439 37.7819387497011 -122.390510590187 (37.7819387497011, -122.390510590187) 6 2 9 28856 6
15012 114856 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1416x Bush St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2016 12:00:00 AM 3 3x3   6006677.76742 2115342.38606 37.7887042046809 -122.420723655192 (37.7887042046809, -122.420723655192) 13 9 10 28858 21
15075 70171 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 775 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5990355.07569 2110118.24586 37.7734266747554 -122.476815345127 (37.7734266747554, -122.476815345127) 11 6 2 55 26
15194 238290 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4053 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002616.60464 2105290.16749 37.7608735804778 -122.434055813139 (37.7608735804778, -122.434055813139) 2 4 5 28862 3
15218 91934 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1115 Irving St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/19/2009 12:00:00 AM 3 3x3   5992339.241228 2106582.494136 37.7638333412086 -122.46969443927 (37.7638333412086, -122.46969443927) 1 8 11 56 12
15257 258903 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1 Massasoit St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010100 2099291 37.7448230609493 -122.407750909418 (37.7448230609493, -122.407750909418) 2 7 7 28859 2
15324 213539 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1560 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5995783.29259 2094350.88739 37.7304468581388 -122.456897840377 (37.7304468581388, -122.456897840377) 9 7 4 28861 40
15377 214743 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 143 Eastwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5995640.47159 2093655.78153 37.7285300628876 -122.457341322169 (37.7285300628876, -122.457341322169) 9 7 4 28861 40
15514 238082 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 690X Powhattan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008610.29695 2098081.77982 37.7414193011484 -122.412816565743 (37.7414193011484, -122.412816565743) 10 7 7 28859 2
15572 70521 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 345 Congdon St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6004728.05962 2093562.78266 37.7287924769796 -122.425918404632 (37.7287924769796, -122.425918404632) 9 7 6 28861 5
15931 70127 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 236 Avalon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6003416.21624 2092787.34546 37.7265890750119 -122.430398228113 (37.7265890750119, -122.430398228113) 9 7 6 28861 5
16118 238091 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 143 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007328.83633 2100176.58773 37.7470991638041 -122.417395843442 (37.7470991638041, -122.417395843442) 2 7 7 28859 2
16146 4184 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3835 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/01/1995 12:00:00 AM 12 3X3   6004944.66483 2100451.11353 37.7477185170056 -122.425659653475 (37.7477185170056, -122.425659653475) 2 4 5 63 22
16183 135997 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Washington St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6009336.40364 2117377.1493 37.7944406553528 -122.411668952587 (37.7944406553528, -122.411668952587) 3 1 10 28857 21
16256 260911 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2035 15th Ave 1 Front Yard : Yard Tree Private 2       Width 3ft   5991575 2101572 37.7500316406912 -122.471972478281 (37.7500316406912, -122.471972478281) 1 8 4 29491 12

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