sf-trees

Data source: data.sfgov.org

Custom SQL query returning 23 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1536 251472 2 42 11 Hiliritas Ave 1 1 1 1   05/22/2017 12:00:00 AM 3 3x3 Permit Number 780012 6001589.0 2096875.0 37.7377091611847 -122.437007355935 (37.7377091611847, -122.437007355935)
6724 102771 2 42 1438 Filbert St 1 1 1 1     8 3x3   6006063.66154 2119354.00796 37.7996844799161 -122.42313363592501 (37.7996844799161, -122.423133635925)
16814 105175 2 42 1601X Newcomb Ave 4 1 1 19     10 3x3   6015153.3918 2095715.6028 37.735287354242395 -122.390027366589 (37.7352873542424, -122.390027366589)
22329 248977 2 42 748 Central Ave 2 1 1 1       3x3   5999650.0 2111146.0 37.7767834132689 -122.444736872581 (37.7767834132689, -122.444736872581)
29829 115807 2 42 742 Central Ave 1 1 1 1     10 3x3   5999623.0981 2111117.8642 37.7767046243395 -122.444827911038 (37.7767046243395, -122.444827911038)
48563 117040 2 42 2220x SUTTER ST 8 1 1 1       3x3   6001781.0 2114465.0 37.786017922595605 -122.437602866759 (37.7860179225956, -122.437602866759)
77653 109672 2 42 798x GRAFTON AVE 2 1 1 1       3x3   5994496.0 2090624.0 37.72013972186421 -122.461078132621 (37.7201397218642, -122.461078132621)
82180 120111 2 42 277 Clinton Park 1 1 1 1     1 3x3   6004952.0 2108176.0 37.7689296510264 -122.426184162815 (37.7689296510264, -122.426184162815)
86884 117033 2 42 2220x SUTTER ST 1 1 1 1       3x3   6001781.0 2114465.0 37.786017922595605 -122.437602866759 (37.7860179225956, -122.437602866759)
90165 111781 2 42 399x EUGENIA AVE 2 1 1 1     10 3x3   6006811.0 2098022.0 37.7411540008274 -122.419033684979 (37.7411540008274, -122.419033684979)
92933 120549 2 42 4098 23rd St 2 1 1 1     1 3x3   6002569.0 2102434.0 37.7530285274797 -122.434016285558 (37.7530285274797, -122.434016285558)
93774 98707 2 42 105X Ord St 1 1 1 2       3x3   6000883.6 2105740.8 37.7620124016568 -122.440081810476 (37.7620124016568, -122.440081810476)
94988 117034 2 42 2220x SUTTER ST 3 1 1 1       3x3   6001781.0 2114465.0 37.786017922595605 -122.437602866759 (37.7860179225956, -122.437602866759)
96893 105172 2 42 1601X NEWCOMB AVE 1 1 1 19     12 3x3 Permit Number 770204 6015135.0 2095759.0 37.735405494081505 -122.390093985074 (37.7354054940815, -122.390093985074)
97305 109671 2 42 798x GRAFTON AVE 1 1 1 1       3x3   5994496.0 2090624.0 37.72013972186421 -122.461078132621 (37.7201397218642, -122.461078132621)
103765 75790 2 42 2080 FOLSOM ST 5 1 1 3   03/15/1997 12:00:00 AM   3x3   6008075.0 2106289.0 37.763924410887206 -122.41524828442499 (37.7639244108872, -122.415248284425)
108628 120548 2 42 4098 23rd St 1 1 1 1     7 3x3   6002569.0 2102434.0 37.7530285274797 -122.434016285558 (37.7530285274797, -122.434016285558)
109113 99760 2 42 4247 25th St 2 1 1 1       3x3 Most likely planted/permitted with tree no. 1 on same day/permit. 6002269.0 2101186.0 37.7495847859814 -122.434964495609 (37.7495847859814, -122.434964495609)
112074 109502 2 42 2604 POST ST 1 1 1 1       3x3   5999699.0 2113674.0 37.7837274467295 -122.444749121189 (37.7837274467295, -122.444749121189)
118711 116614 2 42 299X SHOTWELL ST 1 1 1 2     10 3x3   6007772.0 2106483.0 37.7644400562771 -122.41631001514901 (37.7644400562771, -122.416310015149)
128352 117042 2 42 2220x SUTTER ST 10 1 1 1       3x3   6001781.0 2114465.0 37.786017922595605 -122.437602866759 (37.7860179225956, -122.437602866759)
129296 117035 2 42 2220x SUTTER ST 2 1 1 1       3x3   6001781.0 2114465.0 37.786017922595605 -122.437602866759 (37.7860179225956, -122.437602866759)
143492 117038 2 42 2220x SUTTER ST 6 1 1 1       3x3   6001781.0 2114465.0 37.786017922595605 -122.437602866759 (37.7860179225956, -122.437602866759)
Powered by Datasette · Query took 77.36ms · Data source: data.sfgov.org