93 rows where qSpecies_id = 224

View and edit SQL

Suggested facets: qCaretaker_id, qCareAssistant, Fire Prevention Districts, Police Districts, Supervisor Districts, Neighborhoods (old)

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)
2351 213378 DPW Maintained 1 Magnolia spp :: Magnolia 224 1222 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 Width 3ft Permit Number 784692 5993325.39992 2107141.02877 37.7654238793266 -122.466324239095 (37.7654238793266, -122.466324239095) 11 8 11 56 12
2452 193439 DPW Maintained 1 Magnolia spp :: Magnolia 224 1301 Minnesota St 10 Front Yard : Yard Tree Private 2     1     6015387.42836 2102311.75717 37.7534120052793 -122.38967876317 (37.7534120052793, -122.38967876317) 10 3 8 28856 29
6077 230988 Planning Code 138.1 required 2 Magnolia spp :: Magnolia 224 44 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2018 12:00:00 AM 3 3x6 Permit Number 778706 6007424.10799 2099038.48568 37.7439795505181 -122.416985775987 (37.7439795505181, -122.416985775987) 2 7 7 28859 2
6434 230789 DPW Maintained 1 Magnolia spp :: Magnolia 224 3933 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2020 12:00:00 AM 3 Width 3ft Permit Number 767282 6004098.889 2104204.25697 37.757975940552 -122.428851827645 (37.757975940552, -122.428851827645) 2 4 5 28862 3
6656 258684 Planning Code 138.1 required 2 Magnolia spp :: Magnolia 224 222 Eucalyptus Dr 2 Sidewalk: Property side : Yard Tree Private 2   06/06/2019 12:00:00 AM 3 4x4 Permit Number 782190 5990522.43491 2094710.12159 37.7311297256611 -122.475111403646 (37.7311297256611, -122.475111403646) 1 8 4 64 35
7179 260247 Property Tree 8 Magnolia spp :: Magnolia 224 568 Huron Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5998297.39121 2088148.96817 37.7135618752392 -122.447759972312 (37.7135618752392, -122.447759972312) 9 7 6 28861 25
8126 28056 DPW Maintained 1 Magnolia spp :: Magnolia 224 33 Haight St 3 Sidewalk: Curb side : Cutout Tree DPW 1     8 4X4   6005944.78414 2109618.42708 37.7729462740038 -122.42285271058 (37.7729462740038, -122.42285271058) 7 9 11 28852 10
8278 258683 Planning Code 138.1 required 2 Magnolia spp :: Magnolia 224 222 Eucalyptus Dr 1 Sidewalk: Property side : Yard Tree Private 2   06/06/2019 12:00:00 AM 3 4x4 Permit Number 782190 5990522.43491 2094710.12159 37.7311297256611 -122.475111403646 (37.7311297256611, -122.475111403646) 1 8 4 64 35
10128 256113 Section 806 (d) 5 Magnolia spp :: Magnolia 224 356 Willard North St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2018 12:00:00 AM 3                        
11394 260246 Private 9 Magnolia spp :: Magnolia 224 568 Huron Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/14/2019 12:00:00 AM 3 3x3 Permit Number 784595 5998297.39121 2088148.96817 37.7135618752392 -122.447759972312 (37.7135618752392, -122.447759972312) 9 7 6 28861 25
12570 75375 DPW Maintained 1 Magnolia spp :: Magnolia 224 242 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     5997883.096 2109628.0405 37.77251450021 -122.450739621122 (37.77251450021, -122.450739621122) 15 5 11 29492 16
12849 94786 Permitted Site 7 Magnolia spp :: Magnolia 224 1X CASELLI AVE 4 Sidewalk: Curb side : Cutout Tree Private 2   11/04/2010 12:00:00 AM   3x3 Permit Number 53882 6000842 2104917 37.7597480805722 -122.440166611531 (37.7597480805722, -122.440166611531) 2 4 5 28862 3
13728 96416 Permitted Site 7 Magnolia spp :: Magnolia 224 2749 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 10x10   6008995.5323 2102438.8768 37.7534045389876 -122.411792354923 (37.7534045389876, -122.411792354923) 2 4 7 28859 19
14980 75220 DPW Maintained 1 Magnolia spp :: Magnolia 224 246 Cole St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5997870.8316 2109714.2746 37.772750574805 -122.450788263508 (37.772750574805, -122.450788263508) 15 5 11 29492 16
17162 230428 DPW Maintained 1 Magnolia spp :: Magnolia 224 436 Murray St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6006457.38895 2096010.6224 37.7356112869209 -122.42011363695 (37.7356112869209, -122.42011363695) 2 7 7 28859 2
17608 20404 DPW Maintained 1 Magnolia spp :: Magnolia 224 262X Sunset Blvd 49 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
17989 250142 DPW Maintained 1 Magnolia spp :: Magnolia 224 2550x Lyon St 10 Median : Yard Tree DPW 1     1     5999229.6006 2117622.80882 37.7945430395703 -122.446657269218 (37.7945430395703, -122.446657269218) 13 9 1 57 27
29831 85245 Permitted Site 7 Magnolia spp :: Magnolia 224 1307 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2007 12:00:00 AM     Permit Number 49546 6001610 2110428 37.7749236198612 -122.437905219532 (37.7749236198612, -122.437905219532) 15 5 11 29492 10
34834 96516 Permitted Site 7 Magnolia spp :: Magnolia 224 3119 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2011 12:00:00 AM     Permit Number 58566 6009076 2100510 37.7481127876266 -122.411377822838 (37.7481127876266, -122.411377822838) 2 7 7 28859 2
35244 104763 Undocumented 4 Magnolia spp :: Magnolia 224 51 VICKSBURG ST 2 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2014 12:00:00 AM 15 4x4 Permit Number 772738 6004133.6 2102760.4 37.7540134146385 -122.428628860828 (37.7540134146385, -122.428628860828) 2 4 5 28862 22
37117 117330 Permitted Site 7 Magnolia spp :: Magnolia 224 1144 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2016 12:00:00 AM 3   Permit Number 778490 5998226.1 2106298.1 37.7633909587408 -122.449313182994 (37.7633909587408, -122.449313182994) 15 5 11 29492 9
37133 5427 DPW Maintained 1 Magnolia spp :: Magnolia 224 460X Dolores St 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6004889.2026724 2105697.5669462 37.7621209168257 -122.426224900449 (37.7621209168257, -122.426224900449) 8 4 5 28862 3
38700 104467 Permitted Site 7 Magnolia spp :: Magnolia 224 857 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/2013 12:00:00 AM 3 3x3 Permit Number 769287 6009159.4 2104178.6 37.7581906182499 -122.411348556636 (37.7581906182499, -122.411348556636) 2 4 7 28859 19
43347 53478 Permitted Site 7 Magnolia spp :: Magnolia 224 51 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2014 12:00:00 AM 15 4x4 Permit Number 772738 6004118.50395547 2102762.60365408 37.7540186110043 -122.428681223641 (37.7540186110043, -122.428681223641) 2 4 5 28862 22
44997 62672 Permitted Site 7 Magnolia spp :: Magnolia 224 48 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1986 12:00:00 AM 3   Permit Number 23004 6002888.71912125 2108707.39458203 37.7702718941008 -122.433358884898 (37.7702718941008, -122.433358884898) 15 5 5 29492 9
46982 86872 Permitted Site 7 Magnolia spp :: Magnolia 224 2160 Green St   Sidewalk: Curb side : Cutout Tree Private 2   10/19/2007 12:00:00 AM   3x3 Permit Number 49804 6002705 2118187 37.796290071465 -122.434672325351 (37.796290071465, -122.434672325351) 13 9 1 57 17
47827 86711 Permitted Site 7 Magnolia spp :: Magnolia 224 3714 Cesar Chavez St   Sidewalk: Curb side : Cutout Tree Private 2   09/24/2007 12:00:00 AM 6   Permit Number 49697 6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
54088 117373 DPW Maintained 1 Magnolia spp :: Magnolia 224 2219 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2016 12:00:00 AM 3   Permit Number 778546 5983853.5 2100037.4 37.7453682200001 -122.498560081441 (37.7453682200001, -122.498560081441) 1 8 3 29491 35
54455 110680 Undocumented 4 Magnolia spp :: Magnolia 224 162 DUNCAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005508 2099957 37.7463936103079 -122.423676542195 (37.7463936103079, -122.423676542195) 2 7 5 28859 22
55130 104947 Undocumented 4 Magnolia spp :: Magnolia 224 532 Gonzalez Dr 4 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
56846 140179 DPW Maintained 1 Magnolia spp :: Magnolia 224 246 COLE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5997872.7479 2109697.411 37.7727043813962 -122.450780418722 (37.7727043813962, -122.450780418722) 15 5 11 29492 16
61403 111037 Significant Tree 6 Magnolia spp :: Magnolia 224 3991-3997 Washington St 2 Front Yard : Yard Tree Private 2           5995610.3 2115419.4 37.7882856707006 -122.459020806409 (37.7882856707006, -122.459020806409) 11 6 1 54 31
61499 6716 DPW Maintained 1 Magnolia spp :: Magnolia 224 1200X Fairfax Ave 13 Sidewalk: Curb side : Cutout Tree DPW 1   04/05/2015 11:25:00 AM 3 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
65405 104718 Undocumented 4 Magnolia spp :: Magnolia 224 100x PRECITA AVE 2 Sidewalk: Curb side : Cutout Tree Private 2           6007128 2100007 37.7466222122015 -122.418078299823 (37.7466222122015, -122.418078299823) 2 7 7 28859 2
65688 59775 Permitted Site 7 Magnolia spp :: Magnolia 224 100x PRECITA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/1981 12:00:00 AM 8 9x7 Permit Number 19223 6007128 2100007 37.7466222122015 -122.418078299823 (37.7466222122015, -122.418078299823) 2 7 7 28859 2
68392 230427 DPW Maintained 1 Magnolia spp :: Magnolia 224 230 Coso Ave 1 Side Yard : Yard Tree Private 2     1     6007601.41363 2099515.46986 37.7452992147794 -122.416406470502 (37.7452992147794, -122.416406470502) 2 7 7 28859 2
68971 140178 DPW Maintained 1 Magnolia spp :: Magnolia 224 246 COLE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5997876.1972 2109680.9307 37.7726593281832 -122.450767298801 (37.7726593281832, -122.450767298801) 15 5 11 29492 16
69163 33522 Permitted Site 7 Magnolia spp :: Magnolia 224 174 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/2009 12:00:00 AM   3x3 Permit Number 52072 6007260.41005057 2098019.68890663 37.7411729520807 -122.417479618781 (37.7411729520807, -122.417479618781) 2 7 7 28859 2
69703 21552 DPW Maintained 1 Magnolia spp :: Magnolia 224 1405 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 2x2   6005864.0928275 2114832.0476095 37.7872570487118 -122.423502557849 (37.7872570487118, -122.423502557849) 13 9 1 28858 41
70600 85257 Permitted Site 7 Magnolia spp :: Magnolia 224 689 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2007 12:00:00 AM     Permit Number 49556 6001247 2102379 37.7528023963993 -122.438584066967 (37.7528023963993, -122.438584066967) 2 4 5 28862 22
75824 106270 Undocumented 4 Magnolia spp :: Magnolia 224 49 MISSOURI ST 10 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6013498.7 2106906.8 37.7659240772205 -122.39653250625 (37.7659240772205, -122.39653250625) 14 3 8 28856 20
76095 106244 Significant Tree 6 Magnolia spp :: Magnolia 224 735 MANGELS AVE 1 Front Yard : Yard Tree Private 2   06/02/2014 12:00:00 AM 14   Permit Number 772876 5996640.8 2095225.8 37.7328983615352 -122.453996493912 (37.7328983615352, -122.453996493912) 9 7 4 59 40
76679 86873 Permitted Site 7 Magnolia spp :: Magnolia 224 2160 Green St   Sidewalk: Curb side : Cutout Tree Private 2   10/19/2007 12:00:00 AM   3x3 Permit Number 49804 6002705 2118187 37.796290071465 -122.434672325351 (37.796290071465, -122.434672325351) 13 9 1 57 17
77669 208862 DPW Maintained 1 Magnolia spp :: Magnolia 224 639 Mangels Ave 2 Sidewalk: Property side : Yard Tree Private 2     11     5997188.97266 2095238.55048 37.7329647871987 -122.452102249635 (37.7329647871987, -122.452102249635) 9 7 4 59 40
77753 208861 DPW Maintained 1 Magnolia spp :: Magnolia 224 263 Flood Ave 1 Sidewalk: Property side : Yard Tree Private 2     11     5998987.83707 2094055.2995 37.7298187374412 -122.445798064124 (37.7298187374412, -122.445798064124) 9 7 4 28861 40
78431 110449 Undocumented 4 Magnolia spp :: Magnolia 224 28 BELCHER ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775444 6003746 2108157 37.7688092427031 -122.430354279635 (37.7688092427031, -122.430354279635) 7 9 5 28862 3
80127 6779 DPW Maintained 1 Magnolia spp :: Magnolia 224 1355 Fairfax Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1   06/17/2011 12:00:00 AM 3 3x3   6016787.8631263 2097291.0360599 37.7397036915046 -122.384486040227 (37.7397036915046, -122.384486040227) 10 3 8 58 1
81356 52263 Permitted Site 7 Magnolia spp :: Magnolia 224 40 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/29/2005 12:00:00 AM     Permit Number 48428 6005651.79801021 2099662.26802464 37.7455924596089 -122.423158358307 (37.7455924596089, -122.423158358307) 2 7 5 28859 22
85331 67833 Permitted Site 7 Magnolia spp :: Magnolia 224 469 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/1992 12:00:00 AM   3x3 Permit Number 31495 6002871.84745267 2099449.75945792 37.7448516873624 -122.432755816877 (37.7448516873624, -122.432755816877) 2 7 5 63 22
86556 244383 DPW Maintained 1 Magnolia spp :: Magnolia 224 251 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6005771.1844 2110310.2456 37.7748360439411 -122.423502407009 (37.7748360439411, -122.423502407009) 7 9 11 28852 10
91213 57434 Permitted Site 7 Magnolia spp :: Magnolia 224 4324 18TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/1976 12:00:00 AM 20 9x6 Permit Number 16276 6001563 2105306 37.7608572014532 -122.437700893331 (37.7608572014532, -122.437700893331) 15 4 5 28862 3
91658 106372 Undocumented 4 Magnolia spp :: Magnolia 224 260 MAGELLAN AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   5994684.4 2100364.8 37.7468964099217 -122.461132589625 (37.7468964099217, -122.461132589625) 1 8 4 29491 40
96411 6713 DPW Maintained 1 Magnolia spp :: Magnolia 224 1200X Fairfax Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1   04/05/2015 11:14:00 AM 3 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
97224 94785 Permitted Site 7 Magnolia spp :: Magnolia 224 1X CASELLI AVE 3 Sidewalk: Curb side : Cutout Tree Private 2   11/04/2010 12:00:00 AM   3x3 Permit Number 53882 6000842 2104917 37.7597480805722 -122.440166611531 (37.7597480805722, -122.440166611531) 2 4 5 28862 3
100230 79058 Permitted Site 7 Magnolia spp :: Magnolia 224 84 Berkeley Way 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2011 12:00:00 AM     Permit Number 54829 6001112.32299105 2097379.40258298 37.7390670270865 -122.438691586574 (37.7390670270865, -122.438691586574) 2 7 5 63 7
107038 84073 Permitted Site 7 Magnolia spp :: Magnolia 224 3936 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2008 12:00:00 AM   3x3 Permit Number 50418 6003544.24731161 2102468.85848111 37.7531795392658 -122.43064618026 (37.7531795392658, -122.43064618026) 2 4 5 28862 22
110759 110448 Undocumented 4 Magnolia spp :: Magnolia 224 28 BELCHER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775444 6003746 2108157 37.7688092427031 -122.430354279635 (37.7688092427031, -122.430354279635) 7 9 5 28862 3
116846 208860 DPW Maintained 1 Magnolia spp :: Magnolia 224 1359 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5991111.19274 2106147.12197 37.762566869885 -122.473910078106 (37.762566869885, -122.473910078106) 1 8 11 56 12
117256 37939 Permitted Site 7 Magnolia spp :: Magnolia 224 730 22nd St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/08/1998 12:00:00 AM     Permit Number 40183 6015727.50058131 2103973.29458622 37.7579930864217 -122.388618685659 (37.7579930864217, -122.388618685659) 10 3 8 28856 29
118005 19337 DPW Maintained 1 Magnolia spp :: Magnolia 224 420 Shields St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/12/2014 12:00:00 AM 3 3x3   5992930.1579343 2089870.1086696 37.7179794867167 -122.466435911921 (37.7179794867167, -122.466435911921) 9 8 6 64 24
118673 67230 DPW Maintained 1 Magnolia spp :: Magnolia 224 519 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1992 12:00:00 AM 5   Permit Number 30689 5984068.99923 2112275.3941 37.7789829387423 -122.498718829258 (37.7789829387423, -122.498718829258) 11 6 2 55 26
125697 101408 Permitted Site 7 Magnolia spp :: Magnolia 224 395X Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2012 12:00:00 AM   3x3 Permit Number 768634 6007839 2105646.7 37.7621475376843 -122.416019051105 (37.7621475376843, -122.416019051105) 8 4 7 28859 19
126113 85065 Permitted Site 7 Magnolia spp :: Magnolia 224 168 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2007 12:00:00 AM     Permit Number 49431 5992213.6 2114351.2 37.7851568443713 -122.470694882766 (37.7851568443713, -122.470694882766) 11 6 2 54 11
127423 230429 DPW Maintained 1 Magnolia spp :: Magnolia 224 2649 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010278.55114 2103378.64577 37.7560568286752 -122.407421632625 (37.7560568286752, -122.407421632625) 10 4 7 28859 19
130012 12534 Permitted Site 7 Magnolia spp :: Magnolia 224 129 LAKE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   5995062 2114816 37.7865973635143 -122.46087407189 (37.7865973635143, -122.46087407189) 11 6 1 54 11
132141 131013 DPW Maintained 1 Magnolia spp :: Magnolia 224 2531 Filbert St 1 Sidewalk: Curb side : Pot Tree Private 2     6 Width 3ft   6000837.80329 2118568.05574 37.797230171598 -122.441160549934 (37.797230171598, -122.441160549934) 13 9 1 57 17
132772 57433 Permitted Site 7 Magnolia spp :: Magnolia 224 4316 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/1976 12:00:00 AM 20 6x6 Permit Number 16275 6001651.18541617 2105289.61210405 37.7608172180801 -122.437394726023 (37.7608172180801, -122.437394726023) 15 4 5 28862 3
133612 12528 Permitted Site 7 Magnolia spp :: Magnolia 224 100 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2008 12:00:00 AM 3 3X3   5995135.72177 2114954.21759 37.7869811132671 -122.4606290341 (37.7869811132671, -122.4606290341) 11 6 1 54 11
134459 245120 DPW Maintained 1 Magnolia spp :: Magnolia 224 129 Baker St 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 0ft   6000774.8471 2109422.9959 37.7721166047697 -122.44072207891 (37.7721166047697, -122.44072207891) 15 5 11 29492 9
136425 245119 DPW Maintained 1 Magnolia spp :: Magnolia 224 129 Baker St 1 Sidewalk: Curb side : Yard Tree Private 2     14 Width 0ft   6000771.8557 2109441.6092 37.7721675418639 -122.44073376176 (37.7721675418639, -122.44073376176) 15 5 11 29492 9
138947 230426 DPW Maintained 1 Magnolia spp :: Magnolia 224 230 Coso Ave 2 Side Yard : Yard Tree Private 2     1     6007649.02399 2099489.86888 37.7452315974648 -122.416240028469 (37.7452315974648, -122.416240028469) 2 7 7 28859 2
139210 81687 DPW Maintained 1 Magnolia spp :: Magnolia 224 210 Frederick St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2017 12:00:00 AM 3   Permit Number 777040 5999000.68344445 2107685.40393875 37.7672444226119 -122.446733986311 (37.7672444226119, -122.446733986311) 15 5 11 29492 9
143871 101409 Permitted Site 7 Magnolia spp :: Magnolia 224 395X Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2012 12:00:00 AM   3x3 Permit Number 768634 6007839 2105646.7 37.7621475376843 -122.416019051105 (37.7621475376843, -122.416019051105) 8 4 7 28859 19
144043 139532 DPW Maintained 1 Magnolia spp :: Magnolia 224 2103 O'Farrell St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2017 12:00:00 AM 3 Width 0ft Permit Number 779818 6001200.3588 2113145.5057 37.7823618989571 -122.439517100245 (37.7823618989571, -122.439517100245) 15 5 11 29490 41
147948 111036 Significant Tree 6 Magnolia spp :: Magnolia 224 3991-3997 Washington St 1 Front Yard : Yard Tree Private 2           5995610.3 2115419.4 37.7882856707006 -122.459020806409 (37.7882856707006, -122.459020806409) 11 6 1 54 31
149155 87384 Permitted Site 7 Magnolia spp :: Magnolia 224 152 Pixley St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2008 12:00:00 AM 7 3x3 Permit Number 50364 6002625 2119034 37.7986111712331 -122.435009748717 (37.7986111712331, -122.435009748717) 13 9 1 57 17
152005 28057 DPW Maintained 1 Magnolia spp :: Magnolia 224 33 Haight St 4 Sidewalk: Curb side : Cutout Tree DPW 1     8 4X4   6005944.78414 2109618.42708 37.7729462740038 -122.42285271058 (37.7729462740038, -122.42285271058) 7 9 11 28852 10
153574 100151 Undocumented 4 Magnolia spp :: Magnolia 224 4047 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 5x5 Permit Number 776452 6002690 2105300 37.7609047432887 -122.433802674054 (37.7609047432887, -122.433802674054) 2 4 5 28862 3
155311 96515 Permitted Site 7 Magnolia spp :: Magnolia 224 3119 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2011 12:00:00 AM     Permit Number 58566 6009076 2100510 37.7481127876266 -122.411377822838 (37.7481127876266, -122.411377822838) 2 7 7 28859 2
155991 94784 Permitted Site 7 Magnolia spp :: Magnolia 224 1X CASELLI AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   11/04/2010 12:00:00 AM   3x3 Permit Number 53882 6000842 2104917 37.7597480805722 -122.440166611531 (37.7597480805722, -122.440166611531) 2 4 5 28862 3
156384 5627 Permitted Site 7 Magnolia spp :: Magnolia 224 1215 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 6   6005207.4348277 2101278.8703511 37.7500061913108 -122.424809887589 (37.7500061913108, -122.424809887589) 2 4 5 28859 19
160215 115761 Undocumented 4 Magnolia spp :: Magnolia 224 924 NOE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6003074 2102857 37.7542186318325 -122.432300106993 (37.7542186318325, -122.432300106993) 2 4 5 28862 22
163265 87372 Permitted Site 7 Magnolia spp :: Magnolia 224 67 Belcher St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2008 12:00:00 AM   3x3 Permit Number 50351 6003819 2107947 37.7682367684387 -122.430086795172 (37.7682367684387, -122.430086795172) 7 9 5 28862 3
163852 57435 Permitted Site 7 Magnolia spp :: Magnolia 224 4328 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/1976 12:00:00 AM 24 6x6 Permit Number 16277 6001615.3752968 2105287.59579624 37.7608096458957 -122.437518432693 (37.7608096458957, -122.437518432693) 15 4 5 28862 3
165128 51939 Permitted Site 7 Magnolia spp :: Magnolia 224 61 Pond St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2005 12:00:00 AM 8 5x2 Permit Number 48164 6003201.44301211 2106166.49517673 37.763312938971 -122.432095698187 (37.763312938971, -122.432095698187) 15 4 5 28862 3
168295 87371 Permitted Site 7 Magnolia spp :: Magnolia 224 67 Belcher St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2008 12:00:00 AM   3x3 Permit Number 50351 6003819 2107947 37.7682367684387 -122.430086795172 (37.7682367684387, -122.430086795172) 7 9 5 28862 3
168477 112552 Permitted Site 7 Magnolia spp :: Magnolia 224 51 VICKSBURG ST 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6004133 2102760 37.7540122823763 -122.42863090726 (37.7540122823763, -122.42863090726) 2 4 5 28862 22
170048 53927 Permitted Site 7 Magnolia spp :: Magnolia 224 616-618 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/1972 12:00:00 AM     Permit Number 9640 6001839.32774762 2102295.7359044 37.752607450257 -122.436529733585 (37.752607450257, -122.436529733585) 2 4 5 28862 22
174124 67897 Permitted Site 7 Magnolia spp :: Magnolia 224 463 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/08/1994 12:00:00 AM   3x3 Permit Number 31599 5997692.14982092 2094077.11475557 37.7298045712917 -122.450278952768 (37.7298045712917, -122.450278952768) 9 7 4 28861 40
178484 85208 Undocumented 4 Magnolia spp :: Magnolia 224 3099 California St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/16/2007 12:00:00 AM     Permit Number 49530 5999545 2115014 37.7873979483893 -122.445378282275 (37.7873979483893, -122.445378282275) 13 6 1 29490 31
178575 96914 Undocumented 4 Magnolia spp :: Magnolia 224 4396X 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/1996 12:00:00 AM   3x3 Permit exists for 2 Magnolias on Hoffman frontage. These two appear to be about the same age. 6000641.3 2102303.1 37.7525595190983 -122.440673239158 (37.7525595190983, -122.440673239158) 2 4 5 28862 22
179322 62900 Permitted Site 7 Magnolia spp :: Magnolia 224 42 Berkeley Way 1 Sidewalk: Curb side : Cutout Tree Private 2   07/30/1986 12:00:00 AM 1   Permit Number 23274 6001400.58144689 2097305.17262336 37.7388796034552 -122.437689607497 (37.7388796034552, -122.437689607497) 2 7 5 63 7
193629 101407 Permitted Site 7 Magnolia spp :: Magnolia 224 395X Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2012 12:00:00 AM   3x3 Permit Number 768634 6007839 2105646.7 37.7621475376843 -122.416019051105 (37.7621475376843, -122.416019051105) 8 4 7 28859 19

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