sf-trees

Data source: data.sfgov.org

Custom SQL query returning 20 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
34009 70454 2 27 2631 44th Ave 1 1 1 1 1 06/11/1994 12:00:00 AM 1     5982726.9666 2097193.7529 37.7374942155975 -122.502244984058 (37.7374942155975, -122.502244984058)
36484 207243 2 27 324 Lakeview Ave 1 4 1 1     1 Width 3ft   5996808.75565 2089668.4523599998 37.7176488300194 -122.453014817795 (37.7176488300194, -122.453014817795)
39694 191411 2 27 462 Thornton Ave 1 9 1 1     1 Width 3ft   6012808.38143 2094403.0124599999 37.7315529172119 -122.39804293216001 (37.7315529172119, -122.39804293216)
45169 183658 2 27 1487 48th Ave 1 1 1 1     1 Width 0ft   5981219.3285 2104945.9280000003 37.7586908149842 -122.508032687607 (37.7586908149842, -122.508032687607)
52741 92437 1 27 1974 44th Ave 1 1 1 1 1 07/30/2009 12:00:00 AM 1 3x3 Permit Number 52827 5982618.164 2101679.0263 37.7498031456316 -122.502953108098 (37.7498031456316, -122.502953108098)
57295 207143 2 27 1617 16th Ave 1 1 1 1     1 Width 2ft   5991127.14012 2104370.55559 37.7576898140615 -122.473725315989 (37.7576898140615, -122.473725315989)
59000 227698 2 27 517 Hickory St 1 4 1 1     1 Width 3ft   6004312.97566 2110291.73585 37.7747028072132 -122.428545336007 (37.7747028072132, -122.428545336007)
61927 184535 2 27 1914 47th Ave 1 1 1 1     1 Width 0ft   5981673.4595 2102023.0319999997 37.7506921190217 -122.506245385817 (37.7506921190217, -122.506245385817)
62758 207140 2 27 1682 17th Ave 1 1 1 1     1 Width 3ft   5990920.30999 2103955.3917900003 37.7565379030086 -122.474410316087 (37.7565379030086, -122.474410316087)
73076 207146 2 27 1440 16th Ave 1 2 1 1     1 Width 4ft   5991174.2447 2105585.9909099997 37.7610298052998 -122.47365107156601 (37.7610298052998, -122.473651071566)
73666 184518 2 27 4108 Pacheco St 1 1 1 1     1 Width 0ft   5982209.6889 2101522.5062 37.7493493689338 -122.504354014902 (37.7493493689338, -122.504354014902)
134189 226586 2 27 195 Lexington St 1 1 1 1     1 Width 3ft   6006490.36158 2105010.39 37.760324461620705 -122.420638312212 (37.7603244616207, -122.420638312212)
136966 207147 2 27 1341 12th Ave 1 1 1 1     1 Width 2ft   5992375.35662 2106303.37048 37.7630690288235 -122.469549207953 (37.7630690288235, -122.469549207953)
137436 177005 2 27 362 Arleta Ave 1 1 1 1     1 Width 3ft   6009172.07817 2088408.58756 37.714890285531794 -122.410191328669 (37.7148902855318, -122.410191328669)
163723 207169 2 27 526 Judson Ave 1 1 1 1     1 Width 2ft   5996886.48859 2093636.72948 37.728549238251205 -122.453032422917 (37.7285492382512, -122.453032422917)
177051 207148 2 27 1210 12th Ave 1 1 1 1     1 Width 4ft   5992391.03537 2107185.15973 37.7654910946525 -122.469559175111 (37.7654910946525, -122.469559175111)
177917 177001 2 27 154 Gillette Ave 1 1 1 1     1 Width 3ft   6013011.29164 2086676.67622 37.7103492505861 -122.396799956671 (37.7103492505861, -122.396799956671)
185161 183715 2 27 1226 39th Ave 1 1 1 1     1 Width 0ft   5983995.5254 2106803.3357 37.7639539248956 -122.49856868241899 (37.7639539248956, -122.498568682419)
186733 226608 2 27 1035 Shrader St 1 1 1 1     1 Width 3ft   5997646.28955 2106916.84179 37.765056684330794 -122.451363177783 (37.7650566843308, -122.451363177783)
186756 182869 2 27 1847 26th Ave 1 2 1 1     1 Width 0ft   5988126.7611 2102732.0567 37.753016709320995 -122.48398158304701 (37.753016709321, -122.483981583047)
Powered by Datasette · Query took 6.421ms · Data source: data.sfgov.org