sf-trees

Data source: data.sfgov.org

Custom SQL query returning 35 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
144563 35559 1 42 801 Guerrero St 2 1 1 1 1 03/23/1998 12:00:00 AM     Permit Number 38931 6005679.14966284 2104317.39620731 37.7583759105796 -122.423394653078 (37.7583759105796, -122.423394653078)
144588 36580 1 42 2970 26th St 2 1 1 1 1 05/20/1998 12:00:00 AM     Permit Number 39441 6009675.57743886 2101054.36494821 37.7496411039984 -122.40934290688699 (37.7496411039984, -122.409342906887)
144602 43706 1 42 503 Capitol Ave 2 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43349 5995017.92037976 2088722.8136211003 37.7149495354327 -122.459136447344 (37.7149495354327, -122.459136447344)
145663 50449 1 42 1418 Waller St 2 1 1 1   10/21/2003 12:00:00 AM     Permit Number 47096 5998923.01373461 2108365.57348999 37.7691075589972 -122.44705158673901 (37.7691075589972, -122.447051586739)
149037 70299 2 42 237 Theresa St 2 1 1 1 1 08/27/1994 12:00:00 AM 9     6001826.3531599995 2094025.88285 37.7298996296434 -122.435982902906 (37.7298996296434, -122.435982902906)
152034 124751 2 42 566 Linden St 2 1 1 1     5 Width 3ft   6004689.62752 2110692.77739 37.775825277144705 -122.427270993988 (37.7758252771447, -122.427270993988)
154005 248396 2 42 1655 Waller St 2 1 1 1     7 Width 0ft   5997671.1383 2108143.749 37.768426881635605 -122.45136572862499 (37.7684268816356, -122.451365728625)
156262 140103 2 42 1720 FULTON ST 2 1 1 1     9 Width 0ft   5999438.9967 2110868.4473 37.776009281241 -122.44544683133002 (37.776009281241, -122.44544683133)
156503 174960 2 42 103 De Long St 2 2 1 1     6 Width 10ft   5994409.5991400005 2086788.1181299998 37.709602327657706 -122.461098897396 (37.7096023276577, -122.461098897396)
157543 139098 2 42 2600 POST ST 2 1 1 1     8 Width 0ft   5999639.9141 2113670.3506 37.7837140544374 -122.44495327295601 (37.7837140544374, -122.444953272956)
157925 203650 2 42 1390 Monterey Blvd 2 9 1 1     11 Width 3ft   5993848.38247 2094813.0241599998 37.7316044735649 -122.46362057664699 (37.7316044735649, -122.463620576647)
158134 203631 2 42 1400 Monterey Blvd 2 9 1 1     11 Width 10ft   5993837.01835 2094842.09298 37.7316836345786 -122.46366197331801 (37.7316836345786, -122.463661973318)
159913 138338 2 42 2250 Sutter St 2 1 1 1     6 Width 0ft   6001931.2408 2114335.4048 37.7856706283151 -122.437073793387 (37.7856706283151, -122.437073793387)
159982 220096 2 42 5 Penny Ln 2 13 1 1     4 Width 2ft   6002436.28409 2096397.8300700001 37.736447085360105 -122.43404379100402 (37.7364470853601, -122.434043791004)
162065 220000 2 42 62 Santa Marina St 2 1 1 1     8 Width 3ft   6006013.90538 2097631.08265 37.7400357112669 -122.421761996217 (37.7400357112669, -122.421761996217)
162378 220679 2 42 3607 20th St 2 1 1 1     5 Width 3ft   6006165.33609 2104321.13003 37.758413591125205 -122.421713467922 (37.7584135911252, -122.421713467922)
162565 203221 2 42 2398 12th Ave 2 1 1 1     14 Width 4ft   5992664.0139 2099193.92326 37.7435650062179 -122.468033683007 (37.7435650062179, -122.468033683007)
164961 138533 2 42 2299 SUTTER ST 2 1 1 1     5 Width 0ft   6001645.5525 2114240.3384 37.7853933573613 -122.438055378776 (37.7853933573613, -122.438055378776)
167885 220009 2 42 3447 25th St 2 1 1 1     7 Width 3ft   6006820.56616 2101433.2332200003 37.750521016743896 -122.419242531131 (37.7505210167439, -122.419242531131)
168067 38049 1 42 2700 Bush St 2 1 1 1 1 01/11/2005 12:00:00 AM 9   Permit Number 47797 6000509.1373 2114490.0048 37.78601418351771 -122.44200495026199 (37.7860141835177, -122.442004950262)
168971 220018 2 42 1129 Douglass St 2 9 1 1     4 Width 6ft   6001364.34858 2100418.37342 37.7474256590636 -122.43803782498999 (37.7474256590636, -122.43803782499)
171409 124759 2 42 2534 Polk St 2 1 1 1     10 Width 2ft   6006240.40404 2119512.60207 37.800129911416704 -122.42253331686199 (37.8001299114167, -122.422533316862)
171522 220055 2 42 32 Elsie St 2 1 1 1     7 Width 3ft   6007497.36019 2099175.1634299997 37.7443589574154 -122.416742166726 (37.7443589574154, -122.416742166726)
173115 203638 2 42 750 Grafton Ave 2 1 1 1     12 Width 3ft   5994537.11563 2090599.0913099998 37.720073694513104 -122.46093420637101 (37.7200736945131, -122.460934206371)
173572 245839 2 42 423 Laguna St 2 1 1 1     5 Width 0ft   6005015.8911 2110507.8578 37.775335978986796 -122.4261291969 (37.7753359789868, -122.4261291969)
176496 75331 2 42 101 De Long St 2 1 1 1 1 09/30/1995 12:00:00 AM 6     5994458.53323 2086786.7483599999 37.709601382461294 -122.460929674682 (37.7096013824613, -122.460929674682)
179662 203222 2 42 120 Taraval St 2 1 1 1     12 Width 3ft   5993081.79545 2099194.6713799997 37.7435911783029 -122.466589164064 (37.7435911783029, -122.466589164064)
180473 40818 1 42 1770 Scott St 2 1 1 1   08/26/1999 12:00:00 AM 9   Permit Number 41760 6001596.2583 2114468.8718 37.786018048063 -122.438242299207 (37.786018048063, -122.438242299207)
181456 50381 1 42 1330 Greenwich St 2 1 1 1   10/23/2003 12:00:00 AM 6 3x3 Permit Number 47040 6006481.85746 2119759.67415 37.8008219271496 -122.42171535199499 (37.8008219271496, -122.421715351995)
183618 220682 2 42 1624 Florida St 2 1 1 1     6 Width 3ft   6009643.101369999 2100250.00573 37.7474306916674 -122.40939845218 (37.7474306916674, -122.40939845218)
185093 220033 2 42 502 28th St 2 10 1 1     12     6002622.25428 2099488.24408 37.7449431983695 -122.433621612357 (37.7449431983695, -122.433621612357)
185200 220017 2 42 78 Berkeley Way 2 1 1 1     9 Width 3ft   6001185.230140001 2097348.08527 37.7389851844145 -122.438437264296 (37.7389851844145, -122.438437264296)
185398 220685 2 42 452 Hickory St 2 1 1 1     11 Width 2ft   6004772.24556 2110355.93232 37.774905054848396 -122.426961200922 (37.7749050548484, -122.426961200922)
186993 44745 1 42 1520 Pacific Ave 2 1 1 1   04/04/2001 12:00:00 AM 8   Permit Number 43862 6006829.6851 2117719.85237 37.7952406976494 -122.42036685635401 (37.7952406976494, -122.420366856354)
187340 220676 2 42 3681 20th St 2 1 1 1     7 Width 3ft   6005782.66085 2104298.9799099998 37.7583311853523 -122.423035356192 (37.7583311853523, -122.423035356192)
Powered by Datasette · Query took 3.985ms · Data source: data.sfgov.org