Street_Tree_List

Data source: data.sfgov.org

830 rows where qSpecies = 88 sorted by XCoord

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord ▼ YCoord Latitude Longitude Location
123584 109253 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1355 46th Ave 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1 FUF 1 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773041 5981790.7 2105864.5 37.7612466017789 -122.50612476738199 (37.7612466017789, -122.506124767382)
5195 253341 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1935 46th Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   08/23/2017 12:00:00 AM 3 3x3 Permit Number 769984 5981944.6810099995 2101921.14451 37.750428327874204 -122.505299944249 (37.7504283278742, -122.505299944249)
125226 70167 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 831 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/2015 12:00:00 AM 3   Permit Number 773700 5981976.78091 2110066.45395 37.772794906459 -122.505792724366 (37.772794906459, -122.505792724366)
106309 109276 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1558 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773739 5982234.4 2104492.8 37.757506413032104 -122.504488595501 (37.7575064130321, -122.504488595501)
184438 119038 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 675 44th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5982249.27103 2111200.72651 37.7759253222044 -122.50493423498501 (37.7759253222044, -122.504934234985)
59077 118718 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 818 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5982331.02075 2110159.51383 37.7730712650544 -122.504574285424 (37.7730712650544, -122.504574285424)
103987 108663 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 842 43rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/30/2014 12:00:00 AM 3 3x3 Permit Number 772817 5982645.59315 2110033.9904099996 37.7727451127869 -122.50347686125099 (37.7727451127869, -122.503476861251)
98622 108662 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 842 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/30/2014 12:00:00 AM 3 3x3 Permit Number 772817 5982646.66004 2110014.0281599998 37.77269036496121 -122.50347169236099 (37.7726903649612, -122.503471692361)
52541 47432 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 432 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 2   Permit Number 45343 5982855.38785 2112869.9347900003 37.7805441204791 -122.50296115463001 (37.7805441204791, -122.50296115463)
110968 87269 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 4109 Irving St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/07/2008 12:00:00 AM   3x3 Permit Number 50292 5983031.0 2106268.0 37.762427433139294 -122.50186502168002 (37.7624274331393, -122.50186502168)
96439 107673 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 834 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/09/2014 12:00:00 AM 3 3x3 Permit Number 772907 5983266.37919 2110104.76952 37.77297592784021 -122.50133476468099 (37.7729759278402, -122.501334764681)
174370 71615 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 536 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/14/1995 12:00:00 AM 2     5983503.66193 2112151.1699 37.7786086821922 -122.500665338334 (37.7786086821922, -122.500665338334)
81380 112795 Section 143 8 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1235 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/20/2015 12:00:00 AM   3x3   5983624.1 2106731.7 37.763735444165796 -122.49984801640899 (37.7637354441658, -122.499848016409)
68243 87490 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 496 38th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/16/2008 12:00:00 AM 1 3x3 Permit Number 50390 5984109.08074 2112532.5405200003 37.77969133885821 -122.498599173652 (37.7796913388582, -122.498599173652)
173728 87489 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 496 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/16/2008 12:00:00 AM 1 3x3 Permit Number 50390 5984109.09334 2112519.44129 37.7796553729161 -122.498598162167 (37.7796553729161, -122.498598162167)
50948 85291 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 7350 Geary Blvd   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2007 12:00:00 AM 2 4x72 Permit Number 49578 5984127.30348 2112512.4695 37.779637298343 -122.498534651264 (37.779637298343, -122.498534651264)
180284 105250 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 500 36th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/08/2014 12:00:00 AM 1   Permit Number 771049 5984731.6893 2112357.9141599997 37.7792483592825 -122.496432443475 (37.7792483592825, -122.496432443475)
171597 105251 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 500 36th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/08/2014 12:00:00 AM 1   Permit Number 771049 5984733.08187 2112389.43293 37.779334982299794 -122.496429952441 (37.7793349822998, -122.496429952441)
98773 106368 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 426 Country Club Dr   Sidewalk: Property side : Yard 9 Tree 1 Private 1   04/23/2014 12:00:00 AM     Permit Number 770073 5984817.1 2094918.3 37.731369010287 -122.494850794258 (37.731369010287, -122.494850794258)
168503 78302 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 575 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/17/2013 12:00:00 AM 2 3x3 Permit Number 770704 5985015.95011 2111950.61478 37.7781466811201 -122.49541903513 (37.7781466811201, -122.49541903513)
155447 118202 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 744 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5985103.04881 2110791.51915 37.774969236334 -122.495032243047 (37.774969236334, -122.495032243047)
53029 118073 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 449 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5985293.2738 2112845.5441799997 37.7806201339604 -122.49452567585199 (37.7806201339604, -122.494525675852)
66893 69450 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 438 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/16/1994 12:00:00 AM 3   Permit Number 33560 5985645.83858 2112922.4758599997 37.780851994355004 -122.493311672832 (37.780851994355, -122.493311672832)
79183 87126 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 438 33rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/08/2008 12:00:00 AM   3x3 Permit Number 50074 5985668.2 2112929.7 37.7808731376826 -122.493234847229 (37.7808731376826, -122.493234847229)
30883 119446 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 881 32nd Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 6ft   5986011.18097 2109924.94508 37.7726429911374 -122.49182705320801 (37.7726429911374, -122.491827053208)
62134 96861 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 387 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/02/2011 12:00:00 AM 2 3x3 Permit Number 768142 5986826.57443 2113361.96386 37.7821276946473 -122.489259307913 (37.7821276946473, -122.489259307913)
24130 96862 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 387 29th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/02/2011 12:00:00 AM 2 3x3 Permit Number 768142 5986827.805480001 2113344.76478 37.7820805427479 -122.48925378416 (37.7820805427479, -122.48925378416)
3174 253344 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2586 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/23/2017 12:00:00 AM 3 4x4 Permit Number 780063 5987098.36417 2097677.28593 37.7390777358027 -122.487166705945 (37.7390777358027, -122.487166705945)
90183 49737 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 251 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/2003 12:00:00 AM 3 3x12 Permit Number 46536 5987104.42255848 2114202.9919751 37.7844531321546 -122.488359918659 (37.7844531321546, -122.488359918659)
103390 49736 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 251 28th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/2003 12:00:00 AM 3 3x12 Permit Number 46536 5987104.42255848 2114202.9919751 37.7844531321546 -122.488359918659 (37.7844531321546, -122.488359918659)
102366 109037 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1306 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772801 5987138.4 2106347.4 37.7628858653346 -122.487665061189 (37.7628858653346, -122.487665061189)
99368 109089 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 218 28th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   2 3x3   5987170.3 2114494.3 37.7852568239907 -122.488153421892 (37.7852568239907, -122.488153421892)
115316 109088 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 218 28th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   3 3x3   5987170.3 2114494.3 37.7852568239907 -122.488153421892 (37.7852568239907, -122.488153421892)
126977 95932 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 218 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2011 12:00:00 AM 3 3x3 Permit Number 767629 5987170.3 2114494.3 37.7852568239907 -122.488153421892 (37.7852568239907, -122.488153421892)
22964 109898 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1786 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/09/2015 12:00:00 AM 3 3x3 Permit Number 775112 5987249.9 2103123.1 37.754039320648495 -122.48704261510099 (37.7540393206485, -122.487042615101)
29955 48772 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 766 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/22/2002 12:00:00 AM 2   Permit Number 46029 5987276.54902 2110739.79263 37.7749542102717 -122.48750993680099 (37.7749542102717, -122.487509936801)
109288 108633 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2610 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774602 5987336.48113 2114673.56953 37.7857587403195 -122.487591667787 (37.7857587403195, -122.487591667787)
117109 105717 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 409 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3   5987766.351369999 2113121.02315 37.7815209517603 -122.485990454458 (37.7815209517603, -122.485990454458)
188986 120093 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 655 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5987822.4003099995 2111507.4982 37.7770939337825 -122.485678099475 (37.7770939337825, -122.485678099475)
52885 120377 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 101 25th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5987995.9910699995 2115194.27342 37.7872268871617 -122.485348201277 (37.7872268871617, -122.485348201277)
179311 67205 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 123 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/13/1992 12:00:00 AM 3   Permit Number 30659 5987996.0292 2115149.70283 37.7871045112839 -122.485344797558 (37.7871045112839, -122.485344797558)
73825 120376 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 123 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5987996.34408 2115176.14425 37.787177130208995 -122.48534564914301 (37.787177130209, -122.485345649143)
132678 120242 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 288 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5988397.89946 2114035.20565 37.7840678224086 -122.483872680677 (37.7840678224086, -122.483872680677)
105494 95926 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 651 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2011 12:00:00 AM   3x3 Permit Number 767623 5988426.1 2111542.8 37.777226019991204 -122.483592327097 (37.7772260199912, -122.483592327097)
155904 93189 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 651 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/18/2010 12:00:00 AM 3 3x3 Permit Number 53197 5988441.61799 2111543.24899 37.77722815601879 -122.483538678985 (37.7772281560188, -122.483538678985)
159521 120234 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 896 24th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5988543.40273 2109982.31108 37.7729481790861 -122.48307213983601 (37.7729481790861, -122.483072139836)
66578 70266 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 414 23rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/17/1996 12:00:00 AM 8     5988762.33088 2112478.2196299997 37.7798139854521 -122.482497769619 (37.7798139854521, -122.482497769619)
39564 120406 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 619 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5988769.80583 2111094.18017 37.7760142347438 -122.48237047472901 (37.7760142347438, -122.482370474729)
119795 450 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 700x 23rd Ave 10 Median : Cutout 11 Tree 1 DPW 2   05/29/2015 01:42:00 PM 3     5988819.93055 2110324.8097900003 37.773904673102 -122.48214070454901 (37.773904673102, -122.482140704549)
136936 120427 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 459 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5989038.74655 2112201.43488 37.7790700882049 -122.481521260476 (37.7790700882049, -122.481521260476)
34906 120793 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 559 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5989373.68445 2111524.6737 37.7772313596652 -122.48031303988998 (37.7772313596652, -122.48031303989)
36801 49512 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1928& 21st AVE Clement St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/23/2003 12:00:00 AM 4   Permit Number 46417 5989493.41802 2113376.93915 37.7823241210106 -122.480034435471 (37.7823241210106, -122.480034435471)
9960 173748 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1259 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/13/2017 12:00:00 AM 3 3x3 Permit Number 773489 5989520.0 2106786.0 37.764228762563896 -122.47946011839899 (37.7642287625639, -122.479460118399)
83616 30531 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 100 20th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/02/1986 12:00:00 AM 2 3x3 Permit Number 34534 5989617.18715 2114630.7338900003 37.7857738797228 -122.479698023599 (37.7857738797228, -122.479698023599)
156259 61491 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 178 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/11/1990 12:00:00 AM 3   Permit Number 28869 5989634.7512 2114171.8446400003 37.784514919234205 -122.47960366993601 (37.7845149192342, -122.479603669936)
63085 65128 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 184 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/31/2008 12:00:00 AM 3 3x3 Permit Number 50320 5989636.73328 2114131.59369 37.7844045165702 -122.47959386665 (37.7844045165702, -122.47959386665)
174893 46093 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 100 19th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2001 12:00:00 AM 4   Permit Number 44465 5989926.67635 2114640.8160200003 37.785819536272 -122.478628027687 (37.785819536272, -122.478628027687)
160936 121810 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 106 19th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5989928.89895 2114601.72994 37.7857123459232 -122.478617478776 (37.7857123459232, -122.478617478776)
89118 98412 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 55 19th Ave 4 Sidewalk: Curb side : 21 Tree 1 Private 1   02/09/2012 12:00:00 AM     Permit Number 768592 5990099.2 2106073.1 37.7623049568555 -122.477404745944 (37.7623049568555, -122.477404745944)
91295 98410 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 55 19th Ave 2 Sidewalk: Curb side : 21 Tree 1 Private 1   02/09/2012 12:00:00 AM     Permit Number 768592 5990099.2 2106073.1 37.7623049568555 -122.477404745944 (37.7623049568555, -122.477404745944)
96447 98411 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 55 19th Ave 3 Sidewalk: Curb side : 21 Tree 1 Private 1   02/09/2012 12:00:00 AM     Permit Number 768592 5990099.2 2106073.1 37.7623049568555 -122.477404745944 (37.7623049568555, -122.477404745944)
181254 208834 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1669 18th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   5990551.61783 2104055.61326 37.756791716882404 -122.47569268998699 (37.7567917168824, -122.475692689987)
153587 95071 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 319 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/04/2011 12:00:00 AM 1 3x3 Permit Number 767740 5990554.377 2113243.49278 37.7820193005134 -122.476354274932 (37.7820193005134, -122.476354274932)
148326 208833 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1655 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5990561.21502 2104064.77483 37.75681742851079 -122.47566016868299 (37.7568174285108, -122.475660168683)
128305 108523 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1655 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773674 5990561.39992 2104128.4377099997 37.7569922406164 -122.475664177859 (37.7569922406164, -122.475664177859)
28196 88382 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 355 17th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM 2 3x3 Permit Number 51360 5990561.77007 2113010.94096 37.7813812065074 -122.476311706446 (37.7813812065074, -122.476311706446)
52959 208835 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1673 18th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5990563.36006 2104017.9082 37.7566888695243 -122.475649328274 (37.7566888695243, -122.475649328274)
30218 208836 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1677 18th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5990563.73281 2104000.71919 37.756641694668396 -122.47564678406499 (37.7566416946684, -122.475646784065)
122847 108524 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1669 18th Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773675 5990564.49357 2104037.4684 37.756742642361495 -122.47564683648301 (37.7567426423615, -122.475646836483)
110033 108525 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1673 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773676 5990565.37747 2104011.47717 37.7566713285758 -122.47564188182501 (37.7566713285758, -122.475641881825)
101009 12725 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1544 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/07/2003 12:00:00 AM 3 3X3   5990592.796680001 2114771.31925 37.7862165141869 -122.476332998319 (37.7862165141869, -122.476332998319)
172445 121908 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 320 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5990601.2313 2113229.42539 37.781983392499704 -122.476191154353 (37.7819833924997, -122.476191154353)
165837 101128 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 295X 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/01/2012 12:00:00 AM 1 3x3 Permit Number 769229 5990852.62725 2113482.2447900004 37.782692139400204 -122.47533991256701 (37.7826921394002, -122.475339912567)
137500 208837 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1958 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5990984.78596 2102065.3313 37.7513520289909 -122.474049439736 (37.7513520289909, -122.474049439736)
38343 122390 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1958 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     3x2   5991007.0 2102078.0 37.7513881006776 -122.47397354599501 (37.7513881006776, -122.473973545995)
106292 43751 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 255 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/24/2015 12:00:00 AM 3   Permit Number 773834 5991170.79793 2113718.28394 37.7833586747671 -122.474256417664 (37.7833586747671, -122.474256417664)
133119 122152 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 263 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   5991173.60125 2113665.4764900003 37.783213842540796 -122.474242864812 (37.7832138425408, -122.474242864812)
157233 208838 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1450 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5991176.37038 2105519.1814900003 37.7608464875004 -122.47363884617799 (37.7608464875004, -122.473638846178)
161888 217796 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 21 Sloat Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 5ft   5991264.945169999 2095927.55542 37.7345154980788 -122.472633170284 (37.7345154980788, -122.472633170284)
97135 72366 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 706 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/21/2014 12:00:00 AM 3 3x3 Permit Number 772932 5991332.62885 2110561.58816 37.7747006286591 -122.473466226319 (37.7747006286591, -122.473466226319)
95030 88376 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 563 14th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51354 5991545.8 2111599.6 37.777563068378704 -122.472804534873 (37.7775630683787, -122.472804534873)
156900 102081 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 525 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/09/2009 12:00:00 AM 2 3x3 Permit Number 52509 5991566.610309999 2111852.8346 37.778259586012204 -122.472751014651 (37.7782595860122, -122.472751014651)
69848 81662 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 563 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   4     5991577.12734 2111607.04314 37.7775853186785 -122.472696706975 (37.7775853186785, -122.472696706975)
73090 123057 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 514 Funston Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5991919.1397400005 2111920.98536 37.778467110254795 -122.47153646453998 (37.7784671102548, -122.47153646454)
139591 87070 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 395 Byxbee St 1 Front Yard : Cutout 8 Tree 1 Private 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
143622 87071 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 395 Byxbee St 2 Front Yard : Cutout 8 Tree 1 Private 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
69222 68687 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 133 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2014 12:00:00 AM 1 6x6 Permit Number 771044 5992088.87095 2114507.13587 37.7855777876584 -122.471137767056 (37.7855777876584, -122.471137767056)
97561 108495 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 133 12th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/23/2014 12:00:00 AM 3 3x3 Permit Number 773787 5992089.92921 2114572.19418 37.7857564810121 -122.47113884728998 (37.7857564810121, -122.47113884729)
67154 122918 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 336 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992182.56375 2113171.96239 37.781917187404794 -122.470716333226 (37.7819171874048, -122.470716333226)
70176 94709 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 739 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/28/2010 12:00:00 AM 1 3x3 Permit Number 53847 5992236.9095 2110392.30167 37.7742881380791 -122.47032583467899 (37.7742881380791, -122.470325834679)
27994 52460 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 682@ CABRILLO 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2005 12:00:00 AM 1   Permit Number 48571 5992268.12798 2110826.06835 37.775480948973396 -122.470249439229 (37.7754809489734, -122.470249439229)
179928 94708 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 696 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/28/2010 12:00:00 AM 1 3x3 Permit Number 53846 5992270.38847 2110735.82166 37.775233286679104 -122.470235046427 (37.7752332866791, -122.470235046427)
90961 94705 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 682 12th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/28/2010 12:00:00 AM   3x3 Permit Number 53845 5992291.3 2110837.3 37.7755131276945 -122.470170100471 (37.7755131276945, -122.470170100471)
141970 94820 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1227 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/10/2010 12:00:00 AM   3x3 Permit Number 53900 5992334.0 2107055.2 37.7651309632558 -122.469746983482 (37.7651309632558, -122.469746983482)
111675 81067 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1283 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/16/2008 12:00:00 AM   3x3 Permit Number 50902 5992359.24137134 2106729.49777919 37.7642381302347 -122.46963596784799 (37.7642381302347, -122.469635967848)
9719 173651 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 80 Entrada Ct 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1   12/21/2016 12:00:00 AM 3 4x10   5992424.456569999 2092194.59394 37.7243327619491 -122.46835290122299 (37.7243327619491, -122.468352901223)
98471 69097 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1652 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/15/2010 12:00:00 AM   3x3 Permit Number 53733 5992497.75001654 2104207.48539143 37.7573213517081 -122.46897335970101 (37.7573213517081, -122.468973359701)
143274 122379 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 466 Vernon St 1 Front Yard : Cutout 8 Tree 1 Private 1   10/26/2016 12:00:00 AM 3 3x3   5992521.0 2090937.0 37.7208852925782 -122.46792773796801 (37.7208852925782, -122.467927737968)
163844 123126 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 771 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5992555.29457 2110202.5485900003 37.773785530078605 -122.469210678659 (37.7737855300786, -122.469210678659)
90136 108459 Private 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 771 11th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     3x3 Permit Number 773786 5992558.08669 2110211.94426 37.7738114893979 -122.469201704334 (37.7738114893979, -122.469201704334)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 622.882ms · Data source: data.sfgov.org