3,247 rows where qSpecies_id = 22 sorted by Supervisor Districts

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)
796 36869 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22   4 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
8250 19840 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 STAIRWAY25 24 Sidewalk: Curb side : Cutout Tree DPW 1     6 60X                      
11197 19797 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 STAIRWAY21 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
12826 19801 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 STAIRWAY21 6 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
14048 19740 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 STAIRWAY15 -50 Sidewalk: Curb side : Cutout Tree DPW 1     3 1OST                      
14814 50011 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 99@ 20TH ST Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2003 12:00:00 AM     Permit Number 46742                    
15898 36871 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22   1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
16336 36872 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22   2 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
16572 19741 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 STAIRWAY15 -14 Sidewalk: Curb side : Cutout Tree DPW 1     3 1OST                      
17433 36873 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22   3 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
4259 33111 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 2626 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2020 12:00:00 AM 3 4x4 Permit Number 769981 6000363.34088 2118561.77591 37.7971858916671 -122.442801853125 (37.7971858916671, -122.442801853125) 13 9 1 57 17
4360 71812 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 340 Spruce St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5997177.69428 2115152.46792 37.787642723191 -122.453578628865 (37.787642723191, -122.453578628865) 11 6 1 54 31
4635 51506 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3641 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2005 12:00:00 AM 4   Permit Number 47816 5997376.74864 2115377.3985 37.7882717315077 -122.452906185094 (37.7882717315077, -122.452906185094) 11 6 1 54 31
5444 35590 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2808 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6   Permit Number 38953 6000039.2737 2114426.5269 37.7858131029776 -122.443625984057 (37.7858131029776, -122.443625984057) 15 6 1 29490 31
6058 138706 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1701 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6001044.197 2114457.2843 37.7859548176593 -122.440151445956 (37.7859548176593, -122.440151445956) 15 6 1 29490 27
6849 45748 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Locust St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2001 12:00:00 AM 3   Permit Number 44395 5997461.24318 2116299.42267 37.7908082054694 -122.452680420191 (37.7908082054694, -122.452680420191) 11 6 1 54 31
7043 112197 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2570 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/16/2015 12:00:00 AM 3 3x3   6001886.22681 2116705.46829 37.7921756543416 -122.437399303646 (37.7921756543416, -122.437399303646) 13 6 1 29490 27
8005 128927 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2101 Washington St 11 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6004695.29857 2116719.42491 37.7923732722634 -122.427680861803 (37.7923732722634, -122.427680861803) 13 9 1 28858 27
10470 128936 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2618 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6003606.06388 2117505.00365 37.7944685972958 -122.431505746802 (37.7944685972958, -122.431505746802) 13 9 1 29490 27
10664 260923 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 47 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2019 12:00:00 AM 3     5990807.95481 2114868.4417 37.7864956605801 -122.475595709543 (37.7864956605801, -122.475595709543) 11 6 1 54 33
11854 72418 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3878 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5996349.46796 2114952.54152 37.7870462658131 -122.456429650633 (37.7870462658131, -122.456429650633) 11 6 1 54 31
15361 36968 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 118 06th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/29/1998 12:00:00 AM 5   Permit Number 39595 5993987.97624 2114726.89582 37.786290850626 -122.464583430573 (37.786290850626, -122.464583430573) 11 6 1 54 11
15719 7346 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2225 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/1980 12:00:00 AM 1 3X3   6002798.59801 2115979.15257 37.7902332041481 -122.43419054146 (37.7902332041481, -122.43419054146) 13 9 1 29490 27
16074 128922 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2101 Washington St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004454.93777 2116689.88617 37.7922785673477 -122.428510409935 (37.7922785673477, -122.428510409935) 13 9 1 28858 27
16453 260924 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 47 16th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2019 12:00:00 AM 3     5990807.95481 2114868.4417 37.7864956605801 -122.475595709543 (37.7864956605801, -122.475595709543) 11 6 1 54 33
18490 34599 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3200 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 4   Permit Number 38292 5999320.20166 2116021.69073 37.7901519674937 -122.446228549814 (37.7901519674937, -122.446228549814) 13 6 1 29490 31
19320 33230 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2740 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2   Permit Number 37416 6000651.12195 2117750.428 37.7949745459919 -122.441747802734 (37.7949745459919, -122.441747802734) 13 9 1 57 27
20435 128934 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1911 Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6004762.88198 2115822.85089 37.7899153288661 -122.427383123225 (37.7899153288661, -122.427383123225) 13 9 1 28858 27
20649 87351 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 3374 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2008 12:00:00 AM     Permit Number 50337 5998108 2116175 37.7905036111085 -122.450433709576 (37.7905036111085, -122.450433709576) 13 6 1 54 31
20722 140879 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 137 COMMONWEALTH AVE 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 0ft   5996520.7008 2113467.9498 37.7829798014331 -122.455729872689 (37.7829798014331, -122.455729872689) 11 6 1 54 31
21892 50870 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2626 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     4   Permit Number 47381 6001002.60746 2117608.08082 37.7946037186291 -122.440521399949 (37.7946037186291, -122.440521399949) 13 9 1 57 27
24674 12708 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1448 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/1992 12:00:00 AM 8 3X3   5990942.238 2114788.08158 37.7862827977651 -122.475125259251 (37.7862827977651, -122.475125259251) 11 6 1 54 33
25476 59994 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 331 Spruce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/13/1982 12:00:00 AM 7   Permit Number 19478 5997127.59055 2115197.55495 37.7877636478193 -122.453755234125 (37.7877636478193, -122.453755234125) 11 6 1 54 31
25519 99895 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2101X Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3 Permit Number 768908 6004333.92311 2116670.59896 37.7922187606381 -122.428927747522 (37.7922187606381, -122.428927747522) 13 9 1 28858 27
29223 65857 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3444 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/08/1990 12:00:00 AM 2 3x3 Permit Number 49753 6000794.66575 2120227.32857 37.8017836378592 -122.441428940891 (37.8017836378592, -122.441428940891) 13 9 1 57 17
30679 123539 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 23 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5994224.17886 2115446.71935 37.7882809036356 -122.463818503438 (37.7882809036356, -122.463818503438) 11 6 1 54 11
30811 128921 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2120 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6004519.58933 2116743.38015 37.7924291066587 -122.428290528411 (37.7924291066587, -122.428290528411) 13 9 1 28858 27
31468 33116 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2699 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 4   Permit Number 37353 6000083.68486 2118474.07473 37.7969291406212 -122.443763225693 (37.7969291406212, -122.443763225693) 13 9 1 57 17
31830 58810 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3199 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3   Permit Number 772746 6002363.40081 2119107.04088 37.7987968652491 -122.435920192279 (37.7987968652491, -122.435920192279) 13 9 1 57 17
32020 59995 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 311 Spruce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/13/1982 12:00:00 AM 5   Permit Number 19480 5997122.00089 2115229.93413 37.7878522319536 -122.453776912276 (37.7878522319536, -122.453776912276) 11 6 1 54 31
32521 128901 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 311 Spruce St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5997122.0047 2115215.47668 37.78781253587 -122.453775854678 (37.78781253587, -122.453775854678) 11 6 1 54 31
33532 44053 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 3100 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM     Permit Number 43582 6001974.87365527 2118765.4026711 37.7978367374605 -122.437240145023 (37.7978367374605, -122.437240145023) 13 9 1 57 17
33686 138733 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2408 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6001048.5577 2114211.4579 37.7852800898662 -122.44011872507 (37.7852800898662, -122.44011872507) 15 6 1 29490 27
35043 128904 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 341 Spruce St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5997139.00909 2115122.29053 37.7875576464082 -122.453710291392 (37.7875576464082, -122.453710291392) 11 6 1 54 31
35123 52586 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 179@ GEARY Jordan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2006 12:00:00 AM 4   Permit Number 48679 5996210.09335 2113138.79265 37.7820581932657 -122.456780626288 (37.7820581932657, -122.456780626288) 11 6 1 54 31
35491 34605 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3201 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1997 12:00:00 AM 5   Permit Number 38293 5999288.97599 2115969.52307 37.7900069454997 -122.446332833392 (37.7900069454997, -122.446332833392) 13 6 1 29490 31
35761 128888 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1549 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6003944.76829 2120400.71212 37.8024386572819 -122.430540507163 (37.8024386572819, -122.430540507163) 13 9 1 57 17
36448 97661 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1909 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2011 12:00:00 AM 3 5x6 Permit Number 768299 5999925.2115 2115581.43122 37.7889776633441 -122.444103621799 (37.7889776633441, -122.444103621799) 13 6 1 29490 27
37140 41087 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2307 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2005 12:00:00 AM 2   Permit Number 48267 6001281.43208 2116413.73631 37.7913402327106 -122.439470976529 (37.7913402327106, -122.439470976529) 13 6 1 29490 27
38072 128919 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2600 Divisadero St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6000714.71077 2117296.03713 37.793730530888 -122.441495154374 (37.793730530888, -122.441495154374) 13 9 1 57 27
39389 128894 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3617 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   5997563.55975 2115405.0464 37.7883583488179 -122.452261848699 (37.7883583488179, -122.452261848699) 11 6 1 54 31
39427 14413 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10X Masonic Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/12/2000 12:00:00 AM 18 3X3   5998974.44495 2113166.80204 37.7822934388942 -122.447219282802 (37.7822934388942, -122.447219282802) 15 5 1 54 16
40335 129007 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2550 Leavenworth St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007463.35439 2121202.39829 37.8048385808931 -122.418421308908 (37.8048385808931, -122.418421308908) 5 1 1 308 32
40349 128929 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2101 Washington St 14 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004845.70245 2116743.27362 37.7924472612924 -122.42716215983 (37.7924472612924, -122.42716215983) 13 9 1 28858 27
41686 128909 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1620 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6004047.371 2120116.17018 37.8016631907718 -122.430165140031 (37.8016631907718, -122.430165140031) 13 9 1 57 17
42871 108698 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2922 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774622 5999117.98057 2118844.23155 37.7978903639015 -122.447131431372 (37.7978903639015, -122.447131431372) 13 9 1 57 17
43066 57165 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 2616 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42848 6003634.5143762 2117314.3321902 37.7939466747915 -122.431393686963 (37.7939466747915, -122.431393686963) 13 9 1 29490 27
45775 107780 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3155 Scott St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2014 12:00:00 AM 3 3x3 Permit Number 770908 6000893.56163 2119195.20013 37.7989553203824 -122.441012627647 (37.7989553203824, -122.441012627647) 13 9 1 57 17
46277 128886 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2201 Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6002294.64841 2119130.10879 37.7988562978392 -122.436159749193 (37.7988562978392, -122.436159749193) 13 9 1 57 17
47248 128931 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2101 Washington St 18 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6004999.26308 2116762.74652 37.7925094116358 -122.42663222262 (37.7925094116358, -122.42663222262) 13 9 1 28858 27
47519 128908 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2699 Filbert St 8 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6000146.67214 2118481.01335 37.7969517846466 -122.443545774121 (37.7969517846466, -122.443545774121) 13 9 1 57 17
48085 128881 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2785 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5999690.87391 2118073.65713 37.7958072876205 -122.44509363868 (37.7958072876205, -122.44509363868) 13 9 1 57 17
48343 88030 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2301 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   5999281.2928 2116744.16757 37.7921334761404 -122.446415168128 (37.7921334761404, -122.446415168128) 11 6 1 29490 30
49013 31990 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 166 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/30/1995 12:00:00 AM 6   Permit Number 35391 5994616.66617 2114522.79819 37.7857666765954 -122.462393532855 (37.7857666765954, -122.462393532855) 11 6 1 54 11
49478 50869 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2626 Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2     4   Permit Number 47381 6000989.97476 2117606.30096 37.7945981122598 -122.440564982893 (37.7945981122598, -122.440564982893) 13 9 1 57 27
50985 33117 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2699 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 4   Permit Number 37353 6000101.0018 2118475.17057 37.7969331372011 -122.443703383925 (37.7969331372011, -122.443703383925) 13 9 1 57 17
53804 36958 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 22 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM     Permit Number 39588 5994276.09301697 2115432.47686212 37.788244789102 -122.46363785633 (37.788244789102, -122.46363785633) 11 6 1 54 11
54769 34225 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 138 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM 4 3x3 Permit Number 52249 5988056.05348 2115056.1881 37.7868512432119 -122.485130265467 (37.7868512432119, -122.485130265467) 11 6 1 55 33
54930 34604 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3200 Washington St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 2   Permit Number 38292 5999291.05254 2116018.28343 37.7901409472086 -122.446329157891 (37.7901409472086, -122.446329157891) 13 6 1 29490 31
55199 26817 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1701 Divisadero St 6 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6001074.1672 2114240.365 37.7853609192564 -122.440032197736 (37.7853609192564, -122.440032197736) 15 6 1 29490 27
55268 120447 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 55 22nd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   5988944.82314 2114949.71234 37.7866106225502 -122.482047561852 (37.7866106225502, -122.482047561852) 11 6 1 55 33
55509 141032 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2 Masonic Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5998900.6522 2112841.8694 37.7813970416057 -122.447451176278 (37.7813970416057, -122.447451176278) 15 5 1 54 16
56853 107781 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3155 Scott St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2014 12:00:00 AM 3 3x3 Permit Number 770908 6000894.3565 2119181.32338 37.7989172637699 -122.441008881075 (37.7989172637699, -122.441008881075) 13 9 1 57 17
59768 14414 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10X Masonic Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/12/2000 12:00:00 AM 6 3X3   5998974.44495 2113166.80204 37.7822934388942 -122.447219282802 (37.7822934388942, -122.447219282802) 15 5 1 54 16
63291 140878 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 137 COMMONWEALTH AVE 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 0ft   5996520.3624 2113480.4714 37.7830141630021 -122.455731948822 (37.7830141630021, -122.455731948822) 11 6 1 54 31
63597 129005 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2620 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6006623.13144 2120229.16523 37.8021189959583 -122.421259841781 (37.8021189959583, -122.421259841781) 5 9 1 28858 32
63617 48898 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2220 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/2002 12:00:00 AM 3   Permit Number 46101 6003904.89835 2116333.07844 37.7912677221834 -122.430388088265 (37.7912677221834, -122.430388088265) 13 9 1 29490 27
65318 107065 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1912 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   5999488.74187 2115560.69721 37.7888958241408 -122.445612251613 (37.7888958241408, -122.445612251613) 13 6 1 29490 27
65709 34614 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3248 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 5   Permit Number 38298 5999168.63526 2116001.62115 37.7900882046605 -122.446751510992 (37.7900882046605, -122.446751510992) 13 6 1 29490 31
66399 26813 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1701 Divisadero St 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6001062.3024 2114325.3961 37.7855937173461 -122.440079345712 (37.7855937173461, -122.440079345712) 15 6 1 29490 27
68370 249647 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2460 Lyon St 7 Front Yard : Yard Tree Private 2     18 Width 10ft   5999284.57219 2117293.77828 37.7936427489551 -122.446443378971 (37.7936427489551, -122.446443378971) 13 9 1 57 27
68946 51625 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3100ON LYON ST Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2010 12:00:00 AM 3   Permit Number 53623 5999235.34275 2116663.42168 37.7919091447295 -122.446568343381 (37.7919091447295, -122.446568343381) 11 6 1 29490 30
70289 128885 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2201 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6002262.59094 2119125.25384 37.7988411460494 -122.436270330726 (37.7988411460494, -122.436270330726) 13 9 1 57 17
70540 50452 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2821 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/21/2003 12:00:00 AM 3   Permit Number 47098 6002052.06788 2117856.8779 37.7953465532623 -122.436907957234 (37.7953465532623, -122.436907957234) 13 9 1 57 27
70855 128906 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 586 Spruce St 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 6ft   5997146.09273 2113991.53957 37.7844533108166 -122.453604104844 (37.7844533108166, -122.453604104844) 15 6 1 54 31
70996 5315 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1820 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/22/1990 12:00:00 AM 3 3X3   6001085.4403 2114655.5077 37.7865014360219 -122.440022974412 (37.7865014360219, -122.440022974412) 13 6 1 29490 27
72179 128882 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2728 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5999935.66766 2118151.33165 37.7960345301288 -122.444252194282 (37.7960345301288, -122.444252194282) 13 9 1 57 17
72311 34610 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3230 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 3   Permit Number 38295 5999238.22234 2116011.35484 37.7901189057187 -122.446511446843 (37.7901189057187, -122.446511446843) 13 6 1 29490 31
72912 128935 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1911 Octavia St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6004767.77033 2115797.41949 37.7898457771089 -122.427364397564 (37.7898457771089, -122.427364397564) 13 9 1 28858 27
72946 99896 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2101X Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 768908 6004371.30251 2116674.47154 37.7922315094359 -122.428798690309 (37.7922315094359, -122.428798690309) 13 9 1 28858 27
73233 128889 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Locust St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5997463.35178 2116288.09249 37.790777216646 -122.452672306504 (37.790777216646, -122.452672306504) 11 6 1 54 31
75656 59992 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 352 Spruce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/13/1982 12:00:00 AM     Permit Number 19476 5997176.2665221 2115199.54422144 37.7877719003215 -122.453586969087 (37.7877719003215, -122.453586969087) 11 6 1 54 31
75900 128910 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 3456 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5997719.95942 2116126.73838 37.7903488812329 -122.451772816269 (37.7903488812329, -122.451772816269) 11 6 1 54 31
76345 120471 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 88 West Clay St 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   5988434.04491 2115070.90864 37.7869136727274 -122.483823598526 (37.7869136727274, -122.483823598526) 11 6 1 55 33
76420 33316 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1443-1443X Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/2019 12:00:00 AM 3   Permit Number 782769 6004409.7027 2120463.36257 37.8026370063559 -122.42893607346 (37.8026370063559, -122.42893607346) 13 9 1 57 17
76714 36969 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 118 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM 6   Permit Number 39595 5993988.21969 2114706.01546 37.7862335328828 -122.464581071586 (37.7862335328828, -122.464581071586) 11 6 1 54 11
77000 120445 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 65 22nd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   5988945.83143 2114929.73493 37.7865558288888 -122.482042609422 (37.7865558288888, -122.482042609422) 11 6 1 55 33
77218 14417 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10X Masonic Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1   12/24/2003 12:00:00 AM 6 3X3   5998974.44495 2113166.80204 37.7822934388942 -122.447219282802 (37.7822934388942, -122.447219282802) 15 5 1 54 16
77760 50610 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 307 Spruce St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2003 12:00:00 AM 5   Permit Number 47207 5997118.78265 2115251.45908 37.7879111492194 -122.453789601717 (37.7879111492194, -122.453789601717) 11 6 1 54 31
78064 128918 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2600 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6000716.24909 2117279.44641 37.7936850647588 -122.441488640582 (37.7936850647588, -122.441488640582) 13 9 1 57 27

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