sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
107866 112769 6 1 1X HOWTH ST 1 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
111205 112771 6 1 1X HOWTH ST 3 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
111811 112770 6 1 1X HOWTH ST 2 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
112482 112773 6 1 1X HOWTH ST 5 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
115212 112774 6 1 1X HOWTH ST 6 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
121815 112772 6 1 1X HOWTH ST 4 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
3811 177743 6 2 401 Ocean Ave 4 9 1 6     37     5998700.41574 2091522.98281 37.722849171448395 -122.446609585371 (37.7228491714484, -122.446609585371)
1027 251426 6 3 5020 Diamond Heights Blvd 1 9 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
3147 253098 6 3 1290 Portola Dr 2 9 1 2   08/22/2017 12:00:00 AM 3 3x3   5994035.0 2097938.0 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736)
3158 253097 6 3 1290 Portola Dr 1 9 1 1 4 08/22/2017 12:00:00 AM 3 3x3   5994035.0 2097938.0 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736)
3799 178336 6 3 401 Ocean Ave 2 9 1 6     29 Width 8ft   5998664.9682 2091522.93582 37.722847017548204 -122.44673211618999 (37.7228470175482, -122.44673211619)
3803 178335 6 3 401 Ocean Ave 1 9 1 6     33 Width 8ft   5998656.04486 2091523.1214700001 37.72284701755029 -122.44676297552601 (37.7228470175503, -122.446762975526)
3818 178337 6 3 401 Ocean Ave 3 9 1 6     29     5998676.28102 2091524.0079700002 37.7228506076618 -122.44669308741301 (37.7228506076618, -122.446693087413)
4659 253652 6 3 131 Font Blvd 2 9 1 1       10x10   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
10208 173903 6 3 675 Corbett Ave 1 9 1 1           5999984.0 2103563.0 37.7559814441149 -122.44303676104799 (37.7559814441149, -122.443036761048)
79699 110954 6 3 126X Mendell St 1 9 1 1   05/12/2015 12:00:00 AM 3     6017060.745069999 2098543.2218400002 37.74315702656929 -122.38362967653299 (37.7431570265693, -122.383629676533)
88130 98104 6 3 1@Carl Irving St 8 9 1 1     15     5995817.2 2106753.3 37.7645027364821 -122.45767767256001 (37.7645027364821, -122.45767767256)
96813 112924 6 3 2X Noe St   9 1 1           6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
111177 110952 6 3 220 Newhall St 8 9 1 1   05/12/2015 12:00:00 AM 3     6016803.8 2098347.9 37.7426065069695 -122.38450453105301 (37.7426065069695, -122.384504531053)
111635 110951 6 3 220 Newhall St 1 9 1 1   05/12/2015 12:00:00 AM 3     6016803.8 2098347.9 37.7426065069695 -122.38450453105301 (37.7426065069695, -122.384504531053)
112127 110953 6 3 220 Newhall St 10 9 1 1   05/12/2015 12:00:00 AM 3     6016803.8 2098347.9 37.7426065069695 -122.38450453105301 (37.7426065069695, -122.384504531053)
118196 102589 6 3 5157 Diamond Heights Blvd 1 9 1 1     8     6000788.8 2100195.2 37.7467801300642 -122.440012028415 (37.7467801300642, -122.440012028415)
122346 87242 6 3 4131 Geary Blvd 1 9 1 1         Permit Number 50271 5994116.9 2112250.5 37.779498769084604 -122.46395756623998 (37.7794987690846, -122.46395756624)
122520 100850 6 3 1 Estero Ave 1 9 1 1           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695)
79584 116089 6 5 98x WOODWARD ST 3 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
81189 98546 6 5 555@Rio Teresita Blvd 2 9 1 1           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448)
91700 95229 6 5 1@Carl Irving St 5 9 1 1   11/16/2010 12:00:00 AM 15     5995817.2 2106753.3 37.7645027364821 -122.45767767256001 (37.7645027364821, -122.45767767256)
103243 116088 6 5 98x WOODWARD ST 2 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
104669 95231 6 5 1@Carl Irving St 10 9 1 1   11/16/2010 12:00:00 AM       5995817.2 2106753.3 37.7645027364821 -122.45767767256001 (37.7645027364821, -122.45767767256)
107871 116087 6 5 98x WOODWARD ST 1 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
125535 116090 6 5 98x WOODWARD ST 4 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
117806 110559 6 15 320x FULTON ST 1 9 1 1       10x36   6006080.0 2112015.0 37.7795343118474 -122.422555311635 (37.7795343118474, -122.422555311635)
119616 110560 6 15 320x FULTON ST 2 9 1 1       10x36   6006080.0 2112015.0 37.7795343118474 -122.422555311635 (37.7795343118474, -122.422555311635)
150859 106257 6 15 1900X 18th St 3 9 1 1     13   Permit Number 770844 6011994.4738300005 2105627.58235 37.762327804017296 -122.401645425613 (37.7623278040173, -122.401645425613)
179146 106256 6 15 1900X 18th St 2 9 1 1     15   Permit Number 770844 6012014.62334 2105627.65597 37.7623291305193 -122.401575740746 (37.7623291305193, -122.401575740746)
2059 173596 6 17 200 Howard St 1 9 1 1       3x3 Permit Number 779179 6014439.0 2115766.0 37.790301726009204 -122.393900378517 (37.7903017260092, -122.393900378517)
87738 87239 6 17 233 Arbor St 1 9 1 1   02/14/2008 12:00:00 AM     Permit Number 50269 6001330.0 2096776.0 37.737422605415205 -122.43789575270901 (37.7374226054152, -122.437895752709)
92995 105436 6 17 610 PARNASSUS AVE 7 9 1 1   03/05/2014 12:00:00 AM 15   Permit Number 771221 5995151.3 2106193.4 37.762927120328996 -122.459940260935 (37.762927120329, -122.459940260935)
95242 106255 6 17 1900X 18th St 1 9 1 1         Permit Number 770844 6012067.0 2105610.0 37.7622835736204 -122.40139334750201 (37.7622835736204, -122.401393347502)
105512 105130 6 17 4045 MORAGA ST   9 1 1           5981665.2 2103465.9 37.7546533409301 -122.506380933635 (37.7546533409301, -122.506380933635)
120703 105435 6 17 610 PARNASSUS AVE 1 9 1 1   03/05/2014 12:00:00 AM 16   Permit Number 771221 5995151.3 2106193.4 37.762927120328996 -122.459940260935 (37.762927120329, -122.459940260935)
18402 48402 6 18 706 Wisconsin St 1 9 1 1   11/19/2010 12:00:00 AM     Permit Number 53935 6012689.64928807 2104214.1545054 37.7584856101735 -122.399141839868 (37.7584856101735, -122.399141839868)
4549 226945 6 19 998 Chenery St 4 9 1 1     21 Width 1ft   6001140.61217 2096125.6115299999 37.735626018710896 -122.438503967885 (37.7356260187109, -122.438503967885)
78153 104715 6 19 3618 22nd St 1 9 1 1         Permit Number 770676 6004228.3 2103103.8 37.7549616692716 -122.42832583872601 (37.7549616692716, -122.428325838726)
97963 104717 6 19 3618 22nd St 3 9 1 1         Permit Number 770676 6004228.3 2103103.8 37.7549616692716 -122.42832583872601 (37.7549616692716, -122.428325838726)
112529 104716 6 19 3618 22nd St 2 9 1 1         Permit Number 770676 6004228.3 2103103.8 37.7549616692716 -122.42832583872601 (37.7549616692716, -122.428325838726)
115705 117417 6 21 2835 Washington St 1 9 1 1       3x10 Permit Number 778177 6001153.1 2116153.5 37.790618387033206 -122.439896334555 (37.7906183870332, -122.439896334555)
82216 116521 6 26 70 BEAUMONT AVE 1 9 1 1     10 3x3   5996728.0 2112568.0 37.7805206716372 -122.454947659336 (37.7805206716372, -122.454947659336)
85138 103617 6 26 201X Haight St 2 9 1 1           6004725.0 2109149.0 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796)
100197 103618 6 26 201X Haight St 3 9 1 1           6004725.0 2109149.0 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796)
2003 127110 6 32 3201 Laguna St 1 9 1 1     23 Width 6ft   6003718.35126 2119752.0994 37.8006449063974 -122.431277695812 (37.8006449063974, -122.431277695812)
93393 103615 6 39 200X Buchanan St 5 9 1 1           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637)
100567 103612 6 39 200X Buchanan St 2 9 1 1           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637)
114318 103614 6 39 200X Buchanan St 4 9 1 1           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637)
138814 103611 6 39 200X Buchanan St 1 9 1 1           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637)
144880 103613 6 39 200X Buchanan St 3 9 1 1           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637)
80719 116576 6 40 2500x OCEAN AVE 1 9 1 6 4   30 10X10   5991377.0 2094742.0 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256)
116414 98290 6 41 300 Mangels Ave 6 9 1 1   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506)
119061 98288 6 41 300 Mangels Ave 4 9 1 1   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506)
127682 98289 6 41 300 Mangels Ave 5 9 1 1   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506)
272 251264 6 47 3630x 19th Ave 3 9 1 1         Permit Number 779147          
277 251265 6 47 3630x 19th Ave 4 9 1 1         Permit Number 779147          
293 251262 6 47 3630x 19th Ave 1 9 1 1         Permit Number 779147          
300 251263 6 47 3630x 19th Ave 2 9 1 1         Permit Number 779147          
1030 251424 6 47 5016 Diamond Heights Blvd 1 9 1 1       3x3   5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
86774 122640 6 47 3630X 19th Ave 4 9 1 1       3x8   5990614.0 2091411.0 37.7220764711857 -122.47455416918999 (37.7220764711857, -122.47455416919)
88391 122637 6 47 3630X 19th Ave 1 9 1 1       3x8   5990614.0 2091411.0 37.7220764711857 -122.47455416918999 (37.7220764711857, -122.47455416919)
91819 122638 6 47 3630X 19th Ave 2 9 1 1       3x8   5990614.0 2091411.0 37.7220764711857 -122.47455416918999 (37.7220764711857, -122.47455416919)
118710 105850 6 47 44 MENDOSA AVE 1 9 1 1     100 6x15   5993395.1 2101192.7 37.7490953323683 -122.465650972372 (37.7490953323683, -122.465650972372)
120114 122639 6 47 3630X 19th Ave 3 9 1 1       3x8   5990614.0 2091411.0 37.7220764711857 -122.47455416918999 (37.7220764711857, -122.47455416919)
3801 177109 6 55 401 Ocean Ave 16 9 1 6     6 Width 5ft   5998958.08532 2091518.52367 37.72285164275971 -122.445718558684 (37.7228516427597, -122.445718558684)
3805 177105 6 55 401 Ocean Ave 12 9 1 6     4 Width 5ft   5998924.5969 2091518.7811599998 37.7228504376811 -122.445834339179 (37.7228504376811, -122.445834339179)
3806 177110 6 55 401 Ocean Ave 17 9 1 6     6 Width 5ft   5998978.57855 2091518.5364400002 37.722852847868 -122.445647719081 (37.722852847868, -122.445647719081)
3808 177108 6 55 401 Ocean Ave 15 9 1 6     5 Width 5ft   5998950.80755 2091518.23612 37.7228504376851 -122.44574369563999 (37.7228504376851, -122.44574369564)
3826 177104 6 55 401 Ocean Ave 11 9 1 6     4 Width 5ft   5998921.0818300005 2091519.29315 37.722851642780796 -122.44584652679501 (37.7228516427808, -122.445846526795)
3827 177106 6 55 401 Ocean Ave 13 9 1 6     7 Width 5ft   5998933.177730001 2091518.16383 37.7228492325857 -122.44580463279199 (37.7228492325857, -122.445804632792)
96595 106311 6 71 99X Clearfield Dr 5 9 1 1   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.4648400003 37.73289581695511 -122.49149816384899 (37.7328958169551, -122.491498163849)
142007 106310 6 71 99X Clearfield Dr 4 9 1 1   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.4648400003 37.73289581695511 -122.49149816384899 (37.7328958169551, -122.491498163849)
22892 251144 6 103 200X Clarendon Ave 1 9 1 1       3x3   5996559.0 2104265.0 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022)
22896 251145 6 103 200X Clarendon Ave 1 9 1 1       3x3   5996559.0 2104265.0 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022)
90764 103616 6 108 201X Haight St 1 9 1 1           6004725.0 2109149.0 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796)
1956 252838 6 114 99 Pond St 1 9 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
43173 112929 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
78522 112919 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
81040 112918 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
85824 112921 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
89530 112922 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
100331 112930 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
115520 112925 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
117865 112928 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
128076 112923 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
140824 112927 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
141641 112926 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
142904 112920 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
1025 251425 6 128 5016 Diamond Heights Blvd 2 9 1 1           5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
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)
122848 96328 6 141 296 Randall St 2 9 1 1         Permit Number 767829 6003708.0 2097940.0 37.7407536226533 -122.429756895294 (37.7407536226533, -122.429756895294)
106567 106109 6 170 135 MENDOSA AVE 2 9 1 1   04/23/2014 12:00:00 AM     Permit Number 772704 5992893.2 2100790.2 37.747961208182 -122.467357269235 (37.747961208182, -122.467357269235)
143283 106107 6 170 135 MENDOSA AVE 1 9 1 1   04/23/2014 12:00:00 AM     Permit Number 772704 5992893.2 2100790.2 37.747961208182 -122.467357269235 (37.747961208182, -122.467357269235)
119294 92055 6 180 1001 Potrero Ave   9 1 1         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
123605 92056 6 180 1001 Potrero Ave   9 1 1   06/16/2009 12:00:00 AM     Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
Powered by Datasette · Query took 11.851ms · Data source: data.sfgov.org