sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
92501 97725 3 94 1000X Bay St 4 5 1 4 2     7x82   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028)
92726 97722 3 94 1000X Bay St 1 5 1 4 2   14 7x57   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028)
117800 97724 3 94 1000X Bay St 3 5 1 4 2   14 7x82   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028)
128722 97723 3 94 1000X Bay St 2 5 1 4 2   14 7x57   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028)
78641 116976 2 218 100x CARGO WAY 7 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
79463 116977 2 5 100x CARGO WAY 117 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
140503 116975 2 218 100x CARGO WAY 6 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
89310 66890 3 2 1035 Gilman Ave 1 1 1 4 2 05/07/2005 12:00:00 AM 6 3x3 Permit Number 45482 6015368.10493708 2089617.80548286 37.71855592189279 -122.388859444456 (37.7185559218928, -122.388859444456)
106838 102115 3 2 1035 Gilman Ave 5 1 1 4 2   6 3x3 Permit Number 52469 6015181.7 2089440.8 37.7180595657824 -122.389491420596 (37.7180595657824, -122.389491420596)
129243 47256 3 2 1035 Gilman Ave 2 1 1 4 2 05/09/2002 12:00:00 AM 6 3x3 Permit Number 45198 6015368.10493708 2089617.80548286 37.71855592189279 -122.388859444456 (37.7185559218928, -122.388859444456)
145918 47257 3 2 1035 Gilman Ave 3 1 1 4 2 07/08/2009 12:00:00 AM 6 3x3 Permit Number 52469 6015368.10493708 2089617.80548286 37.71855592189279 -122.388859444456 (37.7185559218928, -122.388859444456)
100074 43904 1 35 1050 York St 3 1 1 4 2 04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.755232893914794 -122.408509176777 (37.7552328939148, -122.408509176777)
146100 43905 1 35 1050 York St 1 1 1 4 2 04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.755232893914794 -122.408509176777 (37.7552328939148, -122.408509176777)
1794 81999 3 2 1150 Francisco St 2 1 1 4 2 06/04/2008 12:00:00 AM 5 3x3 Permit Number 50638 6005960.45556 2120727.0973099996 37.803448808170295 -122.423588442877 (37.8034488081703, -122.423588442877)
5294 97730 3 2 1150 Francisco St 8 1 1 4 2   6 3x3 Permit Number 50638 6005803.34745 2120703.57786 37.8033753605476 -122.424130448959 (37.8033753605476, -122.424130448959)
5699 97727 3 2 1150 Francisco St 5 1 1 4 2   4 3x3 Permit Number 50638 6005898.3389 2120719.3141099997 37.8034239311172 -122.42380284664699 (37.8034239311172, -122.423802846647)
5962 82000 3 2 1150 Francisco St 1 1 1 4 2 06/04/2008 12:00:00 AM 6 3x3 Permit Number 50638 6005983.68719 2120729.63993 37.803457100839296 -122.423508229633 (37.8034571008393, -122.423508229633)
6518 97735 3 37 1150 Francisco St 13 1 1 4 2 06/22/2016 02:46:00 PM 3 3x3 Permit Number 50638 6005694.978999999 2120690.49004 37.8033333055591 -122.424504530974 (37.8033333055591, -122.424504530974)
7339 97732 3 2 1150 Francisco St 10 1 1 4 2   5 3x3 Permit Number 50638 6005757.30775 2120698.05289 37.8033575908394 -122.424289378073 (37.8033575908394, -122.424289378073)
7419 97731 3 47 1150 Francisco St 9 1 1 4 2   3 3x3 Permit Number 50638 6005778.11415 2120709.05822 37.803388983478605 -122.42421815984501 (37.8033889834786, -122.424218159845)
7474 81997 3 2 1150 Francisco St 4 1 1 4 2 06/04/2008 12:00:00 AM 5 3x3 Permit Number 50638 6005918.11487 2120722.35908 37.8034334081868 -122.42373462766001 (37.8034334081868, -122.42373462766)
7989 97733 3 26 1150 Francisco St 11 1 1 4 2   4 3x3 Permit Number 50638 6005736.8865 2120695.23683 37.8033487055393 -122.42435984622801 (37.8033487055393, -122.424359846228)
8271 81998 3 26 1150 Francisco St 3 1 1 4 2 06/04/2008 12:00:00 AM 4 3x3 Permit Number 50638 6005939.397969999 2120724.9413900003 37.8034416999448 -122.42366116024999 (37.8034416999448, -122.42366116025)
8363 97734 3 2 1150 Francisco St 12 1 1 4 2   5 3x3 Permit Number 50638 6005715.837730001 2120693.51258 37.8033427825912 -122.424432563629 (37.8033427825912, -122.424432563629)
8576 97728 3 2 1150 Francisco St 6 1 1 4 2   5 3x3 Permit Number 50638 6005878.13407 2120716.4935 37.8034150458325 -122.423872565669 (37.8034150458325, -122.423872565669)
8881 97729 3 26 1150 Francisco St 7 1 1 4 2   4 3x3 Permit Number 50638 6005819.00921 2120706.70735 37.80338483759171 -122.42407647347099 (37.8033848375917, -122.424076473471)
10126 97736 3 26 1150 Francisco St 14 1 1 4 2 01/31/2017 12:02:00 PM 3 3x3 Permit Number 50638 6005674.32361 2120686.81612 37.8033220514443 -122.424575748272 (37.8033220514443, -122.424575748272)
6478 98738 2 5 1150 Scott St 2 1 1 20 2   3 4X4   6001885.6171 2112431.4484 37.780440254610205 -122.43709527307301 (37.7804402546102, -122.437095273073)
114699 98740 2 5 1150 Scott St 4 1 1 20 2   20 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
126702 98737 2 5 1150 Scott St 1 1 1 20 2   24 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
128761 98739 2 5 1150 Scott St 3 1 1 20 2   20 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
144482 98742 2 51 1150 Scott St 6 1 1 20 2 03/21/2012 12:00:00 AM 3 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
145720 98741 2 51 1150 Scott St 5 1 1 20 2 03/21/2012 12:00:00 AM 3 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
104096 112062 2 37 1199 VISITACION AVE 4 1 1 4 2 08/18/2015 12:00:00 AM   4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
120376 112063 2 37 1199 VISITACION AVE 5 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
123118 112058 2 37 1199 VISITACION AVE 1 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
140135 112060 2 37 1199 VISITACION AVE 2 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
141095 112061 2 37 1199 VISITACION AVE 3 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
10863 99498 3 108 125 Excelsior Ave 5 1 1 4 2   3 3x3   6002794.02408 2092508.7984200001 37.725788983259605 -122.432529234659 (37.7257889832596, -122.432529234659)
11215 75214 3 155 125 Excelsior Ave 3 1 1 4 2 05/08/1992 12:00:00 AM 14 4x5   6002868.59368 2092460.8085599998 37.725661442297294 -122.432268027453 (37.7256614422973, -122.432268027453)
11694 75308 3 26 125 Excelsior Ave 4 1 1 4 2 05/08/1992 12:00:00 AM 10 4x5   6002852.682680001 2092471.3085599998 37.725689370766204 -122.43232378004 (37.7256893707662, -122.43232378004)
12293 75309 3 184 125 Excelsior Ave 6 1 1 4 2 05/08/1992 12:00:00 AM 5 3x3   6002784.56496 2092514.51527 37.7258041440316 -122.432562342276 (37.7258041440316, -122.432562342276)
12657 75213 3 26 125 Excelsior Ave 2 1 1 4 2 05/08/1992 12:00:00 AM 10 4x5   6002883.607340001 2092451.48886 37.7256367037627 -122.43221546119 (37.7256367037627, -122.43221546119)
12861 75133 3 155 125 Excelsior Ave 1 1 1 4 2 05/08/1992 12:00:00 AM 14 4x4   6002899.19862 2092441.61812 37.7256104849218 -122.43216085884501 (37.7256104849218, -122.432160858845)
77433 31711 3 16 1250X Shrader St 8 1 1 4 2 06/19/1995 12:00:00 AM 6 3x3 Permit Number 35211 5997882.313818 2106467.94501531 37.763837639523395 -122.450514467435 (37.7638376395234, -122.450514467435)
80701 99678 3 55 1250X Shrader St 9 1 1 4 2   10 4x4 Permit Number 770537 5997882.0 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624)
82347 99677 3 17 1250X Shrader St 7 1 1 4 2 10/04/2013 12:00:00 AM 16 3x3 Permit Number 770537 5997882.0 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624)
105707 99675 3 17 1250X Shrader St 5 1 1 4 2   3 3x3   5997882.0 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624)
111245 99672 3 98 1250X Shrader St 2 1 1 4 2   3 3x3   5997882.0 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624)
117464 72536 3 17 1250X Shrader St 1 1 1 4 2 03/21/1992 12:00:00 AM 10 3x3   5997766.5684589995 2106397.97443782 37.7636388926021 -122.45090974788 (37.7636388926021, -122.45090974788)
126843 99674 3 17 1250X Shrader St 4 1 1 4 2   30 4x4   5997882.0 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624)
129440 99676 3 17 1250X Shrader St 6 1 1 4 2   14 3x3   5997882.0 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624)
138394 99673 3 17 1250X Shrader St 3 1 1 4 2   8 4x4   5997882.0 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624)
13403 96770 3 26 1300X Lane St 6 5 1 4 2 12/08/2012 12:00:00 AM 3 3x3   6015623.8599 2095148.9526 37.7337575287133 -122.388361234061 (37.7337575287133, -122.388361234061)
14458 94035 3 25 1300X Lane St 3 1 1 4 2   32 5x5   6015684.8669 2095240.1882 37.7340114236329 -122.388156677838 (37.7340114236329, -122.388156677838)
15674 94034 3 25 1300X Lane St 2 5 1 4 2   24 3x3   6015674.4242 2095246.7836 37.7340289546749 -122.388193241926 (37.7340289546749, -122.388193241926)
15999 94036 3 26 1300X Lane St 4 5 1 4 2 12/08/2012 12:00:00 AM 3 5x5   6015673.325 2095216.0053 37.7339443827642 -122.388194894968 (37.7339443827642, -122.388194894968)
16453 96769 3 26 1300X Lane St 5 1 1 4 2   1 4x4   6015646.9436 2095179.7309 37.7338433188148 -122.388283573512 (37.7338433188148, -122.388283573512)
77312 96772 3 26 1300X Lane St 8 1 1 4 2   2 3x3   6015407.2 2095381.5 37.73438404885479 -122.38912652987801 (37.7343840488548, -122.389126529878)
85372 96771 3 26 1300X Lane St 7 1 1 4 2 11/08/2011 12:00:00 AM 8 4x3   6015407.2 2095381.5 37.73438404885479 -122.38912652987801 (37.7343840488548, -122.389126529878)
124646 96774 3 26 1300X Lane St 10 1 1 4 2 12/08/2012 12:00:00 AM 3 3x3   6015407.2 2095381.5 37.73438404885479 -122.38912652987801 (37.7343840488548, -122.389126529878)
10289 77643 3 55 1300X Silliman St 4 1 1 4 2 10/26/1984 12:00:00 AM 10 4x4   6006923.4408599995 2093174.3728599998 37.7278498138936 -122.41830128179899 (37.7278498138936, -122.418301281799)
10418 77647 3 82 1300X Silliman St 8 1 1 4 2 10/26/1984 12:00:00 AM 10 3x3   6006841.82551 2093150.82877 37.7277805724005 -122.418581759638 (37.7277805724005, -122.418581759638)
10784 77645 3 55 1300X Silliman St 6 1 1 4 2 10/26/1984 12:00:00 AM 10 4x4   6006883.8507199995 2093162.97754 37.727816296176705 -122.41843733843201 (37.7278162961767, -122.418437338432)
11530 77642 3 55 1300X Silliman St 3 1 1 4 2 10/26/1984 12:00:00 AM 12 4x4   6006942.1040900005 2093179.9332599998 37.7278661320969 -122.418237156514 (37.7278661320969, -122.418237156514)
11692 77644 3 55 1300X Silliman St 5 1 1 4 2 10/26/1984 12:00:00 AM 10 4x5   6006907.53511 2093169.55905 37.7278357008551 -122.41835592728 (37.7278357008551, -122.41835592728)
12057 77641 3 55 1300X Silliman St 2 1 1 4 2 10/26/1984 12:00:00 AM 12 4x4   6006964.988919999 2093186.8525200002 37.7278864190206 -122.418158533295 (37.7278864190206, -122.418158533295)
13090 77646 3 55 1300X Silliman St 7 1 1 4 2 10/26/1984 12:00:00 AM 5 3x3   6006863.07514 2093156.65739 37.7277977728371 -122.418508712231 (37.7277977728371, -122.418508712231)
23202 77640 3 55 1300X Silliman St 1 1 1 4 2 10/26/1984 12:00:00 AM 13 0   6006980.92428 2093193.1114700001 37.7279045016753 -122.418103887786 (37.7279045016753, -122.418103887786)
129020 77649 3 55 1300X Silliman St 10 1 1 4 2 10/26/1984 12:00:00 AM 3 3x3   6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
77788 98940 3 26 1400X San Bruno Ave 4 1 1 4 2   10 3x3   6011147.5 2101806.3 37.7517881116631 -122.40430583648501 (37.7517881116631, -122.404305836485)
93944 98943 3 26 1400X San Bruno Ave 7 1 1 4 2   10 3x3   6011147.5 2101806.3 37.7517881116631 -122.40430583648501 (37.7517881116631, -122.404305836485)
98082 98941 3 26 1400X San Bruno Ave 5 1 1 4 2   5 3x3   6011147.5 2101806.3 37.7517881116631 -122.40430583648501 (37.7517881116631, -122.404305836485)
105910 98939 3 26 1400X San Bruno Ave 3 1 1 4 2   12 3x3   6011147.5 2101806.3 37.7517881116631 -122.40430583648501 (37.7517881116631, -122.404305836485)
120806 98938 3 26 1400X San Bruno Ave 2 1 1 4 2   3 3x3   6011147.5 2101806.3 37.7517881116631 -122.40430583648501 (37.7517881116631, -122.404305836485)
123342 98942 3 26 1400X San Bruno Ave 6 1 1 4 2   12 3x3   6011147.5 2101806.3 37.7517881116631 -122.40430583648501 (37.7517881116631, -122.404305836485)
88568 98931 3 26 1401X Utah St 1 1 1 4 2   10 3x3   6010911.0 2101810.0 37.751785052607204 -122.405123950338 (37.7517850526072, -122.405123950338)
92484 98933 3 26 1401X Utah St 3 1 1 4 2   10 3x3   6010911.0 2101810.0 37.751785052607204 -122.405123950338 (37.7517850526072, -122.405123950338)
97955 98935 3 26 1401X Utah St 5 1 1 4 2   10 3x3   6010911.0 2101810.0 37.751785052607204 -122.405123950338 (37.7517850526072, -122.405123950338)
115369 98932 3 26 1401X Utah St 2 1 1 4 2   10 3x3   6010911.0 2101810.0 37.751785052607204 -122.405123950338 (37.7517850526072, -122.405123950338)
117821 98934 3 26 1401X Utah St 4 1 1 4 2   10 3x3   6010911.0 2101810.0 37.751785052607204 -122.405123950338 (37.7517850526072, -122.405123950338)
760 38424 3 112 1451 Jackson St 2 1 1 4 2 06/24/2005 12:00:00 AM 12 3x3 Permit Number 48015 6007280.7970900005 2117415.82487 37.79443132398921 -122.418784361633 (37.7944313239892, -122.418784361633)
5496 99696 3 26 1451 Jackson St 1 1 1 4 2   24 3x3   6007201.17567 2117403.71838 37.794393599230204 -122.41905900288799 (37.7943935992302, -122.419059002888)
5819 99697 3 26 1451 Jackson St 3 1 1 4 2   10 3x3   6007296.6569 2117418.12417 37.794438530258 -122.41872964778099 (37.794438530258, -122.418729647781)
97853 74583 3 26 145X Palm Ave 4 1 1 4 2 05/08/2015 03:18:00 PM 3 3x3   5995615.70210752 2113241.02862618 37.7823047585419 -122.458844340036 (37.7823047585419, -122.458844340036)
104050 74883 3 26 145X Palm Ave 7 1 1 4 2 05/08/2015 03:14:00 PM 3 3x3   5995615.70210752 2113241.02862618 37.7823047585419 -122.458844340036 (37.7823047585419, -122.458844340036)
10658 75132 3 184 148X Paris St 8 1 1 4 2 05/08/1992 12:00:00 AM 6 3x3   6002992.1034699995 2092540.72564 37.725887878997504 -122.431846767938 (37.7258878789975, -122.431846767938)
10679 43313 3 108 148X Paris St 4 1 1 4 2 06/04/2008 12:00:00 AM 3 3x3 Permit Number 50666 6003041.97819 2092624.14713 37.726119762901504 -122.43168030790399 (37.7261197629015, -122.431680307904)
10805 76705 3 108 148X Paris St 5 1 1 4 2 05/08/1992 12:00:00 AM 4 3x3   6003030.53484 2092605.75448 37.726068612152794 -122.431718554264 (37.7260686121528, -122.431718554264)
11783 75049 3 108 148X Paris St 7 1 1 4 2 05/08/1992 12:00:00 AM 6 3x3   6003005.92399 2092563.3958599998 37.7259509097926 -122.431800609333 (37.7259509097926, -122.431800609333)
12059 76663 3 26 148X Paris St 9 1 1 4 2 05/08/1992 12:00:00 AM 6 3x3   6002979.0601 2092519.0806099998 37.725827707182 -122.431890313086 (37.725827707182, -122.431890313086)
12201 43311 3 108 148X Paris St 2 1 1 4 2 06/04/2008 12:00:00 AM 6 3x3 Permit Number 50666 6003068.93568 2092663.2521400002 37.7262286645003 -122.431589908071 (37.7262286645003, -122.431589908071)
12344 43312 3 108 148X Paris St 3 1 1 4 2 06/04/2008 12:00:00 AM 6 3x3 Permit Number 50666 6003053.84834 2092643.73268 37.7261742132654 -122.43164067119899 (37.7261742132654, -122.431640671199)
12381 75048 3 108 148X Paris St 6 1 1 4 2 05/08/1992 12:00:00 AM 6 3x3   6003019.452409999 2092585.35122 37.7260119611657 -122.431755409402 (37.7260119611657, -122.431755409402)
12969 76641 3 41 148X Paris St 11 1 1 4 2 05/08/1992 12:00:00 AM 10 3x3   6002952.722159999 2092480.7640200001 37.7257210052939 -122.43197862653 (37.7257210052939, -122.43197862653)
23170 76652 3 11 148X Paris St 10 1 1 4 2 05/08/1992 12:00:00 AM 8 3x3   6002965.38435 2092499.73249 37.7257738062998 -122.43193620818998 (37.7257738062998, -122.43193620819)
23164 76784 3 2 1501X 42nd Ave 7 1 1 4 2 05/14/1994 12:00:00 AM 1 3x12   5983097.2131 2104562.028 37.7577472058325 -122.50150981087799 (37.7577472058325, -122.501509810878)
23240 76785 3 39 1501X 42nd Ave 8 1 1 4 2 05/14/1994 12:00:00 AM 24 3x12   5983097.8243 2104541.5546 37.757691027540005 -122.501506182606 (37.75769102754, -122.501506182606)
23245 76756 3 108 1501X 42nd Ave 6 1 1 4 2 05/14/1994 12:00:00 AM 2 3x12   5983095.0741 2104639.3384 37.757959352781 -122.501522927406 (37.757959352781, -122.501522927406)
23276 76755 3 108 1501X 42nd Ave 5 1 1 4 2 05/14/1994 12:00:00 AM 3 3x12   5983093.5463 2104662.8676 37.758023867602 -122.501529951702 (37.758023867602, -122.501529951702)
23340 76382 3 39 1501X 42nd Ave 2 1 1 4 2 05/14/1994 12:00:00 AM 25 3x12   5983091.4072 2104771.8049 37.7583228530818 -122.501545408351 (37.7583228530818, -122.501545408351)
Powered by Datasette · Query took 5.699ms · Data source: data.sfgov.org