sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
549 251321 2 47 100X Monument Way 1 14 1 1                    
4222 253622 2 128 300x Naglee Ave   14 1 1                    
4552 97357 1 17   7 14 1 1                    
4913 97358 1 17   8 14 1 1                    
7011 97356 1 17   6 14 1 1                    
7040 97351 1 17   1 14 1 1                    
8657 97354 1 17   4 14 1 1                    
10631 97353 1 17   3 14 1 1                    
14893 97355 1 17   5 14 1 1                    
16895 97352 1 17   2 14 1 1                    
185502 122532 2 3 1900X Castro St 1 14 1 1                    
82185 111319 2 36 200x PENINSULA AVE 2 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
87976 111318 2 36 200x PENINSULA AVE 1 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
122748 111320 2 36 200x PENINSULA AVE 3 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
82737 106281 2 474 399X Elliot St 2 14 1 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
95834 106280 2 474 399X Elliot St 1 14 1 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
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)
87421 111309 2 176 100x GILROY ST 1 14 1 1       30x30   6015178.0 2088529.0 37.7155557353625 -122.38944056945101 (37.7155557353625, -122.389440569451)
91188 111312 2 176 99x GILROY ST 3 14 1 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
96975 111311 2 176 99x GILROY ST 2 14 1 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
123880 111310 2 176 99x GILROY ST 1 14 1 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
112606 105901 3 103 11X ELLIOT ST 2 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
122561 105900 3 103 11X ELLIOT ST 1 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
138343 105902 3 103 11X ELLIOT ST 3 14 1 2     40     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
93493 121630 2 1 96x Valmar Ter 1 14 1 1     12 3x3   6005224.0 2092573.0 37.726102766942205 -122.42413354236 (37.7261027669422, -122.42413354236)
79542 115664 2 1 601x PERU AVE 2 14 1 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
96239 115665 2 1 601x PERU AVE 3 14 1 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
124140 115663 2 1 601x PERU AVE 1 14 1 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
139585 115666 2 1 601x PERU AVE 4 14 1 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
114729 96803 2 103 300X Melrose Ave 1 14 1 1     48     5998134.5 2095546.7 37.733865009274204 -122.448855518806 (37.7338650092742, -122.448855518806)
9968 173756 2 3 1X Emil Ln 2 14 1 1       3x3   5996276.0 2095955.0 37.734879644622296 -122.455310374086 (37.7348796446223, -122.455310374086)
9970 173755 2 3 1X Emil Ln 1 14 1 1       3x3   5996276.0 2095955.0 37.734879644622296 -122.455310374086 (37.7348796446223, -122.455310374086)
142115 121724 2 330 439X ARLINGTON ST 2 14 1 1           6003949.9 2096014.9 37.7354814316621 -122.42878329168998 (37.7354814316621, -122.42878329169)
94709 117610 2 98 391 NEVADA ST 1 14 2 1       3x3   6008958.0 2096497.0 37.737087351465796 -122.41150238578501 (37.7370873514658, -122.411502385785)
145518 114586 2 3 155x BRONTE ST 1 14 1 1     15 3x3 Permit Number 777226 6009330.0 2096609.0 37.737415738166206 -122.410224113722 (37.7374157381662, -122.410224113722)
105116 105651 2 211 150 BRONTE ST 2 14 1 1     20     6009287.5 2096640.3 37.737499298818996 -122.410373266073 (37.737499298819, -122.410373266073)
115115 105652 2 211 150 BRONTE ST 4 14 1 1     25     6009287.5 2096640.3 37.737499298818996 -122.410373266073 (37.737499298819, -122.410373266073)
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)
144060 33896 1 211 150 Bronte St 1 14 1 1   03/03/1997 12:00:00 AM 25   Permit Number 37869 6009276.59000035 2096641.35700735 37.737501589532705 -122.410411061845 (37.7375015895327, -122.410411061845)
94946 95436 2 103 2675 25th Ave 3 14 1 1     16     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
114267 95432 2 116 2675 25th Ave 1 14 1 1     12     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
115606 95435 2 116 2675 25th Ave 2 14 1 1     12     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
82723 102522 2 129 1X 31st St 2 14 1 1           5999966.2 2097547.4 37.7394630398899 -122.442666404233 (37.7394630398899, -122.442666404233)
106463 102521 2 3 1X 31st St 1 14 1 1           5999966.2 2097547.4 37.7394630398899 -122.442666404233 (37.7394630398899, -122.442666404233)
93592 97535 1 3 300 Winfield St 1 14 1 1           6006649.9 2098038.3 37.7411896837785 -122.41959186825599 (37.7411896837785, -122.419591868256)
106956 97537 1 3 300 Winfield St 3 14 1 1           6006649.9 2098038.3 37.7411896837785 -122.41959186825599 (37.7411896837785, -122.419591868256)
144308 97536 1 3 300 Winfield St 2 14 1 1         Permit Number 768224 6006649.9 2098038.3 37.7411896837785 -122.41959186825599 (37.7411896837785, -122.419591868256)
76347 111157 2 1 201x EUGENIA AVE 4 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
82433 111159 2 1 201x EUGENIA AVE 6 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
87282 111156 2 1 201x EUGENIA AVE 3 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
97479 111154 2 1 201x EUGENIA AVE 1 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
100068 111158 2 1 201x EUGENIA AVE 5 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
114760 111155 2 1 201x EUGENIA AVE 2 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
106969 99110 2 36 94 Bernal Heights Blvd 1 14 1 1           6009548.4 2098143.7 37.741641931317396 -122.409577286243 (37.7416419313174, -122.409577286243)
99201 113439 2 180 401x POWHATTAN AVE 1 14 1 1     20 3x3   6008174.0 2098184.0 37.7416754763214 -122.41433236498301 (37.7416754763214, -122.414332364983)
104633 99112 2 36 80X Bradford St 1 14 1 1           6009564.7 2098208.3 37.741820222197596 -122.40952548431801 (37.7418202221976, -122.409525484318)
934 251409 2 3 95x Andover St 1 14 1 1       3x3   6007642.0 2098274.0 37.741892697320296 -122.41617822056101 (37.7418926973203, -122.416178220561)
101119 109309 2 3 349x MAYFLOWER ST 1 14 1 1           6009941.0 2098430.0 37.7424500403346 -122.40823998935801 (37.7424500403346, -122.408239989358)
110332 109200 2 36 2401x CASTRO ST 7 14 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
102606 112729 2 3 444 Franconia St 2 14 1 1     24     6009949.70212209 2098546.33795552 37.7427699663381 -122.40821810325701 (37.7427699663381, -122.408218103257)
127372 112739 2 47 444 Franconia St 3 14 1 1     30     6009949.70212209 2098546.33795552 37.7427699663381 -122.40821810325701 (37.7427699663381, -122.408218103257)
123850 107158 2 71 101x Elsie St 1 14 1 1     20     6007300.0 2098759.0 37.7432051631731 -122.417395111614 (37.7432051631731, -122.417395111614)
77461 107157 2 3 301X Esmeralda Ave 1 14 1 1     28     6007313.0 2098782.0 37.7432690474632 -122.41735179051201 (37.7432690474632, -122.417351790512)
69268 116648 3 193 199x Esmeralda Ave 3 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)
79334 116646 3 193 199x Esmeralda Ave 1 14 1 2     2     6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
82496 116652 3 193 199x Esmeralda Ave 7 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
92156 116653 3 26 199x Esmeralda Ave 8 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)
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)
101447 116661 3 3 199x Esmeralda Ave 14 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)
105412 116658 3 3 199x Esmeralda Ave 12 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
112048 116664 3 42 199x Esmeralda Ave 18 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
112164 116647 3 193 199x Esmeralda Ave 2 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
118788 116651 3 193 199x Esmeralda Ave 6 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
123372 116663 3 154 199x Esmeralda Ave 16 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
129308 116650 3 193 199x Esmeralda Ave 5 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)
145384 116657 3 3 199x Esmeralda Ave 11 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
145521 116649 3 193 199x Esmeralda Ave 4 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)
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)
3511 247940 4 58 29 Joy St 3 14 1 2     5   Permit Number 775404 6010280.31746 2098909.2881400003 37.7437850559498 -122.407100501782 (37.7437850559498, -122.407100501782)
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)
3506 247939 4 180 29 Joy St 2 14 1 2     12   Permit Number 775404 6010258.299769999 2098917.5156900003 37.7438064148349 -122.40717721395 (37.7438064148349, -122.40717721395)
3513 247938 4 16 29 Joy St 1 14 1 2     9   Permit Number 775404 6010254.90659 2098918.71089 37.7438095066969 -122.407189031056 (37.7438095066969, -122.407189031056)
78442 99274 2 3 16 Joy St 1 14 1 1       3x3 Permit Number 768828 6010347.9 2098933.4 37.7438550437031 -122.406868515265 (37.7438550437031, -122.406868515265)
95391 113478 3 38 100x ESMERALDA AVE 5 14 1 2     8     6006917.0 2098966.0 37.7437519821991 -122.418734104398 (37.7437519821991, -122.418734104398)
19241 116677 3 58 100 Esmeralda Ave 16 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
78555 116671 3 28 100 Esmeralda Ave 7 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)
86166 116675 3 180 100 Esmeralda Ave 14 14 1 2     14     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)
92622 116679 3 211 100 Esmeralda Ave 18 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
95360 116668 3 129 100x Esmeralda Ave 4 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)
97063 116666 3 3 100x Esmeralda Ave 2 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
110832 116665 3 3 100x Esmeralda Ave 1 14 1 2     25     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
113837 116669 3 47 100 Esmeralda Ave 6 14 1 2     20     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
Powered by Datasette · Query took 2.84ms · Data source: data.sfgov.org