sf-trees

Data source: data.sfgov.org

Custom SQL query returning 58 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)
4152 216685 2 80 111 Ashton Ave 2 2 1 1   10/06/2017 08:11:00 AM 3 Width 3ft   5994133.1609 2090669.8719900001 37.720244788744104 -122.46233566126101 (37.7202447887441, -122.462335661261)
4474 162754 2 80 997x Capitol Ave 2 1 1 1   10/13/2017 11:43:00 AM 3 Width 0ft   5995095.0 2090528.0 37.719910580533295 -122.45900065774599 (37.7199105805333, -122.459000657746)
4501 162764 2 80 919 Capitol Ave 1 1 1 1   10/13/2017 10:56:00 AM 3 Width 0ft   5995008.1104 2090049.4028900003 37.7185914714977 -122.459266363268 (37.7185914714977, -122.459266363268)
9791 116717 2 80 690X 03RD ST 4 1 1 1   09/22/2003 12:00:00 AM 5 3x3   6014548.0 2111604.0 37.7788798826953 -122.393231883862 (37.7788798826953, -122.393231883862)
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)
78961 121107 2 80 1391 08th Ave 1 1 1 1   09/09/2016 12:00:00 AM 3 3x3   5993608.0 2106030.0 37.7623895873424 -122.46526608917601 (37.7623895873424, -122.465266089176)
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)
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)
97623 100396 2 80 500X Oak Park Dr 1 9 1 1   09/18/2012 12:00:00 AM 3 3x9 Permit Number 769101 5994983.3 2103652.8 37.755941622135296 -122.460337221652 (37.7559416221353, -122.460337221652)
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)
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)
104602 116251 2 80 229 HAIGHT ST 15 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
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)
107040 119284 2 80 651 28th Ave 2 1 1 1   07/26/2016 12:00:00 AM 3 3x3   5987187.0 2111505.0 37.777050030999604 -122.487875935939 (37.7770500309996, -122.487875935939)
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)
110276 121108 2 80 1391 08th Ave 2 1 1 1   09/09/2016 12:00:00 AM 3 3x3   5993608.0 2106030.0 37.7623895873424 -122.46526608917601 (37.7623895873424, -122.465266089176)
111595 112521 2 80 146x ARLETA AVE 4 1 1 1       3x3   6010471.0 2087928.0 37.7136434126305 -122.40566785728501 (37.7136434126305, -122.405667857285)
112828 99931 2 80 801X Noe St 1 1 1 1   07/19/2012 12:00:00 AM   3x3 Permit Number 768924 6003100.6 2103580.4 37.756206424442205 -122.432259777723 (37.7562064244422, -122.432259777723)
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)
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)
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)
126761 116241 2 80 229x HAIGHT ST 4 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
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)
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)
142331 119283 2 80 651 28th Ave 1 1 1 1   07/26/2016 12:00:00 AM 3 3x3   5987187.0 2111505.0 37.777050030999604 -122.487875935939 (37.7770500309996, -122.487875935939)
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)
Powered by Datasette · Query took 56.353ms · Data source: data.sfgov.org