sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
92954 97034 7 54 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
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)
72532 116318 2 54 1451 Hampshire St 1 1 1 3           6010547.7 2101110.8 37.749844886729996 -122.406331036849 (37.74984488673, -122.406331036849)
79036 116326 2 54 1400X Potrero Ave 6 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
80868 116284 2 54 700X Greenwich St 11 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
82559 116276 2 54 700X Greenwich St 3 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
84777 116279 2 54 700X Greenwich St 6 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
88078 116321 2 54 1400X Potrero Ave 1 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
88387 116329 2 54 1400X Potrero Ave 9 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
91482 116332 2 54 1400X Potrero Ave 12 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
92470 116283 2 54 700X Greenwich St 10 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
93124 116328 2 54 1400X Potrero Ave 8 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
94078 116333 2 54 1400X Potrero Ave 13 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
94106 116320 2 54 1451 Hampshire St 3 1 1 3           6010547.7 2101110.8 37.749844886729996 -122.406331036849 (37.74984488673, -122.406331036849)
95183 116324 2 54 1400X Potrero Ave 4 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
98178 116335 2 54 1400X Potrero Ave 15 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
98757 116282 2 54 700X Greenwich St 9 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
98945 116341 2 54 201X Bright St 2 1 1 3           5993755.0695 2088847.02637 37.715217913096104 -122.463510368547 (37.7152179130961, -122.463510368547)
99142 116319 2 54 1451 Hampshire St 2 1 1 3           6010547.7 2101110.8 37.749844886729996 -122.406331036849 (37.74984488673, -122.406331036849)
107067 116330 2 54 1400X Potrero Ave 10 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
107184 116334 2 54 1400X Potrero Ave 14 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
108927 116338 2 54 1400X Potrero Ave 18 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
112628 116325 2 54 1400X Potrero Ave 5 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
113797 116339 2 54 1400X Potrero Ave 19 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
116105 116281 2 54 700X Greenwich St 8 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
117089 116277 2 54 700X Greenwich St 4 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
118898 116327 2 54 1400X Potrero Ave 7 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
119252 116340 2 54 201X Bright St 1 1 1 3           5993755.0695 2088847.02637 37.715217913096104 -122.463510368547 (37.7152179130961, -122.463510368547)
121543 116331 2 54 1400X Potrero Ave 11 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
124407 116322 2 54 1400X Potrero Ave 2 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
125361 116323 2 54 1400X Potrero Ave 3 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
138269 116274 2 54 700X Greenwich St 1 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
138579 116278 2 54 700X Greenwich St 5 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
140188 116280 2 54 700X Greenwich St 7 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
141239 116275 2 54 700X Greenwich St 2 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
143572 116337 2 54 1400X Potrero Ave 17 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
144301 116336 2 54 1400X Potrero Ave 16 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
870 117001 3 54 1X Bernal Heights Blvd 1 7 1 2                    
1988 252845 3 54 544 Cabrillo St 1 1 1 2   03/29/2014 12:00:00 AM   3x3   5993963.0 2110797.0 37.7754989773977 -122.46438440768401 (37.7754989773977, -122.464384407684)
9914 173708 3 54 126 Gold Mine Dr 1 1 1 2       3x3   6001214.0 2098705.0 37.7427125900371 -122.438434982469 (37.7427125900371, -122.438434982469)
33065 185060 3 54 10x El Mirasol Pl 1 11 1 2     0 Width 0ft   5987413.8008 2096060.1353 37.7346558528299 -122.485957413668 (37.7346558528299, -122.485957413668)
36394 184614 3 54 3600x Noriega St 1 11 1 2     0 Width 0ft   5982812.7565 2102876.5318 37.7531025964328 -122.502368824356 (37.7531025964328, -122.502368824356)
40307 184619 3 54 3000x Noriega St 1 11 1 2     0 Width 0ft   5984675.7685 2102938.8014 37.7533828605842 -122.495930852185 (37.7533828605842, -122.495930852185)
40829 184609 3 54 3400x Noriega St 1 11 1 2     0 Width 0ft   5983436.8063 2102896.8371 37.7531949966988 -122.500212272852 (37.7531949966988, -122.500212272852)
44250 184634 3 54 4100x Noriega St 1 11 1 2     0 Width 0ft   5981271.0577 2102821.0876 37.7528596561113 -122.507696113948 (37.7528596561113, -122.507696113948)
47495 184900 3 54 3100x Noriega St 2 11 1 2     0 Width 0ft   5984148.1689 2102921.2035 37.7533036269678 -122.49775407488501 (37.7533036269678, -122.497754074885)
71149 142745 3 54 700x COLUMBUS AVE 8 11 1 2     0 Width 0ft   6009127.5357 2120116.4029 37.8019502507169 -122.412585395041 (37.8019502507169, -122.412585395041)
87071 115068 3 54 70 Coral Rd 8 1 1 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
92851 7876 3 54 1095X Franklin St 1 1 1 2   03/04/2011 12:00:00 AM 3 3x3   6006012.62101 2113826.37447 37.784504100894395 -122.42291717866101 (37.7845041008944, -122.422917178661)
98812 115061 3 54 70 Coral Rd 1 1 1 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
106237 115066 3 54 70 Coral Rd 6 1 1 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
108481 28868 3 54 75 01st St 1 1 1 2   06/11/2011 12:00:00 AM 3 3x3   6013233.2298598 2115774.102568 37.790256890180295 -122.39807285434601 (37.7902568901803, -122.398072854346)
110696 115065 3 54 70 Coral Rd 5 1 1 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
113187 115067 3 54 70 Coral Rd 7 1 1 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
115253 106460 2 54 701 Cortland Ave 3 1 1 2           6007932.0 2097222.5 37.739021812259104 -122.415101080128 (37.7390218122591, -122.415101080128)
117492 115069 3 54 70 Coral Rd 9 1 1 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
117839 106461 2 54 701 Cortland Ave 4 1 1 2           6007932.0 2097222.5 37.739021812259104 -122.415101080128 (37.7390218122591, -122.415101080128)
119022 104960 1 54 2895 San Bruno Ave   1 1 2           6011715.1 2091289.8 37.7229437265236 -122.401603910944 (37.7229437265236, -122.401603910944)
120235 115062 3 54 70 Coral Rd 2 1 1 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
125370 3826 3 54 120 Cashmere St 1 1 1 2   11/16/1992 12:00:00 AM 3 3X3   6016868.5122165 2095917.6664165 37.7359371538987 -122.384111573291 (37.7359371538987, -122.384111573291)
132958 184627 3 54 3300x Noriega St 1 11 1 2     0 Width 0ft   5983533.5949 2102898.8676 37.7532062522999 -122.499877713808 (37.7532062522999, -122.499877713808)
144770 115064 3 54 70 Coral Rd 4 1 1 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
146223 115063 3 54 70 Coral Rd 3 1 1 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
156043 184621 3 54 3100x Noriega St 1 11 1 2     0 Width 0ft   5984373.2194 2102928.6488 37.75333725996521 -122.49697636521401 (37.7533372599652, -122.496976365214)
162177 184618 3 54 3900x Noriega St 1 11 1 2     0 Width 0ft   5981674.4395 2102837.4254 37.7529282714167 -122.506302380507 (37.7529282714167, -122.506302380507)
174998 184611 3 54 3800x Noriega St 1 11 1 2     0 Width 0ft   5982199.0286 2102854.3652 37.753005653234204 -122.504489538097 (37.7530056532342, -122.504489538097)
188070 184620 3 54 3000x Noriega St 2 11 1 2     0 Width 0ft   5984460.1938 2102931.6946 37.753350719104795 -122.496675818993 (37.7533507191048, -122.496675818993)
161 142720 2 54 1170 COLUMBUS AVE 3 1 1 1       Width 0ft   6007999.4825 2121188.7351 37.8048312311886 -122.416565007078 (37.8048312311886, -122.416565007078)
443 251293 2 54 3789 Market St 1 5 2 1       3x3   6000208.0 2102740.0 37.753734455764 -122.44220302061701 (37.753734455764, -122.442203020617)
514 251312 2 54 1499 Noe St 1 1 1 1       3x3   6003369.0 2099547.0 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183)
518 251314 4 54 1108 Diamond St 1 1 1 1       3x3   6001901.0 2100825.0 37.7485726639367 -122.43621121860001 (37.7485726639367, -122.4362112186)
533 251313 4 54 390 28th St 1 1 1 1       3x3   6003369.0 2099547.0 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183)
631 251294 7 54 7126 Geary Blvd 1 16 1 1       3x3   5984860.0 2112552.0 37.779788778901796 -122.49600289252199 (37.7797887789018, -122.496002892522)
667 251356 2 54 519 22nd Ave 1 1 1 1       3x3   5989039.0 2111772.0 37.777890994652296 -122.481488924787 (37.7778909946523, -122.481488924787)
1389 251532 1 54 2100X 20th St 4 1 2 1   05/15/2017 12:00:00 AM 3 4x11            
1391 251531 1 54 2100X 20th St 2 1 2 1   05/15/2017 12:00:00 AM 3 4x11            
1410 139164 2 54 1975 POST ST 5 1 1 1       Width 0ft   6002726.0596 2114048.1262 37.784926980365206 -122.43430340574699 (37.7849269803652, -122.434303405747)
1800 251700 1 54 1560 Sanchez St 1 1 2 1   06/05/2017 12:00:00 AM 3 410x11 Permit Number 780193 6003924.0 2099150.0 37.7440882334859 -122.429096301435 (37.7440882334859, -122.429096301435)
1824 251724 1 54 1630 Clay St 1 1 1 1   06/06/2017 12:00:00 AM 3 3x3   6006933.88533 2116748.92044 37.792580631742204 -122.419937373279 (37.7925806317422, -122.419937373279)
2270 253008 1 54 1201 Tennessee St 1 1 2 1   07/10/2017 12:00:00 AM 3 11x477   6015595.17459 2103370.35297 37.756330202721 -122.389034232236 (37.756330202721, -122.389034232236)
2526 141913 2 54 900 MCALLISTER ST 13 1 1 1     0 Width 0ft   6004416.1749 2111910.2001 37.779152551854104 -122.42830372330299 (37.7791525518541, -122.428303723303)
2865 253261 1 54 339 18th Ave 1 1 1 1       3x3   5990256.0 2113097.0 37.78159976365421 -122.477375802178 (37.7815997636542, -122.477375802178)
2881 253260 1 54 734 09th Ave 1 1 1 1       3x3   5993234.0 2110465.0 37.7745453462497 -122.46688203122801 (37.7745453462497, -122.466882031228)
2900 70091 1 54 752 24th Ave 1 1 1 1 1 12/12/1992 12:00:00 AM 6 3x3   5988512.5089 2110855.81451 37.7753447787774 -122.483243045223 (37.7753447787774, -122.483243045223)
3255 253377 4 54 2 Alpine Ter 1 1 1 1       3x3   6001556.0 2108661.0 37.7700688079313 -122.43796542225 (37.7700688079313, -122.43796542225)
3275 253378 4 54 2 Alpine Ter 2 1 1 1       3x3   6001556.0 2108661.0 37.7700688079313 -122.43796542225 (37.7700688079313, -122.43796542225)
3276 149033 1 54 3916 Sacramento St 1 1 1 1   08/28/2017 12:00:00 AM 3 5.5x12   5996085.364440001 2114918.02173 37.7869363183091 -122.45734088598302 (37.7869363183091, -122.457340885983)
3345 253419 4 54 3499 Jackson St 1 1 1 1       3x3   5997570.0 2115996.0 37.78998131889129 -122.452282225129 (37.7899813188913, -122.452282225129)
3620 139511 2 54 1400 Fulton St 3 1 1 1     0 Width 0ft   6001017.0 2111110.0 37.776762480662704 -122.440005440059 (37.7767624806627, -122.440005440059)
3639 253517 1 54 559 24th Ave 2 5 2 1   09/15/2017 12:00:00 AM 3 2x4.5   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3643 253515 1 54 559 24th Ave 1 1 2 1   09/15/2017 12:00:00 AM 3 7x9.5   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3650 253518 1 54 559 24th Ave 3 5 2 1   09/15/2017 12:00:00 AM 3 2x1   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3660 253516 1 54 559 24th Ave 1 5 2 1   09/15/2017 12:00:00 AM 3 2x2   5988392.0 2112177.0 37.778965370493495 -122.483756799769 (37.7789653704935, -122.483756799769)
4723 253676 1 54 2975 Van Ness Ave 6 5 2 1   10/24/2017 12:00:00 AM 3 3.2x3.75   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
Powered by Datasette · Query took 15.519ms · Data source: data.sfgov.org