sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
13427 3615 1 2 100X Cargo Way 51 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6017970.88261 2098244.46459 37.7423869635862 -122.380461869644 (37.7423869635862, -122.380461869644)
16754 3613 1 2 100X Cargo Way 49 1 1 9     6 3X3   6018003.94992 2098219.94993 37.742321475865296 -122.380345828295 (37.7423214758653, -122.380345828295)
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)
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)
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)
101112 3570 1 2 100X Cargo Way 5 1 1 9     12 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
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)
159024 3587 1 2 100X Cargo Way 23 1 1 9   03/01/2006 12:00:00 AM 3 3X3   6018440.3984199995 2097892.70026 37.7414469858874 -122.378813986102 (37.7414469858874, -122.378813986102)
13841 3685 1 5 100X Cargo Way 121 5 1 9     8 3x3   6016762.06772 2099192.87656 37.744924332395 -122.38470767871999 (37.744924332395, -122.38470767872)
99473 3689 1 5 200X Cargo Way 3 11 1 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
118559 3686 1 5 100X Cargo Way 1 11 1 9     12 8   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
127580 3691 1 5 200X Cargo Way 5 11 1 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
127726 3690 1 5 200X Cargo Way 4 11 1 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
128521 3688 1 5 200X Cargo Way 2 11 1 9     18 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
140153 3687 1 5 200X Cargo Way 1 11 1 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
4931 3597 1 11 100X Cargo Way 33 1 1 9   11/03/2017 12:00:00 AM 3 3X3   6018273.82586 2098018.1543799997 37.7417822729228 -122.37939865514299 (37.7417822729228, -122.379398655143)
4969 3585 1 11 100X Cargo Way 21 1 1 9   05/01/2017 03:02:00 PM 3 3x3   6018473.32905 2097868.47388 37.7413822805579 -122.37869844028299 (37.7413822805579, -122.378698440283)
4972 3572 1 11 100X Cargo Way 7 1 1 9   04/10/2017 09:42:00 AM 3 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
4978 3596 1 11 100X Cargo Way 32 1 1 9   05/01/2017 03:07:00 PM 3 3X3   6018288.66955 2098007.43076 37.7417536466133 -122.379346585295 (37.7417536466133, -122.379346585295)
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)
4987 27477 1 11 100X Cargo Way 20 1 1 9   04/10/2017 09:59:00 AM 3 3X3   6018492.70308 2097854.80306 37.7413458112573 -122.378630501891 (37.7413458112573, -122.378630501891)
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)
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)
5040 3573 1 11 100X Cargo Way 8 1 1 9   04/10/2017 09:44:00 AM 3 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
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)
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)
14769 22080 1 11 3240 03rd St 4 1 1 9   02/07/1995 12:00:00 AM 3 3X3   6015965.08966 2100473.24055 37.748395837805504 -122.387552815329 (37.7483958378055, -122.387552815329)
15308 3663 1 11 100X Cargo Way 99 1 1 9   03/12/1990 12:00:00 AM 3 3X3   6017184.0839 2098879.2573700002 37.744086528482 -122.383226584333 (37.744086528482, -122.383226584333)
15531 27469 1 11 3201 03rd St 1 1 1 9   12/10/1999 12:00:00 AM 3 3X3   6016045.2641 2100630.7066900004 37.7488326475194 -122.387286553937 (37.7488326475194, -122.387286553937)
15616 22077 1 11 3240 03rd St 1 1 1 9   02/07/1995 12:00:00 AM 3 3x3   6015962.924330001 2100554.9145299997 37.748619977641 -122.387566000296 (37.748619977641, -122.387566000296)
16475 22078 1 11 3240 03rd St 2 1 1 9   02/07/1995 12:00:00 AM 3 3X3   6015962.98615 2100528.59711 37.7485477189018 -122.38756395072399 (37.7485477189018, -122.387563950724)
16783 3649 1 11 100X Cargo Way 85 1 1 9   05/31/1996 12:00:00 AM 3 3X3   6017394.85513 2098704.5539599997 37.7436184736271 -122.382485623916 (37.7436184736271, -122.382485623916)
16801 22083 1 11 3240 03rd St 7 1 1 9   02/07/1995 12:00:00 AM 3     6015972.44529 2100358.98918 37.7480825346922 -122.38751940998999 (37.7480825346922, -122.38751940999)
16808 22081 1 11 3240 03rd St 5 1 1 9   02/07/1995 12:00:00 AM 3 3X3   6015967.5851300005 2100424.02181 37.7482608315927 -122.387540752722 (37.7482608315927, -122.387540752722)
16832 22079 1 11 3240 03rd St 3 1 1 9   02/07/1995 12:00:00 AM 3 3X3   6015964.59871 2100502.1098700003 37.7484750797647 -122.38755652683201 (37.7484750797647, -122.387556526832)
22316 3655 1 11 100X Cargo Way 91 1 1 9     6 3X3   6017319.27606 2098771.24223 37.743797410827796 -122.382751600221 (37.7437974108278, -122.382751600221)
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)
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)
22331 3651 1 11 100X Cargo Way 87 1 1 9   12/10/1999 12:00:00 AM 3 3X3   6017363.3819699995 2098733.24342 37.7436955104472 -122.38259644736601 (37.7436955104472, -122.382596447366)
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)
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)
66735 27467 1 11 3255 03rd St 1 1 1 9   12/10/1999 12:00:00 AM 3 3X3   6016160.2227 2100486.94206 37.7484442654916 -122.386878998841 (37.7484442654916, -122.386878998841)
79952 27468 1 11 3255 03rd St 2 1 1 9   12/10/1999 12:00:00 AM 3 3X3   6016160.2227 2100486.94206 37.7484442654916 -122.386878998841 (37.7484442654916, -122.386878998841)
80797 22089 1 11 3400X 03rd St 2 1 1 9     12 3X3   6016009.5802 2099538.74144 37.74583236096979 -122.387333787882 (37.7458323609698, -122.387333787882)
83584 22094 1 11 3400X 03rd St 7 1 1 9     3 3X3   6016017.00918 2099367.08567 37.745361441081705 -122.38729612741999 (37.7453614410817, -122.38729612742)
89420 22091 1 11 3400X 03rd St 4 1 1 9   03/16/1995 12:00:00 AM 3 3X3   6016010.69646 2099489.56952 37.7456974068511 -122.387326498503 (37.7456974068511, -122.387326498503)
97953 22088 1 11 3400X 03rd St 1 1 1 9     12     6016008.97261 2099546.3179900004 37.7458531309618 -122.387336417288 (37.7458531309618, -122.387336417288)
104079 22096 1 11 3400X 03rd St 9 1 1 9   03/16/1995 12:00:00 AM 3 3X3   6016015.13995 2099327.44393 37.7452524895199 -122.38729982623 (37.7452524895199, -122.38729982623)
106525 22092 1 11 3400X 03rd St 5 1 1 9     3 3X3   6016011.14545 2099476.0569599997 37.74566032901671 -122.387324003523 (37.7456603290167, -122.387324003523)
116070 22090 1 11 3400X 03rd St 3 1 1 9   03/03/1995 12:00:00 AM 3 3X3   6016009.63374 2099530.63966 37.745810118120104 -122.387333037689 (37.7458101181201, -122.387333037689)
122100 22095 1 11 3400X 03rd St 8 1 1 9     6 3X3   6016014.437030001 2099301.1365900002 37.745180216060604 -122.387300422076 (37.7451802160606, -122.387300422076)
1123 28040 1 15 1500 The Embarcadero 8 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011973.34792 2120976.9306 37.8044723526732 -122.40279804081499 (37.8044723526732, -122.402798040815)
1899 25838 1 15 800X The Embarcadero 2 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6013225.308119999 2119220.74162 37.7997201038678 -122.39834219506099 (37.7997201038678, -122.398342195061)
2090 25842 1 15 800X The Embarcadero 6 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6013279.137069999 2119139.97441 37.799501334781795 -122.398150256355 (37.7995013347818, -122.398150256355)
2826 28035 1 15 1500 The Embarcadero 3 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011869.41049 2121075.03017 37.804735906188796 -122.403164632367 (37.8047359061888, -122.403164632367)
3114 25811 1 15 1300X The Embarcadero 7 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012315.257619999 2120560.3270799997 37.8033475454092 -122.401585526252 (37.8033475454092, -122.401585526252)
3657 25806 1 15 1300X The Embarcadero 2 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012234.78854 2120695.21971 37.8037134372885 -122.401873481994 (37.8037134372885, -122.401873481994)
3684 27830 1 15 900X The Embarcadero 3 1 1 9   12/20/2000 12:00:00 AM 24     6013136.88249 2119351.75589 37.800074911578 -122.398657381345 (37.800074911578, -122.398657381345)
3878 28034 1 15 1500 The Embarcadero 2 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011851.06099 2121093.24306 37.8047848895665 -122.403229415001 (37.8047848895665, -122.403229415001)
4198 25837 1 15 800X The Embarcadero 1 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6013209.63865 2119244.79078 37.7997852642353 -122.39839810591299 (37.7997852642353, -122.398398105913)
4234 28039 1 15 1500 The Embarcadero 7 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011949.43377 2121001.73319 37.8045391192453 -122.402882543817 (37.8045391192453, -122.402882543817)
4885 25808 1 15 1300X The Embarcadero 4 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012265.91209 2120646.37252 37.803581051681704 -122.401762341075 (37.8035810516817, -122.401762341075)
4943 25845 1 15 800X The Embarcadero 9 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6013327.75405 2119068.43707 37.799307618121 -122.397977001961 (37.799307618121, -122.397977001961)
5391 27795 1 15 900X The Embarcadero 1 1 1 9   12/18/2000 12:00:00 AM 24     6013107.19159 2119396.29372 37.8001955475498 -122.398763251324 (37.8001955475498, -122.398763251324)
5630 28043 1 15 1500 The Embarcadero 11 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6012024.04433 2120930.34171 37.8043472614676 -122.402619322118 (37.8043472614676, -122.402619322118)
5672 25807 1 15 1300X The Embarcadero 3 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012251.480269999 2120666.53325 37.8036356027669 -122.40181370136801 (37.8036356027669, -122.401813701368)
5709 25839 1 15 800X The Embarcadero 3 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6013239.738969999 2119198.12663 37.799658812366204 -122.398290671092 (37.7996588123662, -122.398290671092)
5784 25812 1 15 1300X The Embarcadero 8 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012332.091990001 2120538.6639799997 37.803289003136 -122.401525746517 (37.803289003136, -122.401525746517)
5815 25809 1 15 1300X The Embarcadero 5 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012278.63673 2120626.00413 37.8035258351232 -122.40171687406 (37.8035258351232, -122.40171687406)
6222 27831 1 15 900X The Embarcadero 4 1 1 9   12/20/2000 12:00:00 AM 24     6013146.80764 2119335.33451 37.8000303753641 -122.39862188328699 (37.8000303753641, -122.398621883287)
6770 25843 1 15 800X The Embarcadero 7 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6013291.71436 2119122.7738 37.7994548065492 -122.39810552676902 (37.7994548065492, -122.398105526769)
6942 28041 1 15 1500 The Embarcadero 9 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011990.996730001 2120961.47906 37.804430911926495 -122.40273587786501 (37.8044309119265, -122.402735877865)
7124 27832 1 15 900X The Embarcadero 5 1 1 9   12/20/2000 12:00:00 AM 24     6013158.11098 2119319.87365 37.799988553278105 -122.39858168361799 (37.7999885532781, -122.398581683618)
7283 25805 1 15 1300X The Embarcadero 1 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012220.3272400005 2120713.92747 37.803763997176794 -122.401924842279 (37.8037639971768, -122.401924842279)
7341 28044 1 15 1500 The Embarcadero 12 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6012052.65409 2120901.81041 37.8042705187194 -122.402518307585 (37.8042705187194, -122.402518307585)
7619 25841 1 15 800X The Embarcadero 5 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6013268.0055599995 2119155.84179 37.799544282796205 -122.398189889456 (37.7995442827962, -122.398189889456)
7632 25840 1 15 800X The Embarcadero 4 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6013252.78025 2119179.61334 37.7996087057277 -122.39824424358999 (37.7996087057277, -122.39824424359)
7651 28038 1 15 1500 The Embarcadero 6 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011930.42206 2121019.16916 37.80458593256979 -122.402949563068 (37.8045859325698, -122.402949563068)
7856 28033 1 15 1500 The Embarcadero 1 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011830.13261 2121113.3124599997 37.80483882640021 -122.403303252939 (37.8048388264002, -122.403303252939)
8279 28037 1 15 1500 The Embarcadero 5 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011908.75369 2121039.95348 37.8046417912539 -122.403026011743 (37.8046417912539, -122.403026011743)
8292 25844 1 15 800X The Embarcadero 8 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6013309.3136 2119095.04373 37.7993796466195 -122.398042680326 (37.7993796466195, -122.398042680326)
8337 25810 1 15 1300X The Embarcadero 6 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012292.79565 2120604.39505 37.803467291949204 -122.401666356441 (37.8034672919492, -122.401666356441)
8683 28036 1 15 1500 The Embarcadero 4 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011891.7394900005 2121054.53142 37.8046808685929 -122.40308591740101 (37.8046808685929, -122.403085917401)
8734 25813 1 15 1300X The Embarcadero 9 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012345.50187 2120516.10099 37.8032277988787 -122.401477754221 (37.8032277988787, -122.401477754221)
8754 28042 1 15 1500 The Embarcadero 10 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6012004.18493 2120947.51548 37.804393307678 -122.4026892561 (37.804393307678, -122.4026892561)
8997 27829 1 15 900X The Embarcadero 2 1 1 9   12/20/2000 12:00:00 AM 24     6013118.439809999 2119374.83982 37.800137266990596 -122.39872282141 (37.8001372669906, -122.39872282141)
18001 27903 1 15 280 The Embarcadero 33 1 1 9   01/31/2001 12:00:00 AM 12     6015937.152000001 2112771.705 37.78216321542121 -122.388507741674 (37.7821632154212, -122.388507741674)
20295 25849 1 15 800X The Embarcadero 13 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012736.380854 2120162.4372415002 37.8022785256437 -122.40010024450399 (37.8022785256437, -122.400100244504)
47992 27910 1 15 100 The Embarcadero 4 1 1 9   02/01/2001 12:00:00 AM 12 3X3   6015913.96301 2112493.47301 37.7813979677469 -122.38856853840599 (37.7813979677469, -122.388568538406)
53184 27902 1 15 280 The Embarcadero 32 1 1 9   01/31/2001 12:00:00 AM 12     6015941.319 2112799.309 37.782239240724 -122.38849525296699 (37.782239240724, -122.388495252967)
54631 25675 1 15 350X The Embarcadero 2 1 1 9   12/18/2000 12:00:00 AM 12 4x4   6013785.794644901 2118604.8635638 37.7980602547356 -122.39635950070699 (37.7980602547356, -122.396359500707)
66037 121471 2 15 102X King St 1 11 1 9     9 3x3   6015546.21298 2111901.81315 37.779753015830394 -122.38979944679701 (37.7797530158304, -122.389799446797)
75152 27904 1 15 280 The Embarcadero 34 1 1 9   01/31/2001 12:00:00 AM 12     6015934.027000001 2112727.434 37.7820414840201 -122.388515461744 (37.7820414840201, -122.388515461744)
75154 27919 1 15 100 The Embarcadero 13 1 1 9   02/01/2001 12:00:00 AM 12 3X3   6015840.17801 2112278.62901 37.7808039650097 -122.38880879774099 (37.7808039650097, -122.388808797741)
77564 27895 1 15 280 The Embarcadero 25 1 1 9   01/31/2001 12:00:00 AM 12     6015957.985 2112989.413 37.7827621471367 -122.388450868666 (37.7827621471367, -122.388450868666)
77648 25821 1 15 1300X The Embarcadero 17 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
78967 25865 1 15 800X The Embarcadero 29 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012565.65701 2120204.63501 37.8023848701418 -122.400694001959 (37.8023848701418, -122.400694001959)
79277 15089 1 15 30 Mission St 4 1 1 9     6 4X4   6014680.683616 2116874.398416 37.7933585592202 -122.393141753221 (37.7933585592202, -122.393141753221)
80016 27916 1 15 100 The Embarcadero 10 1 1 9   02/01/2001 12:00:00 AM 12 3X3   6015873.81501 2112343.7330099996 37.780984590279104 -122.388696976059 (37.7809845902791, -122.388696976059)
80438 27893 1 15 280 The Embarcadero 23 1 1 9   01/31/2001 12:00:00 AM 12     6015963.194 2113042.017 37.7829068745448 -122.388436520394 (37.7829068745448, -122.388436520394)
Powered by Datasette · Query took 7.633ms · Data source: data.sfgov.org