sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5254 253839 3 16 94 Cortland Ave 1 1 1 2       3x3   6006239.0 2097690.0 37.740210176126794 -122.42098789234 (37.7402101761268, -122.42098789234)
5190 253817 3 45 159 Gold Mine Dr 1 1 1 2       3x3   6001018.0 2098627.0 37.742487269754704 -122.43910710368601 (37.7424872697547, -122.439107103686)
5085 253795 2 1 1698X 08th Ave 5 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5099 253794 2 1 1698X 08th Ave 4 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5097 253793 2 1 1698X 08th Ave 3 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5081 253792 2 1 1698X 08th Ave 2 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5092 253791 2 1 1698X 08th Ave 1 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5101 253790 3 47 1651X 15th Ave 2 11 1 2       3x2   5991453.0 2104016.0 37.756735165128205 -122.47257252055401 (37.7567351651282, -122.472572520554)
5090 253789 3 47 1651X 15th Ave 1 11 1 2       3x2   5991453.0 2104016.0 37.756735165128205 -122.47257252055401 (37.7567351651282, -122.472572520554)
5094 253788 3 2 1663X 15th Ave 1 11 1 2       3x3   5991413.0 2103963.0 37.756587325686105 -122.472706989611 (37.7565873256861, -122.472706989611)
5106 253787 3 3 1675X 15th Ave 3 11 1 2       3x3   5991390.0 2103897.0 37.7564047756354 -122.47278171886002 (37.7564047756354, -122.47278171886)
5083 253786 3 47 1675X 15th Ave 2 11 1 2       3x3   5991390.0 2103897.0 37.7564047756354 -122.47278171886002 (37.7564047756354, -122.47278171886)
5104 253785 3 3 1675X 15th Ave 1 11 1 2       3x3   5991390.0 2103897.0 37.7564047756354 -122.47278171886002 (37.7564047756354, -122.47278171886)
5102 253784 3 47 1709X 15th Ave 1 11 1 2       3x2   5991403.0 2103783.0 37.756092514171904 -122.472728448949 (37.7560925141719, -122.472728448949)
5100 253781 3 47 90 Cuesta Ct 5 7 1 2           5999757.0 2101744.0 37.750973968576496 -122.443691128062 (37.7509739685765, -122.443691128062)
5107 253780 3 47 90 Cuesta Ct 4 7 1 2           5999757.0 2101744.0 37.750973968576496 -122.443691128062 (37.7509739685765, -122.443691128062)
5095 253779 3 47 90 Cuesta Ct 3 7 1 2           5999757.0 2101744.0 37.750973968576496 -122.443691128062 (37.7509739685765, -122.443691128062)
5089 253778 3 47 90 Cuesta Ct 2 7 1 2           5999757.0 2101744.0 37.750973968576496 -122.443691128062 (37.7509739685765, -122.443691128062)
5105 253777 3 47 90 Cuesta Ct 1 7 1 2           5999757.0 2101744.0 37.750973968576496 -122.443691128062 (37.7509739685765, -122.443691128062)
5008 253723 3 177 1X Glenview Dr   3 1 2       3x3   5998487.0 2100314.0 37.746975021233204 -122.447979947083 (37.7469750212332, -122.447979947083)
4716 253674 3 225 600 x Sanchez St 2 14 1 2       3x3   6003598.0 2104743.0 37.75942683738779 -122.43062255590701 (37.7594268373878, -122.430622555907)
4727 253673 3 26 600 x Sanchez St 1 14 1 2       3x3   6003598.0 2104743.0 37.75942683738779 -122.43062255590701 (37.7594268373878, -122.430622555907)
4719 253672 3 17 390 06th St 4 1 1 2 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
4669 253646 3 39 1200x La Salle Ave 22 1 1 2 3 11/09/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4684 253645 3 39 1200x La Salle Ave 17 1 1 2 3 03/11/2006 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4668 253644 3 39 1200x La Salle Ave 12 1 1 2 3 11/05/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4562 253642 3 43 427 Columbus Ave 2 1 1 2       3x3   6010361.39347 2118971.94152 37.7988770104459 -122.40823488063499 (37.7988770104459, -122.408234880635)
4620 253639 3 15 4405 California St 3 1 1 2 3     3x3   5993893.0 2114132.0 37.784651953064206 -122.46486880251801 (37.7846519530642, -122.464868802518)
4538 253635 3 37 830 Oak St 2 5 1 2   02/22/2008 12:00:00 AM       6003018.63904 2109969.70237 37.7737452502421 -122.43299969185101 (37.7737452502421, -122.432999691851)
4548 253634 3 43 830 Oak St 1 5 3 2           6003018.63904 2109969.70237 37.7737452502421 -122.43299969185101 (37.7737452502421, -122.432999691851)
4506 253629 3 49 123 Eddy St 2 1 1 2           6009831.1503800005 2113653.7445799997 37.7842448233884 -122.409694124829 (37.7842448233884, -122.409694124829)
4520 253628 3 49 123 Eddy St 1 1 1 2           6009831.1503800005 2113653.7445799997 37.7842448233884 -122.409694124829 (37.7842448233884, -122.409694124829)
4446 253627 3 5 44 Stonecrest Dr 1 5 1 2       3x3   5991061.0 2093828.0 37.7287388406121 -122.4731851996 (37.7287388406121, -122.4731851996)
4063 253608 3 47 400X Portola Dr 1 11 1 2       10x10   5998814.0 2100235.0 37.746776792757004 -122.44684353081101 (37.746776792757, -122.446843530811)
3917 253597 3 43 269 Potrero Ave 1 1 1 2       3x3   6010453.0 2107072.0 37.7662077096315 -122.407078650031 (37.7662077096315, -122.407078650031)
3750 253551 3 41 1000 Cayuga Ave 19 13 1 2   09/22/2017 04:40:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3837 253550 3 41 1000 Cayuga Ave 18 13 1 2   09/27/2017 11:43:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3841 253549 3 41 1000 Cayuga Ave 17 13 1 2   09/27/2017 11:46:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3758 253548 3 41 1000 Cayuga Ave 16 13 1 2   09/22/2017 04:31:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3842 253547 3 41 1000 Cayuga Ave 15 13 1 2   09/27/2017 11:40:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3840 253546 3 41 1000 Cayuga Ave 14 13 1 2   09/27/2017 11:50:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3832 253545 3 37 1000 Cayuga Ave 13 13 1 2   09/27/2017 11:58:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3902 253544 3 88 1000 Cayuga Ave 12 13 1 2   10/03/2017 02:38:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3900 253543 3 88 1000 Cayuga Ave 11 13 1 2   10/03/2017 02:35:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3896 253542 3 88 1000 Cayuga Ave 10 13 1 2   10/03/2017 02:42:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3899 253541 3 88 1000 Cayuga Ave 9 13 1 2   10/03/2017 03:59:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3906 253540 3 88 1000 Cayuga Ave 8 13 1 2   10/03/2017 04:11:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
4040 253539 3 37 1000 Cayuga Ave 7 13 1 2   10/05/2017 04:07:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3754 253538 3 37 1000 Cayuga Ave 6 13 1 2   09/22/2017 02:43:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
4116 253537 3 37 1000 Cayuga Ave 5 13 1 2   10/05/2017 04:02:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
4033 253536 3 77 1000 Cayuga Ave 4 13 1 2   10/05/2017 04:10:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3755 253535 3 77 1000 Cayuga Ave 3 13 1 2   09/22/2017 02:31:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3761 253534 3 77 1000 Cayuga Ave 2 13 1 2   09/22/2017 02:08:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3760 253533 3 77 1000 Cayuga Ave 1 13 1 2   09/22/2017 01:57:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
4690 253527 3 79 100 Haight St 2 1 1 2   10/19/2017 09:54:00 AM 3 3X3   6005589.149 2109643.5092 37.7729950707153 -122.424084680793 (37.7729950707153, -122.424084680793)
3586 253468 3 213 801X Alemany Blvd 1 17 1 2                    
4745 253432 3 51 501X Madrid St 2 1 1 2   10/25/2017 04:09:00 PM 3 3x3   6002703.0 2090930.0 37.721448793681 -122.43273116699801 (37.721448793681, -122.432731166998)
4805 253431 3 51 501X Madrid St 3 1 1 2   10/25/2017 04:07:00 PM 3 3x3   6002703.0 2090930.0 37.721448793681 -122.43273116699801 (37.721448793681, -122.432731166998)
4788 253430 3 51 501X Madrid St 1 1 1 2   10/25/2017 04:04:00 PM 3 3x3   6002703.0 2090930.0 37.721448793681 -122.43273116699801 (37.721448793681, -122.432731166998)
3390 253422 3 143 2X Miraloma Dr 1 18 1 2       10x10   5994995.0 2097925.0 37.740215196600396 -122.459881864698 (37.7402151966004, -122.459881864698)
3208 253368 3 47 236 Moncada Way 1 3 1 2       10x10   5992398.0 2093455.0 37.7277919980392 -122.468536018982 (37.7277919980392, -122.468536018982)
3007 253279 2 9 201X Laguna Honda Blvd 1 9 1 2       10x10 ROW IS 10' tree is street tree          
2896 253266 3 37 2411 Ocean Ave 1 1 1 2   04/26/1996 12:00:00 AM   3x3   5992016.868969999 2094311.4593 37.730121598969205 -122.469915916098 (37.7301215989692, -122.469915916098)
2754 253208 3 191 201x Shipley St 1 1 1 2       3x3   6011752.0 2111938.0 37.7796412414558 -122.402927910408 (37.7796412414558, -122.402927910408)
4536 253202 3 43 800 Oak St 4 5 1 2 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4532 253201 3 43 800 Oak St 3 5 1 2 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4545 253200 3 43 800 Oak St 2 5 1 2 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4541 253199 3 43 800 Oak St 1 5 1 2 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
3723 253167 3 12 1X Brotherhood Way 1 7 1 2                    
2573 253125 2 183 1 Oak Park Dr 1 1 1 2       3x3   5996419.0 2103319.0 37.7551075738744 -122.455348004876 (37.7551075738744, -122.455348004876)
3147 253098 6 3 1290 Portola Dr 2 9 1 2   08/22/2017 12:00:00 AM 3 3x3   5994035.0 2097938.0 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736)
4489 253086 3 37 2849X Alemany Blvd 19 1 1 2   10/13/2017 10:29:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4500 253085 3 37 2849X Alemany Blvd 18 1 1 2   10/13/2017 10:40:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4498 253084 3 87 2849X Alemany Blvd 11 1 1 2   10/13/2017 10:31:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4453 253083 3 26 2849X Alemany Blvd 23 1 1 2   10/13/2017 10:53:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4493 253082 3 26 2849X Alemany Blvd 15 1 1 2   10/13/2017 10:25:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4465 253081 3 49 2849X Alemany Blvd 14 1 1 2   10/13/2017 10:35:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4458 253080 3 49 2849X Alemany Blvd 13 1 1 2   10/13/2017 11:00:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4483 253079 3 87 2849X Alemany Blvd 9 1 1 2   10/13/2017 11:57:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4527 253078 3 87 2849X Alemany Blvd 10 1 1 2   10/13/2017 10:44:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4508 253077 3 87 2849X Alemany Blvd 8 1 1 2   10/13/2017 11:16:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4524 253076 3 87 2849X Alemany Blvd 7 1 1 2   10/13/2017 11:52:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4511 253075 3 87 2849X Alemany Blvd 6 1 1 2   10/13/2017 11:04:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4455 253074 3 87 2849X Alemany Blvd 5 1 1 2   10/13/2017 11:14:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4529 253073 3 87 2849X Alemany Blvd 4 1 1 2   10/13/2017 11:54:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
2333 253025 3 51 1754 09th Ave 1 1 1 2   07/11/2017 12:00:00 AM 3     5993444.58369 2103545.63859 37.7555587516047 -122.465650780273 (37.7555587516047, -122.465650780273)
2208 252955 2 11 50 Ewing Ter 2 1 1 2       3x3   5998847.0 2112431.0 37.7802658347108 -122.44760720084999 (37.7802658347108, -122.44760720085)
2206 252954 2 11 50 Ewing Ter 1 1 1 2       3x3   5998847.0 2112431.0 37.7802658347108 -122.44760720084999 (37.7802658347108, -122.44760720085)
2179 252925 3 71 700 Sanchez St 2 7 1 2           6003672.0 2104202.0 37.757945572264 -122.430328029181 (37.757945572264, -122.430328029181)
2186 252924 3 47 700 Sanchez St 1 7 1 2           6003672.0 2104202.0 37.757945572264 -122.430328029181 (37.757945572264, -122.430328029181)
2156 252915 3 11 1924 Hyde St 1 1 1 2   06/27/2012 12:00:00 AM   3x3   6007321.0 2118975.0 37.79871469295279 -122.418755881393 (37.7987146929528, -122.418755881393)
2144 252907 3 47 25 Point Lobos Ave 10 1 1 2       10x10   5982783.76519 2112486.06679 37.7794859217892 -122.50318049806101 (37.7794859217892, -122.503180498061)
2087 252878 3 15 300X King St 7 1 1 2 3     3x3   6014268.0 2110701.0 37.776384889187796 -122.394137287636 (37.7763848891878, -122.394137287636)
2075 252867 3 2 1660 Masonic Ave 4 1 1 2       3x3   6000023.0 2106990.0 37.7653933634599 -122.443148003218 (37.7653933634599, -122.443148003218)
2067 252866 3 2 1660 Masonic Ave 3 1 1 2       3x3   6000023.0 2106990.0 37.7653933634599 -122.443148003218 (37.7653933634599, -122.443148003218)
2083 252865 3 2 1660 Masonic Ave 2 1 1 2       3x3   6000023.0 2106990.0 37.7653933634599 -122.443148003218 (37.7653933634599, -122.443148003218)
2050 252861 3 17 988 Howard St 3 1 1 2   06/19/2017 12:00:00 AM 3 3x3 Permit Number 779759 6010589.4479 2112082.95565 37.7799742710855 -122.40695991983 (37.7799742710855, -122.40695991983)
2061 252860 3 167 1800X Steiner St 3 1 1 2       3x3   6002556.0 2114541.0 37.7862706325854 -122.434927017215 (37.7862706325854, -122.434927017215)
2058 252859 3 167 1800X Steiner St 2 1 1 2       3x3   6002556.0 2114541.0 37.7862706325854 -122.434927017215 (37.7862706325854, -122.434927017215)
2049 252858 3 167 1800X Steiner St 1 1 1 2       3x3   6002556.0 2114541.0 37.7862706325854 -122.434927017215 (37.7862706325854, -122.434927017215)
1988 252845 3 54 544 Cabrillo St 1 1 1 2   03/29/2014 12:00:00 AM   3x3   5993963.0 2110797.0 37.7754989773977 -122.46438440768401 (37.7754989773977, -122.464384407684)
Powered by Datasette · Query took 34.867ms · Data source: data.sfgov.org