979 rows where qSpecies_id = 13 sorted by TreeID

View and edit SQL

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)
133012 101128 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 295X 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2012 12:00:00 AM 1 3x3 Permit Number 769229 5990852.62725 2113482.24479 37.7826921394002 -122.475339912567 (37.7826921394002, -122.475339912567) 11 6 2 54 26
89563 102081 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 525 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/2009 12:00:00 AM 2 3x3 Permit Number 52509 5991566.61031 2111852.8346 37.7782595860122 -122.472751014651 (37.7782595860122, -122.472751014651) 11 6 2 54 26
15129 102443 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 514 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2013 12:00:00 AM 1   Permit Number 770339 6013518.76597 2104573.81866 37.7595193399709 -122.396299571184 (37.7595193399709, -122.396299571184) 10 3 8 28856 29
94823 102805 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600 Kansas St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/11/2017 12:00:00 AM 3 3x3 Permit Number 780021 6011492.26434 2105507.65774 37.7619704808857 -122.403373953167 (37.7619704808857, -122.403373953167) 10 3 8 28856 29
70101 103767 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1323 Polk St 1 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006757 2115467 37.7890508291132 -122.420458370284 (37.7890508291132, -122.420458370284) 13 9 10 28858 21
128948 103768 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1323 Polk St 2 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006757 2115467 37.7890508291132 -122.420458370284 (37.7890508291132, -122.420458370284) 13 9 10 28858 21
33672 103773 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1288 Polk St 3 Sidewalk: Curb side : Pot Tree DPW 1   11/01/2009 12:00:00 AM 3     6006856.2 2115250.5 37.7884619632914 -122.420099779635 (37.7884619632914, -122.420099779635) 13 9 10 28858 21
131007 103774 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1288 Polk St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006856.2 2115250.5 37.7884619632914 -122.420099779635 (37.7884619632914, -122.420099779635) 13 9 10 28858 21
62327 103775 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1288 Polk St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006856.2 2115250.5 37.7884619632914 -122.420099779635 (37.7884619632914, -122.420099779635) 13 9 10 28858 21
19938 103781 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1237 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006764.1 2115217.5 37.7883661638156 -122.420416088533 (37.7883661638156, -122.420416088533) 13 9 10 28858 21
42861 103782 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1237 Polk St 2 Sidewalk: Curb side : Pot Tree DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006764.1 2115217.5 37.7883661638156 -122.420416088533 (37.7883661638156, -122.420416088533) 13 9 10 28858 21
34100 103787 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1217 Polk St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006790.1 2115111 37.7880752061995 -122.420318570601 (37.7880752061995, -122.420318570601) 13 9 10 28858 21
38286 103800 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1157 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006858.38304 2114906.78358 37.7875183256613 -122.420067824472 (37.7875183256613, -122.420067824472) 13 9 10 28858 21
34827 103801 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1157 Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006858.38304 2114906.78358 37.7875183256613 -122.420067824472 (37.7875183256613, -122.420067824472) 13 9 10 28858 21
177229 103802 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1157 Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006858.38304 2114906.78358 37.7875183256613 -122.420067824472 (37.7875183256613, -122.420067824472) 13 9 10 28858 21
189600 103809 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1145 Polk St 3 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006819.8 2114898.5 37.7874934070669 -122.420200726176 (37.7874934070669, -122.420200726176) 13 9 10 28858 21
105559 103810 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1145 Polk St 4 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006819.8 2114898.5 37.7874934070669 -122.420200726176 (37.7874934070669, -122.420200726176) 13 9 10 28858 21
176203 103811 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1145 Polk St 5 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006819.8 2114898.5 37.7874934070669 -122.420200726176 (37.7874934070669, -122.420200726176) 13 9 10 28858 21
64797 103852 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1507 Polk St 1 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006614.6 2116113.6 37.7908182067111 -122.420996984718 (37.7908182067111, -122.420996984718) 13 9 10 28858 21
33582 103859 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1475 Polk St 3 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006677 2115920.4 37.7902912446707 -122.420767361582 (37.7902912446707, -122.420767361582) 13 9 10 28858 21
91960 103860 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1475 Polk St 4 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006677 2115920.4 37.7902912446707 -122.420767361582 (37.7902912446707, -122.420767361582) 13 9 10 28858 21
155187 103861 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1436 Polk St 1 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006766.2 2115894.4 37.7902248822442 -122.420456889097 (37.7902248822442, -122.420456889097) 13 9 10 28858 21
128715 103863 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1435 Polk St 1 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006674.8 2115856.4 37.790115392534 -122.42077042798 (37.790115392534, -122.42077042798) 13 9 10 28858 21
151626 103864 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1435 Polk St 2 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006674.8 2115856.4 37.790115392534 -122.42077042798 (37.790115392534, -122.42077042798) 13 9 10 28858 21
89050 103865 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1424 Polk St 1 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006775 2115831.4 37.7900523957484 -122.420421968076 (37.7900523957484, -122.420421968076) 13 9 10 28858 21
102492 103866 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1411 Polk St 1 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006684.9 2115784.5 37.7899185422019 -122.420730376301 (37.7899185422019, -122.420730376301) 13 9 10 28858 21
165177 103867 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1411 Polk St 2 Sidewalk: Curb side : Cutout Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006684.9 2115784.5 37.7899185422019 -122.420730376301 (37.7899185422019, -122.420730376301) 13 9 10 28858 21
149876 103868 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1411 Polk St 3 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006684.9 2115784.5 37.7899185422019 -122.420730376301 (37.7899185422019, -122.420730376301) 13 9 10 28858 21
62298 103869 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1411 Polk St 4 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006684.9 2115784.5 37.7899185422019 -122.420730376301 (37.7899185422019, -122.420730376301) 13 9 10 28858 21
74128 104035 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 31 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2014 12:00:00 AM 3 3x3 Permit Number 770364 6003192.1 2108122 37.7686817505567 -122.43226767848 (37.7686817505567, -122.43226767848) 15 5 5 28862 3
94413 104138 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3067 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/31/2013 12:00:00 AM   3x3 Permit Number 770728 6001906.1 2118706.9 37.7976721947069 -122.437473929103 (37.7976721947069, -122.437473929103) 13 9 1 57 17
154327 104139 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2301X Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/31/2013 12:00:00 AM   3x3 Permit Number 770728 6001711.91514 2118723.596 37.7977069957146 -122.438147056882 (37.7977069957146, -122.438147056882) 13 9 1 57 17
148842 104140 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2301X Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/31/2013 12:00:00 AM   3x3 Permit Number 770728 6001711.91514 2118723.596 37.7977069957146 -122.438147056882 (37.7977069957146, -122.438147056882) 13 9 1 57 17
58308 104296 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 4267 24TH ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 770781 6001461 2101700 37.7509501962946 -122.437795389969 (37.7509501962946, -122.437795389969) 2 4 5 28862 22
66627 104506 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 631 France Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   6002582.75614 2089515.1433 37.7175570910528 -122.43304578096 (37.7175570910528, -122.43304578096) 9 7 6 28861 5
81820 104632 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 323 Madrid St   Sidewalk: Curb side : Cutout Tree Private 2   12/22/2014 12:00:00 AM 3   Permit Number 773809 6003337.3 2091944.5 37.7242703388921 -122.430610922244 (37.7242703388921, -122.430610922244) 9 7 6 28861 5
179581 105038 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 46 Atalaya Ter   Sidewalk: Curb side : Cutout Tree Private 2   03/05/2015 12:00:00 AM 3 3X4 Permit Number 771123 5998888.1 2110865.6 37.7759699989755 -122.447352315284 (37.7759699989755, -122.447352315284) 15 6 2 29492 16
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
46899 105692 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2523 HARRISON ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1 3x3   6008930.3 2103627.5 37.7566645705002 -122.412101939497 (37.7566645705002, -122.412101939497) 2 4 7 28859 19
63268 105693 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2523 HARRISON ST   Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6008930.3 2103627.5 37.7566645705002 -122.412101939497 (37.7566645705002, -122.412101939497) 2 4 7 28859 19
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
47189 105758 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2523 HARRISON ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1 3x3   6008930.3 2103627.5 37.7566645705002 -122.412101939497 (37.7566645705002, -122.412101939497) 2 4 7 28859 19
26944 105800 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 207 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/27/2014 12:00:00 AM 3   Permit Number 769635 6010004.04754 2087785.06673 37.71322482385 -122.407271751589 (37.71322482385, -122.407271751589) 9 7 8 309 39
53650 105829 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250 DOUGLASS ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2014 12:00:00 AM 3 3x3 Permit Number 773272 6001076.7 2104819.3 37.7594931793762 -122.439347898858 (37.7594931793762, -122.439347898858) 2 4 5 28862 3
193757 105847 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 790 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6008900 2110136 37.7745337092857 -122.412666821872 (37.7745337092857, -122.412666821872) 8 2 9 28853 34
24096 105848 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 790 Tehama St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6008900 2110136 37.7745337092857 -122.412666821872 (37.7745337092857, -122.412666821872) 8 2 9 28853 34
9218 106080 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 188 The Embarcadero 1 Front Yard : Yard Tree Private 2   03/20/2014 12:00:00 AM     Permit Number 771259 6015087.8131 2116516.98611 37.7923997963133 -122.391708043282 (37.7923997963133, -122.391708043282) 12 2 9 28855 6
8067 106254 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1912X 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3 Permit Number 770844 6012043 2105629 37.7623344042956 -122.401477690357 (37.7623344042956, -122.401477690357) 8 3 8 28856 29
43703 106256 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1928 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3 Permit Number 770844 6011999 2105627 37.7623264575812 -122.401629730256 (37.7623264575812, -122.401629730256) 8 3 8 28856 29
98983 106257 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1938 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3 Permit Number 770844 6011971 2105625 37.7623194035501 -122.40172643178 (37.7623194035501, -122.40172643178) 8 3 8 28856 29
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
79934 106843 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1869 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2014 12:00:00 AM     Permit Number 773317 6004088.44172 2118602.99638 37.7975107321666 -122.429915018594 (37.7975107321666, -122.429915018594) 13 9 1 57 17
172708 107438 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 777 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2014 12:00:00 AM 3 3x3 Permit Number 773131 5994721.10495 2110354.7884 37.7743284514501 -122.461729889857 (37.7743284514501, -122.461729889857) 11 6 2 54 11
64728 107495 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 4089 26TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2014 12:00:00 AM 3 5x5 Permit Number 774317 6003351.8 2100635.3 37.7481341140921 -122.431180836539 (37.7481341140921, -122.431180836539) 2 4 5 63 22
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
192239 107674 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 133 ELSIE ST 1 Front Yard : Yard Tree Private 2   10/10/2014 12:00:00 AM 3     6007164.4 2098513.7 37.742523993822 -122.417846597438 (37.742523993822, -122.417846597438) 2 7 7 28859 2
130311 107776 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 4115 26TH ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003143.1 2100622.5 37.7480871393693 -122.431901599648 (37.7480871393693, -122.431901599648) 2 4 5 63 22
3226 107892 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 162 Brewster St   Front Yard : Cutout Tree Private 2   11/04/2014 12:00:00 AM 3 3x3 Permit Number 773952 6010231.01704 2099016.49618 37.7440766668365 -122.407278527778 (37.7440766668365, -122.407278527778) 2 7 7 28859 2
101232 107902 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 133 Elsie St   Front Yard : Yard Tree Private 2   11/04/2014 12:00:00 AM 3   Permit Number 773996 6007164.40736 2098513.65139 37.742523860764 -122.417846568545 (37.742523860764, -122.417846568545) 2 7 7 28859 2
58046 107963 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 33 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770900 6011844.7795 2114609.58385 37.7869819669901 -122.402794885102 (37.7869819669901, -122.402794885102) 12 2 9 28853 6
47704 108089 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2501X 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2014 12:00:00 AM 3   Permit Number 773081 6010157.47788 2105483.07585 37.7618283430246 -122.407988746007 (37.7618283430246, -122.407988746007) 10 4 8 28859 19
142933 108091 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2501X 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2014 12:00:00 AM 3   Permit Number 773081 6010179.28671 2105483.38874 37.7618304231561 -122.407913339641 (37.7618304231561, -122.407913339641) 10 4 8 28859 19
68492 108093 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2501X 18th St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2014 12:00:00 AM 3   Permit Number 773081 6010203.41719 2105485.67353 37.7618380476045 -122.40783004262 (37.7618380476045, -122.40783004262) 10 4 8 28859 19
79651 108193 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250 Douglass St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2014 12:00:00 AM 3 3x3 Permit Number 773272 6001076.66199 2104819.30807 37.7594931993714 -122.439348030893 (37.7594931993714, -122.439348030893) 2 4 5 28862 3
145251 108356 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250X Pixley St 1 Sidewalk: Curb side : Cutout Tree Fire Dept 16   11/02/2018 12:00:00 AM 3 2x4 Permit Number 773698 6002158.91155 2118972.60439 37.7984161192732 -122.436618162405 (37.7984161192732, -122.436618162405) 13 9 1 57 17
108505 108357 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250X Pixley St 2 Sidewalk: Curb side : Cutout Tree Fire Dept 16   11/02/2018 12:00:00 AM 3 2x4 Permit Number 773698 6002140.21513 2118970.44706 37.7984091333207 -122.436682703142 (37.7984091333207, -122.436682703142) 13 9 1 57 17
177003 108358 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250X Pixley St 3 Sidewalk: Curb side : Cutout Tree Fire Dept 16   11/02/2018 12:00:00 AM 3 2x4 Permit Number 773698 6002123.02459 2118966.98612 37.7983986535418 -122.436741939704 (37.7983986535418, -122.436741939704) 13 9 1 57 17
128293 108377 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 226 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1 3x3 Permit Number 773810 6004631.19295 2091083.05863 37.7219782266077 -122.426076821998 (37.7219782266077, -122.426076821998) 9 7 6 28861 5
104312 108448 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 90-98X Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 3 3x3   6004670.84101 2090640.56593 37.7207654791334 -122.425908286356 (37.7207654791334, -122.425908286356) 9 7 6 28861 5
65512 108459 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 771 11th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 773786 5992558.08669 2110211.94426 37.7738114893979 -122.469201704334 (37.7738114893979, -122.469201704334) 11 6 2 54 11
113259 108495 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 133 12th Ave   Sidewalk: Curb side : Cutout Tree Private 2   12/23/2014 12:00:00 AM 3 3x3 Permit Number 773787 5992089.92921 2114572.19418 37.7857564810121 -122.47113884729 (37.7857564810121, -122.47113884729) 11 6 2 54 11
43419 108518 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600-602 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773792 5993757.57798 2110759.58067 37.7753843907715 -122.465092287532 (37.7753843907715, -122.465092287532) 11 6 2 54 11
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
160765 108524 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1669 18th Ave 1 Sidewalk: Property side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773675 5990564.49357 2104037.4684 37.7567426423615 -122.475646836483 (37.7567426423615, -122.475646836483) 1 8 4 56 12
121503 108525 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1673 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773676 5990565.37747 2104011.47717 37.7566713285758 -122.475641881825 (37.7566713285758, -122.475641881825) 1 8 4 56 12
151899 108558 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 222 Theresa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773717 6001903.01628 2093995.18892 37.7298197060157 -122.435715674761 (37.7298197060157, -122.435715674761) 9 7 6 28861 25
130803 108592 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 669 Parker Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774577 5997227.20075 2110944.62571 37.7760919347852 -122.453103475186 (37.7760919347852, -122.453103475186) 15 6 2 54 16
22140 108608 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 46 Mirabel Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774593 6007564.86266 2099909.67409 37.7463795558054 -122.416560777242 (37.7463795558054, -122.416560777242) 2 7 7 28859 2
156492 108610 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 745 Moultrie St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774595 6007633.33742 2095945.52231 37.7354987236975 -122.416043312411 (37.7354987236975, -122.416043312411) 2 7 7 28859 2
187282 108632 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 99 ORD ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774601 6000898 2105859 37.7623377695764 -122.440040482469 (37.7623377695764, -122.440040482469) 15 5 5 28862 3
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
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
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
20705 108706 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1683 Chattanooga St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774629 6004719.93732 2102694.114 37.7538645742471 -122.42659644528 (37.7538645742471, -122.42659644528) 2 4 5 28862 22
183971 108814 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 470 Munich St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774651 6003792.96606 2089744.94608 37.7182566522639 -122.42887901198 (37.7182566522639, -122.42887901198) 9 7 6 28861 5
10118 108815 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 474 Munich St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774652 6003779.44726 2089723.38143 37.7181966752665 -122.428924204145 (37.7181966752665, -122.428924204145) 9 7 6 28861 5
143819 108839 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1112 Russia Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 770758 6003955.6442 2089384.80901 37.7172770009516 -122.428291049376 (37.7172770009516, -122.428291049376) 9 7 6 28861 5
189937 108842 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 420 Woolsey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 772583 6010509.54502 2091864.19266 37.7244535448266 -122.405811727659 (37.7244535448266, -122.405811727659) 10 3 7 309 28
107527 108843 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 420 Woolsey St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 772583 6010519.10921 2091869.71455 37.7244692416558 -122.405779054162 (37.7244692416558, -122.405779054162) 10 3 7 309 28
98737 108845 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 420 Woolsey St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 772583 6010479.05335 2091857.99264 37.7244348155857 -122.405916697196 (37.7244348155857, -122.405916697196) 10 3 7 309 28
68920 108921 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 33 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772690 6007205.6 2099297 37.7446770790021 -122.417759648925 (37.7446770790021, -122.417759648925) 2 7 7 28859 2
182294 108925 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 209 Nevada St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 770705 6009037.7 2097340 37.7394065164512 -122.411286359806 (37.7394065164512, -122.411286359806) 10 7 7 28859 2
41563 108933 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 518 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2015 12:00:00 AM 3 3x3 Permit Number 773146 6008530.3 2096373.5 37.7367242478568 -122.41297241357 (37.7367242478568, -122.41297241357) 10 7 7 28859 2
107998 108994 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1819 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2015 12:00:00 AM 3 3x3 Permit Number 773341 5993399.9 2103085.8 37.7542935760975 -122.465771900659 (37.7542935760975, -122.465771900659) 1 8 4 56 12
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
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
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
51580 109211 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 819 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2015 12:00:00 AM 3 3x3 Permit Number 773413 6011187.72328 2090968.52831 37.722032138266 -122.403404362845 (37.722032138266, -122.403404362845) 10 3 7 309 28
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

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