sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3087 19650 3 36 100 STAIRWAY5 49 1 1 2     12 60ST            
4862 19656 3 36 100 STAIRWAY5 55 1 1 2     18 60ST            
5896 19680 3 36 100 STAIRWAY5 79 1 1 2     12 60ST            
5976 19649 3 36 100 STAIRWAY5 48 1 1 2     12 60ST            
6914 19672 3 36 100 STAIRWAY5 71 1 1 2     12 60ST            
7103 19675 3 36 100 STAIRWAY5 74 1 1 2     12 60ST            
7153 19677 3 36 100 STAIRWAY5 76 1 1 2     12 60ST            
7446 19683 3 36 100 STAIRWAY5 82 1 1 2     12 60ST            
9546 19678 3 36 100 STAIRWAY5 77 1 1 2     12 60ST            
9875 19651 3 36 100 STAIRWAY5 50 1 1 2     12 60ST            
10475 19661 3 36 100 STAIRWAY5 60 1 1 2     12 60ST            
12748 19671 3 36 100 STAIRWAY5 70 1 1 2     12 60ST            
14057 19674 3 36 100 STAIRWAY5 73 1 1 2     12 60ST            
14729 19657 3 36 100 STAIRWAY5 56 1 1 2     18 60ST            
15686 19660 3 36 100 STAIRWAY5 59 1 1 2     18 60ST            
16120 19653 3 36 100 STAIRWAY5 52 1 1 2     12 60ST            
12006 1294 3 36 4000X Alemany Blvd 2 11 1 2     25 10   5991953.08243 2087152.92109 37.7104623187479 -122.469615507754 (37.7104623187479, -122.469615507754)
10605 1293 3 36 4000X Alemany Blvd 1 11 1 2     50 10   5991961.87152 2087160.6390900002 37.7104840184951 -122.46958569253701 (37.7104840184951, -122.469585692537)
109964 1773 3 36 2000X Bay Shore Blvd 14 1 1 2     36 4X4   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
83866 11477 3 36 10X Jennings St 3 1 1 2     18 3X3   6012892.419875 2089345.335603 37.7176702433836 -122.397397833393 (37.7176702433836, -122.397397833393)
112318 11486 3 36 10X Jennings St 12 1 1 2     18 3X3   6012892.419875 2089345.335603 37.7176702433836 -122.397397833393 (37.7176702433836, -122.397397833393)
118292 11478 3 36 10X Jennings St 4 1 1 2     12 3X3   6012892.419875 2089345.335603 37.7176702433836 -122.397397833393 (37.7176702433836, -122.397397833393)
124892 11481 3 36 10X Jennings St 7 1 1 2     18 3X3   6012892.419875 2089345.335603 37.7176702433836 -122.397397833393 (37.7176702433836, -122.397397833393)
42536 176390 3 36 700x Mansell St 37 11 1 2     21 Width 0ft   6009150.9462 2089957.5754799999 37.7191423008581 -122.410373676998 (37.7191423008581, -122.410373676998)
33628 176389 3 36 700x Mansell St 16 11 1 2     38 Width 0ft   6009439.980830001 2090047.93275 37.719406601704 -122.40938096396499 (37.719406601704, -122.409380963965)
67100 176388 3 36 100x Mansell St 8 11 1 2     32 Width 0ft   6011438.192840001 2090648.2271599998 37.7211666433202 -122.40251603501001 (37.7211666433202, -122.40251603501)
54771 176387 3 36 100x Mansell St 4 11 1 2     32 Width 0ft   6011480.82156 2090667.2216900003 37.7212211781905 -122.402370013862 (37.7212211781905, -122.402370013862)
70249 176386 3 36 10x Mansell St 10 11 1 2     8 Width 0ft   6011666.66331 2090722.9963200002 37.7213846965192 -122.40173152668501 (37.7213846965192, -122.401731526685)
162071 176385 3 36 10x Mansell St 9 11 1 2     15 Width 0ft   6011675.69162 2090725.79104 37.7213928740681 -122.401700514484 (37.7213928740681, -122.401700514484)
15306 22434 3 36 6000 03rd St 3 1 1 2     18 3X3   6013550.0151 2091475.3264 37.7235553639507 -122.395273931127 (37.7235553639507, -122.395273931127)
16658 22427 3 36 5919 03rd St 2 1 1 2     18 3X3   6013743.1817 2091759.1378 37.724345394142 -122.39462604842699 (37.724345394142, -122.394626048427)
20112 29963 3 36 500X Junipero Serra Blvd 6 11 1 2   03/09/2013 12:00:00 AM 3 3x3   5991394.8537099995 2093447.95886 37.7277146673841 -122.47200336878099 (37.7277146673841, -122.472003368781)
111415 11292 3 36 1199X Ingalls St 4 1 1 2   04/13/1990 12:00:00 AM 30 3X3   6017612.0195749 2093925.7037957 37.730508696225705 -122.38140247160801 (37.7305086962257, -122.381402471608)
85513 11303 3 36 1201X Ingalls St 2 1 1 2   05/03/1993 12:00:00 AM 40 3X3   6017591.0151778 2093928.8426978001 37.7305161553992 -122.38147530581499 (37.7305161553992, -122.381475305815)
96922 11305 3 36 1201X Ingalls St 4 1 1 2   05/03/1993 12:00:00 AM 40 3X3   6017591.0151778 2093928.8426978001 37.7305161553992 -122.38147530581499 (37.7305161553992, -122.381475305815)
101060 11326 3 36 1223 Ingalls St 4 1 1 2   05/03/1993 12:00:00 AM 50 3X3   6017540.6929483 2093936.3628531997 37.730534025837706 -122.38164980170299 (37.7305340258377, -122.381649801703)
124644 11327 3 36 1223 Ingalls St 5 1 1 2   05/03/1993 12:00:00 AM 40 3X3   6017540.6929483 2093936.3628531997 37.730534025837706 -122.38164980170299 (37.7305340258377, -122.381649801703)
37403 11269 3 36 1176X Ingalls St 8 1 1 2   04/03/1990 12:00:00 AM 3 3x3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
85383 11265 3 36 1176X Ingalls St 4 1 1 2   11/02/1992 12:00:00 AM 20 3X3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
95268 11318 3 36 1216X Ingalls St 9 1 1 2   05/10/1990 12:00:00 AM 60 3X3   6017561.7867095005 2093983.7658262001 37.7306653497809 -122.38158017208 (37.7306653497809, -122.38158017208)
103086 11230 3 36 1050X Ingalls St 16 1 1 2   04/13/1990 12:00:00 AM 45 3X4   6018085.661882901 2094069.8743192002 37.7309306978843 -122.379775016493 (37.7309306978843, -122.379775016493)
128599 11231 3 36 1050X Ingalls St 17 1 1 2   04/02/1990 12:00:00 AM 50 3X4   6018085.661882901 2094069.8743192002 37.7309306978843 -122.379775016493 (37.7309306978843, -122.379775016493)
181793 206291 3 36 500x Junipero Serra Blvd 38 11 1 2     7 Width 0ft   5991445.95006 2094262.4550299998 37.7299540269465 -122.471886066612 (37.7299540269465, -122.471886066612)
18348 16020 3 36 107 Monterey Blvd 1 1 1 2     18 3x3   6001336.16248 2094611.17288 37.731478841871706 -122.437719447913 (37.7314788418717, -122.437719447913)
22088 16025 3 36 131 Monterey Blvd 1 1 1 2     18 4X4   6001203.7257900005 2094613.91575 37.7314788418574 -122.438177502293 (37.7314788418574, -122.438177502293)
20184 16030 3 36 147 Monterey Blvd 1 1 1 2     24 3X3   6001102.99289 2094615.6926099998 37.731477991115796 -122.438525881668 (37.7314779911158, -122.438525881668)
19938 16038 3 36 163 Monterey Blvd 1 1 1 2     12 3X3   6000989.84379 2094618.6563099998 37.7314796917131 -122.43891727113301 (37.7314796917131, -122.438917271133)
124037 10826 3 36 1139X Hudson Ave 33 1 1 2   03/29/1990 12:00:00 AM 12 3X4   6017834.53501 2094620.0550099998 37.732427530713004 -122.380681442077 (37.732427530713, -122.380681442077)
21993 16119 3 36 301 Monterey Blvd 1 1 1 2     18 3x3   6000050.07874 2094632.71852 37.7314647899581 -122.442167217764 (37.7314647899581, -122.442167217764)
17352 16120 3 36 303 Monterey Blvd 1 1 1 2     18 3x3   6000032.3049 2094633.40383 37.7314656586952 -122.44222871430401 (37.7314656586952, -122.442228714304)
143617 16166 3 36 405 Monterey Blvd 1 1 1 2     18 3X3   5999388.049433099 2094640.7964516003 37.7314492181413 -122.44445655139799 (37.7314492181413, -122.444456551398)
17573 16029 3 36 146 Monterey Blvd 1 1 1 2     12 3X3   6001109.44487 2094693.26414 37.7316913516547 -122.43850913181002 (37.7316913516547, -122.43850913181)
98031 16026 3 36 134 Monterey Blvd 1 1 1 2     12 3X3   6001180.6151014995 2094696.8372785 37.7317052108344 -122.438263338431 (37.7317052108344, -122.438263338431)
106493 10804 3 36 1139X Hudson Ave 12 1 1 2     10 3X4   6017540.26401 2094828.3880099999 37.7329833277332 -122.38171330076901 (37.7329833277332, -122.381713300769)
15523 26807 3 36 1487 McKinnon Ave 1 1 1 2     18 3X3   6015996.3267 2095429.905 37.7345495997276 -122.38709308337098 (37.7345495997276, -122.387093083371)
14940 26805 3 36 1491 McKinnon Ave 2 1 1 2     18 3X3   6015969.8239 2095448.3954 37.734598903014295 -122.38718600253901 (37.7345989030143, -122.387186002539)
88912 14871 3 36 1460X McKinnon Ave 2 1 1 2     36 3X3   6016026.3862344 2095468.2889327 37.734656658788296 -122.38699183277399 (37.7346566587883, -122.386991832774)
91909 14872 3 36 1460X McKinnon Ave 3 1 1 2     36 3X3   6016026.3862344 2095468.2889327 37.734656658788296 -122.38699183277399 (37.7346566587883, -122.386991832774)
96819 14870 3 36 1460X McKinnon Ave 1 1 1 2     36 3X3   6016026.3862344 2095468.2889327 37.734656658788296 -122.38699183277399 (37.7346566587883, -122.386991832774)
112180 26802 3 36 1460X McKinnon Ave 4 1 1 2     42 3X3   6016026.3862344 2095468.2889327 37.734656658788296 -122.38699183277399 (37.7346566587883, -122.386991832774)
81336 26808 3 36 1485 McKinnon Ave 2 1 1 2     18 3X3   6015936.7189767 2095472.8520506 37.7346642227188 -122.387302163855 (37.7346642227188, -122.387302163855)
107395 26806 3 36 1487 McKinnon Ave 3 1 1 2     18 3X3   6015928.376782499 2095479.8947363999 37.7346830985113 -122.38733149702601 (37.7346830985113, -122.387331497026)
83724 26803 3 36 1470 McKinnon Ave 1 1 1 2     24 3X3   6016001.5116582 2095486.8668237 37.734706292549205 -122.387079128733 (37.7347062925492, -122.387079128733)
99444 6126 3 36 199X Elk St 10 1 1 2     18 3X3   6000780.36286 2096039.2702900001 37.7353684469933 -122.439743296782 (37.7353684469933, -122.439743296782)
138565 6127 3 36 199X Elk St 11 1 1 2     18 3X3   6000782.74757 2096053.9984099998 37.735409022713704 -122.439736107551 (37.7354090227137, -122.439736107551)
1520 199389 3 36 16 Reuel Ct 1 1 1 2     24 Width 4ft   6017439.78771 2096071.60272 37.7363914002406 -122.38214713169901 (37.7363914002406, -122.382147131699)
116261 18633 3 36 2 Reuel Ct 1 1 1 2     18 3X3   6017006.0134624 2096129.8208529998 37.7365272887181 -122.38365093789899 (37.7365272887181, -122.383650937899)
3956 15038 3 36 1017 Mendell St 1 1 1 2     30 3X3   6015648.0 2096190.0 37.7366173719863 -122.388350408836 (37.7366173719863, -122.388350408836)
97379 15039 3 36 1017 Mendell St 1 1 1 2     18 3x3   6015648.596419999 2096190.1744099997 37.736617883929604 -122.388348358907 (37.7366178839296, -122.388348358907)
81339 6119 3 36 199X Elk St 3 1 1 2     18 3X3   6000815.0314327 2096222.3312360002 37.7358730629277 -122.439636554407 (37.7358730629277, -122.439636554407)
81374 6123 3 36 199X Elk St 7 1 1 2     12 3X3   6000815.0314327 2096222.3312360002 37.7358730629277 -122.439636554407 (37.7358730629277, -122.439636554407)
84321 6121 3 36 199X Elk St 5 1 1 2     12 3X3   6000815.0314327 2096222.3312360002 37.7358730629277 -122.439636554407 (37.7358730629277, -122.439636554407)
93664 6117 3 36 199X Elk St 1 1 1 2     12 3X3   6000815.0314327 2096222.3312360002 37.7358730629277 -122.439636554407 (37.7358730629277, -122.439636554407)
103050 6118 3 36 199X Elk St 2 1 1 2     12 3X3   6000815.0314327 2096222.3312360002 37.7358730629277 -122.439636554407 (37.7358730629277, -122.439636554407)
109965 6122 3 36 199X Elk St 6 1 1 2     18 3x3   6000815.0314327 2096222.3312360002 37.7358730629277 -122.439636554407 (37.7358730629277, -122.439636554407)
145856 6120 3 36 199X Elk St 4 1 1 2     12 3X3   6000815.0314327 2096222.3312360002 37.7358730629277 -122.439636554407 (37.7358730629277, -122.439636554407)
146271 6125 3 36 199X Elk St 9 1 1 2     18 3X3   6000815.0314327 2096222.3312360002 37.7358730629277 -122.439636554407 (37.7358730629277, -122.439636554407)
13610 11963 3 36 1009X Mendell St 1 1 1 2     18 3x3   6015687.60896 2096283.0567700001 37.736875081728705 -122.38821995489599 (37.7368750817287, -122.388219954896)
23270 11971 3 36 1022X Mendell St 1 1 1 2     21 3X3   6015641.62594 2096289.89853 37.736891319872896 -122.388379417299 (37.7368913198729, -122.388379417299)
23178 11964 3 36 1009X Mendell St 2 1 1 2     28 3X3   6015715.011390001 2096321.03931 37.7369808923559 -122.38812786163 (37.7369808923559, -122.38812786163)
123575 11966 3 36 1009X Mendell St 4 1 1 2     12 3x3   6015728.77645 2096327.58352 37.736999624078 -122.38808072579599 (37.736999624078, -122.388080725796)
144147 11973 3 36 1020X Mendell St 3 1 1 2     12 3X3   6015669.55392 2096331.84807 37.7370080523218 -122.388285783946 (37.7370080523218, -122.388285783946)
45604 11962 3 36 945X Mendell St 4 1 1 2     18 3X3   6015820.0973 2096449.8462 37.7373403917231 -122.38777351408001 (37.7373403917231, -122.38777351408)
16820 11511 3 36 101X Jennings St 1 1 1 2     18 5   6018385.91854 2096547.1526 37.7377493756286 -122.378908940096 (37.7377493756286, -122.378908940096)
15508 11512 3 36 101X Jennings St 2 1 1 2     12 3X3   6018400.60741 2096569.54507 37.7378116707805 -122.378859707612 (37.7378116707805, -122.378859707612)
16711 11513 3 36 101X Jennings St 3 1 1 2     12 3X3   6018414.43418 2096589.52395 37.7378672911411 -122.378813288221 (37.7378672911411, -122.378813288221)
15917 11515 3 36 101X Jennings St 5 1 1 2     18 3X3   6018435.759869999 2096618.26492 37.7379473838671 -122.378741549297 (37.7379473838671, -122.378741549297)
13998 11516 3 36 101X Jennings St 6 1 1 2     18 3X3   6018445.80461 2096632.24283 37.737986318204605 -122.378707789643 (37.7379863182046, -122.378707789643)
15740 11517 3 36 101X Jennings St 7 1 1 2     18 3X3   6018459.10272 2096646.1554299998 37.738025252555 -122.37866277678499 (37.738025252555, -122.378662776785)
123070 11559 3 36 830X Mendell St 5 1 1 2     12 3X3   6015912.14045 2096650.33898 37.737896002535294 -122.387469258127 (37.7378960025353, -122.387469258127)
20202 5091 3 36 2600 Diamond St 1 1 1 2     18 3X3   6002242.42307 2096653.9998400002 37.7371394644141 -122.434732362321 (37.7371394644141, -122.434732362321)
13853 11518 3 36 101X Jennings St 8 1 1 2     18 3X3   6018467.96004 2096661.77747 37.7380686358665 -122.37863323672899 (37.7380686358665, -122.378633236729)
121890 11558 3 36 830X Mendell St 4 1 1 2     12 3X3   6015923.7081699995 2096663.9429799998 37.7379339970425 -122.387430211254 (37.7379339970425, -122.387430211254)
16734 11519 3 36 101X Jennings St 9 1 1 2     18 3X3   6018482.73466 2096678.8993400002 37.7381164636019 -122.378583341463 (37.7381164636019, -122.378583341463)
122202 11556 3 36 830X Mendell St 2 1 1 2   06/07/1996 12:00:00 AM 18 3X3   6015938.87476 2096683.24967 37.737987849284394 -122.387379118862 (37.7379878492844, -122.387379118862)
1068 11520 3 36 101X Jennings St 10 1 1 2   05/01/2017 12:00:00 AM 6 3X3   6018495.90717 2096693.85175 37.738158246093 -122.378538834904 (37.738158246093, -122.378538834904)
15479 11521 3 36 101X Jennings St 11 1 1 2     18 3X3   6018533.508280001 2096747.4741099998 37.738307555143706 -122.378412549408 (37.7383075551437, -122.378412549408)
14633 11522 3 36 101X Jennings St 12 1 1 2     18 3X3   6018545.03968 2096763.4476400001 37.738352050906 -122.37837378772801 (37.738352050906, -122.378373787728)
140492 11523 3 36 101X Jennings St 13 1 1 2     18 3X3   6018517.10401 2096771.58701 37.7383728601739 -122.378470941616 (37.7383728601739, -122.378470941616)
14283 11524 3 36 101X Jennings St 14 1 1 2     18 3X3   6018572.85172 2096797.82035 37.7384479645089 -122.378280011831 (37.7384479645089, -122.378280011831)
14617 11525 3 36 101X Jennings St 15 1 1 2     18 3X3   6018584.76615 2096814.86638 37.7384954262103 -122.37824000008499 (37.7384954262103, -122.378240000085)
Powered by Datasette · Query took 5.495ms · Data source: data.sfgov.org