sf-trees

Data source: data.sfgov.org

Custom SQL query returning 76 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4891 253709 2 47 1 Monument Way 3 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
5097 253793 2 1 1698X 08th Ave 3 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
10631 97353 1 17   3 14 1 1                    
43848 99190 1 15 1155@Greenwich Battery St 3 14 1 1   04/24/2012 12:00:00 AM 13 Park Permit Number 768770 6012236.89935 2120056.2938 37.801959219714 -122.401821238566 (37.801959219714, -122.401821238566)
62864 108717 2 304 1141 Chestnut St 3 14 1 1     7 3x3   6006358.32966 2120394.6178099997 37.802558354332795 -122.422187945742 (37.8025583543328, -122.422187945742)
69268 116648 3 193 199x Esmeralda Ave 3 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
87282 111156 2 1 201x EUGENIA AVE 3 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
88788 117626 2 3 890x VERMONT ST 3 14 1 1           6011292.0 2104239.0 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201)
91188 111312 2 176 99x GILROY ST 3 14 1 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
94946 95436 2 103 2675 25th Ave 3 14 1 1     16     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
96239 115665 2 1 601x PERU AVE 3 14 1 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
106956 97537 1 3 300 Winfield St 3 14 1 1           6006649.9 2098038.3 37.7411896837785 -122.41959186825599 (37.7411896837785, -122.419591868256)
110195 105756 1 17 1910X CASTRO ST 3 14 1 1   04/10/2014 12:00:00 AM 14   Permit Number 771977 6002640.0 2099906.0 37.746091265221295 -122.433590100931 (37.7460912652213, -122.433590100931)
115043 105070 2 12 49X Esmeralda Ave 3 14 1 1         Permit Number 771039 6006861.0 2099026.0 37.7439135755866 -122.41893199410299 (37.7439135755866, -122.418931994103)
119057 106282 2 474 399X Elliot St 3 14 1 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
121692 98378 1 47 199X Cragmont Ave 3 14 1 1         Permit Number 768647 5992899.0 2101153.0 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244)
122748 111320 2 36 200x PENINSULA AVE 3 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
127372 112739 2 47 444 Franconia St 3 14 1 1     30     6009949.70212209 2098546.33795552 37.7427699663381 -122.40821810325701 (37.7427699663381, -122.408218103257)
138343 105902 3 103 11X ELLIOT ST 3 14 1 2     40     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
139483 115526 1 17 25 FRANCONIA ST 3 14 1 1   07/12/2016 12:00:00 AM 3 3x3 Permit Number 777451 6010006.0 2099954.0 37.746638251201404 -122.408122694659 (37.7466382512014, -122.408122694659)
144190 116667 3 129 100x Esmeralda Ave 3 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
145558 105653 2 3 150 BRONTE ST 3 14 1 1     16   Permit Number 770978 6009287.5 2096640.3 37.737499298818996 -122.410373266073 (37.737499298819, -122.410373266073)
3510 247941 4 58 29 Joy St 4 14 1 2     5   Permit Number 775404 6010287.82636 2098909.7574 37.743786764646 -122.40707457072901 (37.743786764646, -122.407074570729)
4884 253710 2 47 1 Monument Way 4 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
5099 253794 2 1 1698X 08th Ave 4 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
8657 97354 1 17   4 14 1 1                    
76347 111157 2 1 201x EUGENIA AVE 4 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
86301 105759 1 17 1910X CASTRO ST 4 14 1 1   04/10/2014 12:00:00 AM 15   Permit Number 771977 6002617.0 2100030.0 37.746430435118796 -122.43367849259899 (37.7464304351188, -122.433678492599)
95360 116668 3 129 100x Esmeralda Ave 4 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
111257 98379 2 47 199X Cragmont Ave 4 14 1 1           5992899.0 2101153.0 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244)
115115 105652 2 211 150 BRONTE ST 4 14 1 1     25     6009287.5 2096640.3 37.737499298818996 -122.410373266073 (37.737499298819, -122.410373266073)
128665 117627 2 3 890x VERMONT ST 4 14 1 1           6011292.0 2104239.0 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201)
139585 115666 2 1 601x PERU AVE 4 14 1 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
145521 116649 3 193 199x Esmeralda Ave 4 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
3497 247942 4 58 29 Joy St 5 14 1 2     3   Permit Number 775404 6010292.72224 2098904.67919 37.7437730949632 -122.40705728398399 (37.7437730949632, -122.407057283984)
4898 253711 2 47 1 Monument Way 5 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
5085 253795 2 1 1698X 08th Ave 5 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
14893 97355 1 17   5 14 1 1                    
95391 113478 3 38 100x ESMERALDA AVE 5 14 1 2     8     6006917.0 2098966.0 37.7437519821991 -122.418734104398 (37.7437519821991, -122.418734104398)
100068 111158 2 1 201x EUGENIA AVE 5 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
105289 105760 1 17 1910X CASTRO ST 5 14 1 1   04/10/2014 12:00:00 AM 15   Permit Number 771977 6002617.0 2100030.0 37.746430435118796 -122.43367849259899 (37.7464304351188, -122.433678492599)
129308 116650 3 193 199x Esmeralda Ave 5 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
3501 247943 4 22 29 Joy St 6 14 1 2     2   Permit Number 775404 6010304.2598 2098903.51059 37.7437705318851 -122.407017307297 (37.7437705318851, -122.407017307297)
7011 97356 1 17   6 14 1 1                    
82433 111159 2 1 201x EUGENIA AVE 6 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
113837 116669 3 47 100 Esmeralda Ave 6 14 1 2     20     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
118788 116651 3 193 199x Esmeralda Ave 6 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
4552 97357 1 17   7 14 1 1                    
78555 116671 3 28 100 Esmeralda Ave 7 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
82496 116652 3 193 199x Esmeralda Ave 7 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
110332 109200 2 36 2401x CASTRO ST 7 14 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
4913 97358 1 17   8 14 1 1                    
92156 116653 3 26 199x Esmeralda Ave 8 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
126736 116670 3 180 100 Esmeralda Ave 8 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
89602 116672 3 3 100 Esmeralda Ave 9 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
94398 116654 3 38 199x Esmeralda Ave 9 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
95215 116655 3 38 199x Esmeralda Ave 9 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
105354 116656 3 3 199x Esmeralda Ave 10 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
144028 113477 3 3 100x Esmeralda Ave 10 14 1 2     24     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
145384 116657 3 3 199x Esmeralda Ave 11 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
105412 116658 3 3 199x Esmeralda Ave 12 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
139190 116659 3 3 199x Esmeralda Ave 12 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
93306 116660 3 116 199x Esmeralda Ave 13 14 1 2     8     6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
86166 116675 3 180 100 Esmeralda Ave 14 14 1 2     14     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
101447 116661 3 3 199x Esmeralda Ave 14 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
77674 116662 3 3 199x Esmeralda Ave 15 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
143384 116676 3 338 100 Esmeralda Ave 15 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
19241 116677 3 58 100 Esmeralda Ave 16 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
123372 116663 3 154 199x Esmeralda Ave 16 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
127057 116678 3 58 100 Esmeralda Ave 17 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
92622 116679 3 211 100 Esmeralda Ave 18 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
112048 116664 3 42 199x Esmeralda Ave 18 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
123800 116680 3 132 100 Esmeralda Ave 19 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
95944 116681 3 38 100 Esmeralda Ave 20 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
82247 116682 3 108 100 Esmeralda Ave 21 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
138825 116683 3 108 100 Esmeralda Ave 22 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
Powered by Datasette · Query took 4.393ms · Data source: data.sfgov.org