sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

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)
5256 253838 2 141 1458 46th Ave 1 1 1 1 1     5.5x4   5981900.0 2105162.0 37.759324170949604 -122.505694672765 (37.7593241709496, -122.505694672765)
5214 253835 2 37 3353 19th Ave 10 1 1 1       Width 3ft   5990554.425319999 2094179.3629700001 37.7296742505655 -122.47496207986099 (37.7296742505655, -122.474962079861)
5229 253834 1 54 747 Eddy St 1 1 1 1 4     3x3   6006860.78535 2113242.76542 37.7829494746502 -122.419941385136 (37.7829494746502, -122.419941385136)
5236 253833 1 54 607 Eddy St 2 1 1 1 4     3x3            
5226 253832 1 54 665 Eddy St 1 1 1 1 4     3x3   6007254.7956 2113297.42725 37.783121752773 -122.41858214693501 (37.783121752773, -122.418582146935)
5216 253831 1 54 651X Polk St 5 1 1 1 4     3x3            
5239 253830 1 54 651X Polk St 3 1 1 1 4     3x3            
5211 253829 1 54 869 Ellis St 1 1 1 1 4     3x3   6006713.1749 2113568.2957099997 37.7838349840749 -122.420475171434 (37.7838349840749, -122.420475171434)
5228 253828 1 54 825 Polk St 2 1 1 1 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5224 253827 1 54 825 Polk St 1 1 1 1 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5230 253826 1 54 701 Ellis St 1 1 1 1 4     3x3            
5222 253825 1 54 725 Ellis St 1 1 1 1 4     3x3   6007393.727109999 2113660.9435900003 37.784127700976896 -122.418127279043 (37.7841277009769, -122.418127279043)
5181 253819 2 5 1100x Prague St   1 1 1       3x3   6001057.0 2086858.0 37.71017450293179 -122.43812937571998 (37.7101745029318, -122.43812937572)
5176 253818 2 3 219 Concord St 2 1 1 1 1         5999956.6131 2087048.59536 37.7106351918399 -122.44194619318 (37.7106351918399, -122.44194619318)
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)
5158 253816 2 155 144 Paloma Ave 2 1 1 1       3x2   5991858.0 2093861.0 37.728875565325 -122.470432347955 (37.728875565325, -122.470432347955)
5129 253815 2 155 144 Paloma Ave 1 1 1 1       3x2   5991858.0 2093861.0 37.728875565325 -122.470432347955 (37.728875565325, -122.470432347955)
5120 253810 2 3 281 Ralston St 5 9 1 1       3x6   5992187.95019 2089731.22021 37.7175552771373 -122.46899127483299 (37.7175552771373, -122.468991274833)
5161 253809 6 3 2 Garfield St 3 17 1 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5112 253808 6 3 2 Garfield St 2 17 1 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5144 253807 6 25 2 Garfield St 1 17 1 1       10x2   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5103 253796 4 49 100 Scotia Ave 1 1 1 1   11/07/2017 12:00:00 AM 3   Permit Number 779938 6011980.63004 2095004.60122 37.733158617067296 -122.40094689916799 (37.7331586170673, -122.400946899168)
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)
5098 253771 1 21 844 Lombard St 1 1 1 1   11/07/2017 12:00:00 AM 3 3x3   6008309.10382 2120362.6037 37.802580290063 -122.41543500385 (37.802580290063, -122.41543500385)
5179 253770 6 142 234 Carl St 1 8 1 1       3x3 Permit Number 770677 5997066.0 2107091.0 37.7655016335596 -122.453382820195 (37.7655016335596, -122.453382820195)
5091 253769 5 47 100 Raccoon Dr 2 13 1 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
5096 253768 7 47 100 Raccoon Dr 1 13 1 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
5055 253765 6 42 1366 Guerrero St 2 7 1 1       3X3   6005800.0848900005 2101007.6677599996 37.7492949871928 -122.422741198761 (37.7492949871928, -122.422741198761)
5050 253762 4 54 520 08th Ave 1 1 1 1       3x3   5993490.0 2111935.0 37.778596343165496 -122.46610332918101 (37.7785963431655, -122.466103329181)
5078 253759 2 22 330 Twin Peaks Blvd 3 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5072 253758 2 22 330 Twin Peaks Blvd 2 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5061 253757 2 22 330 Twin Peaks Blvd 1 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
4964 253756 4 44 41x Division St 2 1 1 1   11/03/2017 12:00:00 AM 3 5x5   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5007 253755 4 44 41x Division St 1 1 1 1   11/03/2017 12:00:00 AM 3 5x5   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4992 253754 4 11 2x Rhode Island St 8 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4947 253753 4 11 2x Rhode Island St 7 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4951 253752 4 11 2x Rhode Island St 6 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4966 253751 4 11 2x Rhode Island St 5 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4961 253750 4 11 2x Rhode Island St 4 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4970 253749 4 75 2x Rhode Island St 3 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5020 253748 4 75 2x Rhode Island St 2 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5009 253747 4 11 2x Rhode Island St 1 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4958 253746 4 11 1 Henry Adams St 12 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5036 253745 4 11 1 Henry Adams St 11 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5026 253744 4 11 1 Henry Adams St 10 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4932 253743 4 11 1 Henry Adams St 9 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4997 253742 4 11 1 Henry Adams St 8 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4941 253741 4 11 1 Henry Adams St 7 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5032 253740 4 11 1 Henry Adams St 6 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4999 253739 4 11 1 Henry Adams St 5 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5027 253738 4 11 1 Henry Adams St 4 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5010 253737 4 11 1 Henry Adams St 3 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5024 253736 4 11 1 Henry Adams St 2 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4954 253735 4 11 1 Henry Adams St 1 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4955 253734 3 15 350 Girard St 12 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4982 253733 3 15 350 Girard St 11 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4965 253732 3 15 350 Girard St 10 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5004 253731 3 15 350 Girard St 1 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5028 253730 3 15 350 Girard St 8 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4956 253729 3 15 350 Girard St 7 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5037 253728 3 15 350 Girard St 6 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4993 253727 3 15 350 Girard St 5 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4986 253726 3 15 350 Girard St 4 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5021 253725 3 15 350 Girard St 3 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
4968 253724 3 15 350 Girard St 2 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5008 253723 3 177 1X Glenview Dr   3 1 2       3x3   5998487.0 2100314.0 37.746975021233204 -122.447979947083 (37.7469750212332, -122.447979947083)
4925 253721 1 82 260 06th Ave 1 1 1 1   11/02/2017 12:00:00 AM 3 3.5x9 Permit Number 780843 5994045.0 2113761.0 37.7836420503516 -122.464315992766 (37.7836420503516, -122.464315992766)
4923 253718 6 47 227 Madison St 1 7 1 1       3x3   6005690.0 2092595.0 37.726189474375204 -122.422524168298 (37.7261894743752, -122.422524168298)
4922 253717 6 105 4101 Balboa St 1 13 1 1           5982822.0 2110967.0 37.7753172554615 -122.50293574331002 (37.7753172554615, -122.50293574331)
4921 253716 2 21 2959 21st Ave 2 9 1 1       5x15   5989962.0 2095532.0 37.733353897105495 -122.477108940264 (37.7333538971055, -122.477108940264)
4919 253715 2 231 2959 21st Ave 1 9 1 1       5x15   5989962.0 2095532.0 37.733353897105495 -122.477108940264 (37.7333538971055, -122.477108940264)
4875 253714 2 106 199x Boylston St 1 1 1 1       3x3   6009166.0 2094503.0 37.7316239213188 -122.41064246098699 (37.7316239213188, -122.410642460987)
4881 253712 2 128 339 Vienna St 1 7 1 1       Width 3ft   6003970.0 2091429.0 37.7228907132276 -122.428387044746 (37.7228907132276, -122.428387044746)
4898 253711 2 47 1 Monument Way 5 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4884 253710 2 47 1 Monument Way 4 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4891 253709 2 47 1 Monument Way 3 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4906 253708 2 47 1 Monument Way 2 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4893 253707 2 47 1 Monument Way 1 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4889 253706 4 49 98X Shotwell St 3 1 1 1   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137          
4880 253705 4 49 98X Shotwell St 2 1 1 1   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137          
4867 253704 2 186 514 Shrader St 1 5 1 1       3x3   5997547.0 2108721.0 37.7700047558888 -122.451836758395 (37.7700047558888, -122.451836758395)
4866 253703 2 7 1221 Clayton St 1 1 1 1       3x3   5998953.0 2105574.0 37.7614443133046 -122.44674697738199 (37.7614443133046, -122.446746977382)
4863 253702 2 17 293 Capp St 3 1 1 1       3x3   6007203.0 2105623.0 37.76204668432629 -122.41821705685899 (37.7620466843263, -122.418217056859)
4871 253700 2 17 293 Capp St 1 1 1 1       3x3   6007203.0 2105623.0 37.76204668432629 -122.41821705685899 (37.7620466843263, -122.418217056859)
Powered by Datasette · Query took 105.705ms · Data source: data.sfgov.org