sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
560 131782 2 80 2646 Union St 2 1 1 1     11 Width 3ft Permit Number 779549 6000337.27442 2118211.39807 37.7962223607332 -122.442866875924 (37.7962223607332, -122.442866875924)
2783 252852 2 80 100X Langton St 3 1 1 1       2.5x4   6010166.0 2110701.0 37.776156040570996 -122.408327321329 (37.776156040571, -122.408327321329)
2784 252854 2 80 100X Langton St 1 1 1 1       2.5x4   6010166.0 2110701.0 37.776156040570996 -122.408327321329 (37.776156040571, -122.408327321329)
2788 252853 2 80 100X Langton St 2 1 1 1       2.5x4   6010166.0 2110701.0 37.776156040570996 -122.408327321329 (37.776156040571, -122.408327321329)
3762 139362 2 80 2869 BUSH ST 1 1 1 1     1 Width 0ft   5999793.3033 2114332.6333 37.7855412639984 -122.44447021936199 (37.7855412639984, -122.444470219362)
10102 121489 3 80 2 Judah St 1 11 1 2       3x3            
10105 121488 3 80 750 Parnassus Ave 1 11 1 2       3x3   5994725.7235199995 2106063.1570900003 37.762545022051796 -122.461402729778 (37.7625450220518, -122.461402729778)
19726 116259 2 80 155 LAGUNA ST 7 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
34237 143019 2 80 410 LOMBARD ST 1 1 1 1     19 Width 0ft   6010368.5125 2120644.4743 37.8034697728784 -122.408328278578 (37.8034697728784, -122.408328278578)
66020 116255 2 80 155 LAGUNA ST 3 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
78461 113802 2 80 806 SHOTWELL ST 4 7 1 1           6007931.0 2103220.0 37.755489548438 -122.41552904166201 (37.755489548438, -122.415529041662)
79381 114695 2 80 799x TAYLOR ST 2 1 1 1       3x3   6009121.0 2115613.0 37.7895846457112 -122.41228952949498 (37.7895846457112, -122.412289529495)
81022 116243 2 80 229x HAIGHT ST 6 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
81344 116244 2 80 229x HAIGHT ST 7 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
82486 114696 2 80 799x TAYLOR ST 3 1 1 1       3x3   6009121.0 2115613.0 37.7895846457112 -122.41228952949498 (37.7895846457112, -122.412289529495)
84703 100649 2 80 50 Walter St 1 1 1 1       3x3   6003141.0 2108015.0 37.76838505717971 -122.432436785894 (37.7683850571797, -122.432436785894)
85348 116248 2 80 229 HAIGHT ST 12 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
86226 116252 2 80 229 HAIGHT ST 16 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
87337 117270 2 80 481 JERSEY ST 1 1 1 1     2 3x3   6002050.0 2101440.0 37.750269772538296 -122.435739974128 (37.7502697725383, -122.435739974128)
90305 116261 2 80 155 LAGUNA ST 9 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
92554 116250 2 80 229 HAIGHT ST 14 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
94581 95578 1 80 501@ 6th Ave Irving St 1 1 1 1           5994244.0 2106639.0 37.764098399310704 -122.463110607355 (37.7640983993107, -122.463110607355)
94824 111178 2 80 2109 Polk St 1 1 1 1       3x3   6006363.0 2118096.0 37.7962471953974 -122.42200839754801 (37.7962471953974, -122.422008397548)
96610 116253 2 80 155 LAGUNA ST 1 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
98226 116254 2 80 155 LAGUNA ST 2 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
100092 112520 2 80 146x ARLETA AVE 2 1 1 1       3x3   6010471.0 2087928.0 37.7136434126305 -122.40566785728501 (37.7136434126305, -122.405667857285)
100241 116246 2 80 229 HAIGHT ST 9 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
102114 116238 2 80 229x HAIGHT ST 1 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
102168 116240 2 80 229x HAIGHT ST 3 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
104602 116251 2 80 229 HAIGHT ST 15 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
104629 122520 1 80 250 Randall St 1 1 1 1       3x3   6004004.54241313 2097731.78472111 37.740198698919 -122.428716724311 (37.740198698919, -122.428716724311)
107711 116260 2 80 155 LAGUNA ST 8 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
107993 116249 2 80 229 HAIGHT ST 13 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
108883 116245 2 80 229 HAIGHT ST 8 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
111595 112521 2 80 146x ARLETA AVE 4 1 1 1       3x3   6010471.0 2087928.0 37.7136434126305 -122.40566785728501 (37.7136434126305, -122.405667857285)
113421 116242 2 80 229x HAIGHT ST 5 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
114164 116239 2 80 229x HAIGHT ST 2 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
119717 116247 2 80 229 HAIGHT ST 11 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
120569 113398 2 80 603 CLAYTON ST 2 1 1 1       3x3   5998367.0 2108846.0 37.7703949048055 -122.44900941031099 (37.7703949048055, -122.449009410311)
122604 116372 2 80 1306 10TH AVE 1 1 1 1       6x8   5993057.0 2106542.0 37.7637636140689 -122.46720900630899 (37.7637636140689, -122.467209006309)
123028 18540 3 80 60 Quartz Way 1 1 1 2     75 2x2 Permit Number 778371 5999060.658518599 2099832.0947892 37.745684600557794 -122.445961639207 (37.7456846005578, -122.445961639207)
126761 116241 2 80 229x HAIGHT ST 4 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
138577 103085 1 80 99 Colton St 1 1 1 1 1     2x3 See 55 Brady St; trees planted at same time with permits/FUF 6006671.4 2109566.7 37.7728452155106 -122.42033558182301 (37.7728452155106, -122.420335581823)
140431 107849 2 80 1300x ANZA ST 1 1 1 1     8 3x3   5994625.0 2112199.0 37.7793866324847 -122.46219610899901 (37.7793866324847, -122.462196108999)
141309 103086 1 80 99 Colton St 2 1 1 1 1     2x3 See 55 Brady St; trees planted at same time with permits/FUF 6006671.4 2109566.7 37.7728452155106 -122.42033558182301 (37.7728452155106, -122.420335581823)
141591 118312 2 80 2410 STEINER ST 1 1 1 1       3x3   6002301.0 2116562.0 37.7918052987456 -122.435953913571 (37.7918052987456, -122.435953913571)
141724 121042 2 80 2101 Polk St 4 1 1 1       3x3   6006363.0 2118098.0 37.7962526868942 -122.422008539697 (37.7962526868942, -122.422008539697)
142521 116257 2 80 155 LAGUNA ST 5 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
142800 116256 2 80 155 LAGUNA ST 4 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
143334 116258 2 80 155 LAGUNA ST 6 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
143509 113397 2 80 603 CLAYTON ST 1 1 1 1       3x3   5998367.0 2108846.0 37.7703949048055 -122.44900941031099 (37.7703949048055, -122.449009410311)
93755 115008 1 80 743 32nd Ave 2 1 1 1   01/04/2016 12:00:00 AM     Permit Number 774445 5985969.5 2110831.9 37.775130796003204 -122.49203801834601 (37.7751307960032, -122.492038018346)
5683 13042 1 80 515-519 Lombard St 1 1 1 1   01/06/2016 07:23:00 AM 3 3x3   6009844.8077 2120534.1734 37.8031375739168 -122.410132796901 (37.8031375739168, -122.410132796901)
6621 13040 1 80 515-519 Lombard St 3 1 1 1   01/06/2016 07:26:00 AM 3 3X3   6009890.5899 2120540.3695 37.8031571528751 -122.409974803368 (37.8031571528751, -122.409974803368)
7621 29909 1 80 515-519 Lombard St 2 1 1 1   01/06/2016 07:29:00 AM 3 3x3   6009867.8709 2120537.6157 37.8031483182934 -122.41005322890301 (37.8031483182934, -122.410053228903)
89798 103596 1 80 10X Hermann St 5 1 1 1   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005031.0649 2108842.56611 37.7707643495235 -122.42595813798201 (37.7707643495235, -122.425958137982)
101213 103593 1 80 10X Hermann St 2 1 1 1   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005031.0649 2108842.56611 37.7707643495235 -122.42595813798201 (37.7707643495235, -122.425958137982)
121859 103584 1 80 55X Laguna St 5 1 1 1   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005242.6 2108960.5 37.7711001201992 -122.42523482670799 (37.7711001201992, -122.425234826708)
142728 103585 1 80 55X Laguna St 6 1 1 1   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005242.6 2108960.5 37.7711001201992 -122.42523482670799 (37.7711001201992, -122.425234826708)
143605 103586 1 80 55X Laguna St 7 1 1 1   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005242.6 2108960.5 37.7711001201992 -122.42523482670799 (37.7711001201992, -122.425234826708)
106272 115004 5 80 1050 MCALLISTER ST 1 8 1 21 4 01/19/2016 09:19:00 AM 3 3x3   6004148.0 2111858.0 37.778994045300706 -122.42922772691401 (37.7789940453007, -122.429227726914)
63991 115203 1 80 2056 Ellis St 1 1 1 1   01/19/2016 12:00:00 AM 3   Permit Number 775522 6001029.7 2112838.5 37.781509225585104 -122.44008548171301 (37.7815092255851, -122.440085481713)
66027 115194 1 80 4150 20th St 1 1 1 1   01/19/2016 12:00:00 AM     Permit Number 777365 6002684.1 2104186.2 37.757846181761295 -122.433743471638 (37.7578461817613, -122.433743471638)
6371 13043 1 80 526 Lombard St 1 1 1 1   01/21/2016 11:51:00 AM 3 3x3   6009812.0026 2120568.2515 37.803229305132604 -122.41024872778401 (37.8032293051326, -122.410248727784)
80243 56898 1 80 1886 34th Ave 1 1 1 1   01/21/2016 12:00:00 AM     Permit Number 775792 5985700.55899725 2102390.4838018003 37.751937297297395 -122.492346587933 (37.7519372972974, -122.492346587933)
121335 115253 1 80 20 Edgar Ave 1 1 1 1   01/21/2016 12:00:00 AM     Permit Number 772988 5997135.3 2090888.7 37.7210180538388 -122.451974094521 (37.7210180538388, -122.451974094521)
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)
43549 43627 1 80 2230 35th Ave 1 1 1 1 1 01/22/2016 12:00:00 AM 0 3x3 Permit Number 775700 5985470.85834553 2100027.42958295 37.7454355618475 -122.49296686595899 (37.7454355618475, -122.492966865959)
79092 115287 1 80 1526 12th Ave 1 5 1 1   01/22/2016 12:00:00 AM     Permit Number 776185 5992489.2 2105046.7 37.759625121297795 -122.469064003389 (37.7596251212978, -122.469064003389)
91935 115289 1 80 1425 14th Ave 1 1 1 1   01/22/2016 12:00:00 AM     Permit Number 775512 5991747.8 2105705.5 37.761391146048496 -122.47167612106001 (37.7613911460485, -122.47167612106)
124414 115297 1 80 84 Forest Side Ave 1 1 1 1   01/22/2016 12:00:00 AM     Permit Number 775683 5992506.3 2098571.2 37.7418460572185 -122.468533715231 (37.7418460572185, -122.468533715231)
105773 102005 2 80 1703 CASTRO ST 2 1 1 1   01/26/2016 12:00:00 AM 3 3x3 Permit Number 776283 6002624.0 2100623.7 37.7480609930318 -122.433696712327 (37.7480609930318, -122.433696712327)
120000 102006 2 80 1703 Castro St 3 1 1 1   01/26/2016 12:00:00 AM 3 3x3 Permit Number 776283 6002624.0 2100623.7 37.7480609930318 -122.433696712327 (37.7480609930318, -122.433696712327)
89928 115438 1 80 2500X Larkin St 4 1 1 1   02/01/2016 12:00:00 AM 3   Permit Number 777506 6006688.6 2119773.1 37.8008704472237 -122.421000888697 (37.8008704472237, -122.421000888697)
43784 83046 5 80 100X Cargo Way 6 1 1 9   02/04/2006 12:00:00 AM 1     6018811.25128 2097616.11187 37.740707968002 -122.37751250161399 (37.740707968002, -122.377512501614)
397 13004 3 80 368 Lombard St 1 1 1 2   02/12/2016 06:38:00 AM 3 4X4   6010562.3418 2120670.5672 37.8035522695821 -122.407659361785 (37.8035522695821, -122.407659361785)
4321 12988 3 80 324 Lombard St 1 1 1 2   02/12/2016 06:56:00 AM 3 3X3   6010748.7594 2120699.4941 37.803642129208605 -122.407016292062 (37.8036421292086, -122.407016292062)
7645 13025 1 80 451 Lombard St 1 1 1 1   02/12/2016 07:02:00 AM 3 3X3   6010198.7145 2120581.4625 37.8032872483458 -122.40891142592 (37.8032872483458, -122.40891142592)
145289 25159 3 80 2600X Market St 1 1 1 2   02/19/2015 12:55:00 PM 3 3X3   6001683.708124 2105708.1424058997 37.7619682491468 -122.43731221388599 (37.7619682491468, -122.437312213886)
88959 115768 1 80 210 Drake St 1 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 775810 6001697.3 2086437.3 37.709055747846705 -122.43588629224399 (37.7090557478467, -122.435886292244)
104270 75029 2 80 141X Arleta Ave 1 1 1 13 1 02/24/2016 12:00:00 AM 3   This record is for lthe ot between 141-143 Arleta Ave. 6010470.01061258 2087860.00753073 37.713456663779795 -122.40566649087499 (37.7134566637798, -122.405666490875)
104340 74892 2 80 141X Arleta Ave 2 1 1 13 1 02/24/2016 12:00:00 AM 3   This is for the trees adjacent to the lot between 141-143 Arleta 6010470.01061258 2087860.00753073 37.713456663779795 -122.40566649087499 (37.7134566637798, -122.405666490875)
128131 115769 1 80 210 Drake St 2 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 775810 6001697.3 2086437.3 37.709055747846705 -122.43588629224399 (37.7090557478467, -122.435886292244)
106475 39630 1 80 1568 Shrader St 1 1 1 1   02/25/2010 12:00:00 AM   5x3 Permit Number 53204 5997924.75387781 2105264.0077583 37.7605343603066 -122.45028089123501 (37.7605343603066, -122.450280891235)
85128 55718 1 80 53 Walter St 1 1 1 1   03/02/1973 12:00:00 AM 12 6x7 Permit Number 11741 6003183.88384083 2107999.49897853 37.7683449267986 -122.43228734753401 (37.7683449267986, -122.432287347534)
92225 55721 1 80 62 Walter St 1 1 1 1   03/02/1973 12:00:00 AM 30   Permit Number 11744 6003135.04861118 2107940.94065447 37.768181370821 -122.432452080859 (37.768181370821, -122.432452080859)
78192 109745 1 80 2730 16th St 4 1 1 1 1 03/03/2015 12:00:00 AM 3 3x3 Permit Number 769296 6008568.6 2106948.2 37.7657621501348 -122.413587690705 (37.7657621501348, -122.413587690705)
22867 143011 1 80 650-654 LOMBARD ST 2 1 1 1   03/11/2017 12:26:00 PM 3 Width 0ft   6009188.4253 2120483.2963 37.8029610657241 -122.41240063587601 (37.8029610657241, -122.412400635876)
91959 8974 3 80 5045 Geary Blvd 1 1 1 2   03/12/2011 12:00:00 AM 3 3x3   5991343.5266 2112609.97523 37.780325569878705 -122.473577979119 (37.7803255698787, -122.473577979119)
117154 9031 3 80 5351 Geary Blvd 1 1 1 2   03/12/2011 12:00:00 AM 3 3x3   5990365.52035 2112599.40799 37.7802398682569 -122.476960548186 (37.7802398682569, -122.476960548186)
6943 13034 3 80 490 Lombard St 1 1 1 2   03/16/2016 02:07:00 PM 3 3x3   6010037.8987 2120598.0598 37.8033238110836 -122.409469108899 (37.8033238110836, -122.409469108899)
5406 13016 3 80 407 Lombard St 2 1 1 2   03/16/2016 02:31:00 PM 3 3X3   6010356.171 2120603.3463 37.8033561544514 -122.408368084374 (37.8033561544514, -122.408368084374)
66010 90469 3 80 578 25th Ave 1 1 1 2 8 03/17/2008 12:00:00 AM 3 3x3   5988158.072517 2112047.558198 37.778596339842 -122.48455654153601 (37.778596339842, -122.484556541536)
90847 90526 3 80 705 25th Ave 1 1 1 2 8 03/18/2008 12:00:00 AM 3 3x3   5988149.756261 2111164.589328 37.7761714707406 -122.484520528522 (37.7761714707406, -122.484520528522)
111851 60027 1 80 41 South Park 1 1 1 1 1 03/18/2013 12:00:00 AM     Permit Number 769856 6014655.81368733 2112837.99803451 37.7822741509003 -122.392945269869 (37.7822741509003, -122.392945269869)
99422 90510 3 80 555 25th Ave 1 1 1 2 8 03/19/2008 12:00:00 AM 3 3x3   5988112.407888 2112207.812683 37.7790336942222 -122.48472626983101 (37.7790336942222, -122.484726269831)
102101 90511 3 80 569 25th Ave 1 1 1 2 8 03/19/2008 12:00:00 AM 3 3x3   5988115.7266919995 2112113.5102150002 37.7787749594642 -122.48470786940099 (37.7787749594642, -122.484707869401)
118636 90471 3 80 534 25th Ave 1 1 1 2 8 03/20/2008 12:00:00 AM 3 3x3   5988147.641992 2112343.937312 37.779409506079396 -122.484614370085 (37.7794095060794, -122.484614370085)
6283 13055 1 80 570 Lombard St 1 1 1 1   03/24/2016 08:41:00 AM 3 3x3   6009605.5749 2120542.0431 37.8031457701614 -122.410961227909 (37.8031457701614, -122.410961227909)
79096 84742 1 80 147 Alhambra St 1 5 1 1   03/27/2007 12:00:00 AM   4x6 Permit Number 49255 6001618.0 2120311.0 37.8020602472718 -122.438585827087 (37.8020602472718, -122.438585827087)
84179 98330 1 80 147 Alhambra St 2 5 1 1   03/27/2007 12:00:00 AM   4x6 Permit Number 49255 6001593.9 2120254.3 37.801903193112004 -122.438665159251 (37.801903193112, -122.438665159251)
Powered by Datasette · Query took 4.621ms · Data source: data.sfgov.org