sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
87541 121665 2 53 100 Montalvo Ave 1 1 1 1       3x6   5993653.0 2099666.0 37.7449182738718 -122.46464831295299 (37.7449182738718, -122.464648312953)
5949 19787 3 53 100 STAIRWAY19 9 1 1 2     24 50ST            
13931 19779 3 53 100 STAIRWAY19 1 1 1 2     18 50ST            
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)
83607 1433 3 53 100X Arguello Blvd 1 1 1 2     30 5X5   5995535.85964 2115388.7214900004 37.7881971563264 -122.459276133553 (37.7881971563264, -122.459276133553)
117946 1434 3 53 100X Arguello Blvd 2 1 1 2     125 3X5   5995535.03638 2115411.50396 37.7882596635004 -122.459280632339 (37.7882596635004, -122.459280632339)
87059 1438 1 53 101X Arguello Blvd 4 1 1 1     35 5   5995477.38208 2115292.8933900003 37.787930676078794 -122.45947151175501 (37.7879306760788, -122.459471511755)
91570 1435 1 53 101X Arguello Blvd 1 1 1 1     35 5   5995475.980819999 2115376.20265 37.7881593402184 -122.459482395726 (37.7881593402184, -122.459482395726)
129385 1437 1 53 101X Arguello Blvd 3 1 1 1     37 5   5995475.83232 2115319.03247 37.78800235781971 -122.459478767425 (37.7880023578197, -122.459478767425)
60841 215593 2 53 103 Sagamore St 1 1 1 1     17 Width 3ft   5995757.42889 2087376.9000799998 37.7112964570463 -122.45648314049801 (37.7112964570463, -122.456483140498)
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)
16388 115471 3 53 10X Junipero Serra Blvd 1 1 1 2     24              
3284 253385 2 53 1100 Golden Gate Ave 1 7 1 1           6004275.0 2112509.0 37.780788718892204 -122.428834805692 (37.7807887188922, -122.428834805692)
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)
94286 19045 3 53 111 Sagamore St 1 1 1 2     35 3X3   5995778.761022701 2087391.1107423 37.7113367008986 -122.45641043862801 (37.7113367008986, -122.456410438628)
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)
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)
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)
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)
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)
124841 11792 3 53 1200X Junipero Serra Blvd 1 1 1 2     24 2   5991118.2706518 2089586.5464946998 37.7170961765154 -122.472678089933 (37.7170961765154, -122.472678089933)
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)
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)
40857 124637 3 53 124 Arguello Blvd   1 1 2     31 Width 5ft   5995537.16304 2115311.02189 37.787983889154205 -122.459265995172 (37.7879838891542, -122.459265995172)
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)
89919 1440 3 53 126 Arguello Blvd 1 1 1 2     100 5X5   5995572.08179 2115303.34583 37.7879648202564 -122.459144627311 (37.7879648202564, -122.459144627311)
147734 180580 2 53 1282 Alemany Blvd 1 1 1 1     15 Width 5ft   6002752.91911 2094123.24132 37.7302195481937 -122.432786610727 (37.7302195481937, -122.432786610727)
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)
79845 933 3 53 1294X Alemany Blvd 1 1 1 2     30 3x3   6002802.17626 2094143.63343 37.7302783338422 -122.432617778446 (37.7302783338422, -122.432617778446)
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)
11261 936 3 53 1309 Alemany Blvd 1 1 1 2   03/09/2016 12:00:00 AM 3 3X3   6002560.70092 2093898.0300900002 37.7295902655741 -122.433435046188 (37.7295902655741, -122.433435046188)
11221 938 3 53 1319 Alemany Blvd 1 1 1 2     22 3X3   6002521.94299 2093864.9840400002 37.729497329615704 -122.433566675476 (37.7294973296157, -122.433566675476)
11865 939 1 53 1325 Alemany Blvd 1 1 1 1     11 3X3   6002500.20649 2093846.32088 37.7294448514873 -122.433640487323 (37.7294448514873, -122.433640487323)
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)
11419 940 3 53 1331 Alemany Blvd 1 1 1 2     24 4x4   6002472.82123 2093812.78737 37.7293512221746 -122.433732764948 (37.7293512221746, -122.433732764948)
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)
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)
87605 1441 3 53 138 Arguello Blvd 1 1 1 2     42 5X5   5995537.91826 2115271.42403 37.7878752075455 -122.459260513654 (37.7878752075455, -122.459260513654)
25535 180581 2 53 1394 Alemany Blvd 1 1 1 1     22 Width 5ft   6002394.23037 2093854.8065099998 37.72946213735921 -122.434007462878 (37.7294621373592, -122.434007462878)
140555 22541 3 53 1396X Alemany Blvd 1 1 1 2     26 3X3   6002380.38751 2093819.80205 37.7293652374447 -122.434052817677 (37.7293652374447, -122.434052817677)
170582 242796 2 53 140 Belgrave Ave 2 2 1 1     23 Width 2ft   5997883.8658300005 2104916.82278 37.7595787374877 -122.450397275322 (37.7595787374877, -122.450397275322)
89901 11849 3 53 1401X Junipero Serra Blvd 2 1 1 2     18 3   5991539.129622 2088082.4465586997 37.712990637147605 -122.471113878415 (37.7129906371476, -122.471113878415)
17410 19053 3 53 141 Sagamore St 1 1 1 2     25 3X3   5995501.70307 2087378.49279 37.711286145417496 -122.457367103015 (37.7112861454175, -122.457367103015)
79283 21830 3 53 1419X Alemany Blvd 2 1 1 2     12 3X6   6002361.46709 2093663.80125 37.7289358208429 -122.43410707985599 (37.7289358208429, -122.434107079856)
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)
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)
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)
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)
9461 22540 1 53 1441X Alemany Blvd 3 1 1 1     19 12X6   6002335.8535400005 2093628.68187 37.728837937275 -122.43419311802099 (37.728837937275, -122.434193118021)
58162 180588 2 53 1447 Alemany Blvd 3 1 1 1     19 Width 5ft   6002392.55611 2093716.4847400002 37.729082242150795 -122.434003367375 (37.7290822421508, -122.434003367375)
11385 4849 1 53 1469X Alemany Blvd 1 1 1 1     16 3X6   6002249.52444 2093516.68285 37.7285255132222 -122.43448355857402 (37.7285255132222, -122.434483558574)
72604 180587 2 53 1473 Alemany Blvd 2 1 1 1     23 Width 4ft   6002172.86661 2093413.1451700001 37.7282368704302 -122.434741167586 (37.7282368704302, -122.434741167586)
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)
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)
107172 4850 3 53 1499X ALEMANY BLVD 2 1 1 2     18 6x6   6002180.0 2093376.0 37.728135283202704 -122.43471385212 (37.7281352832027, -122.43471385212)
106977 11873 1 53 1499X Junipero Serra Blvd 3 1 1 13     30 3   5991566.5284818 2087248.8358641004 37.7107033285334 -122.470958490818 (37.7107033285334, -122.470958490818)
125399 11871 1 53 1499X Junipero Serra Blvd 1 1 1 13     24 3   5991566.5284818 2087248.8358641004 37.7107033285334 -122.470958490818 (37.7107033285334, -122.470958490818)
141240 11874 1 53 1499X Junipero Serra Blvd 4 1 1 13     30 3   5991566.5284818 2087248.8358641004 37.7107033285334 -122.470958490818 (37.7107033285334, -122.470958490818)
48389 182457 2 53 1500 31st Ave 5 2 1 1     27 Width 0ft   5986548.9803 2104732.6813 37.7584178970063 -122.48958488521099 (37.7584178970063, -122.489584885211)
163752 182456 2 53 1500 31st Ave 4 2 1 1     23 Width 0ft   5986548.9803 2104699.0505 37.758325556062104 -122.489582412162 (37.7583255560621, -122.489582412162)
177920 182454 2 53 1500 31st Ave 2 2 1 1     21 Width 0ft   5986553.619 2104615.5531 37.7580965659316 -122.489560229786 (37.7580965659316, -122.489560229786)
18280 19057 3 53 155 Sagamore St 2 1 1 2     35 3X3   5995437.65535 2087381.5397299998 37.7112908326789 -122.45758868696801 (37.7112908326789, -122.457588686968)
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)
85887 117255 3 53 1570 31ST AVE 3 1 1 4           5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
94173 117256 3 53 1570 31ST AVE 4 1 1 4           5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
143144 105784 2 53 1570 31ST AVE 1 1 1 4   04/18/2014 12:00:00 AM     Permit Number 772914 5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
10656 970 3 53 1599 Alemany Blvd 1 1 1 2     38 4X4   6001869.51123 2092911.87236 37.7268432620915 -122.435754028151 (37.7268432620915, -122.435754028151)
12243 974 1 53 1599 Alemany Blvd 5 1 1 1     40 3X5   6001933.9280900005 2093061.6302200002 37.7272581220521 -122.435542049851 (37.7272581220521, -122.435542049851)
10343 978 3 53 1601 Alemany Blvd 1 1 1 2     30 3x3   6001786.79947 2092741.5935099998 37.7263710164051 -122.436027780876 (37.7263710164051, -122.436027780876)
12376 979 3 53 1601 Alemany Blvd 2 1 1 2     45 3X3   6001800.3284 2092768.49495 37.7264456502383 -122.435982936161 (37.7264456502383, -122.435982936161)
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)
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)
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)
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)
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)
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)
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)
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)
Powered by Datasette · Query took 8.664ms · Data source: data.sfgov.org