trees

979 rows where qSpecies_id = 13 sorted by qLegalStatus_id descending

✎ 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)
67384 112573 Section 143 10 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 56 ROCKWOOD CT 1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2015 12:00:00 AM   3x6 Permit Number 776002 5995685 2098946 37.7430582687021 -122.457569991387 (37.7430582687021, -122.457569991387) 1 8 4 59 40
144718 112574 Section 143 10 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 56 ROCKWOOD CT 2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2015 12:00:00 AM   3x6 Permit Number 776002 5995685 2098946 37.7430582687021 -122.457569991387 (37.7430582687021, -122.457569991387) 1 8 4 59 40
10378 163649 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 226 Sagamore St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW 07/01/2020 12:00:00 AM 3 3x4 Permit Number 784460 5994737.04022 2087470.63166 37.71149518743 -122.460016622663 (37.71149518743, -122.460016622663) 9 8 6 28861 24
12863 154063 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1781 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 4x3 Permit Number 782693 6014599.10763 2096821.84485 37.7382941111836 -122.392021081628 (37.7382941111836, -122.392021081628) 10 3 8 58 1
64208 71505 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 328 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774557 6006691.32680411 2104197.11487977 37.7581027211657 -122.419885554796 (37.7581027211657, -122.419885554796) 2 4 7 28859 19
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
171901 82180 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 105 Lake St 1 Front Yard : Cutout Tree Private 2 FUF     3x3 Permit Number 773769 5995179.68463591 2114884.08050195 37.7867910649613 -122.460471849521 (37.7867910649613, -122.460471849521) 11 6 1 54 11
194402 265049 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1595 Oak St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 5x5   5999367.57953 2109424.62482 37.7720408355473 -122.445590032014 (37.7720408355473, -122.445590032014) 15 5 11 29492 9
30764 97025 Property Tree 8 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
743 236478 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 222 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/14/2020 12:00:00 AM 3 3x3 Permit Number 785288 6007898.7538 2097586.28669 37.7400188220044 -122.415241775611 (37.7400188220044, -122.415241775611) 2 7 7 28859 2
1556 158441 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 49 Van Buren St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2020 12:00:00 AM 3 3x3 Permit Number 785489 6002069.34164 2096386.56921 37.7363953338756 -122.435311658815 (37.7363953338756, -122.435311658815) 2 7 5 63 7
1859 243453 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 73 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW 04/01/2016 12:00:00 AM 0 4x6 Permit Number 777687 6007416.81803 2098970.61704 37.7437927883108 -122.417006175297 (37.7437927883108, -122.417006175297) 2 7 7 28859 2
1903 220552 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 13 Ohlone Way 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3 Permit Number 785489 6002169.64489 2096371.31931 37.7363591568587 -122.434963778568 (37.7363591568587, -122.434963778568) 2 7 5 63 7
2708 50426 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250 Howth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/12/2014 12:00:00 AM 3   Permit Number 773627 5997303.25557645 2090612.9654569 37.7202705700793 -122.45137364778 (37.7202705700793, -122.45137364778) 9 8 6 28861 24
2825 92602 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2201 Baker St 11 Sidewalk: Property side : Cutout Tree Private 2   08/25/2009 12:00:00 AM   3x3 Permit Number 52915 5999814 2116396 37.7912079107295 -122.444546965455 (37.7912079107295, -122.444546965455) 13 6 1 29490 27
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
4377 88323 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 125 Lisbon St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51312 6003417 2092629 37.7261543381556 -122.430384225952 (37.7261543381556, -122.430384225952) 9 7 6 28861 5
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
8586 50836 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 202 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2004 12:00:00 AM     Permit Number 47354 5994277.69303186 2105335.48637483 37.7605212305047 -122.462899497742 (37.7605212305047, -122.462899497742) 1 5 11 56 12
9598 99292 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1300 Minnesota St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2012 12:00:00 AM   3x3 Permit Number 768897 6015320.4 2102511.6 37.753957014382 -122.389924521932 (37.753957014382, -122.389924521932) 10 3 8 28856 29
9933 264897 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 405 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/02/2020 12:00:00 AM 3 3x3 Permit Number 772749 6002446.89331 2091087.07144 37.7218655485653 -122.433627676211 (37.7218655485653, -122.433627676211) 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
10144 97101 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1096@Jones Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008668 2115966 37.7905284677514 -122.413881848265 (37.7905284677514, -122.413881848265) 5 1 10 28857 21
10565 65035 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1205 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/08/2008 12:00:00 AM   3x3 Permit Number 51820 6003879.11104946 2101261.18670708 37.7498825208731 -122.429402039878 (37.7498825208731, -122.429402039878) 2 4 5 28862 22
11108 86883 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 550 Jersey St   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49808 6001589 2101474 37.750336931821 -122.43733657342 (37.750336931821, -122.43733657342) 2 4 5 28862 22
11319 255592 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 199X San Carlos St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2019 12:00:00 AM 3 3x3 Permit Number 784421 6006714 2105007 37.7603277549802 -122.419864609266 (37.7603277549802, -122.419864609266) 2 4 7 28859 19
12333 95563 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 497 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6003239 2102086.6 37.7521126499553 -122.431674496468 (37.7521126499553, -122.431674496468) 2 4 5 28862 22
14489 255590 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 199X San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2019 12:00:00 AM 3 3x3 Permit Number 784421 6006714 2105007 37.7603277549802 -122.419864609266 (37.7603277549802, -122.419864609266) 2 4 7 28859 19
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
16680 256664 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1381 Filbert St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/2018 12:00:00 AM 3 5x5 Permit Number 782595 6006338.70929 2119347.35531 37.7996817310416 -122.422181395696 (37.7996817310416, -122.422181395696) 13 9 1 28858 32
17107 82354 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 254 Dublin St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2008 12:00:00 AM   3x3 Permit Number 50649 6004015.90676212 2089097.25184538 37.7164908413301 -122.428062269463 (37.7164908413301, -122.428062269463) 9 7 6 28861 5
17760 158440 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 49 Van Buren St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2020 12:00:00 AM 3 3x3 Permit Number 785489 6002067.69843 2096375.7626 37.7363655681024 -122.435316567307 (37.7363655681024, -122.435316567307) 2 7 5 63 7
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
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
21342 88261 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 229 Douglass St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51248 6001199 2104918 37.7597711445886 -122.438931999231 (37.7597711445886, -122.438931999231) 2 4 5 28862 3
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
22457 93624 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 149 Collins St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2010 12:00:00 AM     Permit Number 53164 5998064 2113562 37.783326485193 -122.450397500912 (37.783326485193, -122.450397500912) 15 6 1 54 31
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
23388 256663 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1381 Filbert St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/2018 12:00:00 AM 3 3x3 Permit Number 782595 6006338.70929 2119347.35531 37.7996817310416 -122.422181395696 (37.7996817310416, -122.422181395696) 13 9 1 28858 32
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
25966 95564 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 497 Elizabeth St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767357 6003239 2102086.6 37.7521126499553 -122.431674496468 (37.7521126499553, -122.431674496468) 2 4 5 28862 22
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
27335 50837 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 202 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2004 12:00:00 AM     Permit Number 47354 5994277.69303186 2105335.48637483 37.7605212305047 -122.462899497742 (37.7605212305047, -122.462899497742) 1 5 11 56 12
27502 92600 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2201 Baker St 9 Sidewalk: Property side : Cutout Tree Private 2   08/25/2009 12:00:00 AM   3x3 Permit Number 52915 5999814 2116396 37.7912079107295 -122.444546965455 (37.7912079107295, -122.444546965455) 13 6 1 29490 27
28421 95734 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 626 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767481 6002384.8 2090170.7 37.7193458734928 -122.433776853042 (37.7193458734928, -122.433776853042) 9 7 6 28861 5
28513 37585 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 210 Eagle St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40016 5999628.99810136 2104552.86123042 37.7586791121732 -122.444335603116 (37.7586791121732, -122.444335603116) 2 4 5 28862 3
29687 88259 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1460 Clayton St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51244 5999422 2104472 37.758445274906 -122.445045681381 (37.758445274906, -122.445045681381) 2 5 5 28862 3
29701 88320 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 645 France Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51311 6002646.5 2089495.7 37.7175073196157 -122.432824059512 (37.7175073196157, -122.432824059512) 9 7 6 28861 5
30146 87902 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 223 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50920 6007150.2 2097674.7 37.7402194874954 -122.417836238094 (37.7402194874954, -122.417836238094) 2 7 7 28859 2
32930 83189 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1670 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53556 5992811.58181355 2104100.90541778 37.7570468381941 -122.467880263564 (37.7570468381941, -122.467880263564) 1 8 4 56 12
34346 99307 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 59 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2016 12:00:00 AM 3 3x3 Permit Number 777839 6006944.8 2099028.3 37.7439246092205 -122.418642395457 (37.7439246092205, -122.418642395457) 2 7 7 28859 2
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
35091 95932 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 218 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2011 12:00:00 AM 3 3x3 Permit Number 767629 5987170.3 2114494.3 37.7852568239907 -122.488153421892 (37.7852568239907, -122.488153421892) 11 6 1 55 33
36556 88319 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 631 France Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51310 6002604.8 2089521.8 37.7175766192591 -122.432970060785 (37.7175766192591, -122.432970060785) 9 7 6 28861 5
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
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
38498 88312 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 518 Athens St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51303 6003514 2090320 37.7198198301278 -122.429884275062 (37.7198198301278, -122.429884275062) 9 7 6 28861 5
40470 87788 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 114 Theresa St   Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50526 6002199.1 2093679.9 37.7289708079503 -122.434669544642 (37.7289708079503, -122.434669544642) 9 7 6 28861 25
41309 109735 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 4638 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2015 12:00:00 AM 3 3x3 Permit Number 773846 6000314.1 2105235.6 37.760592809236 -122.442015220342 (37.760592809236, -122.442015220342) 15 4 5 28862 3
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
45035 88479 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1751 Newcomb Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM 3 3x3 Permit Number 51431 6014386 2096253.8 37.7367225430205 -122.392718181551 (37.7367225430205, -122.392718181551) 10 3 8 58 1
46100 83398 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 4244X 19th St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5   06/12/2008 12:00:00 AM 3 3x3 Permit Number 50813 6001912 2104709 37.7592378221466 -122.436451128899 (37.7592378221466, -122.436451128899) 2 4 5 28862 3
46621 88242 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2501 Turk Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51228 5998431.6 2111697.4 37.7782278105943 -122.448991394173 (37.7782278105943, -122.448991394173) 15 6 2 54 16
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
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
47664 109389 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 174X Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/2015 12:00:00 AM 3 3x3 Permit Number 774921 6006834.59164 2098690.08898 37.7429897522087 -122.418999487845 (37.7429897522087, -122.418999487845) 2 7 7 28859 2
48245 96117 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 201 Andover St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2011 12:00:00 AM   3x3 Permit Number 767772 6007577 2097739 37.7404200508617 -122.416365084697 (37.7404200508617, -122.416365084697) 2 7 7 28859 2
48829 63744 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 690 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/2014 12:00:00 AM 3 3x3 Permit Number 773423 6003267.19349485 2109664.80045569 37.772922159977 -122.432118125319 (37.772922159977, -122.432118125319) 15 9 11 29492 10
48862 87126 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 438 33rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2008 12:00:00 AM   3x3 Permit Number 50074 5985668.2 2112929.7 37.7808731376826 -122.493234847229 (37.7808731376826, -122.493234847229) 11 6 2 55 26
49147 95703 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 497 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767357 6003239 2102086.6 37.7521126499553 -122.431674496468 (37.7521126499553, -122.431674496468) 2 4 5 28862 22
49485 95113 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 887 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2010 12:00:00 AM   3x3 Permit Number 54041 6001057 2091844.3 37.7238657652599 -122.438486397461 (37.7238657652599, -122.438486397461) 9 7 6 28861 25
51683 87914 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 101 Wool St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50936 6007398 2097753 37.7404484242714 -122.41698498961 (37.7404484242714, -122.41698498961) 2 7 7 28859 2
52039 250725 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2715 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3 Width 4ft Permit Number 782755 5987015.16529 2114429.97132 37.7850711441675 -122.488685403333 (37.7850711441675, -122.488685403333) 11 6 1 55 33
52836 88007 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1394 Masonic Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/2010 12:00:00 AM   3x3 Permit Number 53732 5999618.7 2107794 37.7675778847064 -122.444604170057 (37.7675778847064, -122.444604170057) 15 5 11 29492 9
53186 109760 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3590 20TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM   3x3 Permit Number 772584 6006354 2104372 37.7585639052988 -122.421064595152 (37.7585639052988, -122.421064595152) 2 4 7 28859 19
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
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
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
56595 5717 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1647 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/14/2008 12:00:00 AM 3 3X3   6005332.0180626 2098744.9227684 37.7430555871926 -122.424198880257 (37.7430555871926, -122.424198880257) 2 7 5 28859 22
56875 82146 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1083 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2008 12:00:00 AM   3x3 Permit Number 51167 5995391.16373818 2098013.23554983 37.7404802453018 -122.458518484651 (37.7404802453018, -122.458518484651) 9 7 4 59 40
57331 115763 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 37 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 771927 6005378.2 2095966 37.7354278990147 -122.423841638688 (37.7354278990147, -122.423841638688) 2 7 7 28859 2
57445 94819 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1551 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53898 5993027.2 2104915.2 37.7592951275131 -122.467193784759 (37.7592951275131, -122.467193784759) 1 8 4 56 12
57946 88834 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 156 Collins St   Sidewalk: Curb side : Cutout Tree Private 2   09/11/2008 12:00:00 AM   3x3 Permit Number 51716 5998112 2113497 37.7831507592552 -122.450226753873 (37.7831507592552, -122.450226753873) 15 6 1 54 31
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
58995 87898 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 700 Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50917 6007438 2097723.6 37.7403699483878 -122.416844602518 (37.7403699483878, -122.416844602518) 2 7 7 28859 2
59519 95549 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1712 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767351 6002582 2100598 37.7479880436154 -122.433840109923 (37.7479880436154, -122.433840109923) 2 4 5 63 22
60421 112587 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 790 Tehama St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008900 2110136 37.7745337092857 -122.412666821872 (37.7745337092857, -122.412666821872) 8 2 9 28853 34
62045 49067 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1298 Ocean Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50555 5995836.31315767 2092013.47244835 37.7240319217297 -122.45654557668 (37.7240319217297, -122.45654557668) 9 8 4 28861 40
62070 115256 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 277 Granada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM     Permit Number 773180 5995612.8 2091840.6 37.7235444201772 -122.457305721784 (37.7235444201772, -122.457305721784) 9 8 4 28861 24
62564 87900 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 700 Eugenia Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50917 6007438 2097723.6 37.7403699483878 -122.416844602518 (37.7403699483878, -122.416844602518) 2 7 7 28859 2
63096 39742 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 4248 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM   3x3 Permit Number 50468 6002277.29168205 2104153.16512299 37.7577323837885 -122.435148020003 (37.7577323837885, -122.435148020003) 2 4 5 28862 3
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
63821 94705 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 682 12th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/28/2010 12:00:00 AM   3x3 Permit Number 53845 5992291.3 2110837.3 37.7755131276945 -122.470170100471 (37.7755131276945, -122.470170100471) 11 6 2 54 11
64603 236697 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 38 Fountain St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/14/2018 12:00:00 AM 3 3x3 Permit Number 781747 6000330.16307 2101460.4358 37.7502280437052 -122.441688731669 (37.7502280437052, -122.441688731669) 2 4 5 28862 22
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
65376 88526 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1680 McAllister St   Sidewalk: Curb side : Cutout Tree Private 2   10/08/2008 12:00:00 AM   3x3 Permit Number 51817 6001106 2111441 37.7776763890724 -122.439721299373 (37.7776763890724, -122.439721299373) 15 5 11 29490 41
66254 51656 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 949 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM   3x3 Permit Number 50463 6003796.70592748 2102740.00151399 37.7539383334149 -122.42979246605 (37.7539383334149, -122.42979246605) 2 4 5 28862 22
66397 84634 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 361 Nevada St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50931 6008966.27725874 2096629.00783692 37.7374502806236 -122.411483091014 (37.7374502806236, -122.411483091014) 10 7 7 28859 2
67330 96066 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 957 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2011 12:00:00 AM   3x3 Permit Number 767691 6008013 2102358 37.7531273009994 -122.415184444517 (37.7531273009994, -122.415184444517) 2 4 7 28859 19

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