trees

979 rows where qSpecies_id = 13 sorted by SiteOrder

✎ 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)
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
4879 260889 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 527 45th Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/18/2019 12:00:00 AM 3     5981905.91133 2112171.65096 37.7785709887537 -122.506193994794 (37.7785709887537, -122.506193994794) 11 6 2 55 26
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
6875 260888 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 528 45th Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/18/2019 12:00:00 AM 3     5981946.38688 2112159.7169 37.7785406040131 -122.50605309173 (37.7785406040131, -122.50605309173) 11 6 2 55 26
9277 85291 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 7350 Geary Blvd   Sidewalk: Curb side : Cutout Tree Private 2   07/24/2007 12:00:00 AM 2 4x72 Permit Number 49578 5984127.30348 2112512.4695 37.779637298343 -122.498534651264 (37.779637298343, -122.498534651264) 11 6 2 55 26
9454 260881 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 751 33rd Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/18/2019 12:00:00 AM 3     5985678.2622 2110774.56948 37.7749563544765 -122.493041236092 (37.7749563544765, -122.493041236092) 11 6 2 55 26
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
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
15796 260912 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 99x Belvedere St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/21/2019 12:00:00 AM 3                        
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
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
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
24293 94928 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 929#4 Broderick St   Sidewalk: Curb side : Landscaping Private 2   12/08/2010 12:00:00 AM 3 26x6 Permit Number 54775 6000937 2111843 37.7787705583514 -122.440334763546 (37.7787705583514, -122.440334763546) 15 5 11 29490 41
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
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
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
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
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
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
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
64837 253415 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 55 Stoneybrook Ave   Front Yard : Cutout Tree Private 2   08/31/2017 12:00:00 AM 3   Permit Number 779907 6005926.97731 2093972.42686 37.7299849530428 -122.421802746417 (37.7299849530428, -122.421802746417) 9 7 6 28861 5
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
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
70116 88597 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Jordan Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/31/2008 12:00:00 AM   3x3 Permit Number 51542 5996162.8 2114014.5 37.7844599367093 -122.457007600103 (37.7844599367093, -122.457007600103) 11 6 1 54 31
76532 88382 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 355 17th Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM 2 3x3 Permit Number 51360 5990561.77007 2113010.94096 37.7813812065074 -122.476311706446 (37.7813812065074, -122.476311706446) 11 6 2 55 26
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
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
87081 89047 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 4552 19th St   Sidewalk: Curb side : Cutout Tree Private 2   10/06/2008 12:00:00 AM   3x3 Permit Number 51787 6000860 2104654 37.7590269716409 -122.440085499527 (37.7590269716409, -122.440085499527) 2 4 5 28862 3
89811 87785 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
92704 88376 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 563 14th Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51354 5991545.8 2111599.6 37.7775630683787 -122.472804534873 (37.7775630683787, -122.472804534873) 11 6 2 54 26
96870 87781 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 270 Delano Ave   Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50517 5999921.6 2092148.7 37.7246369273224 -122.442433121703 (37.7246369273224, -122.442433121703) 9 7 6 28861 25
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
98601 88326 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 559 Lisbon St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51315 6001911 2090236 37.7194982755804 -122.435419269027 (37.7194982755804, -122.435419269027) 9 7 6 28861 5
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
109882 88306 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 575 Athens St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51300 6003350 2089985 37.718890705147 -122.430427275663 (37.718890705147, -122.430427275663) 9 7 6 28861 5
111497 87238 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 313 04th Ave   Sidewalk: Curb side : Cutout Tree Private 2   02/14/2008 12:00:00 AM   3x3 Permit Number 50268 5994594.9 2113356.1 37.7825619851863 -122.462384185128 (37.7825619851863, -122.462384185128) 11 6 2 54 11
112469 88269 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1175 Stanyan St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51255 5997354 2106147 37.7629261534889 -122.452318574624 (37.7629261534889, -122.452318574624) 15 5 11 29492 12
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
114311 88268 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1158 Stanyan St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51254 5997417.6 2106243.4 37.7631944867864 -122.452105561067 (37.7631944867864, -122.452105561067) 15 5 11 29492 9
119526 88650 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 400 Haight St   Sidewalk: Curb side : Cutout Tree Private 2   08/05/2008 12:00:00 AM   3x3 Permit Number 51631 6004213 2109445 37.7723722193741 -122.428830794856 (37.7723722193741, -122.428830794856) 7 9 11 29492 10
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
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
135376 88424 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1465 Washington St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51388 6007689 2117147 37.7937161726159 -122.417352866644 (37.7937161726159, -122.417352866644) 5 1 10 28858 32
139488 88514 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 640 Faxon Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51446 5994921.4 2092497.3 37.7253078255283 -122.459743296133 (37.7253078255283, -122.459743296133) 9 7 4 28861 40
142885 87269 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 4109 Irving St   Sidewalk: Curb side : Cutout Tree Private 2   03/07/2008 12:00:00 AM   3x3 Permit Number 50292 5983031 2106268 37.7624274331393 -122.50186502168 (37.7624274331393, -122.50186502168) 1 8 3 56 35
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
151486 88332 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 659 Madrid St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51320 6002140 2090092 37.7191158866353 -122.434617409737 (37.7191158866353, -122.434617409737) 9 7 6 28861 5
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
157236 87786 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
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
164923 87787 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
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
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
17 164866 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 719 Faxon Ave 1 Sidewalk: Property side : Yard Tree Private 2   11/16/2020 12:00:00 AM 3 4x6 Permit Number 782492 5994853.78052 2092811.30491 37.7261661184654 -122.459999785581 (37.7261661184654, -122.459999785581) 9 7 4 28861 40
37 264963 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 275 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2020 12:00:00 AM 3 3x3   6005706 2110306 37.7748207071365 -122.423727591769 (37.7748207071365, -122.423727591769) 7 9 11 28852 10
558 230313 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 968 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6010194.52879 2103588.60829 37.7566286356186 -122.407727015404 (37.7566286356186, -122.407727015404) 2 4 7 28859 19
741 262415 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 122 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6003235 2094463 37.731179778599 -122.431144235496 (37.731179778599, -122.431144235496) 9 7 5 28861 25
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
821 261708 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 20 Entrada Ct 1 Front Yard : Yard Tree Private 2   02/21/2020 12:00:00 AM 3 3x3 Permit Number 783258 5992481.8221 2092418.55282 37.724951011222 -122.468170882637 (37.724951011222, -122.468170882637) 9 8 4 59 40
895 56729 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1547 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/26/2012 12:00:00 AM 5   Permit Number 769649 6015653.0224 2095684.4557 37.7352295280363 -122.388297771341 (37.7352295280363, -122.388297771341) 10 3 8 58 1
1002 260458 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 835 Darien Way 1 Sidewalk: Property side : Yard Tree Private 2   11/19/2019 12:00:00 AM 3 6x10 Permit Number 784514 5994066 2094094 37.7296427463027 -122.462816092129 (37.7296427463027, -122.462816092129) 9 8 4 59 40
1059 262280 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 10 Niantic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784434 5992391 2086794 37.7095021076955 -122.468075893068 (37.7095021076955, -122.468075893068) 9 8 4 64 24
1439 72311 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3769 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5996250.37824 2115874.50597 37.7895720432509 -122.456839183887 (37.7895720432509, -122.456839183887) 11 6 1 54 31
1513 146932 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 619 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2020 12:30:00 PM 0 Width 3ft   5982546.66357 2111553.12275 37.7769103910512 -122.503931600958 (37.7769103910512, -122.503931600958) 11 6 2 55 26
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
2106 193374 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 778 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6008975.96564 2110229.86919 37.7747957152898 -122.412410677425 (37.7747957152898, -122.412410677425) 8 2 9 28853 34
2285 95676 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 232 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM 3 3x3 Permit Number 767428 6010063.65694 2093465.10714 37.7288243741431 -122.407465923318 (37.7288243741431, -122.407465923318) 10 3 7 309 28
2308 144457 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 566 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/13/2019 12:00:00 AM 3 4x6   5987536.08738 2112106.24218 37.7787212290426 -122.486712509289 (37.7787212290426, -122.486712509289) 11 6 2 55 26
2501 78191 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 680 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6015407.71241 2105894.14692 37.7632496064147 -122.389858829046 (37.7632496064147, -122.389858829046) 14 3 8 28856 29
2571 219957 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3933 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003591.26694 2101840.52548 37.7514569483989 -122.430438748853 (37.7514569483989, -122.430438748853) 2 4 5 28862 22
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
3837 255657 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1421 Fulton St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/22/2018 12:00:00 AM 3     6000959.70168 2111031.39919 37.7765434007218 -122.44019801367 (37.7765434007218, -122.44019801367) 15 5 11 29492 10
4347 174997 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 61 Curtis St 1 Sidewalk: Curb side : Yard Tree Private 2   10/23/2020 12:00:00 AM 3 Width 4ft   6000632.91251 2088182.32659 37.7137866806885 -122.43968998482 (37.7137866806885, -122.43968998482) 9 7 6 28861 5
4490 224675 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 121 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6007745.9196 2107233.93005 37.7665004685576 -122.4164534151 (37.7665004685576, -122.4164534151) 8 4 7 28853 19
4564 264686 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2455 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/15/2020 12:00:00 AM 3 3x3 Permit Number 782284 5990129.23032 2098669.31502 37.7419778589065 -122.476759924113 (37.7419778589065, -122.476759924113) 1 8 3 29491 35
4664 171655 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 101 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x5   6007664.95872 2093252.16101 37.7281051161408 -122.415743336498 (37.7281051161408, -122.415743336498) 9 3 7 309 5
4723 259742 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 259 Page St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/11/2019 12:00:00 AM 3     6005340.35583 2109906.90312 37.7737042366543 -122.424964031136 (37.7737042366543, -122.424964031136) 7 9 11 28852 10
4724 262586 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2 Byron Ct 1 Front Yard : Yard Tree Private 2   08/19/2020 12:00:00 AM 3 8x8 Permit Number 781313 5999459.72778 2086749.57445 37.7097858201455 -122.443642066205 (37.7097858201455, -122.443642066205) 9 7 6 28861 5
4773 165865 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 275 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 3x4   6006836.83511 2097542.23848 37.7398381374333 -122.418910337746 (37.7398381374333, -122.418910337746) 2 7 7 28859 2
4904 144219 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 876 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3 Width 4ft   5982678 2109818 37.7721539708604 -122.503348768347 (37.7721539708604, -122.503348768347) 11 6 2 55 26
5106 147909 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 69 Almaden Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   5995874.31253 2112332.21787 37.7798242673223 -122.45788388223 (37.7798242673223, -122.45788388223) 11 6 2 54 16
5226 259803 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 199x Harkness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
5292 241594 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 687 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007646.0169 2096174.81068 37.7361290122323 -122.416015706955 (37.7361290122323, -122.416015706955) 2 7 7 28859 2
5427 146424 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2131 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6000557.07663 2120624.21431 37.8028598421591 -122.442279615007 (37.8028598421591, -122.442279615007) 13 9 1 57 17
5720 80737 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 186 Allison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6000043.55254 2087718.30936 37.7124790304587 -122.44169374357 (37.7124790304587, -122.44169374357) 9 7 6 28861 5
5771 18021 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2725 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000769.3896 2114817.5231 37.7869282913907 -122.441128056615 (37.7869282913907, -122.441128056615) 13 6 1 29490 27
6056 147742 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 175 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2019 12:00:00 AM 3 Width 4ft   5993335.44452 2114350.58879 37.7852199756724 -122.466813637549 (37.7852199756724, -122.466813637549) 11 6 2 54 11
6589 44716 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1879 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/08/2020 12:00:00 AM 3   Permit Number 43838 5989679.8369 2102593.1522 37.7527256083507 -122.478600649693 (37.7527256083507, -122.478600649693) 1 8 3 56 35
6755 264922 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250 Urbano Dr 1 Sidewalk: Property side : Yard Tree Private 2   11/10/2020 12:00:00 AM 3 4x6 Permit Number 781481 5992625.08037 2092677.96132 37.7256715559054 -122.467694516591 (37.7256715559054, -122.467694516591) 9 8 4 59 40
7003 177395 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 715 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6001937.65614 2089768.77997 37.7182169074587 -122.435293726344 (37.7182169074587, -122.435293726344) 9 7 6 28861 5
7146 112795 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1235 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2015 12:00:00 AM   3x3   5983624.1 2106731.7 37.7637354441658 -122.499848016409 (37.7637354441658, -122.499848016409) 1 8 3 56 35
7285 261471 Undocumented 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1785 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005616 2107209 37.7663120077949 -122.423818660091 (37.7663120077949, -122.423818660091) 8 4 5 28853 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)
);