trees

979 rows where qSpecies_id = 13 sorted by Longitude

✎ 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)
19852 33783 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013842.92338 2116188.62598 37.7914290137913 -122.395992405042 (37.7914290137913, -122.395992405042) 12 2 9 28855 6
81471 33774 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013834.28126 2116198.48682 37.7914556085404 -122.396022998165 (37.7914556085404, -122.396022998165) 12 2 9 28855 6
182336 33780 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 6 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013824.14126 2116210.79912 37.7914888510795 -122.39605894586 (37.7914888510795, -122.39605894586) 12 2 9 28855 6
175026 33785 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 7 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013812.6799 2116223.3583 37.7915226979635 -122.396099482817 (37.7915226979635, -122.396099482817) 12 2 9 28855 6
169485 33779 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 8 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013803.37475 2116233.23226 37.7915492918181 -122.396132371028 (37.7915492918181, -122.396132371028) 12 2 9 28855 6
110549 193372 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 9 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6013792.54079 2116244.01793 37.7915783039417 -122.39617061289 (37.7915783039417, -122.39617061289) 12 2 9 28855 6
27143 193373 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 10 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6013783.27133 2116255.65231 37.7916097334637 -122.396203501097 (37.7916097334637, -122.396203501097) 12 2 9 28855 6
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
34619 131007 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 150x Drumm St 2 Median : Yard Tree DPW 1     4 Width 7ft   6013687.07221 2117423.51513 37.7948110573238 -122.396618254944 (37.7948110573238, -122.396618254944) 4 1 10 28860 6
3991 131008 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 150x Drumm St 3 Median : Yard Tree DPW 1     4 Width 7ft   6013685.84477 2117434.71438 37.7948417395127 -122.396623287539 (37.7948417395127, -122.396623287539) 4 1 10 28860 6
68819 131009 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 150x Drumm St 4 Median : Yard Tree DPW 1     4 Width 7ft   6013684.35472 2117443.22893 37.7948650355324 -122.396629040522 (37.7948650355324, -122.396629040522) 4 1 10 28860 6
49171 94884 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2010 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM 5 3x3 Permit Number 53951 6013072.55459 2096282.04692 37.736727066797 -122.397261344859 (37.736727066797, -122.397261344859) 10 3 8 58 1
50336 94885 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2010 Quesada Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53951 6013050.0613 2096298.08413 37.736769849332 -122.397340238786 (37.736769849332, -122.397340238786) 10 3 8 58 1
21421 193318 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 136 Hawthorne St 4 : Tree Private 2     10 Width 2ft   6013332.96782 2113640.49809 37.7844040630434 -122.397578060899 (37.7844040630434, -122.397578060899) 6 2 9 28856 6
37097 193317 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 136 Hawthorne St 3 : Tree Private 2     9 Width 2ft   6013319.34244 2113654.62795 37.7844421016727 -122.397626191699 (37.7844421016727, -122.397626191699) 6 2 9 28856 6
3743 193316 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 136 Hawthorne St 2 : Tree Private 2     9 Width 2ft   6013300.83104 2113672.81478 37.7844910077044 -122.397691511273 (37.7844910077044, -122.397691511273) 6 2 9 28856 6
173449 193315 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 136 Hawthorne St 1 : Tree Private 2     9 Width 2ft   6013291.13873 2113684.88595 37.7845236126199 -122.39772589056 (37.7845236126199, -122.39772589056) 6 2 9 28856 6
5290 89193 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
5638 89169 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
38386 89162 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2008 12:00:00 AM   3x3 Permit Number 51807 6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
91046 89190 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
100555 89164 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2008 12:00:00 AM   3x3 Permit Number 51807 6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
109890 89170 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
124343 89194 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
131765 89188 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
139876 89172 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
143967 89185 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
152829 89184 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
155829 89192 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 9 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2008 12:00:00 AM   3x3 Permit Number 51807 6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
166081 89187 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
169387 89171 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
176468 89189 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
184577 89191 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
10033 80634 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 577 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6013018.0309 2104352.7115 37.7588843520526 -122.398015861652 (37.7588843520526, -122.398015861652) 10 3 8 28856 29
179747 193343 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 698 Arkansas St 1 : Tree Private 2     4 Width 3ft   6012989.11402 2103849.31958 37.7575005373464 -122.398080555283 (37.7575005373464, -122.398080555283) 10 3 8 28856 29
67350 56947 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 690 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1974 12:00:00 AM 5   Permit Number 14199 6012986.78866 2103864.51855 37.7575421408828 -122.398089663624 (37.7575421408828, -122.398089663624) 10 3 8 28856 29
114696 193341 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1751 22nd St 6 Side Yard : Yard Tree Private 2     2 Width 4ft   6012847.48484 2103764.38864 37.7572594461781 -122.398564409431 (37.7572594461781, -122.398564409431) 10 3 8 28856 29
190220 96333 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 11 Robblee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2011 12:00:00 AM 3 3x3 Permit Number 767342 6012676.77436 2095976.0416 37.7358647977189 -122.398608271155 (37.7358647977189, -122.398608271155) 10 3 8 58 1
87006 113267 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 83 Exeter St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/2015 12:00:00 AM 2   Permit Number 774551 6012507.04437 2090789.37208 37.7216138123142 -122.398831200496 (37.7216138123142, -122.398831200496) 10 3 8 58 1
86141 88503 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 7 Wheat St   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51441 6012178 2091435 37.7233682355202 -122.400013942822 (37.7233682355202, -122.400013942822) 10 3 8 58 1
16524 84225 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1361 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50686 6011917.47723073 2088615.29524593 37.7156113688947 -122.400716532679 (37.7156113688947, -122.400716532679) 10 7 8 309 39
45858 88076 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 674 Thornton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2008 12:00:00 AM 5 3x3 Permit Number 51071 6011923.03733 2094336.64392 37.7313213328046 -122.401099095547 (37.7313213328046, -122.401099095547) 10 3 8 58 1
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
16696 195151 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1912 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   6012043 2105629 37.7623344042956 -122.401477690357 (37.7623344042956, -122.401477690357) 8 3 8 28856 29
180648 57578 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1916 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/23/1976 12:00:00 AM 20 3x3 Permit Number 16445 6012032 2105628 37.7623310447467 -122.401515665193 (37.7623310447467, -122.401515665193) 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
163344 115976 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011653.53869 2091254.58415 37.7228435956385 -122.401814242757 (37.7228435956385, -122.401814242757) 10 3 7 309 28
166371 31608 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 5 Lucerne St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/06/1995 12:00:00 AM 4   Permit Number 35133 6012020.8525 2109827.45516 37.7738611793697 -122.401849428724 (37.7738611793697, -122.401849428724) 14 2 9 28853 34
188951 115977 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011639.0005 2091249.90123 37.7228299259539 -122.40186416949 (37.7228299259539, -122.40186416949) 10 3 7 309 28
158751 115978 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011623.9012 2091244.95295 37.7228154963084 -122.40191601721 (37.7228154963084, -122.40191601721) 10 3 7 309 28
156122 115979 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011610.19593 2091240.25279 37.7228018257296 -122.401963063449 (37.7228018257296, -122.401963063449) 10 3 7 309 28
55630 95830 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 5 Lucerne St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/29/2011 12:00:00 AM   3x3 Permit Number 767564 6011975 2109856 37.7739369979495 -122.402010048031 (37.7739369979495, -122.402010048031) 14 2 9 28853 34
13984 115980 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 5 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011593.71434 2091235.60939 37.7227881560287 -122.402019710862 (37.7227881560287, -122.402019710862) 10 3 7 309 28
155635 61318 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1419 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/02/2014 12:00:00 AM 1   Permit Number 772899 6011764.55732 2101642.9103 37.7513739409742 -122.402160470048 (37.7513739409742, -122.402160470048) 10 3 8 28856 29
108983 131005 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1109 Sansome St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6011966.28047 2119507.31076 37.8004367394276 -122.40271908303 (37.8004367394276, -122.40271908303) 3 1 10 308 23
112413 131004 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1109 Sansome St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6011962.57681 2119524.82057 37.8004846103385 -122.402733131341 (37.8004846103385, -122.402733131341) 3 1 10 308 23
54419 131003 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1109 Sansome St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6011959.67514 2119544.33527 37.8005380309676 -122.402744545519 (37.8005380309676, -122.402744545519) 3 1 10 308 23
12009 162257 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 778 Girard St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4x5   6011373.11147 2091245.9028 37.7228041046152 -122.402783015826 (37.7228041046152, -122.402783015826) 10 3 7 309 28
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
174738 202868 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 721 Kansas St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2018 12:00:00 AM 0 Width 3ft   6011581.65303 2104944.91806 37.7604303154251 -122.403025207773 (37.7604303154251, -122.403025207773) 10 3 8 28856 29
3356 74692 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 200 Green St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6011876.44918 2119465.43765 37.8003167500634 -122.403026990216 (37.8003167500634, -122.403026990216) 3 1 10 308 23
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
126713 53079 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600 Kansas St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/11/2017 12:00:00 AM 3 3x3 Permit Number 780021 6011490.70702 2105522.94409 37.7620123668039 -122.4033804148 (37.7620123668039, -122.4033804148) 10 3 8 28856 29
86635 32310 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/11/2017 12:00:00 AM 3 3x3 Permit Number 780021 6011490.21346 2105535.41825 37.7620465904907 -122.403382999439 (37.7620465904907, -122.403382999439) 10 3 8 28856 29
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
168316 193322 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2111 18th St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6011436.66428 2105551.33646 37.7620873073181 -122.403569326371 (37.7620873073181, -122.403569326371) 10 3 8 28856 29
150870 193321 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2111 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6011418.14714 2105550.13938 37.7620829860523 -122.403633286154 (37.7620829860523, -122.403633286154) 10 3 8 28856 29
155874 193320 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2111 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6011400.26798 2105549.24377 37.7620795281598 -122.403695060604 (37.7620795281598, -122.403695060604) 10 3 8 28856 29
173358 193319 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2111 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6011383.02095 2105548.33564 37.7620760711709 -122.403754647862 (37.7620760711709, -122.403754647862) 10 3 8 28856 29
131019 114688 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 231 Dwight St 1 Front Yard : Cutout Tree Private 2   12/01/2015 12:00:00 AM     Permit Number 774702 6010865.8 2091429.3 37.7232793364177 -122.404549596707 (37.7232793364177, -122.404549596707) 10 3 7 309 28
93475 249954 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 303 Filbert St 1 Side Yard : Yard Tree Private 2     3 Width 0ft   6011374.5207 2120037.63727 37.8018598293151 -122.404804177386 (37.8018598293151, -122.404804177386) 3 1 10 308 23
96748 249953 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 303 Filbert St 2 Side Yard : Yard Tree Private 2     4 Width 0ft   6011372.65237 2120041.55492 37.8018704817969 -122.404810918689 (37.8018704817969, -122.404810918689) 3 1 10 308 23
74008 249952 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 303 Filbert St 3 Side Yard : Yard Tree Private 2     2 Width 0ft   6011371.46837 2120040.8031 37.8018683513038 -122.404814962944 (37.8018683513038, -122.404814962944) 3 1 10 308 23
97084 250221 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 312 Filbert St 2 Side Yard : Yard Tree Private 2     8 Width 0ft   6011282.00764 2120080.85256 37.8019733165766 -122.405127362244 (37.8019733165766, -122.405127362244) 3 1 10 308 23
9101 149740 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600 San Bruno Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     0 5x5   6010932.22924 2105459.16725 37.7618060416252 -122.405307491047 (37.7618060416252, -122.405307491047) 10 3 8 28856 29
11103 149739 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   6010931.02944 2105481.85704 37.7618682756098 -122.405313238612 (37.7618682756098, -122.405313238612) 10 3 8 28856 29
12319 149738 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   6010928.54307 2105503.65431 37.7619279870025 -122.405323373095 (37.7619279870025, -122.405323373095) 10 3 8 28856 29
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
39488 177445 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 15 Karen Ct 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6010506.33995 2091553.32971 37.7235998004623 -122.405800920297 (37.7235998004623, -122.405800920297) 10 3 7 309 28
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
58994 114753 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 10 Karen Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/2015 12:00:00 AM 1   Permit Number 777133 6010495.97692 2091580.43732 37.7236736527876 -122.405838652231 (37.7236736527876, -122.405838652231) 10 3 7 309 28
104830 177444 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 15 Karen Ct 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6010486.61044 2091547.46792 37.7235826018289 -122.40586870937 (37.7235826018289, -122.40586870937) 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
53411 114722 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 465 Woolsey St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM     Permit Number 774759 6010466.6 2091788 37.7242419338513 -122.405954818575 (37.7242419338513, -122.405954818575) 10 3 7 309 28
80677 114721 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 465 Woolsey St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM     Permit Number 774759 6010466.6 2091788 37.7242419338513 -122.405954818575 (37.7242419338513, -122.405954818575) 10 3 7 309 28
174661 114720 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 465 Woolsey St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM     Permit Number 774759 6010466.6 2091788 37.7242419338513 -122.405954818575 (37.7242419338513, -122.405954818575) 10 3 7 309 28
26931 37803 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 465 Woolsey St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/02/2015 12:00:00 AM     Permit Number 774759 6010402.90992445 2091781.87036726 37.7242215408534 -122.406174555323 (37.7242215408534, -122.406174555323) 10 3 7 309 28
92349 177443 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 63 Karen Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6010306.59987 2091507.00491 37.7234614298874 -122.406488127328 (37.7234614298874, -122.406488127328) 10 3 7 309 28
157732 114754 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 83 Karen Ct   Sidewalk: Curb side : Cutout Tree Private 2   12/04/2015 12:00:00 AM     Permit Number 777134 6010271.6 2091687.4 37.7239547991887 -122.406621822462 (37.7239547991887, -122.406621822462) 10 3 7 309 28
189282 177442 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 67 Karen Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6010267.21749 2091493.90642 37.7234232608607 -122.406623343098 (37.7234232608607, -122.406623343098) 10 3 7 309 28
40320 177441 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 71 Karen Ct 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6010258.66598 2091491.87018 37.7234171913236 -122.406652760812 (37.7234171913236, -122.406652760812) 10 3 7 309 28
103818 177440 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 71 Karen Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6010238.57006 2091486.20011 37.7234004981218 -122.406721829644 (37.7234004981218, -122.406721829644) 10 3 7 309 28
76227 18413 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 799X Potrero Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1   03/05/2013 12:00:00 AM 3 4X4   6010481.3464666 2104567.7087473 37.7593330783471 -122.406804093165 (37.7593330783471, -122.406804093165) 10 4 8 28859 19
157993 177434 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 131 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2018 12:00:00 AM 3 3x3 Permit Number 781326 6010258.4147 2094004.87757 37.7303173692474 -122.406830655731 (37.7303173692474, -122.406830655731) 10 3 7 309 28
186074 177439 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 79 Karen Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6010188.86492 2091471.00105 37.7233559834822 -122.406892581232 (37.7233559834822, -122.406892581232) 10 3 7 309 28
154917 26561 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 430 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/10/2007 12:00:00 AM 3 3X3   6010306.7503709 2097855.6706051 37.7408935295991 -122.406934857164 (37.7408935295991, -122.406934857164) 10 3 7 58 2
139230 177438 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 83 Karen Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6010165.7616 2091462.99776 37.7233327153139 -122.406971881647 (37.7233327153139, -122.406971881647) 10 3 7 309 28
129691 114755 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 89 Karen Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/2015 12:00:00 AM 1   Permit Number 777135 6010155.72688 2091460.80739 37.7233261394813 -122.407006415641 (37.7233261394813, -122.407006415641) 10 3 7 309 28
151875 177437 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 93 Karen Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6010115.68283 2091447.62238 37.7232876952637 -122.407143912081 (37.7232876952637, -122.407143912081) 10 3 7 309 28

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