4,014 rows where qSpecies_id = 40 sorted by PlantType

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)
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
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
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
12211 238341 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 227 Collingwood St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2020 12:00:00 AM 3 Width 3ft Permit Number 787829 6002087.73113 2104529.67514 37.7587554234364 -122.435830536172 (37.7587554234364, -122.435830536172) 2 4 5 28862 3
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
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
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
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
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
14218 92323 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2595 27th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2009 12:00:00 AM   3x3 Permit Number 52755 5987970.2 2097662.1 37.7390868384366 -122.484151218827 (37.7390868384366, -122.484151218827) 1 8 3 29491 35
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
14762 62197 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 195 Otsego Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1986 12:00:00 AM 14   Permit Number 22671 6000569.72887 2092182.49012 37.7247666285575 -122.44019505038 (37.7247666285575, -122.44019505038) 9 7 6 28861 25
14867 59187 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 559 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/30/1980 12:00:00 AM 13   Permit Number 18503 5989063.8728 2111532.21619 37.7772340613072 -122.481385317518 (37.7772340613072, -122.481385317518) 11 6 2 55 26
14964 62499 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 142 Otsego Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1986 12:00:00 AM 11   Permit Number 22673 6000619.30471 2092428.32179 37.725444448481 -122.440041292395 (37.725444448481, -122.440041292395) 9 7 6 28861 25
14998 101958 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 200X Ripley St 1 Sidewalk: Property side : Cutout Tree Private 2   06/12/2013 12:00:00 AM   3x3 Permit Number 770180 6009339 2099105 37.744269714821 -122.410369184032 (37.744269714821, -122.410369184032) 2 7 7 28859 2
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
15090 108919 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 624 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/2015 12:00:00 AM 3 3x3 Permit Number 773067 6007633.7 2096431.2 37.7368323085558 -122.416076443366 (37.7368323085558, -122.416076443366) 2 7 7 28859 2
15130 31987 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 128 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/30/1995 12:00:00 AM 11   Permit Number 35387 5994614.2845 2114627.8658 37.7860550266291 -122.462409396175 (37.7860550266291, -122.462409396175) 11 6 1 54 11
15161 45552 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 168 Sylvan Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2001 12:00:00 AM 3   Permit Number 44300 5987586.87726 2094815.36489 37.7312481217032 -122.485267730441 (37.7312481217032, -122.485267730441) 1 8 4 64 35
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
15304 45481 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3014 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/2001 12:00:00 AM 3   Permit Number 44262 5990295.67943 2095138.00578 37.7322914422893 -122.475926565872 (37.7322914422893, -122.475926565872) 1 8 4 64 35
15305 62479 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 35 Delano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/1993 12:00:00 AM 10   Permit Number 31826 6000682.25846 2093099.29894 37.7272903816351 -122.439871753995 (37.7272903816351, -122.439871753995) 9 7 6 28861 25
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
15704 115340 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 566 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/2016 12:00:00 AM 3   Permit Number 776419 5993501.9 2111635.8 37.7777755071295 -122.466040415497 (37.7777755071295, -122.466040415497) 11 6 2 54 11
15749 108724 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 566 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773100 6011759.6093 2105732.18704 37.7626019164795 -122.402465094694 (37.7626019164795, -122.402465094694) 8 3 8 28856 29
15892 78237 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1215 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3   Permit Number 779512 5999758.88688 2090259.2057 37.7194395330998 -122.442859978114 (37.7194395330998, -122.442859978114) 9 7 6 28861 25
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
16209 262261 - 12 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 290 Green St   : Tree Private 2 FUF 06/18/2020 12:00:00 AM 3   Permit Number 785454 6011550.34746 2119418.71162 37.8001702361868 -122.404152146942 (37.8001702361868, -122.404152146942) 3 1 10 308 23
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
16267 261182 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 360 Benton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006757 2095391 37.733926817061 -122.41903382937 (37.733926817061, -122.41903382937) 2 7 7 28859 2
16351 92032 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4232 21st St   Sidewalk: Curb side : Cutout Tree Private 2   06/12/2009 12:00:00 AM   3x3 Permit Number 52175 6001386.1 2103403.9 37.75562443672 -122.43817644846 (37.75562443672, -122.43817644846) 2 4 5 28862 3
16447 237246 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1011 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5998816.10599 2106399.33422 37.763702653385 -122.447279838404 (37.763702653385, -122.447279838404) 15 5 11 29492 9
16466 238123 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3388 17th St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/01/2000 12:00:00 AM 11 Width 3ft Permit Number 42107 6006474.57216 2106141.49112 37.7634293107474 -122.42077322222 (37.7634293107474, -122.42077322222) 8 4 7 28859 19
16544 84392 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2101 Jerrold Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6012504.25768 2099077.65785 37.7443715685998 -122.399422411225 (37.7443715685998, -122.399422411225) 10 3 8 58 1
16564 62492 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 61 Otsego Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1986 12:00:00 AM 17   Permit Number 22663 6000854.65183 2092771.54235 37.7264002488622 -122.43925230995 (37.7264002488622, -122.43925230995) 9 7 6 28861 25
16604 213316 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 325 Howth St 2 : Tree Private 2     3 Width 3ft   5997165.98186 2090264.50059 37.7193059055324 -122.451823029928 (37.7193059055324, -122.451823029928) 9 8 6 28861 24
16667 261183 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 360 Benton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006757 2095391 37.733926817061 -122.41903382937 (37.733926817061, -122.41903382937) 2 7 7 28859 2
16769 238506 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 46 Wilder St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6002753.72188 2095533.8634 37.7340928410181 -122.432884572069 (37.7340928410181, -122.432884572069) 2 7 5 63 7
16830 213628 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 518 Rockdale Dr 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5997988.71827 2097660.25448 37.7396599853215 -122.449511768669 (37.7396599853215, -122.449511768669) 9 7 4 59 40
16871 83424 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 987 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6012206.17554 2103813.08601 37.7573574093248 -122.400785742066 (37.7573574093248, -122.400785742066) 10 3 8 28856 29
16875 108379 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 125 Bertita St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/28/2020 01:08:00 PM 3 3x3 Permit Number 773806 6000690.09097 2090159.58738 37.7192190489897 -122.439634019098 (37.7192190489897, -122.439634019098) 9 7 6 28861 25
16894 51883 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 209 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2005 12:00:00 AM     Permit Number 48099 6006849.08815448 2097918.82782797 37.740872857816 -122.418894673949 (37.740872857816, -122.418894673949) 2 7 7 28859 2
16956 103454 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 284 24th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2019 12:00:00 AM 3 3x3   5988396.69633 2114118.88325 37.7842975073391 -122.483882980771 (37.7842975073391, -122.483882980771) 11 6 2 55 26
17003 238219 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3917 25th St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6004421.85742 2101298.96602 37.7500169674173 -122.427527888021 (37.7500169674173, -122.427527888021) 2 4 5 28862 22
17063 179027 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 376 Ordway St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010782.01904 2090025.31129 37.719419589727 -122.404740419057 (37.719419589727, -122.404740419057) 10 7 8 309 28
17096 95570 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 564 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767361 6001501 2101469 37.7503181999041 -122.437640524789 (37.7503181999041, -122.437640524789) 2 4 5 28862 22
17111 71253 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1436 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10 3x3   6007270.15279 2117448.61656 37.7945207624857 -122.418823519012 (37.7945207624857, -122.418823519012) 5 1 10 28858 32
17129 33142 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3148 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 8   Permit Number 37368 6001934.81136 2119023.66644 37.7985435846779 -122.437397274777 (37.7985435846779, -122.437397274777) 13 9 1 57 17
17130 238435 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 288 States St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6000346.17489 2106832.48905 37.7649792994737 -122.442018912365 (37.7649792994737, -122.442018912365) 15 5 5 28862 3
17131 72323 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 35 Almaden Ct 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5995855.97542 2112465.40969 37.7801889231991 -122.457956959381 (37.7801889231991, -122.457956959381) 11 6 2 54 16
17185 78318 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 605 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5 3x6   6008900.36842 2091273.56909 37.7227416934471 -122.411332749116 (37.7227416934471, -122.411332749116) 9 3 7 309 28
17239 32497 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 665 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/15/1996 12:00:00 AM 16   Permit Number 37002 6007442.30694 2095863.10154 37.7352616718948 -122.416697941676 (37.7352616718948, -122.416697941676) 2 7 7 28859 2
17260 57706 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 268 Hermann St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2009 12:00:00 AM   3x3 Permit Number 52597 6003986.30319774 2108724.10323801 37.7703799791966 -122.429563538214 (37.7703799791966, -122.429563538214) 7 9 11 29492 10
17266 178980 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 38 Whipple Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5998273.42881 2087174.03892 37.7108835719974 -122.447772651587 (37.7108835719974, -122.447772651587) 9 7 6 28861 25
17312 261181 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 340 Benton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006673 2095420 37.7340017140914 -122.419326300122 (37.7340017140914, -122.419326300122) 2 7 7 28859 2
17324 91930 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1201X IRVING ST 6 Sidewalk: Curb side : Cutout Tree DPW 1   06/11/2014 12:00:00 AM 3 3x3   5992070 2106573 37.7637917074669 -122.470624962715 (37.7637917074669, -122.470624962715) 1 8 11 56 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)
);