sf-trees

Data source: data.sfgov.org

Custom SQL query returning 46 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
519 6766 3 8 1275 Fairfax Ave 11 1 1 2   04/10/2017 01:39:00 PM 3 3x3   6017299.75412 2096896.40625 37.7386484107882 -122.38268866835199 (37.7386484107882, -122.382688668352)
1173 190143 3 8 1200 Fairfax Ave 7 4 1 2   03/18/2017 10:47:00 AM 3 Width 4ft   6017523.521480001 2096815.65975 37.738439056714704 -122.381909364434 (37.7384390567147, -122.381909364434)
1275 4132 1 8 3550 Cesar Chavez St 3 1 1 2   05/09/2017 12:00:00 AM 3 3x3   6006390.9849 2100603.33536 37.7482181038931 -122.420669151754 (37.7482181038931, -122.420669151754)
1276 229197 2 8 3186 Cesar Chavez St 1 1 1 2     1 4x4   6008575.05448 2100617.97477 37.7483811527748 -122.41311771451599 (37.7483811527748, -122.413117714516)
1278 231178 2 8 3298 Cesar Chavez St 1 1 1 2   05/09/2017 12:00:00 AM 3 3x6   6007881.72523 2100615.5936 37.7483356677609 -122.41551506969101 (37.7483356677609, -122.415515069691)
1280 231193 2 8 3400 Cesar Chavez St 2 1 1 2   05/09/2017 12:00:00 AM 3 3x6   6007038.27508 2100609.92371 37.7482726540762 -122.41843130396799 (37.7482726540762, -122.418431303968)
1281 231175 2 8 3100 Cesar Chavez St 1 1 1 2   05/09/2017 12:00:00 AM 3 4x4   6008989.553669999 2100618.8922900003 37.7484069327314 -122.41168444520599 (37.7484069327314, -122.411684445206)
1296 231177 2 8 3200 Cesar Chavez St 2 1 1 2     3 Width 3ft   6008330.40398 2100615.02413 37.7483593136265 -122.41396350442 (37.7483593136265, -122.41396350442)
1302 4080 3 8 3200X Cesar Chavez St 4 1 1 2   05/09/2017 12:00:00 AM 3 3X6   6008284.97439 2100614.30528 37.7483547882437 -122.414120548517 (37.7483547882437, -122.414120548517)
1304 231176 2 8 3100 Cesar Chavez St 2 1 1 2     3 4x4   6008965.15097 2100617.87341 37.7484027661782 -122.411768757547 (37.7484027661782, -122.411768757547)
1308 231174 2 8 3092 Cesar Chavez St 1 1 1 2     3 Width 3ft   6009165.99895 2100621.73745 37.7484246412851 -122.411074499805 (37.7484246412851, -122.411074499805)
17477 4067 3 8 3096 Cesar Chavez St 1 1 1 2   04/01/1995 12:00:00 AM 3 3X3   6009129.76815 2100619.82183 37.7484173495801 -122.411199650344 (37.7484173495801, -122.411199650344)
17922 26420 3 8 1492 Dolores St 1 1 1 2     20 3X3   6005205.18394 2099681.3110700003 37.7456195335093 -122.424704037463 (37.7456195335093, -122.424704037463)
19317 4117 3 8 3425 Cesar Chavez St 2 1 1 2   04/01/1995 12:00:00 AM 12 3X3   6006587.39221 2100520.66079 37.7480021658686 -122.419984113875 (37.7480021658686, -122.419984113875)
20218 4065 3 8 3075 Cesar Chavez St 1 1 1 2     12 3x3   6009147.76851 2100538.02687 37.748193768248704 -122.411131628336 (37.7481937682487, -122.411131628336)
20537 4114 3 8 3405 Cesar Chavez St 1 1 1 2     12 3X3   6006963.52964 2100524.30588 37.7480333588561 -122.418683701415 (37.7480333588561, -122.418683701415)
20947 4116 3 8 3425 Cesar Chavez St 1 1 1 2   04/01/1995 12:00:00 AM 12 3X3   6006570.52935 2100520.79948 37.7480015966124 -122.420042434916 (37.7480015966124, -122.420042434916)
21510 4053 3 8 2934 Cesar Chavez St 1 1 1 2   08/02/2016 12:00:00 AM 1 3X3   6009951.6651099995 2100626.39211 37.74848144967 -122.40835799863999 (37.74848144967, -122.40835799864)
21690 4077 3 8 3200X Cesar Chavez St 1 1 1 2     6 3X3   6008348.6867 2100615.53254 37.7483617364081 -122.413900318962 (37.7483617364081, -122.413900318962)
21978 4079 3 8 3200X Cesar Chavez St 3 1 1 2   01/06/1998 12:00:00 AM 3 3X3   6008309.37499 2100615.3209700002 37.7483589476023 -122.414036243399 (37.7483589476023, -122.414036243399)
22240 4066 3 8 3075 Cesar Chavez St 2 1 1 2     12 3X3   6009164.81651 2100538.0301200002 37.7481947332136 -122.41107267688999 (37.7481947332136, -122.41107267689)
23041 6763 3 8 1275 Fairfax Ave 8 1 1 2   08/11/2016 12:00:00 AM 2 3x3   6017251.5649 2096932.76019 37.7387455690451 -122.38285781466298 (37.7387455690451, -122.382857814663)
23101 4130 3 8 3550 Cesar Chavez St 1 1 1 2   09/27/1995 12:00:00 AM 4 3x3   6006437.45796 2100604.55432 37.748224069995295 -122.42050853554501 (37.7482240699953, -122.420508535545)
23301 26453 3 8 401X Keith St 1 1 1 2   06/04/1998 12:00:00 AM 3 3X3   6017690.9643 2096738.1132099999 37.7382353746521 -122.381325031738 (37.7382353746521, -122.381325031738)
23347 26555 3 8 3795 Cesar Chavez St 2 1 1 2     2 3X3   6005295.67635 2100471.79281 37.7477951257409 -122.424447343969 (37.7477951257409, -122.424447343969)
24137 231180 3 8 2800x Bryant St 1 11 1 2     2 Width 5ft   6009829.19056 2100977.4251599996 37.7494384497445 -122.408806277407 (37.7494384497445, -122.408806277407)
25576 231188 3 8 2850x Bryant St 4 11 1 2     1 Width 5ft   6009844.761940001 2100681.8264599997 37.7486276731362 -122.408731579718 (37.7486276731362, -122.408731579718)
37488 231181 3 8 2800x Bryant St 2 11 1 2     1 Width 5ft   6009829.63299 2100960.5991599998 37.7493922740476 -122.408803560533 (37.7493922740476, -122.408803560533)
61236 231182 3 8 2800x Bryant St 3 11 1 2     1 Width 5ft   6009830.8123699995 2100941.41106 37.7493396538235 -122.408798128636 (37.7493396538235, -122.408798128636)
64215 231184 3 8 2800x Bryant St 5 11 1 2     1 Width 5ft   6009832.795080001 2100903.82499 37.7492365618324 -122.40878862099599 (37.7492365618324, -122.408788620996)
79302 4285 3 8 4310X Cesar Chavez St 1 1 1 2   04/07/1995 12:00:00 AM 3 2X3   6001895.2244565 2100336.5410682997 37.747231143218606 -122.43619623965799 (37.7472311432186, -122.436196239658)
85607 25976 3 8 2065 Oakdale Ave 7 1 1 2   02/24/2016 12:00:00 AM 3 2x3   6012647.581347 2097234.3690945 37.739318274919896 -122.398797486611 (37.7393182749199, -122.398797486611)
88090 4078 3 8 3200X Cesar Chavez St 2 1 1 2     6 3X3   6008412.1891644 2100602.6212259 37.7483298510109 -122.413679815119 (37.7483298510109, -122.413679815119)
98439 4287 3 8 4310X Cesar Chavez St 3 1 1 2   01/27/1998 12:00:00 AM 3 2X3   6001895.2244565 2100336.5410682997 37.747231143218606 -122.43619623965799 (37.7472311432186, -122.436196239658)
107774 116080 3 8 2854 CESAR CHAVEZ ST 1 1 1 2       3x3   6010430.0 2100760.0 37.748875082227705 -122.40671333173 (37.7488750822277, -122.40671333173)
111755 109373 3 8 2936 Cesar Chavez St 1 1 1 2   08/02/2016 12:00:00 AM 1 3X3   6009926.0 2100644.0 37.7485283598064 -122.40844799036199 (37.7485283598064, -122.408447990362)
113366 4172 3 8 3795 Cesar Chavez St 3 1 1 2   09/15/2014 08:17:00 AM 3 4X4   6005296.67379 2100472.2695 37.7477964909484 -122.424443928769 (37.7477964909484, -122.424443928769)
113772 122738 2 8 3280x Cesar Chavez St 2 1 1 2       3x3   6007827.0 2100671.0 37.7484847250957 -122.41570823124901 (37.7484847250957, -122.415708231249)
115049 108819 2 8 2850 CESAR CHAVEZ ST 1 1 1 2   01/06/2015 12:00:00 AM 3 3x3   6010441.0 2100764.0 37.7488866808005 -122.40667557539301 (37.7488866808005, -122.406675575393)
118450 122734 2 8 3203 Cesar Chavez St 3 1 1 2       3x3   6008384.0 2100540.0 37.7481563241105 -122.41377286403 (37.7481563241105, -122.41377286403)
146201 4286 3 8 4310X Cesar Chavez St 2 1 1 2   04/07/1995 12:00:00 AM 3 2X3   6001895.2244565 2100336.5410682997 37.747231143218606 -122.43619623965799 (37.7472311432186, -122.436196239658)
147681 231189 3 8 2850x Bryant St 5 11 1 2     1 Width 5ft   6009846.38998 2100665.3670200002 37.7485825703299 -122.40872478893499 (37.7485825703299, -122.408724788935)
154689 231183 3 8 2800x Bryant St 4 11 1 2     1 Width 5ft   6009832.36063 2100921.04222 37.7492838122089 -122.408791337857 (37.7492838122089, -122.408791337857)
169291 231186 3 8 2850x Bryant St 2 11 1 2     1 Width 5ft   6009842.69971 2100715.50345 37.748720027217296 -122.408741086441 (37.7487200272173, -122.408741086441)
175009 231185 3 8 2850x Bryant St 1 11 1 2     1 Width 5ft   6009841.33523 2100729.29077 37.74875780773171 -122.408746777365 (37.7487578077317, -122.408746777365)
187731 231187 3 8 2850x Bryant St 3 11 1 2     1 Width 5ft   6009843.90305 2100697.4884 37.748670629262904 -122.408735654529 (37.7486706292629, -122.408735654529)
Powered by Datasette · Query took 6.345ms · Data source: data.sfgov.org