sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
129932 125619 2 12 675 Marina Blvd 1 1 1 1     7 Width 3ft   5999768.34617 2121544.44179 37.8053415546285 -122.445075213367 (37.8053415546285, -122.445075213367)
80350 125620 2 12 2 Marina Blvd 1 1 1 1     3 Width 3ft   6003429.28949 2121440.99135 37.8052657768583 -122.43239866026501 (37.8052657768583, -122.432398660265)
168317 125621 2 12 2 Marina Blvd 2 1 1 1     2 Width 3ft   6003387.731459999 2121435.75978 37.8052490557616 -122.43254210304701 (37.8052490557616, -122.432542103047)
172903 125622 2 12 2 Marina Blvd 3 1 1 1     2 Width 3ft   6003320.96563 2121427.32718 37.80522211568471 -122.43277255161199 (37.8052221156847, -122.432772551612)
182809 125623 2 12 2 Marina Blvd 4 1 1 1     3 Width 3ft   6003269.3006 2121419.05247 37.805196465208205 -122.432950753169 (37.8051964652082, -122.432950753169)
32872 125618 2 12 3751 Broderick St 2 9 1 1     7 Width 6ft   5999580.4064 2121490.43215 37.8051825302106 -122.44572171438801 (37.8051825302106, -122.445721714388)
129811 125624 2 12 2 Marina Blvd 5 1 1 1     3 Width 3ft   6003226.8845 2121412.3541599996 37.8051756674842 -122.433097060284 (37.8051756674842, -122.433097060284)
83459 53180 1 12 2035X Stockton St 1 1 1 1   11/07/2006 12:00:00 AM     Permit Number 49098 6009862.07762326 2121221.64980232 37.8050261812939 -122.410121597856 (37.8050261812939, -122.410121597856)
132260 142527 2 12 2099 STOCKTON ST 1 1 1 1     3 Width 0ft   6009847.9779 2121202.9781 37.8049741231475 -122.41016907271201 (37.8049741231475, -122.410169072712)
25671 143222 2 12 2048 STOCKTON ST 2 1 1 1     8 Width 0ft   6009889.8742 2121194.9759 37.8049544993561 -122.410023519974 (37.8049544993561, -122.410023519974)
22369 142528 2 12 2099 STOCKTON ST 2 1 1 1     5 Width 0ft   6009851.4529 2121181.5487 37.8049154781273 -122.410155533168 (37.8049154781273, -122.410155533168)
99427 68208 1 12 2060 Stockton St 1 1 1 1 1 08/26/1995 12:00:00 AM 12   Permit Number 31990 6009900.21643537 2121162.10763095 37.804864830914205 -122.409985407616 (37.8048648309142, -122.409985407616)
167927 142529 2 12 2099 STOCKTON ST 3 1 1 1     6 Width 0ft   6009854.3488 2121159.5401 37.8048552103069 -122.41014395677401 (37.8048552103069, -122.410143956774)
30630 30845 1 12 1525 Beach St 1 1 1 1   02/16/1995 12:00:00 AM 15   Permit Number 34694 6002896.94795 2121295.66679 37.8048365538189 -122.434230497442 (37.8048365538189, -122.434230497442)
170626 142530 2 12 2099 STOCKTON ST 4 1 1 1     7 Width 0ft   6009857.2153 2121136.799 37.804792929574 -122.410132430396 (37.804792929574, -122.410132430396)
164126 142531 2 12 2099 STOCKTON ST 5 1 1 1     7 Width 0ft   6009860.4617 2121118.1321 37.8047418568723 -122.41011987716101 (37.8047418568723, -122.410119877161)
90630 98561 3 12 2035X Stockton St 4 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
91242 98559 3 12 2035X Stockton St 2 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
126599 98562 3 12 2035X Stockton St 5 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
141315 98560 3 12 2035X Stockton St 3 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
145078 102910 1 12 1664 North Point St 2 1 1 1   04/30/2013 12:00:00 AM   3x6 Permit Number 769943 6002777.8 2121059.4 37.80418106420979 -122.434625916396 (37.8041810642098, -122.434625916396)
118077 111289 2 12 306 AVILA ST 1 5 1 1       3x3   6000943.0 2121065.0 37.804092109664005 -122.440975765753 (37.804092109664, -122.440975765753)
136536 125625 2 12 1639 North Point St 1 1 1 1     1 Width 4ft   6002902.45766 2120950.27742 37.80388851819811 -122.43418672385201 (37.8038885181981, -122.434186723852)
155454 32040 1 12 3653 Buchanan St 1 1 1 1   04/26/2006 12:00:00 AM 6   Permit Number 48792 6003085.879 2120891.7543900004 37.8037382378899 -122.433547798688 (37.8037382378899, -122.433547798688)
26186 81258 1 12 287 Avila St 1 1 1 1   06/13/2008 12:00:00 AM 8 3x3 Permit Number 50831 6000919.15191 2120907.25979 37.8036576388633 -122.441046970049 (37.8036576388633, -122.441046970049)
34737 54046 1 12 3545 Webster St 1 1 1 1   04/18/1972 12:00:00 AM 6   Permit Number 767245 6002612.039030001 2120815.15788 37.8035010282129 -122.435182063824 (37.8035010282129, -122.435182063824)
92802 106543 1 12 930 Chestnut St 1 1 1 1   05/07/2014 12:00:00 AM   3x3 Permit Number 773058 6007374.7 2120599.1 37.8031770856949 -122.418685297733 (37.8031770856949, -122.418685297733)
151651 125627 2 12 3223 Gough St 2 1 1 1     8 Width 3ft   6004580.53995 2120638.13421 37.803126552307205 -122.428357354311 (37.8031265523072, -122.428357354311)
8728 121206 6 12 930 Chestnut St 2 1 1 1   11/22/2016 12:00:00 AM 3 3x3 Permit Number 778903 6007356.48577 2120579.5282099997 37.803122321012296 -122.418746939923 (37.8031223210123, -122.418746939923)
79502 98996 3 12 2190X North Point St 2 1 1 10   04/18/2011 12:00:00 AM   3x3   6000702.0 2120685.0 37.803035002067396 -122.441782472194 (37.8030350020674, -122.441782472194)
153358 125590 2 12 2150 North Point St 1 1 1 1     5 Width 4ft   6000527.3551199995 2120665.13471 37.8029705046583 -122.44238540588499 (37.8029705046583, -122.442385405885)
134843 125591 2 12 2150 North Point St 2 1 1 1     7 Width 4ft   6000507.36305 2120661.74606 37.802960060829996 -122.44245434519199 (37.80296006083, -122.442454345192)
152537 125594 2 12 206 Mallorca Way 2 1 1 1     10 Width 3ft   6001716.47221 2120564.71559 37.8027624842745 -122.438263253543 (37.8027624842745, -122.438263253543)
137014 50862 1 12 2341 Leavenworth St 1 1 1 1   04/08/2004 12:00:00 AM 4   Permit Number 47377 6007521.84434 2120437.74816 37.802742337637895 -122.418164653188 (37.8027423376379, -122.418164653188)
177865 125593 2 12 206 Mallorca Way 1 1 1 1     10 Width 3ft   6001729.50399 2120554.23968 37.8027344613822 -122.43821740612499 (37.8027344613822, -122.438217406125)
133239 65838 1 12 2250 North Point St 1 1 1 1   05/07/1990 12:00:00 AM 10   Permit Number 28828 5999979.6804599995 2120587.90078 37.8027272101646 -122.444275084734 (37.8027272101646, -122.444275084734)
131549 125592 2 12 2250 North Point St 2 1 1 1     9 Width 3ft   5999957.74098 2120584.9892700003 37.8027179642217 -122.444350796863 (37.8027179642217, -122.444350796863)
169218 125595 2 12 1423 Francisco St 1 1 1 1     4 Width 3ft   6004482.044419999 2120474.01566 37.8026703514085 -122.428686494511 (37.8026703514085, -122.428686494511)
82244 33326 1 12 3149 Gough St 1 1 1 1 1 11/14/1996 12:00:00 AM     Permit Number 37468 6004618.90292403 2120338.69412793 37.8023065379869 -122.42820324515199 (37.8023065379869, -122.428203245152)
52841 58312 1 12 2320 Hyde St 1 1 1 1   10/19/1978 12:00:00 AM 10   Permit Number 17334 6007115.85312 2120286.7149900002 37.8023047788062 -122.419558870373 (37.8023047788062, -122.419558870373)
150885 81640 1 12 145 Mallorca Way 1 1 1 1   06/13/2008 12:00:00 AM 9 3x3 Permit Number 50850 6001879.525719999 2120364.39427 37.802221727306204 -122.437684651343 (37.8022217273062, -122.437684651343)
136332 87878 1 12 145 Mallorca Way 2 1 1 1   06/13/2008 12:00:00 AM 3 3x3 Permit Number 50850 6001884.901219999 2120334.4275700003 37.8021397523048 -122.437663902165 (37.8021397523048, -122.437663902165)
34749 82669 1 12 3501 Divisadero St 1 1 1 1   06/13/2008 12:00:00 AM 9 3x3 Permit Number 50840 6000241.87041 2120304.09273 37.8019629042194 -122.443347380076 (37.8019629042194, -122.443347380076)
143308 41174 1 12 2149 Bay St 1 1 1 1 1 11/23/1999 12:00:00 AM     Permit Number 41893 6000489.10498095 2120261.32844842 37.8018595803393 -122.442488762194 (37.8018595803393, -122.442488762194)
148344 83285 1 12 1475 Chestnut St 1 1 1 1   07/01/2009 12:00:00 AM 9 3x3 Permit Number 52335 6004810.57206 2120169.10495 37.8018517327274 -122.42752788711799 (37.8018517327274, -122.427527887118)
121273 64388 1 12 520 Filbert St 1 1 1 1 1 12/02/1995 12:00:00 AM     Permit Number 25230 6010419.2366821 2119962.89606797 37.801601167334795 -122.408104647622 (37.8016011673348, -122.408104647622)
59494 143079 2 12 536 FILBERT ST 1 1 1 1     9 Width 0ft   6010364.8114 2119950.5825 37.8015643098365 -122.408292115742 (37.8015643098365, -122.408292115742)
131271 64977 1 12 3012 Gough St 1 1 1 1   07/01/2009 12:00:00 AM 8 3x3 Permit Number 52340 6004725.146919999 2119924.44806 37.8011751358946 -122.427806055509 (37.8011751358946, -122.427806055509)
67391 125628 2 12 3005 Gough St 1 1 1 1     8 Width 3ft   6004678.60564 2119921.44839 37.8011642666733 -122.427966894771 (37.8011642666733, -122.427966894771)
119883 100967 2 12 2655 Polk St 2 1 1 1       3x3   6006143.0 2119878.0 37.8011277057339 -122.42289635671699 (37.8011277057339, -122.422896356717)
93402 66797 1 12 2655 Polk St 1 1 1 1 1 09/20/1991 12:00:00 AM     Permit Number 30076 6006140.36971242 2119876.91514311 37.8011245785791 -122.422905381518 (37.8011245785791, -122.422905381518)
134015 125629 2 12 3001 Gough St 1 1 1 1     9 Width 3ft   6004680.60565 2119899.7870400003 37.8011049033356 -122.427958429433 (37.8011049033356, -122.427958429433)
5786 108707 1 12 1849 Chestnut St 1 1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773000 6003000.77487 2119918.27171 37.801060480419395 -122.433772685874 (37.8010604804194, -122.433772685874)
108470 96849 1 12 1401 Kearny St   1 1 1 1 07/29/2011 12:00:00 AM   3x3 Permit Number 767592 6010966.7 2119733.6 37.801002214186894 -122.40619400162501 (37.8010022141869, -122.406194001625)
126720 96850 1 12 1401 Kearny St   1 1 1 1 07/29/2011 12:00:00 AM   3x3 Permit Number 767592 6010966.7 2119733.6 37.801002214186894 -122.40619400162501 (37.8010022141869, -122.406194001625)
163968 30458 1 12 319 Union St 1 1 1 1   05/11/1956 12:00:00 AM 8   Permit Number 107 6011377.90261 2119696.06362 37.800922140404396 -122.40476841315001 (37.8009221404044, -122.40476841315)
61456 30447 1 12 337 Union St 1 1 1 1 1 07/25/2000 12:00:00 AM 6   Permit Number 43381 6011303.90393 2119683.69843 37.8008840523194 -122.40502361014799 (37.8008840523194, -122.405023610148)
53069 142475 2 12 400 UNION ST 1 1 1 1     2 Width 0ft   6010981.7466 2119687.9132 37.8008776110207 -122.406138713142 (37.8008776110207, -122.406138713142)
162124 142476 2 12 400 UNION ST 2 1 1 1     2 Width 0ft   6010961.4303 2119685.3736 37.8008695015228 -122.40620883743 (37.8008695015228, -122.40620883743)
138172 30425 1 12 367 Union St 1 1 1 1   05/11/1956 12:00:00 AM 5   Permit Number 79 6011159.52441 2119665.62673 37.800826359895 -122.405521953284 (37.800826359895, -122.405521953284)
1767 108696 1 12 3219 Laguna St 1 1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774620 6003723.121830001 2119813.07153 37.8008125903965 -122.431265542364 (37.8008125903965, -122.431265542364)
34384 125626 2 12 3219 Laguna St 2 1 1 1     1 Width 4ft   6003725.12144 2119805.22841 37.8007911685429 -122.431258062719 (37.8007911685429, -122.431258062719)
39017 91355 1 12 2125 Leavenworth St 1 1 1 1     1 3x3 Permit Number 52063 6007628.1327 2119682.16495 37.800673678399896 -122.417743252443 (37.8006736783999, -122.417743252443)
164875 125589 2 12 2500 Francisco St 1 9 1 1     10 Width 6ft   5999280.9627 2119804.58635 37.8005365515701 -122.446636601905 (37.8005365515701, -122.446636601905)
45458 125588 2 12 2500 Francisco St 2 9 1 1     2 Width 6ft   5999268.5814 2119802.4814299997 37.8005300647803 -122.446679294525 (37.8005300647803, -122.446679294525)
148962 41213 1 12 2526 Francisco St 1 1 1 1 1 11/29/1999 12:00:00 AM 11   Permit Number 41922 5999227.52525 2119790.57747 37.8004950343837 -122.446820507856 (37.8004950343837, -122.446820507856)
27482 41214 1 12 2526 Francisco St 2 1 1 1 1 11/29/1999 12:00:00 AM 11   Permit Number 41922 5999213.18355 2119788.9581400002 37.8004897688328 -122.446870019146 (37.8004897688328, -122.446870019146)
62202 33320 1 12 2929 Gough St 1 1 1 1 1 07/01/2003 12:00:00 AM 15   Permit Number 46661 6004720.44035 2119653.4015200003 37.800430645622605 -122.427803018508 (37.8004306456226, -122.427803018508)
171382 33319 1 12 2929 Gough St 2 1 1 1   11/14/1996 12:00:00 AM 15   Permit Number 37463 6004723.4328 2119639.75641 37.800393348939295 -122.42779169063999 (37.8003933489393, -122.42779169064)
181816 75489 2 12 2048 Jones St 6 1 1 1 1 02/01/1997 12:00:00 AM 12     6008179.24775 2119559.02881 37.8003665752162 -122.41582743750799 (37.8003665752162, -122.415827437508)
150936 125586 2 12 1570 Greenwich St 2 2 1 1     2 Width 5ft   6005351.57668 2119600.69848 37.800321618997295 -122.425615279117 (37.8003216189973, -122.425615279117)
35542 125578 2 12 3037 Octavia St 1 1 1 1     8 Width 2ft   6004236.80294 2119622.9490400003 37.8003196602889 -122.429474424723 (37.8003196602889, -122.429474424723)
174883 75553 2 12 2048 Jones St 5 1 1 1 1 02/01/1997 12:00:00 AM 5     6008181.17324 2119540.92663 37.8003169794008 -122.415819491999 (37.8003169794008, -122.415819491999)
32510 125587 2 12 1570 Greenwich St 3 1 1 1     7 Width 4ft   6005330.35199 2119597.17474 37.8003107443921 -122.42568847405701 (37.8003107443921, -122.425688474057)
147126 108594 2 12 1570x Greenwich St 5 1 1 1     6 12x6   6005284.85981 2119591.62978 37.800292948628204 -122.42584550017901 (37.8002929486282, -122.425845500179)
75005 75617 2 12 2048 Jones St 4 1 1 1 1 02/01/1997 12:00:00 AM 10     6008184.29777 2119514.11178 37.800243528176395 -122.415806780057 (37.8002435281764, -122.415806780057)
136082 75678 2 12 2048 Jones St 3 1 1 1 1 02/01/1997 12:00:00 AM 10     6008185.66586 2119502.4229599996 37.800211510507296 -122.415801217779 (37.8002115105073, -122.415801217779)
70074 125617 2 12 3157 Baker St 2 1 1 1     2 Width 3ft   5999356.19769 2119675.07907 37.800185256590204 -122.44636693749901 (37.8001852565902, -122.446366937499)
63086 75736 2 12 2048 Jones St 2 1 1 1 1 02/01/1997 12:00:00 AM 10     6008188.52321 2119484.98756 37.800163797885794 -122.415790094937 (37.8001637978858, -122.415790094937)
166282 75789 2 12 2048 Jones St 1 1 1 1 1 02/01/1997 12:00:00 AM 7     6008189.19796 2119473.08465 37.8001311534008 -122.415786916737 (37.8001311534008, -122.415786916737)
70428 80086 2 12 1171-1181 Filbert St 1 1 1 1 1 05/18/2002 12:00:00 AM 2     6007322.74748 2119486.0748799997 37.8001180745474 -122.41878609912399 (37.8001180745474, -122.418786099124)
100530 80155 1 12 3037-39 Octavia St 1 1 1 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52346 6004243.19927944 2119546.78446337 37.8001108941658 -122.429446856273 (37.8001108941658, -122.429446856273)
169070 125585 2 12 1741 Greenwich St 2 1 1 1     7 Width 1ft   6004569.03925 2119447.40428 37.799856464473706 -122.42831223713999 (37.7998564644737, -122.42831223714)
32286 125584 2 12 1807 Greenwich St 1 1 1 1     4 Width 3ft   6004142.183069999 2119385.45145 37.799662195598295 -122.42978489767201 (37.7996621955983, -122.429784897672)
46677 42686 1 12 2340 Larkin St 1 1 1 1   03/16/2011 12:00:00 AM 3   Permit Number 767586 6006754.357369999 2119313.32094 37.799611716670206 -122.420740681136 (37.7996117166702, -122.420740681136)
133442 125577 2 12 2955 Octavia St 1 1 1 1     3 Width 3ft   6004273.3 2119359.2831900003 37.7995977681877 -122.42932931820499 (37.7995977681877, -122.429329318205)
38119 91466 1 12 3041 Laguna St 1 1 1 1   04/15/2009 12:00:00 AM 5 3x3 Permit Number 52107 6003805.74749 2119235.5435099998 37.799231530079005 -122.43093838251 (37.799231530079, -122.43093838251)
41699 125615 2 12 3035 Baker St 1 1 1 1     2 Width 3ft   5999413.69331 2119275.4328400004 37.799091218745204 -122.446139218363 (37.7990912187452, -122.446139218363)
136800 61392 1 12 1665 Filbert St 1 1 1 1   03/26/2014 12:00:00 AM 3   Permit Number 771984 6004986.21736 2119156.81319 37.7990821724697 -122.42684793757799 (37.7990821724697, -122.426847937578)
181450 125616 2 12 3035 Baker St 2 1 1 1     2 Width 3ft   5999416.517999999 2119263.70633 37.799059182196295 -122.446128600073 (37.7990591821963, -122.446128600073)
29167 125678 2 12 900 Green St 4 9 1 1     5 Width 5ft   6008662.75141 2119030.67968 37.798943029353794 -122.41411691706999 (37.7989430293538, -122.41411691707)
150030 125679 2 12 900 Green St 10 9 1 1     2 Width 5ft   6008638.3454 2119028.9317400004 37.7989368590941 -122.414201246497 (37.7989368590941, -122.414201246497)
47967 125680 2 12 900 Green St 19 9 1 1     1 Width 5ft   6008611.01872 2119027.85836 37.7989323768872 -122.41429573018 (37.7989323768872, -122.41429573018)
134078 125681 2 12 900 Green St 21 9 1 1     2 Width 5ft   6008605.498459999 2119027.23009 37.798930341725104 -122.41431478769199 (37.7989303417251, -122.414314787692)
38738 125682 2 12 900 Green St 37 9 1 1     4 Width 5ft   6008560.62871 2119023.68152 37.798918077657 -122.41446980113899 (37.798918077657, -122.414469801139)
163206 125683 2 12 900 Green St 38 9 1 1     4 Width 5ft   6008554.76721 2119022.07601 37.7989133400383 -122.414489970262 (37.7989133400383, -122.414489970262)
26979 125684 2 12 900 Green St 39 9 1 1     2 Width 5ft   6008551.13913 2119021.83646 37.7989124784736 -122.414502507697 (37.7989124784736, -122.414502507697)
137858 125579 2 12 3006 Baker St 1 1 1 1     9 Width 4ft   5999469.68932 2119186.8037900003 37.7988510646785 -122.445939076035 (37.7988510646785, -122.445939076035)
169746 125583 2 12 2229 Greenwich St 1 1 1 1     4 Width 3ft   6002227.76415 2119120.45592 37.7988259933908 -122.43639049903099 (37.7988259933908, -122.436390499031)
133662 113938 1 12 3000 Baker St 1 1 1 1   12/09/2015 12:00:00 AM 1 3x3 Permit Number 776872 5999473.11509 2119163.08751 37.7987861417299 -122.44592551514401 (37.7987861417299, -122.445925515144)
67187 125581 2 12 1851 Filbert St 1 1 1 1     4 Width 3ft   6004102.18468 2119034.85803 37.798697291402995 -122.42989828508001 (37.798697291403, -122.42989828508)
Powered by Datasette · Query took 19.409ms · Data source: data.sfgov.org