sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
177834 100976 3 22 450X Chestnut St 8 1 1 4 4   5   Permit Number 37341 6009558.1383 2120880.7372 37.8040730797801 -122.411149322876 (37.8040730797801, -122.411149322876)
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)
171968 93015 1 79 2395 Lombard St 5 1 1 1 4 01/08/2010 12:00:00 AM 3 4x4 Permit Number 53139; 3-year maintenance agreement through 12/29/12 6001036.8533 2119267.6007 37.7991622735558 -122.440521987709 (37.7991622735558, -122.440521987709)
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)
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)
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)
147766 100979 3 22 450X Chestnut St 11 1 1 4 4   6   Permit Number 37341 6009507.0071 2120874.2443 37.8040523843138 -122.411325807727 (37.8040523843138, -122.411325807727)
145991 97568 3 223 500 Divisadero St 1 1 1 1 4   3     6001703.0 2110108.0 37.7740502679918 -122.437560592174 (37.7740502679918, -122.437560592174)
145388 100987 3 16 2190 Powell St 8 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
145311 100972 3 26 450X Chestnut St 4 1 1 4 4 03/24/2016 07:43:00 AM 3   Permit Number 37341 6009614.0 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823)
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)
144879 24627 3 223 444 Divisadero St 3 1 1 1 4 12/06/2006 12:00:00 AM 3 3X4   6001753.1685929 2109931.6605583 37.7735689361616 -122.43737442109699 (37.7735689361616, -122.437374421097)
144041 97895 2 49 375X Precita Ave 1 1 1 4 4   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
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)
142683 116623 2 41 5732X GEARY BLVD 4 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
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)
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)
141399 97582 3 223 744 Divisadero St 1 1 1 1 4   3 3x3   6001602.0 2110950.0 37.7763564458951 -122.43797029127701 (37.7763564458951, -122.437970291277)
140818 100980 3 468 2190 Powell St 1 1 1 4 4 05/03/2013 12:00:00 AM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
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)
140126 97899 2 49 375X Precita Ave 5 1 1 4 4   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
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)
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)
128369 109998 2 10 501X Shotwell St 15 1 1 10 4         6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
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)
126456 116577 6 98 3000x 19TH AVE 1 5 1 6 4   30 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
125790 116627 2 41 5732X GEARY BLVD 8 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
125523 106883 2 53 180X SAN MARCOS AVE 4 11 1 1 4   4     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
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)
124339 116630 2 41 5732X GEARY BLVD 11 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
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)
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)
123257 116622 2 41 5732X GEARY BLVD 3 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
109915 109999 2 10 501X Shotwell St 16 1 1 10 4         6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
104559 114737 2 225 455x LILY ST 1 10 1 10 4         6004484.0 2109981.0 37.77385927942 -122.427931581119 (37.77385927942, -122.427931581119)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
Powered by Datasette · Query took 2.391ms · Data source: data.sfgov.org