trees

1,914 rows where qSpecies_id = 45 sorted by XCoord

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord ▼ YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
87 259654 DPW Maintained 1 :: 45 101x Cora St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
88 259653 DPW Maintained 1 :: 45 99x Cora St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
89 259623 DPW Maintained 1 :: 45 1498x Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
94 260654 Permitted Site 7 :: 45 2590 Buchanan St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   10/03/2019 12:00:00 AM 3 3.5x3                      
103 253831 DPW Maintained 1 :: 45 699X Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3                      
2087 261314 Permitted Site 7 :: 45 2601 Divisadero St 1 Sidewalk: Property side : Cutout Landscaping Private 2   12/31/2019 12:00:00 AM 3 6x106                      
2635 259636 DPW Maintained 1 :: 45 98x Arleta Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
3035 259640 DPW Maintained 1 :: 45 198x Arleta Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
4471 259626 DPW Maintained 1 :: 45 1499x Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
4568 253833 DPW Maintained 1 :: 45 607 Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3                      
4944 259613 DPW Maintained 1 :: 45 1000 Visitacion Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
5006 259624 DPW Maintained 1 :: 45 1401x Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
5098 251531 DPW Maintained 1 :: 45 2100X 20th St 2 Sidewalk: Curb side : Cutout Landscaping Private 2   05/15/2017 12:00:00 AM 3 4x11                      
6366 117001 DPW Maintained 1 :: 45 1X Bernal Heights Blvd 1 Front Yard : Yard Tree DPW 1                              
6535 259627 DPW Maintained 1 :: 45 1499x Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
8424 261322 Private 9 :: 45 811 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/02/2020 12:00:00 AM 3 3x3                      
10803 259618 DPW Maintained 1 :: 45 1200x Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
12379 259619 DPW Maintained 1 :: 45 1200x Visitacion Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
12908 259612 DPW Maintained 1 :: 45 1000 Visitacion Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
14450 259622 DPW Maintained 1 :: 45 1498x Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
14847 259625 DPW Maintained 1 :: 45 1401x Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
15760 251532 DPW Maintained 1 :: 45 2100X 20th St 4 Sidewalk: Curb side : Cutout Landscaping Private 2   05/15/2017 12:00:00 AM 3 4x11                      
15847 259635 DPW Maintained 1 :: 45 98x Arleta Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
16880 259621 DPW Maintained 1 :: 45 1398x Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
17295 259617 DPW Maintained 1 :: 45 1200x Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
17929 259649 DPW Maintained 1 :: 45 700 Delta St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
17931 259643 DPW Maintained 1 :: 45 241 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
18667 259652 DPW Maintained 1 :: 45 99x Cora St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
18887 259638 DPW Maintained 1 :: 45 99x Arleta Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
19114 259651 DPW Maintained 1 :: 45 598x Rutland St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
410 183338 DPW Maintained 1 :: 45 1200 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5980889.0479 2106803.3028 37.7637711641625 -122.509312865514 (37.7637711641625, -122.509312865514) 1 8 3 56 35
121158 183255 DPW Maintained 1 :: 45 1300 La Playa 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5980911.3073 2106159.7216 37.7620053885736 -122.509188082818 (37.7620053885736, -122.509188082818) 1 8 3 56 35
133142 183254 DPW Maintained 1 :: 45 1300 La Playa 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5980911.6607 2106131.1023 37.7619268290686 -122.509184735204 (37.7619268290686, -122.509184735204) 1 8 3 56 35
87872 183251 DPW Maintained 1 :: 45 1370 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5980924.7337 2105743.1516 37.7608623989944 -122.509110712256 (37.7608623989944, -122.509110712256) 1 8 3 56 35
79520 183258 DPW Maintained 1 :: 45 1386 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5980928.6203 2105658.3536 37.7606297972314 -122.509090973483 (37.7606297972314, -122.509090973483) 1 8 3 56 35
129595 183633 DPW Maintained 1 :: 45 1448 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5980945.5944 2105199.3929 37.759370623772 -122.508998188697 (37.759370623772, -122.508998188697) 1 8 3 56 35
146510 183256 Undocumented 4 :: 45 4741 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5980967.1327 2106185.8677 37.7620804693646 -122.508996949452 (37.7620804693646, -122.508996949452) 1 8 3 56 35
87094 184183 DPW Maintained 1 :: 45 1626 Lower Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5980986.1522 2103988.6176 37.7560485722666 -122.508768028257 (37.7560485722666, -122.508768028257) 1 8 3 56 35
100827 184184 DPW Maintained 1 :: 45 1642 Lower Great Hwy 1 Sidewalk: Curb side : Pot Tree Private 2     0 Width 0ft   5980990.4302 2103889.7643 37.7557774014806 -122.508745894794 (37.7557774014806, -122.508745894794) 1 8 3 56 35
102256 184579 DPW Maintained 1 :: 45 1726 Lower Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981040.0278 2103288.2098 37.7541286275124 -122.508529718341 (37.7541286275124, -122.508529718341) 1 8 3 56 35
64345 184582 DPW Maintained 1 :: 45 1730 Lower Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981040.9483 2103264.2784 37.754062972946 -122.508524758632 (37.754062972946, -122.508524758632) 1 8 3 56 35
29153 184488 DPW Maintained 1 :: 45 1850 Lower Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981108.2951 2102469.7488 37.7518853891009 -122.508232891189 (37.7518853891009, -122.508232891189) 1 8 3 56 35
91560 184171 DPW Maintained 1 :: 45 4230 Lawton St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981117.7231 2104203.7543 37.7566470308009 -122.508328988935 (37.7566470308009, -122.508328988935) 1 8 3 56 35
155106 184509 DPW Maintained 1 :: 45 1886 Lower Great Hwy 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981125.5546 2102268.3878 37.7513335258509 -122.508158262434 (37.7513335258509, -122.508158262434) 1 8 3 56 35
25907 184504 DPW Maintained 1 :: 45 1878 Lower Great Hwy 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981125.893 2102290.0468 37.751393015279 -122.508158699645 (37.751393015279, -122.508158699645) 1 8 3 56 35
12463 184537 DPW Maintained 1 :: 45 1920 Lower Great Hwy 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981149.921 2101972.2688 37.7505219025706 -122.508052026926 (37.7505219025706, -122.508052026926) 1 8 3 29491 35
134670 184524 DPW Maintained 1 :: 45 1984 Lower Great Hwy 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981181.0558 2101584.0989 37.7494579320564 -122.507915558212 (37.7494579320564, -122.507915558212) 1 8 3 29491 35
146397 184529 DPW Maintained 1 :: 45 1996 Lower Great Hwy 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981188.5011 2101512.3535 37.7492613780766 -122.507884488919 (37.7492613780766, -122.507884488919) 1 8 3 29491 35
184827 184392 DPW Maintained 1 :: 45 2040 Lower Great Hwy 1 Sidewalk: Curb side : Pot Tree Private 2     0 Width 0ft   5981213.3751 2101162.7638 37.7483029686657 -122.50777253673 (37.7483029686657, -122.50777253673) 1 8 3 29491 35
93229 184397 DPW Maintained 1 :: 45 2048 Lower Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981217.0977 2101115.7232 37.748174027723 -122.507756174046 (37.748174027723, -122.507756174046) 1 8 3 29491 35
26004 184731 DPW Maintained 1 :: 45 1531 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981237.2508 2104496.4966 37.7574578608752 -122.507937351177 (37.7574578608752, -122.507937351177) 1 8 3 56 35
140298 184177 DPW Maintained 1 :: 45 1605 48th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981248.1823 2104131.4737 37.7564562562261 -122.507872457928 (37.7564562562261, -122.507872457928) 1 8 3 56 35
39172 184634 DPW Maintained 1 :: 45 4100x Noriega St 1 Median : Cutout Tree DPW 1     0 Width 0ft   5981271.0577 2102821.0876 37.7528596561113 -122.507696113948 (37.7528596561113, -122.507696113948) 1 8 3 56 35
125845 184730 DPW Maintained 1 :: 45 1526 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981274.3167 2104688.5654 37.7579874108033 -122.507823417876 (37.7579874108033, -122.507823417876) 1 8 3 56 35
87463 181597 DPW Maintained 1 :: 45 1402 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981283.949 2105512.8626 37.7602512624102 -122.507851276945 (37.7602512624102, -122.507851276945) 1 8 3 56 35
21628 184633 DPW Maintained 1 :: 45 1817 48th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981297.1345 2102687.6924 37.7524949268988 -122.50759603982 (37.7524949268988, -122.50759603982) 1 8 3 56 35
146583 184528 DPW Maintained 1 :: 45 1961 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981337.7451 2101542.4731 37.7493528701871 -122.507370643946 (37.7493528701871, -122.507370643946) 1 8 3 29491 35
104157 117313 DPW Maintained 1 :: 45 883 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5981355.6 2109736.3 37.7718518197324 -122.507916915131 (37.7718518197324, -122.507916915131) 11 6 2 55 26
128827 184454 DPW Maintained 1 :: 45 2153 48th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981374.6331 2100381.1786 37.7461664541179 -122.507156946857 (37.7461664541179, -122.507156946857) 1 8 3 29491 35
19873 184531 DPW Maintained 1 :: 45 4043 Ortega St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981413.5516 2102117.7901 37.7509369936281 -122.507151182389 (37.7509369936281, -122.507151182389) 1 8 3 29491 35
133921 184452 DPW Maintained 1 :: 45 2142 48th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981413.7208 2100483.5512 37.7464498427269 -122.507029381635 (37.7464498427269, -122.507029381635) 1 8 3 29491 35
68941 184172 DPW Maintained 1 :: 45 4145 Lawton St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981416.401 2104160.656 37.7565462922692 -122.507292873512 (37.7565462922692, -122.507292873512) 1 8 3 56 35
158343 184474 DPW Maintained 1 :: 45 2186 48th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981423.3658 2100215.0135 37.745713081334 -122.506976114504 (37.745713081334, -122.506976114504) 1 8 3 29491 35
235 184469 DPW Maintained 1 :: 45 2182 48th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981423.7042 2100234.3036 37.7457660664858 -122.506976375045 (37.7457660664858, -122.506976375045) 1 8 3 29491 35
59973 184515 DPW Maintained 1 :: 45 4042 Ortega St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981427.7653 2102174.645 37.7510939382872 -122.507106248147 (37.7510939382872, -122.507106248147) 1 8 3 56 35
154606 184371 DPW Maintained 1 :: 45 2282 48th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981448.1763 2099546.5215 37.7438790499345 -122.506840749339 (37.7438790499345, -122.506840749339) 1 8 3 29491 35
31704 111759 DPW Maintained 1 :: 45 1235 47th Ave 2 Sidewalk: Curb side : Yard Landscaping Private 2   06/23/2015 12:00:00 AM 3 6x4   5981472.7 2106671.7 37.7634442160317 -122.507284463143 (37.7634442160317, -122.507284463143) 1 8 3 56 35
152691 111758 DPW Maintained 1 :: 45 1235 47th Ave 1 Sidewalk: Curb side : Cutout Landscaping Private 2   06/23/2015 12:00:00 AM 3 6x6   5981472.7 2106671.7 37.7634442160317 -122.507284463143 (37.7634442160317, -122.507284463143) 1 8 3 56 35
150823 183287 DPW Maintained 1 :: 45 1259 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981476.8749 2106516.0091 37.7630169795519 -122.507258472509 (37.7630169795519, -122.507258472509) 1 8 3 56 35
126808 183114 DPW Maintained 1 :: 45 3650 Santiago St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981483.4357 2099456.1026 37.7436328611158 -122.506712127755 (37.7436328611158, -122.506712127755) 1 8 3 29491 35
42492 183041 DPW Maintained 1 :: 45 2518 Lower Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981505.7715 2097922.8827 37.7394243796804 -122.506521214497 (37.7394243796804, -122.506521214497) 1 8 3 29491 35
37983 183044 DPW Maintained 1 :: 45 2538 Lower Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981509.8326 2097796.9898 37.7390789516657 -122.506497839366 (37.7390789516657, -122.506497839366) 1 8 3 29491 35
81816 118419 Undocumented 4 :: 45 5507 Anza St 1 Sidewalk: Curb side : Yard Tree Private 2       Width 3ft   5981562.4785 2111629.449 37.7770620385939 -122.507341801673 (37.7770620385939, -122.507341801673) 11 6 2 55 26
24404 183637 DPW Maintained 1 :: 45 1478 47th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981569.3227 2105033.4266 37.7589516777082 -122.506828758953 (37.7589516777082, -122.506828758953) 1 8 3 56 35
166230 184188 DPW Maintained 1 :: 45 1659 47th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981571.3272 2103786.0218 37.7555267773851 -122.506729307239 (37.7555267773851, -122.506729307239) 1 8 3 56 35
224 183657 DPW Maintained 1 :: 45 1490 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981573.7378 2104946.7308 37.7587138957913 -122.506807059304 (37.7587138957913, -122.506807059304) 1 8 3 56 35
160436 184191 DPW Maintained 1 :: 45 1679 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981575.9108 2103660.4307 37.7551822097756 -122.506704141531 (37.7551822097756, -122.506704141531) 1 8 3 56 35
129560 184123 DPW Maintained 1 :: 45 1566 47th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981590.4236 2104415.507 37.7572562892484 -122.506709953101 (37.7572562892484, -122.506709953101) 1 8 3 56 35
104571 183315 DPW Maintained 1 :: 45 4540 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981596.8931 2106261.3364 37.7623247898963 -122.506824486966 (37.7623247898963, -122.506824486966) 1 8 3 56 35
121385 119124 Undocumented 4 :: 45 601 46th Ave 3 Sidewalk: Property side : Yard Tree Private 2       Width 5ft   5981605.53063 2111566.74083 37.7768923962204 -122.507188220302 (37.7768923962204, -122.507188220302) 11 6 2 55 26
133535 184618 DPW Maintained 1 :: 45 3900x Noriega St 1 Median : Cutout Tree DPW 1     0 Width 0ft   5981674.4395 2102837.4254 37.7529282714167 -122.506302380507 (37.7529282714167, -122.506302380507) 1 8 3 56 35
150270 118550 Undocumented 4 :: 45 8140 Geary Blvd 3 Side Yard : Yard Tree Private 2           5981686.0706 2112397.37669 37.7791778206923 -122.506971243035 (37.7791778206923, -122.506971243035) 11 6 2 55 26
129602 184372 DPW Maintained 1 :: 45 2263 47th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981709.435 2099687.8805 37.7442825640676 -122.50594787141 (37.7442825640676, -122.50594787141) 1 8 3 29491 35
192677 184154 DPW Maintained 1 :: 45 4036 Lawton St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981710.2029 2104227.1296 37.7567461108743 -122.506281748334 (37.7567461108743, -122.506281748334) 1 8 3 56 35
117060 184467 DPW Maintained 1 :: 45 2182 47th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981733.5294 2100249.3634 37.7458256579494 -122.505906179147 (37.7458256579494, -122.505906179147) 1 8 3 29491 35
84238 184505 DPW Maintained 1 :: 45 3940 Ortega St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981746.2202 2102187.1666 37.7511470696737 -122.506005945548 (37.7511470696737, -122.506005945548) 1 8 3 56 35
188912 184421 DPW Maintained 1 :: 45 3741 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981751.4657 2100769.1792 37.7472539827413 -122.505882690421 (37.7472539827413, -122.505882690421) 1 8 3 29491 35
154910 183195 DPW Maintained 1 :: 45 2467 47th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981757.2189 2098306.9914 37.7404938379124 -122.505680301686 (37.7404938379124, -122.505680301686) 1 8 3 29491 35
18947 183207 DPW Maintained 1 :: 45 2487 47th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981762.9721 2098176.699 37.7401364295663 -122.505650753582 (37.7401364295663, -122.505650753582) 1 8 3 29491 35
91590 183170 DPW Maintained 1 :: 45 2382 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981781.9237 2098892.7996 37.74210375914 -122.505638298262 (37.74210375914, -122.505638298262) 1 8 3 29491 35
185065 183277 DPW Maintained 1 :: 45 1255 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981785.9112 2106543.1909 37.7631098104891 -122.506191655726 (37.7631098104891, -122.506191655726) 1 8 3 56 35
79461 184423 DPW Maintained 1 :: 45 3737 Quintara St 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981790.0458 2100770.5329 37.7472599703804 -122.505749385983 (37.7472599703804, -122.505749385983) 1 8 3 29491 35
2785 261137 DPW Maintained 1 :: 45 2454 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5981796.50413 2098381.86438 37.7407017304597 -122.505550019662 (37.7407017304597, -122.505550019662) 1 8 3 29491 35
50028 183186 DPW Maintained 1 :: 45 2446 47th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981797.1527 2098421.378 37.7408102621103 -122.505550705456 (37.7408102621103, -122.505550705456) 1 8 3 29491 35
446 182929 DPW Maintained 1 :: 45 2635 47th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981797.6603 2097141.2975 37.73729554361 -122.505454091008 (37.73729554361, -122.505454091008) 1 8 3 29491 35
49042 182938 DPW Maintained 1 :: 45 2657 47th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981803.7519 2096965.6566 37.7368136403966 -122.505420015001 (37.7368136403966, -122.505420015001) 1 8 3 29491 35
120371 184424 DPW Maintained 1 :: 45 3735 Quintara St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981804.598 2100770.5329 37.7472608268582 -122.505699066436 (37.7472608268582, -122.505699066436) 1 8 3 29491 35
70806 183210 DPW Maintained 1 :: 45 2494 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981807.3053 2098133.0426 37.7400191702032 -122.505494234875 (37.7400191702032, -122.505494234875) 1 8 3 29491 35
84006 183206 DPW Maintained 1 :: 45 2486 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981807.3053 2098184.1443 37.7401594813682 -122.50549802177 (37.7401594813682, -122.50549802177) 1 8 3 29491 35
276 182945 DPW Maintained 1 :: 45 2691 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981809.5051 2096798.8146 37.7363558765881 -122.50538776138 (37.7363558765881, -122.50538776138) 1 8 3 29491 35

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);