sf-trees

Data source: data.sfgov.org

Custom SQL query returning 21 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
25209 196534 2 84 2221 26th St 2 1 1 1     4 Width 3ft   6011830.1521 2101342.3848900003 37.750552424667504 -122.401912510764 (37.7505524246675, -122.401912510764)
43070 234922 2 84 818 Hampshire St 1 1 1 1     12 Width 3ft   6010155.119 2104325.0374 37.758648498551004 -122.40791523902399 (37.758648498551, -122.407915239024)
44716 179166 2 84 137 University St 1 1 1 1     7 Width 3ft   6007974.04708 2093261.8498099998 37.7281490902886 -122.414675489606 (37.7281490902886, -122.414675489606)
53397 237946 2 84 923 Shotwell St 3 1 1 1     13 Width 3ft   6008002.82503 2102600.12508 37.7537915497511 -122.41523676997299 (37.7537915497511, -122.415236769973)
55882 196536 2 84 1422 Rhode Island St 1 4 1 1     10 Width 3ft   6011983.19537 2101729.68858 37.751624416549795 -122.40141048760401 (37.7516244165498, -122.401410487604)
61578 238534 2 84 671 Church St 39 7 1 1     12 Width 3ft   6004315.939809999 2105094.00544 37.7604312615151 -122.428164581928 (37.7604312615151, -122.428164581928)
66954 234918 2 84 1319 San Bruno Ave 1 1 1 1     11 Width 3ft   6011166.831619999 2102201.8831 37.75287537621829 -122.404266824377 (37.7528753762183, -122.404266824377)
68550 234921 2 84 1062 Valencia St 3 1 1 1     6 Width 3ft   6006317.5902 2103335.47216 37.7557157877704 -122.421116917936 (37.7557157877704, -122.421116917936)
70326 237949 2 84 3145 23rd St 1 1 1 1     13 Width 3ft   6008037.75868 2102668.77987 37.753982023462704 -122.41512082037599 (37.7539820234627, -122.415120820376)
74766 237971 2 84 3178 Cesar Chavez St 2 1 1 1     3 Width 3ft   6008600.41483 2100617.45628 37.748381152776396 -122.413029982045 (37.7483811527764, -122.413029982045)
116443 213700 2 84 1316 10th Ave 1 1 1 1     2 Width 3ft   5993037.4807 2106453.44522 37.76351933917171 -122.46727007765499 (37.7635193391717, -122.467270077655)
135994 234923 2 84 24 Franconia St 1 1 1 1     9 Width 3ft   6009961.80336 2099942.52208 37.7466042605945 -122.40827471331998 (37.7466042605945, -122.40827471332)
136216 237947 2 84 923 Shotwell St 5 1 1 1     17 Width 3ft   6008000.7668699995 2102633.77568 37.7538838309939 -122.415246269499 (37.7538838309939, -122.415246269499)
148635 136026 2 84 957 Sacramento St 1 10 1 1     3 Width 3ft   6010195.26054 2116841.12509 37.793017003381706 -122.408659357866 (37.7930170033817, -122.408659357866)
152021 196535 2 84 2050 20th St 1 1 1 1     3 Width 3ft   6011971.89654 2104695.5973799997 37.759767520477205 -122.401658003519 (37.7597675204772, -122.401658003519)
157664 237950 2 84 3145 23rd St 2 1 1 1     8 Width 3ft   6008062.3853 2102670.45818 37.75398801563821 -122.415035774193 (37.7539880156382, -122.415035774193)
166130 238535 2 84 118 Saint Marys Ave 2 9 1 1     10 Width 3ft   6003941.15849 2095961.17353 37.735333416189206 -122.42880968543899 (37.7353334161892, -122.428809685439)
168863 234912 2 84 266 Richland Ave 1 1 1 1     5 Width 3ft   6006193.38743 2096072.09961 37.735765211285894 -122.421030756557 (37.7357652112859, -122.421030756557)
181728 136027 2 84 957 Sacramento St 2 10 1 1     4 Width 3ft   6010215.88282 2116843.14587 37.7930237069305 -122.408588145932 (37.7930237069305, -122.408588145932)
187643 238533 2 84 2929 Harrison St 1 1 1 1     9 Width 3ft   6009029.88036 2101415.6654 37.7505969563892 -122.411601283067 (37.7505969563892, -122.411601283067)
189034 122230 2 84 700 14th Ave 1 2 1 1     6 Width 3ft   5991662.29598 2110580.8797299997 37.774772683199394 -122.472327258665 (37.7747726831994, -122.472327258665)
Powered by Datasette · Query took 3.186ms · Data source: data.sfgov.org