sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
104 251210 3 39 1170 Ingalls St 2 1 1 2   11/02/1992 12:00:00 AM                
144777 24280 3 39 300X Winding Way 18 11 1 2     3 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117)
22854 176359 3 39 350x Winding Way 8 11 1 2     19 Width 0ft   6001093.21408 2086592.19305 37.7094467152559 -122.437985185864 (37.7094467152559, -122.437985185864)
10821 1299 3 39 4000X Alemany Blvd 7 11 1 2     40 10   5991881.88808 2087114.90346 37.7103538164401 -122.46985880224301 (37.7103538164401, -122.469858802243)
10727 1298 3 39 4000X Alemany Blvd 6 11 1 2     25 10   5991889.9079 2087118.85792 37.7103651380077 -122.46983137204599 (37.7103651380077, -122.469831372046)
11437 1297 3 39 4000X Alemany Blvd 5 11 1 2     25 10   5991899.37983 2087126.21827 37.7103858952584 -122.46979917089199 (37.7103858952584, -122.469799170892)
10785 1296 3 39 4000X Alemany Blvd 4 11 1 2     35 10   5991907.39965 2087130.17274 37.710397216839496 -122.46977174067499 (37.7103972168395, -122.469771740675)
10299 1295 3 39 4000X Alemany Blvd 3 11 1 2     25 10   5991914.74417 2087134.82891 37.710410426081 -122.46974669545901 (37.710410426081, -122.469746695459)
88459 104427 2 39 1000x GILMAN AVE 1 1 1 2     20 4x4   6015570.0 2089525.0 37.71831228448 -122.3881550967 (37.71831228448, -122.3881550967)
14018 99640 3 39 1000X Gilman Ave 1 1 1 2     30 3x3 City Owned Lot 6015553.4063 2089548.4030000002 37.7183756251523 -122.38821408703001 (37.7183756251523, -122.38821408703)
19083 26913 3 39 10 Caine Ave 9 11 1 2     24 10   5997584.35365 2089616.43233 37.717550413599795 -122.45033019131 (37.7175504135998, -122.45033019131)
17237 26912 3 39 10 Caine Ave 8 11 1 2     50 10   5997598.31865 2089637.50605 37.7176090763688 -122.450283439137 (37.7176090763688, -122.450283439137)
19195 26910 3 39 10 Caine Ave 6 11 1 2     12 10   5997620.43146 2089669.0920400003 37.7176970696553 -122.45020928103399 (37.7176970696553, -122.450209281034)
17205 26909 3 39 10 Caine Ave 5 11 1 2     18 10   5997629.54091 2089680.9775599998 37.71773022584279 -122.45017865014299 (37.7177302258428, -122.450178650143)
21305 26908 3 39 10 Caine Ave 4 11 1 2     18 10   5997639.65043 2089696.09364 37.7177723096208 -122.45014479517 (37.7177723096208, -122.45014479517)
21645 26907 3 39 10 Caine Ave 3 11 1 2     18 10   5997653.71656 2089718.57825 37.717834852078205 -122.45009779478701 (37.7178348520782, -122.450097794787)
20603 26906 3 39 10 Caine Ave 2 11 1 2     24 10   5997668.873459999 2089736.17467 37.717884035095295 -122.450046671911 (37.7178840350953, -122.450046671911)
19342 26905 3 39 10 Caine Ave 1 11 1 2     12 10   5997683.40035 2089758.8108400002 37.7179470200262 -122.449998089654 (37.7179470200262, -122.449998089654)
179926 176358 3 39 300x Mansell St 1 11 1 2     24 Width 0ft   6010959.21222 2090503.85024 37.720743461908995 -122.40416158569599 (37.720743461909, -122.404161585696)
148876 209172 3 39 600x Faxon Ave 2 3 1 2     31     5994902.7257 2092594.45065 37.725573503888 -122.45981488494199 (37.725573503888, -122.459814884942)
167933 209105 3 39 600x Faxon Ave 1 3 1 2     31     5994942.183230001 2092612.57817 37.7256255467665 -122.459679796903 (37.7256255467665, -122.459679796903)
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)
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)
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)
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)
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)
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)
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)
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)
13251 187611 2 39 100 Northridge Rd 3 1 1 2       3x3   6018548.0 2094208.0 37.7313354560629 -122.37818620453699 (37.7313354560629, -122.378186204537)
4668 253644 3 39 1200x La Salle Ave 12 1 1 2 3 11/05/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4669 253646 3 39 1200x La Salle Ave 22 1 1 2 3 11/09/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4684 253645 3 39 1200x La Salle Ave 17 1 1 2 3 03/11/2006 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
86885 11999 3 39 1200X La Salle Ave 26 1 1 2   11/09/1992 12:00:00 AM 12 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
87797 11991 3 39 1200X La Salle Ave 18 1 1 2   11/09/1992 12:00:00 AM 12 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
105361 11992 3 39 1200X La Salle Ave 19 1 1 2   08/26/2016 12:00:00 AM 18 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
107681 26534 3 39 1200X La Salle Ave 28 1 1 2     12 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
124093 11979 3 39 1200X La Salle Ave 6 1 1 2     30 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
128523 11995 3 39 1200X La Salle Ave 22 1 1 2   11/09/1992 12:00:00 AM 18 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
142345 11985 3 39 1200X La Salle Ave 12 1 1 2   11/05/1992 12:00:00 AM 12 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
14426 4895 3 39 10 Rosie Lee Ln 1 1 1 2   04/19/1993 12:00:00 AM 12 3X4   6018140.882180001 2094365.07214 37.7317442992597 -122.379604608867 (37.7317442992597, -122.379604608867)
85139 6395 3 39 5X Rosie Lee Ln 1 1 1 2   04/19/1993 12:00:00 AM 3 3X4   6018168.8629005 2094369.8502073998 37.7317589621466 -122.379508204595 (37.7317589621466, -122.379508204595)
19420 12067 3 39 1225X La Salle Ave 2 1 1 2     18 3X3   6017323.1868972 2094393.2571117 37.7317765554235 -122.38243353641701 (37.7317765554235, -122.382433536417)
118265 12069 3 39 1225X La Salle Ave 4 1 1 2     18 3X3   6017323.1868972 2094393.2571117 37.7317765554235 -122.38243353641701 (37.7317765554235, -122.382433536417)
123087 12068 3 39 1225X La Salle Ave 3 1 1 2     18 3X3   6017323.1868972 2094393.2571117 37.7317765554235 -122.38243353641701 (37.7317765554235, -122.382433536417)
88148 12074 3 39 1241X La Salle Ave 1 1 1 2     12 3X3   6017245.0743814 2094442.9323578998 37.7319086387255 -122.382707045529 (37.7319086387255, -122.382707045529)
96515 12076 3 39 1241X La Salle Ave 3 1 1 2     12 3X3   6017245.0743814 2094442.9323578998 37.7319086387255 -122.382707045529 (37.7319086387255, -122.382707045529)
142989 12075 3 39 1241X La Salle Ave 2 1 1 2     12 3X3   6017245.0743814 2094442.9323578998 37.7319086387255 -122.382707045529 (37.7319086387255, -122.382707045529)
144907 12078 3 39 1241X La Salle Ave 5 1 1 2     12 3X3   6017245.0743814 2094442.9323578998 37.7319086387255 -122.382707045529 (37.7319086387255, -122.382707045529)
20904 12016 3 39 1230X La Salle Ave 17 1 1 2   11/09/1992 12:00:00 AM 6 3X3   6017323.1168478 2094452.6646717 37.7319396729967 -122.382437910438 (37.7319396729967, -122.382437910438)
78253 12004 3 39 1230X La Salle Ave 5 1 1 2     6 3X3   6017323.1168478 2094452.6646717 37.7319396729967 -122.382437910438 (37.7319396729967, -122.382437910438)
79391 12006 3 39 1230X La Salle Ave 7 1 1 2     12 3X3   6017323.1168478 2094452.6646717 37.7319396729967 -122.382437910438 (37.7319396729967, -122.382437910438)
115821 12014 3 39 1230X La Salle Ave 15 1 1 2   02/25/2011 12:00:00 AM 6 3X3   6017323.1168478 2094452.6646717 37.7319396729967 -122.382437910438 (37.7319396729967, -122.382437910438)
129075 12082 3 39 1261X La Salle Ave 11 1 1 2     24 3X3   6017141.6501925 2094501.7221284 37.732064349457005 -122.383068698568 (37.732064349457, -122.383068698568)
79498 12022 3 39 1250X La Salle Ave 4 1 1 2     18 3X3   6017218.4556902 2094518.6413490002 37.7321150500381 -122.38280433953301 (37.7321150500381, -122.382804339533)
82251 12036 3 39 1250X La Salle Ave 18 1 1 2     12 3X3   6017218.4556902 2094518.6413490002 37.7321150500381 -122.38280433953301 (37.7321150500381, -122.382804339533)
87739 12023 3 39 1250X La Salle Ave 5 1 1 2     18 3X3   6017218.4556902 2094518.6413490002 37.7321150500381 -122.38280433953301 (37.7321150500381, -122.382804339533)
89725 12020 3 39 1250X La Salle Ave 2 1 1 2     12 3X3   6017218.4556902 2094518.6413490002 37.7321150500381 -122.38280433953301 (37.7321150500381, -122.382804339533)
103065 12025 3 39 1250X La Salle Ave 7 1 1 2     12 3X3   6017218.4556902 2094518.6413490002 37.7321150500381 -122.38280433953301 (37.7321150500381, -122.382804339533)
107134 12043 3 39 1250X La Salle Ave 25 1 1 2   03/29/1993 12:00:00 AM 12 3X3   6017218.4556902 2094518.6413490002 37.7321150500381 -122.38280433953301 (37.7321150500381, -122.382804339533)
122864 12030 3 39 1250X La Salle Ave 12 1 1 2     12 3X3   6017218.4556902 2094518.6413490002 37.7321150500381 -122.38280433953301 (37.7321150500381, -122.382804339533)
99618 12111 3 39 1291X La Salle Ave 2 1 1 2     12 3X3   6016979.7352729 2094586.3401911 37.7322877456302 -122.383634368276 (37.7322877456302, -122.383634368276)
79673 12115 3 39 1295X La Salle Ave 4 1 1 2     24 3X3   6016958.2682626 2094597.9426773998 37.7323184171755 -122.383709392876 (37.7323184171755, -122.383709392876)
88419 10839 3 39 1139X Hudson Ave 46 1 1 2     12 3X4   6017986.87901 2094607.0340099998 37.732400183828396 -122.380153842969 (37.7324001838284, -122.380153842969)
108988 10842 3 39 1139X Hudson Ave 49 1 1 2     12 3X4   6018020.73301 2094608.3360099997 37.732405626582796 -122.380036890979 (37.7324056265828, -122.380036890979)
81260 10730 3 39 1100 Hudson Ave 1 1 1 2     12 3X4   6018138.790397401 2094650.7890521 37.7325287066123 -122.379631682873 (37.7325287066123, -122.379631682873)
84760 10732 3 39 1100 Hudson Ave 3 1 1 2     12 3X4   6018138.790397401 2094650.7890521 37.7325287066123 -122.379631682873 (37.7325287066123, -122.379631682873)
88044 10731 3 39 1100 Hudson Ave 2 5 1 2     12 3X4   6018138.790397401 2094650.7890521 37.7325287066123 -122.379631682873 (37.7325287066123, -122.379631682873)
103686 10735 3 39 1100 Hudson Ave 6 5 1 2     12 3x4   6018138.790397401 2094650.7890521 37.7325287066123 -122.379631682873 (37.7325287066123, -122.379631682873)
18452 10752 3 39 1120X Hudson Ave 26 1 1 2     20 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
47273 10756 3 39 1120X Hudson Ave 37 1 1 2     20 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
78294 24522 3 39 1120X Hudson Ave 45 5 1 2     18 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
Powered by Datasette · Query took 12.162ms · Data source: data.sfgov.org