sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
21616 25457 1 37 100 Randolph St 2 1 1 3   12/10/1997 12:00:00 AM 6 3X3   5993681.7949 2088543.8714 37.7143812997511 -122.463741645146 (37.7143812997511, -122.463741645146)
21638 18577 1 37 100 Randolph St 1 1 1 3   10/12/1998 12:00:00 AM 6 3X3   5993712.2633 2088544.8235 37.7143856696584 -122.46363640417201 (37.7143856696584, -122.463636404172)
14183 7380 1 44 1000X Folsom St 4 1 1 3     45 3X3   6010853.2469 2111475.4662 37.7783210049209 -122.40600450833401 (37.7783210049209, -122.406004508334)
15454 7377 1 44 1000X Folsom St 1 1 1 3     45 3X3   6010910.3764 2111530.9317 37.7784764953194 -122.405810783213 (37.7784764953194, -122.405810783213)
15604 7382 1 44 1000X Folsom St 6 1 1 3     60 3X3   6010814.6984 2111439.6909 37.7782206182135 -122.406135341461 (37.7782206182135, -122.406135341461)
15693 7378 1 44 1000X Folsom St 2 1 1 3     45 3X3   6010884.8623 2111505.4176 37.7784050126686 -122.40589724881 (37.7784050126686, -122.40589724881)
16764 7379 1 44 1000X Folsom St 3 1 1 3     45 3X3   6010870.4412 2111489.3325 37.7783600402028 -122.40594600363998 (37.7783600402028, -122.40594600364)
78664 13380 1 12 1000X Mansell St 6 1 1 3     3 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
86895 13384 1 108 1000X Mansell St 10 1 1 3     12 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
92208 13378 1 12 1000X Mansell St 4 1 1 3   01/13/2000 12:00:00 AM 3 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
108952 13376 1 2 1000X Mansell St 2 1 1 3     6 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
109944 13381 1 2 1000X Mansell St 7 1 1 3     18 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
113947 13383 1 2 1000X Mansell St 9 1 1 3     18 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
119188 13379 1 12 1000X Mansell St 5 1 1 3     3 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
126625 13385 1 12 1000X Mansell St 11 1 1 3     3 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
31 22614 1 5 1001 Turk St 5 1 1 3     24 3x5   6005426.7391 2112695.1691 37.781365013820206 -122.424863625752 (37.7813650138202, -122.424863625752)
85 22613 1 5 1001 Turk St 4 1 1 3     24 3x5   6005358.7073 2112686.5825 37.7813375942673 -122.42509837168001 (37.7813375942673, -122.42509837168)
7925 22616 1 37 1001 Turk St 7 1 1 3     24 3x5   6005581.297 2112717.6262 37.7814354041528 -122.424330527926 (37.7814354041528, -122.424330527926)
8575 22617 1 5 1001 Turk St 8 1 1 3   03/25/1997 12:00:00 AM 6 3x5   6005634.7978 2112724.8918 37.781458374599794 -122.424145957729 (37.7814583745998, -122.424145957729)
88826 22610 1 5 1001 Turk St 1 1 1 3     30 3X5   6005224.1346872 2112659.8569034003 37.7812566094766 -122.425562024881 (37.7812566094766, -122.425562024881)
120636 22615 1 5 1001 Turk St 6 1 1 3     24 3x5   6005224.1346872 2112659.8569034003 37.7812566094766 -122.425562024881 (37.7812566094766, -122.425562024881)
126289 22618 1 5 1001 Turk St 9 1 1 3     24 3x5   6005224.1346872 2112659.8569034003 37.7812566094766 -122.425562024881 (37.7812566094766, -122.425562024881)
87911 29065 1 6 1001X McAllister St 1 1 1 3   12/15/2005 12:00:00 AM 3 3x3   6004375.703483 2111849.9138356997 37.7789847305516 -122.42843943238 (37.7789847305516, -122.42843943238)
113978 29066 1 6 1001X McAllister St 2 1 1 3   12/15/2005 12:00:00 AM 3 3x3   6004375.703483 2111849.9138356997 37.7789847305516 -122.42843943238 (37.7789847305516, -122.42843943238)
54664 29069 1 101 1002X Laguna St 3 1 1 3   12/15/2005 12:00:00 AM 15 3x3   6004818.3149515 2112301.2204093 37.780248943687205 -122.4269404119 (37.7802489436872, -122.4269404119)
78978 87642 1 20 1002X Laguna St 1 1 1 3           6004813.344433 2112300.6630169996 37.7802471321724 -122.42695756751101 (37.7802471321724, -122.426957567511)
91746 87641 1 101 1002X Laguna St 4 1 1 3           6004813.344433 2112300.6630169996 37.7802471321724 -122.42695756751101 (37.7802471321724, -122.426957567511)
107812 87643 1 20 1002X Laguna St 2 1 1 3           6004813.344433 2112300.6630169996 37.7802471321724 -122.42695756751101 (37.7802471321724, -122.426957567511)
126681 10586 1 43 1050X Harrison St 4 1 1 3     75 3X3   6011036.2882597 2110765.2479161 37.7763811461579 -122.40532126913901 (37.7763811461579, -122.405321269139)
115377 29070 1 101 1050X Laguna St 1 1 1 3   12/15/2005 12:00:00 AM 3 3x3   6004796.752563099 2112456.6816498 37.7806745826486 -122.427026081915 (37.7806745826486, -122.427026081915)
118030 29072 1 101 1050X Laguna St 3 1 1 3   12/15/2005 12:00:00 AM 3 3x3   6004796.752563099 2112456.6816498 37.7806745826486 -122.427026081915 (37.7806745826486, -122.427026081915)
127866 29071 1 101 1050X Laguna St 2 1 1 3   12/15/2005 12:00:00 AM 3 3x3   6004796.752563099 2112456.6816498 37.7806745826486 -122.427026081915 (37.7806745826486, -122.427026081915)
146163 29073 1 101 1050X Laguna St 4 1 1 3   12/15/2005 12:00:00 AM 3 3x3   6004796.752563099 2112456.6816498 37.7806745826486 -122.427026081915 (37.7806745826486, -122.427026081915)
81054 2804 1 15 1070X California St 1 1 1 3     50 3X3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
88529 2808 1 15 1070X California St 5 1 1 3     50 3x3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
109159 2806 1 15 1070X California St 3 1 1 3     45 3X3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
115677 2805 1 15 1070X California St 2 1 1 3     65 3X3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
126954 2807 1 15 1070X California St 4 1 1 3     45 3X3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
139043 2809 1 15 1070X California St 6 1 1 3     35 3X3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415)
100807 29067 1 101 1091X Turk St 1 1 1 3   12/15/2005 12:00:00 AM 3 3x3   6004816.84954 2112603.0518286 37.781077615403596 -122.426966984587 (37.7810776154036, -122.426966984587)
128333 29068 1 101 1091X Turk St 2 1 1 3   12/15/2005 12:00:00 AM 3 3x3   6004816.84954 2112603.0518286 37.781077615403596 -122.426966984587 (37.7810776154036, -122.426966984587)
12296 19104 1 21 10X Mansell St 2 1 1 3   03/29/2007 12:00:00 AM 3 4X30   6011705.43586 2090789.4617400002 37.721569360619604 -122.40160216911 (37.7215693606196, -122.40160216911)
2010 142062 1 55 1100 Golden Gate Ave 3 1 1 3   01/02/2014 12:00:00 AM 10 Width 0ft Permit Number 771276 6004214.4178 2112228.4 37.780014831771 -122.429024376887 (37.780014831771, -122.429024376887)
2525 9534 1 17 1100X Golden Gate Ave 2 1 1 3   01/02/2014 12:00:00 AM 6 3X3 Permit Number 771276 6004154.8546 2112220.8365 37.779990692526 -122.42922989330201 (37.779990692526, -122.429229893302)
3190 9537 1 25 1100X Golden Gate Ave 5 1 1 3   05/14/1992 12:00:00 AM 3 3X3   6004100.4915 2112210.9093 37.779960357201205 -122.429417251502 (37.7799603572012, -122.429417251502)
5025 9541 1 17 1100X Golden Gate Ave 9 1 1 3   01/02/2014 12:00:00 AM 3 3X3 Permit Number 771276 6003998.856000001 2112198.1457 37.7799195567604 -122.429767943463 (37.7799195567604, -122.429767943463)
7440 9542 1 50 1100X Golden Gate Ave 10 1 1 3   03/31/2000 12:00:00 AM 3 3X3   6003977.1107 2112193.8912 37.7799066435706 -122.429842866574 (37.7799066435706, -122.429842866574)
7827 9544 1 50 1100X Golden Gate Ave 12 1 1 3     6 3X3   6003937.8747 2112189.6367 37.7798927397998 -122.429978297745 (37.7798927397998, -122.429978297745)
7831 9536 1 25 1100X Golden Gate Ave 4 1 1 3   10/14/1994 12:00:00 AM 3 3X3   6004118.455 2112215.6365 37.779974353933 -122.42935544491999 (37.779974353933, -122.42935544492)
8608 9533 1 25 1100X Golden Gate Ave 1 1 1 3     6 3X3   6004176.1272 2112221.7819 37.7799944925987 -122.429156369266 (37.7799944925987, -122.429156369266)
8706 9539 1 26 1100X Golden Gate Ave 7 1 1 3   03/31/2000 12:00:00 AM 3 3X3   6004035.7284 2112200.9821 37.779929432705 -122.429640587781 (37.779929432705, -122.429640587781)
99504 9535 1 17 1100X Golden Gate Ave 3 1 1 3   01/02/2014 12:00:00 AM 12 3X3 Permit Number 771276 6004321.7721315995 2112240.3684222 37.7800537702914 -122.428653843346 (37.7800537702914, -122.428653843346)
100247 9546 1 50 1100X Golden Gate Ave 14 1 1 3   10/14/1994 12:00:00 AM 3 3X3   6004321.7721315995 2112240.3684222 37.7800537702914 -122.428653843346 (37.7800537702914, -122.428653843346)
112928 9545 1 50 1100X Golden Gate Ave 13 1 1 3     12 3X3   6004321.7721315995 2112240.3684222 37.7800537702914 -122.428653843346 (37.7800537702914, -122.428653843346)
139901 9540 1 25 1100X Golden Gate Ave 8 1 1 3   10/14/1994 12:00:00 AM 3 3X3   6004321.7721315995 2112240.3684222 37.7800537702914 -122.428653843346 (37.7800537702914, -122.428653843346)
143168 9547 1 50 1100X Golden Gate Ave 15 1 1 3   05/14/1992 12:00:00 AM 3 3X3   6004321.7721315995 2112240.3684222 37.7800537702914 -122.428653843346 (37.7800537702914, -122.428653843346)
630 20157 1 26 1100X Steiner St 2 1 1 3     18 4X4   6002895.0285 2112125.5503 37.7796576600117 -122.433581380876 (37.7796576600117, -122.433581380876)
7614 20156 1 26 1100X Steiner St 1 1 1 3     18 4X4   6002897.8994 2112109.7603 37.7796144675148 -122.43357032043899 (37.7796144675148, -122.433570320439)
93863 94301 6 101 1150X Fillmore St 5 5 1 3           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156)
101234 94303 6 43 1150X Fillmore St 6 5 1 3           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156)
102570 94295 6 43 1150X Fillmore St 2 5 1 3           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156)
103966 94293 6 43 1150X Fillmore St 1 5 1 3           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156)
107857 94299 6 101 1150X Fillmore St 4 5 1 3           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156)
123205 94297 6 101 1150X Fillmore St 3 5 1 3           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156)
84190 113977 2 225 1180 STANYAN ST 2 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
98380 113980 2 225 1180 STANYAN ST 5 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
120849 113976 2 225 1180 STANYAN ST 1 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
128979 113978 2 225 1180 STANYAN ST 3 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
142159 113981 2 225 1180 STANYAN ST 6 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
38128 88409 3 18 1199 Mason St 3 1 1 3   08/02/2012 12:00:00 AM 4 3x3 Permit Number 769129 6009413.9789 2117291.03714 37.7942085637169 -122.41139444529 (37.7942085637169, -122.41139444529)
44141 88407 3 18 1199 Mason St 1 1 1 3   08/02/2012 12:00:00 AM 4 3x3 Permit Number 769129 6009407.88363 2117347.72867 37.7943638829406 -122.411419542685 (37.7943638829406, -122.411419542685)
66520 100031 3 18 1199 Mason St 4 1 1 3   08/02/2012 12:00:00 AM 4 3x3 Permit Number 769129 6009418.42249 2117262.251 37.7941297732341 -122.411377035334 (37.7941297732341, -122.411377035334)
120980 100033 3 18 1199 Mason St 1 1 1 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
124487 100032 3 18 1199 Mason St 5 1 1 3   08/02/2012 12:00:00 AM   3x3 Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
182553 88408 3 18 1199 Mason St 2 1 1 3   08/02/2012 12:00:00 AM 5 3x3 Permit Number 769129 6009412.43491 2117319.72378 37.794287243625604 -122.411401815264 (37.7942872436256, -122.411401815264)
88615 100034 3 18 1199@Washington Mason St 2 1 1 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
112616 100037 3 18 1199@Washington Mason St 5 1 1 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
116126 100035 3 18 1199@Washington Mason St 3 1 1 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
144094 100036 3 18 1199@Washington Mason St 4 1 1 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
10993 764 1 5 1200X 37th Ave 1 1 1 3     12 3   5984614.2914 2106873.7688 37.76418358274471 -122.496433785178 (37.7641835827447, -122.496433785178)
104399 765 1 176 1200X 37th Ave 2 1 1 3     24 3   5984609.996333099 2107018.7644647 37.764581448379396 -122.496459340328 (37.7645814483794, -122.496459340328)
34305 20466 1 2 1202X Sunset Blvd 5 1 1 3     12 10   5984687.1705981 2107256.1433531996 37.7652377447603 -122.49620993463101 (37.7652377447603, -122.496209934631)
80523 20465 1 2 1202X Sunset Blvd 4 1 1 3     12 10   5984687.1705981 2107256.1433531996 37.7652377447603 -122.49620993463101 (37.7652377447603, -122.496209934631)
100327 20463 1 2 1202X Sunset Blvd 2 1 1 3     12 10   5984687.1705981 2107256.1433531996 37.7652377447603 -122.49620993463101 (37.7652377447603, -122.496209934631)
105704 20464 1 2 1202X Sunset Blvd 3 1 1 3   06/05/1997 12:00:00 AM 3 10   5984687.1705981 2107256.1433531996 37.7652377447603 -122.49620993463101 (37.7652377447603, -122.496209934631)
112463 20462 1 2 1202X Sunset Blvd 1 1 1 3     12 10   5984687.1705981 2107256.1433531996 37.7652377447603 -122.49620993463101 (37.7652377447603, -122.496209934631)
78402 20478 1 203 1203X Sunset Blvd 12 1 1 3     24 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
80842 20504 1 15 1203X Sunset Blvd 13 1 1 3   03/02/1991 12:00:00 AM 18 10   5984781.8902056 2107224.2505442 37.7651557239541 -122.495879974111 (37.7651557239541, -122.495879974111)
81048 20479 1 47 1203X Sunset Blvd 16 1 1 3     24 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
82157 20474 1 47 1203X Sunset Blvd 8 1 1 3     48 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
91646 20468 1 47 1203X Sunset Blvd 2 1 1 3     48 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
93970 20470 1 47 1203X Sunset Blvd 4 1 1 3     12 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
95715 20475 1 5 1203X Sunset Blvd 9 1 1 3     12 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
98213 20471 1 129 1203X Sunset Blvd 5 1 1 3     12 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
107129 20472 1 129 1203X Sunset Blvd 6 1 1 3     12 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
107253 20476 1 15 1203X Sunset Blvd 10 1 1 3     12 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
113448 20473 1 129 1203X Sunset Blvd 7 1 1 3     12 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
115969 20467 1 15 1203X Sunset Blvd 1 1 1 3     12 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
123025 20477 1 5 1203X Sunset Blvd 11 1 1 3     6 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
146051 20469 1 15 1203X Sunset Blvd 3 1 1 3     12 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617)
24419 20488 1 47 1204 Sunset Blvd 9 1 1 3     6 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
Powered by Datasette · Query took 8.981ms · Data source: data.sfgov.org