sf-trees

Data source: data.sfgov.org

Custom SQL query returning 20 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
22043 859 3 42 400X Alemany Blvd 5 1 1 2     16 3x3   6008091.178180001 2095049.40427 37.7330639095777 -122.41439699202299 (37.7330639095777, -122.414396992023)
30672 220054 2 42 300 Virginia Ave 5 2 1 1     6 Width 3ft   6006920.61613 2098340.82095 37.742035584087795 -122.418677274846 (37.7420355840878, -122.418677274846)
30832 203666 2 42 123 Detroit St 5 1 1 1     9 Width 2ft   5999405.93855 2093561.74161 37.728487406244604 -122.44431719010001 (37.7284874062446, -122.4443171901)
49836 103888 1 42 1750 Fulton St 5 1 1 1     11 3x3   5999371.6507 2110859.3099 37.775980347483504 -122.44567914075701 (37.7759803474835, -122.445679140757)
53857 220052 2 42 50 Coleridge St 5 1 1 1     5 Width 3ft   6006851.995619999 2099403.94647 37.7449508246175 -122.418989930439 (37.7449508246175, -122.418989930439)
65727 19285 3 42 1770 Scott St 5 1 1 2   06/01/1998 12:00:00 AM 11 3X3   6001619.01622 2114490.46983 37.786078645055 -122.43816511087601 (37.786078645055, -122.438165110876)
70197 138347 2 42 1770 SCOTT ST 5 1 1 1     11 Width 0ft   6001586.1357 2114554.9139 37.786253721877706 -122.438283486898 (37.7862537218777, -122.438283486898)
78530 42106 1 42 305 Hearst Ave 5 1 1 1 1 06/21/2000 12:00:00 AM     Permit Number 42409 5999382.77994639 2094344.80390055 37.730636191213996 -122.444453504412 (37.730636191214, -122.444453504412)
81412 39503 1 42 216 Jersey St 5 1 1 1 1 12/28/1998 12:00:00 AM     Permit Number 40959 6003716.05884842 2101601.85489178 37.7508086831914 -122.42999018002399 (37.7508086831914, -122.429990180024)
90886 42110 1 42 100@ Detroit Judson Ave 5 1 1 1 1 06/21/2000 12:00:00 AM     Permit Number 42411 5999403.96940848 2093509.81726433 37.7283447217324 -122.444320267584 (37.7283447217324, -122.444320267584)
103765 75790 2 42 2080 FOLSOM ST 5 1 1 3   03/15/1997 12:00:00 AM   3x3   6008075.0 2106289.0 37.763924410887206 -122.41524828442499 (37.7639244108872, -122.415248284425)
107521 49582 1 42 400REVISED Alemany Blvd 5 1 1 1   05/29/2003 12:00:00 AM     Permit Number 46462 6008204.64175087 2095122.01632245 37.7332696598424 -122.414009852171 (37.7332696598424, -122.414009852171)
107814 23676 3 42 319 Virginia Ave 5 11 1 2     6 12   6006936.2458165 2098250.5638735 37.741788638281996 -122.418616833275 (37.741788638282, -122.418616833275)
107835 32345 1 42 1201 35th Ave 5 1 1 1 1 10/23/1996 12:00:00 AM     Permit Number 37068 5985179.95256355 2107022.76154853 37.7646257968319 -122.494488338591 (37.7646257968319, -122.494488338591)
112271 50471 1 42 3010X Lyon St 5 1 1 1   10/21/2003 12:00:00 AM 5 3x3 Permit Number 47106 5999184.20401146 2119093.85477845 37.798579545974704 -122.446920252577 (37.7985795459747, -122.446920252577)
140001 50664 1 42 1 Santa Ynez Ave 5 1 1 1         Permit Number 47244 6000978.87890111 2091807.60057831 37.723760552916296 -122.43875382021002 (37.7237605529163, -122.43875382021)
150574 138352 2 42 2499 Bush St 5 1 1 1     4 Width 0ft   6001715.4366 2114603.3734 37.78639413258121 -122.437839612353 (37.7863941325812, -122.437839612353)
166995 203640 2 42 216 Ralston St 5 9 1 1     13 Width 5ft   5992221.60329 2089317.4306299998 37.7164210557753 -122.468844858002 (37.7164210557753, -122.468844858002)
184876 203227 2 42 1575 07th Ave 5 1 1 1     10 Width 2ft   5993976.11047 2104705.81134 37.7587749306244 -122.463896818706 (37.7587749306244, -122.463896818706)
188982 220022 2 42 1334 Diamond St 5 1 1 1     8 Width 3ft   6001965.3710900005 2100066.86744 37.746494668288996 -122.435934385359 (37.746494668289, -122.435934385359)
Powered by Datasette · Query took 4.602ms · Data source: data.sfgov.org