sf-trees

Data source: data.sfgov.org

Custom SQL query returning 22 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
186853 192392 2 331 500 24th St 16 9 1 1     9     6016520.58901 2102617.76076 37.754314996555706 -122.385781344253 (37.7543149965557, -122.385781344253)
181761 192393 2 331 1 24th St 25 23 1 1     3     6017132.65269 2102598.1255200002 37.7542949326738 -122.38366328523001 (37.7542949326738, -122.38366328523)
173984 225892 2 331 5300 Diamond Heights Blvd 5 10 1 1     5 Width 8ft   6001517.16924 2098900.94096 37.743267837842104 -122.437400739863 (37.7432678378421, -122.437400739863)
170586 192394 2 331 1421 Rhode Island St 2 2 1 1     6     6012026.37481 2101771.27559 37.7517410145355 -122.401264088782 (37.7517410145355, -122.401264088782)
166275 218994 2 331 2 Castenada Ave 4 2 1 1     4 Width 3ft   5994388.65472 2101822.2930799997 37.750881293236105 -122.462260931212 (37.7508812932361, -122.462260931212)
157067 218988 2 331 1510 16th Ave 2 17 1 1     1     5991201.1182 2105012.79044 37.759457505289504 -122.47351631712 (37.7594575052895, -122.47351631712)
156884 192396 2 331 1501 22nd St 22 7 1 1     6     6013303.52204 2103790.4442 37.7573563850094 -122.396989070614 (37.7573563850094, -122.396989070614)
147350 218992 2 331 2459 Funston Ave 2 1 1 1     5 Width 3ft   5992322.108580001 2098706.78417 37.742207695439504 -122.469180449024 (37.7422076954395, -122.469180449024)
137445 183283 2 331 1267 42nd Ave 1 2 1 1     2 Width 0ft   5983032.1982 2106431.7242 37.762877043639 -122.50187299213499 (37.762877043639, -122.501872992135)
80497 104013 6 331 3978 Sacramento St 1 7 1 1   07/24/2013 12:00:00 AM     Permit Number 770312 5995753.1 2114886.6 37.7868309532778 -122.45848816233601 (37.7868309532778, -122.458488162336)
73122 225894 2 331 199 Franconia St 17 23 1 1     7 Width 3ft   6010105.1921 2099680.51389 37.7458928716644 -122.407760416232 (37.7458928716644, -122.407760416232)
72705 218991 2 331 501 Victoria St 1 9 1 1     5 Width 4ft   5993231.47884 2090585.3331 37.719960702794 -122.46544631371201 (37.719960702794, -122.465446313712)
70763 218990 2 331 2 Miramar Ave 3 2 1 1     1 Width 3ft   5995344.79527 2089998.93152 37.7184722402717 -122.458098938021 (37.7184722402717, -122.458098938021)
70177 225891 2 331 511 Powhattan Ave 2 2 1 1     8     6008206.7868099995 2098146.33269 37.741573891916 -122.414216334442 (37.741573891916, -122.414216334442)
56047 192391 2 331 500 24th St 14 9 1 1     9     6016551.42962 2102620.4007599996 37.7543239520029 -122.385674872594 (37.7543239520029, -122.385674872594)
53378 176489 2 331 328 Palmetto Ave 3 9 1 1     7 Width 6ft   5993263.72067 2087255.31983 37.7108191445486 -122.465093131069 (37.7108191445486, -122.465093131069)
40167 218989 2 331 484 Faxon Ave 10 9 1 1     4 Width 3ft   5994799.41803 2091802.78128 37.7233938287444 -122.460114680245 (37.7233938287444, -122.460114680245)
39529 192395 2 331 1501 22nd St 10 7 1 1     10     6013410.28321 2103809.45902 37.7574145378755 -122.396621178649 (37.7574145378755, -122.396621178649)
37064 70204 2 331 1466 42nd Ave 1 1 1 1 1 05/14/1994 12:00:00 AM 2     5983116.0005 2105270.034 37.7596922939576 -122.501497212024 (37.7596922939576, -122.501497212024)
36315 218993 2 331 2459 Funston Ave 3 1 1 1     5 Width 3ft   5992325.084530001 2098721.0439 37.7422470209916 -122.469171196815 (37.7422470209916, -122.469171196815)
27604 225893 2 331 319 Virginia Ave 1 2 1 1     6 Width 3ft   6006908.26589 2098097.04233 37.7413655270935 -122.41870269417 (37.7413655270935, -122.41870269417)
23251 16380 3 331 1000 Moraga St 2 11 1 2     8 12   5991061.65482 2103836.24058 37.7562189332688 -122.47391280754499 (37.7562189332688, -122.473912807545)
Powered by Datasette · Query took 1.909ms · Data source: data.sfgov.org