sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
18577 5154 3 9 259 Divisadero St 1 1 1 1 4   3 3X3   6001780.9624 2109220.4101 37.771617599631604 -122.43722734206499 (37.7716175996316, -122.437227342065)
17572 5174 3 9 350 Divisadero St 1 1 1 1 4 11/28/2006 12:00:00 AM 3 3x4   6001785.2321 2109677.0482 37.7728716568906 -122.437245274575 (37.7728716568906, -122.437245274575)
113485 97567 3 223 342 Divisadero St 1 1 1 1 4   3     6001791.0 2109583.0 37.772613751849605 -122.43721858759199 (37.7726137518496, -122.437218587592)
88343 97566 3 223 338 Divisadero St 1 1 1 1 4   3     6001793.0 2109569.0 37.7725754250276 -122.437210666805 (37.7725754250276, -122.437210666805)
17669 5170 3 223 318 Divisadero St 1 1 1 1 4 02/15/2005 12:00:00 AM 3 3X3   6001801.5136 2109559.6859 37.7725503347821 -122.43718055043101 (37.7725503347821, -122.437180550431)
118370 97563 3 223 250 Divisadero St 1 1 1 1 4 09/21/2015 12:00:00 AM 3 5x5   6001845.0 2109086.0 37.771252182937296 -122.436996208247 (37.7712521829373, -122.436996208247)
116328 5157 3 223 270 Divisadero St 2 1 1 1 4   0     6001849.8958745 2109240.8779841997 37.7716777176824 -122.43699036314301 (37.7716777176824, -122.436990363143)
61687 97564 3 223 252 Divisadero St 1 1 1 1 4   3     6001879.6 2109184.5 37.7715246060424 -122.43688357823 (37.7715246060424, -122.43688357823)
100514 97565 3 223 258 Divisadero St 1 1 1 1 4   3     6001879.6 2109184.5 37.7715246060424 -122.43688357823 (37.7715246060424, -122.43688357823)
101889 95411 1 20 2815 Diamond St 1 1 1 1 4   1 3x3 Planted by Glen Park Library; will become DPW maintained. 6002467.0 2095594.0 37.734241695714005 -122.43388015504499 (37.734241695714, -122.433880155045)
120383 95412 1 20 2815 Diamond St 3 1 1 1 4   1 3x3 Planted by Glen Park Public Library; will become DPW maintained after it is established. 6002467.0 2095594.0 37.734241695714005 -122.43388015504499 (37.734241695714, -122.433880155045)
26614 98657 1 55 2110 Greenwich St 11 1 1 4 4   11 5x5   6002607.56666 2119218.5959900003 37.7991170337862 -122.43508328318701 (37.7991170337862, -122.435083283187)
31571 98656 1 55 2110 Greenwich St 10 1 1 4 4   8 5x5   6002629.88193 2119221.45898 37.799126161900396 -122.435006269744 (37.7991261619004, -122.435006269744)
131687 98655 1 55 2110 Greenwich St 9 1 1 4 4   6 5x5   6002650.75991 2119226.56813 37.799141375727295 -122.434934390513 (37.7991413757273, -122.434934390513)
71504 98651 1 32 2110 Greenwich St 8 1 1 4 4   23 5x5   6002674.17203 2119228.66956 37.799148474973705 -122.434853527066 (37.7991484749737, -122.434853527066)
105652 98659 1 43 2110 Greenwich St 13 1 1 4 4   20 7x7   6002683.8 2119245.6 37.799195508176105 -122.434821422435 (37.7991955081761, -122.434821422435)
111283 98658 3 17 2110 Greenwich St 12 1 1 4 4 06/20/2014 12:00:00 AM   6x6 Permit Number 772915 6002683.8 2119245.6 37.799195508176105 -122.434821422435 (37.7991955081761, -122.434821422435)
53064 98650 1 55 2110 Greenwich St 7 1 1 4 4   11 5x5   6002693.158 2119231.9709099997 37.799158617543604 -122.43478806542801 (37.7991586175436, -122.434788065428)
69128 98649 1 55 2110 Greenwich St 6 1 1 4 4   16 5x5   6002707.76445 2119233.0203 37.799162328147794 -122.434737597267 (37.7991623281478, -122.434737597267)
44207 98648 1 55 2110 Greenwich St 5 1 1 4 4   9 5x5   6002730.0885 2119237.75472 37.7991765949935 -122.434660687245 (37.7991765949935, -122.434660687245)
161870 98647 1 55 2110 Greenwich St 4 1 1 4 4   12 5x5   6002751.94545 2119240.19821 37.7991845449763 -122.434585229619 (37.7991845449763, -122.434585229619)
33915 98646 1 55 2110 Greenwich St 3 1 1 4 4   8 5x5   6002771.23879 2119243.65965 37.799195144410795 -122.43451871576099 (37.7991951444108, -122.434518715761)
153048 98645 1 55 2110 Greenwich St 2 1 1 4 4   9 5x5   6002788.88101 2119245.38589 37.799200885676605 -122.434457791187 (37.7992008856766, -122.434457791187)
74427 67860 1 55 2110 Greenwich St 1 1 1 4 4 01/20/1993 12:00:00 AM 5 5x5 Permit Number 31536 6002806.21719 2119247.92289 37.7992088356751 -122.43439798360501 (37.7992088356751, -122.434397983605)
61243 34693 1 55 3101X Webster St 1 1 1 4 4 07/28/1997 12:00:00 AM 9 3x3 Permit Number 38352 6002813.73545 2119366.57801 37.799535058456 -122.43438045581301 (37.799535058456, -122.434380455813)
52422 34688 1 55 3101X Webster St 2 1 1 4 4 07/28/1997 12:00:00 AM 7 3x3 Permit Number 38352 6002815.38185 2119347.35443 37.7994823689702 -122.434373383533 (37.7994823689702, -122.434373383533)
176592 34689 1 55 3101X Webster St 3 1 1 4 4 07/28/1997 12:00:00 AM 5 3x3 Permit Number 38352 6002816.77257 2119329.88091 37.79943447017929 -122.434367321195 (37.7994344701793, -122.434367321195)
73429 34690 1 55 3101X Webster St 4 1 1 4 4 07/28/1997 12:00:00 AM 8 3x3 Permit Number 38352 6002819.05677 2119313.26082 37.7993889653989 -122.434358228162 (37.7993889653989, -122.434358228162)
166994 34691 1 55 3101X Webster St 5 1 1 4 4 07/28/1997 12:00:00 AM 10 3x3 Permit Number 38352 6002820.98316 2119293.45008 37.7993346796145 -122.43435014504699 (37.7993346796145, -122.434350145047)
133902 34692 1 55 3101X Webster St 6 1 1 4 4 07/28/1997 12:00:00 AM 9 3x3 Permit Number 38352 6002825.2019 2119271.55666 37.7992748054477 -122.434333980647 (37.7992748054477, -122.434333980647)
7506 14836 1 21 1300 McAllister St 1 1 1 1 4 10/22/2008 12:00:00 AM 9 3X3   6002892.8097 2111692.1261 37.7784674596438 -122.43355807318501 (37.7784674596438, -122.433558073185)
81591 95239 2 26 1220 Noe St 6 1 1 4 4   12     6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
95002 95237 2 26 1220 Noe St 4 1 1 4 4   9 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
107934 95238 2 26 1220 Noe St 5 1 1 4 4     3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
117440 95240 2 26 1220 Noe St 7 1 1 4 4   12 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
120777 95241 2 26 1220 Noe St 8 1 1 4 4   3 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
121486 95235 2 26 1220 Noe St 1 1 1 4 4   3 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
142420 95236 2 26 1220 Noe St 2 1 1 4 4   12 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
85143 115005 5 16 1050 MCALLISTER ST 2 8 1 21 4     3x3   6004148.0 2111858.0 37.778994045300706 -122.42922772691401 (37.7789940453007, -122.429227726914)
106272 115004 5 80 1050 MCALLISTER ST 1 8 1 21 4 01/19/2016 09:19:00 AM 3 3x3   6004148.0 2111858.0 37.778994045300706 -122.42922772691401 (37.7789940453007, -122.429227726914)
81163 104152 1 54 525X Church St 2 5 2 4 4     2x68   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
81722 104155 1 54 525X Church St 3 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
92935 104156 1 54 525X Church St 4 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
95495 104151 1 54 525X Church St 1 5 2 4 4     2x58   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
95556 104158 1 54 525X Church St 6 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
96077 104157 1 54 525X Church St 5 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
113603 104154 1 54 525X Church St 2 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
141475 104153 1 54 525X Church St 1 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
87276 112509 2 11 699x WILLOW ST 1 1 1 20 4     2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
94993 112510 2 11 699x WILLOW ST 2 1 1 20 4     2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
120473 112511 2 11 699x WILLOW ST 3 1 1 20 4 08/08/2015 03:37:00 PM 3 2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
89333 104727 1 90 1079 Church St 1 1 1 1 4     3x3 Permit Number 770313 6004450.0 2102615.0 37.7536320814231 -122.427524315639 (37.7536320814231, -122.427524315639)
104559 114737 2 225 455x LILY ST 1 10 1 10 4         6004484.0 2109981.0 37.77385927942 -122.427931581119 (37.77385927942, -122.427931581119)
85658 96467 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
89325 96464 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
103701 96466 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
115707 96469 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
120725 96465 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
124890 96470 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
144888 96468 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
110539 14250 1 15 2001 Market St 6 1 1 1 4 05/20/2011 12:00:00 AM 0 3x3 Permit Number 767173 6004759.8459002 2108188.2274393 37.7689523618819 -122.426849682313 (37.7689523618819, -122.426849682313)
140589 14248 1 15 2001 Market St 4 1 1 1 4 05/20/2011 12:00:00 AM 0 3x3 Permit Number 767173 6004759.8459002 2108188.2274393 37.7689523618819 -122.426849682313 (37.7689523618819, -122.426849682313)
62828 5490 1 150 714 Dolores St 1 1 1 1 4 12/28/2015 12:00:00 AM 1 4X4 Permit Number 774286 6004953.58017 2104162.27117 37.757908995925206 -122.425892952911 (37.7579089959252, -122.425892952911)
127181 103126 1 17 1020 Guerrero St 2 1 1 1 4 03/22/2013 12:00:00 AM   3x3 Permit Number 769235 6005624.5 2103007.3 37.7547756072831 -122.423490517587 (37.7547756072831, -122.423490517587)
1685 251478 1 15 2x Virginia Ave 2 1 1 1 4 02/21/2004 12:00:00 AM   3x3   6006146.0 2098692.0 37.7429562000135 -122.42138058886101 (37.7429562000135, -122.421380588861)
94772 98675 1 17 199X Park St 1 1 1 4 4         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
5211 253829 1 54 869 Ellis St 1 1 1 1 4     3x3   6006713.1749 2113568.2957099997 37.7838349840749 -122.420475171434 (37.7838349840749, -122.420475171434)
12092 77648 3 55 1300X Silliman St 9 1 1 4 4 01/01/2011 12:00:00 AM 3 3x3   6006817.147419999 2093142.9824700002 37.727757638780204 -122.418666516263 (37.7277576387802, -122.418666516263)
5238 169219 1 29 840 Polk St 1 1 1 1 4   0 3x3   6006827.36035 2113629.7400599997 37.7840101293977 -122.42008449353001 (37.7840101293977, -122.42008449353)
5210 83637 1 17 840 Ellis St 1 1 1 1 4 11/19/2005 12:00:00 AM   3x3   6006834.966315799 2113631.30048912 37.784014842491395 -122.420058290383 (37.7840148424914, -122.420058290383)
96184 102636 1 26 2176 Mission St 2 1 1 1 4 02/08/2013 12:00:00 AM 3 5x5 Permit Number 769974 6006850.0 2105688.0 37.7622052831774 -122.41944256138001 (37.7622052831774, -122.41944256138)
109180 102635 1 26 2176 Mission St 1 1 1 1 4 02/08/2013 12:00:00 AM 3 5x5 Permit Number 769974 6006850.0 2105688.0 37.7622052831774 -122.41944256138001 (37.7622052831774, -122.41944256138)
5229 253834 1 54 747 Eddy St 1 1 1 1 4     3x3   6006860.78535 2113242.76542 37.7829494746502 -122.419941385136 (37.7829494746502, -122.419941385136)
5234 169170 1 29 750 Eddy St 1 1 1 1 4   0 3x3   6006877.9642199995 2113290.02776 37.7830802133315 -122.419885308057 (37.7830802133315, -122.419885308057)
5209 169218 1 29 824 Ellis St 1 1 1 1 4   0 3x3   6006905.3054599995 2113639.6299099997 37.7840416758297 -122.419815533287 (37.7840416758297, -122.419815533287)
5227 169217 1 29 800 Ellis St 1 1 1 1 4   0 3x3   6006932.37231 2113646.73425 37.7840627073778 -122.41972239586501 (37.7840627073778, -122.419722395865)
5224 253827 1 54 825 Polk St 1 1 1 1 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5228 253828 1 54 825 Polk St 2 1 1 1 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5223 74484 1 17 749 Polk St 4 1 1 1 4 06/29/2016 12:00:00 AM 3 3x3 Permit Number 778449 6007035.08305 2113498.23336 37.783660745502296 -122.41935651480301 (37.7836607455023, -122.419356514803)
5217 169168 1 29 701 Polk St 2 1 1 1 4   0 3x3   6007051.56678 2113380.55802 37.7833385660552 -122.41929113679599 (37.7833385660552, -122.419291136796)
5226 253832 1 54 665 Eddy St 1 1 1 1 4     3x3   6007254.7956 2113297.42725 37.783121752773 -122.41858214693501 (37.783121752773, -122.418582146935)
5218 169214 1 29 724 Ellis St 1 1 1 1 4   0 Width 4ft   6007369.544319999 2113705.88387 37.7842497348906 -122.41821413029301 (37.7842497348906, -122.418214130293)
5222 253825 1 54 725 Ellis St 1 1 1 1 4     3x3   6007393.727109999 2113660.9435900003 37.784127700976896 -122.418127279043 (37.7841277009769, -122.418127279043)
77610 109992 2 55 501X Shotwell St 9 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
83876 109990 2 26 501X Shotwell St 7 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
85949 109996 2 55 501X Shotwell St 13 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
89691 109988 2 26 501X Shotwell St 5 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
90177 109991 2 297 501X Shotwell St 8 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
92640 109986 2 26 501X Shotwell St 3 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
93134 98908 2 26 501X Shotwell St 2 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
95046 109987 2 26 501X Shotwell St 4 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
106116 109995 2 55 501X Shotwell St 12 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
109915 109999 2 10 501X Shotwell St 16 1 1 10 4         6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
121169 109989 2 26 501X Shotwell St 6 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
124070 98909 2 26 501X Shotwell St 1 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
124316 109993 2 55 501X Shotwell St 10 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
128369 109998 2 10 501X Shotwell St 15 1 1 10 4         6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
142889 109994 2 55 501X Shotwell St 11 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
122481 102195 2 55 3999X Folsom St 9 1 1 4 4   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
10038 96503 3 150 2360X Harrison St 4 1 1 4 4     3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
93703 97898 2 49 375X Precita Ave 4 1 1 4 4   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
Powered by Datasette · Query took 4.953ms · Data source: data.sfgov.org