trees

614 rows where qSpecies_id = 29 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

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)
2407 38882 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 101 Commonwealth Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM     Permit Number 40703 5996508.72142362 2113802.71293841 37.7838982845648 -122.455795523067 (37.7838982845648, -122.455795523067) 11 6 1 54 31
4016 52794 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1277TEHAMA Houston St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2006 12:00:00 AM     Permit Number 48833                    
5667 52792 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1277TEHAMA Houston St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2006 12:00:00 AM     Permit Number 48833                    
6569 82802 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 770 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52410 5983565.30013547 2110567.26400669 37.7742633542941 -122.500334977362 (37.7742633542941, -122.500334977362) 11 6 2 55 26
8281 87805 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 21 Mallorca Way   Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50570 6001886.8 2119949.6 37.8010832252731 -122.437629755692 (37.8010832252731, -122.437629755692) 13 9 1 57 17
11431 35742 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29   2 Sidewalk: Curb side : Cutout Tree Private 2   04/15/1998 12:00:00 AM     Permit Number 39016                    
12760 32019 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 900 07th St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/24/1995 12:00:00 AM     Permit Number 35412 6012513.40810989 2108571.960758 37.7704413522571 -122.400057399946 (37.7704413522571, -122.400057399946) 14 2 8 28856 20
13707 35743 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29   1 Sidewalk: Curb side : Cutout Tree Private 2   04/15/1998 12:00:00 AM     Permit Number 39016                    
13860 52793 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1277TEHAMA Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2006 12:00:00 AM     Permit Number 48833                    
15621 68830 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 111 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/30/1993 12:00:00 AM     Permit Number 32781 6000000.33338592 2094041.19205625 37.7298377607142 -122.442296747396 (37.7298377607142, -122.442296747396) 9 7 4 63 40
16909 38635 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1595 Shafter Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM   33 Permit Number 767658 6014940.81298911 2094124.48881728 37.7309066855794 -122.390651184611 (37.7309066855794, -122.390651184611) 10 3 8 58 1
18659 68867 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 123 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/08/1994 12:00:00 AM     Permit Number 32831 5999260.75597787 2093758.61799029 37.7290196985316 -122.444833238065 (37.7290196985316, -122.444833238065) 9 7 4 28861 40
20270 41769 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1320-1360 Lombard St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2000 12:00:00 AM   3x3 Permit Number 42186 6006041 2120044 37.8015777435459 -122.423261128156 (37.8015777435459, -122.423261128156) 5 9 1 28858 32
20719 32859 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 499 Hoffman Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   10/30/1996 12:00:00 AM     Permit Number 37207 6000703.6978076 2101134.48618072 37.7493543400616 -122.440373654783 (37.7493543400616, -122.440373654783) 2 4 5 28862 22
20853 33056 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 328 San Jose Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37328 6006171.76331287 2101198.94449976 37.7498411527935 -122.421469507825 (37.7498411527935, -122.421469507825) 2 4 5 28859 19
22308 33551 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 242 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1996 12:00:00 AM     Permit Number 37659 6007042.9412775 2097614.40669633 37.7400478987016 -122.418202822848 (37.7400478987016, -122.418202822848) 2 7 7 28859 2
22588 44207 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 701 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2000 12:00:00 AM     Permit Number 43655 6009221.06713893 2115299.96241651 37.7887307349007 -122.411921176175 (37.7887307349007, -122.411921176175) 5 1 10 28852 21
24228 48907 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 2200X Clay St 7 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2002 12:00:00 AM     Permit Number 46105 6004224.6625681 2116191.17070072 37.7908961872794 -122.429271589059 (37.7908961872794, -122.429271589059) 13 9 1 29490 27
24465 48904 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 2200X Clay St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2002 12:00:00 AM     Permit Number 46105 6004224.6625681 2116191.17070072 37.7908961872794 -122.429271589059 (37.7908961872794, -122.429271589059) 13 9 1 29490 27
26389 87804 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1953 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50568 6004841 2117073 37.7933523405685 -122.427201927622 (37.7933523405685, -122.427201927622) 13 9 1 28858 27
26771 83492 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 2040 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2008 12:00:00 AM   3x3 Permit Number 50186 5981220.21812771 2101179.004699 37.7483479647664 -122.50775007916 (37.7483479647664, -122.50775007916) 1 8 3 29491 35
26882 37419 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 557 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39897 6002931.14322816 2099749.14332352 37.7456770883652 -122.432572163971 (37.7456770883652, -122.432572163971) 2 7 5 63 22
27508 68856 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 111 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1993 12:00:00 AM     Permit Number 32819 6000663.76465174 2094326.91833664 37.7306600888757 -122.440023675014 (37.7306600888757, -122.440023675014) 9 7 4 63 40
27524 37977 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1199 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1998 12:00:00 AM     Permit Number 40204 6015599.59779117 2103398.4652457 37.7564076382433 -122.389020897855 (37.7564076382433, -122.389020897855) 10 3 8 28856 29
28524 34910 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 234 Orizaba Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/23/1997 12:00:00 AM     Permit Number 38511 5994034.02525385 2087990.46611796 37.712882070912 -122.462484089909 (37.712882070912, -122.462484089909) 9 8 6 28861 24
30544 41593 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 538 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/2000 12:00:00 AM     Permit Number 43228 6003084.80949648 2098934.42438565 37.7434487728436 -122.431982642828 (37.7434487728436, -122.431982642828) 2 7 5 63 22
31613 33057 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 328 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37328 6006171.76331287 2101198.94449976 37.7498411527935 -122.421469507825 (37.7498411527935, -122.421469507825) 2 4 5 28859 19
31760 53143 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1498@ KEITH Underwood Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2006 12:00:00 AM     Permit Number 49074 6015150.01654287 2093336.52012549 37.7287546860169 -122.389872907792 (37.7287546860169, -122.389872907792) 10 3 8 58 1
33342 41874 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 66 Belcher St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42253 6003778.26782897 2107952.91484982 37.7682507021815 -122.430228105724 (37.7682507021815, -122.430228105724) 7 9 5 28862 3
34413 38029 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 2490X 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM     Permit Number 40235 5992179.14418088 2098457.94829189 37.7415161934278 -122.469656660064 (37.7415161934278, -122.469656660064) 1 8 4 29491 40
36649 43585 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 237 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/2000 12:00:00 AM     Permit Number 43246 6004367.379779 2099245.61051184 37.7443758465625 -122.427570002743 (37.7443758465625, -122.427570002743) 2 7 5 63 22
38756 41743 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1100 California St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42181 6009068.76416013 2116381.28511649 37.7916912386009 -122.412524591719 (37.7916912386009, -122.412524591719) 5 1 10 28857 21
40073 38845 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1333 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM     Permit Number 40675 5989863.06342131 2106288.82741716 37.7628835816678 -122.478237218826 (37.7628835816678, -122.478237218826) 1 8 3 56 35
40275 95802 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1512 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2011 12:00:00 AM   3x3 Permit Number 767546 6014097.5 2102025.1 37.7525532940671 -122.394119575027 (37.7525532940671, -122.394119575027) 10 3 8 28856 29
40902 38028 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 2490X 14th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1998 12:00:00 AM     Permit Number 40235 5992179.14418088 2098457.94829189 37.7415161934278 -122.469656660064 (37.7415161934278, -122.469656660064) 1 8 4 29491 40
42393 69511 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 457 Nevada St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/24/1994 12:00:00 AM     Permit Number 33638 6008927.18415449 2096207.51304953 37.736290754505 -122.411588483232 (37.736290754505, -122.411588483232) 10 7 7 28859 2
42698 41761 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1320-1360 Lombard St 11 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2000 12:00:00 AM   3x3 Permit Number 42186 6006041 2120044 37.8015777435459 -122.423261128156 (37.8015777435459, -122.423261128156) 5 9 1 28858 32
43766 38883 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 101 Commonwealth Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM     Permit Number 40703 5996508.72142362 2113802.71293841 37.7838982845648 -122.455795523067 (37.7838982845648, -122.455795523067) 11 6 1 54 31
44922 38217 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 350 Wayland St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40338 6010576.45287423 2092372.10995681 37.7258519216371 -122.405616192564 (37.7258519216371, -122.405616192564) 10 3 7 309 28
45902 67518 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 342 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/08/1994 12:00:00 AM     Permit Number 31054 5997814.69503285 2093832.35785798 37.7291395391527 -122.449837670115 (37.7291395391527, -122.449837670115) 9 7 4 28861 40
45998 112547 Undocumented 4 Rhamnus alaternus :: Italian Buckthorn 29 462 BROADWAY 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011324 2118723 37.798247331278 -122.404886391926 (37.798247331278, -122.404886391926) 3 1 10 308 23
46083 89314 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 101 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/27/2005 12:00:00 AM   3x3 Permit Number 48328 6002340 2108819 37.7705471897255 -122.435264883718 (37.7705471897255, -122.435264883718) 15 5 11 29492 9
46117 41663 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1376 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42129 5999046.52257313 2104716.21389633 37.7590943881005 -122.44636181287 (37.7590943881005, -122.44636181287) 15 5 5 28862 3
46975 82884 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 398 11th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52426 6008893.02169344 2108709.50255899 37.7706164898271 -122.412590100264 (37.7706164898271, -122.412590100264) 8 2 9 28853 19
48948 48905 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 2200X Clay St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2002 12:00:00 AM     Permit Number 46105 6004224.6625681 2116191.17070072 37.7908961872794 -122.429271589059 (37.7908961872794, -122.429271589059) 13 9 1 29490 27
49617 39731 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 3472 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41103 6003734.27078033 2106581.04610194 37.7644813903829 -122.430282399811 (37.7644813903829, -122.430282399811) 8 4 5 28862 3
49906 41694 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 444 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42146 6003561.9148943 2096429.88916823 37.7365989305362 -122.430154297904 (37.7365989305362, -122.430154297904) 2 7 5 63 7
50181 89199 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 3236 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/08/2008 12:00:00 AM   3x3 Permit Number 51816 5999889 2119639 37.8001166089052 -122.444520645891 (37.8001166089052, -122.444520645891) 13 9 1 57 17
50270 40783 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 410 Monticello St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/1999 12:00:00 AM     Permit Number 41739 5991762.23808711 2091284.45671221 37.7217954779898 -122.470575817994 (37.7217954779898, -122.470575817994) 9 8 4 59 40
51701 98673 Undocumented 4 Rhamnus alaternus :: Italian Buckthorn 29 1898@green Leavenworth St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007784.7 2118870.1 37.7984527607502 -122.417143889347 (37.7984527607502, -122.417143889347) 5 1 10 28858 21
52593 98672 Undocumented 4 Rhamnus alaternus :: Italian Buckthorn 29 1898@green Leavenworth St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007784.7 2118870.1 37.7984527607502 -122.417143889347 (37.7984527607502, -122.417143889347) 5 1 10 28858 21
55018 41767 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1320-1360 Lombard St 7 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2000 12:00:00 AM   3x3 Permit Number 42186 6006041 2120044 37.8015777435459 -122.423261128156 (37.8015777435459, -122.423261128156) 5 9 1 28858 32
55782 47698 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 297 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2002 12:00:00 AM     Permit Number 45496 6000129.38189454 2094930.1458918 37.7322859754961 -122.441914392194 (37.7322859754961, -122.441914392194) 9 7 4 63 40
58873 41744 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1100 California St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42181 6009068.76416013 2116381.28511649 37.7916912386009 -122.412524591719 (37.7916912386009, -122.412524591719) 5 1 10 28857 21
59685 41706 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 235 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42155 6001936.91803675 2096162.95952183 37.7357738321427 -122.435753508421 (37.7357738321427, -122.435753508421) 2 7 5 63 7
59688 87870 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 3236 Broderick St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2008 12:00:00 AM   3x3 Permit Number 50837 5999889 2119639 37.8001166089052 -122.444520645891 (37.8001166089052, -122.444520645891) 13 9 1 57 17
59848 112528 Undocumented 4 Rhamnus alaternus :: Italian Buckthorn 29 459 BROADWAY 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011361 2118561 37.797804586609 -122.404746949234 (37.797804586609, -122.404746949234) 3 1 10 308 23
61612 40785 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 410 Monticello St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/1999 12:00:00 AM     Permit Number 41739 5991762.23808711 2091284.45671221 37.7217954779898 -122.470575817994 (37.7217954779898, -122.470575817994) 9 8 4 59 40
63191 68973 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 3541 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1994 12:00:00 AM     Permit Number 32963 5999700.01023575 2120669.59399303 37.8029355580023 -122.445248759265 (37.8029355580023, -122.445248759265) 13 9 1 57 17
64020 47995 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 2594 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/28/2010 12:00:00 AM   3x3 Permit Number 53833 5991772.56459051 2097785.68925868 37.739646833729 -122.471013497633 (37.739646833729, -122.471013497633) 1 8 4 59 40
65254 40032 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1660 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM     Permit Number 41274 6014934.45622927 2095941.56583888 37.7358956578297 -122.390800100159 (37.7358956578297, -122.390800100159) 10 3 8 58 1
65640 38061 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1802 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM     Permit Number 40254 6001102.14351194 2114546.50782632 37.7862031012974 -122.439957367186 (37.7862031012974, -122.439957367186) 13 6 1 29490 27
66488 41690 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 150 Conrad St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42144 6001748.90360557 2096547.6107594 37.7368193138397 -122.436431068172 (37.7368193138397, -122.436431068172) 2 7 5 63 7
67971 41662 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1376 Clayton St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42129 5999046.52257313 2104716.21389633 37.7590943881005 -122.44636181287 (37.7590943881005, -122.44636181287) 15 5 5 28862 3
68406 38637 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1595 Shafter Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/2010 12:00:00 AM   3x3 Permit Number 767658 6014940.81298911 2094124.48881728 37.7309066855794 -122.390651184611 (37.7309066855794, -122.390651184611) 10 3 8 58 1
68647 41746 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1100 California St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42181 6009068.76416013 2116381.28511649 37.7916912386009 -122.412524591719 (37.7916912386009, -122.412524591719) 5 1 10 28857 21
68740 50562 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 2365 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/13/2003 12:00:00 AM     Permit Number 47184 5998950.78977652 2112707.00584702 37.7810296062885 -122.447268015984 (37.7810296062885, -122.447268015984) 15 5 1 54 16
69114 122462 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1351 42nd Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF         5983044.58583163 2105938.11904156 37.7615224717284 -122.501793626008 (37.7615224717284, -122.501793626008) 1 8 3 56 35
69919 88224 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1821 Hayes St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51220 5999142 2110084 37.7738384306008 -122.446417770519 (37.7738384306008, -122.446417770519) 15 5 11 29492 16
75515 57281 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 2469 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/1995 12:00:00 AM     Permit Number 14578 5992015.46997478 2098642.50003897 37.7420134642029 -122.470236020298 (37.7420134642029, -122.470236020298) 1 8 4 29491 40
75848 67457 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 709 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM   3x3 Permit Number 52276 6002046.91633096 2110893.18552424 37.7762257387634 -122.436427136673 (37.7762257387634, -122.436427136673) 15 5 11 29492 10
76211 41759 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1320-1360 Lombard St 10 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2000 12:00:00 AM   3x3 Permit Number 42186 6006041 2120044 37.8015777435459 -122.423261128156 (37.8015777435459, -122.423261128156) 5 9 1 28858 32
76457 40784 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 410 Monticello St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/1999 12:00:00 AM     Permit Number 41739 5991762.23808711 2091284.45671221 37.7217954779898 -122.470575817994 (37.7217954779898, -122.470575817994) 9 8 4 59 40
76531 41700 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 135 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42150 6002619.11270974 2096812.53264581 37.7375961375204 -122.433441302095 (37.7375961375204, -122.433441302095) 2 7 5 63 7
77782 49152 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 2464 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/23/2003 12:00:00 AM     Permit Number 46274 5991742.04430079 2098660.96480908 37.7420483520093 -122.471182775069 (37.7420483520093, -122.471182775069) 1 8 4 29491 40
79723 35102 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 778 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767512 6001912.66160072 2089308.81779253 37.7169525342318 -122.435347237927 (37.7169525342318, -122.435347237927) 9 7 6 28861 5
79828 37976 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1199 Tennessee St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1998 12:00:00 AM     Permit Number 40204 6015599.59779117 2103398.4652457 37.7564076382433 -122.389020897855 (37.7564076382433, -122.389020897855) 10 3 8 28856 29
80229 48906 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 2200X Clay St 6 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2002 12:00:00 AM     Permit Number 46105 6004224.6625681 2116191.17070072 37.7908961872794 -122.429271589059 (37.7908961872794, -122.429271589059) 13 9 1 29490 27
80398 82767 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 398 11th St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52426 6008893.02169344 2108709.50255899 37.7706164898271 -122.412590100264 (37.7706164898271, -122.412590100264) 8 2 9 28853 19
80581 48903 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 2200X Clay St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2002 12:00:00 AM     Permit Number 46105 6004224.6625681 2116191.17070072 37.7908961872794 -122.429271589059 (37.7908961872794, -122.429271589059) 13 9 1 29490 27
82091 33453 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 343 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/1996 12:00:00 AM     Permit Number 37554 6006165.48085512 2098035.43238588 37.7411545114342 -122.421266615711 (37.7411545114342, -122.421266615711) 2 7 7 28859 2
82279 47718 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 101 Roanoke St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2002 12:00:00 AM     Permit Number 45513 6003399.03676128 2096258.54340471 37.7361192276447 -122.430705213698 (37.7361192276447, -122.430705213698) 2 7 5 63 7
82837 58515 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1465 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/2004 12:00:00 AM     Permit Number 30484 5998691.7005411 2108280.83754266 37.7688616770507 -122.447845581015 (37.7688616770507, -122.447845581015) 15 5 11 29492 9
84430 88271 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 142 Belvedere St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51257 5998321.8 2107947.7 37.7679258166536 -122.449101033169 (37.7679258166536, -122.449101033169) 15 5 11 29492 9
85562 86997 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 248 Day St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/03/2007 12:00:00 AM   3x3 Permit Number 49939 6004323 2098701 37.7428779608266 -122.42768466378 (37.7428779608266, -122.42768466378) 2 7 5 63 22
87519 112589 Undocumented 4 Rhamnus alaternus :: Italian Buckthorn 29 776 TEHAMA ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009004 2110266 37.7748964951756 -122.41231625471 (37.7748964951756, -122.41231625471) 8 2 9 28853 34
88664 38062 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1802 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM     Permit Number 40254 6001102.14351194 2114546.50782632 37.7862031012974 -122.439957367186 (37.7862031012974, -122.439957367186) 13 6 1 29490 27
89232 40031 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1656 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM     Permit Number 41273 6014957.20136248 2095924.63791994 37.7358504391775 -122.390720277971 (37.7358504391775, -122.390720277971) 10 3 8 58 1
92149 87934 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 3600 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50956 5982309 2100840 37.7474812377595 -122.503960055968 (37.7474812377595, -122.503960055968) 1 8 3 29491 35
95168 69021 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 2095 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1994 12:00:00 AM     Permit Number 33025 5981665.37116425 2100840.03174895 37.7474434561007 -122.506185646516 (37.7474434561007, -122.506185646516) 1 8 3 29491 35
95401 112529 Undocumented 4 Rhamnus alaternus :: Italian Buckthorn 29 459 BROADWAY 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011361 2118561 37.797804586609 -122.404746949234 (37.797804586609, -122.404746949234) 3 1 10 308 23
98564 38030 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1400 Ulloa St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1998 12:00:00 AM     Permit Number 40236 5991713.73808693 2098444.67646581 37.7414528421268 -122.471264893104 (37.7414528421268, -122.471264893104) 1 8 4 29491 40
98750 38059 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1802 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM     Permit Number 40254 6001102.14351194 2114546.50782632 37.7862031012974 -122.439957367186 (37.7862031012974, -122.439957367186) 13 6 1 29490 27
99470 38034 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 71 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM     Permit Number 40237 5993126.63617522 2098605.576855 37.7419762612493 -122.466391311334 (37.7419762612493, -122.466391311334) 1 8 4 59 40
100225 41749 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1100 California St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42181 6009068.76416013 2116381.28511649 37.7916912386009 -122.412524591719 (37.7916912386009, -122.412524591719) 5 1 10 28857 21
100414 87936 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 3600 Quintara St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50956 5982309 2100840 37.7474812377595 -122.503960055968 (37.7474812377595, -122.503960055968) 1 8 3 29491 35
103428 41764 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1320-1360 Lombard St 12 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2000 12:00:00 AM   3x3 Permit Number 42186 6006041 2120044 37.8015777435459 -122.423261128156 (37.8015777435459, -122.423261128156) 5 9 1 28858 32
103637 41763 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1320-1360 Lombard St 8 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2000 12:00:00 AM   3x3 Permit Number 42186 6006041 2120044 37.8015777435459 -122.423261128156 (37.8015777435459, -122.423261128156) 5 9 1 28858 32
103820 37979 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 1199 Tennessee St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1998 12:00:00 AM     Permit Number 40204 6015599.59779117 2103398.4652457 37.7564076382433 -122.389020897855 (37.7564076382433, -122.389020897855) 10 3 8 28856 29
104544 112525 Undocumented 4 Rhamnus alaternus :: Italian Buckthorn 29 471 BROADWAY 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011292 2118586 37.7978693737352 -122.404987470864 (37.7978693737352, -122.404987470864) 3 1 10 308 23

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