trees

Custom SQL query returning 101 rows (hide)

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1 264847 1 1 109 Felton St 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6010522 2093730 37.729577358437 -122.405900044893 (37.729577358437, -122.405900044893) 10 3 7 309 28
2 262167 1 2 420 Alpha St 2 Sidewalk: Curb side : Cutout Tree 1 FUF 11/16/2020 12:00:00 AM 3                        
4 264831 1 1 230 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3 4x6   6011678 2088870 37.7162973770842 -122.401562170369 (37.7162973770842, -122.401562170369) 10 7 8 309 39
5 264836 1 4 325 Olmstead St 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3 4x6   6010737 2090909 37.7218435009065 -122.404958220137 (37.7218435009065, -122.404958220137) 10 3 7 309 28
6 262166 1 2 420 Alpha St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 11/16/2020 12:00:00 AM 3                        
8 264824 1 6 1x Harkness Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6012032 2089425 37.7178410421308 -122.400377527521 (37.7178410421308, -122.400377527521) 10 7 8 309 39
10 264794 4 8 31 Dwight St 1 Sidewalk: Curb side : Cutout Tree 2   11/01/2020 12:00:00 AM 3 3x3   6011433 2091603 37.7237879639177 -122.40260109208 (37.7237879639177, -122.40260109208) 10 3 7 309 28
11 264841 1 2 1601 Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6007819 2087884 37.7133739406818 -122.41483104388 (37.7133739406818, -122.41483104388) 9 7 8 309 39
12 264792 4 9 99 Dwight St 1 Sidewalk: Curb side : Cutout Tree 2   11/16/2020 12:00:00 AM 3 3x3   6011432 2091645 37.7239032314516 -122.402607501044 (37.7239032314516, -122.402607501044) 10 3 7 309 28
13 264822 1 10 2 Harkness Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3 4x6                      
14 162252 1 11 789 Girard St 1 Sidewalk: Curb side : Cutout Tree 2   11/01/2020 12:00:00 AM 3 Width 0ft   6011428.3902 2091205.22693 37.7226955033817 -122.402589068938 (37.7226955033817, -122.402589068938) 10 3 7 309 28
15 264849 1 12 15 Hale St 2 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6010381 2094903 37.7327902820185 -122.40647012075 (37.7327902820185, -122.40647012075) 10 3 7 309 28
16 264823 1 10 2 Harkness Ave 2 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3 4x6                      
19 262168 1 2 420 Alpha St 3 Sidewalk: Curb side : Cutout Tree 1 FUF 11/16/2020 12:00:00 AM 3                        
20 264793 4 9 99 Dwight St 2 Sidewalk: Curb side : Cutout Tree 2   11/16/2020 12:00:00 AM 3 3x3   6011432 2091645 37.7239032314516 -122.402607501044 (37.7239032314516, -122.402607501044) 10 3 7 309 28
21 264839 1 2 1601 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6007819 2087884 37.7133739406818 -122.41483104388 (37.7133739406818, -122.41483104388) 9 7 8 309 39
22 262394 6 15 66 Cleary Ct 1 Sidewalk: Property side : Cutout Tree 1   11/13/2020 12:00:00 AM 3 3x3   6004824 2113713 37.7841256623529 -122.427021325889 (37.7841256623529, -122.427021325889) 13 9 11 28858 41
24 264941 1 16 100X Portola Dr 12 Median : Cutout Tree 2       3x3   5999749 2101261 37.7496473113918 -122.443684097942 (37.7496473113918, -122.443684097942) 2 5 5 28862 38
26 259857 1 1 1255 Brussels St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 11/01/2020 12:00:00 AM 3     6011768.59367 2089078.72926 37.7168755602396 -122.401263692233 (37.7168755602396, -122.401263692233) 10 7 8 309 39
28 264848 1 12 15 Hale St 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6010381 2094903 37.7327902820185 -122.40647012075 (37.7327902820185, -122.40647012075) 10 3 7 309 28
29 264952 6 17 20X Cleary Ct 2 Front Yard : Yard Tree 2   11/13/2020 12:00:00 AM 3     6004818 2113712 37.7841225773231 -122.427042012496 (37.7841225773231, -122.427042012496) 13 9 11 28858 41
31 264951 6 17 20X Cleary Ct 1 Front Yard : Yard Tree 2   11/13/2020 12:00:00 AM 3     6004818 2113712 37.7841225773231 -122.427042012496 (37.7841225773231, -122.427042012496) 13 9 11 28858 41
32 264850 1 8 172 University St 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6007951 2093149 37.7278379340298 -122.414747181337 (37.7278379340298, -122.414747181337) 9 3 7 309 5
34 262408 8 15 66X Edgehill Way 1 Unaccepted Street : Yard Tree 2       3x3   5994840 2098758 37.7424934921887 -122.46047813267 (37.7424934921887, -122.46047813267) 1 8 4 59 40
35 16620 1 20 125 Noe St 1 Sidewalk: Curb side : Cutout Tree 2   07/09/1999 12:00:00 AM 6 3X3   6002913 2107540 37.7670678918229 -122.433191472284 (37.7670678918229, -122.433191472284) 15 5 5 28862 3
37 264963 5 13 275 Oak St 1 Sidewalk: Curb side : Cutout Tree 2   11/19/2020 12:00:00 AM 3 3x3   6005706 2110306 37.7748207071365 -122.423727591769 (37.7748207071365, -122.423727591769) 7 9 11 28852 10
40 6039 1 24 1822 Eddy St 4 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6001574.3819 2112547.6661 37.7807416628926 -122.438180307395 (37.7807416628926, -122.438180307395) 15 5 11 29490 41
41 159866 1 1 20 Ruth St 3 Sidewalk: Curb side : Cutout Tree 2   11/19/2020 12:00:00 AM 3 4x6   6001590.27181 2091627.71254 37.7233013847479 -122.436627471279 (37.7233013847479, -122.436627471279) 9 7 6 28861 25
42 221891 1 25 180 Bartlett St 3 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6006685.21207 2102724.39469 37.7540586268078 -122.419802203518 (37.7540586268078, -122.419802203518) 2 4 7 28859 19
43 264724 1 26 2901 Broadway 1 Front Yard : Yard Tree 2       3x3   5999656 2116990 37.7928298614365 -122.445136362104 (37.7928298614365, -122.445136362104) 13 6 1 29490 27
44 159867 1 1 20 Ruth St 4 Sidewalk: Curb side : Cutout Tree 2   11/19/2020 12:00:00 AM 3 4x6   6001543.73914 2091652.70256 37.7233673572035 -122.436790113668 (37.7233673572035, -122.436790113668) 9 7 6 28861 25
45 134298 1 27 1948 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/23/2020 12:00:00 AM 3 Width 4ft   6004784.56446 2117433.72769 37.7943396156388 -122.427422908337 (37.7943396156388, -122.427422908337) 13 9 1 28858 27
46 6035 1 24 1826 Eddy St 1 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6001552.687 2112546.4084 37.7807369756783 -122.438255270265 (37.7807369756783, -122.438255270265) 15 5 11 29490 41
47 264965 4 10 951 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5994993 2090257 37.7191606150529 -122.45933361899 (37.7191606150529, -122.45933361899) 9 8 6 28861 24
48 159865 1 1 20 Ruth St 2 Sidewalk: Curb side : Cutout Tree 2   11/19/2020 12:00:00 AM 3 4x6   6001621.37029 2091612.17517 37.7232604898693 -122.436518858358 (37.7232604898693, -122.436518858358) 9 7 6 28861 25
49 261834 1 1 20x Ruth St 1 Sidewalk: Curb side : Cutout Tree 1   11/19/2020 12:00:00 AM 3 4x6   6001536 2091749 37.7236313283612 -122.436823756643 (37.7236313283612, -122.436823756643) 9 7 6 28861 25
50 264964 6 28 3641 California St 1 Sidewalk: Curb side : Cutout Tree 2       3X3   5996989 2114619 37.7861671437011 -122.454192924446 (37.7861671437011, -122.454192924446) 11 6 1 54 31
51 137691 1 29 2175 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout Tree 2   11/23/2020 12:00:00 AM 3 Width 0ft   5999187.5809 2111472.1809 37.7776526229954 -122.44635998308 (37.7776526229954, -122.44635998308) 15 5 11 54 16
52 264970 4 1 1026 Ingerson Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6014048 2089990 37.7195046364539 -122.393448574201 (37.7195046364539, -122.393448574201) 10 3 8 58 1
53 264969 4 30 1099X Hollister Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF     15x15   6014337 2089983 37.719501468928 -122.392449109694 (37.719501468928, -122.392449109694) 10 3 8 58 1
54 216739 1 11 11 Brighton Ave 1 Sidewalk: Curb side : Yard Tree 2   11/23/2020 12:00:00 AM 3 Width 3ft   5996185.57101 2089978.26988 37.7184637821573 -122.4551912491 (37.7184637821573, -122.4551912491) 9 8 6 28861 24
55 1166 1 31 2900 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree 1   11/23/2020 12:00:00 AM 25 3X3   5997012.91474 2087625.16187 37.7120501257788 -122.45216178836 (37.7120501257788, -122.45216178836) 9 7 6 28861 25
58 195132 1 27 825 Minnesota St 1 Sidewalk: Curb side : Cutout Tree 2   11/25/2020 12:00:00 AM 3 Width 3ft   6015253.79115 2104691.52976 37.7599389420381 -122.390307168065 (37.7599389420381, -122.390307168065) 10 3 8 28856 29
59 195131 1 27 851 Minnesota St 7 Sidewalk: Curb side : Cutout Tree 2   11/25/2020 12:00:00 AM 3 Width 3ft   6015252.45033 2104672.28083 37.7598860142382 -122.390310460464 (37.7598860142382, -122.390310460464) 10 3 8 28856 29
60 264971 9 31 150 17th Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/25/2020 12:00:00 AM 3     5990555.23468 2114396.47455 37.7851851170506 -122.476435559205 (37.7851851170506, -122.476435559205) 11 6 2 54 26
62 264980 6 22 222 Winfield St 1 Front Yard : Yard Tree 2       3x3   6006740 2098205 37.7416524795013 -122.419292156581 (37.7416524795013, -122.419292156581) 2 7 7 28859 2
63 264975 6 15 445 Ortega St 1 Front Yard : Yard Tree 2       10x30   5992686 2102646 37.7530447932571 -122.468208733714 (37.7530447932571, -122.468208733714) 1 8 4 56 12
64 264974 6 34 1868 Greenwich St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6003954 2119422 37.7997518904289 -122.430438688757 (37.7997518904289, -122.430438688757) 13 9 1 57 17
65 264979 4 35 2450 California St 1 Front Yard : Yard Tree 3           6002592 2115500 37.7889058459562 -122.434871073784 (37.7889058459562, -122.434871073784) 13 9 1 29490 27
66 132469 1 36 3135 Pierce St 4 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6001403 2119193 37.7989782820217 -122.43924964791 (37.7989782820217, -122.43924964791) 13 9 1 57 17
68 264976 6 15 445 Ortega St 2 Front Yard : Yard Tree 2       10x30   5992686 2102646 37.7530447932571 -122.468208733714 (37.7530447932571, -122.468208733714) 1 8 4 56 12
69 126274 6 28 1240 Lombard St 1 Sidewalk: Property side : Yard Tree 2     24 Width 6ft   6006421.51674 2120105.21307 37.8017672864012 -122.421948716173 (37.8017672864012, -122.421948716173) 5 9 1 28858 32
71 227799 1 37 1265 Stanyan St 2 Sidewalk: Curb side : Cutout Tree 2   12/01/2020 12:00:00 AM 17 6x6   5997473.24622 2105221.8097 37.760392645519 -122.451839397566 (37.760392645519, -122.451839397566) 15 5 11 29492 12
72 135801 1 7 16 Phoenix Ter 2 Sidewalk: Property side : Yard Tree 2     4 Width 2ft   6008610.92916 2117913.61927 37.7958729471262 -122.414217164494 (37.7958729471262, -122.414217164494) 5 1 10 308 21
73 127010 1 38 1931 Union St 2 Sidewalk: Curb side : Cutout Tree 2     12 Width 3ft   6003752.87677 2118634.51429 37.7975782631807 -122.431078412364 (37.7975782631807, -122.431078412364) 13 9 1 57 17
77 225344 1 38 207 Randall St 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 3ft   6004214.46195 2097518.65353 37.7396253677099 -122.42797572342 (37.7396253677099, -122.42797572342) 2 7 5 63 7
78 237365 1 40 2463 Folsom St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 4ft   6008244.71386 2104091.00553 37.7578987598438 -122.414505749733 (37.7578987598438, -122.414505749733) 2 4 7 28859 19
79 121399 1 28 349X Cargo Way 1 Sidewalk: Curb side : Cutout Tree 1                              
80 260998 1 41 600X Lake Merced Blvd 1 Sidewalk: Property side : Yard Tree 4       10x10                      
82 251210 1 42 1170 Ingalls St 2 Sidewalk: Curb side : Cutout Tree 1   11/02/1992 12:00:00 AM                          
83 259099 1 11 600 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
84 254457 6 43 1055X Duncan St 2 Side Yard : Yard Tree 2                              
85 259368 1 3 1646 Revere Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF                            
86 239818 1 44 219 Moultrie St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6007803 2098062 37.7413196437149 -122.415606526646 (37.7413196437149, -122.415606526646) 2 7 7 28859 2
87 259654 1 45 101x Cora St   Sidewalk: Curb side : Cutout Tree 1 FUF 06/01/2019 12:00:00 AM 3                        
88 259653 1 45 99x Cora St 2 Sidewalk: Curb side : Cutout Tree 1 FUF 06/01/2019 12:00:00 AM 3                        
89 259623 1 45 1498x Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree 1 FUF 06/01/2019 12:00:00 AM 3                        
90 259864 1 1 1398x Brussels St   Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
91 260225 1 10 2201x 22nd Ave 21 Sidewalk: Curb side : Cutout Tree 1 FUF 10/20/2018 12:00:00 AM 3                        
92 260521 1 46 3519x Kirkham St 3 Sidewalk: Curb side : Cutout Tree 1 FUF 07/27/2019 12:00:00 AM 3                        
93 260525 1 47 3437x Rivera St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 07/27/2019 12:00:00 AM 3                        
94 260654 7 45 2590 Buchanan St 1 Sidewalk: Curb side : Cutout Landscaping 2   10/03/2019 12:00:00 AM 3 3.5x3                      
95 261359 1 7 3 Bache St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6007238 2095678 37.7347419306018 -122.417391193891 (37.7347419306018, -122.417391193891) 2 7 7 28859 2
96 137041 1 31 1034 Sacramento St 5 Sidewalk: Curb side : Cutout Tree 2   05/28/2020 12:00:00 AM 3 Width 3ft   6009697.84819 2116804.05029 37.7928873337267 -122.410377820179 (37.7928873337267, -122.410377820179) 3 1 10 28857 21
97 261358 1 7 2x Bache St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6007175 2095707 37.7348180134015 -122.417611061749 (37.7348180134015, -122.417611061749) 2 7 7 28859 2
98 261380 1 48 298x Leavenworth St 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6008523 2113477 37.7836861327236 -122.414207368753 (37.7836861327236, -122.414207368753) 7 10 9 28852 36
99 255073 9 17 173R Glenview Dr   Back Yard : Yard Tree 2                              
100 255131 1 28 401X Brotherhood Way 9 Sidewalk: Property side : Yard Tree 1                              
101 255229 1 11 300X Goettingen St 4 Sidewalk: Curb side : Cutout Tree 1 FUF                            
102 258152 1 49 500X Bryant St 2 Sidewalk: Curb side : Cutout Tree 1 FUF   3                        
103 253831 1 45 699X Polk St 5 Sidewalk: Curb side : Cutout Tree 2 DPW     3x3                      
104 260590 1 50 3099x Jennings St 3 Sidewalk: Curb side : Cutout Tree 1 FUF 08/20/2020 12:00:00 AM 3                        
105 70839 1 11 939 Howard St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   12     6010931.16123 2112337.60471 37.780692593337 -122.405795716794 (37.780692593337, -122.405795716794) 14 2 9 28853 34
106 251438 1 41 2501X Santiago St 1 Median : Yard Tree 1                              
107 264818 1 51 101x Olmstead St 2 Sidewalk: Curb side : Cutout Tree 1   10/23/2020 12:00:00 AM 3                        
111 97355 7 17   5 Unaccepted Street : Yard Tree 2                              
113 182915 1 45 2711 47th Ave 2 Sidewalk: Curb side : Cutout Tree 2     0 Width 0ft   5981812.2124 2096648.8938 37.7359443944789 -122.505367292654 (37.7359443944789, -122.505367292654) 1 8 3 29491 35
114 251458 1 50 651 Texas St 1 Sidewalk: Curb side : Cutout Tree 2   05/03/2017 12:00:00 AM 3 3x3                      
115 121173 6 17 950 Duncan St 2 Front Yard : Yard Tree 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
116 113159 4 52 555 GROVE ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6005146 2111243 37.777361853017 -122.425731455878 (37.777361853017, -122.425731455878) 7 9 11 28852 10
117 108152 4 53 2232 Webster St 4 Sidewalk: Curb side : Cutout Tree 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
118 236256 1 27 151 Valencia St 1 : Tree 2     9 Width 4ft   6006073.15075 2108915.83898 37.7710243776945 -122.422358744984 (37.7710243776945, -122.422358744984) 8 2 9 28853 19
119 184195 1 45 1459 37th Ave 1 Sidewalk: Curb side : Cutout Tree 2     0 Width 0ft   5984624.9154 2105245.6219 37.759713770345 -122.49627690204 (37.759713770345, -122.49627690204) 1 8 3 56 35
120 141225 1 45 3 COMMONWEALTH AVE 1 Sidewalk: Curb side : Yard Tree 2     0 Width 0ft   5996479.075 2114520.1031 37.7858663452689 -122.455949967769 (37.7858663452689, -122.455949967769) 11 6 1 54 31
122 17067 1 54 1355 Oak St 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6000506.9486 2109572.2346 37.7725111167076 -122.441659471159 (37.7725111167076, -122.441659471159) 15 5 11 29492 9
123 221263 1 55 1 Church St 1 Sidewalk: Property side : Yard Tree 2     7 Width 6ft   6004132.36771 2108477.00924 37.7697097883113 -122.429040680782 (37.7697097883113, -122.429040680782) 7 9 5 29492 10
124 114040 1 56 95 LINARES AVE 1 Front Yard : Yard Tree 1     40 3x3   5994258 2102054 37.7515099774588 -122.462729551044 (37.7515099774588, -122.462729551044) 1 8 4 29491 40
125 92934 4 57 339 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree 2     10     5992211 2096907 37.737259523291 -122.46943364564 (37.737259523291, -122.46943364564) 1 8 4 59 40
126 173890 1 58 2593 23rd Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5989209 2097724 37.7393288482101 -122.479872589648 (37.7393288482101, -122.479872589648) 1 8 3 29491 35
127 119777 1 59 204x Octavia St 12 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
128 110722 4 60 1898X 10th Ave 3 Sidewalk: Curb side : Cutout Tree 2           5993137.43282 2102888.05903 37.753735486992 -122.466665198088 (37.753735486992, -122.466665198088) 1 8 4 56 12