sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
168893 41226 1 16 155 Retiro Way 1 1 1 1 1 11/30/1999 12:00:00 AM 8   Permit Number 41932 6001878.60529 2121714.18401 37.805927839759896 -122.437784566908 (37.8059278397599, -122.437784566908)
61737 106161 1 16 827 North Point St 1 1 1 1   03/31/2014 12:00:00 AM 3 3x3 Permit Number 770049 6006757.57528 2121490.3236599998 37.8055893943007 -122.42088419136499 (37.8055893943007, -122.420884191365)
176628 41234 1 16 3743 Webster St 1 1 1 1 1 11/30/1999 12:00:00 AM 5   Permit Number 41939 6002518.8447 2121486.57255 37.805339263172606 -122.435552627664 (37.8053392631726, -122.435552627664)
40934 142736 2 16 15 VANDEWATER ST 2 1 1 1     3 Width 0ft   6009218.8197 2121322.4003 37.805266741303 -122.412354799662 (37.805266741303, -122.412354799662)
133655 112372 2 16 15 Vandewater St 1 1 1 1     6 3x3   6009194.601 2121319.3086 37.805256893193494 -122.412438393162 (37.8052568931935, -122.412438393162)
137394 142655 2 16 55 VANDEWATER ST 4 1 1 1     8 Width 0ft   6009102.8791 2121306.4263 37.8052163739487 -122.412754898161 (37.8052163739487, -122.412754898161)
51491 118370 2 16 55 Vandewater St 3 1 1 1     2 2x2   6009076.084 2121302.8193 37.8052049660579 -122.41284737107901 (37.8052049660579, -122.412847371079)
50875 118368 2 16 55 Vandewater St 1 1 1 1     6 2x2   6009048.7736 2121299.2122 37.8051935288948 -122.412941627226 (37.8051935288948, -122.412941627226)
54813 143215 2 16 215 FRANCISCO ST 2 1 1 1     5 Width 0ft   6010264.7976 2121285.9953 37.805225422298996 -122.408732475128 (37.805225422299, -122.408732475128)
105255 98564 3 16 301X Francisco St 2 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
112530 98567 3 16 301X Francisco St 5 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
123219 98563 3 16 301X Francisco St 1 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
138890 98565 3 16 301X Francisco St 3 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
160416 142656 2 16 382 Francisco St 1 1 1 1     7 Width 0ft   6009478.0111 2121215.2198 37.8049869916815 -122.411450254798 (37.8049869916815, -122.411450254798)
69906 142657 2 16 392 Francisco St 2 1 1 1     7 Width 0ft   6009464.6135 2121214.7045 37.8049848253291 -122.411496582459 (37.8049848253291, -122.411496582459)
154475 142658 2 16 396 Francisco St 3 1 1 1     7 Width 0ft   6009447.6089 2121213.6739 37.8049810417497 -122.411555356166 (37.8049810417497, -122.411555356166)
134214 142744 2 16 410 FRANCISCO ST 1 1 1 1     8 Width 0ft   6009308.9956 2121195.6387 37.804923745513 -122.41203376959 (37.804923745513, -122.41203376959)
4622 142543 3 16 301 FRANCISCO ST 5 1 1 4     6 Width 0ft   6009503.7886 2121178.1337 37.8048866083098 -122.411358426924 (37.8048866083098, -122.411358426924)
4558 142520 3 16 301 FRANCISCO ST 3 1 1 4     7 Width 0ft   6009467.3323 2121175.1455 37.8048763586912 -122.411484377145 (37.8048763586912, -122.411484377145)
4611 142519 3 16 301 FRANCISCO ST 2 1 1 4     6 Width 0ft   6009452.9889 2121171.5596 37.804865708173104 -122.411533760714 (37.8048657081731, -122.411533760714)
4605 142542 3 16 301 FRANCISCO ST 1 1 1 4     8 Width 0ft   6009433.8643 2121170.962 37.8048629945672 -122.411599901453 (37.8048629945672, -122.411599901453)
128967 142540 2 16 2100 POWELL ST 9 1 1 1     9 Width 0ft   6009421.7884 2121061.7254 37.8045623807522 -122.411633968656 (37.8045623807522, -122.411633968656)
32276 31868 1 16 3633 Broderick St 1 1 1 1 1 11/29/1999 12:00:00 AM 7   Permit Number 41912 5999648.6988 2121058.91348 37.804001595372604 -122.445454333359 (37.8040015953726, -122.445454333359)
97910 100983 3 16 2190 Powell St 4 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
107842 100984 3 16 2190 Powell St 5 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
145388 100987 3 16 2190 Powell St 8 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
169417 249809 2 16 258 Chestnut St 8 13 1 1     5 Width 0ft   6010708.4562800005 2121025.2354099997 37.804534279087704 -122.407178739215 (37.8045342790877, -122.407178739215)
53839 249807 2 16 258 Chestnut St 6 13 1 1     7 Width 0ft   6010752.11734 2121021.55825 37.8045266258517 -122.407027386026 (37.8045266258517, -122.407027386026)
52205 249810 2 16 258 Chestnut St 9 13 1 1     5 Width 0ft   6010696.08755 2121019.21593 37.804517058874396 -122.407221117962 (37.8045170588744, -122.407221117962)
156801 249808 2 16 258 Chestnut St 7 13 1 1     12 Width 0ft   6010714.23144 2121016.75548 37.80451131849129 -122.40715815553101 (37.8045113184913, -122.407158155531)
64989 142537 2 16 2100 POWELL ST 6 1 1 1     11 Width 0ft   6009436.3973 2120993.5505 37.8043760089549 -122.411578593269 (37.8043760089549, -122.411578593269)
32782 142536 2 16 2100 POWELL ST 5 1 1 1     13 Width 0ft   6009440.4553 2120971.6371 37.8043160678486 -122.411563000977 (37.8043160678486, -122.411563000977)
58041 135851 2 16 787 Francisco St 1 1 1 1     15 Width 3ft   6007518.53532 2120901.3436 37.804015067204105 -122.41820899156299 (37.8040150672041, -122.418208991563)
60338 135850 2 16 2456 Leavenworth St 3 1 1 1     12 Width 2ft   6007513.5376 2120862.81684 37.803909001168606 -122.418223553398 (37.8039090011686, -122.418223553398)
67124 135849 2 16 2456 Leavenworth St 2 1 1 1     10 Width 3ft   6007515.30382 2120841.49853 37.8038505659037 -122.418215928918 (37.8038505659037, -122.418215928918)
98671 50376 1 16 1620 Montgomery St 5 1 1 1   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734)
112875 50379 1 16 1620 Montgomery St 3 1 1 1   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734)
144023 50380 1 16 1620 Montgomery St 4 1 1 1   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734)
183700 68974 1 16 3555 Broderick St 1 1 1 1 1 01/04/1994 12:00:00 AM 8   Permit Number 32964 5999680.68438 2120824.08507 37.803358645751295 -122.44532675102501 (37.8033586457513, -122.445326751025)
161924 142610 2 16 2424 JONES ST 1 1 1 1     6 Width 0ft   6008008.0914 2120777.2854 37.803701978308894 -122.416506051836 (37.8037019783089, -122.416506051836)
168673 135848 2 16 2434 Leavenworth St 2 1 1 1     11 Width 2ft   6007523.24086 2120777.2700900002 37.80367465761871 -122.418183905875 (37.8036746576187, -122.418183905875)
181487 135847 2 16 2434 Leavenworth St 1 1 1 1     15 Width 2ft   6007523.40269 2120763.6636799998 37.8036373069691 -122.41818238061501 (37.8036373069691, -122.418182380615)
70624 135855 2 16 220 Lombard St 2 1 1 1     7 Width 3ft   6011218.6149 2120762.89652 37.8038424981016 -122.405394792746 (37.8038424981016, -122.405394792746)
172038 135857 2 16 220 Lombard St 4 1 1 1     6 Width 3ft   6011195.52799 2120759.07991 37.803830727779896 -122.405474417834 (37.8038307277799, -122.405474417834)
46464 135859 2 16 220 Lombard St 6 1 1 1     5 Width 3ft   6011176.6986 2120755.37641 37.8038195060395 -122.405539317394 (37.8038195060395, -122.405539317394)
167843 135854 2 16 220 Lombard St 1 1 1 1     8 Width 3ft   6011219.52919 2120749.38326 37.8038054451262 -122.405390676534 (37.8038054451262, -122.405390676534)
29291 135856 2 16 220 Lombard St 3 1 1 1     7 Width 3ft   6011197.01398 2120748.14382 37.803800783049 -122.405468504785 (37.803800783049, -122.405468504785)
172610 135846 2 16 2430 Leavenworth St 2 1 1 1     11 Width 2ft   6007526.597999999 2120747.58183 37.803593330130894 -122.41817018222 (37.8035933301309, -122.41817018222)
33770 135858 2 16 220 Lombard St 5 1 1 1     8 Width 3ft   6011178.53707 2120744.3558400003 37.8037893490595 -122.405532178584 (37.8037893490595, -122.405532178584)
155997 135845 2 16 2430 Leavenworth St 1 1 1 1     10 Width 2ft   6007529.20491 2120735.0222099996 37.8035589913248 -122.418160269894 (37.8035589913248, -122.418160269894)
60551 53178 1 16 2420 REVISED Leavenworth St 1 1 1 1   11/14/2006 12:00:00 AM 5   Permit Number 49096 6007531.88349 2120715.221 37.8035047729776 -122.418149595852 (37.8035047729776, -122.418149595852)
169655 41205 1 16 3525 Broderick St 1 1 1 1 1 11/29/1999 12:00:00 AM 6   Permit Number 41911 5999706.5792 2120652.81241 37.802889855249504 -122.445224820077 (37.8028898552495, -122.445224820077)
154200 143244 2 16 1913 STOCKTON ST 1 1 1 1     5 Width 0ft   6009926.8482 2120632.4472 37.80341200747171 -122.409855833569 (37.8034120074717, -122.409855833569)
147000 81692 1 16 1756-1758 Bay St 1 1 1 1   07/01/2009 12:00:00 AM 4 3x3 Permit Number 52334 6002382.95834 2120580.66995 37.80284417507671 -122.43595801776002 (37.8028441750767, -122.43595801776)
157147 69527 1 16 2209 North Point St 1 1 1 1   03/18/1997 12:00:00 AM 6   Permit Number 37887 6000084.88337 2120557.1111 37.8026486714458 -122.44390881695699 (37.8026486714458, -122.443908816957)
157654 65833 1 16 2217 North Point St 1 1 1 1   05/07/1990 12:00:00 AM 6   Permit Number 28823 6000063.66175 2120554.12794 37.8026392699554 -122.44398203975099 (37.8026392699554, -122.443982039751)
155001 65968 1 16 990 Chestnut St 1 1 1 1   06/21/1990 12:00:00 AM 4   Permit Number 28992 6007125.46509 2120550.16631 37.8030286907859 -122.419544310327 (37.8030286907859, -122.419544310327)
49725 65835 1 16 2223 North Point St 1 1 1 1   05/07/1990 12:00:00 AM 4   Permit Number 28825 6000036.0569400005 2120549.43371 37.802624806145 -122.44407722848301 (37.802624806145, -122.444077228483)
68543 48595 1 16 2820 Polk St 1 1 1 1 1 08/28/2002 12:00:00 AM 7   Permit Number 45905 6006103.679280001 2120512.11503 37.802866605061 -122.42307752091499 (37.802866605061, -122.423077520915)
131807 249873 2 16 230 Greenwich St 9 13 1 1     26 Width 0ft   6011670.78297 2120474.23594 37.8030751776447 -122.403809705266 (37.8030751776447, -122.403809705266)
31893 79837 2 16 2808 Polk St 1 1 1 1 1 05/18/2002 12:00:00 AM 6     6006109.456119999 2120466.37489 37.80274134031279 -122.42305427704599 (37.8027413403128, -122.423054277046)
171246 249875 2 16 230 Greenwich St 11 13 1 1     19 Width 0ft   6011656.00691 2120465.5569700003 37.803050521838706 -122.40386022737499 (37.8030505218387, -122.403860227375)
81488 13074 1 16 645X Lombard St 4 1 1 3     18 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
91375 13073 1 16 645X Lombard St 3 1 1 3     18 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
32953 143252 2 16 661 LOMBARD ST 4 1 1 1     7 Width 0ft   6009254.6269 2120447.319 37.802865995827396 -122.412168998949 (37.8028659958274, -122.412168998949)
128628 107635 6 16 1150 Lombard St 10 7 1 1   10/01/2014 12:00:00 AM 3   Permit Number 773092 6006825.00646 2120436.80144 37.8027004912885 -122.42057600387301 (37.8027004912885, -122.420576003873)
43904 135809 2 16 1154 Chestnut St 2 9 1 1     10 Width 4ft   6006309.30935 2120436.0273599997 37.8026692893277 -122.422360524716 (37.8026692893277, -122.422360524716)
31620 143251 2 16 661 LOMBARD ST 3 1 1 1     8 Width 0ft   6009160.7844 2120435.4058 37.8028280191875 -122.41249290083599 (37.8028280191875, -122.412492900836)
51583 249891 2 16 230 Greenwich St 27 13 1 1     15 Width 0ft   6011455.072819999 2120426.06234 37.8029308517393 -122.404552786308 (37.8029308517393, -122.404552786308)
37934 249882 2 16 230 Greenwich St 18 13 1 1     27 Width 0ft   6011509.072430001 2120419.3733099997 37.8029155030083 -122.40436544761499 (37.8029155030083, -122.404365447615)
71454 249847 2 16 289 Greenwich St 4 17 1 1     5 Width 0ft   6011426.79495 2120392.20909 37.8028363185975 -122.40464825831002 (37.8028363185975, -122.40464825831)
30620 121688 1 16 800 Lombard St 2 1 1 1     7     6008462.12689 2120388.3747 37.802659650390794 -122.414907290765 (37.8026596503908, -122.414907290765)
155614 121689 1 16 800 Lombard St 3 1 1 1     9     6008443.301530001 2120385.2075400003 37.8026498963393 -122.414972211914 (37.8026498963393, -122.414972211914)
63079 249835 2 16 333 Greenwich St 3 7 1 1     10 Width 0ft   6011233.03828 2120380.52255 37.8027933993566 -122.40531793578 (37.8027933993566, -122.40531793578)
35676 249834 2 16 333 Greenwich St 2 7 1 1     9 Width 0ft   6011234.1519 2120371.9476900003 37.8027699171526 -122.40531347785401 (37.8027699171526, -122.405313477854)
30309 249829 2 16 339 Greenwich St 2 7 1 1     5 Width 0ft   6011201.84726 2120367.04696 37.802754654775704 -122.405424923615 (37.8027546547757, -122.405424923615)
39263 249833 2 16 333 Greenwich St 1 7 1 1     7 Width 0ft   6011234.89731 2120366.37397 37.8027546547576 -122.40531050560101 (37.8027546547576, -122.405310505601)
154980 143084 2 16 463 Greenwich St 1 1 1 1     9 Width 0ft   6010663.1497 2120298.4418 37.802536147352704 -122.407284261185 (37.8025361473527, -122.407284261185)
117381 116893 2 16 176 ALHAMBRA ST 1 1 1 1       3x3   6001452.0 2120263.0 37.8019190076456 -122.43915682267799 (37.8019190076456, -122.439156822678)
173495 249974 2 16 28 Napier Ln 1 7 1 1     18 Width 0ft   6011652.50252 2120258.9240099997 37.802482962378704 -122.403857805517 (37.8024829623787, -122.403857805517)
41984 135853 2 16 12 Filbert St 9 10 1 1     26     6012286.0131 2120198.4327700003 37.8023522396158 -122.40166127704799 (37.8023522396158, -122.401661277048)
54014 135817 2 16 1083 Lombard St 1 2 1 1     4 Width 3ft   6007203.659469999 2120166.57987 37.8019798636266 -122.419246489941 (37.8019798636266, -122.419246489941)
39787 135818 2 16 1071 Lombard St 1 2 1 1     6 Width 3ft   6007217.26018 2120160.1793299997 37.801963055314495 -122.419198970666 (37.8019630553145, -122.419198970666)
68322 142615 2 16 701 GREENWICH ST 4 1 1 1     11 Width 0ft   6009481.4553 2120134.1797 37.802018917842105 -122.411361918128 (37.8020189178421, -122.411361918128)
51205 142614 2 16 701 GREENWICH ST 3 1 1 1     12 Width 0ft   6009469.9119 2120131.871 37.8020119312896 -122.41140170073099 (37.8020119312896, -122.411401700731)
169591 142613 2 16 701 GREENWICH ST 2 1 1 1     7 Width 0ft   6009456.5216 2120130.9476 37.802008644823204 -122.41144797242701 (37.8020086448232, -122.411447972427)
156784 71423 2 16 701 Greenwich St 1 1 1 1 1 08/26/1995 12:00:00 AM 12     6009442.6696 2120129.5624 37.8020040644534 -122.411495809181 (37.8020040644534, -122.411495809181)
188163 135837 2 16 2333 Leavenworth St 1 1 1 1     10 Width 3ft   6007565.4054 2120114.29452 37.801856667323705 -122.417990966211 (37.8018566673237, -122.417990966211)
159690 249982 2 16 224 Filbert St 3 7 1 1     12 Width 0ft   6011639.74764 2120113.25639 37.8020822820333 -122.403891687471 (37.8020822820333, -122.403891687471)
150527 142616 2 16 1867 POWELL ST 1 1 1 1     7 Width 0ft   6009512.0452 2120108.7843 37.801950904005 -122.411254267134 (37.801950904005, -122.411254267134)
27269 250005 2 16 232 Filbert St 3 17 1 1     8 Width 0ft   6011493.8796 2120090.77159 37.802012393927 -122.404394879735 (37.802012393927, -122.404394879735)
159363 249970 2 16 213 Filbert St 1 13 1 1     31 Width 0ft   6011737.037830001 2120086.51138 37.802014281606205 -122.403553132272 (37.8020142816062, -122.403553132272)
28833 249969 2 16 213 Filbert St 2 13 1 1     28 Width 0ft   6011730.79134 2120085.86253 37.802012151107704 -122.403574702535 (37.8020121511077, -122.403574702535)
182162 249963 2 16 271 Filbert St 1 7 1 1     10 Width 0ft   6011592.60874 2120072.38059 37.8019674134157 -122.404051933175 (37.8019674134157, -122.404051933175)
184115 249937 2 16 339 Filbert St 2 7 1 1     7 Width 0ft   6011248.56733 2120031.66705 37.8018363956996 -122.405239616532 (37.8018363956996, -122.405239616532)
76837 249945 2 16 325 Filbert St 1 7 1 1     24 Width 0ft   6011292.48387 2120026.50548 37.8018246784261 -122.40508728037399 (37.8018246784261, -122.405087280374)
116481 249933 2 16 345 Filbert St 2 7 1 1     7 Width 0ft   6011225.47356 2120026.31802 37.801820417444 -122.405319155254 (37.801820417444, -122.405319155254)
58002 249931 2 16 345 Filbert St 5 4 1 1     5 Width 0ft   6011214.74621 2120016.06231 37.801791658008106 -122.405355554416 (37.8017916580081, -122.405355554416)
72395 135807 2 16 1311 Lombard St 1 9 1 1     12     6005955.98541 2119974.55098 37.8013822560451 -122.42355037726101 (37.8013822560451, -122.423550377261)
136520 142628 2 16 1922 MASON ST 1 1 1 1     8 Width 0ft   6009103.5255 2119888.7677 37.801323873537896 -122.41265238046002 (37.8013238735379, -122.41265238046)
63220 135844 2 16 1155 Greenwich St 1 2 1 1     7 Width 6ft   6007360.5897 2119841.38777 37.801095804879395 -122.418680361323 (37.8010958048794, -122.418680361323)
Powered by Datasette · Query took 21.07ms · Data source: data.sfgov.org