sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
77875 106884 2 53 180X SAN MARCOS AVE 6 11 1 1 4   4     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
80527 97588 3 223 327 Divisadero St 1 1 1 1 4   3     6001736.6 2109522.6 37.7724448159613 -122.437402436672 (37.7724448159613, -122.437402436672)
80719 116576 6 40 2500x OCEAN AVE 1 9 1 6 4   30 10X10   5991377.0 2094742.0 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256)
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)
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)
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)
82894 24632 3 15 605 Divisadero St 1 1 1 1 4 10/08/2014 11:30:00 AM 3 3X3   6001606.913089 2110457.4002288003 37.7750041699802 -122.437918004082 (37.7750041699802, -122.437918004082)
83032 28101 3 223 305 Divisadero St 1 1 1 1 4   3 3X3   6001749.0605888 2109439.6370142 37.7722177286516 -122.437353392664 (37.7722177286516, -122.437353392664)
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)
84168 28096 3 223 850 Divisadero St 1 1 1 1 4   3 3X3   6001561.6093482 2111313.2017111 37.77735140937129 -122.43813603744499 (37.7773514093713, -122.438136037445)
84743 116631 2 41 5732X GEARY BLVD 12 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
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)
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)
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)
87235 117162 2 5 1383X VERMONT ST 2 8 1 1 4         6011571.0 2102081.0 37.752566033842896 -122.40286062573799 (37.7525660338429, -122.402860625738)
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)
87567 100981 3 468 2190 Powell St 2 1 1 4 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
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)
89035 100982 3 468 2190 Powell St 3 1 1 4 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
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)
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)
89354 111589 3 47 730X Lake Merced Blvd 5 7 1 10 4       Permit Number 774260 5987577.495069999 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397)
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)
90552 47255 3 2 1035 Gilman Ave 4 1 1 4 4 05/09/2002 12:00:00 AM 6 3x3 Permit Number 45198 6015368.10493708 2089617.80548286 37.71855592189279 -122.388859444456 (37.7185559218928, -122.388859444456)
92075 111588 3 47 730X Lake Merced Blvd 4 7 1 10 4   48     5987577.495069999 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397)
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)
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)
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)
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)
94262 106880 2 53 180X SAN MARCOS AVE 3 11 1 1 4   5     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
94772 98675 1 17 199X Park St 1 1 1 4 4         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
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)
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)
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)
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)
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)
96632 116628 2 41 5732X GEARY BLVD 9 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
96961 97902 2 62 375X Precita Ave 8 1 1 4 4   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
97325 97901 2 62 375X Precita Ave 7 1 1 4 4   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
97910 100983 3 16 2190 Powell St 4 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
98455 97903 2 2 375X Precita Ave 9 1 1 4 4   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
98906 116629 2 41 5732X GEARY BLVD 10 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
99549 97896 2 49 375X Precita Ave 2 1 1 4 4   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
100355 116620 2 41 5732X GEARY BLVD 1 8 1 6 4   12 3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
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)
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)
104363 24644 3 223 845 Divisadero St 1 1 1 1 4 12/17/2001 12:00:00 AM 3 3X3   6001484.9123945 2111282.0018462 37.7772613801811 -122.43839912079099 (37.7772613801811, -122.438399120791)
104559 114737 2 225 455x LILY ST 1 10 1 10 4         6004484.0 2109981.0 37.77385927942 -122.427931581119 (37.77385927942, -122.427931581119)
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)
105955 24643 3 223 801X Divisadero St 1 1 1 1 4 05/04/2010 12:00:00 AM 3 4x4   6001519.6000152 2111126.7877173 37.776837174254 -122.438268003206 (37.776837174254, -122.438268003206)
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)
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)
106746 97598 3 223 701X Divisadero St 2 1 1 1 4   3 4x3   6001578.0 2110798.0 37.7759377272515 -122.438042423333 (37.7759377272515, -122.438042423333)
106828 24629 3 223 616 Divisadero St 1 1 1 1 4 12/06/2006 12:00:00 AM 3 3x3   6001670.9205271 2110518.3359108996 37.7751751237236 -122.437700953995 (37.7751751237236, -122.437700953995)
107842 100984 3 16 2190 Powell St 5 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
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)
108016 28093 3 223 508 Divisadero St 1 1 1 1 4   3 3X3   6001722.1241568 2110151.9438084 37.7741720139963 -122.43749758605 (37.7741720139963, -122.43749758605)
108200 97586 3 223 285 Divisadero St 1 1 1 1 4   3     6001769.0 2109329.0 37.771915080469 -122.437276497302 (37.771915080469, -122.437276497302)
108228 106878 2 3 180X SAN MARCOS AVE 1 11 1 1 4   26     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
109167 97897 2 49 375X Precita Ave 3 1 1 4 4   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
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)
109229 93013 1 11 2395 Lombard St 1 1 1 1 4 01/08/2010 12:00:00 AM 3 4x4 Permit Number 53139; 3-year maintenance agreement through 12/29/12 6000915.0 2119261.0 37.7991372104515 -122.440943166878 (37.7991372104515, -122.440943166878)
109678 97597 3 223 701X Divisadero St 1 1 1 1 4   3 4x3   6001578.0 2110798.0 37.7759377272515 -122.438042423333 (37.7759377272515, -122.438042423333)
109915 109999 2 10 501X Shotwell St 16 1 1 10 4         6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
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)
111008 116626 2 20 5732X GEARY BLVD 7 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
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)
113343 116624 2 41 5732X GEARY BLVD 5 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
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)
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)
113857 97066 3 11 1599X Newcomb Ave 7 1 1 4 4   10 3x3   6015231.1 2095663.5 37.7351486000155 -122.38975506041099 (37.7351486000155, -122.389755060411)
114247 106879 2 126 180X SAN MARCOS AVE 2 11 1 1 4   6     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
114335 5184 3 223 460X Divisadero St 1 1 1 1 4 04/21/2016 12:00:00 AM 3 3x3   6001745.349517 2109984.4298688998 37.7737133829934 -122.437405247826 (37.7737133829934, -122.437405247826)
114895 116578 6 1 2699x OCEAN AVE 1 5 1 6 4   11 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
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)
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)
117253 97580 3 223 700X Divisadero St 1 1 1 1 4   3 3x3   6001615.5 2110795.9 37.7759340937147 -122.437912550894 (37.7759340937147, -122.437912550894)
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)
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)
118803 97587 3 223 319 Divisadero St 1 1 1 1 4   3     6001745.0 2109492.0 37.772361273527004 -122.437371188758 (37.772361273527, -122.437371188758)
119101 116621 2 41 5732X GEARY BLVD 2 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
119523 97603 3 223 823 Divisadero St 1 1 1 1 4   3 3x3   6001500.0 2111204.0 37.777048064939706 -122.438341338421 (37.7770480649397, -122.438341338421)
119651 97570 3 223 546 Divisadero St 1 1 1 1 4   3     6001754.3 2110345.0 37.7747039272721 -122.437400111383 (37.7747039272721, -122.437400111383)
119702 111096 1 52 67 SAINT CHARLES AVE 31 1 1 10 4   15     5992079.0 2088073.0 37.712995910736204 -122.46924723728901 (37.7129959107362, -122.469247237289)
119913 97600 3 223 857 Divisadero St 2 1 1 1 4   3 3x3   6001483.0 2111323.0 37.7773738419974 -122.43840867438801 (37.7773738419974, -122.438408674388)
119959 100985 3 18 2190 Powell St 6 1 1 4 4 03/23/2016 02:34:00 PM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
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)
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)
120634 116580 6 98 3000x 19TH AVE 3 5 2 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
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)
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)
120836 24637 3 223 425 Divisadero St 1 1 1 1 4 10/25/2011 12:00:00 AM 3 3X3   6001690.3813095 2109822.1283023 37.773264618286 -122.437583765683 (37.773264618286, -122.437583765683)
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)
121382 5205 3 127 781 Divisadero St 1 1 1 1 4 10/28/2015 07:08:00 AM 3 4X4   6001514.7755792 2111067.8471612 37.776675063930504 -122.438280468838 (37.7766750639305, -122.438280468838)
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)
121851 97594 3 223 601X Divisadero St 1 1 1 1 4   3 3x3   6001572.2 2110512.7 37.7751540352305 -122.43804204596901 (37.7751540352305, -122.438042045969)
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)
Powered by Datasette · Query took 2.213ms · Data source: data.sfgov.org