sf-trees

Data source: data.sfgov.org

Custom SQL query returning 22 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3279 253383 2 10 899 Waller St 5 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
5918 23710 3 10 700X Webster St 5 11 1 2     20 20   6003962.5277 2111419.0963 37.77777842285779 -122.429838035535 (37.7777784228578, -122.429838035535)
7466 23749 3 10 900X Webster St 5 1 1 2     12 4x4   6003935.7161 2111981.6282 37.779321477825704 -122.429970923277 (37.7793214778257, -122.429970923277)
7737 8094 1 10 762 Fulton St 5 1 1 19     100 3X3   6004211.6397 2111535.7715 37.7781128879326 -122.428984591665 (37.7781128879326, -122.428984591665)
21343 14358 3 10 299X Noe St 5 1 1 2     18 4X4   6002934.58534 2106677.65284 37.764701320838796 -122.43305519326599 (37.7647013208388, -122.433055193266)
27348 225835 2 10 1201 Utah St 5 1 1 1     15 Width 4ft   6010878.34698 2102482.51525 37.7536298057935 -122.40528422380899 (37.7536298057935, -122.405284223809)
39523 103291 2 10 50 Francisco St 5 1 1 1     18 3x3   6011052.07349 2121439.56361 37.8056911462811 -122.406018820613 (37.8056911462811, -122.406018820613)
46467 225824 2 10 1200 San Bruno Ave 5 1 1 1     8 Width 4ft   6011091.77167 2102559.41951 37.753852897909105 -122.404551563217 (37.7538528979091, -122.404551563217)
52261 247740 2 10 900 Waller St 5 7 1 1     22     6001271.06334 2108691.18463 37.770135479706 -122.43895317566299 (37.770135479706, -122.438953175663)
92924 14535 1 10 701X Masonic Ave 5 1 1 12     100 3X3   5999165.2663 2110445.36773 37.7748319828874 -122.446363290435 (37.7748319828874, -122.446363290435)
101917 107391 2 10 299X Noe St 5 1 1 1           6002910.362819999 2106651.2793799997 37.7646275317101 -122.433137087982 (37.7646275317101, -122.433137087982)
102315 21703 3 10 1710X Webster St 5 1 1 2     50 3x3   6003481.65409 2114822.70407 37.7870966340846 -122.431744616249 (37.7870966340846, -122.431744616249)
111363 17997 3 10 2650X Pine St 5 1 1 2     18 3X3   6001258.2893795 2114937.1034436002 37.7872844637831 -122.43944515397101 (37.7872844637831, -122.439445153971)
129233 225865 2 10 190 Coleridge St 5 1 1 1     22 Width 5ft   6006497.19455 2098745.86937 37.7431239076329 -122.420170074782 (37.7431239076329, -122.420170074782)
129349 169 3 10 185X Noe St 5 1 1 2     24 6X6   6002905.5013881 2107191.4781257 37.7661105103373 -122.433192503539 (37.7661105103373, -122.433192503539)
130986 141794 2 10 1280 WEBSTER ST 5 1 1 1     21 Width 0ft   6003796.2839 2113010.6813 37.7821391040008 -122.43052672386001 (37.7821391040008, -122.43052672386)
133476 143474 2 10 676 Pine St 5 1 1 1     17 Width 0ft   6010614.9102 2116239.469 37.791388495056204 -122.407164909629 (37.7913884950562, -122.407164909629)
147706 140251 2 10 709 Masonic Ave 5 1 1 1     26 Width 0ft   5999178.3085 2110310.1412 37.7744614302846 -122.446308445103 (37.7744614302846, -122.446308445103)
149846 139229 2 10 1401 WEBSTER ST 5 1 1 1     14 Width 0ft   6003620.1786 2113551.815 37.78361494385479 -122.43117460516198 (37.7836149438548, -122.431174605162)
157847 138433 2 10 1601 Webster St 5 1 1 1     10 Width 0ft   6003506.0814 2114378.5595 37.785878509884796 -122.431628381871 (37.7858785098848, -122.431628381871)
167366 246264 2 10 2298 Noe St 5 1 1 1     15 Width 0ft   6002930.8432 2106681.6365 37.76471204673471 -122.433068420975 (37.7647120467347, -122.433068420975)
187742 138098 2 10 1720 Webster St 5 1 1 1     17 Width 0ft   6003547.1807 2114720.4636 37.786819621724206 -122.43151060705799 (37.7868196217242, -122.431510607058)
Powered by Datasette · Query took 3.525ms · Data source: data.sfgov.org