sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
49696 248657 2 60 1000 San Jose Ave 111 7 1 1     6     6005025.16759 2096929.69692 37.7380540578596 -122.425130754104 (37.7380540578596, -122.425130754104)
176014 248656 2 60 1000 San Jose Ave 110 7 1 1     16     6005044.37292 2096931.03803 37.7380588251561 -122.42506444708 (37.7380588251561, -122.42506444708)
169087 248655 2 60 1000 San Jose Ave 107 7 1 1     16     6005056.20315 2096946.76695 37.7381026814961 -122.425024662861 (37.7381026814961, -122.425024662861)
47336 206320 2 60 700 Junipero Serra Blvd 102 4 1 1     17 Width 0ft   5991249.508230001 2092024.39965 37.7237975164261 -122.47240209038601 (37.7237975164261, -122.472402090386)
54591 248654 2 60 1000 San Jose Ave 81 7 1 1     15     6005089.97805 2097022.6793 37.7383130275105 -122.42491328541901 (37.7383130275105, -122.424913285419)
182006 142450 2 60 10 MAYFAIR DR 65 9 1 1     28 Width 0ft   5997309.2236 2114478.6465 37.7858001276963 -122.45307490578199 (37.7858001276963, -122.453074905782)
52759 142449 2 60 10 MAYFAIR DR 64 9 1 1     21 Width 0ft   5997336.6358 2114481.6923 37.785810061623295 -122.452980287706 (37.7858100616233, -122.452980287706)
73453 142447 2 60 10 MAYFAIR DR 62 9 1 1     23 Width 0ft   5997374.2006 2114486.4302 37.7858252233209 -122.45285066681299 (37.7858252233209, -122.452850666813)
148651 142446 2 60 10 MAYFAIR DR 61 9 1 1     15 Width 0ft   5997383.6764 2114487.7839 37.785829483217896 -122.45281798111 (37.7858294832179, -122.45281798111)
163868 142445 2 60 10 MAYFAIR DR 60 9 1 1     21 Width 0ft   5997392.137 2114489.8144 37.7858355432461 -122.452788856559 (37.7858355432461, -122.452788856559)
185549 142444 2 60 10 MAYFAIR DR 59 9 1 1     17 Width 0ft   5997400.5975 2114491.1681 37.785839744948 -122.45275968348301 (37.785839744948, -122.452759683483)
170692 142443 2 60 10 MAYFAIR DR 58 9 1 1     20 Width 0ft   5997409.7349 2114492.5218 37.785843985429395 -122.452728168531 (37.7858439854294, -122.452728168531)
57355 187371 2 60 2200 Sunset Blvd 56 9 1 1     15 Width 0ft   5985087.8176 2099932.3285 37.745152031922295 -122.494284331613 (37.7451520319223, -122.494284331613)
120871 142441 2 60 10 MAYFAIR DR 56 9 1 1     17 Width 0ft   5997429.025 2114493.8755 37.78584880764029 -122.452661528246 (37.7858488076403, -122.452661528246)
45228 142439 2 60 10 MAYFAIR DR 54 9 1 1     14 Width 0ft   5997443.9155 2114497.5981 37.7858598821031 -122.45261028028901 (37.7858598821031, -122.452610280289)
25216 142438 2 60 10 MAYFAIR DR 53 9 1 1     15 Width 0ft   5997453.3913 2114497.9365 37.7858613541886 -122.452577521257 (37.7858613541886, -122.452577521257)
70458 205113 3 60 800x Junipero Serra Blvd 52 11 1 2     12 Width 0ft   5991352.77429 2092808.82601 37.7259573327624 -122.47210226989701 (37.7259573327624, -122.472102269897)
154222 142437 2 60 10 MAYFAIR DR 52 9 1 1     22 Width 0ft   5997464.7285 2114499.2902 37.7858657206584 -122.452538395628 (37.7858657206584, -122.452538395628)
134038 212168 3 60 300x Marietta Dr 51 11 1 2     28 Width 5ft   5999567.44917 2097481.1748599997 37.7392584623161 -122.444040348193 (37.7392584623161, -122.444040348193)
153762 142436 2 60 10 MAYFAIR DR 51 9 1 1     12 Width 0ft   5997474.8811 2114498.9518 37.7858653731869 -122.45250324620599 (37.7858653731869, -122.452503246206)
48363 205112 3 60 800x Junipero Serra Blvd 50 11 1 2     10 Width 0ft   5991349.718230001 2092758.5362599997 37.7258190727658 -122.47210917039699 (37.7258190727658, -122.472109170397)
60448 142435 2 60 10 MAYFAIR DR 50 9 1 1     20 Width 0ft   5997482.3264 2114500.9823 37.7858713749679 -122.452477634253 (37.7858713749679, -122.452477634253)
30424 205111 3 60 800x Junipero Serra Blvd 49 11 1 2     5 Width 0ft   5991346.44389 2092729.4529400002 37.725739027717204 -122.472118370494 (37.7257390277172, -122.472118370494)
38991 142434 2 60 10 MAYFAIR DR 49 9 1 1     10 Width 0ft   5997490.7869 2114502.336 37.7858755765928 -122.45244846114599 (37.7858755765928, -122.452448461146)
47368 248653 2 60 1001 San Jose Ave 48 7 1 1     19     6005296.42687 2097177.8941099998 37.738750871460205 -122.424210521903 (37.7387508714602, -122.424210521903)
133275 142433 2 60 10 MAYFAIR DR 48 9 1 1     16 Width 0ft   5997499.5859 2114503.0128 37.7858779390155 -122.45241806806101 (37.7858779390155, -122.452418068061)
172148 205110 3 60 800x Junipero Serra Blvd 48 11 1 2     7 Width 0ft   5991343.90426 2092703.6667900002 37.725668078393504 -122.472125270987 (37.7256680783935, -122.472125270987)
149712 142432 2 60 10 MAYFAIR DR 47 9 1 1     14 Width 0ft   5997511.0923 2114504.0281 37.785881385969 -122.45237833260401 (37.785881385969, -122.452378332604)
159485 205109 3 60 800x Junipero Serra Blvd 47 11 1 2     4 Width 0ft   5991344.09487 2092681.13577 37.7256062248454 -122.472122970506 (37.7256062248454, -122.472122970506)
155157 142431 2 60 10 MAYFAIR DR 46 9 1 1     15 Width 0ft   5997523.9523 2114506.3971 37.785888627357004 -122.452334011803 (37.785888627357, -122.452334011803)
38069 206319 2 60 500 Junipero Serra Blvd 45 4 1 1     16 Width 0ft   5991343.42057 2093507.86668 37.7278761829176 -122.472185537258 (37.7278761829176, -122.472185537258)
64888 142430 2 60 10 MAYFAIR DR 45 9 1 1     15 Width 0ft   5997534.1049 2114507.4123 37.7858919964517 -122.452298960079 (37.7858919964517, -122.452298960079)
156791 248646 2 60 701 Church St 45 7 1 1     24     6004337.8277 2104713.595 37.759387983176 -122.42806177235501 (37.759387983176, -122.428061772355)
68941 205108 3 60 800x Junipero Serra Blvd 44 11 1 2     8 Width 0ft   5991339.84346 2092605.6938200002 37.7253988339751 -122.472132170572 (37.7253988339751, -122.472132170572)
70422 205090 3 60 1000x Junipero Serra Blvd 44 11 1 2     4 Width 0ft   5991232.93514 2090942.88536 37.7208269864641 -122.472380575028 (37.7208269864641, -122.472380575028)
182289 142429 2 60 10 MAYFAIR DR 44 9 1 1     16 Width 0ft   5997546.2881 2114509.7813 37.785899199038404 -122.45225698079399 (37.7858991990384, -122.452256980794)
30306 248645 2 60 701 Church St 43 7 1 1     26     6004348.66213 2104681.30747 37.7592999422487 -122.428022000737 (37.7592999422487, -122.428022000737)
157168 142428 2 60 10 MAYFAIR DR 43 9 1 1     13 Width 0ft   5997554.4102 2114510.1197 37.785900593478296 -122.45222890514201 (37.7859005934783, -122.452228905142)
41642 142427 2 60 10 MAYFAIR DR 42 9 1 1     27 Width 0ft   5997563.2092 2114510.7965 37.7859029558443 -122.45219851203998 (37.7859029558443, -122.45219851204)
169141 205089 3 60 1000x Junipero Serra Blvd 42 11 1 2     6 Width 0ft   5991231.16702 2090890.57712 37.7206832586037 -122.47238287549601 (37.7206832586037, -122.472382875496)
31200 205107 3 60 800x Junipero Serra Blvd 41 11 1 2     6 Width 0ft   5991336.964 2092532.2101 37.7251968993055 -122.472136770613 (37.7251968993055, -122.472136770613)
44624 205088 3 60 1000x Junipero Serra Blvd 41 11 1 2     11 Width 0ft   5991229.30633 2090865.43732 37.7206141232198 -122.47238747550301 (37.7206141232198, -122.472387475503)
9233 25445 1 60 1400X La Salle Ave 40 1 1 1     24 3X3   6016123.98501 2095766.22901 37.735480146065505 -122.386675167071 (37.7354801460655, -122.386675167071)
51820 142425 2 60 10 MAYFAIR DR 40 9 1 1     10 Width 0ft   5997580.8071 2114513.5039 37.7859113977237 -122.45213782389 (37.7859113977237, -122.45213782389)
55194 248652 2 60 1001 San Jose Ave 40 7 1 1     15     6005286.42848 2097142.8356 37.7386540441353 -122.42424259893801 (37.7386540441353, -122.424242598938)
65755 205087 3 60 1000x Junipero Serra Blvd 40 11 1 2     5 Width 0ft   5991229.32936 2090834.95737 37.7205304341251 -122.47238517504499 (37.7205304341251, -122.472385175045)
66048 205106 3 60 800x Junipero Serra Blvd 40 11 1 2     10 Width 0ft   5991333.82922 2092509.74916 37.7251350457334 -122.47214597065901 (37.7251350457334, -122.472145970659)
132536 212167 3 60 300x Marietta Dr 40 11 1 2     16 Width 5ft   5999468.42079 2097513.2025099997 37.7393407529711 -122.444385043934 (37.7393407529711, -122.444385043934)
24862 142424 2 60 10 MAYFAIR DR 39 9 1 1     30 Width 0ft   5997593.3287 2114514.5192 37.78591490273521 -122.452094576108 (37.7859149027352, -122.452094576108)
47528 205105 3 60 800x Junipero Serra Blvd 39 11 1 2     7 Width 0ft   5991330.58276 2092481.99012 37.7250586384304 -122.472155170739 (37.7250586384304, -122.472155170739)
162734 212166 3 60 300x Marietta Dr 39 11 1 2     15 Width 5ft   5999464.98652 2097513.89815 37.7393424670869 -122.444396968055 (37.7393424670869, -122.444396968055)
182927 205086 3 60 1000x Junipero Serra Blvd 39 11 1 2     12 Width 0ft   5991226.90116 2090814.4677099998 37.7204740340313 -122.472392075543 (37.7204740340313, -122.472392075543)
9314 12158 1 60 1400X La Salle Ave 38 1 1 1     18 3X3   6016158.70701 2095735.6730099998 37.735398167686206 -122.38655298897699 (37.7353981676862, -122.386552988977)
156267 205085 3 60 1000x Junipero Serra Blvd 38 11 1 2     4 Width 0ft   5991225.77549 2090792.62573 37.720413996187 -122.47239437511601 (37.720413996187, -122.472394375116)
161718 205104 3 60 800x Junipero Serra Blvd 38 11 1 2     7 Width 0ft   5991328.11288 2092459.51484 37.7249967839599 -122.47216207124399 (37.7249967839599, -122.472162071244)
183413 142423 2 60 10 MAYFAIR DR 38 9 1 1     26 Width 0ft   5997605.1735 2114516.8881 37.7859220855908 -122.45205376754801 (37.7859220855908, -122.452053767548)
9353 12157 1 60 1400X La Salle Ave 37 1 1 1     12 3X3   6016176.76201 2095719.00601 37.73535340295211 -122.386489403775 (37.7353534029521, -122.386489403775)
62029 142422 2 60 10 MAYFAIR DR 37 9 1 1     12 Width 0ft   5997618.0335 2114520.9492 37.7859339729155 -122.452009568816 (37.7859339729155, -122.452009568816)
67761 206306 3 60 500x Junipero Serra Blvd 37 11 1 2     5 Width 0ft   5991444.74092 2094236.6421299998 37.7298830812226 -122.471888366154 (37.7298830812226, -122.471888366154)
182952 205103 3 60 800x Junipero Serra Blvd 37 11 1 2     4 Width 0ft   5991326.973119999 2092437.01185 37.724934930379206 -122.47216437168899 (37.7249349303792, -122.472164371689)
9472 12156 1 60 1400X La Salle Ave 36 1 1 1     18 3X3   6016192.73501 2095700.95101 37.7353047117642 -122.386432920212 (37.7353047117642, -122.386432920212)
67638 205084 3 60 1000x Junipero Serra Blvd 36 11 1 2     4 Width 0ft   5991220.51447 2090732.43963 37.720248435491904 -122.472408175222 (37.7202484354919, -122.472408175222)
149555 206305 3 60 500x Junipero Serra Blvd 36 11 1 2     5 Width 0ft   5991441.0529 2094219.4945900002 37.729835784970795 -122.471899866683 (37.7298357849708, -122.471899866683)
181938 205102 3 60 800x Junipero Serra Blvd 36 11 1 2     4 Width 0ft   5991324.44766 2092411.88768 37.7248657994962 -122.472171271311 (37.7248657994962, -122.472171271311)
20236 29626 3 60 900X Junipero Serra Blvd 35 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991174.60245 2090776.1353200001 37.720365755664794 -122.47257006037901 (37.7203657556648, -122.472570060379)
69407 205083 3 60 1000x Junipero Serra Blvd 35 11 1 2     6 Width 0ft   5991217.1837 2090700.70485 37.720161106826 -122.472417376171 (37.720161106826, -122.472417376171)
73277 142420 2 60 10 MAYFAIR DR 35 9 1 1     30 Width 0ft   5997641.3846 2114523.995 37.785943673381205 -122.45192900064899 (37.7859436733812, -122.451929000649)
137633 212165 3 60 300x Marietta Dr 35 11 1 2     24 Width 5ft   5999417.343780001 2097526.3409700003 37.73937391367561 -122.444562589009 (37.7393739136756, -122.444562589009)
156000 206304 3 60 500x Junipero Serra Blvd 35 11 1 2     11 Width 0ft   5991440.53654 2094194.9922900002 37.72976847791129 -122.47189986669599 (37.7297684779113, -122.471899866696)
157717 205101 3 60 800x Junipero Serra Blvd 35 11 1 2     5 Width 0ft   5991325.17756 2092383.3819099998 37.724787571970296 -122.47216667126101 (37.7247875719703, -122.472166671261)
166630 189402 3 60 900x Carolina St 35 3 1 2     31     6012483.079 2103205.45107 37.755704417647294 -122.399785428875 (37.7557044176473, -122.399785428875)
9127 12154 1 60 1400X La Salle Ave 34 1 1 1     12 3X3   6016226.76201 2095667.61701 37.735215066832104 -122.386312951947 (37.7352150668321, -122.386312951947)
31895 206303 3 60 500x Junipero Serra Blvd 34 11 1 2     7 Width 0ft   5991439.20179 2094163.2193200001 37.7296811600564 -122.47190216624901 (37.7296811600564, -122.471902166249)
38226 142419 2 60 10 MAYFAIR DR 34 9 1 1     29 Width 0ft   5997648.4915 2114525.3487 37.7859477973415 -122.451904510544 (37.7859477973415, -122.451904510544)
72304 205082 3 60 1000x Junipero Serra Blvd 34 11 1 2     7 Width 0ft   5991216.27623 2090657.6545099998 37.720042848675604 -122.47241737616501 (37.7200428486756, -122.472417376165)
161984 205100 3 60 800x Junipero Serra Blvd 34 11 1 2     6 Width 0ft   5991322.5960099995 2092355.6088599998 37.724711164672705 -122.472173571767 (37.7247111646727, -122.472173571767)
14800 12153 1 60 1400X La Salle Ave 33 1 1 1     12 3X3   6016182.90625 2095712.9210700002 37.7353370350581 -122.386467736523 (37.7353370350581, -122.386467736523)
133644 205099 3 60 800x Junipero Serra Blvd 33 11 1 2     11 Width 0ft   5991320.805269999 2092333.78187 37.724651129544 -122.47217817178002 (37.724651129544, -122.47217817178)
136328 142418 2 60 10 MAYFAIR DR 33 9 1 1     25 Width 0ft   5997662.3668 2114527.0408 37.785953238114 -122.451856628165 (37.785953238114, -122.451856628165)
14350 12152 3 60 1400X La Salle Ave 32 1 1 2   05/17/1996 12:00:00 AM 6 3X3   6016198.01461 2095698.1267099997 37.7352972490591 -122.386414469663 (37.7352972490591, -122.386414469663)
31596 205081 3 60 1000x Junipero Serra Blvd 32 11 1 2     8 Width 0ft   5991210.7499 2090584.88401 37.7198427189488 -122.47243117628099 (37.7198427189488, -122.472431176281)
39124 142417 2 60 10 MAYFAIR DR 32 9 1 1     14 Width 0ft   5997674.55 2114528.3945 37.785957652798 -122.451814575532 (37.785957652798, -122.451814575532)
45530 206423 3 60 400x Marietta Dr 32 11 1 2     14 Width 3ft   5999166.42001 2097010.61151 37.737943522178504 -122.445393096728 (37.7379435221785, -122.445393096728)
108860 24456 1 60 799X Junipero Serra Blvd 31 1 1 13   06/22/1995 12:00:00 AM 12 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
147406 212283 2 60 751 Junipero Serra Blvd 31 2 1 1     15 Width 3ft   5991413.76911 2093002.29122 37.726492069641 -122.47190551083 (37.726492069641, -122.47190551083)
150003 142416 2 60 10 MAYFAIR DR 31 9 1 1     11 Width 0ft   5997686.3947 2114529.7482 37.78596204808029 -122.451773694005 (37.7859620480803, -122.451773694005)
174777 205080 3 60 1000x Junipero Serra Blvd 31 11 1 2     8 Width 0ft   5991211.60542 2090562.33735 37.7197808608892 -122.47242657625 (37.7197808608892, -122.47242657625)
14130 12150 3 60 1400X La Salle Ave 30 1 1 2   05/17/1996 12:00:00 AM 2 3X3   6016234.16268 2095665.57813 37.735209878118 -122.386287222793 (37.735209878118, -122.386287222793)
42502 142415 2 60 10 MAYFAIR DR 30 9 1 1     17 Width 0ft   5997700.27 2114531.1019 37.785966559642794 -122.451725787187 (37.7859665596428, -122.451725787187)
71529 176016 3 60 700x Mansell St 30 11 1 2     31 Width 0ft   6009216.97292 2089964.58671 37.7191652533595 -122.410145941702 (37.7191652533595, -122.410145941702)
73785 205079 3 60 1000x Junipero Serra Blvd 30 11 1 2     13 Width 0ft   5991209.0936900005 2090537.87387 37.7197135448202 -122.47243347583 (37.7197135448202, -122.47243347583)
80752 24398 1 60 799X Junipero Serra Blvd 30 1 1 13   03/01/2000 12:00:00 AM 12 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
159831 212282 2 60 751 Junipero Serra Blvd 30 2 1 1     6 Width 3ft   5991411.32325 2092975.49462 37.7264183513201 -122.471912013829 (37.7264183513201, -122.471912013829)
15841 12149 1 60 1400X La Salle Ave 29 1 1 1     12 3X3   6016248.95724 2095649.3696400002 37.735166191751 -122.38623494249399 (37.735166191751, -122.386234942494)
43527 205098 3 60 800x Junipero Serra Blvd 29 11 1 2     7 Width 0ft   5991316.70247 2092233.8206900002 37.724376423516105 -122.472185071407 (37.7243764235161, -122.472185071407)
67815 142414 2 60 10 MAYFAIR DR 29 9 1 1     24 Width 0ft   5997709.7458 2114531.1019 37.7859671023257 -122.451693003671 (37.7859671023257, -122.451693003671)
158549 205078 3 60 1000x Junipero Serra Blvd 29 11 1 2     9 Width 0ft   5991207.21899 2090512.07145 37.7196425892212 -122.47243807587601 (37.7196425892212, -122.472438075876)
164373 212164 3 60 300x Marietta Dr 29 11 1 2     18 Width 5ft   5999306.41715 2097560.47752 37.7394613142828 -122.444948576214 (37.7394613142828, -122.444948576214)
165991 206302 3 60 500x Junipero Serra Blvd 29 11 1 2     3 Width 0ft   5991428.71854 2094013.04751 37.729268219243394 -122.471927466905 (37.7292682192434, -122.471927466905)
39182 205077 3 60 1000x Junipero Serra Blvd 28 11 1 2     12 Width 0ft   5991206.77223 2090490.8774299999 37.719584369801396 -122.47243807587601 (37.7195843698014, -122.472438075876)
122809 109028 2 60 1800x FOLSOM ST 28 1 1 1       3x3   6007970.1 2107738.8 37.7678993280557 -122.41571376452801 (37.7678993280557, -122.415713764528)
Powered by Datasette · Query took 29.909ms · Data source: data.sfgov.org