sf-trees

Data source: data.sfgov.org

Custom SQL query returning 26 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1153 17806 3 36 1881 Pine St 1 1 1 2     24 3x3   6004903.5356 2115394.9801 37.7887484569995 -122.42686598915199 (37.7887484569995, -122.426865989152)
5348 26872 3 36 969 Hayes St 1 1 1 2     18 3x3   6003227.2163 2110650.5623 37.7756265519671 -122.432326827371 (37.7756265519671, -122.432326827371)
7223 10658 3 36 957 Hayes St 1 1 1 2   12/14/2007 12:00:00 AM 3 3x3   6003278.1745 2110658.3168 37.7756507331964 -122.43215110447599 (37.7756507331964, -122.432151104476)
7523 87408 3 36 2400X Van Ness Ave 2 11 1 2   04/18/2008 12:00:00 AM 3 3x3   6005843.02152 2118712.53051 37.7979106921903 -122.42385149366501 (37.7979106921903, -122.423851493665)
7779 10661 3 36 958 Hayes St 1 1 1 2     24 3x3   6003257.9574 2110699.3049 37.7757621301077 -122.432223968227 (37.7757621301077, -122.432223968227)
13610 11963 3 36 1009X Mendell St 1 1 1 2     18 3x3   6015687.60896 2096283.0567700001 37.736875081728705 -122.38821995489599 (37.7368750817287, -122.388219954896)
17352 16120 3 36 303 Monterey Blvd 1 1 1 2     18 3x3   6000032.3049 2094633.40383 37.7314656586952 -122.44222871430401 (37.7314656586952, -122.442228714304)
18348 16020 3 36 107 Monterey Blvd 1 1 1 2     18 3x3   6001336.16248 2094611.17288 37.731478841871706 -122.437719447913 (37.7314788418717, -122.437719447913)
19295 5760 3 36 398 Duboce Ave 2 1 1 2     36 3x3   6003950.51884 2108401.53413 37.7694922566853 -122.42966430666999 (37.7694922566853, -122.42966430667)
19540 4835 3 36 115 Cortland Ave 1 1 1 2     24 3x3   6006362.63783 2097667.32197 37.7401548759573 -122.420558792379 (37.7401548759573, -122.420558792379)
20001 4839 3 36 135 Cortland Ave 1 1 1 2     18 3x3   6006426.94909 2097635.5595299997 37.7400712875725 -122.42033417588699 (37.7400712875725, -122.420334175887)
20112 29963 3 36 500X Junipero Serra Blvd 6 11 1 2   03/09/2013 12:00:00 AM 3 3x3   5991394.8537099995 2093447.95886 37.7277146673841 -122.47200336878099 (37.7277146673841, -122.472003368781)
21443 4396 3 36 1005 Church St 1 1 1 2     12 3x3   6004431.4266800005 2103008.65854 37.754711924921295 -122.427616590837 (37.7547119249213, -122.427616590837)
21637 4817 3 36 51 Cortland Ave 1 1 1 2     12 3x3   6005995.99863 2097868.77885 37.7406873618291 -122.42184079032499 (37.7406873618291, -122.421840790325)
21650 1996 3 36 175 Bocana St 1 1 1 2     40 3x3   6007331.5108 2098053.7261799998 37.741270411207296 -122.41723618861201 (37.7412704112073, -122.417236188612)
21993 16119 3 36 301 Monterey Blvd 1 1 1 2     18 3x3   6000050.07874 2094632.71852 37.7314647899581 -122.442167217764 (37.7314647899581, -122.442167217764)
22519 17782 3 36 1791 Pine St 3 1 1 2     24 3x3   6005428.2033400005 2115468.32597 37.788979497959296 -122.425055933202 (37.7889794979593, -122.425055933202)
37403 11269 3 36 1176X Ingalls St 8 1 1 2   04/03/1990 12:00:00 AM 3 3x3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
91987 11505 3 36 100 Jennings St 19 1 1 2     18 3x3   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
97379 15039 3 36 1017 Mendell St 1 1 1 2     18 3x3   6015648.596419999 2096190.1744099997 37.736617883929604 -122.388348358907 (37.7366178839296, -122.388348358907)
101721 18107 3 36 3067 Pine St 1 1 1 2     28 3x3   5999321.271546599 2114616.8679369 37.7862947536085 -122.446123757059 (37.7862947536085, -122.446123757059)
109749 5761 3 36 400 DUBOCE AVE 4 1 1 2     18 3x3   6003934.4 2108512.1 37.7697949309592 -122.429727948184 (37.7697949309592, -122.429727948184)
109965 6122 3 36 199X Elk St 6 1 1 2     18 3x3   6000815.0314327 2096222.3312360002 37.7358730629277 -122.439636554407 (37.7358730629277, -122.439636554407)
123191 11510 3 36 100 Jennings St 24 1 1 2     12 3x3   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
123575 11966 3 36 1009X Mendell St 4 1 1 2     12 3x3   6015728.77645 2096327.58352 37.736999624078 -122.38808072579599 (37.736999624078, -122.388080725796)
140133 12381 3 36 1435 Laguna St 2 1 1 2     18 3x3   6004345.46385 2113763.0093400003 37.7842359045501 -122.42868045552099 (37.7842359045501, -122.428680455521)
Powered by Datasette · Query took 32.776ms · Data source: data.sfgov.org