sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
6680 112268 2 43 1X Geary St 2 1 1 1                    
6704 112269 2 43 1X Geary St 3 1 1 1                    
10998 112267 2 43 1X Geary St 1 1 1 1                    
113029 117600 2 43 565 39TH AVE 1 1 1 1     10 3x3   5983700.0 2111975.0 37.7781364952795 -122.49997311443501 (37.7781364952795, -122.499973114435)
90516 20972 3 43 2002X Sunset Blvd 12 1 1 2     3 40   5984887.616570599 2101567.3225095 37.7496295616808 -122.49509712324499 (37.7496295616808, -122.495097123245)
95236 20974 3 43 2002X Sunset Blvd 14 1 1 2     3 40   5984887.616570599 2101567.3225095 37.7496295616808 -122.49509712324499 (37.7496295616808, -122.495097123245)
97048 20975 3 43 2002X Sunset Blvd 15 1 1 2     3 40   5984887.616570599 2101567.3225095 37.7496295616808 -122.49509712324499 (37.7496295616808, -122.495097123245)
81585 52592 1 43 327CALIFORNIA 25th Ave 1 1 1 1         Permit Number 48686 5988048.64326864 2113784.56845539 37.7833593060301 -122.48506257055 (37.7833593060301, -122.48506257055)
127656 94524 1 43 3322 Anza St 1 1 1 1       3x3 Permit Number 774668 5988381.0 2111924.0 37.7782700631784 -122.48377629744301 (37.7782700631784, -122.483776297443)
106122 117200 2 43 1321 23RD AVE 1 1 1 1     10 3x3   5988915.0 2106334.0 37.7629525336189 -122.481519510385 (37.7629525336189, -122.481519510385)
114563 9079 1 43 5625 Geary Blvd 1 1 1 1     6 3X3   5989525.4329 2112589.82108 37.7801647748824 -122.479866062567 (37.7801647748824, -122.479866062567)
96529 9076 1 43 5618 Geary Blvd 3 1 1 1     12 3x3   5989554.31102 2112758.21214 37.7806288074212 -122.479778486374 (37.7806288074212, -122.479778486374)
101186 9077 1 43 5618 Geary Blvd 4 1 1 1     12 3x3   5989554.31102 2112758.21214 37.7806288074212 -122.479778486374 (37.7806288074212, -122.479778486374)
95810 9071 1 43 5600 Geary Blvd 2 1 1 1   03/01/1990 12:00:00 AM 12 3X3   5989606.68558 2112715.06065 37.7805133679778 -122.479594141591 (37.7805133679778, -122.479594141591)
116898 9070 3 43 5600 Geary Blvd 1 1 1 2   03/01/1990 12:00:00 AM 12 3X3   5989606.68558 2112715.06065 37.7805133679778 -122.479594141591 (37.7805133679778, -122.479594141591)
65794 115992 2 43 438 20th Ave 1 1 1 1   07/27/2016 12:00:00 AM 3   Permit Number 778644 5989723.9 2112354.3 37.7795296278249 -122.47916224845301 (37.7795296278249, -122.479162248453)
78296 93145 2 43 1152 Clement St 3 1 1 1           5991985.0 2113459.0 37.7826938870859 -122.47142072749399 (37.7826938870859, -122.471420727494)
100058 93144 2 43 1152 Clement St 2 1 1 1   04/13/2016 12:00:00 AM 3     5991985.0 2113459.0 37.7826938870859 -122.47142072749399 (37.7826938870859, -122.471420727494)
112840 93146 2 43 1152 Clement St 4 1 1 1           5991985.0 2113459.0 37.7826938870859 -122.47142072749399 (37.7826938870859, -122.471420727494)
119954 26666 3 43 1015 Lake St 1 1 1 2     40 3X3   5992306.14573 2114757.6166 37.78627810348571 -122.47040431482401 (37.7862781034857, -122.470404314824)
93550 105290 2 43 330 11TH AVE   1 1 1     15 4x4   5992515.1 2113228.4 37.7820913739714 -122.469570031425 (37.7820913739714, -122.469570031425)
9804 59226 1 43 530 11th Ave 1 1 1 1   12/28/2016 12:00:00 AM 3   Permit Number 779363 5992552.44717 2111818.61025 37.7782226338783 -122.469338181035 (37.7782226338783, -122.469338181035)
1369 121635 2 43 506 11th Ave 1 1 1 1   05/11/2017 12:00:00 AM 3 3x3   5992560.0 2111978.0 37.778660711296794 -122.46932365779699 (37.7786607112968, -122.469323657797)
120949 12630 1 43 841 Lake St 2 1 1 1     40 3X3   5992831.38337 2114795.44702 37.7864123300728 -122.46858989794501 (37.7864123300728, -122.468589897945)
91008 120156 6 43 758 10th Ave 1 1 2 1     10     5992930.0 2110298.0 37.77406925887279 -122.467921468059 (37.7740692588728, -122.467921468059)
113361 54410 1 43 1248 09th Ave 1 1 1 1   06/20/1972 12:00:00 AM     Permit Number 10182 5993332.64911234 2106987.54521442 37.765002872173 -122.46628801063 (37.765002872173, -122.46628801063)
127180 111369 2 43 724 IRVING ST 1 1 1 1       3x3   5993485.0 2106687.0 37.7641864431876 -122.465739233402 (37.7641864431876, -122.465739233402)
76139 94058 2 43 1401X 08th Ave 1 1 1 1     6 3x3   5993648.0 2105942.0 37.7621502689837 -122.465121353228 (37.7621502689837, -122.465121353228)
121808 94059 2 43 1401X 08th Ave 2 1 1 1     6 3x3   5993648.0 2105942.0 37.7621502689837 -122.465121353228 (37.7621502689837, -122.465121353228)
112107 54742 1 43 1374 07th Ave 1 1 1 1   07/31/1972 12:00:00 AM   3x3 Permit Number 10588 5993980.75543943 2106156.09216002 37.7627572927027 -122.463986029849 (37.7627572927027, -122.463986029849)
101735 1685 3 43 452X Balboa St 1 1 1 2     20 3X3   5994164.03145 2111506.7878 37.7774594509207 -122.46374052558399 (37.7774594509207, -122.463740525584)
119250 103480 1 43 1247 06th Ave 2 1 1 1     12 5x5 Permit Number 31998 5994182.5 2107061.8 37.765255754741 -122.463353999562 (37.765255754741, -122.463353999562)
104013 54736 1 43 1247 06th Ave 1 1 1 1   07/19/1993 12:00:00 AM 12 5x5 Permit Number 31998 5994208.55249488 2107032.01090972 37.7651754625969 -122.463261729084 (37.7651754625969, -122.463261729084)
92438 33008 1 43 1311 06th Ave 1 1 1 1   11/05/1996 12:00:00 AM   6x4 Permit Number 37302 5994224.05093468 2106581.50911401 37.7639393951455 -122.463175433011 (37.7639393951455, -122.463175433011)
105308 25271 1 43 1800 Ocean Ave 4 1 1 1     6 2X2   5994503.82801 2092400.8361900002 37.725018937185 -122.461179802839 (37.725018937185, -122.461179802839)
110854 25270 1 43 1800 Ocean Ave 2 1 1 1     12 2X2   5994503.82801 2092400.8361900002 37.725018937185 -122.461179802839 (37.725018937185, -122.461179802839)
112191 25272 1 43 1800 Ocean Ave 5 1 1 1     6 2X2   5994503.82801 2092400.8361900002 37.725018937185 -122.461179802839 (37.725018937185, -122.461179802839)
120838 25273 1 43 1800 Ocean Ave 6 1 1 1     6 2X2   5994503.82801 2092400.8361900002 37.725018937185 -122.461179802839 (37.725018937185, -122.461179802839)
98245 1679 3 43 350X Balboa St 1 1 1 2     12 3X3   5994545.07613 2111468.1594 37.7773753373943 -122.462419573309 (37.7773753373943, -122.462419573309)
125376 97561 2 43 1251X 04th Ave 1 5 1 1       3x3   5994791.4 2106981.0 37.765068960260294 -122.461242116604 (37.7650689602603, -122.461242116604)
143031 108561 2 43 141 02nd Ave 2 1 1 1       3x3   5995170.0 2114629.2 37.786090674815604 -122.460486880145 (37.7860906748156, -122.460486880145)
94791 119280 2 43 95 Miramar Ave 2 1 1 1       3x3   5995293.0 2090512.0 37.7198780283713 -122.458315087488 (37.7198780283713, -122.458315087488)
114487 119279 2 43 95 Miramar Ave 1 1 1 1       3x3   5995293.0 2090512.0 37.7198780283713 -122.458315087488 (37.7198780283713, -122.458315087488)
115348 106967 2 43 1225 02ND AVE   1 1 1           5995419.1 2107212.6 37.7657409782079 -122.45908784262899 (37.7657409782079, -122.459087842629)
82045 86740 1 43 1275 02nd Ave   1 1 1         Permit Number 49708 5995441.8 2106872.8 37.7648092803065 -122.458984723243 (37.7648092803065, -122.458984723243)
77740 1442 3 43 144 Arguello Blvd 1 1 1 2     35 3X3   5995540.31731 2115189.6989 37.7876509503315 -122.459246293031 (37.7876509503315, -122.459246293031)
86675 121337 1 43 44 Hugo St 2 1 1 1       4x4   5995656.55399656 2107084.69972772 37.765403444810204 -122.45825728758899 (37.7654034448102, -122.458257287589)
118402 54199 1 43 44 Hugo St 1 1 1 1   07/10/1972 12:00:00 AM   4x4 Permit Number 9937 5995656.55399656 2107084.69972772 37.765403444810204 -122.45825728758899 (37.7654034448102, -122.458257287589)
116674 113279 1 43 2 Hugo St 2 1 1 1       5x5   5995790.34429445 2107089.36315796 37.76542393643229 -122.457794878244 (37.7654239364323, -122.457794878244)
92293 106915 1 43 3832 Jackson St 2 1 1 1         Permit Number 772728 5995876.045419999 2115884.62189 37.7895783172049 -122.458135060161 (37.7895783172049, -122.458135060161)
103988 106916 1 43 3832 Jackson St 3 1 1 1   05/01/2015 12:00:00 AM 3     5995876.045419999 2115884.62189 37.7895783172049 -122.458135060161 (37.7895783172049, -122.458135060161)
110441 28300 3 43 100 Broad St 2 1 1 2     13 3X3   5995887.0 2088090.0 37.713261901345 -122.45608683538099 (37.713261901345, -122.456086835381)
90900 96407 1 43 3828 Jackson St 2 1 1 1           5995910.0 2115869.0 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618)
92260 96411 1 43 3828 Jackson St 6 1 1 1   02/10/2012 12:00:00 AM     Permit Number 768662 5995910.0 2115869.0 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618)
94440 96410 1 43 3828 Jackson St 5 1 1 1         Permit Number 767718 5995910.0 2115869.0 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618)
103095 96408 1 43 3828 Jackson St 3 1 1 1           5995910.0 2115869.0 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618)
142605 96409 1 43 3828 Jackson St 4 1 1 1           5995910.0 2115869.0 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618)
145603 97278 1 43 60 Palm Ave 2 1 1 1       3x3 Permit Number 768156 5995934.7 2114107.9 37.7847032866401 -122.45780350364599 (37.7847032866401, -122.457803503646)
101501 117650 2 43 79 ROSSI AVE 1 1 1 1     22 3x3   5996337.0 2111626.0 37.7779117506286 -122.456232175702 (37.7779117506286, -122.456232175702)
96381 117649 2 43 82 ROSSI AVE 1 1 1 1     18 3x3   5996392.0 2111672.0 37.778041211542 -122.456045238979 (37.778041211542, -122.456045238979)
99092 117647 2 43 86 ROSSI AVE 1 1 1 1     24 3x3   5996396.0 2111643.0 37.777961814765504 -122.456029304513 (37.7779618147655, -122.456029304513)
108128 117648 2 43 86 ROSSI AVE 2 1 1 1     24 3x3   5996396.0 2111643.0 37.777961814765504 -122.456029304513 (37.7779618147655, -122.456029304513)
49591 110708 2 43 2999X Turk St 14 1 1 1       3x3   5996638.0 2111487.0 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531)
77420 110696 2 43 2999X Turk St 2 1 1 1       3x3   5996638.0 2111487.0 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531)
99925 110704 2 43 2999X Turk St 10 1 1 1       3x3   5996638.0 2111487.0 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531)
110742 111378 2 43 2999X Turk St 4 1 1 1       3x3   5996638.0 2111487.0 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531)
125637 110712 2 43 2999X Turk St 18 1 1 1       3x3   5996638.0 2111487.0 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531)
127253 110710 2 43 2999X Turk St 16 1 1 1       3x3   5996638.0 2111487.0 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531)
140865 110702 2 43 2999X Turk St 8 1 1 1       3x3   5996638.0 2111487.0 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531)
141223 110706 2 43 2999X Turk St 12 1 1 1       3x3   5996638.0 2111487.0 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531)
83845 8762 3 43 3360 Geary Blvd 1 1 1 2     12 3X3   5996663.11405 2112992.0555 37.7816812935668 -122.455202782638 (37.7816812935668, -122.455202782638)
87220 8763 3 43 3360 Geary Blvd 2 1 1 2     12 3X3   5996663.11405 2112992.0555 37.7816812935668 -122.455202782638 (37.7816812935668, -122.455202782638)
97020 8767 3 43 3360 Geary Blvd 6 1 1 2     12 3X3   5996663.11405 2112992.0555 37.7816812935668 -122.455202782638 (37.7816812935668, -122.455202782638)
117236 8764 3 43 3360 Geary Blvd 3 1 1 2     12 3X3   5996663.11405 2112992.0555 37.7816812935668 -122.455202782638 (37.7816812935668, -122.455202782638)
120064 8766 3 43 3360 Geary Blvd 5 1 1 2     12 3X3   5996663.11405 2112992.0555 37.7816812935668 -122.455202782638 (37.7816812935668, -122.455202782638)
143635 8765 3 43 3360 Geary Blvd 4 1 1 2     12 3X3   5996663.11405 2112992.0555 37.7816812935668 -122.455202782638 (37.7816812935668, -122.455202782638)
144710 8768 3 43 3360 Geary Blvd 7 1 1 2     12 3X3   5996663.11405 2112992.0555 37.7816812935668 -122.455202782638 (37.7816812935668, -122.455202782638)
106931 110698 2 43 2999X Turk St 20 1 1 1       3x3   5996770.5 2111189.3 37.7767375616272 -122.454700997037 (37.7767375616272, -122.454700997037)
127933 92818 1 43 95 Burlwood Dr 1 1 1 1   11/12/2009 12:00:00 AM   3x3 Permit Number 53027 5996883.0 2096019.0 37.7350901820695 -122.453216393363 (37.7350901820695, -122.453216393363)
82477 20090 1 43 2075X Oak St 1 1 1 1     18 3x3   5997085.68869 2109091.58753 37.7709958615587 -122.45345917871401 (37.7709958615587, -122.453459178714)
86827 20091 1 43 2075X Oak St 2 1 1 1     18 3x3   5997085.68869 2109091.58753 37.7709958615587 -122.45345917871401 (37.7709958615587, -122.453459178714)
78954 113001 2 43 700x STANYAN ST 2 1 1 1       3x3   5997124.0 2108268.0 37.768736698354004 -122.453267191941 (37.768736698354, -122.453267191941)
83223 113004 2 43 700x STANYAN ST 5 1 1 1       3x3   5997124.0 2108268.0 37.768736698354004 -122.453267191941 (37.768736698354, -122.453267191941)
84432 113005 2 43 700x STANYAN ST 6 1 1 1       3x3   5997124.0 2108268.0 37.768736698354004 -122.453267191941 (37.768736698354, -122.453267191941)
99696 113009 2 43 700x STANYAN ST 10 1 1 1       3x3   5997124.0 2108268.0 37.768736698354004 -122.453267191941 (37.768736698354, -122.453267191941)
103839 113010 2 43 700x STANYAN ST 11 1 1 1       3x3   5997124.0 2108268.0 37.768736698354004 -122.453267191941 (37.768736698354, -122.453267191941)
105624 113002 2 43 700x STANYAN ST 3 1 1 1       3x3   5997124.0 2108268.0 37.768736698354004 -122.453267191941 (37.768736698354, -122.453267191941)
120558 113000 2 43 700x STANYAN ST 1 1 1 1       3x3   5997124.0 2108268.0 37.768736698354004 -122.453267191941 (37.768736698354, -122.453267191941)
139973 113003 2 43 700x STANYAN ST 4 1 1 1       3x3   5997124.0 2108268.0 37.768736698354004 -122.453267191941 (37.768736698354, -122.453267191941)
140079 113008 2 43 700x STANYAN ST 9 1 1 1       3x3   5997124.0 2108268.0 37.768736698354004 -122.453267191941 (37.768736698354, -122.453267191941)
141838 113006 2 43 700x STANYAN ST 7 1 1 1       3x3   5997124.0 2108268.0 37.768736698354004 -122.453267191941 (37.768736698354, -122.453267191941)
143541 113007 2 43 700x STANYAN ST 8 1 1 1       3x3   5997124.0 2108268.0 37.768736698354004 -122.453267191941 (37.768736698354, -122.453267191941)
99340 113158 2 43 1104 STANYAN ST 1 1 1 1       3x3   5997339.0 2106686.0 37.764405251212004 -122.45240935159799 (37.764405251212, -122.452409351598)
88288 102825 2 43 2001X Baker St 2 1 1 1       3x3   5997438.0 2109144.0 37.77115996155629 -122.45224431217899 (37.7711599615563, -122.452244312179)
111842 102824 2 43 2001X Baker St 1 1 1 1       3x3   5997438.0 2109144.0 37.77115996155629 -122.45224431217899 (37.7711599615563, -122.452244312179)
125020 102826 2 43 2001X Baker St 3 1 1 1       3x3   5997438.0 2109144.0 37.77115996155629 -122.45224431217899 (37.7711599615563, -122.452244312179)
145245 94600 1 43 1709 Waller St 2 1 1 1           5997540.0 2108126.0 37.7683706375079 -122.451818041345 (37.7683706375079, -122.451818041345)
125237 52226 1 43 423 Locust St 2 1 1 1   11/18/2005 12:00:00 AM     Permit Number 48405 5997634.34727934 2115023.86499621 37.787315780851294 -122.451989424725 (37.7873157808513, -122.451989424725)
128062 17122 1 43 1931 Oak St 4 1 1 1     18 3X3   5997743.8504099995 2109170.01524 37.7712489089965 -122.45118824582701 (37.7712489089965, -122.451188245827)
141432 112971 2 43 601x COLE ST 1 1 1 1     14 3x3   5997795.0 2108483.0 37.7693654697431 -122.450961770246 (37.7693654697431, -122.450961770246)
96621 17118 1 43 1907 Oak St 2 1 1 1     12 3x3   5997842.841030001 2109183.73864 37.771292257165896 -122.4508468245 (37.7712922571659, -122.4508468245)
Powered by Datasette · Query took 14.78ms · Data source: data.sfgov.org