sf-trees

Data source: data.sfgov.org

Custom SQL query returning 21 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
125814 48046 1 94 3350 Mission St 6 1 1 1   07/11/2002 12:00:00 AM     Permit Number 45759 6006080.4837518 2098740.43590211 37.7430854999808 -122.42161056574 (37.7430854999808, -122.42161056574)
50977 224616 2 94 525 Burnett Ave 6 1 1 1     8 Width 2ft   5999502.23945 2102489.21916 37.7530056250346 -122.444625668335 (37.7530056250346, -122.444625668335)
64271 184317 2 94 1557 39th Ave 6 1 1 1     8 Width 0ft   5984033.1876 2104377.9194 37.7572966221146 -122.49825927742901 (37.7572966221146, -122.498259277429)
155626 224542 2 94 2925 21st St 6 1 1 1     13 Width 3ft   6008789.37213 2103883.03365 37.7573582996747 -122.412607384336 (37.7573582996747, -122.412607384336)
168974 224551 2 94 3381 20th St 6 1 1 1     15 Width 3ft   6007716.60877 2104410.35168 37.7587459283935 -122.416354782871 (37.7587459283935, -122.416354782871)
74404 226477 2 94 3160 19th St 6 1 1 1     16 Width 3ft   6008318.01409 2105071.04935 37.7605938535523 -122.414321587482 (37.7605938535523, -122.414321587482)
42815 226473 2 94 3101 19th St 6 1 1 1     14 Width 3ft   6008617.67732 2105085.24659 37.7606496645635 -122.413286189004 (37.7606496645635, -122.413286189004)
175419 224660 2 94 602 Alabama St 6 1 1 1     17 Width 3ft   6008966.9840400005 2105222.67226 37.761046609131895 -122.41208780281 (37.7610466091319, -122.41208780281)
2216 122752 3 94 693 Vermont St 6 1 1 4 2   18     6011278.80569 2105286.3398 37.7613508668666 -122.404096651066 (37.7613508668666, -122.404096651066)
89159 116393 2 94 2701 16TH ST 6 1 1 1       3x3   6008575.9 2106772.6 37.7652804030783 -122.413550020856 (37.7652804030783, -122.413550020856)
33348 224580 2 94 2701 16th St 6 1 1 1     18 Width 3ft   6008616.559830001 2106802.76672 37.765365516923396 -122.413411521233 (37.7653655169234, -122.413411521233)
106354 115030 3 94 1009 HARRISON ST 6 1 1 2       3x10   6011058.0 2110680.0 37.776148288994705 -122.405240157274 (37.7761482889947, -122.405240157274)
80869 30892 1 94 412 Hayes St 6 1 1 1   03/08/1995 12:00:00 AM     Permit Number 34719 6005865.19335847 2111068.58127823 37.7769235557198 -122.423231126893 (37.7769235557198, -122.423231126893)
81439 39879 1 94 301 Bryant St 6 1 1 1   01/21/1999 12:00:00 AM     Permit Number 41173 6015620.67363669 2114221.43610992 37.786126305998 -122.389703911477 (37.786126305998, -122.389703911477)
40147 250314 2 94 3828 Jackson St 6 1 1 1     4 Width 3ft   5995896.25125 2115871.75264 37.789544142705395 -122.45806421881201 (37.7895441427054, -122.458064218812)
87598 101431 2 94 2501X Buchanan St 6 1 1 1       3x3   6003643.1 2116935.1 37.7929058867978 -122.431336896261 (37.7929058867978, -122.431336896261)
102524 34150 1 94 30 Steuart St 6 1 1 1   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.794049371853106 -122.394334961669 (37.7940493718531, -122.394334961669)
116935 84930 1 94 1500@Polk Broadway 6 1 1 1           6006413.8 2117997.6 37.795979878671 -122.421825625767 (37.795979878671, -122.421825625767)
173926 126630 3 94 350x Washington St 6 3 1 2     9 Width 8ft   6013712.21512 2118015.33042 37.7964374416781 -122.396572761821 (37.7964374416781, -122.396572761821)
158006 126625 2 94 1445 Sansome St 6 1 1 1     17 Width 3ft   6011819.79643 2120570.04508 37.8033465696629 -122.40330078161101 (37.8033465696629, -122.403300781611)
135535 126618 2 94 3301 Van Ness Ave 6 4 1 1     15 Width 3ft   6005157.457169999 2122152.06561 37.8073160440754 -122.426468777106 (37.8073160440754, -122.426468777106)
Powered by Datasette · Query took 6.357ms · Data source: data.sfgov.org