sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
251 251258 2 65 1748x Eucalyptus Dr 2 9 1 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
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          
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)
389 191855 3 39 573 10th St 2 9 1 2     49 Width 6ft Cal Trans adjacent; 10 ft ROW 6009921.77605 2108434.69103 37.7699196037317 -122.409012217656 (37.7699196037317, -122.409012217656)
545 251322 2 95 828 Foerster St 6 9 1 1       Width 3ft   5998302.82159 2096489.58159 37.7364635618398 -122.448341458403 (37.7364635618398, -122.448341458403)
682 251365 5 47 138x Gladeview Way 2 9 1 1                    
712 251366 5 47 138x Gladeview Way 3 9 1 1                    
713 251364 5 47 138x Gladeview Way 1 9 1 1                    
782 251385 2 47 138x Gladeview Way 2 9 1 1       3x3   5997939.0 2102166.0 37.7520288182083 -122.45000833213699 (37.7520288182083, -122.450008332137)
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)
796 212189 3 60 720 Bosworth St 3 9 1 2     16     6002068.0773599995 2095471.6867 37.7338832054473 -122.435250610137 (37.7338832054473, -122.435250610137)
797 212191 3 60 720 Bosworth St 5 9 1 2     16     6002043.865019999 2095478.6742 37.7339010165159 -122.435334819059 (37.7339010165159, -122.435334819059)
801 212193 3 60 720 Bosworth St 7 9 1 2     14     6002021.19403 2095482.3719 37.7339098820273 -122.43541346386002 (37.7339098820273, -122.43541346386)
810 212202 2 60 800 Bosworth St 10 9 1 1     13     6001677.26505 2095571.4535400001 37.734134940976 -122.43660890297501 (37.734134940976, -122.436608902975)
818 251389 2 3 202x Mangels Ave 1 9 1 1       3x3   5999774.0 2095231.0 37.7330917931436 -122.44316462438499 (37.7330917931436, -122.443164624385)
868 219533 3 119 3794 19th Ave 2 9 1 2     5 Width 8ft   5990481.81422 2090701.1507700002 37.7201197416248 -122.474959308131 (37.7201197416248, -122.474959308131)
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)
1025 251425 6 128 5016 Diamond Heights Blvd 2 9 1 1           5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
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)
1277 212203 3 60 920 Bosworth St 2 9 1 2     16     6001598.82808 2095593.8833700002 37.7341920703926 -122.436881688932 (37.7341920703926, -122.436881688932)
1307 212207 3 60 920 Bosworth St 8 9 1 2     11     6001467.5944 2095628.72955 37.7342802902926 -122.43733789885 (37.7342802902926, -122.43733789885)
1387 250572 2 34 600 Parker Ave 9 9 1 1   05/15/2017 12:00:00 AM 3   Permit Number 779711 5997267.39343 2111112.94332 37.7765563945078 -122.45297659119 (37.7765563945078, -122.45297659119)
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)
1715 123454 2 153 713 02nd Ave 2 9 1 1     8 Width 2ft Permit Number 779827 5995320.73299 2110668.0352 37.7752230435543 -122.459678373092 (37.7752230435543, -122.459678373092)
1736 251677 2 47 772x Panorama Dr 1 9 1 1       3x3   5996636.0 2102785.0 37.7536537924326 -122.454558985212 (37.7536537924326, -122.454558985212)
1872 177039 2 4 178 Seville St 5 9 1 1     7 Width 2ft   6001177.23506 2087434.66895 37.711764745717 -122.437755094333 (37.711764745717, -122.437755094333)
1945 252839 7 114 99 Pond St 2 9 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
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)
2939 203654 2 58 42 Mangels Ave 5 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft   6001070.39767 2095226.13763 37.7331522778487 -122.438682294452 (37.7331522778487, -122.438682294452)
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)
2963 192048 2 37 405 Townsend St 4 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013251.73009 2110171.5616599997 37.7748746334969 -122.39761573260401 (37.7748746334969, -122.397615732604)
2964 192047 2 37 405 Townsend St 3 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013240.399669999 2110155.0455099996 37.7748286529654 -122.397653768512 (37.7748286529654, -122.397653768512)
2976 198801 2 3 150 Executive Park Blvd 3 9 1 1     0 Width 4ft   6013745.097 2086994.3966599999 37.7112624653484 -122.394285983735 (37.7112624653484, -122.394285983735)
2979 192049 2 37 405 Townsend St 5 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013269.505969999 2110186.9808900002 37.77491796101779 -122.397555323332 (37.7749179610178, -122.397555323332)
2980 192046 2 37 405 Townsend St 2 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013200.03931 2110117.49199 37.774723291973096 -122.39779074965 (37.7747232919731, -122.39779074965)
3005 208852 2 58 42 Mangels Ave 3 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft   6001113.97001 2095223.0116299998 37.733146173254205 -122.43853142959101 (37.7331461732542, -122.438531429591)
3007 253279 2 9 201X Laguna Honda Blvd 1 9 1 2       10x10 ROW IS 10' tree is street tree          
3009 192050 2 37 405 Townsend St 6 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013285.99525 2110202.74852 37.774962173497 -122.39749938908501 (37.774962173497, -122.397499389085)
3132 253339 7 47 2019X 24th Ave 1 9 1 13       3x3   5988853.0 2101569.0 37.7498655183494 -122.481384971136 (37.7498655183494, -122.481384971136)
3142 217765 2 47 470 West Portal Ave 4 9 1 1     42 Width 10ft   5991548.70787 2096139.0246599999 37.7351125606845 -122.471667523249 (37.7351125606845, -122.471667523249)
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)
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)
3530 123324 2 12 798 05th Ave 2 9 1 1     13   Permit Number 780721 5994466.95086 2110266.43708 37.7740712286384 -122.462602639066 (37.7740712286384, -122.462602639066)
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)
3544 253465 2 38 98X Marston Ave 4 9 1 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
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)
3567 253463 2 38 98X Marston Ave 2 9 1 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
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)
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)
3585 253464 2 38 98X Marston Ave 3 9 1 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
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)
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)
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)
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)
3811 177743 6 2 401 Ocean Ave 4 9 1 6     37     5998700.41574 2091522.98281 37.722849171448395 -122.446609585371 (37.7228491714484, -122.446609585371)
3818 178337 6 3 401 Ocean Ave 3 9 1 6     29     5998676.28102 2091524.0079700002 37.7228506076618 -122.44669308741301 (37.7228506076618, -122.446693087413)
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)
3856 246917 2 86 845 Shrader St 2 9 1 1     17 Width 3ft   5997637.485090001 2107521.28402 37.766715824697 -122.451437229753 (37.766715824697, -122.451437229753)
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)
4068 216743 2 77 990 Plymouth Ave 3 9 1 1   10/05/2017 07:52:00 AM 3 Width 4ft   5995950.66479 2090454.56836 37.7197581053329 -122.45603763343901 (37.7197581053329, -122.456037633439)
4344 253624 2 44 735 Teresita Blvd 1 9 1 1       3x3   5998960.0 2095994.0 37.735140362702396 -122.446033688862 (37.7351403627024, -122.446033688862)
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)
4659 253652 6 3 131 Font Blvd 2 9 1 1       10x10   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
4725 253667 2 226 2 Cabrillo St 2 9 1 1       Width 3ft   5995617.0 2110854.0 37.775750686051005 -122.458666990683 (37.775750686051, -122.458666990683)
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)
4757 179682 2 198 501X San Juan Ave 4 9 1 1     4 Width 2ft   6000425.2781 2092808.87665 37.726478317196204 -122.44073930839 (37.7264783171962, -122.44073930839)
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)
4921 253716 2 21 2959 21st Ave 2 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)
5072 253758 2 22 330 Twin Peaks Blvd 2 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5078 253759 2 22 330 Twin Peaks Blvd 3 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
Powered by Datasette · Query took 4.126ms · Data source: data.sfgov.org