sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1287 245764 2 141 157 Laidley St 1 1 1 1     38 Width 3ft Permit Number 779702 6004001.6074 2097411.86925 37.739320118017 -122.428704072653 (37.739320118017, -122.428704072653)
1737 182373 2 141 1534 36th Ave 2 1 1 1     6 Width 0ft   5984996.2741 2104755.1988 37.7583889515074 -122.49495641386801 (37.7583889515074, -122.494956413868)
2068 158899 2 141 253 Judson Ave 1 9 1 1     0 Width 0ft   5998481.355769999 2093479.93721 37.7282099959864 -122.447507621406 (37.7282099959864, -122.447507621406)
2252 252990 2 141 52 Pierce St 1 5 1 1       2x8   6002925.0 2108585.0 37.7699378868501 -122.433224642796 (37.7699378868501, -122.433224642796)
2958 93566 2 141 200 Cervantes Blvd 2 1 1 1     10 3x3   6000961.67566 2121419.55702 37.8050666921269 -122.440936588171 (37.8050666921269, -122.440936588171)
3033 253285 2 141 8245 Geary Blvd 1 2 1 1   08/15/2017 12:00:00 AM 3     5981372.0 2112274.0 37.7788205636315 -122.50804856364901 (37.7788205636315, -122.508048563649)
3170 208471 1 141 1175 Kirkham St 1 1 2 1   08/23/2017 12:00:00 AM 3 Width 2ft Permit Number 780657 5991201.16474 2105172.16858 37.7598951180952 -122.473527781682 (37.7598951180952, -122.473527781682)
3368 253427 2 141 2 09th Ave 5 1 1 1       3x3   5993083.0 2114893.0 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285)
3369 253425 2 141 2 09th Ave 3 1 1 1       3x3   5993083.0 2114893.0 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285)
3370 253423 2 141 2 09th Ave 1 1 1 1       3x3   5993083.0 2114893.0 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285)
3380 253426 2 141 2 09th Ave 4 1 1 1       3x3   5993083.0 2114893.0 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285)
3382 122965 2 141 98 09th Ave 4 2 1 1     5 Width 5ft   5993050.799269999 2114904.9128799997 37.786725565514004 -122.467838745487 (37.786725565514, -122.467838745487)
3577 253466 2 141 98X Marston Ave 5 9 1 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3787 65935 1 141 1343 Greenwich St 1 1 1 1   06/08/1990 12:00:00 AM 14   Permit Number 28954 6006463.24964 2119706.38252 37.800674552539604 -122.421775955514 (37.8006745525396, -122.421775955514)
4626 93565 2 141 200 Cervantes Blvd 1 1 1 1     10 3x3   6000974.0103 2121410.57303 37.8050427269948 -122.44089325793999 (37.8050427269948, -122.44089325794)
5256 253838 2 141 1458 46th Ave 1 1 1 1 1     5.5x4   5981900.0 2105162.0 37.759324170949604 -122.505694672765 (37.7593241709496, -122.505694672765)
6085 93568 2 141 200 Cervantes Blvd 4 1 1 1     10 3x3   6000935.9481 2121438.25936 37.8051165784228 -122.44102696373001 (37.8051165784228, -122.44102696373)
6655 20047 3 141 100 STAIRWAY52 3 1 1 2     12 10            
8287 47845 1 141 8250on Geary 47th Ave 1 1 1 1   06/14/2002 12:00:00 AM     Permit Number 45605          
8319 47848 1 141 8250on Geary 47th Ave 5 1 1 1   06/14/2002 12:00:00 AM     Permit Number 45605          
8820 93567 2 141 200 Cervantes Blvd 3 1 1 1     10 3x3   6000948.30119 2121430.16554 37.8050950585436 -122.440983633492 (37.8050950585436, -122.440983633492)
8871 93569 2 141 200 Cervantes Blvd 5 1 1 1     6 3x3   6000923.60214 2121446.70907 37.805139075870706 -122.441070294867 (37.8051390758707, -122.441070294867)
9702 104171 2 141 2607 DIAMOND ST 2 1 1 2     28 3x3   6002306.0 2096613.0 37.7370304975493 -122.43450961762501 (37.7370304975493, -122.434509617625)
9991 34375 1 141 157 Laidley St 1 1 1 1 1 07/14/1997 12:00:00 AM     Permit Number 38127 6003918.97921609 2097483.80532691 37.7395129612854 -122.428994891637 (37.7395129612854, -122.428994891637)
11441 25394 1 141 1045 Geneva Ave 1 1 1 1     60 4X4   6000938.80793 2088782.07415 37.715450859936 -122.43867564846902 (37.715450859936, -122.438675648469)
11858 111285 2 141 1 Baltimore Way 1 1 1 1     16 6x10   6003156.565119999 2086725.0907599998 37.709928747378505 -122.43086338266501 (37.7099287473785, -122.430863382665)
12078 47847 1 141 8250on Geary 47th Ave 6 1 1 1   06/14/2002 12:00:00 AM     Permit Number 45605          
12229 47849 1 141 8250on Geary 47th Ave 4 1 1 1   06/14/2002 12:00:00 AM     Permit Number 45605          
12714 47846 1 141 8250on Geary 47th Ave 2 1 1 1   06/14/2002 12:00:00 AM     Permit Number 45605          
13145 19899 3 141 100 STAIRWAY33 31 1 1 2     12 25ST            
14316 101784 2 141 1017 De Haro St 1 1 1 1     8 3x3   6012216.2726 2103633.6604400002 37.7568653093127 -122.40073821739901 (37.7568653093127, -122.400738217399)
15056 20048 3 141 100 STAIRWAY52 4 1 1 2     12 10            
16207 47844 1 141 8250on Geary 47th Ave 3 1 1 1   06/14/2002 12:00:00 AM     Permit Number 45605          
16947 29712 3 141 1594X Guerrero St 7 11 1 2   03/30/2006 12:00:00 AM 6     6005909.34325 2099821.5035900003 37.7460442149832 -122.422279116311 (37.7460442149832, -122.422279116311)
17074 29980 3 141 1622X Guerrero St 1 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005918.535069999 2099515.50587 37.7452045332674 -122.422225595834 (37.7452045332674, -122.422225595834)
17267 29992 3 141 681X San Jose Ave 7 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005877.58141 2099371.3233 37.7448063305595 -122.42235696431601 (37.7448063305595, -122.422356964316)
17337 30016 3 141 750X San Jose Ave 8 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005691.5289199995 2098774.02454 37.7431557868143 -122.422957855325 (37.7431557868143, -122.422957855325)
17549 5699 1 141 1569 Dolores St 1 1 1 1     90 6   6005313.38344 2099208.61144 37.7443277185515 -122.424296285742 (37.7443277185515, -122.424296285742)
17567 30007 3 141 750X San Jose Ave 3 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005678.3438 2098731.5578099997 37.7430384387857 -122.42300042833 (37.7430384387857, -122.42300042833)
17655 30017 3 141 750X San Jose Ave 9 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005697.924 2098794.2110900003 37.743211575362004 -122.42293717722201 (37.743211575362, -122.422937177222)
17674 5570 1 141 1027 Dolores St 1 1 1 1   01/16/1998 12:00:00 AM 8 3x3   6005145.15998 2102348.30914 37.752939104875296 -122.42510132197701 (37.7529391048753, -122.425101321977)
17696 5612 1 141 1165 Dolores St 1 1 1 1   03/10/2006 12:00:00 AM 3 3X3   6005185.4414800005 2101562.25197 37.750783049509295 -122.424906100762 (37.7507830495093, -122.424906100762)
17852 29994 3 141 681X San Jose Ave 9 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005883.229830001 2099389.42314 37.744856347235896 -122.422338718883 (37.7448563472359, -122.422338718883)
18031 96327 6 141 296 Randall St 1 9 1 1         Permit Number 767829 6003708.0 2097940.0 37.7407536226533 -122.429756895294 (37.7407536226533, -122.429756895294)
18184 89570 3 141 4935 Anza St 1 1 1 2   03/27/2008 12:00:00 AM 3 3x3   5983308.7395 2111690.5540299998 37.77733251999 -122.50130555865499 (37.77733251999, -122.501305558655)
18242 2325 3 141 2298X Bryant St 3 1 1 2   05/17/2004 12:00:00 AM 3 3X3   6009629.89674 2103998.72024 37.757723086282 -122.409708671514 (37.757723086282, -122.409708671514)
18460 29998 3 141 681X San Jose Ave 12 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005888.8207 2099404.7215 37.7448986684345 -122.42232047341601 (37.7448986684345, -122.422320473416)
18498 30012 3 141 738X San Jose Ave 4 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005734.30948 2098905.3013 37.743518656953 -122.422819258997 (37.743518656953, -122.422819258997)
18680 122353 2 141 155 Appleton Ave 4 1 1 1       3x3   6006071.0 2097171.0 37.7387756468895 -122.421531918974 (37.7387756468895, -122.421531918974)
18873 29989 3 141 681X San Jose Ave 4 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005863.98756 2099326.06351 37.74468129061479 -122.42240075410801 (37.7446812906148, -122.422400754108)
18978 15065 3 141 1X Minerva St 8 11 1 2     3 11   5996005.0253 2089004.0026599998 37.7157783129984 -122.45574493019501 (37.7157783129984, -122.455744930195)
19092 5696 3 141 1552 Dolores St 1 1 1 2   04/28/2008 12:00:00 AM 6 3x3   6005224.49905 2099276.7754 37.7445098618418 -122.42460847732201 (37.7445098618418, -122.424608477322)
19193 30011 3 141 795X San Jose Ave 3 11 1 2   01/02/2013 12:00:00 AM 3 3x3   6005625.43803 2098570.80228 37.7425940549807 -122.423171938039 (37.7425940549807, -122.423171938039)
19443 5712 3 141 1617 Dolores St 1 1 1 2     90 3X3   6005334.5075199995 2098914.22042 37.743520580615 -122.42420231019501 (37.743520580615, -122.424202310195)
19754 109729 1 141 4534 19th St 2 1 1 1 1 03/02/2015 12:00:00 AM 3 3x3 Permit Number 774273 6000926.1 2104675.0 37.7590883953394 -122.439858400707 (37.7590883953394, -122.439858400707)
19864 26510 3 141 2854 Harrison St 1 1 1 2     25 3X3   6008945.91858 2101850.94862 37.7517874366552 -122.41192238692301 (37.7517874366552, -122.411922386923)
19921 29988 3 141 681X San Jose Ave 3 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005860.9876 2099317.01753 37.7446562831756 -122.42241048477501 (37.7446562831756, -122.422410484775)
19973 29997 3 141 681X San Jose Ave 11 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005888.0743 2099402.63475 37.7448928965893 -122.422322906097 (37.7448928965893, -122.422322906097)
20201 30009 3 141 750X San Jose Ave 5 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005685.14822 2098754.53828 37.7431019219116 -122.422978533436 (37.7431019219116, -122.422978533436)
20445 29981 3 141 1622X Guerrero St 2 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005920.83177 2099524.56663 37.7452295416039 -122.422218297841 (37.7452295416039, -122.422218297841)
20463 5571 3 141 1033 Dolores St 1 1 1 2     12 3x3   6005142.90403 2102326.22826 37.7528783484711 -122.425107552489 (37.7528783484711, -122.425107552489)
20506 29709 3 141 1594X Guerrero St 4 11 1 2   03/30/2006 12:00:00 AM 6     6005913.75363 2099762.2133 37.745881666108204 -122.422259654058 (37.7458816661082, -122.422259654058)
20584 29990 3 141 681X San Jose Ave 5 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005867.00191 2099335.81011 37.7447082226084 -122.422391023449 (37.7447082226084, -122.422391023449)
20690 29987 3 141 688X San Jose Ave 2 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005801.21502 2099130.13322 37.7441397692444 -122.42260388936 (37.7441397692444, -122.42260388936)
20739 29982 3 141 1622X Guerrero St 3 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005921.74385 2099534.70656 37.7452574349955 -122.422215864289 (37.7452574349955, -122.422215864289)
20960 29713 3 141 1594X Guerrero St 8 11 1 2   03/30/2006 12:00:00 AM 3     6005909.200119999 2099831.66519 37.7460721083515 -122.422280333079 (37.7460721083515, -122.422280333079)
21484 30010 3 141 750X San Jose Ave 2 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005675.35784 2098723.21181 37.7430153540666 -122.423010159912 (37.7430153540666, -122.423010159912)
21551 30008 3 141 750X San Jose Ave 4 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005682.80795 2098743.3766799998 37.743071142629795 -122.422985832334 (37.7430711426298, -122.422985832334)
21719 29996 3 141 681X San Jose Ave 10 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005885.11752 2099395.68964 37.7448736601053 -122.422332636749 (37.7448736601053, -122.422332636749)
21854 30013 3 141 738X San Jose Ave 5 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005738.10231 2098921.33618 37.7435628991021 -122.42280728365101 (37.7435628991021, -122.422807283651)
22277 29993 3 141 681X San Jose Ave 8 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005880.60295 2099381.4202099997 37.7448342248263 -122.422347233647 (37.7448342248263, -122.422347233647)
22281 29985 3 141 688X San Jose Ave 1 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005799.980169999 2099121.4011 37.744115723156796 -122.422607538818 (37.7441157231568, -122.422607538818)
22915 189301 2 141 1345 20th St 3 9 1 1     2 Width 3ft   6013913.31542 2104750.9131 37.76002754956421 -122.394947417095 (37.7600275495642, -122.394947417095)
23036 11607 3 141 4300 Judah St 2 1 1 2     2 3X3   5981158.1048 2105571.7891 37.7604056423858 -122.50829087908899 (37.7604056423858, -122.508290879089)
23096 12683 3 141 1301 Lake St 4 1 1 2     15 3X3   5991446.199519999 2114750.37653 37.7862084655919 -122.473378948706 (37.7862084655919, -122.473378948706)
23180 11605 3 141 4300 Judah St 1 1 1 2     2 3X3   5981172.9444 2105571.7891 37.7604065168831 -122.50823955670201 (37.7604065168831, -122.508239556702)
23253 5092 3 141 2605 Diamond St 1 1 1 2     51     6002286.56903 2096627.94981 37.7370704432348 -122.434577867771 (37.7370704432348, -122.434577867771)
23391 126083 2 141 3651 Baker St 5 9 1 1     5 Width 5ft   5999112.99946 2121376.93874 37.804844210643104 -122.44733105300199 (37.8048442106431, -122.447331053002)
23442 187500 2 141 100 Walbridge St 6 7 1 1     2     6005130.65162 2086494.3835099998 37.709406927448796 -122.424024164397 (37.7094069274488, -122.424024164397)
23475 245699 2 141 689 Noe St 1 1 1 1     13 Width 3ft   6003071.60291 2104232.46466 37.757995194134395 -122.432406630082 (37.7579951941344, -122.432406630082)
23516 201490 2 141 404 Hawes St 3 9 1 1     8     6018801.89872 2095027.62617 37.7335999801502 -122.37736527181299 (37.7335999801502, -122.377365271813)
23577 118033 2 141 89 Shore View Ave 1 2 1 1     17 Width 6ft   5984120.82492 2112822.3596099997 37.780487786596204 -122.498579960483 (37.7804877865962, -122.498579960483)
23908 245647 2 141 478 Bartlett St 1 1 1 1     4 Width 3ft   6006778.49517 2100999.42527 37.749327509367106 -122.419357245036 (37.7493275093671, -122.419357245036)
23910 118018 2 141 492 37th Ave 2 2 1 1     5 Width 1ft   5984413.88926 2112528.9426700003 37.779699331346 -122.49754445899099 (37.779699331346, -122.497544458991)
24094 118130 2 141 3329 Balboa St 2 2 1 1     4 Width 3ft   5985237.75106 2111079.5821 37.775768059624504 -122.494587526681 (37.7757680596245, -122.494587526681)
24180 245677 2 141 4206 23rd St 1 1 1 1     36 Width 3ft   6001747.193080001 2102367.94443 37.7528004815642 -122.436853519485 (37.7528004815642, -122.436853519485)
24192 183253 2 141 1300 La Playa 2 1 1 1     4 Width 0ft   5980913.074 2106102.483 37.7618483320506 -122.50917772189 (37.7618483320506, -122.50917772189)
24304 175944 2 141 1764 Cayuga Ave 2 9 1 1     8 Width 8ft   5997944.4131 2088561.35887 37.7146740246601 -122.449009674469 (37.7146740246601, -122.449009674469)
24330 205383 2 141 64 Ventura Ave 1 2 1 1     6 Width 3ft   5994182.66644 2101796.2621 37.750797955763396 -122.46297136414101 (37.7507979557634, -122.462971364141)
24414 205283 2 141 200 Pacheco St 1 2 1 1     15 Width 6ft   5994526.48433 2100257.0572599997 37.7465914866063 -122.46167083296801 (37.7465914866063, -122.461670832968)
24542 38375 1 141 3809 Noriega St 1 1 1 1 1 08/03/1998 12:00:00 AM 2   Permit Number 40434 5982171.278 2102815.4467 37.7528971616744 -122.50458262013201 (37.7528971616744, -122.504582620132)
24740 182490 2 141 1560 36th Ave 2 1 1 1     3 Width 0ft   5985003.029 2104585.8759 37.7579244332823 -122.494920568176 (37.7579244332823, -122.494920568176)
24782 245521 2 141 5 Parnassus Ave 3 1 1 1     9 Width 4ft   5998664.3758 2106893.76883 37.765051575289604 -122.447840222145 (37.7650515752896, -122.447840222145)
24831 205461 2 141 18 Foerster St 2 9 1 1     24 Width 6ft   5998119.976480001 2093734.95335 37.728889551613705 -122.44877527875799 (37.7288895516137, -122.448775278758)
24964 205338 2 141 216 Ralston St 3 9 1 1     5 Width 5ft   5992219.15057 2089273.39944 37.716300015102796 -122.46885013342899 (37.7163000151028, -122.468850133429)
25031 126107 2 141 2520 Baker St 6 2 1 1     13 Width 4ft   5999698.94271 2117540.8900200003 37.794344910846206 -122.44502739999201 (37.7943449108462, -122.445027399992)
25035 175929 2 141 207 San Juan Ave 5 9 1 1     3 Width 2ft   6001163.218780001 2092286.63013 37.7250863447352 -122.438150888659 (37.7250863447352, -122.438150888659)
25100 205364 2 141 250 Magellan Ave 2 2 1 1     7 Width 4ft   5994743.5494800005 2100407.30657 37.747016525988705 -122.460931137866 (37.7470165259887, -122.460931137866)
25151 189343 2 141 1151 Fairfax Ave 1 1 1 1     4 Width 3ft   6017750.34235 2096562.27095 37.7377558246748 -122.38110750730499 (37.7377558246748, -122.381107507305)
25253 182913 2 141 2650 Sloat Blvd 5 1 1 1     4 Width 0ft   5982496.6705 2096518.7706 37.735627364936 -122.502991257405 (37.735627364936, -122.502991257405)
25300 117795 2 141 3755 Balboa St 1 2 1 1     8 Width 3ft   5983918.45231 2111030.33934 37.7755555482917 -122.499147602329 (37.7755555482917, -122.499147602329)
Powered by Datasette · Query took 2.448ms · Data source: data.sfgov.org