sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
18682 87286 1 12 1272 42nd Ave   9 1 1   03/18/2007 12:00:00 AM     Permit Number 50303 5983096.8 2106514.6 37.7631083916796 -122.501655692289 (37.7631083916796, -122.501655692289)
21199 97237 7 41 125 Excelsior Ave   9 1 4 1 09/07/2011 12:00:00 AM     Permit Number 767513 6002911.0 2092621.3 37.7261045201699 -122.43213288829399 (37.7261045201699, -122.432132888294)
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)
77398 106965 2 15 63 BELLE AVE   9 1 1           5991753.8 2086471.1 37.7085786821221 -122.47025464516001 (37.7085786821221, -122.47025464516)
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)
78648 112011 2 1 115 Red Rock Way   9 1 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
79007 107987 1 48 233 Laidley St   9 1 1   11/10/2014 12:00:00 AM 3   Permit Number 771182 6004231.95883 2097050.3446 37.7383404878499 -122.427881865747 (37.7383404878499, -122.427881865747)
79404 97051 7 180 795 Wisconsin St   9 1 1 1 08/19/2011 12:00:00 AM     Permit Number 767554 6012787.8 2103832.3 37.7574425906128 -122.39877559017401 (37.7574425906128, -122.398775590174)
79961 105904 2 3 700X BROTHERHOOD WAY   9 1 1         Permit Number 772491 5991178.9 2088065.4 37.7129229890255 -122.47235769727399 (37.7129229890255, -122.472357697274)
80283 112014 2 1 115 Red Rock Way   9 1 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
80849 97052 7 291 795 Wisconsin St   9 1 1 1 08/19/2011 12:00:00 AM     Permit Number 767554 6012787.8 2103832.3 37.7574425906128 -122.39877559017401 (37.7574425906128, -122.398775590174)
81019 112013 2 1 115 Red Rock Way   9 1 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
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)
82492 112009 2 1 115 Red Rock Way   9 1 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
82574 107467 1 473 1643 35th Ave   9 1 1   09/11/2014 12:00:00 AM 3   Permit Number 773410 5985268.14341 2104019.02784 37.7563835411873 -122.493961929435 (37.7563835411873, -122.493961929435)
84128 112015 2 1 115 Red Rock Way   9 1 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
84983 96991 1 379 2201 North Point St   9 1 1   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.44357930017799 (37.8026268776405, -122.443579300178)
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)
90475 112007 2 1 115 Red Rock Way   9 1 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
92324 96987 1 84 2201 North Point St   9 1 1   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.44357930017799 (37.8026268776405, -122.443579300178)
92707 112016 2 3 115 Red Rock Way   9 1 1   07/08/2015 12:00:00 AM 3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
93993 112012 2 1 115 Red Rock Way   9 1 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
95977 112005 2 1 115 Red Rock Way   9 1 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
96282 104677 2 15 65 ZIRCON PL   9 1 1         Permit Number 770985 6002398.2 2098694.7 37.7427515964219 -122.43433962698201 (37.7427515964219, -122.434339626982)
96813 112924 6 3 2X Noe St   9 1 1           6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
97565 106145 1 17 89 Belgrave Ave   9 1 1         Permit Number 771523 5998082.7 2104872.2 37.7594675922154 -122.449706395213 (37.7594675922154, -122.449706395213)
98773 106368 1 88 426 Country Club Dr   9 1 1   04/23/2014 12:00:00 AM     Permit Number 770073 5984817.1 2094918.3 37.731369010287 -122.494850794258 (37.731369010287, -122.494850794258)
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)
101381 96988 1 132 2201 North Point St   9 1 1   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.44357930017799 (37.8026268776405, -122.443579300178)
105512 105130 6 17 4045 MORAGA ST   9 1 1           5981665.2 2103465.9 37.7546533409301 -122.506380933635 (37.7546533409301, -122.506380933635)
106196 96990 1 132 2201 North Point St   9 1 1   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.44357930017799 (37.8026268776405, -122.443579300178)
109226 109516 2 47 105 MIDCREST WAY   9 1 1     30 12x12   5998180.4 2101012.8 37.748876224655795 -122.4490904711 (37.7488762246558, -122.4490904711)
110148 92047 3 80 2323 Cesar Chavez St   9 1 2   05/16/2009 12:00:00 AM       6012395.8634440005 2100936.77011 37.749470250033795 -122.399927744224 (37.7494702500338, -122.399927744224)
113702 112010 2 1 115 Red Rock Way   9 1 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
114706 96989 1 132 2201 North Point St   9 1 1   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.44357930017799 (37.8026268776405, -122.443579300178)
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)
117009 112004 2 1 115 Red Rock Way   9 1 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
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)
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)
120716 106300 1 37 687 28th St   9 1 1         Permit Number 772857 6001494.5 2099363.3 37.7445360779925 -122.437512227288 (37.7445360779925, -122.437512227288)
121140 112006 2 1 115 Red Rock Way   9 1 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
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)
127434 97236 7 458 125 Excelsior Ave   9 1 4 1 09/07/2011 12:00:00 AM     Permit Number 767513 6002911.0 2092621.3 37.7261045201699 -122.43213288829399 (37.7261045201699, -122.432132888294)
127458 112008 2 1 115 Red Rock Way   9 1 1     3     6000032.1 2099934.7 37.7460217534147 -122.442609914587 (37.7460217534147, -122.442609914587)
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)
129188 105003 2 98 607 CONGO ST   9 2 1           6000094.1 2095817.0 37.73471905904071 -122.44210000591002 (37.7347190590407, -122.44210000591)
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)
143438 112252 2 3 5301x DIAMOND HEIGHTS BLVD   9 1 1     28 3x3   6001927.0 2098732.0 37.7428272563398 -122.43597156823799 (37.7428272563398, -122.435971568238)
145559 98736 2 17 89 Paradise Ave   9 1 1           6000827.4 2096045.9 37.73538932786521 -122.439581147409 (37.7353893278652, -122.439581147409)
128 212622 2 16 115 Beverly St 1 9 1 1     4 Width 10ft   5991392.0 2089980.0 37.718192344870296 -122.471760605115 (37.7181923448703, -122.471760605115)
241 251257 2 65 1748x Eucalyptus Dr 1 9 1 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
293 251262 6 47 3630x 19th Ave 1 9 1 1         Permit Number 779147          
340 191854 3 39 573 10th St 1 9 1 2     24 Width 6ft tree is in ROW therefore DPW maintained 6009977.72395 2108375.30106 37.7697596664942 -122.408814503513 (37.7697596664942, -122.408814503513)
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)
713 251364 5 47 138x Gladeview Way 1 9 1 1                    
784 251384 2 47 138x Gladeview Way 1 9 1 1       3x3   5997939.0 2102166.0 37.7520288182083 -122.45000833213699 (37.7520288182083, -122.450008332137)
794 212187 3 60 720 Bosworth St 1 9 1 2     16     6002096.28779 2095466.30888 37.733870041163 -122.435152693763 (37.733870041163, -122.435152693763)
818 251389 2 3 202x Mangels Ave 1 9 1 1       3x3   5999774.0 2095231.0 37.7330917931436 -122.44316462438499 (37.7330917931436, -122.443164624385)
869 124177 3 47 8X Almaden Ct 1 9 1 2     10 Width 9ft   5995876.0 2112606.0 37.7805760973259 -122.457897862346 (37.7805760973259, -122.457897862346)
1027 251426 6 3 5020 Diamond Heights Blvd 1 9 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1029 251428 2 47 5030 Diamond Heights Blvd 1 9 1 1       3x3   5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
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)
1034 251427 2 3 5028 Diamond Heights Blvd 1 9 1 1       3x3   5999606.0 2100130.0 37.7465337016449 -122.44409733772801 (37.7465337016449, -122.444097337728)
1438 251533 2 60 1201X Pierce St 1 9 1 1       3x3   6002292.0 2112799.0 37.7814725496882 -122.43571571002899 (37.7814725496882, -122.435715710029)
1500 251574 3 5 191 Portola Dr 1 9 1 2       3x3   5999731.0 2100707.0 37.748125134697 -122.443706547761 (37.748125134697, -122.443706547761)
1680 251668 2 40 301x Laguna Honda Blvd 1 9 1 1       3x3   5995349.0 2100852.0 37.7482723626065 -122.458869747183 (37.7482723626065, -122.458869747183)
1700 123453 2 153 713 02nd Ave 1 9 1 1   05/30/2017 12:00:00 AM 3 Width 2ft Permit Number 779827 5995319.78488 2110672.1771299997 37.7752343616797 -122.459681952866 (37.7752343616797, -122.459681952866)
1736 251677 2 47 772x Panorama Dr 1 9 1 1       3x3   5996636.0 2102785.0 37.7536537924326 -122.454558985212 (37.7536537924326, -122.454558985212)
1956 252838 6 114 99 Pond St 1 9 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
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)
2015 251655 3 98 300x Chester Ave 1 9 1 2       3x3   5991691.0 2087193.0 37.710557214846794 -122.47052422929701 (37.7105572148468, -122.470524229297)
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)
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)
2399 253072 2 3 1350 46th Ave 1 9 1 1       5x10 Permit Number 780489 5981849.666569999 2105897.22193 37.761339917853896 -122.50592325662 (37.7613399178539, -122.50592325662)
2503 253120 1 3 815 Buena Vista Ave West 1 9 1 1       10x100   6000071.60031 2108311.04493 37.769023393565604 -122.44307478834801 (37.7690233935656, -122.443074788348)
2593 155952 2 16 35 Manor Dr 1 9 1 1   07/20/2017 12:00:00 AM 3     5993448.18795 2093194.64055 37.7271377226027 -122.464886627823 (37.7271377226027, -122.464886627823)
2953 192045 2 37 405 Townsend St 1 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013178.04643 2110099.77457 37.7746734191738 -122.39786558493401 (37.7746734191738, -122.397865584934)
3007 253279 2 9 201X Laguna Honda Blvd 1 9 1 2       10x10 ROW IS 10' tree is street tree          
3132 253339 7 47 2019X 24th Ave 1 9 1 13       3x3   5988853.0 2101569.0 37.7498655183494 -122.481384971136 (37.7498655183494, -122.481384971136)
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)
3186 218743 1 37 141 Cresta Vista Dr 1 9 1 1   07/06/1988 12:00:00 AM 8 Width 3ft Permit Number 25334 5995930.5324099995 2096235.39856 37.7356297230374 -122.456525038998 (37.7356297230374, -122.456525038998)
3187 207331 1 27 432 Congo St 1 9 1 1   07/05/2002 12:00:00 AM 8 Width 8ft Permit Number 45704 6000124.74065 2095150.49618 37.7328907415174 -122.441946248045 (37.7328907415174, -122.441946248045)
3523 253474 4 16 134 Lunado Way 1 9 1 1       3x2   5991633.0 2092401.0 37.7248537561355 -122.471103859098 (37.7248537561355, -122.471103859098)
3527 205481 2 211 100 Edna St 1 9 1 1   09/12/2017 12:00:00 AM 3 Width 8ft   5998772.56194 2093243.78905 37.7275782258363 -122.446483932112 (37.7275782258363, -122.446483932112)
3537 102838 2 3 1101X Portola Dr 1 9 1 2                    
3540 123527 2 12 2850 Fulton St 1 9 1 1     8 Width 8ft Permit Number 780721 5994500.1201 2110215.1995599996 37.77393245416361 -122.462484184544 (37.7739324541636, -122.462484184544)
3561 253462 2 38 98X Marston Ave 1 9 1 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3579 123325 2 12 798 05th Ave 1 9 1 1     12   Permit Number 780721 5994467.5512 2110242.48836 37.7740055063811 -122.46259882484101 (37.7740055063811, -122.462598824841)
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)
3903 220233 1 5 1001 Ashbury St 1 9 1 1   05/23/1987 12:00:00 AM 39 Width 4ft Permit Number 12054 5999170.85741 2106639.03394 37.764381073148705 -122.44607010996201 (37.7643810731487, -122.446070109962)
4028 216741 2 77 990 Plymouth Ave 1 9 1 1   10/05/2017 07:49:00 AM 3 Width 4ft   5995950.8772 2090428.1380900003 37.719685546243895 -122.456034989421 (37.7196855462439, -122.456034989421)
4344 253624 2 44 735 Teresita Blvd 1 9 1 1       3x3   5998960.0 2095994.0 37.735140362702396 -122.446033688862 (37.7351403627024, -122.446033688862)
4729 123750 2 227 2 Cabrillo St 1 9 1 1     9 Width 3ft   5995617.0 2110854.0 37.775750686051005 -122.458666990683 (37.775750686051, -122.458666990683)
4764 253679 2 39 94 Teresita Blvd 1 9 1 1       4x8   5997405.0 2099153.0 37.7437252916895 -122.45163765514201 (37.7437252916895, -122.451637655142)
4919 253715 2 231 2959 21st Ave 1 9 1 1       5x15   5989962.0 2095532.0 37.733353897105495 -122.477108940264 (37.7333538971055, -122.477108940264)
5061 253757 2 22 330 Twin Peaks Blvd 1 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
9631 173613 4 51 2955 20th Ave 1 9 1 1   12/12/2016 12:00:00 AM 3 3x6 Permit Number 776469 5990236.78382 2095590.4495400002 37.7335303227244 -122.476163213901 (37.7335303227244, -122.476163213901)
10034 109404 2 136 355 CHRISTOPHER DR 1 9 1 1       3x3   5995347.2 2103110.3 37.7544729812167 -122.45903946490299 (37.7544729812167, -122.459039464903)
Powered by Datasette · Query took 21.986ms · Data source: data.sfgov.org