sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
38305 116138 2 53 1601X Armstrong Ave 10 1 1 3     30     6014404.0852 2092434.1919 37.7262356791342 -122.39238857399599 (37.7262356791342, -122.392388573996)
186517 199851 2 53 1603 Armstrong Ave 9 1 1 1     30 Width 0ft   6014366.3226 2092462.8184 37.7263121847089 -122.392521119846 (37.7263121847089, -122.392521119846)
175293 199849 2 53 1607 Armstrong Ave 7 1 1 1     28 Width 0ft   6014322.4694 2092498.1446 37.7264067479006 -122.392675189528 (37.7264067479006, -122.392675189528)
30230 199847 2 53 1611 Armstrong Ave 5 1 1 1     30 Width 0ft   6014254.2532 2092550.5249 37.7265467847844 -122.392914674805 (37.7265467847844, -122.392914674805)
131994 199846 2 53 1613 Armstrong Ave 4 1 1 1     30 Width 0ft   6014210.3999 2092579.1513 37.726622951149395 -122.393068277245 (37.7266229511494, -122.393068277245)
57951 199844 2 53 1617 Armstrong Ave 2 1 1 1     32 Width 0ft   6014142.1837 2092625.4409 37.7267462633936 -122.39330733792801 (37.7267462633936, -122.393307337928)
69286 58907 1 53 354 Peninsula Ave 1 1 1 1   03/07/1980 12:00:00 AM 29   Permit Number 18182 6012260.63611 2086890.34143 37.7108941228427 -122.39940938545601 (37.7108941228427, -122.399409385456)
1790 26629 3 53 1099X Bay Shore Blvd 2 1 1 2   06/02/2017 12:00:00 AM 6 3x3   6011248.5682 2094191.84655 37.7308861005042 -122.403420689108 (37.7308861005042, -122.403420689108)
30170 180579 2 53 2500 Bay Shore Blvd 3 1 1 1     21 Width 4ft   6010790.74354 2086511.28723 37.7097712796836 -122.404463040238 (37.7097712796836, -122.404463040238)
7781 16359 3 53 1306x Montgomery St 3 11 1 2     18 8   6011459.70542 2119848.6083 37.8013455628052 -122.404496083149 (37.8013455628052, -122.404496083149)
166993 107483 3 53 1306x Montgomery St 6 11 1 2     17     6011458.52251 2119859.64432 37.8013757989196 -122.404500953851 (37.8013757989196, -122.404500953851)
83779 1867 3 53 2555 Bay Shore Blvd 8 1 1 2     18 3x3   6010748.9210869 2086419.1045134 37.7095158271004 -122.404601102054 (37.7095158271004, -122.404601102054)
150428 242795 2 53 1671 Peralta Ave 1 1 1 1     6 Width 3ft   6009731.24755 2099988.4352599997 37.7467174150944 -122.409075193563 (37.7467174150944, -122.409075193563)
24510 142976 2 53 392 CHESTNUT ST 1 1 1 1     17 Width 0ft   6009963.6556 2120937.6931 37.80425219968421 -122.409750018417 (37.8042521996842, -122.409750018417)
180677 102615 2 53 392 Chestnut St 2 1 1 1     16 3x3   6009946.866 2120935.8276 37.804246136595296 -122.409807988636 (37.8042461365953, -122.409807988636)
187353 142975 2 53 2000 Stockton St 1 1 1 1     15 Width 0ft   6009927.4614 2120951.259 37.804287419917294 -122.40987623003299 (37.8042874199173, -122.409876230033)
184419 142972 2 53 2010 Stockton St 2 1 1 1     19 Width 0ft   6009915.1882 2121025.8734 37.804491604686206 -122.409923973004 (37.8044916046862, -122.409923973004)
36173 137082 2 53 1627 Taylor St 2 1 1 1     3 Width 3ft   6008777.375519999 2118389.76877 37.7971896841052 -122.413674921875 (37.7971896841052, -122.413674921875)
175491 137081 2 53 1627 Taylor St 1 1 1 1     4 Width 3ft   6008775.75798 2118410.46159 37.7972464106437 -122.413681983361 (37.7972464106437, -122.413681983361)
179443 137080 2 53 1639 Taylor St 6 1 1 1     3 Width 3ft   6008758.62885 2118554.07509 37.79763977591279 -122.41375141818999 (37.7976397759128, -122.41375141819)
171388 137079 2 53 1639 Taylor St 5 1 1 1     3 Width 3ft   6008755.558119999 2118570.22529 37.7976839479247 -122.413763186745 (37.7976839479247, -122.413763186745)
33957 137078 2 53 1639 Taylor St 4 1 1 1     4 Width 3ft   6008753.16727 2118586.36158 37.7977281199218 -122.413772601749 (37.7977281199218, -122.413772601749)
147002 83273 2 53 1639X Taylor St 3 1 1 1 1 01/21/2006 12:00:00 AM 3     6008750.425980001 2118601.9970299997 37.797770897055294 -122.413783193943 (37.7977708970553, -122.413783193943)
93005 7472 1 53 2637 Folsom St 2 1 1 1     60 4X4   6008329.443080001 2103061.47825 37.75507667179011 -122.41413988378599 (37.7550766717901, -122.414139883786)
125401 7486 1 53 2679X Folsom St 1 1 1 1     18 3X3   6008312.8272 2102836.8814 37.754459046451004 -122.414181457232 (37.754459046451, -122.414181457232)
86707 7464 1 53 2599 Folsom St 1 1 1 1     60 3X3   6008286.46562 2103308.5385 37.7557526290701 -122.41430599230301 (37.7557526290701, -122.414305992303)
95650 7425 1 53 2501 Folsom St 1 1 1 1     60 3X3   6008288.6679 2103807.30911 37.7571222633799 -122.414333665067 (37.7571222633799, -122.414333665067)
19676 7475 3 53 2650X Folsom St 3 1 1 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
77659 7482 3 53 2650X Folsom St 10 1 1 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
86841 7477 3 53 2650X Folsom St 5 1 1 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
87254 7476 3 53 2650X Folsom St 4 1 1 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
94466 7473 3 53 2650X Folsom St 1 1 1 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
106471 7479 3 53 2650X Folsom St 7 1 1 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
112238 7474 3 53 2650X Folsom St 2 1 1 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
114677 7481 3 53 2650X Folsom St 9 1 1 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
50637 117189 1 53 1335 Washington St 2 1 1 1     12 3x3   6008262.17379 2117224.41185 37.793960957890896 -122.415375111785 (37.7939609578909, -122.415375111785)
54703 39229 1 53 1335 Washington St 1 1 1 1   12/04/1998 12:00:00 AM 15 3x3 Permit Number 40871 6008226.63206 2117220.6849599998 37.793948727108 -122.41549782608699 (37.793948727108, -122.415497826087)
46257 97505 2 53 20X 10th St 2 1 1 1   10/18/2011 12:00:00 AM 12 3x3 Permit Number 768079 6007672.0 2110712.0 37.7760462700595 -122.416955543158 (37.7760462700595, -122.416955543158)
139773 97504 2 53 20X 10th St 1 1 1 1   10/18/2011 12:00:00 AM 12 3x3 Permit Number 768079 6007672.0 2110712.0 37.7760462700595 -122.416955543158 (37.7760462700595, -122.416955543158)
19243 39175 1 53 750 South Van Ness Ave 1 1 1 1 1 07/27/2002 12:00:00 AM 10   Permit Number 40836 6007492.94598473 2105289.21429212 37.7611465023321 -122.417190590059 (37.7611465023321, -122.417190590059)
61015 242794 3 53 2x Coso Ave 4 3 1 2     30     6007112.52178 2099889.35747 37.746298321115 -122.418123483128 (37.746298321115, -122.418123483128)
57260 242793 3 53 2x Coso Ave 1 3 1 2     30 Width 9ft   6007083.58829 2099965.0449 37.746504513177 -122.418228897148 (37.746504513177, -122.418228897148)
45548 45657 1 53 1330 Union St 1 1 1 1   08/13/2001 12:00:00 AM 18   Permit Number 44353 6006609.23369 2119082.98627 37.798971095388396 -122.421226497612 (37.7989710953884, -122.421226497612)
19652 99912 2 53 3751X Fair Oaks St 1 1 1 1       3x3   6005509.050559999 2101091.11643 37.7495076933522 -122.42375353501998 (37.7495076933522, -122.42375353502)
77976 99913 2 53 3751X Fair Oaks St 2 1 1 1       3x3 Permit Number 768933 6005509.050559999 2101091.11643 37.7495076933522 -122.42375353501998 (37.7495076933522, -122.42375353502)
121533 93024 1 53 394 Fair Oaks St 3 1 1 1         Tree 3 on 25th St 6005476.0 2101410.0 37.750381408432204 -122.42389049729601 (37.7503814084322, -122.423890497296)
144992 93023 1 53 394 Fair Oaks St 2 1 1 1         Tree 2 on 25th St 6005476.0 2101410.0 37.750381408432204 -122.42389049729601 (37.7503814084322, -122.423890497296)
109973 99911 2 53 400 Fair Oaks St 1 1 1 1       3x3   6005460.7 2101331.3 37.750164452601794 -122.42393781012501 (37.7501644526018, -122.423937810125)
119155 99894 6 53 1636 Bush St 1 7 1 1   07/11/2012 12:00:00 AM     Permit Number 768849 6005665.0 2115204.0 37.7882670981083 -122.424217840789 (37.7882670981083, -122.424217840789)
60171 242791 2 53 1001 San Jose Ave 14 7 1 1     5     6005175.70924 2096892.8816200001 37.7379614744454 -122.424607638258 (37.7379614744454, -122.424607638258)
144278 2933 3 53 1834 California St 6 1 1 2   05/29/1997 12:00:00 AM 7 3X3   6005503.04257 2115905.51621 37.7901841403418 -122.424828114668 (37.7901841403418, -122.424828114668)
88227 51907 1 53 157 Day St 2 1 1 1   07/18/2005 12:00:00 AM     Permit Number 48113 6004926.17092668 2098691.36646376 37.7428856098168 -122.42559837996599 (37.7428856098168, -122.425598379966)
98822 51906 1 53 157 Day St 1 1 1 1   07/18/2005 12:00:00 AM     Permit Number 48113 6004926.17092668 2098691.36646376 37.7428856098168 -122.42559837996599 (37.7428856098168, -122.425598379966)
117028 137076 2 53 689 Hayes St 4 4 1 1     19 Width 4ft   6004731.627309999 2110853.90859 37.776270079140396 -122.427137185641 (37.7762700791404, -122.427137185641)
34624 142237 2 53 689 HAYES ST 4 1 1 1     18 Width 0ft   6004726.9033 2110859.9695 37.7762864537737 -122.42715395911101 (37.7762864537737, -122.427153959111)
26368 137075 2 53 689 Hayes St 1 4 1 1     24 Width 5ft   6004617.552730001 2110839.21576 37.776223284701 -122.42753075415001 (37.776223284701, -122.42753075415)
156335 142234 2 53 689 HAYES ST 1 1 1 1     22 Width 0ft   6004609.2702 2110836.2012 37.77621453898529 -122.427559190874 (37.7762145389853, -122.427559190874)
40956 242792 2 53 1200 San Jose Ave 12 7 1 1     37     6003987.76148 2095934.3227099997 37.7352623274905 -122.42864664822399 (37.7352623274905, -122.428646648224)
99073 108311 2 53 439x ARLINGTON ST 1 13 1 1           6003949.9 2096014.9 37.7354814316621 -122.42878329168998 (37.7354814316621, -122.42878329169)
3284 253385 2 53 1100 Golden Gate Ave 1 7 1 1           6004275.0 2112509.0 37.780788718892204 -122.428834805692 (37.7807887188922, -122.428834805692)
166700 180582 2 53 1110 Alemany Blvd 1 1 1 1     26 Width 4ft   6003793.49913 2094480.4258 37.7312592588934 -122.429214647441 (37.7312592588934, -122.429214647441)
74958 180583 2 53 1114 Alemany Blvd 1 1 1 1     25 Width 4ft   6003761.56491 2094470.84041 37.731231131690706 -122.42932436652599 (37.7312311316907, -122.429324366526)
75801 180584 2 53 1114 Alemany Blvd 2 1 1 1     22 Width 4ft   6003732.95256 2094463.1481400002 37.7312083905422 -122.42942273618601 (37.7312083905422, -122.429422736186)
113835 5927 3 53 1335 Eddy St 3 1 1 2   07/26/2016 12:00:00 AM 12 4X4   6004029.334559999 2112693.29822 37.781280848415 -122.42969783017901 (37.781280848415, -122.429697830179)
88173 6271 1 53 1420X Ellis St 1 1 1 1     18 4X4   6004021.46971 2113238.82139 37.782778273754104 -122.429763959937 (37.7827782737541, -122.429763959937)
72396 180590 2 53 1159 Alemany Blvd 3 1 1 1     24 Width 4ft   6003628.44812 2094335.41976 37.7308517598817 -122.429774919684 (37.7308517598817, -122.429774919684)
89521 6272 1 53 1420X Ellis St 2 1 1 1     18 4X4   6003992.005369999 2113234.0209999997 37.782763424573005 -122.429865551596 (37.782763424573, -122.429865551596)
95703 6273 1 53 1420X Ellis St 3 1 1 1     18 4X4   6003962.5783400005 2113230.61655 37.78275241032 -122.42996711374701 (37.78275241032, -122.429967113747)
106502 6275 3 53 1421X Ellis St 1 1 1 2     12 4X4   6003957.217759999 2113179.66455 37.782612205263796 -122.429982023346 (37.7826122052638, -122.429982023346)
107061 6276 3 53 1421X Ellis St 2 1 1 2     12 4X4   6003957.217759999 2113179.66455 37.782612205263796 -122.429982023346 (37.7826122052638, -122.429982023346)
79677 10721 3 53 50X Hollis St 8 1 1 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
80768 10719 3 53 50X Hollis St 6 1 1 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
92480 10715 3 53 50X Hollis St 2 1 1 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
96651 10718 3 53 50X Hollis St 5 1 1 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
100033 10714 3 53 50X Hollis St 1 1 1 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
103593 10720 3 53 50X Hollis St 7 1 1 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
115302 10716 3 53 50X Hollis St 3 1 1 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
122430 10717 3 53 50X Hollis St 4 1 1 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
124683 10723 3 53 50X Hollis St 10 1 1 2     3 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
128283 10722 3 53 50X Hollis St 9 1 1 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
10333 899 3 53 1161 Alemany Blvd 1 1 1 2     24 4X5   6003541.15178 2094307.19105 37.7307693064514 -122.43007470418002 (37.7307693064514, -122.43007470418)
11932 900 3 53 1167 Alemany Blvd 1 1 1 2     25 3X3   6003509.8986599995 2094295.64409 37.7307358309933 -122.43018192766 (37.7307358309933, -122.43018192766)
89099 6281 3 53 1475 Ellis St 4 1 1 2     12 4X4   6003892.9969 2113024.38483 37.7821822086902 -122.43019311854601 (37.7821822086902, -122.430193118546)
93750 6280 3 53 1475 Ellis St 3 1 1 2     12 4X4   6003892.9969 2113024.38483 37.7821822086902 -122.43019311854601 (37.7821822086902, -122.430193118546)
99544 6284 3 53 1475 Ellis St 7 1 1 2     12 4X4   6003892.9969 2113024.38483 37.7821822086902 -122.43019311854601 (37.7821822086902, -122.430193118546)
101312 6282 3 53 1475 Ellis St 5 1 1 2     12 4X4   6003892.9969 2113024.38483 37.7821822086902 -122.43019311854601 (37.7821822086902, -122.430193118546)
115146 26486 3 53 1475 Ellis St 8 1 1 2     12 4X4   6003892.9969 2113024.38483 37.7821822086902 -122.43019311854601 (37.7821822086902, -122.430193118546)
145390 6278 3 53 1475 Ellis St 1 1 1 2     12 4X4   6003892.9969 2113024.38483 37.7821822086902 -122.43019311854601 (37.7821822086902, -122.430193118546)
111027 6274 3 53 1420X Ellis St 4 1 1 2     18 4X4   6003886.01337 2113219.41254 37.782717310542395 -122.430231196525 (37.7827173105424, -122.430231196525)
81090 6279 3 53 1475 Ellis St 2 1 1 2     12 4X4   6003832.24761 2113162.85488 37.782558971887205 -122.430413166544 (37.7825589718872, -122.430413166544)
9213 885 1 53 1100X ALEMANY BLVD 3 1 1 1     20     6003437.0 2094359.0 37.7309056628368 -122.43043846836599 (37.7309056628368, -122.430438468366)
9367 884 1 53 1100X ALEMANY BLVD 2 1 1 1   04/22/2008 12:00:00 AM 24 3X6   6003437.0 2094359.0 37.7309056628368 -122.43043846836599 (37.7309056628368, -122.430438468366)
88057 883 3 53 1100X ALEMANY BLVD 1 1 1 2     30 3X6   6003437.0 2094359.0 37.7309056628368 -122.43043846836599 (37.7309056628368, -122.430438468366)
9059 896 1 53 1155X Alemany Blvd 3 1 1 1     19 4X4   6003365.90456 2094243.1413900002 37.730583513638294 -122.43067599245 (37.7305835136383, -122.43067599245)
12842 912 1 53 1229 Alemany Blvd 1 1 1 1     25 4X4   6003089.95028 2094152.4368200002 37.730318821659296 -122.431623533692 (37.7303188216593, -122.431623533692)
8324 106867 2 53 1974 Union St 1 1 1 1     14 3x3   6003576.11959 2118663.726 37.797648453467396 -122.431692125901 (37.7976484534674, -122.431692125901)
11189 914 1 53 1233 Alemany Blvd 1 1 1 1     25 3X5   6003058.45033 2094142.0195400002 37.730288432643796 -122.431731689776 (37.7302884326438, -122.431731689776)
11782 915 3 53 1237 Alemany Blvd 1 1 1 2     30 3X3   6003037.510530001 2094134.6631900002 37.7302670467787 -122.431803556408 (37.7302670467787, -122.431803556408)
170241 180589 2 53 1241 Alemany Blvd 1 1 1 1     20 Width 4ft   6003010.99045 2094126.1928400001 37.7302422857354 -122.431894635246 (37.7302422857354, -122.431894635246)
141047 917 3 53 1245 Alemany Blvd 1 1 1 2     35 3X3   6003003.64796 2094102.5381599998 37.730176919086496 -122.43191833078899 (37.7301769190865, -122.431918330789)
82113 929 3 53 1286X Alemany Blvd 1 1 1 2     25 3x3   6002834.53778 2094157.0386599998 37.73031697676271 -122.432506857514 (37.7303169767627, -122.432506857514)
Powered by Datasette · Query took 7.183ms · Data source: data.sfgov.org