sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
24196 198273 2 51 101 Pennsylvania Ave 39 7 1 1     1     6014246.68754 2106694.7124400004 37.7653833298046 -122.393930504207 (37.7653833298046, -122.393930504207)
26540 70481 2 51 934 Avalon Ave 1 1 1 1 1 08/06/1994 12:00:00 AM 3     6005107.91916 2092023.60961 37.7245877066523 -122.424495766183 (37.7245877066523, -122.424495766183)
26966 70402 2 51 212 Oxford St 1 1 1 1 1 05/21/1994 12:00:00 AM 10     6006462.64225 2092921.27798 37.727128920939606 -122.419876323835 (37.7271289209396, -122.419876323835)
31590 198270 2 51 101 Pennsylvania Ave 9 7 1 1     1     6014327.719219999 2106393.16587 37.764559852075 -122.39362912521099 (37.764559852075, -122.393629125211)
35409 78535 2 51 62 Colby St 2 1 1 1 1 09/16/2000 12:00:00 AM 6     6007981.72204 2093794.7148099998 37.7296126541786 -122.41468665108 (37.7296126541786, -122.41468665108)
37494 70335 2 51 320 Silliman St 1 1 1 1 1 04/30/1994 12:00:00 AM 6     6009780.67381 2094049.10859 37.7304120750579 -122.408485397509 (37.7304120750579, -122.408485397509)
38497 180409 2 51 141 Rousseau St 2 9 1 1     1     6003595.96524 2094719.6833400002 37.7319050215902 -122.429914617678 (37.7319050215902, -122.429914617678)
38853 70336 2 51 324 Silliman St 1 1 1 1 1 04/30/1994 12:00:00 AM 8     6009735.9866 2094035.87413 37.7303732333298 -122.408638954927 (37.7303732333298, -122.408638954927)
43394 78532 2 51 501 Wayland St 1 1 1 1 1 09/30/2000 12:00:00 AM 5     6010074.13409 2092167.4028 37.725261736838604 -122.407338256469 (37.7252617368386, -122.407338256469)
43763 79959 2 51 1719 Quesada Ave 1 1 1 1 1 09/07/2002 12:00:00 AM 5     6014649.309169999 2095031.35513 37.73338057973321 -122.39172235292 (37.7333805797332, -122.39172235292)
45366 70407 2 51 231 Oxford St 1 1 1 1 1 05/21/1994 12:00:00 AM 8     6006535.83698 2092862.23217 37.7269709172726 -122.419619102459 (37.7269709172726, -122.419619102459)
49606 198325 2 51 1225 Mission Bay Blvd South 7 2 1 1     4     6013787.22843 2108637.88784 37.770693312961996 -122.39565583825899 (37.770693312962, -122.395655838259)
50678 80637 2 51 706 Vermont St 1 1 1 1 1 10/05/2002 12:00:00 AM 4     6011239.20103 2105002.70461 37.7605698551303 -122.404213664555 (37.7605698551303, -122.404213664555)
51615 198272 2 51 101 Pennsylvania Ave 30 7 1 1     1     6014300.74273 2106595.72792 37.765114544025295 -122.393736609482 (37.7651145440253, -122.393736609482)
55075 74119 2 51 164 South Park 1 1 1 1 1 07/23/1994 12:00:00 AM 7     6014130.8006 2112451.57445 37.7811839433263 -122.39473452509199 (37.7811839433263, -122.394734525092)
59226 198321 2 51 1225 Mission Bay Blvd South 3 2 1 1     4     6013777.96356 2108496.99922 37.7703059488766 -122.39567801282601 (37.7703059488766, -122.395678012826)
65756 198271 2 51 101 Pennsylvania Ave 17 7 1 1     1     6014323.67834 2106481.09805 37.7648010700346 -122.393649256519 (37.7648010700346, -122.393649256519)
66247 198320 2 51 1225 Mission Bay Blvd South 2 2 1 1     4     6013760.20993 2108475.0165 37.7702446016405 -122.39573788252 (37.7702446016405, -122.39573788252)
67644 70573 2 51 862 42nd Ave 1 1 1 1 1 01/20/1996 12:00:00 AM 11     5982961.78283 2109923.12422 37.772459289826 -122.502374937437 (37.772459289826, -122.502374937437)
71393 198322 2 51 1225 Mission Bay Blvd South 4 2 1 1     4     6013789.7693 2108510.1655 37.7703427572515 -122.39563809912599 (37.7703427572515, -122.395638099126)
75545 198319 2 51 1225 Mission Bay Blvd South 1 2 1 1     4     6013741.4074800005 2108464.54508 37.7702148034894 -122.395802186723 (37.7702148034894, -122.395802186723)
117662 70482 2 51 935 Avalon Ave 1 1 1 1 1 08/06/1994 12:00:00 AM 4     6005101.627719999 2092066.92628 37.724706289440796 -122.424520594648 (37.7247062894408, -122.424520594648)
130711 75004 2 51 101 Laurel St 1 1 1 1 1 02/10/1996 12:00:00 AM 8     5997965.54363 2116098.57851 37.7902856238171 -122.450921084564 (37.7902856238171, -122.450921084564)
133147 78531 2 51 501 Wayland St 2 1 1 1 1 09/30/2000 12:00:00 AM 6     6010098.32429 2092174.05375 37.7252813528324 -122.407255101567 (37.7252813528324, -122.407255101567)
147888 74993 2 51 414 Tehama St 1 1 1 1 1 08/19/1989 12:00:00 AM 1     6011197.75639 2112352.56567 37.780748577930204 -122.404874484592 (37.7807485779302, -122.404874484592)
148832 198324 2 51 1225 Mission Bay Blvd South 6 2 1 1     5     6013797.10576 2108619.17547 37.77064248240121 -122.39562036091101 (37.7706424824012, -122.395620360911)
154542 78505 2 51 432 Burrows St 1 1 1 1 1 09/30/2000 12:00:00 AM 5     6009991.68308 2093152.7262400002 37.7279626131612 -122.407692726044 (37.7279626131612, -122.407692726044)
158639 198326 2 51 1225 Mission Bay Blvd South 8 2 1 1     4     6013771.76611 2108656.94068 37.7707447676885 -122.39571065823601 (37.7707447676885, -122.395710658236)
161848 70149 2 51 754 21st Ave 1 1 1 1 1 05/22/1993 12:00:00 AM 8     5989468.1167 2110177.57013 37.773538072981204 -122.479887770247 (37.7735380729812, -122.479887770247)
162109 70404 2 51 218 Oxford St 1 1 1 1 1 05/21/1994 12:00:00 AM 10     6006477.26442 2092881.04144 37.7270192639056 -122.41982292118601 (37.7270192639056, -122.419822921186)
162876 219443 2 51 550 Mangels Ave 2 9 1 1     3     5997790.17005 2095292.68219 37.733147839699896 -122.45002766386699 (37.7331478396999, -122.450027663867)
167045 219446 2 51 762 Joost Ave 2 9 1 1     8     5997041.47466 2095025.35 37.7323709396524 -122.45259680479201 (37.7323709396524, -122.452596804792)
173502 73886 2 51 164 South Park 2 1 1 1 1 07/23/1994 12:00:00 AM 7     6014128.33524 2112437.75054 37.78114584894679 -122.39474208568701 (37.7811458489468, -122.394742085687)
173800 198327 2 51 1225 Mission Bay Blvd South 9 2 1 1     4     6013747.40215 2108665.50559 37.7707669296806 -122.395795534462 (37.7707669296806, -122.395795534462)
173810 75766 2 51 100 Goettingen St 1 1 1 1 1 04/30/1994 12:00:00 AM 8     6009894.26848 2094011.0737400001 37.730314000377 -122.408090001562 (37.730314000377, -122.408090001562)
175328 198323 2 51 1225 Mission Bay Blvd South 5 2 1 1     4     6013802.38344 2108531.614 37.7704023517081 -122.39559596947201 (37.7704023517081, -122.395595969472)
176376 70562 2 51 164 South Park 3 1 1 1 1 07/23/1994 12:00:00 AM 8     6014127.69322 2112419.53716 37.7810958034577 -122.39474303089199 (37.7810958034577, -122.394743030892)
177436 70333 2 51 143 Goettingen St 1 1 1 1 1 04/30/1994 12:00:00 AM 7     6009984.51803 2093871.67123 37.7299362833339 -122.407768169286 (37.7299362833339, -122.407768169286)
180856 72281 2 51 730 42nd Ave 1 1 1 1 1 01/20/1996 12:00:00 AM 8     5982929.242880001 2110803.7534 37.7748753302021 -122.502552686167 (37.7748753302021, -122.502552686167)
181702 70405 2 51 225 Oxford St 1 1 1 1 1 05/21/1994 12:00:00 AM 8     6006525.54367 2092869.6574799998 37.726990725739 -122.41965521291999 (37.726990725739, -122.41965521292)
181929 74171 2 51 466 Clementina St 1 1 1 1 1 09/09/1995 12:00:00 AM 1     6011049.67315 2111947.37062 37.7796277285636 -122.405358235294 (37.7796277285636, -122.405358235294)
181939 82808 2 51 637 10th Ave 1 1 1 1 1 04/30/2005 12:00:00 AM 4     5992833.07706 2111118.80762 37.776317378073294 -122.468316464164 (37.7763173780733, -122.468316464164)
185243 72258 2 51 230 Paris St 1 1 1 1 1 01/06/1996 12:00:00 AM 11     6002786.80425 2092214.2025900001 37.7249796797621 -122.432533160192 (37.7249796797621, -122.432533160192)
187128 78262 2 51 501 Wayland St 3 1 1 1 1 09/30/2000 12:00:00 AM 6     6010118.26182 2092179.1105400003 37.725296353538795 -122.40718653543699 (37.7252963535388, -122.407186535437)
13358 79034 2 51 10 Moss St 1 1 1 1   02/09/2002 12:00:00 AM 1 2.5x4   6010138.62156 2111398.24518 37.7780689795412 -122.40847122506399 (37.7780689795412, -122.408471225064)
2218 114579 2 51 1501 Beach St 1 1 1 1   12/29/2015 12:00:00 AM 3 3x3   6002950.36974 2121305.2817599997 37.8048659859314 -122.43404631360701 (37.8048659859314, -122.434046313607)
4081 102392 2 51 30X Harriet St 4 1 1 1     2 3x3   6010436.41014 2111752.09711 37.7790572463352 -122.40746601596202 (37.7790572463352, -122.407466015962)
4422 253158 2 51 700 Avalon Ave 1 1 1 1   10/11/2017 07:47:00 AM 3 3x3   6004446.0 2092174.0 37.7249632430066 -122.426794641082 (37.7249632430066, -122.426794641082)
6520 121576 2 51 3553-3555 Sacramento St 1 1 1 1     2 3x3   5997856.717119999 2115116.32362 37.787582382260396 -122.451226746117 (37.7875823822604, -122.451226746117)
6649 114581 2 51 1501 Beach St 2 1 1 1   12/29/2015 12:00:00 AM 3 3x3   6002967.5258 2121305.9196 37.8048687108976 -122.433986988903 (37.8048687108976, -122.433986988903)
6827 100292 2 51 3701 Buchanan St 1 1 1 1     6 3x3   6003061.81659 2121064.97367 37.804212487284005 -122.43364345509701 (37.804212487284, -122.433643455097)
9705 110500 2 51 900X JESSIE ST 2 1 1 1     2 3x3   6007667.0 2110717.0 37.7760597176113 -122.416973193872 (37.7760597176113, -122.416973193872)
9708 110501 2 51 900X JESSIE ST 3 1 1 1     2 3x3   6007667.0 2110717.0 37.7760597176113 -122.416973193872 (37.7760597176113, -122.416973193872)
13559 106005 2 51 59 Reddy St 1 1 1 1 1   3 3x3   6013632.51665 2093922.487 37.7302793593954 -122.395160068985 (37.7302793593954, -122.395160068985)
13583 100891 2 51 91 Welsh St 10 1 1 1     6 3x3   6013606.47382 2111993.91964 37.7798981618967 -122.396516359044 (37.7798981618967, -122.396516359044)
14003 100882 2 51 91 Welsh St 1 1 1 1     6 3x3   6013366.225459999 2111763.75465 37.7792528084154 -122.397331345366 (37.7792528084154, -122.397331345366)
14258 100759 2 51 362 Brannan St 2 1 1 1     9 3x3   6014440.04423 2112282.11717 37.780735840838396 -122.39365282322201 (37.7807358408384, -122.393652823222)
14587 100888 2 51 91 Welsh St 7 1 1 1     6 3x3   6013550.27415 2111938.66795 37.7797433256341 -122.396706905611 (37.7797433256341, -122.396706905611)
15099 99592 2 51 1855X Evans Ave 5 1 1 1     10 3x3   6014373.22453 2099430.50237 37.7454443986533 -122.392984546922 (37.7454443986533, -122.392984546922)
15205 102387 2 51 84 Harriet St 1 1 1 1     3 3x3   6010709.4483199995 2111466.67522 37.778288823307 -122.406501343779 (37.778288823307, -122.406501343779)
15396 100890 2 51 91 Welsh St 9 1 1 1     6 3x3   6013579.59012 2111966.26913 37.779820743762606 -122.39660742352 (37.7798207437626, -122.39660742352)
15592 102388 2 51 90X Harriet St 1 1 1 1     3 3x3   6010739.31321 2111434.0362400003 37.778200875001104 -122.406395729189 (37.7782008750011, -122.406395729189)
15713 100889 2 51 91 Welsh St 8 1 1 1     6 3x3   6013566.0867800005 2111954.86803 37.7797886874229 -122.396653338395 (37.7797886874229, -122.396653338395)
15863 100892 2 51 91 Welsh St 11 1 1 1     6 3x3   6013627.65977 2112013.31498 37.7799525960738 -122.396444426786 (37.7799525960738, -122.396444426786)
16098 100884 2 51 91 Welsh St 3 1 1 1     6 3x3   6013403.42787 2111798.46493 37.7793501860944 -122.397205080544 (37.7793501860944, -122.397205080544)
26251 116376 2 51 50x Madera St 2 1 1 1     4 3x3   6012832.143680001 2103274.0879599997 37.7559123328161 -122.39858306046801 (37.7559123328161, -122.398583060468)
32694 104489 2 51 101X Arkansas St 2 1 1 1     1 3x3   6012893.40207 2106545.4722700003 37.7648982471715 -122.398600762736 (37.7648982471715, -122.398600762736)
56163 116375 2 51 50x Madera St 1 1 1 1     5 3x3   6012868.23872 2103276.4049 37.7559207054891 -122.39845839373301 (37.7559207054891, -122.398458393733)
79513 95519 2 51 600X 32nd Ave 1 1 1 4     5 3x3   5985993.74648 2111883.3180400003 37.7780191077803 -122.49203157445 (37.7780191077803, -122.49203157445)
80644 106769 2 51 2600X 24th St 1 1 1 1       3x3   6010715.11393 2102268.82005 37.753033918516 -122.405833670893 (37.753033918516, -122.405833670893)
80755 115918 2 51 3100X Anza St 2 1 1 1     12 3x3   5989005.40184 2111951.8122900003 37.7783827554231 -122.481618324321 (37.7783827554231, -122.481618324321)
81646 120536 2 51 437 Duncan St 1 1 1 1     3 3x3   6003669.0 2099775.0 37.7457899005416 -122.430022609753 (37.7457899005416, -122.430022609753)
84938 102708 2 51 999X PHELPS ST 1 1 1 1   03/07/2015 12:00:00 AM 3 3x3 Permit Number 773962 6014744.0 2097272.0 37.7395381878784 -122.39155157401501 (37.7395381878784, -122.391551574015)
86458 95224 2 51 299 on 16th St Dolores St 6 1 1 1     3 3x3   6004880.0 2106610.0 37.764625720621794 -122.426321695151 (37.7646257206218, -122.426321695151)
91382 95488 2 51 600X 32nd Ave 10 1 1 4     6 3x3   5986007.7101 2111508.12486 37.776989750535 -122.491955639862 (37.776989750535, -122.491955639862)
93377 95497 2 51 600X 32nd Ave 1 1 1 4     6 3x3   5985999.2312900005 2111660.71954 37.777408236422296 -122.491996207782 (37.7774082364223, -122.491996207782)
94030 95491 2 51 600X 32nd Ave 7 1 1 4     3 3x3   5986009.30138 2111441.61533 37.776807227327396 -122.491945237383 (37.7768072273274, -122.491945237383)
94146 110101 2 51 1348 Douglass St   1 1 1   01/19/2016 12:00:00 AM   3x3 Permit Number 774671 6001379.0 2099692.0 37.7454320431231 -122.437935141467 (37.7454320431231, -122.437935141467)
95213 113810 2 51 4101x 25TH ST 3 1 1 10 6     3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
95576 100214 2 51 730 Broderick St 1 1 1 1     3 3x3   6001088.1 2111178.5 37.77695461161171 -122.439764396806 (37.7769546116117, -122.439764396806)
96578 95515 2 51 600X 32nd Ave 5 1 1 4     6 3x3   5985992.57608 2111969.58011 37.7782558903759 -122.492041976045 (37.7782558903759, -122.492041976045)
96802 95494 2 51 600X 32nd Ave 4 1 1 4     3 3x3   5986000.13497 2111717.2940599998 37.7775636267397 -122.491997248036 (37.7775636267397, -122.491997248036)
101527 95518 2 51 600X 32nd Ave 2 1 1 4     5 3x3   5985992.056890001 2111902.81718 37.778072548088495 -122.49203885528601 (37.7780725480885, -122.492038855286)
106701 113812 2 51 4101x 25TH ST 5 1 1 10 6   1 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
107004 95516 2 51 600X 32nd Ave 4 1 1 4     5 3x3   5985994.45155 2111944.6872400003 37.778187651292896 -122.492033654948 (37.7781876512929, -122.492033654948)
108571 95509 2 51 600X 32nd Ave 11 1 1 4   02/19/2015 02:37:00 PM 3 3x3   5985988.58257 2112092.73248 37.7785937981587 -122.492064860632 (37.7785937981587, -122.492064860632)
110307 117181 2 51 8 KNOTT CT 2 1 1 1       3x3   6000120.0 2086463.0 37.7090365866676 -122.44133950250601 (37.7090365866676, -122.441339502506)
111692 95487 2 51 600X 32nd Ave 11 1 1 4     3 3x3   5986008.46306 2111529.3689900003 37.777048124873296 -122.49195459962401 (37.7770481248733, -122.491954599624)
112142 95511 2 51 600X 32nd Ave 9 1 1 4   02/19/2015 02:32:00 PM 3 3x3   5985988.37339 2112068.78219 37.7785280252799 -122.492063820389 (37.7785280252799, -122.492063820389)
114153 102709 2 51 999X PHELPS ST 2 1 1 1   03/07/2015 12:00:00 AM 3 3x3 Permit Number 773962 6014744.0 2097272.0 37.7395381878784 -122.39155157401501 (37.7395381878784, -122.391551574015)
117433 115917 2 51 3100X Anza St 1 1 1 1     12 3x3   5989023.45884 2111952.8782599997 37.7783867322409 -122.481555937234 (37.7783867322409, -122.481555937234)
117880 95486 2 51 600X 32nd Ave 12 1 1 4     3 3x3   5986007.39345 2111549.75354 37.777104032517705 -122.49195980083701 (37.7771040325177, -122.491959800837)
118573 120668 2 51 1154 Clayton St 1 1 1 1     8 3x3   5998951.0 2105925.0 37.76240795737721 -122.44677915122601 (37.7624079573772, -122.446779151226)
120188 95514 2 51 600X 32nd Ave 6 1 1 4   02/19/2015 02:29:00 PM 3 3x3   5985991.7561 2111987.56369 37.7783052202186 -122.492046137036 (37.7783052202186, -122.492046137036)
123561 95485 2 51 600X 32nd Ave 13 1 1 4     10 3x3   5986006.6183 2111569.83262 37.777159118639496 -122.49196396094601 (37.7771591186395, -122.491963960946)
124692 95484 2 51 600X 32nd Ave 15 1 1 4     6 3x3   5986002.98697 2111639.37953 37.777349862368496 -122.491981644298 (37.7773498623685, -122.491981644298)
126039 108924 2 51 335-341 Oak St 2 1 1 1     1 3x3   6005380.1 2110235.1 37.7746076306443 -122.42484990347602 (37.7746076306443, -122.424849903476)
139550 95513 2 51 600X 32nd Ave 7 1 1 4     6 3x3   5985988.88946 2112008.2856099997 37.7783619491242 -122.49205757976002 (37.7783619491242, -122.49205757976)
140987 95489 2 51 600X 32nd Ave 9 1 1 4     6 3x3   5986007.8525 2111486.5622099997 37.7769305539658 -122.49195355936199 (37.7769305539658, -122.491953559362)
141798 95490 2 51 600X 32nd Ave 8 1 1 4     3 3x3   5986007.65609 2111463.21002 37.7768664240251 -122.49195251911199 (37.7768664240251, -122.491952519112)
142332 95517 2 51 600X 32nd Ave 3 1 1 4     10 3x3   5985993.99278 2111923.13747 37.778128454962 -122.49203365493601 (37.778128454962, -122.492033654936)
Powered by Datasette · Query took 90.713ms · Data source: data.sfgov.org