sf-trees

Data source: data.sfgov.org

Custom SQL query returning 34 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
185708 120477 2 55 2201 Lake St 8 9 1 1     7 Width 1ft   5988623.03819 2114641.82381 37.785746527658 -122.483138270198 (37.785746527658, -122.483138270198)
182203 122137 2 55 1 15th Ave 8 9 1 1     18     5991115.84231 2114982.60549 37.786826966306 -122.47453884083001 (37.786826966306, -122.47453884083)
56238 207903 2 55 450 Wawona St 8 1 1 1     3 Width 3ft   5991490.36095 2097069.60585 37.7376643249521 -122.471937050068 (37.7376643249521, -122.471937050068)
29591 207870 2 55 1541 12th Ave 8 1 1 1     8 Width 4ft   5992427.188159999 2104766.73387 37.7588528245185 -122.469258092 (37.7588528245185, -122.469258092)
155134 207943 2 55 2300 09th Ave 8 9 1 1     3 Width 3ft   5992681.5782 2100498.78362 37.747148834263896 -122.46806784736201 (37.7471488342639, -122.468067847362)
161734 207823 2 55 298 Staples Ave 8 1 1 1     6 Width 2ft   5998174.84145 2093811.63794 37.7291032467189 -122.448591128189 (37.7291032467189, -122.448591128189)
91870 122411 6 55 499x Ocean Ave 8 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
84624 96883 1 55 2200X San Jose Ave 8 5 1 1           5998886.2 2091075.7 37.7216316467069 -122.445935216513 (37.7216316467069, -122.445935216513)
177642 177057 2 55 765 Delano Ave 8 9 1 1     6 Width 10ft   5998963.193390001 2090191.18353 37.7192073641203 -122.44560549771799 (37.7192073641203, -122.445605497718)
56715 207986 2 55 714 Detroit St 8 17 1 1     7     5999466.52885 2095410.65053 37.733567534417794 -122.444240535497 (37.7335675344178, -122.444240535497)
28430 207999 2 55 395 Joost Ave 8 9 1 1     8 Width 10ft   5999487.38528 2094945.2711599998 37.732290901786605 -122.444135000045 (37.7322909017866, -122.444135000045)
156675 177064 2 55 102 France Ave 8 9 1 1     9 Width 1ft   6001373.70465 2090220.37665 37.7194248480604 -122.437275380676 (37.7194248480604, -122.437275380676)
166567 227271 2 55 739 27th St 8 9 1 1     3 Width 7ft   6001729.3164800005 2099973.25035 37.7462242052805 -122.436743934384 (37.7462242052805, -122.436743934384)
79176 103608 1 55 100X Buchanan St 8 1 1 1     12 3x3   6004868.5 2109011.4 37.771218737852294 -122.426532477218 (37.7712187378523, -122.426532477218)
22389 23387 3 55 1661 Pine St 8 1 1 2     6 3X3   6006004.3296300005 2115544.61706 37.7892215019103 -122.423068034874 (37.7892215019103, -122.423068034874)
34937 250115 2 55 200 Austin St 8 1 1 1     4 Width 2ft   6006022.685330001 2115414.2324599996 37.788864534007296 -122.422995255427 (37.7888645340073, -122.422995255427)
154493 227258 2 55 191 Park St 8 1 1 1     18 Width 2ft   6005985.64044 2096389.9035099999 37.7366261169846 -122.421771586598 (37.7366261169846, -122.421771586598)
117184 98682 1 55 199X Park St 8 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
17503 15320 3 55 1680 Mission St 8 1 1 2   02/27/2004 12:00:00 AM 3 3X3   6006776.8374 2108697.9883 37.770465880950496 -122.419909204722 (37.7704658809505, -122.419909204722)
103689 42990 3 55 2X Yale St 8 1 1 4 2 07/05/2000 12:00:00 AM 10 5x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
169954 177129 2 55 100 Yale St 8 1 1 1     11 Width 3ft   6006955.53979 2093363.24603 37.7283702254814 -122.418203699955 (37.7283702254814, -122.418203699955)
107003 102193 2 55 3999X Folsom St 8 1 1 4 2   18 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
41598 227339 2 55 3915 Folsom St 8 1 1 1     5 Width 3ft   6008435.918269999 2096862.8615 37.738062629287796 -122.41333332967501 (37.7380626292878, -122.413333329675)
126306 70470 2 55 450X Banks St 8 1 1 4 2 06/18/1994 12:00:00 AM 3 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
28423 227193 2 55 434 Banks St 8 1 1 1     4 Width 2ft   6008555.86345 2096552.67511 37.7372176586621 -122.412896693524 (37.7372176586621, -122.412896693524)
155190 129670 2 55 2208 Powell St 8 1 1 1     9 Width 4ft   6009329.84162 2121764.6853 37.8064873745564 -122.412001868104 (37.8064873745564, -122.412001868104)
158501 129660 2 55 2135 Stockton St 8 1 1 1     6 Width 3ft   6009777.616330001 2121686.62202 37.8062981445983 -122.410446739741 (37.8062981445983, -122.410446739741)
4587 129651 1 55 2210 Stockton St 8 1 1 1   07/29/2005 12:00:00 AM 2 Width 3ft   6009800.43185 2121827.80217 37.8066870690198 -122.410377757248 (37.8066870690198, -122.410377757248)
181331 191432 2 55 2300 18th St 8 1 1 1     19     6010899.91125 2105517.41089 37.761964158640396 -122.405423368691 (37.7619641586404, -122.405423368691)
176396 226687 2 55 2300 22nd St 8 7 1 1     5     6011241.492219999 2103724.7897099997 37.757061113294704 -122.40411580209499 (37.7570611132947, -122.404115802095)
128257 113967 2 55 200 RHODE ISLAND ST 8 1 1 1       3x3   6011658.0 2107333.0 37.7669917162652 -122.40292912289699 (37.7669917162652, -122.402929122897)
34184 129681 2 55 464 California St 8 10 1 1     2 Width 4ft   6012011.03614 2116789.35281 37.7929763782966 -122.402372995143 (37.7929763782966, -122.402372995143)
179227 191458 2 55 110 Main St 8 9 1 1     16 Width 3ft   6014482.2077 2115927.0882900003 37.790746438249 -122.393762161888 (37.790746438249, -122.393762161888)
9486 6754 1 55 1215 Fairfax Ave 8 1 1 1   12/29/1992 12:00:00 AM 8 3x3   6017521.099066501 2096743.3718321999 37.7382404347673 -122.381912713319 (37.7382404347673, -122.381912713319)
Powered by Datasette · Query took 9.466ms · Data source: data.sfgov.org