sf-trees

Data source: data.sfgov.org

Custom SQL query returning 23 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
31570 225166 2 99 338 Hoffman Ave 5 1 1 1     8 Width 4ft   6000619.1665199995 2101783.32951 37.7511310943237 -122.440712500502 (37.7511310943237, -122.440712500502)
34786 126022 2 99 550 Geary St 3 10 1 1     4 Width 4ft   6009023.96612 2114628.9203 37.786877155513004 -122.412555665234 (37.786877155513, -122.412555665234)
37175 126019 2 99 542 Geary St 1 10 1 1     11 Width 4ft   6009096.37686 2114637.77725 37.7869055381056 -122.412305766101 (37.7869055381056, -122.412305766101)
38579 190011 2 99 1599 Newhall St 1 4 1 1     10 Width 4ft   6014210.748430001 2095415.1555299999 37.7344100624646 -122.39326543937 (37.7344100624646, -122.39326543937)
38646 201508 2 99 1001 Innes Ave 6 9 1 1     1 Width 4ft   6018593.65925 2094901.94124 37.7332433998449 -122.378076502435 (37.7332433998449, -122.378076502435)
61557 206031 3 99 601x Monterey Blvd 11 11 1 2     7 Width 4ft   5997540.974909999 2094710.58133 37.731535267123 -122.450847236737 (37.731535267123, -122.450847236737)
63471 206034 3 99 700x Monterey Blvd 17 11 1 2     8 Width 4ft   5996882.83192 2094722.4323900002 37.731530109506295 -122.453123407313 (37.7315301095063, -122.453123407313)
70787 201506 2 99 1001 Innes Ave 4 9 1 1     1 Width 4ft   6018588.36983 2094906.5368 37.7332557268509 -122.378095108499 (37.7332557268509, -122.378095108499)
71306 206033 3 99 700x Monterey Blvd 16 11 1 2     8 Width 4ft   5996901.71225 2094723.16535 37.7315332040984 -122.453058187605 (37.7315332040984, -122.453058187605)
132078 225152 2 99 339 Elsie St 1 1 1 1     5 Width 4ft   6006495.85243 2097173.79313 37.738807262551205 -122.42006317417801 (37.7388072625512, -122.420063174178)
149483 225211 2 99 83 Tiffany Ave 1 1 1 1     17 Width 4ft   6006284.028469999 2099592.34977 37.74543613838021 -122.42096723475402 (37.7454361383802, -122.420967234754)
149755 206029 3 99 501x Monterey Blvd 8 11 1 2     7 Width 4ft   5998304.86283 2094699.93665 37.731549739012706 -122.448205573546 (37.7315497390127, -122.448205573546)
153857 201507 2 99 1001 Innes Ave 5 9 1 1     1 Width 4ft   6018590.61876 2094904.2906900002 37.733249683412296 -122.37808717738599 (37.7332496834123, -122.378087177386)
158983 206028 3 99 501x Monterey Blvd 7 11 1 2     7 Width 4ft   5998324.94212 2094699.61096 37.7315499926202 -122.448136132397 (37.7315499926202, -122.448136132397)
163945 206035 3 99 700x Monterey Blvd 18 11 1 2     6 Width 4ft   5996866.22235 2094722.0274099999 37.7315280455795 -122.453180800271 (37.7315280455795, -122.453180800271)
166097 201509 2 99 1001 Innes Ave 7 9 1 1     1 Width 4ft   6018596.778580001 2094899.20439 37.73323605689679 -122.378065528029 (37.7332360568968, -122.378065528029)
173541 206030 3 99 501x Monterey Blvd 9 11 1 2     5 Width 4ft   5998284.310380001 2094699.8261099998 37.7315482605292 -122.44827661909201 (37.7315482605292, -122.448276619092)
176930 225167 2 99 338 Hoffman Ave 6 1 1 1     7 Width 4ft   6000621.34497 2101755.16217 37.7510538776544 -122.44070294699699 (37.7510538776544, -122.440702946997)
181029 126020 2 99 550 Geary St 1 10 1 1     4 Width 4ft   6009058.631990001 2114632.0881 37.786887798972295 -122.412435952882 (37.7868877989723, -122.412435952882)
181426 201513 2 99 1001 Innes Ave 11 9 1 1     1 Width 4ft   6018634.55292 2094871.3359599998 37.7331616173072 -122.377932996723 (37.7331616173072, -122.377932996723)
188264 206032 3 99 601x Monterey Blvd 12 11 1 2     7 Width 4ft   5997524.38886 2094711.3028099998 37.7315362986421 -122.450904629644 (37.7315362986421, -122.450904629644)
188409 126023 2 99 560 Geary St 1 10 1 1     4 Width 4ft   6009008.4198 2114630.0994700002 37.7868795207321 -122.412609535497 (37.7868795207321, -122.412609535497)
188481 126021 2 99 550 Geary St 2 10 1 1     4 Width 4ft   6009038.2153900005 2114627.76765 37.7868747902962 -122.412506284359 (37.7868747902962, -122.412506284359)
Powered by Datasette · Query took 3.305ms · Data source: data.sfgov.org