sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
97889 104310 5 329 3747 23RD ST 3 1 1 1     13 5x5   6004798.0 2102451.0 37.7532014528284 -122.426309178314 (37.7532014528284, -122.426309178314)
15764 80467 5 294 1780 Bancroft Ave 1 1 1 1   09/07/2002 12:00:00 AM 10     6013451.73876 2092852.71308 37.727331923129896 -122.395710120444 (37.7273319231299, -122.395710120444)
88690 80520 5 291 2499X Mendell St 1 1 1 1   09/07/2002 12:00:00 AM 2     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
94178 22382 5 291 2499X Mendell St 2 1 1 1   05/13/1997 12:00:00 AM 3 3X3   6014045.0718623 2092725.5085003 37.7270156330804 -122.393650054041 (37.7270156330804, -122.393650054041)
94668 80514 5 291 1769X Armstrong Ave 9 1 1 1   09/07/2002 12:00:00 AM 4     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
97551 80517 5 291 1769X Armstrong Ave 5 1 1 1   09/07/2002 12:00:00 AM 3     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
114609 80518 5 291 1769X Armstrong Ave 4 1 1 1   09/07/2002 12:00:00 AM 5     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
114700 80515 5 291 1769X Armstrong Ave 8 1 1 1   09/07/2002 12:00:00 AM 4     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
119627 80516 5 291 1769X Armstrong Ave 7 1 1 1   09/07/2002 12:00:00 AM 4     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
127060 22386 5 291 1769X Armstrong Ave 6 1 1 1     3 3X3   6014045.0718623 2092725.5085003 37.7270156330804 -122.393650054041 (37.7270156330804, -122.393650054041)
99668 104881 5 262 101 Gonzalez Dr 1 2 1 1         missing? 5990474.7 2090014.4 37.718233681711204 -122.47493379652201 (37.7182336817112, -122.474933796522)
84402 109353 5 253 2505 Pacific Ave 6 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
104832 109350 5 253 2505 Pacific Ave 3 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
113379 109349 5 253 2505 Pacific Ave 2 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
122284 109352 5 253 2505 Pacific Ave 5 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
125736 109351 5 253 2505 Pacific Ave 4 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
139898 109348 5 253 2505 Pacific Ave 1 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
5058 3648 5 233 100X Cargo Way 84 1 1 9   05/31/1996 12:00:00 AM 3 3X3   6017409.48154 2098690.6025 37.7435809736936 -122.382434078367 (37.7435809736936, -122.382434078367)
22310 3634 5 233 100X Cargo Way 70 1 1 9     6 3X3   6017632.60306 2098495.95511 37.743058833606604 -122.38164903679899 (37.7430588336066, -122.381649036799)
22333 3610 5 233 100X Cargo Way 46 1 1 9     6 3X3   6018056.230380001 2098180.90993 37.742217164400294 -122.380162344118 (37.7422171644003, -122.380162344118)
22347 3647 5 233 100X Cargo Way 83 1 1 9   05/31/1996 12:00:00 AM 3 3X3   6017425.17191 2098677.66921 37.7435463281955 -122.38237892474599 (37.7435463281955, -122.382378924746)
22349 3626 5 233 100X Cargo Way 62 1 1 9     12 3X3   6017765.800369999 2098395.89545 37.7427914435713 -122.38118151611201 (37.7427914435713, -122.381181516112)
4983 83050 5 232 100X Cargo Way 2 1 1 9   02/04/2006 12:00:00 AM 1     6018877.26977 2097567.07885 37.7405769700435 -122.377280830842 (37.7405769700435, -122.377280830842)
97877 121418 5 226 521 Lakeview Ave 1 5 2 1       3x3   5996348.0 2089857.0 37.718140121256106 -122.45462104638399 (37.7181401212561, -122.454621046384)
102645 110587 5 225 151 EDGEWOOD AVE 1 7 1 1           5996558.0 2106132.0 37.7628393335165 -122.45507056334999 (37.7628393335165, -122.45507056335)
3835 253567 5 218 25 Raycliff Ter 1 13 1 1           6000333.0 2116919.0 37.792673532262505 -122.44278881704399 (37.7926735322625, -122.442788817044)
19281 114961 5 207 220 Evelyn Way 1 1 1 1   12/28/2015 12:00:00 AM     Permit Number 776128 5997838.7 2098850.9 37.7429206264442 -122.45011626136801 (37.7429206264442, -122.450116261368)
90903 80593 5 204 1780 Bancroft Ave 5 1 1 1   09/07/2002 12:00:00 AM 7     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
113265 80510 5 204 1740 Bancroft Ave 5 1 1 1   08/20/2007 12:00:00 AM 9   Permit Number 49651 6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
118440 80512 5 204 1740 Bancroft Ave 3 1 1 1   09/07/2002 12:00:00 AM 9     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
119892 22381 5 204 1780 Bancroft Ave 4 1 1 1     10 3X3   6014045.0718623 2092725.5085003 37.7270156330804 -122.393650054041 (37.7270156330804, -122.393650054041)
124928 104968 5 164 495 COLLINGWOOD ST 1 7 1 1     15   Permit Number 770776 6002186.6 2103026.0 37.7546323087418 -122.435381040855 (37.7546323087418, -122.435381040855)
16217 22383 5 147 1799X Armstrong Ave 2 1 1 1   05/13/1997 12:00:00 AM 2 4x15   6013476.602999999 2093118.78047 37.7280638732384 -122.39564279807301 (37.7280638732384, -122.395642798073)
93853 109126 5 138 890x CASTRO ST 2 1 1 1     4 3x3   6002411.0 2103002.0 37.754579151967796 -122.434603290485 (37.7545791519678, -122.434603290485)
141344 109125 5 138 890x CASTRO ST 1 1 1 1     12 3x3   6002411.0 2103002.0 37.754579151967796 -122.434603290485 (37.7545791519678, -122.434603290485)
82462 114642 5 135 30 MacEdonia St 1 1 1 1   11/30/2015 12:00:00 AM     Permit Number 773527 6010319.9 2099707.2 37.745978163196995 -122.407019863158 (37.745978163197, -122.407019863158)
127330 109501 5 119 1400X on Filbert Montgomery St 1 14 1 1         see 279 Filbert St. Same tree; shared responsibility 6011485.9 2120124.8 37.802105381717894 -122.404424889694 (37.8021053817179, -122.404424889694)
145175 108885 5 118 707 NOE ST 5 13 1 1       3x3   6003152.4 2104071.5 37.757557804850705 -122.43211570496099 (37.7575578048507, -122.432115704961)
85994 104510 5 116 254 ALLISON ST 1 13 1 1     40     6000052.0 2087408.0 37.7116274717654 -122.441642291463 (37.7116274717654, -122.441642291463)
109976 117353 5 108 101X China Basin St 2 1 1 1       3x3 Permit Number 772935 6015309.46376 2108739.72137 37.771057483634294 -122.39039747437401 (37.7710574836343, -122.390397474374)
130745 82138 5 108 360 09th Ave 1 1 1 1 1 11/13/2004 12:00:00 AM 12     5993114.289030001 2113170.0137400003 37.781965672785795 -122.467492879752 (37.7819656727858, -122.467492879752)
123259 73314 5 104 1142 Alabama St 1 1 1 1   12/09/2014 12:00:00 AM 3 3x3   6009184.98526399 2102501.75487234 37.7535878144828 -122.411141625253 (37.7535878144828, -122.411141625253)
966 251417 5 103 418 19th Ave 1 1 1 6       3x3   5990003.0 2112517.0 37.779992561868504 -122.478208632121 (37.7799925618685, -122.478208632121)
106936 105441 5 103 425 WAWONA ST   19 1 1           5991587.6 2097036.5 37.737579050883106 -122.471598439568 (37.7375790508831, -122.471598439568)
141824 121089 5 103 1X Grand View Ave 2 1 1 1       3x3   6000227.0 2103854.0 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848)
119638 109607 5 98 775 Congo St 1 7 2 1           6000381.8 2095947.7 37.7350943222142 -122.44111470541901 (37.7350943222142, -122.441114705419)
5000 83036 5 97 100X Cargo Way 16 1 1 9   03/18/2017 02:55:00 PM 3     6018559.56213 2097806.04485 37.7412156164156 -122.378395939846 (37.7412156164156, -122.378395939846)
22318 3611 5 97 100X Cargo Way 47 1 1 9   05/31/1996 12:00:00 AM 3 3X3   6018038.2961099995 2098194.83807 37.7422544187983 -122.380225323637 (37.7422544187983, -122.380225323637)
22344 3639 5 97 100X Cargo Way 75 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6017551.66161 2098562.89956 37.743238180001995 -122.381933568796 (37.743238180002, -122.381933568796)
23256 3593 5 97 100X Cargo Way 29 1 1 9   04/06/2016 12:00:00 AM 7 3X3   6018341.35218 2097966.95491 37.7416454132021 -122.379161613636 (37.7416454132021, -122.379161613636)
145512 72375 5 90 4299X Fulton St 1 1 1 1 1 03/09/1996 12:00:00 AM   3x3 Permit Number 773790 5990099.63678033 2109979.56687008 37.773031079694 -122.47768879633699 (37.773031079694, -122.477688796337)
88121 71505 5 88 328 San Carlos St 1 1 1 1   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774557 6006691.32680411 2104197.11487977 37.758102721165706 -122.41988555479601 (37.7581027211657, -122.419885554796)
90136 108459 5 88 771 11th Ave   1 1 1 1     3x3 Permit Number 773786 5992558.08669 2110211.94426 37.7738114893979 -122.469201704334 (37.7738114893979, -122.469201704334)
103533 12529 5 88 105 Lake St 1 8 1 1 1 07/12/2004 12:00:00 AM 6 3x3 Permit Number 773769 5995136.95364 2114887.49287 37.78679797610221 -122.460619935074 (37.7867979761022, -122.460619935074)
142320 82180 5 88 105 Lake St 1 8 1 1 1     3x3 Permit Number 773769 5995179.68463591 2114884.08050195 37.78679106496129 -122.46047184952101 (37.7867910649613, -122.460471849521)
3419 252969 5 82 101 Whipple Ave 1 1 1 1           5998180.94106 2087280.50358 37.711170613109104 -122.448099970249 (37.7111706131091, -122.448099970249)
4012 252965 5 82 115X Whipple Ave 1 1 1 1   10/05/2017 02:04:00 PM 3              
4061 252970 5 82 101X Whipple Ave 2 2 1 1   10/05/2017 12:21:00 PM 3              
4066 252966 5 82 111 Whipple Ave 1 1 1 1   10/05/2017 12:19:00 PM 3     5998135.7809 2087327.97675 37.7112983819328 -122.448259470506 (37.7112983819328, -122.448259470506)
4074 252967 5 82 109 Whipple Ave 1 1 1 1   10/05/2017 01:55:00 PM 3     5998144.81293 2087318.48212 37.7112728281964 -122.448227570418 (37.7112728281964, -122.448227570418)
1517 99716 5 81 1415 Scott St 4 1 1 1     12 3x3   6001693.2243 2113487.1552 37.7833280195253 -122.43783648412202 (37.7833280195253, -122.437836484122)
43784 83046 5 80 100X Cargo Way 6 1 1 9   02/04/2006 12:00:00 AM 1     6018811.25128 2097616.11187 37.740707968002 -122.37751250161399 (37.740707968002, -122.377512501614)
106272 115004 5 80 1050 MCALLISTER ST 1 8 1 21 4 01/19/2016 09:19:00 AM 3 3x3   6004148.0 2111858.0 37.778994045300706 -122.42922772691401 (37.7789940453007, -122.429227726914)
1079 3621 5 78 100X Cargo Way 57 1 1 9   05/01/2017 03:22:00 PM 3 3X3   6017849.66978 2098333.64293 37.7426251400454 -122.380887189608 (37.7426251400454, -122.380887189608)
4945 3600 5 78 100X Cargo Way 36 1 1 9   05/01/2017 03:14:00 PM 3 3X3   6018222.967130001 2098056.59418 37.7418850159701 -122.379577179554 (37.7418850159701, -122.379577179554)
4950 3646 5 78 100X Cargo Way 82 1 1 9   04/10/2017 10:16:00 AM 3 3X3   6017441.11571 2098662.50366 37.7435055673357 -122.38232273959999 (37.7435055673357, -122.3823227396)
4973 3631 5 78 100X Cargo Way 67 1 1 9   05/01/2017 03:27:00 PM 3 3X3   6017682.09522 2098458.88711 37.7429597849556 -122.381475327351 (37.7429597849556, -122.381475327351)
4980 83034 5 78 100X Cargo Way 18 1 1 9   03/18/2017 02:59:00 PM 3     6018525.50747 2097831.43609 37.7412834585567 -122.37851545254298 (37.7412834585567, -122.378515452543)
4994 3624 5 78 100X Cargo Way 60 1 1 9   05/01/2017 03:25:00 PM 3 3X3   6017797.96297 2098371.7943700003 37.742727042232396 -122.38106863050601 (37.7427270422324, -122.381068630506)
5023 3601 5 78 100X Cargo Way 37 1 1 9   04/10/2017 10:11:00 AM 3 3X3   6018206.00756 2098069.0742900004 37.7419183484432 -122.379636687689 (37.7419183484432, -122.379636687689)
5038 83035 5 78 100X Cargo Way 17 1 1 9   04/10/2017 09:50:00 AM 3     6018541.89406 2097818.9676900003 37.741250126083706 -122.37845792741501 (37.7412501260837, -122.378457927415)
5049 3594 5 78 100X Cargo Way 30 1 1 9     12 3x3   6018322.1359 2097981.33701 37.741683843926396 -122.379229056502 (37.7416838439264, -122.379229056502)
5054 83037 5 78 100X Cargo Way 15 1 1 9   02/04/2006 12:00:00 AM 5     6018575.81097 2097793.86484 37.74118306815279 -122.378338911137 (37.7411830681528, -122.378338911137)
5063 3598 5 78 100X Cargo Way 34 1 1 9   05/01/2017 03:10:00 PM 3 3X3   6018255.028469999 2098031.9569200003 37.7418191352571 -122.37946460960501 (37.7418191352571, -122.379464609605)
5070 3618 5 78 100X Cargo Way 54 1 1 9     12 3X3   6017899.85524 2098296.735 37.7425265680461 -122.380711096061 (37.7425265680461, -122.380711096061)
22311 3643 5 78 100X Cargo Way 79 1 1 9     6 3X3   6017487.6627 2098619.8542 37.7433910314633 -122.382158823763 (37.7433910314633, -122.382158823763)
22315 3636 5 78 100X Cargo Way 72 1 1 9     12 3X3   6017599.14752 2098522.45762 37.7431297568333 -122.38176656108601 (37.7431297568333, -122.381766561086)
22328 3612 5 78 100X Cargo Way 48 1 1 9     6 3X3   6018020.628269999 2098207.76094 37.7422889275932 -122.380287312129 (37.7422889275932, -122.380287312129)
22335 3628 5 78 100X Cargo Way 64 1 1 9     6 3X3   6017730.69941 2098422.13413 37.7428615520079 -122.38130471064899 (37.7428615520079, -122.381304710649)
22337 3609 5 78 100X Cargo Way 45 1 1 9     9 3X3   6018070.77279 2098169.47823 37.7421865775631 -122.380111266222 (37.7421865775631, -122.380111266222)
22338 3608 5 78 100X Cargo Way 44 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6018087.01832 2098157.15518 37.7421536371939 -122.380054237523 (37.7421536371939, -122.380054237523)
22339 3642 5 78 100X Cargo Way 78 1 1 9     6 3X3   6017503.4842 2098606.02713 37.7433539389383 -122.382103154832 (37.7433539389383, -122.382103154832)
22340 3632 5 78 100X Cargo Way 68 1 1 9     6 3X3   6017663.5913 2098472.7680200003 37.7429968775117 -122.38154027458799 (37.7429968775117, -122.381540274588)
22352 3605 5 78 100X Cargo Way 41 1 1 9     6 3X3   6018137.75637 2098119.86028 37.7420540318827 -122.37987620861601 (37.7420540318827, -122.379876208616)
4998 83042 5 77 100X Cargo Way 10 1 1 9   03/18/2017 02:54:00 PM 3     6018742.83505 2097668.8048 37.740848882771 -122.37775271773 (37.740848882771, -122.37775271773)
5059 83040 5 76 100X Cargo Way 12 1 1 9   02/04/2006 12:00:00 AM 6     6018704.22704 2097697.64106 37.740925933998 -122.37788821227699 (37.740925933998, -122.377888212277)
98596 115128 5 68 499X MAIN ST 6 1 1 1     7     6015842.0 2114626.0 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338)
104521 115129 5 68 499X MAIN ST 7 1 1 1     6     6015842.0 2114626.0 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338)
240 251249 5 64 161 Lundys Ln 1 7 2 1       3x3   6006716.0 2098685.0 37.7429691002686 -122.41940918518 (37.7429691002686, -122.41940918518)
79103 120636 5 64 385 Nevada St 1 5 2 1       3x3   6008960.0 2096519.0 37.7371478708762 -122.411497024701 (37.7371478708762, -122.411497024701)
79432 106576 5 64 507 STEINER ST 1 7 2 1           6003113.3 2110111.6 37.7741402349502 -122.432682383122 (37.7741402349502, -122.432682383122)
103907 106639 5 64 1321X CLAYTON ST 1 13 2 1           5998910.0 2105100.0 37.7601403710114 -122.44686158716699 (37.7601403710114, -122.446861587167)
110838 107348 5 64 260 LANSDALE AVE 1 13 2 1           5995019.0 2096651.7 37.7367204092857 -122.459706678853 (37.7367204092857, -122.459706678853)
120169 104564 5 64 18 FLOOD AVE 1 7 2 1           6000327.0 2094154.0 37.730166118083794 -122.44117551704201 (37.7301661180838, -122.441175517042)
123904 106641 5 64 1323X CLAYTON ST 1 13 2 1           5999055.0 2105304.0 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866)
138621 104565 5 64 18 FLOOD AVE 1 7 2 1           6000327.0 2094154.0 37.730166118083794 -122.44117551704201 (37.7301661180838, -122.441175517042)
57485 73751 5 61 794-798 19th Ave 2 1 1 1 1 03/09/1996 12:00:00 AM 10 3x3   5990095.37972 2109981.17843 37.7730352575459 -122.477703639701 (37.7730352575459, -122.477703639701)
185734 73761 5 61 794-798 19th Ave 1 1 1 1 1 03/09/1996 12:00:00 AM 7 3x3   5990097.66816 2109968.1044799997 37.772999492868706 -122.47769476794599 (37.7729994928687, -122.477694767946)
116115 104650 5 60 346 LAKE ST   1 1 1     28 10x8   5994385.6 2114927.2 37.7868637456835 -122.46322230514099 (37.7868637456835, -122.463222305141)
119359 108314 5 60 2501X DIAMOND ST 4 1 1 1       3x3   6002141.0 2097265.0 37.7388113707969 -122.435126715418 (37.7388113707969, -122.435126715418)
120714 104436 5 60 2 SAN FERNANDO WAY 1 7 1 1     13     5992040.0 2096369.0 37.7357724272627 -122.469985704629 (37.7357724272627, -122.469985704629)
Powered by Datasette · Query took 2.844ms · Data source: data.sfgov.org