sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
358 251286 3 20 1299x Hudson Ave 7 1 1 2 3 02/09/1998 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
359 22941 3 11 413 Valencia St 1 1 1 2   04/05/2017 12:00:00 AM 6 3X3   6006166.67617 2107189.14794 37.766288570288204 -122.421912561635 (37.7662885702882, -122.421912561635)
360 6307 3 79 1804 Ellis St 2 1 1 2     6 4x4   6002139.3488 2112974.3616 37.781945376326 -122.436256362281 (37.781945376326, -122.436256362281)
361 85803 4 69 923 Folsom St 1 1 1 1   04/05/2017 12:00:00 AM 3 3x3 Permit Number 778048 6011427.0378 2111936.1074 37.779617893816 -122.40405196806002 (37.779617893816, -122.40405196806)
362 187139 3 47 2301 Sunset Blvd 1 9 1 1     39 Width 0ft   5984937.035 2099496.8257 37.7439474344515 -122.494773601416 (37.7439474344515, -122.494773601416)
363 119608 6 34 299x Avalon Ave 4 7 1 1                    
364 182551 2 37 2565 Judah St 1 1 1 1     3 Width 0ft   5986541.5452 2105693.4321 37.7610554202125 -122.489681251316 (37.7610554202125, -122.489681251316)
365 251211 4 6 210X Shipley St 4 1 1 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604.0 2111950.0 37.779665925350706 -122.40344075372101 (37.7796659253507, -122.403440753721)
366 22992 3 11 670 Valencia St 2 1 1 2   04/05/2017 12:00:00 AM 18 3X3   6006180.5496 2105697.57647 37.7621938490894 -122.42175862016501 (37.7621938490894, -122.421758620165)
367 235603 3 15 715 Valencia St 1 1 1 2     7 Width 3ft   6006265.7166 2105404.69213 37.7613944596986 -122.42144325851002 (37.7613944596986, -122.42144325851)
368 18096 3 35 3008 Pine St 1 1 1 2   01/29/1997 12:00:00 AM 6 3X3   5999424.6928 2114682.6521 37.786481285230295 -122.44577068023099 (37.7864812852303, -122.445770680231)
369 192563 4 11 33 08th St 1 1 1 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008747.97709 2111280.89227 37.777668779422896 -122.413273679445 (37.7776687794229, -122.413273679445)
370 3092 3 15 2980 California St 1 1 1 2     12 3X3   6000114.4381800005 2115142.33295 37.7877828069853 -122.443417371621 (37.7877828069853, -122.443417371621)
371 8188 1 42 1272 Fulton St 1 1 1 1   09/19/1997 12:00:00 AM 10 3X4   6001679.2828 2111174.9406 37.7769784708042 -122.437719062833 (37.7769784708042, -122.437719062833)
372 251291 4 11 33 08th St 5 1 1 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
373 250075 4 26 1599X Bush St 4 1 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
374 117614 1 11 345 Stockton St 2 1 1 1   06/30/2016 12:00:00 AM 3 5x5   6010658.32467 2115339.45675 37.788919706525704 -122.406951233227 (37.7889197065257, -122.406951233227)
375 251284 3 20 1299x Hudson Ave 5 1 1 2 3 06/21/1996 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
376 229176 3 11 793 Valencia St 1 1 1 2     2 Width 3ft   6006285.11873 2105008.6290700003 37.7603080570896 -122.42134802750601 (37.7603080570896, -122.421348027506)
377 250072 4 26 1599X Bush St 1 1 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
378 138112 3 59 1698 Sutter St 1 1 1 2     17 Width 0ft   6004508.5013 2114699.1479 37.7868155327596 -122.428183141793 (37.7868155327596, -122.428183141793)
379 122497 2 11 31X 08th St 1 1 1 1     4 3x3   6008445.21835 2111601.2724900004 37.7785314648928 -122.414343702699 (37.7785314648928, -122.414343702699)
380 54250 1 12 1278 24th Ave 1 1 1 1   11/16/2012 12:00:00 AM 3 3x3 Permit Number 769471 5988656.6839 2106624.6375 37.7637355217759 -122.48243422269199 (37.7637355217759, -122.482434222692)
381 122664 1 11 401x Laguna St 2 1 1 1   11/10/2016 12:00:00 AM 3 3X3            
382 228870 1 11 132 Church St 1 4 1 1   11/03/2006 12:00:00 AM 2 Width 4ft Permit Number 49185 6004081.45763 2108139.41942 37.768779966653106 -122.42919270218599 (37.7687799666531, -122.429192702186)
383 181340 2 18 1360 24th Ave 1 1 1 1     16 Width 0ft   5988678.0351 2106085.8063 37.7622572799997 -122.48232089502501 (37.7622572799997, -122.482320895025)
384 85806 4 6 210X Shipley St 2 1 1 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011627.0 2111882.0 37.77948049775679 -122.40335640121799 (37.7794804977568, -122.403356401218)
385 251282 3 20 1299x Hudson Ave 1 1 1 2 3 04/07/2016 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
386 2602 1 26 1760 Bush St 1 1 1 1     6 3X3   6005112.3923 2115130.7833 37.7880348455319 -122.42612455857201 (37.7880348455319, -122.426124558572)
387 85807 4 6 210X Shipley St 3 1 1 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604.0 2111950.0 37.779665925350706 -122.40344075372101 (37.7796659253507, -122.403440753721)
388 11057 3 32 1630 Hyde St 1 1 1 2     70 3X3   6007426.31744 2117960.00612 37.795933702633796 -122.418319444503 (37.7959337026338, -122.418319444503)
389 191855 3 39 573 10th St 2 9 1 2     49 Width 6ft Cal Trans adjacent; 10 ft ROW 6009921.77605 2108434.69103 37.7699196037317 -122.409012217656 (37.7699196037317, -122.409012217656)
390 251276 3 37 1175X Hudson Ave 4 1 1 2 3 03/09/1998 12:00:00 AM   3x3   6017547.0 2094834.0 37.732999109091 -122.381690402626 (37.732999109091, -122.381690402626)
391 251275 3 37 1175x Hudson Ave 1 1 1 2 3 09/16/2011 12:00:00 AM   3x3   6017547.0 2094834.0 37.732999109091 -122.381690402626 (37.732999109091, -122.381690402626)
392 251280 3 20 1275x Hudson Ave 1 1 1 2 3 03/11/2006 12:00:00 AM   3x3   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
393 251277 3 76 1200x Hudson Ave 3 1 1 2 3 10/26/2011 12:00:00 AM   3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
394 85804 4 69 923 Folsom St 2 1 1 1   04/05/2017 12:00:00 AM 3 3x3 Permit Number 778048 6011441.4589 2111949.4191 37.7796552503769 -122.404003016031 (37.7796552503769, -122.404003016031)
395 249557 4 11 1450 Franklin St 3 4 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005881.27559 2115126.52616 37.788066583556706 -122.423464052238 (37.7880665835567, -122.423464052238)
396 251212 4 6 210X Shipley St 5 1 1 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604.0 2111950.0 37.779665925350706 -122.40344075372101 (37.7796659253507, -122.403440753721)
397 13004 3 80 368 Lombard St 1 1 1 2   02/12/2016 06:38:00 AM 3 4X4   6010562.3418 2120670.5672 37.8035522695821 -122.407659361785 (37.8035522695821, -122.407659361785)
398 251281 3 20 1275x Hudson Ave 4 1 1 2 3 03/23/2006 12:00:00 AM   3x3   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
399 17856 3 41 2121 Pine St 1 1 1 2   04/21/2000 12:00:00 AM 10 3X3   6003596.6138 2115206.3541 37.7881565558045 -122.431374278321 (37.7881565558045, -122.431374278321)
400 251289 4 11 33 08th St 3 1 1 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
401 235987 1 16 1118 Church St 1 1 1 1   04/20/2000 12:00:00 AM 10 Width 3ft Permit Number 42064 6004405.04081 2102370.6961 37.7529587370629 -122.42766238971399 (37.7529587370629, -122.427662389714)
402 251283 3 20 1299x Hudson Ave 9 1 1 2 3 06/06/1997 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
403 65940 4 62 620 Eddy St 1 1 1 1 1 06/04/1990 12:00:00 AM 8   Permit Number 28961 6007431.46715 2113367.23378 37.78332336932171 -122.41797588370702 (37.7833233693217, -122.417975883707)
404 249555 4 11 1450 Franklin St 1 4 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005893.0868 2115064.96247 37.787898211588704 -122.423418809148 (37.7878982115887, -122.423418809148)
405 13887 3 15 1028 Market St 1 1 1 2     12 4x4   6009423.7082400005 2112763.96692 37.781778865529105 -122.411040866943 (37.7817788655291, -122.411040866943)
406 249556 4 11 1450 Franklin St 2 4 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005884.0832400005 2115105.79396 37.7880098165527 -122.423452863778 (37.7880098165527, -122.423452863778)
407 248462 1 16 130 Beulah St 1 1 1 1     9 Width 0ft Permit Number 779787 5997458.097999999 2107812.3026 37.767504613553 -122.45207869525 (37.767504613553, -122.45207869525)
408 23369 1 15 1350 Van Ness Ave 1 1 1 1     13 4x4   6006387.07969 2115184.64805 37.788254707334 -122.421718185767 (37.788254707334, -122.421718185767)
409 251278 3 76 1200x Hudson Ave 4 1 1 2 3 01/27/2016 09:31:00 AM   3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
410 251287 3 20 1299x Hudson Ave 8 1 1 2 3 02/09/1998 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
411 154366 2 11 411 Valencia St 1 1 1 1     0 Width 3ft   6006164.37856 2107202.76015 37.7663258166161 -122.42192147568899 (37.7663258166161, -122.421921475689)
412 251290 4 11 33 08th St 4 1 1 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
413 249558 4 11 1450 Franklin St 4 4 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005877.98213 2115146.79048 37.7881220384566 -122.42347688825899 (37.7881220384566, -122.423476888259)
414 17191 1 26 1804X Bush St 2 1 1 1     10 4X4   6004806.1465 2115088.0891 37.7879003042654 -122.427181073064 (37.7879003042654, -122.427181073064)
415 250074 4 26 1599X Bush St 3 1 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
416 192564 4 11 33 08th St 2 1 1 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
417 229177 3 11 789 Valencia St 1 1 1 2     5 Width 3ft   6006284.79968 2105036.34994 37.7603841541343 -122.42135109956699 (37.7603841541343, -122.421351099567)
418 23307 3 15 1000 Van Ness Ave 2 1 1 2   08/01/2014 12:00:00 AM 2 3x3   6006542.6232900005 2114014.0044299997 37.785049178209206 -122.421096875635 (37.7850491782092, -122.421096875635)
419 13971 3 15 1150X Market St 1 1 1 2     12 4x4   6008925.3091 2112314.2981 37.780516220741 -122.412733301341 (37.780516220741, -122.412733301341)
420 54426 1 20 770 Carolina St 1 1 1 1   07/02/1973 12:00:00 AM 15 3x3 Permit Number 12242 6012397.0815 2104349.75534 37.758841631549394 -122.400163199892 (37.7588416315494, -122.400163199892)
421 236222 3 81 758 Valencia St 1 1 1 2     7 Width 3ft   6006212.30332 2105198.62923 37.7608256474983 -122.42161335716801 (37.7608256474983, -122.421613357168)
422 23174 1 15 240 Van Ness Ave 1 1 1 5     5 3x3   6006908.21847 2111432.04348 37.777980343250796 -122.419648771078 (37.7779803432508, -122.419648771078)
423 109554 2 15 300x Van Ness Ave 10 1 1 1     4 3x3   6006839.87541 2111919.81075 37.7793157843461 -122.41991981597201 (37.7793157843461, -122.419919815972)
424 122666 1 11 401x Laguna St 4 1 1 1   11/10/2016 12:00:00 AM 3 3X3            
425 251299 4 15 2190X Market St 3 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
426 21683 1 35 1840 Sutter St 1 1 1 1   08/03/1999 12:00:00 AM 6 2x2   6003770.0848 2114594.6383 37.786486768354294 -122.430730428794 (37.7864867683543, -122.430730428794)
427 251307 2 17 200 Cashmere St 1 13 1 1       3x3   6016315.0 2096328.0 37.7370332293639 -122.38605389871 (37.7370332293639, -122.38605389871)
428 14314 3 15 2190X Market St 8 1 1 2     9 4X4   6003589.1349 2107204.4091 37.766184772649495 -122.430828874247 (37.7661847726495, -122.430828874247)
429 142788 2 82 733 POLK ST 1 1 1 1     7 Width 0ft Polk St Scape will replant 6007029.0497 2113497.6534 37.7836588132661 -122.419377346786 (37.7836588132661, -122.419377346786)
430 103824 1 21 1000 Polk St 4 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006951.91038 2114418.6460599997 37.786183288961205 -122.419709589538 (37.7861832889612, -122.419709589538)
431 251298 4 15 2190X Market St 4 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
432 251297 4 15 2190X Market St 5 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
433 251301 2 36 100 Whitney Young Cir 2 13 1 7       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
434 136390 2 17 3395 Sacramento St 6 1 1 1   04/06/2017 12:00:00 AM 3 Width 5ft Permit Number 779746 5998765.27001 2115243.09553 37.787982442971604 -122.448092477507 (37.7879824429716, -122.448092477507)
435 95185 1 15 1401X Divisadero St 6 1 1 1     3 3x3   6001223.4102 2113260.1588 37.78267801898829 -122.43944557401699 (37.7826780189883, -122.439445574017)
436 6932 3 32 500 Fell St 1 1 1 2     12 3X3   6004980.8762 2110598.20876 37.775582081585895 -122.42625675563801 (37.7755820815859, -122.426256755638)
437 20292 3 3 20X Sunset Blvd 13 1 1 2     36 60            
438 157409 1 58 125 Highland Ave 1 1 1 1   04/06/2017 12:00:00 AM 3 3x5   6005572.56549 2096690.1102099998 37.7374271143738 -122.423221099494 (37.7374271143738, -122.423221099494)
439 136984 2 17 454 Walnut St 5 1 1 1   04/06/2017 12:00:00 AM 3 Width 4ft Permit Number 779785 5998641.89853 2115102.68231 37.7875898520492 -122.448509202661 (37.7875898520492, -122.448509202661)
440 157410 1 58 125 Highland Ave 2 1 1 1   04/06/2017 12:00:00 AM 3 2x5   6005546.67522 2096690.9332 37.7374279129674 -122.423310672857 (37.7374279129674, -122.423310672857)
441 251295 1 2 220 Point Lobos Ave 1 1 1 1   06/26/1989 12:00:00 AM   3x3 Permit Number 27117 5982087.0 2112698.0 37.7800268469822 -122.50560657808902 (37.7800268469822, -122.505606578089)
442 9602 1 26 1355 Golden Gate Ave 4 1 1 1     11 3X3   6003083.4108 2112017.0963 37.779370559175206 -122.432921935155 (37.7793705591752, -122.432921935155)
443 251293 2 54 3789 Market St 1 5 2 1       3x3   6000208.0 2102740.0 37.753734455764 -122.44220302061701 (37.753734455764, -122.442203020617)
444 44838 1 17   12 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
445 251285 3 11 1299x Hudson Ave 2 1 1 2 3 03/11/2006 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
446 251296 4 15 2190X Market St 2 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
447 27524 3 2 3201 California St 4 1 1 2     9 3X3   5999021.2149 2114925.4479 37.787124893549795 -122.447184087894 (37.7871248935498, -122.447184087894)
448 224849 2 32 4 Rotteck St 1 1 1 1     18 3x3 Permit Number 779889 6003244.1353400005 2095137.54828 37.733032453088704 -122.431160782146 (37.7330324530887, -122.431160782146)
449 200971 3 15 1408 Market St 1 1 1 2     5 Width 0ft Permit Number 779898 6007408.8361 2110843.7597 37.7763932439775 -122.417875241075 (37.7763932439775, -122.417875241075)
450 142159 2 16 490X Baker St 1 1 1 1     2 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
451 192346 4 83 118 10th St 1 1 1 1   04/09/2014 12:00:00 AM 1 Width 3ft Permit Number 770901 6007994.19176 2110350.5452799997 37.7750719195804 -122.41581539288201 (37.7750719195804, -122.415815392882)
452 221749 2 26 275 Grattan St 3 1 2 1     24 Width 4ft   5997432.91763 2106413.5715 37.763662611962 -122.452064861225 (37.763662611962, -122.452064861225)
453 200966 3 15 1438 Market St 1 1 1 2     11 Width 0ft Permit Number 779897 6007276.3996 2110716.1923 37.776035520315205 -122.418324330264 (37.7760355203152, -122.418324330264)
454 251309 2 44 2111 15th Ave 2 1 1 1       3x3   5991606.081259999 2101026.68041 37.7485361329461 -122.471825260742 (37.7485361329461, -122.471825260742)
455 234501 3 3 2423 Market St 2 2 1 2     12 Width 8ft   6002117.5892 2105782.84009 37.7621980066439 -122.435816935712 (37.7621980066439, -122.435816935712)
456 23112 3 11 1448 Valencia St 1 1 1 2   03/26/1992 12:00:00 AM 20 3X3 Permit Number 779902 6006436.396269999 2101132.22455 37.74967287242389 -122.42054965793899 (37.7496728724239, -122.420549657939)
457 142162 2 84 490X Baker St 4 1 1 1     0 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
458 221750 2 26 275 Grattan St 2 1 2 1     11 Width 4ft   5997409.41415 2106414.31665 37.7636633116224 -122.45214620578699 (37.7636633116224, -122.452146205787)
Powered by Datasette · Query took 1.77ms · Data source: data.sfgov.org