sf-trees

Data source: data.sfgov.org

Custom SQL query returning 19 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2099 200057 2 45 1898x Lane St 5 1 1 1     1 Width 0ft   6014825.8229 2094079.4071 37.7307765200208 -122.39104557773999 (37.7307765200208, -122.39104557774)
25288 136307 2 45 1110 Jones St 5 1 1 1     6 Width 3ft   6008614.233080001 2116420.22843 37.7917726483359 -122.41410002782 (37.7917726483359, -122.41410002782)
29920 240423 2 45 5 Penny Ln 5 13 1 1     2 Width 2ft   6002449.92079 2096381.9214299999 37.7364041778047 -122.433995506402 (37.7364041778047, -122.433995506402)
30089 122281 2 45 1750 Balboa St 5 9 1 1     1 Width 3ft   5990111.6262 2111320.57885 37.7767138255075 -122.477745368245 (37.7767138255075, -122.477745368245)
38193 246761 2 45 70 Waltham St 5 7 1 1     16     6009235.422669999 2098888.8268 37.7436703438078 -122.410712070303 (37.7436703438078, -122.410712070303)
40581 214021 2 45 75 Fairfield Way 5 1 1 1     2 Width 2ft   5993799.03412 2093427.92907 37.727798498601295 -122.463690690492 (37.7277984986013, -122.463690690492)
47391 197344 2 45 670 Howard St 5 1 1 1     5 Width 4ft   6012519.5716699995 2113947.09446 37.785200579973605 -122.40041369075199 (37.7852005799736, -122.400413690752)
84570 48905 1 45 2200X Clay St 5 1 1 1   11/22/2002 12:00:00 AM     Permit Number 46105 6004224.6625681 2116191.17070072 37.790896187279394 -122.42927158905898 (37.7908961872794, -122.429271589059)
86977 122462 1 45 1351 42nd Ave 5 1 1 1 1         5983044.58583163 2105938.11904156 37.7615224717284 -122.501793626008 (37.7615224717284, -122.501793626008)
92893 37976 1 45 1199 Tennessee St 5 1 1 1 1 11/06/1998 12:00:00 AM     Permit Number 40204 6015599.59779117 2103398.4652457 37.756407638243296 -122.38902089785499 (37.7564076382433, -122.389020897855)
98390 11347 3 45 1300X Ingalls St 5 1 1 2   06/06/1997 12:00:00 AM 18 3X3   6017347.6886145 2093992.5867035 37.730677746775605 -122.382320962891 (37.7306777467756, -122.382320962891)
111937 87074 1 45 395 Byxbee St 5 8 1 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
114842 41747 1 45 1100 California St 5 1 1 1 1 06/19/2000 12:00:00 AM     Permit Number 42181 6009068.76416013 2116381.28511649 37.7916912386009 -122.41252459171899 (37.7916912386009, -122.412524591719)
124237 38635 1 45 1595 Shafter Ave 5 1 1 1 1 08/16/2011 12:00:00 AM   33 Permit Number 767658 6014940.81298911 2094124.48881728 37.7309066855794 -122.390651184611 (37.7309066855794, -122.390651184611)
125174 53143 1 45 1498@ KEITH Underwood Ave 5 1 1 1 1 11/02/2006 12:00:00 AM     Permit Number 49074 6015150.01654287 2093336.52012549 37.7287546860169 -122.389872907792 (37.7287546860169, -122.389872907792)
128204 41769 1 45 1320-1360 Lombard St 5 1 1 1   06/19/2000 12:00:00 AM   3x3 Permit Number 42186 6006041.0 2120044.0 37.8015777435459 -122.423261128156 (37.8015777435459, -122.423261128156)
138246 197352 2 45 1240 Ingalls St 5 1 1 1     6 Width 3ft   6017442.65456 2093993.31463 37.7306849905143 -122.381992698304 (37.7306849905143, -122.381992698304)
168253 240399 2 45 1636 Diamond St 5 9 1 1     1 Width 8ft   6002005.77197 2099212.90242 37.7441521762959 -122.43573359642201 (37.7441521762959, -122.435733596422)
182997 184434 2 45 3816 Quintara St 5 1 1 1     1 Width 0ft   5981590.8846 2100821.8038 37.7473890220179 -122.506441860059 (37.7473890220179, -122.506441860059)
Powered by Datasette · Query took 56.119ms · Data source: data.sfgov.org