sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
176194 187582 2 30 747 University St 3 17 1 1     12     6008739.08909 2090759.6184900003 37.7213214463175 -122.41185395930799 (37.7213214463175, -122.411853959308)
108210 122590 2 30 100 MacOndray Ln 1 14 1 1           6008161.0 2119143.0 37.7992232381339 -122.415861106147 (37.7992232381339, -122.415861106147)
47731 227663 2 30 6 Unnamed 011 1 13 1 1     13 Width 10ft   6002739.4908 2096074.90228 37.735577602816896 -122.432972414242 (37.7355776028169, -122.432972414242)
162970 246778 2 30 392 Franconia St 2 13 1 1     12     6009934.469769999 2098852.71045 37.7436103455484 -122.408292376913 (37.7436103455484, -122.408292376913)
188401 207079 2 30 59 Ralston St 3 13 1 1     12     5992173.18035 2088300.4585900002 37.7136258989769 -122.46893826428699 (37.7136258989769, -122.468938264287)
45037 129425 2 30 2149 Broadway 1 10 1 1     3 Width 4ft   6003239.07369 2117504.42466 37.794446200597 -122.432775535577 (37.794446200597, -122.432775535577)
54446 129451 2 30 1147 Filbert St 1 10 1 1     9 Width 3ft   6007395.89235 2119499.90916 37.80016017810029 -122.418533970572 (37.8001601781003, -122.418533970572)
55147 246315 2 30 1660 Mission St 2 10 1 1     5 Width 0ft   6006857.4528 2108984.4305 37.7712569245067 -122.419650681714 (37.7712569245067, -122.419650681714)
56470 129438 2 30 715 Bush St 3 10 1 1     3 Width 4ft   6010041.47641 2115755.35321 37.790027121797294 -122.409114812309 (37.7900271217973, -122.409114812309)
65596 129426 2 30 2149 Broadway 2 10 1 1     3 Width 4ft   6003248.10705 2117506.03033 37.7944511216749 -122.432744393832 (37.7944511216749, -122.432744393832)
132516 246316 2 30 1660 Mission St 3 10 1 1     5 Width 0ft   6006848.8767 2108962.1326 37.7711952166815 -122.41967876451 (37.7711952166815, -122.41967876451)
146728 246318 2 30 1660 Mission St 5 10 1 1     4 Width 0ft   6006836.8702 2108926.9706 37.7710979938489 -122.419717800254 (37.7710979938489, -122.419717800254)
151998 129437 2 30 715 Bush St 2 10 1 1     3 Width 4ft   6010035.0094 2115756.1647799998 37.790028987884895 -122.409137245009 (37.7900289878849, -122.409137245009)
162927 246317 2 30 1660 Mission St 4 10 1 1     5 Width 0ft   6006842.0158 2108939.8347 37.771133605468705 -122.419700914309 (37.7711336054687, -122.419700914309)
163894 129427 2 30 2149 Broadway 3 10 1 1     3 Width 4ft   6003257.40294 2117505.83832 37.794451121666604 -122.43271221522 (37.7944511216666, -122.43271221522)
171961 129439 2 30 715 Bush St 4 10 1 1     3 Width 4ft   6010043.54378 2115756.3306400003 37.7900299214 -122.409107728349 (37.7900299214, -122.409107728349)
173661 191249 2 30 2300 18th St 3 10 1 1     6 Width 10ft   6010915.57021 2105542.63703 37.7620342994705 -122.405370986778 (37.7620342994705, -122.405370986778)
182481 129436 2 30 715 Bush St 1 10 1 1     3 Width 4ft   6010030.57511 2115756.25526 37.7900289879055 -122.409152593735 (37.7900289879055, -122.409152593735)
187192 246314 2 30 1660 Mission St 1 10 1 1     4 Width 0ft   6006868.6018 2109014.4469 37.7713399704187 -122.419614246796 (37.7713399704187, -122.419614246796)
22918 191269 2 30 538 Delancey St 6 9 1 1     8     6015147.69888 2113724.07494 37.7847344271845 -122.391305511737 (37.7847344271845, -122.391305511737)
28130 191253 2 30 654 Minnesota St 12 9 1 1     3 Width 10ft   6015148.44265 2105367.15882 37.7617882296504 -122.39071873558599 (37.7617882296504, -122.390718735586)
35185 129454 2 30 855 Chestnut St 3 9 1 1     5 Width 6ft   6007720.06236 2120575.53372 37.8031318169374 -122.41748848713002 (37.8031318169374, -122.41748848713)
36009 186909 2 30 2700 Sunset Blvd 58 9 1 1     2 Width 0ft   5985192.0104 2096702.7177 37.7362904860675 -122.49368611859501 (37.7362904860675, -122.493686118595)
36838 191250 2 30 654 Minnesota St 8 9 1 1     5 Width 10ft   6015147.38841 2105382.23529 37.7618295678896 -122.390723435432 (37.7618295678896, -122.390723435432)
43531 191264 2 30 801 Arkansas St 30 9 1 1     19     6013055.03201 2103799.19748 37.7573665842245 -122.39784906707399 (37.7573665842245, -122.397849067074)
46474 129453 2 30 855 Chestnut St 2 9 1 1     4 Width 6ft   6007720.64474 2120576.4205400003 37.8031342846895 -122.417486534671 (37.8031342846895, -122.417486534671)
49285 129456 2 30 855 Chestnut St 5 9 1 1     3 Width 6ft   6007719.74229 2120576.43903 37.803134284681 -122.41748965894199 (37.803134284681, -122.417489658942)
51023 185052 2 30 2715 41st Ave 2 9 1 1     3 Width 0ft   5983668.1125 2096649.8142 37.7360559577629 -122.498950875232 (37.7360559577629, -122.498950875232)
56239 191252 2 30 654 Minnesota St 10 9 1 1     3 Width 10ft   6015147.22099 2105373.94992 37.761806808764796 -122.390723435452 (37.7618068087648, -122.390723435452)
57630 191251 2 30 654 Minnesota St 9 9 1 1     5 Width 10ft   6015148.84129 2105378.48456 37.7618193498029 -122.39071814833599 (37.7618193498029, -122.390718148336)
61708 227660 2 30 195 Beacon St 1 9 1 1     8 Width 2ft   6003113.10037 2097586.0775 37.73974812787179 -122.43178856828101 (37.7397481278718, -122.431788568281)
62772 185051 2 30 2715 41st Ave 1 9 1 1     3 Width 0ft   5983667.0512 2096660.9577 37.736086492552 -122.49895536756901 (37.736086492552, -122.498955367569)
62886 227610 2 30 400 Prospect Ave 6 9 1 1     25     6006250.04952 2097648.9456700003 37.7400980729811 -122.420946773391 (37.7400980729811, -122.420946773391)
65391 129455 2 30 855 Chestnut St 4 9 1 1     5 Width 6ft   6007721.09596 2120576.41129 37.8031342846798 -122.41748497255199 (37.8031342846798, -122.417484972552)
66851 191268 2 30 538 Delancey St 5 9 1 1     4     6015150.51675 2113731.33336 37.7847545135408 -122.391296270324 (37.7847545135408, -122.391296270324)
71134 187130 2 30 2600 Sunset Blvd 66 9 1 1     1 Width 0ft   5985156.874 2097417.7557 37.73825173359629 -122.49386027578899 (37.7382517335963, -122.493860275789)
74356 186817 2 30 1200 Sunset Blvd 110 9 1 1     2 Width 0ft   5984826.8059 2106810.865 37.7640233139964 -122.49569412937599 (37.7640233139964, -122.495694129376)
76720 129452 2 30 855 Chestnut St 1 9 1 1     5 Width 6ft   6007720.96455 2120575.51523 37.803131816931206 -122.41748536375799 (37.8031318169312, -122.417485363758)
105637 96626 1 30 145 Sutro Heights Ave 1 9 1 1   06/10/2011 12:00:00 AM     Permit Number 767986 5981103.1 2111247.3 37.775985700966395 -122.50890252539 (37.7759857009664, -122.50890252539)
144733 96627 1 30 145 Sutro Heights Ave 2 9 1 1   06/10/2011 12:00:00 AM     Permit Number 767986 5981103.1 2111247.3 37.775985700966395 -122.50890252539 (37.7759857009664, -122.50890252539)
154095 248214 2 30 67 Fair Ave 4 9 1 1     18 Width 6ft   6006956.2223 2099478.83098 37.7451623091856 -122.41863484214 (37.7451623091856, -122.41863484214)
155770 191267 2 30 538 Delancey St 3 9 1 1     7     6015157.461180001 2113744.4936599997 37.7847910341296 -122.391273164948 (37.7847910341296, -122.391273164948)
155958 227621 2 30 1335 Douglass St 5 9 1 1     5 Width 4ft   6001398.3282 2099807.1524799997 37.7457493236871 -122.43787655407499 (37.7457493236871, -122.437876554075)
157008 187077 2 30 2600 Sunset Blvd 13 9 1 1     2 Width 0ft   5985155.4633 2096938.6014 37.736936021545 -122.493829852855 (37.736936021545, -122.493829852855)
159621 186908 2 30 2700 Sunset Blvd 57 9 1 1     2 Width 0ft   5985188.8014 2096694.9245 37.736268900285 -122.493696639188 (37.736268900285, -122.493696639188)
160010 176926 2 30 200 Morse St 5 9 1 1     23 Width 10ft   6000586.22066 2087873.8924099999 37.712937131606395 -122.439829268227 (37.7129371316064, -122.439829268227)
161451 227601 2 30 1100 San Jose Ave 48 9 1 1     13     6004769.19859 2096667.0685 37.7373184762576 -122.425997076417 (37.7373184762576, -122.425997076417)
162520 227662 2 30 32 Harry St 10 9 1 1     4 Width 10ft   6003182.99622 2097643.55659 37.7399099141156 -122.43155100069099 (37.7399099141156, -122.431551000691)
166791 191265 2 30 2100 Thomas Ave 2 9 1 1     10     6012134.75084 2095927.2478099999 37.735700607590296 -122.400478845738 (37.7357006075903, -122.400478845738)
168581 227609 2 30 400 Prospect Ave 5 9 1 1     33     6006260.1728300005 2097644.39448 37.740086147061 -122.420911448013 (37.740086147061, -122.420911448013)
168888 176927 2 30 200 Morse St 6 9 1 1     30 Width 10ft   6000575.21017 2087869.90013 37.7129255429455 -122.43986703794201 (37.7129255429455, -122.439867037942)
182154 207098 2 30 144 Mangels Ave 4 9 1 1     9     6000468.8354 2095254.59465 37.733196173744105 -122.440764091915 (37.7331961737441, -122.440764091915)
187273 176963 2 30 83 Badger St 7 9 1 1     15 Width 2ft   6002428.97482 2094295.2581 37.7306734890866 -122.43391881851299 (37.7306734890866, -122.433918818513)
103688 92051 3 30 2323 Cesar Chavez St   8 1 2   05/16/2009 12:00:00 AM       6012395.8634440005 2100936.77011 37.749470250033795 -122.399927744224 (37.7494702500338, -122.399927744224)
140608 92050 3 30 2323 Cesar Chavez St   8 1 2   05/16/2009 12:00:00 AM       6012395.8634440005 2100936.77011 37.749470250033795 -122.399927744224 (37.7494702500338, -122.399927744224)
26504 227603 2 30 1201 San Jose Ave 55 7 1 1     2     6004504.07862 2096101.1879099999 37.735749708773795 -122.42687342978998 (37.7357497087738, -122.42687342979)
44798 227608 2 30 1201 San Jose Ave 73 7 1 1     3     6004572.06439 2096162.43718 37.7359217292935 -122.426642736581 (37.7359217292935, -122.426642736581)
54300 227606 2 30 1201 San Jose Ave 60 7 1 1     3     6004509.90475 2096122.13365 37.7358075504724 -122.426854777822 (37.7358075504724, -122.426854777822)
69112 187585 2 30 748 University St 1 7 1 1     19     6008708.47344 2090752.4419999998 37.7213000235466 -122.411959282496 (37.7213000235466, -122.411959282496)
95709 98492 6 30 2149 Laguna St 1 7 1 1           6004211.7 2116183.0 37.7908730187591 -122.429315856087 (37.7908730187591, -122.429315856087)
107985 92049 3 30 2323 Cesar Chavez St   7 1 2   05/16/2009 12:00:00 AM       6012395.8634440005 2100936.77011 37.749470250033795 -122.399927744224 (37.7494702500338, -122.399927744224)
148811 247957 2 30 8 Joy St 1 7 1 1     41     6010434.9927199995 2098878.7541 37.743709870826 -122.40656351750602 (37.743709870826, -122.406563517506)
165842 227605 2 30 1201 San Jose Ave 58 7 1 1     2     6004504.61589 2096121.06345 37.735804312902204 -122.426872987299 (37.7358043129022, -122.426872987299)
166757 227604 2 30 1201 San Jose Ave 57 7 1 1     4     6004502.9106 2096117.99556 37.7357957927473 -122.426878664735 (37.7357957927473, -122.426878664735)
184269 227602 2 30 1201 San Jose Ave 54 7 1 1     1     6004494.61967 2096104.27773 37.735757657887994 -122.426906353066 (37.735757657888, -122.426906353066)
184382 227607 2 30 1201 San Jose Ave 61 7 1 1     2     6004513.177130001 2096122.0643 37.735807545078295 -122.426843458979 (37.7358075450783, -122.426843458979)
95348 97442 1 30 1900@Gough Pacific Ave 2 5 1 1           6004943.9 2117474.7 37.794461125583794 -122.42687450783701 (37.7944611255838, -122.426874507837)
26163 247176 2 30 111 Buena Vista Ave East 1 4 1 1     5 Width 4ft   6001288.35672 2108578.65763 37.7698274924813 -122.438885293015 (37.7698274924813, -122.438885293015)
56432 227632 2 30 71 Clarendon Ave 1 4 1 1     9 Width 3ft   5997905.871119999 2104612.50701 37.758744422044295 -122.450299233916 (37.7587444220443, -122.450299233916)
56561 191262 2 30 690 Wisconsin St 5 4 1 1     15 Width 3ft   6012676.19431 2104276.36771 37.7586556841436 -122.399192740559 (37.7586556841436, -122.399192740559)
58867 247173 2 30 141 Buena Vista Ave East 1 4 1 1     6 Width 4ft   6001348.76723 2108505.96887 37.7696313440465 -122.438671125768 (37.7696313440465, -122.438671125768)
76698 227631 2 30 75 Clarendon Ave 1 4 1 1     9 Width 3ft   5997896.0946 2104612.71078 37.758744422037395 -122.450333060142 (37.7587444220374, -122.450333060142)
131733 191263 2 30 728 Wisconsin St 2 4 1 1     13 Width 3ft   6012693.0382199995 2104091.70249 37.7581495726586 -122.399121524154 (37.7581495726586, -122.399121524154)
136118 250773 2 30 259 32nd Ave 1 4 1 1     14 Width 3ft   5985865.92055 2114194.89594 37.7843585636424 -122.492644052605 (37.7843585636424, -122.492644052605)
156796 191266 2 30 1721 Revere Ave 1 4 1 1     25 Width 9ft   6014437.69224 2094855.17275 37.7328850694924 -122.39244165855499 (37.7328850694924, -122.392441658555)
156929 217749 2 30 445 West Portal Ave 1 4 1 1     2 Width 3ft   5991783.05973 2096405.3403 37.7358573522267 -122.470876685538 (37.7358573522267, -122.470876685538)
159965 176962 2 30 121 Saint Charles Ave 1 4 1 1     12 Width 2ft   5992069.06615 2087619.0428799998 37.71174887986621 -122.46924855110301 (37.7117488798662, -122.469248551103)
174454 227588 2 30 435 Oak St 1 4 1 1     3 Width 3ft   6004887.16184 2110182.76224 37.77443606920671 -122.42655134748001 (37.7744360692067, -122.42655134748)
177184 191261 2 30 690 Wisconsin St 3 4 1 1     18 Width 3ft   6012675.54577 2104288.99957 37.7586903323146 -122.399195870217 (37.7586903323146, -122.399195870217)
60646 191259 3 30 900x Carolina St 27 3 1 2     17     6012470.08805 2103421.28043 37.7562963136528 -122.39984551077299 (37.7562963136528, -122.399845510773)
23452 207071 2 30 1927 08th Ave 3 2 1 1     11 Width 6ft   5993749.481269999 2102344.6615 37.752278758765605 -122.464509159894 (37.7522787587656, -122.464509159894)
31453 207072 2 30 245 Pacheco St 1 2 1 1     3 Width 4ft   5994440.698340001 2100406.16627 37.7469959638947 -122.46197828057899 (37.7469959638947, -122.461978280579)
33222 207070 2 30 1927 08th Ave 2 2 1 1     10 Width 6ft   5993749.21516 2102356.41341 37.752311011160295 -122.464510933358 (37.7523110111603, -122.464510933358)
34497 191363 2 30 955 Key Ave 1 2 1 1     13     6013550.52728 2089583.75311 37.7183615103672 -122.395139727222 (37.7183615103672, -122.395139727222)
42271 207076 2 30 230 Pacheco St 4 2 1 1     9 Width 6ft   5994497.66006 2100431.13069 37.7470677891411 -122.461783123205 (37.7470677891411, -122.461783123205)
45787 207074 2 30 230 Pacheco St 2 2 1 1     9 Width 6ft   5994502.2451599995 2100385.66213 37.7469432078786 -122.46176397213301 (37.7469432078786, -122.461763972133)
46195 207077 2 30 230 Pacheco St 5 2 1 1     9 Width 6ft   5994500.88494 2100452.87217 37.74712767141 -122.461773548104 (37.74712767141, -122.461773548104)
47675 176920 2 30 671 London St 3 2 1 1     6     6001061.12784 2089906.70665 37.718545806627205 -122.43833338090299 (37.7185458066272, -122.438333380903)
56287 227611 2 30 66 Balmy St 1 2 1 1     15 Width 3ft   6008811.16325 2101739.4503099998 37.751473726132005 -122.412380510571 (37.751473726132, -122.412380510571)
62217 250619 2 30 114 28th Ave 1 2 1 1     4 Width 4ft   5987113.722030001 2115192.60557 37.7871708695801 -122.48840049988002 (37.7871708695801, -122.48840049988)
130451 176925 2 30 17 Curtis St 2 2 1 1     1 Width 4ft   6000534.5551 2088493.30994 37.7146349724878 -122.440052229032 (37.7146349724878, -122.440052229032)
133413 250533 2 30 69 26th Ave 1 2 1 1     10 Width 6ft   5987683.92995 2115503.12844 37.7880567296852 -122.48645053678601 (37.7880567296852, -122.486450536786)
136250 250532 2 30 79 26th Ave 1 2 1 1     11 Width 6ft   5987685.24066 2115481.63254 37.787997784513294 -122.486444423174 (37.7879977845133, -122.486444423174)
154559 250620 2 30 114 28th Ave 2 2 1 1     4 Width 4ft   5987116.07946 2115204.5954 37.7872039277514 -122.48839322528099 (37.7872039277514, -122.488393225281)
163085 183580 2 30 2614 26th Ave 1 2 1 1     2 Width 0ft   5988349.2799 2097484.0905 37.7386201346216 -122.482827506776 (37.7386201346216, -122.482827506776)
168398 129401 2 30 5 Dicha Aly 3 2 1 1     7 Width 4ft   5998309.94171 2113772.92465 37.7839197016653 -122.449561847418 (37.7839197016653, -122.449561847418)
171953 207069 2 30 1927 08th Ave 1 2 1 1     14 Width 6ft   5993748.4844 2102370.47272 37.752349572298606 -122.46451448116999 (37.7523495722986, -122.46451448117)
175597 207073 2 30 230 Pacheco St 1 2 1 1     9 Width 6ft   5994505.45248 2100370.5542599997 37.746901910105 -122.46175178633601 (37.746901910105, -122.461751786336)
175752 183581 2 30 2614 26th Ave 2 2 1 1     2 Width 0ft   5988348.717 2097504.9177 37.738677287922 -122.48283097892299 (37.738677287922, -122.482830978923)
176799 182968 2 30 2501 19th Ave 1 2 1 1     4 Width 0ft   5990431.4773 2098333.0499 37.7410720891089 -122.475690312642 (37.7410720891089, -122.475690312642)
182340 207075 2 30 230 Pacheco St 3 2 1 1     10 Width 6ft   5994498.162330001 2100407.0553599996 37.7470017132656 -122.461779641027 (37.7470017132656, -122.461779641027)
Powered by Datasette · Query took 9.763ms · Data source: data.sfgov.org