sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
70435 187490 2 83 750 Velasco Ave 1 2 1 1     6     6006575.2964699995 2086657.1322 37.709935258482 -122.419042759324 (37.709935258482, -122.419042759324)
183829 218974 2 83 211 Miramar Ave 1 1 1 1     13 Width 4ft   5995324.88397 2091369.23318 37.7222336187729 -122.458266889107 (37.7222336187729, -122.458266889107)
109753 985 3 83 1628 Alemany Blvd 1 1 1 2     15 3X3   6001654.0889800005 2092682.1975 37.7262003881553 -122.436482304747 (37.7262003881553, -122.436482304747)
32277 218975 2 83 25 Lakewood Ave 2 1 1 1     11 Width 3ft   5993599.79076 2092994.2198700001 37.726596156286504 -122.464347997761 (37.7265961562865, -122.464347997761)
97990 11657 1 83 699X Junipero Serra Blvd 18 1 1 13     12 3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
91370 51032 1 83 78 Vienna St 1 1 1 1   07/08/2004 12:00:00 AM 3   Permit Number 47507 6004848.23489 2092967.4640400002 37.7271646546122 -122.425460601145 (37.7271646546122, -122.425460601145)
57897 51033 1 83 76 Vienna St 1 1 1 1   07/08/2004 12:00:00 AM 4   Permit Number 47508 6004871.9247 2093005.4504099998 37.7272702952631 -122.42538140772 (37.7272702952631, -122.42538140772)
172999 83898 1 83 661 Cayuga Ave 1 1 1 1   05/30/2008 12:00:00 AM 9 3x3 Permit Number 50511 6001665.34461 2093208.93849 37.7276473387373 -122.436481078764 (37.7276473387373, -122.436481078764)
164652 192352 2 83 1040 Palou Ave 6 1 1 1     26 Width 4ft   6017850.25276 2093091.0077 37.728229933050706 -122.380520862443 (37.7282299330507, -122.380520862443)
49592 11636 1 83 499X Junipero Serra Blvd 4 1 1 13     12 3   5991474.53212 2093889.5616418 37.7289318087747 -122.471760091134 (37.7289318087747, -122.471760091134)
93732 11634 1 83 499X Junipero Serra Blvd 2 1 1 13     12 3   5991474.53212 2093889.5616418 37.7289318087747 -122.471760091134 (37.7289318087747, -122.471760091134)
172557 218973 2 83 550 Hearst Ave 2 1 1 1     7 Width 2ft   5997760.19795 2094413.18303 37.7307312291661 -122.450067916609 (37.7307312291661, -122.450067916609)
187664 218966 2 83 255 Santa Ana Ave 1 1 1 1     9 Width 3ft   5992657.85366 2095112.0231700002 37.7323567798226 -122.467758171218 (37.7323567798226, -122.467758171218)
179390 218976 2 83 208 Joost Ave 1 9 1 1     8 Width 10ft   6000663.81639 2094977.92785 37.73244761315671 -122.440070159711 (37.7324476131567, -122.440070159711)
36227 225787 2 83 46 Bosworth St 1 1 1 1     5 Width 2ft   6004400.603180001 2095343.96322 37.7336646890731 -122.42717726484 (37.7336646890731, -122.42717726484)
116506 116066 3 83 40 MALTA DR   11 1 2     10     5999623.0 2096071.0 37.7353896244756 -122.44374699604401 (37.7353896244756, -122.443746996044)
79400 41689 1 83 117 Conrad St 2 1 1 1   06/19/2000 12:00:00 AM     Permit Number 42143 6001812.465231299 2096668.95095007 37.737156097415706 -122.436219989049 (37.7371560974157, -122.436219989049)
70126 192356 2 83 1400 Quint St 3 4 1 1     11 Width 3ft   6013361.05471 2096570.45075 37.7375350213353 -122.396284074954 (37.7375350213353, -122.396284074954)
34313 192355 2 83 1400 Quint St 2 4 1 1     13 Width 1ft   6013376.06433 2096591.73652 37.7375943028269 -122.39623367064199 (37.7375943028269, -122.396233670642)
156396 192354 2 83 1400 Quint St 1 4 1 1     10 Width 1ft   6013388.3658300005 2096606.99697 37.7376368893361 -122.39619220741999 (37.7376368893361, -122.39619220742)
14443 25984 3 83 1901 Oakdale Ave 2 1 1 2     12 2x2   6013408.21183 2096665.5323700001 37.7377987196205 -122.396127690947 (37.7377987196205, -122.396127690947)
13842 25983 3 83 1901 Oakdale Ave 1 1 1 2     12 2x2   6013395.85675 2096673.78587 37.7378206945684 -122.396170987024 (37.7378206945684, -122.396170987024)
84899 92547 1 83 99 Santa Marina St 1 5 1 1       3x3 Permit Number 52890 6006207.5 2097640.2 37.740071660795 -122.42109327168501 (37.740071660795, -122.421093271685)
163347 218971 2 83 736 Myra Way 1 1 1 1     10 Width 2ft   5997513.55349 2097982.45512 37.7405174763054 -122.451177906656 (37.7405174763054, -122.451177906656)
145428 33475 3 83 194X COLERIDGE ST 1 1 1 2   11/20/1996 12:00:00 AM 40   Permit Number 37572 6006432.0 2098629.0 37.742799336995795 -122.420387207052 (37.7427993369958, -122.420387207052)
84512 33479 1 83 190 Coleridge St 1 1 1 1   11/20/1996 12:00:00 AM     Permit Number 37572 6006437.49245401 2098651.34949844 37.742861013201704 -122.420369801641 (37.7428610132017, -122.420369801641)
94836 33480 1 83 190 Coleridge St 6 1 1 1   11/20/1996 12:00:00 AM     Permit Number 37572 6006437.49245401 2098651.34949844 37.742861013201704 -122.420369801641 (37.7428610132017, -122.420369801641)
112329 33476 1 83 190 Coleridge St 5 1 1 1   11/20/1996 12:00:00 AM     Permit Number 37572 6006437.49245401 2098651.34949844 37.742861013201704 -122.420369801641 (37.7428610132017, -122.420369801641)
118261 33474 1 83 190 Coleridge St 4 1 1 1   11/20/1996 12:00:00 AM     Permit Number 37572 6006437.49245401 2098651.34949844 37.742861013201704 -122.420369801641 (37.7428610132017, -122.420369801641)
141574 33477 1 83 190 Coleridge St 3 1 1 1   11/20/1996 12:00:00 AM     Permit Number 37572 6006437.49245401 2098651.34949844 37.742861013201704 -122.420369801641 (37.7428610132017, -122.420369801641)
143673 33478 1 83 190 Coleridge St 2 1 1 1   11/20/1996 12:00:00 AM     Permit Number 37572 6006437.49245401 2098651.34949844 37.742861013201704 -122.420369801641 (37.7428610132017, -122.420369801641)
90352 107514 2 83 76 Taraval St 2 1 1 1     15 3x10   5993384.0 2099214.0 37.7436616846124 -122.4655456274 (37.7436616846124, -122.4655456274)
54476 218970 2 83 85 Teresita Blvd 1 1 1 1     4 Width 2ft   5997504.5128 2099195.16066 37.7438467530404 -122.45129660546499 (37.7438467530404, -122.451296605465)
52799 192306 2 83 3600 03rd St 4 4 1 1     21 Width 5ft   6015896.02327 2098855.55467 37.74395018136929 -122.38767879773701 (37.7439501813693, -122.387678797737)
177456 225383 2 83 464 Valley St 1 1 1 1     17 Width 3ft   6002919.07295 2099218.44031 37.744219217150395 -122.432576000288 (37.7442192171504, -122.432576000288)
2265 252991 2 83 65 Valley St 1 1 1 1       3x3   6005528.0 2099293.0 37.7445715466522 -122.423560184697 (37.7445715466522, -122.423560184697)
87227 64914 1 83 65 Valley St 1 1 1 1 1 03/21/1989 12:00:00 AM   4x4 Permit Number 25941 6005478.362986099 2099307.48712071 37.7446085231046 -122.42373284962 (37.7446085231046, -122.42373284962)
46622 248136 2 83 226 Rutledge St 1 1 1 1     7 Width 2ft   6010037.88024 2099520.31318 37.745449227116204 -122.407981876971 (37.7454492271162, -122.407981876971)
130861 225380 2 83 3200 Cesar Chavez St 11 1 1 1     13 Width 3ft   6008095.36431 2100612.74929 37.7483398640139 -122.41477610753401 (37.7483398640139, -122.414776107534)
76795 225788 2 83 4436 25th St 1 1 1 1     15 Width 3ft   6001105.5651 2101159.8137 37.7494467567732 -122.43898580666 (37.7494467567732, -122.43898580666)
158058 225799 2 83 3965 25th St 1 1 1 1     7 Width 3ft   6004086.71679 2101282.70984 37.7499533700549 -122.428685663533 (37.7499533700549, -122.428685663533)
57020 218969 2 83 150 Alton Ave 2 2 1 1     6 Width 4ft   5993603.1998 2101661.03992 37.750393275225704 -122.46496537605499 (37.7503932752257, -122.464965376055)
188474 218968 2 83 150 Alton Ave 1 2 1 1     10 Width 4ft   5993617.45125 2101661.58733 37.7503955999976 -122.464916133678 (37.7503955999976, -122.464916133678)
150960 218967 2 83 140 Alton Ave 3 2 1 1     4 Width 4ft   5993644.45362 2101662.07824 37.7503985047832 -122.46482279396099 (37.7503985047832, -122.464822793961)
23985 192353 2 83 1500 Minnesota St 1 1 1 1     25 Width 2ft   6015367.9403099995 2101545.1725 37.7513060448498 -122.38969261993 (37.7513060448498, -122.38969261993)
30174 225388 2 83 306 Chattanooga St 1 1 1 1     16 Width 4ft   6004766.979119999 2101818.89406 37.751464083609996 -122.426371452475 (37.75146408361, -122.426371452475)
25338 225387 2 83 300 Chattanooga St 4 1 1 1     13 Width 4ft   6004770.30193 2101839.2583 37.7515201869079 -122.426361411567 (37.7515201869079, -122.426361411567)
53360 225386 2 83 300 Chattanooga St 3 1 1 1     8 Width 4ft   6004769.89273 2101857.00053 37.751568879815395 -122.42636408974501 (37.7515688798154, -122.426364089745)
176581 225385 2 83 300 Chattanooga St 2 1 1 1     13 Width 4ft   6004766.71932 2101872.10114 37.7516101631948 -122.42637613885701 (37.7516101631948, -122.426376138857)
124107 225384 2 83 300 Chattanooga St 1 1 1 1     12 Width 4ft   6004767.459419999 2101889.24161 37.7516572687753 -122.426374799776 (37.7516572687753, -122.426374799776)
47218 192303 2 83 2250 24th St 5 1 1 1     10 Width 3ft   6011758.176530001 2102347.8311400004 37.753309143502605 -122.402232092032 (37.7533091435026, -122.402232092032)
69720 192302 2 83 2250 24th St 4 1 1 1     4 Width 3ft   6011784.47888 2102348.07827 37.753311290205296 -122.402141149916 (37.7533112902053, -122.402141149916)
175214 192301 2 83 2250 24th St 3 1 1 1     8 Width 3ft   6011807.32161 2102351.9134 37.753323095606106 -122.402062424168 (37.7533230956061, -122.402062424168)
131706 192300 2 83 2250 24th St 2 1 1 1     14 Width 3ft   6011831.68624 2102353.37218 37.7533284609567 -122.401978268278 (37.7533284609567, -122.401978268278)
23787 192299 2 83 2250 24th St 1 1 1 1     3 Width 3ft   6011852.1113599995 2102354.12957 37.7533316805221 -122.401907686797 (37.7533316805221, -122.401907686797)
152668 192298 2 83 2200 24th St 1 1 1 1     7 Width 3ft   6011908.73866 2102359.4276900003 37.7533493881837 -122.40171222904699 (37.7533493881837, -122.401712229047)
152796 225789 2 83 409 Dellbrook Ave 1 4 1 1     1 Width 3ft   5997048.20072 2102795.35511 37.753705857856204 -122.453134258532 (37.7537058578562, -122.453134258532)
175184 225800 2 83 839 Sanchez St 1 1 1 1     0 Width 3ft   6003765.43327 2103426.88271 37.755822575974705 -122.429949607592 (37.7558225759747, -122.429949607592)
140993 56058 1 83 2858 22nd St 1 1 1 1   12/03/2007 12:00:00 AM   3x3 Permit Number 49940 6009112.81160157 2103362.97509043 37.7559484836074 -122.41145205807301 (37.7559484836074, -122.411452058073)
134591 225784 2 83 98 Hill St 1 1 1 1     5 Width 3ft   6005770.92499 2103464.5515400004 37.756039377343505 -122.423016636805 (37.7560393773435, -122.423016636805)
184629 225785 2 83 96 Hill St 1 1 1 1     5 Width 3ft   6005776.35688 2103464.45432 37.7560394169139 -122.422997844584 (37.7560394169139, -122.422997844584)
43682 225786 2 83 94 Hill St 1 1 1 1     6 Width 3ft   6005786.7967300005 2103464.50998 37.7560401588409 -122.422961744009 (37.7560401588409, -122.422961744009)
57413 225818 2 83 98 Hill St 6 2 1 1     10 Width 6ft   6005774.11943 2103465.5032 37.7560421706386 -122.423005656989 (37.7560421706386, -122.423005656989)
187202 225803 2 83 378 Diamond St 1 1 1 1     12 Width 3ft   6001778.51091 2103657.66309 37.7563435190568 -122.43683753583099 (37.7563435190568, -122.436837535831)
181842 225802 2 83 372 Diamond St 1 1 1 1     12 Width 3ft   6001775.08554 2103686.11524 37.75642144712079 -122.436851418666 (37.7564214471208, -122.436851418666)
168265 225805 2 83 367 Diamond St 1 1 1 1     11 Width 3ft   6001818.89494 2103707.75244 37.7564833474558 -122.436701459403 (37.7564833474558, -122.436701459403)
55974 225806 2 83 363 Diamond St 1 1 1 1     10 Width 3ft   6001815.68909 2103737.4020700003 37.7565645760008 -122.43671466866002 (37.7565645760008, -122.43671466866)
4450 225795 2 83 3000X 21st St 5 1 1 1     8 Width 3ft   6008004.64414 2103879.4657900003 37.7573044302625 -122.415321039155 (37.7573044302625, -122.415321039155)
4518 225796 2 83 3000X 21st St 4 1 1 1     9 Width 3ft   6008035.828509999 2103884.08468 37.7573188652869 -122.415213517995 (37.7573188652869, -122.415213517995)
4515 225797 2 83 3000X 21st St 3 1 1 1     8 Width 3ft   6008067.53952 2103885.7722400003 37.75732528104621 -122.41510396797301 (37.7573252810462, -122.415103967973)
4521 225798 2 83 3000X 21st St 2 1 1 1     11 Width 3ft   6008119.80842 2103888.79141 37.757336508198705 -122.414923414683 (37.7573365081987, -122.414923414683)
59057 225804 2 83 4433 20th St 1 1 1 1     11 Width 3ft   6001581.80688 2104063.4307 37.7574464772949 -122.437546862602 (37.7574464772949, -122.437546862602)
165124 225801 2 83 4201 18th St 3 1 1 1     11 Width 3ft   6001928.34635 2105251.90853 37.7607294461137 -122.43643345245 (37.7607294461137, -122.43643345245)
69464 218977 2 83 254 Edgewood Ave 1 1 1 1     27 Width 3ft   5996588.22406 2105623.7456099996 37.761445530401 -122.45492930356701 (37.761445530401, -122.454929303567)
55477 225792 2 83 3291 Shotwell St 3 1 1 1     7 Width 3ft   6007807.819130001 2105426.09185 37.761540045560295 -122.416111269835 (37.7615400455603, -122.416111269835)
58336 225382 2 83 3614 18th St 1 1 1 1     7 Width 3ft   6005452.14403 2105496.18029 37.761599759639104 -122.424263576509 (37.7615997596391, -122.424263576509)
95274 225793 2 83 3291 Shotwell St 2 1 1 1     5 Width 3ft   6007803.17898 2105505.53039 37.761757904533205 -122.416132944404 (37.7617579045332, -122.416132944404)
76249 225794 2 83 3291 Shotwell St 1 1 1 1     6 Width 3ft   6007798.59434 2105543.95905 37.761863162968105 -122.416151522586 (37.7618631629681, -122.416151522586)
183667 225780 2 83 3271 18th St 1 1 1 1     3 Width 2ft   6007669.1739300005 2105574.3226 37.76193925642529 -122.41660128882401 (37.7619392564253, -122.416601288824)
149426 225781 2 83 3271 18th St 2 1 1 1     5 Width 2ft   6007691.06747 2105574.75784 37.7619416827748 -122.416525598274 (37.7619416827748, -122.416525598274)
174186 225782 2 83 3271 18th St 3 1 1 1     5 Width 2ft   6007716.52666 2105576.00343 37.761946534627 -122.416437632899 (37.761946534627, -122.416437632899)
32326 225783 2 83 3251 18th St 1 1 1 1     4 Width 2ft   6007765.10393 2105579.72042 37.7619594722828 -122.416269885947 (37.7619594722828, -122.416269885947)
170242 192294 2 83 551 Utah St 4 1 1 1     13 Width 4ft   6010701.8989 2105624.20056 37.7622463056326 -122.40611574324 (37.7622463056326, -122.40611574324)
25212 192295 2 83 551 Utah St 5 1 1 1     12 Width 5ft   6010700.612380001 2105651.26498 37.7623205464704 -122.406122099663 (37.7623205464704, -122.406122099663)
188952 192296 2 83 551 Utah St 6 1 1 1     11 Width 4ft   6010697.50187 2105678.84279 37.762396094938104 -122.406134800806 (37.7623960949381, -122.406134800806)
69712 192297 2 83 551 Utah St 9 1 1 1     9 Width 2ft   6010694.42792 2105749.21353 37.7625891451824 -122.406150390541 (37.7625891451824, -122.406150390541)
134588 192304 2 83 2599 Mariposa St 3 1 1 1     7 Width 3ft   6009910.49486 2105936.61453 37.7630598260768 -122.40887496583001 (37.7630598260768, -122.40887496583)
33563 192305 2 83 2599 Mariposa St 4 1 1 1     5 Width 3ft   6009925.06485 2105936.96188 37.763061595931894 -122.40882459747 (37.7630615959319, -122.40882459747)
151890 192390 2 83 233 Mississippi St 2 1 1 1     16 Width 4ft   6014050.42421 2105956.49266 37.763345430981396 -122.394557641045 (37.7633454309814, -122.394557641045)
107280 56260 1 83 238 Grattan St 1 1 1 1   07/31/1973 12:00:00 AM     Permit Number 12386 5997570.92464879 2106477.05534424 37.763844826719705 -122.451592119849 (37.7638448267197, -122.451592119849)
168395 225816 2 83 220 States St 1 1 1 1     15 Width 3ft   6000887.34044 2106474.16774 37.7640262618211 -122.440121464252 (37.7640262618211, -122.440121464252)
151215 225817 2 83 220 States St 2 1 1 1     13 Width 3ft   6000861.2218 2106493.57318 37.764078057384296 -122.440213192391 (37.7640780573843, -122.440213192391)
50532 225778 2 83 924 Clayton St 1 1 1 1     20 Width 3ft   5998777.438569999 2106776.2154 37.7647352648411 -122.447440705541 (37.7647352648411, -122.447440705541)
75021 225791 2 83 920 Ashbury St 1 1 1 1     6 Width 3ft   5999226.76064 2106974.09226 37.765304251518 -122.44590085663799 (37.765304251518, -122.445900856638)
53654 225790 2 83 920 Ashbury St 2 1 1 1     6 Width 3ft   5999222.99784 2106999.85397 37.765374771852706 -122.445915724224 (37.7653747718527, -122.445915724224)
33903 225779 2 83 1559 Masonic Ave 1 1 1 1     12 Width 3ft   5999770.51083 2107118.5981099997 37.765732061717294 -122.44403054288901 (37.7657320617173, -122.444030542889)
180692 225809 2 83 197 Noe St 2 1 1 1     18 Width 3ft   6002900.20105 2107141.3628 37.765972605181204 -122.433207255136 (37.7659726051812, -122.433207255136)
40849 225810 2 83 197 Noe St 3 1 1 1     27 Width 3ft   6002901.372830001 2107162.40051 37.766030436082794 -122.433204705528 (37.7660304360828, -122.433204705528)
42776 225811 2 83 197 Noe St 4 1 1 1     22 Width 3ft   6002903.222130001 2107175.55757 37.766066667072 -122.43319924936701 (37.766066667072, -122.433199249367)
40148 225812 2 83 197 Noe St 5 1 1 1     29 Width 3ft   6002912.30789 2107203.01713 37.7661425797454 -122.43316978576999 (37.7661425797454, -122.43316978577)
19824 16637 3 83 159 Noe St 2 1 1 2     24 3X3   6002887.79495 2107329.82108 37.7664893619256 -122.433263632733 (37.7664893619256, -122.433263632733)
Powered by Datasette · Query took 7.799ms · Data source: data.sfgov.org