sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
155107 191981 2 39 8 Navy Rd 12 1 1 1     27 Width 4ft   6017899.944209999 2093758.26883 37.730064844096 -122.380395431304 (37.730064844096, -122.380395431304)
79810 68817 1 39 125 Congo St 1 1 1 1 1 06/19/2007 12:00:00 AM     Permit Number 49379 6000058.92001633 2094143.32486819 37.730121532663105 -122.442101535638 (37.7301215326631, -122.442101535638)
59027 209180 2 39 1265 Monterey Blvd 1 1 1 1     2 Width 3ft   5994085.05956 2094328.0353599999 37.7302864478603 -122.46276717308099 (37.7302864478603, -122.462767173081)
24217 206259 2 39 125 Congo St 1 1 1 1     10 Width 3ft   6000067.98121 2094222.9592799998 37.73034070664679 -122.442075923983 (37.7303407066468, -122.442075923983)
77827 11247 3 39 1145X Ingalls St 2 1 1 2   01/09/2003 12:00:00 AM 8 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
78989 11248 3 39 1145X Ingalls St 3 1 1 2     50 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
99438 11256 3 39 1145X Ingalls St 11 1 1 2   01/09/2003 12:00:00 AM 3 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
120747 11257 3 39 1145X Ingalls St 12 1 1 2     70 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
123755 11255 3 39 1145X Ingalls St 10 1 1 2   11/02/1992 12:00:00 AM 80 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
124384 11246 3 39 1145X Ingalls St 1 1 1 2   01/09/2003 12:00:00 AM 16 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
141024 11249 3 39 1145X Ingalls St 4 1 1 2   01/09/2003 12:00:00 AM 8 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
143708 11250 3 39 1145X Ingalls St 5 1 1 2     40 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
144435 11259 3 39 1145X Ingalls St 14 1 1 2     70 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
94658 11363 3 39 1351X Ingalls St 2 1 1 2   11/05/1992 12:00:00 AM 45 3X3   6017270.42563 2093912.097264 37.730452470679005 -122.38258247713001 (37.730452470679, -122.38258247713)
128842 11364 3 39 1351X Ingalls St 3 1 1 2   11/05/1992 12:00:00 AM 45 3X3   6017270.42563 2093912.097264 37.730452470679005 -122.38258247713001 (37.730452470679, -122.38258247713)
29750 192007 2 39 1201 Ingalls St 1 1 1 1     23 Width 3ft   6017817.46724 2093902.85475 37.730457297459395 -122.38069061399099 (37.7304572974594, -122.380690613991)
130780 192006 2 39 1241 Ingalls St 4 1 1 1     18 Width 3ft   6017773.06159 2093908.81444 37.7304712108758 -122.380844546432 (37.7304712108758, -122.380844546432)
68175 192008 2 39 1201 Ingalls St 3 1 1 1     22 Width 3ft   6017902.514280001 2093906.2127 37.730471210880395 -122.380396824379 (37.7304712108804, -122.380396824379)
35908 192005 2 39 1241 Ingalls St 2 1 1 1     19 Width 3ft   6017726.88625 2093915.31646 37.7304865155426 -122.38100463475901 (37.7304865155426, -122.381004634759)
41202 191993 2 39 1395 Ingalls St 1 1 1 1     28 Width 3ft   6017281.31768 2093927.6967 37.7304959053633 -122.382545906371 (37.7304959053633, -122.382545906371)
171306 192004 2 39 1241 Ingalls St 1 1 1 1     15 Width 3ft   6017662.928069999 2093923.1897599997 37.730504603608395 -122.381226296963 (37.7305046036084, -122.381226296963)
120914 11299 3 39 1199X Ingalls St 11 1 1 2     12 3X3   6017612.0195749 2093925.7037957 37.730508696225705 -122.38140247160801 (37.7305086962257, -122.381402471608)
138783 11294 3 39 1199X Ingalls St 6 1 1 2   11/02/1992 12:00:00 AM 20 3X3   6017612.0195749 2093925.7037957 37.730508696225705 -122.38140247160801 (37.7305086962257, -122.381402471608)
170007 191994 2 39 1395 Ingalls St 2 1 1 1     22 Width 3ft   6017291.34241 2093932.84482 37.730510594866296 -122.382511607139 (37.7305105948663, -122.382511607139)
119632 45473 1 39 1301 Monterey Blvd 1 1 1 1 1 07/19/2001 12:00:00 AM     Permit Number 44252 5993960.36650023 2094413.72258595 37.730514541433 -122.463204465727 (37.730514541433, -122.463204465727)
163711 192009 2 39 1201 Ingalls St 4 1 1 1     30 Width 3ft   6017965.16033 2093921.6756900002 37.7305171257561 -122.38018131983 (37.7305171257561, -122.38018131983)
171887 191995 2 39 1395 Ingalls St 3 1 1 1     21 Width 3ft   6017309.55095 2093938.56525 37.7305273078777 -122.382449054783 (37.7305273078777, -122.382449054783)
149465 209069 2 39 177 San Aleso Ave 1 1 1 1     5 Width 3ft   5993364.4367 2094431.43007 37.7305288133566 -122.465265951075 (37.7305288133566, -122.465265951075)
134935 192003 2 39 1395 Ingalls St 7 1 1 1     17 Width 3ft   6017599.45813 2093934.6827 37.7305326570345 -122.381446522951 (37.7305326570345, -122.381446522951)
148531 192002 2 39 1395 Ingalls St 6 1 1 1     25 Width 3ft   6017577.27087 2093937.8070099999 37.730540010805896 -122.381523445545 (37.7305400108059, -122.381523445545)
79414 55370 1 39 177 San Aleso Ave 1 1 1 1   07/11/2011 12:00:00 AM   2x3 Permit Number 767959 5993373.59500695 2094436.22943113 37.7305425193622 -122.465234638195 (37.7305425193622, -122.465234638195)
175645 191996 2 39 1395 Ingalls St 4 1 1 1     27 Width 3ft   6017329.70509 2093943.7601700001 37.7305426853777 -122.382379739556 (37.7305426853777, -122.382379739556)
40533 192001 2 39 1395 Ingalls St 5 1 1 1     23 Width 3ft   6017559.96669 2093940.58979 37.73054669636571 -122.38158346271001 (37.7305466963657, -122.38158346271)
36637 192000 2 39 1301 Ingalls St 4 1 1 1     27 Width 3ft   6017496.52836 2093947.2221900001 37.7305614047807 -122.381803241742 (37.7305614047807, -122.381803241742)
115961 11336 3 39 1279 Ingalls St 5 1 1 2   11/04/1992 12:00:00 AM 6 3X3   6017412.9471167 2093950.7223454 37.7305663998171 -122.38209244081101 (37.7305663998171, -122.382092440811)
135618 209130 2 39 1301 Monterey Blvd 2 2 1 1     14 Width 2ft   5993944.42117 2094433.5464700002 37.7305680543596 -122.463261028572 (37.7305680543596, -122.463261028572)
59599 191999 2 39 1301 Ingalls St 3 1 1 1     26 Width 3ft   6017476.30115 2093950.5505099997 37.7305694267286 -122.381873402332 (37.7305694267286, -122.381873402332)
146541 192010 2 39 1201 Ingalls St 5 1 1 1     20 Width 3ft   6018007.26195 2093940.33851 37.7305706929704 -122.380037063171 (37.7305706929704, -122.380037063171)
58565 191998 2 39 1301 Ingalls St 2 1 1 1     15 Width 3ft   6017405.01242 2093955.87991 37.7305801232525 -122.38212023116002 (37.7305801232525, -122.38212023116)
38827 191997 2 39 1301 Ingalls St 1 1 1 1     30 Width 3ft   6017389.868919999 2093956.67155 37.7305814605653 -122.382172640078 (37.7305814605653, -122.382172640078)
49945 209129 2 39 1301 Monterey Blvd 1 2 1 1     14 Width 2ft   5993935.3367099995 2094440.81242 37.7305874815164 -122.463292961705 (37.7305874815164, -122.463292961705)
164049 192011 2 39 1200 Ingalls St 8 1 1 1     16 Width 3ft   6017795.885559999 2093951.0847 37.730588536408604 -122.38076857713001 (37.7305885364086, -122.38076857713)
63788 192012 2 39 1200 Ingalls St 11 1 1 1     21 Width 3ft   6017731.41883 2093958.61827 37.7306056640162 -122.38099197412201 (37.7306056640162, -122.380991974122)
72215 11275 3 39 1176X Ingalls St 14 1 1 2     60 3x3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
79089 11278 3 39 1176X Ingalls St 17 1 1 2     45 3x3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
82684 11268 3 39 1176X Ingalls St 7 1 1 2     60 3x3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
92296 11266 3 39 1176X Ingalls St 5 1 1 2   04/03/1990 12:00:00 AM 26 3X3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
98284 11286 3 39 1176X Ingalls St 25 1 1 2     45 3X3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
109373 11264 3 39 1176X Ingalls St 3 1 1 2   11/02/1992 12:00:00 AM 45 3X3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
116742 11283 3 39 1176X Ingalls St 22 1 1 2     80 3X3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
124813 11267 3 39 1176X Ingalls St 6 1 1 2     60 3X3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
139037 11285 3 39 1176X Ingalls St 24 1 1 2     45 3X3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
144239 11273 3 39 1176X Ingalls St 12 1 1 2   11/02/1992 12:00:00 AM 18 3x3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
178833 199330 2 39 1240 Ingalls St 2 1 1 1     22 Width 3ft   6017502.14738 2093988.55891 37.7306752175799 -122.38178668971901 (37.7306752175799, -122.381786689719)
104315 11345 3 39 1300X Ingalls St 3 1 1 2     90 3X3   6017347.6886145 2093992.5867035 37.730677746775605 -122.382320962891 (37.7306777467756, -122.382320962891)
162951 199331 2 39 1240 Ingalls St 3 1 1 1     25 Width 3ft   6017484.78419 2093989.84089 37.73067777884471 -122.38184680667801 (37.7306777788447, -122.381846806678)
178483 199332 2 39 1240 Ingalls St 4 1 1 1     25 Width 3ft   6017464.05542 2093991.8993400002 37.7306822862551 -122.381918613076 (37.7306822862551, -122.381918613076)
181076 199334 2 39 1240 Ingalls St 7 1 1 1     33 Width 3ft   6017407.70897 2093993.3611400002 37.7306831882733 -122.382113515049 (37.7306831882733, -122.382113515049)
139127 199333 2 39 1240 Ingalls St 6 1 1 1     20 Width 3ft   6017427.17906 2093994.2825799999 37.730686793661 -122.38204626733999 (37.730686793661, -122.38204626734)
81116 11239 3 39 1100X Ingalls St 8 1 1 2     40 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
81312 11243 3 39 1100X Ingalls St 12 1 1 2     12 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
86825 11235 3 39 1100X Ingalls St 4 1 1 2   01/06/2016 12:00:00 AM 18 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
99278 11244 3 39 1100X Ingalls St 13 1 1 2     18 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
103589 11241 3 39 1100X Ingalls St 10 1 1 2     80 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
126235 11232 3 39 1100X Ingalls St 1 1 1 2     60 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
138686 11245 3 39 1100X Ingalls St 14 1 1 2   04/02/1998 12:00:00 AM 12 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
40833 191885 2 39 1190 La Salle Ave 6 1 1 1     27 Width 3ft   6017587.790709999 2094017.9071400003 37.7307605308653 -122.381492644674 (37.7307605308653, -122.381492644674)
124113 191884 2 39 1190 La Salle Ave 5 1 1 1     17 Width 4ft   6017587.67672 2094040.73865 37.730823215418795 -122.38149462589199 (37.7308232154188, -122.381494625892)
71341 199337 2 39 15 Beatrice Ln 12 1 1 1     18 Width 3ft   6017980.98552 2094034.02956 37.73082650063571 -122.380134413865 (37.7308265006357, -122.380134413865)
34411 199336 2 39 15 Beatrice Ln 11 1 1 1     21 Width 3ft   6017966.39006 2094043.2312 37.7308509612846 -122.38018551245399 (37.7308509612846, -122.380185512454)
29839 191883 2 39 1190 La Salle Ave 4 1 1 1     28 Width 4ft   6017587.33306 2094052.1604900002 37.730854558576496 -122.381496607983 (37.7308545585765, -122.381496607983)
40959 191886 2 39 1189 La Salle Ave 2 1 1 1     20 Width 3ft   6017618.3449 2094055.2465 37.7308647442976 -122.38138960844 (37.7308647442976, -122.38138960844)
29980 191882 2 39 1190 La Salle Ave 3 1 1 1     16 Width 3ft   6017584.53768 2094069.90933 37.730903139072204 -122.381507505984 (37.7309031390722, -122.381507505984)
13240 187608 2 39 101 Northridge Rd 3 1 1 2       3x3   6018884.0 2094052.0 37.730925622785 -122.37701375897899 (37.730925622785, -122.377013758979)
13250 187606 2 39 101 Northridge Rd 1 1 1 2       3x3   6018884.0 2094052.0 37.730925622785 -122.37701375897899 (37.730925622785, -122.377013758979)
13256 187607 2 39 101 Northridge Rd 2 1 1 2       3x3   6018884.0 2094052.0 37.730925622785 -122.37701375897899 (37.730925622785, -122.377013758979)
138594 11229 3 39 1050X Ingalls St 15 1 1 2     45 3X4   6018085.661882901 2094069.8743192002 37.7309306978843 -122.379775016493 (37.7309306978843, -122.379775016493)
71042 191881 2 39 1190 La Salle Ave 2 1 1 1     20 Width 3ft   6017577.89829 2094096.01138 37.7309744436069 -122.381532274204 (37.7309744436069, -122.381532274204)
182832 191880 2 39 1190 La Salle Ave 1 1 1 1     19 Width 3ft   6017570.519730001 2094113.85237 37.7310230240753 -122.38155902364599 (37.7310230240753, -122.381559023646)
127234 11208 1 39 1001X Ingalls St 6 1 1 1     30 3X4   6018170.9910099 2094117.1281791 37.7310651541831 -122.379483297777 (37.7310651541831, -122.379483297777)
127821 11203 3 39 1001X Ingalls St 1 1 1 2     60 3X4   6018170.9910099 2094117.1281791 37.7310651541831 -122.379483297777 (37.7310651541831, -122.379483297777)
37328 191887 2 39 1189 La Salle Ave 6 1 1 1     22 Width 3ft   6017601.124969999 2094139.4908099999 37.731095111950395 -122.381454997274 (37.7310951119504, -122.381454997274)
61093 191888 2 39 1189 La Salle Ave 12 1 1 1     14 Width 3ft   6017588.02353 2094172.00048 37.7311836537856 -122.381502551614 (37.7311836537856, -122.381502551614)
173958 191889 2 39 1189 La Salle Ave 15 1 1 1     28 Width 3ft   6017576.13014 2094179.0885299998 37.7312024595247 -122.38154416233499 (37.7312024595247, -122.381544162335)
22909 209066 2 39 140 San Aleso Ave 1 1 1 1     5 Width 3ft   5993360.06028 2094684.7320599998 37.7312240657298 -122.46529947329901 (37.7312240657298, -122.465299473299)
184992 191890 2 39 1189 La Salle Ave 16 1 1 1     18 Width 3ft   6017576.622909999 2094189.3518 37.731230667655204 -122.381543172197 (37.7312306676552, -122.381543172197)
182100 191879 2 39 1194 La Salle Ave 6 1 1 1     25 Width 3ft   6017524.3913900005 2094199.8191400003 37.7312565249545 -122.381724475507 (37.7312565249545, -122.381724475507)
129536 191891 2 39 1189 La Salle Ave 20 1 1 1     15 Width 3ft   6017565.20536 2094205.8473099999 37.7312753306895 -122.381583791867 (37.7312753306895, -122.381583791867)
154016 191878 2 39 1194 La Salle Ave 5 1 1 1     23 Width 3ft   6017504.66664 2094216.4817299999 37.731301187978 -122.38179382671801 (37.731301187978, -122.381793826718)
169419 191892 2 39 1189 La Salle Ave 22 1 1 1     14 Width 3ft   6017557.69492 2094217.1276599998 37.7313058896339 -122.38161054129499 (37.7313058896339, -122.381610541295)
13251 187611 2 39 100 Northridge Rd 3 1 1 2       3x3   6018548.0 2094208.0 37.7313354560629 -122.37818620453699 (37.7313354560629, -122.378186204537)
161604 191877 2 39 1194 La Salle Ave 3 1 1 1     25 Width 3ft   6017481.20119 2094246.6317599998 37.7313826782496 -122.38187704821199 (37.7313826782496, -122.381877048212)
185872 191875 2 39 1194 La Salle Ave 1 1 1 1     15 Width 3ft   6017468.81534 2094257.7246 37.731412453025996 -122.38192064014 (37.731412453026, -122.38192064014)
185583 191876 2 39 1194 La Salle Ave 2 1 1 1     20 Width 3ft   6017474.3783599995 2094263.6054599998 37.7314289079177 -122.381901816439 (37.7314289079177, -122.381901816439)
68686 191893 2 39 1189 La Salle Ave 26 1 1 1     18 Width 3ft   6017518.154180001 2094274.42497 37.7314610334903 -122.38175122585501 (37.7314610334903, -122.381751225855)
35899 191874 2 39 1446 Osceola Ln 10 1 1 1     8 Width 3ft   6017213.67337 2094295.67432 37.7315025623769 -122.38280536260099 (37.7315025623769, -122.382805362601)
35579 191894 2 39 1195 La Salle Ave 1 1 1 1     4 Width 3ft   6017504.55596 2094293.80074 37.731513484662706 -122.381799585104 (37.7315134846627, -122.381799585104)
57291 191895 2 39 1195 La Salle Ave 3 1 1 1     13 Width 3ft   6017499.7458 2094300.2744 37.731530994442394 -122.381816665021 (37.7315309944424, -122.381816665021)
66333 191896 2 39 1195 La Salle Ave 5 1 1 1     20 Width 4ft   6017494.95789 2094307.84123 37.731551507078 -122.38183374402901 (37.731551507078, -122.381833744029)
133897 191873 2 39 1196 La Salle Ave 28 1 1 1     20 Width 3ft   6017415.1746 2094317.3101 37.731573100711294 -122.38211023161199 (37.7315731007113, -122.382110231612)
169425 191897 2 39 1195 La Salle Ave 7 1 1 1     14 Width 3ft   6017484.19267 2094318.4432599999 37.731580023696395 -122.38187169902099 (37.7315800236964, -122.381871699021)
Powered by Datasette · Query took 6.874ms · Data source: data.sfgov.org