sf-trees

Data source: data.sfgov.org

Custom SQL query returning 49 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
119065 98218 3 8 1501X 42nd Ave 12 1 1 10 6   3 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
120505 98220 3 8 1501X 42nd Ave 14 1 1 10 6   5 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
1397 183688 3 8 1341 42nd Ave 2 1 1 1     5 Width 0ft   5983045.4855 2105994.3027 37.7616767889617 -122.501794671486 (37.7616767889617, -122.501794671486)
42328 115970 3 8 1599x 30TH AVE 7 1 1 4     0 3x3   5986686.0 2104596.0 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136)
95487 115964 3 8 1599x 30TH AVE 1 1 1 4     8 3x3   5986686.0 2104596.0 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136)
168456 115973 3 8 1599x 30TH AVE 10 1 1 4     0 3x3   5986686.0 2104596.0 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136)
160302 115965 3 8 1599x 30th Ave 2 1 1 4     7 3x3   5986811.649 2104744.2782 37.758465070521105 -122.488677324697 (37.7584650705211, -122.488677324697)
175061 115966 3 8 1599x 30th Ave 3 1 1 4     6 3x3   5986811.649 2104717.0256 37.7583902423484 -122.488675321582 (37.7583902423484, -122.488675321582)
48933 115967 3 8 1599x 30th Ave 4 1 1 4     4 3x3   5986812.8086 2104676.4366 37.758278863742106 -122.488668327875 (37.7582788637421, -122.488668327875)
164886 115968 3 8 1599x 30th Ave 5 1 1 4     6 3x3   5986813.3885 2104648.6042 37.7582024774349 -122.48866427663799 (37.7582024774349, -122.488664276638)
166151 115971 3 8 1599x 30th Ave 8 1 1 4     4 3x3   5986813.9683 2104572.6448 37.757993947556 -122.48865668838499 (37.757993947556, -122.488656688385)
177652 115972 3 8 1599x 30th Ave 9 1 1 4     8 3x3   5986817.4474 2104547.1317 37.757924098588795 -122.488642781125 (37.7579240985888, -122.488642781125)
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)
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)
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)
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)
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)
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)
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)
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)
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)
79730 99039 3 8 200X Bartlett St 13 1 1 4 2   3 3x3   6006692.0 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314)
105713 40250 3 8 3351X 23rd St 1 1 1 4 2 05/13/1999 12:00:00 AM 3 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
Powered by Datasette · Query took 54.85ms · Data source: data.sfgov.org