4,014 rows where qSpecies_id = 40 sorted by PlotSize

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)
53788 40655 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 300 Congdon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/2005 12:00:00 AM 7   Permit Number 47919 6004683.61058 2093747.94444 37.7292983780117 -122.426085244164 (37.7292983780117, -122.426085244164) 9 7 6 28861 5
53799 237116 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 100 Hwy 101 Southbound 4 Back Yard : Yard Tree Private 2     5     6005840.35144 2109000.46624 37.7712436090254 -122.423170022474 (37.7712436090254, -122.423170022474) 8 2 5 28853 19
54359 68227 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 700 Irving St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32021 5993616.93785931 2106672.28749806 37.764153656105 -122.465281833175 (37.764153656105, -122.465281833175) 11 8 11 56 12
54467 59596 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1401 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/21/2014 12:00:00 AM 0   Permit Number 770950 6000181.59670606 2113731.76941076 37.7839135947641 -122.443083674123 (37.7839135947641, -122.443083674123) 15 6 11 29490 31
54909 49745 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 34@ LELAND Britton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM 4   Permit Number 46544 6008556.33506 2087877.23988 37.7133967814171 -122.412282069889 (37.7133967814171, -122.412282069889) 9 7 8 309 39
55740 41910 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 595 12th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2000 12:00:00 AM 1   Permit Number 42273 5992200.00918 2111450.35788 37.7771911401531 -122.470530554439 (37.7771911401531, -122.470530554439) 11 6 2 54 11
55789 35478 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 524 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/18/1998 12:00:00 AM 6   Permit Number 38890 5986598.81458 2112347.1481 37.7793280029197 -122.489972580124 (37.7793280029197, -122.489972580124) 11 6 2 55 26
56607 115280 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1670 Sloat Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM     Permit Number 775682 5985986.6 2095938.5 37.7342385999548 -122.490882714096 (37.7342385999548, -122.490882714096) 1 8 3 64 35
56894 44392 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1201X ATHENS ST 2 Sidewalk: Curb side : Cutout Tree Private 2   03/22/2001 12:00:00 AM     Permit Number 43750 6001492 2087581 37.7121844315022 -122.436677650137 (37.7121844315022, -122.436677650137) 9 7 6 28861 5
56967 48563 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 53 Byxbee St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/2002 12:00:00 AM     Permit Number 45982 5991907.82184104 2088893.56567496 37.7152390922347 -122.469898587444 (37.7152390922347, -122.469898587444) 9 8 6 64 24
56998 37620 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 630 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM 3   Permit Number 40044 5990677.73899 2111070.74016 37.7760606748146 -122.475768788042 (37.7760606748146, -122.475768788042) 11 6 2 54 26
57134 55259 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 Britton St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/1972 12:00:00 AM 8   Permit Number 11181 6008604.18987 2088002.78931 37.7137441994136 -122.412125533875 (37.7137441994136, -122.412125533875) 9 7 8 309 39
57272 64861 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 52 Almaden Ct 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1989 12:00:00 AM 6   Permit Number 25877 5995901.57947 2112392.78617 37.7799921383013 -122.457793938484 (37.7799921383013, -122.457793938484) 11 6 2 54 16
57460 108081 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 626 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           6010239.31853 2105432.72154 37.7616946632209 -122.407702139761 (37.7616946632209, -122.407702139761) 10 4 8 28859 19
58178 68544 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 571 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM 8   Permit Number 32430 5982530.7498 2111896.54419 37.777852390021 -122.504012093664 (37.777852390021, -122.504012093664) 11 6 2 55 26
58358 40656 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 300 Congdon St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/2005 12:00:00 AM 5   Permit Number 47919 6004682.83135 2093737.61351 37.7292699675313 -122.426087202875 (37.7292699675313, -122.426087202875) 9 7 6 28861 5
58690 47521 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 250 Santa Rosa Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45392 6000921.51016478 2093527.18016994 37.728478861528 -122.439075316563 (37.728478861528, -122.439075316563) 9 7 6 28861 25
58762 45577 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3866 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2001 12:00:00 AM 3   Permit Number 44317 5996397.21092 2114961.83643 37.7870745279007 -122.456265143944 (37.7870745279007, -122.456265143944) 11 6 1 54 31
59393 50792 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2740 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2     2   Permit Number 47317 5999864.3976 2118141.20218 37.7960026509676 -122.444498073449 (37.7960026509676, -122.444498073449) 13 9 1 57 17
59438 45485 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3036 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/2001 12:00:00 AM 3   Permit Number 44264 5990298.1598 2095038.91467 37.7320195070769 -122.475910756673 (37.7320195070769, -122.475910756673) 1 8 4 64 35
59447 52174 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1X Albion St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2005 12:00:00 AM     Permit Number 48366 6005910.85537193 2107243.06588365 37.766422185477 -122.422801230733 (37.766422185477, -122.422801230733) 8 4 5 28853 19
59520 48455 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 583 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/05/2002 12:00:00 AM     Permit Number 45823 5999806.95358347 2104023.79131082 37.7572365678724 -122.443682145846 (37.7572365678724, -122.443682145846) 2 5 5 28862 3
59546 40019 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 12 Latona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 6   Permit Number 41264 6014412.91208 2094585.93232 37.7321444139378 -122.392508504263 (37.7321444139378, -122.392508504263) 10 3 8 58 1
59738 52528 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 142 San Juan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2005 12:00:00 AM 7   Permit Number 48628 6001332.37944 2092272.13723 37.7250561697812 -122.437565081984 (37.7250561697812, -122.437565081984) 9 7 6 28861 25
59928 69413 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 73 Seville St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/1994 12:00:00 AM 4   Permit Number 33518 6001961.1999 2087395.46496 37.711701646594 -122.43504269857 (37.711701646594, -122.43504269857) 9 7 6 28861 5
59977 50487 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 247 Louisburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/2003 12:00:00 AM     Permit Number 47123 5997593.4002378 2090478.75871424 37.7199186793696 -122.450361048898 (37.7199186793696, -122.450361048898) 9 8 6 28861 24
60307 66567 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 41 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/15/1991 12:00:00 AM 16   Permit Number 29756 6005047.11996 2093219.91873 37.7278690746777 -122.424791009107 (37.7278690746777, -122.424791009107) 9 7 6 28861 5
60473 37967 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 456 Missouri St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM 5   Permit Number 40197 6013486.47926 2104950.0016 37.7605504594599 -122.396437603638 (37.7605504594599, -122.396437603638) 10 3 8 28856 29
60810 97558 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 324 Vicente St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2011 12:00:00 AM     Permit Number 768235 5991924.2 2097789.3 37.7396655169148 -122.470489475237 (37.7396655169148, -122.470489475237) 1 8 4 59 40
61226 237210 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 483 Valley St 6 Sidewalk: Curb side : Yard Tree Private 2     1     6002788.03138 2099167.4963 37.7440719046074 -122.43302547424 (37.7440719046074, -122.43302547424) 2 7 5 63 22
61293 124047 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 693 11th Ave 1 Sidewalk: Property side : Yard Tree Private 2     6     5992526.15399 2110751.16453 37.7752901975761 -122.469351420391 (37.7752901975761, -122.469351420391) 11 6 2 54 11
61476 69497 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 55 Otsego Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/24/1994 12:00:00 AM 6   Permit Number 33620 6000865.52787 2092792.12819 37.7264573917689 -122.439216186893 (37.7264573917689, -122.439216186893) 9 7 6 28861 25
61818 50771 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 638 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/04/2004 12:00:00 AM 7   Permit Number 47314 5988487.78798 2111617.79391 37.7774355226981 -122.483384430148 (37.7774355226981, -122.483384430148) 11 6 2 55 26
62065 94707 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 40 Edgehill Way 2 Sidewalk: Property side : Yard Tree Private 2   10/29/2010 12:00:00 AM 6   Permit Number 53868 5994701.2 2098925.3 37.7429448703691 -122.460970181408 (37.7429448703691, -122.460970181408) 1 8 4 59 40
62747 40637 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 142 Russ St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/10/1999 12:00:00 AM 13   Permit Number 41636 6010361.02696 2111479.70343 37.7783050974438 -122.407707586435 (37.7783050974438, -122.407707586435) 14 2 9 28853 34
63274 45510 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2929 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/2001 12:00:00 AM 4   Permit Number 44276 5988794.07528 2095754.20535 37.7338961880477 -122.481162998885 (37.7338961880477, -122.481162998885) 1 8 4 64 35
64059 46848 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 198 Naples St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/25/2002 12:00:00 AM     Permit Number 44916 6004181.50847912 2092412.60436793 37.72560343989 -122.427725951573 (37.72560343989, -122.427725951573) 9 7 6 28861 5
64316 66574 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 275 Maynard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/15/1991 12:00:00 AM 9   Permit Number 29764 6005180.34697 2093822.91903 37.7295323042601 -122.424373310882 (37.7295323042601, -122.424373310882) 9 7 6 28861 5
64537 50859 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 265 Tingley St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2004 12:00:00 AM     Permit Number 47374 6001990.14047863 2094209.80770193 37.7304139486402 -122.435429823591 (37.7304139486402, -122.435429823591) 9 7 6 28861 25
65636 37565 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4722 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/16/2014 12:00:00 AM 3   Permit Number 773499 6000146.90061434 2104650.61343097 37.7589770506678 -122.442551483621 (37.7589770506678, -122.442551483621) 2 4 5 28862 3
65799 62176 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 42 Meda Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/26/1985 12:00:00 AM 14   Permit Number 22292 6000115.63671 2091826.84592 37.7237642478004 -122.441739275348 (37.7237642478004, -122.441739275348) 9 7 6 28861 25
65809 99710 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 100 Paloma Ave 3 Sidewalk: Property side : Yard Tree Private 2           5992094.2 2093835.6 37.7288194775612 -122.469613947177 (37.7288194775612, -122.469613947177) 9 8 4 59 40
65972 43259 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 445 Wayland St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/12/2000 12:00:00 AM 8   Permit Number 43042 6010225.92511 2092216.88388 37.7254060959994 -122.406817013015 (37.7254060959994, -122.406817013015) 10 3 7 309 28
66320 65288 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 41 Rico Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/07/1990 12:00:00 AM 7   Permit Number 28836 6001457.59323 2121333.88235 37.8048596843835 -122.439214266819 (37.8048596843835, -122.439214266819) 13 9 1 57 17
66708 39922 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2335 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/1999 12:00:00 AM 6   Permit Number 41196 6003527.33622 2116558.3105 37.7918647577979 -122.431710530526 (37.7918647577979, -122.431710530526) 13 9 1 29490 27
66922 32354 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 116 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/03/1996 12:00:00 AM 16   Permit Number 36908 6002648.503 2105198.23241 37.7606229592107 -122.433938919273 (37.7606229592107, -122.433938919273) 2 4 5 28862 3
67796 33273 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1121 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/13/1996 12:00:00 AM 7   Permit Number 37442 6009382.25638 2117052.96271 37.7935530901583 -122.411487381259 (37.7935530901583, -122.411487381259) 3 1 10 28857 21
67957 213281 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 321 Ashton Ave 1 Sidewalk: Property side : Yard Tree Private 2     10     5994152.36191 2092054.50461 37.7240477617885 -122.462369665551 (37.7240477617885, -122.462369665551) 9 8 4 59 40
69041 44741 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 271 Saint Charles Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/2001 12:00:00 AM 3   Permit Number 43859 5992054.55445 2086618.70048 37.7090013413078 -122.469225944836 (37.7090013413078, -122.469225944836) 9 8 4 64 24
69230 31466 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 512 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1995 12:00:00 AM 4   Permit Number 35032 6002998.75397 2102141.19875 37.7522489444334 -122.432509202251 (37.7522489444334, -122.432509202251) 2 4 5 28862 22
69305 47977 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2455 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45711 5992012.3429777 2098733.73104635 37.7422637805034 -122.47025347442 (37.7422637805034, -122.47025347442) 1 8 4 29491 40
69568 68878 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 535 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM 9   Permit Number 32849 5994664.33554 2111876.7239 37.778504013274 -122.462036654628 (37.778504013274, -122.462036654628) 11 6 2 54 11
69638 48506 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 45 Cordova St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM 5   Permit Number 45843 6001715.61599 2087735.00145 37.7126199910876 -122.43591578109 (37.7126199910876, -122.43591578109) 9 7 6 28861 5
70689 94959 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1059 Evans Ave 1 Sidewalk: Property side : Yard Tree Private 2   12/09/2010 12:00:00 AM       6018613.9 2096078.3 37.7364745658864 -122.378088153142 (37.7364745658864, -122.378088153142) 10 3 8 58 1
70859 96362 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1432 23rd Ave   Sidewalk: Curb side : Cutout Tree Private 2   05/12/2011 12:00:00 AM     Permit Number 767816 5989066.4 2105558.5 37.7608320226819 -122.480939093689 (37.7608320226819, -122.480939093689) 1 8 3 56 35
71695 100034 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1199@Washington Mason St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5   08/02/2012 12:00:00 AM     Permit Number 769129 6009411 2117399.5 37.7945062091547 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
71705 115279 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1670 Sloat Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM     Permit Number 775682 5985986.6 2095938.5 37.7342385999548 -122.490882714096 (37.7342385999548, -122.490882714096) 1 8 3 64 35
72009 43296 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 589 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/12/2015 12:00:00 AM 3   Permit Number 775309 6013581.06232 2104334.57728 37.7588659015663 -122.396067351846 (37.7588659015663, -122.396067351846) 10 3 8 28856 29
72323 43023 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 519 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2000 12:00:00 AM 9   Permit Number 42885 6004020.08181 2110698.29349 37.7758025350991 -122.429587516272 (37.7758025350991, -122.429587516272) 7 9 11 29492 10
72654 43678 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 447 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM 11   Permit Number 43321 5994953.99228 2112486.25959 37.7801943078359 -122.461078821483 (37.7801943078359, -122.461078821483) 11 6 2 54 11
72807 58303 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 150 Delmar St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2016 12:00:00 AM 3   Permit Number 772898 5999424.90355926 2107324.72926963 37.7662783248476 -122.445240741314 (37.7662783248476, -122.445240741314) 15 5 5 29492 9
73927 50360 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 807 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2003 12:00:00 AM 3   Permit Number 47032 6011601.76017 2104587.37273 37.7594496982747 -122.402930518137 (37.7594496982747, -122.402930518137) 10 3 8 28856 29
74075 108083 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 626 Potrero Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           6010239.31853 2105432.72154 37.7616946632209 -122.407702139761 (37.7616946632209, -122.407702139761) 10 4 8 28859 19
74678 64863 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 77 Almaden Ct 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1989 12:00:00 AM 5   Permit Number 25879 5995882.63467 2112271.55178 37.7796581724444 -122.45785070124 (37.7796581724444, -122.45785070124) 11 6 2 54 16
74983 67962 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 859 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM 3   Permit Number 31683 5986944.37754 2110090.62613 37.7731524036412 -122.488611249777 (37.7731524036412, -122.488611249777) 11 6 2 55 26
76004 47146 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 138 Aptos Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/07/2002 12:00:00 AM     Permit Number 45119 5992930.24436849 2094060.37682206 37.7294849440246 -122.466740042815 (37.7294849440246, -122.466740042815) 9 8 4 59 40
77029 51447 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 326 Bocana St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2004 12:00:00 AM     Permit Number 47765 6006818.05257651 2097195.51767411 37.7388850615796 -122.41895069494 (37.7388850615796, -122.41895069494) 2 7 7 28859 2
77137 57611 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 356 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/1976 12:00:00 AM 13   Permit Number 16500 6013179.72476 2105412.69394 37.7618038355947 -122.397530985864 (37.7618038355947, -122.397530985864) 10 3 8 28856 29
77485 237431 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1204 Diamond St 1 Sidewalk: Curb side : Pot Tree Private 2     8     6001926.93451 2100562.26984 37.7478527426092 -122.436102739369 (37.7478527426092, -122.436102739369) 2 4 5 63 22
77491 49399 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 535@ BALBOA 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/18/2003 12:00:00 AM 3   Permit Number 46352 5993738.83746 2111833.00909 37.7783306565586 -122.465235101695 (37.7783306565586, -122.465235101695) 11 6 2 54 11
77718 46685 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1563 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/2016 12:00:00 AM     Permit Number 776034 5992114.70084954 2104801.75310053 37.758930915917 -122.470341358559 (37.758930915917, -122.470341358559) 1 8 4 56 12
78450 94948 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Pomona St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
78958 115432 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 121 Edgehill Way 2 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2016 12:00:00 AM 3   Permit Number 777500 5994912.6 2098995.5 37.7431497843009 -122.460244308613 (37.7431497843009, -122.460244308613) 1 8 4 59 40
79124 34480 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 771 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM 18   Permit Number 38207 6009276.26447 2119410.9605 37.8000216267413 -122.412020839304 (37.8000216267413, -122.412020839304) 3 1 10 308 4
79153 47019 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 380 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/02/2002 12:00:00 AM     Permit Number 45014 6004716.89647578 2110040.09694572 37.7740347181094 -122.427130164093 (37.7740347181094, -122.427130164093) 7 9 11 28852 10
79234 51284 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2205 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2004 12:00:00 AM 4   Permit Number 47656 6000322.72568 2116238.1776 37.7908035865572 -122.442775457127 (37.7908035865572, -122.442775457127) 13 6 1 29490 27
79423 31513 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2513 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 15   Permit Number 35071 6011012.0661 2102261.56789 37.7530306081845 -122.404806236834 (37.7530306081845, -122.404806236834) 10 4 8 28859 19
80364 45549 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 345 Sloat Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2001 12:00:00 AM 4   Permit Number 44299 5990323.96119 2095935.96592 37.7344840775814 -122.475887044262 (37.7344840775814, -122.475887044262) 1 8 4 64 35
81042 106983 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1737-1795 Post St 4 Sidewalk: Curb side : Cutout Tree DPW 1   07/01/2012 12:00:00 AM 4     6003734.5 2114103.2 37.7851353863698 -122.430818459211 (37.7851353863698, -122.430818459211) 13 9 11 29490 13
81108 49149 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2721 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2003 12:00:00 AM 8   Permit Number 46272 6001579.27273 2117782.40416 37.7951151846669 -122.438538563903 (37.7951151846669, -122.438538563903) 13 9 1 57 27
81146 50013 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 999 Wisconsin St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2009 12:00:00 AM 2   Permit Number 52022 6012813.23846 2102916.22313 37.7549286606329 -122.398623329429 (37.7549286606329, -122.398623329429) 10 3 8 28856 29
81439 47701 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Laidley St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2002 12:00:00 AM     Permit Number 45497 6003509.82655426 2097791.42406059 37.7403344433628 -122.430431505695 (37.7403344433628, -122.430431505695) 2 7 5 63 7
82301 62079 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 595 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/1985 12:00:00 AM 14   Permit Number 22161 6013301.58361 2104304.12984 37.7587667459021 -122.397031791103 (37.7587667459021, -122.397031791103) 10 3 8 28856 29
82981 48493 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 688(REVISED) Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM     Permit Number 45836 6008651.5358149 2098064.55146278 37.7413743105027 -122.412672757895 (37.7413743105027, -122.412672757895) 10 7 7 28859 2
83349 33813 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 261 Linden St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/26/1996 12:00:00 AM 6   Permit Number 37827 6006152.11101 2110895.22751 37.7764637562375 -122.422226270344 (37.7764637562375, -122.422226270344) 7 9 11 28852 10
83624 33812 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 261 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/26/1996 12:00:00 AM 5   Permit Number 37827 6006136.86682 2110893.01835 37.776456830551 -122.422278847415 (37.776456830551, -122.422278847415) 7 9 11 28852 10
84071 43214 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 365 Sweeny St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2000 12:00:00 AM 5   Permit Number 43005 6008676.285 2094499.96863 37.7315881292836 -122.412335294439 (37.7315881292836, -122.412335294439) 9 3 7 309 28
84092 34483 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 845 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM 8   Permit Number 38210 6008918.61834 2119360.64227 37.7998633928514 -122.413254875509 (37.7998633928514, -122.413254875509) 3 1 10 308 32
84216 47399 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 627 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM 3   Permit Number 45310 5994686.98675 2111235.69119 37.7767452124767 -122.461911800485 (37.7767452124767, -122.461911800485) 11 6 2 54 11
84440 30682 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 425 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3   Permit Number 782764 6004593.18284 2110062.14173 37.7740882510028 -122.427559681752 (37.7740882510028, -122.427559681752) 7 9 11 28852 10
84450 104867 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 411 Holladay Ave 2 Front Yard : Yard Tree Private 2         Permit Number 770735 6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
84550 45513 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2917 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/2001 12:00:00 AM 3   Permit Number 44278 5988534.98014 2095768.80664 37.733921213495 -122.482059828009 (37.733921213495, -122.482059828009) 1 8 4 64 35
85139 45478 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3008 20th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/2001 12:00:00 AM 4   Permit Number 44261 5990292.27426 2095193.28859 37.732443037405 -122.475942374151 (37.732443037405, -122.475942374151) 1 8 4 64 35
85613 68681 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 324 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1993 12:00:00 AM 3   Permit Number 32590 5992799.21781 2113282.48251 37.7822562861189 -122.468591057596 (37.7822562861189, -122.468591057596) 11 6 2 54 11
85793 50929 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2261 Cecelia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2004 12:00:00 AM     Permit Number 47425 5991475.24491559 2099916.59093812 37.7454805429508 -122.472196779655 (37.7454805429508, -122.472196779655) 1 8 4 29491 40
86033 46596 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2480 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2002 12:00:00 AM 3   Permit Number 45794 6001101.66117 2118661.22174 37.7975010069291 -122.440254222167 (37.7975010069291, -122.440254222167) 13 9 1 57 17
86390 47315 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1420 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/2002 12:00:00 AM     Permit Number 45244 6010384.18455371 2100995.83638931 37.7495200736312 -122.406888381765 (37.7495200736312, -122.406888381765) 2 4 7 28859 19
86715 47032 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 22 Waller St 3 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
86919 31989 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 147 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/30/1995 12:00:00 AM 6   Permit Number 35389 5994568.75053 2114560.86481 37.78586843793 -122.462562068449 (37.78586843793, -122.462562068449) 11 6 1 54 11
86937 84667 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4045 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM     Permit Number 769743 6002887.32453677 2101799.94982156 37.7513056360956 -122.432870165781 (37.7513056360956, -122.432870165781) 2 4 5 28862 22

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);