trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1 264847 1 1 109 Felton St 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6010522 2093730 37.729577358437 -122.405900044893 (37.729577358437, -122.405900044893) 10 3 7 309 28
2 262167 1 2 420 Alpha St 2 Sidewalk: Curb side : Cutout Tree 1 FUF 11/16/2020 12:00:00 AM 3                        
6 262166 1 2 420 Alpha St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 11/16/2020 12:00:00 AM 3                        
8 264824 1 6 1x Harkness Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6012032 2089425 37.7178410421308 -122.400377527521 (37.7178410421308, -122.400377527521) 10 7 8 309 39
11 264841 1 2 1601 Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6007819 2087884 37.7133739406818 -122.41483104388 (37.7133739406818, -122.41483104388) 9 7 8 309 39
15 264849 1 12 15 Hale St 2 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6010381 2094903 37.7327902820185 -122.40647012075 (37.7327902820185, -122.40647012075) 10 3 7 309 28
19 262168 1 2 420 Alpha St 3 Sidewalk: Curb side : Cutout Tree 1 FUF 11/16/2020 12:00:00 AM 3                        
21 264839 1 2 1601 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6007819 2087884 37.7133739406818 -122.41483104388 (37.7133739406818, -122.41483104388) 9 7 8 309 39
26 259857 1 1 1255 Brussels St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 11/01/2020 12:00:00 AM 3     6011768.59367 2089078.72926 37.7168755602396 -122.401263692233 (37.7168755602396, -122.401263692233) 10 7 8 309 39
28 264848 1 12 15 Hale St 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6010381 2094903 37.7327902820185 -122.40647012075 (37.7327902820185, -122.40647012075) 10 3 7 309 28
32 264850 1 8 172 University St 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6007951 2093149 37.7278379340298 -122.414747181337 (37.7278379340298, -122.414747181337) 9 3 7 309 5
79 121399 1 28 349X Cargo Way 1 Sidewalk: Curb side : Cutout Tree 1                              
82 251210 1 42 1170 Ingalls St 2 Sidewalk: Curb side : Cutout Tree 1   11/02/1992 12:00:00 AM                          
83 259099 1 11 600 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
85 259368 1 3 1646 Revere Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF                            
87 259654 1 45 101x Cora St   Sidewalk: Curb side : Cutout Tree 1 FUF 06/01/2019 12:00:00 AM 3                        
88 259653 1 45 99x Cora St 2 Sidewalk: Curb side : Cutout Tree 1 FUF 06/01/2019 12:00:00 AM 3                        
89 259623 1 45 1498x Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree 1 FUF 06/01/2019 12:00:00 AM 3                        
90 259864 1 1 1398x Brussels St   Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
91 260225 1 10 2201x 22nd Ave 21 Sidewalk: Curb side : Cutout Tree 1 FUF 10/20/2018 12:00:00 AM 3                        
92 260521 1 46 3519x Kirkham St 3 Sidewalk: Curb side : Cutout Tree 1 FUF 07/27/2019 12:00:00 AM 3                        
93 260525 1 47 3437x Rivera St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 07/27/2019 12:00:00 AM 3                        
100 255131 1 28 401X Brotherhood Way 9 Sidewalk: Property side : Yard Tree 1                              
101 255229 1 11 300X Goettingen St 4 Sidewalk: Curb side : Cutout Tree 1 FUF                            
102 258152 1 49 500X Bryant St 2 Sidewalk: Curb side : Cutout Tree 1 FUF   3                        
104 260590 1 50 3099x Jennings St 3 Sidewalk: Curb side : Cutout Tree 1 FUF 08/20/2020 12:00:00 AM 3                        
106 251438 1 41 2501X Santiago St 1 Median : Yard Tree 1                              
107 264818 1 51 101x Olmstead St 2 Sidewalk: Curb side : Cutout Tree 1   10/23/2020 12:00:00 AM 3                        
127 119777 1 59 204x Octavia St 12 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
129 107934 1 17 3098X Market St 3 Median : Yard Tree 1           5999920 2105144 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916) 2 4 5 28862 3
133 211075 1 63 650x Miramar Ave 6 Median : Yard Tree 1     34     5995390.83549 2093912.64173 37.7292209976493 -122.458222905073 (37.7292209976493, -122.458222905073) 9 7 4 28861 40
137 189330 1 64 1427x Innes Ave 23 Median : Yard Tree 1     15     6016163.75351 2096735.77367 37.7381445215441 -122.386605256348 (37.7381445215441, -122.386605256348) 10 3 8 58 1
154 119838 1 31 301x Octavia St 11 Median : Cutout Tree 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
160 107490 1 68 1306x Montgomery St 19 Median : Cutout Tree 1     12     6011447.18476 2119974.76336 37.8016912541172 -122.404548295963 (37.8016912541172, -122.404548295963) 3 1 10 308 23
161 194506 1 15 299x Cashmere St 26 Median : Yard Tree 1     18     6016624.93937 2096021.78221 37.7362095654157 -122.384960961105 (37.7362095654157, -122.384960961105) 10 3 8 58 1
181 14420 1 16 2X Masonic Ave 8 Median : Cutout Tree 1     35     5998841.5976 2113071.3194 37.7820236767836 -122.447671998063 (37.7820236767836, -122.447671998063) 15 5 2 54 16
187 112917 1 66 480X BEACON ST 1 Sidewalk: Property side : Yard Tree 1           6002571 2098077 37.7410653426557 -122.433697996676 (37.7410653426557, -122.433697996676) 2 7 5 63 7
206 119799 1 31 201x Octavia St 7 Median : Cutout Tree 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
215 119692 1 59 4x Octavia St 10 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
225 119839 1 31 301x Octavia St 12 Median : Cutout Tree 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
238 119796 1 31 201x Octavia St 4 Median : Cutout Tree 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
245 251484 1 15 900 Bosworth St 7 Front Yard : Yard Tree 1           6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
248 119766 1 59 204x Octavia St 1 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
266 219228 1 81 200x Terrace Dr 4 Median : Yard Tree 1     10     5993785.97496 2096493.89011 37.736216119669 -122.463958297244 (37.736216119669, -122.463958297244) 1 8 4 59 40
271 107116 1 17 300X LIBERTY ST 18 Median : Cutout Tree 1     12     6004270.1 2103982.4 37.7573764628527 -122.428243896062 (37.7573764628527, -122.428243896062) 2 4 5 28862 3
285 260625 1 4 1601x Thomas Ave 2 Sidewalk: Curb side : Cutout Tree 1 FUF 08/24/2019 12:00:00 AM 3                        
300 234411 1 87 10x Benton Ave 4 Median : Yard Tree 1     32     6004755.33467 2095032.93123 37.7328307189427 -122.425928720736 (37.7328307189427, -122.425928720736) 2 7 7 28861 2
304 132028 1 9 33x Battery St 1 Median : Yard Tree 1     27     6012842.61776 2116100.99756 37.7911327033699 -122.399447311639 (37.7911327033699, -122.399447311639) 4 1 10 28854 6
313 119729 1 59 104x Octavia St 9 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
344 119791 1 31 202x Octavia St Frontage East 11 Median : Cutout Tree 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
375 115067 1 45 70 Coral Rd 7 Sidewalk: Curb side : Cutout Tree 1           6012676.36761 2102522.24683 37.7538392609312 -122.399069018455 (37.7538392609312, -122.399069018455) 10 3 8 28856 29
406 119837 1 31 301x Octavia St 10 Median : Cutout Tree 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
413 119686 1 59 4x Octavia St 4 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
428 119830 1 31 301x Octavia St 3 Median : Cutout Tree 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
431 119778 1 59 204x Octavia St 13 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
436 120628 1 35 1500 Geary Blvd 5 Median : Cutout Tree 1           6004397 2113949 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
442 119718 1 31 102x Octavia St Frontage East 11 Median : Cutout Tree 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
444 105900 1 56 11X ELLIOT ST 1 Unaccepted Street : Yard Tree 1     30     6009059 2088845 37.716082244868 -122.410612975888 (37.716082244868, -122.410612975888) 9 7 8 309 18
470 119711 1 31 102x Octavia St Frontage East 4 Median : Cutout Tree 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
481 119782 1 31 202x Octavia St Frontage East 2 Median : Cutout Tree 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
519 259637 1 45 95 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 06/01/2019 12:00:00 AM 3     6010745.67067 2087724.79538 37.7131008096728 -122.404704194453 (37.7131008096728, -122.404704194453) 9 7 8 309 39
537 261951 1 41 1X Portola Dr To Clipper St Connetion 5 Sidewalk: Property side : Yard Tree 1                              
544 259763 1 75 2701 24th St 1 Sidewalk: Curb side : Cutout Tree 1   03/12/2019 12:00:00 AM 3                        
566 260237 1 10 2201x 22nd Ave 33 Sidewalk: Curb side : Cutout Tree 1 FUF 10/20/2018 12:00:00 AM 3                        
570 259611 1 45 1420 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 06/01/2019 12:00:00 AM 3     6008434.50928 2087674.99824 37.7128346308013 -122.412688855365 (37.7128346308013, -122.412688855365) 9 7 8 309 39
595 261954 1 41 1X Portola Dr To Clipper St Connetion 8 Sidewalk: Property side : Yard Tree 1                              
629 259747 1 18 1674 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 10/13/2018 12:00:00 AM 3     6014811.75538 2097073.30447 37.7389963714409 -122.391303417459 (37.7389963714409, -122.391303417459) 10 3 8 58 1
663 259361 1 128 1699x Keith St 2 Sidewalk: Curb side : Cutout Tree 1 FUF 05/25/2019 12:00:00 AM 3                        
785 262387 1 140 1525 Galvez Ave 2 Sidewalk: Curb side : Cutout Tree 1   03/03/2017 12:18:00 PM       6016246.49948 2097351.8889 37.739840829559 -122.38636210374 (37.739840829559, -122.38636210374) 10 3 8 58 1
805 259342 1 1 124 Bacon St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 04/27/2019 12:00:00 AM 3     6011093.06151 2093005.0494 37.7276187164247 -122.403874822512 (37.7276187164247, -122.403874822512) 10 3 7 309 28
822 112248 1 88 1799X TAYLOR ST 1 Unaccepted Street : Yard Tree 1     15     6008739 2118839 37.7984210068607 -122.413839504702 (37.7984210068607, -122.413839504702) 5 1 10 308 21
844 254210 1 15 300x Esmeralda Ave 20 Unaccepted Street : Yard Tree 1                              
848 116677 1 146 100 Esmeralda Ave 16 Unaccepted Street : Yard Tree 1           6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
871 259735 1 14 100x Florida St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 06/09/2018 12:00:00 AM 3                        
894 260859 1 149 739 33rd Ave   Sidewalk: Curb side : Cutout Tree 1 FUF 05/18/2019 12:00:00 AM 3     5985675.22385 2110852.85567 37.7751711283725 -122.493057514378 (37.7751711283725, -122.493057514378) 11 6 2 55 26
895 56729 1 13 1547 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree 1   12/26/2012 12:00:00 AM 5   Permit Number 769649 6015653.0224 2095684.4557 37.7352295280363 -122.388297771341 (37.7352295280363, -122.388297771341) 10 3 8 58 1
927 260891 1 1 839 34th Ave   Sidewalk: Curb side : Cutout Tree 1 FUF 05/18/2019 12:00:00 AM 3     5985392.72943 2110161.55054 37.7732564760791 -122.493983752439 (37.7732564760791, -122.493983752439) 11 6 2 55 26
929 257972 1 47 2091 44th Ave 1 Sidewalk: Curb side : Cutout Tree 1     3     5982601.27724 2100898.28737 37.7476584613609 -122.502953711343 (37.7476584613609, -122.502953711343) 1 8 3 29491 35
993 67493 1 25 740 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree 1   09/08/1992 12:00:00 AM 8   Permit Number 31018 6011800.9294 2105019.52264 37.7606474054712 -122.402272073209 (37.7606474054712, -122.402272073209) 10 3 8 28856 29
1030 260915 1 1 1307 Waller St   Sidewalk: Curb side : Cutout Tree 1 FUF 09/21/2019 12:00:00 AM 3     5999454.48308 2108393.47297 37.7692145145226 -122.445215277932 (37.7692145145226, -122.445215277932) 15 5 11 29492 9
1043 99282 1 44 1500 Fillmore St 1 Sidewalk: Curb side : Cutout Tree 1   12/14/2013 12:00:00 AM 3     6003016.20305 2114040.83621 37.7849234280868 -122.433299082538 (37.7849234280868, -122.433299082538) 13 9 11 29490 13
1049 120626 1 35 1500 Geary Blvd 3 Median : Cutout Tree 1           6004397 2113949 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
1090 260553 1 36 151x Palm Ave 4 Sidewalk: Curb side : Cutout Tree 1 SFUSD 09/21/2019 12:00:00 AM 3                        
1095 255202 1 1 301X Burrows St 3 Sidewalk: Curb side : Cutout Tree 1 FUF                            
1107 258138 1 11 300 Beale St 12 Sidewalk: Curb side : Cutout Tree 1 FUF   3     6014765.94263 2115143.61778 37.7886109721909 -122.39272561329 (37.7886109721909, -122.39272561329) 6 2 9 28855 6
1126 262542 1 6 1260 Egbert Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 08/18/2020 12:00:00 AM       6015016 2090665 37.7214117898675 -122.390149655616 (37.7214117898675, -122.390149655616) 10 3 8 58 1
1138 260594 1 1 3090x Jennings St 4 Sidewalk: Curb side : Cutout Tree 1 FUF 08/24/2019 12:00:00 AM 3                        
1179 251578 1 37 1000X Columbus Ave 6 Median : Cutout Tree 1                              
1249 107933 1 17 3098X Market St 1 Median : Yard Tree 1           5999920 2105144 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916) 2 4 5 28862 3
1378 95407 1 15 2X Cranleigh Dr 9 Median : Yard Tree 1     80     5991370.3 2095943.7 37.7345659248964 -122.472270103664 (37.7345659248964, -122.472270103664) 1 8 4 64 40
1393 255136 1 11 401X Brotherhood Way 14 Sidewalk: Property side : Yard Tree 1                              
1422 259801 1 18 1180x Brussels St 2 Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
1511 260421 1 8 200x Bacon St 5 Sidewalk: Curb side : Cutout Tree 1 FUF 08/17/2019 12:00:00 AM 3                        
1522 187744 1 70 2x Dukes Ct 2 Median : Yard Tree 1     3     6016140.58365 2096258.22676 37.7368319916033 -122.386652075929 (37.7368319916033, -122.386652075929) 10 3 8 58 1
1524 28207 1 27 300X King St 13 Sidewalk: Curb side : Cutout Tree 1     12     6014268.5967781 2110706.0699128 37.7763988431969 -122.394135578218 (37.7763988431969, -122.394135578218) 6 2 9 28856 20
1534 28217 1 27 300X King St 23 Sidewalk: Curb side : Cutout Tree 1     12     6014268.5967781 2110706.0699128 37.7763988431969 -122.394135578218 (37.7763988431969, -122.394135578218) 6 2 9 28856 20
1569 262185 1 23 210 Teddy Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 09/07/2019 12:00:00 AM 3     6010173.92032 2088318.83679 37.7146999535571 -122.406722203929 (37.7146999535571, -122.406722203929) 9 7 8 309 39
1576 260532 1 65 1759 43rd Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 07/27/2019 12:00:00 AM 3     5982834.94 2103154.54026 37.7538672331819 -122.502312683451 (37.7538672331819, -122.502312683451) 1 8 3 56 35
1593 259756 1 102 1523 Innes Ave   Sidewalk: Curb side : Cutout Tree 1 FUF 10/13/2018 12:00:00 AM 3     6015921.70632 2096895.74231 37.7385703600528 -122.387453298811 (37.7385703600528, -122.387453298811) 10 3 8 58 1
1613 112905 1 93 1500 Bancroft Ave 1 Front Yard : Yard Tree 1     25     6014696 2091834 37.7246038778524 -122.391337493735 (37.7246038778524, -122.391337493735) 10 3 8 58 1
1736 255231 1 11 300X Goettingen St 6 Sidewalk: Curb side : Cutout Tree 1 FUF