sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
55940 229199 2 8 4302 Cesar Chavez St 1 1 1 1     12 Width 3ft   6001921.37317 2100330.7590799998 37.7472167528667 -122.43610540585699 (37.7472167528667, -122.436105405857)
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)
102235 45172 1 8 1632 Florida St 1 1 1 1 1 05/23/2001 12:00:00 AM     Permit Number 44020 6009655.50292779 2100210.97889112 37.7473242274109 -122.40935281451 (37.7473242274109, -122.40935281451)
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)
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)
134260 231190 2 8 3425 Cesar Chavez St 3 1 1 1     2 Width 3ft   6006626.98431 2100522.1293599997 37.7480084287668 -122.41984730991699 (37.7480084287668, -122.419847309917)
28778 231191 2 8 3415 Cesar Chavez St 1 1 1 1     3 Width 3ft   6006945.26425 2100523.93824 37.7480313210083 -122.418746836492 (37.7480313210083, -122.418746836492)
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)
27036 231200 2 8 3399 Cesar Chavez St 1 1 1 1     3 Width 3ft   6007140.13481 2100524.8991799997 37.7480449295337 -122.418073048237 (37.7480449295337, -122.418073048237)
64599 229187 2 8 3291 Cesar Chavez St 1 2 1 1     2 Width 5ft   6007776.8751 2100527.33423 37.7480874332941 -122.41587139094601 (37.7480874332941, -122.415871390946)
151833 229188 2 8 3287 Cesar Chavez St 1 2 1 1     4 Width 5ft   6007796.6026099995 2100528.4399 37.748091578262795 -122.415803252021 (37.7480915782628, -122.415803252021)
149559 229189 2 8 3281 Cesar Chavez St 1 1 1 1     4 Width 3ft   6007838.5569 2100529.3417599997 37.748096413035796 -122.415658239036 (37.7480964130358, -122.415658239036)
51483 183925 2 8 2116 25th Ave 3 1 1 1     5 Width 0ft   5988539.921 2100941.6436 37.7481247565163 -122.48242163832701 (37.7481247565163, -122.482421638327)
163558 229190 2 8 3215 Cesar Chavez St 11 1 1 1     4 Width 3ft   6008320.8606 2100531.29587 37.748128878546794 -122.413990583024 (37.7481288785468, -122.413990583024)
30509 229191 2 8 3215 Cesar Chavez St 12 1 1 1     1 Width 3ft   6008335.25423 2100531.00146 37.74812887855779 -122.413940789363 (37.7481288785578, -122.413940789363)
172199 231148 2 8 3183 Cesar Chavez St 1 1 1 1     3 Width 3ft   6008529.37485 2100533.17504 37.7481457471424 -122.41326967835899 (37.7481457471424, -122.413269678359)
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)
32437 231199 2 8 3636 Cesar Chavez St 4 1 1 1     3 Width 3ft   6005923.7545 2100590.88969 37.7481575867153 -122.422283938475 (37.7481575867153, -122.422283938475)
76446 231198 2 8 3636 Cesar Chavez St 3 1 1 1     3 Width 3ft   6005940.89889 2100590.84766 37.748158438366794 -122.42222465067199 (37.7481584383668, -122.422224650672)
40538 231149 2 8 3125 Cesar Chavez St 6 1 1 1     4 Width 3ft   6008940.07145 2100531.3882 37.7481638900469 -122.411849371852 (37.7481638900469, -122.411849371852)
172988 231150 2 8 3125 Cesar Chavez St 7 1 1 1     3 Width 3ft   6008959.306369999 2100530.99521 37.748163890068895 -122.411782830119 (37.7481638900689, -122.411782830119)
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)
147495 231151 2 8 3101 Cesar Chavez St 1 1 1 1     4 Width 3ft   6009109.901219999 2100538.836 37.7481938662608 -122.411262629885 (37.7481938662608, -122.411262629885)
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)
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)
21261 4131 1 8 3550 Cesar Chavez St 2 1 1 1     12 3x3   6006413.7316 2100602.86847 37.7482181038987 -122.420590461077 (37.7482181038987, -122.420590461077)
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)
153905 231152 2 8 2963 Cesar Chavez St 1 1 1 1     2 Width 3ft   6009747.40006 2100537.70106 37.74822648288679 -122.409058089377 (37.7482264828868, -122.409058089377)
159914 231197 2 8 3498 Cesar Chavez St 5 1 1 1     2 Width 3ft   6006585.57014 2100606.48147 37.7482377073132 -122.419996503833 (37.7482377073132, -122.419996503833)
186660 231196 2 8 3498 Cesar Chavez St 4 1 1 1     4 Width 3ft   6006617.04806 2100606.14609 37.7482385598621 -122.419887630105 (37.7482385598621, -122.419887630105)
25794 231195 2 8 3400 Cesar Chavez St 4 1 1 1     5 Width 3ft   6006991.81479 2100609.32412 37.7482683921736 -122.418591920205 (37.7482683921736, -122.418591920205)
25597 231194 2 8 3400 Cesar Chavez St 3 1 1 1     1 Width 3ft   6007016.74283 2100608.8130099997 37.7482683921765 -122.41850568331002 (37.7482683921765, -122.41850568331)
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)
188179 231192 2 8 3400 Cesar Chavez St 1 1 1 1     1 Width 3ft   6007058.660209999 2100610.39043 37.748275083131496 -122.41836084568199 (37.7482750831315, -122.418360845682)
154002 183927 2 8 1595 Quintara St 2 1 1 1     2 Width 0ft   5988608.557999999 2101004.688 37.748301852225204 -122.48218891491501 (37.7483018522252, -122.482188914915)
51679 183928 2 8 1595 Quintara St 3 1 1 1     5 Width 0ft   5988643.6391 2101005.1964 37.7483052885878 -122.482067644083 (37.7483052885878, -122.482067644083)
25508 183929 2 8 1595 Quintara St 4 1 1 1     5 Width 0ft   5988670.0771 2101007.2301 37.7483124102266 -122.481976372217 (37.7483124102266, -122.481976372217)
130129 231146 2 8 2891 Cesar Chavez St 1 1 1 1     2 Width 3ft   6010152.40627 2100564.88075 37.748323792227204 -122.40765949968201 (37.7483237922272, -122.407659499682)
124251 93970 1 8 3400 Cesar Chavez St 3 1 1 1     3 3x3 Permit Number 53400 6006959.5 2100632.2 37.7483293848143 -122.41870528613501 (37.7483293848143, -122.418705286135)
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)
42990 45095 1 8 1515 Quintara St 14 1 1 1   05/08/2001 12:00:00 AM     Permit Number 43970 5988775.62486061 2101011.37824645 37.7483299379041 -122.48161169888 (37.7483299379041, -122.48161169888)
78077 45099 1 8 1515 Quintara St 7 1 1 1 1 05/08/2001 12:00:00 AM     Permit Number 43970 5988775.62486061 2101011.37824645 37.7483299379041 -122.48161169888 (37.7483299379041, -122.48161169888)
82502 45107 1 8 1515 Quintara St 10 1 1 1 1 05/08/2001 12:00:00 AM     Permit Number 43970 5988775.62486061 2101011.37824645 37.7483299379041 -122.48161169888 (37.7483299379041, -122.48161169888)
87887 45104 1 8 1515 Quintara St 5 1 1 1 1 05/08/2001 12:00:00 AM     Permit Number 43970 5988775.62486061 2101011.37824645 37.7483299379041 -122.48161169888 (37.7483299379041, -122.48161169888)
90249 45102 1 8 1515 Quintara St 1 1 1 1 1 05/08/2001 12:00:00 AM     Permit Number 43970 5988775.62486061 2101011.37824645 37.7483299379041 -122.48161169888 (37.7483299379041, -122.48161169888)
90508 45096 1 8 1515 Quintara St 13 1 1 1   05/08/2001 12:00:00 AM     Permit Number 43970 5988775.62486061 2101011.37824645 37.7483299379041 -122.48161169888 (37.7483299379041, -122.48161169888)
91807 45094 1 8 1515 Quintara St 15 1 1 1   05/08/2001 12:00:00 AM     Permit Number 43970 5988775.62486061 2101011.37824645 37.7483299379041 -122.48161169888 (37.7483299379041, -122.48161169888)
97950 45098 1 8 1515 Quintara St 11 1 1 1   05/08/2001 12:00:00 AM     Permit Number 43970 5988775.62486061 2101011.37824645 37.7483299379041 -122.48161169888 (37.7483299379041, -122.48161169888)
105259 45105 1 8 1515 Quintara St 4 1 1 1 1 05/08/2001 12:00:00 AM     Permit Number 43970 5988775.62486061 2101011.37824645 37.7483299379041 -122.48161169888 (37.7483299379041, -122.48161169888)
108381 45100 1 8 1515 Quintara St 3 1 1 1 1 05/08/2001 12:00:00 AM     Permit Number 43970 5988775.62486061 2101011.37824645 37.7483299379041 -122.48161169888 (37.7483299379041, -122.48161169888)
109126 45108 1 8 1515 Quintara St 2 1 1 1 1 05/08/2001 12:00:00 AM     Permit Number 43970 5988775.62486061 2101011.37824645 37.7483299379041 -122.48161169888 (37.7483299379041, -122.48161169888)
114749 45103 1 8 1515 Quintara St 6 1 1 1 1 05/08/2001 12:00:00 AM     Permit Number 43970 5988775.62486061 2101011.37824645 37.7483299379041 -122.48161169888 (37.7483299379041, -122.48161169888)
126088 45097 1 8 1515 Quintara St 12 1 1 1   05/08/2001 12:00:00 AM     Permit Number 43970 5988775.62486061 2101011.37824645 37.7483299379041 -122.48161169888 (37.7483299379041, -122.48161169888)
142635 45101 1 8 1515 Quintara St 8 1 1 1 1 05/08/2001 12:00:00 AM     Permit Number 43970 5988775.62486061 2101011.37824645 37.7483299379041 -122.48161169888 (37.7483299379041, -122.48161169888)
142796 45106 1 8 1515 Quintara St 9 1 1 1 1 05/08/2001 12:00:00 AM     Permit Number 43970 5988775.62486061 2101011.37824645 37.7483299379041 -122.48161169888 (37.7483299379041, -122.48161169888)
153238 231179 2 8 3298 Cesar Chavez St 2 1 1 1     3 Width 3ft   6007865.21134 2100614.7853099997 37.7483325201375 -122.415572117257 (37.7483325201375, -122.415572117257)
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)
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)
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)
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)
42581 231145 2 8 2889 Cesar Chavez St 1 1 1 1     2 Width 3ft   6010184.657819999 2100581.30879 37.748370705352 -122.407549132205 (37.748370705352, -122.407549132205)
162933 229196 2 8 3198 Cesar Chavez St 2 1 1 1     2 Width 3ft   6008499.285209999 2100616.55168 37.74837299142221 -122.41337962318501 (37.7483729914222, -122.413379623185)
97658 122709 2 8 3092 Cesar Chavez St 1 1 1 1     2 3x3   6009072.0 2100607.0 37.7483789037457 -122.41139850646002 (37.7483789037457, -122.41139850646)
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)
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)
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)
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)
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)
125104 39835 1 8 2034 Great Hwy 1 1 1 1 1 01/06/1999 12:00:00 AM     Permit Number 41157 5981216.95216217 2101218.11125367 37.7484551479521 -122.507764274182 (37.7484551479521, -122.507764274182)
154617 231171 2 8 2950 Cesar Chavez St 1 1 1 1     4 Width 3ft   6009778.821959999 2100624.5586900003 37.7484667349686 -122.408955560378 (37.7484667349686, -122.408955560378)
1313 231170 2 8 2934 Cesar Chavez St 2 1 1 1     1 Width 3ft   6009921.15441 2100625.625 37.7484776347434 -122.408463450455 (37.7484776347434, -122.408463450455)
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)
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)
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)
39248 231144 2 8 2861 Cesar Chavez St 1 1 1 1     2 Width 3ft   6010352.984680001 2100652.77775 37.7485763641144 -122.406972095682 (37.7485763641144, -122.406972095682)
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)
70120 231143 2 8 2857 Cesar Chavez St 1 1 1 1     3 Width 3ft   6010376.44019 2100661.4980599997 37.7486016206723 -122.406891600982 (37.7486016206723, -122.406891600982)
9624 157504 1 8 561 Clipper St 1 1 1 1     2 4x12   6001543.35163 2100850.1382 37.7486213607928 -122.437449759212 (37.7486213607928, -122.437449759212)
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)
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)
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)
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)
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)
26398 231169 2 8 2850 Cesar Chavez St 1 1 1 1     1 Width 2ft   6010444.30181 2100779.49812 37.748929419971205 -122.40666524970501 (37.7489294199712, -122.406665249705)
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)
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)
187562 231173 2 8 1456 Hampshire St 1 1 1 1     2 Width 3ft   6010420.7845 2100915.18546 37.749300671809294 -122.406756134286 (37.7493006718093, -122.406756134286)
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)
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)
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)
43210 208534 2 8 2054 18th Ave 1 1 1 1     9 Width 3ft   5990697.96146 2101402.01717 37.749514123180106 -122.47499288701 (37.7495141231801, -122.47499288701)
93007 50913 1 8 2054 18th Ave 1 1 1 1 1 04/26/2004 12:00:00 AM     Permit Number 47416 5990700.21989371 2101411.09480317 37.749539178873604 -122.474985739909 (37.7495391788736, -122.474985739909)
52643 208535 2 8 2034 18th Ave 1 1 1 1     5 Width 3ft   5990694.79543 2101523.21482 37.7498467167631 -122.47501268111 (37.7498467167631, -122.47501268111)
41310 231163 2 8 4028 25th St 1 1 1 1     2 Width 3ft   6003650.36974 2101302.0860599997 37.74998186778821 -122.430195955301 (37.7499818677882, -122.430195955301)
87084 39491 1 8 4028 25th St 1 1 1 1   12/28/1998 12:00:00 AM 2 3x3 Permit Number 773152 6003658.31087799 2101306.87444184 37.7499954653433 -122.430168836007 (37.7499954653433, -122.430168836007)
Powered by Datasette · Query took 4.653ms · Data source: data.sfgov.org