sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
98696 11137 1 41 2455X Hyde St 1 1 1 3     24 3X3   6006975.507678599 2120876.6023828997 37.8039165535698 -122.420086422377 (37.8039165535698, -122.420086422377)
118702 11141 1 41 2455X Hyde St 5 1 1 3     45 3X3   6006975.507678599 2120876.6023828997 37.8039165535698 -122.420086422377 (37.8039165535698, -122.420086422377)
121329 11140 1 41 2455X Hyde St 4 1 1 3     30 3X3   6006975.507678599 2120876.6023828997 37.8039165535698 -122.420086422377 (37.8039165535698, -122.420086422377)
122047 11138 1 41 2455X Hyde St 2 1 1 3     45 3X3   6006975.507678599 2120876.6023828997 37.8039165535698 -122.420086422377 (37.8039165535698, -122.420086422377)
50090 13071 1 80 645X Lombard St 1 1 1 3   09/27/2006 12:00:00 AM 3 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
81488 13074 1 16 645X Lombard St 4 1 1 3     18 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
91375 13073 1 16 645X Lombard St 3 1 1 3     18 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
96845 13075 1 80 645X Lombard St 5 1 1 3   01/22/2015 12:00:00 AM 3 3X3 Permit Number 774508 6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
107446 13077 1 43 645X Lombard St 7 1 1 3     18 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
125041 13072 1 80 645X Lombard St 2 1 1 3   09/27/2008 12:00:00 AM 3 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
83060 116290 2 127 1901X Powell St 6 1 1 3           6009504.70132 2120333.4249299997 37.802567299543206 -122.41129555893 (37.8025672995432, -122.41129555893)
84099 116291 2 127 1901X Powell St 7 1 1 3           6009504.70132 2120333.4249299997 37.802567299543206 -122.41129555893 (37.8025672995432, -122.41129555893)
88440 116286 2 127 1901X Powell St 2 1 1 3           6009504.70132 2120333.4249299997 37.802567299543206 -122.41129555893 (37.8025672995432, -122.41129555893)
92543 116287 2 127 1901X Powell St 3 1 1 3           6009504.70132 2120333.4249299997 37.802567299543206 -122.41129555893 (37.8025672995432, -122.41129555893)
94547 116285 2 127 1901X Powell St 1 1 1 3           6009504.70132 2120333.4249299997 37.802567299543206 -122.41129555893 (37.8025672995432, -122.41129555893)
108909 116293 2 127 1901X Powell St 9 1 1 3           6009504.70132 2120333.4249299997 37.802567299543206 -122.41129555893 (37.8025672995432, -122.41129555893)
111444 116288 2 127 1901X Powell St 4 1 1 3           6009504.70132 2120333.4249299997 37.802567299543206 -122.41129555893 (37.8025672995432, -122.41129555893)
123347 116289 2 127 1901X Powell St 5 1 1 3           6009504.70132 2120333.4249299997 37.802567299543206 -122.41129555893 (37.8025672995432, -122.41129555893)
139446 116292 2 127 1901X Powell St 8 1 1 3           6009504.70132 2120333.4249299997 37.802567299543206 -122.41129555893 (37.8025672995432, -122.41129555893)
96202 112131 1 44 850X COLUMBUS AVE 5 1 1 3     3 3x6   6008928.0 2120320.0 37.8024980771426 -122.41329029104999 (37.8024980771426, -122.41329029105)
106111 112128 1 44 850X COLUMBUS AVE 2 1 1 3     3 3x6   6008928.0 2120320.0 37.8024980771426 -122.41329029104999 (37.8024980771426, -122.41329029105)
141984 112129 1 44 850X COLUMBUS AVE 3 1 1 3     3 3x6   6008928.0 2120320.0 37.8024980771426 -122.41329029104999 (37.8024980771426, -122.41329029105)
144403 112127 1 44 850X COLUMBUS AVE 1 1 1 3     3 3x6   6008928.0 2120320.0 37.8024980771426 -122.41329029104999 (37.8024980771426, -122.41329029105)
145495 112130 1 44 850X COLUMBUS AVE 4 1 1 3     3 3x6   6008928.0 2120320.0 37.8024980771426 -122.41329029104999 (37.8024980771426, -122.41329029105)
80868 116284 2 54 700X Greenwich St 11 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
82559 116276 2 54 700X Greenwich St 3 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
84777 116279 2 54 700X Greenwich St 6 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
92470 116283 2 54 700X Greenwich St 10 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
98757 116282 2 54 700X Greenwich St 9 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
116105 116281 2 54 700X Greenwich St 8 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
117089 116277 2 54 700X Greenwich St 4 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
138269 116274 2 54 700X Greenwich St 1 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
138579 116278 2 54 700X Greenwich St 5 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
140188 116280 2 54 700X Greenwich St 7 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
141239 116275 2 54 700X Greenwich St 2 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
93919 96976 2 143 390X Filbert St 1 3 1 3     28     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116)
3904 4665 1 59 600X Columbus Ave 8 1 1 3     100 5X5   6009675.3838 2119664.5956 37.8007404309352 -122.410657649881 (37.8007404309352, -122.410657649881)
5145 4664 1 59 600X Columbus Ave 7 1 1 3     90 5X5   6009692.467999999 2119649.5892 37.8007001848924 -122.410597470914 (37.8007001848924, -122.410597470914)
7037 4663 1 59 600X Columbus Ave 6 1 1 3     60 5X5   6009710.0139 2119634.3519 37.8006593307081 -122.41053567802 (37.8006593307081, -122.41053567802)
8289 4662 1 59 600X Columbus Ave 5 1 1 3     80 5X5   6009727.0981 2119617.2678 37.8006133797513 -122.41047535239099 (37.8006133797513, -122.410475352391)
6968 4661 1 59 600X Columbus Ave 4 1 1 3     90 5X5   6009739.5649 2119605.2627 37.8005811155969 -122.41043136381901 (37.8005811155969, -122.410431363819)
7939 4660 1 59 600X Columbus Ave 3 1 1 3     125 5X5   6009761.7282 2119587.7167 37.8005341810425 -122.410353429867 (37.8005341810425, -122.410353429867)
4255 4659 1 59 600X Columbus Ave 2 1 1 3     90 5X5   6009780.1976 2119571.0943 37.800489575353104 -122.410288343699 (37.8004895753531, -122.410288343699)
7851 4658 1 59 600X Columbus Ave 1 1 1 3     34 5X5   6009795.4348 2119557.2423 37.8004523952872 -122.410234638074 (37.8004523952872, -122.410234638074)
7109 18519 1 59 1700X Powell St 1 1 1 3     30 3X3   6009627.5943 2119520.0726 37.800340927010296 -122.410812809398 (37.8003409270103, -122.410812809398)
81016 27773 1 15 199X The Embarcadero 6 1 1 3   12/01/2000 12:00:00 AM 6     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
84542 27772 1 15 199X The Embarcadero 5 1 1 3   12/01/2000 12:00:00 AM 6     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
88004 27771 1 15 199X The Embarcadero 4 1 1 3   12/01/2000 12:00:00 AM 6     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
89735 27770 1 15 199X The Embarcadero 3 1 1 3   12/01/2000 12:00:00 AM 6     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
105834 27768 1 15 199X The Embarcadero 1 1 1 3   12/10/2000 12:00:00 AM 6     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
117568 27769 1 15 199X The Embarcadero 2 1 1 3   12/01/2000 12:00:00 AM 6     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
81037 101512 3 15 240X DRUMM ST 3 1 1 3       3x3   6013870.0 2117910.0 37.796157009088 -122.396019403228 (37.796157009088, -122.396019403228)
92516 101511 3 15 240X DRUMM ST 1 1 1 3       3x3   6013870.0 2117910.0 37.796157009088 -122.396019403228 (37.796157009088, -122.396019403228)
109942 101514 3 127 240X DRUMM ST 5 1 1 3   11/30/2012 12:00:00 AM   3x3 Permit Number 769442 6013870.0 2117910.0 37.796157009088 -122.396019403228 (37.796157009088, -122.396019403228)
128867 101513 3 15 240X DRUMM ST 4 1 1 3       3x3   6013870.0 2117910.0 37.796157009088 -122.396019403228 (37.796157009088, -122.396019403228)
88615 100034 3 18 1199@Washington Mason St 2 1 1 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
112616 100037 3 18 1199@Washington Mason St 5 1 1 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
116126 100035 3 18 1199@Washington Mason St 3 1 1 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
120980 100033 3 18 1199 Mason St 1 1 1 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
124487 100032 3 18 1199 Mason St 5 1 1 3   08/02/2012 12:00:00 AM   3x3 Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
144094 100036 3 18 1199@Washington Mason St 4 1 1 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
44141 88407 3 18 1199 Mason St 1 1 1 3   08/02/2012 12:00:00 AM 4 3x3 Permit Number 769129 6009407.88363 2117347.72867 37.7943638829406 -122.411419542685 (37.7943638829406, -122.411419542685)
182553 88408 3 18 1199 Mason St 2 1 1 3   08/02/2012 12:00:00 AM 5 3x3 Permit Number 769129 6009412.43491 2117319.72378 37.794287243625604 -122.411401815264 (37.7942872436256, -122.411401815264)
38128 88409 3 18 1199 Mason St 3 1 1 3   08/02/2012 12:00:00 AM 4 3x3 Permit Number 769129 6009413.9789 2117291.03714 37.7942085637169 -122.41139444529 (37.7942085637169, -122.41139444529)
66520 100031 3 18 1199 Mason St 4 1 1 3   08/02/2012 12:00:00 AM 4 3x3 Permit Number 769129 6009418.42249 2117262.251 37.7941297732341 -122.411377035334 (37.7941297732341, -122.411377035334)
7403 107472 2 26 1464 Washington St 1 1 1 3     12 3x3   6007706.0171300005 2117181.73808 37.793812512193604 -122.417296448573 (37.7938125121936, -122.417296448573)
152223 115560 2 26 1464 Washington St 2 1 1 3     9 3x3   6007697.45646 2117180.95447 37.793809878961895 -122.417326013802 (37.7938098789619, -122.417326013802)
113933 100787 1 17 2001 Washington St 11 1 1 3           6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639)
1909 125218 1 5 2101 Washington St 21 1 1 3     13 Width 4ft   6005090.35688 2116771.11072 37.7925375271472 -122.42631763077499 (37.7925375271472, -122.426317630775)
79670 100784 1 17 2101 Washington St 6 1 1 3           6004647.8 2116722.2 37.7923782050701 -122.42784540593 (37.7923782050701, -122.42784540593)
115457 100785 1 17 2101 Washington St 8 1 1 3           6004647.8 2116722.2 37.7923782050701 -122.42784540593 (37.7923782050701, -122.42784540593)
121557 100783 1 17 2101X Washington St 5 1 1 3           6004647.8 2116722.2 37.7923782050701 -122.42784540593 (37.7923782050701, -122.42784540593)
123011 100786 1 17 2101 Washington St 9 1 1 3           6004647.8 2116722.2 37.7923782050701 -122.42784540593 (37.7923782050701, -122.42784540593)
81054 2804 1 15 1070X California St 1 1 1 3     50 3X3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
88529 2808 1 15 1070X California St 5 1 1 3     50 3x3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
109159 2806 1 15 1070X California St 3 1 1 3     45 3X3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
115677 2805 1 15 1070X California St 2 1 1 3     65 3X3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
126954 2807 1 15 1070X California St 4 1 1 3     45 3X3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
139043 2809 1 15 1070X California St 6 1 1 3     35 3X3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
87999 9918 1 108 1905X Gough St 2 1 1 3     20 3X3 Permit Number 768908 6005198.982724099 2116181.2464075 37.7909240477297 -122.425899774562 (37.7909240477297, -122.425899774562)
92525 9919 1 108 1905X Gough St 3 1 1 3     20 3X3 Permit Number 768908 6005198.982724099 2116181.2464075 37.7909240477297 -122.425899774562 (37.7909240477297, -122.425899774562)
97157 9917 1 43 1905X Gough St 1 1 1 3     30 3x3 Permit Number 768908 6005198.982724099 2116181.2464075 37.7909240477297 -122.425899774562 (37.7909240477297, -122.425899774562)
81330 116229 2 127 1699 Steiner St 4 1 1 3           6002584.4 2114045.3 37.7849111787577 -122.434793299622 (37.7849111787577, -122.434793299622)
98431 116227 2 127 1699 Steiner St 2 1 1 3           6002584.4 2114045.3 37.7849111787577 -122.434793299622 (37.7849111787577, -122.434793299622)
110949 116228 2 127 1699 Steiner St 3 1 1 3           6002584.4 2114045.3 37.7849111787577 -122.434793299622 (37.7849111787577, -122.434793299622)
145449 20228 1 15 1699 Steiner St 1 1 1 3     18 3X3   6002579.480222 2114044.5496622 37.784908839203204 -122.43481026677 (37.7849088392032, -122.43481026677)
84242 99240 2 43 560X Ellis St 1 1 1 3     10 4x4   6008281.0 2113828.0 37.784636297853105 -122.415069452341 (37.7846362978531, -122.415069452341)
7636 99241 2 32 560X Ellis St 2 1 1 3     10 4x4   6008235.1228 2113825.75072 37.7846275436788 -122.415228013286 (37.7846275436788, -122.415228013286)
7647 99242 2 32 560X Ellis St 3 1 1 3     8 4x4   6008195.716580001 2113819.71845 37.7846087658129 -122.415363918808 (37.7846087658129, -122.415363918808)
91001 99244 2 43 570 Ellis St 2 1 1 3     11 4x4   6008204.0 2113818.0 37.784604512923 -122.41533513918002 (37.784604512923, -122.41533513918)
122770 99243 2 43 570 Ellis St 1 1 1 3     9 4x4   6008204.0 2113818.0 37.784604512923 -122.41533513918002 (37.784604512923, -122.41533513918)
79113 24925 1 316 2099X Post St 1 1 1 3   02/09/1996 12:00:00 AM 6 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
79616 24935 1 5 2099X Post St 12 1 1 3     3 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
82591 24927 1 5 2099X Post St 3 1 1 3     36 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
83248 24932 1 5 2099X Post St 8 1 1 3   02/22/1996 12:00:00 AM 18 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
93328 24934 1 5 2099X Post St 10 1 1 3   09/28/1999 12:00:00 AM 24 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
93902 26750 1 316 2099X Post St 15 1 1 3   04/05/2003 12:00:00 AM 3 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
96268 26751 1 316 2099X Post St 16 1 1 3   04/05/2003 12:00:00 AM 3 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
97103 24936 1 134 2099X Post St 17 1 1 3   12/21/2007 12:00:00 AM 36 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
106916 26749 1 134 2099X Post St 11 1 1 3   09/28/1999 12:00:00 AM 3 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
107042 24929 1 5 2099X Post St 5 1 1 3     24 3X3   6001850.6502853 2113928.178638 37.7845479080691 -122.437323443199 (37.7845479080691, -122.437323443199)
Powered by Datasette · Query took 8.16ms · Data source: data.sfgov.org