sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
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)
4865 253699 2 17 3076 Market St 1 1 1 1       3x3   6000057.0 2105400.0 37.761029556529294 -122.44291621566002 (37.7610295565293, -122.44291621566)
4864 253698 2 21 2200 Ofarrell St 1 5 1 1       Width 0ft   6000775.0 2113124.0 37.7822786323031 -122.440987106931 (37.7822786323031, -122.440987106931)
4870 253696 2 17 235 Laussat St 1 1 1 1       Width 3ft   6003605.0 2109124.0 37.77145640087421 -122.430911009882 (37.7714564008742, -122.430911009882)
4854 253694 2 43 536 Octavia St 2 1 1 1       3x3   6005450.0 2111168.0 37.7771730951376 -122.42467448311199 (37.7771730951376, -122.424674483112)
4859 253693 2 43 536 Octavia St 1 1 1 1       3x3   6005450.0 2111168.0 37.7771730951376 -122.42467448311199 (37.7771730951376, -122.424674483112)
4851 253692 2 187 68 Haight St 1 1 1 1       3x3   6005803.0 2109684.0 37.77311832041121 -122.42334782195499 (37.7731183204112, -122.423347821955)
4855 253691 2 187 60 Haight St 3 1 1 1       3x3   6005848.0 2109690.0 37.7731373345919 -122.42319258754601 (37.7731373345919, -122.423192587546)
4856 253690 2 187 60 Haight St 2 1 1 1       3x3   6005848.0 2109690.0 37.7731373345919 -122.42319258754601 (37.7731373345919, -122.423192587546)
4852 253689 2 187 60 Haight St 1 1 1 1       3x3   6005848.0 2109690.0 37.7731373345919 -122.42319258754601 (37.7731373345919, -122.423192587546)
4844 253688 1 37 999 Natoma St 3 1 1 1 1         6007970.79373767 2109754.69864739 37.7734345505501 -122.415854130267 (37.7734345505501, -122.415854130267)
4849 253684 2 20 767 Burrows St 1 1 1 1       3x3   6009074.0 2092682.0 37.7266186845557 -122.410831962563 (37.7266186845557, -122.410831962563)
4764 253679 2 39 94 Teresita Blvd 1 9 1 1       4x8   5997405.0 2099153.0 37.7437252916895 -122.45163765514201 (37.7437252916895, -122.451637655142)
4747 253677 6 71 199X Kissling St 1 18 1 1       5x10            
4723 253676 1 54 2975 Van Ness Ave 6 5 2 1   10/24/2017 12:00:00 AM 3 3.2x3.75   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
4726 253675 1 54 2975 Van Ness Ave 1 5 2 1   10/24/2017 12:00:00 AM 3 3.2x14.2   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
4736 253671 2 37 1063 Prague St 2 1 1 1       3x3   6001095.0 2086792.0 37.7099954426001 -122.437993315946 (37.7099954426001, -122.437993315946)
4721 253670 2 37 1063 Prague St 1 1 1 1       3x3   6001095.0 2086792.0 37.7099954426001 -122.437993315946 (37.7099954426001, -122.437993315946)
4725 253667 2 226 2 Cabrillo St 2 9 1 1       Width 3ft   5995617.0 2110854.0 37.775750686051005 -122.458666990683 (37.775750686051, -122.458666990683)
4704 253666 2 18 578 07th Ave 2 1 1 1       Width 4ft   5993791.71774 2111566.05198 37.7776007134003 -122.465032776868 (37.7776007134003, -122.465032776868)
4701 253665 2 41 715 Buena Vista Ave 3 5 1 1       3x3   5999814.0 2107879.0 37.767822415683796 -122.443934762725 (37.7678224156838, -122.443934762725)
4707 253664 2 41 715 Buena Vista Ave 2 5 1 1       3x3   5999814.0 2107879.0 37.767822415683796 -122.443934762725 (37.7678224156838, -122.443934762725)
4708 253663 2 41 715 Buena Vista Ave 1 5 1 1       3x3   5999814.0 2107879.0 37.767822415683796 -122.443934762725 (37.7678224156838, -122.443934762725)
4698 253662 2 41 715 Buena Vista Ave 2 1 1 1       3x3   5999814.0 2107879.0 37.767822415683796 -122.443934762725 (37.7678224156838, -122.443934762725)
4710 253661 2 41 715 Buena Vista Ave 1 1 1 1       3x3   5999814.0 2107879.0 37.767822415683796 -122.443934762725 (37.7678224156838, -122.443934762725)
4700 253660 1 37 1545 Pine St 5 1 1 1   10/20/2017 12:00:00 AM 3 4x4   6006535.0 2115598.0 37.789398009701706 -122.421235768961 (37.7893980097017, -122.421235768961)
4703 253659 1 37 1545 Pine St 4 1 1 1   10/20/2017 12:00:00 AM 3 4x4   6006535.0 2115598.0 37.789398009701706 -122.421235768961 (37.7893980097017, -122.421235768961)
4699 253658 1 37 1545 Pine St 3 1 1 1   10/20/2017 12:00:00 AM 3 4x4   6006535.0 2115598.0 37.789398009701706 -122.421235768961 (37.7893980097017, -122.421235768961)
4702 253657 1 37 1545 Pine St 2 1 1 1   10/20/2017 12:00:00 AM 3 4x4   6006535.0 2115598.0 37.789398009701706 -122.421235768961 (37.7893980097017, -122.421235768961)
4709 253656 1 37 1545 Pine St 1 1 1 1   10/20/2017 12:00:00 AM 3 4x4   6006535.0 2115598.0 37.789398009701706 -122.421235768961 (37.7893980097017, -122.421235768961)
4693 253655 2 36 1048 Ingalls St 1 7 1 1       3x3   6018024.0 2094000.0 37.7307354351655 -122.379983340658 (37.7307354351655, -122.379983340658)
4659 253652 6 3 131 Font Blvd 2 9 1 1       10x10   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
Powered by Datasette · Query took 118.542ms · Data source: data.sfgov.org