trees

979 rows where qSpecies_id = 13 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)
5226 259803 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 199x Harkness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
12808 254368 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 590X Orizaba Ave 1 Back Yard : Yard Tree Private 2   02/06/2018 12:00:00 AM 3   Permit Number 778929                    
15038 259861 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 201x Wilde Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
15229 259804 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 199x Harkness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
15796 260912 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 99x Belvedere St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/21/2019 12:00:00 AM 3                        
19358 259860 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 201x Wilde Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
187522 109253 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1355 46th Ave 1 Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773041 5981790.7 2105864.5 37.7612466017789 -122.506124767382 (37.7612466017789, -122.506124767382) 1 8 3 56 35
4879 260889 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 527 45th Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/18/2019 12:00:00 AM 3     5981905.91133 2112171.65096 37.7785709887537 -122.506193994794 (37.7785709887537, -122.506193994794) 11 6 2 55 26
42827 253341 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1935 46th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   08/23/2017 12:00:00 AM 3 3x3 Permit Number 769984 5981944.68101 2101921.14451 37.7504283278742 -122.505299944249 (37.7504283278742, -122.505299944249) 1 8 3 29491 35
6875 260888 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 528 45th Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/18/2019 12:00:00 AM 3     5981946.38688 2112159.7169 37.7785406040131 -122.50605309173 (37.7785406040131, -122.50605309173) 11 6 2 55 26
145486 70167 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 831 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2015 12:00:00 AM 3   Permit Number 773700 5981976.78091 2110066.45395 37.772794906459 -122.505792724366 (37.772794906459, -122.505792724366) 11 6 2 55 26
64385 109276 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1558 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773739 5982234.4 2104492.8 37.7575064130321 -122.504488595501 (37.7575064130321, -122.504488595501) 1 8 3 56 35
34068 119038 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 675 44th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5982249.27103 2111200.72651 37.7759253222044 -122.504934234985 (37.7759253222044, -122.504934234985) 11 6 2 55 26
159524 118718 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 818 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5982331.02075 2110159.51383 37.7730712650544 -122.504574285424 (37.7730712650544, -122.504574285424) 11 6 2 55 26
1513 146932 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 619 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2020 12:30:00 PM 0 Width 3ft   5982546.66357 2111553.12275 37.7769103910512 -122.503931600958 (37.7769103910512, -122.503931600958) 11 6 2 55 26
71691 108663 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 842 43rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/2014 12:00:00 AM 3 3x3 Permit Number 772817 5982645.59315 2110033.99041 37.7727451127869 -122.503476861251 (37.7727451127869, -122.503476861251) 11 6 2 55 26
68669 108662 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 842 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/2014 12:00:00 AM 3 3x3 Permit Number 772817 5982646.66004 2110014.02816 37.7726903649612 -122.503471692361 (37.7726903649612, -122.503471692361) 11 6 2 55 26
4904 144219 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 876 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3 Width 4ft   5982678 2109818 37.7721539708604 -122.503348768347 (37.7721539708604, -122.503348768347) 11 6 2 55 26
134045 47432 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 432 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM 2   Permit Number 45343 5982855.38785 2112869.93479 37.7805441204791 -122.50296115463 (37.7805441204791, -122.50296115463) 11 6 2 55 26
142885 87269 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 4109 Irving St   Sidewalk: Curb side : Cutout Tree Private 2   03/07/2008 12:00:00 AM   3x3 Permit Number 50292 5983031 2106268 37.7624274331393 -122.50186502168 (37.7624274331393, -122.50186502168) 1 8 3 56 35
127507 107673 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 834 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2014 12:00:00 AM 3 3x3 Permit Number 772907 5983266.37919 2110104.76952 37.7729759278402 -122.501334764681 (37.7729759278402, -122.501334764681) 11 6 2 55 26
7356 71615 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 536 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     5983503.66193 2112151.1699 37.7786086821922 -122.500665338334 (37.7786086821922, -122.500665338334) 11 6 2 55 26
7146 112795 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1235 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2015 12:00:00 AM   3x3   5983624.1 2106731.7 37.7637354441658 -122.499848016409 (37.7637354441658, -122.499848016409) 1 8 3 56 35
10191 117755 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 406 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2020 12:00:00 AM 3 Width 4ft   5983780.25118 2113048.87393 37.7810897498012 -122.499774894099 (37.7810897498012, -122.499774894099) 11 6 2 55 26
3141 117754 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 406 39th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   5983780.49053 2113060.07342 37.7811205143771 -122.499774894109 (37.7811205143771, -122.499774894109) 11 6 2 55 26
138912 87490 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 496 38th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2008 12:00:00 AM 1 3x3 Permit Number 50390 5984109.08074 2112532.54052 37.7796913388582 -122.498599173652 (37.7796913388582, -122.498599173652) 11 6 2 55 26
156666 87489 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 496 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2008 12:00:00 AM 1 3x3 Permit Number 50390 5984109.09334 2112519.44129 37.7796553729161 -122.498598162167 (37.7796553729161, -122.498598162167) 11 6 2 55 26
9277 85291 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 7350 Geary Blvd   Sidewalk: Curb side : Cutout Tree Private 2   07/24/2007 12:00:00 AM 2 4x72 Permit Number 49578 5984127.30348 2112512.4695 37.779637298343 -122.498534651264 (37.779637298343, -122.498534651264) 11 6 2 55 26
155734 105250 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 500 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2014 12:00:00 AM 1   Permit Number 771049 5984731.6893 2112357.91416 37.7792483592825 -122.496432443475 (37.7792483592825, -122.496432443475) 11 6 2 55 26
40035 105251 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 500 36th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2014 12:00:00 AM 1   Permit Number 771049 5984733.08187 2112389.43293 37.7793349822998 -122.496429952441 (37.7793349822998, -122.496429952441) 11 6 2 55 26
97176 106368 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 426 Country Club Dr   Sidewalk: Property side : Yard Tree Private 2   04/23/2014 12:00:00 AM     Permit Number 770073 5984817.1 2094918.3 37.731369010287 -122.494850794258 (37.731369010287, -122.494850794258) 1 8 4 64 35
180587 78302 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 575 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/17/2013 12:00:00 AM 2 3x3 Permit Number 770704 5985015.95011 2111950.61478 37.7781466811201 -122.49541903513 (37.7781466811201, -122.49541903513) 11 6 2 55 26
82285 118202 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 744 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5985103.04881 2110791.51915 37.774969236334 -122.495032243047 (37.774969236334, -122.495032243047) 11 6 2 55 26
175263 118073 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 449 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5985293.2738 2112845.54418 37.7806201339604 -122.494525675852 (37.7806201339604, -122.494525675852) 11 6 2 55 26
17426 261374 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 479 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2020 12:00:00 AM 3 Width 3ft   5985580 2112677 37.7801741370735 -122.493521345038 (37.7801741370735, -122.493521345038) 11 6 2 55 26
125836 69450 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 438 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/16/1994 12:00:00 AM 3   Permit Number 33560 5985645.83858 2112922.47586 37.780851994355 -122.493311672832 (37.780851994355, -122.493311672832) 11 6 2 55 26
48862 87126 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 438 33rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2008 12:00:00 AM   3x3 Permit Number 50074 5985668.2 2112929.7 37.7808731376826 -122.493234847229 (37.7808731376826, -122.493234847229) 11 6 2 55 26
9454 260881 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 751 33rd Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/18/2019 12:00:00 AM 3     5985678.2622 2110774.56948 37.7749563544765 -122.493041236092 (37.7749563544765, -122.493041236092) 11 6 2 55 26
188424 143862 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3141 Clement St 1 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 4ft   5985712.91878 2113178.76157 37.781559604533 -122.493098498008 (37.781559604533, -122.493098498008) 11 6 2 55 26
132302 143863 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3131 Clement St 1 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 4ft   5985738.04922 2113178.19583 37.78155952089 -122.493011518265 (37.78155952089, -122.493011518265) 11 6 2 55 26
166987 254106 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3129 Clement St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x4   5985757 2113159 37.7815079229311 -122.492944544174 (37.7815079229311, -122.492944544174) 11 6 2 55 26
151406 143864 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3123 Clement St 1 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 4ft   5985786.64325 2113178.68848 37.7815637153323 -122.492843444866 (37.7815637153323, -122.492843444866) 11 6 2 55 26
139510 254105 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3107 Clement St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   5985853 2113163 37.7815245194182 -122.492612729734 (37.7815245194182, -122.492612729734) 11 6 2 55 26
9085 119446 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 885 32nd Ave 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 6ft   5985992 2109886 37.7725349378609 -122.491890533583 (37.7725349378609, -122.491890533583) 11 6 2 55 26
148647 96861 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 387 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/02/2011 12:00:00 AM 2 3x3 Permit Number 768142 5986826.57443 2113361.96386 37.7821276946473 -122.489259307913 (37.7821276946473, -122.489259307913) 11 6 2 55 26
65286 96862 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 387 29th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   08/02/2011 12:00:00 AM 2 3x3 Permit Number 768142 5986827.80548 2113344.76478 37.7820805427479 -122.48925378416 (37.7820805427479, -122.48925378416) 11 6 2 55 26
52039 250725 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2715 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3 Width 4ft Permit Number 782755 5987015.16529 2114429.97132 37.7850711441675 -122.488685403333 (37.7850711441675, -122.488685403333) 11 6 1 55 33
89454 254862 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2715 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3 Width 4ft Permit Number 782755 5987015.16529 2114429.97132 37.7850711441675 -122.488685403333 (37.7850711441675, -122.488685403333) 11 6 1 55 33
102182 253344 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2586 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2017 12:00:00 AM 3 4x4 Permit Number 780063 5987098.36417 2097677.28593 37.7390777358027 -122.487166705945 (37.7390777358027, -122.487166705945) 1 8 3 29491 35
67540 49737 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 251 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2003 12:00:00 AM 3 3x12 Permit Number 46536 5987104.42255848 2114202.9919751 37.7844531321546 -122.488359918659 (37.7844531321546, -122.488359918659) 11 6 1 55 33
101443 49736 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 251 28th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2003 12:00:00 AM 3 3x12 Permit Number 46536 5987104.42255848 2114202.9919751 37.7844531321546 -122.488359918659 (37.7844531321546, -122.488359918659) 11 6 1 55 33
125740 109037 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1306 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772801 5987138.4 2106347.4 37.7628858653346 -122.487665061189 (37.7628858653346, -122.487665061189) 1 8 3 56 35
35091 95932 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 218 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2011 12:00:00 AM 3 3x3 Permit Number 767629 5987170.3 2114494.3 37.7852568239907 -122.488153421892 (37.7852568239907, -122.488153421892) 11 6 1 55 33
109181 109089 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 218 28th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2 3x3   5987170.3 2114494.3 37.7852568239907 -122.488153421892 (37.7852568239907, -122.488153421892) 11 6 1 55 33
135375 109088 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 218 28th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5987170.3 2114494.3 37.7852568239907 -122.488153421892 (37.7852568239907, -122.488153421892) 11 6 1 55 33
38675 109898 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1786 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/2015 12:00:00 AM 3 3x3 Permit Number 775112 5987249.9 2103123.1 37.7540393206485 -122.487042615101 (37.7540393206485, -122.487042615101) 1 8 3 56 35
89243 48772 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 766 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/22/2002 12:00:00 AM 2   Permit Number 46029 5987276.54902 2110739.79263 37.7749542102717 -122.487509936801 (37.7749542102717, -122.487509936801) 11 6 2 55 26
117947 108633 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2610 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774602 5987336.48113 2114673.56953 37.7857587403195 -122.487591667787 (37.7857587403195, -122.487591667787) 11 6 1 55 33
49648 143618 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3634 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   5987351.65597 2111892.16723 37.7781226861604 -122.487334792473 (37.7781226861604, -122.487334792473) 11 6 2 55 26
2308 144457 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 566 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/13/2019 12:00:00 AM 3 4x6   5987536.08738 2112106.24218 37.7787212290426 -122.486712509289 (37.7787212290426, -122.486712509289) 11 6 2 55 26
14012 261007 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 566 27th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/13/2019 12:00:00 AM 3 4x6   5987536.08738 2112106.24218 37.7787212290426 -122.486712509289 (37.7787212290426, -122.486712509289) 11 6 2 55 26
194351 265046 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1250 Eucalyptus Dr 4 Sidewalk: Property side : Yard Tree Private 2   12/17/2020 12:00:00 AM 3 5x10 Permit Number 781946 5987698.06233 2094734.87015 37.7310335805158 -122.484877445397 (37.7310335805158, -122.484877445397) 1 8 4 64 35
132118 147269 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 319 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 4ft   5987740.91933 2113799.84011 37.7833833082347 -122.48612828182 (37.7833833082347, -122.48612828182) 11 6 2 55 26
184483 105717 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 409 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   5987766.35137 2113121.02315 37.7815209517603 -122.485990454458 (37.7815209517603, -122.485990454458) 11 6 2 55 26
184918 120093 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 655 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5987822.40031 2111507.4982 37.7770939337825 -122.485678099475 (37.7770939337825, -122.485678099475) 11 6 2 55 26
104335 120377 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 101 25th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5987995.99107 2115194.27342 37.7872268871617 -122.485348201277 (37.7872268871617, -122.485348201277) 11 6 1 55 33
53557 67205 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 123 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1992 12:00:00 AM 3   Permit Number 30659 5987996.0292 2115149.70283 37.7871045112839 -122.485344797558 (37.7871045112839, -122.485344797558) 11 6 1 55 33
47323 120376 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 123 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5987996.34408 2115176.14425 37.787177130209 -122.485345649143 (37.787177130209, -122.485345649143) 11 6 1 55 33
124215 95926 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 651 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2011 12:00:00 AM   3x3 Permit Number 767623 5988426.1 2111542.8 37.7772260199912 -122.483592327097 (37.7772260199912, -122.483592327097) 11 6 2 55 26
87714 93189 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 651 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/18/2010 12:00:00 AM 3 3x3 Permit Number 53197 5988441.61799 2111543.24899 37.7772281560188 -122.483538678985 (37.7772281560188, -122.483538678985) 11 6 2 55 26
50268 120234 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 896 24th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5988543.40273 2109982.31108 37.7729481790861 -122.483072139836 (37.7729481790861, -122.483072139836) 11 6 2 55 26
7414 70266 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 414 23rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5988762.33088 2112478.21963 37.7798139854521 -122.482497769619 (37.7798139854521, -122.482497769619) 11 6 2 55 26
112971 120406 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 619 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5988769.80583 2111094.18017 37.7760142347438 -122.482370474729 (37.7760142347438, -122.482370474729) 11 6 2 55 26
145436 147382 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 735 23rd Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2018 12:00:00 AM 3 3x5   5988794.34162 2110291.35438 37.7738113254544 -122.482226768263 (37.7738113254544, -122.482226768263) 11 6 2 55 26
152426 450 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 700x 23rd Ave 10 Median : Cutout Tree DPW 1   05/29/2015 01:42:00 PM 3     5988819.93055 2110324.80979 37.773904673102 -122.482140704549 (37.773904673102, -122.482140704549) 11 6 2 55 26
8414 260883 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 122 22nd Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/18/2019 12:00:00 AM 3     5988999.56708 2114522.30916 37.7854402782048 -122.481826844764 (37.7854402782048, -122.481826844764) 11 6 2 55 26
21530 120427 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 459 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5989038.74655 2112201.43488 37.7790700882049 -122.481521260476 (37.7790700882049, -122.481521260476) 11 6 2 55 26
53593 120793 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 559 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5989373.68445 2111524.6737 37.7772313596652 -122.48031303989 (37.7772313596652, -122.48031303989) 11 6 2 55 26
41966 49512 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1928& 21st AVE Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2003 12:00:00 AM 4   Permit Number 46417 5989493.41802 2113376.93915 37.7823241210106 -122.480034435471 (37.7823241210106, -122.480034435471) 11 6 2 55 26
95009 173748 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1259 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2017 12:00:00 AM 3 3x3 Permit Number 773489 5989520 2106786 37.7642287625639 -122.479460118399 (37.7642287625639, -122.479460118399) 1 8 3 56 35
120185 30531 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 100 20th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/02/1986 12:00:00 AM 2 3x3 Permit Number 34534 5989617.18715 2114630.73389 37.7857738797228 -122.479698023599 (37.7857738797228, -122.479698023599) 11 6 2 55 26
151513 61491 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 178 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/11/1990 12:00:00 AM 3   Permit Number 28869 5989634.7512 2114171.84464 37.7845149192342 -122.479603669936 (37.7845149192342, -122.479603669936) 11 6 2 55 26
29714 65128 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 184 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/31/2008 12:00:00 AM 3 3x3 Permit Number 50320 5989636.73328 2114131.59369 37.7844045165702 -122.47959386665 (37.7844045165702, -122.47959386665) 11 6 2 55 26
6589 44716 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1879 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/08/2020 12:00:00 AM 3   Permit Number 43838 5989679.8369 2102593.1522 37.7527256083507 -122.478600649693 (37.7527256083507, -122.478600649693) 1 8 3 56 35
1560 258220 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 477 Eucalyptus Dr 2 Sidewalk: Property side : Cutout Tree Private 2   07/03/2019 12:00:00 AM 3 3x3 Permit Number 774069 5989683 2094686 37.7310148065902 -122.478011682019 (37.7310148065902, -122.478011682019) 1 8 4 64 14
18060 258219 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 477 Eucalyptus Dr 1 Sidewalk: Property side : Cutout Tree Private 2   07/03/2019 12:00:00 AM 3 3x3 Permit Number 774069 5989683 2094686 37.7310148065902 -122.478011682019 (37.7310148065902, -122.478011682019) 1 8 4 64 14
12397 264812 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2270 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2020 12:00:00 AM 3 3x3   5989815 2099915 37.745379953303 -122.477937465434 (37.745379953303, -122.477937465434) 1 8 3 29491 35
137284 46093 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 100 19th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2001 12:00:00 AM 4   Permit Number 44465 5989926.67635 2114640.81602 37.785819536272 -122.478628027687 (37.785819536272, -122.478628027687) 11 6 2 55 26
178900 121810 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 106 19th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5989928.89895 2114601.72994 37.7857123459232 -122.478617478776 (37.7857123459232, -122.478617478776) 11 6 2 55 26
14232 90568 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1818 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/14/2019 12:00:00 AM 3 3x3   5989946.28172 2110622.60957 37.7747877973492 -122.478266291409 (37.7747877973492, -122.478266291409) 11 6 2 55 26
35612 255646 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1542 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2018 12:00:00 AM 3 3x5 Permit Number 779777 5989956.05847 2104865.26605 37.7589802621415 -122.477811515827 (37.7589802621415, -122.477811515827) 1 8 3 56 35
73635 98412 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 55 19th Ave 4 Sidewalk: Curb side : Tree Private 2   02/09/2012 12:00:00 AM     Permit Number 768592 5990099.2 2106073.1 37.7623049568555 -122.477404745944 (37.7623049568555, -122.477404745944) 1 8 3 56 35
76660 98411 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 55 19th Ave 3 Sidewalk: Curb side : Tree Private 2   02/09/2012 12:00:00 AM     Permit Number 768592 5990099.2 2106073.1 37.7623049568555 -122.477404745944 (37.7623049568555, -122.477404745944) 1 8 3 56 35
80624 98410 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 55 19th Ave 2 Sidewalk: Curb side : Tree Private 2   02/09/2012 12:00:00 AM     Permit Number 768592 5990099.2 2106073.1 37.7623049568555 -122.477404745944 (37.7623049568555, -122.477404745944) 1 8 3 56 35
4564 264686 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2455 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/15/2020 12:00:00 AM 3 3x3 Permit Number 782284 5990129.23032 2098669.31502 37.7419778589065 -122.476759924113 (37.7419778589065, -122.476759924113) 1 8 3 29491 35
180872 122238 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1645 Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2018 12:00:00 AM 3 Width 5ft   5990263.53816 2114709.99218 37.786029027112 -122.477467650491 (37.786029027112, -122.477467650491) 11 6 2 55 26
47632 208834 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1669 18th Ave 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 3ft   5990551.61783 2104055.61326 37.7567917168824 -122.475692689987 (37.7567917168824, -122.475692689987) 1 8 4 56 12
189780 95071 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 319 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2011 12:00:00 AM 1 3x3 Permit Number 767740 5990554.377 2113243.49278 37.7820193005134 -122.476354274932 (37.7820193005134, -122.476354274932) 11 6 2 55 26
147161 208833 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1655 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5990561.21502 2104064.77483 37.7568174285108 -122.475660168683 (37.7568174285108, -122.475660168683) 1 8 4 56 12
22578 108523 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1655 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773674 5990561.39992 2104128.43771 37.7569922406164 -122.475664177859 (37.7569922406164, -122.475664177859) 1 8 4 56 12

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)
);