sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5014 3588 5 11 100X Cargo Way 24 1 1 9   04/10/2017 10:07:00 AM 3 3X3   6018423.14615 2097904.9005 37.7414795341434 -122.37887448618 (37.7414795341434, -122.37887448618)
5065 3592 5 11 100X Cargo Way 28 1 1 9   05/31/1996 12:00:00 AM 3 3X3   6018357.04475 2097955.64275 37.741615217581796 -122.379106567936 (37.7416152175818, -122.379106567936)
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)
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)
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)
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)
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)
22313 3602 5 2 100X Cargo Way 38 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6018187.24152 2098084.4470599997 37.7419595239099 -122.379702643058 (37.7419595239099, -122.379702643058)
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)
22330 3607 5 11 100X Cargo Way 43 1 1 9     6 3x3   6018106.23722 2098142.91565 37.742115598557895 -122.37998679465001 (37.7421155985579, -122.37998679465)
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)
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)
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)
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)
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)
5066 3614 5 11 100X Cargo Way 50 1 1 9     12 3X3   6017985.84349 2098232.4529 37.742354807434396 -122.380409304248 (37.7423548074344, -122.380409304248)
1081 3617 5 2 100X Cargo Way 53 1 1 9   05/01/2017 03:16:00 PM 3 3X3   6017937.25359 2098269.56212 37.742454020638796 -122.380579893948 (37.7424540206388, -122.380579893948)
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)
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)
22346 3622 5 11 100X Cargo Way 58 1 1 9     6 3X3   6017832.2114699995 2098347.65106 37.7426626399605 -122.380948529647 (37.7426626399605, -122.380948529647)
22348 3623 5 2 100X Cargo Way 59 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6017813.51979 2098359.7555299997 37.7426948446985 -122.38101400211 (37.7426948446985, -122.38101400211)
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)
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)
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)
22341 3629 5 2 100X Cargo Way 65 1 1 9     6 3X3   6017712.663240001 2098437.04484 37.7429014981049 -122.38136811194201 (37.7429014981049, -122.381368111942)
22321 3630 5 50 100X Cargo Way 66 1 1 9     12 3X3   6017698.24794 2098446.68655 37.7429271764597 -122.381418626885 (37.7429271764597, -122.381418626885)
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)
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)
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)
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)
22327 3638 5 11 100X Cargo Way 74 1 1 9     6 3X3   6017567.18226 2098548.9302 37.7432006800566 -122.381878930467 (37.7432006800566, -122.381878930467)
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)
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)
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)
22350 3645 5 11 100X Cargo Way 81 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6017457.23238 2098648.52258 37.7434680683118 -122.38226603915399 (37.7434680683118, -122.382266039154)
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)
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)
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)
139890 9241 5 2 6442 Geary Blvd 1 1 1 1   10/01/1993 12:00:00 AM 6 3x3   5986987.758640001 2112604.7127900003 37.7800579063209 -122.488646014596 (37.7800579063209, -122.488646014596)
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)
113580 16882 5 37 300X Oak St 3 1 1 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
83519 16883 5 37 300X Oak St 4 1 1 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
85178 16884 5 37 300X Oak St 5 1 1 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
142156 16885 5 37 300X Oak St 6 1 1 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
116204 16886 5 37 300X Oak St 7 1 1 1   11/10/2016 12:00:00 AM 3 3X4   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
85166 16887 5 37 300X Oak St 8 1 1 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
78271 16888 5 37 300X Oak St 9 1 1 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
109961 22155 5 58 1570X FAIRFAX AVE 7 1 1 1     1 3X3   6015579.0 2098247.0 37.74226164995721 -122.388732527256 (37.7422616499572, -122.388732527256)
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)
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)
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)
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)
105247 25212 5 11 215X Fell St 3 1 1 1     6 3X3   6006420.227630001 2110742.05634 37.7760583047566 -122.421287897592 (37.7760583047566, -122.421287897592)
4630 25362 5 11 974 Geneva Ave 1 1 1 1   10/18/2017 12:00:00 AM 3 3X3 Permit Number 780532 6000558.35356 2088917.09573 37.7157999479938 -122.440000340863 (37.7157999479938, -122.440000340863)
78203 26198 5 11 3830 03rd St 3 1 1 1     1 3x4   6015747.5106037995 2098323.3315623 37.742480578689 -122.388155190044 (37.742480578689, -122.388155190044)
122211 36938 5 12 351 11th Ave 1 1 1 1   02/06/2015 12:00:00 AM 3 3x3 Permit Number 774744 5992449.52236815 2113091.8234389997 37.781712581861 -122.46978695177602 (37.781712581861, -122.469786951776)
103609 39626 5 15 1550 Shrader St 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.45031878213301 (37.7607233191374, -122.450318782133)
92292 39627 5 15 199X Carmel St 1 1 1 1 1 12/29/1998 12:00:00 AM 6   Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.45031878213301 (37.7607233191374, -122.450318782133)
122002 39628 5 15 199X Carmel St 2 1 1 1 1 12/29/1998 12:00:00 AM 5   Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.45031878213301 (37.7607233191374, -122.450318782133)
104147 39629 5 15 199X Carmel St 3 1 1 1 1 12/29/1998 12:00:00 AM 6   Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.45031878213301 (37.7607233191374, -122.450318782133)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
23209 83033 5 41 100X Cargo Way 3 1 1 9   02/04/2006 12:00:00 AM 1     6018894.74802 2097554.01331 37.7405420574702 -122.377219490814 (37.7405420574702, -122.377219490814)
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)
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)
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)
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)
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)
4985 83041 5 11 100X Cargo Way 11 1 1 9   04/10/2017 09:47:00 AM 3     6018722.37051 2097684.4746 37.74089078129229 -122.377824564564 (37.7408907812923, -122.377824564564)
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)
4949 83043 5 41 100X Cargo Way 9 1 1 9   03/18/2017 02:49:00 PM 3     6018760.2720099995 2097656.0724299997 37.7408148829885 -122.377691543139 (37.7408148829885, -122.377691543139)
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)
4989 83048 5 11 100X Cargo Way 4 1 1 9   04/10/2017 09:41:00 AM 3     6018843.8838 2097592.61577 37.7406452501696 -122.37739803950001 (37.7406452501696, -122.3773980395)
134600 83049 5 2 100X Cargo Way 5 1 1 9   02/04/2006 12:00:00 AM 11     6018864.1607099995 2097578.2563400003 37.7406069390666 -122.377326932804 (37.7406069390666, -122.377326932804)
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)
117366 85739 5 15 601X Howard St 1 1 1 1   04/30/2007 12:00:00 AM 3 5x5 Permit Number 770115 6013161.811798001 2114488.497614 37.78672294116279 -122.398229721423 (37.7867229411628, -122.398229721423)
142254 85740 5 15 601X Howard St 2 1 1 1   04/30/2007 12:00:00 AM 3 5x5 Permit Number 770115 6013161.811798001 2114488.497614 37.78672294116279 -122.398229721423 (37.7867229411628, -122.398229721423)
102017 85741 5 15 601X Howard St 3 1 1 1   04/30/2007 12:00:00 AM 3 5x5 Permit Number 770115 6013161.811798001 2114488.497614 37.78672294116279 -122.398229721423 (37.7867229411628, -122.398229721423)
102 98037 5 26 1384X Grove St 1 1 1 1   03/23/2017 12:00:00 AM 3   Permit Number 767782 6001197.2582 2110764.9293 37.775825263482105 -122.439357134105 (37.7758252634821, -122.439357134105)
7821 99713 5 15 1415 Scott St 1 1 1 1     12 3x3   6001685.4406 2113539.6106 37.7834716060779 -122.43786717092199 (37.7834716060779, -122.437867170922)
7784 99714 5 15 1415 Scott St 2 1 1 1     12 3x3   6001688.147999999 2113522.0126 37.7834234404081 -122.43785654353 (37.7834234404081, -122.43785654353)
7284 99715 5 15 1415 Scott St 3 1 1 1     12 3x3   6001690.8553 2113503.3994 37.7833724872506 -122.43784584376199 (37.7833724872506, -122.437845843762)
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)
2892 99717 5 15 1415 Scott St 5 1 1 1     12 3x3   6001694.9164 2113468.8804 37.7832779377979 -122.437829320807 (37.7832779377979, -122.437829320807)
99533 100242 5 17 76 Linda St   10 2 1           6005815.0 2105046.0 37.76038415245 -122.422976606568 (37.76038415245, -122.422976606568)
94096 100243 5 17 1326-1332 Shotwell St   19 1 1           6008043.0 2100485.0 37.7479861507453 -122.41494814206699 (37.7479861507453, -122.414948142067)
Powered by Datasette · Query took 3.224ms · Data source: data.sfgov.org