sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2200 252931 2 90 71 Edgar Ave 1 1 1 1       3x3   5997064.0 2091155.0 37.7217451669512 -122.45223976154499 (37.7217451669512, -122.452239761545)
89333 104727 1 90 1079 Church St 1 1 1 1 4     3x3 Permit Number 770313 6004450.0 2102615.0 37.7536320814231 -122.427524315639 (37.7536320814231, -122.427524315639)
104089 108760 1 90 1350 Church St   1 1 1 1     3x3   6004491.73804 2101024.57628 37.749267509186204 -122.427266693799 (37.7492675091862, -122.427266693799)
114199 100465 1 90 1140 Potrero Ave 1 1 1 1     3 3x3   6010498.9 2102571.5 37.75385291653011 -122.40660271212 (37.7538529165301, -122.40660271212)
151629 116966 4 90 480 Potrero Ave 3 1 1 1     1 3x3   6010311.678719999 2106089.82191 37.7635029625087 -122.407498202703 (37.7635029625087, -122.407498202703)
98395 108709 1 90 280 Fair Oaks St   1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773390 6005432.93594 2102084.07132 37.752229821306706 -122.42408734733101 (37.7522298213067, -122.424087347331)
9834 6787 3 90 1360 Fairfax Ave 7 1 1 2   01/03/2017 06:55:00 AM 3 3x3   6016787.1910829 2097353.9213772 37.739876324716896 -122.384492742853 (37.7398763247169, -122.384492742853)
102059 108761 1 90 1350 Church St 1 1 1 1 1 01/05/2015 12:00:00 AM 3 3x3 Permit Number 774645 6004491.73804 2101024.57628 37.749267509186204 -122.427266693799 (37.7492675091862, -122.427266693799)
90759 108834 1 90 163 Ney St   1 1 1 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774662 6004445.49273 2094062.1156099997 37.73014756094079 -122.42693080570601 (37.7301475609408, -122.426930805706)
142073 108791 1 90 323 Edinburgh St   1 1 1 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774649 6003546.88289 2091819.58764 37.7239392283561 -122.429877518865 (37.7239392283561, -122.429877518865)
89625 108873 1 90 137 Cole St   1 1 1 1 01/08/2015 12:00:00 AM 3 3x3 Permit Number 773403 5997771.922180001 2110131.23662 37.7738897825389 -122.45116047571699 (37.7738897825389, -122.451160475717)
112259 108977 1 90 2970 21st St 1 1 1 1 1 01/20/2015 12:00:00 AM 3 3x3 Permit Number 773794 6008402.2 2103930.0 37.7574655215329 -122.413949705223 (37.7574655215329, -122.413949705223)
118880 93268 3 90 1574 Church St 1 1 1 2   01/29/2015 05:47:00 AM 3 3x3   6004569.0 2099722.0 37.7456953047191 -122.42690676352 (37.7456953047191, -122.42690676352)
117889 109142 1 90 342 29th Ave 1 1 1 1 1 01/29/2015 12:00:00 AM 3 3x3 Permit Number 773572 5986886.5 2113633.7 37.782877302208796 -122.489071978745 (37.7828773022088, -122.489071978745)
124404 87647 3 90 1989X PINE ST 3 1 1 2   01/30/2008 12:00:00 AM 3 3x3   6004432.0 2115332.0 37.788548856891296 -122.42849294395701 (37.7885488568913, -122.428492943957)
9977 5406 3 90 392 Dolores St 1 1 1 2   02/02/2012 12:00:00 AM 5 3x3   6004848.6988147 2106052.9215434 37.7630943465887 -122.42639029035401 (37.7630943465887, -122.426390290354)
22960 109286 1 90 1438 43rd Ave 1 1 1 1 1 02/05/2015 12:00:00 AM 3 3x3 Permit Number 771727 5982826.9 2105321.3 37.75981607235 -122.502500845014 (37.75981607235, -122.502500845014)
55712 109258 1 90 1290 45th Ave 1 1 1 1 1 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773444 5982171.0 2106334.4 37.762559192748604 -122.504844313965 (37.7625591927486, -122.504844313965)
128139 12447 3 90 1989X Pine St 2 1 1 2   02/18/2004 12:00:00 AM 4 3x3   6004432.626396201 2115327.1853143997 37.7885356724235 -122.428490433403 (37.7885356724235, -122.428490433403)
85097 109530 1 90 76 Alvarado St 1 1 1 1 1 02/20/2015 12:00:00 AM 3 3x3 Permit Number 775000 6005863.7 2102913.1 37.7545304541232 -122.42265660342301 (37.7545304541232, -122.422656603423)
88356 95388 1 90 4290 25th St 1 1 1 1 1 02/24/2011 12:00:00 AM   3x3 Permit Number 767255 6001987.9 2101228.0 37.7496841432906 -122.43593955208 (37.7496841432906, -122.43593955208)
106814 95387 1 90 949 Diamond St 1 1 1 1 1 02/24/2011 12:00:00 AM   3x3 Permit Number 767255 6001944.0 2101334.0 37.7499727001327 -122.436098944037 (37.7499727001327, -122.436098944037)
104974 95423 1 90 2187 21st Ave 1 1 1 1 1 03/01/2011 12:00:00 AM   3x3 Permit Number 767291 5989736.1 2100494.0 37.7469651560486 -122.478252612879 (37.7469651560486, -122.478252612879)
13480 85599 3 90 1115 Palou Ave 1 1 1 2   03/07/2014 12:00:00 AM 3 3x3   6017434.0078 2093308.576 37.7288043549368 -122.38197498007798 (37.7288043549368, -122.381974980078)
105721 95660 1 90 431 Brussels St 1 1 1 1 1 03/08/2011 12:00:00 AM   3x3 Permit Number 767422 6010656.7 2092697.9 37.726750960199794 -122.40536171554 (37.7267509601998, -122.40536171554)
96738 85598 3 90 1101 Palou Ave 2 1 1 2   03/08/2014 12:00:00 AM 3 3x3   6017523.881587001 2093256.0516779998 37.728665096277204 -122.381660625783 (37.7286650962772, -122.381660625783)
145512 72375 5 90 4299X Fulton St 1 1 1 1 1 03/09/1996 12:00:00 AM   3x3 Permit Number 773790 5990099.63678033 2109979.56687008 37.773031079694 -122.47768879633699 (37.773031079694, -122.477688796337)
100415 6784 1 90 1360 Fairfax Ave 4 1 1 1   03/10/2007 12:00:00 AM 4 3x3   6016787.1910829 2097353.9213772 37.739876324716896 -122.384492742853 (37.7398763247169, -122.384492742853)
102892 13103 1 90 1516 Lombard St 1 1 1 1   03/11/2008 12:00:00 AM 3 3x3   6005111.0 2119918.0 37.801179250916796 -122.426470375667 (37.8011792509168, -122.426470375667)
139282 87673 1 90 2610 Bay Shore Blvd 1 1 1 1   03/14/2006 12:00:00 AM 3 3x3   6010582.741346 2086196.4709060001 37.708895230886 -122.40515978386101 (37.708895230886, -122.405159783861)
507 251288 3 90 1335 Fairfax Ave 9 1 1 2 3 03/18/2017 01:58:00 PM 3 3x3   6016828.0 2097292.0 37.7397085577181 -122.38434732981199 (37.7397085577181, -122.384347329812)
84159 85604 3 90 1261 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016687.610646 2093879.449725 37.7303306134548 -122.384595098105 (37.7303306134548, -122.384595098105)
86667 85584 3 90 1512 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6015354.897796 2094923.102787 37.7331224832721 -122.389275358402 (37.7331224832721, -122.389275358402)
91134 85567 3 90 1274 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016640.49857 2093964.460415 37.730561430483796 -122.384763892339 (37.7305614304838, -122.384763892339)
93558 85578 3 90 1388 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016034.7263629995 2094416.0331849998 37.7317678372886 -122.386889636739 (37.7317678372886, -122.386889636739)
100161 85559 3 90 980 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6018187.977748999 2092810.8923689998 37.727479421244 -122.37933387198099 (37.727479421244, -122.379333871981)
105434 85569 3 90 1260 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016711.517151 2093911.5196330003 37.7304199931233 -122.384514682139 (37.7304199931233, -122.384514682139)
105958 85583 3 90 1500 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6015418.292964 2094875.9215880001 37.7329964475839 -122.389052889382 (37.7329964475839, -122.389052889382)
112715 85568 3 90 1264 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016691.22613 2093926.645569 37.730460403847204 -122.384585884949 (37.7304604038472, -122.384585884949)
118293 85562 3 90 990 Palou Ave 2 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6018144.213614 2092843.516343 37.7275665867834 -122.379487431767 (37.7275665867834, -122.379487431767)
118353 85607 3 90 1397 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6015969.720597 2094414.6007130002 37.7317603044799 -122.387114277117 (37.7317603044799, -122.387114277117)
120019 85580 3 90 1458 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6015655.098902999 2094699.254039 37.7325244779387 -122.38822185678002 (37.7325244779387, -122.38822185678)
120459 85597 3 90 1101 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 6 3x3   6017523.881587001 2093256.0516779998 37.728665096277204 -122.381660625783 (37.7286650962772, -122.381660625783)
120899 85560 3 90 980 Palou Ave 2 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6018187.977748999 2092810.8923689998 37.727479421244 -122.37933387198099 (37.727479421244, -122.379333871981)
127595 85589 3 90 1566 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6015069.619532 2095135.4181869999 37.7336896386511 -122.390276478357 (37.7336896386511, -122.390276478357)
142002 85561 3 90 990 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6018144.213614 2092843.516343 37.7275665867834 -122.379487431767 (37.7275665867834, -122.379487431767)
143637 85570 3 90 1260 Palou Ave 2 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016711.517151 2093911.5196330003 37.7304199931233 -122.384514682139 (37.7304199931233, -122.384514682139)
143702 85577 3 90 1370 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016127.199744 2094347.0989189998 37.731583677290004 -122.38656512948499 (37.73158367729, -122.386565129485)
144143 85565 3 90 1276 Palou Ave 1 1 1 2   03/21/2007 12:00:00 AM 3 3x3   6016630.35305 2093972.0233900002 37.7305816357941 -122.384799493903 (37.7305816357941, -122.384799493903)
82865 93743 1 90 875 Howard St   1 1 1   03/29/2010 12:00:00 AM   3x3 Permit Number 53322 6011367.4 2112778.7 37.7819281242694 -122.40431760427 (37.7819281242694, -122.40431760427)
14031 18353 4 90 480 Potrero Ave 2 1 1 1   04/02/2013 12:00:00 AM 3 3x3   6010310.709559999 2106111.3358 37.76356198052329 -122.407503071611 (37.7635619805233, -122.407503071611)
89374 88771 1 90 461 Baker St 1 1 1 1   04/03/2015 12:00:00 AM 3 3x3 Permit Number 775199 6000624.0 2110522.0 37.7751256013752 -122.441322740074 (37.7751256013752, -122.441322740074)
511 251164 2 90 1215 Fairfax Ave 10 1 1 1   04/10/2017 01:46:00 PM 3 3x3   6017471.0 2096747.0 37.738247630240295 -122.382086185189 (37.7382476302403, -122.382086185189)
9244 87452 1 90 601 Dolores St 4 1 1 1   04/28/2008 12:00:00 AM 4 3x3   6004976.0 2104871.0 37.7598562652774 -122.425865863079 (37.7598562652774, -122.425865863079)
9121 85732 1 90 901 Howard St 1 1 1 1   04/30/2007 12:00:00 AM 3 3x3   6011193.193535 2112605.183477 37.7814419523203 -122.404908060988 (37.7814419523203, -122.404908060988)
9463 85733 1 90 901 Howard St 2 1 1 1   04/30/2007 12:00:00 AM 4 3x3   6011193.193535 2112605.183477 37.7814419523203 -122.404908060988 (37.7814419523203, -122.404908060988)
88428 86595 3 90 2154 Bryant St 1 1 1 2   04/30/2007 12:00:00 AM 6 3x3   6009566.0 2104744.0 37.7597658751742 -122.409982265203 (37.7597658751742, -122.409982265203)
89180 85698 3 90 640 Howard St 4 1 1 2   04/30/2007 12:00:00 AM 3 3x3   6012881.28755 2114275.485576 37.786122430176896 -122.39918531693199 (37.7861224301769, -122.399185316932)
99235 86637 3 90 2679 Bryant St 1 1 1 2   04/30/2007 12:00:00 AM 3 3x3   6009805.5318559995 2101750.09748 37.751558711569096 -122.40894259967101 (37.7515587115691, -122.408942599671)
100706 85720 1 90 1133 Howard St 2 1 1 1   04/30/2007 12:00:00 AM 3 3x3   6009666.355548 2111144.506481 37.777345813652 -122.41008705150699 (37.777345813652, -122.410087051507)
109929 85721 1 90 1049 Howard St 1 1 1 1   04/30/2007 12:00:00 AM 3 3x3   6010189.0 2111652.0 37.778768551926795 -122.408314849736 (37.7787685519268, -122.408314849736)
110192 85696 3 90 640 Howard St 2 1 1 2   04/30/2007 12:00:00 AM 3 3x3   6012881.28755 2114275.485576 37.786122430176896 -122.39918531693199 (37.7861224301769, -122.399185316932)
110941 85708 3 90 964 Howard St 1 1 1 2   04/30/2007 12:00:00 AM 3 3x3   6010738.0 2112218.0 37.780353382723604 -122.40645552748501 (37.7803533827236, -122.406455527485)
120118 85737 3 90 843 Howard St 1 1 1 2   04/30/2007 12:00:00 AM 3 3x3   6011572.165806 2112967.7341830004 37.782458608165896 -122.40362250946998 (37.7824586081659, -122.40362250947)
124409 85712 3 90 1144 Howard St 2 1 1 2   04/30/2007 12:00:00 AM 3 3x3   6009550.0 2111081.0 37.777164917460105 -122.410485079371 (37.7771649174601, -122.410485079371)
139951 85719 1 90 1175 Howard St 1 1 1 1   04/30/2007 12:00:00 AM 3 3x3   6009405.0 2110901.0 37.7766625499179 -122.410973965657 (37.7766625499179, -122.410973965657)
144410 85707 3 90 960 Howard St 1 1 1 2   04/30/2007 12:00:00 AM 3 3x3   6010763.0 2112242.0 37.7804206796364 -122.406370731962 (37.7804206796364, -122.406370731962)
146040 85697 3 90 640 Howard St 3 1 1 2   04/30/2007 12:00:00 AM 3 3x3   6012881.28755 2114275.485576 37.786122430176896 -122.39918531693199 (37.7861224301769, -122.399185316932)
146109 85695 3 90 640 Howard St 1 1 1 2   04/30/2007 12:00:00 AM 3 3x3   6012881.28755 2114275.485576 37.786122430176896 -122.39918531693199 (37.7861224301769, -122.399185316932)
1124 29774 3 90 1100X Evans Ave 8 1 1 2   05/03/2017 12:44:00 PM 3 3x3   6018183.3236 2096672.8034 37.7380832156692 -122.37961814277901 (37.7380832156692, -122.379618142779)
9231 6725 1 90 1200X Fairfax Ave 22 1 1 1   05/05/2008 12:00:00 AM 3 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191)
95910 95566 1 90 168 Jersey St 1 1 1 1 1 05/08/2014 12:00:00 AM   3x3 Permit Number 772810 6004034.0 2101610.0 37.75084904875379 -122.4288912915 (37.7508490487538, -122.4288912915)
79013 85727 1 90 1025 Howard St 1 1 1 1   05/16/2007 12:00:00 AM 3 3x3   6010365.0 2111820.0 37.7792396944918 -122.40771784288 (37.7792396944918, -122.40771784288)
141707 85728 1 90 1025 Howard St 2 1 1 1   05/16/2007 12:00:00 AM 3 3x3   6010365.0 2111820.0 37.7792396944918 -122.40771784288 (37.7792396944918, -122.40771784288)
85241 85828 3 90 875 Howard St 1 1 1 2   05/17/2007 12:00:00 AM 3 3x3   6011370.824523999 2112775.117387 37.7819184786136 -122.40430550469401 (37.7819184786136, -122.404305504694)
88557 85827 1 90 1345 Howard St 1 1 1 1   05/17/2007 12:00:00 AM 3 3x3   6008580.0 2110114.0 37.774455337270396 -122.413772211324 (37.7744553372704, -122.413772211324)
96836 85833 3 90 875 Howard St 6 1 1 2   05/17/2007 12:00:00 AM 3 3x3   6011370.824523999 2112775.117387 37.7819184786136 -122.40430550469401 (37.7819184786136, -122.404305504694)
96859 85826 1 90 1399X Howard St 3 1 1 1   05/17/2007 12:00:00 AM 3 3x3   6008422.422874 2109956.642426 37.774014420128495 -122.414306166437 (37.7740144201285, -122.414306166437)
116886 85824 1 90 1399X Howard St 1 1 1 1   05/17/2007 12:00:00 AM 3 3x3   6008422.422874 2109956.642426 37.774014420128495 -122.414306166437 (37.7740144201285, -122.414306166437)
117554 85822 1 90 1499X Howard St 1 1 1 1   05/17/2007 12:00:00 AM 3 3x3   6008077.269337 2109627.004998 37.7730899192917 -122.415476772701 (37.7730899192917, -122.415476772701)
123660 85829 3 90 875 Howard St 2 1 1 2   05/17/2007 12:00:00 AM 3 3x3   6011370.824523999 2112775.117387 37.7819184786136 -122.40430550469401 (37.7819184786136, -122.404305504694)
127408 85825 3 90 1399X Howard St 2 1 1 2   05/17/2007 12:00:00 AM 3 3x3   6008422.422874 2109956.642426 37.774014420128495 -122.414306166437 (37.7740144201285, -122.414306166437)
140765 85831 3 90 875 Howard St 4 1 1 2   05/17/2007 12:00:00 AM 3 3x3   6011370.824523999 2112775.117387 37.7819184786136 -122.40430550469401 (37.7819184786136, -122.404305504694)
142267 85832 3 90 875 Howard St 5 1 1 2   05/17/2007 12:00:00 AM 3 3x3   6011370.824523999 2112775.117387 37.7819184786136 -122.40430550469401 (37.7819184786136, -122.404305504694)
146253 85830 3 90 875 Howard St 3 1 1 2   05/17/2007 12:00:00 AM 3 3x3   6011370.824523999 2112775.117387 37.7819184786136 -122.40430550469401 (37.7819184786136, -122.404305504694)
80881 85815 1 90 1607 Howard St 2 1 1 1   05/18/2007 12:00:00 AM 3 3x3   6007663.0 2109095.0 37.7716058657462 -122.41687208779301 (37.7716058657462, -122.416872087793)
86047 85812 1 90 1675 Howard St 3 1 1 1   05/18/2007 12:00:00 AM 3 3x3   6007516.0 2108769.0 37.7707024771995 -122.417357464156 (37.7707024771995, -122.417357464156)
110344 85820 1 90 1501 Howard St 1 1 1 1   05/18/2007 12:00:00 AM 3 3x3   6008072.0 2109608.0 37.7730374398788 -122.415493654294 (37.7730374398788, -122.415493654294)
115233 85817 1 90 1581 Howard St 1 1 1 1   05/18/2007 12:00:00 AM 3 3x3   6007957.739489 2109502.485486 37.7727412989479 -122.415881423672 (37.7727412989479, -122.415881423672)
118449 85818 1 90 1525 Howard St 1 1 1 1   05/18/2007 12:00:00 AM 3 3x3   6007957.0 2109502.0 37.7727399243445 -122.415883947269 (37.7727399243445, -122.415883947269)
123533 85811 3 90 1675 Howard St 2 1 1 2   05/18/2007 12:00:00 AM 3 3x3   6007516.0 2108769.0 37.7707024771995 -122.417357464156 (37.7707024771995, -122.417357464156)
124508 85821 1 90 1501 Howard St 2 1 1 1   05/18/2007 12:00:00 AM 3 3x3   6008072.0 2109608.0 37.7730374398788 -122.415493654294 (37.7730374398788, -122.415493654294)
140189 85813 3 90 1675 Howard St 4 1 1 2   05/18/2007 12:00:00 AM 3 3x3   6007516.0 2108769.0 37.7707024771995 -122.417357464156 (37.7707024771995, -122.417357464156)
144998 85810 1 90 1675 Howard St 1 1 1 1   05/18/2007 12:00:00 AM 3 3x3   6007516.0 2108769.0 37.7707024771995 -122.417357464156 (37.7707024771995, -122.417357464156)
145952 85814 1 90 1607 Howard St 1 1 1 1   05/18/2007 12:00:00 AM 3 3x3   6007663.0 2109095.0 37.7716058657462 -122.41687208779301 (37.7716058657462, -122.416872087793)
116965 18361 3 90 530 Potrero Ave 7 1 1 2   06/02/2015 11:39:00 AM 3 3x3   6010330.807907499 2105828.5872592 37.762786742062204 -122.407413622665 (37.7627867420622, -122.407413622665)
17657 18422 3 90 940 Potrero Ave 1 1 1 2   06/09/2016 06:57:00 AM 3 3x3   6010451.25485 2103753.05423 37.7570945357026 -122.406850749261 (37.7570945357026, -122.406850749261)
102897 87853 1 90 599 Moultrie St 1 1 1 1   06/11/2008 12:00:00 AM   3x3 Permit Number 50764 6007684.0 2096571.0 37.7372189966792 -122.415912430403 (37.7372189966792, -122.415912430403)
86147 55564 1 90 1X CASELLI AVE 1 1 1 1   06/12/2008 12:00:00 AM   3x3 Permit Number 50796 6000842.0 2104917.0 37.7597480805722 -122.44016661153098 (37.7597480805722, -122.440166611531)
102655 87857 1 90 1X CASELLI AVE 5 1 1 1   06/12/2008 12:00:00 AM   3x3 Permit Number 50796 6000842.0 2104917.0 37.7597480805722 -122.44016661153098 (37.7597480805722, -122.440166611531)
59156 87882 1 90 1771 North Point St 1 1 1 1   06/13/2008 12:00:00 AM 6 3x3 Permit Number 50853 6002283.00879 2120864.7759700003 37.8036185768076 -122.436324238766 (37.8036185768076, -122.436324238766)
Powered by Datasette · Query took 3.919ms · Data source: data.sfgov.org